Order Delivery Date Support Thread

[Maccon]

Hey, im getting TABLE_HEADING_DELIVERY_DATE displayed on checkout stages instead of the Desired delivery date text - anyone any ideas why or how to fix this??

cheers

[Maccon]

never mind...stupid mistake on my part!!! all fixed!

[MhawSayar]

Your database probably doesn't have the "zen_" prefix on each table.

Try the attached SQL file..

I got the same problem and now I fixed it with the help your guide.

Thank you so much mrmeech! Much appreciate!!

This plugin is really great and work awesome. And thanks for contribution of those useful plugin for community!!

If you don't mind, I'd like to request some additional feature for future release. It's about delivery time. I think it will really helpful for some sensitive products shops (eg, flowers shop.. etc).

I attached screen shoot from one online shop.

Wish all of the best for you. Thanks in advance!

[MhawSayar]

Friends!! A whole page and a half of responses happened and i didn't receive a notification of a new post until today!!! How that happend, i have no clue. But it's the truth!

Anyway, i DO have a variation with a time feature that will work, but is NOT implemented in the best way.

Here's the 2 cents of background on why the time part is little "ghetto-implemented": Basically when i went to do this i COULD NOT get the javascript to consistently merge the date with the time and have it insert into the database as a "datetime" record. I ran into huge problems with the fact that the zen's checkout uses css buttons combined with a function to call/create the "continue" button image. Additionally, when i went to use a pre-made date and time picker javascript object, i couldn't get that to work either. Forgive me!!

I will attach the package as is, which should work (provided you don't have any other checkout mods already installed). In it you will see commented out code from when i was feverishly trying to get a smooth datetime feature working.

You are going to have to add times to the array - currently there is just 12:30 and 1:30, and the format must be in 24-hour format. You'll see when you get there. You can find it on the includes/templates/YOUR_TEMPLATE/template/tpl_checkout_shipping_default.php. It's around line 140 and looks like this:

<!-- Bof Order Delivery Date -->
<fieldset class="shipping" id="delivery_date_details">
<legend><?php echo TABLE_HEADING_DELIVERY_DATE; ?></legend>

<label for="delivery_date_details">Date:</label>

<input readonly="readonly" id="date" name="order_delivery_date_day" type="text">

<select id="order_delivery_date_time" name="order_delivery_date_time">
<option value="">Select Delivery Time</option>
<option value="12:30:00">12:30pm</option>
<option value="13:30:00">1:30pm</option>
</select>
</fieldset>

THIS IS IMPORTANT:
BACK UP YOUR DATABASE FIRST!!!
If you have this installed already, you will need to alter the zen_orders table in the database. You *SHOULD* be able to just rename the row "order_deliver_date" to "order_delivery_date_day" and change the type from datetime to date. (I'm *pretty sure* this will preserve the date data, but don't hold me to it!) Then you need to add another row called "order_delivery_date_time" and make the type as just "time".
The SQL file is attached, which should work if you haven't installed the Mod yet at all.

And finally, KEEP THIS IN MIND: A number of months ago i read (i think) Ajeh's (who is a zen cart official) response to someone asking when the next version of zen cart (1.4) will be out, and the answer was basically some time before the end of december 2008 - WHICH IS VERY SOON (assuming they are still on track). Although not in their roadmap, it is likely that the checkout code will be changed.

Because of the 48kb limit on file uploads i had to split/zip up the package. Make a folder called includes and decompress the following in there: Classes.zip, languages.zip, modules.zip, templates.zip

Let me know how this works out for everyone.

Wow! I didn't see that! Great update and thanks for that. I'll test and come back here for feedback.

Just let me know one thing, I already installed this mod v2.2 (Only Date version) in my site. Do I need to remove it before re-installing with this one (Date & Time mod)? Or how can I install this new one without removing old? Just overwrite all old files? (sql, admin, email, includes..etc)

[I've no zen prefix in my database.]

Cheer! Thanks in advance!

[mrmeech]

...I already installed this mod v2.2 (Only Date version) in my site. Do I need to remove it before re-installing with this one (Date & Time mod)? Or how can I install this new one without removing old? Just overwrite all old files? (sql, admin, email, includes..etc)

[I've no zen prefix in my database.]

The date with time version uses different database row names than the date-only version. These steps should provide you a rather easy roadmap for moving from version w/o date to the version WITH the date:

1. Do NOT do this on a live site. And when you do, back up your site and database!!!
2. log in to your database for your zen cart store via PHPmyAdmin
3. Select the "Orders" table from the list of tables on the left.
4. Scroll down to the bottom of the table, where you will see "order_delivery_date"
5. Click on the pencil icon (it will say "change" when you hover over it)
6. Rename it from "order_delivery_date" to "order_delivery_date_day" and click save.
7. THEN copy and paste the SQL statement that is zipped up and attached to this post into an query window in PHPmyAdmin (you can access it via the button icons on the top of the left frame).
8. Overwrite delivery date files with the delivery date w/time files.
9. Test!

Hopefully that goes smoothly for ya!

[MhawSayar]

The date with time version uses different database row names than the date-only version. These steps should provide you a rather easy roadmap for moving from version w/o date to the version WITH the date:

[*]Do NOT do this on a live site. And when you do, back up your site and database!!![*]log in to your database for your zen cart store via PHPmyAdmin
...................
Hopefully that goes smoothly for ya!

Thank you so much for really quick reply Mr Meech!!

Very clear instructions and really great help for me!!! I followed your instructions exactly and now installation is finished smoothly without any problems! Work Awesome!

Again appreciate for your works and helping others! You are the great man!

Wish all of the best for you!!


[I installed this modified version mod into my Online shop test version, and I edit to add some additional time intervals. I attach screenshoot to show how it's working Awesome!]

[plbs]

mrmeech, awesome mod!

However, I've had two issues. Fixed one, still stumped on the other.

1) I noticed that, if you place and complete an order with a selected delivery date, then in the same session place a second order, but leave the delivery date blank, the 2nd order will store the same delivery date that you entered on the first order.

Figured out that this was due to the Order Delivery Date being stored in a session variable, along with other order-related data, but that (unless I screwed up the install!), the delivery date session variable is never cleared like the others are. So, I made the following change to includs\modules\pages\checkout_process\header_php.php ...

// unregister session variables used during checkout
unset($_SESSION['sendto']);
unset($_SESSION['billto']);
unset($_SESSION['shipping']);
unset($_SESSION['payment']);
unset($_SESSION['comments']);
unset($_SESSION['order_delivery_date']); //<- added this line
$order_total_modules->clear_posts();//ICW ADDED FOR CREDIT CLASS SYSTEM


That seemed to fix the problem.

2. If a customer doesn't select a delivery date, I've verified that the field is NULL in the table. The date is also blank in all relevant emails. However, on the Admin Orders pages, any orders with a blank (NULL) delivery date appear with the delivery date 11/30/1999. Again, if a date WAS selected, the correct date appears. But if a date was NOT selected, and the table field is NULL, then the date 11/30/1999 appears, rather that it just being blank.

Any ideas on this one?

Thanks!
Steve

[plbs]

Well, I'm a PHP and ZC newb, so I don't know if this is the ideal solution, but I did come up with a fix for my #2 problem above.

I edited admin\includes\function\general.php, specifically the three date conversion functions, zen_date_long, zen_date_short, and zen_datetime_short

Each of those starts with an if ... return false statement to trap essentially blank input. It was trapping '0001-01-01 00:00:00' as a "blank" date, but I found that my NULL date field was actually evaluating to "0000-00-00" as a string. So I added another OR to each of those IF statements:

function zen_date_long($raw_date) {
if ( ($raw_date == '0001-01-01 00:00:00') || ($raw_date == '0000-00-00') || ($raw_date == '') ) return false; //<-- edited this line



function zen_date_short($raw_date) {
if ( ($raw_date == '0001-01-01 00:00:00') || ($raw_date == '0000-00-00') || ($raw_date == '') ) return false; //<-- edited this line



function zen_datetime_short($raw_datetime) {
if ( ($raw_datetime == '0001-01-01 00:00:00') || ($raw_datetime == '0000-00-00') || ($raw_datetime == '') ) return false; //<-- edited this line



Again, don't know if this is the optimal way to fix, but it has worked. Now, if there is no delivery date entered on an order, that field is simply blank on the Admin orders table, edit order page, invoice, packing slip, etc.

If there's a better, or more Zen-compliant way to do this, please advise!

Thanks,
Steve

[cpixi]

Hi MrMeech- really appreciate the mod. It works like a charm, but could you give a newbie php user a little advice on requiring the date instead of just requesting it?

My guess is to write an if else clause on the tpl_checkout_payment_default.php page directing the customer back to the shipping page if they do not enter in a date.

Any help is much appreciated....

[gbrown77]

Ok, I am a little new to Zen Cart, but I have 2 clients who need this mod, both have different requirements, one is a flower delivery company, they would like to be able to schedule day and time.

Client #2 is an activity company how needs to schedule things like helicopter rides, and scuba diving. They need to schedule when things are going to happen.

I was wondering if anyone has made one message that describes "Here is how to install, configure etc." I have been trying to read thru all #159 messages, but some are 3 years old.

I would be happy to post a page on one of my websites which would gives all the instructions.

I am using Zen Cart 1.3.8a

Just so you know, I have downloaded all the files installed them, but I can not figure out how to get it to run, I go thru the order process and it never asks me when to deliver? The files are all there, but no mod.

Could someone act as if you did not have to read all the threads, and just say, download this, back up DB, and install these then here is how to test, config, etc?

Thanks

George