Hello
I am Ashish Gupta.I am new in yii framework. I am doing a project where I am facing problem during search. I am sharing code for search action in model, gridview code and search form code. I am getting error (Error 500 <h1>PHP ERROR(8)use of undefined constant.).I am using drop down list for search which is based on foreign key relationship. In main table only numeric id going to store. Please help me to understand the error with solution.
My search function in model class
public function search()
{
// @todo Please modify the following code to remove attributes that should not be searched.
$criteria=new CDbCriteria;
$criteria->compare('fname',$this->fname,true);
$criteria->compare('lname',$this->lname,true);
$criteria->compare('username',$this->username,true);
$criteria->compare('password',$this->password,true);
$criteria->compare('email',$this->email,true);
$criteria->compare('status_id',$this->status_id,true);
$criteria->compare('pkg_id',$this->pkg_id,true);
$criteria->compare('active_date',$this->active_date,true);
$criteria->compare('deactive_date',$this->deactive_date,true);
return new CActiveDataProvider($this, array(
'criteria'=>$criteria,
));
}
my view file which display gridview formate
<?php
/* @var $this AdminUserController */
/* @var $model AdminUser */
$this->breadcrumbs=array(
'Admin Users'=>array('index'),
'Manage',
);
$this->menu=array(
array('label'=>'List AdminUser', 'url'=>array('index')),
array('label'=>'Create AdminUser', 'url'=>array('create')),
array('label'=>'Manage AdminUser Contact', 'url'=>array('adminUserContact/admin')),
);
Yii::app()->clientScript->registerScript(‘search’, "
$(’.search-button’).click(function(){
$('.search-form').toggle();
return false;
});
$(’.search-form form’).submit(function(){
$('#admin-user-grid').yiiGridView('update', {
data: $(this).serialize()
});
return false;
});
");
?>
<h1>Manage Admin Users</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'=>'admin-user-grid',
'dataProvider'=>$model->search(),
'filter'=>$model,
'columns'=>array(
'fname',
'lname',
'username',
'password',
'email',
array('name'=>'status_id','value'=>CHtml::encode($model->getStatusText())),
array('name'=>'pkg_id','value'=>CHtml::encode($model->getPackageText())),
'active_date',
'deactive_date',
array(
'class'=>'CButtonColumn',
),
),
)); ?>
my search form code which will load by ajax function when advance search is clicked
<?php
/* @var $this AdminUserController */
/* @var $model AdminUser */
/* @var $form CActiveForm */
?>
<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,'fname'); ?>
<?php echo $form->textField($model,'fname',array('size'=>60,'maxlength'=>255)); ?>
</div>
<div class="row">
<?php echo $form->label($model,'lname'); ?>
<?php echo $form->textField($model,'lname',array('size'=>60,'maxlength'=>255)); ?>
</div>
<div class="row">
<?php echo $form->label($model,'username'); ?>
<?php echo $form->textField($model,'username',array('size'=>60,'maxlength'=>255)); ?>
</div>
<div class="row">
<?php echo $form->label($model,'email'); ?>
<?php echo $form->textField($model,'email',array('size'=>60,'maxlength'=>255)); ?>
</div>
<div class="row">
<?php echo $form->label($model,'status_id'); ?>
<?php //echo $form->textField($model,'status_id');
echo $form->dropDownList($model,'status_id',$model->getStatusOption());
?>
</div>
<div class="row">
<?php echo $form->label($model,'pkg_id'); ?>
<?php //echo $form->textField($model,'pkg_id');
echo $form->dropDownList($model,'pkg_id',$model->getPkgOption());
?>
</div>
<div class="row">
<?php echo $form->label($model,'active_date'); ?>
<?php //echo $form->textField($model,'active_date');
$this->widget('zii.widgets.jui.CJuiDatePicker',array(
'model' => $model,
'attribute' => 'active_date',
// additional javascript options for the date picker plugin
'options'=>array(
'dateFormat' => 'yy-mm-dd', // format of "2012-12-25"
'showOtherMonths' => true, // show dates in other months
'selectOtherMonths' => true, // can seelect dates in other months
'changeYear' => true, // can change year
'changeMonth' => true,
'yearRange'=>'2014:2050',
),
'htmlOptions'=>array(
'style'=>'height:20px;',
),
));
?>
</div>
<div class="row">
<?php echo $form->label($model,'deactive_date'); ?>
<?php //echo $form->textField($model,'deactive_date');
$this->widget('zii.widgets.jui.CJuiDatePicker',array(
'model' => $model,
'attribute' => 'deactive_date',
// additional javascript options for the date picker plugin
'options'=>array(
'dateFormat' => 'yy-mm-dd', // format of "2012-12-25"
'showOtherMonths' => true, // show dates in other months
'selectOtherMonths' => true, // can seelect dates in other months
'changeYear' => true, // can change year
'changeMonth' => true,
'yearRange'=>'2014:2050',
),
'htmlOptions'=>array(
'style'=>'height:20px;'
),
));
?>
</div>
<div class="row buttons">
<?php echo CHtml::submitButton('Search'); ?>
</div>
<?php $this->endWidget(); ?>
</div><!-- search-form -->
Fetching text from the table for display purpose.
public function getStatusText()
{
$user=Status::model()->findByAttributes(array('statusid'=>$this->status_id));
return $user['status_name'];
}
public function getPackageText()
{
$user=Package::model()->findByAttributes(array('pkgid'=>$this->pkg_id));
return $user['pkg_name'];
}
Fetching options from the table.
public function getPkgOption()
{
$models = Package::model()->findAll();
$list = CHtml::listData($models,'pkgid', 'pkg_name');
return $list;
}
public function getStatusOption()
{
$models = Status::model()->findAll();
$list = CHtml::listData($models,'statusid', 'status_name');
return $list;
}
Pleas make me understand the error and solution for the error.