BillnoSerialServiceImpl.java 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321
  1. package com.ruoyi.warehouseBusiness.service.impl;
  2. import com.ruoyi.basicData.domain.TCorps;
  3. import com.ruoyi.basicData.mapper.TCorpsMapper;
  4. import com.ruoyi.common.utils.StringUtils;
  5. import com.ruoyi.warehouseBusiness.domain.BillnoDel;
  6. import com.ruoyi.warehouseBusiness.domain.BillnoSerial;
  7. import com.ruoyi.warehouseBusiness.mapper.BillnoDelMapper;
  8. import com.ruoyi.warehouseBusiness.mapper.BillnoSerialMapper;
  9. import com.ruoyi.warehouseBusiness.service.IBillnoSerialService;
  10. import org.apache.commons.lang3.time.DateFormatUtils;
  11. import org.springframework.beans.factory.annotation.Autowired;
  12. import org.springframework.stereotype.Service;
  13. import java.util.Date;
  14. import java.util.List;
  15. /**
  16. * 客户存货编号流水号Service业务层处理
  17. *
  18. * @author ruoyi
  19. * @date 2020-12-23
  20. */
  21. @Service
  22. public class BillnoSerialServiceImpl implements IBillnoSerialService {
  23. @Autowired
  24. private TCorpsMapper tCorpsMapper;
  25. @Autowired
  26. private BillnoDelMapper billnoDelMapper;
  27. @Autowired
  28. private BillnoSerialMapper billnoSerialMapper;
  29. /**
  30. * 获取业务编号
  31. *
  32. * @param billType 编号类型(SJRK(入库) SJCK(实际出库) CKDB(调拨) HQZY(货权转移))
  33. * @param time 入库时间
  34. * @return 结果
  35. */
  36. public String getBillNo(String billType, Date time) {
  37. String billNo = null;
  38. BillnoDel billnoDel = new BillnoDel();
  39. billnoDel.setBillType(billType);
  40. List<BillnoDel> billnoDels = billnoDelMapper.selectBillnoDelList(billnoDel);
  41. // 如果有数据在删除列表
  42. if (StringUtils.isNotEmpty(billnoDels)) {
  43. billnoDelMapper.deleteBillnoDelById(billnoDels.get(0).getId());
  44. billNo = billnoDels.get(0).getBillNo();
  45. return billNo;
  46. } else {
  47. String yyyyMM = DateFormatUtils.format(time, "yyyyMM");
  48. BillnoSerial billnoSerial = new BillnoSerial();
  49. billnoSerial.setBillType(billType);
  50. billnoSerial.setBillPrefix(yyyyMM);
  51. BillnoSerial billnoSerials = billnoSerialMapper.selectBillnoSerial(billnoSerial);
  52. if (StringUtils.isNotNull(billnoSerials)) {
  53. billnoSerials.setSerial(billnoSerials.getSerial() + 1);
  54. billnoSerialMapper.updateBillnoSerial(billnoSerials);
  55. if (billnoSerials.getSerial() <= 9) {
  56. billNo = yyyyMM + "00" + billnoSerials.getSerial();
  57. } else if (billnoSerials.getSerial() <= 99) {
  58. billNo = yyyyMM + "0" + billnoSerials.getSerial();
  59. } else if (billnoSerials.getSerial() <= 999) {
  60. billNo = yyyyMM + "" + billnoSerials.getSerial();
  61. }
  62. } else {
  63. billNo = yyyyMM + "001";
  64. billnoSerial.setSerial(1);
  65. billnoSerialMapper.insertBillnoSerial(billnoSerial);
  66. }
  67. }
  68. if ("SJRK".equals(billType)) {
  69. billNo = "RK" + billNo;
  70. } else if ("SJCK".equals(billType)) {
  71. billNo = "CK" + billNo;
  72. } else if ("CKDB".equals(billType)) {
  73. billNo = "DB" + billNo;
  74. } else if ("HQZY".equals(billType)) {
  75. billNo = "HZ" + billNo;
  76. } else if ("WA".equals(billType)) {
  77. billNo = "WA" + billNo;
  78. } else if ("DZ".equals(billType)) {
  79. billNo = "DZ" + billNo;
  80. } else if ("SF".equals(billType)) {
  81. billNo = "SF" + billNo;
  82. } else if ("FF".equals(billType)) {
  83. billNo = "FF" + billNo;
  84. } else if ("SFDZ".equals(billType)) {
  85. billNo = "SFDZ" + billNo;
  86. } else if ("JSSF".equals(billType)) {
  87. billNo = "JSSF" + billNo;
  88. } else if ("JSFF".equals(billType)) {
  89. billNo = "JSFF" + billNo;
  90. } else if ("HWTG".equals(billType)) {
  91. billNo = "HWTG" + billNo;
  92. }else if ("SE".equals(billType)){
  93. billNo = "SE" + billNo;
  94. }else if ("KHDZ".equals(billType)) {
  95. billNo = "KHDZ" + billNo;
  96. } else if ("KHSF".equals(billType)) {
  97. billNo = "KHSF" + billNo;
  98. } else if ("KHFF".equals(billType)) {
  99. billNo = "KHFF" + billNo;
  100. }else if ("ApplyFP".equals(billType)) {
  101. billNo = "ApplyFP" + billNo;
  102. }else if ("invoiceFP".equals(billType)) {
  103. billNo = "invoiceFP" + billNo;
  104. }else if ("INV".equals(billType)) {
  105. billNo = "INV" + billNo;
  106. }
  107. return billNo;
  108. }
  109. /**
  110. * 获取客户存货编号
  111. *
  112. * @param corpId 客户id
  113. * @param time 时间
  114. * @return 结果
  115. */
  116. public String getCorpNo(long corpId, Date time) {
  117. String corpNo = null;
  118. String yyyy = DateFormatUtils.format(time, "yyyy");
  119. TCorps corps = tCorpsMapper.selectTCorpsById(corpId);
  120. corpNo = corps.getfNo() + yyyy;
  121. BillnoSerial billnoSerial = new BillnoSerial();
  122. billnoSerial.setBillType("corpNo");
  123. billnoSerial.setBillPrefix(yyyy);
  124. BillnoSerial billnoSerials = billnoSerialMapper.selectBillnoSerial(billnoSerial);
  125. if (StringUtils.isNotNull(billnoSerials)) {
  126. billnoSerials.setSerial(billnoSerials.getSerial() + 1);
  127. billnoSerialMapper.updateBillnoSerial(billnoSerials);
  128. if (billnoSerials.getSerial() <= 9) {
  129. corpNo = corpNo + "000" + billnoSerials.getSerial();
  130. } else if (billnoSerials.getSerial() <= 99) {
  131. corpNo = corpNo + "00" + billnoSerials.getSerial();
  132. } else if (billnoSerials.getSerial() <= 999) {
  133. corpNo = corpNo + "0" + billnoSerials.getSerial();
  134. } else if (billnoSerials.getSerial() <= 9999) {
  135. corpNo = corpNo + billnoSerials.getSerial();
  136. }
  137. } else {
  138. billnoSerial.setSerial(1);
  139. billnoSerialMapper.insertBillnoSerial(billnoSerial);
  140. corpNo = corpNo + "0001";
  141. }
  142. return corpNo;
  143. }
  144. /**
  145. * 获取入库 出库 流水号
  146. *
  147. * @param billType 编号类型(RK(入库) CK(出库) )
  148. * @param time 入库时间
  149. * @return 结果
  150. */
  151. public String getSerialNumber(String billType, Date time) {
  152. String billNo = null;
  153. String yyMMdd = null;
  154. if ("JH".equals(billType) || "JHBF".equals(billType) || "DDBF".equals(billType) || "JHBGBF".equals(billType)) {
  155. yyMMdd = DateFormatUtils.format(time, "yyyyMMdd");
  156. } else if ("CCF".equals(billType) || "SJLSH".equals(billType)) {
  157. yyMMdd = DateFormatUtils.format(time, "yyMM");
  158. } else {
  159. yyMMdd = DateFormatUtils.format(time, "yyMMdd");
  160. }
  161. if ("RK".equals(billType) || "CK".equals(billType) || "DB".equals(billType)) {
  162. // 流水号 是否有回收
  163. BillnoDel billnoDel = new BillnoDel();
  164. billnoDel.setBillType(billType);
  165. List<BillnoDel> billnoDels = billnoDelMapper.selectBillnoDelList(billnoDel);
  166. // 如果有数据在删除列表
  167. if (StringUtils.isNotEmpty(billnoDels)) {
  168. billnoDelMapper.deleteBillnoDelById(billnoDels.get(0).getId());
  169. billNo = billnoDels.get(0).getBillNo();
  170. return billNo;
  171. }
  172. }
  173. boolean tms = false;
  174. if ("SJLSH".equals(billType)) {
  175. tms = true;
  176. }
  177. BillnoSerial billnoSerial = new BillnoSerial();
  178. billnoSerial.setBillType(billType);
  179. billnoSerial.setBillPrefix(yyMMdd);
  180. BillnoSerial billnoSerials = billnoSerialMapper.selectBillnoSerial(billnoSerial);
  181. if (StringUtils.isNotNull(billnoSerials)) {
  182. if (tms) {
  183. if (billnoSerials.getSerial() <= 9) {
  184. billNo = yyMMdd + "000" + billnoSerials.getSerial();
  185. } else if (billnoSerials.getSerial() <= 99) {
  186. billNo = yyMMdd + "00" + billnoSerials.getSerial();
  187. } else if (billnoSerials.getSerial() <= 999) {
  188. billNo = yyMMdd + "0" + billnoSerials.getSerial();
  189. } else if (billnoSerials.getSerial() <= 9999) {
  190. billNo = yyMMdd + "" + billnoSerials.getSerial();
  191. }
  192. billnoSerials.setSerial(billnoSerials.getSerial() + 1);
  193. billnoSerialMapper.updateBillnoSerial(billnoSerials);
  194. return billNo;
  195. }
  196. if (billnoSerials.getSerial() <= 9) {
  197. billNo = yyMMdd + "00" + billnoSerials.getSerial();
  198. } else if (billnoSerials.getSerial() <= 99) {
  199. billNo = yyMMdd + "0" + billnoSerials.getSerial();
  200. } else if (billnoSerials.getSerial() <= 999) {
  201. billNo = yyMMdd + "" + billnoSerials.getSerial();
  202. }
  203. billnoSerials.setSerial(billnoSerials.getSerial() + 1);
  204. billnoSerialMapper.updateBillnoSerial(billnoSerials);
  205. } else {
  206. billnoSerial.setSerial(2);
  207. if (tms) {
  208. billNo = yyMMdd + "0001";
  209. billnoSerialMapper.insertBillnoSerial(billnoSerial);
  210. return billNo;
  211. }
  212. billNo = yyMMdd + "001";
  213. billnoSerialMapper.insertBillnoSerial(billnoSerial);
  214. }
  215. billNo = billType + billNo;
  216. return billNo;
  217. }
  218. /**
  219. * 获取入库 出库 流水号
  220. *
  221. * @param billType 编号类型(RK(入库) CK(出库) )
  222. * @param time 入库时间
  223. * @return 结果
  224. */
  225. public String getFictitiousNumber(String billType, Date time) {
  226. String billNo = null;
  227. String yyMMdd = DateFormatUtils.format(time, "yyMMdd");
  228. BillnoSerial billnoSerial = new BillnoSerial();
  229. billnoSerial.setBillType(billType);
  230. billnoSerial.setBillPrefix(yyMMdd);
  231. BillnoSerial billnoSerials = billnoSerialMapper.selectBillnoSerial(billnoSerial);
  232. if (StringUtils.isNotNull(billnoSerials)) {
  233. if (billnoSerials.getSerial() <= 9) {
  234. billNo = yyMMdd + "00" + billnoSerials.getSerial();
  235. } else if (billnoSerials.getSerial() <= 99) {
  236. billNo = yyMMdd + "0" + billnoSerials.getSerial();
  237. } else if (billnoSerials.getSerial() <= 999) {
  238. billNo = yyMMdd + "" + billnoSerials.getSerial();
  239. }
  240. } else {
  241. billNo = yyMMdd + "001";
  242. }
  243. billNo = billType + billNo;
  244. return billNo;
  245. }
  246. /**
  247. * 查询客户存货编号流水号
  248. *
  249. * @param id 客户存货编号流水号ID
  250. * @return 客户存货编号流水号
  251. */
  252. @Override
  253. public BillnoSerial selectBillnoSerialById(Long id) {
  254. return billnoSerialMapper.selectBillnoSerialById(id);
  255. }
  256. /**
  257. * 查询客户存货编号流水号列表
  258. *
  259. * @param billnoSerial 客户存货编号流水号
  260. * @return 客户存货编号流水号
  261. */
  262. @Override
  263. public List<BillnoSerial> selectBillnoSerialList(BillnoSerial billnoSerial) {
  264. return billnoSerialMapper.selectBillnoSerialList(billnoSerial);
  265. }
  266. /**
  267. * 新增客户存货编号流水号
  268. *
  269. * @param billnoSerial 客户存货编号流水号
  270. * @return 结果
  271. */
  272. @Override
  273. public int insertBillnoSerial(BillnoSerial billnoSerial) {
  274. return billnoSerialMapper.insertBillnoSerial(billnoSerial);
  275. }
  276. /**
  277. * 修改客户存货编号流水号
  278. *
  279. * @param billnoSerial 客户存货编号流水号
  280. * @return 结果
  281. */
  282. @Override
  283. public int updateBillnoSerial(BillnoSerial billnoSerial) {
  284. return billnoSerialMapper.updateBillnoSerial(billnoSerial);
  285. }
  286. /**
  287. * 批量删除客户存货编号流水号
  288. *
  289. * @param ids 需要删除的客户存货编号流水号ID
  290. * @return 结果
  291. */
  292. @Override
  293. public int deleteBillnoSerialByIds(Long[] ids) {
  294. return billnoSerialMapper.deleteBillnoSerialByIds(ids);
  295. }
  296. /**
  297. * 删除客户存货编号流水号信息
  298. *
  299. * @param id 客户存货编号流水号ID
  300. * @return 结果
  301. */
  302. @Override
  303. public int deleteBillnoSerialById(Long id) {
  304. return billnoSerialMapper.deleteBillnoSerialById(id);
  305. }
  306. }