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)#)