[Koha-patches] [PATCH] (bug #3080) fix the acqui/spent.pl

[Galen Charlton]

Hi,

This patch does not apply to HEAD, and doesn't appear to take into
account James Winter's work on spent.pl.  Furthermore, the description
you entered for bug 3080 ["The page which contains the spent funds
doesn't work, it should :)"] is not useful: is spent.pl crashing for
you?  Not giving correct results?  What?

Regards,

Galen

On Wed, Apr 1, 2009 at 8:44 AM, Nahuel ANGELINETTI
<nahuel.angelinetti at biblibre.com> wrote:
> this patch fix the sql request used in spent.pl
> ---
>  acqui/spent.pl |    2 +-
>  1 files changed, 1 insertions(+), 1 deletions(-)
>
> diff --git a/acqui/spent.pl b/acqui/spent.pl
> index f73537b..af6f1ea 100755
> --- a/acqui/spent.pl
> +++ b/acqui/spent.pl
> @@ -33,7 +33,7 @@ my $query =
>     quantity-quantityreceived as tleft,
>     aqorders.ordernumber
>     as ordnum,entrydate,budgetdate,booksellerid,aqbasket.basketno
> -    from aqorders,aqorderbreakdown,aqbasket
> +    from aqorderbreakdown,aqbasket,aqorders
>     left join biblioitems on  biblioitems.biblioitemnumber=aqorders.biblioitemnumber
>     where bookfundid=? and
>     aqorders.ordernumber=aqorderbreakdown.ordernumber and
> --
> 1.5.6.3
>
> _______________________________________________
> Koha-patches mailing list
> Koha-patches at lists.koha.org
> http://lists.koha.org/mailman/listinfo/koha-patches
>



-- 
Galen Charlton
VP, Research & Development, LibLime
galen.charlton at liblime.com
p: 1-888-564-2457 x709
skype: gmcharlt