Result Slip Report
An Example of the layout of result slip
Result Slip Report
Version 1
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
<?php
use yii\helpers\Html;
use yii\widgets\ListView;
// Prepare data for grouping
$results = $dataProvider->getModels();
$groupedData = [];
foreach ($results as $row) {
$studentNumber = $row['student_number'];
if (!isset($groupedData[$studentNumber])) {
$groupedData[$studentNumber] = [
'surname' => $row['surname'],
'other_names' => $row['other_names'],
'courses' => []
];
}
$groupedData[$studentNumber]['courses'][] = [
'course_code' => $row['course_code'],
'course_name' => $row['course_name'],
'course_reg_type_name' => $row['course_reg_type_name'],
'final_mark' => $row['final_mark']
];
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Student Course Report</title>
<link rel="stylesheet" href="path/to/bootstrap.css">
<style>
.report-container {
margin: 20px;
}
.student-section {
border: 1px solid #ddd;
border-radius: 5px;
margin-bottom: 20px;
padding: 15px;
background-color: #f9f9f9;
}
.student-header {
font-size: 1.5em;
font-weight: bold;
margin-bottom: 10px;
}
.student-info {
margin-bottom: 15px;
}
.courses-table {
width: 100%;
border-collapse: collapse;
margin-bottom: 20px;
}
.courses-table th,
.courses-table td {
border: 1px solid #ddd;
padding: 8px;
}
.courses-table th {
background-color: #f4f4f4;
text-align: left;
}
.course-row:nth-child(even) {
background-color: #f9f9f9;
}
.report-footer {
font-size: 0.9em;
text-align: right;
margin-top: 20px;
}
</style>
</head>
<body>
<div class="report-container">
<h1>Student Course Report</h1>
<?php foreach ($groupedData as $studentNumber => $studentData): ?>
<div class="student-section">
<div class="student-header">
<?= Html::encode($studentData['surname']) . ', ' . Html::encode($studentData['other_names']) . ' (Student Number: ' . Html::encode($studentNumber) . ')' ?>
</div>
<div class="student-info">
<strong>Student Number:</strong> <?= Html::encode($studentNumber) ?><br>
<strong>Surname:</strong> <?= Html::encode($studentData['surname']) ?><br>
<strong>Other Names:</strong> <?= Html::encode($studentData['other_names']) ?>
</div>
<table class="courses-table">
<thead>
<tr>
<th>Course Code</th>
<th>Course Name</th>
<th>Registration Type</th>
<th>Final Mark</th>
</tr>
</thead>
<tbody>
<?php foreach ($studentData['courses'] as $course): ?>
<tr class="course-row">
<td><?= Html::encode($course['course_code']) ?></td>
<td><?= Html::encode($course['course_name']) ?></td>
<td><?= Html::encode($course['course_reg_type_name']) ?></td>
<td><?= Html::encode($course['final_mark']) ?></td>
</tr>
<?php endforeach; ?>
</tbody>
</table>
</div>
<?php endforeach; ?>
<div class="report-footer">
Report generated on <?= date('Y-m-d H:i:s') ?>
</div>
</div>
</body>
</html>
Version 2
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
<?php
use yii\helpers\Html;
// Group results by Programme, then by Level, then by Semester
$results = $dataProvider->getModels();
$groupedData = [];
foreach ($results as $row) {
$groupedData[$row['prog_curriculum_desc']][$row['academic_level_name']][$row['semster_name']][] = $row;
}
?>
<?php if (!empty($groupedData)): ?>
<table border="1" cellspacing="0" cellpadding="5">
<thead>
<tr>
<th>Course Code</th>
<th>Course Name</th>
<th>Final Mark</th>
</tr>
</thead>
<tbody>
<?php foreach ($groupedData as $programme => $levels): ?>
<!-- Programme Row -->
<tr>
<td colspan="3" style="background-color: #f0f0f0; font-weight: bold;">
Programme: <?= Html::encode($programme) ?>
</td>
</tr>
<?php foreach ($levels as $level => $semesters): ?>
<!-- Level Row -->
<tr>
<td colspan="3" style="background-color: #d0e0f0; padding-left: 20px; font-weight: bold;">
Level: <?= Html::encode($level) ?>
</td>
</tr>
<?php foreach ($semesters as $semester => $rows): ?>
<!-- Semester Row -->
<tr>
<td colspan="3" style="background-color: #e0f7d0; padding-left: 40px; font-weight: bold;">
Semester: <?= Html::encode($semester) ?>
</td>
</tr>
<?php foreach ($rows as $row): ?>
<!-- Data Row -->
<tr>
<td><?= Html::encode($row['course_code']) ?></td>
<td><?= Html::encode($row['course_name']) ?></td>
<td><?= Html::encode($row['final_mark']) ?></td>
</tr>
<?php endforeach; ?>
<?php endforeach; ?>
<?php endforeach; ?>
<?php endforeach; ?>
</tbody>
</table>
<?php else: ?>
<p>No results found.</p>
<?php endif; ?>
This post is licensed under CC BY 4.0 by the author.