[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpcompta-dev] r5347 - phpcompta/trunk/sql
From: |
phpcompta-dev |
Subject: |
[Phpcompta-dev] r5347 - phpcompta/trunk/sql |
Date: |
Tue, 13 Aug 2013 04:00:30 +0200 (CEST) |
Author: danydb
Date: 2013-08-13 04:00:29 +0200 (Tue, 13 Aug 2013)
New Revision: 5347
Modified:
phpcompta/trunk/sql/upgrade.sql
Log:
Bug #0000873: Si achat utilisant le poste comptable dans DEP_PRIV alors le
mettre en d?\195?\169pense privee
Modified: phpcompta/trunk/sql/upgrade.sql
===================================================================
--- phpcompta/trunk/sql/upgrade.sql 2013-08-13 01:34:46 UTC (rev 5346)
+++ phpcompta/trunk/sql/upgrade.sql 2013-08-13 02:00:29 UTC (rev 5347)
@@ -22,10 +22,10 @@
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 account_priv = fid_good_account then
+ if strpos( fid_good_account , account_priv ) = 1 then
p_dep_priv=p_price;
end if;
-
+
insert into quant_purchase
(qp_internal,
j_id,
@@ -59,6 +59,7 @@
$BODY$
LANGUAGE plpgsql;
+-- ajout code manquant dans parm_code
create or replace function add_parm_code() returns void as
$fct$
declare
@@ -75,3 +76,10 @@
end;
$fct$
language plpgsql;
+
+select add_parm_code();
+
+drop function add_parm_code();
+
+update parm_code set p_value='67' where p_value='6740' and p_code='DNA';
+
---
PhpCompta est un logiciel de comptabilité libre en ligne (full web)
Projet opensource http://www.phpcompta.eu
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpcompta-dev] r5347 - phpcompta/trunk/sql,
phpcompta-dev <=