TWarehouseBillsServiceImpl.java 101 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093
  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. return tWarehouseBillsMapper.selectInventoryList(tWarehouseBills);
  735. }
  736. @Override
  737. public List<TWareHouseItemsExcel> selectTWarehousebillsItemsList(TWarehouseBills tWarehouseBills) {
  738. return tWarehouseBillsMapper.selectTWarehousebillsItemList(tWarehouseBills);
  739. }
  740. /**
  741. * 根据仓库主表id 更新对应明细表状态
  742. *
  743. * @param fPid 仓库主表id
  744. * @return 结果
  745. */
  746. @Transactional
  747. public AjaxResult warehouseFollow(Long fPid, long fettle) {
  748. if (StringUtils.isNull(fPid)) {
  749. return AjaxResult.error("仓库更新状态未找到主表信息,请与管理员联系");
  750. }
  751. try {
  752. tWarehouseBillsMapper.warehouseFollowUpdate(fPid, fettle, new Date());
  753. tWarehousebillsfeesMapper.warehouseFeesFollowUpdate(fPid, fettle, new Date());
  754. TWarehouseBills tWarehouseBills = tWarehouseBillsMapper.selectTWarehousebillsById(fPid);
  755. if ("SJRK".equals(tWarehouseBills.getfBilltype()) || "SJCK".equals(tWarehouseBills.getfBilltype())) {
  756. fettle = 40L;
  757. }
  758. tWarehousebillsitemsMapper.warehouseItemFollowUpdate(fPid, fettle);
  759. } catch (Exception e) {
  760. return AjaxResult.error("更新库存费用状态失败,请联系管理员");
  761. }
  762. return AjaxResult.success();
  763. }
  764. /**
  765. * 根据仓库主表id 更新对应明细表状态
  766. *
  767. * @param fPid 仓库主表id
  768. * @return 结果
  769. */
  770. @Transactional
  771. public AjaxResult storageFeeFollow(Long fPid, long fettle) {
  772. if (StringUtils.isNull(fPid)) {
  773. return AjaxResult.error("仓库更新状态未找到主表信息,请与管理员联系");
  774. }
  775. int warehouseUpdateResult = tWarehouseBillsMapper.warehouseFollowUpdate(fPid, fettle, new Date());
  776. if (warehouseUpdateResult <= 0) {
  777. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  778. return AjaxResult.error("更新库存明细状态失败,请联系管理员");
  779. }
  780. TWarehousebillsfees warehousebillsfees = new TWarehousebillsfees();
  781. warehousebillsfees.setfPid(fPid);
  782. List<TWarehousebillsfees> warehousebillsfeesList = tWarehousebillsfeesMapper.selectTWarehousebillsfeesList(warehousebillsfees);
  783. for (TWarehousebillsfees wareItem : warehousebillsfeesList) {
  784. if (StringUtils.isNull(wareItem.getSrcId())) {
  785. continue;
  786. }
  787. if ("KCZZ".equals(wareItem.getfBilltype())) {
  788. TWhgenleg tWhgenleg = tWhgenlegMapper.selectTWhgenlegById(wareItem.getSrcId());
  789. tWhgenleg.setfChargedate(DateUtils.dateAdd(wareItem.getfBillingDeadline(), 1));
  790. int i = tWhgenlegMapper.updateTWhgenleg(tWhgenleg);
  791. if (i <= 0) {
  792. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  793. return AjaxResult.error("更新库存费用状态失败,请联系管理员");
  794. }
  795. } else {
  796. TWarehousebillsitems tWarehousebillsitems = tWarehousebillsitemsMapper.selectTWarehousebillsitemsById(wareItem.getSrcId());
  797. tWarehousebillsitems.setfChargedate(DateUtils.dateAdd(wareItem.getfBillingDeadline(), 1));
  798. if ("SJCK".equals(wareItem.getfBilltype())) {
  799. tWarehousebillsitems.setfStorageFeeDeadline(wareItem.getfBillingDeadline());
  800. }
  801. tWarehousebillsitemsMapper.updateTWarehousebillsitems(tWarehousebillsitems);
  802. }
  803. }
  804. int feesUpdateResult = tWarehousebillsfeesMapper.warehouseFeesFollowUpdate(fPid, fettle, new Date());
  805. if (feesUpdateResult <= 0) {
  806. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  807. return AjaxResult.error("更新库存费用状态失败,请联系管理员");
  808. }
  809. return AjaxResult.success();
  810. }
  811. /**
  812. * 入库详情入账
  813. *
  814. * @param warehouseBills 主表
  815. * @param warehousebillsitems 明细
  816. * @param loginUser 当前登录人
  817. * @param billsType 状态
  818. * @return 结果
  819. */
  820. @Override
  821. @Transactional
  822. public AjaxResult addCredit(String warehouseBills, String warehousebillsitems, String tEnclosure, String warehousebillsfeesCr,
  823. String warehousebillsfeesDr, LoginUser loginUser, String billsType) {
  824. Map<String, Object> map = new HashMap<>();
  825. if (StringUtils.isNull(warehouseBills) || "[]".equals(warehouseBills)) {
  826. return AjaxResult.error("未找到主表信息");
  827. }
  828. if (StringUtils.isNull(warehousebillsitems) || "[]".equals(warehousebillsitems)) {
  829. return AjaxResult.error("未找到入账信息");
  830. }
  831. TWarehouseBills tWarehouseBills = JSONArray.parseObject(warehouseBills, TWarehouseBills.class);
  832. tWarehouseBills.setfItemsStatus(4L);
  833. tWarehouseBills.setfBilltype(billsType);
  834. tWarehouseBills.setUpdateBy(loginUser.getUser().getUserName());
  835. tWarehouseBills.setUpdateTime(new Date());
  836. tWarehouseBillsMapper.updateTWarehousebills(tWarehouseBills);
  837. tEnclosureMapper.deleteByFPid(tWarehouseBills.getfId());
  838. tWarehousebillsfeesMapper.deleteByFPid(tWarehouseBills.getfId());
  839. boolean businessStatus = "场地直装".equals(tWarehouseBills.getfBusinessType());
  840. JSONArray warehouseJSON = JSONArray.parseArray(warehousebillsitems);
  841. List<TWarehousebillsitems> warehousebillsitemsList = JSONObject.parseArray(warehouseJSON.toJSONString(), TWarehousebillsitems.class);
  842. for (TWarehousebillsitems item : warehousebillsitemsList) {
  843. if (!businessStatus) {
  844. // 查询库容量 是否可入库
  845. int m = calculation(tWarehouseBills.getfWarehouseid(), item.getfGrossweight());
  846. if (m == 0) {
  847. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  848. return AjaxResult.error("更新库存总账失败-->入库毛重大于库容");
  849. }
  850. item.setfBillingway(tWarehouseBills.getfBillingway());
  851. item.setfChargedate(tWarehouseBills.getfChargedate());
  852. TWhgenleg tWhgenle = queryTWhgenleg(tWarehouseBills, item);
  853. if (StringUtils.isNotNull(tWhgenle)) {
  854. int i = updateTWhgenlegData(item, tWhgenle.getfId(), billsType);
  855. if (i <= 0) {
  856. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  857. return AjaxResult.error("更新库存总账失败");
  858. }
  859. } else {
  860. if (instalTWhgenleg(tWarehouseBills, item, loginUser.getUser()) <= 0) {
  861. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  862. return AjaxResult.error("新增库存总账失败");
  863. }
  864. }
  865. item.setfIsInventory(0L);
  866. } else {
  867. item.setfIsInventory(1L);
  868. }
  869. int num = 0;
  870. if (StringUtils.isNotNull(item.getfId())) {
  871. item.setfBillstatus(40L);
  872. item.setUpdateBy(loginUser.getUser().getUserName());
  873. item.setUpdateTime(new Date());
  874. num = tWarehousebillsitemsMapper.updateTWarehousebillsitems(item);
  875. // 添加状态log
  876. insertTWarehousebillsLog(item, 40L, loginUser);
  877. }
  878. if (num <= 0) {
  879. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  880. return AjaxResult.error("新增库存明细失败");
  881. }
  882. }
  883. // 附件添加
  884. if (StringUtils.isNotEmpty(tEnclosure) && !"[]".equals(tEnclosure)) {
  885. JSONArray jsonDrArray = JSONArray.parseArray(tEnclosure);
  886. List<TEnclosure> tEnclosureList = JSONObject.parseArray(jsonDrArray.toJSONString(), TEnclosure.class);
  887. for (TEnclosure enclosure : tEnclosureList) {
  888. enclosure.setfPid(tWarehouseBills.getfId());
  889. enclosure.setCreateBy(loginUser.getUser().getUserName());
  890. enclosure.setCreateTime(new Date());
  891. tEnclosureMapper.insertTEnclosure(enclosure);
  892. }
  893. }
  894. // 收款明细添加
  895. if (StringUtils.isNotEmpty(warehousebillsfeesDr) && !"[]".equals(warehousebillsfeesDr)) {
  896. JSONArray jsonDrArray = JSONArray.parseArray(warehousebillsfeesDr);
  897. List<TWarehousebillsfees> warehousebillsfeesDrList = JSONObject.parseArray(jsonDrArray.toJSONString(), TWarehousebillsfees.class);
  898. for (TWarehousebillsfees wbDr : warehousebillsfeesDrList) {
  899. wbDr.setfPid(tWarehouseBills.getfId());
  900. wbDr.setfDc("D");
  901. wbDr.setCreateBy(loginUser.getUser().getUserName());
  902. wbDr.setCreateTime(new Date());
  903. if (tWarehouseBills.getfBsdate() != null && !tWarehouseBills.getfBsdate().equals("")) {
  904. wbDr.setfBsdate(tWarehouseBills.getfBsdate());
  905. }
  906. tWarehousebillsfeesMapper.insertTWarehousebillsfees(wbDr);
  907. }
  908. }
  909. // 付款明细添加
  910. if (StringUtils.isNotNull(warehousebillsfeesCr) && !"[]".equals(warehousebillsfeesCr)) {
  911. JSONArray jsonCrArray = JSONArray.parseArray(warehousebillsfeesCr);
  912. List<TWarehousebillsfees> warehousebillsfeesCrList = JSONObject.parseArray(jsonCrArray.toJSONString(), TWarehousebillsfees.class);
  913. for (TWarehousebillsfees wbCr : warehousebillsfeesCrList) {
  914. wbCr.setfPid(tWarehouseBills.getfId());
  915. wbCr.setfDc("C");
  916. wbCr.setCreateBy(loginUser.getUser().getUserName());
  917. wbCr.setCreateTime(new Date());
  918. if (tWarehouseBills.getfBsdate() != null && !tWarehouseBills.getfBsdate().equals("")) {
  919. wbCr.setfBsdate(tWarehouseBills.getfBsdate());
  920. }
  921. tWarehousebillsfeesMapper.insertTWarehousebillsfees(wbCr);
  922. }
  923. }
  924. map.put("warehousebillsitems", warehousebillsitemsList);
  925. return AjaxResult.success("成功", map);
  926. }
  927. /**
  928. * 出库、调拨、货转 确认
  929. *
  930. * @param warehouseBills
  931. * @param warehousebillsitems
  932. * @param loginUser
  933. * @param billsType
  934. * @return
  935. */
  936. @Override
  937. @Transactional
  938. public AjaxResult updateCredit(String warehouseBills, String warehousebillsitems, String tEnclosure, String warehousebillsfeesCr,
  939. String warehousebillsfeesDr, LoginUser loginUser, String billsType) {
  940. Long fPid = null;
  941. Map<String, Object> map = new HashMap<>();
  942. TWarehouseBills tWarehouseBills = JSONArray.parseObject(warehouseBills, TWarehouseBills.class);
  943. tWarehouseBills.setfItemsStatus(4L);
  944. tWarehouseBills.setfBilltype(billsType);
  945. if (StringUtils.isNotNull(tWarehouseBills.getfId())) {
  946. tWarehouseBills.setUpdateBy(loginUser.getUser().getUserName());
  947. tWarehouseBills.setUpdateTime(new Date());
  948. tWarehouseBillsMapper.updateTWarehousebills(tWarehouseBills);
  949. fPid = tWarehouseBills.getfId();
  950. } else {
  951. tWarehouseBills.setfBsdeptid(loginUser.getUser().getDeptId());
  952. tWarehouseBills.setCreateBy(loginUser.getUser().getUserName());
  953. tWarehouseBills.setCreateTime(new Date());
  954. String billNo = billnoSerialServiceImpl.getBillNo(billsType, tWarehouseBills.getfBsdate());
  955. tWarehouseBills.setfBillno(billNo);
  956. tWarehouseBillsMapper.insertTWarehousebills(tWarehouseBills);
  957. fPid = tWarehouseBills.getfId();
  958. }
  959. tEnclosureMapper.deleteByFPid(fPid);
  960. tWarehousebillsfeesMapper.deleteByFPid(fPid);
  961. JSONArray warehouseJSON = JSONArray.parseArray(warehousebillsitems);
  962. List<TWarehousebillsitems> warehousebillsitemsList = JSONObject.parseArray(warehouseJSON.toJSONString(), TWarehousebillsitems.class);
  963. int i = 1;
  964. List<TFees> feesList = new ArrayList<>();
  965. List<TWarehousebillsfees> warehousebillsfees = new ArrayList<>();
  966. for (TWarehousebillsitems wbItem : warehousebillsitemsList) {
  967. long warehouselocId = 0L;
  968. long transferWarehouselocid = 0L;
  969. if ("CKDB".equals(billsType)) {
  970. warehouselocId = wbItem.getfWarehouselocid();
  971. transferWarehouselocid = wbItem.getfTransferWarehouselocid();
  972. // wbItem.setfWarehouselocid(transferWarehouselocid);
  973. }
  974. // 查询总账是否存在
  975. TWhgenleg tWhgenle = queryTWhgenleg(tWarehouseBills, wbItem);
  976. // 入库数特殊不判断入账
  977. if ("SJCK".equals(billsType)) { // 出库 查询
  978. if (StringUtils.isNull(tWhgenle)) { // 为空 提示没有库存
  979. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  980. return AjaxResult.error("库存明细第" + i + "行库存为空");
  981. } else { // 非空修改库存总账
  982. // 库存 < 出库件数
  983. if (tWhgenle.getfQtyblc() < wbItem.getfQty()) {
  984. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  985. return AjaxResult.error("库存明细第" + i + "行库存不足");
  986. }
  987. // 更新库存总账
  988. updateTWhgenlegData(wbItem, tWhgenle.getfId(), billsType);
  989. if (StringUtils.isNull(tWarehouseBills.getfBsdate()) || StringUtils.isNull(wbItem.getfChargedate())) {
  990. return AjaxResult.error("库存明细第" + i + "行请检查日期,操作终止");
  991. }
  992. long dateDay = DateUtils.getDateDay(tWarehouseBills.getfBsdate(), wbItem.getfChargedate());
  993. if (StringUtils.isNull(tWarehouseBills.getfCorpid())) {
  994. return AjaxResult.error("库存明细第" + i + "行请检查客户信息,操作终止");
  995. }
  996. /*long fCorpid = tWarehouseBills.getfCorpid();
  997. TGoods tGoods = tGoodsMapper.selectTGoodsById(wbItem.getfGoodsid());
  998. long fGoodsid = tGoods.getfTypeid();
  999. long fBillingway = wbItem.getfBillingway();
  1000. long fQty = wbItem.getfQty();
  1001. // 计算仓储费明细
  1002. Map<String, Object> objectMap = tWarehouseAgreementService.getCarryingCost(fCorpid, fGoodsid, dateDay, fBillingway, fQty , 0L);
  1003. if (StringUtils.isNull(objectMap)) {
  1004. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  1005. return AjaxResult.error("库存明细第" + i + "行没有维护出库明细的仓储协议,操作终止");
  1006. }
  1007. Long feeId = (Long) objectMap.get("feeId");
  1008. BigDecimal amt = (BigDecimal) objectMap.get("amt");
  1009. TFees tFees = tFeesMapper.selectTFeesById(feeId);
  1010. if (StringUtils.isNotNull(tFees)) {
  1011. feesList.add(tFees);
  1012. }
  1013. TWarehousebillsfees fees = new TWarehousebillsfees();
  1014. fees.setfPid(fPid);
  1015. fees.setfFeeid(feeId);
  1016. fees.setfCorpid(tWarehouseBills.getfCorpid());
  1017. fees.setfFeeUnitid(fBillingway);
  1018. fees.setfQty(new BigDecimal(1));
  1019. fees.setfUnitprice(amt);
  1020. fees.setfAmount(amt);
  1021. fees.setfExrate(new BigDecimal(1));
  1022. fees.setfCurrency("RMB");
  1023. fees.setRemark(dateDay + "天" + tFees.getfName());
  1024. warehousebillsfees.add(fees);*/
  1025. }
  1026. wbItem.setfBillstatus(40L);
  1027. } else if ("CKDB".equals(billsType)) { // 调拨查询
  1028. if (StringUtils.isNull(tWhgenle)) { // 为空 提示没有库存
  1029. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  1030. return AjaxResult.error("库存明细第" + i + "行库存为空");
  1031. } else { // 非空修改库存总账
  1032. if (tWhgenle.getfQtyblc() < wbItem.getfQty()) { // 1、 库存 < 调拨件数 提示库存不足
  1033. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  1034. return AjaxResult.error("库存明细第" + i + "行库存不足");
  1035. } else { // 2、 库存足够 先 进行出库操作
  1036. wbItem.setfWarehouselocid(warehouselocId);
  1037. updateTWhgenlegData(wbItem, tWhgenle.getfId(), "SJCK");
  1038. }
  1039. // 3、 进行入库操作 查询是否存在库存
  1040. wbItem.setfWarehouselocid(transferWarehouselocid); // 新库区
  1041. TWhgenleg tWhgenle1 = queryTWhgenleg(tWarehouseBills, wbItem);
  1042. if (StringUtils.isNull(tWhgenle1)) { // 5、 不存在 进行新增库存
  1043. instalTWhgenleg(tWarehouseBills, wbItem, loginUser.getUser());
  1044. } else { // 4、 存在 进行跟新库存
  1045. updateTWhgenlegData(wbItem, tWhgenle1.getfId(), "SJRK");
  1046. }
  1047. }
  1048. wbItem.setfWarehouselocid(warehouselocId);
  1049. wbItem.setfBillstatus(40L);
  1050. } else if ("HQZY".equals(billsType)) { // 货转
  1051. wbItem.setfBillstatus(6L);
  1052. wbItem.setfChargedate(tWarehouseBills.getfChargedate());
  1053. wbItem.setfBillingway(tWarehouseBills.getfBillingway());
  1054. if (StringUtils.isNull(tWhgenle)) { // 为空 提示没有库存
  1055. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  1056. return AjaxResult.error("库存明细第" + i + "行库存为空");
  1057. } else { // 非空修改库存总账
  1058. if (tWhgenle.getfQtyblc() < wbItem.getfQty()) { // 1、 库存 < 调拨件数 提示库存不足
  1059. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  1060. return AjaxResult.error("库存明细第" + i + "行库存不足");
  1061. } else { // 2、 库存足够 先 进行出库操作
  1062. updateTWhgenlegData(wbItem, tWhgenle.getfId(), "SJCK");
  1063. }
  1064. long corpId = tWarehouseBills.getfCorpid();
  1065. tWarehouseBills.setfCorpid(tWarehouseBills.getfTocorpid());
  1066. // 3、 进行入库操作 查询是否存在库存
  1067. TWhgenleg tWhgenle1 = queryTWhgenleg(tWarehouseBills, wbItem);
  1068. if (StringUtils.isNull(tWhgenle1)) { // 5、 不存在 进行新增库存
  1069. instalTWhgenleg(tWarehouseBills, wbItem, loginUser.getUser());
  1070. } else { // 4、 存在 进行跟新库存
  1071. updateTWhgenlegData(wbItem, tWhgenle1.getfId(), "SJRK");
  1072. }
  1073. tWarehouseBills.setfCorpid(corpId);
  1074. }
  1075. }
  1076. i++;
  1077. int num = 0;
  1078. wbItem.setfPid(fPid);
  1079. wbItem.setfBilltype(billsType);
  1080. wbItem.setfBillno(tWarehouseBills.getfBillno());
  1081. wbItem.setfBsdate(tWarehouseBills.getfBsdate());
  1082. if (StringUtils.isNotNull(wbItem.getfId())) {
  1083. wbItem.setUpdateBy(loginUser.getUser().getUserName());
  1084. wbItem.setUpdateTime(new Date());
  1085. num = tWarehousebillsitemsMapper.updateTWarehousebillsitems(wbItem);
  1086. if ("SJCK".equals(billsType)) {
  1087. // 添加状态log
  1088. insertTWarehousebillsLog(wbItem, 40L, loginUser);
  1089. }
  1090. } else {
  1091. wbItem.setCreateTime(new Date());
  1092. wbItem.setCreateBy(loginUser.getUsername());
  1093. num = tWarehousebillsitemsMapper.insertTWarehousebillsitems(wbItem);
  1094. }
  1095. if (num <= 0) {
  1096. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  1097. return AjaxResult.error("库存明细更新失败");
  1098. }
  1099. }
  1100. // 附件添加
  1101. if (StringUtils.isNotEmpty(tEnclosure) && !"[]".equals(tEnclosure)) {
  1102. JSONArray jsonDrArray = JSONArray.parseArray(tEnclosure);
  1103. List<TEnclosure> tEnclosureList = JSONObject.parseArray(jsonDrArray.toJSONString(), TEnclosure.class);
  1104. for (TEnclosure enclosure : tEnclosureList) {
  1105. enclosure.setfPid(tWarehouseBills.getfId());
  1106. enclosure.setCreateBy(loginUser.getUser().getUserName());
  1107. enclosure.setCreateTime(new Date());
  1108. tEnclosureMapper.insertTEnclosure(enclosure);
  1109. }
  1110. }
  1111. // 收款明细添加
  1112. if (StringUtils.isNotEmpty(warehousebillsfeesDr) && !"[]".equals(warehousebillsfeesDr)) {
  1113. JSONArray jsonDrArray = JSONArray.parseArray(warehousebillsfeesDr);
  1114. List<TWarehousebillsfees> warehousebillsfeesDrList = JSONObject.parseArray(jsonDrArray.toJSONString(), TWarehousebillsfees.class);
  1115. for (TWarehousebillsfees wbDr : warehousebillsfeesDrList) {
  1116. wbDr.setfPid(tWarehouseBills.getfId());
  1117. wbDr.setfDc("D");
  1118. wbDr.setCreateBy(loginUser.getUser().getUserName());
  1119. wbDr.setCreateTime(new Date());
  1120. tWarehousebillsfeesMapper.insertTWarehousebillsfees(wbDr);
  1121. }
  1122. }
  1123. // 付款明细添加
  1124. if (StringUtils.isNotNull(warehousebillsfeesCr) && !"[]".equals(warehousebillsfeesCr)) {
  1125. JSONArray jsonCrArray = JSONArray.parseArray(warehousebillsfeesCr);
  1126. List<TWarehousebillsfees> warehousebillsfeesCrList = JSONObject.parseArray(jsonCrArray.toJSONString(), TWarehousebillsfees.class);
  1127. for (TWarehousebillsfees wbCr : warehousebillsfeesCrList) {
  1128. wbCr.setfPid(tWarehouseBills.getfId());
  1129. wbCr.setfDc("C");
  1130. wbCr.setCreateBy(loginUser.getUser().getUserName());
  1131. wbCr.setCreateTime(new Date());
  1132. tWarehousebillsfeesMapper.insertTWarehousebillsfees(wbCr);
  1133. }
  1134. }
  1135. map.put("fPid", fPid);
  1136. map.put("warehouse", tWarehouseBills);
  1137. map.put("warehouseItem", warehousebillsitemsList);
  1138. map.put("fees", feesList);
  1139. map.put("warehousebillsfees", warehousebillsfees);
  1140. // 添加成功 主键返回 前台
  1141. return AjaxResult.success("成功", map);
  1142. }
  1143. /**
  1144. * 打印作业单
  1145. *
  1146. * @param warehouseBills
  1147. * @param warehousebillsitems
  1148. * @param tEnclosure
  1149. * @param tWarehousebillsfeesCr
  1150. * @param tWarehousebillsfeesDr
  1151. * @param loginUser
  1152. * @param status
  1153. * @param billtystatus
  1154. * @return
  1155. */
  1156. @Override
  1157. public AjaxResult waitWarehousing(String warehouseBills, String warehousebillsitems,
  1158. String tEnclosure, String tWarehousebillsfeesCr, String tWarehousebillsfeesDr,
  1159. LoginUser loginUser, Long status, String billtystatus) {
  1160. Map<String, Object> map = new HashMap<>();
  1161. if (StringUtils.isNull(warehouseBills) || "[]".equals(warehouseBills)) {
  1162. return AjaxResult.error("未找到主表信息");
  1163. }
  1164. if (StringUtils.isNull(warehousebillsitems) || "[]".equals(warehousebillsitems)) {
  1165. return AjaxResult.error("未找到入账信息");
  1166. }
  1167. TWarehouseBills tWarehouseBills = JSONArray.parseObject(warehouseBills, TWarehouseBills.class);
  1168. if(status==20){
  1169. tWarehouseBills.setfItemsStatus(2L);
  1170. }else if(status==30){
  1171. tWarehouseBills.setfItemsStatus(3L);
  1172. }
  1173. if (StringUtils.isNotNull(tWarehouseBills.getfId())) {
  1174. tWarehouseBills.setUpdateBy(loginUser.getUser().getUserName());
  1175. tWarehouseBills.setUpdateTime(new Date());
  1176. tWarehouseBillsMapper.updateTWarehousebills(tWarehouseBills);
  1177. }
  1178. tEnclosureMapper.deleteByFPid(tWarehouseBills.getfId());
  1179. tWarehousebillsfeesMapper.deleteByFPid(tWarehouseBills.getfId());
  1180. JSONArray warehouseJSON = JSONArray.parseArray(warehousebillsitems);
  1181. List<TWarehousebillsitems> warehousebillsitemsList = JSONObject.parseArray(warehouseJSON.toJSONString(), TWarehousebillsitems.class);
  1182. for (TWarehousebillsitems item : warehousebillsitemsList) {
  1183. // 生成流水号
  1184. Date time = new Date();
  1185. String serialNumber;
  1186. if (item.getfBillstatus() < 30L) {
  1187. if ("RK".equals(billtystatus)) { // 生成 入库 流水号
  1188. serialNumber = billnoSerialServiceImpl.getSerialNumber("RK", time);
  1189. item.setfSerialNumber(serialNumber);
  1190. } else if ("CK".equals(billtystatus)) { //生成 出库 流水号
  1191. serialNumber = billnoSerialServiceImpl.getSerialNumber("CK", time);
  1192. item.setfSerialNumber(serialNumber);
  1193. } else if ("DB".equals(billtystatus)) { //生成 出库 流水号
  1194. serialNumber = billnoSerialServiceImpl.getSerialNumber("DB", time);
  1195. item.setfSerialNumber(serialNumber);
  1196. }
  1197. item.setfBillstatus(status);
  1198. item.setUpdateTime(new Date());
  1199. item.setUpdateBy(loginUser.getUser().getUserName());
  1200. int num = tWarehousebillsitemsMapper.updateTWarehousebillsitems(item);
  1201. // 添加状态log
  1202. insertTWarehousebillsLog(item, status, loginUser);
  1203. if (num <= 0) {
  1204. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  1205. return AjaxResult.error("更新库存明细失败");
  1206. }
  1207. }
  1208. }
  1209. // 附件添加
  1210. if (StringUtils.isNotEmpty(tEnclosure) && !"[]".equals(tEnclosure)) {
  1211. JSONArray jsonDrArray = JSONArray.parseArray(tEnclosure);
  1212. List<TEnclosure> tEnclosureList = JSONObject.parseArray(jsonDrArray.toJSONString(), TEnclosure.class);
  1213. for (TEnclosure enclosure : tEnclosureList) {
  1214. enclosure.setfPid(tWarehouseBills.getfId());
  1215. enclosure.setCreateBy(loginUser.getUser().getUserName());
  1216. enclosure.setCreateTime(new Date());
  1217. tEnclosureMapper.insertTEnclosure(enclosure);
  1218. }
  1219. }
  1220. // 收款明细添加
  1221. if (StringUtils.isNotEmpty(tWarehousebillsfeesDr) && !"[]".equals(tWarehousebillsfeesDr)) {
  1222. JSONArray jsonDrArray = JSONArray.parseArray(tWarehousebillsfeesDr);
  1223. List<TWarehousebillsfees> warehousebillsfeesDrList = JSONObject.parseArray(jsonDrArray.toJSONString(), TWarehousebillsfees.class);
  1224. for (TWarehousebillsfees wbDr : warehousebillsfeesDrList) {
  1225. wbDr.setfPid(tWarehouseBills.getfId());
  1226. wbDr.setfDc("D");
  1227. wbDr.setCreateBy(loginUser.getUser().getUserName());
  1228. wbDr.setCreateTime(new Date());
  1229. if (tWarehouseBills.getfBsdate() != null && !tWarehouseBills.getfBsdate().equals("")) {
  1230. wbDr.setfBsdate(tWarehouseBills.getfBsdate());
  1231. }
  1232. tWarehousebillsfeesMapper.insertTWarehousebillsfees(wbDr);
  1233. }
  1234. }
  1235. // 付款明细添加
  1236. if (StringUtils.isNotNull(tWarehousebillsfeesCr) && !"[]".equals(tWarehousebillsfeesCr)) {
  1237. JSONArray jsonCrArray = JSONArray.parseArray(tWarehousebillsfeesCr);
  1238. List<TWarehousebillsfees> warehousebillsfeesCrList = JSONObject.parseArray(jsonCrArray.toJSONString(), TWarehousebillsfees.class);
  1239. for (TWarehousebillsfees wbCr : warehousebillsfeesCrList) {
  1240. wbCr.setfPid(tWarehouseBills.getfId());
  1241. wbCr.setfDc("C");
  1242. wbCr.setCreateBy(loginUser.getUser().getUserName());
  1243. wbCr.setCreateTime(new Date());
  1244. if (tWarehouseBills.getfBsdate() != null && !tWarehouseBills.getfBsdate().equals("")) {
  1245. wbCr.setfBsdate(tWarehouseBills.getfBsdate());
  1246. }
  1247. tWarehousebillsfeesMapper.insertTWarehousebillsfees(wbCr);
  1248. }
  1249. }
  1250. // 添加成功 返回 前台
  1251. TWarehousebillsitems tWarehousebillsitems = new TWarehousebillsitems();
  1252. tWarehousebillsitems.setfPid(tWarehouseBills.getfId());
  1253. List<TWarehousebillsitems> mapList = tWarehousebillsitemsMapper.selectTWarehousebillsitemsList(tWarehousebillsitems);
  1254. map.put("warehousebillsitems", mapList);
  1255. return AjaxResult.success("成功", map);
  1256. }
  1257. /**
  1258. * 生成计算仓储费信息
  1259. *
  1260. * @param warehouseBills
  1261. * @param mapItem
  1262. * @param loginUser
  1263. * @return
  1264. */
  1265. public Map<String, Object> getWarehouseItems(TWarehouseBills warehouseBills, List<Map<String, Object>> mapItem, LoginUser loginUser) {
  1266. Map<String, Object> map = new HashMap<>();
  1267. long feeId = 0L;
  1268. BigDecimal sumAmt = new BigDecimal(0);
  1269. List<TWarehousebillsfees> itemsList = new ArrayList<>();
  1270. List<SysDictData> taxRate = sysDictDataMapper.selectDictDataByType("tax_rate");
  1271. for (Map<String, Object> item : mapItem) {
  1272. if (StringUtils.isNull(item.get("fBillingway"))) {
  1273. map.put("error", "单号:" + item.get("fBillno") + ",业务日期:" + item.get("fBsdate") + "未找到库存总账的计费单位,请确认");
  1274. return map;
  1275. }
  1276. Date fBsdate = (Date) item.get("fBsdate");
  1277. long fCorpid = warehouseBills.getfCorpid();
  1278. String fBilltype = (String) item.get("fBilltype");
  1279. long fGoodsid = Long.parseLong((String) item.get("fTypeid"));
  1280. long fId = Long.valueOf(String.valueOf(item.get("fId"))).longValue();
  1281. // 累计计费天数
  1282. long accumulatedDays = DateUtils.getDateDay((Date) item.get("fChargedate"), (Date) item.get("fOriginalbilldate"));
  1283. // 库存天数
  1284. long fInventoryDays = 0L;
  1285. // 要计费天数
  1286. long fBillingDays = DateUtils.getDateDay(warehouseBills.getfBillingDeadline(), (Date) item.get("fOriginalbilldate"));
  1287. if ("SJCK".equals(fBilltype)) {
  1288. fInventoryDays = DateUtils.getDateDay(fBsdate, (Date) item.get("fOriginalbilldate"));
  1289. fBillingDays = fInventoryDays;
  1290. } else if ("HQZY".equals(fBilltype)) {
  1291. fInventoryDays = DateUtils.getDateDay(warehouseBills.getfBillingDeadline(), fBsdate);
  1292. } else {
  1293. fBillingDays = DateUtils.getDateDay(warehouseBills.getfBillingDeadline(), (Date) item.get("fChargedate"));
  1294. fInventoryDays = DateUtils.getDateDay(warehouseBills.getfBillingDeadline(), (Date) item.get("fOriginalbilldate"));
  1295. }
  1296. /*if ("KCZZ".equals(fBilltype)) {
  1297. } else {
  1298. fInventoryDays = Long.valueOf(String.valueOf(item.get("fBillingDays")));
  1299. }*/
  1300. Long dictLabel = Long.valueOf(String.valueOf(item.get("fBillingway")));
  1301. BigDecimal fQty = acquiredQuantity(item, dictLabel);
  1302. if (fQty.equals(BigDecimal.ZERO)) {
  1303. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  1304. return AjaxResult.error("单号:" + item.get("fBillno") + ",业务日期:" + item.get("fBsdate") + "未找到计费单位,请确认");
  1305. }
  1306. // 计算仓储费明细
  1307. Map<String, Object> objectMap = tWarehouseAgreementService.getCarryingCost(fCorpid, fGoodsid, fBillingDays, dictLabel, fQty, accumulatedDays);
  1308. if (StringUtils.isNull(objectMap)) {
  1309. map.put("error", "单号:" + item.get("fBillno") + ",业务日期:" + item.get("fBsdate") + "未找到仓储费协议,请确认");
  1310. return map;
  1311. }
  1312. String mblno = "";
  1313. if (StringUtils.isNotNull(item.get("fMblno"))) {
  1314. mblno = item.get("fMblno").toString();
  1315. }
  1316. String remark = objectMap.get("remark").toString();
  1317. feeId = Long.valueOf(String.valueOf(objectMap.get("feeId"))).longValue();
  1318. BigDecimal amt = (BigDecimal) objectMap.get("amt");
  1319. map.put("feeId", feeId);
  1320. map.put("itemFeeId", objectMap.get("feeId"));
  1321. sumAmt = sumAmt.add(amt).setScale(2, BigDecimal.ROUND_HALF_UP);
  1322. TWarehousebillsfees fees = new TWarehousebillsfees();
  1323. fees.setfFeeid(feeId);
  1324. fees.setfDc("D");
  1325. fees.setfAmt(amt);
  1326. fees.setSrcId(fId);
  1327. fees.setfMblno(mblno);
  1328. fees.setRemark(remark);
  1329. fees.setfFeeunitid(2L);
  1330. fees.setfAmount(sumAmt);
  1331. fees.setfBillstatus(2L);
  1332. fees.setfCurrency("RMB");
  1333. fees.setfBsdate(fBsdate);
  1334. fees.setfBillingQty(fQty);
  1335. fees.setfUnitprice(sumAmt);
  1336. fees.setfBilltype(fBilltype);
  1337. fees.setfBillingDays(fBillingDays);
  1338. fees.setCreateTime(new Date());
  1339. fees.setfQty(new BigDecimal(1));
  1340. fees.setfPid(warehouseBills.getfId());
  1341. fees.setfInventoryDays(fInventoryDays);
  1342. fees.setfExrate(new BigDecimal(1));
  1343. fees.setfCorpid(warehouseBills.getfCorpid());
  1344. fees.setfMarks(item.get("fMarks").toString());
  1345. fees.setSrcBillNo((String) item.get("fBillno"));
  1346. fees.setfChargedate((Date) item.get("fChargedate"));
  1347. fees.setCreateBy(loginUser.getUser().getUserName());
  1348. fees.setfProductName(item.get("fGoodsids").toString());
  1349. if ("SJCK".equals(fBilltype)) {
  1350. fees.setfBillingDeadline(fBsdate);
  1351. } else {
  1352. fees.setfBillingDeadline(warehouseBills.getfBillingDeadline());
  1353. }
  1354. fees.setfTaxrate(new BigDecimal(taxRate.get(0).getDictValue()));
  1355. fees.setfOriginalbilldate((Date) item.get("fOriginalbilldate"));
  1356. fees.setfBillingway(Long.valueOf(String.valueOf(item.get("fBillingway"))).longValue());
  1357. tWarehousebillsfeesMapper.insertTWarehousebillsfees(fees);
  1358. itemsList.add(fees);
  1359. }
  1360. map.put("sumAmt", sumAmt);
  1361. map.put("itemsList", itemsList);
  1362. return map;
  1363. }
  1364. /**
  1365. * 新增库存费计算
  1366. *
  1367. * @param tWarehouseBills 主表的查询条件
  1368. * @param loginUser 登录用户
  1369. * @param billsType 状态
  1370. * @return 结果
  1371. */
  1372. @Override
  1373. @Transactional
  1374. public AjaxResult calculateStorageFees(TWarehouseBills tWarehouseBills, LoginUser loginUser, String billsType) {
  1375. if (StringUtils.isNull(tWarehouseBills.getfCorpid())) {
  1376. return AjaxResult.error("请选择客户信息");
  1377. }
  1378. long fPid = 0L;
  1379. if (StringUtils.isNull(tWarehouseBills.getfId())) {
  1380. // 生成流水号
  1381. Date time = new Date();
  1382. String billNo = billnoSerialServiceImpl.getSerialNumber("JSCCF", time);
  1383. tWarehouseBills.setfBillno(billNo);
  1384. if (StringUtils.isNull(tWarehouseBills.getfBillstatus())) {
  1385. tWarehouseBills.setfBillstatus(2L);
  1386. }
  1387. tWarehouseBills.setfBilltype(billsType);
  1388. tWarehouseBills.setfBsdeptid(loginUser.getUser().getDeptId());
  1389. tWarehouseBills.setCreateBy(loginUser.getUser().getUserName());
  1390. tWarehouseBills.setCreateTime(new Date());
  1391. tWarehouseBillsMapper.insertTWarehousebills(tWarehouseBills);
  1392. fPid = tWarehouseBills.getfId();
  1393. } else {
  1394. tWarehousebillsfeesMapper.deleteByFPid(tWarehouseBills.getfId());
  1395. tWarehousebillsitemsMapper.deleteByFPid(tWarehouseBills.getfId());
  1396. tWarehouseBills.setUpdateBy(loginUser.getUser().getUserName());
  1397. tWarehouseBills.setUpdateTime(new Date());
  1398. tWarehouseBillsMapper.updateTWarehousebills(tWarehouseBills);
  1399. fPid = tWarehouseBills.getfId();
  1400. }
  1401. // 计划物资明细
  1402. List<TWarehousebillsfees> itemsList = new ArrayList<>();
  1403. BigDecimal bigDecimal = new BigDecimal(0);
  1404. Map<String, Object> map = new HashMap<>();
  1405. // 库存总账id
  1406. long whgenlegFeeId = 0;
  1407. // 计费单位
  1408. long feeUnitid = 1;
  1409. // 查询 出库 货转的库存明细
  1410. List<Map<String, Object>> warehousebillsitemsList = tWarehousebillsitemsMapper.selectStorageFeeItemList(tWarehouseBills);
  1411. if (warehousebillsitemsList.size() != 0) {
  1412. Map<String, Object> mapItem = getWarehouseItems(tWarehouseBills, warehousebillsitemsList, loginUser);
  1413. if (mapItem.containsKey("error")) {
  1414. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  1415. return AjaxResult.error((String) mapItem.get("error"));
  1416. }
  1417. itemsList = (List<TWarehousebillsfees>) mapItem.get("itemsList");
  1418. }
  1419. List<Map<String, Object>> tWhgenlegs = tWhgenlegMapper.selectStorageFeeItemList(tWarehouseBills);
  1420. if (tWhgenlegs.size() != 0) {
  1421. Map<String, Object> mapItem = getWarehouseItems(tWarehouseBills, tWhgenlegs, loginUser);
  1422. if (mapItem.containsKey("error")) {
  1423. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  1424. return AjaxResult.error((String) mapItem.get("error"));
  1425. }
  1426. List<TWarehousebillsfees> itemList = (List<TWarehousebillsfees>) mapItem.get("itemsList");
  1427. if (itemList.size() != 0) {
  1428. for (TWarehousebillsfees ite : itemList) {
  1429. itemsList.add(ite);
  1430. }
  1431. }
  1432. }
  1433. TFees tFees = new TFees();
  1434. tFees.setfStatus("2");
  1435. tFees.setDelFlag("0");
  1436. List<TFees> feesList = tFeesMapper.selectTFeesList(tFees);
  1437. if (itemsList.size() <= 0) {
  1438. return AjaxResult.error("未找到合适的库存明细");
  1439. }
  1440. map.put("feesList", feesList);
  1441. map.put("warehouseBills", tWarehouseBills);
  1442. map.put("warehouseItemList", itemsList);
  1443. return AjaxResult.success(map);
  1444. }
  1445. /**
  1446. * 仓储费计算提交以及暂存
  1447. *
  1448. * @param warehouseBills
  1449. * @param warehouseItems
  1450. * @param warehouseFees
  1451. * @param loginUser
  1452. * @param billsType
  1453. * @return
  1454. */
  1455. @Override
  1456. @Transactional
  1457. public AjaxResult insertStorageFee(String warehouseBills, String warehouseItems, String warehouseFees, LoginUser loginUser, String billsType) {
  1458. TWarehouseBills tWarehousebills = JSONArray.parseObject(warehouseBills, TWarehouseBills.class);
  1459. long fPid = 0L;
  1460. boolean billstatus = tWarehousebills.getfBillstatus().equals(4L);
  1461. if (billstatus && (StringUtils.isNull(warehouseItems) || "[]".equals(warehouseItems))) {
  1462. return AjaxResult.error("未找到计费物资明细无法提交");
  1463. }
  1464. /*if (billstatus && (StringUtils.isNull(warehouseFees) || "[]".equals(warehouseFees))) {
  1465. return AjaxResult.error("未找到应收款明细无法提交");
  1466. }*/
  1467. if (StringUtils.isNotNull(tWarehousebills.getfId())) {
  1468. fPid = tWarehousebills.getfId();
  1469. tWarehousebills.setUpdateTime(new Date());
  1470. tWarehousebills.setUpdateBy(loginUser.getUser().getUserName());
  1471. tWarehouseBillsMapper.updateTWarehousebills(tWarehousebills);
  1472. tWarehousebillsfeesMapper.deleteByFPid(fPid);
  1473. tWarehousebillsitemsMapper.deleteByFPid(fPid);
  1474. } else {
  1475. // 生成流水号
  1476. Date time = new Date();
  1477. String billNo = billnoSerialServiceImpl.getSerialNumber("JSCCF", time);
  1478. tWarehousebills.setfBillno(billNo);
  1479. tWarehousebills.setfDeptid(loginUser.getUser().getDeptId());
  1480. tWarehousebills.setfBsdeptid(loginUser.getUser().getDeptId());
  1481. tWarehousebills.setCreateBy(loginUser.getUser().getUserName());
  1482. tWarehousebills.setCreateTime(new Date());
  1483. tWarehousebills.setfBilltype(billsType);
  1484. tWarehouseBillsMapper.insertTWarehousebills(tWarehousebills);
  1485. fPid = tWarehousebills.getfId();
  1486. }
  1487. JSONArray warehouseJSON = JSONArray.parseArray(warehouseItems);
  1488. List<TWarehousebillsfees> itemsList = JSONObject.parseArray(warehouseJSON.toJSONString(), TWarehousebillsfees.class);
  1489. for (TWarehousebillsfees item : itemsList) {
  1490. item.setfId(null);
  1491. item.setSrcBillNo(tWarehousebills.getfBillno());
  1492. item.setfPid(fPid);
  1493. item.setfBillstatus(tWarehousebills.getfBillstatus());
  1494. tWarehousebillsfeesMapper.insertTWarehousebillsfees(item);
  1495. }
  1496. if (StringUtils.isNotNull(warehouseFees) && !"[]".equals(warehouseFees)) {
  1497. JSONArray feesJSON = JSONArray.parseArray(warehouseFees);
  1498. List<TWarehousebillsfees> warehousebillsfeesList = JSONObject.parseArray(feesJSON.toJSONString(), TWarehousebillsfees.class);
  1499. for (TWarehousebillsfees fees : warehousebillsfeesList) {
  1500. fees.setfId(null);
  1501. fees.setfPid(fPid);
  1502. fees.setfDc("D");
  1503. fees.setfBilltype("JSCCF");
  1504. fees.setSrcBillNo(tWarehousebills.getfBillno());
  1505. fees.setfBillstatus(tWarehousebills.getfBillstatus());
  1506. tWarehousebillsfeesMapper.insertTWarehousebillsfees(fees);
  1507. }
  1508. }
  1509. if (billstatus) {
  1510. String key = "warehouse.storageFeeCalculation.ApprovalFlow";
  1511. SysConfig sysConfig = sysConfigMapper.checkConfigKeyUnique(key);
  1512. if (StringUtils.isNull(sysConfig)) {
  1513. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  1514. return AjaxResult.error("系统参数异常,未找到开启审批流参数");
  1515. }
  1516. if ("0".equals(sysConfig.getConfigValue())) {
  1517. AuditItems auditItems = new AuditItems();
  1518. auditItems.setLevelId(0L);
  1519. auditItems.setBillId(fPid);
  1520. auditItems.setActId(150L);
  1521. auditItems.setIffinalItem("F");
  1522. auditItems.setBillNo(tWarehousebills.getfBillno());
  1523. // 存储委托方(货权方)
  1524. auditItems.setRefno1(tWarehousebills.getfCorpid() + "");
  1525. // 存储业务类型(业务类型)
  1526. auditItems.setRefno2(tWarehousebills.getfBilltype());
  1527. // 存储提单号(提单号)
  1528. auditItems.setRefno3(tWarehousebills.getfMblno());
  1529. auditItems.setSendUserId(loginUser.getUser().getUserId());
  1530. auditItems.setSendName(loginUser.getUsername());
  1531. auditItems.setSendTime(new Date());
  1532. auditItems.setAuditUserId(loginUser.getUser().getUserId());
  1533. auditItems.setAuditItem(new Date());
  1534. auditItems.setAuditOpTime(new Date());
  1535. auditItems.setAuditMsg("提交");
  1536. auditItems.setAuditStatus("O");
  1537. AjaxResult approvalFlow = auditItemsService.createApprovalFlow(auditItems);
  1538. String code = approvalFlow.get("code").toString();
  1539. // Long code = Long.valueOf(String.valueOf(ajaxResult.get("code"))).longValue();
  1540. if ("500".equals(code)) {
  1541. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  1542. }
  1543. return approvalFlow;
  1544. } else {
  1545. AjaxResult ajaxResult = storageFeeFollow(fPid, 6L);
  1546. String code = ajaxResult.get("code").toString();
  1547. // Long code = Long.valueOf(String.valueOf(ajaxResult.get("code"))).longValue();
  1548. if ("500".equals(code)) {
  1549. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  1550. }
  1551. return ajaxResult;
  1552. }
  1553. }
  1554. return AjaxResult.success(tWarehousebills);
  1555. }
  1556. /**
  1557. * 根据id查询仓储费计算信息
  1558. *
  1559. * @param fId
  1560. * @return
  1561. */
  1562. @Override
  1563. public AjaxResult selectStorageFeeById(Long fId) {
  1564. TWarehouseBills tWarehouseBills = tWarehouseBillsMapper.selectTWarehousebillsById(fId);
  1565. if (StringUtils.isNull(tWarehouseBills)) {
  1566. return AjaxResult.error("未找到信息,请刷新页面重试");
  1567. }
  1568. Map<String, Object> map = new HashMap<>();
  1569. List<TWarehousebillsfees> feesList = new ArrayList<>();
  1570. List<TWarehousebillsfees> itemsList = new ArrayList<>();
  1571. TWarehousebillsfees warehousebillsfees = new TWarehousebillsfees();
  1572. warehousebillsfees.setfPid(fId);
  1573. List<TWarehousebillsfees> warehouseFeesList = tWarehousebillsfeesMapper.selectTWarehousebillsfeesList(warehousebillsfees);
  1574. for (TWarehousebillsfees fees : warehouseFeesList) {
  1575. if (StringUtils.isNotNull(fees.getSrcId())) {
  1576. itemsList.add(fees);
  1577. } else {
  1578. feesList.add(fees);
  1579. }
  1580. }
  1581. TGoods tGoods = new TGoods();
  1582. tGoods.setfStatus("0");
  1583. tGoods.setDelFlag("0");
  1584. List<TGoods> goods = tGoodsMapper.selectTGoodsList(tGoods);
  1585. TFees tFees = new TFees();
  1586. tFees.setfStatus("2");
  1587. tFees.setDelFlag("0");
  1588. List<TFees> feesLists = tFeesMapper.selectTFeesList(tFees);
  1589. // 查询联系人
  1590. List<SysUser> sysUserList = new ArrayList<>();
  1591. SysUser sysUser = sysUserMapper.selectUserByUserName(tWarehouseBills.getCreateBy());
  1592. if (StringUtils.isNotNull(sysUser)) {
  1593. sysUserList.add(sysUser);
  1594. }
  1595. TCorps corps = tCorpsMapper.selectTCorpsById(tWarehouseBills.getfCorpid());
  1596. map.put("corps", corps);
  1597. map.put("goodsList", goods);
  1598. map.put("feesList", feesLists);
  1599. map.put("sysUser", sysUserList);
  1600. map.put("warehouse", tWarehouseBills);
  1601. map.put("warehouseFeesList", feesList);
  1602. map.put("warehouseItemsList", itemsList);
  1603. return AjaxResult.success(map);
  1604. }
  1605. /**
  1606. * 根据不同计费单位获取不同 计算库存明细数量
  1607. *
  1608. * @param item 库存明细
  1609. * @param dictLabel 计费单位
  1610. * @return 结果
  1611. */
  1612. public BigDecimal acquiredQuantity(Map<String, Object> item, Long dictLabel) {
  1613. BigDecimal fQty = new BigDecimal(0);
  1614. // 件数
  1615. long boxNum = 1;
  1616. // 毛重
  1617. long grossWeight = 2;
  1618. // 净重
  1619. long netWeight = 3;
  1620. // 尺码
  1621. long size = 4;
  1622. // 统一
  1623. long fixed = 5;
  1624. if (dictLabel.equals(boxNum)) {
  1625. fQty = new BigDecimal(((Number) item.get("fQty")).doubleValue());
  1626. return fQty.setScale(2, BigDecimal.ROUND_HALF_UP);
  1627. } else if (dictLabel.equals(grossWeight)) {
  1628. fQty = new BigDecimal(((Number) item.get("fGrossweight")).doubleValue());
  1629. } else if (dictLabel.equals(netWeight)) {
  1630. fQty = new BigDecimal(((Number) item.get("fNetweight")).doubleValue());
  1631. } else if (dictLabel.equals(size)) {
  1632. fQty = new BigDecimal(((Number) item.get("fVolumn")).doubleValue());
  1633. } else if (dictLabel.equals(fixed)) {
  1634. fQty = new BigDecimal(1);
  1635. }
  1636. //return fQty.setScale(2, BigDecimal.ROUND_HALF_UP);
  1637. // 结果值除以1000 保留两位
  1638. BigDecimal divisor = new BigDecimal("1000");
  1639. BigDecimal result = fQty.divide(divisor, 2, BigDecimal.ROUND_HALF_UP);
  1640. return result;
  1641. }
  1642. // 入库 收费明细 校验
  1643. public Long check(BigDecimal number, BigDecimal unitPrice) {
  1644. BigDecimal result1 = number.multiply(unitPrice);
  1645. // 保留两位小数且四舍五入
  1646. result1 = result1.setScale(2, BigDecimal.ROUND_HALF_UP);
  1647. // 转换去掉小数点
  1648. String result = result1.toString().replace(".", "");
  1649. return Long.valueOf(result);
  1650. }
  1651. /**
  1652. * 修改详情主表
  1653. *
  1654. * @param tWarehousebills 详情主表
  1655. * @return 结果
  1656. */
  1657. @Override
  1658. public int updateTWarehousebills(TWarehouseBills tWarehousebills) {
  1659. tWarehousebills.setUpdateTime(DateUtils.getNowDate());
  1660. return tWarehouseBillsMapper.updateTWarehousebills(tWarehousebills);
  1661. }
  1662. /**
  1663. * 批量删除详情主表
  1664. *
  1665. * @param fIds 需要删除的详情主表ID
  1666. * @return 结果
  1667. */
  1668. @Override
  1669. public int deleteTWarehousebillsByIds(Long[] fIds) {
  1670. // 取出业务编号、 放入 billno_del
  1671. for (Long id : fIds) {
  1672. // 1、查询主表信息
  1673. TWarehouseBills tWarehousebills = tWarehouseBillsMapper.selectTWarehousebillsById(id);
  1674. // 2、业务编号、客存编号 放入 billno_del
  1675. BillnoDel billnoDel = new BillnoDel();
  1676. billnoDel.setBillType(tWarehousebills.getfBilltype());
  1677. billnoDel.setBillNo(tWarehousebills.getfBillno());
  1678. billnoDelMapper.insertBillnoDel(billnoDel);
  1679. }
  1680. return tWarehouseBillsMapper.deleteTWarehousebillsByIds(fIds);
  1681. }
  1682. @Override
  1683. public AjaxResult queryRemove(Long fId) {
  1684. // 查询主表明细
  1685. TWarehouseBills tWarehousebills = tWarehouseBillsMapper.selectTWarehousebillsById(fId);
  1686. // 查询仓库明细从表数据
  1687. TWarehousebillsitems tWarehousebillsitems = new TWarehousebillsitems();
  1688. tWarehousebillsitems.setfPid(tWarehousebills.getfId());
  1689. List<Map<String, Object>> mapList = tWarehousebillsitemsMapper.selectGoodsTransferitemsList(tWarehousebillsitems);
  1690. // 查询仓库费用明细表数据
  1691. TWarehousebillsfees tWarehousebillsfees = new TWarehousebillsfees();
  1692. tWarehousebillsfees.setfPid(tWarehousebills.getfId());
  1693. List<TWarehousebillsfees> warehousebillsfees = tWarehousebillsfeesMapper.selectTWarehousebillsfeesList(tWarehousebillsfees);
  1694. // 查询附件表数据
  1695. TEnclosure enclosure = new TEnclosure();
  1696. enclosure.setfPid(tWarehousebills.getfId());
  1697. List<TEnclosure> enclosures = tEnclosureMapper.selectTEnclosureList(enclosure);
  1698. if (StringUtils.isNull(tWarehousebills)) {
  1699. return AjaxResult.success("0");
  1700. } else if (StringUtils.isNotNull(tWarehousebills)
  1701. && StringUtils.isEmpty(warehousebillsfees)
  1702. && StringUtils.isEmpty(enclosures)
  1703. && StringUtils.isEmpty(mapList)) {
  1704. return AjaxResult.success("1");
  1705. } else {
  1706. return AjaxResult.success("2");
  1707. }
  1708. }
  1709. /**
  1710. * 删除详情主表信息
  1711. *
  1712. * @param fId 详情主表ID
  1713. * @return 结果
  1714. */
  1715. @Override
  1716. public int deleteTWarehousebillsById(Long fId) {
  1717. return tWarehouseBillsMapper.deleteTWarehousebillsById(fId);
  1718. }
  1719. @Override
  1720. public String getWarehouseInStockBillsNo(TWarehouseBills tWarehouseBills) {
  1721. return null;
  1722. }
  1723. @Override
  1724. public String getWarehouseOutStockBillsNo(TWarehouseBills tWarehouseBills) {
  1725. return null;
  1726. }
  1727. /**
  1728. * 撤销入库
  1729. *
  1730. * @param fId
  1731. * @param loginUser
  1732. * @param billsType
  1733. * @return
  1734. */
  1735. @Override
  1736. @Transactional
  1737. public AjaxResult revokeTWarehousebillsById(Long fId, LoginUser loginUser, String billsType) {
  1738. // 查询 仓库主表信息、库存明细信息
  1739. TWarehouseBills tWarehousebills = tWarehouseBillsMapper.selectTWarehousebillsById(fId);
  1740. // 修改主表信息
  1741. tWarehousebills.setUpdateBy(loginUser.getUser().getUserName());
  1742. tWarehousebills.setUpdateTime(new Date());
  1743. tWarehousebills.setfBillstatus(2L); //撤销状态
  1744. tWarehousebills.setfReviewDate(null);// 审核通过时间清空
  1745. tWarehouseBillsMapper.updateTWarehousebills(tWarehousebills);
  1746. tWarehousebillsfeesMapper.warehouseFeesFollowUpdate(tWarehousebills.getfId(), 2L, new Date());
  1747. if ("JSCCF".equals(tWarehousebills.getfBilltype())) {
  1748. List<TWarehousebillsfees> feesList = tWarehousebillsfeesMapper.selectWarehousebillsfeesByPId(fId);
  1749. for (TWarehousebillsfees wareItem : feesList) {
  1750. if (StringUtils.isNull(wareItem.getSrcId())) {
  1751. continue;
  1752. }
  1753. if ("KCZZ".equals(wareItem.getfBilltype())) {
  1754. TWhgenleg whgenleg = new TWhgenleg();
  1755. whgenleg.setfId(wareItem.getSrcId());
  1756. whgenleg.setfChargedate(wareItem.getfChargedate());
  1757. int i = tWhgenlegMapper.updateTWhgenleg(whgenleg);
  1758. if (i <= 0) {
  1759. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  1760. return AjaxResult.error("更新库存费用状态失败,请联系管理员");
  1761. }
  1762. } else {
  1763. TWarehousebillsitems billsItem = new TWarehousebillsitems();
  1764. billsItem.setfId(wareItem.getSrcId());
  1765. billsItem.setfBilltype(wareItem.getfBilltype());
  1766. if (!"SJCK".equals(wareItem.getfBilltype())) {
  1767. billsItem.setfChargedate(wareItem.getfBillingDeadline());
  1768. tWarehousebillsitemsMapper.updateTWarehousebillsitems(billsItem);
  1769. } else {
  1770. billsItem.setfChargedate(wareItem.getfChargedate());
  1771. }
  1772. tWarehousebillsitemsMapper.agreementApprovalRejected(billsItem);
  1773. }
  1774. }
  1775. }
  1776. return AjaxResult.success();
  1777. }
  1778. /**
  1779. * 撤销入账
  1780. *
  1781. * @param warehouseBills 主表
  1782. * @param warehousebillsitems 明细
  1783. * @param loginUser 当前登录人
  1784. * @param billsType 状态
  1785. * @return 结果
  1786. */
  1787. @Override
  1788. @Transactional
  1789. public AjaxResult revokeTWarehousebillsById1(String warehouseBills, String warehousebillsitems, String tEnclosure,
  1790. String warehousebillsfeesCr, String warehousebillsfeesDr, LoginUser loginUser, String billsType) {
  1791. if (StringUtils.isNull(warehouseBills) || "[]".equals(warehouseBills)) {
  1792. return AjaxResult.error("未找到主表信息");
  1793. }
  1794. if (StringUtils.isNull(warehousebillsitems) || "[]".equals(warehousebillsitems)) {
  1795. return AjaxResult.error("未找到入账信息");
  1796. }
  1797. TWarehouseBills tWarehousebills = JSONArray.parseObject(warehouseBills, TWarehouseBills.class);
  1798. tWarehousebills.setfItemsStatus(1L); //撤销状态
  1799. tWarehouseBillsMapper.updateTWarehousebills(tWarehousebills);
  1800. tEnclosureMapper.deleteByFPid(tWarehousebills.getfId());
  1801. tWarehousebillsfeesMapper.deleteByFPid(tWarehousebills.getfId());
  1802. JSONArray warehouseJSON = JSONArray.parseArray(warehousebillsitems);
  1803. List<TWarehousebillsitems> warehousebillsitemsList = JSONObject.parseArray(warehouseJSON.toJSONString(), TWarehousebillsitems.class);
  1804. if (StringUtils.isNotEmpty(warehousebillsitemsList)) {
  1805. int i = 1;
  1806. for (TWarehousebillsitems wb : warehousebillsitemsList) {
  1807. // 查询库存总账
  1808. TWhgenleg tWhgenle = queryTWhgenleg(tWarehousebills, wb);
  1809. if ("SJRKRevoke".equals(billsType)) { // 撤销 入库
  1810. if (wb.getfIsInventory().equals(0L)) {
  1811. if (StringUtils.isNotNull(tWhgenle) && (wb.getfQty() <= tWhgenle.getfQtyblc())) { // 非空 且 撤销数 <= 结余数
  1812. updateTWhgenlegData(wb, tWhgenle.getfId(), billsType);
  1813. } else { // 撤销数>结余数
  1814. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  1815. return AjaxResult.error("第" + i + "行撤销数大于库存结余数");
  1816. }
  1817. }
  1818. wb.setfBillstatus(10L);
  1819. } else if ("SJCKRevoke".equals(billsType)) { // 撤销出库
  1820. if (StringUtils.isNotNull(tWhgenle)) { // 非空
  1821. updateTWhgenlegData(wb, tWhgenle.getfId(), billsType);
  1822. } else {
  1823. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  1824. return AjaxResult.error("第" + i + "行未查询到库存信息");
  1825. }
  1826. wb.setfBillstatus(10L);
  1827. } else if ("CKDBRevoke".equals(billsType)) { // 调拨 撤销
  1828. Long warehouselocid = wb.getfWarehouselocid();// 原货仓库
  1829. Long transferWarehouselocid = wb.getfTransferWarehouselocid(); // 新仓库
  1830. // 1、新货权方撤销入库
  1831. // 查询库存总账
  1832. wb.setfWarehouselocid(transferWarehouselocid);
  1833. TWhgenleg tWhgenle1 = queryTWhgenleg(tWarehousebills, wb);
  1834. if (StringUtils.isNotNull(tWhgenle1) && (wb.getfQty() <= tWhgenle1.getfQtyblc())) {
  1835. updateTWhgenlegData(wb, tWhgenle1.getfId(), "SJRKRevoke");
  1836. } else {
  1837. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  1838. return AjaxResult.error("第" + i + "行撤销数大于库存结余数");
  1839. }
  1840. // 2、原货权方撤销出库
  1841. // 查询库存总账
  1842. wb.setfWarehouselocid(warehouselocid);
  1843. TWhgenleg tWhgenle2 = queryTWhgenleg(tWarehousebills, wb);
  1844. updateTWhgenlegData(wb, tWhgenle2.getfId(), "SJCKRevoke");
  1845. wb.setfBillstatus(10L);
  1846. } else if ("HQZYRevoke".equals(billsType)) { // 货转撤销
  1847. Long fCorpid = tWarehousebills.getfCorpid();// 原货权方
  1848. Long fTocorpid = tWarehousebills.getfTocorpid(); // 新货权方
  1849. // 1、新货权方撤销入库
  1850. // 查询库存总账
  1851. tWarehousebills.setfCorpid(fTocorpid);
  1852. TWhgenleg tWhgenle1 = queryTWhgenleg(tWarehousebills, wb);
  1853. if (StringUtils.isNotNull(tWhgenle1) && (wb.getfQty() <= tWhgenle1.getfQtyblc())) {
  1854. updateTWhgenlegData(wb, tWhgenle1.getfId(), "SJRKRevoke");
  1855. } else {
  1856. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  1857. return AjaxResult.error("第" + i + "行撤销数大于库存结余数");
  1858. }
  1859. // 2、原货权方撤销出库
  1860. // 查询库存总账
  1861. tWarehousebills.setfCorpid(fCorpid);
  1862. TWhgenleg tWhgenle2 = queryTWhgenleg(tWarehousebills, wb);
  1863. updateTWhgenlegData(wb, tWhgenle2.getfId(), "SJCKRevoke");
  1864. wb.setfBillstatus(1L);
  1865. }
  1866. i++;
  1867. wb.setUpdateBy(loginUser.getUser().getUserName());
  1868. wb.setUpdateTime(new Date());
  1869. if (tWarehousebillsitemsMapper.updateTWarehousebillsitems(wb) <= 0) {
  1870. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  1871. return AjaxResult.error("新增库存明细失败");
  1872. }
  1873. }
  1874. }
  1875. // 附件添加
  1876. if (StringUtils.isNotEmpty(tEnclosure) && !"[]".equals(tEnclosure)) {
  1877. JSONArray jsonDrArray = JSONArray.parseArray(tEnclosure);
  1878. List<TEnclosure> tEnclosureList = JSONObject.parseArray(jsonDrArray.toJSONString(), TEnclosure.class);
  1879. for (TEnclosure enclosure : tEnclosureList) {
  1880. enclosure.setfPid(tWarehousebills.getfId());
  1881. enclosure.setCreateBy(loginUser.getUser().getUserName());
  1882. enclosure.setCreateTime(new Date());
  1883. tEnclosureMapper.insertTEnclosure(enclosure);
  1884. }
  1885. }
  1886. // 收款明细添加
  1887. if (StringUtils.isNotEmpty(warehousebillsfeesDr) && !"[]".equals(warehousebillsfeesDr)) {
  1888. JSONArray jsonDrArray = JSONArray.parseArray(warehousebillsfeesDr);
  1889. List<TWarehousebillsfees> warehousebillsfeesDrList = JSONObject.parseArray(jsonDrArray.toJSONString(), TWarehousebillsfees.class);
  1890. for (TWarehousebillsfees wbDr : warehousebillsfeesDrList) {
  1891. wbDr.setfPid(tWarehousebills.getfId());
  1892. wbDr.setfDc("D");
  1893. wbDr.setCreateBy(loginUser.getUser().getUserName());
  1894. wbDr.setCreateTime(new Date());
  1895. if (tWarehousebills.getfBsdate() != null && !tWarehousebills.getfBsdate().equals("")) {
  1896. wbDr.setfBsdate(tWarehousebills.getfBsdate());
  1897. }
  1898. tWarehousebillsfeesMapper.insertTWarehousebillsfees(wbDr);
  1899. }
  1900. }
  1901. // 付款明细添加
  1902. if (StringUtils.isNotNull(warehousebillsfeesCr) && !"[]".equals(warehousebillsfeesCr)) {
  1903. JSONArray jsonCrArray = JSONArray.parseArray(warehousebillsfeesCr);
  1904. List<TWarehousebillsfees> warehousebillsfeesCrList = JSONObject.parseArray(jsonCrArray.toJSONString(), TWarehousebillsfees.class);
  1905. for (TWarehousebillsfees wbCr : warehousebillsfeesCrList) {
  1906. wbCr.setfPid(tWarehousebills.getfId());
  1907. wbCr.setfDc("C");
  1908. wbCr.setCreateBy(loginUser.getUser().getUserName());
  1909. wbCr.setCreateTime(new Date());
  1910. if (tWarehousebills.getfBsdate() != null && !tWarehousebills.getfBsdate().equals("")) {
  1911. wbCr.setfBsdate(tWarehousebills.getfBsdate());
  1912. }
  1913. tWarehousebillsfeesMapper.insertTWarehousebillsfees(wbCr);
  1914. }
  1915. }
  1916. return AjaxResult.success();
  1917. }
  1918. /**
  1919. * 添加 库存明细状态
  1920. *
  1921. * @param wbItem
  1922. * @param status
  1923. * @param loginUser
  1924. */
  1925. public void insertTWarehousebillsLog(TWarehousebillsitems wbItem, Long status, LoginUser loginUser) {
  1926. // 添加状态log
  1927. TWarehousebillsLog tWarehousebillsLog = new TWarehousebillsLog();
  1928. tWarehousebillsLog.setfPid(wbItem.getfPid());
  1929. tWarehousebillsLog.setfItmeid(wbItem.getfId());
  1930. tWarehousebillsLog.setfItmestatus(status);
  1931. tWarehousebillsLog.setCreateTime(new Date());
  1932. tWarehousebillsLog.setCreateBy(loginUser.getUser().getUserName());
  1933. tWarehousebillsLogMapper.insertTWarehousebillsLog(tWarehousebillsLog);
  1934. }
  1935. /**
  1936. * 删除 库存明细
  1937. *
  1938. * @param fid
  1939. * @param tWarehousebillsitems
  1940. */
  1941. public void deleteBillsitems(Long fid, String tWarehousebillsitems) {
  1942. List<Long> oldList = new ArrayList<Long>();
  1943. List<Long> newList = new ArrayList<Long>();
  1944. // 查询所有从表数据
  1945. TWarehousebillsitems tWarehousebillsitem = new TWarehousebillsitems();
  1946. tWarehousebillsitem.setfPid(fid);
  1947. List<TWarehousebillsitems> warehousebillsitemsList = tWarehousebillsitemsMapper.selectTWarehousebillsitemsList(tWarehousebillsitem);
  1948. warehousebillsitemsList.forEach(wb ->
  1949. oldList.add(wb.getfId())
  1950. );
  1951. // 获取提交从表数据ID
  1952. if (tWarehousebillsitems != null) {
  1953. JSONArray warehouseJSON = JSONArray.parseArray(tWarehousebillsitems);
  1954. List<TWarehousebillsitems> warehousebillsitemsLists = JSONObject.parseArray(warehouseJSON.toJSONString(), TWarehousebillsitems.class);
  1955. warehousebillsitemsLists.forEach(wb ->
  1956. newList.add(wb.getfId())
  1957. );
  1958. }
  1959. // 删除多余的ID
  1960. List<Long> reduce1 = oldList.stream().filter(item -> !newList.contains(item)).collect(toList());
  1961. reduce1.forEach(id ->
  1962. tWarehousebillsitemsMapper.deleteTWarehousebillsitemsById(id)
  1963. );
  1964. }
  1965. /**
  1966. * 库容-结余毛重
  1967. *
  1968. * @param fTotalgross
  1969. * @param fGrossweightblc
  1970. * @return
  1971. */
  1972. public static BigDecimal calculation1(String fTotalgross, String fGrossweightblc) {
  1973. BigDecimal num1 = new BigDecimal(fTotalgross);
  1974. BigDecimal num2 = new BigDecimal(fGrossweightblc);
  1975. BigDecimal result = num1.subtract(num2);
  1976. return result.setScale(2, BigDecimal.ROUND_HALF_UP);
  1977. }
  1978. /**
  1979. * 判断 是否允许 入库
  1980. *
  1981. * @param fId
  1982. */
  1983. public int calculation(Long fId, BigDecimal fGrossweight) {
  1984. // 仓库库容
  1985. TWarehouse tWarehouse = tWarehouseMapper.selectTWarehouseById(fId);
  1986. // 毛重公斤转化为吨
  1987. fGrossweight = fGrossweight.divide(new BigDecimal(1000), 0, BigDecimal.ROUND_HALF_UP);
  1988. // 总账使用
  1989. List<Map<String, Object>> whouseList = tWhgenlegMapper.selectWareHouseListWhouse(fId);
  1990. if (whouseList != null && whouseList.size() > 0) {
  1991. String fTotalgross = null;
  1992. String fGrossweightblc = null;
  1993. for (Map<String, Object> m : whouseList) {
  1994. for (String k : m.keySet()) {
  1995. // 获取毛重库容
  1996. if (k.equals("fTotalgross")) {
  1997. fTotalgross = m.get(k).toString();
  1998. }
  1999. if (k.equals("fGrossweightD")) {
  2000. fGrossweightblc = m.get(k).toString();
  2001. }
  2002. }
  2003. }
  2004. BigDecimal result = calculation1(fTotalgross, fGrossweightblc);
  2005. if (result.compareTo(fGrossweight) == -1) {
  2006. return 0;// 结余库容小于入库数
  2007. } else {
  2008. return 1;
  2009. }
  2010. } else {
  2011. if(tWarehouse.getfTotalgross()!=null){
  2012. if (tWarehouse.getfTotalgross().compareTo(fGrossweight) == -1) {
  2013. return 0;// 库容小于入库数
  2014. } else {
  2015. return 1;
  2016. }
  2017. }else {
  2018. return 0;// 库容小于入库数
  2019. }
  2020. }
  2021. }
  2022. }