LIS Links

First and Largest Academic Social Network of LIS Professionals in India

Latest Activity

Manmeet Kaur updated their profile
1 hour ago
MEDARIKA SYIEM updated their profile
4 hours ago
Namita Bayan updated their profile
yesterday
Paojathang Haokip left a comment for paojangul misao
Saturday
Pramod kumar updated their profile
Friday
srikanth updated their profile
Sep 26
Dola Ghosh might attend Dr. U. PRAMANATHAN's event
Sep 24
Mahendra Singh and Navnit Patel are now friends
Sep 24
Rajbir Singh and Dr. Badan Barman are now friends
Sep 23
Santosh Kumar Kori is now friends with DEVENDER and pankaj mishra
Sep 18
Santosh Kumar Kori is attending neema shukla's event
Thumbnail

International Conference on Libraries and Emerging Technologies for Smart Knowledge Ecosystems (ICLET 2025), at Jaipur,Rajasthan

November 14, 2025 at 9am to November 15, 2025 at 6pm
Sep 18
Nayana Nair updated their profile
Sep 18
PRASANNA R updated their profile
Sep 14
Kanika sharma might attend Dr. U. PRAMANATHAN's event
Sep 12
Dr. Asha Peter updated their profile
Sep 10
Dr. Asha Peter is now friends with ANILKUMAR.R and VIJAYAKUMAR V
Sep 10
jai prakash kumar updated their profile
Sep 9
Saradhambal V updated their profile
Sep 7
neema shukla updated their profile
Sep 7
Dr. Bhakti Gala and KUMAR RAJ are now friends
Sep 6

I wants to know how to take monthly fine report in Koha software with the following details

date, name of patron, patrons number, fine amount????

Views: 1750

Reply to This

Replies to This Forum

you click on the link

http://wiki.koha-community.org/wiki/SQL_Reports_Library#Fines_w.2F_...

or

you can copy this and save and run sql command

SELECT      (SELECT CONCAT('<a href=\"/cgi-bin/koha/members/boraccount.pl?borrowernumber=',b.borrowernumber,'\">', b.surname,', ', b.firstname,'</a>')      FROM borrowers b WHERE b.borrowernumber = a.borrowernumber) AS Patron,      format(sum(amountoutstanding),2) AS 'Outstanding',     (SELECT count(i.itemnumber) FROM issues i WHERE b.borrowernumber = i.borrowernumber) AS 'Checkouts' FROM      accountlines a, borrowers b WHERE      (SELECT sum(amountoutstanding) FROM accountlines a2 WHERE a2.borrowernumber = a.borrowernumber)  > '0.00'     AND a.borrowernumber = b.borrowernumber GROUP BY      a.borrowernumber ORDER BY b.surname, b.firstname, Outstanding ASC

 

thank you sir

Hello Sir,

Which SQL Command will be used for Daily Fine Report in KOHA 

SELECT
b.surname, b.cardnumber,b.categorycode,b.Sort1, bib.title, i.barcode,
a.amountoutstanding, ni.issuedate, ni.date_due,
IF ( ni.returndate IS NULL , " ", ni.returndate ) AS returndate
FROM accountlines a
LEFT JOIN borrowers b ON ( b.borrowernumber = a.borrowernumber )
LEFT JOIN items i ON ( a.itemnumber = i.itemnumber )
LEFT JOIN biblio bib ON ( i.biblionumber = bib.biblionumber )
LEFT JOIN ( SELECT * FROM issues UNION SELECT * FROM old_issues ) ni ON ( ni.itemnumber = i.itemnumber AND ni.borrowernumber = a.borrowernumber )
WHERE
a.amountoutstanding > 0
GROUP BY a.description
ORDER BY b.surname, b.firstname, ni.timestamp DESC

RSS

© 2025   Created by Dr. Badan Barman.   Powered by

Badges  |  Report an Issue  |  Terms of Service

Koha Workshop