awo-hamburg-intranet/module/infopoint/dashboard_infopoint.php

<?php

require_once(MODULE_PATH . "infopoint/infopoint_config.inc.php");

$siteparts     = \DynCom\mysyde\common\classes\Siteparts::get();
$pageIds       = array();
$sitepartCount = array();
$formname      = "form_infopoint";
$translation   = \DynCom\mysyde\common\classes\Registry::get("translation");

$action = (isset($_GET['action']) ? $_GET['action'] : "");

if ($action != "" && $action != "admin_login") {
    require_once(MODULE_PATH . "infopoint/infopoint.inc.php");
    exit();
}

$pages_anzahl    = array();

$query  = "SELECT id, count(*) AS anzahl FROM main_infopoint_pages GROUP BY id";
$result = @mysqli_query($GLOBALS['mysql_con'], $query);
while ($row = @mysqli_fetch_array($result, 1)) {
    $pages_anzahl[] = $row['anzahl'];
}

$presets_anzahl    = array();

$query  = "SELECT id, count(*) AS anzahl FROM main_infopoint_presets GROUP BY id";
$result = @mysqli_query($GLOBALS['mysql_con'], $query);
while ($row = @mysqli_fetch_array($result, 1)) {
    $presets_anzahl[] = $row['anzahl'];
}

$screens_anzahl    = array();

$query  = "SELECT id, count(*) AS anzahl FROM main_infopoint_screens GROUP BY id";
$result = @mysqli_query($GLOBALS['mysql_con'], $query);
while ($row = @mysqli_fetch_array($result, 1)) {
    $screens_anzahl[] = $row['anzahl'];
}

$anzahl_pages = count($pages_anzahl);
$anzahl_presets = count($presets_anzahl);
$anzahl_screens = count($screens_anzahl);
?>

<div id="mainContent">
    <?php echo current_website_language($site, $language); ?>
    <h1><?php echo get_translation('left_infopoint'); ?></h1>

    <div class="dashboard_part_left">
        <h2><?php echo get_translation('left_infopoint'); ?></h2>

        <a class="dashoard_box button_inhalt_collection"
           href="<?php echo get_menu_link($_GET["level_1"] . "/screens", $site, $language); ?>">
            <span class="dashboard_box_number"><?php echo(isset($anzahl_screens) ? $anzahl_screens : 0); ?></span>
            <span class="dashboard_box_description"><?php echo $translation->get("infopoint_screens"); ?></span>
            <img src="<?php echo PATH_SETUP_ICON_INFOPOINT . "liste.png"; ?>" />
        </a>

        <a class="dashoard_box button_inhalt_collection"
           href="<?php echo get_menu_link($_GET["level_1"] . "/pages", $site, $language); ?>">
            <span class="dashboard_box_number"><?php echo(isset($anzahl_pages) ? $anzahl_pages : 0); ?></span>
            <span class="dashboard_box_description"><?php echo $translation->get("infopoint_pages"); ?></span>
            <img src="<?php echo PATH_SETUP_ICON_INFOPOINT . "dokumente_2.png"; ?>" />
        </a>

        <a class="dashoard_box button_inhalt_collection"
           href="<?php echo get_menu_link($_GET["level_1"] . "/presets", $site, $language); ?>">
            <span class="dashboard_box_number"><?php echo(isset($anzahl_presets) ? $anzahl_presets : 0); ?></span>
            <span class="dashboard_box_description"><?php echo $translation->get("infopoint_presets"); ?></span>
            <img src="<?php echo PATH_SETUP_ICON_INFOPOINT . "dokumente_2.png"; ?>" />
        </a>
    </div>

    <div class="dashboard_part_right">
        <h2><?php echo get_translation('last_changed_faq'); ?></h2>

        <form id="<?= $formname ?>" name="<?= $formname ?>" method="post" enctype="multipart/form-data">
            <input type="hidden" class="selected_linklist_row" name="input_id" value="" />

            <div class="requestLoader"></div>
            <div id="page_linklist">
                <?
                $query = "SELECT
        			main_faq.id, 
                    GROUP_CONCAT(' ', IF(main_faq_group_link.active = 1,main_faq_setup_group.description,NULL)) AS '".$translation->get("linked_with")."',
        			main_faq.description AS '" . $translation->get("description") . "',
        			from_unixtime(main_faq.modified_date, '%d.%m.%Y %H:%i:%s') AS '" . $translation->get("changed_on") . "', 
        			main_admin_user.name AS '" . $translation->get("changed_by") . "' 
        		from 
        			main_faq left join main_admin_user
        		ON 
        			main_faq.modified_user = main_admin_user.id
                LEFT JOIN
                    main_faq_group_link 
                ON 
                    main_faq_group_link.main_faq_id = main_faq.id
                LEFT JOIN 
                    main_faq_setup_group
                ON 
                    main_faq_setup_group.id = main_faq_group_link.main_faq_setup_group_id

        		where 
        			(main_faq.main_language_id = " . (int)$GLOBALS["language"]['id'] . ")
                GROUP BY main_faq_group_link.main_faq_id ORDER BY main_faq.modified_date desc limit 20";

                $format = array('option', 'text', 'text', 'text', 'text');
                if ($result = @mysqli_query($GLOBALS['mysql_con'], $query)) {
                    linklist($result, $formname, $format, "input_id", "infoboard_list");
                }
                ?>
            </div>
        </form>
    </div>