| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851 |
- package cn.com.lzt.leave.controller;
- import java.io.IOException;
- import java.net.URI;
- import java.text.ParseException;
- import java.text.ParsePosition;
- import java.text.SimpleDateFormat;
- import java.util.ArrayList;
- import java.util.Date;
- import java.util.HashMap;
- import java.util.List;
- import java.util.Map;
- import java.util.Set;
- import javax.servlet.http.HttpServletRequest;
- import javax.servlet.http.HttpServletResponse;
- import javax.servlet.http.HttpSession;
- import javax.validation.ConstraintViolation;
- import javax.validation.Validator;
- 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.ContextHolderUtils;
- import org.jeecgframework.core.util.ExceptionUtil;
- import org.jeecgframework.core.util.JeecgDataAutorUtils;
- import org.jeecgframework.core.util.MyBeanUtils;
- import org.jeecgframework.core.util.ResourceUtil;
- import org.jeecgframework.core.util.StringUtil;
- import org.jeecgframework.core.util.oConvertUtils;
- 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.cgform.entity.upload.CgUploadEntity;
- import org.jeecgframework.web.cgform.service.config.CgFormFieldServiceI;
- import org.jeecgframework.web.system.pojo.base.TSDepart;
- import org.jeecgframework.web.system.pojo.base.TSRole;
- import org.jeecgframework.web.system.pojo.base.TSRoleUser;
- import org.jeecgframework.web.system.pojo.base.TSUser;
- import org.jeecgframework.web.system.pojo.base.TSUserOrg;
- import org.jeecgframework.web.system.pojo.base.TaskDto;
- import org.jeecgframework.web.system.service.SystemService;
- import org.jeecgframework.web.system.service.UserService;
- 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.util.CollectionUtils;
- import org.springframework.web.bind.annotation.PathVariable;
- import org.springframework.web.bind.annotation.RequestBody;
- import org.springframework.web.bind.annotation.RequestMapping;
- import org.springframework.web.bind.annotation.RequestMethod;
- import org.springframework.web.bind.annotation.ResponseBody;
- import org.springframework.web.bind.annotation.ResponseStatus;
- import org.springframework.web.multipart.MultipartFile;
- import org.springframework.web.multipart.MultipartHttpServletRequest;
- import org.springframework.web.servlet.ModelAndView;
- import org.springframework.web.util.UriComponentsBuilder;
- import cn.com.lzt.common.service.TSysFileServiceI;
- import cn.com.lzt.dialogDeal.service.UserDepartOrgDealServiceI;
- import cn.com.lzt.leave.dto.LeaveDto;
- import cn.com.lzt.leave.entity.LeaveEntity;
- import cn.com.lzt.leave.service.LeaveServiceI;
- import cn.com.lzt.leave.service.ModifyServiceI;
- import cn.com.lzt.personnelbasearchivesmanage.entity.PersonnelBaseArchivesManageEntity;
- import com.jeecg.qianbao.util.FormProcUtil;
- /**
- * @Title: Controller
- * @Description: 离职申请表
- * @author onlineGenerator
- * @date 2017-10-12 13:40:50
- * @version V1.0
- *
- */
- @Controller
- @RequestMapping("/leaveController")
- public class LeaveController extends BaseController {
- /**
- * Logger for this class
- */
- private static final Logger logger = Logger.getLogger(LeaveController.class);
- // 下载路径
- private static final String showAndDownUrl = ResourceUtil.getConfigByName("showAndDownUrl");
-
- @Autowired
- private LeaveServiceI leaveService;
- @Autowired
- private SystemService systemService;
- @Autowired
- private Validator validator;
- @Autowired
- private CgFormFieldServiceI cgFormFieldService;
- @Autowired
- private TSysFileServiceI tSysFileService;
- @Autowired
- private ModifyServiceI modifyService;
- @Autowired
- private UserService userService;
-
- @Autowired
- private UserDepartOrgDealServiceI userDepartOrgDealService;
-
- /**
- * 离职申请表列表 页面跳转
- *
- * @return
- */
- @RequestMapping(params = "list")
- public ModelAndView list(HttpServletRequest request) {
- HttpSession session = ContextHolderUtils.getSession();
- TSUser tuser = (TSUser)session.getAttribute("LOCAL_CLINET_USER");
- request.setAttribute("user", tuser);
- request.setAttribute("showAndDownUrl", showAndDownUrl);
- return new ModelAndView("cn/com/lzt/leave/leaveList");
- }
- /**
- * easyui AJAX请求数据
- *
- * @param request
- * @param response
- * @param dataGrid
- * @param user
- * @throws Exception
- */
- @RequestMapping(params = "datagrid")
- public void datagrid(LeaveDto leave,HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) throws Exception {
- /*CriteriaQuery cq = new CriteriaQuery(LeaveEntity.class, dataGrid);
- //查询条件组装器
- org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, leave, request.getParameterMap());
- try{
- //自定义追加查询条件
- String query_applyDate_begin = request.getParameter("applyDate_begin");
- String query_applyDate_end = request.getParameter("applyDate_end");
- if(StringUtil.isNotEmpty(query_applyDate_begin)){
- cq.ge("applyDate", new SimpleDateFormat("yyyy-MM-dd").parse(query_applyDate_begin));
- }
- if(StringUtil.isNotEmpty(query_applyDate_end)){
- cq.le("applyDate", new SimpleDateFormat("yyyy-MM-dd").parse(query_applyDate_end));
- }
- String query_leaveDate_begin = request.getParameter("leaveDate_begin");
- String query_leaveDate_end = request.getParameter("leaveDate_end");
- if(StringUtil.isNotEmpty(query_leaveDate_begin)){
- cq.ge("leaveDate", new SimpleDateFormat("yyyy-MM-dd").parse(query_leaveDate_begin));
- }
- if(StringUtil.isNotEmpty(query_leaveDate_end)){
- cq.le("leaveDate", new SimpleDateFormat("yyyy-MM-dd").parse(query_leaveDate_end));
- }
-
- String orgIds = request.getParameter("orgIds");
- List<String> orgIdList = extractIdListByComma(orgIds);
- // 获取 当前组织机构的用户信息
- if (!CollectionUtils.isEmpty(orgIdList)) {
- cq.in("belongUnitid", orgIdList.toArray());
- }
- }catch (Exception e) {
- throw new BusinessException(e.getMessage());
- }
-
- //显示没有被逻辑删除的数据
- cq.eq("deleteFlag", Globals.Delete_Normal.toString());
-
- //排序
- Map map = new HashMap();
- map.put("createDate", "desc");
- cq.setOrder(map);
-
- cq.add();
- this.leaveService.getDataGridReturn(cq, true);
-
- List<LeaveEntity> entity = dataGrid.getResults();
- if(!entity.isEmpty()){
- for (LeaveEntity leaveEntity : entity) {
- List<TSysFileEntity> tSysFileEntity = tSysFileService.getSysFileEntitiesByBusiId(leaveEntity.getId(), "departurefile");
- if(!tSysFileEntity.isEmpty()){
- leaveEntity.setFileUrl(tSysFileEntity.get(0).getFileUrl());
- }
- }
- }
- TagUtil.datagrid(response, dataGrid);*/
-
- String orgIds = request.getParameter("orgIds");
- List<String> orgIdList = extractIdListByComma(orgIds);
- // 获取 当前组织机构的用户信息
- if (!CollectionUtils.isEmpty(orgIdList)) {
- String or = orgIdList.get(0);
- List<String> ChildIdList = userDepartOrgDealService.getChildIdByProjectDepartId(or);
- leave.setOrgIdList(ChildIdList);
- //leave.setOrgIdList(orgIdList);
- }
-
- HttpSession session = ContextHolderUtils.getSession();
- TSUser user = (TSUser)session.getAttribute("LOCAL_CLINET_USER");
- List<String> useridList = new ArrayList<String>();
- List<String> useridList1 = new ArrayList<String>();
- List<String> orgidList = new ArrayList<String>();
- //查询该用户的所有角色
- StringBuffer hql1 = new StringBuffer("from TSRoleUser where TSUser.id = :userid");
- List<TSRoleUser> listru = systemService.getSession().createQuery(hql1.toString()).setParameter("userid", user.getId()).list();
- /*boolean temp = false;
- for (TSRoleUser tsRoleUser : listru) {
- TSRole tsRole = tsRoleUser.getTSRole();
- if("M_ZJL".equals(tsRole.getRoleCode())){
- temp = true;
- break;
- }
- }*/
- /*if(){
- temp = true;
- }*/
- useridList1.add(user.getId());
- if("admin".equals(user.getUserName())){
- useridList = null;
- }/*else if(temp){
- }*/else{
- //useridList = userService.getUserList("leave", user);
- StringBuffer hql = new StringBuffer("from TSUserOrg where tsUser.id = :userid and status=0");
- List<TSUserOrg> tsList = systemService.getSession().createQuery(hql.toString()).setParameter("userid", user.getId()).list();
- for (TSUserOrg tsUserOrg : tsList) {
- TSDepart tsDepart = tsUserOrg.getTsDepart();
- if(Globals.org_type_3.equals(tsDepart.getOrgType()) || Globals.org_type_5.equals(tsDepart.getOrgType())){
- /*List<TSDepart> tsDList = systemService.findListbySql("select id from t_s_depart where parentdepartid = '"+tsDepart.getId()+"'");
-
- StringBuffer sql = new StringBuffer();
- sql.append("select uo.user_id as id FROM t_s_user_org uo " +
- "LEFT JOIN t_bus_user_personnel up on uo.user_id = up.userid " +
- "where up.manager_type = 2 and uo.org_id in(");
- for (int i = 0; i < tsDList.size(); i++) {
- if(i==0){
- sql.append("'"+tsDList.get(i)+"'");
- }else{
- sql.append(",'"+tsDList.get(i)+"'");
- }
- }
- sql.append(")");
-
- List<Map<String, Object>> tsDLists = systemService.findForJdbc(sql.toString(),null);
-
- if(!tsDLists.isEmpty()){
- for (Map t2 : tsDLists) {
- useridList.add(t2.get("id").toString());
- }
- }*/
-
- StringBuffer sql = new StringBuffer();
- sql.append("select uo.user_id as id FROM t_s_user_org uo " +
- "LEFT JOIN t_bus_user_personnel up on uo.user_id = up.userid " +
- "where uo.org_id = '"+tsDepart.getId()+"' and status=0");
-
- List<Map<String, Object>> tsDLists = systemService.findForJdbc(sql.toString(),null);
-
- if(!tsDLists.isEmpty()){
- for (Map t2 : tsDLists) {
- useridList.add(t2.get("id").toString());
- }
- }
-
- List<String> tsDList = systemService.findListbySql("select id from t_s_depart where parentdepartid = '"+tsDepart.getId()+"'");
- if(!tsDList.isEmpty()){
- for (int i = 0; i < tsDList.size(); i++) {
- orgidList.add(tsDList.get(i).toString());
- }
- }
- }
- }
- useridList.add(user.getId());
- }
-
- String authSql = JeecgDataAutorUtils.loadDataSearchConditonSQLString();
- MiniDaoPage<LeaveDto> list = leaveService.getAllEntities(leave,useridList,useridList1,orgidList,dataGrid.getPage(), dataGrid.getRows(),authSql);
- //update-begin--Author:zhangliang Date:20170706 for:TASK #1945 【demo错误】minidao例子,通过条件查询,后台报错
-
- List<LeaveDto> corrList = list.getResults();
- if(!corrList.isEmpty()){
- for (LeaveDto cor : corrList) {
- if(StringUtils.isNotEmpty(cor.getProcInstId())){
- TaskDto dto = systemService.getTaskDto(cor.getId(), cor.getProcInstId());
- if(dto != null){
- if(dto.isReject()){
- cor.setReject("2");
- }else{
- cor.setReject("1");
- }
- if(dto.isIamApplyUser()){
- cor.setIamApplyUser("2");
- }else{
- cor.setIamApplyUser("1");
- }
- }else{
- cor.setReject("1");
- cor.setIamApplyUser("1");
- }
- }else{
- cor.setReject("1");
- cor.setIamApplyUser("1");
- }
-
- if(StringUtils.isNotEmpty(cor.getBelongUnitid())){
- cor.setBelongUnitid(modifyService.getByorgId(cor.getBelongUnitid()));
- }
- }
- }
-
- dataGrid.setTotal(list.getTotal());
- dataGrid.setResults(list.getResults());
-
- TagUtil.datagrid(response, dataGrid);
- }
- /**
- * 删除离职申请表
- *
- * @return
- */
- @RequestMapping(params = "doDel")
- @ResponseBody
- public AjaxJson doDel(LeaveEntity leave, HttpServletRequest request) {
- String message = null;
- AjaxJson j = new AjaxJson();
- leave = systemService.getEntity(LeaveEntity.class, leave.getId());
- message = "离职申请表删除成功";
- try{
- leaveService.delete(leave);
- 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
- * @throws ParseException
- */
- /*@RequestMapping(params = "modify")
- @ResponseBody
- public AjaxJson modify(HttpServletRequest request) throws ParseException {
- String message = null;
- AjaxJson j = new AjaxJson();
- message = "定时操作成功";
- modifyService.modifyUpdate();
- 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(",")){
- LeaveEntity leave = systemService.getEntity(LeaveEntity.class, id);
- leaveService.delete(leave);
- 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
- */
- @SuppressWarnings("unchecked")
- @RequestMapping(params = "doAdd")
- @ResponseBody
- public AjaxJson doAdd(LeaveEntity leave, HttpServletRequest request) {
- String message = null;
- AjaxJson j = new AjaxJson();
- message = "离职申请表添加成功";
- try{
-
- HttpSession session = ContextHolderUtils.getSession();
- TSUser tuser = (TSUser)session.getAttribute("LOCAL_CLINET_USER");
- if(tuser != null){
- leave.setApplicantId(tuser.getId());
- }
-
- SimpleDateFormat sim = new SimpleDateFormat("yyyy-MM-dd");
- ParsePosition pos = new ParsePosition(0);
- leave.setApplyDate(sim.parse(sim.format(new Date()), pos));
-
- leave.setDeleteFlag(Globals.Delete_Normal.toString());
-
- String userids = request.getParameter("userid");
- List<TSUserOrg> roleUser = systemService.getSession().createSQLQuery("select * from t_s_user_org where user_id = '"+userids+"' and ifpluralism = 0 and status = 0 ").addEntity(TSUserOrg.class).list();
- leave.setBelongUnitid(roleUser.get(0).getTsDepart().getId());
-
- leaveService.save(leave);
-
- tSysFileService.updateBusiId(leave.getDeparturefile(), leave.getId());
-
- 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);
- j.setObj(leave);
- return j;
- }
-
- /**
- * 更新离职申请表
- *
- * @param ids
- * @return
- */
- @RequestMapping(params = "doUpdate")
- @ResponseBody
- public AjaxJson doUpdate(LeaveEntity leave, HttpServletRequest request) {
- String message = null;
- AjaxJson j = new AjaxJson();
- message = "离职申请表更新成功";
- LeaveEntity t = leaveService.get(LeaveEntity.class, leave.getId());
- try {
- MyBeanUtils.copyBeanNotNull2Bean(leave, t);
-
- String userids = request.getParameter("userid");
- List<TSUserOrg> roleUser = systemService.getSession().createSQLQuery("select * from t_s_user_org where user_id = '"+userids+"' and ifpluralism = 0 and status = 0 ").addEntity(TSUserOrg.class).list();
- t.setBelongUnitid(roleUser.get(0).getTsDepart().getId());
-
- leaveService.saveOrUpdate(t);
- tSysFileService.updateBusiId(t.getDeparturefile(), t.getId());
- 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(LeaveEntity leave, HttpServletRequest req) {
- if (StringUtil.isNotEmpty(leave.getId())) {
- leave = leaveService.getEntity(LeaveEntity.class, leave.getId());
- req.setAttribute("leavePage", leave);
- }
- return new ModelAndView("cn/com/lzt/leave/leave-add");
- }
- /**
- * 离职申请表编辑页面跳转
- *
- * @return
- */
- @RequestMapping(params = "goUpdate")
- public ModelAndView goUpdate(LeaveEntity leave, HttpServletRequest request) {
- if (StringUtil.isNotEmpty(leave.getId())) {
- leave = leaveService.getEntity(LeaveEntity.class, leave.getId());
- request.setAttribute("leavePage", leave);
-
- TSUser user = systemService.getEntity(TSUser.class, leave.getUserid());
- request.setAttribute("user",user);
- }
- return new ModelAndView("cn/com/lzt/leave/leave-update");
- }
-
- /**
- * 离职申请表编辑页面跳转
- *
- * @return
- */
- @RequestMapping(params = "goView")
- public ModelAndView goView(LeaveEntity leave, HttpServletRequest request) {
- if (StringUtil.isNotEmpty(leave.getId())) {
- leave = leaveService.getEntity(LeaveEntity.class, leave.getId());
- request.setAttribute("leavePage", leave);
-
- TSUser user = systemService.getEntity(TSUser.class, leave.getUserid());
- request.setAttribute("user",user);
- }
-
- String flage = oConvertUtils.getString(request.getParameter("flage"));
- if(oConvertUtils.isNotEmpty(flage)){
- request.setAttribute("flage",flage);
- }
-
- String taskId = oConvertUtils.getString(request.getParameter("taskId"));
- if(oConvertUtils.isNotEmpty(taskId)){
- FormProcUtil.initWorkflowParam(request);
- request.setAttribute("taskId",taskId);
- }
- return new ModelAndView("cn/com/lzt/leave/leave-view");
- }
-
- /**
- * 离职申请表编辑页面跳转
- *
- * @return
- */
- @RequestMapping(params = "goview")
- public ModelAndView goview(LeaveEntity leave, HttpServletRequest request) {
- if (StringUtil.isNotEmpty(leave.getId())) {
- leave = leaveService.getEntity(LeaveEntity.class, leave.getId());
- request.setAttribute("leavePage", leave);
-
- TSUser user = systemService.getEntity(TSUser.class, leave.getUserid());
- request.setAttribute("user",user);
- }
- return new ModelAndView("cn/com/lzt/leave/leaveView");
- }
-
- /**
- * 导入功能跳转
- *
- * @return
- */
- @RequestMapping(params = "upload")
- public ModelAndView upload(HttpServletRequest req) {
- req.setAttribute("controller_name","leaveController");
- return new ModelAndView("common/upload/pub_excel_upload");
- }
-
- /**
- * 导出excel
- *
- * @param request
- * @param response
- */
- @RequestMapping(params = "exportXls")
- public String exportXls(LeaveEntity leave,HttpServletRequest request,HttpServletResponse response
- , DataGrid dataGrid,ModelMap modelMap) {
- CriteriaQuery cq = new CriteriaQuery(LeaveEntity.class, dataGrid);
- org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, leave, request.getParameterMap());
- List<LeaveEntity> leaves = this.leaveService.getListByCriteriaQuery(cq,false);
- modelMap.put(NormalExcelConstants.FILE_NAME,"离职申请表");
- modelMap.put(NormalExcelConstants.CLASS,LeaveEntity.class);
- modelMap.put(NormalExcelConstants.PARAMS,new ExportParams("离职申请表列表", "导出人:"+ResourceUtil.getSessionUser().getRealName(),
- "导出信息"));
- modelMap.put(NormalExcelConstants.DATA_LIST,leaves);
- return NormalExcelConstants.JEECG_EXCEL_VIEW;
- }
- /**
- * 导出excel 使模板
- *
- * @param request
- * @param response
- */
- @RequestMapping(params = "exportXlsByT")
- public String exportXlsByT(LeaveEntity leave,HttpServletRequest request,HttpServletResponse response
- , DataGrid dataGrid,ModelMap modelMap) {
- modelMap.put(NormalExcelConstants.FILE_NAME,"离职申请表");
- modelMap.put(NormalExcelConstants.CLASS,LeaveEntity.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<LeaveEntity> listLeaveEntitys = ExcelImportUtil.importExcel(file.getInputStream(),LeaveEntity.class,params);
- for (LeaveEntity leave : listLeaveEntitys) {
- leaveService.save(leave);
- }
- j.setMsg("文件导入成功!");
- } catch (Exception e) {
- j.setMsg("文件导入失败!");
- logger.error(ExceptionUtil.getExceptionMessage(e));
- }finally{
- try {
- file.getInputStream().close();
- } catch (IOException e) {
- e.printStackTrace();
- }
- }
- }
- return j;
- }
-
- /**
- * 获取文件附件信息
- *
- * @param id leave主键id
- */
- @RequestMapping(params = "getFiles")
- @ResponseBody
- public AjaxJson getFiles(String id){
- List<CgUploadEntity> uploadBeans = cgFormFieldService.findByProperty(CgUploadEntity.class, "cgformId", id);
- List<Map<String,Object>> files = new ArrayList<Map<String,Object>>(0);
- for(CgUploadEntity b:uploadBeans){
- String title = b.getAttachmenttitle();//附件名
- String fileKey = b.getId();//附件主键
- String path = b.getRealpath();//附件路径
- String field = b.getCgformField();//表单中作为附件控件的字段
- Map<String, Object> file = new HashMap<String, Object>();
- file.put("title", title);
- file.put("fileKey", fileKey);
- file.put("path", path);
- file.put("field", field==null?"":field);
- files.add(file);
- }
- AjaxJson j = new AjaxJson();
- j.setObj(files);
- return j;
- }
- @RequestMapping(method = RequestMethod.GET)
- @ResponseBody
- public List<LeaveEntity> list() {
- List<LeaveEntity> listLeaves=leaveService.getList(LeaveEntity.class);
- return listLeaves;
- }
-
- @RequestMapping(value = "/{id}", method = RequestMethod.GET)
- @ResponseBody
- public ResponseEntity<?> get(@PathVariable("id") String id) {
- LeaveEntity task = leaveService.get(LeaveEntity.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 LeaveEntity leave, UriComponentsBuilder uriBuilder) {
- //调用JSR303 Bean Validator进行校验,如果出错返回含400错误码及json格式的错误信息.
- Set<ConstraintViolation<LeaveEntity>> failures = validator.validate(leave);
- if (!failures.isEmpty()) {
- return new ResponseEntity(BeanValidators.extractPropertyAndMessage(failures), HttpStatus.BAD_REQUEST);
- }
- //保存
- try{
- leaveService.save(leave);
- } catch (Exception e) {
- e.printStackTrace();
- return new ResponseEntity(HttpStatus.NO_CONTENT);
- }
- //按照Restful风格约定,创建指向新任务的url, 也可以直接返回id或对象.
- String id = leave.getId();
- URI uri = uriBuilder.path("/rest/leaveController/" + 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 LeaveEntity leave) {
- //调用JSR303 Bean Validator进行校验,如果出错返回含400错误码及json格式的错误信息.
- Set<ConstraintViolation<LeaveEntity>> failures = validator.validate(leave);
- if (!failures.isEmpty()) {
- return new ResponseEntity(BeanValidators.extractPropertyAndMessage(failures), HttpStatus.BAD_REQUEST);
- }
- //保存
- try{
- leaveService.saveOrUpdate(leave);
- } 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) {
- leaveService.deleteEntityById(LeaveEntity.class, id);
- }
-
- /**
- * 启用
- *
- * @author liujie
- */
- @RequestMapping(params = "enable")
- @ResponseBody
- public AjaxJson enable(String id, HttpServletRequest req) {
- AjaxJson j = new AjaxJson();
- String message = null;
- LeaveEntity entity = leaveService.getEntity(LeaveEntity.class, id);
- try{
- entity.setBpmStatus(Globals.BPM_STATUS_PROCESSING.toString());
- leaveService.updateEntitie(entity);
- message = "离职申请:" + "" + "启用成功!";
- systemService.addLog(message, Globals.Log_Type_UPDATE, Globals.Log_Leavel_INFO);
- }catch(Exception e){
- message = "操作失败!";
- }
- j.setMsg(message);
- return j;
- }
-
- /**
- * 撤销
- *
- * @author liujie
- */
- @RequestMapping(params = "disable")
- @ResponseBody
- public AjaxJson disable(String id, HttpServletRequest req) {
- AjaxJson j = new AjaxJson();
- String message = null;
- LeaveEntity entity = leaveService.getEntity(LeaveEntity.class, id);
- try{
- entity.setBpmStatus(Globals.BPM_STATUS_Normal.toString());
- leaveService.updateEntitie(entity);
- message = "离职申请:" + "" + "撤销成功!";
- systemService.addLog(message, Globals.Log_Type_UPDATE, Globals.Log_Leavel_INFO);
- }catch(Exception e){
- message = "操作失败!";
- }
- j.setMsg(message);
- return j;
- }
-
- /**
- * 逻辑删除转正申请
- *
- * @return
- */
- @RequestMapping(params = "logicDel")
- @ResponseBody
- public AjaxJson logicDel(LeaveEntity leaveEntity, HttpServletRequest request) {
- String message = null;
- AjaxJson j = new AjaxJson();
- leaveEntity = systemService.getEntity(LeaveEntity.class, leaveEntity.getId());
- message = "离职申请 删除成功";
- try{
- leaveEntity.setDeleteFlag(Globals.Delete_Forbidden.toString());
- leaveService.logicDel(leaveEntity);
- 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
- * @throws ParseException
- */
- @SuppressWarnings("unchecked")
- @RequestMapping(params = "isLeave")
- @ResponseBody
- public AjaxJson isLeave(HttpServletRequest request) throws ParseException {
- AjaxJson j = new AjaxJson();
- String id = request.getParameter("id");
- String userid = request.getParameter("userid");
-
- j.setSuccess(true);
- j.setMsg("所选人员可以离职");
-
- if(StringUtils.isNotEmpty(userid)){
- PersonnelBaseArchivesManageEntity per = leaveService.findUniqueByProperty(PersonnelBaseArchivesManageEntity.class, "userid", userid);
- if(StringUtils.isNotEmpty(per.getPositionStatus())){
- if(Globals.JOBSTATUS_3.equals(per.getPositionStatus()) || Globals.JOBSTATUS_4.equals(per.getPositionStatus())){
- j.setSuccess(false);
- j.setMsg("所选离职人员已经离职,不可申请离职");
- return j;
- }
- }
- }
-
- List<LeaveEntity> holidayList = leaveService.getSession().createQuery(" FROM LeaveEntity where userid = :userid and deleteFlag = 0").
- setParameter("userid",userid).list();
- if(!holidayList.isEmpty()){
- for (LeaveEntity le : holidayList) {
- if("3".equals(le.getBpmStatus())){
- j.setSuccess(false);
- j.setMsg("所选离职人员已经申请过离职,并且已经审批通过,不可再次申请离职");
- return j;
- }
-
- }
- if(StringUtils.isNotEmpty(id)){
- if(holidayList.size() > 1){
- j.setSuccess(false);
- j.setMsg("所选离职人员已经申请过离职,不可再次申请离职");
- return j;
- }
- }else{
- if(holidayList.size() > 0){
- j.setSuccess(false);
- j.setMsg("所选离职人员已经申请过离职,不可再次申请离职");
- return j;
- }
- }
- }
- return j;
- }
-
- }
|