Bookings module - current version 2.22 (see page 13)

[WebBird]

Hello there,

I made a simple bookings module to show free/booked times on a calendar page. You may see it in action here:

http://www.müritzklink.de/pages/buchungsstatus.php

This module works with WB 2.7 and 2.8.

Month sheets shown as list (one beneath the other) instead of columns in IE? See here how to fix this: http://www.websitebaker2.org/forum/index.php/topic,10218.msg71114.html#msg71114

Download from AMASP: http://www.websitebakers.com/pages/modules/calendar-and-time/bookings.php

[keesweb]

This is just the module I need, for a holiday house....

Unfortunately I get the notice: Unknown column 'bookings_id' in 'field list' when trying to add...

On the site the name of the months aren't mentioned...

[macsmet]

I get the same errors as keesweb mentioned.
Looks very promising though!

[WebBird]

Woops, seems I forgot to include the latest changes into the installer. I'll repair that soon!

[WebBird]

I've uploaded a corrected version.


Edit: For Download see below!

On the site the name of the months aren't mentioned...

Which language do you use? I've only included EN and DE.

[keesweb]

I'm using dutch... I sent you the dutch translation...

It's working fine. Two remarks

- lay out on some templates is not quite good
- only the current your is shown; how can we look at the next year?

Thanks,

Kees

[WebBird]

I'm using dutch... I sent you the dutch translation...

Wow, that's great, thanks a lot! I've included this in the new version now.

- lay out on some templates is not quite good

After some tests I found that there was a line break after the 6th month only, not each 3rd as I said. So using a smaller font, as you did, broke the layout. I've added an option to set this according to your own needs now. The default is still 6. Good values may be 3 or 4.

Please uninstall and reinstall the new version.

http://www.webing.de/webbird/cgi-bin/dtrack/dtrack.cgi?rc=real&file=Bookings%20Module%20for%20websitebaker%202.70

Other fixes:

* The header and footer settings were never used
* Maintainer in language modules were missing (comments)
* Same for frontend.css

- only the current your is shown; how can we look at the next year?

Just add "?year=<YYYY>" to the URI. Example:

http://www.golf-appartement-marbella.nl/pages/beschikbaarheid.php?year=2009

Thank you for trying!

WebBird

[keesweb]

It's working....

Thank you very much...

I made a hidden page with your booking module. Afterwarts menulinks to that page with the year (?year=2009).
It all works...

http://www.golf-appartement-marbella.nl/pages/verhuur/beschikbaarheid.php?year=2008 

In the backend you have 'Name (wird nicht angezeigt!): ' Has that any function? If so; the dutch translation is 'Naam (wordt niet getoond)..

[WebBird]

I'm happy to hear that the module works for you now. Your site looks good, by the way.

One final note: There are no consistency checks. That means, if you add a new date, it's not checked if it overlaps any existing entries.

In the backend you have 'Name (wird nicht angezeigt!): ' Has that any function? If so; the dutch translation is 'Naam (wordt niet getoond)..

It's for the Admin only. You can note the name of the guest there if you want. Thanks for the translation.

WebBird

[terrajohn]

Now the module only shows when a certain day is occupied, which is perfect for renting a house or so. But what if you would use this module for renting materials or specific meetingrooms or so
Is it possible to make a distinction between time-blocks (eg. morning, afternoon and evening). So you would have then a status of fully booked, partly available, all times available. This would mean that people needs to be able to click or something on the partly booked days to see what section of the day is occupied.
Would it be difficult to integrate such a functionality? I only know that as being a newbie I'm not capable to do

[WebBird]

This would be possible, but at the moment I'm not planning to add new features. I am sorry, but I don't have enough free time to do this at the moment. Maybe later.

Edit: Please feel free to drop me a note (maybe as PN) if you'd like to describe how it should look like. I'm afraid "time blocks" in the month tables would "splatter" the table, so I think a link to a special day view would be better.

[WebBird]

Raymond provided a patch to let you have an additional CSS class for the "month days" header. (This could only be done by ".bookings_sheet th { ... }" before.)

Here's the new version:

Edit: For download see below!

Many thanks to Raymond. 

[WebBird]

How about this?

[WebBird]

Hello,

I managed to add the "time" feature "terrajohn" asked for.  An improved version of the bookings module is available now.

New features and other changes:

* Removed month names from language modules (done by strftime now)
* In "year view", months are linked to get a "this month only" view
* In "year view", a link to previous year is added to the january month sheet, and a link to next year is added to the december month sheet
* In "single month view", there are links to next and previous month; the heading is linked back to "year view"
* If a time range is given, the day is linked to a "day view"; moving the mouse over a linked day gives the bookings as a "tooltip window" (done via CSS)
* In "day view", a back link is given to "single month" or "year view" (where you came from)
* "Day view" can be a list or a "calendar sheet"
* If "sheet" is chosen for "day view", a start and an end hour can be given in the settings to restrict output

Restrictions and known bugs:

* Time can only be set in 30 minute steps
* Incomplete NL translation

Download:

http://www.webing.de/webbird/cgi-bin/dtrack/dtrack.cgi?rc=real&file=bookings_v1.10.zip

Suggestions, bug reports and "hymns of praise"  are welcome.

[erpe]

Hi

Is it possible to update the module by installing another time?

rgds

erpe

[WebBird]

I would implement that if I'd know how...

So for the moment, the answer is "no". 

[erpe]

So that means:  unzip and uploading per ftp?

[WebBird]

Ahm, no, there are changes in the database, too.

I've added an upgrade.php to the archive now, but I'm not really sure if it works, so I'd suggest to test it before trying to install it on a "production server". (On my server, the version number is not updated in the "addons" table, don't know why...)

Unter all circumstances, backup your data before trying to upgrade!

To upgrade manually, do the following:

* Backup your data!
* Make a backup copy of the old "bookings" module directory
* Backup your data!
* Unzip the new one and copy it to the server
* Backup your data!
* Alter the mod_bookings_settin gs table (see below)
* Now it's too late to backup your data!
* Change the version number in the "addons" table to "1.10" (Edit: If you have installed the "Reload Add-Ons" Admin-Tool, you can do this by calling the mod.)

To alter the table, you'll have to execute the following statements:

ALTER TABLE <TABLE_PREFIX>mod_bookings_settin gs ADD `dateformat` VARCHAR(255) NOT NULL DEFAULT ''
ALTER TABLE <TABLE_PREFIX>mod_bookings_settin gs ADD `dayview` VARCHAR(50) NOT NULL DEFAULT ''
ALTER TABLE <TABLE_PREFIX>mod_bookings_settin gs ADD `daysheetheader` VARCHAR(255) NOT NULL DEFAULT ''
ALTER TABLE <TABLE_PREFIX>mod_bookings_settin gs ADD `daystarthour` TINYINT(4) NOT NULL DEFAULT ''
ALTER TABLE <TABLE_PREFIX>mod_bookings_settin gs ADD `dayendhour` TINYINT(4) NOT NULL DEFAULT ''

Hope this works.
You will have to change <TABLE_PREFIX> to your chosen prefix, of course.

[macsmet]

Hi there,

I don't find the upgrade.php in your zip file.
Maybe yoy forgot to add it?

Greetings,

MacSmet

[WebBird]

I don't find the upgrade.php in your zip file.
Maybe yoy forgot to add it?

Ahm, no, I accidentally named the ZIP-File wrong (bookings_1.10.zip instead of bookings_v1.10.zip). Please download again.

[erpe]

Hi WebBird

I downloaded 30 min ago and tried to install. No errormassages during installation.
But when I create a new side with this module, the following error appears:
Table wbmod_bookings_sett ings' doesn't exist


rgds

erpe

[aldus]

I must confirm this bug:
Install the modul, but the MySQL table within the settings "mod_bookings_settin gs" isn't installed/there.
But (!) "mod_bookings_dates" is!

MacOx 10.5.4 - MAMP 1.7.1 - PHP 5.2.5 - MySQL 5.0.41 - WB 2.7

Regards
Aldus

[WebBird]

Hm, I cannot reproduce this error. 

Edit:

Tested with:

WB 2.7.0, mySQL 4.1, PHP 5.2.5, with and without PREFIX

[aldus]

The mysth is: i've got no error-messages and zend says: php-script is ok;
and i also see no problematic lines ...
So - why (on earth) one table is installed correctly - one failed ...

Regards
Aldus

[WebBird]

The problem was that mySQL 5 does not allow DEFAULT to be empty with TINYINT column type. I corrected this now.