有关zentaophp框架的一个sql语句方法
- WBOY原创
- 2016-07-06 13:54:161387浏览
<code>php</code><code>return $this->dao->select('id,amount,dept,signedBy,begin,end,bourse,openBank')->from(TABLE_CONTRACT)
->where('deleted')->eq(0)
->beginIF($mode=='bysearch')->andWhere('begin','between',$startDate,$endDate)
->orWhere('end')->between($startDate,$endDate)
->fi()
->beginIF($dept)
->andWhere('dept')->eq($dept)
->fi()
// ->groupBy($groupBy)
->orderBy($orderBy)
->fetchAll();
</code>
这段代码能够生成这样的sql
<code>sql</code><code>SELECT id,amount,dept,signedBy,begin,end,bourse,openBank FROM `crm_contract` wHeRe deleted = '0' AND dept = '820011' AND begin BETWEEN '2015-03-01' AND '2015-03-31' OR end BETWEEN '2015-03-01' AND '2015-03-31' oRdEr bY `signedBy` desc,`amount` desc </code>
对上面的orm语句如何书写才能形成下列的SQL语句
<code>sql</code><code>id,amount,dept,signedBy,begin,end,bourse,openBank FROM `crm_contract` wHeRe deleted = '0' AND dept = '820011' AND (begin BETWEEN '2015-03-01' AND '2015-03-31' OR end BETWEEN '2015-03-01' AND '2015-03-31' ) oRdEr bY `signedBy` desc,`amount` desc </code>
简单说明就是在begin和end两个where条件外面加上括号该怎么处理？
回复内容：
<code>php</code><code>return $this->dao->select('id,amount,dept,signedBy,begin,end,bourse,openBank')->from(TABLE_CONTRACT)
->where('deleted')->eq(0)
->beginIF($mode=='bysearch')->andWhere('begin','between',$startDate,$endDate)
->orWhere('end')->between($startDate,$endDate)
->fi()
->beginIF($dept)
->andWhere('dept')->eq($dept)
->fi()
// ->groupBy($groupBy)
->orderBy($orderBy)
->fetchAll();
</code>
这段代码能够生成这样的sql
<code>sql</code><code>SELECT id,amount,dept,signedBy,begin,end,bourse,openBank FROM `crm_contract` wHeRe deleted = '0' AND dept = '820011' AND begin BETWEEN '2015-03-01' AND '2015-03-31' OR end BETWEEN '2015-03-01' AND '2015-03-31' oRdEr bY `signedBy` desc,`amount` desc </code>
对上面的orm语句如何书写才能形成下列的SQL语句
<code>sql</code><code>id,amount,dept,signedBy,begin,end,bourse,openBank FROM `crm_contract` wHeRe deleted = '0' AND dept = '820011' AND (begin BETWEEN '2015-03-01' AND '2015-03-31' OR end BETWEEN '2015-03-01' AND '2015-03-31' ) oRdEr bY `signedBy` desc,`amount` desc </code>
简单说明就是在begin和end两个where条件外面加上括号该怎么处理？
声明：
本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn