|
USR_ID;
echo "
|
|
|
|
|
|
|
|
|
|
|
";
if ($row->USR_FLG_ATIVO == 'S')
echo " |
|
|
|
|
|
|
|
";
}
$flag = 0;
$stmt=("SELECT
1 AS TIPO,
USRD_MEN_ID AS MEN_ID,
MEN_CAPTION
FROM USUARIO_D,
MENU
WHERE
MEN_ID = USRD_MEN_ID
AND USRD_USR_ID = '$cod'
UNION
SELECT
0 AS TIPO,
MEN_ID,
MEN_CAPTION
FROM MENU
WHERE
MEN_ID not in(SELECT
USRD_MEN_ID
FROM
USUARIO_D
WHERE
USRD_USR_ID = '$cod')
ORDER BY
3
");
$sth = ibase_query($dbh, $stmt);
while ($row = ibase_fetch_object ($sth))
{
$flag++;
echo "
|
|
";
}
echo"
|
|
";
$stmt=("SELECT
1 AS TIPO,
USRE_EMP_ID AS EMP_ID,
EMP_NOME,
EMP_CIDADE
FROM USUARIO_E,
EMPRESA
WHERE
EMP_ID = USRE_EMP_ID
AND USRE_USR_ID = '$cod'
UNION
SELECT
0 AS TIPO,
EMP_ID,
EMP_NOME,
EMP_CIDADE
FROM EMPRESA
WHERE
EMP_ID not in(SELECT
USRE_EMP_ID
FROM
USUARIO_E
WHERE
USRE_USR_ID = '$cod')
ORDER BY 2
");
$sth = ibase_query($dbh, $stmt);
while ($row = ibase_fetch_object ($sth))
{
$flag++;
echo "
|
|
";
}
echo"
|
|
|
 |
|
|
";
else
echo "
";
echo " $row->MEN_CAPTION