12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075 |
- package com.steerinfo.dil.service.impl;
- import com.baomidou.mybatisplus.extension.api.R;
- import com.steerinfo.dil.feign.AmsFeign;
- import com.steerinfo.dil.feign.IMFeign;
- import com.steerinfo.dil.feign.TmsTruckFeign;
- import com.steerinfo.dil.mapper.*;
- import com.steerinfo.dil.model.*;
- import com.steerinfo.dil.service.IOmstruckOrderService;
- import com.steerinfo.dil.util.DataChange;
- import io.swagger.models.auth.In;
- import org.springframework.beans.factory.annotation.Autowired;
- import org.springframework.stereotype.Service;
- import org.springframework.transaction.annotation.Transactional;
- import java.math.BigDecimal;
- import java.text.SimpleDateFormat;
- import java.util.*;
- /**
- * OmstruckOrder服务实现:
- *
- * @author generator
- * @version 1.0-SNAPSHORT 2021-10-15 09:37
- * 类描述
- * 修订历史:
- * 日期:2021-10-15
- * 作者:generator
- * 参考:
- * 描述:OmstruckOrder服务实现
- * @Copyright 湖南视拓信息技术股份有限公司. All rights reserved.
- * @see null
- */
- @Service(value = "omstruckOrderService")
- public class OmstruckOrderServiceImpl implements IOmstruckOrderService {
- @Autowired
- private OmstruckOrderMapper omstruckOrderMapper;
- @Autowired
- private OmstruckOrderMaterialMapper omstruckOrderMaterialMapper;
- @Autowired
- private AmsFeign amsFeign;
- @Autowired
- private TmsTruckFeign tmsTruckFeign;
- @Autowired
- private IMFeign imFeign;
- @Autowired
- RmsCapacityMapper rmsCapacityMapper;
- @Autowired
- RmsDriverCapacityMapper rmsDriverCapacityMapper;
- @Autowired
- AmstruckInwardPlanMapper amstruckInwardPlanMapper;
- @Autowired
- OmstruckOrderSeparateServiceImpl omstruckOrderSeparateService;
- @Autowired
- OmstruckOrderSeparateMapper omstruckOrderSeparateMapper;
- /**
- * 用于远程调用运输订单新增
- *
- * @param omstruckOrder
- * @return
- */
- @Override
- public int insertSelective(OmstruckOrder omstruckOrder) {
- return omstruckOrderMapper.insertSelective(omstruckOrder);
- }
- /**
- * 查询所有运输订单
- * 获取已下发的运输订单 用于websocket
- *
- * @param map
- * @return
- */
- @Override
- public List<Map<String, Object>> getAllTruckOrder(Map<String, Object> map) {
- return omstruckOrderMapper.getAllTruckOrder(map);
- }
- /**
- * 新增运输订单
- *
- * @param map
- * @return
- */
- @Override
- @Transactional
- public int addPurOrder(Map<String, Object> map) {
- BigDecimal orderType = DataChange.dataToBigDecimal(map.get("orderType"));
- int i = 0;
- switch (orderType.intValue()) {
- case 1:
- case 2:
- case 3:
- i = dispatchSteelOrder(map);//新增焦炭发运计划订单
- break;
- case 4:
- break;
- case 5:
- case 6:
- case 7:
- case 8:
- case 17:
- case 18:
- i = addCGPurOrders(map);
- break;
- // case 8:
- // i = addCGPurOrder(map); //新增采购运输订单
- // break;
- case 9:
- break;
- case 10:
- break;
- case 11:
- }
- return i;
- }
- /**
- * 新增采购其他订单
- * @return
- */
- public int addCGPurOrders(Map<String, Object> map){
- //从map中获取司机运力列表
- List<Map<String, Object>> driverCapacityIdList = (List<Map<String, Object>>) map.get("driverCapacityIdList");
- BigDecimal purchaseOrderId = DataChange.dataToBigDecimal(map.get("purchaseOrderId"));
- //是否一车多趟 有则更新采购订单
- Object isMoreTrips = map.get("isMoreTrips");
- if(isMoreTrips != null){
- boolean trips = (boolean) isMoreTrips;
- if(trips){
- //更新采购订单为一车多趟类型
- omstruckOrderSeparateMapper.updateAPOisMoreTrips(DataChange.dataToBigDecimal(map.get("purchaseOrderId")));
- }
- }
- //物资ID
- Object materialId = map.get("materialId");
- BigDecimal orderType = DataChange.dataToBigDecimal(map.get("orderType"));
- //预计进厂时间
- Date orderEntryTime = null;
- if(map.get("orderEntryTime") != null){
- try {
- orderEntryTime = new Date((long) map.get("orderEntryTime"));
- } catch (Exception e) {
- System.out.println("预估进厂日期转换失败");
- }
- }
- int count = 0;
- for (Map<String, Object> capacityMap : driverCapacityIdList) {
- map.put("carrierId",capacityMap.get("carrierId"));
- map.put("priceId",capacityMap.get("priceId"));
- //添加运输订单
- OmstruckOrder omstruckOrder = generateOmsTruckOrder(map);
- omstruckOrder.setOrderPlanId(purchaseOrderId);
- omstruckOrder.setCapacityId(DataChange.dataToBigDecimal(capacityMap.get("capacityId"))); //添加运力ID
- omstruckOrder.setOrderEntryTime(orderEntryTime);
- count += omstruckOrderMapper.insertSelective(omstruckOrder);
- BigDecimal orderId = omstruckOrder.getOrderId();
- //添加运输订单子表
- capacityMap.put("materialId", materialId);
- capacityMap.put("orderType", orderType);
- addOrderMaterial(capacityMap,orderId);
- //添加总实绩
- capacityMap.put("orderId", orderId);
- tmsTruckFeign.addTotalResult(capacityMap);
- }
- return count;
- }
- /**
- * 新增采购进口矿运输订单订单
- *
- * @param map
- * @return
- */
- @Transactional
- public int addCGPurOrder(Map<String, Object> map) {
- //生成运输订单号和主键
- OmstruckOrder omstruckOrder = generateOmsTruckOrder(map);
- Object orderEntryTime = map.get("orderEntryTime");
- if (orderEntryTime != null) {
- omstruckOrder.setOrderEntryTime(new Date((long) orderEntryTime)); //新增预计进厂时间
- }
- if (map.get("orderMaterialWeight") != null) {
- amsFeign.updateMaterial(map); //更改运输计划子表 增加已分配重量 减少未分配重量 feign调用ams
- }
- //添加运力Id
- BigDecimal capacityId = DataChange.dataToBigDecimal(map.get("capacityId"));
- omstruckOrder.setCapacityId(capacityId);
- //新增运输订单
- omstruckOrderMapper.insertSelective(omstruckOrder);
- //更新运力状态为待运输:2
- // map.put("capacityStatus", 2);
- // omstruckOrderMapper.updateCapacityByCarIdOrNum(map);
- //新增运输订单子表
- addOrderMaterial(map, omstruckOrder.getOrderId());
- //新增实绩总表关联订单 feign 调用truckTms
- map.put("orderId", omstruckOrder.getOrderId());
- tmsTruckFeign.addTotalResult(map);
- return 1;
- }
- /**
- * 生成运输订单实体类
- */
- public OmstruckOrder generateOmsTruckOrder(Map<String, Object> map) {
- BigDecimal orderType = DataChange.dataToBigDecimal(map.get("orderType"));
- OmstruckOrder omstruckOrder = new OmstruckOrder();
- //生成订单主键Id
- BigDecimal maxId = omstruckOrderMapper.selectMaxId();
- omstruckOrder.setOrderId(maxId);
- //生成运输订单号
- int id = maxId.intValue();
- String orderNumber = DataChange.generateEightDigitsNumber("WYSDD", id);
- omstruckOrder.setOrderNumber(orderNumber);
- //设置线路
- omstruckOrder.setLineId(DataChange.dataToBigDecimal(map.get("lineId")));
- //添加当前订单所属承运商Id与运价ID
- Object carrierId = map.get("carrierId");
- Object priceId = map.get("priceId");
- if(carrierId != null) omstruckOrder.setCarrierId(DataChange.dataToBigDecimal(carrierId));
- if (priceId != null) omstruckOrder.setPriceId(DataChange.dataToBigDecimal(priceId));
- //运单状态 刚分配默认为未下发
- omstruckOrder.setOrderStatus(new BigDecimal(3));
- switch (orderType.intValue()) {
- case 1:
- omstruckOrder.setOrderPlanId(DataChange.dataToBigDecimal(map.get("saleOrderMaterialId")));
- break;
- case 2:
- case 3:
- omstruckOrder.setOrderPlanId(DataChange.dataToBigDecimal(map.get("dayPlanId")));
- break;
- case 4:
- break;
- case 5:
- case 6:
- case 7:
- case 8:
- case 17:
- case 18:
- if (map.get("purchaseOrderId") != null) omstruckOrder.setOrderPlanId(DataChange.dataToBigDecimal(map.get("purchaseOrderId"))); //订单ID
- if (map.get("unloadPointId") != null) omstruckOrder.setUnloadPointId(DataChange.dataToBigDecimal(map.get("unloadPointId")));// 添加卸货点
- break;
- case 9:
- break;
- case 10:
- break;
- case 11:
- }
- //添加订单类型
- omstruckOrder.setOrderType(orderType);
- omstruckOrder.setInsertUsername("admin");
- omstruckOrder.setInsertTime(new Date());
- return omstruckOrder;
- }
- /**
- * 新增订单子表
- *
- * @param map
- * @param
- */
- public void addOrderMaterial(Map<String, Object> map, BigDecimal orderId) {
- BigDecimal orderType = DataChange.dataToBigDecimal(map.get("orderType"));
- OmstruckOrderMaterial omstruckOrderMaterial = new OmstruckOrderMaterial();
- switch (orderType.intValue()) {
- case 1:
- //获得销售物资id
- //生成子表主键
- omstruckOrderMaterial.setOrderMaterialId(omstruckOrderMaterialMapper.selectMaxId());
- Integer saleOrderMaterialId = (Integer) map.get("saleOrderMaterialId");
- //通过车序号id查找物资件数和物资重量
- Map<String, Object> map1 = omstruckOrderMapper.selectTheoreticalWeightAndMaterialNumber(saleOrderMaterialId);
- BigDecimal materialNumber = (BigDecimal) map1.get("materialNumber");
- BigDecimal weight = (BigDecimal) map1.get("weight");
- //设置物资理重和物资件数
- omstruckOrderMaterial.setOrderMaterialWeight(DataChange.dataToBigDecimal(weight));
- omstruckOrderMaterial.setOrderMaterialNumber(DataChange.dataToBigDecimal(materialNumber));
- //通过销售订单车序号id查找物资id
- List<Map<String, Object>> materialList = omstruckOrderMapper.selectMaterialIdBysaleOrderMaterialId(saleOrderMaterialId);
- for (int i = 0; i < materialList.size(); i++) {
- Map<String, Object> map2 = materialList.get(i);
- BigDecimal materialId = (BigDecimal) map2.get("materialId");
- omstruckOrderMaterial.setMaterialId(materialId);
- }
- //执行新增
- omstruckOrderMaterialMapper.insertSelective(omstruckOrderMaterial);
- break;
- case 2:
- case 3:
- //获取发运计划id
- //生成子表主键
- omstruckOrderMaterial.setOrderMaterialId(omstruckOrderMaterialMapper.selectMaxId());
- Integer dayPlanId = (Integer) map.get("dayPlanId");
- //设置订单id
- omstruckOrderMaterial.setOrderId(orderId);
- //根据发运计划id查找物资id和物资重量
- map = omstruckOrderMapper.selectMaterialIdAndWeightByDayPlanId(dayPlanId);
- BigDecimal materialId = (BigDecimal) map.get("materialId");
- BigDecimal materialWeight = (BigDecimal) map.get("materialWeight");
- //设置物资id
- omstruckOrderMaterial.setMaterialId(DataChange.dataToBigDecimal(materialId));
- //设置物资重量
- omstruckOrderMaterial.setOrderMaterialWeight(DataChange.dataToBigDecimal(materialWeight));
- omstruckOrderMaterialMapper.insertSelective(omstruckOrderMaterial);
- break;
- case 4:
- break;
- case 5:
- case 6:
- case 7:
- case 8:
- case 17:
- case 18:
- //生成子表主键
- omstruckOrderMaterial.setOrderMaterialId(omstruckOrderMaterialMapper.selectMaxId());
- omstruckOrderMaterial.setMaterialId(DataChange.dataToBigDecimal(map.get("materialId")));
- omstruckOrderMaterial.setOrderId(orderId);
- Object orderMaterialWeight = map.get("orderMaterialWeight");
- if (orderMaterialWeight != null) {
- if (orderMaterialWeight.toString().length() != 0) {
- omstruckOrderMaterial.setOrderMaterialWeight(DataChange.dataToBigDecimal(map.get("orderMaterialWeight")));
- }
- }
- Object orderMaterialNumber = map.get("orderMaterialNumber");
- if(orderMaterialNumber != null ) {
- if (orderMaterialNumber.toString().length() != 0) {
- omstruckOrderMaterial.setOrderMaterialNumber(DataChange.dataToBigDecimal(map.get("orderMaterialNumber")));
- }
- }
- omstruckOrderMaterial.setInsertUsername("admin");
- omstruckOrderMaterial.setInsertTime(new Date());
- omstruckOrderMaterialMapper.insertSelective(omstruckOrderMaterial);
- break;
- case 9:
- break;
- case 10:
- break;
- case 11:
- }
- }
- /**
- * 修改运输订单 和订单子表
- *
- * @param map
- * @return
- */
- @Override
- @Transactional
- public int updateOrder(Map<String, Object> map) {
- //修改运输订单运力ID
- OmstruckOrder omstruckOrder = new OmstruckOrder();
- BigDecimal orderId = DataChange.dataToBigDecimal(map.get("orderId"));
- BigDecimal orderType;
- if(map.get("orderType") == null){
- //查询订单类型
- orderType = new BigDecimal(omstruckOrderMapper.getOrderTypeByOrderNumber(orderId));
- }else{
- orderType = DataChange.dataToBigDecimal(map.get("orderType"));
- }
- omstruckOrder.setOrderId(orderId);
- if (map.get("unloadPointId") != null) {
- omstruckOrder.setUnloadPointId(DataChange.dataToBigDecimal(map.get("unloadPointId")));
- }
- if (map.get("capacityId") != null) {
- omstruckOrder.setCapacityId(DataChange.dataToBigDecimal(map.get("capacityId")));
- }
- if(map.get("orderEntryTime") != null){
- omstruckOrder.setOrderEntryTime(new Date((long) map.get("orderEntryTime")));
- }
- if(map.get("unloadPointId")!=null || map.get("capacityId") != null || map.get("orderEntryTime") != null){
- omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
- }
- switch (orderType.intValue()) {
- case 1:
- break;
- case 2:
- break;
- case 3:
- break;
- case 4:
- break;
- case 5:
- case 6:
- case 7:
- case 8:
- case 17:
- case 18:
- //修改运输订单子表物资重量
- OmstruckOrderMaterial omstruckOrderMaterial = new OmstruckOrderMaterial();
- //添加子表主键 通过订单ID查询出子表主键
- BigDecimal orderMaterialId = omstruckOrderMaterialMapper.getOrderMaterialIdByOrderId(DataChange.dataToBigDecimal(map.get("orderId")));
- omstruckOrderMaterial.setOrderMaterialId(orderMaterialId);
- if (map.get("orderMaterialWeight") != null) {
- omstruckOrderMaterial.setOrderMaterialWeight(DataChange.dataToBigDecimal(map.get("orderMaterialWeight")));
- if(orderType.intValue() == 8)
- amsFeign.updateMaterial(map);//修改运输计划子表 已分配未分配重量
- }
- if(map.get("orderMaterialNumber") != null) {
- omstruckOrderMaterial.setOrderMaterialNumber(DataChange.dataToBigDecimal(map.get("orderMaterialNumber")));
- }
- if (map.get("materialId") != null) {
- omstruckOrderMaterial.setMaterialId(DataChange.dataToBigDecimal(map.get("materialId")));
- }
- if(map.get("orderMaterialWeight") != null || map.get("orderMaterialNumber") != null || map.get("materialId") != null){
- omstruckOrderMaterialMapper.updateByPrimaryKeySelective(omstruckOrderMaterial);
- }
- break;
- case 9:
- break;
- case 10:
- break;
- case 11:
- }
- return 1;
- }
- /**
- * 逻辑删除未下发订单
- *
- * @param map
- * @return
- */
- @Override
- @Transactional
- public int deleteOrder(Map<String, Object> map) {
- OmstruckOrder omstruckOrder = new OmstruckOrder();
- omstruckOrder.setOrderId(DataChange.dataToBigDecimal(map.get("orderId")));
- //设置状态为逻辑删除:7
- omstruckOrder.setOrderStatus(new BigDecimal(7));
- int i = omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
- //若是传来物资重量则修改已分配未分配重量
- if (map.get("orderMaterialWeight") != null) {
- amsFeign.updateMaterial(map); //feign调用
- }
- // //通过车牌号修改运输状态为空闲中 0
- // String capacityNumber = (String) map.get("capacityNumber");
- // HashMap<String, Object> changeStatusMap = new HashMap<>();
- // changeStatusMap.put("capacityNumber", capacityNumber);
- // changeStatusMap.put("capacityStatus", 0);
- // int i1 = omstruckOrderMapper.updateCapacityByCarIdOrNum(changeStatusMap);
- return i;
- }
- /**
- * 运单派发、下发
- * 运单ID
- *
- * @param mapValue
- * @return
- */
- @Override
- @Transactional
- public int dispatchOrder(Map<String, Object> mapValue) {
- List<Map<String,Object>> mapList = (List<Map<String, Object>>) mapValue.get("mapList");
- int result = 0;
- for (Map<String, Object> map : mapList) {
- Integer orderId = (Integer) map.get("orderId");
- OmstruckOrder omstruckOrder = new OmstruckOrder();
- omstruckOrder.setOrderId(new BigDecimal(orderId));
- //生成订单下发时间 修改订单表
- omstruckOrder.setOrderIssueTime(new Date());
- //设置状态为已下发:4
- omstruckOrder.setOrderStatus(new BigDecimal(4));
- //下发 推送数据给 websocket
- pushMesToWebsocket(map);
- result += omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
- }
- return result;
- }
- /**
- * 发送消息到 websocket 推送消息
- * orderId 订单Id
- * @return
- */
- public void pushMesToWebsocket(Map<String, Object> map) {
- Map<String, Object> mesMap = omstruckOrderMapper.pushMesToWebsocket(map);
- //添加消息实体
- HashMap<Object, Object> mapp = new HashMap<>();
- mapp.put("messageType", 3);
- mapp.put("sendPerson", "system");
- mapp.put("receivePerson", mesMap.get("capacityNumber"));
- mapp.put("messageContent", mesMap);
- mapp.put("createTime", new Date());
- ArrayList<Object> list = new ArrayList<>();
- list.add(mapp);
- //调用websocket接口推送
- HashMap<Object, Object> sendMap = new HashMap<>();
- //将消息实体放入list中存到map中
- sendMap.put("messages", list);
- String s = imFeign.sendToUser(sendMap);
- System.out.println(s);
- }
- @Override//判断一车多单是否还有订单,如果又就再推送消息给他
- public void pushMessageToDriver(Map<String, Object> mapValue) {
- Map<String,Object> mapAddOrder =omstruckOrderMapper.getSporadicOrdermapAddOrder(new BigDecimal(mapValue.get("orderId").toString()));
- BigDecimal sporadicOrderTimes = DataChange.dataToBigDecimal(mapAddOrder.get("sporadicOrderTimes"));
- BigDecimal sporadicOrderId = DataChange.dataToBigDecimal(mapAddOrder.get("sporadicOrderId"));
- BigDecimal transStatus = DataChange.dataToBigDecimal(mapAddOrder.get("transStatus"));
- BigDecimal orderId = DataChange.dataToBigDecimal(mapValue.get("orderId"));
- //获取运输订单类型
- Integer orderType = omstruckOrderMapper.getOrderTypeByOrderId(orderId);
- BigDecimal capacityId = DataChange.dataToBigDecimal(mapAddOrder.get("capacityId"));
- Map<String, Object> addMapSporadicOrder = new HashMap<>();
- addMapSporadicOrder.put("sporadicOrderId",sporadicOrderId);
- addMapSporadicOrder.put("orderId",orderId);
- List<Map<String,Object>> mapList = new ArrayList<>();
- Map<String,Object> map=new HashMap<>();
- map.put("capacityId",capacityId);
- mapList.add(map);
- addMapSporadicOrder.put("mapList",mapList);
- switch (orderType) {
- case 13:
- case 19:
- case 12:
- case 14:
- if (transStatus.intValue()==1){
- amsFeign.addSporadicOrderTimes(addMapSporadicOrder);
- }
- break;
- //普通零星
- case 15:
- case 16:
- if (sporadicOrderTimes.intValue() > 0) {
- //mapvalue需要orderId,零星订单id,maplist放一个运力id
- amsFeign.addSporadicOrderTimes(addMapSporadicOrder);
- }
- }
- }
- //撤销订单
- @Transactional
- @Override
- public int undoOrder(Map<String, Object> map) throws Exception{
- int result=0;
- BigDecimal orderId =DataChange.dataToBigDecimal(map.get("orderId"));
- Map<String, Object> mesMap = omstruckOrderSeparateMapper.getOrderMesByOrderId(orderId);
- BigDecimal orderPlanId = DataChange.dataToBigDecimal(mesMap.get("orderPlanId"));
- int orderType = DataChange.dataToBigDecimal(mesMap.get("orderType")).intValue();
- BigDecimal resultTotalId = DataChange.dataToBigDecimal(mesMap.get("resultTotalId"));
- OmstruckOrder omstruckOrder = new OmstruckOrder();
- omstruckOrder.setOrderId(DataChange.dataToBigDecimal(orderId));
- omstruckOrder.setOrderStatus(new BigDecimal(4));
- //讲路段顺序号设为空,适应进厂以后扫码
- omstruckOrder.setOrderLineSequence(new BigDecimal(0));
- result += omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
- if(orderType == 11 ){
- result += omstruckOrderMapper.deleteLoadResult(resultTotalId);
- return result ;
- }
- if (orderType==21){
- //根据总实绩id查找计时实绩id
- int timeTaskByTotalId = omstruckOrderMapper.getTimeTaskByTotalId(resultTotalId);
- if (timeTaskByTotalId!=0)
- {
- throw new Exception("已经计时开始");
- }else {
- result += omstruckOrderMapper.deleteTimeTaskByTotalId(resultTotalId);
- }
- }
- //通过总实绩ID删除所有已经生成的实绩
- result += omstruckOrderMapper.deleteEnResult(resultTotalId);
- result += omstruckOrderMapper.deleteWeightResult(resultTotalId);
- result += omstruckOrderMapper.deleteUnloadResult(resultTotalId);
- result += omstruckOrderMapper.deleteLoadResult(resultTotalId);
- result += omstruckOrderMapper.deleteLeaveResult(resultTotalId);
- if(orderType == 12 || orderType == 13 || orderType == 14 || orderType == 19){
- Map<String, Object> sporadicOrderTimes = omstruckOrderMapper.getSporadicOrderTimes(orderId);
- BigDecimal orderTimes =(BigDecimal)sporadicOrderTimes.get("orderTimes");
- BigDecimal transTimes = (BigDecimal)sporadicOrderTimes.get("transTimes");
- //更新趟次
- omstruckOrderSeparateService.updateTimes(orderPlanId,orderTimes.intValue()+1);
- //更新状态
- omstruckOrderSeparateMapper.updateSporadicStatus(orderPlanId,1);
- //更新已运输趟次
- if (transTimes.intValue()>0) {
- omstruckOrderSeparateMapper.updateTranTimes(orderPlanId, transTimes.intValue() - 1);
- }
- }
- return result;
- }
- //修改运力
- @Override
- public int updateCapacityId(Map<String,Object> map) {
- int result=0;
- OmstruckOrder omstruckOrder=new OmstruckOrder();
- BigDecimal orderId =DataChange.dataToBigDecimal(map.get("orderId"));
- BigDecimal capacityId =DataChange.dataToBigDecimal(map.get("capacityId"));
- omstruckOrder.setOrderId(orderId);
- omstruckOrder.setCapacityId(capacityId);
- result+=omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
- return result;
- }
- //采购内转派单
- @Override
- public int addPurInwardOrder(Map<String, Object> mapValue) {
- int result = 0;
- List<Map<String,Object>> mapList = (List<Map<String, Object>>) mapValue.get("mapList");
- BigDecimal planId = DataChange.dataToBigDecimal(mapValue.get("planId"));
- BigDecimal lineId = DataChange.dataToBigDecimal(mapValue.get("lineId"));
- BigDecimal orderType = DataChange.dataToBigDecimal(mapValue.get("orderType"));
- AmstruckInwardPlan amstruckInwardPlan = amstruckInwardPlanMapper.selectByPrimaryKey(planId);
- amstruckInwardPlan.setPlanStatus(new BigDecimal(3));
- result += amstruckInwardPlanMapper.updateByPrimaryKeySelective(amstruckInwardPlan);
- BigDecimal materialId = omstruckOrderMapper.getInwardMaterial(planId);
- for (Map<String,Object> orderMap : mapList) {
- OmstruckOrder omstruckOrder = new OmstruckOrder();
- String capacityNumber = (String)orderMap.get("capacityNumber");
- Map<String,Object> capacityMap = new HashMap<>();
- capacityMap.put("capacityNumber",capacityNumber);
- List<RmsCapacity> rmsCapacities = rmsCapacityMapper.selectByParameters(capacityMap);
- RmsCapacity rmsCapacity = rmsCapacities.get(0);
- // rmsCapacity.setCapacityStatus(new BigDecimal(2));
- result +=rmsCapacityMapper.updateByPrimaryKeySelective(rmsCapacity);
- BigDecimal capacityId = rmsCapacity.getCapacityId();
- capacityMap.clear();
- capacityMap.put("capacityId",capacityId);
- BigDecimal orderId = omstruckOrderMapper.selectMaxId();
- // 添加总实绩
- Map<String,Object> orderIdMap = new HashMap<>();
- orderIdMap.put("orderId",orderId);
- tmsTruckFeign.addTotalResult(orderIdMap);
- omstruckOrder.setOrderId(orderId);
- omstruckOrder.setOrderPlanId(planId);
- String orderNumber = DataChange.generateEightDigitsNumber("WYSDD", orderId.intValue());
- omstruckOrder.setOrderNumber(orderNumber);
- omstruckOrder.setOrderIssueTime(new Date());
- omstruckOrder.setOrderStatus(new BigDecimal(4));
- omstruckOrder.setCapacityId(capacityId);
- omstruckOrder.setInsertTime(new Date());
- omstruckOrder.setUpdateTime(new Date());
- omstruckOrder.setInsertUsername("admin");
- omstruckOrder.setUpdateUsername("admin");
- omstruckOrder.setInsertUpdateRemark("无");
- omstruckOrder.setDeleted(new BigDecimal(0));
- omstruckOrder.setOrderType(orderType);
- omstruckOrder.setLineId(lineId);
- result +=omstruckOrderMapper.insertSelective(omstruckOrder);
- OmstruckOrderMaterial omstruckOrderMaterial = new OmstruckOrderMaterial();
- BigDecimal orderMaterialId = omstruckOrderMaterialMapper.selectMaxId();
- omstruckOrderMaterial.setOrderMaterialId(orderMaterialId);
- omstruckOrderMaterial.setOrderId(orderId);
- omstruckOrderMaterial.setMaterialId(materialId);
- omstruckOrderMaterial.setInsertTime(new Date());
- omstruckOrderMaterial.setUpdateTime(new Date());
- omstruckOrderMaterial.setInsertUsername("admin");
- omstruckOrderMaterial.setUpdateUsername("admin");
- omstruckOrderMaterial.setInsertUpdateRemark("无");
- result +=omstruckOrderMaterialMapper.insertSelective(omstruckOrderMaterial);
- }
- return result;
- }
- @Override
- public List<Map<String, Object>> getPurInwardOrderList(Map<String, Object> mapValue) {
- List<Map<String,Object>> mapList = omstruckOrderMapper.getPurInwardOrderList(mapValue);
- for (Map<String,Object>map:mapList
- ) {
- map.put("loadName","化工园区铁专线");
- }
- return mapList;
- }
- @Override
- public int addPurInwardOrder1(BigDecimal orderId) {
- //根据运输订单id查询信息
- Map<String,Object>map = omstruckOrderMapper.selectOrderMap(orderId);
- BigDecimal planId = DataChange.dataToBigDecimal(map.get("planId"));
- BigDecimal lineId = DataChange.dataToBigDecimal(map.get("lineId"));
- BigDecimal orderType = DataChange.dataToBigDecimal(map.get("orderType"));
- BigDecimal capacityId = DataChange.dataToBigDecimal(map.get("capacityId"));
- BigDecimal materialId = DataChange.dataToBigDecimal(map.get("materialId"));
- int result = 0;
- OmstruckOrder omstruckOrder = new OmstruckOrder();
- BigDecimal orderIds = omstruckOrderMapper.selectMaxId();
- // 添加总实绩
- Map<String,Object> orderIdMap = new HashMap<>();
- orderIdMap.put("orderId",orderIds);
- tmsTruckFeign.addTotalResult(orderIdMap);
- omstruckOrder.setOrderId(orderIds);
- omstruckOrder.setOrderPlanId(planId);
- String orderNumber = DataChange.generateEightDigitsNumber("WYSDD", orderIds.intValue());
- omstruckOrder.setOrderNumber(orderNumber);
- omstruckOrder.setOrderIssueTime(new Date());
- omstruckOrder.setOrderStatus(new BigDecimal(4));
- omstruckOrder.setCapacityId(capacityId);
- omstruckOrder.setInsertTime(new Date());
- omstruckOrder.setUpdateTime(new Date());
- omstruckOrder.setInsertUsername("admin");
- omstruckOrder.setUpdateUsername("admin");
- omstruckOrder.setInsertUpdateRemark("无");
- omstruckOrder.setDeleted(new BigDecimal(0));
- omstruckOrder.setOrderType(orderType);
- omstruckOrder.setLineId(lineId);
- result +=omstruckOrderMapper.insertSelective(omstruckOrder);
- OmstruckOrderMaterial omstruckOrderMaterial = new OmstruckOrderMaterial();
- BigDecimal orderMaterialId = omstruckOrderMaterialMapper.selectMaxId();
- omstruckOrderMaterial.setOrderMaterialId(orderMaterialId);
- omstruckOrderMaterial.setOrderId(orderIds);
- omstruckOrderMaterial.setMaterialId(materialId);
- omstruckOrderMaterial.setInsertTime(new Date());
- omstruckOrderMaterial.setUpdateTime(new Date());
- omstruckOrderMaterial.setInsertUsername("admin");
- omstruckOrderMaterial.setUpdateUsername("admin");
- omstruckOrderMaterial.setInsertUpdateRemark("无");
- result +=omstruckOrderMaterialMapper.insertSelective(omstruckOrderMaterial);
- return result;
- }
- @Override
- public int refuseCtrlZ(Map<String, Object> map) {
- return omstruckOrderMapper.refuseCtrlZ(map);
- }
- /**
- * 销售物流,下发订单
- *
- * @param map
- * @return
- */
- @Override
- public int dispatchOrderForSale(Map<String, Object> map) {
- OmstruckOrder omstruckOrder = new OmstruckOrder();
- Integer orderId = (Integer) map.get("orderId");
- Integer orderType = (Integer) map.get("orderType");
- omstruckOrder.setOrderId(DataChange.dataToBigDecimal(orderId));
- if (orderType == 2 || orderType == 3) {
- Integer loadId = (Integer) map.get("LoadId");
- if (loadId != null) {
- //根据运输订单id查找装车实绩id
- omstruckOrder.setUnloadPointId(DataChange.dataToBigDecimal(loadId));
- }
- }
- //设置下发状态
- omstruckOrder.setOrderIssueTime(new Date());
- omstruckOrder.setOrderStatus(new BigDecimal(4));
- // pushMesToWebsocket(map); //下发 推送数据给 websocket
- return omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
- }
- @Override
- public List<Map<String, Object>> selectWaterSlagForOrder(Map<String, Object> map) {
- return omstruckOrderMapper.selectWaterSlagForOrder(map);
- }
- @Override
- public List<Map<String, Object>> selectCokeRailPlanForOrder(Map<String, Object> map) {
- return omstruckOrderMapper.selectCokeRailPlanForOrder(map);
- }
- /**
- * 司机接单、拒绝 0:拒绝 1:接收
- * 需要接收参数 主键Id 与 接收拒绝操作码
- *
- * @param map
- * @return
- */
- @Override
- @Transactional
- public synchronized int driverReceiveOrRefuse(Map<String, Object> map) throws RuntimeException {
- BigDecimal orderId = DataChange.dataToBigDecimal(map.get("orderId"));
- OmstruckOrder omstruckOrder = new OmstruckOrder();
- if((Integer) map.get("orderReceiveStatus") == 1) {
- List<Integer> orderIdList = omstruckOrderMapper.getReceiveOrderIdListByCapacityNum((String) map.get("capacityNumber"));
- if (orderIdList.size() > 0) {
- throw new RuntimeException("已有接收的订单!");
- }
- omstruckOrder.setOrderStatus(new BigDecimal(5)); //5 :已接收
- //通过订单ID查询信息
- Map<String, Object> orderMessage = omstruckOrderSeparateMapper.getOrderMessagge(orderId);
- int orderStatus = DataChange.dataToBigDecimal(orderMessage.get("orderStatus")).intValue();
- if(orderStatus == 5 || orderStatus == 6) {
- throw new RuntimeException("订单已被接收或已被拒绝!");
- }
- int orderType = DataChange.dataToBigDecimal(orderMessage.get("orderType")).intValue();
- if(orderType == 11){
- //发送计量委托
- orderMessage.put("asd", 1);
- orderMessage.put("orderId", orderId);
- tmsTruckFeign.sendMeasureCommission(orderMessage);
- }else if(orderType!=21){
- //添加各个实绩
- omstruckOrderSeparateService.addAllSonResult(orderMessage);
- }
- //判断订单是否是一车多单
- if (orderType ==12 || orderType ==13 || orderType ==14 || orderType ==19) {
- //通过订单查询趟次
- Map<String, Object> sporadicOrderTimes = omstruckOrderMapper.getSporadicOrderTimes(orderId);
- BigDecimal orderTimes = DataChange.dataToBigDecimal(sporadicOrderTimes.get("orderTimes"));
- //通过订单id查询已运输趟次
- BigDecimal transTimes=DataChange.dataToBigDecimal(sporadicOrderTimes.get("transTimes"));
- //生成作业实绩之后、更改订单数量
- if (orderMessage.containsKey("orderPlanId") && orderTimes.intValue() > 0) {
- int state =0;
- //如果运输趟次,接完之后将变成0
- if(orderTimes.intValue() == 1){
- //修改零星订单运输状态
- state +=omstruckOrderSeparateMapper.updateSporadicStatus(DataChange.dataToBigDecimal(orderMessage.get("orderPlanId")),0);
- }
- state+=omstruckOrderSeparateService.updateTimes(new BigDecimal(orderMessage.get("orderPlanId").toString()), orderTimes.intValue() - 1);
- //接收订单以后已运输订单趟次+1
- state+=omstruckOrderSeparateMapper.updateTranTimes(DataChange.dataToBigDecimal(orderMessage.get("orderPlanId").toString()),transTimes.intValue()+1);
- }
- }
- } else { //其他状态都视为 拒绝接单
- omstruckOrder.setOrderStatus(new BigDecimal(6));
- //添加拒绝原因
- omstruckOrder.setInsertUpdateRemark((String) map.get("insertUpdateRemark"));
- }
- omstruckOrder.setOrderId(orderId);
- //生成接收/拒绝时间
- Date receiveTime = new Date();
- omstruckOrder.setOrderReceiveRefuseTime(receiveTime);
- //计算司机从派单到操作时长
- Date issueTime = omstruckOrderMapper.getInsertTimeById(orderId.intValue());
- long time = receiveTime.getTime() - issueTime.getTime();
- long min = time / (1000 * 60);
- omstruckOrder.setOrderCommunicationDuration(new BigDecimal(min));
- return omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
- }
- //根据承运商获取销售订单
- @Override
- public List<Map<String, Object>> selectSaleOrderForCarrier(Map<String, Object> map) {
- Integer carrierId = (Integer) map.get("carrierId");
- List<Map<String, Object>> maps = omstruckOrderMapper.selectSaleMaterialIdByCarrierId(carrierId);
- List<Map<String, Object>> list = null;
- for (Map<String, Object> map1 : maps) {
- BigDecimal saleOrderMaterialId = (BigDecimal) map1.get("saleOrderMaterialId");
- list = omstruckOrderMapper.selectSaleBySaleOrderMaterialId(saleOrderMaterialId.intValue());
- }
- return list;
- }
- /**
- * 查询已接收的焦炭发运计划
- *
- * @param
- * @return
- */
- @Override
- public List<Map<String, Object>> selectCokeDayPlanAndRecived(Map<String, Object> map) {
- return omstruckOrderMapper.selectCokeDayPlanAndRecived(map);
- }
- /**
- * 查询已接收的水渣发运计划
- *
- * @param
- * @return
- */
- @Override
- public List<Map<String, Object>> selectWaterSlagDayPlanAndRecived(Integer carrierId) {
- return omstruckOrderMapper.selectWaterSlagDayPlanAndRecived(carrierId);
- }
- /**
- * 司机接单推送数据
- * 车牌号
- * @param
- * @return
- */
- @Override
- public List<Map<String, Object>> sendMesToDriver(Map<String, Object> map) {
- //通过车牌号匹配运力ID
- BigDecimal capacityId = omstruckOrderMapper.getCapacityIdByCapacityNum((String) map.get("capacityNumber"));
- if (capacityId == null) {
- return null;
- }
- map.put("capacityId", capacityId);
- //通过运力Id匹配 已下发的运输订单
- List<Map<String, Object>> truckOrderByCapacityNum;
- if ((Integer) map.get("orderType") == 1 || (Integer) map.get("orderType") == 2) {
- truckOrderByCapacityNum = omstruckOrderMapper.getSaleTruckOrderByCapacityNum(map);
- } else {
- truckOrderByCapacityNum = omstruckOrderMapper.getTruckOrderByCapacityNum(map);
- }
- return truckOrderByCapacityNum;
- }
- /**
- * 得到作业时间和地点
- *
- * @param orderId
- * @return
- */
- @Override
- public List<Map<String, Object>> selectPlaceAndTime(BigDecimal orderId) {
- List<Map<String, Object>> mapList = omstruckOrderMapper.selectPlaceAndTime(orderId);
- Map<String, Object> map = mapList.get(0);
- String entryGatepost = (String) map.get("entryGatepost");
- Date entryTime = (Date) map.get("entryTime");
- String entryResult = entryGatepost + "/" + entryTime;
- String grossCalculate = (String) map.get("grossCalculate");
- Date grossTime = (Date) map.get("grossTime");
- String grossResult = grossCalculate + "/" + grossTime;
- String unloadWarhouse = (String) map.get("unloadWarhouse");
- Date unloadTime = (Date) map.get("unloadTime");
- String unloadResult = unloadWarhouse + "/" + unloadTime;
- String tareCalculate = (String) map.get("tareCalculate");
- Date tareTime = (Date) map.get("tareTime");
- String tareResult = tareCalculate + "/" + tareTime;
- String leaveGatepost = (String) map.get("leaveGatepost");
- Date outTime = (Date) map.get("outTime");
- String leaveResult = leaveGatepost + "/" + outTime;
- String receiptWarhouse = (String) map.get("receiptWarhouse");
- Date receiptTime = (Date) map.get("receiptTime");
- String receiptResult = receiptWarhouse + "/" + receiptTime;
- List<Map<String, Object>> resultList = new ArrayList<>();
- Map<String, Object> map1 = new HashMap<>();
- map1.put("title", "进厂门岗/时间");
- map1.put("desc", entryResult);
- resultList.add(map1);
- Map<String, Object> map2 = new HashMap<>();
- map2.put("title", "毛重衡器/时间");
- map2.put("desc", grossResult);
- resultList.add(map2);
- Map<String, Object> map3 = new HashMap<>();
- map3.put("title", "卸货地点/时间");
- map3.put("desc", unloadResult);
- resultList.add(map3);
- Map<String, Object> map4 = new HashMap<>();
- map4.put("title", "皮重衡器/时间");
- map4.put("desc", tareResult);
- resultList.add(map4);
- Map<String, Object> map5 = new HashMap<>();
- map5.put("title", "出厂门岗/时间");
- map5.put("desc", leaveResult);
- resultList.add(map5);
- if ((Integer) map.get("orderType") == 1) {
- Map<String, Object> map6 = new HashMap<>();
- map5.put("title", "异地库/时间");
- map5.put("desc", receiptResult);
- resultList.add(map6);
- }
- Map<String, Object> map7 = new HashMap<>();
- BigDecimal orderLineSequence = (BigDecimal) map.get("orderLineSequence");
- map7.put("orderLineSequence", orderLineSequence);
- resultList.add(map7);
- return resultList;
- }
- /**
- * 查询已下发未接受的销售订单信息
- *
- * @param orderType
- * @return
- */
- @Override
- public List<Map<String, Object>> getOrderUnReceive(BigDecimal orderType) {
- return omstruckOrderMapper.getOrderUnReceive(orderType);
- }
- /**
- * 查询已下发已接受的销售订单信息
- *
- * @param orderType
- * @return
- */
- @Override
- public List<Map<String, Object>> getOrderReceived(BigDecimal orderType) {
- return omstruckOrderMapper.getOrderReceived(orderType);
- }
- /**
- * 分派钢材销售订单
- *
- * @param map
- * @return
- */
- @Override
- public int dispatchSteelOrder(Map<String, Object> map) {
- //新增运单(销售钢材订单)
- //生成运输订单号和主键以及绑定运力
- OmstruckOrder omstruckOrder = generateOmsTruckOrder(map);
- //设置线路 遗留问题,设置为进门门岗
- omstruckOrder.setLineId(new BigDecimal(1));
- //新增运输订单
- omstruckOrderMapper.insertSelective(omstruckOrder);
- //更新运力状态为待运输:2
- // map.put("capacityStatus", 2);
- // omstruckOrderMapper.updateCapacityById(map);
- //新增运输订单子表
- addOrderMaterial(map, omstruckOrder.getOrderId());
- //新增实绩总表关联订单 feign调用
- map.put("orderId", omstruckOrder.getOrderId());
- tmsTruckFeign.addTotalResult(map);
- return 6;
- }
- //设置销售订单下发状态
- @Override
- public int IssueSteelOrder(Map<String, Object> map) {
- //设置下发状态
- OmstruckOrder omstruckOrder = new OmstruckOrder();
- Integer orderId = (Integer) map.get("orderId");
- omstruckOrder.setOrderId(DataChange.dataToBigDecimal(orderId));
- omstruckOrder.setOrderIssueTime(new Date());
- //设置下发状态值:4
- omstruckOrder.setOrderStatus(new BigDecimal(4));
- return 2;
- }
- //销售模块查看所有订单
- @Override
- public List<Map<String, Object>> selectAllOrderForSale(Map<String, Object> map) {
- //map获取承运商
- Integer carrierId = (Integer) map.get("carrierId");
- Integer saleOrderMaterialId = (Integer) map.get("saleOrderMaterialId");
- List<Map<String, Object>> maps = omstruckOrderMapper.selectSaleMaterialIdByCarrierId(carrierId);
- //根据车序号查找运输订单
- List<Map<String, Object>> mapList = null;
- List<Map<String, Object>> maps1 = new ArrayList<>();
- //判断获取的车序号是否属于承运商
- for (Map<String, Object> map1 : maps) {
- BigDecimal compareNum = DataChange.dataToBigDecimal(map1.get("saleOrderMaterialId"));
- if (compareNum.intValue() == saleOrderMaterialId) {
- mapList = omstruckOrderMapper.selectAllOrderForSale(map);
- for (int i = 0; i < mapList.size(); i++) {
- Map<String, Object> map2 = mapList.get(i);
- if (map2.get("orderId") == null) {
- return maps1;
- }
- }
- return mapList;
- }
- }
- return maps1;
- }
- @Override
- public List<Map<String, Object>> selectTransportOrderForSale(Map<String, Object> map) {
- String carrierSsoId = (String) map.get("carrierSsoId");
- BigDecimal carrierId = omstruckOrderMapper.getCarrierIdBySSO(carrierSsoId);
- map.put("carrierId",carrierId);
- List<Map<String, Object>> mapList = omstruckOrderMapper.selectTransportOrderForSale(map);
- int count = 1;
- for (Map<String, Object> stringObjectMap : mapList) {
- stringObjectMap.put("ROW_ID",count);
- count ++;
- }
- return mapList;
- }
- @Override
- public List<Map<String, Object>> selectSteelSaleForCarrier(Map<String, Object> map) {
- return omstruckOrderMapper.selectSteelSaleForCarrier(map);
- }
- //根据销售订单id查找信息
- @Override
- public List<Map<String, Object>> selectInfoBySaleOrderId(Integer saleOrderId) {
- return omstruckOrderMapper.selectInfoBySaleOrderId(saleOrderId);
- }
- @Override
- public List<Map<String, Object>> selectCokeRailPlan(Map<String, Object> map) {
- return omstruckOrderMapper.selectCokeRailPlan(map);
- }
- @Override
- public List<Map<String, Object>> selectInfoByDayPlanId(Map<String, Object> map) {
- return omstruckOrderMapper.selectInfoByDayPlanId(map);
- }
- /**
- * 查找司机排班表信息
- *
- * @param map
- * @return
- */
- @Override
- public List<Map<String, Object>> selectCapacityAndDriver(Map<String, Object> map) {
- return omstruckOrderMapper.selectCapacityAndDriver(map);
- }
- /**
- * 查询所有运力信息
- *
- * @return
- */
- @Override
- public List<Map<String, Object>> getAllCapacity(Map<String, Object> map) {
- return omstruckOrderMapper.getAllCapacity(map);
- }
- /**
- * 用于后台展示司机接单未接单数据
- *
- * @param map
- * @return
- */
- @Override
- public List<Map<String, Object>> getReceiveRefuseOrder(Map<String, Object> map) {
- return omstruckOrderMapper.getTruckOrderByCapacityNum(map);
- }
- /**
- * 通过运输订单号查询运单所有信息 包含作业路径名称
- *
- * @param map 传运输订单号
- * @return
- */
- @Override
- public List<Map<String, Object>> getOrderMesByOrderNum(Map<String, Object> map) {
- return omstruckOrderMapper.getTruckOrderByCapacityNum(map);
- }
- /**
- * 查询所有司机已拒绝的订单
- * 车牌号
- *
- * @param map
- * @return
- */
- @Override
- public List<Map<String, Object>> getReceiveRefuseOrderByCapacityId(Map<String, Object> map) {
- //通过车牌号查询运力Id
- BigDecimal capacityId = omstruckOrderMapper.getCapacityIdByCapacityNum((String) map.get("capacityNumber"));
- map.put("capacityId", capacityId);
- return omstruckOrderMapper.getReceiveRefuseOrderByCapacityId(map);
- }
- /**
- * 通过运单号查询订单详情
- * 运输订单号
- *
- * @param
- * @return
- */
- @Override
- public List<Map<String, Object>> getOrderByOrderId(BigDecimal orderId) {
- return omstruckOrderMapper.getOrderByOrderId(orderId);
- }
- /**
- * 查看运输派单
- *
- * @param map
- * @return
- */
- @Override
- public List<Map<String, Object>> getTransportDispatch(Map<String, Object> map) {
- return omstruckOrderMapper.getTransportDispatch(map);
- }
- /**
- * 用于更新路段顺序号
- *
- * @param map orderId
- * @return
- */
- public int updateOrderLineSequence(Map<String, Object> map, Integer lineSequence) {
- OmstruckOrder omstruckOrder = new OmstruckOrder();
- omstruckOrder.setOrderId(DataChange.dataToBigDecimal(map.get("orderId")));
- omstruckOrder.setOrderLineSequence(new BigDecimal(lineSequence));
- return omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
- }
- //新增内转运输订单
- @Override
- public int insert(OmstruckOrder omstruckOrder) {
- //生成订单主键Id
- BigDecimal maxId = omstruckOrderMapper.selectMaxId();
- omstruckOrder.setOrderId(maxId);
- //生成运输订单号
- int id = maxId.intValue();
- String orderNumber = DataChange.generateEightDigitsNumber("WYSDD", id);
- omstruckOrder.setOrderNumber(orderNumber);
- //设置状态为未下发
- omstruckOrder.setOrderStatus(new BigDecimal(3));
- //设置运输订单的类型
- omstruckOrder.setOrderType(new BigDecimal(11));
- omstruckOrder.setInsertTime(new Date());
- omstruckOrder.setInsertUsername("admin");
- return omstruckOrderMapper.insertSelective(omstruckOrder);
- }
- //通过物资id查询批次表匹配最新的批次,关联最新的采购订单号
- @Override
- public Map<String, Object> selectNewOrderId(Map<String, Object> map) {
- return omstruckOrderMapper.selectNewOrderId(map);
- }
- //app司机接单查询数据
- @Override
- public Map<String, Object> sendMesToDriverApp(Map<String, Object> map) {
- //通过车牌号匹配运力ID
- BigDecimal capacityId = omstruckOrderMapper.getCapacityIdByCapacityNum((String) map.get("capacityNumber"));
- map.put("capacityId", capacityId);
- if (capacityId == null) {
- return null;
- }
- //通过运力Id匹配 已下发的运输订单
- Map<String, Object> truckOrderByCapacityNum = new HashMap<>();
- if ((Integer) map.get("orderType") == 1 || (Integer) map.get("orderType") == 2) {
- //查询主干信息
- Map<String, Object> map1 = omstruckOrderMapper.getSaleTruckOrderByCapacityId(map);
- //查询物资信息
- List<Map<String, Object>> mapList = omstruckOrderMapper.getSaleTruckOrderByCapacityNumMaterial(map);
- truckOrderByCapacityNum.put("orderf", map1);
- truckOrderByCapacityNum.put("materialList", mapList);
- }
- return truckOrderByCapacityNum;
- }
- @Override
- public BigDecimal selectCapacityId(BigDecimal carrierId, String capacityNumber) {
- return omstruckOrderMapper.selectCapacityId(carrierId, capacityNumber);
- }
- /**
- * 车牌号下拉
- *
- * @return
- */
- @Override
- public List<Map<String, Object>> getDriverCapacity() {
- return omstruckOrderMapper.getDriverCapacity();
- }
- /**
- * 派单信息
- *
- * @param dispatchId
- * @return
- */
- @Override
- public Map<String, Object> getTruckNoDispatchMap(Integer dispatchId) {
- Map<String, Object> map = omstruckOrderMapper.getTruckNoDispatchMap(new BigDecimal(dispatchId));
- List<BigDecimal> orderIdList = omstruckOrderMapper.getNullOrNotNull(new BigDecimal(dispatchId));
- if (orderIdList != null || orderIdList.size() != 0) {
- return null;
- }
- List<Map<String, Object>> materialMessages = omstruckOrderMapper.getMaterialMessages(new BigDecimal(dispatchId));
- String allMaterialName = "";
- String allMaterialNumber = "";
- String allMaterialTheoreticalWeight = "";
- String allMaterialSpecificationModel = "";
- if (materialMessages == null || materialMessages.size() == 0) {
- } else {
- for (Map<String, Object> materialMap : materialMessages) {
- if (materialMap != null) {
- String materialName = (String) materialMap.get("materialName");
- allMaterialName += materialName + "/";
- String materialTheoreticalWeight = materialMap.get("materialTheoreticalWeight").toString();
- if (materialTheoreticalWeight != null) {
- allMaterialTheoreticalWeight += materialTheoreticalWeight + "/";
- }
- String saleOrderMaterialNumber = materialMap.get("saleOrderMaterialNumber").toString();
- allMaterialNumber += saleOrderMaterialNumber + "/";
- String specificationModel = materialMap.get("specificationModel").toString();
- if (specificationModel != null) {
- allMaterialSpecificationModel += specificationModel + "/";
- }
- }
- }
- String subMaterialName = null;
- String subMaterialNumber = null;
- String subMaterialTheoreticalWeight = null;
- String subMaterialSpecificationModel = null;
- if (allMaterialName.length() >= 2) {
- subMaterialName = allMaterialName.substring(0, allMaterialName.length() - 2);
- }
- if (allMaterialName.length() < 2) {
- subMaterialName = allMaterialName;
- }
- if (allMaterialNumber.length() >= 2) {
- subMaterialNumber = allMaterialNumber.substring(0, allMaterialNumber.length() - 2);
- }
- if (allMaterialNumber.length() < 2) {
- subMaterialNumber = allMaterialNumber;
- }
- if (allMaterialTheoreticalWeight.length() >= 2) {
- subMaterialTheoreticalWeight = allMaterialTheoreticalWeight.substring(0, allMaterialTheoreticalWeight.length() - 2);
- }
- if (allMaterialTheoreticalWeight.length() < 2) {
- subMaterialTheoreticalWeight = allMaterialTheoreticalWeight;
- }
- if (allMaterialSpecificationModel.length() >= 2) {
- subMaterialSpecificationModel = allMaterialSpecificationModel.substring(0, allMaterialSpecificationModel.length() - 2);
- }
- if (allMaterialSpecificationModel.length() < 2) {
- subMaterialSpecificationModel = allMaterialSpecificationModel;
- }
- map.put("allMaterialName", subMaterialName);
- map.put("allMaterialNumber", subMaterialNumber);
- map.put("allMaterialTheoreticalWeight", subMaterialTheoreticalWeight);
- map.put("allMaterialSpecificationModel", subMaterialSpecificationModel);
- }
- return map;
- }
- /**
- * 承运商分派运输订单给司机
- * @param dispatchId
- * @param orderType
- * @param capacityNumber
- * @param carrierId
- * @return
- */
- @Override
- public int addAppTruckOrder(Integer dispatchId, Integer orderType, String capacityNumber, Integer carrierId) {
- OmstruckOrder omstruckOrder = new OmstruckOrder();
- BigDecimal orderId = omstruckOrderMapper.selectMaxId();
- Map<String,Object> orderIdMap = new HashMap<>();
- orderIdMap.put("orderId",orderId);
- tmsTruckFeign.addTotalResult(orderIdMap);
- omstruckOrder.setOrderId(orderId);
- BigDecimal saleOrderMaterialId = omstruckOrderMapper.getSaleMaterialId(new BigDecimal(dispatchId));
- omstruckOrder.setOrderPlanId(saleOrderMaterialId);
- String orderNumber = DataChange.generateEightDigitsNumber("WYSDD", orderId.intValue());
- omstruckOrder.setOrderNumber(orderNumber);
- omstruckOrder.setOrderIssueTime(new Date());
- omstruckOrder.setOrderStatus(new BigDecimal(4));
- omstruckOrder.setInsertTime(new Date());
- omstruckOrder.setUpdateTime(new Date());
- omstruckOrder.setInsertUsername("admin");
- omstruckOrder.setUpdateUsername("admin");
- omstruckOrder.setInsertUpdateRemark("无");
- omstruckOrder.setDeleted(new BigDecimal(0));
- omstruckOrder.setOrderType(new BigDecimal(orderType));
- BigDecimal capacityId = omstruckOrderMapper.getCapacityId(capacityNumber);
- omstruckOrder.setCapacityId(capacityId);
- // omstruckOrder.setCarrierId();
- // BigDecimal driverCapacityId = omstruckOrderMapper.getDriverCapacityId(capacityId);
- // omstruckOrder.setDriverCapacityId(driverCapacityId);
- // RmsDriverCapacity rmsDriverCapacity = rmsDriverCapacityMapper.selectByPrimaryKey(driverCapacityId);
- // rmsDriverCapacity.setCarrierId(new BigDecimal(carrierId));
- // rmsDriverCapacityMapper.updateByPrimaryKeySelective(rmsDriverCapacity);
- List<Map<String, Object>> mapList = omstruckOrderMapper.getMaterialMessages(new BigDecimal(dispatchId));
- if (mapList != null && mapList.size() != 0) {
- for (Map<String, Object> map : mapList) {
- OmstruckOrderMaterial omstruckOrderMaterial = new OmstruckOrderMaterial();
- BigDecimal orderMaterialId = omstruckOrderMaterialMapper.selectMaxId();
- omstruckOrderMaterial.setOrderMaterialId(orderMaterialId);
- omstruckOrderMaterial.setOrderId(orderId);
- omstruckOrderMaterial.setInsertTime(new Date());
- omstruckOrderMaterial.setUpdateTime(new Date());
- omstruckOrderMaterial.setInsertUsername("admin");
- omstruckOrderMaterial.setUpdateUsername("admin");
- omstruckOrderMaterial.setInsertUpdateRemark("无");
- if (map != null) {
- BigDecimal materialTheoreticalWeight = (BigDecimal) map.get("materialTheoreticalWeight");
- BigDecimal saleOrderMaterialNumber = (BigDecimal) map.get("saleOrderMaterialNumber");
- BigDecimal materialId = (BigDecimal) map.get("materialId");
- omstruckOrderMaterial.setOrderMaterialWeight(materialTheoreticalWeight);
- omstruckOrderMaterial.setMaterialId(materialId);
- omstruckOrderMaterial.setOrderMaterialNumber(saleOrderMaterialNumber);
- }
- omstruckOrderMaterialMapper.insertSelective(omstruckOrderMaterial);
- }
- }
- // RmsCapacity rmsCapacity = new RmsCapacity();
- // rmsCapacity.setCapacityId(capacityId);
- // rmsCapacity.setCapacityStatus(new BigDecimal(2));
- // rmsCapacityMapper.updateByPrimaryKeySelective(rmsCapacity);
- int result = omstruckOrderMapper.insertSelective(omstruckOrder);
- // 调用websocket推送数据给司机
- pushMesToWebsocket(orderIdMap);
- return result;
- }
- /**
- * 根据运单id关闭订单
- * @param orderId
- * @return
- */
- @Override
- public int closeOmstruckOrder(BigDecimal orderId) {
- OmstruckOrder omstruckOrder = omstruckOrderMapper.selectByPrimaryKey(orderId);
- omstruckOrder.setOrderStatus(new BigDecimal(7));
- int result = omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
- return result;
- }
- /**
- * 查询所有车牌号和司机
- * @param mapValue
- * @return
- */
- @Override
- public List<Map<String, Object>> getCapacityAndDriverList(Map<String, Object> mapValue) {
- return omstruckOrderMapper.getCapacityAndDriver(mapValue);
- }
- @Override
- public int closeOrder(Map<String, Object> map) {
- Integer orderId =(Integer) map.get("orderId");
- OmstruckOrder omstruckOrder=new OmstruckOrder();
- omstruckOrder.setOrderId(DataChange.dataToBigDecimal(orderId));
- omstruckOrder.setOrderStatus(new BigDecimal(8));
- omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
- return 1;
- }
- /**
- * 分解内转计划(新增运输订单)
- * @param mapValue
- * @return
- */
- @Transactional
- @Override
- public int addInwardOrder(Map<String, Object> mapValue) {
- int result = 0;
- BigDecimal orderType;
- List<Map<String,Object>> mapList = (List<Map<String, Object>>) mapValue.get("mapList");
- BigDecimal planId = DataChange.dataToBigDecimal(mapValue.get("planId")) ;
- BigDecimal lineId = DataChange.dataToBigDecimal(mapValue.get("lineId")) ;
- orderType = DataChange.dataToBigDecimal(mapValue.get("orderType"));
- String userId=(String) mapValue.get("userId");
- //根据计划查找需求,如果是计时,就添加新的订单类型
- String inwardType = amstruckInwardPlanMapper.getInwardByPlanId(planId);
- if (inwardType.equals("计时")) {
- mapValue.remove(orderType);
- orderType = BigDecimal.valueOf(21);
- mapValue.put("orderType", orderType);
- }
- Integer carrierId = (Integer) mapValue.get("carrierId");
- AmstruckInwardPlan amstruckInwardPlan = amstruckInwardPlanMapper.selectByPrimaryKey(planId);
- amstruckInwardPlan.setPlanStatus(new BigDecimal(3));
- result += amstruckInwardPlanMapper.updateByPrimaryKeySelective(amstruckInwardPlan);
- for (Map<String,Object> orderMap : mapList) {
- OmstruckOrder omstruckOrder = new OmstruckOrder();
- omstruckOrder.setInsertUsername(userId);
- String capacityNumber = (String)orderMap.get("capacityNumber");
- List<Map<String,Object>>orderMaterialList = (List<Map<String,Object>>)orderMap.get("orderMaterialList");
- Map<String,Object> capacityMap = new HashMap<>();
- capacityMap.put("capacityNumber",capacityNumber);
- List<RmsCapacity> rmsCapacities = rmsCapacityMapper.selectByParameters(capacityMap);
- RmsCapacity rmsCapacity = rmsCapacities.get(0);
- // rmsCapacity.setCapacityStatus(new BigDecimal(2));
- result +=rmsCapacityMapper.updateByPrimaryKeySelective(rmsCapacity);
- BigDecimal capacityId = rmsCapacity.getCapacityId();
- capacityMap.clear();
- capacityMap.put("capacityId",capacityId);
- BigDecimal orderId = omstruckOrderMapper.selectMaxId();
- // 添加总实绩
- Map<String,Object> orderIdMap = new HashMap<>();
- orderIdMap.put("orderId",orderId);
- tmsTruckFeign.addTotalResult(orderIdMap);
- omstruckOrder.setOrderId(orderId);
- omstruckOrder.setOrderPlanId(planId);
- String orderNumber = DataChange.generateEightDigitsNumber("WYSDD", orderId.intValue());
- omstruckOrder.setOrderNumber(orderNumber);
- omstruckOrder.setOrderIssueTime(new Date());
- omstruckOrder.setOrderStatus(new BigDecimal(4));
- omstruckOrder.setCapacityId(capacityId);
- omstruckOrder.setInsertTime(new Date());
- omstruckOrder.setUpdateTime(new Date());
- omstruckOrder.setInsertUpdateRemark("无");
- omstruckOrder.setDeleted(new BigDecimal(0));
- omstruckOrder.setOrderType(orderType);
- if(lineId != null){
- omstruckOrder.setLineId(lineId);
- }
- omstruckOrder.setCarrierId(new BigDecimal(carrierId));
- result +=omstruckOrderMapper.insertSelective(omstruckOrder);
- for (Map<String,Object>orderMaterial:orderMaterialList
- ) {
- OmstruckOrderMaterial omstruckOrderMaterial = new OmstruckOrderMaterial();
- BigDecimal orderMaterialId = omstruckOrderMaterialMapper.selectMaxId();
- BigDecimal materialId = DataChange.dataToBigDecimal(orderMaterial.get("materialId"));
- omstruckOrderMaterial.setOrderMaterialId(orderMaterialId);
- omstruckOrderMaterial.setOrderId(orderId);
- omstruckOrderMaterial.setMaterialId(materialId);
- if (orderMaterial.get("materialCount")!=null) {
- omstruckOrderMaterial.setOrderMaterialNumber(DataChange.dataToBigDecimal(orderMaterial.get("materialCount")));
- }
- omstruckOrderMaterial.setInsertTime(new Date());
- omstruckOrderMaterial.setInsertUsername(userId);
- omstruckOrderMaterial.setUpdateTime(new Date());
- if (orderMaterial.get("materialWeight")!=null) {
- omstruckOrderMaterial.setOrderMaterialWeight(DataChange.dataToBigDecimal(orderMaterial.get("materialWeight")));
- }
- result +=omstruckOrderMaterialMapper.insertSelective(omstruckOrderMaterial);
- }
- }
- return result;
- }
- /**
- * 查询分解计划
- * @param mapValue
- * @return
- */
- @Override
- public List<Map<String, Object>> getInwardOrderList(Map<String, Object> mapValue) {
- List<Map<String,Object>> mapList = omstruckOrderMapper.getInwardOrderList(mapValue);
- return mapList;
- }
- /**
- * 下发计划
- * @param mapList
- * @return
- */
- @Override
- public int issuePlanOrder(List<Map<String, Object>> mapList) {
- int result = 0;
- for (Map<String,Object> map : mapList) {
- Integer orderId = (Integer) map.get("orderId");
- OmstruckOrder omstruckOrder = omstruckOrderMapper.selectByPrimaryKey(new BigDecimal(orderId));
- omstruckOrder.setOrderStatus(new BigDecimal(4));
- omstruckOrder.setOrderIssueTime(new Date());
- result += omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
- }
- return result;
- }
- /**
- * 分派计划
- * @param mapList
- * @return
- */
- @Override
- public int apportionInwardOrder(List<Map<String, Object>> mapList) {
- int result = 0;
- for (Map<String,Object> map : mapList) {
- BigDecimal orderId = new BigDecimal((Integer) map.get("orderId"));
- OmstruckOrder omstruckOrder = omstruckOrderMapper.selectByPrimaryKey(orderId);
- omstruckOrder.setOrderIssueTime(new Date());
- omstruckOrder.setOrderStatus(new BigDecimal(4));
- // Map<Object, Object> map9 = new HashMap<>();
- // long data = new Date().getTime();
- // //根据运输订单id查询车牌号
- // String capacityNumber = omstruckOrderMapper.selectCapacityNumber(orderId);
- // BigDecimal orderType = omstruckOrderMapper.selectOrderType(orderId);
- //
- // map9.put("receivePerson",capacityNumber);
- // map9.put("messageType",2);
- // map9.put("snedPerson","system");
- // map9.put("creatTime",data);
- result += omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
- }
- return result;
- }
- /**
- * 司机APP端查询下发给自己运输订单
- * @param capacityNumber
- * @return
- */
- @Override
- public List<Map<String, Object>> sendOrderToApp(String capacityNumber) {
- //通过车牌号匹配运力ID
- BigDecimal capacityId = omstruckOrderMapper.getCapacityIdByCapacityNum(capacityNumber);
- List<Map<String,Object>> resultList = omstruckOrderMapper.getResultList(capacityId);
- for (Map<String,Object> map : resultList) {
- BigDecimal orderId = (BigDecimal) map.get("orderId");
- BigDecimal orderType = (BigDecimal) map.get("orderType");
- // 查询物资信息
- List<Map<String,Object>> materialMapList = omstruckOrderMapper.getMaterialMes(orderId);
- String allMaterialName = "";
- String allMaterialNumber = "";
- String allMaterialWeight = "";
- String allMaterialSpecificationModel = "";
- // 对物资信息进行处理
- if (materialMapList == null && materialMapList.size() == 0) {
- } else {
- for (Map<String,Object> materialMap : materialMapList) {
- String materialName = (String) materialMap.get("materialName");
- BigDecimal materialNumber = (BigDecimal) materialMap.get("materialNumber");
- BigDecimal materialWeight = (BigDecimal) materialMap.get("materialWeight");
- String materialModel = (String) materialMap.get("materialModel");
- String materialSpecification = (String) materialMap.get("materialSpecification");
- if (materialName != null) {
- allMaterialName += materialName + "/";
- }
- if (materialNumber != null) {
- allMaterialNumber += materialNumber.toString() + "/";
- }
- if (materialWeight != null) {
- allMaterialWeight += materialWeight.toString() + "/";
- }
- if (materialSpecification != null || materialModel != null) {
- allMaterialSpecificationModel += materialSpecification + materialModel + "/";
- }
- }
- String subMaterialName = "";
- String subMaterialNumber = "";
- String subMaterialWeight = "";
- String subMaterialSpecificationModel = "";
- if (allMaterialName.length() >= 2) {
- subMaterialName = allMaterialName.substring(0, allMaterialName.length() - 2);
- }
- if (allMaterialName.length() < 2) {
- subMaterialName = allMaterialName;
- }
- if (allMaterialNumber.length() >= 2) {
- subMaterialNumber = allMaterialNumber.substring(0, allMaterialNumber.length() - 1);
- }
- if (allMaterialNumber.length() < 2) {
- subMaterialNumber = allMaterialNumber;
- }
- if (allMaterialWeight.length() >= 2) {
- subMaterialWeight = allMaterialWeight.substring(0, allMaterialWeight.length() - 1);
- }
- if (allMaterialWeight.length() < 2) {
- subMaterialWeight = allMaterialWeight;
- }
- if (allMaterialSpecificationModel.length() >= 2) {
- subMaterialSpecificationModel = allMaterialSpecificationModel.substring(0, allMaterialSpecificationModel.length() - 2);
- }
- if (allMaterialSpecificationModel.length() < 2) {
- subMaterialSpecificationModel = allMaterialSpecificationModel;
- }
- map.put("allMaterialName", subMaterialName);
- map.put("allMaterialNumber", subMaterialNumber);
- map.put("allMaterialWeight", subMaterialWeight);
- map.put("allMaterialSpecificationModel", subMaterialSpecificationModel);
- }
- Map<String,Object> orderMap = null;
- int intValue = orderType.intValue();
- if (intValue == 1 || intValue == 2 || intValue == 3) {
- orderMap = omstruckOrderMapper.getSaleOrderMap(orderId);
- }
- if (intValue == 4) {
- orderMap = omstruckOrderMapper.getSteelInwardOrderMap(orderId);
- }
- if (intValue == 5 || intValue == 6 || intValue == 7 || intValue == 8) {
- orderMap = omstruckOrderMapper.getPurchaseOrderMap(orderId);
- }
- if (intValue == 9 || intValue == 10 || intValue == 11) {
- orderMap = omstruckOrderMapper.getInwardOrderMap(orderId);
- }
- map.putAll(orderMap);
- }
- return resultList;
- }
- //新增内转异地库计划订单(新增运输订单)
- @Override
- public int apportionInwardOffsetOrder(Map<String, Object> mapValue) {
- int result = 0;
- List<Map<String,Object>> mapList = (List<Map<String, Object>>) mapValue.get("mapList");
- String dayPlanId = (String) mapValue.get("dayPlanId");
- Integer lineId = (Integer) mapValue.get("lineId");
- String orderType = (String) mapValue.get("orderType");
- // Integer carrierId = (Integer) mapValue.get("carrierId");
- // AmstruckInwardPlan amstruckInwardPlan = amstruckInwardPlanMapper.selectByPrimaryKey(new BigDecimal(planId));
- // amstruckInwardPlan.setPlanStatus(new BigDecimal(3));
- // result += amstruckInwardPlanMapper.updateByPrimaryKeySelective(amstruckInwardPlan);
- BigDecimal materialId = omstruckOrderMapper.getInwardMaterial(new BigDecimal(dayPlanId));
- for (Map<String,Object> orderMap : mapList) {
- OmstruckOrder omstruckOrder = new OmstruckOrder();
- String capacityNumber = (String)orderMap.get("capacityNumber");
- BigDecimal materialNumber = DataChange.dataToBigDecimal(orderMap.get("materialNumber")) ;
- // BigDecimal materialWeight = DataChange.dataToBigDecimal(orderMap.get("materialWeight"));
- Map<String,Object> capacityMap = new HashMap<>();
- capacityMap.put("capacityNumber",capacityNumber);
- List<RmsCapacity> rmsCapacities = rmsCapacityMapper.selectByParameters(capacityMap);
- RmsCapacity rmsCapacity = rmsCapacities.get(0);
- rmsCapacity.setCapacityStatus(new BigDecimal(2));
- result +=rmsCapacityMapper.updateByPrimaryKeySelective(rmsCapacity);
- BigDecimal capacityId = rmsCapacity.getCapacityId();
- capacityMap.clear();
- capacityMap.put("capacityId",capacityId);
- List<RmsDriverCapacity> rmsDriverCapacities = rmsDriverCapacityMapper.selectByParameters(capacityMap);
- RmsDriverCapacity rmsDriverCapacity = rmsDriverCapacities.get(0);
- BigDecimal dcId = rmsDriverCapacity.getDriverCapacityId();
- if(dcId!=null){
- BigDecimal orderId = omstruckOrderMapper.selectOrderId(dcId);
- OmstruckOrderMaterial omstruckOrderMaterial = new OmstruckOrderMaterial();
- BigDecimal orderMaterialId = omstruckOrderMaterialMapper.selectMaxId();
- omstruckOrderMaterial.setOrderMaterialId(orderMaterialId);
- omstruckOrderMaterial.setOrderId(orderId);
- omstruckOrderMaterial.setMaterialId(materialId);
- omstruckOrderMaterial.setOrderMaterialNumber(materialNumber);
- omstruckOrderMaterial.setInsertTime(new Date());
- omstruckOrderMaterial.setUpdateTime(new Date());
- omstruckOrderMaterial.setInsertUsername("admin");
- omstruckOrderMaterial.setUpdateUsername("admin");
- omstruckOrderMaterial.setInsertUpdateRemark("无");
- }
- // rmsDriverCapacity.setCarrierId(new BigDecimal(carrierId));
- result +=rmsDriverCapacityMapper.updateByPrimaryKeySelective(rmsDriverCapacity);
- BigDecimal orderId = omstruckOrderMapper.selectMaxId();
- omstruckOrder.setOrderId(orderId);
- omstruckOrder.setOrderPlanId(new BigDecimal(dayPlanId));
- String orderNumber = DataChange.generateEightDigitsNumber("WYSDD", orderId.intValue());
- omstruckOrder.setOrderNumber(orderNumber);
- omstruckOrder.setOrderIssueTime(new Date());
- omstruckOrder.setOrderStatus(new BigDecimal(3));
- omstruckOrder.setInsertTime(new Date());
- omstruckOrder.setUpdateTime(new Date());
- omstruckOrder.setInsertUsername("admin");
- omstruckOrder.setUpdateUsername("admin");
- omstruckOrder.setInsertUpdateRemark("无");
- omstruckOrder.setDeleted(new BigDecimal(0));
- omstruckOrder.setOrderType(new BigDecimal(orderType));
- omstruckOrder.setLineId(new BigDecimal(lineId));
- result +=omstruckOrderMapper.insertSelective(omstruckOrder);
- OmstruckOrderMaterial omstruckOrderMaterial = new OmstruckOrderMaterial();
- BigDecimal orderMaterialId = omstruckOrderMaterialMapper.selectMaxId();
- omstruckOrderMaterial.setOrderMaterialId(orderMaterialId);
- omstruckOrderMaterial.setOrderId(orderId);
- omstruckOrderMaterial.setMaterialId(materialId);
- omstruckOrderMaterial.setOrderMaterialNumber(materialNumber);
- omstruckOrderMaterial.setInsertTime(new Date());
- omstruckOrderMaterial.setUpdateTime(new Date());
- omstruckOrderMaterial.setInsertUsername("admin");
- omstruckOrderMaterial.setUpdateUsername("admin");
- omstruckOrderMaterial.setInsertUpdateRemark("无");
- // omstruckOrderMaterial.setOrderMaterialWeight(materialWeight);
- result +=omstruckOrderMaterialMapper.insertSelective(omstruckOrderMaterial);
- }
- return result;
- }
- /**
- * 查询运单下的所有信息
- * @param capacityNumber
- * @return
- */
- @Override
- public List<Map<String, Object>> getAllOrderMessage(String capacityNumber) {
- List<Map<String, Object>> resultList;
- // 判断是走采购,销售还是内转
- resultList = omstruckOrderMapper.getResultListByCapacity(capacityNumber);
- // 如果不是内转则取下面的orderId和orderType
- if (resultList == null || resultList.size() == 0) {
- //通过车牌号匹配运力ID
- BigDecimal capacityId = omstruckOrderMapper.getCapacityIdByCapacityNum(capacityNumber);
- BigDecimal driverCapacityId = omstruckOrderMapper.getDriverCapacityId(capacityId);
- resultList = omstruckOrderMapper.getResultList(driverCapacityId);
- }
- // 循环遍历出每一条运输订单的信息
- for (Map<String, Object> map : resultList) {
- BigDecimal orderId = (BigDecimal) map.get("orderId");
- BigDecimal orderType = (BigDecimal) map.get("orderType");
- // 查询物资信息
- List<Map<String, Object>> materialMapList = omstruckOrderMapper.getMaterialMes(orderId);
- String allMaterialName = "";
- String allMaterialNumber = "";
- String allMaterialWeight = "";
- String allMaterialSpecificationModel = "";
- // 对物资信息进行处理
- if (materialMapList == null && materialMapList.size() == 0) {
- } else {
- for (Map<String, Object> materialMap : materialMapList) {
- String materialName = (String) materialMap.get("materialName");
- BigDecimal materialNumber = (BigDecimal) materialMap.get("materialNumber");
- BigDecimal materialWeight = (BigDecimal) materialMap.get("materialWeight");
- String materialModel = (String) materialMap.get("materialModel");
- String materialSpecification = (String) materialMap.get("materialSpecification");
- if (materialName != null) {
- allMaterialName += materialName + "/";
- }
- if (materialNumber != null) {
- allMaterialNumber += materialNumber.toString() + "/";
- }
- if (materialWeight != null) {
- allMaterialWeight += materialWeight.toString() + "/";
- }
- if (materialSpecification != null || materialModel != null) {
- allMaterialSpecificationModel += materialSpecification + materialModel + "/";
- }
- }
- String subMaterialName = "";
- String subMaterialNumber = "";
- String subMaterialWeight = "";
- String subMaterialSpecificationModel = "";
- if (allMaterialName.length() >= 2) {
- subMaterialName = allMaterialName.substring(0, allMaterialName.length() - 2);
- }
- if (allMaterialName.length() < 2) {
- subMaterialName = allMaterialName;
- }
- if (allMaterialNumber.length() >= 2) {
- subMaterialNumber = allMaterialNumber.substring(0, allMaterialNumber.length() - 1);
- }
- if (allMaterialNumber.length() < 2) {
- subMaterialNumber = allMaterialNumber;
- }
- if (allMaterialWeight.length() >= 2) {
- subMaterialWeight = allMaterialWeight.substring(0, allMaterialWeight.length() - 1);
- }
- if (allMaterialWeight.length() < 2) {
- subMaterialWeight = allMaterialWeight;
- }
- if (allMaterialSpecificationModel.length() >= 2) {
- subMaterialSpecificationModel = allMaterialSpecificationModel.substring(0, allMaterialSpecificationModel.length() - 2);
- }
- if (allMaterialSpecificationModel.length() < 2) {
- subMaterialSpecificationModel = allMaterialSpecificationModel;
- }
- map.put("allMaterialName", subMaterialName);
- map.put("allMaterialNumber", subMaterialNumber);
- map.put("allMaterialWeight", subMaterialWeight);
- map.put("allMaterialSpecificationModel", subMaterialSpecificationModel);
- }
- Map<String, Object> orderMap = null;
- int intValue = orderType.intValue();
- if (intValue == 1 || intValue == 2 || intValue == 3) {
- orderMap = omstruckOrderMapper.getSaleMap(orderId);
- }
- if (intValue == 4) {
- orderMap = omstruckOrderMapper.getSteelInwardMap(orderId);
- }
- if (intValue == 5 || intValue == 6 || intValue == 7 || intValue == 8) {
- orderMap = omstruckOrderMapper.getPurchaseMap(orderId);
- }
- if (intValue == 9 || intValue == 10 || intValue == 11) {
- orderMap = omstruckOrderMapper.getInwardMap(orderId);
- }
- map.putAll(orderMap);
- }
- return resultList;
- }
- /**
- * 司机确认订单
- * orderNumber 运输订单号
- * @param map
- * @return
- */
- @Override
- public int driverConfirmation(Map<String, Object> map) {
- OmstruckOrder omstruckOrder = new OmstruckOrder();
- BigDecimal orderId;
- //通过运输订单号查询运输订单Id
- if(map.get("orderId") == null){
- orderId = new BigDecimal(omstruckOrderMapper.getOrderIdByOrderNumber((String) map.get("orderNumber")));
- }else {
- orderId = DataChange.dataToBigDecimal(map.get("orderId"));
- }
- Map<String, Object> seqMap = omstruckOrderMapper.getMaxLineSeqByOrderId(orderId);
- if(seqMap != null){
- //如果没有到最后一步之前 不允许确认
- BigDecimal orderLineSequence = DataChange.dataToBigDecimal(seqMap.get("orderLineSequence"));
- BigDecimal maxSegmentSqe = DataChange.dataToBigDecimal(seqMap.get("segmentSqe"));
- int i = maxSegmentSqe.intValue() - orderLineSequence.intValue();
- if( i != 1){
- return 0;
- }
- }
- omstruckOrder.setOrderId(orderId);
- //设置司机确认订单
- omstruckOrder.setDriverConfirmation(new BigDecimal(1));
- omstruckOrder.setUpdateTime(new Date());
- return omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
- }
- /**
- * 查询订单是否确认
- * @Author TXF
- * @Date 2022/1/4 23:36
- * @param map {orderId}
- * @return
- **/
- public boolean getDriverConfirmation(Map<String, Object> map){
- Integer driverConfirmation = omstruckOrderMapper.getDriverConfirmation(DataChange.dataToBigDecimal(map.get("orderId")));
- if(driverConfirmation == null){
- return true;
- }else {
- return false;
- }
- }
- /**
- * 通过运输订单号查询订单信息给司机
- * @param map
- * @return
- */
- public Map<String, Object> getMessageToApp(Map<String, Object> map){
- BigDecimal orderId = DataChange.dataToBigDecimal(map.get("orderId"));
- Integer orderType;
- String inwardType="";
- //获取订单类型
- if(map.get("orderType") == null){
- orderType = omstruckOrderMapper.getOrderTypeByOrderNumber(orderId);
- }else {
- orderType = DataChange.dataToBigDecimal(map.get("orderType")).intValue();
- }
- Map<String, Object> mesMap = new HashMap<>();
- switch (orderType){
- case 1:
- case 2:
- mesMap = omstruckOrderMapper.getXSOrderMessageToApp(map);
- break;
- case 3:
- case 4:
- mesMap = omstruckOrderMapper.getFYJHOrderMessageToApp(map);
- break;
- case 5:
- case 6:
- case 7:
- case 8:
- case 17:
- case 18:
- mesMap = omstruckOrderMapper.getCGOrderMessageToApp(map);
- break;
- case 9:
- case 10:
- case 20:
- mesMap = omstruckOrderMapper.getNZOrderMessageToApp(map);
- mesMap.put("loadName","化工园区铁专线");
- BigDecimal organizationId =(BigDecimal) mesMap.get("organizationId");
- if (organizationId.intValue()==1){
- mesMap.put("organizationCode","一厂");
- }else if (organizationId.intValue()==2){
- mesMap.put("organizationCode","二厂");
- }
- break;
- case 11:
- mesMap = omstruckOrderMapper.getInwardOrderMessageToApp(map);
- inwardType += "计重";
- mesMap.put("inwardType", inwardType);
- break;
- case 21:
- mesMap = omstruckOrderMapper.getInwardTimeOrderMessageToApp(map);
- inwardType += "计时";
- mesMap.put("inwardType", inwardType);
- break;
- case 12:
- case 13:
- case 14:
- mesMap = omstruckOrderMapper.getSporadicOrder(map);
- break;
- case 19:
- mesMap=omstruckOrderMapper.getSporadicOrder(map);
- mesMap.put("type", "零星退货");
- }
- mesMap.put("materialMesList", omstruckOrderMapper.getMaterialMes(orderId));
- return mesMap;
- }
- /**
- * 通过车牌号查询所有已下发未接收的订单信息
- * @param map
- * @return
- */
- public List<Map<String, Object>> getAllOrderMessagesByCapacityNum(Map<String, Object> map){
- String capacityNumber = (String) map.get("capacityNumber");
- //通过车牌号查询所有未下发的订单ID
- List<Map<String, Object>> orderMesList = omstruckOrderMapper.getOrderIdListByCapacityNumber(capacityNumber);
- List<Map<String, Object>> mesMapList = new ArrayList<>();
- for (Map<String, Object> orderMesMap: orderMesList) {
- int orderType = DataChange.dataToBigDecimal(orderMesMap.get("orderType")).intValue();
- //如果订单类型为2 则判断订单发货日期是否为当日 如果不是当日则不给显示
- if(orderType == 2){
- Integer judgeDate = omstruckOrderSeparateMapper.getDeliveryDate(orderMesMap.get("orderId"));
- if(judgeDate == null){ // 数据为空则是已过截止日期 关闭订单
- omstruckOrderMapper.closeTruckOrder(DataChange.dataToBigDecimal(orderMesMap.get("orderId")));
- continue;
- }
- }
- if(orderType == 10|| orderType == 20){
- Integer planEnable = omstruckOrderSeparateMapper.getOrderPlanEnable(orderMesMap.get("orderId"));
- if(planEnable == 0){ // 数据为0则失效
- omstruckOrderMapper.closeTruckOrder(DataChange.dataToBigDecimal(orderMesMap.get("orderId")));
- continue;
- }
- }
- if(orderType == 12|| orderType == 13 || orderType == 14 || orderType == 19){
- Integer sporadicStatus = omstruckOrderSeparateMapper.getSporadicStatus(orderMesMap.get("orderId"));
- if(sporadicStatus == 0){ // 数据为0则失效
- omstruckOrderMapper.closeTruckOrder(DataChange.dataToBigDecimal(orderMesMap.get("orderId")));
- continue;
- }
- }
- //如果订单类型为11 当订单大于截止日期时,不显示订单
- if(orderType == 11 || orderType == 21){
- int result = omstruckOrderSeparateMapper.getInward(orderMesMap.get("orderId"));
- if(result == 0){
- omstruckOrderMapper.closeTruckOrder(DataChange.dataToBigDecimal(orderMesMap.get("orderId")));
- continue;
- }
- }
- Map<String, Object> mesMap = getMessageToApp(orderMesMap);
- mesMapList.add(mesMap);
- }
- return mesMapList;
- }
- /**
- * 新增进口矿
- * @param mapValue
- * @return
- */
- @Transactional
- @Override
- public int addInputOrder(Map<String, Object> mapValue) {
- List<Map<String,Object>> mapList = (List<Map<String, Object>>) mapValue.get("mapList");
- BigDecimal purchaseOrderId = new BigDecimal((Integer) mapValue.get("purchaseOrderId"));
- BigDecimal materialId = new BigDecimal((Integer) mapValue.get("materialId"));
- BigDecimal orderType = new BigDecimal((Integer) mapValue.get("orderType"));
- BigDecimal lineId = new BigDecimal((Integer) mapValue.get("lineId"));
- Integer planId = (Integer) mapValue.get("planId");
- int result = 0;
- for (Map<String, Object> map : mapList) {
- OmstruckOrder omstruckOrder = new OmstruckOrder();
- OmstruckOrderMaterial omstruckOrderMaterial = new OmstruckOrderMaterial();
- BigDecimal orderId = omstruckOrderMapper.selectMaxId();
- BigDecimal orderMaterialId = omstruckOrderMaterialMapper.selectMaxId();
- String capacityNumber = (String)map.get("capacityNumber");
- BigDecimal capacityId = omstruckOrderMapper.getCapacityId(capacityNumber);
- BigDecimal materialWeight = DataChange.dataToBigDecimal(map.get("orderMaterialWeight"));
- String unloadPoint = (String) map.get("unloadPoint");
- BigDecimal unloadPointId = omstruckOrderMapper.getUnloadPointId(unloadPoint);
- // Date orderEntryTime = new Date((Long) map.get("orderEntryTime"));
- // 运输订单
- omstruckOrder.setOrderId(orderId);
- omstruckOrder.setOrderNumber(DataChange.generateEightDigitsNumber("WYSDD",orderId.intValue()));
- omstruckOrder.setCapacityId(capacityId);
- omstruckOrder.setOrderPlanId(purchaseOrderId);
- omstruckOrder.setOrderType(orderType);
- omstruckOrder.setOrderStatus(new BigDecimal(3));
- omstruckOrder.setLineId(lineId);
- omstruckOrder.setUnloadPointId(unloadPointId);
- // omstruckOrder.setOrderEntryTime(orderEntryTime);
- omstruckOrder.setInsertTime(new Date());
- omstruckOrder.setInsertUsername("admin");
- // 运输订单子表
- omstruckOrderMaterial.setOrderMaterialId(orderMaterialId);
- omstruckOrderMaterial.setOrderId(orderId);
- omstruckOrderMaterial.setOrderMaterialWeight(materialWeight);
- omstruckOrderMaterial.setMaterialId(materialId);
- omstruckOrderMaterial.setInsertTime(new Date());
- omstruckOrderMaterial.setInsertUsername("admin");
- result += omstruckOrderMapper.insertSelective(omstruckOrder);
- result += omstruckOrderMaterialMapper.insertSelective(omstruckOrderMaterial);
- //新增实绩总表关联订单 feign 调用truckTms
- map.put("orderId", omstruckOrder.getOrderId());
- tmsTruckFeign.addTotalResult(map);
- //更改运输计划子表 增加已分配重量 减少未分配重量 feign调用ams
- map.put("planId",planId);
- amsFeign.updateMaterial(map);
- }
- return result;
- }
- }
|