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

(-)a/installer/data/mysql/de-DE/mandatory/userpermissions.sql (+3 lines)
Lines 11-16 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
11
   ( 9, 'edit_catalogue', 'Katalogdaten bearbeiten (Titel- und Exemplardaten ändern)'),
11
   ( 9, 'edit_catalogue', 'Katalogdaten bearbeiten (Titel- und Exemplardaten ändern)'),
12
   ( 9, 'fast_cataloging', 'Schnellaufnahmen anlegen'),
12
   ( 9, 'fast_cataloging', 'Schnellaufnahmen anlegen'),
13
   ( 9, 'edit_items', 'Exemplare bearbeiten'),
13
   ( 9, 'edit_items', 'Exemplare bearbeiten'),
14
   ( 9, 'edit_items_restricted', 'Limit item modification to barcode, status and note (please note that edit_item is still required)'),
15
   ( 9, 'delete_all_items', 'Delete all items at once'),
14
   (10, 'writeoff', 'Gebühren erlassen'),
16
   (10, 'writeoff', 'Gebühren erlassen'),
15
   (10, 'remaining_permissions', 'Verbleibende Berechtigungen für die Verwaltung von Gebühren'),
17
   (10, 'remaining_permissions', 'Verbleibende Berechtigungen für die Verwaltung von Gebühren'),
16
   (11, 'vendors_manage', 'Lieferanten verwalten'),
18
   (11, 'vendors_manage', 'Lieferanten verwalten'),
Lines 43-48 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
43
   (13, 'batch_upload_patron_images', 'Benutzerfotos einzeln oder im Stapel hochladen'),
45
   (13, 'batch_upload_patron_images', 'Benutzerfotos einzeln oder im Stapel hochladen'),
44
   (13, 'schedule_tasks', 'Aufgabenplaner verwenden'),
46
   (13, 'schedule_tasks', 'Aufgabenplaner verwenden'),
45
   (13, 'items_batchmod', 'Stapelbearbeitung von Exemplaren durchführen'),
47
   (13, 'items_batchmod', 'Stapelbearbeitung von Exemplaren durchführen'),
48
   (13, 'items_batchmod_restricted', 'Limit batch item modification to item status (please note that items_batchmod is still required)'),
46
   (13, 'items_batchdel', 'Stapellöschung von Exemplaren durchführen'),
49
   (13, 'items_batchdel', 'Stapellöschung von Exemplaren durchführen'),
47
   (13, 'manage_csv_profiles', 'CSV-Profile für Export verwalten'),
50
   (13, 'manage_csv_profiles', 'CSV-Profile für Export verwalten'),
48
   (13, 'moderate_tags', 'Von Benutzern vergebene Tags moderieren'),
51
   (13, 'moderate_tags', 'Von Benutzern vergebene Tags moderieren'),
(-)a/installer/data/mysql/en/mandatory/userpermissions.sql (+3 lines)
Lines 11-16 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
11
   ( 9, 'edit_catalogue', 'Edit catalog (Modify bibliographic/holdings data)'),
11
   ( 9, 'edit_catalogue', 'Edit catalog (Modify bibliographic/holdings data)'),
12
   ( 9, 'fast_cataloging', 'Fast cataloging'),
12
   ( 9, 'fast_cataloging', 'Fast cataloging'),
13
   ( 9, 'edit_items', 'Edit Items'),
13
   ( 9, 'edit_items', 'Edit Items'),
14
   ( 9, 'edit_items_restricted', 'Limit item modification to barcode, status and note (please note that edit_item is still required)'),
15
   ( 9, 'delete_all_items', 'Delete all items at once'),
14
   (10, 'writeoff', 'Write off fines and fees'),
16
   (10, 'writeoff', 'Write off fines and fees'),
15
   (10, 'remaining_permissions', 'Remaining permissions for managing fines and fees'),
17
   (10, 'remaining_permissions', 'Remaining permissions for managing fines and fees'),
16
   (11, 'vendors_manage', 'Manage vendors'),
18
   (11, 'vendors_manage', 'Manage vendors'),
Lines 43-48 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
43
   (13, 'batch_upload_patron_images', 'Upload patron images in a batch or one at a time'),
45
   (13, 'batch_upload_patron_images', 'Upload patron images in a batch or one at a time'),
44
   (13, 'schedule_tasks', 'Schedule tasks to run'),
46
   (13, 'schedule_tasks', 'Schedule tasks to run'),
45
   (13, 'items_batchmod', 'Perform batch modification of items'),
47
   (13, 'items_batchmod', 'Perform batch modification of items'),
48
   (13, 'items_batchmod_restricted', 'Limit batch item modification to item status (please note that items_batchmod is still required)'),
46
   (13, 'items_batchdel', 'Perform batch deletion of items'),
49
   (13, 'items_batchdel', 'Perform batch deletion of items'),
47
   (13, 'manage_csv_profiles', 'Manage CSV export profiles'),
50
   (13, 'manage_csv_profiles', 'Manage CSV export profiles'),
48
   (13, 'moderate_tags', 'Moderate patron tags'),
51
   (13, 'moderate_tags', 'Moderate patron tags'),
(-)a/installer/data/mysql/es-ES/mandatory/userpermissions.sql (+3 lines)
Lines 11-16 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
11
   ( 9, 'edit_catalogue', 'Edit catalog (Modify bibliographic/holdings data)'),
11
   ( 9, 'edit_catalogue', 'Edit catalog (Modify bibliographic/holdings data)'),
12
   ( 9, 'fast_cataloging', 'Fast cataloging'),
12
   ( 9, 'fast_cataloging', 'Fast cataloging'),
13
   ( 9, 'edit_items', 'Edit Items'),
13
   ( 9, 'edit_items', 'Edit Items'),
14
   ( 9, 'edit_items_restricted', 'Limit item modification to barcode, status and note (please note that edit_item is still required)'),
15
   ( 9, 'delete_all_items', 'Delete all items at once'),
14
   (10, 'writeoff', 'Write off fines and fees'),
16
   (10, 'writeoff', 'Write off fines and fees'),
15
   (10, 'remaining_permissions', 'Remaining permissions for managing fines and fees'),
17
   (10, 'remaining_permissions', 'Remaining permissions for managing fines and fees'),
16
   (11, 'vendors_manage', 'Manage vendors'),
18
   (11, 'vendors_manage', 'Manage vendors'),
Lines 43-48 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
43
   (13, 'batch_upload_patron_images', 'Upload patron images in a batch or one at a time'),
45
   (13, 'batch_upload_patron_images', 'Upload patron images in a batch or one at a time'),
44
   (13, 'schedule_tasks', 'Schedule tasks to run'),
46
   (13, 'schedule_tasks', 'Schedule tasks to run'),
45
   (13, 'items_batchmod', 'Perform batch modification of items'),
47
   (13, 'items_batchmod', 'Perform batch modification of items'),
48
   (13, 'items_batchmod_restricted', 'Limit batch item modification to item status (please note that items_batchmod is still required)'),
46
   (13, 'items_batchdel', 'Perform batch deletion of items'),
49
   (13, 'items_batchdel', 'Perform batch deletion of items'),
47
   (13, 'manage_csv_profiles', 'Manage CSV export profiles'),
50
   (13, 'manage_csv_profiles', 'Manage CSV export profiles'),
48
   (13, 'moderate_tags', 'Moderate patron tags'),
51
   (13, 'moderate_tags', 'Moderate patron tags'),
(-)a/installer/data/mysql/fr-FR/1-Obligatoire/userpermissions.sql (+3 lines)
Lines 11-16 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
11
   ( 9, 'edit_catalogue', 'Ajouter et modifier des notices au catalogue'),
11
   ( 9, 'edit_catalogue', 'Ajouter et modifier des notices au catalogue'),
12
   ( 9, 'fast_cataloging', 'Catalogage rapide'),
12
   ( 9, 'fast_cataloging', 'Catalogage rapide'),
13
   ( 9, 'edit_items', 'Modifier des exemplaires'),
13
   ( 9, 'edit_items', 'Modifier des exemplaires'),
14
   ( 9, 'edit_items_restricted', 'Limit item modification to barcode, status and note (please note that edit_item is still required)'),
15
   ( 9, 'delete_all_items', 'Delete all items at once'),
14
   (10, 'writeoff', 'Write off fines and fees'),
16
   (10, 'writeoff', 'Write off fines and fees'),
15
   (10, 'remaining_permissions', 'Remaining permissions for managing fines and fees'),
17
   (10, 'remaining_permissions', 'Remaining permissions for managing fines and fees'),
16
   (13, 'edit_news', 'Ecrire des nouvelles pour l''OPAC et l''interface professionnelle'),
18
   (13, 'edit_news', 'Ecrire des nouvelles pour l''OPAC et l''interface professionnelle'),
Lines 47-52 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
47
   (13, 'moderate_tags', 'Modérer les tags des adhérents'),
49
   (13, 'moderate_tags', 'Modérer les tags des adhérents'),
48
   (13, 'rotating_collections', 'Gérer les collections tournantes'),
50
   (13, 'rotating_collections', 'Gérer les collections tournantes'),
49
   (13, 'items_batchmod', 'Modifier les exemplaires par lot'),
51
   (13, 'items_batchmod', 'Modifier les exemplaires par lot'),
52
   (13, 'items_batchmod_restricted', 'Limit batch item modification to item status (please note that items_batchmod is still required)'),
50
   (13, 'items_batchdel', 'Supprimer les exemplaires par lot'),
53
   (13, 'items_batchdel', 'Supprimer les exemplaires par lot'),
51
   (13, 'upload_local_cover_images', 'Téléchargement des images de couverture'),
54
   (13, 'upload_local_cover_images', 'Téléchargement des images de couverture'),
52
   (13, 'manage_patron_lists', 'Add, edit and delete patron lists and their contents'),
55
   (13, 'manage_patron_lists', 'Add, edit and delete patron lists and their contents'),
(-)a/installer/data/mysql/it-IT/necessari/userpermissions.sql (+3 lines)
Lines 13-18 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
13
   ( 9, 'edit_catalogue', 'Cataloga (crea/modifica dati bibliografici e di copia)'),
13
   ( 9, 'edit_catalogue', 'Cataloga (crea/modifica dati bibliografici e di copia)'),
14
   ( 9, 'fast_cataloging', 'Catalogazione veloce'),
14
   ( 9, 'fast_cataloging', 'Catalogazione veloce'),
15
   ( 9, 'edit_items', 'Crea/modifica copie'),
15
   ( 9, 'edit_items', 'Crea/modifica copie'),
16
   ( 9, 'edit_items_restricted', 'Limit item modification to barcode, status and note (please note that edit_item is still required)'),
17
   ( 9, 'delete_all_items', 'Delete all items at once'),
16
   (10, 'writeoff', 'Write off fines and fees'),
18
   (10, 'writeoff', 'Write off fines and fees'),
17
   (10, 'remaining_permissions', 'Remaining permissions for managing fines and fees'),
19
   (10, 'remaining_permissions', 'Remaining permissions for managing fines and fees'),
18
   (11, 'vendors_manage', 'Crea/modifica fornitori'),
20
   (11, 'vendors_manage', 'Crea/modifica fornitori'),
Lines 45-50 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
45
   (13, 'batch_upload_patron_images', 'Aggiorna le foto utente in modalità batch o al momento'),
47
   (13, 'batch_upload_patron_images', 'Aggiorna le foto utente in modalità batch o al momento'),
46
   (13, 'schedule_tasks', 'Schedula i task da far andare'),
48
   (13, 'schedule_tasks', 'Schedula i task da far andare'),
47
   (13, 'items_batchmod', 'Abilita alla modifica batch delle copie'),
49
   (13, 'items_batchmod', 'Abilita alla modifica batch delle copie'),
50
   (13, 'items_batchmod_restricted', 'Limit batch item modification to item status (please note that items_batchmod is still required)'),
48
   (13, 'items_batchdel', 'Abilita alla cancellazione via batch delle copie'),
51
   (13, 'items_batchdel', 'Abilita alla cancellazione via batch delle copie'),
49
   (13, 'manage_csv_profiles', 'Gestisci i profili CSV di export'),
52
   (13, 'manage_csv_profiles', 'Gestisci i profili CSV di export'),
50
   (13, 'moderate_tags', 'Modera i tag inseriti dagli utenti'),
53
   (13, 'moderate_tags', 'Modera i tag inseriti dagli utenti'),
(-)a/installer/data/mysql/nb-NO/1-Obligatorisk/userpermissions.sql (+3 lines)
Lines 31-36 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
31
   ( 9, 'edit_catalogue', 'Endre katalogen (Endre bibliografiske poster og eksemplaropplysninger)'),
31
   ( 9, 'edit_catalogue', 'Endre katalogen (Endre bibliografiske poster og eksemplaropplysninger)'),
32
   ( 9, 'fast_cataloging', 'Hurtigkatalogisering'),
32
   ( 9, 'fast_cataloging', 'Hurtigkatalogisering'),
33
   ( 9, 'edit_items', 'Endre eksmeplarer'),
33
   ( 9, 'edit_items', 'Endre eksmeplarer'),
34
   ( 9, 'edit_items_restricted', 'Limit item modification to barcode, status and note (please note that edit_item is still required)'),
35
   ( 9, 'delete_all_items', 'Delete all items at once'),
34
   (10, 'writeoff', 'Write off fines and fees'),
36
   (10, 'writeoff', 'Write off fines and fees'),
35
   (10, 'remaining_permissions', 'Remaining permissions for managing fines and fees'),
37
   (10, 'remaining_permissions', 'Remaining permissions for managing fines and fees'),
36
   (11, 'vendors_manage', 'Administrere leverandører'),
38
   (11, 'vendors_manage', 'Administrere leverandører'),
Lines 63-68 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
63
   (13, 'batch_upload_patron_images', 'Laste opp bilder av lånere enkeltvis eller en masse'),
65
   (13, 'batch_upload_patron_images', 'Laste opp bilder av lånere enkeltvis eller en masse'),
64
   (13, 'schedule_tasks', 'Planlegge oppgaver som skal kjøres'),
66
   (13, 'schedule_tasks', 'Planlegge oppgaver som skal kjøres'),
65
   (13, 'items_batchmod', 'Utføre masseendringer av eksemplarer'),
67
   (13, 'items_batchmod', 'Utføre masseendringer av eksemplarer'),
68
   (13, 'items_batchmod_restricted', 'Limit batch item modification to item status (please note that items_batchmod is still required)'),
66
   (13, 'items_batchdel', 'Utføre masseslettinger av eksemplarer'),
69
   (13, 'items_batchdel', 'Utføre masseslettinger av eksemplarer'),
67
   (13, 'manage_csv_profiles', 'Administrere CSV eksportprofiler'),
70
   (13, 'manage_csv_profiles', 'Administrere CSV eksportprofiler'),
68
   (13, 'moderate_tags', 'Behandle tagger fra lånere'),
71
   (13, 'moderate_tags', 'Behandle tagger fra lånere'),
(-)a/installer/data/mysql/pl-PL/mandatory/userpermissions.sql (+3 lines)
Lines 11-16 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
11
   ( 9, 'edit_catalogue', 'Edit catalogue'),
11
   ( 9, 'edit_catalogue', 'Edit catalogue'),
12
   ( 9, 'fast_cataloging', 'Szybkie katalogowanie'),
12
   ( 9, 'fast_cataloging', 'Szybkie katalogowanie'),
13
   ( 9, 'edit_items', 'Edit Items'),
13
   ( 9, 'edit_items', 'Edit Items'),
14
   ( 9, 'edit_items_restricted', 'Limit item modification to barcode, status and note (please note that edit_item is still required)'),
15
   ( 9, 'delete_all_items', 'Delete all items at once'),
14
   (10, 'writeoff', 'Write off fines and fees'),
16
   (10, 'writeoff', 'Write off fines and fees'),
15
   (10, 'remaining_permissions', 'Remaining permissions for managing fines and fees'),
17
   (10, 'remaining_permissions', 'Remaining permissions for managing fines and fees'),
16
   (11, 'vendors_manage', 'Zarządzanei dostawcami'),
18
   (11, 'vendors_manage', 'Zarządzanei dostawcami'),
Lines 43-48 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
43
   (13, 'batch_upload_patron_images', 'Upload patron images in a batch or one at a time'),
45
   (13, 'batch_upload_patron_images', 'Upload patron images in a batch or one at a time'),
44
   (13, 'schedule_tasks', 'Schedule tasks to run'),
46
   (13, 'schedule_tasks', 'Schedule tasks to run'),
45
   (13, 'items_batchmod', 'Perform batch modification of items'),
47
   (13, 'items_batchmod', 'Perform batch modification of items'),
48
   (13, 'items_batchmod_restricted', 'Limit batch item modification to item status (please note that items_batchmod is still required)'),
46
   (13, 'items_batchdel', 'Perform batch deletion of items'),
49
   (13, 'items_batchdel', 'Perform batch deletion of items'),
47
   (13, 'manage_csv_profiles', 'Manage CSV export profiles'),
50
   (13, 'manage_csv_profiles', 'Manage CSV export profiles'),
48
   (13, 'moderate_tags', 'Moderate patron tags'),
51
   (13, 'moderate_tags', 'Moderate patron tags'),
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +22 lines)
Lines 8465-8470 if ( CheckVersion($DBversion) ) { Link Here
8465
    SetVersion($DBversion);
8465
    SetVersion($DBversion);
8466
}
8466
}
8467
8467
8468
$DBversion = "3.15.00.XXX";
8469
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
8470
    $dbh->do(q{
8471
        INSERT INTO permissions (module_bit, code, description) VALUES ('9', 'edit_items_restricted', 'Limit item modification to barcode, status and note (please note that edit_item is still required)');
8472
    });
8473
8474
    $dbh->do(q{
8475
        INSERT INTO permissions (module_bit, code, description) VALUES ('9', 'delete_all_items', 'Delete all items at once');
8476
    });
8477
8478
    $dbh->do(q{
8479
        INSERT INTO permissions (module_bit, code, description) VALUES ('13', 'items_batchmod_restricted', 'Limit batch item modification to item status (please note that items_batchmod is still required)');
8480
    });
8481
8482
    # The delete_all_items permission should be added to users having the edit_items permission.
8483
    $dbh->do(q{
8484
        INSERT INTO user_permissions (borrowernumber, module_bit, code) SELECT borrowernumber, module_bit, "delete_all_items" FROM user_permissions WHERE code="edit_items";
8485
    });
8486
    print "Upgrade to $DBversion done (Bug 7673: Adds new permissions edit_items_restricted, delete_all_items and items_batchmod_restricted)\n";
8487
    SetVersion($DBversion);
8488
}
8489
8468
=head1 FUNCTIONS
8490
=head1 FUNCTIONS
8469
8491
8470
=head2 TableExists($table)
8492
=head2 TableExists($table)
8471
- 

Return to bug 7673