<?php

	session_start();
	error_reporting(0);
	$varsesion= $_SESSION['usuario'];

	if($varsesion == null || $varsesion= ''){
		echo 'Usted no tiene Autorizacion, favor de iniciar sesion';
		die();
	}


	require 'cn2.php';

	$where ="";

	$sqld= "select * from mg_ecomputo d LEFT JOIN mg_usuarios u on d.id = u.id ";

	if(!empty($_POST))
	{
		$valor = $_POST['campo'];
		if(!empty($valor)){
			$where = "WHERE name LIKE '%$valor%' OR (serie LIKE '%$valor%')";
		}
	}
	$sqld= "select * from mg_ecomputo d LEFT JOIN mg_usuarios u on d.id = u.id  $where";
	$sql = "select u.id, u.nombre, d.tipo,d.name,d.serie,d.ip,d.modelo,d.procesador,d.hdd,d.ram,d.monitor,d.seriem,d.so,d.loffice from mg_ecomputo d RIGHT JOIN mg_usuarios u on d.id = u.id";
	$resultado= $mysqli->query($sqld);
	$todo=$mysqli->query($sql);


?>


<html lang="es">
<head>
		
		<meta charset="utf-8">
	    <meta name="viewport" content="width=device-width, initial-scale=1">
		<link href="css/bootstrap.min.css" rel="stylesheet">
		<link href="css/bootstrap-theme.css" rel="stylesheet">
		<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" integrity="sha384-1q8mTJOASx8j1Au+a5WDVnPi2lkFfwwEAa8hDDdjZlpLegxhjVME1fgjWPGmkzs7" crossorigin="anonymous">
		<!--<link rel="stylesheet" type="text/css" href="css/estilos.css">-->
		<!--<link href="css/jquery.dataTables.min.css" rel="stylesheet">-->	
		<!--<script src="js/jquery-3.1.1.min.js"></script>-->
		<!--<script src="js/jquery.dataTables.min.js"></script>-->
		<link rel="stylesheet" href="css/bootstrap.min.css">
		<!--<script src="js/bootstrap.min.js"></script>-->		
		<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
        <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.0/js/bootstrap.min.js"></script>
        <style> 
        tr:nth-child(odd){
	background-color: #f2f2f2;
}
tr:nth-child(even){
	background-color: #fbfbfb;
}
tr: hover{
	background-color: #EBF8FC;
}
</style>

</head>
<body>
		
	</header>
		<nav class="navbar navbar-inverse">
        <div class="container">
    <!-- Brand and toggle get grouped for better mobile display -->
        <div class="navbar-header">
      <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1" aria-expanded="false">
        <span class="sr-only">Toggle navigation</span>
        <span class="icon-bar"></span>
        <span class="icon-bar"></span>
        <span class="icon-bar"></span>
      </button>
      <a class="navbar-brand" href="index.php"><strong>INVENTARIO MG</strong></a>
    </div>

    <!-- Collect the nav links, forms, and other content for toggling -->
    <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
      <ul class="nav navbar-nav">
        <!--<li class="active"><a href="bdispo.php"><span class="glyphicon glyphicon-hdd"></span> Equipos <span class="sr-only">(current)</span></a></li>-->
        <li class="dropdown">
          <a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false"><span class="glyphicon glyphicon-hdd"></span> Equipos<span class="caret"></span></a>
          <ul class="dropdown-menu">
            <li><a href="bdispo.php">PC</a></li>
            <li role="separator" class="divider"></li>
            <li><a href="cany.php">Conx. AnyDesk</a></li>
            <li role="separator" class="divider"></li>
            
          </ul>
        </li>
        <li class="dropdown">
          <a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false"><span class="glyphicon glyphicon-user"></span> Personal<span class="caret"></span></a>
          <ul class="dropdown-menu">
            <li><a href="regis.php">Usuarios</a></li>
            <li role="separator" class="divider"></li>
            <li><a href="consul.php">Vendedores</a></li>
            <li role="separator" class="divider"></li>
            <li><a href="buscaip.php">IP'S</a></li>
            
          </ul>
        </li>
        <li><a href="imp.php"><span class="glyphicon glyphicon-print"></span> Impresoras</a></li>
        <li><a href="antenas.php"><span class="glyphicon glyphicon-signal"></span> Antenas</a></li>
        <li><a href="cel.php"><span class="glyphicon glyphicon-phone"></span> Celulares</a></li>
        <li><a href="correos.php"><span class="glyphicon glyphicon-envelope"></span> Correos</a></li>
      </ul>
      
      <ul class="nav navbar-nav navbar-right">
        <li><a href="index.php">Bienvenido: <?php echo $_SESSION['usuario'] ?> </a></li>
        <li><a style="text-align: right;" href="close_sesion.php" data-toggle="modal" data-target="#confirm-delete"><span class="glyphicon glyphicon-lock" style="color: #FF0000;">Cerrar Sesion</span></a></li>
        
        <!--<li class="dropdown">
          <a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">Dropdown <span class="caret"></span></a>
        
          <ul class="dropdown-menu">
            <li><a href="#">Action</a></li>
            <li><a href="#">Another action</a></li>
            <li><a href="#">Something else here</a></li>
            <li role="separator" class="divider"></li>
            <li><a href="#">Separated link</a></li>
          </ul>
        </li>-->
      </ul>
    </div><!-- /.navbar-collapse -->
  </div><!-- /.container-fluid -->
</nav>




	<div class="container">
		<div class="row">
			<h2 style="text-align: center"><strong>EQUIPO DE COMPUTO MG</strong></h2>

			<form action="<?php $_SERVER['PHP_SELF']; ?>" method="POST">
					<b>Nombre y/o Serie: </b><input type="text" id="campo" name="campo" />
					<input type="submit" id="enviar" name="enviar" value="Buscar" class="btn btn-info" />
			</form>
		</div>
		<div>
			<form action="dispo.php">
				<input style="padding:4px 12px; cursor: pointer;color: #fff;background: crimson; margin: auto;" type="submit" value="Nuevo Registro">
			</form>
		</div>
		<div>
			<form action="expequipos.php">
				<input style="padding:4px 12px; cursor: pointer;color: #fff;background: #084B8A; margin: auto;" type="submit" value="Exportar Registro">
			</form>
		</div>
		
		<br>

		<div class="row table-responsive" style=" max-width:8000px">
			<table class="display" id="mitabla" style="border-color: #337ab7;">
			<thead>
				<tr style="color: #fff; background-color: #7B7B7C; border-color: #337ab7; font-size: 75%;">
					<th style="padding: 10px; text-align: center;">ID</th>
					<th style="padding: 15px; text-align: center;">NOMBRE</th>
					<th style="padding: 10px; text-align: center;">NOMBRE PC</th>
					<th style="padding: 10px; text-align: center;">IP</th>
					<th style="padding: 10px; text-align: center;">DOMINIO</th>
					<th style="padding: 10px; text-align: center;">TIPO</th>
					<th style="padding: 10px; text-align: center;">S.O</th>
					<th style="padding: 10px; text-align: center;">OFFICE</th>
					<th style="padding: 15px; text-align: center;">MODELO</th>
					<th style="padding: 15px; text-align: center;">SERIE</th>
					<th style="padding: 10px; text-align: center;">PROCESADOR</th>
					<th style="padding: 10px; text-align: center;">HDD</th>
					<th style="padding: 10px; text-align: center;">RAM</th>
					<th style="padding: 10px; text-align: center;">MONITOR</th>
					<th style="padding: 10px; text-align: center;">SERIE</th>
					<th style="padding: 10px; text-align: center;">ANTIVIRUS</th>
					<th style="padding: 10px; text-align: center;">TIPOVENTA</th>
					
					
				
				</tr>
			</thead>
			<tbody>
				<?php while($row= $resultado->fetch_array(MYSQLI_ASSOC)) {?>
				<tr style="font-size: 80%;border-bottom: 2px solid #7B7B7C">
				        <td style="text-align: center;  font-weight: bold;"><?php echo $row['id']; ?></td>
						<td style="text-align: center;  font-weight: bold;"><?php echo $row['nombre']; ?></td>
						<td style="text-align: center; padding: 15px;"><?php echo $row['name'];?></td>
						<td style="text-align: center; padding: 20px;"><?php echo $row['ip'];?></td>
						<td style="text-align: center; padding: 10px;"><?php echo $row['dominio']; ?></td>
						<td style="text-align: center; padding: 10px;"><?php echo $row['tipo']; ?></td>
						<td style="text-align: center; padding: 20px;"><?php echo $row['so'];?></td>
						<td style="text-align: center; padding: 20px;"><?php echo $row['loffice'];?></td>
						<td style="text-align: center; padding: 25px;"><?php echo $row['modelo'];?></td>
						<td style="text-align: center; padding: 20px;"><?php echo $row['serie'];?></td>
						<td style="text-align: center;"><?php echo $row['procesador'];?></td>
						<td style="text-align: center; padding: 25px;"><?php echo $row['hdd'];?></td>
						<td style="text-align: center; padding: 25px;"><?php echo $row['ram'];?></td>
						<td style="text-align: center; padding: 20px;"><?php echo $row['monitor'];?></td>
						<td style="text-align: center; padding: 20px;"><?php echo $row['seriem'];?></td>
						<td style="text-align: center; padding: 20px;"><?php echo $row['antivirus'];?></td>
						<td style="text-align: center; padding: 20px;"><?php echo $row['tipoventa'];?></td>
						
						
						<td><a href="edispo.php?serie=<?php echo $row['serie']; ?>"><span class="glyphicon glyphicon-pencil" style="padding: 15px;"></span></a></td>
						<td><a href="#" data-href="eliminardispo.php?serie=<?php echo $row['serie']; ?>" data-toggle="modal" data-target="#confirm-delete"><span class="glyphicon glyphicon-trash" style="color: #FF0000;"></span></a>
						</td>
				</tr>
				<?php } ?>
			</tbody>	
			</table>
		</div>

	</div>

	
	
    <div class="footer" style="position: ; width:100%; height:120px; background-color:#363636; bottom:0;">
	    
	    <div class="container">
	     
	        <div style="text-align:center; color:#D2D2D2;">
	            	<label>Avenida Vallarta 5750 , Jocotan, Zapopan, Jalisco, 45017.</label>
	            	<label>Tel.(33)27345000</label>
	            	<p>© Morris Garages, todos los derechos reservados</p><br />
	            	
	            
	        </div>
	        <div style="text-align:center; font-size:25px; color:#D2D2D2;">
	            	<p><strong> INVENTARIO SISTEMAS MG</strong></p>
	        </div>

	    </div>
	</div>

	<!-- Modal -->
		<div class="modal fade" id="confirm-delete" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
			<div class="modal-dialog">
				<div class="modal-content">
					
					<div class="modal-header">
						<button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
						<h4 class="modal-title" id="myModalLabel">Eliminar Registro</h4>
					</div>
					
					<div class="modal-body">
						¿Desea eliminar este registro?
					</div>
					
					<div class="modal-footer">
						<button type="button" class="btn btn-default" data-dismiss="modal">Cancel</button>
						<a class="btn btn-danger btn-ok">Delete</a>
					</div>
				</div>
			</div>
		</div>

		<script>
			$('#confirm-delete').on('show.bs.modal', function(e) {
				$(this).find('.btn-ok').attr('href', $(e.relatedTarget).data('href'));
				
				$('.debug-url').html('Delete URL: <strong>' + $(this).find('.btn-ok').attr('href') + '</strong>');
			});
		</script>	
</body>
</html>