public function search($order_id) { $query = OrdersProducts::find()->where(['order_id' => $order_id]); $dataProvider = new ActiveDataProvider(['query' => $query]); if (!$this->validate()) { // uncomment the following line if you do not want to any records when validation fails // $query->where('0=1'); return $dataProvider; } return $dataProvider; }
public function actionUpdate($order_id) { $model = $this->findModel($order_id); $searchModel = new OrdersAdminSearch(); $searchModelProducts = new OrdersProductsAdminSearch(); $dataProvider = $searchModelProducts->search($order_id); $query = OrdersProducts::find()->where(['order_id' => $order_id]); $total = $query->sum('quantity'); if ($model->load(Yii::$app->request->post()) && $model->save()) { return $this->redirect(['view', 'order_id' => $model->order_id]); } else { return $this->render('update', ['model' => $model, 'dataProvider' => $dataProvider, 'total' => $total]); } }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($id) { $query = OrdersProducts::find()->where(['order_id' => $id]); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to any records when validation fails // $query->where('0=1'); return $dataProvider; } // $query->andFilterWhere([ // 'id' => $this->id, // 'id_parent' => $this->id_parent, // 'expanded' => $this->expanded, // 'root' => $this->root, // 'lft' => $this->lft, // 'rgt' => $this->rgt, // 'level' => $this->level, // ]); // $query->andFilterWhere(['like', 'name', $this->name]); return $dataProvider; }
echo $model->address; ?> </p> <p>Комментарий: <?php echo $model->comment; ?> </p> </br> <? $order_id = $model->order_id; $searchModel = new OrdersProductsSearch(); $dataProvider = $searchModel->search($order_id); $query = OrdersProducts::find()->where(['order_id' => $order_id]); $total = $query->sum('quantity'); echo GridView::widget([ 'dataProvider' => $dataProvider, 'tableOptions' => ['class'=>'table table-bordered'], 'layout' => "{items}", 'showFooter'=>true, 'columns' => [ // [ // 'label'=>'<i class="fa fa-picture-o"></i>', // 'encodeLabel'=>false, // 'format'=>'raw', // 'value'=>function ($model) { // $product = Products::findOne($model->product_id);
public function getProducts() { return $this->hasMany(OrdersProducts::className(), ['order_id' => 'order_id']); }