X-Git-Url: https://git.tokkee.org/?a=blobdiff_plain;f=gosa-plugins%2Fgofon%2Fgofon%2Fphoneaccount%2Fclass_phoneAccount.inc;h=cdde338d23707dc1633d2ef41693645db15bd4ef;hb=e673d873a82feeb57a63070e3a6e925d333ea8f9;hp=d2b2029a640893e540266f526622b6f785a28052;hpb=363cc978ac284e553354f6693d8dbc083d8b08e6;p=gosa.git diff --git a/gosa-plugins/gofon/gofon/phoneaccount/class_phoneAccount.inc b/gosa-plugins/gofon/gofon/phoneaccount/class_phoneAccount.inc index d2b2029a6..cdde338d2 100644 --- a/gosa-plugins/gofon/gofon/phoneaccount/class_phoneAccount.inc +++ b/gosa-plugins/gofon/gofon/phoneaccount/class_phoneAccount.inc @@ -3,9 +3,9 @@ class phoneAccount extends plugin { /* Definitions */ - var $plHeadline= "Phone"; + var $plHeadline = "Phone"; var $plDescription= "This does something"; - var $has_mailAccount= FALSE; + var $plIcon = "plugins/gofon/images/phoneAccount.png"; /* Attributes */ var $telephoneNumber = array(); @@ -38,14 +38,18 @@ class phoneAccount extends plugin var $CopyPasteVars = array("phoneNumbers","macroarray","macrostillavailable"/*"phoneNumbers" -Reset- */, "hardware_list","used_hardware"); - var $attributes = array("goFonDeliveryMode", "goFonFormat","cn","goFonHomeServer", + var $attributes = array("goFonDeliveryMode", "goFonFormat","goFonHomeServer", "goFonHardware","goFonPIN","goFonVoicemailPIN","telephoneNumber", "goFonMacro","macro"); var $objectclasses= array("goFonAccount"); var $uid; + var $cn; var $view_logged = FALSE; var $multiple_support = TRUE; + var $mailAddress = ""; + var $has_mailAccount = FALSE; + var $pager = ""; function phoneAccount (&$config, $dn= NULL, $parent= NULL) { @@ -59,36 +63,41 @@ class phoneAccount extends plugin } } - /* Set up has_mailAccount */ - if (isset($this->attrs['objectClass'])){ - if (in_array("gosaMailAccount", $this->attrs['objectClass'])){ - $this->has_mailAccount= TRUE; - } - } - /* Set parent object to tab object */ if(is_object($parent)){ $this->parent = $parent->parent; - }else{ + } - /* Workaround ... - FIXME, * If there is time, split this code into class_voip.inc and class_phoneaccount.inc - This code is to much to be comprehensible and understandable. - * We don't need a parent object here, we just need a reference to the users uid and cn. - - */ - $this->parent = new usertabs($this->config, - $this->config->data['TABS']['USERTABS'],$this->dn); + /* Get current uid and cn + */ + if(isset($this->attrs['uid'][0])){ + $this->uid = $this->attrs['uid'][0]; + } + if(isset($this->attrs['cn'][0])){ + $this->cn = $this->attrs['cn'][0]; + } + if(isset($this->attrs['mail'][0])){ + $this->mailAddress = $this->attrs['mail'][0]; + } + if(isset($this->attrs['pager'][0])){ + $this->pager = $this->attrs['pager'][0]; } - /* Set uid */ - if((isset($this->parent->by_object['user']->uid))&&(!empty($this->parent->by_object['user']->uid))){ - $this->uid = $this->parent->by_object['user']->uid; + /* If there is a parent object present, use references + */ + if(isset($this->parent->by_object['user']->uid)){ + $this->uid = &$this->parent->by_object['user']->uid; } - if((isset($this->parent->by_object['user']->cn))&&(!empty($this->parent->by_object['user']->cn))){ - $this->cn = $this->parent->by_object['user']->cn; + if(isset($this->parent->by_object['user']->cn)){ + $this->cn =&$this->parent->by_object['user']->cn; + } + if(isset($this->parent->by_object['user']->pager)){ + $this->pager =&$this->parent->by_object['user']->pager; + } + if(isset($this->parent->by_object['mailAccount']->mail)){ + $this->mailAddress = &$this->parent->by_object['mailAccount']->mail; + $this->has_mailAccount = &$this->parent->by_object['mailAccount']->is_account; } - /* Check server configurations * Load all server configuration in $this->goFonHomeServers if available @@ -151,7 +160,7 @@ class phoneAccount extends plugin * Search for all available phone hardware */ $tmp = get_sub_list("(objectClass=goFonHardware)","phone",array(get_ou("phoneou")), - $this->config->current['BASE'],array("cn","description"), GL_NO_ACL_CHECK); + $this->config->current['BASE'],array("cn","description"), GL_SUBSEARCH); foreach($tmp as $attrs){ $cn= $attrs['cn'][0]; $description= ""; @@ -178,7 +187,7 @@ class phoneAccount extends plugin get_ou("phoneou")); $tmp = get_sub_list("(goFonHardware=*)","phone",$deps_a,$this->config->current['BASE'], - array('cn','dn','goFonHardware'),GL_NO_ACL_CHECK); + array('cn','dn','goFonHardware'),GL_SUBSEARCH); foreach($tmp as $attrs){ $cn = $attrs['goFonHardware'][0]; if(isset($this->hardware_list[$cn])){ @@ -192,7 +201,7 @@ class phoneAccount extends plugin * an array with name and parameters */ $tmp = get_sub_list("(&(objectClass=goFonMacro)(goFonMacroVisible=1))","gofonmacro",array(get_ou("macroou")), - $this->config->current['BASE'],array("displayName","goFonMacroParameter","dn","cn"), GL_NONE); + $this->config->current['BASE'],array("displayName","goFonMacroParameter","dn","cn"), GL_NO_ACL_CHECK | GL_SUBSEARCH ); /* Add none for no macro*/ @@ -202,6 +211,16 @@ class phoneAccount extends plugin /* Fetch all Macros*/ foreach($tmp as $attrs){ + $ui = get_userinfo(); + $acl = $ui->get_permissions($attrs['dn'],"gofonmacro/macro",""); + + /* Skip all macros we are not able to read + execpt, the currently selected macro. + */ + if(!preg_match("/r/",$acl) && !preg_match("/^".normalizePreg($attrs['dn'])."/",$this->goFonMacro)){ + continue; + } + /* unset Count, we don't need that here */ unset($attrs['displayName']['count']); @@ -388,8 +407,6 @@ class phoneAccount extends plugin $i_is_accounted = false; // Ensure that extension entry, for name to number is only once in table - restore_error_handler(); - /* Prepare some basic attributes */ $oldnums = array(); foreach($this->a_old_telenums as $tele){ @@ -399,13 +416,9 @@ class phoneAccount extends plugin $newnums[]= preg_replace("/[^0-9]/","",$tele); } - /* If deletion starts from userslist, cn uid are not set */ - if((isset($this->parent->by_object['user']->uid))&&(!empty($this->parent->by_object['user']->uid))){ - $this->uid = $this->parent->by_object['user']->uid; - } - if((isset($this->parent->by_object['user']->cn))&&(!empty($this->parent->by_object['user']->cn))){ - $this->cn = $this->parent->by_object['user']->cn; - } + if(empty($this->uid)) trigger_error("Uid is empty."); + + /* Create voicemail entry */ if((!isset($this->cn))||(empty($this->cn))){ @@ -414,11 +427,11 @@ class phoneAccount extends plugin $CNname= $this->cn; } - if((isset($this->parent))&&(isset($this->parent->by_object['mailAccount']))&&($this->parent->by_object['mailAccount']->is_account==true)){ - $s_mail = $this->parent->by_object['mailAccount']->mail; - }else{ - $s_mail = ""; + $s_mail = ""; + if($this->has_mailAccount){ + $s_mail = $this->mailAddress;; } + /* Get phonehardware to setup sip entry */ $ldap = $this->config->get_ldap_link(); $r_res = $ldap->search("(&(objectClass=goFonHardware)(cn=".$this->goFonHardware."))", array('*')); @@ -655,6 +668,17 @@ class phoneAccount extends plugin $customer_id = $newnums[$i_new_key]; + $query = "SELECT id,name,callerid FROM ".$a_New['SIP_TABLE']." WHERE name='".$this->uid."';"; + + $rid = mysql_query($query,$new_connection); + @DEBUG (DEBUG_MYSQL, __LINE__, __FUNCTION__, __FILE__,$query, "Database query"); + $result = mysql_fetch_assoc($rid); + + $old_customer_id = ""; + if($result){ + $old_customer_id = $result['callerid']; + } + $voice_data_array = array( "customer_id" => $customer_id, "mailbox" => $customer_id, @@ -663,13 +687,12 @@ class phoneAccount extends plugin "context" => $this->voice_context, "email" => $s_mail); - /* Set pager number if available */ - if(isset($this->parent->by_object['user']->pager)){ - $voice_data_array['pager'] = $this->parent->by_object['user']->pager; - } + $voice_data_array['pager'] = $this->pager; /* Check if there is already an entry in sip_users for this uid */ - $query_tmp = "SELECT * FROM ".$a_New['VOICE_TABLE']." WHERE customer_id='".$customer_id."';\n"; + $query_tmp = "SELECT * FROM ".$a_New['VOICE_TABLE']." WHERE customer_id='".$old_customer_id."';\n"; + + $rid = mysql_query($query_tmp,$new_connection); @DEBUG (DEBUG_MYSQL, __LINE__, __FUNCTION__, __FILE__,$query_tmp, "Database query"); if(mysql_affected_rows($new_connection)){ @@ -677,6 +700,7 @@ class phoneAccount extends plugin /********************** * Update Voice mail entry **********************/ + $result = mysql_fetch_assoc($rid) ; foreach($voice_data_array as $name => $value){ @@ -685,14 +709,14 @@ class phoneAccount extends plugin } } - /* Only update entry if there is something to uopdate */ + /* Only update entry if there is something to update */ if(count($voice_data_array)){ $query = "UPDATE ".$a_New['VOICE_TABLE']." SET "; foreach($voice_data_array as $key => $val){ $query.= "".$key."='".$val."',"; } $query = preg_replace("/,$/","",$query); - $query.= " WHERE customer_id='".$customer_id."';"; + $query.= " WHERE customer_id='".$old_customer_id."';"; $SQL_query_array[] = $query; } }else{ @@ -846,6 +870,7 @@ class phoneAccount extends plugin $display = ""; $SkipWrite = (!isset($this->parent) || !$this->parent) && !session::is_set('edit'); + if(empty($this->macro)&&(!empty($this->goFonMacro))){ /* Go through already saved values, for a parameter */ @@ -1066,7 +1091,7 @@ class phoneAccount extends plugin /* Assign acls */ $tmp = $this->plInfo(); foreach($tmp['plProvidedAcls'] as $name => $translation){ - $smarty->assign($name."ACL",$this->getacl($name)); + $smarty->assign($name."ACL",$this->getacl($name,$SkipWrite)); } /* Transfer ACL's */ @@ -1225,12 +1250,12 @@ class phoneAccount extends plugin } } if(array_differs($old_macro_settings,$this->macroarray[$this->macro][$key])){ - $this->modified = TRUE; + $this->is_modified = TRUE; } } if(count(array_diff($this->macroarray[$this->macro][$key],$backup))){ - $this->modified = TRUE; + $this->is_modified = TRUE; } } } @@ -1385,12 +1410,6 @@ class phoneAccount extends plugin { if(!$this->initially_was_account) return; - foreach($this->attributes as $key=>$val){ - if(in_array($val,array("uid","cn"))){ - unset($this->attributes[$key]); - unset($this->$val); - } - } if(count($this->goFonHomeServers) && !empty($this->init_HomeServer) && is_callable("mysql_pconnect")){ // Get Configuration for initial Mysql database Server @@ -1419,14 +1438,6 @@ class phoneAccount extends plugin $SQL=""; - /* If deletion starts from userslist, cn uid are not set */ - if((isset($this->parent->by_object['user']->uid))&&(!empty($this->parent->by_object['user']->uid))){ - $this->uid = $this->parent->by_object['user']->uid; - } - - if((isset($this->parent->by_object['user']->cn))&&(!empty($this->parent->by_object['user']->cn))){ - $this->cn = $this->parent->by_object['user']->cn; - } $first_num = false; // Delete old entries @@ -1437,7 +1448,17 @@ class phoneAccount extends plugin $SQL[] = "DELETE FROM ".$a_SETUP['EXT_TABLE']." WHERE exten='".$s_telenums."';\n"; } - $SQL[] = "DELETE FROM ".$a_SETUP['VOICE_TABLE']." WHERE customer_id='".$first_num."';"; + + $query = "SELECT id,name,callerid FROM ".$a_SETUP['SIP_TABLE']." WHERE name='".$this->uid."';"; + $rid = mysql_query($query,$r_con); + @DEBUG (DEBUG_MYSQL, __LINE__, __FUNCTION__, __FILE__,$query, "Database query"); + $result = mysql_fetch_assoc($rid); + $callerid = $first_num; + if($result){ + $callerid = $result['callerid']; + } + + $SQL[] = "DELETE FROM ".$a_SETUP['VOICE_TABLE']." WHERE customer_id='".$callerid."';"; $SQL[] = "DELETE FROM ".$a_SETUP['EXT_TABLE']." WHERE exten='".$this->uid."';\n"; $SQL[] = "DELETE FROM ".$a_SETUP['SIP_TABLE']." WHERE name='".$this->uid."';\n"; @@ -1517,8 +1538,6 @@ class phoneAccount extends plugin } foreach($this->phoneNumbers as $num){ - if(!isset($this->cn)) $this->cn = ""; - if((isset($numbers[$num]))&&(($numbers[$num]['uid'][0]!=$this->uid))){ if(isset($numbers[$num]['uid'][0])){ return sprintf(_("The specified telephonenumber '%s' is already assigned to '%s'."),$num,$numbers[$num]['uid'][0]); @@ -1590,9 +1609,9 @@ class phoneAccount extends plugin "plProvidedAcls" => array( "telephoneNumber" => _("Telephone number"), - "goFonHomeServer" => _("Home server"), "goFonMacro" => _("Macro settings"), "goFonHardware" => _("Phone hardware"), + "goFonHomeServer" => _("Home server"), "goFonContext" => _("Phone context"), "goFonVoiceMailContext" => _("Voice mail context"), "goFonPIN" => _("Telephone pin"), @@ -1667,7 +1686,7 @@ class phoneAccount extends plugin } } if(count(array_diff($this->macroarray[$this->macro][$key],$backup))){ - $this->modified = TRUE; + $this->is_modified = TRUE; } } }