public function actionDesignershipping() { $orders1 = OrderDetails::find()->where(['designer_id' => 'DummyDesigner1', 'order_status' => 'pending'])->all(); $orderid1 = []; $items1 = []; $itemName1 = []; foreach ($orders1 as $order) { $items1[$order->idetails_id] = ItemDetails::find()->where(['idetails_id' => $order->idetails_id])->one(); $itemName1[$order->idetails_id] = Item::find()->where(['item_id' => $items1[$order->idetails_id]->item_id])->one(); $orderid1[$order->order_id] = Orders::find()->where(['order_id' => $order->order_id])->one(); } $orders2 = OrderDetails::find()->where(['designer_id' => 'DummyDesigner1', 'order_status' => 'shipped'])->all(); $orderid2 = []; $items2 = []; $itemName2 = []; foreach ($orders2 as $order) { $items2[$order->idetails_id] = ItemDetails::find()->where(['idetails_id' => $order->idetails_id])->one(); $itemName2[$order->idetails_id] = Item::find()->where(['item_id' => $items2[$order->idetails_id]->item_id])->one(); $orderid2[$order->order_id] = Orders::find()->where(['order_id' => $order->order_id])->one(); } return $this->render('designershipping', ['orders1' => $orders1, 'items1' => $items1, 'itemName1' => $itemName1, 'orderid1' => $orderid1, 'orders2' => $orders2, 'items2' => $items2, 'itemName2' => $itemName2, 'orderid2' => $orderid2]); }