LIS Links

First and Largest Academic Social Network of LIS Professionals in India

Latest Activity

Archanagita Saikia updated their profile
yesterday
RP Raaj shared a profile on Facebook
Friday
prema updated their profile
Friday
Vikram Jain replied to Vikram Jain's discussion Call for Chapter Contribution in Editorial Book "Artificial Intelligence Connect: Empowering Education & Enabling Libraries"
Thursday
Abdullah al-Modabber updated their profile
Wednesday
Fazal posted a status
"🎓 Decode DDC with AI: Smart Classification 🗓️ Date: 31st August 2025 ⏰ Time: 06:30 – 08:PM Register: https://forms.gle/uuNBECwesduV2fjd6"
Wednesday
YOGESHKUMAR HARILAL LAD is attending komal patel's event
Thumbnail

National Conference on Re-Imagining Libraries of Viksit Bharat 29-30 AUGUST 2025 at Bhopal

August 29, 2025 at 10am to August 30, 2025 at 5pm
Wednesday
LAITHANGBAM NEPOLEAN SINGH shared Ravithimmegowda's discussion on Facebook
Jul 20
LAITHANGBAM NEPOLEAN SINGH updated their profile
Jul 20
Dr. O Seshaiaih and Sumit Sundar Ray are now friends
Jul 20
Sumit Sundar Ray updated their profile
Jul 20
Bristy Handique updated their profile
Jul 19
meghabat singh updated their profile
Jul 18
Elukoti Bhosle updated their profile
Jul 18
DEVI SHANKAR DINGARA updated their profile
Jul 17
ASHUTOSH KAG updated their profile
Jul 17
Dr. U. PRAMANATHAN posted discussions
Jul 16
Dr. U. PRAMANATHAN posted blog posts
Jul 16
Dr. U. PRAMANATHAN is now friends with Ramesh Kumar and Suraj Morya
Jul 16
Archanagita Saikia posted a discussion
Jul 16

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: 1712

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