real_escape_string($time['to']); $mysql['from'] = $db->real_escape_string($time['from']); //show real or filtered clicks $aff_campaigns = array(); $count = 0; $mysql['user_id'] = $db->real_escape_string($_SESSION['user_id']); $user_sql = "SELECT 2p.user_pref_show, 2p.user_cpc_or_cpv, 2ac.aff_campaign_name, 2ac.aff_campaign_id, 2ch.data AS chart_data, 2ch.chart_time_range FROM 202_users_pref AS 2p LEFT OUTER JOIN 202_aff_campaigns AS 2ac ON (2p.user_id = 2ac.user_id AND 2ac.aff_campaign_deleted = 0) LEFT OUTER JOIN 202_charts AS 2ch ON (2p.user_id = 2ch.user_id) WHERE 2p.user_id=".$mysql['user_id'].""; $user_result = _mysqli_query($user_sql, $dbGlobalLink); //($user_sql); while ($user_row2 = $user_result->fetch_assoc()) { $user_row['user_pref_show'] = $user_row2['user_pref_show']; $user_row['user_cpc_or_cpv'] = $user_row2['user_cpc_or_cpv']; $user_row['user_chart_data'] = $user_row2['chart_data']; $user_row['chart_time_range'] = $user_row2['chart_time_range']; $aff_campaigns[] = array('aff_campaign_id' => $user_row2['aff_campaign_id'], 'aff_campaign_name' => $user_row2['aff_campaign_name']); } $user_row['user_chart_data'] = unserialize($user_row['user_chart_data']); if ($user_row['user_pref_show'] == 'all') { $click_filtered = ''; } if ($user_row['user_pref_show'] == 'real') { $click_filtered = " AND click_filtered='0' "; } if ($user_row['user_pref_show'] == 'filtered') { $click_filtered = " AND click_filtered='1' "; } if ($user_row['user_pref_show'] == 'filtered_bot') { $click_filtered = " AND click_bot='1' "; } if ($user_row['user_pref_show'] == 'leads') { $click_filtered = " AND click_lead='1' "; } if ($user_row['user_cpc_or_cpv'] == 'cpv') $cpv = true; else $cpv = false; ?>
Account Overview
hasPermission("access_to_campaign_data")) { ?>
hasPermission("access_to_campaign_data")) { echo '
'; $start = new DateTime('@' . $mysql['from']); $end = new DateTime('@' . $mysql['to']); switch ($user_row['chart_time_range']) { case 'hours': $rangeOutputFormat = 'M d h:iA'; break; case 'days': $rangeOutputFormat = 'M d'; break; default: $rangeOutputFormat = 'M d'; $user_row['chart_time_range'] = 'days'; break; } $rangePeriod = returnRanges($start, $end, $user_row['chart_time_range']); $chart = $de->getChart($mysql['from'], $mysql['to'], $user_row['user_chart_data'], $user_row['chart_time_range'], $rangeOutputFormat, $rangePeriod); } ?> hasPermission("access_to_campaign_data")) { ?> getReportData('campaignOverview', $mysql['from'], $mysql['to'],$cpv)); $lpsData = array(); $lpsData = ($de->getReportData('LpOverview', $mysql['from'], $mysql['to'],$cpv)); $dr->displayReport('LpOverview', $lpsData); $dr->displayReport('campaignOverview', $campaignsData); $slpDirectLinkPerPPC = $de->getReportData('slp_direct_link_per_ppc', $mysql['from'], $mysql['to'],$cpv); $dr->displayPerPPCReport('slp_direct_link', $slpDirectLinkPerPPC); $AlpPerPPC = $de->getReportData('alp_per_ppc', $mysql['from'], $mysql['to'],$cpv); $dr->displayPerPPCReport('alp', $AlpPerPPC); ?> hasPermission("access_to_campaign_data")) { ?>