/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = ReportClassified::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(['id' => $this->id, 'subject_id' => $this->subject_id, 'classified_id' => $this->classified_id, 'create_at' => $this->create_at, 'update_at' => $this->update_at, 'checked' => $this->checked]); $query->andFilterWhere(['like', 'message', $this->message])->andFilterWhere(['like', 'email_reporter', $this->email_reporter]); return $dataProvider; }
<i class="fa fa-times"></i> </div> <a href="<?php echo \yii\helpers\Url::to(['/statistic-report/']); ?> " class="small-box-footer"> More info <i class="fa fa-arrow-circle-right"></i> </a> </div> </div><!-- ./col --> <div class="col-lg-4 col-xs-4"> <!-- small box --> <div class="small-box bg-yellow"> <div class="inner"> <h3><?php echo $dataChecked = \common\models\ReportClassified::find()->where(['checked' => 1])->count(); ?> </h3> <p>Report Checked</p> </div> <div class="icon"> <i class="fa fa-check"></i> </div> <a href="<?php echo \yii\helpers\Url::to(['/statistic-report/']); ?> " class="small-box-footer"> More info <i class="fa fa-arrow-circle-right"></i> </a> </div> </div><!-- ./col -->