[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Noalyss-commit] [noalyss] 123/323: SQL : patch for new version CSS : in
From: |
Dany De Bontridder |
Subject: |
[Noalyss-commit] [noalyss] 123/323: SQL : patch for new version CSS : install new theme |
Date: |
Wed, 14 Mar 2018 17:38:36 -0400 (EDT) |
sparkyx pushed a commit to branch master
in repository noalyss.
commit e432ff5bdcc0edb637b84e256b00e95fd52e215c
Author: Dany De Bontridder <address@hidden>
Date: Mon Feb 5 21:31:58 2018 +0100
SQL : patch for new version
CSS : install new theme
---
html/{style-r692.css => style-classic7.css} | 0
include/class/dossier.class.php | 2 +-
include/constant.php | 2 +-
include/sql/patch/ac-upgrade17.sql | 16 ++++
include/sql/patch/upgrade125.sql | 109 ++++++++++++++++++++++++++++
5 files changed, 127 insertions(+), 2 deletions(-)
diff --git a/html/style-r692.css b/html/style-classic7.css
similarity index 100%
rename from html/style-r692.css
rename to html/style-classic7.css
diff --git a/include/class/dossier.class.php b/include/class/dossier.class.php
index 957beb2..4108a8a 100644
--- a/include/class/dossier.class.php
+++ b/include/class/dossier.class.php
@@ -281,7 +281,7 @@ class Dossier
static function get_version($p_cn)
{
- return $p_cn->get_value('select val from version');
+ return $p_cn->get_value('select max(val) from version');
}
static function connect()
diff --git a/include/constant.php b/include/constant.php
index 9a3153b..8927f3e 100644
--- a/include/constant.php
+++ b/include/constant.php
@@ -108,7 +108,7 @@ if ( !defined("SITE_UPDATE_PLUGIN"))
if ( ! defined ("SYSINFO_DISPLAY")) {
define ("SYSINFO_DISPLAY",TRUE);
}
-define ("DBVERSION",125);
+define ("DBVERSION",126);
define ("MONO_DATABASE",25);
define ("DBVERSIONREPO",17);
define ('NOTFOUND','--not found--');
diff --git a/include/sql/patch/ac-upgrade17.sql
b/include/sql/patch/ac-upgrade17.sql
new file mode 100644
index 0000000..a012aba
--- /dev/null
+++ b/include/sql/patch/ac-upgrade17.sql
@@ -0,0 +1,16 @@
+begin;
+-- add style
+insert into theme (the_name,the_filestyle) values
('Classic7','style-classic7.css');
+delete from theme where the_filestyle in
('style-mandarine.css','style-mobile.css');
+update user_global_pref set parameter_value='style-classic7.css' ;
+-- add constraint
+alter table jnt_use_dos add CONSTRAINT use_id_dos_id_uniq UNIQUE
(use_id,dos_id);
+-- create table to check progress
+create table progress
+(
+ p_id varchar(16) primary key,
+ p_value numeric (5,2) not null ,
+ p_created timestamp default now()
+);
+select upgrade_repo(18);
+commit;
\ No newline at end of file
diff --git a/include/sql/patch/upgrade125.sql b/include/sql/patch/upgrade125.sql
new file mode 100644
index 0000000..ac8dbf5
--- /dev/null
+++ b/include/sql/patch/upgrade125.sql
@@ -0,0 +1,109 @@
+begin;
+
+set search_path to public,comptaproc;
+
+alter table action_gestion drop ag_ref_ag_id;
+
+create sequence tmp_pcmn_id_seq;
+ALTER TABLE tmp_pcmn ADD COLUMN id bigint;
+update tmp_pcmn set id=nextval('tmp_pcmn_id_seq');
+
+ALTER TABLE tmp_pcmn ALTER COLUMN id SET NOT NULL;
+ALTER TABLE tmp_pcmn ALTER COLUMN id SET DEFAULT
nextval('tmp_pcmn_id_seq'::regclass);
+ALTER TABLE tmp_pcmn ADD CONSTRAINT id_ux UNIQUE(id);
+COMMENT ON COLUMN tmp_pcmn.id IS 'allow to identify the row, it is unique and
not null (pseudo pk)';
+update tmp_pcmn set id=nextval('tmp_pcmn_id_seq');
+
+alter table tmp_pcmn add column pcm_direct_use varchar(1);
+COMMENT ON COLUMN tmp_pcmn.pcm_direct_use IS 'Value are N or Y , N cannot be
used directly , not even through a card';
+ALTER TABLE tmp_pcmn ALTER COLUMN pcm_direct_use SET DEFAULT 'Y';
+update tmp_pcmn set pcm_direct_use='Y';
+update tmp_pcmn set pcm_direct_use='N' where length(pcm_val) < 3 and not
exists (select j_poste from jrnx where j_poste=pcm_val);
+ALTER TABLE tmp_pcmn ALTER COLUMN pcm_direct_use SET NOT NULL;
+alter table tmp_pcmn add constraint pcm_direct_use_ck check (pcm_direct_use in
('Y','N'));
+
+insert into bilan (b_name,b_file_template,b_file_form,b_type) values
('ASBL','document/fr_be/bnb-asbl.rtf','document/fr_be/bnb-asbl.form','RTF');
+
+alter table jnt_letter drop jl_amount_deb;
+
+ALTER TABLE operation_analytique ADD COLUMN f_id bigint;
+ALTER TABLE operation_analytique ADD CONSTRAINT
operation_analytique_fiche_id_fk FOREIGN KEY (f_id) REFERENCES fiche
(f_id) MATCH SIMPLE ON UPDATE cascade ON cascade;
+COMMENT ON COLUMN operation_analytique.f_id IS 'FK to fiche.f_id , used only
with ODS';
+
+drop FUNCTION comptaproc.table_analytic_account(text,text);
+drop FUNCTION comptaproc.table_analytic_card(text,text);
+
+CREATE TABLE public.user_filter (
+ id bigserial,
+ login text NULL,
+ nb_jrn int4 NULL,
+ date_start varchar(10) NULL,
+ date_end varchar(10) NULL,
+ description text NULL,
+ amount_min numeric(20,4) NULL,
+ amount_max numeric(20,4) NULL,
+ qcode text NULL,
+ accounting text NULL,
+ r_jrn text NULL,
+ date_paid_start varchar(10) NULL,
+ date_paid_end varchar(10) NULL,
+ ledger_type varchar(5) NULL,
+ all_ledger int4 NULL,
+ filter_name text NOT NULL,
+ unpaid varchar NULL,
+ PRIMARY KEY (id)
+);
+
+
+
+
+alter table jrn_periode drop constraint jrn_periode_pk;
+create sequence jrn_periode_id_seq;
+alter table jrn_periode add id bigint;
+alter table jrn_periode alter column id set default
nextval('jrn_periode_id_seq');
+update jrn_periode set id=nextval('jrn_periode_id_seq');
+alter table jrn_periode add constraint jrn_periode_pk primary key (id);
+alter table jrn_periode add constraint jrn_periode_periode_ledger unique
(jrn_def_id,p_id);
+
+CREATE TABLE public.user_active_security (
+ id serial not NULL,
+ us_login text NOT NULL,
+ us_ledger varchar(1) not NULL,
+ us_action varchar(1) not NULL
+);
+COMMENT ON COLUMN public.user_active_security.us_login IS 'user''s login' ;
+COMMENT ON COLUMN public.user_active_security.us_ledger IS 'Flag Security for
ledger' ;
+COMMENT ON COLUMN public.user_active_security.us_action IS 'Security for
action' ;
+
+ALTER TABLE public.user_active_security ADD CONSTRAINT user_active_security_pk
PRIMARY KEY (id) ;
+ALTER TABLE public.user_active_security ADD CONSTRAINT
user_active_security_ledger_check CHECK (us_ledger in ('Y','N')) ;
+ALTER TABLE public.user_active_security ADD CONSTRAINT
user_active_security_action_check CHECK (us_action in ('Y','N')) ;
+
+insert into user_active_security (us_login,us_ledger,us_action) select
user_name,'Y','Y' from profile_user;
+
+alter table jrn_def add jrn_enable int;
+alter table jrn_def alter jrn_enable set default 1;
+update jrn_def set jrn_enable=1;
+comment on column jrn_def.jrn_enable is 'Set to 1 if the ledger is enable ';
+
+
+alter table jrn add jr_optype varchar(3);
+alter table jrn alter jr_optype set default 'NOR';
+comment on column jrn.jr_optype is 'Type of operation , NOR = NORMAL , OPE
opening , EXT extourne, CLO closing';
+update jrn set jr_optype='NOR';
+
+-- update quant_sold set qs_vat_sided=round(qs_vat_sided,2);
+-- update quant_purchase set qp_vat_sided=round(qp_vat_sided,2);
+
+alter table tags add column t_actif char(1);
+update tags set t_actif='Y';
+ALTER TABLE tags ADD CONSTRAINT tags_check CHECK (t_actif in ('N','Y')) ;
+alter table tags alter t_actif set default 'Y';
+COMMENT ON COLUMN tags.t_actif is 'Y if the tag is activate and can be used ';
+alter table version add v_description text;
+alter table version add v_date timestamp;
+alter table version alter v_date set default now();
+ alter table version add primary key (val);
+insert into version (val,v_description) values (126,'Add filter for search,
inactive tag or ledger, type of operation, security');
+
+commit;
\ No newline at end of file
- [Noalyss-commit] [noalyss] 129/323: Small bug : new structure for table version, (continued)
- [Noalyss-commit] [noalyss] 129/323: Small bug : new structure for table version, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 126/323: fix : typo default theme Classic7, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 121/323: use icon_action::icon_magnify instead of icon, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 128/323: Improve CSS, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 109/323: update account_repository (to review), Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 131/323: upgrade SQL : syntax on FK, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 127/323: Esthetic, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 130/323: upgrade SQL : issue with trigger on tmp_pcmn, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 132/323: set version, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 133/323: Fix bug for updating, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 123/323: SQL : patch for new version CSS : install new theme,
Dany De Bontridder <=
- [Noalyss-commit] [noalyss] 113/323: indent, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 134/323: Bug : cannot update payment, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 135/323: CSS : cosmetic menu, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 138/323: CSS : reduce height menu, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 137/323: SQL upgrate : problem with sequence bilan, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 136/323: SQL upgrate : drop trigger before update, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 139/323: Bug : ANC ND VAT not computed, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 141/323: Set version, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 144/323: merge rel6919.9, Dany De Bontridder, 2018/03/14
- [Noalyss-commit] [noalyss] 140/323: Bug : ANC ND VAT not computed, Dany De Bontridder, 2018/03/14