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 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 157-162 Link Here
157
            Manage patron categories
157
            Manage patron categories
158
        </span>
158
        </span>
159
        <span class="permissioncode">([% name | html %])</span>
159
        <span class="permissioncode">([% name | html %])</span>
160
    [%- CASE 'manage_patron_restrictions' -%]
161
        <span class="sub_permission manage_patron_restrictions_subpermission">
162
            Manage patron restrictions
163
        </span>
164
        <span class="permissioncode">([% name | html %])</span>
160
    [%- CASE 'manage_patron_attributes' -%]
165
    [%- CASE 'manage_patron_attributes' -%]
161
        <span class="sub_permission manage_patron_attributes_subpermission">
166
        <span class="sub_permission manage_patron_attributes_subpermission">
162
            Manage extended patron attributes
167
            Manage extended patron attributes
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/admin-home.tt (-1 / +4 lines)
Lines 104-109 Link Here
104
                    <dt><a href="/cgi-bin/koha/admin/cities.pl">Cities and towns</a></dt>
104
                    <dt><a href="/cgi-bin/koha/admin/cities.pl">Cities and towns</a></dt>
105
                    <dd>Define cities and towns that your patrons live in.</dd>
105
                    <dd>Define cities and towns that your patrons live in.</dd>
106
                [% END %]
106
                [% END %]
107
                [% IF ( CAN_user_parameters_manage_patron_restrictions ) %]
108
                    <dt><a href="/cgi-bin/koha/admin/restrictions.pl">Patron restrictions</a></dt>
109
                    <dd>Define patron restrictions.</dd>
110
                [% END %]
107
                </dl>
111
                </dl>
108
            [% END %]
112
            [% END %]
109
113
110
- 

Return to bug 23681