When sorted by the third column, $11.00 comes between $109.00 and $110.00
1009 Item Z $109.00
1076 Item N $11.00
1079 Item A $11.00
1099 Item X $110.00
I’ve been searching forums, reading docs and google too for quite a while. I apologize if it’s been answered before. Is this obvious to anyone what I’m doing wrong? THANKS IN ADVANCE
my view
$this->widget('zii.widgets.grid.CGridView',
array(
'id'=>'exchange-gridview',
'enablePagination'=>true,
'dataProvider'=>$dataProvider,
'summaryText'=> '<b>Please click on the item number from this list of eligible products</b>',
'columns'=>array(
array(
'name' => 'sku',
'header' => 'Item No.',
'value' => 'makeLinkBack($data->sku,"' . $shortName . '","' . $row . '");',
'htmlOptions' => array('class'=>'leftAlign', 'style' => 'width:15%'),
'headerHtmlOptions' => array('style'=>'text-align:left; margin-left:5px;'),
),
array(
'name' => 'pname',
'header' => 'Product Name',
'value' => 'ucwords($data->pname);',
'htmlOptions' => array('class'=>'leftAlign', 'style' => 'width:65%'),
'headerHtmlOptions' => array('style'=>'text-align:left; margin-left:5px;'),
),
array(
'name' => 'price',
'header' => 'Price',
'value' => 'CustomerController::makeMoney($data->price);' ,
'htmlOptions' => array('class'=>'leftAlign', 'style' => 'width:20%'),
'headerHtmlOptions' => array('style'=>'text-align:left; margin-left:5px;'),
),
),
));
Dataprovider setup in controller
$criteria=new CDbCriteria;
$ltypeCriteria = "%" . $ntype . "%";
$criteria->condition = "ntype like :ltype";
$criteria->params = array(":ntype" => $ntypeCriteria);
$dataProvider = new CActiveDataProvider("Product",
array(
'criteria' => $criteria,
'pagination' => array(
'pageSize' => 20
),
));