JKT48 Database

Aplikasi web berbasis Laravel untuk mengelola database JKT48 — member, generasi, single (senbatsu), team, riwayat kapten, peta member, dan diskografi lengkap (songs, albums, setlists, coupling songs, sub-units, MV locations) — dengan dashboard publik, panel admin, sorter interaktif, REST API terbuka, dan bot notifikasi (Telegram + Discord).

Live: https://jkt48.rebornian48.my.id API docs: https://jkt48.rebornian48.my.id/api/docs

---

Fitur

Dashboard publik (/)

• Statistik ringkas: total member, aktif, lulus, generasi, singles.
• Chart pertumbuhan member harian (Chart.js).
• Top 10 tenure, top senbatsu, top center.
• Distribusi usia & birthplace.
• Kapten aktif per posisi.

Daftar member (/members)

• Grid kartu member dgn foto, generasi, status.
• Filter: search text, generasi, status. Pagination.

Detail member (/members/{id})

• Profil lengkap, timeline karier, daftar single, riwayat kapten, riwayat team.

Singles (/singles, /singles/{id})

• List semua single dgn jumlah member per single.
• Klik kartu single → halaman detail: cover art, judul + judul JP, asal grup, tanggal rilis, daftar senbatsu lengkap dgn foto + nama + generasi (center border merah + badge "CENTER", diurutkan A–Z), section Daftar Lagu (link preview YouTube), dan section Coupling Songs (center + member list dgn kartu foto).

Albums & EP (/albums, /albums/{id})

• Grid berkelompok Album Studio vs Mini Album/EP.
• Detail album: tracklist ter-link ke katalog songs (judul asal, asal grup, link preview YouTube).
• 5 studio album + 1 EP di seeder awal.

Setlists (/setlists, /setlists/{id})

• Grid berkelompok Reguler vs Special.
• Detail setlist: daftar lagu berurutan (judul asal, asal grup, single terkait, link preview YouTube).
• 17 setlist reguler + 10 special di seeder awal.

Captains (/captains)

• Timeline kapten per posisi (chart) + riwayat berurutan.
• Kapten sekarang linked ke team (Team J / KIII / T / dst).

Statistik (/statistik)

• Tabel gabungan per-generasi: jumlah member aktif/lulus, rata-rata usia sekarang, rata-rata usia saat join, rata-rata masa aktif (untuk yg lulus), dan rata-rata "days to graduate".
• Baris khusus Kaigai dan Transfer (Kaigai 1 + Kaigai 2 + Transfer digabung).
• Baris New Era survivors (exclude Gen 10).
• Split JKT48V Gen 1 vs Gen 2.
• Fallback ke Generation.join_date bila member belum di-set manual.

Restrukturisasi (/restrukturisasi)

• Ringkasan hasil restrukturisasi: distribusi per restructure_status (JKT48 / Team Dream / Team Love / Trainee / dsb.), termasuk yg diumumkan lulus.

Kalender (/kalender)

• Kalender event bulanan: ulang tahun semua member (aktif + lulus), tanggal announce & tanggal lulus.
• Setiap event nampilkan usia member saat kejadian.

Peta JKT48 (/peta, /peta/{slug})

• Peta interaktif berbasis Leaflet: sebaran birthplace member, titik/polygon/polyline custom, catatan per titik.
• Data disimpan di master maps + map_points / map_polylines / map_polygon_layers / map_notes.
• Bisa di-seed dari Google Sheets via JKT48MapSeeder (butuh GOOGLE_SHEETS_API_KEY + JKT48_MAP_SHEET_ID).
• Endpoint JSON: GET /api/peta/{slug} (dipakai frontend map, bukan bagian dari REST API publik).

Sorter interaktif (/sorter)

• Neobrutalism UI — border hitam tebal, hard shadow, palet cream/kuning/pink/lime, tipografi display Archivo Black.
• Member sorter (/sorter/member) — merge sort interaktif berbasis perbandingan berpasangan.
  • Filter status (Aktif/Lulus) + generasi.
  • Pilih Kiri / Kanan / Seri; keyboard shortcut ← → ↓ U.
  • Progress bar + undo 1 langkah (tombol di header & di kolom tengah, dekat Seri).
  • Hasil: toggle ranking Unik / Tie 1,1,2,3 / Tie 1,1,3,4.
  • Salin teks, screenshot PNG (html2canvas).
• Song sorter (/sorter/song) — merge sort untuk katalog 425+ lagu diskografi.
  • Filter status rilis (Sudah/Belum) + asal grup (Original, JKT48, AKB48, dsb.) + search judul.
  • Kartu battle menampilkan cover art single (fallback initial), subtitle AsalGrup • SingleTitle.
  • Semua fitur core sama dengan Member sorter (undo, ranking mode, salin, screenshot).
• Arsitektur extensible — algoritma & UI dishare di public/js/sorter-core.js. Nambah tipe baru cukup: (1) tambah case di SorterController::SUPPORTED_TYPES + method data{Type}(), (2) buat sorter/{type}.blade.php (filter panel), (3) public/js/sorter-{type}.js (wiring filter → SorterCore.start({items, filter, formatSubtitle?, formatBadge?})).

REST API v1 (/api/v1/*)

Read-only JSON API, JSON:API-ish envelope (data + meta pagination). No auth (public dataset). Base URL: https://jkt48.rebornian48.my.id/api.

JKT48 Data API disusun oleh Rebornian48.

Endpoint	Fungsi
GET /api/v1/members	List member (filter: q, status, generation_id, team_id; pagination page, per_page)
GET /api/v1/members/{id}	Detail member + relasi (singles, captains, teams)
GET /api/v1/singles	List single + jumlah member
GET /api/v1/singles/{id}	Detail single + tracklist member
GET /api/v1/generations	List generasi
GET /api/v1/generations/{id}	Detail generasi + member
GET /api/v1/teams	List team
GET /api/v1/teams/{id}	Detail team + member aktif
GET /api/v1/captains	List kapten (per posisi/team)
GET /api/v1/statistics	Statistik gabungan per generasi
GET /api/v1/songs · /songs/{id}	Katalog 425 lagu (filter: q, single_id, origin_group, released; sort: external_id, title, debut_date)
GET /api/v1/albums · /albums/{id}	Album + EP (filter type=album|ep, include tracks)
GET /api/v1/setlists · /setlists/{id}	Setlist (filter type=regular|special)
GET /api/v1/coupling-songs · /coupling-songs/{id}	Coupling songs (filter single_id, include members + role)
GET /api/v1/sub-units · /sub-units/{id}	Sub-unit + lagu-nya
GET /api/v1/mv-locations · /mv-locations/{id}	Lokasi syuting MV (filter category, year, has_coords)

Swagger UI: https://jkt48.rebornian48.my.id/api/docs — spec OpenAPI di /api/docs/openapi.json.

Bot notifikasi (Telegram + Discord)

Broadcast otomatis ke Telegram dan/atau Discord ketika ada:

• Ulang tahun member aktif (per hari).
• Kelulusan member (per hari, berdasarkan graduation_date).

Dedupe pakai tabel notification_logs — aman kalau scheduler jalan berkali-kali di hari yg sama.

Selain broadcast, bot juga menerima command inbound:

Command	Fungsi
/help	Bantuan
/ultah	Member yang berulang tahun hari ini
/lulus	Kelulusan bulan ini
/member <nama>	Cari member (max 5 hasil)
/jadwal	Semua event bulan ini

Nambah command baru: tambah case di App\Services\Notifications\CommandRouter::handle() — otomatis jalan di Telegram maupun Discord.

Setup singkat:

1. Isi .env (lihat blok Bot notifications di .env.example).
2. php artisan migrate — buat tabel notification_logs.
3. Aktifkan cron scheduler (Hostinger cron 1 menit sekali):

   * * * * * cd ~/domains/jkt48.rebornian48.my.id/public_html && php artisan schedule:run >> /dev/null 2>&1
   

4. Telegram: set webhook agar bot menerima command:

   curl "https://api.telegram.org/bot<TOKEN>/setWebhook?url=https://<APP_URL>/webhooks/telegram/<TELEGRAM_WEBHOOK_SECRET>"
   

5. Discord (webhook broadcast): cukup buat Incoming Webhook di channel → paste URL ke DISCORD_WEBHOOK_URLS.
6. Discord (slash command opsional): di Developer Portal → set Interactions Endpoint URL ke https://<APP_URL>/webhooks/discord, isi DISCORD_PUBLIC_KEY, lalu register command (/ultah, /lulus, /member, /jadwal, /help) via API. Signature Ed25519 diverifikasi di controller.

Manual test broadcast hari ini:

php artisan notifications:daily
php artisan notifications:daily --date=2026-09-15

Panel admin (/admin)

• Auth berbasis session dgn admin_users table (bcrypt). Default: admin / data_jkt48.
• CRUD inti: members, singles, generations, captains, teams, maps (peta).
• CRUD Diskografi: songs, albums (tracklist inline), setlists (multi-select lagu, urutan = position), coupling-songs (multi-select member + center → sync ke pivot), sub-units (lagu inline), mv-locations (lat/long).
• Form Single diperluas: title_jp, origin_group, release_year, mv_title, mv_url, cover_art_url, audio_file.
• Ganti password (/admin/password).
• Dokumentasi in-app (/admin/docs/{api,telegram,discord}) — panduan API, setup bot Telegram, setup bot Discord.

---

Tech Stack

• Backend: Laravel 13 (PHP 8.3+)
• Frontend: Blade + Tailwind CSS (CDN) + Chart.js + Leaflet (peta)
• Style: Neobrutalism global (public/css/neo.css) — cream ground, chunky borders, hard offset shadows, Archivo Black headings.
• DB: MySQL / MariaDB
• API docs: Swagger UI (spec OpenAPI 3.0 di App\Http\Controllers\Api\DocsController).
• Deployment: Hostinger shared hosting via Git auto-deploy

---

Struktur Proyek

jkt48_data/
├── app/
│   ├── Http/Controllers/
│   │   ├── DashboardController.php     # halaman publik
│   │   ├── LoginController.php
│   │   ├── PetaController.php          # peta publik
│   │   ├── SorterController.php        # sorter (extensible per type)
│   │   ├── Admin/                      # CRUD admin + docs + password
│   │   ├── Api/                        # REST API v1 + Swagger docs
│   │   └── Webhooks/                   # Telegram + Discord inbound
│   ├── Models/
│   │   ├── Member.php  Generation.php  Single.php  Captain.php
│   │   ├── Team.php    MemberTeam.php  AdminUser.php
│   │   ├── Map.php     MapPoint.php    MapPolyline.php ...
│   │   └── Song.php    Album.php  AlbumTrack.php  Setlist.php  SetlistSong.php
│   │       CouplingSong.php  CouplingSongMember.php
│   │       SubUnit.php  SubUnitSong.php  MvLocation.php
│   └── Services/Notifications/         # Broadcaster + CommandRouter
├── database/
│   ├── migrations/                     # schema Laravel
│   ├── data/diskografi/*.json          # sumber data diskografi (parsed dari Excel)
│   └── seeders/                        # generasi, member, single, team,
│                                       # captain, admin user, map, diskografi
├── resources/views/
│   ├── layouts/       app.blade.php   admin.blade.php
│   ├── dashboard/     index members member singles captains
│   │                  statistik restrukturisasi calendar
│   ├── admin/         CRUD + docs + password
│   ├── auth/          login
│   ├── peta/          peta interaktif
│   └── sorter/        index / member / song
├── public/
│   ├── css/neo.css                     # global Neobrutalism overrides
│   ├── js/sorter-core.js               # merge sort core + render/undo/copy/screenshot
│   ├── js/sorter-member.js             # filter wiring member (status + generasi)
│   ├── js/sorter-song.js               # filter wiring song (rilis + asal grup + search)
│   ├── img/                            # foto member (257 file)
│   └── .htaccess                       # Laravel front-controller
├── routes/
│   ├── web.php                         # halaman + admin + webhooks
│   └── api.php                         # REST API v1 + Swagger
├── composer.json  composer.lock
├── schema.sql                          # raw SQL (setup manual)
├── DEPLOY.md                           # panduan deploy Hostinger
├── INSTALL.md                          # setup lokal
└── CHANGELOG.md

---

Setup Lokal

Lihat INSTALL.md.

Ringkas:

git clone https://github.com/Rebornian48/data.git jkt48_data
cd jkt48_data
composer install
cp .env.example .env
php artisan key:generate
# edit .env: DB_DATABASE, DB_USERNAME, DB_PASSWORD
php artisan migrate --seed
php artisan serve

---

Deploy

Lihat DEPLOY.md.

Ringkas:

1. Hostinger hPanel → Git → connect repo GitHub Rebornian48/data.
2. Branch main, deploy path public_html.
3. Set document root ke .../public_html/public (Laravel front-controller).
4. Setelah first deploy, SSH ke server:

   cd ~/domains/jkt48.rebornian48.my.id/public_html
   cp .env.example .env
   php artisan key:generate --force
   # edit .env: DB_*, APP_URL, APP_ENV=production, APP_DEBUG=false, bot vars
   mkdir -p storage/framework/{cache/data,sessions,views} storage/logs bootstrap/cache
   chmod -R 775 storage bootstrap/cache
   php artisan migrate --seed --force
   php artisan config:clear

5. Tambahkan cron 1 menit untuk scheduler (broadcast ulang tahun/kelulusan).
6. Enable Deploy otomatis — push berikutnya trigger sendiri.

---

Extensibility Sorter

Nambah sorter baru (contoh setlist):

1. SorterController.php — tambah 'setlist' ke SUPPORTED_TYPES, buat method dataSetlist() yang return array dgn key: sorterTitle, sorterSubtitle, items (schema {id, name, photo, ...}), plus data filter (mis. types).
2. Copy resources/views/sorter/song.blade.php → setlist.blade.php, sesuaikan filter panel + load sorter-setlist.js.
3. Buat public/js/sorter-setlist.js: wiring filter khusus setlist → SorterCore.start({items, filter: {compute, watch}, formatSubtitle?, formatBadge?}).
4. URL /sorter/setlist otomatis jalan lewat route dinamis existing.

Contoh implementasi: sorter-song.js + sorter/song.blade.php.

---

Kredensial Admin Default

username: admin
password: data_jkt48

Ganti setelah deploy pertama via Admin → Ganti Password (/admin/password).

---

Lisensi

Proyek internal — tidak untuk redistribusi tanpa izin.