LIS Links

First and Largest Academic Social Network of LIS Professionals in India

Latest Activity

Abdullah al-Modabber updated their profile
yesterday
Fazal posted a status
"🎓 Decode DDC with AI: Smart Classification 🗓️ Date: 31st August 2025 ⏰ Time: 06:30 – 08:PM Register: https://forms.gle/uuNBECwesduV2fjd6"
yesterday
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
yesterday
LAITHANGBAM NEPOLEAN SINGH shared Ravithimmegowda's discussion on Facebook
Monday
LAITHANGBAM NEPOLEAN SINGH updated their profile
Monday
Dr. O Seshaiaih and Sumit Sundar Ray are now friends
Monday
Sumit Sundar Ray updated their profile
Sunday
Bristy Handique updated their profile
Saturday
meghabat singh updated their profile
Saturday
Elukoti Bhosle updated their profile
Saturday
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
Manju Meerwal joined Dr. Badan Barman's group
Jul 16
Dr. O Seshaiaih posted a discussion
Jul 16
Dr. A. Madhava Rao posted an event

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

August 4, 2025 from 2pm to 4pm
Jul 16
Dr. Badan Barman posted a blog post
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????

Facebook

Views: 1710

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