package cn.com.lzt.userwage.controller; import cn.com.lzt.arrangeduty.dto.ProjectDepartDto; import cn.com.lzt.common.dto.VisibleUserDto; import cn.com.lzt.common.service.DataPermissionServiceI; import cn.com.lzt.common.util.UserUtil; import cn.com.lzt.dialogDeal.service.UserDepartOrgDealServiceI; import cn.com.lzt.dingattendanceinfo.entity.DingAttendanceinfoEntity; import cn.com.lzt.useroptions.entity.TBusUserOptionsEntity; import cn.com.lzt.useroptions.service.TBusUserOptionsServiceI; import cn.com.lzt.userwage.dto.UserWageDetaillsDto; import cn.com.lzt.userwage.dto.UserWageDto; import cn.com.lzt.userwage.dto.UserWagePaperDto; import cn.com.lzt.userwage.dto.UserWageViewDto; import cn.com.lzt.userwage.entity.UserWageEntity; import cn.com.lzt.userwage.entity.UserwagePage; import cn.com.lzt.userwage.service.UserWageServiceI; import cn.com.lzt.userwagestrategyhistory.entity.UserWagestrategyHistoryEntity; import org.apache.commons.collections.CollectionUtils; import org.apache.commons.lang.StringUtils; import org.apache.ibatis.annotations.Param; import org.apache.log4j.Logger; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.ss.usermodel.Workbook; 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.minidao.pojo.MiniDaoPage; import org.jeecgframework.poi.excel.ExcelExportUtil; import org.jeecgframework.poi.excel.ExcelImportUtil; import org.jeecgframework.poi.excel.annotation.Excel; import org.jeecgframework.poi.excel.entity.ExportParams; import org.jeecgframework.poi.excel.entity.ImportParams; import org.jeecgframework.poi.excel.entity.params.ExcelExportEntity; import org.jeecgframework.poi.excel.entity.vo.NormalExcelConstants; import org.jeecgframework.tag.core.easyui.TagUtil; import org.jeecgframework.web.system.pojo.base.TSBaseUser; import org.jeecgframework.web.system.pojo.base.TSDepart; import org.jeecgframework.web.system.pojo.base.TSUser; import org.jeecgframework.web.system.pojo.base.TSUserOrg; 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.ServletOutputStream; 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.beans.PropertyDescriptor; import java.io.IOException; import java.io.UnsupportedEncodingException; import java.lang.reflect.Field; import java.lang.reflect.InvocationTargetException; import java.lang.reflect.Method; import java.math.BigDecimal; import java.net.URI; import java.text.ParseException; import java.util.*; /** * @Title: Controller * @Description: 员工工资核算表 * @author onlineGenerator * @date 2017-10-26 18:36:30 * @version V1.0 * */ @Controller @RequestMapping("/userWageController") public class UserWageController extends BaseController { /** * Logger for this class */ private static final Logger logger = Logger.getLogger(UserWageController.class); @Autowired private UserWageServiceI userWageService; @Autowired private SystemService systemService; @Autowired private Validator validator; @Autowired private DataPermissionServiceI dataPermissionService; @Autowired private UserDepartOrgDealServiceI userDepartOrgDealService; @Autowired private TBusUserOptionsServiceI userOptionsService; /** * 得到上个月的年月 * @return */ private String getMonthlys(){ Calendar cal = Calendar.getInstance(); int year = cal.get(Calendar.YEAR); int month = cal.get(Calendar.MONTH); if(month < 10){ if(month == 0){ year = year - 1; month = 12; }else{ // month = Integer.valueOf(0+""+month); return year + "-" + 0 + "" + month; } } return year+"-"+month; } /** * 员工工资核算表列表 页面跳转 * * @return */ @RequestMapping(params = "list") public ModelAndView list(HttpServletRequest request) { HttpSession session = ContextHolderUtils.getSession(); TSUser tuser = (TSUser)session.getAttribute("LOCAL_CLINET_USER"); String departid = ""; String departname = ""; try { TBusUserOptionsEntity options = userOptionsService.getOptionsByUserID(tuser.getId(), Globals.USER_OPTIONS_TYPE_PROJECT, false); if(options != null) { departid = options.getOptionId(); departname = options.getOptionName(); } } catch (Exception e) { e.printStackTrace(); org.jeecgframework.core.util.LogUtil.error(e.getMessage()); } if (oConvertUtils.isNotEmpty(departid)) { request.setAttribute("departid", departid); request.setAttribute("departname", departname); } request.setAttribute("monthlys", getMonthlys()); return new ModelAndView("cn/com/lzt/userwage/userWageList"); } /** * 员工工资核算表列表 页面跳转 * * @return */ @RequestMapping(params = "listView") public ModelAndView listView(HttpServletRequest request) { String orgid = request.getParameter("orgid"); String monthly = request.getParameter("monthly"); if(oConvertUtils.isNotEmpty(monthly)){ request.setAttribute("monthlys", monthly); request.setAttribute("orgid", orgid); }else{ request.setAttribute("monthlys", getMonthlys()); } return new ModelAndView("cn/com/lzt/userwage/userWageViewList"); } @RequestMapping(params = "logrp") public ModelAndView logrp(@Param("id") String id,HttpServletRequest request){ if(StringUtils.isNotEmpty(id)){ UserWageEntity userWage = systemService.get(UserWageEntity.class, id); TSBaseUser tsBaseUser = systemService.get(TSBaseUser.class, userWage.getUserid()); request.setAttribute("realname", tsBaseUser.getRealName()); if(userWage != null){ //systemService.get StringBuffer hql = new StringBuffer("from UserWagestrategyHistoryEntity where userid =? and strategyMonth = ? "); List userList = systemService.findHql(hql.toString(),userWage.getUserid(),userWage.getMonthly()); //List userList = systemService.findListbySql("select * from t_bus_user_wagestrategy_history where userid = '"+userWage.getUserid()+"' and strategy_month = '"+userWage.getMonthly()+"'"); if(!userList.isEmpty() && userList.size() > 0){ // System.out.println(JSONObject.toJSONString(userList.get(0))); request.setAttribute("userwh", userList.get(0)); }else{ request.setAttribute("userwh",new UserWagestrategyHistoryEntity()); } } } return new ModelAndView("cn/com/lzt/userwage/userwagestrategy-view"); } @RequestMapping(params = "goview") public ModelAndView goView(@Param("belongUnitname") String belongUnitname,@Param("id") String id,@Param("monthly")String monthly,@Param("type")String type, HttpServletRequest request){ request.setAttribute("id", id); TSDepart depart = systemService.get(TSDepart.class, id); if(depart != null) { request.setAttribute("belongUnitname",depart.getDepartname()); } request.setAttribute("monthly", monthly); request.setAttribute("monthlys",monthly); request.setAttribute("type",type); return new ModelAndView("cn/com/lzt/userwage/userWageEditList"); } /** * 直接打开工资编辑 * @param belongUnitname * @param id * @param monthly * @param type * @param request * @return */ @RequestMapping(params = "editList") public ModelAndView editList(@Param("belongUnitname") String belongUnitname,@Param("id") String id,@Param("monthly")String monthly,@Param("type")String type, HttpServletRequest request){ // request.setAttribute("id", id); // TSDepart depart = systemService.get(TSDepart.class, id); // if(depart != null) { // request.setAttribute("belongUnitname",depart.getDepartname()); // } // request.setAttribute("monthly", monthly); // request.setAttribute("monthlys",monthly); // request.setAttribute("type",type); return new ModelAndView("cn/com/lzt/userwage/userWageEditList"); } /** * 所有项目（部门）选择弹窗页面跳转路径 * 列表页弹窗 * @author liujie * 2017-12-13 * @param request * @return */ @RequestMapping(params = "projectDepartTableAll") public ModelAndView projectDepartTableAll(HttpServletRequest request) { //return new ModelAndView("cn/com/lzt/arrangeduty/dutyMealTable"); ModelAndView mv = new ModelAndView("cn/com/lzt/userwage/projectDepartTableAll"); String ids = oConvertUtils.getString(request.getParameter("ids")); mv.addObject("ids", ids); return mv; } /** * 项目（部门）选择弹窗列表数据 * @author liujie * 2017-11-15 * @param projectDepartDto * @param request * @param response * @param dataGrid */ @RequestMapping(params = "projectDepartDatagridAll") public void projectDepartDatagridAll(ProjectDepartDto projectDepartDto, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) { TSUser tSUser=ResourceUtil.getSessionUser(); List projectDepartDtoList=userWageService.getProjectDepartAll(projectDepartDto,tSUser.getId()); dataGrid.setResults(projectDepartDtoList); TagUtil.datagrid(response, dataGrid); } /** * 员工工资核算表列表 页面跳转 * * @return */ @RequestMapping(params = "listDetails") public ModelAndView listDetails(@Param("realname") String realname,@Param("belongBank") String belongBank,@Param("pid") String pid,@Param("monthly")String monthly,HttpServletRequest request) { request.setAttribute("monthlys", getMonthlys()); request.setAttribute("monthly", monthly); request.setAttribute("orgid", pid); request.setAttribute("realname", realname); request.setAttribute("belongBank", belongBank); return new ModelAndView("cn/com/lzt/userwage/userWageDetailsList"); } /** * 员工月度工资明细表格 * * @param request * @param response * @param dataGrid * @throws ParseException */ @RequestMapping(params = "datagrid") public void datagrid(UserWageDto userWage,HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) throws ParseException { String monthlys = request.getParameter("monthlys"); String monthly = request.getParameter("monthly"); String realname = request.getParameter("realname"); String belongBank = request.getParameter("belongBank"); String orgIds = request.getParameter("orgIds"); String orgId = request.getParameter("orgid"); String type = request.getParameter("type"); if(oConvertUtils.isEmpty(monthlys) && oConvertUtils.isEmpty(monthly)){ dataGrid.setResults(new ArrayList()); dataGrid.setFooter(""); TagUtil.datagrid(response, dataGrid); return; } // if(oConvertUtils.isEmpty(orgIds) && oConvertUtils.isEmpty(orgIds)){ // dataGrid.setResults(new ArrayList()); // dataGrid.setFooter(""); // TagUtil.datagrid(response, dataGrid); // return; // } if(realname != null) { userWage.setRealname(realname); } if(belongBank != null) { userWage.setBelongBank(belongBank); } MiniDaoPage list = null; if(oConvertUtils.isNotEmpty(monthlys) || oConvertUtils.isNotEmpty(monthly)){ if(StringUtils.isEmpty(orgIds)&&StringUtils.isNotEmpty(orgId)){ List orgIdList = extractIdListByComma(orgId); // 获取 当前组织机构的用户信息 if (!CollectionUtils.isEmpty(orgIdList)) { if(oConvertUtils.isNotEmpty(type) && "1".equals(type)){ userWage.setOrgIdList(orgIdList); }else{ String or = orgIdList.get(0); List ChildIdList = userDepartOrgDealService.getChildIdByProjectDepartId(or); userWage.setOrgIdList(ChildIdList); } } }else{ if(StringUtils.isNotEmpty(orgIds)){ List orgIdList = extractIdListByComma(orgIds); // 获取 当前组织机构的用户信息 if (!CollectionUtils.isEmpty(orgIdList)) { String or = orgIdList.get(0); List ChildIdList = userDepartOrgDealService.getChildIdByProjectDepartId(or); userWage.setOrgIdList(ChildIdList); } } } if(StringUtils.isNotEmpty(monthlys)){ userWage.setMonthly(monthlys); }else{ if(StringUtils.isNotEmpty(monthly)){ request.setAttribute("monthlys", monthly); userWage.setMonthly(monthly); }else{ request.setAttribute("monthlys", getMonthlys()); userWage.setMonthly(getMonthlys()); } //userWage.setMonthly(sim.format(sim.parse("2017-10"))); } String authSql = JeecgDataAutorUtils.loadDataSearchConditonSQLString(); VisibleUserDto dto = dataPermissionService.getVisibleUserList();// 获取当前用户可见的userid列表 if(dto != null){ if(dto.getFlag().value().equalsIgnoreCase("ALL")){ list = userWageService.getPagedEntities(userWage,null,null,dataGrid.getPage(), dataGrid.getRows(), authSql); // map = userWageService.getMoneySUM(userWage,null,moth); }else if(dto.getFlag().value().equalsIgnoreCase("NONE")){ // 获取当前登录用户 HttpSession session = ContextHolderUtils.getSession(); TSUser user = (TSUser)session.getAttribute("LOCAL_CLINET_USER"); List uidList = new ArrayList(); uidList.add(user.getId()); list = userWageService.getPagedEntities(userWage,uidList,null,dataGrid.getPage(), dataGrid.getRows(), authSql); // map = userWageService.getMoneySUM(userWage,uidList,moth); }else if(dto.getFlag().value().equalsIgnoreCase("PART")){ List useridList = dto.getUseridList(); if(useridList != null && useridList.size() > 0){ list = userWageService.getPagedEntities(userWage,useridList,null,dataGrid.getPage(), dataGrid.getRows(), authSql); // map = userWageService.getMoneySUM(userWage,useridList,moth); } } } // 为了提高效率,人事部门不做工资权限限制. 20170628 xzx // UserWageDto> list = userWageService.getAll(userWage,authSql); if(list != null && !list.getResults().isEmpty()){ for (Iterator iterator = list.getResults().iterator(); iterator.hasNext();) { UserWageDto userWageDto = (UserWageDto) iterator.next(); if (oConvertUtils.isEmpty(userWageDto.getId())) { userWageDto.setId("temp"+UUIDGenerator.generate()); } if(StringUtils.isNotEmpty(userWage.getStatus())){ if(StringUtils.isEmpty(userWageDto.getMonthly())){ iterator.remove(); } } if(StringUtils.isEmpty(userWageDto.getMonthly())){ userWageDto.setBelongUnitName(getBybelongId(userWageDto.getUserids())); } } Collections.sort(list.getResults()); dataGrid.setResults(list.getResults()); dataGrid.setTotal(list.getTotal()); } // List list = new ArrayList(); // Map map = new HashMap(); // if(dto.getFlag().value().equalsIgnoreCase("ALL")){ // list = userWageService.getAllEntities(userWage,null,null,authSql); // map = userWageService.getMoneySUM(userWage,null,null); // }else if(dto.getFlag().value().equalsIgnoreCase("NONE")){ // // 获取当前登录用户 // HttpSession session = ContextHolderUtils.getSession(); // TSUser user = (TSUser)session.getAttribute("LOCAL_CLINET_USER"); // List uidList = new ArrayList(); // uidList.add(user.getId()); // list = userWageService.getAllEntities(userWage,uidList,null,authSql); // map = userWageService.getMoneySUM(userWage,uidList,null); // }else if(dto.getFlag().value().equalsIgnoreCase("PART")){ // List useridList = dto.getUseridList(); // if(useridList != null && useridList.size() > 0){ // list = userWageService.getAllEntities(userWage,useridList,null,authSql); // map = userWageService.getMoneySUM(userWage,useridList,null); // } // } Map map = new HashMap(); //代码层计算合计，不通过sql计算 try { calcuSumMap(map,list.getResults()); } catch (Exception e) { e.printStackTrace(); } StringBuffer str = new StringBuffer(); for(String key : map.keySet()) { String value = map.get(key) == null ? "0.00" : map.get(key).toString(); str.append(key).append(":").append(value).append(","); } // //List list = userWageService.getAllEntities(userWage,authSql); // dataGrid.setResults(list); // //Map map = userWageService.getMoneySUM(userWage,null); // // StringBuffer str = new StringBuffer(); // str.append("basicWage:"+(String.valueOf(map.get("basic_wage")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("basic_wage")))+","); // str.append("dutiesAllowance:"+(String.valueOf(map.get("duties_allowance")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("duties_allowance")))+","); // str.append("certificateSubsidy:"+(String.valueOf(map.get("certificate_subsidy")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("certificate_subsidy")))+","); // str.append("trafficSubsidy:"+(String.valueOf(map.get("traffic_subsidy")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("traffic_subsidy")))+","); // str.append("megathermalSubsidy:"+(String.valueOf(map.get("megathermal_subsidy")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("megathermal_subsidy")))+","); // str.append("onlyChildCost:"+(String.valueOf(map.get("only_child_cost")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("only_child_cost")))+","); // str.append("otherSubsidy:"+(String.valueOf(map.get("other_subsidy")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("other_subsidy")))+","); // str.append("bonus:"+(String.valueOf(map.get("bonus")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("bonus")))+","); // str.append("projectPerformance:"+(String.valueOf(map.get("project_performance")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("project_performance")))+","); // str.append("mealsSubsidyDay:"+(String.valueOf(map.get("meals_subsidy_day")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("meals_subsidy_day")))+","); // str.append("mealsSubsidyNight:"+(String.valueOf(map.get("meals_subsidy_night")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("meals_subsidy_night")))+","); // str.append("mealsSubsidy:"+(String.valueOf(map.get("meals_subsidy")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("meals_subsidy")))+","); // str.append("overtimepayTimeout:"+(String.valueOf(map.get("overtimepay_timeout")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("overtimepay_timeout")))+","); // str.append("overtimepayFixed:"+(String.valueOf(map.get("overtimepay_fixed")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("overtimepay_fixed")))+","); // str.append("duty:"+(String.valueOf(map.get("duty")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("duty")))+","); // str.append("specialOvertime:"+(String.valueOf(map.get("special_overtime")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("special_overtime")))+","); // str.append("sickLeaveDebit:"+(String.valueOf(map.get("sick_leave_debit")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("sick_leave_debit")))+","); // str.append("thingLeaveDebit:"+(String.valueOf(map.get("thing_leave_debit")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("thing_leave_debit")))+","); // str.append("absenceDebit:"+(String.valueOf(map.get("absence_debit")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("absence_debit")))+","); // str.append("paymentSubsidy:"+(String.valueOf(map.get("payment_subsidy")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("payment_subsidy")))+","); // str.append("socialSecurityDebit:"+(String.valueOf(map.get("social_security_debit")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("social_security_debit")))+","); // str.append("providentFundDebit:"+(String.valueOf(map.get("provident_fund_debit")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("provident_fund_debit")))+","); // str.append("preTaxMone:"+(String.valueOf(map.get("pre_tax_mone")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("pre_tax_mone")))+","); // str.append("otherDebit:"+(String.valueOf(map.get("other_debit")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("other_debit")))+","); // str.append("reissue:"+(String.valueOf(map.get("reissue")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("reissue")))+","); // str.append("taxMoney:"+(String.valueOf(map.get("tax_money")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("tax_money")))+","); // str.append("actualMoney:"+(String.valueOf(map.get("actual_money")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("actual_money")))); // dataGrid.setFooter(str.toString()); // } dataGrid.setFooter(str.toString()); } if(list == null || list.getResults() == null || list.getResults().size() == 0){ dataGrid.setResults(new ArrayList()); dataGrid.setFooter(""); } TagUtil.datagrid(response, dataGrid); } /** * 月度工资一览的表格数据 * * @param request * @param response * @param dataGrid */ @RequestMapping(params = "datagrid1") public void datagrid1(UserWageViewDto userWage,HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) { String monthlys = request.getParameter("monthlys"); if(oConvertUtils.isNotEmpty(monthlys)){ String orgIds = request.getParameter("orgIds"); List orgIdList = extractIdListByComma(orgIds); // 获取 当前组织机构的用户信息 if (!CollectionUtils.isEmpty(orgIdList)) { String or = orgIdList.get(0); List ChildIdList = userDepartOrgDealService.getChildIdByProjectDepartId(or); userWage.setOrgIdList(ChildIdList); } userWage.setMonthly(monthlys); String authSql = JeecgDataAutorUtils.loadDataSearchConditonSQLString(); VisibleUserDto dto = dataPermissionService.getVisibleUserList();// 获取当前用户可见的userid列表 if(dto != null){ MiniDaoPage list = new MiniDaoPage(); Map map = new HashMap(); list = userWageService.getViewEntities(userWage,null,dataGrid.getPage(), dataGrid.getRows(), authSql); map = userWageService.getMoneyViewSUM(userWage,null); // if(dto.getFlag().value().equalsIgnoreCase("ALL")){ // list = userWageService.getViewEntities(userWage,null,dataGrid.getPage(), dataGrid.getRows(), authSql); // map = userWageService.getMoneyViewSUM(userWage,null); // }else if(dto.getFlag().value().equalsIgnoreCase("NONE")){ // // 获取当前登录用户 // HttpSession session = ContextHolderUtils.getSession(); // TSUser user = (TSUser)session.getAttribute("LOCAL_CLINET_USER"); // List uidList = new ArrayList(); // uidList.add(user.getId()); // list = userWageService.getViewEntities(userWage,uidList,dataGrid.getPage(), dataGrid.getRows(), authSql); // map = userWageService.getMoneyViewSUM(userWage,uidList); // }else if(dto.getFlag().value().equalsIgnoreCase("PART")){ // List useridList = dto.getUseridList(); // if(useridList != null && useridList.size() > 0){ // list = userWageService.getViewEntities(userWage,useridList,dataGrid.getPage(), dataGrid.getRows(), authSql); // map = userWageService.getMoneyViewSUM(userWage,useridList); // } // } //MiniDaoPage list = userWageService.getViewEntities(userWage, dataGrid.getPage(), dataGrid.getRows(), authSql); dataGrid.setResults(list.getResults()); //Map map = userWageService.getMoneyViewSUM(userWage); StringBuffer str = new StringBuffer(); str.append("sumcount:"+(String.valueOf(map.get("sumcount")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("sumcount")))+","); str.append("basicWage:"+(String.valueOf(map.get("basic_wage")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("basic_wage")))+","); str.append("dutiesAllowance:"+(String.valueOf(map.get("duties_allowance")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("duties_allowance")))+","); str.append("certificateSubsidy:"+(String.valueOf(map.get("certificate_subsidy")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("certificate_subsidy")))+","); str.append("projectPerformance:"+(String.valueOf(map.get("project_performance")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("project_performance")))+","); str.append("mealsSubsidy:"+(String.valueOf(map.get("meals_subsidy")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("meals_subsidy")))+","); str.append("specialOvertime:"+(String.valueOf(map.get("special_overtime")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("special_overtime")))+","); str.append("absenceDebit:"+(String.valueOf(map.get("absence_debit")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("absence_debit")))+","); str.append("paymentSubsidy:"+(String.valueOf(map.get("payment_subsidy")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("payment_subsidy")))+","); str.append("deductions:"+(String.valueOf(map.get("deductions")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("deductions")))+","); str.append("comDeductions:"+(String.valueOf(map.get("comDeductions")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("comDeductions")))+","); str.append("comCost:"+(String.valueOf(map.get("comCost")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("comCost")))+","); str.append("preTaxMone:"+(String.valueOf(map.get("pre_tax_mone")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("pre_tax_mone")))+","); str.append("daikouDebit:"+(String.valueOf(map.get("daikouDebit")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("daikouDebit")))+","); str.append("otherDebit:"+(String.valueOf(map.get("other_debit")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("other_debit")))+","); str.append("reissue:"+(String.valueOf(map.get("reissue")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("reissue")))+","); str.append("taxMoney:"+(String.valueOf(map.get("tax_money")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("tax_money")))+","); str.append("actualMoney:"+(String.valueOf(map.get("actual_money")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("actual_money")))); dataGrid.setFooter(str.toString()); } }else{ dataGrid.setResults(new ArrayList()); dataGrid.setFooter(""); } TagUtil.datagrid(response, dataGrid); } /** * easyui AJAX请求数据 * * @param request * @param response * @param dataGrid * @throws ParseException */ @RequestMapping(params = "datagrid2") public void datagrid2(UserWageDto userWage,HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) throws ParseException { String monthlys = request.getParameter("monthlys"); if(StringUtils.isNotEmpty(monthlys)){ String orgIds = request.getParameter("orgIds"); if(StringUtils.isNotEmpty(orgIds)){ List orgIdList = extractIdListByComma(orgIds); // 获取 当前组织机构的用户信息 if (!CollectionUtils.isEmpty(orgIdList)) { String or = orgIdList.get(0); List ChildIdList = userDepartOrgDealService.getChildIdByProjectDepartId(or); if(!ChildIdList.isEmpty()){ List ch = new ArrayList(); for (String str : ChildIdList) { ch.add(str); } ChildIdList = ch; } userWage.setOrgIdList(ChildIdList); } if(orgIdList != null && orgIdList.size()>0 && orgIdList.get(0)!=null &&orgIdList.get(0).length()>0) { } HttpSession session = ContextHolderUtils.getSession(); TSUser tuser = (TSUser)session.getAttribute("LOCAL_CLINET_USER"); try { userOptionsService.saveUserOptions(tuser.getId(), orgIdList.get(0), Globals.USER_OPTIONS_TYPE_PROJECT); } catch (Exception e) { e.printStackTrace(); org.jeecgframework.core.util.LogUtil.error(e.getMessage()); } }/*else{ TSUser tSUser=ResourceUtil.getSessionUser(); StringBuffer hql = new StringBuffer("from TSUserOrg where tsUser.id = :userid and status=0"); List tsList = systemService.getSession().createQuery(hql.toString()).setParameter("userid", tSUser.getId()).list(); if(!tsList.isEmpty()){ for (TSUserOrg tsUserOrg : tsList) { List ChildIdList = userDepartOrgDealService.getChildIdByProjectDepartId(tsUserOrg.getTsDepart().getId()); if(!ChildIdList.isEmpty()){ List ch = new ArrayList(); for (String str : ChildIdList) { if(!str.equals(tsUserOrg.getTsDepart().getId())){ ch.add(str); } } ChildIdList = ch; } userWage.setOrgIdList(ChildIdList); } } }*/ String moth = ""; String [] mothl = monthlys.split("-"); if("01".equals(mothl[1])){ moth = Integer.valueOf(mothl[0])-1+"-12-01 00:00:00"; }else{ //moth = mothl[0]+"-"+(Integer.valueOf(mothl[1])-1)+"-01 00:00:00"; moth = mothl[0] + "-" + "0" + (Integer.valueOf(mothl[1]) - 1) + "-01 00:00:00"; } if(StringUtils.isNotEmpty(monthlys)){ userWage.setMonthly(monthlys); }/*else{ Calendar cal = Calendar.getInstance(); int year = cal.get(Calendar.YEAR); int month = cal.get(Calendar.MONTH ); if(month < 10){ month = Integer.valueOf(0+""+month); } monthlys = year+"-"+month; request.setAttribute("monthlys", year+"-"+month); userWage.setMonthly(year+"-"+month); }*/ String authSql = JeecgDataAutorUtils.loadDataSearchConditonSQLString(); VisibleUserDto dto = dataPermissionService.getVisibleUserList();// 获取当前用户可见的userid列表 if(dto != null){ List list = new ArrayList(); Map map = new HashMap(); if(dto.getFlag().value().equalsIgnoreCase("ALL")){ list = userWageService.getAllEntities(userWage,null,moth,authSql); // map = userWageService.getMoneySUM(userWage,null,moth); }else if(dto.getFlag().value().equalsIgnoreCase("NONE")){ // 获取当前登录用户 HttpSession session = ContextHolderUtils.getSession(); TSUser user = (TSUser)session.getAttribute("LOCAL_CLINET_USER"); List uidList = new ArrayList(); uidList.add(user.getId()); list = userWageService.getAllEntities(userWage,uidList,moth,authSql); // map = userWageService.getMoneySUM(userWage,uidList,moth); }else if(dto.getFlag().value().equalsIgnoreCase("PART")){ List useridList = dto.getUseridList(); if(useridList != null && useridList.size() > 0){ list = userWageService.getAllEntities(userWage,useridList,moth,authSql); // map = userWageService.getMoneySUM(userWage,useridList,moth); } } //List list = userWageService.getAll(userWage,authSql); if(!list.isEmpty()){ for (Iterator iterator = list.iterator(); iterator.hasNext();) { UserWageDto userWageDto = (UserWageDto) iterator.next(); if (oConvertUtils.isEmpty(userWageDto.getId())) { userWageDto.setId("temp"+UUIDGenerator.generate()); } if(StringUtils.isNotEmpty(userWage.getStatus())){ if(StringUtils.isEmpty(userWageDto.getMonthly())){ iterator.remove(); } } if(StringUtils.isEmpty(userWageDto.getMonthly())){ userWageDto.setBelongUnitName(getBybelongId(userWageDto.getUserids())); } } /*for (UserWageDto us : list) { }*/ } Collections.sort(list); dataGrid.setResults(list); //代码层计算合计，不通过sql计算 try { calcuSumMap(map,list); } catch (Exception e) { e.printStackTrace(); } StringBuffer str = new StringBuffer(); for(String key : map.keySet()) { String value = map.get(key) == null ? "0.00" : map.get(key).toString(); str.append(key).append(":").append(value).append(","); } // str.append("basicWage:"+(String.valueOf(map.get("basicWage")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("basicWage")))+","); // str.append("dutiesAllowance:"+(String.valueOf(map.get("dutiesAllowance")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("dutiesAllowance")))+","); // str.append("certificateSubsidy:"+(String.valueOf(map.get("certificateSubsidy")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("certificateSubsidy")))+","); // str.append("trafficSubsidy:"+(String.valueOf(map.get("trafficSubsidy")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("trafficSubsidy")))+","); // str.append("megathermalSubsidy:"+(String.valueOf(map.get("megathermalSubsidy")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("megathermalSubsidy")))+","); // str.append("onlyChildCost:"+(String.valueOf(map.get("onlyChildCost")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("onlyChildCost")))+","); // str.append("otherSubsidy:"+(String.valueOf(map.get("otherSubsidy")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("otherSubsidy")))+","); // str.append("bonus:"+(String.valueOf(map.get("bonus")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("bonus")))+","); // str.append("projectPerformance:"+(String.valueOf(map.get("projectPerformance")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("projectPerformance")))+","); // str.append("mealsSubsidyDay:"+(String.valueOf(map.get("mealsSubsidyDay")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("mealsSubsidyDay")))+","); // str.append("mealsSubsidyNight:"+(String.valueOf(map.get("mealsSubsidyNight")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("mealsSubsidyNight")))+","); // str.append("mealsSubsidy:"+(String.valueOf(map.get("mealsSubsidy")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("mealsSubsidy")))+","); // str.append("overtimepayTimeout:"+(String.valueOf(map.get("overtimepayTimeout")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("overtimepayTimeout")))+","); // str.append("overtimepayFixed:"+(String.valueOf(map.get("overtimepayFixed")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("overtimepayFixed")))+","); // str.append("duty:"+(String.valueOf(map.get("duty")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("duty")))+","); // str.append("specialOvertime:"+(String.valueOf(map.get("specialOvertime")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("specialOvertime")))+","); // str.append("sickLeaveDebit:"+(String.valueOf(map.get("sickLeaveDebit")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("sickLeaveDebit")))+","); // str.append("thingLeaveDebit:"+(String.valueOf(map.get("thingLeaveDebit")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("thingLeaveDebit")))+","); // str.append("absenceDebit:"+(String.valueOf(map.get("absenceDebit")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("absenceDebit")))+","); // str.append("paymentSubsidy:"+(String.valueOf(map.get("paymentSubsidy")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("paymentSubsidy")))+","); // str.append("socialSecurityDebit:"+(String.valueOf(map.get("socialSecurityDebit")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("socialSecurityDebit")))+","); // str.append("providentFundDebit:"+(String.valueOf(map.get("providentFundDebit")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("providentFundDebit")))+","); // str.append("preTaxMone:"+(String.valueOf(map.get("preTaxMone")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("preTaxMone")))+","); // str.append("otherDebit:"+(String.valueOf(map.get("otherDebit")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("otherDebit")))+","); // str.append("reissue:"+(String.valueOf(map.get("reissue")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("reissue")))+","); // str.append("taxMoney:"+(String.valueOf(map.get("taxMoney")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("taxMoney")))+","); // str.append("actualMoney:"+(String.valueOf(map.get("actualMoney")).equalsIgnoreCase("null")?"0.00":String.valueOf(map.get("actualMoney")))); dataGrid.setFooter(str.toString()); } }else{ dataGrid.setResults(new ArrayList()); dataGrid.setFooter(""); } TagUtil.datagrid(response, dataGrid); } private void calcuSumMap(Map map, List list) throws Exception { if(map == null || list == null || list.isEmpty()) { return; } for(UserWageDto dto : list) { for(Field field : dto.getClass().getDeclaredFields()) { sumMapItem(dto,map, field); } } } private Method getGetMethod (UserWageDto dto, Field field) throws NoSuchMethodException, SecurityException { byte[] meth = field.getName().getBytes(); meth[0] = (byte)((char)meth[0]-'a'+'A'); return (Method)dto.getClass().getMethod("get" + new String(meth)); } private void sumMapItem(UserWageDto dto, Map map, Field field)throws Exception { if(dto == null || map == null) { return; } BigDecimal mapValue = map.get(field.getName()); BigDecimal dtoValue = null; if("class java.math.BigDecimal".equals(field.getGenericType().toString())){ dtoValue = (BigDecimal)getGetMethod(dto, field).invoke(dto); }else if("class java.lang.Integer".equals(field.getGenericType().toString())){ dtoValue = new BigDecimal((Integer)getGetMethod(dto, field).invoke(dto)); }else if("class java.lang.Double".equals(field.getGenericType().toString())){ dtoValue = new BigDecimal((Double)getGetMethod(dto, field).invoke(dto)); } if(dtoValue == null) { dtoValue = BigDecimal.ZERO; } if(mapValue == null) { map.put(field.getName(), dtoValue); }else { mapValue = mapValue.add(dtoValue); map.put(field.getName(), mapValue); } } /** * 通过人查询所属项目 * @param userid * @return */ private String getBybelongId(String userid){ String temp = ""; StringBuffer hql = new StringBuffer("from TSUserOrg where tsUser.id = :userid and ifpluralism = 0 and status=0"); List tsList = systemService.getSession().createQuery(hql.toString()).setParameter("userid", userid).list(); if(!tsList.isEmpty()){ TSUserOrg uo = tsList.get(0); TSDepart tsDepart = uo.getTsDepart(); if("1".equals(tsDepart.getOrgType()) || "3".equals(tsDepart.getOrgType()) || "4".equals(tsDepart.getOrgType()) || "5".equals(tsDepart.getOrgType())){ temp = tsDepart.getId(); }else if("2".equals(tsDepart.getOrgType()) && "1".equals(tsDepart.getTSPDepart().getOrgType())){ temp = tsDepart.getId(); }else{ temp = selectById(tsDepart.getId()); } temp = systemService.get(TSDepart.class, temp).getDepartname(); } return temp; } private String selectById(String id){ String temp = ""; TSDepart tsDepart =systemService.getEntity(TSDepart.class,id); if("3".equals(tsDepart.getOrgType()) || "5".equals(tsDepart.getOrgType())){ temp = tsDepart.getId(); }else{ if(tsDepart.getTSPDepart() != null){ selectById(tsDepart.getTSPDepart().getId()); temp = tsDepart.getTSPDepart().getId(); } } return temp; } /** * 删除员工工资核算表 * * @return */ @RequestMapping(params = "doDel") @ResponseBody public AjaxJson doDel(UserWageEntity userWage, HttpServletRequest request) { String message = null; AjaxJson j = new AjaxJson(); userWage = systemService.getEntity(UserWageEntity.class, userWage.getId()); message = "员工工资核算表删除成功"; try{ userWageService.delete(userWage); 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(",")){ UserWageEntity userWage = systemService.getEntity(UserWageEntity.class, id ); userWageService.delete(userWage); 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 = "doAdd") @ResponseBody public AjaxJson doAdd(UserWageEntity userWage, HttpServletRequest request) { String message = null; AjaxJson j = new AjaxJson(); message = "员工工资核算表添加成功"; try{ userWageService.save(userWage); 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; } /** * 更新员工工资核算表 * * @return */ @RequestMapping(params = "doUpdate") @ResponseBody public AjaxJson doUpdate(UserWageEntity userWage, HttpServletRequest request) { String message = null; AjaxJson j = new AjaxJson(); message = "员工工资核算表更新成功"; UserWageEntity t = userWageService.get(UserWageEntity.class, userWage.getId()); try { MyBeanUtils.copyBeanNotNull2Bean(userWage, t); userWageService.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(UserWageEntity userWage, HttpServletRequest req) { if (StringUtil.isNotEmpty(userWage.getId())) { userWage = userWageService.getEntity(UserWageEntity.class, userWage.getId()); req.setAttribute("userWagePage", userWage); } return new ModelAndView("cn/com/lzt/userwage/userWage-add"); } /** * 员工工资核算表编辑页面跳转 * * @return */ @RequestMapping(params = "goUpdate") public ModelAndView goUpdate(UserWageEntity userWage, HttpServletRequest req) { if (StringUtil.isNotEmpty(userWage.getId())) { userWage = userWageService.getEntity(UserWageEntity.class, userWage.getId()); req.setAttribute("userWagePage", userWage); } return new ModelAndView("cn/com/lzt/userwage/userWage-update"); } /** * 导入功能跳转 * * @return */ @RequestMapping(params = "upload") public ModelAndView upload(HttpServletRequest req) { req.setAttribute("controller_name","userWageController"); return new ModelAndView("common/upload/pub_excel_upload"); } /** * 员工工资条 * 导出excel * * @param request * @param response */ @RequestMapping(params = "exportWagePaperXls") public String exportWagePaperXls(UserWageDto userWage,HttpServletRequest request,HttpServletResponse response , DataGrid dataGrid,ModelMap modelMap) { String filename = "员工工资条"; List list = new ArrayList(); String orgIds = request.getParameter("orgIds"); String monthlys = request.getParameter("monthlys"); TSDepart depart = systemService.get(TSDepart.class, orgIds); if(depart != null) { filename = depart.getDepartname(); } // String departname = request.getParameter("departname"); // if(departname != null && departname.length()>0) { // filename = departname; // } if(monthlys != null && monthlys.length()>0) { filename = filename + "(" + monthlys + ")"; } if(StringUtils.isNotEmpty(orgIds) && StringUtils.isNotEmpty(monthlys)){ String monthly = request.getParameter("monthly"); String orgId = request.getParameter("orgid"); String type = request.getParameter("type"); if(StringUtils.isEmpty(orgIds)&&StringUtils.isNotEmpty(orgId)){ List orgIdList = extractIdListByComma(orgId); // 获取 当前组织机构的用户信息 if (!CollectionUtils.isEmpty(orgIdList)) { if(oConvertUtils.isNotEmpty(type) && "1".equals(type)){ userWage.setOrgIdList(orgIdList); }else{ String or = orgIdList.get(0); List ChildIdList = userDepartOrgDealService.getChildIdByProjectDepartId(or); userWage.setOrgIdList(ChildIdList); } } }else{ if(StringUtils.isNotEmpty(orgIds)){ List orgIdList = extractIdListByComma(orgIds); // 获取 当前组织机构的用户信息 if (!CollectionUtils.isEmpty(orgIdList)) { String or = orgIdList.get(0); List ChildIdList = userDepartOrgDealService.getChildIdByProjectDepartId(or); userWage.setOrgIdList(ChildIdList); } } } String moth = ""; String [] mothl = monthlys.split("-"); if("01".equals(mothl[1])){ moth = Integer.valueOf(mothl[0])-1+"-12-01"; }else{ moth = monthlys+"-01 00:00:00"; } if(StringUtils.isNotEmpty(monthlys)){ userWage.setMonthly(monthlys); }else{ if(StringUtils.isNotEmpty(monthly)){ request.setAttribute("monthlys", monthly); userWage.setMonthly(monthly); }else{ request.setAttribute("monthlys", getMonthlys()); userWage.setMonthly(getMonthlys()); } } String authSql = JeecgDataAutorUtils.loadDataSearchConditonSQLString(); VisibleUserDto dto = dataPermissionService.getVisibleUserList();// 获取当前用户可见的userid列表 if(dto != null){ if(dto.getFlag().value().equalsIgnoreCase("ALL")){ list = userWageService.getAllEntities(userWage,null,moth,authSql); }else if(dto.getFlag().value().equalsIgnoreCase("NONE")){ // 获取当前登录用户 HttpSession session = ContextHolderUtils.getSession(); TSUser user = (TSUser)session.getAttribute("LOCAL_CLINET_USER"); List uidList = new ArrayList(); uidList.add(user.getId()); list = userWageService.getAllEntities(userWage,uidList,moth,authSql); }else if(dto.getFlag().value().equalsIgnoreCase("PART")){ List uidList = dto.getUseridList(); if(uidList != null && uidList.size() > 0){ list = userWageService.getAllEntities(userWage,uidList,moth,authSql); } } } } // long s = System.currentTimeMillis(); // getDingAttendanceinfoEntitiesWithCache(); // long e = System.currentTimeMillis(); // System.out.println("ding: " + (e-s)/1000 +"s"); // // getDingAttendanceinfoEntitiesWithJDBC(); // // long e2 = System.currentTimeMillis(); // System.out.println("jdbc: " +(e2-e)/1000 + " s"); Collections.sort(list); List paperList = new ArrayList<>(); try { creatWagePaper(list, paperList); } catch (Exception e) { org.jeecgframework.core.util.LogUtil.error(e.getMessage()); } modelMap.put(NormalExcelConstants.FILE_NAME,filename); modelMap.put(NormalExcelConstants.CLASS,UserWagePaperDto.class); modelMap.put(NormalExcelConstants.PARAMS,new ExportParams("员工工资核算列表", "导出人:"+ResourceUtil.getSessionUser().getRealName(), "导出信息")); modelMap.put(NormalExcelConstants.DATA_LIST,paperList); return NormalExcelConstants.JEECG_EXCEL_VIEW; } private void getDingAttendanceinfoEntitiesWithJDBC() { // HashMap hm = hm_cache.get("getDingAttendanceinfoEntitiesWithCache"); // Date curdate = dto.getYmdDate(); // String strDateFormat = "yyyy-MM"; // SimpleDateFormat sdf = new SimpleDateFormat(strDateFormat); // Calendar calendar = Calendar.getInstance(); // calendar.setTime(curdate); // calendar.add(Calendar.DATE, 2); // Date tomdate = calendar.getTime(); // if(hm == null) { HashMap hm = new HashMap<>(); // hm_cache.put("getDingAttendanceinfoEntitiesWithCache", hm); // // CriteriaQuery cq = new CriteriaQuery(DingAttendanceinfoEntity.class); // cq.like("attendanceTime", sdf.format(curdate)+"%"); // cq.add(); // cq.between("attendanceTime", curdate, tomdate); // cq.add(); // cq.addOrder("attendanceTime", SortDirection.asc); String hql = "select id,user_id, attendance_time from t_bus_ding_attendanceinfo " + "where attendance_time like '2019-08%'"; List> mapList=new ArrayList>(); mapList = systemService.findForJdbc(hql, null); //getListByCriteriaQuery(cq, false); for(Map map : mapList) { DingAttendanceinfoEntity entity = new DingAttendanceinfoEntity(); entity.setId(map.get("id").toString()); entity.setUserId(map.get("user_id").toString()); entity.setAttendanceTime((Date)map.get("attendance_time")); String userInEntity = entity.getUserId(); if(hm.containsKey(userInEntity)) { List entitylist = (List)hm.get(userInEntity); entitylist.add(entity); }else { List newlist = new ArrayList<>(); newlist.add(entity); hm.put(userInEntity, newlist); } } // } // // List allList = (List)hm.get(dto.getUserid()); // if(allList == null) { // return new ArrayList(); // } // List selectList = new ArrayList<>(); // for(DingAttendanceinfoEntity attInAll : allList) { // Date attendanceTime = attInAll.getAttendanceTime(); // if(attendanceTime.after(curdate) && attendanceTime.before(tomdate)) { // selectList.add(attInAll); // } // } // return selectList; } /** * @return */ private void getDingAttendanceinfoEntitiesWithCache() { // HashMap hm = hm_cache.get("getDingAttendanceinfoEntitiesWithCache"); // Date curdate = dto.getYmdDate(); // String strDateFormat = "yyyy-MM"; // SimpleDateFormat sdf = new SimpleDateFormat(strDateFormat); // Calendar calendar = Calendar.getInstance(); // calendar.setTime(curdate); // calendar.add(Calendar.DATE, 2); // Date tomdate = calendar.getTime(); // if(hm == null) { HashMap hm = new HashMap<>(); // hm_cache.put("getDingAttendanceinfoEntitiesWithCache", hm); // // CriteriaQuery cq = new CriteriaQuery(DingAttendanceinfoEntity.class); // cq.like("attendanceTime", sdf.format(curdate)+"%"); // cq.add(); // cq.between("attendanceTime", curdate, tomdate); // cq.add(); // cq.addOrder("attendanceTime", SortDirection.asc); String hql = "from DingAttendanceinfoEntity where attendanceTime like '2019-08%'"; List entitiesFromDB = systemService.findHql(hql); //getListByCriteriaQuery(cq, false); for(DingAttendanceinfoEntity entity : entitiesFromDB) { String userInEntity = entity.getUserId(); if(hm.containsKey(userInEntity)) { List entitylist = (List)hm.get(userInEntity); entitylist.add(entity); }else { List newlist = new ArrayList<>(); newlist.add(entity); hm.put(userInEntity, newlist); } } // } // // List allList = (List)hm.get(dto.getUserid()); // if(allList == null) { // return new ArrayList(); // } // List selectList = new ArrayList<>(); // for(DingAttendanceinfoEntity attInAll : allList) { // Date attendanceTime = attInAll.getAttendanceTime(); // if(attendanceTime.after(curdate) && attendanceTime.before(tomdate)) { // selectList.add(attInAll); // } // } // return selectList; } /** * @param list * @param paperList * @throws InvocationTargetException * @throws IllegalArgumentException * @throws IllegalAccessException */ private void creatWagePaper(List list, List paperList) throws Exception { for(int i=0 ; i < list.size() ; i++) { UserWageDto dto = list.get(i); UserWagePaperDto papertitle = new UserWagePaperDto(); UserWagePaperDto paperitem = new UserWagePaperDto(); Field[] fields = UserWagePaperDto.class.getDeclaredFields(); for(int j=0 ; j0) { paperList.add(papertitle); } paperList.add(paperitem); } } /** * 员工工资核算 * 导出excel * * @param request * @param response */ @RequestMapping(params = "exportXls") public String exportXls(UserWageDto userWage,HttpServletRequest request,HttpServletResponse response , DataGrid dataGrid,ModelMap modelMap) { String filename = "员工工资核算"; List list = new ArrayList(); String orgIds = request.getParameter("orgIds"); String monthlys = request.getParameter("monthlys"); TSDepart depart = systemService.get(TSDepart.class, orgIds); if(depart != null) { filename = depart.getDepartname(); } // String departname = request.getParameter("departname"); // if(departname != null && departname.length()>0) { // filename = departname; // } if(monthlys != null && monthlys.length()>0) { filename = filename + "(" + monthlys + ")"; } if(StringUtils.isNotEmpty(orgIds) && StringUtils.isNotEmpty(monthlys)){ String monthly = request.getParameter("monthly"); String orgId = request.getParameter("orgid"); String type = request.getParameter("type"); if(StringUtils.isEmpty(orgIds)&&StringUtils.isNotEmpty(orgId)){ List orgIdList = extractIdListByComma(orgId); // 获取 当前组织机构的用户信息 if (!CollectionUtils.isEmpty(orgIdList)) { if(oConvertUtils.isNotEmpty(type) && "1".equals(type)){ userWage.setOrgIdList(orgIdList); }else{ String or = orgIdList.get(0); List ChildIdList = userDepartOrgDealService.getChildIdByProjectDepartId(or); userWage.setOrgIdList(ChildIdList); } } }else{ if(StringUtils.isNotEmpty(orgIds)){ List orgIdList = extractIdListByComma(orgIds); // 获取 当前组织机构的用户信息 if (!CollectionUtils.isEmpty(orgIdList)) { String or = orgIdList.get(0); List ChildIdList = userDepartOrgDealService.getChildIdByProjectDepartId(or); userWage.setOrgIdList(ChildIdList); } } } String moth = ""; String [] mothl = monthlys.split("-"); if("01".equals(mothl[1])){ moth = Integer.valueOf(mothl[0])-1+"-12-01"; }else{ moth = monthlys+"-01 00:00:00"; } if(StringUtils.isNotEmpty(monthlys)){ userWage.setMonthly(monthlys); }else{ if(StringUtils.isNotEmpty(monthly)){ request.setAttribute("monthlys", monthly); userWage.setMonthly(monthly); }else{ request.setAttribute("monthlys", getMonthlys()); userWage.setMonthly(getMonthlys()); } } String authSql = JeecgDataAutorUtils.loadDataSearchConditonSQLString(); VisibleUserDto dto = dataPermissionService.getVisibleUserList();// 获取当前用户可见的userid列表 if(dto != null){ if(dto.getFlag().value().equalsIgnoreCase("ALL")){ list = userWageService.getAllEntities(userWage,null,moth,authSql); }else if(dto.getFlag().value().equalsIgnoreCase("NONE")){ // 获取当前登录用户 HttpSession session = ContextHolderUtils.getSession(); TSUser user = (TSUser)session.getAttribute("LOCAL_CLINET_USER"); List uidList = new ArrayList(); uidList.add(user.getId()); list = userWageService.getAllEntities(userWage,uidList,moth,authSql); }else if(dto.getFlag().value().equalsIgnoreCase("PART")){ List uidList = dto.getUseridList(); if(uidList != null && uidList.size() > 0){ list = userWageService.getAllEntities(userWage,uidList,moth,authSql); } } } } Collections.sort(list); modelMap.put(NormalExcelConstants.FILE_NAME,filename); modelMap.put(NormalExcelConstants.CLASS,UserWageDto.class); modelMap.put(NormalExcelConstants.PARAMS,new ExportParams("员工工资核算列表", "导出人:"+ResourceUtil.getSessionUser().getRealName(), "导出信息")); modelMap.put(NormalExcelConstants.DATA_LIST,list); return NormalExcelConstants.JEECG_EXCEL_VIEW; } /** * 月度工资一览导出 * * @param request * @param response */ @RequestMapping(params = "exportXls1") public String exportXls1(UserWageViewDto userWage,HttpServletRequest request,HttpServletResponse response , DataGrid dataGrid,ModelMap modelMap) { MiniDaoPage list = new MiniDaoPage(); String monthlys = request.getParameter("monthlys"); // String departname = request.getParameter("departname"); String orgIds = request.getParameter("orgIds"); String filename = "员工月度工资一览"; TSDepart depart = systemService.get(TSDepart.class, orgIds); if(depart != null) { filename = depart.getDepartname(); } if(monthlys != null && monthlys.length()>0) { filename = filename + "(" + monthlys + ")"; } if(StringUtils.isNotEmpty(monthlys)){ List orgIdList = extractIdListByComma(orgIds); // 获取 当前组织机构的用户信息 if (!CollectionUtils.isEmpty(orgIdList)) { String or = orgIdList.get(0); List ChildIdList = userDepartOrgDealService.getChildIdByProjectDepartId(or); userWage.setOrgIdList(ChildIdList); } userWage.setMonthly(monthlys); String authSql = JeecgDataAutorUtils.loadDataSearchConditonSQLString(); VisibleUserDto dto = dataPermissionService.getVisibleUserList();// 获取当前用户可见的userid列表 if(dto != null){ if(dto.getFlag().value().equalsIgnoreCase("ALL")){ list = userWageService.getViewEntities(userWage,null,dataGrid.getPage(), dataGrid.getRows(), authSql); }else if(dto.getFlag().value().equalsIgnoreCase("NONE")){ // 获取当前登录用户 HttpSession session = ContextHolderUtils.getSession(); TSUser user = (TSUser)session.getAttribute("LOCAL_CLINET_USER"); List uidList = new ArrayList(); uidList.add(user.getId()); list = userWageService.getViewEntities(userWage,uidList,dataGrid.getPage(), dataGrid.getRows(), authSql); }else if(dto.getFlag().value().equalsIgnoreCase("PART")){ List useridList = dto.getUseridList(); if(useridList != null && useridList.size() > 0){ list = userWageService.getViewEntities(userWage,useridList,dataGrid.getPage(), dataGrid.getRows(), authSql); } } //MiniDaoPage list = userWageService.getViewEntities(userWage, dataGrid.getPage(), dataGrid.getRows(), authSql); //List list = userWageService.getAllEntities(userWage,authSql); } } modelMap.put(NormalExcelConstants.FILE_NAME,filename); modelMap.put(NormalExcelConstants.CLASS,UserWageViewDto.class); modelMap.put(NormalExcelConstants.PARAMS,new ExportParams("员工月度工资一览列表", "导出人:"+ResourceUtil.getSessionUser().getRealName(), "导出信息")); if(list.getResults() == null){ modelMap.put(NormalExcelConstants.DATA_LIST,new ArrayList<>()); }else{ modelMap.put(NormalExcelConstants.DATA_LIST,list.getResults()); } return NormalExcelConstants.JEECG_EXCEL_VIEW; } /** * 月度工资详细 * * @param request * @param response */ @RequestMapping(params = "exportXlsDetailByProject") public String exportXlsDetailByProject(@Param("orgId") String orgId ,@Param("monthly")String monthly,@Param("type")String type,HttpServletRequest request,HttpServletResponse response , DataGrid dataGrid,ModelMap modelMap) { String filename = "美都环卫全体员工工资详细"; UserWageDto userWage = new UserWageDto(); if(StringUtils.isNotEmpty(orgId)){ TSDepart depart = systemService.get(TSDepart.class, orgId); if(depart != null) { filename = depart.getDepartname(); } } // if(StringUtils.isNotEmpty(orgId) && departname != null && departname.length()>0) { // filename = departname; // } filename = filename.replaceAll(",", ""); if(monthly != null && monthly.length()>0) { filename = filename + "(" + monthly + ")"; } if(StringUtils.isNotEmpty(orgId)){ List orgIdList = extractIdListByComma(orgId); // 获取 当前组织机构的用户信息 if (!CollectionUtils.isEmpty(orgIdList)) { if(oConvertUtils.isNotEmpty(type) && "1".equals(type)){ userWage.setOrgIdList(orgIdList); }else{ String or = orgIdList.get(0); List ChildIdList = userDepartOrgDealService.getChildIdByProjectDepartId(or); userWage.setOrgIdList(ChildIdList); } } } if(StringUtils.isNotEmpty(monthly)){ userWage.setMonthly(monthly); } String authSql = JeecgDataAutorUtils.loadDataSearchConditonSQLString(); VisibleUserDto dto = dataPermissionService.getVisibleUserList();// 获取当前用户可见的userid列表 if(dto != null){ List list = new ArrayList(); if(dto.getFlag().value().equalsIgnoreCase("ALL")){ list = userWageService.getAllEntities(userWage,null,null,authSql); }else if(dto.getFlag().value().equalsIgnoreCase("NONE")){ // 获取当前登录用户 HttpSession session = ContextHolderUtils.getSession(); TSUser user = (TSUser)session.getAttribute("LOCAL_CLINET_USER"); List uidList = new ArrayList(); uidList.add(user.getId()); list = userWageService.getAllEntities(userWage,uidList,null,authSql); }else if(dto.getFlag().value().equalsIgnoreCase("PART")){ List useridList = dto.getUseridList(); if(useridList != null && useridList.size() > 0){ list = userWageService.getAllEntities(userWage,useridList,null,authSql); } } Collections.sort(list); modelMap.put(NormalExcelConstants.FILE_NAME,filename); modelMap.put(NormalExcelConstants.CLASS,UserWageDto.class); modelMap.put(NormalExcelConstants.PARAMS,new ExportParams("员工工资详细列表", "导出人:"+ResourceUtil.getSessionUser().getRealName(), "导出信息")); modelMap.put(NormalExcelConstants.DATA_LIST,list); } return NormalExcelConstants.JEECG_EXCEL_VIEW; } /** * 月度工资详细 * * @param request * @param response */ @RequestMapping(params = "exportXls2") public String exportXls2(UserWageDto userWage,HttpServletRequest request,HttpServletResponse response , DataGrid dataGrid,ModelMap modelMap) { String monthlys = request.getParameter("monthlys"); String monthly = request.getParameter("monthly"); String orgIds = request.getParameter("orgIds"); String orgId = request.getParameter("orgid"); String type = request.getParameter("type"); // String departname = request.getParameter("departname"); String filename = "员工工资详细"; // if(departname != null && departname.length()>0) { // filename = departname; // } if(monthlys != null && monthlys.length()>0) { filename = filename + "(" + monthlys + ")"; } if(StringUtils.isEmpty(orgIds)&&StringUtils.isNotEmpty(orgId)){ List orgIdList = extractIdListByComma(orgId); // 获取 当前组织机构的用户信息 if (!CollectionUtils.isEmpty(orgIdList)) { if(oConvertUtils.isNotEmpty(type) && "1".equals(type)){ userWage.setOrgIdList(orgIdList); }else{ String or = orgIdList.get(0); List ChildIdList = userDepartOrgDealService.getChildIdByProjectDepartId(or); userWage.setOrgIdList(ChildIdList); } } }else{ if(StringUtils.isNotEmpty(orgIds)){ List orgIdList = extractIdListByComma(orgIds); // 获取 当前组织机构的用户信息 if (!CollectionUtils.isEmpty(orgIdList)) { String or = orgIdList.get(0); List ChildIdList = userDepartOrgDealService.getChildIdByProjectDepartId(or); userWage.setOrgIdList(ChildIdList); } } } if(StringUtils.isNotEmpty(monthlys)){ userWage.setMonthly(monthlys); }else{ if(StringUtils.isNotEmpty(monthly)){ request.setAttribute("monthlys", monthly); userWage.setMonthly(monthly); }else{ request.setAttribute("monthlys", getMonthlys()); userWage.setMonthly(getMonthlys()); } //userWage.setMonthly(sim.format(sim.parse("2017-10"))); } String authSql = JeecgDataAutorUtils.loadDataSearchConditonSQLString(); VisibleUserDto dto = dataPermissionService.getVisibleUserList();// 获取当前用户可见的userid列表 if(dto != null){ List list = new ArrayList(); if(dto.getFlag().value().equalsIgnoreCase("ALL")){ list = userWageService.getAllEntities(userWage,null,null,authSql); }else if(dto.getFlag().value().equalsIgnoreCase("NONE")){ // 获取当前登录用户 HttpSession session = ContextHolderUtils.getSession(); TSUser user = (TSUser)session.getAttribute("LOCAL_CLINET_USER"); List uidList = new ArrayList(); uidList.add(user.getId()); list = userWageService.getAllEntities(userWage,uidList,null,authSql); }else if(dto.getFlag().value().equalsIgnoreCase("PART")){ List useridList = dto.getUseridList(); if(useridList != null && useridList.size() > 0){ list = userWageService.getAllEntities(userWage,useridList,null,authSql); } } Collections.sort(list); modelMap.put(NormalExcelConstants.FILE_NAME,filename); modelMap.put(NormalExcelConstants.CLASS,UserWageDto.class); modelMap.put(NormalExcelConstants.PARAMS,new ExportParams("员工工资详细列表", "导出人:"+ResourceUtil.getSessionUser().getRealName(), "导出信息")); modelMap.put(NormalExcelConstants.DATA_LIST,list); } return NormalExcelConstants.JEECG_EXCEL_VIEW; } /** * 月度工资明细 * 人事使用 * * @param request * @param response * @throws Exception */ @RequestMapping(params = "exportXls3") public String exportXls3(UserWageDto userWage,HttpServletRequest request,HttpServletResponse response , DataGrid dataGrid,ModelMap modelMap) throws Exception { String monthlys = request.getParameter("monthlys"); String monthly = request.getParameter("monthly"); String orgIds = request.getParameter("orgIds"); String orgId = request.getParameter("orgid"); String type = request.getParameter("type"); String departname = request.getParameter("departname"); String filename = "员工工资明细"; if(departname != null && departname.length()>0) { filename = departname; } if(monthlys != null && monthlys.length()>0) { filename = filename + "(" + monthlys + ")"; } if(StringUtils.isEmpty(orgIds)&&StringUtils.isNotEmpty(orgId)){ List orgIdList = extractIdListByComma(orgId); // 获取 当前组织机构的用户信息 if (!CollectionUtils.isEmpty(orgIdList)) { if(oConvertUtils.isNotEmpty(type) && "1".equals(type)){ userWage.setOrgIdList(orgIdList); }else{ String or = orgIdList.get(0); List ChildIdList = userDepartOrgDealService.getChildIdByProjectDepartId(or); userWage.setOrgIdList(ChildIdList); } } }else{ if(StringUtils.isNotEmpty(orgIds)){ List orgIdList = extractIdListByComma(orgIds); // 获取 当前组织机构的用户信息 if (!CollectionUtils.isEmpty(orgIdList)) { String or = orgIdList.get(0); List ChildIdList = userDepartOrgDealService.getChildIdByProjectDepartId(or); userWage.setOrgIdList(ChildIdList); } } } if(StringUtils.isNotEmpty(monthlys)){ userWage.setMonthly(monthlys); }else{ if(StringUtils.isNotEmpty(monthly)){ request.setAttribute("monthlys", monthly); userWage.setMonthly(monthly); }else{ request.setAttribute("monthlys", getMonthlys()); userWage.setMonthly(getMonthlys()); } //userWage.setMonthly(sim.format(sim.parse("2017-10"))); } String authSql = JeecgDataAutorUtils.loadDataSearchConditonSQLString(); // VisibleUserDto dto = dataPermissionService.getVisibleUserList();// 获取当前用户可见的userid列表 // // HashMap permKeyMap = null; //通过map来过滤 // if(dto != null){ List list = new ArrayList(); // permKeyMap = new HashMap(); List listDetail = new ArrayList(); // 取得所有的数据，然后在业务层过滤，效率会提高一些 list = userWageService.getAllEntities(userWage,null,null,authSql); UserWageDetaillsDto dto2 = null; for (UserWageDto userWageDto : list) { dto2 = new UserWageDetaillsDto(); MyBeanUtils.copyBeanNotNull2Bean(userWageDto,dto2); listDetail.add(dto2); } // if(dto.getFlag().value().equalsIgnoreCase("ALL")){ // UserWageDetaillsDto dto2 = null; // for (UserWageDto userWageDto : list) { // dto2 = new UserWageDetaillsDto(); // MyBeanUtils.copyBeanNotNull2Bean(userWageDto,dto2); // listDetail.add(dto2); // } // }else if(dto.getFlag().value().equalsIgnoreCase("NONE")){ // // 获取当前登录用户 // HttpSession session = ContextHolderUtils.getSession(); // TSUser user = (TSUser)session.getAttribute("LOCAL_CLINET_USER"); // permKeyMap.put(user.getId(), null); // UserWageDetaillsDto dto2 = null; // for (UserWageDto userWageDto : list) { // if(permKeyMap.containsKey(userWageDto.getUserid())) { // dto2 = new UserWageDetaillsDto(); // MyBeanUtils.copyBeanNotNull2Bean(userWageDto,dto2); // listDetail.add(dto2); // } // } // }else if(dto.getFlag().value().equalsIgnoreCase("PART")){ // List useridList = dto.getUseridList(); // if(useridList != null && useridList.size() > 0){ // for(String userid : useridList) { // permKeyMap.put(userid, null); // } // UserWageDetaillsDto dto2 = null; // for (UserWageDto userWageDto : list) { // if(permKeyMap.containsKey(userWageDto.getUserid())) { // dto2 = new UserWageDetaillsDto(); // MyBeanUtils.copyBeanNotNull2Bean(userWageDto,dto2); // listDetail.add(dto2); // } // } // } // } Collections.sort(listDetail); modelMap.put(NormalExcelConstants.FILE_NAME,filename); modelMap.put(NormalExcelConstants.CLASS,UserWageDetaillsDto.class); modelMap.put(NormalExcelConstants.PARAMS,new ExportParams("员工工资明细列表", "导出人:"+ResourceUtil.getSessionUser().getRealName(), "导出信息")); modelMap.put(NormalExcelConstants.DATA_LIST,listDetail); // } return NormalExcelConstants.JEECG_EXCEL_VIEW; } /** * 导出excel 使模板 * * @param request * @param response */ @RequestMapping(params = "exportXlsByT") public String exportXlsByT(UserWageEntity userWage,HttpServletRequest request,HttpServletResponse response , DataGrid dataGrid,ModelMap modelMap) { modelMap.put(NormalExcelConstants.FILE_NAME,"员工工资核算表"); modelMap.put(NormalExcelConstants.CLASS,UserWageEntity.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 fileMap = multipartRequest.getFileMap(); for (Map.Entry entity : fileMap.entrySet()) { MultipartFile file = entity.getValue();// 获取上传文件对象 ImportParams params = new ImportParams(); params.setTitleRows(2); params.setHeadRows(1); params.setNeedSave(true); try { List listUserWageEntitys = ExcelImportUtil.importExcel(file.getInputStream(),UserWageEntity.class,params); for (UserWageEntity userWage : listUserWageEntitys) { userWageService.save(userWage); } 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 list() { List listUserWages=userWageService.getList(UserWageEntity.class); return listUserWages; } @RequestMapping(value = "/{id}", method = RequestMethod.GET) @ResponseBody public ResponseEntity get(@PathVariable("id") String id) { UserWageEntity task = userWageService.get(UserWageEntity.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 UserWageEntity userWage, UriComponentsBuilder uriBuilder) { //调用JSR303 Bean Validator进行校验，如果出错返回含400错误码及json格式的错误信息. Set> failures = validator.validate(userWage); if (!failures.isEmpty()) { return new ResponseEntity(BeanValidators.extractPropertyAndMessage(failures), HttpStatus.BAD_REQUEST); } //保存 try{ userWageService.save(userWage); } catch (Exception e) { e.printStackTrace(); return new ResponseEntity(HttpStatus.NO_CONTENT); } //按照Restful风格约定，创建指向新任务的url, 也可以直接返回id或对象. String id = userWage.getId(); URI uri = uriBuilder.path("/rest/userWageController/" + 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 UserWageEntity userWage) { //调用JSR303 Bean Validator进行校验，如果出错返回含400错误码及json格式的错误信息. Set> failures = validator.validate(userWage); if (!failures.isEmpty()) { return new ResponseEntity(BeanValidators.extractPropertyAndMessage(failures), HttpStatus.BAD_REQUEST); } //保存 try{ userWageService.saveOrUpdate(userWage); } 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) { userWageService.deleteEntityById(UserWageEntity.class, id); } /** * 保存新增/更新的行数据 * @param page * @return * @throws Exception */ @RequestMapping(params = "saveRows") @ResponseBody public AjaxJson saveRows(UserwagePage page) throws Exception{ List demos=page.getUserWageList(); AjaxJson j = userWageService.addOrEdit(demos); return j; } /** * 工资进行上报 * @param request * @param status * @return */ @RequestMapping(params="updateStatus") @ResponseBody public AjaxJson updateStatus(HttpServletRequest request,boolean status){ String ids = request.getParameter("ids"); List idList = extractIdListByComma(ids); AjaxJson j = userWageService.updateStatus(idList, status); return j; } @RequestMapping(params = "budgetlist") public ModelAndView budgetlist(HttpServletRequest request) { // String orgid = request.getParameter("orgid"); // String monthly = request.getParameter("monthly"); // if(oConvertUtils.isNotEmpty(monthly)){ // request.setAttribute("monthlys", monthly); // request.setAttribute("orgid", orgid); // }else{ // request.setAttribute("monthlys", getMonthlys()); // } return new ModelAndView("cn/com/lzt/userwage/userWageViewBudgetList"); } @RequestMapping(params = "datagridbudget") public void datagridbudget(UserWageViewDto userWage,HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) { List> retList = getWageAndBudgetList(userWage); dataGrid.setResults(retList); TagUtil.datagrid(response, dataGrid); } private List> getWageAndBudgetList(UserWageViewDto userWage) { List> retList = new ArrayList>(); String year = userWage.getMonthly().substring(0,4); int monthInt = Integer.valueOf(userWage.getMonthly().substring(5)); String month = "month"+monthInt; String qrySql = "select '"+userWage.getMonthly()+"' as yearmonth, \n" + " wage.*,\n" + " IFNULL(budget.projovertimebudget,0) as projovertimebudget,\n" + " IFNULL(budget.govovertimebudget,0) as govovertimebudget,\n" + " IFNULL(budget.ondutybudget,0) as ondutybudget\n" + "from (\n" + " SELECT \n" + " sum(c.overtimepay_timeout+c.special_overtime) as projovertime, \n" + " sum(c.duty) as onduty, \n" + " sum(c.overtimepay_Fixed) as govovertime, \n" + " d.id as departid,\n" + " d.departname AS departname\n" + " FROM\n" + " t_bus_user_wage c\n" + " LEFT JOIN t_s_base_user u ON c.userid = u.id\n" + " LEFT JOIN t_s_depart d ON d.id = c.pjt_id\n" + " WHERE u.delete_flag = '0' \n" + " and monthly =? \n" + " group BY\n" + " d.id) wage\n" + "left join (\n" + " select \n" + " depart_id as departid,\n" + " dep_name as departname ,\n" + " sum(case when budget_type = 'code1' then "+month+" else 0 end) as projovertimebudget ,\n" + " sum(case when budget_type = 'code2' then "+month+" else 0 end ) as govovertimebudget ,\n" + " sum(case when budget_type = 'code3' or budget_type = 'code4' then "+month+" else 0 end ) as ondutybudget \n" + " from t_b_overtime_budget\n" + " where years =? \n" + " group by depart_id ) budget on budget.departid = wage.departid " + "left join t_s_depart t on t.id = wage.departid " + "where t.org_type in ('3','5') "; if(StringUtils.isNotEmpty(userWage.getPjtId())) { qrySql +=" and wage.departid = '"+userWage.getPjtId()+"' order by CONVERT(wage.departname using gbk)"; }else { qrySql +=" order by CONVERT(wage.departname using gbk)"; } retList = systemService.findForJdbc(qrySql, userWage.getMonthly(),year); return retList; } @RequestMapping(params = "exportXlsBudget") public void exportXlsBudget(UserWageViewDto userWage,HttpServletRequest request,HttpServletResponse response , DataGrid dataGrid,ModelMap modelMap) { List> retList = getWageAndBudgetList(userWage); String codedFileName = "加班预算执行表"; Workbook workbook = null; List entityList = new ArrayList(); ExcelExportEntity head1 = new ExcelExportEntity("项目管理处", "departname", 30); entityList.add(head1); ExcelExportEntity head2 = new ExcelExportEntity("工资月度", "yearmonth", 15); entityList.add(head2); ExcelExportEntity head3 = new ExcelExportEntity("项目加班费预算", "projovertimebudget", 15); entityList.add(head3); ExcelExportEntity head4 = new ExcelExportEntity("项目加班费发生额", "projovertime", 15); entityList.add(head4); ExcelExportEntity head5 = new ExcelExportEntity("国定加班费预算", "govovertimebudget", 15); entityList.add(head5); ExcelExportEntity head6 = new ExcelExportEntity("国定加班费发生额", "govovertime", 15); entityList.add(head6); ExcelExportEntity head7 = new ExcelExportEntity("值班费预算", "ondutybudget", 15); entityList.add(head7); ExcelExportEntity head8 = new ExcelExportEntity("值班费发生额", "onduty", 15); entityList.add(head8); List> resultData = retList; workbook = ExcelExportUtil.exportExcel(workbook, new ExportParams("加班预算执行表", "导出人:" + ResourceUtil.getSessionUser().getRealName(), "加班预算执行表"), entityList, resultData); if (workbook instanceof HSSFWorkbook) { codedFileName +=".xls"; } else { codedFileName +=".xlsx"; } try { //IE if (request.getHeader("USER-AGENT").toLowerCase().indexOf("msie") > 0 || request.getHeader("USER-AGENT").toLowerCase().indexOf("rv:11.0") > 0){ codedFileName = java.net.URLEncoder.encode(codedFileName, "UTF8"); } else { codedFileName = new String(codedFileName.getBytes("UTF-8"), "ISO-8859-1"); } response.setHeader("content-disposition", "attachment;filename=" + codedFileName); ServletOutputStream out = response.getOutputStream(); workbook.write(out); out.flush(); } catch (UnsupportedEncodingException e) { logger.error(e.getMessage()); } catch (IOException e) { logger.error(e.getMessage()); } } /** * 一线员工未排班，不能修改工资条 * */ @RequestMapping(params = "checkRowEdit") @ResponseBody public AjaxJson checkRowEdit(UserwagePage page) throws Exception{ AjaxJson j = new AjaxJson(); List userwages=page.getUserWageList(); String usernames = ""; for (UserWageEntity userWage : userwages) { userWage = systemService.get(UserWageEntity.class,userWage.getId()); String userid = userWage.getUserid(); String deptid = userWage.getPjtId(); String month = userWage.getMonthly(); if(!UserUtil.isProjectUser(userid)) continue; //查看是否排班 String arrangeSql = "select count(*) from t_bus_projarrange_detail where userid =? and yearmonth =? and pid = ?"; Map arrangeCountRet = systemService.findOneForJdbc(arrangeSql, userid,month,deptid); int count = Integer.valueOf(arrangeCountRet.get("count(*)").toString()); if(count == 0) { usernames += systemService.get(TSUser.class, userid).getRealName()+"
"; } } if(StringUtils.isNotEmpty(usernames)) { j.setSuccess(false); j.setMsg("以下员工未排班，不能修改工资：
"+usernames); } return j; } }