123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101 |
- package example
- import (
- "github.com/flipped-aurora/gin-vue-admin/server/global"
- "github.com/flipped-aurora/gin-vue-admin/server/model/common/response"
- "github.com/flipped-aurora/gin-vue-admin/server/model/example"
- "github.com/flipped-aurora/gin-vue-admin/server/utils"
- "github.com/gin-gonic/gin"
- "go.uber.org/zap"
- )
- type ExcelApi struct {
- }
- func (e *ExcelApi) ExportExcel(c *gin.Context) {
- var excelInfo example.ExcelInfo
- _ = c.ShouldBindJSON(&excelInfo)
- filePath := global.GVA_CONFIG.Excel.Dir + excelInfo.FileName
- err := excelService.ParseInfoList2Excel(excelInfo.InfoList, filePath)
- if err != nil {
- global.GVA_LOG.Error("转换Excel失败!", zap.Any("err", err))
- response.FailWithMessage("转换Excel失败", c)
- return
- }
- c.Writer.Header().Add("success", "true")
- c.File(filePath)
- }
- func (e *ExcelApi) ImportExcel(c *gin.Context) {
- _, header, err := c.Request.FormFile("file")
- if err != nil {
- global.GVA_LOG.Error("接收文件失败!", zap.Any("err", err))
- response.FailWithMessage("接收文件失败", c)
- return
- }
- _ = c.SaveUploadedFile(header, global.GVA_CONFIG.Excel.Dir+"ExcelImport.xlsx")
- response.OkWithMessage("导入成功", c)
- }
- func (e *ExcelApi) LoadExcel(c *gin.Context) {
- menus, err := excelService.ParseExcel2InfoList()
- if err != nil {
- global.GVA_LOG.Error("加载数据失败!", zap.Any("err", err))
- response.FailWithMessage("加载数据失败", c)
- return
- }
- response.OkWithDetailed(response.PageResult{
- List: menus,
- Total: int64(len(menus)),
- Page: 1,
- PageSize: 999,
- }, "加载数据成功", c)
- }
- func (e *ExcelApi) DownloadTemplate(c *gin.Context) {
- fileName := c.Query("fileName")
- filePath := global.GVA_CONFIG.Excel.Dir + fileName
- ok, err := utils.PathExists(filePath)
- if !ok || err != nil {
- global.GVA_LOG.Error("文件不存在!", zap.Any("err", err))
- response.FailWithMessage("文件不存在", c)
- return
- }
- c.Writer.Header().Add("success", "true")
- c.File(filePath)
- }
|