@@ -, +, @@ filters --- ..._-_add_ConsiderLibraryHoursWhenIssuing_syspref.pl | 0 .../bug_6796_-_add_branch_hours_table.pl | 2 +- installer/data/mysql/kohastructure.sql | 2 +- .../intranet-tmpl/prog/en/modules/admin/branches.tt | 12 ++++++------ 4 files changed, 8 insertions(+), 8 deletions(-) mode change 100644 => 100755 installer/data/mysql/atomicupdate/bug_6796_-_add_ConsiderLibraryHoursWhenIssuing_syspref.pl --- a/installer/data/mysql/atomicupdate/bug_6796_-_add_branch_hours_table.pl +++ a/installer/data/mysql/atomicupdate/bug_6796_-_add_branch_hours_table.pl @@ -11,7 +11,7 @@ return { $dbh->do(q{ CREATE TABLE branch_hours ( branchcode varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, - day int(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 0, + day enum('0','1','2','3','4','5','6') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', open_time time COLLATE utf8mb4_unicode_ci DEFAULT NULL, close_time time COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (branchcode, day), --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -1570,7 +1570,7 @@ DROP TABLE IF EXISTS branch_hours; /*!40101 SET character_set_client = utf8 */; CREATE TABLE branch_hours ( branchcode varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, - day int(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 0, + day enum('0','1','2','3','4','5','6') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', open_time time COLLATE utf8mb4_unicode_ci DEFAULT NULL, close_time time COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (branchcode, day), --- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/branches.tt +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/branches.tt @@ -289,21 +289,21 @@ Libraries › Administration › Koha [% IF opening_hours # Existing library %] [% daycount = 0 %] [% FOREACH hr IN opening_hours %] - + [% PROCESS dayname day=daycount %] - + [% IF hr.day == daycount && hr.open_time %] - + [% ELSE %] [% END %] [% IF hr.day == daycount && hr.close_time %] - + [% ELSE %] [% END %] @@ -313,10 +313,10 @@ Libraries › Administration › Koha [% END %] [% ELSE # New library %] [% FOREACH daycount IN [0..6] %] - + [% PROCESS dayname day=daycount %] - + --