package com.fh.controller.api;

import java.io.File;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Collections;
import java.util.Comparator;
import java.util.Date;
import java.util.Iterator;
import java.util.List;
import java.util.Map;

import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;

import org.apache.commons.lang.StringUtils;
import org.apache.shiro.crypto.hash.SimpleHash;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.multipart.MultipartFile;

import com.fh.bean.Paper;
import com.fh.bean.Point;
import com.fh.bean.Question;
import com.fh.bean.ResultHomework;
import com.fh.bean.ResultHomework.ResultStudent;
import com.fh.bean.StudentAnswer;
import com.fh.bean.TestPaper;
import com.fh.bean.TestPaperInfo;
import com.fh.controller.base.BaseController;
import com.fh.controller.sunvote.Myelfun;
import com.fh.service.api.V1Manager;
import com.fh.service.feedback.feedback.FeedbackManager;
import com.fh.service.feedback.problemphenomenon.ProblemPhenomenonManager;
import com.fh.service.software.softwareversion.SoftwareVersionManager;
import com.fh.service.sunvote.attachkeyboard.AttachKeyboardManager;
import com.fh.service.sunvote.basestation.BasestationManager;
import com.fh.service.sunvote.cache.CacheManager;
import com.fh.service.sunvote.chapter.ChapterManager;
import com.fh.service.sunvote.classbasetation.ClassBasetationManager;
import com.fh.service.sunvote.classroster.ClassRosterManager;
import com.fh.service.sunvote.classtype.ClassTypeManager;
import com.fh.service.sunvote.coursemanagement.CourseManagementManager;
import com.fh.service.sunvote.event.EventManager;
import com.fh.service.sunvote.grade.GradeManager;
import com.fh.service.sunvote.headmaster.HeadmasterManager;
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.keypad.KeypadManager;
import com.fh.service.sunvote.keypadcheck.KeypadCheckManager;
import com.fh.service.sunvote.knowledge.KnowledgeManager;
import com.fh.service.sunvote.knowledgechapter.KnowledgeChapterManager;
import com.fh.service.sunvote.networkstatistics.NetworkStatisticsManager;
import com.fh.service.sunvote.paper.PaperManager;
import com.fh.service.sunvote.paperclassteacher.PaperClassTeacherManager;
import com.fh.service.sunvote.paperquestion.PaperQuestionManager;
import com.fh.service.sunvote.papertype.PaperTypeManager;
import com.fh.service.sunvote.question.QuestionManager;
import com.fh.service.sunvote.questiontype.QuestionTypeManager;
import com.fh.service.sunvote.school.SchoolManager;
import com.fh.service.sunvote.schoolgradesubject.SchoolGradeSubjectManager;
import com.fh.service.sunvote.sclass.SClassManager;
import com.fh.service.sunvote.student.StudentManager;
import com.fh.service.sunvote.studenttest.StudentTestManager;
import com.fh.service.sunvote.subject.SubjectManager;
import com.fh.service.sunvote.teacher.TeacherManager;
import com.fh.service.sunvote.teachingmaterial.TeachingMaterialManager;
import com.fh.service.sunvote.testpaper.TestPaperManager;
import com.fh.service.sunvote.testpaperinfo.TestPaperInfoManager;
import com.fh.service.sunvote.textbook.TextbookManager;
import com.fh.service.system.user.UserManager;
import com.fh.util.DbFH;
import com.fh.util.PageData;
import com.fh.util.Tools;

@Controller
@RequestMapping(value = "/api/v1")
public class V1 extends BaseController {

	@Resource(name = "schoolService")
	private SchoolManager schoolService;

	@Resource(name = "basestationService")
	private BasestationManager basestationService;

	@Resource(name = "chapterService")
	private ChapterManager chapterService;

	@Resource(name = "classbasetationService")
	private ClassBasetationManager classbasetationService;

	@Resource(name = "classrosterService")
	private ClassRosterManager classrosterService;

	@Resource(name = "classtypeService")
	private ClassTypeManager classtypeService;

	@Resource(name = "gradeService")
	private GradeManager gradeService;

	@Resource(name = "coursemanagementService")
	private CourseManagementManager coursemanagementService;

	@Resource(name = "keypadService")
	private KeypadManager keypadService;

	@Resource(name = "keypadcheckService")
	private KeypadCheckManager keypadcheckService;

	@Resource(name = "knowledgeService")
	private KnowledgeManager knowledgeService;

	@Resource(name = "knowledgechapterService")
	private KnowledgeChapterManager knowledgechapterService;

	@Resource(name = "paperService")
	private PaperManager paperService;

	@Resource(name = "paperclassteacherService")
	private PaperClassTeacherManager paperclassteacherService;

	@Resource(name = "paperquestionService")
	private PaperQuestionManager paperquestionService;

	@Resource(name = "papertypeService")
	private PaperTypeManager papertypeService;

	@Resource(name = "questionService")
	private QuestionManager questionService;

	@Resource(name = "questiontypeService")
	private QuestionTypeManager questiontypeService;

	@Resource(name = "schoolgradesubjectService")
	private SchoolGradeSubjectManager schoolgradesubjectService;

	@Resource(name = "sclassService")
	private SClassManager sclassService;
	
	@Resource(name="homeworkService")
	private HomeworkManager homeworkService;
	
	@Resource(name = "studentService")
	private StudentManager studentService;

	@Resource(name = "subjectService")
	private SubjectManager subjectService;

	@Resource(name = "teacherService")
	private TeacherManager teacherService;
	
	@Resource(name="headmasterService")
	private HeadmasterManager headmasterService;

	@Resource(name = "testpaperinfoService")
	private TestPaperInfoManager testpaperinfoService;

	@Resource(name = "testpaperService")
	private TestPaperManager testpaperService;

	@Resource(name = "studenttestService")
	private StudentTestManager studenttestService;

	@Resource(name = "feedbackService")
	private FeedbackManager feedbackService;

	@Resource(name = "problemphenomenonService")
	private ProblemPhenomenonManager problemphenomenonService;

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

	@Resource(name = "softwareversionService")
	private SoftwareVersionManager softwareversionService;

	@Resource(name = "attachkeyboardService")
	private AttachKeyboardManager attachkeyboardService;

	@Resource(name = "networkstatisticsService")
	private NetworkStatisticsManager networkstatisticsService;

	@Resource(name = "eventService")
	private EventManager eventService;

	@Resource(name = "userService")
	private UserManager userService;

	@Resource(name = "teachingmaterialService")
	private TeachingMaterialManager teachingmaterialService;

	@Resource(name = "textbookService")
	private TextbookManager textbookService;

	@Resource(name = "cacheService")
	private CacheManager cacheService;
	
	@Resource(name="homeworkproblemService")
	private HomeworkProblemManager homeworkproblemService;
	
	@Resource(name="homeworkReporService")
	private HomeworkReportManager homeworkReporkService;
	
	/**
	 * 登录 可以通过账号密码登录、 可以通过教师卡登录
	 * 
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value = "/login", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public Object login() throws Exception {
		event("apilogin");
		PageData pd = this.getPageData();
		ResponseGson<PageData> res = new ResponseGson();
		if (!pd.containsKey("ACCOUT")) {
			pd.put("ACCOUT", pd.get("USERNAME"));
		}
		if (((pd.containsKey("USERNAME") || (pd.containsKey("ACCOUT") && pd
				.get("ACCOUT") != null)) && pd.containsKey("PASSWORD"))
				|| pd.containsKey("KEYPAD_ID")) {
			PageData eventPd = new PageData();
			eventPd.put("EVENT_ID", get32UUID());
			eventPd.put("EVENT_NAME", "login");
			eventPd.put("EVENT_USER", pd.getString("USERNAME"));
			eventPd.put("EVENT_TYPE", "0");
			eventPd.put("EVENT_START_TIME", Tools.date2Str(new Date()));
			if (pd.getString("CLIENT_ID") != null) {
				eventPd.put("CLIENT_ID", pd.getString("CLIENT_ID"));
			} else {
				eventPd.put("CLIENT_ID", "CLIENT");
			}
			eventPd.put("EVENT_IP", getRemoteIp());
			eventService.save(eventPd);
			
			PageData pageData = teacherService.getUserInfo(pd);
			PageData headerMaster = headmasterService.findByUsenameAndPassword(pd);
			if (pageData != null && pageData.getString("ID") != null) {
				pageData.put("PASSWORD", "");// 返回参数中不返回密码
				PageData pt = new PageData();
				pt.put("TEACHER_ID", pageData.get("ID"));
				// 在任课表中查找老师教哪些班级，然后查出班级信息
				List<PageData> classInfoList = v1Service
						.getTeacherClassInfo(pt);

				pageData.put("classInfoList", classInfoList);
				// 在认可表中查找老师教哪些科目，然后查出科目信息
				List<PageData> subjectList = v1Service
						.getTeacherSubjectInfo(pt);
				// 一个sql语句完成。
				pageData.put("subjectList", subjectList);

				pageData.remove("SUBJECT_IDS");

				
				pageData.put("role", "teacher");
				res.setData(pageData);
				// 填充数据到返回数据中
			} else if(headerMaster != null && headerMaster.get("HEADMASTER_ID") != null){
				headerMaster.put("PASSWORD", "");
				headerMaster.put("role", "headermaster");
				List<PageData> classInfoList = sclassService.listAll(headerMaster);
				headerMaster.put("classInfoList", classInfoList);
				res.setData(headerMaster);
				
			}else{
				res.set1Error();
			}
		} else {
			res.set1Error();
		}

		return res.toJson();
	}

	/**
	 * 登录 可以通过账号密码登录、 可以通过教师卡登录
	 * 
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value = "/userinfo", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public Object userinfo() throws Exception {
		event("userinfo");
		PageData pd = this.getPageData();
		ResponseGson<PageData> res = new ResponseGson();
		PageData pageData = teacherService.findById(pd);
		if (pageData != null && pageData.getString("ID") != null) {
			pageData.put("PASSWORD", "");// 返回参数中不返回密码
			PageData pt = new PageData();
			pt.put("TEACHER_ID", pageData.get("ID"));
			// 在任课表中查找老师教哪些班级，然后查出班级信息
			List<PageData> classInfoList = v1Service.getTeacherClassInfo(pt);

			pageData.put("classInfoList", classInfoList);
			// 在认可表中查找老师教哪些科目，然后查出科目信息
			List<PageData> subjectList = v1Service.getTeacherSubjectInfo(pt);
			// 一个sql语句完成。
			pageData.put("subjectList", subjectList);

			pageData.remove("SUBJECT_IDS");

			PageData eventPd = new PageData();
			eventPd.put("EVENT_ID", get32UUID());
			eventPd.put("EVENT_NAME", "login");
			eventPd.put("EVENT_USER", pageData.getString("ID"));
			eventPd.put("EVENT_TYPE", "0");
			eventPd.put("EVENT_START_TIME", Tools.date2Str(new Date()));
			if (pd.getString("CLIENT_ID") != null) {
				eventPd.put("CLIENT_ID", pd.getString("CLIENT_ID"));
			} else {
				eventPd.put("CLIENT_ID", "CLIENT");
			}
			eventPd.put("EVENT_IP", getRemoteIp());
			eventService.save(eventPd);

			res.setData(pageData);
			// 填充数据到返回数据中
		} else {
			res.set1Error();
		}

		return res.toJson();
	}

	/**
	 * 查询班级 班级及班级学生详细信息
	 * 
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value = "/class", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public Object sclass() throws Exception {
		event("sclass");
		long cur = System.currentTimeMillis();
		PageData pd = this.getPageData();
		if (pd.containsKey("ID")) {
			ResponseGson<PageData> res = new ResponseGson();
			PageData pageData = sclassService.findById(pd);
			if (pageData != null && pageData.containsKey("ID")) {
				PageData pt = new PageData();
				pt.put("SCLASS_ID", pageData.get("ID"));
				List<PageData> studentList = v1Service.getClassStudent(pt);
				pageData.put("studentList", studentList);
				pt.put("CLASS_ID", pageData.get("ID"));
				List<PageData> keyboards = attachkeyboardService
						.listAllClassId(pt);
				pageData.put("keyboards", keyboards);
				res.setData(pageData);
			} else {
				res.set2Error();
			}
			logger.info("class cost time : "
					+ (System.currentTimeMillis() - cur));
			return res.toJson();
		} else {
			ResponseGson<List<PageData>> res = new ResponseGson();
			List<PageData> list = sclassService.listAll(pd);
			res.setData(list);
			logger.info("class cost time : "
					+ (System.currentTimeMillis() - cur));
			return res.toJson();
		}
	}

	/**
	 * 问题类型
	 * 
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value = "/questiontype", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public Object questiontype() throws Exception {
		event("questiontype");
		long cur = System.currentTimeMillis();
		PageData pd = this.getPageData();
		ResponseGson<List<PageData>> res = new ResponseGson();
		List<PageData> list = questiontypeService.listAll(pd);
		res.setData(list);
		logger.info("questiontype cost time : "
				+ (System.currentTimeMillis() - cur));
		return res.toJson();
	}

	/**
	 * 班级类型
	 * 
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value = "/classtype", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public Object classtype() throws Exception {
		event("classtype");
		long cur = System.currentTimeMillis();
		PageData pd = this.getPageData();
		ResponseGson<List<PageData>> res = new ResponseGson();
		List<PageData> list = classtypeService.listAll(pd);
		res.setData(list);
		logger.info("classtype cost time : "
				+ (System.currentTimeMillis() - cur));
		return res.toJson();
	}

	/**
	 * 年级 年级类型
	 * 
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value = "/grade", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public Object grade() throws Exception {
		event("grade");
		long cur = System.currentTimeMillis();
		PageData pd = this.getPageData();
		ResponseGson<List<PageData>> res = new ResponseGson();
		if (!pd.containsKey("SCHOOL_ID")) {
			List<PageData> list = gradeService.listAll(pd);
			res.setData(list);
		} else {
			List<PageData> list = schoolgradesubjectService.listAllGrade(pd);
			res.setData(list);
		}
		logger.info("class cost time : " + (System.currentTimeMillis() - cur));
		return res.toJson();
	}

	/**
	 * 科目
	 * 
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value = "/subject", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public Object subject() throws Exception {
		event("subject");
		long cur = System.currentTimeMillis();
		PageData pd = this.getPageData();
		ResponseGson<List<PageData>> res = new ResponseGson();
		if (!pd.containsKey("SCHOOL_ID")) {
			List<PageData> list = subjectService.listAll(pd);
			res.setData(list);
		} else {
			List<PageData> list = schoolgradesubjectService.listAllSubject(pd);
			res.setData(list);
		}
		logger.info("subject cost time : " + (System.currentTimeMillis() - cur));
		return res.toJson();
	}

	/**
	 * 科目
	 * 
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value = "/subjectname", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public Object subjectName() throws Exception {
		event("subjectName");
		long cur = System.currentTimeMillis();
		PageData pd = this.getPageData();
		ResponseGson<List<PageData>> res = new ResponseGson();
		if (!pd.containsKey("SCHOOL_ID")) {
			List<PageData> list = subjectService.listAll(pd);
			res.setData(list);
		} else {
			List<PageData> list = schoolgradesubjectService.listAllSubject(pd);
			res.setData(list);
		}
		logger.info("subject cost time : " + (System.currentTimeMillis() - cur));
		return res.toJson();
	}

	/**
	 * 键盘扫描
	 * 
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value = "/keypadscan", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public Object keypadScan() throws Exception {
		event("keypadScan");
		long cur = System.currentTimeMillis();
		PageData pd = this.getPageData();
		ResponseGson<String> res = new ResponseGson();
		String ID = get32UUID();
		pd.put("KEYPADCHECK_ID", ID); // 主键
		pd.put("CREATE_DATE", Tools.date2Str(new Date())); // 创建时间
		try {
			keypadcheckService.save(pd);
			res.setData(ID);
			res.setSuccess();
		} catch (Exception ex) {
			res.setDataError();
		}
		logger.info("keypadScan cost time : "
				+ (System.currentTimeMillis() - cur));
		return res.toJson();
	}

	/**
	 * showcount 数量 currentpage 当前页码
	 * 
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value = "/paper", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public Object paper() throws Exception {
		event("paper");
		long cur = System.currentTimeMillis();
		PageData pd = this.getPageData();
		ResponseGson<List<PageData>> res = new ResponseGson<List<PageData>>();
		if (pd.containsKey("PAPER_TYPE")) {
			String CURRENTPAGE = pd.getString("CURRENTPAGE");
			String SHOWCOUNT = pd.getString("SHOWCOUNT");
			if (CURRENTPAGE != null && SHOWCOUNT != null
					&& !"".equals(CURRENTPAGE.trim())
					&& !"".equals(SHOWCOUNT.trim())) {
				int currentPage = Integer.parseInt(CURRENTPAGE);
				int showcount = Integer.parseInt(SHOWCOUNT);
				currentPage = (currentPage > 0 ? currentPage - 1 : 0)
						* showcount;
				pd.put("CURRENTPAGE", "" + currentPage);
			}
			List<PageData> pageList = paperService.listAllByType(pd);
			res.setData(pageList);
		} else {
			res.setDataError();
		}
		logger.info("paper cost time : " + (System.currentTimeMillis() - cur));
		return res.toJson();
	}

	/**
	 * 试卷详细信息
	 * 
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value = "/paperinfo", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public Object paperInfo() throws Exception {
		event("paperInfo");
		long cur = System.currentTimeMillis();
		PageData pd = this.getPageData();
		ResponseGson<Paper> res = new ResponseGson<Paper>();
		if (pd.containsKey("PAPER_ID")) {
			try {
				try {
					Paper paper = new Paper();
					PageData ppd = paperService.findById(pd);
					if (ppd != null) {
						paper.setTitle(ppd.getString("TITLE"));
						paper.setExam_time(ppd.getString("EXAM_TIME"));
						paper.setUser_id(ppd.getString("USER_ID"));
						paper.setPaper_type(ppd.getString("PAPER_TYPE"));
						paper.setSubject_id(ppd.getString("SUBJECT_ID"));
						paper.setGrade_id(ppd.getString("GRADE_ID"));
						paper.setScore(ppd.getString("SCORE"));
						paper.setSchool_id(ppd.getString("SCHOOL_ID"));
						paper.setQuestions(new ArrayList<Question>());

						List<PageData> questList = v1Service
								.getTestPaperInfo(pd);
						for (PageData qpd : questList) {
							Question question = new Question();
							question.setAnswer(qpd.getString("ANSWER"));
							question.setQuestion_id(qpd
									.getString("QUESTION_ID"));
							question.setSubject_id(qpd.getString("SUBJECT_ID"));
							question.setChapter_id(qpd.getString("CHAPTER_ID"));
							question.setProblem_type_id(qpd
									.getString("PROBLEM_TYPE_ID"));
							question.setKnowledge_id(qpd
									.getString("KNOWLEDGE_ID"));
							question.setContent(qpd.getString("CONTENT"));
							question.setOption_num(qpd.getString("OPTION_NUM"));
							question.setOption_content(qpd
									.getString("OPTION_CONTENT"));
							question.setDifficulty(qpd.getString("DIFFICULTY"));
							question.setAnalysis(qpd.getString("ANALYSIS"));
							question.setQuestion_from(qpd
									.getString("QUESTION_FROM"));
							question.setScore(qpd.getString("SCORE"));
							question.setPart_score(qpd.getString("PART_SCORE"));
							question.setQuestionType(qpd
									.getString("PROBLEM_TYPE_ID"));
							question.setRank(qpd.getString("RANK"));
							question.setNo_name(qpd.getString("NO_NAME"));
							question.setQuestions(new ArrayList<Question>());
							if ("-1".equals("" + qpd.getString("P_ID"))) {
								PageData pidPd = new PageData();
								pidPd.put("PID", question.getQuestion_id());
								List<PageData> qs = v1Service
										.getQuestionsByPID(pidPd);
								for (PageData q : qs) {
									Question qq = new Question();
									qq.setAnswer(q.getString("ANSWER"));
									qq.setQuestion_id(q
											.getString("QUESTION_ID"));
									qq.setSubject_id(q.getString("SUBJECT_ID"));
									qq.setChapter_id(q.getString("CHAPTER_ID"));
									qq.setProblem_type_id(q
											.getString("PROBLEM_TYPE_ID"));
									qq.setKnowledge_id(q
											.getString("KNOWLEDGE_ID"));
									qq.setContent(q.getString("CONTENT"));
									qq.setOption_num(q.getString("OPTION_NUM"));
									qq.setOption_content(q
											.getString("OPTION_CONTENT"));
									qq.setDifficulty(q.getString("DIFFICULTY"));
									qq.setAnalysis(q.getString("ANALYSIS"));
									qq.setQuestion_from(q
											.getString("QUESTION_FROM"));
									qq.setScore(q.getString("SCORE"));
									qq.setPart_score(q.getString("PART_SCORE"));
									qq.setQuestionType(qpd
											.getString("PROBLEM_TYPE_ID"));
									qq.setRank(q.getString("RANK"));
									qq.setNo_name(q.getString("NO_NAME"));
									question.getQuestions().add(qq);
								}
							}
							if ("-1".equals(qpd.getString("P_ID"))
									|| "0".equals(qpd.getString("P_ID"))) {
								paper.getQuestions().add(question);
							}
						}
						// pd.put("JSON", paper.toJson());
						res.setData(paper);
						logger.info(paper.toJson());

					}
				} catch (Exception ex) {
					ex.printStackTrace();
				}
			} catch (Exception ex) {
				ex.printStackTrace();
				res.setError();
			}
		} else {
			res.setOtherError();
		}
		logger.info("paperInfo cost time : "
				+ (System.currentTimeMillis() - cur));
		return res.toJson();
	}

	/*	*//**
	 * 试卷详细信息
	 * 
	 * @return
	 * @throws Exception
	 */
	/*
	 * @RequestMapping(value = "/paperinfo", produces =
	 * "application/json;charset=UTF-8")
	 * 
	 * @ResponseBody public Object paperInfo() throws Exception {
	 * event("paperInfo"); long cur = System.currentTimeMillis(); PageData pd =
	 * this.getPageData(); ResponseGson<PageData> res = new
	 * ResponseGson<PageData>(); if (pd.containsKey("PAPER_ID")) { try { try {
	 * PageData ppd = paperService.findById(pd); if (ppd != null) {
	 * List<PageData> questList = v1Service .getTestPaperInfo(pd);
	 * ppd.put("QUESTIONS", questList); for (PageData qpd : questList) {
	 * 
	 * String optionContent = qpd .getString("OPTION_CONTENT"); if
	 * (optionContent != null && optionContent.startsWith("[") &&
	 * optionContent.endsWith("]")) { String[] options =
	 * optionContent.substring(1, optionContent.length() - 1).split(",");
	 * qpd.put("OPTION_CONTENT", options); } else { qpd.put("OPTION_CONTENT",
	 * new String[] { optionContent }); } if ("-1".equals("" +
	 * qpd.getString("P_ID"))) { PageData pidPd = new PageData();
	 * pidPd.put("PID", qpd.getString("QUESTION_ID")); List<PageData> qs =
	 * v1Service .getQuestionsByPID(pidPd); for (PageData pcd : qs) { String
	 * optionContent1 = pcd .getString("OPTION_CONTENT"); if (optionContent1 !=
	 * null && optionContent1.startsWith("[") && optionContent1.endsWith("]")) {
	 * String[] options = optionContent1 .substring( 1, optionContent1.length()
	 * - 1) .split(","); pcd.put("OPTION_CONTENT", options); } else {
	 * pcd.put("OPTION_CONTENT", new String[] { optionContent1 }); } String[]
	 * keys = new String[pcd.keySet().size()]; pcd.keySet().toArray(keys);
	 * Iterator map1it = pcd.entrySet().iterator(); for (String key : keys) {
	 * pcd.put(key.toLowerCase(),pcd.get(key)); pcd.remove(key.toUpperCase()); }
	 * } qpd.put("QUESTIONS", qs); }
	 * 
	 * String[] keys = new String[qpd.keySet().size()];
	 * qpd.keySet().toArray(keys); for (String key : keys) {
	 * qpd.put(key.toLowerCase(), qpd.get(key)); qpd.remove(key.toUpperCase());
	 * }
	 * 
	 * } String[] keys = new String[ppd.keySet().size()];
	 * ppd.keySet().toArray(keys); for (String key : keys) {
	 * ppd.put(key.toLowerCase(), ppd.get(key)); ppd.remove(key.toUpperCase());
	 * } // pd.put("JSON", paper.toJson()); res.setData(ppd);
	 * logger.info(res.toJson());
	 * 
	 * } } catch (Exception ex) { ex.printStackTrace(); } } catch (Exception ex)
	 * { ex.printStackTrace(); res.setError(); } } else { res.setOtherError(); }
	 * logger.info("paperInfo cost time : " + (System.currentTimeMillis() -
	 * cur)); return res.toJson(); }
	 *//**
	 * 试卷详细信息
	 * 
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value = "/paperinfo2", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public Object paperInfo2() throws Exception {
		event("paperInfo2");
		long cur = System.currentTimeMillis();
		PageData pd = this.getPageData();
		ResponseGson<PageData> res = new ResponseGson<PageData>();
		if (pd.containsKey("PAPER_ID")) {
			try {
				try {
					PageData ppd = paperService.findById(pd);
					if (ppd != null) {
						List<PageData> questList = v1Service
								.getTestPaperInfo(pd);
						ppd.put("QUESTIONS", questList);
						for (PageData qpd : questList) {

							String optionContent = qpd
									.getString("OPTION_CONTENT");
							if (optionContent != null
									&& optionContent.startsWith("[")
									&& optionContent.endsWith("]")) {
								String[] options = optionContent.substring(1,
										optionContent.length() - 1).split(",");
								qpd.put("OPTION_CONTENT", options);
							} else {
								qpd.put("OPTION_CONTENT",
										new String[] { optionContent });
							}
							if ("-1".equals("" + qpd.getString("P_ID"))) {
								PageData pidPd = new PageData();
								pidPd.put("PID", qpd.getString("QUESTION_ID"));
								List<PageData> qs = v1Service
										.getQuestionsByPID(pidPd);
								for (PageData pcd : qs) {
									String optionContent1 = pcd
											.getString("OPTION_CONTENT");
									if (optionContent1 != null
											&& optionContent1.startsWith("[")
											&& optionContent1.endsWith("]")) {
										String[] options = optionContent1
												.substring(
														1,
														optionContent1.length() - 1)
												.split(",");
										pcd.put("OPTION_CONTENT", options);
									} else {
										pcd.put("OPTION_CONTENT",
												new String[] { optionContent1 });
									}
								}
								qpd.put("QUESTIONS", qs);
							}

						}
						res.setData(ppd);
						logger.info(res.toJson());

					}
				} catch (Exception ex) {
					ex.printStackTrace();
				}
			} catch (Exception ex) {
				ex.printStackTrace();
				res.setError();
			}
		} else {
			res.setOtherError();
		}
		logger.info("paperInfo cost time : "
				+ (System.currentTimeMillis() - cur));
		return res.toJson();
	}
	

	/**
	 * 试卷详细信息
	 * 
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value = "/testpaperinfo", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public Object testpaperinfo() throws Exception {
		event("testpaperinfo");
		long cur = System.currentTimeMillis();
		PageData pd = this.getPageData();
		ResponseGson<PageData> res = new ResponseGson();
		String paperId = pd.getString("ID");
		if (!StringUtils.isEmpty(paperId)) {
			try {
				pd.put("TESTPAPER_ID", paperId);
				PageData testPd = testpaperService.findById(pd);
				if (testPd != null) {
					PageData testInfof = new PageData();
					testInfof.put("PAPER_ID", testPd.getString("PAPER_ID"));
					testInfof.put("TEST_ID", paperId);
					List<PageData> list = testpaperinfoService
							.listTestPaperQuestionIDs(testInfof);
					for (PageData pqd : list) {
						PageData tpqd = questionService.findById(pqd);
						pqd.putAll(tpqd);
						pqd.remove("P_ID");
						pqd.remove("SUBJECT_ID");
						pqd.remove("PROBLEM_TYPE_ID");
						pqd.remove("CHAPTER_ID");
						pqd.remove("TEACHER_ID");
						pqd.remove("SCHOOL_ID");
						pqd.remove("SUG_SCORE");
						pqd.remove("SUG_PART_SCORE");
						pqd.remove("USER_ID");
						pqd.remove("CREATE_DATE");
						pqd.remove("QUESTION_FROM");
						pqd.remove("REMARK");
						pqd.put("TEST_ID", paperId);
						List<PageData> listinfo = testpaperinfoService
								.listTestPaperQuestionIDinfo(pqd);
						List<PageData> answerInfos = new ArrayList<PageData>();
						List<String> answerList = new ArrayList<String>();
						for (PageData pid : listinfo) {
							String answer = pid.getString("ANSWER");
							PageData answerPd = null;
							if (answerInfos.size() > 0) {
								answerPd = answerInfos
										.get(answerInfos.size() - 1);
								if (!answer
										.equals(answerPd.getString("ANSWER"))) {
									answerPd = new PageData();
									answerPd.put("ANSWER", answer);
									answerPd.put("ISRIGHT",
											pid.getString("RIGHT"));
									answerInfos.add(answerPd);
									answerList.add(answer);
								}
							} else {
								answerPd = new PageData();
								answerPd.put("ANSWER", answer);
								answerPd.put("ISRIGHT", pid.getString("RIGHT"));
								answerInfos.add(answerPd);
								answerList.add(answer);
							}
							String strCount = answerPd.getString("COUNT");
							int count = 0;
							if (strCount != null) {
								try {
									count = Integer.parseInt(strCount);
								} catch (NumberFormatException ex) {
								}
							}
							count++;
							answerPd.put("COUNT", count);
						}
						String questionNumStr = pqd.getString("OPTION_NUM");
						int questionNum = Integer.parseInt(questionNumStr);
						for (int i = 0; i < questionNum; i++) {
							if ((!answerList.contains("" + (char) ('A' + i)))
									&& !(answerList.contains(""
											+ (char) ('a' + i)))) {
								PageData answerPd = new PageData();
								answerPd.put("ANSWER", "" + (char) ('A' + i));
								answerPd.put("ISRIGHT", pqd.get("ANSWER")
										.equals(('A' + i)) ? "1" : "0");
								answerPd.put("COUNT", 0);
								answerInfos.add(answerPd);
							}
						}
						Collections.sort(answerInfos,
								new Comparator<PageData>() {

									@Override
									public int compare(PageData p1, PageData p2) {
										return p1.getString("ANSWER")
												.compareToIgnoreCase(
														p2.getString("ANSWER"));
									}

								});
						pqd.put("ANSWERINFO", answerInfos);
						pqd.remove("TEST_ID");
					}
					for (PageData pad : list) {
						String optionContent = pad.getString("OPTION_CONTENT");
						if (optionContent != null
								&& optionContent.startsWith("[")
								&& optionContent.endsWith("]")) {
							String[] options = optionContent.substring(1,
									optionContent.length() - 1).split(",");
							pad.put("OPTION_CONTENT", options);
						} else {
							pad.put("OPTION_CONTENT",
									new String[] { optionContent });
						}
					}
					testPd.put("QUESTIONS", list);

				}

				res.setData(testPd);
			} catch (Exception e) {
				e.printStackTrace();
				res.setError();
			}
		}
		logger.info("testpaperinfo cost time:"
				+ (System.currentTimeMillis() - cur));
		return res.toJson();
	}

	/**
	 * 试卷详细信息
	 * 
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value = "/questionintestreportinfo", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public Object questionInTestReportInfo() throws Exception {
		event("questionInTestReportInfo");
		long cur = System.currentTimeMillis();
		PageData pd = this.getPageData();
		ResponseGson<PageData> res = new ResponseGson();
		if (pd.getString("QUESTION_ID") != null) {
			String questionId = pd.getString("QUESTION_ID");
			PageData pqd = new PageData();
			pqd.put("QUESTION_ID", questionId);
			PageData tpqd = questionService.findById(pqd);
			if (tpqd != null) {
				pqd.putAll(tpqd);
				pqd.remove("P_ID");
				pqd.remove("SUBJECT_ID");
				pqd.remove("PROBLEM_TYPE_ID");
				pqd.remove("CHAPTER_ID");
				pqd.remove("TEACHER_ID");
				pqd.remove("SCHOOL_ID");
				pqd.remove("SUG_SCORE");
				pqd.remove("SUG_PART_SCORE");
				pqd.remove("USER_ID");
				pqd.remove("CREATE_DATE");
				pqd.remove("QUESTION_FROM");
				pqd.remove("REMARK");
				String optionContent = pqd.getString("OPTION_CONTENT");
				if (optionContent != null && optionContent.startsWith("[")
						&& optionContent.endsWith("]")) {
					String[] options = optionContent.substring(1,
							optionContent.length() - 1).split(",");
					pqd.put("OPTION_CONTENT", options);
				} else {
					pqd.put("OPTION_CONTENT", new String[] { optionContent });
				}
				if (pd.getString("TEST_ID") != null) {
					pqd.put("TEST_ID", pd.getString("TEST_ID"));
				}
				List<PageData> listinfo = testpaperinfoService
						.listTestPaperQuestionIDinfo(pqd);
				List<PageData> answerInfos = new ArrayList<PageData>();
				for (PageData pid : listinfo) {
					String answer = pid.getString("ANSWER");
					PageData answerPd = null;
					if (answerInfos.size() > 0) {
						answerPd = answerInfos.get(answerInfos.size() - 1);
						if (!answer.equals(answerPd.getString("ANSWER"))) {
							answerPd = new PageData();
							answerPd.put("ANSWER", answer);
							answerPd.put("ISRIGHT", pid.getString("RIGHT"));
							answerInfos.add(answerPd);
						}
					} else {
						answerPd = new PageData();
						answerPd.put("ANSWER", answer);
						answerPd.put("ISRIGHT", pid.getString("RIGHT"));
						answerInfos.add(answerPd);
					}
					String strCount = answerPd.getString("COUNT");
					int count = 0;
					if (strCount != null) {
						try {
							count = Integer.parseInt(strCount);
						} catch (NumberFormatException ex) {
						}
					}
					count++;
					answerPd.put("COUNT", count);
				}
				pqd.put("ANSWERINFO", answerInfos);
				res.setData(pqd);
			} else {
				res.setDataError();
			}
		} else {
			res.setDataError();
		}
		logger.info("questionInTestReportInfo cost time:"
				+ (System.currentTimeMillis() - cur));
		return res.toJson();
	}

	/**
	 * 试卷简要信息
	 * 
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value = "/paperbriefinfo", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public Object paperBriefInfo() throws Exception {
		event("paperBriefInfo");
		long cur = System.currentTimeMillis();
		PageData pd = this.getPageData();
		ResponseGson<Paper> res = new ResponseGson<Paper>();
		if (pd.containsKey("PAPER_ID")) {
			try {
				try {
					Paper paper = new Paper();
					PageData ppd = paperService.findById(pd);
					if (ppd != null) {
						paper.setTitle(ppd.getString("TITLE"));
						paper.setExam_time(ppd.getString("EXAM_TIME"));
						paper.setUser_id(ppd.getString("USER_ID"));
						paper.setPaper_type(ppd.getString("PAPER_TYPE"));
						paper.setSubject_id(ppd.getString("SUBJECT_ID"));
						paper.setGrade_id(ppd.getString("GRADE_ID"));
						paper.setScore(ppd.getString("SCORE"));
						paper.setQuestions(new ArrayList<Question>());

						List<PageData> questList = v1Service
								.getTestPaperInfo(pd);
						for (PageData qpd : questList) {
							Question question = new Question();
							question.setQuestion_id(qpd
									.getString("QUESTION_ID"));
							if ("-1".equals("" + qpd.getString("P_ID"))) {
								PageData pidPd = new PageData();
								pidPd.put("PID", question.getQuestion_id());
								question.setQuestions(new ArrayList<Question>());
								List<PageData> qs = v1Service
										.getQuestionsByPID(pidPd);
								for (PageData q : qs) {
									Question qq = new Question();
									qq.setQuestion_id(q
											.getString("QUESTION_ID"));
									question.getQuestions().add(qq);
								}
							}
							if ("-1".equals(qpd.getString("P_ID"))
									|| "0".equals(qpd.getString("P_ID"))) {
								paper.getQuestions().add(question);
							}
						}
						// pd.put("JSON", paper.toJson());
						res.setData(paper);
						logger.info(paper.toJson());

					}
				} catch (Exception ex) {
					ex.printStackTrace();
				}
			} catch (Exception ex) {
				ex.printStackTrace();
				res.setError();
			}
		} else {
			res.setOtherError();
		}
		logger.info("paperBriefInfo cost time : "
				+ (System.currentTimeMillis() - cur));
		return res.toBrifJson();
	}

	/**
	 * 试卷问题
	 * 
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value = "/paperquestion", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public Object paperQuestion() throws Exception {
		event("paperQuestion");
		long cur = System.currentTimeMillis();
		PageData pd = this.getPageData();
		ResponseGson<PageData> res = new ResponseGson();
		logger.info("paperquestion cost time : "
				+ (System.currentTimeMillis() - cur));
		return res.toJson();
	}

	/**
	 * 问题
	 * 
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value = "/question", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public Object question() throws Exception {
		event("question");
		long cur = System.currentTimeMillis();
		PageData pd = this.getPageData();
		ResponseGson<List<PageData>> res = new ResponseGson();
		List<PageData> list = new ArrayList<PageData>();
		if (pd.containsKey("ID")) {
			String ids = pd.getString("ID");
			String[] id = ids.split(",");
			for (String i : id) {
				pd.put("QUESTION_ID", i);
				PageData data = questionService.findById(pd);
				String optionContent = data.getString("OPTION_CONTENT");
				if (optionContent != null && optionContent.startsWith("[")
						&& optionContent.endsWith("]")) {
					String[] options = optionContent.substring(1,
							optionContent.length() - 1).split(",");
					data.put("OPTION_CONTENT", options);
				} else {
					data.put("OPTION_CONTENT", new String[] { optionContent });
				}
				if (data != null) {
					list.add(data);
				}
			}
			res.setData(list);
		} else {
			res.setDataError();
		}
		logger.info("question cost time : "
				+ (System.currentTimeMillis() - cur));
		return res.toJson();
	}

	/**
	 * 查询知识点名称
	 * 
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value = "/knowledgename", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public Object knowledgename() throws Exception {
		event("knowledgename");
		ResponseGson<List<PageData>> res = new ResponseGson();
		List<PageData> list = new ArrayList<PageData>();
		PageData pd = getPageData();
		if (pd.get("ID") != null) {
			String ids = pd.getString("ID");
			String[] id = ids.split(",");
			for (String i : id) {
				pd.put("KNOWLEDGE_ID", i);
				PageData data = knowledgeService.findById(pd);
				if (data != null) {
					PageData t = new PageData();
					t.put("KNOWLEDGE_ID", data.get("KNOWLEDGE_ID"));
					t.put("NAME", data.get("NAME"));
					list.add(t);
				}
			}
			res.setData(list);
		}
		;
		return res;
	}

	/**
	 * 章节名称
	 * 
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value = "/chaptername", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public Object chaptername() throws Exception {
		event("chaptername");
		ResponseGson<List<PageData>> res = new ResponseGson();
		List<PageData> list = new ArrayList<PageData>();
		PageData pd = getPageData();
		if (pd.get("ID") != null) {
			String ids = pd.getString("ID");
			String[] id = ids.split(",");
			for (String i : id) {
				pd.put("ID", i);
				PageData data = chapterService.findById(pd);
				if (data != null) {
					PageData t = new PageData();
					t.put("ID", data.get("ID"));
					t.put("NAME", data.get("NAME"));
					list.add(t);
				}
			}
			res.setData(list);
		}
		;
		return res;
	}

	/**
	 * 试题添加
	 * 
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value = "/question/add", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public Object questionAdd() throws Exception {
		event("questionAdd");
		long cur = System.currentTimeMillis();
		PageData pd = this.getPageData();
		ResponseGson<PageData> res = new ResponseGson();
		pd.put("QUESTION_ID", this.get32UUID());
		questionService.save(pd);
		logger.info("questionAdd cost time : "
				+ (System.currentTimeMillis() - cur));
		return res.toJson();
	}

	/***
	 * 上传试卷
	 * 
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value = "/uploadpaper", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public Object uploadpaper() throws Exception {
		event("uploadpaper");
		long cur = System.currentTimeMillis();
		PageData pd = this.getPageData();
		ResponseGson<String> res = new ResponseGson();

		if (!StringUtils.isEmpty(pd.getJsonString())) {
			logger.info(pd.getJsonString());
			Paper paper = Paper.parse(pd.getJsonString());
			PageData paperPd = new PageData();
			String paperID = this.get32UUID();
			res.setData(paperID);
			paperPd.put("PAPER_ID", paperID);
			paperPd.put("TITLE", paper.getTitle());
			paperPd.put("USER_ID", paper.getUser_id());
			paperPd.put("PAPER_TYPE", paper.getPaper_type());
			paperPd.put("SUBJECT_ID", paper.getSubject_id());
			paperPd.put("GRADE_ID", paper.getGrade_id());
			paperPd.put("EXAM_TIME", paper.getExam_time());
			paperPd.put("SCORE", paper.getScore());
			paperPd.put("PAPER_STATE", "0");
			paperPd.put("REMARK", "");
			String schoolID = Myelfun.getUserID(paper.getUser_id());
			paperPd.put("SCHOOL_ID", paper.getSchool_id() == null ? schoolID:paper.getSchool_id());
			paperPd.put("CREATE_DATE", Tools.date2Str(new Date()));
			paperPd.put("MODIFY_DATE", Tools.date2Str(new Date()));

			int questionNum = 0;

			List<Question> questions = paper.getQuestions();
			if (questions != null) {
				for (Question question : questions) {
					String questionID = this.get32UUID();
					PageData qPd = new PageData();
					qPd.put("QUESTION_ID", questionID);
					if (question.getQuestions() != null
							&& question.getQuestions().size() > 0) {
						qPd.put("P_ID", "-1");
					} else {
						questionNum++;
						qPd.put("P_ID", "0");
					}
					qPd.put("SUBJECT_ID", paper.getSubject_id());
					qPd.put("CHAPTER_ID", question.getChapter_id());
					qPd.put("PROBLEM_TYPE_ID",
							question.getProblem_type_id() == null ? "1"
									: question.getProblem_type_id());
					qPd.put("TEACHER_ID", paper.getUser_id());
					qPd.put("SCHOOL_ID", schoolID);
					qPd.put("KNOWLEDGE_ID", question.getKnowledge_id());
					qPd.put("CONTENT", question.getContent());
					qPd.put("OPTION_NUM", question.getOption_num());
					qPd.put("OPTION_CONTENT", question.getOption_content());
					qPd.put("ANSWER", question.getAnswer());
					qPd.put("DIFFICULTY", question.getDifficulty());
					qPd.put("ANALYSIS", question.getAnalysis());
					qPd.put("QUESTION_FROM", question.getQuestion_from());
					qPd.put("SUG_SCORE", question.getScore());
					qPd.put("SUG_PART_SCORE", question.getPart_score());
					qPd.put("USER_ID", paper.getUser_id());
					qPd.put("CREATE_DATE", Tools.date2Str(new Date()));
					qPd.put("REMARK", "");
					questionService.save(qPd);

					PageData pqPd = new PageData();
					pqPd.put("PAPER_ID", paperID);
					pqPd.put("QUESTION_ID", questionID);
					pqPd.put("SCORE", question.getScore());
					pqPd.put("PART_SCORE", "0");
					pqPd.put("RANK", question.getRank());
					pqPd.put("NO_NAME", question.getNo_name());
					pqPd.put("PAPERQUESTION_ID", this.get32UUID());
					paperquestionService.save(pqPd);

					if (question.getQuestions() != null) {
						List<Question> qs = question.getQuestions();
						for (Question q : qs) {
							String qID = this.get32UUID();
							PageData cqPd = new PageData();
							cqPd.put("QUESTION_ID", qID);
							cqPd.put("P_ID", questionID);
							cqPd.put("SUBJECT_ID", paper.getSubject_id());
							cqPd.put("CHAPTER_ID", q.getChapter_id());
							cqPd.put("PROBLEM_TYPE_ID", question
									.getProblem_type_id() == null ? "1"
									: question.getProblem_type_id());
							cqPd.put("TEACHER_ID", paper.getUser_id());
							cqPd.put("SCHOOL_ID", schoolID);
							cqPd.put("KNOWLEDGE_ID", q.getKnowledge_id());
							cqPd.put("CONTENT", q.getContent());
							cqPd.put("OPTION_NUM", q.getOption_num());
							cqPd.put("OPTION_CONTENT", q.getOption_content());
							cqPd.put("ANSWER", q.getAnswer());
							cqPd.put("DIFFICULTY", q.getDifficulty());
							cqPd.put("ANALYSIS", q.getAnalysis());
							cqPd.put("QUESTION_FROM", q.getQuestion_from());
							cqPd.put("SUG_SCORE", q.getScore());
							cqPd.put("SUG_PART_SCORE", q.getSug_part_score());
							cqPd.put("USER_ID", paper.getUser_id());
							cqPd.put("CREATE_DATE", Tools.date2Str(new Date()));
							cqPd.put("REMARK", "");

							questionService.save(cqPd);

							PageData cpqPd = new PageData();
							cpqPd.put("PAPER_ID", paperID);
							cpqPd.put("QUESTION_ID", qID);
							cpqPd.put("SCORE", q.getScore());
							cpqPd.put("PART_SCORE", "0");
							cpqPd.put("RANK", q.getRank());
							cpqPd.put("NO_NAME", q.getNo_name());
							cpqPd.put("PAPERQUESTION_ID", this.get32UUID());

							paperquestionService.save(cpqPd);
							questionNum++;
						}
					}
				}
			}
			paperPd.put("QUESTION_NUM", "" + questionNum);
			paperService.save(paperPd);

		} else {
			res.setDataError();
		}
		logger.info("uploadpaper cost time : "
				+ (System.currentTimeMillis() - cur));
		return res.toJson();
	}

	/**
	 * 上传试卷，不上传试题详细信息。试题从已有数据库中组卷
	 * 
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value = "/publishpaper", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public Object publishPaper() throws Exception {
		event("publishpaper");
		long cur = System.currentTimeMillis();
		PageData pd = this.getPageData();
		ResponseGson<String> res = new ResponseGson();

		if (!StringUtils.isEmpty(pd.getJsonString())) {
			logger.info(pd.getJsonString());
			Paper paper = Paper.parse(pd.getJsonString());
			PageData paperPd = new PageData();
			String paperID = this.get32UUID();
			res.setData(paperID);
			paperPd.put("PAPER_ID", paperID);
			paperPd.put("TITLE", paper.getTitle());
			paperPd.put("USER_ID", paper.getUser_id());
			paperPd.put("PAPER_TYPE", paper.getPaper_type());
			paperPd.put("SUBJECT_ID", paper.getSubject_id());
			paperPd.put("GRADE_ID", paper.getGrade_id());
			paperPd.put("EXAM_TIME", paper.getExam_time());
			paperPd.put("CLASS_ID", paper.getClass_id());
			paperPd.put("SCORE", paper.getScore());
			paperPd.put("PAPER_STATE", "0");
			paperPd.put("REMARK", "");
			String schoolID = Myelfun.getUserID(paper.getUser_id());
			paperPd.put("SCHOOL_ID", schoolID);
			paperPd.put("CREATE_DATE", Tools.date2Str(new Date()));
			paperPd.put("MODIFY_DATE", Tools.date2Str(new Date()));
			List<Question> questions = paper.getQuestions();
			int questionNum = questions.size();
			if (questions != null) {
				for (Question question : questions) {
					PageData pqPd = new PageData();
					pqPd.put("PAPER_ID", paperID);
					pqPd.put("QUESTION_ID", question.getQuestion_id());
					pqPd.put("SCORE", question.getScore());
					pqPd.put("PART_SCORE", "0");
					pqPd.put("RANK", question.getRank());
					pqPd.put("NO_NAME", question.getNo_name());
					pqPd.put("PAPERQUESTION_ID", this.get32UUID());
					pqPd.put("P_ID", "0");
					pqPd.put("KNOWLEDGE_ID", question.getKnowledge_id());//
					paperquestionService.save(pqPd);

				}
			}
			paperPd.put("QUESTION_NUM", "" + questionNum);
			paperService.save(paperPd);

		} else {
			res.setDataError();
		}
		logger.info("publishpaper cost time : "
				+ (System.currentTimeMillis() - cur));
		return res.toJson();
	}

	/**
	 * 上传知识点
	 * 
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value = "/uploadpoint", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public Object uploadpoint() throws Exception {
		event("uploadpoint");
		long cur = System.currentTimeMillis();
		PageData pd = this.getPageData();
		ResponseGson<String> res = new ResponseGson();

		if (!StringUtils.isEmpty(pd.getJsonString())) {
			try {
				ResponseGson<List<Point>> req = ResponseGson.parse(
						pd.getJsonString(), Point.class);
				List<Point> list = req.getData();
				if (list != null && list.size() > 0) {
					for (Point point : list) {
						savePoint(point, null);
					}
				}
			} catch (Exception e) {
				res.setError();
			}
		} else {
			res.setDataError();
		}
		logger.info("uploadpoint cost time : "
				+ (System.currentTimeMillis() - cur));
		return res.toJson();
	}

	/**
	 * 上传测验成绩
	 * 
	 * @return
	 */
	@RequestMapping(value = "/uploadtestpaper", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public Object uploadTestpaper() {
		event("uploadTestpaper");
		long cur = System.currentTimeMillis();
		PageData pd = this.getPageData();
		ResponseGson<String> res = new ResponseGson();
		if (!StringUtils.isEmpty(pd.getJsonString())) {
			logger.info(pd.getJsonString());
			TestPaper testPaper = TestPaper.parse(pd.getJsonString());
			try {
				PageData testPd = new PageData();
				String testPaperId = this.get32UUID();
				testPd.put("TEACHER_ID", testPaper.getTeacherId());
				testPd.put("PAPER_ID", testPaper.getPaperId());
				testPd.put("SCLASS_ID", testPaper.getClassId());
				testPd.put(
						"CREATE_DATE",
						testPaper.getCreateDate() == null ? Tools
								.date2Str(new Date()) : testPaper
								.getCreateDate());
				testPd.put(
						"TEST_TYPE",
						testPaper.getTest_type() != null ? testPaper
								.getTest_type() : "1");
				List<PageData> listData = testpaperService.listAll(testPd);
				if (!(listData != null && listData.size() > 0)) {
					testPd.put("START_DATE", testPaper.getStartDate());
					testPd.put("END_DATE", testPaper.getEndDate());
					testPd.put("NAME", testPaper.getName());
					testPd.put("TESTPAPER_ID", testPaperId);
					testPd.put("OTHER_SCORE", testPaper.getOtherScore());
					testPd.put("HIGHT_SCORE", testPaper.getHighScore());
					testPd.put("LOW_SCORE", testPaper.getLowScore());
					testPd.put("AVG_SCORE", testPaper.getAvgScore());
					testPd.put("REMARK", testPaper.getRemark());
					testpaperService.save(testPd);
					if (testPaper.getStudents() != null) {
						List<PageData> testInfoPdList = new ArrayList();
						PageData testInfoPd = null;
						for (StudentAnswer studentAnswer : testPaper
								.getStudents()) {
							if (studentAnswer.getQuestions() != null) {
								PageData studentPageData = new PageData();
								studentPageData.put("STUDENTTEST_ID",
										get32UUID());
								studentPageData.put("STUDENT_ID",
										studentAnswer.getStudentId());
								studentPageData.put("TEST_ID", testPaperId);
								studentPageData.put("PAPER_ID",
										testPaper.getPaperId());
								studentPageData.put("SCORE",
										studentAnswer.getScore());
								studentPageData.put("CLASS_ID",
										testPaper.getClassId());
								studenttestService.save(studentPageData);

								for (TestPaperInfo testPaperInfo : studentAnswer
										.getQuestions()) {
									testInfoPd = new PageData();
									testInfoPd.put("TESTPAPERINFO_ID",
											this.get32UUID());
									testInfoPd.put("PAPER_ID",
											testPaper.getPaperId());
									testInfoPd.put("STUDENT_ID",
											studentAnswer.getStudentId());
									testInfoPd.put("TEST_ID", testPaperId);
									testInfoPd.put("QUESTION_ID",
											testPaperInfo.getQuestionId());
									testInfoPd.put("ANSWER",
											testPaperInfo.getAnswer());
									testInfoPd.put("RIGHT",
											testPaperInfo.getRight());
									testInfoPd.put("SCORE",
											testPaperInfo.getScore());
									testInfoPd.put("LIKES",
											testPaperInfo.getLikes());
									testInfoPd
											.put("ANSWER_TYPE",
													testPaperInfo
															.getAnswerType() == null ? "1"
															: testPaperInfo
																	.getAnswerType());
									testInfoPd.put("PRESS_TIME",
											testPaperInfo.getPressTime());
									testInfoPd.put("RECEIVER_DATE",
											testPaperInfo.getReceiverDate());
									testInfoPd.put("SUBJECTIVE",
											testPaperInfo.getSubjective());
									testInfoPd.put("NOTE",
											testPaperInfo.getNote());
									testInfoPd.put("MARK_NO",
											testPaperInfo.getMarkNo());
									testInfoPdList.add(testInfoPd);
								}
							}
						}
						testpaperinfoService.batchSave(testInfoPdList);
					}
				} else {
					testPaperId = listData.get(0).getString("TESTPAPER_ID");
				}
				res.setData(testPaperId);
			} catch (Exception e) {
				e.printStackTrace();
				res.setError();
				res.setMessage(e.getMessage());
			}
		} else {
			res.setDataError();
		}
		logger.info("uploadTestpaper cost time:"
				+ (System.currentTimeMillis() - cur));

		return res.toJson();

	}

	/**
	 * 上传测验成绩
	 * 
	 * @return
	 */
	@RequestMapping(value = "/uploadupdatetestpaper", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public Object uploadupdateTestpaper() {
		event("uploadupdateTestpaper");
		long cur = System.currentTimeMillis();
		PageData pd = this.getPageData();
		ResponseGson<String> res = new ResponseGson();
		if (!StringUtils.isEmpty(pd.getJsonString())) {
			logger.info(pd.getJsonString());
			TestPaper testPaper = TestPaper.parse(pd.getJsonString());
			try {
				PageData testPd = new PageData();
				String testPaperId = this.get32UUID();
				testPd.put("TEACHER_ID", testPaper.getTeacherId());
				testPd.put("PAPER_ID", testPaper.getPaperId());
				testPd.put("SCLASS_ID", testPaper.getClassId());
				testPd.put(
						"CREATE_DATE",
						testPaper.getCreateDate() == null ? Tools
								.date2Str(new Date()) : testPaper
								.getCreateDate());
				testPd.put(
						"TEST_TYPE",
						testPaper.getTest_type() != null ? testPaper
								.getTest_type() : "1");
				List<PageData> listData = testpaperService.listAll(testPd);
				if ((listData != null && listData.size() > 0)) {
					testPaperId = listData.get(0).getString("TESTPAPER_ID");
					testpaperService.deleteList(testPd);
					testPd.put("TEST_ID", testPaperId);
					testpaperinfoService.delete(testPd);
					studenttestService.delete(testPd);
				}
				testPd.put("START_DATE", testPaper.getStartDate());
				testPd.put("END_DATE", testPaper.getEndDate());
				testPd.put("NAME", testPaper.getName());
				testPd.put("TESTPAPER_ID", testPaperId);
				testPd.put("OTHER_SCORE", testPaper.getOtherScore());
				testPd.put("HIGHT_SCORE", testPaper.getHighScore());
				testPd.put("LOW_SCORE", testPaper.getLowScore());
				testPd.put("AVG_SCORE", testPaper.getAvgScore());
				testPd.put("TOTAL_SCORE", testPaper.getTotalScore());
				testPd.put("SUBJECT_ID", testPaper.getSubject_id());
				testPd.put("REMARK", testPaper.getRemark());
				testpaperService.save(testPd);
				if (testPaper.getStudents() != null) {
					List<PageData> testInfoPdList = new ArrayList();
					PageData testInfoPd = null;
					for (StudentAnswer studentAnswer : testPaper.getStudents()) {
						if (studentAnswer.getQuestions() != null) {
							PageData studentPageData = new PageData();
							studentPageData.put("STUDENT_ID",
									studentAnswer.getStudentId());
							studentPageData.put("TEST_ID", testPaperId);
							studentPageData.put("PAPER_ID",
									testPaper.getPaperId());
							studentPageData.put("SCORE",
									studentAnswer.getScore());
							studentPageData.put("CLASS_ID",
									testPaper.getClassId());
							studentPageData.put("STUDENTTEST_ID", get32UUID());
							studenttestService.save(studentPageData);

							for (TestPaperInfo testPaperInfo : studentAnswer
									.getQuestions()) {
								testInfoPd = new PageData();
								testInfoPd.put("TESTPAPERINFO_ID",
										this.get32UUID());
								testInfoPd.put("PAPER_ID",
										testPaper.getPaperId());
								testInfoPd.put("STUDENT_ID",
										studentAnswer.getStudentId());
								testInfoPd.put("TEST_ID", testPaperId);
								testInfoPd.put("QUESTION_ID",
										testPaperInfo.getQuestionId());
								testInfoPd.put("ANSWER",
										testPaperInfo.getAnswer());
								testInfoPd.put("RIGHT",
										testPaperInfo.getRight());
								testInfoPd.put("SCORE",
										testPaperInfo.getScore());
								testInfoPd.put("LIKES",
										testPaperInfo.getLikes());
								testInfoPd.put("ANSWER_TYPE", testPaperInfo
										.getAnswerType() == null ? "1"
										: testPaperInfo.getAnswerType());
								testInfoPd.put("PRESS_TIME",
										testPaperInfo.getPressTime());
								testInfoPd.put("RECEIVER_DATE",
										testPaperInfo.getReceiverDate());
								testInfoPd.put("SUBJECTIVE",
										testPaperInfo.getSubjective());
								testInfoPd.put("NOTE", testPaperInfo.getNote());
								testInfoPd.put("MARK_NO",
										testPaperInfo.getMarkNo());
								testInfoPdList.add(testInfoPd);
							}
						}
					}
					testpaperinfoService.batchSave(testInfoPdList);
				}
				res.setData(testPaperId);
			} catch (Exception e) {
				e.printStackTrace();
				res.setError();
				res.setMessage(e.getMessage());
			}
		} else {
			res.setDataError();
		}
		logger.info("uploadupdatetestpaper cost time:"
				+ (System.currentTimeMillis() - cur));

		return res.toJson();

	}

	/**
	 * 上传测验成绩
	 * 
	 * @return
	 */
	@RequestMapping(value = "/uploadupdatetestpaper2", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public Object uploadupdateTestpaper2() {
		event("uploadupdateTestpaper2");
		long cur = System.currentTimeMillis();
		PageData pd = this.getPageData();
		ResponseGson<String> res = new ResponseGson();
		if (!StringUtils.isEmpty(pd.getJsonString())) {
			logger.info(pd.getJsonString());
			TestPaper testPaper = TestPaper.parse(pd.getJsonString());
			try {
				PageData testPd = new PageData();
				String testPaperId = this.get32UUID();
				testPd.put("TEACHER_ID", testPaper.getTeacherId());
				testPd.put("PAPER_ID", testPaper.getPaperId());
				testPd.put("SCLASS_ID", testPaper.getClassId());
				testPd.put(
						"CREATE_DATE",
						testPaper.getCreateDate() == null ? Tools
								.date2Str(new Date()) : testPaper
								.getCreateDate());
				List<PageData> listData = testpaperService.listAll(testPd);
				if ((listData != null && listData.size() > 0)) {
					testPaperId = listData.get(0).getString("TESTPAPER_ID");
					testpaperService.deleteList(testPd);
					testPd.put("TEST_ID", testPaperId);
					testpaperinfoService.delete(testPd);
					studenttestService.delete(testPd);
				}
				testPd.put(
						"TEST_TYPE",
						testPaper.getTest_type() != null ? testPaper
								.getTest_type() : "101");
				testPd.put("START_DATE", testPaper.getStartDate());
				testPd.put("END_DATE", testPaper.getEndDate());
				testPd.put("NAME", testPaper.getName());
				testPd.put("TESTPAPER_ID", testPaperId);
				testPd.put("OTHER_SCORE", testPaper.getOtherScore());
				testPd.put("HIGHT_SCORE", testPaper.getHighScore());
				testPd.put("LOW_SCORE", testPaper.getLowScore());
				testPd.put("AVG_SCORE", testPaper.getAvgScore());
				testPd.put("TOTAL_SCORE", testPaper.getTotalScore());
				testPd.put("SUBJECT_ID", testPaper.getSubject_id());
				testPd.put("REMARK", testPaper.getRemark());
				testpaperService.save(testPd);
				if (testPaper.getStudents() != null) {
					List<PageData> testInfoPdList = new ArrayList();
					PageData testInfoPd = null;
					for (StudentAnswer studentAnswer : testPaper.getStudents()) {
						if (studentAnswer.getQuestions() != null) {
							PageData studentPageData = new PageData();
							studentPageData.put("STUDENT_ID",
									studentAnswer.getStudentId());
							studentPageData.put("TEST_ID", testPaperId);
							studentPageData.put("PAPER_ID",
									testPaper.getPaperId());
							studentPageData.put("SCORE",
									studentAnswer.getScore());
							studentPageData.put("CLASS_ID",
									testPaper.getClassId());
							studentPageData.put("STUDENTTEST_ID", get32UUID());
							studenttestService.save(studentPageData);

							for (TestPaperInfo testPaperInfo : studentAnswer
									.getQuestions()) {
								testInfoPd = new PageData();
								testInfoPd.put("TESTPAPERINFO_ID",
										this.get32UUID());
								testInfoPd.put("PAPER_ID",
										testPaperInfo.getPaperId());
								testInfoPd.put("STUDENT_ID",
										studentAnswer.getStudentId());
								testInfoPd.put("TEST_ID", testPaperId);
								testInfoPd.put("QUESTION_ID",
										testPaperInfo.getQuestionId());
								testInfoPd.put("ANSWER",
										testPaperInfo.getAnswer());
								testInfoPd.put("RIGHT",
										testPaperInfo.getRight());
								testInfoPd.put("SCORE",
										testPaperInfo.getScore());
								testInfoPd.put("LIKES",
										testPaperInfo.getLikes());
								testInfoPd.put("ANSWER_TYPE", testPaperInfo
										.getAnswerType() == null ? "1"
										: testPaperInfo.getAnswerType());
								testInfoPd.put("PRESS_TIME",
										testPaperInfo.getPressTime());
								testInfoPd.put("RECEIVER_DATE",
										testPaperInfo.getReceiverDate());
								testInfoPd.put("SUBJECTIVE",
										testPaperInfo.getSubjective());
								testInfoPd.put("NOTE", testPaperInfo.getNote());
								testInfoPd.put("MARK_NO",
										testPaperInfo.getMarkNo());
								testInfoPd.put("RANDOM",
										testPaperInfo.getRandom());
								testInfoPd.put("RANK", testPaperInfo.getRank());
								testInfoPdList.add(testInfoPd);
							}
						}
					}
					if(testInfoPdList.size() > 0){
						testpaperinfoService.batchSave(testInfoPdList);
					}
				}
				res.setData(testPaperId);
			} catch (Exception e) {
				e.printStackTrace();
				res.setError();
				res.setMessage(e.getMessage());
			}
		} else {
			res.setDataError();
		}
		logger.info("uploadupdateTestpaper2 cost time:"
				+ (System.currentTimeMillis() - cur));

		return res.toJson();

	}

	/**
	 * 查询知识点
	 * 
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value = "/point", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public Object point() throws Exception {
		event("point");
		ResponseGson<List<PageData>> res = new ResponseGson();

		PageData pd = getPageData();
		String key = this.getRequestKey(pd, "point");
		PageData pagedata = new PageData();
		pagedata.put("KEY", key);
		if (!"".equals(key.trim())) {
			PageData ret = cacheService.findById(pagedata);
			if (ret != null && ret.get("CACHE") != null) {
				return ret.get("CACHE");
			}
		}
		List<PageData> list = knowledgeService.listAllknowledge(pd);
		String depth = pd.getString("DEPTH");
		int end = 3;
		if (depth != null) {
			try {
				end = Integer.parseInt(depth);
			} catch (Exception e) {

			}
		}
		roundPointData(list, 1, end);
		res.setData(list);
		String str = res.toJson();
		str = str.replaceAll("[^\\u0000-\\uFFFF]", "");
		pagedata.put("CACHE", str);
		cacheService.save(pagedata);
		return str;
	}

	/**
	 * 知识点递归查询
	 * 
	 * @param list
	 *            查询知识点及子知识点
	 * @param dept
	 *            深度
	 * @param end
	 *            层深
	 * @throws Exception
	 */
	private void roundPointData(List<PageData> list, int dept, int end)
			throws Exception {
		if (list != null) {
			for (PageData pd : list) {
				pd.put("P_ID", pd.getString("KNOWLEDGE_ID"));
				if (pd.getString("P_ID") != null
						&& !"".equals(pd.getString("P_ID")) && dept < end) {
					List<PageData> ret = knowledgeService.listAllknowledge(pd);
					if (ret != null && ret.size() > 0) {
						roundPointData(ret, dept + 1, end);
						pd.put("CHILDREN", ret);
					}
				}
				pd.remove("P_ID");
			}
		}
	}

	/**
	 * 章节递归查询
	 * 
	 * @param list
	 *            章节
	 * @param dept
	 *            深度
	 * @param end
	 *            递归深度
	 * @throws Exception
	 */
	private void roundChapterData(List<PageData> list, int dept, int end)
			throws Exception {
		if (list != null) {
			for (PageData pd : list) {
				pd.put("P_ID", pd.getString("ID"));
				if (dept < end) {
					if (pd.getString("P_ID") != null
							&& !"".equals(pd.getString("P_ID"))) {
						List<PageData> ret = chapterService.listAllChapter(pd);
						if (ret != null && ret.size() > 0) {
							roundChapterData(ret, dept + 1, end);
							pd.put("CHILDREN", ret);
						}
					}
				}
				pd.remove("P_ID");
				pd.remove("TEACHINGMATERIAL_ID");
			}
		}
	}

	/**
	 * 下载测验成绩
	 * 
	 * @return
	 */
	@RequestMapping(value = "/downloadtestpaper", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public Object downloadTestpaper() {
		event("downloadTestpaper");
		long cur = System.currentTimeMillis();
		PageData pd = this.getPageData();
		ResponseGson<TestPaper> res = new ResponseGson();

		String paperId = pd.getString("ID");

		if (!StringUtils.isEmpty(paperId)) {
			TestPaper testPaper = new TestPaper();
			try {
				pd.put("TESTPAPER_ID", paperId);
				PageData testPd = testpaperService.findById(pd);
				if (testPd != null) {
					testPaper.setTestpaperId(paperId);
					testPaper.setTeacherId(testPd.getString("TEACHER_ID"));
					testPaper.setName(testPd.getString("NAME"));
					testPaper.setPaperId(testPd.getString("PAPER_ID"));
					testPaper.setClassId(testPd.getString("SCLASS_ID"));
					testPaper.setStartDate(testPd.getString("START_DATE"));
					testPaper.setEndDate(testPd.getString("END_DATE"));
					testPaper.setCreateDate(testPd.getString("CREATE_DATE"));
					testPaper.setOtherScore(testPd.getString("OTHER_SCORE"));
					testPaper.setHighScore(testPd.getString("HIGHT_SCORE"));
					testPaper.setLowScore(testPd.getString("LOW_SCORE"));
					testPaper.setAvgScore(testPd.getString("AVG_SCORE"));
					testPaper.setRemark(testPd.getString("REMARK"));
					PageData testInfof = new PageData();
					testInfof.put("TEST_ID", paperId);

					List<PageData> studentList = studenttestService
							.listAll(testInfof);

					for (PageData sPageData : studentList) {
						StudentAnswer studentAnswer = new StudentAnswer();
						testInfof.put("STDUENT_ID",
								sPageData.getString("STDUENT_ID"));
						studentAnswer.setScore(sPageData.getString("SCORE"));
						List<PageData> list = testpaperinfoService
								.listAll(testInfof);
						for (PageData testInfoPd : list) {
							TestPaperInfo testPaperInfo = new TestPaperInfo();
							testPaperInfo.setTestPaperInfoId(testInfoPd
									.getString("TESTPAPERINFO_ID"));
							testPaperInfo.setQuestionId(testInfoPd
									.getString("QUESTION_ID"));
							testPaperInfo.setAnswer(testInfoPd
									.getString("ANSWER"));
							testPaperInfo.setRight(testInfoPd
									.getString("RIGHT"));
							testPaperInfo.setScore(testInfoPd
									.getString("SCORE"));
							testPaperInfo.setLikes(testInfoPd
									.getString("LIKES"));
							testPaperInfo.setAnswerType(testInfoPd
									.getString("ANSWER_TYPE"));
							testPaperInfo.setPressTime(testInfoPd
									.getString("PRESS_TIME"));
							testPaperInfo.setReceiverDate(testInfoPd
									.getString("RECEIVER_DATE"));
							testPaperInfo.setSubjective(testInfoPd
									.getString("SUBJECTIVE"));
							testPaperInfo.setNote(testInfoPd.getString("NOTE"));
							testPaperInfo.setMarkNo(testInfoPd
									.getString("MARK_NO"));
							testPaperInfo.setRank(testInfoPd.getString("RANK"));
							studentAnswer.getQuestions().add(testPaperInfo);
						}
						testPaper.getStudents().add(studentAnswer);
					}
				}

				res.setData(testPaper);
			} catch (Exception e) {
				e.printStackTrace();
				res.setError();
			}
		}
		logger.info("downloadtestpaper cost time:"
				+ (System.currentTimeMillis() - cur));
		return res.toJson();

	}

	/**
	 * 
	 * 下载测验成绩
	 * 
	 * @return
	 */
	@RequestMapping(value = "/testpaper", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public Object testpaper() {
		event("testpaper");
		long cur = System.currentTimeMillis();
		PageData pd = this.getPageData();
		ResponseGson<List<TestPaper>> res = new ResponseGson();
		pd.put("TEACHER_ID", pd.getString("USER_ID"));
		try {
			List<PageData> pageList = testpaperService.listAll(pd);
			List<TestPaper> list = new ArrayList<TestPaper>();
			if (pageList != null) {
				for (PageData testPd : pageList) {
					TestPaper testPaper = new TestPaper();
					testPaper.setTestpaperId(testPd.getString("TESTPAPER_ID"));
					testPaper.setTeacherId(testPd.getString("TEACHER_ID"));
					testPaper.setName(testPd.getString("NAME"));
					testPaper.setPaperId(testPd.getString("PAPER_ID"));
					testPaper.setClassId(testPd.getString("SCLASS_ID"));
					testPaper.setStartDate(testPd.getString("START_DATE"));
					testPaper.setEndDate(testPd.getString("END_DATE"));
					testPaper.setCreateDate(testPd.getString("CREATE_DATE"));
					testPaper.setOtherScore(testPd.getString("OTHER_SCORE"));
					testPaper.setHighScore(testPd.getString("HIGHT_SCORE"));
					testPaper.setLowScore(testPd.getString("LOW_SCORE"));
					testPaper.setAvgScore(testPd.getString("AVG_SCORE"));
					testPaper.setRemark(testPd.getString("REMARK"));
					list.add(testPaper);
				}
			}
			res.setData(list);
		} catch (Exception e) {
			res.setError();
			res.setMessage(e.getMessage());
			e.printStackTrace();
		}
		logger.info("testpaper cost time:" + (System.currentTimeMillis() - cur));
		return res.toJson();

	}

	/***
	 * 
	 */
	@RequestMapping(value = "/schooladmin", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public void schoolAdmin() {
		event("schoolAdmin");
		PageData pd = this.getPageData();
		this.getUserID();
	}

	/***
	 * 网络
	 * 
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value = "/network", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public Object network() throws Exception {
		event("network");
		PageData pd = this.getPageData();
		ResponseGson<PageData> res = new ResponseGson();
		PageData spd = networkstatisticsService.findByClientID(pd);
		String seqStr = pd.getString("SEQ");
		if (seqStr != null && pd.getString("CLIENT_ID") != null
				&& pd.getString("SESSION_ID") != null) {
			int seq = Integer.parseInt(seqStr);
			if (spd != null) {
				int successCount = Integer.parseInt(spd
						.getString("SUCCESS_COUNT"));
				spd.put("SUCCESS_COUNT", ++successCount + "");
				int fail = seq - successCount;
				if (fail < 0) {
					fail = 0;
				}
				spd.put("FAIL_COUNT", fail + "");
				networkstatisticsService.edit(spd);
				spd.remove("NETWORKSTATISTICS_ID");
				spd.remove("CLIENT_ID");
				spd.remove("SESSION_ID");
				res.setData(spd);
			} else {
				pd.put("NETWORKSTATISTICS_ID", get32UUID());
				pd.put("SUCCESS_COUNT", "1");
				pd.put("CLIENT_IP", getRemoteIp());
				int fail = seq - 1;
				if (fail < 0) {
					fail = 0;
				}
				pd.put("FAIL_COUNT", fail + "");
				networkstatisticsService.save(pd);
				pd.remove("JSON");
				pd.remove("CLIENT_ID");
				pd.remove("SESSION_ID");
				pd.remove("SEQ");
				pd.remove("NETWORKSTATISTICS_ID");
				res.setData(pd);
			}
		} else {
			res.setDataError();
		}
		return res.toJson();
	}

	/**
	 * 获取远端ip地址
	 * 
	 * @return
	 */
	public String getRemoteIp() {
		HttpServletRequest request = getRequest();
		String ip = "";
		if (request.getHeader("x-forwarded-for") == null) {
			ip = request.getRemoteAddr();
		} else {
			ip = request.getHeader("x-forwarded-for");
		}
		return ip;
	}

	/**
	 * 查询新版本信息
	 * 
	 * @param request
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value = "/newversion", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public Object getNewVersion(HttpServletRequest request) throws Exception {
		event("getNewVersion");
		PageData pd = this.getPageData();
		String softId = pd.getString("SOFTID");
		String path = request.getContextPath();
		String basePath = request.getScheme() + "://" + request.getServerName()
				+ ":" + request.getServerPort() + path + "/";
		ResponseGson<PageData> res = new ResponseGson();
		if (softId != null && !"".equals(softId)) {
			pd.put("SOFTWARE_ID", softId);
			PageData result = softwareversionService.findNewVersion(pd);
			if (result != null) {
				result.remove("SOFTWAREVERSION_ID");
				result.remove("SOFTWARE_ID");
				result.put("VERSION_PATH", basePath + "uploadFiles/uploadFile/"
						+ result.getString("VERSION_PATH"));
				res.setData(result);
			} else {
				res.setDataError();
			}
		} else {
			res.setDataError();
		}
		return res.toJson();
	}

	/**
	 * 获取教材版本
	 * 
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value = "/teachingmaterial", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public Object teachingmaterial() throws Exception {
		PageData pd = getPageData();
		ResponseGson<List<PageData>> ret = new ResponseGson<List<PageData>>();
		List<PageData> lpd = new ArrayList<PageData>();
		List<PageData> list = teachingmaterialService.listAll(pd);
		String subjectID = pd.getString("SUBJECT_ID");
		if (subjectID != null && !"".equals(subjectID)) {
			for (PageData pad : list) {
				String subis = pad.getString("SUBJECT_ID");
				if (subis != null) {
					String[] subs = subis.split(",");
					if (subs != null) {
						for (String sub : subs) {
							if (subjectID.trim().equals(sub.trim())) {
								pad.remove("SUBJECT_ID");
								pad.put("VERSION_CODE",
										pad.getString("VERSION_CODE"));
								lpd.add(pad);
								break;
							}
						}
					}
				}
			}
		} else {
			for (PageData pad : list) {
				pad.remove("SUBJECT_ID");
				pad.put("VERSION_CODE", pad.getString("VERSION_CODE"));
				lpd.add(pad);
			}
		}
		ret.setData(lpd);
		return ret.toJson();
	}

	@RequestMapping(value = "/textbook", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public Object textbook() throws Exception {
		PageData pd = getPageData();
		ResponseGson<List<PageData>> ret = new ResponseGson<List<PageData>>();
		List<PageData> list = textbookService.listAll(pd);
		ret.setData(list);
		return ret.toJson();
	}

	/**
	 * 获取教材版本
	 * 
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value = "/chapter", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public Object chapter() throws Exception {
		PageData pd = getPageData();
		String key = this.getRequestKey(pd, "chapter");
		PageData pagedata = new PageData();
		pagedata.put("KEY", key);
		if (!"".equals(key.trim())) {
			PageData ret = cacheService.findById(pagedata);
			if (ret != null && ret.get("CACHE") != null) {
				return ret.get("CACHE");
			}
		}
		ResponseGson<List<PageData>> res = new ResponseGson<List<PageData>>();
		List<PageData> list = chapterService.listAllChapter(pd);
		String depth = pd.getString("DEPTH");
		int end = 3;
		if (depth != null) {
			try {
				end = Integer.parseInt(depth);
			} catch (Exception e) {

			}
		}
		roundChapterData(list, 1, end);
		res.setData(list);
		String str = res.toJson();
		pagedata.put("CACHE", str);
		cacheService.save(pagedata);
		return str;
	}

	/**
	 * 获取试题
	 * 
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value = "/questions", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public Object questions() throws Exception {
		PageData pd = getPageData();
		ResponseGson<List<PageData>> res = new ResponseGson<List<PageData>>();
		String teachingmaterialId = pd.getString("TEACHINGMATERIAL_ID");
		String chapterId = pd.getString("CHAPTER_ID");
		if (teachingmaterialId != null && !teachingmaterialId.equals("")
				&& chapterId == null) {
			PageData chapterPd = new PageData();
			chapterPd.put("TEACHINGMATERIAL_ID", teachingmaterialId);
			List<PageData> chapterList = chapterService
					.listAllChapter(chapterPd);
			roundChapterData(chapterList, 1, 3);
			List<String> ids = getIds(chapterList, "ID");
			pd.put("CHAPTER_IDS", ids);
		} else {
			List<String> ids = new ArrayList<String>();
			if (chapterId != null && !"".equals(chapterId.trim())) {
				ids.add(chapterId);
			}
			pd.put("CHAPTER_IDS", ids);
		}
		pd.remove("CHAPTER_ID");
		String knowledge = pd.getString("KNOWLEDGE_ID");
		if (knowledge != null && !"".equals(knowledge.trim())) {
			PageData knowPd = new PageData();
			knowPd.put("P_ID", knowledge);
			List<PageData> knowlist = knowledgeService.listAllknowledge(knowPd);
			roundPointData(knowlist, 1, 3);
			List<String> ids = getIds(knowlist, "KNOWLEDGE_ID");
			ids.add(knowledge);
			pd.put("KNOWLEDGE_IDS", ids);
			pd.remove("KNOWLEDGE_ID");
		}
		int pageNumI = 0;
		int count = 30;
		String pageNum = pd.getString("PAGENUM");
		String countStr = pd.getString("COUNT");
		if (pageNum != null && !"".equals(pageNum) && countStr != null
				&& !"".equals(countStr)) {
			pageNumI = Integer.parseInt(pageNum);
			count = Integer.parseInt(countStr);
			if (pageNumI >= 1) {
				pageNumI = (pageNumI - 1) * count;
			} else {
				pageNumI = 0;
			}
			pd.put("PAGENUM", "" + pageNumI);
			pd.put("COUNT", "" + count);
		}
		List<PageData> list = questionService.listAllquestion(pd);
		for (PageData pad : list) {
			String optionContent = pad.getString("OPTION_CONTENT");
			if (optionContent != null && optionContent.startsWith("[")
					&& optionContent.endsWith("]")) {
				String[] options = optionContent.substring(1,
						optionContent.length() - 1).split(",");
				pad.put("OPTION_CONTENT", options);
			} else {
				pad.put("OPTION_CONTENT", new String[] { optionContent });
			}
		}
		res.setData(list);
		return res.toJson();
	}

	/**
	 * 随机获取试题
	 * 
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value = "/randquestions", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public Object randquestions() throws Exception {
		PageData pd = getPageData();
		ResponseGson<List<PageData>> res = new ResponseGson<List<PageData>>();
		String teachingmaterialId = pd.getString("TEACHINGMATERIAL_ID");
		String chapterId = pd.getString("CHAPTER_ID");
		if (teachingmaterialId != null && !teachingmaterialId.equals("")
				&& chapterId == null) {
			PageData chapterPd = new PageData();
			chapterPd.put("TEACHINGMATERIAL_ID", teachingmaterialId);
			List<PageData> chapterList = chapterService
					.listAllChapter(chapterPd);
			roundChapterData(chapterList, 1, 3);
			List<String> ids = getIds(chapterList, "ID");
			pd.put("CHAPTER_IDS", ids);
		} else {
			List<String> ids = new ArrayList<String>();
			if (chapterId != null && !"".equals(chapterId.trim())) {
				ids.add(chapterId);
			}
			pd.put("CHAPTER_IDS", ids);
		}
		pd.remove("CHAPTER_ID");
		String knowledge = pd.getString("KNOWLEDGE_ID");
		if (knowledge != null && !"".equals(knowledge.trim())) {
			PageData knowPd = new PageData();
			knowPd.put("P_ID", knowledge);
			List<PageData> knowlist = knowledgeService.listAllknowledge(knowPd);
			roundPointData(knowlist, 1, 3);
			List<String> ids = getIds(knowlist, "KNOWLEDGE_ID");
			ids.add(knowledge);
			pd.put("KNOWLEDGE_IDS", ids);
			pd.remove("KNOWLEDGE_ID");
		}
		List<PageData> list = questionService.listAllRandquestion(pd);
		for (PageData pad : list) {
			String optionContent = pad.getString("OPTION_CONTENT");
			if (optionContent != null && optionContent.startsWith("[")
					&& optionContent.endsWith("]")) {
				String[] options = optionContent.substring(1,
						optionContent.length() - 1).split(",");
				pad.put("OPTION_CONTENT", options);
			} else {
				pad.put("OPTION_CONTENT", new String[] { optionContent });
			}
		}
		res.setData(list);
		return res.toJson();
	}

	/**
	 * 
	 * @param chapterList
	 * @param key
	 * @return
	 */
	public List<String> getIds(List<PageData> chapterList, String key) {
		List<String> ids = new ArrayList<String>();
		if (chapterList != null && chapterList.size() > 0) {
			for (PageData pd : chapterList) {
				String chapterid = pd.getString(key);
				if (chapterid != null && !"".equals(chapterid)) {
					ids.add(chapterid);
				}
				Object obj = pd.get("CHILDREN");
				if (obj != null && (obj instanceof List)) {
					@SuppressWarnings("unchecked")
					List<PageData> list = (List<PageData>) obj;
					List<String> ret = getIds(list, key);
					if (ret != null && ret.size() > 0) {
						ids.addAll(ret);
					}
				}
			}
		}

		return ids;

	}

	/**
	 * 
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value = "/tempcreateUser", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public Object tempCreateUser() throws Exception {
		PageData pd = new PageData();
		pd = this.getPageData();
		pd.put("ID", this.get32UUID());
		teacherService.save(pd);
		pd.put("USER_ID", pd.getString("ID")); // ID 主键
		pd.put("LAST_LOGIN", ""); // 最后登录时间
		pd.put("IP", ""); // IP
		pd.put("STATUS", "0"); // 状态
		pd.put("SKIN", "default");
		pd.put("RIGHTS", "");
		pd.put("USERNAME", pd.getString("ACCOUT"));
		pd.put("ROLE_ID", "57bb1e6f138247a0b05cc721a5da1b64");
		pd.put("PASSWORD",
				new SimpleHash("SHA-1", pd.getString("ACCOUT"), pd
						.getString("PASSWORD")).toString()); // 密码加密

		if (null == userService.findByUsername(pd)) { // 判断用户名是否存在
			userService.saveU(pd); // 执行保存
		}

		// ID, TEACHER_ID, CLASS_ID, SUBJECT_ID, START_DATE, END_DATE, GRADE_ID,
		// TERM_ID, REMARK
		pd.put("TEACHER_ID", pd.get("ID"));
		pd.put("CLASS_ID", "bc33389101ec46e6b7d47daa8adf58ac");
		pd.put("SUBJECT_ID", "1");
		pd.put("GRADE_ID", "1");
		pd.put("TERM_ID", "0d8ea2efdef74accbd0d00e9bc07dfbb");
		coursemanagementService.save(pd);

		return "{'res':'success'}";
	}

	/**
	 * 
	 * @param apiName
	 */
	private void event(String apiName) {
//		PageData eventPd = new PageData();
//		eventPd.put("EVENT_ID", get32UUID());
//		eventPd.put("EVENT_NAME", apiName);
//		eventPd.put("EVENT_USER", getUsername());
//		eventPd.put("EVENT_TYPE", "-1");
//		eventPd.put("EVENT_START_TIME", Tools.date2Str(new Date()));
//		eventPd.put("CLIENT_ID", "SERVER");
//		eventPd.put("EVENT_IP", getRemoteIp());
//		try {
//			eventService.save(eventPd);
//		} catch (Exception e) {
//
//		}
	}

	static int index = 0;

	/**
	 * 
	 * @param point
	 * @param pid
	 */
	private void savePoint(Point point, String pid) {
		List<Point> children = point.getChildren();
		if (children != null && children.size() > 0) {
			for (Point p : children) {
				savePoint(p, point.getCode());
			}
		}
		PageData pageData = new PageData();
		pageData.put("KNOWLEDGE_ID", point.getCode());
		pageData.put("NAME", point.getName());
		pageData.put("P_ID", pid);
		pageData.put("RANK", ++index);
		try {
			knowledgeService.save(pageData);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	/**
	 * 
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value = "/uploadbook", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public Object uploadbook() throws Exception {
		event("uploadbook");
		long cur = System.currentTimeMillis();
		PageData pd = this.getPageData();
		ResponseGson<String> res = new ResponseGson();

		if (!StringUtils.isEmpty(pd.getJsonString())) {
			try {
				ResponseGson<List<Point>> req = ResponseGson.parse(
						pd.getJsonString(), Point.class);
				List<Point> list = req.getData();
				if (list != null && list.size() > 0) {
					for (Point point : list) {
						saveBook(point);
					}
				}
			} catch (Exception e) {
				res.setError();
			}
		} else {
			res.setDataError();
		}
		logger.info("uploadpoint cost time : "
				+ (System.currentTimeMillis() - cur));
		return res.toJson();
	}

	/**
	 * 
	 * @param point
	 */
	private void saveBook(Point point) {

		PageData pd = new PageData();
		pd.put("ID", point.getCode());
		pd.put("NAME", point.getName());
		pd.put("SUBJECT_ID", point.getSubjectCode());
		try {
			teachingmaterialService.save(pd);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	/**
	 * 
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value = "/uploadyuncelianquestion", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public Object uploadyuncelianquestion() throws Exception {
		event("uploadyuncelianquestion");
		long cur = System.currentTimeMillis();
		PageData pd = this.getPageData();
		ResponseGson<Object> res = new ResponseGson();

		if (!StringUtils.isEmpty(pd.getJsonString())) {
			try {
				ResponseGson<Object> req = ResponseGson.parse(pd
						.getJsonString());
				Object data = req.getData();
				if (data instanceof List) {
					List<Object> list = (List) data;
					for (Object obj : list) {
						if (obj instanceof Map) {
							Map map = (Map) obj;

							PageData pageData = new PageData();
							pageData.put("QUESTION_ID", map.get("id"));
							Object cateObj = map.get("cate");
							if (cateObj != null) {
								String cate = cateObj.toString();
								float catef = Float.parseFloat(cate);
								pageData.put("QUESTION_TYPE_ID", (int) catef);
							}
							Object contentObj = map.get("content");
							if (contentObj != null) {
								String content = contentObj.toString();
								content = replaceWebUrl(content);
								pageData.put("CONTENT", content);
							}
							Object subjectCodeObj = map.get("subjectCode");
							if (subjectCodeObj != null) {
								String subjectCode = subjectCodeObj.toString();
								pageData.put("SUBJECT_ID", subjectCode);
							}
							Object optionsObj = map.get("options");
							if (optionsObj instanceof List) {
								List ss = (List) optionsObj;
								pageData.put("OPTION_CONTENT",
										optionsObj.toString());
								pageData.put("OPTION_NUM", "" + ss.size());
							}
							Object answersObj = map.get("answers");
							if (answersObj instanceof List) {
								List answers = (List) answersObj;
								StringBuilder sb = new StringBuilder();
								for (Object as : answers) {
									sb.append(as.toString());
								}
								pageData.put("ANSWER", sb.toString());
							}
							Object difficulty = map.get("difficulty");
							try {
								if (difficulty != null) {
									float fdifficulty = Float
											.parseFloat(difficulty.toString());
									pageData.put("DIFFICULTY",
											(int) fdifficulty);
								}
							} catch (Exception ex) {
								ex.printStackTrace();
							}
							Object discussObj = map.get("discuss");
							if (discussObj != null) {
								String discuss = discussObj.toString();
								discuss = replaceWebUrl(discuss);
								pageData.put("REMARK", discuss);
							}
							Object analyseObj = map.get("analyse");
							if (analyseObj != null) {
								String analyse = analyseObj.toString();
								analyse = replaceWebUrl(analyse);
								pageData.put("ANALYSIS", analyse);
							}
							Object methodObj = map.get("method");
							if (methodObj != null) {
								String method = methodObj.toString();
								method = replaceWebUrl(method);
								pageData.put("METHOD", method);
							}
							Object points = map.get("points");
							StringBuilder sb = new StringBuilder();
							if (points instanceof List) {
								List pointsList = (List) points;
								for (Object pObject : pointsList) {
									if (pObject instanceof Map) {
										Map pMap = (Map) pObject;
										sb.append(pMap.get("code")).append(",");
									}
								}

								if (sb.toString().length() > 1) {
									sb.deleteCharAt(sb.length() - 1);
								}
								pageData.put("KNOWLEDGE_ID", sb.toString());
							}
							pageData.put("QUESTION_FROM", "101");
							try {
								questionService.save(pageData);
							} catch (Exception e) {
								logger.error("save fail:" + map.get("id"), e);
							}
						}
					}
				}
			} catch (Exception e) {
				res.setError();
			}
		} else {
			res.setDataError();
		}
		logger.info("uploadyuncelianquestion cost time : "
				+ (System.currentTimeMillis() - cur));
		return res.toJson();
	}

	/**
	 * 
	 * @param content
	 * @return
	 */
	private String replaceWebUrl(String content) {
		if (content != null) {
			content = content.replaceAll(
					"http://image.yuncelian.com/1/analysis/",
					"http://image.yuncelian.com/1/analysis/");
		}
		return content;
	}

	/**
	 * 
	 * @param pd
	 * @param methodName
	 * @return
	 */
	public String getRequestKey(PageData pd, String methodName) {
		StringBuilder key = new StringBuilder();
		key.append(methodName).append("{");
		if (pd != null) {
			Iterator iterator = pd.keySet().iterator();
			while (iterator.hasNext()) {
				Object obj = iterator.next();
				key.append(obj.toString()).append(":")
						.append(pd.get(obj).toString()).append(";");
			}
		}
		key.append("}");

		return key.toString();
	}

	/**
	 * 根据ID，获取科目中文名称
	 * 
	 * @param type
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value = "/subjectename", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public String findSubjectEName() throws Exception {
		PageData pageData = this.getPageData();
		ResponseGson<String> res = new ResponseGson<String>();
		pageData = subjectService.findById(pageData);
		if (pageData != null) {
			res.setData(pageData.getString("ENAME"));
		} else {
			res.setDataError();
		}
		return res.toJson();
	}

	/**
	 * 根据ID或者科目英文名称
	 * 
	 * @param type
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value = "/subjectcname", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public String findSubjectCName() throws Exception {
		ResponseGson<String> res = new ResponseGson<String>();
		PageData pageData = new PageData();
		StringBuilder sb = new StringBuilder();
		String type = this.getPageData().getString("ID");
		if (type.contains(",")) {
			String[] types = type.split(",");
			for (String t : types) {
				pageData.put("ID", t);
				pageData = subjectService.findById(pageData);
				if (pageData != null) {
					sb.append(pageData.getString("CNAME") + ";  ");
				}
			}
			sb.delete(sb.length() - 3, sb.length());
		} else {
			pageData.put("ID", type);
			pageData = subjectService.findById(pageData);
			if (pageData != null) {
				sb.append(pageData.getString("CNAME"));
			}
		}
		res.setData(sb.toString());
		return res.toJson();
	}

	/**
	 * 根据ID班级名称
	 * 
	 * @param id
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value = "/classname", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public String findClassName() throws Exception {
		ResponseGson<String> res = new ResponseGson<String>();
		PageData pageData = this.getPageData();
		pageData = sclassService.findById(pageData);
		String className = "";
		if (pageData != null) {
			className = pageData.getString("CLASS_NAME");
		} else {
			res.setDataError();
		}
		res.setData(className);
		return res.toJson();

	}
	
	/**
	 * 获取作业列表
	 * 
	 * @param id
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value = "/listhomework", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public String listhomework() throws Exception {
		ResponseGson<List<PageData>> res = new ResponseGson<List<PageData>>();
		PageData pageData = this.getPageData();
		List<PageData> list = homeworkService.qlistAll(pageData);
		res.setData(list);
		return res.toJson();
		
	}
	
	/**
	 * 获取作业详情
	 * 
	 * @param id
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value = "/homework", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public String homework() throws Exception {
		ResponseGson<List<PageData>> res = new ResponseGson<List<PageData>>();
		PageData pageData = this.getPageData();
		List<PageData> list = homeworkproblemService.listProblem(pageData);
		for(PageData pd : list){
			if(pd.get("P_HOMEWORK_PROBLEM_ID") != null){
				List<PageData> childList = homeworkproblemService.listProblem(pd);
				pd.put("PROBLEMS", childList);
			}
			
		}
		res.setData(list);
		return res.toJson();
		
	}
	
	/**
	 * 获取作业详情
	 * 
	 * @param id
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value = "/uploadhomework", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public String uploadhomework() throws Exception {
		ResponseGson<String> res = new ResponseGson<String>();
		
		PageData pd = this.getPageData();
		if (!StringUtils.isEmpty(pd.getJsonString())) {
			ResultHomework resultHomework = ResultHomework.parse(pd.getJsonString());
			PageData homePd = new PageData();
			homePd.put("HOMEWORK_ID", resultHomework.getHOMEWORK_ID());
			homePd.put("CLASS_ID", resultHomework.getCLASS_ID());
			homePd.put("GET_SCORE", resultHomework.getGET_SCORE());
			homePd.put("GET_SCORE_PERSENT", resultHomework.getGET_SCORE_PERSENT());
			homePd.put("COMPLETE_DESC", resultHomework.getCOMPLETE_DESC());
			homePd.put("GET_MAX_SCORE", resultHomework.getGET_MAX_SCORE());
			homeworkService.edit(homePd);
			List<PageData> list = homeworkReporkService.findByHomeworkID(homePd);
			if(list == null || list.size() == 0){
				// 初始化班級作业数据
				// 1. 根据班级id 查询班级学生列表
				List<PageData> student = studentService.findByClassId(homePd);
				for(PageData ptd : student){
					ptd.put("STUDENT_NAME", ptd.get("NAME"));
					ptd.put("STUDENT_NO", ptd.get("SNO"));
					ptd.put("RANK", student.size() + "");
					ptd.put("KEYBOARD", ptd.get("KEYPAD_ID"));
					ptd.put("RIGHT_PERSENT", "0%");
					ptd.put("GET_SCORE", "0");
					ptd.put("ANSWER", "");
					ptd.put("HOMEWORK_ID", resultHomework.getHOMEWORK_ID());
				}
				// 2. 根据学生列表生成初始化成绩
				homeworkReporkService.batchSave(student);
			}
			List<ResultStudent> students = resultHomework.getSTUDENTS();
			for(ResultStudent student:students){
				// update 学生作业情况
				PageData tpd = new PageData();
				tpd.put("STUDENT_NAME", student.getSTUDENT_NAME());
				tpd.put("STUDENT_NO", student.getSTUDENT_NO());
				tpd.put("RANK", student.getRANK());
				tpd.put("KEYBOARD", student.getKEYBOARD());
				tpd.put("RIGHT_PERSENT", student.getRIGHT_PERSENT());
				tpd.put("GET_SCORE", student.getGET_SCORE());
				tpd.put("ANSWER", student.getANSWER());
				tpd.put("HOMEWORK_ID", resultHomework.getHOMEWORK_ID());
				homeworkReporkService.update(tpd);
			}
			res.setData(resultHomework.getHOMEWORK_ID());
		}else{
			res.setDataError();
		}
		
		return res.toJson();
		
	}
	
	
	/**
	 * 更新学生详情
	 * 
	 * @param id
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value = "/uploadshomework", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public String uploadshomework() throws Exception {
		ResponseGson<String> res = new ResponseGson<String>();
		
		PageData pd = this.getPageData();
		if (!StringUtils.isEmpty(pd.getJsonString())) {
			ResultHomework resultHomework = ResultHomework.parse(pd.getJsonString());
			PageData homePd = new PageData();
			homePd.put("HOMEWORK_ID", resultHomework.getHOMEWORK_ID());
			homePd.put("CLASS_ID", resultHomework.getCLASS_ID());
			homePd.put("GET_SCORE", resultHomework.getGET_SCORE());
			homePd.put("GET_SCORE_PERSENT", resultHomework.getGET_SCORE_PERSENT());
			homePd.put("COMPLETE_DESC", resultHomework.getCOMPLETE_DESC());
			homePd.put("GET_MAX_SCORE", resultHomework.getGET_MAX_SCORE());
			homeworkService.edit(homePd);
			List<PageData> list = homeworkReporkService.findByHomeworkID(homePd);
			if(list == null || list.size() == 0){
				// 初始化班級作业数据
				// 1. 根据班级id 查询班级学生列表
				List<PageData> student = studentService.findByClassId(homePd);
				for(PageData ptd : student){
					ptd.put("STUDENT_NAME", ptd.get("NAME"));
					ptd.put("STUDENT_NO", ptd.get("SNO"));
					ptd.put("RANK", student.size() + "");
					ptd.put("KEYBOARD", ptd.get("KEYPAD_ID"));
					ptd.put("RIGHT_PERSENT", "0%");
					ptd.put("GET_SCORE", "0");
					ptd.put("ANSWER", "");
					ptd.put("HOMEWORK_ID", resultHomework.getHOMEWORK_ID());
				}
				// 2. 根据学生列表生成初始化成绩
				homeworkReporkService.batchSave(student);
			}
			List<ResultStudent> students = resultHomework.getSTUDENTS();
			for(ResultStudent student:students){
				// update 学生作业情况
				PageData tpd = new PageData();
				tpd.put("STUDENT_NAME", student.getSTUDENT_NAME());
				tpd.put("STUDENT_NO", student.getSTUDENT_NO());
				tpd.put("RANK", student.getRANK());
				tpd.put("KEYBOARD", student.getKEYBOARD());
				tpd.put("RIGHT_PERSENT", student.getRIGHT_PERSENT());
				tpd.put("GET_SCORE", student.getGET_SCORE());
				tpd.put("ANSWER", student.getANSWER());
				tpd.put("HOMEWORK_ID", resultHomework.getHOMEWORK_ID());
				homeworkReporkService.update(tpd);
			}
			res.setData(resultHomework.getHOMEWORK_ID());
		}else{
			res.setDataError();
		}
		
		return res.toJson();
		
	}

	/**
	 * 根据ID班级名称
	 * 
	 * @param id
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value = "/qstudentinfo", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public String qstudentinfo() throws Exception {
		ResponseGson<List<PageData>> res = new ResponseGson();
		PageData pageData = this.getPageData();
		if (pageData.containsKey("TEST_ID")
				&& pageData.containsKey("QUESTION_ID")) {
			List<PageData> list = v1Service.getQuestionWrongInfo(pageData);
			res.setData(list);
		} else {
			res.setDataError();
		}
		return res.toJson();

	}

	/**
	 * 根据ID班级名称
	 * 
	 * @param id
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value = "/wrongquestion", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public String wrongquestion() throws Exception {
		ResponseGson<List<PageData>> res = new ResponseGson();
		PageData pageData = this.getPageData();
		List<PageData> list = v1Service.getLastWrongQuestionInfo(pageData);
		res.setData(list);
		return res.toJson();

	}

	/**
	 * 根据ID班级名称
	 * 
	 * @param id
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value = "/printmsg", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public String printmsg() throws Exception {
		ResponseGson<Map> res = new ResponseGson();
		res.setData(FileUploadProgressListener.map);
		return res.toJson();

	}

	/**
	 * 根据ID班级名称
	 * 
	 * @param id
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value = "/printresult", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public String printresult() throws Exception {
		ResponseGson<Map> res = new ResponseGson();
		res.setData(FileUploadProgressListener.result);
		return res.toJson();

	}

	@RequestMapping(value = "/uploadfile", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public String uploadFile(
			@RequestParam(value = "file", required = false) MultipartFile file,
			HttpServletRequest request) throws Exception {
		ResponseGson<String> res = new ResponseGson<String>();
		if (file != null) {
			String path = request.getSession().getServletContext()
					.getRealPath("/uploadFiles/uploadFile/");
			String name = System.currentTimeMillis()
					+ file.getOriginalFilename();
			File pathFile = new File(path);
			pathFile.mkdirs();
			File saveFile = new File(path + File.separator + name);
			if (saveFile.exists()) {
				saveFile.delete();
			}
			saveFile.createNewFile();
			file.transferTo(saveFile);
			path = request.getContextPath();
			String basePath = request.getScheme() + "://"
					+ request.getServerName() + ":" + request.getServerPort()
					+ path + "/";
			res.setData("/uploadFiles/uploadFile/" + name);
		} else {
			res.setDataError();
		}
		return res.toJson();
	}

	@RequestMapping(value = "/liuqin", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public String dosunvotedata() /*throws Exception*/ {

		PageData pd = new PageData();
		pd.put("dbtype", "mysql");
		pd.put("username", "root");
		pd.put("password", "admin");
		pd.put("dbAddress", "120.78.57.84");
		pd.put("dbport", "3306");
		pd.put("databaseName", "sunvote");
		pd.put("dbport", "3306");
		List<PageData> resultList = new ArrayList<PageData>();
		
		try {
			Connection conn = DbFH.getFHCon(pd);

			Statement stmt = conn.createStatement();
			ResultSet rs = stmt
					.executeQuery("select reportId,paperName,createTime,paperScore,classAverage,className from t_report where userId = '4000001' and className = 'G205' ");
			while (rs.next()) {
				PageData coloumData = new PageData();
				String reportId = rs.getString("reportId");
				coloumData.put("PAPER_ID", reportId);
				coloumData.put("TESTPAPER_ID", reportId);
				coloumData.put("NAME", rs.getString("paperName"));
				coloumData.put("START_DATE", rs.getString("createTime"));
				coloumData.put("END_DATE", rs.getString("createTime"));
				coloumData.put("CREATE_DATE", rs.getString("createTime"));
				coloumData.put("REMARK", rs.getString("paperScore"));
				coloumData.put("TOTAL_SCORE", rs.getString("paperScore"));
				coloumData.put("AVG_SCORE", rs.getString("classAverage"));
				String className = rs.getString("className");
				if ("G201".equals(className)) {
					coloumData.put("SCLASS_ID",
							"2af1ca03c40c4acab7b7d0f8243c9849");
				}
				if ("G202".equals(className)) {
					coloumData.put("SCLASS_ID",
							"49f1b14d10424bb6abc8aed56a4693cf");
				}
				if ("G203".equals(className)) {
					coloumData.put("SCLASS_ID",
							"80b5dde0138b405bb2bcfc5f33bad649");
				}
				if ("G204".equals(className)) {
					coloumData.put("SCLASS_ID",
							"f9de4a939ec54d7ba27d1248279a2f95");
				}
				if ("G205".equals(className)) {
					coloumData.put("SCLASS_ID",
							"0f10ce0a3bf146769213c49825c35feb");
				}
				if ("G206".equals(className)) {
					coloumData.put("SCLASS_ID",
							"d33edcd7a0f74ca9a0e92ebda9442869");
				}
				if ("G207".equals(className)) {
					coloumData.put("SCLASS_ID",
							"ffef54ef21c64525831f266b6fae34fc");
				}
				coloumData
						.put("TEACHER_ID", "dbf8b49c641d47a8a811bb6d7480be72");
				coloumData.put("TEST_TYPE", "1");

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

				Statement stmt1 = conn.createStatement();
				ResultSet rs1 = stmt1
						.executeQuery("select studentName,answerStr,score,totalScore from t_reportdetail where reportId = '"
								+ reportId + "'");
				while (rs1.next()) {
					PageData detailPd = new PageData();
					detailPd.put("NAME", rs1.getString("studentName"));
					detailPd.put("answerStr", rs1.getString("answerStr"));
					detailPd.put("SCORE", rs1.getString("totalScore"));
					detailPd.put("totalScore",  rs.getString("paperScore"));
					detailList.add(detailPd);
				}
				rs1.close();
				stmt1.close();
				stmt1 = null;
				coloumData.put("STUDENT", detailList);

				resultList.add(coloumData);
			}
			rs.close();
			stmt.close();
			conn.close();
		}catch(Exception e){
			e.printStackTrace();
		}
		for (PageData paper : resultList) {
			PageData testPd = new PageData();
			testPd.put("TESTPAPER_ID", paper.get("TESTPAPER_ID"));
			testPd.put("PAPER_ID", paper.get("PAPER_ID"));
			List<PageData> listData = null;
			try {
				listData = testpaperService.listAll(testPd);
			} catch (Exception e) {
				e.printStackTrace();
			}
			if ((listData != null && listData.size() > 0)) {
				String testPaperId = listData.get(0).getString("TESTPAPER_ID");
				try {
					testpaperService.deleteList(testPd);
				} catch (Exception e) {
					e.printStackTrace();
				}
				testPd.put("TEST_ID", testPaperId);
				try {
					testpaperinfoService.delete(testPd);
				} catch (Exception e) {
					e.printStackTrace();
				}
				try {
					studenttestService.delete(testPd);
				} catch (Exception e) {
					e.printStackTrace();
				}
				listData.clear();
			}
			if (!(listData != null && listData.size() > 0)) {
				logger.info(paper);
				try {
					testpaperService.save(paper);
				} catch (Exception e) {
					e.printStackTrace();
				}
				logger.info("添加测试名称成功：" +  paper.get("TESTPAPER_ID"));
				List<PageData> detailList = (List<PageData>) paper.get("STUDENT");
				int i = 0;
				List<PageData> testInfoPdList = new ArrayList();
				for (PageData student : detailList) {
					i++;
					PageData studentDetail = null;
					try {
						studentDetail = studentService.findByName(student);
					} catch (Exception e) {
						e.printStackTrace();
					}
					PageData studentPageData = new PageData();
					studentPageData.put("STUDENTTEST_ID", get32UUID());
					studentPageData.put("STUDENT_ID", studentDetail.get("ID"));
					studentPageData.put("TEST_ID", paper.get("TESTPAPER_ID"));
					studentPageData.put("PAPER_ID", paper.get("TESTPAPER_ID"));
					studentPageData.put("SCORE", student.get("SCORE"));
					studentPageData.put("CLASS_ID", paper.get("SCLASS_ID"));
					logger.info("学生测试数据");
					logger.info(studentPageData);
					try {
						studenttestService.save(studentPageData);
					} catch (Exception e) {
						e.printStackTrace();
					}
					logger.info("添加学生测试成功：" +  studentDetail.get("NAME"));

					String answerStr = student.getString("answerStr");
					String[] answerStrs = answerStr.split(";");
					int j = 0;
					for (String answers : answerStrs) {
						j++;
						PageData testInfoPd = new PageData();
						testInfoPd.put("TESTPAPERINFO_ID", this.get32UUID());
						testInfoPd.put("PAPER_ID", paper.get("TESTPAPER_ID"));
						testInfoPd.put("STUDENT_ID", studentDetail.get("ID"));
						testInfoPd.put("TEST_ID", paper.get("TESTPAPER_ID"));
						testInfoPd.put("QUESTION_ID", paper.get("TESTPAPER_ID") + "" + i);
						String[] ans = answers.split(",");
						testInfoPd.put("ANSWER", ans[0]);
						testInfoPd.put("RIGHT", ans[1]);
						testInfoPd.put("SCORE", "");
						testInfoPd.put("LIKES", "");
						testInfoPd.put("ANSWER_TYPE", "1");
						testInfoPd.put("PRESS_TIME", "");
						testInfoPd.put("RECEIVER_DATE", "");
						testInfoPd.put("SUBJECTIVE", "");
						testInfoPd.put("MARK_NO", "" + j);
						testInfoPd.put("RANDOM", "" + j);
						testInfoPd.put("RANK", "" + j);
						try {
							logger.info("学生详细测试数据");
							logger.info(testInfoPd);
							testpaperinfoService.save(testInfoPd);
							logger.info("添加学生详细情况成功：");
						} catch (Exception e) {
							// TODO Auto-generated catch block
							e.printStackTrace();
						}
//						testInfoPdList.add(testInfoPd);
					}
//					logger.info("学生详细测试数据");
//					logger.info(testInfoPdList);
					try {
//						testpaperinfoService.batchSave(testInfoPdList);
					} catch (Exception e) {
						e.printStackTrace();
					}
//					logger.info("添加学生详细情况成功：");
				}
			}
		}
		
		ResponseGson<String> res = new ResponseGson<String>();
		return res.toJson();
	}

}