public function addLogEntry($filename, $status, $process) { $filedata = stat($filename); $fileIdQ = $this->databaseConnection->query("SELECT id,id FROM dicom_files WHERE filename = '" . $filename . "' AND filesize ='" . $filedata['size'] . "' AND filedate='" . date('Y-m-d H:i:s', $filedata['mtime']) . "'"); $fileIdArr = $fileIdQ->fetch_array(); $this->databaseConnection->query("INSERT INTO dicom_file_log (event_date_time, dicom_file_id, status, process_name) VALUES (now(), '" . $fileIdArr[0] . "', '" . $status . "', '" . $process . "')"); }
$mysqli = connectDatabase(); $logger = new eventLogger($mysqli); if ($dicomConfig['FAM'] == '1') { while (fam_pending($fam_res)) { $arr = fam_next_event($fam_res); // FAMCreated == 5 if ($arr['code'] == 5) { echo 'New file arrived: ' . $arr['filename'] . "\n"; $newfile = true; $filedata = stat($dicomConfig['biometry']['inputFolder'] . '/' . $arr['filename']); if (!($fileid = fileEntryExistsFAM($dicomConfig['biometry']['inputFolder'] . '/' . $arr['filename'], $filedata, $mysqli))) { $fileid = createFileEntry($dicomConfig['biometry']['inputFolder'] . '/' . $arr['filename'], $filedata, $mysqli); } //var_dump("Fileid: ".$fileid); $mysqli->query("INSERT INTO dicom_file_queue (filename, detected_date, last_modified_date, status_id) VALUES ('" . $dicomConfig['biometry']['inputFolder'] . '/' . $arr['filename'] . "', now(), now(), (SELECT id FROM dicom_process_status WHERE name = 'new'))"); $logger->addLogEntry($dicomConfig['biometry']['inputFolder'] . '/' . $arr['filename'], 'new', basename($_SERVER['SCRIPT_FILENAME'])); // add log entry } elseif ($arr['code'] == 1) { echo 'File has been changed: ' . $arr['filename'] . "\n"; echo "What we should do now? :)\n"; //var_dump(stat($dicomConfig["biometry"]["inputFolder"]."/".$arr["filename"])); } } } else { unset($allFilesQ); unset($allfiles); $allFilesQ = $mysqli->query('SELECT * FROM dicom_files '); $allfiles = array(); foreach ($allFilesQ as $fileEntry) { $allfiles[$fileEntry['filename']]['filesize'] = $fileEntry['filesize']; $allfiles[$fileEntry['filename']]['filedate'] = $fileEntry['filedate'];