From d933a72ec7a51a698e7b91b94d2f24df2228f7aa Mon Sep 17 00:00:00 2001
From: rettenbe <rettenbe@594d385d-05f5-0310-b6e9-bd551577e9d8>
Date: Thu, 21 Feb 2008 15:06:27 +0000
Subject: [PATCH] timestamp updates at jobdb are forbidden while status is
 'processing'

git-svn-id: https://oss.gonicus.de/repositories/gosa/trunk@9029 594d385d-05f5-0310-b6e9-bd551577e9d8
---
 gosa-si/modules/GosaPackages.pm | 30 +++++++++++++++++-------------
 gosa-si/tests/client.php        |  3 ++-
 2 files changed, 19 insertions(+), 14 deletions(-)

diff --git a/gosa-si/modules/GosaPackages.pm b/gosa-si/modules/GosaPackages.pm
index 772955f12..14c5209ae 100644
--- a/gosa-si/modules/GosaPackages.pm
+++ b/gosa-si/modules/GosaPackages.pm
@@ -531,25 +531,29 @@ sub update_status_jobdb_entry {
 
         # conditions
         # no timestamp update if status eq waiting
-        
+        my $res_hash = $main::job_db->select_dbentry("SELECT * FROM $table $where AND status='processing' ");
+        if( (0 != keys(%$res_hash)) && ($update =~ /timestamp/i) ) {
+            $error ++;
+            $out_xml = "<answer1>1</answer1><error_string>there is no timestamp update allowed while status is 'processing'</error_string>";
+        }
+
+        if( $error == 0 ) {
+            my $sql_statement = "UPDATE $table $update $where";
+            # execute db query
+            my $db_res = $main::job_db->update_dbentry($sql_statement);
 
-        my $sql_statement = "UPDATE $table $update $where";
-print STDERR "================================================\n";
-print STDERR "$sql_statement\n";
-        # execute db query
-        my $db_res = $main::job_db->update_dbentry($sql_statement);
+            # check success of db update
+            if( not $db_res > 0 ) { $error++; };
 
-        # check success of db update
-        if( not $db_res > 0 ) { $error++; };
+        }
     }
 
     if( $error == 0) {
-        $out_xml = "<xml><header>answer</header><source>$server_address</source><target>GOSA</target><answer1>0</answer1></xml>";
+        $out_xml = "<answer1>0</answer1>";
     }
-    my @out_msg_l = ( $out_xml );
-
-print STDERR $out_xml."\n";
-
+    
+    my $out_msg = sprintf("<xml><header>answer</header><source>%s</source><target>GOSA</target>%s</xml>", $server_address, $out_xml);
+    my @out_msg_l = ( $out_msg );
     return @out_msg_l;
 }
 
diff --git a/gosa-si/tests/client.php b/gosa-si/tests/client.php
index f2c316851..02efe6cb9 100755
--- a/gosa-si/tests/client.php
+++ b/gosa-si/tests/client.php
@@ -30,6 +30,7 @@ if($sock->connected()){
 $data = "<xml> <header>gosa_reload_ldap_config</header> <source>GOSA</source><target>00:1B:77:04:8A:6C</target></xml>";
 
 # update  
+$data = "<xml> <header>gosa_update_status_jobdb_entry</header> <source>GOSA</source><target>GOSA</target><where><clause><phrase> <macaddress>00:01:6c:9d:b9:fa</macaddress></phrase></clause> </where> <update><timestamp>23450101000000</timestamp><result>XXXXXXXXXXXXXXx</result></update></xml>";
 #$data = "<xml> <header>gosa_update_status_jobdb_entry</header> <source>GOSA</source><target>GOSA</target><where><clause><phrase> <status>waiting</status></phrase></clause> </where> <update><status>processing</status> <result>update</result></update></xml>";
 
 # query
@@ -60,7 +61,7 @@ $data = "<xml> <header>gosa_reload_ldap_config</header> <source>GOSA</source><ta
 
 
 #$data = "<xml><header>job_trigger_action_reinstall</header><source>GOSA</source><target>00:01:6c:9d:b9:fa</target><macaddress>00:01:6c:9d:b9:fa</macaddress><timestamp>20130101000000</timestamp></xml>";
-#$data = "<xml><header>job_trigger_action_reinstall</header><source>GOSA</source><target>00:01:6c:9d:b9:fa</target><macaddress>00:01:6c:9d:b9:fa</macaddress></xml>";
+#$data = "<xml><header>job_trigger_action_reinstall</header><source>GOSA</source><target>00:01:6c:9d:b9:fa</target><macaddress>00:01:6c:9d:b9:fa</macaddress><timestamp>98760101000000</timestamp></xml>";
 
 
     $sock->write($data);
-- 
2.30.2