public function actionIndex() { $articleModel = new MirArticle(); $list = $articleModel->find()->where(["article_class" => '5'])->orderBy("article_id desc")->all(); $pics = $articleModel->find()->select("article_id,article_pic")->where(["article_class" => '5', 'article_istop' => '1'])->orderBy("article_id desc")->all(); // p($pics); return $this->render('index', ['list' => $list, 'pics' => $pics]); }
public function actionIndex2() { $id = Yii::$app->request->get("id"); // p($id); $articleModel = new MirArticle(); $jishu = $articleModel::findOne(["article_id" => $id]); $tuijiannews = $articleModel->find()->where(["article_class" => '3'])->orderBy("article_id desc")->limit(10)->all(); // p($tuijiannews); // p($jishu); return $this->render('index2', ['model' => $jishu, 'newMeetings' => $tuijiannews]); }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = MirArticle::find(); $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(['article_id' => $this->article_id, 'article_date' => $this->article_date, 'article_istop' => $this->article_istop, 'article_rank' => $this->article_rank]); $query->andFilterWhere(['like', 'article_title', $this->article_title])->andFilterWhere(['like', 'article_titile_e', $this->article_titile_e])->andFilterWhere(['like', 'article_class', $this->article_class])->andFilterWhere(['like', 'article_contents', $this->article_contents])->andFilterWhere(['like', 'article_contents_e', $this->article_contents_e])->andFilterWhere(['like', 'article_makerid', $this->article_makerid])->andFilterWhere(['like', 'article_pic', $this->article_pic])->andFilterWhere(['like', 'article_zy', $this->article_zy])->andFilterWhere(['like', 'article_source', $this->article_source])->orderBy("article_id desc"); return $dataProvider; }
public function actionIndex3() { $articleModel = new MirArticle(); $data = MirArticle::find()->select("article_pic,article_id")->all(); for ($i = 0; $i < count($data); $i++) { $pics[$i]['id'] = $data[$i]->article_id; $pics[$i]['pic'] = $data[$i]->article_pic; } for ($i = 0; $i < count($pics); $i++) { if ($pics[$i]['pic'] == 'nopic.gif') { $model = MirArticle::find()->where(["article_id" => $pics[$i]['id']])->one(); $model->article_pic = "moren.png"; $model->save(); } } echo "ok"; }