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

(-)a/C4/Acquisition.pm (+3 lines)
Lines 635-640 sub GetBasketsInfosByBookseller { Link Here
635
    my $query = qq{
635
    my $query = qq{
636
        SELECT aqbasket.*,
636
        SELECT aqbasket.*,
637
          SUM(aqorders.quantity) AS total_items,
637
          SUM(aqorders.quantity) AS total_items,
638
          SUM(
639
            IF ( aqorders.orderstatus = 'cancelled', aqorders.quantity, 0 )
640
          ) AS total_items_cancelled,
638
          COUNT(DISTINCT aqorders.biblionumber) AS total_biblios,
641
          COUNT(DISTINCT aqorders.biblionumber) AS total_biblios,
639
          SUM(
642
          SUM(
640
            IF(aqorders.datereceived IS NULL
643
            IF(aqorders.datereceived IS NULL
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/acqui/booksellers.tt (-2 / +6 lines)
Lines 116-122 $(document).ready(function() { Link Here
116
                                    [% END %]
116
                                    [% END %]
117
                                        <td>[% basket.basketno %]</td>
117
                                        <td>[% basket.basketno %]</td>
118
                                        <td>[% basket.basketname %]</td>
118
                                        <td>[% basket.basketname %]</td>
119
                                        <td>[% basket.total_items %]</td>
119
                                        <td>
120
                                            [% basket.total_items %]
121
                                            [% IF basket.total_items_cancelled %]
122
                                                ([% basket.total_items_cancelled %] cancelled)
123
                                            [% END %]
124
                                        </td>
120
                                        <td>[% basket.total_biblios %]</td>
125
                                        <td>[% basket.total_biblios %]</td>
121
                                        <td>[% basket.expected_items %]</td>
126
                                        <td>[% basket.expected_items %]</td>
122
                                        <td>
127
                                        <td>
123
- 

Return to bug 11243