Spojenie dvoch tabuliek s notorm s cudzim klucom

MKI-Miro

Ahojte
mam dve tabulky

Tabulka1: order
stlpec1: id (primary)
stlpec2: number

Tabulka2: order_item
stlpec1: id (primary)
stlpec2: order_number (foregin key to number)

a chcem urobit nieco taketo (len to neviem spravne zapisat)

$this->template->orders = $this->orderRepository->findAll()->order('id DESC');

a v sablone potom

{foreach $orders as $order}
	{foreach $order->order_item as $orderItem}
        {/foreach}
{/foreach}

Ak oto spravne zapisat ? teraz mi pise ze order_item nepozna

dakujem

Editoval MKI-Miro (5. 3. 2013 12:23)

vvoody

{foreach $orders as $order}
    {foreach $order->related('order_item','order_number') as $orderItem}
        {/foreach}
{/foreach}

MKI-Miro

dakujeem

MKI-Miro

chybu mi to sice nehlasi ale vysledok nie je ani jeden = ani jeden krat neprebehne foreach hmm mozno niekde inde nejaka moja chyba

Edit
teraz sa to snazi pozerat do order_item ale neberie column number z tabulky order ale column id z tabulky order

Editoval MKI-Miro (5. 3. 2013 18:12)