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