Bugzilla – Attachment 7998 Details for
Bug 7271
Revert getitems default sort to homebranch instead of holding branch
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 7271 - change sort in items.pm to sort by home library instead of holding branch
Bug-7271---change-sort-in-itemspm-to-sort-by-home-.patch (text/plain), 1.56 KB, created by
Chris Cormack
on 2012-03-03 07:35:58 UTC
(
hide
)
Description:
Bug 7271 - change sort in items.pm to sort by home library instead of holding branch
Filename:
MIME Type:
Creator:
Chris Cormack
Created:
2012-03-03 07:35:58 UTC
Size:
1.56 KB
patch
obsolete
>From ca909b1e9d57a2a4f7b79d978ed33735e5f4d2c4 Mon Sep 17 00:00:00 2001 >From: Liz Rea <wizzyrea@gmail.com> >Date: Mon, 28 Nov 2011 11:39:33 -0600 >Subject: [PATCH] Bug 7271 - change sort in items.pm to sort by home library > instead of holding branch > >Signed-off-by: Chris Cormack <chris@bigballofwax.co.nz> >--- > C4/Items.pm | 7 ++++--- > 1 files changed, 4 insertions(+), 3 deletions(-) > >diff --git a/C4/Items.pm b/C4/Items.pm >index 8025529..b257e52 100644 >--- a/C4/Items.pm >+++ b/C4/Items.pm >@@ -1185,14 +1185,15 @@ sub GetItemsInfo { > items.notforloan as itemnotforloan, > itemtypes.description, > itemtypes.notforloan as notforloan_per_itemtype, >- branchurl >+ holding.branchurl > FROM items >- LEFT JOIN branches ON items.holdingbranch = branches.branchcode >+ LEFT JOIN branches AS holding ON items.holdingbranch = holding.branchcode >+ LEFT JOIN branches AS home ON items.homebranch=home.branchcode > LEFT JOIN biblio ON biblio.biblionumber = items.biblionumber > LEFT JOIN biblioitems ON biblioitems.biblioitemnumber = items.biblioitemnumber > LEFT JOIN itemtypes ON itemtypes.itemtype = " > . (C4::Context->preference('item-level_itypes') ? 'items.itype' : 'biblioitems.itemtype'); >- $query .= " WHERE items.biblionumber = ? ORDER BY branches.branchname,items.dateaccessioned desc" ; >+ $query .= " WHERE items.biblionumber = ? ORDER BY home.branchname,items.dateaccessioned desc" ; > my $sth = $dbh->prepare($query); > $sth->execute($biblionumber); > my $i = 0; >-- >1.7.5.4
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 7271
:
6450
| 7998