GoodsServiceImpl.java 3.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081
  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. Goods one = goodsMapper.selectOne(goodsQueryWrapper);
  32. if (one != null)
  33. return 2;
  34. goods.setCreateTime(LocalDateTime.now(ZoneId.of("Asia/Shanghai")));
  35. return goodsMapper.insert(goods);
  36. }
  37. @Override
  38. public int deleteGoods(GoodsDeleteBo bo) {
  39. QueryWrapper<Goods> goodsQueryWrapper = new QueryWrapper<>();
  40. goodsQueryWrapper.eq("appkey",bo.getAppkey());
  41. goodsQueryWrapper.eq("goods_id",bo.getGoodsId());
  42. return goodsMapper.delete(goodsQueryWrapper);
  43. }
  44. @Override
  45. public PageInfo<List<GoodsListVo>> getGoodsList(PlanBo bo) {
  46. PageHelper.startPage(bo.getPageNum(),bo.getPageSize(),true);
  47. QueryWrapper<Goods> queryWrapper = new QueryWrapper<>();
  48. if (bo.getStartTime() != null)
  49. queryWrapper.apply("DATE_FORMAT(create_time,'%Y-%m-%d %H:%i:%s') >= DATE_FORMAT({0},'%Y-%m-%d %H:%i:%s')",bo.getStartTime());
  50. if (bo.getEndTime() != null)
  51. queryWrapper.apply("DATE_FORMAT(create_time,'%Y-%m-%d %H:%i:%s') <= DATE_FORMAT({0},'%Y-%m-%d %H:%i:%s')",bo.getEndTime());
  52. List<GoodsListVo> vos = new ArrayList<>();
  53. for (Goods goods : goodsMapper.selectList(queryWrapper)) {
  54. vos.add(new GoodsListVo(goods));
  55. }
  56. return new PageInfo(vos);
  57. }
  58. @Override
  59. public GoodsDetailVo getGoodsDetail(GoodsBo bo) {
  60. QueryWrapper<Goods> goodsQueryWrapper = new QueryWrapper<>();
  61. goodsQueryWrapper.eq("appkey",bo.getAppkey());
  62. goodsQueryWrapper.eq("goods_id",bo.getGoodsId());
  63. Goods goods = goodsMapper.selectOne(goodsQueryWrapper);
  64. return new GoodsDetailVo(goods);
  65. }
  66. @Override
  67. public int editGoods(Goods goods) {
  68. QueryWrapper<Goods> goodsQueryWrapper = new QueryWrapper<>();
  69. goodsQueryWrapper.eq("appkey",goods.getAppkey());
  70. goodsQueryWrapper.eq("goods_id",goods.getGoodsId());
  71. return goodsMapper.update(goods,goodsQueryWrapper);
  72. }
  73. }