Yes. Public Holidays should come before Payroll Approval because holidays affect attendance, overtime, leave balances, and salary calculations. Recommended folder: ```text holiday_management/ ├── holidays.php ├── holidays_script.php ├── holiday_calendar.php ├── holiday_calendar_script.php ``` --- # STEP 1 — Create Table ```sql CREATE TABLE public_holidays ( id INT AUTO_INCREMENT PRIMARY KEY, holiday_name VARCHAR(255) NOT NULL, holiday_date DATE NOT NULL, is_recurring TINYINT(1) DEFAULT 1, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); ``` --- # STEP 2 — Preload Nigeria Holidays ```sql INSERT INTO public_holidays (holiday_name,holiday_date,is_recurring) VALUES ('New Year Day','2026-01-01',1), ('Workers Day','2026-05-01',1), ('Democracy Day','2026-06-12',1), ('Independence Day','2026-10-01',1), ('Christmas Day','2026-12-25',1), ('Boxing Day','2026-12-26',1); ``` --- # STEP 3 — holidays_script.php ```php prepare(" INSERT INTO public_holidays ( holiday_name, holiday_date, is_recurring ) VALUES (?,?,?) "); $stmt->bind_param( "ssi", $name, $date, $recurring ); $stmt->execute(); header( "Location: holidays.php?saved=1" ); exit; } /* |-------------------------------------------------------------------------- | DELETE |-------------------------------------------------------------------------- */ if(isset($_GET['delete'])){ $id = intval($_GET['delete']); $conn->query(" DELETE FROM public_holidays WHERE id=$id "); header( "Location: holidays.php" ); exit; } /* |-------------------------------------------------------------------------- | LOAD |-------------------------------------------------------------------------- */ $holidays = []; $res = $conn->query(" SELECT * FROM public_holidays ORDER BY holiday_date "); while($row=$res->fetch_assoc()){ $holidays[]=$row; } ?> ``` --- # STEP 4 — holidays.php ```php Public Holidays

🎉 Public Holidays

Holiday Added Successfully

Add Holiday

Holiday Date Recurring Action
Delete
``` --- # STEP 5 — Holiday Calendar Create: ```text holiday_calendar.php holiday_calendar_script.php ``` --- # holiday_calendar_script.php ```php query(" SELECT * FROM public_holidays "); while($row=$res->fetch_assoc()){ $date = date( "$year-m-d", strtotime( $row['holiday_date'] ) ); $holidays[$date] = $row['holiday_name']; } ``` --- # holiday_calendar.php ```php Holiday Calendar

📅 Holiday Calendar

$name): ?>
``` --- # STEP 6 — Attendance Integration Inside your attendance logic: ```php $holidayCheck = $conn->query(" SELECT id FROM public_holidays WHERE holiday_date='$attendanceDate' "); $isHoliday = $holidayCheck->num_rows > 0; ``` --- If holiday: ```php $status = 'Holiday'; ``` instead of: ```php $status = 'Absent'; ``` --- # STEP 7 — Payroll Integration When calculating: ```php scheduledDays ``` exclude public holidays. Example: ```php $holidayCount = 0; $resHoliday = $conn->query(" SELECT COUNT(*) total FROM public_holidays WHERE holiday_date BETWEEN '$startDate' AND '$endDate' "); if($r=$resHoliday->fetch_assoc()){ $holidayCount = intval($r['total']); } $scheduledDays = $scheduledDays - $holidayCount; ``` This prevents salary deductions on official holidays. --- # Add to Sidebar ```php
  • 🎉 Public Holidays
  • 📅 Holiday Calendar
    • ``` After this module, the next one should be **Payroll Approval Workflow**: ```text Payroll Generated ↓ Manager Reviews ↓ HR Reviews ↓ Finance Reviews ↓ Superadmin Approves ↓ Payslips Released ``` That is typically the final control layer before staff can view or download payslips.