meidu2021/daju/target/classes/cn/com/lzt/projarrangedetail/controller/ProjarrangeDetailController.java

package cn.com.lzt.projarrangedetail.controller;
import cn.com.lzt.arrangeduty.entity.ArrangeDutyEntity;
import cn.com.lzt.arrangeduty.service.ArrangeDutyServiceI;
import cn.com.lzt.arrangedutyoperate.entity.ArrangeDutyOperateEntity;
import cn.com.lzt.arrangedutyoperate.service.ArrangeDutyOperateServiceI;
import cn.com.lzt.calendar.dto.CalendarAscDto;
import cn.com.lzt.calendar.entity.CalendarEntity;
import cn.com.lzt.calendar.service.CalendarServiceI;
import cn.com.lzt.common.util.uuid.GetUUID;
import cn.com.lzt.dialogDeal.service.UserDepartOrgDealServiceI;
import cn.com.lzt.excel.HGLExcelConstant;
import cn.com.lzt.excel.HGLExcelImportUtils;
import cn.com.lzt.excel.entity.HGLExcelResult;
import cn.com.lzt.projarrangedetail.dao.ProjArrangeDetailAndUserMiniDao;
import cn.com.lzt.projarrangedetail.dto.ProjArrangeDetailAndUserDto;
import cn.com.lzt.projarrangedetail.dto.UserArrangeCalendarDto;
import cn.com.lzt.projarrangedetail.entity.ProjarrangeDetailEntity;
import cn.com.lzt.projarrangedetail.service.ArrangeDutyAndOndutyServiceI;
import cn.com.lzt.projarrangedetail.service.ProjarrangeDetailServiceI;
import cn.com.lzt.projarrangegeneral.entity.ProjArrangeGeneralEntity;
import cn.com.lzt.projarrangegeneral.service.ProjArrangeGeneralServiceI;
import cn.com.lzt.projectpostdetail.entity.ProjectPostDetailEntity;
import cn.com.lzt.tools.HGLDateUtils;
import cn.com.lzt.userarrangedetail.entity.UserArrangeDetailHistoryEntity;
import cn.com.lzt.userarrangedetail.service.UserArrangeDetailServiceI;
import cn.com.lzt.useroptions.entity.TBusUserOptionsEntity;
import cn.com.lzt.useroptions.service.TBusUserOptionsServiceI;
import net.sf.json.JSONArray;
import org.apache.commons.lang3.StringUtils;
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.model.json.AjaxJson;
import org.jeecgframework.core.common.model.json.DataGrid;
import org.jeecgframework.core.constant.Globals;
import org.jeecgframework.core.util.*;
import org.jeecgframework.poi.excel.entity.ExportParams;
import org.jeecgframework.poi.excel.entity.ImportParams;
import org.jeecgframework.poi.excel.entity.enmus.ExcelType;
import org.jeecgframework.poi.excel.entity.params.ExcelExportEntity;
import org.jeecgframework.poi.excel.entity.vo.MapExcelConstants;
import org.jeecgframework.poi.excel.entity.vo.NormalExcelConstants;
import org.jeecgframework.tag.core.easyui.TagUtil;
import org.jeecgframework.web.system.pojo.base.DictEntity;
import org.jeecgframework.web.system.pojo.base.TSDepart;
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.*;
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 javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import javax.validation.ConstraintViolation;
import javax.validation.Validator;
import java.io.IOException;
import java.net.URI;
import java.text.SimpleDateFormat;
import java.util.*;
import java.util.Map.Entry;

/**   
 * @Title: Controller  
 * @Description: 项目排班详细表
 * @author onlineGenerator
 * @date 2017-10-24 10:52:56
 * @version V1.0   
 *
 */
@Controller
@RequestMapping("/projarrangeDetailController")
public class ProjarrangeDetailController extends BaseController {
	/**
	 * Logger for this class
	 */
	private static final Logger logger = Logger.getLogger(ProjarrangeDetailController.class);

	//项目排班详细表
	@Autowired
	private ProjarrangeDetailServiceI projarrangeDetailService;
	@Autowired
	private SystemService systemService;
	@Autowired
	private Validator validator;
	@Autowired
	private TBusUserOptionsServiceI userOptionsService;
	//日历表
	@Autowired
	private CalendarServiceI calendarService;
	
	//员工排班详情表
	@Autowired
	private UserArrangeDetailServiceI userArrangeDetailService;
	
	//班次表
	@Autowired
	private ArrangeDutyServiceI arrangeDutyService;
	
	//项目排班总览表
	@Autowired
	private ProjArrangeGeneralServiceI projArrangeGeneralService;
	
	//排班操作表
	@Autowired
	private ArrangeDutyOperateServiceI arrangeDutyOperateService;
	
	//排班总方法页
	@Autowired
	private ArrangeDutyAndOndutyServiceI arrangeDutyAndOndutyServiceI;
	
	//项目排班自己总结公共方法；
	//ProjectArrangeCommonMethod commonMethod;
	
//	用户和项目关系处理
	@Autowired
	UserDepartOrgDealServiceI userDepartOrgDealServiceI;
	
	@Autowired
	ProjArrangeDetailAndUserMiniDao projDao;

	
	/**
	 * 项目排班详细表列表 页面跳转
	 * @author zbw
	 * 2017-11-24
	 * @param request
	 * @param calendarAscDto
	 * @return
	 */
	@RequestMapping(params = "list")
	public ModelAndView list(HttpServletRequest request,CalendarAscDto calendarAscDto) {
		String pid=request.getParameter("pid");
		String[] pidArr = null;
		String[] weekStr = new String[] {"一","二","三","四","五","六","日"};
		HttpSession session = ContextHolderUtils.getSession();
		TSUser tuser = (TSUser)session.getAttribute("LOCAL_CLINET_USER");
		try {
			if(pid!=null){
				pidArr=pid.split(",");
				if(pidArr != null && pidArr.length>0) {
					userOptionsService.saveUserOptions(tuser.getId(), pid,  Globals.USER_OPTIONS_TYPE_PROJECT);
				}
			}else {
				TBusUserOptionsEntity options = userOptionsService.getOptionsByUserID(tuser.getId(), Globals.USER_OPTIONS_TYPE_PROJECT, true);
				if(options != null) {
					pid = options.getOptionId();
					pidArr= new String[1];
					pidArr[0] = pid;
				}
			}
		} catch (Exception e) {
			e.printStackTrace();
			org.jeecgframework.core.util.LogUtil.error(e.getMessage());
		}
		if(calendarAscDto.getYear()==null&&calendarAscDto.getMonth()==null){
			SimpleDateFormat simpleDateFormat=new SimpleDateFormat("yyy-MM");
			String[] dateNumber=simpleDateFormat.format(new Date()).split("-");
			calendarAscDto.setYear(Integer.parseInt(dateNumber[0]));
			calendarAscDto.setMonth(Integer.parseInt(dateNumber[1]));
		}
		List<CalendarAscDto> listCalendar=projarrangeDetailService.getCalendar(calendarAscDto);
		List<HashMap<String, Object>> titlelist = new ArrayList<HashMap<String, Object>>();
		//日期列名字符串即主键id
		String calendaridStr="";
		//日期列名字符串即主键id+星期几
		String specialCalendar="[{";
		for (int i =0;i<listCalendar.size();i++) {
			if(specialCalendar.length()!=2){
				specialCalendar+=",'"+listCalendar.get(i).getId()+"':'"+listCalendar.get(i).getWeek()+"'";
			}else{
				specialCalendar+="'"+listCalendar.get(i).getId()+"':'"+listCalendar.get(i).getWeek()+"'";
			}
			
			if(calendaridStr.length()!=0){
				calendaridStr+=","+listCalendar.get(i).getId();
			}else{
				calendaridStr=listCalendar.get(i).getId();
			}
			HashMap<String, Object> map = new HashMap<String, Object>();
			String monthTemp = String.valueOf(listCalendar.get(i).getMonth());
			String dayTemp = String.valueOf(listCalendar.get(i).getDay());
			String weekTemp = null;
	        if((listCalendar.get(i).getWeek() != null)){
	        	int weekInt= -1;
	        	try {
	        		weekInt =Integer.parseInt(listCalendar.get(i).getWeek());
	        	}catch(Exception e) {}
	        	if(weekInt > 0 && weekInt < 8) {
	        		weekTemp =  weekStr[weekInt-1];
	        	}
	        	
	        }
	        if(weekTemp == null) {
	        	map.put("title", monthTemp+"月"+dayTemp+"日");
	        }else {
	        	map.put("title", monthTemp+"月"+dayTemp+"日"+" 星期"+weekTemp+"");
	        }
		
			/*map.put("field", String.valueOf(listCalendar.get(i).getYear())+
					String.valueOf(listCalendar.get(i).getMonth())+String.valueOf(listCalendar.get(i).getDay()));*/
			map.put("field", listCalendar.get(i).getId());
			titlelist.add(map);
		}
		
		specialCalendar += "}]";
		request.setAttribute("specialCalendar",specialCalendar);
		String tempMonth=String.valueOf(calendarAscDto.getMonth()).length()==1?"0"+String.valueOf(calendarAscDto.getMonth()):String.valueOf(calendarAscDto.getMonth());
		String yearmonth=String.valueOf(calendarAscDto.getYear())+"-"+tempMonth;
		request.setAttribute("calendaridStr",calendaridStr);
		request.setAttribute("titlelist",titlelist);
		request.setAttribute("yearmonth",yearmonth);
		request.setAttribute("usernamesearch",request.getParameter("usernamesearch"));
		if(pidArr!=null){
			String id=pidArr[0];
			TSDepart dePart = this.systemService.getEntity(TSDepart.class, id);
			request.setAttribute("pid",id);
			request.setAttribute("departname",dePart.getDepartname());
		}else{
			request.setAttribute("pid",pid);
			request.setAttribute("departname",null);
		}
		return new ModelAndView("cn/com/lzt/projarrangedetail/projarrangeDetailList");
	}
	
	/**
	 * 项目排班详细表列表 页面跳转
	 * @author zbw
	 * 2017-11-24
	 * @param request
	 * @param calendarAscDto
	 * @return
	 */
	@RequestMapping(params = "listAll")
	public ModelAndView listAll(HttpServletRequest request,CalendarAscDto calendarAscDto) {
		String pid=request.getParameter("pid");
		String[] pidArr = null;
		String[] weekStr = new String[] {"一","二","三","四","五","六","日"};
		HttpSession session = ContextHolderUtils.getSession();
		TSUser tuser = (TSUser)session.getAttribute("LOCAL_CLINET_USER");
		try {
			if(pid!=null){
				pidArr=pid.split(",");
				if(pidArr != null && pidArr.length>0) {
					userOptionsService.saveUserOptions(tuser.getId(), pid,  Globals.USER_OPTIONS_TYPE_PROJECT);
				}
			}else {
				TBusUserOptionsEntity options = userOptionsService.getOptionsByUserID(tuser.getId(), Globals.USER_OPTIONS_TYPE_PROJECT, true);
				if(options != null) {
					pid = options.getOptionId();
					pidArr= new String[1];
					pidArr[0] = pid;
				}
			}
		} catch (Exception e) {
			e.printStackTrace();
			org.jeecgframework.core.util.LogUtil.error(e.getMessage());
		}
		if(calendarAscDto.getYear()==null&&calendarAscDto.getMonth()==null){
			SimpleDateFormat simpleDateFormat=new SimpleDateFormat("yyy-MM");
			String[] dateNumber=simpleDateFormat.format(new Date()).split("-");
			calendarAscDto.setYear(Integer.parseInt(dateNumber[0]));
			calendarAscDto.setMonth(Integer.parseInt(dateNumber[1]));
		}
		List<CalendarAscDto> listCalendar=projarrangeDetailService.getCalendar(calendarAscDto);
		List<HashMap<String, Object>> titlelist = new ArrayList<HashMap<String, Object>>();
		//日期列名字符串即主键id
		String calendaridStr="";
		//日期列名字符串即主键id+星期几
		String specialCalendar="[{";
		for (int i =0;i<listCalendar.size();i++) {
			if(specialCalendar.length()!=2){
				specialCalendar+=",'"+listCalendar.get(i).getId()+"':'"+listCalendar.get(i).getWeek()+"'";
			}else{
				specialCalendar+="'"+listCalendar.get(i).getId()+"':'"+listCalendar.get(i).getWeek()+"'";
			}
			
			if(calendaridStr.length()!=0){
				calendaridStr+=","+listCalendar.get(i).getId();
			}else{
				calendaridStr=listCalendar.get(i).getId();
			}
			HashMap<String, Object> map = new HashMap<String, Object>();
			String monthTemp = String.valueOf(listCalendar.get(i).getMonth());
			String dayTemp = String.valueOf(listCalendar.get(i).getDay());
			String weekTemp = null;
	        if((listCalendar.get(i).getWeek() != null)){
	        	int weekInt= -1;
	        	try {
	        		weekInt =Integer.parseInt(listCalendar.get(i).getWeek());
	        	}catch(Exception e) {}
	        	if(weekInt > 0 && weekInt < 8) {
	        		weekTemp =  weekStr[weekInt-1];
	        	}
	        	
	        }
	        if(weekTemp == null) {
	        	map.put("title", monthTemp+"月"+dayTemp+"日");
	        }else {
	        	map.put("title", monthTemp+"月"+dayTemp+"日"+" 星期"+weekTemp+"");
	        }
		
			/*map.put("field", String.valueOf(listCalendar.get(i).getYear())+
					String.valueOf(listCalendar.get(i).getMonth())+String.valueOf(listCalendar.get(i).getDay()));*/
			map.put("field", listCalendar.get(i).getId());
			titlelist.add(map);
		}
		
		specialCalendar += "}]";
		request.setAttribute("specialCalendar",specialCalendar);
		String tempMonth=String.valueOf(calendarAscDto.getMonth()).length()==1?"0"+String.valueOf(calendarAscDto.getMonth()):String.valueOf(calendarAscDto.getMonth());
		String yearmonth=String.valueOf(calendarAscDto.getYear())+"-"+tempMonth;
		request.setAttribute("calendaridStr",calendaridStr);
		request.setAttribute("titlelist",titlelist);
		request.setAttribute("yearmonth",yearmonth);
		request.setAttribute("usernamesearch",request.getParameter("usernamesearch"));
		if(pidArr!=null){
			String id=pidArr[0];
			TSDepart dePart = this.systemService.getEntity(TSDepart.class, id);
			request.setAttribute("pid",id);
			request.setAttribute("departname",dePart.getDepartname());
		}else{
			request.setAttribute("pid",pid);
			request.setAttribute("departname",null);
		}
		return new ModelAndView("cn/com/lzt/projarrangedetail/projarrangeDetailAllList");
	}
	
	
	/**
	 * 排班审核查看详细 页面跳转
	 * 
	 * @return
	 */
	@RequestMapping(params = "generalDetailList")
	public ModelAndView generalDetailList(HttpServletRequest request,CalendarAscDto calendarAscDto) {
		String projarrangegeneralId=calendarAscDto.getId();
		calendarAscDto.setId("");
		String pid=request.getParameter("pid");
		String[] pidArr = null;
		String[] weekStr = new String[] {"一","二","三","四","五","六","日"};
		if(pid!=null){
			pidArr=pid.split(",");
		}
		if(calendarAscDto.getYear()==null&&calendarAscDto.getMonth()==null){
			SimpleDateFormat simpleDateFormat=new SimpleDateFormat("yyy-MM");
			String[] dateNumber=simpleDateFormat.format(new Date()).split("-");
			calendarAscDto.setYear(Integer.parseInt(dateNumber[0]));
			calendarAscDto.setMonth(Integer.parseInt(dateNumber[1]));
		}
		List<CalendarAscDto> listCalendar=projarrangeDetailService.getCalendar(calendarAscDto);
		List<HashMap<String, Object>> titlelist = new ArrayList<HashMap<String, Object>>();
		//日期列名字符串即主键id
		String calendaridStr="";
		//日期列名字符串即主键id+星期几
		String specialCalendar="[{";
		for (int i=0;i<listCalendar.size();i++) {
			if(specialCalendar.length()!=2){
				specialCalendar+=",'"+listCalendar.get(i).getId()+"':'"+listCalendar.get(i).getWeek()+"'";
			}else{
				specialCalendar+="'"+listCalendar.get(i).getId()+"':'"+listCalendar.get(i).getWeek()+"'";
			}
			
			if(calendaridStr.length()!=0){
				calendaridStr+=","+listCalendar.get(i).getId();
			}else{
				calendaridStr=listCalendar.get(i).getId();
			}
			HashMap<String, Object> map = new HashMap<String, Object>();
			String monthTemp = String.valueOf(listCalendar.get(i).getMonth());
			String dayTemp = String.valueOf(listCalendar.get(i).getDay());
			String weekTemp = null;
	        if((listCalendar.get(i).getWeek() != null)){
	        	int weekInt= -1;
	        	try {
	        		weekInt =Integer.parseInt(listCalendar.get(i).getWeek());
	        	}catch(Exception e) {}
	        	if(weekInt > 0 && weekInt < 8) {
	        		weekTemp =  weekStr[weekInt-1];
	        	}
	        	
	        }
	        if(weekTemp == null) {
	        	map.put("title", monthTemp+"月"+dayTemp+"日");
	        }else {
	        	map.put("title", monthTemp+"月"+dayTemp+"日"+" 星期"+weekTemp+"");
	        }
			/*map.put("field", String.valueOf(listCalendar.get(i).getYear())+
					String.valueOf(listCalendar.get(i).getMonth())+String.valueOf(listCalendar.get(i).getDay()));*/
			map.put("field", listCalendar.get(i).getId());
			titlelist.add(map);
		}
		
		specialCalendar+="}]";
		request.setAttribute("specialCalendar",specialCalendar);
		
		String tempMonth=String.valueOf(calendarAscDto.getMonth()).length()==1?"0"+String.valueOf(calendarAscDto.getMonth()):String.valueOf(calendarAscDto.getMonth());
		String yearmonth=String.valueOf(calendarAscDto.getYear())+"-"+tempMonth;
		request.setAttribute("calendaridStr",calendaridStr);
		request.setAttribute("titlelist",titlelist);
		request.setAttribute("yearmonth",yearmonth);
		if(pidArr!=null){
			String id=pidArr[0];
			TSDepart dePart = this.systemService.getEntity(TSDepart.class, id);
			request.setAttribute("pid",pidArr[0]);
			request.setAttribute("departname",dePart.getDepartname());
		}else{
			request.setAttribute("pid",pid);
			request.setAttribute("departname",null);
		}
		
		//审核表Id
		request.setAttribute("projarrangegeneralId",projarrangegeneralId);
		
		return new ModelAndView("cn/com/lzt/projarrangegeneral/generalDetailList");
	}
	
	
	

	/**
	 * 员工排班上报数据主页面
	 * easyui AJAX请求数据
	 * 
	 * @param request
	 * @param response
	 * @param dataGrid
	 * @param user
	 */

	@RequestMapping(params = "datagrid")
	public void datagrid(ProjArrangeDetailAndUserDto projArrangeDetailAndUserDto,HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
		long start = System.currentTimeMillis();
		UserArrangeCalendarDto userArrangeCalendarDto=new UserArrangeCalendarDto();
		int s=dataGrid.getField().indexOf("userid")+7;
		int e=dataGrid.getField().indexOf("workingDays")-1;
	
		//日期列名数组即主键id
		String[] calendaridArr=dataGrid.getField().substring(s, e).split(",");
		//String calendarid="";
		List<String> calendaridList=new ArrayList<String>();
		for (int i = 0; i < calendaridArr.length; i++) {
			calendaridList.add(calendaridArr[i]);
		}
		if(calendaridList.size()>0){
			userArrangeCalendarDto.setCalendaridList(calendaridList);
		}
		
		projArrangeDetailAndUserDto.setYearmonth(request.getParameter("yearmonth"));
		String pid=request.getParameter("pid");
		if(pid!=null&&pid.length()>0){
			pid=pid.split(",")[0];
		}
		projArrangeDetailAndUserDto.setPid(pid);
		
		projArrangeDetailAndUserDto.setUserName(request.getParameter("usernamesearch"));
		
		//包括该项目id
		//根据项目id查询所有子节点id
		List<String> ChildIdList=userDepartOrgDealServiceI.getChildIdByProjectDepartId(pid);
		projArrangeDetailAndUserDto.setChildDepartIdList(ChildIdList);
		String authSql = JeecgDataAutorUtils.loadDataSearchConditonSQLString();
		//查询项目排班详细表数据
		List<ProjArrangeDetailAndUserDto> projArrangeDetailAndUserDtolist = projarrangeDetailService.getProjArrangeDetailAndUserByPIdYearMonth(
				projArrangeDetailAndUserDto,authSql);
		dataGrid.setResults(projArrangeDetailAndUserDtolist);
		
		//班次名称如果被删除，则不用拼接此条数据
		//只查询启用的数据
		StringBuffer hql = new StringBuffer(" from ArrangeDutyEntity t where delete_flag <> '1' ");
		List<ArrangeDutyEntity> arrangeDutyEntityList = arrangeDutyService.findHql(hql.toString());
		List<String> shiftIdList=new ArrayList<String>();
		for (int i = 0; i < arrangeDutyEntityList.size(); i++) {
			shiftIdList.add(arrangeDutyEntityList.get(i).getId());
		}

		@SuppressWarnings("unchecked")
		List<ProjArrangeDetailAndUserDto> projectPostUserMiniDaoDtolistNew = dataGrid.getResults();
		Map<String,Map<String,Object>> extMap = new HashMap<String, Map<String,Object>>();
		for(ProjArrangeDetailAndUserDto temp:projectPostUserMiniDaoDtolistNew){

		   if(temp.getId()!=null){
			   Map<String, Object> m = new HashMap<String, Object>();
			   userArrangeCalendarDto.setProjarrangeDetailid(temp.getId());
			   //查询员工排班详情表数据
			   List<UserArrangeCalendarDto> userArrangeCalendarMiniDaoDtolist = getUserArrangeD(userArrangeCalendarDto);
			   for (int i = 0; i < calendaridArr.length; i++) {
				   	for (int j = 0; j < userArrangeCalendarMiniDaoDtolist.size(); j++) {
						if(calendaridArr[i].equals(userArrangeCalendarMiniDaoDtolist.get(j).getCalendarid())){
							if(shiftIdList.contains(userArrangeCalendarMiniDaoDtolist.get(j).getShiftid())){
								m.put(calendaridArr[i], userArrangeCalendarMiniDaoDtolist.get(j).getShiftid());
							}/*else if(shiftIdListDT.contains(userArrangeCalendarMiniDaoDtolist.get(j).getShiftid())){
								m.put(calendaridArr[i], shiftIdMapDT.get(userArrangeCalendarMiniDaoDtolist.get(j).getShiftid()));
							}*/
						}
					}
			   }
			   extMap.put(temp.getId(), m);
		   }else{
			   Map<String, Object> m0 = new HashMap<String, Object>();
			   //String myId=String.valueOf((int)(Math.random()*100));
			   String myId=GetUUID.generate();
			   temp.setId(myId);
			   extMap.put(temp.getId(), m0);
		   }
		}
		long end = System.currentTimeMillis();
		//System.out.println(end-start);
		if(extMap.size()==0){
			TagUtil.datagrid(response, dataGrid);
		}else{
			TagUtil.datagrid(response, dataGrid,extMap);
		}
		
		
	}
	
	/**
	 * 员工排班上报数据主页面
	 * easyui AJAX请求数据
	 * 
	 * @param request
	 * @param response
	 * @param dataGrid
	 * @param user
	 */

	@RequestMapping(params = "datagridAll")
	public void datagridAll(ProjArrangeDetailAndUserDto projArrangeDetailAndUserDto,HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
		long start = System.currentTimeMillis();
		UserArrangeCalendarDto userArrangeCalendarDto=new UserArrangeCalendarDto();
		int s=dataGrid.getField().indexOf("userid")+7;
		int e=dataGrid.getField().indexOf("workingDays")-1;
	
		//日期列名数组即主键id
		String[] calendaridArr=dataGrid.getField().substring(s, e).split(",");
		//String calendarid="";
		List<String> calendaridList=new ArrayList<String>();
		for (int i = 0; i < calendaridArr.length; i++) {
			calendaridList.add(calendaridArr[i]);
		}
		if(calendaridList.size()>0){
			userArrangeCalendarDto.setCalendaridList(calendaridList);
		}
		
		projArrangeDetailAndUserDto.setYearmonth(request.getParameter("yearmonth"));
		String pid=request.getParameter("pid");
		if(pid!=null&&pid.length()>0){
			pid=pid.split(",")[0];
		}
		projArrangeDetailAndUserDto.setPid(pid);
		
		projArrangeDetailAndUserDto.setUserName(request.getParameter("usernamesearch"));
		
		//包括该项目id
		//根据项目id查询所有子节点id
		List<String> ChildIdList=userDepartOrgDealServiceI.getChildIdByProjectDepartId(pid);
		projArrangeDetailAndUserDto.setChildDepartIdList(ChildIdList);
		String authSql = JeecgDataAutorUtils.loadDataSearchConditonSQLString();
		//查询项目排班详细表数据
		List<ProjArrangeDetailAndUserDto> projArrangeDetailAndUserDtolist = projarrangeDetailService.getProjArrangeDetailAndUserByPIdYearMonth(
				projArrangeDetailAndUserDto,authSql);
		dataGrid.setResults(projArrangeDetailAndUserDtolist);
		
		//班次名称如果被删除，则不用拼接此条数据
		//只查询启用的数据
		StringBuffer hql = new StringBuffer(" from ArrangeDutyEntity t where delete_flag <> '1' ");
		List<ArrangeDutyEntity> arrangeDutyEntityList = arrangeDutyService.findHql(hql.toString());
		List<String> shiftIdList=new ArrayList<String>();
		for (int i = 0; i < arrangeDutyEntityList.size(); i++) {
			shiftIdList.add(arrangeDutyEntityList.get(i).getId());
		}
		
		
		
		
		@SuppressWarnings("unchecked")
		List<ProjArrangeDetailAndUserDto> projectPostUserMiniDaoDtolistNew=dataGrid.getResults();
		Map<String,Map<String,Object>> extMap = new HashMap<String, Map<String,Object>>();
		for(ProjArrangeDetailAndUserDto temp:projectPostUserMiniDaoDtolistNew){
	      
		   if(temp.getId()!=null){
			   Map<String, Object> m = new HashMap<String, Object>();
			   userArrangeCalendarDto.setProjarrangeDetailid(temp.getId());
			   //查询员工排班详情表数据
			   List<UserArrangeCalendarDto> userArrangeCalendarMiniDaoDtolist=getUserArrangeD(userArrangeCalendarDto);
			   for (int i = 0; i < calendaridArr.length; i++) {
				   	for (int j = 0; j < userArrangeCalendarMiniDaoDtolist.size(); j++) {
						if(calendaridArr[i].equals(userArrangeCalendarMiniDaoDtolist.get(j).getCalendarid())){
							if(shiftIdList.contains(userArrangeCalendarMiniDaoDtolist.get(j).getShiftid())){
								m.put(calendaridArr[i], userArrangeCalendarMiniDaoDtolist.get(j).getShiftid());
							}/*else if(shiftIdListDT.contains(userArrangeCalendarMiniDaoDtolist.get(j).getShiftid())){
								m.put(calendaridArr[i], shiftIdMapDT.get(userArrangeCalendarMiniDaoDtolist.get(j).getShiftid()));
							}*/
						}
					}
			   }
			   extMap.put(temp.getId(), m);
		   }else{
			   Map<String, Object> m0 = new HashMap<String, Object>();
			   //String myId=String.valueOf((int)(Math.random()*100));
			   String myId=GetUUID.generate();
			   temp.setId(myId);
			   extMap.put(temp.getId(), m0);
		   }
		}
		long end = System.currentTimeMillis();
		//System.out.println(end-start);
		if(extMap.size()==0){
			TagUtil.datagrid(response, dataGrid);
		}else{
			TagUtil.datagrid(response, dataGrid,extMap);
		}
		
		
	}
	
	/**
	 * 查询员工排班详情表
	 * @author zbw
	 * 2017-10-26
	 * @param userArrangeCalendarMiniDaoDto
	 * @return
	 */
	@RequestMapping(params = "getUserArrangeD")
	@ResponseBody
	public List<UserArrangeCalendarDto> getUserArrangeD(UserArrangeCalendarDto userArrangeCalendarDto) {
		//AjaxJson j = new AjaxJson();
		String authSql = JeecgDataAutorUtils.loadDataSearchConditonSQLString();
		List<UserArrangeCalendarDto> userArrangeCalendarDtolist = projarrangeDetailService.getUserArrangeCalendar(
				userArrangeCalendarDto,authSql);
		return userArrangeCalendarDtolist;
		
	}
	
	
	
	

	/**
	 * 删除项目排班详细表
	 * 
	 * @return
	 */
	@RequestMapping(params = "doDel")
	@ResponseBody
	public AjaxJson doDel(ProjarrangeDetailEntity projarrangeDetail, HttpServletRequest request) {
		String message = null;
		AjaxJson j = new AjaxJson();
		projarrangeDetail = systemService.getEntity(ProjarrangeDetailEntity.class, projarrangeDetail.getId());
		message = "项目排班详细删除成功";
		try{
			projarrangeDetailService.delete(projarrangeDetail);
			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(",")){
				ProjarrangeDetailEntity projarrangeDetail = systemService.getEntity(ProjarrangeDetailEntity.class, 
				id
				);
				projarrangeDetailService.delete(projarrangeDetail);
				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(ProjarrangeDetailEntity projarrangeDetail, HttpServletRequest request) {
		String message = null;
		AjaxJson j = new AjaxJson();
		message = "项目排班详细添加成功";
		try{
			projarrangeDetailService.save(projarrangeDetail);
			systemService.addLog(message, Globals.Log_Type_INSERT, 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 = "doUpdate")
	@ResponseBody
	public AjaxJson doUpdate(ProjarrangeDetailEntity projarrangeDetail, HttpServletRequest request) {
		String message = null;
		AjaxJson j = new AjaxJson();
		message = "项目排班详细更新成功";
		ProjarrangeDetailEntity t = projarrangeDetailService.get(ProjarrangeDetailEntity.class, projarrangeDetail.getId());
		try {
			MyBeanUtils.copyBeanNotNull2Bean(projarrangeDetail, t);
			projarrangeDetailService.saveOrUpdate(t);
			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(ProjarrangeDetailEntity projarrangeDetail, HttpServletRequest req) {
		if (StringUtil.isNotEmpty(projarrangeDetail.getId())) {
			projarrangeDetail = projarrangeDetailService.getEntity(ProjarrangeDetailEntity.class, projarrangeDetail.getId());
			req.setAttribute("projarrangeDetailPage", projarrangeDetail);
		}
		return new ModelAndView("cn/com/lzt/projarrangedetail/projarrangeDetail-add");
	}
	/**
	 * 项目排班详细表编辑页面跳转
	 * 
	 * @return
	 */
	@RequestMapping(params = "goUpdate")
	public ModelAndView goUpdate(ProjarrangeDetailEntity projarrangeDetail, HttpServletRequest req) {
		if (StringUtil.isNotEmpty(projarrangeDetail.getId())) {
			projarrangeDetail = projarrangeDetailService.getEntity(ProjarrangeDetailEntity.class, projarrangeDetail.getId());
			req.setAttribute("projarrangeDetailPage", projarrangeDetail);
		}
		return new ModelAndView("cn/com/lzt/projarrangedetail/projarrangeDetail-update");
	}
	
	/**
	 * 导入功能跳转
	 * 
	 * @return
	 */
	@RequestMapping(params = "upload")
	public ModelAndView upload(HttpServletRequest req) {
		req.setAttribute("controller_name","projarrangeDetailController");
		return new ModelAndView("common/upload/pub_excel_upload");
	}
	
	/**
	 * 导出excel
	 * 
	 * @param request
	 * @param response
	 */
	@RequestMapping(params = "exportXls")
	public String exportXls(ProjarrangeDetailEntity projarrangeDetail,HttpServletRequest request,HttpServletResponse response
			, DataGrid dataGrid,ModelMap modelMap) {
		
		//获取用户名称
		List<DictEntity> baseUserList=systemService.queryDict("t_s_base_user", "id", "realname");
		Map<String, String> baseUserMap=new HashMap<String, String>();
		for (int i = 0; i < baseUserList.size(); i++) {
			baseUserMap.put(baseUserList.get(i).getTypecode(), baseUserList.get(i).getTypename());
		}
		//获取班次名称
		List<DictEntity> arrangeDutyList=systemService.queryDict("t_bus_arrange_duty", "id", "duty_name");
		Map<String, String> arrangeDutyMap=new HashMap<String, String>();
		for (int i = 0; i < arrangeDutyList.size(); i++) {
			arrangeDutyMap.put(arrangeDutyList.get(i).getTypecode(), arrangeDutyList.get(i).getTypename());
		}
		
		//获取项目岗位名称
		List<DictEntity> projectPostDetailList=systemService.queryDict("t_bus_project_post_detail", "id", "ptj_post_name");
		Map<String, String> projectPostDetailMap=new HashMap<String, String>();
		for (int i = 0; i < projectPostDetailList.size(); i++) {
			projectPostDetailMap.put(projectPostDetailList.get(i).getTypecode(), projectPostDetailList.get(i).getTypename());
		}
		
		//获取项目名称
		List<DictEntity> departList=systemService.queryDict("t_s_depart", "id", "departname");
		Map<String, String> departMap=new HashMap<String, String>();
		for (int i = 0; i < departList.size(); i++) {
			departMap.put(departList.get(i).getTypecode(), departList.get(i).getTypename());
		}
		String[] weekStr = new String[] {"一","二","三","四","五","六","日"};
		
		//日历id
		List<String> calendaridList=new ArrayList<String>();
		
		
		//标题   该list中用于存储标题的信息，每一个ExcelExportEntity 表示一列，根据List 的入栈顺序，由左至右，一次排序
        List<ExcelExportEntity> entityList = new ArrayList<ExcelExportEntity>();  
        String yearmonth=projarrangeDetail.getYearmonth();;
        CalendarAscDto calendarAscDto=new CalendarAscDto();
        if(projarrangeDetail.getYearmonth()!=null&&projarrangeDetail.getYearmonth().length()>0){
        	if(yearmonth.indexOf(",")!=-1){
        		yearmonth=projarrangeDetail.getYearmonth().split(",")[0];
        	}
        	calendarAscDto.setYear(Integer.parseInt(yearmonth.split("-")[0]));
			calendarAscDto.setMonth(Integer.parseInt(yearmonth.split("-")[1]));
        }else{
        	SimpleDateFormat simpleDateFormat=new SimpleDateFormat("yyy-MM");
			String[] dateNumber=simpleDateFormat.format(new Date()).split("-");
			calendarAscDto.setYear(Integer.parseInt(dateNumber[0]));
			calendarAscDto.setMonth(Integer.parseInt(dateNumber[1]));
        }
		List<CalendarAscDto> calendarAscDtoList=projarrangeDetailService.getCalendar(calendarAscDto);
		ExcelExportEntity head1=new ExcelExportEntity("项目名称", "pid", 15);
		entityList.add(head1); 
		ExcelExportEntity head2=new ExcelExportEntity("月度", "yearmonth", 15);
		entityList.add(head2); 
		ExcelExportEntity head3=new ExcelExportEntity("项目岗位", "pjtPostId", 15);
		entityList.add(head3); 
		ExcelExportEntity head4=new ExcelExportEntity("员工姓名", "userid", 15);
		entityList.add(head4); 
		for (int i = 0; i < calendarAscDtoList.size(); i++) {
			String monthTemp = String.valueOf(calendarAscDtoList.get(i).getMonth());
			String dayTemp = String.valueOf(calendarAscDtoList.get(i).getDay());
			String weekTemp = null;
	        if((calendarAscDtoList.get(i).getWeek() != null)){
	        	int weekInt= -1;
	        	try {
	        		weekInt =Integer.parseInt(calendarAscDtoList.get(i).getWeek());
	        	}catch(Exception e) {}
	        	if(weekInt > 0 && weekInt < 8) {
	        		weekTemp =  weekStr[weekInt-1];
	        	}
	        	
	        }
	        String headstr = null;
	        if(weekTemp == null) {
	        	headstr = monthTemp+"月"+dayTemp+"日";
	        }else {
	        	headstr = monthTemp+"月"+dayTemp+"日"+" 星期"+weekTemp+"";
	        }
			ExcelExportEntity head= new ExcelExportEntity(headstr, calendarAscDtoList.get(i).getId(), 15);
			entityList.add(head); 
			calendaridList.add(calendarAscDtoList.get(i).getId());
		}
		ExcelExportEntity head5=new ExcelExportEntity("上班天数(日)", "workingDays", 15);
		entityList.add(head5); 
		ExcelExportEntity head6=new ExcelExportEntity("超时加班(小时)", "timeOutOvertimeHours", 15);
		entityList.add(head6); 
		ExcelExportEntity head7=new ExcelExportEntity("国定加班(小时)", "countryOvertimeHours", 15);
		entityList.add(head7); 
		ExcelExportEntity head8=new ExcelExportEntity("值班天数(日)", "ondutyDays", 15);
		entityList.add(head8); 
		ExcelExportEntity head9=new ExcelExportEntity("备注", "remark", 15);
		entityList.add(head9); 
		
		
		 //组建数据集
        List<Map<String,Object>> dataResult = new ArrayList<Map<String,Object>>();  
        
        String pid=projarrangeDetail.getPid();
        if(pid.equals(",")){
        	pid=null;
        }
		if(pid!=null&&pid.split(",").length>0){
			pid=pid.split(",")[0];
		}
		
		//班次名称如果被删除，则不用拼接此条数据
		//只查询启用的数据
		StringBuffer hql = new StringBuffer(" from ArrangeDutyEntity t where delete_flag <> '1' ");
		List<ArrangeDutyEntity> arrangeDutyEntityList = arrangeDutyService.findHql(hql.toString());
		List<String> shiftIdList=new ArrayList<String>();
		for (int i = 0; i < arrangeDutyEntityList.size(); i++) {
			shiftIdList.add(arrangeDutyEntityList.get(i).getId());
		}
        
		String projectname = departMap.get(pid);
		//包括该项目id
		//根据项目id查询所有子节点id
		List<String> ChildIdList=userDepartOrgDealServiceI.getChildIdByProjectDepartId(pid);
		ProjArrangeDetailAndUserDto projArrangeDetailAndUserDto=new ProjArrangeDetailAndUserDto();
		projArrangeDetailAndUserDto.setChildDepartIdList(ChildIdList);
		projArrangeDetailAndUserDto.setYearmonth(yearmonth);
		projArrangeDetailAndUserDto.setPid(pid);
		String authSql = JeecgDataAutorUtils.loadDataSearchConditonSQLString();
		//查询项目排班详细表数据
		List<ProjArrangeDetailAndUserDto> projArrangeDetailAndUserDtolist = projarrangeDetailService.getProjArrangeDetailAndUserByPIdYearMonth(
				projArrangeDetailAndUserDto,authSql);
        
		UserArrangeCalendarDto userArrangeCalendarDto=new UserArrangeCalendarDto();
		for(int i=0;i<projArrangeDetailAndUserDtolist.size();i++){
			Map<String, Object> map = new HashMap<String, Object>();  
			map.put("pid", departMap.get(projArrangeDetailAndUserDtolist.get(i).getPid()));
			map.put("yearmonth", projArrangeDetailAndUserDtolist.get(i).getYearmonth());
			map.put("pjtPostId", projectPostDetailMap.get(projArrangeDetailAndUserDtolist.get(i).getPjtPostId()));
			map.put("userid", baseUserMap.get(projArrangeDetailAndUserDtolist.get(i).getUserid()));
			map.put("workingDays", projArrangeDetailAndUserDtolist.get(i).getWorkingDays());
			map.put("timeOutOvertimeHours", projArrangeDetailAndUserDtolist.get(i).getTimeOutOvertimeHours());
			map.put("countryOvertimeHours", projArrangeDetailAndUserDtolist.get(i).getCountryOvertimeHours());
			map.put("ondutyDays", projArrangeDetailAndUserDtolist.get(i).getOndutyDays());
			map.put("remark", projArrangeDetailAndUserDtolist.get(i).getRemark());
			
			
			if(projArrangeDetailAndUserDtolist.get(i).getId()!=null){
				userArrangeCalendarDto.setProjarrangeDetailid(projArrangeDetailAndUserDtolist.get(i).getId());
				userArrangeCalendarDto.setCalendaridList(calendaridList);
				//查询员工排班详情表数据
				List<UserArrangeCalendarDto> userArrangeCalendarDtolist=getUserArrangeD(userArrangeCalendarDto);
				for (int m = 0; m < calendarAscDtoList.size(); m++) {
					for (int k = 0; k < userArrangeCalendarDtolist.size(); k++) {
						if(calendarAscDtoList.get(m).getId().equals(userArrangeCalendarDtolist.get(k).getCalendarid())){
							if(shiftIdList.contains(userArrangeCalendarDtolist.get(k).getShiftid())){
								map.put(calendarAscDtoList.get(m).getId(), arrangeDutyMap.get(userArrangeCalendarDtolist.get(k).getShiftid()));
							}
						}
					}
				}
				
				
			}
			dataResult.add(map);  
		}
		/*for(ProjArrangeDetailAndUserDto projArrangeDetailAndUser:projArrangeDetailAndUserDtolist){
			Map<String, Object> map = new HashMap<String, Object>();  
			map.put("pid", departMap.get(projArrangeDetailAndUser.getPid()));
			map.put("yearmonth", projArrangeDetailAndUser.getYearmonth());
			map.put("pjtPostId", projectPostDetailMap.get(projArrangeDetailAndUser.getPjtPostId()));
			map.put("userid", baseUserMap.get(projArrangeDetailAndUser.getUserid()));
			map.put("workingDays", projArrangeDetailAndUser.getWorkingDays());
			map.put("timeOutOvertimeHours", projArrangeDetailAndUser.getTimeOutOvertimeHours());
			map.put("countryOvertimeHours", projArrangeDetailAndUser.getCountryOvertimeHours());
			map.put("ondutyDays", projArrangeDetailAndUser.getOndutyDays());
			map.put("remark", projArrangeDetailAndUser.getRemark());
			
			
			if(projArrangeDetailAndUser.getId()!=null){
				userArrangeCalendarDto.setProjarrangeDetailid(projArrangeDetailAndUser.getId());
				userArrangeCalendarDto.setCalendaridList(calendaridList);
				//查询员工排班详情表数据
				List<UserArrangeCalendarDto> userArrangeCalendarDtolist=getUserArrangeD(userArrangeCalendarDto);
				for (int i = 0; i < calendarAscDtoList.size(); i++) {
					for (int j = 0; j < userArrangeCalendarDtolist.size(); j++) {
						if(calendarAscDtoList.get(i).getId().equals(userArrangeCalendarDtolist.get(j).getCalendarid())){
							if(shiftIdList.contains(userArrangeCalendarDtolist.get(j).getShiftid())){
								map.put(calendarAscDtoList.get(i).getId(), arrangeDutyMap.get(userArrangeCalendarDtolist.get(j).getShiftid()));
							}
						}
					}
				}
				
				
			}
			dataResult.add(map);  
		}*/
		
		modelMap.put(MapExcelConstants.ENTITY_LIST, entityList);  
        modelMap.put(MapExcelConstants.MAP_LIST, dataResult);
		modelMap.put(NormalExcelConstants.FILE_NAME,"项目排班详细-"+projectname);
		modelMap.put(NormalExcelConstants.PARAMS,new ExportParams("项目排班详细列表", "导出人:"+ResourceUtil.getSessionUser().getRealName(),
			"导出信息"));
//		return NormalExcelConstants.JEECG_EXCEL_VIEW;
//        return MapExcelConstants.JEECG_MAP_EXCEL_VIEW;  
		return "hglexcelview";
	}
	
	/**
	 * 导出excel模板
	 * 
	 * @param request
	 * @param response
	 */
	@RequestMapping(params = "exportXlsTemplate")
	public String exportXlsTemplateForArrange(ProjarrangeDetailEntity projarrangeDetail,HttpServletRequest request,HttpServletResponse response
			, DataGrid dataGrid,ModelMap modelMap) {
		
        String pid=projarrangeDetail.getPid();

        if(pid.equals(",")){
        	pid=null;
        }
		if(pid!=null&&pid.split(",").length>0){
			pid=pid.split(",")[0];
		}

		//获取项目名称
		TSDepart depart = systemService.findUniqueByProperty(TSDepart.class, "id", pid);
		String[] weekStr = new String[] {"一","二","三","四","五","六","日"};
		
		//日历id
		List<String> calendaridList=new ArrayList<String>();
		
		
		//标题   该list中用于存储标题的信息，每一个ExcelExportEntity 表示一列，根据List 的入栈顺序，由左至右，一次排序
        List<ExcelExportEntity> entityList = new ArrayList<ExcelExportEntity>();  
        String yearmonth=projarrangeDetail.getYearmonth();;
        CalendarAscDto calendarAscDto=new CalendarAscDto();
        if(projarrangeDetail.getYearmonth()!=null&&projarrangeDetail.getYearmonth().length()>0){
        	if(yearmonth.indexOf(",")!=-1){
        		yearmonth=projarrangeDetail.getYearmonth().split(",")[0];
        	}
        	calendarAscDto.setYear(Integer.parseInt(yearmonth.split("-")[0]));
			calendarAscDto.setMonth(Integer.parseInt(yearmonth.split("-")[1]));
        }else{
        	SimpleDateFormat simpleDateFormat=new SimpleDateFormat("yyy-MM");
			String[] dateNumber=simpleDateFormat.format(new Date()).split("-");
			calendarAscDto.setYear(Integer.parseInt(dateNumber[0]));
			calendarAscDto.setMonth(Integer.parseInt(dateNumber[1]));
        }
		List<CalendarAscDto> calendarAscDtoList=projarrangeDetailService.getCalendar(calendarAscDto);
		ExcelExportEntity head1=new ExcelExportEntity("项目名称", "pid", 15);
		entityList.add(head1); 
		ExcelExportEntity head2=new ExcelExportEntity("月度", "yearmonth", 15);
		entityList.add(head2); 
		ExcelExportEntity head3=new ExcelExportEntity("项目岗位", "pjtPostId", 15);
		entityList.add(head3); 
		ExcelExportEntity head4=new ExcelExportEntity("员工姓名", "userid", 15);
		entityList.add(head4); 
		for (int i = 0; i < calendarAscDtoList.size(); i++) {
			String monthTemp = String.valueOf(calendarAscDtoList.get(i).getMonth());
			String dayTemp = String.valueOf(calendarAscDtoList.get(i).getDay());
			String weekTemp = null;
	        if((calendarAscDtoList.get(i).getWeek() != null)){
	        	int weekInt= -1;
	        	try {
	        		weekInt =Integer.parseInt(calendarAscDtoList.get(i).getWeek());
	        	}catch(Exception e) {}
	        	if(weekInt > 0 && weekInt < 8) {
	        		weekTemp =  weekStr[weekInt-1];
	        	}
	        	
	        }
	        String headstr = null;
	        if(weekTemp == null) {
	        	headstr = monthTemp+"月"+dayTemp+"日";
	        }else {
	        	headstr = monthTemp+"月"+dayTemp+"日"+" 星期"+weekTemp+"";
	        }
			ExcelExportEntity head= new ExcelExportEntity(headstr, calendarAscDtoList.get(i).getId(), 15);
			entityList.add(head); 
			calendaridList.add(calendarAscDtoList.get(i).getId());
		}
		
		
		 //组建数据集
        List<Map<String,Object>> dataResult = new ArrayList<Map<String,Object>>();  
        
		String hqlDute = " from ArrangeDutyEntity where pid =? or pid is null and delete_flag <> '1' ";
		List<ArrangeDutyEntity> pArrangeList = systemService.findHql(hqlDute, pid);
		List<String> pArrangeNamelist = new ArrayList<String>();
		for(ArrangeDutyEntity arrange : pArrangeList) {
			pArrangeNamelist.add(arrange.getDutyName());
		}
		
        
		String projectname = depart.getDepartname();
		//包括该项目id
		//根据项目id查询所有子节点id
		List<String> ChildIdList=userDepartOrgDealServiceI.getChildIdByProjectDepartId(pid);
		ProjArrangeDetailAndUserDto projArrangeDetailAndUserDto=new ProjArrangeDetailAndUserDto();
		projArrangeDetailAndUserDto.setChildDepartIdList(ChildIdList);
		projArrangeDetailAndUserDto.setYearmonth(yearmonth);
		projArrangeDetailAndUserDto.setPid(pid);
		//获取最新的人员与岗位匹配数据，预置到模板中
		String projPostHistory = "SELECT\n" + 
				"	detail.userid as  userid ,post.ptj_post_name as postname\n" + 
				"FROM\n" + 
				"	 (\n" + 
				"	SELECT\n" + 
				"		userid,max(yearmonth) as yearmonth\n" + 
				"	FROM\n" + 
				"		t_bus_projarrange_detail detail\n" + 
				"	WHERE\n" + 
				"		detail.pid  =? \n" +
				"	group by userid )temp \n" + 
				"left join t_bus_projarrange_detail detail on temp.userid = detail.userid and temp.yearmonth = detail.yearmonth \n" + 
				" left join t_bus_project_post_detail post on post.id = detail.pjt_postid";
		List<Map<String,Object>> userPostRes = systemService.findForJdbc(projPostHistory,pid);
		HashMap<String,String> userPostMap = new HashMap<String, String>();
		for(Map<String,Object> userPost : userPostRes){
			userPostMap.put(userPost.get("userid").toString(), userPost.get("postname").toString());
		}
		//查询此项目所有当前在职人员
		//人员姓名＋身份证后四位，避免重复
		String userSql = 
				"select  user.id as userid,  concat(realname,right(idcard,4)) as realname \n" + 
				"from t_s_base_user user left join t_s_user su on su.id = user.id \n" + 
				"left join t_s_user_org uorg on user.id = uorg.user_id  and uorg.ifpluralism = '0'\n" + 
				"left join t_s_depart depart on depart.id = uorg.org_id\n" + 
				"left join t_s_depart pdepart on pdepart.id = depart.parentdepartid\n" + 
				"LEFT JOIN t_bus_user_personnel up ON up.userid = user.id \n"+
				"where up.position_status in ('1','2') and user.delete_flag = '0' and (pdepart.id =? or depart.id = ? ) "
				+ "order by  convert(user.realname using gbk) collate gbk_Chinese_ci asc";
		List<Map<String,Object>> userRes = systemService.findForJdbc(userSql, pid,pid);
		for(Map<String,Object> oneUser : userRes){
			Map<String, Object> map = new HashMap<String, Object>();  
			map.put("pid", depart.getDepartname());
			map.put("yearmonth", yearmonth);
			map.put("pjtPostId", userPostMap.get(oneUser.get("userid").toString()));
			map.put("userid", oneUser.get("realname"));
			dataResult.add(map);  
		}
		
		//查询项目所有岗位设置，做数据验证
		String hqlPost = " from ProjectPostDetailEntity where pid =?  and delete_flag <> '1' ";
		List<ProjectPostDetailEntity> postList = systemService.findHql(hqlPost, pid);
		List<String> postNameList = new ArrayList<String>();
		for(ProjectPostDetailEntity post : postList) {
			postNameList.add(post.getPtjPostName());
		}
		
		List<Map<String,Object>> validParamMap = new ArrayList<Map<String,Object>>();
		Map<String,Object> paramArrange = new HashMap<String, Object>();
		paramArrange.put(HGLExcelConstant.VALIDTIONSTRS, pArrangeNamelist);
		paramArrange.put(HGLExcelConstant.FIRSTROW,3);
		paramArrange.put(HGLExcelConstant.FIRSTCOL,4);
		paramArrange.put(HGLExcelConstant.ENDROW,dataResult.size()+2);
		paramArrange.put(HGLExcelConstant.ENDCOL,entityList.size()-1);
		validParamMap.add(paramArrange);
		
		Map<String,Object> paramPost = new HashMap<String, Object>();
		paramPost.put(HGLExcelConstant.VALIDTIONSTRS, postNameList);
		paramPost.put(HGLExcelConstant.FIRSTROW,3);
		paramPost.put(HGLExcelConstant.FIRSTCOL,2);
		paramPost.put(HGLExcelConstant.ENDROW,dataResult.size()+2);
		paramPost.put(HGLExcelConstant.ENDCOL,2);
		validParamMap.add(paramPost);
		
//		
//		modelMap.put(HGLExcelConstant.VALIDTIONSTRS, pArrangeNamelist);
//		modelMap.put(HGLExcelConstant.FIRSTROW,3);
//		modelMap.put(HGLExcelConstant.FIRSTCOL,4);
//		modelMap.put(HGLExcelConstant.ENDROW,dataResult.size()+2);
//		modelMap.put(HGLExcelConstant.ENDCOL,entityList.size()-1);
		modelMap.put(HGLExcelConstant.VALIDPARAM, validParamMap);
		modelMap.put(HGLExcelConstant.CHECKPARAM,yearmonth);
		modelMap.put(MapExcelConstants.ENTITY_LIST, entityList);  
        modelMap.put(MapExcelConstants.MAP_LIST, dataResult);
		modelMap.put(NormalExcelConstants.FILE_NAME,"项目排班模板-"+projectname+"-"+yearmonth);
		ExportParams exportp = new ExportParams("项目排班模板-"+projectname+"-"+yearmonth, "导出人:"+ResourceUtil.getSessionUser().getRealName(),
				"导出信息");
		exportp.setType(ExcelType.XSSF);
		modelMap.put(NormalExcelConstants.PARAMS,exportp);
		return HGLExcelConstant.HGL_MAP_EXCEL_VIEW;
	}
	/**
	 * 导出excel 使模板
	 * 
	 * @param request
	 * @param response
	 */
	@RequestMapping(params = "exportXlsByT")
	public String exportXlsByT(ProjarrangeDetailEntity projarrangeDetail,HttpServletRequest request,HttpServletResponse response
			, DataGrid dataGrid,ModelMap modelMap) {
    	modelMap.put(NormalExcelConstants.FILE_NAME,"项目排班详细");
    	modelMap.put(NormalExcelConstants.CLASS,ProjarrangeDetailEntity.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 {
				String checkMsg = HGLExcelImportUtils.getCheckMsg(file.getInputStream(), 2, 0, 0);
				if(checkMsg.equals("false")) {
					j.setMsg("文件校验失败，必须上传系统导出的excel模板，请点击【导出排班模板】排班后再上传");
					j.setSuccess(false);
					return j;
				}
				HGLExcelResult exceldata = HGLExcelImportUtils.getDataFromExcel(file.getInputStream(), 2, 1);
				String month = exceldata.getDataList().get(0).get(1);
				if(!month.equals(checkMsg)) {
					j.setMsg("文件月份校验失败，请先选择【排班月度】后点击【导出排班模板】，然后排班上传文件");
					j.setSuccess(false);
					return j;
				}
				TSDepart depart = systemService.findUniqueByProperty(TSDepart.class, "departname", exceldata.getDataList().get(0).get(0));
				String pid = depart.getId();
				if(depart == null) {
					j.setMsg("项目名称错误，无法匹配系统所属部门档案");
					j.setSuccess(false);
					return j;
				}
				List<ProjArrangeGeneralEntity> proGeneralL = systemService.findHql(
						" from ProjArrangeGeneralEntity where belongUnitid =? and yearmonth = ? ", pid,month);
//				List<String> headList = exceldata.getHeaderList();
				ProjArrangeGeneralEntity projGeneral = null;
				if(proGeneralL.size() > 0) {
					projGeneral = proGeneralL.get(0);
					if(projGeneral.getArrangeDutyStatus().equals(Globals.ARRANGESTATUS_2)) {
						j.setSuccess(false);
						j.setMsg("文件导入失败，排班已上报，不允许修改");
						return j;
					}
				}
				TSUser user = ResourceUtil.getSessionUser();
				List<Map<String,Object>> res = systemService.findForJdbc(
						"select count(*) count from t_s_user_org uo  where uo.user_id =? and uo.org_id = ? ",user.getId(),pid);
				if((Long)res.get(0).get("count") == 0) {
					j.setSuccess(false);
					j.setMsg("文件导入失败，用户【"+user.getRealName()+"】没有项目【"+depart.getDepartname()+"】管理权限，不允许导入");
					return j;
				}
				//缓存项目岗位
				String hqlPost = " from ProjectPostDetailEntity where pid =?  and delete_flag <> '1' ";
				List<ProjectPostDetailEntity> postList = systemService.findHql(hqlPost, pid);
				Map<String, String> projectPostDetailMap=new HashMap<String, String>();
				Map<String, Integer> postdutyNumMap=new HashMap<String, Integer>();
				for(ProjectPostDetailEntity post : postList) {
					projectPostDetailMap.put(post.getPtjPostName(), post.getId());
					postdutyNumMap.put(post.getPtjPostName(), post.getNeedNumber());
				}
				//缓存班次map
				String hqlDute = " from ArrangeDutyEntity where pid =? or pid is null and delete_flag <> '1' ";
				List<ArrangeDutyEntity> pArrangeList = systemService.findHql(hqlDute, pid);
				HashMap<String,String> pArrangeMap = new HashMap<String, String>();
				for(ArrangeDutyEntity arrange : pArrangeList) {
					pArrangeMap.put(arrange.getDutyName(), arrange.getId());
				}
				String checkResult = checkArrange(exceldata,pArrangeMap,projectPostDetailMap,postdutyNumMap);
				if(StringUtils.isNotEmpty(checkResult)) {
					j.setSuccess(false);
					j.setMsg("文件导入失败，排班内容错误，清单如下：<br>"+checkResult);
					return j;
				}
				//缓存日历，把excel中的所有日历都查询出来
				HashMap<String, String> calMap = new HashMap<String, String>();
				for(int i = 0 ; i < exceldata.getHeaderList().size(); i++) {
					String colTitle = exceldata.getHeaderList().get(i);
					if(colTitle.indexOf("月") > -1 && colTitle.indexOf("日") > -1) {
						String titleMonth = colTitle.substring(0, colTitle.indexOf("月"));
						String titleDay = colTitle.substring(colTitle.indexOf("月")+1, colTitle.indexOf("日"));
						List<CalendarEntity> calList = systemService.findHql(
								" from CalendarEntity where month =? and year =? and day =? ",
								Integer.parseInt(titleMonth) ,Integer.parseInt(month.substring(0,4)),Integer.parseInt(titleDay));
						calMap.put(colTitle,calList.get(0).getId());
					}
				}
				//缓存项目人员
				HashMap<String,String> userMap = new HashMap<String, String>();
				String userSql = "select  user.id as userid,  concat(realname,right(idcard,4)) as realname \n" + 
						"from t_s_base_user user left join t_s_user su on su.id = user.id \n" + 
						"left join t_s_user_org uorg on user.id = uorg.user_id  and uorg.ifpluralism = '0'\n" + 
						"left join t_s_depart depart on depart.id = uorg.org_id\n" + 
						"left join t_s_depart pdepart on pdepart.id = depart.parentdepartid\n" + 
						"LEFT JOIN t_bus_user_personnel up ON up.userid = user.id \n"+
						"where up.position_status in ('1','2') and user.delete_flag = '0' and pdepart.id =? or depart.id =? ";
				List<Map<String,Object>> userRes = systemService.findForJdbc(userSql, pid,pid);
				for(Map<String,Object> oneRes :userRes) {
					userMap.put(oneRes.get("realname").toString(),oneRes.get("userid").toString());
				}
				
				
//				List<ProjArrangeGeneralEntity> proGeneralL = systemService.findHql(" from ProjArrangeGeneralEntity where belongUnitid = ? and yearmonth = ?", pid,month);
				List<String> headList = exceldata.getHeaderList();
				if(null != projGeneral) {
//					projGeneral = proGeneralL.get(0);
//					if(!projGeneral.getArrangeDutyStatus().equals(Globals.ARRANGESTATUS_0)) {
//						j.setSuccess(false);
//						j.setMsg("文件导入失败，排班已上报，不允许修改");
//						return j;
//					}
					List<ProjarrangeDetailEntity> details = systemService.findByProperty(ProjarrangeDetailEntity.class, "projarrangeGeneralid", projGeneral.getId());
					HashMap<String ,ProjarrangeDetailEntity> projMap = new HashMap<String, ProjarrangeDetailEntity>();
					for(ProjarrangeDetailEntity projentity : details) {
						projMap.put(projentity.getUserid(), projentity);
					}
					for(List<String> data: exceldata.getDataList()) {
						Map<String, Object> myMap = new HashMap<String, Object>();
						for(int i = 4 ; i < data.size(); i++) {
							if(!pArrangeMap.containsKey(data.get(i)))
								continue;
							myMap.put(calMap.get(headList.get(i)), pArrangeMap.get(data.get(i)));
						}
						if(projMap.get(userMap.get(data.get(3))) != null ){
							ProjarrangeDetailEntity projarrangeDetailEntity=arrangeDutyAndOndutyServiceI.getDayAndTimeFO(projMap.get(userMap.get(data.get(3))),myMap);
							arrangeDutyAndOndutyServiceI.saveProjarrangeDetail(projarrangeDetailEntity, myMap, Globals.ARRANGESTATUS_0);
						}else if(userMap.containsKey(data.get(3))) {
							importSaveDetail(projGeneral, userMap, projectPostDetailMap, data, calMap, pArrangeMap, month, pid, headList);
						}
					}
				}else {
					String xiuxi = arrangeDutyService.getDUTYTYPE_xiuxiId();
					//没有排班
					projGeneral = new ProjArrangeGeneralEntity();
					projGeneral.setBelongUnitid(pid);
					projGeneral.setYearmonth(month);
					projGeneral.setArrangeDutyStatus("0");
					systemService.save(projGeneral);
					for(List<String> data: exceldata.getDataList()) {
						if(userMap.containsKey(data.get(3))) {
							importSaveDetail(projGeneral, userMap, projectPostDetailMap, data, calMap, pArrangeMap, month, pid, headList);
						}
					}
				}
				j.setMsg("文件导入成功！");
			} catch (Exception e) {
				j.setMsg("文件导入失败！");
				logger.error(ExceptionUtil.getExceptionMessage(e));
			}finally{
				try {
					file.getInputStream().close();
				} catch (IOException e) {
					e.printStackTrace();
				}
			}
		}
		return j;
	}
		
	private void importSaveDetail(ProjArrangeGeneralEntity projGeneral, HashMap<String,String> userMap,Map<String, String> projectPostDetailMap,
			List<String> data,HashMap<String, String> calMap,HashMap<String,String> pArrangeMap,String month,String pid, List<String>headList) throws Exception {
		ProjarrangeDetailEntity projentity = new ProjarrangeDetailEntity();
		projentity.setProjarrangeGeneralid(projGeneral.getId());
		projentity.setPjtPostId(projectPostDetailMap.get(data.get(2)));
		projentity.setUserid(userMap.get(data.get(3)));
		projentity.setYearmonth(month);
		projentity.setPid(pid);
		Map<String, Object> myMap = new HashMap<String, Object>();
		for(int i = 4 ; i < data.size(); i++) {
			if(!pArrangeMap.containsKey(data.get(i)))
				continue;
			myMap.put(calMap.get(headList.get(i)), pArrangeMap.get(data.get(i)));
		}
		//
		projentity=arrangeDutyAndOndutyServiceI.getDayAndTimeFO(projentity,myMap);
		arrangeDutyAndOndutyServiceI.saveProjarrangeDetail(projentity, myMap, Globals.ARRANGESTATUS_0);
	}
	/**
	 * 校验必输项
	 * 检查是否超出岗位设置人数限制
	 * */
	private String checkArrange(HGLExcelResult exceldata,Map<String,String> arrangeMap,Map<String,String> postMap,Map<String, Integer> postdutyNumMap) {
		StringBuffer unFormatStr = new StringBuffer();
		List<String> headList = exceldata.getHeaderList();
		List<List<String>> dataList = exceldata.getDataList();
		for(int i = 0 ; i < dataList.size() ; i++) {
			List<String> arrangeData = dataList.get(i);
			for(int j = 4; j < arrangeData.size(); j ++) {
				if(StringUtils.isEmpty(arrangeData.get(j))) {
					unFormatStr.append("【"+arrangeData.get(3)+"】"+headList.get(j)+"未排班;<br>");
				}
				else if(!arrangeMap.containsKey(arrangeData.get(j))) {
					unFormatStr.append("【"+arrangeData.get(3)+"】"+headList.get(j)+"班次【"+arrangeData.get(j)+"】不存在;<br>");
				}
			}
			if(StringUtils.isEmpty(arrangeData.get(2))) {
				unFormatStr.append("【"+arrangeData.get(3)+"】项目岗位不能为空;<br>");
			}
			else if(!postMap.containsKey(arrangeData.get(2))) {
				unFormatStr.append("【"+arrangeData.get(3)+"】项目岗位【"+arrangeData.get(2)+"】不存在;<br>");
			}else{
				postdutyNumMap.put(arrangeData.get(2), postdutyNumMap.get(arrangeData.get(2))-1);
			}
		}
		for (Entry<String,Integer> post : postdutyNumMap.entrySet()) {
			if(post.getValue() < 0) {
				unFormatStr.append("【"+post.getKey()+"】项目岗位超出岗位编制人数<br>");
			}
		}
		
		return unFormatStr.toString();
	}
	@RequestMapping(method = RequestMethod.GET)
	@ResponseBody
	public List<ProjarrangeDetailEntity> list() {
		List<ProjarrangeDetailEntity> listProjarrangeDetails=projarrangeDetailService.getList(ProjarrangeDetailEntity.class);
		return listProjarrangeDetails;
	}
	
	@RequestMapping(value = "/{id}", method = RequestMethod.GET)
	@ResponseBody
	public ResponseEntity<?> get(@PathVariable("id") String id) {
		ProjarrangeDetailEntity task = projarrangeDetailService.get(ProjarrangeDetailEntity.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 ProjarrangeDetailEntity projarrangeDetail, UriComponentsBuilder uriBuilder) {
		//调用JSR303 Bean Validator进行校验，如果出错返回含400错误码及json格式的错误信息.
		Set<ConstraintViolation<ProjarrangeDetailEntity>> failures = validator.validate(projarrangeDetail);
		if (!failures.isEmpty()) {
			return new ResponseEntity(BeanValidators.extractPropertyAndMessage(failures), HttpStatus.BAD_REQUEST);
		}

		//保存
		try{
			projarrangeDetailService.save(projarrangeDetail);
		} catch (Exception e) {
			e.printStackTrace();
			return new ResponseEntity(HttpStatus.NO_CONTENT);
		}
		//按照Restful风格约定，创建指向新任务的url, 也可以直接返回id或对象.
		String id = projarrangeDetail.getId();
		URI uri = uriBuilder.path("/rest/projarrangeDetailController/" + 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 ProjarrangeDetailEntity projarrangeDetail) {
		//调用JSR303 Bean Validator进行校验，如果出错返回含400错误码及json格式的错误信息.
		Set<ConstraintViolation<ProjarrangeDetailEntity>> failures = validator.validate(projarrangeDetail);
		if (!failures.isEmpty()) {
			return new ResponseEntity(BeanValidators.extractPropertyAndMessage(failures), HttpStatus.BAD_REQUEST);
		}

		//保存
		try{
			projarrangeDetailService.saveOrUpdate(projarrangeDetail);
		} 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) {
		projarrangeDetailService.deleteEntityById(ProjarrangeDetailEntity.class, id);
	}
	
	/**
	 * 前端获取日历表json数据
	 * @author zbw
	 * 2017-10-24
	 * @param calendar
	 * @param request
	 * @param response
	 * @return
	 */
	/*@RequestMapping(params = "getCalendar")
	@ResponseBody
	public AjaxJson getCalendar(CalendarEntity calendar, HttpServletRequest request, HttpServletResponse response) {
		AjaxJson j = new AjaxJson();
		DataGrid dataGrid=new DataGrid();
		dataGrid.setField("id,year,month,day,week,createName,createBy,createDate,updateName,updateBy,updateDate,sysOrgCode,sysCompanyCode,");
		
		CriteriaQuery cq = new CriteriaQuery(CalendarEntity.class,dataGrid);
		//查询条件组装器
		//org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, calendar, request.getParameterMap());
		org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, calendar, request.getParameterMap());
		try{
		//自定义追加查询条件
		cq.eq("year", calendar.getYear());
		cq.eq("month", calendar.getMonth());
		//排序
		Map<String, Object> map = new HashMap<String, Object>();
		map.put("day", "asc");
		cq.setOrder(map);
		//排序
		}catch (Exception e) {
			throw new BusinessException(e.getMessage());
		}
		cq.add();
		List<CalendarEntity> list=this.calendarService.getDataGridReturn(cq, true).getRows();
		Map<String, Object> myMap=new HashMap<String, Object>();
		myMap.put("0", list);
		j.setAttributes(myMap);
		return j;
		
	}*/
	
	
	
	
	/**
	 * 员工排班保存总方法
	 * 
	 * @author zbw
	 * 2017-10-28
	 * @param strmap
	 * @param calendaridStr
	 * @param request
	 * @param response
	 * @return
	 */
	/*国定加班时长计算规则
	1.节假日区分=国定
	1.1国定加班时长=基准工时相加
	//1.2轮流加班班次时（轮流加班值班国家法定节假日不会出现，所以不考虑）
	
	超时加班时长计算规则
	
	2.1.超时加班时长=月度国定节假日以外所有班次的基准工时-月度法定工作日天数*8
	2.2.轮流加班班次时：超时加班时长相加
	
	值班天数计算规则
	值班天数=班次类型为值班时天数相加
	
	3上班天数计算规则
	3.1上班天数=班次类型为常班，日班，夜班时天数相加*/
	@RequestMapping(params = "saveRows")
	@ResponseBody
	public AjaxJson saveRows(String strmap,String calendaridStr,String yearmonth,String pid,String arrangeDutyStatus,
			HttpServletRequest request, HttpServletResponse response){
		AjaxJson j = new AjaxJson();
		if(pid!=null&&pid.length()>0){
			pid=pid.split(",")[0];
		}
		JSONArray jsonArray = JSONArray.fromObject(strmap); // 首先把字符串转成 JSONArray  对象
		for (int k = 0; k < jsonArray.size(); k++) {
			//每一行的键值数据
			Map<String, Object> map=jsonArray.getJSONObject(k);
			
			//日期calendarId
			String[] calendaridArr=calendaridStr.split(",");
			//List<String> calendarIdList=extractIdListByComma(calendaridStr);
			//只有日期和班次键值数据
			Map<String, Object>  myMap=new HashMap<String, Object>();
			
			//所有班次信息
			//List<String> shiftList=new ArrayList<String>();
			
			for (int i = 0; i < calendaridArr.length; i++) {
				for (Entry<String,Object> entryParam : map.entrySet()) {
					//System.out.println("key="+entryParam.getKey()+",value="+entryParam.getValue());
					if(entryParam.getKey().equals(calendaridArr[i])){
						myMap.put(entryParam.getKey(), entryParam.getValue());
						//shiftList.add(entryParam.getValue().toString());
					}
				}
			}
			
			ProjarrangeDetailEntity projarrangeDetailEntity=new ProjarrangeDetailEntity();
			projarrangeDetailEntity.setId(map.get("id").toString());
			projarrangeDetailEntity.setPjtPostId(map.get("pjtPostId").toString());
			projarrangeDetailEntity.setUserid(map.get("userid").toString());
			projarrangeDetailEntity.setYearmonth(yearmonth);
			projarrangeDetailEntity.setPid(pid);
			
			try {
				//天数和时间算法
				projarrangeDetailEntity=arrangeDutyAndOndutyServiceI.getDayAndTimeFO(projarrangeDetailEntity,myMap);
				
				//项目排班详细表保存新增/更新的行数据
				j=arrangeDutyAndOndutyServiceI.saveProjarrangeDetail(projarrangeDetailEntity,myMap,arrangeDutyStatus);
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			
		}
		return j;
	}
	
	/**
	 * 验证班次停用启用状态
	 * @author zbw
	 * 2017-12-11
	 * @param strmap
	 * @param request
	 * @param response
	 * @return
	 */
	@RequestMapping(params = "checkShiftStatus")
	@ResponseBody
	public AjaxJson checkShiftStatus(String strmap,
			HttpServletRequest request, HttpServletResponse response){
		AjaxJson j = new AjaxJson();
		
		List<String> shiftIdList=new ArrayList<String>();
		
		JSONArray jsonArray = JSONArray.fromObject(strmap); // 首先把字符串转成 JSONArray  对象
		for (int k = 0; k < jsonArray.size(); k++) {
			//每一行的键值数据
			Map<String, Object> map=jsonArray.getJSONObject(k);
			for (Entry<String,Object> entryParam : map.entrySet()) {
				//System.out.println("key="+entryParam.getKey()+",value="+entryParam.getValue());
				if(!shiftIdList.contains(entryParam.getValue().toString())){
					shiftIdList.add(entryParam.getValue().toString());
				}
			}
		}
		
		//班次名称查询只查询删除和停用的数据
		StringBuffer hql = new StringBuffer(" from ArrangeDutyEntity t where  status = '1' ");
		List<ArrangeDutyEntity> arrangeDutyEntityListDT = arrangeDutyService.findHql(hql.toString());
		List<String> shiftIdListDT=new ArrayList<String>();
		Map<String, Object> shiftIdMapDT=new HashMap<String, Object>();
		for (int i = 0; i < arrangeDutyEntityListDT.size(); i++) {
			shiftIdListDT.add(arrangeDutyEntityListDT.get(i).getId());
			shiftIdMapDT.put(arrangeDutyEntityListDT.get(i).getId(), arrangeDutyEntityListDT.get(i).getDutyName());
		}
		String msg="";
		for (int i = 0; i < shiftIdList.size(); i++) {
			if(shiftIdListDT.contains(shiftIdList.get(i))){
				if(msg.length()!=0){
					msg+=","+shiftIdMapDT.get(shiftIdList.get(i)).toString();
				}else{
					msg=shiftIdMapDT.get(shiftIdList.get(i)).toString();
				}
			}
		}
		if(msg.length()!=0){
			msg+="为停用状态";
			j.setMsg(msg);
			j.setSuccess(false);
		}
	
		return j;

	}
	
	
	/**
	 * 上报总方法
	 * @author zbw
	 * 2017-12-8
	 * @param yearmonth
	 * @param pid
	 * @param request
	 * @param response
	 * @return
	 */
	@RequestMapping(params = "putOutProjarrange")
	@ResponseBody
	public AjaxJson putOutProjarrange(String yearmonth,String pid,
			HttpServletRequest request, HttpServletResponse response){
		AjaxJson j = new AjaxJson();
		if(pid!=null&&pid.length()>0){
			pid=pid.split(",")[0];
		}
		TSUser tSUser=ResourceUtil.getSessionUser();
		try {
			//查询项目排班总览表数据
			StringBuffer hql = new StringBuffer(" FROM ProjArrangeGeneralEntity where belongUnitid=? and yearmonth=? ");
			List<ProjArrangeGeneralEntity> projArrangeGeneralEntityList = systemService.findHql(hql.toString(),pid,yearmonth);
			if(projArrangeGeneralEntityList.size()>0){
				//查询项目排班详细表数据计算排班人数
				hql = new StringBuffer(" FROM ProjarrangeDetailEntity where pid=? and yearmonth=? ");
				List<ProjarrangeDetailEntity> projarrangeDetailEntityList = systemService.findHql(hql.toString(),pid,yearmonth);
				projArrangeGeneralEntityList.get(0).setPeopleQuantity(projarrangeDetailEntityList.size());
				projArrangeGeneralEntityList.get(0).setArrangeDutyStatus(Globals.ARRANGESTATUS_1);
				projArrangeGeneralEntityList.get(0).setReporterId(tSUser.getId());
			}
			systemService.saveOrUpdate(projArrangeGeneralEntityList.get(0));
			j.setSuccess(true);
			j.setMsg("操作成功");
		} catch (Exception e) {
			j.setMsg("操作失败");
			j.setSuccess(false);
			e.printStackTrace();
		}
	
		return j;

	}
	
	
	
	/**
	 * 月度排班总方法；
	 * @author zbw
	 * 2017-11-7
	 * @param arrangeDutyOperateId
	 * @param yearmonth
	 * @param pid
	 * @param arrangeDutyStatus
	 * @return
	 */
	@RequestMapping(params = "saveMonthArrangeDutyOperate")
	@ResponseBody
	public AjaxJson saveMonthArrangeDutyOperate(String arrangeDutyOperateId,String yearmonth,String pid,String arrangeDutyStatus){
		SimpleDateFormat simpleDateFormat=new SimpleDateFormat("yyy-MM-dd HH:mm:ss ms");
		AjaxJson j = new AjaxJson();
		if(pid!=null&&pid.length()>0){
			pid=pid.split(",")[0];
		}
		try {
			long start = System.currentTimeMillis();
			System.out.println(simpleDateFormat.format(new Date()));
			j=arrangeDutyAndOndutyServiceI.saveMonthArrangeDutyOperate(arrangeDutyOperateId, yearmonth, pid, arrangeDutyStatus);
			long end = System.currentTimeMillis();
			System.out.println(end-start);
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			j.setMsg("操作失败");
			j.setSuccess(false);
//			throw new BusinessException(e.getMessage());
			
			
		}
		return j;
	}
	
	/**
	 * 轮流值班排班总方法；
	 * @author zbw
	 * 2017-11-7
	 * @param arrangeDutyOperateId
	 * @param yearmonth
	 * @param pid
	 * @param arrangeDutyStatus
	 * @return
	 */
	@RequestMapping(params = "saveOndutyArrangeDutyOperate")
	@ResponseBody
	public AjaxJson saveOndutyArrangeDutyOperate(String onDutyOperateId,String yearmonth,String pid,String arrangeDutyStatus){
		AjaxJson j = new AjaxJson();
		if(pid!=null&&pid.length()>0){
			pid=pid.split(",")[0];
		}
		try {
			j=arrangeDutyAndOndutyServiceI.saveOndutyArrangeDutyOperate(onDutyOperateId, yearmonth, pid, arrangeDutyStatus);
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			j.setSuccess(false);
		}
		return j;
	}
	
	/**
	 * 异步验证是否已经上报，若已确认的话不能再次上报
	 * @author zbw
	 * 2017-11-28
	 * @param pid
	 * @param yearmonth
	 * @return
	 */
	@RequestMapping(params = "checkMonthArrangeDutyStatus")
	@ResponseBody
	public AjaxJson checkMonthArrangeDutyStatus(String pid,String yearmonth){
		AjaxJson j = new AjaxJson();
		if(pid!=null&&pid.length()>0){
			pid=pid.split(",")[0];
		}
		j=projarrangeDetailService.checkMonthArrangeDutyStatus(pid, yearmonth);
		return j;
	}
	
	/**
	 * 月度排班总方法；
	 * @author zbw
	 * 2017-11-7
	 * @param arrangeDutyOperateId
	 * @param yearmonth
	 * @param pid
	 * @param arrangeDutyStatus
	 * @return
	 */
	/*@RequestMapping(params = "saveMonthArrangeDutyOperate")
	@ResponseBody
	public AjaxJson saveOnDutyOperate(String onDutyOperateId,String yearmonth,String pid,String arrangeDutyStatus){
		AjaxJson j = new AjaxJson();
		if(pid!=null&&pid.length()>0){
			pid=pid.split(",")[0];
		}
		j=projarrangeDetailService.saveMonthArrangeDutyOperate(onDutyOperateId, yearmonth, pid, arrangeDutyStatus);
		return j;
	}*/
	
	/**
	 * 异步判断是否可以行编辑
	 * @author zbw
	 * 2017-11-12
	 * @param projarrangeDetailEntity
	 * @return
	 */
	@RequestMapping(params = "getCheckEdit")
	@ResponseBody
	public AjaxJson getCheckEdit(ProjarrangeDetailEntity projarrangeDetailEntity){
		AjaxJson j = new AjaxJson();
		//根据主键id和月度查询项目排班详细表数据
		StringBuffer hql = new StringBuffer(" from ProjarrangeDetailEntity t where t.id=? and t.yearmonth=? ");
		List<ProjarrangeDetailEntity> projarrangeDetailList = projarrangeDetailService.findHql(hql.toString()
				, projarrangeDetailEntity.getId(),projarrangeDetailEntity.getYearmonth());
		boolean flag=false;
		String runWay="";
		if(projarrangeDetailList.size()!=0){
			String userId=projarrangeDetailList.get(0).getUserid();
			//根据月度查询项目排班操作表数据
			hql = new StringBuffer(" from ArrangeDutyOperateEntity t where t.yearmonth=? ");
			List<ArrangeDutyOperateEntity> arrangeDutyOperateList = projarrangeDetailService.findHql(hql.toString()
					, projarrangeDetailEntity.getYearmonth());
			
			for (int i = 0; i < arrangeDutyOperateList.size(); i++) {
				 List<String> userIdList = extractIdListByComma(arrangeDutyOperateList.get(i).getUserid());
				 if(userIdList.contains(userId)){
//					 if(arrangeDutyOperateList.get(i).getRunway().equals(Globals.other_jijiabanfei)||
//							 arrangeDutyOperateList.get(i).getRunway().equals(Globals.other_wujiabanfei)||
//							 arrangeDutyOperateList.get(i).getRunway().equals(Globals.f2t_jijiabanfei)||
//							 arrangeDutyOperateList.get(i).getRunway().equals(Globals.f2t_wujiabanfei)){
//						 flag=true;
//						 break;
//					 }else{
//						 runWay=ProjectArrangeCommonMethod.getRunWayByCode(arrangeDutyOperateList.get(i).getRunway());
//						 flag=false;
//						 break;
//					 }
					 flag=true;
					 break;
				 }else{
					 runWay="无";
					 flag=false;
				 }
			}
		}else{
			runWay="无";
			flag=false;
		}
		if(flag==false){
			if(runWay=="无"){
				j.setMsg("通过Excel导入的排班不能进行修改，请到Excel排班模板中修改后导入");
			}else{
				j.setMsg("当前员工运转方式为'"+runWay+"'，不可以编辑班次。");
			}
			j.setSuccess(false);
		}
		
		return j;
	}
	
	/**
	 * 复制上个月的月度排班
	 * PS：
	 * 1、只复制运转方式为做五休二的排班
	 * */
	@RequestMapping(params = "copyLastMonthArrange")
	@ResponseBody
	public AjaxJson copyLastMonthArrange(String yearmonth,String pid,
			HttpServletRequest request, HttpServletResponse response){
		AjaxJson j = new AjaxJson();
		if(StringUtil.isEmpty(pid) || StringUtil.isEmpty(yearmonth)){
			j.setMsg("项目以及排班月度不能为空。");
			j.setSuccess(false);
			return j;
		}
//		StringBuffer hql = new StringBuffer(" from ArrangeDutyOperateEntity t where runway in ('").append(Globals.f2t_jijiabanfei)
//				.append("','").append(Globals.f2t_wujiabanfei).append("')");
//		hql.append(" and t.yearmonth = ? and t.pid =? ");
		List<ArrangeDutyOperateEntity> curMonthArrangeDutyOptList = projDao.getArrangeDutyOperate4CopyLastMonth(yearmonth, pid);
		if(curMonthArrangeDutyOptList.size() > 0) {
			j.setMsg("本月做五休二运转方式已经进行了排班，不能复制上月排班");
			j.setSuccess(false);
			return j;
		}
//		TSUser tSUser=ResourceUtil.getSessionUser();
		try {
			String lastMonth = HGLDateUtils.addDateMonth(yearmonth, -1);
			// 先查询上个月的做五休二方式的排班list
			List<ArrangeDutyOperateEntity> lastMonthArrangeDutyOptList = projDao.getArrangeDutyOperate4CopyLastMonth(lastMonth,pid);
			String checkRet = checkUserConfig(lastMonthArrangeDutyOptList);
			if(StringUtils.isNotEmpty(checkRet)) {
				j.setMsg("复制排班失败，"+checkRet);
				j.setSuccess(false);
				return j;
			}
			String arrangeDutyOperateIds = "";
			for(  ArrangeDutyOperateEntity optEntity : lastMonthArrangeDutyOptList) {
				//清空原id,表示此条记录为新增
				optEntity.setId(null);
				optEntity.setYearmonth(yearmonth);
//				ArrangeDutyOperateEntity t = new ArrangeDutyOperateEntity();
//				MyBeanUtils.copyBeanNotNull2Bean(optEntity, t);
				AjaxJson aj = arrangeDutyOperateService.saveArrangeDutyOperate(optEntity,"1",arrangeDutyOperateIds);
				//把新增的排班oprate ID记录下来，为后续生成排班做准备
				arrangeDutyOperateIds = aj.getAttributes().get("arrangeDutyOperateId").toString();
			}
			saveMonthArrangeDutyOperate(arrangeDutyOperateIds, yearmonth, pid, "0");
			
			j.setSuccess(true);
			j.setMsg("操作成功");
		} catch (Exception e) {
			j.setMsg("操作失败");
			j.setSuccess(false);
			e.printStackTrace();
		}
	
		return j;
	}
	
	private String checkUserConfig(List<ArrangeDutyOperateEntity> lastMonthArrangeDutyOptList ) {
		String ret = "";
		if(lastMonthArrangeDutyOptList == null || lastMonthArrangeDutyOptList.size() == 0)
			return ret;
		List<Map<String, Object>> postConfig = systemService.findForJdbc("select  id,ptj_post_name, need_number ,pid "
				+ "from t_bus_project_post_detail where pid =?  and delete_flag = 0 ",
				lastMonthArrangeDutyOptList.get(0).getPid());
		HashMap<String,Integer> configCountMap = new HashMap<String, Integer>();
		HashMap<String,Integer> arrangeCountMap = new HashMap<String, Integer>();
		HashMap<String,String> postNameMap = new HashMap<String, String>();
		for (Map<String, Object> map : postConfig) {
			postNameMap.put(map.get("id").toString(), map.get("ptj_post_name").toString());
			configCountMap.put(map.get("id").toString(), Integer.valueOf( map.get("need_number").toString()));
		}
//		for (ArrangeDutyOperateEntity operate : lastMonthArrangeDutyOptList) {
//			if(configCountMap.get(operate.getPjtPostId()) >= operate.getDeployPeopleNum()) {
//				configCountMap.put(operate.getPjtPostId(), configCountMap.get(operate.getPjtPostId()) - operate.getDeployPeopleNum());
//			}else {
//				ret = "岗位【"+postNameMap.get(operate.getPjtPostId())+"】排班人数超过项目岗位编制人数，请联系人力资源部";
//				return ret;
//			}
//		}
		for (ArrangeDutyOperateEntity operate : lastMonthArrangeDutyOptList) {
			arrangeCountMap.put(operate.getPjtPostId(),
					arrangeCountMap.containsKey(operate.getPjtPostId())
							? arrangeCountMap.get(operate.getPjtPostId()) + operate.getDeployPeopleNum()
							: operate.getDeployPeopleNum());
		}
		//检查岗位配置中各岗位配置数量，是否超出
		for (Entry<String, Integer> arrange : arrangeCountMap.entrySet()) {
			if(configCountMap.get(arrange.getKey()) < arrange.getValue()) { 
				ret += String.format("<br>岗位【%s】，复制排班人数%d人，项目岗位编制人数%d人;", postNameMap.get(arrange.getKey()),arrange.getValue(),configCountMap.get(arrange.getKey())) ;
			}
		}
		return StringUtils.isNotEmpty(ret)
				? "以下岗位超出编制，请联系人力资源部："+ret
				:"";
	}
	

	@RequestMapping(params = "redoArrange")
	@ResponseBody
	public AjaxJson redoArrange(String yearmonth,String pid,
			HttpServletRequest request, HttpServletResponse response){
		//检查是否可以恢复
		AjaxJson j = checkRedo(yearmonth, pid);
		if(!j.isSuccess())
			return j;
		TSDepart depart = systemService.findUniqueByProperty(TSDepart.class, "id", pid);
		try {
			ProjArrangeDetailAndUserDto paramDto = new ProjArrangeDetailAndUserDto();
			//查询项目排班详细表数据
			List<ProjarrangeDetailEntity> projArrangeDetaillist = systemService.findHql(
					" FROM ProjarrangeDetailEntity where pid =? and yearmonth=? ", pid,yearmonth);
					projarrangeDetailService.getProjArrangeDetailAndUserByPIdYearMonth(
					paramDto,null);
			for(ProjarrangeDetailEntity projDetail: projArrangeDetaillist){
				//查询员工排班历史详情表数据(历史只保留了一份)
				List<UserArrangeDetailHistoryEntity> historyList = systemService.findHql(" FROM UserArrangeDetailHistoryEntity where projarrangeDetailid = ?", projDetail.getId());
				Map<String,Object> caldutyMap = new HashMap<String, Object>();
				for(UserArrangeDetailHistoryEntity history:historyList) {
					caldutyMap.put(history.getCalendarid(),history.getShiftid());
				}

				projDetail=arrangeDutyAndOndutyServiceI.getDayAndTimeFO(projDetail,caldutyMap);
				arrangeDutyAndOndutyServiceI.saveProjarrangeDetail(projDetail, caldutyMap, Globals.ARRANGESTATUS_0,false);
			}
			String message = "成功恢复项目【"+depart.getDepartname()+"】【"+yearmonth+"】月度排班";
			j.setSuccess(true);
			j.setMsg(message);
			systemService.addLog(message, Globals.Log_Type_INSERT, Globals.Log_Leavel_INFO);
		} catch (Exception e) {
			j.setMsg("操作失败");
			j.setSuccess(false);
			e.printStackTrace();
		}
	
		return j;
	}
	private AjaxJson checkRedo(String yearmonth,String pid) {
		AjaxJson j = new AjaxJson();
		if(StringUtil.isEmpty(pid) || StringUtil.isEmpty(yearmonth)){
			j.setMsg("项目以及排班月度不能为空。");
			j.setSuccess(false);
			return j;
		}
		List<ProjArrangeGeneralEntity> projArrangeGenerallist = systemService.findHql(
				" FROM ProjArrangeGeneralEntity where belongUnitid =? and yearmonth=? ", pid,yearmonth);
		if(projArrangeGenerallist.size() == 0) {
			j.setMsg("当前项目月度【"+yearmonth+"】未排班，无可恢复数据");
			j.setSuccess(false);
			return j;
		}
		if(projArrangeGenerallist.get(0).getArrangeDutyStatus().equals(Globals.ARRANGESTATUS_2)) {
			j.setMsg("当前项目月度【"+yearmonth+"】排班已上报，不能恢复");
			j.setSuccess(false);
			return j;
		}
		return j;
	}
	/**
     * 用户选择机构列表跳转页面
     *	项目名称选择
     * @return
     */
    /*@RequestMapping(params = "departZTreeSelect")
    public String departZTreeSelect(HttpServletRequest req) {
    	req.setAttribute("orgIds", req.getParameter("orgIds"));
        return "cn/com/lzt/projarrangedetail/departZTreeSelect";
    }*/
	
  //update--start--by:jg_renjie--at:20160318 for:#942 【组件封装】组织机构弹出模式，目前是列表，得改造成树方式
  	//update-start--Author: os_renjie  Date:20160529 for：TASK #1056 【bug】用户编辑，弹出组织机构，默认没选中
  	/*@RequestMapping(params = "getDepartZTreeInfo")
  	@ResponseBody
  	public AjaxJson getDepartZTreeInfo(HttpServletRequest request, HttpServletResponse response){
  		
  		AjaxJson j = new AjaxJson();
  		
  		String orgIds = request.getParameter("orgIds");
  		
  		String[] ids = new String[]{}; 
  		if(StringUtils.isNotBlank(orgIds)){
  			orgIds = orgIds.substring(0, orgIds.length()-1);
  			ids = orgIds.split("\\,");
  		}
  		
  		String parentid = request.getParameter("parentid");
  		
  		List<TSDepart> tSDeparts = new ArrayList<TSDepart>();
  		
  		StringBuffer hql = new StringBuffer(" from TSDepart t where 1=1 ");
  		if(StringUtils.isNotBlank(parentid)){
  			
  			TSDepart dePart = this.systemService.getEntity(TSDepart.class, parentid);
  			
  			hql.append(" and TSPDepart = ?");
  			tSDeparts = this.systemService.findHql(hql.toString(), dePart);
  		} else {
  			hql.append(" and t.orgType = ?");
  			tSDeparts = this.systemService.findHql(hql.toString(), "1");
  		}
  		List<Map<String,Object>> dateList = new ArrayList<Map<String,Object>>();
  		if(tSDeparts.size()>0){
  			Map<String,Object> map = null;
  			String sql = null;
  			 Object[] params = null;
  			for(TSDepart depart:tSDeparts){
  				map = new HashMap<String,Object>();
  				map.put("id", depart.getId());
  				map.put("name", depart.getDepartname());
  				
  				if(ids.length>0){
  					for(String id:ids){
  						if(id.equals(depart.getId())){
  							map.put("checked", true);
  						}
  					}
  				}
  				
  				if(StringUtils.isNotBlank(parentid)){
  					map.put("pId", parentid);
  				} else{
  					map.put("pId", "1");
  				}
  				//根据id判断是否有子节点
  				sql = "select count(1) from t_s_depart t where t.parentdepartid = ?";
  				params = new Object[]{depart.getId()};
  				long count = this.systemService.getCountForJdbcParam(sql, params);
  				if(count>0){
  					map.put("isParent",true);
  				}
  				dateList.add(map);
  			}
  		}
  		net.sf.json.JSONArray jsonArray = net.sf.json.JSONArray.fromObject(dateList);
  		j.setMsg(jsonArray.toString());
  		return j;
  	}*/
  	//update-start--Author: os_renjie  Date:20160529 for：TASK #1056 【bug】用户编辑，弹出组织机构，默认没选中
  	//update--end--by:jg_renjie--at:20160318 for:#942 【组件封装】组织机构弹出模式，目前是列表，得改造成树方式
	
	
	
	
	
	
	


	
}