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

(-)a/C4/HoldsQueue.pm (-1 / +17 lines)
Lines 133-139 sub GetHoldsQueueItems { Link Here
133
    my $dbh   = C4::Context->dbh;
133
    my $dbh   = C4::Context->dbh;
134
134
135
    my @bind_params = ();
135
    my @bind_params = ();
136
    my $query = q/SELECT tmp_holdsqueue.*, biblio.author, items.ccode, items.itype, biblioitems.itemtype, items.location,
136
    my $query = q/SELECT borrowers.surname,
137
                         borrowers.othernames,
138
                         borrowers.firstname,
139
                         borrowers.cardnumber,
140
                         borrowers.borrowernumber,
141
                         borrowers.title AS borrower_title,
142
                         tmp_holdsqueue.*, biblio.author, items.ccode, items.itype, biblioitems.itemtype, items.location,
137
                         items.enumchron, items.cn_sort, biblioitems.publishercode,
143
                         items.enumchron, items.cn_sort, biblioitems.publishercode,
138
                         biblio.copyrightdate, biblio.subtitle, biblio.medium,
144
                         biblio.copyrightdate, biblio.subtitle, biblio.medium,
139
                         biblio.part_number, biblio.part_name,
145
                         biblio.part_number, biblio.part_name,
Lines 143-148 sub GetHoldsQueueItems { Link Here
143
                       JOIN biblio      USING (biblionumber)
149
                       JOIN biblio      USING (biblionumber)
144
                  LEFT JOIN biblioitems USING (biblionumber)
150
                  LEFT JOIN biblioitems USING (biblionumber)
145
                  LEFT JOIN items       USING (  itemnumber)
151
                  LEFT JOIN items       USING (  itemnumber)
152
                  LEFT JOIN borrowers   USING (borrowernumber)
146
                  WHERE 1=1
153
                  WHERE 1=1
147
                /;
154
                /;
148
    if ($params->{branchlimit}) {
155
    if ($params->{branchlimit}) {
Lines 172-177 sub GetHoldsQueueItems { Link Here
172
        }
179
        }
173
        delete $row->{itemtype};
180
        delete $row->{itemtype};
174
181
182
        $row->{borrower} = {
183
            borrowernumber => $row->{borrowernumber},
184
            cardnumber     => $row->{cardnumber},
185
            firstname      => $row->{firstname},
186
            othernames     => $row->{othernames},
187
            surname        => $row->{surname},
188
            title          => $row->{borrower_title},
189
        };
190
175
        push @$items, $row;
191
        push @$items, $row;
176
    }
192
    }
177
    return $items;
193
    return $items;
(-)a/circ/view_holdsqueue.pl (-3 / +1 lines)
Lines 54-62 if ( $run_report ) { Link Here
54
        ccodeslimit => $ccodeslimit,
54
        ccodeslimit => $ccodeslimit,
55
        locationslimit => $locationslimit
55
        locationslimit => $locationslimit
56
    });
56
    });
57
    for my $item ( @$items ) {
57
58
        $item->{patron} = Koha::Patrons->find( $item->{borrowernumber} );
59
    }
60
    $template->param(
58
    $template->param(
61
        branchlimit     => $branchlimit,
59
        branchlimit     => $branchlimit,
62
        itemtypeslimit     => $itemtypeslimit,
60
        itemtypeslimit     => $itemtypeslimit,
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/circ/view_holdsqueue.tt (-2 / +1 lines)
Lines 187-193 Link Here
187
            </td>
187
            </td>
188
            <td class="hq-patron">
188
            <td class="hq-patron">
189
              <p>
189
              <p>
190
                  [% INCLUDE 'patron-title.inc' invert_name=1 patron=itemsloo.patron hide_patron_infos_if_needed=1 link_to="circulation_reserves" %]
190
                  [% INCLUDE 'patron-title.inc' invert_name=1 borrower=itemsloo.borrower hide_patron_infos_if_needed=0 link_to="circulation_reserves" %]
191
              </p>
191
              </p>
192
              [% UNLESS Koha.Preference('HidePatronName') %]
192
              [% UNLESS Koha.Preference('HidePatronName') %]
193
                 <p>[% itemsloo.patron.phone | html %]</p>
193
                 <p>[% itemsloo.patron.phone | html %]</p>
194
- 

Return to bug 28966