queryByCondition

select 
@pageTag(){
t.*
@}
from xzx_order_batch_info t
where 1=1  
@//数据权限，该sql语句功能点,如果不考虑数据权限，可以删除此行  
and #function("xzxOrderBatchInfo")#

batchDelXzxOrderBatchInfoByIds

• 批量逻辑删除
  update xzx_order_batch_info set del_flag = 1 where bacth_no in( #join(ids)#)

queryBatchInfoDetailList

select a.create_time as createtime,a.weight as cweight,(select c.weight from xzx_user_vehicle_info c where c.id = #vehicleId# ) as vweight,'0' as orderId 
from xzx_order_clock_in_info a where a.user_id =#userId# and a.vehicle_id=#vehicleId#
 @if(!isEmpty(weightError)){
     AND a.weight-(select c.weight from xzx_user_vehicle_info c where c.id = #vehicleId#)>=#weightError#
 @}
 @if(!isEmpty(startTime)){
          AND a.create_time>=#startTime#
 @}
 @if(!isEmpty(endTime)){
          AND a.create_time<=#endTime#
 @}    
union all
select b.create_time as createtime, b.weight as bweight,(select c.weight from xzx_user_vehicle_info c where c.id = #vehicleId# ) as vweight,
         b.order_id as orderId from xzx_order_batch_info b where b.user_id=#userId# and b.vehicle_id=#vehicleId#
          @if(!isEmpty(weightError)){
                  AND b.weight-(select c.weight from xzx_user_vehicle_info c where c.id = #vehicleId#)>=#weightError#
              @}
              @if(!isEmpty(startTime)){
                       AND b.create_time>=#startTime#
              @}
              @if(!isEmpty(endTime)){
                       AND b.create_time<=#endTime#
              @}    
limit #page#, #limit#

queryBatchInfoDetailCount

select sum(count) from(
select count(1) as count
from xzx_order_clock_in_info a where a.user_id =#userId# and a.vehicle_id=#vehicleId#
 @if(!isEmpty(weightError)){
         AND a.weight-(select c.weight from xzx_user_vehicle_info c where c.id = #vehicleId#)>=#weightError#
     @}
     @if(!isEmpty(startTime)){
              AND a.create_time>=#startTime#
     @}
     @if(!isEmpty(endTime)){
              AND a.create_time<=#endTime#
     @}
union all
select count(1) as count from xzx_order_batch_info b where b.user_id=#userId# and b.vehicle_id=#vehicleId# 
 @if(!isEmpty(weightError)){
         AND b.weight-(select c.weight from xzx_user_vehicle_info c where c.id = #vehicleId#)>=#weightError#
     @}
     @if(!isEmpty(startTime)){
              AND b.create_time>=#startTime#
     @}
     @if(!isEmpty(endTime)){
              AND b.create_time<=#endTime#
     @}
     ) c

queryClockDetailList

select a.create_time as createtime,a.weight as cweight,(select c.weight from xzx_user_vehicle_info c where c.id = #vehicleId# ) as vweight,'0' as orderId 
from xzx_order_clock_in_info a where a.user_id =#userId# and a.vehicle_id=#vehicleId#
 @if(!isEmpty(weightError)){
     AND b.weight-(select c.weight from xzx_user_vehicle_info c where c.id = #vehicleId#)>=#weightError#
 @}
 @if(!isEmpty(startTime)){
          AND a.create_time>=#startTime#
 @}
 @if(!isEmpty(endTime)){
          AND a.create_time<=#endTime#
 @}        
limit #page#, #limit#

queryBatchDetailList

select b.create_time as createtime, b.weight as bweight,(select c.weight from xzx_user_vehicle_info c where c.id = #vehicleId# ) as vweight,
             b.order_id as orderId from xzx_order_batch_info b where b.user_id=#userId# and b.vehicle_id=#vehicleId#
              @if(!isEmpty(weightError)){
                      AND b.weight-(select c.weight from xzx_user_vehicle_info c where c.id = #vehicleId#)>=#weightError#
                  @}
                  @if(!isEmpty(startTime)){
                           AND b.create_time>=#startTime#
                  @}
                  @if(!isEmpty(endTime)){
                           AND b.create_time<=#endTime#
                  @}        
limit #page#, #limit#

queryClockDetailCount

select sum(count) from(
select count(1) as count from xzx_order_batch_info b where b.user_id=#userId# and b.vehicle_id=#vehicleId# 
     @if(!isEmpty(weightError)){
             AND b.weight-(select c.weight from xzx_user_vehicle_info c where c.id = #vehicleId#)>=#weightError#
         @}
         @if(!isEmpty(startTime)){
                  AND b.create_time>=#startTime#
         @}
         @if(!isEmpty(endTime)){
                  AND b.create_time<=#endTime#
         @}
     ) c   

queryBatchDetailCount

select sum(count) from(
select count(1) as count
from xzx_order_clock_in_info a where a.user_id =#userId# and a.vehicle_id=#vehicleId#
 @if(!isEmpty(weightError)){
         AND b.weight-(select c.weight from xzx_user_vehicle_info c where c.id = #vehicleId#)>=#weightError#
     @}
     @if(!isEmpty(startTime)){
              AND a.create_time>=#startTime#
     @}
     @if(!isEmpty(endTime)){
              AND a.create_time<=#endTime#
     @}
     ) c  

queryEmptyWeight

select a.create_time as createtime,a.weight as cweight,(select c.weight from xzx_user_vehicle_info c where c.id = #vehicleId# ) as vweight,'0' as orderId 
    from xzx_order_clock_in_info a where a.user_id =#userId# and a.vehicle_id=#vehicleId#
     @if(!isEmpty(weightError)){
         AND a.weight-(select c.weight from xzx_user_vehicle_info c where c.id = #vehicleId#)>=#weightError#
     @}
     @if(!isEmpty(startTime)){
              AND a.create_time>=#startTime#
     @}
     @if(!isEmpty(endTime)){
              AND a.create_time<=#endTime#
     @}
     LIMIT 1