[Koha-bugs] [Bug 7638] New: one page notice for printing per student?

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7638

             Bug #: 7638
           Summary: one page notice for printing per student?
    Classification: Unclassified
 Change sponsored?: ---
           Product: Koha
           Version: master
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Notices
        AssignedTo: henridamien at koha-fr.org
        ReportedBy: melia at bywatersolutions.com
         QAContact: koha.sekjal at gmail.com


Our schools want a paper notice to send to students.  They want it to print one
8 1/2 x 11 page per student.  They want all fines, fees, and lost to be on one
report.  I did create a SQL report that is working, but the schools want to be
able to print this out on one piece of paper per student.  Below is the SQL
statement I made:

SELECT b.cardnumber, b.surname, b.firstname, g.attribute AS 'Grade',
h.attribute AS 'Homeroom', a.date, a.description, a.accounttype, a.amount,
a.amountoutstanding
FROM borrowers b JOIN borrower_attributes g on
(b.borrowernumber=g.borrowernumber)
JOIN borrower_attributes as h ON (h.borrowernumber=b.borrowernumber)
JOIN accountlines a ON (b.borrowernumber=a.borrowernumber)
WHERE b.branchcode =<<Pick your library|branches>>
AND a.date between <<Date Between (yyyy-mm-dd)>> and <<and (yyyy-mm-dd)>>
AND g.code='GRADE'
AND h.code='Homeroom'
ORDER BY a.accounttype ASC
Name (Last, First) or in 2 separate fields
Student ID number
Grade
Homeroom (even if the homeroom field is blank)
Item Title
Date Checked Out
Due Date
Item Status
Amount Due

-- 
Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are watching all bug changes.