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