GoodsServiceImpl.java 4.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101
  1. package com.ruoyi.demo.service.impl;
  2. import com.baomidou.mybatisplus.core.conditions.Wrapper;
  3. import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
  4. import com.github.pagehelper.PageHelper;
  5. import com.github.pagehelper.PageInfo;
  6. import com.ruoyi.demo.entity.Goods;
  7. import com.ruoyi.demo.entity.bo.GoodsBo;
  8. import com.ruoyi.demo.entity.bo.GoodsDeleteBo;
  9. import com.ruoyi.demo.entity.bo.PlanBo;
  10. import com.ruoyi.demo.entity.vo.GoodsDetailVo;
  11. import com.ruoyi.demo.entity.vo.GoodsListVo;
  12. import com.ruoyi.demo.mapper.GoodsMapper;
  13. import com.ruoyi.demo.service.GoodsService;
  14. import org.springframework.beans.factory.annotation.Autowired;
  15. import org.springframework.stereotype.Service;
  16. import org.springframework.transaction.annotation.Transactional;
  17. import java.time.LocalDateTime;
  18. import java.time.ZoneId;
  19. import java.util.ArrayList;
  20. import java.util.List;
  21. @Service
  22. @Transactional
  23. public class GoodsServiceImpl implements GoodsService {
  24. @Autowired
  25. GoodsMapper goodsMapper;
  26. @Override
  27. public int addGoods(Goods goods) {
  28. QueryWrapper<Goods> goodsQueryWrapper = new QueryWrapper<>();
  29. goodsQueryWrapper.eq("appkey",goods.getAppkey());
  30. goodsQueryWrapper.eq("goods_id",goods.getGoodsId());
  31. goodsQueryWrapper.eq("vendor_id",goods.getVendorId());
  32. goodsQueryWrapper.eq("deleted","0");
  33. Goods one = goodsMapper.selectOne(goodsQueryWrapper);
  34. if (one != null)
  35. return 2;
  36. goods.setCreateTime(LocalDateTime.now(ZoneId.of("Asia/Shanghai")));
  37. return goodsMapper.insert(goods);
  38. }
  39. @Override
  40. public int deleteGoods(GoodsDeleteBo bo) {
  41. QueryWrapper<Goods> goodsQueryWrapper = new QueryWrapper<>();
  42. goodsQueryWrapper.eq("appkey",bo.getAppkey());
  43. goodsQueryWrapper.eq("goods_id",bo.getGoodsId());
  44. goodsQueryWrapper.eq("vendor_id",bo.getVendorId());
  45. return goodsMapper.delete(goodsQueryWrapper);
  46. }
  47. @Override
  48. public PageInfo<List<GoodsListVo>> getGoodsList(PlanBo bo) {
  49. PageHelper.startPage(bo.getPageNum(),bo.getPageSize(),true);
  50. QueryWrapper<Goods> queryWrapper = new QueryWrapper<>();
  51. if (bo.getText() != null)
  52. queryWrapper.and(goodsQueryWrapper -> {
  53. goodsQueryWrapper.like("goods_id",bo.getText())
  54. .or()
  55. .like("goods_name",bo.getText())
  56. .or()
  57. .like("vendor_id",bo.getText())
  58. .or()
  59. .like("vendor_name",bo.getText())
  60. .or()
  61. .like("goods_classify",bo.getText());
  62. });
  63. if (bo.getStartTime() != null)
  64. queryWrapper.apply("create_time >= STR_TO_DATE({0},'%Y-%m-%d %H:%i:%s')",bo.getStartTime());
  65. if (bo.getEndTime() != null)
  66. queryWrapper.apply("create_time <= STR_TO_DATE({0},'%Y-%m-%d %H:%i:%s')",bo.getEndTime());
  67. queryWrapper.eq("deleted","0");
  68. List<GoodsListVo> vos = new ArrayList<>();
  69. for (Goods goods : goodsMapper.selectList(queryWrapper)) {
  70. vos.add(new GoodsListVo(goods));
  71. }
  72. return new PageInfo(vos);
  73. }
  74. @Override
  75. public GoodsDetailVo getGoodsDetail(GoodsBo bo) {
  76. QueryWrapper<Goods> goodsQueryWrapper = new QueryWrapper<>();
  77. goodsQueryWrapper.eq("appkey",bo.getAppkey());
  78. goodsQueryWrapper.eq("goods_id",bo.getGoodsId());
  79. goodsQueryWrapper.eq("vendor_id",bo.getVendorId());
  80. goodsQueryWrapper.eq("deleted","0");
  81. Goods goods = goodsMapper.selectOne(goodsQueryWrapper);
  82. return new GoodsDetailVo(goods);
  83. }
  84. @Override
  85. public int editGoods(Goods goods) {
  86. QueryWrapper<Goods> goodsQueryWrapper = new QueryWrapper<>();
  87. goodsQueryWrapper.eq("appkey",goods.getAppkey());
  88. goodsQueryWrapper.eq("goods_id",goods.getGoodsId());
  89. goodsQueryWrapper.eq("vendor_id",goods.getVendorId());
  90. goodsQueryWrapper.eq("deleted","0");
  91. return goodsMapper.update(goods,goodsQueryWrapper);
  92. }
  93. }