$now = time();
$this->CardTypeInfos->recursive = -1;
$conditions = [
‘seller_id‘=>SELLER_ID,
‘del_state‘=>1,
‘or‘=>[
[
‘date_info_type‘=>2,
],
[
‘date_info_type‘=>1,
‘begin >= ‘=>$now,
‘end <= ‘=>$now,
],
]
];
$coupons_list = $this->CardTypeInfos->find(‘list‘, array(‘conditions‘ => $conditions, ‘fields‘ => array(‘id‘, ‘title‘)));
echo $this->debugsql(‘CardTypeInfos‘);
die;
以上代码 sql语句输出 ：SELECT `CardTypeInfos`.`id`, `CardTypeInfos`.`title` FROM `dkh_yunths`.`card_type_infos` AS `CardTypeInfos` WHERE `seller_id` = 1 AND `del_state` = 1 AND ((`date_info_type` = 2) OR (((`date_info_type` = 1) AND (`begin` >= ‘1466497533‘) AND (`end` <= ‘1466497533‘))))
原文：http://www.cnblogs.com/-mrl/p/5604105.html