From cdea8caa5617f0cb77bcbc9803759abd2df50644 Mon Sep 17 00:00:00 2001 From: Niklas Olmes Date: Fri, 24 Apr 2026 19:30:00 +0200 Subject: stipcrm --- templater_common.php | 567 +++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 567 insertions(+) create mode 100644 templater_common.php (limited to 'templater_common.php') diff --git a/templater_common.php b/templater_common.php new file mode 100644 index 0000000..7f6a684 --- /dev/null +++ b/templater_common.php @@ -0,0 +1,567 @@ + += 2001 AND Förderbeginn > '2000-01-01' GROUP BY Person;"; +$stmt = $mysqli->prepare($stips_sql); +$stmt->bind_result($stips_persid); +$stmt->execute(); +$stips = []; +while ($stmt->fetch()) { + $stips[$stips_persid] = 1; +} +$stmt->reset(); +?> + +prepare($prefs_sql); +$stmt->bind_param("i", $_SESSION['auth_userid']); +$stmt->bind_result($prefs_persid, $prefs_salutation); +$stmt->execute(); +$prefs = []; +while ($stmt->fetch()) { + $prefs[$prefs_persid] = $prefs_salutation; +} +$stmt->reset(); +?> + + +
+ Einzel-E-Mail-Modul ist aktiv. Alle Adressaten werden zusammengefasst und sind direkter Adressat (To) der E-Mail. Da sich damit alle Adressaten gegenseitig sehen können, sollte diese Funktion nur verwendet werden, wenn dies datenschutzrechtlich unbedenklich ist. Individualisierung durch Templateauszeichnungen ist selbstredent nicht möglich. +
+ +
+prepare($sql); +$stmt->execute(); +$r = $stmt->get_result(); +echo $mysqli->error; + +$data = []; +$i = 0; +while (($l = $r->fetch_object())) { + $e = []; + foreach ($l as $k => $v) { + $e[$k] = $v; + if ($k == 's2' || $k == 's3' || $k == 's4' || $k == 's5' || $k == 's6' || $k == 'data') + $e[$k] = json_decode($v); + } + $e['index'] = $i; + $data[] = $e; + $i++; +} +$stmt->reset(); + +if ($payload_sql) { + $payload_sql = $payload_sql . $ids_in; + if ($payload_sql_order) + $payload_sql .= " ORDER BY " . $payload_sql_order; + $stmt = $mysqli->prepare($payload_sql); + $stmt->execute(); + $r = $stmt->get_result(); + echo $mysqli->error; + + $payload = []; + $i = 0; + while (($l = $r->fetch_object())) { + $e = []; + foreach ($l as $k => $v) { + $e[$k] = $v; + } + $e['index'] = $i; + $payload[] = $e; + $i++; + } + $stmt->reset(); +} + +if ($independent_payload_sql) { + if ($independent_payload_sql_order) + $independent_payload_sql .= " ORDER BY " . $independent_payload_sql_order; + $stmt = $mysqli->prepare($independent_payload_sql); + $stmt->execute(); + $r = $stmt->get_result(); + echo $mysqli->error; + + $independent_payload = []; + $i = 0; + while (($l = $r->fetch_object())) { + $e = []; + foreach ($l as $k => $v) { + $e[$k] = $v; + } + $e['index'] = $i; + $independent_payload[] = $e; + $i++; + } + $stmt->reset(); +} +?> + +

Template

+ + + +
+
{{ '' | signatur }}
+
+ +prepare($sql); + $stmt->bind_result($pid, $ptitle); + $stmt->execute(); +?> + + + + + + +

Vorschau

+ + + +
+
+
+ +

Adressaten

+ + + +prepare($sql); + $stmt->execute(); + $r = $stmt->get_result(); + $id = "email"; + $order = '[]'; + $noautolinks = true; + $nodefaultlinks = true; + $links = [ + '#' => '#', + 'RUID' => '#', + 'ruid' => '#', + 'UID' => '#', + 'uid' => '#', + 'ID' => '#', + 'id' => '#', + ]; + $rowcallback = "redoRows"; + $norefresh = true; + include __DIR__ . '/autotable.php'; + $stmt->reset(); +})(); +?> + + + + + + -- cgit v1.3.1