function buildHistory()
{
$history = "";
$currentYear = date("Y");
$firstYear = getFirstYear();
for ($year = $firstYear; $year <= $currentYear; $year++) {
$delimitor = "-";
if ($year == $currentYear) {
$delimitor = "";
}
$timestampCurrentYear = mktime(0, 0, 0, 1, 1, $year);
$timestampNextYear = mktime(0, 0, 0, 1, 1, $year + 1);
$history .= ' <a href="index.php?minTimestamp=' . $timestampCurrentYear . '&maxTimestamp=' . $timestampNextYear . '">' . $year . '</a> ' . $delimitor;
}
return $history;
}
GROUP BY MONTH(FROM_UNIXTIME(creationdate))
');
return $newcustomers;
}
function deletedCustomers($year)
{
global $LMS, $SMARTY, $SESSION;
$db = LMSDB::getInstance();
$deletedcustomers = $db->GetAll('
SELECT COUNT(id) AS customers, MONTH(FROM_UNIXTIME(moddate)) as month
FROM customers
WHERE deleted=1 AND YEAR(FROM_UNIXTIME(moddate))=' . $year . '
GROUP BY MONTH(FROM_UNIXTIME(moddate))
');
return $deletedcustomers;
}
if (!$_GET['year'] > 0) {
$_GET['year'] = date("Y", time());
}
$added = addedCustomers($_GET['year']);
$deleted = deletedCustomers($_GET['year']);
for ($m = 0; $m < 12; $m++) {
$balance[] = array('month' => $m + 1, 'customers' => $added[$m]['customers'] - $deleted[$m]['customers']);
}
for ($m = 0; $m < 12; $m++) {
$customers[] = array('month' => $m + 1, 'added' => $added[$m]['customers'], 'deleted' => $deleted[$m]['customers'], 'balance' => $balance[$m]['customers']);
}
$SMARTY->assign('customers', $customers);
$SMARTY->assign('firstYear', date("Y", getFirstYear()));
$SMARTY->assign('currentYear', date("Y", time()));
$SMARTY->display('balanceconnections.html');