Top ↑

Methods #Methods

• add_order_by — Fills ORDER BY clause of SQL request based on user supplied parameters.
• add_sql_query_params — Updates the database query with parameters used for downloads report.
• add_time_period_sql_params — Gets WHERE time clause of SQL request with date-related constraints.
• assign_report_columns — Assign report columns once full table name has been assigned.
• get_data — Returns the report data based on parameters supplied by the user.
• get_excluded_customers — Returns comma separated ids of excluded customers, based on query arguments from the user.
• get_excluded_ip_addresses — Returns comma separated ids of excluded ip address, based on query arguments from the user.
• get_included_customers — Returns comma separated ids of included customers, based on query arguments from the user.
• get_included_ip_addresses — Returns comma separated ids of included ip address, based on query arguments from the user.
• initialize_queries — Initialize query objects.
• normalize_order_by — Maps ordering specified by the user to columns in the database/fields in the data.