<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<ListView id="__2Zx8T8rUN7WX8tEV5s1">
  <name>考试点</name>
  <parentId>__xmA8P0JniFiisvoPiWM</parentId>
  <applicationid>__LgZds5MVHW3o08T7UcX</applicationid>
  <pagination>true</pagination>
  <pageLines>5</pageLines>
  <showTotalRow>false</showTotalRow>
  <refresh>false</refresh>
  <refreshAll>false</refreshAll>
  <newPage>false</newPage>
  <readonly>false</readonly>
  <displayType>relatedForm</displayType>
  <defaultShowMode>month</defaultShowMode>
  <collapsibleShowMode>normal</collapsibleShowMode>
  <showWaterMark>false</showWaterMark>
  <showActivityColumnType>0</showActivityColumnType>
  <searchFormId>__oKzy34j0YbLy4PWgP9S</searchFormId>
  <autoCompose>false</autoCompose>
  <relatedForm></relatedForm>
  <permissionType>public</permissionType>
  <filterScript><![CDATA[]]></filterScript>
  <sqlFilterScript><![CDATA[(function(){
  var name = getItemValueAsString("exam_site_name"); 
  var region = getItemValueAsString("region"); 
  var status = getItemValueAsString("status"); 
  var personNumStart = getItemValueAsString("person_num_start");
  var personNumEnd = getItemValueAsString("person_num_end");
  var trainingName = getItemValueAsString("training_name");
  var sql = "select '"+getDomainid()+"' as domainid,"+
      //" a.formid,"+ //表单id
      "a.item_name,"+
      "a.AUTHOR as item_AUTHOR,"+
      "ITEM_REGION_PROVINCE,ITEM_REGION_CITY,ITEM_REGION_DISTRICT,"+
      "b.ITEM_CITYNAMEINDEX,"+
      "a.item_address,"+
      "a.item_training_name,"+
      "a.item_person_num,"+
      "a.created as item_created,"+
      "case a.item_status when 1 then '启用' else '禁用' end as item_status ,"+
      "a.id,"+
      "a.id as item_id "+
      "from tlk_exam_site a join companyinfocollect.tlk_citylevel b on a.ITEM_REGION_DISTRICT=b.id "; 
  var whereStr=" where 1= 1 and a.item_status = '1' and item_training_id= '"+getDomainid()+"' ";
  if(isNotNull(name)){            
    whereStr += "and a.item_name like '"+name+"%' ";              
  } 
  if(isNotNull(region)){            
    whereStr += "and a.ITEM_REGION_DISTRICT = '"+region+"' ";              
  } 
  if(isNotNull(status)){            
    whereStr += "and a.item_status = '"+status+"' ";              
  } 
  if(isNotNull(personNumStart)){            
    whereStr += "and a.item_person_num >= '"+personNumStart+"' ";              
  } 
  if(isNotNull(personNumEnd)){            
    whereStr += "and a.item_person_num <= '"+personNumEnd+"' ";              
  } 
  if(isNotNull(trainingName)){            
    whereStr += "and a.item_training_name like '"+trainingName+"%' ";              
  } 
  sql+=whereStr;
  println("考试点管理列表==="+sql);
  return sql;
})()]]></sqlFilterScript>
  <procedureFilterScript><![CDATA[]]></procedureFilterScript>
  <filterCondition><![CDATA[[]]]></filterCondition>
  <commonFilterCondition><![CDATA[[{"field":"exam_site_name","isCommonFilter":"true","paramKey":1693983736318},{"field":"region","isCommonFilter":"true","paramKey":1693983737672}]]]></commonFilterCondition>
  <authorityCondition>[]</authorityCondition>
  <openType>1</openType>
  <editMode>02</editMode>
  <width>0</width>
  <height>0</height>
</ListView>