| | |
| | | import cn.afterturn.easypoi.excel.entity.TemplateExportParams; |
| | | import cn.hutool.core.io.resource.ClassPathResource; |
| | | import com.baomidou.mybatisplus.core.toolkit.Wrappers; |
| | | import com.ruoyi.common.annotation.Log; |
| | | import com.ruoyi.common.basic.PageInfo; |
| | | import com.ruoyi.common.core.domain.AjaxResult; |
| | | import com.ruoyi.common.enums.BusinessType; |
| | | import com.ruoyi.common.utils.DateUtils; |
| | | import com.ruoyi.common.utils.StringUtils; |
| | | import com.ruoyi.common.utils.WebUtils; |
| | |
| | | } |
| | | return AjaxResult.success(profitDetailsVO); |
| | | } |
| | | |
| | | @Log(title = "统计-盈利明细导出", businessType = BusinessType.UPDATE) |
| | | @ApiOperation( value = "盈利明细导出") |
| | | @PostMapping(value = "/profitDetailsExport") |
| | | public void profitDetailsExport(@RequestBody ProfitDetailsQuery query) { |
| | |
| | | return AjaxResult.success(personnelStatisticsAndSumVO); |
| | | } |
| | | |
| | | |
| | | @Log(title = "统计-汇总导出", businessType = BusinessType.UPDATE) |
| | | @ApiOperation( value = "汇总导出") |
| | | @PostMapping(value = "/sumExport") |
| | | public void sumExport(@RequestBody ProfitDetailsQuery query) { |
| | |
| | | } |
| | | } |
| | | |
| | | sumGeneratorClient.setGeneratorTime(DateUtils.stringToLocalDate(query.getStartTime()) + " ~ " + DateUtils.stringToLocalDate(query.getEndTime())); |
| | | sumGeneratorClient = orderMealService.sumExport(query); |
| | | sumGeneratorClient.setGeneratorTime(DateUtils.stringToLocalDateTime(query.getStartTime()).toLocalDate() + " ~ " + DateUtils.stringToLocalDateTime(query.getEndTime()).toLocalDate()); |
| | | TShop shop = shopService.getById(objectId); |
| | | if(Objects.nonNull(shop)){ |
| | | sumGeneratorClient.setShopName(shop.getShopName()); |
| | | } |
| | | sumGeneratorClient = orderSaleService.sumExport(query); |
| | | result.put("sumGeneratorClient",sumGeneratorClient); |
| | | //1.获取excel模板 |
| | | ClassPathResource classPathResource = new ClassPathResource("template/营业统计报表.xls"); |