X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2Fbin%2Ffreeside-torrus-srvderive;h=cb2bcf41af6f72d6640bd9a1bb2c22cac2102cc7;hb=bed7609980610c6582e9a3842d28f15f837efa76;hp=6f949a2d5087651e4ee07d3b803be3a6d5d34383;hpb=e508799ff74d8bbf26b7cab53a255fe2a374d0f4;p=freeside.git

diff --git a/FS/bin/freeside-torrus-srvderive b/FS/bin/freeside-torrus-srvderive
index 6f949a2d5..cb2bcf41a 100644
--- a/FS/bin/freeside-torrus-srvderive
+++ b/FS/bin/freeside-torrus-srvderive
@@ -2,16 +2,17 @@
 
 use strict;
 use Date::Parse;
+use Date::Format;
 use FS::Daemon ':all'; #daemonize1 drop_root daemonize2 myexit logfile sig*
 use FS::UID qw( adminsuidsetup dbh driver_name );
 use FS::Record qw( qsearch str2time_sql str2time_sql_closing concat_sql );
 use FS::torrus_srvderive;
 
-our $DEBUG = 2;
+our $DEBUG = 1;
 
 my $user = shift or die &usage;
 $FS::Daemon::PID_NEWSTYLE = 1;
-daemonize1('freeside-torrus-srvderive');
+daemonize1('torrus-srvderive');
 
 drop_root();
 
@@ -47,12 +48,17 @@ my $sql = "
     WHERE NOT EXISTS (
                        SELECT 1 FROM srvexport AS other
                          WHERE other.serviceid IN ( $in, $out )
+                           AND srvexport.srv_date = other.srv_date
                            AND ABS( $_date - $other_date ) <= 60
                      )
-    ORDER BY id
-    LIMIT 10
 ";
 
+my $orderlimit = "
+    ORDER BY srv_date, srv_time
+    LIMIT 100
+";
+
+
 while (1) {
 
   my $found = 0;
@@ -61,19 +67,67 @@ while (1) {
 
     my $serviceid = $torrus_srvderive->serviceid;
 
-    warn $sql if $DEBUG > 1;
+    my @serviceids = $torrus_srvderive->component_serviceids;
+
+    my @in = ();
+    for my $dir ('_IN', '_OUT') {
+      push @in, map dbh->quote("$_$dir"), @serviceids;
+    }
+    my $in = join(',', @in);
+
+    my $ssql = "
+      $sql AND EXISTS (
+                       SELECT 1 FROM srvexport AS other
+                         WHERE other.serviceid IN ($in)
+                           AND srvexport.srv_date = other.srv_date
+                           AND ABS( $_date - $other_date ) <= 60
+                     )
+      $orderlimit
+    ";
+
+    warn $sql if $DEBUG > 2;
     my $sth = dbh->prepare($sql) or die $DBI::errstr; #better recovery?
     $sth->execute($serviceid, $serviceid) or die $sth->errstr;
     my $prev = 0;
     while ( my $row = $sth->fetchrow_arrayref ) {
-      $found++;
+      last if sigterm() || sigint();
+
       my( $srv_date, $srv_time ) = @$row;
       my $cur = str2time( "$srv_date $srv_time" );
       next if $cur-$prev <= 60;
-      
+      last if time - $cur <= 300;
+
       warn "no $serviceid for $srv_date $srv_time; adding\n"
         if $DEBUG;
+      $found++;
 
+      for my $dir ('_IN', '_OUT') {
+
+        my $sin = join(',', map dbh->quote("$_$dir"), @serviceids);
+
+        my $sum = "
+          SELECT COALESCE(SUM(value),0) FROM srvexport AS other
+            WHERE other.serviceid IN ($sin)
+              AND ABS( $cur - $other_date ) <= 60
+        ";
+
+        my $isql = "
+          INSERT INTO srvexport ( srv_date, srv_time, serviceid, value, intvl )
+            VALUES ( ?, ?, ?, ($sum), ? )
+        ";
+        my @param = ( time2str('%Y-%m-%d', $cur), #srv_date
+                      time2str('%X', $cur),       #srv_time
+                      "$serviceid$dir",
+                      300, #intvl ... 
+                    );
+        warn $isql. ' with param '. join(',',@param). "\n"
+          if $DEBUG > 1;
+
+        my $isth = dbh->prepare($isql) or die $DBI::errstr; #better recovery?
+        $isth->execute( @param )       or die $isth->errstr;
+        dbh->commit                    or die dbh->errstr;
+                        
+      }
 
       $prev = $cur;
     }