<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<ListView id="__vqrormvLe0CKdeFpCJ2">
  <name>userCertification</name>
  <parentId>__33O9dRsTvtyXuJr33bv</parentId>
  <applicationid>__LgZds5MVHW3o08T7UcX</applicationid>
  <pagination>true</pagination>
  <pageLines>05</pageLines>
  <showTotalRow>false</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></searchFormId>
  <autoCompose>false</autoCompose>
  <relatedForm>__JPHvq5gsbT0nuFotaqq</relatedForm>
  <permissionType>public</permissionType>
  <filterScript><![CDATA[]]></filterScript>
  <sqlFilterScript><![CDATA[(function(){    
    var userId= getWebUser().getId();
println("userId--->"+userId);
  var sqlh = "select "+
              "'"+getDomainid()+"' as DOMAINID,"+
              "ID,"+ //用户ID
              "ID as item_ID,"+
              "NAME as item_name," + //保安员姓名
              "FIELD11 as item_ID_TYPE," + //证件类型
              "FIELD12 as item_ID_NUMBER," + //证件号码
              "LOGINNO as item_telephone," + //手机号
              "FIELD13 as item_CERTIFICATIONSTATUS" + //实名状态
              " from " +sysfunction.DS_OBPM+".t_user"+
              " where ID='"+userId+"'";
            println("sqlh---->"+sqlh);
          var datart = findBySQL(sqlh);
 var idCardNo=datart.getItemValueAsString("ID_NUMBER");
println("idCardNo--->"+idCardNo);
//var securityId = getItemValueAsString("securityId"); 
println(idCardNo);
    var sql = "select '"+getDomainid()+"' as domainid,"+
        "a.ITEM_SECURITYID," + //保安员ID
        "a.ITEM_NAME," + //保安员姓名
        "a.ITEM_IDCARDNO," + //证件号码
        "a.ITEM_IDCARDTYPE," + //证件类型
        "CASE a.ITEM_CERTIFICATETYPE WHEN '1' THEN '保安资格证' end ITEM_CERTIFICATETYPE," + //证书类型
        "a.ITEM_CERTIFICATENO," + //证书编号
        "a.ITEM_LEVEL," + //证书等级
        "a.ITEM_CONFIRMDATE," + //鉴定日期
        "a.ITEM_CERTIFICATEFROM," + //发证机关
        "a.ITEM_CERTIFICATEFROMNO," + //发证机关编号
        "a.ITEM_CERTIFICATEDATE," + //发证日期
        "a.ITEM_STATUS," + //证书状态
        "a.ITEM_CULTIVATECOMPANY," + //所属培训机构
        "a.ITEM_COMPANYNAMETOGET," + //发证所在企业
        "a.ITEM_CULTIVATECOMPANYCODE," + //培训机构信用代码
        "a.ITEM_COMPANYNAMETOGETCODE," + //报名企业信用代码
        "a.ITEM_ONEINCHPHOTO," + //一寸照片
        "a.ITEM_BIRTHDAY," + //出生日期
        "a.ITEM_PERSONID" + //资格证报名id
        " from tlk_certification a "+
" LEFT JOIN tlk_system_qualify_person_apply b on a.ITEM_IDCARDNO = b.ITEM_IDCARDNO and b.ITEM_APPLYSTATUS='1' where a.ITEM_IDCARDNO='"+idCardNo+"'";
println(sql);
println("w w w w w w w w w w ww w w w w ");
    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>