[value scratch=1 name=mv_data_table set="[value mvc_data_table]" hide=1] [if-mm !tables] [bounce href="[area config/violation]"] [/if-mm] [L]Database Spreadsheet[/L] [perl tables="[value mvc_data_table]"] my $table = $Values->{mvc_data_table}; $Values->{mvc_data_key_name} = $Db{$table}->config('KEY'); if ($table ne $Values->{mv_data_table}) { $Values->{mv_data_table} = $table; } $Values->{mvc_data_fields} = $CGI->{mvc_data_fields} || $Values->{"$table:mvc_data_fields"} || '' ; return; [/perl] [title-bar][L]Search Spreadsheet[/L]: [value mv_data_table][if scratch export_ok] ([L]exported[/L])[/if][/title-bar]

[L]Edit menu for table[/L] [value mv_data_table]
[L]Upload/download/export menu for table[/L] [value mv_data_table]
[scratch menu]

[search-region] [rotate-table rotate="[value mvc_rotate_spread]" interpolate=1] [with param=table value="[value mv_data_table]"] [row-edit columns="[value mvc_data_fields]"] [search-list] [if-mm keys [item-code]] [/if-mm] [/search-list]
[L]Key[/L]
[page href="config/edit_record" arg="[item-code]"]Edit [row-edit key="[item-code]" size="[value mvc_spread_size]" columns="[value mvc_data_fields]"]
[/rotate-table] [no-match] [L]No records found[/L]. [/no-match] [more-list][L]More pages of results[/L]: [more] [/more-list] [/search-region]
[set Submit] mv_todo=set [/set]     [if !value mvc_too_large] [L]Auto-export[/L] [/if]
[L]Edit/Insert row[/L]:

[if type=explicit compare="[calc] q{[dbinfo table='[value mv_data_table]' attribute=type]} eq '8'; [/calc]"] [elsif type=file term="products/[value mv_data_table].ks"] [/elsif] [else] [/else] [/if] Search again

[title-bar 400 2][L]Limit fields to display (changes above will not be made)[/L][/title-bar] [set name=mvc_data_fields_name int][value mv_data_table]:mvc_data_fields[/set]

[L]Column width[/L]

[set Display All Fields][scratch mvc_data_fields_name]= mv_todo=return mv_nextpage=@@MV_PAGE@@ [/set] [widget name="[scratch mvc_data_fields_name]" type="checkbox left 2" data="=ALL,[db-columns joiner=',']" ] [/widget]
[L]Number of rows[/L]
[L]Decode HTML entities[/L]
[value name=mvc_data_fields set="" hide=1]

[L]Edit menu for table[/L] [value mv_data_table]
[L]Upload/download/export menu for table[/L] [value mv_data_table]
[scratch menu]