Reports and repeating reservations

[RobC]

Hi.

From what I have found, the recommend way to get a report of all reservations (or all reservations for a specific resource) is to go to Application Management... Reservations, then export to CSV.

Unfortunately, for repeating reservations, only the first instance of that reservation appears.

We would like to be able to create a report of all the usage of a resource, including the repeated instances.

Rob
(using phpScheduleIt 2.0)

[Nick]

That sounds like a bug. I'll try and reproduce this.

[RobC]

I just retested using 2.0.1.

Here are the steps I took to reproduce:
1. Clean install using Softaculous script.
2. Create a reservation for today or tomorrow on the "Conference Room 1" resource (it was there when I installed), set it to repeat weekly on the same day until the end of the month.
3. The repeating instances of the reservation show up on the dashboard, and on the "Schedule... Bookings" and "Schedule... Resource calendar", however, only the first instance appears on the "Application Management... Reservations" view.

I hope this helps.  Let me know if you need more information.

Rob

[Nick]

Very strange. I can't seem to reproduce this. Are you using the English (US) language?

[RobC]

I'm using en_us.

I tried out a couple more things, maybe it may help in finding the issue:
- I created a new user, made a repeating daily reservation, logged out then logged in as admin, went to the "Application Management... Reservations" view.
-- it worked fine
- I created a repeating daily reservation as admin. -- it appears correctly.
- I created a repeating weekly reservation as my user -- same problem as before: only the first appearance shows up in "Application Management... Reservations"

I did notice that my admin user was in a different timezone (Europe/Helsinki).  I changed it to America/Chicago (like the other user), but no change to the behaviour.

It seems to be related to the weekly repeating reservations, since the daily ones appear to be ok.

Rob

[Nick]

Weird, I'm still not able to reproduce even with the weekly recurrence. I'll keep playing around.

[RobC]

Hi Nick,

I upgraded to 2.1, and can no longer reproduce this issue.

Having said that, the original report may have been user error.  I can't recall if I changed the date range filter in the Application Management... Reservations screen.  Seeing that by default it seems to filter from one week prior to the current date to one week after the current date, only one instance of a weekly reservation would appear.

On a related note, is there a way to change the default filter in that screen?

Rob

[Nick]

Do you just want to change the default dates?

[RobC]

Default dates, yes.  (it is more useful to see upcoming reservations rather than ones in the past).

Maybe also the Status (for a one-click way of finding any reservations Pending Approval).  I'm trying to make it simple for our resource administrator (thank you!) to find and approve pending reservations.  But this one is not as important (since pending reservations already appear in a different color in that view).

Rob

[Nick]

I'll figure out a better way to handle this (saved searches or configurable defaults or something).

For now, you can change /Presenters/Admin/ManageReservationsPresenter.php lines 72 and 73 to:

Code:

$startDate = $this->GetDate($startDateString, $userTimezone, 0);
$endDate = $this->GetDate($endDateString, $userTimezone, 14);

The 14 can be however many days you want to show by default