| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832 |
- 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.Calendar;
- 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.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 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.OrganizationManagementMapper;
- import com.goafanti.common.dao.TDunLogMapper;
- import com.goafanti.common.dao.TOrderBackMapper;
- import com.goafanti.common.dao.TOrderDunMapper;
- import com.goafanti.common.dao.TOrderLogMapper;
- import com.goafanti.common.dao.TOrderNewMapper;
- import com.goafanti.common.dao.TOrderOutsourceMapper;
- 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.enums.OrderLogProcess;
- 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.TOrderLog;
- import com.goafanti.common.model.TOrderNew;
- import com.goafanti.common.model.TOrderOutsource;
- 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.TOrderLogBo;
- import com.goafanti.order.bo.TOrderNewBo;
- import com.goafanti.order.bo.TOrderRefundBo;
- import com.goafanti.order.bo.TOrderTaskBo;
- import com.goafanti.order.bo.OrderOutsourceBo;
- import com.goafanti.order.bo.OrderOutsourceDtails;
- 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<TOrderNewMapper> 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 OrganizationManagementMapper organizationManagementMapper ;
- @Autowired
- private JDBCIdGenerator idGenerator;
- @Autowired
- private AdminMapper adminMapper;
- @Autowired
- private TOrderLogMapper tOrderLogMapper;
- @Autowired
- private NoticeMapper noticeMapper;
- @Autowired
- private OrderService orderService;
- @Autowired
- private TOrderOutsourceMapper tOrderOutsourceMapper;
- @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.setOrderDep(adminMapper.selectByPrimaryKey(TokenManager.getAdminId()).getDepartmentId());
- 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<LockingReleaseBo> 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<TOrderTaskBo> selectOrderTask(String orderNo) {
- return tOrderTaskMapper.selectOrderTask(orderNo);
- }
- @Override
- public int updateServiceOrder(TOrderNew t, Integer isSubmit) {
- TOrderNew t2=tOrderNewMapper.selectByPrimaryKey(t.getOrderNo());
- if(t2.getDeleteSign()==3)throw new BusinessException(new Error( "订单变更锁定中","订单变更锁定中"));
- //判断手机号码是否存在
- 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 (StringUtils.isBlank(t.getOrderDep())) {
- t.setOrderDep(adminMapper.selectByPrimaryKey(TokenManager.getAdminId()).getDepartmentId());
- }
- if (isSubmit==1) {//订单提交
- t.setOrderStatus(OrderNewState.QDDS.getCode());
- t.setProcessStatus(ProcessStatus.YPYXGLY.getCode());
- if (t2.getApproval()==ApprovalNewState.BH.getCode()){
- t.setApproval(ApprovalNewState.DSH.getCode());
- }
- //生成流转
- addOrderLog(t.getOrderNo(),OrderLogProcess.TJ.getCode());
- if (StringUtils.isBlank(t2.getContractNo())) {
- //没有合同编号则生成
- createContractNo(t);
- }
- }
- if (t2.getApproval()==ApprovalNewState.BH.getCode()||
- t2.getOrderStatus()==OrderNewState.QDSHJJ.getCode()||
- t2.getOrderStatus()==OrderNewState.YBH.getCode()) {
- t.setCreateTime(new Date());
- tOrderBackMapper.updateByOrderNoAndBackStatus(t.getOrderNo());
- }
-
-
- return tOrderNewMapper.updateByPrimaryKeySelective(t);
- }
- private void createContractNo(TOrderNew t) {
- //根据订单部门或许合同编号前缀
- OrganizationManagement dep=organizationManagementMapper.selectByPrimaryKey(t.getOrderDep());
- if (dep==null||StringUtils.isBlank(dep.getAbbreviation())) {
- throw new BusinessException(new Error( "该部门缩写不存在","该部门缩写不存在"));
- }
- //根据前缀查询最大编号
- String max=organizationManagementMapper.getMaxAbbreviation(dep.getAbbreviation()+"-");
- //获取日期年份
- Calendar c=Calendar.getInstance();
- int y=c.getWeekYear();
-
- String sno=null;
- if (StringUtils.isBlank(max)||max.length()<13) {
- String cn=""+dep.getAbbreviation()+"-"+y+"0001";
- cn=iterationNo(cn,dep.getAbbreviation(),y,1);
- t.setContractNo(cn);
- }else {
- int ty=Integer.parseInt(max.substring(max.indexOf("-")+1, max.length()-4));
- int no=Integer.parseInt(max.substring(max.length()-4, max.length()));
-
- //得出字符串
- sno = countNo(dep.getAbbreviation(), sno, ty, no);
- //迭代得出最后编码
- sno=iterationNo(sno,dep.getAbbreviation(),ty,no);
- //年份小于等于则获取最大值加1,大于则获取最新年份
- if (y<=ty) {
- t.setContractNo(sno);
- }else {
- t.setContractNo(""+dep.getAbbreviation()+"-"+y+"0001");
- }
- }
- }
- public static void main(String[] args) {
- String max="GZKD1-20190001";
- int ty=Integer.parseInt(max.substring(max.indexOf("-")+1, max.length()-4));
- int no=Integer.parseInt(max.substring(max.length()-4, max.length()));
- System.out.println("ty:"+ty+",no:"+no);
- no++;
- String s="GZKD"+"-"+ty+"000"+no;
- System.out.println(s);
-
- int i=Integer.parseInt(s.substring(s.indexOf("-")+5, s.length()));
- System.out.println(i);
-
- }
- private String iterationNo(String sno ,Object mp, int ty, int no) {
- if (tOrderNewMapper.checkContractNo(sno)>0) {
- int i=Integer.parseInt(sno.substring(sno.indexOf("-")+5, sno.length()));
- sno=countNo(mp, sno, ty, i);
- iterationNo(sno,mp,ty,i);
-
- }
- return sno;
- }
- private String countNo(Object object, String sno, int ty, int no) {
- no++;
- if (no>0&&no<10) {
- sno=object+"-"+ty+"000"+no;
- }else if (no>9&&no<100) {
- sno=object+"-"+ty+"00"+no;
- } else if (no>99&&no<1000) {
- sno=object+"-"+ty+"0"+no;
- } else if(no>1000){
- sno=object+"-"+ty+no;
- }
- return sno;
- }
-
- public void addOrderLog(String orderNo, Integer code) {
- TOrderLog tl=new TOrderLog();
- tl.setOrderNo(orderNo);
- tl.setProcess(code);
- tl.setAid(TokenManager.getAdminId());
- tOrderLogMapper.insertSelective(tl);
-
- }
- @Override
- public TOrderNewBo getOrderNewDetail(String orderNo) {
- TOrderNewBo tOrder= tOrderNewMapper.getOrderNewDetail(orderNo);
- return tOrder;
- }
- @Override
- public int createOrderDun(String orderDun,String orderNo) {
- List<TOrderDun> l= JSON.parseArray(orderDun, TOrderDun.class);
- List<TOrderDun> 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<TOrderNewBo> orderNewList(String name, String orderNo, String starTime, String endTime,Integer specially,Integer distribution,String depId, Integer pageNo,
- Integer pageSize,Integer outsource) {
- Map<String, Object> params = new HashMap<String, Object>();
- if(pageSize==null||pageSize<0)pageSize=10;
- if(pageNo==null||pageNo<0)pageNo=1;
- if (specially!=null&&(specially==0||specially==1||specially==2||specially==4||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(depId)) params.put("depId", depId);
- 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");
- params.put("outsource", outsource);
- Pagination<TOrderNewBo> p = (Pagination<TOrderNewBo>)findPage("selectOrderNewListByPage", "selectOrderNewListCount", params, pageNo, pageSize);
- return p;
- }
-
- @Override
- public int updateOrderNew(String orderNo, Integer orderStatus,String reason,Integer outsource, TOrderOutsource o) {
- TOrderNew t= new TOrderNew();
- TOrderNew t2= tOrderNewMapper.selectByPrimaryKey(orderNo);
- t.setOrderNo(orderNo);
- if (orderStatus==OrderNewState.QDSHTG.getCode()) {
- if (t2.getApproval()==ApprovalNewState.FTP.getCode()||t2.getApproval()==ApprovalNewState.TG.getCode()) {//如果通过分配给财务管理员
- t.setProcessStatus(ProcessStatus.YPCWGLY.getCode());
- }else {
- t.setProcessStatus(ProcessStatus.YPTPSH.getCode());
- }
- if(outsource!=null&&outsource==1) {
- t.setOutsource(outsource);
- addOrderLog(orderNo, OrderLogProcess.FQWB.getCode());
- }else {
- addOrderLog(orderNo, OrderLogProcess.SH.getCode());
- }
- }
- if (outsource==0) {//非外包
- if (orderStatus==OrderNewState.QDSHJJ.getCode()) {//如果不通过新增驳回
- t.setProcessStatus(ProcessStatus.YPYXY.getCode());
- addBackOrder(orderNo, reason);
- addOrderLog(orderNo, OrderLogProcess.BH.getCode());
- }
-
- }else if (outsource==1) {//外包
- o.setRefundStatus(0);
-
- if(o.getId()==null) {
- o.setCreateTime(new Date());
- tOrderOutsourceMapper.insertSelective(o);
- }else {
- tOrderOutsourceMapper.updateByPrimaryKeySelective(o);
- }
- }
- 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<TOrderNewBo> dunOrderNewList(String name, String orderNo, String starTime, String endTime,
- Integer specially, String adminName,String depId,Integer pageNo, Integer pageSize) {
- Map<String, Object> params = new HashMap<String, Object>();
- 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(depId)) params.put("depId", depId);
- if(specially!=null&&specially==1) params.put("aid", TokenManager.getAdminId());;
- if (StringUtils.isNotBlank(adminName)) params.put("adminName", adminName);
- 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<TOrderNewBo> p = (Pagination<TOrderNewBo>)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<TDunLogListBo> 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);
- addOrderLog(t.getOrderNo(), OrderLogProcess.FQTD.getCode());
- return tOrderRefundMapper.insertSelective(t);
- }
- @Override
- public int updateApprovalOrder(String orderNo,Integer confirm,String reason) {
- TOrderNew t=new TOrderNew();
- TOrderNew t2=tOrderNewMapper.selectByPrimaryKey(orderNo);
- t.setOrderNo(orderNo);
- if (confirm==2) {
- t.setApproval(2);
- if(t2.getOutsource()==0)t.setProcessStatus(ProcessStatus.YPCWGLY.getCode());
- addOrderLog(orderNo, OrderLogProcess.TP.getCode());
- } else {
- t.setApproval(3);
- t.setOrderStatus(OrderNewState.YBH.getCode());
- addBackOrder(orderNo, reason);
- addOrderLog(orderNo, OrderLogProcess.BH.getCode());
- }
- return tOrderNewMapper.updateByPrimaryKeySelective(t);
- }
- @Override
- public List<TOrderDun> selectOrderDun(String orderNo) {
-
- return tOrderDunMapper.selectByOrderNoDunSubject(orderNo);
- }
- @Override
- public boolean checkOrderMain(TOrderTask t) {
- List<TOrderTaskBo> list=tOrderTaskMapper.selectOrderTask(t.getOrderNo());
- int flag=0;
- if(t.getMain()==1)flag++;
- for (TOrderTask t2 : list) {
- if(t2.getMain()==1&&t.getId()==null) {
- flag++;
- }else if (t2.getMain()==1&&(!t.getId().equals(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()||tOrder.getOrderStatus()==OrderNewState.QDSHTG.getCode()) {
- return false;
- }
- return true;
- }
- @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<TOrderRefundBo> orderRefundList(String name, String orderNo, String starTime, String endTime, Integer specially,
- Integer pageNo, Integer pageSize) {
- Map<String, Object> params = new HashMap<String, Object>();
- 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<TOrderRefundBo> p = (Pagination<TOrderRefundBo>)findPage("selectOrderRefundListByPage", "selectOrderRefundListCount", params, pageNo, pageSize);
- return p;
-
- }
- @Override
- public boolean checkORderTask(String orderNo) {
- List<TOrderTaskBo> list=tOrderTaskMapper.selectOrderTask(orderNo);
- for (TOrderTaskBo t : list) {
- if (t.getMain()==1) {
- return false;
- }
- }
- return true;
- }
- @Override
- public boolean checkORderDun(String orderNo) {
- List<TOrderDun> 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 adminName,String depId, String starTime, String endTime) {
- if(endTime!=null) endTime=endTime+" 23:59:59";
- List<TOrderNewBo> list=tOrderDunMapper.getOrderDunData(name,orderNo, adminName, depId,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<TOrderTaskBo> 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());
- t.setProcessStatus(ProcessStatus.YPYXY.getCode());
- t.setFinanceId("");
- addBackOrder(orderNo, reason);
- return tOrderNewMapper.updateByPrimaryKeySelective(t);
- }
-
- @Override
- public List<OrderDunTaskBo> 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 = "<div>客户名称: "+ b.getUserName() +"</div><div>订单编号: " + orderNo + "</div>";
- String tite="订单驳回";
- if(StringUtils.isNotBlank(dunId)) {
- TOrderDun tDun=tOrderDunMapper.selectByPrimaryKey(dunId);
- content +="<div>催收时间: " + new SimpleDateFormat("yyyy-MM-dd").format(tDun.getCreateTime()) +
- "</div><div>催收科目: " + OrderDunSubject.getValueByCode(tDun.getDunSubject()) +
- "</div><div>催收情况: " + (tDun.getDunStatus()==2?"已完成":"已启动") +"</div>";
- tite="催收通知";
- }
- //发送驳回邮件
- EmailBo bo = new EmailBo(tite, b.getEmail(), b.getSalesmanName(), a.getDepartmentName(), a.getName(), content);
- if(StringUtils.isNotBlank(b.getEmail())) {
- 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);
- }
- @Override
- public int updateFinance(String orderNo, String newFinance) {
- String aid=TokenManager.getAdminId();
- return tOrderNewMapper.updateFinance(aid,orderNo,newFinance);
-
- }
- @Override
- public List<TOrderLogBo> selectOrderLog(String orderNo) {
- return tOrderLogMapper.selectOrderByNo(orderNo);
- }
-
- }
|