<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<ListView id="__iIwhvJqWbp32woMmYQQ">
  <name>五级结业证旧证查询</name>
  <parentId>__xmA8P0JniFiisvoPiWM</parentId>
  <applicationid>__LgZds5MVHW3o08T7UcX</applicationid>
  <pagination>true</pagination>
  <pageLines>10</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>__DDPwNyKyq2wSm7RJltc</searchFormId>
  <autoCompose>false</autoCompose>
  <relatedForm></relatedForm>
  <permissionType>public</permissionType>
  <filterScript><![CDATA[]]></filterScript>
  <sqlFilterScript><![CDATA[(function(){
   var whereStr = " and 1 = 1 "
  var idCardNo = getItemValueAsString("idCard"); 
  //var certificateNO = getItemValueAsString("certificateNO"); 
  var name = getItemValueAsString("name"); 
  var jiguan = getItemValueAsString("jiguan");
  var bianhao = getItemValueAsString("bianhao");
  //var company = getItemValueAsString("company"); 
  var createStartDate = getItemValueAsDate("createStartDate"); 
  var createEndDate = getItemValueAsDate("createEndDate"); 
  var z_name = getItemValueAsString("z_name");  
  var z_idCard = getItemValueAsString("z_idCard"); 
  //var status = getItemValueAsString("status"); 
  if(isNotNull(idCardNo)){            
    whereStr += "and ITEM_IDCARDNO = '"+idCardNo+"' ";            
  } 
  /*if(isNotNull(certificateNO)){            
    whereStr += "and ITEM_certificateNO like concat('%','"+certificateNO+"','%') ";            
  }*/   
  if(isNotNull(bianhao)){            
    whereStr += " and zsbh like concat('%','"+bianhao+"','%') ";            
  }   
  if(isNotNull(name)){            
    whereStr += "and ITEM_name = '"+name+"' ";            
  } 
 if(isNotNull(jiguan)){            
    whereStr = whereStr + " and fzjgmc like concat('%','"+jiguan+"','%')"       
  }
  /*if(isNotNull(company)){            
    queryCriteriaSql = queryCriteriaSql + " and a.ITEM_COMPANYNAMETOGET like concat('%','"+company+"','%')"     
  }*/
   if(isNotNull(z_name)){                                        
    whereStr = whereStr + " and xm like concat('%','"+z_name+"','%')"
  }
  if(isNotNull(z_idCard)){                                        
    whereStr = whereStr + " and idnum like concat('%','"+z_idCard+"','%')"
  }
  if(isNotNull(createStartDate)){            
    whereStr += " and fzrq >= '"+format(createStartDate,"yyyy-MM-dd")+"' ";            
  }            
  if(isNotNull(createEndDate)){            
    whereStr += " and fzrq < DATE_FORMAT(DATE_ADD('"+format(createEndDate,"yyyy-MM-dd")+"',INTERVAL 1 DAY),'%Y-%m-%d')";             
  } 
  /*if(isNotNull(status)){            
    queryCriteriaSql = queryCriteriaSql + " and a.ITEM_STATUS like concat('%','"+status+"','%')"           
  }*/ 
var sql = "select id,id as item_id,xm as item_xm,sex as item_sex,trainName as item_trainName, trainid as domainid,idnum as item_idnum ,case certificateType when '3' then '结业证' end as item_certificateType,"+
" zsbh as item_zsbh , fzrq as item_fzrq,fzjgmc as item_fzjgmc,csrq as item_csrq "+
" from  obpm2.tenant_user_credential_details where trainid='"+getDomainid()+"'  and certificateType='3' "
  sql += whereStr;
  println("------------"+sql)
return sql;
})()
]]></sqlFilterScript>
  <procedureFilterScript><![CDATA[]]></procedureFilterScript>
  <filterCondition><![CDATA[[]]]></filterCondition>
  <commonFilterCondition><![CDATA[[{"field":"z_name","isCommonFilter":"true","paramKey":1652949652787}]]]></commonFilterCondition>
  <authorityCondition>[]</authorityCondition>
  <openType>1</openType>
  <editMode>02</editMode>
  <width>0</width>
  <height>0</height>
</ListView>