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

(-)a/installer/data/mysql/atomicupdate/14686_permissions.sql (+20 lines)
Line 0 Link Here
1
-- Insert permission
2
INSERT IGNORE INTO permissions (module_bit, code, description) VALUES
3
    (13, 'upload_general_files', 'Upload any file'),
4
    (13, 'upload_manage', 'Manage uploaded files');
5
6
-- Update user_permissions for current users (check count in uploaded_files)
7
-- Note 9 == edit_catalogue and 13 == tools
8
-- We do not insert if someone is superlibrarian, does not have edit_catalogue,
9
-- or already has all tools
10
INSERT IGNORE INTO user_permissions (borrowernumber, module_bit, code)
11
    SELECT borrowernumber, 13, 'upload_general_files'
12
    FROM borrowers bo
13
    WHERE flags<>1 AND flags & POW(2,13) = 0 AND
14
        ( flags & POW(2,9) > 0 OR (
15
            SELECT COUNT(*) FROM user_permissions
16
            WHERE borrowernumber=bo.borrowernumber AND module_bit=9 ) > 0 )
17
        AND ( SELECT COUNT(*) FROM uploaded_files ) > 0
18
19
# Copy-paste for RM use:
20
#    print "Upgrade to $DBversion done (Bug 14686 - New menu option and permission for file uploading)\n";
(-)a/koha-tmpl/intranet-tmpl/prog/en/includes/permissions.inc (-1 / +2 lines)
Lines 100-104 Link Here
100
    [%- CASE 'report' -%]<span>Use report plugins</span>
100
    [%- CASE 'report' -%]<span>Use report plugins</span>
101
    [%- CASE 'tool' -%]<span>Use tool plugins</span>
101
    [%- CASE 'tool' -%]<span>Use tool plugins</span>
102
    [%- CASE 'delete_public_lists' -%]<span>Delete public lists</span>
102
    [%- CASE 'delete_public_lists' -%]<span>Delete public lists</span>
103
    [%- CASE 'upload_general_files' -%]<span>Upload any file</span>
104
    [%- CASE 'upload_manage' -%]<span>Manage uploaded files (<i>Useless without upload_general_files</i>)</span>
103
    [%- END -%]
105
    [%- END -%]
104
[%- END -%]
106
[%- END -%]
105
- 

Return to bug 14686