JA Job Board Component 8,554 posts

[timmieboy Friend timmieboyJoin date: January 2013Posts: 344Downloads:0Uploads:59 Thanks: 9 Thanked: 5 times in 1 posts]

#189940

Hello

How can I make sure that the packages in de list of plans are ordered by price or title.

Thanks

---

Attachments:

1. 

[HeR0 Friend HeR0Join date: August 2011Posts: 3626Downloads:0Uploads:61 Thanks: 33 Thanked: 588 times in 549 posts]

#503245

Now it is sorted by ordering field. You could change the sort order as you wish, you need edit the query statement in the japosts.php model file.

[timmieboy Friend timmieboyJoin date: January 2013Posts: 344Downloads:0Uploads:59 Thanks: 9 Thanked: 5 times in 1 posts]

#503277

Can you be more specific, I am not a experince developer.

Thanks

[HeR0 Friend HeR0Join date: August 2011Posts: 3626Downloads:0Uploads:61 Thanks: 33 Thanked: 588 times in 549 posts]

#503566

You can change order by price as follows:

[PHP]$query = ‘SELECT s.* FROM #__ja_posting_plans AS s WHERE s.published=1 ‘.$where.’ ORDER BY `type` ASC, ordering DESC’;[/PHP]

Change to

[PHP]$query = ‘SELECT s.* FROM #__ja_posting_plans AS s WHERE s.published=1 ‘.$where.’ ORDER BY `type` ASC, price, ordering DESC’;[/PHP]

[timmieboy Friend timmieboyJoin date: January 2013Posts: 344Downloads:0Uploads:59 Thanks: 9 Thanked: 5 times in 1 posts]

#503677

Thank you works fine.

[timmieboy Friend timmieboyJoin date: January 2013Posts: 344Downloads:0Uploads:59 Thanks: 9 Thanked: 5 times in 1 posts]

#505571

Hello Hero,

Because of the update, I can’t find the lines you told me to change for different ordering. Can you tell how to order the items again.

Thanks

[HeR0 Friend HeR0Join date: August 2011Posts: 3626Downloads:0Uploads:61 Thanks: 33 Thanked: 588 times in 549 posts]

#505669

It is in the getItems function in this file componentscom_jajobboardmodelsjaposts.php

[Author]

Posts