function dumptable($tablenm)
{
echo "<h1>{$tablenm}</h1>\n";
$sql = "SELECT * from {$tablenm}";
dispsql($sql);
$res = mysql_query($sql) or die("Error during select. " . mysql_error());
disphor($res);
}
public function loadByUserNm($usernm)
{
$sql = "SELECT usernm, userix, firstnm, lastnm, phonenbr, member, admin " . " FROM user " . " WHERE usernm = '{$usernm}'";
dispsql($sql);
$result = mysql_query($sql) or die("Error loading User for {$usernm}. " . mysql_error());
$o = mysql_fetch_object($result, "User");
$this->usernm = $o->usernm;
$this->userix = $o->userix;
$this->firstnm = $o->firstnm;
$this->lastnm = $o->lastnm;
$this->phonenbr = $o->phonenbr;
$this->member = $o->member;
$this->admin = $o->admin;
}
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";
}
}
public function save()
{
$ER_DUP_ENTRY = 1062;
$sql = "INSERT INTO orderdtl SET " . " orderix = {$this->orderix}, " . " orderdtlix = {$this->orderdtlix}, " . " itemix = {$this->itemix}, " . " eventix = {$this->eventix}, " . " action = '{$this->action}', " . " qty = {$this->qty}, " . " extamt = {$this->extamt}";
dispsql($sql);
$result = mysql_query($sql);
$errno = mysql_errno();
if ($errno == $ER_DUP_ENTRY) {
$sql = "UPDATE orderdtl SET " . " orderix = {$this->orderix}, " . " orderdtlix = {$this->orderdtlix}, " . " itemix = {$this->itemix}, " . " eventix = {$this->eventix}, " . " action = '{$this->action}', " . " qty = {$this->qty}, " . " extamt = {$this->extamt} " . " WHERE orderix = {$this->orderix} AND " . " orderdtlix = {$this->orderdtlix}";
dispsql($sql);
$result = mysql_query($sql) or die("Error updating OrderDtl for orderix {$this->orderix}, orderdtlix {$this->orderdtlix}. " . mysql_error());
} else {
die("{$errno}: Error inserting OrderDtl for orderix {$this->orderix}, " . "orderdtlix {$this->orderdtlix}. " . mysql_error());
}
return mysql_affected_rows();
}
public function save()
{
if (!$this->userix) {
$sql = "INSERT INTO user SET " . " usernm = '{$this->usernm}', " . " passwd = PASSWORD('{$this->passwd}'), " . " firstnm = '{$this->firstnm}', " . " lastnm = '{$this->lastnm}', " . " phonenbr = '{$this->phonenbr}', " . " member = '{$this->member}'";
if (1) {
dispsql($sql);
}
$result = mysql_query($sql) or die("Error inserting user {$this->usernm}. " . mysql_error());
$this->userix = mysql_insert_id();
} else {
$sql = "UPDATE user SET " . " usernm = '{$this->usernm}', " . " firstnm = '{$this->firstnm}', " . " lastnm = '{$this->lastnm}', " . " phonenbr = '{$this->phonenbr}', " . " member = '{$this->member}' " . " WHERE userix = {$this->userix}";
if (1) {
dispsql($sql);
}
$result = mysql_query($sql) or die("Error updating user {$this->usernm}. " . mysql_error());
}
}
(SELECT COUNT(*) FROM registration r
WHERE r.waiting
AND r.eventix = e.eventix)
AS waiting,
(SELECT COUNT(*) FROM registration r
WHERE r.waiting
AND r.eventix = e.eventix
\t\tAND r.userix = {$userix})
AS mywaiting
FROM event e
{$whereClause}
GROUP BY e.eventdt, e.advstarttm, e.eventcd
ORDER BY e.eventdt, e.advstarttm, e.eventcd
EOQ;
if ($debug > 1) {
dispsql($sql);
}
$res = mysql_query($sql) or die("Error during event select. " . mysql_error());
echo "<form action='eventorder.php' method='post'>\n";
if ($userix) {
echo "<input type='submit' name='action' value='Submit Order'>\n";
}
$ix = 0;
$preveventcdpfx = '';
while ($row = mysql_fetch_object($res)) {
$openings = max($row->capacity - $row->reserved, 0);
/* Get personal reservation counts */
if ($usernm) {
$myreserved = dbgetsingleton("SELECT COUNT(*) myreserved " . " FROM registration " . " WHERE eventix = {$row->eventix} " . " AND NOT waiting " . " AND userix = {$userix} " . " AND releasetime IS NULL", "myreserved");
$myreleased = dbgetsingleton("SELECT COUNT(*) myreleased " . " FROM registration " . " WHERE eventix = {$row->eventix} " . " AND NOT waiting " . " AND userix = {$userix} " . " AND releasetime IS NOT NULL", "myreleased");
if ($row->waiting) {
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;
}
