001 | package com.dev.warehouse.bus.controller; |
004 | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
005 | import com.baomidou.mybatisplus.core.metadata.IPage; |
006 | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
007 | import com.dev.warehouse.bus.entity.Goods; |
008 | import com.dev.warehouse.bus.entity.Provider; |
009 | import com.dev.warehouse.bus.service.IGoodsService; |
010 | import com.dev.warehouse.bus.service.IProviderService; |
011 | import com.dev.warehouse.bus.vo.GoodsVo; |
012 | import com.dev.warehouse.sys.common.AppFileUtils; |
013 | import com.dev.warehouse.sys.common.Constast; |
014 | import com.dev.warehouse.sys.common.DataGridView; |
015 | import com.dev.warehouse.sys.common.ResultObj; |
016 | import org.apache.commons.lang3.StringUtils; |
017 | import org.springframework.beans.factory.annotation.Autowired; |
018 | import org.springframework.web.bind.annotation.RequestMapping; |
019 | import org.springframework.web.bind.annotation.RestController; |
021 | import java.util.List; |
024 | @RequestMapping ( "/goods" ) |
025 | public class GoodsController { |
028 | private IGoodsService goodsService; |
031 | private IProviderService providerService; |
038 | @RequestMapping ( "loadAllGoods" ) |
039 | public DataGridView loadAllGoods(GoodsVo goodsVo){ |
040 | IPage<Goods> page = new Page<>(goodsVo.getPage(),goodsVo.getLimit()); |
041 | QueryWrapper<Goods> queryWrapper = new QueryWrapper(); |
042 | queryWrapper.eq(goodsVo.getProviderid()!= null &&goodsVo.getProviderid()!= 0 , "providerid" ,goodsVo.getProviderid()); |
043 | queryWrapper.like(StringUtils.isNotBlank(goodsVo.getGoodsname()), "goodsname" ,goodsVo.getGoodsname()); |
044 | queryWrapper.like(StringUtils.isNotBlank(goodsVo.getProductcode()), "productcode" ,goodsVo.getProductcode()); |
045 | queryWrapper.like(StringUtils.isNotBlank(goodsVo.getPromitcode()), "promitcode" ,goodsVo.getPromitcode()); |
046 | queryWrapper.like(StringUtils.isNotBlank(goodsVo.getDescription()), "description" ,goodsVo.getDescription()); |
047 | queryWrapper.like(StringUtils.isNotBlank(goodsVo.getSize()), "size" ,goodsVo.getSize()); |
048 | queryWrapper.orderByDesc( "id" ); |
049 | goodsService.page(page,queryWrapper); |
050 | List<Goods> records = page.getRecords(); |
051 | for (Goods goods : records) { |
052 | Provider provider = providerService.getById(goods.getProviderid()); |
054 | goods.setProvidername(provider.getProvidername()); |
057 | return new DataGridView(page.getTotal(),page.getRecords()); |
065 | @RequestMapping ( "addGoods" ) |
066 | public ResultObj addGoods(GoodsVo goodsVo){ |
068 | if (goodsVo.getGoodsimg()!= null &&goodsVo.getGoodsimg().endsWith( "_temp" )){ |
069 | String newName = AppFileUtils.renameFile(goodsVo.getGoodsimg()); |
070 | goodsVo.setGoodsimg(newName); |
072 | goodsService.save(goodsVo); |
073 | return ResultObj.ADD_SUCCESS; |
074 | } catch (Exception e) { |
076 | return ResultObj.ADD_ERROR; |
085 | @RequestMapping ( "updateGoods" ) |
086 | public ResultObj updateGoods(GoodsVo goodsVo){ |
089 | if (!(goodsVo.getGoodsimg()!= null &&goodsVo.getGoodsimg().equals(Constast.DEFAULT_IMG))){ |
090 | if (goodsVo.getGoodsimg().endsWith( "_temp" )){ |
091 | String newName = AppFileUtils.renameFile(goodsVo.getGoodsimg()); |
092 | goodsVo.setGoodsimg(newName); |
094 | String oldPath = goodsService.getById(goodsVo.getId()).getGoodsimg(); |
095 | AppFileUtils.removeFileByPath(oldPath); |
098 | goodsService.updateById(goodsVo); |
099 | return ResultObj.UPDATE_SUCCESS; |
100 | } catch (Exception e) { |
102 | return ResultObj.UPDATE_ERROR; |
111 | @RequestMapping ( "deleteGoods" ) |
112 | public ResultObj deleteGoods(Integer id,String goodsimg){ |
115 | AppFileUtils.removeFileByPath(goodsimg); |
116 | goodsService.removeById(id); |
117 | return ResultObj.DELETE_SUCCESS; |
118 | } catch (Exception e) { |
120 | return ResultObj.DELETE_ERROR; |
128 | @RequestMapping ( "loadAllGoodsForSelect" ) |
129 | public DataGridView loadAllGoodsForSelect(){ |
130 | QueryWrapper<Goods> queryWrapper = new QueryWrapper<Goods>(); |
131 | queryWrapper.eq( "available" ,Constast.AVAILABLE_TRUE); |
132 | List<Goods> list = goodsService.list(queryWrapper); |
133 | for (Goods goods : list) { |
134 | Provider provider = providerService.getById(goods.getProviderid()); |
136 | goods.setProvidername(provider.getProvidername()); |
139 | return new DataGridView(list); |
144 | * @param providerid 供应商ID |
147 | @RequestMapping ( "loadGoodsByProviderId" ) |
148 | public DataGridView loadGoodsByProviderId(Integer providerid){ |
149 | QueryWrapper<Goods> queryWrapper = new QueryWrapper<Goods>(); |
150 | queryWrapper.eq( "available" ,Constast.AVAILABLE_TRUE); |
151 | queryWrapper.eq(providerid!= null , "providerid" ,providerid); |
152 | List<Goods> list = goodsService.list(queryWrapper); |
153 | for (Goods goods : list) { |
154 | Provider provider = providerService.getById(goods.getProviderid()); |
156 | goods.setProvidername(provider.getProvidername()); |
159 | return new DataGridView(list); |