| | |
|---|
| | | .apply(Objects.nonNull(status)&&Constants.equalsInteger(status,Constants.TWO),"m.STATUS = 0 and m.END_DATE < now() " ) |
|---|
| | | .eq("TYPE",couponType) |
|---|
| | | .apply(!Objects.isNull(price)," m.LIMIT_PRICE >= "+price+" ") |
|---|
| | | .apply(" now() between m.START_DATE and m.END_DATE ") |
|---|
| | | // .apply(" now() between m.START_DATE and m.END_DATE ") |
|---|
| | | .orderByDesc(" m.PRICE ") |
|---|
| | | ); |
|---|
| | | return page; |
|---|
| | |
|---|
| | | //查询商品列表 |
|---|
| | | List<Goods> goodsList = goodsMapper.selectJoinList(Goods.class, |
|---|
| | | new MPJLambdaWrapper<Goods>() |
|---|
| | | .selectAll(Goods.class) |
|---|
| | | .selectAs(GoodsSku::getPrice,Goods::getSkuPrice) |
|---|
| | | .selectAs(GoodsSku::getId,Goods::getSkuId) |
|---|
| | | .leftJoin(GoodsSku.class,GoodsSku::getGoodsId,Goods::getId) |
|---|
