404

D7net
:/ var / www / html / novonote / adm / vendor / api /
Filename : pegaRestricao.php
back
<?php
include_once "ConectaApi.php";
if(isset($_POST['id'])) {
    $login = $_POST['id'];
    $empr_id = $_POST['empr_id'];
    $opcao = $_POST['opcao'];
    $pg_id = $_POST['pg_id'];
}
if(isset($_GET['id'])) {
$login = $_GET['id'];
$empr_id = $_GET['empr_id'];
$opcao = $_GET['opcao'];
$pg_id = $_GET['pg_id'];
}
if($opcao == '1'){
$query = "SELECT pg.id pg_id,
                pg.nome,
                grpg.id grpg_id, 
                grpg.nome grpg_nome,
                u.id
                FROM adms_menu pg
                inner join adms_usuarios u
                on u.usuario = '$login'
                left join  adms_restricao r
                on r.usu_id = u.id
		and r.pag_id = pg.id
                INNER JOIN adms_tps_pgs tpg ON tpg.id=pg.adms_tps_id
                inner join adms_grps_pgs grpg
                on grpg.id = pg.adms_grps_id
                inner join adms_empr_mod emod
                on adms_mod_id = emod.mod_id
                and emod.empr_id = $empr_id 
                 where pg.nivel = 3
                  and  pg.adms_grps_id = 1
                  and pg.adms_sits_id = 1
                   and pg.permite_restr = 'S'
                  and r.pag_id is null
                ORDER BY pg.nome";
}else{
    $query = "SELECT pg.id pg_id,
                pg.nome,
                grpg.id grpg_id, 
                grpg.nome grpg_nome,
                u.id
                FROM adms_menu pg
                inner join adms_usuarios u
                on u.usuario = '$login'
                left join  adms_restricao r
                on r.usu_id = u.id
		and r.pag_id = pg.id
                INNER JOIN adms_tps_pgs tpg ON tpg.id=pg.adms_tps_id
                inner join adms_grps_pgs grpg
                on grpg.id = pg.adms_grps_id
                inner join adms_empr_mod emod
                on adms_mod_id = emod.mod_id
                and emod.empr_id = $empr_id 
                 where pg.nivel = 3
                  and  pg.adms_grps_id <> 1
                  and pg.adms_sits_id = 1
                  and pg.permite_restr = 'S'
                  and r.pag_id is null
                  and pg.parent_id = $pg_id
                ORDER BY pg.nome";
}   
// echo($query);
    $result = mysqli_query($link, $query) or die(mysqli_error());
        
$stringForn = [];
//$stringforn[0] =  "<thead><tr><th colspan='2' align='center'>Selecione Página para Restrição</th></tr></thead><tbody>";
    while ($row = mysqli_fetch_object($result))
    {    
        $stringForn[]=  $row;
    }
	echo json_encode($stringForn);        
/*
        $stringFil = "";

$stringFil .= "<thead><tr><th colspan='4' style='text-align: center !important'>Selecione Página para Restrição</th></tr>";
$stringFil .= "<tr><th align='center'>ID</th>";
$stringFil .= "<th align='center'>Nome</th>";
$stringFil .= "<th align='center'>Processo</th>";
$stringFil .= "<th align='center'>Restr</th>";
$stringFil .= "</tr></thead><tbody>";
// Loop para gerar linhas da tabela
while ($row = mysqli_fetch_array($result)) {
    $stringFil .= "<tr><td>" . trim($row[0]) ."</td><td>" . trim($row[1])."</td><td>" . trim($row[3]). "</td><td class='td_rest' align='center'><input style='width: 100px !important'class='editar' type='checkbox' id='restricao' name='" . $row[0] . "'></td></tr>";
    
//    $stringFil .= "<tr><td class='td_rest'>" . trim($row[1]) . "</td><td class='td_rest' align='center'><input class='editar' type='checkbox' id='gravar_lojas' name='" . $row[0] . "'></td></tr>";
}

$stringFil .= "</tbody></table>";

// Imprime a tabela na página
echo $stringFil;
 */