Esempi in PHP per report_customsql_substitute_user_token

Esempio n. 1

File: locallib.php Progetto: elliott2081/moodle-report_customsql

function report_customsql_prepare_sql($report, $timenow)
{
    global $USER;
    $sql = $report->querysql;
    if ($report->runable != 'manual') {
        list($end, $start) = report_customsql_get_starts($report, $timenow);
        $sql = report_customsql_substitute_time_tokens($sql, $start, $end);
    }
    $sql = report_customsql_substitute_user_token($sql, $USER->id);
    return $sql;
}

Esempio n. 2

File: report_test.php Progetto: brendanheywood/moodle-report_customsql

 public function test_report_customsql_substitute_user_token()
 {
     $this->assertEquals('SELECT COUNT(*) FROM oh_quiz_attempts WHERE user = 123', report_customsql_substitute_user_token('SELECT COUNT(*) FROM oh_quiz_attempts ' . 'WHERE user = %%USERID%%', 123));
 }