package services

import (
	"backend-linksee-api/models"
	"github.com/jinzhu/gorm"
)

func GetProject(db *gorm.DB, projId int64) models.ProjectInfo {
	var project models.ProjectInfo
	db.Where("project_auto_id = ?", projId).Where("project_is_delete = 0").Find(&project)
	return project
}

func GetProjectInfo(db *gorm.DB, projId int64) models.ProjectInfo {
	var project models.ProjectInfo
	db.Where("project_auto_id = ?", projId).Where("project_is_delete = 0").Find(&project)
	return project
}

/// 根据盒子ID查找到对应的项目信息
func GetProjectByBoxId(db *gorm.DB, boxId string) models.ProjectInfo {
	var project models.ProjectInfo
	sql := `SELECT b.project_auto_id, p.project_name, p.province, p.city, p.area, p.district, p.city_id, p.user_id, p.operator_id, p.distributor_id 
			FROM btk_box b 
			LEFT JOIN btk_project p 
			ON p.project_auto_id = b.project_auto_id 
			WHERE b.box_id = ? AND b.box_is_delete = 0 
			ORDER BY b.box_create_time DESC LIMIT 1`
	db.Raw(sql, boxId).Find(&project)
	return project
}