ITWarehouseBillsService.java 18 KB

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