[Phpgroupware-cvs] property/inc/class.sotenant.inc.php, 1.1.1.3

[nomail]

Update of /property/inc
Modified Files:
        Branch: 
          class.sotenant.inc.php

date: 2004/05/18 17:53:52;  author: sigurdne;  state: Exp;  lines: +10 -10

Log Message:
no message
=====================================================================
Index: property/inc/class.sotenant.inc.php
diff -u property/inc/class.sotenant.inc.php:1.1.1.2 
property/inc/class.sotenant.inc.php:1.1.1.3
--- property/inc/class.sotenant.inc.php:1.1.1.2 Tue May 18 13:45:24 2004
+++ property/inc/class.sotenant.inc.php Tue May 18 17:53:52 2004
@@ -71,15 +71,15 @@
                        {
                                $cols = $entity_table . 
'.*,fm_tenant_category.descr as category';
 
-                               $cols_return[]                          = 
'tenant_id';
+                               $cols_return[]                          = 'id';
                                $uicols['input_type'][]         = 'text';
-                               $uicols['name'][]                       = 
'tenant_id';
+                               $uicols['name'][]                       = 'id';
                                $uicols['descr'][]                      = 
lang('ID');
                                $uicols['statustext'][]         = lang('ID');
 
-                               $cols_return[]                          = 
'tenant_id';
+                               $cols_return[]                          = 'id';
                                $uicols['input_type'][]         = 'hidden';
-                               $uicols['name'][]                       = 
'tenant_id';
+                               $uicols['name'][]                       = 'id';
                                $uicols['descr'][]                      = false;
                                $uicols['statustext'][]         = false;
 
@@ -162,7 +162,7 @@
                        }
                        else
                        {
-                               $ordermethod = ' order by tenant_id DESC';
+                               $ordermethod = " order by $entity_table.id 
DESC";
                        }
 
                        $where= 'WHERE';
@@ -314,7 +314,7 @@
 
                        if($tenant_id)
                        {
-                               $this->db->query("SELECT * from fm_tenant where 
tenant_id='$tenant_id'");
+                               $this->db->query("SELECT * from fm_tenant where 
id='$tenant_id'");
 
                                if($this->db->next_record())
                                {
@@ -374,8 +374,8 @@
                        $this->db->query("INSERT INTO fm_tenant 
(entry_date,last_name,first_name,contact_phone,category $cols) "
                                . "VALUES ('" . time() . "','" . 
$tenant['last_name'] . "','" . $tenant['first_name'] . "','" . 
$tenant['contact_phone'] . "','" . $tenant['cat_id'] . "' $vals)");
 
-                       $receipt['tenant_id']= 
$this->db->get_last_insert_id('fm_tenant','tenant_id');
-                       $receipt['tenant_id']= $tenant_id;
+                       $receipt['tenant_id']= 
$this->db->get_last_insert_id('fm_tenant','id');
+
                        $receipt['message'][] = array('msg'=>lang('tenant %1 
has been saved',$receipt['tenant_id']));
 
                        $this->db->transaction_commit();
@@ -411,7 +411,7 @@
                        }
 
                        $this->db->query("UPDATE fm_tenant set last_name='" . 
$tenant['last_name'] . "', first_name='" . $tenant['first_name'] . "', 
contact_phone='" . $tenant['contact_phone'] . "', entry_date='" . time() . "', 
category='"
-                                                       . $tenant['cat_id'] . 
"' $value_set WHERE tenant_id=" . intval($tenant['tenant_id']));
+                                                       . $tenant['cat_id'] . 
"' $value_set WHERE id=" . intval($tenant['tenant_id']));
 
                        $receipt['tenant_id']= $tenant['tenant_id'];
                        $receipt['message'][] = array('msg'=>lang('tenant %1 
has been edited',$tenant['tenant_id']));
@@ -420,7 +420,7 @@
 
                function delete($tenant_id)
                {
-                       $this->db->query('DELETE FROM fm_tenant WHERE 
tenant_id=' . intval($tenant_id));
+                       $this->db->query('DELETE FROM fm_tenant WHERE id=' . 
intval($tenant_id));
                }
 
                function read_attrib($data)