summaryrefslogtreecommitdiff
path: root/httemplate/elements/checkboxes-table-name.html
blob: 1638b9ca2cb67659aefbd9b170b68bc754787680 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
<%doc>

Example:

  include( '/elements/checkboxes-table-name.html',

    ###
    # required
    ###
    'link_table'      => 'table_name',
   
    'name_col' => 'name_column',
    #or
    'name_callback' => sub { },
   
    'names_list' => [ 'value',
                      'other value',
                      [ 'complex value' => { 'desc' => "Add'l description",
                                             'note' => '&nbsp;*',
                                           }
                      ],
                    ],
   
    ###
    # recommended (required?)
    ###
    'source_obj'   => $obj,
    #or?
    #'source_table' => 'table_name',
    #'sourcenum'    => '4', #current value of primary key in source_table
    #                       # (none is okay, just pass it if you have it)

    ###
    # optional
    ###
    'num_col' => 'col_name' #if column name is different in link_table than
                            #source_table
    'link_static' => { 'column' => 'value' },

  )

</%doc>

<TABLE CELLSPACING=0 CELLPADDING=0>

% foreach my $item ( @{ $opt{'names_list'} } ) {
%
%     my $name = ref($item) ? $item->[0] : $item;
%     ( my $display = $name ) =~ s/ /&nbsp;/g;
%     $display .= $item->[1]{note} if ref($item) && $item->[1]{note};
%     my $desc = ref($item) && $item->[1]{desc} ? $item->[1]{desc} : '';
%
%     my $checked;
%     if ( $cgi->param('error') ) {
%
%       $checked = $cgi->param($opt{'link_table'}. ".$name" )
%                    ? 'CHECKED'
%                    : '';
%
%     } else {
%
%       $checked =
%         qsearchs( $opt{'link_table'}, {
%                                         $source_pkey     => $sourcenum,
%                                         $opt{'name_col'} => $name,
%                                         %$link_static,
%                                       }                                 )
%                    ? 'CHECKED'
%                    : ''
%
%     }

  <TR>
    <TD VALIGN="top">
      <INPUT TYPE="checkbox" NAME="<% $opt{'link_table'}. ".$name" %>" <% $checked %> VALUE="ON">
    </TD>
    <TD><% $display %>
%     if ( $desc ) {
        <BR><FONT SIZE="-2"><% $desc %></FONT>
%     }
    </TD>
  </TR>

% } 

</TABLE>

<%init>

my( %opt ) = @_;

my( $source_pkey, $sourcenum, $source_obj );
if ( $opt{'source_obj'} ) {

  $source_obj = $opt{'source_obj'};
  #$source_table = $source_obj->dbdef_table->table;
  $source_pkey = $source_obj->dbdef_table->primary_key;
  $sourcenum = $source_obj->$source_pkey();

} else {

  #$source_obj?
  $source_pkey = $opt{'source_table'}
                   ? dbdef->table($opt{'source_table'})->primary_key
                   : '';
  $sourcenum = $opt{'sourcenum'};
}

$source_pkey = $opt{'num_col'} || $source_pkey;

my $link_static = $opt{'link_static'} || {};

</%init>