[Bug 7638] New: one page notice for printing per student?
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@koha-fr.org ReportedBy: melia@bywatersolutions.com QAContact: koha.sekjal@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.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7638 Savitra Sirohi <savitra.sirohi@osslabs.biz> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |ASSIGNED CC| |savitra.sirohi@osslabs.biz Assignee|henridamien@koha-fr.org |savitra.sirohi@osslabs.biz -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7638 --- Comment #1 from Savitra Sirohi <savitra.sirohi@osslabs.biz> --- Draft Design: A new tool called "Print Patron notices", that can perhaps be extended later to print other kinds of notices. A default template (ACCTLINES_PRINT) will be created as part of this patch. The template will contain a header with borrower and borrower attributes fields and a body containing accountlines fields such as accounttype, amount, date. A mechanism to specify which borrower attribute(s) are to included in the notice will be provided. E.g. <<borrower_attributes.attribute|GRADE>> will allow the attribute for code "GRADE" to be included. Only those acccountlines records that have outstanding amounts > 0 will be displayed in the report. The tool will generate a PDF file containing a report per patron, each report will contain text per the notice template. Following filters will be made available during report generation: Branch Patron category Transaction date range The pages in the PDF fike will be of size Letter (8.5*11) by default. This can be extended later to include other paper sizes. -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7638 Nicole C. Engard <nengard@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |nengard@gmail.com --- Comment #2 from Nicole C. Engard <nengard@gmail.com> --- For this section: Following filters will be made available during report generation: Branch Patron category Transaction date range I would note with branch we're talking about - the patron's branch? Also, will the notice allow for customization of what fields show from the accountlines table? You mention the defaults that will be in the template, but I just want to be clear. Thanks a ton! Nicole -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7638 Kyle M Hall <kyle.m.hall@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |kyle.m.hall@gmail.com --- Comment #3 from Kyle M Hall <kyle.m.hall@gmail.com> --- As an alternative to PDF, it may be better to use html and css. I've done this before, it's possible to create page breaks using css, and it is much easier to work with HTML than it is to create PDF files. I know this from personal experience. This also means we could use the notices system to make this template-able. Customizing a PDF would be far more difficult. http://davidwalsh.name/css-page-breaks -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7638 --- Comment #4 from Ian Walls <koha.sekjal@gmail.com> --- I highly recommend avoiding direct PDF generation; better to use HTML and CSS, then let the browser print to PDF. Lots of the open source PDF tools are... limited... as we've seen with the Labels tool bug 2246. -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org