File: /home/austral3d/fourdplan.com/webservices3.0/mail.php
<?php
include ("Comun.php");
$db = Conectar();
date_default_timezone_set('America/Santiago');
$uploaddir = 'screenshots/';
$uploadfile = $uploaddir . basename($_FILES['file']['name']);
move_uploaded_file($_FILES['file']['tmp_name'], $uploadfile);
$language = $_POST['language'];
$assembly_id = $_POST['assembly_id'];
$progress = $_POST['progress'];
$comment = $_POST['message'];
$insert_notification = $_POST['notification'];
$owner_company = consultar("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 = consultar("SELECT p.nombre FROM Assembly a, Proyecto p WHERE a.proyecto_id = p.id AND a.id = '$assembly_id'");
$assembly_name = consultar("SELECT nombre FROM Assembly WHERE id = '$assembly_id'");
$image_url = 'http://www.fourdplan.com/webservices3.0/screenshots/' . $_FILES['file']['name'];
$date2 = date('Y:m:d');
if ($language == "english")
{
$subject = 'Fourdplan - Progress report';
$text1 = 'PROGRESS REPORT';
$text2 = 'PROJECT:';
$text3 = 'DATE:';
$date = date('m/d/Y');
$text4 = 'Model:';
$text5 = 'Progress:';
$text6 = 'PHOTOGRAPHIC RECORD:';
}
else
{
$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:';
}
// $to = 'jmarin@austral3d.com, ' . $_POST['addresses'];
// $message = '
// <html>
// <head>
// </head>
// <body>
// <div>
// <center>
// <img src="http://www.fourdplan.com/webservices3.0/banner2.jpg" height="107" width="765">
// <br style = "color: white;">.</br>
// <table style="width:100%;">
// <tr>
// <th style = "border: 1px solid black;">FOURDPLAN</th>
// <th style = "border: 1px solid black; font-size:22px;">' . $text1 . '</th>
// <th style = "border: 1px solid black;">' . $owner_company . '</th>
// </tr>
// </table>
// <table style="width:100%;">
// <tr>
// <td style = "border: 1px solid black; font-weight: bold;">' . $text2 . '</td>
// <td style = "border: 1px solid black;">' . $project . '</td>
// <td style = "border: 1px solid black; font-weight: bold;">' . $text3 . '</td>
// <td style = "border: 1px solid black;">' . $date . '</td>
// </tr>
// <tr>
// <td style = "border: 1px solid black; font-weight: bold;">' . $text4 . '</td>
// <td colspan="3" style = "border: 1px solid black;">' . $assembly_name . '</td>
// </tr>
// <tr>
// <td style = "border: 1px solid black; font-weight: bold;">' . $text5 . '</td>
// <td colspan="3" style = "border: 1px solid black;">' . $progress . '</td>
// </tr>
// <tr>
// <td colspan="4" style = "border: 1px solid black;">
// <center><br>' . $comment . '
// <br style = "color: white;">.</br>
// </center>
// </td>
// </tr>
// </table>
// </center>
// <br>
// <span style = "font-weight: bold;">' . $text6 . '</span>
// <table style="width:100%;">
// <tr>
// <td style = "border: 1px solid black;">
// <center>
// <img src="' . $image_url . '" height="395" width="700">
// </center>
// </td>
// </tr>
// </table>
// </div>
// </body>
// </html>';
// $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 = consultar("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 = consultar("SELECT p.id FROM Assembly a, Proyecto p WHERE a.proyecto_id = p.id AND a.id = '$assembly_id'");
if ($insert_notification == "true")
ejecutar("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')");
?>