eventLogger::addLogEntry PHP Method

addLogEntry() public method

public addLogEntry ( $filename, $status, $process )
    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 . "')");
    }

Usage Example

コード例 #1
0
ファイル: runFileWatcher.php プロジェクト: openeyes/openeyes
 $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'];