File: /home/austral3d/fourdplan.com/pruebas/php/mail.php
<?php
session_start();
require('conexion.php');
if(empty($_GET['lenguaje'])){
$lenguaje = false;
}else{
$lenguaje = $_GET['lenguaje'];
}
$no_id = $_GET['p'];
$notificacion = mysql_query("select * from Notificacion where id = '".$no_id."'");
if($notificacion){
while($array_noti= mysql_fetch_array($notificacion ))
{
$datos = $array_noti;
}
$proyecto = mysql_query("select nombre from Proyecto where id ='".$datos[1]."'");
$assembly = mysql_query("select nombre from Assembly where id ='".$datos[2]."'");
$empresa = mysql_query("select nombre from Empresa where id ='".$datos[3]."'");
$proy = mysql_result($proyecto,0,"nombre");
$asse = mysql_result($assembly,0,"nombre");
$empr = mysql_result($empresa,0,"nombre");
}
//notificacion leida-----------------------
$id_leidas = mysql_query("select id from NotificacionesLeidas order by id DESC limit 1");
if(mysql_num_rows($id_leidas)!=0){
$id = mysql_result($id_leidas,0,"id");
if($id == 0){
$id = 1;
}else{
$id += 1;
}
}else{
$id= 1;
}
//Marcar leida-----------------------
$consul_leida = mysql_query("select usuario_id from NotificacionesLeidas where usuario_id = '".$_SESSION['id']."' and notificacion_id = '".$no_id."'");
if(mysql_num_rows($consul_leida)==0){
$leida = mysql_query("INSERT INTO NotificacionesLeidas (id,usuario_id,notificacion_id) values('".$id."','".$_SESSION['id']."','".$datos[0]."')");
}
/*
$owner_company = mysql_query("SELECT e.nombre FROM Empresa e, Assembly a, Proyecto p WHERE a.proyecto_id = p.id AND p.empresa_id = e.id AND a.id = '$assembly_id'");
$project = mysql_query("SELECT p.nombre FROM Assembly a, Proyecto p WHERE a.proyecto_id = p.id AND a.id = '$assembly_id'");
$assembly_name = mysql_query("SELECT nombre FROM Assembly WHERE id = '$assembly_id'");
$image_url = 'http://www.fourdplan.com/webservices/screenshots/' . $_FILES['file']['name'];
$date2 = date('Y:m:d');
$to = 'nd0806@gmail.com, ' . $_POST['addresses'];*/
if ($lenguaje)
{
$subject = 'Fourdplan - Reporte de avance';
$text1 = 'REPORTE DE AVANCE';
$text2 = 'PROYECTO:';
$text3 = 'FECHA:';
$date = date('d/m/Y');
$text4 = 'Modelo en revisión:';
$text5 = 'Progreso:';
$text6 = 'REGISTRO FOTOGRÁFICO:';
}
else
{
$subject = 'Fourdplan - Progress report';
$text1 = 'PROGRESS REPORT';
$text2 = 'PROJECT:';
$text3 = 'DATE:';
$date = date('m/d/Y');
$text4 = 'Model:';
$text5 = 'Progress:';
$text6 = 'PHOTOGRAPHIC RECORD:';
}
/*$headers = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
$headers .= 'From: Austral3D <tecnologia@austral3d.com>' . "\r\n";
$mail_sent = mail($to, $subject, $message, $headers);
if ($mail_sent)
echo('Mail enviado');
else
echo('Error al enviar el mail');
$company_id = mysql_query("SELECT e.id FROM Empresa e, Assembly a, Proyecto p WHERE a.proyecto_id = p.id AND p.empresa_id = e.id AND a.id = '$assembly_id'");
$project_id = mysql_query("SELECT p.id FROM Assembly a, Proyecto p WHERE a.proyecto_id = p.id AND a.id = '$assembly_id'");
if ($insert_notification == "true")
mysql_query("INSERT INTO Notificacion(proyecto_id, assembly_id, empresa_id, progreso, mensaje, fecha, imagen_url) VALUES ('$project_id', '$assembly_id', '$company_id', '$progress', '$comment', '$date2', '$image_url')");
*/
?>
<!DOCTYPE html>
<html>
<head>
<title>Fourdplan</title>
<meta charset="UTF-8">
<link href="../css/bootstrap.min.css" rel="stylesheet">
<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">
<style type="text/css">
.scrollable-menu {
height: auto;
max-height: 200px;
overflow-x: hidden;
}
</style>
</head>
<body>
<div class="content">
<div>
<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>
<?php
if($lenguaje){
//español
?>
<!-- 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">
<!-- menu Proyecto -->
<li><a href="../index.php?lenguaje=true"><span class="glyphicon glyphicon-home" aria-hidden="true"></span> Inicio<span class="sr-only">(current)</span></a></li>
</ul>
<!--Derecha barra-->
<ul class="nav navbar-nav navbar-right">
<?php require("barrasuperior.php");?>
<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>
<li><a href="mail.php?p=<?php echo $proyecto_id;?>">Ingles</a></li>
</ul>
</li>
</ul>
</div><!-- /.navbar-collapse -->
<?php
}else{
//ingles
?>
<div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
<ul class="nav navbar-nav">
<!-- menu Proyecto -->
<li><a href="../index.php"><span class="glyphicon glyphicon-home" aria-hidden="true"></span> Home<span class="sr-only">(current)</span></a></li>
</ul>
<!--Derecha barra-->
<ul class="nav navbar-nav navbar-right">
<?php require("barrasuperior.php");?>
<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">Log Out</a></li>
<li><a href="mail.php?p=<?php echo $proyecto_id;?>&lenguaje=true">Spanish</a></li>
</ul>
</li>
</ul>
</div>
<?php
}
?>
</div><!-- /.container-fluid -->
</nav>
</div>
<br><br><br><br><br>
<div id="container" style="width: 60%; margin: 0 auto;">
<table class="table table-bordered" style="border:solid black; background-color:#c7c7c7;">
<tr>
<th style="border:1px solid black;">FOURDPLAN</th>
<th style="border:1px solid black;"><?php echo $text1 ;?></th>
<th style="border:1px solid black;"> <?php echo $empr;?></th>
</tr>
</table>
<table class="table table-bordered" style="border:solid black; background-color:#c7c7c7;">
<tr>
<td style = "border: 1px solid black; font-weight: bold;"><?php echo $text2;?></td>
<td style = "border: 1px solid black;"> <?php echo $proy;?></td>
<td style = "border: 1px solid black; font-weight: bold;"><?php echo $text3;?></td>
<td style = "border: 1px solid black;"><?php echo $datos[6];?></td>
</tr>
<tr>
<td style = "border: 1px solid black; font-weight: bold;"><?php echo $text4;?></td>
<td colspan="3" style = "border: 1px solid black;"><?php echo $asse;?></td>
</tr>
<tr>
<td style = "border: 1px solid black; font-weight: bold;"><?php echo $text5;?></td>
<td colspan="3" style = "border: 1px solid black;"><?php echo $datos[4];?></td>
</tr>
<tr>
<td colspan="4" style = "border: 1px solid black;">
<center>
<h3><?php echo $datos[5];?></h3>
<br>
</center>
</td>
</tr>
</table>
<br>
<span style = "font-weight: bold;"><?php echo $text6;?></span>
<table class="table table-bordered" style="border:solid black; background-color:#c7c7c7;">
<tr>
<td style = "border: 1px solid black;">
<center>
<img src="<?php echo $datos[7];?>" height="395" width="700">
</center>
</td>
</tr>
</table>
</div>
</div>
<!-- pie de pagina-->
<?php require("pie.php");?>
<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>