UnitServiceImpl.java 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363
  1. package com.jsh.erp.service.impl;
  2. import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
  3. import com.jsh.erp.constants.BusinessConstants;
  4. import com.jsh.erp.constants.ExceptionConstants;
  5. import com.jsh.erp.datasource.entities.Material;
  6. import com.jsh.erp.datasource.entities.Unit;
  7. import com.jsh.erp.datasource.entities.UnitExample;
  8. import com.jsh.erp.datasource.entities.User;
  9. import com.jsh.erp.datasource.mappers.MaterialMapperEx;
  10. import com.jsh.erp.datasource.mappers.UnitMapper;
  11. import com.jsh.erp.datasource.mappers.UnitMapperEx;
  12. import com.jsh.erp.datasource.vo.UnitListVo;
  13. import com.jsh.erp.exception.BusinessRunTimeException;
  14. import com.jsh.erp.exception.JshException;
  15. import com.jsh.erp.service.LogService;
  16. import com.jsh.erp.service.UnitService;
  17. import com.jsh.erp.service.UserService;
  18. import com.jsh.erp.utils.PageUtils;
  19. import com.jsh.erp.utils.StringUtil;
  20. import org.slf4j.Logger;
  21. import org.slf4j.LoggerFactory;
  22. import org.springframework.stereotype.Service;
  23. import org.springframework.transaction.annotation.Transactional;
  24. import org.springframework.web.context.request.RequestContextHolder;
  25. import org.springframework.web.context.request.ServletRequestAttributes;
  26. import javax.annotation.Resource;
  27. import javax.servlet.http.HttpServletRequest;
  28. import java.math.BigDecimal;
  29. import java.util.ArrayList;
  30. import java.util.Date;
  31. import java.util.List;
  32. @Service
  33. public class UnitServiceImpl extends ServiceImpl<UnitMapper,Unit> implements UnitService {
  34. private Logger logger = LoggerFactory.getLogger(UnitServiceImpl.class);
  35. @Resource
  36. private UnitMapper unitMapper;
  37. @Resource
  38. private UnitMapperEx unitMapperEx;
  39. @Resource
  40. private UserService userService;
  41. @Resource
  42. private LogService logService;
  43. @Resource
  44. private MaterialMapperEx materialMapperEx;
  45. @Override
  46. public Unit getUnit(long id) {
  47. Unit result=null;
  48. try{
  49. result=unitMapper.selectByPrimaryKey(id);
  50. }catch(Exception e){
  51. JshException.readFail(logger, e);
  52. }
  53. return result;
  54. }
  55. @Override
  56. public List<Unit> getUnitListByIds(String ids) {
  57. List<Long> idList = StringUtil.strToLongList(ids);
  58. List<Unit> list = new ArrayList<>();
  59. try{
  60. UnitExample example = new UnitExample();
  61. example.createCriteria().andIdIn(idList);
  62. list = unitMapper.selectByExample(example);
  63. }catch(Exception e){
  64. JshException.readFail(logger, e);
  65. }
  66. return list;
  67. }
  68. /**
  69. * 所有单位集合
  70. */
  71. @Override
  72. public List<Unit> unitList() {
  73. UnitExample example = new UnitExample();
  74. example.createCriteria().andEnabledEqualTo(true).andDeleteFlagNotEqualTo(BusinessConstants.DELETE_FLAG_DELETED);
  75. List<Unit> list = null;
  76. try{
  77. list = unitMapper.selectByExample(example);
  78. }catch(Exception e){
  79. JshException.readFail(logger, e);
  80. }
  81. return list;
  82. }
  83. @Override
  84. public List<Unit> select(String name)throws Exception {
  85. List<Unit> list=null;
  86. try{
  87. PageUtils.startPage();
  88. list=unitMapperEx.selectByConditionUnit(name);
  89. }catch(Exception e){
  90. JshException.readFail(logger, e);
  91. }
  92. return list;
  93. }
  94. /**
  95. * 新增单位
  96. * @param unit 单位
  97. */
  98. @Override
  99. public int insertUnit(Unit unit, HttpServletRequest request)throws Exception {
  100. int result=0;
  101. try{
  102. unit.setEnabled(true);
  103. result=unitMapper.insertSelective(unit);
  104. logService.insertLog("多单位",
  105. new StringBuffer(BusinessConstants.LOG_OPERATION_TYPE_ADD).append(unit.getName()).toString(), request);
  106. }catch(Exception e){
  107. JshException.writeFail(logger, e);
  108. }
  109. return result;
  110. }
  111. /**
  112. * 修改单位
  113. * @param unit 单位
  114. */
  115. @Override
  116. public int updateUnit(Unit unit, HttpServletRequest request) {
  117. int result=0;
  118. try{
  119. result = unitMapper.updateByPrimaryKeySelective(unit);
  120. logService.insertLog("多单位",
  121. new StringBuffer(BusinessConstants.LOG_OPERATION_TYPE_EDIT).append(unit.getName()).toString(), request);
  122. }catch(Exception e){
  123. JshException.writeFail(logger, e);
  124. }
  125. return result;
  126. }
  127. /**
  128. * 根据单位信息生成名称的格式
  129. * @param unit
  130. */
  131. private void parseNameByUnit(Unit unit) {
  132. String unitName = unit.getBasicUnit() + "/" + "(" + unit.getOtherUnit() + "=" + unit.getRatio().toString() + unit.getBasicUnit() + ")";
  133. if(StringUtil.isNotEmpty(unit.getOtherUnitTwo()) && unit.getRatioTwo()!=null) {
  134. unitName += "/" + "(" + unit.getOtherUnitTwo() + "=" + unit.getRatioTwo().toString() + unit.getBasicUnit() + ")";
  135. if(StringUtil.isNotEmpty(unit.getOtherUnitThree()) && unit.getRatioThree()!=null) {
  136. unitName += "/" + "(" + unit.getOtherUnitThree() + "=" + unit.getRatioThree().toString() + unit.getBasicUnit() + ")";
  137. }
  138. }
  139. unit.setName(unitName);
  140. }
  141. /**
  142. * 删除单位
  143. * @param id 单位id
  144. * @param request
  145. */
  146. @Override
  147. public int deleteUnit(Long id, HttpServletRequest request) {
  148. return batchDeleteUnitByIds(id.toString());
  149. }
  150. /**
  151. * 批量删除单位
  152. * @param ids 单位id字符集
  153. * @param request
  154. */
  155. @Override
  156. public int batchDeleteUnit(String ids, HttpServletRequest request){
  157. return batchDeleteUnitByIds(ids);
  158. }
  159. /**
  160. * 检查单位名称是否存在
  161. * @param name 单位名称
  162. * @return 单位数量
  163. */
  164. @Override
  165. public int checkIsNameExist(String name) {
  166. UnitExample example = new UnitExample();
  167. example.createCriteria().andNameEqualTo(name.replaceAll(" ", "")).andDeleteFlagNotEqualTo(BusinessConstants.DELETE_FLAG_DELETED);
  168. List<Unit> list = null;
  169. try{
  170. list = unitMapper.selectByExample(example);
  171. }catch(Exception e){
  172. JshException.readFail(logger, e);
  173. }
  174. return list == null ? 0 : list.size();
  175. }
  176. /**
  177. * 根据条件查询单位id
  178. * @param basicUnit
  179. * @param otherUnit
  180. * @param ratio
  181. * @return
  182. */
  183. @Override
  184. public Long getUnitIdByParam(String basicUnit, String otherUnit, BigDecimal ratio){
  185. Long unitId = null;
  186. UnitExample example = new UnitExample();
  187. example.createCriteria().andBasicUnitEqualTo(basicUnit).andOtherUnitEqualTo(otherUnit).andRatioEqualTo(ratio)
  188. .andDeleteFlagNotEqualTo(BusinessConstants.DELETE_FLAG_DELETED);
  189. List<Unit> list = unitMapper.selectByExample(example);
  190. if(list!=null && list.size()>0) {
  191. unitId = list.get(0).getId();
  192. }
  193. return unitId;
  194. }
  195. /**
  196. * 根据多单位的比例进行库存换算(保留两位小数)
  197. * @param stock
  198. * @param unitInfo
  199. * @param materialUnit
  200. * @return
  201. */
  202. @Override
  203. public BigDecimal parseStockByUnit(BigDecimal stock, Unit unitInfo, String materialUnit) {
  204. if(materialUnit.equals(unitInfo.getOtherUnit()) && unitInfo.getRatio()!=null && unitInfo.getRatio().compareTo(BigDecimal.ZERO)!=0) {
  205. stock = stock.divide(unitInfo.getRatio(),2,BigDecimal.ROUND_HALF_UP);
  206. }
  207. if(materialUnit.equals(unitInfo.getOtherUnitTwo()) && unitInfo.getRatioTwo()!=null && unitInfo.getRatioTwo().compareTo(BigDecimal.ZERO)!=0) {
  208. stock = stock.divide(unitInfo.getRatioTwo(),2,BigDecimal.ROUND_HALF_UP);
  209. }
  210. if(materialUnit.equals(unitInfo.getOtherUnitThree()) && unitInfo.getRatioThree()!=null && unitInfo.getRatioThree().compareTo(BigDecimal.ZERO)!=0) {
  211. stock = stock.divide(unitInfo.getRatioThree(),2,BigDecimal.ROUND_HALF_UP);
  212. }
  213. return stock;
  214. }
  215. /**
  216. * 根据多单位的比例进行单价换算(保留两位小数),变大
  217. * @param unitPrice
  218. * @param unitInfo
  219. * @param materialUnit
  220. * @return
  221. */
  222. @Override
  223. public BigDecimal parseUnitPriceByUnit(BigDecimal unitPrice, Unit unitInfo, String materialUnit) {
  224. if (materialUnit.equals(unitInfo.getOtherUnit()) && unitInfo.getRatio() != null && unitInfo.getRatio().compareTo(BigDecimal.ZERO) != 0) {
  225. unitPrice = unitPrice.multiply(unitInfo.getRatio());
  226. }
  227. if (materialUnit.equals(unitInfo.getOtherUnitTwo()) && unitInfo.getRatioTwo() != null && unitInfo.getRatioTwo().compareTo(BigDecimal.ZERO) != 0) {
  228. unitPrice = unitPrice.multiply(unitInfo.getRatioTwo());
  229. }
  230. if (materialUnit.equals(unitInfo.getOtherUnitThree()) && unitInfo.getRatioThree() != null && unitInfo.getRatioThree().compareTo(BigDecimal.ZERO) != 0) {
  231. unitPrice = unitPrice.multiply(unitInfo.getRatioThree());
  232. }
  233. return unitPrice;
  234. }
  235. /**
  236. * 根据多单位的比例进行总金额换算(保留两位小数),变小
  237. * @param allPrice
  238. * @param unitInfo
  239. * @param materialUnit
  240. * @return
  241. */
  242. @Override
  243. public BigDecimal parseAllPriceByUnit(BigDecimal allPrice, Unit unitInfo, String materialUnit) {
  244. if (materialUnit.equals(unitInfo.getOtherUnit()) && unitInfo.getRatio() != null && unitInfo.getRatio().compareTo(BigDecimal.ZERO) != 0) {
  245. allPrice = allPrice.divide(unitInfo.getRatio(), 2, BigDecimal.ROUND_HALF_UP);
  246. }
  247. if (materialUnit.equals(unitInfo.getOtherUnitTwo()) && unitInfo.getRatioTwo() != null && unitInfo.getRatioTwo().compareTo(BigDecimal.ZERO) != 0) {
  248. allPrice = allPrice.divide(unitInfo.getRatioTwo(), 2, BigDecimal.ROUND_HALF_UP);
  249. }
  250. if (materialUnit.equals(unitInfo.getOtherUnitThree()) && unitInfo.getRatioThree() != null && unitInfo.getRatioThree().compareTo(BigDecimal.ZERO) != 0) {
  251. allPrice = allPrice.divide(unitInfo.getRatioThree(), 2, BigDecimal.ROUND_HALF_UP);
  252. }
  253. return allPrice;
  254. }
  255. /**
  256. * 批量设置状态
  257. * @param status 状态
  258. * @param ids 单位id
  259. */
  260. @Override
  261. public int batchSetStatus(Boolean status, String ids){
  262. logService.insertLog("多单位",
  263. new StringBuffer(BusinessConstants.LOG_OPERATION_TYPE_ENABLED).toString(),
  264. ((ServletRequestAttributes) RequestContextHolder.getRequestAttributes()).getRequest());
  265. List<Long> unitIds = StringUtil.strToLongList(ids);
  266. Unit unit = new Unit();
  267. unit.setEnabled(status);
  268. UnitExample example = new UnitExample();
  269. example.createCriteria().andIdIn(unitIds);
  270. int result=0;
  271. try{
  272. result = unitMapper.updateByExampleSelective(unit, example);
  273. }catch(Exception e){
  274. JshException.writeFail(logger, e);
  275. }
  276. return result;
  277. }
  278. /**
  279. * 根据单位id获取单位值集合
  280. * @param id 单位id
  281. */
  282. @Override
  283. public List getUnitListByID(Long id){
  284. Unit unit = unitMapper.selectByPrimaryKey(id);
  285. List<UnitListVo> list = new ArrayList();
  286. UnitListVo unitListVo = new UnitListVo().setName(unit.getBasicUnit()).setRatio(new BigDecimal("1"));
  287. list.add(unitListVo);
  288. if (unit.getOtherUnit() != null){
  289. UnitListVo vo = new UnitListVo().setName(unit.getOtherUnit()).setRatio(unit.getRatio());
  290. list.add(vo);
  291. }
  292. if (unit.getOtherUnitTwo() != null){
  293. UnitListVo vo = new UnitListVo().setName(unit.getOtherUnitTwo()).setRatio(unit.getRatioTwo());
  294. list.add(vo);
  295. }
  296. if (unit.getOtherUnitThree() != null){
  297. UnitListVo vo = new UnitListVo().setName(unit.getOtherUnitThree()).setRatio(unit.getRatioThree());
  298. list.add(vo);
  299. }
  300. return list;
  301. }
  302. /**
  303. * 批量删除多单位
  304. * @param ids
  305. * @return
  306. * @throws Exception
  307. */
  308. private int batchDeleteUnitByIds(String ids) {
  309. int result=0;
  310. String [] idArray = ids.split(",");
  311. //校验产品表 jsh_material
  312. // List<Material> materialList = null;
  313. // try{
  314. // materialList = materialMapperEx.getMaterialListByUnitIds(idArray);
  315. // }catch(Exception e){
  316. // JshException.readFail(logger, e);
  317. // }
  318. // if(materialList!=null&&materialList.size()>0){
  319. // logger.error("异常码[{}],异常提示[{}],参数,UnitIds[{}]",
  320. // ExceptionConstants.DELETE_FORCE_CONFIRM_CODE,ExceptionConstants.DELETE_FORCE_CONFIRM_MSG,ids);
  321. // throw new BusinessRunTimeException(ExceptionConstants.DELETE_FORCE_CONFIRM_CODE,
  322. // ExceptionConstants.DELETE_FORCE_CONFIRM_MSG);
  323. // }
  324. //记录日志
  325. StringBuffer sb = new StringBuffer();
  326. sb.append(BusinessConstants.LOG_OPERATION_TYPE_DELETE);
  327. List<Unit> list = getUnitListByIds(ids);
  328. for(Unit unit: list){
  329. sb.append("[").append(unit.getName()).append("]");
  330. }
  331. logService.insertLog("多单位", sb.toString(),
  332. ((ServletRequestAttributes) RequestContextHolder.getRequestAttributes()).getRequest());
  333. User userInfo = userService.getCurrentUser();
  334. //校验通过执行删除操作
  335. try{
  336. result = unitMapperEx.batchDeleteUnitByIds(new Date(),userInfo == null ? null : userInfo.getId(),idArray);
  337. }catch(Exception e){
  338. JshException.writeFail(logger, e);
  339. }
  340. return result;
  341. }
  342. }