[Phpcompta-dev] r4119 - phpcompta/trunk/html

[phpcompta-dev]

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'];