<?php

	$server = "YDAWBH119";
	$database_naam = "ml";
	$gebruikersnaam = "mailing";
	$wachtwoord = "mailing123";
	$datum_vandaag = date('Y-m-d');
	$jaar = date('Y');
	$maand = date('m');
	$dag = date('d');
	
	require_once('class.phpmailer.php');
	$conn_send=mysql_connect('YDAWBH119', 'mailing', 'mailing123');
	mysql_select_db('ml');

	$query_adressen = "SELECT kes_send_table.send_id, kes_send_table.afzender_emailadres, kes_send_table.afzender_naam, kes_send_table.ontvanger_emailadres, kes_send_table.ontvanger_naam, kes_send_table.onderwerp, kes_send_table.inhoud, kes_send_table.verzend_datum FROM kes_send_table WHERE YEAR(kes_send_table.verzend_datum) <= '$jaar' AND MONTH(kes_send_table.verzend_datum) <= '$maand' AND DAY(kes_send_table.verzend_datum) <= '$dag' ORDER BY kes_send_table.verzend_datum ASC LIMIT 0,1500";
		
	$res_adressen = mysql_query($query_adressen);
	
	$counter = 0;
	
	if($res_adressen){
	
		$mail                = new PHPMailer(true);

		$mail->IsSMTP(); 						// telling the class to use SMTP
   		$mail->Host       = "email-smtp.eu-west-1.amazonaws.com"; // SMTP server
		$mail->SMTPKeepAlive = true;           	// SMTP connection will not close after each email sent
		$mail->SMTPAuth   = true;                  // enable SMTP authentication
		$mail->Port       = 587;                    // set the SMTP port for the GMAIL server
		$mail->SMTPSecure = "tls";                  // Use TLS for sending
   		$mail->Username = "AKIAJP4NUEJHDEQECCWQ"; // SMTP username
    	$mail->Password = "AhgpQLX+xCDcdi9Pkn1XYUzDH1s9kr/TcehCDNnRuyJf"; // SMTP password
		
		$eerste = true;
    
		while ($row = mysql_fetch_array($res_adressen)) 
		{
			try {
          if($eerste){
            $eerste = false;
            $org_verzend_datum = $row['verzend_datum'];
          }			
          
          $onderwerp = stripslashes($row['onderwerp']);
          $inhoud = stripslashes($row['inhoud']);
                
          $mail->SetFrom($row['afzender_emailadres'], $row['afzender_naam']);
          $mail->AddReplyTo($row['afzender_emailadres'], $row['afzender_naam']);
          
          $mail->Subject = $onderwerp;
          $mail->MsgHTML($inhoud);
          $mail->AddAddress($row['ontvanger_emailadres'], $row['ontvanger_naam']);
		  //$mail->AddAttachment("D:\HostingSpaces\SBogers10\komma-mediadesign.nl\kes\happy_holidays.jpg", "happy_holidays.jpg");
		  $mail->AddAttachment("D:\\HostingSpaces\\SBogers10\\komma-mediadesign.nl\\kes\\rooymans_neveroutofstock_2016_retail.pdf", "rooymans_neveroutofstock_2016_retail.pdf");
		  //$mail->AddAttachment("D:\HostingSpaces\SBogers10\komma-mediadesign.nl\kes\prints_price_list.pdf", "prints_price_list.pdf");
		  //$mail->AddAttachment("D:\HostingSpaces\SBogers10\komma-mediadesign.nl\kes\systems_price_list.pdf", "systems_price_list.pdf");
		  //$mail->AddAttachment("D:\HostingSpaces\SBogers10\komma-mediadesign.nl\kes\augmentation_de_prix_2015.pdf", "augmentation_de_prix_2015.pdf");
        
          $mail->Send();
          $query_delete = sprintf("DELETE FROM kes_send_table WHERE kes_send_table.send_id = '%s'", $row['send_id']);
          $res_delete = mysql_query($query_delete);
          $counter = $counter + 1;
        } 
        catch (phpmailerException $e) {
            $error = strip_tags($e->errorMessage()); //Pretty error messages from PHPMailer
            $datum = date("Y-m-d");
            $tijd = date("H:i:s");
            
            $query_error = sprintf("INSERT INTO kes_send_errors (afzender_emailadres, afzender_naam, ontvanger_emailadres, ontvanger_naam, onderwerp, inhoud, verzend_datum, invoeg_datum, tijd, error_description) VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')", 
              $row['afzender_emailadres'],
              addslashes($row['afzender_naam']),
              $row['ontvanger_emailadres'],
              addslashes($row['ontvanger_naam']),
              addslashes($row['onderwerp']),
              addslashes($row['inhoud']),
              $row['verzend_datum'],
              $datum,
              $tijd,
              $error);
             $res_error = mysql_query($query_error);
            
            $query_delete = sprintf("DELETE FROM kes_send_table WHERE kes_send_table.send_id = '%s'", $row[0]);
            $res_delete = mysql_query($query_delete);
            
            $error_counter = $error_counter + 1;
            echo($error . "\n");
        } 
        catch (Exception $e) {
            $error = strip_tags($e->errorMessage()); //Boring error messages from anything else!
            $datum = date("Y-m-d");
            $tijd = date("H:i:s");
            
            $query_error = sprintf("INSERT INTO kes_send_errors (afzender_emailadres, afzender_naam, ontvanger_emailadres, ontvanger_naam, onderwerp, inhoud, verzend_datum, invoeg_datum, tijd, error_description) VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')", 
              $row['afzender_emailadres'],
              addslashes($row['afzender_naam']),
              $row['ontvanger_emailadres'],
              addslashes($row['ontvanger_naam']),
              addslashes($row['onderwerp']),
              addslashes($row['inhoud']),
              $row['verzend_datum'],
              $datum,
              $tijd,
              $error);
              $res_error = mysql_query($query_error);
            
            $query_delete = sprintf("DELETE FROM kes_send_table WHERE kes_send_table.send_id = '%s'", $row[0]);
            $res_delete = mysql_query($query_delete);
            
            $error_counter = $error_counter + 1;
            echo($error . "\n");
        }
           // Clear all addresses and attachments for next loop
          $mail->ClearAddresses();
          $mail->ClearAttachments();
      }

      $datum = date("Y-m-d");
      $tijd = date("H:i:s");  
      
      if($counter > 0 || $error_counter > 0){
        $query_history = sprintf("INSERT INTO kes_send_history(aantal, niet_verzonden, verzend_datum, werkelijke_datum, tijd) VALUES ('%s', '%s', '%s', '%s', '%s')", $counter, $error_counter, $org_verzend_datum, $datum, $tijd);
        $res_history = mysql_query($query_history);
      }
	}
?>