<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<ListView id="__wsCSThaOyU4jP2sEFXD">
  <name>五级等级证</name>
  <parentId>__AT2erAITyWrFQyQEh3m</parentId>
  <applicationid>__LgZds5MVHW3o08T7UcX</applicationid>
  <description>鉴定成绩表</description>
  <pagination>true</pagination>
  <pageLines>10</pageLines>
  <showTotalRow>true</showTotalRow>
  <refresh>false</refresh>
  <refreshAll>false</refreshAll>
  <newPage>false</newPage>
  <lastModifyTime>2021-11-19T19:13:41.000+08:00</lastModifyTime>
  <readonly>false</readonly>
  <displayType>relatedForm</displayType>
  <defaultShowMode>month</defaultShowMode>
  <collapsibleShowMode>normal</collapsibleShowMode>
  <showWaterMark>false</showWaterMark>
  <showActivityColumnType>0</showActivityColumnType>
  <searchFormId>__XNQ0cQ4gWbomYMBy5f5</searchFormId>
  <autoCompose>false</autoCompose>
  <relatedForm>__gUvCL35mg8TQJmmdaFE</relatedForm>
  <permissionType>public</permissionType>
  <filterScript><![CDATA[]]></filterScript>
  <sqlFilterScript><![CDATA[
   (function(){

	var domainId = getDomainid();
	var idCardNo = getItemValueAsString("idCard"); 
	var createStartDate = getItemValueAsDate("createStartDate"); 
	var createEndDate = getItemValueAsDate("createEndDate"); 
	var z_name = getItemValueAsString("z_name");  
	var z_idCard = getItemValueAsString("z_idCard"); 
	var z_certificate = getItemValueAsString("z_certificate"); 
	var whereStr = "";
	var queryCriteriaSql = "";   
	if(isNotNull(z_name)){                                        
	  queryCriteriaSql = queryCriteriaSql + " and a.ITEM_NAME like concat('%','"+z_name+"','%')"
	}
	if(isNotNull(z_idCard)){                                        
	  queryCriteriaSql = queryCriteriaSql + " and a.ITEM_IDCARDNO like concat('%','"+z_idCard+"','%')"
	}
	if(isNotNull(z_certificate)){                                        
	  queryCriteriaSql = queryCriteriaSql + " and a.ITEM_certificateNO like concat('%','"+z_certificate+"','%')"
	}
	if(isNotNull(createStartDate)){            
	  queryCriteriaSql += "and a.ITEM_DATE >= '"+format(createStartDate,"yyyy-MM-dd")+"' ";            
	}            
	if(isNotNull(createEndDate)){            
	  queryCriteriaSql += "and a.ITEM_DATE < DATE_FORMAT(DATE_ADD('"+format(createEndDate,"yyyy-MM-dd")+"',INTERVAL 1 DAY),'%Y-%m-%d')";             
	}
  
	var sql = "select a.domainid,"+
		"a.applicationid,"+
		//"a.formid,"+
		"a.ITEM_name, " + //姓名
		"a.ITEM_number, " + //序号
		"a.ITEM_idCardNo, " + //身份证
		"a.ITEM_sex, " + //性别
		"a.ITEM_identificationTheoryScore, " + //鉴定理论成绩
		"DATE_FORMAT(a.ITEM_birth,'%Y-%m-%d')as item_birth, " + //出生日期
		"a.ITEM_identificationOperationScore, " + //鉴定实操分数
		"a.ITEM_education, " + //文化程度
		"a.ITEM_identificationTestResults, " + //鉴定考试结果
		"a.ITEM_company, " + //所在单位
		"a.ITEM_certificateNO, " + //证书编号
		"a.ITEM_job, " + //职业
		"a.ITEM_level, " + //级别
		"a.ITEM_admission, " + //准考证号
		"a.ITEM_workYear, " + //职业申报年限
		"a.ITEM_remarks, " + //备注
		"a.ITEM_date, " + //发证日期
		"a.ID,"+
		"a.ID as ITEM_ID"+
		" from tlk_scores a where a.DOMAINID = '"+getDomainid()+"'" 
	sql=sql+queryCriteriaSql;
	order ="ORDER BY a.ITEM_date"
	sql=sql+order;
	println("sql==========================>" + sql);
	return sql;
  })()]]></sqlFilterScript>
  <procedureFilterScript><![CDATA[]]></procedureFilterScript>
  <filterCondition><![CDATA[[{"field":"name","operator":"LIKE","type":"03","ipField":"","numField":0,"daField":"","sfField":"z_name","syField":"","match":"z_name"},{"field":"idCardNo","operator":"LIKE","type":"03","ipField":"","numField":0,"daField":"","sfField":"z_idCard","syField":"","match":"z_idCard"},{"field":"certificateNO","operator":"LIKE","type":"03","ipField":"","numField":0,"daField":"","sfField":"z_certificate","syField":"","match":"z_certificate"},{"field":"date","operator":">=","type":"03","ipField":"","numField":0,"daField":"","sfField":"createStartDate","syField":"","match":"createStartDate"},{"field":"date","operator":"<=","type":"03","ipField":"","numField":0,"daField":"","sfField":"createEndDate","syField":"","match":"createEndDate"}]]]></filterCondition>
  <commonFilterCondition><![CDATA[[{"field":"z_name","isCommonFilter":"true","paramKey":1641261832612}]]]></commonFilterCondition>
  <authorityCondition>[]</authorityCondition>
  <openType>293</openType>
  <editMode>02</editMode>
  <width>0</width>
  <height>0</height>
</ListView>