queryStaticData
===
    SELECT IFNULL(e.weight,0) AS weight, IFNULL(e.money,0) AS money ,a.title as config_value_name FROM xzx_sys_environmental_info a 
    LEFT JOIN(
        SELECT SUM(b.money) as money, SUM(b.weight) as weight, b.item_type, b.flag FROM xzx_order_storage_info c 
        LEFT JOIN xzx_order_storage_detail b ON c.storage_id=b.storage_id
        WHERE b.flag=#flag# GROUP BY b.item_type
    ) e ON e.item_type = a.item_type
    WHERE a.del_flag=0 and a.parent_id is NOT NULL;
    
queryStaticDataToday
===
    SELECT IFNULL(e.weight,0) AS weight, IFNULL(e.money,0) AS money ,a.title as config_value_name  FROM xzx_sys_environmental_info a 
    LEFT JOIN(
        SELECT SUM(b.money) as money, SUM(b.weight) as weight, b.item_type, b.flag FROM xzx_order_storage_info c 
        LEFT JOIN xzx_order_storage_detail b ON c.storage_id=b.storage_id
        WHERE b.flag=#flag# 
        @if(!isEmpty(startTime)){
            and c.storage_time BETWEEN #startTime# AND #endTime# 
        @}
        @if(!isEmpty(receiverphone)){
            and c.receiver_phone=#receiverphone#
        @}
         GROUP BY b.item_type
    ) e ON e.item_type = a.item_type
    WHERE a.del_flag=0 and a.parent_id is NOT NULL;
    
queryDetailList
===
    SELECT IFNULL(SUM(b.weight),0) as weight, IFNULL(SUM(b.money),0) as money, a.receiver_name, d.orderTotal,a.storage_user_name as storageUserName,a.receiver_phone as receiverPhone, x.name as name FROM xzx_order_storage_info a
    LEFT JOIN xzx_order_storage_detail b on a.storage_id = b.storage_id AND b.flag = #flag#
    LEFT JOIN (
        SELECT c.receiver_name, COUNT(c.receiver_name) AS orderTotal FROM (
            SELECT  distinct b.storage_id, a.receiver_name FROM xzx_order_storage_info a
            LEFT JOIN xzx_order_storage_detail b on a.storage_id = b.storage_id AND b.flag = #flag#
            @if(!isEmpty(startTime)){
                where a.storage_time BETWEEN #startTime# AND #endTime#
            @}
        ) c
        GROUP BY c.receiver_name ORDER BY c.receiver_name
    ) d ON d.receiver_name = a.receiver_name
    LEFT JOIN xzx_user_other_info x ON a.receiver=x.user_id 
    WHERE 1=1 
    @if(!isEmpty(startTime)){
        and a.storage_time BETWEEN #startTime# AND #endTime#
    @}
    @if(!isEmpty(storageUserName)){
        and a.storage_user_name = #storageUserName#
    @}
    @if(!isEmpty(receiverName)){
        and x.name = #receiverName#
    @}
    GROUP BY a.receiver_name limit #page#, #limit#
     
queryDetailListCount
===
    SELECT COUNT(*) FROM (
    SELECT SUM(b.weight) as weight, SUM(b.money) as money, a.receiver_name, d.orderTotal FROM xzx_order_storage_info a
        LEFT JOIN xzx_order_storage_detail b on a.storage_id = b.storage_id AND b.flag = #flag#
        LEFT JOIN (
            SELECT c.receiver_name, COUNT(c.receiver_name) AS orderTotal FROM (
                SELECT  distinct b.storage_id, a.receiver_name FROM xzx_order_storage_info a
                LEFT JOIN xzx_order_storage_detail b on a.storage_id = b.storage_id AND b.flag = #flag#
                @if(!isEmpty(startTime)){
                    where a.storage_time BETWEEN #startTime# AND #endTime#
                @}
            ) c
        GROUP BY c.receiver_name ORDER BY c.receiver_name
        ) d ON d.receiver_name = a.receiver_name
         LEFT JOIN xzx_user_other_info x ON a.receiver=x.user_id 
        WHERE 1=1 
        @if(!isEmpty(startTime)){
            and a.storage_time BETWEEN #startTime# AND #endTime#
        @}
        @if(!isEmpty(storageUserName)){
            and a.storage_user_name = #storageUserName#
        @}
        @if(!isEmpty(receiverName)){
            and x.name = #receiverName#
        @}
        GROUP BY a.receiver_name
        ) as x
        
queryDetailTotal
===
    SELECT IFNULL(e.weight,0) AS weight, IFNULL(e.money,0) AS money ,a.title as config_value_name FROM xzx_sys_environmental_info a 
        LEFT JOIN(
            SELECT SUM(b.money) as money, SUM(b.weight) as weight, b.item_type, b.flag FROM xzx_order_storage_info c 
            LEFT JOIN xzx_order_storage_detail b ON c.storage_id=b.storage_id
            WHERE 
            @if(!isEmpty(startTime)){
                c.storage_time BETWEEN #startTime# AND #endTime# 
            @}
            AND b.flag=#flag# GROUP BY b.item_type
        ) e ON e.item_type = a.item_type
        WHERE a.parent_id is NOT NULL;
        
queryUserOrderNo
===
    	SELECT a.storage_id, a.storage_time FROM xzx_order_storage_info a
    	LEFT JOIN xzx_order_storage_detail b ON a.storage_id=b.storage_id 
    	WHERE b.flag = #flag# 
    	@if(!isEmpty(startTime)){
            AND a.storage_time BETWEEN #startTime# AND #endTime# 
        @}
        @if(!isEmpty(phone)){
            and a.receiver_phone=#phone#
        @}
    	GROUP BY a.storage_id limit #page#,#limit#
    	
queryUserOrderNoCount
===
    SELECT COUNT(*) FROM (
        SELECT a.storage_id FROM xzx_order_storage_info a
        LEFT JOIN xzx_order_storage_detail b ON a.storage_id=b.storage_id 
        WHERE b.flag = #flag# 
        @if(!isEmpty(startTime)){
            AND a.storage_time BETWEEN #startTime# AND #endTime# 
        @}
        @if(!isEmpty(phone)){
            and a.receiver_phone=#phone#
        @}
        GROUP BY a.storage_id
    ) AS e
    
queryOrderIdsByStorageId
===    
    SELECT order_id FROM xzx_order_storage_info where storage_id=#storageId#
queryTotalForOrderNo
===
    SELECT IFNULL(e.weight,0) AS weight, IFNULL(e.money,0) AS money ,a.title as config_value_name, e.storage_id
    FROM xzx_sys_environmental_info a
    LEFT JOIN(
    	SELECT SUM(b.money) as money, SUM(b.weight) as weight, b.item_type, b.flag, b.storage_id 
    	FROM xzx_order_storage_detail b WHERE b.storage_id=#orderNo# and b.flag=#flag# GROUP BY b.item_type 
    ) e ON e.item_type = a.item_type 
    WHERE a.del_flag=0 and  a.parent_id is NOT NULL;
    

queryTotalOrderItemByIds
===
    SELECT IFNULL(e.weight,0) AS weight, IFNULL(e.money,0) AS money ,a.title as config_value_name, e.storage_id
    FROM xzx_sys_environmental_info a
    LEFT JOIN(
    	SELECT SUM(b.money) as money, SUM(b.weight) as weight, b.item_type, #storageId# as storage_id 
    	FROM xzx_order_item_info b WHERE b.order_id in (
    	               @for(id in orderArr){
                          #id#  #text(idLP.last?"":"," )#
                        @}
        ) GROUP BY b.item_type 
    ) e ON e.item_type = a.item_type 
    WHERE a.parent_id is NOT NULL;
    
        
queryCuserOrderByUserId
===
    SELECT a.*, IFNULL(b.money,0) AS money, c.nick_name AS nickNme FROM xzx_order_info a
    LEFT JOIN xzx_order_detail_info b ON a.order_id=b.order_id
    LEFT JOIN xzx_user_other_info c ON c.user_id=a.receiver 
    WHERE a.create_user_id=#userId# 
    @if(!isEmpty(orderStatus)){
        AND a.order_status in ( #join(orderStatus)#)
    @}
    limit #page#,#limit#
    
queryCuserOrderByUserIdx
===
    SELECT a.*, IFNULL(b.money,0) AS money FROM xzx_order_info a
    LEFT JOIN xzx_order_detail_info b ON a.order_id=b.order_id
    WHERE a.receiver=#receiveUserId#  
    @if(!isEmpty(orderStatus)){
        AND a.order_status in ( #join(orderStatus)#)
    @}
    limit #page#,#limit#
    
queryCuserOrderByUserIdCount
===
    SELECT count(*) as count FROM xzx_order_info a
    LEFT JOIN xzx_order_detail_info b ON a.order_id=b.order_id
    WHERE a.create_user_id=#userId# 
    @if(!isEmpty(orderStatus)){
        AND a.order_status in ( #join(orderStatus)# )
    @}

queryCuserOrderByUserIdCount1
===
    SELECT count(a.order_id) as count,
     (select count(b.order_id) from xzx_order_info b where b.order_status=3 and b.create_user_id=#userId#) as count1 
    FROM xzx_order_info a
        WHERE  a.create_user_id=#userId# and a.order_status in (4,5,7)
   
        
queryCuserOrderByUserIdCountx
===
    SELECT count(*) as count FROM xzx_order_info a
    LEFT JOIN xzx_order_detail_info b ON a.order_id=b.order_id
    WHERE a.receiver=#receiveUserId# 
    @if(!isEmpty(orderStatus)){
        AND a.order_status in ( #join(orderStatus)# )
    @}
    
queryOrderByOrderno
===
    SELECT a.address, a.address_area, a.order_type, a.order_status,a.create_time,a.rela_name,b.*,c.item_type, c.weight AS cweight, c.amount as camount, c.money as cmoney, d.title FROM xzx_order_info a 
    LEFT JOIN xzx_order_detail_info b ON a.order_id=b.order_id
    LEFT JOIN xzx_order_item_info c ON c.order_id=a.order_id 
    LEFT JOIN xzx_sys_environmental_info d ON c.item_type = d.item_type
    WHERE a.order_id=#orderNo#

queryOrderByOrderId
===
    select receiver  from  xzx_order_info  WHERE order_id=#orderId# 

queryUserIdByOrderId
===
    select create_user_id  from  xzx_order_info  WHERE order_id=#orderId#         

queryOrderPageByOrderno
===
    SELECT a.address, a.address_area, a.order_type, a.order_status,a.create_time,
           a.rela_name,b.*,e.item_type, e.cweight AS cweight, e.camount as camount,
           e.cmoney as cmoney, e.title
    FROM xzx_order_info a 
    LEFT JOIN xzx_order_detail_info b ON a.order_id=b.order_id
    LEFT JOIN(
         select c.item_type, c.weight AS cweight, c.amount as camount,c.order_id,
           c.money as cmoney,d.title FROM xzx_order_item_info c 
          LEFT JOIN xzx_sys_environmental_info d ON c.item_type = d.item_type
          WHERE c.money>0
      )e on a.order_id = e.order_id
    WHERE a.order_id=#orderNo#    
    limit #page#,#limit#
queryOrderCountByOrderno
===
       select count(k.title) from (
        SELECT e.title as title FROM xzx_order_info a 
        LEFT JOIN xzx_order_detail_info b ON a.order_id=b.order_id
        LEFT JOIN(
                 select c.item_type, c.weight AS cweight, c.amount as camount,c.order_id,
                   c.money as cmoney,d.title FROM xzx_order_item_info c 
                  LEFT JOIN xzx_sys_environmental_info d ON c.item_type = d.item_type
                  WHERE c.money>0
              )e on a.order_id = e.order_id
        WHERE a.order_id=#orderNo#  ) k       


queryOrderList
===
    SELECT a.order_id,a.create_time,a.reserve_time,a.order_type,a.order_status,c.nick_name,c.name,a.rela_name,b.money,SUM(f.weight) AS weight FROM xzx_order_info a
    LEFT JOIN xzx_order_detail_info b ON a.order_id = b.order_id
    LEFT JOIN xzx_user_other_info c ON a.receiver = c.user_id
    LEFT JOIN xzx_order_item_info f ON a.order_id = f.order_id 
    WHERE 1=1 
    @if(!isEmpty(orderStatus)){
        AND a.order_status=#orderStatus#
    @}
    @if(!isEmpty(startTime)){
        AND a.create_time BETWEEN #startTime# AND #endTime#
    @}
    @if(!isEmpty(orderType)){
        AND a.order_type = #orderType#
    @}
    @if(!isEmpty(name)){
        AND c.name = #name#
    @}
    @if(!isEmpty(mobilePhone)){
        AND c.mobile_phone = #mobilePhone#
    @}
    GROUP BY a.create_time desc  
    limit #page#, #limit#
    
queryOrderListCount
===
    SELECT count(*) FROM (SELECT a.order_id FROM xzx_order_info a
    LEFT JOIN xzx_order_detail_info b ON a.order_id = b.order_id
    LEFT JOIN xzx_user_other_info c ON a.receiver = c.user_id
    LEFT JOIN xzx_order_item_info f ON a.order_id = f.order_id 
    WHERE 1=1 
    @if(!isEmpty(orderStatus)){
        AND a.order_status=#orderStatus#
    @}
    @if(!isEmpty(startTime)){
        AND a.create_time BETWEEN #startTime# AND #endTime#
    @}
    @if(!isEmpty(orderType)){
        AND a.order_type = #orderType#
    @}
    @if(!isEmpty(name)){
        AND c.name = #name#
    @}
    @if(!isEmpty(mobilePhone)){
        AND c.mobile_phone = #mobilePhone#
    @}
    GROUP BY a.create_time) as x

queryOrderByTownIdsApiListCount
===
    SELECT count(*) FROM (SELECT a.order_id FROM xzx_order_info a
    LEFT JOIN ( select SUM(f.money) as orderMoney,SUM(f.weight) AS orderWeight,b.order_id,
                    b.complete_time,b.cancel_reason_name,b.receive_time 
                    from
                     xzx_order_detail_info b
                   LEFT JOIN xzx_order_item_info f ON f.order_id = b.order_id
        )m ON m.order_id=a.order_id
    LEFT JOIN xzx_user_other_info c ON a.receiver = c.user_id
    LEFT JOIN xzx_user_info d ON  a.create_user_id = d.user_id
    WHERE 1=1 
    @if(!isEmpty(orderStatus)){
        AND a.order_status=#orderStatus#
    @}
    @if(!isEmpty(startTime)){
        AND a.create_time BETWEEN #startTime# AND #endTime#
    @}
    @if(!isEmpty(orderType)){
        AND a.order_type = #orderType#
    @}
    @if(!isEmpty(name)){
        AND c.name = #name#
    @}
    @if(!isEmpty(createType)){
                AND a.create_type = #createType#
            @}
       @if(!isEmpty(mobilePhone)){
            AND (d.mobile_phone like #"%"+mobilePhone+"%"#  or d.nick_name = #nickName#)
        @}
        @if(!isEmpty(orderId)){
                AND a.order_id like #"%"+orderId+"%"#
        @}   
        @if(!isEmpty(townIds)){
                 AND a.town_id in ( #join(townIds)# )
        @}     
    GROUP BY a.create_time,a.order_id ) as x
    
queryOrderApiListCount
===
    SELECT count(*) FROM (SELECT a.order_id FROM xzx_order_info a
    LEFT JOIN xzx_order_detail_info b ON a.order_id = b.order_id
    LEFT JOIN xzx_user_other_info c ON a.receiver = c.user_id
    LEFT JOIN xzx_order_item_info f ON a.order_id = f.order_id 
    LEFT JOIN xzx_user_info d ON  a.create_user_id = d.user_id
    WHERE 1=1 
    @if(!isEmpty(orderStatus)){
        AND a.order_status=#orderStatus#
    @}
    @if(!isEmpty(startTime)){
        AND a.create_time BETWEEN #startTime# AND #endTime#
    @}
    @if(!isEmpty(orderType)){
        AND a.order_type = #orderType#
    @}
    @if(!isEmpty(name)){
        AND c.name = #name#
    @}
    @if(!isEmpty(createType)){
                AND a.create_type = #createType#
            @}
       @if(!isEmpty(mobilePhone)){
            AND (d.mobile_phone like #"%"+mobilePhone+"%"#  or d.nick_name = #nickName#)
        @}
        @if(!isEmpty(orderId)){
                AND a.order_id like #"%"+orderId+"%"#
        @}   
        @if(!isEmpty(partnerIds)){
                 AND c.partner_id in ( #join(partnerIds)# )
        @}     
    GROUP BY a.create_time) as x
    
queryStatusByCuserId
===
    SELECT COUNT(*) as count, a.order_status as orderStatus FROM xzx_order_info a 
    WHERE a.receiver = #userId# GROUP BY a.order_status

queryOrderByPartnerId
===
    select b.township_id from xzx_order_detail_info a
    left join xzx_user_address_info b on a.address_id=b.address_id
     where a.order_id=#orderId#

queryTownIdByPartnerId
===
    select partner_id from xzx_partner_gaode 
    where del_flag=0 
    and partner_id<>partner_key 
    and town_id=#townId# limit 1
              
updateOrderStatus
===
    update xzx_order_info set 
    @if(!isEmpty(orderStatus)){
        order_status=#orderStatus#
    @}
    @if(!isEmpty(receiveId)){
        ,receiver=#receiveId#
    @}
    where order_id=#orderId#
updateApirecByOrderId
===
    update xzx_order_info set receiver=#receiveId#,order_status=2,trace_id=#trid#  where order_id=#orderId#  

updateApirecDetailByOrderId
===
    update xzx_order_detail_info set receive_time=SYSDATE(),receiver_phone=#mobilePhone#,receiver_name=#name#  
    where order_id=#orderId#  

updateOrderStatus1
===
    update xzx_order_info set order_status=#orderStatus#  where order_id=#orderId#    
           
updateOrderDetailReData
===
     update xzx_order_detail_info set cancel_reason_name = #cancelReasonName# where order_id=#orderId#


queryOrderByTownIdApiList
===
    SELECT a.order_id as orderId,a.create_time as createTime,a.reserve_time as reserveTime,a.order_type as orderType,
                   a.rela_phone as relaPhone,m.receive_time as receiveTime,
                   m.complete_time as completeTime,
                   m.cancel_reason_name as cancelReasonName,
                   a.order_status as orderStatus,
                  IFNULL(d.nick_name,c.nick_name) as nickName,
                   c.name as name,d.mobile_phone as mobilePhone,a.rela_name as relaName,
                   m.orderMoney as orderMoney,m.orderWeight AS orderWeight 
           FROM xzx_order_info a  
     LEFT JOIN ( select SUM(f.money) as orderMoney,SUM(f.weight) AS orderWeight,b.order_id,
                    b.complete_time,b.cancel_reason_name,b.receive_time 
                    from
                     xzx_order_detail_info b
                   LEFT JOIN xzx_order_item_info f ON f.order_id = b.order_id
        )m ON m.order_id=a.order_id
    LEFT JOIN xzx_user_info d ON  a.create_user_id = d.user_id
    LEFT JOIN xzx_user_other_info c ON a.receiver = c.user_id
    WHERE 1=1 
    @if(!isEmpty(orderStatus)){
        AND a.order_status=#orderStatus#
    @}
    @if(!isEmpty(startTime)){
        AND a.create_time BETWEEN #startTime# AND #endTime#
    @}
    @if(!isEmpty(orderType)){
        AND a.order_type = #orderType#
    @}
    @if(!isEmpty(name)){
        AND c.name = #name#
    @}
    @if(!isEmpty(mobilePhone)){
        AND (d.mobile_phone like #"%"+mobilePhone+"%"#  or d.nick_name = #nickName#)
    @}
    @if(!isEmpty(orderId)){
            AND a.order_id like #"%"+orderId+"%"#
    @}
    @if(!isEmpty(createType)){
            AND a.create_type = #createType#
        @}
    @if(!isEmpty(townIds)){
             AND a.town_id in ( #join(townIds)# )
    @}
    GROUP BY a.create_time,a.order_id desc  
    limit #page#, #limit# 
                   
queryOrderApiList
===
    SELECT a.order_id as orderId,a.create_time as createTime,a.reserve_time as reserveTime,a.order_type as orderType,a.rela_phone as relaPhone,b.receive_time as receiveTime,b.complete_time as completeTime,b.cancel_reason_name as cancelReasonName,
           a.order_status as orderStatus,IFNULL(d.nick_name,c.nick_name) as nickName,c.name as name,d.mobile_phone as mobilePhone,a.rela_name as relaName,SUM(f.money) as orderMoney,SUM(f.weight) AS orderWeight 
           FROM xzx_order_info a
    LEFT JOIN xzx_order_detail_info b ON a.order_id = b.order_id
    LEFT JOIN xzx_user_info d ON  a.create_user_id = d.user_id
    LEFT JOIN xzx_user_other_info c ON a.receiver = c.user_id
    LEFT JOIN xzx_order_item_info f ON a.order_id = f.order_id 
    WHERE 1=1 
    @if(!isEmpty(orderStatus)){
        AND a.order_status=#orderStatus#
    @}
    @if(!isEmpty(startTime)){
        AND a.create_time BETWEEN #startTime# AND #endTime#
    @}
    @if(!isEmpty(orderType)){
        AND a.order_type = #orderType#
    @}
    @if(!isEmpty(name)){
        AND c.name = #name#
    @}
    @if(!isEmpty(mobilePhone)){
        AND (d.mobile_phone like #"%"+mobilePhone+"%"#  or d.nick_name = #nickName#)
    @}
    @if(!isEmpty(orderId)){
            AND a.order_id like #"%"+orderId+"%"#
    @}
    @if(!isEmpty(createType)){
            AND a.create_type = #createType#
        @}
    @if(!isEmpty(partnerIds)){
             AND c.partner_id in ( #join(partnerIds)# )
    @}
    GROUP BY a.create_time desc  
    limit #page#, #limit#  

queryStorageApiList
===
    select a.storage_id as storageId,x.name as storageName,
                      storage_user_phone as storageUserPhone,(select user_type from xzx_user_other_info where user_id=receiver) as userType,
                      receiver_name as receiverName,receiver_phone as receiverPhone,
                      storage_time as storageTime, recycle_weight as recycleWeight,storage_weight as storageWeight,storage_money as storageMoney,
                      recycle_money as recycleMoney,
                       (select f.create_time  from xzx_order_batch_info f where a.order_id=f.order_id) as batchTime,
                       (select storage_name from xzx_sys_storage where a.sys_storage_id=id) as sysStorageName,
                       (select b.vehicle_id from xzx_order_batch_info b where a.order_id=b.order_id) as vehicleId,
                       IFNULL((select b.weight from xzx_order_batch_info b where a.order_id=b.order_id),0) as batchWeight,
                       IFNULL((select c.weight  from xzx_user_vehicle_info c where id = (select b.vehicle_id from xzx_order_batch_info b where a.order_id=b.order_id)),0) as emptyWeight,
                       (select c.vehicle_no  from xzx_user_vehicle_info c where id = (select b.vehicle_id from xzx_order_batch_info b where a.order_id=b.order_id)) as vehicleNo
     from xzx_order_storage_info a   
     left join xzx_user_other_info x on x.user_id=a.storage_user_id
     where 1=1
      @if(!isEmpty(storageStatus)){
              AND a.storage_status = #storageStatus#
      @}
      @if(!isEmpty(startTime)){
                    AND a.storage_time >= #startTime#
      @}
      @if(!isEmpty(endTime)){
                          AND a.storage_time <= #endTime#
      @}
      @if(!isEmpty(name)){
                  AND (a.receiver_name like #"%"+name+"%"# or a.receiver_phone like #"%"+name+"%"# or a.storage_id like #"%"+name+"%"#)
      @}
      @if(!isEmpty(partnerIds)){
               AND x.partner_id in ( #join(partnerIds)# )
      @}
     order by a.storage_time desc
     limit #page#, #limit#   
     
queryStorageApiNum
===     
    select count(x.storageId) from (
        select a.storage_id as storageId
         from xzx_order_storage_info a
          left join xzx_user_other_info k on k.user_id=a.storage_user_id
         where 1=1
          @if(!isEmpty(storageStatus)){
                  AND a.storage_status = #storageStatus#
          @}
          @if(!isEmpty(startTime)){
                        AND a.storage_time >= #startTime#
          @}
          @if(!isEmpty(endTime)){
                              AND a.storage_time <= #endTime#
          @}
          @if(!isEmpty(name)){
                            AND (a.receiver_name like #"%"+name+"%"# or a.receiver_phone like #"%"+name+"%"# or a.storage_id like #"%"+name+"%"#)
                @}
                 @if(!isEmpty(partnerIds)){
                               AND k.partner_id in ( #join(partnerIds)# )
                      @}
         order by a.storage_time desc
        ) x    

queryStorageDetailApiList
===
     SELECT a.order_id as orderId,a.create_time as createTime,
                c.name as name,c.mobile_phone as mobilePhone,SUM(f.money) as orderMoney,SUM(f.weight) AS orderWeight 
                FROM xzx_order_info a
         LEFT JOIN xzx_order_detail_info b ON a.order_id = b.order_id
         LEFT JOIN xzx_user_other_info c ON a.receiver = c.user_id
         LEFT JOIN xzx_order_item_info f ON a.order_id = f.order_id 
         WHERE 1=1
          @if(!isEmpty(orderIds)){
              AND a.order_id in ( #join(orderIds)# ) 
          @} 
         GROUP BY a.create_time desc  
         limit #page#, #limit#  

queryStroageDetailPageByOrderno
===
        select sum(a.money) as recycleMoney,sum(a.weight) as recycleWeight,d.title,
        (SELECT c.money from xzx_order_storage_detail c where a.item_type=c.item_type
             @if(!isEmpty(storageId)){
                    AND c.storage_id =#storageId#
                  @}
             group by item_type) as storageMoney,
        (SELECT c.weight from xzx_order_storage_detail c where a.item_type=c.item_type
              @if(!isEmpty(storageId)){
                        AND c.storage_id =#storageId#
                      @}
                 group by item_type) as storageWeight
        from xzx_order_item_info a
        LEFT JOIN xzx_sys_environmental_info d ON d.item_type = a.item_type
        where  1=1
                    @if(!isEmpty(orderIds)){
                         AND a.order_id in ( #join(orderIds)# ) 
                     @} 
        GROUP BY a.item_type
        limit #page#,#limit#    
queryStroageDetailCountByOrderno
===
       select count(k.title) from (
        select d.title as title
            from xzx_order_item_info a
            LEFT JOIN xzx_sys_environmental_info d ON d.item_type = a.item_type
            where  1=1
                        @if(!isEmpty(orderIds)){
                             AND a.order_id in ( #join(orderIds)# ) 
                         @} 
            GROUP BY a.item_type
             ) k   

addOrderInfoApi
===
    INSERT INTO `xzx_order_info` 
        (`order_id`, `address`, `order_status`, 
         `order_second_status`, `order_type`, `address_area`,
         `reserve_time`, `create_user_id`, `receiver`,
         `cancel_user_id`, `create_time`, `rela_phone`,
         `rela_name`, `longitude`, `latitude`, `town_id`,
         `create_type`, `del_flag`, `store_id`) 
     VALUES (#orderId#, #detailAddress#, #orderStatus#, 
             NULL, '1', #addressArea#, 
             #reserveTime#, #createUserId#, NULL,
             NULL, SYSDATE(), #mobilePhone#, 
             #nickName#, #longitude#, #latitude#, #townshipId#, 
             '3', '0', #storeId#)

addOrderDetailApi
===
    INSERT INTO `xzx_order_detail_info` (`order_id`, `remark`, `create_user_name`, 
    `mobile_phone`, `reserve_time`, `complete_time`,
    `receive_time`, `order_pic`, `address_id`,
    `weight`, `amount`, `money`,
    `storage_money`, `receiver_name`, `take_phone_pic`, 
    `receiver_phone`, `cancel_user_name`, `cancel_user_phone`,
    `storage_user_id`, `storage_user_name`, `storage_user_phone`,
    `cancel_reason_code`, `cancel_reason_name`) 
    VALUES (#orderId#, #remark#, #createUserName#,
     #mobilePhone#, #reserveTime#, null, 
     NULL, NULL, #addressId#,
     NULL, NULL, NULL, 
     NULL, NULL, NULL,
     NULL, NULL, NULL, 
     NULL, NULL, NULL,
     NULL, NULL)
     
addOrderItem
===
    INSERT INTO `xzx_order_item_info` (`order_id`, `item_type`, `weight`,
     `amount`, `money`) 
    VALUES 
    @for(info in list){
             (#info.orderId#,#info.itemType#,null,null,null)
              @if(!isEmpty(info.itemType)){
                 #text(infoLP.last?"":"," )#
              @} 
    @}
    
queryProvince
===
    select level_1_id as level1Id,level_1_name as level1Name  
        from xzx_sys_address_level_info where 1=1 group by level_1_id

queryCityByProvinceId
===              
    select level_2_id as level2Id,level_2_name as level2Name
     from xzx_sys_address_level_info where 1=1 and level_1_id=#provinceId# group by level_2_id

queryTownShipByCityId
===
    select level_3_id as level3Id,level_3_name as level3Name
        from xzx_sys_address_level_info where 1=1 and level_2_id=#cityId# group by level_3_id     
         
queryOrderReNum
===
    select count(order_id) from xzx_order_info  where del_flag=0 and  receiver=#userId# and order_status=2           

queryTownIdsByPartnerIds
===
    select fence_id from xzx_partner_fence where 1=1 and del_flag=0
      @if(!isEmpty(partnerIds)){
          AND partner_id in ( #join(partnerIds)# ) 
      @}