| | |
|---|
| | | MPJLambdaWrapper<Goods> wrapper = new MPJLambdaWrapper<Goods>() |
|---|
| | | .selectAll(Goods.class) |
|---|
| | | .select(" ifnull(( select min(gs.PRICE) from goods_sku gs where gs.GOODS_ID = t.id ),0) ",Goods::getMinPrice) |
|---|
| | | .select(" ifnull(( select min(gs.SHOW_PRICE) from goods_sku gs where gs.GOODS_ID = t.id ),0) ",Goods::getLinePrice) |
|---|
| | | .leftJoin(SystemUser.class, SystemUser::getId, Goods::getCreator) |
|---|
| | | .eq(Goods::getIsdeleted,Constants.ZERO) |
|---|
| | | .eq(!Objects.isNull(model) && Objects.nonNull(model.getCategoryId()), |
|---|
| | |
|---|
| | | //真实销量 = realSaleNum - saleNum; |
|---|
| | | //真实库存= sumStock - (realSaleNum - saleNum) |
|---|
| | | goodsResponse.setStock(sumStock); |
|---|
| | | goodsResponse.setRealSaleNum(goodsResponse.getRealSaleNum()+sumStock); |
|---|
| | | goodsResponse.setGoodsSkuResponseList(goodsSkuResponseList); |
|---|
| | | //Sku基础信息 |
|---|
| | | List<SkuResponse> skuResponseList = skuMapper.getSkuResponseList(goodsResponse.getId()); |
|---|
