[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Noalyss-commit] [noalyss] 06/11: Bug in QUANT_PURCHASE , dp_dep_priv is
From: |
Dany De Bontridder |
Subject: |
[Noalyss-commit] [noalyss] 06/11: Bug in QUANT_PURCHASE , dp_dep_priv is not saved |
Date: |
Fri, 1 Jun 2018 17:02:49 -0400 (EDT) |
sparkyx pushed a commit to branch master
in repository noalyss.
commit 64749aa738e780adae581ffd3454b655b5281759
Author: Dany De Bontridder <address@hidden>
Date: Sat May 12 12:56:12 2018 +0200
Bug in QUANT_PURCHASE , dp_dep_priv is not saved
Conflicts:
sql/upgrade.sql
---
sql/upgrade.sql | 64 +++++++++++++++++++++++++++++++++++++++++++++++++--------
1 file changed, 55 insertions(+), 9 deletions(-)
diff --git a/sql/upgrade.sql b/sql/upgrade.sql
index f3ed35a..f3340f5 100644
--- a/sql/upgrade.sql
+++ b/sql/upgrade.sql
@@ -1,9 +1,55 @@
-create view v_tva_rate as select
- tva_id,
- tva_rate,
- tva_label,
- tva_comment,
- split_part(tva_poste,',',1) as tva_purchase,
- split_part(tva_poste,',',2) as tva_sale,
- tva_both_side
-from tva_rate;
+CREATE OR REPLACE FUNCTION comptaproc.insert_quant_purchase(p_internal text,
p_j_id numeric, p_fiche character varying, p_quant numeric, p_price numeric,
p_vat numeric, p_vat_code integer, p_nd_amount numeric, p_nd_tva numeric,
p_nd_tva_recup numeric, p_dep_priv numeric, p_client character varying,
p_tva_sided numeric, p_price_unit numeric)
+ RETURNS void
+ LANGUAGE plpgsql
+AS $function$
+declare
+ fid_client integer;
+ fid_good integer;
+ account_priv account_type;
+ fid_good_account account_type;
+ n_dep_priv numeric;
+begin
+ n_dep_priv := p_dep_priv;
+ select p_value into account_priv from parm_code where
p_code='DEP_PRIV';
+ select f_id into fid_client from
+ fiche_detail where ad_id=23 and ad_value=upper(trim(p_client));
+ select f_id into fid_good from
+ fiche_detail where ad_id=23 and ad_value=upper(trim(p_fiche));
+ select ad_value into fid_good_account from fiche_detail where ad_id=5
and f_id=fid_good;
+ if strpos( fid_good_account , account_priv ) = 1 then
+ n_dep_priv=p_price;
+ end if;
+
+ insert into quant_purchase
+ (qp_internal,
+ j_id,
+ qp_fiche,
+ qp_quantite,
+ qp_price,
+ qp_vat,
+ qp_vat_code,
+ qp_nd_amount,
+ qp_nd_tva,
+ qp_nd_tva_recup,
+ qp_supplier,
+ qp_dep_priv,
+ qp_vat_sided,
+ qp_unit)
+ values
+ (p_internal,
+ p_j_id,
+ fid_good,
+ p_quant,
+ p_price,
+ p_vat,
+ p_vat_code,
+ p_nd_amount,
+ p_nd_tva,
+ p_nd_tva_recup,
+ fid_client,
+ n_dep_priv,
+ p_tva_sided,
+ p_price_unit);
+ return;
+end;
+ $function$
\ No newline at end of file
- [Noalyss-commit] [noalyss] branch master updated (490aeb1 -> ecc3b53), Dany De Bontridder, 2018/06/01
- [Noalyss-commit] [noalyss] 01/11: Missing class : missing class for acc_ledger, Dany De Bontridder, 2018/06/01
- [Noalyss-commit] [noalyss] 05/11: Display the balance difference, Dany De Bontridder, 2018/06/01
- [Noalyss-commit] [noalyss] 08/11: Add upgrade128.sql, Dany De Bontridder, 2018/06/01
- [Noalyss-commit] [noalyss] 04/11: Action_Code : add validate, cancel and modify icon, Dany De Bontridder, 2018/06/01
- [Noalyss-commit] [noalyss] 02/11: Bug 1600 : alphanumeric accounting must be case insensitive, Dany De Bontridder, 2018/06/01
- [Noalyss-commit] [noalyss] 03/11: html_page_start : protect query, improve code, Dany De Bontridder, 2018/06/01
- [Noalyss-commit] [noalyss] 06/11: Bug in QUANT_PURCHASE , dp_dep_priv is not saved,
Dany De Bontridder <=
- [Noalyss-commit] [noalyss] 07/11: integrate fix for bug in insert_quant_purchase which cannot save private fee Conflicts: include/sql/patch/upgrade128.sql, Dany De Bontridder, 2018/06/01
- [Noalyss-commit] [noalyss] 10/11: Security : direct injection, Dany De Bontridder, 2018/06/01
- [Noalyss-commit] [noalyss] 09/11: Upgrade 128.sql, Dany De Bontridder, 2018/06/01
- [Noalyss-commit] [noalyss] 11/11: Fix : security fixes see rapport exakat (Damien Seguy), Dany De Bontridder, 2018/06/01