src/com/fh/controller/api/V1.java

package com.fh.controller.api;
import java.util.ArrayList;
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.ResponseBody;
import com.fh.bean.Paper;
import com.fh.bean.Point;
import com.fh.bean.Question;
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.entity.Page;
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.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.system.user.UserManager;
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 = "studentService")
	private StudentManager studentService;
	@Resource(name = "subjectService")
	private SubjectManager subjectService;
	@Resource(name = "teacherService")
	private TeacherManager teacherService;
	@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 = "cacheService")
	private CacheManager cacheService;
	/**
	 * 登录
	 * 可以通过账号密码登录、
	 * 可以通过教师卡登录
	 * @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 pageData = teacherService.getUserInfo(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();
			}
		} 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 = "/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") && pd.containsKey("USER_ID")) {
			Page page = new Page();
			page.getPd().put("PAPER_TYPE", pd.get("PAPER_TYPE"));
			page.getPd().put("USER_ID", pd.get("USER_ID"));
			page.getPd().put("SUBJECT_ID", pd.get("SUBJECT_ID"));
			if (pd.containsKey("CURRENTPAGE")) {
				String curpage = pd.getString("CURRENTPAGE");
				try {
					page.setCurrentPage(Integer.parseInt(curpage));
				} catch (Exception ex) {
				}
			}
			if (pd.containsKey("SHOWCOUNT")) {
				String showCount = pd.getString("SHOWCOUNT");
				try {
					page.setShowCount(Integer.parseInt(showCount));
				} catch (Exception ex) {
				}
			} else {
				page.setShowCount(100);
			}
			List<PageData> pageList = paperService.listAllByType(page);
			res.setData(pageList);
		} else {
			res.setParmError();
		}
		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.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"));
							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.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 = "/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("paperInfo 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);
				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 {
		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 {
		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", schoolID);
			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("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()));
			int questionNum = 0;
			List<Question> questions = paper.getQuestions();
			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());
					paperquestionService.save(pqPd);
				}
			}
			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 = "/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());
				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());
				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("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("uploadtestpaper 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 {
		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();
	}
	/**
	 * 获取教材版本
	 * 
	 * @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");
		}
		List<PageData> list = questionService.listAllquestion(pd);
		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);
		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) {
			// TODO Auto-generated catch block
			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();
	}
}