smart_intersectionV2.0/server/dao/dev_event.go

package dao

import "server/global"

type Event struct {
	global.GVA_MODEL
	Sn   string `gorm:"type:varchar(64)" json:"sn"`   //雷达sn（实际上是LED的SN）
	Type string `gorm:"type:varchar(64)" json:"type"` //事件类型
	Time string `gorm:"type:varchar(64)" json:"time"` //触发事件的时间
}

func (Event) TableName() string {
	return "dev_event"
}

func QueryEventByUserId(userId int) (data interface{}, err error) {
	var results []struct {
		Event
		ProjectName string
		ScreensName string
	}

	err = global.GVA_DB.Table("dev_event").
		Select("dev_event.*, project.project_name, dev_screens.screens_name").
		Joins("LEFT JOIN dev_screens ON dev_screens.sn = dev_event.sn").
		Joins("LEFT JOIN project ON project.id = dev_screens.project_id").
		Joins("LEFT JOIN user_project ON user_project.project_id = project.id").
		Where("user_project.sys_user_id = ?", userId).
		Order("dev_event.id DESC").
		Scan(&results).Error
	if err != nil {
		return nil, err
	}
	return results, err
}