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

(-)a/C4/Acquisition.pm (-10 / +7 lines)
Lines 72-91 sub GetOrderFromItemnumber { Link Here
72
    my ($itemnumber) = @_;
72
    my ($itemnumber) = @_;
73
    my $dbh          = C4::Context->dbh;
73
    my $dbh          = C4::Context->dbh;
74
    my $query        = qq|
74
    my $query        = qq|
75
75
        SELECT ord.* from aqorders ord
76
    SELECT  * from aqorders    LEFT JOIN aqorders_items
76
        LEFT JOIN items it ON it.biblionumber=ord.biblionumber
77
    ON (     aqorders.ordernumber = aqorders_items.ordernumber   )
77
        WHERE it.itemnumber=?|;
78
    WHERE itemnumber = ?  |;
78
   #Bugzilla 6916: query used join with aqorders_items, but this only
79
   #worked if syspref AcqCreateItems == placing an order. Now we use items.
80
   #It is not needed to return columns from tables other than aqorders.
79
81
80
    my $sth = $dbh->prepare($query);
82
    my $sth = $dbh->prepare($query);
81
82
#    $sth->trace(3);
83
84
    $sth->execute($itemnumber);
83
    $sth->execute($itemnumber);
85
86
    my $order = $sth->fetchrow_hashref;
84
    my $order = $sth->fetchrow_hashref;
87
    return ( $order  );
85
    return $order;
88
89
}
86
}
90
87
91
# Returns the itemnumber(s) associated with the ordernumber given in parameter
88
# Returns the itemnumber(s) associated with the ordernumber given in parameter
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/catalogue/moredetail.tt (-8 / +4 lines)
Lines 151-170 Link Here
151
            <div class="listgroup"><h4>History</h4>
151
            <div class="listgroup"><h4>History</h4>
152
            <ol class="bibliodetails">
152
            <ol class="bibliodetails">
153
153
154
                <li><span class="label">
154
                <li><span class="label">Accession Date:</span>
155
                [% IF ( CAN_user_editcatalogue_edit_catalogue ) %]
155
                [% IF ( CAN_user_editcatalogue_edit_catalogue ) %]
156
157
                    Accession Date:</span>
158
                    [% IF ( ITEM_DAT.basketno ) %]
156
                    [% IF ( ITEM_DAT.basketno ) %]
159
                    <a href="/cgi-bin/koha/acqui/parcel.pl?supplierid=[% ITEM_DAT.booksellerid %]&amp;invoice=[% ITEM_DAT.booksellerinvoicenumber %]&amp;datereceived=[% ITEM_DAT.datereceived %]">[% ITEM_DAT.dateaccessioned %]</a>
157
                        <a href="/cgi-bin/koha/acqui/parcel.pl?supplierid=[% ITEM_DAT.booksellerid %]&amp;invoice=[% ITEM_DAT.booksellerinvoicenumber %]&amp;datereceived=[% ITEM_DAT.datereceived %]">[% ITEM_DAT.dateaccessioned %]</a>
160
                    [% ELSE %]
158
                    [% ELSE %]
161
                    [% ITEM_DAT.dateaccessioned %]
159
                        [% ITEM_DAT.dateaccessioned %]
162
                    [% END %]
160
                    [% END %]
163
                [% ELSE %]
161
                [% ELSE %]
164
                    [% ITEM_DAT.dateaccessioned %]
162
                    [% ITEM_DAT.dateaccessioned %]
165
                [% END %] </li>
163
                [% END %] &nbsp;</li>
166
164
167
                
168
                <li><span class="label">Total Checkouts:</span>[% IF ( ITEM_DAT.issues ) %][% ITEM_DAT.issues %][% ELSE %]0[% END %]  (<a href="/cgi-bin/koha/circ/bookcount.pl?&amp;biblionumber=[% ITEM_DAT.biblionumber %]&amp;bi=[% ITEM_DAT.biblioitemnumber %]&amp;itm=[% ITEM_DAT.itemnumber %]">View item's checkout history</a>)</li>
165
                <li><span class="label">Total Checkouts:</span>[% IF ( ITEM_DAT.issues ) %][% ITEM_DAT.issues %][% ELSE %]0[% END %]  (<a href="/cgi-bin/koha/circ/bookcount.pl?&amp;biblionumber=[% ITEM_DAT.biblionumber %]&amp;bi=[% ITEM_DAT.biblioitemnumber %]&amp;itm=[% ITEM_DAT.itemnumber %]">View item's checkout history</a>)</li>
169
166
170
                <li><span class="label">Last seen:</span> [% ITEM_DAT.datelastseen %]&nbsp;</li>
167
                <li><span class="label">Last seen:</span> [% ITEM_DAT.datelastseen %]&nbsp;</li>
171
- 

Return to bug 6916