| | |
| | | @PostMapping("/deleteGoodsType/{id}") |
| | | @ApiOperation(value = "删除", tags = {"后台-商品类型管理"}) |
| | | public R deleteGoodsType(@PathVariable("id") Integer id) { |
| | | // 初始化条件构造器 |
| | | QueryWrapper<TGoods> wrapper = new QueryWrapper<>(); |
| | | // 类型匹配 todo |
| | | wrapper.or().apply("FIND_IN_SET('" + id + "', typeIds)"); // 将每个类型 ID 应用于 FIND_IN_SET 函数 |
| | | wrapper.eq("isDelete", 0); |
| | | List<TGoods> list = goodsService.list(wrapper); |
| | | if (!list.isEmpty()){ |
| | | return R.fail("当前商品分类被使用,无法删除!"); |
| | | } |
| | | TGoodsType byId = goodsTypeService.getById(id); |
| | | byId.setIsDelete(1); |
| | | goodsTypeService.removeById(byId); |
| | |
| | | wrapper.orderByDesc("id"); |
| | | List<TGoods> list = goodsService.list(wrapper); |
| | | for (TGoods tGoods : list) { |
| | | long goodsId = orderService.count(new QueryWrapper<TOrder>().eq("goodsId", tGoods.getId())); |
| | | tGoods.setInventory(goodsId); |
| | | Long temp = 0L; |
| | | List<TOrder> list1 = orderService.list(new QueryWrapper<TOrder>().eq("goodsId", tGoods.getId())); |
| | | for (TOrder tOrder : list1) { |
| | | temp+=tOrder.getCount(); |
| | | } |
| | | tGoods.setInventory(temp); |
| | | } |
| | | PageInfo<TGoods> res = new PageInfo<>(query.getPageNumber(), query.getPageSize()); |
| | | res.setRecords(list); |
| | |
| | | TOrder byId = orderService.getById(id); |
| | | TGoods byId2 = goodsService.getById(byId.getGoodsId()); |
| | | TOrderVO tGoodsVO = new TOrderVO(); |
| | | tGoodsVO.setName(byId2.getName()); |
| | | BeanUtils.copyProperties(byId, tGoodsVO); |
| | | tGoodsVO.setName(byId2.getName()); |
| | | TUser byId1 = studyClient.getUserById(byId.getUserId()).getData(); |
| | | tGoodsVO.setUserName(byId1.getName()); |
| | | tGoodsVO.setPhone(byId1.getPhone()); |
| | | if (byId.getProvince()!=null && byId.getCity() != null){ |
| | | tGoodsVO.setConsigneeAddress(byId.getProvince()+byId.getCity()+tGoodsVO.getConsigneeAddress()); |
| | | } |
| | | return R.ok(tGoodsVO); |
| | | } |
| | | |
| | |
| | | @ApiOperation(value = "列表查询", tags = {"后台-订单管理"}) |
| | | @ApiOperationSupport(order = 13) |
| | | public R<PageInfo<TOrderVO>> listAll1(@RequestBody OrderQuery query) throws ParseException { |
| | | SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); |
| | | SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd"); |
| | | |
| | | if (query.getEndTime() != null) { |
| | | Date parse = format.parse(query.getStartTime()); |