public function logex($xacttype, $description = NULL, $userix = NULL, $orderix = NULL, $eventix = NULL, $detail = NULL)
{
global $debug;
$this->xacttype = $xacttype;
if ($description) {
$this->description = $description;
}
if ($userix) {
$this->userix = $userix;
}
if ($orderix) {
$this->orderix = $orderix;
}
if ($eventix) {
$this->eventix = $eventix;
}
if ($detail) {
$this->detail = $detail;
}
$sql = "INSERT INTO xactlog SET " . "xacttype = '{$xacttype}', ";
if ($description) {
$sql .= " description = '{$description}', ";
}
if ($userix) {
$sql .= " userix = {$userix}, ";
}
if ($orderix) {
$sql .= " orderix = {$orderix}, ";
}
if ($eventix) {
$sql .= " eventix = {$eventix}, ";
}
if ($detail) {
$sql .= " detail = '{$detail}', ";
}
$sql = substr($sql, 0, strlen($sql) - 2);
if ($debug > 1) {
dispsql($sql);
}
$result = mysql_query($sql) or die("Error logging to xactlog. " . mysql_error());
$this->xactix = mysql_insert_id();
$this->xacttime = dbgetsingleton("SELECT xacttime FROM xactlog WHERE xactix = {$this->xactix}", "xacttime");
if ($debug > 1) {
echo "<pre>";
print_r($this);
echo "</pre>\n";
}
}
}
if (!$passwd2) {
$errlist .= "<li>Password again is required.</li>";
$errors++;
}
/* Repeat entry checks */
if ($usernm != $usernm2) {
$errlist .= "<li>E-mail addresses do not match.</li>";
$errors++;
}
if ($passwd != $passwd2) {
$errlist .= "<li>Passwords do not match.</li>";
$errors++;
}
/* User name uniqueness check */
$count = dbgetsingleton("SELECT COUNT(*) cnt FROM user WHERE usernm = '{$usernm}'", "cnt");
if ($count) {
$errlist .= "<li>E-mail address \"{$usernm}\" has already been registered.</li>";
$errors++;
}
$errlist .= "</ul>\n";
if ($errors) {
$presentform = 1;
} else {
$errlist = "";
/* Create user record */
$user = new User($usernm, $firstnm, $lastnm, $phonenbr, false, $passwd);
$user->save();
$user->passwd = "";
$_SESSION["user"] = $user;
echo "<p>Congratulations! You have been registered and are logged in.</p>\n";
function getEventTypeCount($eventcdptrn)
{
$sql = "SELECT COUNT(*) cnt FROM event WHERE eventcd LIKE '{$eventcdptrn}' AND active AND eventdt >= CURDATE()";
return dbgetsingleton($sql, "cnt");
}
$myreserved = 0;
$mywaiting = 0;
}
/* Event header */
$price = $member ? $row->mbrprice : $row->guestprice;
$eventcdpfx = substr($row->eventcd, 0, strlen($row->eventcd) - 1);
if (!$row->eventgrouped) {
$flag = $openings <= 0 ? "<span class='flag'>SOLD OUT</span>" : "";
printf("<h3>%s - %s %s</h3>\n", $row->eventnm, $row->fmteventdt, $flag);
printf("<p style='font-size: small'>{$row->longDescription}</p>\n");
printResvPrice($member, $row->mbrprice, $row->guestprice);
} else {
# Special query to determine if the entire grouped event is sold out
if ($eventcdpfx != $preveventcdpfx) {
$gcapacity = dbgetsingleton("SELECT SUM(capacity) gcapacity " . " FROM event " . " WHERE eventcd LIKE '{$eventcdpfx}_'", "gcapacity");
$greserved = dbgetsingleton("SELECT COUNT(*) greserved " . " FROM registration r JOIN event e USING (eventix) " . " WHERE e.eventcd LIKE '{$eventcdpfx}_'", "greserved");
$flag = $greserved >= $gcapacity ? "<span class='flag'>SOLD OUT</span>" : "";
printf("<h3>%s - %s %s</h3>\n", $row->eventnm, $row->fmteventdt, $flag);
$preveventcdpfx = $eventcdpfx;
printf("<p>{$row->longDescription}</p>\n");
printResvPrice($member, $row->mbrprice, $row->guestprice);
}
}
/* Event status table
**
** +----------+----------+----------+----------+----------+----------+
** | | Reserved | Released | Openings | | Waiting |
** | Event +----------+----------+----------+ +----------+
** | Time | Bargraph | Controls | Bargraph |
** | +--------------------------------+ +----------+
** | | Personal Reservations | | PersWait |
$eventnm = $row['eventnm'];
$eventdt = $row['eventdt'];
$capacity = $row['capacity'];
$mbrprice = $row['mbrprice'];
$guestprice = $row['guestprice'];
/* Get reservation counts */
$reserved = dbgetsingleton("SELECT COUNT(*) reserved " . " FROM registration " . " WHERE eventix = {$eventix} " . " AND NOT waiting " . " AND releasetime IS NULL", "reserved");
$released = dbgetsingleton("SELECT COUNT(*) released " . " FROM registration " . " WHERE eventix = {$eventix} " . " AND NOT waiting " . " AND releasetime IS NOT NULL", "released");
$openings = $capacity - $reserved;
$waiting = dbgetsingleton("SELECT COUNT(*) waiting " . " FROM registration " . " WHERE eventix = {$eventix} AND waiting", "waiting");
/* Get personal reservation counts */
if ($usernm) {
$myreserved = dbgetsingleton("SELECT COUNT(*) myreserved " . " FROM registration " . " WHERE eventix = {$eventix} " . " AND NOT waiting " . " AND userix = {$userix} " . " AND releasetime IS NULL", "myreserved");
$myreleased = dbgetsingleton("SELECT COUNT(*) myreleased " . " FROM registration " . " WHERE eventix = {$eventix} " . " AND NOT waiting " . " AND userix = {$userix} " . " AND releasetime IS NOT NULL", "myreleased");
if ($waiting) {
$mywaiting = dbgetsingleton("SELECT COUNT(*) mywaiting " . " FROM registration " . " WHERE eventix = {$eventix} AND waiting AND userix = {$userix}", "mywaiting");
}
} else {
$myreserved = 0;
$mywaiting = 0;
}
/* Put out one event section */
$price = $member ? $mbrprice : $guestprice;
printf("<h3>%s - %s (Reservations: \$%.2f)</h3>\n", $eventnm, $eventdt, $price / $pricedivider);
if (!$member) {
warning(sprintf("If you were a member this reservation would only cost \$%.2f.", $mbrprice));
}
echo "<table width=100%>\n";
echo "<tr><td width=50%>\n";
/* Entire event counts */
echo "<table><tr>\n";
require_once "{$TKTDIR}database.php";
require_once "{$TKTDIR}xactlog.php";
require_once "{$TKTDIR}order.php";
dbconnect();
$x = new XactLog();
$order = new Order();
$ipn = $_POST;
$orderix = postvalue("invoice", NULL);
$payment_status = postvalue("payment_status", NULL);
$mc_gross = postvalue("mc_gross", 0.0);
$userix = NULL;
if ($orderix) {
$order->loadByOrderIx($orderix);
$userix = $order->userix;
if ($userix) {
$usernm = dbgetsingleton("SELECT usernm FROM user WHERE userix = {$userix}", "usernm");
}
}
$x->log("PP IPN Notificaton", "Unvalidated PP Notification", $userix, $orderix, NULL, print_r($_POST, true));
/* Form the response */
if (array_key_exists("test_ipn", $_POST) && $_POST["test_ipn"] == 1) {
$ppurl = "https://www.sandbox.paypal.com/cgi-bin/webscr";
} else {
$ppurl = "https://www.paypal.com/cgi-bin/webscr";
}
$request = curl_init();
curl_setopt_array($request, array(CURLOPT_URL => $ppurl, CURLOPT_POST => TRUE, CURLOPT_POSTFIELDS => http_build_query(array("cmd" => "_notify-validate") + $_POST), CURLOPT_RETURNTRANSFER => TRUE, CURLOPT_HEADER => FALSE, CURLOPT_SSL_VERIFYPEER => TRUE));
/* Send the response */
$response = curl_exec($request);
$status = curl_getinfo($request, CURLINFO_HTTP_CODE);
curl_close($request);
require_once "{$TKTDIR}database.php";
require_once "DynHtmlPage2.php";
require_once "DynHtmlBlock.php";
$pageName = "Reports";
$debug = 0;
$year = getvalue("year", 0);
DynHtmlPage::docHeader($pageName);
DynHtmlPage::header();
echo "<div class='colmask leftmenu'>\n";
loginprompt();
dbconnect();
# Report menu logic
if (User::isAdmin()) {
echo "<ul>\n";
echo "<li><a href='report.orderByUser.php'>Orders by User</a></li>\n";
$currseason = dbgetsingleton("SELECT season currseason FROM season WHERE startdt = (SELECT MAX(startdt) FROM season)", "currseason");
echo "<li><a href='report.membership.php?season={$currseason}'>Membership ({$currseason})</a></li>\n";
echo "<li>Event Registration\n";
echo "<ul>\n";
if ($year == 0) {
$sql = "SELECT eventix, eventnm, eventdt \n\t\t\t\t\tFROM event \n\t\t\t\t\tWHERE eventdt > CURRENT_DATE - INTERVAL 7 DAY \n\t\t\t\t\tORDER BY eventdt, advstarttm";
} else {
$sql = "SELECT eventix, eventnm, eventdt \n\t\t\t\t\tFROM event \n\t\t\t\t\tWHERE YEAR(eventdt) = {$year}\n\t\t\t\t\tORDER BY eventdt, advstarttm";
}
$result = mysql_query($sql) or die("Error selecting from event. " . mysql_error());
while ($row = mysql_fetch_assoc($result)) {
$url = "report.eventRegistration.php?eventix=" . $row['eventix'];
printf("<li><a href='%s'>%s - %s</a></li>\n", $url, $row['eventdt'], $row['eventnm']);
}
echo "</ul></li>\n";
echo "<li>Event Registration - Historical\n";
$debug = 1;
dbconnect();
/* Event table */
echo "<h1>Event Detail</h1>\n";
$sql = "SELECT r.eventix, r.userix, r.position, r.waiting, " . " e.eventnm, e.capacity, u.usernm \n" . " FROM registration r \n" . " JOIN event e ON (r.eventix = e.eventix) \n" . " JOIN user u ON (r.userix = u.userix) \n" . " ORDER BY r.eventix, r.position, r.waiting";
dispsql($sql);
$res = mysql_query($sql) or die("Error during select. " . mysql_error());
$cbeventix = 0;
while ($row = mysql_fetch_assoc($res)) {
if ($cbeventix != $row['eventix']) {
$cbeventix = $row['eventix'];
$eventnm = $row['eventnm'];
$capacity = $row['capacity'];
$registered = dbgetsingleton("SELECT COUNT(*) registered FROM registration WHERE eventix = {$cbeventix} AND waiting = 0", "registered");
$openings = $capacity - $registered;
$waiting = dbgetsingleton("SELECT COUNT(*) waiting FROM registration WHERE eventix = {$cbeventix} AND waiting = 1", "waiting");
echo "<h2>eventix {$cbeventix}, eventnm: {$eventnm}, registered: {$registered}, openings: {$openings}, waiting: {$waiting}</h2>\n";
}
if ($debug) {
echo "position: {$row['position']}, ";
echo "userix: {$row['userix']}, ";
echo "waiting: {$row['waiting']}, ";
echo "usernm: {$row['usernm']}";
} else {
echo $row['position'] . ": ";
echo $row['usernm'] . " ";
if ($row['waiting']) {
echo " (waiting)";
}
}
echo "<br/>\n";
public function setPmtRejTime()
{
$sql = "UPDATE orderhdr SET \n" . " pmtrejtime = CURRENT_TIMESTAMP \n" . " WHERE orderix = {$this->orderix}";
dispsql($sql);
$result = mysql_query($sql) or die("Error updating Order payment rejection timestamp. " . mysql_error());
$this->pmtrejtime = dbgetsingleton("SELECT pmtrejtime FROM orderhdr WHERE orderix = {$this->orderix}", "pmtrejtime");
return $this->pmtrejtime;
}
