YII 高级查询

  $criteria = new CDbCriteria;    
                
                $connection = Yii::app()->db;
                $sql = "SELECT * FROM rah_borrower where jieqingTime BETWEEN '$_mix' and  '$_max'";
                $command = $connection->createCommand($sql);
                $result = $command->queryAll();
                // get foreach and get array
                $_arrayBorrIDs =  array();
                if (isset($result)) {
                    foreach ($result as $user) {
                        $_arrayBorrIDs = array_merge($_arrayBorrIDs, array($user['borrowerID']));
                    }
                    $criteria->addInCondition('borrowerID', $_arrayBorrIDs);
                } else {
                    $criteria->addCondition('0 > 0'); //查无此人
                }                
                //2、在rightMatchb表查询lendInvestID 对应的borrowerID
                $criteria->select = 'sum(matchRightAmt) as matchRightAmt';
                $criteria->addCondition("lendInvestID =$model->lendInvestID");
                $_rightMatch = RightMatch::model()->find($criteria);
                
                echo $_rightMatch->matchRightAmt;