<<

NAME

C4::Reports - Module for generating reports

SYNOPSIS

  use C4::Reports;

DESCRIPTION

METHODS

get_report_types()

This will return a list of all the available report types

get_report_areas()

This will return a list of all the available report areas

get_all_tables()

This will return a list of all tables in the database

get_columns($area)

This will return a list of all columns for a report area

build_query($columns,$criteria,$orderby,$area)

This will build the sql needed to return the results asked for, $columns is expected to be of the format tablename.columnname. This is what get_columns returns.

get_criteria($area,$cgi);

Returns an arraref to hashrefs suitable for using in a tmpl_loop. With the criteria and available values.

save_report($sql,$name,$type,$notes)

Given some sql and a name this will saved it so that it can resued

create_compound($masterID,$subreportID)

This will take 2 reports and create a compound report using both of them

get_column_type($column)

This takes a column name of the format table.column and will return what type it is (free text, set values, date)

get_distinct_values($column)

Given a column name, return an arrary ref of hashrefs suitable for use as a tmpl_loop with the distinct values of the column

AUTHOR

Chris Cormack <crc@liblime.com>

POD ERRORS

Hey! The above document had some coding errors, which are explained below:

Around line 647:

You forgot a '=back' before '=head1'

<<