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#