行业考试管理-我的考试-列表数据-根据id查询 __LgZds5MVHW3o08T7UcX __LgZds5MVHW3o08T7UcX published UTF-8 get /train/select/user/exam/byid json = DATE_FORMAT(exam.item_computer_start_date, '%Y-%m-%d') and DATE_FORMAT(now(), '%Y-%m-%d') <= DATE_FORMAT(exam.item_computer_end_date, '%Y-%m-%d') then '进行中' when DATE_FORMAT(now(), '%Y-%m-%d') > DATE_FORMAT(exam.item_computer_end_date, '%Y-%m-%d') 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; })()]]>