File: /home/austral3d/fourdplan.com/php/workpackage.php
<?php
//INICIO VARIABLE SESION
session_start();
if ($_SESSION == NULL ){
echo'<script>
alert("Acceso denegado.")
self.location="index.php"
</script>';
}
//coneccion servidor y base de datos
require('conexion.php');
$idcon = $_GET['idcon'];
$rol= $_GET['rol'];
$con = mysql_query("select id, nombre, fecha_estimada_arribo, fecha_real_arribo from WorkPackage where conjunto_id = '".$idcon."'");
$cona = mysql_query("select id, nombre, fecha_estimada_arribo, fecha_real_arribo from WorkPackage where conjunto_id = '".$idcon."'");
$con_wp= mysql_query("select nombre from Conjunto where id = '$idcon'");
$resu = mysql_fetch_array($con_wp);
?>
<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><a href="javascript:history.go(-1);">ASSEMBLIES </a></li>
<li class="active"><a href="javascript:history.go();">WORKPACKAGE <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="" >
<?php
$array = mysql_fetch_array($cona);
if($array != 0){
?>
<center>
<div class="container">
<div class="container-fluid">
<!-- Default panel contents -->
<h3><b>WORKPACKAGES: <?php echo $resu[0]?></b></h3>
<br>
<!-- Table -->
<table class="table table-bordered">
<?php
if($rol == 1){
?>
<tr class="active">
<th>ID</th>
<th>Nombre</th>
<th>Fecha estimada arribo</th>
<th>Fecha real arribo</th>
<th></th>
</tr>
<?php
//bucle de carga de la tabla
while($array = mysql_fetch_array($con))
{
?>
<tr>
<td align="center"><?php echo $array[0];?></td>
<td><a href="partes.php?wpid=<?php echo $array['id'];?>&rol=<?php echo $rol?>"><?php echo $array[1];?></a></td>
<td align="center"><?php echo $array[2];?></td>
<td align="center"><?php echo $array[3];?></td>
<td align="center"><a href="actualizar_wp.php?idwp=<?php echo $array['id'];?>">Modificar Fechas <a/></td>
</tr>
<?php
}
}else if($rol == 2)
{
?>
<tr class="active">
<th>ID</th>
<th>Nombre</th>
<th>Fecha estimada arribo</th>
<th>Fecha real arribo</th>
</tr>
<?php
while($array = mysql_fetch_array($con))
{
?>
<tr>
<td align="center"><?php echo $array[0];?></td>
<td><a href="partes.php?wpid=<?php echo $array['id'];?>&rol=<?php echo $rol?>"><?php echo $array[1];?></a></td>
<td align="center"><?php echo $array[2];?></td>
<td align="center"><?php echo $array[3];?></td>
</tr>
<?php
}
}
}else
{
echo '<center>
<div class="container">
<p><h3><b>No se encontraron datos</b></h3></p>
</div>
</center>';
}
?>
</table>
</div>
</div>
</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>
</body>
</html>