fix 477 part IIB, #18503
[freeside.git] / httemplate / edit / part_pkg.cgi
1 <% include( 'elements/edit.html',
2               'post_url'              => popurl(1).'process/part_pkg.cgi',
3               'name'                  => "Package definition",
4               'table'                 => 'part_pkg',
5
6               'agent_virt'            => 1,
7               'agent_null_right'      => $edit_global,
8               'agent_clone_extra_sql' => $agent_clone_extra_sql,
9               #'viewall_dir'           => 'browse',
10               'viewall_url'           => $p.'browse/part_pkg.cgi',
11               'html_init'             => include('/elements/init_overlib.html').
12                                          $javascript,
13               'html_bottom'           => $html_bottom,
14               'body_etc'              =>
15                 'onLoad="agent_changed(document.edit_topform.agentnum)"',
16
17               'begin_callback'        => $begin_callback,
18               'end_callback'          => $end_callback,
19               'new_hashref_callback'  => $new_hashref_callback,
20               'new_object_callback'   => $new_object_callback,
21               'new_callback'          => $new_callback,
22               'clone_callback'        => $clone_callback,
23               'edit_callback'         => $edit_callback,
24               'error_callback'        => $error_callback,
25               'field_callback'        => $field_callback,
26
27               'labels' => { 
28                             'pkgpart'          => 'Package Definition',
29                             'pkg'              => 'Package (customer-visible)',
30                             'comment'          => 'Comment (customer-hidden)',
31                             'classnum'         => 'Package class',
32                             'addon_classnum'   => 'Restrict additional orders to package class',
33                             'promo_code'       => 'Promotional code',
34                             'freq'             => 'Recurring fee frequency',
35                             'setuptax'         => 'Setup fee tax exempt',
36                             'recurtax'         => 'Recurring fee tax exempt',
37                             'taxclass'         => 'Tax class',
38                             'taxproduct_select'=> 'Tax products',
39                             'plan'             => 'Price plan',
40                             'disabled'         => 'Disable new orders',
41                             'disable_line_item_date_ranges' => 'Disable line item date ranges',
42                             'setup_cost'       => 'Setup cost',
43                             'recur_cost'       => 'Recur cost',
44                             'pay_weight'       => 'Payment weight',
45                             'credit_weight'    => 'Credit weight',
46                             'agentnum'         => 'Agent',
47                             'setup_fee'        => 'Setup fee',
48                             'setup_show_zero'  => 'Show zero setup',
49                             'recur_fee'        => 'Recurring fee',
50                             'recur_show_zero'  => 'Show zero recurring',
51                             'discountnum'      => 'Offer discounts for longer terms',
52                             'bill_dst_pkgpart' => 'Include line item(s) from package',
53                             'svc_dst_pkgpart'  => 'Include services of package',
54                             'report_option'    => 'Report classes',
55                             'fcc_ds0s'         => 'Voice-grade equivalents',
56                             'fcc_voip_class'   => 'Category',
57                           },
58
59               'fields' => [
60                             { field=>'clone',  type=>'hidden',
61                               curr_value_callback =>
62                                 sub { shift->param('clone') },
63                             },
64                             { field=>'pkgnum', type=>'hidden',
65                               curr_value_callback =>
66                                 sub { shift->param('pkgnum') },
67                             },
68
69                             { field=>'custom',  type=>'hidden' },
70
71                             { type => 'columnstart' },
72                             
73                               { field     => 'pkg',
74                                 type      => 'text',
75                                 size      => 40, #32
76                                 maxlength => 50,
77                               },
78                               {field=>'comment',  type=>'text', size=>40 }, #32
79                               { field         => 'agentnum',
80                                 type          => 'select-agent',
81                                 disable_empty => ! $acl_edit_global,
82                                 empty_label   => '(global)',
83                                 onchange      => 'agent_changed',
84                               },
85                               {field=>'classnum', type=>'select-pkg_class' },
86                               ( $conf->exists('pkg-addon_classnum')
87                                   ? ( { field=>'addon_classnum',
88                                         type =>'select-pkg_class',
89                                       }
90                                     )
91                                    : ()
92                               ),
93                               {field=>'disabled', type=>$disabled_type, value=>'Y'},
94                               {field=>'disable_line_item_date_ranges', type=>$disabled_type, value=>'Y'},
95
96                               { type     => 'tablebreak-tr-title',
97                                 value    => 'Pricing', #better name?
98                               },
99                               { field    => 'plan',
100                                 type     => 'selectlayers-select',
101                                 options  => [ keys %plan_labels ],
102                                 labels   => \%plan_labels,
103                                 onchange => 'aux_planchanged(what);',
104                               },
105                               { field    => 'setup_fee',
106                                 type     => 'money',
107                                 onchange => 'setup_changed',
108                               },
109                               { field    => 'setup_show_zero',
110                                 type     => 'checkbox',
111                                 value    => 'Y',
112                                 disabled => sub { $setup_show_zero_disabled },
113                               },
114                               { field    => 'freq',
115                                 type     => 'part_pkg_freq',
116                                 onchange => 'freq_changed',
117                               },
118                               { field    => 'recur_fee',
119                                 type     => 'money',
120                                 disabled => sub { $recur_disabled },
121                                 onchange => 'recur_changed',
122                               },
123
124                               { field    => 'recur_show_zero',
125                                 type     => 'checkbox',
126                                 value    => 'Y',
127                                 disabled => sub { $recur_show_zero_disabled },
128                               },
129
130                               #price plan
131                               #setup fee
132                               #recurring frequency
133                               #recurring fee (auto-disable)
134
135                             { type => 'columnnext' },
136
137                               {type=>'justtitle', value=>'Taxation' },
138                               {field=>'setuptax', type=>'checkbox', value=>'Y'},
139                               {field=>'recurtax', type=>'checkbox', value=>'Y'},
140                               {field=>'taxclass', type=>'select-taxclass' },
141                               { field => 'taxproductnums',
142                                 type  => 'hidden',
143                                 value => join(',', @taxproductnums),
144                               },
145                               { field => 'taxproduct_select',
146                                 type  => 'selectlayers',
147                                 options => [ '(default)', @taxproductnums ],
148                                 curr_value => '(default)',
149                                 labels  => { ( '(default)' => '(default)' ),
150                                              map {($_=>$usage_class{$_})}
151                                              @taxproductnums
152                                            },
153                                 layer_fields => \%taxproduct_fields,
154                                 layer_values_callback => $taxproduct_values,
155                                 layers_only  =>   !$taxproducts,
156                                 cell_style   => ( !$taxproducts
157                                                   ? 'display:none'
158                                                   : ''
159                                                 ),
160                               },
161
162                               { type  => 'tablebreak-tr-title',
163                                 value => 'Promotions', #better name?
164                               },
165                               { field=>'promo_code', type=>'text', size=>15 },
166
167                               { type  => 'tablebreak-tr-title',
168                                 value => 'Cost tracking', #better name?
169                               },
170                               { field=>'setup_cost', type=>'money', },
171                               { field=>'recur_cost', type=>'money', },
172
173                             { type => 'columnnext' },
174
175                               { field    => 'agent_type',
176                                 type     => 'select-agent_types',
177                                 disabled => ! $acl_edit_global,
178                                 curr_value_callback => sub {
179                                   my($cgi, $object, $field) = @_;
180                                   #in the other callbacks..?  hmm.
181                                   \@agent_type;
182                                 },
183                               },
184
185                               { type  => 'tablebreak-tr-title',
186                                 value => 'Line-item revenue recogition', #better name?
187                               },
188                               { field=>'pay_weight',    type=>'text', size=>6 },
189                               { field=>'credit_weight', type=>'text', size=>6 },
190
191                               ( $conf->exists('cust_pkg-show_fcc_voice_grade_equivalent')
192                                 ? ( 
193                                     { type  => 'tablebreak-tr-title',
194                                       value => 'FCC Form 477 information',
195                                     },
196                                     { field=>'fcc_voip_class',
197                                       type=>'select-voip_class',
198                                     },
199                                     { field=>'fcc_ds0s', type=>'text', size=>6 },
200                                   )
201                                  : ()
202                               ),
203
204
205                             { type => 'columnend' },
206
207                             { 'type'  => $report_option ? 'tablebreak-tr-title'
208                                                         : 'hidden',
209                               'value' => 'Optional report classes',
210                               'field' => 'census_title',
211                             },
212                             { 'field'    => 'report_option',
213                               'type'     => $report_option ? 'select-table'
214                                                            : 'hidden',
215                               'table'    => 'part_pkg_report_option',
216                               'name_col' => 'name',
217                               'hashref'  => { 'disabled' => '' },
218                               'multiple' => 1,
219                             },
220
221                             { 'type'    => 'tablebreak-tr-title',
222                               'value'   => 'Term discounts',
223                             },
224                             { 'field'      => 'discountnum',
225                               'type'       => 'select-table',
226                               'table'      => 'discount',
227                               'name_col'   => 'name',
228                               'hashref'    => { %$discountnum_hashref },
229                               #'extra_sql'  => 'AND (months IS NOT NULL OR months != 0)',
230                               'empty_label'=> 'Select discount',
231                               'm2_label'   => 'Offer discounts for longer terms',
232                               'm2m_method' => 'part_pkg_discount',
233                               'm2m_dstcol' => 'discountnum',
234                               'm2_error_callback' => $discount_error_callback,
235                             },
236
237                             { 'type'    => 'tablebreak-tr-title',
238                               'value'   => 'Pricing add-ons',
239                               'colspan' => 4,
240                             },
241                             { 'field'      => 'bill_dst_pkgpart',
242                               'type'       => 'select-part_pkg',
243                               'extra_sql'  => sub { $pkgpart
244                                                      ? "AND pkgpart != $pkgpart"
245                                                      : ''
246                                                   },
247                               'm2_label'   => 'Include line item(s) from package',
248                               'm2m_method' => 'bill_part_pkg_link',
249                               'm2m_dstcol' => 'dst_pkgpart',
250                               'm2_error_callback' =>
251                                 &{$m2_error_callback_maker}('bill'),
252                               'm2_fields' => [ { 'field' => 'hidden',
253                                                  'type'  => 'checkbox',
254                                                  'value' => 'Y',
255                                                  'curr_value' => '',
256                                                  'label' => 'Bundle',
257                                                },
258                                              ],
259                             },
260
261                             { type  => 'tablebreak-tr-title',
262                               value => 'Services',
263                             },
264                             { type => 'pkg_svc', },
265
266                             { 'field'      => 'svc_dst_pkgpart',
267                               'label'      => 'Also include services from package: ',
268                               'type'       => 'select-part_pkg',
269                               'extra_sql'  => sub { $pkgpart
270                                                      ? "AND pkgpart != $pkgpart"
271                                                      : ''
272                                                   },
273                               'm2_label'   => 'Include services of package: ',
274                               'm2m_method' => 'svc_part_pkg_link',
275                               'm2m_dstcol' => 'dst_pkgpart',
276                               'm2_error_callback' =>
277                                 &{$m2_error_callback_maker}('svc'),
278                             },
279
280                             { type  => 'tablebreak-tr-title',
281                               value => 'Price plan options',
282                             },
283
284                           ],
285
286            )
287 %>
288 <%init>
289
290 my $curuser = $FS::CurrentUser::CurrentUser;
291
292 my $edit_global = 'Edit global package definitions';
293 my $acl_edit        = $curuser->access_right('Edit package definitions');
294 my $acl_edit_global = $curuser->access_right($edit_global);
295
296 my $acl_edit_either = $acl_edit || $acl_edit_global;
297
298 my $begin_callback = sub {
299   my( $cgi, $fields, $opt ) = @_;
300   die "access denied"
301     unless $acl_edit_either
302         || ( $cgi->param('pkgnum')
303              && $curuser->access_right('Customize customer package')
304            );
305 };
306
307 my $disabled_type = $acl_edit_either ? 'checkbox' : 'hidden';
308
309 #arg.  access rights for cloning are Hard.
310 # on the one hand we don't really want cloning (customizing a package) to fail 
311 #  for want of finding the source package in normal usage
312 # on the other hand, we don't want people using the clone link to be able to
313 #  see 
314 my $agent_clone_extra_sql = 
315   ' ( '. FS::part_pkg->curuser_pkgs_sql.
316   "   OR ( part_pkg.custom = 'Y' ) ".
317   ' ) ';
318
319 my $conf = new FS::Conf;
320 my $taxproducts = $conf->exists('enable_taxproducts');
321
322 my $sth = dbh->prepare("SELECT COUNT(*) FROM part_pkg_report_option".
323                        "  WHERE disabled IS NULL OR disabled = ''  ")
324   or die dbh->errstr;
325 $sth->execute or die $sth->errstr;
326 my $report_option = $sth->fetchrow_arrayref->[0];
327
328 #XXX
329 # - tr-part_pkg_freq: month_increments_only (from price plans)
330 # - test cloning
331 # - test errors cloning
332 # - test custom pricing
333 # - move the selectlayer divs away from lame layer_callback
334
335 #my ($query) = $cgi->keywords;
336 #
337 #my $part_pkg = '';
338
339 my @agent_type = ();
340 my %tax_override = ();
341
342 my %taxproductnums = map { ($_->classnum => 1) }
343                      qsearch('usage_class', { 'disabled' => '' });
344 my @taxproductnums = ( qw( setup recur ), sort (keys %taxproductnums) );
345
346 my %options = ();
347 my $recur_disabled = 1;
348 my $setup_show_zero_disabled = 0;
349 my $recur_show_zero_disabled = 1;
350
351 my $pkgpart = '';
352
353 my $error_callback = sub {
354   my($cgi, $object, $fields, $opt ) = @_;
355
356   (@agent_type) = $cgi->param('agent_type');
357
358   $opt->{action} = 'Custom' if $cgi->param('pkgnum');
359
360   $setup_show_zero_disabled = ($cgi->param('setup_fee') > 0) ? 1 : 0;
361
362   $recur_disabled = $cgi->param('freq') ? 0 : 1;
363   $recur_show_zero_disabled =
364     $cgi->param('freq')
365       ? $cgi->param('recur_fee') > 0 ? 1 : 0
366       : 1;
367
368   foreach ($cgi->param) {
369     /^usage_taxproductnum_(\d+)$/ && ($taxproductnums{$1} = 1);
370   }
371   $tax_override{''} = $cgi->param('tax_override');
372   $tax_override{$_} = $cgi->param('tax_override_$_')
373     foreach(grep { /^tax_override_(\w+)$/ } $cgi->param);
374
375   #some false laziness w/process
376   $cgi->param('plan') =~ /^(\w+)$/ or die 'unparsable plan';
377   my $plan = $1;
378   my $options = $cgi->param($plan."__OPTIONS");
379   my @options = split(',', $options);
380   %options =
381     map { my $optionname = $_;
382           my $param = $plan."__$optionname";
383           my $value = join(', ', $cgi->param($param));
384           ( $optionname => $value );
385         }
386         @options;
387
388   $object->set($_ => scalar($cgi->param($_)) )
389     foreach (qw( setup_fee recur_fee disable_line_item_date_ranges ));
390
391   $pkgpart = $object->pkgpart;
392
393 };
394
395 my $new_hashref_callback = sub { { 'plan' => 'flat' }; };
396
397 my $new_object_callback = sub {
398   my( $cgi, $hashref, $fields, $opt ) = @_;
399
400   my $part_pkg = FS::part_pkg->new( $hashref );
401   $part_pkg->set($_ => '0')
402     foreach (qw( setup_fee recur_fee disable_line_item_date_ranges ));
403
404   $part_pkg;
405
406 };
407
408 my $edit_callback = sub {
409   my( $cgi, $object, $fields, $opt ) = @_;
410
411   $setup_show_zero_disabled = ($object->option('setup_fee') > 0) ? 1 : 0;
412
413   $recur_disabled = $object->freq ? 0 : 1;
414
415   $recur_show_zero_disabled =
416     $object->freq
417       ? $object->option('recur_fee') > 0 ? 1 : 0
418       : 1;
419
420   (@agent_type) =
421     map {$_->typenum} qsearch('type_pkgs', { 'pkgpart' => $object->pkgpart } );
422
423   my @report_option = ();
424   foreach ($object->options) {
425     /^usage_taxproductnum_(\d+)$/ && ($taxproductnums{$1} = 1);
426     /^report_option_(\d+)$/ && (push @report_option, $1);
427   }
428   foreach ($object->part_pkg_taxoverride) {
429     $taxproductnums{$_->usage_class} = 1
430       if $_->usage_class;
431   }
432
433   $cgi->param('report_option', join(',', @report_option));
434   foreach my $field ( @$fields ) {
435     next unless ( 
436       ref($field) eq 'HASH' &&
437       $field->{field} &&
438       $field->{field} eq 'report_option'
439     );
440     #$field->{curr_value} = join(',', @report_option);
441     $field->{value} = join(',', @report_option);
442   }
443
444   %options = $object->options;
445
446   $object->set($_ => $object->option($_, 1))
447     foreach (qw( setup_fee recur_fee disable_line_item_date_ranges ));
448
449   $pkgpart = $object->pkgpart;
450
451 };
452
453 my $new_callback = sub {
454   my( $cgi, $object, $fields ) = @_;
455
456   my $conf = new FS::Conf; 
457
458   if ( $conf->exists('agent_defaultpkg') ) {
459     #my @all_agent_types = map {$_->typenum} qsearch('agent_type',{});
460     @agent_type = map {$_->typenum} qsearch('agent_type',{});
461   }
462
463   $options{'suspend_bill'}=1 if $conf->exists('part_pkg-default_suspend_bill');
464
465 };
466
467 my $clone_callback = sub {
468   my( $cgi, $object, $fields, $opt ) = @_;
469
470   if ( $cgi->param('pkgnum') ) {
471
472     my $cust_pkg = qsearchs('cust_pkg', { 'pkgnum' => $cgi->param('pkgnum') } );
473     $object->agentnum( $cust_pkg->cust_main->agentnum );
474
475     $opt->{action} = 'Custom';
476
477     #my $part_pkg = $clone_part_pkg->clone;
478     #this is all clone does anyway
479     $object->custom('Y');
480
481     $object->disabled('Y');
482
483   } else { #not when cloning...
484
485     (@agent_type) =
486       map {$_->typenum} qsearch('type_pkgs',{ 'pkgpart' => $object->pkgpart } );
487
488   }
489
490   %options = $object->options;
491
492   $object->set($_ => $options{$_})
493     foreach (qw( setup_fee recur_fee disable_line_item_date_ranges ));
494
495   $recur_disabled = $object->freq ? 0 : 1;
496 };
497
498 my $discount_error_callback = sub {
499   my( $cgi, $object ) = @_;
500   map {
501         if ( /^discountnum(\d+)$/ &&
502              ( my $discountnum = $cgi->param("discountnum$1") ) )
503         {
504           new FS::part_pkg_discount {
505             'pkgpart'     => $object->pkgpart,
506             'discountnum' => $discountnum,
507           };
508         } else {
509           ();
510         }
511       }
512   $cgi->param;
513 };
514
515 my $m2_error_callback_maker = sub {
516   my $link_type = shift; #yay closures
517   return sub {
518     my( $cgi, $object ) = @_;
519     map {
520
521           if ( /^${link_type}_dst_pkgpart(\d+)$/ &&
522                ( my $dst = $cgi->param("${link_type}_dst_pkgpart$1") ) )
523           {
524
525             my $hidden = $cgi->param("${link_type}_dst_pkgpart__hidden$1")
526                          || '';
527             new FS::part_pkg_link {
528               'link_type'   => $link_type,
529               'src_pkgpart' => $object->pkgpart,
530               'dst_pkgpart' => $dst,
531               'hidden'      => $hidden,
532             };
533           } else {
534             ();
535           }
536         }
537     $cgi->param;
538   };
539 };
540
541 my $javascript = <<'END';
542   <SCRIPT TYPE="text/javascript">
543
544     function freq_changed(what) {
545       var freq = what.options[what.selectedIndex].value;
546
547       if ( freq == '0' ) {
548         what.form.recur_fee.disabled = true;
549         what.form.recur_fee.style.backgroundColor = '#dddddd';
550         what.form.recur_show_zero.disabled = true;
551         //what.form.recur_show_zero.style.backgroundColor= '#dddddd';
552       } else {
553         what.form.recur_fee.disabled = false;
554         what.form.recur_fee.style.backgroundColor = '#ffffff';
555         recur_changed( what.form.recur_fee );
556         //what.form.recur_show_zero.style.backgroundColor= '#ffffff';
557       }
558
559     }
560
561     function setup_changed(what) {
562       var setup = what.value;
563       if ( parseFloat(setup) == 0 ) {
564         what.form.setup_show_zero.disabled = false;
565       } else {
566         what.form.setup_show_zero.disabled = true;
567       }
568     }
569
570     function recur_changed(what) {
571       var recur = what.value;
572       if ( parseFloat(recur) == 0 ) {
573         what.form.recur_show_zero.disabled = false;
574       } else {
575         what.form.recur_show_zero.disabled = true;
576       }
577     }
578
579     function agent_changed(what) {
580
581       var agentnum;
582       if ( what.type == 'select-one' ) {
583         agentnum = what.options[what.selectedIndex].value;
584       } else {
585         agentnum = what.value;
586       }
587
588       if ( agentnum == 0 ) {
589         what.form.agent_type.disabled = false;
590         //what.form.agent_type.style.backgroundColor = '#ffffff';
591         what.form.agent_type.style.visibility = '';
592       } else {
593         what.form.agent_type.disabled = true;
594         //what.form.agent_type.style.backgroundColor = '#dddddd';
595         what.form.agent_type.style.visibility = 'hidden';
596       }
597
598     }
599
600     function aux_planchanged(what) {
601
602       alert('called!');
603       var plan = what.options[what.selectedIndex].value;
604       var table = document.getElementById('TableNumber7') // XXX NOT ROBUST
605
606       if ( plan == 'flat' || plan == 'prorate' || plan == 'subscription' ) {
607         //table.disabled = false;
608         table.style.visibility = '';
609       } else {
610         //table.disabled = true;
611         table.style.visibility = 'hidden';
612       }
613
614     }
615
616   </SCRIPT>
617 END
618
619 tie my %plans, 'Tie::IxHash', %{ FS::part_pkg::plan_info() };
620
621 tie my %plan_labels, 'Tie::IxHash',
622   map {  $_ => ( $plans{$_}->{'shortname'} || $plans{$_}->{'name'} ) }
623       keys %plans;
624
625 my $html_bottom = sub {
626   my( $object ) = @_;
627
628   #warn join("\n", map { "$_: $options{$_}" } keys %options ). "\n";
629
630   my $layer_callback = sub {
631   
632     my $layer = shift;
633     my $html = ntable("#cccccc",2);
634   
635     #$html .= '
636     #  <TR>
637     #    <TD ALIGN="right">Recurring fee frequency </TD>
638     #    <TD><SELECT NAME="freq">
639     #';
640     #
641     #my @freq = keys %freq;
642     #@freq = grep { /^\d+$/ } @freq
643   #XXX this bit#  #  if exists($plans{$layer}->{'freq'}) && $plans{$layer}->{'freq'} eq 'm';
644     #foreach my $freq ( @freq ) {
645     #  $html .= qq(<OPTION VALUE="$freq");
646     #  $html .= ' SELECTED' if $freq eq $part_pkg->freq;
647     #  $html .= ">$freq{$freq}";
648     #}
649
650    #$html .= '</SELECT></TD></TR>';
651   
652     my $href = $plans{$layer}->{'fields'};
653     my @fields = exists($plans{$layer}->{'fieldorder'})
654                    ? @{$plans{$layer}->{'fieldorder'}}
655                    : keys %{ $href };
656   
657     foreach my $field ( grep $_ !~ /^(setup|recur)_fee$/, @fields ) {
658   
659        if(!exists($href->{$field})) {
660         # shouldn't happen
661         warn "nonexistent part_pkg option: '$field'\n";
662         next;
663       }
664
665       $html .= '<TR><TD ALIGN="right">'. $href->{$field}{'name'}. '</TD><TD>';
666   
667       my $format = sub { shift };
668       $format = $href->{$field}{'format'} if exists($href->{$field}{'format'});
669
670       #XXX these should use elements/ fields... (or this whole thing should
671       #just use layer_fields instead of layer_callback)
672   
673       if ( ! exists($href->{$field}{'type'}) ) {
674   
675         $html .= qq!<INPUT TYPE="text" NAME="${layer}__$field" VALUE="!.
676                  ( exists($options{$field})
677                      ? &$format($options{$field})
678                      : $href->{$field}{'default'} ).
679                  qq!">!;
680   
681       } elsif ( $href->{$field}{'type'} eq 'checkbox' ) {
682   
683         $html .= qq!<INPUT TYPE="checkbox" NAME="${layer}__$field" VALUE=1 !.
684                  ( exists($options{$field}) && $options{$field}
685                    ? ' CHECKED'
686                    : ''
687                  ). '>';
688   
689       } elsif ( $href->{$field}{'type'} =~ /^select/ ) {
690   
691         $html .= '<SELECT';
692         $html .= ' MULTIPLE'
693           if $href->{$field}{'type'} eq 'select_multiple';
694         $html .= qq! NAME="${layer}__$field">!;
695
696         $html .= '<OPTION VALUE="">'. $href->{$field}{'empty_label'}
697           if exists($href->{$field}{'disable_empty'})
698                && ! $href->{$field}{'disable_empty'};
699   
700         if ( $href->{$field}{'select_table'} ) {
701           foreach my $record (
702             qsearch( $href->{$field}{'select_table'},
703                      $href->{$field}{'select_hash'}   )
704           ) {
705             my $value = $record->getfield($href->{$field}{'select_key'});
706             $html .= qq!<OPTION VALUE="$value"!.
707                      (  $options{$field} =~ /(^|, *)$value *(,|$)/ #?
708                           ? ' SELECTED'
709                           : ''
710                      ).
711                      '>'. $record->getfield($href->{$field}{'select_label'});
712           }
713         } elsif ( $href->{$field}{'select_options'} ) {
714           foreach my $key ( keys %{ $href->{$field}{'select_options'} } ) {
715             my $label = $href->{$field}{'select_options'}{$key};
716             $html .= qq!<OPTION VALUE="$key"!.
717                      ( $options{$field} =~ /(^|, *)$key *(,|$)/ #?
718                          ? ' SELECTED'
719                          : ''
720                      ).
721                      '>'. $label;
722           }
723   
724         } else {
725           $html .= '<font color="#ff0000">warning: '.
726                    "don't know how to retreive options for $field select field".
727                    '</font>';
728         }
729         $html .= '</SELECT>';
730   
731       } elsif ( $href->{$field}{'type'} eq 'radio' ) {
732   
733         my $radio =
734           qq!<INPUT TYPE="radio" NAME="${layer}__$field"!;
735   
736         foreach my $key ( keys %{ $href->{$field}{'options'} } ) {
737           my $label = $href->{$field}{'options'}{$key};
738           $html .= qq!$radio VALUE="$key"!.
739                    ( $options{$field} =~ /(^|, *)$key *(,|$)/ #?
740                        ? ' CHECKED'
741                        : ''
742                    ).
743                    "> $label<BR>";
744         }
745   
746       }
747   
748       $html .= '</TD></TR>';
749     }
750     $html .= '</TABLE>';
751   
752     $html .= qq(<INPUT TYPE="hidden" NAME="${layer}__OPTIONS" VALUE=").
753              join(',', keys %{ $href } ). '">';
754   
755     $html;
756   
757   };
758
759   my %selectlayers = (
760     field          => 'plan',
761     options        => [ keys %plan_labels ],
762     labels         => \%plan_labels,
763     curr_value     => $object->plan,
764     layer_callback => $layer_callback,
765   );
766
767   my $return =
768     include('/elements/selectlayers.html', %selectlayers, 'layers_only'=>1 ).
769     '<SCRIPT TYPE="text/javascript">'.
770       include('/elements/selectlayers.html', %selectlayers, 'js_only'=>1 );
771
772   $return .=
773     "taxproduct_selectchanged(document.getElementById('taxproduct_select'));\n"
774       if $taxproducts;
775
776   $return .= '</SCRIPT>';
777
778   $return;
779
780 };
781
782 my %usage_class = map { ($_->classnum => $_->classname) }
783                   qsearch('usage_class', {});
784 $usage_class{setup} = 'Setup';
785 $usage_class{recur} = 'Recurring';
786
787 my %taxproduct_fields = ();
788 my $end_callback = sub {
789   my( $cgi, $object, $fields, $opt ) = @_;
790
791   @taxproductnums = ( qw( setup recur ), sort (keys %taxproductnums) );
792
793   if ( $object->pkgpart ) {
794     foreach my $usage_class ( '', @taxproductnums ) {
795       $tax_override{$usage_class} =
796         join (",", map $_->taxclassnum,
797                        qsearch( 'part_pkg_taxoverride', {
798                                   'pkgpart'     => $object->pkgpart,
799                                   'usage_class' => $usage_class,
800                               })
801              );
802     }
803   }
804
805   %taxproduct_fields =
806     map { $_ => [ "taxproductnum_$_", 
807                   { type  => 'select-taxproduct',
808                     #label => "$usage_class{$_} tax product",
809                   },
810                   "tax_override_$_", 
811                   { type  => 'select-taxoverride' }
812                 ]
813         }
814         @taxproductnums;
815
816   $taxproduct_fields{'(default)'} =
817     [ 'taxproductnum', { type => 'select-taxproduct',
818                          #label => 'Default tax product',
819                        },
820       'tax_override',  { type => 'select-taxoverride' },
821     ];
822 };
823
824 my $taxproduct_values = sub {
825   my ($cgi, $object, $flags) = @_;
826   my $routine =
827     sub { my $layer = shift;
828           my @fields = @{$taxproduct_fields{$layer}};
829           my @values = ();
830           while( @fields ) {
831             my $field = shift @fields;
832             shift @fields;
833             $field =~ /^taxproductnum_\w+$/ &&
834               push @values, ( $field => $options{"usage_$field"} );
835             $field =~ /^tax_override_(\w+)$/ &&
836               push @values, ( $field => $tax_override{$1} );
837             $field =~ /^taxproductnum$/ &&
838               push @values, ( $field => $object->taxproductnum );
839             $field =~ /^tax_override$/ &&
840               push @values, ( $field => $tax_override{''} );
841           }
842           { (@values) };
843         };
844   
845   my @result = 
846     map { ( $_ => { &{$routine}($_) } ) } ( '(default)', @taxproductnums );
847   return({ @result });
848   
849 };
850
851 my $field_callback = sub {
852   my ($cgi, $object, $fieldref) = @_;
853
854   my $field = $fieldref->{field};
855   if ($field eq 'taxproductnums') {
856     $fieldref->{value} = join(',', @taxproductnums);
857   } elsif ($field eq 'taxproduct_select') {
858     $fieldref->{options} = [ '(default)', @taxproductnums ];
859     $fieldref->{labels}  = { ( '(default)' => '(default)' ),
860                              map {( $_ => ($usage_class{$_} || $_) )}
861                                @taxproductnums
862                            };
863     $fieldref->{layer_fields} = \%taxproduct_fields;
864     $fieldref->{layer_values_callback} = $taxproduct_values;
865   }
866 };
867
868 my $discountnum_hashref = {
869                             'disabled' => '',
870                             'months' => { 'op' => '>', 'value' => 1 },
871                           };
872
873 </%init>