X-Git-Url: https://git.tokkee.org/?a=blobdiff_plain;f=gosa-plugins%2Fgofon%2Fgofon%2Fphoneaccount%2Fclass_phoneAccount.inc;h=cdde338d23707dc1633d2ef41693645db15bd4ef;hb=e673d873a82feeb57a63070e3a6e925d333ea8f9;hp=4be721303bd9718349be1a883cdb83f6b4df2f78;hpb=f91465c311cf7c5e32d5c54b1901150798776263;p=gosa.git diff --git a/gosa-plugins/gofon/gofon/phoneaccount/class_phoneAccount.inc b/gosa-plugins/gofon/gofon/phoneaccount/class_phoneAccount.inc index 4be721303..cdde338d2 100644 --- a/gosa-plugins/gofon/gofon/phoneaccount/class_phoneAccount.inc +++ b/gosa-plugins/gofon/gofon/phoneaccount/class_phoneAccount.inc @@ -3,8 +3,9 @@ class phoneAccount extends plugin { /* Definitions */ - var $plHeadline= "Phone"; + var $plHeadline = "Phone"; var $plDescription= "This does something"; + var $plIcon = "plugins/gofon/images/phoneAccount.png"; /* Attributes */ var $telephoneNumber = array(); @@ -95,7 +96,7 @@ class phoneAccount extends plugin } 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(); + $this->has_mailAccount = &$this->parent->by_object['mailAccount']->is_account; } /* Check server configurations @@ -159,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= ""; @@ -186,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])){ @@ -200,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*/ @@ -210,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']); @@ -396,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){ @@ -659,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, @@ -670,7 +690,9 @@ class phoneAccount extends plugin $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)){ @@ -678,6 +700,7 @@ class phoneAccount extends plugin /********************** * Update Voice mail entry **********************/ + $result = mysql_fetch_assoc($rid) ; foreach($voice_data_array as $name => $value){ @@ -686,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{ @@ -1425,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"; @@ -1576,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"),