問題描述
如果我在 db 中有 2 個(gè)字段 - 概率和影響，并且我需要 GridView 中的一列，其中這兩個(gè)字段相乘.我設(shè)法將它添加到那里:
If I have 2 fields in db - probability and influence and I need a column in GridView where these two fields are multiplied. I managed to add it there like:
[
'attribute' => 'priority',
'format' => 'raw',
'value' => function ($model) {
return $model->influence * $model->probability;
},
],
但無法處理排序，因?yàn)樵摿胁辉跀?shù)據(jù)庫中，向 $query 添加過濾器只會(huì)導(dǎo)致錯(cuò)誤.
But can't handle the sorting, because that column is not in db and adding filters to $query causes only errors.
$query = Risks::find();
$query->select(`probability*influence AS priority`);
$dataProvider = new ActiveDataProvider([
'query' => $query,
]);
已更新(適用于 Asc 和 Desc 但不適用于過濾器)
Updated (works Asc and Desc but not with filters)
public function search($params)
{
$query = Risks::find();
$query->joinWith(['author', 'proj']);
$query->select('*, (probability * influence) as priority');
$dataProvider = new ActiveDataProvider([
'query' => $query,
]);
$dataProvider->setSort([
'attributes' => [
// 'id',
'probability',
'risks',
'influence',
'del' => [
'asc' => ['risks.del' => SORT_ASC],
'desc' => ['risks.del' => SORT_DESC],
],
'priority' => [
'asc' => ['priority' => SORT_ASC],
'desc' => ['priority' => SORT_DESC],
'label' => 'Priority',
],
'proj' => [
'asc' => ['projects.name' => SORT_ASC],
'desc' => ['projects.name' => SORT_DESC],
],
'author' => [
'asc' => ['users.name' => SORT_ASC],
'desc' => ['users.name' => SORT_DESC],
]
]
]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere([
'id' => $this->id,
'proj_id' => $this->proj_id,
'author_id' => $this->author_id,
'influence' => $this->influence,
'probability' => $this->probability,
//'del' => $this->del,
])
->andFilterWhere(['like', 'projects.name', $this->proj])
->andFilterWhere(['like', 'users.name', $this->author]);
$query->andFilterWhere(['like', 'risks', $this->risks]);
$query->having('priority = '. $this->priority);
//$query->having(['priority' => $this->priority]);
return $dataProvider;
}
推薦答案
第 1 步:將 getter 函數(shù)添加到您的基本 Risks 模型:
STEP 1: Add a getter function to your base Risks model:
public function getPriority() {
return ($this->probability * $this->influence);
}
第 2 步:將屬性 priority 添加到您的模型 RisksSearch 并配置您的規(guī)則.
STEP 2: Add an attribute priority to your model RisksSearch and configure your rules.
/* your calculated attribute */
public $priority;
/* setup rules */
public function rules() {
return [
/* your other rules */
[['priority'], 'safe']
];
}
第 3 步:編輯 search() 方法以包含計(jì)算字段 priority
public function search($params) {
$query = Person::find();
$query->select('*, (probability * influence) as priority');
$dataProvider = new ActiveDataProvider([
'query' => $query,
]);
/**
* Setup your sorting attributes
* Note: This is setup before $this->load($params)
*/
$dataProvider->setSort([
'attributes' => [
'id',
'priority' => [
'asc' => ['priority' => SORT_ASC],
'desc' => ['priority' => SORT_DESC],
'label' => 'Priority',
'default' => SORT_ASC
],
]
]);
...
第 4 步:在 $this->load($params) 之后添加 $query->andFilterWhere() 以便能夠過濾計(jì)算出的字段
STEP 4: Add $query->andFilterWhere() after $this->load($params) to be able to filter the calculated field
// use the operator you wish, i.e. '=', '>', '<' etc
$query->andFilterWhere(['=', '(probability * influence)', $this->priority]);
這篇關(guān)于在 GridView Yii2 中對(duì)數(shù)據(jù)進(jìn)行排序和過濾，其中列不在數(shù)據(jù)庫中的文章就介紹到這了，希望我們推薦的答案對(duì)大家有所幫助，也希望大家多多支持html5模板網(wǎng)！