Change sort by "value DESC" to "sort=-value"

[kongondo]

Hi,

I have a situation where a sort value is being sent by GET to be processed by another PHP file in PW. The value is being sent via AJAX. The script I am using uses "value ASC" or "value DESC" as sorting parameters. For instance, the sort value could be "name DESC", (sort by name descending). The value is passed to a PW find() to grab some results and sort them according to the sent sort value. Obviously the following will not work with PW selectors:

$pages->find("template=basic-page, limit=10, sort=name DESC");// sort will not work

How can I convert the sort value coming in via AJAX ("name DESC") (without hacking the core of that script) to achieve "-name" for use in PW selectors as follows?

$pages->find("template=basic-page, limit=10, sort=-name");

Thanks.

[diogo]

If you have few variations of sort you could do it with a switch statement:

switch ($get) {
    case "name DESC":
        $sort = -name;
        break;
    case "name ASC":
        $sort = -name;
        break;
    // and so on...
}

 

If there are more variations you can automate it like this:

$sort = explode(" ", $get);

$order = $sort[1] == "DESC" ? "-" : "" ;

$value = $sort[0];

$pages->find("template=basic-page, limit=10, sort=$order$value");

[kongondo]

Diogo,

I used the second option. Works a treat! Muito obrigado!       

[diogo]

De Nada