public function buildUsers()
{
/**
* Build a list of users.
*
* This builds a list of users with options to perform changes to their account.
*
* @author Mark O'Russa <*****@*****.**>
*
* @return boolean Returns a list of users with pagination, otherwise throws a customException.
*/
global $debug, $message, $Dbc;
try {
$output = '';
//Get the user count.
$userCountStmt = $Dbc->query("SELECT\n\tcount(userId) AS 'count'\nFROM\n\tusers");
$row = $userCountStmt->fetch(PDO::FETCH_ASSOC);
$itemCount = $row['count'];
//Get the pagination info.
$pagination = new Adrlist_Pagination('buildUsers', 'buildUsers', $itemCount, 'Search Users');
list($offset, $limit) = $pagination->offsetLimit();
//Get the users.
$usersStmt = $Dbc->prepare("SELECT\n\tuserId AS 'userId',\n\tprimaryEmail AS 'primaryEmail',\n\tsecondaryEmail AS 'secondaryEmail',\n\tfirstName AS 'firstName',\n\tlastName AS 'lastName',\n\tdateAdded AS 'dateAdded'\nFROM\n\tusers\nLIMIT " . $offset . ', ' . $limit);
$usersStmt->execute();
$userRows = array();
while ($row = $usersStmt->fetch(PDO::FETCH_ASSOC)) {
$userRows[] = array($row['userId'], '<span class="blue bold">P:</span> ' . $row['primaryEmail'] . '<br><span class="blue bold">S:</span> ' . $row['secondaryEmail'], '<span class="blue bold">F:</span> ' . $row['firstName'] . '<br><span class="blue bold">L:</span> ' . $row['lastName'], $row['dateAdded']);
}
$pagination->setParameters($itemCount, $offset, $limit, 'buildUsers');
$titleArray = array('userId', 'Email', 'Name', 'Date Added');
$cssWidths = array('3em', '18em', '10em', '8em');
$buildRows = new Adrlist_BuildRows($titleArray, $userRows, $cssWidths);
$pagination = $pagination->output();
return $pagination['paginationTop'] . $buildRows->outputTitleRow() . $buildRows->outputRows() . $pagination['paginationBottom'];
} catch (Adrlist_CustomException $e) {
} catch (PDOException $e) {
error(__LINE__, '', '<pre class="red">' . $e . '</pre>');
}
}
function buildDailyDigest()
{
/*
Returns error logs for the day.
All times are UTC.
*/
global $debug, $message, $success, $errorDbc, $returnThis;
$output = '';
try {
$midnight = strtotime('-1 day', mktime(0, 0, 0));
$startDate = isset($_POST['startDate']) ? $_POST['startDate'] : date('Y-m-d H:i:s', $midnight);
$endDate = isset($_POST['endDate']) ? $_POST['endDate'] : date('Y-m-d H:i:s', $midnight + 86399);
$params = array($startDate, $endDate);
//$time = new Adrlist_MeasureTime('countStmt');
$countStmt = $errorDbc->prepare("SELECT COUNT(errorId) AS 'count' FROM errorReporting WHERE errorDatetime BETWEEN ? AND ?");
$countStmt->execute($params);
$row = $countStmt->fetch(PDO::FETCH_ASSOC);
//$debug->add($time->output());
$itemCount = $row['count'];
$pagination = new Adrlist_Pagination('buildDailyDigest', 'dailyDigest', $itemCount);
$offsetLimit = $pagination->offsetLimit();
list($offset, $limit) = $offsetLimit;
$dailyDigestStmt = "SELECT\n\terrorId AS 'errorId',\n\terrorDatetime AS 'datetime',\n\tserverName AS 'serverName',\n\thttpHost AS 'httpHost',\n\thttpResponseStatusCode AS 'httpResponseStatusCode',\n\tuserAgent AS 'userAgent',\n\trequestUri AS 'requestUri',\n\tremoteAddress AS 'remoteAddress',\n\thttpReferrer AS 'httpReferrer',\n\tdebug AS 'debug'\nFROM\n\terrorReporting\nWHERE\n\tdatetime BETWEEN ? AND ?\nORDER BY\n\tserverName,httpHost,errorDatetime\nLIMIT " . $offset . ', ' . $limit;
//Get all of the items for statistics.
$debug->add($dailyDigestStmt);
$debug->printArray($params, '$params');
$dailyDigestStatsStmt = $errorDbc->prepare($dailyDigestStmt);
//$time = new Adrlist_MeasureTime('dailyDigestStatsStmt');
$dailyDigestStatsStmt->execute($params);
//$debug->add($time->output());
//General Statistics like how many errors per domain.
$errors = array();
$serverNameArray = array();
$sucker = 0;
/*
array(
* 0 => array(
* Name,
* Date,
* etc
* ),
* 1 => array(
* Name,
* Date,
* etc
* )
* )
*/
while ($row = $dailyDigestStatsStmt->fetch(PDO::FETCH_ASSOC)) {
}
//Get just the server names to count them.
$serverNamesStmt = $errorDbc->prepare("SELECT\n\tserverName AS 'serverName'\nFROM\n\terrorReporting\nWHERE\n\terrorDatetime BETWEEN ? AND ?");
$serverNamesStmt->execute($params);
while ($row = $serverNamesStmt->fetch(PDO::FETCH_ASSOC)) {
if (!array_key_exists($row['serverName'], $serverNameArray)) {
$serverNameArray[$row['serverName']] = 0;
}
$serverNameArray[$row['serverName']] = $serverNameArray[$row['serverName']] + 1;
}
$debug->printArray(array($serverNameArray), '$serverNameArray');
$newServerNameArray = array();
foreach ($serverNameArray as $key => $value) {
$newServerNameArray[] = array($key, $value);
}
$generalStatsTitleRow = array('Server Name', '# of Records');
$generalStatsCssWidths = array(20, 5);
$generalStatsBuildRows = new Adrlist_BuildRows($generalStatsTitleRow, $newServerNameArray, $generalStatsCssWidths);
$generalStats = '<div class="bold textCenter textLarge" style="margin-top:2em">General Statistics</div>
' . $generalStatsBuildRows->output();
$dailyDigestStmt = $errorDbc->prepare($dailyDigestStmt);
$dailyDigestStmt->execute(array($startDate, $endDate));
//$pagination = new BuildPagination($itemCount,$offset,$limit,'dailyDigest');
//$pagination->setPagesNumbersToDisplay(25);
//$pagination = $pagination->output();
//Column widths in em.
$widthDatetime = 8;
$widthServerName = '18';
$widthHttpHost = 18;
$widthHttpResponse = 8;
$widthUserAgent = 15;
$widthRequestUri = 18;
$widthRemoteAddress = 8;
$widthHttpReferrer = 20;
$widthDebug = 8;
$cssWidths = array(2, 8, 18, 18, 8, 15, 18, 8, 20, 8);
$titleRow = array('', 'Datetime', 'Server Name', 'Http Host', 'HTTP Response Status Code', 'User Agent', 'Request URI', 'Remote Address', 'Http Referrer');
$pagination = $pagination->output();
$buildRows = new Adrlist_BuildRows($titleRow, '', $cssWidths);
$table = $buildRows->outputTitleRow();
$class = 'rowAlt';
$x = $offset + 1;
while ($row = $dailyDigestStmt->fetch(PDO::FETCH_ASSOC)) {
if ($class == 'rowWhite') {
$class = 'rowAlt';
} else {
$class = 'rowWhite';
}
$table .= '<div class="hand ' . $class . ' clear relative" style="overflow:hidden" id="errorTrigger' . $row['errorId'] . '" errorId="' . $row['errorId'] . '">
<div class="row">' . $x . '</div>
<div class="row" style="width:' . $widthDatetime . 'em;">' . $row['datetime'] . '</div>
<div class="row" style="width:' . $widthServerName . 'em;">' . $row['serverName'] . '</div>
<div class="row" style="width:' . $widthHttpHost . 'em;">
<span id="httpHostShortShowHide' . $row['errorId'] . '">' . shortenText($row['httpHost'], $widthHttpHost, false, true, true) . '</span>
<span class="hide" id="HttpHostLongShowHide' . $row['errorId'] . '">' . $row['httpHost'] . '</span>
</div>
<div class="row" style="width:' . $widthHttpResponse . 'em;">' . $row['httpResponseStatusCode'] . '</div>
<div class="row" style="width:' . $widthUserAgent . 'em;">
<span id="userAgentShortShowHide' . $row['errorId'] . '">' . shortenText($row['userAgent'], $widthUserAgent, false, true, true) . '</span>
<span class="hide" id="userAgentLongShowHide' . $row['errorId'] . '">' . $row['userAgent'] . '</span>
</div>
<div class="row" style="width:' . $widthRequestUri . 'em;">
<span id="requestUriShortShowHide' . $row['errorId'] . '">' . shortenText($row['requestUri'], $widthRequestUri, false, true, true) . '</span>
<span class="hide" id="requestUriLongShowHide' . $row['errorId'] . '">' . urldecode($row['requestUri']) . '</span>
</div>
<div class="row" style="width:' . $widthRemoteAddress . 'em;">' . $row['remoteAddress'] . '</div>
<div class="row" style="width:' . $widthHttpReferrer . 'em;">
<span id="httpReferrerShortShowHide' . $row['errorId'] . '">' . shortenText($row['httpReferrer'], $widthHttpReferrer, false, true, true) . '</span>
<span class="hide" id="httpReferrerLongShowHide' . $row['errorId'] . '">' . $row['httpReferrer'] . '</span>
</div>
<div class="break hide textLeft" id="debugShowHide' . $row['errorId'] . '">' . $row['debug'] . '</div>
</div>
';
$x++;
}
$output .= 'Showing <input type="text" id="startDate" value="' . $startDate . '"> to <input type="text" id="endDate" value="' . $endDate . '"> <span class="buttonBlueThin" id="dateRangeGo">Go</span>' . $generalStats . '<div class="hr3"></div><div class="bold textCenter textLarge" style="margin-top:1em">Errors</div>' . $pagination . $table . $pagination;
if (MODE == 'buildDailyDigest') {
$success = true;
$returnThis['output'] = $output;
$returnThis['container'] = 'dailyDigestHolder';
}
} catch (PDOException $e) {
error(__LINE__, '', '<pre>' . $e . '</pre>');
}
if (MODE == 'buildDailyDigest') {
returnData();
} else {
return $output;
}
}
function buildUsers()
{
global $debug, $message, $success, $Dbc, $returnThis;
try {
$output = '';
//Get the user count.
$userCountStmt = $Dbc->query("SELECT\n\tcount(userId) AS 'count'\nFROM\n\tusers");
$row = $userCountStmt->fetch(PDO::FETCH_ASSOC);
$itemCount = $row['count'];
//Get the pagination info.
$pagination = new Adrlist_Pagination();
$offsetLimit = $pagination->getOffsetLimit($_SESSION['userId'], $_SERVER['SCRIPT_NAME'], 'buildUsers');
if (isset($_POST['offset'])) {
$offset = $_POST['offset'];
$pagination->setOffset($_SESSION['userId'], $_SERVER['SCRIPT_NAME'], 'buildUsers', $offset);
} else {
$offset = $offsetLimit[0];
}
$offset = $offset > $itemCount ? 0 : $offset;
//When changing list viewing options the offset may be larger than the count.
if (isset($_POST['limit'])) {
$limit = $_POST['limit'];
$pagination->setLimit($_SESSION['userId'], $_SERVER['SCRIPT_NAME'], 'buildUsers', $limit);
$offset = 0;
//We must reset the offset when changing the limit.
} else {
$limit = $offsetLimit[1];
}
//Get the users.
$usersStmt = $Dbc->prepare("SELECT\n\tuserId AS 'userId',\n\tprimaryEmail AS 'primaryEmail',\n\tsecondaryEmail AS 'secondaryEmail',\n\tfirstName AS 'firstName',\n\tlastName AS 'lastName',\n\tdateAdded AS 'dateAdded'\nFROM\n\tusers\nLIMIT " . $offset . ', ' . $limit);
$usersStmt->execute();
$userRows = array();
while ($row = $usersStmt->fetch(PDO::FETCH_ASSOC)) {
$userRows[] = array($row['userId'], '<span class="blue bold">P:</span> ' . $row['primaryEmail'] . '<br><span class="blue bold">S:</span> ' . $row['secondaryEmail'], '<span class="blue bold">F:</span> ' . $row['firstName'] . '<br><span class="blue bold">L:</span> ' . $row['lastName'], $row['dateAdded']);
}
$pagination->setParameters($itemCount, $offset, $limit, 'buildUsers');
$titleArray = array('userId', 'Email', 'Name', 'Date Added');
$cssWidths = array('3em', '18em', '10em', '8em');
$buildRows = new Adrlist_BuildRows($titleArray, $userRows, $cssWidths);
$pagination = $pagination->output();
$output .= $pagination['paginationTop'] . $buildRows->outputTitleRow() . $buildRows->outputRows() . $pagination['paginationBottom'];
} catch (Adrlist_CustomException $e) {
} catch (PDOException $e) {
error(__LINE__, '', $debug->printArray($e) . '<pre class="red">' . $e . '</pre>');
}
if (MODE == 'buildUsers') {
$success = true;
$returnThis['output'] = $output;
$returnThis['container'] = 'buildUsersHolder';
returnData();
} else {
return $output;
}
}
