eclass.unmer.ac.id

<?php
	require '../includes/conexao/funcao.inc.php';
	require '../includes/conexao/config.php';
	require '../includes/conexao/conn.php';
	require '../includes/conexao/function.php';

//DATA QUE VAI ORDENAR
	if($_POST['competencia']==1){

$msn = "Por competência de: $_POST[dec] até $_POST[atec]";

$dec  = DateTodbDateC($_POST['dec']);
        $atec = DateTodbDateC($_POST['atec']);

$datade  = "AND dbcompetencia_recibo >= '$dec'";
        $dataate = "AND dbcompetencia_recibo <= '$atec'";

if($_POST['status']==1){

$status = "";

}else if($_POST['status']==2){

$status = "AND status_recibo = '0'";

}

}elseif($_POST['competencia']==2){

$msn = "Por vencimento de: $_POST[de] até $_POST[ate]";

$dataf = "cw_lancamentos.previsao_lancamentos";

$de  = DateTodbDate2($_POST['de']);
        $ate = DateTodbDate2($_POST['ate']);

$datade  = "AND dbvencimento_recibo >= '$de'";
        $dataate = "AND dbvencimento_recibo <= '$ate'";

if($_POST['status']==1){

$status = "";

}else if($_POST['status']==2){

$status = "AND status_recibo = '0'";

}

}elseif($_POST['competencia']==3){

$msn = "Por baixa de: $_POST[de] até $_POST[ate]";

$dataf = "cw_lancamentos.previsao_lancamentos";

$de  = DateTodbDate2($_POST['de']);
        $ate = DateTodbDate2($_POST['ate']);

$datade  = "AND databaixa_recibo >= '$de'";
        $dataate = "AND databaixa_recibo <= '$ate'";

$status = "AND status_recibo = '1'";

}
	//DATA QUE VAI ORDENAR

//ARRAY QUEM SELECIONA OS CLIENTES
    if (!empty($_POST['cliente'])) {
    
    
    $queryData = "'" . implode("','", $_POST['cliente']) . "'";
    
        
    $cliente = " AND cliente_recibo IN($queryData)";
    
    }else{

$cliente = "";

}
    //ARRAY QUEM SELECIONA OS CLIENTES

//SALDO INICIAL
	/*$querycre = "SELECT SUM(cw_lancamento.valor_lancamento) as total FROM cw_lancamentos, cw_lancamento WHERE  cw_lancamentos.chave_lancamentos=cw_lancamento.chave_lancamento AND cw_lancamentos.baixa_lancamentos!='0000-00-00' AND cw_lancamento.dc_lancamento='2' $conta $pconta $projeto";
	$resultcre = DBExecute($querycre);
	$rescre = mysqli_fetch_assoc($resultcre);
	
	
	$querydeb = "SELECT SUM(cw_lancamento.valor_lancamento) as total FROM cw_lancamentos, cw_lancamento WHERE  cw_lancamentos.chave_lancamentos=cw_lancamento.chave_lancamento AND cw_lancamentos.baixa_lancamentos!='0000-00-00' AND cw_lancamento.dc_lancamento='1' $conta $pconta $projeto";
	$resultdeb = DBExecute($querydeb);
	$resdeb = mysqli_fetch_assoc($resultdeb);
		
	$saldo = $rescre['total']-$resdeb['total'];*/
	//SALDO INICIAL
	
	
	$query = "SELECT id_cliente, codigo_cliente, razao_cliente FROM cw_cliente, cw_recibo WHERE id_cliente = cliente_recibo $datade $dataate $cliente $status GROUP BY id_cliente";
	$link   = DBConnect();
	$result = @mysqli_query($link, $query) or die(mysqli_error($link));
?>
<!DOCTYPE html>
<html>

<head>

<title>RELATÓRIO DE COBRANÇA</title>

</head>

<body class="fixed-navigation">
<div class="row wrapper border-bottom white-bg page-heading">
                <div class="col-sm-4">
                    <h2><i class="fa fa-bar-chart-o"></i> RELATÓRIO DE COBRANÇA</h2>
                    
                </div>
            </div>
        <div class="row">
            <div class="col-lg-12">
                <div class="wrapper wrapper-content animated fadeInUp">

<div class="project-list">
							
                                <table width="100%" border="0">
                                	
                                    <?php
                                            
											while($res = mysqli_fetch_assoc($result)){ 
											
                                            
									?>
                                      <tr>
                                        <th colspan="7" scope="col" style="text-align:left; border-top:1px solid #000; border-bottom:1px solid #000; background-color: #B8B8B8; color: #000; font-weight: bold; padding: 5px "><?php echo $res['codigo_cliente']; ?> - <?php echo $res['razao_cliente']; ?></th>
                                      </tr>
                                      <tr style="background-color:#000; color:#FFF; font-weight:bold">
                                        <th width="14%" style="padding:5px">Nº Título</th>
                                        <th width="14%" style="padding:5px">Competência</th>
                                        <th width="14%" style="padding:5px">Vencimento</th>
                                        <th width="14%" style="padding:5px">Baixa</th>
                                        <th width="12%" style="padding:5px">Valor</th>
                                        <th width="15%" style="padding:5px">Recebido</th>
                                        <th width="15%" style="padding:5px">Total</th>
                                      </tr>
                                      <?php
                                            $queryl = "SELECT * FROM cw_recibo WHERE cliente_recibo='$res[id_cliente]' $datade $dataate $status";
                                            $linkl   = DBConnect();
                                            $resultl = @mysqli_query($linkl, $queryl) or die(mysqli_error($linkl));
                                            
                                            $totalgeral = 0;
                                            $totalresto = 0;
                                            $valortotal = 0;

while($resl = mysqli_fetch_assoc($resultl)){

$querysom = "SELECT SUM(valor_baixa) as total FROM cw_baixa WHERE cobranca_baixa='$resl[id_recibo]'";
                                            $resultsom = DBExecute($querysom);
                                            $ressom = mysqli_fetch_assoc($resultsom);
                                            $totalrestante = $ressom['total'];

$totalgeral += $resl['valor_recibo'];
                                            $totalresto += $totalrestante;
                                            $valortotal += ($resl['valor_recibo'] - $totalrestante);

?>
                                      <tr>
                                        <th><?php echo $resl['nosso_recibo']; ?></th>
                                        <th><?php echo $resl['competencia_recibo']; ?></th>
                                        <th><?php echo $resl['vencimento_recibo']; ?></th>
                                        <th><?php echo dbDateToDate2($resl['databaixa_recibo']); ?></th>
                                        <th><?php echo formataValor2($resl['valor_recibo']); ?></th>
                                        <th><?php echo formataValor2($totalrestante); ?></th>
                                        <th><?php echo formataValor2($resl['valor_recibo'] - $totalrestante); ?></th>
                                      </tr>
                                      <?php 
                                        }
                                      ?>   
                                      
                                      <tr>
                                        <th colspan="7" style="border-top:1px solid #000">&nbsp;</th>
                                      </tr>
                                      <tr>

<th colspan="7" style="font-weight:bold; text-align: right">Valor dos Títulos......................................................... R$ <?php echo formataValor2($totalgeral); ?></th>
                                      </tr>
                                      <tr>
                                        <th colspan="7" style="font-weight:bold; text-align: right">Valor Recebido............................................................ R$ <?php echo formataValor2($totalresto); ?></th>
                                      </tr>
                                      <tr>
                                        <th colspan="7" style="font-weight:bold; padding-bottom: 5px; text-align: right">Saldo Total................................................................... R$ <?php echo formataValor2($valortotal); ?></th>
                                      </tr>
                                    
                                    <?php } ?>

</table>    
                                    
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>

<script src="../midia/bootstrap/js/bootstrap.js"></script>
    <script src="../midia/js/jquery.metisMenu.js"></script>
    <script src="../midia/js/jquery.slimscroll.min.js"></script>
    <script src="../midia/js/jquery.maskedinput.min.js"></script>
    
	<script src="../midia/js/footable.all.min.js"></script>
    <script src="../midia/js/chosen.jquery.js"></script>

<script src="../midia/js/jquery.flot.js"></script>
    <script src="../midia/js/jquery.flot.tooltip.min.js"></script>
    <script src="../midia/js/jquery.flot.spline.js"></script>
    <script src="../midia/js/jquery.flot.resize.js"></script>
    <script src="../midia/js/jquery.flot.pie.js"></script>
    <script src="../midia/js/jquery.flot.symbol.js"></script>
    <script src="../midia/js/curvedLines.js"></script>
    <script src="../midia/js/site.js"></script>

<script src="../midia/js/jquery.peity.min.js"></script>
    <script src="../midia/js/peity-demo.js"></script>

<script src="../midia/js/inspinia.js"></script>
    <script src="../midia/js/pace.min.js"></script>

<script src="../midia/js/jquery-ui.min.js"></script>

<script src="../midia/js/jquery-jvectormap-2.0.2.min.js"></script>
    <script src="../midia/js/jquery-jvectormap-world-mill-en.js"></script>

<script src="../midia/js/jquery.sparkline.min.js"></script>

<script src="../midia/js/sparkline-demo.js"></script>
    
     
   <script src="../midia/js/datepicker.js"></script>

$('#edit-modallancamentos').on('show.bs.modal', function(e) {
            
            
                    var $modal = $(this),
                        esseyId = e.relatedTarget.id;
                    
                    $.ajax({
                        cache: false,
                        type: 'POST',
                        url: '../includes/config_lancamentos.php',
                        data: 'EID='+esseyId,
                        success: function(data) 
                        {
                            $modal.find('.edit-content').html(data);
                        }
                    });
                    
                })

$('#edit-modalconfig-lancamento').on('show.bs.modal', function(e) {
            
                    var $modal = $(this),
                        esseyId = e.relatedTarget.id;
                    
                    $.ajax({
                        cache: false,
                        type: 'POST',
                        url: '../includes/modalconfig-lancamento.php',
                        data: 'EID='+esseyId,
                        success: function(data) 
                        {
                            $modal.find('.edit-content').html(data);
                        }
                    });
                    
                })

$(document).ready(function(){
            $(document).on("click", ".altlancamento", function() {
            
                var chavelancamento = $("#chavelancamento").val();
                var idlancamento    = $("#idlancamento").val();
                var cdalt           = $("#cdalt:checked").val();
                var contaalt        = $("#contaalt").val();
                var plano_contaalt  = $("#plano_contaalt").val();
                var valoralt        = $("#valoralt").val();
                var historicoalt    = $("#historicoalt").val();
                
                
                $("#config_lancamento").html('<img src="../midia/img/ajax_loader.gif" alt="Aguarde..." />');
                
                $.ajax({
                type: "POST",
                url: "../includes/up-lancamento.php",
                data: {chavelancamento: chavelancamento, idlancamento: idlancamento, cdalt: cdalt, contaalt: contaalt, plano_contaalt: plano_contaalt, valoralt: valoralt, historicoalt: historicoalt},
                
                success: function(html){
                    
                        
                        $("#config_lancamento").empty();
                        $("#config_lancamento").append(html);
                        $('#edit-modalconfig-lancamento').modal('hide');
                
                }
                });
                return false;
                });
                });

$(document).ready(function(){
                    $(document).on("click", "#altvalordolancamento", function() {
                    
                    var chlancamento = $("#chlancamento").val();
                                    
                    $.ajax({
                        cache: false,
                        type: 'POST',
                        url: '../includes/alsomalancamento.php',
                        data: {chlancamento : chlancamento },
                        success: function(html) 
                        {
                                $(".somavalordolancamento").empty();
                                $(".somavalordolancamento").append(html);
                            
                        }
                    }); return false;
            
            });
            });         
            
    </script>
    
    
</body>
</html>