@_UI_STD_INIT_@ [calc] return unless $CGI->{mv_more_ip}; $CGI->{mv_data_table} = $Values->{mv_data_table}; return; [/calc] [seti page_title] [either] [cgi page_title] [or] [L]Spreadsheet Edit:[/L] [cgi mv_data_table] [/either] [/seti] [seti page_banner] [either] [cgi page_banner] [or] [L]Spreadsheet Edit:[/L] [page href=__UI_BASE__/db_metaconfig form=" ui_table=[cgi mv_data_table] ui_view=[cgi ui_meta_view] start_at=extended.spread_height "][cgi mv_data_table] [/either] [/seti] [set ui_class]Admin[/set] [seti help_name][either][cgi help_name][or]gensql.main[/either][/seti] [seti icon_name][either][cgi icon_name][or]icon_config.gif[/either][/seti] @_UI_STD_HEAD_@ [tmp extra_title] [loop list="[cgi mv_data_table]"] [if-loop-data __UI_META_TABLE__ name] [loop-data __UI_META_TABLE__ name] [/if-loop-data] [if-loop-data __UI_META_TABLE__ help_url] help [/if-loop-data] [if-loop-data __UI_META_TABLE__ help] [loop-data __UI_META_TABLE__ name] [/if-loop-data] [/loop] [/tmp] [calc] $Scratch->{page_banner} .= $Scratch->{extra_title}; $Scratch->{page_title} .= $Scratch->{extra_title}; return; [/calc] [output name=search_box]
[output name=""] [perl tables="[cgi mv_data_table] __UI_META_TABLE__"] my $table = $CGI->{mv_data_table}; my $db = $Db{$table}; my $mrec = $Tag->meta_record($table, $CGI->{ui_meta_view}) || {}; my $sp = q{@@MV_PAGE@@}; $mrec ||= {}; $mrec->{spread_fields} ||= join(" ", $db->columns()); $mrec->{spread_height} ||= 10; my $key = $CGI->{ui_data_key_name} = $db->config('KEY'); $mrec->{spread_sort} ||= $key; $CGI->{ui_description_field} = $mrec->{label}; my $qualbase = qq{ sp=$sp st=db ml=$mrec->{spread_height} ms=0 }; my $qualsimple = qq{ fi=$table rf=$CGI->{ui_data_key_name} tf=$mrec->{spread_sort} }; my $qual; my $sstring; if(! $CGI->{ui_text_qualification}) { $qual = "ra=yes"; } elsif ($CGI->{ui_text_qualification} =~ /^\s*select/ ) { $qual = "sq=$CGI->{ui_text_qualification}"; $sstring = join "\n", $qualbase, $qual; } elsif ($CGI->{ui_text_qualification} =~ /=/ ) { my ($f, $s) = split /\s*=\s*/, $CGI->{ui_text_qualification} , 2; $qual = "co=1\nop=eq\nse=$s\nsf=$f"; } elsif ($CGI->{ui_text_qualification}) { $qual = "se=$CGI->{ui_text_qualification}\nsu=1"; } else { $qual = "ra=yes"; } $sstring ||= join "\n", $qualbase, $qualsimple, $qual; my @fields = split /[\0\s,]+/, $mrec->{spread_fields}; @fields = grep length($_) && $_ ne $key, @fields; $CGI->{mv_data_fields} = join " ", @fields; $CGI->{mrec_textarea_rows} ||= 4; $CGI->{mrec_spread_width} ||= $mrec->{spread_width} || 12; $Scratch->{mrec_options} = $sstring; $Scratch->{ui_num_col} = scalar(@fields) + 2; $Scratch->{ui_most_col} = $Scratch->{ui_num_col} - 1; $Config->{NoSearch} = ''; return; [/perl] [output name="top_of_form"] @_UI_STD_FOOTER_@