use of com.itrus.portal.db.Delivery in project portal by ixinportal.
the class PsCourierController method confirm.
// 确认配送
@RequestMapping(value = "confirm/{id}", produces = "text/html")
public String confirm(@PathVariable("id") Long id, Model uiModel, @Valid Delivery delivery, @Valid CourierInfo courierInfo, @RequestParam(value = "dvid", required = false) Integer dvid, @RequestParam(value = "itnum", required = false) Integer itnum, @RequestParam(value = "billid", required = false) Integer billid, @RequestParam(value = "ivc", required = false) Integer ivc, @RequestParam(value = "items1", required = false) String items1, @RequestParam(value = "items2", required = false) String items2) {
// 得到配送内容
int itemsnum = 0;
if (items1 != null && items2 != null) {
itemsnum = 3;
} else if (items2 != null) {
itemsnum = Integer.parseInt(items2);
} else {
itemsnum = Integer.parseInt(items1);
}
// 添加配送信息
courierInfo.setCourierItems(itemsnum);
courierInfo.setCourierTime(new Date());
courierInfo.setCourierStatus(1);
courierInfo.setMessageSms(0);
sqlSession.insert("com.itrus.portal.db.CourierInfoMapper.insertSelective", courierInfo);
Bill bill = sqlSession.selectOne("com.itrus.portal.db.BillMapper.selectByPrimaryKey", billid);
Product pdt = sqlSession.selectOne("com.itrus.portal.db.ProductMapper.selectByPrimaryKey", bill.getProduct());
Product product1 = null;
Product product2 = null;
Product product3 = null;
Integer hasKey = 0;
/*if (null != pdt.getIsCombined() && pdt.getIsCombined() ==1){
String[] comb = pdt.getCombinedId().split(",");
product1 = sqlSession.selectOne("com.itrus.portal.db.ProductMapper.selectByPrimaryKey", Long.parseLong(comb[0]));
product2 = sqlSession.selectOne("com.itrus.portal.db.ProductMapper.selectByPrimaryKey", Long.parseLong(comb[1]));
if (null != product1.getUsbKey() || null != product2.getUsbKey()){
hasKey = 1;
}
if(comb.length==3){
product3 = sqlSession.selectOne("com.itrus.portal.db.ProductMapper.selectByPrimaryKey", Long.parseLong(comb[2]));
if (null != product3.getUsbKey()){
hasKey = 1;
}
}
}*/
if (null != bill.getProduct1()) {
product1 = sqlSession.selectOne("com.itrus.portal.db.ProductMapper.selectByPrimaryKey", bill.getProduct1());
if (null != product1.getUsbKey()) {
hasKey = 1;
}
}
if (null != bill.getProduct2()) {
product2 = sqlSession.selectOne("com.itrus.portal.db.ProductMapper.selectByPrimaryKey", bill.getProduct2());
if (null != product2.getUsbKey()) {
hasKey = 1;
}
}
if (null != bill.getProduct3()) {
product3 = sqlSession.selectOne("com.itrus.portal.db.ProductMapper.selectByPrimaryKey", bill.getProduct3());
if (null != product3.getUsbKey()) {
hasKey = 1;
}
}
// itnum=0 为第一次配送
if (itnum == 0) {
// 修改配送地址,并保存
Delivery delivery1 = sqlSession.selectOne("com.itrus.portal.db.DeliveryMapper.selectByPrimaryKey", dvid);
delivery1.setReceiver(delivery.getReceiver());
delivery1.setRvPhone(delivery.getRvPhone());
delivery1.setDetailAdds(delivery.getDetailAdds());
delivery1.setRegionCodes(delivery.getRegionCodes());
sqlSession.update("com.itrus.portal.db.DeliveryMapper.updateByPrimaryKeySelective", delivery1);
}
// itnum=1 为第二次配送,
if (itnum == 1 || itemsnum == 3 || (itemsnum == 1 && ivc == 0) || (ivc == 1 && itemsnum == 2 && (pdt.getUsbKey() == null && hasKey == 0))) {
// 修改bill表里的配送时间,和设置订单状态为完成
bill.setBillStatus(8);
bill.setDeliveryTime(new Date());
sqlSession.update("com.itrus.portal.db.BillMapper.updateByPrimaryKeySelective", bill);
}
List<Map> l1 = sqlSession.selectList("com.itrus.portal.db.CourierInfoMapper.selectCourierInfoMaxId");
// 自动发短信
sendMoreSmsFhtz((long) l1.get(0).get("id"));
String oper = "确认快递配送";
String info = "快递订单: " + courierInfo.getCourierId();
LogUtil.adminlog(sqlSession, oper, info);
return "redirect:/pscourier";
}
use of com.itrus.portal.db.Delivery 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";
}
use of com.itrus.portal.db.Delivery in project portal by ixinportal.
the class APIService method entAuth1.
/*
* @PostMapping(value= "/auth/entAuthPay") public String entAuthPay(
*
* @RequestHeader("Content-Signature") String authHmac,
*
* @RequestParam("appId") String appId,
*
* @RequestParam("productId") String productId,
*
* @RequestParam("orderNumber") String orderNumber,
*
* @RequestParam("enterpriseType") String enterpriseType,
*
* @RequestParam("isThreeInOne") boolean isThreeInOne,
*
* @RequestParam("enterpriseName") String enterpriseName,
*
* @RequestParam("licenseNo") String licenseNo,
*
* @RequestParam("orgCode") String orgCode,
*
* @RequestParam("taxNo") String taxNo,
*
* @RequestParam("legalName") String legalName,
*
* @RequestParam("legalCardType") Integer legalCardType,
*
* @RequestParam("legalIdCardNo") String legalIdCardNo,
*
* @RequestParam("agentName") String agentName,
*
* @RequestParam("agentPhone") String agentPhone,
*
* @RequestParam("agentEmail") String agentEmail,
*
* @RequestParam("agentTelephone")String agentTelephone,
*
* @RequestParam("agentCardType") Integer agentCardType,
*
* @RequestParam("agentIdCardNo")String agentIdCardNo, HttpServletRequest
* request,Model uiModel){ HttpSession session = request.getSession();
* //新创建订单设置为 代支付状态 if(StringUtils.isEmpty(orderNumber)){
*
* //String authHmac = "123";
*
* Map<String, Object> result = this.entAuth(authHmac, appId, productId,
* orderNumber, enterpriseType, isThreeInOne, enterpriseName , licenseNo,
* orgCode, taxNo, legalName, legalCardType, legalIdCardNo, agentName,
* agentPhone , agentEmail, agentTelephone, agentCardType, agentIdCardNo,
* request);
*
* if(result != null && (int)result.get("status") == 1){ Bill bill =
* billService.getBillByOrderNumber(result.get("orderNumber").toString());
* Product product = sqlSession.selectOne(
* "com.itrus.portal.db.ProductMapper.selectByPrimaryKey",
* bill.getProduct()); uiModel.addAttribute("product", product);
*
* bill.setBillStatus(1); bill.setBillSum(product.getPrice()); sqlSession
* .update("com.itrus.portal.db.BillMapper.updateByPrimaryKeySelective",
* bill); //uiModel.addAttribute("webbill", bill);
* session.setAttribute("webbill", bill); UserInfo userInfo =
* sqlSession.selectOne(
* "com.itrus.portal.db.UserInfoMapper.selectByPrimaryKey",
* bill.getUniqueId()); session.setAttribute("webuserInfo", userInfo);
* session.setAttribute("webverifyCodeStatus", true);// 通过 if
* (product.getOnpay() != null && product.getOnpay() != ""){ List<Long>
* onlinepays = new ArrayList<Long>(); String[] onpay =
* (product.getOnpay()).split(","); Map<Integer, String> map = new
* HashMap<Integer, String>(); for (int i = 0; i < onpay.length; i++) {
* OnlinePay op = sqlSession .selectOne(
* "com.itrus.portal.db.OnlinePayMapper.selectByPrimaryKey", onpay[i]);
* map.put(op.getSort(), onpay[i]); } Set<Integer> set = map.keySet();
* Object[] obj = set.toArray(); Arrays.sort(obj); for (int i =
* (onpay.length - 1); i >= 0; i--) { String a = map.get(obj[i]);
* onlinepays.add(Long.parseLong(a)); }
*
* Map<Long, OnlinePay> opMap = sqlSession .selectMap(
* "com.itrus.portal.db.OnlinePayMapper.selectByExample", "id");
* uiModel.addAttribute("opMap", opMap); uiModel.addAttribute("onlinepays",
* onlinepays); Map<Long, PayConfig> pcMap = sqlSession .selectMap(
* "com.itrus.portal.db.PayConfigMapper.selectByExample", "id");
* uiModel.addAttribute("pcMap", pcMap); } Enterprise emterprise =
* sqlSession.selectOne(
* "com.itrus.portal.db.EnterpriseMapper.selectByPrimaryKey",
* bill.getEnterprise()); session.setAttribute("webenterprise",
* emterprise);//得到付款方姓名 DigitalCert digitalCert = sqlSession.selectOne(
* "com.itrus.portal.db.DigitalCertMapper.selectByPrimaryKey",
* product.getCert()); uiModel.addAttribute("digitalCert", digitalCert);
* //期限
*
* if(StringUtils.isNotBlank(product.getPay())){ Transfer transfer =
* sqlSession.selectOne(
* "com.itrus.portal.db.TransferMapper.selectByPrimaryKey",
* Long.parseLong(product.getPay())); uiModel.addAttribute("transfer",
* transfer);//银行账户汇款 } return "ixinweb/zhifu"; } return
* "ixinweb/tijiaoshibai"; }else{ return "ixinweb/tijiaoshibai"; } }
*
* @RequestMapping(value = "/to") public String to(){ return
* "ixinweb/apiResult"; }
*/
/**
* 提交企业认证申请(新加)
*
* @param authHmac
* hmac签名值,采用HmacSHA1算法
* @param appId
* 应用标识
* @param productId
* 项目产品标识
* @param orderNumber
* 申请流水号,审核拒绝修改提交时必填 (创建申请为空,修改申请不为空)
* @param enterpriseType
* 企业类型 1.企业,2.个体工商户,3.事业单位/政府机关
* @param isThreeInOne
* 是否三证合一
* @param enterpriseName
* 企业名称,事业单位名称
* @param licenseNo
* 营业执照注册号或统一社会信用代码,事业单位法人证书编号
* @param orgCode
* 组织机构代码(三证合一时非必填)
* @param taxNo
* 税务登记证号码(三证合一时非必填,或根据业务需要选填)
* @param legalName
* 法定代表人姓名(根据业务需要选填)
* @param legalCardType
* 证件类型(1代表身份证,2护照,3其他)
* @param legalIdCardNo
* 证件号码
* @param agentName
* 代理人姓名
* @param agentPhone
* 代理人手机号
* @param agentEmail
* 代理人邮箱
* @param agentTelephone
* 代理人固定电话(非必填)
* @param agentCardType
* 证件类型(1代表身份证,2护照,3其他)
* @param agentIdCardNo
* 证件号码
* @param detailAdds
* 配送地址
* @param certUid
* 特定证书信息
* @param certsize
* 企业用户证书数量
* @param isenterprisecert
* 是否购买企业证书
* @param productType
* 产品业务类型
* @return status 1: 表示处理正常, billId: 订单编号, orderNumber: 申请流水号 status 0:
* 表示处理失败, message: 失败原因
*/
@PostMapping(value = "/auth/entAuth1")
@ResponseBody
public Map<String, Object> entAuth1(@RequestHeader("Content-Signature") String authHmac, @RequestParam(value = "appId", required = true) String appId, @RequestParam(value = "productId", required = true) String productId, @RequestParam(value = "orderNumber", required = false) String orderNumber, @RequestParam(value = "enterpriseType", required = false) String enterpriseType, @RequestParam(value = "isThreeInOne", required = true) boolean isThreeInOne, @RequestParam(value = "enterpriseName", required = false) String enterpriseName, @RequestParam(value = "licenseNo", required = false) String licenseNo, @RequestParam(value = "orgCode", required = false) String orgCode, @RequestParam(value = "taxNo", required = false) String taxNo, @RequestParam(value = "legalName", required = false) String legalName, @RequestParam(value = "legalCardType", required = false) Integer legalCardType, @RequestParam(value = "legalIdCardNo", required = false) String legalIdCardNo, @RequestParam(value = "agentName", required = false) String agentName, @RequestParam(value = "agentPhone", required = false) String agentPhone, @RequestParam(value = "agentEmail", required = false) String agentEmail, @RequestParam(value = "agentTelephone", required = false) String agentTelephone, @RequestParam(value = "agentCardType", required = false) Integer agentCardType, @RequestParam(value = "agentIdCardNo", required = false) String agentIdCardNo, @RequestParam(value = "detailAdds", required = false) String detailAdds, @RequestParam(value = "certUid", required = false) String certUid, @RequestParam(value = "certsize", required = false) Integer certsize, @RequestParam(value = "isenterprisecert", required = false) Boolean isenterprisecert, @RequestParam(value = "courier", required = false) Integer courier, @RequestParam(value = "cost", required = false) Integer cost, /* @RequestParam(value = "productType", required = false)String
* productType,
*/
HttpServletRequest request) {
log.error("【APIService 提交申请日志】appId=" + appId + ",authHmac=" + authHmac + ",productId=" + productId + ",orderNumber=" + orderNumber + ",enterpriseType=" + enterpriseType + ",isThreeInOne=" + isThreeInOne + ",enterpriseName" + enterpriseName + ",licenseNo=" + licenseNo + ",orgCode=" + orgCode + ",taxNo=" + taxNo + ",legalName=" + legalName + ",legalCardType=" + legalCardType + ",legalIdCardNo=" + legalIdCardNo + ",agentName=" + agentName + ",agentPhone=" + agentPhone + ",agentEmail=" + agentEmail + ",agentTelephone=" + agentTelephone + ",agentCardType=" + agentCardType + ",agentIdCardNo=" + agentIdCardNo + ",detailAdds=" + detailAdds + ",certUid=" + certUid + ",certsize=" + certsize + ",courier=" + courier + ",cost=" + cost + ",isenterprisecert" + isenterprisecert);
Map<String, Object> result = new HashMap<String, Object>();
// 验证参数是否完整
if (StringUtils.isEmpty(authHmac) || StringUtils.isEmpty(appId) || StringUtils.isEmpty(productId) || StringUtils.isEmpty(enterpriseType) || StringUtils.isEmpty(enterpriseName) || StringUtils.isEmpty(licenseNo) || /* 营业执照 */
StringUtils.isEmpty(agentName) || StringUtils.isEmpty(agentPhone) || StringUtils.isEmpty(agentEmail)) {
result.put("status", 0);
result.put("message", "提交的参数信息不完整");
return result;
}
log.error("企业名称位数=" + enterpriseName.length());
if (enterpriseName.length() > 32) {
result.put("status", -7);
result.put("message", "企业名称超过32个汉字,请检查企业名称或联系管理员");
return result;
}
// 得到对应产品信息
Product product = productService.getProductById(StringTools.getLong(productId)[0]);
if (product == null) {
result.put("status", 0);
result.put("message", "提交的项目产品标识有误");
return result;
}
DigitalCert dcert = sqlSession.selectOne("com.itrus.portal.db.DigitalCertMapper.selectByPrimaryKey", product.getCert());
if ("3".equals(dcert.getInitBuy())) {
if (null != isenterprisecert) {
if (isenterprisecert == false) {
isenterprisecert = false;
} else {
isenterprisecert = true;
}
} else {
isenterprisecert = true;
}
} else {
if (null != isenterprisecert) {
if (isenterprisecert == false) {
isenterprisecert = false;
} else {
isenterprisecert = true;
}
} else {
isenterprisecert = null;
}
}
if ("2".equals(dcert.getCertType())) {
if (StringUtils.isEmpty(certUid)) {
result.put("status", 0);
result.put("message", "提交的参数信息不完整,证书信息项不能为空");
return result;
}
}
if (StringUtils.isNotEmpty(product.getDelivery())) {
if (StringUtils.isEmpty(detailAdds)) {
result.put("status", 0);
result.put("message", "提交的参数信息不完整,配送地址不能为空");
return result;
}
}
// 得到应用信息 改成service
Map<String, ApplicationInfo> appInfoMap = CacheCustomer.getAPP_INFO_MAP();
ApplicationInfo applicationInfo = appInfoMap.get(appId);
if (applicationInfo == null) {
ApplicationInfoExample applicationInfoExample = new ApplicationInfoExample();
ApplicationInfoExample.Criteria appInfoExampleCriteria = applicationInfoExample.createCriteria();
appInfoExampleCriteria.andAppIdEqualTo(appId);
applicationInfo = sqlSession.selectOne("com.itrus.portal.db.ApplicationInfoMapper.selectByExample", applicationInfoExample);
}
if (applicationInfo == null) {
result.put("status", 0);
result.put("message", "应用标识不存在");
return result;
}
if (!applicationInfo.getAccessIp().contains(request.getRemoteAddr()) && "1".equals(applicationInfo.getIsIpStatus())) {
result.put("status", -1);
result.put("message", "此IP没有此服务权限");
log.error("APIService_AccsessIp : " + request.getRemoteAddr());
return result;
}
// 验证hmac有效性
log.error("打印isenterprisecert=" + isenterprisecert);
try {
if (isenterprisecert != null) {
String macVal = CertService.hmacSha1(applicationInfo.getSecretKey().getBytes(), (appId + productId + orderNumber + enterpriseType + isThreeInOne + enterpriseName + licenseNo + orgCode + taxNo + legalName + legalCardType + legalIdCardNo + agentName + agentPhone + agentEmail + agentTelephone + agentCardType + agentIdCardNo + detailAdds + certUid + certsize + courier + cost + isenterprisecert).getBytes("utf-8"));
if (!authHmac.equals("HMAC-SHA1 " + macVal)) {
result.put("status", -3);
result.put("message", "服务密钥错误");
return result;
}
} else {
String macVal = CertService.hmacSha1(applicationInfo.getSecretKey().getBytes(), (appId + productId + orderNumber + enterpriseType + isThreeInOne + enterpriseName + licenseNo + orgCode + taxNo + legalName + legalCardType + legalIdCardNo + agentName + agentPhone + agentEmail + agentTelephone + agentCardType + agentIdCardNo + detailAdds + certUid + certsize + courier + cost).getBytes("utf-8"));
if (!authHmac.equals("HMAC-SHA1 " + macVal)) {
result.put("status", -3);
result.put("message", "服务密钥错误");
return result;
}
}
// Base64.encode(HMACSHA1.getHmacSHA1(csr+billId+uid+userId,
// sc.getAddressKey()), false);
} catch (Exception e) {
result.put("status", -2);
result.put("message", "Hmac验证错误");
e.printStackTrace();
return result;
}
// orderNumber==null true:新建 , false:审核拒绝修改提交
if (StringUtils.isEmpty(orderNumber)) {
UserInfo userInfo = null;
Certification certification = null;
// 获取产品的认证等级需要认证的项
certification = certificationService.getSelectById(product.getAuthentication());
DefaultTransactionDefinition def = new DefaultTransactionDefinition();
def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED);
TransactionStatus status = transactionManager.getTransaction(def);
try {
// 判断手机号是否存在
userInfo = userInfoService.getUserInfoByMphone(agentPhone);
if (userInfo != null) {
/*
* result.put("status", 0); result.put("message",
* "该手机号已经存在关联用户"); return result;
*/
} else {
try {
int passNumber = (int) ((Math.random() * 9 + 1) * 10000000);
// 新建用户 随机密码默认
userInfo = userInfoService.registerUserInfo(agentPhone, String.valueOf(passNumber), product.getProject());
} catch (Exception e) {
result.put("status", -4);
result.put("message", "新建用户失败,请重试");
return result;
}
}
/**
* 需要认证的项:0营业执照,1组织机构代码,2税务登记证,3授权书,4法定代表人/经营者 5代理人
*/
if (certification == null) {
result.put("status", -6);
result.put("message", "产品的认证等级未配置需要认证的项");
return result;
}
Long[] items = StringTools.getLong(certification.getCertItems());
// 保存企业信息
Enterprise enterprise = new Enterprise();
enterprise.setEnterpriseName(enterpriseName);
enterprise.setEnterpriseNature(Integer.parseInt(enterpriseType));
enterprise.setAuthenticationLevel(product.getAuthentication());
enterprise = enterpriseService.saveOrUpdateEnterprise(enterprise);
// 保存代理人信息
userInfo.setEmail(agentEmail);
userInfo.setRealName(agentName);
userInfo = userInfoService.updateUserInfo(userInfo);
Delivery deliver = null;
// 判断是否配送
if (StringUtils.isNotEmpty(product.getDelivery())) {
// 保存配送信息
Delivery delivery = new Delivery();
if (courier != null && cost != null) {
delivery.setCourier(courier);
delivery.setCost(cost);
} else {
// 0:1,0:0
String[] deliverPrices = product.getDeliveryPrice().split(",");
for (int j = 0; j < deliverPrices.length; j++) {
// [0]:0,1;[1]:0,0
String[] deliverpi = deliverPrices[j].split(":");
if (Integer.parseInt(deliverpi[0].toString()) != 0) {
String courier1 = deliverpi[0].toString();
String cost1 = deliverpi[1].toString();
delivery.setCourier(Integer.parseInt(courier1));
delivery.setCost(Integer.parseInt(cost1));
}
}
/*String courier1 = product.getDeliveryPrice().split(":")[0];
String cost1 = product.getDeliveryPrice().split(":")[1];
delivery.setCourier(Integer.parseInt(courier1));
delivery.setCost(Integer.parseInt(cost1));*/
}
delivery.setDetailAdds(detailAdds);
delivery.setUserInfo(userInfo.getId());
delivery.setReceiver(agentName);
delivery.setRvPhone(agentPhone);
deliveryService.saveDelivery(userInfo.getId(), agentName, agentPhone, delivery);
deliver = deliveryService.getDelibery(userInfo.getId());
}
/*
String[] uid = {};
JSONArray jsonArray = new JSONArray(product.getCertinfo());
for(int i=0;i<jsonArray.length();i++){
JSONObject jsob = JSONObject.parseObject(jsonArray.get(i).toString());
jsob.getString("inputName");
}*/
// Delivery deliver = deliveryService.getDelibery(userInfo.getId());
// 添加企业-代理人关联关系
userInfoEnterpriseServiceImpl.saveUserInfoEnterprise(userInfo.getId(), enterprise.getId());
// 生成订单
Bill bill = billService.saveBill(userInfo.getId(), enterprise.getId(), product.getId(), null, null, null, null, product.getProject(), 1, product.getPrice(), userInfo.getId(), ComNames.BILL_STATUS_3);
String billId = UniqueIDUtils.genBilUID(bill);
bill.setBillId(billId);
bill.setAppId(appId);
if (deliver != null) {
bill.setDelivery(deliver.getId());
}
if ("2".equals(dcert.getCertType())) {
/*try {
String[] cuid = certUid.split(",");
String s2 = null;
String s3 = null;
JSONArray jsonArray = new JSONArray(product.getCertinfo());
for(int i=0;i<jsonArray.length();i++){
JSONObject jsob = JSONObject.parseObject(jsonArray.get(i).toString());
String iput = jsob.getString("inputName");
System.out.println(iput);
if(iput!=null){
for(int j=0;j<cuid.length;j++){
s2 = ""+iput+"_"+(j+1)+":"+cuid[j]+"";
if(s2!=null){
s2 = ","+iput+"_"+(j+1)+""+":"+""+cuid[j]+"";
}
System.out.println(s2);
}
}
}
s3="{"+s2+"}";*/
// 证书信息项
bill.setUid(certUid);
/*} catch (JSONException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
*/
} else {
// 证书信息项
bill.setUid("{}");
}
// bill.setUid("{}");// 证书信息项
bill.setUid0("{}");
bill.setOrderNumber(billId.substring(4, billId.length()));
// 判断证书数量是否为空
if (certsize != null && certsize > 0) {
// 购买数量
bill.setProductNum(certsize);
} else {
// 购买数量
bill.setProductNum(1);
}
bill.setIsenterprisecert(isenterprisecert);
sqlSession.update("com.itrus.portal.db.BillMapper.updateByPrimaryKey", bill);
sqlSession.flushStatements();
// 保持执照证件信息
// 是否有营业执照信息,默认false没有
boolean hasBl = false;
BusinessLicense businessLicense = new BusinessLicense();
OrgCode org = new OrgCode();
TaxRegisterCert taxregisterCert = new TaxRegisterCert();
IdentityCard identityCard = new IdentityCard();
Agent agent = new Agent();
Proxy proxy = new Proxy();
for (Long item : items) {
if (ComNames.BUSINESS_ITEM.equals(item) && !enterprise.getEnterpriseNature().equals(3)) {
// 事业单位不填写营业执照
hasBl = true;
// 设置企业唯一标识
if (enterprise.getEnterpriseNature().equals(1) || enterprise.getEnterpriseNature().equals(2)) {
// 类型为企业和个体工商户:当三证合一时,企业标识为统一社会信用代码;当非三证合一时,企业标识为营业执照注册号;
enterprise.setEnterpriseSn(licenseNo);
}
// 保存营业执照
businessLicense.setEnterpriseName(enterpriseName);
if (isThreeInOne) {
businessLicense.setBusinessType(1);
} else {
businessLicense.setBusinessType(0);
}
businessLicense.setLicenseNo(licenseNo);
businessLicense = businessService.portSaveBusiness(enterprise.getId(), enterprise.getEnterpriseSn(), bill.getId(), userInfo.getId(), businessLicense, null != businessLicense.getId() ? 2 : 1);
} else if (ComNames.ORG_CODE_ITEM.equals(item)) {
if (hasBl && businessLicense.getBusinessType().equals(1))
// 五证合一企业不用提交组织机构代码、税务登记信息
continue;
if (enterprise.getEnterpriseNature().equals(3)) {
// 类型为政府机关/事业单位:企业标识为组织机构代码
enterprise.setEnterpriseSn(orgCode);
}
// 保存组织机构代码
org.setEnterpriseName(enterpriseName);
org.setOrgCode(orgCode);
org = orgCodeService.saveOrgCode(enterprise.getId(), enterprise.getEnterpriseSn(), bill.getId(), userInfo.getId(), org, null != org.getId() ? 2 : 1);
} else if (ComNames.TAX_CERT_ITEM.equals(item)) {
if (hasBl && businessLicense.getBusinessType().equals(1))
// 五证合一企业不用提交组织机构代码、税务登记信息
continue;
// 保存税务登记证
if (enterprise.getEnterpriseNature().equals(3))
// 事业单位不填写税务登记信息
continue;
taxregisterCert.setEnterpriseName(enterpriseName);
taxregisterCert.setCertNo(taxNo);
taxregisterCert = taxCertService.saveTaxCert(enterprise.getId(), enterprise.getEnterpriseSn(), bill.getId(), userInfo.getId(), taxregisterCert, null != taxregisterCert.getId() ? 2 : 1);
} else if (ComNames.IDENTITY_CARD_ITEM.equals(item)) {
// 保存法定代表人
identityCard.setEnterpriseName(enterpriseName);
identityCard.setName(legalName);
identityCard.setCardType(legalCardType);
identityCard.setIdCode(legalIdCardNo);
identityCard = identityCardService.portSaveIdentityCard(enterprise.getId(), enterprise.getEnterpriseSn(), bill.getId(), userInfo.getId(), identityCard, null != identityCard.getId() ? 2 : 1);
} else if (ComNames.AGENT_ITEM.equals(item)) {
// 保存代理人
agent.setEnterpriseName(enterpriseName);
agent.setName(agentName);
agent.setIdCode(agentIdCardNo);
agent.setCardType(agentCardType);
agent = agentService.portSaveAgent(enterprise.getId(), enterprise.getEnterpriseSn(), bill.getId(), userInfo.getId(), agent, null != agent.getId() ? 2 : 1);
} else if (ComNames.PROXY_ITEM.equals(item)) {
// 保存授权书
proxy = proxyService.portSaveProxy(enterprise.getId(), userInfo.getUniqueId(), bill.getId(), userInfo.getId(), proxy);
}
}
// 更新企业唯一标识
enterprise = enterpriseService.updateEnterpriseSn(enterprise);
transactionManager.commit(status);
// 返回第三方数据
result.put("status", 1);
result.put("billId", bill.getBillId());
result.put("orderNumber", bill.getOrderNumber());
// 记录日志
UserLog userlog = new UserLog();
userlog.setProject(userInfo.getProject());
userlog.setType("购买产品");
userlog.setInfo(userInfo.getmPhone() + "购买了" + product.getName() + ",应用标识:" + appId);
userlog.setHostId("未知");
userlog.setSn(null == userInfo.getUniqueId() ? null : userInfo.getUniqueId());
LogUtil.userlog(sqlSession, userlog);
return result;
} catch (Exception e) {
e.printStackTrace();
if (!status.isCompleted())
transactionManager.rollback(status);
UserLog userlog = new UserLog();
userlog.setProject(product.getProject());
userlog.setType("购买产品");
userlog.setInfo("url:/api/auth/search,应用标识:" + appId + ",详细错误:" + e.getMessage());
userlog.setHostId("未知");
userlog.setSn(null == userInfo.getUniqueId() ? null : userInfo.getUniqueId());
LogUtil.userlog(sqlSession, userlog);
if (e.getMessage().contains("请提交完整") || e.getMessage().contains("请确认输入是否有误")) {
result.put("status", 0);
result.put("message", e.getMessage());
return result;
}
result.put("status", -4);
result.put("message", "服务端出现未知错误,请联系管理员");
return result;
} finally {
if (!status.isCompleted())
transactionManager.rollback(status);
}
} else {
// 提交企业认证申请(审核拒绝修改提交时)
Bill bill = billService.getBillByOrderNumber(orderNumber);
if (bill == null) {
result.put("status", -5);
result.put("message", "申请流水号不存在");
return result;
}
UserInfo userInfo = userInfoService.getUserInfoByBillId(bill.getId());
Enterprise enterprise = enterpriseService.getEnterpriseById(bill.getEnterprise());
if (bill.getBillStatus() != ComNames.BILL_STATUS_4) {
result.put("status", -5);
result.put("message", "该订单未审核拒绝");
return result;
}
// 根据订单id获取产品需要认证项,
List<String> certItems = sqlSession.selectList("com.itrus.portal.db.CertificationMapper.selectCertItemsByBillId", bill.getId());
if (null == certItems || certItems.isEmpty()) {
result.put("status", -4);
result.put("message", "服务端出现异常,请联系管理员");
return result;
}
// 记录旧的企业唯一标识:
String oldEnterpriseSn = enterprise.getEnterpriseSn();
// 设置企业唯一标识
if (enterpriseType.equals(1) || enterpriseType.equals(2)) {
// 类型为企业和个体工商户:当三证合一时,企业标识为统一社会信用代码;当非三证合一时,企业标识为营业执照注册号;
enterprise.setEnterpriseSn(licenseNo);
}
if (enterpriseType.equals(3)) {
// 类型为政府机关/事业单位:企业标识为组织机构代码
enterprise.setEnterpriseSn(orgCode);
}
// 修改企业名称
enterprise.setEnterpriseName(enterpriseName.replace(" ", ""));
// 修改企业性质
enterprise.setEnterpriseNature(Integer.parseInt(enterpriseType));
DefaultTransactionDefinition def = new DefaultTransactionDefinition();
def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED);
TransactionStatus status = transactionManager.getTransaction(def);
try {
// 将参数传入对象
BusinessLicense businessLicense = new BusinessLicense();
OrgCode orgCd = new OrgCode();
TaxRegisterCert taxregisterCert = new TaxRegisterCert();
IdentityCard identityCard = new IdentityCard();
Agent agent = new Agent();
Proxy proxy = new Proxy();
businessLicense.setEnterpriseName(enterpriseName);
if (isThreeInOne) {
businessLicense.setBusinessType(1);
} else {
businessLicense.setBusinessType(0);
}
businessLicense.setLicenseNo(licenseNo);
orgCd.setEnterpriseName(enterpriseName);
orgCd.setOrgCode(orgCode);
taxregisterCert.setEnterpriseName(enterpriseName);
taxregisterCert.setCertNo(taxNo);
identityCard.setEnterpriseName(enterpriseName);
identityCard.setName(legalName);
identityCard.setCardType(legalCardType);
identityCard.setIdCode(legalIdCardNo);
agent.setEnterpriseName(enterpriseName);
agent.setName(agentName);
agent.setIdCode(agentIdCardNo);
agent.setCardType(agentCardType);
// 删除订单关联的旧认证项,新增订单对应的新认证项
billWebService.portSaveBillAuthenticationItems(certItems.get(0), Integer.parseInt(enterpriseType), bill.getId(), businessLicense, orgCd, taxregisterCert, identityCard, agent, proxy, enterprise, userInfo);
// 3、判断该订单对应的企业的认证项是否为通过,若是通过,则重新设置为不通过
if (null != enterprise.getAuthenticationLevel())
enterprise.setAuthenticationLevel(product.getAuthentication());
if (null != enterprise.getHasBl())
enterprise.setHasBl(null);
if (null != enterprise.getHasOrgCode())
enterprise.setHasOrgCode(null);
if (null != enterprise.getHasTaxCert())
enterprise.setHasTaxCert(null);
if (null != enterprise.getHasIdCard())
enterprise.setHasIdCard(null);
if (null != enterprise.getHasAgent())
enterprise.setHasAgent(null);
sqlSession.update("com.itrus.portal.db.EnterpriseMapper.updateByPrimaryKey", enterprise);
bill.setBillStatus(ComNames.BILL_STATUS_3);
sqlSession.update("com.itrus.portal.db.BillMapper.updateByPrimaryKeySelective", bill);
transactionManager.commit(status);
// 企业标识改变后,将旧目录中的图片复制到新目录中
if (!oldEnterpriseSn.equals(enterprise.getEnterpriseSn())) {
CopyFile.copyFile(systemConfigService.getTrustDir().getPath() + File.separator + oldEnterpriseSn, systemConfigService.getTrustDir().getPath() + File.separator + enterprise.getEnterpriseSn());
}
// 判断代理人手机号是否存在 true:把全部订单关联到新手机号用户
UserInfo userInfo1 = userInfoService.getUserInfoByMphone(agentPhone);
if (userInfo1 != null) {
BillExample be = new BillExample();
BillExample.Criteria bec = be.createCriteria();
bec.andUniqueIdEqualTo(userInfo.getId());
List<Bill> billList = sqlSession.selectList("com.itrus.portal.db.BillMapper.selectByExample", be);
// 循环修改订单关联的用户信息
for (Bill b : billList) {
b.setUniqueId(userInfo1.getId());
sqlSession.update("com.itrus.portal.db.BillMapper.updateByPrimaryKeySelective", b);
}
userInfo1.setEnterprise(userInfo.getEnterprise());
sqlSession.update("com.itrus.portal.db.UserInfoMapper.updateByPrimaryKeySelective", userInfo1);
userInfo.setEnterprise(null);
sqlSession.update("com.itrus.portal.db.UserInfoMapper.updateByPrimaryKeySelective", userInfo);
UserinfoEnterpriseExample uee = new UserinfoEnterpriseExample();
UserinfoEnterpriseExample.Criteria ueec = uee.createCriteria();
ueec.andUserInfoEqualTo(userInfo.getId());
List<UserinfoEnterprise> ueList = sqlSession.selectList("com.itrus.portal.db.UserinfoEnterpriseMapper.selectByExample", uee);
for (UserinfoEnterprise ue : ueList) {
ue.setUserInfo(userInfo1.getId());
sqlSession.update("com.itrus.portal.db.UserinfoEnterpriseMapper.updateByPrimaryKeySelective", ue);
}
} else {
userInfo.setmPhone(agentPhone);
sqlSession.update("com.itrus.portal.db.UserInfoMapper.updateByPrimaryKeySelective", userInfo);
}
result.put("status", 1);
result.put("billId", bill.getBillId());
} catch (UserInfoServiceException e) {
if (!status.isCompleted())
transactionManager.rollback(status);
result.put("status", -4);
result.put("message", "服务端出现未知错误,请联系管理员");
return result;
} catch (Exception e) {
e.printStackTrace();
if (!status.isCompleted())
transactionManager.rollback(status);
UserLog userlog = new UserLog();
userlog.setType("修改订单");
userlog.setInfo("url:/api/auth/entAuth1,应用标识:" + appId + ",详细错误:" + e.getMessage());
userlog.setHostId("未知");
userlog.setProject(userInfo.getProject());
LogUtil.userlog(sqlSession, userlog);
result.put("status", -4);
result.put("message", "服务端出现未知错误,请联系管理员");
if (e.getMessage().contains("有误")) {
result.put("status", 0);
result.put("message", e.getMessage());
}
return result;
} finally {
if (!status.isCompleted())
transactionManager.rollback(status);
}
return result;
}
}
use of com.itrus.portal.db.Delivery in project portal by ixinportal.
the class PsCourierController method sendMoreSmsFhtz.
/**
* 发送属于快递配送的短信
*/
private Map<String, Object> sendMoreSmsFhtz(Long pcId) {
Map<String, Object> retMap = new HashMap<String, Object>();
// 0标识失败,1标识成功
retMap.put("retCode", 0);
try {
CourierInfo ci = sqlSession.selectOne("com.itrus.portal.db.CourierInfoMapper.selectByPrimaryKey", pcId);
if (null == ci) {
retMap.put("retMsg", "发送短信失败,未找到对应的快递配送记录");
return retMap;
}
Bill bill = sqlSession.selectOne("com.itrus.portal.db.BillMapper.selectByPrimaryKey", ci.getBill());
CourierExample courierex = new CourierExample();
Map<Long, Courier> couriermap = sqlSession.selectMap("com.itrus.portal.db.CourierMapper.selectByExample", courierex, "id");
// 查找对应项目的消息模版:FHTZ
MessageTemplate messageTemplate = messageTemplateService.getMsgTemp(bill.getProject(), "FHTZ");
if (null == messageTemplate) {
retMap.put("retMsg", "发送短信失败,未找到对应的快递配送消息模版");
return retMap;
}
String content = messageTemplate.getMessageContent();
if (StringUtils.isBlank(content) || content.indexOf("cItems") == -1 || content.indexOf("cId") == -1 || content.indexOf("cName") == -1) {
retMap.put("retMsg", "发送短信失败,快递配送消息模版配置错误");
return retMap;
}
String str = null;
if (ci.getCourierItems() == 1) {
str = "电子钥匙";
}
if (ci.getCourierItems() == 2) {
str = "发票";
}
if (ci.getCourierItems() == 3) {
str = "电子钥匙和发票";
}
content = content.replaceAll("cItems", str);
content = content.replaceAll("cId", ci.getCourierId());
content = content.replaceAll("cName", couriermap.get(ci.getCourier()).getCompanyName());
Delivery delivery = sqlSession.selectOne("com.itrus.portal.db.DeliveryMapper.selectByPrimaryKey", bill.getDelivery());
if (smsSendService.sendSms(delivery.getRvPhone(), content, "发货通知", bill.getProject(), bill.getUniqueId(), bill.getBillId())) {
ci.setMessageSms(1);
sqlSession.update("com.itrus.portal.db.CourierInfoMapper.updateByPrimaryKeySelective", ci);
retMap.put("retCode", 1);
retMap.put("retMsg", "发送短信成功");
}
} catch (Exception e) {
e.printStackTrace();
retMap.put("retMsg", "发送短信失败,errmsg:" + e.getMessage());
return retMap;
}
return retMap;
}
Aggregations