[MySQLTableReport] element index

Package indexes

• default
• QueryTableParser
• Loader
• Anemometer
• QueryExplain
• AnemometerModel

__construct

MySQLTableReport::__construct() in MySQLTableReport.php

create a new instance, pass configuration information describing the datasource and the report tables and fields.

clear

MySQLTableReport::clear() in MySQLTableReport.php

Remove blank strings as values in form fields.

date_range

MySQLTableReport::date_range() in MySQLTableReport.php

look for a range of date values for the given column, and return values to be added to the WHERE clause

execute

MySQLTableReport::execute() in MySQLTableReport.php

Execute the generated query on the configured databse and return a result handle

from

MySQLTableReport::from() in MySQLTableReport.php

define the primary table to select from

ge

MySQLTableReport::ge() in MySQLTableReport.php

apply a "greater than or equal to" operator to a WHERE condition, instead of the default equality matching

get_column_names

MySQLTableReport::get_column_names() in MySQLTableReport.php

retuns a list of all column names. These will be exactly the same as the columns returned by the query.

get_custom_fields

MySQLTableReport::get_custom_fields() in MySQLTableReport.php

returns a list of custom fields names.

get_distinct_values

MySQLTableReport::get_distinct_values() in MySQLTableReport.php

given a table and column, find all the unique values. This is a utility method often used when building dropdown lists on a search form, or getting values for pivot operations.

get_form_fields

MySQLTableReport::get_form_fields() in MySQLTableReport.php

return the list of form fields defined by the configuration parameters used to construct this object. Field names are prefixed by the table *alias*

get_form_field_values

MySQLTableReport::get_form_field_values() in MySQLTableReport.php

return an associate array with form_field_name => value for all fields.

get_pivot_values

MySQLTableReport::get_pivot_values() in MySQLTableReport.php

return the list of values for a given pivot column

get_search_uri

MySQLTableReport::get_search_uri() in MySQLTableReport.php

return a urlencoded string of parameters that were used in this report.

get_tables

MySQLTableReport::get_tables() in MySQLTableReport.php

returns the list of table names, not the aliases

get_table_by_alias

MySQLTableReport::get_table_by_alias() in MySQLTableReport.php

gets the concrete name of a table for the given alias

get_table_fields

MySQLTableReport::get_table_fields() in MySQLTableReport.php

select the field names for the report tables from the database.

group

MySQLTableReport::group() in MySQLTableReport.php

set the GROUP BY expression

gt

MySQLTableReport::gt() in MySQLTableReport.php

greater than: see documentation for ge()

having

MySQLTableReport::having() in MySQLTableReport.php

set the HAVING clause

join

MySQLTableReport::join() in MySQLTableReport.php

add a table to the JOIN clause

le

MySQLTableReport::le() in MySQLTableReport.php

less than or equal to: see documentation for ge()

like

MySQLTableReport::like() in MySQLTableReport.php

like: see documentation for ge()

limit

MySQLTableReport::limit() in MySQLTableReport.php

set the LIMIT clause

lt

MySQLTableReport::lt() in MySQLTableReport.php

less than: see documentation for ge()

MySQLTableReport

MySQLTableReport in MySQLTableReport.php

class MySQLTableReport Generic reporting class. Given a configuration file, that describes the tables and fields to be searched, and information to connect to a database, take form data and generate an SQL query to run.

MySQLTableReport.php

MySQLTableReport.php in MySQLTableReport.php

ne

MySQLTableReport::ne() in MySQLTableReport.php

not equals: see documentation for ge()

order

MySQLTableReport::order() in MySQLTableReport.php

set the ORDER BY clause

pivot

MySQLTableReport::pivot() in MySQLTableReport.php

preform a pivot on a column. Get the unique list of values

process_form_data

MySQLTableReport::process_form_data() in MySQLTableReport.php

Read all form data and process values. This will be called automatically by query() and execute() methods.

query

MySQLTableReport::query() in MySQLTableReport.php

generate the SQL query and return it as a string.

raw_where

MySQLTableReport::raw_where() in MySQLTableReport.php

raw_where is an unprocessed string that is added to the WHERE clause

select

MySQLTableReport::select() in MySQLTableReport.php

add a column to the select field list

set_pivot_values

MySQLTableReport::set_pivot_values() in MySQLTableReport.php

pivot operations require some setup -- this defines the list of values to turn into additional columns when we ask the report to pivot a column.

where

MySQLTableReport::where() in MySQLTableReport.php

add a condition to the WHERE clause.