From 707c98f780eb60b065c3a9fba135b51ca9ccfa8b Mon Sep 17 00:00:00 2001 From: miker Date: Mon, 7 Apr 2008 14:24:03 +0000 Subject: [PATCH] adding "first5" function to trim zip codes git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_1_2@9242 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/005.schema.actors.sql | 4 ++++ Open-ILS/web/reports/oils_rpt_tforms.js | 5 +++++ Open-ILS/web/reports/xul/transforms.js | 5 +++++ 3 files changed, 14 insertions(+) diff --git a/Open-ILS/src/sql/Pg/005.schema.actors.sql b/Open-ILS/src/sql/Pg/005.schema.actors.sql index d783c5eef4..2f0a62d0b1 100644 --- a/Open-ILS/src/sql/Pg/005.schema.actors.sql +++ b/Open-ILS/src/sql/Pg/005.schema.actors.sql @@ -524,4 +524,8 @@ CREATE INDEX actor_org_address_org_unit_idx ON actor.org_address (org_unit); INSERT INTO actor.org_address VALUES (DEFAULT,DEFAULT,DEFAULT,1,'123 Main St.',NULL,'Anywhere',NULL,'GA','US','30303'); UPDATE actor.org_unit SET holds_address = 1, ill_address = 1, billing_address = 1, mailing_address = 1; +CREATE OR REPLACE FUNCTION public.first5 ( TEXT ) RETURNS TEXT AS $$ + SELECT SUBSTRING( $1, 1, 5); +$$ LANGUAGE SQL; + COMMIT; diff --git a/Open-ILS/web/reports/oils_rpt_tforms.js b/Open-ILS/web/reports/oils_rpt_tforms.js index e890204945..3a901ea460 100644 --- a/Open-ILS/web/reports/oils_rpt_tforms.js +++ b/Open-ILS/web/reports/oils_rpt_tforms.js @@ -51,6 +51,11 @@ var OILS_RPT_TRANSFORMS = { label : 'Upper case' }, + first5 : { + datatype : [OILS_RPT_DTYPE_STRING, 'text'], + label : 'First 5 characters (for US ZIP code)' + }, + /* timestamp transforms ----------------------- */ dow : { datatype : OILS_RPT_DTYPE_TIMESTAMP, diff --git a/Open-ILS/web/reports/xul/transforms.js b/Open-ILS/web/reports/xul/transforms.js index c901f346ec..e08e3cbf09 100644 --- a/Open-ILS/web/reports/xul/transforms.js +++ b/Open-ILS/web/reports/xul/transforms.js @@ -88,6 +88,11 @@ var OILS_RPT_TRANSFORMS = { label : 'Upper case' }, + firt5 : { + datatype : [ OILS_RPT_DTYPE_STRING ], + label : 'First 5 characters (for US ZIP code)' + }, + /* timestamp transforms ----------------------- */ dow : { datatype : [ OILS_RPT_DTYPE_TIMESTAMP ], -- 2.11.0