fetch_array(MYSQLI_ASSOC)) { $rotator_totals_sql = "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='".$rotator_row['id']."'"; $rotator_totals_sql .= $click_filtered; $rotator_totals_sql .= " AND click_time >= '".$mysql['from']."' AND click_time <= '".$mysql['to']."'"; $rotator_totals_result = $db->query($rotator_totals_sql) or record_mysql_error($rotator_totals_sql); $rotator_totals_row = $rotator_totals_result->fetch_array(MYSQLI_ASSOC); //clicks $clicks = 0; $clicks = $rotator_totals_row['clicks']; $total_clicks = $total_clicks + $clicks; //leads $leads = 0; $leads = $rotator_totals_row['leads']; $total_leads = $total_leads + $leads; //payout $payout = 0; $payout = $rotator_totals_row['payout']; $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['cost']; $total_cost = $total_cost + $cost; //avg cpc $avg_cpc = 0; $avg_cpc = $rotator_totals_row['avg_cpc']; $total_avg_cpc = @round($total_cost/$total_clicks, 5); //income $income = 0; $income = $rotator_totals_row['income']; $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['rotator_name'] = htmlentities($rotator_row['name'], ENT_QUOTES, 'UTF-8'); $html['rotator_clicks'] = htmlentities(number_format($clicks), ENT_QUOTES, 'UTF-8'); $html['rotator_leads'] = htmlentities(number_format($leads), ENT_QUOTES, 'UTF-8'); $html['rotator_su_ratio'] = htmlentities($su_ratio.'%', ENT_QUOTES, 'UTF-8'); $html['rotator_payout'] = htmlentities(dollar_format($payout), ENT_QUOTES, 'UTF-8'); $html['rotator_epc'] = htmlentities(dollar_format($epc), ENT_QUOTES, 'UTF-8'); $html['rotator_avg_cpc'] = htmlentities(dollar_format($avg_cpc, $cpv), ENT_QUOTES, 'UTF-8'); $html['rotator_income'] = htmlentities(dollar_format($income, $cpv), ENT_QUOTES, 'UTF-8'); $html['rotator_cost'] = htmlentities(dollar_format($cost, $cpv), ENT_QUOTES, 'UTF-8'); $html['rotator_net'] = htmlentities(dollar_format($net, $cpv), ENT_QUOTES, 'UTF-8'); $html['rotator_roi'] = htmlentities($roi.'%', ENT_QUOTES, 'UTF-8'); $html['rotator_cost_wrapper'] = '('.$html['rotator_cost'].')'; if (!$userObj->hasPermission("access_to_campaign_data")) { $html['rotator_clicks'] = '?'; $html['rotator_leads'] = '?'; $html['rotator_income'] = '?'; $html['rotator_cost_wrapper'] = '?'; $html['rotator_net'] = '?'; } ?> query($rule_sql) or record_mysql_error($rule_sql); $rows = $rule_result->num_rows; while ($rule_row = $rule_result->fetch_assoc()) { $rule_stats_sql = "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='".$rule_row['id']."'"; $rule_stats_sql .= $click_filtered; $rule_stats_sql .= " AND click_time >= '".$mysql['from']."' AND click_time <= '".$mysql['to']."'"; $rule_stats_result = $db->query($rule_stats_sql) or record_mysql_error($rule_stats_sql); $rule_stats_row = $rule_stats_result->fetch_assoc(); $rule_su_ratio = @round($rule_stats_row['leads']/$rule_stats_row['clicks']*100,2); $rule_epc = @round($rule_stats_row['income']/$rule_stats_row['clicks'],2); $rule_net = $rule_stats_row['income'] - $rule_stats_row['cost']; $rule_roi = @round(($rule_net/$rule_stats_row['cost']*100),2); $html['rule_name'] = htmlentities($rule_row['rule_name'], ENT_QUOTES, 'UTF-8'); $html['rule_clicks'] = htmlentities(number_format($rule_stats_row['clicks']), ENT_QUOTES, 'UTF-8'); $html['rule_leads'] = htmlentities(number_format($rule_stats_row['leads']), ENT_QUOTES, 'UTF-8'); $html['rule_su_ratio'] = htmlentities($rule_su_ratio.'%', ENT_QUOTES, 'UTF-8'); $html['rule_payout'] = htmlentities(dollar_format($rule_stats_row['payout']), ENT_QUOTES, 'UTF-8'); $html['rule_epc'] = htmlentities(dollar_format($rule_epc), ENT_QUOTES, 'UTF-8'); $html['rule_avg_cpc'] = htmlentities(dollar_format($rule_stats_row['avg_cpc'], $cpv), ENT_QUOTES, 'UTF-8'); $html['rule_income'] = htmlentities(dollar_format($rule_stats_row['income'], $cpv), ENT_QUOTES, 'UTF-8'); $html['rule_cost'] = htmlentities(dollar_format($rule_stats_row['cost'], $cpv), ENT_QUOTES, 'UTF-8'); $html['rule_net'] = htmlentities(dollar_format($rule_net, $cpv), ENT_QUOTES, 'UTF-8'); $html['rule_roi'] = htmlentities($rule_roi .'%', ENT_QUOTES, 'UTF-8'); $html['rule_cost_wrapper'] = '('.$html['rule_cost'].')'; if (!$userObj->hasPermission("access_to_campaign_data")) { $html['rule_clicks'] = '?'; $html['rule_leads'] = '?'; $html['rule_income'] = '?'; $html['rule_cost_wrapper'] = '?'; $html['rule_net'] = '?'; } ?> = '".$mysql['from']."' AND click_time <= '".$mysql['to']."'"; $default_stats_result = $db->query($default_stats_sql) or record_mysql_error($default_stats_sql); $default_stats_row = $default_stats_result->fetch_assoc(); $default_su_ratio = @round($default_stats_row['leads']/$default_stats_row['clicks']*100,2); $default_epc = @round($default_stats_row['income']/$default_stats_row['clicks'],2); $default_net = $default_stats_row['income'] - $default_stats_row['cost']; $default_roi = @round(($default_net/$default_stats_row['cost']*100),2); $html['default_clicks'] = htmlentities(number_format($default_stats_row['clicks']), ENT_QUOTES, 'UTF-8'); $html['default_leads'] = htmlentities(number_format($default_stats_row['leads']), ENT_QUOTES, 'UTF-8'); $html['default_su_ratio'] = htmlentities($default_su_ratio.'%', ENT_QUOTES, 'UTF-8'); $html['default_payout'] = htmlentities(dollar_format($default_stats_row['payout']), ENT_QUOTES, 'UTF-8'); $html['default_epc'] = htmlentities(dollar_format($default_epc), ENT_QUOTES, 'UTF-8'); $html['default_avg_cpc'] = htmlentities(dollar_format($default_stats_row['avg_cpc'], $cpv), ENT_QUOTES, 'UTF-8'); $html['default_income'] = htmlentities(dollar_format($default_stats_row['income'], $cpv), ENT_QUOTES, 'UTF-8'); $html['default_cost'] = htmlentities(dollar_format($default_stats_row['cost'], $cpv), ENT_QUOTES, 'UTF-8'); $html['default_net'] = htmlentities(dollar_format($default_net, $cpv), ENT_QUOTES, 'UTF-8'); $html['default_roi'] = htmlentities($default_roi .'%', ENT_QUOTES, 'UTF-8'); $html['default_cost_wrapper'] = '('.$html['default_cost'].')'; if (!$userObj->hasPermission("access_to_campaign_data")) { $html['default_clicks'] = '?'; $html['default_leads'] = '?'; $html['default_income'] = '?'; $html['default_cost_wrapper'] = '?'; $html['default_net'] = '?'; } ?> hasPermission("access_to_campaign_data")) { $html['total_clicks'] = '?'; $html['total_leads'] = '?'; $html['total_income'] = '?'; $html['total_cost_wrapper'] = '?'; $html['total_net'] = '?'; } ?>

Rotator		Clicks	Leads	S/U	Payout	EPC	Avg CPC	Income	Cost	Net	ROI
(details)
Defaults
Totals for report