[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpcompta-dev] r5149 - phpcompta/tags/rel650/include
From: |
phpcompta-dev |
Subject: |
[Phpcompta-dev] r5149 - phpcompta/tags/rel650/include |
Date: |
Tue, 30 Oct 2012 22:14:27 +0100 (CET) |
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
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpcompta-dev] r5149 - phpcompta/tags/rel650/include,
phpcompta-dev <=