<?

include "db.class.php";
include "email.class.php";

$html = "";
$db = new db();

$fuel = $db->exec_query('fuel_movement', ['*'], '', '', '', '', 'tank_id = 3 AND sent_email != 1 AND date_time_closed != "" ', "ORDER BY record_id ASC");

while ($fuel_tran = $fuel->fetch_assoc()) {

    // if (count($amlost_due) > 1) {
    $email_send = new email();
    $em = ['chris@elegantwork.co.za', 'kayde@muellestates.co.za'];
    $names = ['CP', 'KAYDE'];
    if($email_send->send_mail($em, $names, "<h1>DIESEL TRANSACTION SUCCESSFULL</h1><br><hr><br> Amount : {$fuel_tran['amount']} <br> Date: {$fuel_tran['date_time_opened']} <br> Status : {$fuel_tran['status']}", "DIESEL TRANSACTION")){
        $db->Update('fuel_movement',['sent_email'],[1],"record_id = {$fuel_tran['record_id']}");
    }
}
