// Data atual
$currentDate = date("Y-m-d");

$repoPaths = [
    '/var/www/mymotors',
    '/var/www/quickrealty',
    '/var/www/horizon'
];

$backupPaths = [
    '/var/www/nextcloud/data/jose/files/My Motors/Backups/' . $currentDate,
    '/var/www/nextcloud/data/jose/files/Quick Realty/Backups/' . $currentDate,
    '/var/www/nextcloud/data/jose/files/Horizon/Backups/' . $currentDate
];

$dbNames = [
    'mymotors',
    'quickrealty',
    'horizon'
];

$dbUser = 'jose_leite';
$dbPassword = 'bWmPzanx';

// Função para fazer backup dos repositórios
function backupRepositories($repoPaths, $backupPaths, $currentDate) {
    foreach ($repoPaths as $index => $repoPath) {
        $repoName = basename($repoPath);
        $tarFile = "{$repoName}-{$currentDate}.tar.gz";
        $command = "tar -czf $tarFile -C $repoPath .";
        exec($command);

        $backupPath = $backupPaths[$index];
        if (!file_exists($backupPath)) {
            mkdir($backupPath, 0777, true);
        }
        rename($tarFile, "$backupPath/$tarFile");
    }
}

// Função para fazer backup dos bancos de dados
function backupDatabases($dbNames, $dbUser, $dbPassword, $backupPaths, $currentDate) {
    foreach ($dbNames as $index => $dbName) {
        $sqlFile = "{$dbName}-{$currentDate}.sql";
        $command = "mysqldump -u $dbUser -p$dbPassword $dbName > $sqlFile";
        exec($command);

        $backupPath = $backupPaths[$index];
        if (!file_exists($backupPath)) {
            mkdir($backupPath, 0777, true);
        }
        rename($sqlFile, "$backupPath/$sqlFile");
    }
}

// Executar backups
backupRepositories($repoPaths, $backupPaths, $currentDate);
backupDatabases($dbNames, $dbUser, $dbPassword, $backupPaths, $currentDate);

shell_exec("sudo -u www-data php /var/www/nextcloud/occ files:scan jose");

// Mensagem de sucesso
echo "Backup concluído em {$currentDate}\n";

?>