queryByCondition
===


    select 
    @pageTag(){
    t.*
    @}
    from xzx_electronic_fence t
    where 1=1  
    
    
    

batchDelXzxElectronicFenceByIds
===

* 批量逻辑删除

    update xzx_electronic_fence set del_flag = 1 where id  in( #join(ids)#)

queryElectronic
===
    select * from  xzx_electronic_fence 
    where fence_name=#fenceName# and del_flag=0
    @if(isNotEmpty(id)){
         AND id <>#id#
    @}

queryFenceList
===
    select a.* from  xzx_electronic_fence a 
    left join xzx_partner_fence b on a.id=b.fence_id
      where a.del_flag=0  and b.del_flag=0
        @if(isNotEmpty(fenceType)){
             AND a.fence_type=#fenceType#
        @}
        @if(isNotEmpty(partnerId)){
                     AND b.partner_id=#partnerId#
        @}
        @if(isNotEmpty(partnerIdList)){
             AND b.partner_id in ( #join(partnerIdList)# )
         @}

queryPartnerAreaIds
===
     select count(id) from xzx_partner_gaode where del_flag=0 and partner_id=#partnerId# 
      @if(isNotEmpty(townId)){
                  AND town_id=#townId#
             @}    
queryAreaTownId
===
     select level_3_id from xzx_sys_address_level_info where level_3_name=#keyword# 

queryTownListByArea
===
    select id from xzx_electronic_fence where town_code=#townCode# and del_flag=0 and  fence_type=2
     @if(isNotEmpty(eleId)){
           AND id<>#eleId#
     @}   
queryODByArea
===
    select id from  xzx_electronic_fence where   town_code=#townCode# and del_flag=0