16 # &Date_Init("DateFormat=non-US"); # set non-USA date, eg:19/08/2005
19 my $csv = Text::CSV_XS->new(
30 my $supplierid = $query->param('supplierid');
31 my @serialid = $query->param('serialid');
32 my $op = $query->param('op') || q{};
33 my $serialidcount = @serialid;
38 @lateissues = GetLateIssues($supplierid);
39 for my $issue (@lateissues){
41 [ $issue->{'name'}, $issue->{'title'}, $issue->{'serialseq'}, $issue->{'planneddate'},];
47 for (my $k=0;$k<@serialid;$k++){
48 @missingissues = GetLateOrMissingIssues($supplierid, $serialid[$k]);
50 for (my $j=0;$j<@missingissues;$j++){
51 my @rows2 = ($missingissues[$j]->{'name'}, # lets build up a row
52 $missingissues[$j]->{'title'},
53 $missingissues[$j]->{'serialseq'},
54 $missingissues[$j]->{'planneddate'},
56 push (@loop2, \@rows2);
58 $totalcount2 += scalar @missingissues;
59 # update claim date to let one know they have looked at this missing item
60 updateClaim($serialid[$k]);
66 if($missingissues[0]->{'name'}){ # if exists display supplier name in heading for neatness
67 # not necessarily needed as the name will appear in supplier column also
68 $heading = "FOR $missingissues[0]->{'name'}";
69 $filename = "_$missingissues[0]->{'name'}";
74 -type => 'application/vnd.ms-excel',
75 -attachment => "claims".$filename.".csv",
79 print "LATE ISSUES ".$heading."\n\n";
80 print "SUPPLIER,TITLE,ISSUE NUMBER,LATE SINCE\n";
82 for my $row ( @loop1 ) {
85 my $string = $csv->string;
91 if($serialidcount == 1){
92 print "MISSING ISSUE ".$heading."\n\n";
94 print "MISSING ISSUES ".$heading."\n\n";
96 print "SUPPLIER,TITLE,ISSUE NUMBER,LATE SINCE\n";
98 for my $row ( @loop2 ) {
100 $csv->combine(@$row);
101 my $string = $csv->string;
108 my $count = scalar @lateissues;
109 print ",,Total Number Late, $count\n";
111 if($serialidcount == 1){
114 print ",,Total Number Missing, $totalcount2\n";