/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = PartidaGenerica::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(['cuenta' => $this->cuenta, 'partida' => $this->partida, 'generica' => $this->generica, 'estatus' => $this->estatus]); $query->andFilterWhere(['estatus' => $this->nombreEstatus]); $query->andFilterWhere(['like', 'nombre', $this->nombre]); return $dataProvider; }
/** * Funcion de respuesta para el AJAX de * partidas generales * @return array JSON */ public function actionGenerica() { $request = Yii::$app->request; if ($request->isAjax) { Yii::$app->response->format = Response::FORMAT_JSON; if ($request->isPost) { //Partidas GE $ge = PartidaGenerica::find()->select(["id AS id", "CONCAT(generica,' - ',nombre) AS name"])->where(['id_partida' => $request->post('depdrop_parents'), 'estatus' => 1])->asArray()->all(); return ['output' => $ge]; } } }