htdocs/edit/cust_main.cgi

   1 #!/usr/bin/perl -Tw
   2 #
   3 # cust_main.cgi: Edit a customer (output form)
   4 #
   5 # Usage: cust_main.cgi custnum
   6 #        http://server.name/path/cust_main.cgi?custnum
   7 #
   8 # Note: Should be run setuid freeside as user nobody.
   9 #
  10 # ivan@voicenet.com 96-nov-29 -> 96-dec-04
  11 #
  12 # Blank custnum for new customer.
  13 # ivan@voicenet.com 96-dec-16
  14 #
  15 # referral defaults to blank, to force people to pick something
  16 # ivan@voicenet.com 97-jun-4
  17 #
  18 # rewrote for new API
  19 # ivan@voicenet.com 97-jul-28
  20 #
  21 # new customer is null, not '#'
  22 # otaker gotten from &getotaker instead of $ENV{REMOTE_USER}
  23 # ivan@sisd.com 97-nov-12
  24 #
  25 # cgisuidsetup($cgi);
  26 # no need for old_ fields.
  27 # now state+county is a select field (took out PA hack)
  28 # used autoloaded $cust_main->field methods
  29 # ivan@sisd.com 97-dec-17
  30 #
  31 # fixed quoting problems ivan@sisd.com 98-feb-23
  32 #
  33 # paydate sql update ivan@sisd.com 98-mar-5
  34 #
  35 # Changes to allow page to work at a relative position in server
  36 # Changed 'day' to 'daytime' because Pg6.3 reserves the day word
  37 # Added test for paydate in mm-dd-yyyy format for Pg6.3 default format
  38 #       bmccane@maxbaud.net     98-apr-3
  39 #
  40 # fixed one missed day->daytime ivan@sisd.com 98-jul-13
  41
  42 use strict;
  43 use CGI::Base;
  44 use CGI::Carp qw(fatalsToBrowser);
  45 use FS::UID qw(cgisuidsetup getotaker);
  46 use FS::Record qw(qsearch qsearchs);
  47 use FS::cust_main;
  48
  49 my($cgi) = new CGI::Base;
  50 $cgi->get;
  51
  52 cgisuidsetup($cgi);
  53
  54 SendHeaders(); # one guess.
  55
  56 #get record
  57 my($custnum,$action,$cust_main);
  58 if ( $cgi->var('QUERY_STRING') =~ /^(\d+)$/ ) { #editing
  59   $custnum=$1;
  60   $cust_main = qsearchs('cust_main',{'custnum'=>$custnum});
  61   $action='Edit';
  62 } else {
  63   $custnum='';
  64   $cust_main = create FS::cust_main ( {} );
  65   $cust_main->setfield('otaker',&getotaker);
  66   $cust_main->setfield('country','US');
  67   $action='Add';
  68 }
  69
  70 print <<END;
  71 <HTML>
  72   <HEAD>
  73     <TITLE>Customer $action</TITLE>
  74   </HEAD>
  75   <BODY>
  76     <CENTER>
  77     <H1>Customer $action</H1>
  78     </CENTER>
  79     <FORM ACTION="process/cust_main.cgi" METHOD=POST>
  80     <PRE>
  81 END
  82
  83 print qq!<INPUT TYPE="hidden" NAME="custnum" VALUE="$custnum">!,
  84       qq!Customer #<FONT SIZE="+1"><B>!;
  85 print $custnum ? $custnum : " (NEW)" , "</B></FONT>";
  86
  87 #agentnum
  88 my($agentnum)=$cust_main->agentnum || 1; #set to first agent by default
  89 my(@agents) = qsearch('agent',{});
  90 print qq!\n\nAgent # <SELECT NAME="agentnum" SIZE="1">!;
  91 my($agent);
  92 foreach $agent (sort {
  93   $a->agent cmp $b->agent;
  94 } @agents) {
  95     print "<OPTION" . " SELECTED"x($agent->agentnum==$agentnum),
  96     ">", $agent->agentnum,": ", $agent->agent, "\n";
  97 }
  98 print "</SELECT>";
  99
 100 #referral
 101 #unless ($custnum) {
 102   my($refnum)=$cust_main->refnum || 0; #to avoid "arguement not numeric" error
 103   my(@referrals) = qsearch('part_referral',{});
 104   print qq!\nReferral <SELECT NAME="refnum" SIZE="1">!;
 105   print "<OPTION> \n";
 106   my($referral);
 107   foreach $referral (sort {
 108     $a->refnum <=> $b->refnum;
 109   } @referrals) {
 110     print "<OPTION" . " SELECTED"x($referral->refnum==$refnum),
 111     ">", $referral->refnum, ": ", $referral->referral,"\n";
 112   }
 113   print "</SELECT>";
 114 #}
 115
 116 my($last,$first,$ss,$company,$address1,$address2,$city)=(
 117   $cust_main->last,
 118   $cust_main->first,
 119   $cust_main->ss,
 120   $cust_main->company,
 121   $cust_main->address1,
 122   $cust_main->address2,
 123   $cust_main->city,
 124 );
 125
 126 print <<END;
 127
 128
 129 Name (last)<INPUT TYPE="text" NAME="last" VALUE="$last"> (first)<INPUT TYPE="text" NAME="first" VALUE="$first">  SS# <INPUT TYPE="text" NAME="ss" VALUE="$ss" SIZE=11 MAXLENGTH=11>
 130 Company <INPUT TYPE="text" NAME="company" VALUE="$company">
 131 Address <INPUT TYPE="text" NAME="address1" VALUE="$address1" SIZE=40 MAXLENGTH=40>
 132         <INPUT TYPE="text" NAME="address2" VALUE="$address2" SIZE=40 MAXLENGTH=40>
 133 City <INPUT TYPE="text" NAME="city" VALUE="$city">  State (county) <SELECT NAME="state" SIZE="1">
 134 END
 135
 136 foreach ( qsearch('cust_main_county',{}) ) {
 137   print "<OPTION";
 138   print " SELECTED" if ( $cust_main->state eq $_->state
 139                       && $cust_main->county eq $_->county );
 140   print ">",$_->state;
 141   print " (",$_->county,")" if $_->county;
 142 }
 143 print "</SELECT>";
 144
 145 my($zip,$country,$daytime,$night,$fax)=(
 146   $cust_main->zip,
 147   $cust_main->country,
 148   $cust_main->daytime,
 149   $cust_main->night,
 150   $cust_main->fax,
 151 );
 152
 153 print <<END;
 154   Zip <INPUT TYPE="text" NAME="zip" VALUE="$zip" SIZE=10 MAXLENGTH=10>
 155 Country: <FONT SIZE="+1"><B>$country</B></FONT><INPUT TYPE="hidden" NAME="country" VALUE="$country">
 156
 157 Phone (daytime)<INPUT TYPE="text" NAME="daytime" VALUE="$daytime" SIZE=18 MAXLENGTH=20>  (night)<INPUT TYPE="text" NAME="night" VALUE="$night" SIZE=18 MAXLENGTH=20>  (fax)<INPUT TYPE="text" NAME="fax" VALUE="$fax" SIZE=12 MAXLENGTH=12>
 158
 159 END
 160
 161 my(%payby)=(
 162   'CARD' => "Credit card    ",
 163   'BILL' => "Billing    ",
 164   'COMP' => "Complimentary",
 165 );
 166 for (qw(CARD BILL COMP)) {
 167   print qq!<INPUT TYPE="radio" NAME="payby" VALUE="$_"!;
 168   print qq! CHECKED! if ($cust_main->payby eq "$_");
 169   print qq!>$payby{$_}!;
 170 }
 171
 172
 173 my($payinfo,$payname,$otaker)=(
 174   $cust_main->payinfo,
 175   $cust_main->payname,
 176   $cust_main->otaker,
 177 );
 178
 179 my($paydate);
 180 if ( $cust_main->paydate =~ /^(\d{4})-(\d{2})-\d{2}$/ ) {
 181   $paydate="$2/$1"
 182 } elsif ( $cust_main->paydate =~ /^(\d{2})-\d{2}-(\d{4}$)/ ) {
 183   $paydate="$1/$2"
 184 }
 185 else {
 186   $paydate='';
 187 }
 188
 189 print <<END;
 190
 191   Card number ,   P.O. #   or   Authorization    <INPUT TYPE="text" NAME="payinfo" VALUE="$payinfo" SIZE=19 MAXLENGTH=19>
 192 END
 193
 194 print qq!Exp. date (MM/YY or MM/YYYY)<INPUT TYPE="text" NAME="paydate" VALUE="$paydate" SIZE=8 MAXLENGTH=7>    Billing name <INPUT TYPE="text" NAME="payname" VALUE="$payname">\n<INPUT TYPE="checkbox" NAME="tax" VALUE="Y"!;
 195 print qq! CHECKED! if $cust_main->tax eq "Y";
 196 print qq!> Tax Exempt!;
 197
 198 print <<END;
 199
 200
 201 Order taken by: <FONT SIZE="+1"><B>$otaker</B></FONT><INPUT TYPE="hidden" NAME="otaker" VALUE="$otaker">
 202 </PRE>
 203 END
 204
 205 print qq!<CENTER><INPUT TYPE="submit" VALUE="!,
 206       $custnum ?  "Apply Changes" : "Add Customer", qq!"></CENTER>!;
 207
 208 print <<END;
 209
 210     </FORM>
 211   </BODY>
 212 </HTML>
 213 END
 214