<?php
if( !isset( $_GET['token'] ) || ( isset( $_GET['token'] ) && $_GET['token'] != "eFD6dx2G4RFBkrYS7Z87" ) ) die();

require_once("../includes/config.inc.php");

// Auf SMTP-Versand umgestellt? Dann erzeugt die Regel-Engine (payment_received) die Rechnungsmails – alter Erzeuger aus.
if ( class_exists( 'mailservice' ) && mailservice::smtpEnabled() ) { echo 'SMTP aktiv – Erzeugung läuft über die Mail-Regeln'; exit; }

global $oData;
global $oPDF;


$arrMails = $oData->rawQuery("
  SELECT
    b.booking_invoice AS invoice_id,
    c.customer_id,
    c.customer_firstname,
    c.customer_lastname,
    IF(c.customer_gender = 2, 'Frau', 'Herr') AS customer_gender,
    b.booking_no,
    i.invoice_no,
    c.customer_email,
    i.invoice_date,
    t.template_content,
    t.template_title,
    t.template_id
  FROM pacim_invoice i
    LEFT JOIN pacim_customer c ON c.customer_id = i.invoice_customer
    LEFT JOIN pacim_payments p ON p.payment_invoice = i.invoice_id
    LEFT JOIN pacim_booking b ON b.booking_invoice = i.invoice_id
    LEFT JOIN pacim_templates t ON t.template_id = 3
  WHERE
    ( ( DATE( i.invoice_date ) = DATE( NOW() ) ) OR ( DATE( p.payment_timestamp ) = DATE( NOW() ) ) )
    AND c.customer_source != 'AIDA' AND TRIM( COALESCE( c.customer_email, '') ) <>''
    AND TRIM( COALESCE(i.invoice_no, '') ) <>''
    AND ( SELECT COUNT( message_id ) FROM pacim_messages WHERE message_template = 3 AND message_customer = c.customer_id ) = 0
  LIMIT 5
");


//die();



if( !empty( $arrMails ) ) {

  foreach($arrMails as $mailKey => $mailTemplate) {


    $mailTemplate = (object) $mailTemplate;

    $createMails[ $mailKey ] = array(
        'message_status' => 0,
        'message_count' => 0,
        'message_template' => $mailTemplate->template_id,
        'message_customer' => $mailTemplate->customer_id,
        'message_invoice' => $mailTemplate->invoice_id,
        'message_booking' => 0,
        'message_sender' => 'info@parken-am-schiff.de',
        'message_receiver' => $mailTemplate->customer_email,
        'message_subject' => str_replace(
            array(
                  '[customer_gender]',
				  '[customer_firstname]',
                  '[customer_lastname]',
                  '[invoice_no]'
            ),
            array(
                  $mailTemplate->customer_gender == 2 ? "geehrte Frau" : "geehrter Herr",
				  $mailTemplate->customer_firstname,
                  $mailTemplate->customer_lastname,
                  $mailTemplate->invoice_no
            ),
            $mailTemplate->template_title
        ),
        'message_content' => str_replace(
            array(
                  '[customer_gender]',
				  '[customer_firstname]',
                  '[customer_lastname]',
                  '[invoice_no]'
            ),
            array(
                  $mailTemplate->customer_gender == 2 ? "geehrte Frau" : "geehrter Herr",
				  $mailTemplate->customer_firstname,
                  $mailTemplate->customer_lastname,
                  $mailTemplate->invoice_no
            ),
            $mailTemplate->template_content
        )
    );

    //print_r($createMails);

    //$oData->where('message_id', $data->message_id);
    $oData->insert('pacim_messages', $createMails[ $mailKey ]);
    $invDatas = $oData->dataSet( $mailTemplate->invoice_id );
    //print_r($invDatas);

    // Rechnung generieren
    $oPDF->createInvoice( $invDatas );


      //open connection
      /*$ch = curl_init(SITE_URL . "/ajax_request.php");
      curl_setopt( $ch, CURLOPT_POST, 1 );
      curl_setopt( $ch, CURLOPT_POSTFIELDS, array('mail_id' => $message['message_id']));
      $result = curl_exec( $ch );
      curl_close($ch);

      $mysql->where('message_id', $message['message_id']);
      $mysql->update('pacim_messages', array('message_status' => 1));*/
  }

  //echo "<pre>";
  //print_r( $createMails );
  //echo "</pre>";


    //echo count($arrMails) . " Mails versendet";
} else {
    echo "keine Mails zu erstellen";
}

//SELECT * FROM `pacim_invoice` WHERE DATE_FORMAT(invoice_datetime, "%Y-%m-%d") > "2018-12-10"