[Phpgroupware-cvs] property/inc/class.soalarm.inc.php, 1.1

[nomail]

Update of /property/inc
Added Files:
        Branch: 
          class.soalarm.inc.php

date: 2004/07/21 19:00:12;  author: sigurdne;  state: Exp;

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.soalarm.inc.php,v 1.1 2004/07/21 19:00:12 sigurdne Exp $ 
*/

        class soalarm
        {

                function soalarm()
                {
                        $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 select_method_list()
                {
                        $this->db->query("SELECT id,name,data FROM 
fm_async_method ORDER BY name ");

                        $i = 0;
                        while ($this->db->next_record())
                        {
                                if($this->db->f('data'))
                                {
                                        $data_set = 
unserialize($this->db->f('data'));
                                        while (is_array($data_set) && 
list($key,$value) = each($data_set))
                                        {
                                                $method_data[] = $key . '=' . 
$value;
                                        }

                                        $method_data= @implode 
(',',$method_data);
                                }

                                $categories[$i]['id']                           
= $this->db->f('id');
                                $categories[$i]['name']                         
= stripslashes($this->db->f('name')) . '(' . $method_data . ')';
                                $i++;
                        }
                        return $categories;
                }

                function read_single_method($id)
                {
                        $this->db->query("SELECT name FROM fm_async_method  
where id='$id'");
                        $this->db->next_record();
                        return $this->db->f('name');
                }

                function read($data)
                {
                        if(is_array($data))
                        {
                                $id     = (isset($data['id'])?$data['id']:0);
                                $start  = 
(isset($data['start'])?$data['start']:0);
                                $filter = 
(isset($data['filter'])?$data['filter']:'');
                                $query = 
(isset($data['query'])?$data['query']:'');
                                $sort = 
(isset($data['sort'])?$data['sort']:'DESC');
                                $order = 
(isset($data['order'])?$data['order']:'');
                                $allrows                = 
(isset($data['allrows'])?$data['allrows']:'');
                        }

                        if ($order)
                        {
                                $ordermethod = " order by $order $sort";
                        }
                        else
                        {
                                $ordermethod = ' order by id DESC';
                        }


                        $where = 'WHERE';
                        if ($filter > 0)
                        {
                                $filtermethod .= " $where owner='$filter' ";
                                $where = 'AND';

                        }

/*                      if($query)
                        {
                                $query = ereg_replace("'",'',$query);
                                $query = ereg_replace('"','',$query);

                                $querymethod = " $where ( abid = '$query' or 
org_name LIKE '%$query%')";
                        }
*/
                        $id = $this->db->db_addslashes($id);
                        if (strpos($id,'%') !== False || strpos($id,'_') !== 
False)
                        {
                                $filtermethod = "$where id LIKE '%$id%' AND 
id!='##last-check-run##'";
                        }
                        elseif (!$id)
                        {
                                $filtermethod = $where . ' next<='.time()." AND 
id!='##last-check-run##'";
                        }
                        else
                        {
                                $filtermethod = "$where id='$id'";
                        }

                        $sql = "SELECT * FROM phpgw_async $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__);
                        }

                        $jobs = array();
                        while ($this->db->next_record())
                        {
                                $id = $this->db->f('id');
                                $data   = unserialize($this->db->f('data'));

                                $jobs[$id] = array(
                                        'id'     => $id,
                                        'next'   => $this->db->f('next'),
                                        'times'  => 
unserialize($this->db->f('times')),
                                        'method' => $this->db->f('method'),
                                        'data'   => $data,
                                        'enabled'   => (int)$data['enabled'],
                                        'account_id'   => 
$this->db->f('account_id')
                                );
                        }
                        if (!count($jobs))
                        {
                                return False;
                        }
                        return $jobs;
                }

                function read_org($id=0)
                {
                        $id = $this->db->db_addslashes($id);
                        if (strpos($id,'%') !== False || strpos($id,'_') !== 
False)
                        {
                                $where = "id LIKE '%$id%' AND 
id!='##last-check-run##'";
                        }
                        elseif (!$id)
                        {
                                $where = 'next<='.time()." AND 
id!='##last-check-run##'";
                        }
                        else
                        {
                                $where = "id='$id'";
                        }
                        $this->db->query($sql="SELECT * FROM $this->db_table 
WHERE $where",__LINE__,__FILE__);

                        $jobs = array();
                        while ($this->db->next_record())
                        {
                                $id = $this->db->f('id');

                                $jobs[$id] = array(
                                        'id'     => $id,
                                        'next'   => $this->db->f('next'),
                                        'times'  => 
unserialize($this->db->f('times')),
                                        'method' => $this->db->f('method'),
                                        'data'   => 
unserialize($this->db->f('data')),
                                        'account_id'   => 
$this->db->f('account_id')
                                );
                                //echo "job id='$id'<pre>"; 
print_r($jobs[$id]); echo "</pre>\n";
                        }
                        if (!count($jobs))
                        {
                                return False;
                        }
                        return $jobs;
                }


                function read_single($owner_id)
                {
                        $this->db->query("select * from fm_owner where 
owner_id='$owner_id'",__LINE__,__FILE__);

                        if ($this->db->next_record())
                        {
                                $owner['id']                    = 
(int)$this->db->f('owner_id');
                                $owner['abid']                  = 
$this->db->f('abid');
                                $owner['org_name']              = 
stripslashes($this->db->f('org_name'));
                                $owner['remark']                = 
stripslashes($this->db->f('remark'));
                                $owner['entry_date']            = 
$this->db->f('entry_date');
                                $owner['cat_id']                        = 
(int)$this->db->f('category');

                                return $owner;
                        }
                }

                function add($owner)
                {
                        $owner['name'] = 
$this->db->db_addslashes($owner['name']);

                        $this->db->query("INSERT INTO fm_owner 
(entry_date,remark,abid,org_name,category) "
                                . "VALUES ('" . time() . "','" . 
$owner['remark'] . "','" . $owner['abid'] . "','" . $owner['org_name']
                                . "','" . $owner['cat_id'] . 
"')",__LINE__,__FILE__);

                        $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']);

                        $this->db->query("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']),__LINE__,__FILE__);

                        $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)
                {
                        $this->db->query('DELETE FROM fm_owner WHERE owner_id=' 
. intval($owner_id),__LINE__,__FILE__);
                }
        }
?>