File: /home/austral3d/fourdplan.com/php/permiso_usuarios.php
<?php
session_start();
if ($_SESSION == NULL ){
session_destroy();
echo'<script>
alert("Acceso denegado.")
self.location="../index.php"
</script>';
}
require('conexion.php');
$proyectos = mysql_query("select nombre, id from Proyecto");
$a = mysql_query("SELECT U.id, U.nombre, U.apellido, E.nombre FROM Usuario U join Empresa E on U.empresa_id = E.id ");
$tabla = '<table class="table table" style="background-color:#363636;"><tr><th><font color="#fff">Nombre</font></th><th><font color="#fff">Empresa</font></th>';
while($p = mysql_fetch_array($proyectos)){
$tabla.= $j[]= '<th><font color="#fff">'.$p[0].'</font></th>';
$k[]= $p[1];
}
while($b = mysql_fetch_array($a)){
$g[] = $b[0];//id usuario
$h[] = $b[1];//nombre usuario
$i[] = $b[2];//apellido usuario
$l[] = $b[3];//empresa
}
$pk = count($k);
$pg = count($g);
$cero1 = 0;
$cero2 = 0;
while($pg > $cero2){
$tabla.='</tr><tr><td class="bg-info">'.$h[$cero2].' '.$i[$cero2].'</td><td class="bg-info">'.$l[$cero2].'</td>';
while($pk > $cero1){
$consulta_proyectos = mysql_query("select rol_id from Permisos where usuario_id = '".$g[$cero2]."' and proyecto_id = '".$k[$cero1]."' ");
$bbbbb = mysql_num_rows($consulta_proyectos);
if($bbbbb ==0){
$tabla.='<td class="bg-success"></td>';
}else{
$cp = mysql_result($consulta_proyectos,0);
if($cp==1){
$o = "Usuario";
$tabla.='<td class="danger">'.$o.'</td>';
}else if($cp==2){
$o = "Admin";
$tabla.='<td class="bg-primary">'.$o.'</td>';
}
}
$cero1+=1;
}
if($cero1 >= $pk){
$cero2+=1;
$cero1=0;
}
$tabla.= '</tr>';
}
$tabla.='</table>';
?>
<!DOCTYPE html>
<html>
<head>
<title>Fourdplan</title>
<link href="../css/bootstrap.min.css" rel="stylesheet">
<meta charset="UTF-8">
<link href="../css/sti.css" rel="stylesheet">
<link rel="icon" href="../img/fdp.ico">
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no">
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.2/jquery.min.js"></script>
</head>
<body>
<div class="content">
<!-- menu barra negra superior -->
<nav class="navbar navbar-inverse navbar-fixed-top">
<div class="container-fluid">
<!-- 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" ><img src="../img/logo90x19.png" class="img" /></a>
</div>
<div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
<ul class="nav navbar-nav">
<li><a href="../index.php"><span class="glyphicon glyphicon-home" aria-hidden="true"></span> Inicio</a></li>
</ul>
<ul class="nav navbar-nav navbar-right">
<?php require("barrasuperior.php");?>
<!--li role="presentation"><a href="#"> <span class="label label-primary">(0) <img src="../img/correo.png" /></span></a></li-->
<li role="presentation"><a><span class="glyphicon glyphicon-user" aria-hidden="true"></span> <?php //if($_SESSION){echo $_SESSION['nombre'];}?></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-list" aria-hidden="true"></span><span class="caret"></span></a>
<ul class="dropdown-menu">
<li><a href="cerrar_session.php">Cerrar sesion</a></li>
</ul>
</li>
</ul>
</div><!-- /.navbar-collapse -->
</div><!-- /.container-fluid -->
</nav>
<br><br><br><br>
</div>
<div>
<center><h3>Permisos de usuario</h3></center>
<br>
</div>
<div class="container">
<?php
echo $tabla;
?>
</div>
<br><br>
<div>
<br>
</div>
<br><br>
<!-- pie de pagina-->
<div><?php require("pie.php");?><div>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script>
<script src="../js/bootstrap.min.js"></script>
<script src="../js/highcharts.js"></script>
<script src="../js/modules/exporting.js"></script>
<script src="../js/modules/data.js"></script>
</body>
</html>