[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Noalyss-commit] [noalyss] 42/173: Currency - fix view
From: |
Dany De Bontridder |
Subject: |
[Noalyss-commit] [noalyss] 42/173: Currency - fix view |
Date: |
Mon, 22 Mar 2021 12:58:35 -0400 (EDT) |
sparkyx pushed a commit to branch master
in repository noalyss.
commit 588442f9336997e9ff61f0dca9394c5fb7c146e1
Author: Dany De Bontridder <danydb@noalyss.eu>
AuthorDate: Sat Jan 12 13:44:37 2019 +0100
Currency - fix view
---
include/sql/patch/upgrade131.sql | 4 +++-
sql/upgrade.sql | 13 +++++++++++++
2 files changed, 16 insertions(+), 1 deletion(-)
diff --git a/include/sql/patch/upgrade131.sql b/include/sql/patch/upgrade131.sql
index 17dd1c8..9a004b5 100644
--- a/include/sql/patch/upgrade131.sql
+++ b/include/sql/patch/upgrade131.sql
@@ -1,6 +1,6 @@
begin;
-drop VIEW public.v_detail_sale;
+drop VIEW if exists public.v_detail_sale;
CREATE OR REPLACE VIEW public.v_detail_sale as
WITH m AS (
@@ -145,6 +145,8 @@ join operation_currency as oc on (oc.j_id=q1.j_id)
group by x.j_poste,x.j_id
;
+drop view if exists v_all_card_currency;
+
create or replace view v_all_card_currency as
select sum(oc_amount) as sum_oc_amount,sum(oc_vat_amount) as
sum_oc_vat_amount,x.f_id,x.j_id
from
diff --git a/sql/upgrade.sql b/sql/upgrade.sql
index e69de29..e8af5a3 100644
--- a/sql/upgrade.sql
+++ b/sql/upgrade.sql
@@ -0,0 +1,13 @@
+begin;
+insert into "parameter" (pr_id ) values ('MY_DEFAULT_ROUND_ERROR_DEB');
+insert into "parameter" (pr_id ) values ('MY_DEFAULT_ROUND_ERROR_CRED');
+drop view if exists v_all_card_currency;
+
+create or replace view v_all_card_currency as
+select sum(oc_amount) as sum_oc_amount,sum(oc_vat_amount) as
sum_oc_vat_amount,f_id,j_id
+from
+operation_currency
+join jrnx using (j_id)
+group by f_id,j_id;
+
+commit ;
\ No newline at end of file
- [Noalyss-commit] [noalyss] 31/173: Task #1660 : place the button for the inventory on the top, (continued)
- [Noalyss-commit] [noalyss] 31/173: Task #1660 : place the button for the inventory on the top, Dany De Bontridder, 2021/03/22
- [Noalyss-commit] [noalyss] 32/173: New function findSide return D if number is <0, Dany De Bontridder, 2021/03/22
- [Noalyss-commit] [noalyss] 35/173: Task #0001309: Association d'une opération avec elle-même., Dany De Bontridder, 2021/03/22
- [Noalyss-commit] [noalyss] 36/173: Merge branch 'r700-currency' of gitlab.noalyss.eu:noalyss/noalyss into r700-currency, Dany De Bontridder, 2021/03/22
- [Noalyss-commit] [noalyss] 41/173: PHP 7.2 incomptability : sizeof of not array, Dany De Bontridder, 2021/03/22
- [Noalyss-commit] [noalyss] 45/173: Database upgrade, Dany De Bontridder, 2021/03/22
- [Noalyss-commit] [noalyss] 53/173: Mantis #0001682: CA - ajouter possibilité d'exporter le plan analytique, missing file, Dany De Bontridder, 2021/03/22
- [Noalyss-commit] [noalyss] 56/173: Mantis #1626: AFFICHAGE BALANCE FICHE - soldes nuls au débit, Dany De Bontridder, 2021/03/22
- [Noalyss-commit] [noalyss] 58/173: Mantis #1665: Pouvoir modifier l'ordre dans les listing de compta analytique, Dany De Bontridder, 2021/03/22
- [Noalyss-commit] [noalyss] 59/173: Mantis #1596: Dans le plan comptable, fiches non cliquables Les fiches sont cliquable dans Plan Comptable , PCMNCFG et dans la liste des postes, en plus on peut obtenir toutes les fiches d'un poste, Dany De Bontridder, 2021/03/22
- [Noalyss-commit] [noalyss] 42/173: Currency - fix view,
Dany De Bontridder <=
- [Noalyss-commit] [noalyss] 52/173: Mantis #0001682: CA - ajouter possibilité d'exporter le plan analytique, add action CSV:Analytic_Axis, Dany De Bontridder, 2021/03/22
- [Noalyss-commit] [noalyss] 67/173: Wrong merge broke fiche.class.php, Dany De Bontridder, 2021/03/22
- [Noalyss-commit] [noalyss] 64/173: CSS : cosmetic, Dany De Bontridder, 2021/03/22
- [Noalyss-commit] [noalyss] 68/173: Fix broken merge, Dany De Bontridder, 2021/03/22
- [Noalyss-commit] [noalyss] 71/173: Cosmetic adapt color, Dany De Bontridder, 2021/03/22
- [Noalyss-commit] [noalyss] 74/173: TEST : fix some little bugs, Dany De Bontridder, 2021/03/22
- [Noalyss-commit] [noalyss] 75/173: mantis #1690: Bug : impossible d'utiliser < dans Inplace_Edit Replace strip_tags , add a space before the "<", Dany De Bontridder, 2021/03/22
- [Noalyss-commit] [noalyss] 21/173: Currency : for misc. operation, Dany De Bontridder, 2021/03/22
- [Noalyss-commit] [noalyss] 76/173: Mantis #1693: CA - problème avec la balance croisée double, Dany De Bontridder, 2021/03/22
- [Noalyss-commit] [noalyss] 79/173: Merge with dev7109, Dany De Bontridder, 2021/03/22