[Phpgroupware-cvs] phpgwapi/inc/accounts class.accounts_sql.inc.php

[Sigurd Nes]

CVSROOT:        /sources/phpgwapi
Module name:    phpgwapi
Changes by:     Sigurd Nes <sigurdne>   06/12/07 20:10:02

Modified files:
        inc/accounts   : class.accounts_sql.inc.php 

Log message:
        Add a contact_person when adding account

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/phpgwapi/inc/accounts/class.accounts_sql.inc.php?cvsroot=phpgwapi&r1=1.20&r2=1.21

Patches:
Index: class.accounts_sql.inc.php
===================================================================
RCS file: /sources/phpgwapi/phpgwapi/inc/accounts/class.accounts_sql.inc.php,v
retrieving revision 1.20
retrieving revision 1.21
diff -u -b -r1.20 -r1.21
--- class.accounts_sql.inc.php  24 Oct 2006 09:20:17 -0000      1.20
+++ class.accounts_sql.inc.php  7 Dec 2006 20:10:01 -0000       1.21
@@ -8,7 +8,7 @@
        * @license http://www.gnu.org/licenses/lgpl.html GNU Lesser General 
Public License
        * @package phpgwapi
        * @subpackage accounts
-       * @version $Id: class.accounts_sql.inc.php,v 1.20 2006/10/24 09:20:17 
Caeies Exp $
+       * @version $Id: class.accounts_sql.inc.php,v 1.21 2006/12/07 20:10:01 
sigurdne Exp $
        */
 
        /**
@@ -91,7 +91,8 @@
                                                        . "', 
account_lastname='" . $this->data['account_lastname'] . "', account_status='"
                                                        . $this->data['status'] 
. "', account_expires=" . $this->data['expires']
                                                        . 
($this->data['account_lid']?", account_lid='".$this->data['account_lid']."'":'')
-                                                       . 
(isset($this->data['person_id'])?', person_id=' . $this->data['person_id']:'') 
. ', account_quota=' . intval($this->data['quota'])
+                                               //      . 
(isset($this->data['person_id'])?', person_id=' . $this->data['person_id']:'')
+                                                       . ', account_quota=' . 
intval($this->data['quota'])
                                                        . ' WHERE account_id=' 
. intval($this->data['account_id']),__LINE__,__FILE__);
                }
 
@@ -407,6 +408,39 @@
                function create($account_info, $default_prefs = true)
                {
                        $this->set_data($account_info, $default_prefs);
+                       $this->db->transaction_begin();
+                       
+                       $values= array
+                       (
+                               -3,
+                               'public',
+                               1,
+                       );
+
+                       $values = $this->db->validate_insert($values);
+
+                       $this->db->query("INSERT INTO phpgw_contact 
(owner,access,contact_type_id) "
+                               . "VALUES ($values)",__LINE__,__FILE__);
+                       $person_id = 
$this->db->get_last_insert_id('phpgw_contact','contact_id');
+
+                       $values= array
+                       (
+                               $person_id,
+                               $this->db->db_addslashes($this->firstname),
+                               $this->db->db_addslashes($this->lastname),
+                               ((isset($this->status) && $this->status == 'A') 
? 'Y':'N'),
+                               time(),
+                               0,
+                               time(),
+                               0       
+                       );
+
+                       $values = $this->db->validate_insert($values);
+
+                       $this->db->query("INSERT INTO phpgw_contact_person 
(person_id,first_name,last_name,active,created_on,created_by,modified_on,modified_by)
 "
+                               . "VALUES ($values)",__LINE__,__FILE__);
+
+
                        $fields = array('account_lid',
                                                        'account_type',
                                                        'account_pwd',
@@ -424,7 +458,7 @@
                                                        
"'".$this->db->db_addslashes($this->lastname)."'",
                                                        
"'".$this->db->db_addslashes($this->status)."'",
                                                        intval($this->expires),
-                                                       
intval($this->person_id),
+                                                       intval($person_id),
                                                        intval($this->quota)
                                                   );
                        if((int)$this->account_id && 
!$this->exists((int)$this->account_id))
@@ -437,6 +471,7 @@
                                                         __LINE__,__FILE__);
 
                        $account_info['account_id'] = 
$this->db->get_last_insert_id('phpgw_accounts','account_id');
+                       $this->db->transaction_commit();
                        return parent::create($account_info, $default_prefs);
                }