代码之家 › 专栏 › 技术社区 › moh

yii2 right sql命令来执行我的查询

yii2

moh · 技术社区 · 7 年前

我正在尝试从 user_request_wallet 表中lead_developer=?然后回答什么?或者是?我想加入 mainRequest

它应该怎么指挥???

我试了两种方法,但没有成功

//$model = UserRequestWallet::find()->Where(['and',['lead_developer' => $getUser]])
//->andWhere(['and',['answer_tocall' => 'accepted']])
//->andWhere(['or',['answer_tocall' => 'putonhold']])
//->joinWith('mainRequest');

$model = (new \yii\db\Query())
->select('*')
->from('user_request_wallet')
->andwhere(['lead_developer'=> $getUser])->andWhere(['answer_tocall' => 'accepted'])
->orWhere(['answer_tocall'=>'putonhold'])->leftJoin('mainRequest');

Exception (Database Exception) 'yii\db\Exception' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE ((`lead_developer`=7) AND (`answer_tocall`='accepted')) OR (`answer_tocall' at line 1

正在执行的SQL是:

SELECT COUNT(*) FROM `user_request_wallet` LEFT JOIN `mainRequest` WHERE ((`lead_developer`=7) AND (`answer_tocall`='accepted')) OR (`answer_tocall`='putonhold')

3 回复 | 直到 7 年前

Insane Skull 7 年前

$model = UserRequestWallet::find()
        ->with('mainRequest')
        ->where(['lead_developer' => $getUser])
        ->andWhere([
            'OR',
            ['answer_tocall' => 'accepted'],
            ['answer_tocall' => 'putonhold'],
        ])
        ->all();

Paul 7 年前

这就是工作

$model = UserRequestWallet::find()
    ->where(['lead_developer' => $getUser])
    ->andWhere(['or', 'answer_tocall = accepted', 'answer_tocall = putonhold'])
    ->joinWith('mainRequest');

vityapro 7 年前

根据 documentation leftJoin( $table, $on = '', $params = [] ) 如果你想使用 static method find() joinWith(['relationName']) 属于 ActiveRecords documentation .

推荐文章

SkarabePL · Yii2依赖注入、配置和继承

6 年前

tklustig · 如何获得更广泛的工具提示输出

6 年前

user759235 · yii2,检查输入时使用模型规则

6 年前

Masoud92m · Yii2表单验证-仅在填写密码字段时比较密码重复

6 年前

ZULI · Yii2:将手机掩码显示为文本

6 年前

TheStoryCoder · Yii2:是否在事务外部执行查询?

6 年前

Vadzim Yatskevich · groupBy()方法给出空结果Yii2

6 年前

Toma Tomov · Yii2 GridView操作列不发送post参数

6 年前

arun webber · Yii2:将原始查询转换为ActiveRecord

6 年前

Moeez · Yii2如何将接收到的JSON数据保存到数据库中

6 年前