youngee_mc_api/app/service/youngee_talent_service/info_tables.go

package youngee_talent_service

import (
	"youngmini_server/app/dao"
	"youngmini_server/app/model"
	"youngmini_server/app/model/youngee_talent_model"

	"github.com/gogf/gf/frame/g"
)

func GetInfoTables() *TalentHttpResult {
	allInfos := youngee_talent_model.InfoTables{}
	//Scan 将查询结果扫描到提供的变量中
	err := g.DB().Model(model.InfoTalentAgeBracket{}).Scan(&allInfos.AgeBracket)
	if err != nil {
		return &TalentHttpResult{Code: -1, Msg: "query age bracket failed"}
	}

	err = g.DB().Model(model.InfoTalentSkilledArea{}).Scan(&allInfos.SkilledArea)
	if err != nil {
		return &TalentHttpResult{Code: -2, Msg: "query skilled area failed"}
	}

	err = g.DB().Model(model.InfoProductType{}).Scan(&allInfos.ProductType)
	if err != nil {
		return &TalentHttpResult{Code: -3, Msg: "query product type failed"}
	}

	err = g.DB().Model(model.InfoTaskStage{}).OrderAsc(dao.InfoTaskStage.Columns.TaskStageId).Scan(&allInfos.TaskStage)
	if err != nil {
		return &TalentHttpResult{Code: -4, Msg: "query infoTask stage failed"}
	}

	err = g.DB().Model(model.InfoBank{}).Scan(&allInfos.Bank)
	if err != nil {
		return &TalentHttpResult{Code: -5, Msg: "query bank failed"}
	}

	err = g.DB().Model(model.InfoMessage{}).Scan(&allInfos.MessageInfo)
	if err != nil {
		return &TalentHttpResult{Code: -6, Msg: "query skilled area failed"}
	}

	err = g.DB().Model(model.InfoSectaskStage{}).OrderAsc(dao.InfoSectaskStage.Columns.TaskStageId).Scan(&allInfos.SecTaskStage)
	if err != nil {
		return &TalentHttpResult{Code: -7, Msg: "query InfoSectaskStage failed"}
	}

	err = g.DB().Model(dao.InfoThirdPlatform.Table).Fields(
		dao.InfoThirdPlatform.Columns.PlatformId,
		dao.InfoThirdPlatform.Columns.PlatformIcon,
		dao.InfoThirdPlatform.Columns.PlatformName).OrderAsc(dao.InfoThirdPlatform.Columns.PlatformId).Scan(&allInfos.ThirdPlatform)

	if err != nil {
		return &TalentHttpResult{Code: -7, Msg: "query third platform info failed"}
	}

	return &TalentHttpResult{Code: 0, Msg: "success", Data: allInfos}
}