/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($id_program, $params) { $query = DisciplineName::find()->where(['id_program_main' => $id_program]); $subQueryDiscipline = Discipline::find()->select('*, cast([[code_last]] as decimal(10,3)) as [[code_last_num]]'); $subQuerySemester = DisciplineSemester::find()->select('id_discipline, MIN(semester) as min_semester')->groupBy('id_discipline'); $query->innerJoin(['discMain' => $subQueryDiscipline], 'discMain.id = discipline_name.id_discipline')->leftJoin(['discSemester' => $subQuerySemester], 'discSemester.id_discipline = discipline_name.id_discipline'); $provider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 10, 'pageSizeParam' => false]]); $provider->setSort(['attributes' => ['name', 'disciplineCode' => ['asc' => ['discMain.code_first' => SORT_ASC, 'discMain.code_last_num' => SORT_ASC, 'suffix' => SORT_ASC], 'desc' => ['discMain.code_first' => SORT_DESC, 'discMain.code_last_num' => SORT_DESC, 'suffix' => SORT_DESC], 'label' => 'DisciplineCode'], 'kind', 'block', 'disciplineSemesters' => ['asc' => ['discSemester.min_semester' => SORT_ASC], 'desc' => ['discSemester.min_semester' => SORT_DESC], 'label' => 'DisciplineSemester']], 'defaultOrder' => ['disciplineCode' => SORT_ASC]]); if (!($this->load($params) && $this->validate())) { return $provider; } $query->andWhere('name LIKE "%' . $this->name . '%" '); $query->andWhere('discMain.code_first LIKE "%' . $this->disciplineCode . '%" '); if (is_numeric($this->kind)) { $query->andWhere('discMain.kind = ' . $this->kind); } if (is_numeric($this->block)) { $query->andWhere('discMain.block = ' . $this->block); } return $provider; }