forked from science-ation/science-ation
171 lines
6.8 KiB
PHP
171 lines
6.8 KiB
PHP
<?
|
|
/*
|
|
This file is part of the 'Science Fair In A Box' project
|
|
SFIAB Website: http://www.sfiab.ca
|
|
|
|
Copyright (C) 2005 Sci-Tech Ontario Inc <info@scitechontario.org>
|
|
Copyright (C) 2005 James Grant <james@lightbox.org>
|
|
|
|
This program is free software; you can redistribute it and/or
|
|
modify it under the terms of the GNU General Public
|
|
License as published by the Free Software Foundation, version 2.
|
|
|
|
This program is distributed in the hope that it will be useful,
|
|
but WITHOUT ANY WARRANTY; without even the implied warranty of
|
|
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
|
|
General Public License for more details.
|
|
|
|
You should have received a copy of the GNU General Public License
|
|
along with this program; see the file COPYING. If not, write to
|
|
the Free Software Foundation, Inc., 59 Temple Place - Suite 330,
|
|
Boston, MA 02111-1307, USA.
|
|
*/
|
|
?>
|
|
<?
|
|
require("../common.inc.php");
|
|
require_once("../user.inc.php");
|
|
require_once('reports.inc.php');
|
|
user_auth_required('admin');
|
|
send_header("Reports",
|
|
array('Committee Main' => 'committee_main.php',
|
|
'Administration' => 'admin/index.php')
|
|
);
|
|
echo "<br />";
|
|
echo error('This page will no longer be available after Summer 2008. Please use the new \'My Reports\' interface. ');
|
|
|
|
$id = intval($_POST['id']);
|
|
echo "<h4>".i18n("All Reports")."</h4>";
|
|
echo "<form method=\"get\" name=\"reportgen\" action=\"reports_gen.php\">";
|
|
echo "<select name=\"id\" id=\"report\">";
|
|
echo "<option value=\"0\">".i18n("Select a Report")."</option>\n";
|
|
$reports = report_load_all();
|
|
$x=0;
|
|
foreach($reports as $r) {
|
|
$sel = ($id == $r['id']) ? 'selected=\"selected\"' : '';
|
|
echo "<option value=\"{$r['id']}\" $sel>{$r['name']}</option>\n";
|
|
}
|
|
echo "</select>";
|
|
echo "<select name=\"type\"><option value=\"\">Default Format</option>";
|
|
echo "<option value=\"pdf\">PDF</option>";
|
|
echo "<option value=\"csv\">CSV</option>";
|
|
echo "<option value=\"label\">Label</option>";
|
|
echo "</select>";
|
|
echo "<input type=\"text\" value=\"{$config['FAIRYEAR']}\" size=\"5\" name=\"year\" />";
|
|
echo "<input type=\"submit\" value=\"Generate Report\"></form>";
|
|
echo "<br />";
|
|
echo "<hr />";
|
|
|
|
|
|
echo "<h4>".i18n("Custom Reports")."</h4>";
|
|
|
|
/*
|
|
echo i18n("Day of Fair Registration/Checkin Forms (All Categories)").": ";
|
|
echo "<a href=\"reports_gen.php?id=9&type=pdf\">PDF</a> ";
|
|
echo "<a href=\"reports_gen.php?id=9&type=csv\">CSV</a> ";
|
|
*/
|
|
|
|
//lets split this up by age category,
|
|
/*
|
|
$catq=mysql_query("SELECT * FROM projectcategories WHERE year='".$config['FAIRYEAR']."' ORDER BY id");
|
|
while($catr=mysql_fetch_object($catq))
|
|
{
|
|
echo "<td>";
|
|
echo "<a href=\"reports_checkin.php?type=pdf&cat=$catr->id\">$catr->category (PDF)</a> ";
|
|
echo "<br>";
|
|
echo "<a href=\"reports_checkin.php?type=csv&cat=$catr->id\">$catr->category (CSV)</a> ";
|
|
echo "</td>";
|
|
}
|
|
*/
|
|
echo "<br />";
|
|
echo i18n("Mailing Labels").": ";
|
|
echo "<a href=\"reports_mailinglabels.php\">".i18n("Mailing Label Generator")."</a>";
|
|
|
|
echo "<br />";
|
|
echo "<br />";
|
|
echo i18n("School Access Codes").": ";
|
|
echo "<a href=\"reports_gen.php?sid=36&type=pdf\">PDF</a> ";
|
|
echo "<a href=\"reports_gen.php?sid=36&type=csv\">CSV</a> ";
|
|
// echo "<a href=\"reports_schoolaccesscodes.php?type=pdf\">PDF</a> ";
|
|
// echo "<a href=\"reports_schoolaccesscodes.php?type=csv\">CSV</a> ";
|
|
|
|
echo "<br />";
|
|
echo i18n("Student Emergency Contact Names/Numbers").": ";
|
|
echo "<a href=\"reports_gen.php?sid=17&type=pdf\">PDF</a> ";
|
|
echo "<a href=\"reports_gen.php?sid=17&type=csv\">CSV</a> ";
|
|
echo "<br />";
|
|
echo i18n("Students/Projects From Each School").": ";
|
|
echo "<a href=\"reports_gen.php?sid=19&type=pdf\">PDF</a> ";
|
|
echo "<a href=\"reports_gen.php?sid=19&type=csv\">CSV</a> ";
|
|
|
|
echo "<br />";
|
|
echo i18n("Project Logistical Requirements (tables, electricity)").": ";
|
|
echo "<a href=\"reports_gen.php?sid=16&type=pdf\">PDF</a> ";
|
|
echo "<a href=\"reports_gen.php?sid=16&type=csv\">CSV</a> ";
|
|
echo "<br />";
|
|
|
|
echo i18n("Project Table Labels").": ";
|
|
echo "<a href=\"reports_gen.php?sid=30\">PDF</a> ";
|
|
echo "<br />";
|
|
|
|
echo i18n("Project Summary Details").": ";
|
|
echo "<a href=\"reports_projects_details.php?type=pdf\">PDF</a> ";
|
|
echo "<br />";
|
|
echo i18n("Nametags").": ";
|
|
echo "<a href=\"reports_gen.php?sid=26\">Students PDF</a> ";
|
|
echo "<a href=\"reports_gen.php?sid=26&type=csv\">Students CSV</a> ";
|
|
echo "<a href=\"reports_gen.php?sid=27\">Judges PDF</a> ";
|
|
echo "<a href=\"reports_gen.php?sid=27&type=csv\">Judges CSV</a> ";
|
|
echo "<a href=\"reports_gen.php?sid=28\">Committee PDF</a> ";
|
|
echo "<a href=\"reports_gen.php?sid=28&type=csv\">Committee CSV</a> ";
|
|
|
|
echo "<br />";
|
|
echo "<br />";
|
|
echo i18n("Judges List").": ";
|
|
echo "<a href=\"reports_judges.php?type=csv\">Judge List (CSV)</a> ";
|
|
|
|
echo "<br />";
|
|
echo i18n("Judging Teams").": ";
|
|
echo "<a href=\"reports_gen.php?sid=21&type=csv\">List (CSV)</a> ";
|
|
echo "<a href=\"reports_gen.php?sid=21&type=pdf\">List (PDF)</a> ";
|
|
echo "<a href=\"reports_gen.php?sid=22&type=csv\">Team Awards (CSV)</a> ";
|
|
echo "<a href=\"reports_gen.php?sid=22&type=pdf\">Team Awards (PDF)</a> ";
|
|
|
|
echo "<br />";
|
|
echo i18n("Judging Teams Project Assignments").": ";
|
|
echo "<a href=\"reports_judges_teams_projects.php?type=csv\">CSV</a> ";
|
|
echo "<a href=\"reports_judges_teams_projects.php?type=pdf\">PDF</a> ";
|
|
|
|
echo "<br />";
|
|
echo i18n("Projects Judging Team Assignments").": ";
|
|
echo "<a href=\"reports_projects_judges_teams.php?type=csv\">CSV</a> ";
|
|
echo "<a href=\"reports_projects_judges_teams.php?type=pdf\">PDF</a> ";
|
|
|
|
echo "<br />";
|
|
echo i18n("Project Identification Labels (for judging sheets)").": ";
|
|
echo "<a href=\"reports_gen.php?sid=29\">PDF</a> ";
|
|
echo "<br />";
|
|
echo "<br />";
|
|
|
|
|
|
echo i18n("Awards list for Program").": ";
|
|
echo "<a href=\"reports_program_awards.php?type=csv\">CSV</a> ";
|
|
|
|
|
|
echo "<br />";
|
|
echo i18n("Award Ceremony Script").": ";
|
|
echo "<a href=\"reports_acscript.php?type=pdf\">FULL PDF</a> ";
|
|
echo "<a href=\"reports_acscript.php?type=pdf&awardtype=Divisional\">(Divisional)</a> ";
|
|
echo "<a href=\"reports_acscript.php?type=pdf&awardtype=Special\">(Special)</a> ";
|
|
echo "<a href=\"reports_acscript.php?type=pdf&awardtype=Interdisciplinary\">(Interdisciplinary)</a> ";
|
|
echo "<a href=\"reports_acscript.php?type=pdf&awardtype=Other\">(Other)</a> ";
|
|
echo "<a href=\"reports_acscript.php?type=pdf&awardtype=Grand\">(Grand)</a> ";
|
|
echo "<br />";
|
|
echo i18n("Award Ceremony Script").": ";
|
|
echo "<a href=\"reports_acscript.php?type=csv\">CSV</a> ";
|
|
echo "<br />";
|
|
echo "<a href=\"reports_gen.php?sid=42\">Award Winners CSV</a> ";
|
|
echo "<br />";
|
|
|
|
send_footer();
|
|
?>
|