<?php
error_reporting(0);
include_once 'includes/db_connect.php';
include_once 'includes/functions.php';

sec_session_start();
?>
<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <title>LarIT | rdenes de Compra</title>
  <!-- Tell the browser to be responsive to screen width -->
  <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
  <!-- Bootstrap 3.3.7 -->
  <link rel="stylesheet" href="bower_components/bootstrap/dist/css/bootstrap.min.css">
  <!-- Font Awesome -->
  <link rel="stylesheet" href="bower_components/font-awesome/css/font-awesome.min.css">
  <!-- Ionicons -->
  <link rel="stylesheet" href="bower_components/Ionicons/css/ionicons.min.css">
   <!-- DataTables -->
  <link rel="stylesheet" href="bower_components/datatables.net-bs/css/dataTables.bootstrap.min.css">
  <!-- Theme style -->
  <link rel="stylesheet" href="dist/css/AdminLTE.min.css">
  <!-- AdminLTE Skins. Choose a skin from the css/skins
       folder instead of downloading all of them to reduce the load. -->
  <link rel="stylesheet" href="dist/css/skins/_all-skins.min.css">

  <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
  <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
  <!--[if lt IE 9]>
  <script src="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script>
  <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
  <![endif]-->

 <!-- Google Font -->
  <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,600,700,300italic,400italic,600italic">

  <SCRIPT LANGUAGE="JavaScript">
window.history.forward(1); 
</SCRIPT>	

</head>
<body class="hold-transition skin-blue sidebar-mini">
<div class="wrapper">

<?php if (login_check($mysqli) == true) : ?>	

<?php include_once 'includes/header.php'; ?>
  <!-- Left side column. contains the logo and sidebar -->
  <aside class="main-sidebar">
    <!-- sidebar: style can be found in sidebar.less -->
    <section class="sidebar">
      <!-- Sidebar user panel -->
      <div class="user-panel"  style="background-color:white">
        <div class="pull-left">
		  <img src="img/logogii.png" alt=""/>
		  <hr>
		  
		  <?php
		  $seltot="SELECT alias from inmuebles where id=".$_GET['cid'];
		  $qresult = mysql_query($seltot); 
		  $row = mysql_fetch_array($qresult);
		  ?>
		  
		  <p align=center><b><?php echo $row['alias'];?></b></p>
        </div>
	  </div>
		
      <!-- sidebar menu: : style can be found in sidebar.less -->
      <?php include_once 'includes/menu.php'; ?>
    </section>
    <!-- /.sidebar -->
  </aside>

 <!-- Content Wrapper. Contains page content -->
  <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
      <h1>
        rdenes de Compra
        <small>LISTADO</small>
      </h1>
      <ol class="breadcrumb">
        <li><a href="#"><i class="fa fa-dashboard"></i> Finanzas</a></li>
        <li class="active">rdenes de Compra</li>
      </ol>
    </section>


 <!-- Main content -->
    <section class="content">
      <div class="row">
        <div class="col-xs-12">
          <div class="box">
            <div class="box-header">
								<?php 
								echo "<a class='btn btn-primary' href='orden.php' title='Nueva Orden de Compra'><i class='fa fa-plus'></i></a></font>"; 
								echo "&nbsp;&nbsp;<a class='btn btn-info' href='filt_ordenes.php?page=1' title='Bsqueda avanzada'><i class='fa fa-search'></a></i></font>";
								?>
            </div>
			
                        <div class="panel-body">

												<?php
													$limit=1000;
													// $qselect = "SELECT * from guias";
													
												$id_empresa = 1;
												
												 if ($_POST['filtro']=="S") { ?>

												 <form name='frmsolserx' id='frmsolserx' method='post' target=_top action='list_ordenes.php'>
													<input type=hidden readonly name=filtro value="S">
													<input type=hidden readonly name=estado value="<?php echo $_POST['estado']; ?>">
													<input type=hidden readonly name=dtpfe value="<?php echo $_POST['dtpfe']; ?>">
													<input type=hidden readonly name=dtpfe2 value="<?php echo $_POST['dtpfe2']; ?>">
													<input type=hidden readonly name=id_proveedor value="<?php echo $_POST['id_proveedor']; ?>">
													<input type=hidden readonly name=anio value="<?php echo $_POST['anio']; ?>">
													<input type=hidden readonly name=numero value="<?php echo $_POST['numero']; ?>">
													</form>

													<form name='frmsolserx2' id='frmsolserx2' method='post' action='list_ordenes.php'>
													<input type=hidden readonly name=filtro value="N">
													<a href="javascript:;" onclick="document.getElementById('frmsolserx2').submit();"><i class='fa fa-filter'></i> Quitar Filtro</a>
													</form>
													
													<?php } 													
													
													// $nrResults=mysql_num_rows($qresult); // Count the results 
													$nrResults=1000;
													
													
													$pid=1;
													if (($nrResults%$limit)<>0) { 
													$pmax=floor($nrResults/$limit)+1;  // Divide to total result by the number of query you want 
													// to display per page($limit) and create a Max page 
													} else { 
													$pmax=floor($nrResults/$limit); 
													} 
													// $qselect = "SELECT * from guias order by id LIMIT ".(($_GET['page']-1)*$limit).", $limit";
													// $qresult = mysql_query($qselect);  // Let's get the query 
													$numc=($_GET['page']-1)*$limit;
													//Need to generate query considering your limit 
													$poi=1;
													?>
													
													<div class="table-responsive">
														<table class="table table-striped table-bordered table-hover" id="dataTables-example">
														<thead>
															<tr>
																<th></th>
																<th># O/C</th>
																<th>Fecha</th>
																<th>Proveedor</th>
																<th>Referencia</th>
																<th>Total</th>
															</tr>
														</thead>
														<tbody>
											
													<?php
													
													// $selini="select * from m_ordcom where fec_ocom >= '2016-01-01' and swt_est <> 'A' and (swt_apr = 0 or usr_apr='X') and fec_ocom>='2016-04-01' ";
													$selini="select * from ordenes where sp=0";
													
													// if ($rowop['id_cargo']==14 or $rowop['id_cargo']==15) $selini="select * from m_ordcom where fec_ocom >= '2016-01-01' and swt_est <> 'A' and swt_apr = 0 and fec_ocom>='2016-04-01' ";
													
													$selmid="";
													$selfin=" order by fecha DESC,numero DESC";
													if ($_POST['filtro']=="S") {
														if ($_POST['anio']!="") $selmid = $selmid . " and anio='".$_POST['anio']."'";
														if ($_POST['numero']!="") $selmid = $selmid . " and numero='".substr("000000".$_POST['numero'],-6)."'";
														if ($_POST['dtpfe']!="") {
															$desde=substr($_POST['dtpfe'],6,4)."-".substr($_POST['dtpfe'],3,2)."-".substr($_POST['dtpfe'],0,2);
															$selmid = $selmid . " and fecha >= '".$desde."'";
														}	
														if ($_POST['dtpfe2']!="") {
															$hasta=substr($_POST['dtpfe2'],6,4)."-".substr($_POST['dtpfe2'],3,2)."-".substr($_POST['dtpfe2'],0,2);
															$selmid = $selmid . " and fecha <= '".$hasta."'";
														}
														if ($_POST['estado']!="") $selmid = $selmid . " and estado=".$_POST['estado'];
														if ($_POST['id_proveedor']!="") $selmid = $selmid . " and id_proveedor=".$_POST['id_proveedor'];
													} 
													
													$seltot=$selini.$selmid.$selfin;
													
													$qresult = mysql_query($seltot);  // Let's get the query 
													
													while($row = mysql_fetch_array($qresult)) {
													
													echo "<tr>";												
													
													echo "<td>";
													echo "<button title='' class='btn btn-default' onclick='window.open(\"view_orden_pdf.php?cid=".substr(md5(uniqid(mt_rand(), true)), 0, 7)."0".$row['id']."\",\"_blank\");' data-original-title='Imprimir'><i class='fa fa-print'></i></button>";
													echo "&nbsp;&nbsp;<button title='' class='btn btn-default' onclick='location.href=\"orden.php?cid=".substr(md5(uniqid(mt_rand(), true)), 0, 7)."0".$row['id']."\"' data-original-title='Editar'><i class='fa fa-pencil'></i></button>";
													echo "</td>";
													
													echo "<td>";
													echo $row['anio']."-".$row['numero'];
													echo "</td>";
													
													echo "<td>";
													echo substr($row['fecha'],8,2)."/".substr($row['fecha'],5,2)."/".substr($row['fecha'],0,4);
													echo "</td>";													
													
													$qresultpg2 = mysql_query("SELECT * FROM proveedores where id=".$row['id_proveedor']);
													$row2 = mysql_fetch_array($qresultpg2);
													$des_pro = $row2['descripcion'];
													echo "<td>";
													echo $des_pro;
													echo "</td>";
													
													echo "<td>";
													echo $row['doc_ref'];
													echo "</td>";
													
													$qresultpg2 = mysql_query("select * from tablas_d where cdg_tab='MON' and codigo='".$row['cdg_mon']."'");
													$row2 = mysql_fetch_array($qresultpg2);
													$abr_mon=$row2['abr_item'];
													
													echo "<td>";
													$total = (float)$row['total'];
													$total = number_format($total, 2);
													echo $abr_mon." ".$total."&nbsp;&nbsp;";
													echo "</td>";
																										
													// PARA FIN DEL IF
													}
													
													echo "</table>";
													?>
													
												</tbody>
                                </table>
            </div>
            <!-- /.box-body -->
          </div>
          <!-- /.box -->
        </div>
        <!-- /.col -->
      </div>
      <!-- /.row -->
    </section>
    <!-- /.content -->
  </div>
  <!-- /.content-wrapper -->
  
 <?php include_once 'includes/footer.php'; ?>
  
  
<!-- jQuery 3 -->
<script src="bower_components/jquery/dist/jquery.min.js"></script>
<!-- Bootstrap 3.3.7 -->
<script src="bower_components/bootstrap/dist/js/bootstrap.min.js"></script>
<!-- SlimScroll -->
<script src="bower_components/jquery-slimscroll/jquery.slimscroll.min.js"></script>
<!-- FastClick -->
<script src="bower_components/fastclick/lib/fastclick.js"></script>
<!-- AdminLTE App -->
<script src="dist/js/adminlte.min.js"></script>
<!-- AdminLTE for demo purposes -->
<script src="dist/js/demo.js"></script>
<!-- DataTables -->
<script src="bower_components/datatables.net/js/jquery.dataTables.min.js"></script>
<script src="bower_components/datatables.net-bs/js/dataTables.bootstrap.min.js"></script>
    <script>
        $(document).ready(function () {
            $('#dataTables-example').dataTable({
				"language": {
					"sProcessing":     "Procesando...",
					"sLengthMenu":     "Mostrar _MENU_ registros",
					"sZeroRecords":    "No se encontraron resultados",
					"sEmptyTable":     "Ningn dato disponible en esta tabla",
					"sInfo":           "Mostrando registros del _START_ al _END_ de un total de _TOTAL_ registros",
					"sInfoEmpty":      "Mostrando registros del 0 al 0 de un total de 0 registros",
					"sInfoFiltered":   "(filtrado de un total de _MAX_ registros)",
					"sInfoPostFix":    "",
					"sSearch":         "Buscar:",
					"sUrl":            "",
					"sInfoThousands":  ",",
					"sLoadingRecords": "Cargando...",
					"oPaginate": {
						"sFirst":    "Primero",
						"sLast":     "ltimo",
						"sNext":     "Siguiente",
						"sPrevious": "Anterior"
					},
					"oAria": {
						"sSortAscending":  ": Activar para ordenar la columna de manera ascendente",
						"sSortDescending": ": Activar para ordenar la columna de manera descendente"
					}
				}
    } );
        });
    </script>	
	   <?php else : ?>
            <p>
                <span class="error">No est autorizado a visualizar esta pgina.</span> Por favor <a href="login.php">ingrese</a> nuevamente.
            </p>
        <?php endif; ?>

</body>

</html>