From b93d95a77ae3681a8c97859f446644190e84170e Mon Sep 17 00:00:00 2001 From: zhangzengfei <zhangzengfei@smartai.com> Date: 星期四, 22 八月 2024 14:44:06 +0800 Subject: [PATCH] 添加摄像机运行方向 --- models/positions.go | 8 +++++++- 1 files changed, 7 insertions(+), 1 deletions(-) diff --git a/models/positions.go b/models/positions.go index d3a6cb1..b957033 100644 --- a/models/positions.go +++ b/models/positions.go @@ -6,6 +6,7 @@ Id uint `gorm:"column:id;primary_key;auto_increment;unique;not null;"` DeviceId string `gorm:"column:device_id;index" json:"device_id"` Pos string `gorm:"column:pos" json:"pos"` + RunDir int `gorm:"column:run_dir" json:"run_dir"` CreateTime int64 `gorm:"column:create_time;index"` TimeString string `gorm:"column:time_string;"` } @@ -17,8 +18,13 @@ func (d *Positions) Save() error { return db.Table(d.TableName()).Save(d).Error } + func (d *Positions) FindDevicePosition(devId string, timestamp int64) error { - return db.Table(d.TableName()).Where("device_id = ? AND create_time <= ?", devId, timestamp).Order("create_time desc").First(&d).Error + return db.Table(d.TableName()).Where("device_id = ? AND create_time <= ?", devId, timestamp).Order("id desc").First(&d).Error +} + +func (d *Positions) FindMovePosition(id uint, pos string) error { + return db.Table(d.TableName()).Where("id > ? AND pos != ?", id, pos).First(&d).Error } func (d *Positions) FindPositionByTime(timestamp int64) error { -- Gitblit v1.8.0