From 67f416634f95c81e618123b826e18a57ae08220d Mon Sep 17 00:00:00 2001
From: 无关风月 <443237572@qq.com>
Date: 星期二, 22 四月 2025 17:55:30 +0800
Subject: [PATCH] 11.6

---
 ruoyi-service/ruoyi-admin/src/main/java/com/ruoyi/admin/controller/FranchiseeController.java |   94 +++++++++++++++++++++++++++++++++++++++++++++-
 1 files changed, 91 insertions(+), 3 deletions(-)

diff --git a/ruoyi-service/ruoyi-admin/src/main/java/com/ruoyi/admin/controller/FranchiseeController.java b/ruoyi-service/ruoyi-admin/src/main/java/com/ruoyi/admin/controller/FranchiseeController.java
index a468954..b20e4bd 100644
--- a/ruoyi-service/ruoyi-admin/src/main/java/com/ruoyi/admin/controller/FranchiseeController.java
+++ b/ruoyi-service/ruoyi-admin/src/main/java/com/ruoyi/admin/controller/FranchiseeController.java
@@ -122,10 +122,13 @@
             @ApiImplicitParam(value = "管理员", name = "head", dataType = "String"),
             @ApiImplicitParam(value = "手机号码", name = "phone", dataType = "String"),
             @ApiImplicitParam(value = "管辖城市", name = "city", dataType = "String"),
+            @ApiImplicitParam(value = "充值/扣款起始时间", name = "date1", dataType = "String"),
+            @ApiImplicitParam(value = "充值/扣款结束时间", name = "date2", dataType = "String"),
             @ApiImplicitParam(value = "页码", name = "pageNum", dataType = "Integer", required = true),
             @ApiImplicitParam(value = "每页条数", name = "pageSize", dataType = "Integer", required = true)
     })
     public R<RencentBalance> recentmoney(String name, String head, String phone, String city,
+                                         String date1,String date2,
                                          @RequestParam(name = "pageNum", defaultValue = "1") Integer pageNum,
                                          @RequestParam(name = "pageSize", defaultValue = "10") Integer pageSize) {
         BigDecimal balance = new BigDecimal(0);
@@ -140,11 +143,11 @@
         for (Franchisee franchisee : list) {
             balance = balance.add(franchisee.getBalance());
         }
-
         //充值的金额
         BigDecimal balance1 = new BigDecimal(0);
         List<TFranchiseeBalanceChange> list1 = balanceChangeService.lambdaQuery()
                 .in(TFranchiseeBalanceChange::getFranchiseeId,collect)
+                .between(date1!=null,TFranchiseeBalanceChange::getCreateTime, date1, date2)
                 .eq(TFranchiseeBalanceChange::getType, 1).list();
         for (TFranchiseeBalanceChange franchiseeBalanceChange : list1) {
             balance1 = balance1.add(franchiseeBalanceChange.getAmount());
@@ -154,6 +157,7 @@
         List<TFranchiseeBalanceChange> list2 = balanceChangeService.lambdaQuery()
                 .in(TFranchiseeBalanceChange::getFranchiseeId,collect)
                 .eq(TFranchiseeBalanceChange::getType, 2)
+                .between(date1!=null,TFranchiseeBalanceChange::getCreateTime, date1, date2)
                 .eq(TFranchiseeBalanceChange::getIs_pay,1).list();
         for (TFranchiseeBalanceChange franchiseeBalanceChange : list2) {
             balance2 = balance2.add(franchiseeBalanceChange.getAmount());
@@ -188,6 +192,7 @@
                 .like(moneyRecentQuery.getName() != null && !"".equals(moneyRecentQuery.getName()), TFranchiseeBalanceChange::getFranchiseeName, moneyRecentQuery.getName())
                 .ge(moneyRecentQuery.getDate1() != null, TFranchiseeBalanceChange::getCreateTime, moneyRecentQuery.getDate1())
                 .le(moneyRecentQuery.getDate2() != null, TFranchiseeBalanceChange::getCreateTime, moneyRecentQuery.getDate2())
+                .eq(moneyRecentQuery.getFranchId()!=null, TFranchiseeBalanceChange::getFranchiseeId, moneyRecentQuery.getFranchId())
                 .eq(TFranchiseeBalanceChange::getIs_pay,1)
                 .orderByDesc(TFranchiseeBalanceChange::getCreateTime)
                 .page(Page.of(moneyRecentQuery.getPageNum(), moneyRecentQuery.getPageSize()));
@@ -225,6 +230,7 @@
                     .eq(moneyRecentQuery.getName() != null && !"".equals(moneyRecentQuery.getName()), TFranchiseeBalanceChange::getFranchiseeName, moneyRecentQuery.getName())
                     .ge(moneyRecentQuery.getDate1() != null, TFranchiseeBalanceChange::getCreateTime, moneyRecentQuery.getDate1())
                     .le(moneyRecentQuery.getDate2() != null, TFranchiseeBalanceChange::getCreateTime, moneyRecentQuery.getDate2())
+                    .eq(moneyRecentQuery.getFranchId()!=null, TFranchiseeBalanceChange::getFranchiseeId, moneyRecentQuery.getFranchId())
                     .eq(TFranchiseeBalanceChange::getIs_pay,1)
                     .orderByDesc(TFranchiseeBalanceChange::getCreateTime)
                     .list();
@@ -343,7 +349,7 @@
         map.put("p4_Cur", "1"); /**交易币种 */
         map.put("q5_OpenId", openId);
         map.put("p5_ProductName", "加盟商充值"); /** 商品名称 */
-        map.put("p9_NotifyUrl", "https://v7ro848ar5jx.ngrok.xiaomiqiu123.top/admin/franchisee/callBack"); /** 服务器异步通知地址 */
+        map.put("p9_NotifyUrl", "http://101.34.55.62:9100/admin/franchisee/callBack"); /** 服务器异步通知地址 */
         map.put("q1_FrpCode", "WEIXIN_APP3"); /** 交易类型*/
         map.put("q7_AppId", "wx1a4a7760be53a835"); /** 交易类型*/
         map.put("qa_TradeMerchantNo", "777165000859101"); /** 777开头的报备商户号   必填!*/
@@ -453,7 +459,89 @@
         map.put("p5_ProductName", "充值"); /** 商品名称 */
         map.put("p6_ProductDesc", "加盟商充值"); /** 商品名称 */
 //        map.put("p7_Mp", ""); /** 如果商户请求时传递了该参数,则返回给商户时会原值传 回。 */
-        map.put("p9_NotifyUrl", "https://v7ro848ar5jx.ngrok.xiaomiqiu123.top/admin/franchisee/callBack"); /** 服务器异步通知地址 */
+        map.put("p9_NotifyUrl", "http://101.34.55.62:9100/admin/franchisee/callBack"); /** 服务器异步通知地址 */
+        map.put("q1_FrpCode", "WEIXIN_NATIVE"); /** 微信扫码(主扫)【注:此为用户主扫,商户被扫】*/
+        map.put("q4_IsShowPic", "1"); /** 是否展示二 维码图片 1表示输出*/
+        map.put("q7_AppId", "wx1a4a7760be53a835"); /** 交易类型*/
+        map.put("qa_TradeMerchantNo", "777165000859101"); /** 777开头的报备商户号   必填!*/
+        map.put("qi_FqSellerPercen", "0"); /** 卖家承担收 费比例 目前仅支持传入 0 ,即用户承 担手续费!*/
+
+        String Strmap = CreateLinkStringByGet1.createLinkStringByGet(map);
+
+        // 签名
+        String sign = "";
+        sign = Md5_Sign.SignByMD5(Strmap, key);
+        map.put("hmac", sign);/** 签名数据 */
+        System.out.println("发送:" + JSON.toJSONString(map).toString());
+
+        // post请求参数内容
+        HttpRequester hr = new HttpRequester();
+        HttpRespons HP = hr.sendPost("https://trade.joinpay.com/tradeRt/uniPay", map);
+        System.out.println("接收返回参数:" + HP.getContent());
+        JSONObject jsonObject = JSONObject.parseObject(HP.getContent());
+        String rcResult = jsonObject.getString("rd_Pic");
+        Map<String, Object> map2 = new HashMap<>();
+        map2.put("rcResult", rcResult);
+//        com.wechat.pay.java.service.payments.nativepay.model.PrepayRequest prepayRequest = new com.wechat.pay.java.service.payments.nativepay.model.PrepayRequest();
+//            prepayRequest.setAppid(weChatConfig.appId);
+//            prepayRequest.setMchid(weChatConfig.merchantId);
+//            prepayRequest.setOutTradeNo(code);
+//            prepayRequest.setDescription("购买资料");
+//            prepayRequest.setNotifyUrl("http://www.zhipingwang.com.cn:9090/admin/franchisee/callBack");
+//            com.wechat.pay.java.service.payments.nativepay.model.Amount amount = new com.wechat.pay.java.service.payments.nativepay.model.Amount();
+//            amount.setTotal(i);
+//            prepayRequest.setAmount(amount);
+//            // 调用下单方法,得到应答
+//            com.wechat.pay.java.service.partnerpayments.app.model.PrepayResponse response;
+        try {
+//                com.wechat.pay.java.service.payments.nativepay.model.PrepayResponse prepay = nativePayService.prepay(prepayRequest);
+            //预支付成功,创建预支付订单
+            TFranchiseeBalanceChange tFranchiseeBalanceChange = new TFranchiseeBalanceChange();
+            tFranchiseeBalanceChange.setAmount(money);
+            tFranchiseeBalanceChange.setIs_pay(0);
+            tFranchiseeBalanceChange.setFranchiseeName(byId.getName());
+            tFranchiseeBalanceChange.setFranchiseeId(String.valueOf(byId.getId()));
+            tFranchiseeBalanceChange.setType(2);
+            tFranchiseeBalanceChange.setCode(code);
+            tFranchiseeBalanceChange.setRemark("加盟商扫码充值");
+            balanceChangeService.save(tFranchiseeBalanceChange);
+
+
+
+            PayDto payDto = new PayDto();
+            payDto.setOrderId(tFranchiseeBalanceChange.getId());
+            payDto.setQrCode(rcResult);
+
+            return R.ok(payDto);
+        } catch (HttpException e) { // 发送HTTP请求失败
+//                log.error("发送HTTP请求失败: {}", e.getHttpRequest());
+        } catch (ServiceException e) { // 服务返回状态小于200或大于等于300,例如500
+//                log.error("服务返回状态异常: {}", e.getResponseBody());
+        } catch (MalformedMessageException e) { // 服务返回成功,返回体类型不合法,或者解析返回体失败
+//                log.error("返回体类型不合法: {}", e.getMessage());
+        } catch (Exception e) {
+//                log.error("预下单异常: {}", e.getMessage());
+        }
+        return null;
+
+    }
+    @ApiOperation(value = "扫码支付",tags = {"后台2.0-总平台"})
+    @PostMapping(value = "/code/buyPlatform")
+    public R buyPlatform(@RequestParam BigDecimal money,Integer id) throws AlipayApiException, IOException {
+        Franchisee byId = franchiseeService.getById(id);
+        String code = generateTradeNumber();
+        int i = money.multiply(BigDecimal.valueOf(100)).intValue();
+        String key = "ad273ceb5e1b49e68d5c565d28d1d305";/** md5密钥商户后台-商户中心-商户设置-密钥管理获取 必填!*/
+        Map<String, String> map = new HashMap<String, String>();
+        map.put("p0_Version", "2.5");/** 版本号 */
+        map.put("p1_MerchantNo", "888122400007793");/** 商户编号 */
+        map.put("p2_OrderNo", code); /**商户订单号*/
+        map.put("p3_Amount", String.valueOf(money));/**订单金额*/
+        map.put("p4_Cur", "1"); /**交易币种 */
+        map.put("p5_ProductName", "充值"); /** 商品名称 */
+        map.put("p6_ProductDesc", "加盟商充值"); /** 商品名称 */
+//        map.put("p7_Mp", ""); /** 如果商户请求时传递了该参数,则返回给商户时会原值传 回。 */
+        map.put("p9_NotifyUrl", "http://101.34.55.62:9100/admin/franchisee/callBack"); /** 服务器异步通知地址 */
         map.put("q1_FrpCode", "WEIXIN_NATIVE"); /** 微信扫码(主扫)【注:此为用户主扫,商户被扫】*/
         map.put("q4_IsShowPic", "1"); /** 是否展示二 维码图片 1表示输出*/
         map.put("q7_AppId", "wx1a4a7760be53a835"); /** 交易类型*/

--
Gitblit v1.7.1