Bugzilla – Attachment 15946 Details for
Bug 6898
circulation librarians can't run overdues without reports permissions
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
[SIGNED-OFF] Bug 6898 - circulation librarians can't run overdues without reports permissions followup
Bug-6898---circulation-librarians-cant-run-overdue.patch (text/plain), 1.69 KB, created by
Kyle M Hall (khall)
on 2013-03-07 17:18:16 UTC
(
hide
)
Description:
[SIGNED-OFF] Bug 6898 - circulation librarians can't run overdues without reports permissions followup
Filename:
MIME Type:
Creator:
Kyle M Hall (khall)
Created:
2013-03-07 17:18:16 UTC
Size:
1.69 KB
patch
obsolete
>From 06df5a8df860cee6537d4476a8ba467c93ce615e Mon Sep 17 00:00:00 2001 >From: Fridolyn SOMERS <fridolyn.somers@biblibre.com> >Date: Thu, 7 Mar 2013 12:17:33 -0500 >Subject: [PATCH] Bug 6898 - circulation librarians can't run overdues without reports permissions followup > >Better update database. > >Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> >--- > installer/data/mysql/updatedatabase.pl | 14 +++++++++++++- > 1 files changed, 13 insertions(+), 1 deletions(-) > >diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl >index 5ca7850..02b6bd1 100755 >--- a/installer/data/mysql/updatedatabase.pl >+++ b/installer/data/mysql/updatedatabase.pl >@@ -6477,7 +6477,19 @@ if ( CheckVersion($DBversion) ) { > } > $DBversion = "3.11.00.XXX"; > if ( CheckVersion($DBversion) ) { >- $dbh->do("INSERT INTO permissions ( module_bit, code, description ) VALUES ( '1', 'overdues_report', 'Execute overdue items report' )"); >+ $dbh->do(q{ >+ INSERT INTO permissions ( module_bit, code, description ) >+ VALUES ( '1', 'overdues_report', 'Execute overdue items report' ) >+ }); >+ # add new permission for users with all report permissions and circulation remaining permission >+ my $sth = $dbh->prepare(q{ >+ INSERT INTO user_permissions (borrowernumber, module_bit, code) >+ SELECT user_permissions.borrowernumber, 1, 'overdues_report' >+ FROM user_permissions >+ LEFT JOIN borrowers USING(borrowernumber) >+ WHERE borrowers.flags & (1 << 16) >+ AND user_permissions.code = 'circulate_remaining_permissions' >+ }); > print "Upgrade to $DBversion done ( Add circ permission overdues_report )\n"; > SetVersion($DBversion); > } >-- >1.7.2.5
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 6898
:
7568
|
8233
|
14680
|
15162
|
15939
|
15940
|
15946
|
15947
|
15948
|
15966
|
15974
|
15975
|
16034
|
16035
|
16207
|
16208
|
18670
|
19434
|
19541