First add a release flag to payroll.
## SQL
Run:
```sql
ALTER TABLE payroll_details
ADD COLUMN payslip_released TINYINT(1) DEFAULT 0;
```
---
# payroll_release_script.php
```php
prepare("
UPDATE payroll_details
SET payslip_released = 1
WHERE id = ?
AND payroll_status='Disbursed'
");
$stmt->bind_param("i",$id);
$stmt->execute();
header("Location: payroll_release.php");
exit;
}
if(isset($_GET['unrelease'])){
$id = intval($_GET['unrelease']);
$stmt = $conn->prepare("
UPDATE payroll_details
SET payslip_released = 0
WHERE id = ?
");
$stmt->bind_param("i",$id);
$stmt->execute();
header("Location: payroll_release.php");
exit;
}
$res = $conn->query("
SELECT
p.*,
e.name,
d.name department
FROM payroll_details p
LEFT JOIN employees e
ON e.id=p.employee_id
LEFT JOIN departments d
ON d.id=e.department_id
WHERE p.payroll_status='Disbursed'
ORDER BY p.generated_at DESC
");
```
---
# payroll_release.php
```php
Payslip Release Control
Payslip Release Control
| Employee |
Department |
Net Salary |
Released |
Action |
fetch_assoc()): ?>
|
|
|
₦
|
Released
Hidden
|
Release
Hide
|
```
---
# UPDATE payslip.php
Find:
```php
if($payslip['payroll_status'] !== 'Paid'){
die("Payslip has not been released yet.");
}
```
Replace with:
```php
if(
$payslip['payroll_status'] !== 'Disbursed'
||
!$payslip['payslip_released']
){
die("Payslip has not been released yet.");
}
```
---
# UPDATE payslip_script.php
Ensure your query includes:
```sql
p.payslip_released
```
Example:
```php
SELECT
p.*,
e.name,
d.name department
```
Since `p.*` already contains all payroll fields, you likely don't need to add anything if you're already selecting `p.*`.
---
# UPDATE payslips.php
Add:
```php
AND p.payroll_status='Disbursed'
AND p.payslip_released=1
```
for staff users.
Example:
```php
if($role == 'staff'){
$sql .= "
AND p.payroll_status='Disbursed'
AND p.payslip_released=1
";
}
```
---
# SIDEBAR
Add:
```php
Payslip Release
```
Visible to:
```php
hr
accounts
admin
superadmin
```
---
After this module, the next file to build should be **payroll_dashboard.php**, which will give HR, Audit, GM, and Accounts a management dashboard showing:
* Total Payroll
* Total PAYE
* Total Pension
* Total Loans
* Total Salary Advances
* Total Overtime
* Total Employees Paid
* Pending Approvals
* Disbursed Payroll
all from your existing payroll tables.
The next module should be:
# payroll_dashboard.php
This becomes the landing page for:
* HR
* Audit
* GM
* Accounts
* Admin
and shows payroll KPIs.
---
## payroll_dashboard.php
```php
query("
SELECT
COUNT(*) employees,
SUM(gross_salary) gross_payroll,
SUM(net_salary) net_payroll,
SUM(tax_amount) total_tax,
SUM(pension_amount) total_pension,
SUM(loan_deduction) total_loans,
SUM(salary_advance_deduction) total_advances,
SUM(overtime_pay) total_overtime
FROM payroll_details
WHERE payroll_month=$month
AND payroll_year=$year
")->fetch_assoc();
$statusSummary = $conn->query("
SELECT
payroll_status,
COUNT(*) total
FROM payroll_details
WHERE payroll_month=$month
AND payroll_year=$year
GROUP BY payroll_status
");
?>
Payroll Dashboard
Payroll Dashboard
Payroll Status Summary
|
Status
|
Employees
|
fetch_assoc()): ?>
|
|
|
```
---
# Add Sidebar
```php
```
---
### Next module after Dashboard
The next one should be:
```text
payroll_export.php
```
which generates:
```csv
Employee Name
Department
Bank Name
Account Number
Net Salary
```
for upload into:
* Access Bank
* Zenith Bank
* First Bank
* UBA
* GTBank
and becomes the Accounts Department payroll transfer file.
That should be built before Finance Reports because it is used every payroll cycle.
Next is the **Bank Transfer Export Module**.
This allows Accounts to generate a CSV file containing all salaries to upload to the bank.
---
# 1. Verify Employees Table
First check:
```sql
DESCRIBE employees;
```
You should ideally have:
```sql
bank_name
account_number
account_name
```
If not, run:
```sql
ALTER TABLE employees
ADD COLUMN bank_name VARCHAR(100) NULL,
ADD COLUMN account_number VARCHAR(50) NULL,
ADD COLUMN account_name VARCHAR(200) NULL;
```
---
# 2. payroll_export.php
Create:
```php
query($sql);
while($row=$res->fetch_assoc()){
fputcsv($output,[
$row['name'],
$row['bank_name'],
$row['account_number'],
$row['account_name'],
$row['net_salary']
]);
}
fclose($output);
exit;
}
?>
Payroll Bank Export
```
---
# 3. Sidebar
Add:
```php
```
Visible to:
```php
accounts
admin
superadmin
```
---
# 4. Better Workflow
Current:
```text
HR
↓
Audit
↓
GM
↓
Accounts
↓
Disbursed
```
Recommended:
```text
HR Submit
↓
Audit Approve
↓
GM Approve
↓
Export Bank File
↓
Accounts Upload To Bank
↓
Disbursed
↓
Release Payslips
```
This prevents marking salaries as disbursed before the bank file is actually generated.
---
### Next Module
After this, build:
```text
finance_reports.php
```
This will show:
* Payroll Cost By Department
* Monthly Payroll Trend
* PAYE Liability
* Pension Liability
* Loan Recoveries
* Salary Advance Recoveries
* Overtime Cost
which is usually what the GM and Finance Manager want to see every month.