function ListOldReports($dir) { #$dir_files = array_diff(scandir($dir), array('..', '.')); $dir_files = listdir_by_date($dir); echo "<thead>"; echo "<tr><th>Report timestamp</th><th align=\"left\">Report</th></tr>\n"; echo "</thead>"; echo "<tbody>"; foreach ($dir_files as $fdate => $fname) { $fdate = explode(",", $fdate); $fdate = date("Y.m.d H:i:s", $fdate[0]); echo "<tr><td>{$fdate}</td><td align=\"left\"><a href=\"reports/{$fname}\">{$fname}</a></td></tr>\n"; } echo "</tbody>"; }
//nasty global for now global $timestamp; if ($time < $timestamp) { return $file; //return date('d-m-Y', $time); } } function sliceFiles($item) { // var_dump($item); if (!empty($item)) { return $item; } } //set time $timestamp = strtotime(date('d-m-Y', strtotime('-2 month'))); //windows dir name $path = ""; $files = listdir_by_date($path); //$files = listdir_by_date(""); //get files over due $reducedFiles = array_filter(array_map('reduceFiles', $files, array_keys($files)), 'sliceFiles'); //print_r($files); echo "These files are deleted\n"; print_r($reducedFiles); //set live when needed /* foreach ($reducedFiles as $key => $filename) { unlink($path.$filename); } */
#file name which copied recently#' echo "\n" . $latestSqlFileName; //escloc13_dbdumpall_2014111521.sql.gz $hoursOfSqlFileLastCreated = hours_diff_of_latest_backup_file($latestSqlFileName); echo "\n" . $hoursOfSqlFileLastCreated; # if the last backup was taken more than 9 hours then trigger the mail with exact date time when the back was taken if ($hoursOfSqlFileLastCreated > 9) { $subjectSQL = $cloudName . ' SQL Backup failed - Last sql backup was taken at' . date(" Y-m-d H:i:s.", filemtime($latestSqlFileName)); $messageSQL = $cloudName . ' SQL Backup failed - Last sql backup was taken at' . date(" Y-m-d H:i:s.", filemtime($latestSqlFileName)) . '(' . round($hoursOfSqlFileLastCreated, 2) . ' hours ago )'; mail($to, $subjectSQL, $messageSQL); } ######################################################################### ########## CHECKING REPORTING_DB BACKUPS IN ALL CLOUD ######################################################################### //escloc13_reporting_data_2014120400.dat $reportdbBackUpFileName = $cloudName . '_reporting_data_*.dat'; $reportdbFileSortedArray = listdir_by_date($directoryName . $reportdbBackUpFileName); $latestReportdbFileName = $directoryName . end($reportdbFileSortedArray); #file name which copied recently#' echo $latestReportdbFileName; //escloc13_dbdumpall_2014111521.sql.gz $hoursOfReportdbFileLastCreated = hours_diff_of_latest_backup_file($latestReportdbFileName); echo "\n" . $hoursOfReportdbFileLastCreated; # if the last backup was taken more than 24 hours then trigger the mail with exact date time when the back was taken if ($hoursOfReportdbFileLastCreated > 24) { $subjectRDB = $cloudName . ' ReportDB Backup failed - Last ReportDB backup was taken at' . date(" Y-m-d H:i:s.", filemtime($latestReportdbFileName)); $messageRDB = $cloudName . ' ReportDB Backup failed - Last ReportDB backup was taken at' . date(" Y-m-d H:i:s.", filemtime($latestReportdbFileName)) . '(' . round($hoursOfReportdbFileLastCreated, 2) . ' hours ago )'; mail($to, $subjectRDB, $messageRDB); } } mail('*****@*****.**', 'backup check script executed in esclos64', 'backup check script executed in esclos64');