queryOperaIteml
===
        select a.id,a.title,
             (select b.title from xzx_sys_environmental_info b where b.id=a.parent_id) as type,
              a.price as price,a.second_price as secondPrice,IFNULL(a.put_storage_price,0.00) as putStoragePrice,a.sort as sort,
              a.picture as picture,a.parent_id
         from xzx_sys_environmental_info a where a.del_flag=0 and a.parent_id is not null
            @if(!isEmpty(title)){
                AND title like #"%"+title+"%"#
            @}
            @if(!isEmpty(parentId) && parentId != ''){
                AND parent_id=#parentId#
            @}
            @if(!isEmpty(id)){
                AND id=#id#
            @}
            @if(!isEmpty(partnerIds)){
                AND partner_id in ( #join(partnerIds)# )
            @}
            @if(!isEmpty(cityId)){
                AND city_id =#cityId#
            @}
            @if(!isEmpty(townIdList)){
                            AND city_id in (#join(townIdList)#)
                        @}
            order by sort 
            limit #pageNum#,#limitNum#
queryItemById
===
    select a.* from  xzx_sys_environmental_info a where a.del_flag=0 and a.parent_id is not null   
queryOrderByCityId
===
    select a.* from xzx_order_info a
     left join (
          select c.order_id,d.township_id from xzx_order_detail_info c 
          left join xzx_user_address_info d on c.address_id=d.address_id
          where 1=1
     ) m on a.order_id=m.order_id
     left join xzx_user_info b on a.create_user_id = b.user_id
     where a.order_status in ('4','7') and m.township_id =#cityId#
queryCityByTownId
===
    select level_1_id as pid,level_2_id as cid  
        from xzx_sys_address_level_info where 1=1 and  level_3_id=#townId#              
queryOperaIteml1
===
        select a.id,a.title,
             (select b.title from xzx_sys_environmental_info b where b.id=a.parent_id) as type,
              a.price as price,a.second_price as secondPrice,IFNULL(a.put_storage_price,0.00) as putStoragePrice,a.sort as sort,
              a.picture as picture,a.parent_id
         from xzx_package_goods_info a where a.del_flag=0 and a.parent_id is not null
            @if(!isEmpty(title)){
                AND title like #"%"+title+"%"#
            @}
            @if(!isEmpty(parentId) && parentId != ''){
                AND parent_id=#parentId#
            @}
            @if(!isEmpty(id)){
                AND id=#id#
            @}
            @if(!isEmpty(partnerIds)){
                AND partner_id in ( #join(partnerIds)# )
            @}
            @if(!isEmpty(cityId)){
                AND city_id =#cityId#
            @}
            @if(!isEmpty(packageId) && packageId != ''){
                AND package_id=#packageId#
            @}
            order by sort 
            limit #pageNum#,#limitNum#
queryOperaItemlCount
===
     select count(k.title) from (
        select a.title as title
         from xzx_sys_environmental_info a where a.del_flag=0 and a.parent_id is not null
            @if(!isEmpty(title)){
                AND title like #"%"+title+"%"#
            @}
            @if(!isEmpty(parentId) && parentId != ''){
                AND parent_id=#parentId#
            @}
            @if(!isEmpty(id)){
                AND id=#id#
            @}
            @if(!isEmpty(partnerIds)){
                AND partner_id in ( #join(partnerIds)# )
            @}
            @if(!isEmpty(packageId) && packageId != ''){
                 AND package_id=#packageId#
             @}
             @if(!isEmpty(townIdList)){
                 AND city_id in (#join(townIdList)#)
             @}
             @if(!isEmpty(cityId)){
                              AND city_id = #cityId#
             @}
            order by sort )k             
queryOperaItemlCount1
===
     select count(k.title) from (
        select a.title as title
         from xzx_package_goods_info a where a.del_flag=0 and a.parent_id is not null
            @if(!isEmpty(title)){
                AND title like #"%"+title+"%"#
            @}
            @if(!isEmpty(parentId) && parentId != ''){
                AND parent_id=#parentId#
            @}
            @if(!isEmpty(id)){
                AND id=#id#
            @}
            @if(!isEmpty(partnerIds)){
                AND partner_id in ( #join(partnerIds)# )
            @}
            @if(!isEmpty(cityId)){
                AND city_id =#cityId#
            @}
            order by sort )k
            
queryCityByPartnerId
===
    select city_id from xzx_partner_gaode where del_flag=0 and partner_id<>partner_key
     @if(!isEmpty(partnerIds)){
                    AND partner_id in ( #join(partnerIds)# )
     @}
      group by city_id   

queryAreaByCityIds
===
      select level_2_id as cityId,
                 level_2_name as cityName  
          from xzx_sys_address_level_info where 1=1 
          and level_2_id in  ( #join(cityIds)#)        
queryOperaItemAll
===
    select * from xzx_sys_environmental_info where del_flag = 0
queryOperaItemAll1
===
    select * from xzx_package_goods_info where del_flag = 0
queryOperateItemList
===
        select a.id,a.title,a.sort,a.item_type,a.city_id from xzx_sys_environmental_info a where a.del_flag=0 and a.del_flag=0
        @if(!isEmpty(id)){
                          AND a.id=#id#
                  @}
        @if(!isEmpty(cityId)){
                        AND a.city_id=#cityId#
                @}
        @if(!isEmpty(townIdList)){
               AND a.city_id in (#join(townIdList)#)
        @}          
        @if(!isEmpty(partnerId)){
               AND a.parent_id=#partnerId#
        @} else {
               AND a.partner_id is null
        @} 
        and a.parent_id is null             
        limit #pageNum#,#limitNum#

queryOperateItemList1
===
        select a.id,a.title,a.sort,a.item_type,a.city_id from xzx_package_goods_info a where a.del_flag=0 and a.parent_id is null
        @if(!isEmpty(id)){
                AND id=#id#
        @}
        limit #pageNum#,#limitNum#
                
queryOperateItemCount
===
        select count(a.id) from xzx_sys_environmental_info a where a.del_flag=0
        @if(!isEmpty(id)){
                AND a.id=#id#
        @}
        @if(!isEmpty(cityId)){
                AND a.city_id=#cityId#
        @} 
        @if(!isEmpty(townIdList)){
                                        AND a.city_id in (#join(townIdList)#)
                                @} 
        @if(!isEmpty(partnerId)){
                        AND a.parent_id=#partnerId#
        @} else {
                   AND a.partner_id is null
                @}
        and a.parent_id is null        
        
queryOperateItemCount1
===
        select count(a.id) from xzx_package_goods_info a where a.parent_id is null
        @if(!isEmpty(id)){
                AND id=#id#
        @}        
queryOperateItemChildren
===
    select a.id,a.title,a.sort,a.item_type,a.city_id from xzx_sys_environmental_info a where a.del_flag=0 and a.parent_id is not null
            @if(!isEmpty(id)){
                    AND parent_id=#id#
            @}
querySysStorageApiList
===            
        select a.*,(select b.level_3_name from xzx_sys_address_level_info b where b.level_3_id=a.area) as areaName from xzx_sys_storage a where a.del_flag = 0
           @if(!isEmpty(area)){
                               AND a.area=#area#
                       @} 
           @if(!isEmpty(startTime)){
                               AND a.create_time>=#startTime#
                       @}  
            @if(!isEmpty(endTime)){
                               AND a.create_time<=#endTime#
                       @} 
            @if(!isEmpty(townIds)){
                   AND a.area in  (#join(townIds)#)
            @}                                                        
            limit #page#, #limit#  
querySysStorageApiCount
===            
        select count(*) from xzx_sys_storage where del_flag = 0
           @if(!isEmpty(area)){
                               AND area=#area#
                       @} 
           @if(!isEmpty(startTime)){
                               AND create_time>=#startTime#
                       @}  
            @if(!isEmpty(endTime)){
                               AND create_time<=#endTime#
                       @}
            @if(!isEmpty(townIds)){
                               AND area in  (#join(townIds)#)
                        @}                                                        
addSysStorageApi
===
    insert into xzx_sys_storage (storage_name, storage_area, province, city, area, detail_address, create_time,longitude,latitude)
     values (
        #storageName#, #storageArea#, #province#, #city#, #area#, #detailAddress#, #createTime#,#longitude#,#latitude#
     )  
updateSysStorageApi
===
    update `xzx_sys_storage` SET `storage_name` = #storageName#, `storage_area` = #storageArea#, 
    `province` = #province#, `city` = #city#, `area` = #area#, `detail_address` = #detailAddress#, 
    `create_time` = #createTime# WHERE `id` = #id#
delSysStorageApi
===
    update xzx_sys_storage set del_flag = 1 where `id` = #id#

checkUserNameByPhone
===
    select user_id,mobile_phone,name,nick_name 
    from xzx_user_other_info    
    where del_flag=0 and mobile_phone=#phone# and user_type=#type#