ElectronicMembershipCardController.java 35 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574
  1. package com.platform.yijia.controller;
  2. import com.alibaba.fastjson.JSON;
  3. import com.alibaba.fastjson.JSONObject;
  4. import com.alibaba.fastjson.parser.Feature;
  5. import com.google.gson.Gson;
  6. import com.platform.yijia.param.request.RechargeBalance;
  7. import com.platform.yijia.pojo.*;
  8. import com.platform.yijia.service.ElectronicMembershipCardService;
  9. import com.platform.yijia.service.GzhNewsTemplateService;
  10. import com.platform.yijia.service.StationService;
  11. import com.platform.yijia.utils.*;
  12. import com.platform.yijia.utils.weixinapp.WxPushUtil;
  13. import me.chanjar.weixin.mp.bean.template.WxMpTemplateData;
  14. import org.apache.commons.lang3.StringUtils;
  15. import org.slf4j.Logger;
  16. import org.slf4j.LoggerFactory;
  17. import org.springframework.stereotype.Controller;
  18. import org.springframework.transaction.annotation.Transactional;
  19. import org.springframework.web.bind.annotation.*;
  20. import javax.annotation.Resource;
  21. import java.math.BigDecimal;
  22. import java.text.SimpleDateFormat;
  23. import java.util.*;
  24. /*
  25. * <Title> ElectronicMembershipCardController </Title>
  26. * <Description> 电子会员卡(储蓄卡)功能模块 </Description>
  27. * @Author JK
  28. * @Date 2021年3月22日
  29. */
  30. @Controller
  31. @RequestMapping("/demo")
  32. public class ElectronicMembershipCardController {
  33. private static Logger logger =(Logger) LoggerFactory.getLogger(ElectronicMembershipCardController.class);
  34. @Resource
  35. private ElectronicMembershipCardService electronicMembershipCardService;
  36. @Resource
  37. private StationService stationService;
  38. @Resource
  39. private GzhNewsTemplateService gzhNewsTemplateService;
  40. @Resource
  41. private WxPushUtil wxPushUtil;
  42. //获取用户电子会员卡(储蓄卡)列表
  43. @RequestMapping(value = "/getElectronicCardList", method = RequestMethod.GET)
  44. @ResponseBody
  45. public String getElectronicCardList(@RequestParam Integer stationId, String unionId){
  46. Gson gson =new Gson();
  47. //返回结果集
  48. ResultData resultData = null;
  49. if(stationId !=null && unionId !=null){
  50. CustomerElectronicCard customerElectronicCard = new CustomerElectronicCard();
  51. customerElectronicCard.setStationId(stationId);
  52. customerElectronicCard.setUnionId(unionId);
  53. List<CustomerElectronicCard> electronicCardList = electronicMembershipCardService.getElectronicCardList(customerElectronicCard);
  54. resultData = ResultData.success(electronicCardList);
  55. }else {
  56. resultData = ResultData.error(CodeMsg.REQUEST_FAIL);
  57. }
  58. return gson.toJson(resultData);
  59. }
  60. //用户充值电子会员卡(储蓄卡)生成充值记录
  61. @RequestMapping(value = "/rechargeBalance", method = RequestMethod.POST)
  62. @ResponseBody
  63. @Transactional
  64. public String rechargeBalance(@RequestBody RechargeBalance rechargeBalance){
  65. Gson gson =new Gson();
  66. //返回结果集
  67. ResultData resultData = null;
  68. if(rechargeBalance !=null){
  69. BigDecimal amt = new BigDecimal(rechargeBalance.getAmt());
  70. //String openId = rechargeBalance.getOpenId(); //公众号的openId
  71. Integer stationId = rechargeBalance.getStationId();
  72. //BigDecimal presentAmt = new BigDecimal(rechargeBalance.getPresentAmt());
  73. String payType = rechargeBalance.getPayType();
  74. String customerName = rechargeBalance.getCustomerName();
  75. String cardOilsType = rechargeBalance.getCardOilsType();
  76. String unionId = rechargeBalance.getUnionId();
  77. String stationName = rechargeBalance.getStationName();
  78. String stationCardEnabledFlag = electronicMembershipCardService.getStationCardEnabledFlag(stationId);
  79. //是否启用电子卡功能
  80. if(stationCardEnabledFlag.equals("1")){
  81. CustomerCardUseRecord customerCardUseRecord = new CustomerCardUseRecord(); //电子会员卡使用记录
  82. CustomerCardSetting customerCardSetting = new CustomerCardSetting(); //电子卡优惠规则设置
  83. customerCardSetting.setStationId(stationId);
  84. customerCardSetting.setCardOilsType(cardOilsType);
  85. customerCardSetting.setOrderBy("DESC");
  86. //获取用户要充值电子卡的优惠规则信息
  87. List<CustomerCardSetting> cardRechargeSettingList = electronicMembershipCardService.getCardRechargeSettingList(customerCardSetting);
  88. if(cardRechargeSettingList !=null && cardRechargeSettingList.size() ==1){
  89. String discountTime = cardRechargeSettingList.get(0).getDiscountTime();
  90. String[] dctime={}; //会员充值活动时间
  91. if(discountTime.contains(",")){
  92. dctime =discountTime.split(",");
  93. }else {
  94. dctime =new String[1];
  95. dctime[0] = discountTime;
  96. }
  97. String currentTime =null;
  98. Calendar calendar = Calendar.getInstance();
  99. calendar.setTime(new Date()); //获取当前时间
  100. //循环优惠规则明细
  101. for (CustomerCardSettingDetail cardDetail : cardRechargeSettingList.get(0).getCustomerCardSettingDetailList()){
  102. if(amt.compareTo(cardDetail.getDiscountAmtEnd()) ==1 || amt.compareTo(cardDetail.getDiscountAmtEnd()) ==0){
  103. //String isDiscountCoupon = cardRechargeSettingList.get(0).getIsDiscountCoupon(); //是否使用优惠券
  104. //充值优惠类型
  105. if(cardDetail.getSettingRuleType().equals("1")){ //按充值金额
  106. BigDecimal presentAmt = cardDetail.getPresentAmt(); //当前赠送金额
  107. if(cardRechargeSettingList.get(0).getDiscountTimeSetting().equals("1") && dctime !=null){
  108. String discountTimeType = cardRechargeSettingList.get(0).getDiscountTimeType(); //获取日期类型
  109. switch (discountTimeType){
  110. case "1": // 1.按周来
  111. int day_Week = calendar.get(Calendar.DAY_OF_WEEK);
  112. day_Week= day_Week-1; //减一原因:数据库存的下标从零开始
  113. currentTime = String.valueOf(day_Week);
  114. break;
  115. case "2": // 2.每月的多少号
  116. int day_month = calendar.get(Calendar.DAY_OF_MONTH);
  117. day_month = day_month-1; //减一原因:数据库存的下标从零开始
  118. currentTime = String.valueOf(day_month); //当前时间
  119. break;
  120. case "3": // 3.固定日期
  121. currentTime =new SimpleDateFormat("yyyy-MM-dd").format(new Date());
  122. break;
  123. }
  124. for (String str : dctime){
  125. if(str.equals(currentTime)){ //如果当前时间在会员日活动时间内
  126. //计算会员日内的总赠送积分
  127. if(cardRechargeSettingList.get(0).getPresentScale() !=null){
  128. presentAmt = presentAmt.multiply(new BigDecimal(cardRechargeSettingList.get(0).getPresentScale())).add(presentAmt);
  129. }
  130. break;
  131. }
  132. }
  133. }
  134. customerCardUseRecord.setAmt(amt);
  135. customerCardUseRecord.setPresentAmt(presentAmt);
  136. }else if(cardDetail.getSettingRuleType().equals("2")){ //按充值金额的比例
  137. BigDecimal presentAmt = amt.multiply(cardDetail.getPresentAmt().divide(new BigDecimal(100))); //当前赠送金额比例的赠送积分
  138. if(cardRechargeSettingList.get(0).getDiscountTimeSetting().equals("1") && dctime !=null){
  139. String discountTimeType = cardRechargeSettingList.get(0).getDiscountTimeType(); //获取日期类型
  140. switch (discountTimeType){
  141. case "1": // 1.按周来
  142. int day_Week = calendar.get(Calendar.DAY_OF_WEEK);
  143. day_Week= day_Week-1; //减一原因:数据库存的下标从零开始
  144. currentTime = String.valueOf(day_Week);
  145. break;
  146. case "2": // 2.每月的多少号
  147. int day_month = calendar.get(Calendar.DAY_OF_MONTH);
  148. day_month = day_month-1; //减一原因:数据库存的下标从零开始
  149. currentTime = String.valueOf(day_month); //当前时间
  150. break;
  151. case "3": // 3.固定日期
  152. currentTime =new SimpleDateFormat("yyyy-MM-dd").format(new Date());
  153. break;
  154. }
  155. for (String str : dctime){
  156. if(str.equals(currentTime)){ //如果当前时间在会员日活动时间内
  157. //计算会员日期内的总赠送积分
  158. if(cardRechargeSettingList.get(0).getPresentScale() !=null){
  159. presentAmt = presentAmt.multiply(new BigDecimal(cardRechargeSettingList.get(0).getPresentScale())).add(presentAmt);
  160. }
  161. break;
  162. }
  163. }
  164. }
  165. customerCardUseRecord.setAmt(amt);
  166. customerCardUseRecord.setPresentAmt(presentAmt);
  167. }
  168. break;
  169. }
  170. }
  171. }else {
  172. customerCardUseRecord.setAmt(amt);
  173. customerCardUseRecord.setPresentAmt(new BigDecimal(0));
  174. }
  175. customerCardUseRecord.setUnionId(unionId);
  176. customerCardUseRecord.setStationId(stationId);
  177. customerCardUseRecord.setCardOilsType(cardOilsType);
  178. customerCardUseRecord.setStationName(stationName);
  179. customerCardUseRecord.setCustomerName(customerName);
  180. customerCardUseRecord.setUsageType("+");
  181. customerCardUseRecord.setPayType(payType); //1表示微信
  182. customerCardUseRecord.setCreateTime(new Date());
  183. customerCardUseRecord.setStatus("0");
  184. CustomerElectronicCard c = new CustomerElectronicCard(); //电子会员卡
  185. c.setUnionId(unionId);
  186. c.setCardOilsType(cardOilsType);
  187. CustomerElectronicCard electronicCardInfoByUnionId = electronicMembershipCardService.getElectronicCardInfoByUnionId(c);
  188. if(electronicCardInfoByUnionId !=null && electronicCardInfoByUnionId.getCustomerNo() !=null){
  189. customerCardUseRecord.setCustomerNo(electronicCardInfoByUnionId.getCustomerNo());
  190. }
  191. //订单规则 时间+6位随机数
  192. Random random = new Random();
  193. String str="";
  194. for(int i=0; i<6; i++){
  195. str+=random.nextInt(10);
  196. }
  197. String orderNo = System.nanoTime()+str;
  198. customerCardUseRecord.setOrderNo(orderNo);
  199. electronicMembershipCardService.insetCardUseRecord(customerCardUseRecord); //插入电子会员卡的使用记录
  200. resultData = ResultData.success(orderNo);
  201. }
  202. }
  203. return gson.toJson(resultData);
  204. }
  205. //用户充值电子会员卡(储蓄卡)拉起随行付支付接口
  206. @RequestMapping(value = "/rechargeBalanceSXFPay", method = RequestMethod.POST)
  207. @ResponseBody
  208. public String rechargeBalanceSXFPay(@RequestBody RechargeBalance rechargeBalance){
  209. Gson gson =new Gson();
  210. //返回结果集
  211. ResultData resultData = null;
  212. if(rechargeBalance !=null){
  213. String amt = rechargeBalance.getAmt();
  214. String openId = rechargeBalance.getOpenId(); //公众号的openId
  215. Integer stationId = rechargeBalance.getStationId();
  216. String userType = rechargeBalance.getUserType();
  217. String subject = rechargeBalance.getSubject();
  218. String orderNo = rechargeBalance.getOrderNo();
  219. //将业务参数存放在 JSON 对象中
  220. JSONObject reqData = new JSONObject();
  221. Map<String, String> resultMap = stationService.getStationAppIdAndAppSecret(stationId);
  222. if(resultMap !=null && resultMap.containsKey("gzhAppId") && resultMap.containsKey("mno")){
  223. logger.info("==============================电子会员卡(储蓄卡)充值功能调用随行付接口================================");
  224. try {
  225. if(userType.equals("1")){
  226. //1 是公众号
  227. reqData.put("payWay", "02"); //支付方式 02 公众号/服 务窗/js支付 03 小程序
  228. reqData.put("userId", openId); //用户号 微信:openid; 支付宝:userid;银联:userid;微信&支付宝必传,银联js为非必传
  229. reqData.put("subAppid", resultMap.get("gzhAppId")); //微信公众号
  230. logger.info("支付子商户:"+ resultMap.get("gzhAppId"));
  231. }else if(userType.equals("2")){
  232. reqData.put("payWay", "03"); //支付方式 02 公众号/服 务窗/js支付 03 小程序
  233. reqData.put("userId", openId); //用户号 微信:openid; 支付宝:userid;银联:userid;微信&支付宝必传,银联js为非必传
  234. reqData.put("subAppid", resultMap.get("appId")); //微信小程序
  235. logger.info("支付子商户:"+ resultMap.get("appId"));
  236. }
  237. reqData.put("mno", resultMap.get("mno")); //商户编号
  238. logger.info("商户编号:"+ resultMap.get("mno"));
  239. reqData.put("ordNo", orderNo); //商户订单号
  240. reqData.put("amt", amt); //订单总金额
  241. reqData.put("payType", "WECHAT"); //支付渠道
  242. reqData.put("subject", subject); //订单标题
  243. reqData.put("tradeSource", "01"); //交易来源 01服务商,02收银台,03硬件
  244. reqData.put("trmIp", "172.16.2.1");//商家ip地址
  245. reqData.put("outFrontFailUrl", ""); //js 支付,前台 事变通知地址
  246. reqData.put("notifyUrl", "https://www.huijy.net/demo/getCardRechargeCallback"); //回调地址
  247. // reqData.put("notifyUrl", "https://www.huijy.net/api/getCardRechargeCallback"); //回调地址
  248. // reqData.put("subMechId", ""); //子商户号
  249. // reqData.put("amt", "0.01");
  250. // reqData.put("discountAmt", ""); //参与优惠金额
  251. // reqData.put("unDiscountAmt", ""); //不参与优惠金额
  252. // reqData.put("timeExpire", "10"); //订单失效时间, 以分钟为单位
  253. // reqData.put("limitPay", "00"); //限制卡类型: 00-全部 01-限定不能使 用信用卡支付 默认值 00
  254. // reqData.put("hbFqNum", "6"); //花呗分期数,仅可上送 6 或 12
  255. // reqData.put("customerIp", ""); //持卡人ip地址,银联js支付时必传
  256. // reqData.put("outFrontUrl", ""); //js 支付,前台 成功通知地址
  257. // reqData.put("needReceipt", "00"); //电子发票功能 微信开具电子 发票使用
  258. // reqData.put("ledgerAccountFlag", "00"); //是否做分账 分账交易使 用;00:做; 01:不做;不传默认为不做分账
  259. // reqData.put("ledgerAccountEffectTime", "00"); //分账有效时间 单位为天;是 否做分账选择 00 时该字段必传
  260. // reqData.put("ruleId", "00"); //同 步 分 账 规 则 id
  261. // reqData.put("fusruleId", "00"); //同步分账规则
  262. // reqData.put("ylTrmNo", ""); //银联终端号
  263. // reqData.put("terminalId", ""); //TQ机具编号
  264. // reqData.put("deviceNo ", "1111"); //设备号
  265. // reqData.put("identityFlag", ""); //是否是实名支付
  266. // reqData.put("buyerIdType", "IDCARD"); //证件类型
  267. // reqData.put("buyerIdNo", "410523198701054018"); //证件号
  268. // reqData.put("buyerName", "张三"); //买家姓名
  269. // reqData.put("mobileNum", ""); //手机号
  270. // reqData.put("extend", ""); //备用
  271. String req= SXFPaySign.getSXFPay(reqData);
  272. logger.debug("参数信息:"+req);
  273. System.out.println("req:" + req);
  274. //此处不要改变reqData里面值的顺序用LinkedHashMap
  275. HashMap reqMap = JSON.parseObject(req, LinkedHashMap.class, Feature.OrderedField);
  276. //组装加密串
  277. String signContent = RSASignature.getOrderContent(reqMap);
  278. System.out.println("拼接后的参数:" + signContent);
  279. logger.debug("拼接后的参数:"+signContent);
  280. //sign
  281. String sign = RSASignature.encryptBASE64(RSASignature.sign(signContent, SXFPaySign.privateKey));
  282. System.out.println("============签名:" + sign);
  283. reqMap.put("sign", sign);
  284. String reqStr = JSON.toJSONString(reqMap);
  285. System.out.println("请求参数:" + reqMap);
  286. System.out.println("请求参数:" + reqStr);
  287. //调用第三方接口地址
  288. //String url = "https://openapi-test.tianquetech.com/order/jsapiScan";//测试地址
  289. String url = "https://openapi.suixingpay.com/order/jsapiScan";//生产地址
  290. String resultJson = HttpUtils.connectPostUrl(url, reqStr);
  291. System.out.println("返回信息:" + resultJson);
  292. // logger.debug("返回信息:"+resultJson);
  293. //不要对reqData排序 所以用LinkedHashMap
  294. HashMap<String, Object> result = JSON.parseObject(resultJson, LinkedHashMap.class, Feature.OrderedField);
  295. if ("0000".equals(result.get("code"))) {
  296. //验签
  297. String signResult = result.get("sign").toString();
  298. result.remove("sign");
  299. String resultStr = RSASignature.getOrderContent(result);
  300. System.out.println(resultStr);
  301. //sign
  302. String resultSign = RSASignature.encryptBASE64(RSASignature.sign(signContent, SXFPaySign.privateKey));
  303. System.out.println("resultSign:" + resultSign);
  304. //组装加密串
  305. if (RSASignature.doCheck(resultStr, signResult, SXFPaySign.sxfPublic)) {
  306. System.out.println("===================验签成功==============");
  307. }
  308. }
  309. resultData=ResultData.success(result);
  310. }catch (Exception e){
  311. resultData=ResultData.error(CodeMsg.YEWU_FAIL,"订单支付失败");
  312. e.printStackTrace();
  313. }
  314. }
  315. }else {
  316. resultData = ResultData.error(CodeMsg.REQUEST_FAIL);
  317. }
  318. return gson.toJson(resultData);
  319. }
  320. //用户电子会员卡(储蓄卡)充值功能随行付回调功能
  321. @RequestMapping(value = "/getCardRechargeCallback", consumes = "application/json", method = RequestMethod.POST)
  322. @ResponseBody
  323. @Transactional
  324. public void getCardRechargeCallback(@RequestBody JSONObject request){
  325. logger.info("=========================电子会员卡(储蓄卡)充值功能随行付回调功能===============================");
  326. logger.info("电子会员卡(储蓄卡)充值功能随行付回调返回过来的参数:"+request);
  327. //logger.info("ordNo信息:" + request.get("ordNo").toString());
  328. //logger.info("sign信息:" + request.get("sign").toString());
  329. Gson gson =new Gson();
  330. String sxfUuid=request.get("sxfUuid").toString(); //随行付落单号
  331. String payWay=request.get("payWay").toString(); //随行付交易方式
  332. String payTime=request.get("payTime").toString(); //随行付交易时间
  333. String uuid=request.get("uuid").toString(); //随行付交易流水号
  334. String mno=request.get("mno").toString();//发起交易的商户编号
  335. String ordNo=request.get("ordNo").toString();//商户生成的订单号
  336. String amt=request.get("amt").toString();//金额
  337. String buyerId=request.get("buyerId").toString();//用户登录
  338. String transactionId=request.get("transactionId").toString();//用户登录
  339. String drType=request.get("drType").toString();//借贷记标识 1-借,2-贷,3-其他
  340. String payType=request.get("payType").toString();//对订单的描述,取值范围:WECHAT:微信,ALIPAY:支付宝,UNIONPAY:
  341. String payBank=request.get("payBank").toString();//付款银行银行编码,例如 ICBC
  342. String pointAmount=request.get("pointAmount").toString();//代金券金额
  343. String totalOffstAmt=request.get("totalOffstAmt").toString();//消 费 者 付 款金额
  344. String settleAmt=request.get("settleAmt").toString();//商家入账金额
  345. String timeStamp=request.get("timeStamp").toString();//响应时间
  346. String sign=request.get("sign").toString();//签名
  347. String bizCode=request.get("bizCode").toString();//业务返回码
  348. String bizMsg=request.get("bizMsg").toString();//业 务 返 回 信息
  349. String openid=request.get("openid").toString();//微 信 或 支 付宝身份id()opendid userid
  350. String channelId=request.get("channelId").toString();//渠道商户号
  351. String subMechId=request.get("subMechId").toString();//子商户号
  352. String finishTime=request.get("finishTime").toString();//交易完成时间
  353. String clearDt=request.get("clearDt").toString();
  354. String settlementBatchNo=request.get("settlementBatchNo").toString();
  355. //String origOrdNo=request.get("origOrdNo").toString();//反交易退款异步通知
  356. //String origUuid=request.get("origUuid").toString();//token
  357. //String scene=request.get("scene").toString();//用户登录
  358. //String buyerAccount=request.get("buyerAccount").toString();//
  359. //String realRefundAmount=request.get("realRefundAmount").toString();//商家出账金额
  360. //String recFeeAmt=request.get("recFeeAmt").toString();//交易手续费
  361. //String recFeeRate=request.get("recFeeRate").toString();//交易手续费率
  362. //String refBuyerAmt=request.get("refBuyerAmt").toString();//消 费 者 到 账金额
  363. //String extend = extend=request.get("extend").toString();//备用
  364. //将业务参数存放在 JSON 对象中
  365. JSONObject reqData = new JSONObject();
  366. //备用
  367. if(request.containsKey("extend") && request.get("extend") !=null){
  368. String extend = request.get("extend").toString();
  369. reqData.put("extend", extend);
  370. }
  371. //优惠券参数
  372. if(request.containsKey("promotionDetail") && request.get("promotionDetail") !=null){
  373. String promotionDetail = request.get("promotionDetail").toString();
  374. reqData.put("promotionDetail", promotionDetail);
  375. }
  376. //商家出账金额
  377. if(request.containsKey("realRefundAmount") && request.get("realRefundAmount") !=null){
  378. String realRefundAmount = request.get("realRefundAmount").toString();
  379. reqData.put("realRefundAmount", realRefundAmount);
  380. }
  381. //szltFlag
  382. if(request.containsKey("szltFlag") && request.get("szltFlag") !=null){
  383. String szltFlag = request.get("szltFlag").toString();
  384. reqData.put("szltFlag", szltFlag);
  385. }
  386. //recFeeAmt
  387. if(request.containsKey("recFeeAmt") && request.get("recFeeAmt") !=null){
  388. String recFeeAmt = request.get("recFeeAmt").toString();
  389. reqData.put("recFeeAmt", recFeeAmt);
  390. }
  391. //szltRecfeeAmt
  392. if(request.containsKey("szltRecfeeAmt") && request.get("szltRecfeeAmt") !=null){
  393. String szltRecfeeAmt = request.get("szltRecfeeAmt").toString();
  394. reqData.put("szltRecfeeAmt", szltRecfeeAmt);
  395. }
  396. reqData.put("sxfUuid",sxfUuid);
  397. reqData.put("payWay",payWay);
  398. reqData.put("payTime",payTime);
  399. reqData.put("uuid",uuid);
  400. reqData.put("mno",mno);
  401. reqData.put("ordNo",ordNo);
  402. reqData.put("amt",amt);
  403. reqData.put("buyerId",buyerId);
  404. reqData.put("transactionId",transactionId);
  405. reqData.put("drType",drType);
  406. reqData.put("payType",payType);
  407. reqData.put("payBank",payBank);
  408. reqData.put("pointAmount",pointAmount);
  409. reqData.put("totalOffstAmt",totalOffstAmt);
  410. reqData.put("settleAmt",settleAmt);
  411. reqData.put("timeStamp",timeStamp);
  412. reqData.put("bizCode",bizCode);
  413. reqData.put("bizMsg",bizMsg);
  414. reqData.put("openid",openid);
  415. reqData.put("channelId",channelId);
  416. reqData.put("subMechId",subMechId);
  417. reqData.put("finishTime",finishTime);
  418. reqData.put("clearDt",clearDt);
  419. reqData.put("settlementBatchNo",settlementBatchNo);
  420. //reqData.put("realRefundAmount",realRefundAmount);
  421. //reqData.put("recFeeAmt",recFeeAmt);
  422. //reqData.put("recFeeRate",recFeeRate);
  423. //reqData.put("buyerAccount",buyerAccount);
  424. //reqData.put("origOrdNo",origOrdNo);
  425. //reqData.put("origUuid",origUuid);
  426. //reqData.put("scene",scene);
  427. //reqData.put("refBuyerAmt",refBuyerAmt);
  428. //reqData.put("extend",extend);
  429. //根据回调信息,先进行验签,验签后修改状态
  430. logger.info("打印参数信息"+gson.toJson(reqData));
  431. //不要对reqData排序 所以用LinkedHashMap
  432. HashMap<String, Object> result = JSON.parseObject(gson.toJson(reqData), LinkedHashMap.class, Feature.OrderedField);
  433. //验签
  434. String resultStr = RSASignature.getOrderContent(result);
  435. //JSONObject req = new JSONObject();
  436. System.out.println(resultStr);
  437. if (RSASignature.doCheck(resultStr, sign, SXFPaySign.sxfPublic)) {
  438. logger.info("验签成功");
  439. //随行付回调验签成功更新客户电子卡余额 和 更新客户充值记录状态
  440. CustomerCardUseRecord customerCardUseRecord = new CustomerCardUseRecord();
  441. customerCardUseRecord.setOrderNo(ordNo);
  442. CustomerCardUseRecord customerCardUseRecordInfo = electronicMembershipCardService.getCardRecordByOrderNo(customerCardUseRecord);
  443. // 0表示未支付 1表示已支付
  444. if(customerCardUseRecordInfo !=null && customerCardUseRecordInfo.getStatus().equals("0")){
  445. logger.info("充值单号:" + ordNo);
  446. CustomerElectronicCard customerElectronicCard = new CustomerElectronicCard();
  447. customerElectronicCard.setUnionId(customerCardUseRecord.getUnionId());
  448. customerCardUseRecord.setStationId(customerCardUseRecordInfo.getStationId());
  449. //是否有赠送金额
  450. BigDecimal presentAmt =new BigDecimal(0);
  451. if(customerCardUseRecordInfo.getPresentAmt() !=null){
  452. presentAmt = customerCardUseRecordInfo.getPresentAmt(); //客户充值赠送金额
  453. customerElectronicCard.setAmt(new BigDecimal(amt).add(presentAmt));
  454. }else {
  455. customerElectronicCard.setAmt(new BigDecimal(amt));
  456. }
  457. customerElectronicCard.setRecentlyTime(new Date());
  458. customerElectronicCard.setCardOilsType(customerCardUseRecordInfo.getCardOilsType());
  459. electronicMembershipCardService.updateElectronicCardInfoByUnionId(customerElectronicCard);
  460. customerCardUseRecord.setStatus("1");
  461. customerCardUseRecord.setBalance(customerElectronicCard.getAmt());
  462. electronicMembershipCardService.updateCardRecordStatusByOrderNo(customerCardUseRecord);
  463. logger.info("=====================电子会员卡充值成功=============================");
  464. customerCardUseRecord.setUnionId(customerCardUseRecordInfo.getUnionId());
  465. CustomerElectronicCard electronicCardInfo = electronicMembershipCardService.getElectronicCardInfo(customerElectronicCard);
  466. if(electronicCardInfo !=null && electronicCardInfo.getBlogOpenid() !=null){
  467. String stationName = electronicCardInfo.getStationName();
  468. String blogOpenid = electronicCardInfo.getBlogOpenid();
  469. Integer stationId = electronicCardInfo.getStationId(); //油站ID
  470. String customerName = electronicCardInfo.getCustomerName(); //客户名称
  471. BigDecimal balance = electronicCardInfo.getAmt(); //当前余额
  472. String customerNo = electronicCardInfo.getCustomerNo(); //电子卡号
  473. //获取要推送充值成功模板的ID
  474. GzhNewsTemplate gzhNewsTemplate = new GzhNewsTemplate();
  475. gzhNewsTemplate.setTemplateType("3"); //3 代表电子会员卡充值成功模板类型
  476. gzhNewsTemplate.setStationId(stationId);
  477. GzhNewsTemplate gzhNewsTemplateInfo = gzhNewsTemplateService.getGzhNewsTemplate(gzhNewsTemplate);
  478. if(gzhNewsTemplateInfo !=null && gzhNewsTemplateInfo.getTemplateId() !=null){
  479. List<WxMpTemplateData> wxMpTemplate = new ArrayList<>();
  480. wxMpTemplate.add(new WxMpTemplateData("first","尊敬的"+customerName+",您好:\n" + "您在"+stationName+"的电子会员卡充值成功信息如下"));
  481. wxMpTemplate.add(new WxMpTemplateData("keyword1", customerNo));
  482. wxMpTemplate.add(new WxMpTemplateData("keyword2", amt));
  483. wxMpTemplate.add(new WxMpTemplateData("keyword3", presentAmt.toString()));
  484. wxMpTemplate.add(new WxMpTemplateData("keyword4", balance.toString()));
  485. wxMpTemplate.add(new WxMpTemplateData("keyword5", new SimpleDateFormat("yyyy年MM月dd日HH时mm分").format(new Date())));
  486. wxMpTemplate.add(new WxMpTemplateData("remark","感谢您在"+ stationName+"的本次充值!"));
  487. Map<String, String> m = stationService.getStationAppIdAndAppSecret(stationId);
  488. if(m !=null && m.containsKey("gzhAppId") && m.containsKey("gzhAppSecret")){
  489. String gzhAppId = m.get("gzhAppId");
  490. String gzhAppSecret = m.get("gzhAppSecret");
  491. wxPushUtil.push(gzhAppId, gzhAppSecret, gzhNewsTemplateInfo.getTemplateId(), blogOpenid, wxMpTemplate);
  492. logger.info("电子会员卡公众号消息推送成功,推送人:"+ blogOpenid);
  493. }
  494. }
  495. }
  496. }
  497. }else {
  498. logger.info("验签失败");
  499. }
  500. }
  501. //获取用户电子会员卡(储蓄卡)充值记录
  502. @RequestMapping(value = "/getCardRechargeRecord", method = RequestMethod.GET)
  503. @ResponseBody
  504. public String getCardRechargeRecord(@RequestParam Integer stationId, String unionId){
  505. Gson gson =new Gson();
  506. //返回结果集
  507. ResultData resultData = null;
  508. if(stationId !=null && unionId !=null){
  509. CustomerCardUseRecord customerCardUseRecord = new CustomerCardUseRecord();
  510. customerCardUseRecord.setUsageType("+"); // '+' 代表充值
  511. customerCardUseRecord.setStationId(stationId);
  512. customerCardUseRecord.setUnionId(unionId);
  513. List<CustomerCardUseRecord> cardUseRecordList = electronicMembershipCardService.getCardUseRecordList(customerCardUseRecord);
  514. resultData = ResultData.success(cardUseRecordList);
  515. }else {
  516. resultData = ResultData.error(CodeMsg.REQUEST_FAIL);
  517. }
  518. return gson.toJson(resultData);
  519. }
  520. //获取用户电子会员卡(储蓄卡)消费记录
  521. @RequestMapping(value = "/getCardConsumptionRecord", method = RequestMethod.GET)
  522. @ResponseBody
  523. public String getCardConsumptionRecord(@RequestParam Integer stationId, String unionId){
  524. Gson gson =new Gson();
  525. //返回结果集
  526. ResultData resultData = null;
  527. if(stationId !=null && unionId !=null){
  528. CustomerCardUseRecord customerCardUseRecord = new CustomerCardUseRecord();
  529. customerCardUseRecord.setUnionId(unionId);
  530. customerCardUseRecord.setStationId(stationId);
  531. customerCardUseRecord.setUsageType("-"); // '-' 代表消费
  532. List<CustomerCardUseRecord> cardUseRecordList = electronicMembershipCardService.getCardUseRecordList(customerCardUseRecord);
  533. resultData = ResultData.success(cardUseRecordList);
  534. }else {
  535. resultData = ResultData.error(CodeMsg.REQUEST_FAIL);
  536. }
  537. return gson.toJson(resultData);
  538. }
  539. //查询油站电子会员卡(储蓄卡)充值设置规则
  540. @RequestMapping(value = "/getCardRechargeSettingList", method = RequestMethod.GET)
  541. @ResponseBody
  542. public String getCardRechargeSettingList(@RequestParam Integer stationId){
  543. Gson gson =new Gson();
  544. //返回结果集
  545. ResultData resultData = null;
  546. if(stationId !=null){
  547. CustomerCardSetting customerCardSetting = new CustomerCardSetting();
  548. customerCardSetting.setStationId(stationId);
  549. //customerCardSetting.setCardOilsType(cardOilsType);
  550. customerCardSetting.setOrderBy("ASC"); //优惠规则升序排序
  551. List<CustomerCardSetting> cardRechargeSettingList = electronicMembershipCardService.getCardRechargeSettingList(customerCardSetting);
  552. resultData = ResultData.success(cardRechargeSettingList);
  553. }else {
  554. resultData = ResultData.error(CodeMsg.REQUEST_FAIL);
  555. }
  556. return gson.toJson(resultData);
  557. }
  558. }