孙向锦 / 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;

  
  /** 
   * 说明：试卷
   * 创建时间：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();
  				pdtemp.put("CLASS_ID", list.get(i).get("SCLASS_ID").toString());
  				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 = 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+=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 = 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);
  			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.addObject("varList", templist);
  //		mv.addObject("pd",pd);
  		
  		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
  		Integer max = Integer.valueOf(pd.getString("MAX"));
  		for(int x = 0 ;x<max;x++){
  			titles.add("选"+Myelfun.jstlInt2Char(x+1)+"人数");	//8
  			titles.add("选"+Myelfun.jstlInt2Char(x+1)+"比例");	//9
  		}
  		titles.add("漏选人数");	//10
  		titles.add("漏选比例");	//11
  		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("var1", varOList.get(i).getString("QUESTION_RANK"));	    //1
  			vpd.put("var2", varOList.get(i).getString("ANSWER"));	    //2
  			vpd.put("var3", varOList.get(i).getString("ANSWERNUM"));	    //3
  			vpd.put("var4", varOList.get(i).getString("RIGHTNUM"));	    //4

  			vpd.put("var5", decimalFormat.format(Double.valueOf(varOList.get(i).getString("RIGHTNUM"))*100/Double.valueOf(varOList.get(i).getString("ANSWERNUM")))+"%");	    //5

  			vpd.put("var6", varOList.get(i).getString("QUESTION_SCORE"));	    //6

  			vpd.put("var7", decimalFormat.format(Double.valueOf(varOList.get(i).getString("RIGHTNUM"))*Double.valueOf(varOList.get(i).getString("QUESTION_SCORE"))/Double.valueOf(varOList.get(i).getString("ANSWERNUM"))));	    //7

  			String s = varOList.get(i).get("optin_info").toString();
  			s = s.replace("[", "");
  			s = s.replace("]", "");
  			List<String> optoin = Arrays.asList(s.split(",")); 
  			for(int y = 0 ;y<max;y++){

  				Integer nn = 0;
  				if((optoin.size()-1)>y){
  					nn = Integer.valueOf(optoin.get(y));
  				}else{
  					break;
  				}

  				vpd.put("var"+(8+2*y), nn);	    //8

  				vpd.put("var"+(9+2*y), decimalFormat.format(nn*100/Double.valueOf(varOList.get(i).getString("ANSWERNUM")))+"%");	    //9

  				
  			}
  			

  			vpd.put("var"+(max*2+8), Integer.valueOf(optoin.get(optoin.size()-1)));	    //8

  			vpd.put("var"+(max*2+9), decimalFormat.format(Double.valueOf(optoin.get(optoin.size()-1))*100/Double.valueOf(varOList.get(i).getString("ANSWERNUM2")))+"%");	    //9

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

  	/**
  	 * 按学生分析
  	 * @return
  	 * @throws Exception
  	 */
  	@RequestMapping(value="/paperRep3")
  	public ModelAndView paperRep3() throws Exception{
  		ModelAndView mv = this.getModelAndView();
  		PageData pd = new PageData();

  		List<PageData> temp = new ArrayList<PageData>();

  		PageData saveData = new PageData();
  		
  		ResponseGson<PageData> res = new ResponseGson();
  		pd = this.getPageData();
  		if(pd.containsKey("PAPER_ID")){

  			List<PageData> list = studenttestService.findTestInfoByPid(pd);

  			PageData paper = paperService.findById(pd);
  			if(paper!=null){
  				pd.put("SCORE", paper.get("SCORE"));
  				pd.put("PAPER_NAME", paper.get("TITLE"));
  			}

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

  			Integer test_num = 0;
  			Integer lost_num = 0;

  			for(PageData item : list){
  				
  				Integer index = this.indexOfStrInList(sid, item.getString("STUDENT_ID"));
  				if(index!=-1){
  					

  						test_num++;
  						List<PageData> test_list = (List<PageData>) temp.get(index).get("TEST_LIST");
  						PageData test = new PageData();
  						test.put("CREATE_DATE", item.get("CREATE_DATE"));
  						if(item.getString("LOST_TEST").isEmpty()){
  							test.put("SCORE", item.get("SCORE"));
  						}else{
  							test.put("SCORE", "--");
  							temp.get(index).put("LOST_NUM", Integer.valueOf(temp.get(index).getString("LOST_NUM"))+1);
  						}
  						test.put("AVG_SCORE", item.get("AVG_SCORE"));
  						test_list.add(test);
  						Float total = Float.valueOf(temp.get(index).getString("STUDENT_TOTAL"));
  						temp.get(index).put("STUDENT_TOTAL",total+Float.valueOf(item.getString("SCORE")));
  						temp.get(index).put("TEST_LIST", test_list);
  						temp.get(index).put("TEST_NUM", test_list.size()-Integer.valueOf(temp.get(index).getString("LOST_NUM")));
  						

  				}else{

  					test_num=1;
  					lost_num=0;

  					PageData stu = new PageData();
  					stu.put("STUDENT_NAME", item.get("STUDENT_NAME"));
  					stu.put("CLASS_NAME", item.get("CLASS_NAME"));

  					List<PageData> testList = new ArrayList<PageData>();
  					PageData test = new PageData();
  					test.put("CREATE_DATE", item.get("CREATE_DATE"));
  					if(item.getString("LOST_TEST").isEmpty()){
  						test.put("SCORE", item.get("SCORE"));
  					}else{
  						test.put("SCORE", "--");
  						lost_num++;
  					}
  					test.put("AVG_SCORE", item.get("AVG_SCORE"));
  					testList.add(test);
  					stu.put("STUDENT_TOTAL",item.get("SCORE"));
  					stu.put("TEST_LIST", testList);
  					stu.put("TEST_NUM", testList.size()-lost_num);
  					stu.put("LOST_NUM", lost_num);
  					sid.add(item.getString("STUDENT_ID"));

  					temp.add(stu);
  				}
  				

  			}
  		}

  		Collections.sort(temp,new Comparator<PageData>(){
  
  			@Override
  			public int compare(PageData o1, PageData o2) {
  				Float o1GetScore = Float.valueOf(o1.getString("STUDENT_TOTAL"))/Float.valueOf(o1.getString("TEST_NUM"));
  				Float o2GetScore = Float.valueOf(o2.getString("STUDENT_TOTAL"))/Float.valueOf(o2.getString("TEST_NUM"));
  				return o2GetScore.compareTo(o1GetScore);
  			}
  			
  		});

  		mv.setViewName("sunvote/paper/test_list3");

  		mv.addObject("varList", temp);

  		mv.addObject("pd",pd);
  		res.setData(saveData);
  		return mv;
  	}
  	
  	

  	@RequestMapping(value="/export3")
  	public ModelAndView export3() throws Exception{
  		ModelAndView mv = this.getModelAndView();
  		PageData pd = new PageData();
  		List<PageData> temp = new ArrayList<PageData>();
  		PageData saveData = new PageData();
  		
  		ResponseGson<PageData> res = new ResponseGson();
  		pd = this.getPageData();
  		if(pd.containsKey("PAPER_ID")){
  			
  			List<PageData> list = studenttestService.findTestInfoByPid(pd);
  			PageData paper = paperService.findById(pd);
  			if(paper!=null){
  				pd.put("SCORE", paper.get("SCORE"));
  				pd.put("PAPER_NAME", paper.get("TITLE"));
  			}
  			List<String> sid = new ArrayList<String>();
  			Integer test_num = 0;
  			Integer lost_num = 0;
  			for(PageData item : list){
  				
  				Integer index = this.indexOfStrInList(sid, item.getString("STUDENT_ID"));
  				if(index!=-1){
  					
  						test_num++;
  						List<PageData> test_list = (List<PageData>) temp.get(index).get("TEST_LIST");
  						PageData test = new PageData();
  						test.put("CREATE_DATE", item.get("CREATE_DATE"));
  						if(item.getString("LOST_TEST").isEmpty()){
  							test.put("SCORE", item.get("SCORE"));
  						}else{
  							test.put("SCORE", "--");
  							temp.get(index).put("LOST_NUM", Integer.valueOf(temp.get(index).getString("LOST_NUM"))+1);
  						}
  						test.put("AVG_SCORE", item.get("AVG_SCORE"));
  						test_list.add(test);
  						Float total = Float.valueOf(temp.get(index).getString("STUDENT_TOTAL"));
  						temp.get(index).put("STUDENT_TOTAL",total+Float.valueOf(item.getString("SCORE")));
  						temp.get(index).put("TEST_LIST", test_list);
  						temp.get(index).put("TEST_NUM", test_list.size()-Integer.valueOf(temp.get(index).getString("LOST_NUM")));
  						
  				}else{
  					test_num=1;
  					lost_num=0;
  					PageData stu = new PageData();
  					stu.put("STUDENT_NAME", item.get("STUDENT_NAME"));
  					stu.put("CLASS_NAME", item.get("CLASS_NAME"));
  					List<PageData> testList = new ArrayList<PageData>();
  					PageData test = new PageData();
  					test.put("CREATE_DATE", item.get("CREATE_DATE"));
  					if(item.getString("LOST_TEST").isEmpty()){
  						test.put("SCORE", item.get("SCORE"));
  					}else{
  						test.put("SCORE", "--");
  						lost_num++;
  					}
  					test.put("AVG_SCORE", item.get("AVG_SCORE"));
  					testList.add(test);
  					stu.put("STUDENT_TOTAL",item.get("SCORE"));
  					stu.put("TEST_LIST", testList);
  					stu.put("TEST_NUM", testList.size()-lost_num);
  					stu.put("LOST_NUM", lost_num);
  					sid.add(item.getString("STUDENT_ID"));
  					temp.add(stu);
  				}
  				
  			}
  		}
  		Collections.sort(temp,new Comparator<PageData>(){
  
  			@Override
  			public int compare(PageData o1, PageData o2) {
  				Float o1GetScore = Float.valueOf(o1.getString("STUDENT_TOTAL"))/Float.valueOf(o1.getString("TEST_NUM"));
  				Float o2GetScore = Float.valueOf(o2.getString("STUDENT_TOTAL"))/Float.valueOf(o2.getString("TEST_NUM"));
  				return o2GetScore.compareTo(o1GetScore);
  			}
  			
  		});
  
  		mv.addObject("varList", temp);
  		mv.addObject("pd",pd);
  		
  		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
  		
  		dataMap.put("titles", titles);
  		List<PageData> varOList = temp;
  		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("var1", varOList.get(i).getString("STUDENT_NAME"));	    //1
  			vpd.put("var2", varOList.get(i).getString("CLASS_NAME"));	    //2
  			vpd.put("var3", i+1);	    //3
  			vpd.put("var4", varOList.get(i).getString("TEST_NUM").equals("0")?0:decimalFormat.format(Double.valueOf(varOList.get(i).getString("STUDENT_TOTAL"))/Double.valueOf(varOList.get(i).getString("TEST_NUM"))));	    //4
  			vpd.put("var5", varOList.get(i).getString("TEST_NUM").equals("0")?0:decimalFormat.format((Double.valueOf(varOList.get(i).getString("STUDENT_TOTAL"))*100/Double.valueOf(varOList.get(i).getString("TEST_NUM")))/Double.valueOf(pd.getString("SCORE"))));	    //5
  			List<PageData> test_list = (List<PageData>)varOList.get(i).get("TEST_LIST");
  			
  			List<String> score = new ArrayList<String>();
  			List<String> AVG_SCORE = new ArrayList<String>();
  			List<String> CREATE_DATE = new ArrayList<String>();
  			for(int x=0;x<test_list.size();x++){
  				score.add(test_list.get(x).getString("SCORE"));
  				AVG_SCORE.add(test_list.get(x).getString("AVG_SCORE"));
  				CREATE_DATE.add(test_list.get(x).getString("CREATE_DATE"));
  				
  			}
  			vpd.put("var6", score);
  			vpd.put("var7", AVG_SCORE);
  			vpd.put("var8", CREATE_DATE);
  			varList.add(vpd);
  		}
  		dataMap.put("varList", varList);
  		ObjectExcelView2 erv = new ObjectExcelView2();
  		mv = new ModelAndView(erv,dataMap);
  		
  
  		return mv;
  	}