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 11-16 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
11
   ( 9, 'edit_catalogue', 'Cataloga (crea/modifica dati bibliografici e di copia)'),
11
   ( 9, 'edit_catalogue', 'Cataloga (crea/modifica dati bibliografici e di copia)'),
12
   ( 9, 'fast_cataloging', 'Catalogazione veloce'),
12
   ( 9, 'fast_cataloging', 'Catalogazione veloce'),
13
   ( 9, 'edit_items', 'Crea/modifica copie'),
13
   ( 9, 'edit_items', 'Crea/modifica copie'),
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', 'Cancellare multe e tariffe'),
16
   (10, 'writeoff', 'Cancellare multe e tariffe'),
15
   (10, 'remaining_permissions', 'Permessi rimanenti per gestione multe e costi'),
17
   (10, 'remaining_permissions', 'Permessi rimanenti per gestione multe e costi'),
16
   (11, 'vendors_manage', 'Crea/modifica fornitori'),
18
   (11, 'vendors_manage', 'Crea/modifica fornitori'),
Lines 43-48 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
43
   (13, 'batch_upload_patron_images', 'Aggiorna le foto utente in modalità batch o al momento'),
45
   (13, 'batch_upload_patron_images', 'Aggiorna le foto utente in modalità batch o al momento'),
44
   (13, 'schedule_tasks', 'Schedula i task'),
46
   (13, 'schedule_tasks', 'Schedula i task'),
45
   (13, 'items_batchmod', 'Abilita alla modifica batch delle copie'),
47
   (13, 'items_batchmod', 'Abilita alla modifica batch delle copie'),
48
   (13, 'items_batchmod_restricted', 'Limit batch item modification to item status (please note that items_batchmod is still required)'),
46
   (13, 'items_batchdel', 'Abilita alla cancellazione via batch delle copie'),
49
   (13, 'items_batchdel', 'Abilita alla cancellazione via batch delle copie'),
47
   (13, 'manage_csv_profiles', 'Gestisci i profili CSV di export'),
50
   (13, 'manage_csv_profiles', 'Gestisci i profili CSV di export'),
48
   (13, 'moderate_tags', 'Modera i tag inseriti dagli utenti'),
51
   (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 8613-8618 if ( CheckVersion($DBversion) ) { Link Here
8613
    SetVersion($DBversion);
8613
    SetVersion($DBversion);
8614
}
8614
}
8615
8615
8616
$DBversion = "3.17.00.XXX";
8617
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
8618
    $dbh->do(q{
8619
        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)');
8620
    });
8621
8622
    $dbh->do(q{
8623
        INSERT INTO permissions (module_bit, code, description) VALUES ('9', 'delete_all_items', 'Delete all items at once');
8624
    });
8625
8626
    $dbh->do(q{
8627
        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)');
8628
    });
8629
8630
    # The delete_all_items permission should be added to users having the edit_items permission.
8631
    $dbh->do(q{
8632
        INSERT INTO user_permissions (borrowernumber, module_bit, code) SELECT borrowernumber, module_bit, "delete_all_items" FROM user_permissions WHERE code="edit_items";
8633
    });
8634
    print "Upgrade to $DBversion done (Bug 7673: Adds new permissions edit_items_restricted, delete_all_items and items_batchmod_restricted)\n";
8635
    SetVersion($DBversion);
8636
}
8637
8616
=head1 FUNCTIONS
8638
=head1 FUNCTIONS
8617
8639
8618
=head2 TableExists($table)
8640
=head2 TableExists($table)
8619
- 

Return to bug 7673