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

(-)a/installer/data/mysql/atomicupdate/bug_23681_add_debarment_types.perl (-8 / +8 lines)
Lines 18-32 if ( CheckVersion( $DBversion ) ) { Link Here
18
            ('SUSPENSION', 'Suspension', 1, 0),
18
            ('SUSPENSION', 'Suspension', 1, 0),
19
            ('DISCHARGE', 'Discharge', 1, 0);
19
            ('DISCHARGE', 'Discharge', 1, 0);
20
        |);
20
        |);
21
        $dbh->do( q|
22
            ALTER TABLE borrower_debarments
23
            MODIFY COLUMN type varchar(50) NOT NULL
24
        | );
25
        $dbh->do( q|
26
            ALTER TABLE borrower_debarments
27
            ADD CONSTRAINT borrower_debarments_ibfk_2 FOREIGN KEY (type) REFERENCES debarment_types(code) ON DELETE NO ACTION ON UPDATE CASCADE;
28
        | );
21
    }
29
    }
22
    $dbh->do( q|
23
        ALTER TABLE borrower_debarments
24
        MODIFY COLUMN type varchar(50) NOT NULL
25
    | );
26
    $dbh->do( q|
27
        ALTER TABLE borrower_debarments
28
        ADD CONSTRAINT borrower_debarments_ibfk_2 FOREIGN KEY (type) REFERENCES debarment_types(code) ON DELETE NO ACTION ON UPDATE CASCADE;
29
    | );
30
30
31
    SetVersion( $DBversion );
31
    SetVersion( $DBversion );
32
    print "Upgrade to $DBversion done (Bug 23681 - Add debarment_types)\n";
32
    print "Upgrade to $DBversion done (Bug 23681 - Add debarment_types)\n";
(-)a/installer/data/mysql/atomicupdate/bug_23681_add_manage_patron_restrictions_perm.perl (+9 lines)
Line 0 Link Here
1
$DBversion = 'XXX';
2
if( CheckVersion( $DBversion ) ) {
3
    $dbh->do(q{
4
        INSERT IGNORE INTO permissions (module_bit, code, description) VALUES
5
           ( 3, 'manage_patron_restrictions', 'Manage patron restrictions')
6
    });
7
    SetVersion( $DBversion );
8
    print "Upgrade to $DBversion done (Bug 23681 - Add manage_patron_restrictions_permission)\n";
9
}
(-)a/installer/data/mysql/mandatory/userpermissions.sql (+1 lines)
Lines 20-25 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
20
   ( 3, 'manage_item_circ_alerts', 'Manage item circulation alerts'),
20
   ( 3, 'manage_item_circ_alerts', 'Manage item circulation alerts'),
21
   ( 3, 'manage_cash_registers', 'Add and remove cash registers'),
21
   ( 3, 'manage_cash_registers', 'Add and remove cash registers'),
22
   ( 3, 'manage_cities', 'Manage cities and towns'),
22
   ( 3, 'manage_cities', 'Manage cities and towns'),
23
   ( 3, 'manage_patron_restrictions', 'Manage patron restrictions'),
23
   ( 3, 'manage_marc_frameworks', 'Manage MARC bibliographic and authority frameworks'),
24
   ( 3, 'manage_marc_frameworks', 'Manage MARC bibliographic and authority frameworks'),
24
   ( 3, 'manage_classifications', 'Manage classification sources'),
25
   ( 3, 'manage_classifications', 'Manage classification sources'),
25
   ( 3, 'manage_matching_rules', 'Manage record matching rules'),
26
   ( 3, 'manage_matching_rules', 'Manage record matching rules'),
(-)a/koha-tmpl/intranet-tmpl/prog/en/includes/permissions.inc (+5 lines)
Lines 163-168 Link Here
163
            Manage patron categories
163
            Manage patron categories
164
        </span>
164
        </span>
165
        <span class="permissioncode">([% name | html %])</span>
165
        <span class="permissioncode">([% name | html %])</span>
166
    [%- CASE 'manage_patron_restrictions' -%]
167
        <span class="sub_permission manage_patron_restrictions_subpermission">
168
            Manage patron restrictions
169
        </span>
170
        <span class="permissioncode">([% name | html %])</span>
166
    [%- CASE 'manage_patron_attributes' -%]
171
    [%- CASE 'manage_patron_attributes' -%]
167
        <span class="sub_permission manage_patron_attributes_subpermission">
172
        <span class="sub_permission manage_patron_attributes_subpermission">
168
            Manage extended patron attributes
173
            Manage extended patron attributes
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/admin-home.tt (-1 / +4 lines)
Lines 123-128 Link Here
123
                    <dt><a href="/cgi-bin/koha/admin/curbside_pickup.pl">Curbside pickup</a></dt>
123
                    <dt><a href="/cgi-bin/koha/admin/curbside_pickup.pl">Curbside pickup</a></dt>
124
                    <dd>Configure curbside pickup for libraries</dd>
124
                    <dd>Configure curbside pickup for libraries</dd>
125
                [% END %]
125
                [% END %]
126
                [% IF ( CAN_user_parameters_manage_patron_restrictions ) %]
127
                    <dt><a href="/cgi-bin/koha/admin/restrictions.pl">Patron restrictions</a></dt>
128
                    <dd>Define patron restrictions.</dd>
129
                [% END %]
126
                </dl>
130
                </dl>
127
            [% END %]
131
            [% END %]
128
132
129
- 

Return to bug 23681