I have a table that has datetime field and i want to filter it by interval from advanced search form.
i made in my module 2 variables to store the values from form
public $created_from;
public $created_till;
and in model search() i added 2 compare lines and commented out the original compare
$criteria->compare('t.sisfar_in_items_created_ts','>'.$this->created_from, true);
$criteria->compare('t.sisfar_in_items_created_ts','<'.$this->created_till, true);
When i try to use the new form fields they dont seem to give their values to $created_from and $created_till to be used in compare.
The filter itself seems to work since if i give $created_from and $created_till values in model contructor the table gets filtered corectly.
Any ideas what i am missing or doing wrong?
Full model code:
<?php
class SisfarInItems2 extends CActiveRecord
{
public $sisfar_customers_name;
public $created_from;
public $created_till;
function __construct() {
//$this->created_from = '2012-06-06';
//$this->created_till = date('Y-m-d');
//print "In BaseClass constructor\n";
}
/**
* Returns the static model of the specified AR class.
* @return SisfarInItems2 the static model class
*/
public static function model($className=__CLASS__)
{
return parent::model($className);
}
/**
* @return string the associated database table name
*/
public function tableName()
{
return 'sisfar_in_items';
}
/**
* @return array validation rules for model attributes.
*/
public function rules()
{
// NOTE: you should only define rules for those attributes that
// will receive user inputs.
return array(
array('sisfar_in_items_xml, sisfar_in_items_xml_after_pre_process, sisfar_in_items_received_xml_id, sisfar_in_items_mode, sisfar_in_items_created_by, sisfar_in_items_created_ts, sisfar_in_items_modified_by, sisfar_in_items_modified_ts', 'required'),
array('sisfar_in_items_received_xml_id, sisfar_in_items_created_by, sisfar_in_items_modified_by', 'numerical', 'integerOnly'=>true),
array('sisfar_in_items_ItemWeight', 'numerical'),
array('sisfar_in_items_ips_mailitm_pid, sisfar_in_items_ItemId, sisfar_in_items_Content, sisfar_in_items_LocalId, sisfar_in_items_ClassCd, sisfar_in_items_AddService, sisfar_in_items_OrigCountryCd, sisfar_in_items_DestCountryCd, sisfar_in_items_PostalStatusCd, sisfar_in_items_Sender_Name, sisfar_in_items_Sender_Address, sisfar_in_items_Sender_City, sisfar_in_items_Sender_Postcode, sisfar_in_items_AdditionalData, sisfar_in_items_Sender_CountrySubEntity, sisfar_in_items_Sender_PhoneNo, sisfar_in_items_Sender_FaxNo, sisfar_in_items_Sender_Email, sisfar_in_items_Addressee_Name, sisfar_in_items_Addressee_Forename, sisfar_in_items_Addressee_Address, sisfar_in_items_Addressee_City, sisfar_in_items_Addressee_Postcode, sisfar_in_items_Addressee_CountrySubEntity, sisfar_in_items_Addressee_PhoneNo, sisfar_in_items_Addressee_Email, sisfar_in_items_ItemEvent_TNCd, sisfar_in_items_ItemEvent_Date, sisfar_in_items_ItemEvent_OfficeCd, sisfar_in_items_ItemEvent_UserFid, sisfar_in_items_ItemEvent_NonDeliveryReason, sisfar_in_items_ItemEvent_NonDeliveryMeasure, sisfar_in_items_ItemEvent_NextOfficeFcd, sisfar_in_items_Parcel_MailItemCategoryCd, sisfar_in_items_Parcel_ExpressInd, sisfar_in_items_Parcel_MailCategoryCd, sisfar_in_items_Parcel_CoDInd, sisfar_in_items_Parcel_CoDValue, sisfar_in_items_Parcel_CoDCurrencyCd, sisfar_in_items_Parcel_SenderInstructionCd, sisfar_in_items_Parcel_InsuredSDRValue, sisfar_in_items_Parcel_InsuredValue, sisfar_in_items_Parcel_InsuredCurrencyCd, sisfar_in_items_Letter_MailCategoryCd, sisfar_in_items_Letter_CoDValue, sisfar_in_items_Letter_InsuredCurrencyCd, sisfar_in_items_Letter_MailItemCategoryCd, sisfar_in_items_Letter_LetterCharacteristicCd, sisfar_in_items_Letter_InsuredValue, sisfar_in_items_Letter_InsuredSDRValue, sisfar_in_items_Letter_CoDInd, sisfar_in_items_Letter_ExpressInd', 'length', 'max'=>50),
array('sisfar_in_items_RecptclId, sisfar_in_items_CodCurrencyCd', 'length', 'max'=>10),
array('sisfar_in_items_mode', 'length', 'max'=>1),
// The following rule is used by search().
// Please remove those attributes that should not be searched.
array('created_from, created_till, sisfar_customers_name, sisfar_in_items_xml_id, sisfar_in_items_ips_mailitm_pid, sisfar_in_items_ItemId, sisfar_in_items_xml, sisfar_in_items_xml_after_pre_process, sisfar_in_items_received_xml_id, sisfar_in_items_ItemWeight, sisfar_in_items_RecptclId, sisfar_in_items_CodCurrencyCd, sisfar_in_items_Content, sisfar_in_items_LocalId, sisfar_in_items_ClassCd, sisfar_in_items_AddService, sisfar_in_items_OrigCountryCd, sisfar_in_items_DestCountryCd, sisfar_in_items_PostalStatusCd, sisfar_in_items_Sender_Name, sisfar_in_items_Sender_Address, sisfar_in_items_Sender_City, sisfar_in_items_Sender_Postcode, sisfar_in_items_AdditionalData, sisfar_in_items_Sender_CountrySubEntity, sisfar_in_items_Sender_PhoneNo, sisfar_in_items_Sender_FaxNo, sisfar_in_items_Sender_Email, sisfar_in_items_Addressee_Name, sisfar_in_items_Addressee_Forename, sisfar_in_items_Addressee_Address, sisfar_in_items_Addressee_City, sisfar_in_items_Addressee_Postcode, sisfar_in_items_Addressee_CountrySubEntity, sisfar_in_items_Addressee_PhoneNo, sisfar_in_items_Addressee_Email, sisfar_in_items_ItemEvent_TNCd, sisfar_in_items_ItemEvent_Date, sisfar_in_items_ItemEvent_OfficeCd, sisfar_in_items_ItemEvent_UserFid, sisfar_in_items_ItemEvent_NonDeliveryReason, sisfar_in_items_ItemEvent_NonDeliveryMeasure, sisfar_in_items_ItemEvent_NextOfficeFcd, sisfar_in_items_Parcel_MailItemCategoryCd, sisfar_in_items_Parcel_ExpressInd, sisfar_in_items_Parcel_MailCategoryCd, sisfar_in_items_Parcel_CoDInd, sisfar_in_items_Parcel_CoDValue, sisfar_in_items_Parcel_CoDCurrencyCd, sisfar_in_items_Parcel_SenderInstructionCd, sisfar_in_items_Parcel_InsuredSDRValue, sisfar_in_items_Parcel_InsuredValue, sisfar_in_items_Parcel_InsuredCurrencyCd, sisfar_in_items_Letter_MailCategoryCd, sisfar_in_items_Letter_CoDValue, sisfar_in_items_Letter_InsuredCurrencyCd, sisfar_in_items_Letter_MailItemCategoryCd, sisfar_in_items_Letter_LetterCharacteristicCd, sisfar_in_items_Letter_InsuredValue, sisfar_in_items_Letter_InsuredSDRValue, sisfar_in_items_Letter_CoDInd, sisfar_in_items_Letter_ExpressInd, sisfar_in_items_mode, sisfar_in_items_created_by, sisfar_in_items_created_ts, sisfar_in_items_modified_by, sisfar_in_items_modified_ts', 'safe', 'on'=>'search'),
);
}
/**
* @return array relational rules.
*/
public function relations()
{
// NOTE: you may need to adjust the relation name and the related
// class name for the relations automatically generated below.
return array(
'customers' => array(self::HAS_ONE, 'SisfarCustomers', '', 'on'=>'sisfar_customers_id = sisfar_in_items_created_by'),
);
}
/**
* @return array customized attribute labels (name=>label)
*/
public function attributeLabels()
{
return array(
'sisfar_in_items_xml_id' => 'Sisfar In Items Xml',
'sisfar_in_items_ips_mailitm_pid' => 'Sisfar In Items Ips Mailitm Pid',
'sisfar_in_items_ItemId' => 'Sisfar In Items Item',
'sisfar_in_items_xml' => 'Sisfar In Items Xml',
'sisfar_in_items_xml_after_pre_process' => 'Sisfar In Items Xml After Pre Process',
'sisfar_in_items_received_xml_id' => 'Sisfar In Items Received Xml',
'sisfar_in_items_ItemWeight' => 'Sisfar In Items Item Weight',
'sisfar_in_items_RecptclId' => 'Sisfar In Items Recptcl',
'sisfar_in_items_CodCurrencyCd' => 'Sisfar In Items Cod Currency Cd',
'sisfar_in_items_Content' => 'Sisfar In Items Content',
'sisfar_in_items_LocalId' => 'Sisfar In Items Local',
'sisfar_in_items_ClassCd' => 'Sisfar In Items Class Cd',
'sisfar_in_items_AddService' => 'Sisfar In Items Add Service',
'sisfar_in_items_OrigCountryCd' => 'Sisfar In Items Orig Country Cd',
'sisfar_in_items_DestCountryCd' => 'Sisfar In Items Dest Country Cd',
'sisfar_in_items_PostalStatusCd' => 'Sisfar In Items Postal Status Cd',
'sisfar_in_items_Sender_Name' => 'Sisfar In Items Sender Name',
'sisfar_in_items_Sender_Address' => 'Sisfar In Items Sender Address',
'sisfar_in_items_Sender_City' => 'Sisfar In Items Sender City',
'sisfar_in_items_Sender_Postcode' => 'Sisfar In Items Sender Postcode',
'sisfar_in_items_AdditionalData' => 'Sisfar In Items Additional Data',
'sisfar_in_items_Sender_CountrySubEntity' => 'Sisfar In Items Sender Country Sub Entity',
'sisfar_in_items_Sender_PhoneNo' => 'Sisfar In Items Sender Phone No',
'sisfar_in_items_Sender_FaxNo' => 'Sisfar In Items Sender Fax No',
'sisfar_in_items_Sender_Email' => 'Sisfar In Items Sender Email',
'sisfar_in_items_Addressee_Name' => 'Sisfar In Items Addressee Name',
'sisfar_in_items_Addressee_Forename' => 'Sisfar In Items Addressee Forename',
'sisfar_in_items_Addressee_Address' => 'Sisfar In Items Addressee Address',
'sisfar_in_items_Addressee_City' => 'Sisfar In Items Addressee City',
'sisfar_in_items_Addressee_Postcode' => 'Sisfar In Items Addressee Postcode',
'sisfar_in_items_Addressee_CountrySubEntity' => 'Sisfar In Items Addressee Country Sub Entity',
'sisfar_in_items_Addressee_PhoneNo' => 'Sisfar In Items Addressee Phone No',
'sisfar_in_items_Addressee_Email' => 'Sisfar In Items Addressee Email',
'sisfar_in_items_ItemEvent_TNCd' => 'Sisfar In Items Item Event Tncd',
'sisfar_in_items_ItemEvent_Date' => 'Sisfar In Items Item Event Date',
'sisfar_in_items_ItemEvent_OfficeCd' => 'Sisfar In Items Item Event Office Cd',
'sisfar_in_items_ItemEvent_UserFid' => 'Sisfar In Items Item Event User Fid',
'sisfar_in_items_ItemEvent_NonDeliveryReason' => 'Sisfar In Items Item Event Non Delivery Reason',
'sisfar_in_items_ItemEvent_NonDeliveryMeasure' => 'Sisfar In Items Item Event Non Delivery Measure',
'sisfar_in_items_ItemEvent_NextOfficeFcd' => 'Sisfar In Items Item Event Next Office Fcd',
'sisfar_in_items_Parcel_MailItemCategoryCd' => 'Sisfar In Items Parcel Mail Item Category Cd',
'sisfar_in_items_Parcel_ExpressInd' => 'Sisfar In Items Parcel Express Ind',
'sisfar_in_items_Parcel_MailCategoryCd' => 'Sisfar In Items Parcel Mail Category Cd',
'sisfar_in_items_Parcel_CoDInd' => 'Sisfar In Items Parcel Co Dind',
'sisfar_in_items_Parcel_CoDValue' => 'Sisfar In Items Parcel Co Dvalue',
'sisfar_in_items_Parcel_CoDCurrencyCd' => 'Sisfar In Items Parcel Co Dcurrency Cd',
'sisfar_in_items_Parcel_SenderInstructionCd' => 'Sisfar In Items Parcel Sender Instruction Cd',
'sisfar_in_items_Parcel_InsuredSDRValue' => 'Sisfar In Items Parcel Insured Sdrvalue',
'sisfar_in_items_Parcel_InsuredValue' => 'Sisfar In Items Parcel Insured Value',
'sisfar_in_items_Parcel_InsuredCurrencyCd' => 'Sisfar In Items Parcel Insured Currency Cd',
'sisfar_in_items_Letter_MailCategoryCd' => 'Sisfar In Items Letter Mail Category Cd',
'sisfar_in_items_Letter_CoDValue' => 'Sisfar In Items Letter Co Dvalue',
'sisfar_in_items_Letter_InsuredCurrencyCd' => 'Sisfar In Items Letter Insured Currency Cd',
'sisfar_in_items_Letter_MailItemCategoryCd' => 'Sisfar In Items Letter Mail Item Category Cd',
'sisfar_in_items_Letter_LetterCharacteristicCd' => 'Sisfar In Items Letter Letter Characteristic Cd',
'sisfar_in_items_Letter_InsuredValue' => 'Sisfar In Items Letter Insured Value',
'sisfar_in_items_Letter_InsuredSDRValue' => 'Sisfar In Items Letter Insured Sdrvalue',
'sisfar_in_items_Letter_CoDInd' => 'Sisfar In Items Letter Co Dind',
'sisfar_in_items_Letter_ExpressInd' => 'Sisfar In Items Letter Express Ind',
'sisfar_in_items_mode' => 'Sisfar In Items Mode',
'sisfar_in_items_created_by' => 'Sisfar In Items Created By',
'sisfar_in_items_created_ts' => 'Sisfar In Items Created Ts',
'sisfar_in_items_modified_by' => 'Sisfar In Items Modified By',
'sisfar_in_items_modified_ts' => 'Sisfar In Items Modified Ts',
);
}
/**
* Retrieves a list of models based on the current search/filter conditions.
* @return CActiveDataProvider the data provider that can return the models based on the search/filter conditions.
*/
public function search()
{
// Warning: Please modify the following code to remove attributes that
// should not be searched.
$criteria=new CDbCriteria;
$criteria->compare('t.sisfar_in_items_xml_id',$this->sisfar_in_items_xml_id);
$criteria->compare('t.sisfar_in_items_ips_mailitm_pid',$this->sisfar_in_items_ips_mailitm_pid,true);
$criteria->compare('t.sisfar_in_items_ItemId',$this->sisfar_in_items_ItemId,true);
$criteria->compare('t.sisfar_in_items_xml',$this->sisfar_in_items_xml,true);
$criteria->compare('t.sisfar_in_items_xml_after_pre_process',$this->sisfar_in_items_xml_after_pre_process,true);
$criteria->compare('sisfar_in_items_received_xml_id',$this->sisfar_in_items_received_xml_id);
$criteria->compare('t.sisfar_in_items_ItemWeight',$this->sisfar_in_items_ItemWeight);
$criteria->compare('t.sisfar_in_items_RecptclId',$this->sisfar_in_items_RecptclId,true);
$criteria->compare('t.sisfar_in_items_CodCurrencyCd',$this->sisfar_in_items_CodCurrencyCd,true);
$criteria->compare('t.sisfar_in_items_Content',$this->sisfar_in_items_Content,true);
$criteria->compare('t.sisfar_in_items_LocalId',$this->sisfar_in_items_LocalId,true);
$criteria->compare('t.sisfar_in_items_ClassCd',$this->sisfar_in_items_ClassCd,true);
$criteria->compare('t.sisfar_in_items_AddService',$this->sisfar_in_items_AddService,true);
$criteria->compare('t.sisfar_in_items_OrigCountryCd',$this->sisfar_in_items_OrigCountryCd,true);
$criteria->compare('t.sisfar_in_items_DestCountryCd',$this->sisfar_in_items_DestCountryCd,true);
$criteria->compare('t.sisfar_in_items_PostalStatusCd',$this->sisfar_in_items_PostalStatusCd,true);
$criteria->compare('t.sisfar_in_items_Sender_Name',$this->sisfar_in_items_Sender_Name,true);
$criteria->compare('t.sisfar_in_items_Sender_Address',$this->sisfar_in_items_Sender_Address,true);
$criteria->compare('t.sisfar_in_items_Sender_City',$this->sisfar_in_items_Sender_City,true);
$criteria->compare('t.sisfar_in_items_Sender_Postcode',$this->sisfar_in_items_Sender_Postcode,true);
$criteria->compare('t.sisfar_in_items_AdditionalData',$this->sisfar_in_items_AdditionalData,true);
$criteria->compare('t.sisfar_in_items_Sender_CountrySubEntity',$this->sisfar_in_items_Sender_CountrySubEntity,true);
$criteria->compare('t.sisfar_in_items_Sender_PhoneNo',$this->sisfar_in_items_Sender_PhoneNo,true);
$criteria->compare('t.sisfar_in_items_Sender_FaxNo',$this->sisfar_in_items_Sender_FaxNo,true);
$criteria->compare('t.sisfar_in_items_Sender_Email',$this->sisfar_in_items_Sender_Email,true);
$criteria->compare('t.sisfar_in_items_Addressee_Name',$this->sisfar_in_items_Addressee_Name,true);
$criteria->compare('t.sisfar_in_items_Addressee_Forename',$this->sisfar_in_items_Addressee_Forename,true);
$criteria->compare('t.sisfar_in_items_Addressee_Address',$this->sisfar_in_items_Addressee_Address,true);
$criteria->compare('t.sisfar_in_items_Addressee_City',$this->sisfar_in_items_Addressee_City,true);
$criteria->compare('t.sisfar_in_items_Addressee_Postcode',$this->sisfar_in_items_Addressee_Postcode,true);
$criteria->compare('t.sisfar_in_items_Addressee_CountrySubEntity',$this->sisfar_in_items_Addressee_CountrySubEntity,true);
$criteria->compare('t.sisfar_in_items_Addressee_PhoneNo',$this->sisfar_in_items_Addressee_PhoneNo,true);
$criteria->compare('t.sisfar_in_items_Addressee_Email',$this->sisfar_in_items_Addressee_Email,true);
$criteria->compare('t.sisfar_in_items_ItemEvent_TNCd',$this->sisfar_in_items_ItemEvent_TNCd,true);
$criteria->compare('t.sisfar_in_items_ItemEvent_Date',$this->sisfar_in_items_ItemEvent_Date,true);
$criteria->compare('t.sisfar_in_items_ItemEvent_OfficeCd',$this->sisfar_in_items_ItemEvent_OfficeCd,true);
$criteria->compare('t.sisfar_in_items_ItemEvent_UserFid',$this->sisfar_in_items_ItemEvent_UserFid,true);
$criteria->compare('t.sisfar_in_items_ItemEvent_NonDeliveryReason',$this->sisfar_in_items_ItemEvent_NonDeliveryReason,true);
$criteria->compare('t.sisfar_in_items_ItemEvent_NonDeliveryMeasure',$this->sisfar_in_items_ItemEvent_NonDeliveryMeasure,true);
$criteria->compare('t.sisfar_in_items_ItemEvent_NextOfficeFcd',$this->sisfar_in_items_ItemEvent_NextOfficeFcd,true);
$criteria->compare('t.sisfar_in_items_Parcel_MailItemCategoryCd',$this->sisfar_in_items_Parcel_MailItemCategoryCd,true);
$criteria->compare('t.sisfar_in_items_Parcel_ExpressInd',$this->sisfar_in_items_Parcel_ExpressInd,true);
$criteria->compare('t.sisfar_in_items_Parcel_MailCategoryCd',$this->sisfar_in_items_Parcel_MailCategoryCd,true);
$criteria->compare('t.sisfar_in_items_Parcel_CoDInd',$this->sisfar_in_items_Parcel_CoDInd,true);
$criteria->compare('t.sisfar_in_items_Parcel_CoDValue',$this->sisfar_in_items_Parcel_CoDValue,true);
$criteria->compare('t.sisfar_in_items_Parcel_CoDCurrencyCd',$this->sisfar_in_items_Parcel_CoDCurrencyCd,true);
$criteria->compare('t.sisfar_in_items_Parcel_SenderInstructionCd',$this->sisfar_in_items_Parcel_SenderInstructionCd,true);
$criteria->compare('t.sisfar_in_items_Parcel_InsuredSDRValue',$this->sisfar_in_items_Parcel_InsuredSDRValue,true);
$criteria->compare('t.sisfar_in_items_Parcel_InsuredValue',$this->sisfar_in_items_Parcel_InsuredValue,true);
$criteria->compare('t.sisfar_in_items_Parcel_InsuredCurrencyCd',$this->sisfar_in_items_Parcel_InsuredCurrencyCd,true);
$criteria->compare('t.sisfar_in_items_Letter_MailCategoryCd',$this->sisfar_in_items_Letter_MailCategoryCd,true);
$criteria->compare('t.sisfar_in_items_Letter_CoDValue',$this->sisfar_in_items_Letter_CoDValue,true);
$criteria->compare('t.sisfar_in_items_Letter_InsuredCurrencyCd',$this->sisfar_in_items_Letter_InsuredCurrencyCd,true);
$criteria->compare('t.sisfar_in_items_Letter_MailItemCategoryCd',$this->sisfar_in_items_Letter_MailItemCategoryCd,true);
$criteria->compare('t.sisfar_in_items_Letter_LetterCharacteristicCd',$this->sisfar_in_items_Letter_LetterCharacteristicCd,true);
$criteria->compare('t.sisfar_in_items_Letter_InsuredValue',$this->sisfar_in_items_Letter_InsuredValue,true);
$criteria->compare('t.sisfar_in_items_Letter_InsuredSDRValue',$this->sisfar_in_items_Letter_InsuredSDRValue,true);
$criteria->compare('t.sisfar_in_items_Letter_CoDInd',$this->sisfar_in_items_Letter_CoDInd,true);
$criteria->compare('t.sisfar_in_items_Letter_ExpressInd',$this->sisfar_in_items_Letter_ExpressInd,true);
$criteria->compare('t.sisfar_in_items_mode',$this->sisfar_in_items_mode,true);
$criteria->compare('t.sisfar_in_items_created_by',$this->sisfar_in_items_created_by);
//$criteria->compare('t.sisfar_in_items_created_ts',$this->sisfar_in_items_created_ts,true);
$criteria->compare('t.sisfar_in_items_modified_by',$this->sisfar_in_items_modified_by);
$criteria->compare('t.sisfar_in_items_modified_ts',$this->sisfar_in_items_modified_ts,true);
$criteria->compare('customers.sisfar_customers_name',$this->sisfar_customers_name, true);
$criteria->compare('t.sisfar_in_items_created_ts','>'.$this->created_from, true);
$criteria->compare('t.sisfar_in_items_created_ts','<'.$this->created_till, true);
$criteria->with = array('customers');
//$criteria->together = true;
//$criteria->addBetweenCondition('sisfar_in_items_created_ts', $this->created_from, $this->created_till);
return new CActiveDataProvider($this, array(
'criteria'=>$criteria,
'sort'=>array(
'attributes'=>array(
'sisfar_customers_name'=>array(
'asc'=>'customers.sisfar_customers_name',
'desc'=>'customers.sisfar_customers_name DESC',
),
'*',
),
),
));
}
}
advanced search form code:
<div class="wide form">
<?php $form=$this->beginWidget('CActiveForm', array(
'action'=>Yii::app()->createUrl($this->route),
'method'=>'get',
)); ?>
<div class="row">
<?php echo $form->label($model,'sisfar_in_items_xml_id'); ?>
<?php echo $form->textField($model,'sisfar_in_items_xml_id'); ?>
</div>
<div class="row">
<?php echo $form->label($model,'sisfar_in_items_ips_mailitm_pid'); ?>
<?php echo $form->textField($model,'sisfar_in_items_ips_mailitm_pid',array('size'=>50,'maxlength'=>50)); ?>
</div>
<div class="row">
<?php echo $form->label($model,'sisfar_in_items_ItemId'); ?>
<?php echo $form->textField($model,'sisfar_in_items_ItemId',array('size'=>50,'maxlength'=>50)); ?>
</div>
<div class="row">
<?php echo $form->label($model,'sisfar_in_items_mode'); ?>
<?php echo $form->textField($model,'sisfar_in_items_mode',array('size'=>1,'maxlength'=>1)); ?>
</div>
<div class="row">
<?php echo $form->label($model,'sisfar_in_items_created_ts'); ?>
<?php echo $form->textField($model,'sisfar_in_items_created_ts'); ?>
</div>
<div class="row">
<?php echo $form->label($model,'sisfar_customers_name'); ?>
<?php echo $form->textField($model,'sisfar_customers_name'); ?>
</div>
<div class="row">
<?php echo $form->label($model,'created_from'); ?>
<?php echo $form->textField($model,'created_from'); ?>
</div>
<div class="row">
<?php echo $form->label($model,'created_till'); ?>
<?php echo $form->textField($model,'created_till'); ?>
</div>
<div class="row buttons">
<?php echo CHtml::submitButton('Search'); ?>
</div>
<?php $this->endWidget(); ?>
</div><!-- search-form -->
full admin view code:
<?php
$this->breadcrumbs=array(
'Sisfar In Items2s'=>array('index'),
'Manage',
);
$this->menu=array(
array('label'=>'List SisfarInItems2', 'url'=>array('index')),
array('label'=>'Create SisfarInItems2', 'url'=>array('create')),
);
Yii::app()->clientScript->registerScript('search', "
$('.search-button').click(function(){
$('.search-form').toggle();
return false;
});
$('.search-form form').submit(function(){
$.fn.yiiGridView.update('sisfar-in-items2-grid', {
data: $(this).serialize()
});
return false;
});
");
?>
<h1>Manage Sisfar In Items2s</h1>
<p>
You may optionally enter a comparison operator (<b><</b>, <b><=</b>, <b>></b>, <b>>=</b>, <b><></b>
or <b>=</b>) at the beginning of each of your search values to specify how the comparison should be done.
</p>
<?php echo CHtml::link('Advanced Search','#',array('class'=>'search-button')); ?>
<div class="search-form" style="display:none">
<?php $this->renderPartial('_search',array(
'model'=>$model,
)); ?>
</div><!-- search-form -->
<?php $this->widget('zii.widgets.grid.CGridView', array(
'id'=>'sisfar-in-items2-grid',
'dataProvider'=>$model->search(),
'filter'=>$model,
'columns'=>array(
'sisfar_in_items_xml_id',
'sisfar_in_items_ItemId',
'sisfar_in_items_mode',
array(
'name' => 'sisfar_customers_name',
'value' => '$data->customers->sisfar_customers_name',
),
'sisfar_in_items_created_ts',
'sisfar_in_items_modified_ts',
),
)); ?>