$f = 'CASEWHEN car_status=4THEN 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();