| Server IP : 20.75.53.88 / Your IP : 216.73.217.72 [ Web Server : Apache System : Linux VMRALP-3 4.4.0-256-generic #290~14.04.1-Ubuntu SMP Thu Jun 20 09:24:50 UTC 2024 x86_64 User : www-data ( 33) PHP Version : 5.5.9-1ubuntu4.29+esm15 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, Domains : 3 Domains MySQL : ON | cURL : OFF | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/html/juridico/pacajus/horizonte/modulos/pessoa/ |
Upload File : |
<?php
/**
* Created by PhpStorm.
* User: RalpAlves
* Date: 12/04/2016
* Time: 10:48
*/
//ini_set('display_errors', 'off');
//include ('/../fpdf/fpdf.php');
$id = $_GET['id'];
//$conn = conexao::getInstance();
//PESSOA
$pess = $conn->query("select * from pessoas where codigo=$id");
$p = $pess->fetch(PDO::FETCH_OBJ);
$tpfj = $conn->query("select * from tipo_fj");
$tpes = $conn->query("select * from tipo_pessoas");
$eciv = $conn->query("select * from estado_civil");
$naci = $conn->query("select * from nacionalidade");
$sexo = $conn->query("select * from sexo");
$endp = $conn->query("select * from v_lista_pessoas_endereco where cod_pessoa='$id'");
//PROFISSAO
$prof = $conn->query("select * from profissoes");
$func = $conn->query("select * from profissoes");
//ENDERECO
$tipe = $conn->query("select * from tipo_enderecos");
$bair = $conn->query("select * from bairros");
$cida = $conn->query("select * from cidades");
//TELEFONE
$tele = $conn->query("select * from v_lista_pessoas_telefone WHERE cod_pessoa='$id'");
//AGENDA
$agenda = $conn->query("SELECT * FROM v_lista_agenda WHERE cod_pessoa='$id'");
//PROCESSO
$proc = $conn->query("select * from v_lista_processo WHERE cod_cli='$id'");
//CONTRATO
$cont = $conn->query("SELECT * FROM v_lista_contratos where cod_contratante='$id'");
$data = date('d/m/Y', strtotime($p->data_nasc));
// Separa em dia, mês e ano
list($dia, $mes, $ano) = explode('/', $data);
// Descobre que dia é hoje e retorna a unix timestamp
$hoje = mktime(0, 0, 0, date('m'), date('d'), date('Y'));
// Descobre a unix timestamp da data de nascimento do fulano
$nascimento = mktime(0, 0, 0, $mes, $dia, $ano);
// Depois apenas fazemos o cálculo já citado :)
$idade = floor((((($hoje - $nascimento) / 60) / 60) / 24) / 365.25);
?>
<head>
<script type="text/javascript">
$(document).ready(function () {
$('#tabela1').DataTable({
stateSave: true, "oLanguage": {
"sProcessing": "Processando. Aguarde...",
"sLengthMenu": "Mostrar _MENU_ registros",
"sZeroRecords": "NENHUM REGISTRO ENCONTRADO!",
"sInfo": "Mostrando _START_ até _END_ de _TOTAL_ registros",
"sInfoEmpty": "Mostrando 0 até 0 de 0 registros",
"sInfoFiltered": "(de _MAX_ registros no total)",
"sInfoPostFix": "",
"sSearch": "<i aling='center' class='fa fa-search' title='pesquisar registro'>",
"sUrl": "",
"oPaginate": {
"sFirst": "<<",
"sPrevious": "<i aling='center' class='fa fa-arrow-circle-left' title='registro anterior'></i>",
"sNext": "<i aling='center' class='fa fa-arrow-circle-right' title='próximo registro'>",
"sLast": ">>"
}
}
});
});
</script>
<script type="text/javascript">
$(document).ready(function () {
$('#tabela2').DataTable({
stateSave: true,
"oLanguage": {
"sProcessing": "Processando. Aguarde...",
"sLengthMenu": "Mostrar _MENU_ registros",
"sZeroRecords": "NENHUM REGISTRO ENCONTRADO!",
"sInfo": "Mostrando _START_ até _END_ de _TOTAL_ registros",
"sInfoEmpty": "Mostrando 0 até 0 de 0 registros",
"sInfoFiltered": "(de _MAX_ registros no total)",
"sInfoPostFix": "",
"sSearch": "<i aling='center' class='fa fa-search' title='pesquisar registro'>",
"sUrl": "",
"oPaginate": {
"sFirst": "<<",
"sPrevious": "<i aling='center' class='fa fa-arrow-circle-left' title='registro anterior'></i>",
"sNext": "<i aling='center' class='fa fa-arrow-circle-right' title='próximo registro'>",
"sLast": ">>"
}
}
});
});
</script>
<script type="text/javascript">
$(document).ready(function () {
$('#tabela3').DataTable({
stateSave: true,
"oLanguage": {
"sProcessing": "Processando. Aguarde...",
"sLengthMenu": "Mostrar _MENU_ registros",
"sZeroRecords": "NENHUM REGISTRO ENCONTRADO!",
"sInfo": "Mostrando _START_ até _END_ de _TOTAL_ registros",
"sInfoEmpty": "Mostrando 0 até 0 de 0 registros",
"sInfoFiltered": "(de _MAX_ registros no total)",
"sInfoPostFix": "",
"sSearch": "<i aling='center' class='fa fa-search' title='pesquisar registro'>",
"sUrl": "",
"oPaginate": {
"sFirst": "<<",
"sPrevious": "<i aling='center' class='fa fa-arrow-circle-left' title='registro anterior'></i>",
"sNext": "<i aling='center' class='fa fa-arrow-circle-right' title='próximo registro'>",
"sLast": ">>"
}
}
});
});
</script>
<script type="text/javascript">
$(document).ready(function () {
$('#tabela4').DataTable({
stateSave: true,
"oLanguage": {
"sProcessing": "Processando. Aguarde...",
"sLengthMenu": "Mostrar _MENU_ registros",
"sZeroRecords": "NENHUM REGISTRO ENCONTRADO!",
"sInfo": "Mostrando _START_ até _END_ de _TOTAL_ registros",
"sInfoEmpty": "Mostrando 0 até 0 de 0 registros",
"sInfoFiltered": "(de _MAX_ registros no total)",
"sInfoPostFix": "",
"sSearch": "<i aling='center' class='fa fa-search' title='pesquisar registro'>",
"sUrl": "",
"oPaginate": {
"sFirst": "<<",
"sPrevious": "<i aling='center' class='fa fa-arrow-circle-left' title='registro anterior'></i>",
"sNext": "<i aling='center' class='fa fa-arrow-circle-right' title='próximo registro'>",
"sLast": ">>"
}
}
});
});
</script>
<script src="modulos/pessoa/validacao.js"></script>
</head>
<div class="container panel panel-primary filterable">
<div class="container label">
<a href='?page=pessoa/pessoa' title="Voltar"><i aling='center' class='fa fa-arrow-circle-o-left fa-2x'></i></a>
<span style="font-size:20px; color: #060606"> Pessoa | Edição</span>
<a href='modulos/pessoa/ficha_pessoa.php?id=<?php echo $id ?>' target="_blank" title='Ficha da pessoa'>
<i aling='center' class='fa fa-file-pdf-o font_green navbar-right' style="padding-right: 50%; font-size: 25px;"></i>
</a>
</div>
</div>
<form id="form1" name="cadastro" OnSubmit="showCarga()" method="post" action="?page=pessoa/pessoa_crud&var=editar">
<div class="container">
<div class='panel panel-primary filterable panel-body'>
<input type='hidden' readonly class='form-control' name='codigo' id='codigo' value="<?php echo $p->codigo ?>"/>
<div class="col-lg-2 col-md-2 col-sm-2 col-xs-12">
<label for="">Tipo</label>
<select id="cod_fj" name="cod_fj" class="form-control">
<?php while ($ipfj = $tpfj->fetch(PDO::FETCH_OBJ)) {
if ($p->cod_fj==$ipfj->codigo) {
$selected = 'selected';
} else {
$selected = '';
} ?>
<option value="<?php echo $ipfj->codigo ?>"<?php echo $selected; ?>><?php echo $ipfj->tipofj ?></option>
<?php } ?>
</select>
</div>
<div class='col-xs-12 col-sm-5 col-md-5 col-lg-5'>
<label for="">nome</label>
<input type='text' class='form-control upper' name='nome' id='nome' value="<?php echo $p->nome ?>"/></div>
<div class='col-xs-12 col-sm-2 col-md-2 col-lg-2'>
<label for='data_nasc'>Nascimento | <?php echo $idade ?></label>
<input type='text' class='form-control' maxlength=10 name='data_nasc' id='data_nasc' onkeydown="formataData(this,event)" value="<?php echo date('d/m/Y', strtotime($p->data_nasc)) ?>"/>
</div>
<div class="col-lg-3 col-md-3 col-sm-3 col-xs-12">
<label for=""><a class='j50 link' title="Adicionar tipo de pessoa" href="index2.php?page=auxi/tipo_pessoa_cad"><i class='fa fa-plus-circle'></i></a> Tipo
pessoa <span title="atualizar registros"><i class='fa fa-refresh' onclick="combo('cod_tipo_pessoa','sel_tipo_pessoa','0')" style="cursor: hand;"></i></span></label>
<script src="js/index.js"></script>
<div id="cod_tipo_pessoa">
<select id="cod_tipo_pessoa" name="cod_tipo_pessoa" class="form-control">
<?php while ($itpes = $tpes->fetch(PDO::FETCH_OBJ)) {
$selecao = $p->cod_tipo_pessoa==$itpes->codigo ? 'selected' : ''
?>
<option value="<?php echo $itpes->codigo ?>"<?php echo $selecao; ?>><?php echo $itpes->tipo ?></option>
<?php } ?>
</select>
</div>
</div>
<div class="col-lg-2 col-md-2 col-sm-2 col-xs-12">
<label for="">Estado civil</label>
<select id="cod_estado_civil" name="cod_estado_civil" class="form-control select">
<?php while ($ieciv = $eciv->fetch(PDO::FETCH_OBJ)) {
$selecao = $p->cod_estado_civil==$ieciv->codigo ? 'selected' : ''
?>
<option value="<?php echo $ieciv->codigo ?>"<?php echo $selecao; ?>><?php echo $ieciv->estado_civil ?></option>
<?php } ?>
</select>
</div>
<div class="col-lg-3 col-md-3 col-sm-3 col-xs-12">
<label for="">Nacionalidade</label>
<select id="cod_nacionalidade" name="cod_nacionalidade" class="form-control">
<?php while ($inaci = $naci->fetch(PDO::FETCH_OBJ)) {
$selecao = $p->cod_nacionalidade==$inaci->codigo ? 'selected' : ''
?>
<option value="<?php echo $inaci->codigo ?>"<?php echo $selecao; ?>><?php echo $inaci->nacionalidade ?></option>
<?php } ?>
</select>
</div>
<div class="col-lg-2 col-md-2 col-sm-2 col-xs-12">
<label for="">Sexo</label>
<select id="cod_sexo" name="cod_sexo" class="form-control">
<?php while ($isexo = $sexo->fetch(PDO::FETCH_OBJ)) {
$selecao = $p->cod_sexo==$isexo->codigo ? 'selected' : ''
?>
<option value="<?php echo $isexo->codigo ?>"<?php echo $selecao; ?>><?php echo $isexo->sexo ?></option>
<?php } ?>
</select>
</div>
<div class='col-xs-12 col-sm-4 col-md-4 col-lg-4'>
<label for='conjuge'>Cônjuge</label>
<input type='text' class='form-control upper' name='conjuge' id='conjuge' value="<?php echo $p->conjuge ?>"/></div>
<div class='col-xs-12 col-sm-1 col-md-1 col-lg-1'>
<label for='bt_novo'> </label>
<br>
<button type="button" onclick="valida();" name="bt_novo" class="btn btn-primary form-control"><i class="glyphicon glyphicon-ok"></i></button>
</div>
</div>
</div>
<div class="container">
<div class="">
<div class="panel panel-heading with-nav-tabs panel-primary">
<ul class="nav nav-tabs ">
<li class="active"><a href="#tab3primary" data-toggle="tab"><i class='fa fa-map-marker'></i> Endereço</a></li>
<li><a href="#tab4primary" data-toggle="tab"><i class='fa fa-phone'></i> Contatos</a></li>
<li><a href="#tab1primary" data-toggle="tab"><i class='fa fa-folder-open-o'></i> Documentos</a></li>
<li><a href="#tab2primary" data-toggle="tab"><i class='fa fa-graduation-cap'></i> Profissão</a></li>
<?php if ($direito==1) { ?>
<li><a href="#tab7primary" data-toggle="tab"><i class='fa fa-file-text-o'></i> Contratos</a></li>
<? } ?>
<?php if ($direito==1) { ?>
<li><a href="#tab5primary" data-toggle="tab"><i class='fa fa-gavel'></i> Processos</a></li>
<? } ?>
<?php if ($direito==1) { ?>
<li><a href="#tab6primary" data-toggle="tab"><i class='fa fa-calendar'></i> Agenda</a></li>
<? } ?>
<li><a href="#tab8primary" data-toggle="tab"><i class="fa fa-camera"></i> Foto</a></li>
</ul>
<div class="panel-body">
<div class="tab-content">
<div class="tab-pane fade in active" id="tab3primary">
<div class="panel panel-primary active" align="center">
<a class='j50 link' title="Adicionar novo endereço" href="index2.php?page=pessoa/endereco_cad&id=<?php echo $id ?>"><i class='fa fa-plus-circle fa-1x'></i></a>
| <span style="font-size:18px; color: #060606">Endereço</span> |
<span title="atualizar informações"><i class='fa fa-refresh fa-1x' onclick="combo('tab_end','sel_endereco','<?php echo $p->codigo ?>')" style="cursor: hand;"></i></span>
</div>
<div id="action">
<div class='panel panel-primary filterable panel-body'>
<form id='frm_pesq' method='post' class="search-form">
<table id="tab_end" class='table dtabelas table-striped table-hover dt-responsive' cellspacing='0' width='100%' border='0'>
<thead>
<tr class="success">
<th width="2%">ID</th>
<th>Tipo</th>
<th>Endereço</th>
<th>Número</th>
<th>Compl.</th>
<th>Bairro</th>
<th>Cidade</th>
<th>CEP</th>
<th width="2%"></th>
<th width="2%"></th>
</tr>
</thead>
<tbody>
<?php
while ($e = $endp->fetch(PDO::FETCH_OBJ)) {
echo "<tr>";
echo "<td>" . $e->codigo . "</td>";
echo "<td>" . $e->tipo . "</td>";
echo "<td>" . $e->endereco . "</td>";
echo "<td>" . $e->numero . "</td>";
echo "<td>" . $e->complemento . "</td>";
echo "<td>" . $e->bairro . "</td>";
echo "<td>" . $e->cidade . "</td>";
echo "<td>" . $e->cep . "</td>";
$idend = $e->codigo;
//$pes = $e->cod_pessoa;
////if($direito == "1") {
echo "<td><a class='j50' href='index2.php?page=pessoa/endereco_edt&id=$p->codigo&idend=$idend&var=editar' title=\"editar registro\"><i aling='center' class='fa fa-pencil'></i></a></td>";
//}
if ($e->principal==1) {
echo "<td title=\"endereço principal\"><i class='fa fa-check-circle'></td>";
} else {
echo "<td><i class='fa fa-circle-o'></td>";
}
echo "</tr>";
}
?>
</tbody>
</table>
</form>
</div>
</div>
</div>
<div class="tab-pane" id="tab1primary">
<div class="panel panel-primary active" align="center"><span style="font-size:18px; color: #060606">Documentação</span></div>
<div id="action">
<div class='col-xs-12 col-sm-2 col-md-2 col-lg-2'>
<label for='cpfcnpj'>CPF | CNPJ</label>
<input type='text' class='form-control' name='cpfcnpj' id='cpfcnpj' value="<?php echo $p->cpfcnpj ?>"/></div>
<div class='col-xs-12 col-sm-2 col-md-2 col-lg-2'>
<label for='rginscri'>RG | Inscrição</label>
<input type='text' class='form-control' name='rginscri' id='rginscri' value="<?php echo $p->rginscri ?>"/></div>
<div class='col-xs-12 col-sm-3 col-md-3 col-lg-3'>
<label for='num_pis'>Nº PIS</label>
<input type='text' class='form-control' name='num_pis' id='num_pis' value="<?php echo $p->num_pis ?>"/></div>
<div class='col-xs-12 col-sm-2 col-md-2 col-lg-2'>
<label for='data_cad_pis'>Data PIS</label>
<input type='text' class='form-control' name='data_cad_pis' id='data_cad_pis' onkeydown="formataData(this,event)" value="<?php echo date('d/m/Y', strtotime($p->data_cad_pis)) ?>"/>
</div>
<div class='col-xs-12 col-sm-3 col-md-3 col-lg-3'>
<label for='agencia_pis'>Agência PIS</label>
<input type='text' class='form-control' name='agencia_pis' id='agencia_pis' value="<?php echo $p->agencia_pis ?>"/></div>
<div class='col-xs-12 col-sm-4 col-md-4 col-lg-4'>
<label for='num_cnt'>Nº CTPS</label>
<input type='text' class='form-control' name='num_cnt' id='num_cnt' value="<?php echo $p->num_cnt ?>"/></div>
<div class='col-xs-12 col-sm-3 col-md-3 col-lg-3'>
<label for='serie_cnt'>Série CTPS</label>
<input type='text' class='form-control' name='serie_cnt' id='serie_cnt' value="<?php echo $p->serie_cnt ?>"/></div>
<div class='col-xs-12 col-sm-2 col-md-2 col-lg-2'>
<label for='nit'>Nº NIT</label>
<input type='text' class='form-control' name='nit' id='nit' value="<?php echo $p->nit ?>"/></div>
<div class='col-xs-12 col-sm-3 col-md-3 col-lg-3'>
<label for='oab'>Nº OAB</label>
<input type='text' class='form-control' name='oab' id='oab' value="<?php echo $p->oab ?>"/></div>
<div class='col-xs-12 col-sm-4 col-md-4 col-lg-4'>
<label for='titulo_numero'>Título Nº</label>
<input type='text' class='form-control' name='titulo_numero' id='titulo_numero' value="<?php echo $p->titulo_numero ?>"/></div>
<div class='col-xs-12 col-sm-3 col-md-3 col-lg-3'>
<label for='titulo_zona'>Título zona</label>
<input type='text' class='form-control' name='titulo_zona' id='titulo_zona' value="<?php echo $p->titulo_zona ?>"/></div>
<div class='col-xs-12 col-sm-2 col-md-2 col-lg-2'>
<label for='titulo_secao'>Título seção</label>
<input type='text' class='form-control' name='titulo_secao' id='titulo_secao' value="<?php echo $p->titulo_secao ?>"/></div>
</div>
<!--ANEXAR DOCUMENTOS-->
<div class='panel-body'>
<label for=''> </label>
<br>
<a href="#anexo" onclick="Mudarestado('dAnexo')" class="link" title="anexar documento"><i class='fa fa-plus-circle'></i>
Anexar documento</a>
</div>
<div id="dAnexo" style="display: none;">
<a name="anexo">
<div class='panel panel-primary active'>
<div class='panel-body'>
<form id="f_documento" name="f_documento" enctype="multipart/form-data" OnSubmit="showCarga()" method="post" action="?page=pessoa/pessoa_crud&var=pessoa_doc">
<a name="peticao">
<input type='hidden' name='cod_pessoa' value="<?php echo $id ?>"/>
<input type='hidden' name='cli_ver' value="1"/>
<div class='col-xs-12 col-sm-3 col-md-3 col-lg-3'>
<label for='data'>Data</label>
<input type='text' class='form-control' readonly name='data' id='data' value="<?php echo date('d/m/Y') ?>"/></div>
<div class='col-xs-12 col-sm-8 col-md-8 col-lg-8'>
<label for='descri'>Descrição</label>
<input type='text' class='form-control upper' autofocus required name='descri' id='descri'/></div>
<div class='col-xs-10 col-sm-10 col-md-10 col-lg-10'>
<label for='caminho'>Adicionar arquivo</label>
<input id="file-0a" class="file" name="caminho" required type="file" multiple data-min-file-count="1">
</div>
<div class='col-xs-2 col-sm-2 col-md-2 col-lg-2'>
<label for='bt_novo'> </label>
<br>
<button type="button" onclick="validaDoc();" name="bt_novo" class="btn btn-primary form-control">
<i class="glyphicon glyphicon-ok"></i></button>
</div>
</a>
</form>
</div>
</div>
</a>
</div>
<!--LISTAR DOCUMENTOS-->
<div class='col-xs-12 col-sm-12 col-md-12 col-lg-12 panel-body'>
<section>
<li class="divider"></li>
<div class='col-xs-12 col-sm-12 col-md-12 col-lg-12'>
<table id="id_peticao" class='dtabelas table table-striped table-hover dt-responsive' cellspacing='0' width='100%' border='0'>
<thead>
<tr class="success">
<th width="2%">ID</th>
<th>Data</th>
<th>Descrição</th>
<th>Arquivo</th>
<th width="2%"></th>
</tr>
</thead>
<tbody>
<?php
$pesDoc = $conn->query("select * from pessoas_doc where cod_pessoa='$id'");
while ($h = $pesDoc->fetch(PDO::FETCH_OBJ)) {
echo "<tr>";
echo "<td>" . $h->codigo . "</td>";
echo "<td>" . date('d/m/Y', strtotime($h->data)) . "</td>";
echo "<td>" . $h->descri . "</td>";
echo "<td>" . substr($h->caminho, 14, 100) . "</td>";
$idend = $h->codigo;
if ($direito=="1") {
echo "<td><a href='#' data-toggle='modal' data-target='#myModal$h->codigo' title='visualizar arquivo'><i aling='center' class='text-red fa fa-file-pdf-o'></i></a></td>";
}
echo "</tr>";
?>
<!-- Modal -->
<div class="modal fade bs-example-modal-lg" id="myModal<?=$h->codigo?>" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" style="margin-top: 2%;">
<div class="modal-dialog modal-lg" role="document">
<div class="modal-content">
<div class="modal-header text-green">
<button type="button" class="close" data-dismiss="modal" aria-label="Fechar">
<span aria-hidden="true"><i title="fechar" aling='center' class='text-red fa fa-power-off'></i></span>
</button>
<h5 class="modal-title" id="myModalLabel"><?=$h->descri?></h5>
</div>
<div class="modal-body">
<?php
$filename = $h->caminho;
if ((substr($filename, -4)==".JPG") || (substr($filename, -4)==".jpg") || (substr($filename, -5)==".jpeg") || (substr($filename, -5)==".JPEG")) { ?>
<img src='" . $filename . "' alt='Imagem' width='100%'>
<?php } else { ?>
<object type="application/pdf" data="<?php echo $filename ?>" width="100%" height="65%">
<a href='<?php echo $filename ?>'><i aling='center' class='text-red fa fa-file-pdf-o'></i> Visualizar
arquivo</a>
</object>
<?php }
?>
</div>
<div class="modal-footer text-green">
<?php echo $p->nome ?> <br> <?php echo $d->objeto ?>
</div>
</div>
</div>
</div>
<?php
}
?>
</tbody>
</table>
</div>
</section>
</div>
<!--ANEXAR DOCUMENTOS-->
</div>
<div class="tab-pane" id="tab2primary">
<div class="panel panel-primary active" align="center"><span style="font-size:18px; color: #060606">Dados profissionais</span></div>
<div class="col-lg-3 col-md-3 col-sm-3 col-xs-12">
Profissão
<select name="cod_profissao" class="form-control select2" style="width: 100%;">
<?php while ($iprof = $prof->fetch(PDO::FETCH_OBJ)) {
if ($p->cod_profissao==$iprof->codigo) {
$selected = 'selected';
} else {
$selected = '';
} ?>
<option value="<?php echo $iprof->codigo ?>"<?php echo $selected; ?>><?php echo $iprof->profissao ?></option>
<?php } ?>
</select>
</div>
<div class='col-lg-3 col-md-3 col-sm-3 col-xs-12'>
Função
<select name="cod_funcao" class="form-control select2" style="width: 100%;">
<?php while ($ifunc = $func->fetch(PDO::FETCH_OBJ)) {
if ($p->cod_funcao==$ifunc->codigo) {
$selected = 'selected';
} else {
$selected = '';
} ?>
<option value="<?php echo $ifunc->codigo ?>"<?php echo $selected; ?>><?php echo $ifunc->profissao ?></option>
<?php } ?>
</select>
</div>
<div class='col-xs-12 col-sm-2 col-md-2 col-lg-2'>
<label for='data_adm'>Admissão</label>
<input type='text' class='form-control' name='data_adm' id='data_adm' onkeydown="formataData(this,event)" value="<?php echo date('d/m/Y', strtotime($p->data_adm)) ?>"/>
</div>
<div class='col-xs-12 col-sm-2 col-md-2 col-lg-2'>
<label for='data_dem'>Demissao</label>
<input type='text' class='form-control' name='data_dem' id='data_dem' onkeydown="formataData(this,event)" value="<?php echo date('d/m/Y', strtotime($p->data_dem)) ?>"/>
</div>
</div>
<div class="tab-pane" id="tab4primary">
<div class="panel panel-primary active" align="center">
<a class='j50 link' title="Adicionar novo contato" href="index2.php?page=pessoa/telefone_cad&id=<?php echo $id ?>"><i class='fa fa-plus-circle fa-1x'></i></a>
| <span style="font-size:18px; color: #060606">Contatos</span> |
<span title="atualizar registros"><i class='fa fa-refresh fa-1x' onclick="combo('tab_tel','sel_telefone','<?php echo $p->codigo ?>')" style="cursor: hand;"></i></span>
</div>
<div id="action">
<div class='col-xs-12 col-sm-12 col-md-12 col-lg-12'>
<section>
<div class='col-xs-12 col-sm-7 col-md-7 col-lg-7'>
<label for='email'>Telefones</label>
<form id='frm_pesq' method='post' class="search-form">
<table id="tab_tel" class='table dtabelas table-striped table-hover dt-responsive' cellspacing='0' width='100%' border='0'>
<thead>
<tr class="success">
<th width="2%">ID</th>
<th>Tipo</th>
<th>Telefone</th>
<th>Ramal</th>
<th>Contato</th>
<th width="2%"></th>
</tr>
</thead>
<tbody>
<?php
while ($e = $tele->fetch(PDO::FETCH_OBJ)) {
echo "<tr>";
echo "<td>" . $e->codigo . "</td>";
echo "<td>" . $e->tipo . "</td>";
echo "<td>" . $e->telefone . "</td>";
echo "<td>" . $e->ramal . "</td>";
echo "<td>" . $e->contato . "</td>";
$idend = $e->codigo;
//$pes = $e->cod_pessoa;
////if($direito == "1") {
echo "<td><a class='j50' href='index2.php?page=pessoa/telefone_edt&id=$p->codigo&idend=$idend&var=editar' title=\"editar registro\"><i aling='center' class='fa fa-pencil'></i></a></td>";
//}
echo "</tr>";
}
?>
</tbody>
</table>
</form>
</div>
<div class='col-xs-12 col-sm-5 col-md-5 col-lg-5'>
<label for='email'>email</label>
<input type='email' class='form-control' name='email' id='email' required value="<?php echo $p->email ?>" style="text-transform: lowercase;"/>
</div>
</section>
</div>
</div>
</div>
<div class="tab-pane" id="tab5primary">
<div class="panel panel-primary active" align="center"><span style="font-size:18px; color: #060606">Processos</span></div>
<div id="action">
<table class='table dtabelas table-striped table-hover dt-responsive' cellspacing='0' width='100%' border='0'>
<thead>
<tr class="success">
<th width="2%">ID</th>
<th>Processo</th>
<th>Requerente</th>
<th>Adv.Responsável</th>
<th>Requerido</th>
<th>Objeto ação</th>
<th>Órgão</th>
<th width="2%"></th>
</tr>
</thead>
<tbody>
<?php
while ($d = $proc->fetch(PDO::FETCH_OBJ)) {
echo "<tr>";
echo "<td>" . $d->codigo . "</td>";
echo "<td>" . $d->n_processo . "</td>";
echo "<td>" . $d->polo_ativo . "</td>";
echo "<td>" . $d->adv_resp . "</td>";
echo "<td>" . $d->polo_passivo . "</td>";
echo "<td>" . $d->objeto . "</td>";
echo "<td>" . $d->orgao . "</td>";
$id = $d->codigo;
// if($direito == "1") {
echo "<td><a class='j80' href='index2.php?page=processos/processo_edt&id=$id'><i aling='center' class='fa fa-pencil' title='Editar registro'></i></a></td>";
// }
echo "</tr>";
}
?>
</tbody>
</table>
</div>
</div>
<div class="tab-pane" id="tab6primary">
<div class="panel panel-primary active" align="center"><span style="font-size:18px; color: #060606">
<a class='j90 link' title="Adicionar novo compromisso" href="index2.php?page=agenda/agenda_cad&id=<?php echo $id ?>"><i class='fa fa-plus-circle'></i></a>
| <span style="font-size:18px; color: #060606">Agenda</span> |
<span title="atualizar registros"><i class='fa fa-refresh' title="atualizar lista de compromissos" onclick="combo('tab_agenda','sel_agenda','<?php echo $p->codigo ?>')" style="cursor: hand;font-size:14px;"></i></span>
</span></div>
<div id="action">
<table id="tab_agenda" class='table dtabelas table-striped table-hover dt-responsive' cellspacing='0' width='100%' border='0'>
<thead>
<tr class="success">
<th width="2%">ID</th>
<th>Solicitante</th>
<th>Compromisso</th>
<th>Data</th>
<th>Hora início</th>
<th>Lembrar (H:M antes)</th>
<th>Local</th>
<th width="2%"></th>
</tr>
</thead>
<tbody>
<?php
while ($age = $agenda->fetch(PDO::FETCH_OBJ)) {
echo "<tr>";
echo "<td>" . $age->codigo . "</td>";
echo "<td>" . $age->nome . "</td>";
echo "<td>" . $age->compromisso . "</td>";
echo "<td>" . date('d/m/Y', strtotime($age->data_compromisso)) . "</td>";
echo "<td>" . $age->hora_inicio . "</td>";
echo "<td>" . $age->lembrar . "</td>";
echo "<td>" . $age->local . "</td>";
$id = $age->codigo;
//if($direito == "1") {
echo "<td><a class='j60' href='index2.php?page=agenda/agenda_edt&id=$age->codigo&acao=pessoa' title=\"visualizar registro\"><i aling='center' class='fa fa-eye'></i></a></td>";
//}
echo "</tr>";
}
?>
</tbody>
</table>
</div>
</div>
<div class="tab-pane" id="tab7primary">
<div class="panel panel-primary active" align="center"><span style="font-size:18px; color: #060606">
<a class='j90 link' title="Adicionar novo contrato" href="index2.php?page=contrato/contrato_cad&id=<?php echo $id ?>"><i class='fa fa-plus-circle'></i></a>
| <span style="font-size:18px; color: #060606">Contratos</span> |
<span title="atualizar registros"><i class='fa fa-refresh' title="atualizar lista de contratos" onclick="combo('tab_cont','sel_contrato','<?php echo $p->codigo ?>')" style="cursor: hand;font-size:14px;"></i></span>
</span></div>
<div id="action">
<table id="tab_cont" class='table dtabelas table-striped table-hover dt-responsive' cellspacing='0' width='100%' border='0'>
<thead>
<tr class="success">
<th width="2%">ID</th>
<th>Contratante</th>
<th>Descrição</th>
<th>Situação</th>
<th>Tipo</th>
<th>Valor</th>
<th>Valor mensal</th>
<th>Vencimento</th>
<th width="2%"></th>
</tr>
</thead>
<tbody>
<?php
while ($d = $cont->fetch(PDO::FETCH_OBJ)) {
echo "<tr>";
echo "<td>" . $d->codigo . "</td>";
echo "<td>" . $d->nome . "</td>";
echo "<td>" . $d->descricao . "</td>";
echo "<td>" . $d->situacao . "</td>";
echo "<td>" . $d->lancamento . "</td>";
echo "<td>" . $d->valor . "</td>";
echo "<td>" . $d->valor_mensal . "</td>";
echo "<td>dia: " . $d->dia_venc . "</td>";
$id = $d->codigo;
//if($direito == "1") {
echo "<td><a class='j80' title=\"editar registro\" href='index2.php?page=contrato/contrato_edt&id=$id'><i aling='center' class='fa fa-pencil'></i></a></td>";
//}
echo "</tr>";
}
?>
</tbody>
</table>
</div>
</div>
<div class="tab-pane" id="tab8primary">
<div class="panel panel-primary active" align="center"><span style="font-size:18px; color: #060606">Foto da pessoa</span></div>
<div id="action">
<div class='col-xs-12 col-sm-4 col-md-4 col-lg-4 centro'>
<?php if ($p->foto=='') { ?>
<img class="img-bordered img-rounded" src="images/usuario.png" width='32%'/>
<? } else { ?>
<img class="img-bordered img-rounded" src="<?php echo $p->foto ?>" alt='Imagem' width='32%'>
<?php } ?>
<form name="f_fotol" enctype="multipart/form-data" OnSubmit="showCarga()" id="f_fotol" method="post" action="?page=pessoa/pessoa_crud&var=pessoa_foto_limpar">
<input type='hidden' name='cod_pessoa' value="<?php echo $p->codigo ?>"/>
<button type="submit" name="bt_novo" style="background: white;" class="btn" title="limpar foto">
<i class="glyphicon glyphicon-remove font_red"></i>
</button>
</form>
</div>
<form name="f_foto" enctype="multipart/form-data" OnSubmit="showCarga()" id="f_foto" method="post" action="?page=pessoa/pessoa_crud&var=pessoa_foto">
<input type='hidden' name='cod_pessoa' value="<?php echo $p->codigo ?>"/>
<div class='col-xs-12 col-sm-8 col-md-8 col-lg-8'>
<label for='caminho'>Adicionar | mudar foto</label>
<input id="file-0a" class="file" name="foto" required type="file" data-min-file-count="1" accept="image/jpeg">
<label for='bt_novo'> </label>
<button type="button" onclick="validaFoto();" name="bt_novo" class="btn btn-primary form-control">
<i class="glyphicon glyphicon-ok"></i> Salvar foto
</button>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</form>