From 275b6c4986343c3e4230e1ad28ce9548b017d584 Mon Sep 17 00:00:00 2001
From: doum <doum>
Date: 星期四, 05 二月 2026 14:06:07 +0800
Subject: [PATCH] 代码初始化
---
server/services/src/main/java/com/doumee/service/business/impl/OrdersServiceImpl.java | 275 +++++++++++++++++++++++++++++++++++++++++++++++++++---
1 files changed, 258 insertions(+), 17 deletions(-)
diff --git a/server/services/src/main/java/com/doumee/service/business/impl/OrdersServiceImpl.java b/server/services/src/main/java/com/doumee/service/business/impl/OrdersServiceImpl.java
index beb566a..9f9db40 100644
--- a/server/services/src/main/java/com/doumee/service/business/impl/OrdersServiceImpl.java
+++ b/server/services/src/main/java/com/doumee/service/business/impl/OrdersServiceImpl.java
@@ -5,6 +5,8 @@
import com.alibaba.fastjson.TypeReference;
import com.allinpay.syb.lib.SybConstants;
import com.allinpay.syb.lib.SybUtil;
+import com.allinpay.syb.model.PayPublicModel;
+import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.doumee.biz.system.SystemDictDataBiz;
import com.doumee.core.constants.Constants;
import com.doumee.core.constants.ResponseStatus;
@@ -12,20 +14,23 @@
import com.doumee.core.model.PageData;
import com.doumee.core.model.PageWrap;
import com.doumee.core.utils.DateUtil;
-import com.doumee.dao.business.dto.PayOrderNotifyParam;
-import com.doumee.dao.business.dto.PayOrderParam;
-import com.doumee.dao.business.dto.PayOrderResponse;
+import com.doumee.core.utils.HttpsUtil;
+import com.allinpay.syb.model.PayOrderNotifyParam;
+import com.allinpay.syb.model.PayOrderParam;
+import com.allinpay.syb.model.PayOrderResponse;
import com.doumee.dao.business.model.Orders;
import com.doumee.core.utils.Utils;
import com.doumee.dao.business.OrdersMapper;
import com.doumee.dao.system.SystemUserMapper;
import com.doumee.dao.system.model.SystemUser;
+import com.doumee.dao.vo.IndexOrderCountVO;
import com.doumee.service.business.OrdersService;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.github.yulichang.wrapper.MPJLambdaWrapper;
+import io.swagger.models.auth.In;
import lombok.extern.slf4j.Slf4j;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
@@ -37,6 +42,7 @@
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.math.BigDecimal;
+import java.net.URLEncoder;
import java.util.*;
/**
@@ -95,14 +101,21 @@
param.setCusid(systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.PAY_SYB_CUSID).getCode());
param.setVersion(systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.PAY_VERSION).getCode());
param.setCharset("utf-8");
- param.setTrxamt("1");//鍗曚綅鍒�
+ param.setTrxamt(orders.getMoney().intValue()+"");//鍗曚綅鍒�
param.setRandomstr(UUID.randomUUID().toString().replace("-",""));
param.setReqsn(""+orders.getId());
param.setReturl(systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.PAY_RETURN_URL).getCode());
param.setNotify_url( systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.PAY_NOTIFY_URL).getCode());
- param.setBody(StringUtils.defaultString(orders.getName(),"") +"-"
- + StringUtils.defaultString(orders.getPhone(),"")+ "-"
- +StringUtils.defaultString(orders.getRemark(),""));
+ String remark = (Constants.equalsInteger(orders.getType(),Constants.ZERO)?"杞︽":"寤舵湡娆�")
+ +"-"+ StringUtils.defaultString(orders.getName(),"") +"-"
+ + StringUtils.defaultString(orders.getPhone(),"");
+ if(StringUtils.isNotBlank(orders.getRemark())){
+ remark += "-"+StringUtils.defaultString(orders.getRemark(),"");
+ }
+ if(remark.length()>300){
+ remark = remark.substring(0,300);
+ }
+ param.setBody(remark);
param.setValidtime( systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.PAY_VALID_TIME).getCode());
param.setSigntype( systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.PAY_SIGN_TYPE).getCode());
@@ -218,7 +231,7 @@
queryWrapper.eq(pageWrap.getModel().getPayMethod() != null,Orders::getPayMethod, pageWrap.getModel().getPayMethod());
queryWrapper.eq(pageWrap.getModel().getPayOrderId() != null,Orders::getPayOrderId, pageWrap.getModel().getPayOrderId());
queryWrapper.ge(pageWrap.getModel().getStarttime()!=null,Orders::getCreateTime , pageWrap.getModel().getStarttime());
- queryWrapper.ne(pageWrap.getModel().getEndtime()!=null,Orders::getCreateTime , pageWrap.getModel().getEndtime());
+ queryWrapper.le(pageWrap.getModel().getEndtime()!=null,Orders::getCreateTime , pageWrap.getModel().getEndtime());
queryWrapper.eq(pageWrap.getModel().getCancelWay() != null,Orders::getCancelWay, pageWrap.getModel().getCancelWay());
queryWrapper.eq(pageWrap.getModel().getCancelInfo() != null,Orders::getCancelInfo, pageWrap.getModel().getCancelInfo());
queryWrapper.eq(pageWrap.getModel().getCancelUserId() != null,Orders::getCancelUserId, pageWrap.getModel().getCancelUserId());
@@ -227,6 +240,107 @@
queryWrapper.orderByDesc(Orders::getId);
return PageData.from(ordersMapper.selectJoinPage(page,Orders.class, queryWrapper));
}
+ @Override
+ public IndexOrderCountVO getIndexData(Orders pageWrap) {
+ IndexOrderCountVO data = initIndexOrderCountMoel();
+ List<Orders> list = ordersMapper.selectList(new QueryWrapper<Orders>()
+ .select("status,type,count(id) as num,sum(money) as money")
+ .lambda()
+ .eq(Orders::getDeleted,Constants.ZERO )
+ .apply("to_days(create_time) =to_days(now())")
+ .groupBy(Orders::getType,Orders::getStatus));//鎸夌被鍨嬪拰鐘舵�佸垎缁�
+ if(list!=null){
+ for(Orders model:list){
+ data.setTodayNum(data.getTodayNum()+Constants.formatLongNum(model.getNum()));
+ data.setTodayMoney(data.getTodayMoney().add(Constants.formatBigDecimal(model.getMoney())));
+ if(Constants.equalsInteger(model.getType(),Constants.ONE)){
+ data.setTodayNum1(data.getTodayNum1()+Constants.formatLongNum(model.getNum()));
+ data.setTodayMoney1(data.getTodayMoney1().add(Constants.formatBigDecimal(model.getMoney())));
+ //寤舵湡娆�
+ if(Constants.equalsInteger(model.getStatus(),Constants.ONE)){
+ //浜ゆ槗鎴愬姛
+ data.setTodayDoneNum(data.getTodayDoneNum()+Constants.formatLongNum(model.getNum()));
+ data.setTodayDoneMoney(data.getTodayDoneMoney().add(Constants.formatBigDecimal(model.getMoney())));
+ data.setTodayDoneNum1(data.getTodayDoneNum1()+Constants.formatLongNum(model.getNum()));
+ data.setTodayDoneMoney1(data.getTodayDoneMoney1().add(Constants.formatBigDecimal(model.getMoney())));
+ }else if(Constants.equalsInteger(model.getStatus(),Constants.ZERO)){
+ //浜ゆ槗涓�
+ data.setTodayWaitNum(data.getTodayWaitNum()+Constants.formatLongNum(model.getNum()));
+ data.setTodayWaitMoney(data.getTodayWaitMoney().add(Constants.formatBigDecimal(model.getMoney())));
+ data.setTodayWaitNum1(data.getTodayWaitNum1()+Constants.formatLongNum(model.getNum()));
+ data.setTodayWaitMoney1(data.getTodayWaitMoney1().add(Constants.formatBigDecimal(model.getMoney())));
+ }else {
+ //浜ゆ槗澶辫触
+ data.setTodayFailNum1(data.getTodayFailNum1()+Constants.formatLongNum(model.getNum()));
+ data.setTodayFailMoney1(data.getTodayFailMoney1().add(Constants.formatBigDecimal(model.getMoney())));
+ data.setTodayFailNum(data.getTodayFailNum()+Constants.formatLongNum(model.getNum()));
+ data.setTodayFailMoney(data.getTodayFailMoney().add(Constants.formatBigDecimal(model.getMoney())));
+ }
+ }else{
+ //杞︽
+ data.setTodayNum0(data.getTodayNum0()+Constants.formatLongNum(model.getNum()));
+ data.setTodayMoney0(data.getTodayMoney0().add(Constants.formatBigDecimal(model.getMoney())));
+ //寤舵湡娆�
+ if(Constants.equalsInteger(model.getStatus(),Constants.ONE)){
+ //浜ゆ槗鎴愬姛
+ data.setTodayDoneNum(data.getTodayDoneNum()+Constants.formatLongNum(model.getNum()));
+ data.setTodayDoneMoney(data.getTodayDoneMoney().add(Constants.formatBigDecimal(model.getMoney())));
+ data.setTodayDoneNum0(data.getTodayDoneNum0()+Constants.formatLongNum(model.getNum()));
+ data.setTodayDoneMoney0(data.getTodayDoneMoney0().add(Constants.formatBigDecimal(model.getMoney())));
+ }else if(Constants.equalsInteger(model.getStatus(),Constants.ZERO)){
+ //浜ゆ槗涓�
+ data.setTodayWaitNum(data.getTodayWaitNum()+Constants.formatLongNum(model.getNum()));
+ data.setTodayWaitMoney(data.getTodayWaitMoney().add(Constants.formatBigDecimal(model.getMoney())));
+ data.setTodayWaitNum0(data.getTodayWaitNum0()+Constants.formatLongNum(model.getNum()));
+ data.setTodayWaitMoney0(data.getTodayWaitMoney0().add(Constants.formatBigDecimal(model.getMoney())));
+ }else {
+ //浜ゆ槗澶辫触
+ data.setTodayFailNum(data.getTodayFailNum()+Constants.formatLongNum(model.getNum()));
+ data.setTodayFailMoney(data.getTodayFailMoney().add(Constants.formatBigDecimal(model.getMoney())));
+ data.setTodayFailNum0(data.getTodayFailNum0()+Constants.formatLongNum(model.getNum()));
+ data.setTodayFailMoney0(data.getTodayFailMoney0().add(Constants.formatBigDecimal(model.getMoney())));
+ }
+ }
+ }
+ }
+
+ return data;
+ }
+
+ private IndexOrderCountVO initIndexOrderCountMoel() {
+ IndexOrderCountVO data = new IndexOrderCountVO();
+ data.setTodayMoney(new BigDecimal(0));
+ data.setTodayMoney0(new BigDecimal(0));
+ data.setTodayMoney1(new BigDecimal(0));
+ data.setTodayNum(0l);
+ data.setTodayNum0(0l);
+ data.setTodayNum1(0l);
+
+ data.setTodayDoneMoney(new BigDecimal(0));
+ data.setTodayDoneMoney0(new BigDecimal(0));
+ data.setTodayDoneMoney1(new BigDecimal(0));
+ data.setTodayDoneNum(0l);
+ data.setTodayDoneNum0(0l);
+ data.setTodayDoneNum1(0l);
+
+ data.setTodayWaitMoney(new BigDecimal(0));
+ data.setTodayWaitMoney0(new BigDecimal(0));
+ data.setTodayWaitMoney1(new BigDecimal(0));
+ data.setTodayWaitNum(0l);
+ data.setTodayWaitNum0(0l);
+ data.setTodayWaitNum1(0l);
+
+ data.setTodayFailMoney(new BigDecimal(0));
+ data.setTodayFailMoney0(new BigDecimal(0));
+ data.setTodayFailMoney1(new BigDecimal(0));
+ data.setTodayFailNum(0l);
+ data.setTodayFailNum0(0l);
+ data.setTodayFailNum1(0l);
+
+ return data;
+
+ }
+
@Override
public long count(Orders orders) {
QueryWrapper<Orders> wrapper = new QueryWrapper<>(orders);
@@ -238,17 +352,142 @@
try {
time = Integer.parseInt(systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.PAY_VALID_TIME).getCode());
}catch (Exception e){
-
}
- Date date = new Date();
- ordersMapper.update(null,new UpdateWrapper<Orders>().lambda()
- .set(Orders::getStatus,Constants.TWO)
- .set(Orders::getCancelInfo,"瓒呮椂鏈敮浠橈紝鑷姩鍙栨秷")
- .set(Orders::getCancelWay,Constants.ZERO)
- .set(Orders::getCancelDate,date)
- .set(Orders::getUpdateTime,date)
+ List<Orders> orderList = ordersMapper.selectList(new QueryWrapper<Orders>().lambda()
.eq(Orders::getStatus,Constants.ZERO)
.apply("TIMESTAMPDIFF(MINUTE, create_time ,now()) > "+time));
+ if(orderList !=null && orderList.size()>0){
+ PayPublicModel publicModel = initPayPublicModel();
+ Date date = new Date();
+ for(Orders model : orderList){
+ queryPayOrderDetailBiz(model,publicModel,date,time);
+ }
+ }
+ }
+ @Override
+ public void updateByPayStatus(Orders param) {
+ int time = 30;
+ try {
+ time = Integer.parseInt(systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.PAY_VALID_TIME).getCode());
+ }catch (Exception e){
+ }
+ Orders model = ordersMapper.selectById(param.getId());
+ if(model !=null ){
+ PayPublicModel publicModel = initPayPublicModel();
+ Date date = new Date();
+ queryPayOrderDetailBiz(model,publicModel,date,time);
+ }
+ }
+
+ private void queryPayOrderDetailBiz(Orders model, PayPublicModel publicModel, Date date,int time) {
+ TreeMap<String,String> params = new TreeMap<String,String>();
+ params.put("cusid",publicModel.getCusid());
+ params.put("appid",publicModel.getAppid());
+ params.put("version",publicModel.getVersion());
+ params.put("trxid", "");
+ params.put("randomstr", SybUtil.getValidatecode(8));
+ params.put("signtype", publicModel.getSigntype());
+ String appkey = publicModel.getAppkey();
+ String url = publicModel.getUrl();
+ String appPubkey = publicModel.getAppPubkey();
+ params.remove("sign");
+ params.put("reqsn", model.getId()+"");
+ PayOrderNotifyParam map = query(params,url,appkey,appPubkey);
+ int status = Constants.TWO;
+ if(map!=null){
+ String info = SybUtil.getPayInfoByStatus(map);
+ if(StringUtils.equals(map.getTrxcode(),"VSP501")
+ ||StringUtils.equals(map.getTrxcode(),"VSP511")
+ ||StringUtils.equals(map.getTrxcode(),"VSP551")){
+ //浜ゆ槗绫诲瀷鏄� 寰俊鏀粯 銆佹敮浠樺疂鏀粯鎴栬�呴摱鑱旀壂鐮佹敮浠橈紝璁板綍鏀粯鐘舵��
+ if(StringUtils.equals(map.getTrxstatus(),"0000")){
+ //浜ゆ槗鎴愬姛
+ model.setPayStatus(Constants.ONE);
+ status = Constants.ONE;
+ } else if (StringUtils.equals(map.getTrxstatus(),"2000") || StringUtils.equals(map.getTrxstatus(),"2008")) {
+ //濡傛灉浜ゆ槗鏈敮浠橈紝骞朵笖鏈秴杩囧崐灏忔椂锛屼笉澶勭悊
+ if(date.getTime() - model.getCreateTime().getTime() < 30*60*1000){
+ return;
+ }
+ }
+ }
+ model.setPayFee(map.getFee());
+ model.setStatus(status);
+ model.setPayDate(DateUtil.fromStringToDate("yyyyMMddHHmmss",map.getPaytime()));
+ model.setPayOrderId(map.getSrctrxid());//閫氳仈璁㈠崟鍙�
+ model.setPayThirdOrderId(map.getChnltrxid());//鏀粯瀹濆井淇¤鍗曞彿
+ model.setPayThirdOrderData(map.getChnldata());//涓夋柟浜ゆ槗娓犻亾鏁版嵁
+ model.setPayInfo(info);
+ model.setPayCode(map.getTrxcode());
+ }else{
+ model.setCancelDate(date);
+ model.setCancelInfo("瓒呮椂鏈敮浠橈紝鑷姩鍙栨秷");
+ model.setCancelWay(Constants.ZERO);
+ model.setStatus(Constants.TWO);
+ }
+ model.setUpdateTime(date);
+ ordersMapper.updateById(model) ;
+ }
+
+ private PayPublicModel initPayPublicModel() {
+ PayPublicModel model = new PayPublicModel();
+ model.setUrl(systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.PAY_SYB_CUSID).getCode());
+ model.setCusid( systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.PAY_SYB_CUSID).getCode());
+ model.setAppid(systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.PAY_SYB_APPID).getCode());
+ model.setVersion(systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.PAY_VERSION).getCode());
+ model.setSigntype( systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.PAY_SIGN_TYPE).getCode());
+ model.setAppkey(systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.PAY_APPKEY).getCode());
+ model.setUrl(systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.PAY_SYB_APIURL).getCode());
+ model.setAppPubkey( systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.PAY_SYB_RSATLPUBKEY).getCode());
+ return model;
+ }
+
+ public PayOrderNotifyParam query( TreeMap<String,String> params,String url,String appkey,String pubKey ) {
+ try {
+ params.put("sign", SybUtil.unionSign(params,appkey,SybConstants.SIGN_TYPE));
+ String data =getHttpParamsStr(params);
+ log.error("璁㈠崟鏌ヨ鏁版嵁璇锋眰================{}",data);
+ String result = HttpsUtil.post(url+"/tranx/query",data,"application/x-www-form-urlencoded",true);
+ log.error("璁㈠崟鏌ヨ鏁版嵁杩斿洖================{}",result);
+ PayOrderNotifyParam map = handleResult(result,pubKey,params.get("signtype"));
+ return map;
+ }catch (Exception e){
+ log.error("閫氳仈璁㈠崟鏌ヨ寮傚父================{}",e);
+ }
+ return null;
+ }
+ public String getHttpParamsStr(Map<String, String> params ) throws IOException {
+ StringBuilder outBuf = new StringBuilder();
+ boolean isNotFirst = false;
+ for (Map.Entry<String, String> entry: params.entrySet()){
+ if (isNotFirst)
+ outBuf.append('&');
+ isNotFirst = true;
+ outBuf
+ .append(entry.getKey())
+ .append('=')
+ .append(URLEncoder.encode(entry.getValue(), "UTF-8"));
+ }
+ System.out.println("鍙傛暟:"+outBuf.toString());
+ return outBuf.toString();
+ }
+
+ public static PayOrderNotifyParam handleResult(String result,String pubKey,String signType) throws Exception{
+ log.error("杩斿洖鏁版嵁杩斿洖================{}",result);
+ Map map = SybUtil.json2ObjMap(result);
+ if(map == null){
+ log.error("杩斿洖鏁版嵁杩斿洖閿欒================{}",result);
+ throw new Exception("杩斿洖鏁版嵁閿欒");
+ }
+ if("SUCCESS".equals(map.get("retcode"))){
+ TreeMap tmap = new TreeMap();
+ tmap.putAll(map);
+ if(SybUtil.validSign(tmap, pubKey, signType)){
+ PayOrderNotifyParam param = JSONObject.toJavaObject(JSONObject.parseObject(result),PayOrderNotifyParam.class);
+ return param;
+ }
+ }
+ return null;
}
@Override
public void returnPage(PayOrderParam param, HttpServletResponse response) throws IOException {
@@ -281,7 +520,7 @@
r ="鏀粯缁撴灉寮傚父锛岃鍗曟煡璇㈠け璐ワ紝濡傛湁鐤戦棶璇疯仈绯诲鏈嶄汉鍛�";
return;
}
- if(Constants.equalsInteger(model.getPayStatus(),Constants.ONE)){
+ if(Constants.equalsInteger(model.getPayStatus(),Constants.ONE)){
log.error("鏀粯澶勭悊======璁㈠崟宸叉敮浠�"+map.getCusorderid());
return;
}
@@ -338,4 +577,6 @@
return map;
}
+
+
}
--
Gitblit v1.9.3