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";
}
