CODEWITHSUNDEEP
mysqlyii
deib97
deib97

Reputation: 35

How to convert my query to CDbCriteria with AND condition?

How to convert custom query into CDbCriteria in YIi. I have try like this, maybe not complete:

 $criteria=new CDbCriteria;
 $criteria->select='t.kode, t.status, p.berlaku_punish AS p_berlakupunish,p.nilai AS p_nilai';
 $criteria->join = 'LEFT JOIN punish p ON (p.id_status = t.id)';

 myquery : `$sql="SELECT status.id, status.kode, status.status, m1.berlaku_punish, m1.nilai
    FROM STATUS LEFT JOIN punish m1 ON status.id = m1.id_status
    AND m1.id = ( SELECT MAX( m2.id ) FROM punish m2 WHERE m2.id_status = status.id)";`

How to insert AND in myquery into my custom not complete CDbCriteria ?? Sory,about my english.

Upvotes: 0

Views: 170

Answers (1)

Sabit Huraira
Sabit Huraira

Reputation: 307

You can use addCondition like this:

$criteria->addCondition("function_id =ur_value");
$criteria->addCondition("legal_id =ur_value");

It will define where function_id=ur_value and legal_id=ur_value

or you can use condition like this:

$criteria->condition="function_id=ur_value AND legal_id=ur_value";

Upvotes: 1

Related Questions