行业考试管理-我的培训-列表数据 __LgZds5MVHW3o08T7UcX __LgZds5MVHW3o08T7UcX published UTF-8 post /train/select/user/train json = DATE_FORMAT(plan.item_train_start_time, '%Y-%m-%d') and DATE_FORMAT(now(), '%Y-%m-%d') <= DATE_FORMAT(plan.item_train_end_time, '%Y-%m-%d') " }else if("已结束".equals(status)){ whereStr+=" and DATE_FORMAT(now(), '%Y-%m-%d') > DATE_FORMAT(plan.item_train_end_time, '%Y-%m-%d') " } } } var sql="select '"+getDomainid()+"' as domainid,"+ "person.id,DATE_FORMAT(person.created, '%Y-%m-%d') as created,"+ "plan.item_plan,"+//培训计划 "type.item_point_type,"+//培训类型 "type.id as item_point_type_id,"+//培训类型id "person.item_classroom_type,"+//教室类型 "person.item_person_name,"+//姓名 "person.item_idcard_no,"+//身份证 "person.item_employee_id,"+//职员id "class.item_class_name,"+//班级名称 "person.item_seat,"+//座位号 "classroom.item_longitude,"+//经度 "classroom.item_latitude,"+//纬度 "classroom.item_range,"+//有效范围 "DATE_FORMAT(plan.item_train_start_time, '%Y-%m-%d') as item_train_start_time,"+//培训开始时间 "DATE_FORMAT(plan.item_train_end_time, '%Y-%m-%d') as item_train_end_time,"+//培训结束时间 "case when DATE_FORMAT(now(), '%Y-%m-%d') < DATE_FORMAT(plan.item_train_start_time, '%Y-%m-%d') then '未开始' when DATE_FORMAT(now(), '%Y-%m-%d') >= DATE_FORMAT(plan.item_train_start_time, '%Y-%m-%d') and DATE_FORMAT(now(), '%Y-%m-%d') <= DATE_FORMAT(plan.item_train_end_time, '%Y-%m-%d') then '进行中' when DATE_FORMAT(now(), '%Y-%m-%d') > DATE_FORMAT(plan.item_train_end_time, '%Y-%m-%d') then '已结束' end as status, "+ "person.item_train_domain_name,"+//培训单位 "class.id as item_class_id,"+//教室id "plan.id as item_plan_id "+//计划id "from tlk_train_person person "+ "inner join tlk_train_class_info class on class.id=person.item_class_id "+ "inner join tlk_train_classroom classroom on classroom.id=class.item_classroom_id "+ "inner join tlk_train_plan plan on plan.id=person.item_plan_id "+ "left join tlk_train_point_type type on type.id = person.item_point_type " + 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; })()]]>