| | |
|---|
| | | .selectAs(Goods::getName,Collect::getName) |
|---|
| | | .selectAs(Goods::getPrice,Collect::getPrice) |
|---|
| | | .selectAs(Goods::getImgurl,Collect::getActivityImgurl) |
|---|
| | | .select(" ifnull(( select min(gs.PRICE) from goods_sku gs where gs.GOODS_ID = t1.id and gs.ISDELETED = 0 ),0) ",Goods::getMinPrice) |
|---|
| | | .select(" ifnull(( select min(gs.SHOW_PRICE) from goods_sku gs where gs.GOODS_ID = t1.id and gs.ISDELETED = 0 ),0) ",Goods::getLinePrice) |
|---|
| | | .select(" ifnull(( select min(gs.PRICE) from goods_sku gs where gs.GOODS_ID = t1.id and gs.ISDELETED = 0 ),0) ",Collect::getMinPrice) |
|---|
| | | .select(" ifnull(( select min(gs.SHOW_PRICE) from goods_sku gs where gs.GOODS_ID = t1.id and gs.ISDELETED = 0 ),0) ",Collect::getLinePrice) |
|---|
| | | .leftJoin(Goods.class,Goods::getId,Collect::getObjId) |
|---|
| | | .eq(Collect::getIsdeleted,Constants.ZERO) |
|---|
| | | .eq(Collect::getMemberId,memberId) |
|---|
