Classroom booking System

[Bev]

I had set up the subjects as departments, and would like to be able to see bookings by subject/department. But for the moment I will rely on the staff entering their subject in the use field. I can manage a bit of SQL to retrieve the data later.

 

Thanks for the system, it was pretty easy to install and it looks great.

[timbo343]

@webman i might have asked this question before but is there any way to get classroombookings integrated with AD rather than staff having separate logins? Would be really cool if this could be done.

 

Thanks

Edited December 15, 2015 by timbo343

[webman]

@webman i might have asked this question before but is there any way to get classroombookings integrated with AD rather than staff having separate logins? Would be really cool if this could be done.

 

Thanks

 

Hey @timbo343, I'm afraid not, as it stands I have been looking at a quick/easy way of getting this into the current version, so watch this space.

[Ephelyon]

Hi @webman, our Deputy Head would like us to report on how many times (i.e. periods) individual staff have booked a computer room (any room) per half-term. Just noticed you mentioned earlier you might have some SQL queries - can we come with a begging bowl please?

 

Ideally the query would generate two columns (teacher name, total bookings) and accept two dates as input (start and end of half-term). Don't want to ask too much of your time so if there's anything you could point us to that we could generate it from ourselves, we'd really appreciate it!

[webman]

Hi @Ephelyon, I do have those! None of them do exactly what your Deputy Head would like, but I'll see what I can come up with over lunch today

[webman]

Hi @Ephelyon, as promised!

 

The following SQL query will report the number of single instance bookings made by users, ordered by the highest number of bookings made in the given date range.

 

SELECT 
users.displayname AS `Teacher Name`,
COUNT(bookings.booking_id) AS `Total Bookings`
FROM bookings 
LEFT JOIN users ON bookings.user_id=users.user_id 
WHERE bookings.date IS NOT NULL 
AND bookings.date BETWEEN '2016-01-01' AND '2016-02-08'
GROUP BY bookings.user_id
ORDER BY `Total Bookings` DESC, users.username ASC

 

You can change "displayname" to be any column from the users table - for example - username, firstname, lastname, or email - depending on which is more relevant for you.

Change the two date values to be the start and end of the date range you are interested in.

 

 

Hope that helps!

 

Craig.

[Ephelyon]

Many thanks! Scripted this into prompting for the dates so we can run it over SSH now.

[TomChabbs]

Hello @webman, it's @Ephelyon's technician here!

 

We're using your Classroom Booking system and in anticipating the exam period I’m anticipating a potential issue we might have.

 

As exams are taking priority over the normal scheduled recurring lessons I am having to cancel some recurring bookings to make room for exams. However, this deletes all future and past recurring bookings for that period, meaning that when I go a couple of months into the future to book an exam it deletes the current recurring bookings up until that time.

 

Is there any way to cancel just one instance of a recurring booking and allow the others to remain unaffected? This would be like the difference between deleting an “occurrence” and deleting a “series” of recurring appointments in Outlook, say. Do you know if there’s a way to do that on CRBS?

[webman]

Hi @TomChabbs, thanks for posting the question! The short answer is, sadly, no

 

The only suggestion I have is to either 1) delete the whole recurring series, and (re-)create those actual lessons as one-off bookings; or 2) leave the recurring ones as-is, and just create single "EXAM" bookings where relevant.

 

I think at my last school it was a combination of the above, and teachers understood that during exam season there would be some disruption and alterations.

 

It's not ideal, I know, but that's all there is at the moment - sorry!

[TomChabbs]

Thanks @webman for the reply!

 

In regards to suggestion 2; I have tried create a single "EXAM" booking over a recurring booking but the recurring booking always seems to take priority. However, interestingly creating a single booking does seem to take priority over a non-recurring booking.

 

It is possible that I have misunderstood what you meant by your second suggestion, any ideas?

 

Thanks for all your help.

[webman]

No problem! Sorry, I mean to just fill in the empty slots with one-off "EXAM" bookings - leaving the recurring ones as they are.

 

The main goal was to prevent the booking of the room by other staff when exams are occurring - so it was sort-of less important what the actual booking label was - the main thing was that staff couldn't book it out.

[TomChabbs]

Ah I see! Yeah that's a good idea for exam season!

 

For now I'll either cancel the recurring or just verbally tell them that their timetabled booking is being replaced by an exam. Thanks

[Gareth_Shaw]

Hello

 

I have just installed Classroombookings on a Amazon ec2 it seems to be working (after realizing the url in config.php does not like ip numbers).

 

I now have a problem with booking styles, also when I enter school details and enter the details including a logo it gives an error unable to create image and when I go to bookings it says no booking style contact admin ( I am admin)

 

Any help on solving these issues would be greatly appreciated.

 

Thanks

[webman]

Hi @Gareth_Shaw, thanks for checking out Classroombookings

 

When it says unable to create image, I recall this could be down to two issues:

 

1) No correct permissions for the directories listed below.

2) The PHP GD extensions is not enabled or installed.

 

The following directories need full write access by the web server/PHP user:

 

webroot/images/roomphotos
webroot/images/schoollogo
webroot/images/bg
system/cache
temp

 

Usually the "755" permission value is sufficient, but depending on the environment (sorry, I'm not familiar with the specifics of EC2) it may need 777.

 

Can you check those two items please and then try saving the details again?

 

 

Craig.

[Gareth_Shaw]

Craig

 

Thank you very much - it looks like the issue was PHP GD not being installed.

 

I have now got the booking system to work as admin, I am now going to set up the timetable for the rooms and test further - I will get back with my findings.

 

One suggestion / request - I work in Kuwait where our school week (like of GCC countries) is Sunday to Thursday. Is there anyway to change the working week start / end day ?

 

Thanks for the quick response.

 

Gareth

[webman]

Hi Gareth

 

That's great, pleased you've got that bit sorted

 

I've had a look through the current version, and it and it doesn't seem easy/straightforward to change the start day of week, as it's assumed in several places to be Monday. Hopefully this shouldn't be too much of a problem if you choose the "One day at a time" Bookings display type option in the School Details page.

 

If you use a multi-week timetable, you can probably be fine as well if you set up the Week Cycle as usual - just the dates on that configuration page will be the Monday of the week where your week starts on the Thursday (if that makes sense!)

 

It's a great suggestion to bring up though. I will take this into consideration in the next version and make it configurable, thanks.

 

 

Craig.

[Gareth_Shaw]

Craig

 

Ok Thanks.

 

I have noticed this has been asked a few times - but when is the next version due - I am running the version from classroombookings.com (1.0.7) - is this the most current version (although it says copyright 2006 at the bottom of each page).

 

Thanks

 

Gareth

[webman]

Still no firm date for the next version unfortunately!

 

The version you have is the most recent one available. The copyright year is just from the very first release of it

[andylorenz]

webcam, nice to meet you...

 

i really want to prove your beautiful program...

 

i have seen it on internet and it look simply incredible...

 

but for misteriously reasons... it's impossible to use...

 

i have php 5.5.35 mysql linux server... so... everything seem to be ok...

 

it has to work... it's too beautiful for not use it...

 

now...

 

i gave a look this page...

 

Installation | Classroombookings

 

 

i extracted the zip file in the webpace... 1.7... the last version...

 

i changed the name of the folder... because was too long for me...

 

i took the two files in the example... they were inside a subfolder...

 

config.defalult,php and database.default.php...

 

changed the name in config,.php and database.php...

 

i put them in the main directory of the program... where there is the index file...

 

i have configurated them with my dates...

 

the only things not clear for me i this part..

// Empty string if using mod_rewrite in .htaccess to enable clean URLs

$config['index_page'] = 'index.php';now... in any case...

 

when i try to go in the directory... the same directory i have write in the php...

 

http.//mysite/clbooking/

 

it continued to tell me don't existe te config.php file..

 

what do you think could be the problem?

Edited May 19, 2016 by andylorenz

[webman]

Hi andylorenz!

 

I think the main issue you are having is that you have put the config.php and database.php files in the same place as the index.php file.

 

The config.php and database.php files should be in the system/application/config/ directory. Try moving them there, and see if the page loads again.

 

 

Craig.

[Bev]

We have been using this system for over a year and it's been working great, but this term we are getting loads of glitches. Bookings that appear not to have been made but then are actually there if you change the day and return to the original day.

 

Is there any reason this would happen? I have it hosted on some webspace which I have purchased.

[webman]

Hi Bev

 

That sounds very strange, I don't think I've experienced that particular problem before! Would you be able to send me an email please giving me log in access, and some examples of the problem days, periods, bookings etc, so I can have a look? Email is craig(at)classroombokings.com.

[jessica]

hi @webman

Is there any way to report how often departments have booked each Computer room?

[webman]

Hi @jessica! I have some SQL snippets to run directly in the database, which may produce what you want. I'll have a look and let you know!

[jessica]

Thank you