基于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,按钮样式还需要调整。