# LOA Tracker — Technical Design Document **Project:** Leave of Absence (LOA) Tracking Tool **Author:** Eric Dunn **Date:** 2026-02-24 **Status:** In Development **Last Updated:** 2026-02-24 --- ## Part 1: Onboarding Tracker Analysis ### File Structure ``` app/HR/Onboarding/ ├── onboarding.php — main page (dashboard + inline edit) ├── onboarding_filter.php — filter logic (require'd into onboarding.php) ├── sync_onboarding.php — AJAX endpoint (UPDATE + soft delete) └── temp/ — working drafts, ignore ``` ### Authentication Pattern - Bootstrap: `require __DIR__ . '/../../bootstrap_env.php'` - Auth gate: `requireLogin()` — redirects to `login.php?returnUrl=...` if not logged in - Session timeout: 10 hours, checked manually; redirects to `login.php?timeout=1` - Permissions: query `V_employee_permissions` WHERE `form_name = 'Onboarding'` AND `id = $emp_id` - Label `'Edit'` → full edit (`$canEdit = true`) - Anything else → `'ReadOnly'` (`$canEdit = false`) - Session vars injected into JS at top of ``: ```js const SESSION_USER = ..., SESSION_NAME = ..., SESSION_ID = ..., CAN_EDIT = ...; ``` ### DB Connection Pattern Two styles in use (mixed — PDO for permissions, MySQLi for main queries): ```php // Permissions (PDO) $pdo = new \PDO("mysql:host=$servername;port=$port;dbname=$dbname;charset=utf8mb4", ...); // Main queries (MySQLi) $conn = new mysqli($servername, $username, $password, $dbname); $conn->set_charset('utf8mb4'); ``` Credentials via: `envv('new_servername')`, `envv('new_username')`, `envv('new_password')`, `envv('new_dbname')`, `envv('DB_PORT')` **LOA tool should use MySQLi consistently** (PDO only needed for permission check). ### CSS / JS Libraries | Asset | Source | |---|---| | `josh_style.css` | Local `../assets/css/` + CDN fallback from portal | | `ewd_style.css` | Local `../assets/css/` | | `message-multi.css` | Local + portal fallback | | jQuery 3.7.1 | cdnjs | | xlsx.full.min.js | cdnjs (for export) | No Bootstrap. Custom CSS only. Inline `