From b1d7efd8c4ab9c4bf56f62e636a358a5182c09bf Mon Sep 17 00:00:00 2001
From: zhangzengfei <zhangzengfei@smartai.com>
Date: 星期六, 28 九月 2024 23:43:58 +0800
Subject: [PATCH] fix db colummn
---
db/models.go | 154 ++++----------------------------------------------
1 files changed, 14 insertions(+), 140 deletions(-)
diff --git a/db/models.go b/db/models.go
index 67af5ca..52eef2e 100644
--- a/db/models.go
+++ b/db/models.go
@@ -1,18 +1,21 @@
package db
-import (
- "time"
+type BuildingType int
+
+const (
+ BuildingTypeResidential BuildingType = 1 //浣忓畢妤�
+ BuildingTypeMixedUse BuildingType = 2 //鍟嗕綇妤�
+ BuildingTypePublicRental BuildingType = 3 //鍏鎴�
+ BuildingTypeLowIncome BuildingType = 4 //寤夌鎴�
+ BuildingTypeOldResidential BuildingType = 5 //鑰佹棫灏忓尯
+ BuildingTypeOffice BuildingType = 6 //鍐欏瓧妤�
)
-type PersonnelStatusRule struct {
- ID int `gorm:"column:id"`
- Name string `gorm:"column:name"`
- DetectionCountStart int `gorm:"column:detectionCountStart"`
- DetectionCountEnd int `gorm:"column:detectionCountEnd"`
- DetectionDaysStart int `gorm:"column:detectionDaysStart"`
- DetectionDaysEnd int `gorm:"column:detectionDaysEnd"`
- Status string `gorm:"column:status"`
-}
+const (
+ StatusStranger int = 1
+ StatusVisitor int = 2
+ StatusResident int = 3
+)
type AlarmRule struct {
RuleId string `json:"ruleId"`
@@ -29,120 +32,6 @@
TargetType string `json:"targetType"`
Floor string `json:"floor"`
}
-
-type BuildingType int
-
-const (
- BuildingTypeResidential BuildingType = 1 //浣忓畢妤�
- BuildingTypeMixedUse BuildingType = 2 //鍟嗕綇妤�
- BuildingTypePublicRental BuildingType = 3 //鍏鎴�
- BuildingTypeLowIncome BuildingType = 4 //寤夌鎴�
- BuildingTypeOldResidential BuildingType = 5 //鑰佹棫灏忓尯
- BuildingTypeOffice BuildingType = 6 //鍐欏瓧妤�
-)
-
-//type status int
-
-const (
- StatusStranger int = 1
- StatusVisitor int = 2
- StatusResident int = 3
-)
-
-type Device struct {
- DeviceCode string `gorm:"column:deviceCode" json:"deviceCode" example:"J83762"` //璁惧缂栫爜
- AreaID string `json:"areaID" gorm:"index;column:communityID;type:varchar(299);"` //甯镐綇灏忓尯 domain unit ID
- BuildingType BuildingType `gorm:"column:building_type;type:tinyint(1);not null;default:0" json:"buildingType"` //妤煎畤绫诲瀷
- MaxBuildingFloor int `gorm:"column:max_building_floor;type:tinyint(1);not null;default:0" json:"maxBuildingFloor"` //鏈�楂樻ゼ灞傚彿
-}
-
-type Task struct {
- Id int `gorm:"column:id"`
- Name string `gorm:"name"`
-}
-
-func (Task) TableName() string {
- return "task"
-}
-
-type MoveInout struct {
- //RecordId int `gorm:"column:record_id"`
- DocumentNumber string `gorm:"column:document_number"`
- CommunityID string `gorm:"column:community_id"`
- MoveInDate time.Time `gorm:"column:move_in_date"`
- MoveOutDate *time.Time `gorm:"column:move_out_date"`
- Status string `gorm:"column:status"`
- MoveType string `gorm:"column:move_type"`
-}
-
-func (MoveInout) TableName() string {
- return "move_inout"
-}
-
-type Resident struct {
- CommunityId string `gorm:"column:community_id"`
- DocumentNumber string `gorm:"column:document_number"`
- LastAppearanceTime int64 `gorm:"column:last_appearance_time"`
- CreateAt string `gorm:"column:create_at"`
-}
-
-type PersonStatus struct {
- Id uint `gorm:"column:id;primary_key;auto_increment;not null;"`
- OrgId string `gorm:"column:org_id;type:varchar(299);not null;default:''"` // 娲惧嚭鎵�id
- CommunityID string `gorm:"uniqueIndex:idx_document_number_community_id;index:community_id_last_appearance_time;column:community_id;type:varchar(299);not null;default:''"` // 灏忓尯id
- DocumentNumber string `gorm:"uniqueIndex:idx_document_number_community_id;column:document_number;type:varchar(299);not null;default:''"` // 妗ｆ缂栧彿
- DaysAppeared int `gorm:"column:days_appeared;type:int(11);not null;default:0" json:"daysAppeared"` // 鍑虹幇澶╂暟
- Count int `gorm:"column:count;type:int;not null;default:0"` // 鎶撴媿娆℃暟
- Status string `gorm:"column:status;type:varchar(255);not null;default:''"` //鏍囩
- LastAppearanceTime int64 `gorm:"index:community_id_last_appearance_time;column:last_appearance_time;type:int;not null;default:0" json:"lastAppearanceTime"` //鏈�鍚庡嚭鐜版椂闂�
- LastAppearanceStatusTime int64 `gorm:"column:last_appearance_status_time"`
- LastLocation string `gorm:"column:last_location;type:varchar(255);not null;default:''" json:"lastLocation"` //鏈�鍚庡嚭鐜板湴鐐�
- FrequentAddress string `gorm:"column:frequent_address;type:varchar(255);not null;default:''" json:"frequentAddress"` //甯稿嚭鐜板湴鐐�
- CreatedAt time.Time
- UpdatedAt time.Time
- NewStatus string `gorm:"-"`
- ////OrgId string `gorm:"column:org_id"`
- //CommunityID string `gorm:"column:communityID"`
- //DocumentNumber string `gorm:"column:documentNumber"`
- //Status string `gorm:"column:status"`
- //FrequentAddress string `gorm:"column:frequentAddress"`
-}
-
-func (PersonStatus) TableName() string {
- return "snapshot_count_summary"
-}
-
-type LabelManage struct {
- Id int `gorm:"id"`
- Name string `gorm:"name"`
- ValidDays int `gorm:"valid_days"`
-}
-
-func (LabelManage) TableName() string {
- return "label_manage"
-}
-
-type Identity struct {
- CreatedAt time.Time
- UpdatedAt time.Time
- CommunityID string `gorm:"column:community_id"`
- DocumentNumber string `gorm:"column:dbtablepersons_id"`
- LabelId int `gorm:"column:label_id"`
- ExpireTime int64 `gorm:"column:expire_time"`
-}
-
-func (Identity) TableName() string {
- return "dbtablepersons_label"
-}
-
-//
-//type ModelMatix struct {
-// CommunityID string
-// DocumentNumber string
-// CaptureDate string
-// Status string
-// FrequentAddress string
-//}
type StatusPersonMapping struct {
Status string
@@ -163,19 +52,4 @@
CaptureDate string `json:"captureDate"`
CaptureAddress string `json:"captureAddress"`
Direction string `json:"direction"`
-}
-
-type PublicHouse struct {
- ID int `gorm:"primaryKey;autoIncrement" json:"id"` // 涓婚敭ID
- CommunityID string `gorm:"column:community_id;type:varchar(255)" json:"community_id"` // 灏忓尯ID
- Applicant string `gorm:"column:applicant;type:varchar(255)" json:"applicant"` // 鐢宠浜�
- IdCard string `gorm:"column:id_card;type:varchar(50)" json:"id_card"` // 璇佷欢缂栧彿
- PhoneNumber string `gorm:"column:phone_number;type:varchar(20)" json:"phone_number"` // 鑱旂郴鐢佃瘽
- Address string `gorm:"column:address;type:varchar(255)" json:"address"` // 鎴垮眿鍦板潃
- ApplicationTime string `gorm:"column:application_time" json:"application_time"` // 鐢宠鏃堕棿
- EndTime string `gorm:"column:end_time" json:"end_time"` // 缁撴潫鏃堕棿
-}
-
-func (PublicHouse) TableName() string {
- return "public_house"
}
--
Gitblit v1.8.0