package com.ruoyi.report.controller;

import java.io.File;
import java.io.FileOutputStream;
import java.io.OutputStream;
import java.util.Arrays;
import java.util.List;

import javax.servlet.http.HttpServletResponse;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.web.bind.annotation.DeleteMapping;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.PutMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.ruoyi.common.annotation.Log;
import com.ruoyi.common.core.controller.BaseController;
import com.ruoyi.common.core.domain.AjaxResult;
import com.ruoyi.common.core.page.TableDataInfo;
import com.ruoyi.common.enums.BusinessType;
import com.ruoyi.common.utils.poi.ExcelUtil;
import com.ruoyi.report.domain.RzlInventStatisticsInfo;
import com.ruoyi.report.service.IRzlInventStatisticsInfoExcel;
import com.ruoyi.report.service.IRzlInventStatisticsInfoService;

/**
 * 专利有效-万人发明拥有量统计Controller
 *
 * @author ruoyi
 * @date 2023-03-26
 */
@RestController
@RequestMapping("/report/rzlInventStatisticsInfo")
public class RzlInventStatisticsInfoController extends BaseController {
    private final IRzlInventStatisticsInfoService rzlInventStatisticsInfoService;
    
    @Autowired
    private IRzlInventStatisticsInfoExcel rzlInventStatisticsInfoExcel;

    public RzlInventStatisticsInfoController(IRzlInventStatisticsInfoService rzlInventStatisticsInfoService) {
        this.rzlInventStatisticsInfoService = rzlInventStatisticsInfoService;
    }

    /**
     * 查询专利有效-万人发明拥有量统计列表
     *
     * @param rzlInventStatisticsInfo 专利有效-万人发明拥有量统计
     * @return 专利有效-万人发明拥有量统计集合
     * @date 2023-03-26
     */
    @PreAuthorize("@ss.hasPermi('report:rzlInventStatisticsInfo:list')")
    @GetMapping("/list")
    public TableDataInfo list(RzlInventStatisticsInfo rzlInventStatisticsInfo) {
//        startPage();
//        List<RzlInventStatisticsInfo> list = rzlInventStatisticsInfoService.queryList(rzlInventStatisticsInfo);
    	 List<RzlInventStatisticsInfo> list = rzlInventStatisticsInfoService.listByReport(rzlInventStatisticsInfo);
       
//    	 
//	        try {
//				OutputStream out=new FileOutputStream(new File("D:\\temp\\exp.xlsx"));
//				
//				rzlInventStatisticsInfoExcel.doExport(out,rzlInventStatisticsInfo,list);
//				
//				
//			} catch (Exception e) {
//				// TODO Auto-generated catch block
//				e.printStackTrace();
//			}
    	 
        return getDataTable(list);
    }

    

    /**
     * 导出专利有效-万人发明拥有量统计列表
     *
     * @param rzlInventStatisticsInfo 专利有效-万人发明拥有量统计
     * @date 2023-03-26
     */
    @PreAuthorize("@ss.hasPermi('report:rzlInventStatisticsInfo:export')")
    @Log(title = "专利有效-万人发明拥有量统计", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, RzlInventStatisticsInfo rzlInventStatisticsInfo) {

//      startPage();
//      List<RzlInventStatisticsInfo> list = rzlInventStatisticsInfoService.queryList(rzlInventStatisticsInfo);
  	 List<RzlInventStatisticsInfo> list = rzlInventStatisticsInfoService.listByReport(rzlInventStatisticsInfo);

		response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
		response.setCharacterEncoding("utf-8");
//  	 
	        try {
				
				rzlInventStatisticsInfoExcel.doExport(response.getOutputStream(),rzlInventStatisticsInfo,list);
				
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
				logger.error("导出失败,"+e.getMessage(),e);
				throw new RuntimeException("导出失败，请联系管理员",e);
			}
  	 
  
    }

    /**
     * 获取专利有效-万人发明拥有量统计详细信息
     *
     * @param id 主键id
     * @return 结果
     * @date 2023-03-26
     */
    @PreAuthorize("@ss.hasPermi('report:rzlInventStatisticsInfo:query')")
    @GetMapping(value = "/{id}")
    public AjaxResult getInfo(@PathVariable("id") Long id) {
        return AjaxResult.success(rzlInventStatisticsInfoService.getById(id));
    }


    /**
     * 新增专利有效-万人发明拥有量统计信息
     *
     * @param rzlInventStatisticsInfo 专利有效-万人发明拥有量统计
     * @return 结果
     * @date 2023-03-26
     */
    @PreAuthorize("@ss.hasPermi('report:rzlInventStatisticsInfo:add')")
    @Log(title = "专利有效-万人发明拥有量统计", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody RzlInventStatisticsInfo rzlInventStatisticsInfo) {
        return toAjax(rzlInventStatisticsInfoService.save(rzlInventStatisticsInfo));
    }


    /**
     * 修改专利有效-万人发明拥有量统计信息
     *
     * @param rzlInventStatisticsInfo 专利有效-万人发明拥有量统计
     * @return 结果
     * @date 2023-03-26
     */
    @PreAuthorize("@ss.hasPermi('report:rzlInventStatisticsInfo:edit')")
    @Log(title = "专利有效-万人发明拥有量统计", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody RzlInventStatisticsInfo rzlInventStatisticsInfo) {
        return toAjax(rzlInventStatisticsInfoService.updateById(rzlInventStatisticsInfo));
    }


    /**
     * 删除专利有效-万人发明拥有量统计信息
     *
     * @param ids 主键ids
     * @return 结果
     * @date 2023-03-26
     */
    @PreAuthorize("@ss.hasPermi('report:rzlInventStatisticsInfo:remove')")
    @Log(title = "专利有效-万人发明拥有量统计", businessType = BusinessType.DELETE)
    @DeleteMapping("/{ids}")
    public AjaxResult remove(@PathVariable Long[] ids) {
        return toAjax(rzlInventStatisticsInfoService.removeByIds(Arrays.asList(ids)));
    }


}
