[Koha-bugs] [Bug 17015] New: New Koha Calendar

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17015

            Bug ID: 17015
           Summary: New Koha Calendar
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Holidays
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: mehdi.hamidi at inlibro.com
        QA Contact: testopia at bugs.koha-community.org

We are trying to create a new Koha calendar system. The one available right now
is way too slow. This is the first patch of the calendar, it doesn't affect the
functioning of the current calendar, but it works in parallel with it. Instead
of having multiple tables for the holidays, we created one table, called
discrete_calendar. This table contains the dates,branchcode, opening/closing
hours, a note about the holiday and whether the library is open or not. 

The script misc/generate_discrete_calendar.pl fills the table discrete_calendar
based on tables : repeatable_holidays, special_holidays, openinghours and
branches. The script, by default, will add 2 years from the past and 1 year in
the future in the table discrete_calendar. It also has an option to added more
than 1 year in the future.

The script misc/cronjobs/add_days_discrete_calendar.pl will add days in the
future in the table discrete calendar. A day's opening and closing hours will
be based on the same weekday from the week before. It will also check if the
same day from last year was a holiday, if so, this will be counted as a
holiday.
The script makes sur there's at least 1 year in the future. So if it hasn't ran
for 8 days, 8 days will be added in he future the next time the script is
executed.

There's also an atomic update to create the table.

The current options are not final and they can be changed for convenience.

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.