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

(-)a/C4/Items.pm (-1 / +3 lines)
Lines 706-711 sub GetItemsInfo { Link Here
706
    my $dbh   = C4::Context->dbh;
706
    my $dbh   = C4::Context->dbh;
707
    require C4::Languages;
707
    require C4::Languages;
708
    my $language = C4::Languages::getlanguage();
708
    my $language = C4::Languages::getlanguage();
709
    my $branch = C4::Context->preference("DefaultItemSortOrder") || 'home';
709
    my $query = "
710
    my $query = "
710
    SELECT items.*,
711
    SELECT items.*,
711
           biblio.*,
712
           biblio.*,
Lines 757-763 sub GetItemsInfo { Link Here
757
        AND localization.lang = ?
758
        AND localization.lang = ?
758
    |;
759
    |;
759
760
760
    $query .= " WHERE items.biblionumber = ? ORDER BY home.branchname, items.enumchron, LPAD( items.copynumber, 8, '0' ), items.dateaccessioned DESC" ;
761
    $query .= " WHERE items.biblionumber = ? ORDER BY $branch.branchname, items.enumchron, LPAD( items.copynumber, 8, '0' ), items.dateaccessioned DESC" ;
762
761
    my $sth = $dbh->prepare($query);
763
    my $sth = $dbh->prepare($query);
762
    $sth->execute($language, $biblionumber);
764
    $sth->execute($language, $biblionumber);
763
    my $i = 0;
765
    my $i = 0;
(-)a/installer/data/mysql/atomicupdate/bug_9264.perl (+9 lines)
Line 0 Link Here
1
$DBversion = 'XXX';
2
if( CheckVersion( $DBversion ) ) {
3
    $dbh->do(q{
4
        INSERT IGNORE INTO systempreferences
5
        ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES
6
        ('DefaultItemSortOrder', 'home', 'home|holding', 'Define the default sort order for items.', 'Choice' )
7
    });
8
    NewVersion( $DBversion, 9264, "Add DefaultItemSortOrder preference");
9
}
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/searching.pref (-1 / +8 lines)
Lines 283-285 Searching: Link Here
283
            - LIBRIS base URL
283
            - LIBRIS base URL
284
            - pref: LibrisURL
284
            - pref: LibrisURL
285
            - "Please only change this if you are sure it needs changing."
285
            - "Please only change this if you are sure it needs changing."
286
- 
286
        -
287
            - The default sort order for items should be by the item's
288
            - pref: DefaultItemSortOrder
289
              type: choice
290
              default: home
291
              choices:
292
                  home: "home library"
293
                  holding: "holding library"

Return to bug 9264