Function ExportChannels

controller/channel_export.go:13–97

(c *gin.Context)

)

func ExportChannels(c *gin.Context) {
	// 获取所有渠道数据
	channels, err := model.GetAllChannels(0, 0, true, false)
	if err != nil {
		common.ApiError(c, err)
		return
	}

	// 创建Excel文件
	f := excelize.NewFile()
	defer func() {
		if err := f.Close(); err != nil {
			common.SysError("Error closing Excel file: " + err.Error())
		}
	}()

	// 创建工作表
	sheetName := "Channels"
	f.SetSheetName("Sheet1", sheetName)

	// 设置表头
	headers := []string{
		"ID", "名称", "类型", "状态", "密钥", "组织", "测试模型",
		"权重", "创建时间", "测试时间", "响应时间", "基础URL", "其他",
		"余额", "余额更新时间", "模型", "分组", "已用配额",
		"模型映射", "状态码映射", "优先级", "自动禁用", "标签", "额外设置", "参数覆盖",
	}

	for i, header := range headers {
		cell, _ := excelize.CoordinatesToCellName(i+1, 1)
		f.SetCellValue(sheetName, cell, header)
	}

	// 填充数据
	for i, channel := range channels {
		row := i + 2 // 从第二行开始填充数据
		data := []interface{}{
			channel.Id,
			channel.Name,
			channel.Type,
			channel.Status,
			channel.Key,
			channel.OpenAIOrganization,
			channel.TestModel,
			channel.Weight,
			channel.CreatedTime,
			channel.TestTime,
			channel.ResponseTime,
			channel.BaseURL,
			channel.Other,
			channel.Balance,
			channel.BalanceUpdatedTime,
			channel.Models,
			channel.Group,
			channel.UsedQuota,
			channel.ModelMapping,
			channel.StatusCodeMapping,
			channel.Priority,