File Manager

Editing File: /home/cienp/public_html/portal/alt_agnd_pagm.php

<?
    if ($_POST[passa] == 'yes') {
            
	require "$this->include_dir/conecta.php";
	
	$s_id_agnd_pagm = protecao($_POST[id_agnd_pagm],'inteiro');

$sql  = "SELECT a.*, ";
    $sql .= "DATE_FORMAT(a.dt_agnd, '%d/%m/%Y') as dt_agnd, ";
    $sql .= "DATE_FORMAT(a.dt_pagm, '%d/%m/%Y') as dt_pagm ";
	$sql .= "FROM ".$pref_tabl."agnd_pagm a ";
	$sql .= "WHERE a.id_agnd_pagm = $s_id_agnd_pagm ";
	$sql .= "LIMIT 1 ";
	$res = mysqli_query($conn, $sql);
	if (mysqli_num_rows($res) > 0) {
		$linha = mysqli_fetch_array($res);
	
        $qatvo = $linha['fl_atvo'];
        $selatvo[$qatvo] = "checked";
        
?>

<div class="right_col" role="main">
    <div class="clearfix"></div>
    <div class="row">
        <div class="col-md-12 col-sm-12 col-xs-12">
            <div class="x_panel">
                <div class="x_title">
                    <h2>Alteração de Agenda de Pagamento <small>Gerenciador de Agenda de Pagamento</small></h2>
                    <div class="clearfix"></div>
                </div>
                <div class="form-group">
<?php
                if ($_GET[certo] == 'S') {
                    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>Alteração de Agenda de Pagamento!</strong> Sua agenda foi alterada 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>Alteração de Agenda de Pagamento!</strong> Erro ao efetuar a operação. Entre em contato com o administrador.
                         </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>Alteração de Agenda de Pagamento!</strong> O anexo foi inserido com sucesso.
                    </div>";
                }
                if ($_GET[certo] == 'X') {
                    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> O anexo foi excluído com sucesso.
                            </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_agnd_pagm" 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-6 col-sm-6 col-xs-12">
                            <select name="id_tipo_pagm" id="id_tipo_pagm" class="form-control">
                                <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)) {
                                    $selmarc = '';
                                    if ($linha[id_tipo_pagm] == $linhadp[id_tipo_pagm])
                                        $selmarc = 'selected';
?>
                                <option value="<?=$linhadp[id_tipo_pagm]?>" <?=$selmarc?>><?=$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" value="<?=$linha['de_titl']?>">
                        </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><?=$linha['de_agnd']?></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='myDatepicker2'>
                                    <input name="dt_agnd" type="text" id="dt_agnd" class="form-control" value="<?=$linha['dt_agnd']?>"/>
                                    <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">Data Pagamento</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='myDatepicker3'>
                                    <input name="dt_pagm" type="text" id="dt_pagm" class="form-control" value="<?=$linha['dt_pagm']?>"/>
                                    <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" required="required" class="form-control col-md-7 col-xs-12" maxlength="100" value="<?php echo moeda ($linha['vl_agnd'])?>">
                        </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 descrição" required><?=$linha['de_obsr']?></textarea>
                        </div>
                    </div>
                    
                    <div class="form-group text-center">
                        <small>*Obs: campos obrigat&oacute;rios</small>
                    </div>
                    
                    <div class="form-group">
                        <div class="col-md-6 col-sm-6 col-xs-12 col-md-offset-3">
                            <a href="javascript:voltar();"><button class="btn btn-primary" type="button">Voltar</button></a>
                            <button type="submit" class="btn btn-success">Alterar</button>
                            <input name="opc" type="hidden" id="opc" value="alt">
                            <input type="hidden" name="id_agnd_pagm" id="id_agnd_pagm" value="<?=$s_id_agnd_pagm?>">
                            <input type="hidden" name="id_comp" id="id_comp" value="<?php echo $linha[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_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>
                </div>

<?php
        
        $sqlar  = "SELECT * ";
        $sqlar .= "FROM ".$pref_tabl."agnd_anex ";
        $sqlar .= "WHERE id_agnd_pagm = $s_id_agnd_pagm ";
        $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_agnd/<?php echo $linhaar[nm_arqv];?>" target="_blank"><i class="fa fa-file-pdf-o"></i></a></td>
                            <td class="text-center"><a href="javascript:exc_pagm(<?php echo $linhaar[id_anex];?>);"><i class="fa fa-trash"></i></a></td>
                        </tr>
<?php                                    
            }
?>
                            </tbody>
                        </table>
                    </div>
                </div>
<?php                                    
        }
?>
        
            </div>
        </div>
        
    </div>
</div>
        
<SCRIPT LANGUAGE="javascript">
    function voltar() {
        document.acidente.action = "index1.php?pg=alt_solc";
        document.acidente.submit();
    }
    function exc_pagm(xb) {
        if (confirm('Tem certeza que deseja excluir o anexo?')) {
            document.acidente.action = "index1.php?pg=sql_agnd_pagm";
            document.acidente.opc.value = 'exc_anex';
            document.acidente.id_anex.value = xb;
            document.acidente.submit();
        }
    }
    $('#myDatepicker2').datetimepicker({
        format: 'DD/MM/YYYY',
        locale:'pt-br'
    });
    $('#myDatepicker3').datetimepicker({
        format: 'DD/MM/YYYY',
        locale:'pt-br'
    });
</script>
<form name="acidente" method="post" action="" style="margin:0px !important;">
    <input type="hidden" name="id_agnd_pagm" id="id_agnd_pagm" value="<?=$s_id_agnd_pagm?>">
    <input type="hidden" name="id_comp" id="id_comp" value="<?php echo $linha[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_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 type="hidden" name="opc" id="opc">
    <input type="hidden" name="id_anex" id="id_anex">
    <input type="hidden" name="passa" id="passa" value="yes">
</form>
<?php
    }
} else {
    require "erro.php";
}
?>

Back to Directory File Manager