ThinkPHP的开发技巧

where拼接原生语句

$map['name'] = 'lhs';
$map['_string'] = 'status = 1 and id >10'
原生语句："(name = 'lhs') and ('status = 1 and id >10')"

where复合查询

		//_complex表示和其他条件and关系。
        $search_where["_complex"] = [
            ['apply_type'=>2,'car_status'=>['in',[1,2,3,4]]],
            ['apply_type'=>4,'car_status'=>['in',[1,2,3,4]]],
            ['apply_type'=>12,'car_status'=>['in',[1,2,3,4]]],
            ['apply_type'=>13,'car_status'=>['in',[1,2,3,4,5]]],
            "_logic"=>"OR" //这些条件的关系
        ];

对多个字段的值排序，没有优先级

        $f = 'CASE WHEN car_status=4 THEN b.operate_time ELSE b.carry_time END carry_time_desc,b.id,c.id as car_id,        c.vin,c.plate_number,a.apply_type,carry_time,operate_time,d.type_name,b.transfer_out_warehouse_id,a.in_warehouse_id,
        b.transfer_in_warehouse_id,b.car_status';

        $apply_cars_data = M('application')->alias('a')
            ->join("yck_application_cars as b on a.id = b.apply_id")
            ->join("yck_cars as c on b.car_id = c.id")
            ->join("yck_car_basic_config as d on d.id = c.config_id")
            ->where($where)
            ->limit($start,$lim)
            ->field($f)
            ->order('carry_time_desc desc')
            ->select();