# Include the Dropbox SDK libraries
require_once ROOT_PATH . "plugins/dropbox-sdk/lib/Dropbox/autoload.php";
include_once ROOT_PATH . 'plugins/mysqldump-php-1.4.1/src/Ifsnop/Mysqldump/Mysqldump.php';
use Dropbox as dbx;
try {
date_default_timezone_set('Europe/Athens');
// run script only during working hours
if (!App::isWorkingDateTimeOn()) {
exit;
}
$filePath = ROOT_PATH . 'storage/excel/';
$curTerms = TermFetcher::retrieveCurrTerm();
foreach ($curTerms as $curTerm) {
$curTermId = $curTerm[TermFetcher::DB_COLUMN_ID];
$curTermName = $curTerm[TermFetcher::DB_COLUMN_NAME];
$curTermStartDateTime = new DateTime($curTerm[TermFetcher::DB_COLUMN_START_DATE]);
$curTermYear = $curTermStartDateTime->format('Y');
$fullPathFile = Excel::saveAppointments($curTermId);
$fileName = pathinfo($fullPathFile)['filename'] . "." . pathinfo($fullPathFile)['extension'];
$accessToken = DropboxFetcher::retrieveAccessToken(DropboxCon::SERVICE_APP_EXCEL_BACKUP)[DropboxFetcher::DB_COLUMN_ACCESS_TOKEN];
$dbxClient = new dbx\Client($accessToken, App::getVersion());
$adminAccountInfo = $dbxClient->getAccountInfo();
$f = fopen($fullPathFile, "rb");
$result = $dbxClient->uploadFile("/storage/excel/{$curTermYear}/{$fileName}", dbx\WriteMode::force(), $f);
fclose($f);
}
exit;
} catch (\Exception $e) {
App::storeError($e);
exit;
}