<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<ListView id="__1ZcECfdFoAfNsxtvUN6">
  <name>apply_config_base_info</name>
  <parentId>__aW2bmAP2xSqnxrdwntX</parentId>
  <applicationid>__LgZds5MVHW3o08T7UcX</applicationid>
  <description><![CDATA[报名任务管理]]></description>
  <pagination>true</pagination>
  <pageLines>10</pageLines>
  <showTotalRow>true</showTotalRow>
  <refresh>false</refresh>
  <refreshAll>false</refreshAll>
  <newPage>false</newPage>
  <readonly>false</readonly>
  <relatedMap><![CDATA[                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            ]]></relatedMap>
  <displayType>relatedForm</displayType>
  <defaultShowMode>month</defaultShowMode>
  <collapsibleShowMode>normal</collapsibleShowMode>
  <showWaterMark>false</showWaterMark>
  <showActivityColumnType>0</showActivityColumnType>
  <searchFormId>__h7SnDZ4jqFZx4QmuDBV</searchFormId>
  <autoCompose>false</autoCompose>
  <relatedForm>__9R1Aei29Y0ZwTAnkcQf</relatedForm>
  <permissionType>public</permissionType>
  <filterScript><![CDATA[]]></filterScript>
  <sqlFilterScript><![CDATA[//表单某字段值为当前打开文档Id
(function(){
 
 var applyRuleName = getItemValueAsString("applyRuleName");                  
var createStartDate = getItemValueAsDate("createStartDate");       
var createEndDate = getItemValueAsDate("createEndDate");           
var applyType = getItemValueAsString("applyType");            
var whereStr = "where 1=1 ";         
                
if(isNotNull(applyRuleName)){            
  whereStr += "and a.ITEM_APPLYRULENAME like concat('%','"+applyRuleName+"','%') ";            
}            
if(isNotNull(createStartDate)){            
  whereStr += "and a.CREATED >= '"+format(createStartDate,"yyyy-MM-dd HH:mm:ss")+"' ";            
}            
if(isNotNull(createEndDate)){            
  whereStr += "and a.CREATED <= '"+format(createEndDate,"yyyy-MM-dd HH:mm:ss")+"' ";            
}            
if(isNotNull(applyType)){          
  whereStr += "and a.ITEM_APPLYTYPE = '"+applyType+"' ";            
}
 
 
 var sql = 
 "select "+
"'"+ getDomainid() +"' as domainid,"+  
"a.ITEM_APPLYRULENAME," + //报名名称
"a.ITEM_APPLYTYPE," + //报名分类
"a.ITEM_APPLYSTARTDATE," + //报名开始日期
"a.ITEM_APPLYENDDATE," + //报名结束日期
"a.ITEM_CREATEDUSER,"+ //创建者
"a.CREATED,"+
"b.ITEM_APPLYCOLUMN," + //报名字段
"c.ITEM_APPLYSTARTEDU," + //开始文化程度
"c.ITEM_APPLYENDEDU," + //结束文化程度
"c.ITEM_APPLYEDUCATIONTYPE," + //文化程度要求是否启用开关
"c.ITEM_APPLYAGETYPE," + //年龄要求是否启用开关
"c.ITEM_APPLYSTARTAGE," + //开始年龄
"c.ITEM_APPLYENDAGE," + //结束年龄
"a.ID AS ITEM_ID,"+
"b.ID AS ITEM_BID,"+
"c.ID AS ITEM_CID,"+
"a.ID "+
"from tlk_apply_rule_info a "+
"INNER JOIN "+
"tlk_apply_column_info b on a.ID = b.ITEM_APPLYRULEID "+
"INNER JOIN "+
"tlk_apply_condition_info c on b.ITEM_APPLYRULEID = c.ITEM_APPLYRULEID "+ whereStr;
 
return sql;
})()]]></sqlFilterScript>
  <procedureFilterScript><![CDATA[]]></procedureFilterScript>
  <filterCondition><![CDATA[[]]]></filterCondition>
  <commonFilterCondition><![CDATA[[{"field":"applyRuleName","isCommonFilter":"true"}]]]></commonFilterCondition>
  <authorityCondition>[]</authorityCondition>
  <openType>1</openType>
  <editMode>02</editMode>
  <width>0</width>
  <height>0</height>
</ListView>