Yii CDbCriteria加入 [英] Yii CDbCriteria Join

问题描述

如何编写查询

  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屋！