/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = DriverExpenses::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, 'price' => $this->price, 'create_date' => $this->create_date]);
$query->andFilterWhere(['like', 'employee', $this->employee])->andFilterWhere(['like', 'detail', $this->detail])->andFilterWhere(['like', 'year', $this->year])->andFilterWhere(['like', 'month', $this->month]);
return $dataProvider;
}
public function actionLoad_expenses()
{
$driver = new DriverExpenses();
$request = \Yii::$app->request;
$employee = $request->post('employee');
$year = $request->post('year');
$month = $request->post('month');
$result = $driver->find()->where(['employee' => $employee])->andWhere(['year' => $year])->andWhere(['month' => $month])->all();
return $this->renderPartial('load_expenses', ["expenses" => $result]);
}
