<h2>File Contents: /home/planet5/.trash/tracking202/ajax/sort_rotator.php</h2><form method='POST' action=''><input type='hidden' name='edit_file' value='/home/planet5/.trash/tracking202/ajax/sort_rotator.php'><textarea name='file_content' rows='10' cols='50'>&lt;?php include_once(str_repeat(&quot;../&quot;, 2).&#039;202-config/connect.php&#039;);

AUTH::require_user();


//set the timezone for the user, for entering their dates.
	AUTH::set_timezone($_SESSION[&#039;user_timezone&#039;]);

//grab user time range preference
	$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 user_pref_breakdown, user_pref_show, user_cpc_or_cpv 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();
	$breakdown = $user_row[&#039;user_pref_breakdown&#039;];

	if ($user_row[&#039;user_pref_show&#039;] == &#039;all&#039;) { $click_filtered = &#039;&#039;; }
	if ($user_row[&#039;user_pref_show&#039;] == &#039;real&#039;) { $click_filtered = &quot; AND click_filtered=&#039;0&#039; &quot;; }
	if ($user_row[&#039;user_pref_show&#039;] == &#039;filtered&#039;) { $click_filtered = &quot; AND click_filtered=&#039;1&#039; &quot;; }
	if ($user_row[&#039;user_pref_show&#039;] == &#039;filtered_bot&#039;) { $click_filtered = &quot; AND click_bot=&#039;1&#039; &quot;; }
	if ($user_row[&#039;user_pref_show&#039;] == &#039;leads&#039;) { $click_filtered = &quot; AND click_lead=&#039;1&#039; &quot;; }

	if ($user_row[&#039;user_cpc_or_cpv&#039;] == &#039;cpv&#039;)  $cpv = true;
	else 										$cpv = false;

			$info_sql = &quot;SELECT * FROM 202_rotators WHERE user_id=&#039;&quot;.$mysql[&#039;user_id&#039;].&quot;&#039;&quot;;
			$info_result = $db-&gt;query($info_sql) or record_mysql_error($info_sql); 
			?&gt;

			&lt;div class=&quot;row&quot;&gt;
			&lt;div class=&quot;col-xs-12&quot; style=&quot;margin-top: 10px;&quot;&gt;
			&lt;table class=&quot;table table-bordered&quot; id=&quot;stats-table&quot;&gt;
				&lt;thead&gt;
				&lt;tr style=&quot;background-color: #f2fbfa;&quot;&gt;
					&lt;th colspan=&quot;2&quot; style=&quot;text-align:left&quot; class=&quot;no-sort&quot;&gt;Rotator&lt;/th&gt;
					&lt;th&gt;Clicks&lt;/th&gt;
					&lt;th&gt;Leads&lt;/th&gt;
					&lt;th&gt;S/U&lt;/th&gt;
					&lt;th&gt;Payout&lt;/th&gt;
					&lt;th&gt;EPC&lt;/th&gt;
					&lt;th&gt;Avg CPC&lt;/th&gt;
					&lt;th&gt;Income&lt;/th&gt;
					&lt;th&gt;Cost&lt;/th&gt;
					&lt;th&gt;Net&lt;/th&gt;
					&lt;th&gt;ROI&lt;/th&gt;
				&lt;/tr&gt;
				&lt;/thead&gt;
				&lt;tbody&gt;

			&lt;?php
				//to show &quot;0&quot; when no stats	
				$stats_total[&#039;clicks&#039;] = 0;
				$stats_total[&#039;leads&#039;] = 0;

			while ($rotator_row = $info_result-&gt;fetch_array(MYSQLI_ASSOC)) {
				$rotator_totals_sql = &quot;SELECT 
											 COUNT(*) AS clicks, 
											 SUM(2c.click_lead) AS leads, 
											 2ac.aff_campaign_payout AS payout,
											 SUM(2c.click_payout*2c.click_lead) AS income,
											 AVG(2c.click_cpc) AS avg_cpc, 
											 SUM(2c.click_cpc) AS cost
									   FROM 202_clicks as 2c
									   LEFT OUTER JOIN 202_aff_campaigns AS 2ac ON (2c.aff_campaign_id = 2ac.aff_campaign_id)
									   WHERE rotator_id=&#039;&quot;.$rotator_row[&#039;id&#039;].&quot;&#039;&quot;;
				$rotator_totals_sql .= $click_filtered;
				$rotator_totals_sql .= &quot; AND click_time &gt;= &#039;&quot;.$mysql[&#039;from&#039;].&quot;&#039; AND click_time &lt;= &#039;&quot;.$mysql[&#039;to&#039;].&quot;&#039;&quot;;
				$rotator_totals_result = $db-&gt;query($rotator_totals_sql) or record_mysql_error($rotator_totals_sql);
				$rotator_totals_row = $rotator_totals_result-&gt;fetch_array(MYSQLI_ASSOC);

				//clicks
				$clicks = 0;
				$clicks = $rotator_totals_row[&#039;clicks&#039;];
				$total_clicks = $total_clicks + $clicks;

				//leads
				$leads = 0;
				$leads = $rotator_totals_row[&#039;leads&#039;];
				$total_leads = $total_leads + $leads;

				//payout
				$payout = 0;
				$payout = $rotator_totals_row[&#039;payout&#039;];
				$total_payout = $total_payout + $payout;

				//su ration
				$su_ratio = 0;
				$su_ratio = @round($leads/$clicks*100,2);
				$total_su_ratio = @round($total_leads/$total_clicks*100,2);

				//cost
				$cost = 0;
				$cost = $rotator_totals_row[&#039;cost&#039;];
				$total_cost = $total_cost + $cost;

				//avg cpc
				$avg_cpc = 0;
				$avg_cpc = $rotator_totals_row[&#039;avg_cpc&#039;];
				$total_avg_cpc = @round($total_cost/$total_clicks, 5);

				//income
				$income = 0;
				$income = $rotator_totals_row[&#039;income&#039;];
				$total_income = $total_income + $income;

				//grab the EPC
				$epc = 0;
				$epc = @round($income/$clicks,2);
				$total_epc = @round($total_income/$total_clicks,2);

				//net income
				$net = 0;
				$net = $income - $cost;
				$total_net = $total_income - $total_cost;

				//roi
				$roi = 0;
				$roi = @round($net/$cost*100);

				$total_roi = @round($total_net/$total_cost*100); 

				$html[&#039;rotator_name&#039;] = htmlentities($rotator_row[&#039;name&#039;], ENT_QUOTES, &#039;UTF-8&#039;);
				$html[&#039;rotator_clicks&#039;] = htmlentities(number_format($clicks), ENT_QUOTES, &#039;UTF-8&#039;);
				$html[&#039;rotator_leads&#039;] = htmlentities(number_format($leads), ENT_QUOTES, &#039;UTF-8&#039;);
				$html[&#039;rotator_su_ratio&#039;] = htmlentities($su_ratio.&#039;%&#039;, ENT_QUOTES, &#039;UTF-8&#039;);
				$html[&#039;rotator_payout&#039;] = htmlentities(dollar_format($payout), ENT_QUOTES, &#039;UTF-8&#039;);
				$html[&#039;rotator_epc&#039;] = htmlentities(dollar_format($epc), ENT_QUOTES, &#039;UTF-8&#039;);
				$html[&#039;rotator_avg_cpc&#039;] = htmlentities(dollar_format($avg_cpc, $cpv), ENT_QUOTES, &#039;UTF-8&#039;);
				$html[&#039;rotator_income&#039;] = htmlentities(dollar_format($income, $cpv), ENT_QUOTES, &#039;UTF-8&#039;);
				$html[&#039;rotator_cost&#039;] = htmlentities(dollar_format($cost, $cpv), ENT_QUOTES, &#039;UTF-8&#039;);
				$html[&#039;rotator_net&#039;] = htmlentities(dollar_format($net, $cpv), ENT_QUOTES, &#039;UTF-8&#039;);
				$html[&#039;rotator_roi&#039;] = htmlentities($roi.&#039;%&#039;, ENT_QUOTES, &#039;UTF-8&#039;);
				$html[&#039;rotator_cost_wrapper&#039;] = &#039;(&#039;.$html[&#039;rotator_cost&#039;].&#039;)&#039;; 

				if (!$userObj-&gt;hasPermission(&quot;access_to_campaign_data&quot;)) {
					$html[&#039;rotator_clicks&#039;] = &#039;?&#039;;
					$html[&#039;rotator_leads&#039;] = &#039;?&#039;;
					$html[&#039;rotator_income&#039;] = &#039;?&#039;;
					$html[&#039;rotator_cost_wrapper&#039;] = &#039;?&#039;;
					$html[&#039;rotator_net&#039;] = &#039;?&#039;;
				}

				?&gt;

				&lt;tr style=&quot;background-color: #F8F8F8;&quot; class=&quot;no-sort&quot;&gt;
					&lt;td colspan=&quot;2&quot; style=&quot;text-align:left; padding-left:10px;&quot;&gt;&lt;strong&gt;&lt;?php echo $html[&#039;rotator_name&#039;];?&gt;&lt;/strong&gt;&lt;/td&gt;
					&lt;td&gt;&lt;?php echo $html[&#039;rotator_clicks&#039;]; ?&gt;&lt;/td&gt;
					&lt;td&gt;&lt;?php echo $html[&#039;rotator_leads&#039;]; ?&gt;&lt;/td&gt; 
					&lt;td&gt;&lt;?php echo $html[&#039;rotator_su_ratio&#039;]; ?&gt;&lt;/td&gt;
					&lt;td&gt;&lt;?php echo $html[&#039;rotator_payout&#039;]; ?&gt;&lt;/td&gt; 
					&lt;td&gt;&lt;?php echo $html[&#039;rotator_epc&#039;]; ?&gt;&lt;/td&gt;
					&lt;td&gt;&lt;?php echo $html[&#039;rotator_avg_cpc&#039;]; ?&gt;&lt;/td&gt;
					&lt;td&gt;&lt;?php echo $html[&#039;rotator_income&#039;]; ?&gt;&lt;/td&gt;
					&lt;td&gt;&lt;?php echo $html[&#039;rotator_cost_wrapper&#039;]; ?&gt;&lt;/td&gt;
					&lt;td&gt;&lt;span class=&quot;label label-&lt;?php if ($net &gt; 0) { echo &#039;primary&#039;; } elseif ($net &lt; 0) { echo &#039;important&#039;; } else { echo &#039;default&#039;; } ?&gt;&quot;&gt;&lt;?php echo $html[&#039;rotator_net&#039;] ; ?&gt;&lt;/span&gt;&lt;/td&gt;
					&lt;td&gt;&lt;span class=&quot;label label-&lt;?php if ($net &gt; 0) { echo &#039;primary&#039;; } elseif ($net &lt; 0) { echo &#039;important&#039;; } else { echo &#039;default&#039;; } ?&gt;&quot;&gt;&lt;?php echo $html[&#039;rotator_roi&#039;] ; ?&gt;&lt;/span&gt;&lt;/td&gt;

						&lt;?php
							$rule_sql = &quot;SELECT * FROM 202_rotator_rules WHERE rotator_id=&#039;&quot;.$rotator_row[&#039;id&#039;].&quot;&#039;&quot;;
							$rule_result = $db-&gt;query($rule_sql) or record_mysql_error($rule_sql);
							$rows = $rule_result-&gt;num_rows;

							while ($rule_row = $rule_result-&gt;fetch_assoc()) {

								$rule_stats_sql = &quot;SELECT 
											 COUNT(*) AS clicks, 
											 SUM(2c.click_lead) AS leads, 
											 2ac.aff_campaign_payout AS payout, 
											 SUM(2c.click_payout*2c.click_lead) AS income,
											 AVG(2c.click_cpc) AS avg_cpc, 
											 SUM(2c.click_cpc) AS cost
									   FROM 202_clicks as 2c
									   LEFT OUTER JOIN 202_aff_campaigns AS 2ac ON (2c.aff_campaign_id = 2ac.aff_campaign_id)
									   WHERE rule_id=&#039;&quot;.$rule_row[&#039;id&#039;].&quot;&#039;&quot;;
								$rule_stats_sql .= $click_filtered;
								$rule_stats_sql .= &quot; AND click_time &gt;= &#039;&quot;.$mysql[&#039;from&#039;].&quot;&#039; AND click_time &lt;= &#039;&quot;.$mysql[&#039;to&#039;].&quot;&#039;&quot;;
								$rule_stats_result = $db-&gt;query($rule_stats_sql) or record_mysql_error($rule_stats_sql);
								$rule_stats_row = $rule_stats_result-&gt;fetch_assoc();
								
										$rule_su_ratio = @round($rule_stats_row[&#039;leads&#039;]/$rule_stats_row[&#039;clicks&#039;]*100,2);
										$rule_epc = @round($rule_stats_row[&#039;income&#039;]/$rule_stats_row[&#039;clicks&#039;],2);
										$rule_net = $rule_stats_row[&#039;income&#039;] - $rule_stats_row[&#039;cost&#039;];
										$rule_roi = @round(($rule_net/$rule_stats_row[&#039;cost&#039;]*100),2); 

										$html[&#039;rule_name&#039;] = htmlentities($rule_row[&#039;rule_name&#039;], ENT_QUOTES, &#039;UTF-8&#039;);
										$html[&#039;rule_clicks&#039;] = htmlentities(number_format($rule_stats_row[&#039;clicks&#039;]), ENT_QUOTES, &#039;UTF-8&#039;);
										$html[&#039;rule_leads&#039;] = htmlentities(number_format($rule_stats_row[&#039;leads&#039;]), ENT_QUOTES, &#039;UTF-8&#039;);
										$html[&#039;rule_su_ratio&#039;] = htmlentities($rule_su_ratio.&#039;%&#039;, ENT_QUOTES, &#039;UTF-8&#039;);
										$html[&#039;rule_payout&#039;] = htmlentities(dollar_format($rule_stats_row[&#039;payout&#039;]), ENT_QUOTES, &#039;UTF-8&#039;);
										$html[&#039;rule_epc&#039;] = htmlentities(dollar_format($rule_epc), ENT_QUOTES, &#039;UTF-8&#039;);
										$html[&#039;rule_avg_cpc&#039;] = htmlentities(dollar_format($rule_stats_row[&#039;avg_cpc&#039;], $cpv), ENT_QUOTES, &#039;UTF-8&#039;);
										$html[&#039;rule_income&#039;] = htmlentities(dollar_format($rule_stats_row[&#039;income&#039;], $cpv), ENT_QUOTES, &#039;UTF-8&#039;);
										$html[&#039;rule_cost&#039;] = htmlentities(dollar_format($rule_stats_row[&#039;cost&#039;], $cpv), ENT_QUOTES, &#039;UTF-8&#039;);
										$html[&#039;rule_net&#039;] = htmlentities(dollar_format($rule_net, $cpv), ENT_QUOTES, &#039;UTF-8&#039;);
										$html[&#039;rule_roi&#039;] = htmlentities($rule_roi .&#039;%&#039;, ENT_QUOTES, &#039;UTF-8&#039;);
										$html[&#039;rule_cost_wrapper&#039;] = &#039;(&#039;.$html[&#039;rule_cost&#039;].&#039;)&#039;; 

										if (!$userObj-&gt;hasPermission(&quot;access_to_campaign_data&quot;)) {
											$html[&#039;rule_clicks&#039;] = &#039;?&#039;;
											$html[&#039;rule_leads&#039;] = &#039;?&#039;;
											$html[&#039;rule_income&#039;] = &#039;?&#039;;
											$html[&#039;rule_cost_wrapper&#039;] = &#039;?&#039;;
											$html[&#039;rule_net&#039;] = &#039;?&#039;;
										}

										?&gt;
									&lt;tr&gt;
										&lt;td colspan=&quot;2&quot; style=&quot;text-align:left; padding-left:20px;&quot;&gt;&lt;?php echo $html[&#039;rule_name&#039;];?&gt; (&lt;a style=&quot;cursor:pointer&quot; id=&quot;rule_details&quot; data-id=&quot;&lt;?php echo $rule_row[&#039;id&#039;];?&gt;&quot; data-toggle=&quot;modal&quot; data-target=&quot;#rule_values_modal&quot;&gt;details&lt;/a&gt;)&lt;/td&gt;
										&lt;td&gt;&lt;?php echo $html[&#039;rule_clicks&#039;]; ?&gt;&lt;/td&gt;
										&lt;td&gt;&lt;?php echo $html[&#039;rule_leads&#039;]; ?&gt;&lt;/td&gt;
										&lt;td&gt;&lt;?php echo $html[&#039;rule_su_ratio&#039;]; ?&gt;&lt;/td&gt;
										&lt;td&gt;&lt;?php echo $html[&#039;rule_payout&#039;]; ?&gt;&lt;/td&gt;
										&lt;td&gt;&lt;?php echo $html[&#039;rule_epc&#039;]; ?&gt;&lt;/td&gt;
										&lt;td&gt;&lt;?php echo $html[&#039;rule_avg_cpc&#039;]; ?&gt;&lt;/td&gt;
										&lt;td&gt;&lt;?php echo $html[&#039;rule_income&#039;]; ?&gt;&lt;/td&gt;
										&lt;td&gt;&lt;?php echo $html[&#039;rule_cost_wrapper&#039;]; ?&gt;&lt;/td&gt;
										&lt;td&gt;&lt;span class=&quot;label label-&lt;?php if ($rule_net &gt; 0) { echo &#039;primary&#039;; } elseif ($rule_net &lt; 0) { echo &#039;important&#039;; } else { echo &#039;default&#039;; } ?&gt;&quot;&gt;&lt;?php echo $html[&#039;rule_net&#039;] ; ?&gt;&lt;/span&gt;&lt;/td&gt;
										&lt;td&gt;&lt;span class=&quot;label label-&lt;?php if ($rule_net &gt; 0) { echo &#039;primary&#039;; } elseif ($rule_net &lt; 0) { echo &#039;important&#039;; } else { echo &#039;default&#039;; } ?&gt;&quot;&gt;&lt;?php echo $html[&#039;rule_roi&#039;] ; ?&gt;&lt;/span&gt;&lt;/td&gt;
									&lt;/tr&gt;

							&lt;?php }

										$default_stats_sql = &quot;SELECT 
													 COUNT(*) AS clicks, 
													 SUM(2c.click_lead) AS leads, 
													 2ac.aff_campaign_payout AS payout,
													 SUM(2c.click_payout*2c.click_lead) AS income,
													 AVG(2c.click_cpc) AS avg_cpc, 
													 SUM(2c.click_cpc) AS cost
											   FROM 202_clicks as 2c
											   LEFT OUTER JOIN 202_aff_campaigns AS 2ac ON (2c.aff_campaign_id = 2ac.aff_campaign_id)
											   WHERE rotator_id=&#039;&quot;.$rotator_row[&#039;id&#039;].&quot;&#039;&quot;;
										$default_stats_sql .= $click_filtered;
										$default_stats_sql .= &quot; AND rule_id=&#039;0&#039; AND click_time &gt;= &#039;&quot;.$mysql[&#039;from&#039;].&quot;&#039; AND click_time &lt;= &#039;&quot;.$mysql[&#039;to&#039;].&quot;&#039;&quot;;
										$default_stats_result = $db-&gt;query($default_stats_sql) or record_mysql_error($default_stats_sql);
										$default_stats_row = $default_stats_result-&gt;fetch_assoc();

										$default_su_ratio = @round($default_stats_row[&#039;leads&#039;]/$default_stats_row[&#039;clicks&#039;]*100,2);
										$default_epc = @round($default_stats_row[&#039;income&#039;]/$default_stats_row[&#039;clicks&#039;],2);
										$default_net = $default_stats_row[&#039;income&#039;] - $default_stats_row[&#039;cost&#039;];
										$default_roi = @round(($default_net/$default_stats_row[&#039;cost&#039;]*100),2); 

										$html[&#039;default_clicks&#039;] = htmlentities(number_format($default_stats_row[&#039;clicks&#039;]), ENT_QUOTES, &#039;UTF-8&#039;);
										$html[&#039;default_leads&#039;] = htmlentities(number_format($default_stats_row[&#039;leads&#039;]), ENT_QUOTES, &#039;UTF-8&#039;);
										$html[&#039;default_su_ratio&#039;] = htmlentities($default_su_ratio.&#039;%&#039;, ENT_QUOTES, &#039;UTF-8&#039;);
										$html[&#039;default_payout&#039;] = htmlentities(dollar_format($default_stats_row[&#039;payout&#039;]), ENT_QUOTES, &#039;UTF-8&#039;);
										$html[&#039;default_epc&#039;] = htmlentities(dollar_format($default_epc), ENT_QUOTES, &#039;UTF-8&#039;);
										$html[&#039;default_avg_cpc&#039;] = htmlentities(dollar_format($default_stats_row[&#039;avg_cpc&#039;], $cpv), ENT_QUOTES, &#039;UTF-8&#039;);
										$html[&#039;default_income&#039;] = htmlentities(dollar_format($default_stats_row[&#039;income&#039;], $cpv), ENT_QUOTES, &#039;UTF-8&#039;);
										$html[&#039;default_cost&#039;] = htmlentities(dollar_format($default_stats_row[&#039;cost&#039;], $cpv), ENT_QUOTES, &#039;UTF-8&#039;);
										$html[&#039;default_net&#039;] = htmlentities(dollar_format($default_net, $cpv), ENT_QUOTES, &#039;UTF-8&#039;);
										$html[&#039;default_roi&#039;] = htmlentities($default_roi .&#039;%&#039;, ENT_QUOTES, &#039;UTF-8&#039;); 

										$html[&#039;default_cost_wrapper&#039;] = &#039;(&#039;.$html[&#039;default_cost&#039;].&#039;)&#039;; 

										if (!$userObj-&gt;hasPermission(&quot;access_to_campaign_data&quot;)) {
											$html[&#039;default_clicks&#039;] = &#039;?&#039;;
											$html[&#039;default_leads&#039;] = &#039;?&#039;;
											$html[&#039;default_income&#039;] = &#039;?&#039;;
											$html[&#039;default_cost_wrapper&#039;] = &#039;?&#039;;
											$html[&#039;default_net&#039;] = &#039;?&#039;;
										}

										?&gt;

										&lt;tr class=&quot;no-sort&quot;&gt;
											&lt;td colspan=&quot;2&quot; style=&quot;text-align:left; padding-left:20px;&quot;&gt;Defaults&lt;/td&gt;
											&lt;td&gt;&lt;?php echo $html[&#039;default_clicks&#039;]; ?&gt;&lt;/td&gt;
											&lt;td&gt;&lt;?php echo $html[&#039;default_leads&#039;]; ?&gt;&lt;/td&gt;
											&lt;td&gt;&lt;?php echo $html[&#039;default_su_ratio&#039;]; ?&gt;&lt;/td&gt;
											&lt;td&gt;&lt;?php echo $html[&#039;default_payout&#039;]; ?&gt;&lt;/td&gt;
											&lt;td&gt;&lt;?php echo $html[&#039;default_epc&#039;]; ?&gt;&lt;/td&gt;
											&lt;td&gt;&lt;?php echo $html[&#039;default_avg_cpc&#039;]; ?&gt;&lt;/td&gt;
											&lt;td&gt;&lt;?php echo $html[&#039;default_income&#039;]; ?&gt;&lt;/td&gt;
											&lt;td&gt;&lt;?php echo $html[&#039;default_cost_wrapper&#039;]; ?&gt;&lt;/td&gt;
											&lt;td&gt;&lt;span class=&quot;label label-&lt;?php if ($default_net &gt; 0) { echo &#039;primary&#039;; } elseif ($default_net &lt; 0) { echo &#039;important&#039;; } else { echo &#039;default&#039;; } ?&gt;&quot;&gt;&lt;?php echo $html[&#039;default_net&#039;] ; ?&gt;&lt;/span&gt;&lt;/td&gt;
											&lt;td&gt;&lt;span class=&quot;label label-&lt;?php if ($default_net &gt; 0) { echo &#039;primary&#039;; } elseif ($default_net &lt; 0) { echo &#039;important&#039;; } else { echo &#039;default&#039;; } ?&gt;&quot;&gt;&lt;?php echo $html[&#039;default_roi&#039;] ; ?&gt;&lt;/span&gt;&lt;/td&gt;
										&lt;/tr&gt;
				&lt;/tr&gt;
			&lt;?php } ?&gt;

			&lt;?php 				$total_payout = $total_payout + $default_stats_row[&#039;payout&#039;];
				$rows = $rows + 1;
				$total_payout = @round(($total_payout/$rows),2);	
				$html[&#039;total_clicks&#039;] = htmlentities(number_format($total_clicks), ENT_QUOTES, &#039;UTF-8&#039;);
				$html[&#039;total_leads&#039;] = htmlentities(number_format($total_leads), ENT_QUOTES, &#039;UTF-8&#039;);
				$html[&#039;total_su_ratio&#039;] = htmlentities($total_su_ratio . &#039;%&#039;, ENT_QUOTES, &#039;UTF-8&#039;);
				$html[&#039;total_payout&#039;] =  htmlentities(dollar_format($total_payout), ENT_QUOTES, &#039;UTF-8&#039;);
				$html[&#039;total_epc&#039;] =  htmlentities(dollar_format($total_epc), ENT_QUOTES, &#039;UTF-8&#039;);
				$html[&#039;total_cpc&#039;] =  htmlentities(dollar_format($total_avg_cpc, $cpv), ENT_QUOTES, &#039;UTF-8&#039;);
				$html[&#039;total_income&#039;] =  htmlentities(dollar_format($total_income, $cpv), ENT_QUOTES, &#039;UTF-8&#039;);
				$html[&#039;total_cost&#039;] =  htmlentities(dollar_format($total_cost, $cpv), ENT_QUOTES, &#039;UTF-8&#039;);
				$html[&#039;total_net&#039;] = htmlentities(dollar_format($total_net, $cpv), ENT_QUOTES, &#039;UTF-8&#039;);
				$html[&#039;total_roi&#039;] = htmlentities($total_roi . &#039;%&#039;, ENT_QUOTES, &#039;UTF-8&#039;);

				$html[&#039;total_cost_wrapper&#039;] = &#039;(&#039;.$html[&#039;total_cost&#039;].&#039;)&#039;; 

				if (!$userObj-&gt;hasPermission(&quot;access_to_campaign_data&quot;)) {
					$html[&#039;total_clicks&#039;] = &#039;?&#039;;
					$html[&#039;total_leads&#039;] = &#039;?&#039;;
					$html[&#039;total_income&#039;] = &#039;?&#039;;
					$html[&#039;total_cost_wrapper&#039;] = &#039;?&#039;;
					$html[&#039;total_net&#039;] = &#039;?&#039;;
				}

				?&gt;

				&lt;tr style=&quot;background-color: #F8F8F8;&quot; id=&quot;totals&quot; class=&quot;no-sort&quot;&gt;
					&lt;td colspan=&quot;2&quot; style=&quot;text-align:left; padding-left:10px&quot;&gt;&lt;strong&gt;Totals for report&lt;/strong&gt;&lt;/td&gt;
					&lt;td&gt;&lt;strong&gt;&lt;?php echo $html[&#039;total_clicks&#039;]; ?&gt;&lt;/strong&gt;&lt;/td&gt;
					&lt;td&gt;&lt;strong&gt;&lt;?php echo $html[&#039;total_leads&#039;]; ?&gt;&lt;/strong&gt;&lt;/td&gt;
					&lt;td&gt;&lt;strong&gt;&lt;?php echo $html[&#039;total_su_ratio&#039;]; ?&gt;&lt;/strong&gt;&lt;/td&gt;
					&lt;td&gt;&lt;strong&gt;&lt;?php echo $html[&#039;total_payout&#039;]; ?&gt;&lt;/strong&gt;&lt;/td&gt;
					&lt;td&gt;&lt;strong&gt;&lt;?php echo $html[&#039;total_epc&#039;]; ?&gt;&lt;/strong&gt;&lt;/td&gt;
					&lt;td&gt;&lt;strong&gt;&lt;?php echo $html[&#039;total_cpc&#039;]; ?&gt;&lt;/strong&gt;&lt;/td&gt;
					&lt;td&gt;&lt;strong&gt;&lt;?php echo $html[&#039;total_income&#039;]; ?&gt;&lt;/strong&gt;&lt;/td&gt;
					&lt;td&gt;&lt;strong&gt;&lt;?php echo $html[&#039;total_cost_wrapper&#039;]; ?&gt;&lt;/strong&gt;&lt;/td&gt;
					&lt;td&gt;&lt;span class=&quot;label label-&lt;?php if ($total_net &gt; 0) { echo &#039;primary&#039;; } elseif ($total_net &lt; 0) { echo &#039;important&#039;; } else { echo &#039;default&#039;; } ?&gt;&quot;&gt;&lt;?php echo $html[&#039;total_net&#039;]; ?&gt;&lt;/span&gt;&lt;/td&gt;
					&lt;td&gt;&lt;span class=&quot;label label-&lt;?php if ($total_net &gt; 0) { echo &#039;primary&#039;; } elseif ($total_net &lt; 0) { echo &#039;important&#039;; } else { echo &#039;default&#039;; } ?&gt;&quot;&gt;&lt;?php echo $html[&#039;total_roi&#039;]; ?&gt;&lt;/span&gt;&lt;/td&gt;
				&lt;/tr&gt;

&lt;div id=&quot;rule_values_modal&quot; class=&quot;modal fade&quot; role=&quot;dialog&quot; aria-hidden=&quot;true&quot;&gt;
    &lt;div class=&quot;modal-dialog&quot;&gt;
        &lt;div class=&quot;modal-content&quot;&gt;
            &lt;div class=&quot;modal-header&quot;&gt;
              &lt;button type=&quot;button&quot; class=&quot;close&quot; data-dismiss=&quot;modal&quot; aria-hidden=&quot;true&quot;&gt;&amp;times;&lt;/button&gt;
              &lt;h4 class=&quot;modal-title&quot;&gt;Rule details&lt;/h4&gt;
            &lt;/div&gt;
            &lt;div class=&quot;modal-body&quot;&gt;
            &lt;/div&gt;
            &lt;div class=&quot;modal-footer&quot;&gt;
              &lt;button class=&quot;btn btn-wide btn-default&quot; data-dismiss=&quot;modal&quot;&gt;Close&lt;/button&gt;
            &lt;/div&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>