use of com.itrus.portal.db.Enterprise 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;
}
use of com.itrus.portal.db.Enterprise in project portal by ixinportal.
the class BindCertWebController method bindPage.
@RequestMapping("/bindCertPage")
public String bindPage(@RequestParam(value = "certSn", required = true) String certSn, HttpSession session, Model uiModel) throws UserInfoServiceException {
// 是否登录
UserInfo webuserInfo = (UserInfo) session.getAttribute("webuserInfo");
Enterprise webenterprise = (Enterprise) session.getAttribute("webenterprise");
if (null == webuserInfo || null == webenterprise) {
// 登录状态失效,跳转到注册页面
return "redirect:/userInfoWeb/denglu.html";
}
// 返回所有信任源所有
List<String> allIssUerDn = new ArrayList<String>();
allIssUerDn = sqlSession.selectList("com.itrus.portal.db.CrlContextMapper.selectAllIssUerDn");
try {
uiModel.addAttribute("allIssUerDn", jsonTool.writeValueAsString(allIssUerDn));
} catch (JsonGenerationException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (JsonMappingException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
UserCert userCert = null;
userCert = userCertService.getUserCertByCertSn(certSn);
if (null == userCert)
throw new UserInfoServiceException("未找到对应的证书信息");
// DateFormat df = new SimpleDateFormat("yyyy/MM/dd");
UserCertPojo ucp = new UserCertPojo(userCert, userCert.getCertStartTime().getTime() + "", userCert.getCertEndTime().getTime() + "");
CertBuf certBuf = sqlSession.selectOne("com.itrus.portal.db.CertBufMapper.selectByPrimaryKey", userCert.getCertBuf());
uiModel.addAttribute("userCert", ucp);
uiModel.addAttribute("certBase64", certBuf.getCertBuf().replaceAll("\n", ""));
return "ixinweb/bangding";
}
use of com.itrus.portal.db.Enterprise in project portal by ixinportal.
the class BindCertWebController method bindCert.
// 绑定用户和证书
@RequestMapping("/bindCert")
@ResponseBody
public Map<String, Object> bindCert(@RequestParam(value = "mPhone", required = true) String mPhone, @RequestParam(value = "code", required = true) String code, @RequestParam(value = "password", required = false) String password, @RequestParam(value = "projectId", required = true) Long projectId, @RequestParam(value = "certBase64", required = true) String certBase64, @RequestParam(value = "keySn", required = false) String keySn, 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 (!dynamicCodeService.verifyCode(mPhone, code)) {
// 验证码不通过
retMap.put("retMsg", "动态码验证失败");
return retMap;
}
DefaultTransactionDefinition def = new DefaultTransactionDefinition();
def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED);
TransactionStatus status = transactionManager.getTransaction(def);
try {
// 绑定用户和证书
UserInfo userInfo = userInfoService.getUserInfoByMphone(mPhone);
if (null == userInfo) {
if (StringUtils.isBlank(password)) {
retMap.put("retMsg", "请先设置登录口令");
return retMap;
}
// 先自动创建用户
userInfo = userInfoService.registerUserInfo(mPhone, password, projectId);
// 记录系统日志
String info = mPhone + "注册成功";
LogUtil.syslog(sqlSession, "注册用户", info);
}
// 添加企业-代理人关联关系
userInfoEnterpriseServiceImpl.saveUserInfoEnterprise(userInfo.getId(), webenterprise.getId());
// 获取证书
UserCert userCert = userCertService.getUserCert(certBase64);
// 判断是否已和证书绑定
if (userCertService.isBindCert(userInfo.getId(), certBase64)) {
retMap.put("retMsg", "该证书已绑定过用户");
return retMap;
}
// 绑定证书与用户关系
if (StringUtils.isNotBlank(keySn))
userCert.setKeySn(keySn);
userCert.setUserinfo(userInfo.getId());
userCert.setEnterprise(webenterprise.getId());
sqlSession.update("com.itrus.portal.db.UserCertMapper.updateByPrimaryKey", userCert);
retMap.put("retCode", 1);
transactionManager.commit(status);
return retMap;
} catch (CertificateException e) {
if (!status.isCompleted())
transactionManager.rollback(status);
retMap.put("retMsg", e.getMessage());
return retMap;
} catch (UserInfoServiceException e) {
if (!status.isCompleted())
transactionManager.rollback(status);
retMap.put("retMsg", e.getMessage());
return retMap;
} catch (SigningServerException e) {
if (!status.isCompleted())
transactionManager.rollback(status);
retMap.put("retMsg", e.getMessage());
return retMap;
} catch (Exception e) {
if (!status.isCompleted())
transactionManager.rollback(status);
retMap.put("retMsg", "服务端出现未知异常,请联系管理员");
String info = mPhone + "绑定证书失败,原因:" + e.getMessage();
LogUtil.syslog(sqlSession, "绑定证书", info);
return retMap;
} finally {
if (!status.isCompleted())
transactionManager.rollback(status);
}
}
use of com.itrus.portal.db.Enterprise in project portal by ixinportal.
the class BindCertWebController method sendCode.
/**
* 绑定证书时发送验证码
*
* @param mPhone
* @param project
* @param certBase64
* @return
*/
@RequestMapping("/sendCode")
@ResponseBody
public Map<String, Object> sendCode(@RequestParam(value = "mPhone", required = true) String mPhone, @RequestParam(value = "project", required = true) Long project, @RequestParam(value = "certBase64", required = true) String certBase64, 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;
}
try {
// 判断该证书是否已经绑定有用户
UserInfo userInfo = userInfoService.getUserInfoByMphone(mPhone);
// 0表示没有用户,1表示有用户
retMap.put("hasUserInfo", 0);
if (null != userInfo) {
// 1表示有用户
retMap.put("hasUserInfo", 1);
// 判断是否和证书绑定
if (userCertService.isBindCert(userInfo.getId(), certBase64)) {
retMap.put("retMsg", "该证书已绑定过用户");
return retMap;
}
}
// 发送验证码
// ZSBD表示短信模版类型为‘绑定证书’。
dynamicCodeService.sendCode(mPhone, project, "ZSBD");
retMap.put("retCode", 1);
} catch (UserInfoServiceException e) {
retMap.put("retMsg", e.getMessage());
return retMap;
} catch (CertificateException e) {
retMap.put("retMsg", e.getMessage());
return retMap;
} catch (SigningServerException e) {
retMap.put("retMsg", e.getMessage());
return retMap;
}
return retMap;
}
use of com.itrus.portal.db.Enterprise in project portal by ixinportal.
the class ClientWebController method checkInvoceByPDF.
/**
* retCode:0为失败,1为成功
* PDF发票校验接口
* @param invoicePDF:PDF发票文件
*/
@RequestMapping("/fpjyByPDF")
@ResponseBody
public Map<String, Object> checkInvoceByPDF(@RequestParam(value = "invoicePDF", required = true) MultipartFile invoicePDF, @RequestParam(value = "productId", required = true) Long productId, HttpServletRequest request) {
HttpSession session = request.getSession();
Map<String, Object> retMap = new HashMap<>();
retMap.put("retCode", 0);
UserInfo webuserInfo = (UserInfo) session.getAttribute("webuserInfo");
Enterprise webenterprise = (Enterprise) session.getAttribute("webenterprise");
if (null == webuserInfo || null == webenterprise) {
retMap.put("retMsg", "用户登录信息已失效,请重新登录");
return retMap;
}
//
Project project = (Project) session.getAttribute("webproject");
if (null == project) {
retMap.put("retMsg", "项目信息不存在");
return retMap;
}
// 获取发票校验的应用
ExtraProduct product = extraProductService.selectByPrimaryKey(productId);
if (null == product) {
retMap.put("retMsg", "产品信息不存在");
return retMap;
}
if (invoicePDF.getContentType().equals("pdf")) {
retMap.put("retMsg", "请上传PDF类型的文件");
return retMap;
}
try {
File file = baiWangService.getInvoiceImageFilePath();
String imageFileName = getImageFileName();
// 将pdf转为图片,存储到制定路径
PDFToImageUtils.pdf2Pic(invoicePDF.getInputStream(), file, imageFileName);
File PDFImageFile = new File(file, imageFileName);
// 0位发票代码,1为发票号码,2为发票校验码
String[] invoiceInfo = parseQRCodeTool.parseQRCode(PDFImageFile);
if (null == invoiceInfo || invoiceInfo.length != 3) {
retMap.put("retMsg", "无法识别发票中的信息,请重新上传或者用其他方式校验发票");
return retMap;
}
// 删除临时文件
PDFImageFile.deleteOnExit();
Map<String, String> invoiceMap = baiWangService.verifyInvoice(invoiceInfo[0], invoiceInfo[1], invoiceInfo[2]);
retMap.putAll(invoiceMap);
if (null != retMap.get("REPLYCODE") && retMap.get("REPLYCODE").equals("0000")) {
retMap.put("retCode", 1);
String info = invoiceMap.toString().replaceAll(" ", "");
checkInvoiceLogService.insertCheckInvoiceLog(product.getAppName(), webenterprise.getEnterpriseName(), info, project.getId(), webuserInfo.getRealName());
return retMap;
} else {
String REPLYMSG = (String) retMap.get("REPLYMSG");
retMap.put("retMsg", REPLYMSG);
return retMap;
}
} catch (Exception e) {
UserLog userlog = new UserLog();
userlog.setProject(webuserInfo.getProject());
userlog.setType("校验发票");
userlog.setInfo("url:fpjyByPDF,详细错误:" + e.getMessage());
userlog.setHostId("未知");
userlog.setSn(null == webuserInfo.getUniqueId() ? null : webuserInfo.getUniqueId());
LogUtil.userlog(sqlSession, userlog);
retMap.put("retMsg", "PDF发票校验出错,请确认您上传的PDF电子发票是否正确或者更换其他查验方式,您还可以请联系管理员,错误代码:fpjyByPDF001");
}
return retMap;
}
Aggregations