forked from science-ation/science-ation
99 lines
2.9 KiB
PHP
99 lines
2.9 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");
|
|
user_auth_required('committee', 'admin');
|
|
require("../tours.class.php");
|
|
require("../tableeditor.class.php");
|
|
|
|
|
|
|
|
send_header("Tour Management",
|
|
array('Committee Main' => 'committee_main.php',
|
|
'Administration' => 'admin/index.php',
|
|
'Tours' => 'admin/tours.php')
|
|
);
|
|
|
|
|
|
if($_GET['action'] == 'renumber') {
|
|
$q = $pdo->prepare("SELECT id FROM tours WHERE year='{$config['FAIRYEAR']}'");
|
|
$q->execute();
|
|
$x = 1;
|
|
while($i = $q->fetch(PDP::FETCH_OBJ)) {
|
|
$stmt = $pdo->prepare("UPDATE tours SET num='$x' WHERE id='{$i->id}'");
|
|
$stmt->execute();
|
|
$x++;
|
|
}
|
|
echo happy(i18n('Tours successfully renumbered'));
|
|
}
|
|
|
|
|
|
?>
|
|
<script language="javascript" type="text/javascript">
|
|
|
|
function opentoursinfo(id)
|
|
{
|
|
if(id)
|
|
currentid=id;
|
|
else
|
|
currentid=document.forms.tours["tourslist[]"].options[document.forms.tours["tourslist[]"].selectedIndex].value;
|
|
|
|
window.open("tours_info.php?id="+currentid,"JudgeInfo","location=no,menubar=no,directories=no,toolbar=no,width=770,height=500,scrollbars=yes");
|
|
return false;
|
|
|
|
}
|
|
</script>
|
|
|
|
<?
|
|
|
|
$icon_path = $config['SFIABDIRECTORY']."/images/16/";
|
|
$icon_exitension = $config['icon_extension'];
|
|
|
|
|
|
$editor = new TableEditor('tours');
|
|
|
|
// $editor->setDebug(true);
|
|
$editor->filterList("(tours.year={$config['FAIRYEAR']} OR tours.year IS NULL)");
|
|
|
|
$editor->execute();
|
|
|
|
if($_GET['TableEditorAction'] == '') {
|
|
|
|
echo i18n('You can automatically erase all the tour numbers and
|
|
re-number them (starting from 1) by clicking on the link below.
|
|
This will NOT affect any students who have already specified
|
|
their tour preferences. It will not change which tours
|
|
students have been assigned to (if that has been completed
|
|
too). It MAY cause the tour numbers to change, so if you have
|
|
already printed reports with the tour numbers on them, they
|
|
will need to be re--printed.');
|
|
|
|
echo '<br /><br />';
|
|
echo "<a onclick=\"return confirmClick('Are you sure you re-number ALL the tours?')\" href=\"tours_manager.php?action=renumber\">Renumber ALL Tours</a>";
|
|
}
|
|
|
|
send_footer();
|
|
?>
|