request->get()); //$query = Page::find(); //->joinWith('pagelang'); $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([ $this->addCondition($query, 'title'), ]); return $dataProvider; } static function getList (array $param = array ()) { $sql = ' SELECT `page`.date_add, `page`.`show`, `page_lang`.* FROM `page` LEFT JOIN `page_lang` ON `page_lang`.page_id = `page`.page_id AND `page_lang`.lang_id = '.(int)$param['lang_id']; $WHERE = array (); if (isset ($param['page_id'])) { $WHERE[] = '`page_lang`.page_id = '.(int)$param['page_id']; } if (isset ($param['date_add'])) { $WHERE[] = '`page`.date_add = "'.(int)$param['page_id'].'"'; } if (isset ($param['show'])) { $WHERE[] = '`page`.show = "'.(int)$param['show'].'"'; } if (! empty ($WHERE)) { $sql .= ' WHERE '.implode (' AND ', $WHERE); } return $sql; } }