Para master Yii… ane mau minta tolong gimana caranya menampilkan nama_kabupaten melalui ControllerDesa ke CGridview
kalau melalui query biasa seperti ini:
select a.nama_desa,b.nama_kecamatan,c.nama_kabupaten
from cs_desa a
inner join cs_kecamatan b on b.idkecamatan=a.idkecamatan
inner join cs_kabupaten c on c.idkabupaten=b.idkabupaten
berikut penampakan tabel relasinya (dalam attachment)
terima kasih sebelumnya…
Angela88
(Angela Arrie)
January 19, 2012, 11:06am
2
$criteria=new CDbCriteria;
$criteria->join.='inner join cs_kecamatan b on b.idkecamatan=a.idkecamatan';
$criteria->join.=' inner join cs_kabupaten c on c.idkabupaten=b.idkabupaten';
$criteria->select = 't.nama_desa,b.nama_kecamatan,c.nama_kabupaten';
return new CActiveDataProvider('NamaModel', array(
'criteria'=>$criteria,
));
terima kasih sista…akhirnya ada yg jawab.
cuma sekarang yang jadi masalah saya belum bisa nampilkan di CGridview
array('name'=>'nama_kecamatan',
'header'=>'Kecamatan',
'type' => 'raw',
'value'=>'$data->nama_kecamatan',
),
pesan errornya seperti ini:
Angela88
(Angela Arrie)
January 31, 2012, 2:10am
4
kalo kaya gini bisa ga???
array('name'=>'b.nama_kecamatan',
'header'=>'Kecamatan',
'type' => 'raw',
),
belum bisa juga sista…
pesen errornya seperti ini:
Angela88
(Angela Arrie)
January 31, 2012, 6:51am
6
t4 q kaya gini jadi…
model
public function device($id_content){
$criteria = new CDbCriteria;
$criteria->select = 'device.name, t.id_device, t.date_last_update, t.id_content_device, t.id_download, download.name';
$criteria->condition = 't.id_content = '.$id_content;
$criteria->join = 'LEFT JOIN download on t.id_download = download.id_download';
$criteria->join .= ' LEFT outer JOIN device on t.id_device = device.id_device';
$count=Yii::app()->db->createCommand("select count(id_device) from content_device where id_content = $id_content")->queryScalar();
return new CActiveDataProvider('ContentDevice', array(
'criteria'=>$criteria,
'pagination'=>array(
'pageSize'=>$count,
),
));
}
gridview
<?php $this->widget('zii.widgets.grid.CGridView', array(
'dataProvider'=>$model->device($model->id_content),
'enablePagination'=>false,
'columns'=>array(
//'download.name',
array(
'name'=>'download.name',
'header'=>'Download Name',
),
'device.name',
array(
'name'=>'status',
'type'=>'raw',
'value'=>'MMS::model("util")->getStatus($data->status)',
),
),
)); ?>
coba typenya diilangin…