WarehouseBillsCcbServiceImpl.java 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363
  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.utils.DateUtils;
  12. import com.ruoyi.reportManagement.domain.TWhgenleg;
  13. import com.ruoyi.reportManagement.mapper.TWhgenlegMapper;
  14. import com.ruoyi.system.mapper.SysDictDataMapper;
  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. private final SysDictDataMapper sysDictData;
  47. @Override
  48. @Transactional(rollbackFor = Exception.class)
  49. public AjaxResult inAndOutStock(String billType, List<TWarehousebillsitems> items) {
  50. for (TWarehousebillsitems item : items) {
  51. // 获取客户信息
  52. TCorps corp = corpMapper.getCorpByName(item.getCargoBelong());
  53. if (ObjectUtil.isNull(corp)) {
  54. return AjaxResult.error("客户不存在!");
  55. }
  56. TGoods goods = goodsMapper.getGoodsByNo(item.getCargoNo());
  57. TGoods goods1 = new TGoods();
  58. if (ObjectUtil.isNull(goods)) {
  59. String type = "";
  60. if (item.getType().contains("橡胶")) {
  61. type = "橡胶";
  62. } else if (item.getType().contains("棉花")) {
  63. type = "棉花";
  64. } else if (item.getType().contains("钢铁")) {
  65. type = "钢铁";
  66. } else {
  67. type = "无";
  68. }
  69. String dictValue = sysDictData.selectDictValue("data_goods_category", type);
  70. if (ObjectUtil.isNotNull(dictValue)) {
  71. goods1.setfTypeid(Long.getLong(dictValue));
  72. } else {
  73. goods1.setfTypeid(999l);
  74. }
  75. goods1.setfName(item.getCargoName());
  76. goods1.setfNo(item.getCargoNo());
  77. goodsMapper.insertTGoods(goods1);
  78. } else {
  79. goods1.setfId(goods.getfId());
  80. }
  81. // 初始化数据
  82. Date bsDate = new Date();
  83. String billNo = serialServiceImpl.getBillNo(billType, bsDate);
  84. String dateChanged = DateUtils.getTimestamp(bsDate).toString() + (int) (Math.random() * 900) + 100;
  85. Long billId;
  86. // 组装主表数据
  87. TWarehouseBills bill = new TWarehouseBills();
  88. bill.setfDeptid(100L);
  89. bill.setCreateBy("CCB");
  90. bill.setfStorekeeper("CCB");
  91. bill.setfContacts("CCB");
  92. bill.setfIfdamage("1");
  93. bill.setfIfweigh("1");
  94. bill.setfChargetype("1");
  95. bill.setfStltypeid(1L);
  96. if ("1".equals(item.getfSealno())) {
  97. bill.setfTrademodeid(273L);
  98. } else {
  99. bill.setfTrademodeid(1L);
  100. }
  101. bill.setfGoodsid(goods1.getfId());
  102. bill.setfPlanqty(item.getfPlanqty());
  103. bill.setfPlangrossweight(item.getfPlangrossweight());
  104. bill.setfPlannetweight(item.getfPlannetweight());
  105. bill.setfPlanvolumn(BigDecimal.ZERO);
  106. bill.setfQty(item.getfQty());
  107. bill.setfGrossweight(item.getfGrossweight());
  108. bill.setfNetweight(item.getfNetweight());
  109. bill.setfVolumn(BigDecimal.ZERO);
  110. bill.setfBsdeptid(100L);
  111. bill.setfBillno(billNo);
  112. bill.setfCorpid(corp.getfId());
  113. bill.setfShipper(corp.getfCname());
  114. bill.setfStltypeid(corp.getfStltypeid());
  115. bill.setfBillingway(2L);
  116. bill.setfTrademodeid(1L);
  117. bill.setfMblno(item.getfMblno());
  118. bill.setfBilltype(billType);
  119. bill.setCreateTime(bsDate);
  120. bill.setfDateChanged(dateChanged);
  121. bill.setfBillstatus(2L);
  122. bill.setfItemsStatus(2L);
  123. bill.setfBsdate(bsDate);
  124. bill.setfBstime(bsDate);
  125. bill.setfProductName(item.getCargoName());
  126. if ("SJRK".equals(billType)) {
  127. String bsCorpNo = serialServiceImpl.getCorpNo(corp.getfId(), bsDate);
  128. bill.setfBscorpno(bsCorpNo);
  129. bill.setfBusinessType("0");
  130. } else {
  131. /* TWarehouse warehouse = warehouseMapper.getWarehouseByNo(item.getWarehouseNo());
  132. if (ObjectUtil.isNull(warehouse)) {
  133. return AjaxResult.error("仓库不存在!");
  134. }
  135. bill.setfWarehouseid(warehouse.getfId());*/
  136. bill.setfChargedate(bsDate);
  137. bill.setfBusinessType("5");
  138. }
  139. bill.setRemark(item.getCargoName());
  140. billMapper.insertTWarehousebills(bill);
  141. billId = bill.getfId();
  142. // 从表数据处理
  143. item.setfGoodsid(goods1.getfId());
  144. item.setfPid(billId);
  145. item.setfBillno(billNo);
  146. item.setfShipper(bill.getfShipper());
  147. item.setfBilltype(billType);
  148. item.setCreateBy("CCB");
  149. item.setCreateTime(bsDate);
  150. item.setfBsdate(bill.getfBsdate());
  151. item.setfBusinessType(1L);
  152. if ("SJCK".equals(billType)) {
  153. /* TWarehouse warehouse = warehouseMapper.getWarehouseByNo(item.getShelvesNo());
  154. if (ObjectUtil.isNull(warehouse)) {
  155. return AjaxResult.error("库区不存在!");
  156. }
  157. item.setfWarehouselocid(warehouse.getfId());
  158. item.setfWarehouseInformation(warehouse.getfWarehouseInformation());
  159. TWhgenleg temp = new TWhgenleg();
  160. temp.setfCorpid(bill.getfCorpid());
  161. temp.setfMblno(item.getfMblno());
  162. temp.setfWarehouseLocationid(item.getfWarehouselocid());
  163. temp.setfTrademodeid(bill.getfTrademodeid());
  164. temp.setfGoodsid(item.getfGoodsid());
  165. temp.setfLocation(1L);
  166. TWhgenleg stock = stockMapper.selectTWhgenleg(temp);
  167. if (ObjectUtil.isNull(stock)) {
  168. return AjaxResult.error("未找到库存!");
  169. }
  170. item.setfSrcid(stock.getfId());
  171. item.setfSrcBsdate(stock.getfBsdate());
  172. item.setfChargedate(stock.getfChargedate());*/
  173. }
  174. billItemMapper.insertTWarehousebillsitems(item);
  175. if ("SJCK".equals(billType)) {
  176. List<String> tags = item.getElectronicTags();
  177. if (CollectionUtil.isNotEmpty(tags)) {
  178. tags.forEach(tag -> {
  179. TWarehousebillsitemsElabel eLabel = new TWarehousebillsitemsElabel();
  180. eLabel.setfGPid(billId);
  181. eLabel.setfPid(item.getfId());
  182. eLabel.setfContent(tag);
  183. eLabel.setfType(2);
  184. eLabel.setCreateBy("CCB");
  185. eLabel.setCreateTime(bsDate);
  186. eLabelMapper.insert(eLabel);
  187. });
  188. }
  189. }
  190. }
  191. return AjaxResult.success();
  192. }
  193. @Override
  194. public List<Map<String, Object>> getStockList(String takeVoucher, String corpName) {
  195. // 获取客户信息
  196. TCorps corp = corpMapper.getCorpByName(corpName);
  197. if (ObjectUtil.isNull(corp)) {
  198. return Collections.emptyList();
  199. }
  200. return stockMapper.selectStockList(takeVoucher, corp.getfId());
  201. }
  202. @Override
  203. public AjaxResult lockStock(String belongTo, List<String> billNoList, boolean isWrNumber) {
  204. billNoList.forEach(billNo -> {
  205. String fOriginalbillno = stockMapper.selectfOriginalbillno(billNo);
  206. TWhgenleg stock = new TWhgenleg();
  207. stock.setfOriginalbillno(billNo);
  208. stock.setLockStatus(1);
  209. stock.setBelongTo(belongTo);
  210. stock.setLockTime(new Date());
  211. if (isWrNumber) {
  212. stock.setWrNumber(fOriginalbillno);
  213. }
  214. stockMapper.changeBelongTo(stock);
  215. });
  216. return AjaxResult.success();
  217. }
  218. @Override
  219. public AjaxResult unlockStock(List<String> billNoList, boolean isWrNumber) {
  220. billNoList.forEach(billNo -> {
  221. TWhgenleg stock = new TWhgenleg();
  222. stock.setfOriginalbillno(billNo);
  223. stock.setLockStatus(0);
  224. stock.setUnlockTime(new Date());
  225. if (isWrNumber) {
  226. stock.setWrNumber("");
  227. }
  228. stockMapper.changeBelongTo(stock);
  229. });
  230. return AjaxResult.success();
  231. }
  232. @Override
  233. public List<Map<String, Object>> getSyncOrg(Integer pageNum, Integer pageSize, String time) {
  234. PageHelper.startPage(pageNum, pageSize);
  235. return corpMapper.getSyncCorpList(time);
  236. }
  237. @Override
  238. public List<String> getLabel(String billNo) {
  239. return eLabelMapper.getLabel(billNo);
  240. }
  241. /**
  242. * 获取库存
  243. *
  244. * @param blNumber 提单号
  245. * @param corpName 客户名
  246. * @param billNo 保管凭证号
  247. * @return 库存列表
  248. */
  249. @Override
  250. public List<Map<String, Object>> selectBlNumber(String blNumber, String corpName, String billNo) {
  251. // 获取客户信息
  252. TCorps corp = corpMapper.getCorpByName(corpName);
  253. //判断该客户是否存在
  254. if (ObjectUtil.isNull(corp)) {
  255. return Collections.emptyList();
  256. }
  257. return stockMapper.selectBlNumber(blNumber, corp.getfId(), billNo);
  258. }
  259. @Override
  260. public List<Map<String, Object>> selectBlNumberPage(String blNumber, String corpName, String billNo, int pageNo, int pageSize) {
  261. // 获取客户信息
  262. TCorps corp = corpMapper.getCorpByName(corpName);
  263. //判断该客户是否存在
  264. if (ObjectUtil.isNull(corp)) {
  265. return Collections.emptyList();
  266. }
  267. return stockMapper.selectBlNumberPage(blNumber, corp.getfId(), billNo, pageNo, pageSize);
  268. }
  269. /**
  270. * 查询用户资产
  271. *
  272. * @param blNumber 提单号
  273. * @param userName 客户名称
  274. * @param wrNumber 仓单编号
  275. * @param cargoType 物料编号
  276. * @return
  277. */
  278. @Override
  279. public List<Map<String, Object>> selectQueryAssets(String blNumber, String userName, String wrNumber, String cargoType) {
  280. // 获取客户信息
  281. TCorps corp = corpMapper.getCorpByName(userName);
  282. //判断该客户是否存在
  283. if (ObjectUtil.isNull(corp)) {
  284. return Collections.emptyList();
  285. }
  286. return stockMapper.selectQueryAssets(blNumber, corp.getfId(), wrNumber, cargoType);
  287. }
  288. /**
  289. * 跌价补货-修改仓单编号以及质押归属人
  290. *
  291. * @param stock 修改信息
  292. * @param userName 客户
  293. * @return 结果
  294. */
  295. @Override
  296. public int cargosRF(TWhgenleg stock, String userName) {
  297. // 获取客户信息
  298. TCorps corp = corpMapper.getCorpByName(userName);
  299. stock.setfCorpid(corp.getfId());
  300. return stockMapper.changeBelongTo(stock);
  301. }
  302. /**
  303. * 锁定库存
  304. *
  305. * @param belongTo 归属人
  306. * @param billNo 提单号
  307. * @param isWrNumber 是否仓单编号请求
  308. * @return 结果
  309. */
  310. @Override
  311. public String generateWrNumber(String belongTo, String billNo, boolean isWrNumber) {
  312. String fOriginalbillno = stockMapper.selectfOriginalbillno(billNo);
  313. TWhgenleg stock = new TWhgenleg();
  314. stock.setfOriginalbillno(billNo);
  315. stock.setLockStatus(1);
  316. stock.setBelongTo(belongTo);
  317. stock.setLockTime(new Date());
  318. if (isWrNumber) {
  319. stock.setWrNumber(fOriginalbillno);
  320. }
  321. stockMapper.changeBelongTo(stock);
  322. return fOriginalbillno;
  323. }
  324. }