/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = GroupOption::find()->with(['creater', 'updater', 'deleter'])->asArray(true);
$query->where('[[tenant_id]] = :tenantId', [':tenantId' => Yad::getTenantId()]);
$dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['group_name' => SORT_ASC, 'value' => SORT_ASC]]]);
if (!($this->load($params) && $this->validate())) {
return $dataProvider;
}
$query->andFilterWhere(['enabled' => $this->enabled, 'defaulted' => $this->defaulted]);
$query->andFilterWhere(['like', 'group_name', $this->group_name])->andFilterWhere(['like', 'alias', $this->alias]);
return $dataProvider;
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = IpAccessRule::find()->with(['creater', 'updater', 'deleter'])->asArray(true);
$query->andWhere('tenant_id = :tenantId', [':tenantId' => Yad::getTenantId()]);
$dataProvider = new ActiveDataProvider(['query' => $query]);
if (!($this->load($params) && $this->validate())) {
return $dataProvider;
}
$query->andFilterWhere(['type' => $this->type, 'enabled' => $this->enabled]);
$query->andFilterWhere(['like', 'ip_address', $this->ip_address]);
return $dataProvider;
}
/**
* 获取设置为不可见的列
* @return array
*/
public static function getInvisibleColumns($name)
{
return Yii::$app->db->createCommand('SELECT [[attribute]] FROM {{%grid_column_config}} WHERE [[tenant_id]] = :tenantId AND [[user_id]] = :userId AND [[name]] = :name AND [[visible]] = :visible')->bindValues([':tenantId' => Yad::getTenantId(), ':userId' => Yii::$app->user->id, ':name' => $name, ':visible' => Constant::BOOLEAN_FALSE])->queryColumn();
}
/**
* 根据分组名称和值获取对应的分组显示文本
* @param string $groupName
* @param string $value
* @return mixed
*/
public static function getText($groupName, $value)
{
$text = null;
if (!empty($groupName) && !empty($value)) {
$text = Yii::$app->db->createCommand('SELECT [[text]] FROM {{%group_option}} WHERE [[tenant_id]] = :tenantId AND [[group_name]] = :groupName AND [[value]] = :value')->bindValues([':tenantId' => Yad::getTenantId(), ':groupName' => trim($groupName), ':value' => trim($value)])->queryScalar();
}
return $text;
}
