View | Details | Raw Unified | Return to bug 24163
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_24163.perl (+18 lines)
Line 0 Link Here
1 
$DBversion = 'XXX'; # will be replaced by the RM
2 
if( CheckVersion( $DBversion ) ) {
3 
    $dbh->do(q{
4 
        INSERT IGNORE INTO export_format( profile, description, content, csv_separator, type, used_for ) VALUES
5 
        ("Late orders (csv profile)", "default CSV export for late orders", 'Title[% separator %]Author[% separator %]Publication year[% separator %]ISBN[% separator %]Quantity[% separator %]Number of claims
6 
        [% FOR order IN orders ~%]
7 
        [%~ SET biblio = order.biblio ~%]
8 
        "[% biblio.title %]"[% separator ~%]
9 
        "[% biblio.author %]"[% separator ~%]
10 
        "[% bibio.biblioitem.publicationyear %]"[% separator ~%]
11 
        "[% biblio.biblioitem.isbn %]"[% separator ~%]
12 
        "[% order.quantity%]"[% separator ~%]
13 
        "[% order.claims.count%][% IF order.claims.count %]([% FOR c IN order.claims %][% c.claimed_on | $KohaDates %][% UNLESS loop.last %], [% END %][% END %])[% END %]"
14 
        [% END %]', ",", "sql", "late_orders")
15 
    });
16 
    SetVersion( $DBversion );
17 
    print "Upgrade to $DBversion done (Bug 24163 - Define a default CSV profile for late orders)\n";
18 
}
(-)a/installer/data/mysql/en/optional/csv_profiles.yml (-3 / +19 lines)
Lines 25-35 description: Link Here
25 
tables:
 25 
tables:
26 
  - export_format:
 26 
  - export_format:
27 
      translatable: [ profile, description ]
 27 
      translatable: [ profile, description ]
28 
      multiline: []
 28 
      multiline: [ content ]
29 
      rows:
 29 
      rows:
30 
        - profile: "issues to claim"
 30 
        - profile: "issues to claim"
31 
          description: "default CSV export for serial issue claims"
 31 
          description: "default CSV export for serial issue claims"
32 
          content: "SUPPLIER=aqbooksellers.name|TITLE=subscription.title|ISSUE NUMBER=serial.serialseq|LATE SINCE=serial.planneddate"
 32 
          content:
33 
            - "SUPPLIER=aqbooksellers.name|TITLE=subscription.title|ISSUE NUMBER=serial.serialseq|LATE SINCE=serial.planneddate"
33 
          csv_separator: ","
 34 
          csv_separator: ","
34 
          type: sql
 35 
          type: sql
35 
          used_for: late_issues
 36 
          used_for: late_issues
36 
-
37 
        - profile: "Late orders (csv profile)"
38 
          description: "default CSV export for late orders"
39 
          content:
40 
            - 'Title[% separator %]Author[% separator %]Publication year[% separator %]ISBN[% separator %]Quantity[% separator %]Number of claims'
41 
            - '[% FOR order IN orders ~%]'
42 
            - '[%~ SET biblio = order.biblio ~%]'
43 
            - '"[% biblio.title %]"[% separator ~%]'
44 
            - '"[% biblio.author %]"[% separator ~%]'
45 
            - '"[% bibio.biblioitem.publicationyear %]"[% separator ~%]'
46 
            - '"[% biblio.biblioitem.isbn %]"[% separator ~%]'
47 
            - '"[% order.quantity%]"[% separator ~%]'
48 
            - '"[% order.claims.count%][% IF order.claims.count %]([% FOR c IN order.claims %][% c.claimed_on | $KohaDates %][% UNLESS loop.last %], [% END %][% END %])[% END %]"'
49 
            - '[% END %]'
50 
          csv_separator: ","
51 
          type: sql
52 
          used_for: late_orders

Return to bug 24163