From 2ea1bf50d3c8c08c208a412d9f468d9dfccb0b60 Mon Sep 17 00:00:00 2001 From: ivan Date: Sun, 27 Feb 2011 20:31:24 +0000 Subject: [PATCH] add start of torrus srvderive daemon, RT#10574 --- FS/bin/freeside-torrus-srvderive | 1 + 1 file changed, 1 insertion(+) diff --git a/FS/bin/freeside-torrus-srvderive b/FS/bin/freeside-torrus-srvderive index 9ecfbbc72..ce47414a6 100644 --- a/FS/bin/freeside-torrus-srvderive +++ b/FS/bin/freeside-torrus-srvderive @@ -48,6 +48,7 @@ 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 srv_date, srv_time -- 2.11.0