5 include( 'elements/edit.html',
8 #? 'primary_key' => #required when the dbdef doesn't know...???
13 #listref - each item is a literal column name (or method) or hashref
15 #if not specified all columns (except for the primary key) will be editable
18 { 'field' => 'another_columname',
19 'type' => 'text', #text
25 #selectlayers (can now use after a tablebreak-tr-title... but not inside columnstart/columnnext/columnend)
31 #hidden - hidden value from object
32 #fixed - display fixed value from object or here
35 'value' => 'Y', #for checkbox, title, fixed, fixedhidden
37 'onchange' => 'javascript_function',
39 #m2 stuff only tested w/selectlayers so far
40 #might work w/select too, dunno others
41 'm2name_table' => 'table_name',
42 'm2name_namecol' => 'name_column',
45 #'m2m_srccol' => #opt, if not the same as this table
46 'm2m_dstcol' => #required for now, eventuaully opt, if not the same as target table
48 'm2_label' => 'Label', #
49 'm2_new_default' => \@table_name_objects, #default
52 'm2_error_callback' => sub { my($cgi, $object) = @_; },
53 'm2_remove_warnings' => \%warnings, #hashref of warning
56 'm2_new_js' => 'function_name', #javascript function called
57 #on spawned rows (one arg:
59 'm2_remove_js' => 'function_name', #js function called when
60 #a row is deleted (three
63 #layer_fields & layer_values_callback only for selectlayer
65 'fieldname' => 'Label',
68 type =>'text', #text, money
71 'layer_values_callback' =>
73 my( $cgi, $object ) = @_;
74 { 'layer' => { 'fieldname' => 'current_value',
75 'fieldname2' => 'field2value',
78 'layer2' => { 'l2fieldname' => 'l2value',
87 'menubar' => '', #menubar arrayref
91 'agent_null_right' => 'Access Right Name',
93 #run when re-displaying with an error
94 'error_callback' => sub { my( $cgi, $object, $fields_listref, $opt_hashref ) = @_; },
97 'edit_callback' => sub { my( $cgi, $object, $fields_listref ) = @_; },
99 # returns a hashref for the new object
100 'new_hashref_callback'
102 # returns the new object iself (otherwise, ->new is called)
103 'new_object_callback'
106 'new_callback' => sub { my( $cgi, $object, $fields_listref ) = @_; },
108 #run before display to return a different value
109 'value_callback' => sub { my( $columname, $value ) = @_; },
112 'field_callback' => sub { },
114 'viewall_dir' => '', #'search' or 'browse', defaults to 'search'
116 'html_init' => '', #after the header/menubar
118 #string or coderef of additional HTML to add before </TABLE>
119 'html_table_bottom' => '',
121 #after </TABLE> but before the submit
122 'html_bottom' => '', #string
123 'html_bottom' => sub {
129 #at the very bottom (well, as low as you can go from here)
132 # overrides default popurl(1)."process/$table.html"
133 'post_url' => popurl(1).'process/something',
135 #we're in a popup (no title/menu/searchboxes)
142 <% include('/elements/header'. ( $opt{popup} ? '-popup' : '' ). '.html',
144 include( '/elements/menubar.html', @menubar )
148 <% defined($opt{'html_init'})
149 ? ( ref($opt{'html_init'})
150 ? &{$opt{'html_init'}}()
156 <% include('/elements/error.html') %>
158 % my $url = $opt{'post_url'} || popurl(1)."process/$table.html";
160 <FORM ACTION="<% $url %>" METHOD=POST NAME="edit_topform">
162 <INPUT TYPE="hidden" NAME="svcdb" VALUE="<% $table %>">
163 <INPUT TYPE="hidden" NAME="<% $pkey %>" VALUE="<% $object->$pkey() %>">
166 <% ( $opt{labels} && exists $opt{labels}->{$pkey} )
167 ? $opt{labels}->{$pkey}
171 #<% $object->$pkey() || "(NEW)" %>
174 <TABLE ID="TableNumber<% $tablenum++ %>" BGCOLOR="#cccccc" BORDER=0 CELLSPACING=0>
177 % my @g_row_stack = ();
178 % foreach my $f ( map { ref($_) ? $_ : {'field'=>$_} }
182 % &{ $opt{'field_callback'} }( $f )
183 % if $opt{'field_callback'};
185 % my $field = $f->{'field'};
186 % my $type = $f->{'type'} ||= 'text';
188 % my $label = ( $opt{labels} && exists $opt{labels}->{$field} )
189 % ? $opt{labels}->{$field}
192 % my $onchange = $f->{'onchange'};
194 % my $layer_values = {};
195 % $layer_values = &{ $f->{'layer_values_callback'} }( $cgi, $object )
196 % if $f->{'layer_values_callback'}
197 % && ! $f->{'m2name_table'}
198 % && ! $f->{'m2m_method'};
200 % warn "layer values: ". Dumper($layer_values)
203 % my %include_common = (
205 % #text and derivitives
206 % 'size' => $f->{'size'},
208 % #checkbox, title, fixed, fixedhidden
209 % #& deprecated weird value hashref used only by reason.html
210 % 'value' => $f->{'value'},
213 % 'options' => $f->{'options'},
214 % 'labels' => $f->{'labels'},
215 % 'empty_label' => $f->{'empty_label'},
216 % 'multiple' => $f->{'multiple'},
217 % 'disable_empty' => $f->{'disable_empty'},
219 % 'reason_class' => $f->{'reason_class'},
222 % 'layer_fields' => $f->{'layer_fields'},
223 % 'layer_values' => $layer_values,
224 % 'html_between' => $f->{'html_between'},
227 % 'disabled' => $f->{'disabled'},
231 % $include_common{$_} = $f->{$_}
232 % foreach grep exists($f->{$_}), qw( table name_col );
234 % if ( $type eq 'tablebreak-tr-title' ) {
235 % $include_common{'table_id'} = 'TableNumber'. $tablenum++
238 % my $layer_prefix_on = '';
240 % my $include_sub = sub {
243 % my $fieldnum = delete $opt{'fieldnum'};
245 % my $include = $type;
246 % $include = "input-$include" if $include =~ /^(text|money|percentage)$/;
247 % $include = "tr-$include" unless $include =~ /^(hidden|tablebreak|column)/;
249 % $include_common{'layer_prefix'} = "$field$fieldnum."
250 % if $layer_prefix_on;
253 % ( "/elements/$include.html",
254 % 'field' => "$field$fieldnum",
255 % 'id' => "$field$fieldnum", #separate?
256 % 'label_id' => $field."_label$fieldnum", #don't want field0_label0...
263 % unless ( $type =~ /^column/ ) {
264 % $g_row = 1 if $type eq 'tablebreak-tr-title';
266 % $g_row++ if $type eq 'title';
268 % if ( $type eq 'columnstart' ) {
269 % push @g_row_stack, $g_row++;
271 % #} elsif ( $type eq 'columnnext' ) {
272 % } elsif ( $type eq 'columnend' ) {
273 % $g_row = pop @g_row_stack;
279 % my $curr_value = '';
280 % if ( $f->{'m2name_table'} || $f->{'m2m_method'} ) { #XXX test this for all
283 % if ( $f->{'m2name_table'} ) {
284 % $table = $f->{'m2name_table'};
285 % $col = $f->{'m2name_namecol'};
286 % } elsif ( $f->{'m2m_method'} ) {
287 % $table = $f->{'m2m_method'};
288 % $col = $f->{'m2m_dstcol'};
291 % $layer_prefix_on = 1;
292 % #print out the fields for the existing m2s
294 % if ( $mode eq 'error' ) {
295 % @existing = &{ $f->{'m2_error_callback'} }( $cgi, $object );
296 % } elsif ( $object->$pkey() ) { # $mode eq 'edit'
297 % @existing = $object->$table();
298 % warn scalar(@existing). " from $object->$table: ". join('/', @existing)
300 % } elsif ( $f->{'m2_new_default'} ) { # && $mode eq 'new'
301 % @existing = @{ $f->{'m2_new_default'} };
303 % foreach my $name_obj ( @existing ) {
305 % my $ex_label = '<INPUT TYPE="button" VALUE="X" TITLE="Remove this '.
306 % lc($f->{'m2_label'}).
307 % qq(" onClick="remove_$field($fieldnum);").
308 % ' STYLE="color:#ff0000;font-weight:bold;'.
309 % 'padding-left:2px;padding-right:2px"'.
310 % '> '. ($f->{'m2_label'} || $field ). ' ';
312 % if ( $f->{'layer_values_callback'} ) {
313 % my %switches = ( 'mode' => $mode );
315 % &{ $f->{'layer_values_callback'} }( $cgi, $name_obj, \%switches );
317 % warn "layer values: ". Dumper($layer_values)
320 % my @existing = &{ $include_sub }(
321 % 'label' => $ex_label,
322 % 'fieldnum' => $fieldnum,
323 % 'curr_value' => $name_obj->$col(),
324 % 'onchange' => $onchange,
325 % 'layer_values' => $layer_values,
326 % 'cell_style' => ( $fieldnum ? 'border-top:1px solid black' : '' ),
329 <% include( @existing ) %>
334 % #$field .= $fieldnum;
335 % $onchange .= "\nspawn_$field(what);";
337 % if ( $f->{curr_value_callback} ) {
338 % $curr_value = &{ $f->{curr_value_callback} }( $cgi, $object, $field ),
340 % $curr_value = $object->$field();
342 % $curr_value = &{ $opt{'value_callback'} }( $f->{'field'}, $curr_value )
343 % if $opt{'value_callback'} && $mode ne 'error';
346 % my @include = &{ $include_sub }(
348 % 'fieldnum' => $fieldnum,
349 % 'curr_value' => $curr_value,
350 % 'object' => $object,
352 % 'onchange' => $onchange,
353 % 'cell_style' => ( $fieldnum ? 'border-top:1px solid black' : '' ),
356 <% include( @include ) %>
358 % if ( $f->{'m2name_table'} || $f->{'m2m_method'} ) {
360 <SCRIPT TYPE="text/javascript">
362 var <%$field%>_rownum = <% $g_row %>;
363 var <%$field%>_fieldnum = <% $fieldnum %>;
365 function spawn_<%$field%>(what) {
367 // only spawn if we're the last element... return if not
369 var field_regex = /(\d+)$/;
370 var match = field_regex.exec(what.name);
372 alert(what.name + " didn't match?!");
375 if ( match[1] != <%$field%>_fieldnum ) {
379 // change the label on the last entry & add a remove button
380 var prev_label = document.getElementById('<% $field %>_label' + <%$field%>_fieldnum );
381 prev_label.innerHTML = '<INPUT TYPE="button" VALUE="X" TITLE="Remove this <% lc($f->{'m2_label'}) %>" onClick="remove_<% $field %>(' + <%$field%>_fieldnum + ');" STYLE="color:#ff0000;font-weight:bold;padding-left:2px;padding-right:2px" > <% $f->{'m2_label'} || $field %>';
383 <%$field%>_fieldnum++;
387 % $include[0] =~ s(^/elements/tr-)(/elements/);
388 % my @layer_opt = ( @include,
389 % 'field' => $field."MAGIC_NUMBER",
390 % 'id' => $field."MAGIC_NUMBER",
391 % 'layer_prefix' => $field."MAGIC_NUMBER.",
393 % warn @layer_opt if $opt{'debug'};
395 var newrow = <% include(@layer_opt, html_only=>1) |js_string %>;
397 % if ( $type eq 'selectlayers' ) { #until the rest have html/js_only
398 var newfunc = <% include(@layer_opt, js_only =>1) |js_string %>;
403 // substitute in the new field name
404 var magic_regex = /MAGIC_NUMBER/g;
405 newrow = newrow.replace( magic_regex, <%$field%>_fieldnum );
406 newfunc = newfunc.replace( magic_regex, <%$field%>_fieldnum );
409 if (window.ActiveXObject) {
410 window.execScript(newfunc);
411 } else { /* (window.XMLHttpRequest) */
412 //window.eval(newfunc);
413 setTimeout(newfunc, 0);
418 //hmm, can't use selectlayers after a tablebreak-title for now
419 var table = document.getElementById('TableNumber<% $tablenum-1 %>');
421 var row = table.insertRow(<%$field%>_rownum++);
423 var label_cell = document.createElement('TD');
425 label_cell.id = '<% $field %>_label' + <%$field%>_fieldnum;
427 label_cell.style.textAlign = "right";
428 label_cell.style.verticalAlign = "top";
429 label_cell.style.borderTop = "1px solid black";
430 label_cell.style.paddingTop = "5px";
432 label_cell.innerHTML = '<% $label %>';
434 row.appendChild(label_cell);
436 var widget_cell = document.createElement('TD');
438 widget_cell.style.borderTop = "1px solid black";
439 widget_cell.style.paddingTop = "3px";
441 widget_cell.innerHTML = newrow;
443 row.appendChild(widget_cell);
445 % if ( $f->{'m2_new_js'} ) {
446 // take out items selected in previous dropdowns
447 var new_element = document.getElementById("<%$field%>" + <%$field%>_fieldnum );
448 <% $f->{'m2_new_js'} %>(new_element);
450 if ( new_element.length < 2 ) {
451 //just the ** Select new **, so don't display the row
452 row.style.display = 'none';
458 function remove_<%$field%>(remove_fieldnum) {
459 //alert("remove <%$field%> " + remove_fieldnum);
460 var select = document.getElementById('<%$field%>' + remove_fieldnum);
463 alert("can't find element <%$field%>" + remove_fieldnum);
467 % my $warnings = $f->{'m2_remove_warnings'};
469 var sel_value = select.options[select.selectedIndex].value;
470 % foreach my $value ( keys %$warnings ) {
471 if ( sel_value == '<% $value %>' ) {
472 if ( ! confirm( <% $warnings->{$value} |js_string %> ) ) {
479 select.disabled = 'disabled'; // this seems to prevent it from being submitted on tested browsers so far (IE, moz, konq at least)
480 var label_td = document.getElementById('<%$field%>_label' + remove_fieldnum );
481 label_td.parentNode.style.display = 'none';
483 % if ( $f->{m2_remove_js} ) {
484 var opt = select.options[select.selectedIndex];
485 <% $f->{m2_remove_js} %>( opt.value, opt.text, 'no_match');
496 <% ref( $opt{'html_table_bottom'} )
497 ? &{ $opt{'html_table_bottom'} }( $object )
498 : $opt{'html_table_bottom'}
503 <% ref( $opt{'html_bottom'} )
504 ? &{ $opt{'html_bottom'} }( $object )
505 : $opt{'html_bottom'}
510 <INPUT TYPE="submit" ID="submit" VALUE="<% $object->$pkey() ? "Apply changes" : "Add $opt{'name'}" %>">
514 <% ref( $opt{'html_foot'} )
515 ? &{ $opt{'html_foot'} }( $object )
519 <% include("/elements/footer.html") %>
524 my $curuser = $FS::CurrentUser::CurrentUser;
526 #false laziness w/process.html
527 my $table = $opt{'table'};
528 my $class = "FS::$table";
529 my $pkey = dbdef->table($table)->primary_key; #? $opt{'primary_key'} ||
530 my $fields = $opt{'fields'}
531 #|| [ grep { $_ ne $pkey } dbdef->table($table)->columns ];
532 || [ grep { $_ ne $pkey } fields($table) ];
533 #my @actualfields = map { ref($_) ? $_->{'field'} : $_ } @$fields;
535 if ( $cgi->param('redirect') ) {
536 my $session = $cgi->param('redirect');
537 my $pref = $curuser->option("redirect$session");
538 die "unknown redirect session $session\n" unless length($pref);
539 $cgi = new CGI($pref);
544 if ( $cgi->param('error') ) {
548 $object = $class->new( {
549 map { $_ => scalar($cgi->param($_)) } fields($table)
552 &{$opt{'error_callback'}}($cgi, $object, $fields, \%opt )
553 if $opt{'error_callback'};
555 } elsif ( $cgi->keywords || $cgi->param($pkey) ) { #editing
560 if ( $cgi->param($pkey) ) {
561 $value = $cgi->param($pkey)
563 my( $query ) = $cgi->keywords;
566 $value =~ /^(\d+)$/ or die "unparsable $pkey";
569 'hashref' => { $pkey => $1 },
570 'extra_sql' => ( $opt{'agent_virt'}
571 ? ' AND '. $curuser->agentnums_sql(
572 'null_right' => $opt{'agent_null_right'}
577 warn "$table $pkey => $1"
580 &{$opt{'edit_callback'}}($cgi, $object, $fields)
581 if $opt{'edit_callback'};
587 my $hashref = $opt{'new_hashref_callback'}
588 ? &{$opt{'new_hashref_callback'}}
591 $object = $opt{'new_object_callback'}
592 ? &{$opt{'new_object_callback'}}( $cgi, $hashref, $fields, \%opt )
593 : $class->new( $hashref );
595 &{$opt{'new_callback'}}($cgi, $object, $fields)
596 if $opt{'new_callback'};
600 $opt{action} ||= $object->$pkey() ? 'Edit' : 'Add';
602 my $title = $opt{action}. ' '. $opt{name};
604 my $viewall_url = $p . ( $opt{'viewall_dir'} || 'search' ) . "/$table.html";
605 $viewall_url = $opt{'viewall_url'} if $opt{'viewall_url'};
608 if ( $opt{'menubar'} ) {
609 @menubar = @{ $opt{'menubar'} };
612 #eventually use Lingua::bs to pluralize
613 "View all $opt{'name'}s" => $viewall_url,