HOW TO: Add a desired shipping date field to order form [description]

**Desciption how to add a drop down list with desired delivery date to your order form [for Zen Cart 1.3.7]
**
Note: in the following description I use the table prefix zen_
If you have no prefix, or another then you'll have to change it yourself.
The file & directory names were taken from a local Win XP + XAMPP environment. At linux webhosting all "" should be the other way "/" :smile:

Note2: I have to check the email confirmation.
The desired order date seems to be missing in the email confirmation.

1. Add field to zen_orders table

 ALTER TABLE zen_orders ADD order_delivery_date date AFTER ip_address;
```**
* FRONT-END ***

**2. tpl_checkout_shipping_default.php**
File: includes\templates\classic\templates\tpl_checkout_shipping_default.php
In the checkout form I added a dropdown field with dates.
Note that I excluded some dates (1st & 2nd Christmas day and 1st January) because there won't be any deliveries.
Just before <fieldset class="shipping" id="comments"> I added:

<fieldset class="shipping" id="delivery_date"> <legend><?php echo TABLE_HEADING_DELIVERY_DATE; ?></legend> <select name="delivery_date"> <?php for ($i=0, $n=50; $i < $n; $i++) { $now[$i] = strtotime ("+$i day", time()); if ( strftime ("%w",$now[$i])<>0 AND strftime ("%m-%d",$now[$i])<>"12-25" AND strftime ("%m-%d",$now[$i])<>"12-26" AND strftime ("%m-%d",$now[$i])<>"01-01" ){ echo '<option value="'.strftime ("%Y-%m-%d",$now[$i]).'">'.strftime ("%A %d %B %Y",$now[$i]).'</option>'; } } ?> </select> </fieldset> ```**3. order.php** File: \includes\classes\order.php I added the order_delivery_date field in some queries: ``` $order_query = "select customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, payment_module_code, shipping_method, shipping_module_code, coupon_code, cc_type, cc_owner, cc_number, cc_expires, currency, currency_value, date_purchased, orders_status, last_modified, order_total, order_tax, ip_address from " . TABLE_ORDERS . " where orders_id = '" . (int)$order_id . "'"; ```the last 3 lines: ``` date_purchased, orders_status, last_modified, order_total, order_tax, ip_address, order_delivery_date from " . TABLE_ORDERS . " where orders_id = '" . (int)$order_id . "'"; ```and

$this->info = array('currency' => $order->fields['currency'],
'currency_value' => $order->fields['currency_value'],
'payment_method' => $order->fields['payment_method'],
'payment_module_code' => $order->fields['payment_module_code'],
'shipping_method' => $order->fields['shipping_method'],
'shipping_module_code' => $order->fields['shipping_module_code'],
'coupon_code' => $order->fields['coupon_code'],
'cc_type' => $order->fields['cc_type'],
'cc_owner' => $order->fields['cc_owner'],
'cc_number' => $order->fields['cc_number'],
'cc_expires' => $order->fields['cc_expires'],
'date_purchased' => $order->fields['date_purchased'],
'orders_status' => $order_status->fields['orders_status_name'],
'last_modified' => $order->fields['last_modified'],
'total' => $order->fields['order_total'],
'tax' => $order->fields['order_tax'],
'ip_address' => $order->fields['ip_address']
);
```the last 3 lines:

'ip_address' => $order->fields['ip_address'],
'delivery_date' => $order->fields['delivery_date']
);

$this->info = array('order_status' => DEFAULT_ORDERS_STATUS_ID,
'currency' => $_SESSION['currency'],
'currency_value' => $currencies->currencies[$_SESSION['currency']]['value'],
'payment_method' => $GLOBALS[$class]->title,
'payment_module_code' => $GLOBALS[$class]->code,
'coupon_code' => $coupon_code->fields['coupon_code'],
// 'cc_type' => (isset($GLOBALS['cc_type']) ? $GLOBALS['cc_type'] : ''),
// 'cc_owner' => (isset($GLOBALS['cc_owner']) ? $GLOBALS['cc_owner'] : ''),
// 'cc_number' => (isset($GLOBALS['cc_number']) ? $GLOBALS['cc_number'] : ''),
// 'cc_expires' => (isset($GLOBALS['cc_expires']) ? $GLOBALS['cc_expires'] : ''),
// 'cc_cvv' => (isset($GLOBALS['cc_cvv']) ? $GLOBALS['cc_cvv'] : ''),
'shipping_method' => $_SESSION['shipping']['title'],
'shipping_module_code' => $_SESSION['shipping']['id'],
'shipping_cost' => $_SESSION['shipping']['cost'],
'subtotal' => 0,
'tax' => 0,
'total' => 0,
'tax_groups' => array(),
'comments' => (isset($_SESSION['comments']) ? $_SESSION['comments'] : ''),
'ip_address' => $_SESSION['customers_ip_address'] . ' - ' . $_SERVER['REMOTE_ADDR']
);

'ip_address' => $_SESSION['customers_ip_address'] . ' - ' . $_SERVER['REMOTE_ADDR'],
'delivery_date' => $_SESSION['delivery_date']
);

'ip_address' => $_SESSION['customers_ip_address'] . ' - ' . $_SERVER['REMOTE_ADDR']
);

zen_db_perform(TABLE_ORDERS, $sql_data_array);

'ip_address' => $_SESSION['customers_ip_address'] . ' - ' . $_SERVER['REMOTE_ADDR'],
'delivery_date' => $this->info['delivery_date']
);

zen_db_perform(TABLE_ORDERS, $sql_data_array);

File:    \includes\modules\pages\checkout_shipping\header_php.php
I added some lines of code after:

if (isset($_SESSION['comments'])) {
$comments = $_SESSION['comments'];
}

if (isset($_SESSION['delivery_date'])) {
$delivery_date = $_SESSION['delivery_date'];
}

$comments = $_SESSION['comments'];

if (zen_not_null($_POST['delivery_date'])) {
  $_SESSION['delivery_date'] = zen_db_prepare_input($_POST['delivery_date']);
}
$delivery_date = $_SESSION['delivery_date'];

File:    \includes\languages\english\checkout_shipping.php
For every language you'll have to insert:

define('TABLE_HEADING_DELIVERY_DATE', 'Desired Delivery Date');

**6. order.php**
File: \admin\includes\classes\order.php
I added to:

$order = $db->Execute("select cc_cvv, customers_name, customers_company, customers_street_address,
customers_suburb, customers_city, customers_postcode, customers_id,
customers_state, customers_country, customers_telephone,
customers_email_address, customers_address_format_id, delivery_name,
delivery_company, delivery_street_address, delivery_suburb,
delivery_city, delivery_postcode, delivery_state, delivery_country,
delivery_address_format_id, billing_name, billing_company,
billing_street_address, billing_suburb, billing_city, billing_postcode,
billing_state, billing_country, billing_address_format_id,
coupon_code, payment_method, payment_module_code, shipping_method, shipping_module_code,
cc_type, cc_owner, cc_number, cc_expires, currency,
currency_value, date_purchased, orders_status, last_modified,
order_total, order_tax, ip_address

order_total, order_tax, ip_address, order_delivery_date

$this->info = array('currency' => $order->fields['currency'],
'currency_value' => $order->fields['currency_value'],
'payment_method' => $order->fields['payment_method'],
'payment_module_code' => $order->fields['payment_module_code'],
'shipping_method' => $order->fields['shipping_method'],
'shipping_module_code' => $order->fields['shipping_module_code'],
'coupon_code' => $order->fields['coupon_code'],
'cc_type' => $order->fields['cc_type'],
'cc_owner' => $order->fields['cc_owner'],
'cc_number' => $order->fields['cc_number'],
'cc_cvv' => $order->fields['cc_cvv'],
'cc_expires' => $order->fields['cc_expires'],
'date_purchased' => $order->fields['date_purchased'],
'orders_status' => $order->fields['orders_status'],
'total' => $order->fields['order_total'],
'tax' => $order->fields['order_tax'],
'last_modified' => $order->fields['last_modified'],
'ip_address' => $order->fields['ip_address']
);

'ip_address' => $order->fields['ip_address'],
'delivery_date' => $order->fields['order_delivery_date']
);

File:    \admin\orders.php

I changed:

EMAIL_TEXT_DATE_ORDERED . ' ' . zen_date_long($check_status->fields['date_purchased']) . "\n\n" .
strip_tags($notify_comments) .

EMAIL_TEXT_DATE_ORDERED . ' ' . zen_date_long($check_status->fields['date_purchased']) . "\n\n" .
EMAIL_TEXT_DELIVERY_DATE . ' ' . zen_date_long($check_status->fields[' delivery_date']) . "\n\n" .
strip_tags($notify_comments) .

$html_msg['EMAIL_TEXT_DATE_ORDERED'] = EMAIL_TEXT_DATE_ORDERED . ' ' . zen_date_long($check_status->fields['date_purchased']);
$html_msg['EMAIL_TEXT_STATUS_COMMENTS'] = nl2br($notify_comments);

$html_msg['EMAIL_TEXT_DATE_ORDERED'] = EMAIL_TEXT_DATE_ORDERED . ' ' . zen_date_long($check_status->fields['date_purchased']);
$html_msg['EMAIL_TEXT_DELIVERY_DATE'] = EMAIL_TEXT_DELIVERY_DATE . ' ' . zen_date_long($check_status->fields['delivery_date']);
$html_msg['EMAIL_TEXT_STATUS_COMMENTS'] = nl2br($notify_comments);

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

    <tr>
       <td class="main"><strong><?php echo ENTRY_DATE_PURCHASED; ?></strong></td>
       <td class="main"><?php echo zen_date_long($order->info['date_purchased']); ?></td>
    </tr>
    <tr>
       <td class="main"><strong><?php echo ENTRY_DELIVERY_DATE; ?></strong></td>
       <td class="main"><?php echo zen_date_long($order->info['delivery_date']); ?></td>
    </tr>

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

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

            <td class="dataTableContent" align="center"><?php echo zen_datetime_short($orders->fields['date_purchased']); ?></td>
            <td class="dataTableContent" align="right"><?php echo $orders->fields['orders_status_name']; ?></td>

            <td class="dataTableContent" align="center"><?php echo zen_datetime_short($orders->fields['date_purchased']); ?></td>
            <td class="dataTableContent" align="center"><?php echo zen_datetime_short($orders->fields['order_delivery_date']); ?></td>
            <td class="dataTableContent" align="right"><?php echo $orders->fields['orders_status_name']; ?></td>

  $orders_query_raw = "select o.orders_id, o.customers_id, o.customers_name, o.payment_method, o.shipping_method, o.date_purchased, o.last_modified,

  $orders_query_raw = "select o.orders_id, o.customers_id, o.customers_name, o.payment_method, o.shipping_method, o.date_purchased, o.order_delivery_date, o.last_modified,

  $orders_query_raw = "select o.orders_id, o.customers_id, o.customers_name, o.payment_method, o.shipping_method, o.date_purchased, o.last_modified,

  $orders_query_raw = "select o.orders_id, o.customers_id, o.customers_name, o.payment_method, o.shipping_method, o.date_purchased, o.order_delivery_date, o.last_modified,

  $orders_query_raw = "select o.orders_id, o.customers_id, o.customers_name, o.payment_method, o.shipping_method, o.date_purchased, o.last_modified,

  $orders_query_raw = "select o.orders_id, o.customers_id, o.customers_name, o.payment_method, o.shipping_method, o.date_purchased, o.order_delivery_date, o.last_modified,

File:    \admin\invoice.php
I changed

$order_check = $db->Execute("select cc_cvv, customers_name, customers_company, customers_street_address,
customers_suburb, customers_city, customers_postcode,
customers_state, customers_country, customers_telephone,
customers_email_address, customers_address_format_id, delivery_name,
delivery_company, delivery_street_address, delivery_suburb,
delivery_city, delivery_postcode, delivery_state, delivery_country,
delivery_address_format_id, billing_name, billing_company,
billing_street_address, billing_suburb, billing_city, billing_postcode,
billing_state, billing_country, billing_address_format_id,
payment_method, cc_type, cc_owner, cc_number, cc_expires, currency,
currency_value, date_purchased, orders_status, last_modified

currency_value, date_purchased, orders_status, last_modified, order_delivery_date

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

  <tr>
    <td class="main"><strong><?php echo ENTRY_DATE_PURCHASED; ?></strong></td>
    <td class="main"><?php echo zen_date_long($order->info['date_purchased']); ?></td>
  </tr>
  <tr>
    <td class="main"><strong><?php echo ENTRY_DELIVERY_DATE; ?></strong></td>
    <td class="main"><?php echo zen_date_long($order->info['delivery_date']); ?></td>
  </tr>

File:    \admin\packingslip.php
In:

$order_check = $db->Execute("select cc_cvv, customers_name, customers_company, customers_street_address,
customers_suburb, customers_city, customers_postcode,
customers_state, customers_country, customers_telephone,
customers_email_address, customers_address_format_id, delivery_name,
delivery_company, delivery_street_address, delivery_suburb,
delivery_city, delivery_postcode, delivery_state, delivery_country,
delivery_address_format_id, billing_name, billing_company,
billing_street_address, billing_suburb, billing_city, billing_postcode,
billing_state, billing_country, billing_address_format_id,
payment_method, cc_type, cc_owner, cc_number, cc_expires, currency,
currency_value, date_purchased, orders_status, last_modified

currency_value, date_purchased, orders_status, last_modified, order_delivery_date

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

  <tr>
    <td class="main"><strong><?php echo ENTRY_DATE_PURCHASED; ?></strong></td>
    <td class="main"><?php echo zen_date_long($order->info['date_purchased']); ?></td>
  </tr>
  <tr>
    <td class="main"><strong><?php echo ENTRY_DELIVERY_DATE; ?></strong></td>
    <td class="main"><?php echo zen_date_long($order->info['delivery_date']); ?></td>
  </tr>

File:    \includes\languages\english\orders.php
add:

define('TABLE_HEADING_DELIVERY_DATE', 'Desired Delivery Date');
define('ENTRY_DELIVERY_DATE', 'Desired Delivery Date:');

File:    \includes\languages\english\invoice.php
add:

define('ENTRY_DELIVERY_DATE', 'Desired Delivery Date:');

File:    \includes\languages\english\packingslip.php
add:

define('ENTRY_DELIVERY_DATE', 'Desired Delivery Date:');

I am trying to send the desired delivery date in the email messages, but it's still not working.
Here follows a description for the changes I made so far.
**
*** First of all I have change all references in the description above from ****delivery_date ****to order_delivery_date ! *****

13. email order status
File \email\email_template_order_status.html

changed:

    <div>$EMAIL_TEXT_DATE_ORDERED</div>
    <div>$EMAIL_TEXT_STATUS_COMMENTS</div>
```into:
> <div>$EMAIL_TEXT_DATE_ORDERED</div>
>     <div>$EMAIL_TEXT_DELIVERY_DATE</div>
>     <div>$EMAIL_TEXT_STATUS_COMMENTS</div>**

14. order class**
File: \includes\classes\order.php

EMAIL_TEXT_DATE_ORDERED . ' ' . strftime(DATE_FORMAT_LONG) . "\n" .
EMAIL_TEXT_INVOICE_URL . ' ' . zen_href_link(FILENAME_ACCOUNT_HISTORY_INFO, 'order_id=' . $zf_insert_id, 'SSL', false) . "\n\n";

EMAIL_TEXT_DATE_ORDERED . ' ' . strftime(DATE_FORMAT_LONG) . "\n" .
EMAIL_TEXT_DELIVERY_DATE . ' ' . zen_date_long($check_status->fields['order_delivery_date']) . "\n\n" .
EMAIL_TEXT_INVOICE_URL . ' ' . zen_href_link(FILENAME_ACCOUNT_HISTORY_INFO, 'order_id=' . $zf_insert_id, 'SSL', false) . "\n\n";

File: \includes\languages\english\checkout_process.php
add

define('EMAIL_TEXT_DELIVERY_DATE', 'Desired Delivery Date:');

File: \includes\languages\english\orders.php
add

define('EMAIL_TEXT_DELIVERY_DATE', 'Desired Delivery Date:');

17. order.php**
File: includes\classes\order.php

EMAIL_TEXT_DATE_ORDERED . ' ' . strftime(DATE_FORMAT_LONG) . "\n" .
EMAIL_TEXT_INVOICE_URL . ' ' . zen_href_link(FILENAME_ACCOUNT_HISTORY_INFO, 'order_id=' . $zf_insert_id, 'SSL', false) . "\n\n";

EMAIL_TEXT_DATE_ORDERED . ' ' . strftime(DATE_FORMAT_LONG) . "\n" .
EMAIL_TEXT_DELIVERY_DATE . ' ' . zen_db_output($this->info['order_delivery_date']) . "\n\n" .
EMAIL_TEXT_INVOICE_URL . ' ' . zen_href_link(FILENAME_ACCOUNT_HISTORY_INFO, 'order_id=' . $zf_insert_id, 'SSL', false) . "\n\n";

    $sql_data_array = array('orders_id' => $insert_id,
                            'orders_status_id' => $this->info['order_status'],
                            'date_added' => 'now()',
                            'customer_notified' => $customer_notification,
                            'comments' => $this->info['comments']);
```changed into:
```
    $sql_data_array = array('orders_id' => $insert_id,
                            'orders_status_id' => $this->info['order_status'],
                            'date_added' => 'now()',
                            'order_delivery_date' => $this->info['order_delivery_date']);
                            'customer_notified' => $customer_notification,
                            'comments' => $this->info['comments']);
```**18. orders.php in admin back-end**
File: \admin\orders.php
```
          $check_status = $db->Execute("select customers_name, customers_email_address, orders_status,
                                      date_purchased, order_delivery_date from " . TABLE_ORDERS . "
                                      where orders_id = '" . $_GET['oID'] . "'");
```into:
```
          $check_status = $db->Execute("select customers_name, customers_email_address, orders_status,
                                      date_purchased, order_delivery_date from " . TABLE_ORDERS . "
                                      where orders_id = '" . $_GET['oID'] . "'");
```

Ok, I had to make a couple of additional changes in order to get the confirmation email with date working correctly!
Sorry for the confusion!

BTW: The email sent from the back-end (in admin/orders.php e.g. after change of status) does not contain the date.
Instead there's an empty space....
Hopefully does someone else know a solution...

19. orders in back-end
File: \admin\orders.php

          // adjust download_maxdays based on current date
          $check_status = $db->Execute("select customers_name, customers_email_address, orders_status,
                                      date_purchased, order_delivery_date from " . TABLE_ORDERS . "
                                      where orders_id = '" . $_GET['oID'] . "'");
```changed into:

      // adjust download_maxdays based on current date
      $check_status = $db->Execute("select customers_name, customers_email_address, orders_status,
                                  date_purchased from " . TABLE_ORDERS . "
                                  where orders_id = '" . $_GET['oID'] . "'");

File: includes\classes\order.php

$sql_data_array = array('orders_id' => $insert_id,
                        'orders_status_id' => $this->info['order_status'],
                        'date_added' => 'now()',
                        'order_delivery_date' => $this->info['order_delivery_date'],
                        'customer_notified' => $customer_notification,
                        'comments' => $this->info['comments']);

$sql_data_array = array('orders_id' => $insert_id,
                        'orders_status_id' => $this->info['order_status'],
                        'date_added' => 'now()',
                        'customer_notified' => $customer_notification,
                        'comments' => $this->info['comments']);

Thanks for posting this. I know alot of zenners have been waiting for someone to work this one out! I have a few questions.

1. In #10 the file mentioned \includes\languages\english\orders.php - I don't have that file, but I do have that file in the admin directory (admin\includes\languages\english\orders.php). Is that the one you mean?
2. How would I remove Saturday as a shipping date?
3. Would it be possible to add a Cancel date as well? Most wholesale companies have that.
4. Will you be also adding the field to Account history order page that a customer sees when they are logged in and looking at their orders?

dreamz:

In #10 the file mentioned \includes\languages\english\orders.php - I don't have that file, but I do have that file in the admin directory (admin\includes\languages\english\orders.php). Is that the one you mean?
Yes, I do indeed mean the language file in \admin
thank you for your correction!

How would I remove Saturday as a shipping date?You'll have to change the part strftime ("%A %d %B %Y",$now[$i])
in the file tpl_checkout_shipping_default.php (See step 2. Front-end )
Remove the "%A" because it displays the "full weekday name according to the current locale" (see the php.net documentation for strftime at http://php.net/manual/en/function.strftime.php )

Would it be possible to add a Cancel date as well? Most wholesale companies have that.Probably. I don't know this functionality. Maybe you could elaborate on this: how should a cancel date be implemented in the order process, and how does it work?

Will you be also adding the field to Account history order page that a customer sees when they are logged in and looking at their orders?I haven't found the time for that yet.

A cancel date is usually coupled with a ship date in wholesale orders. That is - it is a window of time where the purchase can be shipped within. I guess it would just be a second field very much like order_delivery_date, but it would be order_cancel_date.

The only difference I see between the two fields would be that order_cancel_date could not take place before order_delivery_date. One other option in the drop down for order_cancel_date and should default to is empty which would indicate no cancel date. That would make sense for orders that are not wholesale and/or do not require a cancel ship date.
Thanks, again!

Hi guys,
Have you managed the confirmation email issue regarding this feature??

Does anyone have a site that this mod is working on so I can see how it works?

I've tried this on 3.7.8 but it doesn't work.
Anyone tried this before?

Thanks

Based on this post and some others, I've posted net terms, start order date and start and cancel order date modules. You can find out more at Zen Cart Purchase Order System

Based on this and other modules for Net Terms, Start Order Date and Cancel Order Date, I've put together a little post on the subject. You can find it at Zen Cart Purchase Order System.

Please add your modules to the Downloads Section.

Bey12:

Based on this post and some others, I've posted net terms, start order date and start and cancel order date modules.

I concur with Kim - this is a fantastic (and simple) mod and will have a warm welcome to the downloads section.

It's now in the Downloads section over here

Included in the zip file are two folders with separate modules - one is for adding only the Ship Order Date and the other is to add both Ship Order and Cancel Order Date.

Great! I haven't had time yet to compile this into a distributable contribution.

Thanks for this contribution, James!

pe7er:

Great! I haven't had time yet to compile this into a distributable contribution.

Thanks for this contribution, James!

Hey Everyone -

I have applied this mod to a site and found that it still needs a bit of work - but it has an Excellent start!

So, first thing that i'd like to tackle is the fact that the emails are not including the delivery date.

I'm hopeing that someone would be able to explain how and where the email arrays are formed. Anyone?

mrmeech:

Hey Everyone -

I have applied this mod to a site and found that it still needs a bit of work - but it has an Excellent start!

So, first thing that i'd like to tackle is the fact that the emails are not including the delivery date.

I'm hopeing that someone would be able to explain how and where the email arrays are formed. Anyone?

I should clarify this post, as my problem is not very clear:

When order related emails are sent, the place where the delivery date information is supposed to be simply prints out on the email as: EMAIL_TEXT_DELIVERY_DATE

I am pretty sure the problem resides in the orders.php file either on the admin side or on the catalog side, but i cannot figure out why. I am not yet familiar with the email data-flow.

On the contrary, the order date information appears correctly on the order information (invoice, packing slip, edit order) pages when logged into the admin.

Any help or pointers would be greatly appreciated. :smile:

Well, i'm not sure if anyone is listening out there - but i just did a lot of work on this mod over the past two days and now have an updated version 100% ready to be uploaded. HOWEVER, i am waiting to upload it to the community - i wrote an email to Ajeh and Kim explain why i am not uploading it yet, and i will append that email to the end of this post for everyone to read and give their input. I do not want any hard feelings.

I've notated this all in the readme.txt file, but so that everyone knows what is ready to go:

HISTORY:

03/24/2008:
Updated to fix a number of issues in code and add a couple other features (By MrMeech):

• Added File (includes/templates/YOUR_TEMPLATE/templates/tpl_checkout_confirmation_default.php) - Added Delivery Date to display on checkout confirmation page
• Added File (includes/languages/english/YOUR_TEMPLATE/checkout_confirmation) - has Delivery Date define
• Added File (email/email_template_checkout.html) - to show delivery date on email generated during checkout, in addition to when orders are updated via Admin
• (admin/includes/classes/order.php) - Fixed "info" array "delivery_date" to "order_delivery_date" to match format of the rest of the array and unify all code references to the array. Also some code would reference "delivery_date" and some would reference "order_delivery_date", so everything is now "order_delivery_date".
• (admin/includes/languages/english/orders.php) - Added missing email define
• (admin/invoice.php) - Line 150 - changed to "order_delivery_date"
• (admin/orders.php) - Removed extra space in string and updated to correct path (line 108); Updated line 117 to "order_delivery_date" from "delivery_date"; Updated line 414 to reflect similar changes
• (admin/packingslip.php) - Line 147 updated to "order_delivery_date"
• (includes/classes/order.php) - Line 924 - Was missing the HTML variable for HTML email output
• Added contribution info to the comments at the top of every file (except the emails) for easier version tracking down the road.
• Updated this file (readme.txt)

03/13/2008:
First compiled release of this modification

02/13/2008:
Peter Martin's Post to the forum of the initial codeOk, now, for the email to Ajeh and Kim:

Kim (and now Linda, too!),

You haven't responded yet, but that's a good thing in this situation as i figured out how to update existing contributions.

However, i come to you now with a situation a little out of the norm - please read this message all the way through.

Based on this thread: http://www.zen-cart.com/forum/showthread.php?t=88550

...this contribution was born: http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_ id=961

Unfortunately this contribution seems to have been slapped together in hyperspeed and i really feel as if it should be split in two. Right now it contains both the "Ship Order Date" and "Cancel Order Date." Confusingly, the "Cancel Order Date" folder is supposed to include the ship order date folder mod... Aside from that, this mod is designed to add a DELIVERY date, not a SHIP date.

Additionally, If you compare on the two top-level directories ("ship-cancel date" and "ship date") you will find that, aside from the SQL query, they are identical (unless i'm crazy and missed something). My file compare program (Kdiff3) noted that the one template override file for the checkout differed, but upon viewing them, they were carbon copies of one another.

I have spent a number of hours looking at the code for this, and while it is 90% complete, it has a fatal last 10%, with errors that will translate all the way to email outputs. There are a handful of other mishaps in the code, but the purpose of this message is not to review all of them...

I have updated the code to work on my site, and now that i know where all of the errors are, it will take me only a few minutes to go back through the current contribution code to fix it for the community. I can have this ready to go in a day (since i'm pooped now and am calling it quits for the night).

So, this is what i propose:- >

• Renaming this contribution to "Order Delivery Date" - or delete/freeze this contribution to avoid the confusion that is likely going to ensue.

• Depending on the action that you take: If you rename the contribution, i will upload the fixed code directly to the contribution, or; If you delete/freeze the contribution, i will make a new one.

• I also really believe that a new support thread with a more relevant title (ie: "Order Delivery Date" instead of "Ship Date") should be formed - i will be glad to do this - just looking for backup on it.Please inform me of your thoughts on all of this and what plan of action you believe is best.

I was able to send email with delivery date as well in the admin as well.

In the orders.PHP, we have written

EMAIL_TEXT_DELIVERY_DATE . ' ' . zen_date_long($check_status->fields[' delivery_date']) . "\n\n"

but we did not add this field to the $checkstatus=$db->Execute

and one more thing, we did not define EMAIL_TEXT_DELIVERY_DATE under /admin/languages

It worked for me, if any qiestions I can be contacted [email protected] or 630-235-9772

Thank you pe7er for lot of coding there...

has anyone tested this with super orders?