/* vim: set ts=4 sw=4 et : */
require_once __DIR__ . "/check_auth.php";
require_once __DIR__ . "/../includes/common.php";
session_write_close();
require_once __DIR__ . "/lookup.php";
require_once __DIR__ . "/lookup_more.php";
$persID = $_GET['id'];
include_once __DIR__ . "/fotolink.php";
(function () use ($mysqli, $_title, $persID, $fotolink, &$email) {
$sql = "
SELECT Personen.*, DATE(Geburtsdatum) AS Geburtsdatum, Personen_Prefs.salutation, IF(UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(appprofiles.lastnot) < (60*60*24), 1, 0) AS AppNotifications, appprofiles.id AS AppProfileID, SUM(SpendenTOT.Betrag) AS `Gesamtsumme`, (SELECT SUM(Spenden.Betrag) FROM Spenden WHERE Spenden.Person = ? AND Spenden.SuperID IS NULL AND DATE_SUB(CURDATE(), INTERVAL 365 DAY) <= Spenden.Geldeingang) AS `Summe letzte 365 Tage`
FROM Personen
LEFT JOIN Personen_Prefs ON Personen.ID = Personen_Prefs.persid AND Personen_Prefs.userid = ?
LEFT JOIN appprofiles ON Personen.ID = appprofiles.persid
LEFT JOIN Spenden AS SpendenTOT ON Personen.ID = SpendenTOT.Person AND SpendenTOT.SuperID IS NULL
WHERE Personen.ID=?
";
$stmt = $mysqli->prepare($sql);
$stmt->bind_param('iii', $persID, $_SESSION['auth_userid'], $persID);
$stmt->execute();
$r = $stmt->get_result();
$l = $r->fetch_object();
$l->Foto = $fotolink;
$email = $l->Email;
$_title = '' . $l->Nachname . ', ' . $l->Vorname . ' (ID ' . $persID . ')';
include_once __DIR__ . "/header.php";
$id = "persview";
$pdf_sql = $email_sql = "SELECT *, DATE(Geburtsdatum), CONCAT('', Personen.ID, 'person') AS uid FROM Personen WHERE Personen.ID IN ";
include __DIR__ . '/autoemail.php';
include __DIR__ . '/autopdf.php';
?>
=$_title?>
$id = "pers";
$entrytable = "Personen";
$def = [
"Stammdaten",
[11, '=2Geschlecht', '=3Anrede', '=3anrede_briefkopf~Anrede Briefkopf', '_^w~w ', '_^m~m ', '_^d~div'],
['informale Ansprache', 'Ansprache', 'Titel', 'salutation|salutations~Individ. autom. Ansprache (' . $_SESSION['auth_user'] . ')'],
['Vorname', 'Nachname', 'Geburtsname', 'user'],
['!Foto', 'Geburtsdatum#isodate', 'Geburtsort', 'Staatsangehörigkeit|laenderByID'],
"Kontaktdaten",
['Straße', 'Adresszusatz'],
['PLZ', 'Ort', 'Land|laenderByID'],
['Email#email', 'Email-Privat#email', 'Email-Geschäftlich#email'],
['Telefon', 'Handy', 'Fax', 'Homepage'],
"Spenderinformationen",
['+Liste Privatspender', '+Ewige Liste Privatspender', '_Gesamtsumme', '_Summe letzte 365 Tage'],
"Sonstiges",
[6, '_Newsletter|threeWay~Anmeldung Newsletter', '+wuenscht_keine_Emails~wünscht keine Emails', '+stellenangebote~Erhalt Stellenangebote', '+ideellesfp~Ideelles Förderprogramm', '+infos~Erhalt Infos', '+community~Studienfonds Community']
];
if (in_array($persID, [1, 2, 3])) {
$def[] = ['*signature~Signatur'];
}
$bottom = <<
$('#persForm button.btn_w').click(function () {
$('#persForm input[name=Geschlecht]').val('weiblich').trigger('change');
$('#persForm input[name=Anrede]').val('Frau').trigger('change');
$('#persForm input[name=anrede_briefkopf]').val('Frau').trigger('change');
$('#persForm input[name="informale Ansprache"]').val('Liebe').trigger('change');
$('#persForm input[name=Ansprache]').val('Sehr geehrte Frau').trigger('change');
return false;
});
$('#persForm button.btn_m').click(function () {
$('#persForm input[name=Geschlecht]').val('männlich').trigger('change');
$('#persForm input[name=Anrede]').val('Herr').trigger('change');
$('#persForm input[name=anrede_briefkopf]').val('Herrn').trigger('change');
$('#persForm input[name="informale Ansprache"]').val('Lieber').trigger('change');
$('#persForm input[name=Ansprache]').val('Sehr geehrter Herr').trigger('change');
return false;
});
$('#persForm button.btn_d').click(function () {
$('#persForm input[name=Geschlecht]').val('divers').trigger('change');
$('#persForm input[name=Anrede]').val('').trigger('change');
$('#persForm input[name=anrede_briefkopf]').val('').trigger('change');
$('#persForm input[name="informale Ansprache"]').val('Hallo').trigger('change');
$('#persForm input[name=Ansprache]').val('Guten Tag').trigger('change');
return false;
});
EOD;
include __DIR__ . '/autoform.php';
$stmt->reset();
})();
(function () use ($persID) {
$globstring = "{*-" . $persID . "person*," . $persID . "person*}_";
require_once __DIR__ . "/doc.php";
})();
include_once __DIR__ . '/notesXpers.php';
include_once __DIR__ . '/emailsXpers.php';
include_once __DIR__ . '/stipsXpers.php';
include_once __DIR__ . '/eventsXpers.php';
include_once __DIR__ . '/donationsXpers.php';
include_once __DIR__ . '/orgaXpers.php';
require_once __DIR__ . "/jumper.php";
require_once __DIR__ . "/footer.php";