function visitors_date_filter_sql_condition in Visitors 8

Same name and namespace in other branches

1. 8.2 visitors.module \visitors_date_filter_sql_condition()
2. 7.2 forms/date_filter.inc \visitors_date_filter_sql_condition()
3. 7 forms/date_filter.inc \visitors_date_filter_sql_condition()
4. 7.0 forms/date_filter.inc \visitors_date_filter_sql_condition()

Build sql query from date filter values.

Return value

string sql query.

15 calls to visitors_date_filter_sql_condition()

chart_visitors_monthly_history in reports/monthly_history.inc

Display monthly history chart report.

visitors_cities in reports/cities.inc

Display cities report.

visitors_city_hits in reports/city_hits.inc

Display city hits report.

visitors_countries in reports/countries.inc

Display countries report.

visitors_days_of_month_data in reports/days_of_month.inc

Get data for days of month report order the query based on a header array.

... See full list

File

forms/date_filter.inc, line 240

Date filter form for the visitors module.

Code

function visitors_date_filter_sql_condition(&$query) {
  visitors_set_session_date_range();
  $from = visitors_get_from_timestamp();
  $to = visitors_get_to_timestamp();
  $query
    ->condition('visitors_date_time', $from, '>');
  $query
    ->condition('visitors_date_time', $to, '<');
}