<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<ListView id="__i37ipbUND1aoVKHZWZI">
  <name>可确认成绩人员</name>
  <parentId>__hGBmZIJlszexS9jEYx0</parentId>
  <applicationid>__LgZds5MVHW3o08T7UcX</applicationid>
  <pagination>true</pagination>
  <pageLines>10</pageLines>
  <showTotalRow>true</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>__yDzJ2ltb3BWmiTEib7A</searchFormId>
  <autoCompose>true</autoCompose>
  <permissionType>public</permissionType>
  <filterScript><![CDATA[]]></filterScript>
  <sqlFilterScript><![CDATA[(function(){
  var rdoc =getRelateDocument();
  var exam_id = rdoc.getItemValueAsString("exam_id");
    var whereStr= " and 1=1 "
     var person_name = getItemValueAsString("person_name"); 
  if(isNotNull(person_name)){                                        
    whereStr = whereStr + " and item_person_name like '%"+person_name+"%' "
  }  
  var telephone = getItemValueAsString("telephone");  
  if(isNotNull(telephone)){                                        
    whereStr = whereStr + " and item_telephone like '%"+telephone+"%' "
  }
  var idcard_no = getItemValueAsString("idcard_no");  
  if(isNotNull(idcard_no)){                                        
    whereStr = whereStr + " and item_idcard_no like '%"+idcard_no+"%' "
  }
  var domain_name = getItemValueAsString("domain_name");  
  if(isNotNull(domain_name)){                                        
    whereStr = whereStr + " and item_domain_name like '%"+domain_name+"%' "
  }
  var sql="select '"+getDomainid()+"' as domainid,p.created,p.id,p.id as item_id,"+
      "p.item_person_name,p.item_telephone,p.item_idcard_no,p.item_domain_name,p.item_domain_id,p.item_order_person_id,p.item_train_domain_name,"+
      "p.item_train_domain_id  "+
      " from tlk_train_exam_person p where item_exam_id='"+exam_id+"' and item_confirm_status='0' and  item_is_up='0' and item_exam_info in ('0','1')   "+whereStr+
      "  order by created desc "

  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>