4 if ( $cgi->param('clone') && $cgi->param('clone') =~ /^(\d+)$/ ) {
5 $cgi->param('clone', $1);
7 $cgi->param('clone', '');
9 if ( $cgi->param('pkgnum') && $cgi->param('pkgnum') =~ /^(\d+)$/ ) {
10 $cgi->param('pkgnum', $1);
12 $cgi->param('pkgnum', '');
15 my ($query) = $cgi->keywords;
18 if ( $cgi->param('error') ) {
19 $part_pkg = new FS::part_pkg ( {
20 map { $_, scalar($cgi->param($_)) } fields('part_pkg')
23 if ( $cgi->param('clone') ) {
24 $action='Custom Pricing';
26 qsearchs('part_pkg', { 'pkgpart' => $cgi->param('clone') } );
27 $part_pkg ||= $old_part_pkg->clone;
28 $part_pkg->disabled('Y');
29 } elsif ( $query && $query =~ /^(\d+)$/ ) {
30 $part_pkg ||= qsearchs('part_pkg',{'pkgpart'=>$1});
32 unless ( $part_pkg ) {
33 $part_pkg = new FS::part_pkg {};
34 $part_pkg->plan('flat');
37 unless ( $part_pkg->plan ) { #backwards-compat
38 $part_pkg->plan('flat');
39 $part_pkg->plandata("setup_fee=". $part_pkg->setup. "\n".
40 "recur_fee=". $part_pkg->recur. "\n");
42 $action ||= $part_pkg->pkgpart ? 'Edit' : 'Add';
43 my $hashref = $part_pkg->hashref;
47 <%= header("$action Package Definition", menubar(
48 'Main Menu' => popurl(2),
49 'View all packages' => popurl(2). 'browse/part_pkg.cgi',
52 <% #), ' onLoad="visualize()"'); %>
54 <% if ( $cgi->param('error') ) { %>
55 <FONT SIZE="+1" COLOR="#ff0000">Error: <%= $cgi->param('error') %></FONT>
58 <% #print '<FORM ACTION="', popurl(1), 'process/part_pkg.cgi" METHOD=POST>'; %>
63 #if ( $cgi->param('clone') ) {
64 # print qq!<INPUT TYPE="hidden" NAME="clone" VALUE="!, $cgi->param('clone'), qq!">!;
66 #if ( $cgi->param('pkgnum') ) {
67 # print qq!<INPUT TYPE="hidden" NAME="pkgnum" VALUE="!, $cgi->param('pkgnum'), qq!">!;
70 #print qq!<INPUT TYPE="hidden" NAME="pkgpart" VALUE="$hashref->{pkgpart}">!,
73 <%= itable('',8,1) %><TR><TD VALIGN="top">
77 <%= ntable("#cccccc",2) %>
79 <TD ALIGN="right">Package Definition #</TD>
80 <TD BGCOLOR="#ffffff">
81 <%= $hashref->{pkgpart} ? $hashref->{pkgpart} : "(NEW)" %>
85 <TD ALIGN="right">Package (customer-visible)</TD>
87 <INPUT TYPE="text" NAME="pkg" SIZE=32 VALUE="<%= $part_pkg->pkg %>">
91 <TD ALIGN="right">Comment (customer-hidden)</TD>
93 <INPUT TYPE="text" NAME="comment" SIZE=32 VALUE="<%=$part_pkg->comment%>">
98 <TD ALIGN="right">Disable new orders</TD>
100 <INPUT TYPE="checkbox" NAME="disabled" VALUE="Y"<%= $hashref->{disabled} eq 'Y' ? ' CHECKED' : '' %>
106 </TD><TD VALIGN="top">
109 <%= ntable("#cccccc", 2) %>
111 <TD ALIGN="right">Setup fee tax exempt</TD>
115 print '<INPUT TYPE="checkbox" NAME="setuptax" VALUE="Y"';
116 print ' CHECKED' if $hashref->{setuptax} eq "Y";
121 <TR><TD ALIGN="right">Recurring fee tax exempt</TD><TD>
124 print '<INPUT TYPE="checkbox" NAME="recurtax" VALUE="Y"';
125 print ' CHECKED' if $hashref->{recurtax} eq "Y";
130 my $conf = new FS::Conf;
131 #false laziness w/ view/cust_main.cgi quick order
132 if ( $conf->exists('enable_taxclasses') ) {
133 print '<TR><TD ALIGN="right">Tax class</TD><TD><SELECT NAME="taxclass">';
134 my $sth = dbh->prepare('SELECT DISTINCT taxclass FROM cust_main_county')
136 $sth->execute or die $sth->errstr;
137 foreach my $taxclass ( map $_->[0], @{$sth->fetchall_arrayref} ) {
138 print qq!<OPTION VALUE="$taxclass"!;
139 print ' SELECTED' if $taxclass eq $hashref->{taxclass};
140 print qq!>$taxclass</OPTION>!;
142 print '</SELECT></TD></TR>';
145 '<INPUT TYPE="hidden" NAME="taxclass" VALUE="'. $hashref->{taxclass}. '">';
156 my $thead = "\n\n". ntable('#cccccc', 2).
157 '<TR><TH BGCOLOR="#dcdcdc"><FONT SIZE=-1>Quan.</FONT></TH>';
158 $thead .= '<TH BGCOLOR="#dcdcdc"><FONT SIZE=-1>Primary</FONT></TH>'
159 if dbdef->table('pkg_svc')->column('primary_svc');
160 $thead .= '<TH BGCOLOR="#dcdcdc">Service</TH></TR>';
162 #unless ( $cgi->param('clone') ) {
165 #print <<END, $thead;
166 print <<END, itable('', 4, 1), '<TR><TD VALIGN="top">', $thead;
167 <BR><BR>Services included
174 my @part_svc = qsearch( 'part_svc', { 'disabled' => '' } );
175 foreach my $part_svc ( @part_svc ) {
176 my $svcpart = $part_svc->svcpart;
177 my $pkgpart = $cgi->param('clone') || $part_pkg->pkgpart;
178 my $pkg_svc = $pkgpart && qsearchs( 'pkg_svc', {
179 'pkgpart' => $pkgpart,
180 'svcpart' => $svcpart,
181 } ) || new FS::pkg_svc ( {
182 'pkgpart' => $pkgpart,
183 'svcpart' => $svcpart,
187 #? #next unless $pkg_svc;
189 push @fixups, "pkg_svc$svcpart";
191 #unless ( defined ($cgi->param('clone')) && $cgi->param('clone') ) {
194 print '<TR>'; # if $count == 0 ;
195 print qq!<TD><INPUT TYPE="text" NAME="pkg_svc$svcpart" SIZE=4 MAXLENGTH=3 VALUE="!,
196 $cgi->param("pkg_svc$svcpart") || $pkg_svc->quantity || 0,
198 if ( dbdef->table('pkg_svc')->column('primary_svc') ) {
199 print qq!<TD><INPUT TYPE="radio" NAME="pkg_svc_primary" VALUE="$svcpart"!;
200 print ' CHECKED' if $pkg_svc->primary_svc =~ /^Y/i;
203 print qq!<TD><A HREF="part_svc.cgi?!,$part_svc->svcpart,
204 qq!">!, $part_svc->getfield('svc'), "</A></TD></TR>";
205 # print "</TABLE></TD><TD>$thead" if ++$count == int(scalar(@part_svc) / 2);
207 foreach ( 1 .. $columns-1 ) {
208 print "</TABLE></TD><TD VALIGN=\"top\">$thead"
209 if $count == int( $_ * scalar(@part_svc) / $columns );
212 print qq!<INPUT TYPE="hidden" NAME="pkg_svc$svcpart" VALUE="!,
213 $cgi->param("pkg_svc$svcpart") || $pkg_svc->quantity || 0, qq!">\n!;
217 #unless ( $cgi->param('clone') ) {
220 print "</TR></TABLE></TD></TR></TABLE>";
221 #print "</TR></TABLE>";
224 foreach my $f ( qw( clone pkgnum ) ) {
225 print qq!<INPUT TYPE="hidden" NAME="$f" VALUE="!. $cgi->param($f). '">';
227 print '<INPUT TYPE="hidden" NAME="pkgpart" VALUE="'. $part_pkg->pkgpart. '">';
229 # prolly should be in database
230 tie my %plans, 'Tie::IxHash', %{ FS::part_pkg::plan_info() };
232 my %plandata = map { /^(\w+)=(.*)$/; ( $1 => $2 ); }
233 split("\n", $part_pkg->plandata );
235 tie my %options, 'Tie::IxHash', map { $_=>$plans{$_}->{'name'} } keys %plans;
237 my @form_select = ();
238 if ( $conf->exists('enable_taxclasses') ) {
239 push @form_select, 'taxclass';
241 push @fixups, 'taxclass'; #hidden
245 if ( dbdef->table('pkg_svc')->column('primary_svc') ) {
246 push @form_radio, 'pkg_svc_primary';
249 tie my %freq, 'Tie::IxHash', %FS::part_pkg::freq;
250 if ( $part_pkg->dbdef_table->column('freq')->type =~ /(int)/i ) {
251 delete $freq{$_} foreach grep { ! /^\d+$/ } keys %freq;
254 my $widget = new HTML::Widgets::SelectLayers(
255 'selected_layer' => $part_pkg->plan,
256 'options' => \%options,
257 'form_name' => 'dummy',
258 'form_action' => 'process/part_pkg.cgi',
259 'form_text' => [ qw(pkg comment clone pkgnum pkgpart), @fixups ],
260 'form_checkbox' => [ qw(setuptax recurtax disabled) ],
261 'form_radio' => \@form_radio,
262 'form_select' => \@form_select,
263 'layer_callback' => sub {
265 my $html = qq!<INPUT TYPE="hidden" NAME="plan" VALUE="$layer">!.
269 <TD ALIGN="right">Recurring fee frequency </TD>
270 <TD><SELECT NAME="freq">
273 my @freq = keys %freq;
274 @freq = grep { /^\d+$/ } @freq
275 if exists($plans{$layer}->{'freq'}) && $plans{$layer}->{'freq'} eq 'm';
276 foreach my $freq ( @freq ) {
277 $html .= qq(<OPTION VALUE="$freq");
278 $html .= ' SELECTED' if $freq eq $part_pkg->freq;
279 $html .= ">$freq{$freq}";
281 $html .= '</SELECT></TD></TR>';
283 my $href = $plans{$layer}->{'fields'};
284 foreach my $field ( exists($plans{$layer}->{'fieldorder'})
285 ? @{$plans{$layer}->{'fieldorder'}}
289 $html .= '<TR><TD ALIGN="right">'. $href->{$field}{'name'}. '</TD><TD>';
291 if ( ! exists($href->{$field}{'type'}) ) {
292 $html .= qq!<INPUT TYPE="text" NAME="$field" VALUE="!.
293 ( exists($plandata{$field})
295 : $href->{$field}{'default'} ).
296 qq!" onChange="fchanged(this)">!;
297 } elsif ( $href->{$field}{'type'} eq 'select_multiple' ) {
298 $html .= qq!<SELECT MULTIPLE NAME="$field" onChange="fchanged(this)">!;
300 qsearch( $href->{$field}{'select_table'},
301 $href->{$field}{'select_hash'} )
303 my $value = $record->getfield($href->{$field}{'select_key'});
304 $html .= qq!<OPTION VALUE="$value"!.
305 ( $plandata{$field} =~ /(^|, *)$value *(,|$)/
308 '>'. $record->getfield($href->{$field}{'select_label'})
310 $html .= '</SELECT>';
313 $html .= '</TD></TR>';
317 $html .= '<INPUT TYPE="hidden" NAME="plandata" VALUE="'.
318 join(',', keys %{ $href } ). '">'.
321 $html .= '<INPUT TYPE="submit" VALUE="'.
322 ( $hashref->{pkgpart} ? "Apply changes" : "Add package" ).
323 '" onClick="fchanged(this)">';
332 <BR><BR>Price plan <%= $widget->html %>