Changeset 40 for trunk/cleanup_gfac.php

Timestamp:

Apr 28, 2019, 3:00:50 PM (5 years ago)

Author:

gegorbet

Message:

more time information in error,completion emails

File:

• trunk/cleanup_gfac.php (modified) (4 diffs)

trunk/cleanup_gfac.php

@@ -33 +33 @@
    global $editXMLFilename;
    global $submittime;
+   global $endtime;
    global $status;
    global $stdout;
@@ -76 +77 @@
              "WHERE h.HPCAnalysisRequestID=$requestID";
    */
-   $query  = "SELECT clusterName, submitTime, queueStatus, method "              .
+   $query  = "SELECT clusterName, submitTime, queueStatus, analType "            .
              "FROM HPCAnalysisRequest h, HPCAnalysisResult r "                   .
              "WHERE h.HPCAnalysisRequestID=$requestID "                          .
@@ -98 +99 @@
 
    // Get the GFAC ID
-   $query = "SELECT HPCAnalysisResultID, gfacID FROM HPCAnalysisResult " .
+   $query = "SELECT HPCAnalysisResultID, gfacID, endTime FROM HPCAnalysisResult " .
             "WHERE HPCAnalysisRequestID=$requestID";
 
@@ -110 +111 @@
    }
 
-   list( $HPCAnalysisResultID, $gfacID ) = mysqli_fetch_array( $result ); 
+   list( $HPCAnalysisResultID, $gfacID, $endtime ) = mysqli_fetch_array( $result ); 
 
    ////////