孙向锦 / SunvoteEducation

  package com.fh.controller.sunvote.paper;
  
  import java.io.PrintWriter;
  import java.text.DateFormat;

  import java.text.DecimalFormat;

  import java.text.SimpleDateFormat;
  import java.util.ArrayList;

  import java.util.Arrays;
  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.apache.shiro.session.Session;

  import org.springframework.beans.propertyeditors.CustomDateEditor;
  import org.springframework.stereotype.Controller;
  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.alibaba.druid.support.json.JSONUtils;

  import com.fh.bean.Paper;
  import com.fh.bean.Question;

  import com.fh.controller.api.ResponseGson;

  import com.fh.controller.base.BaseController;

  import com.fh.controller.sunvote.Myelfun;

  import com.fh.entity.Page;

  import com.fh.entity.system.User;

  import com.fh.service.api.V1Manager;

  import com.fh.service.sunvote.pagetemplate.PageTemplateManager;

  import com.fh.service.sunvote.paper.PaperManager;
  import com.fh.service.sunvote.paperquestion.PaperQuestionManager;

  import com.fh.service.sunvote.question.QuestionManager;

  import com.fh.service.sunvote.schoolgradesubject.SchoolGradeSubjectManager;

  import com.fh.service.sunvote.sclass.SClassManager;
  import com.fh.service.sunvote.sclass.impl.SClassService;
  import com.fh.service.sunvote.student.StudentManager;
  import com.fh.service.sunvote.studenttest.StudentTestManager;
  import com.fh.service.sunvote.testpaper.TestPaperManager;
  import com.fh.service.sunvote.testpaperinfo.TestPaperInfoManager;

  import com.fh.util.AppUtil;

  import com.fh.util.Const;

  import com.fh.util.Jurisdiction;

  import com.fh.util.ObjectExcelView;

  import com.fh.util.ObjectExcelView2;

  import com.fh.util.PageData;

  import com.hp.hpl.sparta.ParseException;

  /**
   * 说明：试卷 创建时间：2018-05-17

   */
  @Controller

  @RequestMapping(value = "/paper")

  public class PaperController extends BaseController {

  
  	String menuUrl = "paper/list.do"; // 菜单地址(权限用)
  	@Resource(name = "paperService")

  	private PaperManager paperService;

  
  	@Resource(name = "testpaperService")

  	private TestPaperManager testpaperService;

  
  	@Resource(name = "testpaperinfoService")

  	private TestPaperInfoManager testpaperinfoService;

  
  	@Resource(name = "studentService")

  	private StudentManager stundentService;

  
  	@Resource(name = "paperquestionService")

  	private PaperQuestionManager paperquestionService;

  
  	@Resource(name = "questionService")

  	private QuestionManager questionService;

  	@Resource(name = "v1Service")

  	private V1Manager v1Service;
  
  	@Resource(name = "schoolgradesubjectService")

  	private SchoolGradeSubjectManager schoolgradesubjectService;

  
  	@Resource(name = "pagetemplateService")

  	private PageTemplateManager pagetemplateService;

  
  	@Resource(name = "studenttestService")

  	private StudentTestManager studenttestService;

  
  	@Resource(name = "sclassService")

  	private SClassManager sclassService;

  
  	/**
  	 * 保存
  	 * 

  	 * @param
  	 * @throws Exception
  	 */

  	@RequestMapping(value = "/save")
  	public ModelAndView save() throws Exception {
  		logBefore(logger, Jurisdiction.getUsername() + "新增Paper");
  		if (!Jurisdiction.buttonJurisdiction(menuUrl, "add")) {
  			return null;
  		} // 校验权限

  		ModelAndView mv = this.getModelAndView();
  		PageData pd = new PageData();
  		pd = this.getPageData();

  		pd.put("PAPER_ID", this.get32UUID()); // 主键

  		paperService.save(pd);

  		mv.addObject("msg", "success");

  		mv.setViewName("save_result");
  		return mv;
  	}

  
  	/**
  	 * 保存
  	 * 

  	 * @param
  	 * @throws Exception
  	 */

  	@RequestMapping(value = "/newpaper")
  	public ModelAndView newPaper() throws Exception {
  		logBefore(logger, Jurisdiction.getUsername() + "新增Paper");

  		ModelAndView mv = this.getModelAndView();

  
  		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() + "删除Paper");

  		PageData pd = new PageData();
  		pd = this.getPageData();

  		String[] ArrayDATA_IDS = new String[] { pd.getString("PAPER_ID") };
  		if (pd.getString("QINGSONGKAO") != null) {

  			List<PageData> list = paperquestionService.listAll(pd);
  			String[] qids = new String[list.size()];

  			int i = 0;
  			for (PageData ptd : list) {

  				qids[i++] = ptd.getString("QUESTION_ID");
  			}

  			if (qids.length > 0) {

  				questionService.deleteAll(qids);
  			}
  		}

  		paperquestionService.deleteAllPaper(ArrayDATA_IDS);

  		paperService.delete(pd);
  		out.write("success");
  		out.close();
  	}

  
  	/**
  	 * 修改
  	 * 

  	 * @param
  	 * @throws Exception
  	 */

  	@RequestMapping(value = "/edit")
  	public ModelAndView edit() throws Exception {
  		logBefore(logger, Jurisdiction.getUsername() + "修改Paper");
  		if (!Jurisdiction.buttonJurisdiction(menuUrl, "edit")) {
  			return null;
  		} // 校验权限

  		ModelAndView mv = this.getModelAndView();
  		PageData pd = new PageData();
  		pd = this.getPageData();
  		paperService.edit(pd);

  		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() + "列表Paper");
  		// if(!Jurisdiction.buttonJurisdiction(menuUrl, "cha")){return null;}
  		// //校验权限(无权查看时页面会有提示,如果不注释掉这句代码就无法进入列表页面,所以根据情况是否加入本句代码)

  		ModelAndView mv = this.getModelAndView();
  		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<PageData> varList = paperService.list(page); // 列出Paper列表

  		mv.setViewName("sunvote/paper/paper_list");
  		mv.addObject("varList", varList);
  		mv.addObject("pd", pd);

  		mv.addObject("QX", Jurisdiction.getHC()); // 按钮权限

  		return mv;
  	}

  
  	@RequestMapping(value = "/paperRep")
  	public ModelAndView paperRep() throws Exception {

  		ModelAndView mv = this.getModelAndView();
  		PageData pd = new PageData();
  		List<PageData> templist = new ArrayList<PageData>();
  		PageData saveData = new PageData();

  		DecimalFormat decimalFormat = new DecimalFormat("0.00");

  		String total_score = "";

  		ResponseGson<PageData> res = new ResponseGson();
  		pd = this.getPageData();

  		if (pd.containsKey("PAPER_ID")) {

  			List<PageData> list = testpaperService.listAll(pd);

  			total_score = list.get(0).getString("TOTAL_SCORE");

  			pd.put("testpaperlist", list);

  			Integer you_sum = 0; // 优秀总人数
  			Integer liang_sum = 0; // 良好总人数
  			Integer jige_sum = 0; // 及格总人数
  			Integer difen_sum = 0; // 低分总人数
  			Integer num_sum = 0; // 年级总人数
  			Float avg_sum = (float) 0; // 平均分的和

  			String testpaperList = "";

  
  			for (int i = 0; i < list.size(); i++) {

  				PageData data = new PageData();

  				PageData pdtemp = new PageData();

  				if (!list.get(i).getString("SCLASS_ID").isEmpty()) {
  					pdtemp.put("CLASS_ID", list.get(i).get("SCLASS_ID")
  							.toString());
  				} else {
  					pdtemp.put("CLASS_ID", "");
  
  				}
  
  				List<PageData> studentlist = stundentService
  						.listAllClass(pdtemp);
  				testpaperList += list.get(i).get("TESTPAPER_ID").toString()
  						+ ",";

  				data.put("testpaper_id", list.get(i).get("TESTPAPER_ID"));
  				data.put("student_num", studentlist.size());
  				data.put("creat_time", list.get(i).get("CREATE_DATE"));
  				data.put("avg_score", list.get(i).get("AVG_SCORE"));
  				data.put("class_id", list.get(i).get("SCLASS_ID"));
  				pdtemp.put("TEST_ID", list.get(i).get("TESTPAPER_ID"));
  				List<PageData> l = studenttestService.listAll(pdtemp);

  				Integer you = 0;
  				Integer liang = 0;
  				Integer jige = 0;
  				Integer difen = 0;

  				Float total = list.get(i).get("TOTAL_SCORE")
  						.toString().isEmpty()?0:Float.valueOf(list.get(i).get("TOTAL_SCORE")

  						.toString());
  
  				for (int j = 0; j < l.size(); j++) {
  					Float score = Float.valueOf(l.get(j).get("SCORE")
  							.toString());
  					if (total != 0) {
  						if (score / total >= 0.8) {

  							you++;

  						} else if (score / total >= 0.7) {

  							liang++;

  						} else if (score / total >= 0.6) {

  							jige++;

  						} else if (score / total < 0.3) {

  							difen++;
  						}
  					}

  				}

  				you_sum += you;

  				liang_sum += liang;

  				jige_sum += jige;
  				difen_sum += difen;
  				num_sum += studentlist.size();

  				avg_sum += list.get(i).get("AVG_SCORE")
  						.toString().isEmpty()?0:Float.valueOf(list.get(i).get("AVG_SCORE")

  						.toString());
  
  				data.put("you", you);
  				data.put("liang", liang);
  				data.put("jige", jige);
  				data.put("difen", difen);
  

  				templist.add(data);
  			}

  			if (list.size() > 0) {
  				PageData dataTemp = new PageData();
  				dataTemp.put("testpaper_id", "");
  				dataTemp.put("student_num", num_sum);
  				dataTemp.put("creat_time", "");
  				dataTemp.put("avg_score",
  						decimalFormat.format(avg_sum / list.size()));
  				dataTemp.put("class_id", "");
  				dataTemp.put("you", you_sum);
  				dataTemp.put("liang", liang_sum);
  				dataTemp.put("jige", jige_sum);
  				dataTemp.put("difen", difen_sum);
  				dataTemp.put("testpaperList", testpaperList);
  				templist.add(dataTemp);

  			}

  		}

  		saveData.put("list", templist);

  		pd.put("TOTAL_SCORE", total_score);

  		mv.setViewName("sunvote/paper/test_list1");
  		mv.addObject("varList", templist);

  		mv.addObject("pd", pd);

  		res.setData(saveData);
  		return mv;
  	}

  
  	@RequestMapping(value = "/export1")
  	public ModelAndView export1() throws Exception {

  		ModelAndView mv = this.getModelAndView();
  		PageData pd = new PageData();
  		List<PageData> templist = new ArrayList<PageData>();
  		PageData saveData = new PageData();

  		ResponseGson<PageData> res = new ResponseGson();
  		pd = this.getPageData();

  		if (pd.containsKey("PAPER_ID")) {

  			List<PageData> list = testpaperService.listAll(pd);

  			pd.put("testpaperlist", list);

  			for (int i = 0; i < list.size(); i++) {

  				PageData data = new PageData();

  				PageData pdtemp = new PageData();
  				pdtemp.put("CLASS_ID", list.get(i).get("SCLASS_ID").toString());

  				List<PageData> studentlist = stundentService
  						.listAllClass(pdtemp);

  				data.put("testpaper_id", list.get(i).get("TESTPAPER_ID"));
  				data.put("student_num", studentlist.size());
  				data.put("creat_time", list.get(i).get("CREATE_DATE"));
  				data.put("avg_score", list.get(i).get("AVG_SCORE"));
  				data.put("class_id", list.get(i).get("SCLASS_ID"));
  				pdtemp.put("TEST_ID", list.get(i).get("TESTPAPER_ID"));
  				List<PageData> l = studenttestService.listAll(pdtemp);

  				Integer you = 0;
  				Integer liang = 0;
  				Integer jige = 0;
  				Integer difen = 0;

  				Float total = Float.valueOf(list.get(i).get("TOTAL_SCORE")
  						.toString());
  
  				for (int j = 0; j < l.size(); j++) {
  					Float score = Float.valueOf(l.get(j).get("SCORE")
  							.toString());
  					if (total != 0) {
  						if (score / total >= 0.8) {

  							you++;

  						} else if (score / total >= 0.7) {

  							liang++;

  						} else if (score / total >= 0.6) {

  							jige++;

  						} else if (score / total < 0.3) {

  							difen++;
  						}
  					}

  				}

  
  				data.put("you", you);
  				data.put("liang", liang);
  				data.put("jige", jige);
  				data.put("difen", difen);
  

  				templist.add(data);
  			}
  		}
  

  		Map<String, Object> dataMap = new HashMap<String, Object>();

  		List<String> titles = new ArrayList<String>();

  		titles.add("序号"); // 1
  		titles.add("班级名称"); // 2
  		titles.add("考试时间"); // 3
  		titles.add("平均分"); // 4
  		titles.add("班级总人数"); // 5
  		titles.add("优秀人数"); // 6
  		titles.add("优秀率"); // 7
  		titles.add("良好人数"); // 8
  		titles.add("良好率"); // 9
  		titles.add("及格人数"); // 10
  		titles.add("及格率"); // 11
  		titles.add("低分人数"); // 12
  		titles.add("低分率"); // 13

  		dataMap.put("titles", titles);
  		List<PageData> varOList = templist;
  		List<PageData> varList = new ArrayList<PageData>();

  		DecimalFormat decimalFormat = new DecimalFormat("0.00");
  		for (int i = 0; i < varOList.size(); i++) {

  			PageData vpd = new PageData();
  			vpd.put("ID", varOList.get(i).getString("class_id"));
  			PageData c = sclassService.findById(vpd);
  			vpd.remove("ID");

  			Integer you = Integer.valueOf(varOList.get(i).getString("you"));
  			Integer liang = Integer.valueOf(varOList.get(i).getString("liang"));
  			Integer jige = Integer.valueOf(varOList.get(i).getString("jige"));
  			Integer difen = Integer.valueOf(varOList.get(i).getString("difen"));

  			Integer student_num = Integer.valueOf(varOList.get(i).getString(
  					"student_num"));
  
  			vpd.put("var1", i + 1); // 1
  			vpd.put("var2", c.getString("CLASS_NAME")); // 2
  			vpd.put("var3", varOList.get(i).getString("creat_time")); // 3
  			vpd.put("var4", varOList.get(i).getString("avg_score")); // 4
  			vpd.put("var5", student_num); // 5
  			vpd.put("var6", you); // 6
  			vpd.put("var7",
  					student_num == 0 ? 0 : decimalFormat.format(you * 100.0
  							/ student_num)
  							+ "%"); // 7
  			vpd.put("var8", liang); // 8
  			vpd.put("var9",
  					student_num == 0 ? 0 : decimalFormat.format(liang * 100.0
  							/ student_num)
  							+ "%"); // 9
  			vpd.put("var10", jige); // 10
  			vpd.put("var11",
  					student_num == 0 ? 0 : decimalFormat.format(jige * 100.0
  							/ student_num)
  							+ "%"); // 11
  			vpd.put("var12", difen); // 12
  			vpd.put("var13",
  					student_num == 0 ? 0 : decimalFormat.format(difen * 100.0
  							/ student_num)
  							+ "%"); // 13

  			varList.add(vpd);
  		}
  		dataMap.put("varList", varList);
  		ObjectExcelView erv = new ObjectExcelView();

  		mv = new ModelAndView(erv, dataMap);

  		return mv;
  	}

  
  	@RequestMapping(value = "/paperRep2")
  	public ModelAndView paperRep2() throws Exception {

  		ModelAndView mv = this.getModelAndView();
  		PageData pd = new PageData();
  		List<PageData> templist = new ArrayList<PageData>();
  		PageData saveData = new PageData();

  		ResponseGson<PageData> res = new ResponseGson();
  		pd = this.getPageData();

  		if (pd.containsKey("PAPER_ID")) {

  			List<PageData> list = paperquestionService.listAll(pd);
  			List<PageData> test = new ArrayList<PageData>();
  			int onum[] = new int[list.size()];

  
  			for (int i = 0; i < list.size(); i++) {

  				PageData temp = new PageData();
  				String questionid = list.get(i).get("QUESTION_ID").toString();

  
  				if (list.get(i).get("NO_NAME") == null
  						|| list.get(i).get("NO_NAME").toString().isEmpty()) {

  					continue;
  				}

  				Float que_score = list.get(i).getString("SCORE").isEmpty()?0:Float.valueOf(list.get(i).get("SCORE")

  						.toString());

  				temp.put("QUESTION_ID", questionid);
  				PageData question = questionService.findById(temp);

  				temp.put("ANSWER", question.get("ANSWER").toString());

  				temp.put("QUESTION_RANK", list.get(i).get("RANK").toString());
  				temp.put("QUESTION_SCORE", que_score);

  				PageData que = questionService.findById(temp);
  				Integer option_num = 0;

  				if (!que.get("OPTION_NUM").toString().isEmpty()) {
  					option_num = Integer.valueOf(que.get("OPTION_NUM")
  							.toString());
  					onum[i] = option_num;

  				}

  				String tpList = pd.get("TESTPAPER_ID").toString();
  				String tpListArray[] = tpList.split(",");

  				temp.put("TEST_ID", tpListArray);

  
  				List<PageData> queInfo = testpaperinfoService
  						.listTestPaperQuestionIDinfo(temp);
  				int answer[] = new int[option_num + 1];

  				int right = 0;

  				int lost = 0;

  				for (int j = 0; j < queInfo.size(); j++) {
  					if (queInfo.get(j).get("ANSWER").toString().isEmpty()) {

  						lost++;
  					}

  					if (queInfo.get(j).get("RIGHT") != null
  							&& !queInfo.get(j).get("RIGHT").toString()
  									.isEmpty()) {
  						if (queInfo.get(j).get("RIGHT").toString().equals("1")) {

  							right++;
  						}
  					}

  					if (queInfo.get(j).get("ANSWER") != null
  							&& !queInfo.get(j).get("ANSWER").toString()
  									.isEmpty()) {
  						for (int o = 0; o < option_num; o++) {
  							String s = String.valueOf((char) (65 + o));
  							if (queInfo.get(j).get("ANSWER").toString()
  									.indexOf(s) > -1) {

  								answer[o]++;
  							}

  						}
  					} else {

  						answer[option_num]++;
  					}
  				}
  				temp.put("RIGHTNUM", right);

  				temp.put("ANSWERNUM", (queInfo.size() - lost));
  				temp.put("ANSWERNUM2", queInfo.size());

  				temp.put("optin_info", answer);
  				templist.add(temp);
  			}
  			Arrays.sort(onum);

  			int max = onum[onum.length - 1];
  			pd.put("MAX", max);
  		}
  
  		Collections.sort(templist, new Comparator<PageData>() {

  
  			@Override
  			public int compare(PageData o1, PageData o2) {

  				Integer o1GetScore = Integer.valueOf(o1
  						.getString("QUESTION_RANK"));
  				Integer o2GetScore = Integer.valueOf(o2
  						.getString("QUESTION_RANK"));

  				return o1GetScore.compareTo(o2GetScore);
  			}

  		});
  		mv.setViewName("sunvote/paper/test_list2");
  		mv.addObject("varList", templist);

  		mv.addObject("pd", pd);

  		res.setData(saveData);
  		return mv;
  	}

  
  	@RequestMapping(value = "/export2")
  	public ModelAndView export2() throws Exception {

  		ModelAndView mv = this.getModelAndView();
  		PageData pd = new PageData();
  		List<PageData> templist = new ArrayList<PageData>();
  		PageData saveData = new PageData();

  		ResponseGson<PageData> res = new ResponseGson();
  		pd = this.getPageData();

  		if (pd.containsKey("PAPER_ID")) {

  			List<PageData> list = paperquestionService.listAll(pd);
  			List<PageData> test = new ArrayList<PageData>();
  			int onum[] = new int[list.size()];

  
  			for (int i = 0; i < list.size(); i++) {

  				PageData temp = new PageData();
  				String questionid = list.get(i).get("QUESTION_ID").toString();

  
  				if (list.get(i).get("NO_NAME") == null
  						|| list.get(i).get("NO_NAME").toString().isEmpty()) {

  					continue;
  				}

  				Float que_score = Float.valueOf(list.get(i).get("SCORE")
  						.toString());

  				temp.put("QUESTION_ID", questionid);
  				PageData question = questionService.findById(temp);

  				temp.put("ANSWER", question.get("ANSWER").toString());

  				temp.put("QUESTION_RANK", list.get(i).get("RANK").toString());
  				temp.put("QUESTION_SCORE", que_score);

  				PageData que = questionService.findById(temp);
  				Integer option_num = 0;

  				if (!que.get("OPTION_NUM").toString().isEmpty()) {
  					option_num = Integer.valueOf(que.get("OPTION_NUM")
  							.toString());
  					onum[i] = option_num;

  				}

  				String tpList = pd.get("TESTPAPER_ID").toString();
  				String tpListArray[] = tpList.split(",");

  				temp.put("TEST_ID", tpListArray);

  				List<PageData> queInfo = testpaperinfoService
  						.listTestPaperQuestionIDinfo(temp);
  				int answer[] = new int[option_num + 1];

  				int right = 0;

  				int lost = 0;

  				for (int j = 0; j < queInfo.size(); j++) {
  					if (queInfo.get(j).get("ANSWER").toString().isEmpty()) {

  						lost++;
  					}

  					if (queInfo.get(j).get("RIGHT") != null
  							&& !queInfo.get(j).get("RIGHT").toString()
  									.isEmpty()) {
  						if (queInfo.get(j).get("RIGHT").toString().equals("1")) {

  							right++;
  						}
  					}

  					if (queInfo.get(j).get("ANSWER") != null
  							&& !queInfo.get(j).get("ANSWER").toString()
  									.isEmpty()) {
  						for (int o = 0; o < option_num; o++) {
  							String s = String.valueOf((char) (65 + o));
  							if (queInfo.get(j).get("ANSWER").toString()
  									.equals(s)) {

  								answer[o]++;
  							}

  						}
  					} else {

  						answer[option_num]++;
  					}
  				}
  				temp.put("RIGHTNUM", right);

  				temp.put("ANSWERNUM", (queInfo.size() - lost));
  				temp.put("ANSWERNUM2", queInfo.size());

  				temp.put("optin_info", JSONUtils.toJSONString(answer));
  				templist.add(temp);
  			}
  			Arrays.sort(onum);