[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpcompta-dev] r583 - trunk/rapport_avance/sql
From: |
phpcompta-dev |
Subject: |
[Phpcompta-dev] r583 - trunk/rapport_avance/sql |
Date: |
Sat, 23 Nov 2013 14:05:05 +0100 (CET) |
Author: danydb
Date: 2013-11-23 14:05:05 +0100 (Sat, 23 Nov 2013)
New Revision: 583
Modified:
trunk/rapport_avance/sql/1-add-listing.sql
Log:
Change listing_param structure, add trigger for formatting lp_code
Modified: trunk/rapport_avance/sql/1-add-listing.sql
===================================================================
--- trunk/rapport_avance/sql/1-add-listing.sql 2013-11-22 18:18:19 UTC (rev
582)
+++ trunk/rapport_avance/sql/1-add-listing.sql 2013-11-23 13:05:05 UTC (rev
583)
@@ -16,7 +16,6 @@
l_id bigint constraint fk_listing_param_listing references
rapport_advanced.listing(l_id) on update cascade on delete cascade,
lp_code text not null constraint c_lp_code check (length (trim(lp_code))> 0),
lp_comment text,
- l_card int default 0,
l_order int,
ad_id bigint constraint fk_listing_param_detail_attr_def references attr_def
(ad_id),
lp_card_saldo char(1) check (lp_card_saldo in ('C','D','S',NULL)),
@@ -27,7 +26,7 @@
fp_signed integer,
jrn_def_type character(3),
tt_id integer,
- type_detail integer,
+ type_detail text not null,
with_tmp_val account_type,
type_sum_account bigint,
operation_pcm_val account_type,
@@ -61,4 +60,27 @@
ON rapport_advanced.listing_param
FOR EACH ROW
EXECUTE PROCEDURE
rapport_advanced.formulaire_param_detail_jrn_def_id_ins_upd();
+ alter table rapport_advanced.listing_param add constraint ck_type_detail
check (type_detail in ('ATTR','COMP','FORM','SALDO','ACCOUNT'));
+
+CREATE OR REPLACE FUNCTION rapport_advanced.listing_param_code_transform()
+ RETURNS trigger
+ AS $function$
+ declare
+ sResult text;
+ begin
+ sResult := lower(NEW.lp_code);
+
+ sResult := translate(sResult,E'éèêëàâäïîüûùöôç','eeeeaaaiiuuuooc');
+ sResult := translate(sResult,E' $€µ£%.+-/\\!(){}(),;_&|"#''^<>*','');
+
+ NEW.lp_code=upper(sResult);
+
+return NEW;
+
+end;
+$function$
+ LANGUAGE plpgsql;
+
+create trigger listing_param_code_transform_trg before insert or update of
lp_code on rapport_advanced.listing_param
+ for each row execute procedure
rapport_advanced.listing_param_code_transform();
commit;
\ No newline at end of file
---
PhpCompta est un logiciel de comptabilité libre en ligne (full web)
Projet opensource http://www.phpcompta.eu
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpcompta-dev] r583 - trunk/rapport_avance/sql,
phpcompta-dev <=