Bugzilla – Attachment 1076 Details for
Bug 3080
"spent" of budget and funds doesn't work
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
follow up
0001--followup-bug-3080-refix-the-sql-request.patch (text/plain), 1.38 KB, created by
Chris Cormack
on 2009-07-02 10:31:00 UTC
(
hide
)
Description:
follow up
Filename:
MIME Type:
Creator:
Chris Cormack
Created:
2009-07-02 10:31:00 UTC
Size:
1.38 KB
patch
obsolete
>From 86e4d9352ff76919f7cee73d3e47799cbe83f4fc Mon Sep 17 00:00:00 2001 >From: Nahuel ANGELINETTI <nahuel.angelinetti@biblibre.com> >Date: Thu, 2 Jul 2009 12:30:05 +0200 >Subject: [PATCH] [followup](bug #3080) refix the sql request >Content-Type: text/plain; charset="utf-8" > >This fix the sql request that have some problems of synthax and a table repeated in "FROM". >--- > acqui/spent.pl | 10 ++++------ > 1 files changed, 4 insertions(+), 6 deletions(-) > >diff --git a/acqui/spent.pl b/acqui/spent.pl >index 578ed9b..6271b05 100755 >--- a/acqui/spent.pl >+++ b/acqui/spent.pl >@@ -33,14 +33,12 @@ my $query = > quantity-quantityreceived as tleft, > aqorders.ordernumber > as ordnum,entrydate,budgetdate,booksellerid,aqbasket.basketno >- from aqorderbreakdown,aqbasket,aqorders >+ from aqorderbreakdown,aqorders > left join biblioitems on biblioitems.biblioitemnumber=aqorders.biblioitemnumber >- LEFT JOINaqbasket USING (basketno) >+ LEFT JOIN aqbasket USING (basketno) > where bookfundid=? and >- aqorders.ordernumber=aqorderbreakdown.ordernumber and >- aqorders.basketno=aqbasket.basketno >- and ( >- (datereceived >= ? and datereceived < ?)) >+ aqorders.ordernumber=aqorderbreakdown.ordernumber >+ and (datereceived >= ? and datereceived < ?) > and (datecancellationprinted is NULL or > datecancellationprinted='0000-00-00') > and (closedate >= ? and closedate < ?) >-- >1.6.0.4 >
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 3080
:
1075
| 1076