AmsSaleOrderServiceImpl.java 91 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916
  1. package com.steerinfo.dil.service.impl;
  2. import com.alibaba.druid.support.json.JSONUtils;
  3. import com.steerinfo.dil.feign.JoinFeign;
  4. import com.steerinfo.dil.feign.TmsTruckFeign;
  5. import com.steerinfo.dil.mapper.*;
  6. import com.steerinfo.dil.model.*;
  7. import com.steerinfo.dil.service.IAmsSaleOrderService;
  8. import com.steerinfo.dil.util.*;
  9. import org.springframework.beans.factory.annotation.Autowired;
  10. import org.springframework.stereotype.Service;
  11. import org.springframework.transaction.annotation.Transactional;
  12. import java.math.BigDecimal;
  13. import java.text.ParseException;
  14. import java.text.SimpleDateFormat;
  15. import java.util.*;
  16. /**
  17. * AmsSaleOrder服务实现:
  18. *
  19. * @author generator
  20. * @version 1.0-SNAPSHORT 2021-09-06 07:10
  21. * 类描述
  22. * 修订历史:
  23. * 日期:2021-09-06
  24. * 作者:generator
  25. * 参考:
  26. * 描述:AmsSaleOrder服务实现
  27. * @Copyright 湖南视拓信息技术股份有限公司. All rights reserved.
  28. * @see null
  29. */
  30. @Service(value = "amsSaleOrderService")
  31. public class AmsSaleOrderServiceImpl implements IAmsSaleOrderService {
  32. @Autowired
  33. private AmsSaleOrderMapper amsSaleOrderMapper;
  34. @Autowired
  35. private AmsSaleOrderMaterialMapper amsSaleOrderMaterialMapper;
  36. @Autowired
  37. private AmsSaleTrucknoMaterialMapper trucknoMaterialMapper;
  38. @Autowired
  39. TmstruckLoadResult tmstruckLoadResult;
  40. @Autowired
  41. TmstruckWeightResult tmstruckWeightResult;
  42. @Autowired
  43. TmstruckWeightResultMapper tmstruckWeightResultMapper;
  44. @Autowired
  45. TmstruckLoadResultMapper tmstruckLoadResultMapper;
  46. @Autowired
  47. AmsDispatchSaleOrderMapper amsDispatchSaleOrderMapper;
  48. @Autowired
  49. AmsSaleMaterialMapper amsSaleMaterialMapper;
  50. @Autowired
  51. AmsSaleTrucknoMaterialMapper amsSaleTrucknoMaterialMapper;
  52. @Autowired
  53. RmsReceivePlaceMapper rmsReceivePlaceMapper;
  54. @Autowired
  55. JoinFeign joinFeign;
  56. @Autowired
  57. OmstruckOrderMapper omstruckOrderMapper;
  58. @Autowired
  59. OmstruckOrderMaterialMapper omstruckOrderMaterialMapper;
  60. @Autowired
  61. AmsSaleOrderMaterialServiceImpl amsSaleOrderMaterialService;
  62. @Autowired
  63. TmsTruckFeign tmsTruckFeign;
  64. @Autowired
  65. EASUtil easUtil;
  66. @Autowired
  67. EASDeleteUtil easDeleteUtil;
  68. @Autowired
  69. EASTestUtil easTestUtil;
  70. @Autowired
  71. EASDeleteTestUtil easDeleteTestUtil;
  72. @Autowired
  73. RmsMaterialMapper rmsMaterialMapper;
  74. @Autowired
  75. WmspOutboundResultMaterial wmspOutboundResultMaterial;
  76. @Autowired
  77. WmspOutboundResultMaterialMapper wmspOutboundResultMaterialMapper;
  78. @Override
  79. public List<Map<String, Object>> getSaleOrderInfo(Map<String, Object> map) {
  80. return amsSaleOrderMapper.getSaleOrderInfo(map);
  81. }
  82. @Override
  83. public List<Map<String, Object>> getSaleOrderReported(Map<String, Object> map) {
  84. return amsSaleOrderMapper.getSaleOrderReported(map);
  85. }
  86. @Override
  87. public List<Map<String, Object>> getSaleOrderDetail(Map<String, Object> map) {
  88. return amsSaleOrderMapper.getSaleOrderDetail(map);
  89. }
  90. @Override
  91. public List<Map<String, Object>> getSalePlanName() {
  92. return amsSaleOrderMapper.getSalePlanName();
  93. }
  94. @Override
  95. public List<Map<String, Object>> getShipperName() {
  96. return amsSaleOrderMapper.getShipperName();
  97. }
  98. @Override
  99. public List<Map<String, Object>> getConsigneeCompanyName() {
  100. return amsSaleOrderMapper.getConsigneeCompanyName();
  101. }
  102. @Override
  103. /**
  104. * map存放为前端获取的amsSaleOrder基础数据以及selectionList物资信息
  105. * map1为基础数据包括,收货地址,收货人等
  106. * map2存放的从selectionList取出的数据,包括物资id,物资名称等。
  107. */
  108. public int addAmsSaleOrder(Map<String, Object> map) throws ParseException {
  109. //获取前端传过来的map,
  110. int i = 0;
  111. Map<String, Object> map1 = (Map<String, Object>) map.get("amsSaleOrder");
  112. AmsSaleOrder amsSaleOrder = new AmsSaleOrder();
  113. Integer id = (amsSaleOrderMapper.selectMaxId()).intValue();
  114. //生成主键id
  115. amsSaleOrder.setSaleOrderId(new BigDecimal(id));
  116. //WXSDD-年月日-8位数的顺序号
  117. String wxsdd = DataChange.generateEightDigitsNumber("WXSDD", id);
  118. amsSaleOrder.setSaleNumber(wxsdd);
  119. //获得是否自提
  120. amsSaleOrder.setSaleOrderIsselfMention((String) map1.get("saleOrderIsselfMention"));
  121. //获取收货地址id
  122. amsSaleOrder.setReceiveId(DataChange.dataToBigDecimal(map1.get("receiveId")));
  123. //获取发货单位id
  124. amsSaleOrder.setShipperId(DataChange.dataToBigDecimal(map1.get("shipperId")));
  125. //获取备注
  126. amsSaleOrder.setSaleRemark((String) map1.get("saleRemark"));
  127. //设置销售订单状态
  128. amsSaleOrder.setSaleOrderStatus(new BigDecimal(0));
  129. amsSaleOrder.setSaleUnitPrice(new BigDecimal(4000));
  130. amsSaleOrder.setSaleOrderTax("13%");
  131. amsSaleOrder.setInsertUsername("admin");
  132. amsSaleOrder.setInsertTime(new Date());
  133. amsSaleOrder.setUpdateUsername("admin");
  134. amsSaleOrder.setUpdateTime(new Date());
  135. amsSaleOrder.setInsertUpdateRemark("无");
  136. amsSaleOrder.setDeleted(new BigDecimal(0));
  137. amsSaleOrder.setSaleOrderStatus(new BigDecimal(0));
  138. //设置收款客户
  139. amsSaleOrder.setSaleOrderReceiveCustomer((String) map1.get("saleOrderReceiveCustomer"));
  140. i += amsSaleOrderMapper.insertSelective(amsSaleOrder);
  141. //获取车序号和物资信息进行新增车序号与物资中间表
  142. //一个销售订单对应多个车序号
  143. List<Map<String, Object>> selectionList = (List<Map<String, Object>>) map.get("selectionList");
  144. for (Map<String, Object> map2 : selectionList) {
  145. BigDecimal materialId = DataChange.dataToBigDecimal(map2.get("materialId"));
  146. Integer cxh = (Integer) map2.get("cxh");
  147. //生成车序号与物资实体
  148. AmsSaleOrderMaterial amsSaleOrderMaterial = new AmsSaleOrderMaterial();
  149. //生成主键
  150. amsSaleOrderMaterial.setSaleOrderMaterialId(amsSaleOrderMaterialMapper.selectMaxId());
  151. amsSaleOrderMaterial.setSaleOrderId(amsSaleOrder.getSaleOrderId());
  152. // 生成定向派单
  153. AmsDispatchSaleOrder amsDispatchSaleOrder = new AmsDispatchSaleOrder();
  154. amsDispatchSaleOrder.setDispatchId(amsDispatchSaleOrderMapper.selectOtherId());
  155. amsDispatchSaleOrder.setSaleOrderMaterialId(amsSaleOrderMaterial.getSaleOrderMaterialId());
  156. //获取收货地址
  157. Integer saleShipperAddressId =(Integer) map2.get("saleShipperAddressId");
  158. amsSaleOrderMaterial.setSaleShippingAddressId(new BigDecimal(saleShipperAddressId));
  159. //根据收货地址查询承运商
  160. Map<String,Object> map4 = amsSaleOrderMapper.selectProvince(saleShipperAddressId);
  161. BigDecimal carrierId = amsSaleOrderMapper.selectCarrierIdByprovince(map4);
  162. //获取收货方电话号码
  163. amsDispatchSaleOrder.setCarrierId(carrierId);
  164. amsDispatchSaleOrder.setDispatchTime(new Date());
  165. //设置成交类型
  166. amsDispatchSaleOrder.setDispatchType(new BigDecimal(0));
  167. //设置下发状态为未下发
  168. amsDispatchSaleOrder.setDispatchStatus(new BigDecimal(1));
  169. amsDispatchSaleOrder.setInsertTime(new Date());
  170. amsDispatchSaleOrder.setInsertUsername("admin");
  171. amsDispatchSaleOrderMapper.insertSelective(amsDispatchSaleOrder);
  172. amsSaleOrderMaterial.setSaleOrderConsigneeTel(map2.get("saleOrderConsigneeTel").toString());
  173. //获取收货日期
  174. String saleDateOfReceipt =(String) map2.get("saleDateOfReceipt");
  175. SimpleDateFormat simpleDateFormat=new SimpleDateFormat("yyyy-MM-dd");
  176. Date date = simpleDateFormat.parse(saleDateOfReceipt);
  177. amsSaleOrderMaterial.setSaleDateOfReceipt(date);
  178. //获取收货方姓名
  179. amsSaleOrderMaterial.setSaleOrderConsignee((String) map2.get("saleOrderConsignee"));
  180. //设置车序号
  181. amsSaleOrderMaterial.setSaleOrderMaterialTruckNo(new BigDecimal(cxh));
  182. //设置删除状态
  183. amsSaleOrderMaterial.setDeleted(new BigDecimal(0));
  184. i += amsSaleOrderMaterialMapper.insertSelective(amsSaleOrderMaterial);
  185. //新增车序号与物资中间表
  186. AmsSaleTrucknoMaterial trucknoMaterial = new AmsSaleTrucknoMaterial();
  187. trucknoMaterial.setTrucknoMaterialId(trucknoMaterialMapper.selectMaxId());
  188. //设置物资id
  189. trucknoMaterial.setMaterialId(materialId);
  190. //获取车序号物资id
  191. trucknoMaterial.setSaleOrderMaterialId(amsSaleOrderMaterial.getSaleOrderMaterialId());
  192. Integer orderPlanWeight = (Integer) map2.get("orderPlanWeight");
  193. trucknoMaterial.setSaleOrderMaterialNumber(DataChange.dataToBigDecimal(orderPlanWeight));
  194. //获取物资理重
  195. BigDecimal materialTheoreticalWeight = DataChange.dataToBigDecimal(map2.get("materialTheoreticalWeight"));
  196. //判断是否有物资理重
  197. if (materialTheoreticalWeight.intValue() != 0) {
  198. trucknoMaterial.setMaterialTheoreticalWeight(materialTheoreticalWeight);
  199. }
  200. //新增车序号与物资中间表
  201. i += trucknoMaterialMapper.insertSelective(trucknoMaterial);
  202. }
  203. return i;
  204. }
  205. @Transactional(rollbackFor = Exception.class)
  206. @Override
  207. public int uploadSaleOrder(BigDecimal saleOrderId) throws Exception {
  208. AmsSaleOrder amsSaleOrder = amsSaleOrderMapper.selectByPrimaryKey(saleOrderId);
  209. // 调用金蝶接口,将销售订单推送到金蝶系统
  210. Map<String, Object> input = joinFeign.getSaleOrder(saleOrderId);
  211. Map<String, Object> head = (Map<String, Object>) input.get("head");
  212. head.put("status","");
  213. // 获得金蝶接口配置:正式
  214. // Map<String, Object> totalMap = easUtil.getTotalMap();
  215. // 获得金蝶接口配置:测试
  216. Map<String, Object> totalMap = easUtil.getTotalMap();
  217. // 组装报文
  218. totalMap.put("input",input);
  219. System.out.println(totalMap);
  220. String json = JSONUtils.toJSONString(totalMap);
  221. System.out.println(json);
  222. // 得到金蝶返回结果
  223. Map<String,Object> s = joinFeign.pushSaleOrderToEas(totalMap);
  224. String status = (String) s.get("status");
  225. if ("-1".equals(status)) {
  226. throw new Exception(amsSaleOrder.getSaleNumber() + "上传金蝶失败!");
  227. }
  228. System.out.println(s);
  229. amsSaleOrder.setSaleOrderStatus(new BigDecimal(1));
  230. return amsSaleOrderMapper.updateByPrimaryKey(amsSaleOrder);
  231. }
  232. @Override
  233. public List<Map<String, Object>> selectBySaleOrderId(BigDecimal saleOrderId) {
  234. return amsSaleOrderMapper.selectBySaleOrderId(saleOrderId);
  235. }
  236. /**
  237. * 修改订单信息、车序号表、车序号物资中间表
  238. *
  239. * @param map
  240. * @return
  241. */
  242. @Override
  243. @Transactional
  244. public int updateAmsSaleOrder(Map<String, Object> map) throws ParseException {
  245. int i = 0;
  246. int j = 0;
  247. Map<String, Object> map1 = (Map<String, Object>) map.get("amsSaleOrder");
  248. AmsSaleOrder amsSaleOrder = new AmsSaleOrder();
  249. //修改销售订单表 更新销售订单基础信息
  250. amsSaleOrder.setSaleOrderId(DataChange.dataToBigDecimal(map1.get("saleOrderId")));
  251. amsSaleOrder.setShipperId(DataChange.dataToBigDecimal(map1.get("shipperId")));
  252. amsSaleOrder.setReceiveId(DataChange.dataToBigDecimal(map1.get("reciveId")));
  253. amsSaleOrder.setSaleOrderIsselfMention((String) map1.get("saleOrderIsselfMention"));
  254. amsSaleOrder.setSaleOrderReceiveCustomer((String) map1.get("saleOrderReciveCustomer"));
  255. amsSaleOrder.setSaleRemark((String) map1.get("saleRemark"));
  256. amsSaleOrder.setUpdateTime(new Date());
  257. i += amsSaleOrderMapper.updateByPrimaryKeySelective(amsSaleOrder);
  258. //根据销售订单id查找销售车序号和车序号与物资中间表主键
  259. List<Map<String, Object>> map2 = amsSaleOrderMapper.selectSaleOrderMaterialIdBySaleOrderId(DataChange.dataToBigDecimal(map1.get("saleOrderId")));
  260. for (Map<String,Object> Id:map2){
  261. BigDecimal truckNoMaterialId =(BigDecimal) Id.get("TruckNoMaterialId");
  262. BigDecimal saleOrderMaterialId=(BigDecimal) Id.get("saleOrderMaterialId");
  263. //删除对应的车序号表与车序号与物资中间表
  264. j+=amsSaleOrderMaterialMapper.deleteByPrimaryKey(saleOrderMaterialId);
  265. j+=trucknoMaterialMapper.deleteByPrimaryKey(truckNoMaterialId);
  266. }
  267. //新增车序号和物资中间表
  268. //获取车序号和物资信息进行新增车序号与物资中间表
  269. //一个销售订单对应多个车序号
  270. List<Map<String, Object>> selectionList = (List<Map<String, Object>>) map.get("selectionList");
  271. for (Map<String, Object> map3 : selectionList) {
  272. BigDecimal materialId = DataChange.dataToBigDecimal(map3.get("materialId"));
  273. Integer cxh = (Integer) map3.get("cxh");
  274. //生成车序号与物资实体
  275. AmsSaleOrderMaterial amsSaleOrderMaterial = new AmsSaleOrderMaterial();
  276. //生成主键
  277. amsSaleOrderMaterial.setSaleOrderMaterialId(amsSaleOrderMaterialMapper.selectMaxId());
  278. amsSaleOrderMaterial.setSaleOrderId(DataChange.dataToBigDecimal(map1.get("saleOrderId")));
  279. //获取收货地址
  280. amsSaleOrderMaterial.setSaleShippingAddressId(DataChange.dataToBigDecimal(map3.get("saleShipperAddressId")));
  281. //获取收货方电话号码
  282. amsSaleOrderMaterial.setSaleOrderConsigneeTel(map3.get("saleOrderConsigneeTel").toString());
  283. //获取收货日期
  284. String saleDateOfReceipt =(String) map3.get("saleDateOfReceipt");
  285. SimpleDateFormat simpleDateFormat=new SimpleDateFormat("yyyy-MM-dd");
  286. Date date = simpleDateFormat.parse(saleDateOfReceipt);
  287. amsSaleOrderMaterial.setSaleDateOfReceipt(date);
  288. //获取收货方姓名
  289. amsSaleOrderMaterial.setSaleOrderConsignee((String) map3.get("saleOrderConsignee"));
  290. //设置车序号
  291. amsSaleOrderMaterial.setSaleOrderMaterialTruckNo(new BigDecimal(cxh));
  292. //设置删除状态
  293. amsSaleOrderMaterial.setDeleted(new BigDecimal(0));
  294. i += amsSaleOrderMaterialMapper.insertSelective(amsSaleOrderMaterial);
  295. // 生成定向派单
  296. AmsDispatchSaleOrder amsDispatchSaleOrder = new AmsDispatchSaleOrder();
  297. amsDispatchSaleOrder.setDispatchId(amsDispatchSaleOrderMapper.selectOtherId());
  298. amsDispatchSaleOrder.setSaleOrderMaterialId(amsSaleOrderMaterial.getSaleOrderMaterialId());
  299. //获取收货地址
  300. Integer saleShipperAddressId =(Integer) map3.get("saleShipperAddressId");
  301. amsSaleOrderMaterial.setSaleShippingAddressId(new BigDecimal(saleShipperAddressId));
  302. //根据收货地址查询承运商
  303. Map<String,Object> map4 = amsSaleOrderMapper.selectProvince(saleShipperAddressId);
  304. BigDecimal carrierId = amsSaleOrderMapper.selectCarrierIdByprovince(map4);
  305. //获取收货方电话号码
  306. amsDispatchSaleOrder.setCarrierId(carrierId);
  307. amsDispatchSaleOrder.setDispatchTime(new Date());
  308. //设置成交类型
  309. amsDispatchSaleOrder.setDispatchType(new BigDecimal(0));
  310. //设置下发状态为已下发
  311. amsDispatchSaleOrder.setDispatchStatus(new BigDecimal(0));
  312. amsDispatchSaleOrder.setInsertTime(new Date());
  313. amsDispatchSaleOrder.setInsertUsername("admin");
  314. //新增车序号与物资中间表
  315. AmsSaleTrucknoMaterial trucknoMaterial = new AmsSaleTrucknoMaterial();
  316. trucknoMaterial.setTrucknoMaterialId(trucknoMaterialMapper.selectMaxId());
  317. //设置物资id
  318. trucknoMaterial.setMaterialId(materialId);
  319. //获取车序号物资id
  320. trucknoMaterial.setSaleOrderMaterialId(amsSaleOrderMaterial.getSaleOrderMaterialId());
  321. Integer orderPlanWeight = (Integer) map3.get("orderPlanWeight");
  322. trucknoMaterial.setSaleOrderMaterialNumber(DataChange.dataToBigDecimal(orderPlanWeight));
  323. //获取物资理重
  324. BigDecimal materialTheoreticalWeight = DataChange.dataToBigDecimal(map3.get("materialTheoreticalWeight"));
  325. //判断是否有物资理重
  326. if (materialTheoreticalWeight.intValue() != 0) {
  327. trucknoMaterial.setMaterialTheoreticalWeight(materialTheoreticalWeight);
  328. }
  329. //新增车序号与物资中间表
  330. i += trucknoMaterialMapper.insertSelective(trucknoMaterial);
  331. }
  332. // List<Map<String, Object>> mapList = (List<Map<String, Object>>) map.get("mapList");
  333. // ArrayList<Integer> list = new ArrayList<>();
  334. // for (Map<String, Object> truckMesMap : mapList) {
  335. // //修改车序号表
  336. // BigDecimal saleOrderMaterialId = DataChange.dataToBigDecimal(truckMesMap.get("saleOrderMaterialId"));
  337. // if (!list.contains(saleOrderMaterialId.intValue())) {
  338. // //车序号表专用字段
  339. // BigDecimal saleShipperAddressId = DataChange.dataToBigDecimal(truckMesMap.get("saleShipperAddressId"));
  340. // String saleDateOfReceipt =(String) truckMesMap.get("saleDateOfReceipt");
  341. // SimpleDateFormat simpleDateFormat=new SimpleDateFormat("yyyy-MM-dd");
  342. // Date date = simpleDateFormat.parse(saleDateOfReceipt);
  343. // String saleOrderConsignee = (String) truckMesMap.get("saleOrderConsignee");
  344. // String saleOrderConsigneeTel = (String) truckMesMap.get("saleOrderConsigneeTel");
  345. // AmsSaleOrderMaterial amsSaleOrderMaterial = new AmsSaleOrderMaterial();
  346. // amsSaleOrderMaterial.setSaleOrderMaterialId(saleOrderMaterialId);
  347. // amsSaleOrderMaterial.setSaleOrderMaterialTruckNo(DataChange.dataToBigDecimal(truckMesMap.get("cxh")));
  348. // amsSaleOrderMaterial.setSaleShippingAddressId(saleShipperAddressId);
  349. // amsSaleOrderMaterial.setSaleDateOfReceipt(date);
  350. // amsSaleOrderMaterial.setSaleOrderConsignee(saleOrderConsignee);
  351. // amsSaleOrderMaterial.setSaleOrderConsigneeTel(saleOrderConsigneeTel);
  352. // i += amsSaleOrderMaterialMapper.updateByPrimaryKeySelective(amsSaleOrderMaterial);
  353. // list.add(saleOrderMaterialId.intValue());
  354. // }
  355. // //修改车车序号物资表
  356. // AmsSaleTrucknoMaterial amsSaleTrucknoMaterial = new AmsSaleTrucknoMaterial();
  357. // amsSaleTrucknoMaterial.setTrucknoMaterialId(DataChange.dataToBigDecimal(truckMesMap.get("trucknoMaterialId")));
  358. // amsSaleTrucknoMaterial.setSaleOrderMaterialNumber(DataChange.dataToBigDecimal(truckMesMap.get("orderPlanWeight")));
  359. // amsSaleTrucknoMaterial.setMaterialId(DataChange.dataToBigDecimal(truckMesMap.get("materialId")));
  360. // i += trucknoMaterialMapper.updateByPrimaryKeySelective(amsSaleTrucknoMaterial);
  361. // }
  362. return i;
  363. }
  364. @Override
  365. public int deleteAmsSaleOrderBySaleOrderId(BigDecimal saleOrderId) {
  366. //删除所有从表信息
  367. //amsSaleOrderMapper.deleteBySaleOrderId(saleOrderId);
  368. AmsSaleOrder amsSaleOrder = amsSaleOrderMapper.selectByPrimaryKey(saleOrderId);
  369. amsSaleOrder.setDeleted(new BigDecimal(2));
  370. return amsSaleOrderMapper.updateByPrimaryKey(amsSaleOrder);
  371. }
  372. @Override
  373. public List<Map<String, Object>> getSaleOrderUpdateLog(Map<String, Object> map) {
  374. return amsSaleOrderMapper.getSaleOrderUpdateLog(map);
  375. }
  376. /**
  377. * 销售公司查询已审核的订单
  378. * @param map
  379. * @return
  380. */
  381. @Override
  382. public List<Map<String, Object>> getSaleOrderListBySaleCompany(Map<String, Object> map) {
  383. return amsSaleOrderMapper.getSaleOrderListBySaleCompany(map);
  384. }
  385. @Override
  386. public List<Map<String, Object>> getAmsSaleOrderApproved(Map<String, Object> map) {
  387. return amsSaleOrderMapper.getAmsSaleOrderApproved(map);
  388. }
  389. @Override
  390. public List<Map<String, Object>> getSaleOrderList(Map<String, Object> mapValue) {
  391. return amsSaleOrderMapper.getSaleOrderList(mapValue);
  392. }
  393. public Map<String, Object> getCarrier(Integer addressId) {
  394. return amsSaleOrderMapper.selectProvince(addressId);
  395. }
  396. /**
  397. * 根据销售订单id查找信息
  398. */
  399. @Override
  400. public Map<String, Object> selectInfoBySaleOrderId(BigDecimal saleOrderId) {
  401. return amsSaleOrderMapper.selectInfoBySaleOrderId(saleOrderId);
  402. }
  403. /**
  404. * 根据销售订单id查找物资信息
  405. *
  406. * @param saleOrderId
  407. * @return
  408. */
  409. @Override
  410. public List<Map<String, Object>> selectMaterialInfoBySaleOrderId(BigDecimal saleOrderId) {
  411. return amsSaleOrderMapper.selectMaterialInfoBySaleOrderId(saleOrderId);
  412. }
  413. @Override
  414. public int addAmsDispatchSaleOrder(List<Map<String, Object>> mapValue) {
  415. int result = 0;
  416. for (Map<String,Object> map : mapValue) {
  417. Integer dispatchId = (Integer)map.get("dispatchId");
  418. AmsDispatchSaleOrder amsDispatchSaleOrder = amsDispatchSaleOrderMapper.selectByPrimaryKey(new BigDecimal(dispatchId));
  419. amsDispatchSaleOrder.setDispatchStatus(new BigDecimal(0));
  420. result = amsDispatchSaleOrderMapper.updateByPrimaryKeySelective(amsDispatchSaleOrder);
  421. }
  422. return result;
  423. }
  424. @Override
  425. public List<Map<String, Object>> getSaleOrderInfoes(Map<String, Object> map) {
  426. return amsSaleOrderMapper.getSaleOrderInfoes(map);
  427. }
  428. @Override
  429. public List<Map<String, Object>> getSaleOrderReportedes(Map<String, Object> map) {
  430. return amsSaleOrderMapper.getSaleOrderReportedes(map);
  431. }
  432. @Override
  433. public List<Map<String, Object>> getSaleOrderListBySaleCompanyes(Map<String, Object> map) {
  434. List<Map<String, Object>> resultList = amsSaleOrderMapper.getSaleOrderListBySaleCompanyes(map);
  435. return resultList;
  436. }
  437. @Override
  438. public List<Map<String, Object>> getAmsSaleOrderApprovedes(Map<String, Object> map) {
  439. List<Map<String,Object>> resultList = amsSaleOrderMapper.getAmsSaleOrderApprovedes(map);
  440. return resultList;
  441. }
  442. /*
  443. * 根据销售订单主键展示销售基本信息、物资信息
  444. * */
  445. @Override
  446. public List<Map<String, Object>> getSaleOrderAndMaterialById(Map<String,Object> mapValue) {
  447. List<Map<String, Object>> mapList=amsSaleOrderMapper.getSaleOrderAndMaterialById(mapValue);
  448. for (Map<String, Object> map : mapList) {
  449. BigDecimal number;
  450. BigDecimal materialNumber = (BigDecimal) map.get("materialNumber");
  451. BigDecimal materialWeight = (BigDecimal) map.get("materialWeight");
  452. String materialName =(String) map.get("materialName");
  453. if (materialNumber != null && materialNumber.toString().length() != 0 && !materialName.equals("钒渣")) {
  454. number = materialNumber;
  455. }
  456. else {
  457. number = materialWeight;
  458. }
  459. map.put("number",number);
  460. }
  461. return mapList;
  462. }
  463. /**
  464. * 销售焦炭订单
  465. * @param mapValue
  466. * @return
  467. */
  468. @Override
  469. public List<Map<String, Object>> getCokeSaleOrderList(Map<String, Object> mapValue) {
  470. List<Map<String,Object>> mapList = amsSaleOrderMapper.getCokeSaleOrderList(mapValue);
  471. for (Map<String, Object> resultMap : mapList) {
  472. BigDecimal saleOrderId = (BigDecimal) resultMap.get("saleOrderId");
  473. BigDecimal netWeight = amsSaleOrderMapper.getNetWeight(saleOrderId);
  474. BigDecimal carNum = amsSaleOrderMapper.getCarNum(saleOrderId);
  475. resultMap.put("netWeight",netWeight);
  476. resultMap.put("carNum",carNum);
  477. }
  478. return mapList;
  479. }
  480. /**
  481. * 新增钢材销售订单
  482. * @param mapValue
  483. * @return
  484. */
  485. @Override
  486. @Transactional(rollbackFor = Exception.class)
  487. public int addSteelSaleOrder(Map<String, Object> mapValue) throws Exception {
  488. List<Map<String,Object>> mapList = (List<Map<String, Object>>) mapValue.get("mapList");
  489. // 得到发货单位
  490. BigDecimal shipperId = DataChange.dataToBigDecimal(mapValue.get("shipperId"));
  491. // 收货单位
  492. BigDecimal receiveId = DataChange.dataToBigDecimal(mapValue.get("receiveId"));
  493. if (receiveId == null || receiveId.intValue() == 0) {
  494. receiveId = amsSaleOrderMapper.findReceiveId(mapValue.get("receiveName"));
  495. if (receiveId == null) {
  496. throw new Exception("您输入的下单客户:" + mapValue.get("receiveName") + "不存在!!");
  497. }
  498. }
  499. // 是否自提
  500. String isSelfMention = (String) mapValue.get("isSelfMention");
  501. // 备注
  502. String saleRemark = (String) mapValue.get("saleRemark");
  503. // 收款客户
  504. String saleOrderReceiveCustomer = (String) mapValue.get("saleOrderReceiveCustomer");
  505. // 业务员
  506. BigDecimal salerId = DataChange.dataToBigDecimal(mapValue.get("salerId"));
  507. if (salerId == null || salerId.intValue() == 0) {
  508. salerId = amsSaleOrderMapper.findSalerId(mapValue.get("salerName"));
  509. if (salerId == null) {
  510. throw new Exception("您输入的业务员:" + mapValue.get("salerName") +"不存在!!");
  511. }
  512. }
  513. BigDecimal saleOrderId = amsSaleOrderMapper.selectMaxId();
  514. int result = 0;
  515. // 销售订单
  516. AmsSaleOrder amsSaleOrder = new AmsSaleOrder();
  517. amsSaleOrder.setReceiveId(receiveId);
  518. amsSaleOrder.setSaleRemark(saleRemark == null ? "":saleRemark);
  519. amsSaleOrder.setShipperId(shipperId);
  520. amsSaleOrder.setSaleOrderIsselfMention(isSelfMention);
  521. amsSaleOrder.setSaleOrderId(saleOrderId);
  522. amsSaleOrder.setSalerId(salerId);
  523. // 设置钢材订单
  524. amsSaleOrder.setSaleType(new BigDecimal(1));
  525. amsSaleOrder.setSaleNumber(DataChange.generateEightDigitsNumber("WXSDD",saleOrderId.intValue(),"-"));
  526. amsSaleOrder.setInsertTime(new Date());
  527. amsSaleOrder.setInsertUpdateRemark("物流新增销售订单");
  528. amsSaleOrder.setInsertUsername("物流");
  529. amsSaleOrder.setUpdateTime(new Date());
  530. amsSaleOrder.setDeleted(new BigDecimal(0));
  531. amsSaleOrder.setSaleOrderStatus(new BigDecimal(0));
  532. // 税率默认13%
  533. amsSaleOrder.setSaleOrderTax("13%");
  534. // 含税单价某人4000
  535. amsSaleOrder.setSaleUnitPrice(new BigDecimal(4000));
  536. // 收款客户
  537. amsSaleOrder.setSaleOrderReceiveCustomer(saleOrderReceiveCustomer);
  538. // 销售订单物资表
  539. AmsSaleMaterial amsSaleMaterial = new AmsSaleMaterial();
  540. // 车序号物资表
  541. AmsSaleTrucknoMaterial amsSaleTrucknoMaterial = new AmsSaleTrucknoMaterial();
  542. // 遍历每一行
  543. for (Map<String, Object> map : mapList) {
  544. /*
  545. 车序号表
  546. */
  547. // 得到车序号
  548. BigDecimal truckNo = DataChange.dataToBigDecimal(map.get("truckNo"));
  549. Map<String,Object> saleMap = new HashMap<>();
  550. saleMap.put("saleOrderId",saleOrderId);
  551. saleMap.put("saleOrderMaterialTruckNo",truckNo);
  552. // 检测销售订单下的车序号是否已存在
  553. List<AmsSaleOrderMaterial> amsSaleOrderMaterials = amsSaleOrderMaterialMapper.selectByParameters(saleMap);
  554. // 车序号表
  555. AmsSaleOrderMaterial amsSaleOrderMaterial = new AmsSaleOrderMaterial();
  556. if (amsSaleOrderMaterials == null || amsSaleOrderMaterials.size() == 0) {
  557. // 车序号主键
  558. BigDecimal saleOrderMaterialId = amsSaleOrderMaterialMapper.selectMaxId();
  559. BigDecimal shippingAddressId = DataChange.dataToBigDecimal(map.get("shipperAddressId"));
  560. if (shippingAddressId == null || shippingAddressId.intValue() == 0) {
  561. String province = (String) map.get("province");
  562. String district = (String) map.get("district");
  563. String town = (String) map.get("town");
  564. Map<String,Object> addressMap = new HashMap<>();
  565. addressMap.put("province",province);
  566. addressMap.put("district",district);
  567. addressMap.put("town",town);
  568. shippingAddressId = amsSaleOrderMapper.findAddressId(addressMap);
  569. if (shippingAddressId == null) {
  570. throw new Exception("您输入的:" + province + district + town + "地址不存在!!");
  571. }
  572. }
  573. // 车号备注
  574. String truckRemark = (String) (map.get("truckRemark"));
  575. String place = (String) (map.get("place"));
  576. if (place != null && !"null".equals(place)) {
  577. List<Map<String, Object>> placeIdList = amsSaleOrderMaterialMapper.getPlaceId(place,shippingAddressId);
  578. if (placeIdList == null || placeIdList.size() == 0) {
  579. RmsReceivePlace rmsReceivePlace = new RmsReceivePlace();
  580. rmsReceivePlace.setPlaceId(rmsReceivePlaceMapper.selectMaxId());
  581. rmsReceivePlace.setAddressId(shippingAddressId);
  582. rmsReceivePlace.setAddressDeliveryAddress(place);
  583. amsSaleOrderMaterial.setSaleShippingAddressId(rmsReceivePlace.getPlaceId());
  584. rmsReceivePlaceMapper.insertSelective(rmsReceivePlace);
  585. } else {
  586. amsSaleOrderMaterial.setSaleShippingAddressId((BigDecimal) placeIdList.get(0).get("placeId"));
  587. }
  588. }
  589. if (amsSaleOrderMaterial.getSaleShippingAddressId() != null && isSelfMention.equals("否")) {
  590. // 自动匹配承运商
  591. List<Map<String, Object>> carrierList = getCarrierByAddress(amsSaleOrderMaterial.getSaleShippingAddressId());
  592. // 单一承运商才进行匹配
  593. if (carrierList != null && carrierList.size() == 1) {
  594. List<Map<String, Object>> list = new ArrayList<>();
  595. Map<String, Object> map1 = carrierList.get(0);
  596. // 传入车序号主键和承运商id
  597. map1.put("saleOrderMaterialId", saleOrderMaterialId);
  598. list.add(map1);
  599. dispatchToCarrier(list);
  600. }
  601. }
  602. if (isSelfMention.equals("是")) {
  603. // 根据收货单位id查询出收货单位名称
  604. String consigneeName = amsSaleOrderMapper.selectConsigneeName(receiveId);
  605. // 根据收货单位名称查询承运商id
  606. BigDecimal carrierId = amsSaleOrderMapper.selectCarrierId(consigneeName);
  607. List<Map<String, Object>> list = new ArrayList<>();
  608. Map<String,Object> map1 = new HashMap<>();
  609. // 传入车序号主键和承运商id
  610. if (carrierId != null) {
  611. map1.put("saleOrderMaterialId", saleOrderMaterialId);
  612. map1.put("carrierId", carrierId);
  613. list.add(map1);
  614. dispatchToCarrier(list);
  615. }
  616. }
  617. // 收货方姓名
  618. String consigneeName = String.valueOf(map.get("saleOrderConsignee"));
  619. // 收货方电话
  620. String consigneeTel = String.valueOf(map.get("saleOrderConsigneeTel"));
  621. // 截止日期
  622. String dateOfReceiptStr = String.valueOf(map.get("saleDateOfReceipt"));
  623. Date dateOfReceipt = null;
  624. if (!"null".equals(dateOfReceiptStr) && !"undefined".equals(dateOfReceiptStr)) {
  625. dateOfReceipt = new Date(Long.valueOf(dateOfReceiptStr));
  626. }
  627. amsSaleOrderMaterial.setSaleOrderMaterialId(saleOrderMaterialId);
  628. amsSaleOrderMaterial.setSaleOrderId(saleOrderId);
  629. amsSaleOrderMaterial.setTruckRemark(truckRemark);
  630. amsSaleOrderMaterial.setSaleOrderMaterialTruckNo(truckNo);
  631. if (consigneeName != null && !consigneeName.equals("null")) {
  632. amsSaleOrderMaterial.setSaleOrderConsignee(consigneeName);
  633. }
  634. if (consigneeTel != null && !consigneeTel.equals("null")) {
  635. amsSaleOrderMaterial.setSaleOrderConsigneeTel(consigneeTel);
  636. }
  637. amsSaleOrderMaterial.setSaleDateOfReceipt(dateOfReceipt);
  638. amsSaleOrderMaterial.setInsertTime(new Date());
  639. amsSaleOrderMaterial.setUpdateTime(new Date());
  640. amsSaleOrderMaterial.setInsertUpdateRemark("物流新增");
  641. result += amsSaleOrderMaterialMapper.insertSelective(amsSaleOrderMaterial);
  642. }
  643. else {
  644. amsSaleOrderMaterial = amsSaleOrderMaterials.get(0);
  645. }
  646. /*
  647. 销售订单物资表
  648. */
  649. // 物资
  650. BigDecimal materialId = DataChange.dataToBigDecimal(map.get("materialId"));
  651. if (materialId == null || materialId.intValue() == 0) {
  652. String name = (String) map.get("materialName");
  653. String specification = (String) map.get("materialSpecification");
  654. String model = (String) map.get("materialModel");
  655. Map<String,Object> materialMap = new HashMap<>();
  656. materialMap.put("name",name);
  657. materialMap.put("specification",specification);
  658. if (model == null || model.equals("") || model.equals("null")) {
  659. model = null;
  660. }
  661. materialMap.put("model",model);
  662. materialId = amsSaleOrderMapper.findMaterialId(materialMap);
  663. if (materialId == null) {
  664. throw new Exception("您输入的物资:" + name + specification + model + "不存在!!");
  665. }
  666. }
  667. Integer materialCount = amsSaleMaterialMapper.getMaterialCount(materialId);
  668. RmsMaterial rmsMaterial = new RmsMaterial();
  669. rmsMaterial.setMaterialId(materialId);
  670. if (materialCount == null) {
  671. materialCount = new Integer(0);
  672. }
  673. rmsMaterial.setMaterialCount(new BigDecimal(materialCount + 1));
  674. rmsMaterialMapper.updateByPrimaryKeySelective(rmsMaterial);
  675. // 物资件数
  676. BigDecimal materialNumber = DataChange.dataToBigDecimal(map.get("materialNumber"));
  677. // 物资名称
  678. Object materialName = map.get("materialName");
  679. // 钢材米数
  680. BigDecimal steelMeters = DataChange.dataToBigDecimal(map.get("steelMeters"));
  681. // 判断物资是否是盘螺或盘元/盘圆
  682. if (materialName != null && (materialName.toString().contains("盘螺") || materialName.toString().contains("盘元") || materialName.toString().contains("盘圆"))) {
  683. amsSaleMaterial.setSteelMeter(null);
  684. }
  685. else {
  686. amsSaleMaterial.setSteelMeter(steelMeters);
  687. }
  688. // 是否磅重销售(0:磅重;1:理重)
  689. BigDecimal isPoundSale = DataChange.dataToBigDecimal(map.get("isPoundSale"));
  690. // 销售订单物资表主键
  691. BigDecimal saleMaterialId = amsSaleMaterialMapper.selectMaxId();
  692. amsSaleMaterial.setSaleMaterialId(saleMaterialId);
  693. amsSaleMaterial.setSaleOrderId(saleOrderId);
  694. amsSaleMaterial.setMaterialId(materialId);
  695. amsSaleMaterial.setMaterialNumber(materialNumber);
  696. amsSaleMaterial.setInsertTime(new Date());
  697. amsSaleMaterial.setUpdateTime(new Date());
  698. amsSaleMaterial.setIsPoundSale(isPoundSale);
  699. amsSaleMaterial.setInsertUpdateRemark("物流新增");
  700. result += amsSaleMaterialMapper.insertSelective(amsSaleMaterial);
  701. /*
  702. 车序号物资表
  703. */
  704. // 车序号物资表主键
  705. BigDecimal truckNoMaterialId = amsSaleTrucknoMaterialMapper.selectMaxId();
  706. amsSaleTrucknoMaterial.setTrucknoMaterialId(truckNoMaterialId);
  707. amsSaleTrucknoMaterial.setSaleOrderMaterialId(amsSaleOrderMaterial.getSaleOrderMaterialId());
  708. amsSaleTrucknoMaterial.setMaterialId(amsSaleMaterial.getSaleMaterialId());
  709. amsSaleTrucknoMaterial.setSaleOrderMaterialNumber(materialNumber);
  710. amsSaleTrucknoMaterial.setInsertTime(new Date());
  711. amsSaleTrucknoMaterial.setUpdateTime(new Date());
  712. amsSaleTrucknoMaterial.setInsertUpdateRemark("物流新增");
  713. result += amsSaleTrucknoMaterialMapper.insertSelective(amsSaleTrucknoMaterial);
  714. }
  715. result += amsSaleOrderMapper.insertSelective(amsSaleOrder);
  716. return result;
  717. }
  718. /**
  719. * 展示销售订单下的车序号和物资
  720. * @param saleOrderId
  721. * @return
  722. */
  723. @Override
  724. public List<Map<String, Object>> getTruckNoAndMaterialList(BigDecimal saleOrderId) {
  725. HashMap<String,Object> mapValue = new HashMap<>();
  726. mapValue.put("saleOrderId",saleOrderId);
  727. List<Map<String,Object>> mapList = amsSaleOrderMapper.getTruckNoAndMaterial(mapValue);
  728. for (Map<String,Object> map : mapList) {
  729. BigDecimal placeId = (BigDecimal) map.get("placeId");
  730. if (placeId != null) {
  731. List<Map<String, Object>> carrierAndPriceList = getCarrierByPlace(placeId);
  732. map.put("carrierAndPriceList", carrierAndPriceList);
  733. }
  734. }
  735. return mapList;
  736. }
  737. /**
  738. * 销售钢材派车
  739. * @param mapList
  740. * @return
  741. */
  742. @Transactional(rollbackFor = Exception.class)
  743. @Override
  744. public int dispatchSteelOrder(List<Map<String, Object>> mapList) throws Exception {
  745. Map<String, Object> stringObjectMap = mapList.get(0);
  746. Integer saleStatus = amsSaleOrderMapper.findStatus(DataChange.dataToBigDecimal(stringObjectMap.get("saleOrderMaterialId")));
  747. String selfMention = amsSaleOrderMapper.findSelfMention(DataChange.dataToBigDecimal(stringObjectMap.get("saleOrderMaterialId")));
  748. if (saleStatus == 1) {
  749. throw new Exception("订单未审核,无法派车!");
  750. }
  751. int result = 0;
  752. // 遍历每一行
  753. for (Map<String,Object> map : mapList) {
  754. // 得到车牌号
  755. String capacityNumber = (String) map.get("capacityNumber");
  756. // 得到车序号表主键
  757. BigDecimal saleOrderMaterialId = DataChange.dataToBigDecimal(map.get("saleOrderMaterialId"));
  758. // 得到承运商
  759. BigDecimal carrierId = DataChange.dataToBigDecimal(map.get("carrierId"));
  760. // 查询到车序号的单价
  761. BigDecimal priceId = amsSaleOrderMapper.getOrderPrice(map);
  762. // 得到详细地址id
  763. BigDecimal placeId = amsSaleOrderMapper.getPlaceId(saleOrderMaterialId);
  764. // 如果详细地址匹配不到单价,则匹配省市县内最高的一条单价(只给非自提的进行匹配)
  765. if (priceId == null && selfMention.equals("否")) {
  766. // 找到详细地址下的省市县id
  767. BigDecimal addressId = amsSaleOrderMapper.getAddressByPlace(placeId);
  768. // 根据省市县匹配出省市县下的所有单价
  769. Map<String,Object> hashMap = new HashMap<>();
  770. hashMap.put("addressId",addressId);
  771. hashMap.put("carrierId",carrierId);
  772. List<Map<String,Object>> priceList = amsSaleOrderMapper.getAddressPriceList(hashMap);
  773. // 如果长度为0,说明此地址所在省市县内也无单价
  774. if (priceList != null && priceList.size() != 0) {
  775. Map<String, Object> priceMap = priceList.get(0);
  776. priceId = (BigDecimal) priceMap.get("priceId");
  777. }
  778. else {
  779. priceId = new BigDecimal(2400);
  780. }
  781. }
  782. // 运输线路id
  783. BigDecimal lineId = DataChange.dataToBigDecimal(map.get("lineId"));
  784. // 司机电话号码
  785. String driverTel = (String) map.get("driverTel");
  786. BigDecimal isSteel = new BigDecimal(1);
  787. // 得到运力id
  788. BigDecimal capacityId = amsSaleOrderMaterialMapper.getCapacityId(capacityNumber);
  789. if (capacityId == null) {
  790. return 0;
  791. }
  792. List<Map<String,Object>> materialList = amsSaleOrderMaterialMapper.getMaterial(saleOrderMaterialId);
  793. /*
  794. 定向派单表
  795. */
  796. // 通过车序号主键确认定向派单是否已存在
  797. BigDecimal dispatchId0 = amsDispatchSaleOrderMapper.isDispatchExist(saleOrderMaterialId);
  798. if (dispatchId0 == null || dispatchId0.toString().length() == 0) {
  799. AmsDispatchSaleOrder amsDispatchSaleOrder = new AmsDispatchSaleOrder();
  800. // 主键
  801. BigDecimal dispatchId = amsDispatchSaleOrderMapper.selectOtherId();
  802. amsDispatchSaleOrder.setDispatchId(dispatchId);
  803. // 车序号表id
  804. amsDispatchSaleOrder.setSaleOrderMaterialId(saleOrderMaterialId);
  805. // 承运商id
  806. amsDispatchSaleOrder.setCarrierId(carrierId);
  807. // 派单时间和成交时间
  808. amsDispatchSaleOrder.setDispatchTime(new Date());
  809. amsDispatchSaleOrder.setDispatchDealTime(new Date());
  810. // 成交类型
  811. amsDispatchSaleOrder.setDispatchType(new BigDecimal(2));
  812. // 车序号状态
  813. amsDispatchSaleOrder.setDispatchStatus(new BigDecimal(2));
  814. result += amsDispatchSaleOrderMapper.insertSelective(amsDispatchSaleOrder);
  815. }
  816. // 如果已经匹配过承运商或者给某个承运商授权过,则派车时做修改承运商操作
  817. else {
  818. AmsDispatchSaleOrder amsDispatchSaleOrder = amsDispatchSaleOrderMapper.selectByPrimaryKey(dispatchId0);
  819. amsDispatchSaleOrder.setCarrierId(carrierId);
  820. result += amsDispatchSaleOrderMapper.updateByPrimaryKeySelective(amsDispatchSaleOrder);
  821. }
  822. /*
  823. 运输订单
  824. */
  825. OmstruckOrder omstruckOrder = new OmstruckOrder();
  826. Map<String,Object> map1 = new HashMap<>();
  827. map1.put("orderType",new BigDecimal(2));
  828. map1.put("orderPlanId",saleOrderMaterialId);
  829. List<OmstruckOrder> omstruckOrders = omstruckOrderMapper.selectByParameters(map1);
  830. if (omstruckOrders == null || omstruckOrders.size() == 0) {
  831. // 运输订单主键
  832. BigDecimal orderId = omstruckOrderMapper.selectMaxId();
  833. omstruckOrder.setOrderId(orderId);
  834. // 车序号主键
  835. omstruckOrder.setOrderPlanId(saleOrderMaterialId);
  836. //添加承运商ID 和 运价ID
  837. // Object priceId = map.get("priceId");
  838. if (priceId != null) {
  839. omstruckOrder.setPriceId(priceId);
  840. }
  841. else {
  842. omstruckOrder.setPriceId(new BigDecimal(0));
  843. }
  844. omstruckOrder.setCarrierId(carrierId);
  845. // 运输订单号
  846. omstruckOrder.setOrderNumber(DataChange.generateEightDigitsNumber("WYSDD", orderId.intValue()));
  847. // 运力id
  848. omstruckOrder.setCapacityId(capacityId);
  849. // 承运商
  850. omstruckOrder.setCarrierId(carrierId);
  851. // 是否可作业
  852. omstruckOrder.setCanWork(new BigDecimal(0));
  853. // 下发时间
  854. omstruckOrder.setOrderIssueTime(new Date());
  855. // 运单状态
  856. omstruckOrder.setOrderStatus(new BigDecimal(4));
  857. // 司机电话
  858. if (driverTel != null && !"null".equals(driverTel)) {
  859. omstruckOrder.setDriverTel(driverTel);
  860. }
  861. BigDecimal status;
  862. // 钢材
  863. if (isSteel != null && isSteel.intValue() == 1) {
  864. status = new BigDecimal(1);
  865. }
  866. // 非钢材(危化品,焦炭,副产品)
  867. else {
  868. status = new BigDecimal(2);
  869. }
  870. // 订单类型
  871. omstruckOrder.setOrderType(status);
  872. // 运输线路id
  873. omstruckOrder.setLineId(lineId);
  874. omstruckOrder.setInsertTime(new Date());
  875. omstruckOrder.setInsertUsername("");
  876. result += omstruckOrderMapper.insertSelective(omstruckOrder);
  877. }
  878. else {
  879. omstruckOrder = omstruckOrders.get(0);
  880. }
  881. for (Map<String, Object> materialMap : materialList) {
  882. BigDecimal materialId = (BigDecimal) materialMap.get("materialId");
  883. BigDecimal materialWeight = (BigDecimal) materialMap.get("materialWeight");
  884. BigDecimal materialNumber = (BigDecimal) materialMap.get("materialNumber");
  885. /*
  886. 运输订单物资子表
  887. */
  888. OmstruckOrderMaterial omstruckOrderMaterial = new OmstruckOrderMaterial();
  889. // 主键
  890. BigDecimal orderMaterialId = omstruckOrderMaterialMapper.selectMaxId();
  891. omstruckOrderMaterial.setOrderMaterialId(orderMaterialId);
  892. // 运输订单id
  893. omstruckOrderMaterial.setOrderId(omstruckOrder.getOrderId());
  894. // 物资id
  895. omstruckOrderMaterial.setMaterialId(materialId);
  896. // 物资重量
  897. omstruckOrderMaterial.setOrderMaterialWeight(materialWeight);
  898. // 物资件数
  899. omstruckOrderMaterial.setOrderMaterialNumber(materialNumber);
  900. // 新增运输订单子表
  901. result += omstruckOrderMaterialMapper.insertSelective(omstruckOrderMaterial);
  902. }
  903. // 调用websocket
  904. Map<String,Object> orderIdMap = new HashMap<>();
  905. orderIdMap.put("orderId",omstruckOrder.getOrderId());
  906. amsSaleOrderMaterialService.pushMesToWebsocket(orderIdMap);
  907. // 生成运输执行总实绩
  908. result += tmsTruckFeign.addTotalResult(orderIdMap);
  909. }
  910. return result;
  911. }
  912. /**
  913. * 根据详细地址匹配承运商
  914. * @param placeId
  915. * @return
  916. */
  917. @Override
  918. public synchronized List<Map<String,Object>> getCarrierByPlace(BigDecimal placeId) {
  919. BigDecimal addressId = amsSaleOrderMapper.getAddressByPlace(placeId);
  920. List<Map<String,Object>> mapList = amsSaleOrderMapper.getCarrierByPlace(placeId);
  921. return mapList;
  922. }
  923. /**
  924. * 根据省市县匹配承运商
  925. * @param placeId
  926. * @return
  927. */
  928. public synchronized List<Map<String,Object>> getCarrierByAddress(BigDecimal placeId) {
  929. BigDecimal addressId = amsSaleOrderMapper.getAddressByPlace(placeId);
  930. List<Map<String,Object>> mapList = amsSaleOrderMapper.getCarrierByAddress(addressId);
  931. return mapList;
  932. }
  933. /**
  934. * 根据详细地址和承运商匹配单价
  935. * @param mapValue
  936. * @return
  937. */
  938. @Override
  939. public Map<String, Object> getPriceByCarrierAndPlace(Map<String, Object> mapValue) {
  940. Map<String,Object> map = amsSaleOrderMapper.getPriceByCarrierAndPlace(mapValue);
  941. return map;
  942. }
  943. /**
  944. * 将车序号下发给承运商
  945. * @param mapList
  946. * @return
  947. */
  948. @Override
  949. public int dispatchToCarrier(List<Map<String,Object>> mapList) {
  950. int result = 0;
  951. // 遍历每一行
  952. for (Map<String, Object> map : mapList) {
  953. // 得到承运商
  954. BigDecimal carrierId =DataChange.dataToBigDecimal(map.get("carrierId"));
  955. // 得到车序号表主键
  956. BigDecimal saleOrderMaterialId =DataChange.dataToBigDecimal(map.get("saleOrderMaterialId"));
  957. AmsDispatchSaleOrder amsDispatchSaleOrder = new AmsDispatchSaleOrder();
  958. BigDecimal dispatchId = amsDispatchSaleOrderMapper.selectOtherId();
  959. amsDispatchSaleOrder.setDispatchId(dispatchId);
  960. amsDispatchSaleOrder.setCarrierId(carrierId);
  961. amsDispatchSaleOrder.setSaleOrderMaterialId(saleOrderMaterialId);
  962. amsDispatchSaleOrder.setInsertTime(new Date());
  963. amsDispatchSaleOrder.setInsertUpdateRemark("授权承运商");
  964. // 派单时间和成交时间
  965. amsDispatchSaleOrder.setDispatchTime(new Date());
  966. amsDispatchSaleOrder.setDispatchDealTime(new Date());
  967. // 成交类型
  968. amsDispatchSaleOrder.setDispatchType(new BigDecimal(2));
  969. // 车序号状态
  970. amsDispatchSaleOrder.setDispatchStatus(new BigDecimal(2));
  971. result += amsDispatchSaleOrderMapper.insertSelective(amsDispatchSaleOrder);
  972. }
  973. return result;
  974. }
  975. @Override
  976. public List<Map<String, Object>> getSaleOrderListToCarrier(Map<String, Object> map) {
  977. List<Map<String, Object>> resultList = amsSaleOrderMapper.getSaleOrderListToCarrier(map);
  978. return resultList;
  979. }
  980. @Override
  981. public List<Map<String, Object>> getSaleOrderListByCarrierSsoId(Map<String, Object> map) {
  982. List<Map<String, Object>> resultList = amsSaleOrderMapper.getSaleOrderListByCarrierSsoId(map);
  983. return resultList;
  984. }
  985. /**
  986. * 同步金蝶删除
  987. * @param saleOrderId
  988. * @return
  989. */
  990. @Override
  991. public int deleteSaleOrderById(BigDecimal saleOrderId) {
  992. int result = 0;
  993. AmsSaleOrder amsSaleOrder = new AmsSaleOrder();
  994. amsSaleOrder.setSaleOrderId(saleOrderId);
  995. amsSaleOrder.setDeleted(new BigDecimal(2));
  996. // 如果是已经上传金蝶的销售订单,则同步删除
  997. AmsSaleOrder amsSaleOrder1 = amsSaleOrderMapper.selectByPrimaryKey(saleOrderId);
  998. if (amsSaleOrder1.getSaleOrderStatus().intValue() == 1 || amsSaleOrder1.getSaleOrderStatus().intValue() == 2 || amsSaleOrder1.getSaleOrderStatus().intValue() == 4) {
  999. String reason = "修改物资关闭上一条销售订单";
  1000. String number = amsSaleOrder1.getSaleNumber();
  1001. String wholeOrder = "1";
  1002. String status = "close";
  1003. Map<String,Object> head = new HashMap<>();
  1004. head.put("number",number);
  1005. head.put("reason",reason);
  1006. head.put("wholeOrder",wholeOrder);
  1007. head.put("status",status);
  1008. Map<String,Object> input = new HashMap<>();
  1009. Map<String, Object> totalMap = easDeleteUtil.getTotalMap();
  1010. input.put("head",head);
  1011. totalMap.put("input",input);
  1012. // 调用金蝶关闭接口
  1013. String json = JSONUtils.toJSONString(totalMap);
  1014. System.out.println(json);
  1015. Map<String,Object> resultMap = joinFeign.deleteSaleOrderToEas(totalMap);
  1016. System.out.println(resultMap);
  1017. }
  1018. // 如果是副产品订单则关闭时同步关闭未进厂的运单
  1019. Map<String,Object> map = new HashMap<>();
  1020. map.put("saleOrderId",saleOrderId);
  1021. List<AmsSaleMaterial> amsSaleMaterials = amsSaleMaterialMapper.selectByParameters(map);
  1022. if (amsSaleMaterials != null && amsSaleMaterials.get(0).getSaleWarehouse() != null && amsSaleMaterials.get(0).getSaleWarehouse().equals("副产品库")) {
  1023. result += amsSaleOrderMapper.closeOrderNotIn(saleOrderId);
  1024. }
  1025. result += amsSaleOrderMapper.updateByPrimaryKeySelective(amsSaleOrder);
  1026. return result;
  1027. }
  1028. /**
  1029. * 查询出销售订单下的所有数据
  1030. * @param saleOrderId
  1031. * @return
  1032. */
  1033. @Override
  1034. public Map<String, Object> getAllSaleMessages(BigDecimal saleOrderId) {
  1035. Map<String,Object> saleMap = amsSaleOrderMapper.getSaleMapMessages(saleOrderId);
  1036. List<Map<String,Object>> mapList = amsSaleOrderMapper.getSaleListMessages(saleOrderId);
  1037. saleMap.put("mapList",mapList);
  1038. return saleMap;
  1039. }
  1040. /**
  1041. * 修改承运商授权
  1042. * @param mapValue
  1043. * @return
  1044. */
  1045. @Override
  1046. public int updateTruckNoCarrier(Map<String, Object> mapValue) {
  1047. BigDecimal carrierId = DataChange.dataToBigDecimal(mapValue.get("carrierId"));
  1048. mapValue.remove("carrierId");
  1049. List<AmsDispatchSaleOrder> amsDispatchSaleOrders = amsDispatchSaleOrderMapper.selectByParameters(mapValue);
  1050. AmsDispatchSaleOrder amsDispatchSaleOrder = amsDispatchSaleOrders.get(0);
  1051. amsDispatchSaleOrder.setCarrierId(carrierId);
  1052. int result = amsDispatchSaleOrderMapper.updateByPrimaryKeySelective(amsDispatchSaleOrder);
  1053. return result;
  1054. }
  1055. /**
  1056. * 批量上传销售订单至金蝶
  1057. * @param saleOrderIdList
  1058. * @return
  1059. */
  1060. @Transactional(rollbackFor = Exception.class)
  1061. @Override
  1062. public int uploadSaleOrderList(List<Map<String, Object>> saleOrderIdList) {
  1063. int result = 0;
  1064. for (Map<String, Object> map : saleOrderIdList) {
  1065. AmsSaleOrder amsSaleOrder = new AmsSaleOrder();
  1066. BigDecimal saleOrderId = DataChange.dataToBigDecimal(map.get("saleOrderId"));
  1067. // 调用金蝶接口,将销售订单推送到金蝶系统
  1068. Map<String, Object> input = joinFeign.getSaleOrder(saleOrderId);
  1069. Map<String, Object> head = (Map<String, Object>) input.get("head");
  1070. head.put("status","");
  1071. // 获得金蝶接口配置:正式
  1072. // Map<String, Object> totalMap = easUtil.getTotalMap();
  1073. // 获得金蝶接口配置:测试
  1074. Map<String, Object> totalMap = easUtil.getTotalMap();
  1075. // 组装报文
  1076. totalMap.put("input",input);
  1077. System.out.println(totalMap);
  1078. String json = JSONUtils.toJSONString(totalMap);
  1079. System.out.println(json);
  1080. Map<String,Object> s = joinFeign.pushSaleOrderToEas(totalMap);
  1081. String status = (String) s.get("status");
  1082. if ("-1".equals(status)) {
  1083. continue;
  1084. }
  1085. System.out.println(s);
  1086. amsSaleOrder.setSaleOrderId(saleOrderId);
  1087. amsSaleOrder.setSaleOrderStatus(new BigDecimal(1));
  1088. result += amsSaleOrderMapper.updateByPrimaryKeySelective(amsSaleOrder);
  1089. }
  1090. return result;
  1091. }
  1092. /**
  1093. * 新增钒渣销售订单
  1094. * @param mapValue
  1095. * @return
  1096. */
  1097. @Override
  1098. public int addVanadiumSaleOrder(Map<String, Object> mapValue) {
  1099. List<Map<String,Object>> mapList = (List<Map<String, Object>>) mapValue.get("mapList");
  1100. // 得到发货单位
  1101. BigDecimal shipperId = DataChange.dataToBigDecimal(mapValue.get("shipperId"));
  1102. // 收货单位
  1103. BigDecimal receiveId = DataChange.dataToBigDecimal(mapValue.get("receiveId"));
  1104. // 是否自提
  1105. String isSelfMention = (String) mapValue.get("isSelfMention");
  1106. // 备注
  1107. String saleRemark = (String) mapValue.get("saleRemark");
  1108. // 收款客户
  1109. String saleOrderReceiveCustomer = (String) mapValue.get("saleOrderReceiveCustomer");
  1110. // 业务员
  1111. BigDecimal salerId = DataChange.dataToBigDecimal(mapValue.get("salerId"));
  1112. BigDecimal saleOrderId = amsSaleOrderMapper.selectMaxId();
  1113. int result = 0;
  1114. // 销售订单
  1115. AmsSaleOrder amsSaleOrder = new AmsSaleOrder();
  1116. amsSaleOrder.setReceiveId(receiveId);
  1117. amsSaleOrder.setSaleRemark(saleRemark == null ? "":saleRemark);
  1118. amsSaleOrder.setShipperId(shipperId);
  1119. amsSaleOrder.setSaleOrderIsselfMention(isSelfMention);
  1120. amsSaleOrder.setSaleOrderId(saleOrderId);
  1121. amsSaleOrder.setSalerId(salerId);
  1122. // 设置钒渣订单
  1123. amsSaleOrder.setSaleType(new BigDecimal(2));
  1124. amsSaleOrder.setSaleNumber(DataChange.generateEightDigitsNumber("WXSDD",saleOrderId.intValue(),"-"));
  1125. amsSaleOrder.setInsertTime(new Date());
  1126. amsSaleOrder.setInsertUpdateRemark("物流新增销售订单");
  1127. amsSaleOrder.setInsertUsername("物流");
  1128. amsSaleOrder.setUpdateTime(new Date());
  1129. amsSaleOrder.setDeleted(new BigDecimal(0));
  1130. amsSaleOrder.setSaleOrderStatus(new BigDecimal(0));
  1131. // 税率默认13%
  1132. amsSaleOrder.setSaleOrderTax("13%");
  1133. // 含税单价某人4000
  1134. amsSaleOrder.setSaleUnitPrice(new BigDecimal(4000));
  1135. // 收款客户
  1136. amsSaleOrder.setSaleOrderReceiveCustomer(saleOrderReceiveCustomer);
  1137. // 销售订单物资表
  1138. AmsSaleMaterial amsSaleMaterial = new AmsSaleMaterial();
  1139. // 车序号物资表
  1140. AmsSaleTrucknoMaterial amsSaleTrucknoMaterial = new AmsSaleTrucknoMaterial();
  1141. // 遍历每一行
  1142. for (Map<String, Object> map : mapList) {
  1143. /*
  1144. 车序号表
  1145. */
  1146. // 得到车序号
  1147. BigDecimal truckNo = DataChange.dataToBigDecimal(map.get("truckNo"));
  1148. Map<String,Object> saleMap = new HashMap<>();
  1149. saleMap.put("saleOrderId",saleOrderId);
  1150. saleMap.put("saleOrderMaterialTruckNo",truckNo);
  1151. // 检测销售订单下的车序号是否已存在
  1152. List<AmsSaleOrderMaterial> amsSaleOrderMaterials = amsSaleOrderMaterialMapper.selectByParameters(saleMap);
  1153. // 车序号表
  1154. AmsSaleOrderMaterial amsSaleOrderMaterial = new AmsSaleOrderMaterial();
  1155. if (amsSaleOrderMaterials == null || amsSaleOrderMaterials.size() == 0) {
  1156. // 车序号主键
  1157. BigDecimal saleOrderMaterialId = amsSaleOrderMaterialMapper.selectMaxId();
  1158. BigDecimal shippingAddressId = DataChange.dataToBigDecimal(map.get("shipperAddressId"));
  1159. // 车号备注
  1160. String truckRemark = (String) (map.get("truckRemark"));
  1161. String place = (String) (map.get("place"));
  1162. if (place != null && !"null".equals(place)) {
  1163. List<Map<String, Object>> placeIdList = amsSaleOrderMaterialMapper.getPlaceId(place,shippingAddressId);
  1164. if (placeIdList == null || placeIdList.size() == 0) {
  1165. RmsReceivePlace rmsReceivePlace = new RmsReceivePlace();
  1166. rmsReceivePlace.setPlaceId(rmsReceivePlaceMapper.selectMaxId());
  1167. rmsReceivePlace.setAddressId(shippingAddressId);
  1168. rmsReceivePlace.setAddressDeliveryAddress(place);
  1169. amsSaleOrderMaterial.setSaleShippingAddressId(rmsReceivePlace.getPlaceId());
  1170. rmsReceivePlaceMapper.insertSelective(rmsReceivePlace);
  1171. } else {
  1172. amsSaleOrderMaterial.setSaleShippingAddressId((BigDecimal) placeIdList.get(0).get("placeId"));
  1173. }
  1174. }
  1175. if (amsSaleOrderMaterial.getSaleShippingAddressId() != null && isSelfMention.equals("否")) {
  1176. // 自动匹配承运商
  1177. List<Map<String, Object>> carrierList = getCarrierByPlace(amsSaleOrderMaterial.getSaleShippingAddressId());
  1178. // 单一承运商才进行匹配
  1179. if (carrierList != null && carrierList.size() == 1) {
  1180. List<Map<String, Object>> list = new ArrayList<>();
  1181. Map<String, Object> map1 = carrierList.get(0);
  1182. // 传入车序号主键和承运商id
  1183. map1.put("saleOrderMaterialId", saleOrderMaterialId);
  1184. map1.put("carrierId", map1.get("value"));
  1185. list.add(map1);
  1186. dispatchToCarrier(list);
  1187. }
  1188. }
  1189. if (isSelfMention.equals("是")) {
  1190. // 根据收货单位id查询出收货单位名称
  1191. String consigneeName = amsSaleOrderMapper.selectConsigneeName(receiveId);
  1192. // 根据收货单位名称查询承运商id
  1193. BigDecimal carrierId = amsSaleOrderMapper.selectCarrierId(consigneeName);
  1194. List<Map<String, Object>> list = new ArrayList<>();
  1195. Map<String,Object> map1 = new HashMap<>();
  1196. // 传入车序号主键和承运商id
  1197. if (carrierId != null) {
  1198. map1.put("saleOrderMaterialId", saleOrderMaterialId);
  1199. map1.put("carrierId", carrierId);
  1200. list.add(map1);
  1201. dispatchToCarrier(list);
  1202. }
  1203. }
  1204. // 收货方姓名
  1205. String consigneeName = String.valueOf(map.get("saleOrderConsignee"));
  1206. // 收货方电话
  1207. String consigneeTel = String.valueOf(map.get("saleOrderConsigneeTel"));
  1208. // 截止日期
  1209. String dateOfReceiptStr = String.valueOf(map.get("saleDateOfReceipt"));
  1210. Date dateOfReceipt = null;
  1211. if (!"null".equals(dateOfReceiptStr) && !"undefined".equals(dateOfReceiptStr)) {
  1212. dateOfReceipt = new Date(Long.valueOf(dateOfReceiptStr));
  1213. }
  1214. amsSaleOrderMaterial.setSaleOrderMaterialId(saleOrderMaterialId);
  1215. amsSaleOrderMaterial.setSaleOrderId(saleOrderId);
  1216. amsSaleOrderMaterial.setTruckRemark(truckRemark);
  1217. amsSaleOrderMaterial.setSaleOrderMaterialTruckNo(truckNo);
  1218. if (consigneeName != null && !consigneeName.equals("null")) {
  1219. amsSaleOrderMaterial.setSaleOrderConsignee(consigneeName);
  1220. }
  1221. if (consigneeTel != null && !consigneeTel.equals("null")) {
  1222. amsSaleOrderMaterial.setSaleOrderConsigneeTel(consigneeTel);
  1223. }
  1224. amsSaleOrderMaterial.setSaleDateOfReceipt(dateOfReceipt);
  1225. amsSaleOrderMaterial.setInsertTime(new Date());
  1226. amsSaleOrderMaterial.setUpdateTime(new Date());
  1227. amsSaleOrderMaterial.setInsertUpdateRemark("物流新增");
  1228. result += amsSaleOrderMaterialMapper.insertSelective(amsSaleOrderMaterial);
  1229. }
  1230. else {
  1231. amsSaleOrderMaterial = amsSaleOrderMaterials.get(0);
  1232. }
  1233. /*
  1234. 销售订单物资表
  1235. */
  1236. // 物资
  1237. BigDecimal materialId = DataChange.dataToBigDecimal(map.get("materialId"));
  1238. // 物资件数
  1239. BigDecimal materialNumber = DataChange.dataToBigDecimal(map.get("materialNumber"));
  1240. // 钢材米数
  1241. BigDecimal steelMeters = DataChange.dataToBigDecimal(map.get("steelMeters"));
  1242. // 是否磅重销售(0:磅重;1:理重)
  1243. BigDecimal isPoundSale = DataChange.dataToBigDecimal(map.get("isPoundSale"));
  1244. // 销售订单物资表主键
  1245. BigDecimal saleMaterialId = amsSaleMaterialMapper.selectMaxId();
  1246. amsSaleMaterial.setSaleMaterialId(saleMaterialId);
  1247. amsSaleMaterial.setSaleOrderId(saleOrderId);
  1248. amsSaleMaterial.setMaterialId(materialId);
  1249. amsSaleMaterial.setMaterialNumber(materialNumber);
  1250. amsSaleMaterial.setInsertTime(new Date());
  1251. amsSaleMaterial.setUpdateTime(new Date());
  1252. if (steelMeters != null && !steelMeters.toString().equals("0")) {
  1253. amsSaleMaterial.setSteelMeter(steelMeters);
  1254. }
  1255. amsSaleMaterial.setIsPoundSale(isPoundSale);
  1256. amsSaleMaterial.setInsertUpdateRemark("物流新增");
  1257. result += amsSaleMaterialMapper.insertSelective(amsSaleMaterial);
  1258. /*
  1259. 车序号物资表
  1260. */
  1261. // 车序号物资表主键
  1262. BigDecimal truckNoMaterialId = amsSaleTrucknoMaterialMapper.selectMaxId();
  1263. amsSaleTrucknoMaterial.setTrucknoMaterialId(truckNoMaterialId);
  1264. amsSaleTrucknoMaterial.setSaleOrderMaterialId(amsSaleOrderMaterial.getSaleOrderMaterialId());
  1265. amsSaleTrucknoMaterial.setMaterialId(amsSaleMaterial.getSaleMaterialId());
  1266. amsSaleTrucknoMaterial.setSaleOrderMaterialNumber(materialNumber);
  1267. amsSaleTrucknoMaterial.setInsertTime(new Date());
  1268. amsSaleTrucknoMaterial.setUpdateTime(new Date());
  1269. amsSaleTrucknoMaterial.setInsertUpdateRemark("物流新增");
  1270. result += amsSaleTrucknoMaterialMapper.insertSelective(amsSaleTrucknoMaterial);
  1271. }
  1272. result += amsSaleOrderMapper.insertSelective(amsSaleOrder);
  1273. return result;
  1274. }
  1275. /**
  1276. * 自动匹配出最近的一个地址
  1277. * @param receiveId
  1278. * @return
  1279. */
  1280. @Override
  1281. public List<Map<String, Object>> matchingAddressRecently(BigDecimal receiveId) {
  1282. List<Map<String,Object>> mapList = amsSaleOrderMapper.matchingAddressRecently(receiveId);
  1283. List<Map<String,Object>> salerList = amsSaleOrderMapper.getSalerByReceiveId(receiveId);
  1284. if (mapList != null && mapList.size() != 0) {
  1285. if (salerList != null && salerList.size() !=0) {
  1286. Map<String, Object> salerMap = salerList.get(0);
  1287. for (Map<String, Object> map : mapList) {
  1288. map.putAll(salerMap);
  1289. }
  1290. }
  1291. }
  1292. return mapList;
  1293. }
  1294. /**
  1295. * 自动匹配上一条运单的司机电话
  1296. * @param capacityNumber
  1297. * @return
  1298. */
  1299. @Override
  1300. public String matchingDriverTelRecently(String capacityNumber) {
  1301. String driverTel = amsSaleOrderMapper.matchingDriverTelRecently(capacityNumber);
  1302. return driverTel;
  1303. }
  1304. /**
  1305. * 查询内转焦炭订单
  1306. * @param mapValue
  1307. * @return
  1308. */
  1309. @Override
  1310. public List<Map<String, Object>> getCokeInwardOrderList(Map<String, Object> mapValue) {
  1311. return amsSaleOrderMapper.getCokeInwardOrderList(mapValue);
  1312. }
  1313. /**
  1314. * 修改收货地址
  1315. * @param mapValue
  1316. * @return
  1317. */
  1318. @Transactional(rollbackFor = Exception.class)
  1319. @Override
  1320. public int updateCarAddress(Map<String, Object> mapValue) {
  1321. // 判断是否需要删除金蝶分录
  1322. Integer isCloseEas = (Integer) mapValue.get("isCloseEas");
  1323. int result = 0;
  1324. // 运输订单id
  1325. BigDecimal orderId = DataChange.dataToBigDecimal(mapValue.get("orderId"));
  1326. // 车序号id
  1327. BigDecimal saleOrderMaterialId = DataChange.dataToBigDecimal(mapValue.get("saleOrderMaterialId"));
  1328. // 是
  1329. if (isCloseEas == 0 && orderId != null && orderId.intValue() != 0) {
  1330. OmstruckOrder omstruckOrder = new OmstruckOrder();
  1331. omstruckOrder.setOrderId(orderId);
  1332. omstruckOrder.setOrderStatus(new BigDecimal(7));
  1333. omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  1334. // 得到销售订单物资表主键
  1335. List<Map<String,Object>> saleMaterialIdList = amsSaleOrderMapper.getSaleMaterialId(saleOrderMaterialId);
  1336. for (Map<String, Object> map : saleMaterialIdList) {
  1337. // 关闭销售订单物资子表
  1338. BigDecimal saleMaterialId = (BigDecimal) map.get("saleMaterialId");
  1339. AmsSaleMaterial amsSaleMaterial = new AmsSaleMaterial();
  1340. amsSaleMaterial.setDeleted(new BigDecimal(0));
  1341. amsSaleMaterial.setSaleMaterialId(saleMaterialId);
  1342. amsSaleMaterialMapper.updateByPrimaryKeySelective(amsSaleMaterial);
  1343. }
  1344. return 0;
  1345. }
  1346. // 判断是否需要修改派车
  1347. Object isNewCar = mapValue.get("isNewCar");
  1348. // 省市县ID
  1349. BigDecimal shippingAddressId = DataChange.dataToBigDecimal(mapValue.get("shipperAddressId"));
  1350. // 具体地址
  1351. String place = (String) mapValue.get("place");
  1352. AmsSaleOrderMaterial amsSaleOrderMaterial = amsSaleOrderMaterialMapper.selectByPrimaryKey(saleOrderMaterialId);
  1353. if (place != null && !"null".equals(place)) {
  1354. List<Map<String, Object>> placeIdList = amsSaleOrderMaterialMapper.getPlaceId(place,shippingAddressId);
  1355. if (placeIdList == null || placeIdList.size() == 0) {
  1356. RmsReceivePlace rmsReceivePlace = new RmsReceivePlace();
  1357. rmsReceivePlace.setPlaceId(rmsReceivePlaceMapper.selectMaxId());
  1358. rmsReceivePlace.setAddressId(shippingAddressId);
  1359. rmsReceivePlace.setAddressDeliveryAddress(place);
  1360. amsSaleOrderMaterial.setSaleShippingAddressId(rmsReceivePlace.getPlaceId());
  1361. rmsReceivePlaceMapper.insertSelective(rmsReceivePlace);
  1362. } else {
  1363. amsSaleOrderMaterial.setSaleShippingAddressId((BigDecimal) placeIdList.get(0).get("placeId"));
  1364. }
  1365. }
  1366. result += amsSaleOrderMaterialMapper.updateByPrimaryKeySelective(amsSaleOrderMaterial);
  1367. // 需要换车
  1368. if ((Integer) isNewCar == 0) {
  1369. // 根据车序号得到定向派单表主键
  1370. BigDecimal dispatchId = amsSaleOrderMapper.getDispatchId(saleOrderMaterialId);
  1371. if (dispatchId != null) {
  1372. amsDispatchSaleOrderMapper.deleteByPrimaryKey(dispatchId);
  1373. }
  1374. if (orderId != null) {
  1375. omstruckOrderMapper.deleteByPrimaryKey(orderId);
  1376. }
  1377. if (amsSaleOrderMaterial.getSaleShippingAddressId() != null) {
  1378. // 自动匹配承运商
  1379. List<Map<String, Object>> carrierList = getCarrierByPlace(amsSaleOrderMaterial.getSaleShippingAddressId());
  1380. // 单一承运商才进行匹配
  1381. if (carrierList != null && carrierList.size() == 1) {
  1382. List<Map<String, Object>> list = new ArrayList<>();
  1383. Map<String, Object> map1 = carrierList.get(0);
  1384. // 传入车序号主键和承运商id
  1385. map1.put("saleOrderMaterialId", saleOrderMaterialId);
  1386. map1.put("carrierId", map1.get("value"));
  1387. list.add(map1);
  1388. dispatchToCarrier(list);
  1389. }
  1390. }
  1391. }
  1392. return result;
  1393. }
  1394. /**
  1395. * 展示未匹配承运商的车序号
  1396. * @param mapValue
  1397. * @return
  1398. */
  1399. @Override
  1400. public List<Map<String, Object>> getSteelTruckNoList(Map<String, Object> mapValue) {
  1401. List<Map<String, Object>> resultList = amsSaleOrderMapper.getSteelTruckNoList(mapValue);
  1402. return resultList;
  1403. }
  1404. /**
  1405. * 展示车序号的详情
  1406. * @param saleOrderMaterialId
  1407. * @return
  1408. */
  1409. @Override
  1410. public List<Map<String, Object>> getTruckNoMaterial(BigDecimal saleOrderMaterialId) {
  1411. List<Map<String,Object>> mapList = amsSaleOrderMapper.getTruckNoMaterialAndCarrier(saleOrderMaterialId);
  1412. for (Map<String,Object> map : mapList) {
  1413. BigDecimal placeId = (BigDecimal) map.get("placeId");
  1414. if (placeId != null) {
  1415. List<Map<String, Object>> carrierAndPriceList = getCarrierByPlace(placeId);
  1416. map.put("carrierAndPriceList", carrierAndPriceList);
  1417. }
  1418. }
  1419. return mapList;
  1420. }
  1421. /**
  1422. * 展示已分配承运商但未派车的车序号
  1423. * @param mapValue
  1424. * @return
  1425. */
  1426. @Override
  1427. public List<Map<String, Object>> getNoCarTruckNoList(Map<String, Object> mapValue) {
  1428. List<Map<String, Object>> resultList = amsSaleOrderMapper.getCarrierTruckNoList(mapValue);
  1429. return resultList;
  1430. }
  1431. /**
  1432. * 展示已派车的车序号
  1433. * @param mapValue
  1434. * @return
  1435. */
  1436. @Override
  1437. public List<Map<String, Object>> getHaveCarTruckNoList(Map<String, Object> mapValue) {
  1438. List<Map<String, Object>> resultList = amsSaleOrderMapper.getHaveCarTruckNoList(mapValue);
  1439. return resultList;
  1440. }
  1441. /**
  1442. * 修改销售订单中的物资
  1443. * @param mapValue
  1444. * @return
  1445. */
  1446. @Transactional(rollbackFor = Exception.class)
  1447. @Override
  1448. public int updateAllMaterialInSale(Map<String, Object> mapValue) {
  1449. int result = 0;
  1450. // 得到销售订单主键
  1451. BigDecimal saleOrderId = DataChange.dataToBigDecimal(mapValue.get("saleOrderId"));
  1452. BigDecimal saleOrderMaterialId = DataChange.dataToBigDecimal(mapValue.get("saleOrderMaterialId"));
  1453. BigDecimal orderId = DataChange.dataToBigDecimal(mapValue.get("orderId"));
  1454. // 将车辆改为不可作业状态
  1455. OmstruckOrder omstruckOrder = new OmstruckOrder();
  1456. omstruckOrder.setOrderId(orderId);
  1457. omstruckOrder.setCanWork(new BigDecimal(1));
  1458. omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  1459. // 得到运单中的物资
  1460. List<Map<String, Object>> oldList = omstruckOrderMaterialMapper.getMaterialList(orderId);
  1461. Map<String, Object> toTmsMap = new HashMap<>();
  1462. Map<String, Object> truckNoMap = new HashMap<>();
  1463. truckNoMap.put("saleOrderMaterialId",saleOrderMaterialId);
  1464. toTmsMap.put("orderId", orderId);
  1465. toTmsMap.put("oldMaterialMapList", oldList);
  1466. // 得到所有的物资
  1467. List<Map<String, Object>> mapList = (List<Map<String, Object>>) mapValue.get("mapList");
  1468. /*
  1469. 删除三个物资表数据
  1470. */
  1471. List<AmsSaleTrucknoMaterial> amsSaleTrucknoMaterials = amsSaleTrucknoMaterialMapper.selectByParameters(truckNoMap);
  1472. for (AmsSaleTrucknoMaterial amsSaleTrucknoMaterial : amsSaleTrucknoMaterials) {
  1473. // 销售订单物资子表
  1474. amsSaleMaterialMapper.deleteByPrimaryKey(amsSaleTrucknoMaterial.getMaterialId());
  1475. // 车序号子表
  1476. amsSaleTrucknoMaterialMapper.deleteByPrimaryKey(amsSaleTrucknoMaterial.getTrucknoMaterialId());
  1477. }
  1478. // 运输订单物资子表
  1479. List<OmstruckOrderMaterial> omstruckOrderMaterials = omstruckOrderMaterialMapper.selectByParameters(toTmsMap);
  1480. for (OmstruckOrderMaterial omstruckOrderMaterial : omstruckOrderMaterials) {
  1481. omstruckOrderMaterialMapper.deleteByPrimaryKey(omstruckOrderMaterial.getOrderMaterialId());
  1482. }
  1483. /*
  1484. 重新新增三个表
  1485. */
  1486. for (Map<String, Object> map : mapList) {
  1487. Object saleMaterialId = map.get("saleMaterialId");
  1488. BigDecimal materialId = DataChange.dataToBigDecimal(map.get("materialId"));
  1489. BigDecimal materialNumber = DataChange.dataToBigDecimal(map.get("orderPlanWeight"));
  1490. Object trucknoMaterialId = map.get("trucknoMaterialId");
  1491. BigDecimal isPoundSale = DataChange.dataToBigDecimal(map.get("isPound"));
  1492. Object materialWeight = map.get("materialWeight");
  1493. Object steelMeter = map.get("meterNumber");
  1494. Object easId = map.get("easId");
  1495. Object warehouse = map.get("warehouse");
  1496. // 销售订单分录表
  1497. AmsSaleMaterial amsSaleMaterial = new AmsSaleMaterial();
  1498. // 车序号子表
  1499. AmsSaleTrucknoMaterial amsSaleTrucknoMaterial = new AmsSaleTrucknoMaterial();
  1500. // 运输订单子表
  1501. OmstruckOrderMaterial omstruckOrderMaterial = new OmstruckOrderMaterial();
  1502. // if (saleMaterialId != null) {
  1503. // amsSaleMaterial.setSaleMaterialId(DataChange.dataToBigDecimal(saleMaterialId));
  1504. // amsSaleTrucknoMaterial.setTrucknoMaterialId(DataChange.dataToBigDecimal(trucknoMaterialId));
  1505. // }
  1506. // if (saleMaterialId == null){
  1507. amsSaleMaterial.setSaleMaterialId(amsSaleMaterialMapper.selectMaxId());
  1508. amsSaleTrucknoMaterial.setTrucknoMaterialId(amsSaleTrucknoMaterialMapper.selectMaxId());
  1509. // }
  1510. if (easId != null) {
  1511. amsSaleMaterial.setEasPrimaryId(easId.toString());
  1512. }
  1513. if (warehouse != null) {
  1514. amsSaleMaterial.setSaleWarehouse(warehouse.toString());
  1515. }
  1516. if (steelMeter != null) {
  1517. amsSaleMaterial.setSteelMeter(DataChange.dataToBigDecimal(steelMeter));
  1518. }
  1519. if (materialWeight != null) {
  1520. amsSaleMaterial.setMaterialWeight(DataChange.dataToBigDecimal(materialWeight));
  1521. omstruckOrderMaterial.setOrderMaterialWeight(DataChange.dataToBigDecimal(materialWeight));
  1522. }
  1523. amsSaleMaterial.setSaleOrderId(saleOrderId);
  1524. amsSaleMaterial.setIsPoundSale(isPoundSale);
  1525. amsSaleMaterial.setMaterialId(materialId);
  1526. amsSaleMaterial.setDeleted(new BigDecimal(0));
  1527. amsSaleMaterial.setMaterialNumber(materialNumber);
  1528. amsSaleMaterial.setUpdateTime(new Date());
  1529. result += amsSaleMaterialMapper.insertSelective(amsSaleMaterial);
  1530. // 车序号子表
  1531. amsSaleTrucknoMaterial.setSaleOrderMaterialId(saleOrderMaterialId);
  1532. amsSaleTrucknoMaterial.setMaterialId(amsSaleMaterial.getSaleMaterialId());
  1533. amsSaleTrucknoMaterial.setSaleOrderMaterialNumber(materialNumber);
  1534. amsSaleTrucknoMaterial.setUpdateTime(new Date());
  1535. result += amsSaleTrucknoMaterialMapper.insertSelective(amsSaleTrucknoMaterial);
  1536. // 运输订单子表
  1537. omstruckOrderMaterial.setOrderMaterialId(omstruckOrderMaterialMapper.selectMaxId());
  1538. omstruckOrderMaterial.setOrderId(orderId);
  1539. omstruckOrderMaterial.setMaterialId(materialId);
  1540. omstruckOrderMaterial.setOrderMaterialNumber(materialNumber);
  1541. result += omstruckOrderMaterialMapper.insertSelective(omstruckOrderMaterial);
  1542. }
  1543. // 得到运单中的物资
  1544. List<Map<String, Object>> newList = omstruckOrderMaterialMapper.getMaterialList(orderId);
  1545. toTmsMap.put("newMaterialMapList", newList);
  1546. // 修改实绩结果
  1547. Map<String, Object> updateResult = tmsTruckFeign.update(toTmsMap);
  1548. System.out.println(updateResult);
  1549. return result;
  1550. }
  1551. /**
  1552. * 副产品订单
  1553. * @param map
  1554. * @return
  1555. */
  1556. @Override
  1557. public List<Map<String, Object>> getFuSaleOrderList(Map<String, Object> map) {
  1558. List<Map<String, Object>> resultList = amsSaleOrderMapper.getFuSaleOrderList(map);
  1559. return resultList;
  1560. }
  1561. /**
  1562. * 同步关闭金蝶销售订单
  1563. * @param mapValue
  1564. * @return
  1565. */
  1566. @Override
  1567. public int deleteSaleOrderSame(Map<String, Object> mapValue) {
  1568. int result = 0;
  1569. String reason = (String) mapValue.get("reason");
  1570. String number = (String) mapValue.get("number");
  1571. String wholeOrder = "1";
  1572. String status = "close";
  1573. Map<String,Object> head = new HashMap<>();
  1574. // 销售订单号
  1575. head.put("number",number);
  1576. // 关闭原因
  1577. head.put("reason",reason);
  1578. // 是否整单
  1579. head.put("wholeOrder",wholeOrder);
  1580. // 发送状态
  1581. head.put("status",status);
  1582. Map<String,Object> input = new HashMap<>();
  1583. Map<String, Object> totalMap = easDeleteUtil.getTotalMap();
  1584. input.put("head",head);
  1585. totalMap.put("input",input);
  1586. // 调用金蝶关闭接口
  1587. String json = JSONUtils.toJSONString(totalMap);
  1588. System.out.println(json);
  1589. Map<String,Object> resultMap = joinFeign.deleteSaleOrderToEas(totalMap);
  1590. System.out.println(resultMap);
  1591. BigDecimal saleOrderId = DataChange.dataToBigDecimal(mapValue.get("saleOrderId"));
  1592. AmsSaleOrder amsSaleOrder = new AmsSaleOrder();
  1593. amsSaleOrder.setSaleOrderId(saleOrderId);
  1594. amsSaleOrder.setDeleted(new BigDecimal(2));
  1595. amsSaleOrder.setInsertUpdateRemark(reason);
  1596. result += amsSaleOrderMapper.closeOrderNotIn(saleOrderId);
  1597. result += amsSaleOrderMapper.updateByPrimaryKeySelective(amsSaleOrder);
  1598. return result;
  1599. }
  1600. /**
  1601. * 展示反审批的钢材订单
  1602. * @param mapValue
  1603. * @return
  1604. */
  1605. @Override
  1606. public List<Map<String, Object>> getSteelOrderDeletedList(Map<String, Object> mapValue) {
  1607. List<Map<String, Object>> mapList = amsSaleOrderMapper.getSteelOrderDeletedList(mapValue);
  1608. return mapList;
  1609. }
  1610. /**
  1611. * 展示所有状态销售订单列表
  1612. * @param mapValue
  1613. * @return
  1614. */
  1615. @Override
  1616. public List<Map<String, Object>> getAllSteelSaleOrderList(Map<String, Object> mapValue) {
  1617. return amsSaleOrderMapper.getAllSteelSaleOrderList(mapValue);
  1618. }
  1619. /**
  1620. * 修改厂内未装货车辆的运单车牌号
  1621. * @param mapValue
  1622. * @return
  1623. */
  1624. @Override
  1625. public int updateCapacityNumberInFactory(Map<String, Object> mapValue) {
  1626. Object lineSequence = mapValue.get("lineSequence");
  1627. int result = 0;
  1628. if (lineSequence == null || "0".equals(lineSequence.toString()) || "1".equals(lineSequence.toString()) || "2".equals(lineSequence.toString())) {
  1629. result += amsSaleOrderMapper.updateCapacityNumberInFactory(mapValue);
  1630. }
  1631. return result;
  1632. }
  1633. @Override
  1634. public List<Map<String, Object>> getSaleMaterialId(BigDecimal saleOrderMaterialId) {
  1635. return amsSaleOrderMapper.getSaleMaterialId(saleOrderMaterialId);
  1636. }
  1637. /**
  1638. * 展示下发给承运商的车序号和物资
  1639. * @param map
  1640. * @return
  1641. */
  1642. @Override
  1643. public List<Map<String, Object>> getCarrierTruckNoAndMaterialList(Map<String,Object> map) {
  1644. Object carrierSsoId = map.get("carrierSsoId");
  1645. if (carrierSsoId != null && ("".equals(carrierSsoId)) || "null".equals(carrierSsoId) || "undefined".equals(carrierSsoId)) {
  1646. map.replace("carrierSsoId",null);
  1647. }
  1648. List<Map<String,Object>> mapList = amsSaleOrderMapper.getTruckNoAndMaterial(map);
  1649. for (Map<String,Object> mapValue : mapList) {
  1650. BigDecimal placeId = (BigDecimal) mapValue.get("placeId");
  1651. if (placeId != null) {
  1652. List<Map<String, Object>> carrierAndPriceList = getCarrierByPlace(placeId);
  1653. mapValue.put("carrierAndPriceList", carrierAndPriceList);
  1654. }
  1655. }
  1656. return mapList;
  1657. }
  1658. /**
  1659. * 同步关闭金蝶物资分录
  1660. * @param mapValue
  1661. * @return
  1662. */
  1663. @Override
  1664. @Transactional
  1665. public int closeSteelMaterialId(Map<String, Object> mapValue) {
  1666. int result = 0;
  1667. Object orderId = mapValue.get("orderId");
  1668. Integer orderStatus = (Integer) mapValue.get("orderStatus");
  1669. BigDecimal saleOrderMaterialId = DataChange.dataToBigDecimal(mapValue.get("saleOrderMaterialId"));
  1670. List<Map<String, Object>> loadIdList = amsSaleMaterialMapper.findLoadIdList(saleOrderMaterialId);
  1671. List<Map<String, Object>> weightIdList = amsSaleMaterialMapper.findWeightIdList(saleOrderMaterialId);
  1672. String reason = (String) mapValue.get("reason");
  1673. BigDecimal saleMaterialId = DataChange.dataToBigDecimal(mapValue.get("saleMaterialId"));
  1674. // 如果还未派车
  1675. if (orderId == null) {
  1676. // 订单子表设为关闭状态
  1677. AmsSaleMaterial amsSaleMaterial = new AmsSaleMaterial();
  1678. amsSaleMaterial.setSaleMaterialId(saleMaterialId);
  1679. amsSaleMaterial.setDeleted(new BigDecimal(0));
  1680. amsSaleMaterial.setInsertUpdateRemark(reason);
  1681. result += amsSaleMaterialMapper.updateByPrimaryKeySelective(amsSaleMaterial);
  1682. return result;
  1683. }
  1684. // 订单子表设为关闭状态
  1685. AmsSaleMaterial amsSaleMaterial = new AmsSaleMaterial();
  1686. amsSaleMaterial.setSaleMaterialId(saleMaterialId);
  1687. amsSaleMaterial.setDeleted(new BigDecimal(0));
  1688. amsSaleMaterial.setInsertUpdateRemark(reason);
  1689. result += amsSaleMaterialMapper.updateByPrimaryKeySelective(amsSaleMaterial);
  1690. // 已派车
  1691. if (loadIdList == null || loadIdList.size() == 0) {
  1692. return result;
  1693. }
  1694. // 删除实绩表
  1695. Map<String, Object> loadMap = loadIdList.get(0);
  1696. Map<String, Object> weightMap = weightIdList.get(0);
  1697. BigDecimal loadId = (BigDecimal) loadMap.get("loadId");
  1698. BigDecimal weightId = (BigDecimal) weightMap.get("weightId");
  1699. result += amsSaleMaterialMapper.updateOrderMaterialToClose(mapValue);
  1700. result += amsSaleMaterialMapper.deleteLoadResult(loadId);
  1701. result += amsSaleMaterialMapper.deleteWeightResult(weightId);
  1702. result += amsSaleMaterialMapper.deleteWmspOutResult(mapValue);
  1703. return result;
  1704. }
  1705. /**
  1706. * 展示已审核化产焦炭销售订单列表
  1707. * @param mapValue
  1708. * @return
  1709. */
  1710. @Override
  1711. public List<Map<String, Object>> getSaleCokeOrder(Map<String, Object> mapValue) {
  1712. List<Map<String, Object>> resultList = amsSaleOrderMapper.getSaleCokeOrder(mapValue);
  1713. return resultList;
  1714. }
  1715. /**
  1716. * 反关闭金蝶单个分录
  1717. * @param saleMaterialId
  1718. * @return
  1719. */
  1720. @Override
  1721. public int adverseCloseSaleMaterial(BigDecimal saleMaterialId) {
  1722. Map<String,Object> head = new HashMap<>();
  1723. Map<String,Object> input = new HashMap<>();
  1724. // 0:代表不关闭整单
  1725. String wholeOrder = "0";
  1726. // unClose : 代表反关闭
  1727. String status = "unClose";
  1728. AmsSaleMaterial amsSaleMaterial = amsSaleMaterialMapper.selectByPrimaryKey(saleMaterialId);
  1729. int result = amsSaleMaterialMapper.adverseCloseSaleMaterial(saleMaterialId);
  1730. AmsSaleOrder amsSaleOrder = amsSaleOrderMapper.selectByPrimaryKey(amsSaleMaterial.getSaleOrderId());
  1731. // 根据分录id查询运单id,物资id,总实绩id
  1732. Map<String,Object> saleMaterialMap = amsSaleOrderMapper.getSaleMaterialMessage(saleMaterialId);
  1733. BigDecimal orderId = (BigDecimal) saleMaterialMap.get("orderId");
  1734. BigDecimal orderStatus = (BigDecimal) saleMaterialMap.get("orderStatus");
  1735. if (orderId != null && orderStatus.intValue() == 5) {
  1736. BigDecimal resultTotalId = (BigDecimal) saleMaterialMap.get("resultTotalId");
  1737. BigDecimal materialId = (BigDecimal) saleMaterialMap.get("materialId");
  1738. // 根据总实绩id查询订单中的最大路段顺序号
  1739. int maxNum = amsSaleOrderMapper.findOrderMaxNum(resultTotalId);
  1740. // 得到皮重顺序号
  1741. int tareNum = maxNum - 3;
  1742. // 得到装货顺序号
  1743. int loadNum = maxNum - 2;
  1744. // 得到毛重顺序号
  1745. int grossNum = maxNum - 1;
  1746. // 装货实绩
  1747. TmstruckLoadResult tmstruckLoadResult = new TmstruckLoadResult();
  1748. TmstruckWeightResult tmstruckWeightResult = new TmstruckWeightResult();
  1749. tmstruckLoadResult.setResultId(tmstruckLoadResultMapper.selectMaxId());
  1750. tmstruckLoadResult.setResultTotalId(resultTotalId);
  1751. tmstruckLoadResult.setMaterialId(materialId);
  1752. tmstruckLoadResult.setSegmentSqe(new BigDecimal(loadNum));
  1753. result += tmstruckLoadResultMapper.insertSelective(tmstruckLoadResult);
  1754. // 计量实绩
  1755. tmstruckWeightResult.setWeightTaskResultId(tmstruckWeightResultMapper.selectMaxId());
  1756. tmstruckWeightResult.setResultTotalId(resultTotalId);
  1757. tmstruckWeightResult.setMaterialId(materialId);
  1758. tmstruckWeightResult.setResultTarePlaceId(new BigDecimal(10));
  1759. tmstruckWeightResult.setResultGrossPlaceId(new BigDecimal(2));
  1760. tmstruckWeightResult.setGrossSegmentSqe(new BigDecimal(grossNum));
  1761. tmstruckWeightResult.setTareSegmentSqe(new BigDecimal(tareNum));
  1762. result += tmstruckWeightResultMapper.insertSelective(tmstruckWeightResult);
  1763. // 出库子表
  1764. BigDecimal outBoundId = (BigDecimal) saleMaterialMap.get("outBoundId");
  1765. BigDecimal materialNumber = (BigDecimal) saleMaterialMap.get("materialNumber");
  1766. if (outBoundId != null) {
  1767. BigDecimal resultMaterialId = wmspOutboundResultMaterialMapper.getSeqNumber("seq__WMSP_OUTBOUND_RESUL_TMATRIAL");
  1768. WmspOutboundResultMaterial wmspOutboundResultMaterial = new WmspOutboundResultMaterial();
  1769. wmspOutboundResultMaterial.setResultMaterialId(resultMaterialId);
  1770. wmspOutboundResultMaterial.setOutboundResultId(outBoundId);
  1771. wmspOutboundResultMaterial.setMaterialId(materialId);
  1772. wmspOutboundResultMaterial.setMaterialNumber(materialNumber);
  1773. wmspOutboundResultMaterial.setInsertTime(new Date());
  1774. wmspOutboundResultMaterial.setInsertUsername("admin");
  1775. wmspOutboundResultMaterial.setStatus(new BigDecimal(1));
  1776. result += wmspOutboundResultMaterialMapper.insertSelective(wmspOutboundResultMaterial);
  1777. }
  1778. }
  1779. // 设置反关闭分录id
  1780. head.put("unCloseEntryId",amsSaleMaterial.getEasPrimaryId());
  1781. // 设置是否整单
  1782. head.put("wholeOrder",wholeOrder);
  1783. // 设置销售订单号
  1784. head.put("number",amsSaleOrder.getSaleNumber());
  1785. // 设置状态:unClose,反关闭;close,关闭
  1786. head.put("status",status);
  1787. input.put("head",head);
  1788. // 测试
  1789. Map<String, Object> totalMap = easDeleteUtil.getTotalMap();
  1790. // 正式
  1791. // Map<String, Object> totalMap = easDeleteUtil.getTotalMap();
  1792. input.put("head",head);
  1793. totalMap.put("input",input);
  1794. // 调用金蝶关闭接口
  1795. String json = JSONUtils.toJSONString(totalMap);
  1796. System.out.println(json);
  1797. Map<String,Object> resultMap = joinFeign.deleteSaleOrderToEas(totalMap);
  1798. System.out.println(resultMap);
  1799. return result;
  1800. }
  1801. /**
  1802. * 反关闭金蝶整个销售订单
  1803. * @param saleOrderId
  1804. * @return
  1805. */
  1806. @Override
  1807. public int adverseCloseSaleOrder(BigDecimal saleOrderId) {
  1808. Map<String,Object> head = new HashMap<>();
  1809. Map<String,Object> input = new HashMap<>();
  1810. // 0:代表不关闭整单
  1811. String wholeOrder = "1";
  1812. // unClose : 代表反关闭
  1813. String status = "unClose";
  1814. AmsSaleOrder amsSaleOrder = amsSaleOrderMapper.selectByPrimaryKey(saleOrderId);
  1815. amsSaleOrder.setDeleted(new BigDecimal(0));
  1816. // 开启所有的分录
  1817. int result = amsSaleMaterialMapper.openAllSaleMaterial(amsSaleOrder.getSaleOrderId());
  1818. result += amsSaleOrderMapper.updateByPrimaryKeySelective(amsSaleOrder);
  1819. // 设置是否整单
  1820. head.put("wholeOrder",wholeOrder);
  1821. // 设置销售订单号
  1822. head.put("number",amsSaleOrder.getSaleNumber());
  1823. // 设置状态:unClose,反关闭;close,关闭
  1824. head.put("status",status);
  1825. input.put("head",head);
  1826. // 测试
  1827. Map<String, Object> totalMap = easDeleteUtil.getTotalMap();
  1828. // 正式
  1829. // Map<String, Object> totalMap = easDeleteUtil.getTotalMap();
  1830. input.put("head",head);
  1831. totalMap.put("input",input);
  1832. // 调用金蝶关闭接口
  1833. String json = JSONUtils.toJSONString(totalMap);
  1834. System.out.println(json);
  1835. Map<String,Object> resultMap = joinFeign.deleteSaleOrderToEas(totalMap);
  1836. System.out.println(resultMap);
  1837. return result;
  1838. }
  1839. @Override
  1840. public List<Map<String, Object>> getKucunList(Map<String, Object> map) {
  1841. return amsSaleOrderMapper.getKucunList(map);
  1842. }
  1843. }