新增退款

doum

昨天 b29d7b6bbe8256d5e95fb878adf06ffa9abb449a

 server/services/src/main/java/com/doumee/service/business/impl/OrdersServiceImpl.java

@@ -3,6 +3,7 @@
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;
@@ -18,9 +19,11 @@
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;
@@ -56,6 +59,8 @@

    @Autowired
    private OrdersMapper ordersMapper;
    @Autowired
    private RefundMapper refundMapper;
    @Autowired
    private SystemUserMapper systemUserMapper;
    @Autowired
@@ -207,6 +212,7 @@
        IPage<Orders> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity());
        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);
@@ -243,7 +249,7 @@
    @Override
    public IndexOrderCountVO getIndexData(Orders pageWrap) {
        IndexOrderCountVO data = initIndexOrderCountMoel();
       List<Orders> list = ordersMapper.selectList(new QueryWrapper<Orders>()
        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 )
@@ -304,6 +310,18 @@
            }
        }

         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;
    }

@@ -337,6 +355,10 @@
        data.setTodayFailNum0(0l);
        data.setTodayFailNum1(0l);

        data.setTodayRefundMoney(new BigDecimal(0));
        data.setTodayRefundOrderNum(0l);
        data.setTodayRefundNum(0l);

        return data;

    }
@@ -357,7 +379,7 @@
                .eq(Orders::getStatus,Constants.ZERO)
                .apply("TIMESTAMPDIFF(MINUTE, create_time ,now()) > "+time));
        if(orderList !=null && orderList.size()>0){
            PayPublicModel publicModel = initPayPublicModel();
            PayPublicModel publicModel =systemDictDataBiz.initPayPublicModel();
            Date date = new Date();
            for(Orders model : orderList){
                queryPayOrderDetailBiz(model,publicModel,date,time);
@@ -373,26 +395,15 @@
        }
        Orders  model =  ordersMapper.selectById(param.getId());
        if(model !=null ){
            PayPublicModel publicModel = initPayPublicModel();
            PayPublicModel publicModel =systemDictDataBiz.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);
        DoumeeTLUtil doumeeTLUtil = new DoumeeTLUtil(publicModel);
        PayOrderNotifyParam map = doumeeTLUtil.sendQueryOrder(model.getId()+"");
        int status = Constants.TWO;
        if(map!=null){
            String info = SybUtil.getPayInfoByStatus(map);
@@ -406,7 +417,7 @@
                    status = Constants.ONE;
                } else if (StringUtils.equals(map.getTrxstatus(),"2000") || StringUtils.equals(map.getTrxstatus(),"2008")) {
                    //如果交易未支付，并且未超过半小时，不处理
                    if(date.getTime() - model.getCreateTime().getTime() < 30*60*1000){
                    if(date.getTime() - model.getCreateTime().getTime() < time*60*1000){
                        return;
                    }
                }
@@ -429,66 +440,8 @@
        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 {
//        String url =systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.PAY_RETURN_WEB_URL).getCode();
@@ -512,46 +465,24 @@
                    r ="支付结果异常，如有疑问请联系客服人员";
                    return;
                }
                Orders model = ordersMapper.selectOne(new QueryWrapper<Orders>().lambda()
                        .eq(Orders::getId,Integer.parseInt(map.getCusorderid()))
                );
                if(model ==null){
                    log.error("支付处理失败======未找到交易订单"+map.getCusorderid());
                    r ="支付结果异常，订单查询失败，如有疑问请联系客服人员";
                    return;
                }
                 if(Constants.equalsInteger(model.getPayStatus(),Constants.ONE)){
                    log.error("支付处理======订单已支付"+map.getCusorderid());
                    return;
                }
                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);
                        model.setStatus(Constants.ONE);
                    }else{
                        //交易失败
                        model.setStatus(Constants.TWO);
                    }
                }else{
                    model.setStatus(Constants.TWO);
                    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 {
                  //其他类型不通知
                }
                model.setPayFee(map.getFee());
                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());
                ordersMapper.updateById(model);

            }else{
                log.error("支付验签失败======");
                r ="支付失败，如有疑问请联系客服人员";
                return;
            }
            //验签完毕进行业务处理
        } catch (Exception e) {//处理异常
@@ -565,18 +496,66 @@
        }
    }


    public   TreeMap<String, String> getParams(HttpServletRequest request){
        TreeMap<String, String> map = new TreeMap<String, String>();
        Map reqMap = request.getParameterMap();
        for(Object key:reqMap.keySet()){
            String value = ((String[])reqMap.get(key))[0];
            System.out.println(key+";"+value);
            map.put(key.toString(),value);
    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 "支付结果异常，订单查询失败，如有疑问请联系客服人员";
        }
        return map;
        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;
    }


}