Update app.py

app.py

@@ -52,7 +52,7 @@ def check_url_action(request: gr.Request):
 
 
 # ==========================================
-# 模組 1：訂位與通知管理 (包含 No-Show 切換)
+# 模組 1：訂位與通知管理 (包含 No-Show 切換與手動狀態)
 # ==========================================
 
 def get_bookings():
@@ -138,6 +138,17 @@ def toggle_no_show(booking_id, is_noshow=True):
     except Exception as e:
         return f"❌ 錯誤: {str(e)}"
 
+# 🌟 新增：手動強制更新狀態 🌟
+def update_booking_status(booking_id, new_status):
+    if not booking_id: return "❌ 請輸入訂單 ID"
+    if not new_status: return "⚠️ 請選擇要更改的新狀態"
+    try:
+        res = supabase.table("bookings").update({"status": new_status}).eq("id", booking_id).execute()
+        if not res.data: raise Exception("找不到該筆訂單或權限不足")
+        return f"✅ 訂單 {booking_id} 狀態已成功更新為：【{new_status}】"
+    except Exception as e:
+        return f"❌ 狀態更新失敗: {str(e)}"
+
 def render_booking_cards():
     df = get_bookings()
     count_html = f"<div style='color:#bbb; margin-bottom:10px; text-align:right; font-size:14px;'>📊 共 <span style='color:#fff; font-weight:bold;'>{len(df)}</span> 筆資料</div>"
@@ -154,6 +165,7 @@ def render_booking_cards():
         elif '取消' in status: status_bg = "#e74c3c"; status_tx = "#fff"; border_color = "#e74c3c"
         elif '已發' in status: status_bg = "#f1c40f"; status_tx = "#000"; border_color = "#f1c40f"
         elif 'No-Show' in status: status_bg = "#000"; status_tx = "#e74c3c"; border_color = "#e74c3c"
+        elif '付款' in status: status_bg = "#3498db"; status_tx = "#fff"; border_color = "#3498db"
 
         line_badge = "<span style='background:#00B900; color:white; padding:2px 6px; border-radius:4px; font-size:0.7em; margin-left:8px;'>LINE綁定</span>" if has_line else ""
 
@@ -324,19 +336,37 @@ with gr.Blocks(title="Cié Cié Admin", css=custom_css, theme=gr.themes.Monochro
         # --- 分頁 1：訂位與通知管理 ---
         with gr.TabItem("🍷 訂位與通知管理"):
             with gr.Column(elem_id="op-panel"):
-                gr.Markdown("### 🚀 發送通知與防鴿子標記")
+                gr.Markdown("### 🚀 訂單操作控制台")
+                
+                # 第一排：ID 輸入與狀態變更選單
                 with gr.Row():
-                    id_input = gr.Number(label="輸入訂單 ID", precision=0, scale=2)
-                    send_btn = gr.Button("🚀 發送提醒/確認", variant="primary", scale=1)
-                    # No-Show 雙按鈕
+                    id_input = gr.Number(label="輸入訂單 ID", precision=0, scale=1)
+                    new_status_dropdown = gr.Dropdown(
+                        label="手動選擇新狀態", 
+                        choices=["待處理", "待處理 (已付訂金)", "待付款", "已發確認信", "顧客已確認", "顧客已取消", "No-Show", "已完成 (結案)"], 
+                        scale=1
+                    )
+                    
+                # 第二排：各式操作按鈕
+                with gr.Row():
+                    send_btn = gr.Button("🚀 發信/LINE", variant="primary", scale=1)
+                    update_status_btn = gr.Button("💾 變更狀態", variant="secondary", scale=1)
                     noshow_btn = gr.Button("🚫 標記 No-Show", variant="stop", scale=1) 
                     revert_noshow_btn = gr.Button("✅ 撤銷 No-Show", scale=1) 
                     refresh_btn = gr.Button("🔄 刷新列表", scale=1)
+                
                 log_output = gr.Textbox(label="執行結果日誌", lines=1)
 
             booking_display = gr.HTML(elem_id="booking_display")
             
-            # 按鈕事件
+            # 🌟 新增：手動更新狀態的按鈕事件 🌟
+            update_status_btn.click(
+                update_booking_status, 
+                inputs=[id_input, new_status_dropdown], 
+                outputs=log_output
+            ).then(render_booking_cards, outputs=booking_display)
+
+            # 其餘按鈕事件
             refresh_btn.click(render_booking_cards, outputs=booking_display)
             send_btn.click(send_confirmation_hybrid, inputs=id_input, outputs=log_output).then(render_booking_cards, outputs=booking_display)
             noshow_btn.click(toggle_no_show, inputs=[id_input, gr.State(True)], outputs=log_output).then(render_booking_cards, outputs=booking_display)