<?php
session_start();
require_once ("../../config/Cado.php");
require_once ("../ingreso/cIngreso.php");
$oIngreso = new cIngreso();
require_once("../formatos/formato.php");

		if($_SESSION['usuariogrupo_id']=='6'){
		$dts1=$oIngreso->mostrar_filtro($_SESSION['puntoventa_id'],$_POST['cmb_fil_caj_id'],fecha_mysql($_POST['txt_fil_caj_fec1']),fecha_mysql($_POST['txt_fil_caj_fec2']),
		$_POST['cmb_fil_cue_id'],$_POST['cmb_fil_subcue_id'],$_POST['cmb_fil_doc_id'],$_POST['txt_fil_ing_numdoc'],
		$_POST['hdd_fil_cli_id'],$_POST['cmb_fil_ing_est'],$_POST['cmb_fil_mon_id']);
		}else{
		$dts1=$oIngreso->mostrar_filtro('',$_POST['cmb_fil_caj_id'],fecha_mysql($_POST['txt_fil_caj_fec1']),fecha_mysql($_POST['txt_fil_caj_fec2']),
		$_POST['cmb_fil_cue_id'],$_POST['cmb_fil_subcue_id'],$_POST['cmb_fil_doc_id'],$_POST['txt_fil_ing_numdoc'],
		$_POST['hdd_fil_cli_id'],$_POST['cmb_fil_ing_est'],$_POST['cmb_fil_mon_id']);
		}
$num_rows= mysqli_num_rows($dts1);
?>
<div class="table-responsive">
		
		<div class="col-lg-12 col-md-12 col-xs-12 " >
<table cellspacing="1" id="tabla_ingreso" class="table table-striped table-bordered">
  <thead>
    <tr>
      <th nowrap>FECHA</th>
      <th>DOCUMENTO</th>
      <th>CLIENTE</th>
      <th>DETALLE</th>
      <th>CUENTA</th>
      <th align="right">IMPORTE</th>    
      <th title="Editar">&nbsp;</th>
    </tr>
  </thead>
  <tbody>
    <?php
    while($dt1 = mysqli_fetch_array($dts1)){
     $sum_imp+=$dt1['tb_ingreso_imp'];
	 
	  if($dt1['tb_cliente_id']>0){
		$nom = $dt1['tb_cliente_nom'];
		$doc = $dt1['tb_cliente_doc'];
	}
	else{
		$nom = 'INGRESO S/CLIENTE';
		$doc = '';
	}
	
	
     ?>
     <tr title="<?php echo $dt1['tb_ingreso_id'].' ::: '.$dt1['tb_caja_nom']; ?>" >
      <td nowrap="nowrap"><?php echo mostrarFecha($dt1['tb_ingreso_fec'])?></td>
      <td><?php echo $dt1['tb_documento_abr'].' '.$dt1['tb_ingreso_numdoc']?></td>
      <td><?php echo $doc.' '.$nom?></td>  
      <td><?php echo $dt1['tb_ingreso_det'] ?></td>
      <td ><?php echo $dt1['tb_cuenta_nom']?></td>
      <td align="right"><?php echo formato_money($dt1['tb_ingreso_imp'])?></td>        
      <td align="center" nowrap="nowrap">
        <?php 
        if($dt1['tb_ingreso_modide']==0){
          ?> 
          <a class="btn btn-info btn-sm"  onClick="ingreso_form('editar','<?php echo $dt1['tb_ingreso_id']?>')" ><i class="fa fa-edit"></i></a> 
          
          <a class="btn btn-danger btn-sm"   onClick="ingreso_eliminar('<?php echo $dt1['tb_ingreso_id']?>')"><i class="fa fa-trash"></i> </a> 
          <?php 
          }
          ?>
        </td>
      </tr>
      <?php
    }
    mysqli_free_result($dts1);
    ?>
  </tbody>
  <tr class="even">
    <td colspan="4"><strong>TOTAL <?php echo $num_rows." registros";?></strong></td>
	<td colspan="1">&nbsp;</td>
    <td colspan="1" align="right"><strong><?php echo formato_money($sum_imp)?></strong></td>
    <td colspan="1">&nbsp;</td>
  </tr>
</table>
<input name="hdd_ingreso_total" id="hdd_ingreso_total" type="hidden" value="<?php echo $sum_imp?>">
</div>
</div>
 <script type="text/javascript">
  $(function() {  
     $('#tabla_ingreso').DataTable({
 
        "language": {
                "lengthMenu": "Mostrar _MENU_ registros",
                "zeroRecords": "No se encontraron resultados",
                "info": "Mostrando registros del _START_ al _END_ de un total de _TOTAL_ registros",
                "infoEmpty": "Mostrando registros del 0 al 0 de un total de 0 registros",
                "infoFiltered": "(filtrado de un total de _MAX_ registros)",
                "sSearch": "Buscar:",
                "oPaginate": {
                    "sFirst": "Primero",
                    "sLast":"Último",
                    "sNext":"Siguiente",
                    "sPrevious": "Anterior"
			     },
			     "sProcessing":"Procesando...",
            }
    });  
  }); 
</script> 