src/com/fh/controller/sunvote/teacher/TeacherController.java

package com.fh.controller.sunvote.teacher;
import java.io.PrintWriter;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import javax.annotation.Resource;
import org.apache.shiro.crypto.hash.SimpleHash;
import org.springframework.beans.propertyeditors.CustomDateEditor;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.WebDataBinder;
import org.springframework.web.bind.annotation.InitBinder;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.multipart.MultipartFile;
import org.springframework.web.servlet.ModelAndView;
import com.fh.controller.api.ResponseGson;
import com.fh.controller.base.BaseController;
import com.fh.entity.Page;
import com.fh.service.api.V1Manager;
import com.fh.service.sunvote.coursemanagement.CourseManagementManager;
import com.fh.service.sunvote.school.SchoolManager;
import com.fh.service.sunvote.subject.SubjectManager;
import com.fh.service.sunvote.teacher.TeacherManager;
import com.fh.service.system.fhlog.FHlogManager;
import com.fh.service.system.user.UserManager;
import com.fh.util.AppUtil;
import com.fh.util.Const;
import com.fh.util.FileUpload;
import com.fh.util.Jurisdiction;
import com.fh.util.ObjectExcelRead;
import com.fh.util.ObjectExcelView;
import com.fh.util.PageData;
import com.fh.util.PathUtil;
import com.fh.util.Tools;
/**
 * 说明：教师 创建人：Elvis 创建时间：2018-04-26
 */
@Controller
@RequestMapping(value = "/teacher")
public class TeacherController extends BaseController {
	String menuUrl = "teacher/list.do"; // 菜单地址(权限用)
	@Resource(name = "teacherService")
	private TeacherManager teacherService;
	@Resource(name = "schoolService")
	private SchoolManager schoolService;
	@Resource(name = "userService")
	private UserManager userService;
	@Resource(name = "fhlogService")
	private FHlogManager FHLOG;
	
	@Resource(name = "v1Service")
	private V1Manager v1Service;
	@Resource(name="subjectService")
	private SubjectManager subjectService;
	
	@Resource(name="coursemanagementService")
	private CourseManagementManager coursemanagementService;
	
	/**
	 * 保存
	 * 
	 * @param
	 * @throws Exception
	 */
	@RequestMapping(value = "/save")
	public ModelAndView save() throws Exception {
		logBefore(logger, Jurisdiction.getUsername() + "新增Teacher");
		if (!Jurisdiction.buttonJurisdiction(menuUrl, "add")) {
			return null;
		} // 校验权限
		ModelAndView mv = this.getModelAndView();
		PageData pd = new PageData();
		pd = this.getPageData();
		pd.put("ID", this.get32UUID());
		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)) { // 判断用户名是否存在
			teacherService.save(pd);
			userService.saveU(pd); // 执行保存
			FHLOG.save(Jurisdiction.getUsername(),
					"新增系统用户：" + pd.getString("USERNAME"));
		}
		mv.addObject("msg", "success");
		mv.setViewName("save_result");
		return mv;
	}
	
	/**
	 * 保存
	 * 
	 * @param
	 * @throws Exception
	 */
	@RequestMapping(value = "/save2")
	public ModelAndView save2() throws Exception {
		ModelAndView mv = this.getModelAndView();
		PageData pd = new PageData();
		pd = this.getPageData();
		pd.put("ID", this.get32UUID());
		
		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)) { // 判断用户名是否存在
			teacherService.save(pd);
			userService.saveU(pd); // 执行保存
			mv.addObject("msg", "success");
			FHLOG.save(Jurisdiction.getUsername(),
					"新增系统用户：" + pd.getString("USERNAME"));
		}else{
			mv.addObject("msg", "用户名系统已存在。");
			
		}
		
	
		mv.setViewName("save_result2");
		return mv;
	}
	/**
	 * 删除
	 * 
	 * @param out
	 * @throws Exception
	 */
	@RequestMapping(value = "/delete")
	public void delete(PrintWriter out) throws Exception {
		logBefore(logger, Jurisdiction.getUsername() + "删除Teacher");
		if (!Jurisdiction.buttonJurisdiction(menuUrl, "del")) {
			return;
		} // 校验权限
		PageData pd = new PageData();
		pd = this.getPageData();                        
		pd.put("USER_ID", pd.get("ID"));
		teacherService.delete(pd);
		userService.deleteU(pd);
		out.write("success");
		out.close();
	}
	/**
	 * 修改
	 * 
	 * @param
	 * @throws Exception
	 */
	@RequestMapping(value = "/edit")
	public ModelAndView edit() throws Exception {
		logBefore(logger, Jurisdiction.getUsername() + "修改Teacher");
		if (!Jurisdiction.buttonJurisdiction(menuUrl, "edit")) {
			return null;
		} // 校验权限
		ModelAndView mv = this.getModelAndView();
		PageData pd = new PageData();
		pd = this.getPageData();
		teacherService.edit(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()); // 密码加密
		userService.editU(pd); // 执行保存
		mv.addObject("msg", "success");
		mv.setViewName("save_result");
		return mv;
	}
	
	/**
	 * 修改
	 * 
	 * @param
	 * @throws Exception
	 */
	@RequestMapping(value = "/edit2")
	public ModelAndView edit2() throws Exception {
		logBefore(logger, Jurisdiction.getUsername() + "修改Teacher");
		ModelAndView mv = this.getModelAndView();
		PageData pd = new PageData();
		pd = this.getPageData();
		PageData n = teacherService.findById(pd);
		PageData temp = new PageData();
		temp.put("TEACHER_ID",n.get("ID").toString());
		PageData p = coursemanagementService.findByTid(temp);
		pd.put("PASSWORD",
				new SimpleHash("SHA-1", n.getString("ACCOUT"), pd
						.getString("PASSWORD")).toString()); // 密码加密
		teacherService.edit(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", n.getString("ACCOUT"));
		pd.put("ROLE_ID", "57bb1e6f138247a0b05cc721a5da1b64");
		
		userService.editU(pd); // 执行保存
		p.put("SUBJECT_ID", pd.get("SUBJECT_IDS"));
		coursemanagementService.edit(p);
		mv.addObject("msg", "success");
		mv.setViewName("save_result2");
		return mv;
	}
	
	
	/**
	 * 修改
	 * 
	 * @param
	 * @throws Exception
	 */
	@RequestMapping(value = "/updatePassword", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public String updatePassword() throws Exception {
		PageData pd = new PageData();
		pd = this.getPageData();
		PageData n = teacherService.findById(pd);
		ResponseGson<String> ret = new ResponseGson<String>();
		String oldPass = new  SimpleHash("SHA-1", n.getString("ACCOUT"), pd.get("OLDPASSWORD")).toString(); 
		if(n.get("PASSWORD").equals(oldPass)){
			teacherService.edit(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", n.getString("ACCOUT"));
			pd.put("ROLE_ID", "57bb1e6f138247a0b05cc721a5da1b64");
			pd.put("PASSWORD",
					new SimpleHash("SHA-1", n.getString("ACCOUT"), pd
							.getString("PASSWORD")).toString()); // 密码加密
			userService.editU(pd); // 执行保存
			teacherService.edit(pd);
			ret.setData("Success");
		}else{
			ret.set5Error();
			ret.setData("Fail");
		}
		return ret.toJson();
	}
	/**
	 * 列表
	 * 
	 * @param page
	 * @throws Exception
	 */
	@RequestMapping(value = "/teach_paper")
	public ModelAndView teach_paper(Page page) throws Exception {
		logBefore(logger, Jurisdiction.getUsername() + "列表Paper");
		String userId = this.getUserID();
		ModelAndView mv = this.getModelAndView();
		PageData pd = new PageData();
		pd = this.getPageData();
		if(isChineseLanguageClient()){
			mv.setViewName("sunvote/teacher/teach_paper");
		}else{
			mv.setViewName("sunvote/teacher/en_teach_paper");
		}
		pd.put("userId", userId);
		mv.addObject("pd", pd);
		return mv;
	}
	
	/**
	 * 列表
	 * 
	 * @param page
	 * @throws Exception
	 */
	@RequestMapping(value = "/teach_paper1")
	public ModelAndView teach_paper1(Page page) throws Exception {
		logBefore(logger, Jurisdiction.getUsername() + "列表Paper");
		String userId = this.getUserID();
		ModelAndView mv = this.getModelAndView();
		PageData pd = new PageData();
		pd = this.getPageData();
		mv.setViewName("sunvote/teacher/teach_paper1");
		pd.put("userId", userId);
		mv.addObject("pd", pd);
		return mv;
	}
	/**
	 * 列表
	 * 
	 * @param page
	 * @throws Exception
	 */
	@RequestMapping(value = "/test_list")
	public ModelAndView test_list(Page page) throws Exception {
		logBefore(logger, Jurisdiction.getUsername() + "列表Paper");
		String userId = this.getUserID();
		ModelAndView mv = this.getModelAndView();
		PageData pd = new PageData();
		pd = this.getPageData();
		pd.put("userId", userId);
		if(isChineseLanguageClient()){
			mv.setViewName("sunvote/teacher/test_list");
		}else{
			mv.setViewName("sunvote/teacher/en_test_list");
		}
		mv.addObject("pd", pd);
		return mv;
	}
	
	/**
	 * 列表
	 * 
	 * @param page
	 * @throws Exception
	 */
	@RequestMapping(value = "/paper_view")
	public ModelAndView paper_view(Page page) throws Exception {
		logBefore(logger, Jurisdiction.getUsername() + "列表Paper");
		String userId = this.getUserID();
		ModelAndView mv = this.getModelAndView();
		PageData pd = new PageData();
		pd = this.getPageData();
		pd.put("userId", userId);
		pd.put("ID", getTeacherID());
		PageData pageData = teacherService.findById(pd);
		pd.put("subject_id",  pageData.get("SUBJECT_IDS"));
		if(isChineseLanguageClient()){
			mv.setViewName("sunvote/teacher/paper_view");
		}else{
			mv.setViewName("sunvote/teacher/en_paper_view");
		}
		mv.addObject("pd", pd);
		return mv;
	}
	
	private String getSubjectID(String userId) {
		PageData pt = new PageData();
		pt.put("TEACHER_ID", userId);
		try {
			List<PageData> subjectList = v1Service.getTeacherSubjectInfo(pt);
			if (subjectList != null && subjectList.size() > 0) {
				return subjectList.get(0).getString("SUBJECT_ID");
			}
		}catch(Exception ex){}
		return null;
	}
	/**
	 * 列表
	 * 
	 * @param page
	 * @throws Exception
	 */
	@RequestMapping(value = "/paper_view2")
	public ModelAndView paper_view2(Page page) throws Exception {
		logBefore(logger, Jurisdiction.getUsername() + "列表Paper");
		String userId = this.getUserID();
		ModelAndView mv = this.getModelAndView();
		PageData pd = new PageData();
		pd = this.getPageData();
		pd.put("userId", userId);
		if(isChineseLanguageClient()){
			mv.setViewName("sunvote/teacher/paper_view2");
		}else{
			mv.setViewName("sunvote/teacher/en_paper_view2");
		}
		mv.addObject("pd", pd);
		return mv;
	}
	
	/**
	 * 列表
	 * 
	 * @param page
	 * @throws Exception
	 */
	@RequestMapping(value = "/paper_view1")
	public ModelAndView paper_view1(Page page) throws Exception {
		logBefore(logger, Jurisdiction.getUsername() + "列表Paper");
		String userId = this.getUserID();
		ModelAndView mv = this.getModelAndView();
		PageData pd = new PageData();
		pd = this.getPageData();
		pd.put("userId", userId);
		if(isChineseLanguageClient()){
			mv.setViewName("sunvote/teacher/paper_view1");
		}else{
			mv.setViewName("sunvote/teacher/en_paper_view1");
		}
		
		mv.addObject("pd", pd);
		return mv;
	}
	
	/**
	 * 列表
	 * 
	 * @param page
	 * @throws Exception
	 */
	@RequestMapping(value = "/classansync")
	public ModelAndView classansync(Page page) throws Exception {
		logBefore(logger, Jurisdiction.getUsername() + "列表Paper");
		String userId = this.getUserID();
		ModelAndView mv = this.getModelAndView();
		PageData pd = new PageData();
		pd = this.getPageData();
		pd.put("userId", userId);
		if(pd.get("TEST_ID") == null){
			pd.put("TEST_ID", pd.get("TESTPAPERID"));
		}
		List<PageData> diffcultClassList = teacherService.diffcultClassReport(pd);
		for(PageData diffcultPd : diffcultClassList){
			double rightNum = Double.parseDouble(diffcultPd.getString("RIGHT_NUM"));
			double allNum = Double.parseDouble(diffcultPd.getString("ALL_NUM"));
			double persent = rightNum * 100.0 / allNum ;
			diffcultPd.put("RIGHT_PERSENT", String.format("%.2f", persent));
		}
		
		List<PageData> diffcultStudentList = teacherService.diffcultStudentReport(pd);
		for(PageData diffcultPd : diffcultStudentList){
			double rightNum = Double.parseDouble(diffcultPd.getString("RIGHT_NUM"));
			double allNum = Double.parseDouble(diffcultPd.getString("ALL_NUM"));
			double persent = rightNum * 100.0 / allNum ;
			diffcultPd.put("RIGHT_PERSENT", String.format("%.2f", persent));
		}
		
		List<PageData> knowadgeClassList = teacherService.knowadgeClassReport(pd);
		for(PageData diffcultPd : knowadgeClassList){
			double rightNum = Double.parseDouble(diffcultPd.getString("RIGHT_NUM"));
			double allNum = Double.parseDouble(diffcultPd.getString("ALL_NUM"));
			double persent = rightNum * 100.0 / allNum ;
			diffcultPd.put("RIGHT_PERSENT", String.format("%.2f", persent));
		}
		
		List<PageData> knowadgeStudentList = teacherService.knowadgeStudentReport(pd);
		for(PageData diffcultPd : knowadgeStudentList){
			double rightNum = Double.parseDouble(diffcultPd.getString("RIGHT_NUM"));
			double allNum = Double.parseDouble(diffcultPd.getString("ALL_NUM"));
			double persent = rightNum * 100.0 / allNum ;
			diffcultPd.put("RIGHT_PERSENT", String.format("%.2f", persent));
		}
		mv.addObject("diffcultClassList", diffcultClassList);
		mv.addObject("diffcultClassListSize", diffcultClassList.size());
		mv.addObject("diffcultStudentList", diffcultStudentList);
		mv.addObject("knowadgeClassList", knowadgeClassList);
		mv.addObject("knowadgeClassListSize", knowadgeClassList.size());
		mv.addObject("knowadgeStudentList", knowadgeStudentList);
		
		mv.setViewName("sunvote/teacher/paper_report");
		mv.addObject("pd", pd);
		return mv;
	}
	
	
	
	/**
	 * 列表
	 * 
	 * @param page
	 * @throws Exception
	 */
	@RequestMapping(value = "/set_question")
	public ModelAndView set_question(Page page) throws Exception {
		logBefore(logger, Jurisdiction.getUsername() + "列表Paper");
		ModelAndView mv = this.getModelAndView();
		String userId = this.getUserID();
		PageData pd = new PageData();
		pd = this.getPageData();
		pd.put("userId", userId);
		if(isChineseLanguageClient()){
			mv.setViewName("sunvote/teacher/set_question");
		}else{
			mv.setViewName("sunvote/teacher/en_set_question");
		}
		mv.addObject("pd", pd);
		return mv;
	}
	/**
	 * 列表
	 * 
	 * @param page
	 * @throws Exception
	 */
	@RequestMapping(value = "/list")
	public ModelAndView list(Page page) throws Exception {
		logBefore(logger, Jurisdiction.getUsername() + "列表Teacher");
		// if(!Jurisdiction.buttonJurisdiction(menuUrl, "cha")){return null;}
		// //校验权限(无权查看时页面会有提示,如果不注释掉这句代码就无法进入列表页面,所以根据情况是否加入本句代码)
		ModelAndView mv = this.getModelAndView();
		PageData pd = new PageData();
		pd = this.getPageData();
		String keywords = pd.getString("keywords"); // 关键词检索条件
		if (null != keywords && !"".equals(keywords)) {
			pd.put("keywords", keywords.trim());
		}
		page.setPd(pd);
		List<PageData> varList = teacherService.list(page); // 列出Teacher列表
		mv.setViewName("sunvote/teacher/teacher_list");
		mv.addObject("varList", varList);
		List<PageData> schools = schoolService.listAll(pd);
		mv.addObject("schools", schools);
		mv.addObject("pd", pd);
		mv.addObject("QX", Jurisdiction.getHC()); // 按钮权限
		return mv;
	}
	
	/**
	 * 列表
	 * 
	 * @param page
	 * @throws Exception
	 */
	@RequestMapping(value = "/listcs")
	public ModelAndView listcs(Page page) throws Exception {
		logBefore(logger, Jurisdiction.getUsername() + "列表Teacher");
		ModelAndView mv = this.getModelAndView();
		PageData pd = new PageData();
		pd = this.getPageData();
		page.setPd(pd);
		page.setLangIsChina(isChineseLanguageClient());
		List<PageData> varList = teacherService.list(page); // 列出Teacher列表
		if(isChineseLanguageClient()){
			mv.setViewName("sunvote/teacher/teacher_list2");
		}else{
			mv.setViewName("sunvote/teacher/en_teacher_list2");
		}
		
		mv.addObject("varList", varList);
		
		mv.addObject("pd", pd);
		return mv;
	}
	
	/**
	 * 列表
	 * 
	 * @param page
	 * @throws Exception
	 */
	@RequestMapping(value = "/index")
	public ModelAndView index() throws Exception {
		logBefore(logger, Jurisdiction.getUsername() + "列表Teacher");
		// if(!Jurisdiction.buttonJurisdiction(menuUrl, "cha")){return null;}
		// //校验权限(无权查看时页面会有提示,如果不注释掉这句代码就无法进入列表页面,所以根据情况是否加入本句代码)
		ModelAndView mv = this.getModelAndView();
		mv.setViewName("sunvote/teacher/indexPage");
		mv.addObject("pd", this.getPageData());
		return mv;
	}
	/**
	 * 去新增页面
	 * 
	 * @param
	 * @throws Exception
	 */
	@RequestMapping(value = "/goAdd")
	public ModelAndView goAdd() throws Exception {
		ModelAndView mv = this.getModelAndView();
		PageData pd = new PageData();
		pd = this.getPageData();
		mv.setViewName("sunvote/teacher/teacher_edit");
		List<PageData> schools = schoolService.listAll(pd);
		mv.addObject("schools", schools);
		mv.addObject("msg", "save");
		mv.addObject("pd", pd);
		return mv;
	}
	
	@RequestMapping(value = "/goAdd2")
	public ModelAndView goAdd2() throws Exception {
		ModelAndView mv = this.getModelAndView();
		PageData pd = new PageData();
		pd = this.getPageData();
		if(isChineseLanguageClient()){
			mv.setViewName("sunvote/teacher/teacher_edit2");
		}else{
			mv.setViewName("sunvote/teacher/en_teacher_edit2");
		}
		
		
		List<PageData> schools = schoolService.listAll(pd);
		mv.addObject("schools", schools);
		
		List<PageData> subjects = subjectService.listAllSchool(pd);
		mv.addObject("subjects", subjects);
		
		
		
		mv.addObject("msg", "save2");
		mv.addObject("pd", pd);
		return mv;
	}
	/**
	 * 去修改页面
	 * 
	 * @param
	 * @throws Exception
	 */
	@RequestMapping(value = "/goEdit")
	public ModelAndView goEdit() throws Exception {
		ModelAndView mv = this.getModelAndView();
		PageData pd = new PageData();
		pd = this.getPageData();
		pd = teacherService.findById(pd); // 根据ID读取
		mv.setViewName("sunvote/teacher/teacher_edit");
		List<PageData> schools = schoolService.listAll(pd);
		mv.addObject("schools", schools);
		mv.addObject("msg", "edit");
		mv.addObject("pd", pd);
		return mv;
	}
	
	/**
	 * 去修改页面
	 * 
	 * @param
	 * @throws Exception
	 */
	@RequestMapping(value = "/goEdit2")
	public ModelAndView goEdit2() throws Exception {
		ModelAndView mv = this.getModelAndView();
		PageData pd = new PageData();
		pd = this.getPageData();
		pd = teacherService.findById(pd); // 根据ID读取
		if(isChineseLanguageClient()){
			mv.setViewName("sunvote/teacher/teacher_edit2");
		}else{
			mv.setViewName("sunvote/teacher/en_teacher_edit2");
		}
		List<PageData> schools = schoolService.listAll(pd);
		mv.addObject("schools", schools);
		List<PageData> subjects = subjectService.listAllSchool(pd);
		mv.addObject("subjects", subjects);
		mv.addObject("msg", "edit2");
		mv.addObject("pd", pd);
		return mv;
	}
	
	/**
	 * 去修改页面
	 * 
	 * @param
	 * @throws Exception
	 */
	@RequestMapping(value = "/goEdit3")
	public ModelAndView goEdit3() throws Exception {
		ModelAndView mv = this.getModelAndView();
		PageData pd = new PageData();
		pd = this.getPageData();
		pd.put("ID", pd.get("TEACHER_ID"));
		pd = teacherService.findById(pd); // 根据ID读取
		pd.put("PASSWORD", "");
		mv.setViewName("sunvote/teacher/teacher_edit3");
		List<PageData> schools = schoolService.listAll(pd);
		mv.addObject("schools", schools);
		List<PageData> subjects = subjectService.listAllSchool(pd);
		mv.addObject("subjects", subjects);
		mv.addObject("msg", "edit2");
		mv.addObject("pd", pd);
		return mv;
	}
	/**
	 * 批量删除
	 * 
	 * @param
	 * @throws Exception
	 */
	@RequestMapping(value = "/deleteAll")
	@ResponseBody
	public Object deleteAll() throws Exception {
		logBefore(logger, Jurisdiction.getUsername() + "批量删除Teacher");
		PageData pd = new PageData();
		Map<String, Object> map = new HashMap<String, Object>();
		pd = this.getPageData();
		List<PageData> pdList = new ArrayList<PageData>();
		String DATA_IDS = pd.getString("DATA_IDS");
		if (null != DATA_IDS && !"".equals(DATA_IDS)) {
			String ArrayDATA_IDS[] = DATA_IDS.split(",");
			teacherService.deleteAll(ArrayDATA_IDS);
			userService.deleteAllU(ArrayDATA_IDS);
			pd.put("msg", "ok");
		} else {
			pd.put("msg", "no");
		}
		pdList.add(pd);
		map.put("list", pdList);
		return AppUtil.returnObject(pd, map);
	}
	
	/**打开上传EXCEL页面
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value="/goUploadExcel")
	public ModelAndView goUploadExcel()throws Exception{
		ModelAndView mv = this.getModelAndView();
		mv.addObject("pd", getPageData());
		
		if(isChineseLanguageClient()){
			mv.setViewName("sunvote/teacher/uploadexcel");
		}else{
			mv.setViewName("sunvote/teacher/en_uploadexcel");
		}
		return mv;
	}
	/**从EXCEL导入到数据库
	 * @param file
	 * @return
	 * @throws Exception
	 */
	@RequestMapping(value="/readExcel")
	public ModelAndView readExcel(
			@RequestParam(value="excel",required=false) MultipartFile file
			) throws Exception{
		logBefore(logger,Jurisdiction.getUsername() + "从EXCEL导入到数据库");
		ModelAndView mv = this.getModelAndView();
		PageData tpd = getPageData();
		PageData pd = new PageData();
		
		String schoolID = tpd.getString("SCHOOL_ID");
		if (null != file && !file.isEmpty()) {
			String filePath = PathUtil.getClasspath() + Const.FILEPATHFILE;								//文件上传路径
			String fileName =  FileUpload.fileUp(file, filePath, "userexcel");							//执行上传
			List<PageData> listPd = (List)ObjectExcelRead.readExcel(filePath, fileName, 0, 0, 0);		//执行读EXCEL操作,读出的数据导入List 2:从第3行开始；0:从第A列开始；0:第0个sheet
			if(listPd.size() > 0 ){
				pd= listPd.get(0);
				for(int i = 1 ; i < listPd.size();i++){
					PageData savePd = new PageData();
					PageData temp = listPd.get(i);
					for(int j = 0 ; ;j++){
						if(temp.get("var" + j) == null){
							break ;
						}
						if(temp.get("var" + j) != null && !"".equals(temp.get("var" + j).toString())){
							savePd.put(pd.getString("var" + j).toUpperCase(), temp.get("var" + j));
						}
						
					}
					PageData page = subjectService.findByCname(savePd);
					if(page!=null){
						savePd.put("SUBJECT_IDS", page.get("ID"));
					}else{
						savePd.put("SUBJECT_IDS", "");
					}
					if(!savePd.containsKey("ID")){
						if (savePd.values().size() > 0) {
							String teacherId = this.get32UUID();
							savePd.put("ID", teacherId);
							savePd.put("SCHOOL_ID", schoolID);
							
							PageData p = new PageData();
							p.put("USERNAME", savePd.getString("ACCOUT"));
							
							if(null==userService.findByUsername(p)){
								p.put("USER_ID", savePd.get("ID"));
								p.put("ROLE_ID", "57bb1e6f138247a0b05cc721a5da1b64");
								p.put("PASSWORD",
										new SimpleHash("SHA-1", savePd.getString("ACCOUT"), savePd
												.getString("PASSWORD")).toString()); // 密码加密
								p.put("LAST_LOGIN", ""); // 最后登录时间
								p.put("IP", ""); // IP
								p.put("STATUS", "0"); // 状态
								p.put("SKIN", "default");
								p.put("RIGHTS", "");
								p.put("NAME",savePd.getString("NAME") );
								
								userService.saveU(p);
								FHLOG.save(Jurisdiction.getUsername(),
										"新增系统用户：" + pd.getString("USERNAME"));
							}else{
								mv.addObject("state","fail");
								mv.addObject("msg","本次成功导入"+(i-1>=0?i-1:0)+"条数据，第"+i+"行用户名系统已存在。");
								mv.setViewName("save_result2");
								return mv;
							}
							
							
							
							teacherService.save(savePd);
						}
						
					}else{
						teacherService.edit(savePd);
					}
				}
				
			}
		}
		mv.addObject("msg","success");
		mv.setViewName("save_result2");
		return mv;
	}
	
	/**
	 * 导出到excel
	 * 
	 * @param
	 * @throws Exception
	 */
	@RequestMapping(value = "/excel")
	public ModelAndView exportExcel() throws Exception {
		logBefore(logger, Jurisdiction.getUsername() + "导出Teacher到excel");
		ModelAndView mv = new ModelAndView();
		PageData pd = new PageData();
		pd = this.getPageData();
		Map<String, Object> dataMap = new HashMap<String, Object>();
		List<String> titles = new ArrayList<String>();
		titles.add("所在学校"); // 1
		titles.add("姓名"); // 2
		titles.add("电话"); // 3
		titles.add("座机电话"); // 4
		titles.add("证件号"); // 5
		titles.add("账号"); // 6
		titles.add("密码"); // 7
		titles.add("性别"); // 8
		titles.add("科目列表"); // 9
		titles.add("教师卡编号"); // 10
		dataMap.put("titles", titles);
		List<PageData> varOList = teacherService.listAll(pd);
		List<PageData> varList = new ArrayList<PageData>();
		for (int i = 0; i < varOList.size(); i++) {
			PageData vpd = new PageData();
			vpd.put("var1", varOList.get(i).get("SCHOOL_NAME").toString()); // 1
			vpd.put("var2", varOList.get(i).getString("NAME")==null?"":varOList.get(i).getString("NAME")); // 2
			vpd.put("var3", varOList.get(i).getString("PHONE")==null?"":varOList.get(i).getString("PHONE")); // 3
			vpd.put("var4", varOList.get(i).getString("SEAT_PHONE")==null?"":varOList.get(i).getString("SEAT_PHONE")); // 4
			vpd.put("var5", varOList.get(i).getString("CARD_NO")==null?"":varOList.get(i).getString("CARD_NO")); // 5
			vpd.put("var6", varOList.get(i).getString("ACCOUT")==null?"":varOList.get(i).getString("ACCOUT")); // 6
			vpd.put("var7", varOList.get(i).getString("PASSWORD")==null?"":varOList.get(i).getString("PASSWORD")); // 7
			vpd.put("var8", varOList.get(i).get("SEX")==null?"":varOList.get(i).get("SEX").toString().equals("1")?"男":"女"); // 8
			vpd.put("var9", varOList.get(i).getString("CNAME")==null?"":varOList.get(i).getString("CNAME")); // 9
			vpd.put("var10", varOList.get(i).getString("KEYPAD_ID")==null?"":varOList.get(i).getString("KEYPAD_ID")); // 10
			varList.add(vpd);
		}
		dataMap.put("varList", varList);
		ObjectExcelView erv = new ObjectExcelView();
		mv = new ModelAndView(erv, dataMap);
		return mv;
	}
	@InitBinder
	public void initBinder(WebDataBinder binder) {
		DateFormat format = new SimpleDateFormat("yyyy-MM-dd");
		binder.registerCustomEditor(Date.class, new CustomDateEditor(format,
				true));
	}
	/**
	 * 批量删除
	 * 
	 * @param
	 * @throws Exception
	 */
	@RequestMapping(value = "/info", produces = "application/json;charset=UTF-8")
	@ResponseBody
	public Object info() throws Exception {
		PageData pd = this.getPageData();
		ResponseGson<PageData> res = new ResponseGson();
		pd.put("ID", this.getTeacherID());
		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);
			pt.put("ID", pageData.get("SUBJECT_IDS"));
			
			pageData.put("classInfoList", classInfoList);
			// 在认可表中查找老师教哪些科目，然后查出科目信息
			List<PageData> subjectList = new ArrayList<PageData>();
			PageData tmpd = subjectService.findById(pt);
			if(tmpd != null){
				tmpd.put("SUBJECT_ID", tmpd.get("ID"));
			}
			subjectList.add(tmpd);
//					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");
			}
			res.setData(pageData);
			// 填充数据到返回数据中
		} else {
			res.set1Error();
		}
		
		return res.toJson();
	}
	
	
}