From: ivan <ivan>
Date: Sun, 27 Feb 2011 03:26:57 +0000 (+0000)
Subject: add start of torrus srvderive daemon, RT#10574
X-Git-Tag: freeside_2_3_0~572
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=88d8ee93b964e9c291be6e35e0c81c71e454d72a

add start of torrus srvderive daemon, RT#10574
---

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