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 allLocation = enterpriseService.getAllLocation(city); return success(allLocation); } /** * @Description: 零售点数量按区域统计 * @date 2021/4/16 14:52 */ @GetMapping("/retail-statistics-area") @ApiOperation(value = "零售点数量按区域统计") Object getRetailStatisticsByArea() { List 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 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 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 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 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 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 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 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 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 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 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 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 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 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); } }