ITWarehouseBillsService.java 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511
  1. package com.ruoyi.warehouseBusiness.service;
  2. import com.ruoyi.anpin.InventoryLedgerExcel;
  3. import com.ruoyi.anpin.ProfitExcel;
  4. import com.ruoyi.anpin.SalesOfOutbound;
  5. import com.ruoyi.anpin.WarhousrExcel;
  6. import com.ruoyi.common.core.domain.AjaxResult;
  7. import com.ruoyi.common.core.domain.model.LoginUser;
  8. import com.ruoyi.reportManagement.domain.TWareHouseItemsExcel;
  9. import com.ruoyi.warehouseBusiness.domain.TWareHouseExcelItems;
  10. import com.ruoyi.warehouseBusiness.domain.TWarehouseBills;
  11. import com.ruoyi.warehouseBusiness.domain.TWarehousebillsfees;
  12. import com.ruoyi.warehouseBusiness.domain.TWarehousebillsitems;
  13. import com.ruoyi.warehouseBusiness.excel.*;
  14. import java.util.Date;
  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 int 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 getWarehouseInStockBillsNo(TWarehouseBills tWarehouseBills);
  134. String getWarehouseOutStockBillsNo(TWarehouseBills tWarehouseBills);
  135. /**
  136. * 撤销入出库
  137. *
  138. * @param fId
  139. * @param loginUser
  140. * @param billsType
  141. * @return
  142. */
  143. public AjaxResult revokeTWarehousebillsById(Long fId, LoginUser loginUser, String billsType);
  144. /**
  145. * 安品撤销入出库
  146. *
  147. * @param fId
  148. * @param loginUser
  149. * @param billsType
  150. * @return
  151. */
  152. public AjaxResult revokeAnPinOrder(Long fId, LoginUser loginUser, String billsType);
  153. AjaxResult revokeTWarehousebillsById1(String warehouseBills, String warehousebillsitems, String tEnclosure,
  154. String warehousebillsfeesCr, String warehousebillsfeesDr,
  155. LoginUser loginUser, String tCntr, String billsType);
  156. AjaxResult addCredit(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 billsType
  165. * @return
  166. */
  167. AjaxResult updateCredit(String warehouseBills, String warehousebillsitems, String tEnclosure, String warehousebillsfeesCr,
  168. String warehousebillsfeesDr, LoginUser loginUser, String tCntr, String billsType);
  169. /**
  170. * 入库 、 出库 修改 从表状态
  171. *
  172. * @param warehouseBills
  173. * @param warehousebillsitems
  174. * @param loginUser
  175. * @param status
  176. * @return
  177. */
  178. AjaxResult waitWarehousing(String warehouseBills, String warehousebillsitems,
  179. String tEnclosure, String tWarehousebillsfeesCr, String tWarehousebillsfeesDr,
  180. LoginUser loginUser, String tCntr, Long status, String billtystatus);
  181. /**
  182. * 计算仓储费
  183. *
  184. * @param tWarehouseBills
  185. * @param loginUser
  186. * @param billsType
  187. * @return
  188. */
  189. AjaxResult calculateStorageFees(TWarehouseBills tWarehouseBills, LoginUser loginUser, String billsType);
  190. /**
  191. * 仓储费计算提交以及暂存
  192. *
  193. * @param warehouseBills
  194. * @param warehouseItems
  195. * @param warehouseFees
  196. * @param loginUser
  197. * @param billsType
  198. * @return
  199. */
  200. AjaxResult insertStorageFee(String warehouseBills, String warehouseItems, String warehouseFees, LoginUser loginUser, String billsType);
  201. /**
  202. * 根据id 查询仓储费计算明细
  203. *
  204. * @param fId
  205. * @return
  206. */
  207. AjaxResult selectStorageFeeById(Long fId);
  208. /**
  209. * 仓库提交方法
  210. *
  211. * @param tWarehouseBills 仓库主表
  212. * @param tWarehousebillsfeesCr 仓库费用付款明细表
  213. * @param tWarehousebillsfeesDr 仓库费用收款明细表
  214. * @param tWarehousebillsitems 仓库货物明细表
  215. * @param loginUser 当前登陆人
  216. * @param billsType 操作状态
  217. * @return 结果
  218. */
  219. AjaxResult warehouseSubmission(String tWarehouseBills, String tWarehousebillsfeesCr, String tWarehousebillsfeesDr, String tWarehousebillsitems, String tEnclosure, LoginUser loginUser, String tCntr, String billsType);
  220. /**
  221. * 导出计算明细
  222. * @param fId
  223. * @return
  224. */
  225. public List<TWareHouseExcelItems> selectTWarehousebillsItemsList(Long fId);
  226. /**
  227. * 查询出入库汇总列表
  228. *
  229. * @param tWarehouseBills 仓储主表
  230. * * @return 库存总账集合
  231. */
  232. List<Map<String, Object>> selectInventoryList(TWarehouseBills tWarehouseBills);
  233. public List<TWareHouseItemsExcel> selectTWarehousebillsItemsList(TWarehouseBills tWarehouseBills);
  234. AjaxResult serialNumber( String billsType);
  235. public int derecognition(Long fId);
  236. List<Map<String, Object>> selectWareHouseNumber();
  237. /**
  238. * app查询入库数量
  239. */
  240. public List<Map<String, Object>> selectWarehouseBusinessInStockList(TWarehousebillsitems tWarehousebillsitems);
  241. AjaxResult waitWarehousingItems(TWarehousebillsitems tWarehousebillsitems);
  242. AjaxResult addCreditItems(String item , String attachs);
  243. public List<InStock> inStockExport(TWarehouseBills tWarehousebills) throws Exception;
  244. public List<OutStock> outStockExport(TWarehouseBills tWarehousebills) throws Exception;
  245. public List<StockTransfer> stockTransferExport(TWarehouseBills tWarehousebills) throws Exception;
  246. public List<GoodsTransfer> goodsTransferExport(TWarehouseBills tWarehousebills) throws Exception;
  247. public List<StorageFee> storageFeeExport(TWarehouseBills tWarehousebills) throws Exception;
  248. public AjaxResult saveWarehouse(String item, String information);
  249. /**
  250. * 查询提单号是否在一天当中出现多次
  251. * @param tWarehouseBills 仓库数据
  252. * @return 结果
  253. */
  254. public AjaxResult selectContainMblno(String tWarehouseBills, String billsType);
  255. /**
  256. * 凯和网页版查询我的订单
  257. * @param tWarehouseBills
  258. * @return
  259. */
  260. public List<TWarehouseBills> webVersionOrder(TWarehouseBills tWarehouseBills);
  261. /**
  262. * 凯和网页版查询我的订单
  263. * @param tWarehouseBills
  264. * @return
  265. */
  266. public List<TWarehouseBills> webVersionOrderMessage(TWarehouseBills tWarehouseBills);
  267. /**
  268. * 后台管理系统查询订单
  269. * @return
  270. */
  271. public List<Map<String,Object>> ruoYiVersionOrderList(LoginUser loginUser,TWarehouseBills tWarehouseBills);
  272. /**
  273. * 网站查询订单
  274. */
  275. public List<Map<String,Object>> webVersionOrderMessage(LoginUser loginUser,TWarehouseBills tWarehouseBills);
  276. /**
  277. * 根据id获取订单信息
  278. * @param tWarehouseBills
  279. * @return
  280. */
  281. public List<TWarehouseBills> webVersionOrderDetails(TWarehouseBills tWarehouseBills);
  282. /**
  283. * 若依维护订单信息
  284. * @param tWarehousebills
  285. * @param tWarehousebillsCntritems
  286. * @param tWarehousebillsfeesCr
  287. * @param tWarehousebillsfeesDr
  288. * @return
  289. */
  290. public AjaxResult ruoYiUpdateOrderMessage(String tWarehousebills,String tWarehousebillsCntritems,
  291. String tWarehousebillsfeesCr,String tWarehousebillsfeesDr,LoginUser loginUser,
  292. String billsType);
  293. /**
  294. * 若依维护订单信息
  295. * @param tWarehousebills
  296. * @param tWarehousebillsCntritems
  297. * @param tWarehousebillsfeesCr
  298. * @param tWarehousebillsfeesDr
  299. * @return
  300. */
  301. public AjaxResult ruoYiSubmitMessage(String tWarehousebills,String tWarehousebillsCntritems,
  302. String tWarehousebillsfeesCr,String tWarehousebillsfeesDr,LoginUser loginUser,
  303. String billsType);
  304. public AjaxResult updateOrderMessage(TWarehouseBills tWarehouseBills);
  305. /**
  306. * app 查询列表信息
  307. * @param warehouseBills
  308. * @return
  309. */
  310. public List<Map<String, Object>> selectAppStockList(TWarehouseBills warehouseBills);
  311. /**
  312. * 根据主表id查询主表对应明细列表数据
  313. * @param warehouseBills
  314. * @return
  315. */
  316. public List<Map<String, Object>> warehouseItemById(TWarehouseBills warehouseBills);
  317. /**
  318. * 根据明细id查询对应明细表数据
  319. * @param fId
  320. * @return
  321. */
  322. public AjaxResult selectWarehouseItemDataById(Long fId);
  323. /**
  324. * 查询app 添加新行 必要的基础资料
  325. * @return
  326. * @param fId
  327. */
  328. public AjaxResult getAppBasicInformation(Long fId);
  329. /**
  330. * app确认入库、出库、货转
  331. * @param item 明细数据
  332. * @param attachs 附件数据
  333. * @return 结果
  334. */
  335. public AjaxResult warehouseOperationConfirmation(String item, String attachs);
  336. /**
  337. * app仓储新行保存业务
  338. * @param item 明细数据
  339. * @param attachs 附件数据
  340. * @return 结果
  341. */
  342. public AjaxResult submitWarehouse(String item, String attachs);
  343. /**
  344. * 查看集港业务
  345. * @param fId 集港id
  346. * @return
  347. */
  348. public AjaxResult selectContainerPort(Long fId);
  349. /**
  350. * 集港业务保存、提交接口
  351. * @param tWarehouseBills 主表业务
  352. * @param feesCr 收费
  353. * @param feesDr 付费
  354. * @return
  355. */
  356. public AjaxResult saveContainerPort(String tWarehouseBills, String feesCr, String feesDr, String type);
  357. /**
  358. * 查询集港业务基础资料
  359. * @return
  360. */
  361. public AjaxResult selectBasicInformation();
  362. /**
  363. * 集港业务撤销
  364. * @param fId 主表id
  365. * @param type
  366. * @return
  367. */
  368. public AjaxResult revokeContainerPort(Long fId, String type);
  369. /**
  370. * 安品景苑采购,入库,出库,销售出库保存
  371. * @param tWarehousebills
  372. * @param tWarehousebillsfees
  373. * @param billsType
  374. * @return
  375. */
  376. public AjaxResult anPingApply(String tWarehousebills,String tWarehousebillsfees,
  377. LoginUser loginUser,String billsType);
  378. /**
  379. * 安品景苑采购,入库,出库,销售出库提交审核
  380. * @param tWarehousebills
  381. * @param tWarehousebillsfees
  382. * @param billsType
  383. * @return
  384. */
  385. public AjaxResult anPinSubmit(String tWarehousebills,String tWarehousebillsfees,
  386. LoginUser loginUser,String billsType);
  387. /**
  388. * 安品景苑查询详情主表
  389. *
  390. * @param fId 详情主表ID
  391. * @return 详情主表
  392. */
  393. public Map<String, Object> selectAnPinById(Long fId);
  394. /**
  395. * 查询详情主表列表
  396. *
  397. * @param tWarehousebills 详情主表
  398. * @return 详情主表集合
  399. */
  400. public List<TWarehouseBills> selectAnPinList(TWarehouseBills tWarehousebills);
  401. /**
  402. * 批量删除详情主表
  403. *
  404. * @param fIds 需要删除的详情主表ID
  405. * @return 结果
  406. */
  407. public int anPinDeleteUpdate(Long[] fIds,LoginUser loginUser);
  408. /**
  409. * 判断能否删除
  410. * @return
  411. */
  412. public AjaxResult removeById(Long fIds);
  413. /**
  414. * 安品景苑生成入库单,出库单,销售出库
  415. * @param tWarehousebills
  416. * @param loginUser
  417. * @return
  418. */
  419. public AjaxResult generateReceipts(TWarehouseBills tWarehousebills,LoginUser loginUser);
  420. /**
  421. * 判断能否修改
  422. * @param tWarehouseBills
  423. * @return
  424. */
  425. public AjaxResult judge (TWarehouseBills tWarehouseBills);
  426. /**
  427. * 删除仓库从表数据
  428. * @param fIds
  429. * @param loginUser
  430. * @return
  431. */
  432. public int anPinDeleteFeeUpdate (Long[] fIds,LoginUser loginUser);
  433. /**
  434. * 安品出入库统计
  435. * @param tWarehousebillsfees
  436. * @return
  437. */
  438. public List<WarhousrExcel> selectTWarehouseInorOut(TWarehousebillsfees tWarehousebillsfees);
  439. /**
  440. * 安品销售出库统计
  441. * @param tWarehouseBills
  442. * @return
  443. */
  444. public List<SalesOfOutbound> salesOfOutbound(TWarehouseBills tWarehouseBills);
  445. /**
  446. * 安品利润统计
  447. * @param tWarehouseBills
  448. * @return
  449. */
  450. public List<ProfitExcel> salectAnpinProfit(TWarehouseBills tWarehouseBills);
  451. /**
  452. * 安品查询库存总账
  453. * @param tWarehouseBills
  454. * @return
  455. */
  456. public List<InventoryLedgerExcel> selectInventoryLedger(TWarehouseBills tWarehouseBills);
  457. }