[Phpgroupware-cvs] property/inc/class.sotts.inc.php, 1.2

[nomail]

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

date: 2004/06/02 18:54:28;  author: sigurdne;  state: Exp;  lines: +478 -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.                                            
   *
        
\**************************************************************************/

        class sotts
        {

                function sotts()
                {
                        $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->historylog       = 
CreateObject($this->currentapp.'.historylog','tts');
                        $this->config           = 
CreateObject('phpgwapi.config');
                        $this->bocommon         = 
CreateObject($this->currentapp.'.bocommon');
                        $this->join                     = $this->bocommon->join;
                        $this->soadmin_entity   = 
CreateObject($this->currentapp.'.soadmin_entity');
                        $this->dateformat = 
$GLOBALS['phpgw_info']['user']['preferences']['common']['dateformat'];

                }

                function get_category_name($cat_id)
                {
                        $this->db->query("SELECT descr FROM fm_tts_category  
WHERE id='$cat_id' ");

                        $this->db->next_record();

                        return stripslashes($this->db->f('descr'));
                }

                function select_category_list()
                {
                        $this->db->query("SELECT id, descr FROM fm_tts_category 
 ORDER BY descr ");

                        $i = 0;
                        while ($this->db->next_record())
                        {
                                $categories[$i]['id']                           
= $this->db->f('id');
                                $categories[$i]['name']                         
= stripslashes($this->db->f('descr'));
                                $i++;
                        }
                        return $categories;
                }


                function read($data)
                {

                        if(is_array($data))
                        {
                                if ($data['start'])
                                {
                                        $start=$data['start'];
                                }
                                else
                                {
                                        $start=0;
                                }
                                $filter = 
(isset($data['filter'])?$data['filter']:'open');
                                $user_filter= 
(isset($data['user_filter'])?$data['user_filter']:'');
                                $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);
                                $district_id = 
(isset($data['district_id'])?$data['district_id']:0);
                                $allrows = 
(isset($data['allrows'])?$data['allrows']:'');
                        }

//_debug_array($data);

/*                      $this->grants   = 
$GLOBALS['phpgw']->session->appsession('grants_ticket',$this->currentapp);

                        if(!$this->grants)
                        {
                                $this->acl2             = 
CreateObject($this->currentapp.'.acl2','##DEFAULT##','##DEFAULT##');
                                $this->grants           = 
$this->acl2->get_grants($this->currentapp,'.ticket');
                                
$GLOBALS['phpgw']->session->appsession('grants_ticket',$this->currentapp,$this->grants);
                        }
*/
                        if ($order)
                        {
                                $ordermethod = " order by $order $sort";
                        }
                        else
                        {
                                $ordermethod = ' order by fm_tts_tickets.id 
DESC';
                        }

                        $where= 'WHERE';

/*                      $filtermethod = $where . ' ( fm_tts_tickets.user_id=' . 
$this->account;
                        if (is_array($this->grants))
                        {
                                $grants = $this->grants;
                                while (list($user) = each($grants))
                                {
                                        $public_user_list[] = $user;
                                }
                                reset($public_user_list);
                                $filtermethod = " $where ( 
fm_tts_tickets.user_id IN(" . implode(',',$public_user_list) . "))";
                        }

                        $where= 'AND';

*/
                        if ($filter == 'closed'):
                        {
                                $filtermethod .= " $where 
fm_tts_tickets.status='X'";
                                $where = 'AND';
                        }
                        elseif($filter == ''):
                        {
                                $filtermethod .= " $where 
fm_tts_tickets.status='O'";
                                $where = 'AND';
                        }
                        endif;

                        if ($cat_id > 0)
                        {
                                $filtermethod .= " $where cat_id='$cat_id' ";
                                $where = 'AND';
                        }

                        if ($user_filter > 0)
                        {
                                $filtermethod .= " $where 
assignedto=$user_filter";
                                $where = 'AND';
                        }

                        if ($district_id > 0)
                        {
                                $filtermethod .= " $where  
district_id='$district_id' ";
                                $where = 'AND';
                        }

                        if($query)
                        {
                                if(stristr($query, '.'))
                                {
                                        $query=explode(".",$query);
                                        $querymethod = " $where 
(fm_tts_tickets.loc1='" . $query[0] . "' AND fm_tts_tickets.loc4='" . $query[1] 
. "')";
                                }
                                else
                                {
                                        $query = ereg_replace("'",'',$query);
                                        $query = ereg_replace('"','',$query);
                                        $querymethod = " $where (subject LIKE 
'%$query%' or address LIKE '%$query%' or fm_tts_tickets.location_code LIKE 
'%$query%')";
                                }
                        }

                        $sql = "SELECT fm_tts_tickets.*, fm_tts_category.descr 
as category,phpgw_accounts.account_lid as user_lid FROM fm_tts_tickets 
$this->join fm_tts_category on fm_tts_tickets.cat_id=fm_tts_category.id "
                        . " $this->join phpgw_accounts on 
fm_tts_tickets.user_id=phpgw_accounts.account_id "
                        . " $this->join fm_location1 on 
fm_tts_tickets.loc1=fm_location1.loc1 "
                        . " $this->join fm_part_of_town on 
fm_location1.part_of_town_id=fm_part_of_town.part_of_town_id $filtermethod 
$querymethod";

//echo $sql;
                        $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__);
                        }

                        $i = 0;

                        while ($this->db->next_record())
                        {

                                $tickets[$i]['id']                              
= $this->db->f('id');
                                $tickets[$i]['subject']                 = 
$this->db->f('subject');
                                $tickets[$i]['location_code']   = 
$this->db->f('location_code');
                                $tickets[$i]['user']                    = 
$this->db->f('user_lid');
                                $tickets[$i]['address']                 = 
$this->db->f('address');
                                $tickets[$i]['assignedto']              = 
$this->db->f('assignedto');
                                $tickets[$i]['status']                  = 
$this->db->f('status');
                                $tickets[$i]['priority']                = 
$this->db->f('priority');
                                $tickets[$i]['category']                = 
$this->db->f('category');
                                $tickets[$i]['subject']                 = 
$this->db->f('subject');
                                $tickets[$i]['group_id']                = 
$this->db->f('group_id');
                                $tickets[$i]['entry_date']              = 
$this->db->f('entry_date');
                                $tickets[$i]['finnish_date']    = 
$this->db->f('finnish_date');
                                $tickets[$i]['finnish_date2']   = 
$this->db->f('finnish_date2');

                                $this->db2->query("select count(*) from 
fm_tts_views where id='" . $this->db->f('id')
                                        . "' and account_id='" . 
$GLOBALS['phpgw_info']['user']['account_id'] . "'",__LINE__,__FILE__);
                                $this->db2->next_record();

                                if (!$this->db2->f(0))
                                {
                                        $tickets[$i]['new_ticket'] = True;
                                }

                                $i++;

                        }
                        return $tickets;
                }

                function get_origin_entity_type()
                {
                        $sql = "SELECT fm_entity_origin.entity_id, 
fm_entity_origin.cat_id,name"
                        . " FROM fm_entity_origin $this->join 
fm_entity_category on fm_entity_origin.entity_id=fm_entity_category.entity_id"
                        . " AND fm_entity_origin.cat_id=fm_entity_category.id "
                        . " WHERE origin ='tts' and tracking=1 group by 
fm_entity_origin.entity_id, fm_entity_origin.cat_id,name";

                        $this->db->query($sql,__LINE__,__FILE__);

                        $i=0;
                        while ($this->db->next_record())
                        {
                                
$entity[$i]['entity_id']=$this->db->f('entity_id');
                                $entity[$i]['cat_id']=$this->db->f('cat_id');
                                $entity[$i]['type']='entity';
                                $uicols[]       = $this->db->f('name');
                                $i++;
                        }

                        $entity[$i]['type']='project';
                        $uicols[]       = lang('project');

                        $this->uicols   = $uicols;
                        return $entity;
                }

                function get_child_date($id,$type,$entity_id='',$cat_id='')
                {
                        $table= 'fm_' . $type . '_origin';
                        if($cat_id)
                        {
                                $and = " AND entity_id=$entity_id AND 
cat_id=$cat_id";
                        }

                        $sql = "SELECT * FROM $table  WHERE origin_id='$id' and 
origin ='tts' $and";

                        $this->db->query($sql,__LINE__,__FILE__);

                        $i=0;
                        while ($this->db->next_record())
                        {
                                $date_info['date_info'][$i]['entry_date']= 
$GLOBALS['phpgw']->common->show_date($this->db->f('entry_date'),$this->dateformat);
                                if($this->db->f('cat_id'))
                                {
                                        
$date_info['date_info'][$i]['link']=$GLOBALS['phpgw']->link('/index.php','menuaction='.$this->currentapp.'.uientity.view&entity_id='.$entity_id.'&cat_id='
 . $cat_id . '&id=' . $this->db->f('id'));
                                        
$date_info['date_info'][$i]['descr']=$this->soadmin_entity->read_category_name($entity_id,$cat_id);
                                }
                                else
                                {
                                        
$date_info['date_info'][$i]['link']=$GLOBALS['phpgw']->link('/index.php','menuaction='.$this->currentapp.'.ui'
 . $type . '.view&id=' . $this->db->f($type . '_id'));
                                        
$date_info['date_info'][$i]['descr']=lang($type);
                                }

                                $i++;
                        }
//_debug_array($date_info);
                        return $date_info;
                }

                function read_single($id)
                {
                        $sql = "SELECT * FROM fm_tts_tickets WHERE id=$id";

                        $this->db->query($sql,__LINE__,__FILE__);

                        if ($this->db->next_record())
                        {
                                $ticket['assignedto']           = 
$this->db->f('assignedto');
                                $ticket['user_id']                      = 
$this->db->f('user_id');
                                $ticket['group_id']                     = 
$this->db->f('group_id');
                                $ticket['status']                       = 
$this->db->f('status');
                                $ticket['cat_id']                       = 
$this->db->f('cat_id');
                                $ticket['subject']                      = 
stripslashes($this->db->f('subject'));
                                $ticket['priority']                     = 
$this->db->f('priority');
                                $ticket['details']                      = 
stripslashes($this->db->f('details'));
                                $ticket['location_code']        = 
$this->db->f('location_code');
//                              $ticket['contact_phone']        = 
$this->db->f('contact_phone');
                                $ticket['address']                      = 
$this->db->f('address');
                                $ticket['tenant_id']            = 
$this->db->f('tenant_id');
                                $ticket['p_num']                        = 
$this->db->f('p_num');
                                $ticket['p_entity_id']          = 
$this->db->f('p_entity_id');
                                $ticket['p_cat_id']                     = 
$this->db->f('p_cat_id');
                                $ticket['finnish_date']         = 
$this->db->f('finnish_date');
                                $ticket['finnish_date2']        = 
$this->db->f('finnish_date2');

                                $user_id=(int)$this->db->f('user_id');
                                $this->db->query("SELECT 
account_firstname,account_lastname FROM phpgw_accounts WHERE 
account_id='$user_id' ");
                                $this->db->next_record();

                                $ticket['user_name']    = 
$this->db->f('account_firstname') . " " .$this->db->f('account_lastname') ;

                        }

                        $sql = "SELECT * FROM fm_request_origin WHERE 
origin_id='$id' and origin ='tts'";

                        $this->db->query($sql,__LINE__,__FILE__);

                        $i=0;
                        while ($this->db->next_record())
                        {
                                $ticket['request_id'][$i]['id'] = 
$this->db->f('request_id');
                                $ticket['request_id'][$i]['entry_date'] = 
$GLOBALS['phpgw']->common->show_date($this->db->f('entry_date'),$this->dateformat);
                                $i++;
                        }

                        $sql = "SELECT * FROM fm_project_origin WHERE 
origin_id='$id' and origin ='tts'";

                        $this->db->query($sql,__LINE__,__FILE__);

                        $i=0;
                        while ($this->db->next_record())
                        {
                                $ticket['project_id'][$i]['id'] = 
$this->db->f('project_id');
                                $ticket['project_id'][$i]['entry_date'] = 
$GLOBALS['phpgw']->common->show_date($this->db->f('entry_date'),$this->dateformat);
                                $i++;
                        }

                        $sql = "SELECT * FROM fm_entity_origin WHERE 
origin_id='$id' and origin ='tts' ORDER BY entity_id ASC";

                        $this->db->query($sql,__LINE__,__FILE__);

                        $i=0;
                        $j=0;
                        $entity_id=0;
                        while ($this->db->next_record())
                        {
                                if(!$first)
                                {
                                        $boadmin_entity         = 
CreateObject($this->currentapp.'.boadmin_entity');
                                        $entity         = 
$boadmin_entity->read_single($this->db->f('entity_id'),false);
                                        $entity_id      = 
$this->db->f('entity_id');
                                }

                                if($this->db->f('entity_id')==$entity_id)
                                {
                                        $ticket['entity'][$i]['name']   = 
$entity['name'];
                                        
$ticket['entity'][$i]['link_info'][$j]['id']    = $this->db->f('id');
                                        
$ticket['entity'][$i]['link_info'][$j]['link']  = 
$GLOBALS['phpgw']->link('/index.php','menuaction='.$this->currentapp.'.uientity.view&entity_id='.$this->db->f('entity_id').'&cat_id='
 . $this->db->f('cat_id'));
                                        
$ticket['entity'][$i]['link_info'][$j]['entry_date']    = 
$GLOBALS['phpgw']->common->show_date($this->db->f('entry_date'),$this->dateformat);
                                        $j++;
                                }
                                else
                                {
                                        $i++;
                                        $j=0;
                                        $entity         = 
$boadmin_entity->read_single($this->db->f('entity_id'),false);
                                        $entity_id      = 
$this->db->f('entity_id');
                                        $ticket['entity'][$i]['name']   = 
$entity['name'];
                                        
$ticket['entity'][$i]['link_info'][$j]['id']    = $this->db->f('id');
                                        
$ticket['entity'][$i]['link_info'][$j]['link']  = 
$GLOBALS['phpgw']->link('/index.php','menuaction='.$this->currentapp.'.uientity.view&entity_id='.$this->db->f('entity_id').'&cat_id='
 . $this->db->f('cat_id'));
                                        
$ticket['entity'][$i]['link_info'][$j]['entry_date']    = 
$GLOBALS['phpgw']->common->show_date($this->db->f('entry_date'),$this->dateformat);
                                        $j++;
                                }

                                $first=True;
                        }


//_debug_array($ticket);
//_debug_array($ticket['entity']);

                        return $ticket;
                }

                function update_view($id='')
                {
                        // Have they viewed this ticket before ?
                        $this->db->query("select count(*) from fm_tts_views 
where id='$id' "
                                        . "and account_id='" . 
$GLOBALS['phpgw_info']['user']['account_id'] . "'",__LINE__,__FILE__);
                        $this->db->next_record();

                        if (! $this->db->f(0))
                        {
                                $this->db->query("insert into fm_tts_views 
(id,account_id,time) values ('$id','"
                                        . 
$GLOBALS['phpgw_info']['user']['account_id'] . "','" . time() . 
"')",__LINE__,__FILE__);
                        }
                }

                function add($ticket)
                {
                        while (is_array($ticket['location']) && 
list($input_name,$value) = each($ticket['location']))
                        {
                                if($value)
                                {
                                        $cols[] = $input_name;
                                        $vals[] = $value;
                                }
                        }


                        while (is_array($ticket['extra']) && 
list($input_name,$value) = each($ticket['extra']))
                        {
                                if($value)
                                {
                                        $cols[] = $input_name;
                                        $vals[] = $value;
                                }
                        }

                        if($cols)
                        {
                                $cols   = "," . implode(",", $cols);
                                $vals   = ",'" . implode("','", $vals) . "'";
                        }

                        if($ticket['street_name'])
                        {
                                $address[]= $ticket['street_name'];
                                $address[]= $ticket['street_number'];
                                $address        = implode(" ", $address);
                        }

                        if(!$address)
                        {
                                $address = $ticket['location_name'];
                        }

                        $values= array(
                                $ticket['priority'],
                                $GLOBALS['phpgw_info']['user']['account_id'],
                                $ticket['assignedto'],
                                $ticket['group_id'],
                                $this->db->db_addslashes($ticket['subject']),
                                $ticket['cat_id'],
                                'O',
                                $this->db->db_addslashes($ticket['details']),
                                $ticket['location_code'],
                                $address,
                                time(),
                                $ticket['finnish_date']);

                        $values = $this->bocommon->validate_db_insert($values);
                        $this->db->transaction_begin();

                        $this->db->query("insert into fm_tts_tickets 
(priority,user_id,"
                                . 
"assignedto,group_id,subject,cat_id,status,details,location_code,"
                                . "address,entry_date,finnish_date $cols)"
                                . "VALUES ($values $vals )",__LINE__,__FILE__);

                        $id = 
$this->db->get_last_insert_id('fm_tts_tickets','id');
                        if($ticket['extra']['contact_phone'])
                        {
                                $this->db->query("update fm_tenant set 
contact_phone='". $ticket['extra']['contact_phone']. "' where id='". 
$ticket['extra']['tenant_id']. "'",__LINE__,__FILE__);
                        }

                        if($this->db->transaction_commit())
                        {
                                $this->historylog->add('O',$id,mktime(),'');
                                if($ticket['finnish_date'])
                                {
                                        
$this->historylog->add('IF',$id,$ticket['finnish_date'],'');
                                }
                        }

                        $receipt['message'][0]=array('msg'=>lang('Ticket %1 has 
been saved',$id));
                        $receipt['id']  = $id;
                        return $receipt;
                }

        }
?>