xmall沙箱支付的实现

基于xmall电商添加沙箱支付

首先是修改数据库订单表
在这里插入图片描述
添加这三个字段
再编写alipayconfig

import lombok.Data;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.stereotype.Component;

import javax.annotation.PostConstruct;

/**
 * @author Administrator
 * @title: AliPayConfig
 * @projectName end
 * @description: TODO
 * @date 2022/5/218:09
 */
@Data
@Component
@ConfigurationProperties(prefix = "alipay")
public class AliPayConfig {
    private String appId;
    private String appPrivateKey;
    private String alipayPublicKey;
    private String notifyUrl;

}


编写mapper

public interface OrderMapper extends BaseMapper<Order> {

    @Update("update t_order set state=#{state},payment_time=#{paymentTime},alipay_no=#{alipayNo} where order_no=#{orderNo}")
    int updateState(@Param("orderNo") String orderNo, @Param("state") String state, @Param("paymentTime")String gmtPayment,@Param("alipayNo")String alipayTradeNo);
    @Update("update t_order set state=#{state},return_time=#{time} where order_no=#{orderNo}")
    int updateStates(@Param("orderNo") String orderNo, @Param("state") String state, @Param("time")String time);
    @Select("select * from t_order where order_no=#{traceNo}")
    Order getByNo(String traceNo);
}

再编写controller

import cn.hutool.core.date.DateUnit;
import cn.hutool.core.date.DateUtil;
import cn.hutool.json.JSONObject;
import com.alipay.api.AlipayApiException;
import com.alipay.api.AlipayClient;
import com.alipay.api.DefaultAlipayClient;
import com.alipay.api.internal.util.AlipaySignature;
import com.alipay.api.request.AlipayTradePagePayRequest;
import com.alipay.api.request.AlipayTradeRefundRequest;
import com.alipay.api.response.AlipayTradeRefundResponse;
import com.example.common.AliPayConfig;
import com.example.common.Result;
import com.example.dto.AliPay;
import com.example.entity.Order;
import com.example.mapper.OrderMapper;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.util.HashMap;
import java.util.Map;

// xjlugv6874@sandbox.com
// 9428521.24 - 30 = 9428491.24 + 30 = 9428521.24
@RestController
@RequestMapping("/api/alipay")
public class AliPayController {

    private static final String GATEWAY_URL = "https://openapi.alipaydev.com/gateway.do";
    private static final String FORMAT = "JSON";
    private static final String CHARSET = "UTF-8";
    //签名方式
    private static final String SIGN_TYPE = "RSA2";

    @Resource
    private AliPayConfig aliPayConfig;

    @Resource
    private OrderMapper orderMapper;

    @GetMapping("/pays") // &subject=xxx&traceNo=xxx&totalAmount=xxx
    public void pay(AliPay aliPay, HttpServletResponse httpResponse) throws Exception {
        // 1. 创建Client,通用SDK提供的Client,负责调用支付宝的API
        AlipayClient alipayClient = new DefaultAlipayClient(GATEWAY_URL, aliPayConfig.getAppId(),
                aliPayConfig.getAppPrivateKey(), FORMAT, CHARSET, aliPayConfig.getAlipayPublicKey(), SIGN_TYPE);

        // 2. 创建 Request并设置Request参数
        AlipayTradePagePayRequest request = new AlipayTradePagePayRequest();  // 发送请求的 Request类
        request.setNotifyUrl(aliPayConfig.getNotifyUrl());
        JSONObject bizContent = new JSONObject();
        bizContent.set("out_trade_no", aliPay.getTraceNo());  // 我们自己生成的订单编号
        bizContent.set("total_amount", aliPay.getTotalAmount()); // 订单的总金额
        bizContent.set("subject", aliPay.getSubject());   // 支付的名称
        bizContent.set("product_code", "FAST_INSTANT_TRADE_PAY");  // 固定配置
        request.setBizContent(bizContent.toString());

        // 执行请求,拿到响应的结果,返回给浏览器
        String form = "";
        try {
            form = alipayClient.pageExecute(request).getBody(); // 调用SDK生成表单
        } catch (AlipayApiException e) {
            e.printStackTrace();
        }
        httpResponse.setContentType("text/html;charset=" + CHARSET);
        httpResponse.getWriter().write(form);// 直接将完整的表单html输出到页面
        httpResponse.getWriter().flush();
        httpResponse.getWriter().close();
    }

    @PostMapping("/notify")  // 注意这里必须是POST接口
    public String payNotify(HttpServletRequest request) throws Exception {
        if (request.getParameter("trade_status").equals("TRADE_SUCCESS")) {
            System.out.println("=========支付宝异步回调========");

            Map<String, String> params = new HashMap<>();
            Map<String, String[]> requestParams = request.getParameterMap();
            for (String name : requestParams.keySet()) {
                params.put(name, request.getParameter(name));
                // System.out.println(name + " = " + request.getParameter(name));
            }

            String tradeNo = params.get("out_trade_no");
            String gmtPayment = params.get("gmt_payment");
            String alipayTradeNo = params.get("trade_no");

            String sign = params.get("sign");
            String content = AlipaySignature.getSignCheckContentV1(params);
            boolean checkSignature = AlipaySignature.rsa256CheckContent(content, sign, aliPayConfig.getAlipayPublicKey(), "UTF-8"); // 验证签名
            // 支付宝验签
            if (checkSignature) {
                // 验签通过
                System.out.println("交易名称: " + params.get("subject"));
                System.out.println("交易状态: " + params.get("trade_status"));
                System.out.println("支付宝交易凭证号: " + params.get("trade_no"));
                System.out.println("商户订单号: " + params.get("out_trade_no"));
                System.out.println("交易金额: " + params.get("total_amount"));
                System.out.println("买家在支付宝唯一id: " + params.get("buyer_id"));
                System.out.println("买家付款时间: " + params.get("gmt_payment"));
                System.out.println("买家付款金额: " + params.get("buyer_pay_amount"));

                // 更新订单未已支付
                orderMapper.updateState(tradeNo, "待发货", gmtPayment, alipayTradeNo);
            }
        }
        return "success";
    }

    @GetMapping("/return")
    public Result returnPay(AliPay aliPay) throws AlipayApiException {
        // 7天无理由退款
        String now = DateUtil.now();
        Order orders= orderMapper.getByNo(aliPay.getTraceNo());
        if (orders != null) {
            // hutool工具类,判断时间间隔
            long between = DateUtil.between(DateUtil.parseDateTime(orders.getPaymentTime()), DateUtil.parseDateTime(now), DateUnit.DAY);
            if (between > 7) {
                return Result.error("-1", "该订单已超过7天,不支持退款");
            }
        }


        // 1. 创建Client,通用SDK提供的Client,负责调用支付宝的API
        AlipayClient alipayClient = new DefaultAlipayClient(GATEWAY_URL,
                aliPayConfig.getAppId(), aliPayConfig.getAppPrivateKey(), FORMAT, CHARSET,
                aliPayConfig.getAlipayPublicKey(), SIGN_TYPE);
        // 2. 创建 Request,设置参数
        AlipayTradeRefundRequest request = new AlipayTradeRefundRequest();
        JSONObject bizContent = new JSONObject();
        bizContent.set("trade_no", aliPay.getAlipayTraceNo());  // 支付宝回调的订单流水号
        bizContent.set("refund_amount", aliPay.getTotalAmount());  // 订单的总金额
        bizContent.set("out_request_no", aliPay.getTraceNo());   //  我的订单编号


        //JSONArray queryOptions = new JSONArray();
        //queryOptions.add("refund_detail_item_list");
        //bizContent.put("query_options", queryOptions);

        request.setBizContent(bizContent.toString());

        // 3. 执行请求
        AlipayTradeRefundResponse response = alipayClient.execute(request);
        if (response.isSuccess()) {  // 退款成功,isSuccess 为true
            System.out.println("调用成功");

            // 4. 更新数据库状态
            orderMapper.updateStates(aliPay.getTraceNo(), "已退款", now);
            return Result.success();
        } else {   // 退款失败,isSuccess 为false
            System.out.println(response.getBody());
            return Result.error(response.getCode(), response.getBody());
        }

    }

}

编写实体

import lombok.Data;



@Data
public class AliPay {
    private String traceNo;
    private String alipayTraceNo;
    private String subject;
    private String totalAmount;
}

配置一下appliaction文件
如下是我的配置

alipay:
  appId: 2021000119683749
  appPrivateKey: MIIEvQIBADANBgkqhkiG9w0BAQEFAASCBKcwggSjAgEAAoIBAQCuCXu3MwNOZ4qXOGceJJmCPMzsVgS98Wj+jaH3cKabSDaWktg7SptMEnfX3FFxST/TKtICgywCZDOOI1qjSqn+JdP6y/mfbt+vkbkgD36xubFrref/VmLri6VOFMwvkOHZqMMNYFGdLzt+jekoC5nLZ2yFKLPxYgIrZu8TDNgmlPqM5M6J/V+sXq1gYnACgZEyyTAJMFFeE8XDc29+y6Pc6xVs2gTiTCBVpKsBq/sSALinfhM5tHzYyLf2OZXgwrqCnJNE2joVaVKbotAgS32f91n8PRUaaCUez6LbjZnHxohLPcbpW+6zQr5TEjWrqy1SVX1C8MoVJd98g1gaNXIzAgMBAAECggEARDlNeTyTMDogtzUSH1vjnY1uG7uAsmEfcqJc+t37QeYmGBLKlzug80pOFp20g39eeM5Rc1CugOV83Fx5nIeZahq0JZ2uZlSVdYLfmnTYip0rsvWCe7MGpiWhEKHQhVj7YFLq26SFeePZI7xHyT369SS/Atg46ggsp4z7bXFcjoqzBYxuHn+ZT240rE2sTlqrrVHt3AusaxFloI93ofzQbJ5Of36g+FZD1KUESluRpFPBLuDBTdb3cpbCEyq0f3zE8cJfNl8fs9xBa6lVPJ8JRjIYaAIKbcNhdH6brYEKd2ooAt5pL5SFzLs8W8WxdBB+x3w3/Hzbovyl1x4qVETGSQKBgQD0Vqw4Vkjp9dMK3a1qPmfHJGxuDJNYn0yGZSpeVE2iQr1wJcb4wMo3KptegqwBitAu9Y1JhJLl233c3R0lxZuIUIH+ATe8xc/MAst/5Ow5D18LI1NUZ0T02f0c6O+Hl+pHY8zyKZqMTCKHaBLK5mLAkjvg8eAno+QIuTjZoIiBBQKBgQC2V93uqxA+1nybcMwdRa4r6Ipsc3mutgLmBrxV23VsMvKskFATZ8Z8QZPllAQ/4QlIRXTyQeh4UBsg/YqR3Th4aSzHVrk3zFYzyEFHGtXHEZAUyusagzCWt0ZepXRenFk3Dw5CybkPZ8NiNDoWFYc2krs4rwrfr660I2Y4lFRr1wKBgDOon4DJvWC5uITzmVZ9GzPfX41k20JBa8x+VxbafA9yTNsJIag2GorPV0oEFpm834cOI3EHtocigNnRZfg2b0vCubkaSM6AhA5+CMhhfhAST+Xq8hNGQi4CaKFUHlBsrfup/gq1ARfogORf/JkpXHeac0571QiMfgnaH0rjxfiBAoGAO7o+ZP49nQeu20+wXGpFqfZK2Uld81+FRYmxSUJQjTeHDAVdZW3Zszvb0RiR58azvquZqfzyw+4hZMYIDM10wORamZULqH5TQjT3RO5CVimnk1gAeLe+Q7AW6cuyeYcnJgTVfAUNjEFF27YVzMQSfUrE7sVPf4PRawopYqEbohMCgYEA1etFjz8uK9AkAdCyeFkDtIknkFL1huGs1NvmTSUyiEBASZQ3fdyA0cMuW826o7tGewtS2XNw1SuNf9U4TqhYMJrruf/wQHk3hSoJjifTY/qKVqw+1qtBYdmh/Q778O+f70VEciOGZ5pgO4dLQwko3iAOorCHdprJjvPtSNWAiRs=
  alipayPublicKey: MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA7YhwigIb+jLs45Q2bWNg5aVJRWngqqggW9QMVUxaHetWaZI8dwsu4+yzZVoCb9pxPe7J4tGq6LnBi5TVY60/RkjLKWPlkJBzxu8oJDEVkACO1US940UKHCWTH4nTRuK29b+txWXO7aLcnGeLPSlTAfV6jNT7FPXNhMpqm1dDbhLtDPTpZGF2gyRtctEAdf3LZkqeyC6C9XTz7Up+U3KyF3K0zGO63ypuKwlwy20Fkk9iao7jzXxZpVrvzouG5BXVp4cJMRPHz4AOFdmfLSMEhn90QpYXBracY+QrR9DKtWBWu2o16qtN9NnhMNJgNwVRU+KLYpcQRPfSjb9YfCGHyQIDAQAB
  notifyUrl: http://d7bfjr.natappfree.cc/api/alipay/notify

最后修改一下前端

在订单全部那个注解位置添加。
在这里插入图片描述

<el-button type="warming" @click="pays(scope.row)" v-if="scope.row.state === '待付款'">支付</el-button>
<el-button type="warming" @click="returnPay(scope.row)" v-if="scope.row.state === '待发货'">退货</el-button>

加上这一句,前端才能拿到支付宝订单编号,实现退货。
在这里插入图片描述

添加前端方法`

 pays(row) {
    
      const url = `http://localhost:9999/api/alipay/pays?subject=${row.linkUser}&traceNo=${row.orderNo}&totalAmount=${row.totalPrice}`
      window.open(url);  //  得到一个url,这个url就是支付宝支付的界面url, 新窗口打开这个url就可以了
      this.load()
    },
    returnPay(row) {

      const url = `http://localhost:9999/api/alipay/return?totalAmount=${row.totalPrice}&alipayTraceNo=${row.alipayNo}&traceNo=${row.orderNo}`
      API.get(url).then(res => {
        if(res.code === '0') {
          this.$message.success("退款成功")
        }  else {
          this.$message.error("退款失败")
        }
        this.load()
      })
    },

前端界面还有一点小bug,按钮样式还需要调整。

  • 1
    点赞
  • 3
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值