diff options
Diffstat (limited to 'pdf.php')
| -rw-r--r-- | pdf.php | 516 |
1 files changed, 516 insertions, 0 deletions
@@ -0,0 +1,516 @@ +<?php +/* + * This program is free software; you can redistribute it and/or modify + * it under the terms of the GNU General Public License as published by + * the Free Software Foundation; either version 2 of the License, or + * (at your option) any later version. + * + * This program is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU General Public License for more details. + */ +?> +<? +/* vim: set ts=4 sw=4 et : */ + +$_title = "PDF-Dokumente generieren"; + +require_once __DIR__ . "/check_auth.php"; +require_once __DIR__ . "/../includes/common.php"; + +require_once __DIR__ . "/lookup.php"; + +require_once __DIR__ . "/header.php"; + +if (isset($_GET['demo'])) $_SESSION['demo'] = true; + +session_write_close(); + +$num = 0; +if ($_POST['ids'] != '') + $num = count(explode(',', $_POST['ids'])); +?> + +<div id="pdf_modal" style="display: none;" class="transparent_modal"> + <button onclick="abortAll()" class="emergency_off">NOT-AUS</button> + <div class="sk-folding-cube hvcenter"> + <div class="sk-cube1 sk-cube"></div> + <div class="sk-cube2 sk-cube"></div> + <div class="sk-cube4 sk-cube"></div> + <div class="sk-cube3 sk-cube"></div> + </div> +</div> + +<h1>PDF-Dokumente generieren +<? if ($num > 1) { ?> +<span style="font-size: .5em;">für <?=$num?> Datensätze</span> +<? } else { ?> +<span style="font-size: .5em;">für <?=$num?> Datensatz</span> +<? } ?> +</h1> + +<? if ($_SESSION['demo']) { ?> +<p>Demo-Flag ist an</p> +<? } ?> + +<form id="getpdf" action="/db/main/dopdf.php?test" target="_blank" method="post" style="display: inline-block;"> +<table border="0" style="display: inline-block;" class="consignee"> + <tr> + <td>Organisation<sup><small>Vä</small></sup></td> + <td colspan="3"><input type="text" style="width: 530px;" class="changeable" name="organisation" value=""></td> + </tr> + <tr> + <td>Anrede|Briefkopf<sup><small>V</small></sup></td> + <td><input type="text" readonly name="anrede" style="width: 12ch;" value=""> | <input type="text" readonly name="anrede_briefkopf" style="width: 12ch;" value=""></td> + <td>Titel<sup><small>V</small></sup></td> + <td><input type="text" readonly name="titel" value=""></td> + </tr> + <tr> + <td>Vorname<sup><small>V</small></sup></td> + <td><input type="text" readonly name="vorname" value=""></td> + <td>Nachname<sup><small>V</small></sup></td> + <td><input type="text" readonly name="nachname" value=""></td> + </tr> + <tr> + <td>Straße<sup><small>Vä</small></sup></td> + <td><input type="text" class="changeable" name="strasse" value=""></td> + <td>Adresszusatz<sup><small>Vä</small></sup></td> + <td><input type="text" class="changeable" name="adresszusatz" value=""></td> + </tr> + <tr> + <td>PLZ<sup><small>Vä</small></sup></td> + <td><input type="text" class="changeable" name="plz" value=""></td> + <td>Ort<sup><small>Vä</small></sup></td> + <td><input type="text" class="changeable" name="ort" value=""></td> + </tr> + <tr> + <td colspan="4" style="padding-top: 0;"><small>V: Vorschau, ä: änderbar</small></td> + </tr> + <tr> + <td>Dokument</td> + <td colspan="3"> + <select class="mand tchange" name="fn" style="width: 530px;"> +<? _lookup_pdf_documents(); foreach ($pdf_documents as $d) { ?> +<option value="<?=$d['name']?>"<? if ($d['name'] == $_POST['file']) { ?> selected<? }?>><?=$d['name']?> - <?=$d['description']?></option> +<? } ?> + <option value="" style="color: red !important;"><span style="color: red !important;">Bitte Auswahl treffen!</span></option> +<? if (false) { ?><input type="text" readonly name="fn" value="<?=$_POST['file']?>"><? } ?> + </select> + </td> + </tr> + <tr> + <td>Betreff</td> + <td colspan="3"><input style="width: 530px;" class="mand tchange" type="text" name="subject" placeholder="Bescheid fuer..."></td> + </tr> + <tr> + <td>Datum <button style="padding: 0; margin: 0; font-size: .8em;" onclick="$('#templdate').val($.datepicker.formatDate('dd.mm.yy', new Date())); return false;">heute</button></td> + <td><input class="mand tchange" type="text" id="templdate" name="date" placeholder="01.10.2019"></td> + </tr> +</table> +<input type="hidden" name="template" type="text" value=""> +<input type="hidden" name="html" type="text" value=""> +<input type="hidden" name="data" type="text" value=""> +<input type="hidden" name="uid" type="text" value=""> +</form> + +<div style="display: inline-block; margin-left: 1em; vertical-align: top;"> + <button onclick="return sendAll();" class="medium" style="width: 12em;"><i class="fas fa-file-pdf"></i><i class "fas fa-folder-open"></i> alle generieren</button><br /> + <button onclick="return sendOne();" class="medium" style="width: 12em;"><i class="fas fa-file-pdf"></i><i class="fas fa-save"></i> dieses generieren</button><br /> + <button onclick="return getOne();" class="medium" style="width: 12em;"><i class="fas fa-file-pdf"></i><i class="fas fa-question"></i> dieses testen</button> + + <div style="color: darkorange; margin-top: .5em;"> + Letzter Status: + <p id="pdf_status"></p> + </div> +</div> + +<div style="display: inline-block; margin-left: 1em; vertical-align: top;"> + <b>Templates</b> + <div style="color: darkorange; margin-top: .5em;"> +<? + $sql = "SELECT id, name, text, subject, date, fn, ts FROM pdf_templates ORDER BY name"; + $stmt = $mysqli->prepare($sql); + $stmt->bind_result($id, $name, $text, $subject, $date, $fn, $ts); + $stmt->execute(); +?> + <select id="pdf_template" style="max-width: 500px;"> + <option data-text="" data-subject="" data-date="" value="" selected></option> +<? + $templates = []; + while ($stmt->fetch()) { + $templates[$id] = ['name' => $name, 'text' => $text, 'ts' => $ts]; +?> + <option data-id="<?=$id?>" + data-name="<?=str_replace("\"", """, $name)?>" + data-subject="<?=str_replace("\"", """, $subject)?>" + data-date="<?=str_replace("\"", """, $date)?>" + data-text="<?=str_replace("\"", """, $text)?>" + data-fn="<?=str_replace("\"", """, $fn)?>" + value="<?=$id?>"><?=$name?> (ID <?=$id?>; <?=$ts?>)</option> +<? + } +?> + </select> + <br /> + <br /> + <button class="small" onclick="return loadPDFTemplate();"><i class="fas fa-upload"></i> Laden</button> + <button class="small" onclick="return savePDFTemplate();" style="background: orange"><i class="fas fa-download"></i> Überschreiben</button> + <button class="small" onclick="return newPDFTemplate();"><i class="far fa-file"></i> Neu</button> + <button class="small" onclick="return renamePDFTemplate();"><i class="fas fa-pencil-alt"></i> Umbenennen</button> + <button class="small" onclick="return delPDFTemplate();" style="background: red;"><i class="fas fa-trash"></i> Löschen</button> +<? + $stmt->reset(); +?> + + </div> +</div> + +<script> +<? minStart(); ?> + +$('#pdf_template').on('change', function () { + $('#pdf_template').css('background', 'white'); +}); + +$('.tchange').on('input change cut copy paste', function () { + $('#pdf_template').css('background', 'lightgrey'); +}); + +$(document).ready(function () { + quill.on('text-change', function () { + $('#pdf_template').css('background', 'lightgrey'); + }); + + setTimeout(function () { + var tid = localStorage.getItem('pdf_template'); + if (tid !== '' && tid > 0) { + $('select#pdf_template').val(tid); + localStorage.removeItem('pdf_template'); + setTimeout(function () { + loadPDFTemplate(); + }, 100); + } + }, 200); + + $('select[name=fn]').on('select change', function () { + if ($(this).val() == '') { + $(this).parent().parent().css('background', 'red'); + } else { + $(this).parent().parent().css('background', 'unset'); + } + }); +}); + +function newPDFTemplate() { + var n = prompt('Name des neuen Templates:', ''); + if (!n) return; + + var text = $("#editor .ql-editor").html(); + var subject = $('input[name=subject]').val(); + var date = $('input[name=date]').val(); + + $.ajaxSetup({async:false}); + var rv = 0; + $.post('/db/main/addtemplate.php', { + 'name': n, + 'text': text, + 'subject': subject, + 'date': date, + 'pdf': true + }, function (rv) { tid = rv; }); + + localStorage.setItem('pdf_template', tid); + alert(unescape('Neues Template ID ' + tid + ' mit den aktuellen Werten wurde erzeugt.\r\n\r\nDie Seite lädt nun neu.')); + location.reload(); +} + +function renamePDFTemplate() { + var id = $('#pdf_template :selected').attr('data-id'); + var on = $('#pdf_template :selected').attr('data-name'); + var n = prompt('Name des Templates:', on); + if (!n) return; + + $.ajaxSetup({async:false}); + $.post('/db/main/rentemplate.php', { + 'id': id, + 'name': n, + 'pdf': true + }); + + $('#pdf_template :selected').attr('data-name', n); + $('#pdf_template :selected').text(n + ' (ID ' + id + ')'); +} + +function delPDFTemplate() { + var id = $('#pdf_template').val(); + var v = $('#pdf_template :selected').text(); + if (!v) return; + + if (confirm(unescape('Wirklich Template\n "' + v + '"\nunwiderruflich verwerfen?'))) { + $.ajaxSetup({async:false}); + $.post('/db/main/deltemplate.php', { + 'id': id, + 'pdf': true + }); + $('#pdf_template :selected').remove(); + $('#pdf_template').css('background', 'red'); + } +} + +function loadPDFTemplate() { + console.log($('#pdf_template :selected').attr('data-text').replace(/"/g, '"')); + $("#editor .ql-editor").html($('#pdf_template :selected').attr('data-text')); + + $('input[name=subject]').val($('#pdf_template :selected').attr('data-subject')); + $('input[name=date]').val($('#pdf_template :selected').attr('data-date')); + $('select[name=fn]').val($('#pdf_template :selected').attr('data-fn')); + + setTimeout(function () { + $('#pdf_template').css('background', '#cdf5cd'); + }, 200); +} + +function savePDFTemplate() { + var text = $("#editor .ql-editor").html(); + var subject = $('input[name=subject').val(); + var date = $('input[name=date]').val(); + var fn = $('select[name=fn]').val(); + var id = $('#pdf_template').val(); + + $('#pdf_template :selected').attr('data-text', text); + $('#pdf_template :selected').attr('data-subject', subject); + $('#pdf_template :selected').attr('data-date', date); + $('#pdf_template :selected').attr('data-fn', fn); + $('#pdf_template :selected').text($('#pdf_template :selected').attr('data-name') + ' (ID ' + $('#pdf_template :selected').attr('data-id') + ')'); + + $.ajaxSetup({async:false}); + $.post('/db/main/updtemplate.php', { + 'id': id, + 'text': text, + 'subject': subject, + 'date': date, + 'fn': fn, + 'pdf': true + }); + + setTimeout(function () { + $('#pdf_template').css('background', '#cdf5cd'); + }, 200); +} + +<? minEnd(); ?> +</script> + +<? +$sql = $_POST['sql']; +$post_sql = $_POST['postsql']; +$payload_sql = $_POST['payload_sql']; +$payload_sql_order = $_POST['payload_sql_order']; +$independent_payload_sql = $_POST['independent_payload_sql']; +$independent_payload_sql_order = $_POST['independent_payload_sql_order']; +require_once __DIR__ . "/templater_common.php"; +?> + +<script> +<? minStart(); ?> + +function getOne() { + if ($('select[name=fn]').val() == "") { + alert(unescape('Bitte Auswahl bei Dokument (Dateiname) treffen!')); + return; + } + + var html = $('#preview').html(); + $('input[name=html]').val(html); + $('#getpdf').submit(); +} + +function sendOne(skip) { + if ($('select[name=fn]').val() == "") { + alert(unescape('Bitte Auswahl bei Dokument (Dateiname) treffen!')); + return; + } + + if (typeof skip !== 'boolean') + skip = false; + + if (typeof pivot.__done !== 'undefined') { + if (!confirm(unescape('Diese Adressatenkombination wurde schon generiert. Wiederholen und Überschreiben?'))) + return; + } + + var subject = $('input[name=subject]').val(); + var fn = $('select[name=fn]').val(); + var date = $('input[name=date]').val(); + var organisation = $('input[name=organisation]').val(); + var anrede = $('input[name=anrede]').val(); + var anrede_briefkopf = $('input[name=anrede_briefkopf]').val(); + var titel = $('input[name=titel]').val(); + var vorname = $('input[name=vorname]').val(); + var nachname = $('input[name=nachname]').val(); + var strasse = $('input[name=strasse]').val(); + var adresszusatz = $('input[name=adresszusatz]').val(); + var plz = $('input[name=plz]').val(); + var ort = $('input[name=ort]').val(); + var template = $('input[name=template]').val(); + var uid = $('input[name=uid]').val(); + var ddata = $('input[name=data]').val(); + var html = $('#preview').html(); + + var noerror = false; + var response = ""; + $.ajaxSetup({async:false}); + $.ajax({ + type: 'POST', + url: '/db/main/dopdf.php?save', + data: { + 'subject': subject, + 'fn': fn, + 'date': date, + 'organisation': organisation, + 'anrede': anrede, + 'anrede_briefkopf': anrede_briefkopf, + 'titel': titel, + 'vorname': vorname, + 'nachname': nachname, + 'strasse': strasse, + 'adresszusatz': adresszusatz, + 'plz': plz, + 'ort': ort, + 'template': template, + 'uid': uid, + 'data': ddata, + 'html': html + }, + success: function (d, s, x) { + if (d == 1) { + noerror = true; + response = x.responseText; + } + } + }); + + if (noerror && response == '1') { + pivot.__done = true; + delete pivot.__failed; + + redoRows($("tr[data-id='" + pivot.uid + "']")[0], 0, 0, 0, pivot.index); + redoRows($("tr[data-id='" + pivot.UID + "']")[0], 0, 0, 0, pivot.index); + redoRows($("tr[data-id='" + pivot.ruid + "']")[0], 0, 0, 0, pivot.index); + redoRows($("tr[data-id='" + pivot.RUID + "']")[0], 0, 0, 0, pivot.index); + redoRows($("tr[data-id='" + pivot.id + "']")[0], 0, 0, 0, pivot.index); + redoRows($("tr[data-id='" + pivot.ID + "']")[0], 0, 0, 0, pivot.index); + redoRows($("tr[data-id='" + pivot.genuid + "']")[0], 0, 0, 0, pivot.index); + + var stl = ""; + if (organisation) stl += organisation + ' / '; + stl += vorname + ' ' + nachname; + + if (!skip) alert('PDF erfolgreich fuer ' + stl + ' erstellt.'); + + $('#pdf_status').html('PDF erfolgreich: ' + stl); + return true; + } + + pivot.__failed = true; + delete pivot.__done; + + redoRows($("tr[data-id='" + pivot.uid + "']")[0], 0, 0, 0, pivot.index); + redoRows($("tr[data-id='" + pivot.UID + "']")[0], 0, 0, 0, pivot.index); + redoRows($("tr[data-id='" + pivot.id + "']")[0], 0, 0, 0, pivot.index); + redoRows($("tr[data-id='" + pivot.ID + "']")[0], 0, 0, 0, pivot.index); + redoRows($("tr[data-id='" + pivot.ruid + "']")[0], 0, 0, 0, pivot.index); + redoRows($("tr[data-id='" + pivot.RUID + "']")[0], 0, 0, 0, pivot.index); + redoRows($("tr[data-id='" + pivot.genuid + "']")[0], 0, 0, 0, pivot.index); + + var stl = ""; + if (organisation) stl += organisation + ' / '; + stl += vorname + ' ' + nachname; + + alert('Fehler beim Generieren fuer ' + stl + ': ' + response); + $('#pdf_status').html('Fehler: ' + stl); + return false; +} + +function waitASec(time) { + $.ajaxSetup({async:false}); + $.post('/db/main/delay.php', { + time: time + }); +} + +function sendAllDone() { + $('#pdf_modal').hide(); + window.scrollTo(0, 0); + alert(unescape('Fertig. Erfolg für ' + count_s + ' Adressaten.\nFehlgeschlagen bei ' + count_f + '.')); + $('#pdf_status').html('Erfolg: ' + count_s + ', Fehler: ' + count_f); +} + +function sendAllLoop() { + if (typeof window.emergencyOff !== 'undefined') { + sendAllDone(); + delete window.emergencyOff; + return; + } + + if (typeof pivot.__done === 'undefined') { + $('#pdf_status').html('Generiere fuer: ' + pivot['Vorname'] + ' ' + pivot['Nachname']); + + if (sendOne(true)) count_s++; + else count_f++; + + pivot_iter++; + if (pivot_iter < data.length) { + pivot = data[pivot_iter]; + bP(); + setTimeout(sendAllLoop, 100); + return; + } + + setTimeout(sendAllDone, 100); + return; + } + + pivot_iter++; + if (pivot_iter < data.length) { + pivot = data[pivot_iter]; + bP(); + setTimeout(sendAllLoop, 10); + return; + } + + setTimeout(sendAllDone, 100); + return; +} + +function sendAll() { + if ($('select[name=fn]').val() == "") { + alert(unescape('Bitte Auswahl bei Dokument (Dateiname) treffen!')); + return; + } + + if (!confirm(unescape('Wirklich fuer ' + $.grep(data, function (e) { return (typeof e.__done === 'undefined'); }).length + ' Adressaten generieren?'))) + return; + + count_s = 0; + count_f = 0; + pivot = data[0]; + pivot_iter = 0; + bP(); + + window.scrollTo(0, 0); + $('#pdf_modal').show(); + setTimeout(sendAllLoop, 100); +} + +function abortAll() { + window.emergencyOff = true; +} + +<? minEnd(); ?> +</script> + +<? +include_once __DIR__ . "/footer.php"; +?> |