ghazale-dashboards/dashboards/workshop-audit.html

326 lines
37 KiB
HTML
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

<!DOCTYPE html>
<html lang="fa" dir="rtl">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>پایش و ممیزی سانس‌های ورکشاپ‌های ایکیپا (Ekeepa)</title>
<link rel="preconnect" href="https://fonts.googleapis.com">
<link rel="preconnect" href="https://fonts.gstatic.com" crossorigin>
<link href="https://fonts.googleapis.com/css2?family=Vazirmatn:wght@300;400;500;600;700;800;900&display=swap" rel="stylesheet">
<script src="https://cdn.tailwindcss.com"></script>
<script>
tailwind.config = {
theme: {
extend: {
fontFamily: {
sans: ['Vazirmatn', 'sans-serif'],
},
colors: {
brand: {
50: '#f0fdf4',
500: '#10b981',
600: '#059669',
700: '#047857'
}
}
}
}
}
</script>
<style>
body {
font-family: 'Vazirmatn', sans-serif;
font-feature-settings: "tnum";
background-color: #F8FAFC;
color: #0F172A;
}
.tooltip-trigger:hover .tooltip-box {
visibility: visible;
opacity: 1;
}
</style>
</head>
<body class="min-h-screen p-4 md:p-8">
<div class="max-w-7xl mx-auto space-y-6">
<!-- Header -->
<header class="bg-white rounded-2xl p-6 shadow-sm border border-slate-200/80 flex flex-col md:flex-row md:items-center justify-between gap-4">
<div>
<div class="flex items-center gap-3">
<span class="inline-flex items-center justify-center p-2.5 bg-emerald-100 text-emerald-800 rounded-xl">
<svg class="w-6 h-6" fill="none" stroke="currentColor" viewBox="0 0 24 24"><path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4"/></svg>
</span>
<div>
<h1 class="text-2xl font-bold text-slate-900">سامانه پایش وضعیت و سانس‌های ورکشاپ‌های ایکیپا</h1>
<p class="text-sm text-slate-500 mt-1">واکشی و ممیزی مستقیم از API نسخه ۲ سامانه ekeepa.co در افق ۶۰ روزه تقویم</p>
</div>
</div>
</div>
<div class="flex items-center gap-3">
<span class="inline-flex items-center gap-1.5 px-3 py-1.5 rounded-full text-xs font-semibold bg-emerald-50 text-emerald-700 border border-emerald-200">
<span class="w-2 h-2 rounded-full bg-emerald-500 animate-pulse"></span>
🟢 داده زنده (LIVE API)
</span>
<span class="text-xs text-slate-400">۱۹ آبان ۱۴۰۵</span>
</div>
</header>
<!-- Critical Alert Card -->
<div class="bg-red-50 border-2 border-red-200 rounded-2xl p-5 shadow-sm">
<div class="flex items-start gap-4">
<div class="p-3 bg-red-100 text-red-600 rounded-xl mt-0.5">
<svg class="w-6 h-6" fill="none" stroke="currentColor" viewBox="0 0 24 24"><path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M12 9v2m0 4h.01m-6.938 4h13.856c1.54 0 2.502-1.667 1.732-3L13.732 4c-.77-1.333-2.694-1.333-3.464 0L3.34 16c-.77 1.333.192 3 1.732 3z"/></svg>
</div>
<div class="flex-1">
<div class="flex items-center justify-between">
<h3 class="text-base font-bold text-red-900">نتیجه قطعی ممیزی: ورکشاپ فعال بدون هیچ سانس آزاد کشف شد</h3>
<span class="px-2.5 py-0.5 bg-red-200 text-red-800 text-xs font-bold rounded-full">نیاز به اقدام فوری</span>
</div>
<p class="text-sm text-red-700 mt-1.5 leading-relaxed">
ورکشاپ <strong>«گلدوزی و آینه دوزی گوشواره»</strong> (شناسه <code class="bg-red-100 px-1 py-0.5 rounded text-red-900 font-bold">201298717</code> - مجموعه خانه چنور در کرج) دارای وضعیت سیستمی <strong>«فعال»</strong> (<code class="text-xs">status: 2, is_paused: false</code>) است، اما هر ۹ سانس تعریف‌شده در تقویم آینده وضعیت <strong>«پر‌شده»</strong> (<code class="text-xs">status: 2</code>) دارند؛ بنابراین هیچ سانسی برای رزرو توسط کاربران وجود ندارد (<strong>۰ سانس آزاد</strong>).
</p>
<div class="mt-3 flex flex-wrap gap-2 text-xs">
<span class="bg-white/90 border border-red-200 px-2.5 py-1 rounded-lg text-red-800">میزبان: مهسا (<bdi dir="ltr">09012351234</bdi>)</span>
<span class="bg-white/90 border border-red-200 px-2.5 py-1 rounded-lg text-red-800">کل سانس‌ها: ۹ جلسه چهارشنبه‌ها</span>
<span class="bg-white/90 border border-red-200 px-2.5 py-1 rounded-lg text-red-800 font-bold">سانس آزاد: ۰</span>
</div>
</div>
</div>
</div>
<!-- KPI Grid -->
<div class="grid grid-cols-1 sm:grid-cols-2 lg:grid-cols-4 gap-4">
<!-- Card 1 -->
<div class="bg-white rounded-2xl p-5 border border-slate-200 shadow-sm relative group">
<div class="flex items-center justify-between">
<span class="text-xs font-semibold text-slate-500">کل ورکشاپ‌ها</span>
<div class="relative tooltip-trigger cursor-pointer">
<span class="text-slate-400 hover:text-slate-600 font-bold text-xs bg-slate-100 rounded-full w-4 h-4 inline-flex items-center justify-center">i</span>
<div class="tooltip-box invisible opacity-0 transition-opacity absolute bottom-full mb-2 left-1/2 -translate-x-1/2 bg-slate-900 text-white text-[11px] p-2 rounded-lg w-48 shadow-lg pointer-events-none z-20 text-center">
تعداد کل ورکشاپ‌های استخراج‌شده از فایل ارسالی کاربر و بررسی‌شده در API.
</div>
</div>
</div>
<div class="text-3xl font-extrabold text-slate-900 mt-2">۲۱</div>
<div class="text-xs text-slate-500 mt-1">تطبیق ۱۰۰٪ با داده‌های پلتفرم</div>
</div>
<!-- Card 2 -->
<div class="bg-red-50/60 rounded-2xl p-5 border border-red-200 shadow-sm relative group">
<div class="flex items-center justify-between">
<span class="text-xs font-semibold text-red-700">فعال بدون سانس آزاد</span>
<div class="relative tooltip-trigger cursor-pointer">
<span class="text-red-400 hover:text-red-600 font-bold text-xs bg-red-100 rounded-full w-4 h-4 inline-flex items-center justify-center">i</span>
<div class="tooltip-box invisible opacity-0 transition-opacity absolute bottom-full mb-2 left-1/2 -translate-x-1/2 bg-slate-900 text-white text-[11px] p-2 rounded-lg w-52 shadow-lg pointer-events-none z-20 text-center">
ورکشاپ‌هایی که فعال هستند اما در تقویم ۶۰ روزه، تمام سانس‌های آن‌ها پر شده و صفر سانس باز دارند.
</div>
</div>
</div>
<div class="text-3xl font-extrabold text-red-600 mt-2">۱ <span class="text-sm font-normal text-red-700">(گلدوزی گوشواره)</span></div>
<div class="text-xs text-red-600 mt-1">۱۰۰٪ سانس‌های تعریف‌شده مسدود یا تکمیل است</div>
</div>
<!-- Card 3 -->
<div class="bg-amber-50/60 rounded-2xl p-5 border border-amber-200 shadow-sm relative group">
<div class="flex items-center justify-between">
<span class="text-xs font-semibold text-amber-800">در آستانه تکمیل (تنها ۱ سانس آزاد)</span>
<div class="relative tooltip-trigger cursor-pointer">
<span class="text-amber-400 hover:text-amber-600 font-bold text-xs bg-amber-100 rounded-full w-4 h-4 inline-flex items-center justify-center">i</span>
<div class="tooltip-box invisible opacity-0 transition-opacity absolute bottom-full mb-2 left-1/2 -translate-x-1/2 bg-slate-900 text-white text-[11px] p-2 rounded-lg w-52 shadow-lg pointer-events-none z-20 text-center">
ورکشاپ‌هایی که ۸ سانس از ۹ سانس آنها پر شده و فقط ۱ سانس باقی‌مانده دارند.
</div>
</div>
</div>
<div class="text-3xl font-extrabold text-amber-600 mt-2">۲ <span class="text-sm font-normal text-amber-700">(شمع‌سازی و کتابخوانی)</span></div>
<div class="text-xs text-amber-700 mt-1">۸۸٪ سانس‌ها پر شده است</div>
</div>
<!-- Card 4 -->
<div class="bg-emerald-50/60 rounded-2xl p-5 border border-emerald-200 shadow-sm relative group">
<div class="flex items-center justify-between">
<span class="text-xs font-semibold text-emerald-800">ظرفیت کافی و آماده رزرو</span>
<div class="relative tooltip-trigger cursor-pointer">
<span class="text-emerald-400 hover:text-emerald-600 font-bold text-xs bg-emerald-100 rounded-full w-4 h-4 inline-flex items-center justify-center">i</span>
<div class="tooltip-box invisible opacity-0 transition-opacity absolute bottom-full mb-2 left-1/2 -translate-x-1/2 bg-slate-900 text-white text-[11px] p-2 rounded-lg w-52 shadow-lg pointer-events-none z-20 text-center">
ورکشاپ‌های فعال با موجودی بیش از ۱ سانس آزاد برای ثبت‌نام مشتریان (۱۵ ورکشاپ کاملاً آزاد + ۳ ورکشاپ با تکمیل جزئی).
</div>
</div>
</div>
<div class="text-3xl font-extrabold text-emerald-600 mt-2">۱۸</div>
<div class="text-xs text-emerald-700 mt-1">دارای ۴ الی ۷۰ سانس آزاد در تقویم</div>
</div>
</div>
<!-- Filter and Search Bar -->
<div class="bg-white rounded-2xl p-4 border border-slate-200 shadow-sm flex flex-col md:flex-row items-center justify-between gap-4">
<div class="flex flex-wrap items-center gap-2">
<button onclick="setFilter('all')" id="btn-all" class="filter-btn px-3 py-1.5 text-xs font-bold rounded-xl bg-slate-900 text-white transition">همه موارد (۲۱)</button>
<button onclick="setFilter('zero')" id="btn-zero" class="filter-btn px-3 py-1.5 text-xs font-medium rounded-xl bg-slate-100 text-slate-700 hover:bg-red-100 hover:text-red-700 transition">🔴 بدون سانس آزاد (۱)</button>
<button onclick="setFilter('critical')" id="btn-critical" class="filter-btn px-3 py-1.5 text-xs font-medium rounded-xl bg-slate-100 text-slate-700 hover:bg-amber-100 hover:text-amber-700 transition">⚠️ فقط ۱ سانس آزاد (۲)</button>
<button onclick="setFilter('partial')" id="btn-partial" class="filter-btn px-3 py-1.5 text-xs font-medium rounded-xl bg-slate-100 text-slate-700 hover:bg-blue-100 hover:text-blue-700 transition">🟡 تکمیل جزئی (۳)</button>
<button onclick="setFilter('healthy')" id="btn-healthy" class="filter-btn px-3 py-1.5 text-xs font-medium rounded-xl bg-slate-100 text-slate-700 hover:bg-emerald-100 hover:text-emerald-700 transition">🟢 تماماً آزاد (۱۵)</button>
</div>
<div class="w-full md:w-80">
<input type="text" id="search-input" onkeyup="applySearch()" placeholder="جستجو بر اساس عنوان، شهر، شناسه یا میزبان..." class="w-full px-3.5 py-2 text-xs rounded-xl border border-slate-200 focus:outline-none focus:ring-2 focus:ring-slate-900 bg-slate-50">
</div>
</div>
<!-- Table Container -->
<div class="bg-white rounded-2xl border border-slate-200 shadow-sm overflow-hidden">
<div class="p-4 border-b border-slate-100 flex items-center justify-between">
<div class="flex items-center gap-2">
<h2 class="font-bold text-slate-800 text-sm">جدول جامع ارزیابی وضعیت و سانس‌های ورکشاپ‌ها</h2>
<div class="relative tooltip-trigger cursor-pointer">
<span class="text-slate-400 hover:text-slate-600 font-bold text-xs bg-slate-100 rounded-full w-4 h-4 inline-flex items-center justify-center">i</span>
<div class="tooltip-box invisible opacity-0 transition-opacity absolute bottom-full mb-2 right-0 bg-slate-900 text-white text-[11px] p-2.5 rounded-lg w-72 shadow-lg pointer-events-none z-20 text-right leading-relaxed">
داده‌ها از ترکیب مشخصات اولیه با کوئری ۶۰ روزه به اندپوینت <code>play-boxes-range</code> استخراج شده و وضعیت رزروپذیری هر سانس به طور مجزا محاسبه گردیده است.
</div>
</div>
</div>
<span id="showing-count" class="text-xs text-slate-400">نمایش ۲۱ از ۲۱ مورد</span>
</div>
<div class="overflow-x-auto">
<table class="w-full text-right text-xs">
<thead class="bg-slate-50 text-slate-600 font-bold border-b border-slate-200">
<tr>
<th class="p-3 w-10 text-center">#</th>
<th class="p-3">شناسه</th>
<th class="p-3">عنوان ورکشاپ</th>
<th class="p-3">مجموعه و شهر</th>
<th class="p-3">میزبان / تماس</th>
<th class="p-3 text-center">کل سانس‌ها</th>
<th class="p-3 text-center">سانس آزاد</th>
<th class="p-3 text-center">سانس پر</th>
<th class="p-3">نزدیک‌ترین سانس باز</th>
<th class="p-3 text-center">وضعیت دسترسی</th>
<th class="p-3 text-center">عملیات</th>
</tr>
</thead>
<tbody id="table-body" class="divide-y divide-slate-100 text-slate-700">
<!-- Populated via JS -->
</tbody>
</table>
</div>
</div>
</div>
<!-- Data Script -->
<script>
const rawData = [{"num": 1, "room_id": "201051411", "title": "ساخت ماگ شخصی و نقاشی روی ماگ(کرج)", "provider": "سفالگری کرج", "city": "کرج", "district": "استاندارد", "host": "جعفر پور", "phone": "989127051014", "file_status": "فعال", "api_status": 2, "is_paused": false, "is_full": false, "free_sans_today": 0, "available_count": 0, "total_sessions": 70, "sessions_available": 70, "sessions_full": 0, "status_breakdown": {"0": 70, "1": 0, "2": 0, "3": 0, "4": 0, "other": 0}, "first_available_sans": {"date": "2026-11-10", "start_time": 690, "remaining": 6, "price": 1700000}, "first_full_sans": null, "url": "https://ekeepa.co/room/201051411/ساخت-ماگ-شخصی-و-نقاشی-روی-ماگ(کرج)"}, {"num": 2, "room_id": "20879411", "title": "ساخت مهر شخصی چاپ روی توت بگ پارچه ای", "provider": "خانه هنگام", "city": "کرج", "district": "میدان استاندارد", "host": "المیرا علی اکبری", "phone": "989127077684", "file_status": "فعال", "api_status": 2, "is_paused": false, "is_full": false, "free_sans_today": 0, "available_count": 0, "total_sessions": 36, "sessions_available": 36, "sessions_full": 0, "status_breakdown": {"0": 36, "1": 0, "2": 0, "3": 0, "4": 0, "other": 0}, "first_available_sans": {"date": "2026-11-11", "start_time": 660, "remaining": 6, "price": 850000}, "first_full_sans": null, "url": "https://ekeepa.co/room/20879411/ساخت-مهر-شخصی-چاپ-روی-توت-بگ-پارچه-ای"}, {"num": 3, "room_id": "201298715", "title": "سرامیک سازی کودکان (چنور)", "provider": "خانه چنور", "city": "کرج", "district": "مهرشهر", "host": "فاطمه وفایی", "phone": "989213151753", "file_status": "فعال", "api_status": 2, "is_paused": false, "is_full": false, "free_sans_today": 1, "available_count": 0, "total_sessions": 9, "sessions_available": 9, "sessions_full": 0, "status_breakdown": {"0": 9, "1": 0, "2": 0, "3": 0, "4": 0, "other": 0}, "first_available_sans": {"date": "2026-11-08", "start_time": 960, "remaining": 6, "price": 980000}, "first_full_sans": null, "url": "https://ekeepa.co/room/201298715/سرامیک-سازی-کودکان-(چنور)"}, {"num": 4, "room_id": "201029411", "title": "سینما کمپ(کرج)", "provider": "استار اسکرین", "city": "کرج", "district": "کردان", "host": "معین محمدبیگی", "phone": "989127578385", "file_status": "فعال", "api_status": 2, "is_paused": false, "is_full": false, "free_sans_today": 0, "available_count": 0, "total_sessions": 9, "sessions_available": 4, "sessions_full": 5, "status_breakdown": {"0": 4, "1": 0, "2": 5, "3": 0, "4": 0, "other": 0}, "first_available_sans": {"date": "2026-12-02", "start_time": 1200, "remaining": 60, "price": 1490000}, "first_full_sans": {"date": "2026-11-11", "start_time": 1200, "status": 2, "price": 1490000}, "url": "https://ekeepa.co/room/201029411/سینما-کمپ(کرج)"}, {"num": 5, "room_id": "201548713", "title": "شمع سازی پاییزی", "provider": "خانه قرار", "city": "کرج", "district": "مهرویلا", "host": "یاسمن حسینی(خانه قرار)", "phone": "989024562140", "file_status": "فعال", "api_status": 2, "is_paused": false, "is_full": false, "free_sans_today": 0, "available_count": 0, "total_sessions": 9, "sessions_available": 1, "sessions_full": 8, "status_breakdown": {"0": 1, "1": 0, "2": 8, "3": 0, "4": 0, "other": 0}, "first_available_sans": {"date": "2026-11-11", "start_time": 900, "remaining": 6, "price": 1200000}, "first_full_sans": {"date": "2026-11-18", "start_time": 900, "status": 2, "price": 1200000}, "url": "https://ekeepa.co/room/201548713/شمع-سازی-پاییزی"}, {"num": 6, "room_id": "201298713", "title": "شمع سازی پاییزی(کرج)", "provider": "خانه چنور", "city": "کرج", "district": "مهرشهر", "host": "فاطمه وفایی", "phone": "989213151753", "file_status": "فعال", "api_status": 2, "is_paused": false, "is_full": true, "free_sans_today": 0, "available_count": 0, "total_sessions": 18, "sessions_available": 17, "sessions_full": 1, "status_breakdown": {"0": 17, "1": 0, "2": 1, "3": 0, "4": 0, "other": 0}, "first_available_sans": {"date": "2026-11-12", "start_time": 660, "remaining": 8, "price": 1400000}, "first_full_sans": {"date": "2026-11-08", "start_time": 660, "status": 2, "price": 1200000}, "url": "https://ekeepa.co/room/201298713/شمع-سازی-پاییزی(کرج)"}, {"num": 7, "room_id": "201298716", "title": "شمع سازی کودکان (چنور)", "provider": "خانه چنور", "city": "کرج", "district": "مهرشهر", "host": "فاطمه وفایی", "phone": "989213151753", "file_status": "فعال", "api_status": 2, "is_paused": false, "is_full": false, "free_sans_today": 0, "available_count": 0, "total_sessions": 9, "sessions_available": 9, "sessions_full": 0, "status_breakdown": {"0": 9, "1": 0, "2": 0, "3": 0, "4": 0, "other": 0}, "first_available_sans": {"date": "2026-11-12", "start_time": 960, "remaining": 1, "price": 1400000}, "first_full_sans": null, "url": "https://ekeepa.co/room/201298716/شمع-سازی-کودکان-(چنور)"}, {"num": 8, "room_id": "201432313", "title": "صابون سازی (نقش و نگار)", "provider": "اموزشگاه فنی و حرفه‌ای نقش و نگار", "city": "کرج", "district": "مصباح", "host": "غزاله پارساییان", "phone": "989210329528", "file_status": "فعال", "api_status": 2, "is_paused": false, "is_full": false, "free_sans_today": 0, "available_count": 0, "total_sessions": 9, "sessions_available": 4, "sessions_full": 5, "status_breakdown": {"0": 4, "1": 0, "2": 5, "3": 0, "4": 0, "other": 0}, "first_available_sans": {"date": "2026-11-18", "start_time": 900, "remaining": 10, "price": 888000}, "first_full_sans": {"date": "2026-11-11", "start_time": 900, "status": 2, "price": 888000}, "url": "https://ekeepa.co/room/201432313/صابون-سازی-(نقش-و-نگار)"}, {"num": 9, "room_id": "201120115", "title": "قصه نویسی", "provider": "آموزشگاه و مینی کافه ی کیا", "city": "کرج", "district": "فردیس", "host": "بیژن شیرمرز", "phone": "989058589073", "file_status": "فعال", "api_status": 2, "is_paused": false, "is_full": false, "free_sans_today": 1, "available_count": 0, "total_sessions": 9, "sessions_available": 9, "sessions_full": 0, "status_breakdown": {"0": 9, "1": 0, "2": 0, "3": 0, "4": 0, "other": 0}, "first_available_sans": {"date": "2026-11-08", "start_time": 1110, "remaining": 10, "price": 400000}, "first_full_sans": null, "url": "https://ekeepa.co/room/201120115/قصه-نویسی"}, {"num": 10, "room_id": "201548712", "title": "کتابخوانی (خانه قرار)", "provider": "خانه قرار", "city": "کرج", "district": "مهرویلا", "host": "یاسمن حسینی(خانه قرار)", "phone": "989024562140", "file_status": "فعال", "api_status": 2, "is_paused": false, "is_full": false, "free_sans_today": 0, "available_count": 0, "total_sessions": 9, "sessions_available": 1, "sessions_full": 8, "status_breakdown": {"0": 1, "1": 0, "2": 8, "3": 0, "4": 0, "other": 0}, "first_available_sans": {"date": "2026-11-11", "start_time": 960, "remaining": 19, "price": 420000}, "first_full_sans": {"date": "2026-11-18", "start_time": 960, "status": 2, "price": 420000}, "url": "https://ekeepa.co/room/201548712/کتابخوانی-(خانه-قرار)"}, {"num": 11, "room_id": "201298717", "title": "گلدوزی و آینه دوزی گوشواره", "provider": "خانه چنور", "city": "کرج", "district": "مهرشهر", "host": "فاطمه وفایی", "phone": "989213151753", "file_status": "فعال", "api_status": 2, "is_paused": false, "is_full": false, "free_sans_today": 0, "available_count": 0, "total_sessions": 9, "sessions_available": 0, "sessions_full": 9, "status_breakdown": {"0": 0, "1": 0, "2": 9, "3": 0, "4": 0, "other": 0}, "first_available_sans": null, "first_full_sans": {"date": "2026-11-11", "start_time": 840, "status": 2, "price": 3500000}, "url": "https://ekeepa.co/room/201298717/گلدوزی-و-آینه-دوزی-گوشواره"}, {"num": 12, "room_id": "20879412", "title": "نقاشی روی آبجکت های سنگی", "provider": "خانه هنگام", "city": "کرج", "district": "استاندارد", "host": "المیرا علی اکبری", "phone": "989127077684", "file_status": "فعال", "api_status": 2, "is_paused": false, "is_full": false, "free_sans_today": 0, "available_count": 0, "total_sessions": 36, "sessions_available": 36, "sessions_full": 0, "status_breakdown": {"0": 36, "1": 0, "2": 0, "3": 0, "4": 0, "other": 0}, "first_available_sans": {"date": "2026-11-11", "start_time": 660, "remaining": 6, "price": 1200000}, "first_full_sans": null, "url": "https://ekeepa.co/room/20879412/نقاشی-روی-آبجکت-های-سنگی"}, {"num": 13, "room_id": "201051413", "title": "نقاشی روی ماگ شخصی(کرج)", "provider": "سفالگری کرج", "city": "کرج", "district": "استاندارد", "host": "جعفر پور", "phone": "989127051014", "file_status": "فعال", "api_status": 2, "is_paused": false, "is_full": false, "free_sans_today": 0, "available_count": 0, "total_sessions": 53, "sessions_available": 53, "sessions_full": 0, "status_breakdown": {"0": 53, "1": 0, "2": 0, "3": 0, "4": 0, "other": 0}, "first_available_sans": {"date": "2026-11-10", "start_time": 960, "remaining": 4, "price": 950000}, "first_full_sans": null, "url": "https://ekeepa.co/room/201051413/نقاشی-روی-ماگ-شخصی(کرج)"}, {"num": 14, "room_id": "20879413", "title": "نقاشی و طراحی روی صندوقچه های چوبی", "provider": "خانه هنگام", "city": "کرج", "district": "استاندارد", "host": "المیرا علی اکبری", "phone": "989127077684", "file_status": "فعال", "api_status": 2, "is_paused": false, "is_full": false, "free_sans_today": 0, "available_count": 0, "total_sessions": 18, "sessions_available": 18, "sessions_full": 0, "status_breakdown": {"0": 18, "1": 0, "2": 0, "3": 0, "4": 0, "other": 0}, "first_available_sans": {"date": "2026-11-11", "start_time": 900, "remaining": 6, "price": 1000000}, "first_full_sans": null, "url": "https://ekeepa.co/room/20879413/نقاشی-و-طراحی-روی-صندوقچه-های-چوبی"}, {"num": 15, "room_id": "201120112", "title": "نمایشنامه خوانی(کرج)", "provider": "آموزشگاه و مینی کافه ی کیا", "city": "کرج", "district": "فردیس", "host": "بیژن شیرمرز", "phone": "989058589073", "file_status": "فعال", "api_status": 2, "is_paused": false, "is_full": false, "free_sans_today": 0, "available_count": 0, "total_sessions": 8, "sessions_available": 8, "sessions_full": 0, "status_breakdown": {"0": 8, "1": 0, "2": 0, "3": 0, "4": 0, "other": 0}, "first_available_sans": {"date": "2026-11-14", "start_time": 1110, "remaining": 19, "price": 400000}, "first_full_sans": null, "url": "https://ekeepa.co/room/201120112/نمایشنامه-خوانی(کرج)"}, {"num": 16, "room_id": "201120113", "title": "نمایش و تحلیل فیلم (کرج)", "provider": "آموزشگاه و مینی کافه ی کیا", "city": "کرج", "district": "فردیس", "host": "بیژن شیرمرز", "phone": "989058589073", "file_status": "فعال", "api_status": 2, "is_paused": false, "is_full": false, "free_sans_today": 0, "available_count": 0, "total_sessions": 9, "sessions_available": 9, "sessions_full": 0, "status_breakdown": {"0": 9, "1": 0, "2": 0, "3": 0, "4": 0, "other": 0}, "first_available_sans": {"date": "2026-11-10", "start_time": 1110, "remaining": 20, "price": 500000}, "first_full_sans": null, "url": "https://ekeepa.co/room/201120113/نمایش-و-تحلیل-فیلم-(کرج)"}, {"num": 17, "room_id": "561347211", "title": "نقاشی روی بوم (مریوان)", "provider": "ساره آرت", "city": "مريوان", "district": "مریوان", "host": "ساره عزیزی", "phone": "989120472575", "file_status": "فعال", "api_status": 2, "is_paused": false, "is_full": false, "free_sans_today": 0, "available_count": 0, "total_sessions": 8, "sessions_available": 8, "sessions_full": 0, "status_breakdown": {"0": 8, "1": 0, "2": 0, "3": 0, "4": 0, "other": 0}, "first_available_sans": {"date": "2026-11-14", "start_time": 600, "remaining": 1, "price": 1300000}, "first_full_sans": null, "url": "https://ekeepa.co/room/561347211/نقاشی-روی-بوم-(مریوان)"}, {"num": 18, "room_id": "401631312", "title": "جواهردوزی", "provider": "خونه", "city": "مشهد", "district": "صیاد", "host": "نگار قاسمی", "phone": "989159299757", "file_status": "فعال", "api_status": 2, "is_paused": false, "is_full": false, "free_sans_today": 0, "available_count": 0, "total_sessions": 9, "sessions_available": 9, "sessions_full": 0, "status_breakdown": {"0": 9, "1": 0, "2": 0, "3": 0, "4": 0, "other": 0}, "first_available_sans": {"date": "2026-11-10", "start_time": 960, "remaining": 1, "price": 900000}, "first_full_sans": null, "url": "https://ekeepa.co/room/401631312/جواهردوزی"}, {"num": 19, "room_id": "401471311", "title": "ساخت آینه دکوراتیو خمیری(کودک)", "provider": "طاووس آرت", "city": "مشهد", "district": "سجاد", "host": "حسنیه نقی زاده", "phone": "989157154972", "file_status": "فعال", "api_status": 2, "is_paused": false, "is_full": false, "free_sans_today": 0, "available_count": 0, "total_sessions": 9, "sessions_available": 9, "sessions_full": 0, "status_breakdown": {"0": 9, "1": 0, "2": 0, "3": 0, "4": 0, "other": 0}, "first_available_sans": {"date": "2026-11-11", "start_time": 1080, "remaining": 8, "price": 700000}, "first_full_sans": null, "url": "https://ekeepa.co/room/401471311/ساخت-آینه-دکوراتیو-خمیری(کودک)"}, {"num": 20, "room_id": "401147111", "title": "مهد کودک بزرگترها(تربت جام)", "provider": "راضیه شهابی", "city": "مشهد", "district": "تربت جام", "host": "راضیه شهابی", "phone": "989217509107", "file_status": "فعال", "api_status": 2, "is_paused": false, "is_full": false, "free_sans_today": 0, "available_count": 0, "total_sessions": 9, "sessions_available": 9, "sessions_full": 0, "status_breakdown": {"0": 9, "1": 0, "2": 0, "3": 0, "4": 0, "other": 0}, "first_available_sans": {"date": "2026-11-12", "start_time": 1080, "remaining": 10, "price": 160000}, "first_full_sans": null, "url": "https://ekeepa.co/room/401147111/مهد-کودک-بزرگترها(تربت-جام)"}, {"num": 21, "room_id": "401376011", "title": "ورکشاپ خلق سفال", "provider": "نیسترسرام", "city": "مشهد", "district": "کلاهدوز", "host": "نسترن اسفندیاری", "phone": "989156973970", "file_status": "فعال", "api_status": 2, "is_paused": false, "is_full": false, "free_sans_today": 0, "available_count": 0, "total_sessions": 9, "sessions_available": 9, "sessions_full": 0, "status_breakdown": {"0": 9, "1": 0, "2": 0, "3": 0, "4": 0, "other": 0}, "first_available_sans": {"date": "2026-11-12", "start_time": 660, "remaining": 1, "price": 1270000}, "first_full_sans": null, "url": "https://ekeepa.co/room/401376011/ورکشاپ-خلق-سفال"}];
let currentFilter = 'all';
function renderTable(items) {
const tbody = document.getElementById('table-body');
tbody.innerHTML = '';
items.forEach((item) => {
const tr = document.createElement('tr');
tr.className = 'hover:bg-slate-50/80 transition';
let statusBadge = '';
let bgAlert = '';
if (item.sessions_available === 0) {
statusBadge = '<span class="inline-flex items-center gap-1 px-2.5 py-1 rounded-full text-[11px] font-bold bg-red-100 text-red-800">🔴 بدون سانس آزاد</span>';
bgAlert = 'bg-red-50/50';
} else if (item.sessions_available === 1) {
statusBadge = '<span class="inline-flex items-center gap-1 px-2.5 py-1 rounded-full text-[11px] font-bold bg-amber-100 text-amber-800">⚠️ فقط ۱ سانس</span>';
bgAlert = 'bg-amber-50/25';
} else if (item.sessions_full > 0) {
statusBadge = `<span class="inline-flex items-center gap-1 px-2.5 py-1 rounded-full text-[11px] font-medium bg-blue-100 text-blue-800">${item.sessions_available} آزاد / ${item.sessions_full} پر</span>`;
} else {
statusBadge = `<span class="inline-flex items-center gap-1 px-2.5 py-1 rounded-full text-[11px] font-medium bg-emerald-100 text-emerald-800">🟢 ${item.sessions_available} سانس آزاد</span>`;
}
if (bgAlert) tr.classList.add(bgAlert);
let firstSansText = '<span class="text-slate-400">-</span>';
if (item.first_available_sans) {
const fs = item.first_available_sans;
const h = Math.floor(fs.start_time / 60);
const m = fs.start_time % 60;
firstSansText = `<span class="font-medium text-slate-800">${fs.date}</span> <span class="text-slate-400">ساعت</span> <span class="font-bold">${String(h).padStart(2,'0')}:${String(m).padStart(2,'0')}</span>`;
}
tr.innerHTML = `
<td class="p-3 text-center text-slate-400 font-mono">${item.num}</td>
<td class="p-3 font-mono font-bold text-slate-900">${item.room_id}</td>
<td class="p-3 font-semibold text-slate-900 max-w-[220px] truncate" title="${item.title}">${item.title}</td>
<td class="p-3">
<div class="font-medium text-slate-800">${item.provider}</div>
<div class="text-[11px] text-slate-400">${item.city} - ${item.district || ''}</div>
</td>
<td class="p-3">
<div class="text-slate-800">${item.host || '-'}</div>
<div class="text-[11px] text-slate-400 font-mono"><bdi dir="ltr">${item.phone || '-'}</bdi></div>
</td>
<td class="p-3 text-center font-bold text-slate-700">${item.total_sessions}</td>
<td class="p-3 text-center font-bold ${item.sessions_available === 0 ? 'text-red-600' : 'text-emerald-600'}">${item.sessions_available}</td>
<td class="p-3 text-center font-bold text-slate-500">${item.sessions_full}</td>
<td class="p-3">${firstSansText}</td>
<td class="p-3 text-center">${statusBadge}</td>
<td class="p-3 text-center">
<a href="${item.url}" target="_blank" class="inline-flex items-center gap-1 px-2.5 py-1 rounded-lg text-[11px] font-medium bg-slate-100 hover:bg-slate-200 text-slate-800 transition">
مشاهده
<svg class="w-3 h-3" fill="none" stroke="currentColor" viewBox="0 0 24 24"><path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M10 6H6a2 2 0 00-2 2v10a2 2 0 002 2h10a2 2 0 002-2v-4M14 4h6m0 0v6m0-6L10 14"/></svg>
</a>
</td>
`;
tbody.appendChild(tr);
});
document.getElementById('showing-count').innerText = `نمایش ${items.length} از ${rawData.length} مورد`;
}
function setFilter(filterType) {
currentFilter = filterType;
document.querySelectorAll('.filter-btn').forEach(btn => {
btn.className = 'filter-btn px-3 py-1.5 text-xs font-medium rounded-xl bg-slate-100 text-slate-700 hover:bg-slate-200 transition';
});
const activeBtn = document.getElementById('btn-' + filterType);
if (activeBtn) {
activeBtn.className = 'filter-btn px-3 py-1.5 text-xs font-bold rounded-xl bg-slate-900 text-white transition';
}
applySearch();
}
function applySearch() {
const query = document.getElementById('search-input').value.trim().toLowerCase();
let filtered = rawData;
if (currentFilter === 'zero') {
filtered = filtered.filter(x => x.sessions_available === 0);
} else if (currentFilter === 'critical') {
filtered = filtered.filter(x => x.sessions_available === 1);
} else if (currentFilter === 'partial') {
filtered = filtered.filter(x => x.sessions_full > 0 && x.sessions_available > 1);
} else if (currentFilter === 'healthy') {
filtered = filtered.filter(x => x.sessions_full === 0 && x.sessions_available > 1);
}
if (query) {
filtered = filtered.filter(x =>
x.title.toLowerCase().includes(query) ||
x.room_id.toLowerCase().includes(query) ||
x.city.toLowerCase().includes(query) ||
x.provider.toLowerCase().includes(query) ||
(x.host && x.host.toLowerCase().includes(query))
);
}
renderTable(filtered);
}
// Initial render
renderTable(rawData);
</script>
</body>
</html>