[Phpgroupware-cvs] phpgwapi/inc/class.contact_person.inc.php, 1.2

[nomail]

Update of /phpgwapi/inc
Added Files:
        Branch: 
          class.contact_person.inc.php

date: 2004/12/30 06:47:30;  author: skwashd;  state: Exp;  lines: +330 -0

Log Message:
new HEAD
=====================================================================
<?php
        /**
        * Query statements for "person" table
        * @author Edgar Antonio Luna <address@hidden>
        * @copyright Copyright (C) 2003,2004 Free Software Foundation, Inc. 
http://www.fsf.org/
        * @license http://www.gnu.org/licenses/lgpl.html GNU Lesser General 
Public License
        * @package phpgwapi
        * @subpackage contacts
        * @version $Id: class.contact_person.inc.php,v 1.2 2004/12/30 06:47:30 
skwashd Exp $
        */

        /**
        * Use SQL criteria
        */
        include_once(PHPGW_API_INC . '/class.sql_criteria.inc.php');
        /**
        * Use SQL entity
        */
        include_once(PHPGW_API_INC . '/class.sql_entity.inc.php');

        /**
        * Query statements for "person" table
        *
        * @package phpgwapi
        * @subpackage contacts
        */
        class contact_person extends sql_entity
        {
                var $map = array('person_id'            => array('select'       
=> '',
                                                                 'criteria'     
=> '',
                                                                 'insert'       
=> '',
                                                                 'update'       
=> '',
                                                                 'delete'       
=> '',
                                                                 'sort'         
=> '',
                                                                 'field'        
=> '',
                                                                 'type'         
=> 'integer'),
                                 'per_full_name'        => array('select'       
=> 'full_name',
                                                                 'criteria'     
=> '',
                                                                 'insert'       
=> '',
                                                                 'update'       
=> '',
                                                                 'delete'       
=> '',
                                                                 'sort'         
=> '',
                                                                 'field'        
=> ''),
                                 'per_first_name'       => array('select'       
=> '',
                                                                 'criteria'     
=> '',
                                                                 'insert'       
=> '',
                                                                 'update'       
=> '',
                                                                 'delete'       
=> '',
                                                                 'sort'         
=> '',
                                                                 'field'        
=> 'first_name',
                                                                 'type'         
=> 'string'),
                                 'per_last_name'        => array('select'       
=> '',
                                                                 'criteria'     
=> '',
                                                                 'insert'       
=> '',
                                                                 'update'       
=> '',
                                                                 'delete'       
=> '',
                                                                 'sort'         
=> '',
                                                                 'field'        
=> 'last_name',
                                                                 'type'         
=> 'string'),
                                 'per_middle_name'      => array('select'       
=> '',
                                                                 'criteria'     
=> '',
                                                                 'insert'       
=> '',
                                                                 'update'       
=> '',
                                                                 'delete'       
=> '',
                                                                 'sort'         
=> '',
                                                                 'field'        
=> 'middle_name',
                                                                 'type'         
=> 'string'),
                                 'per_prefix'           => array('select'       
=> '',
                                                                 'criteria'     
=> '',
                                                                 'insert'       
=> '',
                                                                 'update'       
=> '',
                                                                 'delete'       
=> '',
                                                                 'sort'         
=> '',
                                                                 'field'        
=> 'prefix',
                                                                 'type'         
=> 'string'),
                                 'per_suffix'           => array('select'       
=> '',
                                                                 'criteria'     
=> '',
                                                                 'insert'       
=> '',
                                                                 'update'       
=> '',
                                                                 'delete'       
=> '',
                                                                 'sort'         
=> '',
                                                                 'field'        
=> 'suffix',
                                                                 'type'         
=> 'string'),
                                 'per_birthday'         => array('select'       
=> '',
                                                                 'criteria'     
=> '',
                                                                 'insert'       
=> '',
                                                                 'update'       
=> '',
                                                                 'delete'       
=> '',
                                                                 'sort'         
=> '',
                                                                 'field'        
=> 'birthday',
                                                                 'type'         
=> 'string'),
                                 'per_pubkey'           => array('select'       
=> '',
                                                                 'criteria'     
=> '',
                                                                 'insert'       
=> '',
                                                                 'update'       
=> '',
                                                                 'delete'       
=> '',
                                                                 'sort'         
=> '',
                                                                 'field'        
=> 'pubkey',
                                                                 'type'         
=> 'string'),
                                 'per_title'            => array('select'       
=> '',
                                                                 'criteria'     
=> '',
                                                                 'insert'       
=> '',
                                                                 'update'       
=> '',
                                                                 'delete'       
=> '',
                                                                 'sort'         
=> '',
                                                                 'field'        
=> 'title',
                                                                 'type'         
=> 'string'),
                                 'per_department'       => array('select'       
=> '',
                                                                 'criteria'     
=> '',
                                                                 'insert'       
=> '',
                                                                 'update'       
=> '',
                                                                 'delete'       
=> '',
                                                                 'sort'         
=> '',
                                                                 'field'        
=> 'department',
                                                                 'type'         
=> 'string'),
                                 'per_initials'         => array('select'       
=> '',
                                                                 'criteria'     
=> '',
                                                                 'insert'       
=> '',
                                                                 'update'       
=> '',
                                                                 'delete'       
=> '',
                                                                 'sort'         
=> '',
                                                                 'field'        
=> 'initials',
                                                                 'type'         
=> 'string'),
                                 'per_sound'            => array('select'       
=> '',
                                                                 'criteria'     
=> '',
                                                                 'insert'       
=> '',
                                                                 'update'       
=> '',
                                                                 'delete'       
=> '',
                                                                 'sort'         
=> '',
                                                                 'field'        
=> 'sound',
                                                                 'type'         
=> 'string'),
                                 'per_active'           => array('select'       
=> '',
                                                                 'criteria'     
=> '',
                                                                 'insert'       
=> '',
                                                                 'update'       
=> '',
                                                                 'delete'       
=> '',
                                                                 'sort'         
=> '',
                                                                 'field'        
=> 'active',
                                                                 'type'         
=> 'string'),
                                 'per_creaton'          => array('select'       
=> '',
                                                                 'criteria'     
=> '',
                                                                 'insert'       
=> '',
                                                                 'update'       
=> '',
                                                                 'delete'       
=> '',
                                                                 'sort'         
=> '',
                                                                 'field'        
=> 'created_on',
                                                                 'type'         
=> 'integer'),
                                 'per_creatby'          => array('select'       
=> '',
                                                                 'criteria'     
=> '',
                                                                 'insert'       
=> '',
                                                                 'update'       
=> '',
                                                                 'delete'       
=> '',
                                                                 'sort'         
=> '',
                                                                 'field'        
=> 'created_by',
                                                                 'type'         
=> 'integer'),
                                 'per_modon'            => array('select'       
=> '',
                                                                 'criteria'     
=> '',
                                                                 'insert'       
=> '',
                                                                 'update'       
=> '',
                                                                 'delete'       
=> '',
                                                                 'sort'         
=> '',
                                                                 'field'        
=> 'modified_on',
                                                                 'type'         
=> 'integer'),
                                 'per_modby'            => array('select'       
=> '',
                                                                 'criteria'     
=> '',
                                                                 'insert'       
=> '',
                                                                 'update'       
=> '',
                                                                 'delete'       
=> '',
                                                                 'sort'         
=> '',
                                                                 'field'        
=> 'modified_by',
                                                                 'type'         
=> 'integer'),
                                 'per_name'             => array('select'       
=> '',
                                                                 'criteria'     
=> '',
                                                                 'insert'       
=> '',
                                                                 'update'       
=> '',
                                                                 'delete'       
=> '',
                                                                 'sort'         
=> '',
                                                                 'field'        
=> ''),
                                 'fn'                   => array('select'       
=> 'full_name',
                                                                 'criteria'     
=> '',
                                                                 'insert'       
=> '',
                                                                 'update'       
=> '',
                                                                 'delete'       
=> '',
                                                                 'sort'         
=> '',
                                                                 'field'        
=> ''),
                                 'n_given'              => array('select'       
=> '',
                                                                 'criteria'     
=> '',
                                                                 'insert'       
=> '',
                                                                 'update'       
=> '',
                                                                 'delete'       
=> '',
                                                                 'sort'         
=> '',
                                                                 'field'        
=> 'first_name',
                                                                 'type'         
=> 'string'),
                                 'n_family'             => array('select'       
=> '',
                                                                 'criteria'     
=> '',
                                                                 'insert'       
=> '',
                                                                 'update'       
=> '',
                                                                 'delete'       
=> '',
                                                                 'sort'         
=> '',
                                                                 'field'        
=> 'last_name',
                                                                 'type'         
=> 'string'),
                                 'n_middle'             => array('select'       
=> '',
                                                                 'criteria'     
=> '',
                                                                 'insert'       
=> '',
                                                                 'update'       
=> '',
                                                                 'delete'       
=> '',
                                                                 'sort'         
=> '',
                                                                 'field'        
=> 'middle_name',
                                                                 'type'         
=> 'string'),
                                 'n_prefix'             => array('select'       
=> '',
                                                                 'criteria'     
=> '',
                                                                 'insert'       
=> '',
                                                                 'update'       
=> '',
                                                                 'delete'       
=> '',
                                                                 'sort'         
=> '',
                                                                 'field'        
=> 'per_prefix'),
                                 'n_suffix'             => array('select'       
=> '',
                                                                 'criteria'     
=> '',
                                                                 'insert'       
=> '',
                                                                 'update'       
=> '',
                                                                 'delete'       
=> '',
                                                                 'sort'         
=> '',
                                                                 'field'        
=> 'per_suffix'),
                                 'sound'                => array('select'       
=> '',
                                                                 'criteria'     
=> '',
                                                                 'insert'       
=> '',
                                                                 'update'       
=> '',
                                                                 'delete'       
=> '',
                                                                 'sort'         
=> '',
                                                                 'field'        
=> 'per_sound'),
                                 'bday'                 => array('select'       
=> '',
                                                                 'criteria'     
=> '',
                                                                 'insert'       
=> '',
                                                                 'update'       
=> '',
                                                                 'delete'       
=> '',
                                                                 'sort'         
=> '',
                                                                 'field'        
=> 'per_birthday'),
                                 'tz'                   => array('select'       
=> '',
                                                                 'criteria'     
=> '',
                                                                 'insert'       
=> '',
                                                                 'update'       
=> '',
                                                                 'delete'       
=> '',
                                                                 'sort'         
=> '',
                                                                 'field'        
=> 'per_timezone'),
                                 'geo'                  => array('select'       
=> '',
                                                                 'criteria'     
=> '',
                                                                 'insert'       
=> '',
                                                                 'update'       
=> '',
                                                                 'delete'       
=> '',
                                                                 'sort'         
=> '',
                                                                 'field'        
=> 'per_geo'),
                                 'pubkey'               => array('select'       
=> '',
                                                                 'criteria'     
=> '',
                                                                 'insert'       
=> '',
                                                                 'update'       
=> '',
                                                                 'delete'       
=> '',
                                                                 'sort'         
=> '',
                                                                 'field'        
=> 'per_pubkey'),
                                 'org_unit'             => array('select'       
=> '',
                                                                 'criteria'     
=> '',
                                                                 'insert'       
=> '',
                                                                 'update'       
=> '',
                                                                 'delete'       
=> '',
                                                                 'sort'         
=> '',
                                                                 'field'        
=> 'per_deparment'),
                                 'title'                => array('select'       
=> '',
                                                                 'criteria'     
=> '',
                                                                 'insert'       
=> '',
                                                                 'update'       
=> '',
                                                                 'delete'       
=> '',
                                                                 'sort'         
=> '',
                                                                 'field'        
=> 'title'),
                                 'count_persons'        => array('select'       
=> '',
                                                                 'criteria'     
=> '',
                                                                 'insert'       
=> '',
                                                                 'update'       
=> '',
                                                                 'delete'       
=> '',
                                                                 'sort'         
=> '',
                                                                 'field'        
=> 'person_id'),
                                 'organizations_person' => array('select'       
=> 'unlink_person'),
                                 'people'               => array('select'       
=> 'relink_org_person'),
                                 'people_local'         => array('select'       
=> 'relink_org_person'));

                function contact_person ($ali = '', $field = '', $criteria =    
'')
                {
                        $this->_constructor('phpgw_contact_person', 
'contact_person');
                        if($field)
                        {
                                $this->add_select($field);
                        }
                        if($criteria)
                        {
                                $this->add_criteria($criteria);
                        }
                        $this->set_ilinks('person_id', 
'phpgwapi.contact_central','contact_id', PHPGW_SQL_REQUIRED_KEY);
                        $this->set_elinks('person_id', 
'phpgwapi.contact_accounts', 'account_person_id');
                        $this->set_ilinks('person_id', 
'phpgwapi.contact_org_person','my_person_id', PHPGW_SQL_LAZY_KEY);
                }

                function unlink_person()
                {
                        unset($this->ilink['phpgwapi.contact_central']);
                }

                function relink_org_person()
                {
                        unset($this->ilink['phpgwapi.contact_org_person']);
                        $this->set_elinks('person_id', 
'phpgwapi.contact_org_person','my_person_id');
                }

                function criteria_person_id($element)
                {
                        $this->_add_criteria($this->index_criteria($element));
                }

                function select_count_persons()
                {
                        $this->add_field('count_persons', 'count(person_id)');
                }

                function full_name()
                {

                        $this->add_field('per_full_name', 
sql::concat_null(array($this->real_field('per_first_name'), sql::string(' '),
                                                                                
 $this->real_field('per_middle_name'), sql::string(' '),
                                                                                
 $this->real_field('per_last_name'))));
                }

        }
?>