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;
}