[Phpgroupware-cvs] property/inc class.soXport.inc.php,1.17

[sigurdne]

Update of property/inc

Modified Files:
     Branch: MAIN
            class.soXport.inc.php lines: +8 -28

Log Message:
no message

====================================================
Index: property/inc/class.soXport.inc.php
diff -u property/inc/class.soXport.inc.php:1.16 
property/inc/class.soXport.inc.php:1.17
--- property/inc/class.soXport.inc.php:1.16     Thu May 12 21:26:28 2005
+++ property/inc/class.soXport.inc.php  Wed Sep 14 10:21:49 2005
@@ -485,36 +485,18 @@
                        $sql="INSERT INTO fm_ecoavvik 
(bilagsnr,fakturadato,forfallsdato,oppsynsmannid,oppsynsigndato,saksbehandlerid,saksigndato,budsjettansvarligid,budsjettsigndato,artid,spvend_code,belop,godkjentbelop)
  values "
                        . 
"($bilagsnr','$fakturadato','$forfallsdato','$oppsynsmannid','$oppsynsigndato','$saksbehandlerid','$saksigndato','$budsjettansvarligid','$budsjettsigndato','$artid','$spvend_code','$belop','$godkjentbelop')";
                        $this->db->query($sql,__LINE__,__FILE__);
-               }
+               }

                function delete_avvik($bilagsnr)
-        {
-                       $sql="delete from fm_ecoavvik where 
bilagsnr='$bilagsnr'";
-                       $this->db->query($sql,__LINE__,__FILE__);
-        }
-        function delete_invoice($bilagsnr)
-        {
-                       $sql="delete from fm_ecobilagoverf where 
bilagsnr='$bilagsnr'";
-                       $this->db->query($sql,__LINE__,__FILE__);
-        }
-
-
-               //Hent DIM C
-        function select_dimc($pmwrkord_code)
-        {
-               $sql= "select location_code from fm_workorder $this->join 
fm_project on fm_workorder.project_id=fm_project.id  where 
fm_workorder.id='$pmwrkord_code'";
+               {
+                       $sql="delete from fm_ecoavvik where 
bilagsnr='$bilagsnr'";
                        $this->db->query($sql,__LINE__,__FILE__);
-                       $this->db->next_record();
-                       $location_code = $this->db->f('location_code');
-                       $location               = split("-", $location_code);
-                       $loc1   = $location[0];
-                       $loc4   = $location[3];
+               }

-                       $sql= "select category from fm_location4 where 
fm_location4.loc1='$loc1' and fm_location4.loc4='$loc4'";
+               function delete_invoice($bilagsnr)
+               {
+                       $sql="delete from fm_ecobilagoverf where 
bilagsnr='$bilagsnr'";
                        $this->db->query($sql,__LINE__,__FILE__);
-                       $this->db->next_record();
-                       $dimc = $this->db->f('category');
-                       return $dimc;
                }

                //Logg transaksjon
@@ -527,7 +509,6 @@

                function increment_batchid()
                {
-
                        $this->db->query("update fm_idgenerator  set value = 
value + 1 where name = 'Ecobatchid'");
                        $this->db->query("select value from fm_idgenerator  
where name = 'Ecobatchid'");
                        $this->db->next_record();
@@ -555,6 +536,5 @@
                }

        }
-

 ?>