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#