patronspersons_by_year.php


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42

<?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.
 */
?>
<?php
/* vim: set ts=4 sw=4 et : */

$_year = $_GET['year'];
$fragment = "";

$social = "";
if (isset($_GET['social'])) {
    $social = "AND contracts.ss > 0";
    $fragment .= "Sozialstipendiums-";
}

$ds = "";
if (isset($_GET['ds'])) {
    $ds = "AND contracts.ls > 0";
    $fragment .= "Leistungstipendiums-";
}

$ideell = "";
if (isset($_GET['ideell'])) {
    $ds = "AND (contracts.ls < 1 AND contracts.ss < 1)";
    $fragment .= "Idellen-";
}

$_title = "Alle Personen bei " . $fragment . "Förderern des Förderjahres " . $_year . "/" . ($_year + 1) . " <small>(anhand Vertr&auml;ge)</small>";

$_constraint = "WHERE Förderer.ID IN (SELECT contracts.patron FROM contracts WHERE (contracts.valid_from >= '" . $_year . "-10-01') AND (contracts.valid_from < '" . ($_year + 1) . "-10-01') " . $social . " " . $ds . " " . $ideell . ")";

require __DIR__ . "/patronspersons_common.php";