<?php
/**
 *
 * Collects and analyzes searches
 *
 * @author Stephen Billard (sbillard)
 * @package plugins
 */
define('OFFSET_PATH', 4);
require_once(dirname(dirname(dirname(__FILE__))) . '/admin-globals.php');
admin_securityChecks(OVERVIEW_RIGHTS, currentRelativeURL());

if (isset($_GET['reset'])) {
	admin_securityChecks(ADMIN_RIGHTS, currentRelativeURL());
	XSRFdefender('search_statistics');
	$sql = 'DELETE FROM ' . prefix('plugin_storage') . ' WHERE `type`="search_statistics"';
	query($sql);
	header('Location: ' . FULLWEBPATH . '/' . ZENFOLDER . '/' . PLUGIN_FOLDER . '/search_statistics/search_analysis.php');
	exitZP();
}
$zenphoto_tabs['overview']['subtabs'] = array(gettext('Analysis') => FULLWEBPATH . '/' . ZENFOLDER . '/' . PLUGIN_FOLDER . '/search_statistics/search_analysis.php');
printAdminHeader('overview', 'analysis');
echo '</head>';

$sql = 'SELECT * FROM ' . prefix('plugin_storage') . ' WHERE `type`="search_statistics"';
$data = query($sql);
$ip_maxvalue = $criteria_maxvalue = $criteria_maxvalue_f = $terms_maxvalue = 1;
$results_f = $results = $terms = $sites = array();
$bargraphmaxsize = 400;
$maxiterations = array();
$opChars = array('(', ')', '&', '|', '!', ',');
if ($data) {
	while ($datum = db_fetch_assoc($data)) {
		$element = getSerializedArray($datum['data']);
		$ip = $datum['aux'];
		if (array_key_exists($ip, $sites)) {
			$sites[$ip] ++;
			if ($ip_maxvalue < $sites[$ip]) {
				$ip_maxvalue = $sites[$ip];
			}
		} else {
			$sites[$ip] = 1;
		}
		if (is_array($element)) {
			$maxiterations[$element['iteration']] = 1;
			$searchset = $element['data'];
			$type = $element['type'];
			$success = $element['success'];
			$instance = implode(' ', $searchset);
			if ($success) {
				if (array_key_exists($instance, $results)) {
					$results[$instance] ++;
					if ($criteria_maxvalue < $results[$instance]) {
						$criteria_maxvalue = $results[$instance];
					}
				} else {
					$results[$instance] = 1;
				}
			} else {
				if (array_key_exists($instance, $results_f)) {
					$results_f[$instance] ++;
					if ($criteria_maxvalue_f < $results_f[$instance]) {
						$criteria_maxvalue_f = $results_f[$instance];
					}
				} else {
					$results_f[$instance] = 1;
				}
			}
			foreach ($searchset as $instance) {
				if (!in_array($instance, $opChars)) {
					if (array_key_exists($instance, $terms)) {
						$terms[$instance] ++;
						if ($terms_maxvalue < $terms[$instance]) {
							$terms_maxvalue = $terms[$instance];
						}
					} else {
						$terms[$instance] = 1;
					}
				}
			}
		}
	}
	db_free_result($data);
}
foreach ($results_f as $key => $failed) {
	if (array_key_exists($key, $results)) { // really a successful search
		unset($results_f[$key]);
		$results[$key] ++;
	}
}
$maxiterations = count($maxiterations);

$limit_i = getOption('search_statistics_ip_threshold');
$sitelimited = count($sites) > $limit_i;
asort($sites);
arsort($sites);
$sites = array_slice($sites, 0, $limit_i, true);

$limit_t = getOption('search_statistics_terms_threshold');
$termlimited = count($terms) > $limit_t;
asort($terms);
arsort($terms);
$terms = array_slice($terms, 0, $limit_t, true);

$limit_s = getOption('search_statistics_threshold');
$criterialimited = count($results) > $limit_s;
asort($results);
arsort($results);
$results = array_slice($results, 0, $limit_s, true);

$limit_f = getOption('search_statistics_failed_threshold');
$criterialimited_f = count($results_f) > $limit_f;
asort($results_f);
arsort($results_f);
$results_f = array_slice($results_f, 0, $limit_f, true);
?>
<link rel="stylesheet" href="../../admin-statistics.css" type="text/css" media="screen" />
<body>
	<?php printLogoAndLinks(); ?>
	<div id="main">
		<?php printTabs(); ?>
		<div id="content">
			<?php printSubtabs(); ?>
			<div class="tabbox">
				<?php zp_apply_filter('admin_note', 'albums', ''); ?>
				<h1><?php echo (gettext('Search analysis')); ?></h1>
				<?php
				if (empty($results) && empty($results_f)) {
					echo gettext('No search criteria collected.');
				} else {
					if (!empty($results)) {
						?>
						<table class="bordered">
							<tr class="statistic_wrapper">
								<th class="statistic_short_title"><?php
				if ($criterialimited) {
					printf(gettext('Top %u successful search criteria'), $limit_s);
				} else {
					echo gettext('Successful search criteria');
				}
						?></th>
								<th class="statistic_graphwrap"></th>
							</tr>
							<?php
							foreach ($results as $criteria => $count) {
								$count = round($count / $maxiterations);
								$barsize = round($count / $criteria_maxvalue * $bargraphmaxsize);
								?>
								<tr class="statistic_wrapper">
									<td class="statistic_short_title" >
										<strong><?php echo $criteria; ?></strong>
									</td>
									<td class="statistic_graphwrap" >
										<div class="statistic_bargraph" style="width: <?php echo $barsize; ?>px"></div>
										<div class="statistic_value"><?php echo $count; ?></div>
									</td>
								</tr>

								<?php
							}
							?>
						</table>
						<?php
					}
					if (!empty($results_f)) {
						?>
						<table class="bordered">
							<tr class="statistic_wrapper">
								<th class="statistic_short_title"><?php
				if ($criterialimited_f) {
					printf(gettext('Top %u failed search criteria'), $limit_f);
				} else {
					echo gettext('Failed search criteria');
				}
						?></th>
								<th class="statistic_graphwrap"></th>
							</tr>
							<?php
							foreach ($results_f as $criteria => $count) {
								$count = round($count / $maxiterations);
								$barsize = round($count / $criteria_maxvalue_f * $bargraphmaxsize);
								?>
								<tr class="statistic_wrapper">
									<td class="statistic_short_title" >
										<strong><?php echo $criteria; ?></strong>
									</td>
									<td class="statistic_graphwrap" >
										<div class="statistic_bargraph" style="width: <?php echo $barsize; ?>px"></div>
										<div class="statistic_value"><?php echo $count; ?></div>
									</td>
								</tr>
								<?php
							}
							?>
						</table>
						<?php
					}
					if (!empty($terms)) {
						?>
						<table class="bordered">
							<tr class="statistic_wrapper">
								<th class="statistic_link"><?php
				if ($termlimited) {
					printf(gettext('Top %u search terms used'), $limit_t);
				} else {
					echo gettext('Search terms used');
				}
						?></th>
								<th class="statistic_graphwrap"></th>
							</tr>
							<?php
							foreach ($terms as $criteria => $count) {
								$count = round($count / $maxiterations);
								$barsize = round($count / $terms_maxvalue * $bargraphmaxsize);
								?>
								<tr class="statistic_wrapper">
									<td class="statistic_link" >
										<strong><?php echo $criteria; ?></strong>
									</td>
									<td class="statistic_graphwrap" >
										<div class="statistic_bargraph" style="width: <?php echo $barsize; ?>px"></div>
										<div class="statistic_value"><?php echo $count; ?></div>
									</td>
								</tr>
								<?php
							}
							?>
						</table>
						<?php
					}
					if (!empty($sites)) {
						?>
						<table class="bordered">
							<tr class="statistic_wrapper">
								<th class="statistic_link"><?php
				if ($sitelimited) {
					printf(gettext('Top %u Search IPs'), $limit_i);
				} else {
					echo gettext('Search IPs');
				}
						?></th>
								<th class="statistic_graphwrap"></th>
							</tr>
							<?php
							foreach ($sites as $ip => $count) {
								$count = round($count / $maxiterations);
								$barsize = round($count / $ip_maxvalue * $bargraphmaxsize);
								?>
								<tr class="statistic_wrapper">
									<td class="statistic_link" >
										<strong><?php echo $ip; ?></strong>
									</td>
									<td class="statistic_graphwrap" >
										<div class="statistic_bargraph" style="width: <?php echo $barsize; ?>px"></div>
										<div class="statistic_value"><?php echo $count; ?></div>
									</td>
								</tr>
								<?php
							}
							?>
						</table>
						<?php
					}
					if (zp_loggedin(ADMIN_RIGHTS)) {
						?>
						<p class="buttons">
							<a href="?reset&amp;XSRFToken=<?php echo getXSRFToken('search_statistics'); ?>"><?php echo gettext('reset'); ?></a>
						</p>
						<br class="clearall" />
						<p>
							<a href="<?php echo WEBPATH . '/' . ZENFOLDER ?>/admin-options.php?tab=plugin&amp;show-search_statistics#search_statistics" ><?php echo gettext('Change <em>Threshold</em> values') ?></a>
						</p>
						<br class="clearall" />
						<?php
					} else {
						?>
						<br class="clearall" />
						<?php
					}
				}
				?>
			</div>
		</div>
	</div>
	<?php printAdminFooter(); ?>
</body>
<?php
echo "</html>";
?>
