AmsSaleOrderController.java 58 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224
  1. package com.steerinfo.dil.controller;
  2. import com.alibaba.druid.support.json.JSONUtils;
  3. import com.steerinfo.dil.feign.ColumnDataFeign;
  4. import com.steerinfo.dil.feign.ESFeign;
  5. import com.steerinfo.dil.feign.JoinFeign;
  6. import com.steerinfo.dil.mapper.AmsDispatchSaleOrderMapper;
  7. import com.steerinfo.dil.model.AmsDispatchSaleOrder;
  8. import com.steerinfo.dil.service.IAmsSaleOrderService;
  9. import com.steerinfo.dil.service.impl.AmsDispatchSaleOrderServiceImpl;
  10. import com.steerinfo.dil.service.impl.AmsSaleOrderCarrierServiceImpl;
  11. import com.steerinfo.dil.service.impl.AmsSaleOrderMaterialServiceImpl;
  12. import com.steerinfo.dil.util.*;
  13. import com.steerinfo.framework.controller.RESTfulResult;
  14. import com.steerinfo.framework.service.pagehelper.PageHelper;
  15. import io.swagger.annotations.ApiImplicitParam;
  16. import io.swagger.annotations.ApiImplicitParams;
  17. import io.swagger.annotations.ApiModelProperty;
  18. import io.swagger.annotations.ApiOperation;
  19. import org.springframework.beans.factory.annotation.Autowired;
  20. import org.springframework.transaction.annotation.Transactional;
  21. import org.springframework.web.bind.annotation.*;
  22. import java.math.BigDecimal;
  23. import java.text.ParseException;
  24. import java.text.SimpleDateFormat;
  25. import java.util.Date;
  26. import java.util.HashMap;
  27. import java.util.List;
  28. import java.util.Map;
  29. //import com.sun.org.apache.bcel.internal.generic.IF_ACMPEQ;
  30. /**
  31. * AmsSaleOrder RESTful接口:
  32. * @author generator
  33. * @version 1.0-SNAPSHORT 2021-09-06 07:10
  34. * 类描述
  35. * 修订历史:
  36. * 日期:2021-09-06
  37. * 作者:generator
  38. * 参考:
  39. * 描述:AmsSaleOrder RESTful接口
  40. * @see null
  41. * @Copyright 湖南视拓信息技术股份有限公司. All rights reserved.
  42. */
  43. @RestController
  44. @RequestMapping("/${api.version}/amssaleorders")
  45. public class AmsSaleOrderController extends BaseRESTfulController {
  46. @Autowired
  47. IAmsSaleOrderService amsSaleOrderService;
  48. @Autowired
  49. AmsSaleOrderMaterialServiceImpl amsSaleOrderMaterialService;
  50. @Autowired
  51. AmsDispatchSaleOrderServiceImpl amsDispatchSaleOrderService;
  52. @Autowired
  53. ColumnDataFeign columnDataFeign;
  54. @Autowired
  55. AmsDispatchSaleOrderMapper amsDispatchSaleOrderMapper;
  56. @Autowired
  57. ColumnDataUtil columnDataUtil;
  58. @Autowired
  59. ESFeign esFeign;
  60. @Autowired
  61. AmsSaleOrderCarrierServiceImpl amsSaleOrderCarrierService;
  62. @Autowired
  63. EASTestUtil easTestUtil;
  64. @Autowired
  65. EASUtil easUtil;
  66. @Autowired
  67. JoinFeign joinFeign;
  68. @Autowired
  69. EASDeleteUtil easDeleteUtil;
  70. @Autowired
  71. EASCapacityTestUtil easCapacityTestUtil;
  72. private final SimpleDateFormat sdfDateTime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
  73. @ApiOperation(value="查询未上报销售订单信息")
  74. @ApiImplicitParams({
  75. @ApiImplicitParam(name = "apiId(98)", value = "表头", required = false, dataType = "Interger")
  76. })
  77. @PostMapping("/getSaleOrderInfo")
  78. public RESTfulResult getSaleOrderInfo(@RequestBody(required=false) Map<String,Object> mapValue,
  79. Integer apiId,
  80. Integer pageNum,
  81. Integer pageSize){
  82. PageHelper.startPage(pageNum,pageSize);
  83. List<Map<String, Object>> amsSaleOrder1 = amsSaleOrderService.getSaleOrderInfo(mapValue);
  84. PageListAdd pageList = columnDataUtil.tableColumnData(apiId, null,amsSaleOrder1);
  85. return success(pageList);
  86. }
  87. @ApiOperation(value="查询已上报销售订单信息")
  88. @ApiImplicitParams({
  89. @ApiImplicitParam(name = "apiId(98)", value = "表头", required = false, dataType = "Interger")
  90. })
  91. @PostMapping("/getSaleOrderReported")
  92. public RESTfulResult getSaleOrderReported(@RequestBody(required=false) Map<String,Object> mapValue,
  93. Integer apiId,
  94. Integer pageNum,
  95. Integer pageSize){
  96. PageHelper.startPage(pageNum,pageSize);
  97. List<Map<String, Object>> amsSaleOrder1 = amsSaleOrderService.getSaleOrderReported(mapValue);
  98. PageListAdd pageList = columnDataUtil.tableColumnData(apiId, null,amsSaleOrder1);
  99. return success(pageList);
  100. }
  101. @ApiOperation(value="查询财务已审批销售订单信息")
  102. @ApiImplicitParams({
  103. @ApiImplicitParam(name = "apiId(105)", value = "表头", required = false, dataType = "Interger")
  104. })
  105. @PostMapping("/getAmsSaleOrderApproved")
  106. public RESTfulResult getAmsSaleOrderApproved(@RequestBody(required=false) Map<String,Object> mapValue,
  107. Integer apiId,
  108. Integer pageNum,
  109. Integer pageSize){
  110. PageHelper.startPage(pageNum,pageSize);
  111. List<Map<String, Object>> amsSaleOrder1 = amsSaleOrderService.getAmsSaleOrderApproved(mapValue);
  112. PageListAdd pageList = columnDataUtil.tableColumnData(apiId, null,amsSaleOrder1);
  113. return success(pageList);
  114. }
  115. @ApiOperation(value="根据销售订单号查询销售订单详细信息")
  116. @ApiImplicitParams({
  117. @ApiImplicitParam(name = "apiId(100)", value = "表头", required = false, dataType = "Interger")
  118. })
  119. @PostMapping("/getSaleOrderDetail")
  120. public RESTfulResult getSaleOrderDetail(BigDecimal saleOrderId,@RequestBody(required=false) Map<String,Object> mapValue,
  121. Integer apiId,
  122. Integer pageNum,
  123. Integer pageSize){
  124. if (mapValue == null) {
  125. mapValue = new HashMap<>();
  126. }
  127. mapValue.put("saleOrderId",saleOrderId);
  128. PageHelper.startPage(pageNum,pageSize);
  129. List<Map<String, Object>> amsSaleOrderDetail1 = amsSaleOrderService.getSaleOrderDetail(mapValue);
  130. PageListAdd pageList = columnDataUtil.tableColumnData(apiId, null,amsSaleOrderDetail1);
  131. return success(pageList);
  132. }
  133. /**
  134. * 上传销售订单
  135. * @param saleOrderId
  136. * @return
  137. */
  138. @ApiOperation(value="上传销售订单")
  139. @ApiImplicitParams({
  140. @ApiImplicitParam(name = "saleOrderId", value = "销售订单ID", required = false, dataType = "java.math.BigDecimal")
  141. })
  142. @PostMapping(value = "/uploadSaleOrder")
  143. public RESTfulResult uploadSaleOrder(@RequestParam BigDecimal saleOrderId) throws Exception {
  144. int i = amsSaleOrderService.uploadSaleOrder(saleOrderId);
  145. return success(i);
  146. }
  147. /**
  148. * 新增销售订单
  149. * @param map
  150. * @return
  151. */
  152. @ApiOperation(value="新增销售订单")
  153. @ApiImplicitParams({
  154. @ApiImplicitParam(name = "amsSaleOrder", value = "销售订单对象", required = false, dataType = "AmsSaleOrder")
  155. })
  156. @PostMapping(value = "/addAmsSaleOrder")
  157. public RESTfulResult addAmsSaleOrder(@RequestBody(required = false) Map<String, Object> map) throws ParseException {
  158. int i = amsSaleOrderService.addAmsSaleOrder(map);
  159. return success(i);
  160. }
  161. /**
  162. * 通过主键渲染销售订单信息
  163. * @param saleOrderId
  164. * @return
  165. */
  166. @ApiOperation(value="通过主键渲染销售订单信息")
  167. @ApiImplicitParams({
  168. @ApiImplicitParam(name = "saleOrderId", value = "主键Id", required = false, dataType = "java.math.BigDecimal")
  169. })
  170. @PostMapping(value = "/getAmsSaleOrderBySaleOrderId")
  171. public RESTfulResult getAmsSaleOrderBySaleOrderId(@RequestParam BigDecimal saleOrderId){
  172. Map<String, Object> maps = amsSaleOrderService.selectInfoBySaleOrderId(saleOrderId);
  173. List<Map<String, Object>> maps1= amsSaleOrderService.selectMaterialInfoBySaleOrderId(saleOrderId);
  174. Map map=new HashMap();
  175. map.put("maps",maps);
  176. map.put("maps1",maps1);
  177. return success(map);
  178. }
  179. /**steelMaterialId
  180. * 通过主键修改销售订单
  181. * @param map
  182. * @return
  183. */
  184. @ApiOperation(value="通过主键修改销售订单")
  185. @ApiImplicitParams({
  186. @ApiImplicitParam(name = "amsSaleOrder", value = "销售订单对象", required = false, dataType = "AmsSaleOrder")
  187. })
  188. @PostMapping(value = "/updateAmsSaleOrder")
  189. public RESTfulResult updateAmsSaleOrder(@RequestBody(required = false) Map<String,Object> map) throws ParseException {
  190. int i = amsSaleOrderService.updateAmsSaleOrder(map);
  191. return success(i);
  192. }
  193. /**
  194. * 通过主键删除销售订单
  195. * @param saleOrderId
  196. * @return
  197. */
  198. @ApiOperation(value="通过主键删除销售订单")
  199. @ApiImplicitParams({
  200. @ApiImplicitParam(name = "saleOrderId", value = "主键Id", required = false, dataType = "java.math.BigDecimal")
  201. })
  202. @PostMapping(value = "/deleteAmsSaleOrderBySaleOrderId")
  203. public RESTfulResult deleteAmsSaleOrderBySaleOrderId(BigDecimal saleOrderId){
  204. int i = amsSaleOrderService.deleteAmsSaleOrderBySaleOrderId(saleOrderId);
  205. return success(i);
  206. }
  207. @ApiOperation(value="根据销售订单号查询销售订单修改日志")
  208. @ApiImplicitParams({
  209. @ApiImplicitParam(name = "apiId(100)", value = "表头", required = false, dataType = "Interger")
  210. })
  211. @PostMapping("/getSaleOrderUpdateLog")
  212. public RESTfulResult getSaleOrderUpdateLog(BigDecimal saleOrderId,@RequestBody(required=false) Map<String,Object> mapValue,
  213. Integer apiId,
  214. Integer pageNum,
  215. Integer pageSize){
  216. if (mapValue == null) {
  217. mapValue = new HashMap<>();
  218. }
  219. mapValue.put("saleOrderId",saleOrderId);
  220. PageHelper.startPage(pageNum,pageSize);
  221. List<Map<String, Object>> amsSaleOrderUpdate1 = amsSaleOrderService.getSaleOrderUpdateLog(mapValue);
  222. PageListAdd pageList = columnDataUtil.tableColumnData(apiId, null,amsSaleOrderUpdate1);
  223. return success(pageList);
  224. }
  225. /**
  226. * 获取销售计划名称
  227. * @param
  228. * @return
  229. */
  230. @ApiOperation(value="获取销售计划名称")
  231. @ApiImplicitParams({
  232. })
  233. @GetMapping(value = "/getSalePlanName")
  234. public RESTfulResult getSalePlanName(){
  235. return success(amsSaleOrderService.getSalePlanName());
  236. }
  237. /**
  238. * 获取发货单位
  239. * @param
  240. * @return
  241. */
  242. @ApiOperation(value="获取发货单位")
  243. @ApiImplicitParams({
  244. })
  245. @GetMapping(value = "/getShipperName")
  246. public RESTfulResult getShipperName(){
  247. return success(amsSaleOrderService.getShipperName());
  248. }
  249. /**
  250. * 获取收货单位
  251. * @param
  252. * @return
  253. */
  254. @ApiOperation(value="获取收货单位")
  255. @ApiImplicitParams({
  256. })
  257. @GetMapping(value = "/getConsigneeCompanyName")
  258. public RESTfulResult getConsigneeCompanyName(){
  259. return success(amsSaleOrderService.getConsigneeCompanyName());
  260. }
  261. /**
  262. * 展示销售公司已审核销售订单的车序号列表
  263. * @param mapValue
  264. * @param pageNum
  265. * @param pageSize
  266. * @param apiId
  267. * @return
  268. */
  269. @ApiModelProperty(value = "展示销售公司已审核销售订单的车序号列表")
  270. @ApiImplicitParams({
  271. @ApiImplicitParam(name = "pageNum", value = "查询页数", required = false, dataType = "Integer"),
  272. @ApiImplicitParam(name = "pageSize", value = "每页记录数", required = false, dataType = "Integer"),
  273. @ApiImplicitParam(name = "apiId", value = "181", required = false, dataType = "BigDecimal")
  274. })
  275. @PostMapping("/getSaleOrderList")
  276. public RESTfulResult getSaleOrderList(@RequestBody(required = false) Map<String,Object> mapValue,
  277. Integer pageNum,
  278. Integer pageSize,
  279. Integer apiId,
  280. Integer status,
  281. String con) {
  282. if (status!=null){
  283. mapValue.put("status",status);
  284. }
  285. PageHelper.startPage(pageNum,pageSize);
  286. //分页数据
  287. List<Map<String, Object>> saleOrderList = amsSaleOrderService.getSaleOrderList(mapValue);
  288. PageListAdd pageList = columnDataUtil.tableColumnData(apiId, null,saleOrderList);
  289. return success(pageList);
  290. }
  291. /**
  292. * 销售公司查询已审核的订单
  293. *
  294. */
  295. @ApiModelProperty(value = "展示销售公司已审核销售订单的车序号列表")
  296. @ApiImplicitParams({
  297. @ApiImplicitParam(name = "pageNum", value = "查询页数", required = false, dataType = "Integer"),
  298. @ApiImplicitParam(name = "pageSize", value = "每页记录数", required = false, dataType = "Integer"),
  299. @ApiImplicitParam(name = "apiId", value = "181", required = false, dataType = "BigDecimal")
  300. })
  301. @PostMapping("/getSaleOrderListBySaleCompany")
  302. public RESTfulResult getSaleOrderListBySaleCompany(@RequestBody(required = false) Map<String,Object> mapValue,
  303. Integer pageNum,
  304. Integer pageSize,
  305. Integer apiId) {
  306. PageHelper.startPage(pageNum,pageSize);
  307. //分页数据
  308. List<Map<String, Object>> saleOrderList = amsSaleOrderService.getSaleOrderListBySaleCompany(mapValue);
  309. PageListAdd pageList = columnDataUtil.tableColumnData(apiId, null,saleOrderList);
  310. return success(pageList);
  311. }
  312. /**
  313. * 固定派单:通过车序号查询收货地址,截取收货地址的区域,去资源管理中查询对应的承运商,将车序号与承运商绑定
  314. */
  315. @PostMapping("/addAmsDispatchSaleOrder")
  316. public RESTfulResult addAmsDispatchSaleOrder(@RequestBody(required = false) List<Map<String,Object>> mapValue){
  317. // if(mapValue==null){
  318. // return failed();
  319. // }
  320. // for (Map<String,Object> m:mapValue
  321. // ) {
  322. // Integer id = Integer.parseInt(m.get("saleOrderMaterialId").toString()) ;
  323. // System.out.println(id);
  324. // //通过主键Id获取地址id
  325. // Integer a=amsSaleOrderMaterialService.selectById(new BigDecimal(id));
  326. // //通过地址id查询省市县
  327. // Map<String,Object> province = amsSaleOrderService.getCarrier(a);
  328. // //根据省市县查询承运商
  329. // List<Map<String,Object>> carrierList=amsSaleOrderService.selectCarrierIdByprovince(province);
  330. // //判断是否只有一个承运商
  331. // //如果收货地区为成都重庆,则有多个一个地区对应多个承运商
  332. // if(carrierList.size()==1) {
  333. // //新增固定派单
  334. // AmsDispatchSaleOrder ad = new AmsDispatchSaleOrder();
  335. // ad.setDispatchId(DataChange.dataToBigDecimal(m.get("dispatchId")));
  336. // ad.setSaleOrderMaterialId(new BigDecimal(id));
  337. // ad.setCarrierId(carrierList.get(0));
  338. // ad.setDispatchDealTime(new Date());
  339. // ad.setDispatchTime(new Date());
  340. // //成交类型(0:定向派单;1:公开抢单)
  341. // ad.setDispatchType(new BigDecimal(0));
  342. // //销售订单车序号状态(0:已下发;1:未下发)
  343. // ad.setDispatchStatus(new BigDecimal(0));
  344. // int i = amsDispatchSaleOrderMapper.updateByPrimaryKeySelective(ad);
  345. // return success(i);
  346. // }
  347. // }
  348. int result = amsSaleOrderService.addAmsDispatchSaleOrder(mapValue);
  349. return success(result);
  350. }
  351. /**
  352. * 公开派单:查询未分派车辆的销售订单的车序号
  353. */
  354. @ApiModelProperty(value = "展示车序号列表")
  355. @ApiImplicitParams({
  356. @ApiImplicitParam(name = "pageNum", value = "查询页数", required = false, dataType = "Integer"),
  357. @ApiImplicitParam(name = "pageSize", value = "每页记录数", required = false, dataType = "Integer"),
  358. @ApiImplicitParam(name = "apiId", value = "182", required = false, dataType = "BigDecimal")
  359. })
  360. @PostMapping("/getAmsSaleOrderMaterial")
  361. public RESTfulResult getAmsSaleOrderMaterial(@RequestBody(required = false) Map<String,Object> mapValue,
  362. Integer pageNum,
  363. Integer pageSize,
  364. Integer apiId,
  365. Integer status) {
  366. mapValue.put("status",status);
  367. PageHelper.startPage(pageNum, pageSize);
  368. //分页查询数据
  369. List<Map<String, Object>> columnList = amsSaleOrderMaterialService.getSaleMaterial(mapValue);
  370. PageListAdd data = columnDataUtil.tableColumnData(apiId, null, columnList);
  371. return success(data);
  372. }
  373. /**
  374. * 公开派单:新增公开派单
  375. */
  376. @PostMapping("/addOpenAmsDispatchSaleOrder/{orderMaterialId}")
  377. public RESTfulResult addOpenAmsDispatchSaleOrder(@PathVariable("orderMaterialId") BigDecimal orderMaterialId){
  378. if(orderMaterialId==null){
  379. return failed();
  380. }
  381. //新增公开派单
  382. AmsDispatchSaleOrder ad = new AmsDispatchSaleOrder();
  383. Integer id = amsDispatchSaleOrderMapper.selectDispatchIdBySaleOrderMaterialId(orderMaterialId.intValue());
  384. ad.setDispatchId(DataChange.dataToBigDecimal(id));
  385. ad.setSaleOrderMaterialId(orderMaterialId);
  386. //成交类型(0:定向派单;1:公开抢单)
  387. ad.setDispatchType(new BigDecimal(1));
  388. //销售订单车序号状态(0:已下发;1:未下发)
  389. ad.setDispatchStatus(new BigDecimal(1));
  390. //更新公开派单状态
  391. amsDispatchSaleOrderMapper.updateByPrimaryKeySelective(ad);
  392. return success("更新成功");
  393. }
  394. /**
  395. * 删除公开派单
  396. */
  397. @PostMapping("/deleteAmsDispatchSaleOrder/{dispatchId}")
  398. public RESTfulResult deleteAmsDispatchSaleOrder(@PathVariable("dispatchId") BigDecimal dispatchId) {
  399. amsDispatchSaleOrderService.delete(dispatchId);
  400. return success("删除成功");
  401. }
  402. /**
  403. * 公开派单:查询公开派单
  404. */
  405. @ApiModelProperty(value = "展示公开派单")
  406. @ApiImplicitParams({
  407. @ApiImplicitParam(name = "pageNum", value = "查询页数", required = false, dataType = "Integer"),
  408. @ApiImplicitParam(name = "pageSize", value = "每页记录数", required = false, dataType = "Integer"),
  409. @ApiImplicitParam(name = "apiId", value = "181", required = false, dataType = "BigDecimal")
  410. })
  411. @PostMapping("/getOpenDispatchSaleOrder")
  412. public RESTfulResult getOpenDispatchSaleOrder(@RequestBody(required = false) Map<String,Object> mapValue,
  413. Integer pageNum,
  414. Integer pageSize,
  415. Integer apiId) {
  416. PageHelper.startPage(pageNum, pageSize);
  417. //分页查询数据
  418. List<Map<String, Object>> columnList = amsDispatchSaleOrderService.getOpenDispatchSaleOrder(mapValue);
  419. PageListAdd data = columnDataUtil.tableColumnData(apiId, null, columnList);
  420. return success(data);
  421. }
  422. /**
  423. *公开派单:修改公开派单
  424. */
  425. @PostMapping("/updateOpenDispatchSaleOrder")
  426. public RESTfulResult updateOpenDispatchSaleOrder(@RequestBody AmsDispatchSaleOrder amsDispatchSaleOrder) {
  427. if(amsDispatchSaleOrder.getCarrierId()!=null){
  428. amsDispatchSaleOrder.setDispatchStatus(new BigDecimal(1));
  429. }
  430. amsDispatchSaleOrder.setDispatchDealTime(new Date());
  431. amsDispatchSaleOrder.setUpdateTime(new Date());
  432. amsDispatchSaleOrder.setUpdateUsername("admin");
  433. amsDispatchSaleOrderService.modify(amsDispatchSaleOrder);
  434. return success("修改成功");
  435. }
  436. @ApiOperation(value="查询未上报的销售订单信息")
  437. @ApiImplicitParams({
  438. @ApiImplicitParam(name = "apiId(408)", value = "表头", required = false, dataType = "Interger")
  439. })
  440. @PostMapping("/getSaleOrderInfoes")
  441. public RESTfulResult getSaleOrderInfoes(@RequestBody(required=false) Map<String,Object> mapValue,
  442. Integer apiId,
  443. Integer pageNum,
  444. Integer pageSize,
  445. String consigneeSsoId,
  446. String con,
  447. String startTime,
  448. String endTime,
  449. String saler
  450. ){
  451. if (consigneeSsoId != null && !"".equals(consigneeSsoId) && !"null".equals(consigneeSsoId)) {
  452. mapValue.put("consigneeSsoId",consigneeSsoId);
  453. }
  454. if (con != null && !"".equals(con) && !"null".equals(con)) {
  455. mapValue.put("con",con);
  456. }
  457. if (saler != null && !"".equals(saler) && !"null".equals(saler)){
  458. mapValue.put("saler",saler);
  459. }
  460. DataChange.queryDataByDateTime(startTime, endTime, mapValue, sdfDateTime);//根据时间段查询数据
  461. PageHelper.startPage(pageNum,pageSize);
  462. List<Map<String, Object>> amsSaleOrder1 = amsSaleOrderService.getSaleOrderInfoes(mapValue);
  463. PageListAdd pageList = columnDataUtil.tableColumnData4(apiId, null,amsSaleOrder1);
  464. return success(pageList);
  465. }
  466. @ApiOperation(value="查询已上报销售订单信息")
  467. @ApiImplicitParams({
  468. @ApiImplicitParam(name = "apiId(408)", value = "表头", required = false, dataType = "Interger")
  469. })
  470. @PostMapping("/getSaleOrderReportedes")
  471. public RESTfulResult getSaleOrderReportedes(@RequestBody(required=false) Map<String,Object> mapValue,
  472. Integer apiId,
  473. Integer pageNum,
  474. Integer pageSize,
  475. String consigneeSsoId,
  476. String con,
  477. String startTime,
  478. String endTime,
  479. String saler){
  480. if (consigneeSsoId != null && !"".equals(consigneeSsoId) && !"null".equals(consigneeSsoId)) {
  481. mapValue.put("consigneeSsoId",consigneeSsoId);
  482. }
  483. if (con != null && !"".equals(con) && !"null".equals(con)) {
  484. mapValue.put("con",con);
  485. }
  486. if (saler != null && !"".equals(saler) && !"null".equals(saler)) {
  487. mapValue.put("saler",saler);
  488. }
  489. DataChange.queryDataByDateTime(startTime, endTime, mapValue, sdfDateTime);//根据时间段查询数据
  490. PageHelper.startPage(pageNum,pageSize);
  491. List<Map<String, Object>> amsSaleOrder1 = amsSaleOrderService.getSaleOrderReportedes(mapValue);
  492. PageListAdd pageList = columnDataUtil.tableColumnData4(apiId, null,amsSaleOrder1);
  493. return success(pageList);
  494. }
  495. @ApiModelProperty(value = "展示已审核销售订单列表")
  496. @ApiImplicitParams({
  497. @ApiImplicitParam(name = "pageNum", value = "查询页数", required = false, dataType = "Integer"),
  498. @ApiImplicitParam(name = "pageSize", value = "每页记录数", required = false, dataType = "Integer"),
  499. @ApiImplicitParam(name = "apiId", value = "409/475", required = false, dataType = "BigDecimal")
  500. })
  501. @PostMapping("/getSaleOrderListBySaleCompanyes")
  502. public RESTfulResult getSaleOrderListBySaleCompanyes(@RequestBody(required = false) Map<String,Object> mapValue,
  503. Integer pageNum,
  504. Integer pageSize,
  505. Integer apiId,
  506. String con,
  507. Integer shipperId,
  508. @RequestParam(required = false) Integer saleType,
  509. String consigneeSsoId,
  510. @RequestParam(required = false) String startTime,
  511. @RequestParam(required = false)String endTime,
  512. String saler
  513. ) {
  514. if (con != null && !"".equals(con) && !"null".equals(con)) {
  515. mapValue.put("con", con);
  516. }
  517. if(shipperId != null && !"".equals(shipperId) && !"null".equals(shipperId)){
  518. mapValue.put("shipperId", shipperId);
  519. }
  520. if (consigneeSsoId != null && !"".equals(consigneeSsoId) && !"null".equals(consigneeSsoId)) {
  521. mapValue.put("consigneeSsoId",consigneeSsoId);
  522. }
  523. if (saler != null && !"".equals(saler) && !"null".equals(saler)) {
  524. mapValue.put("saler",saler);
  525. }
  526. mapValue.put("saleType",saleType);
  527. DataChange.queryDataByDateTime(startTime, endTime, mapValue, sdfDateTime);//根据时间段查询数据
  528. // SimpleDateFormat simpleDateFormat=new SimpleDateFormat("yyyy-MM-dd");
  529. // if(startDate != null && !"".equals(startDate) && !"null".equals(startDate)){
  530. // Date startTime=new Date(Long.parseLong(startDate));
  531. // String startTime1=simpleDateFormat.format(startTime);
  532. // mapValue.put("startTime",startTime1);
  533. // }
  534. // if(endDate != null && !"".equals(endDate) && !"null".equals(endDate)){
  535. // Date endTime=new Date(Long.parseLong(endDate));
  536. // String endTime1=simpleDateFormat.format(endTime);
  537. // mapValue.put("endTime",endTime1);
  538. // }
  539. //不分页筛选数据
  540. PageHelper.startPage(pageNum,pageSize);
  541. //分页数据
  542. List<Map<String, Object>> saleOrderList = amsSaleOrderService.getSaleOrderListBySaleCompanyes(mapValue);
  543. PageListAdd pageList = columnDataUtil.tableColumnData4(apiId, null,saleOrderList);
  544. return success(pageList);
  545. }
  546. @ApiOperation(value="查询财务已审批销售订单信息")
  547. @ApiImplicitParams({
  548. @ApiImplicitParam(name = "apiId(409)", value = "表头", required = false, dataType = "Interger")
  549. })
  550. @PostMapping("/getAmsSaleOrderApprovedes")
  551. public RESTfulResult getAmsSaleOrderApprovedes(@RequestBody(required=false) Map<String,Object> mapValue,
  552. Integer apiId,
  553. Integer pageNum,
  554. Integer pageSize,
  555. @RequestParam String con){
  556. if (con != null && !"undefined".equals(con)) {
  557. mapValue.put("con", con);
  558. }
  559. PageHelper.startPage(pageNum,pageSize);
  560. List<Map<String, Object>> amsSaleOrder1 = amsSaleOrderService.getAmsSaleOrderApprovedes(mapValue);
  561. PageListAdd pageList = columnDataUtil.tableColumnData(apiId, null,amsSaleOrder1);
  562. return success(pageList);
  563. }
  564. /*
  565. * 根据销售订单主键展示销售基本信息、物资信息
  566. * apiId:410
  567. * */
  568. @PostMapping(value="/getSaleOrderAndMaterialById")
  569. public RESTfulResult getSaleOrderAndMaterialById(@RequestBody(required=false) Map<String,Object> mapValue,
  570. Integer apiId,
  571. Integer pageNum,
  572. Integer pageSize,
  573. BigDecimal saleOrderId){
  574. if (mapValue == null) {
  575. mapValue = new HashMap<>();
  576. }
  577. mapValue.put("saleOrderId",saleOrderId);
  578. PageHelper.startPage(pageNum,pageSize);
  579. List<Map<String, Object>> columndata = amsSaleOrderService.getSaleOrderAndMaterialById(mapValue);
  580. PageListAdd pageList = columnDataUtil.tableColumnData(apiId, null,columndata);
  581. return success(pageList);
  582. }
  583. @ApiModelProperty(value = "展示销售焦炭订单列表")
  584. @ApiImplicitParams({
  585. @ApiImplicitParam(name = "pageNum", value = "查询页数", required = false, dataType = "Integer"),
  586. @ApiImplicitParam(name = "pageSize", value = "每页记录数", required = false, dataType = "Integer"),
  587. @ApiImplicitParam(name = "apiId", value = "409", required = false, dataType = "BigDecimal")
  588. })
  589. @PostMapping("/getCokeSaleOrderList")
  590. public RESTfulResult getCokeSaleOrderList(@RequestBody(required = false) Map<String,Object> mapValue,
  591. Integer pageNum,
  592. Integer pageSize,
  593. Integer apiId,
  594. String con) {
  595. if (con != null && !con.equals("undefined")) {
  596. mapValue.put("con","%" + con + "%");
  597. }
  598. //不分页筛选数据
  599. PageHelper.startPage(pageNum,pageSize);
  600. //分页数据
  601. List<Map<String, Object>> saleOrderList = amsSaleOrderService.getCokeSaleOrderList(mapValue);
  602. PageListAdd pageList = columnDataUtil.tableColumnData(apiId, null,saleOrderList);
  603. return success(pageList);
  604. }
  605. @ApiModelProperty(value = "销售订单批量授权给承运商")
  606. @PostMapping("/saleOrderEmpowerCarrier")
  607. public RESTfulResult saleOrderEmpowerCarrier(@RequestBody(required = false) Map<String,Object> mapValue) {
  608. //获得订单ID集合 saleOrderIds
  609. List<Map<String,Integer>> saleOrderIds= (List<Map<String, Integer>>) mapValue.get("saleOrderIds");
  610. //获得承运商 carrierId
  611. BigDecimal carrierId= new BigDecimal(mapValue.get("carrierId").toString());
  612. //销售订单授权承运商中间表
  613. int i= amsSaleOrderCarrierService.addAmsSaleOrderCarrier(carrierId,saleOrderIds);
  614. return success(i);
  615. }
  616. @ApiModelProperty(value = "展示销售公司下发给承运商的销售订单列表")
  617. @ApiImplicitParams({
  618. @ApiImplicitParam(name = "pageNum", value = "查询页数", required = false, dataType = "Integer"),
  619. @ApiImplicitParam(name = "pageSize", value = "每页记录数", required = false, dataType = "Integer"),
  620. @ApiImplicitParam(name = "apiId", value = "409", required = false, dataType = "BigDecimal")
  621. })
  622. @PostMapping("/getSaleOrderListByCarrierSsoId")
  623. public RESTfulResult getSaleOrderListByCarrierSsoId(@RequestBody(required = false) Map<String,Object> mapValue,
  624. String carrierSsoId,
  625. Integer pageNum,
  626. Integer pageSize,
  627. Integer apiId,
  628. String con) {
  629. if (con != null && !"".equals(con) && !"null".equals(con)) {
  630. mapValue.put("con", con);
  631. }
  632. if (carrierSsoId!=null){
  633. mapValue.put("carrierSsoId",carrierSsoId);
  634. }
  635. //不分页筛选数据
  636. PageHelper.startPage(pageNum,pageSize);
  637. //分页数据
  638. List<Map<String, Object>> saleOrderList = amsSaleOrderService.getSaleOrderListByCarrierSsoId(mapValue);
  639. PageListAdd pageList = columnDataUtil.tableColumnData(apiId, null,saleOrderList);
  640. return success(pageList);
  641. }
  642. @ApiModelProperty(value = "新增钢材销售订单")
  643. @PostMapping("/addSteelSaleOrder")
  644. public RESTfulResult addSteelSaleOrder(@RequestBody Map<String,Object> mapValue) {
  645. int result = amsSaleOrderService.addSteelSaleOrder(mapValue);
  646. return success(result);
  647. }
  648. @ApiModelProperty(value = "展示销售订单下的车序号和物资")
  649. @PostMapping("/getTruckNoAndMaterialList")
  650. public RESTfulResult getTruckNoAndMaterialList(@RequestParam Integer saleOrderId) {
  651. List<Map<String,Object>> mapList = amsSaleOrderService.getTruckNoAndMaterialList(new BigDecimal(saleOrderId));
  652. return success(mapList);
  653. }
  654. @ApiModelProperty(value = "钢材派单")
  655. @PostMapping("/dispatchSteelOrder")
  656. public RESTfulResult dispatchSteelOrder(@RequestBody List<Map<String,Object>> mapList) throws Exception {
  657. int result = amsSaleOrderService.dispatchSteelOrder(mapList);
  658. if (result == 0) {
  659. return failed("匹配不到车牌号!");
  660. }
  661. else {
  662. for (Map<String, Object> map : mapList) {
  663. // 调用EAS接口将车牌号传给金蝶
  664. BigDecimal saleOrderMaterialId = new BigDecimal((Integer) map.get("saleOrderMaterialId")) ;
  665. Map<String,Object> input = joinFeign.findCarNumberByOrderId(saleOrderMaterialId);
  666. Map<String, Object> totalMap = easCapacityTestUtil.getTotalMap();
  667. totalMap.put("input",input);
  668. System.out.println(totalMap);
  669. String json = JSONUtils.toJSONString(totalMap);
  670. System.out.println(json);
  671. Map<String,Object> s = joinFeign.pushCarNumberToEas(totalMap);
  672. if (s == null || s.size() == 0) {
  673. throw new Exception("登录金蝶失败");
  674. }
  675. System.out.println(s);
  676. }
  677. return success(result);
  678. }
  679. }
  680. @ApiModelProperty(value = "根据详细地址匹配承运商")
  681. @GetMapping("/getCarrierByPlace")
  682. public RESTfulResult getCarrierByPlace(@RequestParam Integer placeId) {
  683. List<Map<String,Object>> result = amsSaleOrderService.getCarrierByPlace(new BigDecimal(placeId));
  684. return success(result);
  685. }
  686. @ApiModelProperty(value = "根据详细地址和承运商匹配单价")
  687. @PostMapping("/getPriceByCarrierAndPlace")
  688. public RESTfulResult getPriceByCarrierAndPlace(@RequestBody Map<String,Object> mapValue) {
  689. Map<String,Object> result = amsSaleOrderService.getPriceByCarrierAndPlace(mapValue);
  690. return success(result);
  691. }
  692. @ApiModelProperty(value = "将车序号下发给承运商")
  693. @PostMapping("/dispatchToCarrier")
  694. public RESTfulResult dispatchToCarrier(@RequestBody List<Map<String,Object>> mapList) {
  695. int result = amsSaleOrderService.dispatchToCarrier(mapList);
  696. return success(result);
  697. }
  698. @ApiModelProperty(value = "销售钢材承运商查询销售订单")
  699. @ApiImplicitParams({
  700. @ApiImplicitParam(name = "pageNum", value = "查询页数", required = false, dataType = "Integer"),
  701. @ApiImplicitParam(name = "pageSize", value = "每页记录数", required = false, dataType = "Integer"),
  702. @ApiImplicitParam(name = "apiId", value = "409", required = false, dataType = "BigDecimal")
  703. })
  704. @PostMapping("/getSaleOrderListToCarrier")
  705. public RESTfulResult getSaleOrderListToCarrier(@RequestBody(required = false) Map<String, Object> mapValue,
  706. Integer pageNum,
  707. Integer pageSize,
  708. Integer apiId,
  709. String carrierSsoId,
  710. String con,
  711. @RequestParam(required = false) String startTime,
  712. @RequestParam(required = false) String endTime) {
  713. if (con != null && !"".equals(con) && !"null".equals(con)) {
  714. mapValue.put("con", "%" + con + "%");
  715. }
  716. if ((carrierSsoId != null && !"".equals(carrierSsoId)) && !"undefined".equals(carrierSsoId) && !"null".equals(carrierSsoId)) {
  717. mapValue.put("carrierSsoId", carrierSsoId);
  718. }
  719. DataChange.queryDataByDateTime(startTime, endTime, mapValue,sdfDateTime);//根据时间段查询数据
  720. //不分页筛选数据
  721. PageHelper.startPage(pageNum, pageSize);
  722. //分页数据
  723. List<Map<String, Object>> saleOrderList = amsSaleOrderService.getSaleOrderListToCarrier(mapValue);
  724. PageListAdd pageList = columnDataUtil.tableColumnData(apiId, null, saleOrderList);
  725. return success(pageList);
  726. }
  727. /**
  728. * 展示未匹配承运商的车序号
  729. *
  730. * @param mapValue
  731. * @return
  732. */
  733. @ApiOperation(value = "展示未匹配承运商的车序号")
  734. @ApiImplicitParams({
  735. @ApiImplicitParam(name = "map", value = "销售订单物资信息map", required = false, dataType = "java.util.Map"),
  736. @ApiImplicitParam(name = "apiId", value = "411", required = false, dataType = "java.util.Map")
  737. })
  738. @PostMapping(value = "/getSteelTruckNoList")
  739. public RESTfulResult getSteelTruckNoList(@RequestBody(required = false) Map<String, Object> mapValue,
  740. Integer apiId,
  741. Integer pageNum,
  742. Integer pageSize,
  743. String con,
  744. @RequestParam(required = false) String startTime,
  745. @RequestParam(required = false)String endTime) {
  746. if (con != null && !con.equals("undefined") && !con.equals("null")) {
  747. mapValue.put("con", "%" + con + "%");
  748. }
  749. DataChange.queryDataByDateTime(startTime, endTime, mapValue,sdfDateTime);//根据时间段查询数据
  750. PageHelper.startPage(pageNum, pageSize);
  751. //分页数据
  752. List<Map<String, Object>> saleOrderList = amsSaleOrderService.getSteelTruckNoList(mapValue);
  753. PageListAdd pageList = columnDataUtil.tableColumnData(apiId,null, saleOrderList);
  754. return success(pageList);
  755. }
  756. @ApiModelProperty(value = "展示销售订单下的车序号和物资")
  757. @PostMapping("/getTruckNoMaterial")
  758. public RESTfulResult getTruckNoMaterial(@RequestParam Integer saleOrderMaterialId) {
  759. List<Map<String,Object>> mapList = amsSaleOrderService.getTruckNoMaterial(new BigDecimal(saleOrderMaterialId));
  760. return success(mapList);
  761. }
  762. /**
  763. * 展示已分配承运商但未派车的车序号
  764. *
  765. * @param mapValue
  766. * @return
  767. */
  768. @ApiOperation(value = "展示已分配承运商但未派车的车序号")
  769. @ApiImplicitParams({
  770. @ApiImplicitParam(name = "map", value = "销售订单物资信息map", required = false, dataType = "java.util.Map"),
  771. @ApiImplicitParam(name = "apiId", value = "466", required = false, dataType = "java.util.Map")
  772. })
  773. @PostMapping(value = "/getNoCarTruckNoList")
  774. public RESTfulResult getNoCarTruckNoList(@RequestBody(required = false) Map<String, Object> mapValue,
  775. Integer apiId,
  776. Integer pageNum,
  777. Integer pageSize,
  778. String con,
  779. @RequestParam(required = false) String startTime,
  780. @RequestParam(required = false)String endTime) {
  781. if (con != null && !con.equals("undefined") && !con.equals("null")) {
  782. mapValue.put("con", "%" + con + "%");
  783. }
  784. DataChange.queryDataByDateTime(startTime, endTime, mapValue,sdfDateTime);//根据时间段查询数据
  785. PageHelper.startPage(pageNum, pageSize);
  786. //分页数据
  787. List<Map<String, Object>> saleOrderList = amsSaleOrderService.getNoCarTruckNoList(mapValue);
  788. PageListAdd pageList = columnDataUtil.tableColumnData(apiId,null, saleOrderList);
  789. return success(pageList);
  790. }
  791. /**
  792. * 展示已派车的车序号
  793. *
  794. * @param mapValue
  795. * @return
  796. */
  797. @ApiOperation(value = "展示已派车的车序号")
  798. @ApiImplicitParams({
  799. @ApiImplicitParam(name = "map", value = "销售订单物资信息map", required = false, dataType = "java.util.Map"),
  800. @ApiImplicitParam(name = "apiId", value = "466", required = false, dataType = "java.util.Map")
  801. })
  802. @PostMapping(value = "/getHaveCarTruckNoList")
  803. public RESTfulResult getHaveCarTruckNoList(@RequestBody(required = false) Map<String, Object> mapValue,
  804. Integer apiId,
  805. Integer pageNum,
  806. Integer pageSize,
  807. String con,
  808. String startTime,
  809. String endTime) {
  810. if (con != null && !con.equals("undefined") && !con.equals("null")) {
  811. mapValue.put("con", "%" + con + "%");
  812. }
  813. DataChange.queryDataByDateTime(startTime, endTime, mapValue,sdfDateTime);//根据时间段查询数据
  814. PageHelper.startPage(pageNum, pageSize);
  815. //分页数据
  816. List<Map<String, Object>> saleOrderList = amsSaleOrderService.getHaveCarTruckNoList(mapValue);
  817. PageListAdd pageList = columnDataUtil.tableColumnData(apiId,null, saleOrderList);
  818. return success(pageList);
  819. }
  820. @ApiModelProperty(value = "删除上一条销售订单")
  821. @PostMapping("/deleteSaleOrderById")
  822. public RESTfulResult deleteSaleOrderById(@RequestParam Integer saleOrderId) {
  823. int result = amsSaleOrderService.deleteSaleOrderById(new BigDecimal(saleOrderId));
  824. return success(result);
  825. }
  826. @ApiModelProperty(value = "查询出销售订单下的所有数据")
  827. @PostMapping("/getAllSaleMessages")
  828. public RESTfulResult getAllSaleMessages(@RequestParam Integer saleOrderId) {
  829. Map<String,Object> saleMap = amsSaleOrderService.getAllSaleMessages(new BigDecimal(saleOrderId));
  830. return success(saleMap);
  831. }
  832. @ApiModelProperty(value = "修改承运商授权")
  833. @PostMapping("/updateTruckNoCarrier")
  834. public RESTfulResult updateTruckNoCarrier(@RequestBody Map<String,Object> mapValue) {
  835. int result = amsSaleOrderService.updateTruckNoCarrier(mapValue);
  836. return success(result);
  837. }
  838. /**
  839. * 批量上传销售订单
  840. * @param saleOrderIdList
  841. * @return
  842. */
  843. @ApiOperation(value="批量上传销售订单")
  844. @ApiImplicitParams({
  845. @ApiImplicitParam(name = "saleOrderId", value = "销售订单ID", required = false, dataType = "java.math.BigDecimal")
  846. })
  847. @PostMapping(value = "/uploadSaleOrderList")
  848. public RESTfulResult uploadSaleOrderList(@RequestBody List<Map<String,Object>> saleOrderIdList){
  849. int i = amsSaleOrderService.uploadSaleOrderList(saleOrderIdList);
  850. return success(i);
  851. }
  852. @ApiModelProperty(value = "新增钒渣销售订单")
  853. @PostMapping("/addVanadiumSaleOrder")
  854. public RESTfulResult addVanadiumSaleOrder(@RequestBody Map<String,Object> mapValue) {
  855. int result = amsSaleOrderService.addVanadiumSaleOrder(mapValue);
  856. return success(result);
  857. }
  858. @ApiModelProperty(value = "自动匹配出最近的一个地址")
  859. @PostMapping("/matchingAddressRecently")
  860. public RESTfulResult matchingAddressRecently(@RequestParam BigDecimal receiveId) {
  861. List<Map<String,Object>> mapList = amsSaleOrderService.matchingAddressRecently(receiveId);
  862. return success(mapList);
  863. }
  864. @ApiModelProperty(value = "自动匹配上一条运单的司机电话")
  865. @PostMapping("/matchingDriverTelRecently")
  866. public RESTfulResult matchingDriverTelRecently(@RequestParam String capacityNumber) {
  867. String driverTel = amsSaleOrderService.matchingDriverTelRecently(capacityNumber);
  868. return success(driverTel);
  869. }
  870. /**
  871. * 查询内转焦炭订单
  872. *
  873. * @param mapValue
  874. * @return
  875. */
  876. @ApiOperation(value = "查询内转焦炭订单")
  877. @ApiImplicitParams({
  878. @ApiImplicitParam(name = "map", value = "查询内转焦炭订单", required = false, dataType = "java.util.Map"),
  879. @ApiImplicitParam(name = "apiId", value = "168", required = false, dataType = "java.util.Map")
  880. })
  881. @PostMapping(value = "/getCokeInwardOrderList")
  882. public RESTfulResult getCokeInwardOrderList(@RequestBody(required = false) Map<String, Object> mapValue,
  883. Integer apiId,
  884. Integer pageNum,
  885. Integer pageSize,
  886. Integer orderStatus,
  887. String con) {
  888. if (con != null && !con.equals("undefined") && !con.equals("null")) {
  889. mapValue.put("con", "%" + con + "%");
  890. }
  891. if (orderStatus != null) {
  892. mapValue.put("orderStatus",orderStatus);
  893. }
  894. PageHelper.startPage(pageNum, pageSize);
  895. //分页数据
  896. List<Map<String, Object>> saleOrderList = amsSaleOrderService.getCokeInwardOrderList(mapValue);
  897. PageListAdd pageList = columnDataUtil.tableColumnData(apiId,null, saleOrderList);
  898. return success(pageList);
  899. }
  900. /**
  901. * 修改收货地址
  902. *
  903. * @param mapValue
  904. * @return
  905. */
  906. @ApiOperation(value = "修改收货地址")
  907. @ApiImplicitParams({
  908. @ApiImplicitParam(name = "map", value = "修改收货地址", required = false, dataType = "java.util.Map")
  909. })
  910. @PostMapping(value = "/updateCarAddress")
  911. @Transactional
  912. public RESTfulResult updateCarAddress(@RequestBody Map<String, Object> mapValue) throws Exception {
  913. int result = amsSaleOrderService.updateCarAddress(mapValue);
  914. if (result == 0) {
  915. // 如果返回结果为0,则认定是关闭了车辆
  916. BigDecimal saleOrderMaterialId = DataChange.dataToBigDecimal(mapValue.get("saleOrderMaterialId"));
  917. List<Map<String, Object>> saleMaterialIdList = amsSaleOrderService.getSaleMaterialId(saleOrderMaterialId);
  918. String wholeOrder = "0";
  919. String status = "close";
  920. String reason = "收货地址修改超过片区范围";
  921. // 循环调用关闭金蝶分录接口
  922. for (Map<String, Object> head : saleMaterialIdList) {
  923. head.put("wholeOrder", wholeOrder);
  924. head.put("status", status);
  925. head.put("reason", reason);
  926. Map<String, Object> input = new HashMap<>();
  927. input.put("head", head);
  928. Map<String, Object> totalMap = easDeleteUtil.getTotalMap();
  929. totalMap.put("input", input);
  930. String json = JSONUtils.toJSONString(totalMap);
  931. System.out.println("--------------------------------------------");
  932. System.out.println(json);
  933. System.out.println("--------------------------------------------");
  934. Map<String, Object> resultMap = joinFeign.deleteSaleOrderToEas(totalMap);
  935. System.out.println("--------------------------------------------");
  936. System.out.println(resultMap);
  937. }
  938. }
  939. return success(result);
  940. }
  941. /**
  942. * 修改销售订单中的物资
  943. *
  944. * @param mapValue
  945. * @return
  946. */
  947. @ApiOperation(value = "修改销售订单中的物资")
  948. @ApiImplicitParams({
  949. @ApiImplicitParam(name = "map", value = "修改收货地址", required = false, dataType = "java.util.Map")
  950. })
  951. @PostMapping(value = "/updateAllMaterialInSale")
  952. public RESTfulResult updateAllMaterialInSale(@RequestBody Map<String, Object> mapValue) {
  953. //分页数据
  954. int result = amsSaleOrderService.updateAllMaterialInSale(mapValue);
  955. BigDecimal saleOrderId = DataChange.dataToBigDecimal(mapValue.get("saleOrderId"));
  956. // 调用金蝶接口,将销售订单推送到金蝶系统
  957. Map<String, Object> input = joinFeign.getSaleOrder(saleOrderId);
  958. Map<String, Object> head = (Map<String, Object>) input.get("head");
  959. head.put("status", "update");
  960. // 获得金蝶接口配置:正式
  961. // Map<String, Object> totalMap = easUtil.getTotalMap();
  962. // 获得金蝶接口配置:测试
  963. Map<String, Object> totalMap = easUtil.getTotalMap();
  964. // 组装报文
  965. totalMap.put("input", input);
  966. System.out.println(totalMap);
  967. String json = JSONUtils.toJSONString(totalMap);
  968. System.out.println(json);
  969. Map<String,Object> resultMap = joinFeign.pushSaleOrderToEas(totalMap);
  970. System.out.println(resultMap);
  971. return success(result);
  972. }
  973. @ApiModelProperty(value = "展示副产品销售订单列表")
  974. @ApiImplicitParams({
  975. @ApiImplicitParam(name = "pageNum", value = "查询页数", required = false, dataType = "Integer"),
  976. @ApiImplicitParam(name = "pageSize", value = "每页记录数", required = false, dataType = "Integer"),
  977. @ApiImplicitParam(name = "apiId", value = "481", required = false, dataType = "BigDecimal")
  978. })
  979. @PostMapping("/getFuSaleOrderList")
  980. public RESTfulResult getFuSaleOrderList(@RequestBody(required = false) Map<String, Object> mapValue,
  981. Integer pageNum,
  982. Integer pageSize,
  983. Integer apiId,
  984. String con,
  985. BigDecimal deleted,
  986. @RequestParam(required = false) String startTime,
  987. @RequestParam(required = false)String endTime
  988. ) {
  989. if (con != null && !"".equals(con) && !"null".equals(con)) {
  990. mapValue.put("con", con);
  991. }
  992. DataChange.queryDataByDateTime(startTime, endTime, mapValue, sdfDateTime);//根据时间段查询数据
  993. mapValue.put("deleted",deleted);
  994. //不分页筛选数据
  995. PageHelper.startPage(pageNum, pageSize);
  996. //分页数据
  997. List<Map<String, Object>> saleOrderList = amsSaleOrderService.getFuSaleOrderList(mapValue);
  998. PageListAdd pageList = columnDataUtil.tableColumnData4(apiId, null, saleOrderList);
  999. return success(pageList);
  1000. }
  1001. @ApiModelProperty(value = "同步关闭金蝶订单")
  1002. @PostMapping("/deleteSaleOrderSame")
  1003. public RESTfulResult deleteSaleOrderSame(@RequestBody Map<String,Object> mapValue) {
  1004. int result = amsSaleOrderService.deleteSaleOrderSame(mapValue);
  1005. return success(result);
  1006. }
  1007. @ApiModelProperty(value = "展示反审批的钢材订单")
  1008. @ApiImplicitParams({
  1009. @ApiImplicitParam(name = "pageNum", value = "查询页数", required = false, dataType = "Integer"),
  1010. @ApiImplicitParam(name = "pageSize", value = "每页记录数", required = false, dataType = "Integer"),
  1011. @ApiImplicitParam(name = "apiId", value = "481", required = false, dataType = "BigDecimal")
  1012. })
  1013. @PostMapping("/getSteelOrderDeletedList")
  1014. public RESTfulResult getSteelOrderDeletedList(@RequestBody(required = false) Map<String, Object> mapValue,
  1015. Integer pageNum,
  1016. Integer pageSize,
  1017. Integer apiId,
  1018. String con,
  1019. String consigneeSsoId,
  1020. @RequestParam(required = false) String startTime,
  1021. @RequestParam(required = false) String endTime,String saler
  1022. ) {
  1023. if (con != null && !"".equals(con) && !"null".equals(con)) {
  1024. mapValue.put("con", con);
  1025. }
  1026. if (consigneeSsoId != null && !"".equals(consigneeSsoId) && !"null".equals(consigneeSsoId)) {
  1027. mapValue.put("consigneeSsoId", consigneeSsoId);
  1028. }
  1029. if (saler != null && !"".equals(saler) && !"null".equals(saler)) {
  1030. mapValue.put("saler", saler);
  1031. }
  1032. DataChange.queryDataByDateTime(startTime, endTime, mapValue, sdfDateTime);//根据时间段查询数据
  1033. //不分页筛选数据
  1034. PageHelper.startPage(pageNum, pageSize);
  1035. //分页数据
  1036. List<Map<String, Object>> saleOrderList = amsSaleOrderService.getSteelOrderDeletedList(mapValue);
  1037. PageListAdd pageList = columnDataUtil.tableColumnData(apiId, null, saleOrderList);
  1038. return success(pageList);
  1039. }
  1040. @ApiModelProperty(value = "展示所有状态销售订单列表")
  1041. @ApiImplicitParams({
  1042. @ApiImplicitParam(name = "pageNum", value = "查询页数", required = false, dataType = "Integer"),
  1043. @ApiImplicitParam(name = "pageSize", value = "每页记录数", required = false, dataType = "Integer"),
  1044. @ApiImplicitParam(name = "apiId", value = "409/475", required = false, dataType = "BigDecimal")
  1045. })
  1046. @PostMapping("/getAllSteelSaleOrderList")
  1047. public RESTfulResult getAllSteelSaleOrderList(@RequestBody(required = false) Map<String,Object> mapValue,
  1048. Integer pageNum,
  1049. Integer pageSize,
  1050. Integer apiId,
  1051. String con,
  1052. Integer shipperId,
  1053. @RequestParam(required = false) Integer saleType,
  1054. String consigneeSsoId
  1055. // String startDate,
  1056. // String endDate
  1057. ) {
  1058. if (con != null && !"".equals(con) && !"null".equals(con)) {
  1059. mapValue.put("con", con);
  1060. }
  1061. if(shipperId != null && !"".equals(shipperId) && !"null".equals(shipperId)){
  1062. mapValue.put("shipperId", shipperId);
  1063. }
  1064. if (consigneeSsoId != null && !"".equals(consigneeSsoId) && !"null".equals(consigneeSsoId)) {
  1065. mapValue.put("consigneeSsoId",consigneeSsoId);
  1066. }
  1067. mapValue.put("saleType",saleType);
  1068. // SimpleDateFormat simpleDateFormat=new SimpleDateFormat("yyyy-MM-dd");
  1069. // if(startDate != null && !"".equals(startDate) && !"null".equals(startDate)){
  1070. // Date startTime=new Date(Long.parseLong(startDate));
  1071. // String startTime1=simpleDateFormat.format(startTime);
  1072. // mapValue.put("startTime",startTime1);
  1073. // }
  1074. // if(endDate != null && !"".equals(endDate) && !"null".equals(endDate)){
  1075. // Date endTime=new Date(Long.parseLong(endDate));
  1076. // String endTime1=simpleDateFormat.format(endTime);
  1077. // mapValue.put("endTime",endTime1);
  1078. // }
  1079. //不分页筛选数据
  1080. PageHelper.startPage(pageNum,pageSize);
  1081. //分页数据
  1082. List<Map<String, Object>> saleOrderList = amsSaleOrderService.getAllSteelSaleOrderList(mapValue);
  1083. PageListAdd pageList = columnDataUtil.tableColumnData(apiId, null,saleOrderList);
  1084. return success(pageList);
  1085. }
  1086. @ApiModelProperty(value = "修改厂内未装货车辆的运单车牌号")
  1087. @PostMapping("/updateCapacityNumberInFactory")
  1088. public RESTfulResult updateCapacityNumberInFactory(@RequestBody Map<String,Object> mapValue) {
  1089. int result = amsSaleOrderService.updateCapacityNumberInFactory(mapValue);
  1090. if (result == 0) {
  1091. return failed("已装货车辆不允许修改车牌");
  1092. }
  1093. else {
  1094. // 调用EAS接口将车牌号传给金蝶
  1095. BigDecimal saleOrderMaterialId = new BigDecimal((Integer) mapValue.get("saleOrderMaterialId"));
  1096. Map<String, Object> input = joinFeign.findCarNumberByOrderId(saleOrderMaterialId);
  1097. Map<String, Object> totalMap = easCapacityTestUtil.getTotalMap();
  1098. totalMap.put("input", input);
  1099. System.out.println(totalMap);
  1100. String json = JSONUtils.toJSONString(totalMap);
  1101. System.out.println(json);
  1102. Map<String, Object> s = joinFeign.pushCarNumberToEas(totalMap);
  1103. System.out.println("-------------------------------------");
  1104. System.out.println(s);
  1105. System.out.println("-------------------------------------");
  1106. return success(result);
  1107. }
  1108. }
  1109. @ApiModelProperty(value = "展示下发给承运商的车序号和物资")
  1110. @PostMapping("/getCarrierTruckNoAndMaterialList")
  1111. public RESTfulResult getCarrierTruckNoAndMaterialList(@RequestBody Map<String,Object> map) {
  1112. List<Map<String,Object>> mapList = amsSaleOrderService.getCarrierTruckNoAndMaterialList(map);
  1113. return success(mapList);
  1114. }
  1115. @ApiModelProperty(value = "关闭单个钢材物资分录")
  1116. @PostMapping("/closeSteelMaterialId")
  1117. public RESTfulResult closeSteelMaterialId(@RequestBody Map<String, Object> mapValue) {
  1118. int result = amsSaleOrderService.closeSteelMaterialId(mapValue);
  1119. if (result == 0) {
  1120. return failed("该物资已装货,无法关闭物资分录!!");
  1121. }
  1122. String reason = (String) mapValue.get("reason");
  1123. String number = (String) mapValue.get("number");
  1124. String closeEntryId = (String) mapValue.get("closeEntryId");
  1125. BigDecimal closeWlEntryId = DataChange.dataToBigDecimal(mapValue.get("saleMaterialId"));
  1126. String wholeOrder = "0";
  1127. String status = "close";
  1128. Map<String,Object> head = new HashMap<>();
  1129. head.put("number",number);
  1130. head.put("reason",reason);
  1131. head.put("closeEntryId",closeEntryId);
  1132. head.put("wholeOrder",wholeOrder);
  1133. head.put("closeWlEntryId",closeWlEntryId);
  1134. head.put("status",status);
  1135. Map<String,Object> input = new HashMap<>();
  1136. Map<String, Object> totalMap = easDeleteUtil.getTotalMap();
  1137. input.put("head",head);
  1138. totalMap.put("input",input);
  1139. // 调用金蝶关闭接口
  1140. String json = JSONUtils.toJSONString(totalMap);
  1141. System.out.println(json);
  1142. Map<String,Object> resultMap = joinFeign.deleteSaleOrderToEas(totalMap);
  1143. System.out.println(resultMap);
  1144. return success(result);
  1145. }
  1146. }