From e79fa172f4a2850437d2a93960e27dedb84c07ab Mon Sep 17 00:00:00 2001 From: miker Date: Sun, 3 Dec 2006 14:44:26 +0000 Subject: [PATCH] adding payment views and setting as core tables git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_1_0@6648 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/examples/fm_IDL.xml | 104 +++++++++++++++++++++++-------- Open-ILS/src/sql/Pg/080.schema.money.sql | 6 ++ 2 files changed, 83 insertions(+), 27 deletions(-) diff --git a/Open-ILS/examples/fm_IDL.xml b/Open-ILS/examples/fm_IDL.xml index 1a640da5e8..4a26f374d4 100644 --- a/Open-ILS/examples/fm_IDL.xml +++ b/Open-ILS/examples/fm_IDL.xml @@ -1942,24 +1942,24 @@ - + - - - - - - - - - - - - - + + + + + + + + + + + + + @@ -1971,23 +1971,73 @@ - + - - - - - - - - - - - - + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + diff --git a/Open-ILS/src/sql/Pg/080.schema.money.sql b/Open-ILS/src/sql/Pg/080.schema.money.sql index 6db570b77a..9a070d0e8a 100644 --- a/Open-ILS/src/sql/Pg/080.schema.money.sql +++ b/Open-ILS/src/sql/Pg/080.schema.money.sql @@ -57,6 +57,12 @@ CREATE OR REPLACE VIEW money.payment_view AS FROM money.payment p JOIN pg_class c ON (p.tableoid = c.oid); +CREATE OR REPLACE VIEW money.non_drawer_payment_view AS + SELECT p.*, c.relname AS payment_type + FROM money.bnm_payment p + JOIN pg_class c ON p.tableoid = c.oid + WHERE c.relname NOT IN ('cash_payment','check_payment','credit_card_payment'); + CREATE OR REPLACE VIEW money.transaction_billing_type_summary AS SELECT xact, billing_type AS last_billing_type, -- 2.11.0