| 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/parecer/ |
Upload File : |
<?php
$id = $_GET['id'];
$parecer = $conn->query("select * from v_lista_parecer where parecer_id=$id");
$p = $parecer->fetch(PDO::FETCH_OBJ);
$set_soli = $conn->query("select * from setor_solicitante order by setor");
$tip_proc = $conn->query("select * from tipo_procedimento order by tipo_procedimento");
$tip_fase = $conn->query("select * from fases order by fase");
$tip_cont = $conn->query("select * from fornecedores order by fornecedor");
$tip_tema = $conn->query("select * from temas order by tema");
$tip_pess = $conn->query("select * from v_lista_pessoas where cod_tipo_pessoa=3 order by nome");
$tip_area = $conn->query("select * from areas order by area");
$tip_pare = $conn->query("select * from parecer_tipo order by tipo");
$arq_stat = $conn->query("select * from parecer_arq_status");
$arq_file = $conn->query("select * from v_lista_parecer_arq where parecer_id=$id order by arquivo_id DESC");
?>
<head>
<script src="js/mascara.js" type="text/javascript"></script>
<script>
function combo(id, acao, valor) {
$.ajax({
type: "GET",
url: 'modulos/parecer/ajax.php?a=' + acao + '&valor=' + valor,
dataType: "html",
success: function (resultado) {
//alert(resultado);
$('#' + id).html(resultado);
//$('#resposta').html(resultado);
}
});
}
</script>
</head>
<div class="container">
<div class='row'>
<div class='panel-body label'>
<a href='?page=parecer/parecer' title="voltar"><i aling='center' class='fa fa-arrow-circle-o-left fa-2x' title='Voltar'></i></a>
<span style="font-size:20px; color: #060606"> Parecer/Ofício | Edição</span>
<a class="j90" href='index2.php?page=parecer/auxiliar' target="_blank">
<i aling='center' class='fa fa-plus-circle fa-2x pull-right' title='Tabelas auxiliares'></i>
</a>
</div>
</div>
</div>
<div class="container-fluid">
<div class="row">
<div class="panel-body">
<form id="form1" name="form1" OnSubmit="showCarga()" id="formulario" method="post" action="?page=parecer/parecer_crud&var=editar">
<div class='panel panel-primary filterable panel-body'>
<input type='hidden' name='parecer_id' value="<?php echo $p->parecer_id ?>"/>
<input type='hidden' name='id' value="<?php echo $p->parecer_id ?>"/>
<div class='col-md-1'>
<label>ID</label>
<input type='text' disabled class='form-control' autofocus name='referencia' value="<?php echo $p->parecer_id ?>"/>
</div>
<div class="col-md-2">
<label>Tipo</label>
<select name="tipo_id" class="form-control select2">
<?php while ($pt = $tip_pare->fetch(PDO::FETCH_OBJ)) {
if ($p->tipo_id==$pt->tipo_id) {
$selected = 'selected';
} else {
$selected = '';
} ?>
<option value="<?php echo $pt->tipo_id ?>"<?php echo $selected; ?>><?php echo $pt->tipo ?></option>
<?php } ?>
</select>
</div>
<div class='col-md-9'>
<label>Referência</label>
<input type='text' class='form-control' autofocus name='referencia' value="<?php echo $p->referencia ?>"/>
</div>
<div class="col-md-6">
<label>Setor solicitante
<i class='fa fa-refresh' onclick="combo('cod_setor_sol','sel_setor_sol','0')" style="cursor: hand;"></i>
</label>
<select id="cod_setor_sol" name="setor_solicitante_id" class="form-control select2">
<?php while ($ss = $set_soli->fetch(PDO::FETCH_OBJ)) {
if ($p->setor_solicitante_id==$ss->setor_solicitante_id) {
$selected = 'selected';
} else {
$selected = '';
} ?>
<option value="<?php echo $ss->setor_solicitante_id ?>"<?php echo $selected; ?>><?php echo $ss->setor ?></option>
<?php } ?>
</select>
</div>
<div class='col-md-3'>
<label>Data solicitação</label>
<input type='text' class='form-control' name='data_solictacao' value="<?php echo date('d/m/Y', strtotime($p->data_solicitacao)) ?>"/>
</div>
<div class='col-md-3'>
<label>Prazo</label>
<input type='text' class='form-control' name='prazo_realizar' value="<?php echo date('d/m/Y', strtotime($p->prazo_realizar)) ?>"/>
</div>
<div class="col-md-6">
<label>Tipo procedimento
<i class='fa fa-refresh' onclick="combo('cod_tipo_proc','sel_tipo_proc','0')" style="cursor: hand;"></i></label>
<select id="cod_tipo_proc" name="tipo_procedimento_id" class="form-control select2">
<?php while ($tp = $tip_proc->fetch(PDO::FETCH_OBJ)) {
if ($p->tipo_procedimento_id==$tp->tipo_procedimento_id) {
$selected = 'selected';
} else {
$selected = '';
} ?>
<option value="<?php echo $tp->tipo_procedimento_id ?>"<?php echo $selected; ?>><?php echo $tp->tipo_procedimento ?></option>
<?php } ?>
</select>
</div>
<div class="col-md-6">
<label>Fase
<i class='fa fa-refresh' onclick="combo('cod_fase','sel_fase','0')" style="cursor: hand;"></i>
</label>
<select id="cod_fase" name="fase_id" class="form-control select2">
<?php while ($tf = $tip_fase->fetch(PDO::FETCH_OBJ)) {
if ($p->fase_id==$tf->codigo) {
$selected = 'selected';
} else {
$selected = '';
} ?>
<option value="<?php echo $tf->codigo ?>"<?php echo $selected; ?>><?php echo $tf->fase ?></option>
<?php } ?>
</select>
</div>
<div class="col-md-6">
<label>Contratado
<i class='fa fa-refresh' onclick="combo('cod_contratado','sel_contratado','0')" style="cursor: hand;"></i>
</label>
<select id="cod_contratado" name="contratado_id" class="form-control select2">
<?php while ($co = $tip_cont->fetch(PDO::FETCH_OBJ)) {
if ($p->contratado_id==$co->codigo) {
$selected = 'selected';
} else {
$selected = '';
} ?>
<option value="<?php echo $co->codigo ?>"<?php echo $selected; ?>><?php echo $co->fornecedor ?></option>
<?php } ?>
</select>
</div>
<div class="col-md-6">
<label>Tema
<i class='fa fa-refresh' onclick="combo('cod_tema','sel_tema','0')" style="cursor: hand;"></i>
</label>
<select id="cod_tema" name="tema_id" class="form-control select2">
<?php while ($tt = $tip_tema->fetch(PDO::FETCH_OBJ)) {
if ($p->tema_id==$tt->tema_id) {
$selected = 'selected';
} else {
$selected = '';
} ?>
<option value="<?php echo $tt->tema_id ?>"<?php echo $selected; ?>><?php echo $tt->tema ?></option>
<?php } ?>
</select>
</div>
<div class="col-md-6">
<label>Advogado responsável
<i class='fa fa-refresh' onclick="combo('cod_adv_resp','sel_adv_resp','0')" style="cursor: hand;"></i>
</label>
<select id="cod_adv_resp" name="advogado_responsavel" class="form-control select2">
<?php while ($pe = $tip_pess->fetch(PDO::FETCH_OBJ)) {
if ($p->advogado_responsavel==$pe->codigo) {
$selected = 'selected';
} else {
$selected = '';
} ?>
<option value="<?php echo $pe->codigo ?>"<?php echo $selected; ?>><?php echo $pe->nome ?></option>
<?php } ?>
</select>
</div>
<div class="col-md-6">
<label>Área
<i class='fa fa-refresh' onclick="combo('cod_area','sel_area','0')" style="cursor: hand;"></i>
</label>
<select id="cod_area" name="area_id" class="form-control select2">
<?php while ($ta = $tip_area->fetch(PDO::FETCH_OBJ)) {
if ($p->area_id==$ta->codigo) {
$selected = 'selected';
} else {
$selected = '';
} ?>
<option value="<?php echo $ta->codigo ?>"<?php echo $selected; ?>><?php echo $ta->area ?></option>
<?php } ?>
</select>
</div>
<div class='col-md-10'>
<label>Providência</label>
<input type='text' class='form-control' name='providencia' value="<?php echo $p->providencia ?>"/>
</div>
<div class='col-md-1'>
<label>Finalizado?</label>
<?php if ($p->finalizado=='1') { ?>
<input type="checkbox" checked name="finalizado" value="1">
<?php } else { ?>
<input type="checkbox" name="finalizado" value="1">
<?php } ?>
</div>
<div class='col-md-1'>
<label for='bt_novo'> </label>
<br>
<button type="submit" name="bt_novo" title="Salvar registro" class="btn btn-primary form-control"><i class="glyphicon glyphicon-ok"></i></button>
</div>
</div>
</form>
</div>
</div>
</div>
<!--ADICIONAR ARQUIVO-->
<div class="container-fluid">
<div class="row">
<div class="panel-body">
<div class='panel panel-primary filterable panel-body'>
<span style="font-size:15px; color: #060606"><b> Adicionar arquivo</b></span>
<form id="f_files" name="f_files" enctype="multipart/form-data" OnSubmit="showCarga()" method="post" action="?page=parecer/parecer_crud&var=parecer_arq">
<a name="peticao">
<input type='hidden' name='id' value="<?php echo $p->parecer_id ?>"/>
<div class='col-md-10'>
<label for='descri'>Descrição</label>
<input type='text' class='form-control upper' name='descricao'/>
</div>
<div class="col-md-2">
<label>Status
<i class='fa fa-refresh' onclick="combo('cod_status','sel_status','0')" style="cursor: hand;"></i>
</label>
<select id="cod_status" name="status" class="form-control select2">
<?php while ($sta = $arq_stat->fetch(PDO::FETCH_OBJ)) { ?>
<option value="<?php echo $sta->status_id ?>"><?php echo $sta->status ?></option>
<?php } ?>
</select>
</div>
<div class='col-md-10'>
<label for='caminho'>Adicionar arquivo</label>
<input id="file-0a" class="file" name="caminho" type="file" multiple data-min-file-count="1" accept=".pdf, .doc, .docx, .jpg, .jpeg, .xls, .xlsx">
</div>
<div class='col-md-2'>
<label for='bt_novo'> </label>
<br>
<button type="submit" onclick="validaPeticoes();" name="bt_novo" class="btn btn-primary form-control">
<i class="glyphicon glyphicon-ok"></i></button>
</div>
</a>
</form>
</div>
</div>
<div class="container-fluid">
<div class='panel panel-primary filterable panel-body'>
<span style="font-size:15px; color: #060606"><b> Arquivos anexados</b></span>
<form id='frm_pesq' method='post' class="search-form">
<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>Status</th>
<th>Data</th>
<th>Descrição</th>
<th>Tipo</th>
<th width="2%"></th>
</tr>
</thead>
<tbody>
<?php
while ($d = $arq_file->fetch(PDO::FETCH_OBJ)) {
echo "<tr>";
echo "<td>" . $d->arquivo_id . "</td>";
echo "<td>" . $d->status . "</td>";
echo "<td>" . date('d/m/Y', strtotime($d->data)) . "</td>";
echo "<td>" . $d->descricao . "</td>";
echo "<td>" . $d->tipo . "</td>";
$id = $d->arquivo_id;
echo "<td><a href='$d->caminho' target='_blank'><i aling='center' class='fa fa-eye text-orange' title='Visualizar arquivo' style='font-size: 20px;'></i></a></td>";
echo "</tr>";
}
?>
</tbody>
</table>
</form>
</div>
</div>
</div>
</div>
<!--FIM ADICIONAR ARQUIVO-->
</div>
</div>