function eventEmail($eventNo, $type) { global $BASEURL, $CHOIR; $sql = "select * from `eventType` where `id` = '{$type}'"; $eventType = mysql_fetch_array(mysql_query($sql)); $typeName = $eventType['name']; $eventResults = mysql_fetch_array(mysql_query("SELECT * from `event` where `eventNo` = '{$eventNo}'")); $eventName = $eventResults['name']; $eventType = $eventResults['type']; $eventTime = $eventResults['callTime']; $eventReleaseTime = $eventResults['releaseTime']; $eventComments = $eventResults['comments']; $eventLocation = $eventResults['location']; $gigResults = mysql_fetch_array(mysql_query("select * from `gig` where `eventNo` = '{$eventNo}'")); $uniformCode = $gigResults['uniform']; $uniformResults = mysql_fetch_array(mysql_query("select `name` from `uniform` where `id` = '{$uniformCode}'")); $eventUniform = $uniformResults['name']; $eventTime = strtotime($eventTime); $eventTimeDisplay = date("D, M d g:i a", $eventTime); $eventReleaseTime = strtotime($eventReleaseTime); $eventReleaseTimeDisplay = date("D, M d g:i a", $eventReleaseTime); $typeResults = mysql_fetch_array(mysql_query("SELECT * from `eventType` where `id` = '{$eventType}`")); $eventType = $typeResults['name']; $redirectURL = "{$BASEURL}/php/fromEmail.php"; $eventUrl = "{$BASEURL}/#event:{$eventNo}"; if (!$CHOIR) { die("Choir not set"); } $row = mysql_fetch_array(mysql_query("select `admin`, `list` from `choir` where `id` = '{$CHOIR}'")); $sender = $row['admin']; $recipient = $row['list']; //$recipient = "Matthew Schauer <*****@*****.**>"; $choirname = choirname($CHOIR); $subject = "New {$choirname} Event"; $headers = "Content-type:text/html;\n" . "Reply-To: {$sender}\n" . "From: {$sender}\n" . 'X-Mailer: PHP/' . phpversion(); $message = "<html><head></head><body>\n\t\t<h2><a href='{$eventUrl}'>{$eventName}</a></h2>\n\t\t<p><b>{$typeName}</b> from <b>{$eventTimeDisplay}</b> to {$eventReleaseTimeDisplay} at <b>{$eventLocation}</b></p>\n\t\t<p>Uniform: {$eventUniform}</p>\n\t\t<p>{$eventComments}</p>"; $message .= "<form action='{$redirectURL}' method='get'><input type='hidden' value='{$eventNo}' name='id' />"; if ($typeName == "Volunteer Gig") { $confirm = "I will attend"; } else { if ($typeName == "Tutti Gig") { $confirm = "Confirm I will attend"; } } $yesform = "<button type='submit' value='true' name='attend'>{$confirm}</button>"; $noform = "<button type='submit' value='false' name='attend'>I will not attend</button>"; if ($typeName == "Volunteer Gig") { $message .= $yesform . $noform; } else { if ($typeName == "Tutti Gig") { $message .= $yesform; } } $message .= '</form></body></html>'; if (!mail($recipient, $subject, $message, $headers)) { die("Failed to send event email"); } }
$count = 0; foreach ($emailArr as $email) { if ($email == '') { continue; } // Ignore transactions with nobody if (!mysql_query("insert into transaction (memberID, choir, amount, description, semester, type) values ('" . mysql_escape_string($email) . "', '{$CHOIR}', '" . mysql_escape_string($amountArr[$count]) . "','" . mysql_escape_string($descriptionArr[$count]) . "', '" . mysql_escape_string($semArr[$count]) . "', '" . mysql_escape_string($typeArr[$count]) . "')")) { die(mysql_error()); } if ($sendArr[$count]) { $name = fullNameFromEmail(mysql_real_escape_string($email)); $msg = "Keep this receipt for your records."; $msg .= "<br />Name: " . $name; $msg .= "<br />Semester: " . $semArr[$count]; $result = mysql_fetch_array(mysql_query("select `name` from `transacType` where `id` = '" . $typeArr[$count] . "'")); $msg .= "<br />Category: " . $result['name']; $msg .= "<br />Amount: " . $amountArr[$count]; $msg .= "<br />Description: " . $descriptionArr[$count]; $msg .= "<br />Date: " . date('l jS \\of F Y'); //$msg .= "<br />Hash (for Treasurer's use): " . encrypt($d); $title = choirname($CHOIR) . " Receipt"; $headers = 'MIME-Version: 1.0' . "\n"; $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\n"; mail($treasurerEmail . ', ' . $email, $title, $msg, $headers); } $count++; } echo "OK"; } else { echo "ERR"; }
$subcondarr[] = "(select sum(`transaction`.`amount`) from `transaction` where `transaction`.`semester` = '{$SEMESTER}' and `transaction`.`type` = 'dues' and `transaction`.`memberID` = `member`.`email`) < 0"; } } } } } } } $condarr[] = join(' or ', $subcondarr); } $condstr = '(' . join(") and (", $condarr) . ')'; if (!isOfficer($USER)) { $condstr = "exists (select * from `activeSemester` where `activeSemester`.`semester` = '{$SEMESTER}' and `activeSemester`.`member` = `member`.`email`)"; } if ($_POST['type'] == "print") { $choirname = choirname($CHOIR); echo "<html><head><meta charset='UTF-8'><title>{$choirname} Roster</title></head><body>{$style}"; echo member_table($condstr, "print"); echo "</body></html>"; } else { if ($_POST['type'] == "csv") { //header("Content-type: text/csv"); echo member_csv($condstr); } else { if ($_POST['type'] == "normal") { echo $style; echo member_table($condstr, "normal"); } else { die("Unknown type"); } }
function info($userEmail) { global $SEMESTER, $CHOIR; $html = ""; $sql = "select sum(`amount`) as `balance` from `transaction` where `memberID` = '{$userEmail}' and `type` = 'dues' and `semester` = '{$SEMESTER}'"; $result = mysql_fetch_array(mysql_query($sql)); $dues = $result['balance']; if ($dues == '') { $dues = 0; } $sql = "select sum(`amount`) as `balance` from `transaction` where `memberID` = '{$userEmail}' and `type` = 'deposit'"; $result = mysql_fetch_array(mysql_query($sql)); $tie = $result['balance']; if ($tie == '') { $tie = 0; } $html .= "<table><tr><td>"; if ($dues >= 0) { $html .= "<span class='color: green'><i class='icon-ok'></i></span>"; } else { $html .= "<span class='color: red'><i class='icon-remove'></i></span>"; } $html .= "</td><td>Dues</td></tr><tr><td>"; if ($tie >= fee("tie")) { $html .= "<span class='color: green'><i class='icon-ok'></i></span>"; } else { $html .= "<span class='color: red'><i class='icon-remove'></i></span>"; } $html .= "</td><td>Tie Deposit</td></tr></table><br>"; $sql = "select `tie` from `tieBorrow` where `member` = '{$userEmail}' and `dateIn` is null"; $query = mysql_query($sql); if (mysql_num_rows($query) == 0) { $html .= "You do <b>not</b> have a tie checked out."; } else { $result = mysql_fetch_array($query); $html .= "You have tie <b>" . $result['tie'] . "</b> checked out."; } $html .= "<br>"; $balance = balance($userEmail); $choir = choirname($CHOIR); if ($balance > 0) { $html .= "{$choir} owes you <span style='font-weight: bold; color: blue'>\${$balance}</span>."; } else { if ($balance < 0) { $balance *= -1; $html .= "You owe {$choir} <span style='font-weight: bold; color: red'>\${$balance}</span>."; } else { $html .= "Your {$choir} balance is <span style='font-weight: bold'>\$0</span>."; } } $html .= "<br><br>" . user_money_table($userEmail); return "{$html}"; }