ITWarehouseBillsService.java 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703
  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. /**
  147. * 撤回 入库、 调拨
  148. * @param warehouseBills
  149. * @param warehousebillsitems
  150. * @param tEnclosure
  151. * @param warehousebillsfeesCr
  152. * @param warehousebillsfeesDr
  153. * @param loginUser
  154. * @param tCntr
  155. * @param billsType
  156. * @return
  157. */
  158. AjaxResult revokeTWarehousebillsById1(String warehouseBills, String warehousebillsitems, String tEnclosure,
  159. String warehousebillsfeesCr, String warehousebillsfeesDr,
  160. LoginUser loginUser, String tCntr, String billsType);
  161. /**
  162. * 入库确认
  163. *
  164. * @param warehouseBills
  165. * @param warehousebillsitems
  166. * @param tEnclosure
  167. * @param warehousebillsfeesCr
  168. * @param warehousebillsfeesDr
  169. * @param loginUser
  170. * @param tCntr
  171. * @param billsType
  172. * @return
  173. */
  174. AjaxResult addCredit(String warehouseBills, String warehousebillsitems, String tEnclosure, String warehousebillsfeesCr,
  175. String warehousebillsfeesDr, LoginUser loginUser, String tCntr, String billsType);
  176. /**
  177. * 出库 、调拨、 货转 确认
  178. *
  179. * @param warehouseBills
  180. * @param warehousebillsitems
  181. * @param loginUser
  182. * @param billsType
  183. * @return
  184. */
  185. AjaxResult updateCredit(String warehouseBills, String warehousebillsitems, String tEnclosure, String warehousebillsfeesCr,
  186. String warehousebillsfeesDr, LoginUser loginUser, String tCntr, String billsType);
  187. /**
  188. * 入库确认 、 出库确认 修改 从表状态
  189. *
  190. * @param warehouseBills
  191. * @param warehousebillsitems
  192. * @param loginUser
  193. * @param status
  194. * @return
  195. */
  196. AjaxResult waitWarehousing(String warehouseBills, String warehousebillsitems,
  197. String tEnclosure, String tWarehousebillsfeesCr, String tWarehousebillsfeesDr,
  198. LoginUser loginUser, String tCntr, Long status, String billtystatus);
  199. /**
  200. * 计算仓储费
  201. *
  202. * @param tWarehouseBills
  203. * @param loginUser
  204. * @param billsType
  205. * @return
  206. */
  207. AjaxResult calculateStorageFees(TWarehouseBills tWarehouseBills, LoginUser loginUser, String billsType);
  208. /**
  209. * 计算仓储费
  210. *
  211. * @param tWarehouseBillsList
  212. * @param loginUser
  213. * @param billsType
  214. * @return
  215. */
  216. AjaxResult calculateStorageFeesList(List<TWarehouseBills> tWarehouseBillsList, LoginUser loginUser, String billsType);
  217. /**
  218. * 仓储费计算提交以及暂存
  219. *
  220. * @param warehouseBills
  221. * @param warehouseItems
  222. * @param warehouseFees
  223. * @param loginUser
  224. * @param billsType
  225. * @return
  226. */
  227. AjaxResult insertStorageFee(String warehouseBills, String warehouseItems, String warehouseFees, LoginUser loginUser, String billsType);
  228. /**
  229. * 仓储费计算list提交以及暂存
  230. *
  231. * @param storageChargeInsert
  232. * @param loginUser
  233. * @return
  234. */
  235. AjaxResult insertStorageFeeList(List<StorageChargeInsert> storageChargeInsert, LoginUser loginUser, String billsType);
  236. /**
  237. * 根据id 查询仓储费计算明细
  238. *
  239. * @param fId
  240. * @return
  241. */
  242. AjaxResult selectStorageFeeById(Long fId);
  243. /**
  244. * 仓库提交方法
  245. *
  246. * @param tWarehouseBills 仓库主表
  247. * @param tWarehousebillsfeesCr 仓库费用付款明细表
  248. * @param tWarehousebillsfeesDr 仓库费用收款明细表
  249. * @param tWarehousebillsitems 仓库货物明细表
  250. * @param loginUser 当前登陆人
  251. * @param billsType 操作状态
  252. * @return 结果
  253. */
  254. AjaxResult warehouseSubmission(String tWarehouseBills, String tWarehousebillsfeesCr, String tWarehousebillsfeesDr, String tWarehousebillsitems, String tEnclosure, LoginUser loginUser, String tCntr, String billsType);
  255. /**
  256. * 导出计算明细
  257. *
  258. * @param fId
  259. * @return
  260. */
  261. public List<TWareHouseExcelItems> selectTWarehousebillsItemsList(Long fId);
  262. /**
  263. * 查询出入库汇总列表
  264. *
  265. * @param tWarehouseBills 仓储主表
  266. * * @return 库存总账集合
  267. */
  268. List<Map<String, Object>> selectInventoryList(TWarehouseBills tWarehouseBills);
  269. public List<TWareHouseItemsExcel> selectTWarehousebillsItemsList(TWarehouseBills tWarehouseBills);
  270. AjaxResult serialNumber(String billsType);
  271. public int derecognition(Long fId);
  272. List<Map<String, Object>> selectWareHouseNumber();
  273. /**
  274. * app查询入库数量
  275. */
  276. public List<Map<String, Object>> selectWarehouseBusinessInStockList(TWarehousebillsitems tWarehousebillsitems);
  277. AjaxResult waitWarehousingItems(TWarehousebillsitems tWarehousebillsitems);
  278. AjaxResult addCreditItems(String item, String attachs);
  279. public List<InStock> inStockExport(TWarehouseBills tWarehousebills) throws Exception;
  280. public List<OutStock> outStockExport(TWarehouseBills tWarehousebills) throws Exception;
  281. public List<StockTransfer> stockTransferExport(TWarehouseBills tWarehousebills) throws Exception;
  282. public List<GoodsTransfer> goodsTransferExport(TWarehouseBills tWarehousebills) throws Exception;
  283. public List<StorageFee> storageFeeExport(TWarehouseBills tWarehousebills) throws Exception;
  284. public AjaxResult saveWarehouse(String item, String information);
  285. /**
  286. * 查询提单号是否在一天当中出现多次
  287. *
  288. * @param tWarehouseBills 仓库数据
  289. * @return 结果
  290. */
  291. public AjaxResult selectContainMblno(String tWarehouseBills, String billsType);
  292. /**
  293. * 凯和网页版查询我的订单
  294. *
  295. * @param tWarehouseBills
  296. * @return
  297. */
  298. public List<TWarehouseBills> webVersionOrder(TWarehouseBills tWarehouseBills);
  299. /**
  300. * 凯和网页版查询我的订单
  301. *
  302. * @param tWarehouseBills
  303. * @return
  304. */
  305. public List<TWarehouseBills> webVersionOrderMessage(TWarehouseBills tWarehouseBills);
  306. /**
  307. * 后台管理系统查询订单
  308. *
  309. * @return
  310. */
  311. public List<Map<String, Object>> ruoYiVersionOrderList(LoginUser loginUser, TWarehouseBills tWarehouseBills);
  312. /**
  313. * 网站查询订单
  314. */
  315. public List<Map<String, Object>> webVersionOrderMessage(LoginUser loginUser, TWarehouseBills tWarehouseBills);
  316. /**
  317. * 根据id获取订单信息
  318. *
  319. * @param tWarehouseBills
  320. * @return
  321. */
  322. public List<TWarehouseBills> webVersionOrderDetails(TWarehouseBills tWarehouseBills);
  323. /**
  324. * 若依维护订单信息
  325. *
  326. * @param tWarehousebills
  327. * @param tWarehousebillsCntritems
  328. * @param tWarehousebillsfeesCr
  329. * @param tWarehousebillsfeesDr
  330. * @return
  331. */
  332. public AjaxResult ruoYiUpdateOrderMessage(String tWarehousebills, String tWarehousebillsCntr, String tWarehousebillsCntritems,
  333. String tWarehousebillsfeesCr, String tWarehousebillsfeesDr, LoginUser loginUser,
  334. String billsType);
  335. /**
  336. * 若依维护订单信息
  337. *
  338. * @param tWarehousebills
  339. * @param tWarehousebillsCntritems
  340. * @param tWarehousebillsfeesCr
  341. * @param tWarehousebillsfeesDr
  342. * @return
  343. */
  344. public AjaxResult ruoYiSubmitMessage(String tWarehousebills, String tWarehousebillsCntr, String tWarehousebillsCntritems,
  345. String tWarehousebillsfeesCr, String tWarehousebillsfeesDr, LoginUser loginUser,
  346. String billsType);
  347. public AjaxResult updateOrderMessage(TWarehouseBills tWarehouseBills);
  348. /**
  349. * app 查询列表信息
  350. *
  351. * @param warehouseBills
  352. * @return
  353. */
  354. public List<Map<String, Object>> selectAppStockList(TWarehouseBills warehouseBills);
  355. /**
  356. * 根据主表id查询主表对应明细列表数据
  357. *
  358. * @param warehouseBills
  359. * @return
  360. */
  361. public List<Map<String, Object>> warehouseItemById(TWarehouseBills warehouseBills);
  362. /**
  363. * 根据明细id查询对应明细表数据
  364. *
  365. * @param fId
  366. * @return
  367. */
  368. public AjaxResult selectWarehouseItemDataById(Long fId);
  369. /**
  370. * 查询app 添加新行 必要的基础资料
  371. *
  372. * @param fId
  373. * @return
  374. */
  375. public AjaxResult getAppBasicInformation(Long fId);
  376. /**
  377. * app确认入库、出库、货转
  378. *
  379. * @param item 明细数据
  380. * @param attachs 附件数据
  381. * @return 结果
  382. */
  383. public AjaxResult warehouseOperationConfirmation(String item, String attachs);
  384. /**
  385. * app仓储新行保存业务
  386. *
  387. * @param item 明细数据
  388. * @param attachs 附件数据
  389. * @return 结果
  390. */
  391. public AjaxResult submitWarehouse(String item, String attachs);
  392. /**
  393. * 查看集港业务
  394. *
  395. * @param fId 集港id
  396. * @return
  397. */
  398. public AjaxResult selectContainerPort(Long fId);
  399. /**
  400. * 集港业务保存、提交接口
  401. *
  402. * @param tWarehouseBills 主表业务
  403. * @param feesCr 收费
  404. * @param feesDr 付费
  405. * @return
  406. */
  407. public AjaxResult saveContainerPort(String tWarehouseBills, String feesCr, String feesDr, String type);
  408. /**
  409. * 查询集港业务基础资料
  410. *
  411. * @return
  412. */
  413. public AjaxResult selectBasicInformation();
  414. /**
  415. * 集港业务撤销
  416. *
  417. * @param fId 主表id
  418. * @param type
  419. * @return
  420. */
  421. public AjaxResult revokeContainerPort(Long fId, String type);
  422. /**
  423. * 导入Excel生成箱信息
  424. *
  425. * @param file excel
  426. * @return 结果
  427. */
  428. public AjaxResult importCreateCompanyMsg(MultipartFile file) throws Exception;
  429. /**
  430. * 导入Excel生成箱信息
  431. *
  432. * @param file excel
  433. * @return 结果
  434. */
  435. public AjaxResult importCreateCompanyMsgNew(MultipartFile file, LoginUser loginUser, Long fId) throws Exception;
  436. /**
  437. * 提交仓库主表审批
  438. *
  439. * @param tWarehouseBills 主表信息
  440. * @param tWarehousebillsfeesCr 付款信息
  441. * @param tWarehousebillsfeesDr 收款信息
  442. * @param tWarehousebillsitems 仓储明细
  443. * @param tEnclosure 附件信息
  444. * @param tCntr 箱型箱量
  445. * @param billsType 类型
  446. * @return 结果
  447. */
  448. public AjaxResult submitWarehousingApproval(String tWarehouseBills, String tWarehousebillsfeesCr, String tWarehousebillsfeesDr, String tWarehousebillsitems, String tEnclosure, String tCntr, String billsType);
  449. /**
  450. * 撤销已审核通过的接单入库信息
  451. *
  452. * @param fId
  453. * @return
  454. */
  455. public AjaxResult withdrawOrdersById(Long fId);
  456. /**
  457. * 查询单据是否允许变更
  458. *
  459. * @param sysCheckCode
  460. * @return 结果
  461. */
  462. public boolean checkCode(SysCheckCode sysCheckCode);
  463. /**
  464. * 导入【入库明细箱信息】Excel
  465. *
  466. * @param file 文件
  467. * @return
  468. */
  469. public AjaxResult importLibraryInformation(MultipartFile file);
  470. /**
  471. * 计算出库仓储费
  472. *
  473. * @param fId
  474. * @return
  475. */
  476. public AjaxResult calculateOutStockFee(Long fId);
  477. /**
  478. * 查询仓储仓管员角色用户
  479. */
  480. public AjaxResult queryClerkRoleList();
  481. /**
  482. * 出入库明细提交审批确认
  483. */
  484. public AjaxResult addDetails(Long fId, String billsType, LoginUser loginUser);
  485. /**
  486. * 新增仓库主(出入库)
  487. *
  488. * @param tWarehousebills 仓库主(出入库)
  489. * @return 结果
  490. */
  491. public AjaxResult getMblno(TWarehouseBills tWarehousebills);
  492. /**
  493. * 凯和商务端订单修改,修改完,删除提交审批
  494. *
  495. * @param tWarehouseBills 主表信息
  496. * @param loginUser 操作人信息
  497. * @return
  498. */
  499. public AjaxResult orderExamine(TWarehouseBills tWarehouseBills, LoginUser loginUser);
  500. /**
  501. * 凯和商务端运单变更
  502. *
  503. * @param tWarehousebills
  504. * @param tWarehousebillsCntritems
  505. * @return
  506. */
  507. public AjaxResult waybillChanges(String tWarehousebills, String tWarehousebillsCntr, String tWarehousebillsCntritems,
  508. LoginUser loginUser,
  509. String billsType);
  510. /**
  511. * 复制运单变更前的数据
  512. *
  513. * @param fId
  514. * @return
  515. */
  516. public AjaxResult copyKhOrderMessage(Long fId);
  517. /**
  518. * 导出清单
  519. *
  520. * @param tWarehouseBills
  521. * @return
  522. */
  523. public AjaxResult exportInventory(TWarehouseBills tWarehouseBills);
  524. /**
  525. * 凯和若依端删除订单
  526. *
  527. * @param tWarehouseBills
  528. * @param loginUser
  529. * @return
  530. */
  531. public AjaxResult deleteOrder(TWarehouseBills tWarehouseBills, LoginUser loginUser);
  532. /**
  533. * 批量更改订单的船名航次
  534. *
  535. * @param fIds 订单ID
  536. * @param fVessel 船名
  537. * @param fVoyage 航次
  538. * @return
  539. */
  540. public AjaxResult batchModifyingVesselVoyage(Long[] fIds, Long fVessel, Long fVoyage, Long fCargoPlanning);
  541. /**
  542. * 凯和修改订单信息
  543. *
  544. * @param tWarehousebills 详情主表
  545. * @return 结果
  546. */
  547. public int updateKaHeOrder(TWarehouseBills tWarehousebills);
  548. /**
  549. * 凯和单航次配船
  550. *
  551. * @param tWarehouseBills 主表
  552. * @return
  553. */
  554. public List<SingleVoyageByShipExcel> singleVoyageByShip(TWarehouseBills tWarehouseBills);
  555. /**
  556. * 单航次配船修改箱动态信息
  557. *
  558. * @param tCntrno
  559. * @return
  560. */
  561. public AjaxResult updateBoxMessage(TCntrnoMessage tCntrno, LoginUser loginUser);
  562. /**
  563. * 凯和拆单
  564. *
  565. * @param tWarehousebills
  566. * @param tWarehousebillsCntr
  567. * @param tWarehousebillsCntritems
  568. * @return
  569. */
  570. public AjaxResult updateMessageSign(String tWarehousebills, String tWarehousebillsCntr, String tWarehousebillsCntritems, String fOriginalbillno);
  571. /**
  572. * 拆单审批通过修改原单数据
  573. *
  574. * @param orderId
  575. * @return
  576. */
  577. public AjaxResult approveDismount(Long orderId);
  578. /**
  579. * 根据仓库id查询最新两条审核人信息
  580. *
  581. * @param id
  582. * @return
  583. */
  584. AjaxResult queryReviewer(Long id);
  585. /**
  586. * 根据费用id 更新审核信息
  587. *
  588. * @param id
  589. * @return
  590. */
  591. AjaxResult feeReviewSubmit(Long id);
  592. /**
  593. * 根据id撤销已费用审核状态
  594. *
  595. * @param id
  596. * @return
  597. */
  598. AjaxResult revokefeeReview(Long id);
  599. /**
  600. * app根据id查询详情
  601. *
  602. * @param id 主表id
  603. * @param typeEnum 类型
  604. * @return
  605. */
  606. AjaxResult appQueryInit(Long id, String typeEnum);
  607. /**
  608. * 货转根据提单号查询可用客户、仓库信息
  609. *
  610. * @param fMblno 提单号
  611. * @return
  612. */
  613. AjaxResult corpOrWarehouseByMblno(String fMblno);
  614. }