[Phpcompta-dev] r518 - tag/rel660/rapport_avance/include

[phpcompta-dev]

Author: danydb
Date: 2013-06-13 16:25:34 +0200 (Thu, 13 Jun 2013)
New Revision: 518

Modified:
   tag/rel660/rapport_avance/include/class_formulaire_param.php
Log:
Bug# 0000857: [Plugin Rapport Avanc?\195?\169 : Export d'un formulaire : la 
restauration ne se fait pas

Modified: tag/rel660/rapport_avance/include/class_formulaire_param.php
===================================================================
--- tag/rel660/rapport_avance/include/class_formulaire_param.php        
2013-06-10 18:13:58 UTC (rev 517)
+++ tag/rel660/rapport_avance/include/class_formulaire_param.php        
2013-06-13 14:25:34 UTC (rev 518)
@@ -150,14 +150,13 @@
                        }
                        /// Update now the table  
rapport_advanced.restore_formulaire_param and set the correct pk
                        $cn->exec_sql("update 
rapport_advanced.restore_formulaire_param set 
p_id=nextval('rapport_advanced.formulaire_param_p_id_seq')");
-                       $cn->exec_sql("update 
rapport_advanced.restore_formulaire_param_detail set 
fp_id=nextval('rapport_advanced.formulaire_param_detail_fp_id_seq')");
 
                        $cn->exec_sql('insert into 
rapport_advanced.formulaire_param select  p_id, p_code, p_libelle, p_type, 
p_order, f_id, t_id
                                from rapport_advanced.restore_formulaire_param 
where f_id=$1',array($form->f_id));
 
-                       $cn->exec_sql('insert into 
rapport_advanced.formulaire_param_detail select fp_id, p_id, tmp_val, tva_id, 
fp_formula, fp_signed, jrn_def_type,
+                       $cn->exec_sql("insert into 
rapport_advanced.formulaire_param_detail select 
nextval('rapport_advanced.formulaire_param_detail_fp_id_seq'), p_id, tmp_val, 
tva_id, fp_formula, fp_signed, jrn_def_type,
             tt_id, type_detail, with_tmp_val, type_sum_account, 
operation_pcm_val from  rapport_advanced.restore_formulaire_param_detail where 
p_id in (
-                       select p_id from 
rapport_advanced.restore_formulaire_param where f_id=$1)',array($form->f_id));
+                       select p_id from 
rapport_advanced.restore_formulaire_param where f_id=$1)",array($form->f_id));
 
                        $cn->exec_sql('delete from  
rapport_advanced.restore_formulaire_param where f_id=$1',array($form->f_id));
                        $cn->commit();



---
PhpCompta est un logiciel de comptabilité libre en ligne (full web)
Projet opensource http://www.phpcompta.eu