chooch Posted September 5, 2005 Share Posted September 5, 2005 (edited) hi i just wanted to know if anyone can help out.... after installing the admin notes mod, is it possible that certain cations by the admin can be added to the customer notes automatically? in other words both of the following can be done but the second is by far the easiest way: i) admin sends 25% discount coupon via email to customer. the admin then goes to admin notes, customer details and manually types it down to keep track of what he has given and to whom. ii) admin sends 25% discount voucher to customer and when the 'submit' button is pressed it not only send the discount voucher but also send the details of the email (whole or part, along with ccgv details including date of expiry for cert etc) to the customer notes or admin notes this is very handy for when individual emails are sent out with customer specific information - IF it can be updated automatically when submit is pressed as the database exists this could be done using simple instructions - please advise thanks :-) Edited September 5, 2005 by chooch Quote Upon receiving fixes and advice, too many people don't bother to post updates informing the forum of how it went. Until of course they need help again on other issues and they come running back! Why receive the information you require in good faith for free, only to then have the attitude to ignore the people who gave it to you? There's no harm in saying, 'Thanks, it worked'. On the contrary, it creates a better atmosphere. CHOOCH Link to comment Share on other sites More sharing options...
PopTheTop Posted September 9, 2005 Author Share Posted September 9, 2005 hi i just wanted to know if anyone can help out.... after installing the admin notes mod, is it possible that certain cations by the admin can be added to the customer notes automatically? in other words both of the following can be done but the second is by far the easiest way: i) admin sends 25% discount coupon via email to customer. the admin then goes to admin notes, customer details and manually types it down to keep track of what he has given and to whom. ii) admin sends 25% discount voucher to customer and when the 'submit' button is pressed it not only send the discount voucher but also send the details of the email (whole or part, along with ccgv details including date of expiry for cert etc) to the customer notes or admin notes this is very handy for when individual emails are sent out with customer specific information - IF it can be updated automatically when submit is pressed as the database exists this could be done using simple instructions - please advise thanks :-) <{POST_SNAPBACK}> Yes, that is very possible but I do not have the time to do it right now. Quote L8r, PopTheTop Published osC Contributions: - eCheck Payment Module v3.1 - Reviews in Product Display v2.0 - Fancier Invoice & Packingslip v6.1 - Admin Notes / Customer Notes v2.2 - Customer Zip & State Validation v2.2 - Search Box with Dropdown Category Menu v1.0 Pop your camper's top today! It's a popup thing... You wouldn't understand Link to comment Share on other sites More sharing options...
wolfalex Posted September 17, 2005 Share Posted September 17, 2005 Hi, I would like to see the Customer Notes on the order page, like it is done in the customer.php file. But I don't know how to do that. I have inserted this code in orders.php: $contents[] = array('text' => '<hr width="100%" size="1" color="#000000" noshade>'); $contents[] = array('text' => '<strong>Customer Notes:</strong><br><br>' . $cInfo->customers_notes); Now it shows me the line "CUSTOMER NOTES" on the right table on the orders page, but without the entrys from the customers. I don't how to get the information from the customers out of the SQL Table. Can somebody please help me? Alex Wolf Quote Link to comment Share on other sites More sharing options...
PopTheTop Posted September 17, 2005 Author Share Posted September 17, 2005 Hi, I would like to see the Customer Notes on the order page, like it is done in the customer.php file. But I don't know how to do that. I have inserted this code in orders.php: $contents[] = array('text' => '<hr width="100%" size="1" color="#000000" noshade>'); ? ? ? $contents[] = array('text' => '<strong>Customer Notes:</strong><br><br>' . $cInfo->customers_notes); ? Now it shows me the line "CUSTOMER NOTES" on the right table on the orders page, but without the entrys from the customers. I don't how to get the information from the customers out of the SQL Table. Can somebody please help me? Alex Wolf <{POST_SNAPBACK}> You have to call the $cInfo->customers_notes from the customers database table in addition to the tables in orders. Quote L8r, PopTheTop Published osC Contributions: - eCheck Payment Module v3.1 - Reviews in Product Display v2.0 - Fancier Invoice & Packingslip v6.1 - Admin Notes / Customer Notes v2.2 - Customer Zip & State Validation v2.2 - Search Box with Dropdown Category Menu v1.0 Pop your camper's top today! It's a popup thing... You wouldn't understand Link to comment Share on other sites More sharing options...
Guest Posted October 14, 2005 Share Posted October 14, 2005 i do not have this: $search = "where c.customers_lastname like '%" . $keywords . "%' or c.customers_firstname like '%" . $keywords . "%' or c.customers_email_address like '%" . $keywords . "%'"; } $customers_query_raw = "select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, a.entry_country_id from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id " . $search . " order by $order"; closest thing: $search = "where c.customers_lastname like '%" . $keywords . "%' or c.customers_firstname like '%" . $keywords . "%' or c.customers_email_address like '%" . $keywords . "%'"; } $customers_query_raw = "select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, a.entry_country_id from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id " . $search . " order by c.customers_lastname, c.customers_firstname"; when i replace that line, i get: 1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'limit 0, 20' at line 1 select c.customers_notes, c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, a.entry_country_id from customers c left join address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id order by limit 0, 20 [TEP STOP] Quote Link to comment Share on other sites More sharing options...
Guest Posted October 14, 2005 Share Posted October 14, 2005 was able to fix my problem by ignoring this instruction: $search = "where c.customers_lastname like '%" . $keywords . "%' or c.customers_firstname like '%" . $keywords . "%' or c.customers_email_address like '%" . $keywords . "%'"; } $customers_query_raw = "select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, a.entry_country_id from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id " . $search . " order by $order"; and simply adding the c.customers_notes to the original line, like so: $search = "where c.customers_lastname like '%" . $keywords . "%' or c.customers_firstname like '%" . $keywords . "%' or c.customers_email_address like '%" . $keywords . "%'"; } $customers_query_raw = "select c.customers_notes, c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, a.entry_country_id from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id " . $search . " order by $order"; :) Quote Link to comment Share on other sites More sharing options...
Guest Posted October 16, 2005 Share Posted October 16, 2005 I want to make the customer notes box bigger, if anyone out there can help me i would be very greatfull. my company logs call records. so if a customer calls back again the agent needs to read all the call notes back and reading in a little box doesnt display much maybe 2 or 3 x bigger would be great, if anyone can help it would be great thanks Jay Quote Link to comment Share on other sites More sharing options...
adx Posted October 30, 2005 Share Posted October 30, 2005 I think this contribution is fantastic, if only i could get it to work. The customer end works like a dream. No problems there. The problem is when i click into admin notes from tools i get this error. Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /home/globalda/public_html/test/admin/admin_notes.php on line 278 Warning: reset() [function.reset]: Passed variable is not an array or object in /home/globalda/public_html/test/admin/includes/classes/object_info.php on line 17 Warning: Variable passed to each() is not an array or object in /home/globalda/public_html/test/admin/includes/classes/object_info.php on line 18 I can add new notes but i can't delete them. Can anybody help with his as i am desperate for this to work. I am using Milestone 2.2 Thanks in advance. I've the same problem as djmatrix. In trial and error solution, I've edit admin_notes.php on line 278 : $sInfo_array = array_merge($admin_quer, ' '); to $sInfo_array = array_merge($admin_quer); All 3 errors gone and now I can edit, delete, etc..etc.. Question, what's the purpose of that ' ' ? By removing that piece, will it break this contrib somewhere? Thanks. Quote Link to comment Share on other sites More sharing options...
Huitzilopochtli Posted November 10, 2005 Share Posted November 10, 2005 Hi there! many thanks for this great app!! I'm using admin_notes as some sort of WEBLOG, in order to have all of the information stored in one place, we need to keep the business running! 1) Has anyone of you any idea, how I could modify admin_notes to see the date when a message was added or modified in the mainview, in order to be able to sort it that way? Newest on top, for example? 2) Another nice thing wold be to allow comments on each topic, like in a real Weblog! Keep up the good work!! Quote Link to comment Share on other sites More sharing options...
Victro Posted November 15, 2005 Share Posted November 15, 2005 (edited) Hello there, I like this contribution a lot and everything is working great. I have one question that would make the contribution even better for me: Is there a way to show the customer notes in 'account.php' so that every customer can see there notes that the admin made for them when they are logged in? For example, if a customer gets 10% discount, i want to let them know by using an extra field in account.php showing the notes i made for them. :thumbsup: thanks in advance guys. gr. Victro Edited November 15, 2005 by Victro Quote Link to comment Share on other sites More sharing options...
mafiouso Posted December 1, 2005 Share Posted December 1, 2005 Hello I was looking for a mod to give a little more control over the customer listings. the early versions of this mod seem to be what im after. is there any other contibs simular to this? i try install the new ver but don?t want ADMIN_NOTES. is there a easy way to remove it? open to some ideas Thanks Quote Link to comment Share on other sites More sharing options...
gscreations Posted January 4, 2006 Share Posted January 4, 2006 I've the same problem as djmatrix. In trial and error solution, I've edit admin_notes.php on line 278 : $sInfo_array = array_merge($admin_quer, ' '); to $sInfo_array = array_merge($admin_quer); All 3 errors gone and now I can edit, delete, etc..etc.. Question, what's the purpose of that ' ' ? By removing that piece, will it break this contrib somewhere? Thanks. Yes I've got the same errors too, anyone know what onther contrib could be conflicting with this one ? I've done the same as above, but obviously any calls to that array are failing, eg not passing sID through buttons, not displaying Name in right column when deleting etc.. I've fixed the passing of variables through buttons for now by grabbing the sID from url string. But i'd prefer to have this contrib working as it does with everyone else, why exactly are you merging an array with an empty string ? and how can array_merge do this ? surely its for merging 2 arrays not one array and an empty string ? Any help would be nice, adx, djmatrix did you solve this error or find what other contrib was conflicting with this one ?? ps cant really give list on contribs ive installed there are far too many Quote Link to comment Share on other sites More sharing options...
custodian Posted February 22, 2006 Share Posted February 22, 2006 adx, wow.. I've juest sent the last two hours picking through my logs, and admin notes code. Your post did the trick for me. I was able to do everythign except delete... Now all is better Kudos! Henry I've the same problem as djmatrix. In trial and error solution, I've edit admin_notes.php on line 278 : $sInfo_array = array_merge($admin_quer, ' '); to $sInfo_array = array_merge($admin_quer); All 3 errors gone and now I can edit, delete, etc..etc.. Question, what's the purpose of that ' ' ? By removing that piece, will it break this contrib somewhere? Thanks. Quote My Contributions Henry Smith Link to comment Share on other sites More sharing options...
Guest Posted March 25, 2006 Share Posted March 25, 2006 Hi, I would like to see the Customer Notes on the order page, like it is done in the customer.php file. But I don't know how to do that. I have inserted this code in orders.php: $contents[] = array('text' => '<hr width="100%" size="1" color="#000000" noshade>'); $contents[] = array('text' => '<strong>Customer Notes:</strong><br><br>' . $cInfo->customers_notes); Now it shows me the line "CUSTOMER NOTES" on the right table on the orders page, but without the entrys from the customers. I don't how to get the information from the customers out of the SQL Table. Can somebody please help me? Alex Wolf i just updated this contribution to put the customer notes on admin/orders.php... had a use for it myself :thumbsup: Quote Link to comment Share on other sites More sharing options...
xavkick Posted March 25, 2006 Share Posted March 25, 2006 i just updated this contribution to put the customer notes on admin/orders.php... had a use for it myself :thumbsup: i have take your contribution but it's not working.. i can see the word customer notes but nothing after. thanks xav Quote Link to comment Share on other sites More sharing options...
Guest Posted March 26, 2006 Share Posted March 26, 2006 did you add any customer notes for the particular customer? if there are no notes for that customer, all you will see is: Notes: Quote Link to comment Share on other sites More sharing options...
wolfalex Posted March 26, 2006 Share Posted March 26, 2006 hi same problem, doesn't show any notes for a customer. It only shows NOTES. Alex Quote Link to comment Share on other sites More sharing options...
Guest Posted March 26, 2006 Share Posted March 26, 2006 i will do another fresh install on my test site and post results shortly Quote Link to comment Share on other sites More sharing options...
Guest Posted March 26, 2006 Share Posted March 26, 2006 (edited) just tested on two sites, both ended with success. can you post your admin/orders.php file? ps. can you see the notes on the customers -> (search for a name) -> edit / you should see them toward the very bottom, below newsletter Edited March 26, 2006 by eww Quote Link to comment Share on other sites More sharing options...
custodian Posted March 26, 2006 Share Posted March 26, 2006 If you click on the customer you want and select edit and go into their account details.. at the bottom of the screen you don't see a text box to enter the notes? Quote My Contributions Henry Smith Link to comment Share on other sites More sharing options...
insomniac2 Posted March 26, 2006 Share Posted March 26, 2006 Here is what I have done and it works well. It will not show the customer notes box if there are no admin notes. At the top of orders.php FIND: 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 = '" . $oID . "'"); $order_exists = true; if (!tep_db_num_rows($orders_query)) { $order_exists = false; $messageStack->add(sprintf(ERROR_ORDER_DOES_NOT_EXIST, $oID), 'error'); } } BELOW ABOVE CODE ADD: // BEGIN added queries for extra customer information $customers_query = tep_db_query("select c.customers_id, c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_dob, c.customers_email_address, a.entry_company, a.entry_street_address, a.entry_suburb, a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id, a.entry_country_id, a.entry_telephone, a.entry_fax, c.customers_newsletter, c.customers_default_address_id, c.customers_notes from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a on c.customers_default_address_id = a.address_book_id where a.customers_id = c.customers_id and c.customers_id = '" . (int)$HTTP_GET_VARS['cID'] . "'"); $customers = tep_db_fetch_array($customers_query); // END added queries for extra customer information NOW ADD THIS CODE WHERE YOU WANT: <?php if (tep_not_null($customers['customers_notes'])) { ?> <tr> <td class="main"><font color="FF0000"><b><?php echo ENTRY_ADMIN_CUSTOMER_NOTES; ?></b></font> <?php echo $customers['customers_notes']; ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <?php } ?> I ADDED THE ABOVE CODE JUST BEFORE: <tr> <td><table border="0" cellspacing="0" cellpadding="2"> <tr> <td class="main"><b><?php echo ENTRY_PAYMENT_METHOD; ?></b> <?php echo $order->info['payment_method']; ?></td> </tr> NOW JUST ADD THIS DEFINE TO admin/includes/languages/english/orders.php define('ENTRY_ADMIN_CUSTOMER_NOTES', 'Admin Customer Notes:'); Hope this helps you out. Quote Link to comment Share on other sites More sharing options...
Guest Posted March 26, 2006 Share Posted March 26, 2006 (edited) where did you get the codes from: f (($action == 'edit') && isset($HTTP_GET_VARS['oID'])) { $oID = tep_db_prepare_input($HTTP_GET_VARS['oID']); and on? those weren't my edits :P try this where you have: <td class="main"><font color="FF0000"><b><?php echo ENTRY_ADMIN_CUSTOMER_NOTES; ?></b></font> <?php echo $customers['customers_notes']; ?></td> change to: <tr> <td class="main"><?php echo ENTRY_CUSTOMER_NOTES; ?></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 tried to make the add-on as easiest possible with minimal edits, so it was best to just make a separate call for the notes. Edited March 26, 2006 by eww Quote Link to comment Share on other sites More sharing options...
xavkick Posted March 27, 2006 Share Posted March 27, 2006 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,resizable=yes,copyhistory=no,width=650,height=500,screenX=150,screenY=150,top=150,left=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 queryecho $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', ' Quote Link to comment Share on other sites More sharing options...
custodian Posted March 27, 2006 Share Posted March 27, 2006 Is that you entire file? I have atleast another 25 lines in my file after where you left off? Did you just snip it, or was that all of it? Quote My Contributions Henry Smith Link to comment Share on other sites More sharing options...
Guest Posted March 27, 2006 Share Posted March 27, 2006 :lol: sorry, insomniac2 - i just now realized you weren't the one complaining it didn't work custodian, i think the forum snips posts after a certain character amount. xavkick, i see you have the code here: <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> which should work. before we further investigate, can you read mine & custodian's previous few posts and see if you can view the notes on the page specified? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.