AmsSaleOrderServiceImpl.java 174 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093209420952096209720982099210021012102210321042105210621072108210921102111211221132114211521162117211821192120212121222123212421252126212721282129213021312132213321342135213621372138213921402141214221432144214521462147214821492150215121522153215421552156215721582159216021612162216321642165216621672168216921702171217221732174217521762177217821792180218121822183218421852186218721882189219021912192219321942195219621972198219922002201220222032204220522062207220822092210221122122213221422152216221722182219222022212222222322242225222622272228222922302231223222332234223522362237223822392240224122422243224422452246224722482249225022512252225322542255225622572258225922602261226222632264226522662267226822692270227122722273227422752276227722782279228022812282228322842285228622872288228922902291229222932294229522962297229822992300230123022303230423052306230723082309231023112312231323142315231623172318231923202321232223232324232523262327232823292330233123322333233423352336233723382339234023412342234323442345234623472348234923502351235223532354235523562357235823592360236123622363236423652366236723682369237023712372237323742375237623772378237923802381238223832384238523862387238823892390239123922393239423952396239723982399240024012402240324042405240624072408240924102411241224132414241524162417241824192420242124222423242424252426242724282429243024312432243324342435243624372438243924402441244224432444244524462447244824492450245124522453245424552456245724582459246024612462246324642465246624672468246924702471247224732474247524762477247824792480248124822483248424852486248724882489249024912492249324942495249624972498249925002501250225032504250525062507250825092510251125122513251425152516251725182519252025212522252325242525252625272528252925302531253225332534253525362537253825392540254125422543254425452546254725482549255025512552255325542555255625572558255925602561256225632564256525662567256825692570257125722573257425752576257725782579258025812582258325842585258625872588258925902591259225932594259525962597259825992600260126022603260426052606260726082609261026112612261326142615261626172618261926202621262226232624262526262627262826292630263126322633263426352636263726382639264026412642264326442645264626472648264926502651265226532654265526562657265826592660266126622663266426652666266726682669267026712672267326742675267626772678267926802681268226832684268526862687268826892690269126922693269426952696269726982699270027012702270327042705270627072708270927102711271227132714271527162717271827192720272127222723272427252726272727282729273027312732273327342735273627372738273927402741274227432744274527462747274827492750275127522753275427552756275727582759276027612762276327642765276627672768276927702771277227732774277527762777277827792780278127822783278427852786278727882789279027912792279327942795279627972798279928002801280228032804280528062807280828092810281128122813281428152816281728182819282028212822282328242825282628272828282928302831283228332834283528362837283828392840284128422843284428452846284728482849285028512852285328542855285628572858285928602861286228632864286528662867286828692870287128722873287428752876287728782879288028812882288328842885288628872888288928902891289228932894289528962897289828992900290129022903290429052906290729082909291029112912291329142915291629172918291929202921292229232924292529262927292829292930293129322933293429352936293729382939294029412942294329442945294629472948294929502951295229532954295529562957295829592960296129622963296429652966296729682969297029712972297329742975297629772978297929802981298229832984298529862987298829892990299129922993299429952996299729982999300030013002300330043005300630073008300930103011301230133014301530163017301830193020302130223023302430253026302730283029303030313032303330343035303630373038303930403041304230433044304530463047304830493050305130523053305430553056305730583059306030613062306330643065306630673068306930703071307230733074307530763077307830793080308130823083308430853086308730883089309030913092309330943095309630973098309931003101310231033104310531063107310831093110311131123113311431153116311731183119312031213122312331243125312631273128312931303131313231333134313531363137313831393140314131423143314431453146314731483149315031513152315331543155315631573158315931603161316231633164316531663167316831693170317131723173317431753176317731783179318031813182318331843185318631873188318931903191319231933194319531963197319831993200320132023203320432053206320732083209321032113212321332143215321632173218321932203221322232233224322532263227322832293230323132323233323432353236323732383239324032413242324332443245324632473248324932503251325232533254325532563257325832593260326132623263326432653266326732683269327032713272327332743275327632773278327932803281328232833284328532863287328832893290329132923293329432953296329732983299330033013302330333043305330633073308330933103311331233133314331533163317331833193320332133223323332433253326332733283329333033313332333333343335333633373338333933403341334233433344334533463347334833493350335133523353335433553356335733583359336033613362336333643365336633673368336933703371337233733374337533763377337833793380338133823383338433853386338733883389339033913392339333943395339633973398339934003401340234033404340534063407340834093410341134123413341434153416341734183419342034213422342334243425342634273428342934303431343234333434343534363437343834393440344134423443344434453446344734483449345034513452345334543455345634573458345934603461346234633464346534663467346834693470347134723473347434753476347734783479348034813482348334843485348634873488348934903491349234933494349534963497349834993500
  1. package com.steerinfo.dil.service.impl;
  2. import com.alibaba.druid.support.json.JSONUtils;
  3. import com.alibaba.fastjson.JSON;
  4. import com.alibaba.fastjson.JSONObject;
  5. import com.steerinfo.dil.feign.*;
  6. import com.steerinfo.dil.mapper.*;
  7. import com.steerinfo.dil.model.*;
  8. import com.steerinfo.dil.service.IAmsSaleOrderService;
  9. import com.steerinfo.dil.util.*;
  10. import com.steerinfo.framework.utils.base.StringUtils;
  11. import io.swagger.annotations.ApiOperation;
  12. import org.springframework.beans.factory.annotation.Autowired;
  13. import org.springframework.scheduling.annotation.Scheduled;
  14. import org.springframework.stereotype.Service;
  15. import org.springframework.transaction.annotation.Transactional;
  16. import javax.annotation.Resource;
  17. import java.math.BigDecimal;
  18. import java.text.ParseException;
  19. import java.text.SimpleDateFormat;
  20. import java.util.*;
  21. /**
  22. * AmsSaleOrder服务实现:
  23. *
  24. * @author generator
  25. * @version 1.0-SNAPSHORT 2021-09-06 07:10
  26. * 类描述
  27. * 修订历史:
  28. * 日期:2021-09-06
  29. * 作者:generator
  30. * 参考:
  31. * 描述:AmsSaleOrder服务实现
  32. * @Copyright 湖南视拓信息技术股份有限公司. All rights reserved.
  33. * @see null
  34. */
  35. @Service(value = "amsSaleOrderService")
  36. public class AmsSaleOrderServiceImpl implements IAmsSaleOrderService {
  37. @Autowired
  38. private AmsSaleOrderMapper amsSaleOrderMapper;
  39. @Autowired
  40. private AmsSaleOrderMaterialMapper amsSaleOrderMaterialMapper;
  41. @Autowired
  42. private AmsSaleTrucknoMaterialMapper trucknoMaterialMapper;
  43. @Autowired
  44. TmstruckLoadResult tmstruckLoadResult;
  45. @Autowired
  46. TmstruckWeightResult tmstruckWeightResult;
  47. @Autowired
  48. TmstruckWeightResultMapper tmstruckWeightResultMapper;
  49. @Autowired
  50. TmstruckLoadResultMapper tmstruckLoadResultMapper;
  51. @Autowired
  52. AmsDispatchSaleOrderMapper amsDispatchSaleOrderMapper;
  53. @Autowired
  54. AmsSaleMaterialMapper amsSaleMaterialMapper;
  55. @Autowired
  56. AmsSaleTrucknoMaterialMapper amsSaleTrucknoMaterialMapper;
  57. @Autowired
  58. RmsReceivePlaceMapper rmsReceivePlaceMapper;
  59. @Autowired
  60. JoinFeign joinFeign;
  61. @Autowired
  62. OmstruckOrderMapper omstruckOrderMapper;
  63. @Autowired
  64. OmstruckOrderMaterialMapper omstruckOrderMaterialMapper;
  65. @Autowired
  66. AmsSaleOrderMaterialServiceImpl amsSaleOrderMaterialService;
  67. @Autowired
  68. TmsTruckFeign tmsTruckFeign;
  69. @Autowired
  70. EASUtil easUtil;
  71. @Autowired
  72. EASDeleteUtil easDeleteUtil;
  73. @Autowired
  74. EASSaleOrderUtil easSaleOrderUtil;
  75. @Autowired
  76. EASTestUtil easTestUtil;
  77. @Autowired
  78. EASDeleteTestUtil easDeleteTestUtil;
  79. @Autowired
  80. EASDeleteApproveUtil easDeleteApproveUtil;
  81. @Autowired
  82. RmsMaterialMapper rmsMaterialMapper;
  83. @Autowired
  84. TmstrainPleaseApproveResultMapper tmstrainPleaseApproveResultMapper;
  85. @Autowired
  86. WmspOutboundResultMaterialMapper wmspOutboundResultMaterialMapper;
  87. @Resource
  88. EasSaleOrderStatusUtil easSaleOrderStatusUtil;
  89. @Autowired
  90. OtmsFeign otmsFeign;
  91. @Autowired
  92. RmsFeign rmsFeign;
  93. @Autowired
  94. EasFluMakeDateUtil easFluMakeDateUtil;
  95. @Autowired
  96. EASCapacityTestUtil easCapacityTestUtil;
  97. @Autowired
  98. BmstruckFeign bmstruckFeign;
  99. @Autowired
  100. SaleLogUtil saleLogUtil;
  101. @Override
  102. public List<Map<String, Object>> getSaleOrderInfo(Map<String, Object> map) {
  103. return amsSaleOrderMapper.getSaleOrderInfo(map);
  104. }
  105. @Override
  106. public List<Map<String, Object>> getSaleOrderReported(Map<String, Object> map) {
  107. return amsSaleOrderMapper.getSaleOrderReported(map);
  108. }
  109. @Override
  110. public List<Map<String, Object>> getSaleOrderDetail(Map<String, Object> map) {
  111. return amsSaleOrderMapper.getSaleOrderDetail(map);
  112. }
  113. @Override
  114. public List<Map<String, Object>> getSalePlanName() {
  115. return amsSaleOrderMapper.getSalePlanName();
  116. }
  117. @Override
  118. public List<Map<String, Object>> getShipperName() {
  119. return amsSaleOrderMapper.getShipperName();
  120. }
  121. @Override
  122. public List<Map<String, Object>> getConsigneeCompanyName() {
  123. return amsSaleOrderMapper.getConsigneeCompanyName();
  124. }
  125. @Override
  126. /**
  127. * map存放为前端获取的amsSaleOrder基础数据以及selectionList物资信息
  128. * map1为基础数据包括,收货地址,收货人等
  129. * map2存放的从selectionList取出的数据,包括物资id,物资名称等。
  130. */
  131. public int addAmsSaleOrder(Map<String, Object> map) throws ParseException {
  132. //获取前端传过来的map,
  133. int i = 0;
  134. Map<String, Object> map1 = (Map<String, Object>) map.get("amsSaleOrder");
  135. AmsSaleOrder amsSaleOrder = new AmsSaleOrder();
  136. Integer id = (amsSaleOrderMapper.selectMaxId()).intValue();
  137. //生成主键id
  138. amsSaleOrder.setSaleOrderId(new BigDecimal(id));
  139. //WXSDD-年月日-8位数的顺序号
  140. String wxsdd = DataChange.generateEightDigitsNumber("WXSDD", id);
  141. amsSaleOrder.setSaleNumber(wxsdd);
  142. //获得是否自提
  143. amsSaleOrder.setSaleOrderIsselfMention((String) map1.get("saleOrderIsselfMention"));
  144. //获取收货地址id
  145. amsSaleOrder.setReceiveId(DataChange.dataToBigDecimal(map1.get("receiveId")));
  146. //获取发货单位id
  147. amsSaleOrder.setShipperId(DataChange.dataToBigDecimal(map1.get("shipperId")));
  148. //获取备注
  149. amsSaleOrder.setSaleRemark((String) map1.get("saleRemark"));
  150. //设置销售订单状态
  151. amsSaleOrder.setSaleOrderStatus(new BigDecimal(0));
  152. amsSaleOrder.setSaleUnitPrice(new BigDecimal(4000));
  153. amsSaleOrder.setSaleOrderTax("13%");
  154. amsSaleOrder.setInsertUsername("admin");
  155. amsSaleOrder.setInsertTime(new Date());
  156. amsSaleOrder.setUpdateUsername("admin");
  157. amsSaleOrder.setUpdateTime(new Date());
  158. amsSaleOrder.setInsertUpdateRemark("无");
  159. amsSaleOrder.setDeleted(new BigDecimal(0));
  160. amsSaleOrder.setSaleOrderStatus(new BigDecimal(0));
  161. //设置收款客户
  162. amsSaleOrder.setSaleOrderReceiveCustomer((String) map1.get("saleOrderReceiveCustomer"));
  163. i += amsSaleOrderMapper.insertSelective(amsSaleOrder);
  164. //获取车序号和物资信息进行新增车序号与物资中间表
  165. //一个销售订单对应多个车序号
  166. List<Map<String, Object>> selectionList = (List<Map<String, Object>>) map.get("selectionList");
  167. for (Map<String, Object> map2 : selectionList) {
  168. BigDecimal materialId = DataChange.dataToBigDecimal(map2.get("materialId"));
  169. Integer cxh = (Integer) map2.get("cxh");
  170. //生成车序号与物资实体
  171. AmsSaleOrderMaterial amsSaleOrderMaterial = new AmsSaleOrderMaterial();
  172. //生成主键
  173. amsSaleOrderMaterial.setSaleOrderMaterialId(amsSaleOrderMaterialMapper.selectMaxId());
  174. amsSaleOrderMaterial.setSaleOrderId(amsSaleOrder.getSaleOrderId());
  175. // 生成定向派单
  176. AmsDispatchSaleOrder amsDispatchSaleOrder = new AmsDispatchSaleOrder();
  177. amsDispatchSaleOrder.setDispatchId(amsDispatchSaleOrderMapper.selectOtherId());
  178. amsDispatchSaleOrder.setSaleOrderMaterialId(amsSaleOrderMaterial.getSaleOrderMaterialId());
  179. //获取收货地址
  180. Integer saleShipperAddressId =(Integer) map2.get("saleShipperAddressId");
  181. amsSaleOrderMaterial.setSaleShippingAddressId(new BigDecimal(saleShipperAddressId));
  182. //根据收货地址查询承运商
  183. Map<String,Object> map4 = amsSaleOrderMapper.selectProvince(saleShipperAddressId);
  184. BigDecimal carrierId = amsSaleOrderMapper.selectCarrierIdByprovince(map4);
  185. //获取收货方电话号码
  186. amsDispatchSaleOrder.setCarrierId(carrierId);
  187. amsDispatchSaleOrder.setDispatchTime(new Date());
  188. //设置成交类型
  189. amsDispatchSaleOrder.setDispatchType(new BigDecimal(0));
  190. //设置下发状态为未下发
  191. amsDispatchSaleOrder.setDispatchStatus(new BigDecimal(1));
  192. amsDispatchSaleOrder.setInsertTime(new Date());
  193. amsDispatchSaleOrder.setInsertUsername("admin");
  194. amsDispatchSaleOrderMapper.insertSelective(amsDispatchSaleOrder);
  195. amsSaleOrderMaterial.setSaleOrderConsigneeTel(map2.get("saleOrderConsigneeTel").toString());
  196. //获取收货日期
  197. String saleDateOfReceipt =(String) map2.get("saleDateOfReceipt");
  198. SimpleDateFormat simpleDateFormat=new SimpleDateFormat("yyyy-MM-dd");
  199. Date date = simpleDateFormat.parse(saleDateOfReceipt);
  200. amsSaleOrderMaterial.setSaleDateOfReceipt(date);
  201. //获取收货方姓名
  202. amsSaleOrderMaterial.setSaleOrderConsignee((String) map2.get("saleOrderConsignee"));
  203. //设置车序号
  204. amsSaleOrderMaterial.setSaleOrderMaterialTruckNo(new BigDecimal(cxh));
  205. //设置删除状态
  206. amsSaleOrderMaterial.setDeleted(new BigDecimal(0));
  207. i += amsSaleOrderMaterialMapper.insertSelective(amsSaleOrderMaterial);
  208. //新增车序号与物资中间表
  209. AmsSaleTrucknoMaterial trucknoMaterial = new AmsSaleTrucknoMaterial();
  210. trucknoMaterial.setTrucknoMaterialId(trucknoMaterialMapper.selectMaxId());
  211. //设置物资id
  212. trucknoMaterial.setMaterialId(materialId);
  213. //获取车序号物资id
  214. trucknoMaterial.setSaleOrderMaterialId(amsSaleOrderMaterial.getSaleOrderMaterialId());
  215. Integer orderPlanWeight = (Integer) map2.get("orderPlanWeight");
  216. trucknoMaterial.setSaleOrderMaterialNumber(DataChange.dataToBigDecimal(orderPlanWeight));
  217. //获取物资理重
  218. BigDecimal materialTheoreticalWeight = DataChange.dataToBigDecimal(map2.get("materialTheoreticalWeight"));
  219. //判断是否有物资理重
  220. if (materialTheoreticalWeight.intValue() != 0) {
  221. trucknoMaterial.setMaterialTheoreticalWeight(materialTheoreticalWeight);
  222. }
  223. //新增车序号与物资中间表
  224. i += trucknoMaterialMapper.insertSelective(trucknoMaterial);
  225. }
  226. return i;
  227. }
  228. @Transactional(rollbackFor = Exception.class)
  229. @Override
  230. public int uploadSaleOrder(BigDecimal saleOrderId) throws Exception {
  231. AmsSaleOrder amsSaleOrder = amsSaleOrderMapper.selectByPrimaryKey(saleOrderId);
  232. // 调用金蝶接口,将销售订单推送到金蝶系统
  233. Map<String, Object> input = joinFeign.getSaleOrder(saleOrderId);
  234. Map<String, Object> head = (Map<String, Object>) input.get("head");
  235. head.put("status","");
  236. // 获得金蝶接口配置:正式
  237. Map<String, Object> totalMap = new HashMap<>();
  238. totalMap.putAll(easUtil.getTotalMap());
  239. // 获得金蝶接口配置:测试
  240. //Map<String, Object> totalMap = easSaleOrderUtil.getTotalMap();
  241. // 组装报文
  242. totalMap.put("input",input);
  243. System.out.println(totalMap);
  244. String json = JSONUtils.toJSONString(totalMap);
  245. System.out.println(json);
  246. // 得到金蝶返回结果
  247. Map<String,Object> s = joinFeign.pushSaleOrderToEas(totalMap);
  248. try {
  249. newFileTool.newFile("pushSaleOrderToEas:"+totalMap,"金蝶通讯报文");
  250. }catch (Exception e){
  251. e.printStackTrace();
  252. }
  253. String status = (String) s.get("status");
  254. if ("-1".equals(status)) {
  255. throw new Exception(amsSaleOrder.getSaleNumber() + "上传金蝶失败!");
  256. }
  257. System.out.println(s);
  258. amsSaleOrder.setSaleOrderStatus(new BigDecimal(1));
  259. return amsSaleOrderMapper.updateByPrimaryKey(amsSaleOrder);
  260. }
  261. @Override
  262. public List<Map<String, Object>> selectBySaleOrderId(BigDecimal saleOrderId) {
  263. return amsSaleOrderMapper.selectBySaleOrderId(saleOrderId);
  264. }
  265. /**
  266. * 修改订单信息、车序号表、车序号物资中间表
  267. *
  268. * @param map
  269. * @return
  270. */
  271. @Override
  272. @Transactional
  273. public int updateAmsSaleOrder(Map<String, Object> map) throws ParseException {
  274. int i = 0;
  275. int j = 0;
  276. Map<String, Object> map1 = (Map<String, Object>) map.get("amsSaleOrder");
  277. AmsSaleOrder amsSaleOrder = new AmsSaleOrder();
  278. //修改销售订单表 更新销售订单基础信息
  279. amsSaleOrder.setSaleOrderId(DataChange.dataToBigDecimal(map1.get("saleOrderId")));
  280. amsSaleOrder.setShipperId(DataChange.dataToBigDecimal(map1.get("shipperId")));
  281. amsSaleOrder.setReceiveId(DataChange.dataToBigDecimal(map1.get("reciveId")));
  282. amsSaleOrder.setSaleOrderIsselfMention((String) map1.get("saleOrderIsselfMention"));
  283. amsSaleOrder.setSaleOrderReceiveCustomer((String) map1.get("saleOrderReciveCustomer"));
  284. amsSaleOrder.setSaleRemark((String) map1.get("saleRemark"));
  285. amsSaleOrder.setUpdateTime(new Date());
  286. i += amsSaleOrderMapper.updateByPrimaryKeySelective(amsSaleOrder);
  287. //根据销售订单id查找销售车序号和车序号与物资中间表主键
  288. List<Map<String, Object>> map2 = amsSaleOrderMapper.selectSaleOrderMaterialIdBySaleOrderId(DataChange.dataToBigDecimal(map1.get("saleOrderId")));
  289. for (Map<String,Object> Id:map2){
  290. BigDecimal truckNoMaterialId =(BigDecimal) Id.get("TruckNoMaterialId");
  291. BigDecimal saleOrderMaterialId=(BigDecimal) Id.get("saleOrderMaterialId");
  292. //删除对应的车序号表与车序号与物资中间表
  293. j+=amsSaleOrderMaterialMapper.deleteByPrimaryKey(saleOrderMaterialId);
  294. j+=trucknoMaterialMapper.deleteByPrimaryKey(truckNoMaterialId);
  295. }
  296. //新增车序号和物资中间表
  297. //获取车序号和物资信息进行新增车序号与物资中间表
  298. //一个销售订单对应多个车序号
  299. List<Map<String, Object>> selectionList = (List<Map<String, Object>>) map.get("selectionList");
  300. for (Map<String, Object> map3 : selectionList) {
  301. BigDecimal materialId = DataChange.dataToBigDecimal(map3.get("materialId"));
  302. Integer cxh = (Integer) map3.get("cxh");
  303. //生成车序号与物资实体
  304. AmsSaleOrderMaterial amsSaleOrderMaterial = new AmsSaleOrderMaterial();
  305. //生成主键
  306. amsSaleOrderMaterial.setSaleOrderMaterialId(amsSaleOrderMaterialMapper.selectMaxId());
  307. amsSaleOrderMaterial.setSaleOrderId(DataChange.dataToBigDecimal(map1.get("saleOrderId")));
  308. //获取收货地址
  309. amsSaleOrderMaterial.setSaleShippingAddressId(DataChange.dataToBigDecimal(map3.get("saleShipperAddressId")));
  310. //获取收货方电话号码
  311. amsSaleOrderMaterial.setSaleOrderConsigneeTel(map3.get("saleOrderConsigneeTel").toString());
  312. //获取收货日期
  313. String saleDateOfReceipt =(String) map3.get("saleDateOfReceipt");
  314. SimpleDateFormat simpleDateFormat=new SimpleDateFormat("yyyy-MM-dd");
  315. Date date = simpleDateFormat.parse(saleDateOfReceipt);
  316. amsSaleOrderMaterial.setSaleDateOfReceipt(date);
  317. //获取收货方姓名
  318. amsSaleOrderMaterial.setSaleOrderConsignee((String) map3.get("saleOrderConsignee"));
  319. //设置车序号
  320. amsSaleOrderMaterial.setSaleOrderMaterialTruckNo(new BigDecimal(cxh));
  321. //设置删除状态
  322. amsSaleOrderMaterial.setDeleted(new BigDecimal(0));
  323. i += amsSaleOrderMaterialMapper.insertSelective(amsSaleOrderMaterial);
  324. // 生成定向派单
  325. AmsDispatchSaleOrder amsDispatchSaleOrder = new AmsDispatchSaleOrder();
  326. amsDispatchSaleOrder.setDispatchId(amsDispatchSaleOrderMapper.selectOtherId());
  327. amsDispatchSaleOrder.setSaleOrderMaterialId(amsSaleOrderMaterial.getSaleOrderMaterialId());
  328. //获取收货地址
  329. Integer saleShipperAddressId =(Integer) map3.get("saleShipperAddressId");
  330. amsSaleOrderMaterial.setSaleShippingAddressId(new BigDecimal(saleShipperAddressId));
  331. //根据收货地址查询承运商
  332. Map<String,Object> map4 = amsSaleOrderMapper.selectProvince(saleShipperAddressId);
  333. BigDecimal carrierId = amsSaleOrderMapper.selectCarrierIdByprovince(map4);
  334. //获取收货方电话号码
  335. amsDispatchSaleOrder.setCarrierId(carrierId);
  336. amsDispatchSaleOrder.setDispatchTime(new Date());
  337. //设置成交类型
  338. amsDispatchSaleOrder.setDispatchType(new BigDecimal(0));
  339. //设置下发状态为已下发
  340. amsDispatchSaleOrder.setDispatchStatus(new BigDecimal(0));
  341. amsDispatchSaleOrder.setInsertTime(new Date());
  342. amsDispatchSaleOrder.setInsertUsername("admin");
  343. //新增车序号与物资中间表
  344. AmsSaleTrucknoMaterial trucknoMaterial = new AmsSaleTrucknoMaterial();
  345. trucknoMaterial.setTrucknoMaterialId(trucknoMaterialMapper.selectMaxId());
  346. //设置物资id
  347. trucknoMaterial.setMaterialId(materialId);
  348. //获取车序号物资id
  349. trucknoMaterial.setSaleOrderMaterialId(amsSaleOrderMaterial.getSaleOrderMaterialId());
  350. Integer orderPlanWeight = (Integer) map3.get("orderPlanWeight");
  351. trucknoMaterial.setSaleOrderMaterialNumber(DataChange.dataToBigDecimal(orderPlanWeight));
  352. //获取物资理重
  353. BigDecimal materialTheoreticalWeight = DataChange.dataToBigDecimal(map3.get("materialTheoreticalWeight"));
  354. //判断是否有物资理重
  355. if (materialTheoreticalWeight.intValue() != 0) {
  356. trucknoMaterial.setMaterialTheoreticalWeight(materialTheoreticalWeight);
  357. }
  358. //新增车序号与物资中间表
  359. i += trucknoMaterialMapper.insertSelective(trucknoMaterial);
  360. }
  361. // List<Map<String, Object>> mapList = (List<Map<String, Object>>) map.get("mapList");
  362. // ArrayList<Integer> list = new ArrayList<>();
  363. // for (Map<String, Object> truckMesMap : mapList) {
  364. // //修改车序号表
  365. // BigDecimal saleOrderMaterialId = DataChange.dataToBigDecimal(truckMesMap.get("saleOrderMaterialId"));
  366. // if (!list.contains(saleOrderMaterialId.intValue())) {
  367. // //车序号表专用字段
  368. // BigDecimal saleShipperAddressId = DataChange.dataToBigDecimal(truckMesMap.get("saleShipperAddressId"));
  369. // String saleDateOfReceipt =(String) truckMesMap.get("saleDateOfReceipt");
  370. // SimpleDateFormat simpleDateFormat=new SimpleDateFormat("yyyy-MM-dd");
  371. // Date date = simpleDateFormat.parse(saleDateOfReceipt);
  372. // String saleOrderConsignee = (String) truckMesMap.get("saleOrderConsignee");
  373. // String saleOrderConsigneeTel = (String) truckMesMap.get("saleOrderConsigneeTel");
  374. // AmsSaleOrderMaterial amsSaleOrderMaterial = new AmsSaleOrderMaterial();
  375. // amsSaleOrderMaterial.setSaleOrderMaterialId(saleOrderMaterialId);
  376. // amsSaleOrderMaterial.setSaleOrderMaterialTruckNo(DataChange.dataToBigDecimal(truckMesMap.get("cxh")));
  377. // amsSaleOrderMaterial.setSaleShippingAddressId(saleShipperAddressId);
  378. // amsSaleOrderMaterial.setSaleDateOfReceipt(date);
  379. // amsSaleOrderMaterial.setSaleOrderConsignee(saleOrderConsignee);
  380. // amsSaleOrderMaterial.setSaleOrderConsigneeTel(saleOrderConsigneeTel);
  381. // i += amsSaleOrderMaterialMapper.updateByPrimaryKeySelective(amsSaleOrderMaterial);
  382. // list.add(saleOrderMaterialId.intValue());
  383. // }
  384. // //修改车车序号物资表
  385. // AmsSaleTrucknoMaterial amsSaleTrucknoMaterial = new AmsSaleTrucknoMaterial();
  386. // amsSaleTrucknoMaterial.setTrucknoMaterialId(DataChange.dataToBigDecimal(truckMesMap.get("trucknoMaterialId")));
  387. // amsSaleTrucknoMaterial.setSaleOrderMaterialNumber(DataChange.dataToBigDecimal(truckMesMap.get("orderPlanWeight")));
  388. // amsSaleTrucknoMaterial.setMaterialId(DataChange.dataToBigDecimal(truckMesMap.get("materialId")));
  389. // i += trucknoMaterialMapper.updateByPrimaryKeySelective(amsSaleTrucknoMaterial);
  390. // }
  391. return i;
  392. }
  393. @Override
  394. public int deleteAmsSaleOrderBySaleOrderId(BigDecimal saleOrderId) {
  395. //删除所有从表信息
  396. //amsSaleOrderMapper.deleteBySaleOrderId(saleOrderId);
  397. AmsSaleOrder amsSaleOrder = amsSaleOrderMapper.selectByPrimaryKey(saleOrderId);
  398. amsSaleOrder.setDeleted(new BigDecimal(2));
  399. return amsSaleOrderMapper.updateByPrimaryKey(amsSaleOrder);
  400. }
  401. @Override
  402. public List<Map<String, Object>> getSaleOrderUpdateLog(Map<String, Object> map) {
  403. return amsSaleOrderMapper.getSaleOrderUpdateLog(map);
  404. }
  405. /**
  406. * 销售公司查询已审核的订单
  407. * @param map
  408. * @return
  409. */
  410. @Override
  411. public List<Map<String, Object>> getSaleOrderListBySaleCompany(Map<String, Object> map) {
  412. return amsSaleOrderMapper.getSaleOrderListBySaleCompany(map);
  413. }
  414. @Override
  415. public List<Map<String, Object>> getAmsSaleOrderApproved(Map<String, Object> map) {
  416. return amsSaleOrderMapper.getAmsSaleOrderApproved(map);
  417. }
  418. @Override
  419. public List<Map<String, Object>> getSaleOrderList(Map<String, Object> mapValue) {
  420. return amsSaleOrderMapper.getSaleOrderList(mapValue);
  421. }
  422. public Map<String, Object> getCarrier(Integer addressId) {
  423. return amsSaleOrderMapper.selectProvince(addressId);
  424. }
  425. /**
  426. * 根据销售订单id查找信息
  427. */
  428. @Override
  429. public Map<String, Object> selectInfoBySaleOrderId(BigDecimal saleOrderId) {
  430. return amsSaleOrderMapper.selectInfoBySaleOrderId(saleOrderId);
  431. }
  432. /**
  433. * 根据销售订单id查找物资信息
  434. *
  435. * @param saleOrderId
  436. * @return
  437. */
  438. @Override
  439. public List<Map<String, Object>> selectMaterialInfoBySaleOrderId(BigDecimal saleOrderId) {
  440. return amsSaleOrderMapper.selectMaterialInfoBySaleOrderId(saleOrderId);
  441. }
  442. @Override
  443. public int addAmsDispatchSaleOrder(List<Map<String, Object>> mapValue) {
  444. int result = 0;
  445. for (Map<String,Object> map : mapValue) {
  446. Integer dispatchId = (Integer)map.get("dispatchId");
  447. AmsDispatchSaleOrder amsDispatchSaleOrder = amsDispatchSaleOrderMapper.selectByPrimaryKey(new BigDecimal(dispatchId));
  448. amsDispatchSaleOrder.setDispatchStatus(new BigDecimal(0));
  449. result = amsDispatchSaleOrderMapper.updateByPrimaryKeySelective(amsDispatchSaleOrder);
  450. }
  451. return result;
  452. }
  453. @Override
  454. public List<Map<String, Object>> getSaleOrderInfoes(Map<String, Object> map) {
  455. return amsSaleOrderMapper.getSaleOrderInfoes(map);
  456. }
  457. @Override
  458. public List<Map<String, Object>> getSaleOrderReportedes(Map<String, Object> map) {
  459. return amsSaleOrderMapper.getSaleOrderReportedes(map);
  460. }
  461. @Override
  462. public List<Map<String, Object>> getSaleOrderListBySaleCompanyes(Map<String, Object> map) {
  463. List<Map<String, Object>> resultList = amsSaleOrderMapper.getSaleOrderListBySaleCompanyes(map);
  464. return resultList;
  465. }
  466. @Override
  467. public List<Map<String, Object>> getAmsSaleOrderApprovedes(Map<String, Object> map) {
  468. List<Map<String,Object>> resultList = amsSaleOrderMapper.getAmsSaleOrderApprovedes(map);
  469. return resultList;
  470. }
  471. /*
  472. * 根据销售订单主键展示销售基本信息、物资信息
  473. * */
  474. @Override
  475. public List<Map<String, Object>> getSaleOrderAndMaterialById(Map<String,Object> mapValue) {
  476. List<Map<String, Object>> mapList=amsSaleOrderMapper.getSaleOrderAndMaterialById(mapValue);
  477. for (Map<String, Object> map : mapList) {
  478. BigDecimal number;
  479. BigDecimal materialNumber = (BigDecimal) map.get("materialNumber");
  480. BigDecimal materialWeight = (BigDecimal) map.get("materialWeight");
  481. String materialName =(String) map.get("materialName");
  482. if (materialNumber != null && materialNumber.toString().length() != 0 && !materialName.equals("钒渣")) {
  483. number = materialNumber;
  484. }
  485. else {
  486. number = materialWeight;
  487. }
  488. map.put("number",number);
  489. }
  490. return mapList;
  491. }
  492. /**
  493. * 销售焦炭订单
  494. * @param mapValue
  495. * @return
  496. */
  497. @Override
  498. public List<Map<String, Object>> getCokeSaleOrderList(Map<String, Object> mapValue) {
  499. List<Map<String,Object>> mapList = amsSaleOrderMapper.getCokeSaleOrderList(mapValue);
  500. for (Map<String, Object> resultMap : mapList) {
  501. BigDecimal saleOrderId = (BigDecimal) resultMap.get("saleOrderId");
  502. BigDecimal netWeight = amsSaleOrderMapper.getNetWeight(saleOrderId);
  503. BigDecimal carNum = amsSaleOrderMapper.getCarNum(saleOrderId);
  504. resultMap.put("netWeight",netWeight);
  505. resultMap.put("carNum",carNum);
  506. }
  507. return mapList;
  508. }
  509. /**
  510. * 新增钢材销售订单
  511. * @param mapValue
  512. * @return
  513. */
  514. @Override
  515. @Transactional(rollbackFor = Exception.class)
  516. public int addSteelSaleOrder(Map<String, Object> mapValue) throws Exception {
  517. List<Map<String,Object>> mapList = (List<Map<String, Object>>) mapValue.get("mapList");
  518. // 得到发货单位
  519. BigDecimal shipperId = DataChange.dataToBigDecimal(mapValue.get("shipperId"));
  520. // 收货单位
  521. BigDecimal receiveId = DataChange.dataToBigDecimal(mapValue.get("receiveId"));
  522. if (receiveId == null || receiveId.intValue() == 0) {
  523. receiveId = amsSaleOrderMapper.findReceiveId(mapValue.get("receiveName"));
  524. if (receiveId == null) {
  525. //if(mapValue.get("receiveName")!=null){
  526. // //自动注册收货客户
  527. // Map<String, Object> res = joinFeign.registerConsignee(mapValue);
  528. // if("succeed".equals(res.get("status"))){
  529. // receiveId=DataChange.dataToBigDecimal(res.get("data"));
  530. // }else{
  531. // System.out.println(res);
  532. // throw new Exception("注册收货客户失败!请手动注册!");
  533. // }
  534. //}else{
  535. //
  536. //}
  537. throw new Exception("下单客户不存在!!!");
  538. }
  539. //判断该收货客户有没有绑定片区
  540. BigDecimal saleAreaId = amsSaleOrderMapper.selectSaleAreaId(receiveId);
  541. if(saleAreaId == null){
  542. //如果片区为null,则绑定片区
  543. //根据片区名称去查找片区ID
  544. if(mapValue.get("saleArea") != null){
  545. String saleAreaName = (String) mapValue.get("saleArea");
  546. saleAreaId = amsSaleOrderMapper.selectSaleAreaIdByName(saleAreaName);
  547. if(saleAreaId == null){
  548. throw new Exception("您输入的销售片区:" + mapValue.get("saleArea") +"不存在!!");
  549. }else{
  550. //更新收货客户下的销售片区
  551. amsSaleOrderMapper.bindSaleArea(receiveId,saleAreaId);
  552. }
  553. }
  554. }
  555. }
  556. // 是否自提
  557. String isSelfMention = (String) mapValue.get("isSelfMention");
  558. // 备注
  559. String saleRemark = (String) mapValue.get("saleRemark");
  560. String saleGroupCode = null;
  561. try {
  562. saleGroupCode = "钢" + StringUtils.substringBetween(saleRemark,"钢","组") + "组";
  563. } catch (Exception e) {
  564. e.printStackTrace();
  565. }
  566. // 收款客户
  567. String saleOrderReceiveCustomer = (String) mapValue.get("saleOrderReceiveCustomer");
  568. // 业务员
  569. BigDecimal salerId = DataChange.dataToBigDecimal(mapValue.get("salerId"));
  570. if (salerId == null || salerId.intValue() == 0) {
  571. if(mapValue.get("salerName") == null) {
  572. throw new Exception("您输入的业务员为空,请检查后再导入!!");
  573. }
  574. salerId = amsSaleOrderMapper.findSalerId(mapValue.get("salerName"));
  575. if (salerId == null) {
  576. throw new Exception("您输入的业务员:" + mapValue.get("salerName") +"不存在!!");
  577. }
  578. }
  579. BigDecimal saleOrderId = amsSaleOrderMapper.selectMaxId();
  580. int result = 0;
  581. // 销售订单
  582. AmsSaleOrder amsSaleOrder = new AmsSaleOrder();
  583. amsSaleOrder.setReceiveId(receiveId);
  584. amsSaleOrder.setSaleRemark(saleRemark == null ? "":saleRemark);
  585. amsSaleOrder.setShipperId(shipperId);
  586. amsSaleOrder.setSaleOrderIsselfMention(isSelfMention);
  587. amsSaleOrder.setSaleOrderId(saleOrderId);
  588. amsSaleOrder.setSalerId(salerId);
  589. // 设置钢材订单
  590. amsSaleOrder.setSaleType(new BigDecimal(1));
  591. amsSaleOrder.setSaleNumber(DataChange.generateEightDigitsNumber("WXSDD",saleOrderId.intValue(),"-"));
  592. amsSaleOrder.setInsertTime(new Date());
  593. amsSaleOrder.setInsertUpdateRemark("物流新增销售订单");
  594. amsSaleOrder.setInsertUsername("物流");
  595. amsSaleOrder.setUpdateTime(new Date());
  596. amsSaleOrder.setDeleted(new BigDecimal(0));
  597. amsSaleOrder.setSaleOrderStatus(new BigDecimal(0));
  598. // 税率默认13%
  599. amsSaleOrder.setSaleOrderTax("13%");
  600. // 含税单价某人4000
  601. amsSaleOrder.setSaleUnitPrice(new BigDecimal(4000));
  602. // 收款客户
  603. amsSaleOrder.setSaleOrderReceiveCustomer(saleOrderReceiveCustomer);
  604. // 销售订单物资表
  605. AmsSaleMaterial amsSaleMaterial = new AmsSaleMaterial();
  606. // 车序号物资表
  607. AmsSaleTrucknoMaterial amsSaleTrucknoMaterial = new AmsSaleTrucknoMaterial();
  608. // 遍历每一行
  609. for (Map<String, Object> map : mapList) {
  610. /*
  611. 车序号表
  612. */
  613. // 得到车序号
  614. BigDecimal truckNo = DataChange.dataToBigDecimal(map.get("truckNo"));
  615. Map<String,Object> saleMap = new HashMap<>();
  616. saleMap.put("saleOrderId",saleOrderId);
  617. saleMap.put("saleOrderMaterialTruckNo",truckNo);
  618. // 检测销售订单下的车序号是否已存在
  619. List<AmsSaleOrderMaterial> amsSaleOrderMaterials = amsSaleOrderMaterialMapper.selectByParameters(saleMap);
  620. // 车序号表
  621. AmsSaleOrderMaterial amsSaleOrderMaterial = new AmsSaleOrderMaterial();
  622. if (amsSaleOrderMaterials == null || amsSaleOrderMaterials.size() == 0) {
  623. // 车序号主键
  624. BigDecimal saleOrderMaterialId = amsSaleOrderMaterialMapper.selectMaxId();
  625. BigDecimal shippingAddressId = DataChange.dataToBigDecimal(map.get("shipperAddressId"));
  626. if (shippingAddressId == null || shippingAddressId.intValue() == 0) {
  627. String province = (String) map.get("province");
  628. String district = (String) map.get("district");
  629. String town = (String) map.get("town");
  630. Map<String,Object> addressMap = new HashMap<>();
  631. addressMap.put("province",province);
  632. addressMap.put("district",district);
  633. addressMap.put("town",town);
  634. shippingAddressId = amsSaleOrderMapper.findAddressId(addressMap);
  635. if (shippingAddressId == null) {
  636. throw new Exception("您输入的:" + province + district + town + "地址不存在!!");
  637. }
  638. }
  639. // 车号备注
  640. String truckRemark = (String) (map.get("truckRemark"));
  641. String place = (String) (map.get("place"));
  642. if (place != null && !"null".equals(place)) {
  643. List<Map<String, Object>> placeIdList = amsSaleOrderMaterialMapper.getPlaceId(place,shippingAddressId);
  644. if (placeIdList == null || placeIdList.size() == 0) {
  645. RmsReceivePlace rmsReceivePlace = new RmsReceivePlace();
  646. rmsReceivePlace.setPlaceId(rmsReceivePlaceMapper.selectMaxId());
  647. rmsReceivePlace.setAddressId(shippingAddressId);
  648. rmsReceivePlace.setAddressDeliveryAddress(place);
  649. amsSaleOrderMaterial.setSaleShippingAddressId(rmsReceivePlace.getPlaceId());
  650. rmsReceivePlaceMapper.insertSelective(rmsReceivePlace);
  651. } else {
  652. amsSaleOrderMaterial.setSaleShippingAddressId((BigDecimal) placeIdList.get(0).get("placeId"));
  653. }
  654. }
  655. if (amsSaleOrderMaterial.getSaleShippingAddressId() != null && isSelfMention.equals("否") && DataChange.dataToBigDecimal(map.get("carrierId")).intValue() == 0) {
  656. // 自动匹配承运商
  657. List<Map<String, Object>> carrierList = getCarrierByAddress(amsSaleOrderMaterial.getSaleShippingAddressId());
  658. BigDecimal carrierCount = null;
  659. if(place != null && !"null".equals(place)){
  660. carrierCount = amsSaleOrderMapper.getMoreCarrier(place);
  661. }
  662. //根据收货地址id查询备注,判断是否需要匹配承运商
  663. String addressRemark = amsSaleOrderMaterialMapper.getAddressRemark(shippingAddressId);
  664. // 单一承运商才进行匹配
  665. if (carrierList != null && carrierList.size() == 1 && carrierList.get(0) != null && carrierCount.intValue() == 0 && addressRemark == null) {
  666. List<Map<String, Object>> list = new ArrayList<>();
  667. Map<String, Object> map1 = carrierList.get(0);
  668. // 传入车序号主键和承运商id
  669. map1.put("saleOrderMaterialId", saleOrderMaterialId);
  670. list.add(map1);
  671. dispatchToCarrier(list);
  672. }
  673. }
  674. if (isSelfMention.equals("是")) {
  675. // 根据收货单位id查询出收货单位名称
  676. String consigneeName = amsSaleOrderMapper.selectConsigneeName(receiveId);
  677. // 根据收货单位名称查询承运商id
  678. BigDecimal carrierId = amsSaleOrderMapper.selectCarrierId(consigneeName);
  679. List<Map<String, Object>> list = new ArrayList<>();
  680. Map<String,Object> map1 = new HashMap<>();
  681. // 传入车序号主键和承运商id
  682. if (carrierId != null) {
  683. map1.put("saleOrderMaterialId", saleOrderMaterialId);
  684. map1.put("carrierId", carrierId);
  685. list.add(map1);
  686. dispatchToCarrier(list);
  687. }
  688. }
  689. if (isSelfMention.equals("否") && DataChange.dataToBigDecimal(map.get("carrierId")).intValue() != 0) {
  690. //说明有承运商
  691. List<Map<String, Object>> list = new ArrayList<>();
  692. Map<String, Object> carrierMap = new HashMap<>();
  693. carrierMap.put("carrierId",map.get("carrierId"));
  694. carrierMap.put("saleOrderMaterialId",saleOrderMaterialId);
  695. list.add(carrierMap);
  696. dispatchToCarrier(list);
  697. }
  698. // 收货方姓名
  699. String consigneeName = String.valueOf(map.get("saleOrderConsignee"));
  700. // 收货方电话
  701. String consigneeTel = String.valueOf(map.get("saleOrderConsigneeTel"));
  702. // 截止日期
  703. String dateOfReceiptStr = String.valueOf(map.get("saleDateOfReceipt"));
  704. Date dateOfReceipt = null;
  705. if (!"null".equals(dateOfReceiptStr) && !"undefined".equals(dateOfReceiptStr)) {
  706. dateOfReceipt = new Date(Long.valueOf(dateOfReceiptStr));
  707. }
  708. amsSaleOrderMaterial.setSaleOrderMaterialId(saleOrderMaterialId);
  709. amsSaleOrderMaterial.setSaleOrderId(saleOrderId);
  710. amsSaleOrderMaterial.setTruckRemark(truckRemark);
  711. amsSaleOrderMaterial.setSaleOrderMaterialTruckNo(truckNo);
  712. if(map.get("orderNo") != null) {
  713. amsSaleOrderMaterial.setPreviousOrderNumber((String) map.get("orderNo"));
  714. }
  715. if (consigneeName != null && !consigneeName.equals("null")) {
  716. amsSaleOrderMaterial.setSaleOrderConsignee(consigneeName);
  717. }
  718. if (consigneeTel != null && !consigneeTel.equals("null")) {
  719. amsSaleOrderMaterial.setSaleOrderConsigneeTel(consigneeTel);
  720. }
  721. amsSaleOrderMaterial.setSaleDateOfReceipt(dateOfReceipt);
  722. amsSaleOrderMaterial.setInsertTime(new Date());
  723. amsSaleOrderMaterial.setUpdateTime(new Date());
  724. amsSaleOrderMaterial.setInsertUpdateRemark("物流新增");
  725. result += amsSaleOrderMaterialMapper.insertSelective(amsSaleOrderMaterial);
  726. }
  727. else {
  728. amsSaleOrderMaterial = amsSaleOrderMaterials.get(0);
  729. }
  730. /*
  731. 销售订单物资表
  732. */
  733. // 物资
  734. BigDecimal materialId = DataChange.dataToBigDecimal(map.get("materialId"));
  735. if (materialId == null || materialId.intValue() == 0) {
  736. String name = (String) map.get("materialName");
  737. String specification = (String) map.get("materialSpecification");
  738. String model = (String) map.get("materialModel");
  739. Map<String,Object> materialMap = new HashMap<>();
  740. materialMap.put("name",name);
  741. materialMap.put("specification",specification);
  742. if (model == null || model.equals("") || model.equals("null")) {
  743. model = null;
  744. }
  745. materialMap.put("model",model);
  746. materialId = amsSaleOrderMapper.findMaterialId(materialMap);
  747. if (materialId == null) {
  748. throw new Exception("您输入的物资:" + name + specification + model + "不存在!!");
  749. }
  750. }
  751. Integer materialCount = amsSaleMaterialMapper.getMaterialCount(materialId);
  752. RmsMaterial rmsMaterial = new RmsMaterial();
  753. rmsMaterial.setMaterialId(materialId);
  754. if (materialCount == null) {
  755. materialCount = new Integer(0);
  756. }
  757. rmsMaterial.setMaterialCount(new BigDecimal(materialCount + 1));
  758. rmsMaterialMapper.updateByPrimaryKeySelective(rmsMaterial);
  759. // 物资件数
  760. BigDecimal materialNumber = DataChange.dataToBigDecimal(map.get("materialNumber"));
  761. // 物资名称
  762. Object materialName = map.get("materialName");
  763. // 钢材米数
  764. BigDecimal steelMeters = DataChange.dataToBigDecimal(map.get("steelMeters"));
  765. // 判断物资是否是盘螺或盘元/盘圆
  766. if (materialName != null && (materialName.toString().contains("盘螺") || materialName.toString().contains("盘元") || materialName.toString().contains("盘圆"))) {
  767. amsSaleMaterial.setSteelMeter(null);
  768. }
  769. else {
  770. amsSaleMaterial.setSteelMeter(steelMeters);
  771. }
  772. // 是否磅重销售(0:磅重;1:理重)
  773. BigDecimal isPoundSale = DataChange.dataToBigDecimal(map.get("isPoundSale"));
  774. // 销售订单物资表主键
  775. BigDecimal saleMaterialId = amsSaleMaterialMapper.selectMaxId();
  776. amsSaleMaterial.setSaleMaterialId(saleMaterialId);
  777. amsSaleMaterial.setSaleOrderId(saleOrderId);
  778. amsSaleMaterial.setMaterialId(materialId);
  779. amsSaleMaterial.setMaterialNumber(materialNumber);
  780. amsSaleMaterial.setMaterialPlanNumber(materialNumber);
  781. amsSaleMaterial.setSaleNo(amsSaleOrder.getSaleNumber());
  782. try {
  783. amsSaleMaterial.setTransferInOfWarehouse(saleRemark);
  784. } catch (Exception e) {
  785. e.printStackTrace();
  786. }
  787. if(saleGroupCode != null) {
  788. amsSaleMaterial.setTransferOutOfWarehouse(saleGroupCode);
  789. }
  790. amsSaleMaterial.setInsertTime(new Date());
  791. amsSaleMaterial.setUpdateTime(new Date());
  792. amsSaleMaterial.setIsPoundSale(isPoundSale);
  793. amsSaleMaterial.setInsertUpdateRemark("物流新增");
  794. result += amsSaleMaterialMapper.insertSelective(amsSaleMaterial);
  795. /*
  796. 车序号物资表
  797. */
  798. // 车序号物资表主键
  799. BigDecimal truckNoMaterialId = amsSaleTrucknoMaterialMapper.selectMaxId();
  800. amsSaleTrucknoMaterial.setTrucknoMaterialId(truckNoMaterialId);
  801. amsSaleTrucknoMaterial.setSaleOrderMaterialId(amsSaleOrderMaterial.getSaleOrderMaterialId());
  802. amsSaleTrucknoMaterial.setMaterialId(amsSaleMaterial.getSaleMaterialId());
  803. amsSaleTrucknoMaterial.setSaleOrderMaterialNumber(materialNumber);
  804. amsSaleTrucknoMaterial.setInsertTime(new Date());
  805. amsSaleTrucknoMaterial.setUpdateTime(new Date());
  806. amsSaleTrucknoMaterial.setInsertUpdateRemark("物流新增");
  807. result += amsSaleTrucknoMaterialMapper.insertSelective(amsSaleTrucknoMaterial);
  808. }
  809. result += amsSaleOrderMapper.insertSelective(amsSaleOrder);
  810. return saleOrderId.intValue();
  811. }
  812. /**
  813. * 展示销售订单下的车序号和物资
  814. * @param saleOrderId
  815. * @return
  816. */
  817. @Override
  818. public List<Map<String, Object>> getTruckNoAndMaterialList(BigDecimal saleOrderId) {
  819. HashMap<String,Object> mapValue = new HashMap<>();
  820. mapValue.put("saleOrderId",saleOrderId);
  821. List<Map<String,Object>> mapList = amsSaleOrderMapper.getTruckNoAndMaterial(mapValue);
  822. for (Map<String,Object> map : mapList) {
  823. BigDecimal placeId = (BigDecimal) map.get("placeId");
  824. if (placeId != null) {
  825. List<Map<String, Object>> carrierAndPriceList = getCarrierByPlace(placeId);
  826. map.put("carrierAndPriceList", carrierAndPriceList);
  827. }
  828. }
  829. return mapList;
  830. }
  831. /**
  832. * 销售钢材派车
  833. * @param mapList
  834. * @return
  835. */
  836. @Transactional(rollbackFor = Exception.class)
  837. @Override
  838. public int dispatchSteelOrder(List<Map<String, Object>> mapList) throws Exception {
  839. Map<String, Object> stringObjectMap = mapList.get(0);
  840. Integer isCheckGps = amsSaleOrderMapper.getDispachSwitch();
  841. Integer saleStatus = amsSaleOrderMapper.findStatus(DataChange.dataToBigDecimal(stringObjectMap.get("saleOrderMaterialId")));
  842. String selfMention = amsSaleOrderMapper.findSelfMention(DataChange.dataToBigDecimal(stringObjectMap.get("saleOrderMaterialId")));
  843. //如果这个车序号下面有运单,则证明已经派了
  844. Map<String,Object> orderMap = amsSaleOrderMapper.getSteelOrderMap(DataChange.dataToBigDecimal(stringObjectMap.get("saleOrderMaterialId")));
  845. //判断该车序号对应的分录是否全部关闭
  846. Integer flCount = amsSaleMaterialMapper.getAbleFlcount(DataChange.dataToBigDecimal(stringObjectMap.get("saleOrderMaterialId")));
  847. if(flCount == 0) {
  848. throw new Exception("该运单下所有分录被关闭,无法派车");
  849. }
  850. if (orderMap != null) {
  851. throw new Exception("该订单已派发,无法重复派车");
  852. }
  853. if (saleStatus == 1) {
  854. throw new Exception("订单未审核,无法派车!");
  855. }
  856. int result = 0;
  857. // 遍历每一行
  858. for (Map<String,Object> map : mapList) {
  859. //得到此次是否校验GPS
  860. boolean onceCheck = true;
  861. try{
  862. onceCheck = (boolean) map.get("isCheckGPS");
  863. }catch (Exception e){
  864. //取值失败不处理,默认校验GPS
  865. }
  866. // 得到车牌号
  867. String capacityNumber = (String) map.get("capacityNumber");
  868. // 得到运力id
  869. BigDecimal capacityId = amsSaleOrderMaterialMapper.getCapacityId(capacityNumber);
  870. //Map<String,Object> details = amsSaleOrderMapper.getOrderIdByCapacity(map);
  871. //if(details!=null && details.get("orderId")!=null){
  872. // if(details.get("isEn")==null){
  873. // throw new Exception(capacityNumber+"有未进厂的运输订单任务,无法派单");
  874. // }else if(details.get("isLeave")==null){
  875. // throw new Exception(capacityNumber+"有未出厂的运输订单任务,无法派单");
  876. // }else if(details.get("isArrival")==null){
  877. // throw new Exception(capacityNumber+"有未抵达的运输订单任务,无法派单");
  878. // }else if(details.get("isReceipt")==null){
  879. // throw new Exception(capacityNumber+"有未签收的运输订单任务,无法派单");
  880. // }
  881. // throw new Exception(capacityNumber+"有未完成的运输订单任务,无法派单");
  882. //}
  883. //校验该车是否存在手机号
  884. String tel=omstruckOrderMapper.getTelByCapacityId(capacityId);//数据库的手机号
  885. String driverTel = (String) map.get("driverTel");//填写的手机号
  886. if(tel==null || "".equals(tel)){
  887. throw new Exception("该车没有电话号码,无法派车!请去资源管理-运力维护该车的电话号码!");
  888. }
  889. //查询车牌号是否是黑名单
  890. if(amsSaleOrderMapper.isBlackList(capacityNumber)>0){
  891. throw new Exception("该车在黑名单中,无法派车!请联系销售公司!");
  892. }
  893. //非自提,单次校验且全局校验,且车不允许无GPS
  894. int isGPS=amsSaleOrderMapper.isGPS(capacityNumber);
  895. if((selfMention==null || selfMention.equals("否")) && onceCheck && (isCheckGps!=null && isCheckGps==0) && isGPS <= 0){
  896. Map<String,Object> data=null;
  897. try{
  898. data= (Map<String,Object>)otmsFeign.getCurrentLocation(capacityNumber).getData();
  899. }catch (Exception e){
  900. throw new Exception("该车没有GPS定位信息,请联系销售公司物流部,申请是否可以派车。");
  901. }
  902. if(data==null || !"1001".equals(""+data.get("status"))){
  903. throw new Exception("该车没有GPS定位信息,请联系销售公司物流部,申请是否可以派车。");
  904. }
  905. }
  906. //校验结束,上传金蝶
  907. pushCarNumberToEas(map);
  908. // 得到车序号表主键
  909. BigDecimal saleOrderMaterialId = DataChange.dataToBigDecimal(map.get("saleOrderMaterialId"));
  910. // 得到承运商
  911. BigDecimal carrierId = DataChange.dataToBigDecimal(map.get("carrierId"));
  912. // 查询到车序号的单价
  913. BigDecimal priceId = amsSaleOrderMapper.getOrderPrice(map);
  914. // 得到详细地址id
  915. BigDecimal placeId = amsSaleOrderMapper.getPlaceId(saleOrderMaterialId);
  916. // 如果已经设置单价则不覆盖,详细地址匹配不到单价,则匹配省市县内最高的一条单价(只给非自提的进行匹配)
  917. if (priceId == null && placeId != null && selfMention.equals("否")) {
  918. priceId = amsSaleOrderMapper.getPriceIdByPlaceId(placeId);
  919. }
  920. // 运输线路id
  921. BigDecimal lineId = DataChange.dataToBigDecimal(map.get("lineId"));
  922. BigDecimal isSteel = new BigDecimal(1);
  923. //try{
  924. // //不为空且为新手机号,则修改电话号码
  925. // if(driverTel!=null && !"".equals(driverTel) && !driverTel.equals(tel)){
  926. // Map<String,Object> map1=new HashMap<>();
  927. // map1.put("capacityNumber",capacityNumber);
  928. // map1.put("capacityTel",driverTel);
  929. // //在得到司机电话后给运力添加电话号码(通过车牌号)
  930. // rmsFeign.updateCapacity(map1);
  931. // }
  932. //}catch (Exception e){
  933. // e.printStackTrace();
  934. //}
  935. if (capacityId == null) {
  936. return 0;
  937. }
  938. List<Map<String, Object>> materialList = amsSaleOrderMaterialMapper.getMaterial(saleOrderMaterialId);
  939. /*
  940. 定向派单表
  941. */
  942. // 通过车序号主键确认定向派单是否已存在
  943. BigDecimal dispatchId0 = amsDispatchSaleOrderMapper.isDispatchExist(saleOrderMaterialId);
  944. if (dispatchId0 == null || dispatchId0.toString().length() == 0) {
  945. AmsDispatchSaleOrder amsDispatchSaleOrder = new AmsDispatchSaleOrder();
  946. // 主键
  947. BigDecimal dispatchId = amsDispatchSaleOrderMapper.selectOtherId();
  948. amsDispatchSaleOrder.setDispatchId(dispatchId);
  949. // 车序号表id
  950. amsDispatchSaleOrder.setSaleOrderMaterialId(saleOrderMaterialId);
  951. // 承运商id
  952. amsDispatchSaleOrder.setCarrierId(carrierId);
  953. // 派单时间和成交时间
  954. amsDispatchSaleOrder.setDispatchTime(new Date());
  955. amsDispatchSaleOrder.setDispatchDealTime(new Date());
  956. // 成交类型
  957. amsDispatchSaleOrder.setDispatchType(new BigDecimal(2));
  958. // 车序号状态
  959. amsDispatchSaleOrder.setDispatchStatus(new BigDecimal(2));
  960. result += amsDispatchSaleOrderMapper.insertSelective(amsDispatchSaleOrder);
  961. }
  962. // 如果已经匹配过承运商或者给某个承运商授权过,则派车时做修改承运商操作
  963. else {
  964. AmsDispatchSaleOrder amsDispatchSaleOrder = amsDispatchSaleOrderMapper.selectByPrimaryKey(dispatchId0);
  965. amsDispatchSaleOrder.setCarrierId(carrierId);
  966. result += amsDispatchSaleOrderMapper.updateByPrimaryKeySelective(amsDispatchSaleOrder);
  967. }
  968. /*
  969. 运输订单
  970. */
  971. OmstruckOrder omstruckOrder = new OmstruckOrder();
  972. Map<String, Object> map1 = new HashMap<>();
  973. map1.put("orderType", new BigDecimal(2));
  974. map1.put("orderPlanId", saleOrderMaterialId);
  975. List<OmstruckOrder> omstruckOrders = omstruckOrderMapper.selectByParameters(map1);
  976. if (omstruckOrders == null || omstruckOrders.size() == 0) {
  977. // 运输订单主键
  978. BigDecimal orderId = omstruckOrderMapper.selectMaxId();
  979. omstruckOrder.setOrderId(orderId);
  980. // 车序号主键
  981. omstruckOrder.setOrderPlanId(saleOrderMaterialId);
  982. //添加承运商ID 和 运价ID
  983. // Object priceId = map.get("priceId");
  984. if (priceId != null) {
  985. omstruckOrder.setPriceId(priceId);
  986. } else {
  987. omstruckOrder.setPriceId(new BigDecimal(0));
  988. }
  989. omstruckOrder.setCarrierId(carrierId);
  990. // 运输订单号
  991. omstruckOrder.setOrderNumber(DataChange.generateEightDigitsNumber("WYSDD", orderId.intValue()));
  992. // 运力id
  993. omstruckOrder.setCapacityId(capacityId);
  994. // 承运商
  995. omstruckOrder.setCarrierId(carrierId);
  996. // 是否可作业
  997. omstruckOrder.setCanWork(new BigDecimal(0));
  998. // 下发时间
  999. omstruckOrder.setOrderIssueTime(new Date());
  1000. // 运单状态
  1001. omstruckOrder.setOrderStatus(new BigDecimal(4));
  1002. // 司机电话
  1003. if(tel != null && !"".equals(tel)){
  1004. omstruckOrder.setDriverTel(tel);
  1005. }
  1006. BigDecimal status;
  1007. // 钢材
  1008. status = new BigDecimal(1);
  1009. // 订单类型
  1010. omstruckOrder.setOrderType(status);
  1011. // 运输线路id
  1012. omstruckOrder.setLineId(lineId);
  1013. omstruckOrder.setInsertTime(new Date());
  1014. omstruckOrder.setInsertUsername("");
  1015. result += omstruckOrderMapper.insertSelective(omstruckOrder);
  1016. //插入日志
  1017. saleLogUtil.logOrder(orderId,"普通派单,派车号:" + capacityNumber,map,SaleLogUtil.INSERT);
  1018. } else {
  1019. omstruckOrder = omstruckOrders.get(0);
  1020. }
  1021. for (Map<String, Object> materialMap : materialList) {
  1022. BigDecimal materialId = (BigDecimal) materialMap.get("materialId");
  1023. BigDecimal materialWeight = (BigDecimal) materialMap.get("materialWeight");
  1024. BigDecimal materialNumber = (BigDecimal) materialMap.get("materialNumber");
  1025. BigDecimal saleMaterialId = (BigDecimal) materialMap.get("saleMaterialId");
  1026. /*
  1027. 运输订单物资子表
  1028. */
  1029. OmstruckOrderMaterial omstruckOrderMaterial = new OmstruckOrderMaterial();
  1030. // 主键
  1031. BigDecimal orderMaterialId = omstruckOrderMaterialMapper.selectMaxId();
  1032. omstruckOrderMaterial.setOrderMaterialId(orderMaterialId);
  1033. // 运输订单id
  1034. omstruckOrderMaterial.setOrderId(omstruckOrder.getOrderId());
  1035. // 物资id
  1036. omstruckOrderMaterial.setMaterialId(materialId);
  1037. // 物资重量
  1038. omstruckOrderMaterial.setOrderMaterialWeight(materialWeight);
  1039. // 物资件数
  1040. omstruckOrderMaterial.setOrderMaterialNumber(materialNumber);
  1041. omstruckOrderMaterial.setSaleMaterialId(saleMaterialId);
  1042. // 新增运输订单子表
  1043. result += omstruckOrderMaterialMapper.insertSelective(omstruckOrderMaterial);
  1044. }
  1045. // 调用websocket
  1046. Map<String, Object> orderIdMap = new HashMap<>();
  1047. orderIdMap.put("orderId", omstruckOrder.getOrderId());
  1048. try {
  1049. amsSaleOrderMaterialService.pushMesToWebsocket(orderIdMap);
  1050. } catch (Exception e) {
  1051. e.printStackTrace();
  1052. }
  1053. // 生成运输执行总实绩
  1054. result += tmsTruckFeign.addTotalResult(orderIdMap);
  1055. }
  1056. return result;
  1057. }
  1058. /**
  1059. * 钢材批量派车或改车
  1060. * @param mapList
  1061. * @return
  1062. * @throws Exception
  1063. */
  1064. @Override
  1065. @Transactional(rollbackFor = Exception.class)
  1066. public int batchUpdateCapacity(List<Map<String, Object>> mapList) throws Exception {
  1067. //先派车
  1068. for(Map<String, Object> item:mapList){
  1069. String capacityIds=""+item.get("capacityIds");
  1070. if(capacityIds.equals("0")){
  1071. //钢材派车
  1072. dispatchSteelOrderNotPush(item);
  1073. }else{
  1074. //钢材改车
  1075. updateSteelOrderNotPush(item);
  1076. }
  1077. }
  1078. //再上传金蝶
  1079. batchPushCarNumberToEas(mapList);
  1080. return 0;
  1081. }
  1082. @Override
  1083. public int updateSaleOrderRemark(List<Map<String, Object>> list) {
  1084. int i = 0;
  1085. for(Map<String,Object> map :list) {
  1086. BigDecimal saleOrderId = DataChange.dataToBigDecimal(map.get("saleOrderId"));
  1087. AmsSaleOrder amsSaleOrder = amsSaleOrderMapper.selectByPrimaryKey(saleOrderId);
  1088. amsSaleOrder.setInsertUpdateRemark("重新设置继续装");
  1089. i += amsSaleOrderMapper.updateByPrimaryKeySelective(amsSaleOrder);
  1090. }
  1091. return i;
  1092. }
  1093. @Override
  1094. public int continueSteelOrder(List<Map<String, Object>> mapList) throws Exception {
  1095. int result = 0;
  1096. // 遍历每一行
  1097. for (Map<String,Object> map : mapList) {
  1098. List<OmstruckOrder> orders=omstruckOrderMapper.selectByParameters(map);
  1099. if(orders==null || orders.size()<=0){
  1100. throw new Exception("没有对应的运输订单");
  1101. }
  1102. OmstruckOrder omstruckOrder=orders.get(0);
  1103. // 得到车序号表主键
  1104. BigDecimal saleOrderMaterialId = DataChange.dataToBigDecimal(map.get("saleOrderMaterialId"));
  1105. // 得到承运商
  1106. BigDecimal carrierId = omstruckOrder.getCarrierId();
  1107. //查询车序号表物资
  1108. List<Map<String, Object>> materialList = amsSaleOrderMaterialMapper.getMaterial(saleOrderMaterialId);
  1109. if(materialList==null||materialList.size()<=0){
  1110. throw new Exception("车序号没有剩余物资");
  1111. }
  1112. // 程序根据剩余多少拼生成运输线路id 110001 到 110010(单拼到十拼)
  1113. BigDecimal lineId = DataChange.dataToBigDecimal(110000+materialList.size());
  1114. /*
  1115. 定向派单表
  1116. */
  1117. // 通过车序号主键确认定向派单是否已存在
  1118. BigDecimal dispatchId0 = amsDispatchSaleOrderMapper.isDispatchExist(saleOrderMaterialId);
  1119. if (dispatchId0 == null || dispatchId0.toString().length() == 0) {
  1120. AmsDispatchSaleOrder amsDispatchSaleOrder = new AmsDispatchSaleOrder();
  1121. // 主键
  1122. BigDecimal dispatchId = amsDispatchSaleOrderMapper.selectOtherId();
  1123. amsDispatchSaleOrder.setDispatchId(dispatchId);
  1124. // 车序号表id
  1125. amsDispatchSaleOrder.setSaleOrderMaterialId(saleOrderMaterialId);
  1126. // 承运商id
  1127. amsDispatchSaleOrder.setCarrierId(carrierId);
  1128. // 派单时间和成交时间
  1129. amsDispatchSaleOrder.setDispatchTime(new Date());
  1130. amsDispatchSaleOrder.setDispatchDealTime(new Date());
  1131. // 成交类型
  1132. amsDispatchSaleOrder.setDispatchType(new BigDecimal(2));
  1133. // 车序号状态
  1134. amsDispatchSaleOrder.setDispatchStatus(new BigDecimal(2));
  1135. result += amsDispatchSaleOrderMapper.insertSelective(amsDispatchSaleOrder);
  1136. }
  1137. // 如果已经匹配过承运商或者给某个承运商授权过,则派车时做修改承运商操作
  1138. else {
  1139. AmsDispatchSaleOrder amsDispatchSaleOrder = amsDispatchSaleOrderMapper.selectByPrimaryKey(dispatchId0);
  1140. amsDispatchSaleOrder.setCarrierId(carrierId);
  1141. result += amsDispatchSaleOrderMapper.updateByPrimaryKeySelective(amsDispatchSaleOrder);
  1142. }
  1143. /*
  1144. 运输订单
  1145. */
  1146. // 运输订单主键
  1147. BigDecimal orderId = omstruckOrderMapper.selectMaxId();
  1148. omstruckOrder.setOrderId(orderId);
  1149. // 车序号主键
  1150. omstruckOrder.setOrderPlanId(saleOrderMaterialId);
  1151. // 是否可作业
  1152. omstruckOrder.setCanWork(new BigDecimal(0));
  1153. // 下发时间
  1154. omstruckOrder.setOrderIssueTime(new Date());
  1155. //如果该订单已有出厂实绩,不允许生成继续装
  1156. int outFactoryResult = amsSaleOrderMapper.selectOutFactoryResult(omstruckOrder.getOrderNumber());
  1157. // 运单状态
  1158. if(omstruckOrder.getOrderReceiveRefuseTime()!=null){
  1159. omstruckOrder.setOrderStatus(new BigDecimal(7));
  1160. }else{
  1161. omstruckOrder.setOrderStatus(new BigDecimal(4));
  1162. }
  1163. //路段顺序号
  1164. //omstruckOrder.setOrderLineSequence(new BigDecimal(2));
  1165. // 运输线路id
  1166. omstruckOrder.setLineId(lineId);
  1167. omstruckOrder.setInsertTime(new Date());
  1168. omstruckOrder.setInsertUsername("continue");
  1169. result += omstruckOrderMapper.insertSelective(omstruckOrder);
  1170. //插入日志
  1171. saleLogUtil.logOrder(orderId,"继续装派单",map,SaleLogUtil.INSERT);
  1172. for (Map<String, Object> materialMap : materialList) {
  1173. BigDecimal materialId = (BigDecimal) materialMap.get("materialId");
  1174. BigDecimal materialWeight = (BigDecimal) materialMap.get("materialWeight");
  1175. BigDecimal materialNumber = (BigDecimal) materialMap.get("materialNumber");
  1176. BigDecimal saleMaterialId = (BigDecimal) materialMap.get("saleMaterialId");
  1177. /*
  1178. 运输订单物资子表
  1179. */
  1180. OmstruckOrderMaterial omstruckOrderMaterial = new OmstruckOrderMaterial();
  1181. // 主键
  1182. BigDecimal orderMaterialId = omstruckOrderMaterialMapper.selectMaxId();
  1183. omstruckOrderMaterial.setOrderMaterialId(orderMaterialId);
  1184. // 运输订单id
  1185. omstruckOrderMaterial.setOrderId(omstruckOrder.getOrderId());
  1186. // 物资id
  1187. omstruckOrderMaterial.setMaterialId(materialId);
  1188. // 物资重量
  1189. omstruckOrderMaterial.setOrderMaterialWeight(materialWeight);
  1190. // 物资件数
  1191. omstruckOrderMaterial.setOrderMaterialNumber(materialNumber);
  1192. omstruckOrderMaterial.setSaleMaterialId(saleMaterialId);
  1193. // 新增运输订单子表
  1194. result += omstruckOrderMaterialMapper.insertSelective(omstruckOrderMaterial);
  1195. }
  1196. // 调用websocket
  1197. Map<String, Object> orderIdMap = new HashMap<>();
  1198. orderIdMap.put("orderId", omstruckOrder.getOrderId());
  1199. amsSaleOrderMaterialService.pushMesToWebsocket(orderIdMap);
  1200. orderIdMap.put("orderIdOld", map.get("orderId"));
  1201. orderIdMap.put("resultTotalIdOld",map.get("resultTotalId"));
  1202. // 生成所有实绩
  1203. result += tmsTruckFeign.copyAllResult(orderIdMap);
  1204. }
  1205. return result;
  1206. }
  1207. /**
  1208. * 根据详细地址匹配承运商
  1209. * @param placeId
  1210. * @return
  1211. */
  1212. @Override
  1213. public synchronized List<Map<String,Object>> getCarrierByPlace(BigDecimal placeId) {
  1214. BigDecimal addressId = amsSaleOrderMapper.getAddressByPlace(placeId);
  1215. List<Map<String,Object>> mapList = amsSaleOrderMapper.getCarrierByPlace(placeId);
  1216. return mapList;
  1217. }
  1218. /**
  1219. * 根据省市县匹配承运商
  1220. * @param placeId
  1221. * @return
  1222. */
  1223. public synchronized List<Map<String,Object>> getCarrierByAddress(BigDecimal placeId) {
  1224. BigDecimal addressId = amsSaleOrderMapper.getAddressByPlace(placeId);
  1225. List<Map<String,Object>> mapList = amsSaleOrderMapper.getCarrierByAddress(addressId);
  1226. try {
  1227. if(mapList != null && mapList.size() != 1) {
  1228. mapList = amsSaleOrderMapper.getNextCarrier(addressId.intValue());
  1229. }
  1230. } catch (Exception e) {
  1231. e.printStackTrace();
  1232. }
  1233. return mapList;
  1234. }
  1235. /**
  1236. * 根据详细地址和承运商匹配单价
  1237. * @param mapValue
  1238. * @return
  1239. */
  1240. @Override
  1241. public Map<String, Object> getPriceByCarrierAndPlace(Map<String, Object> mapValue) {
  1242. Map<String,Object> map = amsSaleOrderMapper.getPriceByCarrierAndPlace(mapValue);
  1243. return map;
  1244. }
  1245. /**
  1246. * 将车序号下发给承运商
  1247. * @param mapList
  1248. * @return
  1249. */
  1250. @Override
  1251. public int dispatchToCarrier(List<Map<String,Object>> mapList) {
  1252. int result = 0;
  1253. // 遍历每一行
  1254. for (Map<String, Object> map : mapList) {
  1255. // 得到承运商
  1256. BigDecimal carrierId =DataChange.dataToBigDecimal(map.get("carrierId"));
  1257. // 得到车序号表主键
  1258. BigDecimal saleOrderMaterialId =DataChange.dataToBigDecimal(map.get("saleOrderMaterialId"));
  1259. //判断该车序号有没有被授权
  1260. List<BigDecimal> dispatchCarriers = amsDispatchSaleOrderMapper.getDispatchCarriers(saleOrderMaterialId);
  1261. //如果有的话删除授权,重新新增
  1262. for(BigDecimal dispatchId : dispatchCarriers) {
  1263. amsDispatchSaleOrderMapper.deleteByPrimaryKey(dispatchId);
  1264. }
  1265. //判断该车序号有没有被授权
  1266. AmsDispatchSaleOrder amsDispatchSaleOrder = new AmsDispatchSaleOrder();
  1267. BigDecimal dispatchId = amsDispatchSaleOrderMapper.selectOtherId();
  1268. amsDispatchSaleOrder.setDispatchId(dispatchId);
  1269. amsDispatchSaleOrder.setCarrierId(carrierId);
  1270. amsDispatchSaleOrder.setSaleOrderMaterialId(saleOrderMaterialId);
  1271. amsDispatchSaleOrder.setInsertTime(new Date());
  1272. amsDispatchSaleOrder.setInsertUpdateRemark("授权承运商");
  1273. // 派单时间和成交时间
  1274. amsDispatchSaleOrder.setDispatchTime(new Date());
  1275. amsDispatchSaleOrder.setDispatchDealTime(new Date());
  1276. // 成交类型
  1277. amsDispatchSaleOrder.setDispatchType(new BigDecimal(2));
  1278. // 车序号状态
  1279. amsDispatchSaleOrder.setDispatchStatus(new BigDecimal(2));
  1280. result += amsDispatchSaleOrderMapper.insertSelective(amsDispatchSaleOrder);
  1281. }
  1282. return result;
  1283. }
  1284. @Override
  1285. public List<Map<String, Object>> getSaleOrderListToCarrier(Map<String, Object> map) {
  1286. List<Map<String, Object>> resultList = amsSaleOrderMapper.getSaleOrderListToCarrier(map);
  1287. if (resultList.isEmpty()){
  1288. }else {
  1289. for (Map<String, Object> stringObjectMap : resultList) {
  1290. try {
  1291. BigDecimal saleShippingAddressId = (BigDecimal) stringObjectMap.get("saleShippingAddressId");
  1292. if (saleShippingAddressId!=null&&!("".equals(saleShippingAddressId))){
  1293. String address = amsSaleOrderMapper.getshippingAddress(saleShippingAddressId);
  1294. stringObjectMap.put("saleShippingAddress",address);
  1295. }
  1296. }catch (Exception e){
  1297. System.out.println("e"+e.getMessage());
  1298. stringObjectMap.put("saleShippingAddress","");
  1299. }
  1300. }
  1301. }
  1302. return resultList;
  1303. }
  1304. @Override
  1305. public List<Map<String, Object>> getSaleOrderListByCarrierSsoId(Map<String, Object> map) {
  1306. List<Map<String, Object>> resultList = amsSaleOrderMapper.getSaleOrderListByCarrierSsoId(map);
  1307. return resultList;
  1308. }
  1309. /**
  1310. * 同步金蝶删除
  1311. * @param saleOrderId
  1312. * @return
  1313. */
  1314. @Override
  1315. public int deleteSaleOrderById(BigDecimal saleOrderId) {
  1316. int result = 0;
  1317. AmsSaleOrder amsSaleOrder = new AmsSaleOrder();
  1318. amsSaleOrder.setSaleOrderId(saleOrderId);
  1319. amsSaleOrder.setDeleted(new BigDecimal(2));
  1320. // 如果是已经上传金蝶的销售订单,则同步删除
  1321. AmsSaleOrder amsSaleOrder1 = amsSaleOrderMapper.selectByPrimaryKey(saleOrderId);
  1322. if (amsSaleOrder1.getSaleOrderStatus().intValue() == 4) {
  1323. String reason = "修改物资关闭上一条销售订单";
  1324. String number = amsSaleOrder1.getSaleNumber();
  1325. String wholeOrder = "1";
  1326. String status = "close";
  1327. Map<String,Object> head = new HashMap<>();
  1328. head.put("number",number);
  1329. head.put("reason",reason);
  1330. head.put("wholeOrder",wholeOrder);
  1331. head.put("status",status);
  1332. Map<String,Object> input = new HashMap<>();
  1333. Map<String, Object> totalMap = easDeleteApproveUtil.getTotalMap();
  1334. input.put("head",head);
  1335. totalMap.put("input",input);
  1336. // 调用金蝶关闭接口
  1337. String json = JSONUtils.toJSONString(totalMap);
  1338. System.out.println(json);
  1339. Map<String,Object> resultMap = joinFeign.deleteSaleOrderToEas(totalMap);
  1340. try {
  1341. newFileTool.newFile("deleteSaleOrderToEas:"+totalMap,"金蝶通讯报文");
  1342. }catch (Exception e){
  1343. e.printStackTrace();
  1344. }
  1345. System.out.println(resultMap);
  1346. }else if(amsSaleOrder1.getSaleOrderStatus().intValue() == 1 || amsSaleOrder1.getSaleOrderStatus().intValue() == 2){
  1347. String reason = "修改物资关闭上一条销售订单";
  1348. String number = amsSaleOrder1.getSaleNumber();
  1349. Map<String, Object> deleteMap = new HashMap<>();
  1350. deleteMap.put("saleOrderId",saleOrderId);
  1351. deleteMap.put("reason",reason);
  1352. deleteMap.put("number",number);
  1353. deleteSaleOrderSame(deleteMap);
  1354. }
  1355. // 如果是副产品订单则关闭时同步关闭未进厂的运单
  1356. Map<String,Object> map = new HashMap<>();
  1357. map.put("saleOrderId",saleOrderId);
  1358. List<AmsSaleMaterial> amsSaleMaterials = amsSaleMaterialMapper.selectByParameters(map);
  1359. if (amsSaleMaterials != null && amsSaleMaterials.get(0).getSaleWarehouse() != null && amsSaleMaterials.get(0).getSaleWarehouse().equals("副产品库")) {
  1360. result += amsSaleOrderMapper.closeOrderNotIn(saleOrderId);
  1361. }
  1362. result += amsSaleOrderMapper.updateByPrimaryKeySelective(amsSaleOrder);
  1363. return result;
  1364. }
  1365. /**
  1366. * 查询出销售订单下的所有数据
  1367. * @param saleOrderId
  1368. * @return
  1369. */
  1370. @Override
  1371. public Map<String, Object> getAllSaleMessages(BigDecimal saleOrderId) {
  1372. Map<String,Object> saleMap = amsSaleOrderMapper.getSaleMapMessages(saleOrderId);
  1373. List<Map<String,Object>> mapList = amsSaleOrderMapper.getSaleListMessages(saleOrderId);
  1374. saleMap.put("mapList",mapList);
  1375. return saleMap;
  1376. }
  1377. /**
  1378. * 修改承运商授权
  1379. * @param mapValue
  1380. * @return
  1381. */
  1382. @Override
  1383. public int updateTruckNoCarrier(Map<String, Object> mapValue) {
  1384. BigDecimal carrierId = DataChange.dataToBigDecimal(mapValue.get("carrierId"));
  1385. mapValue.remove("carrierId");
  1386. List<AmsDispatchSaleOrder> amsDispatchSaleOrders = amsDispatchSaleOrderMapper.selectByParameters(mapValue);
  1387. AmsDispatchSaleOrder amsDispatchSaleOrder = amsDispatchSaleOrders.get(0);
  1388. amsDispatchSaleOrder.setCarrierId(carrierId);
  1389. int result = amsDispatchSaleOrderMapper.updateByPrimaryKeySelective(amsDispatchSaleOrder);
  1390. return result;
  1391. }
  1392. /**
  1393. * 批量上传销售订单至金蝶
  1394. * @param saleOrderIdList
  1395. * @return
  1396. */
  1397. @Transactional(rollbackFor = Exception.class)
  1398. @Override
  1399. public int uploadSaleOrderList(List<Map<String, Object>> saleOrderIdList) {
  1400. int result = 0;
  1401. for (Map<String, Object> map : saleOrderIdList) {
  1402. AmsSaleOrder amsSaleOrder = new AmsSaleOrder();
  1403. BigDecimal saleOrderId = DataChange.dataToBigDecimal(map.get("saleOrderId"));
  1404. // 调用金蝶接口,将销售订单推送到金蝶系统
  1405. Map<String, Object> input = joinFeign.getSaleOrder(saleOrderId);
  1406. Map<String, Object> head = (Map<String, Object>) input.get("head");
  1407. head.put("status","");
  1408. // 获得金蝶接口配置:正式
  1409. // Map<String, Object> totalMap = easUtil.getTotalMap();
  1410. // 获得金蝶接口配置:测试
  1411. Map<String, Object> totalMap = easUtil.getTotalMap();
  1412. // 组装报文
  1413. totalMap.put("input",input);
  1414. System.out.println(totalMap);
  1415. String json = JSONUtils.toJSONString(totalMap);
  1416. System.out.println(json);
  1417. Map<String,Object> s = joinFeign.pushSaleOrderToEas(totalMap);
  1418. try {
  1419. newFileTool.newFile("pushSaleOrderToEas:"+totalMap,"金蝶通讯报文");
  1420. }catch (Exception e){
  1421. e.printStackTrace();
  1422. }
  1423. String status = (String) s.get("status");
  1424. if ("-1".equals(status)) {
  1425. continue;
  1426. }
  1427. System.out.println(s);
  1428. amsSaleOrder.setSaleOrderId(saleOrderId);
  1429. amsSaleOrder.setSaleOrderStatus(new BigDecimal(1));
  1430. result += amsSaleOrderMapper.updateByPrimaryKeySelective(amsSaleOrder);
  1431. }
  1432. return result;
  1433. }
  1434. /**
  1435. * 新增钒渣销售订单
  1436. * @param mapValue
  1437. * @return
  1438. */
  1439. @Override
  1440. public int addVanadiumSaleOrder(Map<String, Object> mapValue) {
  1441. List<Map<String,Object>> mapList = (List<Map<String, Object>>) mapValue.get("mapList");
  1442. // 得到发货单位
  1443. BigDecimal shipperId = DataChange.dataToBigDecimal(mapValue.get("shipperId"));
  1444. // 收货单位
  1445. BigDecimal receiveId = DataChange.dataToBigDecimal(mapValue.get("receiveId"));
  1446. // 是否自提
  1447. String isSelfMention = (String) mapValue.get("isSelfMention");
  1448. // 备注
  1449. String saleRemark = (String) mapValue.get("saleRemark");
  1450. // 收款客户
  1451. String saleOrderReceiveCustomer = (String) mapValue.get("saleOrderReceiveCustomer");
  1452. // 业务员
  1453. BigDecimal salerId = DataChange.dataToBigDecimal(mapValue.get("salerId"));
  1454. BigDecimal saleOrderId = amsSaleOrderMapper.selectMaxId();
  1455. int result = 0;
  1456. // 销售订单
  1457. AmsSaleOrder amsSaleOrder = new AmsSaleOrder();
  1458. amsSaleOrder.setReceiveId(receiveId);
  1459. amsSaleOrder.setSaleRemark(saleRemark == null ? "":saleRemark);
  1460. amsSaleOrder.setShipperId(shipperId);
  1461. amsSaleOrder.setSaleOrderIsselfMention(isSelfMention);
  1462. amsSaleOrder.setSaleOrderId(saleOrderId);
  1463. amsSaleOrder.setSalerId(salerId);
  1464. // 设置钒渣订单
  1465. amsSaleOrder.setSaleType(new BigDecimal(2));
  1466. amsSaleOrder.setSaleNumber(DataChange.generateEightDigitsNumber("WXSDD",saleOrderId.intValue(),"-"));
  1467. amsSaleOrder.setInsertTime(new Date());
  1468. amsSaleOrder.setInsertUpdateRemark("物流新增销售订单");
  1469. amsSaleOrder.setInsertUsername("物流");
  1470. amsSaleOrder.setUpdateTime(new Date());
  1471. amsSaleOrder.setDeleted(new BigDecimal(0));
  1472. amsSaleOrder.setSaleOrderStatus(new BigDecimal(0));
  1473. // 税率默认13%
  1474. amsSaleOrder.setSaleOrderTax("13%");
  1475. // 含税单价某人4000
  1476. amsSaleOrder.setSaleUnitPrice(new BigDecimal(4000));
  1477. // 收款客户
  1478. amsSaleOrder.setSaleOrderReceiveCustomer(saleOrderReceiveCustomer);
  1479. // 销售订单物资表
  1480. AmsSaleMaterial amsSaleMaterial = new AmsSaleMaterial();
  1481. // 车序号物资表
  1482. AmsSaleTrucknoMaterial amsSaleTrucknoMaterial = new AmsSaleTrucknoMaterial();
  1483. // 遍历每一行
  1484. for (Map<String, Object> map : mapList) {
  1485. /*
  1486. 车序号表
  1487. */
  1488. // 得到车序号
  1489. BigDecimal truckNo = DataChange.dataToBigDecimal(map.get("truckNo"));
  1490. Map<String,Object> saleMap = new HashMap<>();
  1491. saleMap.put("saleOrderId",saleOrderId);
  1492. saleMap.put("saleOrderMaterialTruckNo",truckNo);
  1493. // 检测销售订单下的车序号是否已存在
  1494. List<AmsSaleOrderMaterial> amsSaleOrderMaterials = amsSaleOrderMaterialMapper.selectByParameters(saleMap);
  1495. // 车序号表
  1496. AmsSaleOrderMaterial amsSaleOrderMaterial = new AmsSaleOrderMaterial();
  1497. if (amsSaleOrderMaterials == null || amsSaleOrderMaterials.size() == 0) {
  1498. // 车序号主键
  1499. BigDecimal saleOrderMaterialId = amsSaleOrderMaterialMapper.selectMaxId();
  1500. BigDecimal shippingAddressId = DataChange.dataToBigDecimal(map.get("shipperAddressId"));
  1501. // 车号备注
  1502. String truckRemark = (String) (map.get("truckRemark"));
  1503. String place = (String) (map.get("place"));
  1504. if (place != null && !"null".equals(place)) {
  1505. List<Map<String, Object>> placeIdList = amsSaleOrderMaterialMapper.getPlaceId(place,shippingAddressId);
  1506. if (placeIdList == null || placeIdList.size() == 0) {
  1507. RmsReceivePlace rmsReceivePlace = new RmsReceivePlace();
  1508. rmsReceivePlace.setPlaceId(rmsReceivePlaceMapper.selectMaxId());
  1509. rmsReceivePlace.setAddressId(shippingAddressId);
  1510. rmsReceivePlace.setAddressDeliveryAddress(place);
  1511. amsSaleOrderMaterial.setSaleShippingAddressId(rmsReceivePlace.getPlaceId());
  1512. rmsReceivePlaceMapper.insertSelective(rmsReceivePlace);
  1513. } else {
  1514. amsSaleOrderMaterial.setSaleShippingAddressId((BigDecimal) placeIdList.get(0).get("placeId"));
  1515. }
  1516. }
  1517. if (amsSaleOrderMaterial.getSaleShippingAddressId() != null && isSelfMention.equals("否")) {
  1518. // 自动匹配承运商
  1519. List<Map<String, Object>> carrierList = getCarrierByPlace(amsSaleOrderMaterial.getSaleShippingAddressId());
  1520. // 单一承运商才进行匹配
  1521. if (carrierList != null && carrierList.size() == 1) {
  1522. List<Map<String, Object>> list = new ArrayList<>();
  1523. Map<String, Object> map1 = carrierList.get(0);
  1524. // 传入车序号主键和承运商id
  1525. map1.put("saleOrderMaterialId", saleOrderMaterialId);
  1526. map1.put("carrierId", map1.get("value"));
  1527. list.add(map1);
  1528. dispatchToCarrier(list);
  1529. }
  1530. }
  1531. if (isSelfMention.equals("是")) {
  1532. // 根据收货单位id查询出收货单位名称
  1533. String consigneeName = amsSaleOrderMapper.selectConsigneeName(receiveId);
  1534. // 根据收货单位名称查询承运商id
  1535. BigDecimal carrierId = amsSaleOrderMapper.selectCarrierId(consigneeName);
  1536. List<Map<String, Object>> list = new ArrayList<>();
  1537. Map<String,Object> map1 = new HashMap<>();
  1538. // 传入车序号主键和承运商id
  1539. if (carrierId != null) {
  1540. map1.put("saleOrderMaterialId", saleOrderMaterialId);
  1541. map1.put("carrierId", carrierId);
  1542. list.add(map1);
  1543. dispatchToCarrier(list);
  1544. }
  1545. }
  1546. // 收货方姓名
  1547. String consigneeName = String.valueOf(map.get("saleOrderConsignee"));
  1548. // 收货方电话
  1549. String consigneeTel = String.valueOf(map.get("saleOrderConsigneeTel"));
  1550. // 截止日期
  1551. String dateOfReceiptStr = String.valueOf(map.get("saleDateOfReceipt"));
  1552. Date dateOfReceipt = null;
  1553. if (!"null".equals(dateOfReceiptStr) && !"undefined".equals(dateOfReceiptStr)) {
  1554. dateOfReceipt = new Date(Long.valueOf(dateOfReceiptStr));
  1555. }
  1556. amsSaleOrderMaterial.setSaleOrderMaterialId(saleOrderMaterialId);
  1557. amsSaleOrderMaterial.setSaleOrderId(saleOrderId);
  1558. amsSaleOrderMaterial.setTruckRemark(truckRemark);
  1559. amsSaleOrderMaterial.setSaleOrderMaterialTruckNo(truckNo);
  1560. if (consigneeName != null && !consigneeName.equals("null")) {
  1561. amsSaleOrderMaterial.setSaleOrderConsignee(consigneeName);
  1562. }
  1563. if (consigneeTel != null && !consigneeTel.equals("null")) {
  1564. amsSaleOrderMaterial.setSaleOrderConsigneeTel(consigneeTel);
  1565. }
  1566. amsSaleOrderMaterial.setSaleDateOfReceipt(dateOfReceipt);
  1567. amsSaleOrderMaterial.setInsertTime(new Date());
  1568. amsSaleOrderMaterial.setUpdateTime(new Date());
  1569. amsSaleOrderMaterial.setInsertUpdateRemark("物流新增");
  1570. result += amsSaleOrderMaterialMapper.insertSelective(amsSaleOrderMaterial);
  1571. }
  1572. else {
  1573. amsSaleOrderMaterial = amsSaleOrderMaterials.get(0);
  1574. }
  1575. /*
  1576. 销售订单物资表
  1577. */
  1578. // 物资
  1579. BigDecimal materialId = DataChange.dataToBigDecimal(map.get("materialId"));
  1580. // 物资件数
  1581. BigDecimal materialNumber = DataChange.dataToBigDecimal(map.get("materialNumber"));
  1582. // 钢材米数
  1583. BigDecimal steelMeters = DataChange.dataToBigDecimal(map.get("steelMeters"));
  1584. // 是否磅重销售(0:磅重;1:理重)
  1585. BigDecimal isPoundSale = DataChange.dataToBigDecimal(map.get("isPoundSale"));
  1586. // 销售订单物资表主键
  1587. BigDecimal saleMaterialId = amsSaleMaterialMapper.selectMaxId();
  1588. amsSaleMaterial.setSaleMaterialId(saleMaterialId);
  1589. amsSaleMaterial.setSaleOrderId(saleOrderId);
  1590. amsSaleMaterial.setMaterialId(materialId);
  1591. amsSaleMaterial.setMaterialNumber(materialNumber);
  1592. amsSaleMaterial.setInsertTime(new Date());
  1593. amsSaleMaterial.setUpdateTime(new Date());
  1594. if (steelMeters != null && !steelMeters.toString().equals("0")) {
  1595. amsSaleMaterial.setSteelMeter(steelMeters);
  1596. }
  1597. amsSaleMaterial.setIsPoundSale(isPoundSale);
  1598. amsSaleMaterial.setInsertUpdateRemark("物流新增");
  1599. result += amsSaleMaterialMapper.insertSelective(amsSaleMaterial);
  1600. /*
  1601. 车序号物资表
  1602. */
  1603. // 车序号物资表主键
  1604. BigDecimal truckNoMaterialId = amsSaleTrucknoMaterialMapper.selectMaxId();
  1605. amsSaleTrucknoMaterial.setTrucknoMaterialId(truckNoMaterialId);
  1606. amsSaleTrucknoMaterial.setSaleOrderMaterialId(amsSaleOrderMaterial.getSaleOrderMaterialId());
  1607. amsSaleTrucknoMaterial.setMaterialId(amsSaleMaterial.getSaleMaterialId());
  1608. amsSaleTrucknoMaterial.setSaleOrderMaterialNumber(materialNumber);
  1609. amsSaleTrucknoMaterial.setInsertTime(new Date());
  1610. amsSaleTrucknoMaterial.setUpdateTime(new Date());
  1611. amsSaleTrucknoMaterial.setInsertUpdateRemark("物流新增");
  1612. result += amsSaleTrucknoMaterialMapper.insertSelective(amsSaleTrucknoMaterial);
  1613. }
  1614. result += amsSaleOrderMapper.insertSelective(amsSaleOrder);
  1615. return result;
  1616. }
  1617. /**
  1618. * 自动匹配出最近的一个地址
  1619. * @param receiveId
  1620. * @return
  1621. */
  1622. @Override
  1623. public List<Map<String, Object>> matchingAddressRecently(BigDecimal receiveId) {
  1624. List<Map<String,Object>> mapList = amsSaleOrderMapper.matchingAddressRecently(receiveId);
  1625. List<Map<String,Object>> salerList = amsSaleOrderMapper.getSalerByReceiveId(receiveId);
  1626. if (mapList != null && mapList.size() != 0) {
  1627. if (salerList != null && salerList.size() !=0) {
  1628. Map<String, Object> salerMap = salerList.get(0);
  1629. for (Map<String, Object> map : mapList) {
  1630. map.putAll(salerMap);
  1631. }
  1632. }
  1633. }
  1634. return mapList;
  1635. }
  1636. /**
  1637. * 自动匹配上一条运单的司机电话
  1638. * @param capacityNumber
  1639. * @return
  1640. */
  1641. @Override
  1642. public String matchingDriverTelRecently(String capacityNumber) {
  1643. String driverTel = amsSaleOrderMapper.matchingDriverTelRecently(capacityNumber);
  1644. return driverTel;
  1645. }
  1646. /**
  1647. * 查询内转焦炭订单
  1648. * @param mapValue
  1649. * @return
  1650. */
  1651. @Override
  1652. public List<Map<String, Object>> getCokeInwardOrderList(Map<String, Object> mapValue) {
  1653. return amsSaleOrderMapper.getCokeInwardOrderList(mapValue);
  1654. }
  1655. /**
  1656. * 修改收货地址
  1657. * @param mapValue
  1658. * @return
  1659. */
  1660. @Transactional(rollbackFor = Exception.class)
  1661. @Override
  1662. public int updateCarAddress(Map<String, Object> mapValue) {
  1663. // 判断是否需要删除金蝶分录
  1664. Integer isCloseEas = (Integer) mapValue.get("isCloseEas");
  1665. String operateName = (String) mapValue.get("operateName");
  1666. int result = 0;
  1667. // 运输订单id
  1668. BigDecimal orderId = DataChange.dataToBigDecimal(mapValue.get("orderId"));
  1669. // 车序号id
  1670. BigDecimal saleOrderMaterialId = DataChange.dataToBigDecimal(mapValue.get("saleOrderMaterialId"));
  1671. // 是
  1672. if (isCloseEas == 0 && orderId != null && orderId.intValue() != 0) {
  1673. OmstruckOrder omstruckOrder = new OmstruckOrder();
  1674. omstruckOrder.setOrderId(orderId);
  1675. omstruckOrder.setOrderStatus(new BigDecimal(7));
  1676. omstruckOrder.setInsertUpdateRemark("修改收货地址将状态改为7");
  1677. if(operateName != null){
  1678. omstruckOrder.setOptionerCode(operateName);
  1679. }
  1680. omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  1681. //插入日志
  1682. saleLogUtil.logOrder(orderId,"关闭分录,同步关闭运单",mapValue,SaleLogUtil.UPDATE);
  1683. // 得到销售订单物资表主键
  1684. List<Map<String,Object>> saleMaterialIdList = amsSaleOrderMapper.getSaleMaterialId(saleOrderMaterialId);
  1685. for (Map<String, Object> map : saleMaterialIdList) {
  1686. // 关闭销售订单物资子表
  1687. BigDecimal saleMaterialId = (BigDecimal) map.get("saleMaterialId");
  1688. AmsSaleMaterial amsSaleMaterial = new AmsSaleMaterial();
  1689. amsSaleMaterial.setDeleted(new BigDecimal(0));
  1690. amsSaleMaterial.setSaleMaterialId(saleMaterialId);
  1691. amsSaleMaterialMapper.updateByPrimaryKeySelective(amsSaleMaterial);
  1692. }
  1693. return 0;
  1694. }
  1695. //插入日志
  1696. saleLogUtil.logOrder(orderId,"修改收货地址",mapValue,SaleLogUtil.UPDATE);
  1697. // 判断是否需要修改派车
  1698. Object isNewCar = mapValue.get("isNewCar");
  1699. // 省市县ID
  1700. BigDecimal shippingAddressId = DataChange.dataToBigDecimal(mapValue.get("shipperAddressId"));
  1701. // 具体地址
  1702. String place = (String) mapValue.get("place");
  1703. Integer addressid1= (Integer) mapValue.get("placeId");
  1704. BigDecimal addressid2 =BigDecimal.ZERO;
  1705. AmsSaleOrderMaterial amsSaleOrderMaterial = amsSaleOrderMaterialMapper.selectByPrimaryKey(saleOrderMaterialId);
  1706. if (place != null && !("".equals(place))) {
  1707. List<Map<String, Object>> placeIdList = amsSaleOrderMaterialMapper.getPlaceId(place,shippingAddressId);
  1708. if (placeIdList == null || placeIdList.size() == 0) {
  1709. RmsReceivePlace rmsReceivePlace = new RmsReceivePlace();
  1710. BigDecimal placeId = rmsReceivePlaceMapper.selectMaxId();
  1711. rmsReceivePlace.setPlaceId(placeId);
  1712. rmsReceivePlace.setAddressId(shippingAddressId);
  1713. rmsReceivePlace.setAddressDeliveryAddress(place);
  1714. amsSaleOrderMaterial.setSaleShippingAddressId(rmsReceivePlace.getPlaceId());
  1715. rmsReceivePlaceMapper.insertSelective(rmsReceivePlace);
  1716. addressid2 = placeId;
  1717. } else {
  1718. addressid2 =(BigDecimal) placeIdList.get(0).get("placeId");
  1719. amsSaleOrderMaterial.setSaleShippingAddressId((BigDecimal) placeIdList.get(0).get("placeId"));
  1720. }
  1721. }
  1722. try{
  1723. //修改单价
  1724. Map<String,Object> data=new HashMap<>();
  1725. List<Map<String,Object>> mapList = new ArrayList<>();
  1726. mapValue.put("priceId",DataChange.dataToBigDecimal(amsSaleOrderMaterialMapper.getPriceByPlace(addressid2)));
  1727. mapList.add(mapValue);
  1728. data.put("mapList",mapList);
  1729. bmstruckFeign.updateBatchDetailsOrder(data);
  1730. }catch (Exception e){
  1731. e.printStackTrace();
  1732. }
  1733. String addressids="";
  1734. addressids =addressid1+","+addressid2;
  1735. amsSaleOrderMaterial.setShippingAddressIds(addressids);
  1736. amsSaleOrderMaterialMapper.setHistoryAddressId(mapValue);//修改历史地址
  1737. result += amsSaleOrderMaterialMapper.updateByPrimaryKeySelective(amsSaleOrderMaterial);
  1738. //给改了收货地址的车换单价
  1739. try {
  1740. if(orderId != null && orderId.intValue() != 0){
  1741. //1.查看地址是否存在单价
  1742. BigDecimal priceId = amsSaleOrderMaterialMapper.getPriceIdForUpdate(addressid2);
  1743. if (priceId!=null){
  1744. //把当前的单价给修改进运输单中
  1745. amsSaleOrderMaterialMapper.updateOmstruckOrder(priceId,orderId);
  1746. }else {
  1747. //把0存入运输单中
  1748. priceId=BigDecimal.ZERO;
  1749. amsSaleOrderMaterialMapper.updateOmstruckOrder(priceId,orderId);
  1750. }
  1751. }
  1752. }catch (Exception e){
  1753. e.printStackTrace();
  1754. System.out.println("e"+e.getMessage());
  1755. }
  1756. // 需要换车
  1757. if (isNewCar != null && (Integer) isNewCar == 0) {
  1758. // 根据车序号得到定向派单表主键
  1759. BigDecimal dispatchId = amsSaleOrderMapper.getDispatchId(saleOrderMaterialId);
  1760. if (dispatchId != null) {
  1761. amsDispatchSaleOrderMapper.deleteByPrimaryKey(dispatchId);
  1762. }
  1763. if (orderId != null) {
  1764. omstruckOrderMapper.deleteByPrimaryKey(orderId);
  1765. }
  1766. if (amsSaleOrderMaterial.getSaleShippingAddressId() != null) {
  1767. // 自动匹配承运商
  1768. List<Map<String, Object>> carrierList = getCarrierByPlace(amsSaleOrderMaterial.getSaleShippingAddressId());
  1769. // 单一承运商才进行匹配
  1770. if (carrierList != null && carrierList.size() == 1) {
  1771. List<Map<String, Object>> list = new ArrayList<>();
  1772. Map<String, Object> map1 = carrierList.get(0);
  1773. // 传入车序号主键和承运商id
  1774. map1.put("saleOrderMaterialId", saleOrderMaterialId);
  1775. map1.put("carrierId", map1.get("value"));
  1776. list.add(map1);
  1777. dispatchToCarrier(list);
  1778. }
  1779. }
  1780. }
  1781. return result;
  1782. }
  1783. /**
  1784. * 展示未匹配承运商的车序号
  1785. * @param mapValue
  1786. * @return
  1787. */
  1788. @Override
  1789. public List<Map<String, Object>> getSteelTruckNoList(Map<String, Object> mapValue) {
  1790. List<Map<String, Object>> resultList = amsSaleOrderMapper.getSteelTruckNoList(mapValue);
  1791. return resultList;
  1792. }
  1793. /**
  1794. * 展示车序号的详情
  1795. * @param saleOrderMaterialId
  1796. * @return
  1797. */
  1798. @Override
  1799. public List<Map<String, Object>> getTruckNoMaterial(BigDecimal saleOrderMaterialId) {
  1800. List<Map<String,Object>> mapList = amsSaleOrderMapper.getTruckNoMaterialAndCarrier(saleOrderMaterialId);
  1801. for (Map<String,Object> map : mapList) {
  1802. BigDecimal placeId = (BigDecimal) map.get("placeId");
  1803. if (placeId != null) {
  1804. List<Map<String, Object>> carrierAndPriceList = getCarrierByPlace(placeId);
  1805. map.put("carrierAndPriceList", carrierAndPriceList);
  1806. }
  1807. }
  1808. return mapList;
  1809. }
  1810. /**
  1811. * 展示已分配承运商但未派车的车序号
  1812. * @param mapValue
  1813. * @return
  1814. */
  1815. @Override
  1816. public List<Map<String, Object>> getNoCarTruckNoList(Map<String, Object> mapValue) {
  1817. List<Map<String, Object>> resultList = amsSaleOrderMapper.getCarrierTruckNoList(mapValue);
  1818. return resultList;
  1819. }
  1820. /**
  1821. * 展示已派车的车序号
  1822. * @param mapValue
  1823. * @return
  1824. */
  1825. @Override
  1826. public List<Map<String, Object>> getHaveCarTruckNoList(Map<String, Object> mapValue) {
  1827. List<Map<String, Object>> resultList = amsSaleOrderMapper.getHaveCarTruckNoList(mapValue);
  1828. return resultList;
  1829. }
  1830. /**
  1831. * 修改销售订单中的物资
  1832. * @param mapValue
  1833. * @return
  1834. */
  1835. @Transactional(rollbackFor = Exception.class)
  1836. @Override
  1837. public int updateAllMaterialInSale(Map<String, Object> mapValue) {
  1838. int result = 0;
  1839. // 得到销售订单主键
  1840. BigDecimal saleOrderId = DataChange.dataToBigDecimal(mapValue.get("saleOrderId"));
  1841. BigDecimal saleOrderMaterialId = DataChange.dataToBigDecimal(mapValue.get("saleOrderMaterialId"));
  1842. BigDecimal orderId = DataChange.dataToBigDecimal(mapValue.get("orderId"));
  1843. // 将车辆改为不可作业状态
  1844. OmstruckOrder omstruckOrder = new OmstruckOrder();
  1845. omstruckOrder.setOrderId(orderId);
  1846. omstruckOrder.setCanWork(new BigDecimal(1));
  1847. omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  1848. //插入日志
  1849. saleLogUtil.logOrder(orderId,"修改销售订单中的物资:改为不可作业",mapValue,SaleLogUtil.UPDATE);
  1850. // 得到运单中的物资
  1851. List<Map<String, Object>> oldList = omstruckOrderMaterialMapper.getMaterialList(orderId);
  1852. Map<String, Object> toTmsMap = new HashMap<>();
  1853. Map<String, Object> truckNoMap = new HashMap<>();
  1854. truckNoMap.put("saleOrderMaterialId",saleOrderMaterialId);
  1855. toTmsMap.put("orderId", orderId);
  1856. toTmsMap.put("oldMaterialMapList", oldList);
  1857. // 得到所有的物资
  1858. List<Map<String, Object>> mapList = (List<Map<String, Object>>) mapValue.get("mapList");
  1859. /*
  1860. 删除三个物资表数据
  1861. */
  1862. List<AmsSaleTrucknoMaterial> amsSaleTrucknoMaterials = amsSaleTrucknoMaterialMapper.selectByParameters(truckNoMap);
  1863. for (AmsSaleTrucknoMaterial amsSaleTrucknoMaterial : amsSaleTrucknoMaterials) {
  1864. // 销售订单物资子表
  1865. amsSaleMaterialMapper.deleteByPrimaryKey(amsSaleTrucknoMaterial.getMaterialId());
  1866. // 车序号子表
  1867. amsSaleTrucknoMaterialMapper.deleteByPrimaryKey(amsSaleTrucknoMaterial.getTrucknoMaterialId());
  1868. }
  1869. // 运输订单物资子表
  1870. List<OmstruckOrderMaterial> omstruckOrderMaterials = omstruckOrderMaterialMapper.selectByParameters(toTmsMap);
  1871. for (OmstruckOrderMaterial omstruckOrderMaterial : omstruckOrderMaterials) {
  1872. omstruckOrderMaterialMapper.deleteByPrimaryKey(omstruckOrderMaterial.getOrderMaterialId());
  1873. }
  1874. /*
  1875. 重新新增三个表
  1876. */
  1877. for (Map<String, Object> map : mapList) {
  1878. Object saleMaterialId = map.get("saleMaterialId");
  1879. BigDecimal materialId = DataChange.dataToBigDecimal(map.get("materialId"));
  1880. BigDecimal materialNumber = DataChange.dataToBigDecimal(map.get("orderPlanWeight"));
  1881. Object trucknoMaterialId = map.get("trucknoMaterialId");
  1882. BigDecimal isPoundSale = DataChange.dataToBigDecimal(map.get("isPound"));
  1883. Object materialWeight = map.get("materialWeight");
  1884. Object steelMeter = map.get("meterNumber");
  1885. Object easId = map.get("easId");
  1886. Object warehouse = map.get("warehouse");
  1887. // 销售订单分录表
  1888. AmsSaleMaterial amsSaleMaterial = new AmsSaleMaterial();
  1889. // 车序号子表
  1890. AmsSaleTrucknoMaterial amsSaleTrucknoMaterial = new AmsSaleTrucknoMaterial();
  1891. // 运输订单子表
  1892. OmstruckOrderMaterial omstruckOrderMaterial = new OmstruckOrderMaterial();
  1893. // if (saleMaterialId != null) {
  1894. // amsSaleMaterial.setSaleMaterialId(DataChange.dataToBigDecimal(saleMaterialId));
  1895. // amsSaleTrucknoMaterial.setTrucknoMaterialId(DataChange.dataToBigDecimal(trucknoMaterialId));
  1896. // }
  1897. // if (saleMaterialId == null){
  1898. amsSaleMaterial.setSaleMaterialId(amsSaleMaterialMapper.selectMaxId());
  1899. amsSaleTrucknoMaterial.setTrucknoMaterialId(amsSaleTrucknoMaterialMapper.selectMaxId());
  1900. // }
  1901. if (easId != null) {
  1902. amsSaleMaterial.setEasPrimaryId(easId.toString());
  1903. }
  1904. if (warehouse != null) {
  1905. amsSaleMaterial.setSaleWarehouse(warehouse.toString());
  1906. }
  1907. if (steelMeter != null) {
  1908. amsSaleMaterial.setSteelMeter(DataChange.dataToBigDecimal(steelMeter));
  1909. }
  1910. if (materialWeight != null) {
  1911. amsSaleMaterial.setMaterialWeight(DataChange.dataToBigDecimal(materialWeight));
  1912. omstruckOrderMaterial.setOrderMaterialWeight(DataChange.dataToBigDecimal(materialWeight));
  1913. }
  1914. amsSaleMaterial.setSaleOrderId(saleOrderId);
  1915. amsSaleMaterial.setIsPoundSale(isPoundSale);
  1916. amsSaleMaterial.setMaterialId(materialId);
  1917. amsSaleMaterial.setDeleted(new BigDecimal(0));
  1918. amsSaleMaterial.setMaterialNumber(materialNumber);
  1919. amsSaleMaterial.setUpdateTime(new Date());
  1920. result += amsSaleMaterialMapper.insertSelective(amsSaleMaterial);
  1921. // 车序号子表
  1922. amsSaleTrucknoMaterial.setSaleOrderMaterialId(saleOrderMaterialId);
  1923. amsSaleTrucknoMaterial.setMaterialId(amsSaleMaterial.getSaleMaterialId());
  1924. amsSaleTrucknoMaterial.setSaleOrderMaterialNumber(materialNumber);
  1925. amsSaleTrucknoMaterial.setUpdateTime(new Date());
  1926. result += amsSaleTrucknoMaterialMapper.insertSelective(amsSaleTrucknoMaterial);
  1927. // 运输订单子表
  1928. omstruckOrderMaterial.setOrderMaterialId(omstruckOrderMaterialMapper.selectMaxId());
  1929. omstruckOrderMaterial.setOrderId(orderId);
  1930. omstruckOrderMaterial.setMaterialId(materialId);
  1931. omstruckOrderMaterial.setOrderMaterialNumber(materialNumber);
  1932. result += omstruckOrderMaterialMapper.insertSelective(omstruckOrderMaterial);
  1933. }
  1934. // 得到运单中的物资
  1935. List<Map<String, Object>> newList = omstruckOrderMaterialMapper.getMaterialList(orderId);
  1936. toTmsMap.put("newMaterialMapList", newList);
  1937. // 修改实绩结果
  1938. Map<String, Object> updateResult = tmsTruckFeign.update(toTmsMap);
  1939. System.out.println(updateResult);
  1940. return result;
  1941. }
  1942. /**
  1943. * 副产品订单
  1944. * @param map
  1945. * @return
  1946. */
  1947. @Override
  1948. public List<Map<String, Object>> getFuSaleOrderList(Map<String, Object> map) {
  1949. List<Map<String, Object>> resultList = amsSaleOrderMapper.getFuSaleOrderList(map);
  1950. return resultList;
  1951. }
  1952. /**
  1953. * 同步关闭金蝶销售订单
  1954. * @param mapValue
  1955. * @return
  1956. */
  1957. @Override
  1958. public int deleteSaleOrderSame(Map<String, Object> mapValue) {
  1959. int result = 0;
  1960. BigDecimal saleOrderId = DataChange.dataToBigDecimal(mapValue.get("saleOrderId"));
  1961. String reason = (String) mapValue.get("reason");
  1962. String number = (String) mapValue.get("number");
  1963. Map<String,Object> head = new HashMap<>();
  1964. Map<String,Object> input = new HashMap<>();
  1965. // 销售订单号
  1966. input.put("number",number);
  1967. Map<String, Object> totalMap = easDeleteUtil.getTotalMap();
  1968. totalMap.put("input",input);
  1969. // 调用金蝶关闭接口
  1970. String json = JSONUtils.toJSONString(totalMap);
  1971. System.out.println(json);
  1972. Map<String,Object> resultMap = joinFeign.deleteSaleOrderToEas(totalMap);
  1973. try {
  1974. newFileTool.newFile("deleteSaleOrderToEas:"+totalMap,"金蝶通讯报文");
  1975. }catch (Exception e){
  1976. e.printStackTrace();
  1977. }
  1978. System.out.println(resultMap);
  1979. AmsSaleOrder amsSaleOrder = new AmsSaleOrder();
  1980. amsSaleOrder.setSaleOrderId(saleOrderId);
  1981. amsSaleOrder.setDeleted(new BigDecimal(2));
  1982. amsSaleOrder.setInsertUpdateRemark(reason);
  1983. result += amsSaleOrderMapper.closeOrderNotIn(saleOrderId);
  1984. result += amsSaleOrderMapper.updateByPrimaryKeySelective(amsSaleOrder);
  1985. return result;
  1986. }
  1987. /**
  1988. * 展示反审批的钢材订单
  1989. * @param mapValue
  1990. * @return
  1991. */
  1992. @Override
  1993. public List<Map<String, Object>> getSteelOrderDeletedList(Map<String, Object> mapValue) {
  1994. List<Map<String, Object>> mapList = amsSaleOrderMapper.getSteelOrderDeletedList(mapValue);
  1995. return mapList;
  1996. }
  1997. /**
  1998. * 展示所有状态销售订单列表
  1999. * @param mapValue
  2000. * @return
  2001. */
  2002. @Override
  2003. public List<Map<String, Object>> getAllSteelSaleOrderList(Map<String, Object> mapValue) {
  2004. return amsSaleOrderMapper.getAllSteelSaleOrderList(mapValue);
  2005. }
  2006. /**
  2007. * 修改厂内未装货车辆的运单车牌号
  2008. * @param mapValue
  2009. * @return
  2010. */
  2011. @Override
  2012. public Map<String, Object> updateCapacityNumberInFactory(Map<String, Object> mapValue) throws Exception {
  2013. Object lineSequence = mapValue.get("lineSequence");
  2014. int result = 0;
  2015. if (mapValue.get("orderId") == null) {
  2016. throw new Exception("还未派车,不允许修改车牌号");
  2017. }
  2018. //判断该车序号对应的分录是否全部关闭
  2019. if(mapValue.get("saleOrderMaterialId") != null && DataChange.dataToBigDecimal(mapValue.get("capacityId")).compareTo(new BigDecimal(35128)) != 0) {
  2020. Integer flCount = amsSaleMaterialMapper.getAbleFlcount(DataChange.dataToBigDecimal(mapValue.get("saleOrderMaterialId")));
  2021. if(flCount == 0) {
  2022. throw new Exception("该运单下所有分录被关闭,无法派车");
  2023. }
  2024. }
  2025. //查询输入进来的车牌号是否与原有车牌号一致,如果一致则退出
  2026. BigDecimal oldCapacityId = omstruckOrderMapper.getOldCapacityId(DataChange.dataToBigDecimal(mapValue.get("orderId")));
  2027. String oldCapacityNumber = omstruckOrderMapper.getOldCapacityNumber(oldCapacityId);
  2028. if(oldCapacityId.compareTo(DataChange.dataToBigDecimal(mapValue.get("capacityId"))) == 0) {
  2029. mapValue.put("result",1);
  2030. pushCarNumberToEas(mapValue);
  2031. return mapValue;
  2032. }
  2033. //校验该车是否存在手机号
  2034. String tel=omstruckOrderMapper.getTelByCapacityId(DataChange.dataToBigDecimal(mapValue.get("capacityId")));
  2035. String driverTel = (String) mapValue.get("driverTel");//填写的手机号
  2036. if(tel==null || "".equals(tel)){
  2037. throw new Exception("该车没有电话号码,无法派车!请去资源管理-运力维护该车的电话号码!");
  2038. }
  2039. Integer isCheckGps = amsSaleOrderMapper.getDispachSwitch();
  2040. String capacityNo = (String) mapValue.get("capacityNo");
  2041. //得到此次是否校验GPS
  2042. boolean onceCheck = true;
  2043. //查询是否自提
  2044. String selfMention = "否";
  2045. try{
  2046. selfMention = amsSaleOrderMapper.findSelfMention(DataChange.dataToBigDecimal(mapValue.get("saleOrderMaterialId")));
  2047. onceCheck = (boolean) mapValue.get("isCheckGPS");
  2048. }catch (Exception e){
  2049. //取值失败不处理,取默认值
  2050. }
  2051. //查询车牌号是否是黑名单
  2052. if(amsSaleOrderMapper.isBlackList(capacityNo)>0){
  2053. throw new Exception("该车在黑名单中,无法派车!请联系销售公司!");
  2054. }
  2055. //非自提,单次校验且全局校验,且车辆不允许无GPS
  2056. int isGPS=amsSaleOrderMapper.isGPS(capacityNo);
  2057. if((selfMention==null || selfMention.equals("否")) && onceCheck && (isCheckGps!=null && isCheckGps==0) && isGPS <= 0){
  2058. Map<String,Object> data=null;
  2059. try{
  2060. data= (Map<String,Object>)otmsFeign.getCurrentLocation(capacityNo).getData();
  2061. }catch (Exception e){
  2062. throw new Exception("该车没有GPS定位信息,请联系销售公司物流部,申请是否可以派车。");
  2063. }
  2064. if(data==null || !"1001".equals(""+data.get("status"))){
  2065. throw new Exception("该车没有GPS定位信息,请联系销售公司物流部,申请是否可以派车。");
  2066. }
  2067. }
  2068. pushCarNumberToEas(mapValue);
  2069. //try{
  2070. // //不为空且为新手机号,则修改电话号码
  2071. // if(driverTel!=null && !"".equals(driverTel) && !driverTel.equals(tel)){
  2072. // Map<String,Object> map1=new HashMap<>();
  2073. // map1.put("capacityNumber",capacityNo);
  2074. // map1.put("capacityTel",driverTel);
  2075. // //在得到司机电话后给运力添加电话号码(通过车牌号)
  2076. // rmsFeign.updateCapacity(map1);
  2077. // mapValue.put("capacityTel",driverTel);
  2078. // }else{
  2079. // mapValue.put("capacityTel",tel);
  2080. // }
  2081. //}catch (Exception e){
  2082. // e.printStackTrace();
  2083. //}
  2084. saleLogUtil.logOrder(DataChange.dataToBigDecimal(mapValue.get("orderId")),"修改车牌号,当前车牌号为:" + capacityNo + "上一个车牌号为:" + oldCapacityNumber,mapValue,SaleLogUtil.UPDATE);
  2085. if (lineSequence == null || "0".equals(lineSequence.toString()) || "1".equals(lineSequence.toString()) || "2".equals(lineSequence.toString())) {
  2086. String capacityids="";
  2087. Integer capacityid1= (Integer) mapValue.get("capacityIds");
  2088. Integer capacityid2= (Integer) mapValue.get("capacityId");
  2089. if (capacityid1!=null && !("".equals(capacityid1))){
  2090. capacityids=capacityid1+","+capacityid2;
  2091. }
  2092. mapValue.put("capacityids",capacityids);
  2093. //这是修改车牌号
  2094. //取消是新车牌号,那么不删除排队信息,不删除实绩信息,将运单状态变为7
  2095. if (DataChange.dataToBigDecimal(mapValue.get("capacityId")).compareTo(new BigDecimal(35128)) != 0) {
  2096. //根据订单id查询车牌号改动记录
  2097. String oldCpacityIds = omstruckOrderMapper.getOrderCapacityHistory(DataChange.dataToBigDecimal(mapValue.get("orderId")));
  2098. BigDecimal oldOldCapacityId = null;
  2099. if(oldCpacityIds != null) {
  2100. oldOldCapacityId = DataChange.dataToBigDecimal(oldCpacityIds.split(",")[0]);
  2101. }
  2102. //如果旧车号是取消,且取消的前一个车与该车相等,那么就将状态还原
  2103. if (oldOldCapacityId != null && oldCapacityId != null && oldCapacityId.compareTo(new BigDecimal(35128)) == 0 && DataChange.dataToBigDecimal(mapValue.get("capacityId")).compareTo(oldOldCapacityId) == 0 ) {
  2104. //判断该订单下有没有子实绩
  2105. BigDecimal resultId = amsSaleOrderMaterialMapper.selectEnFactory(DataChange.dataToBigDecimal(mapValue.get("orderId")));
  2106. if(resultId == null) {
  2107. OmstruckOrder omstruckOrder = new OmstruckOrder();
  2108. omstruckOrder.setOrderId(DataChange.dataToBigDecimal(mapValue.get("orderId")));
  2109. omstruckOrder.setOrderStatus(new BigDecimal(4));
  2110. omstruckOrder.setOrderLineSequence(new BigDecimal(0));
  2111. omstruckOrder.setInsertUpdateRemark("将取消改回来原来的车状态不变!");
  2112. if(tel != null && !"".equals(tel)){
  2113. omstruckOrder.setDriverTel(tel);
  2114. }
  2115. /*omstruckOrder.set*/
  2116. result += omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  2117. }else{
  2118. OmstruckOrder omstruckOrder = new OmstruckOrder();
  2119. omstruckOrder.setOrderId(DataChange.dataToBigDecimal(mapValue.get("orderId")));
  2120. omstruckOrder.setOrderStatus(new BigDecimal(5));
  2121. if(tel != null && !"".equals(tel)){
  2122. omstruckOrder.setDriverTel(tel);
  2123. }
  2124. omstruckOrder.setInsertUpdateRemark("将取消改回来原来的车状态不变!");
  2125. /*omstruckOrder.set*/
  2126. result += omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  2127. }
  2128. }else{
  2129. //将排队信息删掉
  2130. Map<String, Object> isSpellingMap = omstruckOrderMapper.getSteelIsSpelling(DataChange.dataToBigDecimal(mapValue.get("orderId")));
  2131. if(isSpellingMap != null && isSpellingMap.get("listId") != null){
  2132. int isSpelling = DataChange.dataToBigDecimal(isSpellingMap.get("isSpelling")).intValue();
  2133. if(isSpelling == 1 ){
  2134. result += omstruckOrderMapper.deleteSpellingList(isSpellingMap.get("listId"));
  2135. }else{
  2136. result += omstruckOrderMapper.deleteQueueList(isSpellingMap.get("listId"));
  2137. }
  2138. }
  2139. //若是接单之后还需要删除实绩且将状态变为4
  2140. //查询运输订单的状态和总实绩ID
  2141. Map<String, Object> orderMesMap = amsSaleOrderMapper.getOrderMes(mapValue);
  2142. BigDecimal resultTotalId = DataChange.dataToBigDecimal(orderMesMap.get("resultTotalId"));
  2143. //删除排队实绩
  2144. if (resultTotalId !=null && !("".equals(resultTotalId))){
  2145. omstruckOrderMapper.deleteQueuingPerformance(resultTotalId);
  2146. }
  2147. OmstruckOrder omstruckOrder = new OmstruckOrder();
  2148. omstruckOrder.setOrderId(DataChange.dataToBigDecimal(mapValue.get("orderId")));
  2149. // 设置新的运输订单号
  2150. omstruckOrder.setOrderNumber(DataChange.generateEightDigitsNumber("WYSDD", omstruckOrderMapper.selectMaxId().intValue()));
  2151. omstruckOrder.setOrderStatus(new BigDecimal(4));
  2152. omstruckOrder.setOrderLineSequence(new BigDecimal(0));
  2153. if(tel != null && !"".equals(tel)){
  2154. omstruckOrder.setDriverTel(tel);
  2155. }
  2156. /*omstruckOrder.set*/
  2157. result += omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  2158. //插入日志
  2159. result += omstruckOrderMapper.deleteEnResult(resultTotalId);
  2160. result += omstruckOrderMapper.deleteWeightResult(resultTotalId);
  2161. result += omstruckOrderMapper.deleteLoadResult(resultTotalId);
  2162. result += omstruckOrderMapper.deleteLeaveResult(resultTotalId);
  2163. }
  2164. }else{
  2165. OmstruckOrder omstruckOrder = new OmstruckOrder();
  2166. omstruckOrder.setOrderId(DataChange.dataToBigDecimal(mapValue.get("orderId")));
  2167. if(tel != null && !"".equals(tel)){
  2168. omstruckOrder.setDriverTel(tel);
  2169. }
  2170. omstruckOrder.setOrderStatus(new BigDecimal(7));
  2171. omstruckOrder.setInsertUpdateRemark("取消车牌号,保留实绩将状态变为7");
  2172. result += omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  2173. }
  2174. result += amsSaleOrderMapper.updateCapacityNumberInFactory(mapValue);
  2175. }
  2176. mapValue.put("result",result);
  2177. return mapValue;
  2178. }
  2179. @Override
  2180. public int updateConsigneeTel(Map<String, Object> mapValue) {
  2181. String saleOrderNo= (String) mapValue.get("saleOrderNo");
  2182. Integer saleOrderMaterialId= (Integer) mapValue.get("saleOrderMaterialId");
  2183. String consigneeTel= (String) mapValue.get("consigneeTel");
  2184. int result = 0;
  2185. if (saleOrderNo!=null&&!("".equals(saleOrderNo)) && saleOrderMaterialId!=null && !("".equals(saleOrderMaterialId))){
  2186. BigDecimal id = DataChange.dataToBigDecimal(saleOrderMaterialId);
  2187. if (id!=null&&!("".equals(id))){
  2188. result += amsSaleOrderMapper.updateForTel(id,consigneeTel);
  2189. }
  2190. }
  2191. return result;
  2192. }
  2193. @Override
  2194. public List<Map<String, Object>> getSaleMaterialId(BigDecimal saleOrderMaterialId) {
  2195. return amsSaleOrderMapper.getSaleMaterialId(saleOrderMaterialId);
  2196. }
  2197. /**
  2198. * 展示下发给承运商的车序号和物资
  2199. * @param map
  2200. * @return
  2201. */
  2202. @Override
  2203. public List<Map<String, Object>> getCarrierTruckNoAndMaterialList(Map<String,Object> map) {
  2204. Object carrierSsoId = map.get("carrierSsoId");
  2205. if (carrierSsoId != null && ("".equals(carrierSsoId)) || "null".equals(carrierSsoId) || "undefined".equals(carrierSsoId)) {
  2206. map.replace("carrierSsoId",null);
  2207. }
  2208. List<Map<String,Object>> mapList = amsSaleOrderMapper.getTruckNoAndMaterial(map);
  2209. for (Map<String,Object> mapValue : mapList) {
  2210. BigDecimal placeId = (BigDecimal) mapValue.get("placeId");
  2211. if (placeId != null) {
  2212. List<Map<String, Object>> carrierAndPriceList = getCarrierByPlace(placeId);
  2213. mapValue.put("carrierAndPriceList", carrierAndPriceList);
  2214. }
  2215. }
  2216. return mapList;
  2217. }
  2218. @Override
  2219. public int updateAMSDeleted(BigDecimal closeWlEntryId) {
  2220. return amsSaleOrderMapper.updateAMSDeleted(closeWlEntryId);
  2221. }
  2222. /**
  2223. * 同步关闭金蝶物资分录
  2224. * @param mapValue
  2225. * @return
  2226. */
  2227. @Override
  2228. @Transactional
  2229. public int closeSteelMaterialId(Map<String, Object> mapValue) {
  2230. int result = 0;
  2231. Object orderId = mapValue.get("orderId");
  2232. Integer orderStatus = (Integer) mapValue.get("orderStatus");
  2233. BigDecimal saleOrderMaterialId = DataChange.dataToBigDecimal(mapValue.get("saleOrderMaterialId"));
  2234. List<Map<String, Object>> loadIdList = amsSaleMaterialMapper.findLoadIdList(saleOrderMaterialId);
  2235. List<Map<String, Object>> weightIdList = amsSaleMaterialMapper.findWeightIdList(saleOrderMaterialId);
  2236. String reason = (String) mapValue.get("reason");
  2237. BigDecimal saleMaterialId = DataChange.dataToBigDecimal(mapValue.get("saleMaterialId"));
  2238. // 如果还未派车
  2239. if (orderId == null) {
  2240. // 订单子表设为关闭状态
  2241. AmsSaleMaterial amsSaleMaterial = new AmsSaleMaterial();
  2242. amsSaleMaterial.setSaleMaterialId(saleMaterialId);
  2243. amsSaleMaterial.setDeleted(new BigDecimal(0));
  2244. amsSaleMaterial.setInsertUpdateRemark(reason);
  2245. result += amsSaleMaterialMapper.updateByPrimaryKeySelective(amsSaleMaterial);
  2246. return result;
  2247. }
  2248. orderStatus = omstruckOrderMapper.getOrderStatus(DataChange.dataToBigDecimal(orderId));
  2249. // 订单子表设为关闭状态
  2250. AmsSaleMaterial amsSaleMaterial = new AmsSaleMaterial();
  2251. amsSaleMaterial.setSaleMaterialId(saleMaterialId);
  2252. amsSaleMaterial.setDeleted(new BigDecimal(0));
  2253. amsSaleMaterial.setInsertUpdateRemark(reason);
  2254. // 已派车
  2255. if ((loadIdList == null || loadIdList.size() == 0) && orderStatus == 5) {
  2256. return result;
  2257. }
  2258. //判断该分录对应净重有没有出来
  2259. int netWeightCount = amsSaleMaterialMapper.getSaleMaterialWeight(mapValue);
  2260. //判断关闭分录是否为最后一拼
  2261. int asmMaterialCount = amsSaleMaterialMapper.getSaleMaterialDelete(saleOrderMaterialId);
  2262. if (asmMaterialCount > 1 && orderStatus == 5 && netWeightCount == 0) {
  2263. // 删除实绩表
  2264. Map<String, Object> loadMap = loadIdList.get(0);
  2265. Map<String, Object> weightMap = weightIdList.get(0);
  2266. BigDecimal loadId = (BigDecimal) loadMap.get("loadId");
  2267. BigDecimal weightId = (BigDecimal) weightMap.get("weightId");
  2268. int i = amsSaleMaterialMapper.deleteWeightResult(weightId);
  2269. if(i != 0) {
  2270. result += amsSaleMaterialMapper.deleteLoadResult(loadId);
  2271. result += amsSaleMaterialMapper.deleteWmspOutResult(mapValue);
  2272. }
  2273. }else if(asmMaterialCount <= 1 && netWeightCount == 0){
  2274. //关闭运输订单
  2275. OmstruckOrder omstruckOrder = new OmstruckOrder();
  2276. omstruckOrder.setOrderId(DataChange.dataToBigDecimal(orderId));
  2277. //如果是单拼或者只剩一条分录没有关闭了则将状态设为7
  2278. omstruckOrder.setOrderStatus(new BigDecimal(7));
  2279. omstruckOrder.setUpdateTime(new Date());
  2280. omstruckOrder.setInsertUpdateRemark("关闭分录,同步关闭运输订单");
  2281. result += omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  2282. //插入日志
  2283. saleLogUtil.logOrder(omstruckOrder.getOrderId(),"关闭分录,同步关闭运输订单",mapValue,SaleLogUtil.UPDATE);
  2284. }
  2285. result += amsSaleMaterialMapper.updateByPrimaryKeySelective(amsSaleMaterial);
  2286. if(netWeightCount == 0) {
  2287. result += amsSaleMaterialMapper.updateOrderMaterialToClose(mapValue);
  2288. }
  2289. return result;
  2290. }
  2291. /**
  2292. * 展示已审核化产焦炭销售订单列表
  2293. * @param mapValue
  2294. * @return
  2295. */
  2296. @Override
  2297. public List<Map<String, Object>> getSaleCokeOrder(Map<String, Object> mapValue) {
  2298. List<Map<String, Object>> resultList = amsSaleOrderMapper.getSaleCokeOrder(mapValue);
  2299. return resultList;
  2300. }
  2301. /**
  2302. * 反关闭金蝶单个分录
  2303. * @param saleMaterialId
  2304. * @return
  2305. */
  2306. @Override
  2307. public int adverseCloseSaleMaterial(BigDecimal saleMaterialId) {
  2308. Map<String,Object> head = new HashMap<>();
  2309. Map<String,Object> input = new HashMap<>();
  2310. // 0:代表不关闭整单
  2311. String wholeOrder = "0";
  2312. // unClose : 代表反关闭
  2313. String status = "unClose";
  2314. AmsSaleMaterial amsSaleMaterial = amsSaleMaterialMapper.selectByPrimaryKey(saleMaterialId);
  2315. int result = amsSaleMaterialMapper.adverseCloseSaleMaterial(saleMaterialId);
  2316. AmsSaleOrder amsSaleOrder = amsSaleOrderMapper.selectByPrimaryKey(amsSaleMaterial.getSaleOrderId());
  2317. // 根据分录id查询运单id,物资id,总实绩id
  2318. Map<String,Object> saleMaterialMap = amsSaleOrderMapper.getSaleMaterialMessage(saleMaterialId);
  2319. BigDecimal orderId = (BigDecimal) saleMaterialMap.get("orderId");
  2320. BigDecimal orderStatus = (BigDecimal) saleMaterialMap.get("orderStatus");
  2321. //查询订单字表条数
  2322. int orderMaterialNum = omstruckOrderMapper.getOrderMaterialNum(orderId);
  2323. //查询计量实绩条数
  2324. int weightResultNum = omstruckOrderMapper.getWeightResultNum(orderId);
  2325. if (orderId != null && orderStatus.intValue() == 5 && orderMaterialNum != weightResultNum) {
  2326. BigDecimal resultTotalId = (BigDecimal) saleMaterialMap.get("resultTotalId");
  2327. BigDecimal materialId = (BigDecimal) saleMaterialMap.get("materialId");
  2328. // 根据总实绩id查询订单中的最大路段顺序号
  2329. // 得到皮重顺序号
  2330. int tareNum = (weightResultNum + 1) * 3 - 1;
  2331. // 得到装货顺序号
  2332. int loadNum = (weightResultNum + 1) * 3;
  2333. // 得到毛重顺序号
  2334. int grossNum = (weightResultNum + 1) * 3 + 1;
  2335. // 装货实绩
  2336. TmstruckLoadResult tmstruckLoadResult = new TmstruckLoadResult();
  2337. TmstruckWeightResult tmstruckWeightResult = new TmstruckWeightResult();
  2338. tmstruckLoadResult.setResultId(tmstruckLoadResultMapper.selectMaxId());
  2339. tmstruckLoadResult.setResultTotalId(resultTotalId);
  2340. tmstruckLoadResult.setSegmentSqe(new BigDecimal(loadNum));
  2341. result += tmstruckLoadResultMapper.insertSelective(tmstruckLoadResult);
  2342. // 计量实绩
  2343. tmstruckWeightResult.setWeightTaskResultId(tmstruckWeightResultMapper.selectMaxId());
  2344. tmstruckWeightResult.setResultTotalId(resultTotalId);
  2345. tmstruckWeightResult.setResultTarePlaceId(new BigDecimal(10));
  2346. tmstruckWeightResult.setResultGrossPlaceId(new BigDecimal(2));
  2347. tmstruckWeightResult.setGrossSegmentSqe(new BigDecimal(grossNum));
  2348. tmstruckWeightResult.setTareSegmentSqe(new BigDecimal(tareNum));
  2349. result += tmstruckWeightResultMapper.insertSelective(tmstruckWeightResult);
  2350. // 出库子表
  2351. BigDecimal outBoundId = (BigDecimal) saleMaterialMap.get("outBoundId");
  2352. BigDecimal materialNumber = (BigDecimal) saleMaterialMap.get("materialNumber");
  2353. if (outBoundId != null) {
  2354. BigDecimal resultMaterialId = wmspOutboundResultMaterialMapper.getSeqNumber("seq__WMSP_OUTBOUND_RESUL_TMATRIAL");
  2355. WmspOutboundResultMaterial wmspOutboundResultMaterial = new WmspOutboundResultMaterial();
  2356. wmspOutboundResultMaterial.setResultMaterialId(resultMaterialId);
  2357. wmspOutboundResultMaterial.setOutboundResultId(outBoundId);
  2358. wmspOutboundResultMaterial.setMaterialId(materialId);
  2359. wmspOutboundResultMaterial.setMaterialNumber(materialNumber);
  2360. wmspOutboundResultMaterial.setInsertTime(new Date());
  2361. wmspOutboundResultMaterial.setInsertUsername("admin");
  2362. wmspOutboundResultMaterial.setStatus(new BigDecimal(1));
  2363. result += wmspOutboundResultMaterialMapper.insertSelective(wmspOutboundResultMaterial);
  2364. }
  2365. }
  2366. //去掉取消装货
  2367. result += omstruckOrderMaterialMapper.updateOmsMaterial(saleMaterialMap);
  2368. if (orderId != null && orderStatus.intValue() == 7) {
  2369. //如果订单被关闭,那么还原
  2370. //判断下面有没有实绩
  2371. int resultCount = omstruckOrderMapper.getResultCount(orderId);
  2372. OmstruckOrder omstruckOrder = new OmstruckOrder();
  2373. if (resultCount == 0) {
  2374. omstruckOrder.setOrderId(orderId);
  2375. omstruckOrder.setOrderStatus(new BigDecimal(4));
  2376. omstruckOrder.setInsertUpdateRemark("反关闭分录,运单同步开启");
  2377. omstruckOrder.setUpdateTime(new Date());
  2378. omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  2379. }else{
  2380. omstruckOrder.setOrderId(orderId);
  2381. omstruckOrder.setOrderStatus(new BigDecimal(5));
  2382. omstruckOrder.setInsertUpdateRemark("反关闭分录,运单同步开启");
  2383. omstruckOrder.setUpdateTime(new Date());
  2384. omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  2385. }
  2386. //插入日志
  2387. saleLogUtil.logOrder(omstruckOrder.getOrderId(),"反关闭分录,运单同步开启",null,SaleLogUtil.UPDATE);
  2388. }
  2389. // 设置反关闭分录id
  2390. head.put("unCloseEntryId",amsSaleMaterial.getEasPrimaryId());
  2391. // 设置是否整单
  2392. head.put("wholeOrder",wholeOrder);
  2393. // 设置销售订单号
  2394. head.put("number",amsSaleOrder.getSaleNumber());
  2395. // 设置状态:unClose,反关闭;close,关闭
  2396. head.put("status",status);
  2397. input.put("head",head);
  2398. // 测试
  2399. Map<String, Object> totalMap = easUtil.getTotalMap();
  2400. // 正式
  2401. // Map<String, Object> totalMap = easDeleteUtil.getTotalMap();
  2402. input.put("head",head);
  2403. totalMap.put("input",input);
  2404. // 调用金蝶关闭接口
  2405. String json = JSONUtils.toJSONString(totalMap);
  2406. System.out.println(json);
  2407. Map<String,Object> resultMap = joinFeign.deleteSaleOrderToEas(totalMap);
  2408. try {
  2409. newFileTool.newFile("deleteSaleOrderToEas:"+totalMap,"金蝶通讯报文");
  2410. }catch (Exception e){
  2411. e.printStackTrace();
  2412. }
  2413. System.out.println(resultMap);
  2414. return result;
  2415. }
  2416. /**
  2417. * 反关闭金蝶整个销售订单
  2418. * @param saleOrderId
  2419. * @return
  2420. */
  2421. @Override
  2422. public int adverseCloseSaleOrder(BigDecimal saleOrderId) {
  2423. Map<String,Object> head = new HashMap<>();
  2424. Map<String,Object> input = new HashMap<>();
  2425. // 0:代表不关闭整单
  2426. String wholeOrder = "1";
  2427. // unClose : 代表反关闭
  2428. String status = "unClose";
  2429. AmsSaleOrder amsSaleOrder = amsSaleOrderMapper.selectByPrimaryKey(saleOrderId);
  2430. amsSaleOrder.setDeleted(new BigDecimal(0));
  2431. // 开启所有的分录
  2432. int result = amsSaleMaterialMapper.openAllSaleMaterial(amsSaleOrder.getSaleOrderId());
  2433. result += amsSaleOrderMapper.updateByPrimaryKeySelective(amsSaleOrder);
  2434. // 设置是否整单
  2435. head.put("wholeOrder",wholeOrder);
  2436. // 设置销售订单号
  2437. head.put("number",amsSaleOrder.getSaleNumber());
  2438. // 设置状态:unClose,反关闭;close,关闭
  2439. head.put("status",status);
  2440. input.put("head",head);
  2441. // 测试
  2442. Map<String, Object> totalMap = easUtil.getTotalMap();
  2443. // 正式
  2444. // Map<String, Object> totalMap = easDeleteUtil.getTotalMap();
  2445. input.put("head",head);
  2446. totalMap.put("input",input);
  2447. // 调用金蝶关闭接口
  2448. String json = JSONUtils.toJSONString(totalMap);
  2449. System.out.println(json);
  2450. Map<String,Object> resultMap = joinFeign.deleteSaleOrderToEas(totalMap);
  2451. try {
  2452. newFileTool.newFile("deleteSaleOrderToEas:"+totalMap,"金蝶通讯报文");
  2453. }catch (Exception e){
  2454. e.printStackTrace();
  2455. }
  2456. System.out.println(resultMap);
  2457. return result;
  2458. }
  2459. @Override
  2460. public List<Map<String, Object>> getKucunList(Map<String, Object> map) {
  2461. return amsSaleOrderMapper.getKucunList(map);
  2462. }
  2463. //反关闭
  2464. @Override
  2465. public int reverseCloseOrder(Map<String, Object> map) {
  2466. Integer isOpenEas = (Integer) map.get("isOpenEas");
  2467. String operateName = (String) map.get("operateName");
  2468. int result = 0;
  2469. // 运输订单id
  2470. BigDecimal orderId = DataChange.dataToBigDecimal(map.get("orderId"));
  2471. // 车序号id
  2472. BigDecimal saleOrderMaterialId = DataChange.dataToBigDecimal(map.get("saleOrderMaterialId"));
  2473. Map<String,Object> head = new HashMap<>();
  2474. Map<String,Object> input = new HashMap<>();
  2475. // 0:代表不关闭整单
  2476. String wholeOrder = "0";
  2477. // unClose : 代表反关闭
  2478. String status = "unClose";
  2479. if( orderId != null && orderId.intValue() != 0){
  2480. //根据订单id查询下面的实绩个数
  2481. int resultCount = amsSaleMaterialMapper.getOrderResults(orderId);
  2482. OmstruckOrder omstruckOrder = new OmstruckOrder();
  2483. omstruckOrder.setOrderId(orderId);
  2484. if(resultCount == 0){
  2485. omstruckOrder.setOrderStatus(new BigDecimal(4));
  2486. }else{
  2487. omstruckOrder.setOrderStatus(new BigDecimal(5));
  2488. }
  2489. if(operateName != null){
  2490. omstruckOrder.setOptionerCode(operateName);
  2491. }
  2492. omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  2493. //插入日志
  2494. saleLogUtil.logOrder(omstruckOrder.getOrderId(),"反关闭",null,SaleLogUtil.UPDATE);
  2495. // 根据车序号主键修改子表
  2496. amsSaleMaterialMapper.updateSaleMaterial(saleOrderMaterialId);
  2497. //查询分录ID,修改金蝶
  2498. List<Map<String,Object>> saleMaterialIdList = amsSaleOrderMapper.getSaleMaterialId(saleOrderMaterialId);
  2499. for(Map<String,Object> easMap:saleMaterialIdList){
  2500. // 设置反关闭分录id
  2501. head.put("unCloseEntryId",easMap.get("closeEntryId"));
  2502. // 设置是否整单
  2503. head.put("wholeOrder",wholeOrder);
  2504. // 设置销售订单号
  2505. head.put("number",map.get("saleNumber"));
  2506. // 设置状态:unClose,反关闭;close,关闭
  2507. head.put("status",status);
  2508. input.put("head",head);
  2509. Map<String, Object> totalMap = easUtil.getTotalMap();
  2510. input.put("head",head);
  2511. totalMap.put("input",input);
  2512. // 调用金蝶关闭接口
  2513. String json = JSONUtils.toJSONString(totalMap);
  2514. System.out.println(json);
  2515. Map<String,Object> resultMap = joinFeign.deleteSaleOrderToEas(totalMap);
  2516. try {
  2517. newFileTool.newFile("deleteSaleOrderToEas:"+totalMap,"金蝶通讯报文");
  2518. }catch (Exception e){
  2519. e.printStackTrace();
  2520. }
  2521. System.out.println(resultMap);
  2522. }
  2523. return 0;
  2524. }
  2525. return 1;
  2526. }
  2527. @Override
  2528. public int getSaleOrderStatus(String saleNumber) {
  2529. int result = 0;
  2530. Map<String,Object> input = new HashMap<>();
  2531. // 销售订单号
  2532. input.put("number",saleNumber);
  2533. Map<String, Object> totalMap = easSaleOrderStatusUtil.getTotalMap();
  2534. totalMap.put("input",input);
  2535. // 调用金蝶关闭接口
  2536. String json = JSONUtils.toJSONString(totalMap);
  2537. System.out.println(json);
  2538. Map<String,Object> resultMap = joinFeign.deleteSaleOrderToEas(totalMap);
  2539. try {
  2540. newFileTool.newFile("deleteSaleOrderToEas:"+totalMap,"金蝶通讯报文");
  2541. }catch (Exception e){
  2542. e.printStackTrace();
  2543. }
  2544. System.out.println(resultMap);
  2545. String outPutMap = (String) resultMap.get("output");
  2546. JSONObject jsonObject = JSON.parseObject(outPutMap);
  2547. if(jsonObject != null){
  2548. result = DataChange.dataToBigDecimal(jsonObject.get("NumberStatus")).intValue();
  2549. }
  2550. if(result == 7){
  2551. //如果为7则更新
  2552. amsSaleOrderMapper.updateSaleOrderStatus(saleNumber);
  2553. }
  2554. return result;
  2555. }
  2556. @Override
  2557. public int adverseCloseSaleMaterialByEas(BigDecimal saleMaterialId) {
  2558. AmsSaleMaterial amsSaleMaterial = amsSaleMaterialMapper.selectByPrimaryKey(saleMaterialId);
  2559. int result = amsSaleMaterialMapper.adverseCloseSaleMaterial(saleMaterialId);
  2560. AmsSaleOrder amsSaleOrder = amsSaleOrderMapper.selectByPrimaryKey(amsSaleMaterial.getSaleOrderId());
  2561. // 根据分录id查询运单id,物资id,总实绩id
  2562. Map<String,Object> saleMaterialMap = amsSaleOrderMapper.getSaleMaterialMessage(saleMaterialId);
  2563. BigDecimal orderId = (BigDecimal) saleMaterialMap.get("orderId");
  2564. BigDecimal orderStatus = (BigDecimal) saleMaterialMap.get("orderStatus");
  2565. //查询订单字表条数
  2566. int orderMaterialNum = omstruckOrderMapper.getOrderMaterialNum(orderId);
  2567. //查询计量实绩条数
  2568. int weightResultNum = omstruckOrderMapper.getWeightResultNum(orderId);
  2569. if (orderId != null && orderStatus.intValue() == 5 && orderMaterialNum != weightResultNum) {
  2570. BigDecimal resultTotalId = (BigDecimal) saleMaterialMap.get("resultTotalId");
  2571. BigDecimal materialId = (BigDecimal) saleMaterialMap.get("materialId");
  2572. // 根据总实绩id查询订单中的最大路段顺序号
  2573. // 得到皮重顺序号
  2574. int tareNum = (weightResultNum + 1) * 3 - 1;
  2575. // 得到装货顺序号
  2576. int loadNum = (weightResultNum + 1) * 3;
  2577. // 得到毛重顺序号
  2578. int grossNum = (weightResultNum + 1) * 3 + 1;
  2579. // 装货实绩
  2580. TmstruckLoadResult tmstruckLoadResult = new TmstruckLoadResult();
  2581. TmstruckWeightResult tmstruckWeightResult = new TmstruckWeightResult();
  2582. tmstruckLoadResult.setResultId(tmstruckLoadResultMapper.selectMaxId());
  2583. tmstruckLoadResult.setResultTotalId(resultTotalId);
  2584. tmstruckLoadResult.setSegmentSqe(new BigDecimal(loadNum));
  2585. result += tmstruckLoadResultMapper.insertSelective(tmstruckLoadResult);
  2586. // 计量实绩
  2587. tmstruckWeightResult.setWeightTaskResultId(tmstruckWeightResultMapper.selectMaxId());
  2588. tmstruckWeightResult.setResultTotalId(resultTotalId);
  2589. tmstruckWeightResult.setResultTarePlaceId(new BigDecimal(10));
  2590. tmstruckWeightResult.setResultGrossPlaceId(new BigDecimal(2));
  2591. tmstruckWeightResult.setGrossSegmentSqe(new BigDecimal(grossNum));
  2592. tmstruckWeightResult.setTareSegmentSqe(new BigDecimal(tareNum));
  2593. result += tmstruckWeightResultMapper.insertSelective(tmstruckWeightResult);
  2594. // 出库子表
  2595. BigDecimal outBoundId = (BigDecimal) saleMaterialMap.get("outBoundId");
  2596. BigDecimal materialNumber = (BigDecimal) saleMaterialMap.get("materialNumber");
  2597. if (outBoundId != null) {
  2598. BigDecimal resultMaterialId = wmspOutboundResultMaterialMapper.getSeqNumber("seq__WMSP_OUTBOUND_RESUL_TMATRIAL");
  2599. WmspOutboundResultMaterial wmspOutboundResultMaterial = new WmspOutboundResultMaterial();
  2600. wmspOutboundResultMaterial.setResultMaterialId(resultMaterialId);
  2601. wmspOutboundResultMaterial.setOutboundResultId(outBoundId);
  2602. wmspOutboundResultMaterial.setMaterialId(materialId);
  2603. wmspOutboundResultMaterial.setMaterialNumber(materialNumber);
  2604. wmspOutboundResultMaterial.setInsertTime(new Date());
  2605. wmspOutboundResultMaterial.setInsertUsername("admin");
  2606. wmspOutboundResultMaterial.setStatus(new BigDecimal(1));
  2607. result += wmspOutboundResultMaterialMapper.insertSelective(wmspOutboundResultMaterial);
  2608. }
  2609. }
  2610. //去掉取消装货
  2611. result += omstruckOrderMaterialMapper.updateOmsMaterial(saleMaterialMap);
  2612. if (orderId != null && orderStatus.intValue() == 7) {
  2613. //如果订单被关闭,那么还原
  2614. //判断下面有没有实绩
  2615. int resultCount = omstruckOrderMapper.getResultCount(orderId);
  2616. OmstruckOrder omstruckOrder = new OmstruckOrder();
  2617. if (resultCount == 0) {
  2618. omstruckOrder.setOrderId(orderId);
  2619. omstruckOrder.setOrderStatus(new BigDecimal(4));
  2620. omstruckOrder.setInsertUpdateRemark("反关闭分录,运单同步开启");
  2621. omstruckOrder.setUpdateTime(new Date());
  2622. omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  2623. }else{
  2624. omstruckOrder.setOrderId(orderId);
  2625. omstruckOrder.setOrderStatus(new BigDecimal(5));
  2626. omstruckOrder.setInsertUpdateRemark("反关闭分录,运单同步开启");
  2627. omstruckOrder.setUpdateTime(new Date());
  2628. omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  2629. }
  2630. //插入日志
  2631. saleLogUtil.logOrder(orderId,"反关闭分录,运单同步开启",null,SaleLogUtil.UPDATE);
  2632. }
  2633. return result;
  2634. }
  2635. @Override
  2636. public List<String> getEasPrimaryIds(Map<String, Object> map) {
  2637. System.out.println("获取制单日期------------" + new Date());
  2638. List<String> easPrimaryIds = amsSaleOrderMapper.getEasPrimaryIds(map);
  2639. String easPrimaryList = "";
  2640. for (String easPrimaryId :easPrimaryIds) {
  2641. easPrimaryList = easPrimaryList + '\'' + easPrimaryId + '\'' + ',';
  2642. }
  2643. easPrimaryList = easPrimaryList.substring(0,easPrimaryList.length() - 1);
  2644. ArrayList<String> easPrimaryList1 = new ArrayList<>();
  2645. easPrimaryList1.add(easPrimaryList);
  2646. Map<String,Object> totalMap = easFluMakeDateUtil.getTotalMap();
  2647. Map<String, Object> input = new HashMap<>();
  2648. input.put("defineSqlNumber","defineXSCKTime");
  2649. input.put("defineSqlparams",easPrimaryList1);
  2650. totalMap.put("input",input);
  2651. totalMap.put("outerSystem","DG");
  2652. JSONObject jsonObject = new JSONObject(totalMap);
  2653. System.out.println(jsonObject);
  2654. Map<String,Object> resultMap = joinFeign.deleteSaleOrderToEas(totalMap);
  2655. System.out.println(resultMap);
  2656. try {
  2657. newFileTool.newFile("deleteSaleOrderToEas:"+totalMap,"金蝶通讯报文");
  2658. }catch (Exception e){
  2659. e.printStackTrace();
  2660. }
  2661. System.out.println("返回");
  2662. System.out.println(resultMap);
  2663. String outPut = (String) resultMap.get("output");
  2664. JSONObject outputjson = JSONObject.parseObject(outPut);
  2665. Map<String,Object> outputMap = (Map<String,Object>) outputjson;
  2666. List<Map<String,Object>> rowSetList = (List<Map<String,Object>>) outputMap.get("rowset");
  2667. for (Map<String,Object> rowSet : rowSetList) {
  2668. Map<String, Object> easMap = new HashMap<>();
  2669. System.out.println(rowSet);
  2670. String easprimaryIdMakeDate = (String) rowSet.get("FCREATETIME");
  2671. SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
  2672. Date easprimaryIdMakeDate1 = null;
  2673. try {
  2674. easprimaryIdMakeDate1 = sdf.parse(easprimaryIdMakeDate);
  2675. } catch (ParseException e) {
  2676. e.printStackTrace();
  2677. }
  2678. rowSet.put("easprimaryIdMakeDate",easprimaryIdMakeDate1);
  2679. amsSaleMaterialMapper.updateSaleMaterialMakeDate(rowSet);
  2680. }
  2681. return easPrimaryIds;
  2682. }
  2683. @Override
  2684. @Transactional(rollbackFor = Exception.class)
  2685. public synchronized int addSteelSaleOrderLoading(Map<String, Object> mapValue) throws Exception {
  2686. List<Map<String,Object>> mapList = (List<Map<String, Object>>) mapValue.get("mapList");
  2687. //如果前端传输过来的销售订单id不是空,则改变为已上传
  2688. if (mapValue.get("saleOrderId") != null) {
  2689. //先判断该销售订单有没有被上传,如果传了则不允许重复上传
  2690. if (mapValue.get("saleOrderNo") != null) {
  2691. int count1 = amsSaleOrderMaterialMapper.selectSaleOrdeNoIsUpload(mapValue.get("saleOrderNo").toString());
  2692. if(count1 != 0) {
  2693. return 0;
  2694. }
  2695. amsSaleOrderMapper.updateOldSaleOrderUploadByNo(mapValue.get("saleOrderNo").toString());
  2696. }else{
  2697. int count = amsSaleOrderMaterialMapper.selectSaleOrderIdIsUpload(DataChange.dataToBigDecimal(mapValue.get("saleOrderId")));
  2698. if(count != 0) {
  2699. return 0;
  2700. }
  2701. amsSaleOrderMapper.updateOldSaleOrderUpload(DataChange.dataToBigDecimal(mapValue.get("saleOrderId")));
  2702. }
  2703. }
  2704. // 得到发货单位
  2705. BigDecimal shipperId = DataChange.dataToBigDecimal(mapValue.get("shipperId"));
  2706. // 收货单位
  2707. BigDecimal receiveId = DataChange.dataToBigDecimal(mapValue.get("receiveId"));
  2708. // 是否自提
  2709. String isSelfMention = (String) mapValue.get("isSelfMention");
  2710. // 备注
  2711. String saleRemark = (String) mapValue.get("saleRemark");
  2712. String saleGroupCode = null;
  2713. try {
  2714. saleGroupCode = "钢" + StringUtils.substringBetween(saleRemark,"钢","组") + "组";
  2715. } catch (Exception e) {
  2716. e.printStackTrace();
  2717. }
  2718. // 收款客户
  2719. String saleOrderReceiveCustomer = (String) mapValue.get("saleOrderReceiveCustomer");
  2720. // 业务员
  2721. BigDecimal salerId = DataChange.dataToBigDecimal(mapValue.get("salerId"));
  2722. BigDecimal saleOrderId = amsSaleOrderMapper.selectMaxId();
  2723. int result = 0;
  2724. // 销售订单
  2725. AmsSaleOrder amsSaleOrder = new AmsSaleOrder();
  2726. amsSaleOrder.setReceiveId(receiveId);
  2727. amsSaleOrder.setSaleRemark(saleRemark == null ? "":saleRemark);
  2728. amsSaleOrder.setShipperId(shipperId);
  2729. amsSaleOrder.setSaleOrderIsselfMention(isSelfMention);
  2730. amsSaleOrder.setSaleOrderId(saleOrderId);
  2731. amsSaleOrder.setSalerId(salerId);
  2732. // 设置钢材订单
  2733. amsSaleOrder.setSaleType(new BigDecimal(1));
  2734. amsSaleOrder.setSaleNumber(DataChange.generateEightDigitsNumber("WXSDD",saleOrderId.intValue(),"-"));
  2735. amsSaleOrder.setInsertTime(new Date());
  2736. amsSaleOrder.setInsertUpdateRemark("物流新增继续装销售订单");
  2737. amsSaleOrder.setInsertUsername("物流");
  2738. amsSaleOrder.setUpdateTime(new Date());
  2739. amsSaleOrder.setDeleted(new BigDecimal(0));
  2740. amsSaleOrder.setSaleOrderStatus(new BigDecimal(0));
  2741. // 税率默认13%
  2742. amsSaleOrder.setSaleOrderTax("13%");
  2743. // 含税单价某人4000
  2744. amsSaleOrder.setSaleUnitPrice(new BigDecimal(4000));
  2745. // 收款客户
  2746. amsSaleOrder.setSaleOrderReceiveCustomer(saleOrderReceiveCustomer);
  2747. // 销售订单物资表
  2748. AmsSaleMaterial amsSaleMaterial = new AmsSaleMaterial();
  2749. // 车序号物资表
  2750. AmsSaleTrucknoMaterial amsSaleTrucknoMaterial = new AmsSaleTrucknoMaterial();
  2751. // 遍历每一行
  2752. for (Map<String, Object> map : mapList) {
  2753. /*
  2754. 车序号表
  2755. */
  2756. // 得到车序号
  2757. BigDecimal truckNo = DataChange.dataToBigDecimal(map.get("truckNo"));
  2758. Map<String,Object> saleMap = new HashMap<>();
  2759. saleMap.put("saleOrderId",saleOrderId);
  2760. saleMap.put("saleOrderMaterialTruckNo",truckNo);
  2761. // 检测销售订单下的车序号是否已存在
  2762. List<AmsSaleOrderMaterial> amsSaleOrderMaterials = amsSaleOrderMaterialMapper.selectByParameters(saleMap);
  2763. // 车序号表
  2764. AmsSaleOrderMaterial amsSaleOrderMaterial = new AmsSaleOrderMaterial();
  2765. if (amsSaleOrderMaterials == null || amsSaleOrderMaterials.size() == 0) {
  2766. // 车序号主键
  2767. BigDecimal saleOrderMaterialId = amsSaleOrderMaterialMapper.selectMaxId();
  2768. BigDecimal shippingAddressId = DataChange.dataToBigDecimal(map.get("shipperAddressId"));
  2769. // 车号备注
  2770. String truckRemark = (String) (map.get("truckRemark"));
  2771. String place = (String) (map.get("place"));
  2772. amsSaleOrderMaterial.setSaleShippingAddressId(DataChange.dataToBigDecimal(map.get("placeId")));
  2773. if (amsSaleOrderMaterial.getSaleShippingAddressId() != null && isSelfMention.equals("否") && DataChange.dataToBigDecimal(map.get("carrierId")).intValue() == 0) {
  2774. // 自动匹配承运商
  2775. List<Map<String, Object>> carrierList = getCarrierByAddress(amsSaleOrderMaterial.getSaleShippingAddressId());
  2776. BigDecimal carrierCount = null;
  2777. if(place != null && !"null".equals(place)){
  2778. carrierCount = amsSaleOrderMapper.getMoreCarrier(place);
  2779. }
  2780. //根据收货地址id查询备注,判断是否需要匹配承运商
  2781. String addressRemark = amsSaleOrderMaterialMapper.getAddressRemark(shippingAddressId);
  2782. // 单一承运商才进行匹配
  2783. if (carrierList != null && carrierList.size() == 1 && carrierList.get(0) != null && carrierCount.intValue() == 0 && addressRemark == null) {
  2784. List<Map<String, Object>> list = new ArrayList<>();
  2785. Map<String, Object> map1 = carrierList.get(0);
  2786. // 传入车序号主键和承运商id
  2787. map1.put("saleOrderMaterialId", saleOrderMaterialId);
  2788. list.add(map1);
  2789. dispatchToCarrier(list);
  2790. }
  2791. }
  2792. if (isSelfMention.equals("是")) {
  2793. // 根据收货单位id查询出收货单位名称
  2794. String consigneeName = amsSaleOrderMapper.selectConsigneeName(receiveId);
  2795. // 根据收货单位名称查询承运商id
  2796. BigDecimal carrierId = amsSaleOrderMapper.selectCarrierId(consigneeName);
  2797. List<Map<String, Object>> list = new ArrayList<>();
  2798. Map<String,Object> map1 = new HashMap<>();
  2799. // 传入车序号主键和承运商id
  2800. if (carrierId != null) {
  2801. map1.put("saleOrderMaterialId", saleOrderMaterialId);
  2802. map1.put("carrierId", carrierId);
  2803. list.add(map1);
  2804. dispatchToCarrier(list);
  2805. }
  2806. }
  2807. if (isSelfMention.equals("否") && DataChange.dataToBigDecimal(map.get("carrierId")).intValue() != 0) {
  2808. //说明有承运商
  2809. List<Map<String, Object>> list = new ArrayList<>();
  2810. Map<String, Object> carrierMap = new HashMap<>();
  2811. carrierMap.put("carrierId",map.get("carrierId"));
  2812. carrierMap.put("saleOrderMaterialId",saleOrderMaterialId);
  2813. list.add(carrierMap);
  2814. dispatchToCarrier(list);
  2815. }
  2816. // 收货方姓名
  2817. String consigneeName = String.valueOf(map.get("saleOrderConsignee"));
  2818. // 收货方电话
  2819. String consigneeTel = String.valueOf(map.get("saleOrderConsigneeTel"));
  2820. // 截止日期
  2821. String dateOfReceiptStr = String.valueOf(map.get("saleDateOfReceipt"));
  2822. Date dateOfReceipt = null;
  2823. if (!"null".equals(dateOfReceiptStr) && !"undefined".equals(dateOfReceiptStr)) {
  2824. dateOfReceipt = new Date(Long.valueOf(dateOfReceiptStr));
  2825. }
  2826. amsSaleOrderMaterial.setSaleOrderMaterialId(saleOrderMaterialId);
  2827. amsSaleOrderMaterial.setSaleOrderId(saleOrderId);
  2828. amsSaleOrderMaterial.setTruckRemark(truckRemark);
  2829. amsSaleOrderMaterial.setSaleOrderMaterialTruckNo(truckNo);
  2830. if(map.get("orderNo") != null) {
  2831. amsSaleOrderMaterial.setPreviousOrderNumber((String) map.get("orderNo"));
  2832. //如果该订单已有出厂实绩,不允许生成继续装
  2833. //int outFactoryResult = amsSaleOrderMapper.selectOutFactoryResult((String) map.get("orderNo"));
  2834. //if(outFactoryResult > 0) {
  2835. // return 0;
  2836. //}
  2837. }
  2838. if (consigneeName != null && !consigneeName.equals("null")) {
  2839. amsSaleOrderMaterial.setSaleOrderConsignee(consigneeName);
  2840. }
  2841. if (consigneeTel != null && !consigneeTel.equals("null")) {
  2842. amsSaleOrderMaterial.setSaleOrderConsigneeTel(consigneeTel);
  2843. }
  2844. amsSaleOrderMaterial.setSaleDateOfReceipt(dateOfReceipt);
  2845. amsSaleOrderMaterial.setInsertTime(new Date());
  2846. amsSaleOrderMaterial.setUpdateTime(new Date());
  2847. amsSaleOrderMaterial.setInsertUpdateRemark("物流新增继续装");
  2848. amsSaleOrderMaterial.setWarrantyNumber(new BigDecimal(1));
  2849. result += amsSaleOrderMaterialMapper.insertSelective(amsSaleOrderMaterial);
  2850. }
  2851. else {
  2852. amsSaleOrderMaterial = amsSaleOrderMaterials.get(0);
  2853. }
  2854. /*
  2855. 销售订单物资表
  2856. */
  2857. // 物资
  2858. BigDecimal materialId = DataChange.dataToBigDecimal(map.get("materialId"));
  2859. Integer materialCount = amsSaleMaterialMapper.getMaterialCount(materialId);
  2860. RmsMaterial rmsMaterial = new RmsMaterial();
  2861. rmsMaterial.setMaterialId(materialId);
  2862. if (materialCount == null) {
  2863. materialCount = new Integer(0);
  2864. }
  2865. rmsMaterial.setMaterialCount(new BigDecimal(materialCount + 1));
  2866. rmsMaterialMapper.updateByPrimaryKeySelective(rmsMaterial);
  2867. // 物资件数
  2868. BigDecimal materialNumber = DataChange.dataToBigDecimal(map.get("materialNumber"));
  2869. // 物资名称
  2870. Object materialName = map.get("materialName");
  2871. // 钢材米数
  2872. BigDecimal steelMeters = DataChange.dataToBigDecimal(map.get("steelMeters"));
  2873. // 判断物资是否是盘螺或盘元/盘圆
  2874. if (materialName != null && (materialName.toString().contains("盘螺") || materialName.toString().contains("盘元") || materialName.toString().contains("盘圆"))) {
  2875. amsSaleMaterial.setSteelMeter(null);
  2876. }
  2877. else {
  2878. amsSaleMaterial.setSteelMeter(steelMeters);
  2879. }
  2880. // 是否磅重销售(0:磅重;1:理重)
  2881. BigDecimal isPoundSale = DataChange.dataToBigDecimal(map.get("isPoundSale"));
  2882. // 销售订单物资表主键
  2883. BigDecimal saleMaterialId = amsSaleMaterialMapper.selectMaxId();
  2884. amsSaleMaterial.setSaleMaterialId(saleMaterialId);
  2885. amsSaleMaterial.setSaleOrderId(saleOrderId);
  2886. amsSaleMaterial.setMaterialId(materialId);
  2887. amsSaleMaterial.setMaterialNumber(materialNumber);
  2888. amsSaleMaterial.setMaterialPlanNumber(materialNumber);
  2889. amsSaleMaterial.setInsertTime(new Date());
  2890. amsSaleMaterial.setUpdateTime(new Date());
  2891. amsSaleMaterial.setIsPoundSale(isPoundSale);
  2892. amsSaleMaterial.setInsertUpdateRemark("物流新增");
  2893. amsSaleMaterial.setSaleNo(amsSaleOrder.getSaleNumber());
  2894. try {
  2895. amsSaleMaterial.setTransferInOfWarehouse(saleRemark);
  2896. } catch (Exception e) {
  2897. e.printStackTrace();
  2898. }
  2899. if(saleGroupCode != null) {
  2900. amsSaleMaterial.setTransferOutOfWarehouse(saleGroupCode);
  2901. }
  2902. result += amsSaleMaterialMapper.insertSelective(amsSaleMaterial);
  2903. /*
  2904. 车序号物资表
  2905. */
  2906. // 车序号物资表主键
  2907. BigDecimal truckNoMaterialId = amsSaleTrucknoMaterialMapper.selectMaxId();
  2908. amsSaleTrucknoMaterial.setTrucknoMaterialId(truckNoMaterialId);
  2909. amsSaleTrucknoMaterial.setSaleOrderMaterialId(amsSaleOrderMaterial.getSaleOrderMaterialId());
  2910. amsSaleTrucknoMaterial.setMaterialId(amsSaleMaterial.getSaleMaterialId());
  2911. amsSaleTrucknoMaterial.setSaleOrderMaterialNumber(materialNumber);
  2912. amsSaleTrucknoMaterial.setInsertTime(new Date());
  2913. amsSaleTrucknoMaterial.setUpdateTime(new Date());
  2914. amsSaleTrucknoMaterial.setInsertUpdateRemark("物流新增");
  2915. result += amsSaleTrucknoMaterialMapper.insertSelective(amsSaleTrucknoMaterial);
  2916. }
  2917. result += amsSaleOrderMapper.insertSelective(amsSaleOrder);
  2918. return saleOrderId.intValue();
  2919. }
  2920. @Override
  2921. public BigDecimal selectTransPortOrder(BigDecimal closeWlEntryId) {
  2922. return amsSaleMaterialMapper.selectTransPortOrderId(closeWlEntryId);
  2923. }
  2924. @Override
  2925. public int updateTransportOrderStatus(BigDecimal orderId) {
  2926. //查询该运单下有没有净重,没有净重就变为7,有净重就变为2
  2927. int netWeight = omstruckOrderMapper.selectNetWeightCount(orderId);
  2928. //查询该运单有没有出厂,没有出厂才变2
  2929. int outFactory = omstruckOrderMapper.selectOutFactory(orderId);
  2930. int orderStatus = 7;
  2931. if(netWeight > 0 && outFactory == 0) {
  2932. orderStatus = 2;
  2933. }
  2934. if(netWeight > 0 && outFactory > 0) {
  2935. orderStatus = 5;
  2936. }
  2937. return amsSaleOrderMaterialMapper.updateTransportOrderStatus(orderId,orderStatus);
  2938. }
  2939. @ApiOperation("定时获取制单日期")
  2940. @Scheduled(fixedRate = 20 * 60 * 1000)
  2941. public void getMakeDateTime() {
  2942. Map<String, Object> Map = new HashMap<>();
  2943. getEasPrimaryIds(Map);
  2944. }
  2945. /**
  2946. * 推送车牌号给金蝶
  2947. * @param map
  2948. * @return
  2949. */
  2950. @Override
  2951. public int pushCarNumberToEas(Map<String, Object> map) throws Exception {
  2952. // 调用EAS接口将车牌号传给金蝶
  2953. List<Map<String,Object>> mapList = new ArrayList<>();
  2954. mapList.add(map);
  2955. Map<String,Object> input = joinFeign.findCarNumberByOrderList(mapList);
  2956. Map<String,Object> totalMap = new HashMap<>();
  2957. totalMap.putAll(easCapacityTestUtil.getTotalMap());
  2958. totalMap.put("input",input);
  2959. Map<String,Object> s = joinFeign.pushCarNumberToEas(totalMap);
  2960. System.out.println(totalMap);
  2961. String json = JSONUtils.toJSONString(totalMap);
  2962. System.out.println(json);
  2963. totalMap.put("output",s);
  2964. try {
  2965. newFileTool.newFile("pushCarNumberToEas:"+totalMap,"金蝶通讯报文");
  2966. }catch (Exception e){
  2967. e.printStackTrace();
  2968. }
  2969. if (s == null || s.size() == 0) {
  2970. throw new Exception("登录金蝶失败!请重试派车!");
  2971. }else{
  2972. try{
  2973. JSONObject result = new JSONObject(s);
  2974. //如果status不为1,抛出异常
  2975. if(!result.getJSONObject("res").getString("status").equals("1")){
  2976. throw new Exception("上传金蝶失败!请重试派车:"+result.getJSONObject("requestException").getString("message"));
  2977. }
  2978. }catch (Exception e){
  2979. e.printStackTrace();
  2980. //只抛出自定义异常
  2981. if(e.getMessage().contains("Exception")){
  2982. throw new Exception("上传金蝶失败!请重试派车!");
  2983. }else{
  2984. throw new Exception(e.getMessage());
  2985. }
  2986. }
  2987. }
  2988. return 1;
  2989. }
  2990. /**
  2991. * 批量推送
  2992. * @param mapList
  2993. * @return
  2994. * @throws Exception
  2995. */
  2996. @Override
  2997. public int batchPushCarNumberToEas(List<Map<String, Object>> mapList) throws Exception {
  2998. Map<String,Object> input = joinFeign.findCarNumberByOrderList(mapList);
  2999. Map<String,Object> totalMap = new HashMap<>();
  3000. totalMap.putAll(easCapacityTestUtil.getTotalMap());
  3001. totalMap.put("input",input);
  3002. Map<String,Object> s = joinFeign.pushCarNumberToEas(totalMap);
  3003. System.out.println(totalMap);
  3004. String json = JSONUtils.toJSONString(totalMap);
  3005. System.out.println(json);
  3006. totalMap.put("output",s);
  3007. System.out.println(totalMap);
  3008. try {
  3009. newFileTool.newFile("pushCarNumberToEas:"+totalMap,"金蝶通讯报文");
  3010. }catch (Exception e){
  3011. e.printStackTrace();
  3012. }
  3013. if (s == null || s.size() == 0) {
  3014. throw new Exception("登录金蝶失败!请重试派车!");
  3015. }else{
  3016. try{
  3017. JSONObject result = new JSONObject(s);
  3018. //如果status不为1,抛出异常
  3019. if(!result.getJSONObject("res").getString("status").equals("1")){
  3020. throw new Exception("上传金蝶失败!请重试派车:"+result.getJSONObject("requestException").getString("message"));
  3021. }
  3022. }catch (Exception e){
  3023. e.printStackTrace();
  3024. //只抛出自定义异常
  3025. if(e.getMessage().contains("Exception")){
  3026. throw new Exception("上传金蝶失败!请重试派车!");
  3027. }else{
  3028. throw new Exception(e.getMessage());
  3029. }
  3030. }
  3031. }
  3032. return 1;
  3033. }
  3034. /**
  3035. * 钢材派车,不上传金蝶
  3036. * @param map
  3037. * @return
  3038. * @throws Exception
  3039. */
  3040. private int dispatchSteelOrderNotPush(Map<String, Object> map) throws Exception {
  3041. Integer isCheckGps = amsSaleOrderMapper.getDispachSwitch();
  3042. Integer saleStatus = amsSaleOrderMapper.findStatus(DataChange.dataToBigDecimal(map.get("saleOrderMaterialId")));
  3043. String selfMention = amsSaleOrderMapper.findSelfMention(DataChange.dataToBigDecimal(map.get("saleOrderMaterialId")));
  3044. //如果这个车序号下面有运单,则证明已经派了
  3045. Map<String,Object> orderMap = amsSaleOrderMapper.getSteelOrderMap(DataChange.dataToBigDecimal(map.get("saleOrderMaterialId")));
  3046. //判断该车序号对应的分录是否全部关闭
  3047. Integer flCount = amsSaleMaterialMapper.getAbleFlcount(DataChange.dataToBigDecimal(map.get("saleOrderMaterialId")));
  3048. if(flCount == 0) {
  3049. throw new Exception("该运单下所有分录被关闭,无法派车");
  3050. }
  3051. if (orderMap != null) {
  3052. throw new Exception("该订单已派发,无法重复派车");
  3053. }
  3054. if (saleStatus == 1) {
  3055. throw new Exception("订单未审核,无法派车!");
  3056. }
  3057. int result = 0;
  3058. //得到此次是否校验GPS
  3059. boolean onceCheck = true;
  3060. try{
  3061. onceCheck = (boolean) map.get("isCheckGPS");
  3062. }catch (Exception e){
  3063. //取值失败不处理,默认校验GPS
  3064. }
  3065. // 得到车牌号
  3066. String capacityNumber = (String) map.get("capacityNumber");
  3067. // 得到运力id
  3068. BigDecimal capacityId = amsSaleOrderMaterialMapper.getCapacityId(capacityNumber);
  3069. //校验该车是否存在手机号
  3070. String tel=omstruckOrderMapper.getTelByCapacityId(capacityId);//数据库的手机号
  3071. String driverTel = (String) map.get("driverTel");//填写的手机号
  3072. if(tel==null || "".equals(tel)){
  3073. throw new Exception("该车没有电话号码,无法派车!请去资源管理-运力维护该车的电话号码!");
  3074. }
  3075. //查询车牌号是否是黑名单
  3076. if(amsSaleOrderMapper.isBlackList(capacityNumber)>0){
  3077. throw new Exception("该车在黑名单中,无法派车!请联系销售公司!");
  3078. }
  3079. //非自提,单次校验且全局校验,且车不允许无GPS
  3080. int isGPS=amsSaleOrderMapper.isGPS(capacityNumber);
  3081. if((selfMention==null || selfMention.equals("否")) && onceCheck && (isCheckGps!=null && isCheckGps==0) && isGPS <= 0){
  3082. Map<String,Object> data=null;
  3083. try{
  3084. data= (Map<String,Object>)otmsFeign.getCurrentLocation(capacityNumber).getData();
  3085. }catch (Exception e){
  3086. throw new Exception("该车没有GPS定位信息,请联系销售公司物流部,申请是否可以派车。");
  3087. }
  3088. if(data==null || !"1001".equals(""+data.get("status"))){
  3089. throw new Exception("该车没有GPS定位信息,请联系销售公司物流部,申请是否可以派车。");
  3090. }
  3091. }
  3092. // 得到车序号表主键
  3093. BigDecimal saleOrderMaterialId = DataChange.dataToBigDecimal(map.get("saleOrderMaterialId"));
  3094. // 得到承运商
  3095. BigDecimal carrierId = DataChange.dataToBigDecimal(map.get("carrierId"));
  3096. // 查询到车序号的单价
  3097. BigDecimal priceId = amsSaleOrderMapper.getOrderPrice(map);
  3098. // 得到详细地址id
  3099. BigDecimal placeId = amsSaleOrderMapper.getPlaceId(saleOrderMaterialId);
  3100. // 如果已经设置单价则不覆盖,详细地址匹配不到单价,则匹配省市县内最高的一条单价(只给非自提的进行匹配)
  3101. if (priceId == null && placeId != null && selfMention.equals("否")) {
  3102. priceId = amsSaleOrderMapper.getPriceIdByPlaceId(placeId);
  3103. }
  3104. // 运输线路id
  3105. BigDecimal lineId = DataChange.dataToBigDecimal(map.get("lineId"));
  3106. if(lineId==null || lineId.compareTo(BigDecimal.ZERO)==0){
  3107. throw new Exception("线路异常!");
  3108. }
  3109. BigDecimal isSteel = new BigDecimal(1);
  3110. if (capacityId == null) {
  3111. return 0;
  3112. }
  3113. List<Map<String, Object>> materialList = amsSaleOrderMaterialMapper.getMaterial(saleOrderMaterialId);
  3114. /*
  3115. 定向派单表
  3116. */
  3117. // 通过车序号主键确认定向派单是否已存在
  3118. BigDecimal dispatchId0 = amsDispatchSaleOrderMapper.isDispatchExist(saleOrderMaterialId);
  3119. if (dispatchId0 == null || dispatchId0.toString().length() == 0) {
  3120. AmsDispatchSaleOrder amsDispatchSaleOrder = new AmsDispatchSaleOrder();
  3121. // 主键
  3122. BigDecimal dispatchId = amsDispatchSaleOrderMapper.selectOtherId();
  3123. amsDispatchSaleOrder.setDispatchId(dispatchId);
  3124. // 车序号表id
  3125. amsDispatchSaleOrder.setSaleOrderMaterialId(saleOrderMaterialId);
  3126. // 承运商id
  3127. amsDispatchSaleOrder.setCarrierId(carrierId);
  3128. // 派单时间和成交时间
  3129. amsDispatchSaleOrder.setDispatchTime(new Date());
  3130. amsDispatchSaleOrder.setDispatchDealTime(new Date());
  3131. // 成交类型
  3132. amsDispatchSaleOrder.setDispatchType(new BigDecimal(2));
  3133. // 车序号状态
  3134. amsDispatchSaleOrder.setDispatchStatus(new BigDecimal(2));
  3135. result += amsDispatchSaleOrderMapper.insertSelective(amsDispatchSaleOrder);
  3136. }
  3137. // 如果已经匹配过承运商或者给某个承运商授权过,则派车时做修改承运商操作
  3138. else {
  3139. AmsDispatchSaleOrder amsDispatchSaleOrder = amsDispatchSaleOrderMapper.selectByPrimaryKey(dispatchId0);
  3140. amsDispatchSaleOrder.setCarrierId(carrierId);
  3141. result += amsDispatchSaleOrderMapper.updateByPrimaryKeySelective(amsDispatchSaleOrder);
  3142. }
  3143. /*
  3144. 运输订单
  3145. */
  3146. OmstruckOrder omstruckOrder = new OmstruckOrder();
  3147. Map<String, Object> map1 = new HashMap<>();
  3148. map1.put("orderType", new BigDecimal(2));
  3149. map1.put("orderPlanId", saleOrderMaterialId);
  3150. List<OmstruckOrder> omstruckOrders = omstruckOrderMapper.selectByParameters(map1);
  3151. if (omstruckOrders == null || omstruckOrders.size() == 0) {
  3152. // 运输订单主键
  3153. BigDecimal orderId = omstruckOrderMapper.selectMaxId();
  3154. omstruckOrder.setOrderId(orderId);
  3155. // 车序号主键
  3156. omstruckOrder.setOrderPlanId(saleOrderMaterialId);
  3157. //添加承运商ID 和 运价ID
  3158. // Object priceId = map.get("priceId");
  3159. if (priceId != null) {
  3160. omstruckOrder.setPriceId(priceId);
  3161. } else {
  3162. omstruckOrder.setPriceId(new BigDecimal(0));
  3163. }
  3164. omstruckOrder.setCarrierId(carrierId);
  3165. // 运输订单号
  3166. omstruckOrder.setOrderNumber(DataChange.generateEightDigitsNumber("WYSDD", orderId.intValue()));
  3167. // 运力id
  3168. omstruckOrder.setCapacityId(capacityId);
  3169. // 承运商
  3170. omstruckOrder.setCarrierId(carrierId);
  3171. // 是否可作业
  3172. omstruckOrder.setCanWork(new BigDecimal(0));
  3173. // 下发时间
  3174. omstruckOrder.setOrderIssueTime(new Date());
  3175. // 运单状态
  3176. omstruckOrder.setOrderStatus(new BigDecimal(4));
  3177. // 司机电话
  3178. if(tel != null && !"".equals(tel)){
  3179. omstruckOrder.setDriverTel(tel);
  3180. }
  3181. BigDecimal status;
  3182. // 钢材
  3183. status = new BigDecimal(1);
  3184. // 订单类型
  3185. omstruckOrder.setOrderType(status);
  3186. // 运输线路id
  3187. omstruckOrder.setLineId(lineId);
  3188. omstruckOrder.setInsertTime(new Date());
  3189. omstruckOrder.setInsertUsername("");
  3190. result += omstruckOrderMapper.insertSelective(omstruckOrder);
  3191. //插入日志
  3192. saleLogUtil.logOrder(orderId,"普通派单,当前派车为:" + capacityNumber,map,SaleLogUtil.INSERT);
  3193. } else {
  3194. omstruckOrder = omstruckOrders.get(0);
  3195. }
  3196. for (Map<String, Object> materialMap : materialList) {
  3197. BigDecimal materialId = (BigDecimal) materialMap.get("materialId");
  3198. BigDecimal materialWeight = (BigDecimal) materialMap.get("materialWeight");
  3199. BigDecimal materialNumber = (BigDecimal) materialMap.get("materialNumber");
  3200. BigDecimal saleMaterialId = (BigDecimal) materialMap.get("saleMaterialId");
  3201. /*
  3202. 运输订单物资子表
  3203. */
  3204. OmstruckOrderMaterial omstruckOrderMaterial = new OmstruckOrderMaterial();
  3205. // 主键
  3206. BigDecimal orderMaterialId = omstruckOrderMaterialMapper.selectMaxId();
  3207. omstruckOrderMaterial.setOrderMaterialId(orderMaterialId);
  3208. // 运输订单id
  3209. omstruckOrderMaterial.setOrderId(omstruckOrder.getOrderId());
  3210. // 物资id
  3211. omstruckOrderMaterial.setMaterialId(materialId);
  3212. // 物资重量
  3213. omstruckOrderMaterial.setOrderMaterialWeight(materialWeight);
  3214. // 物资件数
  3215. omstruckOrderMaterial.setOrderMaterialNumber(materialNumber);
  3216. omstruckOrderMaterial.setSaleMaterialId(saleMaterialId);
  3217. // 新增运输订单子表
  3218. result += omstruckOrderMaterialMapper.insertSelective(omstruckOrderMaterial);
  3219. }
  3220. // 调用websocket
  3221. Map<String, Object> orderIdMap = new HashMap<>();
  3222. orderIdMap.put("orderId", omstruckOrder.getOrderId());
  3223. try {
  3224. amsSaleOrderMaterialService.pushMesToWebsocket(orderIdMap);
  3225. } catch (Exception e) {
  3226. e.printStackTrace();
  3227. }
  3228. // 生成运输执行总实绩
  3229. result += tmsTruckFeign.addTotalResult(orderIdMap);
  3230. return result;
  3231. }
  3232. /**
  3233. * 钢材改车,不上传金蝶
  3234. * @param mapValue
  3235. * @return
  3236. * @throws Exception
  3237. */
  3238. private int updateSteelOrderNotPush(Map<String, Object> mapValue) throws Exception {
  3239. Object lineSequence = mapValue.get("lineSequence");
  3240. int result = 0;
  3241. if (mapValue.get("orderId") == null) {
  3242. throw new Exception("还未派车,不允许修改车牌号");
  3243. }
  3244. //判断该车序号对应的分录是否全部关闭
  3245. if(mapValue.get("saleOrderMaterialId") != null && DataChange.dataToBigDecimal(mapValue.get("capacityId")).compareTo(new BigDecimal(35128)) != 0) {
  3246. Integer flCount = amsSaleMaterialMapper.getAbleFlcount(DataChange.dataToBigDecimal(mapValue.get("saleOrderMaterialId")));
  3247. if(flCount == 0) {
  3248. throw new Exception("该运单下所有分录被关闭,无法派车");
  3249. }
  3250. }
  3251. //查询输入进来的车牌号是否与原有车牌号一致,如果一致则退出
  3252. BigDecimal oldCapacityId = omstruckOrderMapper.getOldCapacityId(DataChange.dataToBigDecimal(mapValue.get("orderId")));
  3253. String oldCapacityNumber = omstruckOrderMapper.getOldCapacityNumber(oldCapacityId);
  3254. if(oldCapacityId.compareTo(DataChange.dataToBigDecimal(mapValue.get("capacityId"))) == 0) {
  3255. return 1;
  3256. }
  3257. //校验该车是否存在手机号
  3258. String tel=omstruckOrderMapper.getTelByCapacityId(DataChange.dataToBigDecimal(mapValue.get("capacityId")));
  3259. String driverTel = (String) mapValue.get("driverTel");//填写的手机号
  3260. if(tel==null || "".equals(tel)){
  3261. throw new Exception("该车没有电话号码,无法派车!请去资源管理-运力维护该车的电话号码!");
  3262. }
  3263. Integer isCheckGps = amsSaleOrderMapper.getDispachSwitch();
  3264. String capacityNo = (String) mapValue.get("capacityNumber");
  3265. //得到此次是否校验GPS
  3266. boolean onceCheck = true;
  3267. //查询是否自提
  3268. String selfMention = "否";
  3269. try{
  3270. selfMention = amsSaleOrderMapper.findSelfMention(DataChange.dataToBigDecimal(mapValue.get("saleOrderMaterialId")));
  3271. onceCheck = (boolean) mapValue.get("isCheckGPS");
  3272. }catch (Exception e){
  3273. //取值失败不处理,取默认值
  3274. }
  3275. //查询车牌号是否是黑名单
  3276. if(amsSaleOrderMapper.isBlackList(capacityNo)>0){
  3277. throw new Exception("该车在黑名单中,无法派车!请联系销售公司!");
  3278. }
  3279. //非自提,单次校验且全局校验,且车辆不允许无GPS
  3280. int isGPS=amsSaleOrderMapper.isGPS(capacityNo);
  3281. if((selfMention==null || selfMention.equals("否")) && onceCheck && (isCheckGps!=null && isCheckGps==0) && isGPS <= 0){
  3282. Map<String,Object> data=null;
  3283. try{
  3284. data= (Map<String,Object>)otmsFeign.getCurrentLocation(capacityNo).getData();
  3285. }catch (Exception e){
  3286. throw new Exception("该车没有GPS定位信息,请联系销售公司物流部,申请是否可以派车。");
  3287. }
  3288. if(data==null || !"1001".equals(""+data.get("status"))){
  3289. throw new Exception("该车没有GPS定位信息,请联系销售公司物流部,申请是否可以派车。");
  3290. }
  3291. }
  3292. saleLogUtil.logOrder(DataChange.dataToBigDecimal(mapValue.get("orderId")),"修改车牌号,当前车号为:" + capacityNo + "上一个车牌号为:" + oldCapacityNumber,mapValue,SaleLogUtil.UPDATE);
  3293. if (lineSequence == null || "0".equals(lineSequence.toString()) || "1".equals(lineSequence.toString()) || "2".equals(lineSequence.toString())) {
  3294. String capacityids="";
  3295. Integer capacityid1= (Integer) mapValue.get("capacityIds");
  3296. Integer capacityid2= (Integer) mapValue.get("capacityId");
  3297. if (capacityid1!=null && !("".equals(capacityid1))){
  3298. capacityids=capacityid1+","+capacityid2;
  3299. }
  3300. mapValue.put("capacityids",capacityids);
  3301. //这是修改车牌号
  3302. //取消是新车牌号,那么不删除排队信息,不删除实绩信息,将运单状态变为7
  3303. if (DataChange.dataToBigDecimal(mapValue.get("capacityId")).compareTo(new BigDecimal(35128)) != 0) {
  3304. //根据订单id查询车牌号改动记录
  3305. String oldCpacityIds = omstruckOrderMapper.getOrderCapacityHistory(DataChange.dataToBigDecimal(mapValue.get("orderId")));
  3306. BigDecimal oldOldCapacityId = null;
  3307. if(oldCpacityIds != null) {
  3308. oldOldCapacityId = DataChange.dataToBigDecimal(oldCpacityIds.split(",")[0]);
  3309. }
  3310. //如果旧车号是取消,且取消的前一个车与该车相等,那么就将状态还原
  3311. if (oldOldCapacityId != null && oldCapacityId != null && oldCapacityId.compareTo(new BigDecimal(35128)) == 0 && DataChange.dataToBigDecimal(mapValue.get("capacityId")).compareTo(oldOldCapacityId) == 0 ) {
  3312. //判断该订单下有没有子实绩
  3313. BigDecimal resultId = amsSaleOrderMaterialMapper.selectEnFactory(DataChange.dataToBigDecimal(mapValue.get("orderId")));
  3314. if(resultId == null) {
  3315. OmstruckOrder omstruckOrder = new OmstruckOrder();
  3316. omstruckOrder.setOrderId(DataChange.dataToBigDecimal(mapValue.get("orderId")));
  3317. omstruckOrder.setOrderStatus(new BigDecimal(4));
  3318. omstruckOrder.setOrderLineSequence(new BigDecimal(0));
  3319. omstruckOrder.setInsertUpdateRemark("将取消改回来原来的车状态不变!");
  3320. if(tel != null && !"".equals(tel)){
  3321. omstruckOrder.setDriverTel(tel);
  3322. }
  3323. /*omstruckOrder.set*/
  3324. result += omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  3325. }else{
  3326. OmstruckOrder omstruckOrder = new OmstruckOrder();
  3327. omstruckOrder.setOrderId(DataChange.dataToBigDecimal(mapValue.get("orderId")));
  3328. omstruckOrder.setOrderStatus(new BigDecimal(5));
  3329. if(tel != null && !"".equals(tel)){
  3330. omstruckOrder.setDriverTel(tel);
  3331. }
  3332. omstruckOrder.setInsertUpdateRemark("将取消改回来原来的车状态不变!");
  3333. /*omstruckOrder.set*/
  3334. result += omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  3335. }
  3336. }else{
  3337. //将排队信息删掉
  3338. Map<String, Object> isSpellingMap = omstruckOrderMapper.getSteelIsSpelling(DataChange.dataToBigDecimal(mapValue.get("orderId")));
  3339. if(isSpellingMap != null && isSpellingMap.get("listId") != null){
  3340. int isSpelling = DataChange.dataToBigDecimal(isSpellingMap.get("isSpelling")).intValue();
  3341. if(isSpelling == 1 ){
  3342. result += omstruckOrderMapper.deleteSpellingList(isSpellingMap.get("listId"));
  3343. }else{
  3344. result += omstruckOrderMapper.deleteQueueList(isSpellingMap.get("listId"));
  3345. }
  3346. }
  3347. //若是接单之后还需要删除实绩且将状态变为4
  3348. //查询运输订单的状态和总实绩ID
  3349. Map<String, Object> orderMesMap = amsSaleOrderMapper.getOrderMes(mapValue);
  3350. BigDecimal resultTotalId = DataChange.dataToBigDecimal(orderMesMap.get("resultTotalId"));
  3351. //删除排队实绩
  3352. if (resultTotalId !=null && !("".equals(resultTotalId))){
  3353. omstruckOrderMapper.deleteQueuingPerformance(resultTotalId);
  3354. }
  3355. OmstruckOrder omstruckOrder = new OmstruckOrder();
  3356. omstruckOrder.setOrderId(DataChange.dataToBigDecimal(mapValue.get("orderId")));
  3357. // 设置新的运输订单号
  3358. omstruckOrder.setOrderNumber(DataChange.generateEightDigitsNumber("WYSDD", omstruckOrderMapper.selectMaxId().intValue()));
  3359. omstruckOrder.setOrderStatus(new BigDecimal(4));
  3360. omstruckOrder.setOrderLineSequence(new BigDecimal(0));
  3361. if(tel != null && !"".equals(tel)){
  3362. omstruckOrder.setDriverTel(tel);
  3363. }
  3364. /*omstruckOrder.set*/
  3365. result += omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  3366. //插入日志
  3367. result += omstruckOrderMapper.deleteEnResult(resultTotalId);
  3368. result += omstruckOrderMapper.deleteWeightResult(resultTotalId);
  3369. result += omstruckOrderMapper.deleteLoadResult(resultTotalId);
  3370. result += omstruckOrderMapper.deleteLeaveResult(resultTotalId);
  3371. }
  3372. }else{
  3373. OmstruckOrder omstruckOrder = new OmstruckOrder();
  3374. omstruckOrder.setOrderId(DataChange.dataToBigDecimal(mapValue.get("orderId")));
  3375. if(tel != null && !"".equals(tel)){
  3376. omstruckOrder.setDriverTel(tel);
  3377. }
  3378. omstruckOrder.setOrderStatus(new BigDecimal(7));
  3379. omstruckOrder.setInsertUpdateRemark("取消车牌号,保留实绩将状态变为7");
  3380. result += omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  3381. }
  3382. result += amsSaleOrderMapper.updateCapacityNumberInFactory(mapValue);
  3383. }
  3384. return result;
  3385. }
  3386. }