phpgroupware-cvs
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Phpgroupware-cvs] phpgwapi/inc/class.contacts_ldap.inc.php, 1.17


From: nomail
Subject: [Phpgroupware-cvs] phpgwapi/inc/class.contacts_ldap.inc.php, 1.17
Date: Thu, 30 Dec 2004 07:47:30 +0100

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

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

Log Message:
new HEAD
=====================================================================
<?php
        /**
        * View and manipulate contact records using LDAP
        * @author Miles Lott <address@hidden>
        * @author Joseph Engo <address@hidden>
        * @copyright Copyright (C) 2001 Miles Lott
        * @copyright Portions Copyright (C) 2001-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.contacts_ldap.inc.php,v 1.17 2004/12/30 06:47:30 
skwashd Exp $
        */

        /**
        * View and manipulate contact records using LDAP
        *
        * @package phpgwapi
        * @subpackage contacts
        * This class provides a contact database scheme. It attempts to be 
based on the vcard 2.1 standard,
        * with mods as needed to make for more reasonable sql storage. The LDAP 
schema used here may require
        * installation of schema files available in the phpgwapi/doc/ldap dir. 
Please see the README file there.
        * @internal Syntax: CreateObject('phpgwapi.contacts');
        * @internal Example: $contacts = CreateObject('phpgwapi.contacts');
        * @ignore
        */
        class contacts_
        {
                var $db = '';
                var $ldap = '';
                var $nextid = '';
                var $std_table = '';
                var $ext_table = 'phpgw_addressbook_extra';

                var $account_id;
                var $adr_types;
                var $total_records;
                var $grants;

                /* The left side are the array elements used throughout phpgw, 
right side are the ldap attributes */
                var $stock_contact_fields = array(
                        'fn'                  => 'cn',
                        'n_given'             => 'givenname',
                        'n_family'            => 'sn',
                        'n_middle'            => 'phpgwmiddlename',
                        'n_prefix'            => 'phpgwprefix',
                        'n_suffix'            => 'phpgwsuffix',
                        'sound'               => 'phpgwaudio',
                        'bday'                => 'phpgwbirthday',
                        'note'                => 'description',
                        'tz'                  => 'phpgwtz',
                        'geo'                 => 'phpgwgeo',
                        'url'                 => 'phpgwurl',
                        'pubkey'              => 'phpgwpublickey',

                        'org_name'            => 'o',
                        'org_unit'            => 'ou',
                        'title'               => 'title',

                        'adr_one_street'      => 'street',
                        'adr_one_locality'    => 'l',
                        'adr_one_region'      => 'st',
                        'adr_one_postalcode'  => 'postalcode',
                        'adr_one_countryname' => 'co',
                        'adr_one_type'        => 'phpgwadronetype',
                        'label'               => 'phpgwaddresslabel',

                        'adr_two_street'      => 'phpgwadrtwostreet',
                        'adr_two_locality'    => 'phpgwadrtwolocality',
                        'adr_two_region'      => 'phpgwadrtworegion',
                        'adr_two_postalcode'  => 'phpgwadrtwopostalcode',
                        'adr_two_countryname' => 'phpgwadrtwocountryname',
                        'adr_two_type'        => 'phpgwadrtwotype',

                        'tel_work'            => 'telephonenumber',
                        'tel_home'            => 'homephone',
                        'tel_voice'           => 'phpgwvoicetelephonenumber',
                        'tel_fax'             => 'facsimiletelephonenumber',
                        'tel_msg'             => 'phpgwmsgtelephonenumber',
                        'tel_cell'            => 'phpgwcelltelephonenumber',
                        'tel_pager'           => 'phpgwpagertelephonenumber',
                        'tel_bbs'             => 'phpgwbbstelephonenumber',
                        'tel_modem'           => 'phpgwmodemtelephonenumber',
                        'tel_car'             => 'phpgwmobiletelephonenumber',
                        'tel_isdn'            => 'phpgwisdnphonenumber',
                        'tel_video'           => 'phpgwvideophonenumber',
                        'tel_prefer'          => 'phpgwpreferphone',
                        'email'               => 'mail',
                        'email_type'          => 'phpgwmailtype',
                        'email_home'          => 'phpgwmailhome',
                        'email_home_type'     => 'phpgwmailhometype'
                );

                var $non_contact_fields = array(
                        'id'     => 'uidnumber',
                        'lid'    => 'uid',
                        'tid'    => 'phpgwcontacttypeid',
                        'cat_id' => 'phpgwcontactcatid',
                        'access' => 'phpgwcontactaccess',
                        'owner'  => 'phpgwcontactowner'
                );

                /* Used to set preferphone field */
                var $tel_types = array(
                        'work'  => 'work',
                        'home'  => 'home',
                        'voice' => 'voice',
                        'fax'   => 'fax',
                        'msg'   => 'msg',
                        'cell'  => 'cell',
                        'pager' => 'pager',
                        'bbs'   => 'bbs',
                        'modem' => 'modem',
                        'car'   => 'car',
                        'isdn'  => 'isdn',
                        'video' => 'video'
                );

                /* Used to set mail_type fields */
                var $email_types = array(
                        'INTERNET'   => 'INTERNET',
                        'CompuServe' => 'CompuServe',
                        'AOL'        => 'AOL',
                        'Prodigy'    => 'Prodigy',
                        'eWorld'     => 'eWorld',
                        'AppleLink'  => 'AppleLink',
                        'AppleTalk'  => 'AppleTalk',
                        'PowerShare' => 'PowerShare',
                        'IBMMail'    => 'IBMMail',
                        'ATTMail'    => 'ATTMail',
                        'MCIMail'    => 'MCIMail',
                        'X.400'      => 'X.400',
                        'TLX'        => 'TLX'
                );

                function contacts_()
                {
                        $this->db = $GLOBALS['phpgw']->db;
                        $this->ldap = $GLOBALS['phpgw']->common->ldapConnect(
                                
$GLOBALS['phpgw_info']['server']['ldap_contact_host'],
                                
$GLOBALS['phpgw_info']['server']['ldap_contact_dn'],
                                
$GLOBALS['phpgw_info']['server']['ldap_contact_pw']
                        );
                        $this->account_id = 
$GLOBALS['phpgw_info']['user']['account_id'];
                        $this->grants     = 
$GLOBALS['phpgw']->acl->get_grants('addressbook');

                        /* Used to flag an address as being:
                           domestic OR  international(default)
                           parcel(default)
                           postal(default)
                           work(default) OR home
                        */
                        $this->adr_types = array(
                                'dom'    => lang('Domestic'),
                                'intl'   => lang('International'),
                                'parcel' => lang('Parcel'),
                                'postal' => lang('Postal')
                        );
                        print_debug('contacts_ldap:','Inside 
contacts_ldap','api');
                }

                function read_single_entry($id,$fields = '')
                {
                        if (!$fields || empty($fields)) { $fields = 
$this->stock_contact_fields; }
                        list($stock_fields,$stock_fieldnames,$extra_fields) =
                                $this->split_stock_and_extras($fields);

                        if (count($stock_fieldnames))
                        {
                                $t_fields = ',' . 
implode(',',$stock_fieldnames);
                                if ($t_fields == ',')
                                {
                                        unset($t_fields);
                                }
                        }

                        $sri = ldap_search($this->ldap, 
$GLOBALS['phpgw_info']['server']['ldap_contact_context'], 'uidnumber='.$id);
                        $ldap_fields = ldap_get_entries($this->ldap, $sri);

                        $return_fields[0]['id']     = 
$ldap_fields[0]['uidnumber'][0];
                        $return_fields[0]['lid']    = $ldap_fields[0]['uid'][0];
                        $return_fields[0]['tid']    = 
$ldap_fields[0]['phpgwcontacttypeid'][0];
                        $return_fields[0]['owner']  = 
$ldap_fields[0]['phpgwcontactowner'][0];
                        $return_fields[0]['access'] = 
$ldap_fields[0]['phpgwcontactaccess'][0];
                        $return_fields[0]['cat_id'] = 
$ldap_fields[0]['phpgwcontactcatid'][0];
                        if (is_array($stock_fieldnames))
                        {
                                
while(list($name,$value)=each($stock_fieldnames))
                                {
                                        $return_fields[0][$name] = 
utf8_decode($ldap_fields[0][$value][0]);
                                }
                        }

                        /* Setup address type fields */
                        if ($return_fields[0]['adr_one_type'])
                        {
                                $one_type = $return_fields[0]['adr_one_type'];
                                reset($this->adr_types);
                                while (list($name,$val) = 
each($this->adr_types))
                                {
                                        eval("if (strstr(\$one_type,\$name)) { 
\$return_fields[0][\"one_\$name\"] = \"on\"; }");
                                }
                        }
                        if ($return_fields[0]['adr_two_type'])
                        {
                                $two_type = $return_fields[0]['adr_two_type'];
                                reset($this->adr_types);
                                while (list($name,$val) = 
each($this->adr_types))
                                {
                                        eval("if (strstr(\$two_type,\$name)) { 
\$return_fields[0][\"two_\$name\"] = \"on\"; }");
                                }
                        }

                        $this->db->query("SELECT contact_name,contact_value 
FROM $this->ext_table WHERE contact_id='" . $id . "'",__LINE__,__FILE__);
                        while ($this->db->next_record())
                        {
                                if ($extra_fields[$this->db->f('contact_name')])
                                {
                                        
$return_fields[0][$this->db->f('contact_name')] = $this->db->f('contact_value');
                                }
                        }
                        return $return_fields;
                }

                function read_last_entry($fields = '')
                {
                        if (!$fields || empty($fields)) { $fields = 
$this->stock_contact_fields; }
                        list($stock_fields,$stock_fieldnames,$extra_fields) =
                                $this->split_stock_and_extras($fields);

                        if (count($stock_fieldnames))
                        {
                                $t_fields = ',' . 
implode(',',$stock_fieldnames);
                                if ($t_fields == ',')
                                {
                                        unset($t_fields);
                                }
                        }

                        $id = $this->nextid;
                        if ($id == -1) { $id = 1; }

                        $sri = ldap_search($this->ldap, 
$GLOBALS['phpgw_info']['server']['ldap_contact_context'], 'uidnumber='.$id);
                        $ldap_fields = ldap_get_entries($this->ldap, $sri);

                        $return_fields[0]['id']     = 
$ldap_fields[0]['uidnumber'][0];
                        $return_fields[0]['lid']    = $ldap_fields[0]['uid'][0];
                        $return_fields[0]['tid']    = 
$ldap_fields[0]['phpgwcontacttypeid'][0];
                        $return_fields[0]['owner']  = 
$ldap_fields[0]['phpgwcontactowner'][0];
                        $return_fields[0]['access'] = 
$ldap_fields[0]['phpgwcontactaccess'][0];
                        $return_fields[0]['cat_id'] = 
$ldap_fields[0]['phpgwcontactcatid'][0];

                        if (is_array($stock_fieldnames))
                        {
                                
while(list($name,$value)=each($stock_fieldnames))
                                {
                                        $return_fields[0][$name] = 
utf8_decode($ldap_fields[0][$value][0]);
                                }
                        }

                        /* Setup address type fields */
                        if ($return_fields[0]['adr_one_type'])
                        {
                                $one_type = $return_fields[0]['adr_one_type'];
                                reset($this->adr_types);
                                while (list($name,$val) = 
each($this->adr_types))
                                {
                                        eval("if (strstr(\$one_type,\$name)) { 
\$return_fields[0][\"one_\$name\"] = \"on\"; }");
                                }
                        }
                        if ($return_fields[0]['adr_two_type'])
                        {
                                $two_type = $return_fields[0]['adr_two_type'];
                                reset($this->adr_types);
                                while (list($name,$val) = 
each($this->adr_types))
                                {
                                        eval("if (strstr(\$two_type,\$name)) { 
\$return_fields[0][\"two_\$name\"] = \"on\"; }");
                                }
                        }

                        $this->db->query("SELECT contact_name,contact_value 
FROM $this->ext_table WHERE contact_id='" . $id . "'",__LINE__,__FILE__);
                        while ($this->db->next_record())
                        {
                                if ($extra_fields[$this->db->f('contact_name')])
                                {
                                        
$return_fields[0][$this->db->f('contact_name')] = $this->db->f('contact_value');
                                }
                        }
                        return $return_fields;
                }

                function 
read($start=0,$limit=0,$fields='',$query='',$filter='',$sort='',$order='', 
$lastmod=-1)
                {
                        if(!$start)  { $start  = 0; }
                        if(!$limit)  { $limit  = 0; }
                        if(!$filter) { $filter = 'tid=n'; }

                        if (!$fields || empty($fields)) { $fields = 
$this->stock_contact_fields; }

                        list($stock_fields,$stock_fieldnames,$extra_fields) = 
$this->split_stock_and_extras($fields);

                        $filterfields = array();
                        /* turn filter's a=b,c=d OR a=b into an array */
                        if ($filter)
                        {
                                print_debug('contacts_ldap:','Inbound filter 
is: #'.$filter.'#','api');
                                $filterarray = split(',',$filter);
                                if ($filterarray[1])
                                {
                                        $i=0;
                                        for ($i=0;$i<count($filterarray);$i++)
                                        {
                                                list($name,$value) = 
split('=',$filterarray[$i]);
                                                if ($name)
                                                {
                                                        
print_debug('contacts_ldap:','Filter strings: 
#'.$this->non_contact_fields[$name].'# => #'.$value.'#','api');
                                                        
$filterfields[$this->non_contact_fields[$name]] = $value;
                                                }
                                        }
                                }
                                else
                                {
                                        list($name,$value) = split('=',$filter);
                                        print_debug('contacts_ldap:','Filter 
strings: #'.$this->non_contact_fields[$name].'# => #'.$value.'#','api');
                                        $filterfields = 
array($this->non_contact_fields[$name] => $value);
                                }
                        }
                        else
                        {
                                $filterfields += array('phpgwcontacttypeid' => 
'n');
                                print_debug('contacts_ldap:','Filter strings: 
#phpgwcontacttypeid=n#','api');
                        }


                /*
                        need some way of using the lastmod arg in the filter 
like this:
                        if($lastmod >= 0)
                        {
                                $filterfields += array('last_mod'       => 
(int) $lastmod);
                        }
                        or maybe not like this - i am not sure what i am doing 
:)
                */


                        if (is_array($this->grants))
                        {
                                /* this was not listing private entries when 
show all was selected */
                                /* $filterfields += array('phpgwcontactaccess' 
=> 'public'); */
                                $grants = $this->grants;
                                if ($DEBUG) { echo '<br>DEBUG - My user id is: 
' . $this->account_id; }
                                while (list($user) = each($grants))
                                {
                                        if ($DEBUG) { echo '<br>DEBUG - Grant 
from owner: '.$user; }
                                        /* I know this looks silly... */
                                        @$filterfields['phpgwcontactowner'][] = 
array('phpgwcontactowner' => $user);
                                }
                        }
                        /*
                        if ($DEBUG)
                        {
                                while(list($name,$value) = each($filterfields))
                                {
                                        echo "<br>DEBUG - Filter strings: 
#".$name.",".$value."#";
                                }
                        }
                        */

                        if (!$sort) { $sort = 'ASC';  }

                        if (!$order)
                        {
                                $order = 'n_family';
                        }

                        if ($DEBUG && $order)
                        {
                                echo "<br>DEBUG - ORDER by $order";
                        }

                        $ldap_fields = array();
                        $myfilter = '';

                        if($query)
                        {
                                reset($this->stock_contact_fields);
                                $myfilter = 
$this->makefilter($filterfields,$this->stock_contact_fields,$query,$DEBUG);
                        }
                        else
                        {
                                $myfilter = 
$this->makefilter($filterfields,'','',$DEBUG);
                        }

                        $sri = ldap_search($this->ldap, 
$GLOBALS['phpgw_info']['server']['ldap_contact_context'], $myfilter);

                        $ldap_fields = ldap_get_entries($this->ldap, $sri);
                        /* _debug_array($ldap_fields);exit; */

                        $this->total_records = ldap_count_entries($this->ldap, 
$sri);
                        print_debug('Contacts_Ldap:','Query returned 
"'.$this->total_records.'" records.','api');

                        /* Use shared sorting routines, based on sort and order 
*/
                        @set_time_limit(0); /* Try not to die, this can take 
some time on slow machines... */
                        if ($sort == 'ASC')
                        {
                                $ldap_fields = 
$this->asortbyindex($ldap_fields, $this->stock_contact_fields[$order]);
                        }
                        else
                        {
                                $ldap_fields = 
$this->arsortbyindex($ldap_fields, $this->stock_contact_fields[$order]);
                        }

                        /*
                        This logic allows you to limit rows, or not.
                        The export feature, for example, does not limit rows.
                        This way, it can retrieve all rows at once.
                        */
                        if ($start && $limit)
                        {
                                $limit = $start + $limit;
                        }
                        elseif ($start && !$limit)
                        {
                                $limit = $start;
                        }
                        elseif(!$start && !$limit)
                        {
                                $limit = $this->total_records;
                        }
                        else
                        {
                                $start = 0;
                                $limit = $limit;
                        }
                        /* echo '('.$start.','.$limit.')'; */

                        @reset($ldap_fields);
                        $j=0;
                        for ($i=$start;$i<$limit;$i++)
                        {
                                if ($i<$this->total_records && 
$ldap_fields[$i]['uid'][0])
                                {
                                        $return_fields[$j]['id']     = 
utf8_decode($ldap_fields[$i]['uidnumber'][0]);
                                        $return_fields[$j]['lid']    = 
utf8_decode($ldap_fields[$i]['uid'][0]);
                                        $return_fields[$j]['tid']    = 
utf8_decode($ldap_fields[$i]['phpgwcontacttypeid'][0]);
                                        $return_fields[$j]['owner']  = 
utf8_decode($ldap_fields[$i]['phpgwcontactowner'][0]);
                                        $return_fields[$j]['access'] = 
utf8_decode($ldap_fields[$i]['phpgwcontactaccess'][0]);
                                        $return_fields[$j]['cat_id'] = 
utf8_decode($ldap_fields[$i]['phpgwcontactcatid'][0]);

                                        if (gettype($stock_fieldnames) == 
'array')
                                        {
                                                reset($stock_fieldnames);
                                                while (list($f_name,$f_value) = 
each($stock_fieldnames))
                                                {
                                                        
$return_fields[$j][$f_name] = utf8_decode($ldap_fields[$i][$f_value][0]);
                                                }
                                                reset($stock_fieldnames);
                                        }
                                        $this->db->query("SELECT 
contact_name,contact_value FROM $this->ext_table WHERE contact_id='"
                                                . $ldap_fields[$i]['id'] . 
"'",__LINE__,__FILE__);
                                        while ($this->db->next_record())
                                        {
                                                if 
($extra_fields[$this->db->f('contact_name')])
                                                {
                                                        
$return_fields[$j][$this->db->f('contact_name')] = 
$this->db->f('contact_value');
                                                }
                                        }
                                        $j++;
                                }
                        }
                        return $return_fields;
                }

                function makefilter($qarray,$extra='',$query='', $DEBUG=False)
                {
                        if(!is_array($qarray))
                        {
                                return $qarray;
                        }

                        if(is_array($extra))
                        {
                                if($DEBUG) { echo '<br>Searching...'; }
                                reset($extra);
                                while(list($name,$value) = each($extra))
                                {
                                        $qarray[] = array($value => $query);
                                }
                        }
                        elseif($extra)
                        {
                                $tmp = split('=',$extra);
                                $qarray[] = array($tmp[0] => $tmp[1]);
                        }

                        @ksort($qarray);

                        $aquery = '(&';
                        $oquery = '(|';
                        $hasor = False;

                        while(list($name,$value) = @each($qarray))
                        {
                                if(is_array($value))
                                {
                                        while(list($x,$y) = each($value))
                                        {
                                                if($y == '*')
                                                {
                                                        $oquery .= '(' . $x . 
'=*)';
                                                        $hasor = True;
                                                }
                                                elseif(is_array($y))
                                                {
                                                        /* This was most likely 
created from acl grants in read() above */
                                                        while(list($a,$b) = 
each($y))
                                                        {
                                                                $tmp .= '(' . 
$a . '=' . $b . ')';
                                                        }
                                                }
                                                else
                                                {
                                                        $oquery .= '(' . $x . 
'=*' . $y . '*)';
                                                        $hasor = True;
                                                }
                                        }
                                }
                                elseif($value == $query)
                                {
                                        /* searching */
                                        $oquery .= '(' . $name . '=*' . $value 
. '*)';
                                        $hasor = True;
                                }
                                else
                                {
                                        /* exact value (filtering based on tid, 
etc...) */
                                        if ($name == 'phpgwcontactcatid')
                                        {
                                                $aquery .= '(|(' . $name . 
'=*,' . $value . ',*)'.
                                                                '(' . $name . 
'=' . $value . '))';
                                        }
                                        else
                                        {
                                                $aquery .= '(' . $name . '=' . 
$value . ')';
                                        }
                                }

                                if($tmp)
                                {
                                        if(strstr($tmp,')('))
                                        {
                                                $aquery .= '(|' . $tmp . ')';
                                        }
                                        else
                                        {
                                                $aquery .= $tmp;
                                        }
                                        unset($tmp);
                                }
                        }
                        $aquery .= ')';
                        $oquery .= ')';
                        if(!$hasor)
                        {
                                $oquery = '';
                                $fquery = $aquery;
                        }
                        else
                        {
                                $fquery = '(&' . $aquery . $oquery . ')';
                        }

                        if($DEBUG)
                        {
                                echo '<br>AND query:  "' . $aquery . '"';
                                echo '<br>OR query:   "' . $oquery . '"';
                                echo '<br>Full query: "' . $fquery . '"';
                                echo '<br>Will search in "' . 
$GLOBALS['phpgw_info']['server']['ldap_contact_context'] . '"';
                        }

                        return $fquery;
                }

                function 
add($owner,$fields,$access='private',$cat_id='0',$tid='n')
                {
                        $tid = $fields['tid'] ? trim($fields['tid']) : $tid;
                        unset($fields['tid']);
                        if(empty($tid))
                        {
                                $tid = 'n';
                        }

                        if 
(!$GLOBALS['phpgw_info']['server']['ldap_contact_context'])
                        {
                                return False;
                        }

                        list($stock_fields,$stock_fieldnames,$extra_fields) = 
$this->split_stock_and_extras($fields);

                        $free = 0;
                        $this->nextid = 
$GLOBALS['phpgw']->common->last_id('contacts');
                        /* Loop until we find a free id */
                        while (!$free)
                        {
                                $ldap_fields = '';
                                $sri = ldap_search($this->ldap, 
$GLOBALS['phpgw_info']['server']['ldap_contact_context'], 
'uidnumber='.$this->nextid);
                                $ldap_fields = ldap_get_entries($this->ldap, 
$sri);
                                if ($ldap_fields[0]['dn'][0])
                                {
                                        $this->nextid = 
$GLOBALS['phpgw']->common->next_id('contacts');
                                }
                                else
                                {
                                        $free = True;
                                }
                        }

                        $ldap_fields = '';
                        if (gettype($stock_fieldnames) == 'array')
                        {
                                
while(list($name,$value)=each($stock_fieldnames))
                                {
                                        if ($stock_fields[$name] != '')
                                        {
                                                $ldap_fields[$value] = 
utf8_encode($stock_fields[$name]);
                                        }
                                }
                        }

                        $time = gettimeofday();
                        $ldap_fields['uid'] = 
time().$time['usec'].':'.$ldap_fields['givenname'];

                        $dn = 'uid=' . $ldap_fields['uid'].',' . 
$GLOBALS['phpgw_info']['server']['ldap_contact_context'];
                        $ldap_fields['phpgwcontacttypeid']    = $tid;
                        $ldap_fields['phpgwcontactowner']     = $owner;
                        if (!isset($access)) { $access = 'private'; }
                        $ldap_fields['phpgwcontactaccess']    = $access;
                        $ldap_fields['phpgwcontactcatid']     = $cat_id ? 
$cat_id : '0';
                        $ldap_fields['uidnumber']      = $this->nextid;
                        /* $ldap_fields['objectclass'][0] = 'person'; */
                        $ldap_fields['objectclass'][0] = 'organizationalPerson';
                        $ldap_fields['objectclass'][1] = 'inetOrgPerson';
                        $ldap_fields['objectclass'][2] = 'phpgwContact';
                        //$ldap_fields['last_mod'] = 
$GLOBALS['phpgw']->datetime->gmtnow;

                        /* _debug_array($ldap_fields); */
                        $err = ldap_add($this->ldap, $dn, $ldap_fields);

                        if (count($extra_fields))
                        {
                                while (list($name,$value) = each($extra_fields))
                                {
                                        $this->db->query("INSERT INTO 
$this->ext_table VALUES ('".$this->nextid."','" . $this->account_id . "','"
                                                . addslashes($name) . "','" . 
addslashes($value) . "')",__LINE__,__FILE__);
                                }
                        }
                        return $this->nextid;
                }

                function field_exists($id,$field_name)
                {
                        $this->db->query("select count(*) from $this->ext_table 
where contact_id='$id' and contact_name='"
                        . addslashes($field_name) . "'",__LINE__,__FILE__);
                        $this->db->next_record();
                        return $this->db->f(0);
                }

                function 
add_single_extra_field($id,$owner,$field_name,$field_value)
                {
                        $this->db->query("insert into $this->ext_table values 
($id,'$owner','" . addslashes($field_name)
                        . "','" . addslashes($field_value) . 
"')",__LINE__,__FILE__);
                }

                function delete_single_extra_field($id,$field_name)
                {
                        $this->db->query("delete from $this->ext_table where 
contact_id='$id' and contact_name='"
                        . addslashes($field_name) . "'",__LINE__,__FILE__);
                }

                function 
update($id,$owner,$fields,$access='private',$cat_id='0',$tid='n')
                {
                        $nonfields = $this->non_contact_fields;

                        if 
(!$GLOBALS['phpgw_info']['server']['ldap_contact_context'])
                        {
                                return False;
                        }

                        /* First make sure that id number exists */
                        $sri = ldap_search($this->ldap, 
$GLOBALS['phpgw_info']['server']['ldap_contact_context'], 'uidnumber='.$id);
                        $ldap_fields = ldap_get_entries($this->ldap, $sri);

                        if ($ldap_fields[0]['dn'])
                        {
                                $dn = utf8_decode($ldap_fields[0]['dn']);
                                
list($stock_fields,$stock_fieldnames,$extra_fields) = 
$this->split_stock_and_extras($fields);
                                if (gettype($stock_fieldnames) == 'array')
                                {
                                        /*
                                        Check each value, add our extra 
attributes if they are missing, and
                                        otherwise fix the entry while we can.
                                        */
                                        /* Verify uidnumber */
                                        $stock_fields['id']   = $id;
                                        if (empty($ldap_fields[0]['uidnumber']))
                                        {
                                                $err = 
ldap_modify($this->ldap,$dn,array('uidnumber'  => $stock_fields['uidnumber']));
                                        }
                                        elseif (!$ldap_fields[0]['uidnumber'])
                                        {
                                                $err = 
ldap_mod_add($this->ldap,$dn,array('uidnumber' => $stock_fields['uidnumber']));
                                        }

                                        /* Verify uid */
                                        $uids = split(',',$dn);
                                        $stock_fields['lid'] = $uids[0];
                                        if (empty($ldap_fields[0]['uid']))
                                        {
                                                $err = 
ldap_modify($this->ldap,$dn,array('uid'  => $stock_fields['lid']));
                                        }
                                        elseif (!$ldap_fields[0]['uid'])
                                        {
                                                $err = 
ldap_mod_add($this->ldap,$dn,array('uid' => $stock_fields['lid']));
                                        }

                                        /* Verify objectclasses are there */
                                        if 
(empty($ldap_fields[0]['objectclass']))
                                        {
                                                /* 
$stock_fields['objectclass'][0] = 'person'; */
                                                $stock_fields['objectclass'][0] 
= 'organizationalPerson';
                                                $stock_fields['objectclass'][1] 
= 'inetOrgPerson';
                                                $stock_fields['objectclass'][2] 
= 'phpgwContact';
                                                $err = 
ldap_modify($this->ldap,$dn,array('objectclass'  => 
$stock_fields['objectclass']));
                                        }
                                        elseif (!$ldap_fields[0]['objectclass'])
                                        {
                                                /* 
$stock_fields['objectclass'][0] = 'person'; */
                                                $stock_fields['objectclass'][0] 
= 'organizationalPerson';
                                                $stock_fields['objectclass'][1] 
= 'inetOrgPerson';
                                                $stock_fields['objectclass'][2] 
= 'phpgwContact';
                                                $err = 
ldap_mod_add($this->ldap,$dn,array('objectclass'  => 
$stock_fields['objectclass']));
                                        }

                                        /* Verify owner */
                                        $stock_fields['owner']  = $owner;
                                        if 
(empty($ldap_fields[0]['phpgwcontactowner']))
                                        {
                                                $err = 
ldap_modify($this->ldap,$dn,array('phpgwcontactowner'  => 
$stock_fields['owner']));
                                        }
                                        elseif 
(!$ldap_fields[0]['phpgwcontactowner'])
                                        {
                                                $err = 
ldap_mod_add($this->ldap,$dn,array('phpgwcontactowner' => 
$stock_fields['owner']));
                                        }

                                        /* Verify access */
                                        $stock_fields['access'] = $access;
                                        if 
(empty($ldap_fields[0]['phpgwcontactaccess']))
                                        {
                                                $err = 
ldap_modify($this->ldap,$dn,array('phpgwcontactaccess'  => 
$stock_fields['access']));
                                        }
                                        elseif 
(!$ldap_fields[0]['phpgwcontactaccess'])
                                        {
                                                $err = 
ldap_mod_add($this->ldap,$dn,array('phpgwcontactaccess' => 
$stock_fields['access']));
                                        }

                                        /* Verify cat_id */
                                        $stock_fields['cat_id']  = $cat_id ? 
$cat_id : ' ';
                                        if 
(empty($ldap_fields[0]['phpgwcontactcatid']))
                                        {
                                                $err = 
ldap_modify($this->ldap,$dn,array('phpgwcontactcatid'  => 
$stock_fields['cat_id']));
                                        }
                                        elseif 
(!$ldap_fields[0]['phpgwcontactcatid'])
                                        {
                                                $err = 
ldap_mod_add($this->ldap,$dn,array('phpgwcontactcatid' => 
$stock_fields['cat_id']));
                                        }

                                        /* Verify tid */
                                        $stock_fields['tid'] = $tid;
                                        if 
(empty($ldap_fields[0]['phpgwcontacttypeid']))
                                        {
                                                $err = 
ldap_modify($this->ldap,$dn,array('phpgwcontacttypeid'  => 
$stock_fields['tid']));
                                        }
                                        elseif 
(!$ldap_fields[0]['phpgwcontacttypeid'])
                                        {
                                                $err = 
ldap_mod_add($this->ldap,$dn,array('phpgwcontacttypeid' => 
$stock_fields['tid']));
                                        }

                                        /* OK, just mod the data already */
                                        $allfields = $stock_fieldnames + 
$nonfields;
                                        while ( list($fname,$fvalue) = 
each($allfields) )
                                        {
                                                /* if 
($ldap_fields[0][$fvalue]) */
                                                if ($ldap_fields[0][$fvalue] && 
$stock_fields[$fname] && $ldap_fields[0][$fvalue][0] != $stock_fields[$fname] )
                                                {
                                                        /* echo "<br>".$fname." 
=> ".$fvalue." was there"; */
                                                        $err = 
ldap_modify($this->ldap,$dn,array($fvalue => 
utf8_encode($stock_fields[$fname])));
                                                }
                                                elseif 
(!$ldap_fields[0][$fvalue] && $stock_fields[$fname])
                                                {
                                                        /* echo "<br>".$fname." 
not there - '".$fvalue."'"; */
                                                        $err = 
ldap_mod_add($this->ldap,$dn,array($fvalue => 
utf8_encode($stock_fields[$fname])));
                                                }
                                                elseif 
($ldap_fields[0][$fvalue] && !$stock_fields[$fname])
                                                {
                                                        /*
                                                        echo "<br>".$fname." 
gone...  deleting - '".$fvalue."'";
                                                        NOTE: we use the 
ldap_fields because we need to send the
                                                        _ORIGINAL_ contents as 
the value. see:
                                                        
http://www.php.net/manual/en/function.ldap-mod-del.php
                                                        */
                                                        $err = 
ldap_mod_del($this->ldap,$dn,array($fvalue => $ldap_fields[0][$fvalue][0]));
                                                }
                                                /* Else we have nothing to do. 
*/
                                        }
                                }

                                //something here to update the last_mod from 
$GLOBALS['phpgw']->datetime->gmtnow

                                while (list($x_name,$x_value) = 
each($extra_fields))
                                {
                                        if ($this->field_exists($id,$x_name))
                                        {
                                                if (! $x_value)
                                                {
                                                        
$this->delete_single_extra_field($id,$x_name);
                                                }
                                                else
                                                {
                                                        
$this->db->query("UPDATE $this->ext_table SET contact_value='" . 
addslashes($x_value)
                                                        . 
"',contact_owner='$owner' WHERE contact_name='" . addslashes($x_name)
                                                        . "' AND 
contact_id='$id'",__LINE__,__FILE__);
                                                }
                                        }
                                        else
                                        {
                                                
$this->add_single_extra_field($id,$owner,$x_name,$x_value);
                                        }
                                }
                        }
                        else
                        {
                                return False;
                        }
                }

                function change_owner($old_owner='',$new_owner='')
                {
                        if (!($new_owner && $old_owner))
                        {
                                return False;
                        }

                        $sri = ldap_search($this->ldap, 
$GLOBALS['phpgw_info']['server']['ldap_contact_context'], 
'phpgwcontactowner='.$old_owner);
                        $ldap_fields = ldap_get_entries($this->ldap, $sri);

                        $entry = '';
                        while (list($null,$entry) = each($ldap_fields))
                        {
                                $err = 
ldap_modify($this->ldap,$dn,array('phpgwcontactowner' => $new_owner));
                        }

                        $this->db->query("UPDATE $this->ext_table SET 
contact_owner='$new_owner' WHERE contact_owner=$owner",__LINE__,__FILE__);
                        return;
                }

                function delete_($id)
                {
                        $response= $GLOBALS['phpgw']->hooks->process(array(
                                                                'location' => 
'delete_addressbook',
                                                                'contact_id' => 
$cid )
                                                        );

                        if( $response )
                        {
                                $return_value = $response;
                        }
                        else
                        {
                                if 
(!$GLOBALS['phpgw_info']['server']['ldap_contact_context'])
                                {
                                        return False;
                                }

                                $sri = ldap_search($this->ldap, 
$GLOBALS['phpgw_info']['server']['ldap_contact_context'], 'uidnumber='.$id);
                                $ldap_fields = ldap_get_entries($this->ldap, 
$sri);

                                if ($ldap_fields[0]['dn'])
                                {
                                        $err = 
ldap_delete($this->ldap,$ldap_fields[0]['dn']);

                                        $this->db->query("DELETE FROM 
$this->ext_table WHERE contact_id='$id' AND contact_owner='"
                                        . $this->account_id . 
"'",__LINE__,__FILE__);
                                        $return_value = False;
                                }
                                else
                                {
                                        return False;
                                }
                        }
                        return $return_value;
                }

                function delete_all($owner=0)
                {
                        if 
(!$GLOBALS['phpgw_info']['server']['ldap_contact_context'])
                        {
                                return False;
                        }

                        if ($owner)
                        {
                                $sri = ldap_search($this->ldap, 
$GLOBALS['phpgw_info']['server']['ldap_contact_context'], 
'phpgwcontactowner='.$owner);
                                $ldap_fields = ldap_get_entries($this->ldap, 
$sri);

                                $entry = '';
                                while (list($null,$entry) =  each($ldap_fields))
                                {
                                        $err = 
ldap_delete($this->ldap,$entry['dn']);
                                }

                                $this->db->query("DELETE FROM $this->ext_table 
WHERE contact_owner=$owner",__LINE__,__FILE__);
                        }
                        return;
                }
        }
?>




reply via email to

[Prev in Thread] Current Thread [Next in Thread]