404

D7net
:/ var / www / html / novonote / adm / vendor / api /
Filename : pegaMenu.php
back
<?php
include_once "ConectaApi.php";
header('Content-Type: application/json');

// Certifique-se de que o array `$menuItems` está definido corretamente

if(isset($_POST['login'])) {
    $login = $_POST['login'];
    $empr_id = $_POST['empr_id'];
    $opcao = $_POST['opcao'];
}
if(isset($_GET['login'])) {
$login = $_GET['login'];
$empr_id = $_GET['empr_id'];
$opcao = $_GET['opcao'];
}

$query = "SELECT pg.id pg_id,
                pg.nome pg_nome
                FROM 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 pg.adms_mod_id = emod.mod_id
                 inner join adm_usu_mod umod
                 on umod.empr_id = $empr_id 
                 and umod.usuario_id = u.id
                 and pg.adms_mod_id = umod.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 r.pag_id is null
                ORDER BY pg.nome ";
  
 //  echo($login.'-'.$empr_id.'-'.$opcao);
    $result = mysqli_query($link, $query) or die(mysqli_error());
       
       
$stringMenu = "";
 $stringMenu = '<option value="">Selecione</option>';
      while ($row = mysqli_fetch_array($result))
    {   
        // $stringMenu .= "<option value='' selected>Selecione</option>"; 
         $stringMenu .= "<option value='$row[0]'>$row[1]</option>";
    }
    if (!isset($menuItems) || empty($menuItems)) {
    echo json_encode(["error" => "Nenhuma opção encontrada"]);
    exit;
}

// Garante que **apenas** o JSON seja retornado, sem texto extra
echo json_encode($menuItems, JSON_UNESCAPED_UNICODE);
exit;
	echo $stringMenu;