public static function generateDateFilters($table_prefix = '', $date_field = 'UpdateDate')
{
$where_query = '';
$start_date = Controller::curr()->request->getVar('From');
$end_date = Controller::curr()->request->getVar('To');
if (!empty($table_prefix)) {
$table_prefix .= '.';
}
if (isset($start_date) && isset($end_date)) {
$date_from = Convert::raw2sql(trim($start_date));
$date_to = Convert::raw2sql(trim($end_date));
$start = new \DateTime($date_from);
$start->setTime(00, 00, 00);
$end = new \DateTime($date_to);
$end->setTime(23, 59, 59);
$where_query .= " ( {$table_prefix}{$date_field} >= '{$start->format('Y-m-d H:i:s')}' AND {$table_prefix}{$date_field} <= '{$end->format('Y-m-d H:i:s')}' ) ";
} else {
$start_date = self::$default_start_date;
$end_date = self::$default_end_date;
$where_query .= " ( {$table_prefix}{$date_field} >= '{$start_date}' AND {$table_prefix}{$date_field} <= '{$end_date}' ) ";
}
self::$date_filter_query = $where_query;
return $where_query;
}
