OrderImageController.java 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305
  1. package com.izouma.awesomeadmin.web;
  2. import com.izouma.awesomeadmin.constant.AppConstant;
  3. import com.izouma.awesomeadmin.dto.Page;
  4. import com.izouma.awesomeadmin.dto.Result;
  5. import com.izouma.awesomeadmin.model.ImageUploadLog;
  6. import com.izouma.awesomeadmin.model.OrderImage;
  7. import com.izouma.awesomeadmin.service.ImageUploadLogService;
  8. import com.izouma.awesomeadmin.service.OSSFileService;
  9. import com.izouma.awesomeadmin.service.OrderImageService;
  10. import com.izouma.awesomeadmin.util.ExportExcelUtil;
  11. import com.izouma.awesomeadmin.util.PropertiesFileLoader;
  12. import org.apache.commons.lang.StringUtils;
  13. import org.apache.shiro.authz.annotation.RequiresAuthentication;
  14. import org.springframework.beans.factory.annotation.Autowired;
  15. import org.springframework.stereotype.Controller;
  16. import org.springframework.web.bind.annotation.RequestMapping;
  17. import org.springframework.web.bind.annotation.RequestMethod;
  18. import org.springframework.web.bind.annotation.RequestParam;
  19. import org.springframework.web.bind.annotation.ResponseBody;
  20. import org.springframework.web.multipart.MultipartFile;
  21. import org.springframework.web.multipart.MultipartHttpServletRequest;
  22. import org.springframework.web.multipart.commons.CommonsMultipartResolver;
  23. import javax.servlet.http.HttpServletRequest;
  24. import javax.servlet.http.HttpServletResponse;
  25. import java.io.IOException;
  26. import java.math.BigDecimal;
  27. import java.util.*;
  28. /**
  29. * controller类
  30. */
  31. @Controller
  32. @RequestMapping("/orderImage")
  33. public class OrderImageController {
  34. @Autowired
  35. private OrderImageService orderImageService;
  36. @Autowired
  37. private OSSFileService OSSFileService;
  38. @Autowired
  39. private ImageUploadLogService imageUploadLogService;
  40. /**
  41. * <p>获取全部记录。</p>
  42. */
  43. @RequiresAuthentication
  44. @RequestMapping(value = "/all", method = RequestMethod.GET)
  45. @ResponseBody
  46. public Result all(OrderImage record) {
  47. List<OrderImage> pp = orderImageService.getOrderImageList(record);
  48. return new Result(true, pp);
  49. }
  50. /**
  51. * <p>根据Id。</p>
  52. */
  53. @RequestMapping(value = "/getOrderImage", method = RequestMethod.GET)
  54. @ResponseBody
  55. public Result getOrderImage(@RequestParam(required = false, value = "id") String id) {
  56. OrderImage data = orderImageService.getOrderImageById(id);
  57. return new Result(true, data);
  58. }
  59. /**
  60. * <p>根据条件获取。</p>
  61. */
  62. @RequestMapping(value = "/getOne", method = RequestMethod.GET)
  63. @ResponseBody
  64. public Result getOne(OrderImage record) {
  65. OrderImage data = orderImageService.getOrderImage(record);
  66. return new Result(true, data);
  67. }
  68. /**
  69. * <p>分页查询。</p>
  70. */
  71. @RequestMapping(value = "/page", method = RequestMethod.GET)
  72. @ResponseBody
  73. public Result page(Page page, OrderImage record) {
  74. Map<String, Object> result = new HashMap<>();
  75. List<OrderImage> pp = orderImageService.getOrderImageByPage(page, record);
  76. result.put(AppConstant.PAGE, page);
  77. result.put("pp", pp);
  78. return new Result(true, result);
  79. }
  80. /**
  81. * <p>保存。</p>
  82. */
  83. @RequestMapping(value = "/save", method = RequestMethod.POST)
  84. @ResponseBody
  85. public Result save(OrderImage record) {
  86. boolean num = orderImageService.createOrderImage(record);
  87. if (num) {
  88. return new Result(true, record.getId());
  89. }
  90. return new Result(false, "保存异常");
  91. }
  92. /**
  93. * <p>更新信息。</p>
  94. */
  95. @RequestMapping(value = "/update", method = RequestMethod.POST)
  96. @ResponseBody
  97. public Result updateOrderImage(OrderImage record) {
  98. boolean num = orderImageService.updateOrderImage(record);
  99. if (num) {
  100. return new Result(true, "保存成功");
  101. }
  102. return new Result(false, "保存异常");
  103. }
  104. /**
  105. * <p>删除。</p>
  106. */
  107. @RequestMapping(value = "/del", method = RequestMethod.POST)
  108. @ResponseBody
  109. public Result deleteOrderImage(@RequestParam(required = true, value = "id") String id) {
  110. boolean num = orderImageService.deleteOrderImage(id);
  111. if (num) {
  112. return new Result(true, "删除成功");
  113. }
  114. return new Result(false, "删除异常");
  115. }
  116. /**
  117. * 导出Excel
  118. *
  119. * @param request
  120. * @param response
  121. * @param record
  122. * @throws Exception
  123. */
  124. @RequestMapping(value = "/exportExcel", method = RequestMethod.GET)
  125. @ResponseBody
  126. public void exportExcel(HttpServletRequest request, HttpServletResponse response, OrderImage record) throws Exception {
  127. List<OrderImage> orderImages = orderImageService.getOrderImageList(record);
  128. String sheetName = "order_image";
  129. String titleName = "订单图片数据表";
  130. String fileName = "订单图片表";
  131. int columnNumber = 16;
  132. int[] columnWidth = {20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20};
  133. String[] columnName = {"", "删除标识", "更新时间", "更新人", "创建时间", "创建人", "订单", "用户", "店铺", "原片地址", "原片大小", "成片地址", "成片大小", "修图人", "状态", "备注"};
  134. String[][] dataList = new String[orderImages.size()][16];
  135. for (int i = 0; i < orderImages.size(); i++) {
  136. dataList[i][0] = String.valueOf(orderImages.get(i).getId());
  137. dataList[i][1] = String.valueOf(orderImages.get(i).getDelFlag());
  138. dataList[i][2] = String.valueOf(orderImages.get(i).getUpdateTime());
  139. dataList[i][3] = String.valueOf(orderImages.get(i).getUpdateUser());
  140. dataList[i][4] = String.valueOf(orderImages.get(i).getCreateTime());
  141. dataList[i][5] = String.valueOf(orderImages.get(i).getCreateUser());
  142. dataList[i][6] = String.valueOf(orderImages.get(i).getOrderId());
  143. dataList[i][7] = String.valueOf(orderImages.get(i).getUserId());
  144. dataList[i][8] = String.valueOf(orderImages.get(i).getStoreId());
  145. dataList[i][9] = String.valueOf(orderImages.get(i).getOriginalImage());
  146. dataList[i][10] = String.valueOf(orderImages.get(i).getOriginalSize());
  147. dataList[i][11] = String.valueOf(orderImages.get(i).getFinishedImage());
  148. dataList[i][12] = String.valueOf(orderImages.get(i).getFinishedSize());
  149. dataList[i][13] = String.valueOf(orderImages.get(i).getDealUser());
  150. dataList[i][14] = String.valueOf(orderImages.get(i).getStatusFlag());
  151. dataList[i][15] = String.valueOf(orderImages.get(i).getRemark());
  152. }
  153. ExportExcelUtil.ExportWithResponse(sheetName, titleName, fileName,
  154. columnNumber, columnWidth, columnName, dataList, response);
  155. }
  156. /**
  157. * <p>返修。</p>
  158. */
  159. @RequestMapping(value = "/repair", method = RequestMethod.POST)
  160. @ResponseBody
  161. public Result repair(OrderImage record) {
  162. boolean num = orderImageService.repair(record);
  163. if (num) {
  164. return new Result(true, "保存成功");
  165. }
  166. return new Result(false, "保存异常");
  167. }
  168. @RequestMapping(value = "/uploadFileForOrder")
  169. @ResponseBody
  170. public Result uploadFile(HttpServletRequest request, String storeId, String orderId, String userId, String typeFlag) {
  171. CommonsMultipartResolver multipartResolver = new CommonsMultipartResolver(request.getSession().getServletContext());
  172. if (multipartResolver.isMultipart(request)) {
  173. MultipartHttpServletRequest multiRequest = (MultipartHttpServletRequest) request;
  174. Iterator it = multiRequest.getFileNames();
  175. List<ImageUploadLog> paths = new ArrayList<>();
  176. while (it.hasNext()) {
  177. MultipartFile file = multiRequest.getFile(it.next().toString());
  178. if (file != null) {
  179. try {
  180. String originalFilename = file.getOriginalFilename();
  181. String uploadPath = storeId + "/" + orderId + "/" + typeFlag + "/" + originalFilename;
  182. String path = OSSFileService.upload(file.getInputStream(), uploadPath);
  183. ImageUploadLog imageUploadLog = new ImageUploadLog();
  184. imageUploadLog.setStoreId(storeId);
  185. imageUploadLog.setOrderId(orderId);
  186. imageUploadLog.setTypeFlag(typeFlag);
  187. imageUploadLog.setUserId(userId);
  188. imageUploadLog.setImageName(originalFilename);
  189. imageUploadLog.setUrl(path);
  190. imageUploadLog.setImageSize(BigDecimal.valueOf(file.getSize()));
  191. imageUploadLogService.createImageUploadLog(imageUploadLog);
  192. paths.add(imageUploadLog);
  193. } catch (IOException e) {
  194. e.printStackTrace();
  195. return new Result(false, "上传失败");
  196. }
  197. }
  198. }
  199. return new Result(true, paths);
  200. }
  201. return new Result(false, "上传失败");
  202. }
  203. /**
  204. * 清空未使用图片
  205. *
  206. * @param orderId
  207. * @return
  208. */
  209. @RequestMapping(value = "/delOssImage", method = RequestMethod.POST)
  210. @ResponseBody
  211. public Result delOssImage(@RequestParam(required = true, value = "orderId") String orderId) {
  212. List<ImageUploadLog> imageUploadLogs = imageUploadLogService.queryDelOssImage(orderId);
  213. for (ImageUploadLog imageUploadLog : imageUploadLogs) {
  214. String imageName = imageUploadLog.getUrl().replace(PropertiesFileLoader.getProperties("aliImageSever") + "/", "");
  215. OSSFileService.deleteObject(imageName);
  216. }
  217. return new Result(true, "删除成功");
  218. }
  219. /**
  220. * 批量更新成片
  221. *
  222. * @param orderId
  223. * @param imageIds
  224. * @return
  225. */
  226. @RequestMapping(value = "/updateFinishedImages", method = RequestMethod.POST)
  227. @ResponseBody
  228. public Result updateFinishedImages(@RequestParam(required = true, value = "orderId") String orderId, @RequestParam(required = true, value = "imageIds") String imageIds) {
  229. ImageUploadLog record = new ImageUploadLog();
  230. record.setOrderId(orderId);
  231. record.setIdStr(imageIds);
  232. List<ImageUploadLog> imageUploadLogs = imageUploadLogService.getImageUploadLogList(record);
  233. for (ImageUploadLog imageUploadLog : imageUploadLogs) {
  234. OrderImage orderImage = new OrderImage();
  235. orderImage.setOrderId(orderId);
  236. orderImage.setImageName(imageUploadLog.getImageName());
  237. orderImage = orderImageService.getOrderImage(orderImage);
  238. if (orderImage != null) {
  239. orderImage.setFinishedImage(imageUploadLog.getUrl());
  240. orderImage.setFinishedSize(imageUploadLog.getImageSize());
  241. }
  242. orderImageService.updateOrderImage(orderImage);
  243. }
  244. return new Result(true, "保存成功");
  245. }
  246. }