/** * @return \yii\db\ActiveQuery */ public function getPurchaseOrderLines() { return $this->hasMany(PurchaseOrderLine::className(), ['product_id' => 'id']); }
public function actionPurchasereport($groupBy = null) { $connection = \Yii::$app->db; $this->layout = 'dashboard'; $query = new Query(); $model = new PurchaseOrder(); $modelLine = new PurchaseOrderLine(); $model->load(Yii::$app->request->get()); $modelLine->load(Yii::$app->request->get()); $submited = false; // print_r($model); // if ($model->load(Yii::$app->request->get()) AND $modelLine->load(Yii::$app->request->get())) { // $query = $this->getPOLineRelatedQuery($model,$modelLine,$groupBy); // }else{ // $query = $this->getPOLineRelatedQuery($model,$modelLine,$groupBy); // } $query = $this->getPOLineRelatedQuery($model, $modelLine, $groupBy); $dataProvider = new ActiveDataProvider(['query' => $query, 'key' => 'id', 'pagination' => ['pageSize' => 500]]); if ($groupBy) { return $this->render('purchasereport_form', ['type' => 'search', 'model' => $model, 'modelline' => $modelLine, 'dataProvider' => $dataProvider, 'groupBy' => $groupBy]); } else { return $this->render('purchasereport_form', ['type' => 'search', 'model' => $model, 'modelline' => $modelLine, 'dataProvider' => $dataProvider, 'groupBy' => 'nogroup']); } }
/** * @return \yii\db\ActiveQuery */ public function getPurchaseOrderLines() { return $this->hasMany(PurchaseOrderLine::className(), ['variants' => 'id']); }
/** * @return \yii\db\ActiveQuery */ public function getPurchaseOrderLines() { // return $this->hasMany(PurchaseOrderLine::className(), ['order_id' => 'id']); return $this->hasMany(PurchaseOrderLine::className(), ['order_id' => 'id'])->orderBy('no, id ASC'); }