[amgad]

GatraJava

Best Project Award, COIL 2025

Cultural tourism platform for Javanese destinations: real-time booking, QR-code tickets, Stripe payments, admin dashboard and three roles (admin, attraction manager, user). Built during an Indonesia–Philippines COIL program.

ROLE
"Backend developer"
PERIOD
"Sep – Oct 2025"
CONTEXT
"COIL program, Indonesia and Philippines"
STACK
"Laravel 12, MySQL, RBAC, Gemini"
UPDATED
"Oct 2025"
github.com/amga-d/COIL

Overview

GatraJava promotes Javanese cultural destinations. Visitors browse attractions and blog articles, book cultural experiences and manage their trips. A cross-university team built it during an Indonesia–Philippines COIL program, and it was selected as Best Project among all teams.

I built the backend in Laravel 12: the database schema, access control for three roles, and the booking system.

What I built

  • MySQL schema for destinations, bookings, blogs, users and admin tables.
  • Role-based access for admins, attraction managers and users.
  • Booking system with real-time availability, reservation logic and booking history.
  • Parts of the admin dashboard: content management, booking moderation, user management and analytics.

How it fits together

    • Browser
  1. HTTP
    • Laravel 12PHP 8.3, RBAC
    • MySQLbookings, destinations
    • Stripepayments
    • Geminitravel assistant

In the repository

$ git clone https://github.com/amga-d/COIL.git

tree -L 1

.
├── app/
├── bootstrap/
├── config/
├── database/
├── Documentation/
├── public/
├── resources/
├── routes/
├── storage/
├── tests/
├── .editorconfig
├── .env.example
├── .gitattributes
├── .gitignore
└── … 14 more

git log --author=amga-d --oneline -5

  1. 12ca671Enhance event display styles and update admin sidebar comments; implement comprehensive database seeders for r
  2. f87ea56Merge branch 'main' of github.com:amga-d/COIL
  3. 8b5ae3dAdd analytics reports feature with detailed breakdown and charts
  4. 0d6c7bfImplement admin review management with index, approval, and flagging features
  5. bdca8e2Enhance admin dashboard with KPI statistics and recent activity updates
  • Laravel 70.3%
  • PHP 27.9%
  • JavaScript 0.9%
  • CSS 0.9%