*
* 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.
*/
?>
prepare("SELECT * FROM fairs WHERE id=?");
$q->execute([$fairs_id]);
$fair = $q->fetch(PDO::FETCH_ASSOC);
if (!($fair['username'] && $fair['password'])) {
echo error(i18n("Username and Password are not set for source '%1'. Please set them in the Science-ation Configuration/External Award Sources editor first", array($r->name)));
return;
}
echo i18n('Checking %1 for awards...', array($fair['name']));
echo ' ';
if ($fair['type'] == 'ysc') {
$req = array('awardrequest' => array(
'username' => $fair['username'],
'password' => $fair['password'],
'year' => $config['FAIRYEAR'],
));
} else {
$req['getawards'] = array('year' => $config['FAIRYEAR']);
}
$data = curl_query($fair, $req);
if ($data['error'] != 0) {
echo error("Server said: {$data['message']} ");
send_footer();
exit;
}
echo notice(i18n('Server said: Success'));
// echo "sending [".nl2br(htmlspecialchars($xmldata))."]";
$keys = array_keys($data);
if (!array_key_exists('awards', $data)) {
echo error(i18n("Invalid XML response. Expecting '%1' in '%2'", array('awards', join(',', array_keys($data)))));
// echo "response=".print_r($data);
return;
}
// get a list of all the existing awards for this external source
$aq = $pdo->prepare("SELECT * FROM award_awards WHERE award_source_fairs_id=? AND year=?");
$aq->execute([$fairs_id,$config['FAIRYEAR']]);
$existingawards = array();
while ($ar = $aq->fetch(PDO::FETCH_OBJ)) {
$existingawards[$ar->id] = true;
}
echo '';
$awards = $data['awards'];
$postback = $data['postback'];
echo i18n('Postback URL: %1', array($postback)) . ' ';
$numawards = is_array($awards) ? count($awards) : 0;
echo i18n('Number of Awards: %1', array($numawards)) . ' ';
if ($numawards == 0) {
echo i18n('No awards to process') . ' ';
return;
}
$divs = projectdivisions_load();
$cats = projectcategories_load();
foreach ($awards as $award) {
$identifier = $award['identifier'];
$year = $award['year'];
echo i18n('Award Identifier: %1', array($identifier)) . ' ';
echo i18n('Award Year: %1', array($year)) . ' ';
echo i18n('Award Name: %1', array($award['name_en'])) . ' ';
if ($year != $config['FAIRYEAR']) {
echo error(i18n('Award is not for the current fair year... skipping'));
echo ' ';
continue;
}
$tq = $pdo->prepare("SELECT * FROM award_awards WHERE
external_identifier=? AND
award_source_fairs_id=? AND
year=?");
$tq->execute([$identifier,$fairs_id,$year]);
if ($tq->rowCount() == 0) {
/* Award doesn't exist, create it, then update it with the common code below */
$q = $pdo->prepare("INSERT INTO award_awards (award_types_id,
year, external_identifier,
award_source_fairs_id)
VALUES (2,?,
?,
?)");
$q->execute([$year,$identifier,$fairs_id]);
$award_id = $pdo->lastInsertId();
/* By default make all divs/cats eligible */
foreach ($divs as $id => $d)
$q = $pdo->prepare("INSERT INTO award_awards_projectdivisions(award_awards_id,projectdivisions_id,year) VALUES (?,?,?)");
$q->execute([$award_id,$id,$config['FAIRYEAR']]);
foreach ($cats as $id => $c)
$q = $pdo->prepare("INSERT INTO award_awards_projectcategories(award_awards_id,projectcategories_id,year) VALUES (?,?,?)");
$q->execute([$award_id,$id,$config['FAIRYEAR']]);
} else {
echo i18n('Award already exists, updating info') . ' ';
$awardrecord = $q->fetch(PDO::FETCH_OBJ);
$award_id = $awardrecord->id;
}
// remove it from the existingawards list
unset($existingawards[$award_id]);
// check if the sponsor exists, if not, add them
$sponsor_str = $award['sponsor'];
$sponsorq = $pdo->prepare("SELECT * FROM sponsors WHERE organization=?");
$sponsorq->execute([$sponsor_str]);
if ($sponsorr = $sponsorq->fetch(PDO::FETCH_OBJ)) {
$sponsor_id = $sponsorr->id;
} else {
$q = $pdo->prepare("INSERT INTO sponsors (organization,year,notes)
VALUES (?,?,'" . "Imported from external source: $r->name" . "')");
$q->execute([$sponsor_str,$year]);
show_pdo_errors_if_any($pdo);
$sponsor_id = $pdo->lastInsertId();
}
$self_nominate = ($award['self_nominate'] == 'yes') ? 'yes' : 'no';
$schedule_judges = ($award['schedule_judges'] == 'yes') ? 'yes' : 'no';
$q = $pdo->prepare("UPDATE award_awards SET
sponsors_id = ?,
name = ?,
criteria = ?,
external_postback = ?,
external_register_winners = ?,
external_additional_materials = ?,
self_nominate = ?,
schedule_judges = ?
WHERE id = ?
AND external_identifier = ?
AND year = ?");
$q->execute([
$sponsor_id,
$award['name_en'],
$award['criteria_en'],
$postback,
($award['external_register_winners'] == 1) ? 1 : 0,
($award['external_additional_materials'] == 1) ? 1 : 0,
$self_nominate,
$schedule_judges,
$award_id,
$identifier,
$year
]);
show_pdo_errors_if_any($pdo);
// update the prizes
$prizes = $award['prizes'];
if (!is_array($prizes)) {
continue;
}
echo i18n('Number of prizes: %1', array(count($prizes))) . ' ';
/* Get existing prizes */
$pq = $pdo->prepare("SELECT * FROM award_prizes WHERE award_awards_id=?");
$pq->execute([$award_id]);
$existingprizes = array();
while ($pr = $pq->fetch(PDO::FETCH_ASSOC))
$existingprizes[$pr['prize']] = $pr;
/* Iterate over the downloaded pizes */
foreach ($prizes AS $prize) {
// if it doesn't exist, add it
if (!array_key_exists($prize['prize_en'], $existingprizes)) {
/*
* Add a base entry, then update it below, yes it's two sql queries,
* but it's much shorter code, and means changing things in only
* one spot
*/
echo ' ' . i18n('Adding prize %1', array($prize['prize_en'])) . ' ';
$p = stripslashes($prize['prize_en']);
$q = $pdo->prepare("INSERT INTO award_prizes (award_awards_id,prize,year,external_identifier)
VALUES (?,?,?,?)");
$q->execute([$award_id,$p,$year,$p]);
$prize_id = $pdo->lastInsertId();
} else {
$ep = $existingprizes[$prize['prize_en']];
echo ' ' . i18n('Updating prize %1', array($ep['prize'])) . ' ';
$prize_id = $ep['id'];
// remove it from the list
unset($existingprizes[$ep['prize']]);
}
if (!array_key_exists('identifier', $prize))
$prize['identifier'] = $prize['prize_en'];
$q = $pdo->prepare("UPDATE award_prizes SET
cash =?,
scholarship =?,
value =?,
prize =?,
number =?,
`order` =?,
external_identifier =?,
trophystudentkeeper =?,
trophystudentreturn =?,
trophyschoolkeeper =?,
trophyschoolreturn =?
WHERE id =?");
$q->execute([
intval($prize['cash']),
intval($prize['scholarship']),
intval($prize['value']),
$prize['prize_en'],
intval($prize['number']),
intval($prize['ord']),
stripslashes($prize['identifier']),
intval($prize['trophystudentkeeper']),
intval($prize['trophystudentreturn']),
intval($prize['trophyschoolkeeper']),
intval($prize['trophyschoolreturn']),
$prize_id
]);
show_pdo_errors_if_any($pdo);
// FIXME: update the translations
}
/* Delete local entries that weren't downloaded */
foreach ($existingprizes AS $ep) {
echo ' ' . i18n('Removing prize %1', array($ep['prize'])) . ' ';
award_prize_delete($ep['id']);
}
}
echo ' ';
// remove any awards that are left in the $existingawards array, they must have been removed from the source
foreach ($existingawards AS $aid => $val) {
echo i18n('Removing award id %1 that was removed from external source', array($aid)) . ' ';
award_delete($aid);
}
echo '';
exit;
}
send_header('Download Awards',
array('Committee Main' => 'committee_main.php',
'Administration' => 'admin/index.php',
'Awards Main' => 'admin/awards.php'));
?>
prepare("SELECT * FROM fairs WHERE enable_awards='yes' ORDER BY name");
$q->execute();
while ($r = $q->fetch(PDO::FETCH_OBJ)) {
echo '