[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Noalyss-commit] [noalyss] 39/238: integrate fix for bug in insert_quant
From: |
Dany De Bontridder |
Subject: |
[Noalyss-commit] [noalyss] 39/238: integrate fix for bug in insert_quant_purchase which cannot save private fee |
Date: |
Sat, 26 Oct 2019 04:40:26 -0400 (EDT) |
sparkyx pushed a commit to annotated tag rel7110
in repository noalyss.
commit fe27cad77b5e71953c8a698c459ed0ea328cd4c0
Author: Dany De Bontridder <address@hidden>
Date: Sat May 12 13:55:09 2018 +0200
integrate fix for bug in insert_quant_purchase which cannot save private
fee
---
include/sql/patch/upgrade128.sql | 55 ++++++++++++++++++++++++++++++++++++++++
1 file changed, 55 insertions(+)
diff --git a/include/sql/patch/upgrade128.sql b/include/sql/patch/upgrade128.sql
index 8a1bf87..b219fed 100644
--- a/include/sql/patch/upgrade128.sql
+++ b/include/sql/patch/upgrade128.sql
@@ -101,6 +101,61 @@ alter table jrn add currency_rate_ref numeric(20,6)
default 1;
update jrn set currency_rate_ref=1;
ALTER TABLE public.jrn ADD CONSTRAINT jrn_currency_fk FOREIGN KEY
(currency_id) REFERENCES public.currency(id) ON DELETE RESTRICT ON UPDATE
RESTRICT;
+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
+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$
+LANGUAGE plpgsql;
insert into version (val,v_description) values (129,'Currency : create view ,
create tables ');
commit;
\ No newline at end of file
- [Noalyss-commit] [noalyss] 06/238: Currency : add ajax call to delete one rate , add documentation , remove debug info, (continued)
- [Noalyss-commit] [noalyss] 06/238: Currency : add ajax call to delete one rate , add documentation , remove debug info, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 31/238: task #448 : currency always used and remove parameter 'use_currency' from parameters, add SQL script, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 32/238: Task #448 : SQL integrated into upgrade128, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 28/238: Task #448 : currency , EUR cannot be changed and not display, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 33/238: Task #448 : correct bug if VAT Rate = 0 , amount was reset, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 25/238: Task #448 : payment method VEN, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 30/238: remove debug info, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 16/238: Currency : insert operation with currency in VEN and ACH, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 38/238: Task #448 : currency improve detail of operation, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 42/238: remove debug, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 39/238: integrate fix for bug in insert_quant_purchase which cannot save private fee,
Dany De Bontridder <=
- [Noalyss-commit] [noalyss] 35/238: Task #448 : correct bug when saving into quant_purchase, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 36/238: Bug in QUANT_PURCHASE , dp_dep_priv is not saved, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 43/238: Missing ob_start, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 41/238: Fix bug quant_purchase , private fee not saved, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 44/238: Task #448 : add info about currency into History of cards and accounting, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 46/238: Merge branch 'r700-currency' of ssh://ns3git/srv/git/noalyss into r700-currency, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 50/238: Protect function nb , return the string if the parameter is not a float, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 53/238: Missing class : missing class for acc_ledger, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 51/238: New version of libreoffice use the numeric in another way, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 45/238: Fix todo_list : if list empty , gets an error in php 7.2, Dany De Bontridder, 2019/10/26