add index on cust_main.refnum, speeds up advertising source list

[freeside.git] / htetc / global.asa
diff --git a/htetc/global.asa b/htetc/global.asa

index d87f1ea..782e062 100644 (file)
--- a/htetc/global.asa
+++ b/htetc/global.asa
@@ -4,7 +4,8 @@ BEGIN { eval "use Devel::AutoProfiler;"; } #only if installed...
  
  use strict;
  use vars qw( $cgi $p );
-use CGI;
+use Apache::ASP 2.55;
+use CGI 2.47;
  #use CGI::Carp qw(fatalsToBrowser);
  use Date::Format;
  use Date::Parse;
@@ -13,15 +14,23 @@ use Tie::IxHash;
  use HTML::Entities;
  use IO::Handle;
  use IO::File;
+use Net::Whois::Raw qw(whois);
+if ( $] < 5.006 ) {
+  eval "use Net::Whois::Raw 0.32 qw(whois)";
+  die $@ if $@;
+}
+use Business::CreditCard;
  use String::Approx qw(amatch);
  use Chart::LinesPoints;
-use HTML::Widgets::SelectLayers 0.02;
+use HTML::Widgets::SelectLayers 0.03;
  use FS::UID qw(cgisuidsetup dbh getotaker datasrc driver_name);
  use FS::Record qw(qsearch qsearchs fields dbdef);
  use FS::Conf;
  use FS::CGI qw(header menubar popurl table itable ntable idiot eidiot
                 small_custview myexit http_header);
  use FS::Msgcat qw(gettext geterror);
+use FS::Misc qw( send_email );
+use FS::Report::Table::Monthly;
  
  use FS::agent;
  use FS::agent_type;
@@ -42,6 +51,7 @@ use FS::part_pkg;
  use FS::part_referral;
  use FS::part_svc;
  use FS::part_svc_router;
+use FS::part_virtual_field;
  use FS::pkg_svc;
  use FS::port;
  use FS::queue qw(joblisting);
@@ -53,12 +63,9 @@ use FS::svc_domain;
  use FS::svc_forward;
  use FS::svc_www;
  use FS::router;
-use FS::part_router_field;
-use FS::router_field;
  use FS::addr_block;
-use FS::part_sb_field;
-use FS::sb_field;
  use FS::svc_broadband;
+use FS::svc_external;
  use FS::type_pkgs;
  use FS::part_export;
  use FS::part_export_option;
@@ -66,7 +73,6 @@ use FS::export_svc;
  use FS::msgcat;
  
  sub Script_OnStart {
-  $Response->AddHeader('Pragma' => 'no-cache');
    $Response->AddHeader('Cache-control' => 'no-cache');
  #  $Response->AddHeader('Expires' => 0);
    $Response->{Expires} = -36288000;
@@ -75,7 +81,8 @@ sub Script_OnStart {
    &cgisuidsetup($cgi);
    $p = popurl(2);
    #print $cgi->header( '-expires' => 'now' );
-  dbh->{'private_profile'} = {} if dbh->can('sprintProfile');
+  #dbh->{'private_profile'} = {} if dbh->can('sprintProfile');
+  dbh->{'private_profile'} = {} if UNIVERSAL::can(dbh, 'sprintProfile');
  
    #really should check for FS::Profiler or something
      # Devel::AutoProfiler _our_ VERSION?  thanks a fucking lot
@@ -112,7 +119,7 @@ sub Script_OnFlush {
    #$$ref = $cgi->header() . $$ref;
    #warn "Script_OnFlush called with dbh ". dbh. "\n";
    #if ( dbh->can('sprintProfile') ) {
-  if ( UNIVERSAL::can(dbh,'sprintProfile') ) {
+  if ( UNIVERSAL::can(dbh, 'sprintProfile') ) {
      #warn "dbh can sprintProfile\n";
      if ( lc($Response->{ContentType}) eq 'text/html' ) { #con
        #warn "contenttype is sprintProfile\n";
@@ -139,8 +146,12 @@ if ( defined(@DBIx::Profile::ISA) ) {
      my( $self, $location) = @_;
      my $page =
        $cgi->header.
-      qq!<HTML><BODY>Redirect to <A HREF="$location">$location</A><BR><BR>!.
-      '<PRE>'. encode_entities(dbh->sprintProfile()).
+      qq!<HTML><BODY>Redirect to <A HREF="$location">$location</A>!.
+      '<BR><BR><PRE>'.
+        ( UNIVERSAL::can(dbh, 'sprintProfile')
+            ? encode_entities(dbh->sprintProfile())
+            : 'DBIx::Profile missing sprintProfile method;'.
+              'unpatched or too old?'                        ).
        "\n\n". &sprintAutoProfile().  '</PRE>'.
        '</BODY></HTML>';
      dbh->{'private_profile'} = {};
@@ -189,5 +200,43 @@ sub sprintAutoProfile {
  
  }
  
+sub include {
+  ( my $file = shift ) =~ s(^/)(%%%FREESIDE_DOCUMENT_ROOT%%%/);
+  #broken in 5.005# ${$Response->TrapInclude($file, @_)};
+  my $ref = $Response->TrapInclude($file, @_);
+  $$ref;
+}
+
+if ( defined(@DBIx::Profile::ISA) ) {
+
+  #false laziness w/above
+  *redirect = sub {
+    my($location) = @_;
+
+    ${$Response->{BinaryRef}} = 
+      $cgi->header.
+      qq!<HTML><BODY>Redirect to <A HREF="$location">$location</A>!.
+      '<BR><BR><PRE>'.
+        ( UNIVERSAL::can(dbh, 'sprintProfile')
+            ? encode_entities(dbh->sprintProfile())
+            : 'DBIx::Profile missing sprintProfile method;'.
+              'unpatched or too old?'                        ).
+      "\n\n". &sprintAutoProfile().  '</PRE>'.
+      '</BODY></HTML>';
+
+    dbh->{'private_profile'} = {};
+
+    $Response->End;
+
+  };
+
+} else {
+
+  *redirect = sub {
+    $Response->Redirect(@_);
+  }
+
+}
+
  1;