Booking System: Split Resources

[Arkaine]

Home Access Plus+ is amazing! The file manager functionality is excellent and the end-user interface looks clean and polished. I can't believe you offer this for free; it's much appreciated! Do you accept donations?

 

In the booking system, it looks like you might be in the early stages of implementing this with the "Laptop" resource type, but do you plan on allowing multiple users to split resources within the same lesson? I have a couple computer labs that may be reserved for multiple classes within the same time slot because there are more than enough workstations to accommodate them. This same concept goes for a couple of my laptop carts as well. I've attached an (edited) screenshot that will hopefully convey my thoughts.

 

[nickbro]

Donations can be made, if willing, either in the form of sugar gifts or Paypal monetary transfers, pm for either address.

 

Unfortunately I think that will be a bit difficult to implement.

 

Setting a quantity required outside of a Laptop resource is coming in the next release (see checking: 83787). This should show to staff if there is a partially free booking which they 'could' share. It would then be a discussion with that member of staff to see if a share is possible.

Edited May 25, 2013 by nickbro

[Arkaine]

Donations can be made, if willing, either in the form of sugar gifts or Paypal monetary transfers, pm for either address.

 

Unfortunately I think that will be a bit difficult to implement.

 

Setting a quantity required outside of a Laptop resource is coming in the next release (see checking: 83787). This should show to staff if there is a partially free booking which they 'could' share. It would then be a discussion with that member of staff to see if a share is possible.

Have a pub night on me!

 

I'm glad to hear you're working on booking system improvements!

 

Ha! It's less like a discussion and more like a brawl.

 

I'm definitely no developer, but I'm sometimes capable enough to hack other brilliant developers' code to get it to do what I want (as long as it's a minor change). Of course I'm more comfortable with PHP and VB than C#...and it looks like most of the logic is compiled into binaries so I wouldn't know where to start with that, heh.

 

If this were PHP/MySQL (not C#/XML), I figure the simplest way to do this would add a "maxresourcecount" field for the booking system resource and do something like this. Obviously, it's more difficult than I make it sound...especially when you already have a day job!

 

//pull max resource count from configuration
$intMaxResourceCount = mysql_query( "SELECT `maxresourcecount` FROM `bookingsystem_resources` WHERE name='$strResourceName'" );

//calculate resource count already booked (an alternative would be to loop through the records and add them up)
$intBookedResourceCount = mysql_query( "SELECT SUM(`bookedresourcecount`) FROM `bookings` WHERE (name='$strResourceName') AND (`date`='$strDate') AND (`lesson`='$strLesson')" );

//determine whether or not to allow booking
if($intBookedResourceCount < $intMaxResourceCount){
   //allow booking if requested quantity is less than or equal to: $intMaxResourceCount - $intBookedResourceCount
}else{
   //don't allow booking
}

[nickbro]

It's coming, I had ideas overnight on how we could do it, render it anyhow

[nickbro]

A hint of things to come:

 

[ATTACH=CONFIG]18382[/ATTACH][ATTACH=CONFIG]18383[/ATTACH]

Testers needed. The booking system display gets cocked up by this, but hopefully can be fixed

[mattianuk]

Happy to volunteer to help test.

[Arkaine]

Holy cow, Nick; you're incredible! I am definitely interested in testing this for you.

 

If the display issues are just a matter of changing some HTML/CSS markup, hell, I am more than happy to contribute to allow you to focus on the more difficult tasks.

Edited May 25, 2013 by Arkaine

[nickbro]

I wont be able to fix the display screen issue (i.e. /hap/bookingsystem/Resource/Display) until next weekend (need my site's bs to move onto the next week (half term for us this week coming))

 

Attached is the v9.2 ALPHA release, it contains this as well as the fix for the Password box on the Home Screen

 

Note: The settings page hasn't been tested, if someone would test it that would be great. It `should` work.

[Arkaine]

Note: The settings page hasn't been tested, if someone would test it that would be great. It `should` work.

You get the following error if the "canshare" XML attribute for the resource doesn't already exist. Manually adding the attribute resolves the issue.

 

 

Object reference not set to an instance of an object.

This error has been logged on the server's event log

[nickbro]

Ah, ok good catch, will add that to an upgrade script Edited May 25, 2013 by nickbro

[Arkaine]

Nick, thank you! It's amazing that you've done this so quickly!

 

It works great for up to two bookings per lesson, but at the third (and any subsequent) booking, the quantity requested is always recorded as "0" regardless of what the user selects when making it.

 

Bookings.xml

 

hapconfig.xml

Edited May 26, 2013 by Arkaine

[Arkaine]

I take that back, it seems to be random rather than on the third booking.

 

Also, is this what you meant by "cocked up display?"

 

Example:

 

Edited May 26, 2013 by Arkaine

[nickbro]

@Arkaine do you get any javascript errors? It should render the free for booking

[nickbro]

Ok, I think I've fixed the issue, DOH moment.

 

You need to move

var xy = 0;

from line 176 to line 177.

 

It should look like

                var h1 = "";
               for (var x = 0; x < this.Data.length; x++) {
                   var xy = 0;

Edited May 26, 2013 by nickbro

[Arkaine]

Ok, I think I've fixed the issue, DOH moment.

 

You need to move

var xy = 0;

from line 176 to line 177.

 

It should look like

                var h1 = "";
               for (var x = 0; x < this.Data.length; x++) {
                   var xy = 0;

Oh, wow, I think that did it! I'll try to break it some more for you.

[Arkaine]

Sometimes when a second user books the same lesson, the "Count" HTTP post variable doesn't get transmitted:

 

 

Sometimes it does what it's supposed to do:

 

Edited May 26, 2013 by Arkaine

[TheScarfedOne]

This looks awesome nick. Thanks! While we are tinkering with it...can you see if you can add the ability to add a choice for the number of sessions before and after a booking to be unavailable/charging... I want to make it 2 not 1 each side ta

[mattianuk]

Also, can we have an admin option to book a resource for a day fr a user?

[nickbro]

@mattianuk: admins can already do that if the resource supports multi-lesson bookings.

 

I'll add an option for the charging periods now

[nickbro]

Attached is Alpha 2 for today, it contains the ability to set more than 1 charging period for a resource (config edit only) Edited May 26, 2013 by nickbro

[TheScarfedOne]

Yep the multi room works a treat. Cheers Nick

[Arkaine]

Damn, that's fast! Post #16 above still applies for Alpha 2.

[nickbro]

Can you check the bookings.xml file and see if it's storing the count. It wont transmit it if it isn't stored

[Arkaine]

Can you check the bookings.xml file and see if it's storing the count. It wont transmit it if it isn't stored

It stores the count as "0" in bookings.xml when the HTTP post count variable isn't transmitted for that particular booking. The client isn't sending the variable to the server, and the server records 0.

Edited May 26, 2013 by Arkaine

[nickbro]

Ok, post count of 0 means use the whole room, will have to look into why that isn't getting set.

 

What value are you putting in for the quantity when you do a booking?