<?
// variávis que se trabalham nessa página
$var_banco = "cliente";
$var_pagina = "cliente-editar";
$var_pagina_anterior = "cliente";
$id = $_REQUEST[id];
?>
<section class="content" >
<!-- Info boxes -->
<section class="content-header">
<h1>
Gerenciamento de Cliente
</h1><br />
<br />
<!-- Default box -->
<div class="box">
<div class="box-header with-border">
<h3 class="box-title">Dados Cadastrais do Cliente</h3>
</div>
<!-- CADASTRO -->
<div class="box-body" style="display: block;">
<?
//ATUALIZANDO DADOS
if ($_REQUEST[alterou] == "sim"){
$comando = "UPDATE ". $var_banco ."
SET
tipo = '". ($_REQUEST[tipo]) ."',
nome = '". ($_REQUEST[nome]) ."',
empresa = '". ($_REQUEST[empresa]) ."',
CPF = '". $_REQUEST[CPF] ."',
CNPJ = '". $_REQUEST[CNPJ] ."',
RG = '". $_REQUEST[RG] ."',
senha = '". $_REQUEST[senha]."',
inscricao = '". $_REQUEST[inscricao] ."',
Endereco = '". ($_REQUEST[Endereco]) ."',
Numero = '". ($_REQUEST[Numero]) ."',
Complemento = '". ($_REQUEST[Complemento]) ."',
Bairro = '". ($_REQUEST[Bairro]) ."',
Cidade = '". ($_REQUEST[Cidade]) ."',
obs = '". ($_REQUEST[obs]) ."',
CEP = '". $_REQUEST[CEP] ."',
UF = '". $_REQUEST[UF] ."',
telefone1 = '". $_REQUEST[telefone1] ."',
telefone2 = '". $_REQUEST[telefone2] ."',
datanasc = '". data_para_salvar($_REQUEST[datanasc]) ."',
email = '".$_REQUEST[email]."',
quem_editou = '".$_SESSION[id]."'
WHERE id=".$_REQUEST[id]; //comando SQL
$exec = mysql_query($comando); //executa o comando no banco
echo "<div class=\"alert alert-success\">
Cliente Atualizado com <strong>sucesso</strong>.
</div><br>";
}
$rs = $obj->query("SELECT * FROM ". $var_banco ." WHERE id=".$id);
?>
<div class="row" id="box_cadastro">
<form class="form-horizontal " id="form1" name="form1" method="post" action="index2.php?secao=<?= $var_pagina?>" style="width:90%; margin:0px auto">
<fieldset>
<div class="control-group">
<script>
function mostra_outro(opc){
if(opc == "2"){
document.getElementById('pj').style.display='inline';
document.getElementById('empresa').required = true;
document.getElementById('CNPJ').required = true;
} else {
document.getElementById('pj').style.display='none';
document.getElementById('empresa').required = false;
document.getElementById('CNPJ').required = false;
}
}
</script>
<div class="row">
<div class="col-md-12">
<label class="control-label">Tipo: </label>
<input type="radio" id="tipo" name="tipo" VALUE="1" required onclick="mostra_outro(1)" <? if(mysql_result($rs, '0', 'tipo') == 1) { echo "checked='checked'";}?> readonly="readonly"> Pessoa Física
<input type="radio" id="tipo" name="tipo" VALUE="2" required onclick="mostra_outro(2)" <? if(mysql_result($rs, '0', 'tipo') == 2) { echo "checked='checked'";}?> readonly="readonly"> Pessoa Jurídica<br />
</div>
</div>
<div class="row" id="pj" name="pj" <? if(mysql_result($rs, '0', 'tipo') == 1) { echo "style='display:none;'";}?>>
<div class="col-md-12">
<label class="control-label">Empresa: </label>
<input type="text" class="form-control" id="empresa" name="empresa" value="<? echo (mysql_result($rs, '0', 'empresa'));?>" <? if(mysql_result($rs, '0', 'tipo') == 2) { echo "required";}?> >
</div>
<div class="col-md-6">
<label class="control-label">CNPJ: </label>
<input type="text" class="form-control" id="CNPJ" name="CNPJ" value="<? echo (mysql_result($rs, '0', 'CNPJ'));?>" <? if(mysql_result($rs, '0', 'tipo') == 2) { echo "required";}?>>
</div>
<div class="col-md-6">
<label class="control-label">Inscrição Estadual: </label>
<input type="text" class="form-control" id="inscricao" name="inscricao" value="<? echo (mysql_result($rs, '0', 'inscricao'));?>">
</div>
</div>
<div class="row">
<div class="col-md-12">
<label class="control-label">Nome: </label>
<input type="text" class="form-control" id="nome" name="nome" value="<? echo (mysql_result($rs, '0', 'nome'));?>" required>
</div>
</div>
<div class="row">
<div class="col-md-3">
<label class="control-label">CPF: </label>
<input type="text" class="form-control" id="CPF" name="CPF" value="<? echo mysql_result($rs, '0', 'CPF');?>" required>
</div>
<div class="col-md-3">
<label class="control-label">RG: </label>
<input type="text" class="form-control" id="RG" name="RG" value="<? echo mysql_result($rs, '0', 'RG');?>">
</div>
<div class="col-md-3">
<label class="control-label">Data Nasc.: </label>
<input type="text" class="form-control" placeholder="Data Nascimento" id="datanasc" name="datanasc" value="<? echo data_para_mostrar(mysql_result($rs, '0', 'datanasc'));?>" >
</div>
<div class="col-md-3">
<label class="control-label">Senha: </label>
<input type="text" class="form-control" id="senha" name="senha" required="required" value="<? echo mysql_result($rs, '0', 'senha');?>">
</div>
</div>
<div class="row">
<div class="col-md-3">
<label class="control-label">Celular: </label>
<input type="text" class="form-control" placeholder="Telefone" id="telefone1" name="telefone1" value="<? echo mysql_result($rs, '0', 'telefone1');?>" required>
</div>
<div class="col-md-3">
<label class="control-label">Telefone: </label>
<input type="text" class="form-control" placeholder="Telefone" id="telefone2" name="telefone2" value="<? echo mysql_result($rs, '0', 'telefone2');?>">
</div>
<div class="col-md-6">
<label class="control-label">E-mail: </label>
<input type="text" class="form-control" placeholder="E-mail" id="email" name="email" value="<? echo mysql_result($rs, '0', 'email');?>" required>
</div>
</div>
<div class="row">
<div class="col-md-4">
<label class="control-label">Endereço: </label>
<input type="text" class="form-control" id="Endereco" name="Endereco" value="<? echo (mysql_result($rs, '0', 'Endereco'));?>" required>
</div>
<div class="col-md-4">
<label class="control-label">Número: </label>
<input type="text" class="form-control" id="Numero" name="Numero" value="<? echo (mysql_result($rs, '0', 'Numero'));?>" required>
</div>
<div class="col-md-4">
<label class="control-label">Complemento: </label>
<input type="text" class="form-control" id="Complemento" name="Complemento" value="<? echo (mysql_result($rs, '0', 'Complemento'));?>">
</div>
</div>
<div class="row">
<div class="col-md-3">
<label class="control-label">Bairro: </label>
<input type="text" class="form-control" id="Bairro" name="Bairro" value="<? echo (mysql_result($rs, '0', 'Bairro'));?>" required>
</div>
<div class="col-md-3">
<label class="control-label">Cidade: </label>
<input type="text" class="form-control" id="Cidade" name="Cidade" value="<? echo (mysql_result($rs, '0', 'Cidade'));?>" required>
</div>
<div class="col-md-3">
<label class="control-label">CEP: </label>
<input type="text" class="form-control" id="CEP" name="CEP" value="<? echo mysql_result($rs, '0', 'CEP');?>" required>
</div>
<div class="col-md-3">
<label class="control-label">UF: </label>
<select name="UF" required class="form-control" >
<option value="" selected="selected">UF</option>
<option value="AC" <? if(mysql_result($rs, '0', 'UF') == "AC") echo " selected='selected' "?>>AC</option>
<option value="AL" <? if(mysql_result($rs, '0', 'UF') == "AL") echo " selected='selected' "?>>AL</option>
<option value="AP" <? if(mysql_result($rs, '0', 'UF') == "AP") echo " selected='selected' "?>>AP</option>
<option value="AM" <? if(mysql_result($rs, '0', 'UF') == "AM") echo " selected='selected' "?>>AM</option>
<option value="BA" <? if(mysql_result($rs, '0', 'UF') == "BA") echo " selected='selected' "?>>BA</option>
<option value="CE" <? if(mysql_result($rs, '0', 'UF') == "CE") echo " selected='selected' "?>>CE</option>
<option value="DF" <? if(mysql_result($rs, '0', 'UF') == "DF") echo " selected='selected' "?>>DF</option>
<option value="ES" <? if(mysql_result($rs, '0', 'UF') == "ES") echo " selected='selected' "?>>ES</option>
<option value="GO" <? if(mysql_result($rs, '0', 'UF') == "GO") echo " selected='selected' "?>>GO</option>
<option value="MA" <? if(mysql_result($rs, '0', 'UF') == "MA") echo " selected='selected' "?>>MA</option>
<option value="MT" <? if(mysql_result($rs, '0', 'UF') == "MT") echo " selected='selected' "?>>MT</option>
<option value="MS" <? if(mysql_result($rs, '0', 'UF') == "MS") echo " selected='selected' "?>>MS</option>
<option value="MG" <? if(mysql_result($rs, '0', 'UF') == "MG") echo " selected='selected' "?>>MG</option>
<option value="PA" <? if(mysql_result($rs, '0', 'UF') == "PA") echo " selected='selected' "?>>PA</option>
<option value="PB" <? if(mysql_result($rs, '0', 'UF') == "PA") echo " selected='selected' "?>>PA</option>
<option value="PR" <? if(mysql_result($rs, '0', 'UF') == "PR") echo " selected='selected' "?>>PR</option>
<option value="PE" <? if(mysql_result($rs, '0', 'UF') == "PE") echo " selected='selected' "?>>PE</option>
<option value="PI" <? if(mysql_result($rs, '0', 'UF') == "PI") echo " selected='selected' "?>>PI</option>
<option value="RJ" <? if(mysql_result($rs, '0', 'UF') == "RJ") echo " selected='selected' "?>>RJ</option>
<option value="RN" <? if(mysql_result($rs, '0', 'UF') == "RN") echo " selected='selected' "?>>RN</option>
<option value="RS" <? if(mysql_result($rs, '0', 'UF') == "RS") echo " selected='selected' "?>>RS</option>
<option value="RO" <? if(mysql_result($rs, '0', 'UF') == "RO") echo " selected='selected' "?>>RO</option>
<option value="RR" <? if(mysql_result($rs, '0', 'UF') == "RR") echo " selected='selected' "?>>RR</option>
<option value="SC" <? if(mysql_result($rs, '0', 'UF') == "SC") echo " selected='selected' "?>>SC</option>
<option value="SP" <? if(mysql_result($rs, '0', 'UF') == "SP") echo " selected='selected' "?>>SP</option>
<option value="SE" <? if(mysql_result($rs, '0', 'UF') == "SE") echo " selected='selected' "?>>SE</option>
<option value="TO" <? if(mysql_result($rs, '0', 'UF') == "TO") echo " selected='selected' "?>>TO</option>
</select>
</div>
</div>
<br />
</div>
<div class="row">
<div class="col-md-12">
<label class="control-label">Informações Adicionais:</label>
<textarea name="obs" class="form-control" id="obs" placeholder="Descrição"/><? echo (mysql_result($rs, '0', 'obs'));?></textarea>
</div>
</div>
<br />
<div class="control-group">
<div class="controls">
<input type="hidden" name="alterou" value="sim">
<input type="hidden" name="id" value="<? echo mysql_result($rs, '0', 'id');?>">
<button type="submit" class="btn btn-primary">ATUALIZAR DADOS CADASTRAIS </button>
<a href="?secao=cliente" class="btn btn-default">VOLTAR MENU PRINCIPAL</a>
</div>
</div>
</fieldset>
</form>
</div>
</div>
</div>
<!-- CADASTRO -->
<!-- CONTAS A PAGAR -->
<div class="box collapsed-box box-success">
<div class="box-header with-border">
<h3 class="box-title"><strong>COMPRAS EFETUADAS PELO CLIENTE</strong></h3>
<div class="box-tools pull-right">
<button type="button" class="btn btn-box-tool bg-aqua" data-widget="collapse" data-toggle="tooltip" title="Compras Efetuadas" data-original-title="Compras Efetuadas">
<i class="fa fa-plus"></i></button>
</div>
</div>
<div class="box-body" style="display: inline;">
<!-- LISTA DE CONTAS A PAGAR CADASTRADAS -->
<? $comando = "SELECT * FROM pedidos WHERE status = 1 AND idCliente=".mysql_result($rs, '0', 'id')." ORDER BY data DESC";
$exec = mysql_query($comando);
?>
<table class="table table-bordered">
<tbody><tr>
<th style="width: 20px">ID</th>
<th style="width: 20%">Data</th>
<th style="width: 10%">Valor</th>
<th style="width: 70%">Situação</th>
<th style="width:100px"></th>
</tr>
<? while ($linha = mysql_fetch_assoc($exec)) {
?>
<tr class="
<?
if($linha[situacao] == "ENTREGUE/FINALIZADO"){
echo " success ";
}
if($linha[situacao] == "PAGAMENTO CONFIRMADO"){
echo " info ";
}
if($linha[situacao] == "EM PROCESSAMENTO"){
echo " warning ";
}
if($linha[situacao] == "ENVIADO"){
echo " info ";
}
if(($linha[situacao] == "CANCELADO") or ($linha[situacao] == "PAGAMENTO RECUSADO") or ($linha[situacao] == "PAGAMENTO DEVOLVIDO/PEDIDO CANCELADO")){
echo " danger ";
}
?>
">
<td><?= $linha[idPedido]?></td>
<td><?= date("d/m/Y H:i:s", strtotime($linha[data]))?></td>
<td>R$ <?= number_format($linha[valor_total], 2, ',', '.')?></td>
<td><?= ($linha[situacao])?></td>
<td>
<a href="index2.php?secao=pedidos-editar&idPedido=<?=$linha[idPedido]?>" class="btn btn-default btn-xs" title="Editar/Atualizar">
<span class="glyphicon glyphicon-refresh"></span>
</a>
<? if($_SESSION["permissao"] == "aaaaaADMINISTRADOR"){ ?>
<a href="index2.php?secao=<?= $var_pagina?>&sub=excluir&idPedido=<?=$linha[idPedido]?>" class="btn btn-danger btn-xs" title="Excluir">
<span class="glyphicon glyphicon-remove"></span>
</a>
<? } ?>
</td>
</tr>
<? } //while ?>
</tbody></table>
<!-- CONTAS A PAGAR -->
</div>
</div>
<!-- /.box -->
</div>
</section>
</section>