plugins/admin/ogroups/class_phonequeue.inc

   1 <?php
   2
   3 class phonequeue extends plugin
   4 {
   5   /* plugin specific values */
   6   var $mail= "";
   7   var $cn= "";
   8
   9
  10   var $goFonTimeOut             ="20";
  11   var $goFonMaxLen              ="20"; //
  12   var $goFonAnnounceFrequency   ="60"; // Annouce Frequency in seconds
  13   var $goFonDialOption_t        ="";
  14   var $goFonDialOption_T        ="";
  15   var $goFonDialOption_h        ="";
  16   var $goFonDialOption_r        ="";
  17   var $goFonQueueAnnounce       ="gonicus-berlin-welcome";
  18   var $goFonDialOption_H        ="";
  19   var $goFonMusiconHold         ="default";
  20   var $goFonWelcomeMusic        ="gonicus-berlin-welcome";
  21   var $goFonQueueReportHold     ="yes";
  22   var $goFonQueueYouAreNext     ="queue-youarenext";
  23   var $goFonQueueThereAre       ="queue-therare";
  24   var $goFonQueueCallsWaiting   ="queue-callswaiting";
  25   var $goFonQueueThankYou       ="queue-thankyou";
  26   var $goFonQueueMinutes        ="queue-minutes";
  27   var $goFonQueueSeconds        ="queue-seconds";
  28   var $goFonQueueLanguage       ="queue-holdtime";
  29   var $goFonQueueStrategy       ="ringall";
  30   var $goFonQueueAnnounceHoldtime="yes";
  31   var $telephoneNumber          =array();
  32   var $goFonQueueMember         =array();
  33   var $goFonDialOption          ="tThH";
  34   var $goFonQueueRetry          =5;
  35
  36   var $old_phone_numbers        =array();
  37
  38   /* attribute list for save action */
  39   var $attributes= array( "goFonTimeOut","goFonMaxLen","goFonAnnounceFrequency","goFonDialOption_t","goFonDialOption_T",
  40       "goFonDialOption_h","goFonDialOption_r",
  41       "goFonDialOption_H","goFonMusiconHold","goFonWelcomeMusic","goFonQueueReportHold","goFonQueueYouAreNext",
  42       "goFonQueueThereAre","goFonQueueCallsWaiting","goFonQueueThankYou","goFonQueueMinutes","goFonQueueSeconds",
  43       "telephoneNumber","goFonQueueLanguage","goFonQueueStrategy","goFonQueueAnnounceHoldtime","goFonQueueAnnounce","goFonDialOption","goFonQueueRetry");
  44   /* ObjectClass */
  45   var $objectclasses= array("goFonQueue");
  46
  47   function phonequeue ($config, $dn= NULL)
  48   {
  49     plugin::plugin($config, $dn);
  50
  51     /* Include config object */
  52     $this->config= $config;
  53
  54     /* Save initial account state */
  55     $this->initially_was_account= $this->is_account;
  56
  57     if($this->is_account){
  58       if(isset($this->attrs['telephoneNumber'])){
  59         $this->telephoneNumber=$this->attrs['telephoneNumber'];
  60         unset($this->telephoneNumber['count']);
  61       }
  62
  63       for($i = 0; $i < strlen($this->goFonDialOption); $i++){
  64         $name = "goFonDialOption_".$this->goFonDialOption[$i];
  65         $this->$name=$this->goFonDialOption[$i];
  66       }
  67     }
  68
  69     $this->old_phone_numbers = $this->telephoneNumber;
  70   }
  71
  72
  73   function execute()
  74   {
  75     /* Do we need to flip is_account state? */
  76     if (isset($_POST['modify_state'])){
  77       $this->is_account= !$this->is_account;
  78     }
  79
  80     /* Show tab dialog headers */
  81     if ($this->parent != NULL){
  82       if ($this->is_account){
  83         $display= $this->show_header(_("Remove the phone queue from this Account"),
  84             _("Phone queue is enabled for this group. You can disable it by clicking below."));
  85       } else {
  86         $display= $this->show_header(_("Create phone queue"), _("For this group the phone queues are disabled. You can enable them by clicking below."));
  87         return ($display);
  88       }
  89     }
  90
  91     /* Add queue number */
  92     if(isset($_POST['add_phonenumber'])&&(isset($_POST['phonenumber']))&&(!empty($_POST['phonenumber']))){
  93       if((!in_array($_POST['phonenumber'],$this->telephoneNumber))&&(is_numeric($_POST['phonenumber']))){
  94         $this->telephoneNumber[]=$_POST['phonenumber'];
  95       }
  96     }
  97
  98     /* Delete queue number */
  99     if(isset($_POST['delete_phonenumber'])&&(isset($_POST['goFonQueueNumber_List']))){
 100       unset($this->telephoneNumber[$_POST['goFonQueueNumber_List']]);
 101     }
 102
 103     $tmp = array();
 104     foreach($this->telephoneNumber as $val){
 105       if(!empty($val)){
 106         $tmp[]= $val;
 107       }
 108     }
 109     $this->telephoneNumber=$tmp;
 110
 111     /* queue number up */
 112     if(isset($_POST['up_phonenumber'])&&(isset($_POST['goFonQueueNumber_List']))){
 113       if($_POST['goFonQueueNumber_List']>0){
 114         $up   = $this->telephoneNumber[$_POST['goFonQueueNumber_List']];
 115         $down = $this->telephoneNumber[$_POST['goFonQueueNumber_List']-1];
 116         $this->telephoneNumber[$_POST['goFonQueueNumber_List']]    = $down;
 117         $this->telephoneNumber[$_POST['goFonQueueNumber_List']-1]  = $up;
 118       }
 119     }
 120
 121     /* Queuenumber down */
 122     if(isset($_POST['down_phonenumber'])&&(isset($_POST['goFonQueueNumber_List']))){
 123       if(isset($this->telephoneNumber[($_POST['goFonQueueNumber_List']+1)])){
 124         $up   = $this->telephoneNumber[$_POST['goFonQueueNumber_List']+1];
 125         $down = $this->telephoneNumber[$_POST['goFonQueueNumber_List']];
 126         $this->telephoneNumber[$_POST['goFonQueueNumber_List']+1]    = $down;
 127         $this->telephoneNumber[$_POST['goFonQueueNumber_List']]  = $up;
 128       }
 129     }
 130
 131
 132     $smarty= get_smarty();
 133
 134     $smarty->assign("goFonQueueLanguageOptions",array('de'=>_('German'),'ur'=>_('Uruguai')));
 135     $smarty->assign("goFonQueueAnnounceHoldtimeOptions",array('no'=>_("No"),'yes'=>_('Yes')));
 136     $smarty->assign("goFonQueueStrategyOptions",array('ringall'    =>_("ring all available channels until one answers"),
 137           'roundrobin' =>_("take turns ringing each available interface"),
 138           'leastrecent'=>_("ring interface which was least recently called by this queue"),
 139           'fewestcalls'=>_("ring the one with fewest completed calls from this queue"),
 140           'random'     =>_("ring random interface"),
 141           'rrmemory'   =>_("round robin with memory, remember where we left off last ring pass")));
 142
 143     foreach($this->attributes as $key => $val){
 144       $smarty->assign($val,$this->$val);
 145
 146       if($this->$val == false){
 147         $smarty->assign($val."CHK","");
 148       }else{
 149         $smarty->assign($val."CHK"," checked ");
 150       }
 151
 152       if(chkacl($this->acl,$key)==""){
 153         $smarty->assign($val."ACL","");
 154       }else{
 155         $smarty->assign($val."ACL"," disabled ");
 156       }
 157     }
 158     return ($display.$smarty->fetch (get_template_path('phonequeue.tpl', TRUE)));
 159   }
 160
 161
 162   /* Check formular input */
 163   function check()
 164   {
 165     $message= array();
 166   #fixme workaround : Tab is not initialised correct
 167           if(!$this->is_account) return($message);
 168
 169     if($this->is_number_used()){
 170       $message[] = $this->is_number_used();
 171     }
 172
 173     if($this->generate_mysql_entension_entries()){
 174       $message[] = $this->generate_mysql_entension_entries();
 175     }
 176
 177     if(!((is_numeric($this->goFonTimeOut))||(empty($this->goFonTimeOut)))){
 178       $message[] = _("Timeout must be numeric");
 179     }
 180     if(!((is_numeric($this->goFonQueueRetry))||(empty($this->goFonQueueRetry)))){
 181       $message[] = _("Retry must be numeric");
 182     }
 183     if(!((is_numeric($this->goFonMaxLen))||(empty($this->goFonMaxLen)))){
 184       $message[] = _("Max queue length must be numeric");
 185     }
 186     if(!((is_numeric($this->goFonAnnounceFrequency))||(empty($this->goFonAnnounceFrequency)))){
 187       $message[] = _("Announce frequency must be numeric");
 188     }
 189     if(count($this->telephoneNumber)==0){
 190       $message[] = _("There must be least one queue number defined.");
 191     }
 192
 193     return $message;
 194   }
 195
 196
 197
 198   function generate_mysql_entension_entries($save = false)
 199   {
 200
 201     $SQL = array();
 202
 203     // Get Configuration for Mysql database Server
 204     $a_SETUP = $_SESSION['config']->data['SERVERS']['FON'];
 205     $s_parameter  ="";
 206
 207     // Connect to DB server
 208     $r_con =  @mysql_pconnect($a_SETUP['SERVER'],$a_SETUP['LOGIN'],$a_SETUP['PASSWORD']);
 209
 210     // Check if we are  connected correctly
 211     if(!$r_con){
 212       gosa_log(mysql_error());
 213       return (sprintf(_("The MySQL Server '%s' isn't reachable as user '%s', check GOsa log for mysql error."),
 214           $a_SETUP['SERVER'],$a_SETUP['LOGIN']));
 215     }
 216
 217     // Select database for Extensions
 218     $db  =  @mysql_select_db($a_SETUP['DB'],$r_con);
 219
 220     // Test if we have the database selected correctly
 221     if(!$db){
 222       gosa_log(mysql_error());
 223       return( sprintf(_("Can't select database %s on %s."),$a_SETUP['DB'],$a_SETUP['SERVER']));
 224     }
 225
 226     if($save){
 227       $i = 0;
 228       $prio = 11;
 229
 230       if(empty($this->cn)){
 231         $this->cn = $this->parent->by_object['ogroup']->cn;
 232         $this->attrs['cn'][0] = $this->parent->by_object['ogroup']->cn;
 233       }
 234
 235       // Delete old Entries
 236       $delete = array();
 237       if(is_array($this->old_phone_numbers)){
 238         foreach($this->old_phone_numbers as $phone){
 239           $delete[]= "DELETE FROM ".$a_SETUP['EXT_TABLE']." WHERE exten='".$phone."';\n";
 240         }
 241       }
 242       $delete[]=    "DELETE FROM ".$a_SETUP['EXT_TABLE']."    WHERE exten='".$this->attrs['cn'][0]."';\n";
 243       $delete[]=    "DELETE FROM ".$a_SETUP['QUEUE_TABLE']."  WHERE name=\"".$this->attrs['cn'][0]."\"; \n";
 244       $delete[]=    "DELETE FROM ".$a_SETUP['QUEUE_MEMBER_TABLE']." WHERE queue_name=\"".$this->attrs['cn'][0]."\";\n";
 245
 246       /* Perform queries to delte old entries */
 247       foreach($delete as $query){
 248         if(!mysql_query($query)){
 249           gosa_log(mysql_error());
 250           return(mysql_error(). sprintf(_("Can't delete in Database %s, on Server %s."),$a_SETUP['DB'],$a_SETUP['SERVER']));
 251         }
 252       }
 253
 254       /* Append new Member for this queue */
 255       $i = 0;
 256       $queueuser =array();
 257       foreach($this->parent->by_object['ogroup']->memberList as $member){
 258         if(in_array("goFonAccount",$member['objectClass'])){
 259           $i ++ ;
 260           $queueuser[$i]['queue_name']  = $this->attrs['cn'][0];
 261           $queueuser[$i]['interface']   = "SIP/".$member['uid'][0];
 262           $queueuser[$i]['penalty']     = 1;
 263         }
 264       }
 265
 266       /* Parse and Add members to query Array */
 267       if(is_array($queueuser)){
 268         foreach($queueuser as $user){
 269           $entries = "";
 270           $values  = "";
 271           foreach($user as $attr => $val){
 272             $entries.= "`".$attr."`,";
 273             $values .= "'".$val."',";
 274           }
 275           $values  = preg_replace("/,$/","",$values);
 276           $entries = preg_replace("/,$/","",$entries );
 277
 278           $SQL[]="INSERT INTO ".$a_SETUP['QUEUE_MEMBER_TABLE']." (".$entries.") VALUES (".$values.")";
 279         }
 280       }
 281
 282
 283       /* generate Extension entries, with priority  */
 284
 285       $queueusers=0;
 286       foreach($this->parent->by_object['ogroup']->memberList as $member){
 287         if(in_array("goFonAccount",$member['objectClass'])){
 288           $queueusers++;
 289         }
 290       }
 291
 292
 293       $i = 0;
 294       foreach($this->telephoneNumber as $num){
 295
 296         // If there are no member in a Queue
 297         // Play sound an quit
 298
 299         // A Queue is not deleted directly, it is stored until the o group is deleted
 300
 301         $a_ext[$i]['context']  = 'GOsa';
 302         $a_ext[$i]['exten']    = $this->attrs['cn'][0];
 303         $a_ext[$i]['priority'] = 1;
 304         $a_ext[$i]['app']      = "Goto";
 305         $a_ext[$i]['appdata']  = $num."|1";
 306         $i ++ ;
 307
 308         if($queueusers == 0){
 309           $a_ext[$i]['context']  = 'GOsa';
 310           $a_ext[$i]['exten']    = $num;
 311           $a_ext[$i]['priority'] = 1;
 312           $a_ext[$i]['app']      = "Wait";
 313           $a_ext[$i]['appdata']  = "2";
 314           $i ++ ;
 315
 316           $a_ext[$i]['context']  = 'GOsa';
 317           $a_ext[$i]['exten']    = $num;
 318           $a_ext[$i]['priority'] = 2;
 319           $a_ext[$i]['app']      = "Playback";
 320           $a_ext[$i]['appdata']  = "ss-noservice";
 321           $i ++ ;
 322
 323           $a_ext[$i]['context']  = 'GOsa';
 324           $a_ext[$i]['exten']    = $num;
 325           $a_ext[$i]['priority'] = 3;
 326           $a_ext[$i]['app']      = "Goto";
 327           $a_ext[$i]['appdata']  = "default";
 328           $i ++ ;
 329         }else{
 330           $prio --;
 331           $a_ext[$i]['context']  = 'GOsa';
 332           $a_ext[$i]['exten']    = $num;
 333           $a_ext[$i]['priority'] = 1;
 334           $a_ext[$i]['app']      = "Wait";
 335           $a_ext[$i]['appdata']  = "2";
 336           $i ++ ;
 337           $a_ext[$i]['context']  = 'GOsa';
 338           $a_ext[$i]['exten']    = $num;
 339           $a_ext[$i]['priority'] = 2;
 340           $a_ext[$i]['app']      = "Set";
 341           $a_ext[$i]['appdata']  = "LANGUAGE|".$this->goFonQueueLanguage;
 342           $i ++ ;
 343           $a_ext[$i]['context']  = 'GOsa';
 344           $a_ext[$i]['exten']    = $num;
 345           $a_ext[$i]['priority'] = 3;
 346           $a_ext[$i]['app']      = "Playback";
 347           $a_ext[$i]['appdata']  = $this->goFonWelcomeMusic;
 348           $i ++ ;
 349           $a_ext[$i]['context']  = 'GOsa';
 350           $a_ext[$i]['exten']    = $num;
 351           $a_ext[$i]['priority'] = 4;
 352           $a_ext[$i]['app']      = "SetCIDName";
 353           if(!empty($this->parent->by_object['ogroup']->description)){
 354             $a_ext[$i]['appdata']  = $this->parent->by_object['ogroup']->description;
 355           }else{
 356             $a_ext[$i]['appdata']  = $this->attrs['cn'][0]." - ".$num;
 357           }
 358           $i ++ ;
 359           $a_ext[$i]['context']  = 'GOsa';
 360           $a_ext[$i]['exten']    = $num;
 361           $a_ext[$i]['priority'] = 5;
 362           $a_ext[$i]['app']      = "Queue";
 363           $a_ext[$i]['appdata']  =  $this->attrs['cn'][0].
 364             "|".
 365             $this->goFonDialOption_t.
 366             $this->goFonDialOption_T.
 367             $this->goFonDialOption_h.
 368             $this->goFonDialOption_H.
 369             $this->goFonDialOption_r;
 370         }
 371
 372         /* Generate Priority Entry */
 373         $queue["announce"]              = "";
 374         $queue["monitor_join"]          = "";
 375         $queue["monitor_format"]        = "";
 376         $queue["queue_holdtime"]        = $this->goFonQueueAnnounce;
 377         $queue["queue_lessthan"]        = "";
 378         $queue["announce_round_seconds"]= "";
 379         $queue["retry"]                 = $this->goFonQueueRetry;
 380         $queue["wrapuptime"]            = "";
 381         $queue["servicelevel"]          = "";
 382         $queue["joinempty"]             = "no";
 383         $queue["leavewhenempty"]        = "yes";
 384         $queue["eventmemberstatus"]     = "";
 385         $queue["eventwhencalled"]       = "";
 386         $queue["reportholdtime"]        = "yes";
 387         $queue["memberdelay"]           = "";
 388         $queue["weight"]                = "";
 389         $queue["timeoutrestart"]        = "";
 390
 391         $queue["context"]               = "default";
 392         $queue["name"]                  = $this->attrs['cn'][0];
 393         $queue["timeout"]               = $this->goFonTimeOut;
 394         $queue["maxlen"]                = $this->goFonMaxLen;
 395         $queue["strategy" ]             = $this->goFonQueueStrategy;
 396         $queue["queue_thankyou"]        = $this->goFonQueueThankYou;
 397         $queue["queue_reporthold"]      = $this->goFonQueueReportHold;
 398         $queue["announce_frequency"]    = $this->goFonAnnounceFrequency;
 399         $queue["queue_youarenext"]      = $this->goFonQueueYouAreNext;
 400         $queue["queue_thereare"]        = $this->goFonQueueThereAre;
 401         $queue["queue_callswaiting"]    = $this->goFonQueueCallsWaiting;
 402         $queue["queue_minutes"]         = $this->goFonQueueMinutes;
 403         $queue["queue_seconds"]         = $this->goFonQueueSeconds;
 404         $queue["announce_holdtime"]     = $this->goFonQueueAnnounceHoldtime;
 405         $queue["musiconhold"]           = $this->goFonMusiconHold;
 406
 407         $i++;
 408       }
 409
 410       /* Parse and Add Extension entries */
 411       foreach($a_ext as $ext){
 412         $entries = "";
 413         $values  = "";
 414         foreach($ext as $attr => $val){
 415           $entries.= "`".$attr."`,";
 416           $values .= "'".$val."',";
 417         }
 418         $values  = preg_replace("/,$/","",$values);
 419         $entries = preg_replace("/,$/","",$entries );
 420         $SQL[]="INSERT INTO ".$a_SETUP['EXT_TABLE']." (".$entries.") VALUES (".$values.")";
 421       }
 422
 423
 424       /* Parse and Add Queue */
 425       $entries = "";
 426       $values  = "";
 427       foreach($queue as $attr=>$val){
 428         if($val == "") continue;
 429         $entries.= "`".$attr."`,";
 430         $values .= "'".$val."',";
 431       }
 432       $values  = preg_replace("/,$/","",$values);
 433       $entries = preg_replace("/,$/","",$entries );
 434       $SQL[]="INSERT INTO ".$a_SETUP['QUEUE_TABLE']." (".$entries.") VALUES (".$values.")";
 435
 436       foreach($SQL as $query){
 437          if(!mysql_query($query)){
 438           gosa_log(mysql_error());
 439           print_red(mysql_error());
 440           return(mysql_error(). sprintf(_("Can't delete in Database %s, on Server %s."),$a_SETUP['DB'],$a_SETUP['SERVER']));
 441         }
 442       }
 443
 444     }
 445     return(false);
 446   }
 447
 448
 449
 450  /* This function checks if the given phonenumbers are available or already in use*/
 451
 452   function is_number_used()
 453   {
 454     $ldap= $this->config->get_ldap_link();
 455     $ldap->cd($this->config->current['BASE']);
 456     $ldap->search("(|(objectClass=goFonAccount)(objectClass=goFonQueue))", array("telephoneNumber","cn","uid"));
 457     while($attrs = $ldap->fetch()) {
 458       unset($attrs['telephoneNumber']['count']);
 459       foreach($attrs['telephoneNumber'] as $tele){
 460         if(!isset($attrs['cn'][0])) $attrs['cn'][0]=$attrs['dn'];
 461         if(!isset($attrs['uid'][0])) $attrs['uid'][0]=$attrs['dn'];
 462         $numbers[$tele]=$attrs;
 463       }
 464     }
 465
 466     foreach($this->telephoneNumber as $num){
 467       if((isset($numbers[$num]))&&(($numbers[$num]['cn'][0]!= $this->attrs['cn'][0]))){
 468         if(isset($numbers[$num]['uid'][0])){
 469           return sprintf(_("The specified telephonenumber '%s' is already assigned to '%s'."),$num,$numbers[$num]['uid'][0]);
 470         }else{
 471           return sprintf(_("The specified telephonenumber '%s' is already assigned to '%s'."),$num,$numbers[$num]['cn'][0]);
 472         }
 473       }
 474     }
 475   }
 476
 477
 478
 479
 480
 481   function save_object()
 482   {
 483     plugin::save_object();
 484     if(isset($_POST['phonenumber'])){
 485       foreach(array("goFonDialOption_t","goFonDialOption_T","goFonDialOption_h","goFonDialOption_r","goFonDialOption_H","goFonMusiconHold") as $val){
 486         if(isset($_POST[$val])){
 487           $this->$val = $_POST[$val];
 488         }else{
 489           $this->$val = false;
 490         }
 491       }
 492     }
 493
 494   }
 495
 496   function save()
 497   {
 498   #fixme workaround : Tab is not initialised correct
 499         if(!$this->is_account) return;
 500     $ldap= $this->config->get_ldap_link();
 501
 502     plugin::save();
 503     $this->attrs['goFonDialOption'] = "";
 504     foreach(array("goFonDialOption_t","goFonDialOption_T","goFonDialOption_r","goFonDialOption_h","goFonDialOption_H") as $val){
 505       $this->attrs['goFonDialOption'].=$this->$val;
 506       unset($this->attrs[$val]);
 507     }
 508     $this->generate_mysql_entension_entries(true);
 509     if($this->attrs['goFonDialOption']=="") $this->attrs['goFonDialOption']=array();
 510
 511     /* Save data to LDAP */
 512     $ldap->cd($this->dn);
 513     $ldap->modify($this->attrs);
 514
 515     show_ldap_error($ldap->get_error());
 516
 517     /* Optionally execute a command after we're done */
 518     if ($this->initially_was_account == $this->is_account){
 519       if ($this->is_modified){
 520         $this->handle_post_events("mofify");
 521       }
 522     } else {
 523       $this->handle_post_events("add");
 524     }
 525   }
 526
 527
 528   /* remove object from parent */
 529   function remove_from_parent()
 530   {
 531     $SQL = array();
 532
 533     // Get Configuration for Mysql database Server
 534     $a_SETUP = $_SESSION['config']->data['SERVERS']['FON'];
 535     $s_parameter  ="";
 536
 537     // Connect to DB server
 538     $r_con =  @mysql_pconnect($a_SETUP['SERVER'],$a_SETUP['LOGIN'],$a_SETUP['PASSWORD']);
 539
 540     // Check if we are  connected correctly
 541     if(!$r_con){
 542       gosa_log(mysql_error());
 543       return (sprintf(_("The MySQL Server '%s' isn't reachable as user '%s', check GOsa log for mysql error."),
 544             $a_SETUP['SERVER'],$a_SETUP['LOGIN']));
 545     }
 546
 547     // Select database for Extensions
 548     $db  =  @mysql_select_db($a_SETUP['DB'],$r_con);
 549
 550     // Test if we have the database selected correctly
 551     if(!$db){
 552       gosa_log(mysql_error());
 553       return( sprintf(_("Can't select database %s on %s."),$a_SETUP['DB'],$a_SETUP['SERVER']));
 554     }
 555
 556     $tmp = array_flip($this->attributes);
 557     foreach(array("goFonDialOption_t","goFonDialOption_T","goFonDialOption_r","goFonDialOption_h","goFonDialOption_H") as $val){
 558       unset($this->$val);
 559       unset($this->attrs[$val]);
 560       unset($tmp[$val]);
 561     }
 562     foreach(array_flip($tmp) as $key => $val){
 563       $tmp2[]=$val;
 564     }
 565     $this->attributes = $tmp2;
 566
 567     $i = 0;
 568     $prio = 11;
 569
 570     if(empty($this->cn)){
 571       $this->cn = $this->parent->by_object['ogroup']->cn;
 572       $this->attrs['cn'][0] = $this->parent->by_object['ogroup']->cn;
 573     }
 574
 575     // Delete old Entries
 576     $delete = array();
 577     foreach($this->old_phone_numbers as $phone){
 578       $delete[]= "DELETE FROM ".$a_SETUP['EXT_TABLE']." WHERE exten='".$phone."';\n";
 579     }
 580     $delete[]=    "DELETE FROM ".$a_SETUP['EXT_TABLE']."    WHERE exten='".$this->attrs['cn'][0]."';\n";
 581     $delete[]=    "DELETE FROM ".$a_SETUP['QUEUE_TABLE']." WHERE name=\"".$this->attrs['cn'][0]."\"; \n";
 582     $delete[]=    "DELETE FROM ".$a_SETUP['QUEUE_MEMBER_TABLE']." WHERE queue_name=\"".$this->attrs['cn'][0]."\";\n";
 583
 584     /* Perform queries to delte old entries */
 585     foreach($delete as $query){
 586       if(!mysql_query($query)){
 587         gosa_log(mysql_error());
 588         return(mysql_error(). sprintf(_("Can't delete in Database %s, on Server %s."),$a_SETUP['DB'],$a_SETUP['SERVER']));
 589       }
 590     }
 591
 592
 593
 594     /* Cancel if there's nothing to do here */
 595     if (!$this->initially_was_account){
 596       return;
 597     }
 598
 599     /* include global link_info */
 600     $ldap= $this->config->get_ldap_link();
 601
 602     /* Remove and write to LDAP */
 603     plugin::remove_from_parent();
 604
 605     @DEBUG (DEBUG_LDAP, __LINE__, __FUNCTION__, __FILE__,
 606         $this->attributes, "Save");
 607     $ldap->cd($this->dn);
 608     $ldap->modify($this->attrs);
 609     show_ldap_error($ldap->get_error());
 610   }
 611
 612 }
 613
 614 // vim:tabstop=2:expandtab:shiftwidth=2:filetype=php:syntax:ruler:
 615 ?>