[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] property/inc/class.sop_of_town.inc.php, 1.2
From: |
nomail |
Subject: |
[Phpgroupware-cvs] property/inc/class.sop_of_town.inc.php, 1.2 |
Date: |
Wed, 2 Jun 2004 20:54:28 +0200 |
Update of /property/inc
Added Files:
Branch:
class.sop_of_town.inc.php
date: 2004/06/02 18:54:28; author: sigurdne; state: Exp; lines: +151 -0
Log Message:
no message
=====================================================================
<?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.sop_of_town.inc.php,v 1.2 2004/06/02 18:54:28 sigurdne
Exp $ */
class sop_of_town
{
function sop_of_town()
{
$this->currentapp =
$GLOBALS['phpgw_info']['flags']['currentapp'];
$this->db = $GLOBALS['phpgw']->db;
$this->db2 = $this->db;
$this->account =
$GLOBALS['phpgw_info']['user']['account_id'];
$this->socommon =
CreateObject($this->currentapp.'.socommon');
$this->join = $this->socommon->join;
}
function read_district_name($id)
{
$this->db->query("SELECT descr FROM fm_district where
id='$id'");
$this->db->next_record();
return $this->db->f('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']:'');
$district_id =
(isset($data['district_id'])?$data['district_id']:0);
$allrows =
(isset($data['allrows'])?$data['allrows']:'');
}
if ($order)
{
$ordermethod = " order by $order $sort";
}
else
{
$ordermethod = ' order by part_of_town_id ASC';
}
$where = 'WHERE';
if ($district_id > 0)
{
$filtermethod .= " $where
district_id='$district_id' ";
$where = 'AND';
}
if($query)
{
$query = ereg_replace("'",'',$query);
$query = ereg_replace('"','',$query);
$querymethod = " $where ( name LIKE
'%$query%')";
}
$sql = "SELECT fm_part_of_town.*, descr as category
FROM fm_part_of_town $this->join fm_district on
fm_part_of_town.district_id=fm_district.id $filtermethod $querymethod";
$this->db2->query($sql,__LINE__,__FILE__);
$this->total_records = $this->db2->num_rows();
if(!$allrows)
{
$this->db->limit_query($sql .
$ordermethod,$start,__LINE__,__FILE__);
}
else
{
$this->db->query($sql .
$ordermethod,__LINE__,__FILE__);
}
while ($this->db->next_record())
{
$p_of_towns[] = array
(
'part_of_town_id' =>
$this->db->f('part_of_town_id'),
'name' =>
stripslashes($this->db->f('name')),
'category' =>
stripslashes($this->db->f('category')),
'district_id' =>
$this->db->f('district_id')
);
}
return $p_of_towns;
}
function read_single($part_of_town_id)
{
$this->db->query("select * from fm_part_of_town where
part_of_town_id='$part_of_town_id'",__LINE__,__FILE__);
if ($this->db->next_record())
{
$p_of_town['id'] =
(int)$this->db->f('part_of_town_id');
$p_of_town['name'] =
stripslashes($this->db->f('name'));
$p_of_town['district_id'] =
(int)$this->db->f('district_id');
return $p_of_town;
}
}
function add($p_of_town)
{
$p_of_town['name'] =
$this->db->db_addslashes($p_of_town['name']);
$this->db->query("INSERT INTO fm_part_of_town
(name,district_id) "
. "VALUES ('" . $p_of_town['name']
. "','" . $p_of_town['district_id'] .
"')",__LINE__,__FILE__);
$receipt['part_of_town_id']=
$this->db->get_last_insert_id('fm_part_of_town','part_of_town_id');
$receipt['message'][] = array('msg'=>lang('Part of town
%1 has been saved',$receipt['part_of_town_id']));
return $receipt;
}
function edit($p_of_town)
{
$p_of_town['name'] =
$this->db->db_addslashes($p_of_town['name']);
$this->db->query("UPDATE fm_part_of_town set name='" .
$p_of_town['name'] . "', district_id='"
.
$p_of_town['district_id'] . "' WHERE part_of_town_id=" .
intval($p_of_town['part_of_town_id']),__LINE__,__FILE__);
$receipt['part_of_town_id']=
$p_of_town['part_of_town_id'];
$receipt['message'][] = array('msg'=>lang('Part of town
%1 has been edited',$p_of_town['part_of_town_id']));
return $receipt;
}
function delete($part_of_town_id)
{
$this->db->query('DELETE FROM fm_part_of_town WHERE
part_of_town_id=' . intval($part_of_town_id),__LINE__,__FILE__);
}
}
?>