<?
session_start();

// ++++++++++++++++++++++++++++++++++
// ABRIR CONEXAO COM O BANCO DE DADOS
// ++++++++++++++++++++++++++++++++++


	$dbh=mysql_connect ("localhost", "razaocon_razaoco", "fcraz1") or die ('I cannot connect to local machine: ' . mysql_error());
	mysql_select_db ("razaocon_razao");
/*
	$dbh=mysql_connect ("localhost", "root", "") or die ('I cannot connect to local machine: ' . mysql_error());
	mysql_select_db ("razao");
*/
// +++++++++++++++
// SAIR DO SISTEMA
// +++++++++++++++

if(isset($_GET['logout'])){ 

	session_destroy(); 
	header("Location:./area.php");

}

// ++++++++++++++++++++++++++
// PERMITIR O ACESSO RESTRITO
// ++++++++++++++++++++++++++

if(isset($_POST['logar'])){

	$s = mysql_query("SELECT * FROM usuario WHERE email='".$_POST['login']."' AND senha='".$_POST['senha']."'");

	if(@mysql_num_rows($s)>0){
	
		$ss = mysql_fetch_object($s);
		
		$_SESSION['usrname'] = $ss->empresa;
		$_SESSION['usrid'] = $ss->usrid;
	
	}else{
	
		print '<script>alert("VERIFIQUE SEUS DADOS DE ACESSO!")</script>';
	
	}

}

// +++++++++++++++++++++++++++
// UPDATE DOS DADOS DO CLIENTE
// +++++++++++++++++++++++++++

if(isset($_POST['update_empresa']))
{
	// update
				
	$s = mysql_query("UPDATE usuario SET empresa='".$_POST['empresa']."',
				cnpj='".$_POST['cnpj']."',
				ie='".$_POST['ie']."',
				endereco='".$_POST['endereco']."',
				bairro='".$_POST['bairro']."',
				cidade='".$_POST['cidade']."',
				estado='".$_POST['estado']."',
				tel_1='".$_POST['tel_1']."',
				tel_2='".$_POST['tel_2']."',
				email='".$_POST['email']."',
				senha='".$_POST['senha']."',
				contato='".$_POST['contato']."' 
				WHERE usrid=".$_SESSION['usrid']."") or die(mysql_error());
	
	if(mysql_affected_rows()>0){
	
		$updated_usr = 2;
	
	}
}



?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<meta name="author" content="Thiago Faria by FORMA CRIATIVA" />
<title>+++/\ Razão Contabilidade /\+++</title>
<link rel="stylesheet" type="text/css" media="all" href="css/stilo.css" /> 
<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>
</head>

<body>
 
        <div id="wrapper">
               <div id="container">
			       <div id="topo">
			         <script type="text/javascript">
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0','width','766','height','110','title','Banner','src','swf/menu','quality','high','pluginspage','http://www.macromedia.com/go/getflashplayer','wmode','transparent','movie','swf/menu' ); //end AC code
</script><noscript><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0" width="766" height="110" title="Banner">
                       <param name="movie" value="swf/menu.swf" />
                       <param name="quality" value="high" />
                       <param name="wmode" value="transparent" />
                       <embed src="swf/menu.swf" width="766" height="110" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" wmode="transparent"></embed>
		             </object>
			       </noscript></div>
				      
					   
					      <div id="corpoMain">
						  
					        <div class="colunaUm">
							  
							        <h1>Usu&aacute;rios cadastrados </h1>
									  <p>&Aacute;rea Restrita &agrave; usu&aacute;rios cadastrados:</p>
									    <? if(!isset($_SESSION['usrname'])){?>
		  
          <form method="post" action="<?=$_SERVER['PHP_SELF'];?>">
										   <table width="50%" border="0" align="center" cellpadding="0" cellspacing="0" mm_noconvert="TRUE">
              <tr>
              
                <td width="82%"><table width="100%" height="166" border="0" align="center" cellpadding="4">
                    <tr>
                      <td colspan="2" align="center" class="form"><strong>Usu&aacute;rio Cadastrado </strong></td>
                    </tr>
                    <tr>
                      <td height="38" align="right" class="form" id="bgTd">login</td>
                      <td id="bgTd"><input type="text" name="login" /></td>
                    </tr>
                    <tr>
                      <td height="38" align="right" class="form" id="bgTd">senha</td>
                      <td id="bgTd"><input type="password" name="senha" /></td>
                    </tr>
                    <tr>
                      <td height="38" align="right" class="form">&nbsp;</td>
                      <td align="right"><input name="logar" type="submit" class="btn" value="Ok" style="width:50px;" /></td>
                    </tr>
                </table></td>
              </tr>
            
              
            </table>
					<? 
		}
		else
		{ 

		// ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
		// USUARIO ESTAR DEVIDAMENTE LOGADO E PODERA TER ACESSO AOS SEUS DADOS E SERVICOS 
		// ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
		
		?>
		
		<tr><td colspan="2" valign="top">
		<!-- 
		########################################################
		TABELA INTERNA - DEMONSTRAR TODOS OS SERVICOS AO CLIENTE
		########################################################
		-->		

		<table width="100%" cellpadding="2" cellspacing="2" border="0">

		<tr><td align="right"></td></tr>
		
		<tr><td>
			<div align="center"><a href="<?=$_SERVER['PHP_SELF'];?>?editar=yes"><img src="img/cgi.gif" border="0" alt="Editar Dados do Sistema"></a> &nbsp;&nbsp; 
			    <a href="<?=$_SERVER['PHP_SELF'];?>"><img src="img/ultimosvisitantes.gif" border="0" alt="Listar arquivos"></a> &nbsp;&nbsp; <a href="<?=$_SERVER['PHP_SELF'];?>?logout=yes"><img src="img/icon_botao1.gif" border="0" alt="Sair do Sistema"></a></div></td>
		</tr>

		<tr><td valign="top">
		
		<? 
		if(!isset($_REQUEST['editar']))
		{
		
		$s = mysql_query("SELECT * FROM pub_file WHERE fk_usrid=".$_SESSION['usrid']."");;

		// +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
		// CONDICAO PARA VERIFICAR SE O CLIENTE POSSUI OU NAO ARQUIVOS
		// CASO NAO POSSUA - DEPOIS DO ELSE - VER ESTRUTURA
		// +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
		
		if(mysql_num_rows($s)>0){

		
		?>
		
		<!-- MONTAR TABELA A FIM DE LISTAR TODOS OS ARQUIVOS DO CLIENTE -->
		
		<table width="100%" cellpadding="2">
		
		<tr class="texto">
		  <td><div align="center">Nome do Arquivo </div></td>
		  <td><div align="center">Data da Publica&ccedil;&atilde;o</div></td>
		  <td><div align="center">Arquivo</div></td>
		</tr>
		<? while($ss=mysql_fetch_object($s)){?>
		<tr>
		  <td><div align="center">
		    <?=$ss->legenda;?>
		    </div></td>
		  <td><div align="center">
		    <?=$ss->data_publicacao;?>
		    </div></td>
		  <td><div align="center"><a href="#"><img src="img/down_load.gif" width="30" height="30" border="0" onclick="MM_openBrWindow('./controle/<?=$ss->nome;?>','arq','status=yes,scrollbars=yes,resizable=yes,width=500,height=500')" /></a></div></td>
		</tr>
		<? } ?>
		</table>

		<? }else{ // O USUARIO NAO POSSUI ARQUIVOS ?>

			<blockquote class="texto">(*) Sem arquivos at&eacute; o momento </blockquote>
		    <? } ?>

		<!-- EOF MONTAR TABELA A FIM DE LISTAR TODOS OS ARQUIVOS DO CLIENTE -->
		
		<? }else{ // MOSTRAR DADOS PESSOAIS DO CLIENTE PARA EDICAO ?>
		
		<? if($updated_usr){ print '<script>alert("DADOS ATUALIZADOS COM SUCESSO!")</script>'; }?>
		
		<!-- 
		############################
		DADOS PARA EDITAR DO CLIENTE 
		############################
		-->
		<? $s = mysql_fetch_object(mysql_query("SELECT * FROM usuario WHERE usrid=".$_SESSION['usrid'].""));?>
		
		<form action="<?=$_SERVER['PHP_SELF'];?>" method="post">
		<input type="hidden" name="editar" value="ok" />
		
		<table width="98%" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#EEEEEE">
		<tr><td width="35%" align="right" class="texto">Empresa</td>
		<td width="65%"><input type="text" name="empresa" value="<?=$s->empresa?>" size="50" /></td></tr>
		<tr><td align="right" class="texto">Contato:</td>
		<td><input type="text" name="contato" value="<?=$s->contato?>" size="50" /></td></tr>
		<tr><td align="right" class="texto">CNPJ:</td>
		<td><input type="text" name="cnpj" value="<?=$s->cnpj;?>" /></td></tr>
		<tr><td align="right" class="texto">IE:</td>
		<td><input type="text" name="ie" value="<?=$s->ie;?>" /></td></tr>
		<tr> <td align="right" class="texto">Endere&ccedil;o:</td>
		<td><input type="text" name="endereco" value="<?=$s->endereco;?>" size="50" /></td></tr>
		<tr> <td align="right" class="texto">Bairro:</td>
		<td><input type="text" name="bairro" value="<?=$s->bairro;?>" /></td></tr>
		<tr> <td align="right" class="texto">Cidade:</td>
		<td><input type="text" name="cidade" value="<?=$s->cidade;?>" /></td></tr>
		<tr> <td align="right" class="texto">Estado:</td>
		<td><input type="text" name="estado" value="<?=$s->estado;?>" size="2" /></td></tr>
		<tr> <td align="right" nowrap="nowrap" class="texto">Telefone 1:</td>
		<td><input type="text" name="tel_1" value="<?=$s->tel_1;?>" /></td></tr>
		<tr> <td align="right" nowrap="nowrap" class="texto">Telefone 2:</td>
		<td><input type="text" name="tel_2" value="<?=$s->tel_2;?>" /></td></tr>
		<tr> <td align="right" class="texto">Login:</td>
		<td><input type="text" name="email" value="<?=$s->email;?>" size="50" /></td></tr>
		<tr><td align="right" class="texto">Senha:</td>
		<td><input type="text" name="senha" maxlength="12" value="<?=$s->senha;?>" /></td></tr>
		<tr><td align="center" colspan="2"><input name="update_empresa" type="submit" class="btnInter" value="Atualizar Empresa" /></td></tr>
		</table>
		</form>


		<!-- 
		#################################
		FIM: DADOS PARA EDITAR DO CLIENTE 
		#################################
		-->

		<? } ?>
		
		</td></tr><!-- 
		FIM
		########################################################
		TABELA INTERNA - DEMONSTRAR TODOS OS SERVICOS AO CLIENTE
		########################################################
		-->		
		


		</tr>
		</table>
		
		<? } // EOF SETOR DE ACESSO ?>
		
		  <!-- 
		  #####################
		  INICIO SETOR EDITAVEL 
		  #####################
		  -->
		 			   
						    </div>
							     
								  <div class="colunaDois">
								   
								        <div class="figuraColunaDois">
										    <img src="img/926343_45454100.jpg" alt="Sessão Clientes" />
											     <p>&Aacute;rea de Clientes </p>
											   
											    
												</div>
								    
									 
									  </div>
						   
						    
							  
							  </div>
			    
				  
				  
				    <div id="rodape"><img src="img/roda.jpg" /></div>
          </div>
			   
			   
			   <!--LOGOMARCA DA FORMA CRIATIVA COM LINK-->
			   <div style="width:766px; text-align:right; margin-top:15px;"><a href="http://www.formacriativa.com.br" target="_blank"><img src="img/asslogo_transp.gif" alt="Site desenvolvido por Forma Criativa" border="0" /></a></div>
			   
        </div>
   
    
	
	
</body>
</html>
