<?php
require_once("general_conn.php");
//Import PHPMailer classes into the global namespace
//These must be at the top of your script, not inside a function


use PHPMailer\PHPMailer\PHPMailer;
use PHPMailer\PHPMailer\SMTP;
use PHPMailer\PHPMailer\Exception;

//Load Composer's autoloader
require 'PHPMailer-master/vendor/autoload.php';

//Create an instance; passing `true` enables exceptions
$mail = new PHPMailer(true);
$JSON_string = base64_decode($_GET[data]);
$obj = json_decode(utf8_encode($JSON_string),true);
//var_dump($obj);
if($obj["status"]!="COMPLETED"){
    echo "Ocurrió un error";
    exit;
}else{

     mysql_select_db($database_general_conn, $general_conn);
 $query_rs1     = "SELECT * FROM xor_orders WHERE order_id = '".$obj["id"]."' ";
$rs1           = mysql_query($query_rs1, $general_conn) or die(mysql_error());
$row_rs1       = mysql_fetch_assoc($rs1);
$totalRows_rs1 = mysql_num_rows($rs1); 
if($totalRows_rs1==0){
     mysql_select_db($database_general_conn, $general_conn);
$query_rs1     = "INSERT INTO xor_orders (order_id, payer_id, payer_name, payer_last, payer_email, product_description, order_metadata) VALUES ('".$obj["id"]."', '".$obj["payer"]["payer_id"]."', '".$obj["payer"]["name"]["given_name"]."', '".$obj["payer"]["name"]["surname"]."', '".$obj["payer"]["email_address"]."', '".$obj["purchase_units"][0]["description"]."', '".$_GET[data]."');";
$rs1           = mysql_query($query_rs1, $general_conn) or die(mysql_error());
}else{
    if($row_rs1["order_status"]=="1"){
        echo "<h2>Esta orden ya expiró</h2>";
        exit;
}
}
echo "<link href=\"css/style.css\" rel=\"stylesheet\" type=\"text/css\">

<link rel=\"stylesheet\" href=\"css/style.css\">

<center>

<img width=\"100%\" src=\"https://www.wintergenomics.com/wp-content/uploads/2022/03/Copia-de-Arcoi%CC%81ris-Google-Classroom-Encabezado-4.png\"></center>


<center>
  <div class=\"numero3\">

<p class=\"letra\" style=\"color:#06b2f1\">GRACIAS</p>
<p class=\"letra2\" style=\"color:#000000\">POR SU COMPRA</p>

<p class=\"letra3\" style=\"color:#000000\">Hemos enviado un link a tu correo para concluir con tu registro. </p><p class=\"letra4\" style=\"color:#000000\">Asegúrate de revisar tu carpeta de SPAM o correos no deseados.</p><p class=\"letra5\" style=\"color:#000000\"> Si no recibiste el correo, escríbenos a cursos@wintergenomics.com para poder asesorarte.</p>


<br></br>
<br></br><br></br>
<br></br>
<br></br>
<br></br>
<br></br>
<img src=\"images/redes.png\" width=\"150\" height=\"60\">

  </div>
</center>

</body>
"; 


	
    $curso = htmlentities($obj["purchase_units"][0]["description"]);
    
}
try {
    //Server settings
    //$mail->SMTPDebug = SMTP::DEBUG_SERVER;                      //Enable verbose debug output
    $mail->isSMTP();                                            //Send using SMTP
    $mail->Host       = 'smtp.gmail.com';                     //Set the SMTP server to send through
    $mail->SMTPAuth   = true;                                   //Enable SMTP authentication
    $mail->Username   = 'noreply@wintergenomics.com';                     //SMTP username
    $mail->Password   = 'voczclqfobumzqmp';                               //SMTP password
    $mail->SMTPSecure = PHPMailer::ENCRYPTION_SMTPS;            //Enable implicit TLS encryption
    $mail->Port       = 465;                                    //TCP port to connect to; use 587 if you have set `SMTPSecure = PHPMailer::ENCRYPTION_STARTTLS`

    //Recipients
    $mail->setFrom('noreply@wintergenomics.com', 'Winter Genomics');
   // $mail->addAddress('hola@wintergenomics.com', 'Winter');     //Add a recipient
    $mail->addAddress($obj["payer"]["email_address"]);               //Name is optional
    $mail->addReplyTo('cursos@wintergenomics.com', 'Winter Genomics');
    $mail->addBCC('cursos@wintergenomics.com');
	$mail->addBCC('hola@wintergenomics.com');
    $mail->addBCC('redes@xorverel.com');

    //Attachments
    //$mail->addAttachment('/var/tmp/file.tar.gz');         //Add attachments
   // $mail->addAttachment('/tmp/image.jpg', 'new.jpg');    //Optional name

    //Content
    
    $mail->isHTML(true);                                  //Set email format to HTML
    $mail->Subject = 'Winter School - Bienvenido';
    $mail->Body    = 'Estimad(a) '.$obj["payer"]["name"]["given_name"].'. 
    <div class="gmail_default">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div class="gmail_default">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div class="gmail_default">
<div>
<div class="gmail_default">&nbsp;</div>
<div class="gmail_default">Gracias por tu pago.&nbsp;</div>
<div class="gmail_default"><strong>Orden de compra: <span style="color: #000000;">'.$obj["id"].'</span></strong></div>
<div class="gmail_default">&nbsp;</div>
<div class="gmail_default"><span style="color: #000000;">En caso de requerir factura, env&iacute;anos tus datos de facturaci&oacute;n a cursos@wintergenomics.com</span></div>
<div class="gmail_default">&nbsp;</div>
<div class="gmail_default">Para acceder al curso, completa tu registro en el siguiente link:</div>
<div class="gmail_default"><span style="color: #000000;"> https://www.wintergenomics.com/xor/register.php?order_id='.$obj["id"].'
 </span></div>
<div class="gmail_default">&nbsp;</div>
</div>
<div><span style="color: #000000;"><strong>&nbsp;</strong></span></div>
</div>
<div class="gmail_default">
<div class="gmail_default">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div class="gmail_default">
<div><strong><span style="color: #000000;">Este correo se genera autom&aacute;ticamente, favor de no responder a este mensaje. En caso de alg&uacute;n problema o dudas, env&iacute;anos un correo a <u><a href="mailto:cursos@wintergenomics.com" target="_blank" rel="noopener">cursos@wintergenomics.com</a></u>.</span></strong></div>
<div><strong><span style="color: #000000;">&nbsp;</span></strong></div>
<div>
<div>Atentamente,</div>
<div>&nbsp;</div>
<div>Winter School</div>
</div>
<div>&nbsp;</div>
<div>&nbsp;</div>
<div>--</div>
</div>
</div>
</div>
</div>
<div class="gmail_signature" dir="ltr" data-smartmail="gmail_signature">
<div dir="ltr">
<div dir="ltr">
<div>
<div><strong><span style="color: #45818e; font-size: xx-small;">S&iacute;guenos en nuestras redes sociales y&nbsp;&iexcl;&Uacute;nete a la revoluci&oacute;n gen&oacute;mica!&nbsp; &nbsp;</span></strong></div>
<div><span style="font-size: xx-small;"><strong><span style="color: #000000;">Conoce m&aacute;s:&nbsp;</span><span style="color: #0000ff;"><a href="https://www.wintergenomics.com/" target="_blank" rel="noopener">https://www.wintergenomics.com/</a></span></strong></span></div>
<div><span style="color: #000000; font-size: xx-small;"><a href="https://www.facebook.com/wintergenomics/" target="_blank" rel="noopener">Facebook,</a>&nbsp;&nbsp;</span><span style="color: #000000; font-size: xx-small;"><a href="https://www.youtube.com/c/WinterGenomics/" target="_blank" rel="noopener">Youtube</a>,&nbsp;</span><span style="color: #000000; font-size: xx-small;"><a href="https://twitter.com/wintergenomics/" target="_blank" rel="noopener">Twitter</a></span><span style="color: #0000ff; font-size: xx-small;">, <a href="https://www.instagram.com/wintergenomics/">Instagram</a></span></div>aquiiii
</div>
</div>
<div dir="ltr"><img src="https://docs.google.com/uc?export=download&amp;id=1z3buwroZZXc2rQtUSSsAd4xNEPqQM7Zu&amp;revid=0Bx5BBUhuZAk1VlZKeHdZNUN1cm1uYmpOQ0VpTy9IVlhLY1U4PQ" /></div>
<div dir="ltr"><span style="color: #000000; font-size: xx-small;"><em>El contenido de este mensaje de datos es confidencial y se entiende dirigido y para uso exclusivo del destinatario, por lo que no podr&aacute; distribuirse y/o difundirse por ning&uacute;n medio sin la previa autorizaci&oacute;n del emisor original. Si usted no es el destinatario, se le proh&iacute;be su utilizaci&oacute;n total o parcial para cualquier fin.</em></span></div>
</div>
</div>
</div>
</div>
</div>
';
    $mail->send();
   // echo 'Message has been sent';
} catch (Exception $e) {
    echo "Message could not be sent. Mailer Error: {$mail->ErrorInfo}";
}