Cdbcriteria With Params

Hi everybody.

i have a search form like this in admin.php

4174

Capture.PNG

in sql this query works fine,




SELECT * FROM pendapatan_baru WHERE tanggal BETWEEN '$tgl_awal' AND '$tgl_akhir' AND id = '$kd_dokter' AND unit_pelaksanaa LIKE '%$kd_pelayanan%'



how to parsing params to model.php??

or anyone has a idea how to use params combination with a CDbCriteria?

sorry to my bad english. . .


$criteria=new CDbCriteria;

$criteria->addBetweenCondition('tanggal',$tgl_awal,$tgl_akhir,'AND');

$criteria->addCondition('id',$kd_dokter);

$criteria->addSearchCondition('unit_pelaksanaa', $kd_pelayanan);