package com.fh.controller.sunvote.homework; import java.io.PrintWriter; import java.text.DateFormat; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Calendar; import java.util.Collections; import java.util.Comparator; import java.util.Date; import java.util.HashMap; import java.util.List; import java.util.Map; import javax.annotation.Resource; import org.springframework.beans.propertyeditors.CustomDateEditor; import org.springframework.stereotype.Controller; import org.springframework.util.StringUtils; import org.springframework.web.bind.WebDataBinder; import org.springframework.web.bind.annotation.InitBinder; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.ResponseBody; import org.springframework.web.servlet.ModelAndView; import com.fh.bean.HomeClass; import com.fh.bean.Homework; import com.fh.bean.HomeworkQuestion; import com.fh.controller.api.ResponseGson; import com.fh.controller.base.BaseController; import com.fh.entity.Page; import com.fh.service.sunvote.coursemanagement.CourseManagementManager; import com.fh.service.sunvote.homework.HomeworkManager; import com.fh.service.sunvote.homework.HomeworkReportManager; import com.fh.service.sunvote.homeworkproblem.HomeworkProblemManager; import com.fh.service.sunvote.student.StudentManager; import com.fh.service.sunvote.teacher.TeacherManager; import com.fh.service.sunvote.teacher.impl.TeacherService; import com.fh.util.AppUtil; import com.fh.util.Jurisdiction; import com.fh.util.ObjectExcelView; import com.fh.util.PageData; import com.fh.util.StringUtil; import com.google.gson.Gson; /** * 说明：作业 创建人：FH Q313596790 * 创建时间：2019-03-07 */ @Controller @RequestMapping(value = "/homework") public class HomeworkController extends BaseController { String menuUrl = "homework/list.do"; // 菜单地址(权限用) @Resource(name = "homeworkService") private HomeworkManager homeworkService; @Resource(name = "homeworkReporService") private HomeworkReportManager homeworkReporService; @Resource(name = "homeworkproblemService") private HomeworkProblemManager homeworkproblemService; @Resource(name="coursemanagementService") private CourseManagementManager coursemanagementService; @Resource(name="homeworkReporService") private HomeworkReportManager homeworkReporkService; @Resource(name="studentService") private StudentManager studentService; @Resource(name = "teacherService") private TeacherManager teacherService; /** * 保存 * * @param * @throws Exception */ @RequestMapping(value = "/save") public ModelAndView save() throws Exception { logBefore(logger, Jurisdiction.getUsername() + "新增Homework"); ModelAndView mv = this.getModelAndView(); PageData pd = new PageData(); pd = this.getPageData(); pd.put("HOMEWORK_ID", this.get32UUID()); // 主键 homeworkService.save(pd); mv.addObject("msg", "success"); mv.setViewName("save_result"); return mv; } /** * 删除 * * @param out * @throws Exception */ @RequestMapping(value = "/delete") public void delete(PrintWriter out) throws Exception { logBefore(logger, Jurisdiction.getUsername() + "删除Homework"); PageData pd = new PageData(); pd = this.getPageData(); homeworkService.delete(pd); out.write("success"); out.close(); } /** * 修改 * * @param * @throws Exception */ @RequestMapping(value = "/edit") public ModelAndView edit() throws Exception { ModelAndView mv = this.getModelAndView(); PageData pd = new PageData(); pd = this.getPageData(); mv.addObject("msg", "success"); mv.setViewName("save_result"); return mv; } /** * 列表 * * @param page * @throws Exception */ @RequestMapping(value = "/list") public ModelAndView list(Page page) throws Exception { logBefore(logger, Jurisdiction.getUsername() + "列表Homework"); ModelAndView mv = this.getModelAndView(); PageData pd = new PageData(); pd = this.getPageData(); if(pd.get("SCHOOL_ID") == null){ pd.put("TEACHER_ID", getTeacherID()); } String keywords = pd.getString("keywords"); // 关键词检索条件 if (null != keywords && !"".equals(keywords)) { pd.put("keywords", keywords.trim()); } page.setPd(pd); page.setLangIsChina(isChineseLanguageClient()); List varList = homeworkService.list(page); // 列出Homework列表 if(isChineseLanguageClient()){ mv.setViewName("sunvote/homework/homework_list"); }else{ mv.setViewName("sunvote/homework/en_homework_list"); } mv.addObject("varList", varList); mv.addObject("pd", pd); mv.addObject("QX", Jurisdiction.getHC()); // 按钮权限 return mv; } /** * 去新增页面 * * @param * @throws Exception */ @RequestMapping(value = "/goAdd") public ModelAndView goAdd() throws Exception { ModelAndView mv = this.getModelAndView(); PageData pd = new PageData(); pd = this.getPageData(); mv.setViewName("sunvote/homework/homework_edit"); mv.addObject("msg", "save"); mv.addObject("pd", pd); return mv; } /** * 去新增页面 * * @param * @throws Exception */ @RequestMapping(value = "/goAdd2") public ModelAndView goAdd2() throws Exception { ModelAndView mv = this.getModelAndView(); PageData pd = new PageData(); pd = this.getPageData(); // 添加科目ID pd.put("TEACHER_ID", getTeacherID()); pd.put("SUBJECT_ID", homeworkService.querySubjectId(pd)); if(isChineseLanguageClient()){ mv.setViewName("sunvote/homework/homework_edit2"); }else{ mv.setViewName("sunvote/homework/en_homework_edit2"); } mv.addObject("msg", "save"); mv.addObject("operation", "add"); mv.addObject("pd", pd); return mv; } /** * 去修改页面 * * @param * @throws Exception */ @RequestMapping(value = "/goEdit") public ModelAndView goEdit() throws Exception { ModelAndView mv = this.getModelAndView(); PageData pd = new PageData(); pd = this.getPageData(); pd = homeworkService.findById(pd); // 根据ID读取 mv.setViewName("sunvote/homework/homework_edit"); mv.addObject("msg", "edit"); mv.addObject("pd", pd); return mv; } /** * 去修改页面 * * @param * @throws Exception */ @RequestMapping(value = "/goEdit2") public ModelAndView goEdit2() throws Exception { ModelAndView mv = this.getModelAndView(); PageData pd = new PageData(); pd = this.getPageData(); pd = homeworkService.findById(pd); // 根据ID读取 pd.put("QUESTIONS", homeworkproblemService.listProblem(pd)); pd.put("TEACHER_ID", getTeacherID()); if(isChineseLanguageClient()){ mv.setViewName("sunvote/homework/homework_edit2"); }else{ mv.setViewName("sunvote/homework/en_homework_edit2"); } mv.addObject("msg", "edit"); mv.addObject("operation", "edit"); mv.addObject("pd", pd); return mv; } /** * 去预览页面 * * @param * @throws Exception */ @RequestMapping(value = "/goView") public ModelAndView goView() throws Exception { ModelAndView mv = this.getModelAndView(); PageData pd = new PageData(); pd = this.getPageData(); pd = homeworkService.findById(pd); // 根据ID读取 pd.put("QUESTIONS", homeworkproblemService.listProblem(pd)); pd.put("TEACHER_ID", getTeacherID()); if(isChineseLanguageClient()){ mv.setViewName("sunvote/homework/homework_view"); }else{ mv.setViewName("sunvote/homework/en_homework_view"); } mv.addObject("msg", "edit"); mv.addObject("operation", "view"); mv.addObject("pd", pd); return mv; } public static String getWeekStart(int cur){ SimpleDateFormat format = new SimpleDateFormat("YYYY-MM-dd"); Calendar ca = Calendar.getInstance(); ca.setFirstDayOfWeek(Calendar.MONDAY); int a = ca.getFirstDayOfWeek(); ca.set(Calendar.DAY_OF_WEEK, a); // Sunday ca.add(Calendar.DATE, cur * 7); String weekEnd = format.format(ca.getTime()); return weekEnd; } public static String getWeekEnd(int cur){ SimpleDateFormat format = new SimpleDateFormat("YYYY-MM-dd"); Calendar ca = Calendar.getInstance(); ca.setFirstDayOfWeek(Calendar.MONDAY); int a = ca.getFirstDayOfWeek(); ca.set(Calendar.DAY_OF_WEEK, a+6); // Sunday ca.add(Calendar.DATE, cur * 7); String weekEnd = format.format(ca.getTime()); return weekEnd + " 23:59:59"; } /** * 传入homework_id * 查询该场课后练的整体情况，最高分，最低分，平均分，总分，总题数，未答人数等 * 未答人数列表 * @return * @throws Exception */ @RequestMapping(value = "/report2") public ModelAndView report2() throws Exception { PageData pageData = this.getPageData(); ModelAndView modelAndView = getModelAndView(); String homeworkId = pageData.getString("HOMEWORK_ID"); if(!StringUtils.isEmpty(homeworkId.trim())){ pageData = homeworkService.findById(pageData); List data = homeworkReporkService.findNoAnswerByHomeworkID(pageData); pageData.put("NO_COUNT", data.size()); modelAndView.addObject("page_data", pageData); // 报表统计情况 modelAndView.addObject("data", data);// 未答学生列表 } if(isChineseLanguageClient()){ modelAndView.setViewName("sunvote/homework/homework_report"); }else{ modelAndView.setViewName("sunvote/homework/en_homework_report"); } return modelAndView; } /** * 传入homework_id * index 第几题 * @return * @throws Exception */ @RequestMapping(value = "/homeworkindex",produces = "text/html;charset=UTF-8") @ResponseBody public Object homeworkindex() throws Exception { PageData pageData = this.getPageData(); String homeworkId = pageData.getString("HOMEWORK_ID"); String index = pageData.getString("INDEX"); int indexint = Integer.parseInt(index); List data = homeworkReporkService.findNoAnswerByHomeworkID(pageData); pageData = homeworkService.findById(pageData); pageData.put("RANK", indexint); pageData = homeworkproblemService.findByCodeAndRank(pageData); pageData.remove("HOMEWORKPROBLEM_ID"); pageData.remove("HOMEWORK_ID"); pageData.remove("CODE"); pageData.remove("RANK"); pageData.remove("NAME"); pageData.remove("TYPE"); String optionNumStr = pageData.getString("OPTION_NUM"); String rightAnswer = pageData.getString("RIGHT_ANSWER"); rightAnswer = rightAnswer.toUpperCase(); int optionNum = Integer.parseInt(optionNumStr); List> resultData = new ArrayList(); for (int i = 0; i < optionNum; i++) { List optionAnswer = new ArrayList(); resultData.add(optionAnswer); for (PageData pd : data) { String answer = pd.getString("ANSWER"); if (!StringUtils.isEmpty(answer)) { String[] answers = answer.split(";"); if (answers.length >= indexint - 1) { String ans = answers[indexint - 1]; String[] anss = ans.split(","); if (anss != null && anss.length == 2) { char option = (char)('A' + i) ; if(anss[0] != null){ if(anss[0].contains("" + option)){ optionAnswer.add(pd.getString("STUDENT_NAME")); } } } } } } } Map map = new HashMap(); map.put("ANSWER", rightAnswer); map.put("DATA", resultData); return new Gson().toJson(map); } /** * 去修改页面 * * @param * @throws Exception */ @RequestMapping(value = "/report") public ModelAndView report() throws Exception { ModelAndView mv = this.getModelAndView(); PageData pd = new PageData(); pd = this.getPageData(); if(pd.get("SCHOOL_ID") == null || "".equals(pd.get("SCHOOL_ID").toString().trim())){ pd.put("TEACHER_ID", getTeacherID()); } if(pd.get("CURRENT_WEEK") == null && pd.get("START_DATE") == null && pd.get("END_DATE") == null){ pd.put("CURRENT_WEEK", "0"); String currentWeek = pd.getString("CURRENT_WEEK"); int current = Integer.parseInt(currentWeek); pd.put("START_DATE", getWeekStart(current)); pd.put("END_DATE", getWeekEnd(current)); }else if(pd.get("CURRENT_WEEK") != null){ String currentWeek = pd.getString("CURRENT_WEEK"); int current = Integer.parseInt(currentWeek); pd.put("START_DATE", getWeekStart(current)); pd.put("END_DATE", getWeekEnd(current)); } // 班级信息 List list = coursemanagementService.listTeacherClass(pd); for(PageData temp : list){ temp.remove("HEADMASTER_ID"); temp.remove("SCHOOL_ID"); temp.remove("GRADE_ID"); temp.remove("TEACHER_ID"); temp.remove("KEYBOARD_TYPE"); temp.remove("BASESTATION_ID"); temp.put("CLASS_ID", temp.get("ID")); temp.remove("ID"); } if(pd.get("CLASS_ID") == null && list.size() > 0){ pd.put("CLASS_ID", list.get(0).get("CLASS_ID")); } pd.put("CLASSES", list); if (pd.get("CLASS_ID") != null) { // 对应班级数据 PageData data = new PageData(); List studentList = studentService.findByClassId(pd); pd.put("COMPLETE_COUNT", "1"); List homeworkList = homeworkService.listAll(pd); List dataList = homeworkService.report(pd); for (PageData stuPd : studentList) { double all = 0; double get = 0; int sc = 0 ; int ac = 0 ; for (PageData dpd : dataList) { if (stuPd.get("ID") != null && dpd.get("STUDENT_ID") != null && dpd.get("STUDENT_ID").equals(stuPd.get("ID")) && isIn(dpd.getString("HOMEWORK_ID"),homeworkList)) { stuPd.put(dpd.get("HOMEWORK_ID"), dpd.get("STUDENT_SCORE")); try { get += Double.parseDouble(dpd.get("STUDENT_SCORE") .toString()); } catch (Exception ex) { } try { all += Double.parseDouble(dpd.get("PAPER_SCORE") .toString()); } catch (Exception ex) { } try { sc += Integer.parseInt(dpd.get("COMPLETE_COUNT") .toString()); } catch (Exception ex) { } try { ac += Integer.parseInt(dpd.get("QUESTION_COUNT") .toString()); } catch (Exception ex) { } } } stuPd.put("STUDENT_ALL_SCORE", get); stuPd.put("PAPER_ALL_SCORE", all); stuPd.put("COMPLETE_COUNT", sc); stuPd.put("ALL_COUNT", ac); stuPd.remove("SCHOOL_ID"); stuPd.remove("SEX"); stuPd.remove("CLASS_ID"); stuPd.remove("NUMBER"); stuPd.put("STUDENT_ID", stuPd.get("ID")); stuPd.remove("ID"); } for (PageData hpd : homeworkList) { hpd.remove("QUESTION_COUNT"); hpd.remove("COMPLETE_COUNT"); hpd.remove("SUBJECT_ID"); hpd.remove("SCHOOL_ID"); hpd.remove("GRADE_ID"); hpd.remove("SUMBIT_DATE"); hpd.remove("MODIFY_DATE"); hpd.remove("TEACHER_ID"); hpd.remove("CREATE_DATE"); hpd.remove("CLASS_ID"); hpd.remove("CODE"); hpd.remove("GET_MAX_SCORE"); hpd.remove("HOMEWORK_DESC"); } data.put("HOMEWORKS", homeworkList);// data.put("STUDENTS", studentList); pd.put("DATA", data); }else{ pd.put("CLASS_ID", ""); } pd.remove("JSON"); if(isChineseLanguageClient()){ mv.setViewName("sunvote/homework/homework_report"); }else{ mv.setViewName("sunvote/homework/en_homework_report"); } mv.addObject("pd", pd); return mv; } private boolean isIn(String homeworkId,List data){ if(data != null && homeworkId != null){ for(PageData pd : data){ if(homeworkId.equals(pd.get("HOMEWORK_ID"))){ return true; } } } return false; } /** * 去修改页面 * * @param * @throws Exception */ @RequestMapping(value = "/student") public ModelAndView student() throws Exception { ModelAndView mv = this.getModelAndView(); PageData pd = new PageData(); pd = this.getPageData(); pd.put("TEACHER_ID", getTeacherID()); if(pd.get("CURRENT_WEEK") == null && pd.get("START_DATE") == null && pd.get("END_DATE") == null){ pd.put("CURRENT_WEEK", "0"); String currentWeek = pd.getString("CURRENT_WEEK"); int current = Integer.parseInt(currentWeek); pd.put("START_DATE", getWeekStart(current)); pd.put("END_DATE", getWeekEnd(current)); }else if(pd.get("CURRENT_WEEK") != null){ String currentWeek = pd.getString("CURRENT_WEEK"); int current = Integer.parseInt(currentWeek); pd.put("START_DATE", getWeekStart(current)); pd.put("END_DATE", getWeekEnd(current)); } String studentId = pd.getString("STUDENT_ID") ; //pd.remove("STUDENT_ID"); List dataList = homeworkService.report(pd); pd.put("DATA", dataList); if(pd.get("CLASS_ID") != null){ List studentList = studentService.findByClassId(pd); pd.put("STUDENTS", studentList); } pd.remove("JSON"); pd.put("STUDENT_ID", studentId); if(isChineseLanguageClient()){ mv.setViewName("sunvote/homework/homework_student_report"); }else{ mv.setViewName("sunvote/homework/en_homework_student_report"); } mv.addObject("pd", pd); Gson gson = new Gson(); mv.addObject("data",gson.toJson(pd)); return mv; } /** * 去修改页面 * * @param * @throws Exception */ @RequestMapping(value = "/student_data", produces = "application/json;charset=UTF-8") @ResponseBody public String studentData() throws Exception { PageData pd = new PageData(); pd = this.getPageData(); pd.put("TEACHER_ID", getTeacherID()); if(pd.get("CURRENT_WEEK") == null && pd.get("START_DATE") == null && pd.get("END_DATE") == null){ pd.put("CURRENT_WEEK", "0"); String currentWeek = pd.getString("CURRENT_WEEK"); int current = Integer.parseInt(currentWeek); pd.put("START_DATE", getWeekStart(current)); pd.put("END_DATE", getWeekEnd(current)); }else if(pd.get("CURRENT_WEEK") != null){ String currentWeek = pd.getString("CURRENT_WEEK"); int current = Integer.parseInt(currentWeek); pd.put("START_DATE", getWeekStart(current)); pd.put("END_DATE", getWeekEnd(current)); } String studentId = pd.getString("STUDENT_ID") ; pd.remove("STUDENT_ID"); List dataList = homeworkService.report(pd); pd.put("DATA", dataList); if(pd.get("CLASS_ID") != null){ List studentList = studentService.findByClassId(pd); pd.put("STUDENTS", studentList); } pd.remove("JSON"); pd.put("STUDENT_ID", studentId); Gson gson = new Gson(); return gson.toJson(pd); } /** * 去修改页面 * * @param * @throws Exception */ @RequestMapping(value = "/homework_report") public ModelAndView homework_report() throws Exception { ModelAndView mv = this.getModelAndView(); PageData pd = new PageData(); pd = this.getPageData(); pd.put("TEACHER_ID", getTeacherID()); if(pd.get("CURRENT_WEEK") == null && pd.get("START_DATE") == null && pd.get("END_DATE") == null){ pd.put("CURRENT_WEEK", "0"); String currentWeek = pd.getString("CURRENT_WEEK"); int current = Integer.parseInt(currentWeek); pd.put("START_DATE", getWeekStart(current)); pd.put("END_DATE", getWeekEnd(current)); }else if(pd.get("CURRENT_WEEK") != null){ String currentWeek = pd.getString("CURRENT_WEEK"); int current = Integer.parseInt(currentWeek); pd.put("START_DATE", getWeekStart(current)); pd.put("END_DATE", getWeekEnd(current)); } if(pd.get("HOMEWORK_ID") != null){ List dataList = homeworkService.report(pd); Collections.sort(dataList,new Comparator(){ @Override public int compare(PageData o1, PageData o2) { String o1GetScore = o1.getString("STUDENT_SCORE"); String o2GetScore = o2.getString("STUDENT_SCORE"); float o1score = 0 ; float o2score = 0 ; try{ o1score = Float.parseFloat(o1GetScore); }catch(Exception e){ o1score = -1 ; } try{ o2score = Float.parseFloat(o2GetScore); }catch(Exception e){ o2score = -1 ; } return o1score - o2score > 0 ? -1 : 1; } }); for(int i = 0 ; i < dataList.size(); i++){ PageData tpd1 = dataList.get(i); if(i == 0){ tpd1.put("RANK", (i+1)); }else{ PageData tpd2 = dataList.get(i-1); String o1GetScore = tpd1.getString("STUDENT_SCORE"); String o2GetScore = tpd2.getString("STUDENT_SCORE"); float o1score = 0 ; float o2score = 0 ; try{ o1score = Float.parseFloat(o1GetScore); }catch(Exception e){ o1score = -1 ; } try{ o2score = Float.parseFloat(o2GetScore); }catch(Exception e){ o2score = -1 ; } if(o2score - o1score == 0){ tpd1.put("RANK",tpd2.get("RANK")); }else{ tpd1.put("RANK", (i+1)); } } } pd.put("DATA", dataList); } if(pd.get("CLASS_ID") != null){ List studentList = studentService.findByClassId(pd); pd.put("STUDENTS", studentList); } pd.put("HOMEWORKINFO", homeworkService.findById(pd)); pd.remove("JSON"); mv.setViewName("sunvote/homework/homework_item_report"); mv.addObject("pd", pd); return mv; } @RequestMapping(value = "/homework_report_data" , produces = "application/json;charset=UTF-8") @ResponseBody public String homeworkReportData() throws Exception { ModelAndView mv = this.getModelAndView(); PageData pd = new PageData(); pd = this.getPageData(); pd.put("TEACHER_ID", getTeacherID()); if(pd.get("CURRENT_WEEK") == null && pd.get("START_DATE") == null && pd.get("END_DATE") == null){ pd.put("CURRENT_WEEK", "0"); String currentWeek = pd.getString("CURRENT_WEEK"); int current = Integer.parseInt(currentWeek); pd.put("START_DATE", getWeekStart(current)); pd.put("END_DATE", getWeekEnd(current)); }else if(pd.get("CURRENT_WEEK") != null){ String currentWeek = pd.getString("CURRENT_WEEK"); int current = Integer.parseInt(currentWeek); pd.put("START_DATE", getWeekStart(current)); pd.put("END_DATE", getWeekEnd(current)); } if(pd.get("HOMEWORK_ID") != null){ List dataList = homeworkService.report(pd); pd.put("DATA", dataList); } if(pd.get("CLASS_ID") != null){ List studentList = studentService.findByClassId(pd); pd.put("STUDENTS", studentList); } pd.remove("JSON"); Gson gson = new Gson(); return gson.toJson(pd); } /** * 批量删除 * * @param * @throws Exception */ @RequestMapping(value = "/deleteAll") @ResponseBody public Object deleteAll() throws Exception { logBefore(logger, Jurisdiction.getUsername() + "批量删除Homework"); PageData pd = new PageData(); Map map = new HashMap(); pd = this.getPageData(); List pdList = new ArrayList(); String DATA_IDS = pd.getString("DATA_IDS"); if (null != DATA_IDS && !"".equals(DATA_IDS)) { String ArrayDATA_IDS[] = DATA_IDS.split(","); homeworkService.deleteHomeworkAll(ArrayDATA_IDS); pd.put("msg", "ok"); } else { pd.put("msg", "no"); } pdList.add(pd); map.put("list", pdList); return AppUtil.returnObject(pd, map); } /** * 导出到excel * * @param * @throws Exception */ @RequestMapping(value = "/excel") public ModelAndView exportExcel() throws Exception { logBefore(logger, Jurisdiction.getUsername() + "导出Homework到excel"); if (!Jurisdiction.buttonJurisdiction(menuUrl, "cha")) { return null; } ModelAndView mv = new ModelAndView(); PageData pd = new PageData(); pd = this.getPageData(); Map dataMap = new HashMap(); List titles = new ArrayList(); titles.add("作业代码"); // 1 titles.add("作业名称"); // 2 titles.add("科目ID"); // 3 titles.add("班级ID"); // 4 titles.add("年级ID"); // 5 titles.add("学校ID"); // 6 titles.add("需要完成时间"); // 7 titles.add("创建时间"); // 8 titles.add("修改时间"); // 9 titles.add("完成次数"); // 10 titles.add("总分"); // 11 dataMap.put("titles", titles); List varOList = homeworkService.listAll(pd); List varList = new ArrayList(); for (int i = 0; i < varOList.size(); i++) { PageData vpd = new PageData(); vpd.put("var1", varOList.get(i).getString("CODE")); // 1 vpd.put("var2", varOList.get(i).getString("NAME")); // 2 vpd.put("var3", varOList.get(i).getString("SUBJECT_ID")); // 3 vpd.put("var4", varOList.get(i).getString("CLASS_ID")); // 4 vpd.put("var5", varOList.get(i).getString("GRADE_ID")); // 5 vpd.put("var6", varOList.get(i).getString("SCHOOL_ID")); // 6 vpd.put("var7", varOList.get(i).getString("COMPLETE_DATE")); // 7 vpd.put("var8", varOList.get(i).getString("CREATE_DATE")); // 8 vpd.put("var9", varOList.get(i).getString("MODIFY_DATE")); // 9 vpd.put("var10", varOList.get(i).get("COMPLETE_COUNT").toString()); // 10 vpd.put("var11", varOList.get(i).get("ALL_SCORE").toString()); // 11 varList.add(vpd); } dataMap.put("varList", varList); ObjectExcelView erv = new ObjectExcelView(); mv = new ModelAndView(erv, dataMap); return mv; } @InitBinder public void initBinder(WebDataBinder binder) { DateFormat format = new SimpleDateFormat("yyyy-MM-dd"); binder.registerCustomEditor(Date.class, new CustomDateEditor(format, true)); } /** * 批量删除 * * @param * @throws Exception */ @RequestMapping(value = "/homereport", produces = "application/json;charset=UTF-8") @ResponseBody public String getHomeReport() throws Exception { PageData pd = this.getPageData(); if(pd.get("HOMEWORK_ID") != null && !"".equals(pd.get("HOMEWORK_ID").toString().trim())){ pd = homeworkService.findById(pd); if(pd != null){ List data = homeworkReporService.findByHomeworkID(pd); pd.put("STUDENTS", data); }else{ pd.put("HOMEWORK_ID", "no"); } }else{ pd.put("HOMEWORK_ID", "no data"); } Gson gson = new Gson(); return gson.toJson(pd); } /** * 列表 * * @param page * @throws Exception */ @RequestMapping(value = "/listdata", produces = "application/json;charset=UTF-8") @ResponseBody public String listdata(Page page) throws Exception { PageData pd = new PageData(); pd = this.getPageData(); String keywords = pd.getString("keywords"); // 关键词检索条件 if (null != keywords && !"".equals(keywords)) { pd.put("keywords", keywords.trim()); } page.setPd(pd); List varList = homeworkService.list(page); // 列出Homework列表 Gson gson = new Gson(); return gson.toJson(varList); } @RequestMapping(value = "/savedata", produces = "application/json;charset=UTF-8") @ResponseBody public String savedata() throws Exception { PageData pd = new PageData(); pd = this.getPageData(); pd.put("HOMEWORK_ID", this.get32UUID()); pd.put("SUBJECT_ID", homeworkService.querySubjectId(pd)); homeworkService.save(pd); ResponseGson responseGson = new ResponseGson(); responseGson.setData(pd.getString("HOMEWORK_ID")); return responseGson.toJson(); } @RequestMapping(value = "/uploadHomework", produces = "application/json;charset=UTF-8") @ResponseBody public String uploadHomework() throws Exception { PageData pd = new PageData(); pd = this.getPageData(); DateFormat format = new SimpleDateFormat("yyyy-MM-dd"); String data = pd.getJsonString(); ResponseGson responseGson = new ResponseGson(); Homework homework = Homework.parse(data); pd.put("ID", getTeacherID()); PageData tmpd = teacherService.findById(pd); PageData hpd = new PageData(); if (homework != null) { hpd.put("CODE", get32UUID()); hpd.put("NAME", homework.getNAME()); if(homework.getSUBJECT_ID() == null){ pd.put("TEACHER_ID", homework.getTEACHER_ID()); List slist = homeworkService.querySubjectId(pd); if(slist.size() > 0){ homework.setSUBJECT_ID(slist.get(0).getString("SUBJECT_ID")); } } hpd.put("SUBJECT_ID", homework.getSUBJECT_ID()); hpd.put("ALL_SCORE", homework.getALL_SCORE()); hpd.put("HOMEWORK_DESC", homework.getHOMEWORK_DESC()); hpd.put("QUESTION_COUNT", homework.getQUESTION_COUNT()); hpd.put("CREATE_DATE", format.format(new Date())); hpd.put("MODIFY_DATE", format.format(new Date())); hpd.put("COMPLETE_COUNT", 0); hpd.put("TEACHER_ID", homework.getTEACHER_ID()); hpd.put("SCHOOL_ID", tmpd.get("SCHOOL_ID")); hpd.put("COMPLETE_DESC", ""); if (homework.getCLASSLIST() != null && homework.getCLASSLIST().size() > 0 && homework.getQUESTIONS() != null && homework.getQUESTIONS().size() > 0) { for (HomeClass homeclass : homework.getCLASSLIST()) { hpd.put("CLASS_ID", homeclass.getCLASS_ID()); hpd.put("COMPLETE_DATE", homeclass.getCOMPLETE_DATE()); hpd.put("HOMEWORK_ID", this.get32UUID()); homeworkService.save(hpd); } for (HomeworkQuestion homeworkQuestion : homework .getQUESTIONS()) { PageData qpd = new PageData(); qpd.put("RANK", homeworkQuestion.getRANK()); qpd.put("CODE", hpd.get("CODE")); qpd.put("NAME", homeworkQuestion.getNAME()); qpd.put("OPTION_NUM", homeworkQuestion.getOPTION_NUM()); qpd.put("SCORE", homeworkQuestion.getSCORE()); qpd.put("RIGHT_ANSWER", homeworkQuestion.getRIGHT_ANSWER()); qpd.put("TYPE", homeworkQuestion.getTYPE()); qpd.put("HOMEWORKPROBLEM_ID", this.get32UUID()); qpd.put("HOMEWORK_ID", hpd.get("CODE")); homeworkproblemService.save(qpd); } responseGson.setData(hpd.getString("CODE")); } else { responseGson.setDataError(); } } else { responseGson.setDataError(); } return responseGson.toJson(); } @RequestMapping(value = "/updateHomework", produces = "application/json;charset=UTF-8") @ResponseBody public String updateHomework() throws Exception { PageData pd = new PageData(); pd = this.getPageData(); DateFormat format = new SimpleDateFormat("yyyy-MM-dd"); String data = pd.getJsonString(); ResponseGson responseGson = new ResponseGson(); Homework homework = Homework.parse(data); pd.put("ID", getTeacherID()); PageData tmpd = teacherService.findById(pd); PageData hpd = new PageData(); if (homework != null) { if (homework.getHOMEWORK_ID() != null && !"".equals(homework.getHOMEWORK_ID().trim())) { hpd.put("HOMEWORK_ID", homework.getHOMEWORK_ID()); hpd = homeworkService.findById(hpd); if(hpd != null){ hpd.put("NAME", homework.getNAME()); hpd.put("SUBJECT_ID", homework.getSUBJECT_ID()); hpd.put("ALL_SCORE", homework.getALL_SCORE()); hpd.put("HOMEWORK_DESC", homework.getHOMEWORK_DESC()); hpd.put("QUESTION_COUNT", homework.getQUESTION_COUNT()); hpd.put("CREATE_DATE", format.format(new Date())); hpd.put("MODIFY_DATE", format.format(new Date())); hpd.put("COMPLETE_COUNT", 0); hpd.put("TEACHER_ID", homework.getTEACHER_ID()); hpd.put("COMPLETE_DESC", ""); hpd.put("SCHOOL_ID", tmpd.get("SCHOOL_ID")); if(homeworkService.findByCode(hpd).size() > 1){ hpd.put("CODE", get32UUID()); for (HomeClass homeclass : homework.getCLASSLIST()) { hpd.put("CLASS_ID", homeclass.getCLASS_ID()); hpd.put("COMPLETE_DATE", homeclass.getCOMPLETE_DATE()); homeworkService.edit(hpd); } for (HomeworkQuestion homeworkQuestion : homework .getQUESTIONS()) { PageData qpd = new PageData(); qpd.put("RANK", homeworkQuestion.getRANK()); qpd.put("CODE", hpd.get("CODE")); qpd.put("NAME", homeworkQuestion.getNAME()); qpd.put("OPTION_NUM", homeworkQuestion.getOPTION_NUM()); qpd.put("SCORE", homeworkQuestion.getSCORE()); qpd.put("RIGHT_ANSWER", homeworkQuestion.getRIGHT_ANSWER()); qpd.put("TYPE", homeworkQuestion.getTYPE()); qpd.put("HOMEWORKPROBLEM_ID", this.get32UUID()); qpd.put("HOMEWORK_ID", hpd.get("CODE")); homeworkproblemService.save(qpd); } responseGson.setData(hpd.getString("CODE")); }else{ for (HomeClass homeclass : homework.getCLASSLIST()) { hpd.put("CLASS_ID", homeclass.getCLASS_ID()); hpd.put("COMPLETE_DATE", homeclass.getCOMPLETE_DATE()); homeworkService.edit(hpd); } homeworkproblemService.deleteByCode(hpd); for (HomeworkQuestion homeworkQuestion : homework .getQUESTIONS()) { PageData qpd = new PageData(); qpd.put("RANK", homeworkQuestion.getRANK()); qpd.put("CODE", hpd.get("CODE")); qpd.put("NAME", homeworkQuestion.getNAME()); qpd.put("OPTION_NUM", homeworkQuestion.getOPTION_NUM()); qpd.put("SCORE", homeworkQuestion.getSCORE()); qpd.put("RIGHT_ANSWER", homeworkQuestion.getRIGHT_ANSWER()); qpd.put("TYPE", homeworkQuestion.getTYPE()); qpd.put("HOMEWORKPROBLEM_ID", this.get32UUID()); qpd.put("HOMEWORK_ID", hpd.get("CODE")); homeworkproblemService.save(qpd); } responseGson.setData(hpd.getString("CODE")); } }else{ responseGson.setDataError(); } } else { responseGson.setDataError(); } } else { responseGson.setDataError(); } return responseGson.toJson(); } }