} if (is_numeric($_GET['a_level'])) { $a_level = xtc_db_prepare_input($_GET['a_level']); $level_clause = " AND a.affiliate_level = '" . $a_level . "'"; } $affiliate_sales_raw = "select a.affiliate_payment, a.affiliate_date, a.affiliate_value, a.affiliate_percent,\n a.affiliate_payment, a.affiliate_level AS level,\n o.orders_status as orders_status_id, os.orders_status_name as orders_status, \n MONTH(aa.affiliate_date_account_created) as start_month, YEAR(aa.affiliate_date_account_created) as start_year\n from " . TABLE_AFFILIATE . " aa\n left join " . TABLE_AFFILIATE_SALES . " a on (aa.affiliate_id = a.affiliate_id )\n left join " . TABLE_ORDERS . " o on (a.affiliate_orders_id = o.orders_id) \n left join " . TABLE_ORDERS_STATUS . " os on (o.orders_status = os.orders_status_id and language_id = '" . $_SESSION['languages_id'] . "')\n where a.affiliate_id = '" . $_SESSION['affiliate_id'] . "' " . $period_clause . $status_clause . $level_clause . " \n group by aa.affiliate_date_account_created, o.orders_status, os.orders_status_name, \n a.affiliate_payment, a.affiliate_date, a.affiliate_value, a.affiliate_percent, \n o.orders_status, os.orders_status_name\n order by affiliate_date DESC"; $count_key = 'aa.affiliate_date_account_created, o.orders_status, os.orders_status_name, a.affiliate_payment, a.affiliate_date, a.affiliate_value, a.affiliate_percent, o.orders_status, os.orders_status_name'; $affiliate_sales_split = new splitPageResults($affiliate_sales_raw, $_GET['page'], MAX_DISPLAY_SEARCH_RESULTS, $count_key); if ($affiliate_sales_split->number_of_rows > 0) { $affiliate_sales_values = xtc_db_query($affiliate_sales_split->sql_query); $affiliate_sales = xtc_db_fetch_array($affiliate_sales_values); } else { $affiliate_sales_values = xtc_db_query("select MONTH(affiliate_date_account_created) as start_month,\n YEAR(affiliate_date_account_created) as start_year\n FROM " . TABLE_AFFILIATE . " WHERE affiliate_id = '" . $_SESSION['affiliate_id'] . "'"); $affiliate_sales = xtc_db_fetch_array($affiliate_sales_values); } $smarty->assign('period_selector', affiliate_period('a_period', $affiliate_sales['start_year'], $affiliate_sales['start_month'], true, xtc_db_prepare_input($_GET['a_period']), 'onChange="this.form.submit();"')); $smarty->assign('status_selector', affiliate_get_status_list('a_status', xtc_db_prepare_input($_GET['a_status']), 'onChange="this.form.submit();"')); $smarty->assign('level_selector', affiliate_get_level_list('a_level', xtc_db_prepare_input($_GET['a_level']), 'onChange="this.form.submit();"')); require DIR_WS_INCLUDES . 'header.php'; $smarty->assign('affiliate_sales_split_numbers', $affiliate_sales_split->number_of_rows); $smarty->assign('FORM_ACTION', xtc_draw_form('params', xtc_href_link(FILENAME_AFFILIATE_SALES), 'get', 'SSL')); $affiliate_sales_table = ''; if ($affiliate_sales_split->number_of_rows > 0) { $number_of_sales = 0; $sum_of_earnings = 0; do { $number_of_sales++; if ($affiliate_sales['orders_status_id'] >= AFFILIATE_PAYMENT_ORDER_MIN_STATUS) { $sum_of_earnings += $affiliate_sales['affiliate_payment']; } if ($number_of_sales / 2 == floor($number_of_sales / 2)) {
require DIR_FS_CATALOG . 'templates/' . CURRENT_TEMPLATE . '/source/boxes.php'; if (!isset($_SESSION['affiliate_id'])) { vam_redirect(vam_href_link(FILENAME_AFFILIATE, '', 'SSL')); } $breadcrumb->add(NAVBAR_TITLE, vam_href_link(FILENAME_AFFILIATE, '', 'SSL')); $breadcrumb->add(NAVBAR_TITLE_SUMMARY, vam_href_link(FILENAME_AFFILIATE_SUMMARY)); $affiliate_raw = "select sum(affiliate_banners_shown) as banner_count, " . "count(affiliate_clickthrough_id) as clickthrough_count, " . "MONTH(affiliate_date_account_created) as start_month, " . "YEAR(affiliate_date_account_created) as start_year, " . "a.affiliate_commission_percent, a.affiliate_firstname, a.affiliate_id, affiliate_lastname " . "from " . TABLE_AFFILIATE . " AS a " . "LEFT JOIN " . TABLE_AFFILIATE_CLICKTHROUGHS . " AS ac ON ( a.affiliate_id = ac.affiliate_id )" . "LEFT JOIN " . TABLE_AFFILIATE_BANNERS_HISTORY . " AS ab ON ( a.affiliate_id = ab.affiliate_banners_affiliate_id )" . " where a.affiliate_id = '" . $_SESSION['affiliate_id'] . "'" . " GROUP BY a.affiliate_date_account_created, a.affiliate_commission_percent, a.affiliate_firstname, affiliate_lastname "; $affiliate_query = vam_db_query($affiliate_raw); $affiliate = vam_db_fetch_array($affiliate_query); $vamTemplate->assign('affiliate', $affiliate); $affiliate_impressions = $affiliate['banner_count']; if ($affiliate_impressions == 0) { $affiliate_impressions = "n/a"; } $vamTemplate->assign('affiliate_impressions', $affiliate_impressions); $vamTemplate->assign('period_selector', affiliate_period('a_period', $affiliate['start_year'], $affiliate['start_month'], true, vam_db_prepare_input($_GET['a_period']), 'onchange="this.form.submit();"')); $affiliate_percent = 0; $affiliate_percent = $affiliate['affiliate_commission_percent']; if ($affiliate_percent < AFFILIATE_PERCENT) { $affiliate_percent = AFFILIATE_PERCENT; } $vamTemplate->assign('affiliate_percent', vam_round($affiliate_percent, 2)); $affiliate_percent_tier = preg_split("/;/", AFFILIATE_TIER_PERCENTAGE, AFFILIATE_TIER_LEVELS); if (empty($_GET['a_period']) or $_GET['a_period'] == "all") { $affiliate_sales = affiliate_level_statistics_query($_SESSION['affiliate_id']); } else { $affiliate_sales = affiliate_level_statistics_query($_SESSION['affiliate_id'], vam_db_prepare_input($_GET['a_period'])); } $vamTemplate->assign('affiliate_transactions', vam_not_null($affiliate_sales['count']) ? $affiliate_sales['count'] : 0); if ($affiliate_clickthroughs > 0) { $affiliate_conversions = vam_round($affiliate_transactions / $affiliate_clickthroughs * 100, 2) . "%";