annotate print.php @ 1096:bbc0a3d0b51e

Major renaming / refactor of site messages. Some that were previously modifiable from admin interface are now "hardcoded" in the configuration file. Having these settings made modifiable from there made no sense and just took space in the UI.
author Matti Hamalainen <ccr@tnsp.org>
date Fri, 27 Jan 2017 22:15:06 +0200
parents 48e16e856646
children ebb0afda63c5
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
1074
48e16e856646 Use long tags.
Matti Hamalainen <ccr@tnsp.org>
parents: 1072
diff changeset
1 <?php
91
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
2 //
571
ce11ea112a65 Change the header blurb a bit.
Matti Hamalainen <ccr@tnsp.org>
parents: 565
diff changeset
3 // FAPWeb - Simple Web-based Demoparty Management System
136
aeebfedb5709 Add some copyright headers.
Matti Hamalainen <ccr@tnsp.org>
parents: 122
diff changeset
4 // Data printout / hardcopy output module
1072
7da8bde9b7be Bump copyrights.
Matti Hamalainen <ccr@tnsp.org>
parents: 1020
diff changeset
5 // (C) Copyright 2012-2017 Tecnic Software productions (TNSP)
91
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
6 //
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
7 $sessionType = "admin";
175
8df523e6326a User require_once instead of require.
Matti Hamalainen <ccr@tnsp.org>
parents: 174
diff changeset
8 require_once "mconfig.inc.php";
8df523e6326a User require_once instead of require.
Matti Hamalainen <ccr@tnsp.org>
parents: 174
diff changeset
9 require_once "msite.inc.php";
8df523e6326a User require_once instead of require.
Matti Hamalainen <ccr@tnsp.org>
parents: 174
diff changeset
10 require_once "msession.inc.php";
91
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
11
591
f7078755dff5 Fix CSS paths for admin and print pages.
Matti Hamalainen <ccr@tnsp.org>
parents: 571
diff changeset
12 $pageCSS = "css/hardcopy.css";
561
6b4cbd590d35 More locale initialization refactoring.
Matti Hamalainen <ccr@tnsp.org>
parents: 512
diff changeset
13
95
d9de08fb5b28 Work on hardcopy/votekey list printing.
Matti Hamalainen <ccr@tnsp.org>
parents: 91
diff changeset
14
147
91af5b225fd6 Cleanups.
Matti Hamalainen <ccr@tnsp.org>
parents: 136
diff changeset
15 //
91
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
16 // Check if we are allowed to execute
147
91af5b225fd6 Cleanups.
Matti Hamalainen <ccr@tnsp.org>
parents: 136
diff changeset
17 //
95
d9de08fb5b28 Work on hardcopy/votekey list printing.
Matti Hamalainen <ccr@tnsp.org>
parents: 91
diff changeset
18 if (!stCheckHTTPS() || !stAdmSessionAuth(TRUE))
91
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
19 {
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
20 stSetupCacheControl();
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
21 stSessionEnd(SESS_ADMIN);
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
22 stSetStatus(404, "Not Found");
122
7d9e8c82e744 Work on votekey printing.
Matti Hamalainen <ccr@tnsp.org>
parents: 95
diff changeset
23
7d9e8c82e744 Work on votekey printing.
Matti Hamalainen <ccr@tnsp.org>
parents: 95
diff changeset
24 cmPrintPageHeader("Error");
720
4f334b3c884f Cleanups.
Matti Hamalainen <ccr@tnsp.org>
parents: 653
diff changeset
25 echo
4f334b3c884f Cleanups.
Matti Hamalainen <ccr@tnsp.org>
parents: 653
diff changeset
26 "<h1>Permission denied</h1>\n".
4f334b3c884f Cleanups.
Matti Hamalainen <ccr@tnsp.org>
parents: 653
diff changeset
27 "<p>You need to be logged in as administrator to access this data.</p>\n".
4f334b3c884f Cleanups.
Matti Hamalainen <ccr@tnsp.org>
parents: 653
diff changeset
28 "<p><a href=\"admin.php\">Click here for login form</a></p>\n";
122
7d9e8c82e744 Work on votekey printing.
Matti Hamalainen <ccr@tnsp.org>
parents: 95
diff changeset
29 cmPrintPageFooter();
91
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
30 exit;
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
31 }
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
32
147
91af5b225fd6 Cleanups.
Matti Hamalainen <ccr@tnsp.org>
parents: 136
diff changeset
33
91af5b225fd6 Cleanups.
Matti Hamalainen <ccr@tnsp.org>
parents: 136
diff changeset
34 //
91af5b225fd6 Cleanups.
Matti Hamalainen <ccr@tnsp.org>
parents: 136
diff changeset
35 // Initialize
91af5b225fd6 Cleanups.
Matti Hamalainen <ccr@tnsp.org>
parents: 136
diff changeset
36 //
91
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
37 stSetupCacheControl();
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
38
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
39 if (!stConnectSQLDB())
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
40 die("Could not connect to SQL database.");
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
41
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
42 stReloadSettings();
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
43
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
44
147
91af5b225fd6 Cleanups.
Matti Hamalainen <ccr@tnsp.org>
parents: 136
diff changeset
45 //
91af5b225fd6 Cleanups.
Matti Hamalainen <ccr@tnsp.org>
parents: 136
diff changeset
46 // Handle request
91af5b225fd6 Cleanups.
Matti Hamalainen <ccr@tnsp.org>
parents: 136
diff changeset
47 //
380
0c7b301742bd Oops^2.
Matti Hamalainen <ccr@tnsp.org>
parents: 379
diff changeset
48 switch (stGetRequestItem("type", "", TRUE))
91
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
49 {
512
998a09b332f1 Add plain text printable results visible for admins.
Matti Hamalainen <ccr@tnsp.org>
parents: 380
diff changeset
50 case "results":
998a09b332f1 Add plain text printable results visible for admins.
Matti Hamalainen <ccr@tnsp.org>
parents: 380
diff changeset
51 header("Content-Type: text/plain");
792
b42b23073209 Improve printing of results with more options (in the admin interface).
Matti Hamalainen <ccr@tnsp.org>
parents: 733
diff changeset
52 echo stGetCompoResultsASCIIStr(FALSE, intval(stGetRequestItem("flags", RFLAG_NORMAL)));
512
998a09b332f1 Add plain text printable results visible for admins.
Matti Hamalainen <ccr@tnsp.org>
parents: 380
diff changeset
53 break;
998a09b332f1 Add plain text printable results visible for admins.
Matti Hamalainen <ccr@tnsp.org>
parents: 380
diff changeset
54
272
cd3283333ec1 Add link for printing out email addresses of participants.
Matti Hamalainen <ccr@tnsp.org>
parents: 175
diff changeset
55 case "emails":
91
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
56 //
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
57 // Generic e-mail data dump
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
58 //
653
5ed91fb08165 Possibly fix an SQL syntax incompability SQLite vs. Postgres.
Matti Hamalainen <ccr@tnsp.org>
parents: 591
diff changeset
59 $sql = "SELECT * FROM attendees WHERE email IS NOT NULL AND email != '' ORDER BY regtime DESC";
95
d9de08fb5b28 Work on hardcopy/votekey list printing.
Matti Hamalainen <ccr@tnsp.org>
parents: 91
diff changeset
60 if (($res = stExecSQL($sql)) !== FALSE)
91
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
61 {
95
d9de08fb5b28 Work on hardcopy/votekey list printing.
Matti Hamalainen <ccr@tnsp.org>
parents: 91
diff changeset
62 cmPrintPageHeader("E-mails");
91
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
63 $out1 = array();
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
64 $out2 = array();
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
65
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
66 foreach ($res as $item)
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
67 {
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
68 $out1[] = $item["name"]." &lt;".$item["email"]."&gt;";
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
69 $out2[] = $item["email"];
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
70 }
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
71
95
d9de08fb5b28 Work on hardcopy/votekey list printing.
Matti Hamalainen <ccr@tnsp.org>
parents: 91
diff changeset
72 echo
d9de08fb5b28 Work on hardcopy/votekey list printing.
Matti Hamalainen <ccr@tnsp.org>
parents: 91
diff changeset
73 implode(", ", $out1)."<br /><hr /><br />\n".
d9de08fb5b28 Work on hardcopy/votekey list printing.
Matti Hamalainen <ccr@tnsp.org>
parents: 91
diff changeset
74 implode("<br />", $out1)."<br /><hr /><br />\n".
d9de08fb5b28 Work on hardcopy/votekey list printing.
Matti Hamalainen <ccr@tnsp.org>
parents: 91
diff changeset
75 implode(", ", $out2)."<br /><hr /><br />\n".
d9de08fb5b28 Work on hardcopy/votekey list printing.
Matti Hamalainen <ccr@tnsp.org>
parents: 91
diff changeset
76 implode("<br />", $out2)."<br /><hr />\n";
d9de08fb5b28 Work on hardcopy/votekey list printing.
Matti Hamalainen <ccr@tnsp.org>
parents: 91
diff changeset
77
d9de08fb5b28 Work on hardcopy/votekey list printing.
Matti Hamalainen <ccr@tnsp.org>
parents: 91
diff changeset
78 cmPrintPageFooter();
91
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
79 }
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
80 break;
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
81
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
82 case "votekeys":
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
83 //
95
d9de08fb5b28 Work on hardcopy/votekey list printing.
Matti Hamalainen <ccr@tnsp.org>
parents: 91
diff changeset
84 // Print out votekeys as a table
91
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
85 //
95
d9de08fb5b28 Work on hardcopy/votekey list printing.
Matti Hamalainen <ccr@tnsp.org>
parents: 91
diff changeset
86 $sql = "SELECT * FROM votekeys ORDER BY id ASC";
d9de08fb5b28 Work on hardcopy/votekey list printing.
Matti Hamalainen <ccr@tnsp.org>
parents: 91
diff changeset
87 if (($res = stExecSQL($sql)) !== FALSE)
91
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
88 {
95
d9de08fb5b28 Work on hardcopy/votekey list printing.
Matti Hamalainen <ccr@tnsp.org>
parents: 91
diff changeset
89 cmPrintPageHeader("Votekeys");
122
7d9e8c82e744 Work on votekey printing.
Matti Hamalainen <ccr@tnsp.org>
parents: 95
diff changeset
90 $keyLen = stGetSetting("userKeyLength");
1020
2a259e243350 Don't use a HTML table for the votekeys.
Matti Hamalainen <ccr@tnsp.org>
parents: 1001
diff changeset
91 echo "<div class=\"votekeys\">\n";
95
d9de08fb5b28 Work on hardcopy/votekey list printing.
Matti Hamalainen <ccr@tnsp.org>
parents: 91
diff changeset
92 foreach ($res as $item)
d9de08fb5b28 Work on hardcopy/votekey list printing.
Matti Hamalainen <ccr@tnsp.org>
parents: 91
diff changeset
93 {
122
7d9e8c82e744 Work on votekey printing.
Matti Hamalainen <ccr@tnsp.org>
parents: 95
diff changeset
94 // This funny code is to ensure that the cells are of uniform width
1020
2a259e243350 Don't use a HTML table for the votekeys.
Matti Hamalainen <ccr@tnsp.org>
parents: 1001
diff changeset
95 printf("<div class=\"votekey\"><span class=\"keyid\">%03d</span>&nbsp;:&nbsp;".
2a259e243350 Don't use a HTML table for the votekeys.
Matti Hamalainen <ccr@tnsp.org>
parents: 1001
diff changeset
96 "<span class=\"keycode\">%s</span></div>\n",
122
7d9e8c82e744 Work on votekey printing.
Matti Hamalainen <ccr@tnsp.org>
parents: 95
diff changeset
97 $item["id"],
7d9e8c82e744 Work on votekey printing.
Matti Hamalainen <ccr@tnsp.org>
parents: 95
diff changeset
98 str_repeat("&nbsp;", $keyLen - strlen($item["key"])).$item["key"]);
95
d9de08fb5b28 Work on hardcopy/votekey list printing.
Matti Hamalainen <ccr@tnsp.org>
parents: 91
diff changeset
99 }
d9de08fb5b28 Work on hardcopy/votekey list printing.
Matti Hamalainen <ccr@tnsp.org>
parents: 91
diff changeset
100
1020
2a259e243350 Don't use a HTML table for the votekeys.
Matti Hamalainen <ccr@tnsp.org>
parents: 1001
diff changeset
101 echo "</div>\n";
95
d9de08fb5b28 Work on hardcopy/votekey list printing.
Matti Hamalainen <ccr@tnsp.org>
parents: 91
diff changeset
102 cmPrintPageFooter();
91
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
103 }
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
104 break;
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
105
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
106 default:
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
107 stSetStatus(404, "Not Found");
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
108 break;
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
109 }
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
110
b58a36f4821e Initial addition of hardcopy / print helper module.
Matti Hamalainen <ccr@tnsp.org>
parents:
diff changeset
111 ?>