ITWarehouseBillsService.java 17 KB

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