This function returns a reference to a hash containing all templates upon success and 1 upon failure. Errors are logged to the Apache log. examples: my $templates = get_all_templates();
This function returns a reference to a hash containing all layouts upon success and 1 upon failure. Errors are logged to the Apache log. examples: my $layouts = get_all_layouts();
This function returns an arrayref whose elements are hashes containing all profiles upon success and 1 upon failure. Errors are logged to the Apache log. Two parameters are accepted. The first limits the field(s) returned. This parameter should be string of comma separted fields. ie. "field_1, field_2, ...field_n" The second limits the records returned based on a string containing a valud SQL 'WHERE' filter. NOTE: Do not pass in the keyword 'WHERE.' examples: my $profiles = get_all_profiles(); my $profiles = get_all_profiles(field_list => field_list, filter => filter_string);
This function returns an arrayref whose elements are hashes containing the batch_ids of current batches along with the item count for each batch upon success and 1 upon failure. Item counts are stored under the key '_item_count' Errors are logged to the Apache log. One parameter is accepted which limits the records returned based on a string containing a valud SQL 'WHERE' filter. NOTE: Do not pass in the keyword 'WHERE.' examples: my $batches = get_batch_summary(); my $batches = get_batch_summary(filter => filter_string);
This function returns an arrayref whose elements are hashes containing the label_ids of current labels along with the item count for each label upon success and 1 upon failure. Item counts are stored under the key '_item_count' Errors are logged to the Apache log. One parameter is accepted which limits the records returned based on a string containing a valud SQL 'WHERE' filter. NOTE: Do not pass in the keyword 'WHERE.' examples: my $labels = get_label_summary(); my $labels = get_label_summary(items => @item_list);
This function returns an arrayref whose elements are hashes containing the label_ids of current cards along with the item count for each card upon success and 1 upon failure. Item counts are stored under the key '_item_count' Errors are logged to the Apache log. One parameter is accepted which limits the records returned based on a string containing a valud SQL 'WHERE' filter. NOTE: Do not pass in the keyword 'WHERE.' examples: my $cards = get_card_summary(); my $cards = get_card_summary(items => @item_list);
This function returns a reference to an array of hashes containing all barcode types along with their name and description. examples: my $barcode_types = get_barcode_types();
This function returns a reference to an array of hashes containing all label types along with their name and description. examples: my $label_types = get_label_types();
This function returns a reference to an array of hashes containing all font types along with their name and description. examples: my $font_types = get_font_types();
This function returns a reference to an array of hashes containing all text justification types along with their name and description. examples: my $text_justification_types = get_text_justification_types();
This function returns a reference to an array of hashes containing all unit types along with their description and multiplier. NOTE: All units are relative to a PostScript Point. There are 72 PS points to the inch. examples: my $unit_values = get_unit_values();
This function returns a reference to an array of hashes containing all label output formats along with their description. examples: my $label_output_formats = get_output_formats();
Return an arrayref of an array containing the column names of the supplied table.
Return an arrayref of an array containing the table names which contain the supplied search term.
This function returns an arrayref of an array of hashes contianing the supplied data formatted suitably to be passed off as a T::P template parameter and used to build an html table. examples: my $table = html_table(header_fields, array_of_row_data); $template->param( TABLE => $table, ); html example: <table> <!-- TMPL_LOOP NAME="TABLE" --> <!-- TMPL_IF NAME="header_fields" --> <tr> <!-- TMPL_LOOP NAME="header_fields" --> <th><!-- TMPL_VAR NAME="field_label" --></th> <!-- /TMPL_LOOP --> </tr> <!-- TMPL_ELSE --> <tr> <!-- TMPL_LOOP NAME="text_fields" --> <!-- TMPL_IF NAME="select_field" --> <td align="center"><input type="checkbox" name="action" value="<!-- TMPL_VAR NAME="field_value" -->" /></td> <!-- TMPL_ELSIF NAME="field_value" --> <td><!-- TMPL_VAR NAME="field_value" --></td> <!-- TMPL_ELSE --> <td> </td> <!-- /TMPL_IF --> <!-- /TMPL_LOOP --> </tr> <!-- /TMPL_IF --> <!-- /TMPL_LOOP --> </table>
Chris Nighswonger <cnighswonger AT foundations DOT edu>