| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540 |
- package cn.com.lzt.othersubsidy.controller;
- import java.io.IOException;
- import java.net.URI;
- import java.util.ArrayList;
- 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.validation.ConstraintViolation;
- import javax.validation.Validator;
- 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.ExceptionUtil;
- import org.jeecgframework.core.util.MyBeanUtils;
- import org.jeecgframework.core.util.ResourceUtil;
- import org.jeecgframework.core.util.StringUtil;
- 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.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.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.megathermalsubsidy.entity.MegathermalSubsidyEntity;
- import cn.com.lzt.othersubsidy.entity.OtherSubsidyEntity;
- import cn.com.lzt.othersubsidy.service.OtherSubsidyServiceI;
- /**
- * @Title: Controller
- * @Description: 其它补贴
- * @author onlineGenerator
- * @date 2017-10-18 18:03:42
- * @version V1.0
- *
- */
- @Controller
- @RequestMapping("/otherSubsidyController")
- public class OtherSubsidyController extends BaseController {
- /**
- * Logger for this class
- */
- private static final Logger logger = Logger.getLogger(OtherSubsidyController.class);
- @Autowired
- private OtherSubsidyServiceI otherSubsidyService;
- @Autowired
- private SystemService systemService;
- @Autowired
- private Validator validator;
-
- /**
- * 其它补贴列表 页面跳转
- *
- * @return
- */
- @RequestMapping(params = "list")
- public ModelAndView list(HttpServletRequest request) {
- return new ModelAndView("cn/com/lzt/othersubsidy/otherSubsidyList");
- }
- /**
- * easyui AJAX请求数据
- *
- * @param request
- * @param response
- * @param dataGrid
- * @param user
- */
- @RequestMapping(params = "datagrid")
- public void datagrid(OtherSubsidyEntity otherSubsidy, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
- CriteriaQuery cq = new CriteriaQuery(OtherSubsidyEntity.class, dataGrid);
- //查询条件组装器
- org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, otherSubsidy, request.getParameterMap());
- try{
- //自定义追加查询条件
- String[] status = new String[]{Globals.Enabled_Status.toString(), Globals.Disabled_Status.toString()};
- cq.in("status", status);
- cq.eq("deleteFlag", Globals.Delete_Normal.toString());
- Map map = new HashMap();
- map.put("createDate", "desc");
- cq.setOrder(map);
- }catch (Exception e) {
- throw new BusinessException(e.getMessage());
- }
- cq.add();
- this.otherSubsidyService.getDataGridReturn(cq, true);
- TagUtil.datagrid(response, dataGrid);
- }
- /**
- * 保存新增/更新的行数据
- * @param page
- * @return
- */
- @RequestMapping(params = "saveRows")
- @ResponseBody
- public AjaxJson saveRows(OtherSubsidyEntity otherSubsidy, HttpServletRequest request){
- String message = null;
- AjaxJson j = new AjaxJson();
- message = "";
- if (StringUtil.isNotEmpty(otherSubsidy.getId())) {
- OtherSubsidyEntity t = otherSubsidyService.get(OtherSubsidyEntity.class, otherSubsidy.getId());
- try {
- MyBeanUtils.copyBeanNotNull2Bean(otherSubsidy, t);
- otherSubsidyService.updateEntitie(t);
- systemService.addLog(message, Globals.Log_Type_UPDATE, Globals.Log_Leavel_INFO);
- message = "其他补贴更新成功";
- } catch (Exception e) {
- e.printStackTrace();
- message = "其他补贴更新失败";
- throw new BusinessException(e.getMessage());
- }
- } else {
- try{
- otherSubsidy.setDeleteFlag(Globals.Delete_Normal.toString());
- otherSubsidy.setStatus(Globals.Enabled_Status.toString());
- otherSubsidyService.save(otherSubsidy);
- systemService.addLog(message, Globals.Log_Type_INSERT, Globals.Log_Leavel_INFO);
- message = "其他补贴添加成功";
- }catch(Exception e){
- e.printStackTrace();
- message = "其他补贴添加失败";
- throw new BusinessException(e.getMessage());
- }
- }
- j.setMsg(message);
- return j;
- }
- /**
- * 删除其它补贴
- *
- * @return
- */
- @RequestMapping(params = "doDel")
- @ResponseBody
- public AjaxJson doDel(OtherSubsidyEntity otherSubsidy, HttpServletRequest request) {
- String message = null;
- AjaxJson j = new AjaxJson();
- otherSubsidy = systemService.getEntity(OtherSubsidyEntity.class, otherSubsidy.getId());
- message = "其它补贴删除成功";
- try{
- otherSubsidyService.delete(otherSubsidy);
- 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(",")){
- OtherSubsidyEntity otherSubsidy = systemService.getEntity(OtherSubsidyEntity.class, id);
- otherSubsidyService.delete(otherSubsidy);
- 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 = "doBatchLogicDel")
- @ResponseBody
- public AjaxJson doBatchLogicDel(String ids,HttpServletRequest request){
- String message = null;
- AjaxJson j = new AjaxJson();
- message = "其他补贴删除成功";
- List<OtherSubsidyEntity> pojoList = new ArrayList<OtherSubsidyEntity>();
- try{
- for(String id:ids.split(",")){
- OtherSubsidyEntity otherSubsidy = systemService.getEntity(OtherSubsidyEntity.class, id);
- otherSubsidy.setDeleteFlag(Globals.Delete_Forbidden.toString());// 设置为1已删除
- pojoList.add(otherSubsidy);
- }
- otherSubsidyService.batchUpdate(pojoList);// 执行批量更新
- 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 = "doEnableObj")
- @ResponseBody
- public AjaxJson doEnableObj(String ids,HttpServletRequest request){
- String message = null;
- AjaxJson j = new AjaxJson();
- message = "其他补贴启用成功";
- List<OtherSubsidyEntity> pojoList = new ArrayList<OtherSubsidyEntity>();
- try{
- for(String id:ids.split(",")){
- OtherSubsidyEntity otherSubsidy = systemService.getEntity(OtherSubsidyEntity.class, id);
- otherSubsidy.setStatus(Globals.Enabled_Status.toString());// 设置为0启用
- pojoList.add(otherSubsidy);
- }
- otherSubsidyService.batchUpdate(pojoList);// 执行批量更新
- 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 = "doDisableObj")
- @ResponseBody
- public AjaxJson doDisableObj(String ids,HttpServletRequest request){
- String message = null;
- AjaxJson j = new AjaxJson();
- message = "其他补贴停用成功";
- List<OtherSubsidyEntity> pojoList = new ArrayList<OtherSubsidyEntity>();
- try{
- for(String id:ids.split(",")){
- OtherSubsidyEntity otherSubsidy = systemService.getEntity(OtherSubsidyEntity.class, id);
- otherSubsidy.setStatus(Globals.Disabled_Status.toString());// 设置为1停用
- pojoList.add(otherSubsidy);
- }
- otherSubsidyService.batchUpdate(pojoList);// 执行批量更新
- 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;
- }
-
- /**
- * 补贴名称重复校验
- *
- * @param ids
- * @return
- */
- @RequestMapping(params = "checkName")
- @ResponseBody
- public Map<String,Object> checkName(OtherSubsidyEntity otherSubsidy, HttpServletRequest request) {
- Boolean flag = otherSubsidyService.findByName(otherSubsidy);
- Map<String,Object> res = new HashMap<String, Object>();
- res.put("flag",flag);
- return res;
- }
- /**
- * 添加其它补贴
- *
- * @param ids
- * @return
- */
- @RequestMapping(params = "doAdd")
- @ResponseBody
- public AjaxJson doAdd(OtherSubsidyEntity otherSubsidy, HttpServletRequest request) {
- String message = null;
- AjaxJson j = new AjaxJson();
- message = "其它补贴添加成功";
- try{
- otherSubsidy.setDeleteFlag(Globals.Delete_Normal.toString());
- otherSubsidy.setStatus(Globals.Enabled_Status.toString());
- otherSubsidyService.save(otherSubsidy);
- 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(OtherSubsidyEntity otherSubsidy, HttpServletRequest request) {
- String message = null;
- AjaxJson j = new AjaxJson();
- message = "其它补贴更新成功";
- OtherSubsidyEntity t = otherSubsidyService.get(OtherSubsidyEntity.class, otherSubsidy.getId());
- try {
- MyBeanUtils.copyBeanNotNull2Bean(otherSubsidy, t);
- otherSubsidyService.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(OtherSubsidyEntity otherSubsidy, HttpServletRequest req) {
- if (StringUtil.isNotEmpty(otherSubsidy.getId())) {
- otherSubsidy = otherSubsidyService.getEntity(OtherSubsidyEntity.class, otherSubsidy.getId());
- req.setAttribute("otherSubsidyPage", otherSubsidy);
- }
- return new ModelAndView("cn/com/lzt/othersubsidy/otherSubsidy-add");
- }
- /**
- * 其它补贴编辑页面跳转
- *
- * @return
- */
- @RequestMapping(params = "goUpdate")
- public ModelAndView goUpdate(OtherSubsidyEntity otherSubsidy, HttpServletRequest req) {
- if (StringUtil.isNotEmpty(otherSubsidy.getId())) {
- otherSubsidy = otherSubsidyService.getEntity(OtherSubsidyEntity.class, otherSubsidy.getId());
- req.setAttribute("otherSubsidyPage", otherSubsidy);
- }
- return new ModelAndView("cn/com/lzt/othersubsidy/otherSubsidy-update");
- }
-
- /**
- * 导入功能跳转
- *
- * @return
- */
- @RequestMapping(params = "upload")
- public ModelAndView upload(HttpServletRequest req) {
- req.setAttribute("controller_name","otherSubsidyController");
- return new ModelAndView("common/upload/pub_excel_upload");
- }
-
- /**
- * 导出excel
- *
- * @param request
- * @param response
- */
- @RequestMapping(params = "exportXls")
- public String exportXls(OtherSubsidyEntity otherSubsidy,HttpServletRequest request,HttpServletResponse response
- , DataGrid dataGrid,ModelMap modelMap) {
- CriteriaQuery cq = new CriteriaQuery(OtherSubsidyEntity.class, dataGrid);
- org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, otherSubsidy, request.getParameterMap());
- List<OtherSubsidyEntity> otherSubsidys = this.otherSubsidyService.getListByCriteriaQuery(cq,false);
- modelMap.put(NormalExcelConstants.FILE_NAME,"其它补贴");
- modelMap.put(NormalExcelConstants.CLASS,OtherSubsidyEntity.class);
- modelMap.put(NormalExcelConstants.PARAMS,new ExportParams("其它补贴列表", "导出人:"+ResourceUtil.getSessionUser().getRealName(),
- "导出信息"));
- modelMap.put(NormalExcelConstants.DATA_LIST,otherSubsidys);
- return NormalExcelConstants.JEECG_EXCEL_VIEW;
- }
- /**
- * 导出excel 使模板
- *
- * @param request
- * @param response
- */
- @RequestMapping(params = "exportXlsByT")
- public String exportXlsByT(OtherSubsidyEntity otherSubsidy,HttpServletRequest request,HttpServletResponse response
- , DataGrid dataGrid,ModelMap modelMap) {
- modelMap.put(NormalExcelConstants.FILE_NAME,"其它补贴");
- modelMap.put(NormalExcelConstants.CLASS,OtherSubsidyEntity.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<OtherSubsidyEntity> listOtherSubsidyEntitys = ExcelImportUtil.importExcel(file.getInputStream(),OtherSubsidyEntity.class,params);
- for (OtherSubsidyEntity otherSubsidy : listOtherSubsidyEntitys) {
- otherSubsidyService.save(otherSubsidy);
- }
- 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<OtherSubsidyEntity> list() {
- List<OtherSubsidyEntity> listOtherSubsidys=otherSubsidyService.getList(OtherSubsidyEntity.class);
- return listOtherSubsidys;
- }
-
- @RequestMapping(value = "/{id}", method = RequestMethod.GET)
- @ResponseBody
- public ResponseEntity<?> get(@PathVariable("id") String id) {
- OtherSubsidyEntity task = otherSubsidyService.get(OtherSubsidyEntity.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 OtherSubsidyEntity otherSubsidy, UriComponentsBuilder uriBuilder) {
- //调用JSR303 Bean Validator进行校验,如果出错返回含400错误码及json格式的错误信息.
- Set<ConstraintViolation<OtherSubsidyEntity>> failures = validator.validate(otherSubsidy);
- if (!failures.isEmpty()) {
- return new ResponseEntity(BeanValidators.extractPropertyAndMessage(failures), HttpStatus.BAD_REQUEST);
- }
- //保存
- try{
- otherSubsidyService.save(otherSubsidy);
- } catch (Exception e) {
- e.printStackTrace();
- return new ResponseEntity(HttpStatus.NO_CONTENT);
- }
- //按照Restful风格约定,创建指向新任务的url, 也可以直接返回id或对象.
- String id = otherSubsidy.getId();
- URI uri = uriBuilder.path("/rest/otherSubsidyController/" + 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 OtherSubsidyEntity otherSubsidy) {
- //调用JSR303 Bean Validator进行校验,如果出错返回含400错误码及json格式的错误信息.
- Set<ConstraintViolation<OtherSubsidyEntity>> failures = validator.validate(otherSubsidy);
- if (!failures.isEmpty()) {
- return new ResponseEntity(BeanValidators.extractPropertyAndMessage(failures), HttpStatus.BAD_REQUEST);
- }
- //保存
- try{
- otherSubsidyService.saveOrUpdate(otherSubsidy);
- } 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) {
- otherSubsidyService.deleteEntityById(OtherSubsidyEntity.class, id);
- }
- }
|