Contoh codenya dibawah ini. kesuliatannya gimana caranya hasil dari $modelUom ini disajikan dalam bentuk CGridView
$sql = "SELECT mis_item_uom.* FROM mis_item_uom WHERE item_code=:item_code ";
$modelUom=Yii::app()->db->createCommand($sql)->queryAll(true,array(":item_code"=>$model->item_code));
Sudah coba pakai CSqlDataProvider tapi belom tau gimana gabungin ke CGridViewnya, … Thanks before pet
$itemCode = $model->item_code;
$sql = "SELECT mis_item_uom.* FROM mis_item_uom WHERE item_code=:item_code ";
$count=Yii::app()->db->createCommand($sql)->execute(true,array(":item_code"=>$itemCode));
$modelUom=Yii::app()->db->createCommand($sql)->queryAll(true,array(":item_code"=>$itemCode));
$dataProvider=new CSqlDataProvider($modelUom, array(
'sort'=>array(
'attributes'=>array(
'uom',
'item_code',
'rate',
'net_weight',
'gross_weight',
'description',
),
),
'pagination'=>array(
'pageSize'=>10,
),
));
Ok sudah bisa
$sql = "SELECT mis_item_uom.* FROM mis_item_uom WHERE item_code='$model->itemCode' ";
$dataProvider=new CSqlDataProvider($sql, array(
'sort'=>array(
'attributes'=>array(
'uom',
'item_code',
'rate',
),
),
'pagination'=>array(
'pageSize'=>10,
),
));
$this->widget('zii.widgets.grid.CGridView', array(
'dataProvider'=>$dataProvider,
'columns'=>array(
'uom','item_code','rate',
)
));
Tq