meidu2021/daju/src-xcgl/main/java/com/xcgl/weeklyschedule/controller/WeeklyScheduleController.java

package com.xcgl.weeklyschedule.controller;

import java.io.IOException;
import java.math.BigDecimal;
import java.net.URI;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Collections;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Locale;
import java.util.Map;
import java.util.Set;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.validation.ConstraintViolation;
import javax.validation.Validator;

import org.apache.log4j.Logger;
import org.jeecgframework.core.beanvalidator.BeanValidators;
import org.jeecgframework.core.common.controller.BaseController;
import org.jeecgframework.core.common.exception.BusinessException;
import org.jeecgframework.core.common.hibernate.qbc.CriteriaQuery;
import org.jeecgframework.core.common.model.json.AjaxJson;
import org.jeecgframework.core.common.model.json.DataGrid;
import org.jeecgframework.core.constant.Globals;
import org.jeecgframework.core.util.DateUtils;
import org.jeecgframework.core.util.ExceptionUtil;
import org.jeecgframework.core.util.JeecgDataAutorUtils;
import org.jeecgframework.core.util.MyBeanUtils;
import org.jeecgframework.core.util.ResourceUtil;
import org.jeecgframework.core.util.StringUtil;
import org.jeecgframework.minidao.pojo.MiniDaoPage;
import org.jeecgframework.p3.core.utils.common.StringUtils;
import org.jeecgframework.poi.excel.ExcelImportUtil;
import org.jeecgframework.poi.excel.entity.ExportParams;
import org.jeecgframework.poi.excel.entity.ImportParams;
import org.jeecgframework.poi.excel.entity.vo.NormalExcelConstants;
import org.jeecgframework.tag.core.easyui.TagUtil;
import org.jeecgframework.web.system.pojo.base.TSUser;
import org.jeecgframework.web.system.service.SystemService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.http.HttpHeaders;
import org.springframework.http.HttpStatus;
import org.springframework.http.MediaType;
import org.springframework.http.ResponseEntity;
import org.springframework.stereotype.Controller;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.bind.annotation.ResponseStatus;
import org.springframework.web.multipart.MultipartFile;
import org.springframework.web.multipart.MultipartHttpServletRequest;
import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.util.UriComponentsBuilder;

import com.xcgl.projecttask.entity.ProjecttaskEntity;
import com.xcgl.reports.dao.XcglRptDao;
import com.xcgl.utils.XcglConstant;
import com.xcgl.utils.XcglDateUtils;
import com.xcgl.weeklyschedule.dao.WeeklyScheduleMiniDao;
import com.xcgl.weeklyschedule.entity.WeeklyScheduleDayDto;
import com.xcgl.weeklyschedule.entity.WeeklySchedulePartiEntity;
import com.xcgl.weeklyschedule.entity.WeeklyScheduleUtils;
import com.xcgl.weeklyschedule.entity.WeeklyscheduleEntity;
import com.xcgl.weeklyschedule.service.WeeklyScheduleServiceI;
import com.xcgl.weixin.dao.WXDao;
import com.xcgl.weixin.entity.WXMultiRowViewer;
import com.xcgl.weixin.entity.WXMultiRowViewerDto;
import com.xcgl.weixin.service.WXServiceI;
import com.xcgl.weixin.utils.WXViewerUtils;

import cn.com.lzt.arrangedutyoperate.dto.UserAndUserPersonnelDto;



@Controller
@RequestMapping(value = "/weeklyscheduleController")
public class WeeklyScheduleController extends BaseController {
	private static final Logger logger = Logger.getLogger(WeeklyScheduleController.class);
	@Autowired
	WeeklyScheduleServiceI weeklyscheduleService ;
	
	@Autowired
	private SystemService systemService;
	@Autowired
	private Validator validator;
	@Autowired
	WXDao wxdao;
	@Autowired
	private WeeklyScheduleMiniDao weeklyScheduleMiniDao;
	@Autowired
	WXServiceI wxservice;
	@Autowired
	private XcglRptDao rptDao;

	/**
	 * 工作周报列表 页面跳转
	 * 
	 * @return
	 */
	@RequestMapping(params = "list")
	public ModelAndView list(HttpServletRequest request) {
		return new ModelAndView("com/xcgl/weeklyschedule/weeklyscheduleList");
	}
	
	@RequestMapping(params = "todayScheduledList")
	public ModelAndView dayScheduledList(HttpServletRequest request) {
		String date = request.getParameter("date");
		SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
		SimpleDateFormat sdf2 = new SimpleDateFormat("yyyy-MM-dd EEEE",Locale.CHINA);
		Date today = null;
		try {
			today = sdf.parse(date);
		} catch (ParseException e) {
			org.jeecgframework.core.util.LogUtil.error(e.getMessage());
		}
		request.setAttribute("date", date);
		request.setAttribute("title", sdf2.format(today)+" 工作安排");
		request.setAttribute("htmlurl", "weeklyscheduleController.do?dayScheduledHtml&date="+date);
		return new ModelAndView("cn/com/lzt/wxviewer/wxMultirowViewer");
	}
	
	@RequestMapping(params = "dayScheduledHtml")
	@ResponseBody
	public AjaxJson dayScheduledHtml(HttpServletRequest request, HttpServletResponse response, String date) {
		date = request.getParameter("date");
		String message = null;
		AjaxJson j = new AjaxJson();
		String html= "";
		try {
			html = getDaySchelduledHtml(date);
		} catch (Exception e) {
			org.jeecgframework.core.util.LogUtil.error(e.getMessage());
			e.printStackTrace();
		}
		j.setObj(html);
		j.setMsg(message);
		return j;
	}

	/**
	 * @param date
	 * @return
	 * @throws Exception 
	 * @throws ParseException 
	 */
	private String getDaySchelduledHtml(String date) throws Exception {
		SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
		List<WeeklyScheduleDayDto> dblist = weeklyscheduleService.getWeeklyScheduleDtosBySomeDate(sdf.parse(date));
		Collections.sort(dblist);
		List<WXMultiRowViewerDto> showlist = new ArrayList<WXMultiRowViewerDto>();
		for(WeeklyScheduleDayDto dbdto : dblist) {
			if(dbdto.getWhatAmZjl() != null && dbdto.getWhatAmZjl().length()>0) {
				WXMultiRowViewerDto damzjl = new WXMultiRowViewerDto();
				String userid = dbdto.getUserid();
				TSUser user = systemService.get(TSUser.class, userid);
//				damzjl.setDivTitle(user.getRealName()+" 上午");
				damzjl.setMainContent(""+user.getRealName()+": " + dbdto.getWhatAmZjl()+"【闵总安排】");
				damzjl.setSecondContent(dbdto.getWhereAm() == null ? "地点：无" : "地点："+dbdto.getWhereAm());
				damzjl.setThirdContent(dbdto.getWhoNamesAm() == null ? "参与人：无" : "参与人："+dbdto.getWhoNamesAm());
				damzjl.setRightTag("上午");
				showlist.add(damzjl);
			}
			if(dbdto.getWhatAm() != null && dbdto.getWhatAm().length()>0) {
				WXMultiRowViewerDto dam = new WXMultiRowViewerDto();
				String userid = dbdto.getUserid();
				TSUser user = systemService.get(TSUser.class, userid);
//				dam.setDivTitle(user.getRealName()+" 上午");
				dam.setMainContent(""+user.getRealName()+": " + dbdto.getWhatAm());
				dam.setSecondContent(dbdto.getWhereAm() == null ?  "地点：无" : "地点："+dbdto.getWhereAm());
				dam.setThirdContent(dbdto.getWhoNamesAm() == null ?"参与人：无" : "参与人："+ dbdto.getWhoNamesAm());
				dam.setRightTag("上午");
				showlist.add(dam);
			}
			if(dbdto.getWhatPmZjl() != null && dbdto.getWhatPmZjl().length()>0) {
				WXMultiRowViewerDto dpmzjl = new WXMultiRowViewerDto();
				String userid = dbdto.getUserid();
				TSUser user = systemService.get(TSUser.class, userid);
//				dpmzjl.setDivTitle(user.getRealName()+" 下午");
				dpmzjl.setMainContent(""+user.getRealName()+": "+dbdto.getWhatPmZjl()+"【闵总安排】");
				dpmzjl.setSecondContent(dbdto.getWherePm()== null ?  "地点：无" : "地点："+dbdto.getWherePm());
				dpmzjl.setThirdContent(dbdto.getWhoNamesPm()== null ? "参与人：无" : "参与人："+dbdto.getWhoNamesPm());
				dpmzjl.setRightTag("下午");
				showlist.add(dpmzjl);
			}
			if(dbdto.getWhatPm() != null && dbdto.getWhatPm().length()>0) {
				WXMultiRowViewerDto dpm = new WXMultiRowViewerDto();
				String userid = dbdto.getUserid();
				TSUser user = systemService.get(TSUser.class, userid);
//				dpm.setDivTitle(user.getRealName()+" 下午");
				dpm.setMainContent(""+user.getRealName()+": "+dbdto.getWhatPm());
				dpm.setSecondContent(dbdto.getWherePm()== null ?  "地点：无" : "地点："+dbdto.getWherePm());
				dpm.setThirdContent(dbdto.getWhoNamesPm()== null ? "参与人：无" : "参与人："+dbdto.getWhoNamesPm());
				dpm.setRightTag("下午");
				showlist.add(dpm);
			}
		}
		WXMultiRowViewer viewer = new WXMultiRowViewer();
		viewer.setRows(showlist);
		viewer.setTitle(date);
		viewer.setWarning(getNoSchedulePersons(date));
		return WXViewerUtils.getWXMultiRowViewerHtml(viewer);

	}
	

	/**
	 * @param date
	 * @return
	 * @throws Exception 
	 */
	private String getNoSchedulePersons(String date) throws Exception {
		SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
		List<Map<String,Object>> userList = new ArrayList<Map<String,Object>>();
		userList = wxdao.getUsersByRoleCode(XcglConstant.ROLE_ZHOUBAO);
		List<WeeklyscheduleEntity> entits = weeklyscheduleService.getWeeklyScheduleBySomeDate(sdf.parse(date));
		HashMap<String, WeeklyscheduleEntity> hm_user3schedule = new HashMap<>();
		if(entits != null && entits.size()>0) {
			StringBuffer sb = new StringBuffer();
			for(WeeklyscheduleEntity entity : entits) {
				String userid = entity.getUserid();
				hm_user3schedule.put(userid, entity);
			}
			for(Map<String,Object> user : userList) {
				if(!hm_user3schedule.containsKey(user.get("id"))){
					sb.append("【").append(user.get("realname")).append("】");
				}else {
					WeeklyscheduleEntity entity = hm_user3schedule.get(user.get("id"));
					if(entity == null) {
						sb.append("【").append(user.get("realname")).append("】");
					}else {
						String what = WeeklyScheduleUtils.getPersonalWhat(entity);
						if(what == null || what.length() == 0) {
							sb.append("【").append(user.get("realname")).append("】");
						}
					}
				}
			}
			if(sb.length()>0) {
				sb.append("未提交周报.");
			}
			return sb.toString();
		}
		return null;
	}

	@RequestMapping(params = "yesterdayWorkList")
	public ModelAndView yesterdayWorkList(HttpServletRequest request) {
		String date = request.getParameter("date");
		SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
		SimpleDateFormat sdf2 = new SimpleDateFormat("yyyy-MM-dd EEEE",Locale.CHINA);
		Date today = null;
		try {
			today = sdf.parse(date);
		} catch (ParseException e) {
			org.jeecgframework.core.util.LogUtil.error(e.getMessage());
		}
		Calendar cal = Calendar.getInstance();
		cal.setTime(today);
		cal.add(Calendar.DAY_OF_MONTH, -1);
		request.setAttribute("date", sdf.format(cal.getTime()));
		request.setAttribute("title", sdf2.format(cal.getTime())+" 完成情况");
		request.setAttribute("htmlurl", "weeklyscheduleController.do?yesterdayWorkHtml&date="+date);
		return new ModelAndView("cn/com/lzt/wxviewer/wxMultirowViewer");
	}
	
	@RequestMapping(params = "yesterdayWorkHtml")
	@ResponseBody
	public AjaxJson yesterdayWorkHtml(HttpServletRequest request, HttpServletResponse response, String date) {
		date = request.getParameter("date");
		String message = null;
		AjaxJson j = new AjaxJson();
		String html= "";
		try {
			html = getYestdayWorkAchievementsHtml(date);
		} catch (Exception e) {
			org.jeecgframework.core.util.LogUtil.error(e.getMessage());
			e.printStackTrace();
		}
		j.setObj(html);
		j.setMsg(message);
		return j;
	}
	
	/**
	 * @param date
	 * @return
	 * @throws Exception 
	 * @throws ParseException 
	 */
	private String getYestdayWorkAchievementsHtml(String date) throws Exception {
		SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
		Date today = sdf.parse(date);
		Calendar cal = Calendar.getInstance();
		cal.setTime(today);
		cal.add(Calendar.DAY_OF_MONTH, -1);
		List<WeeklyScheduleDayDto> dblist = weeklyscheduleService.getWeeklyScheduleDtosBySomeDate(cal.getTime());
		Collections.sort(dblist);
		List<WXMultiRowViewerDto> showlist = new ArrayList<WXMultiRowViewerDto>();
		String weeklyid = null;
		List<ProjecttaskEntity> tasks = new ArrayList<>();	
		HashMap<String, ProjecttaskEntity> taskMap = new HashMap<>();
		SimpleDateFormat sdftime = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
		// 去掉boss
		for(int i=dblist.size()-1 ; i>-1 ; i--) {
			WeeklyScheduleDayDto dto = dblist.get(i);
			if(Globals.BOSS_ID.equals(dto.getUserid())) {
				dblist.remove(i);
			}
		}
		for(WeeklyScheduleDayDto dbdto : dblist) {
			if(weeklyid == null) {
				weeklyid = dbdto.getId();
				String hql = "from ProjecttaskEntity where 1=1 and sourceid=? ";
				tasks = systemService.findHql(hql, weeklyid);
				for(ProjecttaskEntity task : tasks) {
					taskMap.put(sdftime.format(task.getPlanstarttime())+";"+task.getOwner(), task);
				}
			}
			
			ProjecttaskEntity taskEntityAm = taskMap.get(sdf.format(cal.getTime())+" 08:30:00;"+dbdto.getUserid());
			ProjecttaskEntity taskEntityPm = taskMap.get(sdf.format(cal.getTime())+" 13:30:00;"+dbdto.getUserid());
			
			if(dbdto.getWhatAmZjl() != null && dbdto.getWhatAmZjl().length()>0) {
				WXMultiRowViewerDto damzjl = new WXMultiRowViewerDto();
				String userid = dbdto.getUserid();
				TSUser user = systemService.get(TSUser.class, userid);
//				damzjl.setDivTitle(user.getRealName()+" 上午");
				damzjl.setMainContent(""+user.getRealName()+": "+dbdto.getWhatAmZjl()+"【闵总安排】");
				damzjl.setSecondContent(dbdto.getWhereAm() == null ? "地点：无" : "地点："+dbdto.getWhereAm());
				damzjl.setThirdContent(dbdto.getWhoNamesAm() == null ? "参与人：无" : "参与人："+dbdto.getWhoNamesAm());
				
				damzjl.setDeleteView(taskEntityAm != null && taskEntityAm.getTaskstatus() != null && XcglConstant.TASKSTATUS_DONE.equals(taskEntityAm.getTaskstatus()));
				if(damzjl.isDeleteView()) {
					damzjl.setRightTag("已完成");
				}else {
					damzjl.setRightTag("未完成");
				}
				showlist.add(damzjl);
			}
			if(dbdto.getWhatAm() != null && dbdto.getWhatAm().length()>0) {
				WXMultiRowViewerDto dam = new WXMultiRowViewerDto();
				String userid = dbdto.getUserid();
				TSUser user = systemService.get(TSUser.class, userid);
//				dam.setDivTitle(user.getRealName()+" 上午");
				dam.setMainContent(""+user.getRealName()+": "+dbdto.getWhatAm());
				dam.setSecondContent(dbdto.getWhereAm() == null ?  "地点：无" : "地点："+dbdto.getWhereAm());
				dam.setThirdContent(dbdto.getWhoNamesAm() == null ?"参与人：无" : "参与人："+ dbdto.getWhoNamesAm());
				
				dam.setDeleteView(taskEntityAm != null && taskEntityAm.getTaskstatus() != null && XcglConstant.TASKSTATUS_DONE.equals(taskEntityAm.getTaskstatus()));
				if(dam.isDeleteView()) {
					dam.setRightTag("已完成");
				}else {
					dam.setRightTag("未完成");
				}
				showlist.add(dam);
			}
			if(dbdto.getWhatPmZjl() != null && dbdto.getWhatPmZjl().length()>0) {
				WXMultiRowViewerDto dpmzjl = new WXMultiRowViewerDto();
				String userid = dbdto.getUserid();
				TSUser user = systemService.get(TSUser.class, userid);
//				dpmzjl.setDivTitle(user.getRealName()+" 下午");
				dpmzjl.setMainContent(""+user.getRealName()+": "+dbdto.getWhatPmZjl()+"【闵总安排】");
				dpmzjl.setSecondContent(dbdto.getWherePm()== null ?  "地点：无" : "地点："+dbdto.getWherePm());
				dpmzjl.setThirdContent(dbdto.getWhoNamesPm()== null ? "参与人：无" : "参与人："+dbdto.getWhoNamesPm());
				
				dpmzjl.setDeleteView(taskEntityPm != null && taskEntityPm.getTaskstatus() != null && XcglConstant.TASKSTATUS_DONE.equals(taskEntityPm.getTaskstatus()));
				if(dpmzjl.isDeleteView()) {
					dpmzjl.setRightTag("已完成");
				}else {
					dpmzjl.setRightTag("未完成");
				}
				showlist.add(dpmzjl);
			}
			if(dbdto.getWhatPm() != null && dbdto.getWhatPm().length()>0) {
				WXMultiRowViewerDto dpm = new WXMultiRowViewerDto();
				String userid = dbdto.getUserid();
				TSUser user = systemService.get(TSUser.class, userid);
//				dpm.setDivTitle(user.getRealName()+" 下午");
				dpm.setMainContent(""+user.getRealName()+": "+dbdto.getWhatPm());
				dpm.setSecondContent(dbdto.getWherePm()== null ?  "地点：无" : "地点："+dbdto.getWherePm());
				dpm.setThirdContent(dbdto.getWhoNamesPm()== null ? "参与人：无" : "参与人："+dbdto.getWhoNamesPm());
				
				dpm.setDeleteView(taskEntityPm != null && taskEntityPm.getTaskstatus() != null && XcglConstant.TASKSTATUS_DONE.equals(taskEntityPm.getTaskstatus()));
				if(dpm.isDeleteView()) {
					dpm.setRightTag("已完成");
				}else {
					dpm.setRightTag("未完成");
				}
				showlist.add(dpm);
			}
		}
	
		WXMultiRowViewer viewer = new WXMultiRowViewer();
		viewer.setRows(showlist);
		viewer.setTitle(date);
		viewer.setWarning(getNoSchedulePersons(date));
		return WXViewerUtils.getWXMultiRowViewerHtml(viewer);
	}

	@RequestMapping(params = "activitiOvertimeRpt")
	public ModelAndView activitiOvertimeRpt(HttpServletRequest request) {
		String date = request.getParameter("date");
		SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
		SimpleDateFormat sdf2 = new SimpleDateFormat("yyyy-MM-dd EEEE",Locale.CHINA);
		Date today = null;
		try {
			if(StringUtils.isEmpty(date))
				date = "2020-03-21";
			
			today = sdf.parse(date);
		} catch (ParseException e) {
			org.jeecgframework.core.util.LogUtil.error(e.getMessage());
		}
		Calendar cal = Calendar.getInstance();
		cal.setTime(today);
		cal.add(Calendar.DAY_OF_MONTH, -1);
		request.setAttribute("date", sdf.format(cal.getTime()));
		request.setAttribute("title", "签报逾期情况");
		request.setAttribute("htmlurl", "weeklyscheduleController.do?activitiOvertimeRptData&date="+date);
		request.setAttribute("defindedJS", "webpage/cn/com/lzt/contractreports/projectCostWarnRpt4ZJLDemo.js");
		return new ModelAndView("cn/com/lzt/wxviewer/wxMultirowViewer");
	}
	
	@RequestMapping(params = "activitiOvertimeRptData")
	@ResponseBody
	public AjaxJson activitiOvertimeRptData(HttpServletRequest request, HttpServletResponse response, String date) {
		date = request.getParameter("date");
		String message = null;
		AjaxJson j = new AjaxJson();
		String html= "";
		try {
			html = activitiOvertimeRptDataHtml();
		} catch (Exception e) {
			org.jeecgframework.core.util.LogUtil.error(e.getMessage());
			e.printStackTrace();
		}
		j.setObj(html);
		j.setMsg(message);
		return j;
	}
	private String activitiOvertimeRptDataHtml() throws Exception {
		List<WXMultiRowViewerDto> showlist = new ArrayList<WXMultiRowViewerDto>();
		String tookTime = ResourceUtil.getConfigByName("activiti.task.tooktime");
		List<Map<String,Object>> rptData = rptDao.activitiOvertimeStats(Integer.valueOf(tookTime));

		WXMultiRowViewerDto damzjl ;
		for (Map<String, Object> map : rptData) {
			damzjl = new WXMultiRowViewerDto();
			damzjl.setMainContent(map.get("realname").toString());
			String html = "<table style='width:80%;'> <tr> <td  class='detailTableName' style='width:60%;color: #3e4145;'>逾期总数：</td> <td  class='detailTableValue' style='width:60%;text-align: right;color: red;'>"+map.get("overcount").toString()+"条 </td> </tr> "
					+"<tr> <td class='detailTableName' style='width:60%;color: #3e4145;'>最长逾期天数：</td> <td  class='detailTableValue'style='width:60%;text-align: right;color: red;' >"+map.get("maxdaycount").toString()+"天</td></tr>"
					+""
					+"</table>";
			damzjl.setSecondContent(html);
			showlist.add(damzjl);
		}
	
		WXMultiRowViewer viewer = new WXMultiRowViewer();
		viewer.setRows(showlist);
		return WXViewerUtils.getWXMultiRowViewerHtml(viewer);
	}
	/**
	 * easyui AJAX请求数据
	 * 
	 * @param request
	 * @param response
	 * @param dataGrid
	 * @param user
	 */

	@RequestMapping(params = "datagrid")
	public void datagrid(WeeklyscheduleEntity weeklyschedule,HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
		CriteriaQuery cq = new CriteriaQuery(WeeklyscheduleEntity.class, dataGrid);
		//查询条件组装器
		org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, weeklyschedule, request.getParameterMap());
		try{
		//自定义追加查询条件
		}catch (Exception e) {
			throw new BusinessException(e.getMessage());
		}
		cq.add();
		this.weeklyscheduleService.getDataGridReturn(cq, true);
		TagUtil.datagrid(response, dataGrid);
	}
	
	/**
	 * 删除工作周报
	 * 
	 * @return
	 */
	@RequestMapping(params = "doDel")
	@ResponseBody
	public AjaxJson doDel(WeeklyscheduleEntity weeklyschedule, HttpServletRequest request) {
		String message = null;
		AjaxJson j = new AjaxJson();
		weeklyschedule = systemService.getEntity(WeeklyscheduleEntity.class, weeklyschedule.getId());
		message = "工作周报删除成功";
		try{
			weeklyscheduleService.delete(weeklyschedule);
			systemService.addLog(message, Globals.Log_Type_DEL, Globals.Log_Leavel_INFO);
		}catch(Exception e){
			e.printStackTrace();
			message = "工作周报删除失败";
			throw new BusinessException(e.getMessage());
		}
		j.setMsg(message);
		return j;
	}
	
	/**
	 * 批量删除工作周报
	 * 
	 * @return
	 */
	 @RequestMapping(params = "doBatchDel")
	@ResponseBody
	public AjaxJson doBatchDel(String ids,HttpServletRequest request){
		String message = null;
		AjaxJson j = new AjaxJson();
		message = "工作周报删除成功";
		try{
			for(String id:ids.split(",")){
				WeeklyscheduleEntity weeklyschedule = systemService.getEntity(WeeklyscheduleEntity.class, 
				id
				);
				weeklyscheduleService.delete(weeklyschedule);
				systemService.addLog(message, Globals.Log_Type_DEL, Globals.Log_Leavel_INFO);
			}
		}catch(Exception e){
			e.printStackTrace();
			message = "工作周报删除失败";
			throw new BusinessException(e.getMessage());
		}
		j.setMsg(message);
		return j;
	}


	/**
	 * 添加工作周报
	 * 
	 * @param ids
	 * @return
	 */
	@RequestMapping(params = "doAdd")
	@ResponseBody
	public AjaxJson doAdd(WeeklyscheduleEntity weeklyschedule, HttpServletRequest request) {
		String message = null;
		AjaxJson j = new AjaxJson();
		message = "周工作计划保存成功";
		if(weeklyschedule.getId() != null && weeklyschedule.getId().length()> 0) {
			doUpdate(weeklyschedule, request);
		}else {
			try{
				String hql1 = "from WeeklyscheduleEntity where userid=? and mondate = ?";
				List<WeeklyscheduleEntity> WeeklyscheduleEntityList = systemService.findHql(hql1, weeklyschedule.getUserid(),weeklyschedule.getMondate());
				if(WeeklyscheduleEntityList.size() > 0)
					throw new BusinessException("已存在此用户周报，请刷新后，重新填写并保存。");
				weeklyscheduleService.save(weeklyschedule);
				systemService.addLog(message, Globals.Log_Type_INSERT, Globals.Log_Leavel_INFO);
				String zjlWhat = WeeklyScheduleUtils.getZjlWhat(weeklyschedule);
				if(StringUtils.isNotEmpty(zjlWhat))
				{
					sendWXMsg4ZJLWhat(weeklyschedule.getUserid(), zjlWhat, weeklyschedule.getMondate() +"~"+weeklyschedule.getSundate());
				}
			}catch(BusinessException be){
				be.printStackTrace();
				logger.error(be);
				message = "周工作计划保存失败，"+be.getMessage();
			}catch(Exception e){
				e.printStackTrace();
				message = "周工作计划保存失败";
			}
		}
		j.setMsg(message);
		return j;
	}
	
	/**
	 * 更新工作周报
	 * 
	 * @param ids
	 * @return
	 */
	@RequestMapping(params = "doUpdate")
	@ResponseBody
	public AjaxJson doUpdate(WeeklyscheduleEntity weeklyschedule, HttpServletRequest request) {
		String message = null;
		AjaxJson j = new AjaxJson();
		message = "工作周报更新成功";
		WeeklyscheduleEntity t = weeklyscheduleService.get(WeeklyscheduleEntity.class, weeklyschedule.getId());
		try {
			String zjlWhat = WeeklyScheduleUtils.getZjlWhatChanged(weeklyschedule,t);
			if(StringUtils.isNotEmpty(zjlWhat))
			{
				sendWXMsg4ZJLWhat(weeklyschedule.getUserid(), zjlWhat, weeklyschedule.getMondate() +"~"+weeklyschedule.getSundate());
			}
			//参与人员信息列表
	 		List<WeeklySchedulePartiEntity> partiList = weeklyschedule.getPartiList();
	 		
			MyBeanUtils.copyBeanNotNull2Bean(weeklyschedule, t);
			weeklyscheduleService.saveOrUpdate(t);
			//删除原参与人员明细，重新保存
			String delSql = "delete from p_weeklyschedule_parti where scheduleid = ?";
			systemService.executeSql(delSql, weeklyschedule.getId());
			weeklyscheduleService.batchSave(partiList);
			systemService.addLog(message, Globals.Log_Type_UPDATE, Globals.Log_Leavel_INFO);
		} catch (Exception e) {
			e.printStackTrace();
			message = "工作周报更新失败";
			throw new BusinessException(e.getMessage());
		}
		j.setMsg(message);
		return j;
	}
	

	/**
	 * 工作周报新增页面跳转
	 * 
	 * @return
	 */
	@RequestMapping(params = "goAdd")
	public ModelAndView goAdd(WeeklyscheduleEntity weeklyschedule, HttpServletRequest req) {
		//传送过来界面中周一的日期
		String currentMonDate = req.getParameter("currentMonDate");
		String opt = req.getParameter("opt");
		String managerflag = req.getParameter("managerflag");
		String userid = req.getParameter("userid");
		String curweekflag = "2";
		List<Map<String,Object>> userList = new ArrayList<Map<String,Object>>();
		//取下周所有日期从周一到周日
		List<String> weekday = new ArrayList<String>();
		//新增操作，非界面按钮触发
		if(StringUtils.isEmpty(opt)){
			weekday = XcglDateUtils.getWeekdays(XcglDateUtils.addDateDay(
					DateUtils.formatDate(new Date(),"yyyy-MM-dd"),7, new SimpleDateFormat("yyyy-MM-dd")));
		}else {
			//界面按钮触发而来
			if(opt.equals("next")) {
				weekday = XcglDateUtils.getWeekdays(XcglDateUtils.addDateDay(
						currentMonDate,7, new SimpleDateFormat("yyyy-MM-dd")));
			}else if (opt.equals("before")) {
				weekday = XcglDateUtils.getWeekdays(XcglDateUtils.addDateDay(
						currentMonDate,-7, new SimpleDateFormat("yyyy-MM-dd")));
			}else if  (opt.equals("changeUser") || opt.equals("reload")) {
				weekday = XcglDateUtils.getWeekdays(currentMonDate);
			}
		}
		if(weekday.size() == 0 ) {
			req.setAttribute("ex", new Exception("界面参数错误，获取不到周计划日期，请联系系统管理员。"));
			return new  ModelAndView("common/error");
		}

		//如果是管理人员（例如总经办工作人员），则需要查询可做周计划的人员列表
		if(StringUtils.isNotEmpty(managerflag) && managerflag.equals("1")) {
			userList = wxdao.getUsersByRoleCode(XcglConstant.ROLE_ZHOUBAO);
			req.setAttribute("useridList", userList);
		}
		// 参数中无人员，并且不是总经理安排工作，则取当前登录用户ID
		if(StringUtils.isEmpty(userid) && (StringUtils.isEmpty(managerflag) 
				|| !managerflag.equals("1")))
			userid = ResourceUtil.getSessionUser().getId();
		else if(StringUtils.isEmpty(userid) &&  StringUtils.isNotEmpty(managerflag) && managerflag.equals("1")) {
			//总经理安排工作，无人员id参数，则取uers第一个人
			if(userList.size() > 0)
				userid = userList.get(0).get("id").toString();
			else {
				req.setAttribute("ex", new Exception("未设置工作执行人员，请联系管理员处理。"));
				return new  ModelAndView("common/error");
			}
		}
		String hql1 = "from WeeklyscheduleEntity where userid=? and mondate = ?";
		List<WeeklyscheduleEntity> WeeklyscheduleEntityList = systemService.findHql(hql1, userid,weekday.get(0));
		List<String> lastWeekday = XcglDateUtils.getWeekdays(XcglDateUtils.addDateDay(
				weekday.get(0),-7, new SimpleDateFormat("yyyy-MM-dd")));
		List<WeeklyscheduleEntity> lastWeeklyscheduleEntityList = systemService.findHql(hql1, userid,lastWeekday.get(0));
		StringBuffer notDone = new StringBuffer();
		if (lastWeeklyscheduleEntityList != null && lastWeeklyscheduleEntityList.size() > 0) {
			//查询未完成任务
			String hqlTask = "from ProjecttaskEntity where sourceid=? and taskstatus in ('0','1')";
			List<ProjecttaskEntity> notDoneProjecttaskEntitylist = systemService.findHql(hqlTask,  lastWeeklyscheduleEntityList.get(0).getId());
			if(notDoneProjecttaskEntitylist != null ) {
				for(ProjecttaskEntity task:notDoneProjecttaskEntitylist) {
					notDone.append(task.getDescription()).append(";\r\n");
				}
			}
		}
		if (WeeklyscheduleEntityList != null && WeeklyscheduleEntityList.size() > 0) {
			weeklyschedule = WeeklyscheduleEntityList.get(0);
			List<Map<String,Object>> nameTimeList = weeklyScheduleMiniDao.getParticipantName(weeklyschedule.getId());
			weeklyschedule = setRealNames(weeklyschedule, nameTimeList);
			weeklyschedule.setWeekFromTo(weeklyschedule.getMondate()+" 至 "+weeklyschedule.getSundate());
			weeklyschedule.setNotdone(notDone.toString());
			//如果下周周报已添加，则可以在本周继续编辑
			req.setAttribute("weeklyschedulePage", weeklyschedule);
		}else {
			weeklyschedule = new WeeklyscheduleEntity();
			weeklyschedule.setUserid(userid);
			weeklyschedule.setMondate(weekday.get(0));
			weeklyschedule.setTuesdate(weekday.get(1));
			weeklyschedule.setWeddate(weekday.get(2));
			weeklyschedule.setThurdate(weekday.get(3));
			weeklyschedule.setFridate(weekday.get(4));
			weeklyschedule.setSatdate(weekday.get(5));
			weeklyschedule.setSundate(weekday.get(6));
			weeklyschedule.setWeekFromTo(weekday.get(0)+" 至 "+weekday.get(6));
			weeklyschedule.setStatus(Globals.UNAPPROVED);
			weeklyschedule.setNotdone(notDone.toString());
			req.setAttribute("weeklyschedulePage", weeklyschedule);
		}
		List<String> curweekday = XcglDateUtils.getWeekdays(DateUtils.formatDate(new Date(),"yyyy-MM-dd"));
		if(curweekday.get(0).equals(weekday.get(0))) {
			curweekflag = "1";
		}else if(curweekday.get(0).compareTo(weekday.get(0)) > 0)
			curweekflag = "0";
		req.setAttribute("managerflag", managerflag);
		req.setAttribute("curweekflag", curweekflag);
		req.setAttribute("userid", userid);
		req.setAttribute("username",  ResourceUtil.getSessionUser().getRealName());
		return new ModelAndView("com/xcgl/weeklyschedule/weeklyschedule-add");
	}
	
	private WeeklyscheduleEntity setRealNames(WeeklyscheduleEntity weeklyschedule, List<Map<String,Object>> nameTimeList) {
		for(Map<String,Object> nameTime : nameTimeList) {
			String date = nameTime.get("datetime").toString();
			String realNames = nameTime.get("realNames").toString();
			//周一
			if(weeklyschedule.getMondate().equals(date.substring(0,10)) && date.substring(10).equals("am")) {
				weeklyschedule.setWhomonamnames(realNames);
			}else if (weeklyschedule.getMondate().equals(date.substring(0,10)) && date.substring(10).equals("pm")) {
				weeklyschedule.setWhomonpmnames(realNames);
			}
			//周二
			else if(weeklyschedule.getTuesdate().equals(date.substring(0,10)) && date.substring(10).equals("am")) {
				weeklyschedule.setWhotuesamnames(realNames);
			}else if (weeklyschedule.getTuesdate().equals(date.substring(0,10)) && date.substring(10).equals("pm")) {
				weeklyschedule.setWhotuespmnames(realNames);
			}
			//周三
			else if(weeklyschedule.getWeddate().equals(date.substring(0,10)) && date.substring(10).equals("am")) {
				weeklyschedule.setWhowedamnames(realNames);
			}else if (weeklyschedule.getWeddate().equals(date.substring(0,10)) && date.substring(10).equals("pm")) {
				weeklyschedule.setWhowedpmnames(realNames);
			}
			//周四
			else if(weeklyschedule.getThurdate().equals(date.substring(0,10)) && date.substring(10).equals("am")) {
				weeklyschedule.setWhothuramnames(realNames);
			}else if (weeklyschedule.getThurdate().equals(date.substring(0,10)) && date.substring(10).equals("pm")) {
				weeklyschedule.setWhothurpmnames(realNames);
			}
			//周五
			else if(weeklyschedule.getFridate().equals(date.substring(0,10)) && date.substring(10).equals("am")) {
				weeklyschedule.setWhofriamnames(realNames);
			}else if (weeklyschedule.getFridate().equals(date.substring(0,10)) && date.substring(10).equals("pm")) {
				weeklyschedule.setWhofripmnames(realNames);
			}
			//周六
			else if(weeklyschedule.getSatdate().equals(date.substring(0,10)) && date.substring(10).equals("am")) {
				weeklyschedule.setWhosatamnames(realNames);
			}else if (weeklyschedule.getSatdate().equals(date.substring(0,10)) && date.substring(10).equals("pm")) {
				weeklyschedule.setWhosatpmnames(realNames);
			}
			//周日
			else if(weeklyschedule.getSundate().equals(date.substring(0,10)) && date.substring(10).equals("am")) {
				weeklyschedule.setWhosunamnames(realNames);
			}else if (weeklyschedule.getSundate().equals(date.substring(0,10)) && date.substring(10).equals("pm")) {
				weeklyschedule.setWhosunpmnames(realNames);
			}
		}
		return weeklyschedule;
	}
	
	/**
	 * 工作周报编辑页面跳转
	 * 
	 * @return
	 */
	@RequestMapping(params = "goUpdate")
	public ModelAndView goUpdate(WeeklyscheduleEntity weeklyschedule, HttpServletRequest req) {
		if (StringUtil.isNotEmpty(weeklyschedule.getId())) {
			weeklyschedule = weeklyscheduleService.getEntity(WeeklyscheduleEntity.class, weeklyschedule.getId());
			List<Map<String,Object>> nameTimeList = weeklyScheduleMiniDao.getParticipantName(weeklyschedule.getId());
			weeklyschedule = setRealNames(weeklyschedule, nameTimeList);
			req.setAttribute("weeklyschedulePage", weeklyschedule);
		}
		return new ModelAndView("com/xcgl/weeklyschedule/weeklyschedule-update");
	}
	
	/**
	 * 导入功能跳转
	 * 
	 * @return
	 */
	@RequestMapping(params = "upload")
	public ModelAndView upload(HttpServletRequest req) {
		req.setAttribute("controller_name","weeklyscheduleController");
		return new ModelAndView("common/upload/pub_excel_upload");
	}
	
	/**
	 * 导出excel
	 * 
	 * @param request
	 * @param response
	 */
	@RequestMapping(params = "exportXls")
	public String exportXls(WeeklyscheduleEntity weeklyschedule,HttpServletRequest request,HttpServletResponse response
			, DataGrid dataGrid,ModelMap modelMap) {
		CriteriaQuery cq = new CriteriaQuery(WeeklyscheduleEntity.class, dataGrid);
		org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, weeklyschedule, request.getParameterMap());
		List<WeeklyscheduleEntity> weeklyschedules = this.weeklyscheduleService.getListByCriteriaQuery(cq,false);
		modelMap.put(NormalExcelConstants.FILE_NAME,"工作周报");
		modelMap.put(NormalExcelConstants.CLASS,WeeklyscheduleEntity.class);
		modelMap.put(NormalExcelConstants.PARAMS,new ExportParams("工作周报列表", "导出人:"+ResourceUtil.getSessionUser().getRealName(),
			"导出信息"));
		modelMap.put(NormalExcelConstants.DATA_LIST,weeklyschedules);
		return NormalExcelConstants.JEECG_EXCEL_VIEW;
	}
	/**
	 * 导出excel 使模板
	 * 
	 * @param request
	 * @param response
	 */
	@RequestMapping(params = "exportXlsByT")
	public String exportXlsByT(WeeklyscheduleEntity weeklyschedule,HttpServletRequest request,HttpServletResponse response
			, DataGrid dataGrid,ModelMap modelMap) {
    	modelMap.put(NormalExcelConstants.FILE_NAME,"工作周报");
    	modelMap.put(NormalExcelConstants.CLASS,WeeklyscheduleEntity.class);
    	modelMap.put(NormalExcelConstants.PARAMS,new ExportParams("工作周报列表", "导出人:"+ResourceUtil.getSessionUser().getRealName(),
    	"导出信息"));
    	modelMap.put(NormalExcelConstants.DATA_LIST,new ArrayList());
    	return NormalExcelConstants.JEECG_EXCEL_VIEW;
	}
	
	@SuppressWarnings("unchecked")
	@RequestMapping(params = "importExcel", method = RequestMethod.POST)
	@ResponseBody
	public AjaxJson importExcel(HttpServletRequest request, HttpServletResponse response) {
		AjaxJson j = new AjaxJson();
		
		MultipartHttpServletRequest multipartRequest = (MultipartHttpServletRequest) request;
		Map<String, MultipartFile> fileMap = multipartRequest.getFileMap();
		for (Map.Entry<String, MultipartFile> entity : fileMap.entrySet()) {
			MultipartFile file = entity.getValue();// 获取上传文件对象
			ImportParams params = new ImportParams();
			params.setTitleRows(2);
			params.setHeadRows(1);
			params.setNeedSave(true);
			try {
				List<WeeklyscheduleEntity> listWeeklyscheduleEntitys = ExcelImportUtil.importExcel(file.getInputStream(),WeeklyscheduleEntity.class,params);
				for (WeeklyscheduleEntity weeklyschedule : listWeeklyscheduleEntitys) {
					weeklyscheduleService.save(weeklyschedule);
				}
				j.setMsg("文件导入成功！");
			} catch (Exception e) {
				j.setMsg("文件导入失败！");
				logger.error(ExceptionUtil.getExceptionMessage(e));
			}finally{
				try {
					file.getInputStream().close();
				} catch (IOException e) {
					e.printStackTrace();
				}
			}
		}
		return j;
	}
	
	@RequestMapping(method = RequestMethod.GET)
	@ResponseBody
	public List<WeeklyscheduleEntity> list() {
		List<WeeklyscheduleEntity> listWeeklyschedules=weeklyscheduleService.getList(WeeklyscheduleEntity.class);
		return listWeeklyschedules;
	}
	
	@RequestMapping(value = "/{id}", method = RequestMethod.GET)
	@ResponseBody
	public ResponseEntity<?> get(@PathVariable("id") String id) {
		WeeklyscheduleEntity task = weeklyscheduleService.get(WeeklyscheduleEntity.class, id);
		if (task == null) {
			return new ResponseEntity(HttpStatus.NOT_FOUND);
		}
		return new ResponseEntity(task, HttpStatus.OK);
	}

	@RequestMapping(method = RequestMethod.POST, consumes = MediaType.APPLICATION_JSON_VALUE)
	@ResponseBody
	public ResponseEntity<?> create(@RequestBody WeeklyscheduleEntity weeklyschedule, UriComponentsBuilder uriBuilder) {
		//调用JSR303 Bean Validator进行校验，如果出错返回含400错误码及json格式的错误信息.
		Set<ConstraintViolation<WeeklyscheduleEntity>> failures = validator.validate(weeklyschedule);
		if (!failures.isEmpty()) {
			return new ResponseEntity(BeanValidators.extractPropertyAndMessage(failures), HttpStatus.BAD_REQUEST);
		}

		//保存
		try{
			weeklyscheduleService.save(weeklyschedule);
		} catch (Exception e) {
			e.printStackTrace();
			return new ResponseEntity(HttpStatus.NO_CONTENT);
		}
		//按照Restful风格约定，创建指向新任务的url, 也可以直接返回id或对象.
		String id = weeklyschedule.getId();
		URI uri = uriBuilder.path("/rest/weeklyscheduleController/" + id).build().toUri();
		HttpHeaders headers = new HttpHeaders();
		headers.setLocation(uri);

		return new ResponseEntity(headers, HttpStatus.CREATED);
	}

	@RequestMapping(value = "/{id}", method = RequestMethod.PUT, consumes = MediaType.APPLICATION_JSON_VALUE)
	public ResponseEntity<?> update(@RequestBody WeeklyscheduleEntity weeklyschedule) {
		//调用JSR303 Bean Validator进行校验，如果出错返回含400错误码及json格式的错误信息.
		Set<ConstraintViolation<WeeklyscheduleEntity>> failures = validator.validate(weeklyschedule);
		if (!failures.isEmpty()) {
			return new ResponseEntity(BeanValidators.extractPropertyAndMessage(failures), HttpStatus.BAD_REQUEST);
		}

		//保存
		try{
			weeklyscheduleService.saveOrUpdate(weeklyschedule);
		} catch (Exception e) {
			e.printStackTrace();
			return new ResponseEntity(HttpStatus.NO_CONTENT);
		}

		//按Restful约定，返回204状态码, 无内容. 也可以返回200状态码.
		return new ResponseEntity(HttpStatus.NO_CONTENT);
	}

	@RequestMapping(value = "/{id}", method = RequestMethod.DELETE)
	@ResponseStatus(HttpStatus.NO_CONTENT)
	public void delete(@PathVariable("id") String id) {
		weeklyscheduleService.deleteEntityById(WeeklyscheduleEntity.class, id);
	}
	
	@RequestMapping(params = "sendmsg")
	public AjaxJson sendmsg(HttpServletRequest request) {
		AjaxJson j = new AjaxJson();
		weeklyscheduleService.sendWXMsgForWeeklySchedule();
		String message = "微信消息发送成功";
		j.setMsg(message);
		return j;
	}
	
	@RequestMapping(params = "genTask")
	public AjaxJson genTask(HttpServletRequest request) {
		AjaxJson j = new AjaxJson();
		weeklyscheduleService.genWorkFromWeeklySchedule();
		String message = "生成任务成功";
		j.setMsg(message);
		return j;
	}
	@RequestMapping(params = "getPersonInfo")
	public void getPersonInfo(UserAndUserPersonnelDto userAndUserPersonnelDto, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
		List<Map<String,Object>> users = wxdao.getUsersByRoleCode("T_ZBJS");
		List<String> useridListAll = new ArrayList<String>();
		if(users.size() > 0) {
			for(Map<String,Object> map :users) {
				useridListAll.add(map.get("id").toString());
			}
			userAndUserPersonnelDto.setUserIdList(useridListAll);
			String authSql = JeecgDataAutorUtils.loadDataSearchConditonSQLString();
			List<UserAndUserPersonnelDto> listUserAndUserPersonnelDto = weeklyScheduleMiniDao.getUserAndUserPersonnelNoPage(userAndUserPersonnelDto,authSql);
			Collections.sort(listUserAndUserPersonnelDto);
			dataGrid.setResults(listUserAndUserPersonnelDto);
			TagUtil.datagrid(response, dataGrid);
		}
	}
	
	@RequestMapping(params = "openPersonView")
	public ModelAndView openPersonView(HttpServletRequest request) {
		return new ModelAndView("com/xcgl/weeklyschedule/personSelectList");
	}
	/*
	 * 给员工发微信，提醒总经理安排变更，注意自己的工作计划
	 * */
	private void sendWXMsg4ZJLWhat(String userid,String what,String date) {
		List<Map<String, Object>> user = systemService
				.findForJdbc("select openid from t_s_user where id =? and openid is not null", userid);
		if (user.size() == 0)
			return;
		List<Map<String, Object>> listParams = new ArrayList<Map<String, Object>>();
		Map<String, Object> oneMsg = new HashMap<String, Object>();
		Map<String, Object> userMsgParms = new HashMap<String, Object>();
		userMsgParms.put("first", "你有一个闵总新安排的事项，请及时关注");
		userMsgParms.put("keyword1", date);
		userMsgParms.put("keyword2",  what);
		userMsgParms.put("remark", "请登录慧管理系统查看详细周工作计划。");
		oneMsg.put("openid", user.get(0).get("openid").toString());
		oneMsg.put("userid", userid);
		oneMsg.put("tplParams", userMsgParms);
//			oneMsg.put("url", "http://test.shenqin.work:8080/hgl/dsdemoController.do?showNoOrderWarehouse"+"&openid="+user.get("openid")+"&schedule="+weekday.get(0)+","+weekday.get(1));
		listParams.add(oneMsg);
		try {
			wxservice.sendMsgToWXForTodayWork(listParams);
		} catch (Exception e) {
			logger.error(e);
		}
	}
}