<?php $label_string = ""; $label_sql = "\n SELECT label FROM document_labels WHERE document_id = '" . $document->document_id . "'\n "; $label_result = $db->query($label_sql); while ($label = $label_result->fetch_object()) { $label_string .= $label->label . ", "; } # delete last comma and space $label_string = substr($label_string, 0, -2); echo $label_string; ?> </td> <td> <?php # build file path $filepath = BASE_PATH . '/' . ARCHIVE_FOLDER_REL . '/' . $document->internalID . '/' . date_german2yearonly(date_mysql2german($document->date)) . '/' . date_german2monthonly(date_mysql2german($document->date)) . '/' . $document->mailtype . '/' . date_german2ldms(date_mysql2german($document->date)) . '_' . $document->direction . '_' . $document->mailtype . '_' . $document->externalID . '_' . $document->internalID . '_' . $document->number . '.pdf'; ?> <a href="<?php echo $filepath; ?> " title="Dokument öffnen" target="_blank"><img src="<?php echo IMAGES_PATH; ?> /pdf-icon.png" alt="Dokument öffnen" /></a> <a title="URL kopieren" href="#" onclick="window.prompt('In die Zwischenablage kopieren: Strg+C, Enter', '<?php echo $filepath; ?> ');"><img src="<?php echo IMAGES_PATH; ?>
$ep_count_sql = "SELECT COUNT(*) AS c FROM external_parties"; $ep_count_query = $db->query($ep_count_sql); $ep_count = $ep_count_query->fetch_object(); $ep_counted = $ep_count->c; $epdoc_count_sql = "SELECT * FROM documents GROUP by externalID"; $epdoc_count_query = $db->query($epdoc_count_sql); $epdoc_counted = $epdoc_count_query->num_rows; # read DB $read = "\n SELECT d.*, e.external_party, i.internal_party, m.mailtype AS mt \n FROM documents d\n JOIN external_parties e ON (d.externalID = e.id) \n JOIN internal_parties i ON (d.internalID = i.id) \n JOIN mailtypes m ON (d.mailtype = m.id)\n LEFT JOIN document_labels dl ON (d.document_id = dl.document_id)\n WHERE TRUE \n "; $sql = $db->query($read); # search db entries in files $db_dokumente = array(); $treffer_archive = array(); $fehler_archive = array(); while ($document = $sql->fetch_object()) { $filepath = $document->internalID . '/' . date_german2yearonly(date_mysql2german($document->date)) . '/' . date_german2monthonly(date_mysql2german($document->date)) . '/' . $document->mailtype . '/' . date_german2ldms(date_mysql2german($document->date)) . '_' . $document->direction . '_' . $document->mailtype . '_' . $document->externalID . '_' . $document->internalID . '_' . $document->number . '.pdf'; $db_dokumente[$document->document_id] = $filepath; if (in_array($filepath, $all_existing_files)) { $treffer_archive[$document->document_id] = $filepath; } else { $fehler_archive[$document->document_id] = $filepath; } } # search files in db $treffer_db = array(); $fehler_db = array(); foreach ($all_existing_files as $existing_file) { if (in_array($existing_file, $db_dokumente)) { $treffer_db[] = $existing_file; } else { $fehler_db[] = $existing_file;