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

(-)a/C4/Acquisition.pm (-2 / +2 lines)
Lines 1006-1013 sub GetOrder { Link Here
1006
                biblioitems.publishercode AS publisher,
1006
                biblioitems.publishercode AS publisher,
1007
                ADDDATE(aqbasket.closedate, INTERVAL aqbooksellers.deliverytime DAY) AS estimateddeliverydate,
1007
                ADDDATE(aqbasket.closedate, INTERVAL aqbooksellers.deliverytime DAY) AS estimateddeliverydate,
1008
                DATE(aqbasket.closedate)  AS orderdate,
1008
                DATE(aqbasket.closedate)  AS orderdate,
1009
                aqorders.quantity - IFNULL(aqorders.quantityreceived,0)                 AS quantity,
1009
                aqorders.quantity - COALESCE(aqorders.quantityreceived,0)                 AS quantity,
1010
                (aqorders.quantity - IFNULL(aqorders.quantityreceived,0)) * aqorders.rrp AS subtotal,
1010
                (aqorders.quantity - COALESCE(aqorders.quantityreceived,0)) * aqorders.rrp AS subtotal,
1011
                DATEDIFF(CURDATE( ),closedate) AS latesince
1011
                DATEDIFF(CURDATE( ),closedate) AS latesince
1012
                FROM aqorders LEFT JOIN biblio ON biblio.biblionumber = aqorders.biblionumber
1012
                FROM aqorders LEFT JOIN biblio ON biblio.biblionumber = aqorders.biblionumber
1013
                LEFT JOIN biblioitems ON biblioitems.biblionumber = biblio.biblionumber
1013
                LEFT JOIN biblioitems ON biblioitems.biblionumber = biblio.biblionumber
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/acqui/lateorders.tt (-1 / +1 lines)
Lines 40-46 $(document).ready(function() { Link Here
40
        var selected = $("input[name='ordernumber']:checked");
40
        var selected = $("input[name='ordernumber']:checked");
41
41
42
        if (selected.length == 0) {
42
        if (selected.length == 0) {
43
            alert(_('Please select at least one item to export.'));
43
            alert(_("Please select at least one item to export."));
44
            return false;
44
            return false;
45
        }
45
        }
46
46
(-)a/serials/lateissues-export.pl (-8 / +7 lines)
Lines 63-73 for (my $k=0;$k<@serialid;$k++){ Link Here
63
    @missingissues = GetLateOrMissingIssues($supplierid, $serialid[$k]);
63
    @missingissues = GetLateOrMissingIssues($supplierid, $serialid[$k]);
64
64
65
    for (my $j=0;$j<@missingissues;$j++){
65
    for (my $j=0;$j<@missingissues;$j++){
66
	my @rows2 = ($missingissues[$j]->{'name'},          # lets build up a row
66
    my @rows2 = ($missingissues[$j]->{'name'},          # lets build up a row
67
	             $missingissues[$j]->{'title'},
67
                 $missingissues[$j]->{'title'},
68
                     $missingissues[$j]->{'serialseq'},
68
                 $missingissues[$j]->{'serialseq'},
69
                     $missingissues[$j]->{'planneddate'},
69
                 $missingissues[$j]->{'planneddate'},
70
                     );
70
                );
71
        push (@loop2, \@rows2);
71
        push (@loop2, \@rows2);
72
    }
72
    }
73
    $totalcount2 += scalar @missingissues;
73
    $totalcount2 += scalar @missingissues;
Lines 79-87 my $heading =''; Link Here
79
my $filename ='';
79
my $filename ='';
80
if($supplierid){
80
if($supplierid){
81
    if($missingissues[0]->{'name'}){ # if exists display supplier name in heading for neatness
81
    if($missingissues[0]->{'name'}){ # if exists display supplier name in heading for neatness
82
	# not necessarily needed as the name will appear in supplier column also
82
    # not necessarily needed as the name will appear in supplier column also
83
        $heading = "FOR $missingissues[0]->{'name'}";
83
        $heading = "FOR $missingissues[0]->{'name'}";
84
	$filename = "_$missingissues[0]->{'name'}";
84
    $filename = "_$missingissues[0]->{'name'}";
85
    }
85
    }
86
}
86
}
87
87
88
- 

Return to bug 7298