Changeset 28828 for trunk/ippMonitor/raw/czartool_labels.php

Timestamp:

Aug 2, 2010, 1:22:02 PM (16 years ago)

Author:

rhenders

Message:

Now updating Db when reverting

File:

• trunk/ippMonitor/raw/czartool_labels.php (modified) (7 diffs)

trunk/ippMonitor/raw/czartool_labels.php

@@ -31 +31 @@
 $selectedLabel = $_GET[label];
 $selectedServer = $_GET[server];
-$selectedRevertServer = $_GET[revertserver];
 $selectedRevertStage = $_GET[revertstage];
 $selectedRevertMode = $_GET[revertmode];
@@ -39 +38 @@
 
 // deal with reverts: turn on or off if requested and pass current revert state for this stage onto labels table later
-$currentRevertMode;
-if ($selectedRevertStage != "" && $selectedRevertMode != "" && $selectedRevertServer != "" ) {
-
-    exec("czartool_revert.pl -s $selectedRevertServer -t $selectedRevertStage -o $selectedRevertMode", $response, $status);
+if ($selectedRevertStage != "" && $selectedRevertMode != "") {
+
+    exec("czartool_revert.pl -t $selectedRevertStage -o $selectedRevertMode", $response, $status);
+    $currentRevertMode;
     if ($response[0] == "off") $currentRevertMode = 0;
     else if ($response[0] == "on") $currentRevertMode = 1;
+
+    setRevertStatus($czardb, $selectedRevertStage, $currentRevertMode);
 }
 $debug = 0;
@@ -92 +93 @@
 
     echo "<td> \n";
-      createLabelsTable($pass, $proj, $czardb, $stdsLabels, $distLabels, $pubLabels, $stages, $states, "new", $selectedLabel, $selectedStage, $selectedRevertStage, $currentRevertMode);
+      createLabelsTable($pass, $proj, $czardb, $stdsLabels, $distLabels, $pubLabels, $stages, $states, "new", $selectedLabel, $selectedStage);
     echo "</td>\n";
 
@@ -203 +204 @@
 #
 ###########################################################################
-function createLabelsTable($pass, $proj, $db, $stdsLabels, $distLabels, $pubLabels, $stages, $states, $selectedState, $selectedLabel, $selectedStage, $selectedRevertStage, $currentRevertMode) {
+function createLabelsTable($pass, $proj, $db, $stdsLabels, $distLabels, $pubLabels, $stages, $states, $selectedState, $selectedLabel, $selectedStage) {
 
     // set up table columns
@@ -215 +216 @@
     foreach ($stages as &$stage) {
 
-        $revertOnOff=array();
-        if ($stage == "destreak" or $stage == "dist") $server = "distribution";
-        else $server = "stdscience";
-        if ($stage == $selectedRevertStage) $reverting = $currentRevertMode;
-        else $reverting = getRevertStatus($db, $stage);
-        $link = "czartool_labels.php?pass=" . $pass . "&proj=" . $proj . "&label=" . $selectedLabel . "&stage=" . $selectedStage . "&revertserver=" . $server . "&revertstage=" . $stage . "&revertmode=";
+        $reverting = getRevertStatus($db, $stage);
+        $link = "czartool_labels.php?pass=" . $pass . "&proj=" . $proj . "&label=" . $selectedLabel . "&stage=" . $selectedStage . "&revertstage=" . $stage . "&revertmode=";
         if(!$reverting) {$label =  "Start";$link = $link . "on";}
         if($reverting) {$label = "Stop";$link = $link . "off";}
@@ -326 +323 @@
 ###########################################################################
 #
+# Sets reverts status 
+#
+###########################################################################
+function setRevertStatus($db, $stage, $reverting) {
+
+    $sql = "UPDATE reverts SET reverting = $reverting WHERE stage LIKE '$stage'";
+    if ($debug) {echo "$sql<br>";}
+
+    $qry = $db->query($sql);
+    if (dberror($qry)) {echo "<b>error with $sql </b><br>\n";}
+}
+
+###########################################################################
+#
 # Returns whether this stage is reverting or not
 #
@@ -332 +343 @@
 
     $anyFaults = false;
-    $sql = "SELECT reverting FROM $stage ORDER BY timestamp DESC LIMIT 1";
+
+    $sql = "SELECT reverting FROM reverts WHERE stage LIKE '$stage'";
     if ($debug) {echo "$sql<br>";}