package models

import "fmt"

type Region struct {
	Id         int    `json:"id" gorm:"primary_key"`
	RegionName string `json:"region_name"`
	RegionId   string `json:"region_id"`
	RegionDesc string `json:"region_desc"`
}

func GetRegionList(vendorId int) (regionId []string) {
	db.Raw("SELECT DISTINCT region_id FROM region WHERE is_valid=1 AND vendor_id = ?;", vendorId).Pluck("region_id", &regionId)
	return
}

func GetRegionInfo(vendorId int) (region []Region) {
	selectSql := fmt.Sprintf(`SELECT * FROM region WHERE is_valid = 1 `)
	if vendorId != 0 {
		selectSql += fmt.Sprintf(` AND vendor_id = %d`, vendorId)
	}
	db.Raw(selectSql).Scan(&region)
	return
}