forked from science-ation/science-ation
184 lines
6.2 KiB
PHP
184 lines
6.2 KiB
PHP
<?
|
|
|
|
/*
|
|
* This file is part of the 'Science Fair In A Box' project
|
|
* Science-ation Website: https://science-ation.ca/
|
|
*
|
|
* Copyright (C) 2005 Sci-Tech Ontario Inc <info@scitechontario.org>
|
|
* Copyright (C) 2005 James Grant <james@lightbox.org>
|
|
* Copyright (C) 2024 AlgoLibre Inc. <science-ation@algolibre.io>
|
|
*
|
|
* 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_once('common.inc.php');
|
|
require_once('projects.inc.php');
|
|
require_once('lpdf.php');
|
|
|
|
/*
|
|
* Creates a nomination form for every winner of a specific award, should only be called
|
|
* by remote.php, which calls it only if the award has additional materials.
|
|
*/
|
|
function fair_additional_materials($fair, $award, $year)
|
|
{
|
|
global $config, $pdo;
|
|
|
|
$rep = new lpdf(
|
|
"{$config['fairname']} Awards Program",
|
|
'Nomination Form',
|
|
$_SERVER['DOCUMENT_ROOT'] . $config['SFIABDIRECTORY'] . '/data/logo.gif'
|
|
);
|
|
|
|
/* Grab a list of winners */
|
|
$q = $pdo->prepare("SELECT * FROM award_prizes
|
|
LEFT JOIN winners ON winners.awards_prizes_id=award_prizes.id
|
|
WHERE winners.year='$year'
|
|
AND winners.fairs_id='{$fair['id']}'");
|
|
$q->execute();
|
|
while ($r = $q->fetch()) {
|
|
$pid = $r['projects_id'];
|
|
$rep->newPage('', '', 1);
|
|
$rep->setFontSize(12);
|
|
|
|
/* Left margin width */
|
|
$x = 1;
|
|
|
|
$rep->setFontSize(14);
|
|
$rep->addText("{$award['name']}", 'center');
|
|
$rep->setFontSize(12);
|
|
$rep->addText("{$r['prize']}", 'center');
|
|
$rep->nextLine();
|
|
$rep->hr();
|
|
$rep->nextLine();
|
|
|
|
$rep->addTextX('Name of Regional Fair: ___________________________________________________', $x);
|
|
$rep->addTextX("{$fair['name']}", $x + 1.75);
|
|
|
|
$rep->nextLine();
|
|
|
|
$rep->addTextX('Authorized By: __________________________________________________________', $x);
|
|
$rep->nextLine();
|
|
$rep->addTextX('Position: _______________________________________________________________', $x);
|
|
$rep->nextLine();
|
|
|
|
$rep->addTextX('Date: ________________________________________', $x);
|
|
$rep->addTextX(date('l F dS, Y'), $x + 0.5);
|
|
$rep->nextLine();
|
|
$rep->nextLine();
|
|
|
|
$p = project_load($pid);
|
|
// print_r($p);
|
|
|
|
$rep->addTextX('Project Title: ____________________________________________________________', $x);
|
|
$rep->prevLine();
|
|
$rep->addText("{$p['title']}", 'left', $x + 1);
|
|
$rep->nextLine();
|
|
$rep->nextLine();
|
|
$rep->nextLine();
|
|
|
|
foreach ($p['student'] as $s) {
|
|
$rep->addTextX('Name of Student: ________________________________________________________', $x);
|
|
$rep->addTextX("{$s['firstname']} {$s['lastname']}", $x + 1.25);
|
|
$rep->nextLine();
|
|
$rep->addTextX('Grade: _____________ Date of birth: _____________', $x);
|
|
$rep->addTextX("{$s['grade']}", $x + 0.75);
|
|
list($y, $m, $d) = explode('-', $s['dateofbirth']);
|
|
$dob = date('M j, Y', mktime(0, 0, 0, $m, $d, $y));
|
|
$rep->addTextX("$dob", $x + 3);
|
|
$rep->nextLine();
|
|
$rep->addTextX('School: ________________________________________________________________', $x);
|
|
$rep->addTextX("{$s['school']}", $x + 0.75);
|
|
$rep->nextLine();
|
|
$rep->addTextX('Home Address: __________________________________________________________', $x);
|
|
$rep->prevLine();
|
|
$rep->addText("{$s['address']} {$s['city']}, {$s['province']} {$s['postalcode']}", 'left', $x + 1.25);
|
|
$rep->nextLine();
|
|
$rep->nextLine();
|
|
$rep->nextLine();
|
|
}
|
|
|
|
$rep->hr();
|
|
|
|
$rep->setFontBold();
|
|
$rep->addText("To be considered for this award the following materials need to be included with this form:\n");
|
|
$rep->setFontNormal();
|
|
$rep->nextLine();
|
|
|
|
$rep->addText('1.');
|
|
$rep->prevLine();
|
|
$rep->addText("Project Summary/Discussion Paper (Please include a copy of the summary sheet and any documentation that accompanied the display, including charts and diagrams, that will improve the understanding and comprehension of the science fair project.\n", 'left', 0.9);
|
|
$rep->addText('2. Copy of Judges Report and Comments.');
|
|
$rep->addText('3. Colour photograph(s) of the exhibitor(s) and the exhibit.');
|
|
$rep->addText('4. Completed Declaration of Exhibitor form (next page) ');
|
|
|
|
$rep->nextLine();
|
|
|
|
$rep->newPage();
|
|
|
|
$rep->nextLine();
|
|
$rep->setFontBold();
|
|
$rep->addText('DECLARATION OF EXHIBITOR', 'center');
|
|
$rep->nextLine();
|
|
$rep->setFontNormal();
|
|
$rep->nextLine();
|
|
$rep->nextLine();
|
|
$i = ($p['num_students'] == 1) ? 'I' : 'We';
|
|
$my = ($p['num_students'] == 1) ? 'my' : 'our';
|
|
$rep->addText("1. $i certify this exhibit and report is $my own work.");
|
|
$rep->nextLine();
|
|
$fn = strtoupper($config['fairname']);
|
|
$rep->addText('2.');
|
|
$rep->prevLine();
|
|
$rep->addText("$i hereby give permission to $fn the AWARDING ORGANIZATION to publicize $my award and reprint $my project summary.", 'left', 0.9);
|
|
|
|
$rep->nextLine();
|
|
$rep->nextLine();
|
|
$rep->nextLine();
|
|
|
|
foreach ($p['student'] as $s) {
|
|
$rep->addText('______________________________________ _____________________', 'center');
|
|
$rep->nextLine();
|
|
$rep->addTextX("SIGNATURE ({$s['firstname']} {$s['lastname']})", 1.5);
|
|
$rep->addTextX('Date', 6.25);
|
|
$rep->nextLine();
|
|
$rep->nextLine();
|
|
$rep->nextLine();
|
|
}
|
|
|
|
$rep->addText('Certified by:');
|
|
$rep->nextLine();
|
|
$rep->nextLine();
|
|
$rep->nextLine();
|
|
|
|
$rep->addText('______________________________________ _____________________', 'center');
|
|
$rep->nextLine();
|
|
$rep->addTextX('POSITION', 2.5);
|
|
$rep->addTextX('Date', 6.25);
|
|
$rep->nextLine();
|
|
|
|
$rep->nextLine();
|
|
$rep->nextLine();
|
|
|
|
$rep->addText('_________________________________________________', 'center');
|
|
$rep->nextLine();
|
|
$rep->addText('(Regional Chairperson, Awards Chairperson, or Chief Judge)', 'center');
|
|
}
|
|
|
|
return $rep->outputArray();
|
|
}
|
|
|
|
?>
|