gridview in php,php – 在GridView中过滤相关模型的设置

我试图在Yii2的

GridView小部件中为相关模型设置过滤器,但我不断得到错误,因为过滤器值必须是整数.

我已经关注了this question.现在,我有两个型号Services.php和ServiceCharge.php.

在ServiceCharge.php中,关系设置如下：

public function getServiceName()

{

return $this->hasOne(Services::className(),['id'=>'service_name']);

}

在ServiceChargeSearch.php中,代码如下：

namespace app\models;

use Yii;

use yii\base\Model;

use yii\data\ActiveDataProvider;

use app\models\ServiceCharges;

/**

* ServiceChargesSearch represents the model behind the search form about `app\models\ServiceCharges`.

*/

class ServiceChargesSearch extends ServiceCharges

{

/**

* @inheritdoc

*/

public function attributes()

{

// add related fields to searchable attributes

return array_merge(parent::attributes(), ['serviceName.services']);

}

public function rules()

{

return [

[['id'], 'integer'],

[['charges_cash', 'charges_cashless'], 'number'],

[['id', 'serviceName.services', 'room_category'], 'safe'],

];

}

/**

* @inheritdoc

*/

public function scenarios()

{

// bypass scenarios() implementation in the parent class

return Model::scenarios();

}

/**

* Creates data provider instance with search query applied

*

* @param array $params

*

* @return ActiveDataProvider

*/

public function search($params)

{

$query = ServiceCharges::find();

$dataProvider = new ActiveDataProvider([

'query' => $query,

]);

$dataProvider->sort->attributes['serviceName.services'] = [

'asc' => ['serviceName.services' => SORT_ASC],

'desc' => ['serviceName.services' => SORT_DESC],

];

$query->joinWith(['serviceName']);

$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,

// 'service_name' => $this->service_name,

'room_category' => $this->room_category,

'charges_cash' => $this->charges_cash,

'charges_cashless' => $this->charges_cashless,

])

->andFilterWhere(['LIKE', 'serviceName.services', $this->getAttribute('serviceName.services')]);

return $dataProvider;

}

}

在我的Gridview中它的设置如下：

[

'attribute'=>'service_name',

'value'=>'serviceName.services',

],

这是正确显示相关模型的服务名称.

我无法看到我做错了什么,但服务属性的过滤字段根本没有显示.