TWarehouseBillsServiceImpl.java 101 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098
  1. package com.ruoyi.warehouseBusiness.service.impl;
  2. import com.alibaba.fastjson.JSONArray;
  3. import com.alibaba.fastjson.JSONObject;
  4. import com.ruoyi.approvalFlow.domain.AuditItems;
  5. import com.ruoyi.approvalFlow.mapper.AuditItemsMapper;
  6. import com.ruoyi.approvalFlow.service.impl.AuditItemsServiceImpl;
  7. import com.ruoyi.basicData.domain.*;
  8. import com.ruoyi.basicData.mapper.*;
  9. import com.ruoyi.common.core.domain.AjaxResult;
  10. import com.ruoyi.common.core.domain.entity.SysDept;
  11. import com.ruoyi.common.core.domain.entity.SysDictData;
  12. import com.ruoyi.common.core.domain.entity.SysUser;
  13. import com.ruoyi.common.core.domain.model.LoginUser;
  14. import com.ruoyi.common.utils.DateUtils;
  15. import com.ruoyi.common.utils.StringUtils;
  16. import com.ruoyi.reportManagement.domain.TWareHouseItemsExcel;
  17. import com.ruoyi.reportManagement.domain.TWhgenleg;
  18. import com.ruoyi.reportManagement.mapper.TWhgenlegMapper;
  19. import com.ruoyi.system.domain.SysConfig;
  20. import com.ruoyi.system.mapper.SysConfigMapper;
  21. import com.ruoyi.system.mapper.SysDeptMapper;
  22. import com.ruoyi.system.mapper.SysDictDataMapper;
  23. import com.ruoyi.system.mapper.SysUserMapper;
  24. import com.ruoyi.warehouseBusiness.domain.*;
  25. import com.ruoyi.warehouseBusiness.mapper.*;
  26. import com.ruoyi.warehouseBusiness.service.ITWarehouseBillsService;
  27. import org.springframework.beans.factory.annotation.Autowired;
  28. import org.springframework.stereotype.Service;
  29. import org.springframework.transaction.annotation.Transactional;
  30. import org.springframework.transaction.interceptor.TransactionAspectSupport;
  31. import com.ruoyi.common.core.domain.entity.TWarehouse;
  32. import java.math.BigDecimal;
  33. import java.util.*;
  34. import static java.util.stream.Collectors.toList;
  35. /**
  36. * 详情主表Service业务层处理
  37. *
  38. * @author ruoyi
  39. * @date 2020-12-11
  40. */
  41. @Service
  42. public class TWarehouseBillsServiceImpl implements ITWarehouseBillsService {
  43. @Autowired
  44. private TWhgenlegMapper tWhgenlegMapper;
  45. @Autowired
  46. private TGoodsMapper tGoodsMapper;
  47. @Autowired
  48. private SysConfigMapper sysConfigMapper;
  49. @Autowired
  50. private AuditItemsServiceImpl auditItemsService;
  51. @Autowired
  52. private AuditItemsMapper auditItemsMapper;
  53. @Autowired
  54. private SysDeptMapper sysDeptMapper;
  55. @Autowired
  56. private SysUserMapper sysUserMapper;
  57. @Autowired
  58. private TCorpsMapper tCorpsMapper;
  59. @Autowired
  60. private TFeesMapper tFeesMapper;
  61. @Autowired
  62. private TWarehouseMapper tWarehouseMapper;
  63. @Autowired
  64. private SysDictDataMapper sysDictDataMapper;
  65. @Autowired
  66. private TWarehouseAreaMapper tWarehouseAreaMapper;
  67. @Autowired
  68. private TEnclosureMapper tEnclosureMapper;
  69. @Autowired
  70. private TWarehouseBillsMapper tWarehouseBillsMapper;
  71. @Autowired
  72. private TWarehousebillsfeesMapper tWarehousebillsfeesMapper;
  73. @Autowired
  74. private TWarehousebillsitemsMapper tWarehousebillsitemsMapper;
  75. @Autowired
  76. private BillnoSerialServiceImpl billnoSerialServiceImpl;
  77. @Autowired
  78. private BillnoDelMapper billnoDelMapper;
  79. @Autowired
  80. private TWarehousebillsLogMapper tWarehousebillsLogMapper;
  81. @Autowired
  82. private TWarehouseAgreementServiceImpl tWarehouseAgreementService;
  83. /**
  84. * 查询详情主表
  85. *
  86. * @param fId 详情主表ID
  87. * @return 详情主表
  88. */
  89. @Override
  90. public Map<String, Object> selectTWarehousebillsById(Long fId) {
  91. Map<String, Object> map = new HashMap<>();
  92. // 查询仓库主表数据
  93. TWarehouseBills tWarehousebills = tWarehouseBillsMapper.selectTWarehousebillsById(fId);
  94. // 客户表
  95. List<Long> corpsId = new ArrayList<>();
  96. // 用户表
  97. List<SysUser> sysUserList = new ArrayList<>();
  98. // 仓库表
  99. List<TWarehouse> warehouseList = new ArrayList<>();
  100. // 商品
  101. List<Long> goodsId = new ArrayList<>();
  102. // 费用
  103. List<Long> feesId = new ArrayList<>();
  104. // 库区
  105. List<Long> warehouseAreaId = new ArrayList<>();
  106. if (!StringUtils.isNull(tWarehousebills)) {
  107. if (StringUtils.isNotNull(tWarehousebills.getfTocorpid())) {
  108. corpsId.add(tWarehousebills.getfTocorpid());
  109. }
  110. if (StringUtils.isNotNull(tWarehousebills.getfLabour())) {
  111. corpsId.add(tWarehousebills.getfLabour());
  112. }
  113. if (StringUtils.isNotNull(tWarehousebills.getfFleet())) {
  114. corpsId.add(tWarehousebills.getfFleet());
  115. }
  116. corpsId.add(tWarehousebills.getfCorpid());
  117. corpsId.add(tWarehousebills.getfCorpid());
  118. corpsId.add(tWarehousebills.getfCorpid());
  119. // 查询制单人
  120. SysUser logUser = sysUserMapper.selectUserByUserName(tWarehousebills.getCreateBy());
  121. if (StringUtils.isNotNull(logUser)) {
  122. SysDept sysDept = sysDeptMapper.selectDeptById(logUser.getDeptId());
  123. sysUserList.add(logUser);
  124. map.put("dept", sysDept);
  125. }
  126. SysUser sysUser = sysUserMapper.selectUserByUserName(tWarehousebills.getfStorekeeper());
  127. if (StringUtils.isNotNull(sysUser)) {
  128. sysUserList.add(sysUser);
  129. }
  130. // 查询仓库
  131. TWarehouse tWarehouse = tWarehouseMapper.selectTWarehouseById(tWarehousebills.getfWarehouseid());
  132. if (StringUtils.isNotNull(tWarehouse)) {
  133. warehouseList.add(tWarehouse);
  134. }
  135. // 查询经营单位
  136. corpsId.add(tWarehousebills.getfSbu());
  137. map.put("warehousebills", tWarehousebills);
  138. }
  139. // 查询仓库明细从表数据
  140. TWarehousebillsitems tWarehousebillsitems = new TWarehousebillsitems();
  141. tWarehousebillsitems.setfPid(fId);
  142. List<Map<String, Object>> mapList = tWarehousebillsitemsMapper.selectGoodsTransferitemsList(tWarehousebillsitems);
  143. if (StringUtils.isNotEmpty(mapList)) {
  144. for (Map<String, Object> wb : mapList) {
  145. /*TWhgenleg tWhgenleg = new TWhgenleg();
  146. tWhgenleg.setfCorpid(tWarehousebills.getfCorpid());
  147. if (StringUtils.isNotNull(wb.get("fGoodsid"))) {
  148. tWhgenleg.setfGoodsid(((Integer) wb.get("fGoodsid")).longValue());
  149. }
  150. if (StringUtils.isNotNull(wb.get("fWarehouselocid"))) {
  151. tWhgenleg.setfWarehouseLocationid(((Integer) wb.get("fWarehouselocid")).longValue());
  152. }
  153. tWhgenleg.setfTrademodeid(tWarehousebills.getfTrademodeid());
  154. tWhgenleg.setfMblno(tWarehousebills.getfMblno());
  155. TWhgenleg whgenleg = tWhgenlegMapper.selectTWhgenleg(tWhgenleg);
  156. if (StringUtils.isNotNull(whgenleg)) {
  157. wb.put("fQtyblc", whgenleg.getfQtyblc());
  158. }*/
  159. if (StringUtils.isNotNull(wb.get("fGoodsid"))) {
  160. Integer fGoodsid = (Integer) wb.get("fGoodsid");
  161. goodsId.add(fGoodsid.longValue());
  162. }
  163. if (StringUtils.isNotNull(wb.get("fWarehouselocid"))) {
  164. Long fWarehouselocid = Long.valueOf(String.valueOf(wb.get("fWarehouselocid")));
  165. if (wb.get("fTransferWarehouselocid") != null) {
  166. Long fTransferWarehouselocid = Long.valueOf(String.valueOf(wb.get("fTransferWarehouselocid")));
  167. warehouseAreaId.add(fTransferWarehouselocid);
  168. }
  169. warehouseAreaId.add(fWarehouselocid);
  170. }
  171. }
  172. map.put("warehouseBillsItem", mapList);
  173. }
  174. // 查询仓库费用明细表数据
  175. TWarehousebillsfees tWarehousebillsfees = new TWarehousebillsfees();
  176. tWarehousebillsfees.setfPid(fId);
  177. List<TWarehousebillsfees> warehousebillsfeesDr = new ArrayList<>();
  178. List<TWarehousebillsfees> warehousebillsfeesCr = new ArrayList<>();
  179. List<TWarehousebillsfees> warehousebillsfees = tWarehousebillsfeesMapper.selectTWarehousebillsfeesList(tWarehousebillsfees);
  180. if (StringUtils.isNotEmpty(warehousebillsfees)) {
  181. for (TWarehousebillsfees fees : warehousebillsfees) {
  182. if ("C".equals(fees.getfDc())) {
  183. warehousebillsfeesCr.add(fees);
  184. } else {
  185. warehousebillsfeesDr.add(fees);
  186. }
  187. corpsId.add(fees.getfCorpid());
  188. feesId.add(fees.getfFeeid());
  189. }
  190. }
  191. // 查询附件表数据
  192. TEnclosure enclosure = new TEnclosure();
  193. enclosure.setfPid(fId);
  194. List<TEnclosure> enclosures = tEnclosureMapper.selectTEnclosureList(enclosure);
  195. if (StringUtils.isNotEmpty(enclosures)) {
  196. map.put("enclosures", enclosures);
  197. }
  198. List<TCorps> corpsList = new ArrayList<>();
  199. List<Long> corpsIdList = StringUtils.integerDeduplication(corpsId);
  200. for (Long corpId : corpsIdList) {
  201. TCorps corps = tCorpsMapper.selectTCorpsById(corpId);
  202. if (StringUtils.isNotNull(corps)) {
  203. corpsList.add(corps);
  204. }
  205. }
  206. List<TWarehouseArea> warehouseAreaList = new ArrayList<>();
  207. /*List<Long> warehouseAreaIdList = StringUtils.integerDeduplication(warehouseAreaId);
  208. for (Long warehouseArea : warehouseAreaIdList) {
  209. TWarehouseArea tWarehouseArea = tWarehouseAreaMapper.selectTWarehouseAreaById(warehouseArea);
  210. if (StringUtils.isNotNull(tWarehouseArea)) {
  211. warehouseAreaList.add(tWarehouseArea);
  212. }
  213. }*/
  214. List<TGoods> goodsList = new ArrayList<>();
  215. List<Long> goodsIdList = StringUtils.integerDeduplication(goodsId);
  216. for (Long goods : goodsIdList) {
  217. TGoods tGoods = tGoodsMapper.selectTGoodsById(goods);
  218. if (StringUtils.isNotNull(tGoods)) {
  219. goodsList.add(tGoods);
  220. }
  221. }
  222. List<TFees> feesList = new ArrayList<>();
  223. List<Long> longList = StringUtils.integerDeduplication(feesId);
  224. for (Long fees : longList) {
  225. TFees tFees = tFeesMapper.selectTFeesById(fees);
  226. if (StringUtils.isNotNull(tFees)) {
  227. feesList.add(tFees);
  228. }
  229. }
  230. map.put("corps", corpsList);
  231. map.put("goodsList", goodsList);
  232. map.put("feesList", feesList);
  233. map.put("sysUser", sysUserList);
  234. map.put("warehouse", warehouseList);
  235. map.put("warehouseAreas", warehouseAreaList);
  236. map.put("warehousebillsfeesDr", warehousebillsfeesDr);
  237. map.put("warehousebillsfeesCr", warehousebillsfeesCr);
  238. map.put("dept", sysDeptMapper.selectDeptById(tWarehousebills.getfDeptid()));
  239. return map;
  240. }
  241. /**
  242. * 查询详情主表列表
  243. *
  244. * @param tWarehousebills 详情主表
  245. * @return 详情主表
  246. */
  247. @Override
  248. public List<Map<String, Object>> selectWarehouseBusinessList(TWarehouseBills tWarehousebills) {
  249. return tWarehouseBillsMapper.selectWarehouseBusinessList(tWarehousebills);
  250. }
  251. /**
  252. * 查询导出所需主表列表
  253. *
  254. * @param tWarehousebills 详情主表
  255. * @return 详情主表
  256. */
  257. @Override
  258. public List<TWarehouseBills> selectTWarehousebillsList(TWarehouseBills tWarehousebills) {
  259. return tWarehouseBillsMapper.selectTWarehousebillsList(tWarehousebills);
  260. }
  261. /**
  262. * 根据条件查询总账是否存在
  263. *
  264. * @param warehouseBills 仓库主表
  265. * @param warehousebillsitems 仓库明细表
  266. * @return 库存总账
  267. */
  268. public TWhgenleg queryTWhgenleg(TWarehouseBills warehouseBills, TWarehousebillsitems warehousebillsitems) {
  269. TWhgenleg tWhgenleg = new TWhgenleg();
  270. // 客户
  271. tWhgenleg.setfCorpid(warehouseBills.getfCorpid());
  272. // 提单号
  273. if ("HQZY".equals(warehouseBills.getfBilltype()) || "CKDB".equals(warehouseBills.getfBilltype())) {
  274. tWhgenleg.setfMblno(warehousebillsitems.getfMblno());
  275. } else {
  276. tWhgenleg.setfMblno(warehouseBills.getfMblno());
  277. }
  278. // 库区
  279. tWhgenleg.setfWarehouseLocationid(warehousebillsitems.getfWarehouselocid());
  280. // 货物品名
  281. tWhgenleg.setfGoodsid(warehousebillsitems.getfGoodsid());
  282. // 贸易方式
  283. tWhgenleg.setfTrademodeid(warehouseBills.getfTrademodeid());
  284. return tWhgenlegMapper.selectTWhgenleg(tWhgenleg);
  285. }
  286. /**
  287. * 新增库存总账
  288. *
  289. * @param warehouseBills 仓库主表
  290. * @param warehousebillsitems 仓库明细表
  291. * @return 结果
  292. */
  293. @Transactional
  294. public int instalTWhgenleg(TWarehouseBills warehouseBills, TWarehousebillsitems warehousebillsitems, SysUser user) {
  295. TWhgenleg tWhgenleg = new TWhgenleg();
  296. if ("SJRK".equals(warehouseBills.getfBilltype())) {
  297. tWhgenleg.setfOriginalbilldate(warehousebillsitems.getfBsdate());
  298. }
  299. if ("HQZY".equals(warehouseBills.getfBilltype()) || "CKDB".equals(warehouseBills.getfBilltype())) {
  300. tWhgenleg.setfOriginalbilldate(warehousebillsitems.getfOriginalbilldate());
  301. if ("CKDB".equals(warehouseBills.getfBilltype())) {
  302. tWhgenleg.setfCorpid(warehouseBills.getfCorpid());
  303. } else {
  304. // 客户
  305. tWhgenleg.setfCorpid(warehouseBills.getfTocorpid());
  306. }
  307. // 提单号
  308. tWhgenleg.setfMblno(warehousebillsitems.getfMblno());
  309. // 原始单号
  310. tWhgenleg.setfOriginalbillno(warehousebillsitems.getfMblno());
  311. } else {
  312. // 客户
  313. tWhgenleg.setfCorpid(warehouseBills.getfCorpid());
  314. // 提单号
  315. tWhgenleg.setfMblno(warehouseBills.getfMblno());
  316. // 原始单号
  317. tWhgenleg.setfOriginalbillno(warehouseBills.getfMblno());
  318. }
  319. // 明细类型
  320. tWhgenleg.setfBusinessType(warehousebillsitems.getfBusinessType());
  321. // 仓库
  322. tWhgenleg.setfWarehouseid(warehouseBills.getfWarehouseid());
  323. // 库区
  324. tWhgenleg.setfWarehouseLocationid(warehousebillsitems.getfWarehouselocid());
  325. // 货物品名
  326. tWhgenleg.setfGoodsid(warehousebillsitems.getfGoodsid());
  327. // 计费方式
  328. tWhgenleg.setfBillingway(warehousebillsitems.getfBillingway());
  329. // 仓储计费日期
  330. tWhgenleg.setfChargedate(warehousebillsitems.getfChargedate());
  331. // 贸易方式
  332. tWhgenleg.setfTrademodeid(warehouseBills.getfTrademodeid());
  333. // 入库数
  334. tWhgenleg.setfQtyd(warehousebillsitems.getfQty());
  335. // 入库尺码
  336. tWhgenleg.setfVolumnd(warehousebillsitems.getfVolumn());
  337. // 唛头
  338. tWhgenleg.setfMarks(warehousebillsitems.getfMarks());
  339. // 入库毛重
  340. tWhgenleg.setfGrossweightd(warehousebillsitems.getfGrossweight());
  341. // 入库净重
  342. tWhgenleg.setfNetweightd(warehousebillsitems.getfNetweight());
  343. // 入库箱号
  344. tWhgenleg.setfCntrno(warehousebillsitems.getfCntrno());
  345. // 创建人
  346. tWhgenleg.setCreateBy(user.getUserName());
  347. // 创建人
  348. tWhgenleg.setCreateTime(new Date());
  349. // 状态
  350. tWhgenleg.setfStatus("T");
  351. // 结余件数
  352. tWhgenleg.setfQtyblc(warehousebillsitems.getfQty());
  353. return tWhgenlegMapper.insertTWhgenleg(tWhgenleg);
  354. }
  355. @Transactional
  356. public int updateTWhgenlegData(TWarehousebillsitems warehousebillsitems, long whgenlegId, String billtype) {
  357. Map<String, Object> map = new HashMap<>();
  358. map.put("whgenlegId", whgenlegId);
  359. map.put("billType", billtype);
  360. map.put("warehousebillsitems", warehousebillsitems);
  361. return tWhgenlegMapper.updateTWhgenlegData(map);
  362. }
  363. /**
  364. * 仓库暂存接口
  365. *
  366. * @param tWarehouseBills 仓库主表
  367. * @param tWarehousebillsfeesCr 仓库费付款用明细表
  368. * @param tWarehousebillsfeesDr 仓库费收
  369. * 款用明细表
  370. * @param tWarehousebillsitems 仓库货物明细表
  371. * @param loginUser 当前登陆人
  372. * @param billsType 判断标识
  373. * @return 结果
  374. */
  375. @Override
  376. @Transactional
  377. public AjaxResult insertTWarehousebills(String tWarehouseBills, String tWarehousebillsfeesCr, String tWarehousebillsfeesDr
  378. , String tWarehousebillsitems, String tEnclosure, LoginUser loginUser, String billsType) {
  379. Long fPid = null;
  380. Map<String, Object> map = new HashMap<>();
  381. TWarehouseBills warehouseBills = JSONArray.parseObject(tWarehouseBills, TWarehouseBills.class);
  382. if (StringUtils.isNull(warehouseBills.getfId())) {
  383. // 如果是新数据
  384. warehouseBills.setfBillstatus(2L);
  385. warehouseBills.setCreateBy(loginUser.getUser().getUserName());
  386. warehouseBills.setfBilltype(billsType);
  387. warehouseBills.setfBsdeptid(loginUser.getUser().getDeptId());
  388. // 业务编码
  389. String billNo = billnoSerialServiceImpl.getBillNo(billsType, warehouseBills.getfBsdate());
  390. warehouseBills.setfBillno(billNo);
  391. if ("SJRK".equals(billsType)) {
  392. // 存货编码
  393. Date time = new Date();
  394. String bscorpno = billnoSerialServiceImpl.getCorpNo(warehouseBills.getfCorpid(), time);
  395. warehouseBills.setfBscorpno(bscorpno);
  396. } else {
  397. warehouseBills.setfChargedate(warehouseBills.getfBsdate());
  398. }
  399. tWarehouseBillsMapper.insertTWarehousebills(warehouseBills);
  400. fPid = warehouseBills.getfId();
  401. } else {
  402. fPid = warehouseBills.getfId();
  403. if (!"SJRK".equals(billsType)) {
  404. warehouseBills.setfChargedate(warehouseBills.getfBsdate());
  405. }
  406. warehouseBills.setUpdateBy(loginUser.getUser().getUserName());
  407. warehouseBills.setUpdateTime(new Date());
  408. tWarehouseBillsMapper.updateTWarehousebills(warehouseBills);
  409. tWarehousebillsfeesMapper.deleteByFPid(fPid);
  410. tEnclosureMapper.deleteByFPid(fPid);
  411. // 删除 从表中 未打印账单的数据
  412. deleteBillsitems(fPid, tWarehousebillsitems);
  413. }
  414. // 库存明细添加
  415. if (StringUtils.isNotNull(tWarehousebillsitems) && !"[]".equals(tWarehousebillsitems)) {
  416. JSONArray warehouseJSON = JSONArray.parseArray(tWarehousebillsitems);
  417. List<TWarehousebillsitems> warehousebillsitemsList = JSONObject.parseArray(warehouseJSON.toJSONString(), TWarehousebillsitems.class);
  418. for (TWarehousebillsitems wbItem : warehousebillsitemsList) {
  419. boolean warehouseStatus = "SJRK".equals(billsType) || "SJCK".equals(billsType) || "CKDB".equals(billsType);
  420. // 仓储计费日期
  421. wbItem.setfBilltype(billsType);
  422. if ("SJRK".equals(billsType)) {
  423. wbItem.setfChargedate(warehouseBills.getfChargedate());
  424. wbItem.setfBillingway(warehouseBills.getfBillingway());
  425. }
  426. if (null != wbItem.getfId()) {
  427. wbItem.setUpdateTime(new Date());
  428. wbItem.setUpdateBy(loginUser.getUser().getUserName());
  429. tWarehousebillsitemsMapper.updateTWarehousebillsitems(wbItem);
  430. } else {
  431. // 添加主表 业务单号
  432. wbItem.setfBillno(warehouseBills.getfBillno());
  433. if (!warehouseStatus) {
  434. // wbItem.setfMblno(warehouseBills.getfMblno());
  435. wbItem.setfBillstatus(1L);
  436. } else {
  437. wbItem.setfBillstatus(10L);
  438. }
  439. wbItem.setfPid(fPid);
  440. wbItem.setCreateBy(loginUser.getUser().getUserName());
  441. wbItem.setCreateTime(new Date());
  442. tWarehousebillsitemsMapper.insertTWarehousebillsitems(wbItem);
  443. if (!warehouseStatus) {
  444. // 添加状态log
  445. insertTWarehousebillsLog(wbItem, 10L, loginUser);
  446. }
  447. }
  448. }
  449. }
  450. // 附件添加
  451. if (StringUtils.isNotNull(tEnclosure) && !"[]".equals(tEnclosure)) {
  452. JSONArray jsonDrArray = JSONArray.parseArray(tEnclosure);
  453. List<TEnclosure> tEnclosureList = JSONObject.parseArray(jsonDrArray.toJSONString(), TEnclosure.class);
  454. for (TEnclosure enclosure : tEnclosureList) {
  455. enclosure.setfPid(fPid);
  456. enclosure.setCreateBy(loginUser.getUser().getUserName());
  457. enclosure.setCreateTime(new Date());
  458. tEnclosureMapper.insertTEnclosure(enclosure);
  459. }
  460. }
  461. // 收款明细添加
  462. if (StringUtils.isNotNull(tWarehousebillsfeesDr) && !"[]".equals(tWarehousebillsfeesDr)) {
  463. JSONArray jsonDrArray = JSONArray.parseArray(tWarehousebillsfeesDr);
  464. List<TWarehousebillsfees> warehousebillsfeesDrList = JSONObject.parseArray(jsonDrArray.toJSONString(), TWarehousebillsfees.class);
  465. for (TWarehousebillsfees wbDr : warehousebillsfeesDrList) {
  466. // 检验 数量*单价=金额
  467. wbDr.setfPid(fPid);
  468. wbDr.setfDc("D");
  469. wbDr.setfBilltype(billsType);
  470. wbDr.setCreateTime(new Date());
  471. wbDr.setSrcBillNo(warehouseBills.getfBillno());
  472. wbDr.setfChargedate(warehouseBills.getfChargedate());
  473. wbDr.setfBillingDeadline(warehouseBills.getfChargedate());
  474. wbDr.setCreateBy(loginUser.getUser().getUserName());
  475. if (warehouseBills.getfBsdate() != null && !warehouseBills.getfBsdate().equals("")) {
  476. wbDr.setfBsdate(warehouseBills.getfBsdate());
  477. }
  478. tWarehousebillsfeesMapper.insertTWarehousebillsfees(wbDr);
  479. }
  480. }
  481. // 付款明细添加
  482. if (StringUtils.isNotNull(tWarehousebillsfeesCr) && !"[]".equals(tWarehousebillsfeesCr)) {
  483. JSONArray jsonCrArray = JSONArray.parseArray(tWarehousebillsfeesCr);
  484. List<TWarehousebillsfees> warehousebillsfeesCrList = JSONObject.parseArray(jsonCrArray.toJSONString(), TWarehousebillsfees.class);
  485. for (TWarehousebillsfees wbCr : warehousebillsfeesCrList) {
  486. wbCr.setfPid(fPid);
  487. wbCr.setfDc("C");
  488. wbCr.setfBilltype(billsType);
  489. wbCr.setCreateTime(new Date());
  490. wbCr.setSrcBillNo(warehouseBills.getfBillno());
  491. wbCr.setCreateBy(loginUser.getUser().getUserName());
  492. wbCr.setfChargedate(warehouseBills.getfChargedate());
  493. wbCr.setfBillingDeadline(warehouseBills.getfChargedate());
  494. if (warehouseBills.getfBsdate() != null && !warehouseBills.getfBsdate().equals("")) {
  495. wbCr.setfBsdate(warehouseBills.getfBsdate());
  496. }
  497. tWarehousebillsfeesMapper.insertTWarehousebillsfees(wbCr);
  498. }
  499. }
  500. TWarehousebillsitems warehousebillsitems = new TWarehousebillsitems();
  501. warehousebillsitems.setfPid(fPid);
  502. map.put("warehouseBills", warehouseBills);
  503. map.put("warehousebillsitems", tWarehousebillsitemsMapper.selectGoodsTransferitemsList(warehousebillsitems));
  504. return AjaxResult.success("成功", map);
  505. }
  506. /**
  507. * 仓库模块提交接口
  508. *
  509. * @param tWarehouseBills 仓库主表
  510. * @param tWarehousebillsfeesCr 仓库费用付款明细表
  511. * @param tWarehousebillsfeesDr 仓库费用收款明细表
  512. * @param tWarehousebillsitems 仓库货物明细表
  513. * @param tEnclosure
  514. * @param loginUser 当前登陆人
  515. * @param billsType 操作状态
  516. * @return
  517. */
  518. @Override
  519. @Transactional
  520. public AjaxResult warehouseSubmission(String tWarehouseBills, String tWarehousebillsfeesCr, String tWarehousebillsfeesDr,
  521. String tWarehousebillsitems, String tEnclosure, LoginUser loginUser, String billsType) {
  522. Long fPid = null;
  523. boolean isApprove = false;
  524. String key = "";
  525. long actId = 0L;
  526. if ("SJRK".equals(billsType)) {
  527. actId = 110L;
  528. key = "warehouse.inStock.ApprovalFlow";
  529. } else if ("SJCK".equals(billsType)) {
  530. actId = 120L;
  531. key = "warehouse.outStock.ApprovalFlow";
  532. } else if ("CKDB".equals(billsType)) {
  533. actId = 140L;
  534. key = "warehouse.stockTransfer.ApprovalFlow";
  535. } else if ("HQZY".equals(billsType)) {
  536. actId = 130L;
  537. key = "warehouse.transfer.ApprovalFlow";
  538. }
  539. SysConfig sysConfig = sysConfigMapper.checkConfigKeyUnique(key);
  540. if (StringUtils.isNull(sysConfig)) {
  541. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  542. return AjaxResult.error("系统参数异常,未找到开启审批流参数");
  543. }
  544. if ("0".equals(sysConfig.getConfigValue())) {
  545. isApprove = true;
  546. }
  547. TWarehouseBills warehouseBills = JSONArray.parseObject(tWarehouseBills, TWarehouseBills.class);
  548. warehouseBills.setfItemsStatus(4L);
  549. if (StringUtils.isNull(warehouseBills.getfId())) {
  550. if (isApprove) {
  551. warehouseBills.setfBillstatus(4L);
  552. } else {
  553. warehouseBills.setfBillstatus(6L);
  554. warehouseBills.setfReviewDate(new Date());
  555. }
  556. warehouseBills.setfBilltype(billsType);
  557. if (!"SJRK".equals(billsType)) {
  558. warehouseBills.setfChargedate(warehouseBills.getfBsdate());
  559. }
  560. warehouseBills.setfBsdeptid(loginUser.getUser().getDeptId());
  561. warehouseBills.setCreateBy(loginUser.getUser().getUserName());
  562. String billNo = billnoSerialServiceImpl.getBillNo(billsType, warehouseBills.getfBsdate());
  563. warehouseBills.setfBillno(billNo);
  564. Date time = new Date();
  565. String bscorpno = billnoSerialServiceImpl.getCorpNo(warehouseBills.getfCorpid(), time);
  566. warehouseBills.setfBscorpno(bscorpno);
  567. tWarehouseBillsMapper.insertTWarehousebills(warehouseBills);
  568. fPid = warehouseBills.getfId();
  569. } else {
  570. fPid = warehouseBills.getfId();
  571. if (isApprove) {
  572. warehouseBills.setfBillstatus(4L);
  573. } else {
  574. warehouseBills.setfBillstatus(6L);
  575. warehouseBills.setfReviewDate(new Date());
  576. }
  577. warehouseBills.setUpdateTime(new Date());
  578. if (!"SJRK".equals(billsType)) {
  579. warehouseBills.setfChargedate(warehouseBills.getfBsdate());
  580. }
  581. warehouseBills.setUpdateBy(loginUser.getUser().getUserName());
  582. tEnclosureMapper.deleteByFPid(fPid);
  583. tWarehousebillsfeesMapper.deleteByFPid(fPid);
  584. tWarehousebillsitemsMapper.deleteByFPid(fPid);
  585. tWarehouseBillsMapper.updateTWarehousebills(warehouseBills);
  586. }
  587. JSONArray warehouseJSON = JSONArray.parseArray(tWarehousebillsitems);
  588. List<TWarehousebillsitems> warehousebillsitemsList = JSONObject.parseArray(warehouseJSON.toJSONString(), TWarehousebillsitems.class);
  589. int line = 0;
  590. for (TWarehousebillsitems wbItem : warehousebillsitemsList) {
  591. line++;
  592. if ("SJRK".equals(billsType) || "SJCK".equals(billsType) || "CKDB".equals(billsType)) {
  593. // 除了入库其他模块不需要更新主表的 仓储费计费日期到明细表,其他模块 应从库存总账把仓储费计费日期 赋给明细表
  594. if ("SJRK".equals(billsType)) {
  595. wbItem.setfMblno(warehouseBills.getfMblno());
  596. wbItem.setfBillingway(warehouseBills.getfBillingway());
  597. wbItem.setfChargedate(warehouseBills.getfChargedate());
  598. wbItem.setfOriginalbilldate(warehouseBills.getfBsdate());
  599. }
  600. if (!wbItem.getfBillstatus().equals(40L)) {
  601. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  602. return AjaxResult.error("库存明细第" + line + "行状态异常,请确认");
  603. }
  604. } else {
  605. if (!wbItem.getfBillstatus().equals(6L)) {
  606. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  607. return AjaxResult.error("库存明细第" + line + "行状态异常,请确认");
  608. }
  609. }
  610. if (StringUtils.isNull(wbItem.getfChargedate())) {
  611. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  612. return AjaxResult.error("库存明细第" + line + "行未找到仓储费计费日期,请确认");
  613. }
  614. if (StringUtils.isNull(wbItem.getfBillingway())) {
  615. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  616. return AjaxResult.error("库存明细第" + line + "行未找到计费方式,请确认");
  617. }
  618. if (StringUtils.isNull(wbItem.getfOriginalbilldate())) {
  619. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  620. return AjaxResult.error("库存明细第" + line + "行未找到入库日期,请确认");
  621. }
  622. wbItem.setfPid(fPid);
  623. wbItem.setfBilltype(billsType);
  624. wbItem.setCreateTime(new Date());
  625. wbItem.setfBillno(warehouseBills.getfBillno());
  626. wbItem.setCreateBy(loginUser.getUser().getUserName());
  627. tWarehousebillsitemsMapper.insertTWarehousebillsitems(wbItem);
  628. }
  629. if (StringUtils.isNotNull(tWarehousebillsfeesCr) && !"[]".equals(tWarehousebillsfeesCr)) {
  630. JSONArray jsonCrArray = JSONArray.parseArray(tWarehousebillsfeesCr);
  631. List<TWarehousebillsfees> warehousebillsfeesCrList = JSONObject.parseArray(jsonCrArray.toJSONString(), TWarehousebillsfees.class);
  632. for (TWarehousebillsfees wbCr : warehousebillsfeesCrList) {
  633. wbCr.setfPid(fPid);
  634. wbCr.setfDc("C");
  635. wbCr.setfBilltype(billsType);
  636. wbCr.setCreateTime(new Date());
  637. wbCr.setSrcBillNo(warehouseBills.getfBillno());
  638. wbCr.setCreateBy(loginUser.getUser().getUserName());
  639. wbCr.setfChargedate(warehouseBills.getfChargedate());
  640. wbCr.setfBillingDeadline(warehouseBills.getfChargedate());
  641. if (warehouseBills.getfBsdate() != null && !warehouseBills.getfBsdate().equals("")) {
  642. wbCr.setfBsdate(warehouseBills.getfBsdate());
  643. }
  644. tWarehousebillsfeesMapper.insertTWarehousebillsfees(wbCr);
  645. }
  646. }
  647. if (StringUtils.isNotNull(tWarehousebillsfeesDr) && !"[]".equals(tWarehousebillsfeesDr)) {
  648. JSONArray jsonCrArray = JSONArray.parseArray(tWarehousebillsfeesDr);
  649. List<TWarehousebillsfees> warehousebillsfeesDrList = JSONObject.parseArray(jsonCrArray.toJSONString(), TWarehousebillsfees.class);
  650. for (TWarehousebillsfees wbDr : warehousebillsfeesDrList) {
  651. wbDr.setfPid(fPid);
  652. wbDr.setfDc("D");
  653. wbDr.setfBillstatus(4L);
  654. wbDr.setfBilltype(billsType);
  655. wbDr.setCreateTime(new Date());
  656. wbDr.setSrcBillNo(warehouseBills.getfBillno());
  657. wbDr.setCreateBy(loginUser.getUser().getUserName());
  658. wbDr.setfChargedate(warehouseBills.getfChargedate());
  659. wbDr.setfBillingDeadline(warehouseBills.getfChargedate());
  660. if (warehouseBills.getfBsdate() != null && !warehouseBills.getfBsdate().equals("")) {
  661. wbDr.setfBsdate(warehouseBills.getfBsdate());
  662. }
  663. tWarehousebillsfeesMapper.insertTWarehousebillsfees(wbDr);
  664. }
  665. }
  666. if (StringUtils.isNotNull(tEnclosure) && !"[]".equals(tEnclosure)) {
  667. JSONArray jsonEnclosureArray = JSONArray.parseArray(tEnclosure);
  668. List<TEnclosure> enclosuresList = JSONObject.parseArray(jsonEnclosureArray.toJSONString(), TEnclosure.class);
  669. long lineNo = 0L;
  670. for (TEnclosure enclosure : enclosuresList) {
  671. lineNo++;
  672. enclosure.setfPid(fPid);
  673. enclosure.setfLineno(lineNo);
  674. enclosure.setCreateTime(new Date());
  675. enclosure.setCreateBy(loginUser.getUser().getUserName());
  676. tEnclosureMapper.insertTEnclosure(enclosure);
  677. }
  678. }
  679. // 这里加个判断取系统参数来确定是否需要启用审批流
  680. if (isApprove) {
  681. AuditItems auditItems = new AuditItems();
  682. auditItems.setLevelId(0L);
  683. auditItems.setBillId(fPid);
  684. auditItems.setActId(actId);
  685. auditItems.setIffinalItem("F");
  686. auditItems.setBillNo(warehouseBills.getfBillno());
  687. // 存储委托方(货权方)
  688. auditItems.setRefno1(warehouseBills.getfCorpid() + "");
  689. // 存储业务类型(业务类型)
  690. auditItems.setRefno2(warehouseBills.getfBilltype());
  691. // 存储提单号(提单号)
  692. auditItems.setRefno3(warehouseBills.getfMblno());
  693. auditItems.setSendUserId(loginUser.getUser().getUserId());
  694. auditItems.setSendName(loginUser.getUsername());
  695. auditItems.setSendTime(new Date());
  696. auditItems.setAuditUserId(loginUser.getUser().getUserId());
  697. auditItems.setAuditItem(new Date());
  698. auditItems.setAuditOpTime(new Date());
  699. auditItems.setAuditMsg("提交");
  700. auditItems.setAuditStatus("O");
  701. AjaxResult approvalFlow = auditItemsService.createApprovalFlow(auditItems);
  702. // Long code = Long.valueOf(String.valueOf(approvalFlow.get("code"))).longValue();
  703. String code = approvalFlow.get("code").toString();
  704. // Long code = Long.valueOf(String.valueOf(ajaxResult.get("code"))).longValue();
  705. if ("500".equals(code)) {
  706. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  707. }
  708. return approvalFlow;
  709. } else {
  710. AjaxResult ajaxResult = warehouseFollow(fPid, 6L);
  711. String code = ajaxResult.get("code").toString();
  712. // Long code = Long.valueOf(String.valueOf(ajaxResult.get("code"))).longValue();
  713. if ("500".equals(code)) {
  714. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  715. }
  716. return ajaxResult;
  717. }
  718. }
  719. @Override
  720. public List<TWareHouseExcelItems> selectTWarehousebillsItemsList(Long fId) {
  721. return tWarehouseBillsMapper.selectTWarehousebillsItemsList(fId);
  722. }
  723. @Override
  724. public List<Map<String, Object>> selectInventoryList(TWarehouseBills tWarehouseBills) {
  725. if(StringUtils.isNotNull(tWarehouseBills.getfWarehouseid())){
  726. // 获取仓库信息
  727. TWarehouse tWarehouse = tWarehouseMapper.selectTWarehouseById(tWarehouseBills.getfWarehouseid());
  728. if(tWarehouse.getfLocation()==1){
  729. tWarehouseBills.setfLocation(1L);
  730. }else {
  731. tWarehouseBills.setfLocation(0L);
  732. }
  733. }
  734. if(tWarehouseBills.getfBilltype().equals("SJRK")){
  735. return tWarehouseBillsMapper.selectInventorySJRKList(tWarehouseBills);
  736. }else {
  737. return tWarehouseBillsMapper.selectInventorySJCKList(tWarehouseBills);
  738. }
  739. }
  740. @Override
  741. public List<TWareHouseItemsExcel> selectTWarehousebillsItemsList(TWarehouseBills tWarehouseBills) {
  742. return tWarehouseBillsMapper.selectTWarehousebillsItemList(tWarehouseBills);
  743. }
  744. /**
  745. * 根据仓库主表id 更新对应明细表状态
  746. *
  747. * @param fPid 仓库主表id
  748. * @return 结果
  749. */
  750. @Transactional
  751. public AjaxResult warehouseFollow(Long fPid, long fettle) {
  752. if (StringUtils.isNull(fPid)) {
  753. return AjaxResult.error("仓库更新状态未找到主表信息,请与管理员联系");
  754. }
  755. try {
  756. tWarehouseBillsMapper.warehouseFollowUpdate(fPid, fettle, new Date());
  757. tWarehousebillsfeesMapper.warehouseFeesFollowUpdate(fPid, fettle, new Date());
  758. TWarehouseBills tWarehouseBills = tWarehouseBillsMapper.selectTWarehousebillsById(fPid);
  759. if ("SJRK".equals(tWarehouseBills.getfBilltype()) || "SJCK".equals(tWarehouseBills.getfBilltype())) {
  760. fettle = 40L;
  761. }
  762. tWarehousebillsitemsMapper.warehouseItemFollowUpdate(fPid, fettle);
  763. } catch (Exception e) {
  764. return AjaxResult.error("更新库存费用状态失败,请联系管理员");
  765. }
  766. return AjaxResult.success();
  767. }
  768. /**
  769. * 根据仓库主表id 更新对应明细表状态
  770. *
  771. * @param fPid 仓库主表id
  772. * @return 结果
  773. */
  774. @Transactional
  775. public AjaxResult storageFeeFollow(Long fPid, long fettle) {
  776. if (StringUtils.isNull(fPid)) {
  777. return AjaxResult.error("仓库更新状态未找到主表信息,请与管理员联系");
  778. }
  779. int warehouseUpdateResult = tWarehouseBillsMapper.warehouseFollowUpdate(fPid, fettle, new Date());
  780. if (warehouseUpdateResult <= 0) {
  781. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  782. return AjaxResult.error("更新库存明细状态失败,请联系管理员");
  783. }
  784. TWarehousebillsfees warehousebillsfees = new TWarehousebillsfees();
  785. warehousebillsfees.setfPid(fPid);
  786. List<TWarehousebillsfees> warehousebillsfeesList = tWarehousebillsfeesMapper.selectTWarehousebillsfeesList(warehousebillsfees);
  787. for (TWarehousebillsfees wareItem : warehousebillsfeesList) {
  788. if (StringUtils.isNull(wareItem.getSrcId())) {
  789. continue;
  790. }
  791. if ("KCZZ".equals(wareItem.getfBilltype())) {
  792. TWhgenleg tWhgenleg = tWhgenlegMapper.selectTWhgenlegById(wareItem.getSrcId());
  793. tWhgenleg.setfChargedate(DateUtils.dateAdd(wareItem.getfBillingDeadline(), 1));
  794. int i = tWhgenlegMapper.updateTWhgenleg(tWhgenleg);
  795. if (i <= 0) {
  796. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  797. return AjaxResult.error("更新库存费用状态失败,请联系管理员");
  798. }
  799. } else {
  800. TWarehousebillsitems tWarehousebillsitems = tWarehousebillsitemsMapper.selectTWarehousebillsitemsById(wareItem.getSrcId());
  801. tWarehousebillsitems.setfChargedate(DateUtils.dateAdd(wareItem.getfBillingDeadline(), 1));
  802. if ("SJCK".equals(wareItem.getfBilltype())) {
  803. tWarehousebillsitems.setfStorageFeeDeadline(wareItem.getfBillingDeadline());
  804. }
  805. tWarehousebillsitemsMapper.updateTWarehousebillsitems(tWarehousebillsitems);
  806. }
  807. }
  808. int feesUpdateResult = tWarehousebillsfeesMapper.warehouseFeesFollowUpdate(fPid, fettle, new Date());
  809. if (feesUpdateResult <= 0) {
  810. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  811. return AjaxResult.error("更新库存费用状态失败,请联系管理员");
  812. }
  813. return AjaxResult.success();
  814. }
  815. /**
  816. * 入库详情入账
  817. *
  818. * @param warehouseBills 主表
  819. * @param warehousebillsitems 明细
  820. * @param loginUser 当前登录人
  821. * @param billsType 状态
  822. * @return 结果
  823. */
  824. @Override
  825. @Transactional
  826. public AjaxResult addCredit(String warehouseBills, String warehousebillsitems, String tEnclosure, String warehousebillsfeesCr,
  827. String warehousebillsfeesDr, LoginUser loginUser, String billsType) {
  828. Map<String, Object> map = new HashMap<>();
  829. if (StringUtils.isNull(warehouseBills) || "[]".equals(warehouseBills)) {
  830. return AjaxResult.error("未找到主表信息");
  831. }
  832. if (StringUtils.isNull(warehousebillsitems) || "[]".equals(warehousebillsitems)) {
  833. return AjaxResult.error("未找到入账信息");
  834. }
  835. TWarehouseBills tWarehouseBills = JSONArray.parseObject(warehouseBills, TWarehouseBills.class);
  836. tWarehouseBills.setfItemsStatus(4L);
  837. tWarehouseBills.setfBilltype(billsType);
  838. tWarehouseBills.setUpdateBy(loginUser.getUser().getUserName());
  839. tWarehouseBills.setUpdateTime(new Date());
  840. tWarehouseBillsMapper.updateTWarehousebills(tWarehouseBills);
  841. tEnclosureMapper.deleteByFPid(tWarehouseBills.getfId());
  842. tWarehousebillsfeesMapper.deleteByFPid(tWarehouseBills.getfId());
  843. boolean businessStatus = "场地直装".equals(tWarehouseBills.getfBusinessType());
  844. JSONArray warehouseJSON = JSONArray.parseArray(warehousebillsitems);
  845. List<TWarehousebillsitems> warehousebillsitemsList = JSONObject.parseArray(warehouseJSON.toJSONString(), TWarehousebillsitems.class);
  846. for (TWarehousebillsitems item : warehousebillsitemsList) {
  847. if (!businessStatus) {
  848. // 查询库容量 是否可入库
  849. int m = calculation(tWarehouseBills.getfWarehouseid(), item.getfGrossweight());
  850. if (m == 0) {
  851. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  852. return AjaxResult.error("更新库存总账失败-->入库毛重大于库容");
  853. }
  854. item.setfBillingway(tWarehouseBills.getfBillingway());
  855. item.setfChargedate(tWarehouseBills.getfChargedate());
  856. TWhgenleg tWhgenle = queryTWhgenleg(tWarehouseBills, item);
  857. if (StringUtils.isNotNull(tWhgenle)) {
  858. int i = updateTWhgenlegData(item, tWhgenle.getfId(), billsType);
  859. if (i <= 0) {
  860. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  861. return AjaxResult.error("更新库存总账失败");
  862. }
  863. } else {
  864. if (instalTWhgenleg(tWarehouseBills, item, loginUser.getUser()) <= 0) {
  865. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  866. return AjaxResult.error("新增库存总账失败");
  867. }
  868. }
  869. item.setfIsInventory(0L);
  870. } else {
  871. item.setfIsInventory(1L);
  872. }
  873. int num = 0;
  874. if (StringUtils.isNotNull(item.getfId())) {
  875. item.setfBillstatus(40L);
  876. item.setUpdateBy(loginUser.getUser().getUserName());
  877. item.setUpdateTime(new Date());
  878. num = tWarehousebillsitemsMapper.updateTWarehousebillsitems(item);
  879. // 添加状态log
  880. insertTWarehousebillsLog(item, 40L, loginUser);
  881. }
  882. if (num <= 0) {
  883. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  884. return AjaxResult.error("新增库存明细失败");
  885. }
  886. }
  887. // 附件添加
  888. if (StringUtils.isNotEmpty(tEnclosure) && !"[]".equals(tEnclosure)) {
  889. JSONArray jsonDrArray = JSONArray.parseArray(tEnclosure);
  890. List<TEnclosure> tEnclosureList = JSONObject.parseArray(jsonDrArray.toJSONString(), TEnclosure.class);
  891. for (TEnclosure enclosure : tEnclosureList) {
  892. enclosure.setfPid(tWarehouseBills.getfId());
  893. enclosure.setCreateBy(loginUser.getUser().getUserName());
  894. enclosure.setCreateTime(new Date());
  895. tEnclosureMapper.insertTEnclosure(enclosure);
  896. }
  897. }
  898. // 收款明细添加
  899. if (StringUtils.isNotEmpty(warehousebillsfeesDr) && !"[]".equals(warehousebillsfeesDr)) {
  900. JSONArray jsonDrArray = JSONArray.parseArray(warehousebillsfeesDr);
  901. List<TWarehousebillsfees> warehousebillsfeesDrList = JSONObject.parseArray(jsonDrArray.toJSONString(), TWarehousebillsfees.class);
  902. for (TWarehousebillsfees wbDr : warehousebillsfeesDrList) {
  903. wbDr.setfPid(tWarehouseBills.getfId());
  904. wbDr.setfDc("D");
  905. wbDr.setCreateBy(loginUser.getUser().getUserName());
  906. wbDr.setCreateTime(new Date());
  907. if (tWarehouseBills.getfBsdate() != null && !tWarehouseBills.getfBsdate().equals("")) {
  908. wbDr.setfBsdate(tWarehouseBills.getfBsdate());
  909. }
  910. tWarehousebillsfeesMapper.insertTWarehousebillsfees(wbDr);
  911. }
  912. }
  913. // 付款明细添加
  914. if (StringUtils.isNotNull(warehousebillsfeesCr) && !"[]".equals(warehousebillsfeesCr)) {
  915. JSONArray jsonCrArray = JSONArray.parseArray(warehousebillsfeesCr);
  916. List<TWarehousebillsfees> warehousebillsfeesCrList = JSONObject.parseArray(jsonCrArray.toJSONString(), TWarehousebillsfees.class);
  917. for (TWarehousebillsfees wbCr : warehousebillsfeesCrList) {
  918. wbCr.setfPid(tWarehouseBills.getfId());
  919. wbCr.setfDc("C");
  920. wbCr.setCreateBy(loginUser.getUser().getUserName());
  921. wbCr.setCreateTime(new Date());
  922. if (tWarehouseBills.getfBsdate() != null && !tWarehouseBills.getfBsdate().equals("")) {
  923. wbCr.setfBsdate(tWarehouseBills.getfBsdate());
  924. }
  925. tWarehousebillsfeesMapper.insertTWarehousebillsfees(wbCr);
  926. }
  927. }
  928. map.put("warehousebillsitems", warehousebillsitemsList);
  929. return AjaxResult.success("成功", map);
  930. }
  931. /**
  932. * 出库、调拨、货转 确认
  933. *
  934. * @param warehouseBills
  935. * @param warehousebillsitems
  936. * @param loginUser
  937. * @param billsType
  938. * @return
  939. */
  940. @Override
  941. @Transactional
  942. public AjaxResult updateCredit(String warehouseBills, String warehousebillsitems, String tEnclosure, String warehousebillsfeesCr,
  943. String warehousebillsfeesDr, LoginUser loginUser, String billsType) {
  944. Long fPid = null;
  945. Map<String, Object> map = new HashMap<>();
  946. TWarehouseBills tWarehouseBills = JSONArray.parseObject(warehouseBills, TWarehouseBills.class);
  947. tWarehouseBills.setfItemsStatus(4L);
  948. if (StringUtils.isNotNull(tWarehouseBills.getfId())) {
  949. tWarehouseBills.setUpdateBy(loginUser.getUser().getUserName());
  950. tWarehouseBills.setUpdateTime(new Date());
  951. tWarehouseBillsMapper.updateTWarehousebills(tWarehouseBills);
  952. fPid = tWarehouseBills.getfId();
  953. } else {
  954. tWarehouseBills.setfBsdeptid(loginUser.getUser().getDeptId());
  955. tWarehouseBills.setCreateBy(loginUser.getUser().getUserName());
  956. tWarehouseBills.setCreateTime(new Date());
  957. String billNo = billnoSerialServiceImpl.getBillNo(billsType, tWarehouseBills.getfBsdate());
  958. tWarehouseBills.setfBillno(billNo);
  959. tWarehouseBillsMapper.insertTWarehousebills(tWarehouseBills);
  960. fPid = tWarehouseBills.getfId();
  961. }
  962. tEnclosureMapper.deleteByFPid(fPid);
  963. tWarehousebillsfeesMapper.deleteByFPid(fPid);
  964. JSONArray warehouseJSON = JSONArray.parseArray(warehousebillsitems);
  965. List<TWarehousebillsitems> warehousebillsitemsList = JSONObject.parseArray(warehouseJSON.toJSONString(), TWarehousebillsitems.class);
  966. int i = 1;
  967. List<TFees> feesList = new ArrayList<>();
  968. List<TWarehousebillsfees> warehousebillsfees = new ArrayList<>();
  969. for (TWarehousebillsitems wbItem : warehousebillsitemsList) {
  970. long warehouselocId = 0L;
  971. long transferWarehouselocid = 0L;
  972. if ("CKDB".equals(billsType)) {
  973. warehouselocId = wbItem.getfWarehouselocid();
  974. transferWarehouselocid = wbItem.getfTransferWarehouselocid();
  975. // wbItem.setfWarehouselocid(transferWarehouselocid);
  976. }
  977. // 查询总账是否存在
  978. TWhgenleg tWhgenle = queryTWhgenleg(tWarehouseBills, wbItem);
  979. // 入库数特殊不判断入账
  980. if ("SJCK".equals(billsType)) { // 出库 查询
  981. if (StringUtils.isNull(tWhgenle)) { // 为空 提示没有库存
  982. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  983. return AjaxResult.error("库存明细第" + i + "行库存为空");
  984. } else { // 非空修改库存总账
  985. // 库存 < 出库件数
  986. if (tWhgenle.getfQtyblc() < wbItem.getfQty()) {
  987. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  988. return AjaxResult.error("库存明细第" + i + "行库存不足");
  989. }
  990. // 更新库存总账
  991. updateTWhgenlegData(wbItem, tWhgenle.getfId(), billsType);
  992. if (StringUtils.isNull(tWarehouseBills.getfBsdate()) || StringUtils.isNull(wbItem.getfChargedate())) {
  993. return AjaxResult.error("库存明细第" + i + "行请检查日期,操作终止");
  994. }
  995. long dateDay = DateUtils.getDateDay(tWarehouseBills.getfBsdate(), wbItem.getfChargedate());
  996. if (StringUtils.isNull(tWarehouseBills.getfCorpid())) {
  997. return AjaxResult.error("库存明细第" + i + "行请检查客户信息,操作终止");
  998. }
  999. /*long fCorpid = tWarehouseBills.getfCorpid();
  1000. TGoods tGoods = tGoodsMapper.selectTGoodsById(wbItem.getfGoodsid());
  1001. long fGoodsid = tGoods.getfTypeid();
  1002. long fBillingway = wbItem.getfBillingway();
  1003. long fQty = wbItem.getfQty();
  1004. // 计算仓储费明细
  1005. Map<String, Object> objectMap = tWarehouseAgreementService.getCarryingCost(fCorpid, fGoodsid, dateDay, fBillingway, fQty , 0L);
  1006. if (StringUtils.isNull(objectMap)) {
  1007. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  1008. return AjaxResult.error("库存明细第" + i + "行没有维护出库明细的仓储协议,操作终止");
  1009. }
  1010. Long feeId = (Long) objectMap.get("feeId");
  1011. BigDecimal amt = (BigDecimal) objectMap.get("amt");
  1012. TFees tFees = tFeesMapper.selectTFeesById(feeId);
  1013. if (StringUtils.isNotNull(tFees)) {
  1014. feesList.add(tFees);
  1015. }
  1016. TWarehousebillsfees fees = new TWarehousebillsfees();
  1017. fees.setfPid(fPid);
  1018. fees.setfFeeid(feeId);
  1019. fees.setfCorpid(tWarehouseBills.getfCorpid());
  1020. fees.setfFeeUnitid(fBillingway);
  1021. fees.setfQty(new BigDecimal(1));
  1022. fees.setfUnitprice(amt);
  1023. fees.setfAmount(amt);
  1024. fees.setfExrate(new BigDecimal(1));
  1025. fees.setfCurrency("RMB");
  1026. fees.setRemark(dateDay + "天" + tFees.getfName());
  1027. warehousebillsfees.add(fees);*/
  1028. }
  1029. wbItem.setfBillstatus(40L);
  1030. } else if ("CKDB".equals(billsType)) { // 调拨查询
  1031. if (StringUtils.isNull(tWhgenle)) { // 为空 提示没有库存
  1032. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  1033. return AjaxResult.error("库存明细第" + i + "行库存为空");
  1034. } else { // 非空修改库存总账
  1035. if (tWhgenle.getfQtyblc() < wbItem.getfQty()) { // 1、 库存 < 调拨件数 提示库存不足
  1036. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  1037. return AjaxResult.error("库存明细第" + i + "行库存不足");
  1038. } else { // 2、 库存足够 先 进行出库操作
  1039. wbItem.setfWarehouselocid(warehouselocId);
  1040. updateTWhgenlegData(wbItem, tWhgenle.getfId(), "SJCK");
  1041. }
  1042. // 3、 进行入库操作 查询是否存在库存
  1043. wbItem.setfWarehouselocid(transferWarehouselocid); // 新库区
  1044. TWhgenleg tWhgenle1 = queryTWhgenleg(tWarehouseBills, wbItem);
  1045. if (StringUtils.isNull(tWhgenle1)) { // 5、 不存在 进行新增库存
  1046. instalTWhgenleg(tWarehouseBills, wbItem, loginUser.getUser());
  1047. } else { // 4、 存在 进行跟新库存
  1048. updateTWhgenlegData(wbItem, tWhgenle1.getfId(), "SJRK");
  1049. }
  1050. }
  1051. wbItem.setfWarehouselocid(warehouselocId);
  1052. wbItem.setfBillstatus(40L);
  1053. } else if ("HQZY".equals(billsType)) { // 货转
  1054. wbItem.setfBillstatus(6L);
  1055. wbItem.setfChargedate(tWarehouseBills.getfChargedate());
  1056. wbItem.setfBillingway(tWarehouseBills.getfBillingway());
  1057. if (StringUtils.isNull(tWhgenle)) { // 为空 提示没有库存
  1058. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  1059. return AjaxResult.error("库存明细第" + i + "行库存为空");
  1060. } else { // 非空修改库存总账
  1061. if (tWhgenle.getfQtyblc() < wbItem.getfQty()) { // 1、 库存 < 调拨件数 提示库存不足
  1062. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  1063. return AjaxResult.error("库存明细第" + i + "行库存不足");
  1064. } else { // 2、 库存足够 先 进行出库操作
  1065. updateTWhgenlegData(wbItem, tWhgenle.getfId(), "SJCK");
  1066. }
  1067. long corpId = tWarehouseBills.getfCorpid();
  1068. tWarehouseBills.setfCorpid(tWarehouseBills.getfTocorpid());
  1069. // 3、 进行入库操作 查询是否存在库存
  1070. TWhgenleg tWhgenle1 = queryTWhgenleg(tWarehouseBills, wbItem);
  1071. if (StringUtils.isNull(tWhgenle1)) { // 5、 不存在 进行新增库存
  1072. instalTWhgenleg(tWarehouseBills, wbItem, loginUser.getUser());
  1073. } else { // 4、 存在 进行跟新库存
  1074. updateTWhgenlegData(wbItem, tWhgenle1.getfId(), "SJRK");
  1075. }
  1076. tWarehouseBills.setfCorpid(corpId);
  1077. }
  1078. }
  1079. i++;
  1080. int num = 0;
  1081. wbItem.setfPid(fPid);
  1082. wbItem.setfBilltype(billsType);
  1083. wbItem.setfBillno(tWarehouseBills.getfBillno());
  1084. wbItem.setfBsdate(tWarehouseBills.getfBsdate());
  1085. if (StringUtils.isNotNull(wbItem.getfId())) {
  1086. wbItem.setUpdateBy(loginUser.getUser().getUserName());
  1087. wbItem.setUpdateTime(new Date());
  1088. num = tWarehousebillsitemsMapper.updateTWarehousebillsitems(wbItem);
  1089. if ("SJCK".equals(billsType)) {
  1090. // 添加状态log
  1091. insertTWarehousebillsLog(wbItem, 40L, loginUser);
  1092. }
  1093. } else {
  1094. wbItem.setCreateTime(new Date());
  1095. wbItem.setCreateBy(loginUser.getUsername());
  1096. num = tWarehousebillsitemsMapper.insertTWarehousebillsitems(wbItem);
  1097. }
  1098. if (num <= 0) {
  1099. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  1100. return AjaxResult.error("库存明细更新失败");
  1101. }
  1102. }
  1103. // 附件添加
  1104. if (StringUtils.isNotEmpty(tEnclosure) && !"[]".equals(tEnclosure)) {
  1105. JSONArray jsonDrArray = JSONArray.parseArray(tEnclosure);
  1106. List<TEnclosure> tEnclosureList = JSONObject.parseArray(jsonDrArray.toJSONString(), TEnclosure.class);
  1107. for (TEnclosure enclosure : tEnclosureList) {
  1108. enclosure.setfPid(tWarehouseBills.getfId());
  1109. enclosure.setCreateBy(loginUser.getUser().getUserName());
  1110. enclosure.setCreateTime(new Date());
  1111. tEnclosureMapper.insertTEnclosure(enclosure);
  1112. }
  1113. }
  1114. // 收款明细添加
  1115. if (StringUtils.isNotEmpty(warehousebillsfeesDr) && !"[]".equals(warehousebillsfeesDr)) {
  1116. JSONArray jsonDrArray = JSONArray.parseArray(warehousebillsfeesDr);
  1117. List<TWarehousebillsfees> warehousebillsfeesDrList = JSONObject.parseArray(jsonDrArray.toJSONString(), TWarehousebillsfees.class);
  1118. for (TWarehousebillsfees wbDr : warehousebillsfeesDrList) {
  1119. wbDr.setfPid(tWarehouseBills.getfId());
  1120. wbDr.setfDc("D");
  1121. wbDr.setCreateBy(loginUser.getUser().getUserName());
  1122. wbDr.setCreateTime(new Date());
  1123. tWarehousebillsfeesMapper.insertTWarehousebillsfees(wbDr);
  1124. }
  1125. }
  1126. // 付款明细添加
  1127. if (StringUtils.isNotNull(warehousebillsfeesCr) && !"[]".equals(warehousebillsfeesCr)) {
  1128. JSONArray jsonCrArray = JSONArray.parseArray(warehousebillsfeesCr);
  1129. List<TWarehousebillsfees> warehousebillsfeesCrList = JSONObject.parseArray(jsonCrArray.toJSONString(), TWarehousebillsfees.class);
  1130. for (TWarehousebillsfees wbCr : warehousebillsfeesCrList) {
  1131. wbCr.setfPid(tWarehouseBills.getfId());
  1132. wbCr.setfDc("C");
  1133. wbCr.setCreateBy(loginUser.getUser().getUserName());
  1134. wbCr.setCreateTime(new Date());
  1135. tWarehousebillsfeesMapper.insertTWarehousebillsfees(wbCr);
  1136. }
  1137. }
  1138. map.put("fPid", fPid);
  1139. map.put("warehouse", tWarehouseBills);
  1140. map.put("warehouseItem", warehousebillsitemsList);
  1141. map.put("fees", feesList);
  1142. map.put("warehousebillsfees", warehousebillsfees);
  1143. // 添加成功 主键返回 前台
  1144. return AjaxResult.success("成功", map);
  1145. }
  1146. /**
  1147. * 打印作业单
  1148. *
  1149. * @param warehouseBills
  1150. * @param warehousebillsitems
  1151. * @param tEnclosure
  1152. * @param tWarehousebillsfeesCr
  1153. * @param tWarehousebillsfeesDr
  1154. * @param loginUser
  1155. * @param status
  1156. * @param billtystatus
  1157. * @return
  1158. */
  1159. @Override
  1160. public AjaxResult waitWarehousing(String warehouseBills, String warehousebillsitems,
  1161. String tEnclosure, String tWarehousebillsfeesCr, String tWarehousebillsfeesDr,
  1162. LoginUser loginUser, Long status, String billtystatus) {
  1163. Map<String, Object> map = new HashMap<>();
  1164. if (StringUtils.isNull(warehouseBills) || "[]".equals(warehouseBills)) {
  1165. return AjaxResult.error("未找到主表信息");
  1166. }
  1167. if (StringUtils.isNull(warehousebillsitems) || "[]".equals(warehousebillsitems)) {
  1168. return AjaxResult.error("未找到入账信息");
  1169. }
  1170. TWarehouseBills tWarehouseBills = JSONArray.parseObject(warehouseBills, TWarehouseBills.class);
  1171. if(status==20){
  1172. tWarehouseBills.setfItemsStatus(2L);
  1173. }else if(status==30){
  1174. tWarehouseBills.setfItemsStatus(3L);
  1175. }
  1176. if (StringUtils.isNotNull(tWarehouseBills.getfId())) {
  1177. tWarehouseBills.setUpdateBy(loginUser.getUser().getUserName());
  1178. tWarehouseBills.setUpdateTime(new Date());
  1179. tWarehouseBillsMapper.updateTWarehousebills(tWarehouseBills);
  1180. }
  1181. tEnclosureMapper.deleteByFPid(tWarehouseBills.getfId());
  1182. tWarehousebillsfeesMapper.deleteByFPid(tWarehouseBills.getfId());
  1183. JSONArray warehouseJSON = JSONArray.parseArray(warehousebillsitems);
  1184. List<TWarehousebillsitems> warehousebillsitemsList = JSONObject.parseArray(warehouseJSON.toJSONString(), TWarehousebillsitems.class);
  1185. for (TWarehousebillsitems item : warehousebillsitemsList) {
  1186. // 生成流水号
  1187. Date time = new Date();
  1188. String serialNumber;
  1189. if (item.getfBillstatus() < 30L) {
  1190. if ("RK".equals(billtystatus)) { // 生成 入库 流水号
  1191. serialNumber = billnoSerialServiceImpl.getSerialNumber("RK", time);
  1192. item.setfSerialNumber(serialNumber);
  1193. } else if ("CK".equals(billtystatus)) { //生成 出库 流水号
  1194. serialNumber = billnoSerialServiceImpl.getSerialNumber("CK", time);
  1195. item.setfSerialNumber(serialNumber);
  1196. } else if ("DB".equals(billtystatus)) { //生成 出库 流水号
  1197. serialNumber = billnoSerialServiceImpl.getSerialNumber("DB", time);
  1198. item.setfSerialNumber(serialNumber);
  1199. }
  1200. item.setfBillstatus(status);
  1201. item.setUpdateTime(new Date());
  1202. item.setUpdateBy(loginUser.getUser().getUserName());
  1203. int num = tWarehousebillsitemsMapper.updateTWarehousebillsitems(item);
  1204. // 添加状态log
  1205. insertTWarehousebillsLog(item, status, loginUser);
  1206. if (num <= 0) {
  1207. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  1208. return AjaxResult.error("更新库存明细失败");
  1209. }
  1210. }
  1211. }
  1212. // 附件添加
  1213. if (StringUtils.isNotEmpty(tEnclosure) && !"[]".equals(tEnclosure)) {
  1214. JSONArray jsonDrArray = JSONArray.parseArray(tEnclosure);
  1215. List<TEnclosure> tEnclosureList = JSONObject.parseArray(jsonDrArray.toJSONString(), TEnclosure.class);
  1216. for (TEnclosure enclosure : tEnclosureList) {
  1217. enclosure.setfPid(tWarehouseBills.getfId());
  1218. enclosure.setCreateBy(loginUser.getUser().getUserName());
  1219. enclosure.setCreateTime(new Date());
  1220. tEnclosureMapper.insertTEnclosure(enclosure);
  1221. }
  1222. }
  1223. // 收款明细添加
  1224. if (StringUtils.isNotEmpty(tWarehousebillsfeesDr) && !"[]".equals(tWarehousebillsfeesDr)) {
  1225. JSONArray jsonDrArray = JSONArray.parseArray(tWarehousebillsfeesDr);
  1226. List<TWarehousebillsfees> warehousebillsfeesDrList = JSONObject.parseArray(jsonDrArray.toJSONString(), TWarehousebillsfees.class);
  1227. for (TWarehousebillsfees wbDr : warehousebillsfeesDrList) {
  1228. wbDr.setfPid(tWarehouseBills.getfId());
  1229. wbDr.setfDc("D");
  1230. wbDr.setCreateBy(loginUser.getUser().getUserName());
  1231. wbDr.setCreateTime(new Date());
  1232. if (tWarehouseBills.getfBsdate() != null && !tWarehouseBills.getfBsdate().equals("")) {
  1233. wbDr.setfBsdate(tWarehouseBills.getfBsdate());
  1234. }
  1235. tWarehousebillsfeesMapper.insertTWarehousebillsfees(wbDr);
  1236. }
  1237. }
  1238. // 付款明细添加
  1239. if (StringUtils.isNotNull(tWarehousebillsfeesCr) && !"[]".equals(tWarehousebillsfeesCr)) {
  1240. JSONArray jsonCrArray = JSONArray.parseArray(tWarehousebillsfeesCr);
  1241. List<TWarehousebillsfees> warehousebillsfeesCrList = JSONObject.parseArray(jsonCrArray.toJSONString(), TWarehousebillsfees.class);
  1242. for (TWarehousebillsfees wbCr : warehousebillsfeesCrList) {
  1243. wbCr.setfPid(tWarehouseBills.getfId());
  1244. wbCr.setfDc("C");
  1245. wbCr.setCreateBy(loginUser.getUser().getUserName());
  1246. wbCr.setCreateTime(new Date());
  1247. if (tWarehouseBills.getfBsdate() != null && !tWarehouseBills.getfBsdate().equals("")) {
  1248. wbCr.setfBsdate(tWarehouseBills.getfBsdate());
  1249. }
  1250. tWarehousebillsfeesMapper.insertTWarehousebillsfees(wbCr);
  1251. }
  1252. }
  1253. // 添加成功 返回 前台
  1254. TWarehousebillsitems tWarehousebillsitems = new TWarehousebillsitems();
  1255. tWarehousebillsitems.setfPid(tWarehouseBills.getfId());
  1256. List<TWarehousebillsitems> mapList = tWarehousebillsitemsMapper.selectTWarehousebillsitemsList(tWarehousebillsitems);
  1257. map.put("warehousebillsitems", mapList);
  1258. return AjaxResult.success("成功", map);
  1259. }
  1260. /**
  1261. * 生成计算仓储费信息
  1262. *
  1263. * @param warehouseBills
  1264. * @param mapItem
  1265. * @param loginUser
  1266. * @return
  1267. */
  1268. public Map<String, Object> getWarehouseItems(TWarehouseBills warehouseBills, List<Map<String, Object>> mapItem, LoginUser loginUser) {
  1269. Map<String, Object> map = new HashMap<>();
  1270. long feeId = 0L;
  1271. BigDecimal sumAmt = new BigDecimal(0);
  1272. List<TWarehousebillsfees> itemsList = new ArrayList<>();
  1273. List<SysDictData> taxRate = sysDictDataMapper.selectDictDataByType("tax_rate");
  1274. for (Map<String, Object> item : mapItem) {
  1275. if (StringUtils.isNull(item.get("fBillingway"))) {
  1276. map.put("error", "单号:" + item.get("fBillno") + ",业务日期:" + item.get("fBsdate") + "未找到库存总账的计费单位,请确认");
  1277. return map;
  1278. }
  1279. Date fBsdate = (Date) item.get("fBsdate");
  1280. long fCorpid = warehouseBills.getfCorpid();
  1281. String fBilltype = (String) item.get("fBilltype");
  1282. long fGoodsid = Long.parseLong((String) item.get("fTypeid"));
  1283. long fId = Long.valueOf(String.valueOf(item.get("fId"))).longValue();
  1284. // 累计计费天数
  1285. long accumulatedDays = DateUtils.getDateDay((Date) item.get("fChargedate"), (Date) item.get("fOriginalbilldate"));
  1286. // 库存天数
  1287. long fInventoryDays = 0L;
  1288. // 要计费天数
  1289. long fBillingDays = DateUtils.getDateDay(warehouseBills.getfBillingDeadline(), (Date) item.get("fOriginalbilldate"));
  1290. if ("SJCK".equals(fBilltype)) {
  1291. fInventoryDays = DateUtils.getDateDay(fBsdate, (Date) item.get("fOriginalbilldate"));
  1292. fBillingDays = fInventoryDays;
  1293. } else if ("HQZY".equals(fBilltype)) {
  1294. fInventoryDays = DateUtils.getDateDay(warehouseBills.getfBillingDeadline(), fBsdate);
  1295. } else {
  1296. fBillingDays = DateUtils.getDateDay(warehouseBills.getfBillingDeadline(), (Date) item.get("fChargedate"));
  1297. fInventoryDays = DateUtils.getDateDay(warehouseBills.getfBillingDeadline(), (Date) item.get("fOriginalbilldate"));
  1298. }
  1299. /*if ("KCZZ".equals(fBilltype)) {
  1300. } else {
  1301. fInventoryDays = Long.valueOf(String.valueOf(item.get("fBillingDays")));
  1302. }*/
  1303. Long dictLabel = Long.valueOf(String.valueOf(item.get("fBillingway")));
  1304. BigDecimal fQty = acquiredQuantity(item, dictLabel);
  1305. if (fQty.equals(BigDecimal.ZERO)) {
  1306. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  1307. return AjaxResult.error("单号:" + item.get("fBillno") + ",业务日期:" + item.get("fBsdate") + "未找到计费单位,请确认");
  1308. }
  1309. // 计算仓储费明细
  1310. Map<String, Object> objectMap = tWarehouseAgreementService.getCarryingCost(fCorpid, fGoodsid, fBillingDays, dictLabel, fQty, accumulatedDays);
  1311. if (StringUtils.isNull(objectMap)) {
  1312. map.put("error", "单号:" + item.get("fBillno") + ",业务日期:" + item.get("fBsdate") + "未找到仓储费协议,请确认");
  1313. return map;
  1314. }
  1315. String mblno = "";
  1316. if (StringUtils.isNotNull(item.get("fMblno"))) {
  1317. mblno = item.get("fMblno").toString();
  1318. }
  1319. String remark = objectMap.get("remark").toString();
  1320. feeId = Long.valueOf(String.valueOf(objectMap.get("feeId"))).longValue();
  1321. BigDecimal amt = (BigDecimal) objectMap.get("amt");
  1322. map.put("feeId", feeId);
  1323. map.put("itemFeeId", objectMap.get("feeId"));
  1324. sumAmt = sumAmt.add(amt).setScale(2, BigDecimal.ROUND_HALF_UP);
  1325. TWarehousebillsfees fees = new TWarehousebillsfees();
  1326. fees.setfFeeid(feeId);
  1327. fees.setfDc("D");
  1328. fees.setfAmt(amt);
  1329. fees.setSrcId(fId);
  1330. fees.setfMblno(mblno);
  1331. fees.setRemark(remark);
  1332. fees.setfFeeunitid(2L);
  1333. fees.setfAmount(sumAmt);
  1334. fees.setfBillstatus(2L);
  1335. fees.setfCurrency("RMB");
  1336. fees.setfBsdate(fBsdate);
  1337. fees.setfBillingQty(fQty);
  1338. fees.setfUnitprice(sumAmt);
  1339. fees.setfBilltype(fBilltype);
  1340. fees.setfBillingDays(fBillingDays);
  1341. fees.setCreateTime(new Date());
  1342. fees.setfQty(new BigDecimal(1));
  1343. fees.setfPid(warehouseBills.getfId());
  1344. fees.setfInventoryDays(fInventoryDays);
  1345. fees.setfExrate(new BigDecimal(1));
  1346. fees.setfCorpid(warehouseBills.getfCorpid());
  1347. fees.setfMarks(item.get("fMarks").toString());
  1348. fees.setSrcBillNo((String) item.get("fBillno"));
  1349. fees.setfChargedate((Date) item.get("fChargedate"));
  1350. fees.setCreateBy(loginUser.getUser().getUserName());
  1351. fees.setfProductName(item.get("fGoodsids").toString());
  1352. if ("SJCK".equals(fBilltype)) {
  1353. fees.setfBillingDeadline(fBsdate);
  1354. } else {
  1355. fees.setfBillingDeadline(warehouseBills.getfBillingDeadline());
  1356. }
  1357. fees.setfTaxrate(new BigDecimal(taxRate.get(0).getDictValue()));
  1358. fees.setfOriginalbilldate((Date) item.get("fOriginalbilldate"));
  1359. fees.setfBillingway(Long.valueOf(String.valueOf(item.get("fBillingway"))).longValue());
  1360. tWarehousebillsfeesMapper.insertTWarehousebillsfees(fees);
  1361. itemsList.add(fees);
  1362. }
  1363. map.put("sumAmt", sumAmt);
  1364. map.put("itemsList", itemsList);
  1365. return map;
  1366. }
  1367. /**
  1368. * 新增库存费计算
  1369. *
  1370. * @param tWarehouseBills 主表的查询条件
  1371. * @param loginUser 登录用户
  1372. * @param billsType 状态
  1373. * @return 结果
  1374. */
  1375. @Override
  1376. @Transactional
  1377. public AjaxResult calculateStorageFees(TWarehouseBills tWarehouseBills, LoginUser loginUser, String billsType) {
  1378. if (StringUtils.isNull(tWarehouseBills.getfCorpid())) {
  1379. return AjaxResult.error("请选择客户信息");
  1380. }
  1381. long fPid = 0L;
  1382. if (StringUtils.isNull(tWarehouseBills.getfId())) {
  1383. // 生成流水号
  1384. Date time = new Date();
  1385. String billNo = billnoSerialServiceImpl.getSerialNumber("JSCCF", time);
  1386. tWarehouseBills.setfBillno(billNo);
  1387. if (StringUtils.isNull(tWarehouseBills.getfBillstatus())) {
  1388. tWarehouseBills.setfBillstatus(2L);
  1389. }
  1390. tWarehouseBills.setfBilltype(billsType);
  1391. tWarehouseBills.setfBsdeptid(loginUser.getUser().getDeptId());
  1392. tWarehouseBills.setCreateBy(loginUser.getUser().getUserName());
  1393. tWarehouseBills.setCreateTime(new Date());
  1394. tWarehouseBillsMapper.insertTWarehousebills(tWarehouseBills);
  1395. fPid = tWarehouseBills.getfId();
  1396. } else {
  1397. tWarehousebillsfeesMapper.deleteByFPid(tWarehouseBills.getfId());
  1398. tWarehousebillsitemsMapper.deleteByFPid(tWarehouseBills.getfId());
  1399. tWarehouseBills.setUpdateBy(loginUser.getUser().getUserName());
  1400. tWarehouseBills.setUpdateTime(new Date());
  1401. tWarehouseBillsMapper.updateTWarehousebills(tWarehouseBills);
  1402. fPid = tWarehouseBills.getfId();
  1403. }
  1404. // 计划物资明细
  1405. List<TWarehousebillsfees> itemsList = new ArrayList<>();
  1406. BigDecimal bigDecimal = new BigDecimal(0);
  1407. Map<String, Object> map = new HashMap<>();
  1408. // 库存总账id
  1409. long whgenlegFeeId = 0;
  1410. // 计费单位
  1411. long feeUnitid = 1;
  1412. // 查询 出库 货转的库存明细
  1413. List<Map<String, Object>> warehousebillsitemsList = tWarehousebillsitemsMapper.selectStorageFeeItemList(tWarehouseBills);
  1414. if (warehousebillsitemsList.size() != 0) {
  1415. Map<String, Object> mapItem = getWarehouseItems(tWarehouseBills, warehousebillsitemsList, loginUser);
  1416. if (mapItem.containsKey("error")) {
  1417. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  1418. return AjaxResult.error((String) mapItem.get("error"));
  1419. }
  1420. itemsList = (List<TWarehousebillsfees>) mapItem.get("itemsList");
  1421. }
  1422. List<Map<String, Object>> tWhgenlegs = tWhgenlegMapper.selectStorageFeeItemList(tWarehouseBills);
  1423. if (tWhgenlegs.size() != 0) {
  1424. Map<String, Object> mapItem = getWarehouseItems(tWarehouseBills, tWhgenlegs, loginUser);
  1425. if (mapItem.containsKey("error")) {
  1426. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  1427. return AjaxResult.error((String) mapItem.get("error"));
  1428. }
  1429. List<TWarehousebillsfees> itemList = (List<TWarehousebillsfees>) mapItem.get("itemsList");
  1430. if (itemList.size() != 0) {
  1431. for (TWarehousebillsfees ite : itemList) {
  1432. itemsList.add(ite);
  1433. }
  1434. }
  1435. }
  1436. TFees tFees = new TFees();
  1437. tFees.setfStatus("2");
  1438. tFees.setDelFlag("0");
  1439. List<TFees> feesList = tFeesMapper.selectTFeesList(tFees);
  1440. if (itemsList.size() <= 0) {
  1441. return AjaxResult.error("未找到合适的库存明细");
  1442. }
  1443. map.put("feesList", feesList);
  1444. map.put("warehouseBills", tWarehouseBills);
  1445. map.put("warehouseItemList", itemsList);
  1446. return AjaxResult.success(map);
  1447. }
  1448. /**
  1449. * 仓储费计算提交以及暂存
  1450. *
  1451. * @param warehouseBills
  1452. * @param warehouseItems
  1453. * @param warehouseFees
  1454. * @param loginUser
  1455. * @param billsType
  1456. * @return
  1457. */
  1458. @Override
  1459. @Transactional
  1460. public AjaxResult insertStorageFee(String warehouseBills, String warehouseItems, String warehouseFees, LoginUser loginUser, String billsType) {
  1461. TWarehouseBills tWarehousebills = JSONArray.parseObject(warehouseBills, TWarehouseBills.class);
  1462. long fPid = 0L;
  1463. boolean billstatus = tWarehousebills.getfBillstatus().equals(4L);
  1464. if (billstatus && (StringUtils.isNull(warehouseItems) || "[]".equals(warehouseItems))) {
  1465. return AjaxResult.error("未找到计费物资明细无法提交");
  1466. }
  1467. /*if (billstatus && (StringUtils.isNull(warehouseFees) || "[]".equals(warehouseFees))) {
  1468. return AjaxResult.error("未找到应收款明细无法提交");
  1469. }*/
  1470. if (StringUtils.isNotNull(tWarehousebills.getfId())) {
  1471. fPid = tWarehousebills.getfId();
  1472. tWarehousebills.setUpdateTime(new Date());
  1473. tWarehousebills.setUpdateBy(loginUser.getUser().getUserName());
  1474. tWarehouseBillsMapper.updateTWarehousebills(tWarehousebills);
  1475. tWarehousebillsfeesMapper.deleteByFPid(fPid);
  1476. tWarehousebillsitemsMapper.deleteByFPid(fPid);
  1477. } else {
  1478. // 生成流水号
  1479. Date time = new Date();
  1480. String billNo = billnoSerialServiceImpl.getSerialNumber("JSCCF", time);
  1481. tWarehousebills.setfBillno(billNo);
  1482. tWarehousebills.setfDeptid(loginUser.getUser().getDeptId());
  1483. tWarehousebills.setfBsdeptid(loginUser.getUser().getDeptId());
  1484. tWarehousebills.setCreateBy(loginUser.getUser().getUserName());
  1485. tWarehousebills.setCreateTime(new Date());
  1486. tWarehousebills.setfBilltype(billsType);
  1487. tWarehouseBillsMapper.insertTWarehousebills(tWarehousebills);
  1488. fPid = tWarehousebills.getfId();
  1489. }
  1490. JSONArray warehouseJSON = JSONArray.parseArray(warehouseItems);
  1491. List<TWarehousebillsfees> itemsList = JSONObject.parseArray(warehouseJSON.toJSONString(), TWarehousebillsfees.class);
  1492. for (TWarehousebillsfees item : itemsList) {
  1493. item.setfId(null);
  1494. item.setSrcBillNo(tWarehousebills.getfBillno());
  1495. item.setfPid(fPid);
  1496. item.setfBillstatus(tWarehousebills.getfBillstatus());
  1497. tWarehousebillsfeesMapper.insertTWarehousebillsfees(item);
  1498. }
  1499. if (StringUtils.isNotNull(warehouseFees) && !"[]".equals(warehouseFees)) {
  1500. JSONArray feesJSON = JSONArray.parseArray(warehouseFees);
  1501. List<TWarehousebillsfees> warehousebillsfeesList = JSONObject.parseArray(feesJSON.toJSONString(), TWarehousebillsfees.class);
  1502. for (TWarehousebillsfees fees : warehousebillsfeesList) {
  1503. fees.setfId(null);
  1504. fees.setfPid(fPid);
  1505. fees.setfDc("D");
  1506. fees.setfBilltype("JSCCF");
  1507. fees.setSrcBillNo(tWarehousebills.getfBillno());
  1508. fees.setfBillstatus(tWarehousebills.getfBillstatus());
  1509. tWarehousebillsfeesMapper.insertTWarehousebillsfees(fees);
  1510. }
  1511. }
  1512. if (billstatus) {
  1513. String key = "warehouse.storageFeeCalculation.ApprovalFlow";
  1514. SysConfig sysConfig = sysConfigMapper.checkConfigKeyUnique(key);
  1515. if (StringUtils.isNull(sysConfig)) {
  1516. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  1517. return AjaxResult.error("系统参数异常,未找到开启审批流参数");
  1518. }
  1519. if ("0".equals(sysConfig.getConfigValue())) {
  1520. AuditItems auditItems = new AuditItems();
  1521. auditItems.setLevelId(0L);
  1522. auditItems.setBillId(fPid);
  1523. auditItems.setActId(150L);
  1524. auditItems.setIffinalItem("F");
  1525. auditItems.setBillNo(tWarehousebills.getfBillno());
  1526. // 存储委托方(货权方)
  1527. auditItems.setRefno1(tWarehousebills.getfCorpid() + "");
  1528. // 存储业务类型(业务类型)
  1529. auditItems.setRefno2(tWarehousebills.getfBilltype());
  1530. // 存储提单号(提单号)
  1531. auditItems.setRefno3(tWarehousebills.getfMblno());
  1532. auditItems.setSendUserId(loginUser.getUser().getUserId());
  1533. auditItems.setSendName(loginUser.getUsername());
  1534. auditItems.setSendTime(new Date());
  1535. auditItems.setAuditUserId(loginUser.getUser().getUserId());
  1536. auditItems.setAuditItem(new Date());
  1537. auditItems.setAuditOpTime(new Date());
  1538. auditItems.setAuditMsg("提交");
  1539. auditItems.setAuditStatus("O");
  1540. AjaxResult approvalFlow = auditItemsService.createApprovalFlow(auditItems);
  1541. String code = approvalFlow.get("code").toString();
  1542. // Long code = Long.valueOf(String.valueOf(ajaxResult.get("code"))).longValue();
  1543. if ("500".equals(code)) {
  1544. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  1545. }
  1546. return approvalFlow;
  1547. } else {
  1548. AjaxResult ajaxResult = storageFeeFollow(fPid, 6L);
  1549. String code = ajaxResult.get("code").toString();
  1550. // Long code = Long.valueOf(String.valueOf(ajaxResult.get("code"))).longValue();
  1551. if ("500".equals(code)) {
  1552. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  1553. }
  1554. return ajaxResult;
  1555. }
  1556. }
  1557. return AjaxResult.success(tWarehousebills);
  1558. }
  1559. /**
  1560. * 根据id查询仓储费计算信息
  1561. *
  1562. * @param fId
  1563. * @return
  1564. */
  1565. @Override
  1566. public AjaxResult selectStorageFeeById(Long fId) {
  1567. TWarehouseBills tWarehouseBills = tWarehouseBillsMapper.selectTWarehousebillsById(fId);
  1568. if (StringUtils.isNull(tWarehouseBills)) {
  1569. return AjaxResult.error("未找到信息,请刷新页面重试");
  1570. }
  1571. Map<String, Object> map = new HashMap<>();
  1572. List<TWarehousebillsfees> feesList = new ArrayList<>();
  1573. List<TWarehousebillsfees> itemsList = new ArrayList<>();
  1574. TWarehousebillsfees warehousebillsfees = new TWarehousebillsfees();
  1575. warehousebillsfees.setfPid(fId);
  1576. List<TWarehousebillsfees> warehouseFeesList = tWarehousebillsfeesMapper.selectTWarehousebillsfeesList(warehousebillsfees);
  1577. for (TWarehousebillsfees fees : warehouseFeesList) {
  1578. if (StringUtils.isNotNull(fees.getSrcId())) {
  1579. itemsList.add(fees);
  1580. } else {
  1581. feesList.add(fees);
  1582. }
  1583. }
  1584. TGoods tGoods = new TGoods();
  1585. tGoods.setfStatus("0");
  1586. tGoods.setDelFlag("0");
  1587. List<TGoods> goods = tGoodsMapper.selectTGoodsList(tGoods);
  1588. TFees tFees = new TFees();
  1589. tFees.setfStatus("2");
  1590. tFees.setDelFlag("0");
  1591. List<TFees> feesLists = tFeesMapper.selectTFeesList(tFees);
  1592. // 查询联系人
  1593. List<SysUser> sysUserList = new ArrayList<>();
  1594. SysUser sysUser = sysUserMapper.selectUserByUserName(tWarehouseBills.getCreateBy());
  1595. if (StringUtils.isNotNull(sysUser)) {
  1596. sysUserList.add(sysUser);
  1597. }
  1598. TCorps corps = tCorpsMapper.selectTCorpsById(tWarehouseBills.getfCorpid());
  1599. map.put("corps", corps);
  1600. map.put("goodsList", goods);
  1601. map.put("feesList", feesLists);
  1602. map.put("sysUser", sysUserList);
  1603. map.put("warehouse", tWarehouseBills);
  1604. map.put("warehouseFeesList", feesList);
  1605. map.put("warehouseItemsList", itemsList);
  1606. return AjaxResult.success(map);
  1607. }
  1608. /**
  1609. * 根据不同计费单位获取不同 计算库存明细数量
  1610. *
  1611. * @param item 库存明细
  1612. * @param dictLabel 计费单位
  1613. * @return 结果
  1614. */
  1615. public BigDecimal acquiredQuantity(Map<String, Object> item, Long dictLabel) {
  1616. BigDecimal fQty = new BigDecimal(0);
  1617. // 件数
  1618. long boxNum = 1;
  1619. // 毛重
  1620. long grossWeight = 2;
  1621. // 净重
  1622. long netWeight = 3;
  1623. // 尺码
  1624. long size = 4;
  1625. // 统一
  1626. long fixed = 5;
  1627. if (dictLabel.equals(boxNum)) {
  1628. fQty = new BigDecimal(((Number) item.get("fQty")).doubleValue());
  1629. return fQty.setScale(2, BigDecimal.ROUND_HALF_UP);
  1630. } else if (dictLabel.equals(grossWeight)) {
  1631. fQty = new BigDecimal(((Number) item.get("fGrossweight")).doubleValue());
  1632. } else if (dictLabel.equals(netWeight)) {
  1633. fQty = new BigDecimal(((Number) item.get("fNetweight")).doubleValue());
  1634. } else if (dictLabel.equals(size)) {
  1635. fQty = new BigDecimal(((Number) item.get("fVolumn")).doubleValue());
  1636. } else if (dictLabel.equals(fixed)) {
  1637. fQty = new BigDecimal(1);
  1638. }
  1639. //return fQty.setScale(2, BigDecimal.ROUND_HALF_UP);
  1640. // 结果值除以1000 保留两位
  1641. BigDecimal divisor = new BigDecimal("1000");
  1642. BigDecimal result = fQty.divide(divisor, 2, BigDecimal.ROUND_HALF_UP);
  1643. return result;
  1644. }
  1645. // 入库 收费明细 校验
  1646. public Long check(BigDecimal number, BigDecimal unitPrice) {
  1647. BigDecimal result1 = number.multiply(unitPrice);
  1648. // 保留两位小数且四舍五入
  1649. result1 = result1.setScale(2, BigDecimal.ROUND_HALF_UP);
  1650. // 转换去掉小数点
  1651. String result = result1.toString().replace(".", "");
  1652. return Long.valueOf(result);
  1653. }
  1654. /**
  1655. * 修改详情主表
  1656. *
  1657. * @param tWarehousebills 详情主表
  1658. * @return 结果
  1659. */
  1660. @Override
  1661. public int updateTWarehousebills(TWarehouseBills tWarehousebills) {
  1662. tWarehousebills.setUpdateTime(DateUtils.getNowDate());
  1663. return tWarehouseBillsMapper.updateTWarehousebills(tWarehousebills);
  1664. }
  1665. /**
  1666. * 批量删除详情主表
  1667. *
  1668. * @param fIds 需要删除的详情主表ID
  1669. * @return 结果
  1670. */
  1671. @Override
  1672. public int deleteTWarehousebillsByIds(Long[] fIds) {
  1673. // 取出业务编号、 放入 billno_del
  1674. for (Long id : fIds) {
  1675. // 1、查询主表信息
  1676. TWarehouseBills tWarehousebills = tWarehouseBillsMapper.selectTWarehousebillsById(id);
  1677. // 2、业务编号、客存编号 放入 billno_del
  1678. BillnoDel billnoDel = new BillnoDel();
  1679. billnoDel.setBillType(tWarehousebills.getfBilltype());
  1680. billnoDel.setBillNo(tWarehousebills.getfBillno());
  1681. billnoDelMapper.insertBillnoDel(billnoDel);
  1682. }
  1683. return tWarehouseBillsMapper.deleteTWarehousebillsByIds(fIds);
  1684. }
  1685. @Override
  1686. public AjaxResult queryRemove(Long fId) {
  1687. // 查询主表明细
  1688. TWarehouseBills tWarehousebills = tWarehouseBillsMapper.selectTWarehousebillsById(fId);
  1689. // 查询仓库明细从表数据
  1690. TWarehousebillsitems tWarehousebillsitems = new TWarehousebillsitems();
  1691. tWarehousebillsitems.setfPid(tWarehousebills.getfId());
  1692. List<Map<String, Object>> mapList = tWarehousebillsitemsMapper.selectGoodsTransferitemsList(tWarehousebillsitems);
  1693. // 查询仓库费用明细表数据
  1694. TWarehousebillsfees tWarehousebillsfees = new TWarehousebillsfees();
  1695. tWarehousebillsfees.setfPid(tWarehousebills.getfId());
  1696. List<TWarehousebillsfees> warehousebillsfees = tWarehousebillsfeesMapper.selectTWarehousebillsfeesList(tWarehousebillsfees);
  1697. // 查询附件表数据
  1698. TEnclosure enclosure = new TEnclosure();
  1699. enclosure.setfPid(tWarehousebills.getfId());
  1700. List<TEnclosure> enclosures = tEnclosureMapper.selectTEnclosureList(enclosure);
  1701. if (StringUtils.isNull(tWarehousebills)) {
  1702. return AjaxResult.success("0");
  1703. } else if (StringUtils.isNotNull(tWarehousebills)
  1704. && StringUtils.isEmpty(warehousebillsfees)
  1705. && StringUtils.isEmpty(enclosures)
  1706. && StringUtils.isEmpty(mapList)) {
  1707. return AjaxResult.success("1");
  1708. } else {
  1709. return AjaxResult.success("2");
  1710. }
  1711. }
  1712. /**
  1713. * 删除详情主表信息
  1714. *
  1715. * @param fId 详情主表ID
  1716. * @return 结果
  1717. */
  1718. @Override
  1719. public int deleteTWarehousebillsById(Long fId) {
  1720. return tWarehouseBillsMapper.deleteTWarehousebillsById(fId);
  1721. }
  1722. @Override
  1723. public String getWarehouseInStockBillsNo(TWarehouseBills tWarehouseBills) {
  1724. return null;
  1725. }
  1726. @Override
  1727. public String getWarehouseOutStockBillsNo(TWarehouseBills tWarehouseBills) {
  1728. return null;
  1729. }
  1730. /**
  1731. * 撤销入库
  1732. *
  1733. * @param fId
  1734. * @param loginUser
  1735. * @param billsType
  1736. * @return
  1737. */
  1738. @Override
  1739. @Transactional
  1740. public AjaxResult revokeTWarehousebillsById(Long fId, LoginUser loginUser, String billsType) {
  1741. // 查询 仓库主表信息、库存明细信息
  1742. TWarehouseBills tWarehousebills = tWarehouseBillsMapper.selectTWarehousebillsById(fId);
  1743. // 修改主表信息
  1744. tWarehousebills.setUpdateBy(loginUser.getUser().getUserName());
  1745. tWarehousebills.setUpdateTime(new Date());
  1746. tWarehousebills.setfBillstatus(2L); //撤销状态
  1747. tWarehousebills.setfReviewDate(null);// 审核通过时间清空
  1748. tWarehouseBillsMapper.updateTWarehousebills(tWarehousebills);
  1749. tWarehousebillsfeesMapper.warehouseFeesFollowUpdate(tWarehousebills.getfId(), 2L, new Date());
  1750. if ("JSCCF".equals(tWarehousebills.getfBilltype())) {
  1751. List<TWarehousebillsfees> feesList = tWarehousebillsfeesMapper.selectWarehousebillsfeesByPId(fId);
  1752. for (TWarehousebillsfees wareItem : feesList) {
  1753. if (StringUtils.isNull(wareItem.getSrcId())) {
  1754. continue;
  1755. }
  1756. if ("KCZZ".equals(wareItem.getfBilltype())) {
  1757. TWhgenleg whgenleg = new TWhgenleg();
  1758. whgenleg.setfId(wareItem.getSrcId());
  1759. whgenleg.setfChargedate(wareItem.getfChargedate());
  1760. int i = tWhgenlegMapper.updateTWhgenleg(whgenleg);
  1761. if (i <= 0) {
  1762. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  1763. return AjaxResult.error("更新库存费用状态失败,请联系管理员");
  1764. }
  1765. } else {
  1766. TWarehousebillsitems billsItem = new TWarehousebillsitems();
  1767. billsItem.setfId(wareItem.getSrcId());
  1768. billsItem.setfBilltype(wareItem.getfBilltype());
  1769. if (!"SJCK".equals(wareItem.getfBilltype())) {
  1770. billsItem.setfChargedate(wareItem.getfBillingDeadline());
  1771. tWarehousebillsitemsMapper.updateTWarehousebillsitems(billsItem);
  1772. } else {
  1773. billsItem.setfChargedate(wareItem.getfChargedate());
  1774. }
  1775. tWarehousebillsitemsMapper.agreementApprovalRejected(billsItem);
  1776. }
  1777. }
  1778. }
  1779. return AjaxResult.success();
  1780. }
  1781. /**
  1782. * 撤销入账
  1783. *
  1784. * @param warehouseBills 主表
  1785. * @param warehousebillsitems 明细
  1786. * @param loginUser 当前登录人
  1787. * @param billsType 状态
  1788. * @return 结果
  1789. */
  1790. @Override
  1791. @Transactional
  1792. public AjaxResult revokeTWarehousebillsById1(String warehouseBills, String warehousebillsitems, String tEnclosure,
  1793. String warehousebillsfeesCr, String warehousebillsfeesDr, LoginUser loginUser, String billsType) {
  1794. if (StringUtils.isNull(warehouseBills) || "[]".equals(warehouseBills)) {
  1795. return AjaxResult.error("未找到主表信息");
  1796. }
  1797. if (StringUtils.isNull(warehousebillsitems) || "[]".equals(warehousebillsitems)) {
  1798. return AjaxResult.error("未找到入账信息");
  1799. }
  1800. TWarehouseBills tWarehousebills = JSONArray.parseObject(warehouseBills, TWarehouseBills.class);
  1801. tWarehousebills.setfItemsStatus(1L); //撤销状态
  1802. tWarehouseBillsMapper.updateTWarehousebills(tWarehousebills);
  1803. tEnclosureMapper.deleteByFPid(tWarehousebills.getfId());
  1804. tWarehousebillsfeesMapper.deleteByFPid(tWarehousebills.getfId());
  1805. JSONArray warehouseJSON = JSONArray.parseArray(warehousebillsitems);
  1806. List<TWarehousebillsitems> warehousebillsitemsList = JSONObject.parseArray(warehouseJSON.toJSONString(), TWarehousebillsitems.class);
  1807. if (StringUtils.isNotEmpty(warehousebillsitemsList)) {
  1808. int i = 1;
  1809. for (TWarehousebillsitems wb : warehousebillsitemsList) {
  1810. // 查询库存总账
  1811. TWhgenleg tWhgenle = queryTWhgenleg(tWarehousebills, wb);
  1812. if ("SJRKRevoke".equals(billsType)) { // 撤销 入库
  1813. if (wb.getfIsInventory().equals(0L)) {
  1814. if (StringUtils.isNotNull(tWhgenle) && (wb.getfQty() <= tWhgenle.getfQtyblc())) { // 非空 且 撤销数 <= 结余数
  1815. updateTWhgenlegData(wb, tWhgenle.getfId(), billsType);
  1816. } else { // 撤销数>结余数
  1817. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  1818. return AjaxResult.error("第" + i + "行撤销数大于库存结余数");
  1819. }
  1820. }
  1821. wb.setfBillstatus(10L);
  1822. } else if ("SJCKRevoke".equals(billsType)) { // 撤销出库
  1823. if (StringUtils.isNotNull(tWhgenle)) { // 非空
  1824. updateTWhgenlegData(wb, tWhgenle.getfId(), billsType);
  1825. } else {
  1826. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  1827. return AjaxResult.error("第" + i + "行未查询到库存信息");
  1828. }
  1829. wb.setfBillstatus(10L);
  1830. } else if ("CKDBRevoke".equals(billsType)) { // 调拨 撤销
  1831. Long warehouselocid = wb.getfWarehouselocid();// 原货仓库
  1832. Long transferWarehouselocid = wb.getfTransferWarehouselocid(); // 新仓库
  1833. // 1、新货权方撤销入库
  1834. // 查询库存总账
  1835. wb.setfWarehouselocid(transferWarehouselocid);
  1836. TWhgenleg tWhgenle1 = queryTWhgenleg(tWarehousebills, wb);
  1837. if (StringUtils.isNotNull(tWhgenle1) && (wb.getfQty() <= tWhgenle1.getfQtyblc())) {
  1838. updateTWhgenlegData(wb, tWhgenle1.getfId(), "SJRKRevoke");
  1839. } else {
  1840. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  1841. return AjaxResult.error("第" + i + "行撤销数大于库存结余数");
  1842. }
  1843. // 2、原货权方撤销出库
  1844. // 查询库存总账
  1845. wb.setfWarehouselocid(warehouselocid);
  1846. TWhgenleg tWhgenle2 = queryTWhgenleg(tWarehousebills, wb);
  1847. updateTWhgenlegData(wb, tWhgenle2.getfId(), "SJCKRevoke");
  1848. wb.setfBillstatus(10L);
  1849. } else if ("HQZYRevoke".equals(billsType)) { // 货转撤销
  1850. Long fCorpid = tWarehousebills.getfCorpid();// 原货权方
  1851. Long fTocorpid = tWarehousebills.getfTocorpid(); // 新货权方
  1852. // 1、新货权方撤销入库
  1853. // 查询库存总账
  1854. tWarehousebills.setfCorpid(fTocorpid);
  1855. TWhgenleg tWhgenle1 = queryTWhgenleg(tWarehousebills, wb);
  1856. if (StringUtils.isNotNull(tWhgenle1) && (wb.getfQty() <= tWhgenle1.getfQtyblc())) {
  1857. updateTWhgenlegData(wb, tWhgenle1.getfId(), "SJRKRevoke");
  1858. } else {
  1859. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  1860. return AjaxResult.error("第" + i + "行撤销数大于库存结余数");
  1861. }
  1862. // 2、原货权方撤销出库
  1863. // 查询库存总账
  1864. tWarehousebills.setfCorpid(fCorpid);
  1865. TWhgenleg tWhgenle2 = queryTWhgenleg(tWarehousebills, wb);
  1866. updateTWhgenlegData(wb, tWhgenle2.getfId(), "SJCKRevoke");
  1867. wb.setfBillstatus(1L);
  1868. }
  1869. i++;
  1870. wb.setUpdateBy(loginUser.getUser().getUserName());
  1871. wb.setUpdateTime(new Date());
  1872. if (tWarehousebillsitemsMapper.updateTWarehousebillsitems(wb) <= 0) {
  1873. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  1874. return AjaxResult.error("新增库存明细失败");
  1875. }
  1876. }
  1877. }
  1878. // 附件添加
  1879. if (StringUtils.isNotEmpty(tEnclosure) && !"[]".equals(tEnclosure)) {
  1880. JSONArray jsonDrArray = JSONArray.parseArray(tEnclosure);
  1881. List<TEnclosure> tEnclosureList = JSONObject.parseArray(jsonDrArray.toJSONString(), TEnclosure.class);
  1882. for (TEnclosure enclosure : tEnclosureList) {
  1883. enclosure.setfPid(tWarehousebills.getfId());
  1884. enclosure.setCreateBy(loginUser.getUser().getUserName());
  1885. enclosure.setCreateTime(new Date());
  1886. tEnclosureMapper.insertTEnclosure(enclosure);
  1887. }
  1888. }
  1889. // 收款明细添加
  1890. if (StringUtils.isNotEmpty(warehousebillsfeesDr) && !"[]".equals(warehousebillsfeesDr)) {
  1891. JSONArray jsonDrArray = JSONArray.parseArray(warehousebillsfeesDr);
  1892. List<TWarehousebillsfees> warehousebillsfeesDrList = JSONObject.parseArray(jsonDrArray.toJSONString(), TWarehousebillsfees.class);
  1893. for (TWarehousebillsfees wbDr : warehousebillsfeesDrList) {
  1894. wbDr.setfPid(tWarehousebills.getfId());
  1895. wbDr.setfDc("D");
  1896. wbDr.setCreateBy(loginUser.getUser().getUserName());
  1897. wbDr.setCreateTime(new Date());
  1898. if (tWarehousebills.getfBsdate() != null && !tWarehousebills.getfBsdate().equals("")) {
  1899. wbDr.setfBsdate(tWarehousebills.getfBsdate());
  1900. }
  1901. tWarehousebillsfeesMapper.insertTWarehousebillsfees(wbDr);
  1902. }
  1903. }
  1904. // 付款明细添加
  1905. if (StringUtils.isNotNull(warehousebillsfeesCr) && !"[]".equals(warehousebillsfeesCr)) {
  1906. JSONArray jsonCrArray = JSONArray.parseArray(warehousebillsfeesCr);
  1907. List<TWarehousebillsfees> warehousebillsfeesCrList = JSONObject.parseArray(jsonCrArray.toJSONString(), TWarehousebillsfees.class);
  1908. for (TWarehousebillsfees wbCr : warehousebillsfeesCrList) {
  1909. wbCr.setfPid(tWarehousebills.getfId());
  1910. wbCr.setfDc("C");
  1911. wbCr.setCreateBy(loginUser.getUser().getUserName());
  1912. wbCr.setCreateTime(new Date());
  1913. if (tWarehousebills.getfBsdate() != null && !tWarehousebills.getfBsdate().equals("")) {
  1914. wbCr.setfBsdate(tWarehousebills.getfBsdate());
  1915. }
  1916. tWarehousebillsfeesMapper.insertTWarehousebillsfees(wbCr);
  1917. }
  1918. }
  1919. return AjaxResult.success();
  1920. }
  1921. /**
  1922. * 添加 库存明细状态
  1923. *
  1924. * @param wbItem
  1925. * @param status
  1926. * @param loginUser
  1927. */
  1928. public void insertTWarehousebillsLog(TWarehousebillsitems wbItem, Long status, LoginUser loginUser) {
  1929. // 添加状态log
  1930. TWarehousebillsLog tWarehousebillsLog = new TWarehousebillsLog();
  1931. tWarehousebillsLog.setfPid(wbItem.getfPid());
  1932. tWarehousebillsLog.setfItmeid(wbItem.getfId());
  1933. tWarehousebillsLog.setfItmestatus(status);
  1934. tWarehousebillsLog.setCreateTime(new Date());
  1935. tWarehousebillsLog.setCreateBy(loginUser.getUser().getUserName());
  1936. tWarehousebillsLogMapper.insertTWarehousebillsLog(tWarehousebillsLog);
  1937. }
  1938. /**
  1939. * 删除 库存明细
  1940. *
  1941. * @param fid
  1942. * @param tWarehousebillsitems
  1943. */
  1944. public void deleteBillsitems(Long fid, String tWarehousebillsitems) {
  1945. List<Long> oldList = new ArrayList<Long>();
  1946. List<Long> newList = new ArrayList<Long>();
  1947. // 查询所有从表数据
  1948. TWarehousebillsitems tWarehousebillsitem = new TWarehousebillsitems();
  1949. tWarehousebillsitem.setfPid(fid);
  1950. List<TWarehousebillsitems> warehousebillsitemsList = tWarehousebillsitemsMapper.selectTWarehousebillsitemsList(tWarehousebillsitem);
  1951. warehousebillsitemsList.forEach(wb ->
  1952. oldList.add(wb.getfId())
  1953. );
  1954. // 获取提交从表数据ID
  1955. if (tWarehousebillsitems != null) {
  1956. JSONArray warehouseJSON = JSONArray.parseArray(tWarehousebillsitems);
  1957. List<TWarehousebillsitems> warehousebillsitemsLists = JSONObject.parseArray(warehouseJSON.toJSONString(), TWarehousebillsitems.class);
  1958. warehousebillsitemsLists.forEach(wb ->
  1959. newList.add(wb.getfId())
  1960. );
  1961. }
  1962. // 删除多余的ID
  1963. List<Long> reduce1 = oldList.stream().filter(item -> !newList.contains(item)).collect(toList());
  1964. reduce1.forEach(id ->
  1965. tWarehousebillsitemsMapper.deleteTWarehousebillsitemsById(id)
  1966. );
  1967. }
  1968. /**
  1969. * 库容-结余毛重
  1970. *
  1971. * @param fTotalgross
  1972. * @param fGrossweightblc
  1973. * @return
  1974. */
  1975. public static BigDecimal calculation1(String fTotalgross, String fGrossweightblc) {
  1976. BigDecimal num1 = new BigDecimal(fTotalgross);
  1977. BigDecimal num2 = new BigDecimal(fGrossweightblc);
  1978. BigDecimal result = num1.subtract(num2);
  1979. return result.setScale(2, BigDecimal.ROUND_HALF_UP);
  1980. }
  1981. /**
  1982. * 判断 是否允许 入库
  1983. *
  1984. * @param fId
  1985. */
  1986. public int calculation(Long fId, BigDecimal fGrossweight) {
  1987. // 仓库库容
  1988. TWarehouse tWarehouse = tWarehouseMapper.selectTWarehouseById(fId);
  1989. // 毛重公斤转化为吨
  1990. fGrossweight = fGrossweight.divide(new BigDecimal(1000), 0, BigDecimal.ROUND_HALF_UP);
  1991. // 总账使用
  1992. List<Map<String, Object>> whouseList = tWhgenlegMapper.selectWareHouseListWhouse(fId);
  1993. if (whouseList != null && whouseList.size() > 0) {
  1994. String fTotalgross = null;
  1995. String fGrossweightblc = null;
  1996. for (Map<String, Object> m : whouseList) {
  1997. for (String k : m.keySet()) {
  1998. // 获取毛重库容
  1999. if (k.equals("fTotalgross")) {
  2000. fTotalgross = m.get(k).toString();
  2001. }
  2002. if (k.equals("fGrossweightD")) {
  2003. fGrossweightblc = m.get(k).toString();
  2004. }
  2005. }
  2006. }
  2007. BigDecimal bd=new BigDecimal(fGrossweightblc);
  2008. fGrossweightblc = bd.divide(new BigDecimal(1000), 0, BigDecimal.ROUND_HALF_UP).toString();
  2009. BigDecimal result = calculation1(fTotalgross, fGrossweightblc);
  2010. if (result.compareTo(fGrossweight) == -1) {
  2011. return 0;// 结余库容小于入库数
  2012. } else {
  2013. return 1;
  2014. }
  2015. } else {
  2016. if(tWarehouse.getfTotalgross()!=null){
  2017. if (tWarehouse.getfTotalgross().compareTo(fGrossweight) == -1) {
  2018. return 0;// 库容小于入库数
  2019. } else {
  2020. return 1;
  2021. }
  2022. }else {
  2023. return 0;// 库容小于入库数
  2024. }
  2025. }
  2026. }
  2027. }