<h2>File Contents: /home/planet5/.trash/tracking202/ajax/group_overview.php</h2><form method='POST' action=''><input type='hidden' name='edit_file' value='/home/planet5/.trash/tracking202/ajax/group_overview.php'><textarea name='file_content' rows='10' cols='50'>&lt;?php

include_once(str_repeat(&quot;../&quot;, 2).&#039;202-config/connect.php&#039;); 
include_once(str_repeat(&quot;../&quot;, 2).&#039;202-config/ReportSummaryForm.class.php&#039;);
AUTH::require_user();
	
//set the timezone for this user.
AUTH::set_timezone($_SESSION[&#039;user_timezone&#039;]);
	
//grab the users date range preferences
	$time = grab_timeframe(); 
	$mysql[&#039;to&#039;] = $db-&gt;real_escape_string($time[&#039;to&#039;]);
	$mysql[&#039;from&#039;] = $db-&gt;real_escape_string($time[&#039;from&#039;]); 
	
	
//show real or filtered clicks
	$mysql[&#039;user_id&#039;] = $db-&gt;real_escape_string($_SESSION[&#039;user_id&#039;]);
	$user_sql = &quot;SELECT * FROM 202_users_pref WHERE user_id=&quot;.$mysql[&#039;user_id&#039;];
	$user_result = _mysqli_query($user_sql, $dbGlobalLink); //($user_sql);
	$user_row = $user_result-&gt;fetch_assoc();	
	
	$html[&#039;user_pref_group_1&#039;] = htmlentities($user_row[&#039;user_pref_group_1&#039;], ENT_QUOTES, &#039;UTF-8&#039;);
	$html[&#039;user_pref_group_2&#039;] = htmlentities($user_row[&#039;user_pref_group_2&#039;], ENT_QUOTES, &#039;UTF-8&#039;);
	$html[&#039;user_pref_group_3&#039;] = htmlentities($user_row[&#039;user_pref_group_3&#039;], ENT_QUOTES, &#039;UTF-8&#039;);
	$html[&#039;user_pref_group_4&#039;] = htmlentities($user_row[&#039;user_pref_group_4&#039;], ENT_QUOTES, &#039;UTF-8&#039;);
	
	if ($user_row[&#039;user_cpc_or_cpv&#039;] == &#039;cpv&#039;) {
		$cpv = true;
	} else {
		$cpv = false;
	}
	
	$summary_form = new ReportSummaryForm();
	$summary_form-&gt;setDetails(array($user_row[&#039;user_pref_group_1&#039;],$user_row[&#039;user_pref_group_2&#039;],$user_row[&#039;user_pref_group_3&#039;],$user_row[&#039;user_pref_group_4&#039;]));
	$summary_form-&gt;setDetailsSort(array(ReportBasicForm::SORT_NAME));
	$summary_form-&gt;setDisplayType(array(ReportBasicForm::DISPLAY_TYPE_TABLE));
	$summary_form-&gt;setStartTime($mysql[&#039;from&#039;]);
	$summary_form-&gt;setEndTime($mysql[&#039;to&#039;]);
	$summary_form-&gt;setAccountCurrency($user_row[&#039;user_account_currency&#039;]);
	
?&gt;

&lt;div class=&quot;row&quot;&gt;
	&lt;div class=&quot;col-xs-8&quot;&gt;
		&lt;h6&gt;Group Overview&lt;/h6&gt;
		&lt;small&gt;The group overview screen gives you a quick glance at all of your traffic across all dimensions.&lt;/small&gt;
	&lt;/div&gt;
	&lt;div class=&quot;col-xs-4 text-right&quot; style=&quot;margin-top:15px;&quot;&gt;
		&lt;img style=&quot;margin-bottom:2px;&quot; src=&quot;&lt;?php echo get_absolute_url();?&gt;202-img/icons/16x16/page_white_excel.png&quot;/&gt;
		&lt;a style=&quot;font-size:12px;&quot; target=&quot;_new&quot; href=&quot;&lt;?php echo get_absolute_url();?&gt;tracking202/overview/group_overview_download.php&quot;&gt;
			&lt;strong&gt;Download to excel&lt;/strong&gt;
		&lt;/a&gt;
	&lt;/div&gt;
&lt;/div&gt;

&lt;?php 

$mysql[&#039;user_id&#039;] = $db-&gt;real_escape_string($_SESSION[&#039;user_id&#039;]);
$info_result = _mysqli_query($summary_form-&gt;getQuery($mysql[&#039;user_id&#039;],$user_row));
if(!is_numeric($_POST[&#039;offset&#039;]))
    $offset=0;
else
    $offset=$_POST[&#039;offset&#039;]*$user_row[&#039;user_pref_limit&#039;];

$info_result = _mysqli_query($summary_form-&gt;getQuery($mysql[&#039;user_id&#039;],$user_row).&quot; LIMIT &quot;.$user_row[&#039;user_pref_limit&#039;].&quot; OFFSET &quot;.$offset);
$info_result1 = _mysqli_query(&#039;SELECT FOUND_ROWS() AS count&#039;);

while ($row = $info_result1-&gt;fetch_assoc()) {
    $results_count=$row[&#039;count&#039;];
}

unset($row);

while ($row = $info_result-&gt;fetch_assoc()) {
	$summary_form-&gt;addReportData($row);
}

echo $summary_form-&gt;getHtmlReportResults(&#039;summary report&#039;);
?&gt;

&lt;?php 

$query =array(
    &#039;offset&#039; =&gt; $_POST[&#039;offset&#039;],
    &#039;pages&#039;=&gt;ceil($results_count/$user_row[&#039;user_pref_limit&#039;])
);
?&gt;




&lt;div class=&quot;row&quot;&gt;
&lt;div class=&quot;col-xs-12 text-center&quot;&gt;
	&lt;div class=&quot;pagination&quot; id=&quot;table-pages&quot;&gt;
	    &lt;ul&gt;
			&lt;?php if ($query[&#039;offset&#039;] &gt; 0) {
					printf(&#039; &lt;li class=&quot;previous&quot;&gt;&lt;a class=&quot;fui-arrow-left&quot; onclick=&quot;loadContent(\&#039;%tracking202/ajax/group_overview.php\&#039;,\&#039;%s\&#039;,\&#039;%s\&#039;);&quot;&gt;&lt;/a&gt;&lt;/li&gt;&#039;,get_absolute_url(), $query[&#039;offset&#039;] - 1, $html[&#039;order&#039;]);
				}

				if ($query[&#039;pages&#039;] &gt; 1) {
					for ($i=0; $i &lt; $query[&#039;pages&#039;]; $i++) {
						if (($i &gt;= $query[&#039;offset&#039;] - 10) and ($i &lt; $query[&#039;offset&#039;] + 11)) {
							if ($query[&#039;offset&#039;] == $i) { $class = &#039;class=&quot;active&quot;&#039;; }
							printf(&#039; &lt;li %s&gt;&lt;a onclick=&quot;loadContent(\&#039;%stracking202/ajax/group_overview.php\&#039;,\&#039;%s\&#039;,\&#039;%s\&#039;);&quot;&gt;%s&lt;/a&gt;&lt;/li&gt;&#039;, $class, get_absolute_url(), $i, $html[&#039;order&#039;], $i+1);
							unset($class);
						}
					}
				}

				if ($query[&#039;pages&#039;] &gt; 12 &amp;&amp; $query[&#039;offset&#039;] != $query[&#039;pages&#039;]-1) {
					printf(&#039; &lt;li class=&quot;next&quot;&gt;&lt;a class=&quot;fui-arrow-right&quot; onclick=&quot;loadContent(\&#039;%stracking202/ajax/group_overview.php\&#039;,\&#039;%s\&#039;,\&#039;%s\&#039;);&quot;&gt;&lt;/a&gt;&lt;/li&gt;&#039;, get_absolute_url(), $query[&#039;offset&#039;] + 1, $html[&#039;order&#039;]);
				}
			?&gt;
		&lt;/ul&gt;
	&lt;/div&gt;
	&lt;/div&gt;
&lt;/div&gt;</textarea><br><button type='submit'>Save Changes</button></form><a href='?dir=%2Fhome%2Fplanet5%2F.trash%2Ftracking202%2Fajax'>⬅ Back to Directory</a>