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 19-24 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
19
   ( 3, 'manage_item_circ_alerts', 'Manage item circulation alerts'),
19
   ( 3, 'manage_item_circ_alerts', 'Manage item circulation alerts'),
20
   ( 3, 'manage_cash_registers', 'Add and remove cash registers'),
20
   ( 3, 'manage_cash_registers', 'Add and remove cash registers'),
21
   ( 3, 'manage_cities', 'Manage cities and towns'),
21
   ( 3, 'manage_cities', 'Manage cities and towns'),
22
   ( 3, 'manage_patron_restrictions', 'Manage patron restrictions'),
22
   ( 3, 'manage_marc_frameworks', 'Manage MARC bibliographic and authority frameworks'),
23
   ( 3, 'manage_marc_frameworks', 'Manage MARC bibliographic and authority frameworks'),
23
   ( 3, 'manage_classifications', 'Manage classification sources'),
24
   ( 3, 'manage_classifications', 'Manage classification sources'),
24
   ( 3, 'manage_matching_rules', 'Manage record matching rules'),
25
   ( 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 119-124 Link Here
119
                    <dt><a href="/cgi-bin/koha/admin/cities.pl">Cities and towns</a></dt>
119
                    <dt><a href="/cgi-bin/koha/admin/cities.pl">Cities and towns</a></dt>
120
                    <dd>Define cities and towns that your patrons live in</dd>
120
                    <dd>Define cities and towns that your patrons live in</dd>
121
                [% END %]
121
                [% END %]
122
                [% IF ( CAN_user_parameters_manage_patron_restrictions ) %]
123
                    <dt><a href="/cgi-bin/koha/admin/restrictions.pl">Patron restrictions</a></dt>
124
                    <dd>Define patron restrictions.</dd>
125
                [% END %]
122
                </dl>
126
                </dl>
123
            [% END %]
127
            [% END %]
124
128
125
- 

Return to bug 23681