ITWarehouseBillsService.java 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670
  1. package com.ruoyi.warehouseBusiness.service;
  2. import com.ruoyi.common.core.domain.AjaxResult;
  3. import com.ruoyi.common.core.domain.model.LoginUser;
  4. import com.ruoyi.reportManagement.domain.TWareHouseItemsExcel;
  5. import com.ruoyi.shipping.domain.TCntrnoMessage;
  6. import com.ruoyi.shipping.excel.SingleVoyageByShipExcel;
  7. import com.ruoyi.system.domain.SysCheckCode;
  8. import com.ruoyi.warehouseBusiness.domain.StorageChargeInsert;
  9. import com.ruoyi.warehouseBusiness.domain.TWareHouseExcelItems;
  10. import com.ruoyi.warehouseBusiness.domain.TWarehouseBills;
  11. import com.ruoyi.warehouseBusiness.domain.TWarehousebillsitems;
  12. import com.ruoyi.warehouseBusiness.excel.*;
  13. import org.springframework.web.multipart.MultipartFile;
  14. import java.util.List;
  15. import java.util.Map;
  16. /**
  17. * 详情主表Service接口
  18. *
  19. * @author ruoyi
  20. * @date 2020-12-11
  21. */
  22. public interface ITWarehouseBillsService {
  23. /**
  24. * 查询详情主表
  25. *
  26. * @param fId 详情主表ID
  27. * @return 详情主表
  28. */
  29. public Map<String, Object> selectTWarehousebillsById(Long fId);
  30. /**
  31. * 查询凯和订单数据主表
  32. *
  33. * @param fId 详情主表ID
  34. * @return 详情主表
  35. */
  36. public AjaxResult selectTWarehousebills(Long fId);
  37. /**
  38. * 查询导出所需主表列表
  39. *
  40. * @param tWarehousebills 详情主表
  41. * @return 详情主表集合
  42. */
  43. public List<TWarehouseBills> selectTWarehousebillsList(TWarehouseBills tWarehousebills);
  44. /**
  45. * 查询详情主表列表
  46. *
  47. * @param tWarehousebills 详情主表
  48. * @return 详情主表集合
  49. */
  50. public List<Map<String, Object>> selectWarehouseBusinessList(TWarehouseBills tWarehousebills);
  51. /**
  52. * 新增详情主表
  53. *
  54. * @param tWarehouseBills 仓库主表
  55. * @param tWarehousebillsfeesCr 仓库费用付款明细表
  56. * @param tWarehousebillsfeesDr 仓库费用收款明细表
  57. * @param tWarehousebillsitems 仓库货物明细表
  58. * @param loginUser 当前登陆人
  59. * @param billsType 操作状态
  60. * @return 结果
  61. */
  62. public AjaxResult insertTWarehousebills(String tWarehouseBills, String tWarehousebillsfeesCr, String tWarehousebillsfeesDr,
  63. String tWarehousebillsitems, String tEnclosure, LoginUser loginUser, String tCntr, String billsType);
  64. /**
  65. * 新增仓库主(出入库)
  66. *
  67. * @param tWarehousebills 仓库主(出入库)
  68. * @return 结果
  69. */
  70. public int insertTWarehousebills(TWarehouseBills tWarehousebills);
  71. /**
  72. * 凯和订单计划暂存
  73. *
  74. * @param tWarehousebills 主表信息
  75. * @param tWarehousebillsCntr 从表信息
  76. * @return
  77. */
  78. public AjaxResult TSPlantMessage(String tWarehousebills, String tWarehousebillsCntr,
  79. String billsType, LoginUser loginUser);
  80. /**
  81. * 凯和订单计划提交
  82. *
  83. * @param tWarehousebills 主表信息
  84. * @param tWarehousebillsCntr 从表信息
  85. * @return
  86. */
  87. public AjaxResult submitPlantMessage(String tWarehousebills, String tWarehousebillsCntr,
  88. String billsType, LoginUser loginUser);
  89. /**
  90. * 凯和订单配船暂存
  91. *
  92. * @param tWarehousebills 主表信息
  93. * @param tWarehousebillsCntritems 从表信息
  94. * @return
  95. */
  96. public AjaxResult TSMakingMessage(String tWarehousebills, String tWarehousebillsCntritems,
  97. String billsType, LoginUser loginUser);
  98. /**
  99. * 凯和订单配船提交
  100. *
  101. * @param tWarehousebills 主表信息
  102. * @param tWarehousebillsCntritems 从表信息
  103. * @return
  104. */
  105. public AjaxResult submitMakingMessage(String tWarehousebills, String tWarehousebillsCntritems,
  106. String billsType, LoginUser loginUser);
  107. /**
  108. * 修改详情主表
  109. *
  110. * @param tWarehousebills 详情主表
  111. * @return 结果
  112. */
  113. public int updateTWarehousebills(TWarehouseBills tWarehousebills);
  114. /**
  115. * 批量删除详情主表
  116. *
  117. * @param fIds 需要删除的详情主表ID
  118. * @return 结果
  119. */
  120. public AjaxResult deleteTWarehousebillsByIds(Long[] fIds);
  121. /**
  122. * 批量删除凯和订单主表
  123. *
  124. * @param fIds 需要删除的详情主表ID
  125. * @return 结果
  126. */
  127. public int deleteTWarehousebills(Long[] fIds);
  128. public AjaxResult queryRemove(Long fId);
  129. /**
  130. * 删除详情主表信息
  131. *
  132. * @param fId 详情主表ID
  133. * @return 结果
  134. */
  135. public int deleteTWarehousebillsById(Long fId);
  136. String getWarehouseOutStockBillsNo(TWarehouseBills tWarehouseBills);
  137. /**
  138. * 撤销入出库
  139. *
  140. * @param fId
  141. * @param loginUser
  142. * @param billsType
  143. * @return
  144. */
  145. public AjaxResult revokeTWarehousebillsById(Long fId, LoginUser loginUser, String billsType);
  146. AjaxResult revokeTWarehousebillsById1(String warehouseBills, String warehousebillsitems, String tEnclosure,
  147. String warehousebillsfeesCr, String warehousebillsfeesDr,
  148. LoginUser loginUser, String tCntr, String billsType);
  149. AjaxResult addCredit(String warehouseBills, String warehousebillsitems, String tEnclosure, String warehousebillsfeesCr,
  150. String warehousebillsfeesDr, LoginUser loginUser, String tCntr, String billsType);
  151. /**
  152. * 出库 、调拨、 货转 确认
  153. *
  154. * @param warehouseBills
  155. * @param warehousebillsitems
  156. * @param loginUser
  157. * @param billsType
  158. * @return
  159. */
  160. AjaxResult updateCredit(String warehouseBills, String warehousebillsitems, String tEnclosure, String warehousebillsfeesCr,
  161. String warehousebillsfeesDr, LoginUser loginUser, String tCntr, String billsType);
  162. /**
  163. * 入库 、 出库 修改 从表状态
  164. *
  165. * @param warehouseBills
  166. * @param warehousebillsitems
  167. * @param loginUser
  168. * @param status
  169. * @return
  170. */
  171. AjaxResult waitWarehousing(String warehouseBills, String warehousebillsitems,
  172. String tEnclosure, String tWarehousebillsfeesCr, String tWarehousebillsfeesDr,
  173. LoginUser loginUser, String tCntr, Long status, String billtystatus);
  174. /**
  175. * 计算仓储费
  176. *
  177. * @param tWarehouseBills
  178. * @param loginUser
  179. * @param billsType
  180. * @return
  181. */
  182. AjaxResult calculateStorageFees(TWarehouseBills tWarehouseBills, LoginUser loginUser, String billsType);
  183. /**
  184. * 计算仓储费
  185. *
  186. * @param tWarehouseBillsList
  187. * @param loginUser
  188. * @param billsType
  189. * @return
  190. */
  191. AjaxResult calculateStorageFeesList(List<TWarehouseBills> tWarehouseBillsList, LoginUser loginUser, String billsType);
  192. /**
  193. * 仓储费计算提交以及暂存
  194. *
  195. * @param warehouseBills
  196. * @param warehouseItems
  197. * @param warehouseFees
  198. * @param loginUser
  199. * @param billsType
  200. * @return
  201. */
  202. AjaxResult insertStorageFee(String warehouseBills, String warehouseItems, String warehouseFees, LoginUser loginUser, String billsType);
  203. /**
  204. * 仓储费计算list提交以及暂存
  205. *
  206. * @param storageChargeInsert
  207. * @param loginUser
  208. * @return
  209. */
  210. AjaxResult insertStorageFeeList(List<StorageChargeInsert> storageChargeInsert, LoginUser loginUser, String billsType);
  211. /**
  212. * 根据id 查询仓储费计算明细
  213. *
  214. * @param fId
  215. * @return
  216. */
  217. AjaxResult selectStorageFeeById(Long fId);
  218. /**
  219. * 仓库提交方法
  220. *
  221. * @param tWarehouseBills 仓库主表
  222. * @param tWarehousebillsfeesCr 仓库费用付款明细表
  223. * @param tWarehousebillsfeesDr 仓库费用收款明细表
  224. * @param tWarehousebillsitems 仓库货物明细表
  225. * @param loginUser 当前登陆人
  226. * @param billsType 操作状态
  227. * @return 结果
  228. */
  229. AjaxResult warehouseSubmission(String tWarehouseBills, String tWarehousebillsfeesCr, String tWarehousebillsfeesDr, String tWarehousebillsitems, String tEnclosure, LoginUser loginUser, String tCntr, String billsType);
  230. /**
  231. * 导出计算明细
  232. *
  233. * @param fId
  234. * @return
  235. */
  236. public List<TWareHouseExcelItems> selectTWarehousebillsItemsList(Long fId);
  237. /**
  238. * 查询出入库汇总列表
  239. *
  240. * @param tWarehouseBills 仓储主表
  241. * * @return 库存总账集合
  242. */
  243. List<Map<String, Object>> selectInventoryList(TWarehouseBills tWarehouseBills);
  244. public List<TWareHouseItemsExcel> selectTWarehousebillsItemsList(TWarehouseBills tWarehouseBills);
  245. AjaxResult serialNumber(String billsType);
  246. public int derecognition(Long fId);
  247. List<Map<String, Object>> selectWareHouseNumber();
  248. /**
  249. * app查询入库数量
  250. */
  251. public List<Map<String, Object>> selectWarehouseBusinessInStockList(TWarehousebillsitems tWarehousebillsitems);
  252. AjaxResult waitWarehousingItems(TWarehousebillsitems tWarehousebillsitems);
  253. AjaxResult addCreditItems(String item, String attachs);
  254. public List<InStock> inStockExport(TWarehouseBills tWarehousebills) throws Exception;
  255. public List<OutStock> outStockExport(TWarehouseBills tWarehousebills) throws Exception;
  256. public List<StockTransfer> stockTransferExport(TWarehouseBills tWarehousebills) throws Exception;
  257. public List<GoodsTransfer> goodsTransferExport(TWarehouseBills tWarehousebills) throws Exception;
  258. public List<StorageFee> storageFeeExport(TWarehouseBills tWarehousebills) throws Exception;
  259. public AjaxResult saveWarehouse(String item, String information);
  260. /**
  261. * 查询提单号是否在一天当中出现多次
  262. *
  263. * @param tWarehouseBills 仓库数据
  264. * @return 结果
  265. */
  266. public AjaxResult selectContainMblno(String tWarehouseBills, String billsType);
  267. /**
  268. * 凯和网页版查询我的订单
  269. *
  270. * @param tWarehouseBills
  271. * @return
  272. */
  273. public List<TWarehouseBills> webVersionOrder(TWarehouseBills tWarehouseBills);
  274. /**
  275. * 凯和网页版查询我的订单
  276. *
  277. * @param tWarehouseBills
  278. * @return
  279. */
  280. public List<TWarehouseBills> webVersionOrderMessage(TWarehouseBills tWarehouseBills);
  281. /**
  282. * 后台管理系统查询订单
  283. *
  284. * @return
  285. */
  286. public List<Map<String, Object>> ruoYiVersionOrderList(LoginUser loginUser, TWarehouseBills tWarehouseBills);
  287. /**
  288. * 网站查询订单
  289. */
  290. public List<Map<String, Object>> webVersionOrderMessage(LoginUser loginUser, TWarehouseBills tWarehouseBills);
  291. /**
  292. * 根据id获取订单信息
  293. *
  294. * @param tWarehouseBills
  295. * @return
  296. */
  297. public List<TWarehouseBills> webVersionOrderDetails(TWarehouseBills tWarehouseBills);
  298. /**
  299. * 若依维护订单信息
  300. *
  301. * @param tWarehousebills
  302. * @param tWarehousebillsCntritems
  303. * @param tWarehousebillsfeesCr
  304. * @param tWarehousebillsfeesDr
  305. * @return
  306. */
  307. public AjaxResult ruoYiUpdateOrderMessage(String tWarehousebills, String tWarehousebillsCntr, String tWarehousebillsCntritems,
  308. String tWarehousebillsfeesCr, String tWarehousebillsfeesDr, LoginUser loginUser,
  309. String billsType);
  310. /**
  311. * 若依维护订单信息
  312. *
  313. * @param tWarehousebills
  314. * @param tWarehousebillsCntritems
  315. * @param tWarehousebillsfeesCr
  316. * @param tWarehousebillsfeesDr
  317. * @return
  318. */
  319. public AjaxResult ruoYiSubmitMessage(String tWarehousebills, String tWarehousebillsCntr, String tWarehousebillsCntritems,
  320. String tWarehousebillsfeesCr, String tWarehousebillsfeesDr, LoginUser loginUser,
  321. String billsType);
  322. public AjaxResult updateOrderMessage(TWarehouseBills tWarehouseBills);
  323. /**
  324. * app 查询列表信息
  325. *
  326. * @param warehouseBills
  327. * @return
  328. */
  329. public List<Map<String, Object>> selectAppStockList(TWarehouseBills warehouseBills);
  330. /**
  331. * 根据主表id查询主表对应明细列表数据
  332. *
  333. * @param warehouseBills
  334. * @return
  335. */
  336. public List<Map<String, Object>> warehouseItemById(TWarehouseBills warehouseBills);
  337. /**
  338. * 根据明细id查询对应明细表数据
  339. *
  340. * @param fId
  341. * @return
  342. */
  343. public AjaxResult selectWarehouseItemDataById(Long fId);
  344. /**
  345. * 查询app 添加新行 必要的基础资料
  346. *
  347. * @param fId
  348. * @return
  349. */
  350. public AjaxResult getAppBasicInformation(Long fId);
  351. /**
  352. * app确认入库、出库、货转
  353. *
  354. * @param item 明细数据
  355. * @param attachs 附件数据
  356. * @return 结果
  357. */
  358. public AjaxResult warehouseOperationConfirmation(String item, String attachs);
  359. /**
  360. * app仓储新行保存业务
  361. *
  362. * @param item 明细数据
  363. * @param attachs 附件数据
  364. * @return 结果
  365. */
  366. public AjaxResult submitWarehouse(String item, String attachs);
  367. /**
  368. * 查看集港业务
  369. *
  370. * @param fId 集港id
  371. * @return
  372. */
  373. public AjaxResult selectContainerPort(Long fId);
  374. /**
  375. * 集港业务保存、提交接口
  376. *
  377. * @param tWarehouseBills 主表业务
  378. * @param feesCr 收费
  379. * @param feesDr 付费
  380. * @return
  381. */
  382. public AjaxResult saveContainerPort(String tWarehouseBills, String feesCr, String feesDr, String type);
  383. /**
  384. * 查询集港业务基础资料
  385. *
  386. * @return
  387. */
  388. public AjaxResult selectBasicInformation();
  389. /**
  390. * 集港业务撤销
  391. *
  392. * @param fId 主表id
  393. * @param type
  394. * @return
  395. */
  396. public AjaxResult revokeContainerPort(Long fId, String type);
  397. /**
  398. * 导入Excel生成箱信息
  399. *
  400. * @param file excel
  401. * @return 结果
  402. */
  403. public AjaxResult importCreateCompanyMsg(MultipartFile file) throws Exception;
  404. /**
  405. * 导入Excel生成箱信息
  406. *
  407. * @param file excel
  408. * @return 结果
  409. */
  410. public AjaxResult importCreateCompanyMsgNew(MultipartFile file, LoginUser loginUser, Long fId) throws Exception;
  411. /**
  412. * 提交仓库主表审批
  413. *
  414. * @param tWarehouseBills 主表信息
  415. * @param tWarehousebillsfeesCr 付款信息
  416. * @param tWarehousebillsfeesDr 收款信息
  417. * @param tWarehousebillsitems 仓储明细
  418. * @param tEnclosure 附件信息
  419. * @param tCntr 箱型箱量
  420. * @param billsType 类型
  421. * @return 结果
  422. */
  423. public AjaxResult submitWarehousingApproval(String tWarehouseBills, String tWarehousebillsfeesCr, String tWarehousebillsfeesDr, String tWarehousebillsitems, String tEnclosure, String tCntr, String billsType);
  424. /**
  425. * 撤销已审核通过的接单入库信息
  426. *
  427. * @param fId
  428. * @return
  429. */
  430. public AjaxResult withdrawOrdersById(Long fId);
  431. /**
  432. * 查询单据是否允许变更
  433. *
  434. * @param sysCheckCode
  435. * @return 结果
  436. */
  437. public boolean checkCode(SysCheckCode sysCheckCode);
  438. /**
  439. * 导入【入库明细箱信息】Excel
  440. *
  441. * @param file 文件
  442. * @return
  443. */
  444. public AjaxResult importLibraryInformation(MultipartFile file);
  445. /**
  446. * 计算出库仓储费
  447. *
  448. * @param fId
  449. * @return
  450. */
  451. public AjaxResult calculateOutStockFee(Long fId);
  452. /**
  453. * 查询仓储仓管员角色用户
  454. */
  455. public AjaxResult queryClerkRoleList();
  456. /**
  457. * 出入库明细提交审批确认
  458. */
  459. public AjaxResult addDetails(Long fId, String billsType, LoginUser loginUser);
  460. /**
  461. * 新增仓库主(出入库)
  462. *
  463. * @param tWarehousebills 仓库主(出入库)
  464. * @return 结果
  465. */
  466. public AjaxResult getMblno(TWarehouseBills tWarehousebills);
  467. /**
  468. * 凯和商务端订单修改,修改完,删除提交审批
  469. *
  470. * @param tWarehouseBills 主表信息
  471. * @param loginUser 操作人信息
  472. * @return
  473. */
  474. public AjaxResult orderExamine(TWarehouseBills tWarehouseBills, LoginUser loginUser);
  475. /**
  476. * 凯和商务端运单变更
  477. *
  478. * @param tWarehousebills
  479. * @param tWarehousebillsCntritems
  480. * @return
  481. */
  482. public AjaxResult waybillChanges(String tWarehousebills, String tWarehousebillsCntr, String tWarehousebillsCntritems,
  483. LoginUser loginUser,
  484. String billsType);
  485. /**
  486. * 复制运单变更前的数据
  487. *
  488. * @param fId
  489. * @return
  490. */
  491. public AjaxResult copyKhOrderMessage(Long fId);
  492. /**
  493. * 导出清单
  494. *
  495. * @param tWarehouseBills
  496. * @return
  497. */
  498. public AjaxResult exportInventory(TWarehouseBills tWarehouseBills);
  499. /**
  500. * 凯和若依端删除订单
  501. *
  502. * @param tWarehouseBills
  503. * @param loginUser
  504. * @return
  505. */
  506. public AjaxResult deleteOrder(TWarehouseBills tWarehouseBills, LoginUser loginUser);
  507. /**
  508. * 批量更改订单的船名航次
  509. *
  510. * @param fIds 订单ID
  511. * @param fVessel 船名
  512. * @param fVoyage 航次
  513. * @return
  514. */
  515. public AjaxResult batchModifyingVesselVoyage(Long[] fIds, Long fVessel, Long fVoyage, Long fCargoPlanning);
  516. /**
  517. * 凯和修改订单信息
  518. *
  519. * @param tWarehousebills 详情主表
  520. * @return 结果
  521. */
  522. public int updateKaHeOrder(TWarehouseBills tWarehousebills);
  523. /**
  524. * 凯和单航次配船
  525. *
  526. * @param tWarehouseBills 主表
  527. * @return
  528. */
  529. public List<SingleVoyageByShipExcel> singleVoyageByShip(TWarehouseBills tWarehouseBills);
  530. /**
  531. * 单航次配船修改箱动态信息
  532. *
  533. * @param tCntrno
  534. * @return
  535. */
  536. public AjaxResult updateBoxMessage(TCntrnoMessage tCntrno, LoginUser loginUser);
  537. /**
  538. * 凯和拆单
  539. *
  540. * @param tWarehousebills
  541. * @param tWarehousebillsCntr
  542. * @param tWarehousebillsCntritems
  543. * @return
  544. */
  545. public AjaxResult updateMessageSign(String tWarehousebills, String tWarehousebillsCntr, String tWarehousebillsCntritems, String fOriginalbillno);
  546. /**
  547. * 拆单审批通过修改原单数据
  548. *
  549. * @param orderId
  550. * @return
  551. */
  552. public AjaxResult approveDismount(Long orderId);
  553. /**
  554. * 根据仓库id查询最新两条审核人信息
  555. *
  556. * @param id
  557. * @return
  558. */
  559. AjaxResult queryReviewer(Long id);
  560. /**
  561. * 根据费用id 更新审核信息
  562. *
  563. * @param id
  564. * @return
  565. */
  566. AjaxResult feeReviewSubmit(Long id);
  567. /**
  568. * 根据id撤销已费用审核状态
  569. *
  570. * @param id
  571. * @return
  572. */
  573. AjaxResult revokefeeReview(Long id);
  574. /**
  575. * app根据id查询详情
  576. *
  577. * @param id 主表id
  578. * @param typeEnum 类型
  579. * @return
  580. */
  581. AjaxResult appQueryInit(Long id, String typeEnum);
  582. }