TPromoCodeController.java 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368
  1. package com.szwl.controller;
  2. import cn.afterturn.easypoi.excel.ExcelExportUtil;
  3. import cn.afterturn.easypoi.excel.entity.ExportParams;
  4. import com.alibaba.fastjson.JSONArray;
  5. import com.alibaba.fastjson.JSONObject;
  6. import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
  7. import com.baomidou.mybatisplus.core.metadata.IPage;
  8. import com.baomidou.mybatisplus.core.toolkit.Wrappers;
  9. import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
  10. import com.szwl.feign.bean.PayFeign;
  11. import com.szwl.model.bo.JoinpayConstant;
  12. import com.szwl.model.bo.JsonMessage;
  13. import com.szwl.model.bo.R;
  14. import com.szwl.model.bo.ResponseModel;
  15. import com.szwl.model.dto.PromoCodeTarget;
  16. import com.szwl.model.entity.*;
  17. import com.szwl.service.*;
  18. import io.swagger.annotations.Api;
  19. import io.swagger.annotations.ApiOperation;
  20. import org.apache.commons.lang.StringUtils;
  21. import org.apache.poi.ss.usermodel.Workbook;
  22. import org.springframework.beans.factory.annotation.Autowired;
  23. import org.springframework.web.bind.annotation.GetMapping;
  24. import org.springframework.web.bind.annotation.RequestMapping;
  25. import org.springframework.web.bind.annotation.RequestParam;
  26. import org.springframework.web.bind.annotation.RestController;
  27. import javax.servlet.http.HttpServletResponse;
  28. import java.io.IOException;
  29. import java.io.OutputStream;
  30. import java.io.UnsupportedEncodingException;
  31. import java.math.BigDecimal;
  32. import java.net.URLEncoder;
  33. import java.text.SimpleDateFormat;
  34. import java.util.*;
  35. import static com.szwl.constant.ResponseCodesEnum.A0001;
  36. /**
  37. * <p>
  38. * 优惠码列表 前端控制器
  39. * </p>
  40. *
  41. * @author wuhs
  42. * @since 2022-06-17
  43. */
  44. @Api(value = "/tPromoCode", tags = {"优惠码"})
  45. @RestController
  46. @RequestMapping("/tPromoCode")
  47. public class TPromoCodeController {
  48. @Autowired
  49. TEquipmentService tEquipmentService;
  50. @Autowired
  51. TPromoCodeService promoCodeService;
  52. @Autowired
  53. TPriceService priceService;
  54. @Autowired
  55. TAdminService adminService;
  56. @Autowired
  57. TOrderService orderService;
  58. @Autowired
  59. TJoinpayMchService joinpayMchService;
  60. @Autowired
  61. PayFeign payFeign;
  62. @ApiOperation(value = "获取优惠码")
  63. @GetMapping("/getTPromoCode")
  64. public ResponseModel<IPage<TPromoCode>> getTPromoCode(@RequestParam String code) {
  65. LambdaQueryWrapper<TPromoCode> query = Wrappers.lambdaQuery();
  66. query.eq(TPromoCode::getCode,code);
  67. Page<TPromoCode> page = new Page<>(0, 10, true);
  68. IPage<TPromoCode> iPage = promoCodeService.page(page, query);
  69. return R.ok(iPage);
  70. }
  71. @ApiOperation(value = "修改优惠码")
  72. @GetMapping("/updatePromoCode")
  73. public void updatePromoCode(@RequestParam(value = "id")String id, @RequestParam(value = "type")String type) {
  74. TPromoCode promoCode = promoCodeService.getById(id);
  75. promoCode.setIsUse(type);
  76. promoCodeService.updateById(promoCode);
  77. }
  78. @ApiOperation(value = "生成0折优惠码")
  79. @GetMapping("/addPromoCode")
  80. public void addPromoCode(@RequestParam(value = "adminId")String adminId,@RequestParam(value = "lastUseDate")Date lastUseDate,@RequestParam(value = "number")String number) {
  81. int num = Integer.parseInt(number);
  82. List<String> codes = new ArrayList<>();
  83. for (int i = 0; i < num; i++) {
  84. String code = orderService.initSn(Long.valueOf(adminId));
  85. StringBuffer str = new StringBuffer();
  86. str.append(code.substring(0, 6));
  87. codes.add(str.toString());
  88. }
  89. TAdmin admin = adminService.getById(adminId);
  90. for (String code : codes) {
  91. TPromoCode promoCode = new TPromoCode();
  92. promoCode.setCreateDate(new Date());
  93. promoCode.setModifyDate(new Date());
  94. promoCode.setCode(Long.parseLong(code));
  95. promoCode.setAdminId(adminId);
  96. promoCode.setIsUse("0");
  97. promoCode.setDiscount(0f);
  98. promoCode.setLastUseDate(lastUseDate);
  99. promoCode.setCreateDate(new Date());
  100. promoCode.setUserName(admin.getUsername());
  101. promoCodeService.save(promoCode);
  102. }
  103. }
  104. @ApiOperation(value = "添加优惠码")
  105. @GetMapping("/add")
  106. public ResponseModel<?> add(Long adminId,int number,Float discount,Float month,String type,String frpCode) {
  107. if(discount==null||month==null||adminId==null||StringUtils.isEmpty(type)){
  108. return R.fail(A0001);
  109. }
  110. TAdmin admin = adminService.getById(adminId);
  111. if(String.valueOf(admin.getId()).equals("1")){
  112. List<String> codes =new ArrayList<>();
  113. for(int i=0;i<number;i++){
  114. StringBuilder num = new StringBuilder();
  115. Random random = new Random();
  116. for (int j = 0; j < 8; j++) {
  117. num.append(String.valueOf(random.nextInt(10)));
  118. }
  119. String code = num.toString();
  120. codes.add(code);
  121. }
  122. Long data = Calendar.getInstance().getTimeInMillis();
  123. Float mm = month*10;
  124. String m = String.valueOf(mm);
  125. String[] split = m.split("\\.");
  126. String th = split[0];
  127. Long t = Long.valueOf(th);
  128. Long mon = 30L*24L*60L*60L*1000L;
  129. Long d = data + ((mon*t)/10);
  130. SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
  131. String sd = sdf.format(new Date(Long.parseLong(String.valueOf(d))));
  132. Date lastUseDate = new Date(Long.parseLong(String.valueOf(d)));
  133. for(String code : codes){
  134. TPromoCode promoCode = new TPromoCode();
  135. promoCode.setCode(Long.parseLong(code));
  136. promoCode.setAdminId(String.valueOf(admin.getId()));
  137. promoCode.setIsUse("0");
  138. promoCode.setDiscount(discount);
  139. promoCode.setLastUseDate(lastUseDate);
  140. promoCode.setCreateDate(new Date());
  141. promoCode.setUserName(admin.getUsername());
  142. promoCode.setType(type);
  143. promoCodeService.save(promoCode);
  144. }
  145. return R.ok();
  146. }
  147. LambdaQueryWrapper<TEquipment> query = Wrappers.lambdaQuery();
  148. query.eq(TEquipment::getAdminId,admin.getId());
  149. List<TEquipment> list = tEquipmentService.list(query);
  150. TEquipment equipment = list.get(0);
  151. if(list.size()==0){
  152. // "要有机器才能购买优惠码";
  153. return R.fail("没有机器");
  154. }
  155. //0折优惠码需要支付
  156. if(type.equals("0")&&discount==0){
  157. if(admin.getPromoCodeOpen()==null||admin.getPromoCodeOpen().equals("1")){
  158. Long equipmentId = equipment.getId();
  159. Double money = null;
  160. LambdaQueryWrapper<TPrice> query1 = Wrappers.lambdaQuery();
  161. query1.eq(TPrice::getName,"优惠码");
  162. List<TPrice> prices = priceService.list(query1);
  163. for(TPrice price:prices){
  164. if(price.getName().equals("优惠码")){
  165. money = price.getPrice();
  166. }
  167. }
  168. String sn = orderService.initSn(equipmentId);
  169. String orderNo = sn;
  170. String productName = "优惠码";
  171. BigDecimal price = BigDecimal.valueOf(money*number);
  172. BigDecimal cutPrice = price.multiply(new BigDecimal(100)).divide(new BigDecimal(100));
  173. BigDecimal amount = cutPrice;
  174. String productDesc = "";
  175. String commonParameter = "";
  176. String returnUrl = null;
  177. String notifyUrl = JoinpayConstant.Notify_Url_PromoCode;
  178. String isShowPic = "1";
  179. String openId = null;
  180. String authCode = null;
  181. String appid = null;
  182. String transactionModel = null;
  183. String tradeMerchantNo = null;
  184. String buyerId = null;
  185. String isAlt = "0";
  186. String altType = null;
  187. String altUrl = null;
  188. BigDecimal marketingAmount = null;
  189. // frpCode = "WEIXIN_NATIVE";
  190. TOrder order1 = new TOrder();
  191. order1.setSn(sn);
  192. order1.setType(0);
  193. order1.setAdminId(admin.getId());
  194. order1.setProductName(productName);
  195. order1.setPrice(price);
  196. order1.setEquipmentId(equipmentId);
  197. order1.setClientId(equipment.getClientId());
  198. order1.setStatus(0);
  199. order1.setFrpCode(frpCode);
  200. // order1.setRefundTrxNo(String.valueOf(month));
  201. order1.setCreateDate(new Date());
  202. order1.setModifyDate(new Date());
  203. payFeign.addOrder(order1);
  204. JSONArray altInfo = new JSONArray();
  205. String result = null;
  206. try {
  207. result = joinpayMchService.uniPay(
  208. orderNo, amount, productName, productDesc,
  209. commonParameter, returnUrl, notifyUrl, frpCode,
  210. isShowPic, openId, authCode, appid, transactionModel, tradeMerchantNo,
  211. buyerId, isAlt, altType, altInfo, altUrl, marketingAmount
  212. );
  213. } catch (Exception e) {
  214. e.printStackTrace();
  215. return R.fail("申请支付失败");
  216. }
  217. JSONObject resultJson = JSONObject.parseObject(result);
  218. // 汇聚支付支付申请返回支付二维码图片
  219. String rd_Pic = resultJson.getString("rd_Pic");
  220. if (resultJson == null || StringUtils.isBlank(rd_Pic)) {
  221. return R.fail("找不到支付图片");
  222. }
  223. JSONObject kindData = new JSONObject();
  224. kindData.put("sn", sn);
  225. kindData.put("price", price);
  226. kindData.put("image", rd_Pic);
  227. return R.ok(kindData);
  228. }
  229. }
  230. Long equipmentId = equipment.getId();
  231. List<String> codes =new ArrayList<>();
  232. for(int i=0;i<number;i++){
  233. String code = orderService.initSn(equipmentId);
  234. StringBuffer str = new StringBuffer();
  235. str.append(code.substring(0,6));
  236. codes.add(str.toString());
  237. }
  238. Long data = Calendar.getInstance().getTimeInMillis();
  239. Float mm = month*10;
  240. String m = String.valueOf(mm);
  241. String[] split = m.split("\\.");
  242. String th = split[0];
  243. Long t = Long.valueOf(th);
  244. Long mon = 30L*24L*60L*60L*1000L;
  245. Long d = data + ((mon*t)/10);
  246. SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
  247. String sd = sdf.format(new Date(Long.parseLong(String.valueOf(d))));
  248. Date lastUseDate = new Date(Long.parseLong(String.valueOf(d)));
  249. for(String code : codes){
  250. TPromoCode promoCode = new TPromoCode();
  251. promoCode.setCode(Long.parseLong(code));
  252. promoCode.setAdminId(String.valueOf(admin.getId()));
  253. promoCode.setIsUse("0");
  254. promoCode.setDiscount(discount);
  255. promoCode.setLastUseDate(lastUseDate);
  256. promoCode.setCreateDate(new Date());
  257. promoCode.setUserName(admin.getUsername());
  258. promoCode.setType(type);
  259. promoCodeService.save(promoCode);
  260. }
  261. return R.ok();
  262. }
  263. @ApiOperation(value = "获取优惠码列表")
  264. @GetMapping("/pagePromoCode")
  265. public ResponseModel<IPage<?>> pagePromoCode(String adminId , String code, String isUse, Date useStratDate,Date useEndDate,Date createStratDate,Date createEndDate, long current, long size ) {
  266. LambdaQueryWrapper<TPromoCode> query = Wrappers.lambdaQuery();
  267. if(StringUtils.isNotEmpty(adminId)){
  268. TAdmin admin = adminService.getById(adminId);
  269. if(admin.getType()==0||admin.getType()==1){
  270. }else {
  271. query.eq(TPromoCode::getAdminId,adminId);
  272. }
  273. }else {
  274. return R.fail(A0001);
  275. }
  276. if(StringUtils.isNotEmpty(code)){
  277. query.eq(TPromoCode::getCode,code);
  278. }
  279. if(StringUtils.isNotEmpty(isUse)){
  280. query.like(TPromoCode::getIsUse,isUse);
  281. }
  282. if(useStratDate!=null&&useEndDate!=null){
  283. query.gt(TPromoCode::getUseDate,useStratDate);
  284. query.lt(TPromoCode::getUseDate,useEndDate);
  285. }
  286. if(createStratDate!=null&&createEndDate!=null){
  287. query.gt(TPromoCode::getCreateDate,createStratDate);
  288. query.lt(TPromoCode::getCreateDate,createEndDate);
  289. }
  290. Page<TPromoCode> page = new Page<>(current, size, true);
  291. IPage<TPromoCode> iPage = promoCodeService.page(page, query);
  292. return R.ok(iPage);
  293. }
  294. @ApiOperation(value = "导出优惠码列表")
  295. @GetMapping("/export")
  296. public Object export(HttpServletResponse response, String adminId , String code, String isUse, Date useStratDate, Date useEndDate, Date createStratDate, Date createEndDate, long current, long size ) {
  297. LambdaQueryWrapper<TPromoCode> query = Wrappers.lambdaQuery();
  298. if(StringUtils.isNotEmpty(adminId)){
  299. TAdmin admin = adminService.getById(adminId);
  300. if(admin.getType()==0||admin.getType()==1){
  301. }else {
  302. query.eq(TPromoCode::getAdminId,adminId);
  303. }
  304. }else {
  305. return R.fail(A0001);
  306. }
  307. if(StringUtils.isNotEmpty(code)){
  308. query.eq(TPromoCode::getCode,code);
  309. }
  310. if(StringUtils.isNotEmpty(isUse)){
  311. query.like(TPromoCode::getIsUse,isUse);
  312. }
  313. if(useStratDate!=null&&useEndDate!=null){
  314. query.gt(TPromoCode::getUseDate,useStratDate);
  315. query.lt(TPromoCode::getUseDate,useEndDate);
  316. }
  317. if(createStratDate!=null&&createEndDate!=null){
  318. query.gt(TPromoCode::getCreateDate,createStratDate);
  319. query.lt(TPromoCode::getCreateDate,createEndDate);
  320. }
  321. Page<TPromoCode> page = new Page<>(current, size, true);
  322. IPage<TPromoCode> iPage = promoCodeService.page(page, query);
  323. List<TPromoCode> list = iPage.getRecords();
  324. List<PromoCodeTarget> promoCodeTargets = promoCodeService.findById(list);
  325. ExportParams exportParams = new ExportParams("优惠码记录", "sheet1");
  326. Workbook workbook = ExcelExportUtil.exportExcel(exportParams, PromoCodeTarget.class, promoCodeTargets);
  327. if (workbook != null) {
  328. OutputStream os = null;
  329. try {
  330. os = response.getOutputStream();
  331. SimpleDateFormat format = new SimpleDateFormat("yyyyMMddHHmmss");
  332. response.setContentType("application/vnd.ms-excel;charset=utf-8");
  333. response.setHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode("订单记录数据导出" + format.format(new Date()) + ".xls", "UTF-8"));
  334. workbook.write(os);
  335. return JsonMessage.success("导出成功");
  336. } catch (Exception e) {
  337. e.printStackTrace();
  338. return JsonMessage.success("导出错误");
  339. } finally {
  340. try {
  341. os.close();
  342. workbook.close();
  343. } catch (IOException e) {
  344. e.printStackTrace();
  345. }
  346. }
  347. }
  348. return JsonMessage.success("导出成功");
  349. }
  350. }