[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] property/class.socategory.php, 1.1.1.3
From: |
nomail |
Subject: |
[Phpgroupware-cvs] property/class.socategory.php, 1.1.1.3 |
Date: |
Fri, 21 May 2004 19:26:50 -0000 |
Update of /property
Modified Files:
Branch:
class.socategory.php
date: 2004/04/23 21:26:33; author: sigurdne; state: Exp; lines: +210 -210
Log Message:
no message
=====================================================================
Index: property/class.socategory.php
diff -u property/class.socategory.php:1.1.1.2
property/class.socategory.php:1.1.1.3
--- property/class.socategory.php:1.1.1.2 Fri Apr 23 20:25:40 2004
+++ property/class.socategory.php Fri Apr 23 21:26:33 2004
@@ -1,210 +1,210 @@
-<?php
-
/**************************************************************************\
- * phpGroupWare - property
*
- * http://www.phpgroupware.org
*
- *
*
- * Facilities Management
*
- * Written by Sigurd Nes [sigurdne at online.no]
*
- *
------------------------------------------------------------------------ *
- * Copyright 2000 - 2003 Free Software Foundation, Inc
*
- * This program is part of the GNU project, see http://www.gnu.org/
*
- *
------------------------------------------------------------------------ *
- * This program is free software; you can redistribute it and/or modify
it *
- * under the terms of the GNU General Public License as published by the
*
- * Free Software Foundation; either version 2 of the License, or (at
your *
- * option) any later version.
*
-
\**************************************************************************/
-
- class property_socategory
- {
-
- function property_socategory()
- {
- $this->currentapp = 'property';
//$GLOBALS['phpgw_info']['flags']['currentapp'];
- $this->db = $GLOBALS['phpgw']->db;
- $this->db2 = $this->db;
- $this->account = $GLOBALS['phpgw_data']['user']['id'];
- $this->socommon =
CreateObject($this->currentapp.'_socommon');
-
- $this->join = $this->socommon->join;
-
- }
-
- function read($data)
- {
- if(is_array($data))
- {
- if ($data['start'])
- {
- $start=$data['start'];
- }
- else
- {
- $start=0;
- }
- $query =
(isset($data['query'])?$data['query']:'');
- $sort =
(isset($data['sort'])?$data['sort']:'DESC');
- $order =
(isset($data['order'])?$data['order']:'');
- $type =
(isset($data['type'])?$data['type']:'');
- $type_id =
(isset($data['type_id'])?$data['type_id']:'');
- $allrows =
(isset($data['allrows'])?$data['allrows']:'');
- }
-
- if(!$type)
- {
- return;
- }
- if ($order)
- {
- $ordermethod = " order by $order $sort";
-
- }
- else
- {
- $ordermethod = ' order by id asc';
- }
-
- $table = $this->select_table($type,$type_id);
-
- if($query)
- {
- $query = ereg_replace("'",'',$query);
- $query = ereg_replace('"','',$query);
-
- $querymethod = " where id LIKE '%$query%' or
descr LIKE '%$query%'";
- }
-
- $sql = "SELECT * FROM $table $querymethod";
-
- $dbresult2 = $GLOBALS['phpgw']->db->Execute($sql);
- $this->total_records = $dbresult2->_numOfRows;
-
- $maxmatchs = 15;
-
- if(!$allrows)
- {
- $dbresult =
$GLOBALS['phpgw']->db->SelectLimit($sql . $ordermethod,$maxmatchs,$start);
-
- }
- else
- {
- $dbresult = $GLOBALS['phpgw']->db->Execute($sql
. $ordermethod);
- }
-
- while (!$dbresult->EOF)
- {
- $category[] = array
- (
- 'id' => $dbresult->fields['id'],
- 'descr' =>
$dbresult->fields['descr']
- );
- $dbresult->MoveNext();
- }
- return $category;
- }
-
-
- function select_table($type,$type_id)
- {
-
- switch($type)
- {
- case 'dim_d':
- $table='fm_dim_d';
- break;
- case 'tender_chapter':
- $table='fm_chapter';
- break;
- case 'ticket':
- $table='fm_tts_category';
- break;
- case 'request':
- $table='fm_request_category';
- break;
- case 'wo':
- $table='fm_workorder_category';
- break;
- case 'location':
- $table='fm_location' . $type_id .
'_category';
- break;
- case 'drawing':
- $table='fm_drawing_category';
- break;
- case 'meter':
- $table='fm_meter_category';
- break;
- case 'document':
- $table='fm_document_category';
- break;
- case 'owner':
- $table='fm_owner_category';
- break;
- case 'tenant':
- $table='fm_tenant_category';
- break;
- case 'district':
- $table='fm_district';
- break;
- case 'street':
- $table='fm_streetaddress';
- break;
- }
-
- return $table;
- }
-
-
- function read_single($id,$type,$type_id)
- {
-
- $table = $this->select_table($type,$type_id);
-
- $sql = "SELECT * FROM $table where id='$id'";
-
- $dbresult = $GLOBALS['phpgw']->db->Execute($sql);
-
- if (!$dbresult->EOF)
- {
- $category['id'] =
$dbresult->fields['id'];
- $category['descr']
= $dbresult->fields['descr'];
-
- return $category;
- }
- }
-
- function add($category,$type,$type_id)
- {
- $table = $this->select_table($type,$type_id);
-
- $category['descr'] =
$this->db->db_addslashes($category['descr']);
-
- $GLOBALS['phpgw']->db->Execute("INSERT INTO $table (id,
descr) "
- . "VALUES ('" . $category['id'] . "','" .
$category['descr']. "')");
-
- $receipt['message'][]=array('msg'=>lang('category has
been saved'));
- return $receipt;
- }
-
- function edit($category,$type,$type_id)
- {
-
- $table = $this->select_table($type,$type_id);
-
- $category['descr'] =
$this->db->db_addslashes($category['descr']);
-
- $GLOBALS['phpgw']->db->Execute("UPDATE $table set
descr='" . $category['descr']
- . "' WHERE id='" .
$category['id']. "'");
-
-
- $receipt['message'][]=array('msg'=>lang('category has
been edited'));
- return $receipt;
- }
-
- function delete($id,$type,$type_id)
- {
- $table = $this->select_table($type,$type_id);
-
- $GLOBALS['phpgw']->db->Execute("DELETE FROM $table
WHERE id='" . $id . "'");
- }
- }
-?>
+<?php
+
/**************************************************************************\
+ * phpGroupWare - property
*
+ * http://www.phpgroupware.org
*
+ *
*
+ * Facilities Management
*
+ * Written by Sigurd Nes [sigurdne at online.no]
*
+ *
------------------------------------------------------------------------ *
+ * Copyright 2000 - 2003 Free Software Foundation, Inc
*
+ * This program is part of the GNU project, see http://www.gnu.org/
*
+ *
------------------------------------------------------------------------ *
+ * This program is free software; you can redistribute it and/or modify
it *
+ * under the terms of the GNU General Public License as published by the
*
+ * Free Software Foundation; either version 2 of the License, or (at
your *
+ * option) any later version.
*
+
\**************************************************************************/
+
+ class property_socategory
+ {
+
+ function property_socategory()
+ {
+ $this->currentapp = 'property';
//$GLOBALS['phpgw_info']['flags']['currentapp'];
+ $this->db = $GLOBALS['phpgw']->db;
+ $this->db2 = $this->db;
+ $this->account = $GLOBALS['phpgw_data']['user']['id'];
+ $this->socommon =
CreateObject($this->currentapp.'_socommon');
+
+ $this->join = $this->socommon->join;
+
+ }
+
+ function read($data)
+ {
+ if(is_array($data))
+ {
+ if ($data['start'])
+ {
+ $start=$data['start'];
+ }
+ else
+ {
+ $start=0;
+ }
+ $query =
(isset($data['query'])?$data['query']:'');
+ $sort =
(isset($data['sort'])?$data['sort']:'DESC');
+ $order =
(isset($data['order'])?$data['order']:'');
+ $type =
(isset($data['type'])?$data['type']:'');
+ $type_id =
(isset($data['type_id'])?$data['type_id']:'');
+ $allrows =
(isset($data['allrows'])?$data['allrows']:'');
+ }
+
+ if(!$type)
+ {
+ return;
+ }
+ if ($order)
+ {
+ $ordermethod = " order by $order $sort";
+
+ }
+ else
+ {
+ $ordermethod = ' order by id asc';
+ }
+
+ $table = $this->select_table($type,$type_id);
+
+ if($query)
+ {
+ $query = ereg_replace("'",'',$query);
+ $query = ereg_replace('"','',$query);
+
+ $querymethod = " where id LIKE '%$query%' or
descr LIKE '%$query%'";
+ }
+
+ $sql = "SELECT * FROM $table $querymethod";
+
+ $dbresult2 = $GLOBALS['phpgw']->db->Execute($sql);
+ $this->total_records = $dbresult2->_numOfRows;
+
+ $maxmatchs = 15;
+
+ if(!$allrows)
+ {
+ $dbresult =
$GLOBALS['phpgw']->db->SelectLimit($sql . $ordermethod,$maxmatchs,$start);
+
+ }
+ else
+ {
+ $dbresult = $GLOBALS['phpgw']->db->Execute($sql
. $ordermethod);
+ }
+
+ while (!$dbresult->EOF)
+ {
+ $category[] = array
+ (
+ 'id' => $dbresult->fields['id'],
+ 'descr' =>
$dbresult->fields['descr']
+ );
+ $dbresult->MoveNext();
+ }
+ return $category;
+ }
+
+
+ function select_table($type,$type_id)
+ {
+
+ switch($type)
+ {
+ case 'dim_d':
+ $table='fm_dim_d';
+ break;
+ case 'tender_chapter':
+ $table='fm_chapter';
+ break;
+ case 'ticket':
+ $table='fm_tts_category';
+ break;
+ case 'request':
+ $table='fm_request_category';
+ break;
+ case 'wo':
+ $table='fm_workorder_category';
+ break;
+ case 'location':
+ $table='fm_location' . $type_id .
'_category';
+ break;
+ case 'drawing':
+ $table='fm_drawing_category';
+ break;
+ case 'meter':
+ $table='fm_meter_category';
+ break;
+ case 'document':
+ $table='fm_document_category';
+ break;
+ case 'owner':
+ $table='fm_owner_category';
+ break;
+ case 'tenant':
+ $table='fm_tenant_category';
+ break;
+ case 'district':
+ $table='fm_district';
+ break;
+ case 'street':
+ $table='fm_streetaddress';
+ break;
+ }
+
+ return $table;
+ }
+
+
+ function read_single($id,$type,$type_id)
+ {
+
+ $table = $this->select_table($type,$type_id);
+
+ $sql = "SELECT * FROM $table where id='$id'";
+
+ $dbresult = $GLOBALS['phpgw']->db->Execute($sql);
+
+ if (!$dbresult->EOF)
+ {
+ $category['id'] =
$dbresult->fields['id'];
+ $category['descr']
= $dbresult->fields['descr'];
+
+ return $category;
+ }
+ }
+
+ function add($category,$type,$type_id)
+ {
+ $table = $this->select_table($type,$type_id);
+
+ $category['descr'] =
$this->db->db_addslashes($category['descr']);
+
+ $GLOBALS['phpgw']->db->Execute("INSERT INTO $table (id,
descr) "
+ . "VALUES ('" . $category['id'] . "','" .
$category['descr']. "')");
+
+ $receipt['message'][]=array('msg'=>lang('category has
been saved'));
+ return $receipt;
+ }
+
+ function edit($category,$type,$type_id)
+ {
+
+ $table = $this->select_table($type,$type_id);
+
+ $category['descr'] =
$this->db->db_addslashes($category['descr']);
+
+ $GLOBALS['phpgw']->db->Execute("UPDATE $table set
descr='" . $category['descr']
+ . "' WHERE id='" .
$category['id']. "'");
+
+
+ $receipt['message'][]=array('msg'=>lang('category has
been edited'));
+ return $receipt;
+ }
+
+ function delete($id,$type,$type_id)
+ {
+ $table = $this->select_table($type,$type_id);
+
+ $GLOBALS['phpgw']->db->Execute("DELETE FROM $table
WHERE id='" . $id . "'");
+ }
+ }
+?>
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] property/class.socategory.php, 1.1.1.3,
nomail <=