<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<ListView id="__92Y8bF5fV66YwF3mCvU">
  <name>train_exam</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-05T06:41:11.000+08:00</lastModifyTime>
  <readonly>false</readonly>
  <displayType>relatedForm</displayType>
  <defaultShowMode>month</defaultShowMode>
  <collapsibleShowMode>normal</collapsibleShowMode>
  <showWaterMark>false</showWaterMark>
  <showActivityColumnType>0</showActivityColumnType>
  <searchFormId>__MR5WRh2NGWmwc5qjtIE</searchFormId>
  <autoCompose>false</autoCompose>
  <relatedForm>__pEwwmPY4NvWGRIrLxS7</relatedForm>
  <permissionType>public</permissionType>
  <filterScript><![CDATA[]]></filterScript>
  <sqlFilterScript><![CDATA[(function(){
     var whereStr=" where 1=1 "
  var plan = getItemValueAsString("plan");  
  if(isNotNull(plan)){                                        
    whereStr = whereStr + " and item_plan like '%"+plan+"%' "
  }

  var exam_name = getItemValueAsString("exam_name");
  if(isNotNull(exam_name)){                                        
    whereStr = whereStr + " and item_exam_name like '%"+exam_name+"%' "
  }
  
  var exam_kind = getItemValueAsString("exam_kind");
  if(isNotNull(exam_kind)){                                        
    whereStr = whereStr + " and item_exam_kind = '"+exam_kind+"' "
  }
  
  var point_type = getItemValueAsString("point_type");
  if(isNotNull(point_type)){                                        
    whereStr = whereStr + " and item_point_type = '"+point_type+"' "
  }
  
  var start_date = getItemValueAsDate("start_date");
  if(isNotNull(start_date)){                                        
    whereStr = whereStr + " and date_format(a.ITEM_computer_start_date,'%Y-%m-%d %H:%i:%S') >= '"+format(start_date,"yyyy-MM-dd HH:mm:ss")+"' "
  }
  
    var end_date = getItemValueAsDate("end_date");
  if(isNotNull(end_date)){                                        
    whereStr = whereStr + " and date_format(a.ITEM_computer_start_date,'%Y-%m-%d %H:%i:%S') <= '"+format(end_date,"yyyy-MM-dd HH:mm:ss")+"' "
  }
  
    var sql = "select  domainid,"+
        "a.formid," + //表单ID
        "a.applicationid," + //应用ID
        "a.ITEM_point_type," + //培训类型
        "a.ITEM_plan," + //培训计划
        "a.ITEM_plan_id," + //培训计划id
        "a.ITEM_exam_name," + //考试名称
        "a.ITEM_exam_kind," + //考试类型
        "a.ITEM_max_number," + //容纳人数
        "date_format(a.ITEM_computer_start_date,'%Y-%m-%d %H:%i:%S') as ITEM_computer_start_date," + //理论考试开始时间
        "date_format(a.ITEM_computer_end_date,'%Y-%m-%d %H:%i:%S') as ITEM_computer_end_date," + //理论考试结束时间
        "a.ITEM_examination_name," + //考场名称
        "a.ITEM_teacher," + //监考人
        "a.ID,"+ 
        "a.created,"+//创建时间 
        "a.created as item_created,"+//创建时间 
        "a.ID as ITEM_ID"+
        " from tlk_train_exam a "+whereStr+
        " order by a.created desc  ";

  println("sql==>" + sql);
  return sql;
})()]]></sqlFilterScript>
  <procedureFilterScript><![CDATA[]]></procedureFilterScript>
  <filterCondition><![CDATA[[]]]></filterCondition>
  <commonFilterCondition><![CDATA[[]]]></commonFilterCondition>
  <authorityCondition>[]</authorityCondition>
  <openType>293</openType>
  <editMode>02</editMode>
  <width>0</width>
  <height>0</height>
</ListView>