public function show($permalink = null, $id = null)
{
$event = self::load_event();
$ticket = self::load_ticket($event);
$sort = "";
if (isset($_GET['sort'])) {
$sort = $_GET['sort'];
}
if ($sort == "nickname") {
$order = "users.nickname ASC";
} elseif ($sort == "date") {
$order = "event_signups.created_at DESC";
} elseif ($sort == "id") {
$order = "event_signups.id ASC";
} else {
$order = "event_signups.paid DESC, users.nickname ASC";
}
$page = 1;
if (isset($_GET['page'])) {
$page = $_GET['page'];
}
$id = mysql_real_escape_string($ticket->id);
$signups = EventSignup::paginate("event_signups.event_ticket_id = '{$id}'", $order, $page, 20);
$this->assign("event", $event);
$this->assign("ticket", $ticket);
$this->assign("signups", $signups);
$this->assign("sort", $sort);
$this->title = "View Ticket";
$this->render("event_ticket/show.tpl");
}
public function index($permalink = null)
{
$event = self::load_event($permalink);
$this->assign("event", $event);
$sort = "";
$order = "";
if (isset($_GET['sort'])) {
$sort = $_GET['sort'];
}
if ($sort == "nickname") {
$order = "users.nickname ASC";
} elseif ($sort == "seat") {
$order = "event_seats.row ASC, event_seats.number ASC, users.nickname ASC";
} elseif ($sort == "location") {
$order = "users.county ASC, users.nickname ASC";
} elseif ($sort == "clan") {
$order = "users.clan ASC, users.nickname ASC";
} elseif ($sort == "lift") {
$order = "event_signups.lift_required DESC, users.county ASC, users.nickname ASC";
} else {
$sort = "paid";
$order = "event_signups.paid DESC, users.nickname ASC";
}
$order = "event_tickets.staff ASC, event_tickets.participant DESC, {$order}";
$event_id = mysql_real_escape_string($event->id);
$page = $this->getData('page', 1);
$signups = EventSignup::paginate("event_signups.event_id = '{$event_id}'", $order, $page, 100);
$this->assign("signups", $signups);
$this->assign("sort", $sort);
$this->title = $event->name . " :: Attendance";
$this->render("event_signup/index.tpl");
}
<?php
require "init.php";
$script = Script::find_by_code('loyalty_attendance');
$script->start();
ob_start();
$time = date("H:i:s");
echo "[{$time}] Attendance Loyalty Points\r\n\r\n";
$page = EventSignup::paginate("event_signups.paid = 1 AND event_signups.processed = 0 AND events.startdate <= NOW()", "event_signups.created_at ASC", 1, 50);
$count = count($page->collection);
echo " Processing {$count} / {$page->total} signups\r\n";
foreach ($page->collection as $obj) {
mysql_query('BEGIN');
$loyalty = true;
if ($obj->event_ticket->points_value > 0 && !$obj->event_ticket->staff) {
$loyalty = $obj->user->award_loyalty($obj->event_ticket->points_value, "Attendance: {$obj->event->shortname} {$obj->event_ticket->name}");
$script->addlog("Awarded {$obj->event_ticket->points_value}pts to [{$obj->user}] {$obj->user->nickname} for [{$obj->event_ticket}] {$obj->event->shortname} {$obj->event_ticket->name}");
}
$obj->processed = true;
$ua = $obj->save();
if ($loyalty && $ua) {
mysql_query('COMMIT');
} else {
echo "Error processing [{$obj}]\r\n";
print_r($obj);
mysql_query('ROLLBACK');
$script->addlog("Error processing [{$obj}]", 'Critical');
}
}
$script = Script::find_by_code('loyalty_attendance');
$output = ob_get_clean();
public function index($permalink = null)
{
$sort = $this->GetData('sort', "id");
if ($sort == "nickname") {
$order = "users.nickname ASC";
} elseif ($sort == "date") {
$order = "event_signups.created_at DESC";
} elseif ($sort == "id") {
$order = "event_signups.id ASC";
} elseif ($sort == "seat") {
$order = "event_seats.row ASC, event_seats.number ASC";
} elseif ($sort == "ticket") {
$order = "event_tickets.name ASC";
} elseif ($sort == "event") {
$order = "events.name DESC";
} elseif ($sort == "voucher") {
$order = "event_signups.voucher DESC";
} else {
$order = "event_signups.paid DESC, users.nickname ASC";
}
if (isset($_SESSION['signupadminquery'])) {
$query = $_SESSION['signupadminquery'];
} else {
$query = (object) array('event_id' => null, 'signup_id' => null);
}
if (isset($_GET['event_id'])) {
$query->event_id = $this->GetData('event_id');
}
if (isset($_GET['signup_id'])) {
$query->signup_id = $this->GetData('signup_id');
}
$_SESSION['signupadminquery'] = $query;
$filters = array();
if ($query->event_id) {
$event_id = mysql_real_escape_string($query->event_id);
$filters[] = "events.id = '{$event_id}'";
}
if ($query->signup_id) {
$signup_id = mysql_real_escape_string($query->signup_id);
$filters[] = "event_signups.id = '{$signup_id}'";
}
$filter = implode(' AND ', $filters);
$page = $this->GetData('page', 1);
$signups = EventSignup::paginate($filter, $order, $page, 100);
$allEvents = Event::find_all("", "events.startdate DESC");
$events = array('' => 'All');
foreach ($allEvents as $event) {
$events[$event->id] = $event->name;
}
$this->assign('query', $query);
$this->assign('events', $events);
$this->assign("signups", $signups);
$this->assign("sort", $sort);
$this->title = "Event Signups";
$this->render("event_signup/index.tpl");
}
