Jump to content

xavkick

Members
  • Content count

    66
  • Joined

  • Last visited

Posts posted by xavkick


  1. I am not using QT Pro myself, so Xavkick can you confirm that for a product with attribute you still enter the total stock of the products plus the detailled stock for each of its attributes ?

     

    And that when one article of this kind is sold, both the total stock and the particular stock for the attribute are reduced ?

     

     

    No you do not enter the total of stock of the product, you only update each attributes... and the contrib upgrade automatically the total of the stock.... that's make ( all the attributes of the items give the total of the product stock )

     

    But if the item as no attributes you update then only the stock product..... :thumbsup:


  2. I'm trying to get my head around this. It seems like you would have to update all of the products attribute queries as well as the stock check queries to take products_stock_id into account.

     

    Is there a QtPro forum? Maybe a developer there could shed some light on this.

     

     

    hi, I did ask someone for the QTpro Table :

     

    products_Stock_id -------> is the unique ID of each item on this table

    products_id ---------> is the product ID for the Product Stock ID

    products_stock_attributes ----> is the name of the attribut

    products_stock_quantity ----> is the stock level

     

     

    I hope this will help you..

     

    xav


  3. Where else is products_stock_id written? It must be logged somewhere else, like as orders_products_stock_id in table orders_products_attributes.

     

     

     

    I give you the sql files for installing this contribution, then i hope you will understand wich table is created..

     

    # Database changes for QT Pro installation to a store that does not have a

    # previous version of QT Pro installed

     

     

     

    # Add new column to products_options to indicate if stock should be tracked

    # for an option

     

    ALTER TABLE products_options

    ADD products_options_track_stock tinyint(4) default '0' not null

    AFTER products_options_name;

     

     

    # Add new column to orders_products to track attributes to make it possible

    # to delete an order and restock

     

    ALTER TABLE orders_products

    ADD products_stock_attributes varchar(255) default NULL

    AFTER products_quantity;

     

     

    # Create new table to track stock for products attributes

     

    DROP TABLE IF EXISTS products_stock;

    CREATE TABLE products_stock (

    products_stock_id int(11) not null auto_increment,

    products_id int(11) default '0' not null ,

    products_stock_attributes varchar(255) not null,

    products_stock_quantity int(11) default '0' not null ,

    PRIMARY KEY (products_stock_id),

    UNIQUE idx_products_stock_attributes (products_id,products_stock_attributes)

    );

     

    thank you for your help again

     

    lil xav


  4. There's been discussion about this. I'm still waiting for a response to this post:

     

     

     

    Each different attribute has it's own products_stock_id? So a product with four selections and 20 options per selection, would have 80 entries in this table?

     

    I could write up code that will update products_stock but it will do it by products_id, not products_stock_id which is probably the unique id in this table.

     

     

     

    So the best thing to do is that i try to explain you the way this contrin work...

     

    in the table products_stock You have :

     

    products_stock_id

    products_id

    products_stock_attributes

    products_stock_quantity

     

    but the product_id could be the same for different product depending the attrubute :

    here is one copy of my table:

    products_stock_id		  products_id	 products_stock_attributes		products_stock_quantity
    
    374									139					  2-17								   0
    31									  63						4-41								   -1
    24									 138					   2-15									9
    25									  138						2-16								  23

     

     

    So in fact, the product_stock_id is unique

    The product_id can be commom for several items depending the size or color for eample

    The attributes are set like that :

     

    in the products_stock_attributes , the first number is the main categorie attribute like color and the second number ( after the - ) is the color ---> for example red

    and the products_stock_quantity is the quantity of this item.

    So i hope to be simple.

    for example a jean got a product_id 10

    the color_id is 2

    and the color red is 12 and the color yellow is 13, then you will have in the table this :

     

    products_stock_id		  products_id	 products_stock_attributes		products_stock_quantity
    150									  10						 2-12										 50
    151									  10						 2-13										 47

     

    i hope you will understand what i mean because my english is quite bad...

    If you need more information, please ask ma..

     

    xav


  5. custodian :

     

    i make another test. i put in the order.php :

     

     <tr>
    			<td class="main"><b><?php echo ENTRY_CUSTOMER_NOTES; ?></b></td>
    			<td><i>
    			  <?php
    //query to grab the notes
    $cust_notes_query = tep_db_query(" select customers_id, customers_notes from " . TABLE_CUSTOMERS . " where customers_id =' " . (int)$cID . " ' ");
    $cust_notes = tep_db_fetch_array($cust_notes_query);
    
    //end query
    echo $cust_notes['customers_notes']; ?>
    			  </i></td>
    		  </tr>

     

     

    so when i go in the customer.php and i call the order it's running good i can see the notes of that customer because in the adresse bar i have :

    http://www.mysite/admin/customers.php?search=tirel&page=1&cID=1306&action=edit

     

    but i f i use the order.php it's not working because i have in the adresse bar :

     

    http://www.mysite/admin/orders.php?selected_box=customers&page=1&oID=29697&action=edit

     

    so perhaps the good code could be to make a request like

     

    if cID

    elseif oID

     

    but i don't know how to write it in perfect language..

     

    lol

     

    xav


  6. Go to the customer list (not the order list) and select a customer that you know has an order.

    Click details

     

    Scroll down and enter a note in their NOTES field.

     

    Click Update

     

    Now go to the order - is the note you just entered there?

     

     

    hi,

     

     

    yes i try wat you say and nothinbg is written in it... sorry for your lost time...


  7. Make sure that

     

    $result = tep_db_query("select customers_notes from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$customer_id . " '");

     

    did not wrap - it should be all one line That may cause your problem

     

     

    With your solution, nothing appear now, even with order.php or customers.php


  8. Hi xavkick

    I have tried it the way you described and it is the same on my shop. Don't know why it doesn't show up, I will try to firgure it out.

     

    Alex

     

     

    I think the error must be the way we call the customer... When we check the customer ID.


  9. I don't know if this would not make it show or not (tables can be funny like that).. but initially looking at this part

     

    <tr>

    <td class="main"><b><?php echo ENTRY_PAYMENT_METHOD; ?></b></td>

    <td class="main"><?php echo $order->info['payment_method']; ?></td>

    <tr>

    <td class="main"><b><?php echo ENTRY_CUSTOMER_NOTES; ?></b></td>

    <td><i><?php

    //query to grab the notes

    $cust_notes_query = tep_db_query("select customers_id, customers_notes from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$cID . "'");

    $cust_notes = tep_db_fetch_array($cust_notes_query);

     

    //end query

    echo $cust_notes['customers_notes']; ?></i></td>

    </tr>

     

    I think that should be

     

    <tr>

    <td class="main"><b><?php echo ENTRY_PAYMENT_METHOD; ?></b></td>

    <td class="main"><?php echo $order->info['payment_method']; ?></td>

    </tr>

    <tr>

    <td class="main"><b><?php echo ENTRY_CUSTOMER_NOTES; ?></b></td>

    <td><i><?php

    //query to grab the notes

    $cust_notes_query = tep_db_query("select customers_id, customers_notes from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$cID . "'");

    $cust_notes = tep_db_fetch_array($cust_notes_query);

     

    //end query

    echo $cust_notes['customers_notes']; ?></i></td>

    </tr>

     

     

     

    hi, i change it but still not working ....

     

    but i have found on way...

    When you go on the customers.php and look after all the order of one customer... ( you've got a list ) when you click on one order in the list ----> it's working good.... you see the customer notes

     

    But if you click on the same order of that customer but with the files order.php nothing appears....

    I think that could be something to help you to find the solution....


  10. can you post a .txt link file of your admin/orders.php page (which would make it full / not cut-off) in your ROOT directory? (this will not open hacking vulnerabilities, as oscommerce's source is open already) , so myself or someone familiar with the way this contribution works can see why this isn't happening for you? [no passwords or logins, just a copy of admin/orders.php duplicated to your root directory for public access)

     

    if you don't want us to know your shop url, you can load a .zip file of your admin file to www.yousendit.com

     

     

    Hi,

     

    No it's not a problem at all :thumbsup:

    thanks for your help

     

    file is Here


  11. Yes sorry, but in fact my files was splited ( too long! )

     

    So, first thing : when i go on the customer account i can see alle the details and at the bottom i see the notes...

     

     

    Second thing :

     

    If i go on the page order and I click on one order ( a guest who have a note ! ) i see nothing..

     

     

    thanks for your help..

     

    xav


  12. here is my order.php code but still not working :

     

    <?php

    /*

    $Id: orders.php,v 1.2 2003/09/24 15:18:15 wilt Exp $

     

    osCommerce, Open Source E-Commerce Solutions

    http://www.oscommerce.com

     

    Copyright (c) 2003 osCommerce

     

    Released under the GNU General Public License

    */

     

    require('includes/application_top.php');

     

    require(DIR_WS_CLASSES . 'currencies.php');

    $currencies = new currencies();

     

    $orders_statuses = array();

    $orders_status_array = array();

    $orders_status_query = tep_db_query("select orders_status_id, orders_status_name from " . TABLE_ORDERS_STATUS . " where language_id = '" . (int)$languages_id . "'");

    while ($orders_status = tep_db_fetch_array($orders_status_query)) {

    $orders_statuses[] = array('id' => $orders_status['orders_status_id'],

    'text' => $orders_status['orders_status_name']);

    $orders_status_array[$orders_status['orders_status_id']] = $orders_status['orders_status_name'];

    }

     

    $action = (isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : '');

     

    if (tep_not_null($action)) {

    switch ($action) {

    case 'update_order':

    $oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);

     

    /* #CHAVEIRO3# Tracking begin*/

    $track_num = tep_db_prepare_input($HTTP_POST_VARS['track_num']);

    $track_num2 = tep_db_prepare_input($HTTP_POST_VARS['track_num2']);

     

    /* #CHAVEIRO3# Tracking end*/

     

    $order_updated = false;

    $check_status_query = tep_db_query("select customers_name, customers_email_address, orders_status, date_purchased from " . TABLE_ORDERS . " where orders_id = '" . (int)$oID . "'");

    $check_status = tep_db_fetch_array($check_status_query);

    // BOF: WebMakers.com Added: Downloads Controller

    // always update date and time on order_status

    // original if ( ($check_status['orders_status'] != $status) || tep_not_null($comments)) {

    if ( ($check_status['orders_status'] != $status) || $comments != '' || ($status ==DOWNLOADS_ORDERS_STATUS_UPDATED_VALUE) ) {

    tep_db_query("update " . TABLE_ORDERS . " set orders_status = '" . tep_db_input($status) . "', last_modified = now() where orders_id = '" . (int)$oID . "'");

    $check_status_query2 = tep_db_query("select customers_name, customers_email_address, orders_status, date_purchased from " . TABLE_ORDERS . " where orders_id = '" . (int)$oID . "'");

    $check_status2 = tep_db_fetch_array($check_status_query2);

    if ( $check_status2['orders_status']==DOWNLOADS_ORDERS_STATUS_UPDATED_VALUE ) {

    tep_db_query("update " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " set download_maxdays = '" . tep_get_configuration_key_value('DOWNLOAD_MAX_DAYS') . "', download_count = '" . tep_get_configuration_key_value('DOWNLOAD_MAX_COUNT') . "' where orders_id = '" . (int)$oID . "'");

    }

    // EOF: WebMakers.com Added: Downloads Controller

     

    $customer_notified = '0';

    if (isset($HTTP_POST_VARS['notify']) && ($HTTP_POST_VARS['notify'] == 'on')) {

    $notify_comments = '';

    // BOF: WebMakers.com Added: Downloads Controller - Only tell of comments if there are comments

    if (isset($HTTP_POST_VARS['notify_comments']) && ($HTTP_POST_VARS['notify_comments'] == 'on')) {

    $notify_comments = sprintf(EMAIL_TEXT_COMMENTS_UPDATE, $comments) . "\n\n";

    }

    // ################## modifications html ####################"

    $Varlogo = ''.VARLOGO.'';

    $Vartable1 = ''.VARTABLE1.'';

    $Vartable2 = ''.VARTABLE2.'';

    $Vartext1 = ' <b>' . EMAIL_TEXT_DEAR . ' ' . $check_status['customers_name'] . ' </b><br>' . EMAIL_TEXT_DEARR . '<br> ' . EMAIL_TEXT_USER . ': ' . $check_status['customers_email_address'] . ' ';

    $Vartext2 = ' ' . EMAIL_TEXT_ORDER_NUMBER . ' <STRONG> ' . $oID . '</STRONG><br><a href="' . HTTP_SERVER . DIR_WS_CATALOG . 'account_history_info.php?order_id=' . $oID .'">'.IMG.'</a><br>' . EMAIL_TEXT_INVOICE_URL .

    ': <a href="' . HTTP_SERVER . DIR_WS_CATALOG . 'account_history_info.php?order_id=' . $oID .'"><font size="-2">' . HTTP_SERVER . DIR_WS_CATALOG . 'account_history_info.php?order_id=' . $oID .

    '</font></a> ' . $email_total .' <br>' . EMAIL_TEXT_DATE_ORDERED . ' : <b>' . tep_date_long($check_status['date_purchased']) . '</b> ';

    $Varmailfooter1 = ''.VARMAILFOOTER1.'';

    $Varmailfooter2 = ''.VARMAILFOOTER2.'';

    $Varhttp = ''.VARHTTP.'';

    $Varstyle = ''.VARSTYLE.'';

    $Varstatut= ''. sprintf(EMAIL_TEXT_STATUS_UPDATE, $orders_status_array[$status]).'';

    require(DIR_WS_MODULES . 'email/html_orders.php');

    $email = $html_orders;

    // ############### lets start with the email confirmation ##################

    if (EMAIL_USE_HTML == 'true') {

     

    $email = $html_orders;

     

    }

    else

    {

    /* #CHAVEIRO3# Tracking contribution begin*/

    if ((isset($HTTP_POST_VARS['notify_tracking']) &&

     

    ($HTTP_POST_VARS['notify_tracking'] == 'on')) & (tep_not_null($track_num) ||

     

    tep_not_null($track_num2))) {

    $notify_tracking = sprintf(EMAIL_TEXT_TRACKING_NUMBER) . "\n" . URL_TO_TRACK1 .

     

    $track_num. "\n\n";

    }

    $email = STORE_NAME . "\n" . EMAIL_SEPARATOR . "\n" .

     

    EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID . "\n" . EMAIL_TEXT_INVOICE_URL . ' ' .

     

    tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID,

     

    'SSL') . "\n" . EMAIL_TEXT_DATE_ORDERED . ' ' .

     

    tep_date_long($check_status['date_purchased']) . "\n\n" . $notify_tracking .

     

    $notify_comments . sprintf(EMAIL_TEXT_STATUS_UPDATE, $orders_status_array[$status]);

    /* #CHAVEIRO3# Tracking contribution end*/

    }

    // ################## end modification #################

    tep_mail($check_status['customers_name'], $check_status['customers_email_address'], EMAIL_TEXT_SUBJECT, $email, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);

     

    $customer_notified = '1';

    }

     

    /* #CHAVEIRO3# Tracking begin*/

    tep_db_query("insert into " . TABLE_ORDERS_STATUS_HISTORY . " (orders_id,

     

    orders_status_id, date_added, customer_notified, comments, track_num, track_num2)

     

    values ('" . (int)$oID . "', '" . tep_db_input($status) . "', now(), '" .

     

    tep_db_input($customer_notified) . "', '" . tep_db_input($comments) . "', '" .

     

    tep_db_input($track_num) . "', '" . tep_db_input($track_num2) . "')");

    /* #CHAVEIRO3# Tracking end*/

     

    $order_updated = true;

    }

     

    if ($order_updated == true) {

    $messageStack->add_session(SUCCESS_ORDER_UPDATED, 'success');

    } else {

    $messageStack->add_session(WARNING_ORDER_NOT_UPDATED, 'warning');

    }

     

    tep_redirect(tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action')) . 'action=edit'));

    break;

    case 'deleteconfirm':

    $oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);

     

    tep_remove_order($oID, $HTTP_POST_VARS['restock']);

     

    tep_redirect(tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action'))));

    break;

    }

    }

     

    if (($action == 'edit') && isset($HTTP_GET_VARS['oID'])) {

    $oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);

     

    $orders_query = tep_db_query("select orders_id from " . TABLE_ORDERS . " where orders_id = '" . (int)$oID . "'");

    $order_exists = true;

    if (!tep_db_num_rows($orders_query)) {

    $order_exists = false;

    $messageStack->add(sprintf(ERROR_ORDER_DOES_NOT_EXIST, $oID), 'error');

    }

    }

    // BOF: WebMakers.com Added: Additional info for Orders

    // Look up things in orders

    $the_extra_query= tep_db_query("select * from " . TABLE_ORDERS . " where orders_id = '" . (int)$oID . "'");

    $the_extra= tep_db_fetch_array($the_extra_query);

    $the_customers_id= $the_extra['customers_id'];

    // Look up things in customers

    $the_extra_query= tep_db_query("select * from " . TABLE_CUSTOMERS . " where customers_id = '" . $the_customers_id . "'");

    $the_extra= tep_db_fetch_array($the_extra_query);

    $the_customers_fax= $the_extra['customers_fax'];

    // EOF: WebMakers.com Added: Additional info for Orders

     

    include(DIR_WS_CLASSES . 'order.php');

    ?>

    <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

    <html <?php echo HTML_PARAMS; ?>>

    <head>

    <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">

    <title><?php echo TITLE; ?></title>

    <link rel="stylesheet" type="text/css" href="includes/stylesheet.css">

    <script language="javascript" src="includes/menu.js"></script>

    <script language="javascript" src="includes/general.js"></script>

    <script language="javascript"><!--

    function popupWindow(url) {

    window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,res

    izable=yes,copyhistory=no,width=650,height=500,screenX=150,screenY=150,top=150,le

    ft=150')

    }

    //--></script>

    <?php // ====> BOF: ORDERS AT-A-GLANCE <==== ?>

     

    <script language="javascript" src="includes/javascript/overlib_mini.js"><!-- overLIB (c) Erik Bosrup --></script>

     

    <?php // ====> EOF: ORDERS AT-A-GLANCE <==== ?>

    </head>

    <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">

    <!-- header //-->

    <?php

    require(DIR_WS_INCLUDES . 'header.php');

    ?>

    <!-- header_eof //-->

    <!-- body //-->

    <?php // ====> BOF: ORDERS AT-A-GLANCE <==== ?>

     

    <div id="overDiv" style="position:absolute; visibility:hidden; z-index:1000;"></div>

     

    <?php // ====> EOF: ORDERS AT-A-GLANCE <==== ?>

    <table border="0" width="100%" cellspacing="2" cellpadding="2">

    <tr>

    <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">

    <!-- left_navigation //-->

    <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>

    <!-- left_navigation_eof //-->

    </table></td>

    <!-- body_text //-->

    <td width="100%" valign="top">

    <table border="0" width="100%" cellspacing="0" cellpadding="2">

    <?php

    if (($action == 'edit') && ($order_exists == true)) {

    $order = new order($oID);

    ?>

    <!-- BEGIN NEXT AND PREVIOUS ORDERS DISPLAY IN ADMIN //-->

     

    <tr>

    <td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0">

    <tr>

    <td class="pageHeading"><?php if( $nextid = get_order_id($oID,'prev')) { echo '<a href="' .tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action')) . 'oID=' . $nextid . '&action=edit') . '">' . PREV_ORDER . '</a>'; } ?></td>

    <td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', 1, HEADING_IMAGE_HEIGHT); ?></td>

    <td class="pageHeading" align="right"><?php if( $previd = get_order_id($oID)) echo '<a href="' .tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action')) . 'oID=' . $previd . '&action=edit') . '">' . NEXT_ORDER . '</a>'; ?></td>

    </tr>

    </table></td>

    </tr>

    <!-- END NEXT AND PREVIOUS ORDERS DISPLAY IN ADMIN //-->

    <tr>

    <td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0">

    <tr>

    <td class="pageHeading"><?php echo HEADING_TITLE; ?></td>

    <td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', 1, HEADING_IMAGE_HEIGHT); ?></td>

    <td class="pageHeading" align="right"><?php echo '<a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action'))) . '">' . tep_image_button('button_back.gif', IMAGE_BACK) . '</a>'; ?></td>

    <td class="pageHeading" align="right"><?php echo '<a href="' . tep_href_link("edit_orders.php", tep_get_all_get_params(array('action'))) . '">' . tep_image_button('button_edit.gif', IMAGE_EDIT) . '</a>   '; ?> <?php echo '<a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action'))) . '">' . tep_image_button('button_back.gif', IMAGE_BACK) . '</a>'; ?> </td>

    </tr>

    </table></td>

    </tr>

    <tr>

    <td><table width="100%" border="0" cellspacing="0" cellpadding="2">

    <tr>

    <td colspan="3"><?php echo tep_draw_separator(); ?></td>

    </tr>

    <tr>

    <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">

    <tr>

    <td class="main" valign="top"><b><?php echo ENTRY_CUSTOMER; ?></b></td>

    <td class="main"><?php echo tep_address_format($order->customer['format_id'], $order->customer, 1, '', '<br>'); ?></td>

    </tr>

    <tr>

    <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td>

    </tr>

    <tr>

    <td class="main"><b><?php echo ENTRY_TELEPHONE_NUMBER; ?></b></td>

    <td class="main"><?php echo $order->customer['telephone']; ?></td>

    </tr>

    <?php

    // BOF: WebMakers.com Added: Downloads Controller - Extra order info

    ?>

    <tr>

    <td class="main"><b><?php echo 'Numéro de Fax :'; ?></b></td>

    <td class="main"><?php echo $the_customers_fax; ?></td>

    </tr>

    <?php

    // EOF: WebMakers.com Added: Downloads Controller

    ?>

    <tr>

    <td class="main"><b><?php echo ENTRY_EMAIL_ADDRESS; ?></b></td>

    <td class="main"><?php echo '<a href="mailto:' . $order->customer['email_address'] . '"><u>' . $order->customer['email_address'] . '</u></a>'; ?></td>

    </tr>

    </table></td>

    <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">

    <tr>

    <td class="main" valign="top"><b><?php echo ENTRY_SHIPPING_ADDRESS; ?></b></td>

    <td class="main"><?php echo tep_address_format($order->delivery['format_id'], $order->delivery, 1, '', '<br>'); ?></td>

    </tr>

    </table></td>

    <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">

    <tr>

    <td class="main" valign="top"><b><?php echo ENTRY_BILLING_ADDRESS; ?></b></td>

    <td class="main"><?php echo tep_address_format($order->billing['format_id'], $order->billing, 1, '', '<br>'); ?></td>

    </tr>

    </table></td>

    </tr>

    </table></td>

    </tr>

    <!-- //Ajout pour n? TVA intracommunautaire //-->

    <tr>

    <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>

    </tr>

    <tr>

    <td><table border="0" cellspacing="0" cellpadding="2">

    <tr>

    <tr>

    <td class="main"><b><?php echo ENTRY_SHOP_INTRACOM; ?></b></td>

    <td class="main"><?php echo TVA_SHOP_INTRACOM; ?></td>

    </tr>

    </table></td>

    </tr>

    <!-- // fin ajout //-->

    <tr>

    <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>

    </tr>

    <tr>

    <td><table border="0" cellspacing="0" cellpadding="2">

    <?php

    // BOF: WebMakers.com Added: Show Order Info

    ?>

    <!-- add Order # // -->

    <tr>

    <td class="main"><b>Numéro de commande:</b></td>

    <td class="main"><?php echo tep_db_input($oID); ?></td>

    </tr>

    <!-- add date/time // -->

    <tr>

    <td class="main"><b>Date heure commande:</b></td>

    <td class="main"><?php echo tep_datetime_short($order->info['date_purchased']); ?></td>

    </tr>

    <?php

    // EOF: WebMakers.com Added: Show Order Info

    ?>

    <tr>

    <td class="main"><b><?php echo ENTRY_PAYMENT_METHOD; ?></b></td>

    <td class="main"><?php echo $order->info['payment_method']; ?></td>

    <tr>

    <td class="main"><b><?php echo ENTRY_CUSTOMER_NOTES; ?></b></td>

    <td><i><?php

    //query to grab the notes

    $cust_notes_query = tep_db_query("select customers_id, customers_notes from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$cID . "'");

    $cust_notes = tep_db_fetch_array($cust_notes_query);

     

    //end query

    echo $cust_notes['customers_notes']; ?></i></td>

    </tr>

    <?php

    if (tep_not_null($order->info['cc_type']) || tep_not_null($order->info['cc_owner']) || tep_not_null($order->info['cc_number'])) {

    ?>

    <tr>

    <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>

    </tr>

    <tr>

    <td class="main"><?php echo ENTRY_CREDIT_CARD_TYPE; ?></td>

    <td class="main"><?php echo $order->info['cc_type']; ?></td>

    </tr>

    <tr>

    <td class="main"><?php echo ENTRY_CREDIT_CARD_OWNER; ?></td>

    <td class="main"><?php echo $order->info['cc_owner']; ?></td>

    </tr>

    <tr>

    <td class="main"><?php echo ENTRY_CREDIT_CARD_NUMBER; ?></td>

    <td class="main"><?php echo $order->info['cc_number']; ?></td>

    </tr>

    <tr>

    <td class="main"><?php echo ENTRY_CREDIT_CARD_EXPIRES; ?></td>

    <td class="main"><?php echo $order->info['cc_expires']; ?></td>

    </tr>

    <?php

    }

    ?>

    </table></td>

    </tr>

    <tr>

    <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>

    </tr>

    <tr>

    <td><table border="0" width="100%" cellspacing="0" cellpadding="2">

    <tr class="dataTableHeadingRow">

    <td class="dataTableHeadingContent" colspan="2"><?php echo TABLE_HEADING_PRODUCTS; ?></td>

    <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS_MODEL; ?></td>

    <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TAX; ?></td>

    <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_PRICE_EXCLUDING_TAX; ?></td>

    <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_PRICE_INCLUDING_TAX; ?></td>

    <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TOTAL_EXCLUDING_TAX; ?></td>

    <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TOTAL_INCLUDING_TAX; ?></td>

    </tr>

    <?php

    for ($i=0, $n=sizeof($order->products); $i<$n; $i++) {

    echo ' <tr class="dataTableRow">' . "\n" .

    ' <td class="dataTableContent" valign="top" align="right">' . $order->products[$i]['qty'] . ' x</td>' . "\n" .

    ' <td class="dataTableContent" valign="top">' . $order->products[$i]['name'];

     

    if (isset($order->products[$i]['attributes']) && (sizeof($order->products[$i]['attributes']) > 0)) {

    for ($j = 0, $k = sizeof($order->products[$i]['attributes']); $j < $k; $j++) {

    echo '<br><nobr><small> <i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value'];

    if ($order->products[$i]['attributes'][$j]['price'] != '0') //echo ' (' . $order->products[$i]['attributes'][$j]['prefix'] . $currencies->format($order->products[$i]['attributes'][$j]['price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . ')';

    echo '</i></small></nobr>';

    }

    }

     

    echo ' </td>' . "\n" .

    ' <td class="dataTableContent" valign="top">' . $order->products[$i]['model'] . '</td>' . "\n" .

    ' <td class="dataTableContent" align="right" valign="top">' . tep_display_tax_value($order->products[$i]['tax']) . '%</td>' . "\n" .

    ' <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->format($order->products[$i]['final_price'], true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "\n" .

    ' <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->format(tep_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']), true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "\n" .

    ' <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->format($order->products[$i]['final_price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "\n" .

    ' <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->format(tep_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']) * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "\n";

    echo ' </tr>' . "\n";

    }

    ?>

    <tr>

    <td align="right" colspan="8"><table border="0" cellspacing="0" cellpadding="2">

    <?php

    for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {

    echo ' <tr>' . "\n" .

    ' <td align="right" class="smallText">' . $order->totals[$i]['title'] . '</td>' . "\n" .

    ' <td align="right" class="smallText">' . $order->totals[$i]['text'] . '</td>' . "\n" .

    ' </tr>' . "\n";

    }

    ?>

    </table></td>

    </tr>

    </table></td>

    </tr>

    <tr>

    <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>

    </tr>

    <tr>

    <td class="main"><table border="1" cellspacing="0" cellpadding="5">

    <tr>

    <td class="smallText" align="center"><b><?php echo TABLE_HEADING_DATE_ADDED; ?></b></td>

    <td class="smallText" align="center"><b><?php echo TABLE_HEADING_CUSTOMER_NOTIFIED; ?></b></td>

    <td class="smallText" align="center"><b><?php echo TABLE_HEADING_STATUS; ?></b></td>

    <td class="smallText" align="center"><b><?php echo TABLE_HEADING_COMMENTS; ?></b></td>

    <?php

    /* #CHAVEIRO3# Tracking begin*/

    ?>

    <td class="smallText" align="center"><b><?php echo

     

    TABLE_HEADING_TRACKING; ?></b></td>

    <?php

    /* #CHAVEIRO3# Tracking end*/

    ?>

    </tr>

    <?php

    /* #CHAVEIRO3# Tracking begin*/

    $orders_history_query = tep_db_query("select orders_status_id, date_added,

     

    customer_notified, comments, track_num, track_num2 from " .

     

    TABLE_ORDERS_STATUS_HISTORY . " where orders_id = '" . tep_db_input($oID) . "' order

     

    by date_added");

    /* #CHAVEIRO3# Tracking end*/

     

    if (tep_db_num_rows($orders_history_query)) {

    while ($orders_history = tep_db_fetch_array($orders_history_query)) {

    echo ' <tr>' . "\n" .

    ' <td class="smallText" align="center">' . tep_datetime_short($orders_history['date_added']) . '</td>' . "\n" .

    ' <td class="smallText" align="center">';

    if ($orders_history['customer_notified'] == '1') {

    echo tep_image(DIR_WS_ICONS . 'tick.gif', ICON_TICK) . "</td>\n";

    } else {

    echo tep_image(DIR_WS_ICONS . 'cross.gif', ICON_CROSS) . "</td>\n";

    }

    echo ' <td class="smallText">' . $orders_status_array[$orders_history['orders_status_id']] . '</td>' . "\n" .

    ' <td class="smallText">' . nl2br(tep_db_output($orders_history['comments'])) . ' </td>' . "\n" .

     

    /* #CHAVEIRO3# Tracking begin*/

    ' <td class="smallText">' .

    ( empty(

     

    $orders_history['track_num'] ) ? ' ' : '<a href="' . URL_TO_TRACK1 .

     

    nl2br(tep_output_string_protected(nl2br(tep_db_output($orders_history['track_num'])))

     

    ) . '" target="_blank">' .

     

    nl2br(tep_output_string_protected(nl2br(tep_db_output($orders_history['track_num'])))

     

    ) . '</a>  ') .

    ( empty(

     

    $orders_history['track_num2'] ) ? ' ' : '<a href="' . URL_TO_TRACK2 .

     

    nl2br(tep_output_string_protected(nl2br(tep_db_output($orders_history['track_num2']))

     

    )) . '" target="_blank">' .

     

    nl2br(tep_output_string_protected(nl2br(tep_db_output($orders_history['track_num2']))

     

    )) . '</a>  ') .

     

    ' </td>' . "\n" .

    /* #CHAVEIRO3# Tracking end*/

    ' </tr>' . "\n";

    }

    } else {

    echo ' <tr>' . "\n" .

    ' <td class="smallText" colspan="5">' . TEXT_NO_ORDER_HISTORY . '</td>' . "\n" .

    ' </tr>' . "\n";

    }

    ?>

    </table></td>

    </tr>

    <tr>

    <td class="main"><br>

    <b><?php echo TABLE_HEADING_COMMENTS; ?></b></td>

    </tr>

    <tr>

    <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td>

    </tr>

    <tr><?php echo tep_draw_form('status', FILENAME_ORDERS, tep_get_all_get_params(array('action')) . 'action=update_order'); ?>

    <td class="main"><?php echo tep_draw_textarea_field('comments', 'soft', '60', '5'); ?></td>

    </tr>

    <?php

    /* #CHAVEIRO3# Tracking begin*/

    ?>

    <tr>

    <td class="main"><br>

    <b><?php echo TABLE_HEADING_TRACKING; ?></b></td>

    </tr>

    <tr>

    <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td>

    </tr>

    <tr>

    <td class="smallText"><b><?php echo TABLE_HEADING_TRACK1;

     

    ?></b> <?php echo tep_draw_input_field('track_num', '', 'size=/"20/"');

     

    ?>  <b><?php echo TABLE_HEADING_TRACK2; ?></b> <?php echo

     

    tep_draw_input_field('track_num2', '', 'size=/"20/"'); ?>  <b></td>

    </tr>

    <?php

    /* #CHAVEIRO3# Tracking end*/

    ?>

    <tr>

    <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>

    </tr>

    <tr>

     

    <td>

     

    <table border="0" cellspacing="0" cellpadding="2">

    <tr>

     

    <td>

     

    <table border="0" cellspacing="0" cellpadding="2">

    <tr>

    <td class="main"><b><?php echo ENTRY_STATUS; ?></b> <?php echo tep_draw_pull_down_menu('status', $orders_statuses, $order->info['orders_status']); ?></td>

    </tr>

    <tr>

    <td class="main"><b><?php echo ENTRY_NOTIFY_CUSTOMER; ?></b> <?php echo tep_draw_checkbox_field('notify', '', true); ?></td>

    <td class="main"><b><?php echo ENTRY_NOTIFY_COMMENTS; ?></b> <?php echo tep_draw_checkbox_field('notify_comments', '', true); ?></td>

     

    <?php

    /* #CHAVEIRO3# Tracking begin*/

    ?>

    <td class="main"><b><?php echo ENTRY_NOTIFY_TRACKING;

     

    ?></b> <?php echo tep_draw_checkbox_field('notify_tracking', '', true); ?></td>

    <?php

    /* #CHAVEIRO3# Tracking end*/

    ?>

    </tr>

    </table></td>

    <td valign="top"><?php echo tep_image_submit('button_update.gif', IMAGE_UPDATE); ?>

    </td>

     

    </tr>

     

    </table>

    </td>

     

    </form>

     

    </tr>

     

    <tr>

    <td colspan="2" align="right"><?php echo '<a href="javascript:popupWindow(\'' . (HTTP_SERVER . DIR_WS_ADMIN . FILENAME_ORDERS_INVOICE) . '?' . (tep_get_all_get_params(array('oID')) . 'oID=' . $HTTP_GET_VARS['oID']) . '\')">' . tep_image_button('button_invoice.gif', IMAGE_ORDERS_INVOICE) . '</a><a href="javascript:popupWindow(\'' . (HTTP_SERVER . DIR_WS_ADMIN . FILENAME_ORDERS_PACKINGSLIP) . '?' . (tep_get_all_get_params(array('oID')) . 'oID=' . $HTTP_GET_VARS['oID']) . '\')">' . tep_image_button('button_packingslip.gif', IMAGE_ORDERS_PACKINGSLIP) . '</a><a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action'))) . '">' . tep_image_button('button_back.gif', IMAGE_BACK) . '</a>'; ?></td>

    </tr>

    <?php

    } else {

    ?>

    <tr>

    <td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0">

    <tr>

    <td class="pageHeading"><?php echo HEADING_TITLE; ?></td>

    <td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', 1, HEADING_IMAGE_HEIGHT); ?></td>

    <td align="right"><table border="0" width="100%" cellspacing="0" cellpadding="0">

    <tr><?php echo tep_draw_form('orders', FILENAME_ORDERS, '', 'get'); ?>

    <td class="smallText" align="right"><?php echo HEADING_TITLE_SEARCH . ' ' . tep_draw_input_field('oID', '', 'size="12"') . tep_draw_hidden_field('action', 'edit'); ?></td>

    </form>

    </tr>

    <tr><?php echo tep_draw_form('status', FILENAME_ORDERS, '', 'get'); ?>

    <td class="smallText" align="right"><?php echo HEADING_TITLE_STATUS . ' ' . tep_draw_pull_down_menu('status', array_merge(array(array('id' => '', 'text' => TEXT_ALL_ORDERS)), $orders_statuses), '', 'onChange="this.form.submit();"'); ?></td>

    </form>

    </tr>

    </table></td>

    </tr>

    </table></td>

    </tr>

    <tr>

    <td><table border="0" width="100%" cellspacing="0" cellpadding="0">

    <tr>

    <tr>

    <td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">

    <?php

    $HEADING_CUSTOMERS = TABLE_HEADING_CUSTOMERS;

    $HEADING_CUSTOMERS .= '<a href="' . $_SERVER['PHP_SELF'] . '?sort=customer&order=ascending">';

    $HEADING_CUSTOMERS .= ' <img src="images/arrow_up.gif" border="0"></a>';

    $HEADING_CUSTOMERS .= '<a href="' . $_SERVER['PHP_SELF'] . '?sort=customer&order=decending">';

    $HEADING_CUSTOMERS .= ' <img src="images/arrow_down.gif" border="0"></a>';

    $HEADING_DATE_PURCHASED = TABLE_HEADING_DATE_PURCHASED;

    $HEADING_DATE_PURCHASED .= '<a href="' . $_SERVER['PHP_SELF'] . '?sort=date&order=ascending">';

    $HEADING_DATE_PURCHASED .= ' <img src="images/arrow_up.gif" border="0"></a>';

    $HEADING_DATE_PURCHASED .= '<a href="' . $_SERVER['PHP_SELF'] . '?sort=date&order=decending">';

    $HEADING_DATE_PURCHASED .= ' <img src="images/arrow_down.gif" border="0"></a>';

    ?>

    <tr class="dataTableHeadingRow">

    <?php // ====> BOF: ORDERS AT-A-GLANCE <==== ?>

    <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_ORDERNUM; ?></td>

    <?php // ====> BEOF: ORDERS AT-A-GLANCE <==== ?>

    <td class="dataTableHeadingContent"><?php echo $HEADING_CUSTOMERS; ?></td>

    <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ORDER_TOTAL; ?></td>

    <td class="dataTableHeadingContent" align="center"><?php echo $HEADING_DATE_PURCHASED; ?></td>

    <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_STATUS; ?></td>

    <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ACTION; ?> </td>

    </tr>

    <?php

    $sortorder = 'order by ';

    if($_GET["sort"] == 'customer') {

    if($_GET["order"] == 'ascending') {

    $sortorder .= 'o.customers_name asc, ';

    } else {

    $sortorder .= 'o.customers_name desc, ';

    }

    } elseif($_GET["sort"] == 'date') {

    if($_GET["order"] == 'ascending') {

    $sortorder .= 'o.date_purchased asc, ';

    } else {

    $sortorder .= 'o.date_purchased desc, ';

    }

    }

    $sortorder .= 'o.orders_id DESC';

    if (isset($HTTP_GET_VARS['cID'])) {

    $cID = tep_db_prepare_input($HTTP_GET_VARS['cID']);

    $orders_query_raw = "select o.orders_id, o.customers_name, o.customers_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.customers_id = '" . (int)$cID . "' and o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and ot.class = 'ot_total' order by orders_id DESC";

    } elseif (isset($HTTP_GET_VARS['status']) && (tep_not_null($HTTP_GET_VARS['status']))) {

    $status = tep_db_prepare_input($HTTP_GET_VARS['status']);

    $orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and s.orders_status_id = '" . (int)$status . "' and ot.class = 'ot_total' order by o.orders_id DESC";

    } else {

    $orders_query_raw = "select o.orders_id, o.customers_name, o.customers_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and ot.class = 'ot_total' " . $sortorder;

    }

    $orders_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_BESLAU_GRAND_ECRAN, $orders_query_raw, $orders_query_numrows);

    $orders_query = tep_db_query($orders_query_raw);

    while ($orders = tep_db_fetch_array($orders_query)) {

    if ((!isset($HTTP_GET_VARS['oID']) || (isset($HTTP_GET_VARS['oID']) && ($HTTP_GET_VARS['oID'] == $orders['orders_id']))) && !isset($oInfo)) {

    $oInfo = new objectInfo($orders);

    }

     

    if (isset($oInfo) && is_object($oInfo) && ($orders['orders_id'] == $oInfo->orders_id)) {

    echo ' <tr id="defaultSelected" class="dataTableRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=edit') . '\'">' . "\n";

    } else {

    echo ' <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID')) . 'oID=' . $orders['orders_id']) . '\'">' . "\n";

    }

    ?>

    <?php

    // ====> BOF: ORDERS AT-A-GLANCE <==== ?>

    <td class="dataTableContent" align="center"><b><?php echo $orders['orders_id'];

     

    $artikel = "";

    $num = 1;

    $result_artikels = tep_db_query("select products_name, products_quantity from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . tep_db_input($orders['orders_id']) . "' ");

    while($row_artikels = tep_db_fetch_array($result_artikels))

    {

    $artikel .= ($row_artikels["products_quantity"]) . "x " . ($row_artikels["products_name"]) . "<br>";

    $num++;

    }

    {

    $parsedComment = explode("\r", $artikel);

    $cleanComment = "";

    $i=0;

    while($i < count($parsedComment)) {

    $cleanComment .= trim($parsedComment[$i]);

    $i++;

    if ($i < count($parsedComment)) $cleanComment .= '<br \> ';

    }

    ?>

    <script language="javascript"><!--

    document.write('<?php echo '<a href="javascript:void(0);" onmouseover="return overlib(\\\'' . $cleanComment . '\\\');" onmouseout="return nd();"><img src="images/icons/comment2.gif" align="top" border=0></a> '; ?>');

    --></script>

     

    <?php } ?></b></a>

     

    <?php // ====> EOF: ORDERS AT-A-GLANCE <==== ?>

    <td class="dataTableContent"><?php echo '<a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action')) . 'oID=' . $orders['orders_id'] . '&action=edit') . '">' . tep_image(DIR_WS_ICONS . 'preview.gif', ICON_PREVIEW) . '</a> ' . $orders['customers_name']; ?></td>

    <td class="dataTableContent" align="right"><?php echo strip_tags($orders['order_total']); ?></td>

    <td class="dataTableContent" align="center"><?php echo tep_datetime_short($orders['date_purchased']); ?></td>

    <td class="dataTableContent" align="right"><?php echo $orders['orders_status_name']; ?></td>

    <td class="dataTableContent" align="right"><?php if (isset($oInfo) && is_object($oInfo) && ($orders['orders_id'] == $oInfo->orders_id)) { echo tep_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', ''); } else { echo '<a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID')) . 'oID=' . $orders['orders_id']) . '">' . tep_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . '</a>'; } ?>

     </td>

    </tr>

    <?php

    }

    ?>

    <tr>

    <td colspan="5"><table border="0" width="100%" cellspacing="0" cellpadding="2">

    <tr>

    <td class="smallText" valign="top"><?php echo $orders_split->display_count($orders_query_numrows, MAX_DISPLAY_BESLAU_GRAND_ECRAN, $HTTP_GET_VARS['page'], TEXT_DISPLAY_NUMBER_OF_ORDERS); ?></td>

    <td class="smallText" align="right"><?php echo $orders_split->display_links($orders_query_numrows, MAX_DISPLAY_BESLAU_GRAND_ECRAN, MAX_DISPLAY_PAGE_LINKS, $HTTP_GET_VARS['page'], tep_get_all_get_params(array('page', 'oID', 'action'))); ?></td>

    </tr>

    </table></td>

    </tr>

    </table></td>

    <?php

    $heading = array();

    $contents = array();

     

    switch ($action) {

    case 'delete':

    $heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_DELETE_ORDER . '</b>');

     

    $contents = array('form' => tep_draw_form('orders', FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=deleteconfirm'));

    $contents[] = array('text' => TEXT_INFO_DELETE_INTRO . '<br><br>');

    $contents[] = array('text' => TEXT_INFO_DELETE_DATA . ' ' . $oInfo->customers_name . '<br>');

    $contents[] = array('text' => TEXT_INFO_DELETE_DATA_OID . ' <b>' . $oInfo->orders_id . '</b><br>');

    $contents[] = array('text' => '<br>' . tep_draw_checkbox_field('restock') . ' ' . TEXT_INFO_RESTOCK_PRODUCT_QUANTITY);

    $contents[] = array('align' => 'center', 'text' => '<br>' . tep_image_submit('button_delete.gif', IMAGE_DELETE) . ' <a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');

    break;

     

     

    default:

    if (isset($oInfo) && is_object($oInfo)) {

    $heading[] = array('text' => '<b>[' . $oInfo->orders_id . ']  ' . tep_datetime_short($oInfo->date_purchased) . '</b>');

     

    // $contents[] = array('align' => 'center', 'text' => '<a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=edit') . '">' . tep_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=delete') . '">' . tep_image_button('button_delete.gif', IMAGE_DELETE) . '</a>');

     

     

     

    // $contents[] = array('text' => '<br>' . TEXT_DATE_ORDER_CREATED . ' ' . tep_date_short($oInfo->date_purchased));

     

     

    if (tep_not_null($oInfo->last_modified)) $contents[] = array('text' => TEXT_DATE_ORDER_LAST_MODIFIED . ' ' . tep_date_short($oInfo->last_modified));

    $contents[] = array('align' => 'center', 'text' => '<a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=edit') . '">' . tep_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=delete') . '">' . tep_image_button('button_delete.gif', IMAGE_DELETE) . '</a> <a href="' . tep_href_link(FILENAME_EDIT_ORDERS, 'oID=' . $oInfo->orders_id). '">' . tep_image_button('button_update.gif', IMAGE_UPDATE) . '</a>');

     

    $contents[] = array('align' => 'center', 'text' => '<a href="' . tep_href_link(FILENAME_ORDERS_INVOICE, 'oID=' . $oInfo->orders_id) . '" TARGET="_blank">' . tep_image_button('button_invoice.gif', IMAGE_ORDERS_INVOICE) . '</a> <a href="' . tep_href_link(FILENAME_ORDERS_PACKINGSLIP, 'oID=' . $oInfo->orders_id) . '" TARGET="_blank">' . tep_image_button('button_packingslip.gif', IMAGE_ORDERS_PACKINGSLIP) . '</a>');

    // $contents[] = array('align' => 'center', '

×