report_has_date()

Description

Checks for the presence of date placeholders in a report's SQL query.

Parameters

ColumnTypeDefaultDescription
$query string The report's SQL query.

Return

boolean Returns true if a date placeholder was found else false.

Location

include/reporting_functions.php lines 624 to 638

Definition

 
function report_has_date(string $query)
{
    $date_placeholders = array('[from-y]','[from-m]','[from-d]','[to-y]','[to-m]','[to-d]');
    $date_present = false;

    foreach ($date_placeholders as $placeholder) {
        $position = strpos($query, $placeholder);
        if ($position !== false) {
            $date_present = true;
            break;
        }
    }

    return $date_present;
}

This article was last updated 7th April 2025 10:05 Europe/London time based on the source file dated 21st January 2025 15:20 Europe/London time.