<?
require "proteger.php";

extract(recupera($_GET));

$var_pagina = $meio;
$_SESSION['retorno'][$var_pagina] = $_SERVER['REQUEST_URI'];

if(!libera($var_pagina, "list"))
	die(reload(ROOT."/?meio=aviso", 0));

$titulo_pagina = "Administradores";

$qquery = !empty($q) ? "&& u.nome LIKE '%".url_query($q)."%'" : "";
$qnivel = !empty($nivel) ? "&& u.nivel = '$nivel'" : "";
$ativo = !isset($ativo) ? "1" : $ativo;

if($ativo == "0")
	$qativo = "&& u.ativo = '0'";
elseif($ativo == "1")
	$qativo = "&& u.ativo = '1'";

if(!$libera)
	$quid = "&& u.id = '$var_usuario_id'";
else
	$quid = "&& u.id != '1'";

$select = "
	SELECT u.*, n.nivel
	FROM {$db_table_admin} u
	LEFT JOIN {$db_table_admin_niveis} n ON u.nivel = n.id
	WHERE 1 = 1 $quid $qquery $qnivel $qativo
	ORDER BY u.nivel ASC, u.nome ASC";

// para a paginação
$pg = empty($_GET['pagina']) ? 1 : $_GET['pagina'];
$limit = 20;

$limit_inicial = $limit * ($pg - 1);

$total_geral = $ttl = count(getDadosList($select));
$total_exibido = $limit * $pg;
$total_paginas = ceil($total_geral / $limit);
$querystring = preg_replace("[&pagina=[0-9]+]", "", $_SERVER['QUERY_STRING']);

$navegacao = navegacao($querystring, array(
	"pagina_atual" => $pg,
	"total_geral" => $total_geral,
	"total_exibido" => $total_exibido,
	"total_paginas" => $total_paginas
));
//

$sql = getDadosList("{$select} LIMIT $limit_inicial, $limit");

$niveis = getDadosList("SELECT * FROM {$db_table_admin_niveis} ORDER BY nivel ASC");
?>
<fieldset>
	<legend><?= $titulo_pagina ?> (<?= $ttl ?>)</legend>
    <div class="content">
    <? if(libera($var_pagina)){ ?>
        <div class="row">
            <div class="col">
                <button class="btn btn-success" onClick="location.href='?meio=<?= $var_pagina ?>_form'"><i class="fa fa-plus-circle"></i> Novo</button>
            </div>
        </div>
    <? } ?>
		<div class="search">
        	<form action="" method="get">
           		<input type="hidden" name="meio" value="<?= $var_pagina ?>">
            	<div class="row">
            		<div class="col-md-5">
                    	<label><strong>Usuário</strong></label>
                        <input type="text" name="q" class="form-control" value="<?= $q ?>">
                    </div>
					<div class="col-md-3">
						<label><strong>Nível</strong></label>
						<select name="nivel" class="form-control">
							<option value="">Todos</option>
						<? foreach($niveis as $i => $v){ ?>
							<option value="<?= $v['id'] ?>"<?= selected($nivel, $v['id']) ?>><?= $v['nivel'] ?></option>
						<? } ?>
							<option value="0"<?= selected($nivel, "0") ?>>MASTER</option>
						</select>
					</div>
					<div class="col-md-2">
						<label><strong>Status</strong></label>
						<select name="ativo" class="form-control">
							<option value="">Todos</option>
							<option value="1"<?= selected($ativo, "1") ?>>Apenas ativos</option>
							<option value="0"<?= selected($ativo, "0") ?>>Apenas inativos</option>
						</select>
					</div>
                	<div class="col-md-2">
                    	<br>
                        <button type="submit" class="btn btn-dark btn-block"><i class="fa fa-search"></i> Filtrar</button>
                    </div>
                </div>
            </form>
        </div>
        <? if($ttl >= 1){ ?>
		<?= $navegacao ?>
		<div class="cover">
			<ul class="table" data-pagina="<?= $var_pagina ?>" rel="<?= $var_pagina ?>_func.php">
				<li class="item header no-hover text-center">
					<div class="tb15">
						<p>Nível</p>
					</div>
					<div class="tb30">
						<p>Usuário</p>
					</div>
					<div class="tb35">
						<p>Dados</p>
					</div>
					<div class="tb10">
						<p>Acesso</p>
					</div>
					<div class="tb5">
						<p>Ativo</p>
					</div>
					<div class="tb5"></div>
				</li>
			<?
			foreach($sql as $i => $array){
				$nivel = !empty($array['nivel']) ? $array['nivel'] : "MASTER";
			?>
				<li id="item_<?= $array['id'] ?>" class="item" data-id="<?= $array['id'] ?>" contextmenu="menu_<?= $array['id'] ?>">
					<div class="tb15 text-center">
						<p><?= $nivel ?></p>
					</div>
					<div class="tb30 text-center">
						<p><?= $array['user'] ?></p>
					</div>
					<div class="tb35">
						<p><strong><?= $array['nome'] ?></strong></p>
						<p><?= $array['email'] ?></p>
					</div>
					<div class="tb10 text-center">
						<p><?= data($array['acesso']) ? data($array['acesso'])."<br>".hora($array['acesso']) : "-" ?></p>
					</div>
					<div class="tb5">
					<? if($var_usuario_id != $array['id']){ ?>
						<?= tgAtivo2($array['id'], $array['ativo']) ?>
					<? } ?>
					</div>
					<div class="tb5">
						<button class="btn btn-sm btn-block open-menu"><i class="fa fa-bars"></i></button>
					</div>
					<menu id="menu_<?= $array['id'] ?>" type="context" class="hide">
					<? $contextmenu = false; ?>
					<?
					if(libera($var_pagina, "altera")){
						$contextmenu = true;
					?>
						<command label="Editar" icon="fa-edit" onClick="location.href='?meio=<?= $var_pagina ?>_altera&id=<?= $array['id'] ?>'"></command>
					<? } ?>
					<?
					if($var_usuario_id != $array['id'] && libera($var_pagina, "exclui")){
						$contextmenu = true;
					?>
						<hr>
						<command label="Excluir" icon="fa-trash" onClick="hideExclui('<?= $var_pagina ?>_func.php', {funcao:'exclui', id:'<?= $array['id'] ?>'}, this);"></command>
					<? } ?>
						<? if(!$contextmenu){ ?>
						<command label="Opções indisponíveis" disabled></command>
						<? } ?>
					</menu>
				</li>
			<? } ?>
			</ul>
		</div>
		<?= $navegacao ?>
        <? } ?>
    </div>
</fieldset>