Author: danydb
Date: 2011-05-23 20:06:18 +0200 (Mon, 23 May 2011)
New Revision: 4119
Modified:
phpcompta/trunk/html/ajax_ledger.php
Log:
0000269: Pas de synchronisation entre date ANC et ACC
Modified: phpcompta/trunk/html/ajax_ledger.php
===================================================================
--- phpcompta/trunk/html/ajax_ledger.php 2011-05-22 21:30:38 UTC (rev
4118)
+++ phpcompta/trunk/html/ajax_ledger.php 2011-05-23 18:06:18 UTC (rev
4119)
@@ -365,6 +365,13 @@
array($_POST['lib'],$_POST['npj'],$jr_id,$_POST['p_date']));
$cn->exec_sql("update jrnx set j_date=to_date($1,'DD.MM.YYYY')
where j_grpt in (select jr_grpt_id from jrn where jr_id=$2)",
array($_POST['p_date'],$jr_id));
+ $cn->exec_sql('update operation_analytique set oa_date=j_date from
jrnx
+ where
+ operation_analytique.j_id=jrnx.j_id and
+ operation_analytique.j_id in (select j_id
+ from jrnx join jrn on
(j_grpt=jr_grpt_id)
+ where jr_id=$1)
+ ',array($jr_id));
$cn->exec_sql("select comptaproc.jrn_add_note($1,$2)",
array($jr_id,$_POST['jrn_note']));
$rapt=$_POST['rapt'];
_______________________________________________
Phpcompta-dev mailing list
[email protected]
https://lists.nongnu.org/mailman/listinfo/phpcompta-dev
