On Fri, Aug 29, 2008 at 3:18 PM, Rick Welykochy <[EMAIL PROTECTED]> wrote:
> Henri-Damien LAURENT wrote:
>
> >> <guided_report kohaversion="3.00.107">
> >> <title>Patrons nearing expiry</title>
> >> <module>Members</module>
> >> <description>Patrons with expiry dates in the next n
> days</description>
> >> <sql>SELECT cardnumber, surname, firstname, branchcode,
> >> categories.description, dateexpiry from borrowers
> >> LEFT JOIN categories on
> >> borrowers.categorycode=categories.categorycode
> >> WHERE DATEDIFF( dateexpiry, CURDATE() ) < ???Number of Days???
>
> The above is invalid XML. If a librarian / non-programmer is exposed
> to this stuff, chaos will quickly ensue.
>
> Writing a correct XML application is not for kids.
>
>
> cheers
> rickw
>
OK then. How about YAML?
required_version: 3.00.00.107
title: Patrons nearing expiry
module: Members
description: Patrons with expiry dates in the next n days
sql: SELECT cardnumber, surname, firstname, branchcode,
categories.description, dateexpiry from borrowers
LEFT JOIN categories on borrowers.categorycode=categories.categorycode
WHERE DATEDIFF( dateexpiry, CURDATE() ) < ???Number of Days???
AND branchcode = ???LIST:branchcode???
ORDER BY categories.description, dateexpiry
(NOTE: the indents on the last lines of the SQL statement are kept together
because they are indented)
This has the advantage of being easy to understand and write, and YAML is
fairly standard (CPAN uses it, among others).
---
Jesse Weaver
Software Developer, LibLime
_______________________________________________
Koha-devel mailing list
Koha-devel@lists.koha.org
http://lists.koha.org/mailman/listinfo/koha-devel
