Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

[Contribution] Admin Notes


PopTheTop

Recommended Posts

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 by chooch

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

  • Replies 185
  • Created
  • Last Reply

Top Posters In This Topic

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 :-)

 

 

Yes, that is very possible but I do not have the time to do it right now.

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

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

Link to comment
Share on other sites

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

 

You have to call the $cInfo->customers_notes from the customers database table in addition to the tables in orders.

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

  • 4 weeks later...

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]

Link to comment
Share on other sites

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";

 

:)

Link to comment
Share on other sites

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

 

toosmall.PNG

Link to comment
Share on other sites

  • 2 weeks later...
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.

Link to comment
Share on other sites

  • 2 weeks later...

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!!

Link to comment
Share on other sites

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 by Victro
Link to comment
Share on other sites

  • 3 weeks later...

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

Link to comment
Share on other sites

  • 1 month later...
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

Link to comment
Share on other sites

  • 1 month later...

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.

My Contributions

 

Henry Smith

Link to comment
Share on other sites

  • 1 month later...
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:

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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 by eww
Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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 by eww
Link to comment
Share on other sites

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', '

Link to comment
Share on other sites

: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?

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...