0, SUM(Spenden.Betrag), 0)) AS Eingang,
IF(Förderer.`SEPA-Lastschrift erteilt`, 0, ((150 * contracts.ss_months) + (150 * contracts.ls_months)) - IF(SUM(Spenden.Betrag) > 0, SUM(Spenden.Betrag), 0)) AS Fehlbetrag
FROM contracts
LEFT JOIN Förderer ON contracts.patron = Förderer.ID
LEFT JOIN Organisationen ON Förderer.Organisation = Organisationen.ID
LEFT JOIN Spenden ON contracts.id = Spenden.contract
WHERE contracts.id=?
";
$stmt = $mysqli->prepare($sql);
$stmt->bind_param('i', $_GET['id']);
$stmt->execute();
$r = $stmt->get_result();
$l = $r->fetch_object();
$foerdID = $l->FoerdID;
$persID = $l->PersID;
$orgaID = $l->OrgaID;
$_title = 'Vertrag (ID ' . $_GET['id'] . ')' . ' zu: ' . $l->Förderer . '';
include_once __DIR__ . "/header.php";
?>
prepare($sql);
$stmt->bind_param('i', $orgaID);
$stmt->bind_result($id, $nachname, $vorname);
$stmt->execute();
$persXorga = [];
while ($stmt->fetch()) {
$persXorga[$id] = $nachname . ", " . $vorname;
}
$stmt->reset();
$id = "contract";
$entrytable = "contracts";
$def = [
"Förderer",
[10, '_FoerdID', '_=3Förderer', '_=3legal|rechtsformen~Rechtsform', '_=3Zuständig|demo'],
"Vertrag",
[10, '=2call#string|callsByID', 'valid_from#isodate~gültig von', 'valid_to#isodate~gültig bis', '=2ls#number~Anzahl Leistungsstipendien', 'ls_months#number~Monate', '=2ss#number~Anzahl Sozialstipendien', 'ss_months#number~Monate'],
[10, '_APID', '=5contact|persXorga~Ansprechpartner', '_Summe', '_Eingang', '_=2Fehlbetrag'],
[10, '=9remark~Anmerkung', '+=1kontrolliert'],
['*widmung'],
];
include __DIR__ . '/autoform.php';
})();
(function () {
$title = "Spenden zum Vertrag";
$id = "donationsXcontract2";
$sql = "
SELECT
Spenden.ID AS SpendenID,
Spenden.Person AS PersID,
Personen.Nachname,
Personen.Vorname,
Spenden.Organisation AS OrgaID,
Organisationen.Name AS Organisation,
Spenden.Betrag,
DATE(Spenden.Geldeingang) AS Geldeingang
FROM Spenden
LEFT JOIN Personen ON Spenden.Person = Personen.ID
LEFT JOIN Organisationen ON Spenden.Organisation = Organisationen.ID
WHERE Spenden.contract=" . $_GET['id'];
$thdef = ['SpendenID', 'PersID', 'Nachname', 'Vorname', 'OrgaID', 'Organisation', 'Betrag', 'Geldeingang'];
$order = '[[1, "desc"]]';
$ajax = $nospinner = true;
include __DIR__ . '/autotable.php';
})();
include_once __DIR__ . '/footer.php';