meidu2021/daju/target/classes/cn/com/lzt/wagestrategy/controller/WagestrategyController.java

package cn.com.lzt.wagestrategy.controller;
import cn.com.lzt.duties.entity.DutiesEntity;
import cn.com.lzt.duties.service.DutiesServiceI;
import cn.com.lzt.wagestrategy.dto.WagestrategyDto;
import cn.com.lzt.wagestrategy.entity.WagestrategyEntity;
import cn.com.lzt.wagestrategy.entity.ZTreeDutiesEntity;
import cn.com.lzt.wagestrategy.service.WagestrategyServiceI;
import org.apache.commons.lang.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.hibernate.qbc.CriteriaQuery;
import org.jeecgframework.core.common.model.json.AjaxJson;
import org.jeecgframework.core.common.model.json.DataGrid;
import org.jeecgframework.core.constant.Globals;
import org.jeecgframework.core.util.*;
import org.jeecgframework.minidao.pojo.MiniDaoPage;
import org.jeecgframework.poi.excel.ExcelImportUtil;
import org.jeecgframework.poi.excel.entity.ExportParams;
import org.jeecgframework.poi.excel.entity.ImportParams;
import org.jeecgframework.poi.excel.entity.vo.NormalExcelConstants;
import org.jeecgframework.tag.core.easyui.TagUtil;
import org.jeecgframework.web.system.pojo.base.DictEntity;
import org.jeecgframework.web.system.pojo.base.TSDepart;
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.validation.ConstraintViolation;
import javax.validation.Validator;
import java.io.IOException;
import java.math.BigDecimal;
import java.net.URI;
import java.util.*;
import java.util.regex.Matcher;
import java.util.regex.Pattern;

/**   
 * @Title: Controller  
 * @Description: 工资策略表
 * @author onlineGenerator
 * @date 2017-10-11 12:58:25
 * @version V1.0   
 *
 */
@Controller
@RequestMapping("/wagestrategyController")
public class WagestrategyController extends BaseController {
	/**
	 * Logger for this class
	 */
	private static final Logger logger = Logger.getLogger(WagestrategyController.class);

	@Autowired
	private WagestrategyServiceI wagestrategyService;
	@Autowired
	private SystemService systemService;
	@Autowired
	private Validator validator;
	@Autowired
	private DutiesServiceI dutiesService;
	
	
	
	/**
	 * 状态启用
	 * @author zbw
	 * 2017-10-12
	 * @param id
	 * @param request
	 * @return
	 */
	@RequestMapping(params = "enable")
	@ResponseBody
	public AjaxJson enable(String id, HttpServletRequest request) {
		/*AjaxJson j = new AjaxJson();
		String message = null;
		WagestrategyEntity wagestrategy = wagestrategyService.getEntity(WagestrategyEntity.class, id);
		try{
			wagestrategy.setStatus(Globals.Enabled_Status.toString());
			wagestrategyService.updateEntitie(wagestrategy);
			message = "工资策略：" + "" + "启用成功!";
			systemService.addLog(message, Globals.Log_Type_UPDATE, Globals.Log_Leavel_INFO);
		}catch(Exception e){
			message = "操作失败!";
		}
		j.setMsg(message);
		return j;*/
		
		String message = null;
		AjaxJson j = new AjaxJson();
		message = "工资策略启用成功";
		try{
			WagestrategyEntity wagestrategy = wagestrategyService.getEntity(WagestrategyEntity.class, id);
			wagestrategy.setStatus(Globals.Enabled_Status.toString());
			wagestrategyService.saveOrUpdate(wagestrategy);
			systemService.addLog(message, Globals.Log_Type_UPDATE, Globals.Log_Leavel_INFO);
		}catch(Exception e){
			e.printStackTrace();
			message = "工资策略启用失败";
			j.setSuccess(false);
		}
		j.setMsg(message);
		return j;
	}
	
	/**
	 * 状态停用
	 * @author zbw
	 * 2017-10-12
	 * @param id
	 * @param request
	 * @return
	 */
	@RequestMapping(params = "disable")
	@ResponseBody
	public AjaxJson disable(String id, HttpServletRequest request) {
		/*AjaxJson j = new AjaxJson();
		String message = null;
		WagestrategyEntity wagestrategy = wagestrategyService.getEntity(WagestrategyEntity.class, id);
		try{
			wagestrategy.setStatus(Globals.Disabled_Status.toString());
			wagestrategyService.updateEntitie(wagestrategy);
			message = "工资策略：" + "" + "停用成功!";
			systemService.addLog(message, Globals.Log_Type_UPDATE, Globals.Log_Leavel_INFO);
		}catch(Exception e){
			message = "操作失败!";
		}
		j.setMsg(message);
		return j;*/
		
		String message = null;
		AjaxJson j = new AjaxJson();
		message = "工资策略停用成功";
		try{
			WagestrategyEntity wagestrategy = wagestrategyService.getEntity(WagestrategyEntity.class, id);
			wagestrategy.setStatus(Globals.Disabled_Status.toString());
			wagestrategyService.saveOrUpdate(wagestrategy);
			systemService.addLog(message, Globals.Log_Type_UPDATE, Globals.Log_Leavel_INFO);
		}catch(Exception e){
			e.printStackTrace();
			message = "工资策略停用失败";
			j.setSuccess(false);
		}
		j.setMsg(message);
		return j;
	}
	
	/**
	 * 用户选择职务跳转页面dutiesService表格
	 * 
	 * @return
	 */
	@RequestMapping(params = "getDuties")
	public ModelAndView roles(HttpServletRequest request) {
		//--author：zhoujf-----start----date:20150531--------for: 编辑用户，选择角色,弹出的角色列表页面，默认没选中
//		ModelAndView mv = new ModelAndView("system/user/users");
		ModelAndView mv = new ModelAndView("cn/com/lzt/wagestrategy/dutiesTable");
		String ids = oConvertUtils.getString(request.getParameter("ids"));
		mv.addObject("ids", ids);
		return mv;
		//--author：zhoujf-----end------date:20150531--------for: 编辑用户，选择角色,弹出的角色列表页面，默认没选中
	}


	/**
	 * 公司级职务津贴表列表 页面跳转
	 * 
	 * @return
	 */
	@RequestMapping(params = "list")
	public ModelAndView list(HttpServletRequest request) {
		return new ModelAndView("cn/com/lzt/wagestrategy/wagestrategyList");
	}
	
	/**
	 * 公司级职务津贴表列表 页面跳转
	 * 
	 * @return
	 */
	@RequestMapping(params = "comList")
	public ModelAndView comList(HttpServletRequest request) {
		return new ModelAndView("cn/com/lzt/wagestrategy/wagestrategyComList");
	}
	/**
	 * 区域级职务津贴表列表 页面跳转
	 * 
	 * @return
	 */
	@RequestMapping(params = "zoneList")
	public ModelAndView zoneList(HttpServletRequest request) {
		return new ModelAndView("cn/com/lzt/wagestrategy/wagestrategyZoneList");
	}

	
	/**
	 * 区域级职务津贴表列表 页面跳转
	 * 
	 * @return
	 */
	@RequestMapping(params = "projectList")
	public ModelAndView projectList(HttpServletRequest request) {
		return new ModelAndView("cn/com/lzt/wagestrategy/wagestrategyProjectList");
	}
	
	/**
	 * easyui AJAX请求数据
	 * 
	 * @param request
	 * @param response
	 * @param dataGrid
	 * @param user
	 */

	@RequestMapping(params = "datagrid_project")
	public void datagrid_project(WagestrategyDto wagestrategyDto,HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
		String authSql = JeecgDataAutorUtils.loadDataSearchConditonSQLString();
		
		String sortorder = "";
		String sort = dataGrid.getSort(); // 排序对象
		String order = dataGrid.getOrder(); // 排序方式
		if (StringUtil.isEmpty(sort)) {
			sortorder = " bw.create_date desc "; //默认userName,userId降序
		} else {
			sortorder = humpToLine(sort) + " " + order; // 处理下划线，拼接排序
		}
		
		MiniDaoPage<WagestrategyDto> wagestrategyDtoList = wagestrategyService.getProjectWagestrategyDtoPage(wagestrategyDto, dataGrid.getPage(), dataGrid.getRows(), authSql, sortorder);
		
		//获取班次名称
		List<DictEntity> dutiesList=systemService.queryDict("t_bus_duties", "id", "duties_name");
		Map<String, Object> dutiesMap=new HashMap<String, Object>();
		for (int i = 0; i < dutiesList.size(); i++) {
			dutiesMap.put(dutiesList.get(i).getTypecode(), dutiesList.get(i).getTypename());
		}
		
		for (int i = wagestrategyDtoList.getResults().size()-1; i > -1 ; i--) {
			wagestrategyDtoList.getResults().get(i).setDutiesName(dutiesMap.get(wagestrategyDtoList.getResults().get(i).getDutiesId()).toString());
		}
		
	
		StringBuffer hql = new StringBuffer(" from DutiesEntity t ");
		List<DutiesEntity> dutiesEntityList = wagestrategyService.findHql(hql.toString());
		for (int i = 0; i < wagestrategyDtoList.getResults().size(); i++) {
			for (int j = 0; j < dutiesEntityList.size(); j++) {
				if(wagestrategyDtoList.getResults().get(i).getDutiesId().equals(dutiesEntityList.get(j).getId())){
					if(dutiesMap.get(dutiesEntityList.get(j).getParentDutiesid())!=null){
						wagestrategyDtoList.getResults().get(i).setParentDutiesName(dutiesMap.get(dutiesEntityList.get(j).getParentDutiesid()).toString());
					}
				}
			}
		}
		dataGrid.setResults(wagestrategyDtoList.getResults());
		dataGrid.setTotal(wagestrategyDtoList.getTotal());
 		TagUtil.datagrid(response, dataGrid);
	}
	
	/**
	 * easyui AJAX请求数据
	 * 
	 * @param request
	 * @param response
	 * @param dataGrid
	 * @param user
	 */

	@RequestMapping(params = "datagrid_com")
	public void datagrid_com(WagestrategyDto wagestrategyDto,HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
		String authSql = JeecgDataAutorUtils.loadDataSearchConditonSQLString();
		
		String sortorder = "";
		String sort = dataGrid.getSort(); // 排序对象
		String order = dataGrid.getOrder(); // 排序方式
		if (StringUtil.isEmpty(sort)) {
			sortorder = " bw.create_date desc "; //默认userName,userId降序
		} else {
			sortorder = humpToLine(sort) + " " + order; // 处理下划线，拼接排序
		}
		
		MiniDaoPage<WagestrategyDto> wagestrategyDtoList = wagestrategyService.getWagestrategyDtoPage(wagestrategyDto, dataGrid.getPage(), dataGrid.getRows(), authSql, sortorder);
		
		//获取班次名称
		List<DictEntity> dutiesList=systemService.queryDict("t_bus_duties", "id", "duties_name");
		Map<String, Object> dutiesMap=new HashMap<String, Object>();
		for (int i = 0; i < dutiesList.size(); i++) {
			dutiesMap.put(dutiesList.get(i).getTypecode(), dutiesList.get(i).getTypename());
		}
		
		for (int i = wagestrategyDtoList.getResults().size()-1; i > -1 ; i--) {
			wagestrategyDtoList.getResults().get(i).setDutiesName(dutiesMap.get(wagestrategyDtoList.getResults().get(i).getDutiesId()).toString());
		}
		
	
		StringBuffer hql = new StringBuffer(" from DutiesEntity t ");
		List<DutiesEntity> dutiesEntityList = wagestrategyService.findHql(hql.toString());
		for (int i = 0; i < wagestrategyDtoList.getResults().size(); i++) {
			for (int j = 0; j < dutiesEntityList.size(); j++) {
				if(wagestrategyDtoList.getResults().get(i).getDutiesId().equals(dutiesEntityList.get(j).getId())){
					if(dutiesMap.get(dutiesEntityList.get(j).getParentDutiesid())!=null){
						wagestrategyDtoList.getResults().get(i).setParentDutiesName(dutiesMap.get(dutiesEntityList.get(j).getParentDutiesid()).toString());
					}
				}
			}
		}
		dataGrid.setResults(wagestrategyDtoList.getResults());
		dataGrid.setTotal(wagestrategyDtoList.getTotal());
 		TagUtil.datagrid(response, dataGrid);
	}
	
	/**
	 * easyui AJAX请求数据
	 * 
	 * @param request
	 * @param response
	 * @param dataGrid
	 * @param user
	 */

	@RequestMapping(params = "datagrid_zone")
	public void datagrid_zone(WagestrategyDto wagestrategyDto,HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
		String authSql = JeecgDataAutorUtils.loadDataSearchConditonSQLString();
		
		String sortorder = "";
		String sort = dataGrid.getSort(); // 排序对象
		String order = dataGrid.getOrder(); // 排序方式
		if (StringUtil.isEmpty(sort)) {
			sortorder = " bw.create_date desc "; //默认userName,userId降序
		} else {
			sortorder = humpToLine(sort) + " " + order; // 处理下划线，拼接排序
		}
		
		MiniDaoPage<WagestrategyDto> wagestrategyDtoList = wagestrategyService.getZoneWagestrategyDtoPage(wagestrategyDto, dataGrid.getPage(), dataGrid.getRows(), authSql, sortorder);
		
		//获取班次名称
		List<DictEntity> dutiesList=systemService.queryDict("t_bus_duties", "id", "duties_name");
		Map<String, Object> dutiesMap=new HashMap<String, Object>();
		for (int i = 0; i < dutiesList.size(); i++) {
			dutiesMap.put(dutiesList.get(i).getTypecode(), dutiesList.get(i).getTypename());
		}
		
		for (int i = wagestrategyDtoList.getResults().size()-1; i > -1 ; i--) {
			wagestrategyDtoList.getResults().get(i).setDutiesName(dutiesMap.get(wagestrategyDtoList.getResults().get(i).getDutiesId()).toString());
		}
		
	
		StringBuffer hql = new StringBuffer(" from DutiesEntity t ");
		List<DutiesEntity> dutiesEntityList = wagestrategyService.findHql(hql.toString());
		for (int i = 0; i < wagestrategyDtoList.getResults().size(); i++) {
			for (int j = 0; j < dutiesEntityList.size(); j++) {
				if(wagestrategyDtoList.getResults().get(i).getDutiesId().equals(dutiesEntityList.get(j).getId())){
					if(dutiesMap.get(dutiesEntityList.get(j).getParentDutiesid())!=null){
						wagestrategyDtoList.getResults().get(i).setParentDutiesName(dutiesMap.get(dutiesEntityList.get(j).getParentDutiesid()).toString());
					}
				}
			}
		}
		dataGrid.setResults(wagestrategyDtoList.getResults());
		dataGrid.setTotal(wagestrategyDtoList.getTotal());
 		TagUtil.datagrid(response, dataGrid);
	}

	/**
	 * easyui AJAX请求数据
	 * 
	 * @param request
	 * @param response
	 * @param dataGrid
	 * @param user
	 */

	@RequestMapping(params = "datagrid")
	public void datagrid(WagestrategyDto wagestrategyDto,HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
		String authSql = JeecgDataAutorUtils.loadDataSearchConditonSQLString();
		
		String sortorder = "";
		String sort = dataGrid.getSort(); // 排序对象
		String order = dataGrid.getOrder(); // 排序方式
		if (StringUtil.isEmpty(sort)) {
			sortorder = " bw.create_date desc "; //默认userName,userId降序
		} else {
			sortorder = humpToLine(sort) + " " + order; // 处理下划线，拼接排序
		}
		
		MiniDaoPage<WagestrategyDto> wagestrategyDtoList = wagestrategyService.getWagestrategyDtoPage(wagestrategyDto, dataGrid.getPage(), dataGrid.getRows(), authSql, sortorder);
		
		//获取班次名称
		List<DictEntity> dutiesList=systemService.queryDict("t_bus_duties", "id", "duties_name");
		Map<String, Object> dutiesMap=new HashMap<String, Object>();
		for (int i = 0; i < dutiesList.size(); i++) {
			dutiesMap.put(dutiesList.get(i).getTypecode(), dutiesList.get(i).getTypename());
		}
		
		for (int i = wagestrategyDtoList.getResults().size()-1; i > -1 ; i--) {
			wagestrategyDtoList.getResults().get(i).setDutiesName(dutiesMap.get(wagestrategyDtoList.getResults().get(i).getDutiesId()).toString());
		}
		
	
		StringBuffer hql = new StringBuffer(" from DutiesEntity t ");
		List<DutiesEntity> dutiesEntityList = wagestrategyService.findHql(hql.toString());
		for (int i = 0; i < wagestrategyDtoList.getResults().size(); i++) {
			for (int j = 0; j < dutiesEntityList.size(); j++) {
				if(wagestrategyDtoList.getResults().get(i).getDutiesId().equals(dutiesEntityList.get(j).getId())){
					if(dutiesMap.get(dutiesEntityList.get(j).getParentDutiesid())!=null){
						wagestrategyDtoList.getResults().get(i).setParentDutiesName(dutiesMap.get(dutiesEntityList.get(j).getParentDutiesid()).toString());
					}
				}
			}
		}
		dataGrid.setResults(wagestrategyDtoList.getResults());
		dataGrid.setTotal(wagestrategyDtoList.getTotal());
 		TagUtil.datagrid(response, dataGrid);
	}
	
	/**
	 * 逻辑删除工资策略表
	 * @author zbw
	 * 2017-10-12
	 * @param wagestrategy
	 * @param request
	 * @return
	 */
	@RequestMapping(params = "logicDel")
	@ResponseBody
	public AjaxJson logicDel(WagestrategyEntity wagestrategy, HttpServletRequest request) {
		String message = null;
		AjaxJson j = new AjaxJson();
		wagestrategy = systemService.getEntity(WagestrategyEntity.class, wagestrategy.getId());
		message = "工资策略删除成功";
		try{
			wagestrategy.setDeleteFlag(Globals.Delete_Forbidden.toString());
			wagestrategyService.logicDel(wagestrategy);
			systemService.addLog(message, Globals.Log_Type_DEL, Globals.Log_Leavel_INFO);
			
//			wagestrategyService.delete(wagestrategy);
//			systemService.addLog(message, Globals.Log_Type_DEL, Globals.Log_Leavel_INFO);
		}catch(Exception e){
			e.printStackTrace();
			message = "工资策略删除失败";
			j.setSuccess(false);
		}
		j.setMsg(message);
		return j;
	}

	/**
	 * 删除工资策略表
	 * 
	 * @return
	 */
	@RequestMapping(params = "doDel")
	@ResponseBody
	public AjaxJson doDel(WagestrategyEntity wagestrategy, HttpServletRequest request) {
		String message = null;
		AjaxJson j = new AjaxJson();
		wagestrategy = systemService.getEntity(WagestrategyEntity.class, wagestrategy.getId());
		message = "工资策略删除成功";
		try{
			wagestrategyService.delete(wagestrategy);
			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(",")){
				WagestrategyEntity wagestrategy = systemService.getEntity(WagestrategyEntity.class, 
				id
				);
				wagestrategyService.delete(wagestrategy);
				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(WagestrategyEntity wagestrategy, HttpServletRequest request) {
		String message = null;
		AjaxJson j = new AjaxJson();
		message = "工资策略添加成功";
		try{
			String myDutiesId=wagestrategy.getDutiesId();
			String[] myDutiesIdList=myDutiesId.split(",");
			wagestrategy.setDutiesId(myDutiesIdList[0]);
			wagestrategy.setDeleteFlag(Globals.Delete_Normal.toString());
			wagestrategy.setStatus(Globals.Enabled_Status.toString());
			wagestrategyService.save(wagestrategy);
			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(WagestrategyEntity wagestrategy, HttpServletRequest request) {
		String message = null;
		AjaxJson j = new AjaxJson();
		message = "工资策略更新成功";
		WagestrategyEntity t = wagestrategyService.get(WagestrategyEntity.class, wagestrategy.getId());
		try {
			MyBeanUtils.copyBeanNotNull2Bean(wagestrategy, t);
			wagestrategyService.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(WagestrategyEntity wagestrategy, HttpServletRequest req) {
		if (StringUtil.isNotEmpty(wagestrategy.getId())) {
			wagestrategy = wagestrategyService.getEntity(WagestrategyEntity.class, wagestrategy.getId());
			req.setAttribute("wagestrategyPage", wagestrategy);
		}
		return new ModelAndView("cn/com/lzt/wagestrategy/wagestrategy-add");
	}
	/**
	 * 工资策略表编辑页面跳转
	 * 
	 * @return
	 */
	@RequestMapping(params = "goUpdate")
	public ModelAndView goUpdate(WagestrategyEntity wagestrategy, HttpServletRequest req) {
		if (StringUtil.isNotEmpty(wagestrategy.getId())) {
			wagestrategy = wagestrategyService.getEntity(WagestrategyEntity.class, wagestrategy.getId());
			req.setAttribute("wagestrategyPage", wagestrategy);
		}
		return new ModelAndView("cn/com/lzt/wagestrategy/wagestrategy-update");
	}
	
	/**
	 * 导入功能跳转
	 * 
	 * @return
	 */
	@RequestMapping(params = "upload")
	public ModelAndView upload(HttpServletRequest req) {
		req.setAttribute("controller_name","wagestrategyController");
		return new ModelAndView("common/upload/pub_excel_upload");
	}
	
	/**
	 * 导出excel
	 * 
	 * @param request
	 * @param response
	 */
	@RequestMapping(params = "exportXls")
	public String exportXls(WagestrategyEntity wagestrategy,HttpServletRequest request,HttpServletResponse response
			, DataGrid dataGrid,ModelMap modelMap) {
		CriteriaQuery cq = new CriteriaQuery(WagestrategyEntity.class, dataGrid);
		org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, wagestrategy, request.getParameterMap());
		List<WagestrategyEntity> wagestrategys = this.wagestrategyService.getListByCriteriaQuery(cq,false);
		modelMap.put(NormalExcelConstants.FILE_NAME,"工资策略");
		modelMap.put(NormalExcelConstants.CLASS,WagestrategyEntity.class);
		modelMap.put(NormalExcelConstants.PARAMS,new ExportParams("工资策略列", "导出人:"+ResourceUtil.getSessionUser().getRealName(),
			"导出信息"));
		modelMap.put(NormalExcelConstants.DATA_LIST,wagestrategys);
		return NormalExcelConstants.JEECG_EXCEL_VIEW;
	}
	/**
	 * 导出excel 使模板
	 * 
	 * @param request
	 * @param response
	 */
	@RequestMapping(params = "exportXlsByT")
	public String exportXlsByT(WagestrategyEntity wagestrategy,HttpServletRequest request,HttpServletResponse response
			, DataGrid dataGrid,ModelMap modelMap) {
    	modelMap.put(NormalExcelConstants.FILE_NAME,"工资策略");
    	modelMap.put(NormalExcelConstants.CLASS,WagestrategyEntity.class);
    	modelMap.put(NormalExcelConstants.PARAMS,new ExportParams("工资策略列表", "导出人:"+ResourceUtil.getSessionUser().getRealName(),
    	"导出信息"));
    	modelMap.put(NormalExcelConstants.DATA_LIST,new ArrayList());
    	return NormalExcelConstants.JEECG_EXCEL_VIEW;
	}
	
	@SuppressWarnings("unchecked")
	@RequestMapping(params = "importExcel", method = RequestMethod.POST)
	@ResponseBody
	public AjaxJson importExcel(HttpServletRequest request, HttpServletResponse response) {
		AjaxJson j = new AjaxJson();
		
		MultipartHttpServletRequest multipartRequest = (MultipartHttpServletRequest) request;
		Map<String, MultipartFile> fileMap = multipartRequest.getFileMap();
		for (Map.Entry<String, MultipartFile> entity : fileMap.entrySet()) {
			MultipartFile file = entity.getValue();// 获取上传文件对象
			ImportParams params = new ImportParams();
			params.setTitleRows(2);
			params.setHeadRows(1);
			params.setNeedSave(true);
			try {
				List<WagestrategyEntity> listWagestrategyEntitys = ExcelImportUtil.importExcel(file.getInputStream(),WagestrategyEntity.class,params);
				for (WagestrategyEntity wagestrategy : listWagestrategyEntitys) {
					wagestrategyService.save(wagestrategy);
				}
				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<WagestrategyEntity> list() {
		List<WagestrategyEntity> listWagestrategys=wagestrategyService.getList(WagestrategyEntity.class);
		return listWagestrategys;
	}
	
	@RequestMapping(value = "/{id}", method = RequestMethod.GET)
	@ResponseBody
	public ResponseEntity<?> get(@PathVariable("id") String id) {
		WagestrategyEntity task = wagestrategyService.get(WagestrategyEntity.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 WagestrategyEntity wagestrategy, UriComponentsBuilder uriBuilder) {
		//调用JSR303 Bean Validator进行校验，如果出错返回含400错误码及json格式的错误信息.
		Set<ConstraintViolation<WagestrategyEntity>> failures = validator.validate(wagestrategy);
		if (!failures.isEmpty()) {
			return new ResponseEntity(BeanValidators.extractPropertyAndMessage(failures), HttpStatus.BAD_REQUEST);
		}

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

		//保存
		try{
			wagestrategyService.saveOrUpdate(wagestrategy);
		} 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) {
		wagestrategyService.deleteEntityById(WagestrategyEntity.class, id);
	}
	
	/**
     * 用户选择职务tree跳转页面
     *
     * @return
     */
    @RequestMapping(params = "departSelect")
    public String departSelect(HttpServletRequest req) {
    	
    	req.setAttribute("orgIds", req.getParameter("orgIds"));
    	
        return "cn/com/lzt/wagestrategy/dutiesZTree";
    }
	
    /**
     * 获取tree数据
     * @author zbw
     * 2017-10-12
     * @param request
     * @param response
     * @return
     */
	//update--start--by:jg_renjie--at:20160318 for:#942 【组件封装】组织机构弹出模式，目前是列表，得改造成树方式
	//update-start--Author: os_renjie  Date:20160529 for：TASK #1056 【bug】用户编辑，弹出组织机构，默认没选中
	@RequestMapping(params = "getDepartInfo")
	@ResponseBody
	public AjaxJson getDepartInfo(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<ZTreeDutiesEntity> listDuties = new ArrayList<ZTreeDutiesEntity>();
		
		StringBuffer hql = new StringBuffer(" from ZTreeDutiesEntity t where t.status = 0 and t.deleteFlag = 0 ");
		if(StringUtils.isNotBlank(parentid)){
			ZTreeDutiesEntity dutiesEntity = dutiesService.get(ZTreeDutiesEntity.class, parentid);
			hql.append(" and parentDuties = ?");
			listDuties = this.dutiesService.findHql(hql.toString(), dutiesEntity);
		} else {
			hql.append(" and t.parentDutiesid IS NULL");
			listDuties = this.dutiesService.findHql(hql.toString());
		}
		List<Map<String,Object>> dateList = new ArrayList<Map<String,Object>>();
		if(listDuties.size()>0){
			Map<String,Object> map = null;
			String sql = null;
			 Object[] params = null;
			for(ZTreeDutiesEntity dutiesEntity:listDuties){
				map = new HashMap<String,Object>();
				map.put("id", dutiesEntity.getId());
				map.put("name", dutiesEntity.getDutiesName());
				
				if(ids.length>0){
					for(String id:ids){
						if(id.equals(dutiesEntity.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_bus_duties t where t.status='0' and t.delete_flag='0' and  t.parent_dutiesid = ?";
				params = new Object[]{dutiesEntity.getId()};
				long count = this.dutiesService.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;
	}
	
	/**
	 * 异步获取职务名称
	 * @author zbw
	 * 2017-10-13
	 * @param request
	 * @param response
	 * @return
	 */
	@RequestMapping(params = "getDName")
	@ResponseBody
	public AjaxJson getDName(HttpServletRequest request, HttpServletResponse response) {
		AjaxJson j = new AjaxJson();
		String id = request.getParameter("id");
		String message = null;
		ZTreeDutiesEntity dutiesEntity = systemService.getEntity(ZTreeDutiesEntity.class, id);
		try {
			j.setMsg(dutiesEntity.getDutiesName());
			//systemService.addLog(message, Globals.Log_Type_DEL, Globals.Log_Leavel_INFO);
		} catch (Exception e) {
			e.printStackTrace();
			throw new BusinessException(e.getMessage());
		}
		return j;
	}
	
	/**
	 * 异步获取项目名称
	 * @author zbw
	 * 2017-10-13
	 * @param request
	 * @param response
	 * @return
	 */
	@RequestMapping(params = "getPName")
	@ResponseBody
	public AjaxJson getPName(HttpServletRequest request, HttpServletResponse response) {
		AjaxJson j = new AjaxJson();
		String id = request.getParameter("id");
		String message = null;
		TSDepart projectentity = systemService.getEntity(TSDepart.class, id);
		try {
			j.setMsg(projectentity.getDepartname());
			//systemService.addLog(message, Globals.Log_Type_DEL, Globals.Log_Leavel_INFO);
		} catch (Exception e) {
			e.printStackTrace();
			throw new BusinessException(e.getMessage());
		}
		return j;
	}
	
	/**
	 * 保存新增/更新的行数据
	 * @author zbw
	 * 2017-10-13
	 * @param wagestrategy
	 * @param request
	 * @return
	 */
	@RequestMapping(params = "saveRows")
	@ResponseBody
	public AjaxJson saveRows(WagestrategyEntity wagestrategy, HttpServletRequest request){
		if(wagestrategy.getSubsidy()==null){
			wagestrategy.setSubsidy(BigDecimal.ZERO);
		}
		String myDutiesId=wagestrategy.getDutiesId();
		String[] myDutiesIdList=myDutiesId.split(",");
		wagestrategy.setDutiesId(myDutiesIdList[0]);
		String message = null;
		AjaxJson j = new AjaxJson();
		message = "";
		
		/** 如果该记录被删除，点击修改一条页面上的数据，改后的职务名恰好是该条被删除的名字，会出现想修改的数据的职务名没变，而被删除的这一天数据又出现了的情况。
		//查出员工人事信息表所有数据，获取主键id和员工id
		StringBuffer hql = new StringBuffer(" from WagestrategyEntity w where w.deleteFlag='1' and w.dutiesId=? ");
		List<WagestrategyEntity> wagestrategyEntityList = systemService.findHql(hql.toString(),wagestrategy.getDutiesId());
		if(wagestrategyEntityList.size()!=0){
			wagestrategy.setId(wagestrategyEntityList.get(0).getId());
			wagestrategy.setDeleteFlag(Globals.Delete_Normal.toString());
			wagestrategy.setStatus(Globals.Enabled_Status.toString());
		}
		*/
		if (StringUtil.isNotEmpty(wagestrategy.getId())) {
			WagestrategyEntity t = wagestrategyService.get(WagestrategyEntity.class, wagestrategy.getId());
			try {
				MyBeanUtils.copyBeanNotNull2Bean(wagestrategy, t);
				wagestrategyService.saveOrUpdate(t);
				systemService.addLog(message, Globals.Log_Type_UPDATE, Globals.Log_Leavel_INFO);
				message = "工资策略更新成功";
			} catch (Exception e) {
				e.printStackTrace();
				message = "工资策略更新失败";
				j.setSuccess(false);
			}
		} else {
			try{
				wagestrategy.setDeleteFlag(Globals.Delete_Normal.toString());
				wagestrategy.setStatus(Globals.Enabled_Status.toString());
				wagestrategyService.save(wagestrategy);
				systemService.addLog(message, Globals.Log_Type_INSERT, Globals.Log_Leavel_INFO);
				message = "工资策略添加成功";
			}catch(Exception e){
				e.printStackTrace();
				message = "工资策略添加失败";
				j.setSuccess(false);
			}
		}
		j.setMsg(message);
		return j;
	}
	
	/**
	 * 异步验证职务名是否已存在
	 * @author zbw
	 * 2017-11-12
	 * @param wagestrategy
	 * @param request
	 * @return
	 */
	@RequestMapping(params = "ajaxCheckName")
	@ResponseBody
	public AjaxJson ajaxCheckName(WagestrategyEntity wagestrategy, HttpServletRequest request){
		String message = null;
		AjaxJson j = new AjaxJson();
		message = "";
		StringBuffer hql = new StringBuffer(
				" from WagestrategyEntity t where delete_flag = '0'  and t.dutiesId=? and t.id not in ('"+wagestrategy.getId()+"')");
		List<WagestrategyEntity> arrangeDutyEntityList = wagestrategyService.findHql(hql.toString(), wagestrategy.getDutiesId().split(",")[0]);
		if(arrangeDutyEntityList.size()!=0){
			j.setSuccess(false);
		}
		message="职务名称已存在";
		j.setMsg(message);
		return j;
	}
	
	/**
	 * 异步验证职务名和区域是否已存在
	 * @author zbw
	 * 2017-11-12
	 * @param wagestrategy
	 * @param request
	 * @return
	 */
	@RequestMapping(params = "ajaxCheckName_zone")
	@ResponseBody
	public AjaxJson ajaxCheckName_zone(WagestrategyEntity wagestrategy, HttpServletRequest request){
		String message = null;
		AjaxJson j = new AjaxJson();
		message = "";
		StringBuffer hql = new StringBuffer(" from WagestrategyEntity t where delete_flag = '0'  and t.dutiesId=? and t.zone=? and t.id not in ('"+wagestrategy.getId()+"')");
		List<WagestrategyEntity> arrangeDutyEntityList = wagestrategyService.findHql(hql.toString(), wagestrategy.getDutiesId().split(",")[0], wagestrategy.getZone());
		if(arrangeDutyEntityList.size()!=0){
			j.setSuccess(false);
		}
		message="区域职务名称已存在，请点击修改";
		j.setMsg(message);
		return j;
	}
	
	/**
	 * 异步验证职务名和项目是否已存在
	 * @author zbw
	 * 2017-11-12
	 * @param wagestrategy
	 * @param request
	 * @return
	 */
	@RequestMapping(params = "ajaxCheckName_project")
	@ResponseBody
	public AjaxJson ajaxCheckName_project(WagestrategyEntity wagestrategy, HttpServletRequest request){
		String message = null;
		AjaxJson j = new AjaxJson();
		message = "";
		StringBuffer hql = new StringBuffer(
				" from WagestrategyEntity t where delete_flag = '0'  and t.dutiesId=? and t.project=? and t.id not in ('"+wagestrategy.getId()+"')");
		List<WagestrategyEntity> arrangeDutyEntityList = wagestrategyService.findHql(hql.toString(), wagestrategy.getDutiesId().split(",")[0], wagestrategy.getProject());
		if(arrangeDutyEntityList.size()!=0){
			j.setSuccess(false);
		}
		message="项目职务名称已存在，请点击修改";
		j.setMsg(message);
		return j;
	}
	
	
	/**
	 * 驼峰转下划线
	 * 
	 * @param str需要转换的字符串
	 * @return
	 */
	private String humpToLine(String str) {
		Pattern humpPattern = Pattern.compile("[A-Z]");
		Matcher matcher = humpPattern.matcher(str);
		StringBuffer sb = new StringBuffer();
		while (matcher.find()) {
			matcher.appendReplacement(sb, "_" + matcher.group(0).toLowerCase());
		}
		matcher.appendTail(sb);
		return sb.toString();
	}
}