From: ivan Date: Sun, 27 Feb 2011 20:31:24 +0000 (+0000) Subject: add start of torrus srvderive daemon, RT#10574 X-Git-Tag: freeside_2_3_0~552 X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=2ea1bf50d3c8c08c208a412d9f468d9dfccb0b60 add start of torrus srvderive daemon, RT#10574 --- 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