29 lines
724 B
PHP
29 lines
724 B
PHP
<?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);
|
|
}
|