From b29d7b6bbe8256d5e95fb878adf06ffa9abb449a Mon Sep 17 00:00:00 2001
From: doum <doum>
Date: 星期一, 09 二月 2026 10:29:00 +0800
Subject: [PATCH] 新增退款
---
server/services/src/main/java/com/doumee/service/business/impl/OrdersServiceImpl.java | 476 ++++++++++++++++++++++++++++++++++++++++++++++++++---------
1 files changed, 402 insertions(+), 74 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 9a0bef0..9bea96e 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
@@ -3,25 +3,37 @@
import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONObject;
import com.alibaba.fastjson.TypeReference;
+import com.allinpay.syb.lib.DoumeeTLUtil;
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;
import com.doumee.core.exception.BusinessException;
import com.doumee.core.model.PageData;
import com.doumee.core.model.PageWrap;
-import com.doumee.dao.business.dto.PayOrderParam;
-import com.doumee.dao.business.dto.PayOrderResponse;
+import com.doumee.core.utils.DateUtil;
+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.RefundMapper;
import com.doumee.dao.business.model.Orders;
import com.doumee.core.utils.Utils;
import com.doumee.dao.business.OrdersMapper;
+import com.doumee.dao.business.model.Refund;
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;
@@ -29,10 +41,12 @@
import org.springframework.transaction.annotation.Transactional;
import org.springframework.util.CollectionUtils;
+import javax.servlet.http.HttpServletRequest;
+import javax.servlet.http.HttpServletResponse;
+import java.io.IOException;
import java.math.BigDecimal;
-import java.util.Date;
-import java.util.List;
-import java.util.TreeMap;
+import java.net.URLEncoder;
+import java.util.*;
/**
* 璁㈠崟璁板綍琛ㄤ俊鎭〃Service瀹炵幇
@@ -46,7 +60,11 @@
@Autowired
private OrdersMapper ordersMapper;
@Autowired
+ private RefundMapper refundMapper;
+ @Autowired
private SystemUserMapper systemUserMapper;
+ @Autowired
+ private SystemDictDataBiz systemDictDataBiz;
@Override
@Transactional
@@ -70,10 +88,12 @@
}
}
Date date = new Date();
+ orders.setMoney(orders.getMoney().multiply(new BigDecimal(100)));//鍗曚綅鍒�
orders.setCreateTime(date);
orders.setPayStatus(Constants.ZERO);
orders.setStatus(Constants.ZERO);
orders.setPayMethod(Constants.ZERO);
+ orders.setDeleted(Constants.ZERO);
ordersMapper.insert(orders);
return startPayDo(orders);
}
@@ -82,45 +102,59 @@
try {
PayOrderResponse r = new PayOrderResponse();
PayOrderParam param = new PayOrderParam();
- param.setAppid(SybConstants.SYB_APPID);
- param.setCusid(SybConstants.SYB_CUSID);
- param.setVersion(SybConstants.VERSION);
+ param.setAppid(systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.PAY_SYB_APPID).getCode());
+ 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("http://localhost:8080/#/page/success/success");
- param.setNotify_url(SybConstants.NOTFIY_URL);
- param.setNotify_url("");
- param.setBody(orders.getRemark());
- param.setValidtime( SybConstants.VALID_TIME);
- param.setSigntype(SybConstants.SIGN_TYPE);
-
- String appkey = "";
- if(SybConstants.SIGN_TYPE.equals("RSA")){
- appkey = SybConstants.SYB_RSACUSPRIKEY;
- } else if(SybConstants.SIGN_TYPE.equals("SM2")){
- appkey = SybConstants.SYB_SM2PPRIVATEKEY;
- } else{
- appkey = SybConstants.SYB_MD5_APPKEY;
+ param.setReturl(systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.PAY_RETURN_URL).getCode());
+ param.setNotify_url( systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.PAY_NOTIFY_URL).getCode());
+ 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());
+
+ String appkey = systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.PAY_APPKEY).getCode();
String sign = SybUtil.unionSign(getTreeMapByParam(param),appkey,param.getSigntype());
param.setSign( sign);
- r.setUrl(SybConstants.SYB_APIURL+"/h5unionpay/unionorder");
+ r.setUrl(systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.PAY_SYB_APIURL).getCode()+"/h5unionpay/unionorder");
r.setParam(param);
-// String r = HttpsUtil.postJson(SybConstants.SYB_APIURL+"/h5unionpay/unionorder",JSONObject.toJSONString(param));
-// log.error(param);
return r;
}catch (Exception e){
- throw new BusinessException(ResponseStatus.SERVER_ERROR.getCode(),"瀵逛笉璧凤紝鍙戣捣鏀舵璇锋眰澶辫触锛岃绋嶅悗閲嶈瘯锛�");
+ throw new BusinessException(ResponseStatus.SERVER_ERROR.getCode(),"瀵逛笉璧凤紝鍙戣捣鏀舵璇锋眰澶辫触锛岃绋嶅悗閲嶈瘯锛�");
}
}
- private TreeMap<String, String> getTreeMapByParam(PayOrderParam param) {
+ private TreeMap<String, String> getTreeMapByParam(Object param) {
+
TypeReference< TreeMap<String, String> > type = new TypeReference< TreeMap<String, String> >() { };
TreeMap<String, String> obj = JSONObject.parseObject(JSON.toJSONString(param), type.getType());
return obj;
}
-
+ private TreeMap<String, String> getTreeMapByParamStr(String paramStr) {
+ TreeMap<String, String> obj = new TreeMap<>();
+ String params[] =paramStr.split("&");
+ if(params.length ==0){
+ return obj;
+ }
+ for(String tp : params){
+ String tt[] = tp.split("=");
+ if(tt.length>=2){
+ obj.put(tt[0],tt[1]);
+ }
+ }
+ return obj;
+ }
@Override
public void deleteById(Integer id) {
@@ -176,58 +210,352 @@
@Override
public PageData<Orders> findPage(PageWrap<Orders> pageWrap) {
IPage<Orders> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity());
- QueryWrapper<Orders> queryWrapper = new QueryWrapper<>();
+ MPJLambdaWrapper<Orders> queryWrapper = new MPJLambdaWrapper<>();
+ queryWrapper.selectAll(Orders.class)
+ .select("(select sum(r.money) from refund r where r.deleted=0 and r.status in(0,1) and r.order_id=t.id)",Orders::getRefundMoney)
+ .selectAs(SystemUser::getRealname,Orders::getUserRealname)
+ .selectAs(SystemUser::getUsername,Orders::getUsername)
+ .leftJoin(SystemUser.class,SystemUser::getId,Orders::getUserId);
Utils.MP.blankToNull(pageWrap.getModel());
- queryWrapper.lambda().eq(pageWrap.getModel().getId() != null,Orders::getId, pageWrap.getModel().getId());
- queryWrapper.lambda().eq(pageWrap.getModel().getDeleted() != null,Orders::getDeleted, pageWrap.getModel().getDeleted());
- queryWrapper.lambda().eq(pageWrap.getModel().getCreateUser() != null,Orders::getCreateUser, pageWrap.getModel().getCreateUser());
- if (pageWrap.getModel().getCreateTime() != null) {
- queryWrapper.lambda().ge(Orders::getCreateTime, Utils.Date.getStart(pageWrap.getModel().getCreateTime()));
- queryWrapper.lambda().le(Orders::getCreateTime, Utils.Date.getEnd(pageWrap.getModel().getCreateTime()));
- }
- queryWrapper.lambda().eq(pageWrap.getModel().getUpdateUser() != null,Orders::getUpdateUser, pageWrap.getModel().getUpdateUser());
- if (pageWrap.getModel().getUpdateTime() != null) {
- queryWrapper.lambda().ge(Orders::getUpdateTime, Utils.Date.getStart(pageWrap.getModel().getUpdateTime()));
- queryWrapper.lambda().le(Orders::getUpdateTime, Utils.Date.getEnd(pageWrap.getModel().getUpdateTime()));
- }
- queryWrapper.lambda().eq(pageWrap.getModel().getRemark() != null,Orders::getRemark, pageWrap.getModel().getRemark());
- queryWrapper.lambda().eq(pageWrap.getModel().getStatus() != null,Orders::getStatus, pageWrap.getModel().getStatus());
- queryWrapper.lambda().eq(pageWrap.getModel().getName() != null,Orders::getName, pageWrap.getModel().getName());
- queryWrapper.lambda().eq(pageWrap.getModel().getUserId() != null,Orders::getUserId, pageWrap.getModel().getUserId());
- queryWrapper.lambda().eq(pageWrap.getModel().getDetail() != null,Orders::getDetail, pageWrap.getModel().getDetail());
- queryWrapper.lambda().eq(pageWrap.getModel().getImgurl() != null,Orders::getImgurl, pageWrap.getModel().getImgurl());
- queryWrapper.lambda().eq(pageWrap.getModel().getSortnum() != null,Orders::getSortnum, pageWrap.getModel().getSortnum());
- queryWrapper.lambda().eq(pageWrap.getModel().getType() != null,Orders::getType, pageWrap.getModel().getType());
- queryWrapper.lambda().eq(pageWrap.getModel().getBrandId() != null,Orders::getBrandId, pageWrap.getModel().getBrandId());
- queryWrapper.lambda().eq(pageWrap.getModel().getPhone() != null,Orders::getPhone, pageWrap.getModel().getPhone());
- queryWrapper.lambda().eq(pageWrap.getModel().getMoney() != null,Orders::getMoney, pageWrap.getModel().getMoney());
- queryWrapper.lambda().eq(pageWrap.getModel().getPayMethod() != null,Orders::getPayMethod, pageWrap.getModel().getPayMethod());
- queryWrapper.lambda().eq(pageWrap.getModel().getPayOrderId() != null,Orders::getPayOrderId, pageWrap.getModel().getPayOrderId());
- if (pageWrap.getModel().getUpdateTime() != null) {
- queryWrapper.lambda().ge(Orders::getPayDate, Utils.Date.getStart(pageWrap.getModel().getPayDate()));
- queryWrapper.lambda().le(Orders::getPayDate, Utils.Date.getEnd(pageWrap.getModel().getPayDate()));
- }
- if (pageWrap.getModel().getUpdateTime() != null) {
- queryWrapper.lambda().ge(Orders::getCancelDate, Utils.Date.getStart(pageWrap.getModel().getCancelDate()));
- queryWrapper.lambda().le(Orders::getCancelDate, Utils.Date.getEnd(pageWrap.getModel().getCancelDate()));
- }
- queryWrapper.lambda().eq(pageWrap.getModel().getCancelWay() != null,Orders::getCancelWay, pageWrap.getModel().getCancelWay());
- queryWrapper.lambda().eq(pageWrap.getModel().getCancelInfo() != null,Orders::getCancelInfo, pageWrap.getModel().getCancelInfo());
- queryWrapper.lambda().eq(pageWrap.getModel().getCancelUserId() != null,Orders::getCancelUserId, pageWrap.getModel().getCancelUserId());
- queryWrapper.lambda().eq(pageWrap.getModel().getCancelStatus() != null,Orders::getCancelStatus, pageWrap.getModel().getCancelStatus());
- queryWrapper.lambda().eq(pageWrap.getModel().getPayStatus() != null,Orders::getPayStatus, pageWrap.getModel().getPayStatus());
- for(PageWrap.SortData sortData: pageWrap.getSorts()) {
- if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) {
- queryWrapper.orderByDesc(sortData.getProperty());
- } else {
- queryWrapper.orderByAsc(sortData.getProperty());
+ pageWrap.getModel().setDeleted(Constants.ZERO);
+ queryWrapper.eq(pageWrap.getModel().getId() != null,Orders::getId, pageWrap.getModel().getId());
+ queryWrapper.eq(pageWrap.getModel().getDeleted() != null,Orders::getDeleted, pageWrap.getModel().getDeleted());
+ queryWrapper.eq(pageWrap.getModel().getCreateUser() != null,Orders::getCreateUser, pageWrap.getModel().getCreateUser());
+ queryWrapper.like(pageWrap.getModel().getRemark() != null,Orders::getRemark, pageWrap.getModel().getRemark());
+ queryWrapper.eq(pageWrap.getModel().getStatus() != null,Orders::getStatus, pageWrap.getModel().getStatus());
+ queryWrapper.like(pageWrap.getModel().getUsername() != null,SystemUser::getUsername, pageWrap.getModel().getUsername());
+ queryWrapper.like(pageWrap.getModel().getUserRealname() != null,SystemUser::getRealname, pageWrap.getModel().getUserRealname());
+ queryWrapper.like(pageWrap.getModel().getName() != null,Orders::getName, pageWrap.getModel().getName());
+ queryWrapper.eq(pageWrap.getModel().getUserId() != null,Orders::getUserId, pageWrap.getModel().getUserId());
+ queryWrapper.eq(pageWrap.getModel().getDetail() != null,Orders::getDetail, pageWrap.getModel().getDetail());
+ queryWrapper.eq(pageWrap.getModel().getImgurl() != null,Orders::getImgurl, pageWrap.getModel().getImgurl());
+ queryWrapper.eq(pageWrap.getModel().getSortnum() != null,Orders::getSortnum, pageWrap.getModel().getSortnum());
+ queryWrapper.eq(pageWrap.getModel().getType() != null,Orders::getType, pageWrap.getModel().getType());
+ queryWrapper.eq(pageWrap.getModel().getBrandId() != null,Orders::getBrandId, pageWrap.getModel().getBrandId());
+ queryWrapper.eq(pageWrap.getModel().getPhone() != null,Orders::getPhone, pageWrap.getModel().getPhone());
+ queryWrapper.eq(pageWrap.getModel().getMoney() != null,Orders::getMoney, pageWrap.getModel().getMoney());
+ 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.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());
+ queryWrapper.eq(pageWrap.getModel().getCancelStatus() != null,Orders::getCancelStatus, pageWrap.getModel().getCancelStatus());
+ queryWrapper.eq(pageWrap.getModel().getPayStatus() != null,Orders::getPayStatus, pageWrap.getModel().getPayStatus());
+ 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 PageData.from(ordersMapper.selectPage(page, queryWrapper));
+
+ Refund refund = refundMapper.selectJoinOne(Refund.class,new MPJLambdaWrapper<Refund>()
+ .select("count(distinct(order_id)) as orderNum,count(id) as num,sum(money) as money")
+ .eq(Orders::getDeleted,Constants.ZERO )
+ .eq(Orders::getStatus,Constants.ONE)
+ .apply("to_days(create_time) =to_days(now())")
+ .last("limit 1"));
+
+ if(refund!=null){
+ data.setTodayRefundMoney(Constants.getFormatMoney(refund.getMoney()));
+ data.setTodayRefundOrderNum(Constants.formatLongNum(refund.getOrderNum()));
+ data.setTodayRefundNum(Constants.formatLongNum(refund.getNum()));
+ }
+ 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);
+
+ data.setTodayRefundMoney(new BigDecimal(0));
+ data.setTodayRefundOrderNum(0l);
+ data.setTodayRefundNum(0l);
+
+ return data;
+
+ }
+
@Override
public long count(Orders orders) {
QueryWrapper<Orders> wrapper = new QueryWrapper<>(orders);
return ordersMapper.selectCount(wrapper);
}
+ @Override
+ public void autoCancelNoPay() {
+ int time = 30;
+ try {
+ time = Integer.parseInt(systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.PAY_VALID_TIME).getCode());
+ }catch (Exception e){
+ }
+ 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 =systemDictDataBiz.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 =systemDictDataBiz.initPayPublicModel();
+ Date date = new Date();
+ queryPayOrderDetailBiz(model,publicModel,date,time);
+ }
+ }
+
+ private void queryPayOrderDetailBiz(Orders model, PayPublicModel publicModel, Date date,int time) {
+ DoumeeTLUtil doumeeTLUtil = new DoumeeTLUtil(publicModel);
+ PayOrderNotifyParam map = doumeeTLUtil.sendQueryOrder(model.getId()+"");
+ 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() < time*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) ;
+ }
+
+
+
+ @Override
+ public void returnPage(PayOrderParam param, HttpServletResponse response) throws IOException {
+// String url =systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.PAY_RETURN_WEB_URL).getCode();
+// response.sendRedirect(url+"?reqsn="+param.getReqsn());
+ }
+ @Override
+ public void dealOrdreResult(String paramStr, HttpServletResponse response) throws IOException {
+ String r = "success";
+ try {
+ response.setCharacterEncoding("UTF-8");
+ TreeMap<String,String> params = getTreeMapByParamStr(paramStr);//鍔ㄦ�侀亶鍘嗚幏鍙栨墍鏈夋敹鍒扮殑鍙傛暟,姝ゆ闈炲父鍏抽敭,鍥犱负鏀堕摱瀹濅互鍚庡彲鑳戒細鍔犲瓧娈�,鍔ㄦ�佽幏鍙栧彲浠ュ吋瀹�
+ String appkey = systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.PAY_SYB_RSATLPUBKEY).getCode();
+ log.error("鏀粯閫氱煡鍙傛暟======"+paramStr);
+ boolean isSign = SybUtil.validSign(params, appkey, params.get("signtype"));// 鎺ュ彈鍒版帹閫侀�氱煡,棣栧厛楠岀
+ PayOrderNotifyParam map = JSONObject.toJavaObject(JSONObject.parseObject(JSONObject.toJSONString(params)),PayOrderNotifyParam.class);
+ System.out.println("楠岀缁撴灉:"+isSign);
+ if(isSign){
+ log.error("鏀粯楠岀鎴愬姛======");
+ //澶勭悊璁㈠崟鐘舵��
+ if(StringUtils.isBlank(map.getCusorderid())){
+ r ="鏀粯缁撴灉寮傚父锛屽鏈夌枒闂鑱旂郴瀹㈡湇浜哄憳";
+ return;
+ }
+ String info = SybUtil.getPayInfoByStatus(map);
+ if(StringUtils.equals(map.getTrxcode(),"VSP501")
+ ||StringUtils.equals(map.getTrxcode(),"VSP511")
+ ||StringUtils.equals(map.getTrxcode(),"VSP551")){
+ //浜ゆ槗绫诲瀷鏄� 寰俊鏀粯 銆佹敮浠樺疂鏀粯鎴栬�呴摱鑱旀壂鐮佹敮浠橈紝璁板綍鏀粯鐘舵��
+ dealOrdersResultBiz(info,map,r);
+ }else if(StringUtils.equals(map.getTrxcode(),"VSP503")
+ ||StringUtils.equals(map.getTrxcode(),"VSP513")
+ ||StringUtils.equals(map.getTrxcode(),"VSP553")){
+ //浜ゆ槗绫诲瀷鏄� 寰俊t閫�娆� 銆佹敮浠樺疂鏀粯閫�娆炬垨鑰呴摱鑱旀壂鐮侀��璐э紝璁板綍鏀粯鐘舵��
+ dealRefunResultBiz(info,map,r);//澶勭悊閫�娆�
+ }else {
+ //鍏朵粬绫诲瀷涓嶉�氱煡
+ }
+
+ }else{
+ log.error("鏀粯楠岀澶辫触======");
+ r ="鏀粯澶辫触锛屽鏈夌枒闂鑱旂郴瀹㈡湇浜哄憳";
+ }
+ //楠岀瀹屾瘯杩涜涓氬姟澶勭悊
+ } catch (Exception e) {//澶勭悊寮傚父
+ // TODO: handle exception
+ e.printStackTrace();
+ log.error("鏀粯閫氱煡澶勭悊寮傚父锛�",e.getMessage());
+ r = "error";
+ } finally{//鏀跺埌閫氱煡,杩斿洖success
+ response.getOutputStream().write(r.getBytes());
+ response.flushBuffer();
+ }
+ }
+
+ private String dealRefunResultBiz(String info, PayOrderNotifyParam map, String r) {
+ Refund model = refundMapper.selectOne(new QueryWrapper<Refund>().lambda()
+ .eq(Refund::getId,Integer.parseInt(map.getCusorderid().replace(DoumeeTLUtil.REFUND_SN_PREFIX,"")))
+ );
+ if(model ==null){
+ log.error("鏀粯澶勭悊澶辫触======鏈壘鍒颁氦鏄撹鍗�"+map.getCusorderid());
+ return "鏀粯缁撴灉寮傚父锛岃鍗曟煡璇㈠け璐ワ紝濡傛湁鐤戦棶璇疯仈绯诲鏈嶄汉鍛�";
+ }
+ if(Constants.equalsInteger(model.getStatus(),Constants.ONE)){
+ log.error("鏀粯澶勭悊======璁㈠崟宸叉敮浠�"+map.getCusorderid());
+ return "璁㈠崟宸叉敮浠�";
+ }
+ if(StringUtils.equals(map.getTrxstatus(),"0000")){
+ //浜ゆ槗鎴愬姛
+ model.setStatus(Constants.ONE);
+ }else{
+ //浜ゆ槗澶辫触
+ model.setStatus(Constants.TWO);
+ }
+ model.setPayFee(map.getFee());
+ model.setPayDate(DateUtil.fromStringToDate("yyyyMMddHHmmss",map.getPaytime()));
+ model.setPayOrderId(map.getTrxid());//閫氳仈璁㈠崟鍙�
+ model.setPayThirdOrderId(map.getChnltrxid());//鏀粯瀹濆井淇¤鍗曞彿
+ model.setPayThirdOrderData(map.getChnldata());//涓夋柟浜ゆ槗娓犻亾鏁版嵁
+ model.setPayInfo(info);
+ model.setPayCode(map.getTrxcode());
+ refundMapper.updateById(model);
+ return r;
+ }
+
+ private String dealOrdersResultBiz(String info, PayOrderNotifyParam map,String r) {
+ Orders model = ordersMapper.selectOne(new QueryWrapper<Orders>().lambda()
+ .eq(Orders::getId,Integer.parseInt(map.getCusorderid()))
+ );
+ if(model ==null){
+ log.error("鏀粯澶勭悊澶辫触======鏈壘鍒颁氦鏄撹鍗�"+map.getCusorderid());
+ return "鏀粯缁撴灉寮傚父锛岃鍗曟煡璇㈠け璐ワ紝濡傛湁鐤戦棶璇疯仈绯诲鏈嶄汉鍛�";
+ }
+ if(Constants.equalsInteger(model.getPayStatus(),Constants.ONE)){
+ log.error("鏀粯澶勭悊======璁㈠崟宸叉敮浠�"+map.getCusorderid());
+ return "璁㈠崟宸叉敮浠�";
+ }
+ if(StringUtils.equals(map.getTrxstatus(),"0000")){
+ //浜ゆ槗鎴愬姛
+ model.setPayStatus(Constants.ONE);
+ model.setStatus(Constants.ONE);
+ }else{
+ //浜ゆ槗澶辫触
+ model.setStatus(Constants.TWO);
+ }
+ model.setPayFee(map.getFee());
+ model.setPayDate(DateUtil.fromStringToDate("yyyyMMddHHmmss",map.getPaytime()));
+ model.setPayOrderId(map.getTrxid());//閫氳仈璁㈠崟鍙�
+ model.setPayThirdOrderId(map.getChnltrxid());//鏀粯瀹濆井淇¤鍗曞彿
+ model.setPayThirdOrderData(map.getChnldata());//涓夋柟浜ゆ槗娓犻亾鏁版嵁
+ model.setPayInfo(info);
+ model.setPayCode(map.getTrxcode());
+ ordersMapper.updateById(model);
+ return r;
+ }
+
+
}
--
Gitblit v1.9.3