queryByCondition

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

queryByConditionByMap

select 
@pageTag(){
t.*,a.weight as vehicleWeight,(select b.name from xzx_user_other_info b where t.user_id=b.user_id) as name
@}
from xzx_order_clock_in_info t,xzx_user_vehicle_info a
where 1=1 and t.vehicle_id=a.id     

queryByConditionList

SELECT 
   t.*,a.vehicle_no as vehicleNo,a.weight AS vehicleWeight,(SELECT b.name FROM xzx_user_other_info b WHERE t.user_id=b.user_id) AS name
FROM xzx_order_clock_in_info t,xzx_user_vehicle_info a,xzx_user_other_info c
WHERE 1=1 
 AND t.vehicle_id=a.id and t.user_id = c.user_id    
 @if(!isEmpty(weightError)){
                AND (t.weight-a.weight) >= #weightError#
            @}  
         @if(!isEmpty(name)){
                AND c.name  LIKE #'%'+name+'%'#
            @}        
         @if(!isEmpty(startTime)){
                AND t.create_time >= #startTime#
             @}
             @if(!isEmpty(endTime)){
                                 AND t.create_time <=  #endTime#
                              @}
       @if(!isEmpty(partnerIds)){
                           AND c.partner_id in ( #join(partnerIds)# )
                       @}                        
         @pageIgnoreTag(){
                 order by t.create_time desc
             @}
LIMIT #page#, #limit#

queryByConditionListCount

SELECT COUNT(t.id)
FROM xzx_order_clock_in_info t,xzx_user_vehicle_info a,xzx_user_other_info c
WHERE 1=1 AND t.vehicle_id=a.id    and t.user_id = c.user_id 
       @if(!isEmpty(weightError)){
              AND (t.weight-a.weight) >= #weightError#
          @}  
       @if(!isEmpty(name)){
              AND c.name LIKE #'%'+name+'%'#
          @}        
        @if(!isEmpty(startTime)){
               AND t.create_time >= #startTime# 
          @}
        @if(!isEmpty(endTime)){
               AND t.create_time <=  #endTime#
          @}
          @if(!isEmpty(partnerIds)){
                                         AND c.partner_id in ( #join(partnerIds)# )
                                     @}   

batchDelXzxOrderClockInInfoByIds

• 批量逻辑删除

  update xzx_order_clock_in_info set del_flag = 1 where id in( #join(ids)#)