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;
}
