0) {
$affiliate_sales_raw = "
select asale.*, os.orders_status_name as orders_status, a.affiliate_firstname, a.affiliate_lastname from " . TABLE_AFFILIATE_SALES . " asale
left join " . TABLE_ORDERS . " o on (asale.affiliate_orders_id = o.orders_id)
left join " . TABLE_ORDERS_STATUS . " os on (o.orders_status = os.orders_status_id and language_id = " . $languages_id . ")
left join " . TABLE_AFFILIATE . " a on (a.affiliate_id = asale.affiliate_id)
where asale.affiliate_id = '" . $HTTP_GET_VARS['acID'] . "'
order by affiliate_date desc
";
$affiliate_sales_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $affiliate_sales_raw, $affiliate_sales_numrows);
} else {
$affiliate_sales_raw = "
select asale.*, os.orders_status_name as orders_status, a.affiliate_firstname, a.affiliate_lastname from " . TABLE_AFFILIATE_SALES . " asale
left join " . TABLE_ORDERS . " o on (asale.affiliate_orders_id = o.orders_id)
left join " . TABLE_ORDERS_STATUS . " os on (o.orders_status = os.orders_status_id and language_id = " . $languages_id . ")
left join " . TABLE_AFFILIATE . " a on (a.affiliate_id = asale.affiliate_id)
order by affiliate_date desc
";
$affiliate_sales_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $affiliate_sales_raw, $affiliate_sales_numrows);
}
?>
>
|
|
|
0) {
?>
' . tep_image_button('button_back.gif', IMAGE_BACK) . ''; ?> |
' . tep_image_button('button_back.gif', IMAGE_BACK) . ''; ?> |
|
|
|
|
|
|
|
|
0) {
$affiliate_sales_values = tep_db_query($affiliate_sales_raw);
$number_of_sales = '0';
while ($affiliate_sales = tep_db_fetch_array($affiliate_sales_values)) {
$number_of_sales++;
if (($number_of_sales / 2) == floor($number_of_sales / 2)) {
echo ' ';
} else {
echo ' ';
}
$link_to = '' . $affiliate_sales['affiliate_orders_id'] . '';
?>
|
|
|
display_price($affiliate_sales['affiliate_value'], ''); ?> |
|
display_price($affiliate_sales['affiliate_payment'], ''); ?> |
|
|
0 && (PREV_NEXT_BAR_LOCATION == '2' || PREV_NEXT_BAR_LOCATION == '3')) {
?>
display_count($affiliate_sales_numrows, MAX_DISPLAY_SEARCH_RESULTS, $HTTP_GET_VARS['page'], TEXT_DISPLAY_NUMBER_OF_SALES); ?> |
display_links($affiliate_sales_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $HTTP_GET_VARS['page'], tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?> |
|
|
|