package models

import "fmt"

type Zone struct {
	Id       int    `json:"id" gorm:"primary_key"`
	ZoneName string `json:"zone_name"`
	ZoneId   string `json:"zone_id"`
	ZoneDesc string `json:"zone_desc"`
	VendorId int    `json:"vendor_id"`
	RegionId int    `json:"region_id"`
}

func GetZoneInfo(vendorId int, regionId string) (zone []Zone) {
	selectSql := fmt.Sprintf(`SELECT * FROM zone WHERE is_valid = 1 `)
	if vendorId != 0 {
		selectSql += fmt.Sprintf(` AND vendor_id = %d`, vendorId)
	}
	if regionId != "" {
		selectSql += fmt.Sprintf(` AND region_id = (select id from region where region_id='%s')`, regionId)
	}
	db.Raw(selectSql).Scan(&zone)
	return
}