Hello!
First, sorry for my bad english!
Nowy my problem: i’ve a XML db, i’ve used CArrayDataProvider after i’ve converted the XML in Object, then i’ve displayed it with CGridView. Oh yeah!
But i have a problem with sorting date. The date format is timestamp. The results order are like this:
1295391600
1290553200
1296428400
1295996400
1288216800
1298588400
…
Why?
$dataProvider=new CArrayDataProvider($records, array(
'keyField' => 'Id_Ass',
'id'=>'assenze',
'pagination'=>array(
'pageSize'=>15,
),
'sort'=>array(
'defaultOrder'=>array(
'DATA'=>'desc'
),
'attributes'=>array(
'DATA',
),
),
));
$this->render('lista',array(
'dataProvider' => $dataProvider
));
<?php
$this->widget('zii.widgets.grid.CGridView', array(
'dataProvider'=>$dataProvider,
'columns'=>array(
array(
'name'=>'DATA',
'header'=>'Data',
//'value'=>'date("d/m/Y", "$data->DATA")',
'htmlOptions'=>array('style'=>'text-align: center; width: 120px'),
),
array(
'name'=>'MATERIA',
'header'=>'Materia',
'htmlOptions'=>array('style'=>'text-align: center; width: 130px'),
),
array(
'name'=>'MOTIVO_x0020_-_x0020_NOTE',
'header'=>'Note',
'htmlOptions'=>array('style'=>'text-align: center;'),
),
),
));
?>