404

D7net
:/ var / www / html / crsys / adm / vendor / api /
Filename : pegaMenuj.php
back
<?php
session_start();
header('Content-Type: application/json');
include_once "ConectaApi.php";
if(isset($_POST['login'])) {
    $login = $_POST['login'];
    $empr_id = $_POST['empr_id'];
    $opcao = $_POST['opcao'];
    $pg_id = $_GET['pg_id'];
}
if(isset($_GET['login'])) {
$login = $_GET['login'];
$empr_id = $_GET['empr_id'];
$opcao = $_GET['opcao'];

}
$query = "SELECT  pg.id pg_id, pg.nome AS 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_sits_id = 1
          and adms_grps_id = 1
          AND r.pag_id IS NULL
          ORDER BY pg.nome";

$result = mysqli_query($link, $query) or die(json_encode(["error" => mysqli_error($link)]));

$menuItems = [];

    while ($row = mysqli_fetch_object($result))
    {    
        $menuItems[]=  $row;
    }
	echo json_encode($menuItems);