<?php

define("CLI_SCRIPT", true);

require_once(__DIR__ . "/../../config.php");

$query = file_get_contents("query.sql");

$results = $DB->get_records_sql($query);
$fields = array("Email", "User Last Access", "Course ID", "Course Name", "Certificate Creation Date");

$date = date('Ymd', strtotime("-1 days"));
$mem = fopen("/replication/csv/" . $date . ".csv", "w");
$delim = ",";

fputcsv($mem, $fields, $delim);

foreach ($results as $result) {
        $resultfields = array(
                $result->email,
                $result->user_last_access,
                $result->id,
                $result->fullname,
                $result->certificate_created
        );

        fputcsv($mem, $resultfields, $delim);
}