BillnoSerialServiceImpl.java 8.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236
  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. * @param billType 编号类型(SJRK(入库) SJCK(实际出库) CKDB(调拨) HQZY(货权转移))
  32. * @param time 入库时间
  33. * @return 结果
  34. */
  35. public String getBillNo(String billType, Date time) {
  36. String billNo = null;
  37. BillnoDel billnoDel = new BillnoDel();
  38. billnoDel.setBillType(billType);
  39. List<BillnoDel> billnoDels = billnoDelMapper.selectBillnoDelList(billnoDel);
  40. // 如果有数据在删除列表
  41. if (StringUtils.isNotEmpty(billnoDels)) {
  42. billnoDelMapper.deleteBillnoDelById(billnoDels.get(0).getId());
  43. billNo = billnoDels.get(0).getBillNo();
  44. return billNo;
  45. } else {
  46. String yyyyMM = DateFormatUtils.format(time, "yyyyMM");
  47. BillnoSerial billnoSerial = new BillnoSerial();
  48. billnoSerial.setBillType(billType);
  49. billnoSerial.setBillPrefix(yyyyMM);
  50. BillnoSerial billnoSerials = billnoSerialMapper.selectBillnoSerial(billnoSerial);
  51. if (StringUtils.isNotNull(billnoSerials)) {
  52. billnoSerials.setSerial(billnoSerials.getSerial() + 1);
  53. billnoSerialMapper.updateBillnoSerial(billnoSerials);
  54. if (billnoSerials.getSerial() <= 9) {
  55. billNo = yyyyMM +"00" + billnoSerials.getSerial();
  56. } else if (billnoSerials.getSerial() <= 99) {
  57. billNo =yyyyMM + "0" + billnoSerials.getSerial();
  58. } else if (billnoSerials.getSerial() <= 999) {
  59. billNo =yyyyMM + "" + billnoSerials.getSerial();
  60. }
  61. } else {
  62. billNo = yyyyMM + "001";
  63. billnoSerial.setSerial(1);
  64. billnoSerialMapper.insertBillnoSerial(billnoSerial);
  65. }
  66. }
  67. if ("SJRK".equals(billType)) {
  68. billNo = "RK" + billNo;
  69. } else if ("SJCK".equals(billType)) {
  70. billNo = "CK" + billNo;
  71. } else if ("CKDB".equals(billType)) {
  72. billNo = "DB" + billNo;
  73. } else if ("HQZY".equals(billType)) {
  74. billNo = "HZ" + billNo;
  75. } else if ("WA".equals(billType)){
  76. billNo = "WA" + billNo;
  77. } else if ("DZ".equals(billType)){
  78. billNo = "DZ" + billNo;
  79. } else if ("SF".equals(billType)){
  80. billNo = "SF" + billNo;
  81. } else if ("FF".equals(billType)){
  82. billNo = "FF" + billNo;
  83. }
  84. return billNo;
  85. }
  86. /**
  87. * 获取客户存货编号
  88. * @param corpId 客户id
  89. * @param time 时间
  90. * @return 结果
  91. */
  92. public String getCorpNo(long corpId, Date time) {
  93. String corpNo = null;
  94. String yyyy = DateFormatUtils.format(time, "yyyy");
  95. TCorps corps = tCorpsMapper.selectTCorpsById(corpId);
  96. corpNo = corps.getfNo() + yyyy;
  97. BillnoSerial billnoSerial = new BillnoSerial();
  98. billnoSerial.setBillType("corpNo");
  99. billnoSerial.setBillPrefix(yyyy);
  100. BillnoSerial billnoSerials = billnoSerialMapper.selectBillnoSerial(billnoSerial);
  101. if (StringUtils.isNotNull(billnoSerials)) {
  102. billnoSerials.setSerial(billnoSerials.getSerial() + 1);
  103. billnoSerialMapper.updateBillnoSerial(billnoSerials);
  104. if (billnoSerials.getSerial() <= 9) {
  105. corpNo = corpNo + "000" + billnoSerials.getSerial();
  106. } else if (billnoSerials.getSerial() <= 99) {
  107. corpNo = corpNo + "00" + billnoSerials.getSerial();
  108. } else if (billnoSerials.getSerial() <= 999) {
  109. corpNo = corpNo + "0" + billnoSerials.getSerial();
  110. } else if (billnoSerials.getSerial() <= 9999) {
  111. corpNo = corpNo + billnoSerials.getSerial();
  112. }
  113. } else {
  114. billnoSerial.setSerial(1);
  115. billnoSerialMapper.insertBillnoSerial(billnoSerial);
  116. corpNo = corpNo + "0001";
  117. }
  118. return corpNo;
  119. }
  120. /**
  121. * 获取入库 出库 流水号
  122. * @param billType 编号类型(RK(入库) CK(出库) )
  123. * @param time 入库时间
  124. * @return 结果
  125. */
  126. public String getSerialNumber(String billType, Date time) {
  127. String billNo = null;
  128. String yyMMdd = null;
  129. if ("CCF".equals(billType)) {
  130. yyMMdd = DateFormatUtils.format(time, "yyMM");
  131. } else {
  132. yyMMdd = DateFormatUtils.format(time, "yyMMdd");
  133. }
  134. BillnoSerial billnoSerial = new BillnoSerial();
  135. billnoSerial.setBillType(billType);
  136. billnoSerial.setBillPrefix(yyMMdd);
  137. BillnoSerial billnoSerials = billnoSerialMapper.selectBillnoSerial(billnoSerial);
  138. if (StringUtils.isNotNull(billnoSerials)) {
  139. if (billnoSerials.getSerial() <= 9) {
  140. billNo = yyMMdd +"00" + billnoSerials.getSerial();
  141. } else if (billnoSerials.getSerial() <= 99) {
  142. billNo =yyMMdd + "0" + billnoSerials.getSerial();
  143. } else if (billnoSerials.getSerial() <= 999) {
  144. billNo =yyMMdd + "" + billnoSerials.getSerial();
  145. }
  146. billnoSerials.setSerial(billnoSerials.getSerial() + 1);
  147. billnoSerialMapper.updateBillnoSerial(billnoSerials);
  148. } else {
  149. billNo = yyMMdd + "001";
  150. billnoSerial.setSerial(2);
  151. billnoSerialMapper.insertBillnoSerial(billnoSerial);
  152. }
  153. if ("RK".equals(billType)) {
  154. billNo = "RK" + billNo;
  155. } else if ("CK".equals(billType)) {
  156. billNo = "CK" + billNo;
  157. } else if ("CCF".equals(billType)) {
  158. billNo = "CCF" + billNo;
  159. }
  160. return billNo;
  161. }
  162. /**
  163. * 查询客户存货编号流水号
  164. *
  165. * @param id 客户存货编号流水号ID
  166. * @return 客户存货编号流水号
  167. */
  168. @Override
  169. public BillnoSerial selectBillnoSerialById(Long id) {
  170. return billnoSerialMapper.selectBillnoSerialById(id);
  171. }
  172. /**
  173. * 查询客户存货编号流水号列表
  174. *
  175. * @param billnoSerial 客户存货编号流水号
  176. * @return 客户存货编号流水号
  177. */
  178. @Override
  179. public List<BillnoSerial> selectBillnoSerialList(BillnoSerial billnoSerial) {
  180. return billnoSerialMapper.selectBillnoSerialList(billnoSerial);
  181. }
  182. /**
  183. * 新增客户存货编号流水号
  184. *
  185. * @param billnoSerial 客户存货编号流水号
  186. * @return 结果
  187. */
  188. @Override
  189. public int insertBillnoSerial(BillnoSerial billnoSerial) {
  190. return billnoSerialMapper.insertBillnoSerial(billnoSerial);
  191. }
  192. /**
  193. * 修改客户存货编号流水号
  194. *
  195. * @param billnoSerial 客户存货编号流水号
  196. * @return 结果
  197. */
  198. @Override
  199. public int updateBillnoSerial(BillnoSerial billnoSerial) {
  200. return billnoSerialMapper.updateBillnoSerial(billnoSerial);
  201. }
  202. /**
  203. * 批量删除客户存货编号流水号
  204. *
  205. * @param ids 需要删除的客户存货编号流水号ID
  206. * @return 结果
  207. */
  208. @Override
  209. public int deleteBillnoSerialByIds(Long[] ids) {
  210. return billnoSerialMapper.deleteBillnoSerialByIds(ids);
  211. }
  212. /**
  213. * 删除客户存货编号流水号信息
  214. *
  215. * @param id 客户存货编号流水号ID
  216. * @return 结果
  217. */
  218. @Override
  219. public int deleteBillnoSerialById(Long id) {
  220. return billnoSerialMapper.deleteBillnoSerialById(id);
  221. }
  222. }