[Phpcompta-dev] r461 - in trunk/import_account: . include

[phpcompta-dev]

Author: danydb
Date: 2013-01-15 21:18:16 +0100 (Tue, 15 Jan 2013)
New Revision: 461

Modified:
   trunk/import_account/include/class_impacc_operation.php
   trunk/import_account/include/imd_parameter.inc.php
   trunk/import_account/index.php
Log:
Fix bug 

Modified: trunk/import_account/include/class_impacc_operation.php
===================================================================
--- trunk/import_account/include/class_impacc_operation.php     2013-01-06 
00:50:09 UTC (rev 460)
+++ trunk/import_account/include/class_impacc_operation.php     2013-01-15 
20:18:16 UTC (rev 461)
@@ -215,7 +215,7 @@
                        /*
                         *  If a part is N then the whole operation is N
                         */
-                       $sql = "update impadd.operation_tmp  set o_result='N' 
where i_id=$1 and
+                       $sql = "update impacc.operation_tmp  set o_result='N' 
where i_id=$1 and
                                o_doli in (select o_doli from 
impacc.operation_tmp  where o_result='N' and i_id=$1)";
                        $cn->exec_sql($sql, array($this->impid));
                        $cn->commit();

Modified: trunk/import_account/include/imd_parameter.inc.php
===================================================================
--- trunk/import_account/include/imd_parameter.inc.php  2013-01-06 00:50:09 UTC 
(rev 460)
+++ trunk/import_account/include/imd_parameter.inc.php  2013-01-15 20:18:16 UTC 
(rev 461)
@@ -39,7 +39,7 @@
                $tva = new Acc_Tva($cn, $tva_id);
                if ($tva->load() == -1)
                        throw new Exception('Cette tva est invalide');
-               $sql = "insert into impdol.parameter_tva(tva_id,pt_rate) values 
($1,$2)";
+               $sql = "insert into impacc.parameter_tva(tva_id,pt_rate) values 
($1,$2)";
                $cn->exec_sql($sql, array($_POST['tva_id'], $_POST['pt_rate']));
        }
        catch (Exception $e)
@@ -50,7 +50,7 @@
 if (isset($_POST['mod']))
 {
        extract ($_POST);
-       $aparm = $cn->get_array("select pt_id from impdol.parameter_tva");
+       $aparm = $cn->get_array("select pt_id from impacc.parameter_tva");
        try
        {
                for ($i = 0; $i < count($aparm); $i++)
@@ -66,7 +66,7 @@
                                $tva = new Acc_Tva($cn, $tva_id);
                                if ($tva->load() == -1)
                                        throw new Exception('Cette tva est 
invalide');
-                               $sql = "update impdol.parameter_tva set tva_id 
= $1, pt_rate = $2 where pt_id=$3";
+                               $sql = "update impacc.parameter_tva set tva_id 
= $1, pt_rate = $2 where pt_id=$3";
                                $cn->exec_sql($sql, array($tva_id, 
$pt_rate,$aparm[$i]['pt_id']));
                        }
                }
@@ -79,7 +79,7 @@
 /**
  * get data from database
  */
-$atva = $cn->get_array("select * from impdol.parameter_tva order by pt_rate");
+$atva = $cn->get_array("select * from impacc.parameter_tva order by pt_rate");
 require 'template/parameter_tva_add.php';
 echo '<form method="POST">';
 require 'template/parameter.php';

Modified: trunk/import_account/index.php
===================================================================
--- trunk/import_account/index.php      2013-01-06 00:50:09 UTC (rev 460)
+++ trunk/import_account/index.php      2013-01-15 20:18:16 UTC (rev 461)
@@ -79,7 +79,7 @@
   {
     require_once('include/class_install_impacc.php');
 
-    $iplugn=new Install_Impdol();
+    $iplugn=new Install_ImpAcc();
     $iplugn->install($cn);
 
   }



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