<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<ListView id="__Spb1lEvBxL4KWFd10lw">
  <name>送考安排</name>
  <parentId>__jSMkGafJjHFmAX2vrvw</parentId>
  <applicationid>__LgZds5MVHW3o08T7UcX</applicationid>
  <pagination>true</pagination>
  <pageLines>10</pageLines>
  <showTotalRow>true</showTotalRow>
  <refresh>false</refresh>
  <refreshAll>false</refreshAll>
  <newPage>false</newPage>
  <readonly>true</readonly>
  <displayType>relatedForm</displayType>
  <defaultShowMode>month</defaultShowMode>
  <collapsibleShowMode>normal</collapsibleShowMode>
  <showWaterMark>false</showWaterMark>
  <showActivityColumnType>0</showActivityColumnType>
  <searchFormId></searchFormId>
  <autoCompose>true</autoCompose>
  <permissionType>public</permissionType>
  <filterScript><![CDATA[]]></filterScript>
  <sqlFilterScript><![CDATA[(function(){
var sql="select '"+getDomainid()+"' as domainid,a.id,a.id as item_id,a.formid,a.applicationid,a.created,"+
    "item_batch_number,"+//送考批次
     "concat(DATE_FORMAT(item_expect_start_time,'%Y-%m-%d'),'~',DATE_FORMAT(item_expect_end_time,'%Y-%m-%d')) as item_expect_time,"+//期待送考批次
     "item_submit_status,"+//提交状态
     "concat(DATE_FORMAT(item_send_start_time,'%Y-%m-%d %H:%i:%s'),'~',DATE_FORMAT(item_send_end_time,'%Y-%m-%d %H:%i:%s')) as item_send_time,"+//送考时间
     "item_send_status,"+//送考状态
     "item_create_name,"+//创建人
    "item_domain_name,"+//保安公司
     "item_exam_site_name,"+//考试点名称
     "item_exam_site_id,"+//考试点id
     "item_place_name,"+//考场名称
     "item_place_id,"+//考场id
    "item_exam_id,"+//考试id
    "item_up_id,"+//补考id
    "item_max_person_number,"+//保安公司
    "item_create_time,"+//创建时间
     "item_submit_time,"+//提交时间
     "count(b.id) as item_person_number "+//送考人数
     "from tlk_send_exam_batch a left join tlk_batch_person b on a.id = b.item_batch_id where a.item_train_id='"+getDomainid()+"' and a.item_submit_status = '已提交' and a.created >='2025-07-02' "+//送考批次
     "group by a.id "+
    " order by created desc "
println(sql)
    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>