- Combine recommendation form with history on single page
- Combine chatbot interface with chat history on single page
- Fix chatbot SQL error (DISTINCT + ORDER BY incompatibility)
- Fix chatbot not showing old recommendations incorrectly
- Remove history cards from dashboard (moved to respective pages)
- Remove delete account from student profile (admin-only now)
- All 49 PHPUnit tests passing
IMPROVEMENTS:
- Redesigned student profile pages (Admin & BK) with horizontal gradient headers
- Avatar + profile info grid layout for better visual hierarchy
- Sticky chat sidebar with 2/3-1/3 column split for main content
- Updated profile edit page with modern gradient header and compact form
- Redesigned history rekomendasi with expandable details and data summary
- Added 4 interactive Chart.js visualizations to dashboards (Doughnut, Bar, Pie)
- Improved sidebar typography (Admin Panel, Administrator now white)
ALUMNI IMPORT:
- Created TEMPLATE_ALUMNI_MINIMAL.csv (15 essential columns)
- Created TEMPLATE_ALUMNI_IMPORT.csv (full 25-column template with examples)
- Added comprehensive import guide (TEMPLATE_IMPORT_ALUMNI_BIMA_AMBULU.md)
DATABASE:
- Migration for Indonesian table naming (recommendations → rekomendasi, etc.)
- Updated all models with table mappings and backward-compatible accessors
- Fixed JSON casting for hasil_rekomendasi field (Recommendation model)
DATA QUALITY:
- Updated Naive Bayes weights for all 9 majors with accurate bobot_mapel
- Expanded keywords to 15-26 universal values per major
- Implemented 5 universal preferensi_studi values per major
- Added StudentWithAccurateRecommendationSeeder (14 sample students)
- Added RegenerateRecommendationsSeeder with JSON encoding fix
PYTHON BACKEND:
- Fixed Python 3.13 compatibility (pip upgrade: certifi, requests)
- Flask app now runs successfully on Python 3.13
DASHBOARD:
- Admin & BK dashboards with real-time chart data
- Cleaned major name formatting in JSON_EXTRACT queries
- Fixed 32 malformed recommendations data quality issue
Controllers: AdminController, BKController updated with chart data
Views: 6+ views redesigned with modern gradients and responsive layouts
Models: 5+ models updated with Indonesian table mappings
Tests: 45 tests passing, crud validation suite maintained
- Create BKController with dashboard, students, chat history, recommendations, and jurusan management
- Add 8 BK panel views: students list/detail, chat history, riwayat rekomendasi/chatbot, jurusan CRUD, profil
- Add 15 BK routes with auth and isBK middleware protection
- Update AdminSeeder with 8+ char passwords and valid email format
- Add database migrations for chat history improvements
- Update various controllers and models for BK panel integration
- Remove sidebar Profil duplication, keep navbar dropdown only
KakaPatria