Hi,
I use YII2 grid view to display data. I need just simply to have possibility to filter from to. It is about amount. I have done it with datePiker for filtering date between
'filter'=>DatePicker::widget([
'model'=> $searchModel,
'attribute' => 'calldate',
'options'=>['style'=>'width:150px;'],
'readonly' => true,
'pluginOptions' => [
'autoclose'=>true,
'format' => 'yyyy-mm-dd']]).
DatePicker::widget([
'model'=> $searchModel,
'value'=>date('Y-m-j'),
'attribute' => 'calldate2',
'options'=>['style'=>'width:150px;'],
'readonly' => true,
'pluginOptions' => [
'autoclose'=>true,
'format' => 'yyyy-mm-dd']]),
],
of course I have definition of this in search model
if(isset($this->calldate) and isset($this->calldate2) and !empty($this->calldate) and !empty($this->calldate2))
$query->andFilterWhere(['between','calldate',date('Y-m-j',strtotime($this->calldate)),date('Y-m-j',strtotime($this->calldate2))]);
elseif(isset($this->calldate) and !empty($this->calldate))
$query->andFilterWhere(['>=','calldate',date('Y-m-j',strtotime($this->calldate))]);
elseif(isset($this->calldate2) and !empty($this->calldate2))
$query->andFilterWhere(['<=','calldate',date('Y-m-j',strtotime($this->calldate2))]);
I have the same definition in search model only modified for integer.
Can someone help me to do the same for int value. Just to input filters to have the possibility to search value between this value.