From 61a26cb50acf368e76dfb74046e9186dd362c950 Mon Sep 17 00:00:00 2001 From: Julian Maurice Date: Mon, 25 Jun 2018 08:50:05 +0200 Subject: [PATCH] Bug 20988: koha-tmpl/intranet-tmpl/prog/en/modules/reports --- .../en/modules/reports/acquisitions_stats.tt | 145 +++--- .../prog/en/modules/reports/bor_issues_top.tt | 101 ++-- .../prog/en/modules/reports/borrowers_out.tt | 59 +-- .../en/modules/reports/borrowers_stats.tt | 124 +++-- .../en/modules/reports/cash_register_stats.tt | 129 ++--- .../prog/en/modules/reports/cat_issues_top.tt | 105 ++-- .../prog/en/modules/reports/catalogue_out.tt | 75 +-- .../en/modules/reports/catalogue_stats.tt | 109 ++-- .../prog/en/modules/reports/convert_report.tt | 11 +- .../reports/csv/cash_register_stats.tt | 3 +- .../modules/reports/csv/orders_by_budget.tt | 3 +- .../prog/en/modules/reports/dictionary.tt | 105 ++-- .../modules/reports/guided_reports_start.tt | 486 +++++++++--------- .../en/modules/reports/issues_avg_stats.tt | 79 +-- .../prog/en/modules/reports/issues_stats.tt | 183 +++---- .../prog/en/modules/reports/itemslost.tt | 75 +-- .../prog/en/modules/reports/itemtypes.tt | 19 +- .../en/modules/reports/orders_by_budget.tt | 73 +-- .../prog/en/modules/reports/reports-home.tt | 65 +-- .../prog/en/modules/reports/reserves_stats.tt | 113 ++-- .../prog/en/modules/reports/serials_stats.tt | 49 +- 21 files changed, 1061 insertions(+), 1050 deletions(-) diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/acquisitions_stats.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/reports/acquisitions_stats.tt index 4e5c9161cf..12e1d12222 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/acquisitions_stats.tt +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/reports/acquisitions_stats.tt @@ -1,6 +1,7 @@ +[% PROCESS 'i18n.inc' %] [% SET footerjs = 1 %] [% INCLUDE 'doc-head-open.inc' %] -Koha › Reports [% IF ( do_it ) %]› Acquisitions statistics › Results[% ELSE %]› Acquisitions statistics[% END %] +[% t('Koha › Reports') %] [% IF ( do_it ) %][% t('› Acquisitions statistics › Results') %][% ELSE %][% t('› Acquisitions statistics') %][% END %] [% INCLUDE 'doc-head-close.inc' %] @@ -8,7 +9,7 @@ [% INCLUDE 'header.inc' %] [% INCLUDE 'cat-search.inc' %] - +
@@ -18,24 +19,24 @@ [% IF ( do_it ) %] [% FOREACH mainloo IN mainloop %] -

Acquisitions statistics

+

[% t('Acquisitions statistics') %]

[% IF ( mainloo.loopfilter.size ) %] -

Filtered on:

+

[% t('Filtered on:') %]

[% FOREACH loopfilte IN mainloo.loopfilter %]

[% SWITCH loopfilte.crit %] - [% CASE '0' %] Placed on (from) - [% CASE '1' %] Placed on (to) - [% CASE '2' %] Received on (from) - [% CASE '3' %] Received on (to) - [% CASE '4' %] Vendor - [% CASE '5' %] Home library - [% CASE '6' %] Collection - [% CASE '7' %] Item type - [% CASE '8' %] Fund - [% CASE '9' %] Sort1 - [% CASE '10' %] Sort2 - [% CASE %] Unknown filter + [% CASE '0' %] [% t('Placed on (from)') %] + [% CASE '1' %] [% t('Placed on (to)') %] + [% CASE '2' %] [% t('Received on (from)') %] + [% CASE '3' %] [% t('Received on (to)') %] + [% CASE '4' %] [% t('Vendor') %] + [% CASE '5' %] [% t('Home library') %] + [% CASE '6' %] [% t('Collection') %] + [% CASE '7' %] [% t('Item type') %] + [% CASE '8' %] [% t('Fund') %] + [% CASE '9' %] [% t('Sort1') %] + [% CASE '10' %] [% t('Sort2') %] + [% CASE %] [% t('Unknown filter') %] [% END %] : [% loopfilte.filter %]

@@ -43,12 +44,12 @@ [% END %] - + [% FOREACH loopco IN mainloo.loopcol %] [% END %] - + [% FOREACH loopro IN mainloo.looprow %] @@ -57,7 +58,7 @@ [% FOREACH loopcel IN loopro.loopcell %] [% IF ( loopcel.hilighted ) %] [% END %] @@ -66,8 +67,8 @@ [% END %] - - + + [% FOREACH loopfoote IN mainloo.loopfooter %] [% END %] - + [% FOREACH loopro IN mainloo.looprow %] @@ -42,7 +43,7 @@ [% FOREACH loopcel IN loopro.loopcell %] [% IF ( loopcel.hilighted ) %] [% END %] @@ -52,7 +53,7 @@ [% END %] - + [% FOREACH loopfoote IN mainloo.loopfooter %] [% ELSE %] @@ -756,46 +753,46 @@ $(document).ready(function() {
-Create report from SQL +[% t('Create report from SQL') %]
    -
  1. - [% IF ( reportname ) %] - [% ELSE %][% END %] Required +
  2. + [% IF ( reportname ) %] + [% ELSE %][% END %] [% t('Required') %]
  3. [% PROCESS group_and_subgroup_selection %] [% IF (public) %] -
  4. +
  5. [% ELSE %] -
  6. +
  7. [% END %] [% IF (usecache) %]
  8. - +
  9. [% END %] -
  10. +
-SQL: +[% t('SQL:') %]
- Required + [% t('Required') %]
- Cancel + [% t('Cancel') %]
[% END %] [% IF saved_results %] -

Saved report results

+

[% t('Saved report results') %]

[% name %]

[% notes %]

[% mainloo.line %] / [% mainloo.column %][% loopco.coltitle %]TOTAL[% t('TOTAL') %]
[% ELSE %][% END %] [% IF ( loopcel.value ) %][% loopcel.value %] - [% ELSE %]   + [% ELSE %]   [% END %]
TOTAL
[% t('TOTAL') %] [% loopfoote.totalcol %] @@ -80,68 +81,68 @@ [% ELSE %]
- Acquisitions statistics + [% t('Acquisitions statistics') %] - - - - + + + + - + - - - + - + - + - - - + - + - + - + @@ -174,7 +175,7 @@ - + - + - + [% ELSE %][% END %] - + [% END %] - + [% FOREACH loopro IN mainloo.looprow %] [% FOREACH loopcel IN loopro.loopcell %] - [% END %] [% END %] - + [% FOREACH loopfoote IN mainloo.loopfooter %] [% END %] @@ -64,23 +65,23 @@ [% ELSE %] -
Patrons statistics +
[% t('Patrons statistics') %]
TitleRowColumnFilter[% t('Title') %][% t('Row') %][% t('Column') %][% t('Filter') %]
Placed on[% t('Placed on') %] From + [% t('From') %] [% INCLUDE 'date-format.inc' %] - To + [% t('To') %] [% INCLUDE 'date-format.inc' %]
 group by  [% t('group by') %]   
Received on[% t('Received on') %] From + [% t('From') %] [% INCLUDE 'date-format.inc' %] - To + [% t('To') %] [% INCLUDE 'date-format.inc' %]
 group by  [% t('group by') %]   
Vendor[% t('Vendor') %]
Home library[% t('Home library') %] [% IF ccode_avlist.size %]
Item type[% t('Item type') %]
Fund[% t('Fund') %]
Sort1[% t('Sort1') %]
Sort2[% t('Sort2') %] +
  • - +
  • - +
  • - +
  • - +
  • - Output + [% t('Output') %]
    1. - +
    2. - - - + + + - + [% FOREACH loopco IN mainloo.loopcol %] [% END %] [% FOREACH loopco IN mainloo.loopcol %] - - + + [% END %] [% FOREACH loopro IN mainloo.looprow %] @@ -90,33 +91,33 @@
      Rank[% t('Rank') %][% loopco.coltitle %]
      PatronCheckout count[% t('Patron') %][% t('Checkout count') %]
      [% END %] [% ELSE %] -

      Patrons with the most checkouts

      +

      [% t('Patrons with the most checkouts') %]

      -
      1. - +
        1. + [% INCLUDE 'date-format.inc' %]
        2. -
        3. - +
        4. + [% INCLUDE 'date-format.inc' %]
        5. - - [% FOREACH l IN Branches.all( unfiltered => 1 ) %] - + [% END %]
        6. - [% FOREACH itemtype IN itemtypes %] - + [% END %]
        7. - [% FOREACH patron_category IN patron_categories%] - + [% END %]
        8. @@ -125,42 +126,42 @@
            -
          1. + + + + +
          2. -
          3. + + + + + + + +
          - Output -
          1. -
          2. - - + [% t('Output') %] +
            1. +
            2. + + - + - + [% FOREACH loopco IN mainloo.loopcol %] [% END %] @@ -45,53 +46,53 @@
              Num/Patrons[% t('Num/Patrons') %][% loopco.coltitle %]
              [% END %] [% ELSE %] -

              Patrons with no checkouts

              +

              [% t('Patrons with no checkouts') %]

                -
              1. [% FOREACH patron_category IN patron_categories %] - + [% END %]
              2. -
              3. +
              - Limits + [% t('Limits') %]
                -
              1. + + + + + + + + +
              2. -
              3. + + +
              - Output + [% t('Output') %]
              1. - +
              2. - - - + + +
    [% IF ( loopco.coltitle_display ) %][% loopco.coltitle_display %][% ELSE %][% loopco.coltitle %][% END %] TOTAL[% t('TOTAL') %]
    [% IF ( loopro.rowtitle_display ) %][% loopro.rowtitle_display %][% ELSE %][% loopro.rowtitle %][% END %] [% IF ( loopcel.value ) %][% loopcel.value %][% ELSE %] [% END %] + [% IF ( loopcel.value ) %][% loopcel.value %][% ELSE %] [% END %] [% loopro.totalrow %]
    TOTAL[% t('TOTAL') %][% loopfoote.totalcol %]
    - - - - + + + + - + - + - + - + - + - + - - + - - + + - + - - + [% IF ( SORT1_LOOP ) %] - + - + - + [% FOREACH pa_loo IN patron_attributes %] [% IF (pa_loo.class) %] @@ -221,26 +222,23 @@ ([% patron_attribute.description %]) @@ -253,15 +251,15 @@
    - Output + [% t('Output') %]
    1. - +
    2. - - - + + +
      [% INCLUDE 'date-format.inc' %]
    3. - +
      [% INCLUDE 'date-format.inc' %]
    4. - +
    5. - +
    6. - + - +
    @@ -171,21 +172,21 @@ [% IF ( do_it ) %] -
     
    +
     
    TitleRowColumnFilter[% t('Title') %][% t('Row') %][% t('Column') %][% t('Filter') %]
    Patron category[% t('Patron category') %] - [% FOREACH patron_category IN patron_categories %] @@ -89,27 +90,27 @@
    Patron status[% t('Patron status') %]
    Patron activity[% t('Patron activity') %] - +
    ZIP/Postal code[% t('ZIP/Postal code') %]
    - +   
    Library[% t('Library') %] - [% FOREACH l IN Branches.all( unfiltered => 1 ) %] @@ -150,33 +151,33 @@
    Date of birth[% t('Date of birth') %] - + + [% INCLUDE 'date-format.inc' %]
    Gender[% t('Gender') %]
    Sort1[% t('Sort1') %]
    Sort2[% t('Sort2') %]
    Patron attributes[% t('Patron attributes') %]
    - + - + [% IF ( patron_attribute.use_dropdown ) %] - [% END %] [% ELSE %] - + [% END %]
    - - - - - - - - - - - + + + + + + + + + + + [% FOREACH loopresul IN loopresult %] @@ -197,25 +198,25 @@ [% IF transaction_type == "ACT" %] - + - + [% END %] diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/cat_issues_top.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/reports/cat_issues_top.tt index 756d6e0db8..8f8987c00a 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/cat_issues_top.tt +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/reports/cat_issues_top.tt @@ -1,7 +1,8 @@ +[% PROCESS 'i18n.inc' %] [% USE Branches %] [% SET footerjs = 1 %] [% INCLUDE 'doc-head-open.inc' %] -Koha › Reports › Most-circulated items[% IF ( do_it ) %] › Results[% END %] +[% t('Koha › Reports › Most-circulated items') %][% IF ( do_it ) %] [% t('› Results') %][% END %] [% INCLUDE 'doc-head-close.inc' %] @@ -9,7 +10,7 @@ [% INCLUDE 'header.inc' %] [% INCLUDE 'cat-search.inc' %] - +
    @@ -20,24 +21,24 @@ [% IF ( do_it ) %] [% FOREACH mainloo IN mainloop %] -

    Top [% mainloo.limit %] Most-circulated items

    +

    [% t('Top') %] [% mainloo.limit %] [% t('Most-circulated items') %]

    [% IF ( mainloo.loopfilter ) %] -

    Filtered on:

    +

    [% t('Filtered on:') %]

    [% FOREACH loopfilte IN mainloo.loopfilter %]

    [% IF ( loopfilte.err ) %] [% END %] [% loopfilte.crit %] =[% loopfilte.filter |html %][% IF ( loopfilte.err ) %] [% END %]

    [% END %] [% END %]
    Manager namePatron card numberPatron nameTransaction branchTransaction dateTransaction typeNotesAmountBiblio titleBarcodeItem type[% t('Manager name') %][% t('Patron card number') %][% t('Patron name') %][% t('Transaction branch') %][% t('Transaction date') %][% t('Transaction type') %][% t('Notes') %][% t('Amount') %][% t('Biblio title') %][% t('Barcode') %][% t('Item type') %]
    [% loopresul.date | $KohaDates %] [% IF loopresul.accounttype == "ACT" %] - All payments to the library + [% t('All payments to the library') %] [% ELSIF loopresul.accounttype == "C" || loopresul.accounttype == "CR" %] - Credit + [% t('Credit') %] [% ELSIF loopresul.accounttype == "FORW" || loopresul.accounttype == "W" %] - Write off + [% t('Write off') %] [% ELSIF loopresul.accounttype == "F" %] - Fine + [% t('Fine') %] [% ELSIF loopresul.accounttype == "FU" %] - Accruing fine + [% t('Accruing fine') %] [% ELSIF loopresul.accounttype == "Pay" %] - Payment + [% t('Payment') %] [% ELSIF loopresul.accounttype == "A" %] - Account management fee + [% t('Account management fee') %] [% ELSIF loopresul.accounttype == "M" %] - Sundry + [% t('Sundry') %] [% ELSIF loopresul.accounttype == "L" || loopresul.accounttype == "LR" %] - Lost item + [% t('Lost item') %] [% ELSIF loopresul.accounttype == "N" %] - New card + [% t('New card') %] [% ELSE %] [% FOREACH manualinv IN manualinv_types %] [% value_manualinv = manualinv.authorised_value|truncate(5, '') %] @@ -236,9 +237,9 @@
    TOTAL[% t('TOTAL') %] [% total | $Price %]  
    - + [% FOREACH loopco IN mainloo.loopcol %] [% END %] - + [% FOREACH loopco IN mainloo.loopcol %] - - + + [% END %] [% FOREACH loopro IN mainloo.looprow %] @@ -67,94 +68,94 @@
    Rank/Biblioitemnumbers
    [% t('Rank/Biblioitemnumbers') %][% loopco.coltitle %]
      ItemCount of checkouts[% t('Item') %][% t('Count of checkouts') %]
    [% END %] [% ELSE %] -

    Most-circulated items

    +

    [% t('Most-circulated items') %]

      -
    1. - +
    2. + [% INCLUDE 'date-format.inc' %]
    3. -
    4. - +
    5. + [% INCLUDE 'date-format.inc' %]
    6. - - [% PROCESS options_for_libraries libraries => Branches.all() %]
    7. - [% FOREACH itemtype IN itemtypes %] - + [% END %]
    8. - +
    9. - [% FOREACH ccodeloo IN ccodeloop %] - + [% END %]
    10. - [% FOREACH shelvinglocloo IN shelvinglocloop %] - + [% END %]
    11. - [% FOREACH patron_category IN patron_categories %] - + [% END %]
    12. -
    13. -
    14. -
    15. +
    16. +
    17. +
    - Limits -
    1. + + + + + + + + +
    2. -
    3. + + + + + + + +
    - Output + [% t('Output') %]
    1. - +
    2. - - - + + + - + [% FOREACH looptable IN mainloo.looptables %] [% END %] - +
      GroupCall number rangeNumber of items displayedTotal items in group
      [% t('Group') %][% t('Call number range') %][% t('Number of items displayed') %][% t('Total items in group') %]
      [% looptable.coltitle %] [% IF ( looptable.looptable_count ) %] - [% looptable.looptable_first %] to [% looptable.looptable_last %] + [% looptable.looptable_first %] [% t('to') %] [% looptable.looptable_last %] [% END %] [% looptable.looptable_count %] [% looptable.coltitle_count %]
      TOTAL[% mainloo.total_looptable_count %][% mainloo.total_coltitle_count %]
      [% t('TOTAL') %][% mainloo.total_looptable_count %][% mainloo.total_coltitle_count %]
      @@ -60,43 +61,43 @@ - - - + + + [% IF ( looptable.looprow ) %] [% FOREACH loopro IN looptable.looprow %] - - - + + [% END %] [% ELSE %] - + [% END %]
      #Call numberBarcodeItem details[% t('Call number') %][% t('Barcode') %][% t('Item details') %]
      [% loop.count %][% IF ( loopro.itemcallnumber ) %][% loopro.itemcallnumber %][% ELSE %]No call number[% END %][% IF ( loopro.barcode ) %][% loopro.barcode %][% ELSE %]No barcode[% END %]

      [% IF ( loopro.title ) %][% loopro.title %][% ELSE %]NO TITLE[% END %] [% IF ( loopro.author ) %] by [% loopro.author %][% END %]

      - [% IF ( loopro.branch ) %]at [% Branches.GetName( loopro.branch ) %][% END %] +
      [% IF ( loopro.itemcallnumber ) %][% loopro.itemcallnumber %][% ELSE %][% t('No call number') %][% END %][% IF ( loopro.barcode ) %][% loopro.barcode %][% ELSE %][% t('No barcode') %][% END %]

      [% IF ( loopro.title ) %][% loopro.title %][% ELSE %][% t('NO TITLE') %][% END %] [% IF ( loopro.author ) %] [% t('by') %] [% loopro.author %][% END %]

      + [% IF ( loopro.branch ) %][% t('at') %] [% Branches.GetName( loopro.branch ) %][% END %]
      No items for [% looptable.coltitle %]
      [% t('No items for') %] [% looptable.coltitle %]
      [% END %] [% END %] [% ELSE %] -

      Items with no checkouts

      +

      [% t('Items with no checkouts') %]

        -
      1. +
      2. - + [% FOREACH itemtype IN itemtypes %] [% END %] @@ -106,26 +107,26 @@
      - Limits + [% t('Limits') %]
      1. - +
      2. -
      3. + + +
      diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/catalogue_stats.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/reports/catalogue_stats.tt index f47b00e2c9..30c3566e45 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/catalogue_stats.tt +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/reports/catalogue_stats.tt @@ -1,7 +1,8 @@ +[% PROCESS 'i18n.inc' %] [% USE Branches %] [% SET footerjs = 1 %] [% INCLUDE 'doc-head-open.inc' %] -Koha › Reports [% IF ( do_it ) %]› Catalog statistics › Results[% ELSE %]› Catalog statistics[% END %] +[% t('Koha › Reports') %] [% IF ( do_it ) %][% t('› Catalog statistics › Results') %][% ELSE %][% t('› Catalog statistics') %][% END %] [% INCLUDE 'doc-head-close.inc' %] @@ -9,7 +10,7 @@ [% INCLUDE 'header.inc' %] [% INCLUDE 'cat-search.inc' %] - +
      @@ -19,9 +20,9 @@ [% IF ( do_it ) %] [% FOREACH mainloo IN mainloop %] -

      Catalog statistics

      +

      [% t('Catalog statistics') %]

      [% IF ( mainloo.loopfilter ) %] -

      Filtered on:

      +

      [% t('Filtered on:') %]

      [% FOREACH loopfilte IN mainloo.loopfilter %]

      [% loopfilte.crit %] =[% loopfilte.filter %]

      [% END %] @@ -33,7 +34,7 @@ [% FOREACH loopco IN mainloo.loopcol %]
    [% loopco.coltitle %]TOTAL[% t('TOTAL') %]
    [% ELSE %][% END %] [% IF ( loopcel.value ) %][% loopcel.value %] - [% ELSE %]  + [% ELSE %]  [% END %]
    TOTAL[% t('TOTAL') %] [% loopfoote.totalcol %] @@ -66,39 +67,39 @@
    - Catalog statistics + [% t('Catalog statistics') %] - - - - + + + + - + - + - + - + - + - + - + - + - + - + - - + + - + - + [% END %] - + - + - +
    TitleRowColumnFilter[% t('Title') %][% t('Row') %][% t('Column') %][% t('Filter') %]
    Koha full call number[% t('Koha full call number') %]
       - +   
    Item type[% t('Item type') %]
    Publisher[% t('Publisher') %]
    Publication year[% t('Publication year') %]
    Home library[% t('Home library') %]
    Shelving location[% t('Shelving location') %]
    Collection[% t('Collection') %]
    [% notforloan_label %] [% IF (notforloan_avlist) %]
    [% materials_label %] [% IF (materials_avlist) %]
    Filter barcode[% t('Filter barcode') %] - (use * to do a fuzzy search) + [% t('(use * to do a fuzzy search)') %]
    Date acquired (item)[% t('Date acquired (item)') %] - + - +
    Date deleted (item)[% t('Date deleted (item)') %] - + - - + +

    - Cell value + [% t('Cell value') %]
    1. - +
    2. - +
    3. - +
    - Output -
    1. -
    2. - - + [% t('Output') %] +
      1. +
      2. + + [% IF ( areas ) %] - Filter by area + [% t('Filter by area') %] - - - - - + + + + + [% FOREACH definition IN definitions %] @@ -78,26 +79,26 @@ [% END %]
        NameDescriptionAreaDefinitionAction[% t('Name') %][% t('Description') %][% t('Area') %][% t('Definition') %][% t('Action') %]
        - +
        [% ELSE %] -
        There are no saved definitions. Add a definition to the dictionary.
        +
        [% t('There are no saved definitions.') %] [% t('Add a definition to the dictionary.') %]
        [% END %] [% END %] [% IF ( new_dictionary ) %] -

        Add new definition

        +

        [% t('Add new definition') %]

        -
        Step 1 of 5: Name the new definition
          +
          [% t('Step 1 of 5: Name the new definition') %]
          1. - +
          2. - +
          @@ -108,16 +109,16 @@ [% END %] [%- IF ( step_2 ) -%] -

          Add new definition

          +

          [% t('Add new definition') %]

          - Step 2 of 5: Choose the area + [% t('Step 2 of 5: Choose the area') %]
          1. - [%- FOREACH area IN areas -%] [%- END -%] @@ -130,10 +131,10 @@ [%- END -%] [% IF ( step_3 ) %] -

            Add new definition

            +

            [% t('Add new definition') %]

            -Step 3 of 5: Choose a column +[% t('Step 3 of 5: Choose a column') %] @@ -166,10 +167,10 @@ [% END %] [% IF ( step_4 ) %] -

            Add new definition

            +

            [% t('Add new definition') %]

            -Step 4 of 5: Specify a value +[% t('Step 4 of 5: Specify a value') %] @@ -177,9 +178,9 @@ [% FOREACH column IN columns %] -
            1. Column: [% column.name %]
            2. +
              1. [% t('Column:') %] [% column.name %]
              2. [% IF ( column.distinct ) %] -
              3. [% FOREACH value IN column.values %] [% END %] @@ -187,22 +188,22 @@ [% END %] [% IF ( column.date ) %]
              4. - + - +
              5. - Start of date range + [% t('Start of date range') %]
                [% INCLUDE 'date-format.inc' %]
                - End of date range + [% t('End of date range') %]
                [% INCLUDE 'date-format.inc' %]
              6. [% END %] [% IF ( column.text ) %] -
              7. +
              8. [% END %] [% END %] @@ -222,26 +223,26 @@ -

                Add new definition

                +

                [% t('Add new definition') %]

                - Step 5 of 5: Confirm details + [% t('Step 5 of 5: Confirm details') %]
                1. - Name:[%- definition_name | html -%] + [% t('Name:') %][%- definition_name | html -%]
                2. - Description:[%- definition_description | html -%] + [% t('Description:') %][%- definition_description | html -%]
                3. - Area:[%- PROCESS area_name area=area -%] + [% t('Area:') %][%- PROCESS area_name area=area -%]
                4. - Data: + [% t('Data:') %] - - + + [%- FOREACH criteria_loo IN criteria_loop -%] diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/guided_reports_start.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/reports/guided_reports_start.tt index 86c17e8893..6bd3bfcdeb 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/guided_reports_start.tt +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/reports/guided_reports_start.tt @@ -1,3 +1,4 @@ +[% PROCESS 'i18n.inc' %] [% USE Asset %] [% USE KohaDates %] [% USE Koha %] @@ -5,29 +6,29 @@ [% SET footerjs = 1 %] [%- BLOCK area_name -%] [%- SWITCH area -%] - [%- CASE 'CIRC' -%]Circulation - [%- CASE 'CAT' -%]Catalog - [%- CASE 'PAT' -%]Patrons - [%- CASE 'ACQ' -%]Acquisitions - [%- CASE 'ACC' -%]Accounts - [%- CASE 'SER' -%]Serials + [%- CASE 'CIRC' -%][% t('Circulation') %] + [%- CASE 'CAT' -%][% t('Catalog') %] + [%- CASE 'PAT' -%][% t('Patrons') %] + [%- CASE 'ACQ' -%][% t('Acquisitions') %] + [%- CASE 'ACC' -%][% t('Accounts') %] + [%- CASE 'SER' -%][% t('Serials') %] [%- END -%] [%- END -%] [% INCLUDE 'doc-head-open.inc' %] -Koha › Reports › Guided reports wizard [%- IF ( saved1 ) -%]› Saved reports -[%- ELSIF ( create ) -%]› Create from SQL -[%- ELSIF ( showsql ) -%]› Saved reports › SQL view -[%- ELSIF ( execute ) -%]› Saved reports › [% name %] Report -[%- ELSIF ( editsql ) -%]› Saved reports › Edit SQL report +<title>[% t('Koha › Reports › Guided reports wizard') %] [%- IF ( saved1 ) -%][% t('› Saved reports') %] +[%- ELSIF ( create ) -%][% t('› Create from SQL') %] +[%- ELSIF ( showsql ) -%][% t('› Saved reports › SQL view') %] +[%- ELSIF ( execute ) -%][% t('› Saved reports ›') %] [% name %] [% t('Report') %] +[%- ELSIF ( editsql ) -%][% t('› Saved reports › Edit SQL report') %] [%- END -%] -[%- IF ( build1 ) -%]› Build a report, step 1 of 6: Choose a module -[%- ELSIF ( build2 ) -%]› Build a report, step 2 of 6: Pick a report type -[%- ELSIF ( build3 ) -%]› Build a report, step 3 of 6: Select columns for display -[%- ELSIF ( build4 ) -%]› Build a report, step 4 of 6: Select criteria to limit on -[%- ELSIF ( build5 ) -%]› Build a report, step 5 of 6: Pick which columns to total -[%- ELSIF ( build6 ) -%]› Build a report, step 6 of 6: Select how you want the report ordered +[%- IF ( build1 ) -%][% t('› Build a report, step 1 of 6: Choose a module') %] +[%- ELSIF ( build2 ) -%][% t('› Build a report, step 2 of 6: Pick a report type') %] +[%- ELSIF ( build3 ) -%][% t('› Build a report, step 3 of 6: Select columns for display') %] +[%- ELSIF ( build4 ) -%][% t('› Build a report, step 4 of 6: Select criteria to limit on') %] +[%- ELSIF ( build5 ) -%][% t('› Build a report, step 5 of 6: Pick which columns to total') %] +[%- ELSIF ( build6 ) -%][% t('› Build a report, step 6 of 6: Select how you want the report ordered') %] [%- END -%] [% INCLUDE 'doc-head-close.inc' %] @@ -59,22 +60,22 @@ [% INCLUDE 'header.inc' %] [% INCLUDE 'circ-search.inc' %] - @@ -104,59 +105,59 @@ [% INCLUDE "reports-toolbar.inc" %] [% IF ( start ) %] -

                  Guided reports

                  -

                  Use the guided reports engine to create non standard reports. -This feature aims to provide some middle ground between the built in -canned reports and writing custom SQL reports.

                  +

                  [% t('Guided reports') %]

                  +

                  [% t('Use the guided reports engine to create non standard reports.') %] +[% t('This feature aims to provide some middle ground between the built in') %] +[% t('canned reports and writing custom SQL reports.') %]

                  -

                  Build and run reports

                  +

                  [% t('Build and run reports') %]

                  [% IF ( CAN_user_reports_create_reports ) %] - + [% END %] [% IF ( CAN_user_reports_execute_reports ) %] - - + + [% END %] [% IF ( CAN_user_reports_create_reports ) %] - - + + [% END %] -

                  Reports Dictionary

                  -

                  Use the reports dictionary to define custom criteria to use in your reports

                  +

                  [% t('Reports Dictionary') %]

                  +

                  [% t('Use the reports dictionary to define custom criteria to use in your reports') %]

                  - - + + [% END %] [% IF report_converted %]
                  - The report "[% report_converted %]" has been converted. + [% t('The report "') %][% report_converted %][% t('" has been converted.') %]
                  [% END %] [% IF ( saved1 ) %] -[% IF ( savedreports ) %]

                  Saved reports

                  +[% IF ( savedreports ) %]

                  [% t('Saved reports') %]

                  - +
                  @@ -164,23 +165,23 @@ canned reports and writing custom SQL reports.

                  ColumnsValues[% t('Columns') %][% t('Values') %]
                  - - - - - - - - - - - - - - [% IF (usecache) %] [% END %] - - [% IF has_obsolete_reports %][% END %] - + + + + + + + + + + + + + + [% IF (usecache) %] [% END %] + + [% IF has_obsolete_reports %][% END %] + @@ -209,30 +210,30 @@ canned reports and writing custom SQL reports.

                  [% IF (usecache) %] [% END %] [% IF has_obsolete_reports %] [% END %] @@ -240,20 +241,16 @@ canned reports and writing custom SQL reports.

                  [%# There should be no space between these two buttons, it would render badly %] - Run + [% t('Run') %]
                  @@ -273,30 +270,30 @@ canned reports and writing custom SQL reports.

                  [% ELSE %]
                  [% IF (filter_set || filters.date || filters.author || filters.keyword) %] -

                  No saved reports match your criteria.

                  +

                  [% t('No saved reports match your criteria.') %]

                  [% IF ( CAN_user_reports_create_reports ) %] - +
                  - +
                  - + [% END %] [% ELSE %] -

                  There are no saved reports.

                  +

                  [% t('There are no saved reports.') %]

                  [% IF ( CAN_user_reports_create_reports ) %] - Build a new report? + [% t('Build a new report?') %] [% END %] [% END %]
                  @@ -307,16 +304,16 @@ canned reports and writing custom SQL reports.

                  [% IF ( build1 ) %] [% IF ( cache_error) %]
                  - Please choose a cache_expiry less than 30 days + [% t('Please choose a cache_expiry less than 30 days') %]
                  [% END %] -

                  Build a report

                  +

                  [% t('Build a report') %]

                  -Step 1 of 6: Choose a module to report on,[% IF (usecache) %] Set cache expiry, [% END %] and choose report visibility +[% t('Step 1 of 6: Choose a module to report on,') %][% IF (usecache) %] [% t('Set cache expiry,') %] [% END %] [% t('and choose report visibility') %]
                  1. - +
                  2. [% IF (public) %] -
                  3. +
                  4. [% ELSE %] -
                  5. +
                  6. [% END %] [% IF (usecache) %]
                  7. - +
                  8. [% END %]
                  - +
                  @@ -349,24 +346,24 @@ canned reports and writing custom SQL reports.

                  [% IF ( build2 ) %] -

                  Build a report

                  +

                  [% t('Build a report') %]

                  -
                  Step 2 of 6: Pick a report type -
                  1. +
                    [% t('Step 2 of 6: Pick a report type') %] +
                    - - + +
                    @@ -381,9 +378,9 @@ canned reports and writing custom SQL reports.

                    [% END %] [% IF ( build3 ) %] -

                    Build a report

                    -

                    Step 3 of 6: Select columns for display

                    -

                    Note: Be careful selecting when selecting columns. If your choice is too broad it could result in a very large report that will either not complete, or slow your system down.

                    +

                    [% t('Build a report') %]

                    +

                    [% t('Step 3 of 6: Select columns for display') %]

                    +

                    [% t('Note: Be careful selecting when selecting columns. If your choice is too broad it could result in a very large report that will either not complete, or slow your system down.') %]

                    @@ -404,7 +401,7 @@ canned reports and writing custom SQL reports.

                    [% ELSE %]

                    -
                    +
                    @@ -425,8 +422,8 @@ canned reports and writing custom SQL reports.

                    - - + +
                    @@ -434,14 +431,14 @@ canned reports and writing custom SQL reports.

                    [% END %] [% IF ( build4 ) %] -

                    Build a report

                    -
                    +

                    [% t('Build a report') %]

                    + -
                    Step 4 of 6: Select criteria to limit on +
                    [% t('Step 4 of 6: Select criteria to limit on') %]
                   IDReport nameTypeGroupSubgroupNotesAuthorCreation dateLast editLast runPublicJSON URLCache expiry (seconds)Saved resultsUpdateActions [% t('ID') %][% t('Report name') %][% t('Type') %][% t('Group') %][% t('Subgroup') %][% t('Notes') %][% t('Author') %][% t('Creation date') %][% t('Last edit') %][% t('Last run') %][% t('Public') %][% t('JSON URL') %][% t('Cache expiry (seconds)') %][% t('Saved results') %][% t('Update') %][% t('Actions') %]
                  [% savedreport.last_run | $KohaDates with_hours => 1 %] [% IF (savedreport.public) %] - Yes + [% t('Yes') %] [% ELSE %] - No + [% t('No') %] [% END %] [% IF (savedreport.public) %] - [% OPACBaseURL %]/cgi-bin/koha/svc/report?id=[% savedreport.id | html %] + [% OPACBaseURL %][% t('/cgi-bin/koha/svc/report?id=') %][% savedreport.id | html %] [% ELSE %] - [% Koha.Preference('staffClientBaseURL') %]/cgi-bin/koha/svc/report?id=[% savedreport.id | html %] + [% Koha.Preference('staffClientBaseURL') %][% t('/cgi-bin/koha/svc/report?id=') %][% savedreport.id | html %] [% END %] [% savedreport.cache_expiry %] [% FOR result IN savedreport.results %] - [% result.date_run %] -
                  + [% result.date_run %] +
                  [% END %]
                  [% IF savedreport.seems_obsolete %] - This report seems obsolete, it uses biblioitems.marcxml field. - Update SQL + [% t('This report seems obsolete, it uses biblioitems.marcxml field.') %] + [% t('Update SQL') %] [% END %]
                  [% FOREACH criteri IN criteria %] @@ -457,16 +454,16 @@ canned reports and writing custom SQL reports.

                  [% ELSE %] [% IF ( criteri.textrange ) %] - [% ELSE %] [% IF ( criteri.daterange ) %] - @@ -475,7 +472,7 @@ canned reports and writing custom SQL reports.

                  @@ -488,7 +485,7 @@ canned reports and writing custom SQL reports.

                  [% IF ( definitions ) %] -
                  Dictionary definitions +
                  [% t('Dictionary definitions') %]
                  from - to + [% t('from') %] + [% t('to') %]
                  from + [% t('from') %] - to + [% t('to') %] [% INCLUDE 'date-format.inc' %]
                  [% FOREACH definition IN definitions %] @@ -498,15 +495,15 @@ canned reports and writing custom SQL reports.

                  [% END %]
                  - -
                  + + [% END %] [% IF ( build5 ) %] -

                  Build a report

                  -

                  Step 5 of 6: Pick which columns to total

                  +

                  [% t('Build a report') %]

                  +

                  [% t('Step 5 of 6: Pick which columns to total') %]

                  @@ -530,15 +527,15 @@ canned reports and writing custom SQL reports.

                  [% definition.name %]
                - -
                + +
            [% END %] [% IF ( build6 ) %] -

            Build a report

            -

            Step 6 of 6: Choose how you want the report ordered

            +

            [% t('Build a report') %]

            +

            [% t('Step 6 of 6: Choose how you want the report ordered') %]

            @@ -569,8 +566,8 @@ canned reports and writing custom SQL reports.

            [% IF ( showreport ) %] -

            Confirm custom report

            -

            Your report will be generated with the following SQL statement.

            +

            [% t('Confirm custom report') %]

            +

            [% t('Your report will be generated with the following SQL statement.') %]

            [% sql |html %]

            @@ -580,7 +577,7 @@ canned reports and writing custom SQL reports.

            -

            You will need to save the report before you can execute it

            +

            [% t('You will need to save the report before you can execute it') %]

            @@ -594,11 +591,11 @@ canned reports and writing custom SQL reports.

            -Save your custom report +[% t('Save your custom report') %]
              -
            1. Required
            2. +
            3. [% t('Required') %]
            4. [% PROCESS group_and_subgroup_selection %] -
            5. +
            @@ -607,59 +604,59 @@ canned reports and writing custom SQL reports.

            [% IF ( warn_authval_problem ) %]
            -

            Errors found when processing parameters for report: [% name %]

            +

            [% t('Errors found when processing parameters for report:') %] [% name %]

            [% FOREACH problematic_authval IN problematic_authvals %]

            - [% problematic_authval.name %]: The authorized value category ([% problematic_authval.authval %]) - you selected does not exist. + [% problematic_authval.name %]: [% t('The authorized value category (') %][% problematic_authval.authval %]) + [% t('you selected does not exist.') %]

            [% END %] -
            + - - - - - - - - - + + + + + + + + + [% IF ( phase_update) %] - - + + [% ELSIF ( phase_save) %] - - - + + + [% END %]
            -
            - + +
            [% END %] [% IF ( enter_params ) %] -
            - + + [% IF ( auth_val_error ) %] - +
            -

            Errors found when processing parameters for report: [% name %]

            +

            [% t('Errors found when processing parameters for report:') %] [% name %]

            [% FOREACH auth_val_error IN auth_val_errors %]

            - [% auth_val_error.entry %]: The authorized value category ([% auth_val_error.auth_val %]) - you selected does not exist. + [% auth_val_error.entry %]: [% t('The authorized value category (') %][% auth_val_error.auth_val %]) + [% t('you selected does not exist.') %]

            [% END %]
            [% ELSE %] - -

            Enter parameters for report [% name %]:

            + +

            [% t('Enter parameters for report') %] [% name %]:

            [% IF ( notes ) %]

            [% notes %]

            [% END %]
              @@ -673,7 +670,7 @@ canned reports and writing custom SQL reports.

            1. [% ELSE %]
            2. - [% FOREACH value IN sql_param.input.values %] [% END %] @@ -690,20 +687,20 @@ canned reports and writing custom SQL reports.

              [% IF ( execute ) %]

              [% name %]

              -[% IF ( notes ) %]

              Notes: [% notes %]

              [% END %] -[% IF ( unlimited_total ) %]

              Total number of results: [% unlimited_total %][% IF unlimited_total > limit %] ([% limit %] shown)[% END %].

              [% END %] - +[% IF ( notes ) %]

              [% t('Notes:') %] [% notes %]

              [% END %] +[% IF ( unlimited_total ) %]

              [% t('Total number of results:') %] [% unlimited_total %][% IF unlimited_total > limit %] ([% limit %] [% t('shown)') %][% END %].

              [% END %] +
              - - + + [% FOREACH p IN sql_params %] - + [% END %] - +
    - [% header_ro.cell %] + [% header_ro.cell %] [% header_ro.cell %]
    @@ -813,7 +810,7 @@ $(document).ready(function() {
    [% reportname %]
      - [% IF ( notes ) %]
    1. Notes: [% notes %]
    2. [% ELSE %][% END %] + [% IF ( notes ) %]
    3. [% t('Notes:') %] [% notes %]
    4. [% ELSE %][% END %]
    @@ -824,7 +821,7 @@ $(document).ready(function() {
    -

    Your report "[% reportname %]" has been saved

    +

    [% t('Your report "') %][% reportname %][% t('" has been saved') %]

    [% END %] @@ -833,39 +830,39 @@ $(document).ready(function() { [% IF ( editsql ) %] - +
    -Edit SQL report +[% t('Edit SQL report') %]
      -
    1. Required
    2. +
    3. [% t('Required') %]
    4. [% PROCESS group_and_subgroup_selection %] [% IF (public) %] -
    5. +
    6. [% ELSE %] -
    7. +
    8. [% END %] [% IF (usecache) %]
    9. - +
    10. [% END %] -
    11. +
    - SQL: + [% t('SQL:') %]
    - Required + [% t('Required') %]
    - Cancel + [% t('Cancel') %]
    @@ -875,17 +872,17 @@ $(document).ready(function() { [% IF ( errors ) %]
    -The following error was encountered:
    +[% t('The following error was encountered:') %]
    [% FOREACH error IN errors %] - [% IF ( error.sqlerr ) %]This report contains the SQL keyword [% error.sqlerr %]. -
    Use of this keyword is not allowed in Koha reports due to security and data integrity risks. Only SELECT queries are allowed. -
    Please return to the "Saved Reports" screen and delete this report or retry creating a new one. - [% ELSIF ( error.queryerr ) %]The database returned the following error:
    [% error.queryerr %]
    Please check the log for further details. - [% ELSIF ( error.cache_expiry ) %]Please select a cache expiry less than 30 days. + [% IF ( error.sqlerr ) %][% t('This report contains the SQL keyword') %] [% error.sqlerr %]. +
    [% t('Use of this keyword is not allowed in Koha reports due to security and data integrity risks. Only SELECT queries are allowed.') %] +
    [% t('Please return to the "Saved Reports" screen and delete this report or retry creating a new one.') %] + [% ELSIF ( error.queryerr ) %][% t('The database returned the following error:') %]
    [% error.queryerr %]
    [% t('Please check the log for further details.') %] + [% ELSIF ( error.cache_expiry ) %][% t('Please select a cache expiry less than 30 days.') %] [% ELSE %] [% END %] [% END %]
    @@ -904,19 +901,19 @@ $(document).ready(function() {
    -

    Filter

    +

    [% t('Filter') %]

      -
    1. +
    2. [% INCLUDE 'date-format.inc' %]
    3. -
    4. -
    5. +
    6. +
    - Clear + [% t('Clear') %]
    @@ -1185,12 +1182,11 @@ $(document).ready(function() { [% BLOCK group_and_subgroup_selection %]
  • - - - + + + - - - + + +
  • - - - + + + - - - - + + + +
  • [% END %] diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/issues_avg_stats.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/reports/issues_avg_stats.tt index 32871a5cc2..b3be085464 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/issues_avg_stats.tt +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/reports/issues_avg_stats.tt @@ -1,7 +1,8 @@ +[% PROCESS 'i18n.inc' %] [% USE Branches %] [% SET footerjs = 1 %] [% INCLUDE 'doc-head-open.inc' %] -Koha › Reports › Average loan time +[% t('Koha › Reports › Average loan time') %] [% INCLUDE 'doc-head-close.inc' %] @@ -9,7 +10,7 @@ [% INCLUDE 'header.inc' %] [% INCLUDE 'cat-search.inc' %] - +
    @@ -19,9 +20,9 @@ [% IF ( do_it ) %] [% FOREACH mainloo IN mainloop %] -

    Average checkout period

    +

    [% t('Average checkout period') %]

    [% IF ( mainloo.loopfilter ) %] -

    Filtered on:

    +

    [% t('Filtered on:') %]

    [% FOREACH loopfilte IN mainloo.loopfilter %]

    [% IF ( loopfilte.err ) %] [% END %] [% loopfilte.crit %] =[% loopfilte.filter %][% IF ( loopfilte.err ) %] [% END %]

    [% END %] @@ -33,7 +34,7 @@ [% FOREACH loopco IN mainloo.loopcol %]
    [% END %] - + [% FOREACH loopro IN mainloo.looprow %] @@ -50,7 +51,7 @@ [% END %] - + [% FOREACH loopfoote IN mainloo.loopfooter %] - - - - - - - - - - - - - - - + + + + + + + + + + + + + + + @@ -112,22 +113,22 @@
      -
    1. -
    2. +
    3. -
    4. + [% FOREACH itemtype IN itemtypes %] [% END %]
    5. - + - + [% FOREACH n IN AuthorisedValues.GetDescriptionsByKohaField( kohafield => 'items.notforloan') %] [% IF n.authorised_value == notforloanfilter %] @@ -172,7 +173,7 @@ [% INCLUDE 'columns_settings.inc' %] [% Asset.js("js/table_filters.js") %] [% Asset.js("lib/jquery/plugins/jquery.checkboxes.min.js") %] -
    [% loopco.coltitle %]TOTAL[% t('TOTAL') %]
    TOTAL[% t('TOTAL') %] [% loopfoote.totalcol %] @@ -64,61 +65,61 @@
    - Average checkout period statistics + [% t('Average checkout period statistics') %] - - - - + + + + - + - - - + - + - - - + - + - + - + [% IF ( hassort1 ) %] - + [% ELSE %][% END %] - + [% END %] - + [% FOREACH loopro IN mainloo.looprow %] @@ -76,7 +77,7 @@ [% END %] - + [% FOREACH loopfoote IN mainloo.loopfooter %] [% END %] @@ -88,70 +89,70 @@
    - Circulation statistics
    TitleRowColumnFilter[% t('Title') %][% t('Row') %][% t('Column') %][% t('Filter') %]
    Checkout date[% t('Checkout date') %] - + + [% INCLUDE 'date-format.inc' %]
     by  [% t('by') %]
    Returns[% t('Returns') %] - + + [% INCLUDE 'date-format.inc' %]
     by  [% t('by') %]
    Patron category[% t('Patron category') %] @@ -131,7 +132,7 @@
    Item type[% t('Item type') %] @@ -144,7 +145,7 @@
    Library[% t('Library') %] @@ -156,7 +157,7 @@
    Sort1[% t('Sort1') %] @@ -171,7 +172,7 @@ [% END %] [% IF ( hassort2 ) %] [% IF ( HglghtSort2 ) %]
    Sort2[% t('Sort2') %] @@ -189,17 +190,17 @@
    - Output + [% t('Output') %]
    1. - +
    2. - - - - + + +
    [% loopco.coltitle_display |html %]TOTAL[% t('TOTAL') %]
    TOTAL[% t('TOTAL') %][% loopfoote.totalcol %]
    + [% t('Circulation statistics') %]
    - - - - + + + + - + - - - - + - + - + - - + + - + - + - + [% IF ( hassort1 ) %] - + [% END %] [% IF ( hassort2 ) %] - + [% END %] - + - + - + [% IF (attribute_types_by_class.keys.size) %] - + [% FOREACH class IN attribute_types_by_class.keys.sort %] [% IF (class) %] @@ -293,7 +294,7 @@
    TitleRowColumnFilter[% t('Title') %][% t('Row') %][% t('Column') %][% t('Filter') %]
    Period[% t('Period') %] - + + [% INCLUDE 'date-format.inc' %]
    - + + + + + + + + - + + + + + + + + + + + + +
    Patron category[% t('Patron category') %]
    Item type[% t('Item type') %]
    Issuing library[% t('Issuing library') %]
    Collection[% t('Collection') %]
    Shelving location[% t('Shelving location') %]
    Item call number[% t('Item call number') %] From (inclusive) to (exclusive) [% t('From') %] [% t('(inclusive) to') %] [% t('(exclusive)') %]
    Patron sort 1
    [% t('Patron sort 1') %]
    Patron sort 2
    [% t('Patron sort 2') %]
    Home library
    [% t('Home library') %]
    Holding library
    [% t('Holding library') %]
    Patron library[% t('Patron library') %]
    Patron attributes[% t('Patron attributes') %]
    [% IF attr_type.authorised_value_category %]

    - Cell value + [% t('Cell value') %]
    1. - +
    2. - +
    3. - +
    - Output + [% t('Output') %]
    1. - +
    2. - - - + + + [% FOREACH csv_profile IN csv_profiles %] -
    TitleAuthorLost statusLost onBarcodeCall numberDate last seenPriceRep.priceLibraryItem typeCurrent locationLocationNot for loan statusNotes[% t('Title') %][% t('Author') %][% t('Lost status') %][% t('Lost on') %][% t('Barcode') %][% t('Call number') %][% t('Date last seen') %][% t('Price') %][% t('Rep.price') %][% t('Library') %][% t('Item type') %][% t('Current location') %][% t('Location') %][% t('Not for loan status') %][% t('Notes') %]