LIS Links

First and Largest Academic Social Network of LIS Professionals in India

Latest Activity

Bilal Rabbani is now friends with Millan Krushna Dutta and Mhuammad Rafiq Akhtar
32 minutes ago
Vinod Kumar Jain posted a blog post
8 hours ago
neema shukla posted an 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
8 hours ago
Rohidas Rathod posted an event
8 hours ago
Hemanta Kumar Biswal posted an event
Thumbnail

4th International Symposium on Knowledge Engineering for Digital Library Design (KEDLD-2025) at Indian Institute of Technology, Kharagpur

November 3, 2025 to November 5, 2025
8 hours ago
SHIVAKUMARA BC posted a discussion
8 hours ago
Swati replied to Jayant Deshpande's discussion Librarian are forced to teach a subject
yesterday
OKE CHANDAN updated their profile
yesterday
jai prakash kumar updated their profile
Tuesday
Rohidas Rathod updated their profile
Tuesday
Rohidas Bhimrao Rathod updated their profile
Tuesday
Rohidas Bhimrao Rathod updated their profile
Tuesday
Vinod Kumar Jain posted a status
"Required Library paid Intern @ 8000 PM for 6 Months for “Indexing Database”- in Delhi, 9818180051"
Monday
Vinod Kumar Jain posted a status
"Required Library Intern for “Indexing Database”- in Delhi"
Monday
Dr.Stephen.G commented on Dr.Stephen.G's event 'International Conference on Digital and Innovative Advancements for Sustainable Library Services'
Sunday
Dr.Stephen.G posted an event

International Conference on Digital and Innovative Advancements for Sustainable Library Services at Bharati Vidyapeeth’s Institute of Computer Applications & Management (BVICAM), New Delhi

August 29, 2025 at 10am to August 31, 2025 at 5pm
Sunday
Dr.Stephen.G posted a discussion
Sunday
Yogesh Kawale updated their profile
Jul 2
Peeyush Dwivedi posted a blog post
Jul 2
Ravithimmegowda posted a discussion
Jul 2

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

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