Bug 19719: Add new column for collection in the patron checkouts data tables
[koha.git] / admin / columns_settings.yml
index a01f6fe..cec35f3 100644 (file)
@@ -83,7 +83,122 @@ modules:
         -
           columnname: actions
 
+  catalogue:
+    detail:
+      checkoutshistory-table:
+        -
+          columnname: patron
+          cannot_be_toggled: 1
+          cannot_be_modified: 1
+        -
+          columnname: barcode
+          cannot_be_toggled: 1
+          cannot_be_modified: 1
+        -
+          columnname: checked_out_from
+        -
+          columnname: renewed
+        -
+          columnname: checkout_on
+        -
+          columnname: due_date
+        -
+          columnname: checkin_on
+
+  cataloguing:
+    additem:
+      itemst:
+        # NOTE: These columns are in the same order as kohastructure.sql, and contain all items
+        # columns except for the following internal/obsolete fields: stack, more_subfields_xml,
+        # cn_sort, permanent_location, damaged_on itemlost_on, withdrawn_on, issues, renewals and
+        # reserves.
+        -
+          columnname: barcode
+        -
+          columnname: dateaccessioned
+        -
+          columnname: booksellerid
+        -
+          columnname: homebranch
+        -
+          columnname: price
+        -
+          columnname: replacementprice
+        -
+          columnname: replacementpricedate
+        -
+          columnname: datelastborrowed
+        -
+          columnname: datelastseen
+        -
+          columnname: stack
+        -
+          columnname: notforloan
+        -
+          columnname: damaged
+        -
+          columnname: itemlost
+        -
+          columnname: withdrawn
+        -
+          columnname: itemcallnumber
+        -
+          columnname: coded_location_qualifier
+        -
+          columnname: restricted
+        -
+          columnname: itemnotes
+        -
+          columnname: itemnotes_nonpublic
+        -
+          columnname: holdingbranch
+        -
+          columnname: paidfor
+        -
+          columnname: timestamp
+        -
+          columnname: location
+        -
+          columnname: onloan
+        -
+          columnname: cn_source
+        -
+          columnname: ccode
+        -
+          columnname: materials
+        -
+          columnname: uri
+        -
+          columnname: itype
+        -
+          columnname: enumchron
+        -
+          columnname: copynumber
+        -
+          columnname: stocknumber
+
   members:
+    fines:
+      account-fines:
+        -
+          columnname: date
+        -
+          columnname: description
+        -
+          columnname: note
+        -
+          columnname: amount
+          cannot_be_toggled: 1
+          cannot_be_modified: 1
+        -
+          columnname: amountoutstanding
+          cannot_be_toggled: 1
+          cannot_be_modified: 1
+        -
+          columnname: actions
+          cannot_be_toggled: 1
+          cannot_be_modified: 1
+
     member:
       memberresultst:
         -
@@ -94,6 +209,8 @@ modules:
           columnname: cardnumber
         -
           columnname: name
+        -
+          columnname: dateofbirth
         -
           columnname: category
         -
@@ -111,6 +228,83 @@ modules:
           cannot_be_toggled: 1
           cannot_be_modified: 1
 
+    moremember:
+      issues-table:
+        -
+          columnname: sort_order
+          cannot_be_toggled: 1
+          cannot_be_modified: 1
+          is_hidden: 1
+        -
+          columnname: todays_or_previous_checkouts
+          cannot_be_toggled: 1
+          cannot_be_modified: 1
+          is_hidden: 1
+        -
+          columnname: due_date_unformatted
+          cannot_be_toggled: 1
+          cannot_be_modified: 1
+          is_hidden: 1
+        -
+          columnname: due_date
+        -
+          columnname: title
+        -
+          columnname: item_type
+        -
+          columnname: collection_code
+        -
+          columnname: location
+        -
+          columnname: homebranch
+        -
+          columnname: checkout_on
+        -
+          columnname: checkout_from
+        -
+          columnname: callno
+        -
+          columnname: charge
+        -
+          columnname: fine
+        -
+          columnname: price
+        -
+          columnname: renew
+          cannot_be_toggled: 1
+          cannot_be_modified: 1
+        -
+          columnname: checkin
+        -
+          columnname: export
+          cannot_be_toggled: 1
+          cannot_be_modified: 1
+
+    holdshistory:
+      holdshistory-table:
+        -
+          columnname: title
+          cannot_be_toggled: 1
+          cannot_be_modified: 1
+        -
+          columnname: author
+        -
+          columnname: barcode
+        -
+          columnname: branch
+        -
+          columnname: reservedate
+        -
+          columnname: expirationdate
+        -
+          columnname: waitingdate
+        -
+          columnname: cancellationdate
+        -
+          columnname: itemtype
+        -
+          columnname: status
+
   reports:
     lostitems:
       lostitems-table:
@@ -122,6 +316,8 @@ modules:
           columnname: author
         -
           columnname: lostcode
+        -
+          columnname: itemlost_on
         -
           columnname: barcode
         -
@@ -140,19 +336,64 @@ modules:
           columnname: current_location
         -
           columnname: location
+        -
+          columnname: notforloan
         -
           columnname: notes
 
+    saved-sql:
+      table_reports:
+        -
+          columnname: selection
+          cannot_be_toggled: 1
+          cannot_be_modified: 1
+        -
+          columnname: report_id
+          cannot_be_toggled: 1
+          cannot_be_modified: 1
+        -
+          columnname: report_name
+        -
+          columnname: type
+        -
+          columnname: group
+        -
+          columnname: subgroup
+        -
+          columnname: notes
+        -
+          columnname: author
+        -
+          columnname: creation_date
+        -
+          columnname: last_edit
+        -
+          columnname: last_run
+        -
+          columnname: public
+        -
+          columnname: json_url
+        -
+          columnname: cache_expiry
+        -
+          columnname: saved_results
+        -
+          columnname: update
+        -
+          columnname: actions
+          cannot_be_toggled: 1
+          cannot_be_modified: 1
+
   circ:
     circulation:
       issues-table:
         -
-          columnname: un
+          columnname: sort_order
           cannot_be_toggled: 1
           cannot_be_modified: 1
           is_hidden: 1
         -
-          columnname: deux
+          columnname: todays_or_previous_checkouts
           cannot_be_toggled: 1
           cannot_be_modified: 1
           is_hidden: 1
@@ -167,6 +408,12 @@ modules:
           columnname: title
         -
           columnname: item_type
+        -
+          columnname: collection_code
+        -
+          columnname: location
+        -
+          columnname: homebranch
         -
           columnname: checkout_on
         -
@@ -175,6 +422,8 @@ modules:
           columnname: callno
         -
           columnname: charge
+        -
+          columnname: fine
         -
           columnname: price
         -
@@ -183,9 +432,139 @@ modules:
           cannot_be_modified: 1
         -
           columnname: checkin
-          cannot_be_toggled: 1
-          cannot_be_modified: 1
         -
           columnname: export
           cannot_be_toggled: 1
           cannot_be_modified: 1
+
+    returns:
+      checkedintable:
+        -
+          columnname: due_date
+        -
+          columnname: title
+        -
+          columnname: author
+        -
+          columnname: barcode
+        -
+          columnname: homelibrary
+        -
+          columnname: holdinglibrary
+        -
+          columnname: location
+        -
+          columnname: itemcallnumber
+        -
+          columnname: dateaccessioned
+          is_hidden: 1
+        -
+          columnname: itype
+        -
+          columnname: borrower
+        -
+          columnname: itemnote
+
+    view_holdsqueue:
+      holds-table:
+        -
+          columnname: title
+        -
+          columnname: collection
+        -
+          columnname: document_type
+        -
+          columnname: callnumber
+        -
+          columnname: copynumber
+        -
+          columnname: enumeration
+        -
+          columnname: barcode
+        -
+          columnname: patron
+        -
+          columnname: send_to
+        -
+          columnname: date
+        -
+          columnname: notes
+
+    holds:
+      holds-to-pull:
+        -
+          columnname: pull_items
+        -
+          columnname: avalaible_items
+        -
+          columnname: patrons
+        -
+          columnname: patron
+        -
+          columnname: title
+        -
+          columnname: libraries
+        -
+          columnname: call_numbers
+        -
+          columnname: copy_numbers
+        -
+          columnname: enumeration
+        -
+          columnname: itemtypes
+        -
+          columnname: locations
+        -
+          columnname: hold_date
+        -
+          columnname: action
+
+  opac:
+    biblio-detail:
+      holdingst:
+        -
+          columnname: item_itemtype
+        -
+          columnname: item_current_location
+        -
+          columnname: item_home_location
+        -
+          columnname: item_shelving_location
+          is_hidden: 1
+        -
+          columnname: item_ccode
+        -
+          columnname: item_callnumber
+        -
+          columnname: item_enumchron
+        -
+          columnname: item_url
+        -
+          columnname: item_copy
+        -
+          columnname: item_status
+        -
+          columnname: item_notes
+        -
+          columnname: item_datedue
+        -
+          columnname: item_barcode
+          is_hidden: 1
+        -
+          columnname: item_holds
+        -
+          columnname: item_priority
+        -
+          columnname: item_coursereserves
+
+      subscriptionst:
+        -
+          columnname: serial_serialseq
+        -
+          columnname: serial_publisheddate
+        -
+          columnname: serial_planneddate
+        -
+          columnname: serial_status
+        -
+          columnname: serial_notes