| | |
|---|
| | | |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public SaleReportResponse saleReport(SaleReportRequest request,String shopId){ |
|---|
| | | public SaleReportResponse saleReport(SaleReportRequest request,Integer shopId){ |
|---|
| | | SaleReportResponse saleReportResponse = new SaleReportResponse(); |
|---|
| | | saleReportResponse.setSaleTotal(BigDecimal.ZERO); |
|---|
| | | saleReportResponse.setOrderNum(Constants.ZERO); |
|---|
| | |
|---|
| | | .selectAll(Goodsorder.class) |
|---|
| | | .selectAs(Member::getPhone,Goodsorder::getPhone) |
|---|
| | | .selectAs(Member::getNickname,Goodsorder::getNickName) |
|---|
| | | .select(" select ifnull(sum(g.SHOP_SETTLEMENT),0) from goodsorder_detail g where t.id = g.ORDER_ID ",Goodsorder::getShopSettlement) |
|---|
| | | .leftJoin(Member.class,Member::getId,Goodsorder::getMemberId) |
|---|
| | | .eq(Goodsorder::getIsdeleted,Constants.ZERO) |
|---|
| | | .eq(Goodsorder::getDistributionShopId,shopId) |
|---|
