[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Noalyss-commit] [noalyss] 196/219: Task #001381 : favori de filtre , ta
From: |
Dany De Bontridder |
Subject: |
[Noalyss-commit] [noalyss] 196/219: Task #001381 : favori de filtre , table pour sauvegarder |
Date: |
Mon, 18 Dec 2017 13:23:02 -0500 (EST) |
sparkyx pushed a commit to branch master
in repository noalyss.
commit b43e6400f9fb2f5478be4c3e82f96c4ca932513b
Author: Dany De Bontridder <address@hidden>
Date: Sun Dec 10 14:21:47 2017 +0100
Task #001381 : favori de filtre , table pour sauvegarder
---
sql/upgrade.sql | 23 ++++++++++++++++++++++-
1 file changed, 22 insertions(+), 1 deletion(-)
diff --git a/sql/upgrade.sql b/sql/upgrade.sql
index f606086..879e934 100644
--- a/sql/upgrade.sql
+++ b/sql/upgrade.sql
@@ -35,4 +35,25 @@ ALTER TABLE operation_analytique ADD CONSTRAINT
operation_analytique_fiche_id_f
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);
\ No newline at end of file
+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)
+);
- [Noalyss-commit] [noalyss] 46/219: Manage_Table : Improve Javascript for adding / removing row of table, (continued)
- [Noalyss-commit] [noalyss] 46/219: Manage_Table : Improve Javascript for adding / removing row of table, Dany De Bontridder, 2017/12/18
- [Noalyss-commit] [noalyss] 27/219: Task #0001443: opérations rapprochées : bug quand on utilise des tva avec autoliquidation Check with the view v_quant_detail and take into account the negative VAT, Dany De Bontridder, 2017/12/18
- [Noalyss-commit] [noalyss] 33/219: Task #0001324: Afficher la date (période) dans FSALDO, Dany De Bontridder, 2017/12/18
- [Noalyss-commit] [noalyss] 198/219: Task #001381 : reinitialize the search_form, Dany De Bontridder, 2017/12/18
- [Noalyss-commit] [noalyss] 154/219: Task #1440 CA - opération diverses inaccessibles Task #1370 les OD en comptabilité analytique - problème., Dany De Bontridder, 2017/12/18
- [Noalyss-commit] [noalyss] 209/219: Merge branch 'master' of ns3:/srv/git/noalyss, Dany De Bontridder, 2017/12/18
- [Noalyss-commit] [noalyss] 186/219: Protect queryString with encodeURI, Dany De Bontridder, 2017/12/18
- [Noalyss-commit] [noalyss] 207/219: Task #1381 Change esthetic Search Filter, Dany De Bontridder, 2017/12/18
- [Noalyss-commit] [noalyss] 208/219: Fix search for reconcile, Dany De Bontridder, 2017/12/18
- [Noalyss-commit] [noalyss] 157/219: Fix issue with open_basedir, sometime set in the server config, Dany De Bontridder, 2017/12/18
- [Noalyss-commit] [noalyss] 196/219: Task #001381 : favori de filtre , table pour sauvegarder,
Dany De Bontridder <=
- [Noalyss-commit] [noalyss] 109/219: Add button to pin the box, Dany De Bontridder, 2017/12/18
- [Noalyss-commit] [noalyss] 134/219: #0001414: LETTRAGE - montants différents non indiqués Apparation d'une bulle d'info avec la différence, Dany De Bontridder, 2017/12/18
- [Noalyss-commit] [noalyss] 147/219: ANC : ANC_TABLE replace PGPLSQL procedure by Php functions : Anc_Table:create_temp_account Anc_Table:create_temp_card, Dany De Bontridder, 2017/12/18
- [Noalyss-commit] [noalyss] 20/219: Add new theme and modify tmp_pcmn, Dany De Bontridder, 2017/12/18
- [Noalyss-commit] [noalyss] 180/219: Fix ID problem, Dany De Bontridder, 2017/12/18
- [Noalyss-commit] [noalyss] 89/219: Cosmetic : cache certaines colonnes pour petit écran, Dany De Bontridder, 2017/12/18
- [Noalyss-commit] [noalyss] 22/219: Esthetic change icon edit, Dany De Bontridder, 2017/12/18
- [Noalyss-commit] [noalyss] 165/219: Task #1476 : add an new column to TMP_PCMN Adapt the add and update for CFGPCMN Code cleaning : rewrite of Acc_Account + PhpUnit test, Dany De Bontridder, 2017/12/18
- [Noalyss-commit] [noalyss] 177/219: Repository add unique constraint for jnt_use_doc, Dany De Bontridder, 2017/12/18
- [Noalyss-commit] [noalyss] 159/219: INSTALL : check PHP version minimum 5.5, Dany De Bontridder, 2017/12/18