File: /home/austral3d/fourdplan.com/php/asd.php
<?php
require('conexion.php');
session_start();
if ($_SESSION == NULL ){
echo'<script>
alert("Acceso denegado.")
self.location="index.php"
</script>';
}
$id = $_GET['id'];
$rol = $_GET['rol'];
$consulta=mysql_query("select * from Conjunto where Proyecto_id='".$id."'");
$consultaA=mysql_query("select * from Conjunto where Proyecto_id='".$id."'");
$nombre_conjunto = mysql_query("select nombre from Proyecto where id = '$id.'");
$resu=mysql_fetch_array($nombre_conjunto);
?>
<html>
<head>
<title>Austral 3D</title>
<link href="../css/bootstrap.min.css" rel="stylesheet">
</head>
<body>
<center>
<nav class="navbar navbar-inverse navbar-fixed-top">
<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="">4D Plant</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><a href="formulario.php">PROYECTOS </a></li>
<li class="active"><a href="">ASSEMBLIES<span class="sr-only">(current)</span></a></li>
</ul>
<!--Derecha barra-->
<ul class="nav navbar-nav navbar-right">
<li class="dropdown">
<a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">Usuario: <?php if($_SESSION){echo $_SESSION['nombre'];}?></<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>
</center>
<br>
<br>
<br>
<br>
<div class="container">
<center>
<img src="../img/logo.jpg" class="img"/>
</center>
</div>
<br>
<br>
<div>
<form method="POST" action="edit.php">
<?php
$array = mysql_fetch_array($consultaA);
if($array[2]!= 0){
?>
<center>
<div class="container">
<div class="container-fluid">
<!-- Default panel contents -->
<h3><b>ASSEMBLIES: <?php echo $resu[0]; ?></b></h3>
<br>
<!-- Table -->
<table class="table table-bordered">
<?php
//Carga de tabla por tipo de rol usuario
if($rol == 1){ ?>
<tr class="active">
<th >ID</th>
<th>Nombre</th>
<th>Comienzo planificado</th>
<th>Fin planificado</th>
<th>Comienzo real</th>
<th>Fin real</th>
<td></td>
</tr>
<?php
//bucle de carga de la tabla
while($array = mysql_fetch_array($consulta))
{
?>
<tr>
<td align="center"><?php echo $array[0];?></a></td>
<td><a href="workpackage.php?idcon=<?php echo $array['id'];?>&rol=<?php echo $rol?>"><?php echo $array[1];?></a></td>
<td align="center"><?php echo $array[3];?></td>
<td align="center"><?php echo $array[4];?></td>
<td align="center"><?php echo $array[5];?></td>
<td align="center"><?php echo $array[6];?></td>
<td align="center"><a href="actualizar.php?id=<?php echo $array['id'];?>&rol=<?php echo $rol;?>">Modificar Fechas <a/></td>
</tr>
<?php
}
}else if($rol == 2)
{
?>
<tr class="active">
<th >ID</th>
<th>Nombre</th>
<th>Comienzo planificado</th>
<th>Fin planificado</th>
<th>Comienzo real</th>
<th>Fin real</th>
</tr>
<?php while($array = mysql_fetch_array($consulta))
{
?>
<tr>
<td align="center"><?php echo $array[0];?></td>
<td><a href="workpackage.php?idcon=<?php echo $array['id'];?>&rol=<?php echo $rol?>"><?php echo $array[1];?></a></td>
<td align="center"><?php echo $array[3];?></td>
<td align="center"><?php echo $array[4];?></td>
<td align="center"><?php echo $array[5];?></td>
<td align="center"><?php echo $array[6];?></td>
</tr>
<?php
}
}
?>
</table>
</div>
</div>
<?php
}else
{
echo
'<center>
<div class="container">
<p><h3><b>No se encontraron datos</b></h3></p>
</div>
</center>';
}
?>
</center>
</form>
</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 type="text/javascript" src="../js/functions.js"></script>-->
<!--<script type="text/javascript" src="../js/jquery.js"></script>-->
</body>
</html>