QR code-based classroom identification system built as a thesis project — deployed and running live at school, tracking 53 rooms and 69 teachers in real time.

• 🟢 Real-time room status — see which rooms are free or occupied right now
• 👩‍🏫 Teacher finder — search any of the 69 teachers and see where they are
• 📺 Corridor display mode — full-screen TV/tablet view for hallway screens
• 🖨️ QR code generator — generate & print QR codes for every classroom
• 📅 Weekly timetable — per-room and per-teacher schedule view
• 🔐 Admin panel — password-protected dashboard for managing teachers and rooms
• ⚡ Auto-refresh — data updates every 30–60 seconds without page reload

GET /api/terem/204
{
  "terem": "204",
  "allapot": "foglalt",
  "aktualis": {
    "tanar": "ÁSZJ",
    "tanar_nev": "Ácsné Szűcs Judit",
    "osztaly": "9.b",
    "tantargy": "mny",
    "kezdes": "09:15",
    "vegzes": "10:00",
    "perc_maradt": 23
  },
  "kovetkezo": {
    "tanar": "ÁSZJ",
    "osztaly": "10.c",
    "kezdes": "10:15",
    "vegzes": "11:00"
  }
}

ticky-backend/
├── index.php              ← Router
├── config/
│   └── supabase.php       ← Supabase connection
├── utils/
│   └── helpers.php        ← Routing, CORS, JSON helpers
├── api/
│   ├── terem.php
│   ├── termek.php
│   ├── napirend.php
│   ├── tanarok.php
│   ├── tanar_orarend.php
│   ├── admin_tanar.php
│   └── admin_terem.php
└── pages/
    ├── terem.php          ← /terem/{number}
    ├── termek.php         ← /termek
    ├── napirend.php       ← /terem/{number}/nap
    ├── tanar.php          ← /tanar
    ├── kijelzo.php        ← /kijelzo
    ├── qr.php             ← /qr
    └── admin.php          ← hidden route from `ADMIN_PATH`

1. Push ticky-backend/ to GitHub
2. Render → New Web Service → Connect repo
3. Build command: echo "No build needed"
4. Start command: php -S 0.0.0.0:$PORT index.php
5. Set environment variables (see below)
6. Deploy — takes ~1–2 minutes

cd importer
npm install
node importer.js

Requires a .env file with SUPABASE_URL and SUPABASE_SERVICE_KEY. The importer wipes existing data and re-uploads. Run it whenever the timetable changes.

het_napja: 1 = Monday … 5 = Friday

Built with ☕ by Davedka