File: /home/austral3d/fourdplan.com/webservices/EnviarMailDataLoader.php
<?php
include ("Comun.php");
$db = Conectar();
$queriesString = file_get_contents('php://input');
$queries = explode(';', $queriesString);
$project_id = mysql_real_escape_string($_GET['project_id'], $db);
$user_id = mysql_real_escape_string($_GET['user_id'], $db);
$updates = mysql_real_escape_string($_GET['updates'], $db);
$deviations = mysql_real_escape_string($_GET['deviations'], $db);
$module = mysql_real_escape_string($_GET['module'], $db);
date_default_timezone_set('America/Santiago');
$owner_company = consultar("SELECT e.nombre FROM Empresa e, Proyecto p WHERE p.id = '$project_id' AND p.empresa_id = e.id");
$project = consultar("SELECT p.nombre FROM Proyecto p WHERE p.id = '$project_id'");
$user = consultar("SELECT mail FROM Usuario WHERE id = '$user_id'");
$date2 = date('Y:m:d');
$subject = 'Fourdplan - Notificación de inserción de datos';
$text1 = 'NOTIFICACIÓN DE INSERCIÓN DE DATOS';
$text2 = 'PROYECTO:';
$text3 = 'FECHA:';
$date = date('d/m/Y');
$comment = "El usuario " . $user . " ha insertado nuevos datos de " . $module . " del proyecto " . $project . " correspondiente a la fecha " . $date . ". ";
$comment .= "Han habido " . $updates . " actualizaciones y " . $deviations . " desviaciones.";
// $to = 'tecnologia@austral3d.com, nd0806@gmail.com, daniel@austral3d.com ,' . $user;
// //$to = 'nd0806@gmail.com';
// $message = '
// <html>
// <head>
// </head>
// <body>
// <div>
// <center>
// <img src="http://www.fourdplan.com/webservices/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 colspan="4" style = "border: 1px solid black;">
// <center><br>' . $comment . '
// <br style = "color: white;">.</br>
// </center>
// </td>
// </tr>
// </table>
// </center>
// <br>
// </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);
// $file = "../produccion/excels/revertir.txt";
// $myfile = fopen($file, "w");
// for ($i = 0; $i < count($queries) - 1; $i++)
// {
// $query = $queries[$i] . ";\n";
// $firstPos = strpos($query, "'", 0);
// $secondPos = strpos($query, "'", $firstPos + 1);
// $newQuery = substr($query, 0, $firstPos) . "'0000-00-00'" . substr($query, $secondPos + 1, strlen($query) - $secondPos - 1);
// fwrite($myfile, $newQuery);
// }
// fclose($myfile);
// if ($mail_sent)
// echo "Email enviado satisfactoriamente.";
// else
// echo "Error";
?>