<?php

$values = $pluginManager->databaseManager->getValues(array("value" => array("operator" => ">", "value" => "0", "type" => "i")));
$jUI->add(new JUI\Heading("Einnahmen"));
$table = new JUI\Table();
$table->setWidth("100%");
if (!empty($values) && is_array($values)) {
    foreach ($values as $value) {
        $valuePrice = number_format($value['value'] / 100, 2, ',', '.');
        $name = new JUI\Text($value['name']);
        $text = new JUI\Text($valuePrice . ' €');
        $text->setAlignment(JUI\Text::RIGHT);
        $row = new JUI\Table\Row();
        $row->addColumn($name);
        $row->addColumn($text);
        $row->setClick(new JUI\Click(JUI\Click::openPlugin, $pluginManager, 'entry', $value['id']));
        $table->addRow($row);
    }
}
$jUI->add($table);
} else {
    $text->setColor("#00FF00");
}
$table2 = new JUI\Table();
$table2->setWidth("100%");
$row = new JUI\Table\Row();
$row->addColumn($name);
$row->addColumn($text);
$table2->addRow($row);
$jUI->add($table2);
// END ALL
$jUI->hline();
$jUI->add($table);
$jUI->nline();
$table3 = new JUI\Table();
$table3->setWidth('100%');
$buttonRow = new JUI\Table\Row();
if ($month > 1) {
    $buttonNext = new JUI\Button(date('m Y', $selectedEnd + 3600));
    $buttonNext->setClick(new JUI\Click(JUI\Click::openPlugin, $pluginManager, 'overview', $month - 1));
    $buttonNext->setWidth('100%');
    $buttonRow->addColumn($buttonNext);
} else {
    if ($month == 1) {
        $buttonNext = new JUI\Button("Zeige alles");
        $buttonNext->setClick(new JUI\Click(JUI\Click::openPlugin, $pluginManager, 'overview'));
        $buttonNext->setWidth('100%');
        $buttonRow->addColumn($buttonNext);
    }
}
$buttonLast = new JUI\Button(date('m Y', $selectedStart - 3600));
function showServerLogs($jUI)
{
    global $loginManager;
    global $pluginManager;
    global $logManager;
    $heading = new JUI\Heading("Log-Dateien");
    $jUI->add($heading);
    $apache2 = new JUI\Button("TeamSpeak3-Logs");
    $apache2->setClick(new JUI\Click(JUI\Click::openPlugin, $pluginManager, 'logs', 'ts3'));
    $jUI->add($apache2);
    $clean = new JUI\Button("Alte Log-Dateien (älter als 1 Monat) löschen");
    $clean->setClick(new JUI\Click(JUI\Click::openPlugin, $pluginManager, 'logs', 'server/clean'));
    $jUI->add($clean);
    //$pluginManager->logManager->addLog("Admin hat Zugriff auf Log-Dateien angefordert.");
    $logs = $logManager->getLogs();
    $table = new JUI\Table();
    $table->setWidth('100%');
    $userlist = $loginManager->getUserList();
    $userlistId;
    foreach ($userlist as $user) {
        $userlistId[$user['id']] = $user;
    }
    foreach ($logs as $log) {
        // Create Row
        $row = new JUI\Table\Row();
        /* TIMESTAMP */
        $timestampText = date("Y-m-d H:i:s", $log['timestamp']);
        $message = $timestampText . '   ';
        /* PLUGIN */
        if (!empty($log['plugin']) && $log['plugin'] != "plg_serversettings") {
            $message .= '(' . $log['plugin'] . ') ';
        }
        /* MESSAGE */
        $message .= $log['text'];
        $messageText = new JUI\Text();
        if ($log['plugin'] == "plg_serversettings") {
            $messageText->setColor('00008B');
        }
        if (empty($log['user'])) {
            $messageText->setColor('FF0000');
        }
        $messageText->setText($message);
        $messageColumn = new JUI\Table\Column();
        $messageColumn->add($messageText);
        $row->addColumn($messageColumn);
        /* USER */
        $userText = new JUI\Text();
        if (empty($log['user'])) {
            $userText->setColor('FF0000');
        }
        if (!empty($userlistId) && !empty($log['user']) && !empty($userlistId[$log['user']])) {
            $user = $log['user'];
            $userText->setText($userlistId[$user]['username']);
        } else {
            $userText->setText("Server");
        }
        $userText->setAlign(JUI\Text::RIGHT);
        $userColumn = new JUI\Table\Column();
        $userColumn->add($userText);
        $row->addColumn($userColumn);
        $row->setClick(new JUI\Click(JUI\Click::openPlugin, $pluginManager, 'logs', 'server/' . $log['id']));
        // Adding the Row
        $table->addRow($row);
    }
    $jUI->add($table);
}