对比新文件 |
| | |
| | | package com.gk.firework.Controller; |
| | | |
| | | |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import com.gk.firework.Controller.Base.BaseController; |
| | | import com.gk.firework.Domain.Utils.FilterObject; |
| | | import com.gk.firework.Domain.Vo.PageInfoExtension; |
| | | import com.gk.firework.Service.*; |
| | | import io.swagger.annotations.Api; |
| | | import io.swagger.annotations.ApiImplicitParam; |
| | | import io.swagger.annotations.ApiImplicitParams; |
| | | import io.swagger.annotations.ApiOperation; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.web.bind.annotation.*; |
| | | |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | @Api(tags = "统计分析") |
| | | @RequestMapping("/statistics") |
| | | @RestController |
| | | public class StatisticsController extends BaseController { |
| | | |
| | | @Autowired |
| | | private EnterpriseService enterpriseService; |
| | | @Autowired |
| | | private SaleOrderDetailService saleOrderDetailService; |
| | | @Autowired |
| | | private LicenseService licenseService; |
| | | @Autowired |
| | | private EntryDetailService entryDetailService; |
| | | @Autowired |
| | | private DeliveryDetailService deliveryDetailService; |
| | | @Autowired |
| | | private HistoryStockService historyStockService; |
| | | |
| | | /** |
| | | * @Description: 经纬度查询 |
| | | * @date 2021/4/16 14:53 |
| | | */ |
| | | @GetMapping("/all-location") |
| | | @ApiOperation(value = "企业所有信息经纬度查询 按城市查") |
| | | Object getAllLocation(String city) { |
| | | List<Map> allLocation = enterpriseService.getAllLocation(city); |
| | | return success(allLocation); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * @Description: 零售点数量按区域统计 |
| | | * @date 2021/4/16 14:52 |
| | | */ |
| | | @GetMapping("/retail-statistics-area") |
| | | @ApiOperation(value = "零售点数量按区域统计") |
| | | Object getRetailStatisticsByArea() { |
| | | List<Map> retailStatisticsByArea = enterpriseService.getRetailStatisticsByArea(); |
| | | return success(retailStatisticsByArea); |
| | | } |
| | | |
| | | /** |
| | | * @Description: 近n天销售数据统计图 |
| | | * @date 2021/4/16 16:21 |
| | | */ |
| | | @GetMapping("/sale-data-ndays") |
| | | @ApiOperation(value = "近n天销售数据统计图") |
| | | @ApiImplicitParams({ |
| | | @ApiImplicitParam(name = "days", value = "时间天数(从现在往前推n天)") |
| | | }) |
| | | Object getSaleDataInDays(@RequestParam(defaultValue = "10") Integer days) { |
| | | List<Map> saleData = saleOrderDetailService.getSaleDataInDays(days); |
| | | return success(saleData); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * @Description: 销售数量按地区统计 n天 默认90 |
| | | * @date 2021/4/16 16:21 |
| | | */ |
| | | @GetMapping("/sale-data-area-ndays") |
| | | @ApiOperation(value = "销售数量按地区统计 n天 默认90") |
| | | @ApiImplicitParams({ |
| | | @ApiImplicitParam(name = "days", value = "时间天数(从现在往前推n天)") |
| | | }) |
| | | Object getSaleDataAreaInDays(@RequestParam(defaultValue = "90") Integer days) { |
| | | List<Map> saleData = saleOrderDetailService.getSaleDataAreaInDays(days); |
| | | return success(saleData); |
| | | } |
| | | |
| | | /** |
| | | * @Description: 销售数量按品种统计 n天 默认90 |
| | | * @date 2021/4/16 17:03 |
| | | */ |
| | | @GetMapping("/sale-data-productType-ndays") |
| | | @ApiOperation(value = "销售数量按品种统计 n天 默认90") |
| | | @ApiImplicitParams({ |
| | | @ApiImplicitParam(name = "days", value = "时间天数(从现在往前推n天)") |
| | | }) |
| | | Object getSaleDataProductTypeInDays(@RequestParam(defaultValue = "90") Integer days) { |
| | | List<Map> saleData = saleOrderDetailService.getSaleDataProductTypeInDays(days); |
| | | return success(saleData); |
| | | } |
| | | |
| | | /** |
| | | * @Description: 销售量同年对比 |
| | | * @date 2021/4/22 14:52 |
| | | */ |
| | | @GetMapping("/sale-data-compare-in-year") |
| | | @ApiOperation(value = "销售量同年对比") |
| | | @ApiImplicitParams({ |
| | | @ApiImplicitParam(name = "province", value = "省(默认新疆维吾尔自治区)"), |
| | | @ApiImplicitParam(name = "city", value = "市"), |
| | | }) |
| | | Object getSaleDataCompareInYear(@RequestParam(defaultValue = "新疆维吾尔自治区") String province, String city) { |
| | | Map compareData = saleOrderDetailService.getSaleDataCompareInYear(province, city); |
| | | return success(compareData); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * @Description: 进货量同年对比 |
| | | * @date 2021/4/22 14:52 |
| | | */ |
| | | @GetMapping("/inbound-compare-in-year") |
| | | @ApiOperation(value = "进货量同年对比") |
| | | @ApiImplicitParams({ |
| | | @ApiImplicitParam(name = "province", value = "省(默认新疆维吾尔自治区)"), |
| | | @ApiImplicitParam(name = "city", value = "市"), |
| | | }) |
| | | Object getInboundCompareInYear(@RequestParam(defaultValue = "新疆维吾尔自治区") String province, String city) { |
| | | Map compareData = saleOrderDetailService.getInboundCompareInYear(province, city); |
| | | return success(compareData); |
| | | } |
| | | |
| | | /** |
| | | * @Description: 统计各城市某时间的销量、进货量(箱数)显示新疆15个地州市的统计信息 |
| | | * @date 2021/5/15 9:15 |
| | | */ |
| | | @PostMapping("/city-inbound-outbound") |
| | | @ApiOperation(value = "统计各城市某时间的销量、进货量(箱数)显示新疆15个地州市的统计信息") |
| | | @ApiImplicitParams({ |
| | | @ApiImplicitParam(name = "pageIndex", value = "页码"), |
| | | @ApiImplicitParam(name = "pageSize", value = "页大小"), |
| | | @ApiImplicitParam(name = "filter.starttime", value = "开始时间"), |
| | | @ApiImplicitParam(name = "filter.endtime", value = "结束时间"), |
| | | }) |
| | | Object getCityInAndOut(@RequestBody FilterObject filterObject) { |
| | | Integer pageIndex = filterObject.getPageIndex(); |
| | | Integer pageSize = filterObject.getPageSize(); |
| | | //可以手写分页,查总数可以只查15个市 |
| | | IPage page = saleOrderDetailService.getCityInAndOut(new Page<>(pageIndex, pageSize), filterObject.getFilter()); |
| | | return success(page); |
| | | } |
| | | |
| | | @PostMapping("/export/city-inbound-outbound") |
| | | Object exportCityAndOut(@RequestBody FilterObject filterObject) { |
| | | List<Map> list = saleOrderDetailService.getCityInAndOutExport(filterObject.getFilter()); |
| | | return success(list); |
| | | } |
| | | |
| | | /** |
| | | * @Description: 地州市分类销售统计 |
| | | * @date 2022/1/29 18:04 |
| | | */ |
| | | |
| | | @PostMapping("/city-type-sale") |
| | | Object cityTypeSale(@RequestBody FilterObject filterObject) { |
| | | Integer pageIndex = filterObject.getPageIndex(); |
| | | Integer pageSize = filterObject.getPageSize(); |
| | | IPage page = saleOrderDetailService.selectCityTypeSale(new Page<>(pageIndex, pageSize), filterObject.getFilter()); |
| | | return success(page); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * @Description: 导出地州市分类销售统计 |
| | | * @date 2022/1/29 18:04 |
| | | */ |
| | | |
| | | @PostMapping("/export/city-type-sale") |
| | | Object cityTypeSaleExport(@RequestBody FilterObject filterObject) { |
| | | List<Map> list = saleOrderDetailService.selectCityTypeSaleExport(filterObject.getFilter()); |
| | | return success(list); |
| | | } |
| | | |
| | | /** |
| | | * @Description: 地州下的县区分类销售统计 |
| | | * @date 2022/1/29 18:04 |
| | | */ |
| | | |
| | | @PostMapping("/district-type-sale") |
| | | Object districtTypeSale(@RequestBody FilterObject filterObject) { |
| | | Integer pageIndex = filterObject.getPageIndex(); |
| | | Integer pageSize = filterObject.getPageSize(); |
| | | IPage page = saleOrderDetailService.selectDistrictTypeSale(new Page<>(pageIndex, pageSize), filterObject.getFilter()); |
| | | return success(page); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * @Description: 导出地州市分类销售统计 |
| | | * @date 2022/1/29 18:04 |
| | | */ |
| | | |
| | | @PostMapping("/export/district-type-sale") |
| | | Object districtTypeSaleExport(@RequestBody FilterObject filterObject) { |
| | | List<Map> list = saleOrderDetailService.selectDistrictTypeSaleExport(filterObject.getFilter()); |
| | | return success(list); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * @Description: 企业销售分类统计 |
| | | * @date 2022/1/29 13:02 |
| | | */ |
| | | @PostMapping("/enterprise-type-sale") |
| | | Object enterpriseTypeSale(@RequestBody FilterObject filterObject) { |
| | | Integer pageIndex = filterObject.getPageIndex(); |
| | | Integer pageSize = filterObject.getPageSize(); |
| | | IPage page = saleOrderDetailService.selectEnterpriseTypeSale(new Page<>(pageIndex, pageSize), filterObject.getFilter(), getUser()); |
| | | return success(page); |
| | | } |
| | | |
| | | /** |
| | | * @Description: 导出企业销售分类统计 |
| | | * @date 2022/1/29 15:15 |
| | | */ |
| | | @PostMapping("/export/enterprise-type-sale") |
| | | Object exportEnterpriseTypeSale(@RequestBody FilterObject filterObject) { |
| | | List<Map> res = saleOrderDetailService.selectExportEnterpriseTypeSale(filterObject.getFilter(), getUser()); |
| | | return success(res); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * @Description: 企业分类入库统计 |
| | | * @date 2022/1/29 15:19 |
| | | */ |
| | | @PostMapping("/enterprise-type-entry") |
| | | Object enterpriseTypeEntry(@RequestBody FilterObject filterObject) { |
| | | Integer pageIndex = filterObject.getPageIndex(); |
| | | Integer pageSize = filterObject.getPageSize(); |
| | | IPage page = entryDetailService.selectEnterpriseTypeEntry(new Page<>(pageIndex, pageSize), filterObject.getFilter(), getUser()); |
| | | return success(page); |
| | | } |
| | | |
| | | /** |
| | | * @Description: 导出企业分类入库统计 |
| | | * @date 2022/1/29 15:38 |
| | | */ |
| | | @PostMapping("/export/enterprise-type-entry") |
| | | Object exportEnterpriseTypeEntry(@RequestBody FilterObject filterObject) { |
| | | List<Map> res = entryDetailService.selectExportEnterpriseTypeEntry(filterObject.getFilter(), getUser()); |
| | | return success(res); |
| | | } |
| | | |
| | | /** |
| | | * @Description: 各地州分类入库统计 |
| | | * @date 2022/1/29 15:50 |
| | | */ |
| | | @PostMapping("/city-type-entry") |
| | | Object cityTypeEntry(@RequestBody FilterObject filterObject) { |
| | | Integer pageIndex = filterObject.getPageIndex(); |
| | | Integer pageSize = filterObject.getPageSize(); |
| | | IPage page = entryDetailService.selectCityTypeEntry(new Page<>(pageIndex, pageSize), filterObject.getFilter(), getUser()); |
| | | return success(page); |
| | | } |
| | | |
| | | /** |
| | | * @Description: 导出各地州分类入库统计 |
| | | * @date 2022/1/29 16:15 |
| | | */ |
| | | @PostMapping("/export/city-type-entry") |
| | | Object exportCityTypeEntry(@RequestBody FilterObject filterObject) { |
| | | List<Map> res = entryDetailService.selectExportCityTypeEntry(filterObject.getFilter(), getUser()); |
| | | return success(res); |
| | | } |
| | | |
| | | /** |
| | | * @Description: 企业分类出库统计 |
| | | * @date 2022/1/29 16:18 |
| | | */ |
| | | @PostMapping("/enterprise-type-delivery") |
| | | Object enterpriseTypeDelivery(@RequestBody FilterObject filterObject) { |
| | | Integer pageIndex = filterObject.getPageIndex(); |
| | | Integer pageSize = filterObject.getPageSize(); |
| | | IPage page = deliveryDetailService.selectEnterpriseTypeDelivery(new Page<>(pageIndex, pageSize), filterObject.getFilter(), getUser()); |
| | | return success(page); |
| | | } |
| | | |
| | | /** |
| | | * @Description: 导出企业分类出库统计 |
| | | * @date 2022/1/29 16:30 |
| | | */ |
| | | @PostMapping("/export/enterprise-type-delivery") |
| | | Object exportEnterpriseTypeDelivery(@RequestBody FilterObject filterObject) { |
| | | List<Map> res = deliveryDetailService.selectExportEnterpriseTypeDelivery(filterObject.getFilter(), getUser()); |
| | | return success(res); |
| | | } |
| | | |
| | | /** |
| | | * @Description: 各地州分类出库统计 |
| | | * @date 2022/1/29 16:35 |
| | | */ |
| | | @PostMapping("/city-type-delivery") |
| | | Object cityTypeDelivery(@RequestBody FilterObject filterObject) { |
| | | Integer pageIndex = filterObject.getPageIndex(); |
| | | Integer pageSize = filterObject.getPageSize(); |
| | | IPage page = deliveryDetailService.selectCityTypeDelivery(new Page<>(pageIndex, pageSize), filterObject.getFilter(), getUser()); |
| | | return success(page); |
| | | } |
| | | |
| | | /** |
| | | * @Description: 导出各地州分类出库统计 |
| | | * @date 2022/1/29 16:35 |
| | | */ |
| | | @PostMapping("/export/city-type-delivery") |
| | | Object exportCityTypeDelivery(@RequestBody FilterObject filterObject) { |
| | | List<Map> res = deliveryDetailService.selectExportCityTypeDelivery(filterObject.getFilter(), getUser()); |
| | | return success(res); |
| | | } |
| | | |
| | | /** |
| | | * @Description: 导出 |
| | | * @date 2022/1/29 16:39 |
| | | */ |
| | | |
| | | |
| | | @PostMapping("/city-inbound-outbound-detail") |
| | | @ApiOperation(value = "显示市下各个企业的详情") |
| | | @ApiImplicitParams({ |
| | | @ApiImplicitParam(name = "pageIndex", value = "页码"), |
| | | @ApiImplicitParam(name = "pageSize", value = "页大小"), |
| | | @ApiImplicitParam(name = "filter.starttime", value = "开始时间"), |
| | | @ApiImplicitParam(name = "filter.endtime", value = "结束时间"), |
| | | @ApiImplicitParam(name = "filter.safetysupervision", value = "企业类型"), |
| | | @ApiImplicitParam(name = "filter.city", value = "市"), |
| | | }) |
| | | Object getCityInAndOutDetail(@RequestBody FilterObject filterObject) { |
| | | Integer pageIndex = filterObject.getPageIndex(); |
| | | Integer pageSize = filterObject.getPageSize(); |
| | | //可以手写分页,查总数可以只查15个市 |
| | | IPage page = saleOrderDetailService.getCityInAndOutDetail(new Page<>(pageIndex, pageSize), filterObject.getFilter()); |
| | | return success(page); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * @Description: 标题数据 (零售店数量 今日销售数量 今年销售总量 今年购买人次) |
| | | * @date 2021/4/25 9:44 |
| | | */ |
| | | @GetMapping("/title-data") |
| | | @ApiOperation(value = "标题数据 (零售店数量 今日销售数量 今年销售总量 今年购买人次)") |
| | | Object getTitleData() { |
| | | Map data = saleOrderDetailService.getTitleData(); |
| | | return success(data); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * @Description: 性别统计购买 |
| | | * @date 2021/5/15 16:21 |
| | | */ |
| | | @PostMapping("/gender-sale") |
| | | Object getGenderSale(@RequestBody FilterObject filterObject) { |
| | | Integer pageIndex = filterObject.getPageIndex(); |
| | | Integer pageSize = filterObject.getPageSize(); |
| | | IPage page = saleOrderDetailService.getGenderSale(new Page<>(pageIndex, pageSize), filterObject.getFilter(), getUser()); |
| | | return success(page); |
| | | } |
| | | |
| | | /** |
| | | * @Description: 族别统计购买 |
| | | * @date 2021/5/15 16:39 |
| | | */ |
| | | @PostMapping("/race-sale") |
| | | Object getRaceSale(@RequestBody FilterObject filterObject) { |
| | | Integer pageIndex = filterObject.getPageIndex(); |
| | | Integer pageSize = filterObject.getPageSize(); |
| | | IPage page = saleOrderDetailService.getRaceSale(new Page<>(pageIndex, pageSize), filterObject.getFilter(), getUser()); |
| | | return success(page); |
| | | } |
| | | |
| | | /** |
| | | * @Description: 按年龄段 |
| | | * @date 2021/5/15 16:45 |
| | | */ |
| | | @PostMapping("/generation-sale") |
| | | Object getGenerationSale(@RequestBody FilterObject filterObject) { |
| | | List<Map> data = saleOrderDetailService.getGenerationSale(filterObject.getFilter(), getUser()); |
| | | return success(data); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * @Description: 证书分析 |
| | | * @date 2021/7/1 15:11 |
| | | */ |
| | | @PostMapping("/license") |
| | | Object getLicenseStatistic(@RequestBody FilterObject filterObject) { |
| | | Integer pageIndex = filterObject.getPageIndex(); |
| | | Integer pageSize = filterObject.getPageSize(); |
| | | IPage page = licenseService.selectLicenseStatistic(new Page<>(pageIndex, pageSize), filterObject.getFilter(), getUser()); |
| | | return success(page); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * @Description: 企业历史库存查询(年月日) |
| | | * @date 2022/2/8 15:15 |
| | | */ |
| | | @PostMapping("/stock/history") |
| | | Object getHistoryStock(@RequestBody FilterObject filterObject) { |
| | | Integer pageIndex = filterObject.getPageIndex(); |
| | | Integer pageSize = filterObject.getPageSize(); |
| | | IPage page = historyStockService.selectHistoryStock(new Page<>(pageIndex, pageSize), filterObject.getFilter(), getUser()); |
| | | return success(page); |
| | | |
| | | } |
| | | |
| | | @PostMapping("/export/stock/history") |
| | | Object getExportHistoryStock(@RequestBody FilterObject filterObject) { |
| | | List<Map> result = historyStockService.selectExportHistoryStock(filterObject.getFilter(), getUser()); |
| | | return success(result); |
| | | |
| | | } |
| | | |
| | | /** |
| | | * @Description: 各地州库存查询-staticstock |
| | | * @date 2022/2/8 15:40 |
| | | */ |
| | | @PostMapping("/city-stock") |
| | | Object getCityStock(@RequestBody FilterObject filterObject) { |
| | | Integer pageIndex = filterObject.getPageIndex(); |
| | | Integer pageSize = filterObject.getPageSize(); |
| | | IPage page = historyStockService.selectCityStock(new Page<>(pageIndex, pageSize), filterObject.getFilter(), getUser()); |
| | | return success(page); |
| | | } |
| | | |
| | | /** |
| | | * @Description: 各地州历史库存查询(年月日) |
| | | * @date 2022/2/8 16:06 |
| | | */ |
| | | @PostMapping("/history/city-stock") |
| | | Object getHistoryCityStock(@RequestBody FilterObject filterObject) { |
| | | Integer pageIndex = filterObject.getPageIndex(); |
| | | Integer pageSize = filterObject.getPageSize(); |
| | | IPage page = historyStockService.selectHistoryCityStock(new Page<>(pageIndex, pageSize), filterObject.getFilter(), getUser()); |
| | | return success(page); |
| | | } |
| | | } |