在我在index.php
中呈现index.php
之后
我使用Kartik DateRange来获取两个日期之间的数据。这是我的代码:
<?= $form->field($model, 'date', [
'addon'=>['prepend'=>['content'=>'<i class="glyphicon glyphicon-calendar"></i>']],
'options'=>['class'=>'drp-container form-group']
])->widget(DateRangePicker::classname(), [
'useWithAddon'=>true
]);
?>
我用爆炸函数来得到我所传递的日期,我得到了一个真实的数据,它工作得很好。我的searchModel代码:
<?php
namespace app\models;
use Yii;
use yii\base\Model;
use yii\data\ActiveDataProvider;
use app\models\patientservices;
class patientservicesSearch extends patientservices
{
public function rules()
{
return [
[['id', 'price'], 'integer'],
[['patient_id', 'doctor_id','service_id','date','state'], 'safe'],
];
}
public function scenarios()
{
return Model::scenarios();
}
public function search($params)
{
$query = patientservices::find();
$dataProvider = new ActiveDataProvider([
'query' => $query,
'pagination' => array('pageSize' => 150),
]);
$this->load($params);
if (!$this->validate()) {
if ( ! is_null($this->date) && strpos($this->date, ' - ') !== false ) {
list($start_date, $end_date) = explode(' - ', $this->date);
$query->andFilterWhere(['between', 'date', $start_date, $end_date]);
$this->date = null;
}
return $dataProvider;
}
$query->joinWith('patient');
$query->joinWith('service');
$query->joinWith('doctor');
$query->andFilterWhere([
'patient_services.id' => $this->id,
'patient_services.price' => $this->price,
]);
$query->andFilterWhere(['like','patient.patient_name',$this->patient_id]);
$query->orFilterWhere(['=','patient.patient_id',$this->patient_id]);
$query->andFilterWhere(['like','services.service_name',$this->service_id]);
$query->andFilterWhere(['like','doctors.doctor_name',$this->doctor_id]);
if ( ! is_null($this->date) && strpos($this->date, ' - ') !== false ) {
list($start_date, $end_date) = explode(' - ', $this->date);
$query->andFilterWhere(['between', 'date', $start_date, $end_date]);
$this->date = null;
}
$total = 0;
if (!empty($dataProvider->getModels())) {
foreach ($dataProvider->getModels() as $key => $val) {
$total += $val->price;
}
}
return $dataProvider;
}
}
当我将传递参数的表单提交给searchModel
,然后我们知道,日期范围变为空后,其他字段不会变为空,我需要回显传递给searchModel
的参数,特别是日期范围。我不知道我在这里有什么问题。
发布于 2018-04-26 23:10:50
看起来,您的date
值不是加载在searchModel
中,否则它将显示在字段中,即使您在调用view
之前手动将该值分配给字段,如下面所示。我假定searchModel
名为ProductSearch
$params['ProductSearch']['date']='2018-05-20 - 2018-05-23';
$dataProvider=$model->search($params);
$this->render('search',['model'=>$model]);
因此,转到您的模型,并将date
字段添加到您的safe
规则和其他列出的规则中
public function rules() {
return [
[ [ 'id' ] , 'integer' ] ,
[ [ 'some_field', 'some_other_field', 'date' ] , 'safe' ] ,
];
}
如果这个字段不是数据库表的一部分,只是为了搜索而创建的,那么您应该将这个字段在searchModel
中声明为类的一个公共属性。
public $date;
EDIT
添加搜索模型后,似乎要将date
字段设置为null
,因此很明显,一旦搜索成功,它就不会显示您,因此在计算$total
之前,在search($params)
函数的末尾,从条件中移除行$this->date=null;
。
$query->andFilterWhere(['like','doctors.doctor_name',$this->doctor_id]);
if ( ! is_null($this->date) && strpos($this->date, ' - ') !== false ) {
list($start_date, $end_date) = explode(' - ', $this->date);
$query->andFilterWhere(['between', 'date', $start_date, $end_date]);
//-----> $this->date = null; //REMOVE THIS LINE //
}
https://stackoverflow.com/questions/50037103
复制相似问题