Product Date Option - Restricted by Dates in Database

Hello,

In my OC shop, there are a handful of products that allow customers to reserve specific tours. At the moment, I have added some javascript code to my theme's product.tpl file to disable days of jQuery's datepicker, based on a list of entries I manually add to an array.

Ideally, I would love to be able to control which days are booked for each product with the OC admin, and then have the datepicker disable those dates automatically.

Does anyone have any tips on how to accomplish this?

Thanks for your help!
Mindy

I had taken a look at this extension, but I don't think it does what I need. I don't need something that tracks number of products purchased. I need to be able to log in and specify dates that are now unavailable for that particular product.

From the user's point of view, I need a pop-up calendar for a product that looks to a database table with future booked dates and disable those dates that are found. From my end, I need access to the database table to add/remove records to close/open dates.

I looked into adding an XML file to add the necessary Javascript code based on looping through items in a database, but I don't think it's possible to a) access a MySQL database and b) construct a for loop in XML.

Any other hints?

Thanks for your help!
Mindy

I had taken a look at this extension, but I don't think it does what I need. I don't need something that tracks number of products purchased. I need to be able to log in and specify dates that are now unavailable for that particular product.

That's just one thing OCreservation does

From the user's point of view, I need a pop-up calendar for a product that looks to a database table with future booked dates and disable those dates that are found. From my end, I need access to the database table to add/remove records to close/open dates.

That's excactly what OCreservation does

I looked into adding an XML file to add the necessary Javascript code based on looping through items in a database, but I don't think it's possible to a) access a MySQL database and b) construct a for loop in XML.

OCreservation uses a array from the database to disable these dates.

Hi Daik01,
Thank you for responding. But, in my investigating the demo again, I still don't see how this extension accomplishes what I'm looking for. Can you explain how the extension does what I need?
Mindy

RuralSquirrel wrote:Hello,

In my OC shop, there are a handful of products that allow customers to reserve specific tours. At the moment, I have added some javascript code to my theme's product.tpl file to disable days of jQuery's datepicker, based on a list of entries I manually add to an array.

Ideally, I would love to be able to control which days are booked for each product with the OC admin, and then have the datepicker disable those dates automatically.

Does anyone have any tips on how to accomplish this?

Thanks for your help!
Mindy

Please tell me how did you manually add to an array of disable days? I am a beginner, so please share with me in detail

hitlocke wrote:Please tell me how did you manually add to an array of disable days? I am a beginner, so please share with me in detail

@hitlocke: you seem to ask for an 45-100+ Dollar-Knowledge, so, just better don't expect anyone around here to assist you on such for free. Beginner or not, after all, you plan to create a Pro - Moneymaker.

http://www.opencart.com/index.php?route ... ch=booking
http://www.opencart.com/index.php?route ... eservation
http://www.opencart.com/index.php?route ... eservation

Nothing personal, just plain Information!
Ernie
openshop.li/shop/

IP_CAM wrote:

hitlocke wrote:Please tell me how did you manually add to an array of disable days? I am a beginner, so please share with me in detail

@hitlocke: you seem to ask for an 45-100+ Dollar-Knowledge, so, just better don't expect anyone around here to assist you on such for free. Beginner or not, after all, you plan to create a Pro - Moneymaker.

http://www.opencart.com/index.php?route ... ch=booking
http://www.opencart.com/index.php?route ... eservation
http://www.opencart.com/index.php?route ... eservation

Nothing personal, just plain Information!
Ernie
openshop.li/shop/

ok, that gave me a relief. I thought i had asked a silly question. it turned out to be a valuable one.

anyway, so that you know, i just need to disable 3 days off from the calendar, not something routine or expected to be recurring. i dont think i could spend such a huge amount to do this at the moment. upon my research, i need to be clear on which file to approach, either the product.tpl or bootstrap-datetimepicker.min.js. i read alot about the beforeShowDay, but it didnt bring much good.

'still hoping someone could help me out for free'

cheers

hitlocke wrote:

IP_CAM wrote:

hitlocke wrote:Please tell me how did you manually add to an array of disable days? I am a beginner, so please share with me in detail

@hitlocke: you seem to ask for an 45-100+ Dollar-Knowledge, so, just better don't expect anyone around here to assist you on such for free. Beginner or not, after all, you plan to create a Pro - Moneymaker.

http://www.opencart.com/index.php?route ... ch=booking
http://www.opencart.com/index.php?route ... eservation
http://www.opencart.com/index.php?route ... eservation

Nothing personal, just plain Information!
Ernie
openshop.li/shop/

ok, that gave me a relief. I thought i had asked a silly question. it turned out to be a valuable one.

anyway, so that you know, i just need to disable 3 days off from the calendar, not something routine or expected to be recurring. i dont think i could spend such a huge amount to do this at the moment. upon my research, i need to be clear on which file to approach, either the product.tpl or bootstrap-datetimepicker.min.js. i read alot about the beforeShowDay, but it didnt bring much good.

'still hoping someone could help me out for free'

cheers

Ahaaa, finally I have managed to find it myself. Thanks Ernie for the inspiration

Warm regards,

How did you solve that