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);
}
