function populateListCustomersSummary($linkPage, $sort = "MetDate", $reverse = false)
{
// change these if Wordpress location changes
$base = "http://orders.thechapr.com/Admin";
$basepage = "?page_id=" . $_GET["page_id"];
$rows = dbGetCustomersSummary($sort, $reverse);
$list = "";
$list .= '<script>
// code taken from http://stackoverflow.com/questions/133925/javascript-post-request-like-a-form-submit
function post(path, params, method) {
method = method || "post"; // Set method to post by default if not specified.
var form = document.createElement("form");
form.setAttribute("method", method);
form.setAttribute("action", path);
for(var key in params) {
if(params.hasOwnProperty(key)) {
var hiddenField = document.createElement("input");
hiddenField.setAttribute("type", "hidden");
hiddenField.setAttribute("name", key);
hiddenField.setAttribute("value", params[key]);
form.appendChild(hiddenField);
}
}
document.body.appendChild(form);
form.submit();
}';
$list .= "\n function rowClick(cid) {\n window.location.href = \"{$linkPage}\" + \"&CID=\" + cid;\n }\n </script>";
$list .= "\n<table class=\"customerList\" frame=\"box\" style=\"width:95%;align:center\">\n <tr class=\"topline\">\n <td align=\"center\"><font size=\"-2\">" . sortHeader($basepage, "CID", "CID", $sort, $reverse) . "</td>\n <td align=\"center\"><font size=\"-2\">" . sortHeader($basepage, "OID", "OID", $sort, $reverse) . "</td>\n <td align=\"center\">" . sortHeader($basepage, "Met Date", "MetDate", $sort, $reverse) . "</td>\n <td align=\"center\">" . sortHeader($basepage, "Title", "Title", $sort, $reverse) . "</td>\n <td align=\"center\">" . sortHeader($basepage, "First Name", "FirstName", $sort, $reverse) . "</td>\n <td align=\"center\">" . sortHeader($basepage, "Last Name", "LastName", $sort, $reverse) . "</td>\n <td align=\"center\">" . sortHeader($basepage, "City", "City", $sort, $reverse) . "</td>\n <td align=\"center\">" . sortHeader($basepage, "State", "State", $sort, $reverse) . "</td>\n <td align=\"center\">" . sortHeader($basepage, "Country", "Country", $sort, $reverse) . "</td>\n <td align=\"center\">" . sortHeader($basepage, "Customer Notes", "CustomerCNotes", $sort, $reverse) . "</td>\n </tr>\n\n";
foreach ($rows as $row) {
$cid = $row["CID"];
$oid = "";
if ($row["OID"] != null) {
foreach ($row["OID"] as $r) {
foreach ($r as $i) {
$oid .= $i . " ";
}
}
}
$title = $row["Title"];
$firstName = $row["FirstName"];
$lastName = $row["LastName"];
$city = $row["City"];
$state = $row["State"];
$country = $row["Country"];
$customerCNotes = $row["CustomerCNotes"];
$metDate = date("m", $row["MetDate"]) . "/" . date("d", $row["MetDate"]) . "/" . date("y", $row["MetDate"]);
$list .= "<tr onclick=\"rowClick({$cid});\">";
$list .= "\n <td class='centered' align='center'> {$cid} </td>\n <td align='center'> {$oid} </td>\n <td align='center'> {$metDate} </td>\n <td> {$title} </td>\n <td> {$firstName} </td>\n <td> {$lastName} </td>\n <td align='center'> {$city} </td>\n <td align='center'> {$state} </td>\n <td align='center'> {$country} </td>\n <td align='center'> {$customerCNotes} </td>\n </tr>\n";
}
$list .= " \n\n</table>\n<div align=\"center\"><font size=\"-1\"><em>\nClick on a row to view or edit the customer.\n</em></font></div>\n";
print $list;
}
?>
"><?php
echo translate('TotalBrScore');
echo sortTag('TotScore');
?>
</a></th>
<th class="colAvgScore"><a href="<?php
echo sortHeader('AvgScore');
?>
"><?php
echo translate('AvgBrScore');
echo sortTag('AvgScore');
?>
</a></th>
<th class="colMaxScore"><a href="<?php
echo sortHeader('MaxScore');
?>
"><?php
echo translate('MaxBrScore');
echo sortTag('MaxScore');
?>
</a></th>
<?php
if (ZM_WEB_LIST_THUMBS) {
?>
<th class="colThumbnail"><?php
echo translate('Thumbnail');
?>
</th>
<?php
}
function viewOutreach()
{
global $user;
$UID = $user->uid;
$params = drupal_get_query_parameters();
$markup = "<script src=\"https://cdnjs.cloudflare.com/ajax/libs/jquery/3.0.0-beta1/jquery.js\"></script>";
$markup .= '<script src="numberCounting.js"></script>';
$markup .= '<h1>Outreach</h1><br>';
// if doing a custom search
if (isset($params['query']) && $params['query'] == 'search') {
$sql = generateSearchSQL($_SESSION['searchParams'], $_SESSION['proxyFields']);
$outreaches = dbSearchOutreach($sql, $_SESSION['proxyFields']);
$header = '<h2>Custom Search Results (';
$header .= empty($outreaches) ? '0' : count($outreaches);
$header .= ' matches)</h2>';
} else {
if (isset($params['tag'])) {
$_SESSION['searchParams'] = array('tags' => array($params['tag']));
$_SESSION['proxyFields'] = array();
$sql = generateSearchSQL($_SESSION['searchParams'], $_SESSION['proxyFields']);
$outreaches = dbSearchOutreach($sql, $_SESSION['proxyFields']);
$header = '<h2>Outreaches Tagged "' . dbGetTagName($params['tag']) . '"</h2>';
} else {
if (isset($params['owned'])) {
$outreaches = dbGetOwnedOutreachForUser($UID);
$header = '<h2>Outreaches I Own</h2>';
} else {
if (isset($params['signedUp'])) {
$outreaches = dbGetOutreachForUser($UID);
$header = '<h2>Outreaches I Am Signed Up For</h2>';
} else {
if (isset($params['allTeamOutreach'])) {
$TID = getCurrentTeam()['TID'];
$_SESSION['searchParams'] = array('TID' => array('value' => $TID, 'matchType' => 'exact'));
$_SESSION['proxyFields'] = array(':TID' => $TID);
$sql = generateSearchSQL($_SESSION['searchParams'], $_SESSION['proxyFields']);
$outreaches = dbSearchOutreach($sql, $_SESSION['proxyFields']);
$teamName = dbGetTeamName($TID);
$header = "<h2>All Outreach for {$teamName}</h2>";
} else {
$_SESSION['searchParams'] = array();
$_SESSION['proxyFields'] = array();
$header = "<h2>No Search Selected</h2>";
}
}
}
}
}
if (isset($_SESSION['searchParams']['teams']) && count($_SESSION['searchParams']['teams']) > 1) {
$multipleTeamsInResult = true;
} else {
$multipleTeamsInResult = false;
}
$markup .= $header;
// set $outreaches to an array rather than false (so that later functions don't have errors)
if (empty($outreaches)) {
$outreaches = array();
}
$totalFilterOutreaches = count($outreaches);
$totalFilterHours = 0;
foreach ($outreaches as &$outreach) {
$outreach['hours'] = dbGetHoursForOutreach($outreach['OID']);
$totalFilterHours += $outreach['hours'];
}
unset($outreach);
$sortParam = isset($params["sort"]) ? $params['sort'] : 'name';
$isAscending = isset($params['isAscending']) ? true : false;
orderByValue($outreaches, $sortParam, $isAscending);
// custom function (see helperFunctions.inc)
$markup .= '<table style="margin:0px">';
$markup .= '<tr><td style="padding:0px; text-align:left"><b>Outreaches with Current Filters: </b><span class="countUp">' . $totalFilterOutreaches . '</span></td>';
$markup .= '<td style="padding:0px; text-align:right" align="right"><b>Hours with Current Filters: </b><span class="countUp">' . $totalFilterHours . '</span></td></tr>';
$markup .= '<tr><td style="padding:0px" align="left">Sort By: ';
// remove special params (since they should not be added every time)
unset($params['isAscending']);
unset($params['sort']);
$markup .= sortHeader($sortParam, $params, $isAscending, 'Name', 'name', 'outreach') . ' | ';
$markup .= sortHeader($sortParam, $params, $isAscending, 'Status', 'status', 'outreach') . ' | ';
$markup .= sortHeader($sortParam, $params, $isAscending, 'Hours', 'hours', 'outreach') . ' | ';
$markup .= sortHeader($sortParam, $params, $isAscending, 'Event Date', 'eventDate', 'outreach');
$markup .= '</td><td style="padding:0px; text-align:right">';
if (!isset($params['owned'])) {
$markup .= '<a href="?q=outreach&owned"><div class="help tooltip4"><button>Owned</button><span id="helptext"; class="helptext tooltiptext4">Click here to sort by outreach you own.</span></div></a>';
} else {
$markup .= '<a href="?q=outreach&allTeamOutreach"><button>All Team Outreach</button></a>';
}
if (!isset($params['signedUp'])) {
$markup .= '<a href="?q=outreach&signedUp"><div class="help tooltip3"><button>Signed Up</button><span id="helptext"; class="helptext tooltiptext3">Click here to sort by outreach you are signed up for.</span></div></a>';
} else {
$markup .= '<a href="?q=outreach&allTeamOutreach"><button>All Team Outreach</button></a>';
}
$markup .= '</td></tr></table>';
$markup .= '<table class="infoTable" style="margin:0px"><tr><th colspan="2">Status</th>';
if ($multipleTeamsInResult) {
$markup .= '<th colspan="2">Team</th>';
}
$markup .= '<th colspan="4">Name</th>';
$markup .= '<th colspan="2">Hours</th>';
$markup .= '<th colspan="2">Event Date</th>';
if (empty($outreaches)) {
$markup .= '<tr><td colspan="11">No outreach found! Click <a href="?q=outreachForm">here</a> to create new outreach!</td></tr></table>';
return array('#markup' => $markup);
}
foreach ($outreaches as $outreach) {
$OID = $outreach['OID'];
$hours = dbGetHoursForOutreach($OID);
$status;
switch ($outreach['status']) {
case 'isOutreach':
$status = '<span title="Outreach Event"><img class="eventIndicatorIcon" src="/images/icons/outreachBlue.png"></span>';
break;
case 'isIdea':
$status = '<span title="Idea"><img class="eventIndicatorIcon" src="/images/icons/ideaBlue.png"></span>';
break;
case 'doingWriteUp':
$status = '<span title="Write Up"><img class="eventIndicatorIcon" src="/images/icons/writeUpBlue.png"></span>
';
break;
case 'locked':
$status = '<span title="Locked Event"><img class="eventIndicatorIcon" src="/images/icons/lockedBlue.png"></span>';
break;
default:
drupal_set_message('Invalid outreach data.');
break;
}
$markup .= '<tr><td colspan="2" style="padding: 0px 0px 0px 14px;">';
$markup .= showOutreachStatusIcon($outreach['status']) . '</td>';
if ($multipleTeamsInResult) {
$markup .= '<td colspan="2"><a href="?q=viewTeam&TID=' . $outreach['TID'] . '">' . dbGetTeamNumber($outreach['TID']) . '</a></td>';
}
$markup .= '<td colspan="4"><a href="?q=viewOutreach&OID=' . $OID . '">' . chopString($outreach['name'], 15) . '</a></td>';
$markup .= '<td colspan="2">' . $hours . '</td>';
if (dbGetEarliestTimeForOutreach($OID) != false) {
$markup .= '<td colspan="2">' . date(TIME_FORMAT, dbDateSQL2PHP(dbGetEarliestTimeForOutreach($OID))) . '</td>';
} else {
$markup .= '<td colspan="2">[none]</td>';
}
}
$markup .= '</table>';
return array('#markup' => $markup);
}
function populateListOrderSummary($linkPage, $sort = "OrderedDate", $reverse = false, $all = false)
{
$charityHeader = standardIcon("charity");
$toShipHeader = standardIcon("released");
$paidHeader = standardIcon("paid");
$expediteHeader = standardIcon("expedite");
$shippedHeader = standardIcon("shipped");
$invoiceHeader = standardIcon("invoice");
$checkedBox = standardIcon("checkedBox");
$unCheckedBox = standardIcon("box");
$basepage = "?page_id=" . $_GET["page_id"];
$rows = getOrdersSummary($sort, $reverse, $all);
$list = "<h3>Current Orders</h3>";
$list .= '<script>
// code taken from http://stackoverflow.com/questions/133925/javascript-post-request-like-a-form-submit
function post(path, params, method) {
method = method || "post"; // Set method to post by default if not specified.
var form = document.createElement("form");
form.setAttribute("method", method);
form.setAttribute("action", path);
for(var key in params) {
if(params.hasOwnProperty(key)) {
var hiddenField = document.createElement("input");
hiddenField.setAttribute("type", "hidden");
hiddenField.setAttribute("name", key);
hiddenField.setAttribute("value", params[key]);
form.appendChild(hiddenField);
}
}
document.body.appendChild(form);
form.submit();
}';
$list .= "\n function rowClick(oid) {\n// window.location.href = \"http://orders.thechapr.com/Admin/?page_id=89&oid=\" + oid;\n window.location.href = \"{$linkPage}\" + \"&oid=\" + oid;\n// post(\"http://orders.thechapr.com/Admin/?page_id=89\",\n// { email : \"eric@rothfus.com\",\n// fname : \"eric\"},\n// \"post\");\n }\n\n </script>";
$list .= "<table class=\"orderList\" frame=\"box\" style=\"width:99%;align:center\">";
$list .= showAllButton($basepage, $sort, $reverse, $all);
$list .= "\n <tr class=\"topline\">\n <td align=\"center\"><font size=\"-2\">" . sortHeader($basepage, "CID", "CID", $sort, $reverse, $all) . "</td>\n <td align=\"center\"><font size=\"-2\">" . sortHeader($basepage, "OID", "OID", $sort, $reverse, $all) . "</td>\n <td align=\"center\">" . sortHeader($basepage, "First Name", "FirstName", $sort, $reverse, $all) . "</td>\n <td align=\"center\">" . sortHeader($basepage, "Last Name", "LastName", $sort, $reverse, $all) . "</td>\n <td align=\"center\">" . sortHeader($basepage, "Ordered Date", "OrderedDate", $sort, $reverse, $all) . "</td>\n <td align=\"center\">" . sortHeader($basepage, "Items", "ItemCount", $sort, $reverse, $all) . "</td>\n <td align=\"center\">" . sortHeader($basepage, $expediteHeader, "IsExpedited", $sort, $reverse, $all) . "</td>\n <td align=\"center\">" . sortHeader($basepage, $charityHeader, "Charity", $sort, $reverse, $all) . "</td>\n <td align=\"center\">" . sortHeader($basepage, $invoiceHeader, "RequestedPay", $sort, $reverse, $all) . "</td>\n <td align=\"center\">" . sortHeader($basepage, $paidHeader, "PaidDate", $sort, $reverse, $all) . "</td>\n <td align=\"center\">" . sortHeader($basepage, $toShipHeader, "ReleasedToShipping", $sort, $reverse, $all) . "</td>\n <td align=\"center\">" . sortHeader($basepage, $shippedHeader, "ShippedDate", $sort, $reverse, $all) . "</td>\n <td align=\"center\"> Order Notes </td>\n </tr>\n\n";
// these are counters for the bottom of page reporting
// canceled orders are never counted in this list - but shipped are as detailed below
$totalItemCount = 0;
// total of all items in the current list
$totalCharityCount = 0;
// total of charity items in the current list (non charity = $totalItemCount - $totalCharityCount)
$totalItemsShipped = 0;
// total of SHIPPED items in the current list (only shown when shipped shown)
$totalCharityShipped = 0;
// total of charity shipped items in the current list (only shown when shipped shown)
foreach ($rows as $row) {
$canceled = $row["WasCanceled"];
$cid = $row["CID"];
$oid = $row["OID"];
$firstName = $row["FirstName"];
$lastName = $row["LastName"];
$orderDate = date("Y-M-d", $row["OrderedDate"]);
$itemCount = $row["itemCount"];
$paidDate = $row["PaidDate"];
$toShipDate = $row["ReleasedToShipping"];
$shippedDate = $row["ShippedDate"];
$isExpedited = $row["IsExpedited"];
$orderNotes = $row["CustomerONotes"];
if ($row["AdminONotes"]) {
$orderNotes .= " <em>(" . $row["AdminONotes"] . ")</em>";
}
$isCharity = $row["Charity"];
$isInvoice = $row["RequestedPay"];
// do the bottom of page item counts
if (!$canceled) {
$totalItemCount += $row["itemCount"];
if ($isCharity) {
$totalCharityCount += $row["itemCount"];
}
if ($shippedDate) {
$totalItemsShipped += $row["itemCount"];
}
if ($shippedDate && $isCharity) {
$totalCharityShipped += $row["itemCount"];
}
}
// the old way
$box = '☐';
/* Empty Box special Character */
$checked = '☑';
/* Check Box Special Character */
// new pretty way
$box = $unCheckedBox;
$checked = $checkedBox;
if ($isInvoice) {
$invoice = $checked;
if ($row["RequestedPayDays"] == 1) {
$invoiceTitle = $row["RequestedPayDays"] . " day ago";
} else {
if ($row["RequestedPayDays"] == 0) {
$invoiceTitle = "just today";
} else {
$invoiceTitle = $row["RequestedPayDays"] . " days ago";
}
}
} else {
$invoice = $box;
$invoiceTitle = "";
}
if ($paidDate == 0) {
$paid = $box;
} else {
$paid = $checked;
}
if ($toShipDate == 0) {
$released = $box;
} else {
$released = $checked;
}
if ($shippedDate == 0) {
$shipped = $box;
} else {
$shipped = $checked;
}
if ($isCharity) {
$charity = $checked;
} else {
$charity = $box;
}
if ($isExpedited) {
$expedited = $checked;
} else {
$expedited = $box;
}
$list .= "<tr onclick=\"rowClick({$oid});\"";
if ($canceled) {
$list .= " class=\"strikeout\"";
}
$list .= ">";
$list .= "\n\n <td class='centered' align='center'> {$cid} </td>\n <td align='center'> {$oid} </td>\n <td> {$firstName} </td>\n <td> {$lastName} </td>\n <td align='center'> {$orderDate} </td>\n <td align='center'> {$itemCount} </td>\n <td align='center'> {$expedited} </td>\n <td align='center'> {$charity} </td>\n <td align='center' title='{$invoiceTitle}'> {$invoice} </td>\n <td align='center'> {$paid} </td>\n <td align='center'> {$released} </td>\n <td align='center'> {$shipped} </td>\n <td> {$orderNotes} </td>\n </tr>\n\n";
}
// deal with a little link for showing ALL orders, or excluding shipped and canceled
$list .= showAllButton($basepage, $sort, $reverse, $all);
$list .= "\n</table>\n<div align=\"center\"><font size=\"-1\"><em>\nClick on a row to view, edit, or ship the order.\n</em></font></div><P>";
$list .= "<div align=\"center\"><font size=\"-1\"><em>";
$list .= "<table style=\"border:none;margin:0;padding:0\">";
$list .= "<tr style=\"border:none;margin:0;padding:0\">";
$list .= "<td style=\"border:none;text-align:center;margin:0;padding:0\">Total Items: {$totalItemCount}</td>";
$list .= "<td style=\"border:none;text-align:center;margin:0;padding:0\">Total Charity: {$totalCharityCount}</td>";
$list .= "<td style=\"border:none;text-align:center;margin:0;padding:0\">Total Non-Charity: " . ($totalItemCount - $totalCharityCount) . "</td>";
$list .= "</tr>";
if ($all) {
$list .= "<tr style=\"border:none\">";
$list .= "<td style=\"border:none;text-align:center;margin:0;padding:0\">Total Shipped Items: {$totalItemsShipped}</td>";
$list .= "<td style=\"border:none;text-align:center;margin:0;padding:0\">Total Shipped Charity: {$totalCharityShipped}</td>";
$list .= "<td style=\"border:none;text-align:center;margin:0;padding:0\">Total Shipped Non-Charity: " . ($totalItemsShipped - $totalCharityShipped) . "</td>";
$list .= "</tr>";
}
$list .= "</table></em></font></div>";
print $list;
}
function populateListPackagesSummary($linkPage, $sort = "PKID", $reverse = false, $all)
{
// change these if Wordpress location changes
$base = "http://orders.thechapr.com/Admin";
$basepage = "?page_id=" . $_GET["page_id"];
$rows = dbGetPackagesSummary($sort, $reverse, $all);
$list = "";
$list .= '<script>
// code taken from http://stackoverflow.com/questions/133925/javascript-post-request-like-a-form-submit
function post(path, params, method) {
method = method || "post"; // Set method to post by default if not specified.
var form = document.createElement("form");
form.setAttribute("method", method);
form.setAttribute("action", path);
for(var key in params) {
if(params.hasOwnProperty(key)) {
var hiddenField = document.createElement("input");
hiddenField.setAttribute("type", "hidden");
hiddenField.setAttribute("name", key);
hiddenField.setAttribute("value", params[key]);
form.appendChild(hiddenField);
}
}
document.body.appendChild(form);
form.submit();
}';
$list .= "\n function rowClick(PKID) {\n window.location.href = \"{$linkPage}\" + \"&PKID=\" + PKID;\n }\n </script>";
$list .= "\n<table class=\"packageList\" frame=\"box\" style=\"width:95%;align:center\">";
$list .= addNewButton($basepage, $sort, $reverse, $all);
$list .= showAllButton($basepage, $sort, $reverse, $all);
$list .= "\n <tr class=\"topline\">\n <td align=\"center\"><font size=\"-2\">" . sortHeader($basepage, "PKID", "PKID", $sort, $reverse, $all) . "</td>\n <td align=\"center\">" . sortHeader($basepage, "Package Name", "PackageName", $sort, $reverse, $all) . "</td>\n <td align=\"center\">" . sortHeader($basepage, "Price", "Price", $sort, $reverse, $all) . "</td>\n <td align=\"center\">" . sortHeader($basepage, "Active?", "Active", $sort, $reverse, $all) . "</td>\n </tr>\n\n";
foreach ($rows as $row) {
$PKID = $row["PKID"];
$name = $row["PackageName"];
$price = $row["Price"];
if ($row["Active"] == 1) {
$active = "YES";
} else {
$active = "NO";
}
$list .= "<tr onclick=\"rowClick({$PKID});\">";
$list .= "\n <td class='centered' align='center'> {$PKID} </td>\n <td align='center'> {$name} </td>\n <td align='center'> {$price} </td>\n <td align='center'> {$active} </td>\n </tr>\n ";
}
$list .= " \n\n</table>\n<div align=\"center\"><font size=\"-1\"><em>\nClick on a row to view or edit the package.\n</em></font></div>\n";
print $list;
}
?>
"><?php
echo substr($SLANG['Duration'], 0, 3);
echo sortTag('Length');
?>
</a></th>
<th class="colFrames"><a href="<?php
echo sortHeader('Frames', '&');
?>
"><?php
echo substr($SLANG['Frames'], 0, 3);
echo sortTag('Frames');
?>
</a></th>
<th class="colScore"><a href="<?php
echo sortHeader('TotScore', '&');
?>
"><?php
echo substr($SLANG['Score'], 0, 3);
echo sortTag('TotScore');
?>
</a></th>
</tr>
<?php
}
?>
<tr>
<td class="colId"><a href="?view=eventdetails&eid=<?php
echo $event['Id'];
?>
&page=1"><?php
