package com.dingzhuo.energy.project.reportForm.controller;

import java.io.*;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.List;
import java.util.UUID;

import com.dingzhuo.energy.common.utils.SecurityUtils;
import com.dingzhuo.energy.common.utils.time.TimeManager;
import com.dingzhuo.energy.framework.config.RuoYiConfig;
import com.dingzhuo.energy.project.reportForm.domain.JtZhnhExcel;
import org.apache.commons.io.FileUtils;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.springframework.core.io.ClassPathResource;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.util.ClassUtils;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.PutMapping;
import org.springframework.web.bind.annotation.DeleteMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import com.dingzhuo.energy.framework.aspectj.lang.annotation.Log;
import com.dingzhuo.energy.framework.aspectj.lang.enums.BusinessType;
import com.dingzhuo.energy.project.reportForm.domain.consolidatedStatements;
import com.dingzhuo.energy.project.reportForm.service.IconsolidatedStatementsService;
import com.dingzhuo.energy.framework.web.controller.BaseController;
import com.dingzhuo.energy.framework.web.domain.AjaxResult;
import com.dingzhuo.energy.common.utils.poi.ExcelUtil;
import com.dingzhuo.energy.framework.web.page.TableDataInfo;

import javax.servlet.ServletContext;

/**
 * 焦化工序综合报表Controller
 * 
 * @author sys
 * @date 2021-01-15
 */
@RestController
@RequestMapping("/reportForm/consolidatedStatements")
public class consolidatedStatementsController extends BaseController
{
    @Autowired
    private IconsolidatedStatementsService consolidatedStatementsService;

    /**
     * 查询焦化工序综合报表列表
     */
    @PreAuthorize("@ss.hasPermi('reportForm:consolidatedStatements:list')")
    @GetMapping("/list")
    public AjaxResult list(consolidatedStatements consolidatedStatements)
    {
        List<consolidatedStatements> list = consolidatedStatementsService.selectconsolidatedStatementsList(consolidatedStatements);
        return AjaxResult.success(list);
    }

    /**
     * 获取焦化工序综合报表详细信息
     */
    @PreAuthorize("@ss.hasPermi('reportForm:consolidatedStatements:query')")
    @GetMapping(value = "/{id}")
    public AjaxResult getInfo(@PathVariable("id") String id)
    {
        return AjaxResult.success(consolidatedStatementsService.selectconsolidatedStatementsById(id));
    }

    /**
     * 新增焦化工序综合报表
     */
    @PreAuthorize("@ss.hasPermi('reportForm:consolidatedStatements:add')")
    @Log(title = "焦化工序综合报表", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody consolidatedStatements consolidatedStatements) throws ParseException {
        consolidatedStatements.setId(UUID.randomUUID().toString());
        consolidatedStatements.setCreateBy(SecurityUtils.getUsername());
        return toAjax(consolidatedStatementsService.insertconsolidatedStatements(consolidatedStatements));
    }

    /**
     * 修改焦化工序综合报表
     */
    @PreAuthorize("@ss.hasPermi('reportForm:consolidatedStatements:edit')")
    @Log(title = "焦化工序综合报表", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody consolidatedStatements consolidatedStatements)
    {
        return toAjax(consolidatedStatementsService.updateconsolidatedStatements(consolidatedStatements));
    }

    /**
     * 删除焦化工序综合报表
     */
    @PreAuthorize("@ss.hasPermi('reportForm:consolidatedStatements:remove')")
    @Log(title = "焦化工序综合报表", businessType = BusinessType.DELETE)
	@DeleteMapping("/{ids}")
    public AjaxResult remove(@PathVariable String[] ids)
    {
        return toAjax(consolidatedStatementsService.deleteconsolidatedStatementsByIds(ids));
    }
    /**
     * 导出焦化工序综合报表列表
     */
    @PreAuthorize("@ss.hasPermi('reportForm:consolidatedStatements:export')")
    @Log(title = "焦化工序综合报表", businessType = BusinessType.EXPORT)
    @GetMapping("/export")
    public AjaxResult export(consolidatedStatements consolidatedStatements)
    {
        List<consolidatedStatements> list = consolidatedStatementsService.selectconsolidatedStatementsList(consolidatedStatements);
        /*ExcelUtil<consolidatedStatements> util = new ExcelUtil<consolidatedStatements>(consolidatedStatements.class);
        return util.exportExcel(list, "consolidatedStatements");*/
        String downLoadFilePaht = null;
        if(list.size()>0){
            JtZhnhExcel excelout=new JtZhnhExcel();
            downLoadFilePaht=excelout.writeExcel(RuoYiConfig.getDownloadPath() + "jhnhrep.xlsx",list);
        }
        return AjaxResult.success(downLoadFilePaht);
    }
}