(Solved) Bermasalah Saat Render Tabel Menggunakan Pure Sql

[fahmi.k.darmawan]

Assalamualaikum

gan saya kan di controller pake sql kayak gini

public function actionTabel5122S1(){

    $dataProvider=array();


    //$sql = 'SELECT * FROM mata_kuliah';


     $sql = ('Select * FROM mata_kuliah where kode LIKE "___1%" OR kode LIKE "___2%"


          OR kode LIKE "___3%" OR kode LIKE "___4%"


            GROUP BY id order by semester ASC');


     $sum_bobot_sks = Yii::app()->db->createCommand('Select SUM(bobot_sks) FROM mata_kuliah where kode LIKE "___1%" OR kode LIKE "___2%"


            OR kode LIKE "___3%" OR kode LIKE "___4%"


            ')->queryScalar();


        $sum_sks_inti = Yii::app()->db->createCommand('Select SUM(SKS_inti) FROM mata_kuliah where kode LIKE "___1%" OR kode LIKE "___2%"


            OR kode LIKE "___3%" OR kode LIKE "___4%"


            ')->queryScalar();


        $dataProvider=new CSqlDataProvider(array($sql, $sum_bobot_sks, $sum_sks_inti,array('keyField'=>'id')));


        return $dataProvider;


    $this->render('../tabelS1/tabel5122', array('dataProvider'=>$dataProvider));


}

terus di render di view/tabelS1/tabel5122.php yang isinya kayak gini

<?php

foreach($dataProvider->getData() as $dat=>$data) { ?>


<tr>


  <td><?php echo $data['semester']; ?></td>


  <td><?php echo $data['kode']; ?></td>


  <td><?php echo $data['nama']; ?></td>


  <td><?php echo $data['sistem_kredit_semester']; ?></td>


  <td></td>


  <?php } ?>

pas ngeklik ke menu tabel5122 kok gak muncul apa-apa ya (di browser kayak blank page gitu). Mohon penjelasannya. Makasih ya para master. Ilmu yang dishare sangat bermanfaat

[fahmi.k.darmawan]

SOLVED!

di model buat kayak gini

$criteria = new CDbCriteria;

    $criteria->condition = "kode LIKE concat (:kode, '___1%') OR kode LIKE concat (:kode, '___2%')


        OR kode LIKE concat (:kode, '___3%')


        OR kode LIKE concat (:kode, '___4%')";


    $criteria->params = array(':kode'=>  MataKuliah::model()->getAttribute('kode'). '%');


    return $this->model()->findAll($criteria);

terus di Contoller buat kayak gini

public function actionTabel5122S1(){

    $dataProvider = MataKuliah::model()->tabel5122S1();


    $this->render('../tabelS1/tabel5122', array('dataProvider'=>$dataProvider));


}

render tabelnya kayak gini

<?php

foreach($dataProvider as $data) { ?>


<tr>


  <td><?php echo $data['semester']; ?></td>


  <td><?php echo $data['kode']; ?></td>


  <td><?php echo $data['nama']; ?></td>


  <td><?php echo $data['sistem_kredit_semester']; ?></td>

<?php } ?>