<?php

Lib::loadClass('RouteBase');
Lib::loadClass('UI');

class Route_Status extends RouteBase {

  public function defaultAction() {
    UI::gora();
    $_ = array(UI, 'h');
    UI::startTag('div', ['class' => "container"]);
    echo $_('h1', [], [
      $_('a', ['href'=>"index.php"], "SE"),
      " &raquo; ",
      " Status systemu procesy5"
    ]);
    try {
      DB::getPDO();

      if (1 == V::get('event_sheduler_on', '', $_POST)) {
        $this->fixEventSheduler();
      }

      $dbEvents = DB::getPDO()->fetchFirst(" SHOW VARIABLES WHERE VARIABLE_NAME = 'event_scheduler' ");
      // DBG::nicePrint($dbEvents, '$dbEvents');
      //   [Variable_name] => event_scheduler
      //   [Value] => ON

      UI::table([
        'caption' => 'Baza danych',
        'rows' => [
          [
            'nazwa' => 'Event Scheduler (generowanie Grafika, itp.)',
            'wartość' => ('ON' == $dbEvents['Value'])
              ? $_('span', ['class' => "label label-success"], "ON")
              : $_('span', ['class' => "label label-danger"], "OFF"),
            '#' => UI::hButtonPost("Włącz", [
              'class' => "btn btn-xs btn-default",
              'data' => [
                'event_sheduler_on' => 1
              ]
            ])
          ]
        ]
      ]);

      // UI::table([
      //   'caption' => 'Baza danych',
      //   'rows' => DB::getPDO()->fetchAll(" SHOW VARIABLES ")
      // ]);
    } catch (Exception $e) {
      UI::alert('danger', $e->getMessage());
    }
    UI::endTag('div');// .container
    UI::dol();
  }

  public function fixEventSheduler() {
    DB::getPDO()->execSql(" SET GLOBAL event_scheduler='ON' ");
  }

}