<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<Api id="__XqhUhe7z6VcD9aqybBF">
  <name>等级证获取全部班级</name>
  <parentId>__LgZds5MVHW3o08T7UcX</parentId>
  <applicationid>__LgZds5MVHW3o08T7UcX</applicationid>
  <status>published</status>
  <apiGroup></apiGroup>
  <encode>UTF-8</encode>
  <requestType>get</requestType>
  <requestUrl>/exam/ClassInfo</requestUrl>
  <tags></tags>
  <responseType>json</responseType>
  <responseScript><![CDATA[(function(){
var sql = "select '"+getDomainid()+"'as domainid,"+
    "a.applicationid,"+
   "a.formid,"+
"a.ITEM_CLASSNAME," + //班级名称
"DATE_FORMAT(a.ITEM_APPLYTIME, '%Y-%m-%d %H:%i:%S' ) as ITEM_APPLYTIME," + //申请时间
"a.ITEM_CLASSSTATUS," + //班级状态
"DATE_FORMAT(a.ITEM_TRAININGSTARTTIME, '%Y-%m-%d %H:%i:%S' ) as ITEM_TRAININGSTARTTIME," + //开班开始结束
"a.ITEM_TRAININGLOCATION," + //培训地点
"DATE_FORMAT(a.ITEM_GRADUATIONTHEORYTEXTSTARTTIME, '%Y-%m-%d %H:%i:%S' ) as ITEM_GRADUATIONTHEORYTEXTSTARTTIME," + //结业理论考试开始时间
"a.ITEM_GRADUATIONTHEORYTEXTPLACE," + //结业理论考试地点
"DATE_FORMAT(a.ITEM_IDENTIFICATIONTHEORYSTARTTIME, '%Y-%m-%d %H:%i:%S' ) as ITEM_IDENTIFICATIONTHEORYSTARTTIME," + //鉴定理论考试开始时间
"a.ITEM_IDENTIFICATIONTHEORYPLACE," + //鉴定理论考试地点
"a.ITEM_TESTRESULTCONFIRMATIONSTATUS," + //考试成绩确认状态
"COUNT(b.ITEM_NAME) as ITEM_CLASSNUM,"+//班级人员
"CONCAT(a.ITEM_TRAININGSTARTTIME,'~',a.ITEM_TRAININGENDTIME) as ITEM_TRAININGTIME," +//实操考试时间
"CONCAT(a.ITEM_GRADUATIONTHEORYTEXTSTARTTIME,'~',a.ITEM_GRADUATIONTHEORYTEXTENDTIME) as ITEM_GRADUATIONTHEORYTEXTTIME," +//结业-理论考试时间
"CONCAT(a.ITEM_GRADUATIONOPERATIONSTARTTIME,'~',a.ITEM_GRADUATIONOPERATIONENDTIME) as ITEM_GRADUATIONOPERATIONTIME," +//结业-实操考试时间
"CONCAT(a.ITEM_IDENTIFICATIONTHEORYSTARTTIME,'~',a.ITEM_IDENTIFICATIONTHEORYENDTIME) as ITEM_IDENTIFICATIONTHEORYTIME," +//鉴定-理论考试时间
"CONCAT(a.ITEM_IDENTIFICATIONOSTARTTIME,'~',a.ITEM_IDENTIFICATIONOENDTIME) as ITEM_IDENTIFICATIONOTIME," +//鉴定-实操考试时间
"a.ID,"+
"a.ID as ITEM_ID"+
" from tlk_grade_card_class a"+
" LEFT JOIN tms.tlk_level_class_student b on a.ID=b.ITEM_CLASSID GROUP BY a.ID";
  sql += " limit 1000"

var datas = queryByDSName("tms",sql);
return datas;
})()]]></responseScript>
</Api>