<?
$model = Yii::app()->db->createCommand("SELECT Kode_Bahan,CONCAT(kj.Ket,' ',kb.Ket,' ',if(ka.Kode <> 'XX',ka.ket,''), if(ka.Kode = 'XX','',' '),if(kw.Kode <> 'XX',kw.ket,''),if(kw.Kode = 'XX','',' '),if(kf.Kode <> 'XX',kf.ket,''), if(kf.Kode = 'XX','',' '),if(kg.Kode <> 'X',kg.ket,''),if(kg.kode='X','','')) AS Nama_Bahan,Batas_Harga_Beli_Atas,Batas_Harga_Beli_BAwah,kj.Ket As Jenis,if(ka.Kode <> 'XX',ka.ket,'') AS Aplikasi, b.kategori AS Kode_Kategori, kat.kategori FROM nama_bahan b INNER JOIN kode_jenis_bahan kj INNER JOIN kode_bentuk_bahan kb INNER JOIN kode_aplikasi_bahan ka INNER JOIN kode_Warna_Bahan kw INNER JOIN kode_fitur_bahan kf INNER JOIN kode_grade_bahan kg ON LEFT(Kode_Bahan,4) = kj.Kode AND MID(Kode_Bahan,6,1) = kb.kode AND MID(kode_Bahan,8,2) = ka.Kode AND MID(Kode_Bahan,11,2) = kw.Kode AND MID(Kode_Bahan,14,2) = kf.Kode AND MID(Kode_Bahan,17,1) = kg.kode LEFT JOIN kategori_bahan kat ON b.kategori = kat.kode")->queryAll();
$this->widget('bootstrap.widgets.TbGridView', array(
    'dataProvider' => new CArrayDataProvider($model->detFpb, array('keyField'=>'Notrans_FPB')),
    'columns' => array(
        array(
            'header'=>'Nama Bahan',
            'value'=>'Nama_Bahan',
        ),
        array(
            'header'=>'Kode Bahan',
            'name'=>'KoHan',
            'value'=>'$data->KoHan',
        ),
        array(
            'header'=>'Quantity',
            'name'=>'Jml',
            'value'=>'number_format($data->Jml)',
        ),
        array(
            'header'=>'Harga Satuan',
            'name'=>'Harga_Beli',
            'value'=>'number_format($data->Harga_Beli)',

        ),
        array(
            'header'=>'Jumlah',
            'value'=>'number_format($data->Jml * $data->Harga_Beli)',
            'htmlOptions' => array("width" => "50px", 'style' => 'text-align: right;'),
        ),
    ),
));


?>