[Phpcompta-dev] r5149 - phpcompta/tags/rel650/include

[phpcompta-dev]

Author: danydb
Date: 2012-10-30 22:14:26 +0100 (Tue, 30 Oct 2012)
New Revision: 5149

Modified:
   phpcompta/tags/rel650/include/class_fiche_def.php
Log:
0000755: Erreur en cr?\195?\169ation de fiche avec un compte (455) 
d?\195?\169j?\195?\160 utilis?\195?\169.

Modified: phpcompta/tags/rel650/include/class_fiche_def.php
===================================================================
--- phpcompta/tags/rel650/include/class_fiche_def.php   2012-10-30 19:44:20 UTC 
(rev 5148)
+++ phpcompta/tags/rel650/include/class_fiche_def.php   2012-10-30 21:14:26 UTC 
(rev 5149)
@@ -254,15 +254,13 @@
                 $sql="select account_add($1,$2)";
                 $Res=$this->cn->exec_sql($sql,array($p_class_base,$p_nom_mod));
             }
+                       // Get the fd_id
+                       $fd_id=$this->cn->get_current_seq('s_fdef');
 
-            // Get the fd_id
-            $fd_id=$this->cn->get_current_seq('s_fdef');
-
-            // update jnt_fic_attr
-            $sql=sprintf("insert into jnt_fic_attr(fd_id,ad_id,jnt_order)
-                         values (%d,%d,10)",$fd_id,ATTR_DEF_ACCOUNT);
-            $Res=$this->cn->exec_sql($sql);
-
+                       // update jnt_fic_attr
+                       $sql=sprintf("insert into 
jnt_fic_attr(fd_id,ad_id,jnt_order)
+                                        values 
(%d,%d,10)",$fd_id,ATTR_DEF_ACCOUNT);
+                       $Res=$this->cn->exec_sql($sql);
         }
         else
         {
@@ -291,11 +289,15 @@
                                $order=$jnt_order;
                 if ( $v['ad_id'] == ATTR_DEF_NAME )
                     $order=0;
-                $sql=sprintf("insert into jnt_fic_Attr(fd_id,ad_id,jnt_order)
+                               $count=$this->cn->get_value("select count(*) 
from jnt_fic_attr where fd_id=$1 and ad_id=$2",array($fd_id,$v['ad_id']));
+                               if ($count == 0)
+                               {
+                                       $sql=sprintf("insert into 
jnt_fic_Attr(fd_id,ad_id,jnt_order)
                              values (%d,%s,%d)",
                              $fd_id,$v['ad_id'],$order);
-                $this->cn->exec_sql($sql);
-                               $jnt_order+=10;
+                                       $this->cn->exec_sql($sql);
+                                       $jnt_order+=10;
+                               }
             }
         }
         $this->id=$fd_id;



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