| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787 |
- package com.goafanti.order.service.impl;
- import java.io.IOException;
- import java.io.OutputStream;
- import java.math.BigDecimal;
- import java.text.SimpleDateFormat;
- import java.util.ArrayList;
- import java.util.Date;
- import java.util.HashMap;
- import java.util.List;
- import java.util.Map;
- import java.util.UUID;
- import javax.servlet.http.HttpServletResponse;
- import org.apache.poi.xssf.usermodel.XSSFCell;
- import org.apache.poi.xssf.usermodel.XSSFRow;
- import org.apache.poi.xssf.usermodel.XSSFSheet;
- import org.apache.poi.xssf.usermodel.XSSFWorkbook;
- import org.springframework.beans.factory.annotation.Autowired;
- import org.springframework.stereotype.Service;
- import com.goafanti.admin.bo.AdminListBo;
- import com.goafanti.common.bo.Error;
- import com.goafanti.common.bo.OrderExamineBo;
- import com.goafanti.common.dao.AdminMapper;
- import com.goafanti.common.dao.NewOrderChangeMapper;
- import com.goafanti.common.dao.NewOrderDunMapper;
- import com.goafanti.common.dao.OrderChangeLogMapper;
- import com.goafanti.common.dao.OrderExamineMapper;
- import com.goafanti.common.dao.OrderRefundInvoiceMapper;
- import com.goafanti.common.dao.OrganizationManagementMapper;
- import com.goafanti.common.dao.TChangeDunMapper;
- import com.goafanti.common.dao.TChangeTaskMapper;
- import com.goafanti.common.dao.TOrderBillNewMapper;
- import com.goafanti.common.dao.TOrderDunMapper;
- import com.goafanti.common.dao.TOrderInvoiceMapper;
- import com.goafanti.common.dao.TOrderLogMapper;
- import com.goafanti.common.dao.TOrderNewMapper;
- import com.goafanti.common.dao.TOrderTaskMapper;
- import com.goafanti.common.enums.NoticeStatus;
- import com.goafanti.common.error.BusinessException;
- import com.goafanti.common.model.OrderChangeLog;
- import com.goafanti.common.model.OrderExamine;
- import com.goafanti.common.model.OrderRefundInvoice;
- import com.goafanti.common.model.TChangeDun;
- import com.goafanti.common.model.TChangeTask;
- import com.goafanti.common.model.TOrderDun;
- import com.goafanti.common.model.TOrderNew;
- import com.goafanti.common.model.TOrderTask;
- import com.goafanti.common.model.Admin;
- import com.goafanti.common.model.NewOrderChange;
- import com.goafanti.common.model.NewOrderDun;
- import com.goafanti.common.utils.ExportExcelUtil;
- import com.goafanti.common.utils.StringUtils;
- 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.order.bo.BillBo;
- import com.goafanti.order.bo.InvoiceBo;
- import com.goafanti.order.bo.NewOderCahngeListBo;
- import com.goafanti.order.bo.NewOrderChangeBo;
- import com.goafanti.order.bo.OrderChangeLogBo;
- import com.goafanti.order.bo.OutNewOrderDunBo;
- import com.goafanti.order.bo.TChangeDunOut;
- import com.goafanti.order.bo.TChangeTaskOut;
- import com.goafanti.order.bo.TOrderLogBo;
- import com.goafanti.order.bo.TOrderNewBo;
- import com.goafanti.order.bo.TOrderTaskBo;
- import com.goafanti.order.enums.OrderChangeType;
- import com.goafanti.order.enums.OrderNewState;
- import com.goafanti.order.enums.OrderType;
- import com.goafanti.order.service.NewOrderDunService;
- import com.goafanti.order.service.OrderChangeService;
- import com.goafanti.order.service.OrderNewService;
- import com.goafanti.order.service.OrderService;
- @Service
- public class OrderChangeServiceImpl extends BaseMybatisDao<NewOrderChangeMapper> implements OrderChangeService {
- @Autowired
- private NewOrderChangeMapper newOrderChangeMapper;
- @Autowired
- private OrderChangeLogMapper orderChangeLogMapper;
- @Autowired
- private TOrderNewMapper tOrderNewMapper;
- @Autowired
- private TOrderDunMapper tOrderDunMapper;
- @Autowired
- private TOrderLogMapper tOrderLogMapper;
- @Autowired
- private TOrderTaskMapper tOrderTaskMapper;
- @Autowired
- private TOrderBillNewMapper tOrderBillNewMapper;
- @Autowired
- private TOrderInvoiceMapper tOrderInvoiceMapper;
- @Autowired
- private OrderRefundInvoiceMapper orderRefundInvoiceMapper;
- @Autowired
- private OrganizationManagementMapper organizationManagementMapper;
- @Autowired
- private OrderExamineMapper orderExamineMapper;
- @Autowired
- private OrderService orderService;
- @Autowired
- private NewOrderDunMapper newOrderDunMapper;
- @Autowired
- private JDBCIdGenerator idGenerator;
- @Autowired
- private AdminMapper adminMapper;
- @Autowired
- private OrderNewService orderNewService;
- @Autowired
- private NewOrderDunService newOrderDunService;
- @Autowired
- private TChangeTaskMapper TChangeTaskMapper;
- @Autowired
- private TChangeDunMapper TChangeDunMapper;
-
- @Override
- public int addOrderChange(NewOrderChangeBo t,String startRemarks) {
- TOrderNew ton=new TOrderNew();
- ton.setOrderNo(t.getOrderNo());
- ton.setDeleteSign(2);//将订单置为锁定
- tOrderNewMapper.updateByPrimaryKeySelective(ton);
- BigDecimal invoiceAmount=tOrderInvoiceMapper.conutAmountByOrderNo(t.getOrderNo());
- t.setInvoiceAmount(invoiceAmount);//开票金额
- BigDecimal paymentAmount=tOrderBillNewMapper.conutAmountByOrderNo(t.getOrderNo());
- t.setPaymentAmount(paymentAmount);//收款金额
- //预计成本与预计退款:预计成本=项目价格*数量 预计退款=收款-预计成本
- BigDecimal estimateCost=new BigDecimal(tOrderTaskMapper.selectEstimateCost(t.getOrderNo()));
- t.setEstimateCost(estimateCost);
- t.setEstimateRefundable(paymentAmount.subtract(estimateCost));
- t.setZxsRemarks(startRemarks);
- newOrderChangeMapper.insertSelective(t);
- NewOrderChangeBo ncb=newOrderChangeMapper.selectByorderNoAndStatus(t.getOrderNo());
- List<OutNewOrderDunBo> listDun=newOrderDunMapper.selectListNewOrderDun(t.getOrderNo(),null,null);
- List<TChangeDun> listcd=new ArrayList<>();
- if (listDun!=null&&!listDun.isEmpty()) {
- for (OutNewOrderDunBo d : listDun) {
- TChangeDun cd=new TChangeDun();
- cd.setOrderNo(d.getOrderNo());
- cd.setAid(d.getAid());
- cd.setAppropriationRatio(d.getAppropriationRatio());
- cd.setCid(ncb.getId());
- cd.setDid(d.getId());
- cd.setTid(d.getTid());
- cd.setProjectType(d.getProjectType());
- cd.setDunType(d.getDunType());
- cd.setMoney(d.getMoney());
- cd.setWaitDay(d.getWaitDay());
- cd.setStartTime(d.getStartTime());
- cd.setEffectiveCount(d.getEffectiveCount());
- listcd.add(cd);
- }
- TChangeDunMapper.insertSelectiveList(listcd);
- }
- List<TOrderTaskBo> listTask=tOrderTaskMapper.selectOrderTask(t.getOrderNo());
- List<TChangeTask> listck=new ArrayList<>();
- if (listTask!=null&&!listTask.isEmpty()) {
- for (TOrderTaskBo tt : listTask) {
- TChangeTask ck=new TChangeTask();
- ck.setOrderNo(tt.getOrderNo());
- ck.setCid(ncb.getId());
- ck.setCommodityId(tt.getCommodityId());
- ck.setOrderNo(tt.getOrderNo());
- ck.setCommodityName(tt.getCommodityName());
- ck.setCommodityPrice(tt.getCommodityPrice());
- ck.setCommodityQuantity(tt.getCommodityQuantity());
- ck.setTaskComment(tt.getTaskComment());
- ck.setMain(tt.getMain());
- ck.setTid(tt.getId());
- listck.add(ck);
- }
- TChangeTaskMapper.insertSelectiveList(listck);
- }
- if (t.getType()==OrderChangeType.TDTK.getCode()) {
- OrderChangeLog ocl=new OrderChangeLog();
- ocl.setAuditor(TokenManager.getAdminId());
- ocl.setOrderNo(t.getOrderNo());
- ocl.setRemarks(startRemarks);
- ocl.setChangeId(ncb.getId());
- ocl.setStatus(0);
- sendNotice(0, t);//设置与通过一样发送信息
- orderChangeLogMapper.insertSelective(ocl);
- }
- return 1;
- }
-
- /*
- * 新增审核流程中的
- */
- private void insertOrderExamine(String orderNo) {
- List<TOrderTaskBo> list=tOrderTaskMapper.selectOrderTask(orderNo);
- for (TOrderTaskBo t : list) {
- if (t.getConsultantId()!=null) {
- OrderExamine o=new OrderExamine();
- o.setAid(t.getConsultantId());
- o.setOrderNo(orderNo);
- o.setCreateTime(new Date());
- o.setType(0);//咨询师
- o.setStatus(0);//正常
- orderExamineMapper.insertSelective(o);
- }
- if (t.getManagerId()!=null) {
- OrderExamine o=new OrderExamine();
- o.setAid(t.getManagerId());
- o.setOrderNo(orderNo);
- o.setCreateTime(new Date());
- o.setType(1);//咨询师经理
- o.setStatus(0);//正常
- orderExamineMapper.insertSelective(o);
- }
- }
-
-
- }
- @Override
- public List<NewOrderChangeBo> orderChangeDetails(String orderNo) {
- List<NewOrderChangeBo> list=newOrderChangeMapper.selectByorderNo(orderNo);
- return list;
- }
- @Override
- public NewOrderChangeBo orderChangeDetailsById(Integer id) {
- NewOrderChangeBo nb=newOrderChangeMapper.selectById(id);
- List<OrderExamineBo> consultantExamine =orderExamineMapper.selectByOrderNo(nb.getOrderNo(),0);
- List<OrderExamineBo> managerExamine=orderExamineMapper.selectByOrderNo(nb.getOrderNo(),1);
- int isExamine=orderExamineMapper.selectByOrderNoAndAid(nb.getOrderNo(),TokenManager.getAdminId());
- nb.setConsultantExamine(consultantExamine);
- nb.setManagerExamine(managerExamine);
- nb.setIsExamine(isExamine);
- return nb;
- }
- @Override
- public int pushOrderChangeAudit(String orderNo, String remarks, Integer status,Integer processState,Integer rejectState) {
- NewOrderChangeBo nb=newOrderChangeMapper.selectByorderNoAndStatus(orderNo);
- if (processState==null||(nb.getProcessState()!=9&&processState !=nb.getProcessState()) ) {
- throw new BusinessException(new Error( "变更流程与您所操作流程不匹配","变更流程与您所操作流程不匹配"));
- }
- if (nb.getStatus()==4) {
- throw new BusinessException(new Error( "变更流程已通过审核","变更流程已通过审核"));
- }
- //2通过 3驳回
- if (status==2) {
- //变更类型 0退单退款 1项目及金额变更 2仅项目变更 3仅金额变更 4重报 5赠送
- if(nb.getType() !=null){
- if (nb.getChangeAmount().compareTo(new BigDecimal("0.2"))<0) {//小于则总裁通过,大于则董事长
- if(nb.getProcessState()==7) {//总裁项目变更通过
- nb.setStatus(2);
- }
- }else {
- if(nb.getProcessState()==7) {
- nb.setProcessState(nb.getProcessState()+1);
- }else if(nb.getProcessState()==8) {//董事长项目变更通过
- nb.setStatus(2);
- }
- }
- if(nb.getProcessState()==1){//营销管理通过则设置技术管理员通过表
- if (orderExamineMapper.checkCountStatus(orderNo,null,null)<1) {
- insertOrderExamine(orderNo);
- } else {
- orderExamineMapper.updateByOrderNo(orderNo,null);
- }
- nb.setProcessState(nb.getProcessState()+1);
- }
- //必须放置在咨询师与咨询师经理前,否则会直接通过不走咨询师管理员
- if(nb.getProcessState()==4||nb.getProcessState()==5||nb.getProcessState()==6) {
- nb.setProcessState(nb.getProcessState()+1);
- }
- if(nb.getProcessState()==2){//咨询师
- //找出当时人的审核改为通过
- orderExamineMapper.updateByOrderNoAndAid(orderNo,TokenManager.getAdminId(),0);
- //全部通过了则跳下个流程
- if (orderExamineMapper.checkCountStatus(orderNo,0,0)<1) {
- nb.setProcessState(nb.getProcessState()+1);
- }
- }
- if(nb.getProcessState()==3){//咨询师经理
- //找出当时人的审核改为通过
- orderExamineMapper.updateByOrderNoAndAid(orderNo,TokenManager.getAdminId(),1);
- //全部通过了则跳下个流程
- if (orderExamineMapper.checkCountStatus(orderNo,1,0)<1) {
- nb.setProcessState(nb.getProcessState()+1);
- }
- }
-
- }
- /*else {
- if(nb.getProcessState()==9) {
- //changgeAdopt(nb); 取消订单变更完成
- }
- //流程状态 0营销员 1营销管理员 2技术员 3技术经理 4技术总监 5财务专员(退单) 6财务总监 7总裁 8董事长 9 财务专员(非退单)
- if (nb.getProcessState()==1) nb.setProcessState(7);
- else if (nb.getProcessState()==7)nb.setProcessState(9);
- }*/ //去掉第二条线
- if(nb.getStatus()==3) {
- nb.setStatus(1);//如果驳回数据则改为正常数据
- }
- }else {
- nb.setProcessState(rejectState);
- nb.setStatus(3);//订单变更设置为驳回
- //驳回位置查看有无审核人,没有则直接跳下一个
- if (rejectState==2) {
- if (orderExamineMapper.checkCountStatus(orderNo,0,null)<1) nb.setProcessState(nb.getProcessState()+1);
- }
- if (rejectState==3) {
- if (orderExamineMapper.checkCountStatus(orderNo,1,null)<1) nb.setProcessState(nb.getProcessState()+1);
- }
-
- //如果驳回到技术经理之前则将审核表中状态跳回
- if(nb.getProcessState()==3) {
- orderExamineMapper.updateByOrderNo(orderNo,1);
- }else if (nb.getProcessState()<3) {
- orderExamineMapper.updateByOrderNo(orderNo,null);
- }
-
- }
- OrderChangeLog ocl=new OrderChangeLog();
- ocl.setAuditor(TokenManager.getAdminId());
- ocl.setOrderNo(orderNo);
- ocl.setRemarks(remarks);
- ocl.setChangeId(nb.getId());
- ocl.setStatus(status);
- orderChangeLogMapper.insertSelective(ocl);
- sendNotice(status,nb);
- newOrderChangeMapper.updateByPrimaryKeySelective(nb);
- return 1;
- }
-
- private void sendNotice(Integer status,NewOrderChangeBo nb) {
- //0发起2通过 3驳回
- Integer type=0;
- if(status==0)type=NoticeStatus.ORDER_CHANGE_START.getCode();
- if(status==2)type=NoticeStatus.ORDER_CHANGE_YES.getCode();
- if(status==3)type=NoticeStatus.ORDER_CHANGE_NO.getCode();
- //获取发起人与发起人部门
- AdminListBo a = adminMapper.getDeptNameByAid(TokenManager.getAdminId());
- //获取接收者
- //流程状态 0营销员 1营销管理员 2技术员 3技术经理 4技术总监 5财务专员(退单) 6财务总监 7总裁 8董事长 9 财务专员(非退单)
- List<String> alist = new ArrayList<>();
- TOrderNew o=tOrderNewMapper.selectByPrimaryKey(nb.getOrderNo());
- switch (nb.getProcessState()) {
- case 0:
- alist.add(o.getSalesmanId());
- break;
- case 1:
- alist.addAll(adminMapper.listNameByDepAndName(a.getDepartmentId(), "营销管理员"));
- break;
- case 2:
- alist.addAll(tOrderTaskMapper.listNameByDepAndName(o.getOrderNo(),0));
- break;
- case 3:
- alist.addAll(tOrderTaskMapper.listNameByDepAndName(o.getOrderNo(),1));
- break;
- case 4:
- for (Admin admin : adminMapper.getAdminRoleList("咨询师管理员")) {
- alist.add(admin.getId());
- }
- break;
- case 5:
- alist.add(organizationManagementMapper.selectByPrimaryKey(o.getOrderDep()).getFinanceId());
- break;
- case 6:
- for (Admin admin : adminMapper.getAdminRoleList("财务管理员")) {
- alist.add(admin.getId());
- }
- break;
- case 7:
- if(nb.getStatus()==2) {
- alist.add(organizationManagementMapper.selectByPrimaryKey(o.getOrderDep()).getFinanceId());
- }else {
- for (Admin admin : adminMapper.getAdminRoleList("总裁")) {
- alist.add(admin.getId());
- }
- }
- break;
- case 8:
- if(nb.getStatus()==2) {
- alist.add(organizationManagementMapper.selectByPrimaryKey(o.getOrderDep()).getFinanceId());
- }else {
- for (Admin admin : adminMapper.getAdminRoleList("运营决策者")) {
- alist.add(admin.getId());
- }
- }
- break;
- case 9:
- alist.add(organizationManagementMapper.selectByPrimaryKey(o.getOrderDep()).getFinanceId());
- break;
-
- }
- //发送站内信息与邮件
- orderNewService.pushGeneralSendNoticeAndEmail(alist, type, o.getOrderNo(), TokenManager.getAdminId(),0);
-
- }
-
- /**
- * 变更完成复制出原订单镜像
- */
- private void changeAdopt(NewOrderChangeBo nb) {
- TOrderNew t1=tOrderNewMapper.selectByPrimaryKey(nb.getOrderNo());
- List<TOrderDun> td1=tOrderDunMapper.selectByOrderNo(nb.getOrderNo());
- List<OutNewOrderDunBo> td2=newOrderDunMapper.selectListNewOrderDun(nb.getOrderNo(), null, null);
- List<TOrderTaskBo> tt1=tOrderTaskMapper.selectOrderTask(nb.getOrderNo());
- List<TOrderLogBo> tl1=tOrderLogMapper.selectOrderByNo(nb.getOrderNo());
- String newOrderNo=idGenerator.generateId().toString();
- t1.setOrderNo(newOrderNo);
- nb.setUsedOrder(newOrderNo);
- t1.setDeleteSign(1);//将原订单作废,只能查看
- tOrderNewMapper.insertSelective(t1);
- for (TOrderTaskBo tOrderTaskBo : tt1) {
- tOrderTaskBo.setId(null);
- tOrderTaskBo.setOrderNo(newOrderNo);
- tOrderTaskMapper.insertSelective(tOrderTaskBo);
- }
- for (OutNewOrderDunBo outNewOrderDunBo : td2) {
- outNewOrderDunBo.setId(null);
- outNewOrderDunBo.setOrderNo(newOrderNo);
- newOrderDunMapper.insertSelective(outNewOrderDunBo);
- }
- for (TOrderDun tOrderDun : td1) {
- tOrderDun.setId(UUID.randomUUID().toString());
- tOrderDun.setOrderNo(newOrderNo);
- tOrderDunMapper.insertSelective(tOrderDun);
- }
- for (TOrderLogBo tOrderLogBo : tl1) {
- tOrderLogBo.setId(null);
- tOrderLogBo.setOrderNo(newOrderNo);
- tOrderLogMapper.insertSelective(tOrderLogBo);
- }
- nb.setStatus(4);
- //将订单恢复正常
- TOrderNew orderNew =new TOrderNew();
- orderNew.setOrderNo(nb.getOrderNo());
- orderNew.setDeleteSign(0);
- orderNew.setPrimaryOrder(newOrderNo);
- tOrderNewMapper.updateByPrimaryKeySelective(orderNew);
-
- }
- @Override
- public boolean checkOderNo(String orderNo) {
- int i=newOrderChangeMapper.checkOderNo(orderNo);
- if (i>0) {
- return true;
- }
- return false;
- }
- @Override
- public List<OrderChangeLogBo> selectOrderChangeLogList(String changeId) {
- return orderChangeLogMapper.selectOrderChangeLogList(changeId);
- }
- @SuppressWarnings("unchecked")
- @Override
- public Pagination<NewOderCahngeListBo> selectOrderChangeList(String userName,Integer processState,Integer timeType,String startTime,String endTime,
- String depId,String salesmanName,Integer complete,String orderNo, String contractNo,Integer type,Integer pageSize, Integer pageNo) {
- Map<String, Object> parameter=new HashMap<String, Object>();
- if(pageSize==null||pageSize<0)pageSize=10;
- if(pageNo==null||pageNo<0)pageNo=1;
- parameter.put("processState", processState==null?0:processState);
- parameter.put("complete", complete==null?0:complete);
- if (StringUtils.isNotBlank(userName)) parameter.put("userName", userName);
- if (null!=processState) parameter.put("processState", processState);
- if (StringUtils.isNotBlank(orderNo)) parameter.put("orderNo", orderNo);
- if (StringUtils.isNotBlank(contractNo)) parameter.put("contractNo", contractNo);
- if (null!=type) parameter.put("type", type);
- if (null!=timeType) parameter.put("timeType", timeType);
- if (StringUtils.isNotBlank(startTime)) parameter.put("startTime", startTime);
- if (StringUtils.isNotBlank(endTime)) parameter.put("endTime", endTime+" 23:59:59");
- if (StringUtils.isNotBlank(depId)) parameter.put("depId", depId);
- if (StringUtils.isNotBlank(salesmanName)) parameter.put("salesmanName", salesmanName);
- parameter.put("aid", TokenManager.getAdminId());
- parameter.put("deps", orderService.selectMyDeps());
- Pagination<NewOderCahngeListBo> data = (Pagination<NewOderCahngeListBo>)findPage("selectOrderChangeList", "selectOrderChangeCount", parameter, pageNo, pageSize);
- return data;
- }
- @Override
- public int updateOrderChange(NewOrderChangeBo t,Integer changeType,String startRemarks) {
- NewOrderChange noc=new NewOrderChange();
- t.setProcessState(1);
- noc.setId(t.getId());
- if (changeType==0) {
- noc.setRemarks(t.getRemarks());
- noc.setType(t.getType());
- noc.setVoucherUrl(t.getVoucherUrl());
- noc.setTotalAmount(t.getTotalAmount());
- noc.setSettlementAmount(t.getSettlementAmount());
- noc.setChangeAmount(t.getChangeAmount());
- noc.setApplicant(t.getApplicant());
- noc.setStatus(1);//订单置为正常
- noc.setProcessState(1);//流程置为营销管理员
- noc.setDepName(t.getDepName());
- OrderChangeLog ocl=new OrderChangeLog();
- ocl.setAuditor(TokenManager.getAdminId());
- ocl.setOrderNo(t.getOrderNo());
- ocl.setRemarks(startRemarks==null?"":startRemarks);
- ocl.setChangeId(noc.getId());
- ocl.setStatus(0);
- orderChangeLogMapper.insertSelective(ocl);
- sendNotice(0, t);
- }else if (changeType==2) {
- noc.setCwCost(t.getCwCost());
- noc.setRefundableAmount(t.getRefundableAmount());
- }
- if(changeType!=1)newOrderChangeMapper.updateByPrimaryKeySelective(noc);
- return 1;
- }
- @Override
- public int addOrderRefundInvoice(OrderRefundInvoice o) {
- o.setCreateTime(new Date());
- newOrderChangeMapper.addRefundInvoice(o.getOrderNo(),o.getAmount());
- return orderRefundInvoiceMapper.insertSelective(o);
- }
- @Override
- public int deleteOrderRefundInvoice(Integer id) {
- OrderRefundInvoice or=orderRefundInvoiceMapper.selectByPrimaryKey(id);
- newOrderChangeMapper.subtractRefundInvoice(or.getOrderNo(),or.getAmount());
- return orderRefundInvoiceMapper.deleteByPrimaryKey(id);
- }
- @Override
- public List<OrderRefundInvoice> listOrderRefundInvoice(String orderNo) {
- return orderRefundInvoiceMapper.selectByorderNo(orderNo);
- }
- @Override
- public int pushCompleteOrderChange(NewOrderChangeBo nb) {
- changeAdopt(nb);
- TOrderNew o=pushChange(nb);
- List<String> alist = new ArrayList<>();
- alist.add(o.getSalesmanId());
- newOrderChangeMapper.updateByPrimaryKeySelective(nb);
- orderNewService.pushGeneralSendNoticeAndEmail(alist,NoticeStatus.ORDER_CHANGE_END.getCode(), o.getOrderNo(), TokenManager.getAdminId(),0);
- return 1;
- }
- /**
- * 修改订单数据
- * @param nb
- */
- private TOrderNew pushChange(NewOrderChangeBo nb) {
- TOrderNew o=tOrderNewMapper.selectByPrimaryKey(nb.getOrderNo());
- NewOrderChangeBo nob=newOrderChangeMapper.selectById(nb.getId());
- // 变更类型 0退单退款 1项目及金额变更 2仅项目变更 3仅金额变更 4重报 5赠送
- //退单退款不需改变内容
- if (nob.getType()==OrderChangeType.XMJJEBG.getCode()) {
- o.setTotalAmount(nob.getTotalAmount());
- //处理项目及催款
- pushTaskAndDun(nob.getId(),nob.getOrderNo());
- }else if (nob.getType()==OrderChangeType.JXMBG.getCode()) {
- pushTaskAndDun(nob.getId(),nob.getOrderNo());
- }else if (nob.getType()==OrderChangeType.JJEBG.getCode()) {
- o.setTotalAmount(nob.getTotalAmount());
- }else if (nob.getType()==OrderChangeType.CB.getCode()||nob.getType()==OrderChangeType.ZS.getCode()) {
- pushTaskAndDun(nob.getId(),nob.getOrderNo());
- }
- tOrderNewMapper.updateByPrimaryKeySelective(o);
- return o;
- }
- private void pushTaskAndDun(Integer id,String orderNo) {
- List<TChangeTaskOut> listct=TChangeTaskMapper.selectByCid(id);
- for (TChangeTaskOut cd : listct) {
- TOrderTask ot=new TOrderTask();
- if (cd.getType()==1) {
- ot.setOrderNo(cd.getOrderNo());
- ot.setCommodityId(cd.getCommodityId());
- ot.setOrderNo(cd.getOrderNo());
- ot.setCommodityName(cd.getCommodityName());
- ot.setCommodityPrice(cd.getCommodityPrice());
- ot.setCommodityQuantity(cd.getCommodityQuantity());
- ot.setTaskComment(cd.getTaskComment());
- ot.setMain(cd.getMain());
- ot.setTaskStatus(0);
- tOrderTaskMapper.insertSelective(ot);
- cd.setTid(ot.getId());
- TChangeTaskMapper.updateByPrimaryKeySelective(cd);
- }else if (cd.getType()==2) {
- ot.setId(cd.getTid());
- ot.setCommodityPrice(cd.getCommodityPrice());
- tOrderTaskMapper.updateByPrimaryKeySelective(ot);
- }else if(cd.getType()==3) {
- tOrderTaskMapper.deleteByPrimaryKey(cd.getTid());
- }
- }
- List<TChangeDunOut> listcd=TChangeDunMapper.selectByCid(id);
- for (TChangeDunOut cd : listcd) {
- NewOrderDun nd=new NewOrderDun();
- if (cd.getType()==1) {
- nd.setOrderNo(cd.getOrderNo());
- nd.setAid(cd.getAid());
- nd.setAppropriationRatio(cd.getAppropriationRatio());
- nd.setTid(cd.getTid());
- nd.setProjectType(cd.getProjectType());
- nd.setDunType(cd.getDunType());
- nd.setMoney(cd.getMoney());
- nd.setWaitDay(cd.getWaitDay());
- nd.setStartTime(cd.getStartTime());
- nd.setEffectiveCount(cd.getEffectiveCount());
- newOrderDunMapper.insertSelective(nd);
- }else if (cd.getType()==2) {
- nd.setId(cd.getTid());
- nd.setMoney(cd.getMoney());
- newOrderDunMapper.updateByPrimaryKeySelective(nd);
- }else if(cd.getType()==3) {
- newOrderDunMapper.deleteByPrimaryKey(cd.getTid());
- }
- }
-
-
- }
- @Override
- public Map<String, Object> listOrderInvoiceAndBill(String orderNo) {
- Map<String, Object> map=new HashMap<>();
- List<BillBo>list=tOrderBillNewMapper.selectByOrderNo(orderNo);
- List<InvoiceBo>list2=tOrderInvoiceMapper.selectByOrderNo(orderNo);
- map.put("bill", list);
- map.put("invoice", list2);
- return map;
- }
- @SuppressWarnings("unchecked")
- @Override
- public void exportMyChange(HttpServletResponse response, String userName, Integer processState, Integer timeType,
- String startTime, String endTime, String depId, String salesmanName, Integer complete,String orderNo, String contractNo,Integer type,Integer pageSize,Integer pageNo) throws IOException {
- OutputStream out = response.getOutputStream();
- List<NewOderCahngeListBo>list=(List<NewOderCahngeListBo>) selectOrderChangeList( userName, processState, timeType, startTime, endTime,
- depId, salesmanName, complete, orderNo, contractNo, type, pageSize, pageNo).getList();
- try {
- //设计表头 String[] comment = {"合同编号","订单编号","客户名称","订单部门","订单类型","下单时间","订单状态","合同额(万元)","已付额(万元)","欠款(万元)","订单负责人","变更类型","变更审核状态","变更提交时间"}
- String[] comment = {"合同编号","订单编号","客户名称","订单部门","订单类型","下单时间","订单状态","合同额(万元)","已付额(万元)","欠款(万元)","订单负责人","变更类型","变更审核状态","变更提交时间"};
- String fileName ="开票变更记录表" + new SimpleDateFormat("yyyy-MM-dd HH:mm").format(new Date()) + ".xls";
- //type 0 变更
- XSSFWorkbook wb =ExportExcelUtil.exportTemplateInfoS(comment,"开票变更记录");
- //根据列表编写文档
- XSSFSheet sheet =wb.getSheetAt(0);
- for (NewOderCahngeListBo ob : (List<NewOderCahngeListBo>)list) {
- //新增一行
- XSSFRow r = sheet.createRow(sheet.getLastRowNum()+1);
- for (int i = 0; i < comment.length; i++) {
- //当前列的只
- String o = "";
- switch (comment[i]) {
- // String[] comment = {"合同编号","订单编号","客户名称","订单部门","订单类型","下单时间",
- // "订单状态","合同额(万元)","已付额(万元)","欠款(万元)","订单负责人","变更类型","变更审核状态","变更提交时间"};
- case "合同编号": o = ob.getContractNo(); break;
- case "订单编号": o = ob.getOrderNo().toString(); break;
- case "客户名称": o = ob.getNickname(); break;
- case "订单部门": o = ob.getDepName(); break;
- case "订单类型": o = OrderType.getValueByCode(ob.getOrderType()); break;
- case "下单时间": o = ob.getEstablishTimes(); break;
- case "订单状态": o = OrderNewState.getValueByCode(ob.getOrderStatus()); break;
- case "合同额(万元)": o = ob.getTotalAmount(); break;
- case "已付额(万元)": o = ob.getSettlementAmount(); break;
- case "欠款(万元)": o = ob.getArrears(); break;
- case "订单负责人": o = ob.getSalesmanName(); break;
- case "变更类型": o = OrderChangeType.getValueByCode(ob.getType()); break;
- case "变更审核状态": o = getProcessState(ob.getProcessState(),ob.getStatus()); break;
- case "变更提交时间": o = ob.getCreateTimes(); break;
- default: o = ""; break;
- }
- XSSFCell c = r.createCell(i);
- c.setCellValue(o);
- }
- }
- //返回名称及参数
- response.addHeader("Content-Disposition", "attachment;filename=" + new String(fileName.getBytes(),"iso-8859-1"));
- response.setContentType("application/octet-stream;charset=utf-8");
- // 返回数据流
- wb.write(out);
- out.flush();
- out.close();
- } catch (Exception e) {
- throw new BusinessException(new Error("表格生成错误。"));
- }finally {
- out.flush();
- out.close();
- }
- }
-
-
- public static String getProcessState(Integer processState,Integer status) {
- String str="";
- if (processState == 0) {
- str = "营销员";
- } else if (processState == 1) {
- str = "营销管理员";
- } else if (processState == 2) {
- str = "咨询师";
- } else if (processState == 3) {
- str = "咨询师经理";
- } else if (processState == 4) {
- str = "咨询师总监";
- } else if (processState == 5) {
- str = "财务专员";
- } else if (processState == 6) {
- str = "财务总监";
- } else if (processState == 7) {
- str = "总裁";
- } else if (processState == 8) {
- str = "董事长";
- }
- String num = "";
- if (status == 0) {
- num = "发起";
- } else if (status == 1) {
- num = "审核中";
- } else if (status == 2) {
- num = "通过";
- } else if (status == 3) {
- num = "驳回";
- return num + "到" + str;
- } else if (status == 4) {
- num = "完成";
- }
- if (processState == 7 && status == 2) {
- return "订单变更退票中";
- } else if (processState == 8 && status == 2) {
- return "订单变更退票中";
- } else if (processState >= 7 && status == 4) {
- return "订单变更已完成";
- } else {
- return str + num;
- }
- }
- @Override
- public int addChangeTask(TChangeTask t) {
- t.setType(1);
- return TChangeTaskMapper.insertSelective(t);
- }
- @Override
- public int addChangeDun(TChangeDun d) {
- d.setAid(TokenManager.getAdminId());
- d.setType(1);
- return TChangeDunMapper.insertSelective(d);
- }
- @Override
- public int deleteChangeTask(Integer id) {
- return TChangeTaskMapper.deleteByPrimaryKey(id);
- }
- @Override
- public int deleteChangeDun(Integer id) {
- return TChangeDunMapper.deleteByPrimaryKey(id);
- }
- @Override
- public List<TChangeTaskOut> selectChangeTask(Integer cid) {
- return TChangeTaskMapper.selectByCid(cid);
- }
- @Override
- public List<TChangeDunOut> selectChangeDun(Integer cid) {
- return TChangeDunMapper.selectByCid(cid);
- }
- @Override
- public int updateChangeTask(TChangeTask t) {
- return TChangeTaskMapper.updateByPrimaryKeySelective(t);
- }
- @Override
- public int updateChangeDun(TChangeDun t) {
- return TChangeDunMapper.updateByPrimaryKeySelective(t);
- }
- @Override
- public List<TOrderNewBo> orderChangeUsed(String orderNo) {
- List<TOrderNewBo> list=tOrderNewMapper.selectUsedOrderByOrder(orderNo);
- for (TOrderNewBo t : list) {
- t.setDunList(newOrderDunService.selectListNewOrderDun(orderNo));
- t.setTaskList(orderNewService.selectOrderTask(orderNo));
- }
- return list;
- }
- @Override
- public List<Map<String, String>> getOrderChange(String orderNo) {
- List<Map<String, String>> list=new ArrayList<>();
- list =newOrderChangeMapper.getOrderChange(orderNo);
- return list;
- }
- }
|