/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = BuildGuide::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params, ''); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['build_guide_id' => $this->build_guide_id, 'user_fk' => $this->user_fk, 'visibility_fk' => $this->visibility_fk, 'last_update' => $this->last_update, 'in_order' => $this->in_order]); $query->andFilterWhere(['like', 'title', $this->title])->andFilterWhere(['like', 'guide', $this->guide]); return $dataProvider; }
public static function getMyNewestBuild() { $lastBuildGuide = BuildGuide::find()->where(['user_fk' => Yii::$app->user->identity->user_id])->orderBy('last_update DESC')->one(); return $lastBuildGuide; }
public function actionLinkPart($build_id, $part_id) { $oldLink = BuildPart::findOne(['part_fk' => Yii::$app->session['old_part_id'], 'build_guide_fk' => $build_id]); if ($oldLink != NULL) { $oldLink->part_fk = $part_id; $oldLink->update(); } else { $build = BuildGuide::find()->where(['build_guide_id' => $build_id])->one(); $part = Part::find()->where(['part_id' => $part_id])->one(); $part->link('builds', $build); } return $this->redirect(['/build-guide/view', 'id' => $build_id]); }