<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<ListView id="__IhIenvKV6C13FygOPIl">
  <name>协会考试记录查询</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-06T03: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></searchFormId>
  <autoCompose>true</autoCompose>
  <relatedForm>__kYJzSUcq1iL0ltOWW69</relatedForm>
  <permissionType>public</permissionType>
  <filterScript><![CDATA[]]></filterScript>
  <sqlFilterScript><![CDATA[(function(){
  var classroom_type = getParameter("classroom_type");
  var exam_id = getParameter("exam_id");
  var sql="select '"+getDomainid()+"' as domainid,p.id,p.id as item_id,p.created,"+
      "p.item_person_name,p.item_telephone,p.item_idcard_no,p.item_domain_name,p.item_train_domain_name,"+
      "p.item_written_score,p.item_written_sign_status,p.item_operate_score,"+
      "p.item_exam_info,"+
      "tp.item_plan,type.item_point_type,"+
      "e.item_exam_name,e.item_examination_name,e.item_computer_address,e.item_computer_start_date,e.item_computer_end_date,"+
      "case e.item_exam_kind  when '1' then '补考' when '0' then '日常考试' else e.item_exam_kind end as item_exam_kind "+
      " from tlk_train_exam_person p inner join tlk_train_plan tp on p.item_plan_id=tp.id  "+ 
        " inner join tlk_train_exam e on e.id = p.item_exam_id "+
        " left join tlk_train_point_type type on type.id = tp.item_point_type " +
        " where  1=1 "+
      " order by p.created  desc "
  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>