| | |
|---|
| | | |
|---|
| | | import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; |
|---|
| | | import com.baomidou.mybatisplus.core.toolkit.CollectionUtils; |
|---|
| | | import com.ruoyi.framework.web.domain.AjaxResult; |
|---|
| | | import com.ruoyi.framework.web.domain.R; |
|---|
| | | import com.ruoyi.sales.dto.SalesTrendDto; |
|---|
| | | import com.ruoyi.sales.dto.StatisticsTableDto; |
|---|
| | | import com.ruoyi.sales.mapper.SalesLedgerMapper; |
|---|
| | |
|---|
| | | private final SalesLedgerProductMapper salesLedgerProductMapper; |
|---|
| | | private final ShippingInfoMapper shippingInfoMapper; |
|---|
| | | |
|---|
| | | public AjaxResult total() { |
|---|
| | | public R<?> total() { |
|---|
| | | List<SalesLedger> salesLedgers = salesLedgerMapper.selectList(null); |
|---|
| | | if(CollectionUtils.isEmpty(salesLedgers)) return AjaxResult.success(salesLedgers); |
|---|
| | | if(CollectionUtils.isEmpty(salesLedgers)) return R.ok(salesLedgers); |
|---|
| | | Map<String, Object> map = new HashMap<>(); |
|---|
| | | // 销售额 |
|---|
| | | map.put("contractAmountTotal", salesLedgers.stream().map(SalesLedger::getContractAmount).reduce(BigDecimal.ZERO, BigDecimal::add)); |
|---|
| | |
|---|
| | | List<SalesLedgerProduct> salesLedgerProducts = salesLedgerProductMapper.selectList(new LambdaQueryWrapper<SalesLedgerProduct>() |
|---|
| | | .eq(SalesLedgerProduct::getType, 1)); |
|---|
| | | map.put("shipRate", "0%"); |
|---|
| | | if(CollectionUtils.isEmpty(salesLedgerProducts)) return AjaxResult.success(map); |
|---|
| | | if(CollectionUtils.isEmpty(salesLedgerProducts)) return R.ok(map); |
|---|
| | | // 发货数量 |
|---|
| | | long count = shippingInfoMapper.selectCount(new LambdaQueryWrapper<ShippingInfo>() |
|---|
| | | .in(ShippingInfo::getSalesLedgerProductId, salesLedgerProducts.stream().map(SalesLedgerProduct::getId).collect(Collectors.toList())) |
|---|
| | | .eq(ShippingInfo::getStatus,"已发货")); |
|---|
| | | map.put("shipRate", String.format("%.2f", count * 100.0 / salesLedgerProducts.size()) + "%"); |
|---|
| | | return AjaxResult.success(map); |
|---|
| | | return R.ok(map); |
|---|
| | | } |
|---|
| | | |
|---|
| | | public AjaxResult statisticsTable(StatisticsTableDto statisticsTableDto) { |
|---|
| | | public R<?> statisticsTable(StatisticsTableDto statisticsTableDto) { |
|---|
| | | Map<String, Object> map = new HashMap<>(); |
|---|
| | | Calendar calendar = Calendar.getInstance(); |
|---|
| | | |
|---|
| | |
|---|
| | | map.put("orderCountList", orderCountList); |
|---|
| | | map.put("salesAmountList", salesAmountList); |
|---|
| | | map.put("shippingRateList", shippingRateList); |
|---|
| | | return AjaxResult.success(map); |
|---|
| | | return R.ok(map); |
|---|
| | | } |
|---|
| | | } |
|---|
