WarehouseBillsCcbServiceImpl.java 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313
  1. package com.ruoyi.warehouseBusiness.service.impl;
  2. import cn.hutool.core.collection.CollectionUtil;
  3. import cn.hutool.core.util.ObjectUtil;
  4. import com.github.pagehelper.PageHelper;
  5. import com.ruoyi.basicData.domain.TCorps;
  6. import com.ruoyi.basicData.domain.TGoods;
  7. import com.ruoyi.basicData.mapper.TCorpsMapper;
  8. import com.ruoyi.basicData.mapper.TGoodsMapper;
  9. import com.ruoyi.basicData.mapper.TWarehouseMapper;
  10. import com.ruoyi.common.core.domain.AjaxResult;
  11. import com.ruoyi.common.core.domain.entity.TWarehouse;
  12. import com.ruoyi.common.utils.DateUtils;
  13. import com.ruoyi.reportManagement.domain.TWhgenleg;
  14. import com.ruoyi.reportManagement.mapper.TWhgenlegMapper;
  15. import com.ruoyi.warehouseBusiness.domain.TWarehouseBills;
  16. import com.ruoyi.warehouseBusiness.domain.TWarehousebillsitems;
  17. import com.ruoyi.warehouseBusiness.domain.TWarehousebillsitemsElabel;
  18. import com.ruoyi.warehouseBusiness.mapper.TWarehouseBillsMapper;
  19. import com.ruoyi.warehouseBusiness.mapper.TWarehousebillsitemsElabelMapper;
  20. import com.ruoyi.warehouseBusiness.mapper.TWarehousebillsitemsMapper;
  21. import com.ruoyi.warehouseBusiness.service.IWarehouseBillsCcbService;
  22. import lombok.AllArgsConstructor;
  23. import org.springframework.stereotype.Service;
  24. import org.springframework.transaction.annotation.Transactional;
  25. import java.math.BigDecimal;
  26. import java.util.Collections;
  27. import java.util.Date;
  28. import java.util.List;
  29. import java.util.Map;
  30. /**
  31. * 建行接口实现
  32. *
  33. * @author s
  34. */
  35. @Service
  36. @AllArgsConstructor
  37. public class WarehouseBillsCcbServiceImpl implements IWarehouseBillsCcbService {
  38. private final BillnoSerialServiceImpl serialServiceImpl;
  39. private final TWarehouseBillsMapper billMapper;
  40. private final TWarehousebillsitemsMapper billItemMapper;
  41. private final TWarehousebillsitemsElabelMapper eLabelMapper;
  42. private final TCorpsMapper corpMapper;
  43. private final TGoodsMapper goodsMapper;
  44. private final TWarehouseMapper warehouseMapper;
  45. private final TWhgenlegMapper stockMapper;
  46. @Override
  47. @Transactional(rollbackFor = Exception.class)
  48. public AjaxResult inAndOutStock(String billType, List<TWarehousebillsitems> items) {
  49. for (TWarehousebillsitems item : items) {
  50. // 获取客户信息
  51. TCorps corp = corpMapper.getCorpByName(item.getCargoBelong());
  52. if (ObjectUtil.isNull(corp)) {
  53. return AjaxResult.error("客户不存在!");
  54. }
  55. TGoods goods = goodsMapper.getGoodsByNo(item.getCargoNo());
  56. if (ObjectUtil.isNull(goods)) {
  57. return AjaxResult.error("商品不存在!");
  58. }
  59. // 初始化数据
  60. Date bsDate = new Date();
  61. String billNo = serialServiceImpl.getBillNo(billType, bsDate);
  62. String dateChanged = DateUtils.getTimestamp(bsDate).toString() + (int) (Math.random() * 900) + 100;
  63. Long billId;
  64. // 组装主表数据
  65. TWarehouseBills bill = new TWarehouseBills();
  66. bill.setfDeptid(100L);
  67. bill.setCreateBy("CCB");
  68. bill.setfStorekeeper("CCB");
  69. bill.setfContacts("CCB");
  70. bill.setfIfdamage("1");
  71. bill.setfIfweigh("1");
  72. bill.setfChargetype("1");
  73. bill.setfStltypeid(1L);
  74. if ("1".equals(item.getfSealno())) {
  75. bill.setfTrademodeid(273L);
  76. } else {
  77. bill.setfTrademodeid(1L);
  78. }
  79. bill.setfGoodsid(goods.getfId());
  80. bill.setfPlanqty(item.getfPlanqty());
  81. bill.setfPlangrossweight(item.getfPlangrossweight());
  82. bill.setfPlannetweight(item.getfPlannetweight());
  83. bill.setfPlanvolumn(BigDecimal.ZERO);
  84. bill.setfQty(item.getfQty());
  85. bill.setfGrossweight(item.getfGrossweight());
  86. bill.setfNetweight(item.getfNetweight());
  87. bill.setfVolumn(BigDecimal.ZERO);
  88. bill.setfBsdeptid(100L);
  89. bill.setfBillno(billNo);
  90. bill.setfCorpid(corp.getfId());
  91. bill.setfShipper(corp.getfCname());
  92. bill.setfStltypeid(corp.getfStltypeid());
  93. bill.setfBillingway(2L);
  94. bill.setfTrademodeid(1L);
  95. bill.setfMblno(item.getfMblno());
  96. bill.setfBilltype(billType);
  97. bill.setCreateTime(bsDate);
  98. bill.setfDateChanged(dateChanged);
  99. bill.setfBillstatus(2L);
  100. bill.setfItemsStatus(2L);
  101. bill.setfBsdate(bsDate);
  102. bill.setfBstime(bsDate);
  103. if ("SJRK".equals(billType)) {
  104. String bsCorpNo = serialServiceImpl.getCorpNo(corp.getfId(), bsDate);
  105. bill.setfBscorpno(bsCorpNo);
  106. bill.setfBusinessType("0");
  107. } else {
  108. TWarehouse warehouse = warehouseMapper.getWarehouseByNo(item.getWarehouseNo());
  109. if (ObjectUtil.isNull(warehouse)) {
  110. return AjaxResult.error("仓库不存在!");
  111. }
  112. bill.setfWarehouseid(warehouse.getfId());
  113. bill.setfChargedate(bsDate);
  114. bill.setfBusinessType("5");
  115. }
  116. billMapper.insertTWarehousebills(bill);
  117. billId = bill.getfId();
  118. // 从表数据处理
  119. item.setfGoodsid(goods.getfId());
  120. item.setfPid(billId);
  121. item.setfBillno(billNo);
  122. item.setfShipper(bill.getfShipper());
  123. item.setfBilltype(billType);
  124. item.setCreateBy("CCB");
  125. item.setCreateTime(bsDate);
  126. item.setfBsdate(bill.getfBsdate());
  127. item.setfBusinessType(1L);
  128. if ("SJCK".equals(billType)) {
  129. TWarehouse warehouse = warehouseMapper.getWarehouseByNo(item.getShelvesNo());
  130. if (ObjectUtil.isNull(warehouse)) {
  131. return AjaxResult.error("库区不存在!");
  132. }
  133. item.setfWarehouselocid(warehouse.getfId());
  134. item.setfWarehouseInformation(warehouse.getfWarehouseInformation());
  135. TWhgenleg temp = new TWhgenleg();
  136. temp.setfCorpid(bill.getfCorpid());
  137. temp.setfMblno(item.getfMblno());
  138. temp.setfWarehouseLocationid(item.getfWarehouselocid());
  139. temp.setfTrademodeid(bill.getfTrademodeid());
  140. temp.setfGoodsid(item.getfGoodsid());
  141. temp.setfLocation(1L);
  142. TWhgenleg stock = stockMapper.selectTWhgenleg(temp);
  143. if (ObjectUtil.isNull(stock)) {
  144. return AjaxResult.error("未找到库存!");
  145. }
  146. item.setfSrcid(stock.getfId());
  147. item.setfSrcBsdate(stock.getfBsdate());
  148. item.setfChargedate(stock.getfChargedate());
  149. }
  150. billItemMapper.insertTWarehousebillsitems(item);
  151. if ("SJCK".equals(billType)) {
  152. List<String> tags = item.getElectronicTags();
  153. if (CollectionUtil.isNotEmpty(tags)) {
  154. tags.forEach(tag -> {
  155. TWarehousebillsitemsElabel eLabel = new TWarehousebillsitemsElabel();
  156. eLabel.setfGPid(billId);
  157. eLabel.setfPid(item.getfId());
  158. eLabel.setfContent(tag);
  159. eLabel.setfType(2);
  160. eLabel.setCreateBy("CCB");
  161. eLabel.setCreateTime(bsDate);
  162. eLabelMapper.insert(eLabel);
  163. });
  164. }
  165. }
  166. }
  167. return AjaxResult.success();
  168. }
  169. @Override
  170. public List<Map<String, Object>> getStockList(String takeVoucher, String corpName) {
  171. // 获取客户信息
  172. TCorps corp = corpMapper.getCorpByName(corpName);
  173. if (ObjectUtil.isNull(corp)) {
  174. return Collections.emptyList();
  175. }
  176. return stockMapper.selectStockList(takeVoucher, corp.getfId());
  177. }
  178. @Override
  179. public AjaxResult lockStock(String belongTo, List<String> billNoList, boolean isWrNumber) {
  180. billNoList.forEach(billNo -> {
  181. TWhgenleg stock = new TWhgenleg();
  182. stock.setfOriginalbillno(billNo);
  183. stock.setLockStatus(1);
  184. stock.setBelongTo(belongTo);
  185. stock.setLockTime(new Date());
  186. if (isWrNumber) {
  187. stock.setWrNumber(billNo);
  188. }
  189. stockMapper.changeBelongTo(stock);
  190. });
  191. return AjaxResult.success();
  192. }
  193. @Override
  194. public AjaxResult unlockStock(List<String> billNoList, boolean isWrNumber) {
  195. billNoList.forEach(billNo -> {
  196. TWhgenleg stock = new TWhgenleg();
  197. stock.setfOriginalbillno(billNo);
  198. stock.setLockStatus(0);
  199. stock.setUnlockTime(new Date());
  200. if (isWrNumber) {
  201. stock.setWrNumber("");
  202. }
  203. stockMapper.changeBelongTo(stock);
  204. });
  205. return AjaxResult.success();
  206. }
  207. @Override
  208. public List<Map<String, Object>> getSyncOrg(Integer page, Integer size, String time) {
  209. PageHelper.startPage(page, size);
  210. return corpMapper.getSyncCorpList(time);
  211. }
  212. @Override
  213. public List<String> getLabel(String billNo) {
  214. return eLabelMapper.getLabel(billNo);
  215. }
  216. /**
  217. * 获取库存
  218. *
  219. * @param blNumber 提单号
  220. * @param corpName 客户名
  221. * @param billNo 保管凭证号
  222. * @return 库存列表
  223. */
  224. @Override
  225. public List<Map<String, Object>> selectBlNumber(String blNumber, String corpName,String billNo) {
  226. // 获取客户信息
  227. TCorps corp = corpMapper.getCorpByName(corpName);
  228. //判断该客户是否存在
  229. if (ObjectUtil.isNull(corp)) {
  230. return Collections.emptyList();
  231. }
  232. return stockMapper.selectBlNumber(blNumber, corp.getfId(),billNo);
  233. }
  234. @Override
  235. public List<Map<String, Object>> selectBlNumberPage(String blNumber, String corpName, String billNo, int pageNo, int pageSize) {
  236. // 获取客户信息
  237. TCorps corp = corpMapper.getCorpByName(corpName);
  238. //判断该客户是否存在
  239. if (ObjectUtil.isNull(corp)) {
  240. return Collections.emptyList();
  241. }
  242. return stockMapper.selectBlNumberPage(blNumber, corp.getfId(),billNo,pageNo,pageSize);
  243. }
  244. /**
  245. * 查询用户资产
  246. * @param blNumber 提单号
  247. * @param userName 客户名称
  248. * @param wrNumber 仓单编号
  249. * @param cargoType 物料编号
  250. * @return
  251. */
  252. @Override
  253. public List<Map<String, Object>> selectQueryAssets(String blNumber, String userName, String wrNumber, String cargoType) {
  254. // 获取客户信息
  255. TCorps corp = corpMapper.getCorpByName(userName);
  256. //判断该客户是否存在
  257. if (ObjectUtil.isNull(corp)) {
  258. return Collections.emptyList();
  259. }
  260. return stockMapper.selectQueryAssets(blNumber, corp.getfId(),wrNumber,cargoType);
  261. }
  262. /**
  263. * 跌价补货-修改仓单编号以及质押归属人
  264. * @param stock 修改信息
  265. * @param userName 客户
  266. * @return 结果
  267. */
  268. @Override
  269. public int cargosRF(TWhgenleg stock, String userName) {
  270. // 获取客户信息
  271. TCorps corp = corpMapper.getCorpByName(userName);
  272. stock.setfCorpid(corp.getfId());
  273. return stockMapper.changeBelongTo(stock);
  274. }
  275. }