$contents[] = array('text' => '<br><b>' . $abInfo->affiliate_banners_title . '</b>'); if ($abInfo->affiliate_banners_image) { $contents[] = array('text' => '<br>' . smn_draw_checkbox_field('delete_image', 'on', true) . ' ' . TEXT_INFO_DELETE_IMAGE); } $contents[] = array('align' => 'center', 'text' => '<br>' . smn_image_submit('button_delete.gif', IMAGE_DELETE) . ' <a href="' . smn_href_link(FILENAME_AFFILIATE_BANNER_MANAGER, 'selected_box=affiliate&page=' . $_GET['page'] . '&abID=' . $_GET['abID']) . '">' . smn_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>'); break; default: if (is_object($abInfo)) { $sql = "select products_name from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . $abInfo->affiliate_products_id . "' and language_id = '" . $languages_id . "'"; $product_description_query = smn_db_query($sql); $product_description = smn_db_fetch_array($product_description_query); $heading[] = array('text' => '<b>' . $abInfo->affiliate_banners_title . '</b>'); $contents[] = array('align' => 'center', 'text' => '<a href="' . smn_href_link(FILENAME_AFFILIATE_BANNER_MANAGER, 'selected_box=affiliate&page=' . $_GET['page'] . '&abID=' . $abInfo->affiliate_banners_id . '&action=new') . '">' . smn_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . smn_href_link(FILENAME_AFFILIATE_BANNER_MANAGER, 'selected_box=affiliate&page=' . $_GET['page'] . '&abID=' . $abInfo->affiliate_banners_id . '&action=delete') . '">' . smn_image_button('button_delete.gif', IMAGE_DELETE) . '</a>'); $contents[] = array('text' => $product_description['products_name']); $contents[] = array('text' => '<br>' . TEXT_BANNERS_DATE_ADDED . ' ' . smn_date_short($abInfo->affiliate_date_added)); $contents[] = array('text' => '' . sprintf(TEXT_BANNERS_STATUS_CHANGE, smn_date_short($abInfo->affiliate_date_status_change))); } break; } if (smn_not_null($heading) && smn_not_null($contents)) { echo ' <td width="25%" valign="top">' . "\n"; $box = new box(); echo $box->infoBox($heading, $contents); echo ' </td>' . "\n"; } ?> </tr> </table></td> </tr> <?php }
$amount = $currencies->format($amount); } $coupon_min_order = $currencies->format($cInfo->coupon_minimum_order); if ($_GET['action'] == 'voucherdelete') { $contents[] = array('text' => TEXT_CONFIRM_DELETE . '</br></br>' . '<a href="' . smn_href_link('coupon_admin.php', 'action=confirmdelete&status=' . $status . ($_GET['page'] > 1 ? '&page=' . $_GET['page'] : '') . '&cid=' . $_GET['cid'], 'NONSSL') . '">' . smn_image_button('button_confirm.gif', IMAGE_CONFIRM) . '</a>' . '<a href="' . smn_href_link('coupon_admin.php', 'cid=' . $cInfo->coupon_id, 'NONSSL') . '">' . smn_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>'); } else { $prod_details = NONE; if ($cInfo->restrict_to_products) { $prod_details = '<A HREF="listproducts.php?cid=' . $cInfo->coupon_id . '" TARGET="_blank" ONCLICK="window.open(\'listproducts.php?cid=' . $cInfo->coupon_id . '\', \'Valid_Categories\', \'scrollbars=yes,resizable=yes,menubar=yes,width=600,height=600\'); return false">View</A>'; } $cat_details = NONE; if ($cInfo->restrict_to_categories) { $cat_details = '<A HREF="listcategories.php?cid=' . $cInfo->coupon_id . '" TARGET="_blank" ONCLICK="window.open(\'listcategories.php?cid=' . $cInfo->coupon_id . '\', \'Valid_Categories\', \'scrollbars=yes,resizable=yes,menubar=yes,width=600,height=600\'); return false">View</A>'; } $coupon_name_query = smn_db_query("select coupon_name from " . TABLE_COUPONS_DESCRIPTION . " where coupon_id = '" . $cInfo->coupon_id . "' and language_id = '" . $languages_id . "'"); $coupon_name = smn_db_fetch_array($coupon_name_query); $contents[] = array('text' => COUPON_NAME . ' : ' . $coupon_name['coupon_name'] . '<br>' . COUPON_AMOUNT . ' : ' . $amount . '<br>' . COUPON_MIN_ORDER . ' : ' . $coupon_min_order . '<br>' . COUPON_STARTDATE . ' : ' . smn_date_short($cInfo->coupon_start_date) . '<br>' . COUPON_FINISHDATE . ' : ' . smn_date_short($cInfo->coupon_expire_date) . '<br>' . COUPON_USES_COUPON . ' : ' . $cInfo->uses_per_coupon . '<br>' . COUPON_USES_USER . ' : ' . $cInfo->uses_per_user . '<br>' . COUPON_PRODUCTS . ' : ' . $prod_details . '<br>' . COUPON_CATEGORIES . ' : ' . $cat_details . '<br>' . DATE_CREATED . ' : ' . smn_date_short($cInfo->date_created) . '<br>' . DATE_MODIFIED . ' : ' . smn_date_short($cInfo->date_modified) . '<br><br>' . '<center><a href="' . smn_href_link('coupon_admin.php', 'action=email&cid=' . $cInfo->coupon_id, 'NONSSL') . '">' . smn_image_button('button_email.gif', COUPON_BUTTON_EMAIL_VOUCHER) . '</a>' . '<a href="' . smn_href_link('coupon_admin.php', 'action=voucheredit&cid=' . $cInfo->coupon_id, 'NONSSL') . '">' . smn_image_button('button_edit.gif', COUPON_BUTTON_EDIT_VOUCHER) . '</a>' . '<a href="' . smn_href_link('coupon_admin.php', 'action=voucherdelete&status=' . $status . ($_GET['page'] > 1 ? '&page=' . $_GET['page'] : '') . '&cid=' . $cInfo->coupon_id, 'NONSSL') . '">' . smn_image_button('button_delete.gif', COUPON_BUTTON_DELETE_VOUCHER) . '</a>' . '<br><a href="' . smn_href_link('coupon_admin.php', 'action=voucherreport&cid=' . $cInfo->coupon_id, 'NONSSL') . '">' . smn_image_button('button_report.gif', COUPON_BUTTON_VOUCHER_REPORT) . '</a></center>'); } break; } ?> <td width="25%" valign="top"> <?php $box = new box(); echo $box->infoBox($heading, $contents); echo ' </td>' . "\n"; } ?> </tr> </table>
$contents[] = array('text' => '<br>' . TEXT_DATE_ADDED . ' ' . smn_date_short($cInfo->date_added)); if (smn_not_null($cInfo->last_modified)) { $contents[] = array('text' => TEXT_LAST_MODIFIED . ' ' . smn_date_short($cInfo->last_modified)); } $contents[] = array('text' => '<br>' . smn_info_image($cInfo->categories_image, $cInfo->categories_name, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT) . '<br>' . $cInfo->categories_image); $contents[] = array('text' => '<br>' . TEXT_SUBCATEGORIES . ' ' . $cInfo->childs_count . '<br>' . TEXT_PRODUCTS . ' ' . $cInfo->products_count); } elseif (isset($pInfo) && is_object($pInfo)) { // product info box contents $heading[] = array('text' => '<b>' . smn_get_products_name($pInfo->products_id, $languages_id) . '</b>'); $contents[] = array('align' => 'center', 'text' => '<a href="' . smn_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $pInfo->products_id . '&action=new_product') . '">' . smn_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . smn_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $pInfo->products_id . '&action=delete_product') . '">' . smn_image_button('button_delete.gif', IMAGE_DELETE) . '</a> <a href="' . smn_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $pInfo->products_id . '&action=move_product') . '">' . smn_image_button('button_move.gif', IMAGE_MOVE) . '</a> <a href="' . smn_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $pInfo->products_id . '&action=copy_to') . '">' . smn_image_button('button_copy_to.gif', IMAGE_COPY_TO) . '</a>'); $contents[] = array('text' => '<br>' . TEXT_DATE_ADDED . ' ' . smn_date_short($pInfo->products_date_added)); if (smn_not_null($pInfo->products_last_modified)) { $contents[] = array('text' => TEXT_LAST_MODIFIED . ' ' . smn_date_short($pInfo->products_last_modified)); } if (date('Y-m-d') < $pInfo->products_date_available) { $contents[] = array('text' => TEXT_DATE_AVAILABLE . ' ' . smn_date_short($pInfo->products_date_available)); } $contents[] = array('text' => '<br>' . smn_info_image($pInfo->products_image, $pInfo->products_name, SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '<br>' . $pInfo->products_image); $contents[] = array('text' => '<br>' . TEXT_PRODUCTS_PRICE_INFO . ' ' . $currencies->format($pInfo->products_price) . '<br>' . TEXT_PRODUCTS_QUANTITY_INFO . ' ' . $pInfo->products_quantity); $contents[] = array('text' => '<br>' . TEXT_PRODUCTS_AVERAGE_RATING . ' ' . number_format($pInfo->average_rating, 2) . '%'); } } else { // create category/product info $heading[] = array('text' => '<b>' . EMPTY_CATEGORY . '</b>'); $contents[] = array('text' => TEXT_NO_CHILD_CATEGORIES_OR_PRODUCTS); } break; } if (smn_not_null($heading) && smn_not_null($contents)) { echo ' <td width="25%" valign="top">' . "\n"; $box = new box();
</td> </tr> <?php $affiliate_payment_query = smn_db_query("select * from " . TABLE_AFFILIATE_PAYMENT . " where affiliate_payment_id = '" . $_GET['pID'] . "'"); $affiliate_payment = smn_db_fetch_array($affiliate_payment_query); $affiliate_sales_query = smn_db_query("select * from " . TABLE_AFFILIATE_SALES . " where affiliate_payment_id = '" . $payments['affiliate_payment_id'] . "' order by affiliate_payment_date desc"); while ($affiliate_sales = smn_db_fetch_array($affiliate_sales_query)) { ?> <tr class="dataTableRow"> <td class="dataTableContent" align="right" valign="top"><?php echo $affiliate_sales['affiliate_orders_id']; ?> </td> <td class="dataTableContent" align="center" valign="top"><?php echo smn_date_short($affiliate_sales['affiliate_date']); ?> </td> <td class="dataTableContent" align="right" valign="top"><b><?php echo $currencies->display_price($affiliate_sales['affiliate_value'], ''); ?> </b></td> <td class="dataTableContent" align="right" valign="top"><?php echo $affiliate_sales['affiliate_percent']; echo ENTRY_PERCENT; ?> </td> <td class="dataTableContent" align="right" valign="top"><b><?php echo $currencies->display_price($affiliate_sales['affiliate_payment'], ''); ?> </b></td>
<td class="smallText" valign="top"><?php echo $products_split->display_count($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $_GET['page'], TEXT_DISPLAY_NUMBER_OF_PRODUCTS_EXPECTED); ?> </td> <td class="smallText" align="right"><?php echo $products_split->display_links($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $_GET['page']); ?> </td> </tr> </table></td> </tr> </table></td> <?php $heading = array(); $contents = array(); if (isset($pInfo) && is_object($pInfo)) { $heading[] = array('text' => '<b>' . $pInfo->products_name . '</b>'); $contents[] = array('align' => 'center', 'text' => '<a href="' . smn_href_link(FILENAME_CATEGORIES, 'pID=' . $pInfo->products_id . '&action=new_product') . '">' . smn_image_button('button_edit.gif', IMAGE_EDIT) . '</a>'); $contents[] = array('text' => '<br>' . TEXT_INFO_DATE_EXPECTED . ' ' . smn_date_short($pInfo->products_date_available)); } if (smn_not_null($heading) && smn_not_null($contents)) { echo ' <td width="25%" valign="top">' . "\n"; $box = new box(); echo $box->infoBox($heading, $contents); echo ' </td>' . "\n"; } ?> </tr> </table></td> </tr> </table>
?> </td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td align="left" class="main"><table width="100%" border="0" cellspacing="0" cellpadding="2"> <tr> <td class="main"><b><?php echo ENTRY_ORDER_DATE; ?> </b></td> <td class="main"><?php echo smn_date_short($date['date_purchased']); ?> </td> </tr> <tr> <td class="main"><?php echo '<b>' . ENTRY_PAYMENT_METHOD . '</b> ' . $order->info['payment_method']; ?> </td> </tr> <tr> <td class="main"><?php echo $payment_info; ?> </td> </tr>
$contents = array('form' => smn_draw_form('newsletters', FILENAME_NEWSLETTERS, 'page=' . $HTTP_GET_VARS['page'] . '&nID=' . $nInfo->newsletters_id . '&action=deleteconfirm')); $contents[] = array('text' => TEXT_INFO_DELETE_INTRO); $contents[] = array('text' => '<br><b>' . $nInfo->title . '</b>'); $contents[] = array('align' => 'center', 'text' => '<br>' . smn_image_submit('button_delete.gif', IMAGE_DELETE) . ' <a href="' . smn_href_link(FILENAME_NEWSLETTERS, 'page=' . $HTTP_GET_VARS['page'] . '&nID=' . $HTTP_GET_VARS['nID']) . '">' . smn_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>'); break; default: if (is_object($nInfo)) { $heading[] = array('text' => '<b>' . $nInfo->title . '</b>'); if ($nInfo->locked > 0) { $contents[] = array('align' => 'center', 'text' => '<a href="' . smn_href_link(FILENAME_NEWSLETTERS, 'page=' . $HTTP_GET_VARS['page'] . '&nID=' . $nInfo->newsletters_id . '&action=new') . '">' . smn_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . smn_href_link(FILENAME_NEWSLETTERS, 'page=' . $HTTP_GET_VARS['page'] . '&nID=' . $nInfo->newsletters_id . '&action=delete') . '">' . smn_image_button('button_delete.gif', IMAGE_DELETE) . '</a> <a href="' . smn_href_link(FILENAME_NEWSLETTERS, 'page=' . $HTTP_GET_VARS['page'] . '&nID=' . $nInfo->newsletters_id . '&action=preview') . '">' . smn_image_button('button_preview.gif', IMAGE_PREVIEW) . '</a> <a href="' . smn_href_link(FILENAME_NEWSLETTERS, 'page=' . $HTTP_GET_VARS['page'] . '&nID=' . $nInfo->newsletters_id . '&action=send') . '">' . smn_image_button('button_send.gif', IMAGE_SEND) . '</a> <a href="' . smn_href_link(FILENAME_NEWSLETTERS, 'page=' . $HTTP_GET_VARS['page'] . '&nID=' . $nInfo->newsletters_id . '&action=unlock') . '">' . smn_image_button('button_unlock.gif', IMAGE_UNLOCK) . '</a>'); } else { $contents[] = array('align' => 'center', 'text' => '<a href="' . smn_href_link(FILENAME_NEWSLETTERS, 'page=' . $HTTP_GET_VARS['page'] . '&nID=' . $nInfo->newsletters_id . '&action=preview') . '">' . smn_image_button('button_preview.gif', IMAGE_PREVIEW) . '</a> <a href="' . smn_href_link(FILENAME_NEWSLETTERS, 'page=' . $HTTP_GET_VARS['page'] . '&nID=' . $nInfo->newsletters_id . '&action=lock') . '">' . smn_image_button('button_lock.gif', IMAGE_LOCK) . '</a>'); } $contents[] = array('text' => '<br>' . TEXT_NEWSLETTER_DATE_ADDED . ' ' . smn_date_short($nInfo->date_added)); if ($nInfo->status == '1') { $contents[] = array('text' => TEXT_NEWSLETTER_DATE_SENT . ' ' . smn_date_short($nInfo->date_sent)); } } break; } if (smn_not_null($heading) && smn_not_null($contents)) { echo ' <td width="25%" valign="top">' . "\n"; $box = new box(); echo $box->infoBox($heading, $contents); echo ' </td>' . "\n"; } ?> </tr> </table></td> </tr> <?php
<center> <tr> <td width="35%" align="right" class="dataTableContent"><b><?php echo TEXT_AFFILIATE_NAME; ?> </b> </td> <td width="15%" class="dataTableContent"><?php echo $affiliate['affiliate_firstname'] . ' ' . $affiliate['affiliate_lastname']; ?> </td> <td width="35%" align="right" class="dataTableContent"><?php echo TEXT_AFFILIATE_JOINDATE; ?> </td> <td width="15%" class="dataTableContent"><?php echo smn_date_short($affiliate['affiliate_date_account_created']); ?> </td> </tr> <tr> <td width="35%" align="right" class="dataTableContent"><?php echo TEXT_IMPRESSIONS; echo '<a href="javascript:popupWindow(\'' . (HTTP_SERVER . DIR_WS_CATALOG . FILENAME_AFFILIATE_HELP_1) . '\')">' . TEXT_SUMMARY_HELP . '</a>'; ?> </td> <td width="15%" class="dataTableContent"><?php echo $affiliate_impressions; ?> </td> <td width="35%" align="right" class="dataTableContent"><?php echo TEXT_VISITS;
<td class="main"> <?php echo ENTRY_DATE_OF_BIRTH; ?> </td> <td class="main"> <?php if ($is_read_only == true) { echo smn_date_short($account['customers_dob']); } elseif ($error == true) { if ($entry_date_of_birth_error == true) { echo smn_draw_input_field('dob') . ' ' . ENTRY_DATE_OF_BIRTH_ERROR; } else { echo $dob . smn_draw_hidden_field('dob'); } } else { echo smn_draw_input_field('dob', smn_date_short($account['customers_dob'])) . ' ' . ENTRY_DATE_OF_BIRTH_TEXT; } ?> </td> </tr> <?php } ?> <tr> <td class="main"> <?php echo ENTRY_EMAIL_ADDRESS; ?> </td> <td class="main"> <?php if ($is_read_only == true) {
switch ($coupon['coupon_type']) { case 'F': $text_coupon_help .= sprintf(TEXT_COUPON_HELP_FIXED, $currencies->format($coupon['coupon_amount'])); break; case 'P': $text_coupon_help .= sprintf(TEXT_COUPON_HELP_FIXED, number_format($coupon['coupon_amount'], 2) . '%'); break; case 'S': $text_coupon_help .= TEXT_COUPON_HELP_FREESHIP; break; default: } if ($coupon['coupon_minimum_order'] > 0) { $text_coupon_help .= sprintf(TEXT_COUPON_HELP_MINORDER, $currencies->format($coupon['coupon_minimum_order'])); } $text_coupon_help .= sprintf(TEXT_COUPON_HELP_DATE, smn_date_short($coupon['coupon_start_date']), smn_date_short($coupon['coupon_expire_date'])); $text_coupon_help .= '<b>' . TEXT_COUPON_HELP_RESTRICT . '</b>'; $text_coupon_help .= '<br><br>' . TEXT_COUPON_HELP_CATEGORIES; $cat_ids = split("[,]", $coupon['restrict_to_categories']); for ($i = 0; $i < count($cat_ids); $i++) { $result = smn_db_query("SELECT * FROM categories, categories_description WHERE categories.categories_id = categories_description.categories_id and categories_description.language_id = '" . $languages_id . "' and categories.categories_id='" . $cat_ids[$i] . "'"); if ($row = smn_db_fetch_array($result)) { $cats .= '<br>' . $row["categories_name"]; } } if ($cats == '') { $cats = '<br>NONE'; } $text_coupon_help .= $cats; $text_coupon_help .= '<br><br>' . TEXT_COUPON_HELP_PRODUCTS; $pr_ids = split("[,]", $coupon['restrict_to_products']);
$heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_DELETE_CUSTOMER . '</b>'); $contents = array('form' => smn_draw_form('affiliate', FILENAME_AFFILIATE, smn_get_all_get_params(array('acID', 'action')) . 'acID=' . $aInfo->affiliate_id . '&action=deleteconfirm')); $contents[] = array('text' => TEXT_DELETE_INTRO . '<br><br><b>' . $aInfo->affiliate_firstname . ' ' . $aInfo->affiliate_lastname . '</b>'); $contents[] = array('align' => 'center', 'text' => '<br>' . smn_image_submit('button_delete.gif', IMAGE_DELETE) . ' <a href="' . smn_href_link(FILENAME_AFFILIATE, smn_get_all_get_params(array('acID', 'action')) . 'acID=' . $aInfo->affiliate_id) . '">' . smn_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>'); break; default: if (is_object($aInfo)) { $heading[] = array('text' => '<b>' . $aInfo->affiliate_firstname . ' ' . $aInfo->affiliate_lastname . '</b>'); /*Added the customer id to the url by Cimi*/ $contents[] = array('align' => 'center', 'text' => '<a href="' . smn_href_link(FILENAME_AFFILIATE, smn_get_all_get_params(array('acID', 'action', 'cID')) . 'acID=' . $aInfo->affiliate_id . '&action=edit' . '&cID=' . $aInfo->affiliate_customer_id) . '">' . smn_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . smn_href_link(FILENAME_AFFILIATE, smn_get_all_get_params(array('acID', 'action')) . 'acID=' . $aInfo->affiliate_id . '&action=confirm') . '">' . smn_image_button('button_delete.gif', IMAGE_DELETE) . '</a> <a href="' . smn_href_link(FILENAME_AFFILIATE_CONTACT, 'selected_box=affiliate&affiliate=' . $aInfo->affiliate_email_address) . '">' . smn_image_button('button_email.gif', IMAGE_EMAIL) . '</a>'); $affiliate_sales_raw = "select count(*) as count, sum(affiliate_value) as total, sum(affiliate_payment) as payment from " . TABLE_AFFILIATE_SALES . " a left join " . TABLE_ORDERS . " o on (a.affiliate_orders_id=o.orders_id) where o.orders_status >= " . AFFILIATE_PAYMENT_ORDER_MIN_STATUS . " and affiliate_id = '" . $aInfo->affiliate_id . "'"; $affiliate_sales_values = smn_db_query($affiliate_sales_raw); $affiliate_sales = smn_db_fetch_array($affiliate_sales_values); $contents[] = array('text' => '<br>' . TEXT_DATE_ACCOUNT_CREATED . ' ' . smn_date_short($aInfo->date_account_created)); $contents[] = array('text' => '' . TEXT_DATE_ACCOUNT_LAST_MODIFIED . ' ' . smn_date_short($aInfo->date_account_last_modified)); $contents[] = array('text' => '' . TEXT_INFO_DATE_LAST_LOGON . ' ' . smn_date_short($aInfo->date_last_logon)); $contents[] = array('text' => '' . TEXT_INFO_NUMBER_OF_LOGONS . ' ' . $aInfo->number_of_logons); $contents[] = array('text' => '' . TEXT_INFO_COMMISSION . ' ' . $aInfo->affiliate_commission_percent . ' %'); $contents[] = array('text' => '' . TEXT_INFO_COUNTRY . ' ' . $aInfo->countries_name); $contents[] = array('text' => '' . TEXT_INFO_NUMBER_OF_SALES . ' ' . $affiliate_sales['count'], ''); $contents[] = array('text' => '' . TEXT_INFO_SALES_TOTAL . ' ' . $currencies->display_price($affiliate_sales['total'], '')); $contents[] = array('text' => '' . TEXT_INFO_AFFILIATE_TOTAL . ' ' . $currencies->display_price($affiliate_sales['payment'], '')); } break; } if (smn_not_null($heading) && smn_not_null($contents)) { echo ' <td width="25%" valign="top">' . "\n"; $box = new box(); echo $box->infoBox($heading, $contents); echo ' </td>' . "\n"; }
if ($rows > 0) { if (isset($cInfo) && is_object($cInfo)) { // store_category info box contents $heading[] = array('text' => '<b>' . $cInfo->store_categories_name . '</b>'); $contents[] = array('align' => 'center', 'text' => '<a href="' . smn_href_link(FILENAME_MANAGEMENT, 'sPath=' . $sPath . '&cID=' . $cInfo->store_categories_id . '&action=edit_store_category') . '">' . smn_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . smn_href_link(FILENAME_MANAGEMENT, 'sPath=' . $sPath . '&cID=' . $cInfo->store_categories_id . '&action=delete_store_category') . '">' . smn_image_button('button_delete.gif', IMAGE_DELETE) . '</a> <a href="' . smn_href_link(FILENAME_MANAGEMENT, 'sPath=' . $sPath . '&cID=' . $cInfo->store_categories_id . '&action=move_store_category') . '">' . smn_image_button('button_move.gif', IMAGE_MOVE) . '</a>'); $contents[] = array('text' => '<br>' . TEXT_DATE_ADDED . ' ' . smn_date_short($cInfo->date_added)); if (smn_not_null($cInfo->last_modified)) { $contents[] = array('text' => TEXT_LAST_MODIFIED . ' ' . smn_date_short($cInfo->last_modified)); } $contents[] = array('text' => '<br>' . smn_info_image($cInfo->store_categories_image, $cInfo->store_categories_name, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT) . '<br>' . $cInfo->store_categories_image); $contents[] = array('text' => '<br>' . TEXT_SUBCATEGORIES . ' ' . $cInfo->childs_count . '<br>' . TEXT_STORES . ' ' . $cInfo->store_count); } elseif (isset($pInfo) && is_object($pInfo)) { // store info box contents $heading[] = array('text' => '<b>' . $pInfo->store_name . '</b>'); $contents[] = array('align' => 'center', 'text' => '<a href="' . smn_href_link(FILENAME_MANAGEMENT, 'sPath=' . $sPath . '&sID=' . $pInfo->store_id . '&action=edit_store') . '">' . smn_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . smn_href_link(FILENAME_MANAGEMENT, 'sPath=' . $sPath . '&sID=' . $pInfo->store_id . '&action=delete_store') . '">' . smn_image_button('button_delete.gif', IMAGE_DELETE) . '</a> <a href="' . smn_href_link(FILENAME_MANAGEMENT, 'sPath=' . $sPath . '&sID=' . $pInfo->store_id . '&action=move_store') . '">' . smn_image_button('button_move.gif', IMAGE_MOVE) . '</a> <a href="' . smn_href_link(FILENAME_MANAGEMENT, 'sPath=' . $sPath . '&sID=' . $pInfo->store_id . '&action=copy_to') . '">' . smn_image_button('button_copy_to.gif', IMAGE_COPY_TO) . '</a>'); $contents[] = array('text' => '<br>' . TEXT_DATE_ADDED . ' ' . smn_date_short($pInfo->date_added)); } else { // create store_category/store info $heading[] = array('text' => '<b>' . EMPTY_CATEGORY . '</b>'); $contents[] = array('text' => TEXT_NO_CHILD_CATEGORIES_OR_STORES); } } break; } if (smn_not_null($heading) && smn_not_null($contents)) { echo ' <td width="25%" valign="top">' . "\n"; $box = new box(); echo $box->infoBox($heading, $contents); echo ' </td>' . "\n"; } ?>
$orders_query = smn_db_query("select o.orders_id, o.date_purchased, o.delivery_name, o.delivery_country, o.billing_name, o.billing_country, 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 . "' and s.public_flag = '1' order by orders_id desc limit 3"); while ($orders = smn_db_fetch_array($orders_query)) { if (smn_not_null($orders['delivery_name'])) { $order_name = $orders['delivery_name']; $order_country = $orders['delivery_country']; } else { $order_name = $orders['billing_name']; $order_country = $orders['billing_country']; } ?> <tr class="moduleRow" onMouseOver="rowOverEffect(this)" onMouseOut="rowOutEffect(this)" onClick="document.location.href='<?php echo smn_href_link(FILENAME_ACCOUNT_HISTORY_INFO, 'order_id=' . $orders['orders_id'], 'NONSSL'); ?> '"> <td class="main" width="80"><?php echo smn_date_short($orders['date_purchased']); ?> </td> <td class="main"><?php echo '#' . $orders['orders_id']; ?> </td> <td class="main"><?php echo smn_output_string_protected($order_name) . ', ' . $order_country; ?> </td> <td class="main"><?php echo $orders['orders_status_name']; ?> </td> <td class="main" align="right"><?php
$affiliate_payment_values = smn_db_query($affiliate_payment_split->sql_query); $number_of_payment = 0; while ($affiliate_payment = smn_db_fetch_array($affiliate_payment_values)) { $number_of_payment++; if ($number_of_payment / 2 == floor($number_of_payment / 2)) { echo ' <tr class="productListing-even">'; } else { echo ' <tr class="productListing-odd">'; } ?> <td class="smallText" align="right"><?php echo $affiliate_payment['affiliate_payment_id']; ?> </td> <td class="smallText" align="center"><?php echo smn_date_short($affiliate_payment['affiliate_payment_date']); ?> </td> <td class="smallText" align="right"><?php echo $currencies->display_price($affiliate_payment['affiliate_payment_total'], ''); ?> </td> <td class="smallText" align="right"><?php echo $affiliate_payment['affiliate_payment_status_name']; ?> </td> </tr> <?php } } else { ?>
$affiliate_clickthroughs_values = smn_db_query($affiliate_clickthroughs_raw); $number_of_clickthroughs = '0'; while ($affiliate_clickthroughs = smn_db_fetch_array($affiliate_clickthroughs_values)) { $number_of_clickthroughs++; if ($number_of_clickthroughs / 2 == floor($number_of_clickthroughs / 2)) { echo ' <tr class="productListing-even">'; } else { echo ' <tr class="productListing-odd">'; } ?> <td class="dataTableContent"><?php echo $affiliate_clickthroughs['affiliate_firstname'] . " " . $affiliate_clickthroughs['affiliate_lastname']; ?> </td> <td class="dataTableContent" align="center"><?php echo smn_date_short($affiliate_clickthroughs['affiliate_clientdate']); ?> </td> <?php if ($affiliate_clickthroughs['affiliate_products_id'] > 0) { $link_to = '<a href="' . smn_catalog_href_link(FILENAME_CATALOG_PRODUCT_INFO, 'products_id=' . $affiliate_clickthroughs['affiliate_products_id']) . '" target="_blank">' . $affiliate_clickthroughs['products_name'] . '</a>'; } else { $link_to = "Startpage"; } ?> <td class="dataTableContent"><?php echo $link_to; ?> </td> <td class="dataTableContent" align="center"><?php echo $affiliate_clickthroughs['affiliate_clientbrowser'];
</b></td> </tr> <tr> <td><?php echo smn_draw_separator('pixel_trans.gif', '100%', '10'); ?> </td> </tr> <tr> <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox"> <tr class="infoBoxContents"> <td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <?php $statuses_query = smn_db_query("select os.orders_status_name, osh.date_added, osh.comments from " . TABLE_ORDERS_STATUS . " os, " . TABLE_ORDERS_STATUS_HISTORY . " osh where osh.orders_id = '" . (int) $_GET['order_id'] . "' and osh.orders_status_id = os.orders_status_id and os.language_id = '" . (int) $languages_id . "' and os.public_flag = '1' order by osh.date_added"); while ($statuses = smn_db_fetch_array($statuses_query)) { echo ' <tr>' . "\n" . ' <td class="main" valign="top" width="70">' . smn_date_short($statuses['date_added']) . '</td>' . "\n" . ' <td class="main" valign="top" width="70">' . $statuses['orders_status_name'] . '</td>' . "\n" . ' <td class="main" valign="top">' . (empty($statuses['comments']) ? ' ' : nl2br(smn_output_string_protected($statuses['comments']))) . '</td>' . "\n" . ' </tr>' . "\n"; } ?> </table></td> </tr> </table></td> </tr> <?php if (DOWNLOAD_ENABLED == 'true') { include DIR_WS_MODULES . 'downloads.php'; } ?> <tr> <td><?php echo smn_draw_separator('pixel_trans.gif', '100%', '10'); ?>
$contents[] = array('text' => TEXT_DELETE_INTRO); $contents[] = array('text' => '<br><b>' . $mInfo->manufacturers_name . '</b>'); $contents[] = array('text' => '<br>' . smn_draw_checkbox_field('delete_image', '', true) . ' ' . TEXT_DELETE_IMAGE); if ($mInfo->products_count > 0) { $contents[] = array('text' => '<br>' . smn_draw_checkbox_field('delete_products') . ' ' . TEXT_DELETE_PRODUCTS); $contents[] = array('text' => '<br>' . sprintf(TEXT_DELETE_WARNING_PRODUCTS, $mInfo->products_count)); } $contents[] = array('align' => 'center', 'text' => '<br>' . smn_image_submit('button_delete.gif', IMAGE_DELETE) . ' <a href="' . smn_href_link(FILENAME_MANUFACTURERS, 'page=' . $_GET['page'] . '&mID=' . $mInfo->manufacturers_id) . '">' . smn_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>'); break; default: if (isset($mInfo) && is_object($mInfo)) { $heading[] = array('text' => '<b>' . $mInfo->manufacturers_name . '</b>'); $contents[] = array('align' => 'center', 'text' => '<a href="' . smn_href_link(FILENAME_MANUFACTURERS, 'page=' . $_GET['page'] . '&mID=' . $mInfo->manufacturers_id . '&action=edit') . '">' . smn_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . smn_href_link(FILENAME_MANUFACTURERS, 'page=' . $_GET['page'] . '&mID=' . $mInfo->manufacturers_id . '&action=delete') . '">' . smn_image_button('button_delete.gif', IMAGE_DELETE) . '</a>'); $contents[] = array('text' => '<br>' . TEXT_DATE_ADDED . ' ' . smn_date_short($mInfo->date_added)); if (smn_not_null($mInfo->last_modified)) { $contents[] = array('text' => TEXT_LAST_MODIFIED . ' ' . smn_date_short($mInfo->last_modified)); } $contents[] = array('text' => '<br>' . smn_info_image($mInfo->manufacturers_image, $mInfo->manufacturers_name)); $contents[] = array('text' => '<br>' . TEXT_PRODUCTS . ' ' . $mInfo->products_count); } break; } if (smn_not_null($heading) && smn_not_null($contents)) { echo ' <td width="25%" valign="top">' . "\n"; $box = new box(); echo $box->infoBox($heading, $contents); echo ' </td>' . "\n"; } ?> </tr> </table></td>
$contents[] = array('text' => TEXT_INFO_DELETE_INTRO); $contents[] = array('text' => '<br><b>' . $cInfo->title . '</b>'); $contents[] = array('align' => 'center', 'text' => '<br>' . ($remove_currency ? '<a href="' . smn_href_link(FILENAME_CURRENCIES, 'page=' . $_GET['page'] . '&cID=' . $cInfo->currencies_id . '&action=deleteconfirm') . '">' . smn_image_button('button_delete.gif', IMAGE_DELETE) . '</a>' : '') . ' <a href="' . smn_href_link(FILENAME_CURRENCIES, 'page=' . $_GET['page'] . '&cID=' . $cInfo->currencies_id) . '">' . smn_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>'); break; default: if (is_object($cInfo)) { $heading[] = array('text' => '<b>' . $cInfo->title . '</b>'); $contents[] = array('align' => 'center', 'text' => '<a href="' . smn_href_link(FILENAME_CURRENCIES, 'page=' . $_GET['page'] . '&cID=' . $cInfo->currencies_id . '&action=edit') . '">' . smn_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . smn_href_link(FILENAME_CURRENCIES, 'page=' . $_GET['page'] . '&cID=' . $cInfo->currencies_id . '&action=delete') . '">' . smn_image_button('button_delete.gif', IMAGE_DELETE) . '</a>'); $contents[] = array('text' => '<br>' . TEXT_INFO_CURRENCY_TITLE . ' ' . $cInfo->title); $contents[] = array('text' => TEXT_INFO_CURRENCY_CODE . ' ' . $cInfo->code); $contents[] = array('text' => '<br>' . TEXT_INFO_CURRENCY_SYMBOL_LEFT . ' ' . $cInfo->symbol_left); $contents[] = array('text' => TEXT_INFO_CURRENCY_SYMBOL_RIGHT . ' ' . $cInfo->symbol_right); $contents[] = array('text' => '<br>' . TEXT_INFO_CURRENCY_DECIMAL_POINT . ' ' . $cInfo->decimal_point); $contents[] = array('text' => TEXT_INFO_CURRENCY_THOUSANDS_POINT . ' ' . $cInfo->thousands_point); $contents[] = array('text' => TEXT_INFO_CURRENCY_DECIMAL_PLACES . ' ' . $cInfo->decimal_places); $contents[] = array('text' => '<br>' . TEXT_INFO_CURRENCY_LAST_UPDATED . ' ' . smn_date_short($cInfo->last_updated)); $contents[] = array('text' => TEXT_INFO_CURRENCY_VALUE . ' ' . number_format($cInfo->value, 8)); $contents[] = array('text' => '<br>' . TEXT_INFO_CURRENCY_EXAMPLE . '<br>' . $currencies->format('30', false, DEFAULT_CURRENCY) . ' = ' . $currencies->format('30', true, $cInfo->code)); } break; } if (smn_not_null($heading) && smn_not_null($contents)) { echo ' <td width="25%" valign="top">' . "\n"; $box = new box(); echo $box->infoBox($heading, $contents); echo ' </td>' . "\n"; } ?> </tr> </table></td> </tr>
<td class="dataTableContent" align="right"><?php echo smn_date_long(date("Y-m-d\\ H:i:s", $sr->showDate)); ?> <td class="dataTableContent" align="right"> <?php echo smn_date_short(date("Y-m-d\\ H:i:s", $sr->showDateEnd)); ?> </td> <?php break; default: ?> <td class="dataTableContent" align="right"><?php echo smn_date_short(date("Y-m-d\\ H:i:s", $sr->showDate)); ?> <td class="dataTableContent" align="right"> <?php echo smn_date_short(date("Y-m-d\\ H:i:s", $sr->showDateEnd)); ?> </td> <?php } ?> <td class="dataTableContent" align="right"><?php echo $info[0]['order']; ?> </td> <td class="dataTableContent" align="right"><?php echo $info[$last - 1]['totitem']; ?> </td> <td class="dataTableContent" align="right"><?php echo $currencies->format($info[$last - 1]['totsum']);
</tr> <tr> <td colspan="2"><?php echo smn_draw_separator(); ?> </td> </tr> <tr> <?php $row = 0; while ($expected = smn_db_fetch_array($expected_query)) { $row++; if ($row / 2 == floor($row / 2)) { echo ' <tr class="upcomingProducts-even">' . "\n"; } else { echo ' <tr class="upcomingProducts-odd">' . "\n"; } echo ' <td class="smallText"> <a href="' . smn_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $expected['products_id'] . '&ID=' . $expected['store_id']) . '">' . $expected['products_name'] . '</a> </td>' . "\n" . ' <td align="right" class="smallText"> ' . smn_date_short($expected['date_expected']) . ' </td>' . "\n" . ' </tr>' . "\n"; } ?> <tr> <td colspan="2"><?php echo smn_draw_separator(); ?> </td> </tr> </table></td> </tr> <!-- upcoming_products_eof //--> <?php }
$heading = array(); $contents = array(); $heading[] = array('text' => '[' . $gInfo->coupon_id . '] ' . ' ' . $currencies->format($gInfo->coupon_amount)); $redeem_query = smn_db_query("select * from " . TABLE_COUPON_REDEEM_TRACK . " where coupon_id = '" . $gInfo->coupon_id . "'"); $redeemed = 'No'; if (smn_db_num_rows($redeem_query) > 0) { $redeemed = 'Yes'; } $contents[] = array('text' => TEXT_INFO_SENDERS_ID . ' ' . $gInfo->customer_id_sent); $contents[] = array('text' => TEXT_INFO_AMOUNT_SENT . ' ' . $currencies->format($gInfo->coupon_amount)); $contents[] = array('text' => TEXT_INFO_DATE_SENT . ' ' . smn_date_short($gInfo->date_sent)); $contents[] = array('text' => TEXT_INFO_VOUCHER_CODE . ' ' . $gInfo->coupon_code); $contents[] = array('text' => TEXT_INFO_EMAIL_ADDRESS . ' ' . $gInfo->emailed_to); if ($redeemed == 'Yes') { $redeem = smn_db_fetch_array($redeem_query); $contents[] = array('text' => '<br>' . TEXT_INFO_DATE_REDEEMED . ' ' . smn_date_short($redeem['redeem_date'])); $contents[] = array('text' => TEXT_INFO_IP_ADDRESS . ' ' . $redeem['redeem_ip']); $contents[] = array('text' => TEXT_INFO_CUSTOMERS_ID . ' ' . $redeem['customer_id']); } else { $contents[] = array('text' => '<br>' . TEXT_INFO_NOT_REDEEMED); } if (smn_not_null($heading) && smn_not_null($contents)) { echo ' <td width="25%" valign="top">' . "\n"; $box = new box(); echo $box->infoBox($heading, $contents); echo ' </td>' . "\n"; } ?> </tr> </table></td> </tr>
$contents[] = array('text' => TEXT_INFO_DELETE_INTRO); $contents[] = array('text' => '<br><b>' . $sInfo->products_name . '</b>'); $contents[] = array('align' => 'center', 'text' => '<br>' . smn_image_submit('button_delete.gif', IMAGE_DELETE) . ' <a href="' . smn_href_link(FILENAME_SPECIALS, 'page=' . $_GET['page'] . '&sID=' . $sInfo->specials_id) . '">' . smn_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>'); break; default: if (is_object($sInfo)) { $heading[] = array('text' => '<b>' . $sInfo->products_name . '</b>'); $contents[] = array('align' => 'center', 'text' => '<a href="' . smn_href_link(FILENAME_SPECIALS, 'page=' . $_GET['page'] . '&sID=' . $sInfo->specials_id . '&action=edit') . '">' . smn_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . smn_href_link(FILENAME_SPECIALS, 'page=' . $_GET['page'] . '&sID=' . $sInfo->specials_id . '&action=delete') . '">' . smn_image_button('button_delete.gif', IMAGE_DELETE) . '</a>'); $contents[] = array('text' => '<br>' . TEXT_INFO_DATE_ADDED . ' ' . smn_date_short($sInfo->specials_date_added)); $contents[] = array('text' => '' . TEXT_INFO_LAST_MODIFIED . ' ' . smn_date_short($sInfo->specials_last_modified)); $contents[] = array('align' => 'center', 'text' => '<br>' . smn_info_image($sInfo->products_image, $sInfo->products_name, SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT)); $contents[] = array('text' => '<br>' . TEXT_INFO_ORIGINAL_PRICE . ' ' . $currencies->format($sInfo->products_price)); $contents[] = array('text' => '' . TEXT_INFO_NEW_PRICE . ' ' . $currencies->format($sInfo->specials_new_products_price)); $contents[] = array('text' => '' . TEXT_INFO_PERCENTAGE . ' ' . number_format(100 - $sInfo->specials_new_products_price / $sInfo->products_price * 100) . '%'); $contents[] = array('text' => '<br>' . TEXT_INFO_EXPIRES_DATE . ' <b>' . smn_date_short($sInfo->expires_date) . '</b>'); $contents[] = array('text' => '' . TEXT_INFO_STATUS_CHANGE . ' ' . smn_date_short($sInfo->date_status_change)); } break; } if (smn_not_null($heading) && smn_not_null($contents)) { echo ' <td width="25%" valign="top">' . "\n"; $box = new box(); echo $box->infoBox($heading, $contents); echo ' </td>' . "\n"; } } ?> </tr> </table></td> </tr> </table>
$contents[] = array('text' => '<br>' . TEXT_INFO_CLASS_DESCRIPTION . '<br>' . smn_draw_input_field('tax_class_description', $tcInfo->tax_class_description)); $contents[] = array('align' => 'center', 'text' => '<br>' . smn_image_submit('button_update.gif', IMAGE_UPDATE) . ' <a href="' . smn_href_link(FILENAME_TAX_CLASSES, 'page=' . $_GET['page'] . '&tID=' . $tcInfo->tax_class_id) . '">' . smn_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>'); break; case 'delete': $heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_DELETE_TAX_CLASS . '</b>'); $contents = array('form' => smn_draw_form('classes', FILENAME_TAX_CLASSES, 'page=' . $_GET['page'] . '&tID=' . $tcInfo->tax_class_id . '&action=deleteconfirm')); $contents[] = array('text' => TEXT_INFO_DELETE_INTRO); $contents[] = array('text' => '<br><b>' . $tcInfo->tax_class_title . '</b>'); $contents[] = array('align' => 'center', 'text' => '<br>' . smn_image_submit('button_delete.gif', IMAGE_DELETE) . ' <a href="' . smn_href_link(FILENAME_TAX_CLASSES, 'page=' . $_GET['page'] . '&tID=' . $tcInfo->tax_class_id) . '">' . smn_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>'); break; default: if (isset($tcInfo) && is_object($tcInfo)) { $heading[] = array('text' => '<b>' . $tcInfo->tax_class_title . '</b>'); $contents[] = array('align' => 'center', 'text' => '<a href="' . smn_href_link(FILENAME_TAX_CLASSES, 'page=' . $_GET['page'] . '&tID=' . $tcInfo->tax_class_id . '&action=edit') . '">' . smn_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . smn_href_link(FILENAME_TAX_CLASSES, 'page=' . $_GET['page'] . '&tID=' . $tcInfo->tax_class_id . '&action=delete') . '">' . smn_image_button('button_delete.gif', IMAGE_DELETE) . '</a>'); $contents[] = array('text' => '<br>' . TEXT_INFO_DATE_ADDED . ' ' . smn_date_short($tcInfo->date_added)); $contents[] = array('text' => '' . TEXT_INFO_LAST_MODIFIED . ' ' . smn_date_short($tcInfo->last_modified)); $contents[] = array('text' => '<br>' . TEXT_INFO_CLASS_DESCRIPTION . '<br>' . $tcInfo->tax_class_description); } break; } if (smn_not_null($heading) && smn_not_null($contents)) { echo ' <td width="25%" valign="top">' . "\n"; $box = new box(); echo $box->infoBox($heading, $contents); echo ' </td>' . "\n"; } ?> </tr> </table></td> </tr> </table>
<tr> <td class="main" align="center" valign="top" width="130"><?php echo '<b>' . OVERVIEW_PREVIOUS_ORDERS . '</b><br>' . smn_image(DIR_WS_IMAGES . 'arrow_south_east.gif'); ?></td> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <?php $orders_query = smn_db_query("select o.orders_id, o.date_purchased, o.delivery_name, o.delivery_country, o.billing_name, o.billing_country, 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 . "' and s.public_flag = '1' order by orders_id desc limit 3"); while ($orders = smn_db_fetch_array($orders_query)) { if (smn_not_null($orders['delivery_name'])) { $order_name = $orders['delivery_name']; $order_country = $orders['delivery_country']; } else { $order_name = $orders['billing_name']; $order_country = $orders['billing_country']; } ?> <tr class="moduleRow" onMouseOver="rowOverEffect(this)" onMouseOut="rowOutEffect(this)" onClick="document.location.href='<?php echo smn_href_link(FILENAME_ACCOUNT_HISTORY_INFO, 'order_id=' . $orders['orders_id'], 'NONSSL'); ?>'"> <td class="main" width="80"><?php echo smn_date_short($orders['date_purchased']); ?></td> <td class="main"><?php echo '#' . $orders['orders_id']; ?></td> <td class="main"><?php echo smn_output_string_protected($order_name) . ', ' . $order_country; ?></td> <td class="main"><?php echo $orders['orders_status_name']; ?></td> <td class="main" align="right"><?php echo $orders['order_total']; ?></td> <td class="main" align="right"><?php echo '<a href="' . smn_href_link(FILENAME_ACCOUNT_HISTORY_INFO, 'order_id=' . $orders['orders_id'].'&ID='.$store_id, 'NONSSL') . '">' . smn_image_button('small_view.gif', SMALL_IMAGE_BUTTON_VIEW) . '</a>'; ?></td> </tr> <?php } ?> </table></td> <td><?php echo smn_draw_separator('pixel_trans.gif', '10', '1'); ?></td> </tr> </table></td> </tr> </table></td>