-# XXX - POD. Only used in stats.pl, which in turn is never used.
-sub getcharges{
- my($borrowerno,$timestamp)=@_;
- my $dbh=C4Connect;
- my $timestamp2=$timestamp-1;
- my $query="Select * from accountlines where borrowernumber=$borrowerno
- and timestamp = '$timestamp' and accounttype <> 'Pay' and
- accounttype <> 'W'";
- my $sth=$dbh->prepare($query);
-# print $query,"<br>";
- $sth->execute;
- my $i=0;
- my @results;
- while (my $data=$sth->fetchrow_hashref){
-# if ($data->{'timestamp'} == $timestamp){
- $results[$i]=$data;
- $i++;
-# }
- }
- $dbh->disconnect;
- return(@results);
-}
-
-# XXX - POD. This is only used in stats.pl and stats2.pl, neither of
-# which is used.
-sub Getpaidbranch{
- my($date,$borrno)=@_;
- my $dbh=C4Connect;
- my $query="select * from statistics where type='payment' and datetime
- >'$date' and borrowernumber='$borrno'";
- my $sth=$dbh->prepare($query);
- $sth->execute;
-# print $query;
- my $data=$sth->fetchrow_hashref;
- $sth->finish;
- $dbh->disconnect;
- return($data->{'branch'});
-}
-
-# XXX - POD. This is only used in reservereport.pl and
-# reservereport.xls, neither of which is used.
-sub unfilledreserves {
- my $dbh=C4Connect;
- my $query="select *,biblio.title from reserves,reserveconstraints,biblio,borrowers,biblioitems where found <> 'F' and cancellationdate
-is NULL and biblio.biblionumber=reserves.biblionumber and
-reserves.constrainttype='o'
-and (reserves.biblionumber=reserveconstraints.biblionumber
-and reserves.borrowernumber=reserveconstraints.borrowernumber)
-and
-reserves.borrowernumber=borrowers.borrowernumber and
-biblioitems.biblioitemnumber=reserveconstraints.biblioitemnumber order by
-biblio.title,reserves.reservedate";
- my $sth=$dbh->prepare($query);
- $sth->execute;
- my $i=0;
- my @results;
- while (my $data=$sth->fetchrow_hashref){
- $results[$i]=$data;
- $i++;
- }
- $sth->finish;
- $query="select *,biblio.title from reserves,biblio,borrowers where found <> 'F' and cancellationdate
-is NULL and biblio.biblionumber=reserves.biblionumber and reserves.constrainttype='a' and
-reserves.borrowernumber=borrowers.borrowernumber
-order by
-biblio.title,reserves.reservedate";
- $sth=$dbh->prepare($query);
- $sth->execute;
- while (my $data=$sth->fetchrow_hashref){
- $results[$i]=$data;
- $i++;
- }
- $sth->finish;
- $dbh->disconnect;
- return($i,\@results);
-}
-
-END { } # module clean-up code here (global destructor)
-