[Phpgroupware-cvs] property/inc class.sowo_hour.inc.php,1.4

[sigurdne]

Update of property/inc

Modified Files:
     Branch: MAIN
            class.sowo_hour.inc.php lines: +16 -9

Log Message:
no message

====================================================
Index: property/inc/class.sowo_hour.inc.php
diff -u property/inc/class.sowo_hour.inc.php:1.3 
property/inc/class.sowo_hour.inc.php:1.4
--- property/inc/class.sowo_hour.inc.php:1.3    Thu Jan 13 16:52:48 2005
+++ property/inc/class.sowo_hour.inc.php        Mon Apr 11 11:59:02 2005
@@ -287,13 +287,20 @@

                        $this->db->transaction_begin();

+                       $values_insert= array(
+                               $this->account,
+                               $values['name'],
+                               $values['descr'],
+                               $workorder['chapter_id'],
+                               time()
+                                );
+
+                       $values_insert  = 
$this->bocommon->validate_db_insert($values_insert);
+
                        $this->db->query("insert into fm_template 
(owner,name,descr,chapter_id,entry_date) "
-                               . " values ('" .
-                                       $this->account . "','" .
-                                       $values['name'] . "','" .
-                                       $values['descr'] . "','" .
-                                       $workorder['chapter_id'] . "','" .
-                                       time() . "')",__LINE__,__FILE__);
+                               . " values ($values_insert)",__LINE__,__FILE__);
+
+                       unset ($values_insert);

                        $template_id = 
$this->db->get_last_insert_id('fm_template','id');

@@ -304,7 +311,7 @@
                        for ($i=0; $i<count($hour); $i++)
                        {

-                               $values= array(
+                               $values_insert= array(
                                        $hour[$i]['activity_id'],
                                        $hour[$i]['activity_num'],
                                        $this->account,
@@ -323,11 +330,11 @@
                                        $record,
                                        $template_id );

-                               $values = 
$this->bocommon->validate_db_insert($values);
+                               $values_insert  = 
$this->bocommon->validate_db_insert($values_insert);

                                $this->db->query("insert into fm_template_hours 
(activity_id,activity_num,owner,hours_descr,unit,"
                                . 
"cost,quantity,billperae,ns3420_id,dim_d,grouping_id,grouping_descr,remark,tolerance,building_part,record,template_id)
 "
-                               . " values ($values)",__LINE__,__FILE__);
+                               . " values ($values_insert)",__LINE__,__FILE__);

                                $record++;
                        }