prepare("SELECT * FROM main_mandant");
$statement_mandant->execute();
$res_mandant = $statement_mandant->fetchall(PDO::FETCH_ASSOC);
foreach($res_mandant as $key_mandant => $value_mandant) {
if($value_mandant['id'] == $current_mandant) {
echo "".$value_mandant['description']."";
}else {
echo "".$value_mandant['description']."";
}
}
}
function current_mandant($current_mandant) {
$statement_mandant = $GLOBALS['pdo_conn']->prepare("SELECT * FROM main_mandant WHERE id = :id");
$statement_mandant->execute(array(':id' => $current_mandant));
$res_mandant = $statement_mandant->fetch(PDO::FETCH_ASSOC);
return $res_mandant;
}
function getDepartments($current_mandant) {
$statement_departments = $GLOBALS["pdo_conn"]->prepare("SELECT DISTINCT main_department.* FROM main_department LEFT JOIN main_department_mandant_link ON main_department.id = main_department_mandant_link.main_department_id WHERE main_mandant_id = :main_mandant_id");
$statement_departments->execute(array(':main_mandant_id' => $current_mandant));
$res_departments = $statement_departments->fetchall(PDO::FETCH_ASSOC);
echo "Alle
";
foreach ($res_departments as $key_departments => $value_departments) {
echo "".$value_departments['description']."
";
}
}
function getTeilen(){
$current_department = isset($_GET['current_department']) ? $_GET['current_department'] : null;
$statement_mandant = $GLOBALS['pdo_conn']->prepare("SELECT * FROM `main_department` ORDER BY description ASC");
// $statement_mandant = $GLOBALS['pdo_conn']->prepare("SELECT * FROM `main_department`");
$statement_mandant->execute();
$res_mandant = $statement_mandant->fetchAll(PDO::FETCH_ASSOC);
foreach($res_mandant as $key_mandant => $value_mandant) {
$query = "SELECT * FROM main_contact_department WHERE main_department_id = ".$value_mandant['id'];
// var_dump($query);
$result = @mysqli_query($GLOBALS['mysql_con'], $query);
// if (mysqli_num_rows($result) <= 0) {
// continue;
// }
$isActive = ($current_department == $value_mandant['id']) ? 'active' : '';
echo "";
}
}
function getTeilenDropdown() {
$current_department = isset($_GET['current_department']) ? $_GET['current_department'] : null;
$statement_mandant = $GLOBALS['pdo_conn']->prepare("SELECT * FROM `main_department` ORDER BY description ASC");
$statement_mandant->execute();
$res_mandant = $statement_mandant->fetchAll(PDO::FETCH_ASSOC);
echo "";
}
function get_person_role($current_mandant, $contact_id) {
$conn = $GLOBALS['mysql_con'];
$current_mandant = (int)$current_mandant;
$contact_id = (int)$contact_id;
$query = "SELECT main_role_id
FROM main_contact_department
WHERE main_mandant_id = $current_mandant
AND main_contact_id = $contact_id
LIMIT 1";
$res = mysqli_query($conn, $query);
if (!$res) {
return "";
}
$row = mysqli_fetch_array($res, MYSQLI_ASSOC);
if (!$row || empty($row['main_role_id'])) {
return "";
}
$role_id = (int)$row['main_role_id'];
$get_role = "SELECT description
FROM main_role
WHERE id = $role_id
LIMIT 1";
$role_res = mysqli_query($conn, $get_role);
if (!$role_res) {
return "";
}
$role_row = mysqli_fetch_array($role_res, MYSQLI_ASSOC);
return $role_row['description'] ?? "";
}
function get_person_einricht($current_mandant, $contact_id) {
$conn = $GLOBALS['mysql_con'];
$current_mandant = (int)$current_mandant;
$contact_id = (int)$contact_id;
$query = "SELECT main_einricht_id
FROM main_contact_department
WHERE main_mandant_id = $current_mandant
AND main_contact_id = $contact_id
LIMIT 1";
// var_dump($query);
$res = mysqli_query($conn, $query);
if (!$res) {
return "";
}
$row = mysqli_fetch_array($res, MYSQLI_ASSOC);
if (!$row || empty($row['main_einricht_id'])) {
return "";
}
$role_id = (int)$row['main_einricht_id'];
$get_role = "SELECT description
FROM organigramm_einricht
WHERE id = $role_id
LIMIT 1";
$role_res = mysqli_query($conn, $get_role);
if (!$role_res) {
return "";
}
$role_row = mysqli_fetch_array($role_res, MYSQLI_ASSOC);
return $role_row['description'] ?? "";
}
function get_person_space($current_mandant, $contact_id) {
$conn = $GLOBALS['mysql_con'];
$current_mandant = (int)$current_mandant;
$contact_id = (int)$contact_id;
$query = "SELECT main_bereich_id
FROM main_contact_department
WHERE main_mandant_id = $current_mandant
AND main_contact_id = $contact_id
LIMIT 1";
// var_dump($query);
$res = mysqli_query($conn, $query);
if (!$res) {
return "";
}
$row = mysqli_fetch_array($res, MYSQLI_ASSOC);
if (!$row || empty($row['main_bereich_id'])) {
return "";
}
$role_id = (int)$row['main_bereich_id'];
$get_role = "SELECT description
FROM organogramm_space
WHERE id = $role_id
LIMIT 1";
$role_res = mysqli_query($conn, $get_role);
if (!$role_res) {
return "";
}
$role_row = mysqli_fetch_array($role_res, MYSQLI_ASSOC);
return $role_row['description'] ?? "";
}
function getList($current_mandant) {
$join = "";
$where = "WHERE main_contact.active = 1";
$join .= " LEFT JOIN main_contact_department ON main_contact.id = main_contact_department.main_contact_id";
$join .= " LEFT JOIN main_department ON main_contact_department.main_department_id = main_department.id";
if ($_GET['current_department']) {
$where .= " AND main_contact_department.main_mandant_id = " . $current_mandant . " AND main_contact_department.main_department_id IN ( SELECT md.id FROM main_department md WHERE md.id = " . $_GET['current_department'] . ")";
}
if ($_GET['tag']) {
$join .= " LEFT JOIN main_contact_tags_link ON main_contact.id = main_contact_tags_link.main_contact_id";
$where .= " AND main_contact_tags_link.main_contact_tags_id = " . $_GET['tag'];
}
$query = "SELECT main_contact.*, GROUP_CONCAT(DISTINCT main_department.description SEPARATOR ', ') AS department_list
FROM main_contact
$join
$where
GROUP BY main_contact.id
ORDER BY main_contact.name";
$result = @mysqli_query($GLOBALS['mysql_con'], $query);
// Beginne die Tabelle
echo '';
}
?>
";
} else {
echo "