package com.goafanti.order.service.impl; import java.io.UnsupportedEncodingException; import java.math.BigDecimal; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.Date; import java.util.HashMap; import java.util.List; import java.util.Map; import java.util.UUID; import javax.mail.MessagingException; import org.apache.commons.lang3.StringUtils; import org.apache.poi.xssf.usermodel.XSSFWorkbook; import org.apache.xmlbeans.impl.xb.xsdschema.Public; import org.slf4j.Logger; import org.slf4j.LoggerFactory; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.factory.annotation.Value; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import com.alibaba.fastjson.JSON; import com.goafanti.admin.bo.AdminListBo; import com.goafanti.common.bo.EmailBo; import com.goafanti.common.bo.Error; import com.goafanti.common.constant.ErrorConstants; import com.goafanti.common.dao.AdminMapper; import com.goafanti.common.dao.NoticeMapper; import com.goafanti.common.dao.OrganizationContactBookMapper; import com.goafanti.common.dao.TDunLogMapper; import com.goafanti.common.dao.TOrderBackMapper; import com.goafanti.common.dao.TOrderDunMapper; import com.goafanti.common.dao.TOrderNewMapper; import com.goafanti.common.dao.TOrderRefundMapper; import com.goafanti.common.dao.TOrderTaskMapper; import com.goafanti.common.dao.UserLockReleaseMapper; import com.goafanti.common.enums.NoticeStatus; import com.goafanti.common.error.BusinessException; import com.goafanti.common.model.Notice; import com.goafanti.common.model.OrganizationContactBook; import com.goafanti.common.model.OrganizationManagement; import com.goafanti.common.model.TDunLog; import com.goafanti.common.model.TOrderBack; import com.goafanti.common.model.TOrderDun; import com.goafanti.common.model.TOrderNew; import com.goafanti.common.model.TOrderRefund; import com.goafanti.common.model.TOrderRefundWithBLOBs; import com.goafanti.common.model.TOrderTask; import com.goafanti.common.utils.ExportExcelUtil; import com.goafanti.common.utils.LoggerUtils; import com.goafanti.common.utils.SendEmailUtil; import com.goafanti.core.mybatis.BaseMybatisDao; import com.goafanti.core.mybatis.JDBCIdGenerator; import com.goafanti.core.mybatis.page.Pagination; import com.goafanti.core.shiro.token.TokenManager; import com.goafanti.customer.bo.LockingReleaseBo; import com.goafanti.order.bo.OrderDunTaskBo; import com.goafanti.order.bo.OrderRefundDetailBo; import com.goafanti.order.bo.TDunLogListBo; import com.goafanti.order.bo.TOrderNewBo; import com.goafanti.order.bo.TOrderRefundBo; import com.goafanti.order.bo.TOrderTaskBo; import com.goafanti.order.enums.ActiveState; import com.goafanti.order.enums.ApprovalNewState; import com.goafanti.order.enums.LiquidationNewState; import com.goafanti.order.enums.OrderDunSubject; import com.goafanti.order.enums.OrderNewState; import com.goafanti.order.enums.ProcessStatus; import com.goafanti.order.enums.ProjectNewStage; import com.goafanti.order.enums.TaskState; import com.goafanti.order.enums.refundState; import com.goafanti.order.service.OrderNewService; import com.goafanti.order.service.OrderService; @Service public class OrderNewServiceImpl extends BaseMybatisDao implements OrderNewService { @Autowired private TOrderNewMapper tOrderNewMapper; @Autowired private TOrderTaskMapper tOrderTaskMapper; @Autowired private TOrderDunMapper tOrderDunMapper; @Autowired private TDunLogMapper tDunLogMapper; @Autowired private TOrderRefundMapper tOrderRefundMapper; @Autowired private TOrderBackMapper tOrderBackMapper; @Autowired private OrganizationContactBookMapper organizationContactBookMapper; @Autowired private JDBCIdGenerator idGenerator; @Autowired private AdminMapper adminMapper; @Autowired NoticeMapper noticeMapper; @Autowired OrderService orderService; @Autowired private UserLockReleaseMapper userLockReleaseMapper; @Value(value = "${mobileRemindCodeTemplate}") private String mobileRemindCodeTemplate = null; @Value(value = "${upload.path}") private String uploadPath = null; @Value(value = "${accessKey}") private String accessKey = null; @Value(value = "${accessSecret}") private String accessSecret = null; Logger logger = LoggerFactory.getLogger(OrderNewServiceImpl.class); @Override public int createServiceOrder(String uid, Integer orderType) { BigDecimal initial = new BigDecimal(0); TOrderNew t=new TOrderNew(); t.setOrderNo(idGenerator.generateId().toString()); t.setOrderType(orderType); t.setOrderStatus(OrderNewState.DQD.getCode()); t.setFirstAmount(initial); t.setTotalAmount(initial); t.setSettlementAmount(initial); t.setLiquidationStatus(LiquidationNewState.WAIT_PAY_FIRST_BALANCE.getCode()); t.setProcessStatus(ProcessStatus.YPYXY.getCode()); t.setProjectStatus(ProjectNewStage.DTJ.getCode()); t.setApproval(ApprovalNewState.FTP.getCode()); t.setDeleteSign(0);//0-正常,1-作废,2-锁定 t.setSalesmanId(TokenManager.getAdminId()); t.setCreater(TokenManager.getAdminId()==null?"1":TokenManager.getAdminId()); t.setCreateTime(new Date()); t.setUpdateTime(new Date()); t.setBuyerId(uid); return tOrderNewMapper.insertSelective(t); } @Override public int addOrderTask(TOrderTask t) { TOrderNew order=tOrderNewMapper.selectByPrimaryKey(t.getOrderNo()); checkOrder(order,t); t.setTaskStatus(TaskState.WFP.getCode()); t.setProjectStatus(ProjectNewStage.DTJ.getCode()); if(t.getCommodityPrice()!=null)order.setTotalAmount(order.getTotalAmount()); return tOrderTaskMapper.insertSelective(t); } public void checkOrder(TOrderNew order,TOrderTask t){ if(order == null) throw new BusinessException(new Error(ErrorConstants.ORDER_NOT_EXIST, "" ,"")); if(order.getDeleteSign() == ActiveState.ABOLISH.getCode()) throw new BusinessException(new Error(ErrorConstants.ORDER_ALREADY_FREEZE, order.getOrderNo(),"")); if(order.getDeleteSign() == ActiveState.LOCKING.getCode()) throw new BusinessException(new Error(ErrorConstants.ORDER_ALREADY_REVOKE, order.getOrderNo(),"")); List list=userLockReleaseMapper.checkTask(order.getBuyerId(),t.getCommodityId()); if (list.size()>0) { for (LockingReleaseBo lockingReleaseBo : list) { if (!lockingReleaseBo.getAid().equals(TokenManager.getAdminId())) { throw new BusinessException(new Error( "该业务已经被其他人锁定","该业务已经被其他人锁定")); } } } } @Override public int updateOrderTask(TOrderTask t) { return tOrderTaskMapper.updateByPrimaryKeySelective(t); } @Override public int delectOrderTask(Integer id) { return tOrderTaskMapper.deleteByPrimaryKey(id); } @Override public List selectOrderTask(String orderNo) { return tOrderTaskMapper.selectOrderTask(orderNo); } @Override public int updateServiceOrder(TOrderNew t, Integer isSubmit) { TOrderNew t2=tOrderNewMapper.selectByPrimaryKey(t.getOrderNo()); //判断手机号码是否存在 if (StringUtils.isNotBlank(t.getContacts())&&StringUtils.isNotBlank(t.getContactMobile())&& organizationContactBookMapper.checkContacts(t2.getBuyerId(), t2.getContactMobile(),TokenManager.getAdminId()==null?"1":TokenManager.getAdminId() )>0) { OrganizationContactBook contactBook=new OrganizationContactBook(); contactBook.setId(UUID.randomUUID().toString()); contactBook.setAid(TokenManager.getAdminId()==null?"1":TokenManager.getAdminId()); contactBook.setUid(t2.getBuyerId()); contactBook.setName(t.getContacts()); contactBook.setMobile(t.getContactMobile()); organizationContactBookMapper.insertSelective(contactBook); } if (isSubmit==1) { t.setOrderStatus(OrderNewState.QDDS.getCode()); t.setProcessStatus(ProcessStatus.YPYXGLY.getCode()); } if (t2.getApproval()==ApprovalNewState.BH.getCode()|| t2.getOrderStatus()==OrderNewState.QDSHJJ.getCode()|| t2.getOrderStatus()==OrderNewState.YBH.getCode()) { tOrderBackMapper.updateByOrderNoAndBackStatus(t.getOrderNo()); } return tOrderNewMapper.updateByPrimaryKeySelective(t); } @Override public TOrderNewBo getOrderNewDetail(String orderNo) { TOrderNewBo tOrder= tOrderNewMapper.getOrderNewDetail(orderNo); return tOrder; } @Override public int createOrderDun(String orderDun,String orderNo) { List l= JSON.parseArray(orderDun, TOrderDun.class); List l2=tOrderDunMapper.selectByOrderNoDunSubject(orderNo); if (l!=null&&!l.isEmpty()) { for (TOrderDun t : l) { if (t.getId()==null||t.getId().equals("")) {//Id为空新增 if (tOrderDunMapper.checkOrderDun(t.getDunSubject(),orderNo)>0) { throw new BusinessException(new Error( "该截点已经存在","该截点已经存在")); } t.setId(UUID.randomUUID().toString()); t.setDunBy(TokenManager.getAdminId()==null?"1":TokenManager.getAdminId()); t.setDunStatus(0);//未启动 tOrderDunMapper.insertSelective(t); }else { tOrderDunMapper.updateByPrimaryKeySelective(t); } } } boolean flag=true; for (TOrderDun t2 : l2) { if (l.isEmpty()) { tOrderDunMapper.deleteByPrimaryKey(t2.getId()); }else { for (TOrderDun t : l) { if (t2.getId().equals(t.getId())) {//查询集合与返回集合比较查出删除项 flag=false; } } if (t2.getId()!=null&&flag) { tOrderDunMapper.deleteByPrimaryKey(t2.getId()); } flag=true; } } return 1; } @SuppressWarnings("unchecked") @Override public Pagination orderNewList(String name, String orderNo, String starTime, String endTime,Integer specially,Integer distribution, Integer pageNo, Integer pageSize) { Map params = new HashMap(); if(pageSize==null||pageSize<0)pageSize=10; if(pageNo==null||pageNo<0)pageNo=1; if (specially!=null&&(specially==0||specially==1||specially==2||specially==5)) { //0 个人 1 营销员管理 2 驳回 3 特批 4 咨询师管理 5部门订单查询 if (specially!=3&&specially!=4) { params.put("aid", TokenManager.getAdminId()==null?"1":TokenManager.getAdminId()); } //(咨询师管理列表 0 未分配 1部分 2全部) if(specially==4) params.put("distribution",distribution); // 计算出所有本部门及所属部门的ID if(specially==1||specially==5) params.put("deps", orderService.selectMyDeps()); } params.put("specially",specially); if (StringUtils.isNotBlank(name)) params.put("name", name); if (StringUtils.isNotBlank(orderNo)) params.put("orderNo", orderNo); if (StringUtils.isNotBlank(starTime)) params.put("starTime", starTime); if (StringUtils.isNotBlank(endTime)) params.put("endTime", endTime+" 23:59:59"); Pagination p = (Pagination)findPage("selectOrderNewListByPage", "selectOrderNewListCount", params, pageNo, pageSize); return p; } @Override public int updateOrderNew(String orderNo, Integer orderStatus,String reason) { TOrderNew t= new TOrderNew(); TOrderNew t2= tOrderNewMapper.selectByPrimaryKey(orderNo); t.setOrderNo(orderNo); if (orderStatus==OrderNewState.QDSHTG.getCode()&&t2.getApproval()==ApprovalNewState.FTP.getCode()) {//如果通过分配给财务管理员 t.setProcessStatus(ProcessStatus.YPCWGLY.getCode()); } if (orderStatus==OrderNewState.QDSHJJ.getCode()) {//如果不通过新增驳回 t.setProcessStatus(ProcessStatus.YPYXY.getCode()); addBackOrder(orderNo, reason); } t.setOrderStatus(orderStatus); return tOrderNewMapper.updateByPrimaryKeySelective(t); } private void addBackOrder(String orderNo, String reason) { TOrderBack ob=new TOrderBack(); TOrderNew tOrder= tOrderNewMapper.selectByPrimaryKey(orderNo); ob.setCreateTime(new Date()); ob.setOrderNo(orderNo); ob.setReason(reason); ob.setBackStatus(0);//待处理 ob.setInitiate(TokenManager.getAdminId()==null?"1":TokenManager.getAdminId()); ob.setAccept(tOrder.getSalesmanId()); try { addNoticAndSendEmail(orderNo, null, NoticeStatus.ORDER_BACK.getCode()); } catch (UnsupportedEncodingException | MessagingException e) { LoggerUtils.error(getClass(), "发送邮件失败", e); } tOrderBackMapper.insertSelective(ob); } @SuppressWarnings("unchecked") @Override public Pagination dunOrderNewList(String name, String orderNo, String starTime, String endTime, Integer specially, Integer pageNo, Integer pageSize) { Map params = new HashMap(); if(pageSize==null||pageSize<0)pageSize=10; if(pageNo==null||pageNo<0)pageNo=1; if (StringUtils.isNotBlank(name)) params.put("name", name); if (StringUtils.isNotBlank(orderNo)) params.put("orderNo", orderNo); if (StringUtils.isNotBlank(starTime)) params.put("starTime", starTime); if (StringUtils.isNotBlank(endTime)) params.put("endTime", endTime+" 23:59:59"); Pagination p = (Pagination)findPage("selectDunOrderNewListByPage", "selectDunOrderNewListCount", params, pageNo, pageSize); return p; } @Override public int createDunLog(String dunId,String dumTime,String remarks) { TDunLog d=new TDunLog(); d.setId(UUID.randomUUID().toString()); d.setDunId(dunId); d.setDumBy(TokenManager.getAdminId()==null?"1":TokenManager.getAdminId()); SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); try { d.setDumTime(sdf.parse(dumTime)); } catch (ParseException e) { e.printStackTrace(); } d.setRemarks(remarks); return tDunLogMapper.insertSelective(d); } @Override public List selectDunLogList(String dunId) { return tDunLogMapper.selectByDunId(dunId); } @Override public int addOrderRefund(TOrderRefundWithBLOBs t) { TOrderNew order =tOrderNewMapper.selectByPrimaryKey(t.getOrderNo()); t.setRefundStatus(refundState.DSH.getCode()); t.setCreateTime(new Date()); t.setInitiate(TokenManager.getAdminId()==null?"1":TokenManager.getAdminId()); //t.setAccept("1"); t.setAccept(order.getFinanceId()); t.setResult(""); TOrderNew tOrder=new TOrderNew(); tOrder.setOrderNo(t.getOrderNo()); tOrder.setOrderStatus(OrderNewState.TDZ.getCode()); tOrderNewMapper.updateByPrimaryKeySelective(tOrder); return tOrderRefundMapper.insertSelective(t); } @Override public int updateApprovalOrder(String orderNo,Integer confirm,String reason) { TOrderNew t=new TOrderNew(); t.setOrderNo(orderNo); if (confirm==2) { t.setApproval(2); t.setProcessStatus(ProcessStatus.YPZXSGLY.getCode()); } else { t.setApproval(3); t.setOrderStatus(OrderNewState.YBH.getCode()); addBackOrder(orderNo, reason); } return tOrderNewMapper.updateByPrimaryKeySelective(t); } @Override public List selectOrderDun(String orderNo) { return tOrderDunMapper.selectByOrderNoDunSubject(orderNo); } @Override public boolean checkOrderMain(TOrderTask t) { List list=tOrderTaskMapper.selectOrderTask(t.getOrderNo()); int flag=0; if (t.getMain()==1) { flag++; } for (TOrderTask t2 : list) { if (t2.getMain()==1&&t.getId()!=t2.getId()) { flag++; } } if (flag>1) { return true; } return false; } @Override public boolean chekeOrderStatus(String orderNo) { TOrderNew tOrder= tOrderNewMapper.selectByPrimaryKey(orderNo); if (tOrder.getOrderStatus()!=OrderNewState.QDDS.getCode()) { return true; } return false; } @Override public boolean chekeApprovalOrderStatus(String orderNo) { TOrderNew tOrder= tOrderNewMapper.selectByPrimaryKey(orderNo); if (tOrder.getApproval()==ApprovalNewState.FTP.getCode()|| tOrder.getOrderStatus()==OrderNewState.QDSHJJ.getCode()|| tOrder.getOrderStatus()==OrderNewState.YBH.getCode()) { return true; } return false; } @Override public int deleteOrderNew(String orderNo) { TOrderNew t=tOrderNewMapper.selectByPrimaryKey(orderNo); if (t.getOrderStatus()==OrderNewState.YBH.getCode()||t.getOrderStatus()==OrderNewState.YTD.getCode()|| t.getOrderStatus()==OrderNewState.DQD.getCode()||t.getOrderStatus()==OrderNewState.QDSHJJ.getCode()) { t.setOrderNo(orderNo); t.setDeleteSign(1);//作废 return tOrderNewMapper.updateByPrimaryKeySelective(t); } return -1; } @Override public boolean checkOderSettlementAmount(String orderNo) { TOrderNew tOrder= tOrderNewMapper.selectByPrimaryKey(orderNo); if (tOrder.getSettlementAmount()==null|| tOrder.getSettlementAmount().doubleValue()==0|| tOrder.getOrderStatus()==OrderNewState.TDZ.getCode()){ return true; } return false; } @SuppressWarnings("unchecked") @Override public Pagination orderRefundList(String name, String orderNo, String starTime, String endTime, Integer specially, Integer pageNo, Integer pageSize) { Map params = new HashMap(); if(pageSize==null||pageSize<0)pageSize=10; if(pageNo==null||pageNo<0)pageNo=1; params.put("aid", TokenManager.getAdminId()==null?"1":TokenManager.getAdminId()); if (StringUtils.isNotBlank(name)) params.put("name", name); if (StringUtils.isNotBlank(orderNo)) params.put("orderNo", orderNo); if (StringUtils.isNotBlank(starTime)) params.put("starTime", starTime); if (StringUtils.isNotBlank(endTime)) params.put("endTime", endTime+" 23:59:59"); Pagination p = (Pagination)findPage("selectOrderRefundListByPage", "selectOrderRefundListCount", params, pageNo, pageSize); return p; } @Override public boolean checkORderTask(String orderNo) { List list=tOrderTaskMapper.selectOrderTask(orderNo); for (TOrderTaskBo t : list) { if (t.getMain()==1) { return false; } } return true; } @Override public boolean checkORderDun(String orderNo) { List list=tOrderDunMapper.selectByOrderNoDunSubject(orderNo); if (list==null||list.size()<1) { return true; }else { return false; } } /** * 获取催款数据 */ @SuppressWarnings("null") @Override public XSSFWorkbook exportOrderDunData(String name, String orderNo, String starTime, String endTime) { if(endTime!=null) endTime=endTime+" 23:59:59"; List list=tOrderDunMapper.getOrderDunData(name,orderNo,starTime,endTime); if (list==null && list.size()==0) { return null; } String[] comment = {"订单编号","签单时间","客户名称","订单状态","签单金额(万元)","项目状态","结算状态","已收款(万元)","订单负责人","催收科目","催款启动日期"}; String filePath = uploadPath + "/OrderDun"; XSSFWorkbook wb = ExportExcelUtil.exportOrderDunData(list, comment, filePath); return wb; } @Override public int updateOrderOver(String orderNo) { TOrderNew t=tOrderNewMapper.selectByPrimaryKey(orderNo); if (t.getLiquidationStatus()!=LiquidationNewState.ALREADY_PAY.getCode()|| t.getProcessStatus()!=ProcessStatus.YQBFPZXSGLY.getCode()) { return -1; } List list=tOrderTaskMapper.selectOrderTask(orderNo); for (TOrderTaskBo task : list) { if (task.getTaskStatus()!=TaskState.CLYWC.getCode()) { return -1; } } t.setOrderStatus(OrderNewState.YJX.getCode()); t.setSettlementTime(new Date()); return tOrderNewMapper.updateByPrimaryKeySelective(t); } @Override public OrderRefundDetailBo orderRefundDetail(String id) { return tOrderNewMapper.orderRefundDetail(id); } @Override public int updateOrderRefund(TOrderRefundWithBLOBs t) { return tOrderRefundMapper.updateByPrimaryKeySelective(t); } @Override public int updatetechnicianBackOrder(String orderNo,String reason) { TOrderNew t=tOrderNewMapper.selectByPrimaryKey(orderNo); if (t.getSettlementAmount().compareTo(new BigDecimal(0))!=0|| t.getProcessStatus()>ProcessStatus.YPZXSGLY.getCode()) { return -1; } t.setOrderStatus(OrderNewState.YBH.getCode()); addBackOrder(orderNo, reason); return tOrderNewMapper.updateByPrimaryKeySelective(t); } @Override public List selectAllOrderDun() { return tOrderDunMapper.getTaskAllOrderDun(); } @Override public void updateOrderDun(TOrderDun tDun) { tOrderDunMapper.updateByPrimaryKeySelective(tDun); } public void addNotic(String orderNo,Integer type,AdminListBo a,TOrderNewBo b) { LoggerUtils.debug(logger, "======================站内消息发送启动==================="); String str=NoticeStatus.getValueByCode(type)+": 订单编号 -"+orderNo+", 操作人:"+a.getDepartmentName()+"-"+a.getName()+"。"; Notice n =new Notice(); n.setId(UUID.randomUUID().toString()); n.setAid(b.getSalesmanId()); n.setNoticeType(type); n.setContent(str); n.setReaded(0);//未读 noticeMapper.insertSelective(n); } public void sendEmail(String orderNo,String dunId,AdminListBo a,TOrderNewBo b) throws UnsupportedEncodingException, MessagingException{ LoggerUtils.debug(logger, "======================邮件信息发送==================="); String content = "
客户名称: "+ b.getUserName() +"
订单编号: " + orderNo + "
"; String tite="订单驳回"; if(StringUtils.isNotBlank(dunId)) { TOrderDun tDun=tOrderDunMapper.selectByPrimaryKey(dunId); content +="
催收时间: " + new SimpleDateFormat("yyyy-MM-dd").format(tDun.getCreateTime()) + "
催收科目: " + OrderDunSubject.getValueByCode(tDun.getDunSubject()) + "
催收情况: " + (tDun.getDunStatus()==2?"已完成":"已启动") +"
"; tite="催收通知"; } //发送驳回邮件 EmailBo bo = new EmailBo(tite, b.getEmail(), b.getSalesmanName(), a.getDepartmentName(), a.getName(), content); LoggerUtils.debug(logger, "tite:"+tite+" Email:"+ b.getEmail()+" 收件人姓名:"+ b.getSalesmanName()+ " 部门:"+a.getDepartmentName()+ " 发件人姓名:"+a.getName()+" 内容:"+ content); SendEmailUtil.getInstance().send(bo); LoggerUtils.debug(logger, "=========================================发送邮件成功"); } @Override public void addNoticAndSendEmail(String orderNo,OrderDunTaskBo t,Integer type) throws UnsupportedEncodingException, MessagingException { TOrderNewBo b = tOrderNewMapper.getSaleIdByOno(type==NoticeStatus.ORDER_DUN.getCode()?t.getOrderNo():orderNo); String id="1"; if (type==NoticeStatus.ORDER_DUN.getCode()) id=b.getSalesmanId(); if (type==NoticeStatus.ORDER_BACK.getCode()) id=TokenManager.getAdminId()==null?"1":TokenManager.getAdminId(); AdminListBo a = adminMapper.getDeptNameByAid(id); sendEmail(type==NoticeStatus.ORDER_DUN.getCode()?t.getOrderNo():orderNo, t==null?null:t.getId(), a, b); addNotic(type==NoticeStatus.ORDER_DUN.getCode()?t.getOrderNo():orderNo,type,a, b); } }