source: Test.php@ 75f74d9

main
Last change on this file since 75f74d9 was 75f74d9, checked in by Vlado 222039 <vlado.popovski@…>, 6 weeks ago

Initial commit: Adding Book Tracker code
  • Property mode set to 100644
File size: 7.0 KB
Line 
1<?php require_once 'connect.php'; ?>
2<!DOCTYPE html>
3<html lang="en">
4<head>
5 <meta charset="UTF-8">
6 <meta name="viewport" content="width=device-width, initial-scale=1.0">
7 <title>Library Reports - BookTracker</title>
8 <style>
9 :root {
10 --bn-red: #2A4B7C;
11 --bn-beige: #F5F5F1;
12 --bn-dark: #1A1A1A;
13 }
14
15 body {
16 font-family: 'Arial', sans-serif;
17 margin: 0;
18 padding: 20px;
19 background-color: var(--bn-beige);
20 color: var(--bn-dark);
21 }
22
23 .header {
24 background-color: var(--bn-red);
25 color: white;
26 padding: 20px;
27 margin-bottom: 30px;
28 border-radius: 5px;
29 box-shadow: 0 2px 5px rgba(0,0,0,0.1);
30 }
31
32 .report-section {
33 background: white;
34 border-radius: 8px;
35 padding: 20px;
36 margin-bottom: 30px;
37 box-shadow: 0 2px 5px rgba(0,0,0,0.1);
38 }
39
40 h1, h2 {
41 margin: 0 0 15px 0;
42 }
43
44 table {
45 width: 100%;
46 border-collapse: collapse;
47 margin-top: 15px;
48 }
49
50 th, td {
51 padding: 12px;
52 text-align: left;
53 border-bottom: 1px solid #ddd;
54 }
55
56 th {
57 background-color: var(--bn-red);
58 color: white;
59 }
60
61 tr:hover {
62 background-color: #f9f9f9;
63 }
64
65 .stats-number {
66 font-weight: bold;
67 color: var(--bn-red);
68 }
69
70 .nav {
71 display: flex;
72 gap: 15px;
73 margin-bottom: 20px;
74 }
75
76 .nav a {
77 color: var(--bn-red);
78 text-decoration: none;
79 padding: 10px 15px;
80 border: 1px solid var(--bn-red);
81 border-radius: 5px;
82 }
83
84 .nav a:hover {
85 background-color: var(--bn-red);
86 color: white;
87 }
88 </style>
89</head>
90<body>
91 <div class="header">
92 <h1>BookTracker Analytics</h1>
93 <div class="nav">
94 <a href="#member-stats">Member Statistics</a>
95 <a href="#book-stats">Book Statistics</a>
96 </div>
97 </div>
98
99<!-- Member Statistics Section -->
100<div class="report-section" id="member-stats">
101 <h2>Member Loan Statistics (<?php echo date('Y'); ?>)</h2>
102 <?php
103 try {
104 $stmt = $conn->query("SELECT * FROM get_member_history()");
105 $results = $stmt->fetchAll(PDO::FETCH_ASSOC);
106
107 if(count($results) > 0) {
108 echo '<table>';
109 echo '<tr>
110 <th>Member</th>
111 <th>Status</th>
112 <th>Month</th>
113 <th>Total Loans</th>
114 <th>Current Loans</th>
115 <th>Total Fines</th>
116 <th>Fines Amount</th>
117 <th>Paid Amount</th>
118 </tr>';
119
120 foreach($results as $row) {
121 // Format the dates to show month
122 $startDate = new DateTime($row['startdate']);
123 $formattedDate = $startDate->format('F'); // Full month name
124
125 echo "<tr>
126 <td>{$row['membername']}</td>
127 <td>{$row['membershipstatus']}</td>
128 <td>{$formattedDate}</td>
129 <td class='stats-number'>{$row['totalloans']}</td>
130 <td class='stats-number'>{$row['currentloans']}</td>
131 <td class='stats-number'>{$row['totalfines']}</td>
132 <td class='stats-number'>$".number_format($row['totalfineamount'], 2)."</td>
133 <td class='stats-number'>$".number_format($row['totalpayments'], 2)."</td>
134 </tr>";
135 }
136 echo '</table>';
137 } else {
138 echo "<p>No member statistics available for " . date('Y') . ".</p>";
139 }
140 } catch(PDOException $e) {
141 echo "<p>Error loading member statistics: " . $e->getMessage() . "</p>";
142 }
143 ?>
144</div>
145
146 <!-- Book Statistics Section -->
147 <div class="report-section" id="book-stats">
148 <h2>Book Loan Statistics</h2>
149 <?php
150 try {
151 $stmt = $conn->query("SELECT * FROM get_book_loan_stats()");
152 $results = $stmt->fetchAll(PDO::FETCH_ASSOC);
153
154 if(count($results) > 0) {
155 echo '<table>';
156 echo '<tr>
157 <th>Title</th>
158 <th>Avg Days</th>
159 <th>Min Days</th>
160 <th>Max Days</th>
161 <th>Total Loans</th>
162 <th>Loans with Fines</th>
163 </tr>';
164
165 foreach($results as $row) {
166 echo "<tr>
167 <td>{$row['title']}</td>
168 <td class='stats-number'>".number_format($row['avgdaystoreturn'], 1)."</td>
169 <td class='stats-number'>{$row['mindaystoreturn']}</td>
170 <td class='stats-number'>{$row['maxdaystoreturn']}</td>
171 <td class='stats-number'>{$row['totalloans']}</td>
172 <td class='stats-number'>{$row['loanswithfines']}</td>
173 </tr>";
174 }
175 echo '</table>';
176 } else {
177 echo "<p>No book statistics found.</p>";
178 }
179 } catch(PDOException $e) {
180 echo "<p>Error loading book statistics: " . $e->getMessage() . "</p>";
181 }
182 ?>
183 </div>
184
185<!-- Genre Trends Section -->
186<div class="report-section" id="genre-trends">
187 <h2>Genre Trends Analysis - Last 3 Quarters</h2>
188 <?php
189 try {
190 $stmt = $conn->query("SELECT * FROM get_genre_trends()");
191 $results = $stmt->fetchAll(PDO::FETCH_ASSOC);
192
193 if(count($results) > 0) {
194 echo '<table>';
195 echo '<tr>
196 <th>Genre</th>
197 <th>Quarter</th>
198 <th>Loans</th>
199 <th>Average</th>
200 </tr>';
201
202 foreach($results as $row) {
203 $period = new DateTime($row['period']);
204 $formattedPeriod = 'Q' . ceil($period->format('n')/3) . ' ' . $period->format('Y');
205
206 echo "<tr>
207 <td>{$row['genre']}</td>
208 <td>{$formattedPeriod}</td>
209 <td class='stats-number'>{$row['loancount']}</td>
210 <td class='stats-number'>".number_format($row['movingaverage'], 2)."</td>
211 </tr>";
212 }
213 echo '</table>';
214 } else {
215 echo "<p>No genre trends data available for the last 3 quarters.</p>";
216 }
217 } catch(PDOException $e) {
218 echo "<p>Error loading genre trends: " . $e->getMessage() . "</p>";
219 }
220 ?>
221</div>
222
223
224
225</body>
226</html>
Note: See TracBrowser for help on using the repository browser.