Display results of Builder

Question

Display results of Builder

WaldoTH May '16

Created May '16	Last Reply Jun '16	Replies 3	Views 653	Votes 0

WaldoTH 4.3k

May '16

Hi guys, I'm learning to use the Builder and so far I've been using it to paginate stuff and it works great. However, now I don't need to paginate, I need to put every row returned into an array (later to export it to an Excel file) and I haven't been able to manipulate the Builder results in order to do this.

Here's my code:

    $columnsSt = 'Customers.partner_id,  Customers.customer_id, account_type, merge, DATE_FORMAT(MAX(date), "%d-%m-%Y") as lastdate';

  $customers = $this->modelsManager->createBuilder()

                ->columns($columnsSt)

                ->from('Customers')

                ->leftJoin('Purchases', 'Customers.customer_id = p.customer_id','p')

                ->groupBy(array('Customers.customer_id'))

                ->orderBy('customer_id DESC');

As I mentioned, if I use the paginator, I can display this info on my page without problem:

$paginator = new PaginatorQueryBuilder(array(

                "builder"   => $customers,

                "limit"     => 20,

                "page"      => $this->request->getQuery('page', 'int')

            ));

However, now I don't want to paginate! I want to put every result of the Builder into an array. Something like this:

foreach($customers as $cust)
    {

        $CustArr[] = array(
            'partner_id' =>  $cust->partner_id,
            'account_type'          =>  $cust->account_type,
            'lastdate'    =>  $cust->lastdate,

        );

    }

So my question is: how can I manipulate the results of the Builder in order to place them in an array? I'm sorry if this is too dumb, but I haven't been able to do this. Thank you so much!

WaldoTH
4.3k

Accepted
answer

in reply to

Nikolay Mihaylov

May '16

Thank you so so much!! Just a little question more, what's the advantage or... what can I do exactly when caching the query? Thanks again!

try adding this after your orderBy clause

// Get all results
->getQuery()->execute();

// Get single result
->getQuery()->getSingleResult();

// Pro tip: caching the query
->getQuery()->cache(['key' => 'your-cache-filename'])->execute();

Nikolay Mihaylov · Answer 1 · 2016-05-24T23:54:27-07:00

try adding this after your orderBy clause

// Get all results
->getQuery()->execute();

// Get single result
->getQuery()->getSingleResult();

// Pro tip: caching the query
->getQuery()->cache(['key' => 'your-cache-filename'])->execute();

Nikolay Mihaylov · Answer 2 · 2016-05-25T23:01:17-07:00

Ill quote Phalcon docs:

Accessing database systems is often one of the most common bottlenecks in terms of performance.

Its good idea to cache common queries which dont change often. For example a good idea for cache would be sections on your homepage like latest articles, carousels, menu e.t.c.

More info on caching in the docs: https://docs.phalcon.io/en/latest/reference/models-cache.html

Nikolay Mihaylov · Answer 3 · 2016-06-01T06:26:27-07:00

Nikolay Mihaylov
93.7k

Jun '16

If you don't have more questions you can mark thread as solved.