Attachment #153257 for bug #6796

View | Details | Raw Unified | Return to bug 6796
Collapse All | Expand All

Lines 1-5 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_6796_-_add_ConsiderLibraryHoursWhenIssuing_syspref.perl (-5 lines)
1	$DBversion = 'XXX';
2	if ( CheckVersion( $DBversion ) ) {
3	$dbh->do(q{ INSERT IGNORE INTO systempreferences ( variable, value, options, explanation, type ) VALUES ( 'ConsiderLibraryHoursWhenIssuing', 'ignore', 'close\|open\|ignore', "Take library opening hours into consideration to calculate due date when issuing.", 'Choice' ) });
4	NewVersion( $DBversion, 6796, "Add ConsiderLibraryHoursWhenIssuing system preference" );
5	}




use Modern::Perl;

return {
    bug_number => "6796",
    description => "Overnight checkouts taking into account opening and closing hours",
    up => sub {
        my ($args) = @_;
        my ($dbh, $out) = @$args{qw(dbh out)};

        $dbh->do(q{ INSERT IGNORE INTO systempreferences ( variable, value, options, explanation, type ) VALUES ( 'ConsiderLibraryHoursWhenIssuing', 'ignore', 'close|open|ignore', "Take library opening hours into consideration to calculate due date when issuing.", 'Choice' ) });

        say $out "Added system preference 'ConsiderLibraryHoursWhenIssuing'";
    },
};




$DBversion = 'XXX';
if ( CheckVersion( $DBversion ) ) {
    $dbh->do(q{ DROP TABLE IF EXISTS branch_hours });
    $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,
            open_time time COLLATE utf8mb4_unicode_ci DEFAULT NULL,
            close_time time COLLATE utf8mb4_unicode_ci DEFAULT NULL,
            PRIMARY KEY (branchcode, day),
            CONSTRAINT branch_hours_ibfk_1 FOREIGN KEY (branchcode) REFERENCES branches (branchcode) ON DELETE CASCADE ON UPDATE CASCADE
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
    });

    my @indexes = (0..6);
    for my $i (@indexes) {
        $dbh->do(q{ INSERT INTO branch_hours (branchcode, day) SELECT branchcode, ? FROM branches }, undef, $i);
    }
    NewVersion( $DBversion, 6796, "Add branch_hours table" );
}




use Modern::Perl;

return {
    bug_number => "6796",
    description => "Overnight checkouts taking into account opening and closing hours",
    up => sub {
        my ($args) = @_;
        my ($dbh, $out) = @$args{qw(dbh out)};

        unless( TableExists('branch_hours') ) {
            $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,
                    open_time time COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                    close_time time COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                    PRIMARY KEY (branchcode, day),
                    CONSTRAINT branch_hours_ibfk_1 FOREIGN KEY (branchcode) REFERENCES branches (branchcode) ON DELETE CASCADE ON UPDATE CASCADE
                ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
            });

            my @indexes = (0..6);
            for my $i (@indexes) {
                $dbh->do(q{ INSERT INTO branch_hours (branchcode, day) SELECT branchcode, ? FROM branches }, undef, $i);
            }

            say $out "Added table `branch_hours`";
        }
    },
};

Return to bug 6796

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_6796_-_add_ConsiderLibraryHoursWhenIssuing_syspref.pl (+14 lines)
	1	use Modern::Perl;
	2
	3	return {
	4	bug_number => "6796",
	5	description => "Overnight checkouts taking into account opening and closing hours",
	6	up => sub {
	7	my ($args) = @_;
	8	my ($dbh, $out) = @$args{qw(dbh out)};
	9
	10	$dbh->do(q{ INSERT IGNORE INTO systempreferences ( variable, value, options, explanation, type ) VALUES ( 'ConsiderLibraryHoursWhenIssuing', 'ignore', 'close\|open\|ignore', "Take library opening hours into consideration to calculate due date when issuing.", 'Choice' ) });
	11
	12	say $out "Added system preference 'ConsiderLibraryHoursWhenIssuing'";
	13	},
	14	};