File size: 59,803 Bytes
e43efe5
 
 
372df3b
e43efe5
372df3b
e43efe5
0ec3e91
a1ac6b6
0ec3e91
 
 
 
b4edf75
372df3b
 
0ec3e91
 
 
 
 
 
 
 
 
 
 
 
 
 
9579649
c7b565a
372df3b
 
 
 
 
 
 
de7240f
 
 
 
 
 
372df3b
 
 
 
 
 
 
 
 
 
 
 
0ec3e91
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
9579649
a1ac6b6
e43efe5
c7b565a
372df3b
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
e43efe5
 
 
372df3b
 
 
 
 
 
b4edf75
e43efe5
b4edf75
 
de7240f
 
 
 
d0bc0e9
 
b4edf75
9579649
b4edf75
 
 
 
 
a1ac6b6
e43efe5
 
 
 
372df3b
b4edf75
 
 
 
372df3b
b4edf75
e43efe5
372df3b
 
e43efe5
 
 
372df3b
e43efe5
 
372df3b
e43efe5
 
372df3b
 
 
c7b565a
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
372df3b
c090a97
372df3b
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
b3139df
372df3b
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
c7b565a
372df3b
c7b565a
372df3b
 
 
b3139df
372df3b
 
 
b3139df
 
c090a97
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
e43efe5
de7240f
 
 
 
71996b7
372df3b
 
 
de7240f
0ec3e91
de7240f
 
 
 
372df3b
de7240f
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
71996b7
 
 
372df3b
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
c7b565a
372df3b
 
 
 
 
 
 
 
c7b565a
372df3b
 
 
 
 
 
c7b565a
372df3b
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
0ec3e91
372df3b
 
 
 
 
 
 
 
 
 
0ec3e91
 
d0bc0e9
6e9f4a9
0ec3e91
 
 
372df3b
 
6e9f4a9
 
 
 
 
 
 
 
 
 
 
 
 
0ec3e91
6e9f4a9
 
 
 
 
 
 
0ec3e91
 
6e9f4a9
0ec3e91
 
 
d0bc0e9
0ec3e91
6e9f4a9
0ec3e91
372df3b
0ec3e91
 
 
372df3b
0ec3e91
 
 
 
 
 
 
 
 
 
 
 
372df3b
0ec3e91
 
 
 
 
 
 
372df3b
0ec3e91
a1ac6b6
372df3b
 
 
a1ac6b6
372df3b
a1ac6b6
 
 
 
7a8ea17
372df3b
a1ac6b6
c7b565a
a1ac6b6
 
372df3b
a1ac6b6
78c8043
372df3b
e43efe5
 
 
 
372df3b
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
e43efe5
 
372df3b
 
 
e43efe5
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
0b9117b
 
 
 
 
 
 
 
 
 
e43efe5
 
372df3b
0b9117b
e43efe5
372df3b
e43efe5
 
372df3b
e43efe5
 
372df3b
 
 
e43efe5
 
 
 
ec8e90f
 
e43efe5
 
 
372df3b
e43efe5
372df3b
 
 
 
 
 
 
 
 
 
e43efe5
 
372df3b
e43efe5
 
372df3b
 
 
 
9579649
372df3b
 
de7240f
 
372df3b
9579649
e43efe5
 
 
 
 
372df3b
 
e43efe5
372df3b
e43efe5
a1ac6b6
372df3b
a1ac6b6
 
372df3b
de7240f
e43efe5
372df3b
e43efe5
372df3b
a6049f1
372df3b
e43efe5
372df3b
 
e43efe5
372df3b
de7240f
e43efe5
372df3b
 
de7240f
e43efe5
372df3b
 
 
de7240f
e43efe5
372df3b
78c8043
a6049f1
372df3b
 
a6049f1
372df3b
78c8043
372df3b
d0bc0e9
78c8043
372df3b
e43efe5
372df3b
 
 
b3139df
 
 
 
372df3b
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
c7b565a
 
 
 
 
 
 
 
 
 
 
 
 
 
372df3b
 
e43efe5
372df3b
e43efe5
372df3b
e43efe5
0ec3e91
e43efe5
 
 
 
 
9004f29
 
d0bc0e9
 
 
 
 
 
 
 
 
 
 
 
 
 
 
e43efe5
 
8c2ddd7
d0bc0e9
 
8c2ddd7
de7240f
e43efe5
 
 
372df3b
e43efe5
 
 
 
 
 
d0bc0e9
e43efe5
 
d0bc0e9
 
 
 
 
 
 
 
 
 
de7240f
d0bc0e9
 
 
 
 
 
 
 
 
 
 
 
372df3b
d0bc0e9
a1ac6b6
d0bc0e9
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
372df3b
d0bc0e9
 
 
372df3b
d0bc0e9
 
 
 
372df3b
d0bc0e9
372df3b
 
 
1a6973f
d0bc0e9
372df3b
d0bc0e9
c7b565a
d0bc0e9
c7b565a
 
 
1a6973f
d0bc0e9
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
372df3b
d0bc0e9
e43efe5
0ec3e91
 
372df3b
e43efe5
a1ac6b6
 
c7b565a
 
 
372df3b
d0bc0e9
e43efe5
372df3b
 
d0bc0e9
372df3b
de7240f
372df3b
c7b565a
 
372df3b
b34ca99
e43efe5
372df3b
 
 
 
e43efe5
 
 
 
7456a3f
372df3b
 
 
 
7456a3f
e43efe5
 
78c8043
 
 
 
372df3b
e43efe5
 
 
7456a3f
372df3b
 
 
 
 
 
 
b3139df
372df3b
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
c7b565a
 
c090a97
 
c7b565a
 
c090a97
 
 
 
 
 
 
c7b565a
372df3b
 
 
 
 
 
b3139df
c7b565a
372df3b
b3139df
372df3b
 
 
b3139df
c7b565a
372df3b
b3139df
c7b565a
372df3b
b3139df
c7b565a
372df3b
b3139df
c7b565a
372df3b
b3139df
372df3b
 
 
c7b565a
e43efe5
 
8c2ddd7
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
1001
1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
1026
1027
1028
1029
1030
1031
1032
1033
1034
1035
1036
1037
import gradio as gr
import datetime
import pandas as pd
import warnings
import joblib
import hdbscan
import numpy as np
import logger_service
import os
import urllib.request
import matplotlib.pyplot as plt
import seaborn as sns
import matplotlib.font_manager as fm
import shutil
import io
import base64

# --- 🌟 解決 Matplotlib 中文顯示問題 ---
font_path = 'SimHei.ttf'
if not os.path.exists(font_path):
    try:
        print("📥 正在下載中文字型...")
        urllib.request.urlretrieve('https://github.com/StellarCN/scp_zh/raw/master/fonts/SimHei.ttf', font_path)
    except Exception as e:
        print(f"⚠️ 字型下載失敗: {e}")

if os.path.exists(font_path):
    fm.fontManager.addfont(font_path)
    plt.rc('font', family='SimHei')
plt.rcParams['axes.unicode_minus'] = False

# Seaborn 近期會對舊的 pandas option 發出 FutureWarning
warnings.filterwarnings(
    "ignore",
    category=FutureWarning,
    message="use_inf_as_na option is deprecated*",
)

# --- 全域統計與狀態變數 ---
global_stats = {
    "total_count": 0,
    "abnormal_count": 0,
    "start_time": datetime.datetime.now()
}

system_weights = {
    "ow": 75.0, "tw": 80.0, "iw": 65.0, 
    "dw": 45.0, "gw": 50.0, "fw": 60.0
}

def update_system_weights(ow, tw, iw, dw, gw, fw):
    system_weights.update({
        "ow": float(ow), "tw": float(tw), "iw": float(iw), 
        "dw": float(dw), "gw": float(gw), "fw": float(fw)
    })
    return f"✅ 系統權重已更新 - 總體: {ow}%, 時間: {tw}%, IP: {iw}%, 裝置: {dw}%, 地理: {gw}%, 頻率: {fw}%"

ACTION_MAP = {
    "教務系統: 期末網路教學評量": "click_eval_system",
    "教務系統: 期末網路預選系統": "click_pre_select_system",
    "教務系統: 開學後加退選系統": "click_add_drop_system",
    "教務系統: 北科i學園PLUS": "click_istudy",
    "教務系統: 學生證掛失及補發系統": "click_card_loss",
    "教務系統: 課程系統": "click_course_system",
    "教務系統: 學業成績查詢系統": "click_score_query",
    "學務系統: 學生請假系統": "click_leave_system",
    "學務系統: 學生宿舍登錄(抽籤)系統": "click_dorm_system",
    "學務系統: 獎助學金申請系統": "click_scholarship",
    "資訊服務: 網路郵局 WebMail": "click_webmail",
    "資訊服務: 北科軟體雲": "click_vdesk",
    "惡意測試: 嘗試偷改成績 (SQL Injection)": "malicious_sql_injection"
}

log_history = []
initial_df_abn = pd.DataFrame(columns=["timestamp", "ip_address", "cookie_id", "account", "role", "action", "status"])

# HDBSCAN 特徵分群用的 IP 分類
def get_ip_category(ip_str):
    ip = str(ip_str).split(" ")[0]
    if ip.startswith("140.124."): return 0.0    
    elif ip.startswith("61.228."): return 1.0   
    elif ip.startswith("210.61."): return 2.0   
    elif ip.startswith("45.33."): return 3.0    
    else: return 4.0  

def get_geo_level(ip_str):
    ip = str(ip_str).split(" ")[0]
    if ip == "140.124.71.55": return 0       
    elif ip == "140.124.18.22": return 1     
    elif ip.startswith("61.228."): return 2  
    elif ip.startswith("210.61."): return 3  
    elif ip.startswith("45.33."): return 4   
    else: return 5                           

# --- 1. 載入模型與歷史資料 ---
try:
    le_action = joblib.load('le_action.pkl')
    
    print("📂 正在讀取本地歷史資料庫...")
    if os.path.exists('baseline_logs.csv'): 
        baseline_df = pd.read_csv('baseline_logs.csv')
    else: 
        baseline_df = pd.DataFrame(columns=["timestamp", "ip_address", "cookie_id", "account", "role", "action", "status"])
        baseline_df.to_csv('baseline_logs.csv', index=False)

    baseline_df['timestamp'] = pd.to_datetime(baseline_df['timestamp'])
    baseline_df['clean_ip'] = baseline_df['ip_address'].astype(str).apply(lambda x: x.split(" ")[0])
    
    global_stats["total_count"] = len(baseline_df)
    global_stats["abnormal_count"] = baseline_df[baseline_df['status'].str.contains("異常", na=False)].shape[0]
    print(f"📊 統計初始化:總監測量 {global_stats['total_count']}, 異常數 {global_stats['abnormal_count']}")

    display_df = baseline_df.sort_values(by='timestamp', ascending=False).head(20).copy()
    display_df['timestamp'] = display_df['timestamp'].dt.strftime('%Y-%m-%d %H:%M:%S')
    log_history = display_df[['timestamp', 'ip_address', 'cookie_id', 'account', 'role', 'action', 'status']].to_dict('records')
    
    abnormal_mask = baseline_df['status'].astype(str).str.contains("異常", na=False)
    if abnormal_mask.any():
        abn_df_temp = baseline_df[abnormal_mask].sort_values(by='timestamp', ascending=False).copy()
        abn_df_temp['timestamp'] = abn_df_temp['timestamp'].dt.strftime('%Y-%m-%d %H:%M:%S')
        initial_df_abn = abn_df_temp[['timestamp', 'ip_address', 'cookie_id', 'account', 'role', 'action', 'status']]
    
    baseline_df['month'] = baseline_df['timestamp'].dt.month
    baseline_df['day'] = baseline_df['timestamp'].dt.day
    baseline_df['hour'] = baseline_df['timestamp'].dt.hour
    
    ip_codes = np.array([get_ip_category(ip) for ip in baseline_df['clean_ip'].values])
        
    actions = baseline_df['action'].astype(str).values
    known_actions = set(le_action.classes_)
    unknown_actions = set(actions) - known_actions
    if unknown_actions: le_action.classes_ = np.append(le_action.classes_, list(unknown_actions))
    
    baseline_X = np.column_stack((
        baseline_df['month'].values, baseline_df['day'].values, baseline_df['hour'].values,
        ip_codes, le_action.transform(actions)
    ))
    
    AI_READY = True
    print("✅ AI 模組與歷史基準資料載入成功!")
except Exception as e:
    AI_READY = False
    global_stats["total_count"] = 0; global_stats["abnormal_count"] = 0
    print(f"⚠️ AI 模組載入失敗,請確認檔案。錯誤: {e}")

USER_DB = {"student": ["1234", "學生", "同學"], "admin": ["1234", "管理", "管理員"]}


# =====================================================================
# 👉 資料庫狀態更新函式 (阻斷/信任)
# =====================================================================
def update_log_status(log_text, new_status):
    """解析前端傳來的 log_text,並將其狀態更新進記憶體與 CSV"""
    global log_history, global_stats
    
    if not log_text or log_text.strip() == "":
        df_all = pd.DataFrame(log_history)
        abn_logs = [l for l in log_history if "異常" in str(l.get("status", "")) or "錯誤" in str(l.get("status", "")) or "受限" in str(l.get("status", ""))]
        df_abn = pd.DataFrame(abn_logs) if abn_logs else pd.DataFrame(columns=df_all.columns)
        return df_all, df_abn, "⚠️ 請先提供或選擇要調整的 Log 資訊"
        
    try:
        parts = [p.strip() for p in log_text.split("|")]
        parsed = {}
        for p in parts:
            if ":" in p:
                k, v = p.split(":", 1)
                parsed[k.strip()] = v.strip()
        
        target_time = parsed.get("時間")
        target_acc = parsed.get("帳號")
        target_action = parsed.get("動作")
    except Exception:
        df_all = pd.DataFrame(log_history)
        abn_logs = [l for l in log_history if "異常" in str(l.get("status", "")) or "錯誤" in str(l.get("status", "")) or "受限" in str(l.get("status", ""))]
        return df_all, pd.DataFrame(abn_logs) if abn_logs else pd.DataFrame(columns=df_all.columns), "⚠️ Log 格式無法解析,請確保為完整字串"

    updated = False
    old_status = ""
    
    for log in log_history:
        if log.get("timestamp") == target_time and log.get("account") == target_acc and log.get("action") == target_action:
            old_status = log.get("status", "")
            log["status"] = new_status
            updated = True
            break

    if not updated:
        df_all = pd.DataFrame(log_history)
        abn_logs = [l for l in log_history if "異常" in str(l.get("status", "")) or "錯誤" in str(l.get("status", "")) or "受限" in str(l.get("status", ""))]
        return df_all, pd.DataFrame(abn_logs) if abn_logs else pd.DataFrame(columns=df_all.columns), "⚠️ 找不到對應的 Log,可能已被刪除或時間不符"

    try:
        if os.path.exists('baseline_logs.csv'):
            df = pd.read_csv('baseline_logs.csv')
            mask = (df['timestamp'] == target_time) & (df['account'] == target_acc) & (df['action'] == target_action)
            if mask.any():
                df.loc[mask, 'status'] = new_status
                df.to_csv('baseline_logs.csv', index=False)
    except Exception as e:
        print("CSV 更新失敗:", e)

    is_old_abnormal = any(kw in str(old_status) for kw in ["異常", "錯誤", "受限"])
    is_new_abnormal = any(kw in str(new_status) for kw in ["異常", "錯誤", "受限"])
    
    if is_old_abnormal and not is_new_abnormal:
        global_stats["abnormal_count"] = max(0, global_stats["abnormal_count"] - 1)
    elif not is_old_abnormal and is_new_abnormal:
        global_stats["abnormal_count"] += 1

    df_all = pd.DataFrame(log_history)
    abn_logs = [l for l in log_history if "異常" in str(l.get("status", "")) or "錯誤" in str(l.get("status", "")) or "受限" in str(l.get("status", ""))]
    df_abn = pd.DataFrame(abn_logs) if abn_logs else pd.DataFrame(columns=df_all.columns)

    return df_all, df_abn, f"✅ 成功將該筆日誌狀態更新為:{new_status}"


# =====================================================================
# 👉 純淨 API 端點專用打包函數
# =====================================================================
def api_get_stats():
    total = global_stats["total_count"]
    abnormal = global_stats["abnormal_count"]
    rate = round((abnormal / total * 100), 2) if total > 0 else 0
    return {
        "status": "success",
        "ai_ready": AI_READY,
        "data": {
            "total_logs": total,
            "abnormal_logs": abnormal,
            "anomaly_rate_percent": rate,
            "current_weights": system_weights
        }
    }

def api_get_logs(limit=20):
    try: limit = int(limit)
    except: limit = 20
    return {"status": "success", "count": len(log_history[:limit]), "data": log_history[:limit]}

def api_get_chart_data(action_name):
    if not AI_READY: return {"status": "error", "message": "AI 模型未載入"}
    action_code = ACTION_MAP.get(action_name)
    if not action_code: return {"status": "error", "message": f"找不到系統: {action_name}"}
    
    df_hist = baseline_df[baseline_df['action'] == action_code].copy()
    df_live = pd.DataFrame(log_history)
    if not df_live.empty:
        df_live['timestamp'] = pd.to_datetime(df_live['timestamp'], errors='coerce')
        df_live = df_live.dropna(subset=['timestamp'])
        df_live = df_live[df_live['action'] == action_code].copy()
        
    if not df_live.empty:
        df_combined = pd.concat([df_hist, df_live], ignore_index=True)
        df_combined = df_combined.drop_duplicates(subset=['timestamp', 'account', 'action'])
    else:
        df_combined = df_hist.copy()
        
    if df_combined.empty:
        return {"status": "success", "action": action_code, "data": {"normal": [], "abnormal": []}}
        
    df_combined['month'] = df_combined['timestamp'].dt.month
    df_combined['time_of_day'] = df_combined['timestamp'].dt.hour + df_combined['timestamp'].dt.minute / 60.0
    
    is_abnormal = df_combined['status'].astype(str).str.contains("異常", na=False)
    
    normal_data = df_combined[~is_abnormal][['month', 'time_of_day', 'timestamp']].astype(str).to_dict('records')
    abnormal_data = df_combined[is_abnormal][['month', 'time_of_day', 'timestamp', 'status']].astype(str).to_dict('records')
    
    return {"status": "success", "action_code": action_code, "data": {"normal": normal_data, "abnormal": abnormal_data}}

def api_get_abnormal_logs():
    abnormal_logs = [log for log in log_history if "異常" in str(log.get("status", "")) or "錯誤" in str(log.get("status", "")) or "受限" in str(log.get("status", ""))]
    return {"status": "success", "count": len(abnormal_logs), "data": abnormal_logs}

def api_trust_log_action(log_text):
    _, _, message = update_log_status(log_text, "success")
    status = "success" if "✅" in message else "error"
    return {"status": status, "message": message}

def api_block_log_action(log_text):
    _, _, message = update_log_status(log_text, "⛔異常_已手動阻斷")
    status = "success" if "✅" in message else "error"
    return {"status": status, "message": message}

# 👉 新增:給隊友呼叫的 Groq AI 分析打包函數
def api_explain_log_action(log_text):
    """API 專用:呼叫 Groq AI 進行異常日誌分析並回傳 JSON"""
    result = explain_abnormal_log(log_text)
    
    # 透過回傳字串是否帶有警告符號來判斷 API 狀態
    if result.startswith("⚠️"):
        return {"status": "error", "message": result}
    
    return {"status": "success", "data": {"explanation": result}}
# =====================================================================

def get_dashboard_html():
    total = global_stats["total_count"]
    abnormal = global_stats["abnormal_count"]
    rate = (abnormal / total * 100) if total > 0 else 0
    
    if not AI_READY: status_icon, status_text, status_color, status_desc = "🔴", "系統錯誤", "#ef4444", "AI 模型載入失敗,防護停用中。"
    elif rate > 10: status_icon, status_text, status_color, status_desc = "🟡", "高風險警告", "#f59e0b", "近期異常行為頻發,請立刻檢查 Log。"
    else: status_icon, status_text, status_color, status_desc = "🟢", "正常執行", "#10b981", "HDBSCAN 與 Agent 服務運作正常。"

    return f"""
    <div class="stat-dashboard">
        <div class="stat-card card-total">
            <div class="card-icon">📊</div>
            <div class="card-content">
                <div class="card-label">總監測量 (本地歷史資料庫)</div>
                <div class="card-value">{total:,} <span class="card-unit">筆 Log</span></div>
                <div class="card-sub-text">自系統啟動起統計 (+今日即時)</div>
            </div>
        </div>
        <div class="stat-card card-anomaly">
            <div class="card-icon">⚠️</div>
            <div class="card-content">
                <div class="card-label">異常率 (平均數值)</div>
                <div class="card-value-container">
                    <div class="card-value" style="color: #ef4444;">{rate:.2f} %</div>
                    <div class="card-trend trend-up">↑即時</div>
                </div>
                <div class="card-sub-text">共 {abnormal:,} 筆監測到異常行為</div>
            </div>
        </div>
        <div class="stat-card card-status" style="border-top-color: {status_color};">
            <div class="card-icon">{status_icon}</div>
            <div class="card-content">
                <div class="card-label">系統狀態</div>
                <div class="card-value" style="font-size: 24px; color: {status_color};">{status_text}</div>
                <div class="card-sub-text">{status_desc}</div>
            </div>
        </div>
    </div>
    """

def get_plot_data_for_api(selected_key):
    if not selected_key or not AI_READY: return None
    action_code = ACTION_MAP.get(selected_key)
    try:
        plt.close('all') 
        df_hist = baseline_df[baseline_df['action'] == action_code].copy()
        
        df_live = pd.DataFrame(log_history)
        if not df_live.empty:
            df_live['timestamp'] = pd.to_datetime(df_live['timestamp'], errors='coerce')
            df_live = df_live.dropna(subset=['timestamp']) 
            df_live = df_live[df_live['action'] == action_code].copy()
        
        if not df_live.empty:
            df_combined = pd.concat([df_hist, df_live], ignore_index=True)
            df_combined = df_combined.drop_duplicates(subset=['timestamp', 'account', 'action'])
        else:
            df_combined = df_hist.copy()
            
        if df_combined.empty:
            fig, ax = plt.subplots(figsize=(12, 6))
            if os.path.exists(font_path): plt.rc('font', family='SimHei')
            ax.text(0.5, 0.5, f"【{selected_key}】目前尚無資料", ha='center', va='center', fontsize=15)
            buf = io.BytesIO()
            fig.savefig(buf, format='png', dpi=100, bbox_inches='tight')
            buf.seek(0)
            img_base64 = base64.b64encode(buf.getvalue()).decode('utf-8')
            buf.close()
            plt.close(fig)
            return f"data:image/png;base64,{img_base64}"

        df_combined['month'] = df_combined['timestamp'].dt.month
        df_combined['time_of_day'] = df_combined['timestamp'].dt.hour + df_combined['timestamp'].dt.minute / 60.0
        
        is_abnormal = df_combined['status'].astype(str).str.contains("異常", na=False)
        df_normal = df_combined[~is_abnormal]
        df_abnormal = df_combined[is_abnormal]

        fig, ax = plt.subplots(figsize=(12, 6))
        sns.set_theme(style="whitegrid")
        if os.path.exists(font_path): plt.rc('font', family='SimHei')
        plt.rcParams['axes.unicode_minus'] = False

        has_data = False
        months_order = list(range(1, 13)) 

        if not df_normal.empty:
            has_data = True
            sns.stripplot(data=df_normal, x='month', y='time_of_day', jitter=0.3, alpha=0.4, size=5, color='#10b981', order=months_order, ax=ax, label='正常資料')

        if not df_abnormal.empty:
            has_data = True
            sns.stripplot(data=df_abnormal, x='month', y='time_of_day', jitter=0.3, alpha=0.9, size=9, color='#ef4444', marker='X', order=months_order, ax=ax, label='異常資料')
            
        if not has_data:
            ax.text(0.5, 0.5, f"【{selected_key}】目前尚無資料", ha='center', va='center', fontsize=15)
            buf = io.BytesIO()
            fig.savefig(buf, format='png', dpi=100, bbox_inches='tight')
            buf.seek(0)
            img_base64 = base64.b64encode(buf.getvalue()).decode('utf-8')
            buf.close()
            plt.close(fig)
            return f"data:image/png;base64,{img_base64}"

        ax.set_xlabel('月份 (1 ~ 12月)', fontsize=12)
        ax.set_ylabel('時間 (24小時制)', fontsize=12)
        ax.set_yticks(np.arange(0, 25, 2))
        ax.set_ylim(24.5, -0.5)

        handles, labels = ax.get_legend_handles_labels()
        by_label = dict(zip(labels, handles))
        if by_label: ax.legend(by_label.values(), by_label.keys(), loc='upper right', bbox_to_anchor=(1.15, 1))

        plt.tight_layout()
        buf = io.BytesIO()
        fig.savefig(buf, format='png', dpi=100, bbox_inches='tight')
        buf.seek(0)
        img_base64 = base64.b64encode(buf.getvalue()).decode('utf-8')
        buf.close()
        plt.close(fig)
        return f"data:image/png;base64,{img_base64}"
    except Exception as e:
        print(f"繪圖失敗: {e}")
        fig, ax = plt.subplots(figsize=(8, 4))
        ax.text(0.5, 0.5, f"圖表生成失敗: {str(e)}", ha='center', va='center', fontsize=12, color='red')
        ax.set_xlim(0, 1)
        ax.set_ylim(0, 1)
        ax.axis('off')
        
        buf = io.BytesIO()
        fig.savefig(buf, format='png', dpi=100, bbox_inches='tight')
        buf.seek(0)
        img_base64 = base64.b64encode(buf.getvalue()).decode('utf-8')
        buf.close()
        plt.close(fig)
        return f"data:image/png;base64,{img_base64}"

def get_plot_data(selected_key):
    if not selected_key or not AI_READY: return None
    action_code = ACTION_MAP.get(selected_key)
    try:
        plt.close('all') 
        df_hist = baseline_df[baseline_df['action'] == action_code].copy()
        
        df_live = pd.DataFrame(log_history)
        if not df_live.empty:
            df_live['timestamp'] = pd.to_datetime(df_live['timestamp'], errors='coerce')
            df_live = df_live.dropna(subset=['timestamp']) 
            df_live = df_live[df_live['action'] == action_code].copy()
        
        if not df_live.empty:
            df_combined = pd.concat([df_hist, df_live], ignore_index=True)
            df_combined = df_combined.drop_duplicates(subset=['timestamp', 'account', 'action'])
        else:
            df_combined = df_hist.copy()
            
        if df_combined.empty:
            fig, ax = plt.subplots(figsize=(12, 6))
            if os.path.exists(font_path): plt.rc('font', family='SimHei')
            ax.text(0.5, 0.5, f"【{selected_key}】目前尚無資料", ha='center', va='center', fontsize=15)
            return fig

        df_combined['month'] = df_combined['timestamp'].dt.month
        df_combined['time_of_day'] = df_combined['timestamp'].dt.hour + df_combined['timestamp'].dt.minute / 60.0
        
        is_abnormal = df_combined['status'].astype(str).str.contains("異常", na=False)
        df_normal = df_combined[~is_abnormal]
        df_abnormal = df_combined[is_abnormal]

        fig, ax = plt.subplots(figsize=(12, 6))
        sns.set_theme(style="whitegrid")
        if os.path.exists(font_path): plt.rc('font', family='SimHei')
        plt.rcParams['axes.unicode_minus'] = False

        has_data = False
        months_order = list(range(1, 13)) 

        if not df_normal.empty:
            has_data = True
            sns.stripplot(data=df_normal, x='month', y='time_of_day', jitter=0.3, alpha=0.4, size=5, color='#10b981', order=months_order, ax=ax, label='正常資料')

        if not df_abnormal.empty:
            has_data = True
            sns.stripplot(data=df_abnormal, x='month', y='time_of_day', jitter=0.3, alpha=0.9, size=9, color='#ef4444', marker='X', order=months_order, ax=ax, label='異常資料')
            
        if not has_data:
            ax.text(0.5, 0.5, f"【{selected_key}】目前尚無資料", ha='center', va='center', fontsize=15)
            return fig

        ax.set_xlabel('月份 (1 ~ 12月)', fontsize=12)
        ax.set_ylabel('時間 (24小時制)', fontsize=12)
        ax.set_yticks(np.arange(0, 25, 2))
        ax.set_ylim(24.5, -0.5)

        handles, labels = ax.get_legend_handles_labels()
        by_label = dict(zip(labels, handles))
        if by_label: ax.legend(by_label.values(), by_label.keys(), loc='upper right', bbox_to_anchor=(1.15, 1))

        plt.tight_layout()
        return fig
    except Exception as e:
        print(f"繪圖失敗: {e}")
        return None

def timer_update(selected_key): return get_dashboard_html(), get_plot_data(selected_key)

def explain_abnormal_log(log_text):
    if not log_text or log_text.strip() == "": return "⚠️ 請先提供異常 Log 資訊以進行分析。"
    try: from groq import Groq
    except ImportError: return "⚠️ 未安裝 groq 套件。請在終端機執行 `pip install groq`。"
    groq_api_key = os.environ.get("GROQ_API_KEY", "")
    if not groq_api_key: return "⚠️ 未設定 GROQ_API_KEY。"
    try:
        client = Groq(api_key=groq_api_key)
        response = client.chat.completions.create(
            messages=[
                {"role": "system", "content": "你是一位專業的資安分析師。請在50個字以內解釋為什麼這筆 Log 異常,指出風險(如撞庫攻擊、作息異常等),並且嚴格禁止使用MarkDown格式"},
                {"role": "user", "content": f"請分析這筆異常 Log:\n{log_text}"}
            ],
            model="llama-3.1-8b-instant", temperature=0.5, max_tokens=300
        )
        return response.choices[0].message.content
    except Exception as e: return f"⚠️ 呼叫 API 發生錯誤: {str(e)}"

# --- 2. 核心邏輯與真實 HDBSCAN 異常偵測 ---
def check_anomaly(ip, account, action, log_time):
    if not AI_READY: return "success" 
    if action in ["login_attempt", "logout"]: return "success"

    try:
        ow = float(system_weights["ow"])
        tw = float(system_weights["tw"])
        iw = float(system_weights["iw"])
        dw = float(system_weights["dw"])
        gw = float(system_weights["gw"])
        fw = float(system_weights["fw"])
        
        geo_level = get_geo_level(ip)
        
        if gw == 100 and geo_level > 0:
            return "⚠️異常_地理位置受限 (100%絕對鎖定: 僅限校內專網存取)"
        elif gw >= 90 and geo_level > 1:
            return "⚠️異常_地理位置受限 (高敏感防護: 僅限校園網路與宿舍)"
        elif gw >= 70 and geo_level > 2:
            return "⚠️異常_地理位置受限 (進階防護: 禁止公共場所與海外連線)"
        elif gw >= 50 and geo_level > 3:
            return "⚠️異常_地理位置受限 (預設防護: 禁止海外異常 IP)"
        
        current_dt = pd.to_datetime(str(log_time))
        cutoff_dt = current_dt - pd.Timedelta(seconds=60)
        
        recent_clicks = 0
        for log in log_history:
            log_dt = pd.to_datetime(log['timestamp'])
            if log_dt >= cutoff_dt:
                if log.get('account') == account and log.get('action') == action:
                    recent_clicks += 1
            else:
                break
                
        if fw <= 0: max_allowed_clicks = 100
        elif fw <= 10: max_allowed_clicks = 90
        elif fw <= 20: max_allowed_clicks = 80
        elif fw <= 30: max_allowed_clicks = 70
        elif fw <= 40: max_allowed_clicks = 60
        elif fw <= 50: max_allowed_clicks = 50
        elif fw <= 60: max_allowed_clicks = 40
        elif fw <= 70: max_allowed_clicks = 30
        elif fw <= 80: max_allowed_clicks = 15
        elif fw <= 90: max_allowed_clicks = 9
        else: max_allowed_clicks = 3

        if (recent_clicks + 1) > max_allowed_clicks:
            return f"⚠️異常_單一操作頻率過高 ({recent_clicks+1}次/分)"
            
        ip_code = float(get_ip_category(ip))
        action_code = float(le_action.transform([action])[0])
        
        current_month = float(current_dt.month)
        current_day = float(current_dt.day)
        current_hour = float(current_dt.hour)
        
        time_multiplier = tw / 100.0
        action_scale = (dw / 100.0) * 100.0 
        
        scaled_baseline = baseline_X.copy().astype(float)
        scaled_baseline[:, 0] *= time_multiplier * 10.0  
        scaled_baseline[:, 1] *= time_multiplier * 0.5   
        scaled_baseline[:, 2] *= time_multiplier * 2.0   
        scaled_baseline[:, 3] *= (iw / 100.0) * 10.0     
        scaled_baseline[:, 4] *= action_scale            
        
        v_month = current_month * time_multiplier * 10.0
        v_day = current_day * time_multiplier * 0.5
        v_hour = current_hour * time_multiplier * 2.0
        v_ip = ip_code * (iw / 100.0) * 10.0
        v_action = action_code * action_scale
        
        new_data_point = np.array([[v_month, v_day, v_hour, v_ip, v_action]], dtype=float)
        
        same_action_mask = (baseline_X[:, 4] == action_code)
        relevant_history = scaled_baseline[same_action_mask]
        
        other_history = scaled_baseline[~same_action_mask]
        if len(other_history) > 800:
            np.random.seed(int(current_day + current_hour)) 
            indices = np.random.choice(len(other_history), 800, replace=False)
            other_history = other_history[indices]
            
        fit_X = np.vstack((other_history, relevant_history, new_data_point))
        strictness = max(2, int(2 + (ow / 100.0) * 4))
        
        model = hdbscan.HDBSCAN(min_cluster_size=strictness, min_samples=2)
        clusters = model.fit_predict(fit_X)
        
        if clusters[-1] == -1: return "⚠️異常_作息或行為不符"

        if np.any(same_action_mask):
            distances = np.linalg.norm(relevant_history - new_data_point[0], axis=1)
            min_distance = np.min(distances)
            max_tolerance_distance = time_multiplier * 15.0 + 1.0
            
            if ip_code >= 3.0: max_tolerance_distance *= (1 - (iw / 100.0) * 0.6)
                
            if min_distance > max_tolerance_distance:
                return "⚠️異常_作息或行為不符"
                
        return "success"
    except ValueError:
        return "⚠️異常_未知特徵 (出現未授權的 IP 或操作)"
    except Exception as e:
        return f"⚠️系統錯誤: {str(e)}"

def record_log(ip, cookie, account, role, action, status, time_mode, custom_time):
    global baseline_X 
    
    if time_mode == "自訂時間 (模擬過去/未來)" and custom_time and str(custom_time).strip() != "": 
        try:
            valid_time = pd.to_datetime(str(custom_time))
            log_time = valid_time.strftime("%Y-%m-%d %H:%M:%S")
        except Exception:
            log_time = datetime.datetime.now(datetime.timezone(datetime.timedelta(hours=8))).strftime("%Y-%m-%d %H:%M:%S")
            status = "⚠️格式錯誤_無效的自訂時間"
    else: 
        log_time = datetime.datetime.now(datetime.timezone(datetime.timedelta(hours=8))).strftime("%Y-%m-%d %H:%M:%S")

    if status == "success":
        ai_judgment = check_anomaly(ip, account, action, log_time)
        if ai_judgment != "success": status = ai_judgment

    new_log = {"timestamp": log_time, "ip_address": ip, "cookie_id": cookie, "account": account, "role": role, "action": action, "status": status}

    new_df = pd.DataFrame([new_log])
    new_df.to_csv('baseline_logs.csv', mode='a', header=not os.path.exists('baseline_logs.csv'), index=False)
    
    try: logger_service.push_new_log(new_log)
    except: pass

    global_stats["total_count"] += 1
    if "異常" in str(status) or "錯誤" in str(status) or "受限" in str(status): global_stats["abnormal_count"] += 1

    log_history.insert(0, new_log)

    if status == "success" and AI_READY:
        try:
            current_time = pd.to_datetime(str(log_time))
            if action not in le_action.classes_: le_action.classes_ = np.append(le_action.classes_, action)
            new_row = np.array([[float(current_time.month), float(current_time.day), float(current_time.hour), float(get_ip_category(ip)), float(le_action.transform([action])[0])]], dtype=float)
            baseline_X = np.vstack((baseline_X, new_row))
        except: pass 

    df_all = pd.DataFrame(log_history)
    abnormal_logs = [log for log in log_history if "異常" in str(log.get("status", "")) or "錯誤" in str(log.get("status", "")) or "受限" in str(log.get("status", ""))]
    df_abnormal = pd.DataFrame(abnormal_logs) if abnormal_logs else pd.DataFrame(columns=df_all.columns)
    
    input_update = gr.update(value=f"時間: {log_time} | IP: {ip} | 帳號: {account} | 動作: {action} | 狀態: {status}") if "異常" in str(status) or "錯誤" in str(status) or "受限" in str(status) else gr.update()
    return df_all, df_abnormal, input_update

def fast_login(target_account, ip, cookie, time_mode, custom_time):
    role, name = USER_DB[target_account][1], USER_DB[target_account][2]
    df_all, df_abn, inp_upd = record_log(ip, cookie, target_account, role, "login_attempt", "success", time_mode, custom_time)
    target_tab = "student_tab" if role == "學生" else "admin_tab"
    return gr.update(selected="dashboard_route"), gr.update(selected=target_tab), "", f"**{name}** 歡迎您  |  線上人數: 938 (⚡快速登入模式)", df_all, df_abn, inp_upd, target_account

def process_login(ip, cookie, account, password, captcha, time_mode, custom_time):
    def fail_response(msg, df_all, df_abn, inp_upd): return gr.update(selected="login_route"), gr.update(), msg, gr.update(), df_all, df_abn, inp_upd
    if account not in USER_DB: 
        df_all, df_abn, inp_upd = record_log(ip, cookie, account, "Unknown", "login_attempt", "failed_no_account", time_mode, custom_time)
        return fail_response("帳號不存在!", df_all, df_abn, inp_upd)
    role, name = USER_DB[account][1], USER_DB[account][2]
    if captcha.upper() != "FEIK": 
        df_all, df_abn, inp_upd = record_log(ip, cookie, account, role, "login_attempt", "failed_captcha", time_mode, custom_time)
        return fail_response("驗證碼錯誤!", df_all, df_abn, inp_upd)
    if USER_DB[account][0] == password:
        df_all, df_abn, inp_upd = record_log(ip, cookie, account, role, "login_attempt", "success", time_mode, custom_time)
        return gr.update(selected="dashboard_route"), gr.update(selected="student_tab" if role == "學生" else "admin_tab"), "", f"**{name}** 歡迎您  |  線上人數: 938", df_all, df_abn, inp_upd
    df_all, df_abn, inp_upd = record_log(ip, cookie, account, role, "login_attempt", "failed_password", time_mode, custom_time)
    return fail_response("密碼錯誤!", df_all, df_abn, inp_upd)

def toggle_role(current_account, ip, cookie, time_mode, custom_time):
    target_account = "student" if current_account == "admin" else "admin"
    role, name = USER_DB[target_account][1], USER_DB[target_account][2]
    df_all, df_abn, inp_upd = record_log(ip, cookie, target_account, role, "login_attempt", "success", time_mode, custom_time)
    return gr.update(selected="student_tab" if role == "學生" else "admin_tab"), f"**{name}** 歡迎您  |  線上人數: 938 (⚡單鍵切換模式)", df_all, df_abn, inp_upd, target_account

def logout(ip, cookie, account, time_mode, custom_time):
    role = USER_DB.get(account, ["", "Unknown"])[1]
    df_all, df_abn, inp_upd = record_log(ip, cookie, account, role, "logout", "success", time_mode, custom_time)
    return gr.update(selected="login_route"), "", "", "", "", df_all, df_abn, inp_upd

def simulate_click(ip, cookie, account, button_name, time_mode, custom_time):
    role = USER_DB.get(account, ["", "Unknown"])[1]
    return record_log(ip, cookie, account, role, button_name, "success", time_mode, custom_time)

def _extract_gr_update_value(update_obj):
    if update_obj is None: return None
    if isinstance(update_obj, dict): return update_obj.get("value")
    try: return getattr(update_obj, "value", None)
    except Exception: return None

def api_run_student_action(ip, c, acc, button_name, tm, ct):
    df_all, df_abn, inp_upd = simulate_click(ip, c, acc, button_name, tm, ct)
    val = _extract_gr_update_value(inp_upd)
    return val or ""

def api_run_student_action_code(ip, c, acc, action_code, tm, ct):
    df_all, df_abn, inp_upd = simulate_click(ip, c, acc, action_code, tm, ct)
    val = _extract_gr_update_value(inp_upd)
    return df_all, df_abn, val or ""

def api_lambda(ip, c, tm, ct):
    default_acc = USER_DB["student"][0]
    return api_run_student_action(ip, c, default_acc, "click_eval_system", tm, ct)

def api_lambda_1(ip, c, tm, ct):
    default_acc = USER_DB["student"][0]
    return api_run_student_action(ip, c, default_acc, "click_pre_select_system", tm, ct)

def api_lambda_7(ip, c, acc, tm, ct):
    return api_run_student_action(ip, c, acc, "click_leave_system", tm, ct)

def api_lambda_8(ip, c, acc, tm, ct):
    return api_run_student_action(ip, c, acc, "click_dorm_system", tm, ct)

def api_lambda_10(ip, c, acc, tm, ct):
    return api_run_student_action(ip, c, acc, "click_webmail", tm, ct)

def api_lambda_11(ip, c, acc, tm, ct):
    return api_run_student_action(ip, c, acc, "click_vdesk", tm, ct)

def api_lambda_12(ip, c, acc, tm, ct):
    return api_run_student_action(ip, c, acc, "malicious_sql_injection", tm, ct)

def test_anomaly(ip, cookie, account, action_name, test_time_str):
    role = USER_DB.get(account, ["", "Unknown"])[1]
    return record_log(ip, cookie, account, role, action_name, "success", "自訂時間 (模擬過去/未來)", test_time_str)

def toggle_time_input(mode): return gr.update(visible=(mode == "自訂時間 (模擬過去/未來)"))

# --- 4. UI 介面設計 ---
custom_css = """
.mock-panel { background-color: var(--background-fill-secondary); padding: 15px; border-radius: 8px; border: 1px dashed var(--border-color-primary); }
.login-container { max-width: 500px; margin: 0 auto; padding: 20px; }
.ntut-title { color: #d9534f; font-size: 22px; font-weight: bold; text-align: center; margin-bottom: 20px;}
.weight-card { padding: 10px; background: white; border-radius: 8px; box-shadow: 0 1px 3px rgba(0,0,0,0.1); margin-top: 10px; }
.headless-tabs > div:first-child { display: none !important; }
.headless-tabs { border: none !important; background: transparent !important; }
.stat-dashboard { display: flex; gap: 15px; margin-bottom: 20px; justify-content: space-between; }
.stat-card { flex: 1; background-color: #ffffff !important; padding: 15px; border-radius: 10px; box-shadow: 0 4px 6px rgba(0,0,0,0.05); display: flex; align-items: center; gap: 15px; border-top: 4px solid transparent; }
.card-total { border-left: 4px solid #10b981; }
.card-anomaly { border-left: 4px solid #ef4444; }
.card-status { border-left: 4px solid #3b82f6; }
.card-icon { font-size: 30px; width: 40px; text-align: center; }
.card-content { flex: 1; }
.card-label { color: #374151 !important; font-size: 13px; margin-bottom: 2px; font-weight: bold !important; }
.card-value-container { display: flex; align-items: baseline; gap: 8px; }
.card-value { font-size: 24px; font-weight: bold; }
.card-total .card-value { color: #000000 !important; }
.card-unit { font-size: 14px; color: #4b5563 !important; font-weight: normal; }
.card-trend { font-size: 12px; padding: 2px 6px; border-radius: 4px; }
.trend-up { background-color: #fee2e2 !important; color: #ef4444 !important; }
.card-sub-text { color: #6b7280 !important; font-size: 11px; margin-top: 2px; }
"""

with gr.Blocks(title="模擬校園入口與資安防護系統") as demo:
    store_df_all = gr.State(value=pd.DataFrame(log_history))
    store_df_abn = gr.State(value=initial_df_abn)
    dashboard_timer = gr.Timer(value=60)

    with gr.Row():
        with gr.Column(scale=1, elem_classes="mock-panel"):
            gr.Markdown("### ⚙️ 環境變數模擬器")
            mock_ip = gr.Dropdown(choices=["140.124.71.55 (校內預設)", "140.124.18.22 (宿舍)", "61.228.45.112 (家裡)", "210.61.47.88 (公共場所)", "45.33.22.11 (國外異常IP)"], value="140.124.71.55 (校內預設)", allow_custom_value=True, label="模擬來源 IP")
            mock_cookie = gr.Textbox(label="模擬 Cookie Session ID", value="sess_baseline")
            gr.Markdown("---")
            time_mode = gr.Radio(label="時間設定模式", choices=["真實時間 (目前時間)", "自訂時間 (模擬過去/未來)"], value="真實時間 (目前時間)")
            custom_time_input = gr.Textbox(label="輸入自訂時間", placeholder="格式: YYYY-MM-DD HH:MM:SS", value="2026-03-17 03:00:00", visible=False)
            gr.Markdown("---")
            gr.Markdown("### 📊 即時 Log 與 AI 判定區")
            log_display = gr.Dataframe(value=pd.DataFrame(log_history), headers=["timestamp", "ip_address", "cookie_id", "account", "role", "action", "status"], datatype=["str", "str", "str", "str", "str", "str", "str"], interactive=False, wrap=True)

        with gr.Column(scale=2):
            with gr.Tabs(selected="login_route", elem_classes="headless-tabs") as main_router:
                with gr.Tab("Login", id="login_route"):
                    with gr.Column(elem_classes="login-container"):
                        gr.Markdown("<div class='ntut-title'>校園入口網站 Taipei Tech Portal</div>")
                        login_msg = gr.Markdown(value="", visible=True)
                        with gr.Row(): acc_input = gr.Textbox(label="使用者帳號 (Account)", placeholder="student or admin")
                        with gr.Row(): pwd_input = gr.Textbox(label="使用者密碼 (Password)", type="password", placeholder="password : 1234")
                        with gr.Row(): gr.HTML("<div style='background:var(--background-fill-secondary); color:var(--body-text-color); padding:10px; font-weight:bold; letter-spacing: 3px; border:1px solid var(--border-color-primary); text-align:center;'>F E I K</div>")
                        with gr.Row(): captcha_input = gr.Textbox(label="請輸入驗證碼 (Keyin Code)")
                        login_btn = gr.Button("登入 Login", variant="primary")
                        
                        gr.Markdown("---")
                        gr.Markdown("<div style='text-align:center; color:gray; font-size: 0.9em;'>🛠️ 開發與測試專用捷徑</div>")
                        with gr.Row():
                            btn_fast_student = gr.Button("🚀 快速登入 (學生)", variant="secondary")
                            btn_fast_admin = gr.Button("🚀 快速登入 (管理員)", variant="secondary")

                with gr.Tab("Dashboard", id="dashboard_route"):
                    with gr.Column():
                        with gr.Row():
                            gr.Markdown("### 資訊系統")
                            welcome_text = gr.Markdown(value="", elem_classes="text-right")
                            logout_btn = gr.Button("登出", size="sm")
                        with gr.Row(): btn_toggle_role = gr.Button("🔄 Student ↔ Admin", size="sm", variant="secondary")
                        gr.Markdown("---")
                        
                        with gr.Tabs(selected="student_tab", elem_classes="headless-tabs") as role_tabs:
                            with gr.Tab("👨‍🎓 學生專區", id="student_tab"):
                                with gr.Accordion("▼ 1. 教務系統", open=True):
                                    with gr.Row(): btn_eval = gr.Button("▶ 期末網路教學評量", size="sm"); btn_pre_select = gr.Button("▶ 期末網路預選系統", size="sm"); btn_add_drop = gr.Button("▶ 開學後加退選系統", size="sm")
                                    with gr.Row(): btn_istudy = gr.Button("▶ 北科i學園PLUS", size="sm"); btn_card = gr.Button("▶ 學生證掛失及補發系統", size="sm"); btn_course = gr.Button("▶ 課程系統", size="sm")
                                    with gr.Row(): btn_score = gr.Button("▶ 學業成績查詢系統", size="sm")
                                with gr.Accordion("▼ 2. 學務系統", open=True):
                                    with gr.Row(): btn_leave = gr.Button("▶ 學生請假系統", size="sm"); btn_dorm = gr.Button("▶ 學生宿舍登錄(抽籤)系統", size="sm"); btn_scholarship = gr.Button("▶ 獎助學金申請系統", size="sm")
                                with gr.Accordion("▼ 3. 資訊服務", open=True):
                                    with gr.Row(): btn_webmail = gr.Button("▶ 網路郵局 WebMail", size="sm"); btn_vdesk = gr.Button("▶ 北科軟體雲", size="sm")
                                with gr.Accordion("▼ 惡意操作測試區", open=True):
                                    btn_hack_score = gr.Button("💀 嘗試偷改成績 (SQL Injection)", variant="stop", size="sm")

                            with gr.Tab("🛡️ 管理員專區", id="admin_tab"):
                                stat_dashboard_display = gr.HTML(value=get_dashboard_html())
                                with gr.Accordion("▼ 系統操作時間分佈圖 (即時監控)", open=True, elem_classes="weight-card"):
                                    action_dropdown = gr.Dropdown(choices=list(ACTION_MAP.keys()), label="選擇要檢視的系統資料分佈", value=None)
                                    action_plot = gr.Plot(show_label=False)

                                with gr.Accordion("▼ 防護強度微調 (AI 敏感度)", open=True, elem_classes="weight-card"):
                                    gr.Markdown("<span style='color:gray; font-size:0.9em;'>動態防護已全面啟動:包含 HDBSCAN 空間異常偵測、IP 聲譽聯防,以及動態視窗頻率攔截。</span>")
                                    with gr.Row():
                                        overall_weight = gr.Number(label="總體防護強度 (%)", value=75, minimum=0, maximum=100)
                                        time_weight = gr.Number(label="時間特徵權重 (%)", value=80, minimum=0, maximum=100)
                                        ip_weight = gr.Number(label="IP 聲譽權重 (%)", value=65, minimum=0, maximum=100)
                                    with gr.Row():
                                        device_weight = gr.Number(label="裝置指紋/行為權重 (%)", value=45, minimum=0, maximum=100)
                                        geo_weight = gr.Number(label="🌍 地理偏移敏感度 (%)", value=50, minimum=0, maximum=100)
                                        freq_weight = gr.Number(label="⚡ 行為頻率敏感度 (%)", value=60, minimum=0, maximum=100)
                                    weights_status = gr.Textbox(value="", visible=False)
                                
                                with gr.Accordion("▼ 異常 Log 分析 (Groq AI Agent)", open=True, elem_classes="weight-card"):
                                    abnormal_log_display = gr.Dataframe(value=initial_df_abn, headers=["timestamp", "ip_address", "cookie_id", "account", "role", "action", "status"], datatype=["str", "str", "str", "str", "str", "str", "str"], interactive=False, wrap=True)
                                    with gr.Row():
                                        abnormal_log_input = gr.Textbox(label="要分析的異常 Log", placeholder="系統若偵測到新異常將會自動填入...", scale=4)
                                        btn_explain_log = gr.Button("🧠 Groq AI 分析", variant="primary", scale=1)
                                        btn_trust_log = gr.Button("✅ 標記為信任", variant="secondary", scale=1)
                                        btn_block_log = gr.Button("⛔ 立即阻斷", variant="stop", scale=1)
                                    ai_explanation_output = gr.Textbox(label="AI 分析結果與說明", lines=4, interactive=False)
                                
                                with gr.Accordion("▼ HDBSCAN 異常辨識自動化測試區", open=True, elem_classes="weight-card"):
                                    gr.Markdown("<span style='color:gray; font-size:0.9em;'>點擊按鈕將直接以指定時間點執行該系統的操作,結果將顯示於左側 Log 區。</span>")
                                    gr.Markdown("#### 1. 選課相關系統 (具備強烈季節性)")
                                    with gr.Row():
                                        t_pre_sel_norm = gr.Button("✅ 正常: 期末網路預選系統 (06-13 11:00)", size="sm"); t_pre_sel_anom = gr.Button("⚠️ 異常: 期末網路預選系統 (10-15 13:00)", size="sm")
                                    with gr.Row():
                                        t_course_norm = gr.Button("✅ 正常: 課程系統 (02-25 07:50)", size="sm"); t_course_anom = gr.Button("⚠️ 異常: 課程系統 (07-15 05:00)", size="sm")
                                    with gr.Row():
                                        t_add_drop_norm = gr.Button("✅ 正常: 開學後加退選系統 (02-18 14:00)", size="sm"); t_add_drop_anom = gr.Button("⚠️ 異常: 開學後加退選系統 (05-15 12:00)", size="sm")
                                    gr.Markdown("#### 2. 期末與成績相關 (具備週期性)")
                                    with gr.Row():
                                        t_eval_norm = gr.Button("✅ 正常: 期末網路教學評量 (12-17 13:20)", size="sm"); t_eval_anom = gr.Button("⚠️ 異常: 期末網路教學評量 (03-15 03:00)", size="sm")
                                    with gr.Row():
                                        t_score_norm = gr.Button("✅ 正常: 學業成績查詢系統 (11-17 18:50)", size="sm"); t_score_anom = gr.Button("⚠️ 異常: 學業成績查詢系統 (02-15 03:00)", size="sm")
                                    gr.Markdown("#### 3. 校務與行政服務 (生活與常規)")
                                    with gr.Row():
                                        t_dorm_norm = gr.Button("✅ 正常: 學生宿舍登錄(抽籤)系統 (07-21 23:10)", size="sm"); t_dorm_anom = gr.Button("⚠️ 異常: 學生宿舍登錄(抽籤)系統 (11-15 16:00)", size="sm")
                                    with gr.Row():
                                        t_schol_norm = gr.Button("✅ 正常: 獎助學金申請系統 (03-12 14:00)", size="sm"); t_schol_anom = gr.Button("⚠️ 異常: 獎助學金申請系統 (08-15 02:00)", size="sm")
                                    with gr.Row():
                                        t_card_norm = gr.Button("✅ 正常: 學生證掛失 (10-23 13:40)", size="sm"); t_card_anom = gr.Button("⚠️ 異常: 學生證掛失 (08-10 03:00)", size="sm")
                                    gr.Markdown("#### 4. 學習與日常輔助系統 (具備作息規律)")
                                    with gr.Row():
                                        t_istudy_norm = gr.Button("✅ 正常: 北科i學園PLUS (10-18 16:00)", size="sm"); t_istudy_anom = gr.Button("⚠️ 異常: 北科i學園PLUS (08-20 02:00)", size="sm")
                                    with gr.Row():
                                        t_leave_norm = gr.Button("✅ 正常: 學生請假系統 (03-29 08:45)", size="sm"); t_leave_anom = gr.Button("⚠️ 異常: 學生請假系統 (08-15 13:00)", size="sm")
                                    with gr.Row():
                                        t_vdesk_norm = gr.Button("✅ 正常: 軟體雲/WebMail (03-22 18:00)", size="sm"); t_vdesk_anom = gr.Button("⚠️ 異常: 軟體雲/WebMail (08-10 00:00)", size="sm")

    def update_dataframes(df_all, df_abn): return gr.update(value=df_all), gr.update(value=df_abn)
    store_df_all.change(fn=update_dataframes, inputs=[store_df_all, store_df_abn], outputs=[log_display, abnormal_log_display])

    demo.load(fn=timer_update, inputs=[action_dropdown], outputs=[stat_dashboard_display, action_plot])
    dashboard_timer.tick(fn=timer_update, inputs=[action_dropdown], outputs=[stat_dashboard_display, action_plot])
    action_dropdown.change(fn=get_plot_data, inputs=[action_dropdown], outputs=[action_plot], api_name="getPlotData")
    time_mode.change(fn=toggle_time_input, inputs=time_mode, outputs=custom_time_input)
    btn_explain_log.click(fn=explain_abnormal_log, inputs=[abnormal_log_input], outputs=[ai_explanation_output])
    
    # UI 事件綁定:信任與阻斷
    btn_trust_log.click(fn=lambda log: update_log_status(log, "success"), inputs=[abnormal_log_input], outputs=[store_df_all, store_df_abn, ai_explanation_output])
    btn_block_log.click(fn=lambda log: update_log_status(log, "⛔異常_已手動阻斷"), inputs=[abnormal_log_input], outputs=[store_df_all, store_df_abn, ai_explanation_output])

    update_outputs = [main_router, role_tabs, login_msg, welcome_text, store_df_all, store_df_abn, abnormal_log_input]
    
    login_btn.click(fn=process_login, inputs=[mock_ip, mock_cookie, acc_input, pwd_input, captcha_input, time_mode, custom_time_input], outputs=update_outputs)
    logout_btn.click(fn=logout, inputs=[mock_ip, mock_cookie, acc_input, time_mode, custom_time_input], outputs=[main_router, acc_input, pwd_input, captcha_input, login_msg, store_df_all, store_df_abn, abnormal_log_input])
    
    fast_inputs = [mock_ip, mock_cookie, time_mode, custom_time_input]
    fast_outputs = update_outputs + [acc_input] 
    
    btn_fast_student.click(fn=lambda ip, c, tm, ct: fast_login("student", ip, c, tm, ct), inputs=fast_inputs, outputs=fast_outputs, api_name=None)
    btn_fast_admin.click(fn=lambda ip, c, tm, ct: fast_login("admin", ip, c, tm, ct), inputs=fast_inputs, outputs=fast_outputs, api_name=None)
    btn_toggle_role.click(fn=toggle_role, inputs=[acc_input, mock_ip, mock_cookie, time_mode, custom_time_input], outputs=[role_tabs, welcome_text, store_df_all, store_df_abn, abnormal_log_input, acc_input])

    action_mapping = [
        (btn_eval, "click_eval_system"), (btn_pre_select, "click_pre_select_system"), (btn_add_drop, "click_add_drop_system"),
        (btn_istudy, "click_istudy"), (btn_card, "click_card_loss"), (btn_course, "click_course_system"),
        (btn_score, "click_score_query"), (btn_leave, "click_leave_system"), (btn_dorm, "click_dorm_system"),
        (btn_scholarship, "click_scholarship"), (btn_webmail, "click_webmail"), (btn_vdesk, "click_vdesk"),
        (btn_hack_score, "malicious_sql_injection")
    ]

    for btn, action_name in action_mapping:
        btn.click(
            fn=lambda ip, c, acc, tm, ct, n=action_name: simulate_click(ip, c, acc, n, tm, ct), 
            inputs=[mock_ip, mock_cookie, acc_input, time_mode, custom_time_input], 
            outputs=[store_df_all, store_df_abn, abnormal_log_input],
            api_name=None
        )
        
    test_mapping = [
        (t_pre_sel_norm, "click_pre_select_system", "2026-06-13 11:00:00"), (t_pre_sel_anom, "click_pre_select_system", "2026-10-15 13:00:00"),
        (t_course_norm, "click_course_system", "2026-02-25 07:50:00"), (t_course_anom, "click_course_system", "2026-07-15 05:00:00"),
        (t_add_drop_norm, "click_add_drop_system", "2026-02-18 14:00:00"), (t_add_drop_anom, "click_add_drop_system", "2026-05-15 12:00:00"),
        (t_eval_norm, "click_eval_system", "2026-12-17 13:20:00"), (t_eval_anom, "click_eval_system", "2026-03-15 03:00:00"),
        (t_score_norm, "click_score_query", "2026-11-17 18:50:00"), (t_score_anom, "click_score_query", "2026-02-15 03:00:00")
    ]
    
    for btn, action_name, test_time_str in test_mapping:
        btn.click(
            fn=lambda ip, c, acc, n=action_name, t_str=test_time_str: test_anomaly(ip, c, acc, n, t_str),
            inputs=[mock_ip, mock_cookie, acc_input],
            outputs=[store_df_all, store_df_abn, abnormal_log_input],
            api_name=None
        )

    # =====================================================================
    # 👉 隱藏的 UI 綁定區 (讓外部能透過 api_name 存取資料)
    # =====================================================================
    with gr.Group(visible=False):
        api_stats_btn = gr.Button("API_Stats")
        api_stats_out = gr.JSON()
        api_stats_btn.click(fn=api_get_stats, inputs=[], outputs=[api_stats_out], api_name="get_stats")
        
        api_logs_btn = gr.Button("API_Logs")
        api_logs_in = gr.Number(value=20)
        api_logs_out = gr.JSON()
        api_logs_btn.click(fn=api_get_logs, inputs=[api_logs_in], outputs=[api_logs_out], api_name="get_logs")
        
        api_chart_btn = gr.Button("API_Chart")
        api_chart_in = gr.Textbox()
        api_chart_out = gr.JSON()
        api_chart_btn.click(fn=api_get_chart_data, inputs=[api_chart_in], outputs=[api_chart_out], api_name="get_chart_data")
        
        api_abnormal_logs_btn = gr.Button("API_Abnormal_Logs")
        api_abnormal_logs_out = gr.JSON()
        api_abnormal_logs_btn.click(fn=api_get_abnormal_logs, inputs=[], outputs=[api_abnormal_logs_out], api_name="get_abnormal_logs")
        
        api_plot_btn = gr.Button("API_Plot")
        api_plot_in = gr.Textbox()
        api_plot_out = gr.Textbox()
        api_plot_btn.click(fn=get_plot_data_for_api, inputs=[api_plot_in], outputs=[api_plot_out], api_name="get_plot_data_api")
        
        api_update_weights_btn = gr.Button("API_Update_Weights")
        api_update_weights_ow = gr.Number(label="Overall Weight")
        api_update_weights_tw = gr.Number(label="Time Weight") 
        api_update_weights_iw = gr.Number(label="IP Weight")
        api_update_weights_dw = gr.Number(label="Device Weight")
        api_update_weights_gw = gr.Number(label="Geo Weight")
        api_update_weights_fw = gr.Number(label="Frequency Weight")
        api_update_weights_in = [api_update_weights_ow, api_update_weights_tw, api_update_weights_iw, api_update_weights_dw, api_update_weights_gw, api_update_weights_fw]
        api_update_weights_out = gr.Textbox()
        api_update_weights_btn.click(fn=update_system_weights, inputs=api_update_weights_in, outputs=[api_update_weights_out], api_name="update_system_weights")

        api_trust_log_btn = gr.Button("API_Trust_Log")
        api_log_status_in = gr.Textbox()
        api_trust_log_out = gr.JSON()
        api_trust_log_btn.click(fn=api_trust_log_action, inputs=[api_log_status_in], outputs=[api_trust_log_out], api_name="trust_log")

        api_block_log_btn = gr.Button("API_Block_Log")
        api_block_log_out = gr.JSON()
        api_block_log_btn.click(fn=api_block_log_action, inputs=[api_log_status_in], outputs=[api_block_log_out], api_name="block_log")
        
        api_explain_log_btn = gr.Button("API_Explain_Log")
        api_explain_log_in = gr.Textbox()
        api_explain_log_out = gr.JSON()
        api_explain_log_btn.click(fn=api_explain_log_action, inputs=[api_explain_log_in], outputs=[api_explain_log_out], api_name="explain_log")

        api_student_ip = gr.Textbox(label="ip")
        api_student_cookie = gr.Textbox(label="c")
        api_student_time_mode = gr.Radio(label="tm", choices=["真實時間 (目前時間)", "自訂時間 (模擬過去/未來)"], value="真實時間 (目前時間)")
        api_student_custom_time = gr.Textbox(label="ct")

        api_lambda_out = gr.Textbox()
        gr.Button("API_lambda", visible=False).click(fn=api_lambda, inputs=[api_student_ip, api_student_cookie, api_student_time_mode, api_student_custom_time], outputs=[api_lambda_out], api_name="lambda")

        api_lambda_1_out = gr.Textbox()
        gr.Button("API_lambda_1", visible=False).click(fn=api_lambda_1, inputs=[api_student_ip, api_student_cookie, api_student_time_mode, api_student_custom_time], outputs=[api_lambda_1_out], api_name="lambda_1")

        api_lambda_acc = gr.Textbox(label="acc")
        api_lambda_7_out = gr.Textbox()
        gr.Button("API_lambda_7", visible=False).click(fn=api_lambda_7, inputs=[api_student_ip, api_student_cookie, api_lambda_acc, api_student_time_mode, api_student_custom_time], outputs=[api_lambda_7_out], api_name="lambda_7")

        api_lambda_8_out = gr.Textbox()
        gr.Button("API_lambda_8", visible=False).click(fn=api_lambda_8, inputs=[api_student_ip, api_student_cookie, api_lambda_acc, api_student_time_mode, api_student_custom_time], outputs=[api_lambda_8_out], api_name="lambda_8")

        api_lambda_10_out = gr.Textbox()
        gr.Button("API_lambda_10", visible=False).click(fn=api_lambda_10, inputs=[api_student_ip, api_student_cookie, api_lambda_acc, api_student_time_mode, api_student_custom_time], outputs=[api_lambda_10_out], api_name="lambda_10")

        api_lambda_11_out = gr.Textbox()
        gr.Button("API_lambda_11", visible=False).click(fn=api_lambda_11, inputs=[api_student_ip, api_student_cookie, api_lambda_acc, api_student_time_mode, api_student_custom_time], outputs=[api_lambda_11_out], api_name="lambda_11")

        api_lambda_12_out = gr.Textbox()
        gr.Button("API_lambda_12", visible=False).click(fn=api_lambda_12, inputs=[api_student_ip, api_student_cookie, api_lambda_acc, api_student_time_mode, api_student_custom_time], outputs=[api_lambda_12_out], api_name="lambda_12")

        api_student_action_code = gr.Textbox(label="action_code")
        api_student_run_out = gr.Textbox()
        gr.Button("API_RunStudentAction", visible=False).click(fn=api_run_student_action_code, inputs=[api_student_ip, api_student_cookie, api_lambda_acc, api_student_action_code, api_student_time_mode, api_student_custom_time], outputs=[store_df_all, store_df_abn, api_student_run_out], api_name="run_student_action")

if __name__ == "__main__":
    demo.launch(css=custom_css)