生鲜超市销售系统 毕业设计 JAVA+Vue+SpringBoot+MySQL

equestMapping(value = "/getByPage", method = RequestMethod.GET)
@ApiOperation(value = "查询商品")
public Result<IPage<Commodity>> getByPage(@ModelAttribute Commodity commodity ,@ModelAttribute PageVo page){
    QueryWrapper<Commodity> qw = new QueryWrapper<>();
    if(!ZwzNullUtils.isNull(commodity.getNature())) {
        qw.eq("nature",commodity.getNature());
    }
    if(!ZwzNullUtils.isNull(commodity.getAssetName())) {
        qw.like("asset_name",commodity.getAssetName());
    }
    if(!ZwzNullUtils.isNull(commodity.getShopId())) {
        qw.eq("shop_id",commodity.getShopId());
    }
    if(!ZwzNullUtils.isNull(commodity.getTypeId())) {
        qw.eq("type_id",commodity.getTypeId());
    }
    User currUser = securityUtil.getCurrUser();
    BigDecimal discount = currUser.getDiscount();

    String today = DateUtil.today();
    IPage<Commodity> data = iCommodityService.page(PageUtil.initMpPage(page),qw);
    for (Commodity co : data.getRecords()) {
        Integer shopDiscount = null;
        if(!ZwzNullUtils.isNull(co.getSupplierId())) {
            Supplier supplier = iSupplierService.getById(co.getSupplierId());
            if(supplier != null) {
                co.setSupplierName(supplier.getName());
            }
        }
        if(!ZwzNullUtils.isNull(co.getTypeId())) {
            CommodityType type = iCommodityTypeService.getById(co.getTypeId());
            if(type != null) {
                co.setTypeName(type.getTitle());
            }
        }
        if(!ZwzNullUtils.isNull(co.getShopId())) {
            Shop shop = iShopService.getById(co.getShopId());
            if(shop != null) {
                co.setShopName(shop.getTitle());
                QueryWrapper<ShopActivity> saQw = new QueryWrapper<>();
                saQw.eq("shop_id",shop.getId());
                saQw.le("start_date",today);
                saQw.ge("end_date",today);
                List<ShopActivity> shopActivityList = iShopActivityService.list(saQw);
                if(shopActivityList.size() > 0) {
                    int number = 100;
                    for (ShopActivity sa : shopActivityList) {
                        if(sa.getDiscount().intValue() < number) {
                            number = sa.getDiscount().intValue();
                        }
                    }
                    if(shopDiscount == null) {
                        shopDiscount = number;
                    } else if(shopDiscount > number){
                        shopDiscount = number;
                    }
                }
            }
        }
        if(shopDiscount == null) {
            shopDiscount = 100;
        }
        if(discount != null) {
            if(discount.intValue() < shopDiscount) {
                shopDiscount = discount.intValue();
            }
        }
        co.setDiscount(shopDiscount);
    }
    return new ResultUtil<IPage<Commodity>>().setData(data);
}

@RequestMapping(value = "/insert", method = RequestMethod.POST)
@ApiOperation(value = "新增商品入库单")
public Result<CommodityIn> insert(CommodityIn commodityIn){
    CommodityIn oldWarehousing = iCommodityInService.getById(commodityIn.getId());
    double oldNumber = 0.0;
    if(oldWarehousing != null){
        oldNumber = oldWarehousing.getNumber() == null ? 0.0 : Double.parseDouble(oldWarehousing.getNumber());
    }
    // 入库,更新库存
    Commodity assetsType = iCommodityService.getById(commodityIn.getAssetId());
    if(assetsType != null){
        // number = 现在仓库总数量 + 该入库单现增加数量 - 该入库单原有增加数量
        double number = Double.parseDouble(assetsType.getNumber()) + Double.parseDouble(commodityIn.getNumber()) - oldNumber;
        assetsType.setNumber(number + "");
        assetsType.setTotalPrice((Double.parseDouble(assetsType.getUnitPrice()) * number) + "");
        // existNumber = 现在仓库存在数量 + 该入库单现增加数量 - 该入库单原有增加数量
        double existNumber = Double.parseDouble(assetsType.getExistingNumber()) + Double.parseDouble(commodityIn.getNumber()) - oldNumber;
        if(existNumber < 0)  {
            return ResultUtil.error("入库数量大于已出库数量!");
        }
        assetsType.setExistingNumber(existNumber + "");
        iCommodityService.saveOrUpdate(assetsType);
    }
    iCommodityInService.saveOrUpdate(commodityIn);
    return new ResultUtil<CommodityIn>().setData(commodityIn);
}

@RequestMapping(value = "/insert", method = RequestMethod.POST)
@ApiOperation(value = "新增商品出库单")
public Result<CommodityOut> insert(CommodityOut commodityOut){
    CommodityOut oldWarehouseOut = iCommodityOutService.getById(commodityOut.getId());
    double oldNumber = 0.0;
    if(oldWarehouseOut != null){
        oldNumber = Double.parseDouble(oldWarehouseOut.getNumber());
    }
    // outNumber 要出库的数量
    double outNumber = Double.parseDouble(commodityOut.getNumber());
    Commodity oldAssetsType = iCommodityService.getById(commodityOut.getAssetId());
    if(oldAssetsType != null){
        // newNumber 出库后还有的数量 = 仓库原本还有的数量 - 出库单的出库数量 + 原有出库单的出库数量
        Double newNumber = Double.parseDouble(oldAssetsType.getExistingNumber()) - outNumber + oldNumber;
        if(newNumber >= 0){
            oldAssetsType.setExistingNumber(newNumber + "");
            iCommodityService.saveOrUpdate(oldAssetsType);
        }else{
            return ResultUtil.error("手慢啦!库存不足!");
        }
    }
    commodityOut.setDate(DateUtil.now());
    iCommodityOutService.saveOrUpdate(commodityOut);
    return new ResultUtil<CommodityOut>().setData(commodityOut);
}

@RequestMapping(value = "/getByPage", method = RequestMethod.GET)
@ApiOperation(value = "查询商品类型")
public Result<IPage<CommodityType>> getByPage(@ModelAttribute CommodityType commodityType ,@ModelAttribute PageVo page){
    QueryWrapper<CommodityType> qw = new QueryWrapper<>();
    if(!ZwzNullUtils.isNull(commodityType.getCreateBy())) {
    }
    IPage<CommodityType> data = iCommodityTypeService.page(PageUtil.initMpPage(page),qw);
    return new ResultUtil<IPage<CommodityType>>().setData(data);
}

@RequestMapping(value = "/getByPage", method = RequestMethod.GET)
@ApiOperation(value = "查询店铺活动")
public Result<IPage<ShopActivity>> getByPage(@ModelAttribute ShopActivity shopActivity ,@ModelAttribute PageVo page){
    QueryWrapper<ShopActivity> qw = new QueryWrapper<>();
    if(!ZwzNullUtils.isNull(shopActivity.getShopId())) {
        qw.eq("shop_id",shopActivity.getShopId());
    }
    if(!ZwzNullUtils.isNull(shopActivity.getTitle())) {
        qw.eq("title",shopActivity.getTitle());
    }
    IPage<ShopActivity> data = iShopActivityService.page(PageUtil.initMpPage(page),qw);
    for (ShopActivity activity : data.getRecords()) {
        String shopId = activity.getShopId();
        if(!ZwzNullUtils.isNull(shopId)) {
            Shop shop = iShopService.getById(shopId);
            if(shop != null) {
                activity.setShopName(shop.getTitle());
            }
        }
    }
    return new ResultUtil<IPage<ShopActivity>>().setData(data);
}