function deleteUserOrganization($idUser) { $pACL = new paloACL($this->_DB); $pEmail = new paloEmail($this->_DB); $pFax = new paloFax($this->_DB); $Exito = false; //1)se comprueba de que el ID de USUARIO se un numero //2)se verifica que exista dicho usuario //3)se recompila los datos del usuario de las tablas acl_user y user_properties //4)se elimina al usuario de la base //5)se elimina la extension de uso del usuario y la extension de fax //6)se trata de eliminar la cuenta de fax //7)se elimina el buzon de correo if (!preg_match('/^[[:digit:]]+$/', "{$idUser}")) { $this->errMsg = _tr("User ID is not numeric"); return false; } else { $arrUser = $pACL->getUsers($idUser); if ($arrUser === false || count($arrUser) == 0) { $this->errMsg = _tr("User dosen't exist"); return false; } } $idDomain = $arrUser[0][4]; $query = "Select domain from organization where id=?"; $getDomain = $this->_DB->getFirstRowQuery($query, false, array($idDomain)); if ($getDomain == false) { $this->errMsg = $this->_DB->errMsg; return false; } $pDevice = new paloDevice($getDomain[0], "sip", $this->_DB); $arrExten = $pDevice->getExtension($arrUser[0][5]); $faxList = $pFax->getFaxList($arrUser[0][6], $getDomain[0]); $arrFaxExten = $faxList[0]; $this->_DB->beginTransaction(); //tomamos un backup de las extensiones que se van a eliminar de la base astDB por si algo sale mal //y ahi que restaurar la extension $arrExt = $pDevice->backupAstDBEXT($arrUser[0][5]); if ($pDevice->deleteExtension($arrUser[0][5])) { if ($pFax->deleteFaxByUser($idUser)) { if ($pACL->deleteUser($idUser)) { if ($pEmail->deleteAccount($arrUser[0][1])) { $Exito = true; $this->_DB->commit(); $pDevice->tecnologia->prunePeer($arrExten["device"], $arrExten["tech"]); $pDevice->tecnologia->prunePeer($arrFaxExten["device"], $arrFaxExten["tech"]); $pFax->restartService(); } else { $this->errMsg = _tr("Email Account cannot be deleted") . $pEmail->errMsg; $this->_DB->rollBack(); $pDevice->restoreBackupAstDBEXT($arrExt); $pFax->createFaxFileConfig($arrFaxExten['dev_id'], $getDomain[0]); } } else { $this->errMsg = $pACL->errMsg; $this->_DB->rollBack(); $pDevice->restoreBackupAstDBEXT($arrExt); $pFax->createFaxFileConfig($arrFaxExten['dev_id'], $getDomain[0]); } } else { $this->errMsg = _tr("Fax cannot be deleted") . $pFax->errMsg; $this->_DB->rollBack(); $pDevice->restoreBackupAstDBEXT($arrExt); } } else { $this->errMsg = _tr("User Extension can't be deleted") . $pDevice->errMsg; $this->_DB->rollBack(); $pDevice->restoreBackupAstDBEXT($arrExt); } return $Exito; }
function deleteExten($smarty, $module_name, $local_templates_dir, $pDB, $arrConf, $credentials) { $pExten = new paloSantoExtensions($pDB); $error = ""; $continuar = true; $exito = false; $idExten = getParameter("id_exten"); //obtenemos la informacion de la extension por el id dado, en caso de que la extensionpertenzca a un usuario activo //esta no puede volver a ser borrada if (!isset($idExten)) { $smarty->assign("mb_title", _tr("ERROR")); $smarty->assign("mb_message", _tr("Invalid Exten")); return reportExten($smarty, $module_name, $local_templates_dir, $pDB, $arrConf, $credentials); } $domain = getParameter('organization'); if ($credentials['userlevel'] != 'superadmin') { $domain = $credentials['domain']; } $arrExten = $pExten->getExtensionById($idExten, $domain); if ($arrExten === false) { $smarty->assign("mb_title", _tr("ERROR")); $smarty->assign("mb_message", _tr($pExten->errMsg)); return reportExten($smarty, $module_name, $local_templates_dir, $pDB, $arrConf, $credentials); } else { if (count($arrExten) == 0) { $smarty->assign("mb_title", _tr("ERROR")); $smarty->assign("mb_message", _tr("Extension doesn't exist")); return reportExten($smarty, $module_name, $local_templates_dir, $pDB, $arrConf, $credentials); } else { //commprobamos que la extension no le pertenezca a nigun usuario $query = "Select username from acl_user where extension=? and id_group in (select g.id from acl_group g join organization o on g.id_organization=o.id where o.domain=?)"; $result = $pDB->getFirstRowQuery($query, false, array($arrExten["exten"], $arrExten["domain"])); if ($result === false) { $error = $pDB->errMsg; } elseif (count($result) > 0) { $error = _tr("Extension can't be deleted because bellow to user ") . $result[0]; } else { $pDevice = new paloDevice($domain, $arrExten["technology"], $pDB); $pDB->beginTransaction(); $exito = $pDevice->deleteExtension($arrExten["exten"]); if ($exito) { $pDB->commit(); //recargamos la configuracion en realtime para que tomen efecto los cambios hechos en el dispositivo $pDevice->tecnologia->prunePeer($arrExten["device"], $arrExten["technology"]); } else { $pDB->rollBack(); } } } } if ($exito) { $smarty->assign("mb_title", _tr("MESSAGE")); $smarty->assign("mb_message", _tr("The extensions was deleted successfully")); //mostramos el mensaje para crear los archivos de configuracion $pAstConf = new paloSantoASteriskConfig($pDB); $pAstConf->setReloadDialplan($domain, true); } else { $smarty->assign("mb_title", _tr("ERROR")); $smarty->assign("mb_message", _tr($error)); } return reportExten($smarty, $module_name, $local_templates_dir, $pDB, $arrConf, $credentials); }