From 9bf9c64da2f0babb3313ba6b6b27c2f15bf62592 Mon Sep 17 00:00:00 2001
From: zhangzengfei <zhangzengfei@smartai.com>
Date: 星期二, 11 二月 2025 11:04:58 +0800
Subject: [PATCH] 完善模型参数,修复bug

---
 models/accessRegularity.go |  111 +++++++++++++++++++++++++++++++++++++++++++------------
 1 files changed, 87 insertions(+), 24 deletions(-)

diff --git a/models/accessRegularity.go b/models/accessRegularity.go
index 54d5850..26c021d 100644
--- a/models/accessRegularity.go
+++ b/models/accessRegularity.go
@@ -94,7 +94,7 @@
 		return fmt.Errorf("task id:%s, %s timeRange Time range setting error. %+v", task.ID, task.Name, task.Rules)
 	}
 
-	logger.Debugf("LocationModel init finish ...task id:%s, name:%s, rule:%+v", task.ID, task.Name, m)
+	logger.Debugf("AccessRegularity init finish ...task id:%s, name:%s, rule:%+v", task.ID, task.Name, m)
 
 	return nil
 }
@@ -110,51 +110,53 @@
 		SELECT
 			document_number,
 			frequent_address,
-			community_id,
+			community_id
 		FROM
 			snapshot_count_summary
 		WHERE
-			last_appearance_time > ? "" 
-			AND (p.community_id IN ?
-			OR p.org_id IN ?)
-			AND p.status IN ?
+			last_appearance_time > ?
+			AND (community_id IN ?
+			OR org_id IN ?)
+			AND status IN ?
 		`, startDate.Unix(), m.AreaIds, m.OrgIds, m.IdentityType).Scan(&baseFilter).Error
 	if err != nil {
 		logger.Warnf(err.Error())
 	}
 
+	logger.Debugf("task %s base filter result %d", m.Task.Name, len(baseFilter))
 	esCli := db.GetEsClient()
 	for _, p := range baseFilter {
 		// 璋冪敤es鍒嗘瀽姝や汉鐨勫嚭琛岃寰嬫槸鍚︾鍚堟潯浠讹紝 杩斿洖绗﹀悎鏉′欢鐨勬鏁板拰鏈�鍚庝竴娆$鍚堟潯浠剁殑鏃堕棿
 		sTime := startDate.Format(time.DateTime)
 		eTime := time.Now().Format(time.DateTime)
 		captures, err := service.QueryEsRecord(esCli, sTime, eTime, nil, []interface{}{p.CommunityId}, []string{p.DocumentNumber})
+		//logger.Debugf("task %s person %s captures %d", m.Task.Name, p.DocumentNumber, len(captures))
+
 		if len(captures) == 0 || err != nil {
 			continue
 		}
+		//logger.Debugf("task %s person %s captures %+v", m.Task.Name, p.DocumentNumber, captures[0])
 
 		// 鏍规嵁鎶撴媿鏃堕棿鍜屽嚭鍏ユ柟鍚戯紝璁$畻绗﹀悎瑙勫垯鍐呯殑鍑哄叆娆℃暟
-		hitCount := 0
+		hitCount, pd := countValidDays(captures, m.StartHour, m.EndHour, m.LastDirection)
 
-		//for _, c := range captures {
-		//	captureTime, err := time.ParseInLocation(time.DateTime, c.PicDate, time.Local)
-		//}
+		if hitCount > m.Appearances {
+			// 鍐欐暟鎹簱
+			result := &db.ModelTaskResults{
+				Title:         m.Task.Name,
+				Event:         fmt.Sprintf("%s %d娆�", m.Task.Name, hitCount),
+				ModelID:       m.Task.ModelID,
+				ModelTaskID:   m.Task.ID,
+				CommunityId:   p.CommunityId,
+				OrgID:         p.OrgId,
+				ObjectIds:     p.DocumentNumber,
+				Location:      p.FrequentAddress,
+				PicDate:       pd,
+				FirstPersonID: p.DocumentNumber,
+			}
 
-		// 鍐欐暟鎹簱
-		result := &db.ModelTaskResults{
-			Title:         m.Task.Name,
-			Event:         fmt.Sprintf("%s %d娆�", m.Task.Name, hitCount),
-			ModelID:       m.Task.ModelID,
-			ModelTaskID:   m.Task.ID,
-			CommunityId:   p.CommunityId,
-			OrgID:         p.OrgId,
-			ObjectIds:     p.DocumentNumber,
-			Location:      p.FrequentAddress,
-			PicDate:       time.Unix(p.LastAppearanceTime, 0).Format(time.DateTime),
-			FirstPersonID: p.DocumentNumber,
+			results = append(results, result)
 		}
-
-		results = append(results, result)
 	}
 
 	logger.Debugf("task %s last filter result %d", m.Task.Name, len(results))
@@ -175,3 +177,64 @@
 func (m *RegularityModel) eventFormat() string {
 	return ""
 }
+
+func countValidDays(records []*service.ESRecordInfo, startHour, endHour int, direction string) (int, string) {
+	layout := "2006-01-02 15:04:05"             // 鏃堕棿鏍煎紡
+	lastDirectionMap := make(map[string]string) // 璁板綍鏈�鍚庝竴鏉� Direction
+	lastTimeMap := make(map[string]time.Time)   // 璁板綍鏈�鍚庝竴鏉℃椂闂�
+	lastPicDate := ""
+
+	// 鍒ゆ柇鏄惁璺ㄥぉ
+	var isCrossDay bool
+	if endHour < startHour {
+		isCrossDay = true
+	}
+
+	for _, record := range records {
+		// 瑙f瀽鏃堕棿
+		t, err := time.Parse(layout, record.PicDate)
+		if err != nil {
+			fmt.Println("瑙f瀽鏃堕棿澶辫触:", err)
+			continue
+		}
+
+		// 鑾峰彇灏忔椂
+		hour := t.Hour()
+		var key string
+
+		if !isCrossDay {
+			// 鍒ゆ柇鏃堕棿鑼冨洿锛屽苟褰掑睘鍒版煇涓�澶�
+			if hour >= startHour && hour < endHour {
+				key = t.Format("2006-01-02")
+			} else {
+				continue // 涓嶅湪缁熻鑼冨洿鍐�
+			}
+		} else {
+			// 鍒ゆ柇鏃堕棿鑼冨洿锛屽苟褰掑睘鍒版煇涓�澶�
+			if hour >= startHour { // 21:00-23:59 褰掑睘褰撳ぉ
+				key = t.Format("2006-01-02")
+			} else if hour < endHour { // 00:00-02:59 褰掑睘鍓嶄竴澶�
+				key = t.AddDate(0, 0, -1).Format("2006-01-02")
+			} else {
+				continue // 涓嶅湪缁熻鑼冨洿鍐�
+			}
+		}
+
+		// 璁板綍璇ユ椂闂存鍐呯殑鏈�鍚庝竴鏉℃暟鎹�
+		if lastTime, exists := lastTimeMap[key]; !exists || t.After(lastTime) {
+			lastTimeMap[key] = t
+			lastDirectionMap[key] = record.CameraLocation.Direction
+			lastPicDate = record.PicDate
+		}
+	}
+
+	// 缁熻绗﹀悎鏉′欢
+	count := 0
+	for _, dir := range lastDirectionMap {
+		if dir == direction || direction == "" {
+			count++
+		}
+	}
+
+	return count, lastPicDate
+}

--
Gitblit v1.8.0