setLimit($limit);
$oGrid->setTotal($total);
$offset = $oGrid->calculateOffset();
$end = $oGrid->getEnd();
$nombre_archivos = array_slice($total_archivos, $offset, $limit);
//Fin Paginacion
// obtencion de parametros desde la base
$pFTPBackup = new paloSantoFTPBackup($pDB);
$_DATA = $pFTPBackup->getStatusAutomaticBackupById(1);
if(count($_DATA)==0){
$_DATA['status'] = "DISABLED";
}
$_DATADEL = $pFTPBackup->getStatusAutomaticBackupById(2);
if(count($_DATADEL)==0){
$_DATADEL['status'] = "DISABLED";
}
$arrData = null;
$core_dir=dirname(__FILE__)."/../../admin/modules/core/module.xml";
$xml = simplexml_load_string(file_get_contents($core_dir));
$issabelPBX_current_version = $xml->version;
$partes = explode(".",$issabelPBX_current_version);
$issabelPBX_current_version = implode(".",array_slice($partes,0,2));
if(is_array($nombre_archivos) && $total>0){
foreach($nombre_archivos as $key => $nombre_archivo) {
// Control to see if its an old elastix system to migrate, or a new issabel system to restore
$versions = '';
$manifest = '';
$migrate = 0;
$migratefpbx = 0;
$migrateold = 0;
$decrypt=0;
$dirarchi = $dir_backup."/".$nombre_archivo;
if(is_file($dirarchi)) {
$versions = `tar Oxvf $dirarchi backup/versions.xml`;
$manifest = `tar Oxvf $dirarchi ./manifest`;
if(preg_match("/freepbx/",$versions)) {
$migrate=1;
} elseif (preg_match("/pbx_framework_version/",$manifest)) {
$migratefpbx=1;
} else {
$migrate=0;
}
if(preg_match("/\d{4}\d{2}\d{2}\d{2}\d{2}\d{2}.*.aes256/",$nombre_archivo)){
$decrypt=1;
}
// Get the backup issabelPBX version
$xml = simplexml_load_string($versions);
$i=0;
$checkidx=0;
foreach($xml->program as $idx) {
foreach($xml->program[$i]->attributes() as $a => $b) {
if($a=='id' && $b=='issabelpbx') {
$checkidx = $i;
}
}
$i++;
}
$issabelPBX_backup_version = $xml->program[$checkidx]->attributes()->ver;
$partes = explode(".",$issabelPBX_backup_version);
$issabelPBX_backup_version = implode(".",array_slice($partes,0,2));
if(version_compare($issabelPBX_backup_version,$issabelPBX_current_version,'!=')) {
$migrateold = 1;
}
}
$arrTmp[0] = "";
$arrTmp[1] = "$nombre_archivo";
$fecha="";
// se parsea el archivo para obtener la fecha
if(preg_match("/\w*-\d{4}\d{2}\d{2}\d{2}\d{2}\d{2}-\w{2}\.\w*/",$nombre_archivo)){ //issabelbackup-20110720122759-p7.tar
$arrMatchFile = preg_split("/-/",$nombre_archivo);
$data = $arrMatchFile[1];
$fecha = substr($data,-8,2)."/".substr($data,-10,2)."/".substr($data,0,4)." ".substr($data,-6,2).":".substr($data,-4,2 ).":".substr($data,-2,2);
$id = $arrMatchFile[1]."-".$arrMatchFile[2];
}
// If FPBX backup
if(preg_match("/\w*\d{4}\d{2}\d{2}-\d{2}\d{2}\d{2}-\.*/",$nombre_archivo)){ //20170627-125546-1498578946-13.0.192.9-1829244042.tgz
$arrMatchFile = preg_split("/-/",$nombre_archivo);
$data = $arrMatchFile[0].$arrMatchFile[1];
$fecha = substr($data,-8,2)."/".substr($data,-10,2)."/".substr($data,0,4)." ".substr($data,-6,2).":".substr($data,-4,2 ).":".substr($data,-2,2);
$id = $arrMatchFile[1]."-".$arrMatchFile[2];
}
// If Cloud Backup
if(preg_match("/\d{4}\d{2}\d{2}\d{2}\d{2}\d{2}.*.aes256/",$nombre_archivo)){ //20200505214940.tar.aes256
$arrMatchFile = explode(".",$nombre_archivo);
$data = $arrMatchFile[0];
$fecha = substr($data,-8,2)."/".substr($data,-10,2)."/".substr($data,0,4)." ".substr($data,-6,2).":".substr($data,-4,2 ).":".substr($data,-2,2);
$id = $arrMatchFile[1]."-".$arrMatchFile[2];
}
$arrTmp[2] = $fecha;
if($migrate==1) {
$arrTmp[3] = "";
} elseif($migratefpbx==1) {
$arrTmp[3] = "";
} elseif($migrateold==1) {
$arrTmp[3] = "";
} elseif($decrypt==1) {
$arrTmp[3] = "";
} else {
$arrTmp[3] = "";
}
$arrData[] = $arrTmp;
}
}
$arrGrid = array("title" => _tr('Backup List'),
"url" => array('menu' => $module_name),
"icon" => "/modules/$module_name/images/system_backup_restore.png",
"width" => "99%",
"start" => ($total==0) ? 0 : $offset + 1,
"end" => $end,
"total" => $total,
"columns" => array(0 => array("name" => ""),
1 => array("name" => _tr('Name Backup')),
2 => array("name" => _tr('Date')),
3 => array("name" => _tr('Action')),
)
);
$time = $_DATA['status'];
$deltime = $_DATADEL['status'];
$smarty->assign("FILE_UPLOAD", _tr('File Upload'));
$smarty->assign("AUTOMATIC", _tr('AUTOMATIC'));
$smarty->assign("UPLOAD", _tr('Upload'));
$smarty->assign("FTP_BACKUP", _tr('FTP Backup'));
$oGrid->addNew("backup",_tr("Backup"));
$oGrid->deleteList(_tr("Are you sure you wish to delete backup (s)?"),'delete_backup',_tr("Delete"));
$oGrid->customAction("view_form_FTP",_tr("FTP Backup"), "cloud");
$oGrid->addHTMLAction(" ");
$backupIntervals = array(
'DISABLED' => _tr('DISABLED'),
'DAILY' => _tr('DAILY'),
'MONTHLY' => _tr('MONTHLY'),
'WEEKLY' => _tr('WEEKLY'),
);
$deleteIntervals = array(
'DISABLED' => _tr('DISABLED'),
'1' => "1 "._tr('DAY'),
'7' => "7 "._tr('DAYS'),
'30' => "30 "._tr('DAYS'),
'60' => "60 "._tr('DAYS'),
'120' => "120 ". _tr('DAYS'),
'365' => "365 ". _tr('DAYS'),
);
$oGrid->addComboAction("time",_tr("AUTOMATIC"),$backupIntervals,$time,'automatic');
$oGrid->addComboAction("deltime",_tr("DELETEB"),$deleteIntervals,$deltime,'automatic_del');
$contenidoModulo = $oGrid->fetchGrid($arrGrid, $arrData);
return $contenidoModulo;
}
function automatic_backup($smarty, $module_name, $local_templates_dir, $dir_backup, &$pDB, $id)
{
if ($id == 1) { // auto backup
$time = getParameter("time");
} elseif ($id == 2) { //auto del backups
$time = getParameter("deltime");
}
//if there is data in database
$pFTPBackup = new paloSantoFTPBackup($pDB);
$result = $pFTPBackup->getStatusAutomaticBackupById($id);
if(isset($result) && $result != "")
$pFTPBackup->updateStatus($id,$time);
else
$pFTPBackup->insertStatus($id,$time);
if ($id == 2 && $time != "DISABLED") {
$smarty->assign("mb_message", _tr('SUCCESSFUL').". "._tr('EVERYDAYBACKUP')." ".$time." "._tr('WILLBEDELETED'));
} elseif ( $id == 1) {
$smarty->assign("mb_message", _tr('SUCCESSFUL').". "._tr('NOHEAVYCONTENT'));
} else {
$smarty->assign("mb_message", _tr('SUCCESSFUL'));
}
$pFTPBackup->createCronFile($id,$time);
return report_backup_restore($smarty, $module_name, $local_templates_dir, $dir_backup, $pDB);
}
function downloadBackup($smarty, $module_name, $local_templates_dir, $dir_backup)
{
$bArchivoValido = TRUE;
$file_name = getParameter("file_name");
if (basename($file_name) != $file_name) {
$bArchivoValido = FALSE;
} elseif (!preg_match('/(^issabel)backup-\d{14}-\w{2}\.tar$/', $file_name)) {
$bArchivoValido = FALSE;
}
if ($bArchivoValido) {
if (file_exists("$dir_backup/$file_name")) {
header("Cache-Control: private");
header("Pragma: cache");
header('Content-Type: application/octet-stream');
header("Content-Length: ".filesize("$dir_backup/$file_name"));
header("Content-Disposition: attachment; filename=$file_name");
readfile("$dir_backup/$file_name");
} else {
header("HTTP/1.1 404 Not Found");
print "File not found";
}
} else {
header("HTTP/1.1 403 Forbidden");
print "Invalid file";
}
}
function delete_backup($smarty, $module_name, $local_templates_dir, $dir_backup, &$pDB)
{
function delete_backup_isInvalidFile($file_name) {
return !preg_match('/^(cloud|issabel|elastix)backup-\d{14}-\w{2}\.tar|^[0-9]{8}-[0-9]{6}-.*/', $file_name);
}
function delete_backup_doDelete($filePath) {
return file_exists($filePath) ? !unlink($filePath) : FALSE;
}
$archivos_borrar = isset($_POST['chk']) ? array_keys($_POST['chk']) : array();
if (!is_array($archivos_borrar) || count($archivos_borrar) <= 0) {
$smarty->assign('mb_message', _tr('There are not backup file selected'));
} elseif (count(array_filter(array_map('delete_backup_isInvalidFile', $archivos_borrar))) > 0) {
$smarty->assign('mb_message', _tr('Invalid files selected to delete'));
} else {
foreach(array_keys($archivos_borrar) as $i ) {
$archivos_borrar[$i] = $dir_backup.'/'.$archivos_borrar[$i];
}
if (count(array_filter(array_map('delete_backup_doDelete', $archivos_borrar))) > 0) {
$smarty->assign('mb_message', _tr('Error when deleting backup file'));
}
}
return report_backup_restore($smarty, $module_name, $local_templates_dir, $dir_backup, $pDB);
}
function form_general($smarty, $local_templates_dir, $arrBackupOptions, $module_name)
{
$smarty->assign("PROCESS",_tr('Process'));
$smarty->assign("LBL_TODOS", _tr('Select All options'));
$smarty->assign("TODO_FAX", _tr('Select all in this section'));
$smarty->assign("TODO_EMAIL", _tr('Select all in this section'));
$smarty->assign("TODO_ENDPOINT", _tr('Select all in this section'));
$smarty->assign("TODO_ASTERISK", _tr('Select all in this section'));
$smarty->assign("TODO_OTROS", _tr('Select all in this section'));
$smarty->assign("TODO_OTROS_NEW", _tr('Select all in this section'));
$smarty->assign("BACK", _tr('Cancel'));
$smarty->assign("WARNING", _tr('This process could take several minutes'));
/*****************/
$smarty->assign("FAX", _tr('Fax'));
$smarty->assign("EMAIL", _tr('Email'));
$smarty->assign("ENDPOINT", _tr('Endpoint'));
$smarty->assign("ASTERISK", _tr('Asterisk'));
$smarty->assign("OTROS", _tr('Others'));
$smarty->assign("OTROS_NEW", _tr('Others'));
/*****************/
$smarty->assign("backup_fax", $arrBackupOptions['fax']);
$smarty->assign("backup_email", $arrBackupOptions['email']);
$smarty->assign("backup_endpoint", $arrBackupOptions['endpoint']);
$smarty->assign("backup_asterisk", $arrBackupOptions['asterisk']);
$smarty->assign("backup_otros", $arrBackupOptions['otros']);
$smarty->assign("backup_otros_new", $arrBackupOptions['otros_new']);
$smarty->assign("module", $module_name);
return $smarty->fetch("$local_templates_dir/backup.tpl");
}
function backup_form($smarty, $local_templates_dir, $module_name)
{
$arrBackupOptions = Array_Options();
$smarty->assign("title", _tr('Backup'));
$smarty->assign("OPTION_URL", "backup");
return form_general($smarty, $local_templates_dir, $arrBackupOptions, $module_name);
}
function migrate_form($smarty, $local_templates_dir, $path_backup, $module_name)
{
$smarty->assign("module", $module_name);
if(isset($_POST["submit_migrate"])) {
$arr = array_keys($_POST["submit_migrate"]);
$filename = $arr[0];
}
$filename = $filename;
$frame_url=$_SERVER['REQUEST_SCHEME']."://".$_SERVER['HTTP_HOST']."/modules/backup_restore/restore.php?filename=".$filename;
$smarty->assign("frame_url", $frame_url);
return $smarty->fetch("$local_templates_dir/migration.tpl");
}
function decrypt_form($smarty, $local_templates_dir, $path_backup, $module_name)
{
global $arrConf;
$smarty->assign("module", $module_name);
if(isset($_POST["submit_decrypt"])) {
$arr = array_keys($_POST["submit_decrypt"]);
$filename = $arr[0];
}
// $frame_url=$_SERVER['REQUEST_SCHEME']."://".$_SERVER['HTTP_HOST']."/modules/backup_restore/decrypt.php?filename=".$filename;
// $smarty->assign("frame_url", $frame_url);
// return $smarty->fetch("$local_templates_dir/migration.tpl");
$backup_dir = $arrConf['dir'];
$smarty->assign("BACKUP_FILE", $filename);
$smarty->assign("PASSPHRASE", _tr("Passphrase"));
$smarty->assign("DECRYPT_HELP", _tr("Decrypt Desc"));
$smarty->assign("PROCESS", _tr("Process"));
$smarty->assign("BACK", _tr("Cancel"));
//$smarty->assign("ERROR_MSG", _tr("Un error por aqui"));
//$smarty->assign("mb_message", _tr("Un error por aqui"));
if(isset($_POST["dodecrypt"])) {
if (isset($_REQUEST['passphrase']) && isset($_REQUEST['filename'])){
$filename = escapeshellarg($_REQUEST['filename']);
$filename = substr($filename,1,-1);
$filename = $backup_dir."/".$filename;
$fileout = basename ($filename , ".tar.aes256" );
$fileout = $backup_dir."/cloudbackup-".$fileout."-de.tar";
$passphrase = escapeshellarg($_REQUEST['passphrase']);
if(is_file($filename)) {
$cmd = "/usr/bin/openssl aes-256-cbc -in $filename -out $fileout -d -pass pass:$passphrase";
$cmd .= " && rm -f $filename";
$cmd .= " 2>&1 || echo \"err_flag\"";
$file = popen($cmd,"r");
while(!feof($file)) {
$line = fgets($file);
if($line == "err_flag\n") {
$error = true;
break;
}
ob_flush();
flush();
}
pclose($file);
if ($error) {
exec("rm -f $fileout");
$smarty->assign("mb_message", _tr("Error!"));
} else {
return report_backup_restore($smarty, $module_name, $local_templates_dir, $backup_dir, $pDB);
}
} else {
$smarty->assign("mb_message", $filename._tr("is not a file"));
//echo "$filename is not a file;
}
}
}
return $smarty->fetch("$local_templates_dir/decrypt.tpl");
}
function restore_form($smarty, $local_templates_dir, $path_backup, $module_name)
{
$arrBackupOptions = Array_Options("disabled='disabled'");
if(isset($_POST["submit_restore"])) {
$arr = array_keys($_POST["submit_restore"]);
$archivo_post = $arr[0];
} else {
$archivo_post = isset($_POST["backup_file"])?$_POST["backup_file"]:"";
}
$archivo_post = basename($archivo_post);
if (!preg_match('/(^issabel|^cloud)backup-\d{14}-\w{2}\.tar$/', $archivo_post)) {
Header("Location: ?menu=$module_name");
return NULL;
}
$output = $retval = NULL;
exec('tar -xOf '.escapeshellarg("$path_backup/$archivo_post").' backup/a_options.xml',
$output, $retval);
if ($retval == 0)
{
$xmlDoc = new DOMDocument();
$xmlDoc->loadXML(implode('', $output));
//copio el archivo en memoria
$root = $xmlDoc->documentElement;//apunto a el tag raiz
$optionsList = $root->getElementsByTagName("options");
foreach($optionsList as $optionGeneral) {
$attributeID = $optionGeneral->getAttribute("id");
$option = $optionGeneral->getElementsByTagName("option");
foreach($option as $value) {
$arrBackupOptions[$attributeID][$value->nodeValue]["disable"] = "";
}
}
}
$smarty->assign("BACKUP_FILE", $archivo_post);
$smarty->assign("title", _tr("Restore"). ": $archivo_post");
$smarty->assign("OPTION_URL", "restore");
list($versionList_current, $versionList_torestore, $compare) =
runPackageVersionCompare($path_backup, $smarty, $archivo_post);
if (!is_null($compare) && count($compare) > 0) {
$pag = '"?menu='.$module_name.'&action=detail&rawmode=yes&file_name='.$archivo_post.'"';
$outMessage = _tr('Warning')." "._tr('details').'';
$smarty->assign('mb_message', $outMessage);
}
return form_general($smarty, $local_templates_dir, $arrBackupOptions, $module_name);
}
function process_backup($smarty, $local_templates_dir, $module_name)
{
// Recolectar las claves conocidas seleccionadas
$opcionesBackup = Array_Options();
$clavesBackup = array();
foreach($opcionesBackup as $opcionBackup) {
$clavesBackup = array_merge($clavesBackup, array_keys($opcionBackup));
}
$clavesSeleccion = array_intersect($clavesBackup, array_keys($_POST));
// Ejecución del comando en sí
$sArchivoBackup = 'issabelbackup-'.date('YmdHis').'-'.substr(session_id(), 0, 1).substr(session_id(), -1, 1).'.tar';
$sDirBackup = '/var/www/backup';
$sOpcionesBackup = implode(',', $clavesSeleccion);
$output = $retval = NULL;
$sComando = '/usr/bin/issabel-helper backupengine --backup'.
" --backupfile $sArchivoBackup".
" --tmpdir $sDirBackup".
" --components $sOpcionesBackup".
' 2>&1';
exec($sComando, $output, $retval);
if ($retval == 0) {
$smarty->assign('ERROR_MSG', _tr('Backup Complete!').': '.$sArchivoBackup);
} else {
$sMensaje = _tr('Could not generate backup file').': '.$sArchivoBackup.'
'.
_tr('Output follows: ').'
'.
implode("
\n", $output);
$smarty->assign('ERROR_MSG', $sMensaje);
}
return backup_form($smarty, $local_templates_dir, $module_name);
}
function process_restore($smarty, $local_templates_dir, $path_backup, $module_name)
{
$smarty->assign("module", $module_name);
// Recolectar las claves conocidas seleccionadas
$opcionesBackup = Array_Options();
$clavesBackup = array();
foreach ($opcionesBackup as $opcionBackup) {
$clavesBackup = array_merge($clavesBackup, array_keys($opcionBackup));
}
$clavesSeleccion = array_intersect($clavesBackup, array_keys($_POST));
if (count($clavesSeleccion) <= 0) {
$smarty->assign('ERROR_MSG', _tr('Choose an option to restore'));
} elseif (!isset($_POST['backup_file']) || trim($_POST['backup_file']) == '') {
$smarty->assign('ERROR_MSG', _tr("Backup file path can't be empty"));
} elseif (!file_exists($path_backup.'/'.$_POST['backup_file'])) {
$smarty->assign('ERROR_MSG', _tr("File doesn't exist"));
} else {
// Ejecución del comando en sí
$sOpcionesBackup = implode(',', $clavesSeleccion);
$output = $retval = NULL;
$sComando = '/usr/bin/issabel-helper backupengine --restore'.
' --backupfile '.escapeshellarg($_POST['backup_file']).
' --tmpdir '.escapeshellarg($path_backup).
" --components $sOpcionesBackup".
' 2>&1';
exec($sComando, $output, $retval);
if ($retval == 0) {
$smarty->assign('ERROR_MSG', _tr('Restore Complete!'));
} else {
$sMensaje = _tr('Could not restore from backup file').': '.$_POST['backup_file'].'
'.
_tr('Output follows: ').'
'.
implode("
\n", $output);
$smarty->assign('ERROR_MSG', $sMensaje);
}
}
return restore_form($smarty, $local_templates_dir, $path_backup, $module_name);
}
function Array_Options($disabled="")
{
$arrBackupOptions = array(
"asterisk" => array(
"as_db" => array("desc"=>_tr('Database')),
"as_config_files" => array("desc"=>_tr('Configuration Files')),
"as_monitor" => array("desc"=>_tr('Monitors')." "._tr('(Heavy Content)')),
"as_voicemail" => array("desc"=>_tr('Voicemails')." "._tr('(Heavy Content)')),
"as_sounds" => array("desc"=>_tr('Sounds')),
"as_mohmp3" => array("desc"=>_tr('MOH')),
"as_dahdi" => array("desc"=>_tr('DAHDI Configuration')),
),
"fax" => array(
"fx_db" => array("desc"=>_tr('Database')),
"fx_pdf" => array("desc"=>_tr('PDF')),
),
"email" => array(
"em_db" => array("desc"=>_tr('Database')),
"em_mailbox" => array("desc"=>_tr('Mailbox')),
),
"endpoint" => array(
"ep_db" => array("desc"=>_tr('Database')),
"ep_config_files" => array("desc"=>_tr('Configuration Files')),
),
"otros" => array(
"callcenter_db" => array("desc"=>_tr('Call Center CE Database')),
"asternic_db" => array("desc"=>_tr('Asternic Call Center Stats Database')),
"FOP2_settings_db" => array("desc"=>_tr('FOP2 User Settings')),
"sugar_db" => array("desc"=>_tr('SugarCRM Database')),
"vtiger_db" => array("desc"=>_tr('VtigerCRM Database')),
"a2billing_db" => array("desc"=>_tr('A2billing Database')),
"mysql_db" => array("desc"=>_tr('Mysql Database')),
"menus_permissions" => array("desc"=>_tr('Menus and Permissions'))
),
"otros_new" => array(
"calendar_db" => array("desc"=>_tr('Calendar Database')),
"address_db" => array("desc"=>_tr('Address Book Database')),
"conference_db" => array("desc"=>_tr('Conference Database')),
"eop_db" => array("desc"=>_tr('EOP')),
),
);
foreach (array_keys($arrBackupOptions) as $k1) {
foreach (array_keys($arrBackupOptions[$k1]) as $k2) {
$arrBackupOptions[$k1][$k2]['check'] = '';
$arrBackupOptions[$k1][$k2]['msg'] = '';
$arrBackupOptions[$k1][$k2]['disable'] = "$disabled";
}
}
return $arrBackupOptions;
}
/* ------------------------------------------------------------------------------- */
/* FUNCIONS PARA EL BACKUP*/
/* ------------------------------------------------------------------------------- */
/* ------------------------------------------------------------------------------- */
/* FUNCIONS PARA EL RESTORE*/
/* ------------------------------------------------------------------------------- */
function runPackageVersionCompare($path_backup, $smarty, $backup_file)
{
//verificar que existe el archivo de respaldo
$path_file_backup = "$path_backup/$backup_file";
if (empty($backup_file)) {
$smarty->assign('ERROR_MSG', _tr("Backup file path can't be empty"));
return NULL;
}
if (!preg_match('/(^issabel|cloud)backup-\d{14}-\w{2}\.tar$/', $backup_file)) {
$smarty->assign('ERROR_MSG', _tr('Invalid backup filename'));
return NULL;
}
if (!file_exists($path_file_backup)) {
$smarty->assign('ERROR_MSG', _tr("File doesn't exist"));
return NULL;
}
$versionList_current = getVersionPrograms_SYSTEM();
$versionList_torestore = getVersionPrograms_XML($path_file_backup);
if (is_null($versionList_torestore)) {
$smarty->assign("mb_message", _tr('no_file_xml'));
return NULL;
}
$compare = comparePackageVersions($versionList_current, $versionList_torestore);
return array($versionList_current, $versionList_torestore, $compare);
}
function boxAlert($smarty, $local_templates_dir, $versionList_current, $versionList_torestore, $compare)
{
$packagereport = array();
foreach($compare as $key => $value) {
$tupla = array(
'desc' => _tr($key),
'name' => $key,
'version_current' => '',
'version_backup' => '',
);
if (!isset($versionList_torestore[$key]['version']) || !isset($versionList_torestore[$key]['release']) ||
$versionList_torestore[$key]['version'] == $versionList_torestore[$key]['release']){
$tupla['version_backup'] = ""._tr("Package not installed")."";
} else {
$tupla['version_backup'] = $versionList_torestore[$key]['version']."-".$versionList_torestore[$key]['release'];
}
$tupla['version_current'] = $versionList_current[$key]['version']."-".$versionList_current[$key]['release'];
if ($versionList_current[$key]['version'] == $versionList_current[$key]['release']){
$tupla['version_current'] = ""._tr("Package not installed")."";
}
$packagereport[] = array_merge($tupla, getValueofBackupOption($key));
}
$smarty->assign(array(
'warning_details' => _tr('warning_details'),
'programs' => _tr('programs'),
'Package' => _tr('Package'),
'Version' => _tr('Version'),
'local_version' => _tr('local_version'),
'external_version' => _tr('external_version'),
'Options_Backup' => _tr('Options Backup'),
'Endpoint' => _tr('Endpoint'),
'Fax' => _tr('Fax'),
'Email' => _tr('Email'),
'Asterisk' => _tr('Asterisk'),
'Others' => _tr('Others'),
'Others_new' => _tr('Others new'),
'packagereport' => $packagereport,
));
return $smarty->fetch("$local_templates_dir/versionCompareDetail.tpl");
}
function getValueofBackupOption($valueOp)
{
$arrayOptions = array(
"endpoint" => array("issabel-pbx"),
"fax" => array("issabel-fax"),
"email" => array("issabel","issabel-email_admin"),
"asterisk" => array("asterisk","dahdi","wanpipe-util","issabelpbx","issabel"),
"otros" => array("issabel-vtigercrm","issabel-a2billing","issabel","issabel-pbx","issabel-sugarcrm-addon"),
"otros_new" => array("issabel-pbx","issabel-agenda")
);
$arrayResult = array();
foreach($arrayOptions as $key => $value) {
$arrayResult[$key] = in_array($valueOp, $value) ? 'x' : '';
}
return $arrayResult;
}
function showMessageAlert($arr){
$version = "";
foreach($arr as $key => $value){
$version .= "$key => version ".$arr[$key]['version']." release ".$arr[$key]['release']."\n";
}
return $version;
}
function viewDetail($smarty, $module_name, $local_templates_dir, $path_backup)
{
$htmlForm = '';
$backup_file = getParameter("file_name");
list($versionList_current, $versionList_torestore, $compare) =
runPackageVersionCompare($path_backup, $smarty, $backup_file);
if (!is_null($compare)) {
$htmlForm = boxAlert($smarty, $local_templates_dir, $versionList_current, $versionList_torestore, $compare);
}
return $htmlForm;
}
function getVersionPrograms_SYSTEM()
{
$packageList = array('asterisk', 'dahdi', 'wanpipe-util', 'issabelPBX',
'issabel', 'issabel-pbx', 'issabel-email_admin', 'issabel-agenda',
'issabel-fax', 'issabel-vtigercrm', 'issabel-a2billing',
'issabel-sugarcrm-addon');
$output = $retval = NULL;
exec("rpm -q --queryformat '%{name} %{version} %{release}\\n' ".implode(' ', $packageList),
$output, $retval);
// Add all existing packages to report
$arrPro = array();
foreach ($output as $s) {
$fields = explode(' ', trim($s));
if (count($fields) == 3 && in_array($fields[0], $packageList)) {
// This is needed for compatibility with previous backup implementation
$sPackageName = $fields[0];
if ($sPackageName == 'issabelPBX') $sPackageName = 'issabelpbx';
$arrPro[$sPackageName] = array(
'version' => $fields[1],
'release' => $fields[2],
);
$k = array_search($fields[0], $packageList);
unset($packageList[$k]);
}
}
/* Any remaining values in $packageList are missing packages. The missing
* package is marked with 'Package not installed' as attribute value for
* compatibility with the previous backup implementation. */
foreach ($packageList as $sPackage) {
// The string is deliberately not translated
$arrPro[$sPackage] = array(
'version' => 'Package not installed',
'release' => 'Package not installed',
);
}
return $arrPro;
}
function getVersionPrograms_XML($path_file_backup)
{
// Output program versions to stdout
$output = $retval = NULL;
exec('tar -xOf '.escapeshellarg($path_file_backup).' backup/versions.xml',
$output, $retval);
if ($retval != 0) return NULL;
$xmlDoc = new DOMDocument();
if (!$xmlDoc->loadXML(implode('', $output))) return NULL;
$arrPrograms = null;
//copio el archivo en memoria
$root = $xmlDoc->documentElement;//apunto a el tag versions
$optionsList = $root->getElementsByTagName("program");
foreach($optionsList as $optionGeneral) {
$arrPrograms[$optionGeneral->getAttribute("id")] = array(
"version" => $optionGeneral->getAttribute("ver"),
"release" => $optionGeneral->getAttribute("rel"));
}
return $arrPrograms;
}
/**
* Procedimiento para comparar las listas de versiones entre lo instalado
* actualmente y lo que se va a restarar, para avisar de posibles
* inconsistencias.
*
* @param array $versionList_current Lista de paquetes instalados
* actualmente.
* @param array $versionList_torestore Lista de paquetes que estaban
* instalados cuando se realizó el
* backup.
*
* @return array Lista (posiblemente vacía) de diferencias de versiones
*/
function comparePackageVersions($versionList_current, $versionList_torestore)
{
$errors = array();
foreach ($versionList_current as $key => $value) {
if (!isset($versionList_torestore[$key]) || !isset($versionList_torestore[$key]['version']) ||
!isset($versionList_torestore[$key]['release']) ||
$versionList_torestore[$key]['version'] != $versionList_current[$key]['version'] ||
$versionList_torestore[$key]['release'] != $versionList_current[$key]['release']) {
$errors[$key] = $versionList_current[$key]['version']. "-" .$versionList_current[$key]['release'];
}
}
return $errors;
}
/************************ FUNCIONES PARA FTP BACKUP ***********************************/
function viewFormFTPBackup($smarty, $module_name, $local_templates_dir, &$pDB)
{
global $arrConf;
// Variables estáticas
$smarty->assign(array(
'SAVE' => _tr('Save'),
'EDIT' => _tr('Edit'),
'CANCEL' => _tr('Cancel'),
'UPLOAD' => _tr('Upload'),
'DOWNLOAD' => _tr('Download'),
'TITLE' => _tr('TITLE'),
'REQUIRED_FIELD' => _tr('Required field'),
'icon' => "modules/$module_name/images/system_backup_restore.png",
'module_name' => $module_name,
));
$pFTPBackup = new paloSantoFTPBackup($pDB);
// Datos a mostrar en el formulario de credenciales del servidor
$ftpcred = array(
'server' => '',
'port' => 21,
'user' => '',
'password' => '',
'pathServer' => '/',
);
$dbcred = $pFTPBackup->obtenerCredencialesFTP();
if (is_array($dbcred)) {
foreach (array_keys($ftpcred) as $k) {
if (isset($dbcred[$k])) $ftpcred[$k] = $dbcred[$k];
}
}
foreach (array_keys($ftpcred) as $k) {
if (isset($_POST[$k])) $ftpcred[$k] = $_POST[$k];
}
// Listado de archivos local y remoto
$smarty->assign('local_files', $pFTPBackup->obtainFiles($arrConf['dir']));
$smarty->assign('remote_files', $pFTPBackup->listarArchivosTarFTP());
if ($pFTPBackup->errMsg != '') $smarty->assign('mb_message', $pFTPBackup->errMsg);
$oForm = new paloForm($smarty, createFieldForm());
$htmlForm = $oForm->fetchForm("$local_templates_dir/formFTP.tpl", _tr('FTP Backup'), $ftpcred);
return "