TWarehouseBillsServiceImpl.java 98 KB

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