From 88d8ee93b964e9c291be6e35e0c81c71e454d72a Mon Sep 17 00:00:00 2001 From: ivan Date: Sun, 27 Feb 2011 03:26:57 +0000 Subject: [PATCH] add start of torrus srvderive daemon, RT#10574 --- FS/bin/freeside-torrus-srvderive | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/FS/bin/freeside-torrus-srvderive b/FS/bin/freeside-torrus-srvderive index 895cc24b8..50dcb9238 100644 --- a/FS/bin/freeside-torrus-srvderive +++ b/FS/bin/freeside-torrus-srvderive @@ -39,11 +39,14 @@ my $other_date = concat_sql([ 'other.srv_date', "' '", 'other.srv_time' ]); $other_date = "CAST( $other_date AS TIMESTAMP )" if driver_name =~ /^Pg/i; $other_date = str2time_sql. $other_date. str2time_sql_closing; +my $in = concat_sql([ '?', "'_IN'" ) +my $out = concat_sql([ '?', "'_OUT'" ) + my $sql = " SELECT DISTINCT srv_date, srv_time FROM srvexport WHERE NOT EXISTS ( SELECT 1 FROM srvexport AS other - WHERE other.serviceid IN ( ?||'_IN', ?||'_OUT') + WHERE other.serviceid IN ( $in, $out ) AND ABS( $_date - $other_date ) <= 60 ) ORDER BY id -- 2.11.0