public static function getListaMovimientos($todos = false) { if ($todos) { $opciones = MovimUf::find()->asArray()->all(); } else { $opciones = MovimUf::find()->andWhere(['<>', 'manual', 0])->asArray()->all(); } return ArrayHelper::map($opciones, 'id', 'desc_movim_uf'); }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = MovimUf::find(); $pageSize = isset($_GET['per-page']) ? $_GET['per-page'] : \Yii::$app->params['movimUf.defaultPageSize']; // add conditions that should always apply here $dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => $pageSize], 'sort' => ['defaultOrder' => ['id' => SORT_DESC], 'enableMultiSort' => true]]); $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; } // grid filtering conditions $query->andFilterWhere(['id' => $this->id, 'cesion' => $this->cesion, 'migracion' => $this->migracion, 'fec_vto' => $this->fec_vto, 'manual' => $this->manual]); $query->andFilterWhere(['like', 'desc_movim_uf', $this->desc_movim_uf]); return $dataProvider; }