public function notAssignedAuctions(){ $query = Lots::find()->joinWith([ 'auction0' ])->where([ 'auctions.status' => 0 ]); return new ActiveDataProvider([ 'query' => $query, 'pagination' => [ 'pageSize' => 2 ] ]); }
/** * Updates an existing Lots model. * If update is successful, the browser will be redirected to the 'view' page. * @param integer $id * @return mixed */ public function actionUpdate() { $id = Auction::$app->request->post('id'); if($id){ $model = Lots::find()->joinWith(['lotPreferences'])->where('lots.id=:id',[':id' => $id])->one(); if (isset($_POST['Lots'])) { $model->load(Yii::$app->request->post()); $model->lotPreferences->load(Yii::$app->request->post()); if($model->update()) return 'Success'; } else { return $this->renderPartial('_form', [ 'model' => $model, ]); } } }
/** * @return \yii\db\ActiveQuery */ public function getLots($id) { return new ActiveDataProvider([ 'query' => Lots::find() ->innerJoinWith([ 'lotPreferences' => function($query){ $query->joinWith(['category0' , 'brand0'])->asArray(); }, ])->where(['lots.auction' => $id]) ]); }