-sub _build_table {
- my $headers = shift;
- my $data = shift;
- my $table = [];
- my $fields = [];
- my @db_columns = ();
- my ($row_index, $col_index) = (0,0);
- my $cols = 0; # number of columns to wrap on
- my $field_count = 0;
- POPULATE_HEADER:
- foreach my $db_column (@$headers) {
- my @key = keys %$db_column;
- push (@db_columns, $key[0]);
- $$fields[$col_index] = {select_field => 0, field_name => ($key[0]), field_label => $db_column->{$key[0]}};
- $field_count++;
- $col_index++;
- }
- $$table[$row_index] = {header_fields => $fields};
- $cols = $col_index;
- $field_count *= scalar(@$data); # total fields to be displayed in the table
- $col_index = 0;
- $row_index++;
- $fields = [];
- POPULATE_TABLE:
- foreach my $db_row (@$data) {
- my $element_id = 0;
- POPULATE_ROW:
- foreach my $db_column (@db_columns) {
- if (grep {$db_column eq $_} keys %$db_row) {
- $element_id = $db_row->{$db_column} if $db_column =~ m/id/;
- $$fields[$col_index] = {select_field => 0, field_name => ($db_column . "_tbl"), field_value => $db_row->{$db_column}};
- $col_index++;
- next POPULATE_ROW;
- }
- elsif ($db_column =~ m/^_((.*)_(.*$))/) { # this a special case
- my $table_name = get_table_names($2);
- my $record_set = SELECT($1, @$table_name[0], $2 . "_id = " . $db_row->{$2 . "_id"});
- $$fields[$col_index] = {select_field => 0, field_name => ($db_column . "_tbl"), field_value => $$record_set[0]{$1}};
- $col_index++;
- next POPULATE_ROW;
- }
- }
- $$fields[$col_index] = {select_field => 1, field_name => 'select', field_value => $element_id};
- $$table[$row_index] = {text_fields => $fields};
- $col_index = 0;
- $row_index++;
- $fields = [];
- }
- return $table;
-}