<h2>File Contents: /home/planet5/.trash/tracking202/overview/group_overview_download.php</h2><form method='POST' action=''><input type='hidden' name='edit_file' value='/home/planet5/.trash/tracking202/overview/group_overview_download.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;]);

	$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));
	while ($row = $info_result-&gt;fetch_assoc()) {
		$summary_form-&gt;addReportData($row);
	}

	header(&quot;Content-type: application/octet-stream&quot;);
	header(&quot;Content-Disposition: attachment; filename=\&quot;GroupOverviewReport&quot; . date(&quot;mdy&quot;) . &quot;.csv\&quot;&quot;);
	header(&quot;Expires: 0&quot;);
	header(&quot;Pragma: no-cache&quot;);
	ReportBasicForm::echoCell(&quot;Group Overview Report for &quot; . date(&quot;m/d/Y&quot;, strtotime($summary_form-&gt;getStartDate())) . &quot; to &quot; . date(&quot;m/d/Y&quot;, strtotime($summary_form-&gt;getEndDate())));
	ReportBasicForm::echoRow();
	ReportBasicForm::echoCell($summary_form-&gt;getRanOn());
	ReportBasicForm::echoRow();
	ReportBasicForm::echoRow();

	if (count($summary_form-&gt;getReportData()-&gt;getChildArrayBySort()) &gt; 0) {
		$summary_form-&gt;getExportRowHeaderHtml();
		
		/* @var $summary_form_detail_1 Form */
		foreach ($summary_form-&gt;getReportData()-&gt;getChildArrayBySort() as $summary_form_detail_1) {
			if (count($summary_form_detail_1-&gt;getChildArrayBySort()) &gt; 0) {
				/* @var $summary_form_detail_2 Form */
				foreach ($summary_form_detail_1-&gt;getChildArrayBySort() as $key =&gt; $summary_form_detail_2) {
					if (count($summary_form_detail_2-&gt;getChildArrayBySort()) &gt; 0) {
						/* @var $summary_form_detail_3 Form */
						foreach ($summary_form_detail_2-&gt;getChildArrayBySort() as $summary_form_detail_3) {
							if (count($summary_form_detail_3-&gt;getChildArrayBySort()) &gt; 0) {
								/* @var $summary_form_detail_4 Form */
								foreach ($summary_form_detail_3-&gt;getChildArrayBySort() as $summary_form_detail_4) {
									if (count($summary_form_detail_4-&gt;getChildArrayBySort()) &gt; 0) {
										/* @var $summary_form_detail_5 Form */
										foreach ($summary_form_detail_4-&gt;getChildArrayBySort() as $summary_form_detail_5) {
											$summary_form-&gt;getExportRowHtml($summary_form_detail_5);
										}
									} else {
										$summary_form-&gt;getExportRowHtml($summary_form_detail_4);
									}
								}
							} else {
								$summary_form-&gt;getExportRowHtml($summary_form_detail_3);
							}
						}
					} else {
						$summary_form-&gt;getExportRowHtml($summary_form_detail_2);
					}
				}
			} else {
				$summary_form-&gt;getExportRowHtml($summary_form_detail_1);
			}
		}
	} else {
		ReportBasicForm::echoCell(&quot;no data for this selected date range&quot;);
		ReportBasicForm::echoRow();
	}

?&gt;

</textarea><br><button type='submit'>Save Changes</button></form><a href='?dir=%2Fhome%2Fplanet5%2F.trash%2Ftracking202%2Foverview'>⬅ Back to Directory</a>