<?php

	ob_start();

	require(dirname(__FILE__) . '/../../includes/config.inc.php');
	require(dirname(__FILE__) . '/../includes/templates.php');
	require(dirname(__FILE__) . '/../includes/auth.inc.php');
	require(dirname(__FILE__) . '/general.php');

	$SSID = (isset($_GET['SSID'])) ? $_GET['SSID'] : '';
	$AdminID = (isset($_GET['AdminID'])) ? $_GET['AdminID'] : 0;

	$Admin = load_user($AdminID);

	$CURRENTADMIN = $Admin;

	$yesterday = mktime(23, 59, 59, date("m"), date("d")-1, date("Y"));
	$lastWeek = mktime(0, 0, 0, date("m"), date("d")-7, date("Y"));
	$lastMonth = mktime(0, 0, 0, date("m")-1, date("d"), date("Y"));
	$lastYear = mktime(0, 0, 0, date("m"), date("d"), date("Y")-1);

	$yesterday = mktime(0, 0, 0, date("m"), date("d")-1, date("Y"));

	// we need to go back to the start of the week for LastWeek.
	$today = date('w'); // 0 = sunday, 6 = sat
	$thisWeek = mktime(0, 0, 0, date('m'), date('d')-$today, date('Y'));

	// last month is from the start of this month..
	$thisMonth = mktime(0, 0, 0, date('m'), 1, date("Y"));

	// last year is from the start of this year - 1/1/xxxx
	$thisYear = mktime(0, 0, 0, 1, 1, date("Y"));

	OutputPageHeader(false, false, true);

	if ($CURRENTADMIN['Manager'] == 1) {
		$totalSubs_query = "SELECT COUNT(*) FROM " . $TABLEPREFIX . "members";
		$totalLists_query = "SELECT COUNT(*) FROM " . $TABLEPREFIX . "lists";
		$newToday_query = "SELECT COUNT(*) FROM " . $TABLEPREFIX . "members WHERE SubscribeDate > '".addslashes($yesterday)."'";
		$newWeek_query = "SELECT COUNT(*) FROM " . $TABLEPREFIX . "members WHERE SubscribeDate > '".addslashes($thisWeek)."'";
		$newMonth_query = "SELECT COUNT(*) FROM " . $TABLEPREFIX . "members WHERE SubscribeDate > '".addslashes($thisMonth)."'";
		$newYear_query = "SELECT COUNT(*) FROM " . $TABLEPREFIX . "members WHERE SubscribeDate > '".addslashes($thisYear)."'";
	}
	if ($CURRENTADMIN['Manager'] != 1) {

		$totalLists = 0;
		$lResult = mysql_query("SELECT * FROM " . $TABLEPREFIX . "lists");

		$list_check = array();

		while($lRow = mysql_fetch_assoc($lResult))
		{
			$lRow = stripslashes_array($lRow);
			if(AllowList($lRow['ListID']))
			{
				$list_check[] = $lRow['ListID'];
			}
		}

		if (sizeof($list_check) <= 0) {
			$list_check = array('0');
		}
		$list_ids = implode(',', $list_check);

		$totalLists_query = "SELECT COUNT(*) FROM " . $TABLEPREFIX . "lists WHERE ListID IN (" . $list_ids . ")";

		$totalSubs_query = "SELECT COUNT(*) FROM " . $TABLEPREFIX . "members WHERE ListID IN (" . $list_ids . ")";

		$newToday_query = "SELECT COUNT(*) FROM " . $TABLEPREFIX . "members WHERE ListID IN (" . $list_ids . ") AND SubscribeDate > '".addslashes($yesterday)."'";

		$newWeek_query = "SELECT COUNT(*) FROM " . $TABLEPREFIX . "members WHERE ListID IN (" . $list_ids . ") AND SubscribeDate > '".addslashes($thisWeek)."'";

		$newMonth_query = "SELECT COUNT(*) FROM " . $TABLEPREFIX . "members WHERE ListID IN (" . $list_ids . ") AND SubscribeDate > '".addslashes($thisMonth)."'";

		$newYear_query = "SELECT COUNT(*) FROM " . $TABLEPREFIX . "members WHERE ListID IN (" . $list_ids . ") AND SubscribeDate > '".addslashes($thisYear)."'";
	}

	switch($_GET['View']) {
		case 'TotalSubs':
			$report_title = 'Total subscribers';
			$report = number_format(mysql_result(mysql_query($totalSubs_query), 0, 0), 0);
		break;
		case 'TotalLists':
			$report_title = 'Total mailing lists';
			$report = number_format(mysql_result(mysql_query($totalLists_query), 0, 0), 0);
		break;
		case 'TotalToday':
			$report_title = 'New subscribers today';
			$report = number_format(mysql_result(mysql_query($newToday_query), 0, 0), 0);
		break;
		case 'TotalWeek':
			$report_title = 'New subscribers this week';
			$report = number_format(mysql_result(mysql_query($newWeek_query), 0, 0), 0);
		break;
		case 'TotalMonth':
			$report_title = 'New subscribers this month';
			$report = number_format(mysql_result(mysql_query($newMonth_query), 0, 0), 0);
		break;
		case 'TotalYear':
			$report_title = 'New subscribers this year';
			$report = number_format(mysql_result(mysql_query($newYear_query), 0, 0), 0);
		break;
	}
?>
		<table width="95%" border="0" cellspacing="0" cellpadding="0">
			<tr>
				<td valign="top" align="right" colspan="2">
					<a href="javascript:window.close()" class="topLink">[x] Close</a>
				</td>
			</tr>
			<tr>
				<td style='padding: 8px 20px 0px 20px;' valign="top">
					<?php echo $report_title; ?>: <?php echo $report; ?>
				</td>
			</tr>
		</table>
<?php
	OutputPageFooter(false);
?>