BACK TO PROJECTS
CASE FILE #005STATUS: COMPLETED

Web Event SMKN 1 Wonosobo

Role: Full Stack DeveloperYear: 2026

I built Web Event SMKN 1 Wonosobo to help manage school events and competitions efficiently in one place. Built with PHP and MySQL, the platform supports multi-role accounts for Admins, Teachers/Juries, and Students. It features 3-stage milestone tracking (awal, proses, akhir) with automated late flags, FPDF progress report generation, and an embedded Google Gemini AI chatbot for participant inquiry support.

PHPMySQLGoogle Gemini APIAJAXFPDFJavaScript

Application Screenshots & Gallery

12 Images
Web Event SMKN 1 Wonosobo - Screenshot 1
View Full Screenshot
Web Event SMKN 1 Wonosobo - Screenshot 2
View Full Screenshot
Web Event SMKN 1 Wonosobo - Screenshot 3
View Full Screenshot

The Problem Context

School competition management was handled manually with paper forms, unmonitored deadline submissions, fragmented juror score calculations, and no centralized progress tracking.

The Engineering Solution

I developed a centralized web application featuring role-based dashboards, automated 3-stage milestone submission tracking, real-time jury scorecards with automated leaderboards, instant FPDF report generation, and an AI chatbot helper.

SYSTEM ARCHITECTURE TOPOLOGYInteractive Topology
STEP 01
Client Interface
HTML5 / ES6+ Fetch API / CSS3
FRONTEND LAYER
STEP 02
Multi-Role Server
Native PHP Controllers (Admin/Teacher/Student)
BACKEND LAYER
STEP 03
AI Chatbot Service
Google Gemini 1.5 Flash API
SERVICE LAYER
STEP 04
Relational DB
MySQL Data Store
DATABASE LAYER
STEP 05
Report Engine
FPDF Summaries & Scorecards
EXPORT LAYER
SELECTED NODE:Client Interface
Click any node to inspect

Implementation Highlights

01.

Designed a multi-role RBAC architecture for Admin, Teacher/Jury, and Student access.

02.

Built a 3-stage milestone submission engine (awal, proses, akhir) with automated deadline checks.

03.

Created multi-criteria jury scorecards with automated leaderboard aggregation.

04.

Integrated Google Gemini 1.5 Flash API for context-aware participant support.

05.

Implemented FPDF generation for on-the-fly PDF scorecards and certificates.

Measurable Results

  • Automated registration workflows, submission tracking, and score calculations.
  • Generated instant PDF summary reports for event coordinators.

Key Lessons Learned

  • Combining role permissions with automated milestone checks ensures clear accountability in event workflows.
  • Integrating AI assistance directly into operational tools reduces repetitive inquiry workload.