| | |
| | | /** 每日过磅统计(自动称重记录) */ |
| | | @Select("select date_format(first_weight_time, '%Y-%m-%d') as statDate, " |
| | | + "count(*) as tripCount, " |
| | | + "ifnull(sum(net_weight), 0) / 1000 as cargoVolume, " |
| | | + "ifnull(sum(net_weight), 0) as cargoVolume, " |
| | | + "ifnull(avg(order_deviation), 0) as deviationRate, " |
| | | + "sum(case when cheat_flag = '1' then 1 else 0 end) as cheatCount " |
| | | + "from wrzs_weighbridge_record " |
| | |
| | | + "sum(case when appointment_time is not null and first_weight_time > appointment_time then 1 else 0 end) as lateTrips, " |
| | | + "sum(case when cheat_flag = '1' then 1 else 0 end) as cheatCount, " |
| | | + "ifnull(avg(order_deviation), 0) as avgDeviation, " |
| | | + "ifnull(sum(net_weight), 0) / 1000 as totalNetWeight " |
| | | + "ifnull(sum(net_weight), 0) as totalNetWeight " |
| | | + "from wrzs_weighbridge_record " |
| | | + "where weigh_status = '2' and first_weight_time between #{start} and #{end} " |
| | | + "and carrier_name is not null and carrier_name <> '' " |
| | |
| | | |
| | | /** 区间总览 */ |
| | | @Select("select count(*) as totalTrips, " |
| | | + "ifnull(sum(net_weight), 0) / 1000 as totalNetWeight, " |
| | | + "ifnull(sum(net_weight), 0) as totalNetWeight, " |
| | | + "ifnull(avg(order_deviation), 0) as avgDeviation, " |
| | | + "sum(case when cheat_flag = '1' then 1 else 0 end) as cheatCount, " |
| | | + "sum(case when appointment_time is not null and first_weight_time <= appointment_time then 1 else 0 end) as onTimeTrips, " |