代码初始化

doum

5 天以前 275b6c4986343c3e4230e1ad28ce9548b017d584

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

@@ -5,23 +5,32 @@
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;
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.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;
@@ -29,10 +38,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实现
@@ -47,6 +58,8 @@
    private OrdersMapper ordersMapper;
    @Autowired
    private SystemUserMapper systemUserMapper;
    @Autowired
    private SystemDictDataBiz systemDictDataBiz;

    @Override
    @Transactional
@@ -70,10 +83,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 +97,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 +205,378 @@
    @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)
                .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));

        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);
        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 = 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 {
//        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;
                }
                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);
                }
                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) {//处理异常
            // TODO: handle exception
             e.printStackTrace();
            log.error("支付通知处理异常：",e.getMessage());
            r = "error";
        }  finally{//收到通知,返回success
            response.getOutputStream().write(r.getBytes());
            response.flushBuffer();
        }
    }


    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);
        }
        return map;
    }



}