use of com.itrus.portal.db.Enterprise in project portal by ixinportal.
the class BaiWangServiceImpl method submitOrder.
/**
* 1.订单资料推送到第三方平台
* @param extraBill
* @return
*/
public boolean submitOrder(ExtraBill extraBill) {
synchronized (baiWangTask.BaiWangTaskLock) {
if (!baiWangTask.isConnection() || !baiWangTask.isBaiWangDanJiConnection()) {
baiWangTask.initBaiWang();
}
boolean fpt_flag = false;
boolean danji_flag = false;
DefaultTransactionDefinition def = new DefaultTransactionDefinition();
def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED);
TransactionStatus status = null;
try {
// 筛选是该产品,并且订单状态是3:已支付,待服务商审核,5:服务商审核拒绝 :这两种状态的订单
Map<String, Object> paramMap = new HashMap<String, Object>();
paramMap.put("productId", extraBill.getExtraProduct());
paramMap.put("issubmit", 1);
paramMap.put("id", extraBill.getId());
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()) {
return false;
}
Integer count = 0;
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 = "";
try {
// 当没发送过到百旺发票通的时候,则进行发送
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);
if (A_BIZ_LIC.length() > baiWangTask.BAI_WANG_MAX_IMG) {
A_BIZ_LIC = baiWangTask.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() > baiWangTask.BAI_WANG_MAX_IMG) {
A_ID_FRONT = baiWangTask.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() > baiWangTask.BAI_WANG_MAX_IMG) {
A_ID_BACK = baiWangTask.compressImage(A_ID_BACK);
}
fis.close();
}
fis.close();
// +"<TAXPAYER_ID>"+"申请 CA 企业对应唯一编号/当 type=1 时必传"+"</TAXPAYER_ID>"
String TAXPAYER_ID = "";
if (type == 1) {
TAXPAYER_ID = bill.get("taxpayer_id").toString();
}
param2 = "<REQUEST><HEAD>" + "<client_id>" + BaiWangTask.client_id + "</client_id>" + "<access_token>" + BaiWangTask.access_token + "</access_token>" + "<openID>" + BaiWangTask.openID + "</openID>" + "</HEAD>" + "<BODY>" + "<SQM>" + BaiWangTask.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>();
String urlAccessToken = BaiWangTask.baseUrl + "thirdInvoiceService";
URI uri;
uri = new URI(urlAccessToken);
map.add("sign", "caApply");
map.add("type", type);
map.add("xml", param);
Map<String, String> resultMap = new HashMap<>();
String xml = restTemplate.postForObject(uri, map, String.class);
resultMap = BaiWangTask.parseXml(xml);
String recode = resultMap.get("REPLYCODE");
if (StringUtils.isNotBlank(recode) && recode.equals("0000")) {
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);
LogUtil.adminlog(sqlSession, "推送订单_百旺发票通", "手动推送,总共:" + Extrabills.size() + "条,成功:" + count + "条");
fpt_flag = true;
} else {
log.error("推送订单失败_百旺发票通", "订单号:" + bill.get("bill_id").toString() + "错误码:" + resultMap.get("REPLYCODE") + "错误信息:" + resultMap.get("REPLYMSG") + ", 参数:" + param2);
LogUtil.adminlog(sqlSession, "推送订单失败_百旺发票通", "订单号:" + bill.get("bill_id").toString() + "错误码:" + resultMap.get("REPLYCODE") + "错误信息:" + resultMap.get("REPLYMSG"));
}
}
} catch (Exception e) {
log.error("推送订单异常_百旺发票通", "订单号:" + bill.get("bill_id").toString() + "异常信息:" + e.getMessage() + ", 参数:" + param2);
LogUtil.adminlog(sqlSession, "推送订单异常_百旺发票通", "订单号:" + bill.get("bill_id").toString() + "异常信息:" + e.getMessage());
}
// 当没发送到百旺单机的时候,重新发送
try {
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[" + baiWangTask.dan_ji_userName + "]]></login_name>");
stringBuffer.append("<passwd><![CDATA[" + baiWangTask.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>");
HttpClient client = new HttpClient();
client.getHostConfiguration().setHost(baiWangTask.dan_ji_url, baiWangTask.dan_ji_port, baiWangTask.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"));
Map<String, String> resultMap = new HashMap<>();
resultMap = baiWangTask.parseXml(xml);
String returncode = resultMap.get("returncode");
if (StringUtils.isNotBlank(returncode) && returncode.equals("0")) {
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);
danji_flag = true;
} 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.adminlog(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());
LogUtil.adminlog(sqlSession, "推送订单失败_百旺单机", "订单号:" + bill.get("bill_id").toString() + "错误信息:" + e.getMessage());
continue;
}
}
} catch (Exception e) {
LogUtil.syslog(sqlSession, "推送订单失败_百旺", "错误信息:" + e.getMessage());
e.printStackTrace();
return false;
} finally {
if (status != null && !status.isCompleted()) {
transactionManager.rollback(status);
}
}
return (danji_flag && fpt_flag);
}
}
use of com.itrus.portal.db.Enterprise in project portal by ixinportal.
the class EnterpriseServiceImpl method updateEnterpriseSn.
/**
* 更新企业唯一标识
*
* @param enterprise
* @return
* @throws UserInfoServiceException
*/
public Enterprise updateEnterpriseSn(Enterprise enterprise) throws UserInfoServiceException {
// 根据企业名称查找企业
EnterpriseExample example = new EnterpriseExample();
EnterpriseExample.Criteria criteria = example.or();
criteria.andEnterpriseSnEqualTo(enterprise.getEnterpriseSn());
Enterprise enterprise0 = sqlSession.selectOne("com.itrus.portal.db.EnterpriseMapper.selectByExample", example);
if (null != enterprise0) {
if (!enterprise.getEnterpriseName().equals(enterprise0.getEnterpriseName()) && enterprise.getEnterpriseSn().equals(enterprise0.getEnterpriseSn())) {
// 已经存在相同企业标识了(企业名称不同企业标识相同):
if (enterprise.getEnterpriseNature().equals(3)) {
throw new UserInfoServiceException("组织机构代码已被其他公司注册,请确认输入是否有误");
} else {
throw new UserInfoServiceException("营业执照号或统一社会信用代码已被其他公司注册,请确认输入是否有误");
}
}
}
sqlSession.update("com.itrus.portal.db.EnterpriseMapper.updateByPrimaryKey", enterprise);
sqlSession.flushStatements();
return enterprise;
}
use of com.itrus.portal.db.Enterprise in project portal by ixinportal.
the class EnterpriseServiceImpl method getEnterpriseListByIds.
/**
* 根据企业ids查询企业list
*
* @param enterpriseIds
* @return
*/
public List<Enterprise> getEnterpriseListByIds(List<Long> enterpriseIds) {
EnterpriseExample example = new EnterpriseExample();
EnterpriseExample.Criteria criteria = example.or();
criteria.andIdIn(enterpriseIds);
List<Enterprise> enterpriseList = sqlSession.selectList("com.itrus.portal.db.EnterpriseMapper.selectByExample", example);
return enterpriseList;
}
use of com.itrus.portal.db.Enterprise in project portal by ixinportal.
the class BillServiceImpl method getEnterpriseMapByBills.
/**
* 根据订单list获取对应的企业Map
*
* @param bills
* @return
*/
public Map<Long, Enterprise> getEnterpriseMapByBills(List<Bill> bills) {
Map<Long, Enterprise> enterpriseMap = new HashMap<Long, Enterprise>();
List<Long> enterpriseIds = new ArrayList<Long>();
for (Bill bill : bills) {
enterpriseIds.add(bill.getEnterprise());
}
if (!enterpriseIds.isEmpty()) {
EnterpriseExample example = new EnterpriseExample();
EnterpriseExample.Criteria criteria = example.or();
criteria.andIdIn(enterpriseIds);
enterpriseMap = sqlSession.selectMap("com.itrus.portal.db.EnterpriseMapper.selectByExample", example, "id");
}
return enterpriseMap;
}
use of com.itrus.portal.db.Enterprise in project portal by ixinportal.
the class OrgCodeServiceImpl method updateOrgCodeExtraBill.
/**
* 增值订单重新提交组织机构代码
* @param enterPriseId
* @param enterpriseSn
* @param billId
* @param userInfoId
* @param orgCode
* @param itemStatus
* @param old
* @return
* @throws Exception
*/
public OrgCode updateOrgCodeExtraBill(Long enterPriseId, String enterpriseSn, Long billId, Long userInfoId, OrgCode orgCode, Integer itemStatus, OrgCode old) throws Exception {
File imgDir = filePathUtils.getEnterpriseFile(enterpriseSn);
Enterprise ent = sqlSession.selectOne("com.itrus.portal.db.EnterpriseMapper.selectByPrimaryKey", enterPriseId);
if ((null == orgCode || StringUtils.isBlank(orgCode.getEnterpriseName()) || StringUtils.isBlank(orgCode.getOrgCode())) && ent.getEnterpriseNature() != 2) {
throw new UserInfoServiceException("请提交完整的组织机构代码信息");
}
orgCode.setLastModify(new Date());
orgCode.setEnterprise(enterPriseId);
orgCode.setExtraBill(billId);
orgCode.setUserInfo(userInfoId);
// 审核状态:1未审核,2已审核,3已拒绝
orgCode.setItemStatus(itemStatus);
if (StringUtils.isNotBlank(orgCode.getImgFile()) && !ComNames.USE_OLD_IMG.equals(orgCode.getImgFile())) {
File liceImg = filePathUtils.saveImg(imgDir, null, orgCode.getImgFile(), IMG_DEFAULT_TYPE, IMG_NAME_ORG);
if (liceImg != null && liceImg.isFile()) {
orgCode.setImgFile(liceImg.getName());
orgCode.setImgFileHash(HMACSHA1.genSha1HashOfFile(liceImg));
}
}
sqlSession.update("com.itrus.portal.db.OrgCodeMapper.updateByPrimaryKeySelective", orgCode);
sqlSession.flushStatements();
return orgCode;
}
Aggregations