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/userpermissions.sql (+1 lines)
Lines 17-22 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
17
   ( 3, 'manage_transfers', 'Manage library transfer limits and transport cost matrix'),
17
   ( 3, 'manage_transfers', 'Manage library transfer limits and transport cost matrix'),
18
   ( 3, 'manage_item_circ_alerts', 'Manage item circulation alerts'),
18
   ( 3, 'manage_item_circ_alerts', 'Manage item circulation alerts'),
19
   ( 3, 'manage_cities', 'Manage cities and towns'),
19
   ( 3, 'manage_cities', 'Manage cities and towns'),
20
   ( 3, 'manage_patron_restrictions', 'Manage patron restrictions'),
20
   ( 3, 'manage_marc_frameworks', 'Manage MARC bibliographic and authority frameworks'),
21
   ( 3, 'manage_marc_frameworks', 'Manage MARC bibliographic and authority frameworks'),
21
   ( 3, 'manage_classifications', 'Manage classification sources'),
22
   ( 3, 'manage_classifications', 'Manage classification sources'),
22
   ( 3, 'manage_matching_rules', 'Manage record matching rules'),
23
   ( 3, 'manage_matching_rules', 'Manage record matching rules'),
(-)a/koha-tmpl/intranet-tmpl/prog/en/includes/permissions.inc (+5 lines)
Lines 149-154 Link Here
149
            Manage patron categories
149
            Manage patron categories
150
        </span>
150
        </span>
151
        <span class="permissioncode">([% name | html %])</span>
151
        <span class="permissioncode">([% name | html %])</span>
152
    [%- CASE 'manage_patron_restrictions' -%]
153
        <span class="sub_permission manage_patron_restrictions_subpermission">
154
            Manage patron restrictions
155
        </span>
156
        <span class="permissioncode">([% name | html %])</span>
152
    [%- CASE 'manage_patron_attributes' -%]
157
    [%- CASE 'manage_patron_attributes' -%]
153
        <span class="sub_permission manage_patron_attributes_subpermission">
158
        <span class="sub_permission manage_patron_attributes_subpermission">
154
            Manage extended patron attributes
159
            Manage extended patron attributes
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/admin-home.tt (-1 / +4 lines)
Lines 95-100 Link Here
95
                        <dt><a href="/cgi-bin/koha/admin/cities.pl">Cities and towns</a></dt>
95
                        <dt><a href="/cgi-bin/koha/admin/cities.pl">Cities and towns</a></dt>
96
                        <dd>Define cities and towns that your patrons live in.</dd>
96
                        <dd>Define cities and towns that your patrons live in.</dd>
97
                    [% END %]
97
                    [% END %]
98
                    [% IF ( CAN_user_parameters_manage_patron_restrictions ) %]
99
                        <dt><a href="/cgi-bin/koha/admin/restrictions.pl">Patron restrictions</a></dt>
100
                        <dd>Define patron restrictions.</dd>
101
                    [% END %]
98
                </dl>
102
                </dl>
99
            [% END %]
103
            [% END %]
100
104
101
- 

Return to bug 23681