[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] property/class.soowner.php, 1.1.1.3
From: |
nomail |
Subject: |
[Phpgroupware-cvs] property/class.soowner.php, 1.1.1.3 |
Date: |
Fri, 21 May 2004 19:07:17 -0000 |
Update of /property
Modified Files:
Branch:
class.soowner.php
date: 2004/04/23 21:26:33; author: sigurdne; state: Exp; lines: +174 -174
Log Message:
no message
=====================================================================
Index: property/class.soowner.php
diff -u property/class.soowner.php:1.1.1.2 property/class.soowner.php:1.1.1.3
--- property/class.soowner.php:1.1.1.2 Fri Apr 23 20:25:53 2004
+++ property/class.soowner.php Fri Apr 23 21:26:33 2004
@@ -1,174 +1,174 @@
-<?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.
*
-
\**************************************************************************/
- /* $Id$ */
-
- class property_soowner
- {
-
- function property_soowner()
- {
- $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 select_category_list()
- {
- $dbresult = $GLOBALS['phpgw']->db->Execute("SELECT
id,descr FROM fm_owner_category ORDER BY descr ");
-
- $i = 0;
- while (!$dbresult->EOF)
- {
- $categories[$i]['id']
= $dbresult->fields['id'];
- $categories[$i]['name']
= stripslashes($dbresult->fields['descr']);
- $i++;
- $dbresult->MoveNext();
- }
- return $categories;
- }
-
- function read_category_name($cat_id)
- {
- $dbresult = $GLOBALS['phpgw']->db->Execute("SELECT
descr FROM fm_owner_category where id='$cat_id'");
-
- return $dbresult->fields['descr'];
- }
-
- function read($data)
- {
- if(is_array($data))
- {
- $start =
(isset($data['start'])?$data['start']:0);
- $filter =
(isset($data['filter'])?$data['filter']:'none');
- $query =
(isset($data['query'])?$data['query']:'');
- $sort =
(isset($data['sort'])?$data['sort']:'DESC');
- $order =
(isset($data['order'])?$data['order']:'');
- $cat_id =
(isset($data['cat_id'])?$data['cat_id']:0);
- $allrows =
(isset($data['allrows'])?$data['allrows']:'');
- }
-
- if ($order)
- {
- $ordermethod = " order by $order $sort";
- }
- else
- {
- $ordermethod = ' order by org_name DESC';
- }
-
-
- $where = 'WHERE';
- if ($cat_id > 0)
- {
- $filtermethod .= " $where category='$cat_id' ";
- $where = 'AND';
-
- }
-
- if($query)
- {
- $query = ereg_replace("'",'',$query);
- $query = ereg_replace('"','',$query);
-
- $querymethod = " $where ( abid = '$query' or
org_name LIKE '%$query%')";
- }
-
- $sql = "SELECT fm_owner.*, descr as category FROM
fm_owner $this->join fm_owner_category on
fm_owner.category=fm_owner_category.id $filtermethod $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)
- {
- $owners[] = array
- (
- 'owner_id' =>
$dbresult->fields['owner_id'],
- 'abid' =>
$dbresult->fields['abid'],
- 'org_name' =>
stripslashes($dbresult->fields['org_name']),
- 'remark' =>
stripslashes($dbresult->fields['remark']),
- 'entry_date' =>
$dbresult->fields['entry_date'],
- 'category' =>
$dbresult->fields['category']
- );
- $dbresult->MoveNext();
- }
- return $owners;
- }
-
- function read_single($owner_id)
- {
- $dbresult = $GLOBALS['phpgw']->db->Execute("SELECT *
from fm_owner where owner_id='$owner_id'");
-
- if (!$dbresult->EOF)
- {
- $owner['id'] =
(int)$dbresult->fields['owner_id'];
- $owner['abid'] =
$dbresult->fields['abid'];
- $owner['org_name'] =
stripslashes($dbresult->fields['org_name']);
- $owner['remark'] =
stripslashes($dbresult->fields['remark']);
- $owner['entry_date'] =
$dbresult->fields['entry_date'];
- $owner['cat_id'] =
(int)$dbresult->fields['category'];
-
- return $owner;
- }
- }
-
- function add($owner)
- {
- $owner['name'] =
$this->db->db_addslashes($owner['name']);
-
- $GLOBALS['phpgw']->db->Execute("INSERT INTO fm_owner
(entry_date,remark,abid,org_name,category) "
- . "VALUES ('" . time() . "','" .
$owner['remark'] . "','" . $owner['abid'] . "','" . $owner['org_name']
- . "','" . $owner['cat_id'] . "')");
-
- $receipt['owner_id']=
$this->db->get_last_insert_id('fm_owner','owner_id');
- $receipt['message'][] = array('msg'=>lang('owner %1 has
been saved',$receipt['owner_id']));
- return $receipt;
- }
-
- function edit($owner)
- {
- $owner['name'] =
$this->db->db_addslashes($owner['name']);
-
- $GLOBALS['phpgw']->db->Execute("UPDATE fm_owner set
remark='" . $owner['remark'] . "', entry_date='" . time() . "', abid='" .
$owner['abid'] . "', org_name='" . $owner['org_name'] . "', category='"
- . $owner['cat_id'] . "'
WHERE owner_id=" . intval($owner['owner_id']));
-
- $receipt['owner_id']= $owner['owner_id'];
- $receipt['message'][] = array('msg'=>lang('owner %1 has
been edited',$owner['owner_id']));
- return $receipt;
- }
-
- function delete($owner_id)
- {
- $GLOBALS['phpgw']->db->Execute('DELETE FROM fm_owner
WHERE owner_id=' . intval($owner_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.
*
+
\**************************************************************************/
+ /* $Id$ */
+
+ class property_soowner
+ {
+
+ function property_soowner()
+ {
+ $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 select_category_list()
+ {
+ $dbresult = $GLOBALS['phpgw']->db->Execute("SELECT
id,descr FROM fm_owner_category ORDER BY descr ");
+
+ $i = 0;
+ while (!$dbresult->EOF)
+ {
+ $categories[$i]['id']
= $dbresult->fields['id'];
+ $categories[$i]['name']
= stripslashes($dbresult->fields['descr']);
+ $i++;
+ $dbresult->MoveNext();
+ }
+ return $categories;
+ }
+
+ function read_category_name($cat_id)
+ {
+ $dbresult = $GLOBALS['phpgw']->db->Execute("SELECT
descr FROM fm_owner_category where id='$cat_id'");
+
+ return $dbresult->fields['descr'];
+ }
+
+ function read($data)
+ {
+ if(is_array($data))
+ {
+ $start =
(isset($data['start'])?$data['start']:0);
+ $filter =
(isset($data['filter'])?$data['filter']:'none');
+ $query =
(isset($data['query'])?$data['query']:'');
+ $sort =
(isset($data['sort'])?$data['sort']:'DESC');
+ $order =
(isset($data['order'])?$data['order']:'');
+ $cat_id =
(isset($data['cat_id'])?$data['cat_id']:0);
+ $allrows =
(isset($data['allrows'])?$data['allrows']:'');
+ }
+
+ if ($order)
+ {
+ $ordermethod = " order by $order $sort";
+ }
+ else
+ {
+ $ordermethod = ' order by org_name DESC';
+ }
+
+
+ $where = 'WHERE';
+ if ($cat_id > 0)
+ {
+ $filtermethod .= " $where category='$cat_id' ";
+ $where = 'AND';
+
+ }
+
+ if($query)
+ {
+ $query = ereg_replace("'",'',$query);
+ $query = ereg_replace('"','',$query);
+
+ $querymethod = " $where ( abid = '$query' or
org_name LIKE '%$query%')";
+ }
+
+ $sql = "SELECT fm_owner.*, descr as category FROM
fm_owner $this->join fm_owner_category on
fm_owner.category=fm_owner_category.id $filtermethod $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)
+ {
+ $owners[] = array
+ (
+ 'owner_id' =>
$dbresult->fields['owner_id'],
+ 'abid' =>
$dbresult->fields['abid'],
+ 'org_name' =>
stripslashes($dbresult->fields['org_name']),
+ 'remark' =>
stripslashes($dbresult->fields['remark']),
+ 'entry_date' =>
$dbresult->fields['entry_date'],
+ 'category' =>
$dbresult->fields['category']
+ );
+ $dbresult->MoveNext();
+ }
+ return $owners;
+ }
+
+ function read_single($owner_id)
+ {
+ $dbresult = $GLOBALS['phpgw']->db->Execute("SELECT *
from fm_owner where owner_id='$owner_id'");
+
+ if (!$dbresult->EOF)
+ {
+ $owner['id'] =
(int)$dbresult->fields['owner_id'];
+ $owner['abid'] =
$dbresult->fields['abid'];
+ $owner['org_name'] =
stripslashes($dbresult->fields['org_name']);
+ $owner['remark'] =
stripslashes($dbresult->fields['remark']);
+ $owner['entry_date'] =
$dbresult->fields['entry_date'];
+ $owner['cat_id'] =
(int)$dbresult->fields['category'];
+
+ return $owner;
+ }
+ }
+
+ function add($owner)
+ {
+ $owner['name'] =
$this->db->db_addslashes($owner['name']);
+
+ $GLOBALS['phpgw']->db->Execute("INSERT INTO fm_owner
(entry_date,remark,abid,org_name,category) "
+ . "VALUES ('" . time() . "','" .
$owner['remark'] . "','" . $owner['abid'] . "','" . $owner['org_name']
+ . "','" . $owner['cat_id'] . "')");
+
+ $receipt['owner_id']=
$this->db->get_last_insert_id('fm_owner','owner_id');
+ $receipt['message'][] = array('msg'=>lang('owner %1 has
been saved',$receipt['owner_id']));
+ return $receipt;
+ }
+
+ function edit($owner)
+ {
+ $owner['name'] =
$this->db->db_addslashes($owner['name']);
+
+ $GLOBALS['phpgw']->db->Execute("UPDATE fm_owner set
remark='" . $owner['remark'] . "', entry_date='" . time() . "', abid='" .
$owner['abid'] . "', org_name='" . $owner['org_name'] . "', category='"
+ . $owner['cat_id'] . "'
WHERE owner_id=" . intval($owner['owner_id']));
+
+ $receipt['owner_id']= $owner['owner_id'];
+ $receipt['message'][] = array('msg'=>lang('owner %1 has
been edited',$owner['owner_id']));
+ return $receipt;
+ }
+
+ function delete($owner_id)
+ {
+ $GLOBALS['phpgw']->db->Execute('DELETE FROM fm_owner
WHERE owner_id=' . intval($owner_id));
+ }
+ }
+?>
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] property/class.soowner.php, 1.1.1.3,
nomail <=