<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<ListView id="__LL7kp4QmOtpwKCMylEg">
  <name>security</name>
  <parentId>__zsHjVo3E5dg1tSwdEER</parentId>
  <applicationid>__DXZvc8mnEmDqMARhK7G</applicationid>
  <description>保安员奖惩管理</description>
  <pagination>true</pagination>
  <pageLines>30</pageLines>
  <showTotalRow>true</showTotalRow>
  <refresh>true</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>__VrJEakNAooQxTDzPFhg</searchFormId>
  <autoCompose>false</autoCompose>
  <relatedForm>__qFCcCnozYNwzoG3O6Ms</relatedForm>
  <permissionType>public</permissionType>
  <filterScript><![CDATA[]]></filterScript>
  <sqlFilterScript><![CDATA[(function(){
 	var doc = getCurrentDocument();   //文档对象
    //var id= getWebUser().getId();  //用户id
	var domainid = getDomainid();   //企业域id
   // var application()=getApplication(); //应用软件id
  // var ddomainid=getWebUser().getDefaultDepartment();  用户部门id
    
	var s_securityName = getItemValue("s_securityName");
	println("s_securityName值是："+s_securityName);
	var s_documentID = getItemValue("s_documentID");
	println("s_documentID值是："+s_documentID);
	var s_phone = getItemValue("s_phone");
	println("s_phone值是："+s_phone);
	var s_isCertified = getItemValue("s_isCertified");
	println("s_isCertified值是："+s_isCertified);
	/*if("未认证".equals(s_isCertified)){
    	s_isCertified = "";
    }println("s_isCertified值是    2 ："+s_isCertified);
	if("已认证".equals(s_isCertified)){
    	s_isCertified = "";
    }println("s_isCertified值是    2 ："+s_isCertified);
	*/
	var s_jobType = getItemValue("s_jobType");
	println("s_jobType值是："+s_jobType);
	var s_DeptName = getItemValue("s_DeptName");
	println("s_DeptName值是："+s_DeptName);
	var s_shiming = getItemValueAsString("s_shiming");
	println("s_smrz值是："+s_shiming);
	var sql ="select distinct'"+domainid+"' as domainid,	se.item_phone,se.ITEM_securityName,CASE   		WHEN se.item_isInMyCompany = '0' THEN 		'' ELSE se.item_companyName 	END item_companyName,	se.item_documentID,	se.DOMAINID AS item_domain,	se.ITEM_jobType,se.ITEM_documentType,	se.ITEM_isInMyCompany  " +
 " FROM vw_employee se where domainid = '"+domainid+"' and ITEM_jobType = '1'  	AND ITEM_isInMyCompany = '1' ";
 	println("开始sql是："+sql);

	if(isNotNull(s_securityName)){
		sql += " and se.item_securityName  like '%"+s_securityName+"%' " ;
	}
    if(isNotNull(s_documentID)){
		sql += " and se.item_documentID  like '%"+s_documentID+"%' " ;
	}
	if(isNotNull(s_phone)){
		sql += " and se.item_phone  like '%"+s_phone+"%' " ;
	}
/*	if(isNotNull(s_isCertified)){
		sql += " and item_isCertified  like '"+s_isCertified+"' " ;
	}
	if(isNotNull(s_jobType)){
		sql += " and item_jobType  like '"+s_jobType+"' " ;
	}
	if(isNotNull(s_DeptName)){
		sql += " and ITEM_DeptName  like '%"+s_DeptName+"%' " ;
	}
	if(isNotNull(s_shiming)){
		sql += " and item_shiming  like '"+s_shiming+"' " ;
	}*/
	println("结束sql是====>" + sql);
return sql;
})()]]></sqlFilterScript>
  <procedureFilterScript><![CDATA[]]></procedureFilterScript>
  <filterCondition><![CDATA[[{"field":"securityName","operator":"LIKE","type":"03","match":"s_securityName","ipField":"","numField":0,"daField":"","sfField":"s_securityName","syField":""},{"field":"documentID","operator":"LIKE","type":"03","match":"s_documentID","ipField":"","numField":0,"daField":"","sfField":"s_documentID","syField":""},{"field":"phone","operator":"LIKE","type":"03","match":"s_phone","ipField":"","numField":0,"daField":"","sfField":"s_phone","syField":""},{"field":"isCertified","operator":"LIKE","type":"03","match":"s_isCertified","ipField":"","numField":0,"daField":"","sfField":"s_isCertified","syField":""},{"field":"jobType","operator":"LIKE","type":"03","match":"s_jobType","ipField":"","numField":0,"daField":"","sfField":"s_jobType","syField":""},{"field":"DeptID","operator":"LIKE","type":"03","match":"bumenxuanze","ipField":"","numField":0,"daField":"","sfField":"bumenxuanze","syField":""},{"field":"isInMyCompany","operator":"<>","type":"00","match":"0","ipField":"0","numField":0,"daField":"","sfField":"","syField":""},{"field":"shiming","operator":"LIKE","type":"03","match":"s_shiming","ipField":"","numField":0,"daField":"","sfField":"s_shiming","syField":""},{"field":"$Created","operator":"LIKE","type":"03","match":"s_lurutime","ipField":"","numField":0,"daField":"","sfField":"s_lurutime","syField":""}]]]></filterCondition>
  <commonFilterCondition><![CDATA[[{"field":"s_securityName","isCommonFilter":"true"}]]]></commonFilterCondition>
  <authorityCondition>[]</authorityCondition>
  <openType>1</openType>
  <editMode>02</editMode>
  <width>0</width>
  <height>0</height>
</ListView>