|
|
|
$i, 'text' => strftime("%B", mktime(0, 0, 0, $i, 1)));
}
// create year options
$default_y = date("Y"); // default year
for ($i = 0; $i <= 30; $i++) {
$years_array[] = array('id' => date("Y") + $i, 'text' => date("Y") + $i);
}
?>
|
'Date');
new infoBoxHeading($info_box_contents, true, false);
$info_box_contents = array();
$info_box_contents[] = array('form' => tep_draw_form('date', tep_href_link(FILENAME_ACCOUNT_HISTORY_AFF, '', 'NONSSL', false), 'get'), //use to be 'onChange="this.form.submit(); "size="'...
'text' => "Month". tep_draw_pull_down_menu('month_id', $month_array, (!isset($HTTP_GET_VARS['month_id']) ? $default_m : $HTTP_GET_VARS['month_id']) , 'onChange="this.form.submit(); "size="' . MAX_MANUFACTURERS_LIST . '" style="width: 100%"') .
"Year" .
tep_draw_pull_down_menu('years_id', $years_array, (!isset($HTTP_GET_VARS['years_id']) ? $default_y : $HTTP_GET_VARS['years_id']) , 'onChange="this.form.submit(); "size="' . MAX_MANUFACTURERS_LIST . '" style="width: 100%"'). tep_hide_session_id()); /*.
tep_image_submit('button_update.gif',IMAGE_UPDATE,"onClick=this.form.submit()"). tep_hide_session_id());*/
new infoBox($info_box_contents);
?>
|
0) {
//$history_query_raw = "select o.orders_id, o.date_purchased, o.delivery_name, o.billing_name, ot.text as order_total, s.orders_status_name from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_TOTAL . " ot, " . TABLE_ORDERS_STATUS . " s where o.customers_id = '" . (int)$customer_id . "' and o.orders_id = ot.orders_id and ot.class = 'ot_total' and o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' order by orders_id DESC";
$history_query_raw = "select ar.action_name, ar.advertiser_name, ar.sid_customer_id, ar.customers_commision, ar.date_inserted, ar.post_date from " . TABLE_LINKS_AFF_REPORT . " ar where ar.sid_customer_id = '" . (int)$customer_id . "' and month(ar.post_date) = '" . (int)$the_month . "' and year(ar.post_date) = '" . (int)$the_year . "' order by post_date ASC";
$history_split = new splitPageResults($history_query_raw, MAX_DISPLAY_ORDER_HISTORY);
$history_query = tep_db_query($history_split->sql_query);
while ($history = tep_db_fetch_array($history_query)) {
//$products_query = tep_db_query("select count(*) as count from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int)$history['orders_id'] . "'");
// $products_query = tep_db_query("select count(*) as count from " . TABLE_LINKS_AFF_REPORT . " where sid_customer_id = '" . (int)$history['sid_customer_id'] . "' and month(post_date) = '" . (int)$the_month . "' and year(post_date) = '" . (int)$the_year. "' ");
// $products = tep_db_fetch_array($products_query);
/* if (tep_not_null($history['delivery_name'])) {
$order_type = TEXT_ORDER_SHIPPED_TO;
$order_name = $history['delivery_name'];
} else {
$order_type = TEXT_ORDER_BILLED_TO;
$order_name = $history['billing_name'];
}*/
$order_name = $history['advertiser_name'];
?>
' . TEXT_ORDER_NUMBER . ' ' . $history['orders_id'];*/ ?> |
' . TEXT_ORDER_STATUS . ' ' . $history['orders_status_name']; */?> |
' . TEXT_PAYOUT_DATE . ' ' . tep_date_hour_min($history['post_date']) . ' pst ' . TEXT_PAYOUT_COMPANY . ' ' . $history['advertiser_name']; ?> |
' . TEXT_PAYOUT_ACTION . ' ' . $history['action_name'] .' ' . TEXT_PAYOUT_COST .' ' . "$". number_format($history['customers_commision'],2); ?> |
' . tep_image_button('small_view.gif', SMALL_IMAGE_BUTTON_VIEW) . ''; */?> |
|
|
0) {
?>
display_count(TEXT_DISPLAY_NUMBER_OF_ORDERS); ?> |
display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?> |
|
|
|
' . tep_image_button('button_back.gif', IMAGE_BUTTON_BACK) . ''; ?> |
|
|
|
|
|