Maxscape::Page::Table Package

Member Functions

1. addListToWhereClause
2. AttributeParameter
3. CGI_FieldKey
4. CGI_FieldKeyGetColumnKeyValue
5. CGI_FieldKeyGetColumnKeyValues
6. CGI_FieldKeyGetKey
7. CGI_FieldKeyToSelectedWhereClause
8. CGI_FieldKeyToWhereClause
9. changeField
10. displayColumnHeaders
11. displayDescField
12. displayDescRecord
13. displayField
14. displayRecord
15. displayTable
16. Error
17. escapeXML
18. FieldDescriptionToHTML
19. FormSelectGroupRecordElement
20. FormSelectGroupToWhereClause
21. getCGIRecordKey
22. getPageElementContent
23. getRecordKey
24. getTextType
25. insertRecord
26. insertRecords
27. isAKeyColumn
28. KeyColumnsToWhereClase
29. lastRowAsHash
30. lookupColumnDescriptions
31. new
32. NewlineToHTMLBreak
33. nextPreviousCounter
34. nextPreviousDisplay
35. nextPreviousDisplayTwo
36. nextPreviousQuery
37. nextPreviousSubmitBar
38. promptDescRecord
39. promptRecord
40. QueryColumnsToWhereClase
41. removeBlankHeaderTrailorLines
42. searchStringToWhereClause
43. selectRowsWidgetToWhereClause
44. setCGI_TableValuesByKey
45. TableField
46. TableIsEmpty
47. TableKey
48. TableLableHashValue
49. TableLables
50. TableValuesAndKeyFromCGI
51. updateRecord
52. Widget

Synopsis

use Maxscape::Page::Table;

Description

The package generalizes the handling of tables of the Content Database. It eases the programming greatly by providing methods to display, add, edit, etc. database tables via a web browser.

The class can be used in two modes depending on the TableType. In the default mode it tries to figure out how to handle a database field by its type and the parameters passed to the member methods. In this mode the best way to render table fields individually are callback functions passed as parameters to the methods. In the decribed mode the related entry of the TABLE_COLUMN_DESCRIPTION table defines how to render fields of the table to be displayed, edited, etc.

The introduction of a table that describes how to render the presentation of database tables has advantages compared to rendering each field of the table to be displayed individualy, because widgets can be reused. Instead of defining output code for each field of all tables, the related code is defined in the describing table. Thus the presentation of a database table field becomes an entry in the describing table. Instead of writing code for each table field, an entry in the describing table is necessary, only.

new

Synopsis

my $Table = new Maxscape::Page::Table ( %P );

Description

Creates a new 'Table' object.

Examples

my $Table = new Maxscape::Page::Table (
                  TableName         => 'HYPERLINKS',
                  TableType         => 'described',
                  Page              => $P{Page},
                  NoRowsMessage     => $P{NoRowsMessage},
                  ...
);

return $Page->TemplateContent (Name => 'Table.Tag') . $ColGroup

     . $Page->{Object}->displayTable (
           Columns                 => $QueryColumns,
           TableType               => $TableType,
           KeyColumns              => ['NUMBER'],
           # KeyColumns            => ['SENDER', 'NUMBER'],
           TableDescriptionKey     => $TableDescriptionKey,

           FieldCallback           => $FieldCallback,
           Action                  =>  'display',
           # Action                =>  $self->{Form}->{Action},

           selectRowsWidget        => 1,
           selectRowsWidgetHeader  => $selectRowsWidgetHeader,
           selectRowsWidgetTrailor => $selectRowsWidgetTrailor,

           displayColumnHeaders    => $displayColumnHeaders,
           ColumnHeadersHeader     => $ColumnHeadersHeader,
           ColumnHeadersTrailor    => $ColumnHeadersTrailor,

           RecordHeader            => $RecordHeader,
           RecordHeader2           => $RecordHeader2,
           RecordTrailor           => $RecordTrailor,

           FieldHeader             => $FieldHeader,
           FieldHeader2            => $FieldHeader2,
           FieldHeaderSpan2        => $FieldHeaderSpan2,
           FieldHeader2Span2       => $FieldHeader2Span2,
           FieldLabelTrailor       => $FieldLabelTrailor,
           FieldTrailor            => $FieldTrailor,

           where                   => $Page->{Object}->{CountWhere},
           order                   => $order,
           # group                 => $group,
           # count                 => $count,
           displayRowLimit         => $Page->{Object}->{displayRowLimit},
)  . "