Using many values with a Phalcon query

Question

Using many values with a Phalcon query

WaldoTH May '16

Created May '16	Last Reply May '16	Replies 1	Views 546	Votes 0

WaldoTH 4.3k

May '16

Hi guys, I'm getting used to the Model stuff with phalcon. I want to do a query similar to this one:

SELECT pid, MAX(date) as last

        FROM Purchases

        WHERE pid IN ('$strIDQuery')

        GROUP BY pid

Here $strIDQuery=('09282',11811','32762')

So as you can see, I'm trying to retrieve the last date from each ID I pass trough the array. How can I do this with Phalcon:

I have this code:

$lastDates = Purchases::findFirst(

            array(

                "conditions" => "pid = '09282'",

                "order" => "date DESC",

                'format' => 'd-m-Y'

            )

        );

This code returns the last date of the pid=09282, BUT I want to pass many values and get a list of the last dates of each value. (What I'm doing with the IN command with my query above).

So, how can I achieve the results of the query above, with the phalcon models? Thank you!

David Hübner · Answer 1 · 2016-05-18T22:27:19-07:00

Try something like this

$lastDates = Purchases::find(array(
    "columns" => "pid, MAX(date)"
    "conditions" => "pid IN :ids:",
    "bind" => array("ids" => $strIDQuery),
    "group" => "pid"
));

if this fails use query

$lastDates = Purchases::query()
    ->columns(array("pid", "MAX(date)"))
    ->inWhere("pid", strIDQuery)
    ->groupBy ("pid")
    ->execute();