行业考试管理-我的考试-列表数据 __LgZds5MVHW3o08T7UcX __LgZds5MVHW3o08T7UcX published UTF-8 post /train/select/user/exam json = DATE_FORMAT(exam.item_computer_start_date, '%Y-%m-%d %H:%i:%s') and DATE_FORMAT(now(), '%Y-%m-%d %H:%i:%s') <= DATE_FORMAT(exam.item_computer_end_date, '%Y-%m-%d %H:%i:%s') " }else if("已结束".equals(status)){ whereStr+=" and DATE_FORMAT(now(), '%Y-%m-%d %H:%i:%s') > DATE_FORMAT(exam.item_computer_end_date, '%Y-%m-%d %H:%i:%s') " } } } var sql="select '"+getDomainid()+"' as domainid,"+ "person.id,DATE_FORMAT(person.created, '%Y-%m-%d %H:%i:%s') as created,"+ "exam.item_plan,"+//培训计划 "exam.item_paper_id,"+//试卷id "person.item_person_name,"+//姓名 "person.item_idcard_no,"+//身份证 "person.item_employee_id,"+//职员id "exam.item_exam_name,"+//考试名称 "exam.item_computer_address,"+//考试地址 "exam.item_attention,"+//注意事项 "CASE "+ " exam.ITEM_exam_kind "+ " WHEN '1' THEN"+ " '补考' "+ " WHEN '0' THEN"+ " '日常考试' "+ " END ITEM_exam_kind," + //考试类型 "person.item_seat,"+//座位号 "person.item_written_score,"+//理论成绩 "person.item_has_written_score,"+//是否已提交理论成绩 "person.item_written_sign_status,"+//理论签到状态 "person.item_face_status,"+//人脸核验状态 "person.item_over_face_status,"+//人脸核验状态 "examination.item_longitude,"+//经度 "examination.item_latitude,"+//纬度 "examination.item_range,"+//有效范围 "DATE_FORMAT(exam.item_computer_start_date, '%Y-%m-%d %H:%i:%s') as item_computer_start_date,"+//培训开始时间 "DATE_FORMAT(exam.item_computer_end_date, '%Y-%m-%d %H:%i:%s') as item_computer_end_date,"+//培训结束时间 "case when DATE_FORMAT(now(), '%Y-%m-%d %H:%i:%s') < DATE_FORMAT(exam.item_computer_start_date, '%Y-%m-%d %H:%i:%s') then '未开始' when DATE_FORMAT(now(), '%Y-%m-%d %H:%i:%s') >= DATE_FORMAT(exam.item_computer_start_date, '%Y-%m-%d %H:%i:%s') and DATE_FORMAT(now(), '%Y-%m-%d %H:%i:%s') <= DATE_FORMAT(exam.item_computer_end_date, '%Y-%m-%d %H:%i:%s') then '进行中' when DATE_FORMAT(now(), '%Y-%m-%d %H:%i:%s') > DATE_FORMAT(exam.item_computer_end_date, '%Y-%m-%d %H:%i:%s') then '已结束' end as status, "+ "person.item_train_domain_name,"+//培训单位 "exam.id as item_exam_id "+//考试id "from tlk_train_exam_person person "+ "inner join tlk_train_exam exam on exam.id=person.item_exam_id "+ "inner join tlk_train_examination_room examination on examination.id=exam.item_examination_id "+whereStr+ " order by person.created desc " var datas = queryByDSName("tms",sql); result.put("data",datas); result.put("code","200"); result.put("msg","OK"); result.put("state", true); return result; })()]]>