cakephp 复杂查询

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21

$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'))))