Yii CDbCriteria加入 [英] Yii CDbCriteria Join
本文介绍了Yii CDbCriteria加入的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何编写查询
SELECT *
FROM doc_docs dd
JOIN doc_access da
在dd.id = da.doc_id
和da.user_id = 7
解决方案
使用 CDbCriteria
语法吗?
解决方案
必须将条件应用于ActiveRecord模型以获取主表,但是假设您具有DocDocs模型,则可以这样操作:
$ oDBC =新的CDbCriteria();
$ oDBC-> join ='LEFT JOIN doc_access a ON t.id = a.doc_id and a.user_id = 7';
$ aRecords = DocDocs :: model()-> findAll($ oDBC);
尽管如果您为DocDocs模型提供与doc_access的关系可能会容易得多,不必使用dbcriteria:
类DocDocs扩展了CActiveRecord
{
...
公共功能关系()
{
return array('access'=> array(self :: HAS_MANY,'DocAccess','doc_id');
}
...
}
$ oDocDocs =新的DocDocs;
$ oDocDocs-> id = 7;
$ aRecords = $ oDocDocs-> access;
应该为您提供一个非常好的主意...
How I can write the query
SELECT *
FROM doc_docs dd
JOIN doc_access da
ON dd.id=da.doc_id
AND da.user_id=7
with CDbCriteria
syntax?
解决方案
You actually cant completely write that since you have to apply the criteria to an activerecord model to obtain the primary table, but assuming you have a DocDocs model you can do it like this:
$oDBC = new CDbCriteria();
$oDBC->join = 'LEFT JOIN doc_access a ON t.id = a.doc_id and a.user_id = 7';
$aRecords = DocDocs::model()->findAll($oDBC);
Although it might be a lot easier if you give your DocDocs model a relation with doc_access, then you don't have to use the dbcriteria:
class DocDocs extends CActiveRecord
{
...
public function relations()
{
return array('access' => array(self::HAS_MANY, 'DocAccess', 'doc_id');
}
...
}
$oDocDocs = new DocDocs;
$oDocDocs->id = 7;
$aRecords = $oDocDocs->access;
Should give you a fairly good idea how to start...
这篇关于Yii CDbCriteria加入的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文