BookTracker Analytics

Member Loan Statistics ()

query("SELECT * FROM get_member_history()"); $results = $stmt->fetchAll(PDO::FETCH_ASSOC); if(count($results) > 0) { echo ''; echo ''; foreach($results as $row) { // Format the dates to show month $startDate = new DateTime($row['startdate']); $formattedDate = $startDate->format('F'); // Full month name echo ""; } echo '

Member	Status	Month	Total Loans	Current Loans	Total Fines	Fines Amount	Paid Amount
{$row['membername']}	{$row['membershipstatus']}	{$formattedDate}	{$row['totalloans']}	{$row['currentloans']}	{$row['totalfines']}	$".number_format($row['totalfineamount'], 2)."	$".number_format($row['totalpayments'], 2)."

'; } else { echo "

No member statistics available for " . date('Y') . ".

"; } } catch(PDOException $e) { echo "

Error loading member statistics: " . $e->getMessage() . "

"; } ?>

Book Loan Statistics

query("SELECT * FROM get_book_loan_stats()"); $results = $stmt->fetchAll(PDO::FETCH_ASSOC); if(count($results) > 0) { echo ''; echo ''; foreach($results as $row) { echo ""; } echo '

Title	Avg Days	Min Days	Max Days	Total Loans	Loans with Fines
{$row['title']}	".number_format($row['avgdaystoreturn'], 1)."	{$row['mindaystoreturn']}	{$row['maxdaystoreturn']}	{$row['totalloans']}	{$row['loanswithfines']}

'; } else { echo "

No book statistics found.

"; } } catch(PDOException $e) { echo "

Error loading book statistics: " . $e->getMessage() . "

"; } ?>

Genre Trends Analysis - Last 3 Quarters

query("SELECT * FROM get_genre_trends()"); $results = $stmt->fetchAll(PDO::FETCH_ASSOC); if(count($results) > 0) { echo ''; echo ''; foreach($results as $row) { $period = new DateTime($row['period']); $formattedPeriod = 'Q' . ceil($period->format('n')/3) . ' ' . $period->format('Y'); echo ""; } echo '

Genre	Quarter	Loans	Average
{$row['genre']}	{$formattedPeriod}	{$row['loancount']}	".number_format($row['movingaverage'], 2)."

'; } else { echo "

No genre trends data available for the last 3 quarters.

"; } } catch(PDOException $e) { echo "

Error loading genre trends: " . $e->getMessage() . "

"; } ?>