How jcgemina/library-classification-and-reporting-system works
This is a PHP library-management application for authenticated staff, covering inventory, academic organization and courses, user administration, reporting, and activity/security logs. Staff sign in, then the app shell loads role-appropriate pages; those pages perform domain operations against MySQL. Inventory also supports asynchronous AI course suggestions: a page queues work for a CLI worker, which processes it through the AI service. Source excerpts are incomplete and the README is empty, so the graph focuses on capabilities established by the file tree and shown relationships.
Main entry points: app.php App shell · db.php MySQL database · auth.php Authenticate · ai_course.php AI course suggestions
Components 20
Access and shell
- Sign in
login.php - Authenticate
auth.php - App shell
app.php - Role navigation
includes/nav.php
Library and academics
- Book inventory
pages/inventory.php - Academic organization
pages/organization.php - Course catalog
pages/course.php
Administration and insight
- User administration
pages/user.php - User service
includes/user_service.php - Dashboard
pages/dashboard.php - Reports
pages/report.php - Activity and security logs
pages/logs.php - Log export
pages/logs_export.php
AI suggestions
- AI course suggestions
pages/ai_course.php - AI job and ranking service
includes/ai_course_service.php - AI worker
bin/ai_worker.php
Shared foundation
- MySQL database
config/db.php - Shared functions
includes/functions.php
Other components
- Library staff
- AI provider
Connections 31
- Library staff → Sign in: opens
- Sign in → Authenticate: submits credentials
auth.php - Authenticate → MySQL database: checks credentials
auth.php - Authenticate → App shell: redirects after sign-in
auth.php - App shell → Shared functions: requires
app.php - App shell → Role navigation: renders
app.php - App shell → Book inventory: fetches page
app.php - App shell → Academic organization: fetches page
app.php - App shell → Course catalog: fetches page
app.php - App shell → AI course suggestions: fetches page
app.php - App shell → User administration: fetches page
app.php - App shell → Dashboard: fetches page
app.php - App shell → Reports: fetches page
app.php - App shell → Activity and security logs: fetches page
app.php - Book inventory → MySQL database: reads and writes
pages/inventory.php - Academic organization → MySQL database: manages records
pages/organization.php - Course catalog → MySQL database: reads and writes
pages/course.php - User administration → User service: uses
pages/user.php - User administration → MySQL database: manages users
pages/user.php - User service → MySQL database: queries users
includes/user_service.php - Activity and security logs → MySQL database: reads logs
pages/logs.php - Activity and security logs → Log export: offers export
- Book inventory → AI course suggestions: provides suggestions UI
pages/inventory.php - AI course suggestions → AI job and ranking service: requests suggestions
pages/ai_course.php - AI course suggestions → MySQL database: queues and reads jobs
pages/ai_course.php - AI worker → AI job and ranking service: claims and processes jobs
bin/ai_worker.php - AI worker → MySQL database: uses connection
bin/ai_worker.php - AI job and ranking service → MySQL database: stores job results
- AI job and ranking service → AI provider: requests embeddings and relevance
- Authenticate → Shared functions: uses security helpers
auth.php - App shell → MySQL database: loads connection
app.php