<?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 dvm_dienststellen a
              WHERE a.dst_id NOT IN (SELECT dst_id
                                       FROM dvm_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."%'
              ORDER BY bez ASC";
}
else
{
	$query = "
	SELECT a.dst_id, bez, plz, ort
               FROM dvm_dienststellen a
              WHERE a.dst_id NOT IN (SELECT dst_id
                                       FROM dvm_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')
              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]</option>
		";
	    
	    }else{
		$output .= "
			<option value='$row[dst_id]'>$row[bez]</option>
		";
	    
	    }
	}
	echo $output;
}
else
{
	echo 'Data Not Found';
}
?>