Bugzilla – Attachment 3802 Details for
Bug 6119
overdue_notices.pl: Add biblioitems.itemtype in columns for items.content
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Add biblioitems.itemtype in columns for items.content
0001-Bug-6119-Add-biblioitems.itemtype-in-columns-for-ite.patch (text/plain), 1.24 KB, created by
Alex Arnaud
on 2011-04-07 14:19:27 UTC
(
hide
)
Description:
Add biblioitems.itemtype in columns for items.content
Filename:
MIME Type:
Creator:
Alex Arnaud
Created:
2011-04-07 14:19:27 UTC
Size:
1.24 KB
patch
obsolete
>From 04d1b529e8acaa0f9cc431589d97f43c202e2cd5 Mon Sep 17 00:00:00 2001 >From: Alex Arnaud <alex.arnaud@biblibre.com> >Date: Thu, 7 Apr 2011 16:18:25 +0200 >Subject: [PATCH] Bug #6119 - Add biblioitems.itemtype in columns for items.content > >--- > misc/cronjobs/overdue_notices.pl | 5 +++-- > 1 files changed, 3 insertions(+), 2 deletions(-) > >diff --git a/misc/cronjobs/overdue_notices.pl b/misc/cronjobs/overdue_notices.pl >index ba7cba8..bc97ecb 100755 >--- a/misc/cronjobs/overdue_notices.pl >+++ b/misc/cronjobs/overdue_notices.pl >@@ -375,10 +375,11 @@ foreach my $branchcode (@branches) { > $verbose and warn sprintf "branchcode : '%s' using %s\n", $branchcode, $admin_email_address; > > my $sth2 = $dbh->prepare( <<'END_SQL' ); >-SELECT biblio.*, items.*, issues.*, TO_DAYS(NOW())-TO_DAYS(date_due) AS days_overdue >- FROM issues,items,biblio >+SELECT biblio.*, items.*, issues.*, biblioitems.itemtype, TO_DAYS(NOW())-TO_DAYS(date_due) AS days_overdue >+ FROM issues,items,biblio, biblioitems > WHERE items.itemnumber=issues.itemnumber > AND biblio.biblionumber = items.biblionumber >+ AND biblio.biblionumber = biblioitems.biblionumber > AND issues.borrowernumber = ? > AND TO_DAYS(NOW())-TO_DAYS(date_due) BETWEEN ? and ? > END_SQL >-- >1.6.3.3 >
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 6119
: 3802