Query builder and all columns select with JOIN

Question

Query builder and all columns select with JOIN

Sergey Aug '15

Created Aug '15	Last Reply Aug '15	Replies 1	Views 1222	Votes 1

Sergey 1.3k

Aug '15

Hello) I have a code:

$items =  \Phalcon\DI::getDefault()->get('modelsManager')->createBuilder()
            ->addFrom('m:Invoices', 'i')
            ->leftJoin('m:users', 'u.id = i.user_id', 'u')
            ->columns('i.id, i.text, i.cost, i.status, DATE_FORMAT(i.date, "%d-%m-%Y") AS dt, u.name')
            ->limit($limit)->offset($offset)->orderBy($order)
            ->getQuery()->execute();

All works there, but if I want to select all items from first table:

->columns('i.*, u.name')

I get very strange object!!

$items[0]->name - return name from second table $items[0]->text - return error.

How can I receive the same result?

1

Andres Gutierrez · Answer 1 · 2015-08-17T09:35:22-07:00

It groups the Invoices object in the alias "i":

foreach ($items as $item) {
      echo $item->name;
      echo $item->i->text;
}

Sergey · Answer 2 · 2015-08-17T10:15:45-07:00

Sergey
1.3k

Aug '15

Thank you. Very strange code, but it works. I have no ideas, how make json from this code :(