Delivery TimeTable install?

[jacopo]

i post this here hoping that some of those sending me PM would find their ansnsers here..

 

i posted the Delivery TimeTable contributions here:

http://www.oscommerce.com/community/contributions,4530

 

there aren't detailed installation instruction for dummies.. i am sorry for that but i am not having the time to produce them.

 

anyway in the original file you'll find a SQL file and all the files needed.

 

on the file dated 18 Sep 2006 you'll find a list of those brand new files you only need to copy in the right directories, and those modified files in which you should find for the commented code to copy into yours.

 

if you use some FILE COMPARISON sofware, it should be a quite easy operation indeed.

 

at the same time, as i belive we all are enjoing this copperative enviroment,

i belive it would be very nice if any of you would like to contribute yourself, and find the time to create these missing instructructions for those who need them.

 

thank you very much

jacopo

[astan]

Good job, Jacopo! Congratulations. :thumbsup:

Very useful contribution for me.

 

I installed the contribution. Working well.

User can also 'book' a time-slot even before starting buying, to make sure that nobody will take over his desired timeslot while he's buying.

Question: We have two simultaneous shoppers and during the shopping both decide to reserve the same time for delivery (Let suppose that to that time we can delivery only to one customer). Both can select the same delivery time because none of them didn't finish the shopping. First customer finish the shopping and checkout. His shopping will be delivery to the selected time. When the second shopper want to checkout, he will find that his timeslot is busy. Can a user reserve his time slot before start / during shopping and to use it at checkout time (regardless if at the end the timeslot is busy), to avoid this disadvantage form the end of shopping (somebody was more quickly like him in checkout)?

How can a user 'book' a time-slot even before starting buying, to make sure that nobody will take over his desired timeslot while he's buying?

 

Thank you in advance for help.

[r_bobo23]

Good job, Jacopo! Congratulations. :thumbsup:

Very useful contribution for me.

 

I installed the contribution. Working well.

 

Question: We have two simultaneous shoppers and during the shopping both decide to reserve the same time for delivery (Let suppose that to that time we can delivery only to one customer). Both can select the same delivery time because none of them didn't finish the shopping. First customer finish the shopping and checkout. His shopping will be delivery to the selected time. When the second shopper want to checkout, he will find that his timeslot is busy. Can a user reserve his time slot before start / during shopping and to use it at checkout time (regardless if at the end the timeslot is busy), to avoid this disadvantage form the end of shopping (somebody was more quickly like him in checkout)?

How can a user 'book' a time-slot even before starting buying, to make sure that nobody will take over his desired timeslot while he's buying?

 

Thank you in advance for help.

 

Can you tell me how did you update the SQL Database??

[r_bobo23]

i post this here hoping that some of those sending me PM would find their ansnsers here..

 

i posted the Delivery TimeTable contributions here:

http://www.oscommerce.com/community/contributions,4530

 

there aren't detailed installation instruction for dummies.. i am sorry for that but i am not having the time to produce them.

 

anyway in the original file you'll find a SQL file and all the files needed.

 

on the file dated 18 Sep 2006 you'll find a list of those brand new files you only need to copy in the right directories, and those modified files in which you should find for the commented code to copy into yours.

 

if you use some FILE COMPARISON sofware, it should be a quite easy operation indeed.

 

at the same time, as i belive we all are enjoing this copperative enviroment,

i belive it would be very nice if any of you would like to contribute yourself, and find the time to create these missing instructructions for those who need them.

 

thank you very much

jacopo

 

Can you tell me how to update the MYSQL Database with the file attachted becasue I get the following message

 

1146 - Table 'rt.table_admin_files' doesn't exist

 

select admin_files_name from TABLE_ADMIN_FILES where FIND_IN_SET( '', admin_groups_id) and admin_files_is_boxes = '0' and admin_files_name = 'default_delivery_time.php'

 

[TEP STOP]

[breakbred101]

r_bobo

 

You need to open up the sql text file and just copy and paste it into your MySQL database

 

"Run SQL Query" box...

 

Simple as that, press the GO button and all the tables will create using the supplied SQL text document supplied with the contribution....

 

A big thanks goes out to jacopo for such a great flawless contribution....

 

Im having issues figuring out how to change my cost variables though. Currently they are set at Free, $1, $3, and $5 i need to change them to Free, $15, & $20 if any one can assist on this that would be great.

[breakbred101]

Figured out the answer to my own question, thought id pass it on for those as ignorant as myself...

 

To adjust the priceing of the delivery table you have to set the cost variables. The cost variables are located in

 

admin/default_delivery_time.php right around line 127

 

$costs[0] = array('id' => 0, 'text' =>'Y0');

$costs[1] = array('id' => 1, 'text' =>'Y1');

$costs[2] = array('id' => 2, 'text' =>'Y3');

$costs[2] = array('id' => 3, 'text' =>'Y5');

 

you have to modify the id variable and text variable, in my situation the edits are below

 

$costs[0] = array('id' => 0, 'text' =>'$Free');

$costs[1] = array('id' => 15, 'text' =>'$15');

$costs[2] = array('id' => 20, 'text' =>'$20'