<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<ListView id="__9uS2G24n5lxVwxuRr4i">
  <name>apply_contract_select</name>
  <parentId>__33O9dRsTvtyXuJr33bv</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>true</readonly>
  <relatedMap><![CDATA[                                                                                                                                                                                                                                                                                                                    ]]></relatedMap>
  <displayType>relatedForm</displayType>
  <defaultShowMode>month</defaultShowMode>
  <collapsibleShowMode>normal</collapsibleShowMode>
  <showWaterMark>false</showWaterMark>
  <showActivityColumnType>0</showActivityColumnType>
  <searchFormId></searchFormId>
  <autoCompose>false</autoCompose>
  <relatedForm>__kXAsPze9eXl53HmaexP</relatedForm>
  <permissionType>public</permissionType>
  <filterScript><![CDATA[]]></filterScript>
  <sqlFilterScript><![CDATA[#include "sysfunction";
(function(){
var loginNo=getWebUser().getLoginno();        
var securityId = getSession(getUserIdByLoginno(loginNo) + "securityId"); 
//var contractName = getItemValueAsString("contractName"); 
println("securityId==>"+ securityId);
 var sql = "select  '"+getDomainid()+"' as domainid,"+" ITEM_CONTRACTNAME," + //合同名称
"CONCAT_WS('至',DATE_FORMAT(ITEM_CONTRACTSTARTDATE,'%Y-%m-%d'),DATE_FORMAT(ITEM_CONTRACTENDDATE,'%Y-%m-%d')) ITEM_CONTRACTDATE," + //合同时间
"ITEM_CONTRACTSTARTDATE," + //合同开始时间
"ITEM_CONTRACTENDDATE," + //合同结束时间   
"ITEM_PARTYBNAME," + //乙方名称
"ITEM_CONTRACTSTATE," + //合同状态
"ITEM_SECURITYNAME," + //保安员姓名
"ITEM_USERID," + //用户id
"ITEM_SECURITYID,"+//保安员id
"ID ITEM_ID,"+
"ID"+
" from "+sysfunction.DS_FLOW+".tlk_contracttoman where ITEM_SECURITYID = '"+securityId+"'";
//if(!"".equals(contractName)){
//	sql = sql+ " and ITEM_CONTRACTNAME like concat('%','"+contractName+"','%')"
//}
return sql;
})()]]></sqlFilterScript>
  <procedureFilterScript><![CDATA[]]></procedureFilterScript>
  <filterCondition><![CDATA[[]]]></filterCondition>
  <commonFilterCondition><![CDATA[[]]]></commonFilterCondition>
  <authorityCondition>[]</authorityCondition>
  <openType>1</openType>
  <editMode>02</editMode>
  <width>0</width>
  <height>0</height>
</ListView>