Latest Activity

Karandeep Singh and Gurpreet Kaur are now friends
1 hour ago
Karandeep Singh replied to Karandeep Singh's discussion Web OPAC in E-granthalaya 3.0 Software
4 hours ago
Dr.Stephen.G posted blog posts
14 hours ago
Dr.Stephen.G and Madhavan Kolayamparampath are now friends
14 hours ago
Dr. Ujjal Marjit posted a status
"7 Useful Researcher Profiles Every Researcher Must Know https://bit.ly/2VuSVOA"
15 hours ago
Profile IconAshish Kumar Shukla, Chencheti Balu, Arpita Mehta and 9 more joined LIS Links
15 hours ago
Dr. Subhash Chandra posted a blog post
15 hours ago
Dr.P.MUTHU MARI posted a discussion
15 hours ago
Nitish Kumar posted a discussion
15 hours ago
SHRIKANT KUMAR replied to Karandeep Singh's discussion Web OPAC in E-granthalaya 3.0 Software
16 hours ago
Ashoka R updated their profile
20 hours ago
Dr.Ghule Pravin Keruji updated their profile
23 hours ago
Dr.Ghule Pravin Keruji and Sameer More are now friends
23 hours ago
Anuj Jindal replied to MRS.PRITEE CHAK's discussion UGC NET study material
yesterday
shilpa deshpande replied to Badan Barman's discussion PIL on Neglect of Library and Appointment of Library Staff all over India
yesterday
SANTOSH KUMAR updated their profile
yesterday
Badan Barman and Rahul Anand are now friends
yesterday
Karandeep Singh posted a discussion
yesterday
prabhu.c posted a discussion
yesterday
Madhavan Kolayamparampath posted an event

Challenges of Academic Librarians in the Digital Landscape at Zoom/ YouTube

August 12, 2021 from 3:30pm to 7pm
yesterday

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

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

© 2021   Created by Badan Barman.   Powered by

Badges  |  Report an Issue  |  Terms of Service

Koha Workshop