62 lines
1.9 KiB
PHP
Executable File
62 lines
1.9 KiB
PHP
Executable File
<?php
|
|
if(!isset($_SESSION)) { session_start(); }
|
|
require_once("../config/datenbankanbindung.php");
|
|
$db = dbconnect();
|
|
$ka_id = $_SESSION["ka_id"];
|
|
$output = '';
|
|
if(isset($_POST["query"]))
|
|
{
|
|
$search = mysqli_real_escape_string($db, $_POST["query"]);
|
|
$query = "
|
|
SELECT a.dst_id, bez, plz, ort
|
|
FROM bpm_dienststellen a
|
|
WHERE a.dst_id NOT IN (SELECT dst_id
|
|
FROM bpm_dst_wunsch
|
|
WHERE ka_id = '$ka_id'
|
|
)
|
|
AND (gueltig_von <= date_format(now(), '%Y-%m-%d') OR gueltig_von = '0000-00-00')
|
|
AND (gueltig_bis >= date_format(now(), '%Y-%m-%d') OR gueltig_bis = '0000-00-00')
|
|
AND bez like '%".$search."%'
|
|
AND name != ''
|
|
AND register_dat != '0000-00-00 00:00:00'
|
|
ORDER BY bez ASC";
|
|
}
|
|
else
|
|
{
|
|
$query = "
|
|
SELECT a.dst_id, bez, plz, ort
|
|
FROM bpm_dienststellen a
|
|
WHERE a.dst_id NOT IN (SELECT dst_id
|
|
FROM bpm_dst_wunsch
|
|
WHERE ka_id = '$ka_id'
|
|
)
|
|
AND (gueltig_von <= date_format(now(), '%Y-%m-%d') OR gueltig_von = '0000-00-00')
|
|
AND (gueltig_bis >= date_format(now(), '%Y-%m-%d') OR gueltig_bis = '0000-00-00')
|
|
AND register_dat != '0000-00-00 00:00:00'
|
|
ORDER BY bez ASC";
|
|
}
|
|
$result = mysqli_query($db, $query);
|
|
if(mysqli_num_rows($result) > 0)
|
|
{
|
|
while($row = mysqli_fetch_array($result))
|
|
{
|
|
if(mysqli_num_rows($result) == 1){
|
|
$output .= "
|
|
<option value='$row[dst_id]' selected>$row[bez] ($row[plz] $row[ort])</option>
|
|
";
|
|
|
|
}else{
|
|
$output .= "
|
|
<option value='$row[dst_id]'>$row[bez] ($row[plz] $row[ort])</option>
|
|
";
|
|
|
|
}
|
|
}
|
|
echo $output;
|
|
}
|
|
else
|
|
{
|
|
echo 'Data Not Found';
|
|
}
|
|
?>
|