<?php

header('Content-Type: text/html; charset=utf-8');
require_once '../asserts/Asserts.php';
require_once '../../core/DataBase/Connection.php';
require_once '../../core/generics/Controller.php';
require_once '../../core/generics/GenericDao.php';
require_once '../../core/generics/Param.php';
require_once '../../core/generics/datacenter/Group.php';
$controller = new Controller(new GenericDao(Connection::connect()));
assertEquals($controller->groups(), jsonExpected());
?>

<?php 
function jsonExpected()
{
    $json = '[';
    $json .= '{"id":"1","name":"Com?rcio Internacional"},';
    $json .= '{"id":"2","name":"Oferta"},';
    $json .= '{"id":"3","name":"Demanda"},';
    $json .= '{"id":"4","name":"Indicadores Econ?micos"}';
    $json .= ']';
    return $json;
}
        $controller = new DatacenterController($service, $statistic, $jsonResponse, $grouper, $factory); 
?>
<?
    if(isset($_REQUEST['subgroup'])){
        $data_values = $controller->listData($page, $_REQUEST['subgroup']);
        $total = $controller->total($_REQUEST['subgroup']);
        DatacenterHelper::setLinkPaginationWithFilter($_REQUEST['subgroup']);
    }else{
        $data_values = $controller->listData($page);
        $total = $controller->total();
    }    
    $genericController = new Controller(new GenericDao($session));        
?>
<?
    $list_subgroups = array();
    $groups = json_decode($genericController->groups());    
    foreach($groups as $group){
        array_push($list_subgroups, json_decode($genericController->subgroups($group->id)));
    }
?>
<strong>Filtragem de dados</strong> (selecione o grupo que deseja vizualizar os dados)
<select id="subgroup_filter">
    <option value="">Todos</option>
    <?foreach($list_subgroups as $subgroup_of_group):?>
        <?foreach($subgroup_of_group as $subgroup):?>
            <?if(isset($_REQUEST['subgroup']) && $_REQUEST['subgroup'] == $subgroup->id):?>
                <option selected="selected" value="<?echo $subgroup->id?>"><?echo $subgroup->name?></option>
            <?else:?>
                <option value="<?echo $subgroup->id?>"><?echo $subgroup->name?></option>
            <?endif;?>        
        <?endforeach;?>