Hi,
The code below checks the "Paid" reservations from the database and sends them as an email with a cron job.
Normally only "pay_url" data is added, yet I'd like to add "customer_name", "customer_surname" and "amount" too with pay_url.
Could you please guide me how to do it?
Thank you in advance.
<?php
include "../lib/include.php";
$yesterdayDate = date("Y-m-d 09:00:00", strtotime("-1 days"));
$query = "select * from links where status = 1 and cc_payment_id != '' and payment_date >= '".$yesterdayDate."' and payment_date <= '".date("Y-m-d 08:59:59")."'";
$q = $db->query($query);
foreach ($q AS $a) {
$mail_content .= "".$a["pay_url"]." -> Paid<br>";
}
if ($mail_content != "") {
SendMail($settings["system_email"],$mail_content,"Paid Reservations");
}