Examples with ExtraProduct com.itrus.portal.db.ExtraProduct used on opensource projects

Example 21 with ExtraProduct

use of com.itrus.portal.db.ExtraProduct in project portal by ixinportal.

the class SZYQServiceImpl method submitBill.

// 1.提交订单
public boolean submitBill(ExtraBill extraBill) {
    boolean flag = false;
    // 1.查找是神州易桥接口的产品.然后遍历这些产品,根据产品查找订单,
    DefaultTransactionDefinition def = new DefaultTransactionDefinition();
    def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED);
    TransactionStatus status = null;
    try {
        ExtraProduct product = extraProductService.selectByPrimaryKey(extraBill.getExtraProduct());
        Map<String, Object> paramMap = new HashMap<String, Object>();
        paramMap.put("productId", extraBill.getExtraProduct());
        paramMap.put("billStatu", ComNames.EXTRA_BILL_STATUS_3);
        paramMap.put("id", extraBill.getId());
        // 2.查找是该产品的订单,并且订单状态是已支付,待服务商审核的订单.然后遍历订单信息
        List<Map<String, Object>> Extrabills = sqlSession.selectList("com.itrus.portal.db.ExtraBillMapper.selectByCondition_SZYQ", paramMap);
        if (null == Extrabills || Extrabills.isEmpty()) {
            return flag;
        }
        // 3.封装参数,发送数据到第三方平台.根据返回值是否成功,如果成功就修改订单状态和审核时间,事物提交.
        for (Map<String, Object> bill : Extrabills) {
            // 加密串md5(key+时间戳+参数)
            String sign = new String();
            // 时间戳
            long ts = System.currentTimeMillis();
            // 平台编号
            String system_code = product.getServiceId();
            // key
            if (product.getServiceSecret() != null) {
                product.setServiceSecret(AESencrp.decrypt(product.getServiceSecret(), dbEncKey));
            }
            String key = product.getServiceSecret();
            String param = "";
            /**
             * { " phone ":"186000000", //客户手机号
             * " productName ":"1122" ,// 商品名称 "num":"1", //购买商品的数量
             * " preferentialAmount ":" 1520.00 "
             * ,//商品优惠价格（优惠的金额，差价） " finalAmount ":" 1520.00 "
             * ,//商品最终价格（商品优惠后的价格，销售价） " orderPayType ":" 0 "
             * //订单支付状态(1已支付，0待支付) }
             */
            param = "{\"phone\":\"" + bill.get("m_phone").toString() + "\"," + "\"productName\":\"" + bill.get("epname").toString() + "\"," + "\"num\":\"" + bill.get("product_num").toString() + "\"," + "\"preferentialAmount\":\"" + 0 + "\"," + "\"finalAmount\":\"" + bill.get("bill_sum").toString() + "\"," + "\"orderPayType\":\"" + 1 + "\"" + "}";
            param = ts + param;
            sign = szyqBillTask.sign(param, key, "utf-8");
            // TODO 发送到第三方平台
            /**
             * { " orderCreateStatus ":"1", //订单生成状态(1成功，0失败)
             * " ordersNo ":"112233", //订单编号 }
             */
            String result = "{\"orderCreateStatus\":\"" + 1 + "\"," + "\"ordersNo\":\"" + 112233 + "\"" + "}";
            System.out.println(result);
            Map<String, Object> resultMap = szyqBillTask.convertJsonStrToMap(result);
            System.out.println(result);
            if (resultMap.get("orderCreateStatus").equals("1")) {
                String ordersNo = (String) resultMap.get("ordersNo");
                ExtraBill bill2 = extraBillService.selectByPrimaryKey((Long) bill.get("id"));
                bill2.setBillsNo(ordersNo);
                // if (null != bill2.geteInvoice()) {
                bill2.setBillStatus(ComNames.EXTRA_BILL_STATUS_4);
                // } else {
                // bill2.setBillStatus(ComNames.EXTRA_BILL_STATUS_7);
                // }
                status = transactionManager.getTransaction(def);
                extraBillService.updateByPrimaryKeySelective(bill2);
                transactionManager.commit(status);
                flag = true;
                return flag;
            } else {
                LogUtil.syslog(sqlSession, "推送增值订单失败_神州易桥", "订单号:" + bill.get("bill_id") + "推送失败，错误信息：");
                continue;
            }
        }
        LogUtil.syslog(sqlSession, "推送增值订单_神州易桥", "推送成功，推送订单:" + extraBill.getBillId() + "，成功");
    } catch (Exception e) {
        LogUtil.syslog(sqlSession, "推送增值订单失败_神州易桥", "订单号:" + extraBill.getBillId() + ",错误：" + e.toString());
        e.printStackTrace();
    } finally {
        if (status != null && !status.isCompleted()) {
            transactionManager.rollback(status);
        }
    }
    return flag;
}

Example 22 with ExtraProduct

use of com.itrus.portal.db.ExtraProduct in project portal by ixinportal.

the class SHJJExtraBillSmsTask method run.

@Override
public void run() {
    Map<String, Object> param = new HashMap<String, Object>();
    param.put("reviewStatus", 3);
    param.put("isRefuseSms", 0);
    param.put("limit", 20);
    List<Map<String, Object>> billexall = sqlSession.selectList("com.itrus.portal.db.ExtraBillMapper.selectByCondition", param);
    ExtraBill bill;
    MessageTemplate messageTemplate;
    for (Map<String, Object> billMap : billexall) {
        bill = extraBillService.selectByPrimaryKey(Long.parseLong(billMap.get("id").toString()));
        // 查询短信模版
        // 查找对应项目的消息模版：SHJJ
        messageTemplate = messageTemplateService.getMsgTemp(bill.getProject(), "SHJJ");
        if (null == messageTemplate) {
            continue;
        }
        Enterprise enterprise = sqlSession.selectOne("com.itrus.portal.db.EnterpriseMapper.selectByPrimaryKey", bill.getEnterprise());
        ExtraProduct product = extraProductService.selectByPrimaryKey(bill.getExtraProduct());
        Project project = sqlSession.selectOne("com.itrus.portal.db.ProjectMapper.selectByPrimaryKey", bill.getProject());
        UserInfo userInfo = sqlSession.selectOne("com.itrus.portal.db.UserInfoMapper.selectByPrimaryKey", bill.getUniqueId());
        String content = messageTemplate.getMessageContent();
        // 替换特定内容：企业名称：enterpriseName,产品名称：productName，项目名称：projectName,拒绝原因：reason
        if (content.contains("enterpriseName")) {
            content = content.replaceAll("enterpriseName", enterprise.getEnterpriseName());
        }
        if (content.contains("productName")) {
            content = content.replaceAll("productName", product.getAppName());
        }
        if (content.contains("projectName")) {
            content = content.replaceAll("projectName", project.getName());
        }
        if (content.contains("reason")) {
            content = content.replaceAll("reason", bill.getRefuseReason());
        }
        // 发送短信
        try {
            smsSendService.sendRefuseReview(userInfo.getmPhone(), content, "SHJJ", project.getId(), userInfo.getUniqueId(), bill.getBillId());
        } catch (Exception e) {
            e.printStackTrace();
        }
        bill.setIsRefuseSms(true);
        bill.setSendTime(new Date());
        try {
            extraBillService.updateByPrimaryKey(bill);
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }
}

Example 23 with ExtraProduct

use of com.itrus.portal.db.ExtraProduct in project portal by ixinportal.

the class BaiWangTask method initBaiWang.

/**
 * 初始化发票通云服务平台CA代办接口规范所需要的参数
 */
public void initBaiWang() {
    synchronized (BaiWangTaskLock) {
        // start------------处理双机互斥----------
        if (null == taskFlag) {
            taskFlag = systemConfigService.isTimedTaskHost();
        }
        if (taskFlag.equals(false)) {
            return;
        }
        // end------------处理双机互斥----------
        List<ExtraProduct> products = new ArrayList<>();
        try {
            // 1.先判断有没有该接口类型的产品,没有则返回
            products = extraProductService.getExtraProductBySIN(ComNames.SERVICE_INTERFACE_NAME_BWFPTPT);
            if (null == products || products.isEmpty()) {
                return;
            }
            // 2.再判断产品中,所需要的四个参数client_id,client_secret,SQM,baseUrl是否齐全,如果不齐全,则抛出异常,齐全,则为其赋值
            ExtraProduct product = products.get(0);
            String clientId = product.getServiceId();
            if (StringUtils.isBlank(clientId)) {
                LogUtil.syslog(sqlSession, "链接发票通平台错误", "错误信息:appid为空");
            }
            String clientSecret = product.getServiceSecret();
            if (StringUtils.isBlank(clientSecret)) {
                LogUtil.syslog(sqlSession, "链接发票通平台错误", "错误信息:appSecret为空");
            }
            String S_Q_M = product.getSqm();
            if (StringUtils.isBlank(S_Q_M)) {
                LogUtil.syslog(sqlSession, "链接发票通平台错误", "错误信息:代办 CA授权码为空");
            }
            String base_Url = product.getServiceAddress();
            if (StringUtils.isBlank(base_Url)) {
                LogUtil.syslog(sqlSession, "链接发票通平台错误", "错误信息:服务地址为空");
            }
            String[] appId = product.getServiceId().split(";");
            client_id = appId[0];
            dan_ji_userName = appId[1];
            product.setServiceSecret(AESencrp.decrypt(product.getServiceSecret(), dbEncKey));
            String[] appSecret = product.getServiceSecret().split(";");
            client_secret = appSecret[0];
            dan_ji_passWord = appSecret[1];
            String[] urls = product.getServiceAddress().split(";");
            baseUrl = urls[0];
            Map<String, Object> map = getProtocolAddressPortFromUrl(urls[1]);
            dan_ji_url = map.get("address").toString();
            dan_ji_protocol = map.get("protocol").toString();
            dan_ji_port = (Integer) map.get("port");
            SQM = product.getSqm();
            // 3.判断access_token,expires_in是否存在,是否过期,如果还有半个小时或者一个小时过期,则进行更新
            if (!isConnection()) {
                // 进行更新
                updateAccessToken(baseUrl);
                updateOpenId(baseUrl);
            }
        } catch (Exception e) {
            log.error(e.getMessage());
        }
    }
}

Example 24 with ExtraProduct

use of com.itrus.portal.db.ExtraProduct in project portal by ixinportal.

the class BaiWangTask method query.

/**
 * 、 CA 申请记录查询接口服务
 *2.1、 请求报文
 *接口说明： 用于第三方开票服务商查看已提交的企业 CA 申请结果信息
 *调用方式： HTTPS 请求方式 POST 请求
 *测试环境 URL：
 *https://ip:port/Entoauth/thirdInviceService?sign=caResult&xml=
 *<REQUEST>
 *<HEAD>
 *<client_id>企业的 client_id</client_id>
 *<access_token>二.1 接口获取到</access_token>
 *<openID>二.2 接口获取到</openID>
 *</HEAD>
 *<BODY>
 *<SQM>代办 CA 授权码</SQM>
 *<TAX_REGISTER_NO>企业证件号码</TAX_REGISTER_NO>
 *</BODY>
 *</REQUEST>
 */
// 2.订单状态
@Scheduled(cron = "0 0/10 * * * ?")
public void query() {
    synchronized (BaiWangTaskLock) {
        // start------------处理双机互斥----------
        if (null == taskFlag) {
            taskFlag = systemConfigService.isTimedTaskHost();
        }
        if (taskFlag.equals(false)) {
            return;
        }
        // end------------处理双机互斥----------
        if (!isConnection() || !isBaiWangDanJiConnection()) {
            initBaiWang();
        }
        List<ExtraProduct> products = new ArrayList<>();
        DefaultTransactionDefinition def = new DefaultTransactionDefinition();
        def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED);
        TransactionStatus status = null;
        try {
            // 1.先判断有没有该接口类型的产品,没有则返回
            products = extraProductService.getExtraProductBySIN(ComNames.SERVICE_INTERFACE_NAME_BWFPTPT);
            if (null == products || products.isEmpty()) {
                return;
            }
            for (ExtraProduct product : products) {
                // 筛选是该产品,并且订单状态是服务商审核中
                Map<String, Object> paramMap = new HashMap<String, Object>();
                paramMap.put("productId", product.getId());
                paramMap.put("isquery", 1);
                paramMap.put("desc", 1);
                // 2.查找是该产品的订单,并且订单状态是已支付,待服务商审核的订单.然后遍历订单信息
                List<Map<String, Object>> Extrabills = sqlSession.selectList("com.itrus.portal.db.ExtraBillMapper.selectByCondition_BAIWANG", paramMap);
                if (null == Extrabills || Extrabills.isEmpty()) {
                    continue;
                }
                Integer count = 0;
                Integer count_danji = 0;
                Map resultMap = new HashMap<>();
                for (Map<String, Object> bill : Extrabills) {
                    Long id = (Long) bill.get("id");
                    Boolean is_sendfpt = (Boolean) bill.get("is_sendfpt");
                    Boolean is_passfpt = (Boolean) bill.get("is_passfpt");
                    Boolean is_senddj = (Boolean) bill.get("is_senddj");
                    Boolean is_passdj = (Boolean) bill.get("is_passdj");
                    // 其他附加信息
                    // 营业执照
                    BusinessLicense businessLicense = businessService.getBusinessByExtraBillId(id, null);
                    // 企业信息
                    Enterprise enterprise = enterpriseService.getEnterpriseById((Long) bill.get("enterprise"));
                    // 开户行信息
                    OpenBankInfo openBankInfo = openBankInfoService.getOpenBankInfoByExtraBillId(id, null);
                    // 税务登记
                    TaxRegisterCert taxRegisterCert = taxCertService.getTaxRegisterCertByExtraBillId(id, null);
                    // 0:税号 1:信用代码号
                    Integer credentialsType = null;
                    if (null != businessLicense && businessLicense.getBusinessType().equals(1)) {
                        credentialsType = 1;
                    } else if (null != taxRegisterCert) {
                        credentialsType = 0;
                    }
                    String TAX_REGISTER_NO = credentialsType == 1 ? businessLicense.getLicenseNo() : taxRegisterCert.getCertNo();
                    String param2 = "";
                    try {
                        if (null != is_sendfpt && is_sendfpt.equals(true) && ((null == is_passfpt || is_passfpt.equals(false)))) {
                            /**
                             * 、 CA 申请记录查询接口服务
                             *							2.1、 请求报文
                             *							接口说明： 用于第三方开票服务商查看已提交的企业 CA 申请结果信息
                             *							调用方式： HTTPS 请求方式 POST 请求
                             *							测试环境 URL：
                             *							https://ip:port/Entoauth/thirdInviceService?sign=caResult&xml=
                             *							<REQUEST>
                             *							<HEAD>
                             *							<client_id>企业的 client_id</client_id>
                             *							<access_token>二.1 接口获取到</access_token>
                             *							<openID>二.2 接口获取到</openID>
                             *							</HEAD>
                             *							<BODY>
                             *							<SQM>代办 CA 授权码</SQM>
                             *							<TAX_REGISTER_NO>企业证件号码</TAX_REGISTER_NO>
                             *							</BODY>
                             *							</REQUEST>
                             */
                            param2 = "<REQUEST><HEAD>" + "<client_id>" + client_id + "</client_id>" + "<access_token>" + access_token + "</access_token>" + "<openID>" + openID + "</openID>" + "</HEAD>" + "<BODY>" + "<SQM>" + SQM + "</SQM>" + "<TAX_REGISTER_NO>" + TAX_REGISTER_NO + "</TAX_REGISTER_NO>" + "</BODY>" + "</REQUEST>";
                            String param = URLEncoder.encode(new String(Base64.encode(param2.getBytes())), "UTF-8");
                            LinkedMultiValueMap<String, Object> map = new LinkedMultiValueMap<String, Object>();
                            String urlAccessToken = baseUrl + "thirdInvoiceService";
                            URI uri;
                            uri = new URI(urlAccessToken);
                            map.add("sign", "caResult");
                            map.add("xml", param);
                            String xml = restTemplate.postForObject(uri, map, String.class);
                            resultMap = parseXml(xml);
                            String recode = resultMap.get("REPLYCODE").toString();
                            ExtraBill extraBill = extraBillService.selectByPrimaryKey(id);
                            if (StringUtils.isNotBlank(recode) && recode.equals("0000")) {
                                // 当单机的已经审核通过之后,才能修改订单状态
                                if (null != extraBill.getIsPassdj() && extraBill.getIsPassdj().equals(true)) {
                                    if (null != extraBill.geteInvoice()) {
                                        // 订单需要开票.判断是否开票了.
                                        Boolean isinvoiced = extraBill.getIsInvoiced();
                                        if (null == isinvoiced || isinvoiced.equals(false)) {
                                            extraBill.setBillStatus(ComNames.EXTRA_BILL_STATUS_6);
                                        } else {
                                            extraBill.setBillStatus(ComNames.EXTRA_BILL_STATUS_7);
                                            extraBill.setFinishTime(new Date());
                                        }
                                    } else {
                                        // 订单不需要开票,直接完成
                                        extraBill.setBillStatus(ComNames.EXTRA_BILL_STATUS_7);
                                        extraBill.setFinishTime(new Date());
                                    }
                                    extraBill.setCheckTime(new Date());
                                }
                                extraBill.setIsPassfpt(true);
                                is_passfpt = true;
                                status = transactionManager.getTransaction(def);
                                extraBillService.updateByPrimaryKeySelective(extraBill);
                                transactionManager.commit(status);
                                count++;
                            } else if (StringUtils.isNotBlank(recode) && recode.equals("0003")) {
                                extraBill.setRefuseReason(resultMap.get("REPLYMSG").toString());
                                extraBill.setBillStatus(ComNames.EXTRA_BILL_STATUS_5);
                                extraBill.setIsRefuse(true);
                                extraBill.setIsPassfpt(false);
                                extraBill.setIsSendfpt(false);
                                status = transactionManager.getTransaction(def);
                                extraBillService.updateByPrimaryKeySelective(extraBill);
                                transactionManager.commit(status);
                                log.error("审核拒绝_百旺发票通", "订单号:" + bill.get("bill_id").toString() + "拒绝信息:" + resultMap.get("REPLYMSG") + ", 参数:" + param2);
                                LogUtil.syslog(sqlSession, "审核拒绝_百旺发票通", "订单号:" + bill.get("bill_id").toString() + "拒绝信息:" + resultMap.get("REPLYMSG"));
                                count++;
                            }
                        }
                    } catch (Exception e) {
                        log.error("查询订单_百旺发票通", "出现异常,订单号:" + bill.get("bill_id").toString() + "错误异常:" + e.getMessage() + ", 参数:" + param2);
                        LogUtil.syslog(sqlSession, "查询订单_百旺发票通", "出现异常,订单号:" + bill.get("bill_id").toString() + "错误异常:" + e.getMessage());
                    }
                    // 查询单机
                    if (null != is_senddj && is_senddj.equals(true) && (null == is_passdj || is_passdj.equals(false))) {
                        StringBuffer stringBuffer = new StringBuffer();
                        String url = dan_ji_url + "/fpfw/api/kpbusiness";
                        /**
                         *								<?xml version="1.0" encoding="utf-8"?>
                         *								<business comment="查询申请结果" id="CXSQJG">
                         *								<head>
                         *								    <login_name><![CDATA[itruschina]]></login_name>
                         *								    <passwd><![CDATA[12345678]]></passwd>
                         *								    <skpbh><![CDATA[ceshi2017071311222333]]></skpbh>
                         *								    <nsrsbh><![CDATA[911101088020176222333]]></nsrsbh>
                         *								</head>
                         *								</business>
                         */
                        stringBuffer.append("<?xml version='1.0' encoding='utf-8'?>");
                        stringBuffer.append("<business comment='查询申请结果' id='CXSQJG'>");
                        stringBuffer.append("<head>");
                        stringBuffer.append("<login_name><![CDATA[" + dan_ji_userName + "]]></login_name>");
                        stringBuffer.append("<passwd><![CDATA[" + dan_ji_passWord + "]]></passwd>");
                        stringBuffer.append("<skpbh><![CDATA[" + openBankInfo.getTaxNumber() + "]]></skpbh>");
                        stringBuffer.append("<nsrsbh><![CDATA[" + enterprise.getNsrsbh() + "]]></nsrsbh>");
                        stringBuffer.append("</head>");
                        stringBuffer.append("</business>");
                        try {
                            resultMap = new HashMap<>();
                            HttpClient client = new HttpClient();
                            client.getHostConfiguration().setHost(dan_ji_url, dan_ji_port, dan_ji_protocol);
                            HttpMethod method = null;
                            PostMethod post = new PostMethod("/fpfw/api/kpbusiness");
                            NameValuePair bw = new NameValuePair("bw", stringBuffer.toString());
                            NameValuePair[] nameValuePairs = { bw };
                            post.setRequestBody(nameValuePairs);
                            method = post;
                            client.getParams().setParameter(HttpMethodParams.HTTP_CONTENT_CHARSET, "UTF-8");
                            method.addRequestHeader("Content-Type", "application/x-www-form-urlencoded; charset=UTF-8");
                            client.executeMethod(method);
                            String xml = new String(method.getResponseBodyAsString().getBytes("UTF-8"));
                            resultMap = parseXml(xml);
                            /**
                             *								 返回报文:
                             *								<?xml version="1.0" encoding="utf-8"?>
                             *								<business id="CXSQJG" version='1.0'>
                             *								<head>
                             *								</head>
                             *								<body>
                             *								<sq_date>申请日期</sq_date>
                             *								<yxqq>有效期起</yxqq>
                             *								<yxqz>有效期止</yxqz>
                             *								<kt_date>开通日期</kt_date>
                             *								<downloadurl>下载地址</downloadurl>
                             *								<returncode>返回</returncode>
                             *								<returnmsg>返回信息</returnmsg>
                             *								</body>
                             *								</business>
                             */
                            String returncode = resultMap.get("returncode").toString();
                            ExtraBill extraBill = extraBillService.selectByPrimaryKey(id);
                            if (StringUtils.isNotBlank(returncode) && returncode.equals(BW_DANJI_SHEN_HE_TONG_GUO)) {
                                // 当发票通的已经审核通过之后,才能修改订单状态
                                if (null != extraBill.getIsPassfpt() && extraBill.getIsPassfpt().equals(true)) {
                                    if (null != extraBill.geteInvoice()) {
                                        // 订单需要开票.判断是否开票了.
                                        Boolean isinvoiced = extraBill.getIsInvoiced();
                                        if (null == isinvoiced || isinvoiced.equals(false)) {
                                            extraBill.setBillStatus(ComNames.EXTRA_BILL_STATUS_6);
                                        } else {
                                            extraBill.setBillStatus(ComNames.EXTRA_BILL_STATUS_7);
                                            extraBill.setFinishTime(new Date());
                                        }
                                    } else {
                                        // 订单不需要开票,直接完成
                                        extraBill.setBillStatus(ComNames.EXTRA_BILL_STATUS_7);
                                        extraBill.setFinishTime(new Date());
                                    }
                                    extraBill.setCheckTime(new Date());
                                }
                                extraBill.setIsPassdj(true);
                                is_passdj = true;
                                bwdjRecordService.insertOneRecored(resultMap, extraBill.getId());
                                status = transactionManager.getTransaction(def);
                                extraBillService.updateByPrimaryKeySelective(extraBill);
                                transactionManager.commit(status);
                                count_danji++;
                            } else if (StringUtils.isNotBlank(returncode) && returncode.equals(BW_DANJI_SHEN_HE_JU_JUE)) {
                                status = transactionManager.getTransaction(def);
                                String refuseReason = (String) resultMap.get("returnmsg");
                                extraBill.setRefuseReason(refuseReason);
                                refuseDanJi(extraBill);
                                transactionManager.commit(status);
                                log.error("审核拒绝_百旺单机", "订单号:" + bill.get("bill_id").toString() + "错误码:" + resultMap.get("returncode") + "错误信息:" + resultMap.get("returnmsg") + ", 参数:" + stringBuffer.toString());
                                LogUtil.syslog(sqlSession, "审核拒绝_百旺单机", "订单号:" + bill.get("bill_id").toString() + "错误码:" + resultMap.get("returncode") + "错误信息:" + resultMap.get("returnmsg"));
                            }
                        } catch (Exception e) {
                            log.error("查询订单_百旺单机", "出现异常,订单号:" + bill.get("bill_id").toString() + "错误异常:" + e.getMessage() + ", 参数:" + stringBuffer.toString());
                            LogUtil.syslog(sqlSession, "查询订单_百旺单机", "出现异常,订单号:" + bill.get("bill_id").toString() + "错误异常:" + e.getMessage());
                        }
                    }
                }
                LogUtil.syslog(sqlSession, "查询订单_百旺发票通", "总共:" + Extrabills.size() + "条,成功:" + count + "条");
            }
        } catch (Exception e) {
            LogUtil.syslog(sqlSession, "查询订单失败_百旺", "错误信息:" + e.getMessage());
            e.printStackTrace();
        } finally {
            if (status != null && !status.isCompleted()) {
                transactionManager.rollback(status);
            }
        }
    }
}

Example 25 with ExtraProduct

use of com.itrus.portal.db.ExtraProduct in project portal by ixinportal.

the class BaiWangTask method submitOrder.

// 1.订单资料推送
@Scheduled(cron = "0 0/7 * * * ?")
public void submitOrder() {
    /**
     *		 <REQUEST>
     *<HEAD>
     *<client_id>企业的 client_id</client_id>
     *<access_token>二.1 接口获取到</access_token>
     *<openID>二.2 接口获取到</openID>
     *</HEAD>
     *<BODY>
     *<SQM>代办 CA 授权码</SQM>
     *<TAXPAYER_NAME>企业名称</TAXPAYER_NAME>
     *<SHORT_NAME>企业简称</SHORT_NAME>
     *<IS_SZHY>企业证件类型</IS_SZHY>
     *<TAX_REGISTER_NO>企业税号</TAX_REGISTER_NO>
     *<ENT_PROVINCE>省份</ENT_PROVINCE>
     *<ENT_CITY>城市</ENT_CITY>
     *<LEGAL_PERSON>企业法人</LEGAL_PERSON>
     *<ADDRESS>企业联系地址</ADDRESS>
     *<ENT_EMAIL>企业邮箱</ENT_EMAIL>
     *<A_NAME>企业联系人姓名</A_NAME>
     *<A_MOBILE>企业联系电话</A_MOBILE>
     *<A_ID_NO>企业联系人身份证号码</A_ID_NO>
     *<A_EINVOICE_DEL>CA 申请表</A_EINVOICE_DEL>
     *<A_BIZ_LIC>三证合一/营业执照</A_BIZ_LIC>
     *<A_ID_FRONT>企业联系人身份证(正面)</A_ID_FRONT>
     *<A_ID_BACK>企业联系人身份证(反面)</A_ID_BACK>
     *<TAXPAYER_ID>申请 CA 企业对应唯一编号/当 type=1 时必传</TAXPAYER_ID>
     *</BODY>
     *</REQUEST>
     *"<REQUEST><HEAD>"
     */
    synchronized (BaiWangTaskLock) {
        // start------------处理双机互斥----------
        if (null == taskFlag) {
            taskFlag = systemConfigService.isTimedTaskHost();
        }
        if (taskFlag.equals(false)) {
            return;
        }
        // end------------处理双机互斥----------
        if (!isConnection() || !isBaiWangDanJiConnection()) {
            initBaiWang();
        }
        List<ExtraProduct> products = new ArrayList<>();
        DefaultTransactionDefinition def = new DefaultTransactionDefinition();
        def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED);
        TransactionStatus status = null;
        try {
            // 1.先判断有没有该接口类型的产品,没有则返回
            products = extraProductService.getExtraProductBySIN(ComNames.SERVICE_INTERFACE_NAME_BWFPTPT);
            if (null == products || products.isEmpty()) {
                return;
            }
            for (ExtraProduct product : products) {
                // 筛选是该产品,并且订单状态是3:已支付，待服务商审核,5:服务商审核拒绝 ：这两种状态的订单
                Map<String, Object> paramMap = new HashMap<String, Object>();
                paramMap.put("productId", product.getId());
                paramMap.put("issubmit", 1);
                paramMap.put("desc", 1);
                // 2.查找是该产品的订单,并且订单状态是已支付,待服务商审核的订单.然后遍历订单信息
                List<Map<String, Object>> Extrabills = sqlSession.selectList("com.itrus.portal.db.ExtraBillMapper.selectByCondition_BAIWANG", paramMap);
                if (null == Extrabills || Extrabills.isEmpty()) {
                    continue;
                }
                Integer count = 0;
                Integer count_danji = 0;
                Map<String, String> resultMap = new HashMap<>();
                for (Map<String, Object> bill : Extrabills) {
                    Long id = (Long) bill.get("id");
                    Boolean is_sendfpt = (Boolean) bill.get("is_sendfpt");
                    Boolean is_passfpt = (Boolean) bill.get("is_passfpt");
                    Boolean is_senddj = (Boolean) bill.get("is_senddj");
                    Boolean is_passdj = (Boolean) bill.get("is_passdj");
                    Long userinfoId = (Long) bill.get("unique_id");
                    // 企业信息
                    Enterprise enterprise = enterpriseService.getEnterpriseById((Long) bill.get("enterprise"));
                    // 其他附加信息
                    // 营业执照
                    BusinessLicense businessLicense = businessService.getBusinessByExtraBillId(id, null);
                    // 税务登记
                    TaxRegisterCert taxRegisterCert = taxCertService.getTaxRegisterCertByExtraBillId(id, null);
                    // 组织机构代码
                    // OrgCode orgCode = orgCodeService.getOrgCodeByExtraBillId(id, null);
                    // 代理人
                    // Agent agent = agentService.getAgentByExtraBillId(id, null);
                    // 用户
                    UserInfo userInfo = userInfoService.getUserInfoById(userinfoId);
                    // 开户行信息
                    OpenBankInfo openBankInfo = openBankInfoService.getOpenBankInfoByExtraBillId(id, null);
                    // 法人信息
                    IdentityCard identityCard = identityCardService.getIdentityCardByExtraBillId(id, null);
                    Integer type = 0;
                    Boolean isRefuse = (Boolean) bill.get("is_refuse");
                    if (null != isRefuse && isRefuse.equals(true)) {
                        type = 1;
                    }
                    // 0:税号 1:信用代码号
                    Integer credentialsType = null;
                    if (null != businessLicense && businessLicense.getBusinessType().equals(1)) {
                        credentialsType = 1;
                    } else if (null != taxRegisterCert) {
                        credentialsType = 0;
                    }
                    String TAX_REGISTER_NO = credentialsType == 1 ? businessLicense.getLicenseNo() : taxRegisterCert.getCertNo();
                    // 省份,当省份是几个直辖的或者特区的时候,省和市是一样的
                    // 北京市110000,天津市120000,上海市310000,重庆市500000,
                    // 香港,澳门,台湾先不做处理
                    String province = enterprise.getProvince();
                    boolean iscity = false;
                    if (province.equals("110000") || province.equals("120000") || province.equals("310000") || province.equals("500000")) {
                        iscity = true;
                    }
                    province = sysRegionService.getProvince(province);
                    // 城市
                    String city = "";
                    if (iscity) {
                        city = province;
                    } else {
                        city = sysRegionService.getCity(enterprise.getCity());
                    }
                    String param2 = "";
                    // 当没发送过到百旺发票通的时候,则进行发送
                    if (null == is_sendfpt || is_sendfpt.equals(false)) {
                        File file = new File(systemConfigService.getTrustDir().getPath() + File.separator + enterprise.getEnterpriseSn());
                        if (!file.exists()) {
                            file.mkdir();
                        }
                        File imgFile = new File(file, businessLicense.getImgFile());
                        FileInputStream fis = null;
                        fis = new FileInputStream(imgFile);
                        // 三证合一/营业执照
                        String A_BIZ_LIC = ImageToBase64Utils.GetFileBase64(fis);
                        // CompressImageUtils.getThumbPicture(A_BIZ_LIC, width, height);
                        if (A_BIZ_LIC.length() > BAI_WANG_MAX_IMG) {
                            A_BIZ_LIC = compressImage(A_BIZ_LIC);
                        }
                        fis.close();
                        // +"<A_ID_FRONT>"+"企业联系人身份证(正面)"+"</A_ID_FRONT>"
                        imgFile = new File(file, identityCard.getFrontImg());
                        fis = new FileInputStream(imgFile);
                        String A_ID_FRONT = ImageToBase64Utils.GetFileBase64(fis);
                        if (A_ID_FRONT.length() > BAI_WANG_MAX_IMG) {
                            A_ID_FRONT = compressImage(A_ID_FRONT);
                        }
                        fis.close();
                        // 若法人是合并上传的,则传递两张一样的照片过去
                        String A_ID_BACK = "";
                        if (StringUtils.isBlank(identityCard.getBackImg())) {
                            A_ID_BACK = A_ID_FRONT;
                        } else {
                            // +"<A_ID_BACK>"+"企业联系人身份证(反面)"+"</A_ID_BACK>"
                            imgFile = new File(file, identityCard.getBackImg());
                            fis = new FileInputStream(imgFile);
                            A_ID_BACK = ImageToBase64Utils.GetFileBase64(fis);
                            if (A_ID_BACK.length() > BAI_WANG_MAX_IMG) {
                                A_ID_BACK = compressImage(A_ID_BACK);
                            }
                            fis.close();
                        }
                        // +"<TAXPAYER_ID>"+"申请 CA 企业对应唯一编号/当 type=1 时必传"+"</TAXPAYER_ID>"
                        String TAXPAYER_ID = "";
                        if (type == 1) {
                            TAXPAYER_ID = bill.get("taxpayer_id").toString();
                        }
                        // 2.根据产品信息,去筛选企业信息.
                        // HTTPS 请求方式 POST 请求
                        // 1:type 0:代表 CA 新申请， 1： 新申请被驳回， 而再次推送修改过后的资料操作
                        // 服务商是否曾经拒绝过该订单,如果拒绝过.则为true;再次提交给服务商的时候,先判断这个值,如果为true,则进行特殊处理,发送之后,修改该值为false
                        // field boolean --fieldName isRefuse
                        // https://ip:port/Entoauth/thirdInvoiceService?sign=caApply&type=&xml=
                        param2 = "<REQUEST><HEAD>" + "<client_id>" + client_id + "</client_id>" + "<access_token>" + access_token + "</access_token>" + "<openID>" + openID + "</openID>" + "</HEAD>" + "<BODY>" + "<SQM>" + SQM + "</SQM>" + "<TAXPAYER_NAME>" + enterprise.getEnterpriseName() + "</TAXPAYER_NAME>" + "<SHORT_NAME>" + enterprise.getShortName() + "</SHORT_NAME>" + // 0:税号 1:信用代码号
                        "<IS_SZHY>" + credentialsType + "</IS_SZHY>" + // 企业税号或者企业三证合一之后的社会信用代码
                        "<TAX_REGISTER_NO>" + TAX_REGISTER_NO + "</TAX_REGISTER_NO>" + "<ENT_PROVINCE>" + province + "</ENT_PROVINCE>" + "<ENT_CITY>" + city + "</ENT_CITY>" + "<LEGAL_PERSON>" + identityCard.getName() + "</LEGAL_PERSON>" + "<ADDRESS>" + businessLicense.getBusinessPlace() + "</ADDRESS>" + "<ENT_EMAIL>" + bill.get("email").toString() + "</ENT_EMAIL>" + "<A_NAME>" + userInfo.getRealName() + "</A_NAME>" + "<A_MOBILE>" + bill.get("m_phone").toString() + "</A_MOBILE>" + "<A_ID_NO>" + identityCard.getIdCode() + "</A_ID_NO>" + "<A_EINVOICE_DEL></A_EINVOICE_DEL>" + "<A_BIZ_LIC>" + A_BIZ_LIC + "</A_BIZ_LIC>" + "<A_ID_FRONT>" + A_ID_FRONT + "</A_ID_FRONT>" + "<A_ID_BACK>" + A_ID_BACK + "</A_ID_BACK>" + "<TAXPAYER_ID>" + TAXPAYER_ID + "</TAXPAYER_ID>" + "</BODY>" + "</REQUEST>";
                        String param = URLEncoder.encode(new String(Base64.encode(param2.getBytes())), "UTF-8");
                        LinkedMultiValueMap<String, Object> map = new LinkedMultiValueMap<String, Object>();
                        // https://ip:port/Entoauth/thirdInvoiceService?sign=caApply&type=&xml=
                        // String urlAccessToken = baseUrl + "thirdInvoiceService?sign=caApply"
                        // + "&type=" + type + "&xml=" + param;
                        String urlAccessToken = baseUrl + "thirdInvoiceService";
                        URI uri;
                        uri = new URI(urlAccessToken);
                        map.add("sign", "caApply");
                        map.add("type", type);
                        map.add("xml", param);
                        String xml = restTemplate.postForObject(uri, map, String.class);
                        resultMap = parseXml(xml);
                        String recode = resultMap.get("REPLYCODE");
                        if (StringUtils.isNotBlank(recode) && recode.equals("0000")) {
                            ExtraBill extraBill = extraBillService.selectByPrimaryKey(id);
                            extraBill.setIsSendfpt(true);
                            // 两个平台都成功送审之后,订单状态改为服务商审核中
                            if (null != extraBill.getIsSenddj() && extraBill.getIsSenddj().equals(true)) {
                                extraBill.setBillStatus(ComNames.EXTRA_BILL_STATUS_4);
                            }
                            extraBill.setTaxpayerId(resultMap.get("TAXPAYER_ID").toString());
                            if (type == 1) {
                                // 曾经拒绝过的订单,再次推送成功
                                extraBill.setIsRefuse(false);
                            }
                            status = transactionManager.getTransaction(def);
                            extraBillService.updateByPrimaryKeySelective(extraBill);
                            transactionManager.commit(status);
                            count++;
                        } else {
                            log.error("推送订单失败_百旺发票通", "订单号:" + bill.get("bill_id").toString() + "错误码:" + resultMap.get("REPLYCODE") + "错误信息:" + resultMap.get("REPLYMSG") + ", 参数:" + param2);
                            LogUtil.syslog(sqlSession, "推送订单失败_百旺发票通", "订单号:" + bill.get("bill_id").toString() + "错误码:" + resultMap.get("REPLYCODE") + "错误信息:" + resultMap.get("REPLYMSG"));
                        }
                    }
                    // 当没发送到百旺单机的时候,重新发送
                    if (null == is_senddj || is_senddj.equals(false)) {
                        StringBuffer stringBuffer = new StringBuffer();
                        /**
                         *						<?xml version="1.0" encoding="utf-8"?>
                         *						<business comment="注册申请" id="ZCSQ">
                         *						<body>
                         *						    <login_name><![CDATA[itruschina]]></login_name>
                         *						    <passwd><![CDATA[12345678]]></passwd>
                         *						    <skpbh><![CDATA[ceshi2017071311222333]]></skpbh>
                         *						    <nsrsbh><![CDATA[911101088020176222333]]></nsrsbh>
                         *						    <nsrmc><![CDATA[北京天威诚信电子商务服务有限公司测试070333]]></nsrmc>
                         *						    <city><![CDATA[北京市]]></city>
                         *						    <kh_usr_name><![CDATA[张三]]></kh_usr_name>
                         *						    <kh_lxdh><![CDATA[18878996333]]></kh_lxdh>
                         *						    <sfsy><![CDATA[1]]></sfsy>
                         *						    <bz><![CDATA[123]]></bz>
                         *						    <sqr_usr_name><![CDATA[何冠宏]]></sqr_usr_name>
                         *						    <sqr_lxdh><![CDATA[18878991333]]></sqr_lxdh>
                         *						    <sqr_ssgs><![CDATA[北京天威诚信电子商务服务有限公司]]></sqr_ssgs>
                         *						    <sfsf><![CDATA[1]]></sfsf>
                         *						    <sfje><![CDATA[0]]></sfje>
                         *						</body>
                         *						</business>
                         */
                        stringBuffer.append("<?xml version='1.0' encoding='utf-8'?>");
                        stringBuffer.append("<business comment='注册申请' id='ZCSQ'>");
                        stringBuffer.append("<body>");
                        stringBuffer.append("<login_name><![CDATA[" + dan_ji_userName + "]]></login_name>");
                        stringBuffer.append("<passwd><![CDATA[" + dan_ji_passWord + "]]></passwd>");
                        stringBuffer.append("<skpbh><![CDATA[" + openBankInfo.getTaxNumber() + "]]></skpbh>");
                        stringBuffer.append("<nsrsbh><![CDATA[" + enterprise.getNsrsbh() + "]]></nsrsbh>");
                        stringBuffer.append("<nsrmc><![CDATA[" + enterprise.getEnterpriseName() + "]]></nsrmc>");
                        stringBuffer.append("<city><![CDATA[" + city + "]]></city>");
                        stringBuffer.append("<kh_usr_name><![CDATA[" + userInfo.getRealName() + "]]></kh_usr_name>");
                        stringBuffer.append("<kh_lxdh><![CDATA[" + bill.get("m_phone").toString() + "]]></kh_lxdh>");
                        // 试用就是1 ，正式就用0.这个是针对客户端是否试用的
                        stringBuffer.append("<sfsy><![CDATA[0]]></sfsy>");
                        stringBuffer.append("<bz><![CDATA[" + bill.get("bill_id").toString() + "]]></bz>");
                        stringBuffer.append("<sqr_usr_name><![CDATA[" + "王晓雪" + "]]></sqr_usr_name>");
                        stringBuffer.append("<sqr_lxdh><![CDATA[" + "13120460901" + "]]></sqr_lxdh>");
                        stringBuffer.append("<sqr_ssgs><![CDATA[" + "北京天威诚信电子商务服务有限公司" + "]]></sqr_ssgs>");
                        stringBuffer.append("<sfsf><![CDATA[1]]></sfsf>");
                        stringBuffer.append("<sfje><![CDATA[0]]></sfje>");
                        stringBuffer.append("</body>");
                        stringBuffer.append("</business>");
                        try {
                            HttpClient client = new HttpClient();
                            client.getHostConfiguration().setHost(dan_ji_url, dan_ji_port, dan_ji_protocol);
                            HttpMethod method = null;
                            PostMethod post = new PostMethod("/fpfw/api/kpbusiness");
                            NameValuePair bw = new NameValuePair("bw", stringBuffer.toString());
                            NameValuePair[] nameValuePairs = { bw };
                            post.setRequestBody(nameValuePairs);
                            method = post;
                            client.getParams().setParameter(HttpMethodParams.HTTP_CONTENT_CHARSET, "UTF-8");
                            method.addRequestHeader("Content-Type", "application/x-www-form-urlencoded; charset=UTF-8");
                            client.executeMethod(method);
                            String xml = new String(method.getResponseBodyAsString().getBytes("UTF-8"));
                            resultMap = parseXml(xml);
                            String returncode = resultMap.get("returncode");
                            if (StringUtils.isNotBlank(returncode) && returncode.equals("0")) {
                                ExtraBill extraBill = extraBillService.selectByPrimaryKey(id);
                                extraBill.setIsSenddj(true);
                                // 两个平台都成功送审之后,订单状态改为服务商审核中
                                if (null != extraBill.getIsSendfpt() && extraBill.getIsSendfpt().equals(true)) {
                                    extraBill.setBillStatus(ComNames.EXTRA_BILL_STATUS_4);
                                }
                                status = transactionManager.getTransaction(def);
                                extraBillService.updateByPrimaryKeySelective(extraBill);
                                transactionManager.commit(status);
                                count_danji++;
                            } else {
                                /**
                                 * 现在是<?xml version='1.0' encoding='utf-8'?><business version='1.0'><head></head><body><returncode>3</returncode><returnmsg>xml解析错误</returnmsg></body></business>
                                 */
                                log.error("推送订单失败_百旺单机", "订单号:" + bill.get("bill_id").toString() + "错误码:" + resultMap.get("returncode") + ", 错误信息:" + resultMap.get("returnmsg") + ", 参数:" + stringBuffer.toString());
                                LogUtil.syslog(sqlSession, "推送订单失败_百旺单机", "订单号:" + bill.get("bill_id").toString() + "错误码:" + resultMap.get("returncode") + ", 错误信息:" + resultMap.get("returnmsg"));
                            }
                        } catch (Exception e) {
                            e.printStackTrace();
                            log.error("推送订单失败_百旺单机", "订单号:" + bill.get("bill_id").toString() + "错误信息:" + e.getMessage() + ", 参数:" + stringBuffer.toString());
                            LogUtil.syslog(sqlSession, "推送订单失败_百旺单机", "订单号:" + bill.get("bill_id").toString() + "错误信息:" + e.getMessage());
                            continue;
                        }
                    }
                }
                LogUtil.syslog(sqlSession, "推送订单_百旺", "总共:" + Extrabills.size() + "条,发票通成功:" + count + "条, 单机成功:" + count_danji + "条");
            }
        } catch (Exception e) {
            LogUtil.syslog(sqlSession, "推送订单失败_百旺", "错误信息:" + e.getMessage());
            e.printStackTrace();
        } finally {
            if (status != null && !status.isCompleted()) {
                transactionManager.rollback(status);
            }
        }
    }
}