<?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 ="";

	$sql= "SELECT * FROM mg_usuarios";

	if(!empty($_POST))
	{
		$valor = $_POST['campo'];
		if(!empty($valor)){
			$where = "WHERE nombre LIKE '%$valor%' OR (usuario LIKE '%$valor%')";
		}
	}
	$sql = "SELECT * FROM mg_usuarios $where";
	$resultado= $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>
	
    	 <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>USUARIOS MG</strong></h2>

			<form action="<?php $_SERVER['PHP_SELF']; ?>" method="POST">
					<b>NOMBRE o USUARIO: </b><input type="text" id="campo" name="campo" />
					
					<!--<b>SUCURSAL: </b>
					<select name="campo">
					    <option value="">.......</option>
					    <option value="SCMinerva">Volvo Minerva</option>
					    <option value="SCMorelia">Volvo Morelia</option>
					    <option value="SCGalerias">Volvo Galerias</option>
					    <option value="SCBosques">Volvo Bosques</option>
					    <option value="SCQueretaro">Volvo Queretaro</option>
					</select>-->
					
					<input type="submit" id="enviar" name="enviar" value="Buscar" class="btn btn-info" />
			</form>
		</div>
		<div>
			<form action="regis_user.php">
				<button type="button" class="btn btn-info btn-lg " data-toggle="modal" data-target="#myModal3" style="padding:4px 12px; cursor: pointer;color: #fff;background: crimson; margin: auto;">Nuevo Registro</button>
			</form>
		</div>
		<div>
			<form action="exportar.php">
				<input style="padding:4px 12px; cursor: pointer;color: #fff;background: #084B8A; margin: auto;" type="submit" value="Exportar Registro">
			</form>
		</div>
		<!--<div>
			<form action="regis_user.php">
				<input style="padding:4px 12px; cursor: pointer;color: #fff;background: crimson; margin: auto;" type="submit" value="Nuevo Registro">
			</form>
		</div>-->
		
		<div id="myModal3" class="modal fade" role="dialog">
            <div class="modal-dialog">

            <!-- Modal content-->
            <div class="modal-content">
                <div class="modal-header">
                    <button type="button" class="close" data-dismiss="modal">&times;</button>
                    <h4 class="modal-title"><strong>REGISTRO DE USUARIO</strong></h4>
                </div>
            <div class="modal-body">
		
		        <form action="registrar.php" method="post" class="form-registro" onsubmit="return validar();">
		            <div class="contenedor-inputs">
			            <input style="font-size: 12px;margin-bottom: 12px;padding: 12px;border-radius: 3px;border: 1px solid darkgray;" type="text" id="nombre" name="nombre" placeholder="Nombre" class="input-48">
			            <input style="font-size: 12px;margin-bottom: 12px;padding: 12px;border-radius: 3px;border: 1px solid darkgray;" type="text" id="area" name="area" placeholder="Area" class="input-48">
			            <input style="font-size: 12px;margin-bottom: 12px;padding: 12px;border-radius: 3px;border: 1px solid darkgray;" type="text" id="sucursal" name="sucursal" placeholder="Sucursal" class="input-48">
			            <input style="font-size: 12px;margin-bottom: 12px;padding: 12px;border-radius: 3px;border: 1px solid darkgray;" type="text" id="usuario" name="usuario" placeholder="Usuario" class="input-48">
			            <input style="font-size: 12px;margin-bottom: 12px;padding: 12px;border-radius: 3px;border: 1px solid darkgray;" type="text" id="clave" name="clave" placeholder="Clave" class="input-48">
			            <input style="font-size: 12px;margin-bottom: 12px;padding: 12px;border-radius: 3px;border: 1px solid darkgray;" type="text" id="usuariobp" name="usuariobp" placeholder="Usuario BP" class="input-48">
			            <input style="font-size: 12px;margin-bottom: 12px;padding: 12px;border-radius: 3px;border: 1px solid darkgray;" type="text" id="clavebp" name="clavebp" placeholder="Clave BP" class="input-48">
			            <input style="font-size: 12px;margin-bottom: 12px;padding: 12px;border-radius: 3px;border: 1px solid darkgray;" type="email" id="correo" name="correo" placeholder="Correo" class="input-100">
			            <input style="font-size: 12px;margin-bottom: 12px;padding: 12px;border-radius: 3px;border: 1px solid darkgray;" type="text" id="clavecorreo" name="clavecorreo" placeholder="Clave Correo" class="input-48">
			            <input style="font-size: 12px;margin-bottom: 12px;padding: 12px;border-radius: 3px;border: 1px solid darkgray;" type="text" id="ucimp" name="ucimp" placeholder="UC Imp" class="input-48">
			            <input style="font-size: 12px;margin-bottom: 12px;padding: 12px;border-radius: 3px;border: 1px solid darkgray;" type="text" id="clavetel" name="clavetel" placeholder="ClaveTel" class="input-48">
			             
			            <input style="font-size: 12px;margin-bottom: 12px;padding: 12px;border-radius: 3px;border: 1px solid darkgray; padding: 10px 40px; margin: auto; background: crimson; color: #fff; text-align: center" type="submit" value="Registrar" class="btn-registro">
		
		
		            </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
                </div>
            </div>

            </div>
        </div>
		</div>
		
		
		
		
		
		<br>

		<div class="row table-responsive">
			<table class="display" id="mitabla" style="border-color: #337ab7;">
			<thead>
				<tr style="color: #fff; background-color: #7B7B7C; border-color: #337ab7; font-size: 75%; hover:background-color:#EBF8FC;">
					<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;">AREA</th>
					<th style="padding: 10px; text-align: center;">SUCURSAL</th>
					<th style="padding: 15px; text-align: center;">USUARIO</th>
					<th style="padding: 10px; text-align: center;">CLAVE</th>
					<th style="padding: 15px; text-align: center;">USUARIO BP</th>
					<th style="padding: 15px; text-align: center;">CLAVE BP</th>
					<th style="padding: 20px; text-align: center;">CORREO</th>
					<th style="padding: 10px; text-align: center;">CONTRASEÑA</th>
					<th style="padding: 10px; text-align: center;">UC IMP</th>
					<th style="padding: 10px; text-align: center;">CLAVE TEL</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; padding: 10px;"><?php echo $row['nombre']; ?></td>
						<td style="text-align: left; padding: 15px;"><?php echo $row['area'];?></td>
						<td style="text-align: center; padding: 20px;"><?php echo $row['sucursal'];?></td>
						<td style="text-align: center;"><?php echo $row['usuario'];?></td>
						<td style="text-align: center; padding: 15px;"><?php echo $row['clave'];?></td>
						<td style="text-align: center; padding: 20px;"><?php echo $row['usuariobp'];?></td>
						<td style="text-align: left; padding: 15px;"><?php echo $row['clavebp'];?></td>
						<td style="text-align: center;"><?php echo $row['correo'];?></td>
						<td style="text-align: center; padding: 20px;"><?php echo $row['clavecorreo'];?></td>
						<td style="text-align: center; padding: 20px;"><?php echo $row['ucimp'];?></td>
						<td style="text-align: center; padding: 20px;"><?php echo $row['clavetel'];?></td>
						
						<td><a href="editar.php?id=<?php echo $row['id']; ?>"><span class="glyphicon glyphicon-pencil" style="padding: 15px;"></span></a></td>
						<td><a href="#" data-href="eliminar.php?id=<?php echo $row['id']; ?>" 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>