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