Viewing File: /home/cienp/public_html/portal/alt_solc.php
<?
if ($_POST[passa] == 'yes') {
$s_id_comp = protecao($_POST[id_comp],'inteiro');
$sql = "SELECT c.*, u.nm_user, t.de_tipo, s.de_sitc, ";
$sql .= "DATE_FORMAT(c.dt_venc, '%d/%m/%Y') as dt_venc, ";
$sql .= "DATE_FORMAT(c.dt_cads, '%d/%m/%Y') as dt_cads, ";
$sql .= "DATE_FORMAT(c.dt_aprv, '%d/%m/%Y') as dt_aprv, ";
$sql .= "DATE_FORMAT(c.dt_entr_prev, '%d/%m/%Y') as dt_entr_prev, ";
$sql .= "DATE_FORMAT(c.dt_envi_solc, '%d/%m/%Y') as dt_envi_solc ";
$sql .= "FROM ".$pref_tabl."comp c, ".$pref_tabl."solc_tipo t, ".$pref_tabl."user u, ";
$sql .= $pref_tabl."sitc s ";
$sql .= "WHERE c.id_cads = u.id_user ";
$sql .= "AND c.id_tipo = t.id_tipo ";
$sql .= "AND c.id_sitc = s.id_sitc ";
$sql .= "AND c.id_comp = $s_id_comp ";
$sql .= "LIMIT 1";
#echo $sql.'<br>';
$res = mysqli_query($conn, $sql);
if (mysqli_num_rows($res) > 0) {
$linha = mysqli_fetch_array($res);
if ($linha[id_recs] != '') {
$sqlre = "SELECT de_recs, de_desc ";
$sqlre .= "FROM ".$pref_tabl."recs ";
$sqlre .= "WHERE id_recs = $linha[id_recs] ";
$sqlre .= "LIMIT 1 ";
#echo $sqlre.'<br>';
$resre = mysqli_query($conn, $sqlre);
if (mysqli_num_rows($resre) > 0) {
$linhare = mysqli_fetch_array($resre);
if ($linha[id_recs] == 10) {
$linhare[de_recs] .= ' - '.$linha[de_recs_outr];
}
// $linhare[de_desc] = nl2br($linhare[de_desc]);
}
}
if ($linha[id_forn] != '') {
$sqlfr = "SELECT nm_forn, de_mail, nu_fone, de_cont ";
$sqlfr .= "FROM ".$pref_tabl."forn ";
$sqlfr .= "WHERE id_forn = $linha[id_forn] ";
$sqlfr .= "LIMIT 1 ";
#echo $sqlre.'<br>';
$resfr = mysqli_query($conn, $sqlfr);
if (mysqli_num_rows($resfr) > 0) {
$linhafr = mysqli_fetch_array($resfr);
}
}
if ($linha[id_pagm] != '') {
$sqlpg = "SELECT de_pagm ";
$sqlpg .= "FROM ".$pref_tabl."solc_pagm ";
$sqlpg .= "WHERE id_pagm = $linha[id_pagm] ";
$sqlpg .= "LIMIT 1 ";
#echo $sqlre.'<br>';
$respg = mysqli_query($conn, $sqlpg);
if (mysqli_num_rows($respg) > 0) {
$linhapg = mysqli_fetch_array($respg);
}
}
if ($linha[id_resp] != '') {
$sqlr = "SELECT nm_user ";
$sqlr .= "FROM ".$pref_tabl."user ";
$sqlr .= "WHERE id_user = $linha[id_resp] ";
$sqlr .= "LIMIT 1 ";
#echo $sqlr.'<br>';
$resr = mysqli_query($conn, $sqlr);
if (mysqli_num_rows($resr) > 0) {
$linhar = mysqli_fetch_array($resr);
}
}
if ($linha[id_cads] != $linha[id_cads_real]) {
$sqlra = "SELECT nm_user ";
$sqlra .= "FROM ".$pref_tabl."user ";
$sqlra .= "WHERE id_user = $linha[id_cads_real] ";
$sqlra .= "LIMIT 1 ";
#echo $sqlra.'<br>';
$resra = mysqli_query($conn, $sqlra);
if (mysqli_num_rows($resra) > 0) {
$linhara = mysqli_fetch_array($resra);
$nm_cads_real = '(Cadastro: '.$linhara[nm_user].')';
}
}
if ($linha[dt_venc] == '00/00/0000') {
$linha[dt_venc] = '';
}
if ($linha[dt_entr_prev] == '00/00/0000') {
$linha[dt_entr_prev] = '';
}
?>
<script src="<?php echo $this->site_root?>/vendors/jquery/dist/jquery.min.js"></script><!-- jQuery -->
<script src="<?php echo $this->site_root?>/vendors/moment/min/moment.min.js"></script><!-- bootstrap-daterangepicker -->
<script src="<?php echo $this->site_root?>/vendors/moment/locale/pt-br.js"></script><!-- bootstrap-daterangepicker -->
<script src="<?php echo $this->site_root?>/vendors/bootstrap-daterangepicker/daterangepicker.js"></script><!-- bootstrap-daterangepicker -->
<script src="<?php echo $this->site_root?>/vendors/bootstrap-datetimepicker/build/js/bootstrap-datetimepicker.min.js"></script>
<div class="right_col" role="main">
<div class="row">
<div class="col-xs-12">
<di class="x_panel">
<div class="x_title">
<h2>Solicitação <small>Gerenciador de Solicitação</small></h2>
<ul class="nav navbar-right panel_toolbox">
<li>
<button class="btn btn-default" onclick="window.print();"><i class="fa fa-print"></i> Imprimir</button>
<!--<i class="fa fa-file-excel-o" aria-hidden="true"></i> Imprimir-->
</li>
<li>
<a href="javascript:voltar();" style="padding:0px;"><button class="btn btn-primary" type="button">Voltar</button></a>
</li>
</ul>
<div class="clearfix"></div>
</div>
<?php
if ($_GET[certo] == 'T') {
echo "<div class='alert alert-success alert-dismissible fade in' role='alert' style='margin-top:30px;'>
<button type='button' class='close' data-dismiss='alert' aria-label='Close'><span aria-hidden='true'>×</span></button>
<strong>Solicitação de Compras!</strong> O item foi inserido com sucesso!
</div>";
}
if ($_GET[certo] == 'A') {
echo "<div class='alert alert-success alert-dismissible fade in' role='alert' style='margin-top:30px;'>
<button type='button' class='close' data-dismiss='alert' aria-label='Close'><span aria-hidden='true'>×</span></button>
<strong>Solicitação de Compras!</strong> Sua Solicitação foi alterada com sucesso!
</div>";
}
if ($_GET[certo] == 'M') {
echo "<div class='alert alert-success alert-dismissible fade in' role='alert' style='margin-top:30px;'>
<button type='button' class='close' data-dismiss='alert' aria-label='Close'><span aria-hidden='true'>×</span></button>
<strong>Envio de e-mail para Fornecedor!</strong> O e-mail foi enviado com sucesso!
</div>";
}
if ($_GET[certo] == 'X') {
echo "<div class='alert alert-success alert-dismissible fade in' role='alert' style='margin-top:30px;'>
<button type='button' class='close' data-dismiss='alert' aria-label='Close'><span aria-hidden='true'>×</span></button>
<strong>Solicitação de Compras!</strong> O anexo foi excluído com sucesso!
</div>";
}
if ($_GET[certo] == 'N') {
echo "<div class='alert alert-danger alert-dismissible fade in' role='alert' style='margin-top:30px;'>
<button type='button' class='close' data-dismiss='alert' aria-label='Close'><span aria-hidden='true'>×</span></button>
<strong>Inserção de Solicitação!</strong> Erro ao efetuar a operação. Entre em contato com o administrador!
</div>";
}
if ($_GET[certo] == 'L') {
echo "<div class='alert alert-danger alert-dismissible fade in' role='alert' style='margin-top:30px;'>
<button type='button' class='close' data-dismiss='alert' aria-label='Close'><span aria-hidden='true'>×</span></button>
<strong>Envio de e-mail para Fornecedor!</strong> E-mail do fornecedor inválido!
</div>";
}
if ($_GET[certo] == 'D') {
echo "<div class='alert alert-danger alert-dismissible fade in' role='alert' style='margin-top:30px;'>
<button type='button' class='close' data-dismiss='alert' aria-label='Close'><span aria-hidden='true'>×</span></button>
<strong>Envio de e-mail para Fornecedor!</strong> Descrição do e-mail para o fornecedor não esta cadastrada corretamente!
</div>";
}
if ($_GET[certo] == 'E') {
echo "<div class='alert alert-danger alert-dismissible fade in' role='alert' style='margin-top:30px;'>
<button type='button' class='close' data-dismiss='alert' aria-label='Close'><span aria-hidden='true'>×</span></button>
<strong>Envio de e-mail para Fornecedor!</strong> Erro ao enviar o e-mail. Entre em contato com o administrador!
</div>";
}
if ($_GET[certo] == 'F') {
echo "<div class='alert alert-danger alert-dismissible fade in' role='alert' style='margin-top:30px;'>
<button type='button' class='close' data-dismiss='alert' aria-label='Close'><span aria-hidden='true'>×</span></button>
<strong>Inserção de Solicitação!</strong> Erro ao efetuar a operação. O arquivo não é um PDF!
</div>";
}
if ($_GET[certo] == 'V') {
echo "<div class='alert alert-danger alert-dismissible fade in' role='alert' style='margin-top:30px;'>
<button type='button' class='close' data-dismiss='alert' aria-label='Close'><span aria-hidden='true'>×</span></button>
<strong>Inserção de Solicitação!</strong> Erro ao efetuar a operação. O arquivo informado não é um arquivo válido.
</div>";
}
if ($_GET[certo] == 'Y') {
echo "<div class='alert alert-danger alert-dismissible fade in' role='alert' style='margin-top:30px;'>
<button type='button' class='close' data-dismiss='alert' aria-label='Close'><span aria-hidden='true'>×</span></button>
<strong>Inserção de Solicitação!</strong> Erro ao efetuar a operação. O arquivo informado é um diretorio.
</div>";
}
if ($_GET[certo] == 'SA') {
echo "<div class='alert alert-success alert-dismissible fade in' role='alert' style='margin-top:30px;'>
<button type='button' class='close' data-dismiss='alert' aria-label='Close'><span aria-hidden='true'>×</span></button>
<strong>Anexo da Solicitação!</strong> O arquivo foi inserido com sucesso!
</div>";
}
if ($_GET[certo] == 'SAP') {
echo "<div class='alert alert-success alert-dismissible fade in' role='alert' style='margin-top:30px;'>
<button type='button' class='close' data-dismiss='alert' aria-label='Close'><span aria-hidden='true'>×</span></button>
<strong>Inserção de Agenda de Pagamento!</strong> Sua agenda foi inserida com sucesso!
</div>";
}
if ($_GET[certo] == 'NAP') {
echo "<div class='alert alert-danger alert-dismissible fade in' role='alert' style='margin-top:30px;'>
<button type='button' class='close' data-dismiss='alert' aria-label='Close'><span aria-hidden='true'>×</span></button>
<strong>Inserção de Agenda de Pagamento!</strong> Erro ao efetuar a operação. Entre em contato com o administrador!
</div>";
}
if ($_GET[certo] == 'SAPP') {
echo "<div class='alert alert-success alert-dismissible fade in' role='alert' style='margin-top:30px;'>
<button type='button' class='close' data-dismiss='alert' aria-label='Close'><span aria-hidden='true'>×</span></button>
<strong>Solicitação de Compras!</strong> Sua agenda de pagamento foi alterada com sucesso!
</div>";
}
if ($_GET[certo] == 'NAPP') {
echo "<div class='alert alert-danger alert-dismissible fade in' role='alert' style='margin-top:30px;'>
<button type='button' class='close' data-dismiss='alert' aria-label='Close'><span aria-hidden='true'>×</span></button>
<strong>Alteração de Agenda de Pagamento!</strong> Erro ao efetuar a operação. Entre em contato com o administrador!
</div>";
}
?>
<div class="x_content">
<div class="row">
<br />
<div class="col-sm-6 col-xs-12">
<div class="form-group" style="font-size: 16px;">
<p><b>O<?php echo $linha[fl_ocos];?> N°:</b> <?php echo $linha[nu_oc];?></p>
<p><b>Tipo de Solicitação:</b> <?php echo $linha[de_tipo];?></p>
<p><b>Origem do Recurso:</b> <?php echo $linhare[de_recs];?></p>
<p><b>Justificativas:</b> <?php echo $linha[de_just];?></p>
<p><b>Prazo de Entrega:</b> <?php echo $linha[de_praz];?></p>
<p><b>Fornecedor:</b> <?php echo $linhafr[nm_forn];?></p>
<p><b>Forma de Pagamento:</b> <?php echo $linhapg[de_pagm];?></p>
</div>
</div>
<div class="col-sm-6 col-xs-12">
<div class="form-group" style="font-size: 16px;">
<p><b>Data Solicitação:</b> <?php echo $linha[dt_cads];?></p>
<p><b>Data Entrega Prevista:</b> <?php echo $linha[dt_entr_prev];?></p>
<p><b>Solicitante:</b> <?php echo $linha[nm_user];?> <?php echo $nm_cads_real;?></p>
<p><b>Situação:</b> <?php echo $linha[de_sitc];?></p>
<p><b>Responsável:</b> <?php echo $linhar[nm_user];?></p>
<p><b>Data da Aprovação:</b> <?php echo $linha[dt_aprv];?></p>
<p><b>Vencimento do Boleto:</b> <?php echo $linha[dt_venc];?></p>
</div>
</div>
<br />
</div>
<!--<div class="form-group">
<div class="col-md-6 col-sm-6 col-xs-12" style="padding:0px; margin:10px 0;">
<a href="javascript:voltar();"><button class="btn btn-primary" type="button">Voltar</button></a>
</div>
</div>-->
</div>
<?php
$sqlit = "SELECT *, ";
$sqlit .= "DATE_FORMAT(dt_recb, '%d/%m/%Y') as dt_recb ";
$sqlit .= "FROM ".$pref_tabl."item ";
$sqlit .= "WHERE id_comp = $s_id_comp ";
$sqlit .= "ORDER BY id_item ";
#echo $sqlit.'<br>';
$resit = mysqli_query($conn, $sqlit);
if (mysqli_num_rows($resit) > 0) {
?>
<div class="x_content">
<div class="row">
<div class="col-xs-12 table">
<div class="table-responsive">
<br />
<div class="x_title">
<h2>Itens da Solicitação<small>Gerenciador de Solicitação</small></h2>
<?php
if (($linhau[fl_solc] == 'P') // Compras
&& ($linha[id_sitc] != 7) // Cancelada
&& ($linha[id_sitc] != 888) // Aguardando Recebimento ... retirado por Jarbas em 08/12/21
&& ($linha[id_sitc] != 9) // Recebimento Parcial
&& ($linha[id_sitc] != 10)) { // Aguardando Pagamento
?>
<ul class="nav navbar-right panel_toolbox">
<li class="botn_mais_solc">
<a href="javascript:ver_mais();" class="btn btn-success btn-xs"><i class="fa fa-plus-circle " aria-hidden="true"> Inserir</i></a>
</li>
</ul>
<?php
}
?>
<div class="clearfix"></div>
</div>
<?php
if (($linhau[fl_solc] == 'P') // Compras
&& ($linha[id_sitc] != 7) // Cancelada
&& ($linha[id_sitc] != 888) // Aguardando Recebimento ... retirado por Jarbas em 08/12/21
&& ($linha[id_sitc] != 9) // Recebimento Parcial
&& ($linha[id_sitc] != 10)) { // Aguardando Pagamento
?>
<div class="x_content" id="mais" style="display:none;">
<div class="row">
<div class="col-xs-12 table">
<div class="row">
<br />
<form id="demo-form2" data-parsley-validate class="form-horizontal form-label-left" action="<?php echo $this->site_root?>/index1.php?pg=sql_solc" enctype="multipart/form-data" method="POST" name="itemsolc">
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12">Quantidade <span class="required">*</span></label>
<div class="col-md-3 col-sm-6 col-xs-12">
<input type="text" id="nu_qtde" name="nu_qtde" class="form-control col-md-7 col-xs-12" maxlength="9" required="required">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12">Descrição <span class="required">*</span></label>
<div class="col-md-6 col-sm-6 col-xs-12">
<input type="text" id="de_item" name="de_item" class="form-control col-md-7 col-xs-12" required="required">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12">Valor</label>
<div class="col-md-3 col-sm-6 col-xs-12">
<input type="text" id="nu_valr" name="nu_valr" class="form-control col-md-7 col-xs-12">
</div>
</div>
<div class="form-group">
<div class="col-md-6 col-sm-6 col-xs-12 col-md-offset-3">
<button type="submit" class="btn btn-success">Inserir</button>
<input name="opc" type="hidden" id="opc" value="nov_item">
<input name="id_comp" type="hidden" id="id_comp" value="<?php echo $s_id_comp;?>">
<input name="passa" type="hidden" id="passa" value="yes">
<input type="hidden" name="v_nu_oc" id="v_nu_oc" value="<?=$_POST[v_nu_oc]?>">
<input type="hidden" name="v_id_tipo" id="v_id_tipo" value="<?=$_POST[v_id_tipo]?>">
<input type="hidden" name="v_id_forn" id="v_id_forn" value="<?=$_POST[v_id_forn]?>">
<input type="hidden" name="v_id_recs" id="v_id_recs" value="<?=$_POST[v_id_recs]?>">
<input type="hidden" name="v_id_sitc" id="v_id_sitc" value="<?=$_POST[v_id_sitc]?>">
<input type="hidden" name="v_id_user" id="v_id_user" value="<?=$_POST[v_id_user]?>">
<input type="hidden" name="v_dt_inic" id="v_dt_inic" value="<?=$_POST[v_dt_inic]?>">
<input type="hidden" name="v_dt_finl" id="v_dt_finl" value="<?=$_POST[v_dt_finl]?>">
</div>
</div>
</form>
<br />
</div>
</div>
</div>
</div>
<?php
}
?>
<table class="table table-striped">
<thead>
<tr>
<th width="10%">Item</th>
<th width="10%">Qtde</th>
<th>Descrição</th>
<th width="11%">Valor Unitário</th>
<th width="11%">Valor Total</th>
<th width="12%" class="text-center">Recebimento</th>
<th width="7%" class="text-center">Alterar</th>
</tr>
</thead>
<tbody>
<?php
$cont = 0;
while ($linhait = mysqli_fetch_array($resit)) {
$cont++;
if ($linhait[nu_valr] != 0) {
$vl_item = $linhait[nu_qtde] * $linhait[nu_valr];
} else {
$vl_item = 0;
}
$vl_totl = $vl_totl + $vl_item;
if ($linhait[dt_recb] == '00/00/0000') {
$linhait[dt_recb] = '';
}
?>
<tr>
<td><?php echo $cont;?></td>
<td><?php echo moeda($linhait[nu_qtde]);?></td>
<td><?php echo $linhait[de_item];?></td>
<td class="text-right"><?php echo moeda($linhait[nu_valr]);?></td>
<td class="text-right"><?php echo moeda($vl_item);?></td>
<td class="text-center"><?php echo $linhait[dt_recb];?></td>
<?php
if (($linhau[fl_solc] == 'P') // Compras
&& ($linha[id_sitc] != 7)) { // Cancelada
?>
<td class="text-center">
<a href="javascript:alt_item('<?php echo $linhait['id_item'] ?>')" class="btn btn-info btn-xs">
<i class="fa fa-pencil" aria-hidden="true"></i> Alterar
</a>
</td>
<?php
} else {
?>
<td class="text-center">
-
</td>
<?php
}
?>
</tr>
<?php
}
?>
</tbody>
<tfoot>
<tr>
<th class="text-right" colspan="4">Total</th>
<th class="text-right"><?php echo moeda($vl_totl);?></th>
<th></th>
<th></th>
</tr>
</tfoot>
</table>
</div>
</div>
</div>
</div>
<?php
if ($linha[id_forn] != '') {
if ($linha[dt_envi_solc] == '00/00/0000') {
$linha[dt_envi_solc] = '';
}
?>
<div class="x_content">
<div class="row">
<div class="col-xs-12 table">
<div class="x_title">
<h2>Fornecedor Selecionado <small>Gerenciador de Solicitação</small></h2>
<div class="clearfix"></div>
</div>
<div class="row">
<br />
<div class="col-sm-6 col-xs-12">
<div class="form-group" style="font-size: 16px;">
<p><b>Empresa:</b> <?php echo $linhafr[nm_forn];?></p>
<p><b>E-mail:</b> <?php echo $linhafr[de_mail];?></p>
<p><b>Telefone:</b> <?php echo $linhafr[nu_fone];?></p>
</div>
</div>
<div class="col-sm-6 col-xs-12">
<div class="form-group" style="font-size: 16px;">
<p><b>Contato:</b> <?php echo $linhafr[de_cont];?></p>
<p><b>Prazo de Entrega:</b> <?php echo $linha[de_praz];?></p>
<p><b>Data Envio Solicitação:</b> <?php echo $linha[dt_envi_solc];?></p>
</div>
</div>
<br />
</div>
</div>
</div>
</div>
<?php
}
?>
<?php
}
if ((($linhau[fl_solc] == 'P') // Compras
|| ($linhau[fl_solc] == 'D')) // Direção
&& ($linha[id_sitc] == 3)) { // Aprovação
?>
<div class="x_content">
<div class="row">
<div class="col-xs-12 table">
<br />
<div class="x_title">
<h2>Aprovação da Solicitação<small>Gerenciador de Solicitação</small></h2>
<div class="clearfix"></div>
</div>
<div class="x_content" id="mais">
<div class="row">
<div class="col-xs-12 table">
<div class="row">
<br />
<form id="demo-form2" data-parsley-validate class="form-horizontal form-label-left" action="<?php echo $this->site_root?>/index1.php?pg=sql_solc" method="POST" name="aprv_solc" id="aprv_solc">
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12">Origem do Recurso</label>
<div class="col-md-6 col-sm-6 col-xs-12">
<select name="id_recs_aprv" id="id_recs_aprv" class="form-control" onchange="javascript:ver_recs_aprv(this.value)">
<option value="">Selecione</option>
<?php
$sqlrec = "SELECT id_recs, de_recs ";
$sqlrec .= "FROM ".$pref_tabl."recs ";
$sqlrec .= "ORDER BY de_recs ";
$resrec = mysqli_query($conn, $sqlrec);
if (mysqli_num_rows($resrec) > 0) {
while ($linharec = mysqli_fetch_array($resrec)) {
?>
<option value="<?php echo $linharec['id_recs']?>"><?php echo $linharec['de_recs']?></option>
<?php
}
}
?>
</select>
<div id="dv_recs_aprv" style="display: none;">
<br><input type="text" name="de_recs_aprv" id="de_recs_aprv" class="form-control">
</div>
<div class="erro_alt_solc" id="erro_recs_aprv" style="display: none;">Este campo é obrigatório.</div>
</div>
</div>
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12">Observações</label>
<div class="col-md-6 col-sm-6 col-xs-12">
<textarea class="form-control" id="de_desc_aprv" name="de_desc_aprv" rows="3" placeholder="Digite sua observação"></textarea>
</div>
<div class="col-md-6 col-md-offset-3">
<div class="erro_alt_solc_apro" id="msg_erro_de_obsr" style="display:none">Este campo é obrigatório.</div>
</div>
</div>
<div class="form-group">
<div class="col-md-6 col-sm-6 col-xs-12 col-md-offset-3">
<button type="button" class="btn btn-success" onclick="javascript:ver_aprv();">Aprovar</button>
<button type="button" class="btn btn-danger" onclick="javascript:ver_rejt();">Recusado</button>
<input name="opc" type="hidden" id="opc" value="ins_aprv">
<input name="id_comp" type="hidden" id="id_comp" value="<?php echo $s_id_comp;?>">
<input type="hidden" name="v_id_tipo" id="v_id_tipo" value="<?=$_POST[v_id_tipo]?>">
<input type="hidden" name="v_id_forn" id="v_id_forn" value="<?=$_POST[v_id_forn]?>">
<input type="hidden" name="v_id_recs" id="v_id_recs" value="<?=$_POST[v_id_recs]?>">
<input type="hidden" name="v_id_sitc" id="v_id_sitc" value="<?=$_POST[v_id_sitc]?>">
<input type="hidden" name="v_id_user" id="v_id_user" value="<?=$_POST[v_id_user]?>">
<input type="hidden" name="v_dt_inic" id="v_dt_inic" value="<?=$_POST[v_dt_inic]?>">
<input type="hidden" name="v_dt_finl" id="v_dt_finl" value="<?=$_POST[v_dt_finl]?>">
</div>
</div>
</form>
<br />
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<?php
}
//if ($linhau[fl_solc] == 'P') { // Compras
if (($linhau[fl_solc] == 'P') // Compras
&& ($linha[id_sitc] != 7)) { // Cancelada
?>
<div class="x_title">
<h2>Funções Administrativas <small>Gerenciador de Funções Administrativas</small></h2>
<div class="clearfix"></div>
</div>
<div class="x_content">
<div class="row">
<br />
<?php
if (($linha[id_sitc] != 8) // Aguardando Recebimento
&& ($linha[id_sitc] != 9) // Recebimento Parcial
&& ($linha[id_sitc] != 10)) { // Aguardando Pagamento
?>
<form id="demo-form2" data-parsley-validate class="form-horizontal form-label-left" action="<?php echo $this->site_root?>/index1.php?pg=sql_solc" method="POST" name="form_tipo">
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12">Tipo de Solicitação <span class="required">*</span></label>
<div class="col-md-6 col-sm-6 col-xs-12">
<select name="id_tipo" id="id_tipo" class="form-control" required="required">
<option value="">Selecione</option>
<?php
$sqlp = "SELECT id_tipo, de_tipo ";
$sqlp .= "FROM ".$pref_tabl."solc_tipo ";
$sqlp .= "ORDER BY de_tipo ";
$resp = mysqli_query($conn, $sqlp);
if (mysqli_num_rows($resp) > 0) {
while ($linhap = mysqli_fetch_array($resp)) {
?>
<option value="<?php echo $linhap['id_tipo']?>"><?php echo $linhap['de_tipo']?></option>
<?php
}
}
?>
</select>
</div>
<div class="col-md-1 col-sm-1 col-xs-12 padd_botn_alt_solc">
<button type="submit" name="Submit" class="btn btn-primary btn-block ">
<strong>Alterar</strong>
</button>
<input name="opc" type="hidden" id="opc" value="alt_tipo">
<input name="id_comp" type="hidden" id="id_comp" value="<?php echo $s_id_comp;?>">
<input type="hidden" name="v_nu_oc" id="v_nu_oc" value="<?=$_POST[v_nu_oc]?>">
<input type="hidden" name="v_id_tipo" id="v_id_tipo" value="<?=$_POST[v_id_tipo]?>">
<input type="hidden" name="v_id_forn" id="v_id_forn" value="<?=$_POST[v_id_forn]?>">
<input type="hidden" name="v_id_recs" id="v_id_recs" value="<?=$_POST[v_id_recs]?>">
<input type="hidden" name="v_id_sitc" id="v_id_sitc" value="<?=$_POST[v_id_sitc]?>">
<input type="hidden" name="v_id_user" id="v_id_user" value="<?=$_POST[v_id_user]?>">
<input type="hidden" name="v_dt_inic" id="v_dt_inic" value="<?=$_POST[v_dt_inic]?>">
<input type="hidden" name="v_dt_finl" id="v_dt_finl" value="<?=$_POST[v_dt_finl]?>">
</div>
</div>
</form>
<form id="demo-form2" data-parsley-validate class="form-horizontal form-label-left" action="<?php echo $this->site_root?>/index1.php?pg=sql_solc" method="POST" name="form_recs">
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12">Origem do Recurso <span class="required">*</span></label>
<div class="col-md-6 col-sm-6 col-xs-12">
<select name="id_recs" id="id_recs" class="form-control" required="required" onchange="javascript:ver_recs(this.value)">
<option value="">Selecione</option>
<?php
$sqlrec = "SELECT id_recs, de_recs ";
$sqlrec .= "FROM ".$pref_tabl."recs ";
$sqlrec .= "ORDER BY de_recs ";
$resrec = mysqli_query($conn, $sqlrec);
if (mysqli_num_rows($resrec) > 0) {
while ($linharec = mysqli_fetch_array($resrec)) {
?>
<option value="<?php echo $linharec['id_recs']?>"><?php echo $linharec['de_recs']?></option>
<?php
}
}
?>
</select>
<div id="dv_recs" style="display: none;">
<br><input type="text" name="de_recs_outr" id="de_recs_outr" class="form-control">
</div>
</div>
<div class="col-md-1 col-sm-1 col-xs-12 padd_botn_alt_solc">
<button type="submit" name="Submit" class="btn btn-primary btn-block">
<strong>Alterar</strong>
</button>
<input name="opc" type="hidden" id="opc" value="alt_recs">
<input name="id_comp" type="hidden" id="id_comp" value="<?php echo $s_id_comp;?>">
<input type="hidden" name="v_nu_oc" id="v_nu_oc" value="<?=$_POST[v_nu_oc]?>">
<input type="hidden" name="v_id_tipo" id="v_id_tipo" value="<?=$_POST[v_id_tipo]?>">
<input type="hidden" name="v_id_forn" id="v_id_forn" value="<?=$_POST[v_id_forn]?>">
<input type="hidden" name="v_id_recs" id="v_id_recs" value="<?=$_POST[v_id_recs]?>">
<input type="hidden" name="v_id_sitc" id="v_id_sitc" value="<?=$_POST[v_id_sitc]?>">
<input type="hidden" name="v_id_user" id="v_id_user" value="<?=$_POST[v_id_user]?>">
<input type="hidden" name="v_dt_inic" id="v_dt_inic" value="<?=$_POST[v_dt_inic]?>">
<input type="hidden" name="v_dt_finl" id="v_dt_finl" value="<?=$_POST[v_dt_finl]?>">
</div>
</div>
</form>
<?php
}
if (($linha[id_sitc] == 1)
|| ($linha[id_sitc] == 2)
|| ($linha[id_sitc] == 4)
|| ($linha[id_sitc] == 5)
|| ($linha[id_sitc] == 6)
|| ($linha[id_sitc] == 8)
|| ($linha[id_sitc] == 9)
|| ($linha[id_sitc] == 10)) {
?>
<form id="demo-form2" data-parsley-validate class="form-horizontal form-label-left" action="<?php echo $this->site_root?>/index1.php?pg=sql_solc" method="POST" name="">
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12">Situação <span class="required">*</span></label>
<div class="col-md-6 col-sm-6 col-xs-12">
<select name="id_sitc" id="id_sitc" class="form-control" required="required">
<option value="">Selecione</option>
<?php
if ($linha[id_sitc] == 1) {
$selsitc = "AND id_sitc IN (2,7,3) ";
}
if (($linha[id_sitc] == 2)
|| ($linha[id_sitc] == 4)) {
$selsitc = "AND id_sitc = 3 ";
}
if ($linha[id_sitc] == 5) {
$selsitc = "AND id_sitc IN (6,7) ";
}
if ($linha[id_sitc] == 6) {
$selsitc = "AND id_sitc IN (8) ";
}
if ($linha[id_sitc] == 8) {
$selsitc = "AND id_sitc IN (9,10,6,7) ";
}
if ($linha[id_sitc] == 9) {
$selsitc = "AND id_sitc IN (8,10,6,7) ";
}
if ($linha[id_sitc] == 10) {
$selsitc = "AND id_sitc IN (8,9,6,7) ";
}
$sqlst = "SELECT id_sitc, de_sitc ";
$sqlst .= "FROM ".$pref_tabl."sitc ";
$sqlst .= "WHERE id_sitc = id_sitc ";
$sqlst .= "$selsitc ";
$sqlst .= "ORDER BY de_sitc ";
$resst = mysqli_query($conn, $sqlst);
if (mysqli_num_rows($resst) > 0) {
while ($linhast = mysqli_fetch_array($resst)) {
?>
<option value="<?php echo $linhast['id_sitc']?>"><?php echo $linhast['de_sitc']?></option>
<?php
}
}
?>
</select>
</div>
<div class="col-md-1 col-sm-1 col-xs-12 padd_botn_alt_solc">
<button type="submit" name="Submit" class="btn btn-primary btn-block">
<strong>Alterar</strong>
</button>
<input name="opc" type="hidden" id="opc" value="alt_sitc">
<input name="id_comp" type="hidden" id="id_comp" value="<?php echo $s_id_comp;?>">
<input type="hidden" name="v_nu_oc" id="v_nu_oc" value="<?=$_POST[v_nu_oc]?>">
<input type="hidden" name="v_id_tipo" id="v_id_tipo" value="<?=$_POST[v_id_tipo]?>">
<input type="hidden" name="v_id_forn" id="v_id_forn" value="<?=$_POST[v_id_forn]?>">
<input type="hidden" name="v_id_recs" id="v_id_recs" value="<?=$_POST[v_id_recs]?>">
<input type="hidden" name="v_id_sitc" id="v_id_sitc" value="<?=$_POST[v_id_sitc]?>">
<input type="hidden" name="v_id_user" id="v_id_user" value="<?=$_POST[v_id_user]?>">
<input type="hidden" name="v_dt_inic" id="v_dt_inic" value="<?=$_POST[v_dt_inic]?>">
<input type="hidden" name="v_dt_finl" id="v_dt_finl" value="<?=$_POST[v_dt_finl]?>">
</div>
</div>
</form>
<?php
}
if (($linha[id_sitc] != 8) // Aguardando Recebimento
&& ($linha[id_sitc] != 9) // Recebimento Parcial
&& ($linha[id_sitc] != 10)) { // Aguardando Pagamento
?>
<form id="demo-form2" data-parsley-validate class="form-horizontal form-label-left" action="<?php echo $this->site_root?>/index1.php?pg=sql_solc" method="POST" name="form_resp">
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12">Responsável <span class="required">*</span></label>
<div class="col-md-6 col-sm-6 col-xs-12">
<select name="id_resp" id="id_resp" class="form-control" required="required">
<option value="">Selecione</option>
<?php
$sqlst = "SELECT id_user, nm_user ";
$sqlst .= "FROM ".$pref_tabl."user ";
$sqlst .= "WHERE fl_atvo = 'S' ";
$sqlst .= "AND fl_solc = 'P' ";
$sqlst .= "ORDER BY nm_user ";
$resst = mysqli_query($conn, $sqlst);
if (mysqli_num_rows($resst) > 0) {
while ($linhast = mysqli_fetch_array($resst)) {
?>
<option value="<?php echo $linhast['id_user']?>"><?php echo $linhast['nm_user']?></option>
<?php
}
}
?>
</select>
</div>
<div class="col-md-1 col-sm-1 col-xs-12 padd_botn_alt_solc">
<button type="submit" name="Submit" class="btn btn-primary btn-block">
<strong>Alterar</strong>
</button>
<input name="opc" type="hidden" id="opc" value="alt_resp">
<input name="id_comp" type="hidden" id="id_comp" value="<?php echo $s_id_comp;?>">
<input type="hidden" name="v_nu_oc" id="v_nu_oc" value="<?=$_POST[v_nu_oc]?>">
<input type="hidden" name="v_id_tipo" id="v_id_tipo" value="<?=$_POST[v_id_tipo]?>">
<input type="hidden" name="v_id_forn" id="v_id_forn" value="<?=$_POST[v_id_forn]?>">
<input type="hidden" name="v_id_recs" id="v_id_recs" value="<?=$_POST[v_id_recs]?>">
<input type="hidden" name="v_id_sitc" id="v_id_sitc" value="<?=$_POST[v_id_sitc]?>">
<input type="hidden" name="v_id_user" id="v_id_user" value="<?=$_POST[v_id_user]?>">
<input type="hidden" name="v_dt_inic" id="v_dt_inic" value="<?=$_POST[v_dt_inic]?>">
<input type="hidden" name="v_dt_finl" id="v_dt_finl" value="<?=$_POST[v_dt_finl]?>">
</div>
</div>
</form>
<form id="demo-form2" data-parsley-validate class="form-horizontal form-label-left" action="<?php echo $this->site_root?>/index1.php?pg=sql_solc" method="POST" name="form_praz">
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12">Prazo de Entrega <span class="required">*</span></label>
<div class="col-md-6 col-sm-6 col-xs-12">
<input class="form-control" id="de_praz" name="de_praz" maxlength="50" required="required">
</div>
<div class="col-md-1 col-sm-1 col-xs-12 padd_botn_alt_solc">
<button type="submit" name="Submit" class="btn btn-primary btn-block">
<strong>Alterar</strong>
</button>
<input name="opc" type="hidden" id="opc" value="alt_praz">
<input name="id_comp" type="hidden" id="id_comp" value="<?php echo $s_id_comp;?>">
<input type="hidden" name="v_nu_oc" id="v_nu_oc" value="<?=$_POST[v_nu_oc]?>">
<input type="hidden" name="v_id_tipo" id="v_id_tipo" value="<?=$_POST[v_id_tipo]?>">
<input type="hidden" name="v_id_forn" id="v_id_forn" value="<?=$_POST[v_id_forn]?>">
<input type="hidden" name="v_id_recs" id="v_id_recs" value="<?=$_POST[v_id_recs]?>">
<input type="hidden" name="v_id_sitc" id="v_id_sitc" value="<?=$_POST[v_id_sitc]?>">
<input type="hidden" name="v_id_user" id="v_id_user" value="<?=$_POST[v_id_user]?>">
<input type="hidden" name="v_dt_inic" id="v_dt_inic" value="<?=$_POST[v_dt_inic]?>">
<input type="hidden" name="v_dt_finl" id="v_dt_finl" value="<?=$_POST[v_dt_finl]?>">
</div>
</div>
</form>
<form id="demo-form2" data-parsley-validate class="form-horizontal form-label-left" action="<?php echo $this->site_root?>/index1.php?pg=sql_solc" method="POST" name="form_forn">
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12">Fornecedores <span class="required">*</span></label>
<div class="col-md-6 col-sm-6 col-xs-12">
<select name="id_forn" id="id_forn" class="form-control" required="required">
<option value="">Selecione</option>
<?php
$sqlff = "SELECT id_forn, nm_forn ";
$sqlff .= "FROM ".$pref_tabl."forn ";
$sqlff .= "ORDER BY nm_forn ";
$resff = mysqli_query($conn, $sqlff);
if (mysqli_num_rows($resff) > 0) {
while ($linhaff = mysqli_fetch_array($resff)) {
?>
<option value="<?php echo $linhaff['id_forn']?>"><?php echo $linhaff['nm_forn']?></option>
<?php
}
}
?>
</select>
</div>
<div class="col-md-1 col-sm-1 col-xs-12 padd_botn_alt_solc">
<button type="submit" name="Submit" class="btn btn-primary btn-block">
<strong>Alterar</strong>
</button>
<input name="opc" type="hidden" id="opc" value="alt_forn">
<input name="id_comp" type="hidden" id="id_comp" value="<?php echo $s_id_comp;?>">
<input type="hidden" name="v_nu_oc" id="v_nu_oc" value="<?=$_POST[v_nu_oc]?>">
<input type="hidden" name="v_id_tipo" id="v_id_tipo" value="<?=$_POST[v_id_tipo]?>">
<input type="hidden" name="v_id_forn" id="v_id_forn" value="<?=$_POST[v_id_forn]?>">
<input type="hidden" name="v_id_recs" id="v_id_recs" value="<?=$_POST[v_id_recs]?>">
<input type="hidden" name="v_id_sitc" id="v_id_sitc" value="<?=$_POST[v_id_sitc]?>">
<input type="hidden" name="v_id_user" id="v_id_user" value="<?=$_POST[v_id_user]?>">
<input type="hidden" name="v_dt_inic" id="v_dt_inic" value="<?=$_POST[v_dt_inic]?>">
<input type="hidden" name="v_dt_finl" id="v_dt_finl" value="<?=$_POST[v_dt_finl]?>">
</div>
</div>
</form>
<form id="demo-form2" data-parsley-validate class="form-horizontal form-label-left" action="<?php echo $this->site_root?>/index1.php?pg=sql_solc" method="POST" name="form_venc">
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12">Data de Vencimento do Boleto <span class="required">*</span></label>
<div class="col-md-6 col-sm-6 col-xs-12">
<div class='input-group date' id='myDatepicker2'>
<input type='text' class="form-control" id="dt_venc" name="dt_venc" required="required" />
<span class="input-group-addon">
<span class="glyphicon glyphicon-calendar"></span>
</span>
</div>
</div>
<div class="col-md-1 col-sm-1 col-xs-12 padd_botn_alt_solc">
<button type="submit" name="Submit" class="btn btn-primary btn-block">
<strong>Alterar</strong>
</button>
<input name="opc" type="hidden" id="opc" value="alt_venc">
<input name="id_comp" type="hidden" id="id_comp" value="<?php echo $s_id_comp;?>">
<input type="hidden" name="v_nu_oc" id="v_nu_oc" value="<?=$_POST[v_nu_oc]?>">
<input type="hidden" name="v_id_tipo" id="v_id_tipo" value="<?=$_POST[v_id_tipo]?>">
<input type="hidden" name="v_id_forn" id="v_id_forn" value="<?=$_POST[v_id_forn]?>">
<input type="hidden" name="v_id_recs" id="v_id_recs" value="<?=$_POST[v_id_recs]?>">
<input type="hidden" name="v_id_sitc" id="v_id_sitc" value="<?=$_POST[v_id_sitc]?>">
<input type="hidden" name="v_id_user" id="v_id_user" value="<?=$_POST[v_id_user]?>">
<input type="hidden" name="v_dt_inic" id="v_dt_inic" value="<?=$_POST[v_dt_inic]?>">
<input type="hidden" name="v_dt_finl" id="v_dt_finl" value="<?=$_POST[v_dt_finl]?>">
</div>
</div>
</form>
<form id="demo-form2" data-parsley-validate class="form-horizontal form-label-left" action="<?php echo $this->site_root?>/index1.php?pg=sql_solc" method="POST" name="form_pagm">
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12">Formas de Pagamento <span class="required">*</span></label>
<div class="col-md-6 col-sm-6 col-xs-12">
<select name="id_pagm" id="id_pagm" class="form-control" required="required">
<option value="">Selecione</option>
<?php
$sqlpg = "SELECT id_pagm, de_pagm ";
$sqlpg .= "FROM ".$pref_tabl."solc_pagm ";
$sqlpg .= "ORDER BY de_pagm ";
$respg = mysqli_query($conn, $sqlpg);
if (mysqli_num_rows($respg) > 0) {
while ($linhapg = mysqli_fetch_array($respg)) {
?>
<option value="<?php echo $linhapg['id_pagm']?>"><?php echo $linhapg['de_pagm']?></option>
<?php
}
}
?>
</select>
</div>
<div class="col-md-1 col-sm-1 col-xs-12 padd_botn_alt_solc">
<button type="submit" name="Submit" class="btn btn-primary btn-block">
<strong>Alterar</strong>
</button>
<input type="hidden" name="opc" id="opc" value="alt_pagm">
<input type="hidden" name="id_comp" id="id_comp" value="<?php echo $s_id_comp;?>">
<input type="hidden" name="v_nu_oc" id="v_nu_oc" value="<?=$_POST[v_nu_oc]?>">
<input type="hidden" name="v_id_tipo" id="v_id_tipo" value="<?=$_POST[v_id_tipo]?>">
<input type="hidden" name="v_id_forn" id="v_id_forn" value="<?=$_POST[v_id_forn]?>">
<input type="hidden" name="v_id_recs" id="v_id_recs" value="<?=$_POST[v_id_recs]?>">
<input type="hidden" name="v_id_sitc" id="v_id_sitc" value="<?=$_POST[v_id_sitc]?>">
<input type="hidden" name="v_id_user" id="v_id_user" value="<?=$_POST[v_id_user]?>">
<input type="hidden" name="v_dt_inic" id="v_dt_inic" value="<?=$_POST[v_dt_inic]?>">
<input type="hidden" name="v_dt_finl" id="v_dt_finl" value="<?=$_POST[v_dt_finl]?>">
</div>
</div>
</form>
<br />
</div>
</div>
<?php
if (($linha[id_recs] != '')
&& ($linha[id_forn] != '')
&& ($linha[id_sitc] == 5) // Aprovada
&& ($linhafr[de_mail] != '')) {
?>
<div class="x_content">
<div class="x_title">
<h2>E-mail p/ Fornecedor <small>Envio de E-mail p/ Fornecedor</small></h2>
<div class="clearfix"></div>
</div>
<div class="row">
<br />
<form id="demo-form2" data-parsley-validate class="form-horizontal form-label-left" action="<?php echo $this->site_root?>/index1.php?pg=sql_solc" method="POST" name="form_emai">
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12">Nome do Destinatário<span class="required">*</span>:</label>
<div class="col-md-6 col-sm-6 col-xs-12">
<input class="form-control" id="nm_forn" name="nm_forn" maxlength="80" required="required">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12">E-mail do Destinatário<span class="required">*</span>:</label>
<div class="col-md-6 col-sm-6 col-xs-12">
<input class="form-control" id="de_mail_forn" name="de_mail_forn" maxlength="80" required="required">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12">Corpo do E-mail <span class="required">*</span></label>
<div class="col-md-6 col-sm-6 col-xs-12">
<textarea class="form-control" id="de_desc_mail" name="de_desc_mail" rows="8" required><?php echo $linhare[de_desc];?></textarea>
</div>
</div>
<div class="form-group">
<div class="col-md-3 col-sm-3 col-xs-12"> </div>
<div class="col-md-6 col-sm-6 col-xs-12">
<button type="submit" name="Submit" class="btn btn-primary">
<strong>Enviar para o Fornecedor</strong>
</button>
<input type="hidden" name="opc" id="opc" value="env_emai">
<input type="hidden" name="id_comp" id="id_comp" value="<?php echo $s_id_comp;?>">
<input type="hidden" name="v_nu_oc" id="v_nu_oc" value="<?=$_POST[v_nu_oc]?>">
<input type="hidden" name="v_id_tipo" id="v_id_tipo" value="<?=$_POST[v_id_tipo]?>">
<input type="hidden" name="v_id_forn" id="v_id_forn" value="<?=$_POST[v_id_forn]?>">
<input type="hidden" name="v_id_recs" id="v_id_recs" value="<?=$_POST[v_id_recs]?>">
<input type="hidden" name="v_id_sitc" id="v_id_sitc" value="<?=$_POST[v_id_sitc]?>">
<input type="hidden" name="v_id_user" id="v_id_user" value="<?=$_POST[v_id_user]?>">
<input type="hidden" name="v_dt_inic" id="v_dt_inic" value="<?=$_POST[v_dt_inic]?>">
<input type="hidden" name="v_dt_finl" id="v_dt_finl" value="<?=$_POST[v_dt_finl]?>">
</div>
</div>
</form>
<br />
</div>
</div>
<?php
}
}
}
?>
<?php
if ($linha[id_sitc] != 7) { // Cancelada
?>
<div class="x_content">
<div class="x_title">
<h2>Anexo da Solicitação <small>Gerenciador de Anexo da Solicitação</small></h2>
<div class="clearfix"></div>
</div>
<div class="row">
<br />
<form id="demo-form2" data-parsley-validate class="form-horizontal form-label-left" action="<?php echo $this->site_root?>/index1.php?pg=sql_solc" enctype="multipart/form-data" method="POST" name="form_arqv">
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12">Título <span class="required">*</span></label>
<div class="col-md-6 col-sm-6 col-xs-12">
<input type="text" id="de_arqv" name="de_arqv" required="required" class="form-control col-md-7 col-xs-12" maxlength="100">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12">Arquivo <span class="required">*</span></label>
<div class="col-md-6 col-sm-6 col-xs-12">
<input type="file" id="nm_arqv" name="nm_arqv" required="required" class="form-control col-md-7 col-xs-12">
</div>
</div>
<div class="form-group">
<div class="col-md-6 col-sm-6 col-xs-12 col-md-offset-3">
<button type="submit" class="btn btn-success">Inserir</button>
<input name="opc" type="hidden" id="opc" value="alt_anex">
<input name="id_comp" type="hidden" id="id_comp" value="<?php echo $s_id_comp;?>">
<input name="passa" type="hidden" id="passa" value="yes">
</div>
</div>
</form>
<br />
</div>
</div>
<?php
}
$sqlar = "SELECT * ";
$sqlar .= "FROM ".$pref_tabl."anex ";
$sqlar .= "WHERE id_comp = $s_id_comp ";
$sqlar .= "ORDER BY id_anex ";
#echo $sqlit.'<br>';
$resar = mysqli_query($conn, $sqlar);
if (mysqli_num_rows($resar) > 0) {
?>
<div class="row">
<div class="col-xs-12 table">
<table class="table table-striped table-relt-peri">
<thead>
<tr>
<th>Título</th>
<th class="text-center" width="20%">Ver</th>
<th class="text-center" width="20%">Excluir</th>
</tr>
</thead>
<tbody>
<?php
$cont = 0;
while ($linhaar = mysqli_fetch_array($resar)) {
$cont++;
?>
<tr>
<td><?php echo $linhaar[de_arqv];?></td>
<td class="text-center"><a href="<?php echo $this->site_root;?>/arqv/<?php echo $linhaar[nm_arqv];?>" target="_blank"><i class="fa fa-file-pdf-o"></i></a></td>
<?php
if ($linhau[fl_solc] == 'P') { // Compras
?>
<td class="text-center"><a href="javascript:exc_anex(<?php echo $linhaar[id_anex];?>);"><i class="fa fa-trash"></i></a></td>
<?php
} else {
?>
<td class="text-center">-</td>
<?php
}
?>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
</div>
<?php
}
?>
<div class="x_title">
<h2>Observações <small>Gerenciador de Funções Administrativas</small></h2>
<div class="clearfix"></div>
</div>
<?php
if ($linha[id_sitc] != 7) { // Cancelada
?>
<div class="x_content">
<div class="row">
<form id="demo-form2" data-parsley-validate class="form-horizontal form-label-left" action="<?php echo $this->site_root?>/index1.php?pg=sql_solc" enctype="multipart/form-data" method="POST" name="obsrsolc">
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12">Observações <span class="required">*</span></label>
<div class="col-md-6 col-sm-6 col-xs-12">
<textarea class="form-control" id="de_desc" name="de_desc" rows="3" placeholder="Digite sua observação" required="required"></textarea>
</div>
</div>
<div class="form-group">
<div class="col-md-6 col-sm-6 col-xs-12 col-md-offset-3">
<button type="submit" class="btn btn-success">Enviar</button>
<input name="opc" type="hidden" id="opc" value="ins_desc">
<input name="id_comp" type="hidden" id="id_comp" value="<?php echo $s_id_comp;?>">
</div>
</div>
</form>
</div>
</div>
<?php
}
$sqld = "SELECT d.*, u.nm_user, ";
$sqld .= "DATE_FORMAT(d.dt_cads, '%H:%i do dia %d/%m/%Y') as dt_cads ";
$sqld .= "FROM ".$pref_tabl."desc d, ".$pref_tabl."user u ";
$sqld .= "WHERE d.id_cads = u.id_user ";
$sqld .= "AND d.id_comp = $s_id_comp ";
$sqld.= "ORDER BY d.id_desc ";
#echo $sqld.'<br>';
$resd = mysqli_query($conn, $sqld);
if (mysqli_num_rows($resd) > 0) {
?>
<div class="x_content">
<div class="row">
<div class="col-xs-12 table">
<table class="table table-striped">
<thead>
<tr>
<th>Observações</th>
<th width="20%" class="text-center">Cadastrado por</th>
</tr>
</thead>
<tbody>
<?php
$cont = 0;
while ($linhad = mysqli_fetch_array($resd)) {
$cont++;
$linhad[de_desc] = str_replace("'\'",'',$linhad[de_desc]);
$linhad[de_desc] = nl2br($linhad[de_desc]);
?>
<tr>
<td><?php echo $linhad[de_desc];?></td>
<td class="text-center"><?php echo $linhad[nm_user];?><br><?php echo $linhad[dt_cads];?></td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
</div>
</div>
<?php
}
?>
<div class="x_title">
<h2>Cadastro de Agenda de Pagamento <small>Gerenciador de Agenda de Pagamento</small></h2>
<a name="dv_pagm"></a>
<div class="clearfix"></div>
</div>
<div class="x_content">
<br />
<form id="demo-form2" data-parsley-validate class="form-horizontal form-label-left" action="<?php echo $this->site_root?>/index1.php?pg=sql_solc" enctype="multipart/form-data" method="POST" name="tstest">
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name">Tipo de Pagamento <span class="required">*</span>
</label>
<div class="col-md-3 col-sm-6 col-xs-12">
<select name="id_tipo_pagm" id="id_tipo_pagm" class="form-control" required>
<option value="">Selecione</option>
<?php
$sqldp = "SELECT id_tipo_pagm, de_tipo_pagm ";
$sqldp .= "FROM ".$pref_tabl."tipo_pagm ";
$sqldp .= "WHERE fl_atvo = 'S' ";
$sqldp .= "ORDER BY de_tipo_pagm ";
$resdp = mysqli_query($conn, $sqldp);
if (mysqli_num_rows($resdp) > 0) {
while ($linhadp = mysqli_fetch_array($resdp)) {
?>
<option value="<?=$linhadp[id_tipo_pagm]?>"><?=$linhadp[de_tipo_pagm]?></option>
<?php
}
}
?>
</select>
</div>
</div>
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name">Título <span class="required">*</span>
</label>
<div class="col-md-6 col-sm-6 col-xs-12">
<input type="text" id="de_titl" name="de_titl" required="required" class="form-control col-md-7 col-xs-12" maxlength="100">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12">Descrição <span class="required">*</span></label>
<div class="col-md-6 col-sm-6 col-xs-12">
<textarea class="form-control" id="de_agnd" name="de_agnd" rows="3" placeholder="Digite sua descrição" required></textarea>
</div>
</div>
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name">Data Prevista</label>
<div class='col-lg-2 col-md-3 col-sm-3 col-xs-12'>
<div class="form-group">
<div class='input-group date' id='myDatepicker5'>
<input name="dt_agnd" type="text" id="dt_agnd" class="form-control" />
<span class="input-group-addon">
<span class="glyphicon glyphicon-calendar"></span>
</span>
</div>
</div>
</div>
</div>
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name">Valor</label>
<div class="col-md-2 col-sm-6 col-xs-12">
<input type="text" id="vl_agnd" name="vl_agnd" class="form-control col-md-7 col-xs-12" maxlength="10">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12">Observação</label>
<div class="col-md-6 col-sm-6 col-xs-12">
<textarea class="form-control" id="de_obsr" name="de_obsr" rows="3" placeholder="Digite sua observação"></textarea>
</div>
</div>
<div class="form-group">
<div class="col-md-6 col-sm-6 col-xs-12 col-md-offset-3">
<button type="submit" class="btn btn-success">Cadastrar</button>
<input name="opc" type="hidden" id="opc" value="ins_agnd_pagm">
<input name="id_comp" type="hidden" id="id_comp" value="<?php echo $s_id_comp;?>">
<input name="passa" type="hidden" id="passa" value="yes">
</div>
</div>
</form>
</div>
<?php
$sqlar = "SELECT a.*, t.id_tipo_pagm, t.de_tipo_pagm, ";
$sqlar .= "DATE_FORMAT(a.dt_agnd, '%d/%m/%Y') as dt_agn2, ";
$sqlar .= "DATE_FORMAT(a.dt_pagm, '%d/%m/%Y') as dt_pag2 ";
$sqlar .= "FROM ".$pref_tabl."agnd_pagm a, ".$pref_tabl."tipo_pagm t ";
$sqlar .= "WHERE t.id_tipo_pagm = a.id_tipo_pagm ";
$sqlar .= "AND id_comp = $s_id_comp ";
$sqlar .= "ORDER BY a.dt_agnd ";
#echo $sqlar.'<br>';
$resar = mysqli_query($conn, $sqlar);
if (mysqli_num_rows($resar) > 0) {
?>
<div class="row">
<div class="col-xs-12 table">
<table class="table table-striped">
<thead>
<tr>
<th>Tipo de Pagamento</th>
<th>Título</th>
<th>Descrição</th>
<th>Valor</th>
<th class="text-center">Data Prevista</th>
<th class="text-center">Data Pagamento</th>
<th width="10%" class="text-center">Alterar</th>
</tr>
</thead>
<tbody>
<?php
$cont = 0;
while ($linhaar = mysqli_fetch_array($resar)) {
$cont++;
if ($linhaar[dt_pag2] == '00/00/0000') {
$linhaar[dt_pag2] = '';
}
?>
<tr>
<td><?php echo $linhaar[de_tipo_pagm];?></td>
<td><?php echo $linhaar[de_titl];?></td>
<td><?php echo $linhaar[de_agnd];?></td>
<td>R$ <?php echo moeda ($linhaar[vl_agnd]);?></td>
<td class="text-center"><?php echo $linhaar[dt_agn2];?></td>
<td class="text-center"><?php echo $linhaar[dt_pag2];?></td>
<td class="text-center">
<a href="javascript:alt_agnd_pagm('<?php echo $linhaar['id_agnd_pagm'] ?>')" class="btn btn-info btn-xs">
<i class="fa fa-pencil" aria-hidden="true"></i> Alterar
</a>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
</div>
<?php
}
?>
</div>
</div>
</div>
</div>
<script language="javascript">
function alt_item(xb){
document.acidente.action = "index1.php?pg=alt_solc_item";
document.acidente.id_item.value = xb;
document.acidente.submit();
}
function alt_agnd_pagm(xb){
document.acidente.action = "index1.php?pg=alt_agnd_pagm";
document.acidente.id_agnd_pagm.value = xb;
document.acidente.submit();
}
<?php
if ($linhau[fl_solc] == 'P') { // Compras
?>
function exc_anex(xb) {
if (confirm('Tem certeza que deseja excluir o anexo?')) {
document.acidente.action = "index1.php?pg=sql_solc";
document.acidente.opc.value = 'exc_anex';
document.acidente.id_anex.value = xb;
document.acidente.submit();
}
}
<?php
}
?>
function ver_mais() {
$('#mais').slideToggle();
}
$('#myDatepicker2').datetimepicker({
format: 'DD/MM/YYYY',
locale:'pt-br'
});
function ver_recs(valr) {
if (valr == '10') {
$("#dv_recs").slideDown();
} else {
$("#dv_recs").slideUp();
}
}
function ver_recs_aprv(valr) {
if (valr != '') {
$('#id_recs_aprv').removeClass('erro_alt_solc');
$('#erro_recs_aprv').hide();
if (valr == '10') {
$("#dv_recs_aprv").slideDown();
} else {
$("#dv_recs_aprv").slideUp();
}
}
}
function ver_aprv() {
var selc = $("#id_recs_aprv option:selected").val();
var outr = $("#de_recs_aprv").val();
if (selc == '') {
$('#id_recs_aprv').addClass('erro_alt_solc');
$('#erro_recs_aprv').show();
$('#msg_erro_de_obsr').hide();
$('#de_desc_aprv').removeClass('erro_alt_solc_apro');
} else {
$('#erro_recs_aprv').hide();
if (selc == 10) {
if (outr == '') {
$('#de_recs_aprv').addClass('erro_alt_solc');
$('#erro_recs_aprv').show();
} else {
document.aprv_solc.submit();
}
} else {
document.aprv_solc.submit();
}
}
}
function ver_rejt() {
var obsr = $('#de_desc_aprv').val();
obsr = obsr.trim();
if (obsr == "") {
$('#msg_erro_de_obsr').show();
$('#de_desc_aprv').addClass('erro_alt_solc_apro');
$('#id_recs_aprv').removeClass('erro_alt_solc');
$('#erro_recs_aprv').hide();
} else {
if (confirm('Tem certeza que deseja recusar a solicitação?')) {
document.aprv_solc.opc.value = 'ins_rejt';
document.aprv_solc.submit();
}
}
}
function ver_forn() {
if (confirm('Tem certeza que deseja enviar a solicitação para o fornecedor?')) {
document.acidente.action = "index1.php?pg=sql_solc";
document.acidente.opc.value = 'env_emai';
document.acidente.submit();
}
}
function voltar() {
document.acidente.action = "index1.php?pg=res_solc";
document.acidente.submit();
}
$('#myDatepicker5').datetimepicker({
format: 'DD/MM/YYYY',
locale:'pt-br'
});
</script>
<form name="acidente" method="post" action="" style="margin:0px !important;">
<input type="hidden" name="opc" id="opc">
<input name="id_comp" type="hidden" id="id_comp" value="<?php echo $s_id_comp;?>">
<input type="hidden" name="v_nu_oc" id="v_nu_oc" value="<?=$_POST[v_nu_oc]?>">
<input type="hidden" name="v_id_tipo" id="v_id_tipo" value="<?=$_POST[v_id_tipo]?>">
<input type="hidden" name="v_id_forn" id="v_id_forn" value="<?=$_POST[v_id_forn]?>">
<input type="hidden" name="v_id_recs" id="v_id_recs" value="<?=$_POST[v_id_recs]?>">
<input type="hidden" name="v_id_sitc" id="v_id_sitc" value="<?=$_POST[v_id_sitc]?>">
<input type="hidden" name="v_id_user" id="v_id_user" value="<?=$_POST[v_id_user]?>">
<input type="hidden" name="v_dt_inic" id="v_dt_inic" value="<?=$_POST[v_dt_inic]?>">
<input type="hidden" name="v_dt_finl" id="v_dt_finl" value="<?=$_POST[v_dt_finl]?>">
<input name="id_item" type="hidden" id="id_item">
<input name="id_anex" type="hidden" id="id_anex">
<input name="id_agnd_pagm" type="hidden" id="id_agnd_pagm">
<input type="hidden" name="passa" id="passa" value="yes">
</form>
<?
}
} else
require "erro.php";
?>
Back to Directory
File Manager