海政通
blame | 历史 | 补丁 | 提交 | 提交对比 | show whitespace
liujie
2025-09-04 925deb2faa2f2fa39b501dc18a1667aa830ad683 
 ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TErpGoodsController.java


@@ -1,25 +1,47 @@


package com.ruoyi.web.controller.api;






import cn.afterturn.easypoi.excel.ExcelExportUtil;


import cn.afterturn.easypoi.excel.ExcelImportUtil;


import cn.afterturn.easypoi.excel.entity.ExportParams;


import cn.afterturn.easypoi.excel.entity.ImportParams;


import com.alibaba.fastjson2.JSONObject;


import com.baomidou.mybatisplus.core.toolkit.Wrappers;


import com.ruoyi.common.basic.PageInfo;


import com.ruoyi.common.core.domain.AjaxResult;


import com.ruoyi.common.core.domain.R;


import com.ruoyi.common.core.domain.entity.SysUser;


import com.ruoyi.common.core.exception.ServiceException;


import com.ruoyi.common.utils.WebUtils;


import com.ruoyi.framework.web.service.TokenService;


import com.ruoyi.system.dto.TErpGoodsAddDto;


import com.ruoyi.system.dto.TErpGoodsInfoSaveDto;


import com.ruoyi.system.dto.TErpGoodsUpdateStatusDto;


import com.ruoyi.system.importExcel.TErpGoodsExcel;


import com.ruoyi.system.model.TErpGoods;


import com.ruoyi.system.query.TErpGoodsQuery;


import com.ruoyi.system.service.TErpGoodsService;


import com.ruoyi.system.vo.TErpGoodsVO;


import com.ruoyi.web.controller.tool.ImportExcelUtil;


import io.swagger.annotations.Api;


import io.swagger.annotations.ApiOperation;


import org.apache.poi.ss.usermodel.Workbook;


import org.springframework.beans.BeanUtils;


import org.springframework.beans.factory.annotation.Autowired;


import org.springframework.util.StringUtils;


import org.springframework.validation.annotation.Validated;


import org.springframework.web.bind.annotation.*;


import org.springframework.web.multipart.MultipartFile;




import javax.servlet.ServletOutputStream;


import javax.servlet.http.HttpServletResponse;


import javax.validation.Valid;


import java.io.IOException;


import java.io.InputStream;


import java.net.URLEncoder;


import java.text.SimpleDateFormat;


import java.time.LocalDate;


import java.util.*;




/**


 * <p>


@@ -117,6 +139,70 @@


        return R.ok(goods);


    }




    @ApiOperation(value = "商品管理信息导出--导出")


    @PostMapping("/export")


    public void listExport(@RequestBody TErpGoodsQuery query)


    {


        SysUser user = tokenService.getLoginUser().getUser();


        List<TErpGoodsVO> pageList = erpGoodsService.listExport(query,user);


        Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams(), TErpGoodsVO.class, pageList);


        HttpServletResponse response = WebUtils.response();


        assert response != null;


        response.setContentType("application/vnd.ms-excel");


        response.setCharacterEncoding("utf-8");


        ServletOutputStream outputStream = null;


        try {


            String fileName = URLEncoder.encode("商品管理信息导出.xls", "utf-8");


            response.setHeader("Content-Disposition", "attachment;filename=" + fileName);


            response.setContentType("application/vnd.ms-excel;charset=UTF-8");


            response.setHeader("Pragma", "no-cache");


            response.setHeader("Cache-Control", "no-cache");


            outputStream = response.getOutputStream();


            workbook.write(outputStream);


        } catch (IOException e) {


            e.printStackTrace();


        } finally {


            try {


                outputStream.close();


            } catch (IOException e) {


                e.printStackTrace();


            }


        }


    }






    @ApiOperation(value = "商品管理信息导入")


    @PostMapping("/importFile")


    public AjaxResult importFile(@RequestParam(value = "file") MultipartFile file ) {




        SysUser user = tokenService.getLoginUser().getUser();


        JSONObject jsonObject = new JSONObject();


        ImportParams params = new ImportParams();


        params.setHeadRows(1); //表头行数


        String msg = null;


        InputStream inputStream = null;


        TErpGoods goods = new TErpGoods();


        try {


            inputStream = file.getInputStream();


            List<TErpGoodsExcel> carAnnuallyImportExcels = ExcelImportUtil.importExcel(inputStream, TErpGoodsExcel.class, params);


            // 处理车辆数据


            for (TErpGoodsExcel erpGoodsExcel : carAnnuallyImportExcels) {


                System.out.println(erpGoodsExcel);


            }


        } catch (Exception e) {


            e.printStackTrace();


            return AjaxResult.error("车辆年检记录导入失败!");


        }finally {


            try {


                inputStream.close();


            } catch (IOException e) {


                throw new ServiceException(e.getMessage());


            }


        }


        return AjaxResult.success(jsonObject);




    }






}