queryByCondition

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

batchDelXzxPartnerFenceByIds

• 批量逻辑删除

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

saveAllPfInfo

 insert  xzx_partner_fence (partner_id,fence_id,
        create_time,del_flag)  values
        @for(info in list){
          (#info.partnerId#,#info.fenceId#,
           SYSDATE(),0)
           @if(!isEmpty(info.partnerId)){
              #text(infoLP.last?"":"," )#
           @} 
        @}

queryElectronicFence

 select c.id,b.partner_name,b.mobile_phone,c.fence_name,c.fence_type,
 b.create_time,b.prohibit,c.longitude,c.latitude,c.long_lati_arr 
 from xzx_partner_fence a
 LEFT JOIN xzx_city_partner b ON a.partner_id=b.id
 LEFT JOIN xzx_electronic_fence c ON a.fence_id=c.id
 where b.del_flag=0 
 @if(isNotEmpty(startTime)){
                 AND b.create_time >=#startTime#
 @}
 @if(isNotEmpty(endTime)){
                 AND b.create_time <=#endTime#
 @}        
 @if(isNotEmpty(name)){
                 AND (b.partner_name like #"%"+name+"%"# or b.mobile_phone like #"%"+name+"%"# or c.fence_name like #"%"+name+"%"#)
 @}
 @if(isNotEmpty(fenceType)){
                 AND c.fence_type =#fenceType#
 @} 
 limit #page#, #limit#

queryElectronicFenceCount

select count(k.id) from (
     select b.id as id
          from xzx_partner_fence a
          LEFT JOIN xzx_city_partner b ON a.partner_id=b.id
          LEFT JOIN xzx_electronic_fence c ON a.fence_id=c.id
          where b.del_flag=0 
          @if(isNotEmpty(startTime)){
                          AND b.create_time >=#startTime#
          @}
          @if(isNotEmpty(endTime)){
                          AND b.create_time <=#endTime#
          @}        
          @if(isNotEmpty(name)){
                          AND (b.partner_name like #"%"+name+"%"# or b.mobile_phone like #"%"+name+"%"# )
          @}
          @if(isNotEmpty(fenceType)){
                          AND c.fence_type =#fenceType#
          @} 
      )k 

queryElectronicFencePage

 select a.id,a.fence_name as fenceName,a.longitude,a.latitude,a.longLatiArr,a.radius,
        a.keyword,a.create_time,a.fence_type,b.partner_id as partnerIds,a.keyword,a.prohibit,
        c.partner_name  as partnerName,
                   c.mobile_phone  as mobilePhone, 
                  c.account_no  as accountNo                        
 from xzx_electronic_fence a
 left join xzx_partner_fence b on  b.fence_id=a.id
 left join xzx_city_partner c on b.partner_id=c.id
 where a.del_flag=0 and c.partner_type=1
 @if(isNotEmpty(name)){
                  AND (c.partner_name like #"%"+name+"%"# or c.mobile_phone like #"%"+name+"%"# )
       @}
 @if(isNotEmpty(fenceType)){
                 AND a.fence_type =#fenceType#
 @}    
  @if(isNotEmpty(id)){
                      AND a.id =#id#
  @} 
  @if(isNotEmpty(prohibit)){
                            AND a.prohibit =#prohibit#
        @}  
  @if(isNotEmpty(fenceName)){
             AND a.fence_name like #"%"+fenceName+"%"#
  @}
  @if(isNotEmpty(startTime)){
                   AND a.create_time>=#startTime#
        @}
        @if(isNotEmpty(endTime)){
                               AND a.create_time<=#endTime#
                    @}
        @if(isNotEmpty(partnerIdList)){
              AND c.id in ( #join(partnerIdList)# )
        @}            
 limit #page#, #limit#

queryElectronicFencePageCount

select count(k.id) from (
     select a.id as id
          from xzx_electronic_fence a
           left join xzx_partner_fence b on  b.fence_id=a.id
               left join xzx_city_partner c on b.partner_id=c.id
          where a.del_flag=0 and c.partner_type=1
          @if(isNotEmpty(name)){
                                 AND (c.partner_name like #"%"+name+"%"# or c.mobile_phone like #"%"+name+"%"# )
                      @}
                @if(isNotEmpty(fenceType)){
                                AND a.fence_type =#fenceType#
                @} 
                 @if(isNotEmpty(id)){
                                     AND a.id =#id#
                 @} 
                  @if(isNotEmpty(prohibit)){
                                                 AND a.prohibit =#prohibit#
                             @}  
                 @if(isNotEmpty(fenceName)){
                            AND a.fence_name like #"%"+fenceName+"%"#
                 @} 
                 @if(isNotEmpty(startTime)){
                                        AND a.create_time>=#startTime#
                 @}
                 @if(isNotEmpty(endTime)){
                                                    AND a.create_time<=#endTime#
                 @}
                 @if(isNotEmpty(partnerIdList)){
                            AND c.id in ( #join(partnerIdList)# )
                 @}                                 
      )k

deleteByFenceId

update xzx_partner_fence  set del_flag=1 where fence_id=#id#   

deleteByPartnerId

update xzx_partner_fence  set del_flag=1 where partner_id=#partnerId#   

queryPartnerIds

 select partner_id from xzx_partner_fence  where fence_id=#fenceId# 

updateByFenceId

update xzx_partner_fence set partner_id=#partnerId#,update_time=#updateTime#  where fence_id= #fenceId#