[Koha] Report Checked out and Checked in report with school class and section

[Ashok Francis]

Thank you so much MAMSET LIBRARY. It works well. Great work.



On Fri, Feb 8, 2019 at 9:14 AM MAMCET Library <mamcet.library10 at gmail.com>
wrote:

>  Report form Checked out
>  Report SQL:
>
> SELECT DATE_FORMAT(c.issuedate, "%d %b %Y %h:%i %p") AS Issue_Date,
> DATE_FORMAT(c.date_due, "%d %b %Y") AS Due_Date,
> p.cardnumber AS Card_No,
> p.firstname AS First_Name,
> p.surname AS  Last_Name,
> p.borrowernotes AS  Class_section  ,
> p.Categorycode AS Category,
> i.barcode AS Barcode,
> b.title AS Title,
> b.author AS Author,
> p.branchcode AS Library
>
> FROM issues c
> LEFT JOIN items i ON (c.itemnumber=i.itemnumber)
> LEFT JOIN borrowers p ON (c.borrowernumber=p.borrowernumber)
> LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber)
> WHERE c.issuedate
> BETWEEN <<Between Date (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>>
> ORDER BY c.issuedate DESC
>
> On Fri, Feb 8, 2019 at 9:02 AM MAMCET Library <mamcet.library10 at gmail.com>
> wrote:
>
>> Report Checked in report
>>
>> SELECT old_issues.Returndate,
>> borrowers.Cardnumber AS Card_No,
>> borrowers.Surname AS Name,
>> borrowers.borrowernotes AS  Class,
>> borrowers.Categorycode AS Category,
>> items.Barcode AS Barcode,
>> biblio.Title AS Title,
>> biblio.Author AS Author
>>
>> FROM old_issues  LEFT JOIN borrowers ON
>> borrowers.borrowernumber=old_issues.borrowernumber
>> LEFT JOIN items ON old_issues.itemnumber=items.itemnumber LEFT JOIN
>> biblio ON items.biblionumber=biblio.biblionumber WHERE
>> old_issues.returndate
>> BETWEEN <<Between Date (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>>
>> ORDER BY old_issues.returndate DESC
>>
>> On Thu, Feb 7, 2019 at 1:12 PM Ashok Francis <ashokfrancis.tgs at gmail.com>
>> wrote:
>>
>>> Dear All,
>>>
>>> I am running Koha 17.11.04.000 in Ubuntu at CBSE school. I have created
>>> new
>>> field Student class and section in Additional attributes and identifiers.
>>> Every day we are taking circulation report "Date wise list of Checked out
>>> Books" and also Checked in books.  Is it possible to include student
>>> class
>>> and section in this report. It will be very useful for us. If it is
>>> possible, can you please guide me? I will be thankful to you.
>>>
>>> Report SQL:
>>>
>>> SELECT DATE_FORMAT(c.issuedate, "%d %b %Y %h:%i %p") AS Issue_Date,
>>> DATE_FORMAT(c.date_due, "%d %b %Y") AS Due_Date,
>>> i.barcode AS Barcode,
>>> b.title AS Title,
>>> b.author AS Author,
>>> p.cardnumber AS Card_No,
>>> p.firstname AS First_Name,
>>> p.surname AS Last_Name
>>> FROM issues c
>>> LEFT JOIN items i ON (c.itemnumber=i.itemnumber)
>>> LEFT JOIN borrowers p ON (c.borrowernumber=p.borrowernumber)
>>> LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber)
>>> WHERE c.issuedate
>>> BETWEEN '2019-02-07' AND '2019-02-08'  ORDER BY c.issuedate DESC
>>>
>>>
>>> Thank you,
>>>
>>> Ashok Francis
>>>
>>> New Delhi
>>> _______________________________________________
>>> Koha mailing list  http://koha-community.org
>>> Koha at lists.katipo.co.nz
>>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>>
>>
>>
>> --
>>  Thanking you..
>>
>> Librarian,
>> MAMCET <http://mamcet.com/>
>> Trichy-Chennai Trunk Road,
>> Siruganur, Tiruchirappalli-621 105.
>>
>>
>
> --
>  Thanking you..
>
> Librarian,
> MAMCET <http://mamcet.com/>
> Trichy-Chennai Trunk Road,
> Siruganur, Tiruchirappalli-621 105.
>
>