/** * @return \yii\db\ActiveQuery */ public function getItemDetails() { return $this->hasMany(ItemDetails::className(), ['item_id' => 'item_id']); }
/** * @return \yii\db\ActiveQuery */ public function getIdetails() { return $this->hasOne(ItemDetails::className(), ['idetails_id' => 'idetails_id']); }
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]); }
/** * @return \yii\db\ActiveQuery */ public function getIdetails() { return $this->hasMany(ItemDetails::className(), ['idetails_id' => 'idetails_id'])->viaTable('cart', ['customer_user_name' => 'customer_user_name']); }
/** * @return \yii\db\ActiveQuery */ public function getIdetails() { return $this->hasMany(ItemDetails::className(), ['idetails_id' => 'idetails_id'])->viaTable('order_details', ['order_id' => 'order_id']); }