The offline circulation tool can use all of the patron information, not just
their ID
numbers. This patch populates the offline circulation database with patron
information.
---
misc/cronjobs/create_koc_db.pl | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/misc/cronjobs/create_koc_db.pl b/misc/cronjobs/create_koc_db.pl
index c1baa50..ab5c7f2 100755
--- a/misc/cronjobs/create_koc_db.pl
+++ b/misc/cronjobs/create_koc_db.pl
@@ -206,7 +206,7 @@ sub populate_borrowers_table {
my $sth_sqlite = $dbh_sqlite->prepare($sql);
my $sth_mysql = $dbh_mysql->prepare(<<'END_SQL');
-SELECT borrowers.borrowernumber, sum( accountlines.amountoutstanding ) as
total_fines
+SELECT borrowers.*, sum( accountlines.amountoutstanding ) as total_fines
FROM borrowers
LEFT JOIN accountlines
ON borrowers.borrowernumber = accountlines.borrowernumber
--
1.5.6
_______________________________________________
Koha-patches mailing list
[email protected]
http://lists.koha.org/mailman/listinfo/koha-patches
