Frenesiii vou te passar meu index pra vc dar uma olhada okey?
dai fazemos a ultima tentativaaa. por favor velho!!
<?php
clearstatcache();
session_start();
ignore_user_abort(true);
require('../variaveis.inc.php');
require('../funcoes.inc.php');
require('../consiga.inc.php');
if(! $_SESSION["Intranet_Usuario"]){
header("Location: ../intranet_login.php?form[Pagina]=cad_usuario2");
die();
}
include "dbconnect.php" ;
$Matricula = $_POST['Matricula'];
if (!empty($Matricula)) {
$sql_busca_matricula = 'select * from intranet where Matricula="'.$Matricula.'"';
$resultado_matricula = mysql_query($sql_busca_matricula);
$dados_matricula = mysql_fetch_array($resultado_matricula);
$recebe_matricula = $dados_matricula['Matricula'];
$recebe_nome = $dados_matricula['Nome'];
$recebe_sala = $dados_matricula['Sala'];
$recebe_setor = $dados_matricula['Setor'];
$recebe_setor2 = $dados_matricula['Setor2'];
$recebe_ccusto = $dados_matricula['CCusto'];
$recebe_email = $dados_matricula['email'];
$recebe_ramal = $dados_matricula['Ramal'];
$recebe_superior = $dados_matricula['Superior'];
$recebe_id = $dados_matricula['id'];
list ($usuario)= explode("@",$recebe_email);
$sql_busca_permissoes = 'select * from intranet_permissoes where Usuario="'.$usuario.'"';
$resultado_permissoes = mysql_query($sql_busca_permissoes);
$dados_permissoes = mysql_fetch_array($resultado_permissoes);
$permissao_coletor = $dados_permissoes['Coletor'];
$permissao_superior = $dados_permissoes['Superior'];
$permissao_administrador = $dados_permissoes['Administrador'];
$permissao_master = $dados_permissoes['Master'];
$permissao_requisicoes = $dados_permissoes['Requisicoes'];
$permissao_almoxarifado = $dados_permissoes['Almoxarifado'];
$permissao_tercerizado = $dados_permissoes['tercerizado'];
}
$Matricula_ctt = substr($_POST['Matricula'],3,6);
$query1 = "SELECT SRA.RA_MAT, SRA.RA_CC FROM SRA010 SRA, CTT010 CTT WHERE SRA.D_E_L_E_T_<>'*' AND SRA.RA_SITFOLH<>'D' AND SRA.RA_MAT = '" . $Matricula_ctt . "' AND CTT.D_E_L_E_T_<>'*' AND CTT.CTT_CUSTO=*SRA.RA_CC";
$query1 .= " UNION SELECT SRA.RA_MAT, SRA.RA_CC FROM SRA040 SRA, CTT010 CTT WHERE SRA.D_E_L_E_T_<>'*' AND SRA.RA_SITFOLH<>'D' AND SRA.RA_MAT = '" . $Matricula_ctt . "' AND CTT.D_E_L_E_T_<>'*' AND CTT.CTT_CUSTO=*SRA.RA_CC";
$query1 .= " UNION SELECT SRA.RA_MAT, SRA.RA_CC FROM SRA080 SRA, CTT010 CTT WHERE SRA.D_E_L_E_T_<>'*' AND SRA.RA_SITFOLH<>'D' AND SRA.RA_MAT = '" . $Matricula_ctt . "' AND CTT.D_E_L_E_T_<>'*' AND CTT.CTT_CUSTO=*SRA.RA_CC";
$result_query1 = mssql_query($query1,$conn) or die (mssql_get_last_message($result_query1));
$dados_result1 = mssql_fetch_array($result_query1);
$recebe_custo_ctt = $dados_result1['RA_CC'];
?>
<html>
<? include "cabecalho.php";?>
<html>
<head>
<title>cadastrar.php</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<table width="520" border="1" cellspacing="0" bordercolor="#339900" style="border-collapse: collapse;">
<tr>
<td height="20" align="center" bgcolor="#FFFFFF"><strong><font color="#FF0000" size="1" face="verdana">CADASTRAR
USUARIO</font></strong></td>
</tr>
<tr>
<td><table width="520" border="0" cellpadding="2" cellspacing="0">
<tr bgcolor="#FFFFFF">
<td colspan="2"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<form name="busca_matricula" method="post" action="index.php">
<tr>
<td width="100"><strong><font size="0" face="verdana">Buscar matrícula</font></strong></td>
<td><input name="Matricula" type="text" id="Matricula" size="15"></td>
<td><input type="submit" name="busca_matricula" value="Consulta Matrícula" method="post"></td>
<td height="20" align="left"><strong><font size="1" face="Verdana">Tercerizado</font></strong></td>
<td align="left">
<? if (!empty($Matricula)) {
if ($permissao_tercerizado == "1") {
echo '<input name="tercerizado" type="checkbox" checked>';
} else {
echo '<input name="tercerizado" type="checkbox">';
}
} else {
echo '<input name="tercerizado" type="checkbox">';
}
?> </td>
</tr>
</form>
</table></td>
</tr>
<?
if (!empty($Matricula)) {
echo '<form name="form2" method="post" action="editar.php">';
} else {
echo '<form name="form1" method="post" action="inserir.php">';
}
?>
<input type="hidden" name="id" value="<? $rs['id']?>"/>
<tr bgcolor="#FFFFFF">
<td width="100"><strong><font size="1" face="verdana">Matrícula</font></strong></td>
<td>
<?
if (!empty($Matricula)) {
echo '<input name="Matricula" type="text" id="Matricula" value="'.$recebe_matricula.'" size="40">';
} else {
echo ' <input name="Matricula" type="text" id="Matricula" size="40">';
}
?></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="100"><strong><font size="1" face="verdana">Nome</font></strong></td>
<td><? if (!empty($Matricula)) {
echo '<input name="Nome" type="text" id="Nome" value="'.$recebe_nome.'" size="40" >';
} else {
echo '<input name="Nome" type="text" id="Nome" size="40">';
}
?></td>
</tr>
<tr bgcolor="#FFFFFF">
<td><strong><font size="1" face="verdana">Sala</font></strong></td>
<td><? if (!empty($Matricula)) {
echo '<input name="Sala" type="text" id="Sala" value="'.$recebe_sala.'" size="40">';
} else {
echo '<input name="Sala" type="text" id="Sala" size="40">';
}
?></td>
</tr>
<tr bgcolor="#FFFFFF">
<td><strong><font size="1" face="verdana">Centro Custo</font></strong></td>
<td><?
if (!empty($Matricula)) {
if (empty ($recebe_ccusto)) {
echo '<input name="CCusto" type="text" id="CCusto" value="'.$recebe_custo_ctt.'" size="40">';
} else {
echo '<input name="CCusto" type="text" id="CCusto" value = "'.$recebe_ccusto.'"size="40">';
}
} else {
echo '<input name="CCusto" type="text" id="CCusto" size="40">';
}
?></td>
</tr>
<tr bgcolor="#FFFFFF">
<td><strong><font size="1" face="verdana">Email</font></strong></td>
<td><? if (!empty($Matricula)) {
echo '<input name="email" type="text" id="email" value="'.$recebe_email.'" size="40">';
} else {
echo '<input name="email" type="text" id="email" size="40">';
}
?><font size="1" face="verdana" color="#FF0000">OBS.: E-mail sem @</td>
</tr>
<tr bgcolor="#FFFFFF">
<td><strong><font size="1" face="verdana">Ramal</font></strong></td>
<td><? if (!empty($Matricula)) {
echo '<input name="Ramal" type="text" id="Ramal" value="'.$recebe_ramal.'" size="40">';
} else {
echo '<input name="Ramal" type="text" id="Ramal" size="40">';
}
?></td>
</tr>
<tr bgcolor="#FFFFFF">
<td><strong><font size="1" face="verdana">Setor</font></strong></td>
<td> <select name="Setor">
<?
$busca_setor = 'select id, nome_setor from setor order by id';
$rs_setor = mysql_query($busca_setor);
while ($dados_setor = mysql_fetch_array($rs_setor)){
$setor = $dados_setor['id'];
$sel = '';
if ($recebe_setor == $setor)
{
$sel = 'selected';
}
echo '<option value="'.$dados_setor['id'].'" '.$sel.'>'.$dados_setor['nome_setor'].'</option>';
}
?>
</select> </td>
</tr>
<!-- <tr bgcolor="#FFFFFF">
<td><strong><font size="1" face="verdana">Setor2</font></strong></td>
<td>
if (!empty($Matricula)) {
echo '<input name="Setor2" type="text" id="Setor2" value="'.$recebe_setor.'" size="40">';
} else {
echo '<input name="Setor2" type="text" id="Setor2" size="40">';
}
*/
</td>
</tr> -->
<tr bgcolor="#FFFFFF">
<td><strong><font size="1" face="verdana">E-mail Superior</font></strong></td>
<td><? if (!empty($Matricula)) {
echo '<input name="Superior" type="text" id="Superior" value="'.$recebe_superior.'" size="40">';
} else {
echo '<input name="Superior" type="text" id="Superior" size="40">';
}
?></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="20" align="left"><strong><font size="1" face="Verdana">Coletor</font></strong></td>
<td align="left"><? if (!empty($Matricula)) {
if ($permissao_coletor == "1") {
echo '<input name="Coletor" type="checkbox" checked>';
} else {
echo '<input name="Coletor" type="checkbox">';
}
} else {
echo '<input name="Coletor" type="checkbox">';
}
?></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="20" align="left"><strong><font size="1" face="Verdana">Administrador</font></strong></td>
<td align="left"><? if (!empty($Matricula)) {
if ($permissao_administrador == "1") {
echo '<input name="Administrador" type="checkbox" checked>';
} else {
echo '<input name="Administrador" type="checkbox">';
}
} else {
echo '<input name="Administrador" type="checkbox">';
}
?></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="20" align="left"><strong><font size="1" face="Verdana">Almoxarifado</font></strong></td>
<td align="left"> <? if (!empty($Matricula)) {
if ($permissao_almoxarifado == "1") {
echo '<input name="Almoxarifado" type="checkbox" checked>';
} else {
echo '<input name="Almoxarifado" type="checkbox">';
}
} else {
echo '<input name="Almoxarifado" type="checkbox">';
}
?></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="20" align="left"><strong><font size="1" face="Verdana">Master</font></strong></td>
<td align="left"> <? if (!empty($Matricula)) {
if ($permissao_master == "1") {
echo '<input name="Master" type="checkbox" checked>';
} else {
echo '<input name="Master" type="checkbox">';
}
} else {
echo '<input name="Master" type="checkbox">';
}
?></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="20" align="left"><strong><font size="1" face="Verdana">Requisições</font></strong></td>
<td align="left"><? if (!empty($Matricula)) {
if ($permissao_requisicoes == "1") {
echo '<input name="Requisicoes" type="checkbox" checked>';
} else {
echo '<input name="Requisicoes" type="checkbox">';
}
} else {
echo '<input name="Requisicoes" type="checkbox">';
}
?></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="20" align="left"><strong><font size="1" face="Verdana">Superior</font></strong></td>
<td align="left"><? if (!empty($Matricula)) {
if ($permissao_superior == "1") {
echo '<input name="Superior" type="checkbox" checked>';
} else {
echo '<input name="Superior" type="checkbox">';
}
} else {
echo '<input name="Superior" type="checkbox">';
}
?></td>
</tr>
<tr bgcolor="#FFFFFF">
<td></td>
<td>
<? if (!empty($Matricula)) {
echo '<input type="submit" name="Submit" value="Alterar">
<input type="reset" name="Submit" value="Limpar">';
} else {
echo '<input type="submit" name="Submit" value="Cadastrar">
<input type="reset" name="Submit" value="Limpar">';
}
?>
</td>
</tr>
</form>
</table>
</td>
</tr>
</table>
</body>
</script>
</html>
