| | |
| | | import com.ruoyi.basic.pojo.Customer; |
| | | import com.ruoyi.common.utils.poi.ExcelUtil; |
| | | import com.ruoyi.device.pojo.DeviceLedger; |
| | | import com.ruoyi.equipmentenergyconsumption.dto.EquipmentEnergyConsumptionDto; |
| | | import com.ruoyi.equipmentenergyconsumption.pojo.EquipmentEnergyConsumption; |
| | | import com.ruoyi.equipmentenergyconsumption.service.EquipmentEnergyConsumptionService; |
| | | import com.ruoyi.framework.aspectj.lang.annotation.Log; |
| | |
| | | import com.ruoyi.framework.web.domain.AjaxResult; |
| | | import io.swagger.annotations.Api; |
| | | import io.swagger.annotations.ApiOperation; |
| | | import org.springframework.beans.BeanUtils; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.util.CollectionUtils; |
| | | import org.springframework.web.bind.annotation.*; |
| | | import org.springframework.web.multipart.MultipartFile; |
| | | |
| | | import javax.servlet.http.HttpServletResponse; |
| | | import java.util.ArrayList; |
| | | import java.util.List; |
| | | |
| | | /** |
| | |
| | | @PostMapping("/export") |
| | | @ApiOperation("导出设备能耗") |
| | | public void export(HttpServletResponse response) { |
| | | Page page = new Page<>(-1,-1); |
| | | EquipmentEnergyConsumption equipmentEnergyConsumption = new EquipmentEnergyConsumption(); |
| | | IPage<EquipmentEnergyConsumption> listPage = equipmentEnergyConsumptionService.listPage(page, equipmentEnergyConsumption); |
| | | ExcelUtil<EquipmentEnergyConsumption> util = new ExcelUtil<EquipmentEnergyConsumption>(EquipmentEnergyConsumption.class); |
| | | util.exportExcel(response, null , "客户档案数据"); |
| | | util.exportExcel(response, listPage.getRecords() , "导出设备能耗"); |
| | | } |
| | | |
| | | @GetMapping("/listPageByTrend") |
| | |
| | | return AjaxResult.success(listPage); |
| | | } |
| | | |
| | | /** |
| | | * 导出能源趋势 |
| | | */ |
| | | @Log(title = "导出能源趋势", businessType = BusinessType.EXPORT) |
| | | @PostMapping("/exportTwo") |
| | | @ApiOperation("导出能源趋势") |
| | | public void exportTwo(HttpServletResponse response) { |
| | | Page page = new Page<>(-1,-1); |
| | | EquipmentEnergyConsumption equipmentEnergyConsumption = new EquipmentEnergyConsumption(); |
| | | IPage<EquipmentEnergyConsumption> listPage = equipmentEnergyConsumptionService.listPageByTrend(page, equipmentEnergyConsumption); |
| | | List<EquipmentEnergyConsumptionDto> list = new ArrayList<>(); |
| | | listPage.getRecords().forEach(item -> { |
| | | EquipmentEnergyConsumptionDto dto = new EquipmentEnergyConsumptionDto(); |
| | | BeanUtils.copyProperties(item, dto); |
| | | list.add(dto); |
| | | }); |
| | | ExcelUtil<EquipmentEnergyConsumptionDto> util = new ExcelUtil<EquipmentEnergyConsumptionDto>(EquipmentEnergyConsumptionDto.class); |
| | | util.exportExcel(response, list , "导出能源趋势"); |
| | | } |
| | | |
| | | |
| | | |
| | | } |