public static function find() { return parent::find()->where([Customer::tableName() . '.isdel' => 0]); }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = $this->find(); $query->joinWith(['customer']); $dataProvider = new ActiveDataProvider(['query' => $query]); $dataProvider->sort->attributes['customerAdminName'] = ['asc' => [Customer::tableName() . '.name' => SORT_ASC], 'desc' => [Customer::tableName() . '.name' => SORT_DESC]]; $dataProvider->sort->attributes['customerName'] = ['asc' => [Customer::tableName() . '.name' => SORT_ASC], 'desc' => [Customer::tableName() . '.name' => SORT_DESC]]; /* uncomment to sort by relations table on respective column $dataProvider->sort->attributes['confirmationsId'] = [ 'asc' => ['{{%confirmations}}.id' => SORT_ASC], 'desc' => ['{{%confirmations}}.id' => SORT_DESC], ]; $dataProvider->sort->attributes['salesId'] = [ 'asc' => ['{{%sales}}.id' => SORT_ASC], 'desc' => ['{{%sales}}.id' => SORT_DESC], ];*/ if (!($this->load($params) && $this->validate())) { return $dataProvider; } $params = self::queryNumber([['id', $this->tableName()], ['customer_id'], ['total'], ['status'], ['isdel']]); foreach ($params as $p) { $query->andFilterWhere($p); } $params = self::queryString([['reference'], ['data'], ['complete_reference'], ['log']]); foreach ($params as $p) { $query->andFilterWhere($p); } $params = self::queryTime([['time'], ['complete_time']]); foreach ($params as $p) { $query->andFilterWhere($p); } $query->andFilterWhere(['like', "lower(concat(" . Customer::tableName() . ".name," . Customer::tableName() . ".email," . Customer::tableName() . ".phones))", strtolower($this->customerAdminName)]); if ($this->customerName) { $query->andFilterWhere(['like', "lower(concat(','," . Customer::tableName() . ".name,','," . Customer::tableName() . ".email,','," . Customer::tableName() . ".phones,','))", strtolower("," . $this->customerName . ",")]); } return $dataProvider; }