|
Lines 1-2
Link Here
|
| 1 |
INSERT IGNORE INTO export_format( profile, description, content, csv_separator, type, used_for ) |
1 |
INSERT IGNORE INTO export_format( profile, description, content, csv_separator, type, used_for ) VALUES |
| 2 |
VALUES ( "issues to claim", "default CSV export for serial issue claims", "SUPPLIER=aqbooksellers.name|TITLE=subscription.title|ISSUE NUMBER=serial.serialseq|LATE SINCE=serial.planneddate", ",", "sql", "late_issues" ); |
2 |
( "issues to claim", "default CSV export for serial issue claims", "SUPPLIER=aqbooksellers.name|TITLE=subscription.title|ISSUE NUMBER=serial.serialseq|LATE SINCE=serial.planneddate", ",", "sql", "late_issues" ), |
|
|
3 |
("Late orders (csv profile)", "default CSV export for late orders", 'Title[% separator %]Author[% separator %]Publication year[% separator %]ISBN[% separator %]Quantity[% separator %]Number of claims |
| 4 |
[% FOR order IN orders ~%] |
| 5 |
[%~ SET biblio = order.biblio ~%] |
| 6 |
"[% biblio.title %]"[% separator ~%] |
| 7 |
"[% biblio.author %]"[% separator ~%] |
| 8 |
"[% bibio.biblioitem.publicationyear %]"[% separator ~%] |
| 9 |
"[% biblio.biblioitem.isbn %]"[% separator ~%] |
| 10 |
"[% order.quantity%]"[% separator ~%] |
| 11 |
"[% order.claims.count%][% IF order.claims.count %]([% FOR c IN order.claims %][% c.claimed_on | $KohaDates %][% UNLESS loop.last %], [% END %][% END %])[% END %]" |
| 12 |
[% END %]', ",", "sql", "late_orders"); |
| 3 |
- |
|
|