12345678910111213141516171819202122232425262728293031 |
- 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
- }
|