public function searchForUser($params, $pagesize = 20) { $query = Transaction::find(); $dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['created_at' => SORT_DESC]], 'pagination' => ['pageSize' => $pagesize, 'pageSizeParam' => false]]); $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, 'user_id' => $this->user_id, 'deposit_before' => $this->deposit_before, 'value' => $this->value, 'created_at' => $this->created_at, 'updated_at' => $this->updated_at]); $query->andFilterWhere(['like', 'descr', $this->descr]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Transaction::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, 'code' => $this->code, 'status' => $this->status, 'created' => $this->created, 'ttl' => $this->ttl]); $query->andFilterWhere(['like', 'description', $this->description]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Transaction::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $dataProvider->setSort(['class' => 'yii\\data\\Sort', 'attributes' => ['id', 'ttl', 'status', 'user_id' => ['asc' => ['user.username' => SORT_ASC], 'desc' => ['user.username' => SORT_DESC]], 'description', 'resp_status', 'resp_code', 'resp_description']]); $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, 'ttl' => $this->ttl, 'status' => $this->status, 'resp_code' => $this->resp_code, 'user_id' => $this->user_id, 'created_at' => $this->created_at, 'updated_at' => $this->updated_at]); $query->andFilterWhere(['like', 'description', $this->description])->andFilterWhere(['like', 'resp_status', $this->resp_status])->andFilterWhere(['like', 'resp_description', $this->resp_description]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Transaction::find()->joinWith('user'); $dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['id' => SORT_DESC]]]); $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; } //echo'<pre>';var_dump($this->trans_type);echo'</pre>';die; $query->andFilterWhere(['{{%transaction}}.id' => $this->id, '{{%user}}.id' => $this->user_id, '{{%user}}.nickname' => $this->nickname, 'deposit_before' => $this->deposit_before, 'value' => $this->value, 'created_at' => $this->created_at, 'updated_at' => $this->updated_at]); $query->andFilterWhere(['like', 'descr', $this->descr]); if (floatval($this->value_from) < floatval($this->value_to) && floatval($this->value_to) != 0) { $query->andFilterWhere(['between', 'value', floatval($this->value_from), floatval($this->value_to)]); } elseif (floatval($this->value_from) != 0 && floatval($this->value_to) == 0) { $query->andFilterWhere(['>=', 'value', floatval($this->value_from)]); } elseif (floatval($this->value_from) == 0 && floatval($this->value_to) != 0) { $query->andFilterWhere(['<=', 'value', floatval($this->value_to)]); } if ($this->trans_user_type != self::TR_USER_TYPE_ALL) { $admins = User::getAdministratorsIds(); if ($this->trans_user_type == self::TR_USER_TYPE_ADM) { $query->andFilterWhere(['in', 'user_id', $admins]); } else { $query->andFilterWhere(['not in', 'user_id', $admins]); } } if (is_array($this->trans_type)) { if (count($this->trans_type)) { $trans_type_arr = ['or']; foreach ($this->trans_type as $trans_type) { $trans_type_arr[] = '(`descr` like "' . $trans_type . ',%")'; } //echo'<pre>';print_r($trans_type_arr);echo'</pre>';//die; if (count($trans_type_arr)) { $query->andFilterWhere($trans_type_arr); } } } return $dataProvider; }
public static function find() { return parent::find()->andWhere(['user_id' => Yii::$app->getUser()->id]); }
/** * Lists all Transaction models. * @return mixed */ public function actionIndex() { $dataProvider = new ActiveDataProvider(['query' => Transaction::find()]); return $this->render('index', ['dataProvider' => $dataProvider]); }