relationDB

type AlarmInfoFilter struct {
	Name string
}

type AlarmInfoRepo struct {
	// contains filtered or unexported fields
}

type AlarmRecordFilter struct {
	AlarmID       int64 // 告警配置ID
	AlarmName     string
	TriggerType   scene.TriggerType
	ProductID     string
	DeviceName    string
	DealStatus    scene.AlarmDealStatus
	DealStatuses  []scene.AlarmDealStatus
	Time          *def.TimeRange
	WithSceneInfo bool
}

type AlarmRecordRepo struct {
	// contains filtered or unexported fields
}

type AlarmSceneFilter struct {
	AlarmID       int64 // 告警配置ID
	SceneID       int64 // 场景ID
	WithAlarmInfo bool
	WithSceneInfo bool
}

type AlarmSceneRepo struct {
	// contains filtered or unexported fields
}

type DeviceTimerInfoFilter struct {
	Devices     []*devices.Core
	TriggerType string
	Status      int64
	ExecAt      *stores.Cmp
	LastRunTime *stores.Cmp
	Repeat      *stores.Cmp
}

type DeviceTimingInfoRepo struct {
	// contains filtered or unexported fields
}

type ExampleFilter struct {
}

type ExampleRepo struct {
	// contains filtered or unexported fields
}

type NotifyUser struct {
	TargetType def.TargetType
	TargetIDs  []int64
}

type SceneActionFilter struct {
	SceneID          int64
	ProductID        string
	DeviceName       string
	ActionDeviceType scene.ActionDeviceType
	DeviceSelectType scene.SelectType
}

type SceneActionRepo struct {
	// contains filtered or unexported fields
}

type SceneIfTriggerFilter struct {
	ID               int64
	SceneID          int64
	Status           int64
	ExecAt           *stores.Cmp
	LastRunTime      *stores.Cmp
	ExecRepeat       *stores.Cmp
	RepeatType       scene.RepeatType
	ExecLoopStart    *stores.Cmp
	ExecLoopEnd      *stores.Cmp
	ExecType         *stores.Cmp
	Type             string
	ProjectID        *stores.Cmp
	AreaID           *stores.Cmp
	Device           *devices.Core
	DataID           string
	FirstTriggerTime *stores.Cmp
	StateKeepType    scene.StateKeepType
	StateKeepValue   *stores.Cmp
}

type SceneIfTriggerRepo struct {
	// contains filtered or unexported fields
}

type SceneInfoFilter struct {
	Name          string `json:"name"`
	IDs           []int64
	Status        int64
	Type          string
	Tag           string
	IsCommon      def.Bool
	AreaID        int64
	DeviceMode    scene.DeviceMode //设备模式
	ProductID     string           //产品id
	DeviceName    string           //设备名
	HasActionType string           //过滤有某个执行类型
	ProjectID     int64
}

type SceneInfoRepo struct {
	// contains filtered or unexported fields
}

type SceneLogFilter struct {
	Time          *def.TimeRange
	Status        int64
	SceneID       int64
	WithSceneInfo bool
}

type SceneLogRepo struct {
	// contains filtered or unexported fields
}

type UdAlarmInfo struct {
	ID         int64             `gorm:"column:id;type:BIGINT;primary_key;AUTO_INCREMENT"`
	TenantCode stores.TenantCode `gorm:"column:tenant_code;type:VARCHAR(50);NOT NULL"`     // 租户编码
	ProjectID  stores.ProjectID  `gorm:"column:project_id;type:bigint;default:0;NOT NULL"` // 项目ID(雪花ID)
	Name       string            `gorm:"column:name;type:VARCHAR(100);NOT NULL"`
	Desc       string            `gorm:"column:desc;type:VARCHAR(100);NOT NULL"`
	Level      int64             `gorm:"column:level;type:SMALLINT;default:1"`                   // 告警配置级别（1提醒 2一般 3严重 4紧急 5超紧急）
	Status     int64             `gorm:"column:status;type:SMALLINT;default:1"`                  // 状态 1:启用,2:禁用
	Notifies   []*UdAlarmNotify  `gorm:"column:notifies;type:json;serializer:json;default:'[]'"` // 短信通知模版编码
	UserIDs    []int64           `gorm:"column:user_ids;type:json;serializer:json;default:'[]'"` //指定用户ID
	Accounts   []string          `gorm:"column:accounts;type:json;serializer:json;default:'[]'"` //账号
	Scenes     []*UdAlarmScene   `gorm:"foreignKey:AlarmID;references:ID"`
	stores.Time
}

type UdAlarmNotify struct {
	Type       string `json:"type"`       //通知类型
	TemplateID int64  `json:"templateID"` //模版code,不选就是默认的
}

type UdAlarmRecord struct {
	ID          int64                 `gorm:"column:id;type:BIGINT;primary_key;AUTO_INCREMENT"`
	TenantCode  stores.TenantCode     `gorm:"column:tenant_code;type:VARCHAR(50);NOT NULL"`     // 租户编码
	ProjectID   stores.ProjectID      `gorm:"column:project_id;type:bigint;default:0;NOT NULL"` // 项目ID(雪花ID)
	AlarmID     int64                 `gorm:"column:alarm_id;type:BIGINT;NOT NULL"`             //告警记录ID
	AlarmName   string                `gorm:"column:alarm_name;type:VARCHAR(100);NOT NULL"`     //告警名称
	TriggerType scene.TriggerType     `gorm:"column:trigger_type;type:VARCHAR(100);NOT NULL"`   //触发类型(设备触发1,其他2)
	ProductID   string                `gorm:"column:product_id;type:varchar(100);"`             //触发产品id
	DeviceName  string                `gorm:"column:device_name;type:varchar(100);"`            //触发设备名称
	Level       int64                 `gorm:"column:level;type:SMALLINT;NOT NULL"`              //告警配置级别（1提醒 2一般 3严重 4紧急 5超紧急）
	SceneName   string                `gorm:"column:scene_name;type:varchar(100);NOT NULL"`
	SceneID     int64                 `gorm:"column:scene_id;type:BIGINT;NOT NULL"`
	DealStatus  scene.AlarmDealStatus `gorm:"column:deal_status;type:SMALLINT;default:1;NOT NULL"` //告警记录状态（1告警中 2已忽略 3已处理）
	Desc        string                `gorm:"column:desc;type:varchar(100);"`
	WorkOrderID int64                 `gorm:"column:work_order_id;type:BIGINT;NOT NULL"` //工作流ID
	AlarmCount  int64                 `gorm:"column:alarm_count;type:BIGINT;default:1"`  //告警次数
	LastAlarm   time.Time             `gorm:"column:last_alarm;NOT NULL"`
	CreatedTime time.Time             `gorm:"column:created_time;default:CURRENT_TIMESTAMP;NOT NULL"`
}

type UdAlarmScene struct {
	ID         int64             `gorm:"column:id;type:BIGINT;primary_key;AUTO_INCREMENT"`
	TenantCode stores.TenantCode `gorm:"column:tenant_code;type:VARCHAR(50);NOT NULL"`     // 租户编码
	ProjectID  stores.ProjectID  `gorm:"column:project_id;type:bigint;default:0;NOT NULL"` // 项目ID(雪花ID)
	AlarmID    int64             `gorm:"column:alarm_id;uniqueIndex:ai_si;type:BIGINT;NOT NULL"`
	SceneID    int64             `gorm:"column:scene_id;uniqueIndex:ai_si;type:BIGINT;NOT NULL"`
	SceneInfo  *UdSceneInfo      `gorm:"foreignKey:ID;references:SceneID"`
	AlarmInfo  *UdAlarmInfo      `gorm:"foreignKey:ID;references:AlarmID"`
	stores.Time
}

type UdDeviceTimerInfo struct {
	ID          int64             `gorm:"column:id;type:bigint;primary_key;AUTO_INCREMENT"` // id编号
	TenantCode  stores.TenantCode `gorm:"column:tenant_code;type:VARCHAR(50);NOT NULL"`     // 租户编码
	ProjectID   stores.ProjectID  `gorm:"column:project_id;type:bigint;default:0;NOT NULL"` // 项目ID(雪花ID)
	ProductID   string            `gorm:"column:product_id;type:varchar(100);NOT NULL"`     // 产品id
	DeviceName  string            `gorm:"column:device_name;type:varchar(100);NOT NULL"`    // 设备名称
	DeviceAlias string            `gorm:"column:device_alias;type:varchar(100);NOT NULL"`   // 设备名称
	TriggerType string            `gorm:"column:trigger_type;type:varchar(25);NOT NULL"`    //触发类型 timer: 定时触发 delay: 延迟触发(延迟触发同时只能存在一个)
	ExecAt      int64             `gorm:"column:exec_at;type:bigint;NOT NULL"`              //执行时间 从0点加起来的秒数 如 1点就是 1*60*60
	ExecRepeat  int64             `gorm:"column:exec_repeat;type:bigint;default:0b1111111"` //重复 二进制周日到周六 11111111 这个参数只有定时触发才有
	ActionType  string            `gorm:"column:action_type;type:varchar(25);NOT NULL"`     //云端向设备发起属性控制: propertyControl  应用调用设备行为:action
	DataName    string            `gorm:"column:data_name;type:VARCHAR(500);NOT NULL"`      //对应的物模型定义,只读
	DataID      string            `gorm:"column:data_id;type:varchar(100);NOT NULL"`        //属性的id及行为的id
	Value       string            `gorm:"column:value;type:varchar(1024);default:NULL"`     //传的值
	Name        string            `gorm:"column:name;type:varchar(100);default:''"`         // 名称
	LastRunTime time.Time         `gorm:"column:last_run_time;index;default:CURRENT_TIMESTAMP;NOT NULL"`
	Status      int64             `gorm:"column:status;type:BIGINT;default:1"` //状态
	stores.SoftTime
}

type UdExample struct {
	ID int64 `gorm:"column:id;type:bigint;primary_key;AUTO_INCREMENT"` // id编号
}

type UdSceneActionDevice struct {
	//ProjectID        int64                  `gorm:"column:project_id;type:bigint;default:2;NOT NULL"`  // 项目ID(雪花ID)
	AreaID           int64                  `gorm:"column:area_id;type:bigint;default:2;"` // 项目区域ID(雪花ID)
	AreaName         string                 `gorm:"column:area_name;index;type:VARCHAR(100);default:''"`
	ProductID        string                 `gorm:"column:product_id;index;type:VARCHAR(25);default:''"`    //产品id
	ProductName      string                 `gorm:"column:product_name;index;type:VARCHAR(200);default:''"` //产品id
	SelectType       scene.SelectType       `gorm:"column:select_type;type:VARCHAR(25);default:''"`         //设备选择方式
	DeviceName       string                 `gorm:"column:device_name;type:VARCHAR(255);"`                  //选择的列表  选择的列表, fixed类型是设备名列表
	DeviceAlias      string                 `gorm:"column:device_alias;type:VARCHAR(255);"`                 //设备别名
	GroupID          int64                  `gorm:"column:group_id;index;type:bigint"`                      //group类型传GroupID
	Type             scene.ActionDeviceType `gorm:"column:type;type:VARCHAR(25);default:''"`
	DataID           string                 `gorm:"column:data_id;index;type:VARCHAR(100);default:''"`
	Value            string                 `gorm:"column:value;index;type:VARCHAR(500);default:''"`
	DataName         string                 `gorm:"column:data_name;type:VARCHAR(500);default:''"` //对应的物模型定义,只读
	SchemaAffordance string                 `gorm:"column:schema_affordance;type:VARCHAR(500);default:''"`
	Values           scene.DeviceValues     `gorm:"column:values;type:json;serializer:json"`
	Body             string                 `gorm:"column:body;type:VARCHAR(1024)"` // 自定义数据
}

type UdSceneActionScene struct {
	SceneID   int64           `gorm:"column:scene_id;index;type:bigint"` // 场景id编号
	AreaID    int64           `gorm:"column:area_id;type:bigint;"`       // 项目区域ID(雪花ID)
	SceneType scene.SceneType `gorm:"column:scene_type;type:VARCHAR(25);NOT NULL"`
	SceneName string          `gorm:"column:scene_name;type:VARCHAR(256);NOT NULL"`
	Status    def.Bool        `gorm:"column:status;type:BIGINT;default:1"` //状态
}

type UdSceneIf struct {
	Triggers []*UdSceneIfTrigger `gorm:"foreignKey:SceneID;references:ID"`
}

type UdSceneIfTrigger struct {
	ID              int64             `gorm:"column:id;type:bigint;primary_key;AUTO_INCREMENT"` // id编号
	Type            scene.TriggerType `gorm:"column:type;type:VARCHAR(25);NOT NULL"`            //触发类型 device: 设备触发 timer: 定时触发
	SceneID         int64             `gorm:"column:scene_id;index;type:bigint"`                // 场景id编号
	ProjectID       stores.ProjectID  `gorm:"column:project_id;type:bigint;default:1;"`         // 项目ID(雪花ID)
	AreaID          stores.AreaID     `gorm:"column:area_id;type:bigint;default:1;"`            // 项目区域ID(雪花ID)
	Order           int64             `gorm:"column:order;type:BIGINT;default:1;NOT NULL"`      // 排序序号
	Status          int64             `gorm:"column:status;type:BIGINT;default:1"`              //状态 同步场景联动的status
	LastRunTime     sql.NullTime      `gorm:"column:last_run_time;index;default: NULL"`         //最后执行时间
	LastTriggerTime sql.NullTime      `gorm:"column:last_trigger_time;index;default: NULL"`     //最后触发时间

	Device    UdSceneTriggerDevice  `gorm:"embedded;embeddedPrefix:device_"`
	Timer     UdSceneTriggerTimer   `gorm:"embedded;embeddedPrefix:timer_"`
	Weather   UdSceneTriggerWeather `gorm:"embedded;embeddedPrefix:weather_"`
	SceneInfo *UdSceneInfo          `gorm:"foreignKey:ID;references:SceneID"`
	stores.SoftTime
}

type UdSceneInfo struct {
	ID          int64             `gorm:"column:id;type:bigint;primary_key;AUTO_INCREMENT"`                       // id编号
	TenantCode  stores.TenantCode `gorm:"column:tenant_code;type:VARCHAR(50);NOT NULL"`                           // 租户编码
	ProjectID   stores.ProjectID  `gorm:"column:project_id;type:bigint;default:0;NOT NULL"`                       // 项目ID(雪花ID)
	AreaID      stores.AreaID     `gorm:"column:area_id;index:project_id_area_id;type:bigint;default:0;NOT NULL"` // 项目区域ID(雪花ID)
	FlowPath    []*scene.FlowInfo `gorm:"column:flow_path;type:json;serializer:json;"`                            //执行路径
	DeviceMode  scene.DeviceMode  `gorm:"column:device_mode;type:VARCHAR(50);default:'single'"`                   //设备模式
	ProductID   string            `gorm:"column:product_id;index;type:VARCHAR(25);default:''"`                    //产品id
	DeviceName  string            `gorm:"column:device_name;type:VARCHAR(255);default:''"`                        //设备名
	DeviceAlias string            `gorm:"column:device_alias;type:VARCHAR(255);default:''"`                       //设备别名
	Tag         string            `gorm:"column:tag;type:VARCHAR(128);NOT NULL;default:normal"`                   //标签 admin: 管理员 normal: 普通
	IsCommon    def.Bool          `gorm:"column:is_common;type:BIGINT;default:1"`                                 //是否是常用的
	HeadImg     string            `gorm:"column:head_img;type:VARCHAR(256);NOT NULL"`                             // 头像
	Logo        string            `gorm:"column:logo;type:VARCHAR(25);NOT NULL"`                                  // logo
	Name        string            `gorm:"column:name;type:varchar(100);NOT NULL"`                                 // 名称
	Desc        string            `gorm:"column:desc;type:varchar(200);NOT NULL"`                                 // 描述
	Type        scene.SceneType   `gorm:"column:type;type:VARCHAR(25);NOT NULL"`                                  //auto manual
	LastRunTime sql.NullTime      `gorm:"column:last_run_time;index;default:null"`
	Status      def.Bool          `gorm:"column:status;type:BIGINT;default:1"` //状态
	Body        string            `gorm:"column:body;type:VARCHAR(1024)"`      // 自定义数据
	UdSceneIf   `gorm:"embedded;embeddedPrefix:if_"`
	UdSceneWhen `gorm:"embedded;embeddedPrefix:when_"`
	UdSceneThen `gorm:"embedded;embeddedPrefix:then_"`
	stores.SoftTime
}

type UdSceneLog struct {
	ID         int64              `gorm:"column:id;type:bigint;primary_key;AUTO_INCREMENT"`    // id编号
	TenantCode stores.TenantCode  `gorm:"column:tenant_code;type:VARCHAR(50);NOT NULL"`        // 租户编码
	ProjectID  stores.ProjectID   `gorm:"column:project_id;type:bigint;default:0;NOT NULL"`    // 项目ID(雪花ID)
	AreaID     stores.AreaID      `gorm:"column:area_id;index;type:bigint;default:0;NOT NULL"` // 项目区域ID(雪花ID)
	SceneID    int64              `gorm:"column:scene_id;index;type:bigint;NOT NULL"`          // 项目区域ID(雪花ID)
	Type       scene.SceneType    `gorm:"column:type;type:VARCHAR(25);NOT NULL"`               //auto manual
	Trigger    *scene.LogTrigger  `gorm:"column:trigger;type:json;serializer:json"`
	Actions    []*scene.LogAction `gorm:"column:actions;type:json;serializer:json"`
	Status     def.Bool           `gorm:"column:status;type:BIGINT;default:1"` //状态
	SceneInfo  *UdSceneInfo       `gorm:"foreignKey:ID;references:SceneID"`
	stores.OnlyTime
}

type UdSceneThen struct {
	Actions []*UdSceneThenAction `gorm:"foreignKey:scene_id;references:ID"`
}

type UdSceneThenAction struct {
	ID         int64               `gorm:"column:id;type:bigint;primary_key;AUTO_INCREMENT"` // id编号
	TenantCode stores.TenantCode   `gorm:"column:tenant_code;type:VARCHAR(50);NOT NULL"`     // 租户编码
	SceneID    int64               `gorm:"column:scene_id;index;type:bigint"`                // 场景id编号
	Order      int64               `gorm:"column:order;type:BIGINT;default:1;NOT NULL"`      // 排序序号
	Type       scene.ActionType    `gorm:"column:type;type:VARCHAR(25);NOT NULL"`
	Delay      int64               `gorm:"column:delay;type:bigint"`
	Device     UdSceneActionDevice `gorm:"embedded;embeddedPrefix:device_"`
	Notify     *scene.ActionNotify `gorm:"column:notify;type:json;serializer:json"`
	Alarm      *scene.ActionAlarm  `gorm:"column:alarm;type:json;serializer:json"`
	Scene      UdSceneActionScene  `gorm:"embedded;embeddedPrefix:scene_"`
}

type UdSceneTriggerDevice struct {
	ProductID        string                  `gorm:"column:product_id;index;type:VARCHAR(25);default:''"`  //产品id
	SelectType       scene.SelectType        `gorm:"column:select_type;type:VARCHAR(25);default:''"`       //设备选择方式  all: 全部 fixed:指定的设备
	GroupID          int64                   `gorm:"column:group_id;index;type:bigint;default:0"`          //group类型传GroupID
	DeviceName       string                  `gorm:"column:device_name;type:VARCHAR(255);default:''"`      //选择的列表  选择的列表, fixed类型是设备名列表
	DeviceAlias      string                  `gorm:"column:device_alias;type:VARCHAR(255);default:''"`     //设备别名
	Type             scene.TriggerDeviceType `gorm:"column:type;type:VARCHAR(25);default:''"`              //触发类型  connected:上线 disConnected:下线 reportProperty:属性上报 reportEvent: 事件上报
	DataID           string                  `gorm:"column:data_id;type:VARCHAR(255);default:''"`          //选择为属性或事件时需要填该字段 属性的id及事件的id aa.bb.cc
	DataName         string                  `gorm:"column:data_name;type:VARCHAR(255);default:''"`        //对应的物模型定义,只读
	TermType         string                  `gorm:"column:term_type;type:VARCHAR(255);default:''"`        //动态条件类型  eq: 相等  not:不相等  btw:在xx之间  gt: 大于  gte:大于等于 lt:小于  lte:小于等于   in:在xx值之间
	Values           []string                `gorm:"column:values;type:json;serializer:json;default:'[]'"` //比较条件列表
	SchemaAffordance string                  `gorm:"column:schema_affordance;type:VARCHAR(500);default:''"`
	Body             string                  `gorm:"column:body;type:VARCHAR(1024)"` // 自定义数据
	StateKeep        UdStateKeep             `gorm:"embedded;embeddedPrefix:state_keep_"`
	FirstTriggerTime sql.NullTime            `gorm:"column:first_trigger_time;index;default: NULL"` //最后触发时间
}

type UdSceneTriggerTimer struct {
	ExecType      scene.ExecType   `gorm:"column:exec_type;type:VARCHAR(25);"`  //执行方式
	ExecAdd       int64            `gorm:"column:exec_add;type:bigint;"`        //如果是日出日落模式,则为日出日落前后的秒数
	ExecAt        int64            `gorm:"column:exec_at;type:bigint;"`         //执行时间 从0点加起来的秒数 如 1点就是 1*60*60
	ExecRepeat    int64            `gorm:"column:exec_repeat;type:bigint;"`     //重复 二进制周日到周六 11111111 这个参数只有定时触发才有
	ExecLoopStart int64            `gorm:"column:exec_loop_start;type:bigint;"` //循环执行起始时间配置
	ExecLoopEnd   int64            `gorm:"column:exec_loop_end;type:bigint;"`
	ExecLoop      int64            `gorm:"column:exec_loop;type:bigint;"`
	RepeatType    scene.RepeatType `gorm:"column:repeat_type;type:VARCHAR(25);"`
}

type UdSceneTriggerWeather struct {
	Type             scene.WeatherType `gorm:"column:type;type:VARCHAR(25);default:''"`              //天气的类型
	TermType         string            `gorm:"column:term_type;type:VARCHAR(255);default:''"`        //动态条件类型  eq: 相等  not:不相等  btw:在xx之间  gt: 大于  gte:大于等于 lt:小于  lte:小于等于   in:在xx值之间
	Values           []string          `gorm:"column:values;type:json;serializer:json;default:'[]'"` //条件值 参数根据动态条件类型会有多个参数
	FirstTriggerTime sql.NullTime      `gorm:"column:first_trigger_time;index;default: NULL"`        //最后触发时间
}

type UdSceneWhen struct {
	ValidRanges   scene.WhenRanges `gorm:"column:validRanges;type:json;serializer:json"`
	InvalidRanges scene.WhenRanges `gorm:"column:invalidRanges;type:json;serializer:json"`
	Conditions    scene.Conditions `gorm:"column:conditions;type:json;serializer:json"`
}

type UdStateKeep struct {
	Type  scene.StateKeepType `gorm:"column:type;type:VARCHAR(25);default:''"` //持续时间: duration  重复次数 repeating
	Value int64               `gorm:"column:value;type:bigint;default:0"`      //持续的时间或重复的次数
}