<?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;
