Grouping resources in calendar day view

[ylnahar]

We have a unique need to use the scheduler for scheduling OR rooms. We would like the medical staff to basically see the OR room no. (resources) and then the procedures scheduled under them for various times. Therefore all scheduled times for a particular resource should be grouped together for the same resource. This way we want to display 15 resources one after the other.

I feel this would definitely be possible by altering the day view of the calendar. But if someone could give me some info on the modifications and where they need to be applied,  I would greatly appreciate your help.

Thank you.

Yogi

[Nick]

Can you give an example to help me understand?  Are you saying if you have resource 1 booked from 1-2, 2-3, 3-4, and resource 2 booked 12-1, 1-2, 2-3, you want to see

resource 1 1-2
resource 1 2-3
resource 1 3-4
resource 2 12-1
resource 2 1-2
resource 2 2-4

[ylnahar]

Exactly. We would like to re-organize the day/week view like that.

Please advice on how to customize this. Thank you.

Yogi

[Nick]

I'm going to have to think about this one.  You may be able to add a couple of sorts in the lib\mycalendar.class.php or lib\rescalendar.class.php functions that pull or display the reservations.

[ylnahar]

Please let me know if you think this would work with the sorting functions. Thank you.

Yogi

[Nick]

I think this would probably be the simplest option.  As a start, try changing line 62 of lib\db\mycalendardb.class.php to:

$sql .= ' ORDER BY resources.name, res.start_date, res.starttime, res.end_date, res.endtime';

And line 59 of lib\db\rescalendardb.class.php to:

$sql .= ' ORDER BY resources.name, res.start_date, res.starttime, res.end_date, res.endtime';