LIS Links

First and Largest Academic Social Network of LIS Professionals in India

Latest Activity

LAITHANGBAM NEPOLEAN SINGH is attending Dr. U. PRAMANATHAN's event
13 hours ago
SHWETHA KV updated their profile
22 hours ago
Dr. Tarvinder Singh Handa updated their profile
23 hours ago
RP Raaj updated their profile
yesterday
LAITHANGBAM NEPOLEAN SINGH is attending Dr. A. Madhava Rao's event

Online-Lecture on "AI Tools for Academic Research Writing and Publishing" at Microsoft Teams (Online)

August 4, 2025 from 2pm to 4pm
yesterday
Misbah Ul Huda is attending Dr. A. Madhava Rao's event

Online-Lecture on "AI Tools for Academic Research Writing and Publishing" at Microsoft Teams (Online)

August 4, 2025 from 2pm to 4pm
Monday
Dr. N. Kadiresan updated their profile
Monday
Mukesh Baboo updated their profile
Monday
Abdur Rouf B updated their profile
Monday
Archanagita Saikia updated their profile
Saturday
RP Raaj shared a profile on Facebook
Jul 24
prema updated their profile
Jul 24
Vikram Jain replied to Vikram Jain's discussion Call for Chapter Contribution in Editorial Book "Artificial Intelligence Connect: Empowering Education & Enabling Libraries"
Jul 24
Abdullah al-Modabber updated their profile
Jul 23
Fazal posted a status
"🎓 Decode DDC with AI: Smart Classification 🗓️ Date: 31st August 2025 ⏰ Time: 06:30 – 08:PM Register: https://forms.gle/uuNBECwesduV2fjd6"
Jul 22
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
Jul 22
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

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

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