StorageLocationServiceImpl.java 4.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125
  1. package com.tld.service.impl;
  2. import com.github.pagehelper.PageHelper;
  3. import com.github.pagehelper.PageInfo;
  4. import com.tld.excel.ExcelUtils;
  5. import com.tld.mapper.StorageLocationMapper;
  6. import com.tld.model.StorageLocation;
  7. import com.tld.service.StorageLocationService;
  8. import org.springframework.beans.factory.annotation.Autowired;
  9. import org.springframework.stereotype.Service;
  10. import org.springframework.transaction.annotation.Transactional;
  11. import javax.servlet.http.HttpServletResponse;
  12. import java.text.SimpleDateFormat;
  13. import java.util.*;
  14. @Service
  15. public class StorageLocationServiceImpl implements StorageLocationService {
  16. @Autowired
  17. private StorageLocationMapper storageLocationMapper;
  18. @Override
  19. public Map<String, Object> getStorage(StorageLocation storageLocation) {
  20. Map<String, Object> map = new HashMap<>();
  21. try{
  22. PageHelper.startPage(storageLocation.getPage(), storageLocation.getLimit());
  23. PageInfo<StorageLocation> list = new PageInfo<>(storageLocationMapper.getStorage(storageLocation));
  24. map.put("data", list);
  25. map.put("msg", "200");
  26. }catch (Exception e){
  27. e.printStackTrace();
  28. map.put("msg", "500");
  29. map.put("errMsg", "服务器请求异常,请稍后再试");
  30. }
  31. return map;
  32. }
  33. @Override
  34. @Transactional(rollbackFor = Exception.class)
  35. public Map<String, Object> addStorage(StorageLocation storageLocation) {
  36. Map<String, Object> map = new HashMap<>();
  37. try{
  38. storageLocationMapper.addStorage(storageLocation);
  39. map.put("msg", "200");
  40. }catch (Exception e){
  41. e.printStackTrace();
  42. map.put("msg", "500");
  43. map.put("errMsg", "服务器请求异常,请稍后再试");
  44. }
  45. return map;
  46. }
  47. @Override
  48. @Transactional(rollbackFor = Exception.class)
  49. public Map<String, Object> delStorage(String id) {
  50. Map<String, Object> map = new HashMap<>();
  51. try{
  52. storageLocationMapper.delStorage(id);
  53. map.put("msg", "200");
  54. }catch (Exception e){
  55. e.printStackTrace();
  56. map.put("msg", "500");
  57. map.put("errMsg", "服务器请求异常,请稍后再试");
  58. }
  59. return map;
  60. }
  61. @Override
  62. @Transactional(rollbackFor = Exception.class)
  63. public Map<String, Object> updateStorage(StorageLocation storageLocation) {
  64. Map<String, Object> map = new HashMap<>();
  65. try{
  66. storageLocationMapper.updateStorage(storageLocation);
  67. map.put("msg", "200");
  68. }catch (Exception e){
  69. e.printStackTrace();
  70. map.put("msg", "500");
  71. map.put("errMsg", "服务器请求异常,请稍后再试");
  72. }
  73. return map;
  74. }
  75. @Override
  76. public void export(StorageLocation storageLocation, HttpServletResponse response) {
  77. try{
  78. //导出数据汇总
  79. List<List<Object>> sheetDataList = new ArrayList<>();
  80. //表头数据
  81. List<Object> head = Arrays.asList("库位编号", "库位名称", "所在仓库","库位类型","库位容量","是否禁用","创建时间");
  82. //查询数据
  83. PageHelper.startPage(storageLocation.getPage(), storageLocation.getLimit());
  84. PageInfo<Map<String, Object>> list = new PageInfo<>(storageLocationMapper.export(storageLocation));
  85. sheetDataList.add(head);
  86. for(Map<String, Object> userMap : list.getList()){
  87. List<Object> listSheet = new ArrayList<>();
  88. for(String key: userMap.keySet()){
  89. listSheet.add(userMap.get(key));
  90. }
  91. sheetDataList.add(listSheet);
  92. }
  93. //当前时间
  94. Date time = new Date();
  95. SimpleDateFormat sdf = new SimpleDateFormat("yyyyMddHHmmss");
  96. ExcelUtils.export(response, "库位数据导出" + sdf.format(time), sheetDataList);
  97. }catch (Exception e){
  98. e.printStackTrace();
  99. }
  100. }
  101. @Override
  102. public Map<String, Object> getStorageAll(StorageLocation storageLocation) {
  103. Map<String, Object> map = new HashMap<>();
  104. try{
  105. List<StorageLocation> list = storageLocationMapper.getStorage(storageLocation);
  106. map.put("data", list);
  107. map.put("msg", "200");
  108. }catch (Exception e){
  109. e.printStackTrace();
  110. map.put("msg", "500");
  111. map.put("errMsg", "服务器请求异常,请稍后再试");
  112. }
  113. return map;
  114. }
  115. }