meidu2021/daju/target/classes/cn/com/lzt/userstats/controller/UserStatsController.java

package cn.com.lzt.userstats.controller;
import cn.com.lzt.arrangeduty.dto.ProjectDepartDto;
import cn.com.lzt.attendance.dao.AttendanceStatsMinidaoDao;
import cn.com.lzt.common.entity.ChartMultLineDto;
import cn.com.lzt.common.entity.ChartSeriesDto;
import cn.com.lzt.common.entity.DataDto;
import cn.com.lzt.common.entity.UserRoleDto;
import cn.com.lzt.common.util.Constants;
import cn.com.lzt.common.util.DataUtil;
import cn.com.lzt.common.util.ExportExcel;
import cn.com.lzt.dialogDeal.service.DialogDealServiceI;
import cn.com.lzt.userstats.dao.UserStatsMinidaoDao;
import cn.com.lzt.userstats.dto.UserEntity;
import cn.com.lzt.userstats.service.UserStatsServiceI;
import org.apache.log4j.Logger;
import org.jeecgframework.core.common.controller.BaseController;
import org.jeecgframework.core.util.JeecgDataAutorUtils;
import org.jeecgframework.core.util.ResourceUtil;
import org.jeecgframework.core.util.StringUtil;
import org.jeecgframework.minidao.pojo.MiniDaoPage;
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.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.servlet.ModelAndView;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.validation.Validator;
import java.util.*;

/**   
 * @Title: Controller  
 * @Description: 人员统计
 * @author onlineGenerator
 * @date 2017-10-24 16:38:50
 * @version V1.0   
 *
 */
@Controller
@RequestMapping("/userStatsController")
public class UserStatsController extends BaseController {
	/**
	 * Logger for this class
	 */
	private static final Logger logger = Logger.getLogger(UserStatsController.class);
	//用户浏览器统计分析的国际化KEY
	private static final String USER_BROWSER_ANALYSIS = "user.browser.analysis";

	
	@Autowired
	private UserStatsServiceI userstatsService;
	@Autowired
	DialogDealServiceI dialogDealServiceI;
	@Autowired
	private SystemService systemService;
	@Autowired
	private Validator validator;
	
	@Autowired
	private UserStatsMinidaoDao userStatsMinidaoDao;
	@Autowired
	private AttendanceStatsMinidaoDao statsMinidaoDao;


	/**
	 * 人员统计页面
	 * 
	 * @return
	 */
	@RequestMapping(params = "userStats")
	public ModelAndView statisticTabs(HttpServletRequest request) {
		ModelAndView mav = new ModelAndView();
		Calendar c = Calendar.getInstance();
		mav.addObject("curYear",c.get(Calendar.YEAR)+"");
		int month = c.get(Calendar.MONTH);
		if(month > 9){
			mav.addObject("curMonth",  c.get(Calendar.MONTH)+"");
		}else if(month == 0){
			mav.addObject("curYear",(c.get(Calendar.YEAR)-1)+"");
			mav.addObject("curMonth",  "12");
		}else{
			mav.addObject("curMonth",  "0"+c.get(Calendar.MONTH));
		}
		TSUser user = (TSUser) request.getSession().getAttribute(ResourceUtil.LOCAL_CLINET_USER);
		
		//默认HR权限
		String rolefalg ="1";
		//查询用户角色
		String authSql = JeecgDataAutorUtils.loadDataSearchConditonSQLString();
		List<UserRoleDto>  userRolelist = statsMinidaoDao.getUserRoleList(user.getId(),authSql);
		for(UserRoleDto urdto : userRolelist){
			if(Constants.USER_ROLE_HR.contains(urdto.getRolecode())){
				rolefalg = "1";
				break;
			}
			if(Constants.USER_ROLE_DEPT.contains(urdto.getRolecode())){
				rolefalg = "2";
				break;
			}
		}
		if(rolefalg.equals("2")){
			List<ProjectDepartDto> projectDepartDtoList=dialogDealServiceI.getProjectDepartByUserId();
			mav.addObject("departList", projectDepartDtoList);
		}
		mav.addObject("roleFlag", rolefalg);
		mav.setViewName("cn/com/lzt/userstats/userStats");
		return mav;
	}
	
	
	/**
	 * 人员统计数据json
	 * @param request
	 * @param userEntity
	 * @return
	 */
	@RequestMapping(params="userStatsData")
	@ResponseBody
	public Map<String,Object> userStatsData(HttpServletRequest request,UserEntity userEntity) {
		Map<String,Object> result = new HashMap<String,Object>();
		List<String> xAxisData = new ArrayList<String>();
		List<String> yearMonths = new ArrayList<String>();
		List<UserEntity> statsList  = new ArrayList<UserEntity>();
		//如果是月频，需要查询某年某月
		if(userEntity.getAttType() == 0){
			yearMonths.add(userEntity.getAttYear()+"-"+userEntity.getAttMonth());
		}else if(userEntity.getAttType() == 1){
			yearMonths = DataUtil.getYearMonthList(userEntity.getAttYear(), userEntity.getAttQuarters());
		}
		userEntity.setYearMonthList(yearMonths);
		String authSql = JeecgDataAutorUtils.loadDataSearchConditonSQLString();
		MiniDaoPage<UserEntity> list = new MiniDaoPage<UserEntity>();
		if(!StringUtil.isEmpty(userEntity.getPid())){
			list = userStatsMinidaoDao.userStatsPdData(userEntity, authSql);
			statsList  = list.getResults();
			for(UserEntity stats : statsList){
				xAxisData.add(stats.getPidName());
			}
			
		}else{
			list = userStatsMinidaoDao.userStatsData(userEntity, authSql);
			statsList  = list.getResults();
			for(UserEntity stats : statsList){
				xAxisData.add(stats.getpName());
			}
			
		}
		ArrayList<ChartSeriesDto> series = new ArrayList<ChartSeriesDto>();//series值
		ChartSeriesDto csdto = new ChartSeriesDto();
		csdto.setName("员工流动比例（%）");
		csdto.setType("bar");
		csdto.setBarMaxWidth(30);
		List<DataDto> datalist = new ArrayList<DataDto>();
		for(int i= 0 ; i < statsList.size() ; i++){
			DataDto dd = new DataDto();
			if(!StringUtil.isEmpty(userEntity.getPid())){
				dd.setId(statsList.get(i).getDeptId());
			}else{
				dd.setId(statsList.get(i).getPid());
			}
			dd.setValue(DataUtil.getFormatDecimailTwo(statsList.get(i).getFlowProportion()));
			datalist.add(dd);
		}
		csdto.setData(datalist.toArray());
		series.add(csdto);
		ChartMultLineDto cmlDto = new ChartMultLineDto();
		cmlDto.setxAxisData(xAxisData.toArray());
		cmlDto.setSeries(series);
		if( statsList== null || statsList.size() == 0){
			cmlDto.setNoData(true);
		}
		result.put("cdata", cmlDto);
		result.put("tdata", statsList);
		request.getSession().setAttribute("userStats", statsList);
		return result;
	}

	/**
	 * 人员统计年度下钻
	 * @param request
	 * @param userEntity
	 * @return
	 */
	@RequestMapping(params="userYearInto")
	@ResponseBody
	public Map<String,Object> userYearInto(HttpServletRequest request,UserEntity userEntity) {
		Map<String,Object> result = new HashMap<String,Object>();

		 
		String authSql = JeecgDataAutorUtils.loadDataSearchConditonSQLString();
		MiniDaoPage<UserEntity> list = userStatsMinidaoDao.userYearInfo(userEntity, authSql);
		List<UserEntity> statsList  = list.getResults();
		
		List<String> xAxisData = DataUtil.getMonList();
		
		ArrayList<ChartSeriesDto> series = new ArrayList<ChartSeriesDto>();//series值
		ChartSeriesDto csdto = new ChartSeriesDto();
		csdto.setName("员工流动比例（%）");
		csdto.setType("line");
		csdto.setBarMaxWidth(30);
		List<String> datalist = new ArrayList<String>();
		for(String s : xAxisData){
			Boolean flag = false;
			for(int i= 0 ; i < statsList.size() ; i++){
				if(statsList.get(i).getYearMonth().substring(5, 7).equals(s)){
					datalist.add(DataUtil.getFormatDecimailTwo(statsList.get(i).getFlowProportion()));
					flag = true;
				}
			}
			if(!flag){
				datalist.add(null);
			}
		}
		csdto.setData(datalist.toArray());
		series.add(csdto);
		ChartMultLineDto cmlDto = new ChartMultLineDto();
		cmlDto.setxAxisData(xAxisData.toArray());
		cmlDto.setSeries(series);
		result.put("cdata", cmlDto);
		result.put("tdata", statsList);
		request.getSession().setAttribute("userStatsDown", statsList);
		return result;
	}

	
	/**
	 * 人员统计
	 * @param request
	 * @return
	 */
	@RequestMapping(params="userStatsTaskData")
	@ResponseBody
	public void userStatsTaskData(HttpServletRequest request) {
		String attmonth = request.getParameter("attMonth");
		userstatsService.userStatsTaskData(attmonth);
	
	}
	
	/**
	 * 导出
	 * @param exceltitles
	 * @param request
	 * @param response
	 * @throws Exception
	 */
	@RequestMapping(params = "exportExcel")
	@ResponseBody
	public void exportExcel(String exceltitles,String exceltitleIds ,Integer flag,HttpServletRequest request,
			HttpServletResponse response) throws Exception{
		if(flag == 1){
			@SuppressWarnings("unchecked")
			List<Object> dataList = (List<Object>)request.getSession().getAttribute("userStats");
			ExportExcel ex = new ExportExcel("人员统计", exceltitles.split(","), "人员统计", dataList,exceltitleIds.split(","));
			ex.export(response);
		}else{
			@SuppressWarnings("unchecked")
			List<Object> dataList = (List<Object>)request.getSession().getAttribute("userStatsDown");
			ExportExcel ex = new ExportExcel("人员统计", exceltitles.split(","), "人员统计", dataList,exceltitleIds.split(","));
			ex.export(response);
		}
	
	}
}