@echo off
cls

REM PT-BR datetime format
REM set YYMMDD_HHMM=%date:~8,2%%date:~3,2%%date:~0,2%_%time:~0,2%%time:~3,2%
REM EN-US datetime format
REM set YYMMDD_HHMM=%date:~12,2%%date:~4,2%%date:~7,2%_%time:~0,2%%time:~3,2%

set YYMMDD_HHMM=%date:~12,2%%date:~4,2%%date:~7,2%_%time:~0,2%%time:~3,2%
set YYMMDD_HHMM=%YYMMDD_HHMM: =0%

set Seven_Zip_Application=%ProgramFiles%\7-Zip\7z.exe
set OneDrive_Application=%LOCALAPPDATA%\Microsoft\OneDrive\OneDrive.exe

set Firebird_Bin_Folder=%ProgramFiles%\Firebird\Firebird_3_0

set Database=ARAS_CIN
set Backup_Remote_Folder=\\172.27.8.4\aras_chronos_backup
set Backup_OneDrive_Folder=%USERPROFILE%\OneDrive\TRABALHO\CINMOTO_MOT_COM_BACKUP

del "%CD%\%YYMMDD_HHMM%_%Database%.*"
"%Firebird_Bin_Folder%\gbak.exe" -role RDB$ADMIN -backup_database "%Database%" "%CD%\%YYMMDD_HHMM%_%Database%.FBK" -verify -y "%CD%\%YYMMDD_HHMM%_%Database%.LOG" -statistics tdrw
"%Seven_Zip_Application%" a -mx=9 "%CD%\%YYMMDD_HHMM%_%Database%.7Z" "%CD%\%YYMMDD_HHMM%_%Database%.*"
copy "%CD%\%YYMMDD_HHMM%_%Database%.7Z" "%Backup_Remote_Folder%"
copy "%CD%\%YYMMDD_HHMM%_%Database%.7Z" "%Backup_OneDrive_Folder%"
del "%CD%\%YYMMDD_HHMM%_%Database%.*"
PushD "%Backup_Remote_Folder%" && ("forfiles.exe" /s /m "*.*" /d -8 /c "cmd /c del @file") & PopD
PushD "%Backup_OneDrive_Folder%" && ("forfiles.exe" /s /m "*.*" /d -8 /c "cmd /c del @file") & PopD
TIMEOUT 5
start %OneDrive_Application% /shutdown
TIMEOUT 5
start %OneDrive_Application% /background
TIMEOUT 160
start %OneDrive_Application% /shutdown
TIMEOUT 5