/**
* @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');
}
