GoodsServiceImpl.java 3.7 KB

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