Hello,

I am almost done with this component. I just need to add some code, but I need to know where to add it.

User Collection View:

- clicks on a link that allows the user to edit 1 field.
- user enters data, clicks save.

Now I need to run some extra PHP code, but just for that form. What and where is that controller?


Second item:

I have multiple Collection layouts for the same table. So, it is something like this:

Active | Expired | Trial

What I need to do is modify the SQL select for each one so that I can display the records correctly. For example:
This is for active licenses.


Can someone point me in the right direction to make these modifications?

Thanks

I think what you need is listquery() - either that or prepareQuery()

It'll be in the controller for the collection you're working on...

Use $query->where etc to adapt the queries as required.

Sorry if a bit vague. Too tired to check ATM but can do tomorrow if this doesn't help.

Gez

Ok, what file?

Go to bed. I will look at this tomorrow as well.

Whatever the name of the controller for the layouts you're using...

Actually, you could just add a filter on the grid. Filter by the field holding expired, active etc... Then, you could even pass it in the URL if you wanted. That way, you technically have one layout...

Sure,

I'll take a look tomorrow. Btw are you using enum field or a fk for your different 'states' ( active etc)?

Gez

components/com_yourcomponent/controllers/your_controller.php or
administrator/components/ com_yourcomponent/controllers/your_controller.php

State is based on current date.

If timestamp < today it is expired.

I have an integer field for the "Trial". 1 = trial and 0 = no trial.

So to list trial licenses I just have to add:

For Active I need to add:

And for Expired:

Thanks. I will look at them tomorrow. I need to go sleep

Did you get this sorted?

models/xxxxs.php

function prepareQuery()

Sorry @admin & @jcbenton - I told you to look in the controller, not the model!!!

That was silly but, I did say it was late!

Hope you got or get it sorted