#!/usr/bin/perl -Tw # # $Id: cust_pkg.cgi,v 1.8 1999-02-28 00:04:01 ivan Exp $ # # Usage: cust_pkg.cgi pkgnum # http://server.name/path/cust_pkg.cgi?pkgnum # # ivan@voicenet.com 96-dec-15 # # services section needs to be cleaned up, needs to display extraneous # entries in cust_pkg! # ivan@voicenet.com 96-dec-31 # # added navigation bar # ivan@voicenet.com 97-jan-30 # # changed and fixed up suspension and cancel stuff, now you can't add # services to a cancelled package # ivan@voicenet.com 97-feb-27 # # rewrote for new API, still needs to be cleaned up! # ivan@voicenet.com 97-jul-29 # # no FS::Search ivan@sisd.com 98-mar-7 # # $Log: cust_pkg.cgi,v $ # Revision 1.8 1999-02-28 00:04:01 ivan # removed misleading comments # # Revision 1.7 1999/01/19 05:14:20 ivan # for mod_perl: no more top-level my() variables; use vars instead # also the last s/create/new/; # # Revision 1.6 1999/01/18 09:41:44 ivan # all $cgi->header calls now include ( '-expires' => 'now' ) for mod_perl # (good idea anyway) # # Revision 1.5 1998/12/23 03:11:40 ivan # *** empty log message *** # # Revision 1.3 1998/12/17 09:57:22 ivan # s/CGI::(Base|Request)/CGI.pm/; # # Revision 1.2 1998/11/13 09:56:49 ivan # change configuration file layout to support multiple distinct databases (with # own set of config files, export, etc.) # use strict; use vars qw ( $cgi %uiview %uiadd $part_svc $query $pkgnum $cust_pkg $part_pkg $custnum $susp $cancel $expire $pkg $comment $setup $bill $otaker ); use Date::Format; use CGI; use CGI::Carp qw(fatalsToBrowser); use FS::UID qw(cgisuidsetup); use FS::CGI qw(popurl header); use FS::Record qw(qsearch qsearchs); use FS::part_svc; use FS::cust_pkg; use FS::part_pkg; use FS::pkg_svc; use FS::cust_svc; $cgi = new CGI; cgisuidsetup($cgi); foreach $part_svc ( qsearch('part_svc',{}) ) { $uiview{$part_svc->svcpart} = popurl(2). "view/". $part_svc->svcdb . ".cgi"; $uiadd{$part_svc->svcpart}= popurl(2). "edit/". $part_svc->svcdb . ".cgi"; } print $cgi->header( '-expires' => 'now' ), header('Package View', ''); ($query) = $cgi->keywords; $query =~ /^(\d+)$/; $pkgnum = $1; #get package record $cust_pkg = qsearchs('cust_pkg',{'pkgnum'=>$pkgnum}); die "No package!" unless $cust_pkg; $part_pkg = qsearchs('part_pkg',{'pkgpart'=>$cust_pkg->getfield('pkgpart')}); #nav bar $custnum = $cust_pkg->getfield('custnum'); print qq!
Package: $pkg - $comment";
($setup,$bill)=($cust_pkg->getfield('setup'),$cust_pkg->getfield('bill'));
print " Order taken by $otaker";
unless ($cancel) {
#services
print <
Setup: ", $setup ? time2str("%D",$setup) : "(Not setup)" ,"";
print "
Next bill: ", $bill ? time2str("%D",$bill) : "" ,"";
if ($susp) {
print "
Suspended: ", time2str("%D",$susp), "";
print qq! Unsuspend! unless $cancel;
} else {
print qq!
Suspend! unless $cancel;
}
if ($expire) {
print "
Expire: ", time2str("%D",$expire), "";
}
print <
Cancelled: ", time2str("%D",$cancel), "";
} else {
print qq!
Cancel now!;
}
#otaker
$otaker = $cust_pkg->getfield('otaker');
print "
Click on service to view/edit/add service.
END
} else {
print <Service
END
#list of services this pkgpart includes
my($pkg_svc,%pkg_svc);
foreach $pkg_svc ( qsearch('pkg_svc',{'pkgpart'=> $cust_pkg->pkgpart }) ) {
$pkg_svc{$pkg_svc->svcpart} = $pkg_svc->quantity if $pkg_svc->quantity;
}
#list of records from cust_svc
my($svcpart);
foreach $svcpart (sort {$a <=> $b} keys %pkg_svc) {
my($svc)=qsearchs('part_svc',{'svcpart'=>$svcpart})->getfield('svc');
my(@cust_svc)=qsearch('cust_svc',{'pkgnum'=>$pkgnum,
'svcpart'=>$svcpart,
});
my($enum);
for $enum ( 1 .. $pkg_svc{$svcpart} ) {
my($cust_svc);
if ( $cust_svc=shift @cust_svc ) {
my($svcnum)=$cust_svc->svcnum;
print <(View) $svc
(Add) $svc
or
(Link to existing) $svc
END
}
}
warn "WARNING: Leftover services pkgnum $pkgnum!" if @cust_svc;;
}
print "