Differential D23639 Diff 66512 community/donations/graph.php

Changeset View

Standalone View

community/donations/graph.php

1	<?php	1		<?php
2		2
3	require("donations_auth.inc");	3		require("config.php");
4		4
5	$year = (int)mysql_real_escape_string( $_GET["year"] );	5		$year = (int)$_GET["year"];
6	if ($year < 2001 \|\| $year > 2020) {	6		if ($year < 2001 \|\| $year > 2020) {
			bcooksleyUnsubmitted Done Given we're in 2019 maybe we should increase the limit to something like 2030? bcooksley: Given we're in 2019 maybe we should increase the limit to something like 2030?
7	echo "year check failed";	7		echo "year check failed";
8	exit(1);	8		exit(1);
9	}	9		}
10		10
11	// initialise	11		// initialise
12	for ($i = 1; $i <= 12; $i++) {	12		for ($i = 1; $i <= 12; $i++) {
13	$i < 10 ? $i_s = "0".$i : $i_s = $i;	13		$i < 10 ? $i_s = "0".$i : $i_s = $i;
14	$data[ $year."-".$i_s ] = 0;	14		$data[ $year."-".$i_s ] = 0;
15	}	15		}
		16		// $dbConnection->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );//Error Handling
16		17
17	$query = "select sum(amount) as don, DATE_FORMAT(date,\"%Y-%m\") as month from donations ";	18		$stmt = $dbConnection->prepare("SELECT SUM(amount) as don, DATE_FORMAT(date,\"%Y-%m\") as month from donations WHERE YEAR(date) = :year GROUP BY month ORDER BY month DESC");
18	$query .= "where year(date) = '".$year."' ";
19	$query .= "group by month order by month desc";
20	$q = mysql_query($query,$sq);
21	while ($row = mysql_fetch_array($q)) {
22	$data[ $row["month"] ] = $row["don"];
23	}
24
25	$keys = array_keys($data);
26	$values = array_values($data);
27
28	// below is taken from http://code.web-max.ca/image_graph.php
29	// and adapted a bit.
30
31	// Get the total number of columns we are going to plot
32
33	$columns = count($values);
34
35	// Get the height and width of the final image
36
37	$width = 400;
38	$height = 200;
39
40	// Set the amount of space between each column
41
42	$padding = 5;
43
44	// Get the width of 1 column
45
46	$column_width = $width / $columns ;
47
48	// Generate the image variables
49
50	$im = imagecreate($width,$height);
51	$gray = imagecolorallocate ($im,0xcc,0xcc,0xcc);
52	$gray_lite = imagecolorallocate ($im,0xee,0xee,0xee);
53	$gray_dark = imagecolorallocate ($im,0x7f,0x7f,0x7f);
54	$white = imagecolorallocate ($im,0xff,0xff,0xff);
55
56	$blue_lite = imagecolorallocate($im, 0xE7, 0xF8, 0xFF);
57	$blue_dark = imagecolorallocate($im, 0x4A, 0x81, 0xCA);
58	$black = imagecolorallocate($im, 0x00, 0x00, 0x00);
59
60	// Fill in the background of the image
61
62	imagefilledrectangle($im,0,0,$width,$height,$white);
63		19
64	$maxv = 0;	20		$stmt->execute([
65		21		'year' => $year,
66	// Calculate the maximum value we are going to plot	22		]);
67
68	for($i=0;$i<$columns;$i++)$maxv = max($values[$i],$maxv);
69
70	// Now plot each column
71
72	$font_file = '/usr/share/fonts/truetype/ttf-dejavu/DejaVuSans.ttf';
73	for($i=0;$i<$columns;$i++)
74	{
75	$column_height = ($height / 100) * (( $values[$i] / $maxv) *100);
76
77	$x1 = $i*$column_width;
78	$y1 = $height-$column_height;
79	$x2 = (($i+1)*$column_width)-$padding;
80	$y2 = $height;
81
82	imagefilledrectangle($im,$x1,$y1,$x2,$y2,$blue_dark);
83
84	// This part is just for 3D effect
85
86	imageline($im,$x1,$y1,$x1,$y2,$gray_lite);
87	imageline($im,$x1,$y2,$x2,$y2,$gray_lite);
88	imageline($im,$x2,$y1,$x2,$y2,$gray_dark);
89
90	imagefttext( $im, 9, 0, $x1+8, $y2-5 , $black, $font_file, $i+1);
91		23
		24		while ($row = $stmt->fetch()) {
		25		$data[ $row["month"] ] = $row["don"];
92	}	26		}
93
94	// Send the PNG header information. Replace for JPEG or GIF or whatever
95
96	header ("Content-type: image/png");
97	imagepng($im);
98	?>	27		?>
		28
		29		<!DOCTYPE html>
		30		<html>
		31		<head>
		32		<meta charset="UTF-8">
		33		<link href="https://cdn.kde.org/aether-devel/bootstrap.css" rel="stylesheet">
		34		</head>
		35		<body>
		36		<div class="container">
		37		<canvas id="myChart" width="400" height="200"></canvas>
		38		<script src="https://cdn.jsdelivr.net/npm/chart.js@2.8.0/dist/Chart.min.js"></script>
		39		<script>
		40		let ctx = document.getElementById('myChart');
		41		new Chart(ctx, {
		42		type: 'bar',
		43		data: {
		44		labels: ['January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December'],
		45		datasets: [{
		46		label: "Donation for the year <?= $year ?>",
		47		data: [<?php foreach ($data as $month) { echo($month . ","); } ?>],
		48		fill: false,
		49		}],
		50		},
		51		options: {
		52		scales: {
		53		yAxes: [{
		54		ticks: {
		55		beginAtZero: true
		56		}
		57		}]
		58		}
		59		}
		60		});
		61		</script>
		62		</div>
		63		</body>
		64		</html>