<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<ListView id="__iq7nlQmWfBaIk1TVYrp">
  <name>train_exam_person</name>
  <parentId>__hGBmZIJlszexS9jEYx0</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>2025-05-08T03:06:49.000+08:00</lastModifyTime>
  <readonly>false</readonly>
  <displayType>relatedForm</displayType>
  <defaultShowMode>month</defaultShowMode>
  <collapsibleShowMode>normal</collapsibleShowMode>
  <showWaterMark>false</showWaterMark>
  <showActivityColumnType>0</showActivityColumnType>
  <searchFormId>__vfKqZsPxJVsiFortQx5</searchFormId>
  <autoCompose>true</autoCompose>
  <relatedForm>__kYJzSUcq1iL0ltOWW69</relatedForm>
  <permissionType>public</permissionType>
  <filterScript><![CDATA[]]></filterScript>
  <sqlFilterScript><![CDATA[(function(){
  var whereStr= " and 1=1 "
  var classroom_type = getParameter("classroom_type");
  var exam_id = getParameter("exam_id");
  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 exam_info = getItemValueAsString("exam_info");  
  if(isNotNull(exam_info)){                                        
    whereStr = whereStr + " and item_exam_info = '"+exam_info+"' "
  }
  var confirm_status = getItemValueAsString("confirm_status");  
  if(isNotNull(confirm_status)){                                        
    whereStr = whereStr + " and item_confirm_status = '"+confirm_status+"' "
  }
  var written_sign_status = getItemValueAsString("written_sign_status");  
  if(isNotNull(written_sign_status)){                                        
    whereStr = whereStr + " and item_written_sign_status = '"+written_sign_status+"' "
  }
  
  var confirm_start_time = getItemValueAsDate("confirm_start_time");
  if(isNotNull(confirm_start_time)){                                        
    whereStr = whereStr + " and item_confirm_time >= '"+format(confirm_start_time,"yyyy-MM-dd HH:mm:ss")+"' "
  }
  var confirm_end_time = getItemValueAsDate("confirm_end_time");
  if(isNotNull(confirm_end_time)){                                        
    whereStr = whereStr + " and item_confirm_time <= '"+format(confirm_end_time,"yyyy-MM-dd HH:mm:ss")+"' "
  }
  var sql="select domainid,id,id as item_id,formid,applicationid,item_seat,item_person_name,item_has_written_score,item_has_operate_score,item_telephone,item_idcard_no,item_domain_name,item_written_score,item_written_sign_status,item_last_person_id,"+
      "item_operate_score,item_card_status,item_exam_kind,case item_exam_info when '1' then '合格' when '0' then '不合格' else item_exam_info end as item_exam_info,item_confirm_status,item_confirm_time,item_confirm_person   from tlk_train_exam_person where  item_exam_id='"+exam_id+"'"+
      whereStr+" order by item_seat  "
  return sql
  })()]]></sqlFilterScript>
  <procedureFilterScript><![CDATA[]]></procedureFilterScript>
  <filterCondition><![CDATA[[]]]></filterCondition>
  <commonFilterCondition><![CDATA[[]]]></commonFilterCondition>
  <authorityCondition>[]</authorityCondition>
  <openType>277</openType>
  <editMode>02</editMode>
  <width>0</width>
  <height>0</height>
</ListView>