Attachment 145854 Details for Bug 32292 – Bug 32292: Add column descriptions to aqorders table

[patch] Bug 32292: Add column descriptions to aqorders table

Bug-32292-Add-column-descriptions-to-aqorders-tabl.patch (text/plain), 4.44 KB, created by Martin Renvoize (ashimema) on 2023-01-31 12:59:13 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Martin Renvoize (ashimema)

Created: 2023-01-31 12:59:13 UTC

Size: 4.44 KB

patch

obsolete

>From 1aab83dc1f96f2b6d73a61ab14898e39b8c9dd46 Mon Sep 17 00:00:00 2001
>From: Katrin Fischer <katrin.fischer.83@web.de>
>Date: Mon, 21 Nov 2022 21:40:54 +0000
>Subject: [PATCH] Bug 32292: Add column descriptions to aqorders table
>
>This adds nice descriptions to the aqorders database columns.
>
>To test:
>* Go to Guided reports
>* Start a new report for acquisitions module
>* Verify that all aqorders columns show with nice descriptions
>  None should be missing.
>
>Signed-off-by: David Nind <david@davidnind.com>
>Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
>---
> Koha/Database/Columns.pm | 52 ++++++++++++++++++++++++++++++++++++++++
> 1 file changed, 52 insertions(+)
>
>diff --git a/Koha/Database/Columns.pm b/Koha/Database/Columns.pm
>index 519a215b9b5..d092b23ab15 100644
>--- a/Koha/Database/Columns.pm
>+++ b/Koha/Database/Columns.pm
>@@ -58,6 +58,58 @@ to descriptions, for several tables. Currently
> 
> sub columns {
>     return {
>+        aqorders => {
>+            "ordernumber"             => __("Order number"),
>+            "biblionumber"            => __("Biblionumber (internal)"),
>+            "entrydate"               => __("Creation date"),
>+            "quantity"                => __("Quantity"),
>+            "currency"                => __("Currency"),
>+            "listprice"               => __("Vendor price"),
>+            "datereceived"            => __("Date received"),
>+            "invoiceid"               => __("Invoice ID (internal)"),
>+            "freight"                 => __("Not used (deprecated)"),
>+            "unitprice"               => __("Actual cost"),
>+            "unitprice_tax_excluded"  => __("Actual cost, tax excl."),
>+            "unitprice_tax_included"  => __("Actual cost, tax incl."),
>+            "quantityreceived"        => __("Quantity received"),
>+            "created_by"              => __("Borrower number of creator"),
>+            "datecancellationprinted" => __("Cancellation date"),
>+            "cancellationreason"      => __("Cancellation reason"),
>+            "order_internalnote"      => __("Internal note"),
>+            "order_vendornote"        => __("Vendor note"),
>+            "purchaseordernumber"     => __("Not used (deprecated)"),
>+            "basketno"                => __("Basket ID (inernal)"),
>+            "timestamp"               => __("Timestamp"),
>+            "rrp"                     => __("Retail price"),
>+            "replacementprice"        => __("Replacement price"),
>+            "rrp_tax_excluded"        => __("Retail price, tax excl."),
>+            "rrp_tax_included"        => __("Retail price, tax incl."),
>+            "ecost"                   => __("Budgeted cost"),
>+            "ecost_tax_excluded"      => __("Budgeted cost, tax excl."),
>+            "ecost_tax_included"      => __("Budgeted cost, tax incl."),
>+            "tax_rate_bak"            => __("Tax rate backup (deprecated)"),
>+            "tax_rate_on_ordering"    => __("Tax rate on order"),
>+            "tax_rate_on_receiving"   => __("Tax rate on receive"),
>+            "tax_value_bak"           => __("Tax value backup (deprecated)"),
>+            "tax_value_on_ordering"   => __("Tax amount on order"),
>+            "tax_value_on_receiving"  => __("Tax amount on receive"),
>+            "discount"                => __("Discount"),
>+            "budget_id"               => __("Fund ID (internal)"),
>+            "budgetdate"              => __("Not used (deprecated)"),
>+            "sort1"                   => __("Statistic 1"),
>+            "sort2"                   => __("Statistic 2"),
>+            "sort1_authcat"           => __("Not used"),
>+            "sort2_authcat"           => __("Not used"),
>+            "uncertainprice"          => __("Uncertain price"),
>+            "subscriptionid"          => __("Subscription ID (internal)"),
>+            "parent_ordernumber"      => __("Parent order number (internal)"),
>+            "orderstatus"             => __("Order status"),
>+            "line_item_id"            => __("Line item ID (EDIFACT)"),
>+            "suppliers_reference_number" => __("Vendor reference number (EDIFACT)"),
>+            "suppliers_reference_qualifier" => __("Vendor reference qualifier (EDIFACT)"),
>+            "suppliers_report"        => __("Vendor report (EDIFACT)"),
>+            "estimated_delivery_date" => __("Estimated delivery date"),
>+        },
>         borrowers => {
>             "borrowernumber"      => __("Borrower number"),
>             "title"               => __("Salutation"),
>-- 
>2.39.1

Actions: View | Diff | Splinter Review

Attachments on bug 32292: 144137 | 144138 | 144139 | 144140 | 144141 | 144410 | 144411 | 144412 | 144413 | 144414 | 145853 | 145854 | 145855 | 145856 | 145857 | 145868