package models

import "fmt"

type Project struct {
	Id          int    `json:"id" gorm:"primary_key"`
	ProjectName string `json:"project_name"`
	ProjectId   string `json:"project_id"`
	ProjectDesc string `json:"project_desc"`
	VendorId    int    `json:"vendor_id"`
	Owner       string `json:"owner"`
}

func GetProjectList(vendorId int) (projectId []string) {
	db.Raw("SELECT DISTINCT project_id FROM project WHERE is_valid=1 AND vendor_id = ?;", vendorId).Pluck("project_id", &projectId)
	return
}

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