sql 根据某个字段的条件 选择获取字段

sql 根据某个字段的条件 选择获取字段

做个记录…

    public function getstoreallorder($rid,$starttime,$endtime,$state=5,$where='')    {        // p($rid);        // p($where);        // p($starttime);        // p($endtime);        // p($state);die;        return $this->o->table('mdm_order as o')        ->field("m.photo as memberface,o.coupon_used,o.mobile,o.name as username,o.order_num,o.id as orderid,o.t_name,o.platform,o.price as orderPrice,o.state,p.createtime as paytime,p.type as paytype,sum(p.money) as paymoney,            CASE             WHEN c.ctype = '1' THEN '满减'             WHEN c.ctype = '2' THEN '现金'             WHEN c.ctype = '3' THEN '折扣'             WHEN c.ctype = '4' THEN '送菜'            ELSE '' END,            CASE             WHEN c.ctype = '1' THEN c.m_price             WHEN c.ctype = '2' THEN c.cashprice             WHEN c.ctype = '3' THEN c.dis_price             WHEN c.ctype = '4' THEN c.goodname            ELSE '' END,            od.price as dishPrice,od.num as dishNum")        // ->join('mdm_order       as o    on o.r_id   = r.id')        ->join('mdm_o_d         as od   on od.o_id = o.id')        ->join('mdm_order_pay   as p    on p.o_id  = o.id')        ->join('mdm_coupon      as c    on c.id  = o.coupon_id')        ->join('mdm_r           as r    on r.id    = o.r_id')        ->join('mdm_m           as m    on m.id    = o.m_id')        ->where("o.r_id = '$rid' and (o.state = $state) $where  and o.posttime > $starttime and o.posttime < $endtime")        ->group('od.id')        ->order('o.id desc')        ->select();        // o.name as username,o.createtime,o.overtime,o.t_name,o.order_num,o.price        //  $sql = "SELECT count(IF(platform=1,1,NULL)) as koubei,count(IF(platform=2,1,NULL)) as nuomi,count(IF(platform=3,1,NULL)) as diancaibao,count(IF(platform=4,1,NULL)) as shanghuduan,count(IF(platform=5,1,NULL)) as weixin FROM mdm_order where r_id = $rid AND state = 5 AND overtime > $starttime AND overtime < $endtime";        // return $this->o->query($sql);    }