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

Example 31 with Bill

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

the class BillWebServiceImpl method getPfxCertBufByBills.

/**
 * 根据订单.判断订单是否该显示下载证书的按钮
 * @param bills
 * @return Map<Long, Long>,键为bill.id,值为certBuf.id;
 */
public Map<Long, Long> getPfxCertBufByBills(List<Bill> bills) {
    Map<Long, Long> map = new HashMap<Long, Long>();
    if (null == bills || bills.isEmpty()) {
        return map;
    }
    Date date = new Date();
    for (Bill bill : bills) {
        Product product = productService.getProduct(bill.getProduct());
        if (null == product.getCert()) {
            continue;
        }
        DigitalCert digitalCert = digitalCertService.getDigitalCert(product.getCert());
        Integer billStatus = bill.getBillStatus();
        // 判断订单是pfx类型的用户下载证书,且订单状态是678.
        boolean pfx_download = null != digitalCert && null != digitalCert.getCertType() && null != digitalCert.getInitBuy() && digitalCert.getCertType().equals(ComNames.DIGITALCERT_CERTTYPE_PFX) && digitalCert.getInitBuy().equals(ComNames.DIGITALCERT_INITBUYS_2) && (billStatus == ComNames.BILL_STATUS_6 || billStatus == ComNames.BILL_STATUS_7 || billStatus == ComNames.BILL_STATUS_8);
        if (pfx_download) {
            // 根据订单号,找到订单对应的证书信息
            CertBuf certBuf = sqlSession.selectOne("com.itrus.portal.db.CertBufMapper.selectPfxCertByBillId", bill.getId());
            // 获取证书第一次下载时间和当前时间比较,如果超过了十五天,则不允许下载
            int day = DateUtils.daysOfTwo(date, certBuf.getCreateTime());
            if (day < 16) {
                map.put(bill.getId(), certBuf.getId());
            }
        }
    }
    return map;
}

Example 32 with Bill

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

the class BillWebController method register.

/**
 * 审核拒绝后，重新提交订单
 *
 * @param enterpriseName
 *            企业名称
 * @param enterpriseNature
 *            企业性质
 * @param billId
 *            订单id
 * @param businessLicense
 * @param orgCode
 * @param taxregisterCert
 * @param identityCard
 * @param agent
 * @param proxy
 * @param session
 * @return
 */
@RequestMapping("/register")
@ResponseBody
public Map<String, Object> register(@RequestParam(value = "enterpriseName", required = true) String enterpriseName, @RequestParam(value = "enterprise_nature", required = false) Integer enterpriseNature, @RequestParam(value = "bill_id", required = true) Long billId, @RequestParam(value = "uid", required = true) String uid, @RequestParam(value = "uid1", required = false) String uid1, @RequestParam(value = "uid2", required = false) String uid2, @RequestParam(value = "uid3", required = false) String uid3, @ModelAttribute("businessLicense") BusinessLicense businessLicense, @ModelAttribute("orgCode") OrgCode orgCode, @ModelAttribute("taxregisterCert") TaxRegisterCert taxregisterCert, @ModelAttribute("identityCard") IdentityCard identityCard, @ModelAttribute("agent") Agent agent, @ModelAttribute("proxy") Proxy proxy, HttpSession session) {
    Map<String, Object> retMap = new HashMap<String, Object>();
    // 0标识失败，1标识成功
    retMap.put("retCode", 0);
    UserInfo webuserInfo = (UserInfo) session.getAttribute("webuserInfo");
    Enterprise webenterprise = (Enterprise) session.getAttribute("webenterprise");
    if (null == webuserInfo || null == webenterprise) {
        // 登录状态失效,跳转到注册页面
        // 2表示登录失效
        retMap.put("retCode", 2);
        retMap.put("retMsg", "登录已经失效，请重新登录");
        return retMap;
    }
    // 验证参数完整性
    if (null == enterpriseNature || 0 == enterpriseNature || null == billId) {
        retMap.put("retMsg", "提交参数信息不完整");
        return retMap;
    }
    Bill bill = sqlSession.selectOne("com.itrus.portal.db.BillMapper.selectByPrimaryKey", billId);
    if (null == bill) {
        retMap.put("retMsg", "该订单不存在");
        return retMap;
    }
    if (!webuserInfo.getId().equals(bill.getUniqueId())) {
        retMap.put("retMsg", "您不能修改该订单");
        return retMap;
    }
    if (bill.getBillStatus() != ComNames.BILL_STATUS_4) {
        retMap.put("retMsg", "该订单未审核拒绝");
        return retMap;
    }
    // 根据订单id获取产品需要认证项，
    List<String> certItems = sqlSession.selectList("com.itrus.portal.db.CertificationMapper.selectCertItemsByBillId", billId);
    if (null == certItems || certItems.isEmpty()) {
        retMap.put("retMsg", "服务端出现异常，请联系管理员");
        log.error("获取订单对应产品的认证项失败：订单Id=" + billId + ".");
        return retMap;
    }
    // 记录旧的企业唯一标识：
    String oldEnterpriseSn = webenterprise.getEnterpriseSn();
    // 设置企业唯一标识
    if (enterpriseNature.equals(1) || enterpriseNature.equals(2)) {
        // 类型为企业和个体工商户：当三证合一时，企业标识为统一社会信用代码；当非三证合一时,企业标识为营业执照注册号；
        webenterprise.setEnterpriseSn(businessLicense.getLicenseNo());
    }
    if (enterpriseNature.equals(3)) {
        // 类型为政府机关/事业单位：企业标识为组织机构代码
        webenterprise.setEnterpriseSn(orgCode.getOrgCode());
    }
    // 修改企业名称
    webenterprise.setEnterpriseName(enterpriseName.trim());
    // 修改企业性质
    webenterprise.setEnterpriseNature(enterpriseNature);
    DefaultTransactionDefinition def = new DefaultTransactionDefinition();
    def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED);
    TransactionStatus status = transactionManager.getTransaction(def);
    try {
        // 删除订单关联的旧认证项，新增订单对应的新认证项
        billWebService.saveBillAuthenticationItems(certItems.get(0), enterpriseNature, billId, businessLicense, orgCode, taxregisterCert, identityCard, agent, proxy, webenterprise, webuserInfo);
        // 3、判断该订单对应的企业的认证项是否为通过，若是通过，则重新设置为不通过
        if (null != webenterprise.getAuthenticationLevel())
            webenterprise.setAuthenticationLevel(null);
        if (null != webenterprise.getHasBl())
            webenterprise.setHasBl(null);
        if (null != webenterprise.getHasOrgCode())
            webenterprise.setHasOrgCode(null);
        if (null != webenterprise.getHasTaxCert())
            webenterprise.setHasTaxCert(null);
        if (null != webenterprise.getHasIdCard())
            webenterprise.setHasIdCard(null);
        if (null != webenterprise.getHasAgent())
            webenterprise.setHasAgent(null);
        sqlSession.update("com.itrus.portal.db.EnterpriseMapper.updateByPrimaryKey", webenterprise);
        // 修改发票
        if (bill.getInvoice() != null && bill.getIsInvoiced() == null) {
            Invoice invoice = sqlSession.selectOne("com.itrus.portal.db.InvoiceMapper.selectByPrimaryKey", bill.getInvoice());
            invoice.setName(webenterprise.getEnterpriseName());
            sqlSession.update("com.itrus.portal.db.InvoiceMapper.updateByPrimaryKey", invoice);
        }
        if (bill.geteInvoice() != null && bill.getIsInvoiced() == null) {
            Einvoice einvoice = sqlSession.selectOne("com.itrus.portal.db.EinvoiceMapper.selectByPrimaryKey", bill.geteInvoice());
            einvoice.setName(webenterprise.getEnterpriseName());
            sqlSession.update("com.itrus.portal.db.EinvoiceMapper.updateByPrimaryKey", einvoice);
        }
        if (StringUtils.isNotEmpty(uid) && !uid.equals("{}")) {
            bill.setUid(uid);
        }
        if (StringUtils.isNotEmpty(uid1) && !uid1.equals("{}")) {
            bill.setUid1(uid1);
        }
        if (StringUtils.isNotEmpty(uid2) && !uid2.equals("{}")) {
            bill.setUid2(uid2);
        }
        if (StringUtils.isNotEmpty(uid3) && !uid3.equals("{}")) {
            bill.setUid3(uid3);
        }
        // 设置订单为待审核状态
        bill.setBillStatus(ComNames.BILL_STATUS_3);
        sqlSession.update("com.itrus.portal.db.BillMapper.updateByPrimaryKeySelective", bill);
        transactionManager.commit(status);
        session.setAttribute("webenterprise", webenterprise);
        // 企业标识改变后，将旧目录中的图片复制到新目录中
        if (!oldEnterpriseSn.equals(webenterprise.getEnterpriseSn())) {
            CopyFile.copyFile(systemConfigService.getTrustDir().getPath() + File.separator + oldEnterpriseSn, systemConfigService.getTrustDir().getPath() + File.separator + webenterprise.getEnterpriseSn());
        }
        retMap.put("retCode", 1);
    } catch (UserInfoServiceException e) {
        if (!status.isCompleted())
            transactionManager.rollback(status);
        retMap.put("retMsg", e.getMessage());
        return retMap;
    } catch (Exception e) {
        if (!status.isCompleted())
            transactionManager.rollback(status);
        UserLog userlog = new UserLog();
        userlog.setType("重新提交订单");
        userlog.setInfo("url:register,详细错误：" + e.getMessage());
        userlog.setHostId("未知");
        userlog.setProject(webuserInfo.getProject());
        LogUtil.userlog(sqlSession, userlog);
        retMap.put("retMsg", "服务端出现未知错误，请联系管理员");
        log.error(e.getMessage());
        return retMap;
    } finally {
        if (!status.isCompleted())
            transactionManager.rollback(status);
    }
    return retMap;
}

Example 33 with Bill

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

the class BillWebController method billList.

/**
 * 订单列表
 *
 * @param billStatus
 *            0未完成订单，1已完成订单
 * @param request
 * @param uiModel
 * @return
 */
@RequestMapping(produces = "text/html")
public String billList(@RequestParam(value = "billStatus", required = false) Integer billStatus, @RequestParam(value = "page", required = false) Integer page, @RequestParam(value = "size", required = false) Integer size, @RequestParam(value = "page2", required = false) Integer page2, @RequestParam(value = "size2", required = false) Integer size2, HttpServletRequest request, Model uiModel) {
    HttpSession session = request.getSession();
    Boolean verifyCodeStatus = (Boolean) session.getAttribute("webverifyCodeStatus");
    Enterprise enterprise = (Enterprise) session.getAttribute("webenterprise");
    UserInfo userInfo = (UserInfo) session.getAttribute("webuserInfo");
    if (null == verifyCodeStatus || !verifyCodeStatus || null == userInfo) {
        // 登录状态失效,跳转到登录页面
        return "redirect:/userInfoWeb/denglu.html";
    }
    if (userInfo != null && enterprise == null) {
        // 登录未获取到企业信息,跳转到选择企业页面
        return "redirect:/userInfoWeb/choiceEnterprise";
    }
    uiModel.addAttribute("billStatus", billStatus);
    if (page == null || page < 1) {
        page = 1;
    }
    if (size == null || size < 1) {
        size = 5;
    }
    BillExample billExampl = new BillExample();
    BillExample.Criteria criteria = billExampl.or();
    // web页面不显示解锁的订单产品
    List<Long> keyUnlockProductIds = productService.getKeyUnlockProductIds();
    if (null != keyUnlockProductIds && !keyUnlockProductIds.isEmpty()) {
        criteria.andProductNotIn(keyUnlockProductIds);
    }
    // 查询当前用户当前企业的订单
    // 当前用户
    criteria.andUniqueIdEqualTo(userInfo.getId());
    // 当前企业 v 76
    criteria.andEnterpriseEqualTo(enterprise.getId());
    if (null == billStatus || 0 == billStatus) {
        // 未完成订单：订单状态不为8
        criteria.andBillStatusNotEqualTo(ComNames.BILL_STATUS_8);
        criteria.andIsDeleteEqualTo(false);
    } else if (1 == billStatus) {
        // 订单状态为已完成
        criteria.andBillStatusEqualTo(ComNames.BILL_STATUS_8);
    }
    Integer count = sqlSession.selectOne("com.itrus.portal.db.BillMapper.countByExample", billExampl);
    if (page > 1 && size * (page - 1) >= count) {
        page = (count + size - 1) / size;
    }
    uiModel.addAttribute("count", count);
    uiModel.addAttribute("pages", (count + size - 1) / size);
    uiModel.addAttribute("page", page);
    uiModel.addAttribute("size", size);
    Integer offset = size * (page - 1);
    billExampl.setOffset(offset);
    billExampl.setLimit(size);
    billExampl.setOrderByClause("create_time desc");
    List<Bill> billList = sqlSession.selectList("com.itrus.portal.db.BillMapper.selectByExample", billExampl);
    uiModel.addAttribute("billList", billList);
    uiModel.addAttribute("itemcount", billList.size());
    Map<Long, Delivery> deliveryMap = sqlSession.selectMap("com.itrus.portal.db.DeliveryMapper.selectByExample", null, "id");
    uiModel.addAttribute("deliveryMap", deliveryMap);
    // 填写中订单
    if (page2 == null || page2 < 1) {
        page2 = 1;
    }
    if (size2 == null || size2 < 1) {
        size2 = 5;
    }
    EditBillExample ebEx = new EditBillExample();
    EditBillExample.Criteria criteria2 = ebEx.or();
    // 查询当前用户当前企业的订单
    // 当前用户
    criteria2.andUserInfoIdEqualTo(userInfo.getId());
    // 
    criteria2.andEnterpriseIdEqualTo(enterprise.getId());
    Integer count2 = sqlSession.selectOne("com.itrus.portal.db.EditBillMapper.countByExample", ebEx);
    if (page2 > 1 && size2 * (page2 - 1) >= count2) {
        page2 = (count2 + size2 - 1) / size2;
    }
    uiModel.addAttribute("count2", count2);
    uiModel.addAttribute("pages2", (count2 + size2 - 1) / size2);
    uiModel.addAttribute("page2", page2);
    uiModel.addAttribute("size2", size2);
    Integer offset2 = size2 * (page2 - 1);
    // 产品信息：
    /*Map<Long, Product> productMap = billService
				.getProductMapByUserInfoId(userInfo.getId());*/
    // if ((null == billStatus || billStatus.equals(2)) && count2 != 0) {
    Map<Long, Product> productMap = sqlSession.selectMap("com.itrus.portal.db.ProductMapper.selectByExample", "id");
    // }
    uiModel.addAttribute("productMap", productMap);
    // 获取产品关联的数字证书id
    Set<Long> certIds = productService.getDigitalCertIds(productMap);
    // 产品关联的数字证书:
    Map<Long, DigitalCert> digitalCertMap = digitalCertService.getDigitalCertByProductMap(certIds);
    uiModel.addAttribute("digitalCertMap", digitalCertMap);
    // 获取订单对应的产品规格
    Map<Long, ProductSpec> productSpecMap = productSpecService.getProductSpec(billList);
    uiModel.addAttribute("productSpecMap", productSpecMap);
    ebEx.setOffset(offset2);
    ebEx.setLimit(size2);
    ebEx.setOrderByClause("create_time desc");
    List<EditBill> editBillList = sqlSession.selectList("com.itrus.portal.db.EditBillMapper.selectByExample", ebEx);
    // 获取填写中订单对应的产品规格
    Map<Long, ProductSpec> editBill_productSpecMap = productSpecService.getEditBillProductSpec(editBillList);
    uiModel.addAttribute("editBill_productSpecMap", editBill_productSpecMap);
    uiModel.addAttribute("editBillList", editBillList);
    uiModel.addAttribute("itemcount2", editBillList.size());
    // 订单是否对应的pfx的用户下载证书.
    Map<Long, Long> pfxMap = billWebService.getPfxCertBufByBills(billList);
    uiModel.addAttribute("pfxmap", pfxMap);
    session.removeAttribute("sessionPlist");
    session.removeAttribute("enterpriseqqE");
    System.out.println(enterprise.getId());
    Map param = new HashMap();
    param.put("id", enterprise.getId());
    if (userInfo.getmPhone() != null) {
        param.put("phone", userInfo.getmPhone());
    }
    List<Map<String, Object>> plist = sqlSession.selectList("com.itrus.portal.db.ProjectMapper.selectProjectId", param);
    Map<Long, EnterpriseQq> qqMap = new HashMap<Long, EnterpriseQq>();
    for (int i = 0; i < plist.size(); i++) {
        EnterpriseQqExample enterpriseQ = new EnterpriseQqExample();
        EnterpriseQqExample.Criteria qqEx = enterpriseQ.createCriteria();
        // System.out.println(plist.get(i));
        Long pid = Long.parseLong(plist.get(i).get("id").toString());
        // System.out.println(pid);
        qqEx.andProjectIdEqualTo(pid);
        EnterpriseQq enterpriseqq = sqlSession.selectOne("com.itrus.portal.db.EnterpriseQqMapper.selectByExample", enterpriseQ);
        if (enterpriseqq != null) {
            // uiModel.addAttribute("eid", enterpriseqq.getId());
            qqMap.put(pid, enterpriseqq);
        // session.setAttribute("enterpriseqqE", enterpriseqq.getEnterpriseQqLinks());
        }
    }
    session.setAttribute("sessionqqMap", qqMap);
    session.setAttribute("sessionPlist", plist);
    return "ixinweb/zhanghuguanli_dingdanxinxi";
}

Example 34 with Bill

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

the class BillWebController method updateAuditBill.

/**
 * 修改审核中订单
 *
 * @param enterpriseName
 *            企业名称
 * @param enterpriseNature
 *            企业性质
 * @param billId
 *            订单id
 * @param businessLicense
 * @param orgCode
 * @param taxregisterCert
 * @param identityCard
 * @param agent
 * @param proxy
 * @param session
 * @return
 */
@RequestMapping("/updateAuditBill")
@ResponseBody
public Map<String, Object> updateAuditBill(@RequestParam(value = "enterpriseName", required = true) String enterpriseName, @RequestParam(value = "enterprise_nature", required = false) Integer enterpriseNature, @RequestParam(value = "billId", required = true) Long billId, @RequestParam(value = "uid", required = true) String uid, @RequestParam(value = "uid1", required = false) String uid1, @RequestParam(value = "uid2", required = false) String uid2, @RequestParam(value = "uid3", required = false) String uid3, @ModelAttribute("businessLicense") BusinessLicense businessLicense, @ModelAttribute("orgCode") OrgCode orgCode, @ModelAttribute("taxregisterCert") TaxRegisterCert taxregisterCert, @ModelAttribute("identityCard") IdentityCard identityCard, @ModelAttribute("agent") Agent agent, @ModelAttribute("proxy") Proxy proxy, HttpSession session) {
    Map<String, Object> retMap = new HashMap<String, Object>();
    // 0标识失败，1标识成功
    retMap.put("retCode", 0);
    UserInfo webuserInfo = (UserInfo) session.getAttribute("webuserInfo");
    Enterprise webenterprise = (Enterprise) session.getAttribute("webenterprise");
    if (null == webuserInfo || null == webenterprise) {
        // 登录状态失效,跳转到注册页面
        // 2表示登录失效
        retMap.put("retCode", 2);
        retMap.put("retMsg", "登录已经失效，请重新登录");
        return retMap;
    }
    // 验证参数完整性
    if (null == enterpriseNature || 0 == enterpriseNature || null == billId) {
        retMap.put("retMsg", "提交参数信息不完整");
        return retMap;
    }
    Bill bill = sqlSession.selectOne("com.itrus.portal.db.BillMapper.selectByPrimaryKey", billId);
    if (null == bill) {
        retMap.put("retMsg", "该订单不存在");
        return retMap;
    }
    if (!webuserInfo.getId().equals(bill.getUniqueId())) {
        retMap.put("retMsg", "您不能修改该订单");
        return retMap;
    }
    // 1、订单状态为：未支付、支付待确认、已支付待审核、送审中的状态，其余状态不能继续往下执行
    List<Integer> modifiedStatus = new ArrayList<Integer>();
    modifiedStatus.add(ComNames.BILL_STATUS_1);
    modifiedStatus.add(ComNames.BILL_STATUS_2);
    modifiedStatus.add(ComNames.BILL_STATUS_3);
    modifiedStatus.add(ComNames.BILL_STATUS_10);
    // 不在以上状态中
    if (modifiedStatus.indexOf(bill.getBillStatus()) == -1) {
        retMap.put("retMsg", "该订单不能修改");
        return retMap;
    }
    // 根据订单id获取产品需要认证项，
    List<String> certItems = sqlSession.selectList("com.itrus.portal.db.CertificationMapper.selectCertItemsByBillId", billId);
    if (null == certItems || certItems.isEmpty()) {
        retMap.put("retMsg", "服务端出现异常，请联系管理员");
        log.error("获取订单对应产品的认证项失败：订单Id=" + billId + ".");
        return retMap;
    }
    // 记录旧的企业唯一标识：
    String oldEnterpriseSn = webenterprise.getEnterpriseSn();
    // 设置企业唯一标识
    if (enterpriseNature.equals(1) || enterpriseNature.equals(2)) {
        // 类型为企业和个体工商户：当三证合一时，企业标识为统一社会信用代码；当非三证合一时,企业标识为营业执照注册号；
        webenterprise.setEnterpriseSn(businessLicense.getLicenseNo());
    }
    if (enterpriseNature.equals(3)) {
        // 类型为政府机关/事业单位：企业标识为组织机构代码
        webenterprise.setEnterpriseSn(orgCode.getOrgCode());
    }
    // 修改企业名称
    webenterprise.setEnterpriseName(enterpriseName.trim());
    // 修改企业性质
    webenterprise.setEnterpriseNature(enterpriseNature);
    DefaultTransactionDefinition def = new DefaultTransactionDefinition();
    def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED);
    TransactionStatus status = transactionManager.getTransaction(def);
    try {
        // 删除订单关联的旧认证项，新增订单对应的新认证项
        billWebService.saveBillAuthenticationItems(certItems.get(0), enterpriseNature, billId, businessLicense, orgCode, taxregisterCert, identityCard, agent, proxy, webenterprise, webuserInfo);
        // 3、判断该订单对应的企业的认证项是否为通过，若是通过，则重新设置为不通过
        if (null != webenterprise.getAuthenticationLevel())
            webenterprise.setAuthenticationLevel(null);
        if (null != webenterprise.getHasBl())
            webenterprise.setHasBl(null);
        if (null != webenterprise.getHasOrgCode())
            webenterprise.setHasOrgCode(null);
        if (null != webenterprise.getHasTaxCert())
            webenterprise.setHasTaxCert(null);
        if (null != webenterprise.getHasIdCard())
            webenterprise.setHasIdCard(null);
        if (null != webenterprise.getHasAgent())
            webenterprise.setHasAgent(null);
        sqlSession.update("com.itrus.portal.db.EnterpriseMapper.updateByPrimaryKey", webenterprise);
        // 修改发票
        if (bill.getInvoice() != null && bill.getIsInvoiced() == null) {
            Invoice invoice = sqlSession.selectOne("com.itrus.portal.db.InvoiceMapper.selectByPrimaryKey", bill.getInvoice());
            invoice.setName(webenterprise.getEnterpriseName());
            sqlSession.update("com.itrus.portal.db.InvoiceMapper.updateByPrimaryKey", invoice);
        }
        if (bill.geteInvoice() != null && bill.getIsInvoiced() == null) {
            Einvoice einvoice = sqlSession.selectOne("com.itrus.portal.db.EinvoiceMapper.selectByPrimaryKey", bill.geteInvoice());
            einvoice.setName(webenterprise.getEnterpriseName());
            sqlSession.update("com.itrus.portal.db.EinvoiceMapper.updateByPrimaryKey", einvoice);
        }
        // 判断该订单状态是否为送审中，假如是，则设置为 3已支付，待审核(用于重新送审)
        if (bill.getBillStatus().equals(ComNames.BILL_STATUS_10)) {
            bill.setBillStatus(ComNames.BILL_STATUS_3);
            sqlSession.update("com.itrus.portal.db.BillMapper.updateByPrimaryKeySelective", bill);
        }
        if (StringUtils.isNotEmpty(uid) && !uid.equals("{}")) {
            bill.setUid(uid);
            sqlSession.update("com.itrus.portal.db.BillMapper.updateByPrimaryKeySelective", bill);
        } else {
            if (StringUtils.isNotEmpty(uid1) && !uid1.equals("{}")) {
                bill.setUid1(uid1);
            }
            if (StringUtils.isNotEmpty(uid2) && !uid2.equals("{}")) {
                bill.setUid2(uid2);
            }
            if (StringUtils.isNotEmpty(uid3) && !uid3.equals("{}")) {
                bill.setUid3(uid3);
            }
            sqlSession.update("com.itrus.portal.db.BillMapper.updateByPrimaryKeySelective", bill);
        }
        transactionManager.commit(status);
        session.setAttribute("webenterprise", webenterprise);
        // 企业标识改变后，将旧目录中的图片复制到新目录中
        if (!oldEnterpriseSn.equals(webenterprise.getEnterpriseSn())) {
            CopyFile.copyFile(systemConfigService.getTrustDir().getPath() + File.separator + oldEnterpriseSn, systemConfigService.getTrustDir().getPath() + File.separator + webenterprise.getEnterpriseSn());
        }
        retMap.put("retCode", 1);
    } catch (UserInfoServiceException e) {
        if (!status.isCompleted())
            transactionManager.rollback(status);
        retMap.put("retMsg", e.getMessage());
        return retMap;
    } catch (Exception e) {
        if (!status.isCompleted())
            transactionManager.rollback(status);
        UserLog userlog = new UserLog();
        userlog.setType("修改订单");
        userlog.setInfo("url:updateAuditBill,详细错误：" + e.getMessage());
        userlog.setHostId("未知");
        userlog.setProject(webuserInfo.getProject());
        LogUtil.userlog(sqlSession, userlog);
        retMap.put("retMsg", "服务端出现未知错误，请联系管理员");
        log.error(e.getMessage());
        return retMap;
    } finally {
        if (!status.isCompleted())
            transactionManager.rollback(status);
    }
    return retMap;
}

Example 35 with Bill

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

the class BindCertWebController method getProjectByCertBase64.

/**
 * 获取产品信息
 *
 * @param certBase64
 * @return
 * @throws UserInfoServiceException
 */
public Product getProjectByCertBase64(String certBase64) throws UserInfoServiceException {
    UserCert userCert;
    try {
        userCert = userCertService.getUserCert(certBase64);
    } catch (CertificateException e) {
        throw new UserInfoServiceException(e.getMessage());
    } catch (SigningServerException e) {
        throw new UserInfoServiceException(e.getMessage());
    }
    Product product = null;
    // 证书序列号
    String CertSerialNumber = userCert.getCertSn();
    if (userCert.getBill() == null) {
        String accountHash = getRaInfo.getRaInfoByCertSerialNumber(CertSerialNumber);
        if (StringUtils.isBlank(accountHash))
            throw new UserInfoServiceException("获取AccountHash失败，请联系管理员");
        // Ra
        RaAccount raAccount = raAccountService.getRaByAccountHash(accountHash);
        if (null == raAccount)
            throw new UserInfoServiceException("获取RA信息失败，请联系管理员");
        // 产品
        // product = productService.getProductByRa(raAccount.getId());
        product = productService.getRenewProduct(raAccount.getId(), null, null, userCert.getCertDn());
    } else {
        // 证书关联了订单，根据订单获得projectId和productId
        Bill bill = sqlSession.selectOne("com.itrus.portal.db.BillMapper.selectByPrimaryKey", userCert.getBill());
        if (null == bill) {
            throw new UserInfoServiceException("获取产品信息失败，请联系管理员");
        }
        product = sqlSession.selectOne("com.itrus.portal.db.ProductMapper.selectByPrimaryKey", bill.getProduct());
    }
    if (null == product)
        throw new UserInfoServiceException("获取对应产品信息失败");
    userCert.setProduct(product.getId());
    sqlSession.update("com.itrus.portal.db.UserCertMapper.updateByPrimaryKey", userCert);
    return product;
}