public function search($params)
{
$query = new \yii\db\Query();
$dataProvider = new ActiveDataProvider(['query' => $query->from(SqlTracePersqlSearch::tableName()), 'db' => self::getDb(), 'pagination' => ['pageSize' => 50]]);
$query->orderBy('amount desc');
$this->load($params);
if (!$this->validate()) {
return $dataProvider;
}
if ($this->sqlquerytime) {
$this->start_date = $this->sqlquerytime;
$this->end_date = date('Y-m-d 00:00:00', strtotime('+1 day', strtotime($this->sqlquerytime)));
}
$query->andFilterWhere(['databasetype' => $this->databasetype]);
$query->andFilterWhere(['sqlquerytime' => $this->start_date]);
$query->orderBy('amount desc');
return $dataProvider;
}