86 lines
2.5 KiB
PHP
Executable File
86 lines
2.5 KiB
PHP
Executable File
<?php
|
|
require_once("../config/datenbankanbindung.php");
|
|
$db = dbconnect();
|
|
$output = '';
|
|
$script = '';
|
|
$script = $_POST['script'];
|
|
|
|
if(isset($_POST["query"]))
|
|
{
|
|
$search = mysqli_real_escape_string($db, $_POST["query"]);
|
|
if($script == "kand_del" OR $script == "termine_kandidat"){
|
|
$query = "
|
|
SELECT a.ka_id, vorname, nachname
|
|
FROM dvm_kandidat a, dvm_term_kand b, dvm_tanpool c
|
|
WHERE a.ka_id =b.ka_id
|
|
AND b.tp_id =c.tp_id
|
|
AND c.login_dat = '0000-00-00 00:00:00'
|
|
AND (vorname LIKE '%".$search."%'
|
|
OR nachname LIKE '%".$search."%')
|
|
ORDER BY nachname ASC, vorname ASC";
|
|
}else{
|
|
$query = "
|
|
SELECT ka_id, vorname, nachname
|
|
FROM dvm_kandidat
|
|
WHERE vorname LIKE '%".$search."%'
|
|
OR nachname LIKE '%".$search."%'
|
|
";
|
|
}
|
|
}
|
|
else
|
|
{
|
|
if($script == "kand_del" OR $script == "termine_kandidat"){
|
|
$query = "
|
|
SELECT a.ka_id, vorname, nachname
|
|
FROM dvm_kandidat a, dvm_term_kand b, dvm_tanpool c
|
|
WHERE a.ka_id =b.ka_id
|
|
AND b.tp_id =c.tp_id
|
|
AND c.login_dat = '0000-00-00 00:00:00'
|
|
ORDER BY nachname ASC, vorname ASC";
|
|
}else{
|
|
$query = "
|
|
SELECT ka_id, vorname, nachname
|
|
FROM dvm_kandidat
|
|
ORDER BY nachname, vorname";
|
|
}
|
|
}
|
|
$result = mysqli_query($db, $query);
|
|
if(mysqli_num_rows($result) > 0)
|
|
{
|
|
while($row = mysqli_fetch_array($result))
|
|
{
|
|
|
|
$result2 = $db->query("SELECT date_format(tm_datum, '%d.%m.%Y - %H:%i Uhr') tm_datum_form, tm_datum
|
|
FROM dvm_term_kand a, dvm_termine b
|
|
WHERE a.tm_id = b.tm_id
|
|
AND a.ka_id = '$row[ka_id]'
|
|
ORDER BY tk_id DESC
|
|
LIMIT 1");
|
|
$row2 = $result2->fetch_array();
|
|
if($row2['tm_datum'] == '0000-00-00 00:00:00'){
|
|
$tm_datum_form = "-";
|
|
}else{
|
|
$tm_datum_form = $row2['tm_datum_form'];
|
|
}
|
|
|
|
|
|
if(mysqli_num_rows($result) == 1){
|
|
$output .= "
|
|
<option value='$row[ka_id]' selected>$row[nachname], $row[vorname] ($tm_datum_form)</option>
|
|
";
|
|
|
|
}else{
|
|
$output .= "
|
|
<option value='$row[ka_id]'>$row[nachname], $row[vorname] ($tm_datum_form)</option>
|
|
";
|
|
|
|
}
|
|
}
|
|
echo $output;
|
|
}
|
|
else
|
|
{
|
|
echo 'Data Not Found';
|
|
}
|
|
?>
|