set_charset("utf8mb4");
$result = mysqli_query($conn, "SELECT * FROM wpeu_parking_bookings WHERE book_end = CURDATE()");
if (mysqli_num_rows($result) > 0) {
while($row = mysqli_fetch_assoc($result)) {
if (mysqli_query($conn, "INSERT INTO wpeu_parking_bookings_archive SELECT * FROM wpeu_parking_bookings WHERE id = ".$row["id"])) {
try {
$SeeMe->sendSMS(
'36307688404',
'1082DEL='.$row["sim_position"]
);
print_r( $SeeMe->getResult() );
try {
$mail->clearAddresses();
$mail->clearAttachments();
$mail->isSMTP();
$mail->Host = 'mail.karancsgarazs.hu';
$mail->SMTPAuth = true;
$mail->Username = 'noreply@karancsgarazs.hu';
$mail->Password = '}`5P8&b1nMVt';
$mail->Port = 587;
$mail->setFrom('noreply@karancsgarazs.hu', 'Karancs Garázs');
$mail->CharSet = 'UTF-8';
$mail->addAddress("info@karancsgarazs.hu");
$mail->addBCC("mail@jnsngy.hu");
$mail->isHTML(true);
$mail->Subject = 'Bérlet törölve';
$mail->Body = ''.$row["book_start"].'-'.$row["book_end"].'
Név: '.$row['name'].'
Telefonszám / SIM pozíció: '.$row["phone"].' / '.$row["sim_position"].'
E-mail cím: '.$row["email"].'
';
echo $mail->Body;
$mail->send();
echo 'Az e-mail sikeresen elküldve.';
} catch (Exception $e) {
echo "Hiba történt az e-mail küldésekor: {$mail->ErrorInfo}";
}
try {
$mail2->clearAddresses();
$mail2->clearAttachments();
$mail2->isSMTP();
$mail2->Host = 'mail.karancsgarazs.hu';
$mail2->SMTPAuth = true;
$mail2->Username = 'noreply@karancsgarazs.hu';
$mail2->Password = '}`5P8&b1nMVt';
$mail2->Port = 587;
$mail2->setFrom('noreply@karancsgarazs.hu', 'Karancs Garázs');
$mail2->CharSet = 'UTF-8';
$mail2->addAddress($row["email"]);
$mail2->addBCC("mail@jnsngy.hu");
$mail2->isHTML(true);
$mail2->Subject = 'Karancs Garázs bérlet törlésre került';
$mail2->Body = 'Kedves Ügyfelünk!
A mai napon deaktiváltuk a bérleted. Ha időközben meghosszabbítottad, tekintsd tárgytalannak az üzenetet.
';
echo $mail2->Body;
$mail2->send();
echo 'Az e-mail sikeresen elküldve.';
} catch (Exception $e) {
echo "Hiba történt az e-mail küldésekor: {$mail2->ErrorInfo}";
}
} catch ( Exception $e ) {
print_r( $SeeMe->getResult() );
die();
}
if (mysqli_query($conn, "DELETE FROM wpeu_parking_bookings WHERE id = ".$row["id"])) {
echo "törölve";
}
}
}
} else {
echo "Nincs lejáró bérlet.";
}
?>