Order Delivery Date Support Thread

jagall:

Hi All
I am using this mod with 1.3.9h and if a customer does not select a delivery date I get Tuesday 30 November, 1999 this as the date on the invoice. Any ideas anybody. thought perhaps I may not have my localtime set up properly???:huh:

having same problem with 1.3.9f any fix for this?

I don't believe this is a 1.3.9 issue, but, rather a mysql issue. When a date of "0000-00-00" is read, it is known to be an impossible date, so it is read out as the default date.

As I recall, there are two options. One is to find the location where the date is written to the orders table and set it to today's date if it is blank, 0, or null. The other is to find the locations where the date is read out, and if it is 0, don't include it.

Hi hoping someone can help me here. I have reinstalled the files a few times but yet the calendar will now show in either FF, IE or Chrome, only get the input box. Using 1.3.9h. The source reveals the following:
/includes/modules/pages/checkout_shipping/jscript_a-mootools.js,/includes/modules/pages/checkout_shipping/jscript_b-calendar.js&1341428085"></script>

Not sure what the addon bit is with the jscript_b-calendar.js file?

thanks guys.

OK this has been a HUGE help for me! The only thing I am trying to figure out with it, I need of they do not choose a date that it gives a error and makes them choose a date. Is there anything thats been done to fix this?

Thanks

Hi,

New user here, I have a question that I don't think has been asked, but here goes :-

I have installed the addon with no issues but I would like to know, is it possible to stop someone moving onto the next stage of checkout before they have selected a desired delivery date?

Thank you

Oh, just realised my request is the same as brandon's lol.

Is there a way to make this mod work with FEC?

I tried a few thing but no luck. It is either FEC without delivery date option or zen cart standard checkout with order delivery date.

Any suggestion?

Is there a way to make this mod work with FEC?

I tried a few thing but no luck. It is either FEC without delivery date option or zen cart standard checkout with order delivery date.

Any suggestion?

Hi,

I am using version 1.3.9 h, working on https://www.wellhallflorist.co.uk. Have the same problem as a few others where the calendar blocks out the next two days. i.e. today is the 13th, but I cannot select that or the 14th or the 15th. What can I do so the calendar will allow me to choose any date from today's date?

I have the same issue as several other posters and I can't see where the problem has been solved (possibly going blind at this stage)

The order_delivery_date calendar is working on the site and the selected delivery date appears in the email confirmation. However it does not get written to the database. The database values are all "0000-00-00". There has been a mod(not by me)to the original date format into the European d-m-y format. I am assuming that when zen cart attempts to write this date mysql does not like it and hence the 0000-00-00 values. I have looked around but can not find where the sql insert statement is performed. I am hoping to reformat the date data there and solve the problem. Can anyone tell me where the insert can be found. Perhaps it's not an insert... Thanks in advance

pjdub:

The order_delivery_date calendar is working on the site and the selected delivery date appears in the email confirmation. However it does not get written to the database. The database values are all "0000-00-00". There has been a mod(not by me)to the original date format into the European d-m-y format. I am assuming that when zen cart attempts to write this date mysql does not like it and hence the 0000-00-00 values. I have looked around but can not find where the sql insert statement is performed. I am hoping to reformat the date data there and solve the problem. Can anyone tell me where the insert can be found. Perhaps it's not an insert... Thanks in advance

Yes, MySQL is particular about the format of data being inserted into DATE or DATETIME fields. It expects information to be entered in UTF, YYYY-MM-DD (or YYYY-MM-DD HH:MM:SS), but can accept some other formats.

I do not know what has been edited or where when you converted dates to DD-MM-YYYY format for display, but you will want to convert it back to YYYY-MM-DD format for the insert statement. If a new variable was created for the new date format, then the easiest way to do this would be to use the original variable for the insert statement.

I gather that no version was ever put out that made the order date required on the shipping page. I went thru a number of php hoops trying to get something done with Dr. Byte's help and got no where. I'm thinking it has to be added to the javascript. Any one have any experience with this or has anyone figured out any way to make the date required?

Not having it required is what then gives you bizarre delivery dates in admin - the emails are probably being sent out without any delivery date at all.

I believe when I posted the newest version back in October that I didn't use the correct mootools. Has anyone had any problems with that version?

If someone will help with the required delivery date, I'll be glad to upload that as well.

weif:

Yes, MySQL is particular about the format of data being inserted into DATE or DATETIME fields. It expects information to be entered in UTF, YYYY-MM-DD (or YYYY-MM-DD HH:MM:SS), but can accept some other formats.

I do not know what has been edited or where when you converted dates to DD-MM-YYYY format for display, but you will want to convert it back to YYYY-MM-DD format for the insert statement. If a new variable was created for the new date format, then the easiest way to do this would be to use the original variable for the insert statement.

Thanks for the reply Weif. I persisted and found that the following works for what I require:

In includes\classes\order.php in the $sql_data_array around line 600
change
'order_delivery_date' => $this->info['order_delivery_date']
to
'order_delivery_date' => date("Y-m-d", strtotime($this->info['order_delivery_date']))

This worked for me. Dates are being written to the database in yyyy-mm-dd format and elsewhere the european formatting persists (not done by me so can't detail how it was done) Obviously this has nothing to do with null values nor no values being submitted in the delivery date. A problem for another day...

As to having the delivery date required - in includes/modules/checkout_shipping.php

change

//BEGIN Order Delivery Date
if (zen_not_null($_POST['order_delivery_date'])) {
  $_SESSION['order_delivery_date'] = zen_db_prepare_input($_POST['order_delivery_date']);
}
$order_delivery_date = $_SESSION['order_delivery_date'];	

// END Order Delivery Date

to

//BEGIN Order Delivery Date
if (zen_not_null($_POST['order_delivery_date'])) {
  $_SESSION['order_delivery_date'] = zen_db_prepare_input($_POST['order_delivery_date']);
} else {
   $messageStack->add_session('checkout_shipping', ERROR_PLEASE_CHOOSE_DELIVERY_DATE, 'error');
  
   zen_redirect(zen_href_link(FILENAME_CHECKOUT_SHIPPING, '', 'SSL'));
}
$order_delivery_date = $_SESSION['order_delivery_date'];	

// END Order Delivery Date

Add the error to the includes/language/english/your-template/checkout_shipping.php:

define('ERROR_PLEASE_CHOOSE_DELIVERY_DATE', 'Please choose a delivery date');

I have updated the mod and included a database setting to require or not require the delivery date. Also included the mootools version that works with IE9. I uploaded it to the plugins section a few minutes ago so it will take a little while to show up there.

Hi, I have a problem with this plugin.
I downloaded the last version (2.4) and it works fine the first time. Then I cannot see the calendar image on the checkout shipping page.
I had the previous version (2.3.2) and i didn't have any problem.
I test it on Internet Explorer 8 and Google Chrome 23.0.1271.97.
Please help me. I have to publish my site as soon as possible.
Thanks in advance.

The first time? Are you staying logged in, not finished the order, refreshing the page? How are you doing a second time?

The first time I put an order in my site without any problem. The calendar image appears on the checkout shipping page.
Then when I wanted to put another order, the calendar icon doesn't appear, so the order couldn't be finished.
I tried to solve it refreshing the page, login again, deleting my browsing history and finally re-installing the plugin but those actions didn't solve the problem.
My hosting is in godaddy and it is on Linux.

That is truly strange and I can't think of a reason why that would happen. It's just a javascript popup. I added in the database option to require it or not. Did you install that sql and make a choice? Just covering the bases of installation here.

delia:

That is truly strange and I can't think of a reason why that would happen. It's just a javascript popup. I added in the database option to require it or not. Did you install that sql and make a choice? Just covering the bases of installation here.

Yes, I install the sql required, so now I can set if delivery date is required or not.