package user_m import ( "git.hilo.cn/hilo-common/domain" "git.hilo.cn/hilo-common/resource/mysql" "gorm.io/gorm" "hilo-group/myerr" ) // 获取用户的国家,和所属的区域(是否阿语区) // 默认国家给沙特 func GetUserCountryArea(model *domain.Model, id mysql.ID) (string, int, error) { type info struct { Name string Area int } res := new(info) if err := model.DB().Raw("select name, area from res_country where name = (select country from user where id = ?)", id).First(&res).Error; err != nil { if err != gorm.ErrRecordNotFound { return "", 0, myerr.WrapErr(err) } // gorm.ErrRecordNotFound return "KSA", 1, nil } return res.Name, res.Area, nil }