Changeset 40 for trunk/cleanup.php
- Timestamp:
- Apr 28, 2019, 3:00:50 PM (6 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/cleanup.php
r39 r40 32 32 global $editXMLFilename; 33 33 global $submittime; 34 global $endtime; 34 35 global $status; 35 36 global $stderr; … … 73 74 list( $personID ) = mysqli_fetch_array( $result ); 74 75 75 $query = "SELECT clusterName, submitTime, queueStatus, analType " 76 "FROM HPCAnalysisRequest h, HPCAnalysisResult r " 77 "WHERE h.HPCAnalysisRequestID=$requestID " 76 $query = "SELECT clusterName, submitTime, queueStatus, analType " . 77 "FROM HPCAnalysisRequest h, HPCAnalysisResult r " . 78 "WHERE h.HPCAnalysisRequestID=$requestID " . 78 79 "AND h.HPCAnalysisRequestID=r.HPCAnalysisRequestID"; 79 80 … … 95 96 96 97 // Get the GFAC ID 97 $query = "SELECT HPCAnalysisResultID, gfacID FROM HPCAnalysisResult " .98 $query = "SELECT HPCAnalysisResultID, gfacID, endTime FROM HPCAnalysisResult " . 98 99 "WHERE HPCAnalysisRequestID=$requestID"; 99 100 … … 107 108 } 108 109 109 list( $HPCAnalysisResultID, $gfacID ) = mysqli_fetch_array( $result );110 list( $HPCAnalysisResultID, $gfacID, $endtime ) = mysqli_fetch_array( $result ); 110 111 111 112 // Get data from global GFAC DB then insert it into US3 DB … … 664 665 global $email_address; 665 666 global $submittime; 667 global $endtime; 666 668 global $queuestatus; 667 669 global $status; … … 742 744 743 745 // Try to avoid spam filters 744 $now = time(); 746 $now = time(); 747 $tnow = date( 'Y-m-d H:i:s' ); 745 748 $headers .= "Message-ID: <" . $now . "cleanup@$dbhost>\n"; 746 749 $headers .= "X-Mailer: PHP v" . phpversion() . "\n"; … … 753 756 754 757 Submission Time : $submittime 758 Job End Time : $endtime 759 Mail Time : $tnow 755 760 LIMS Host : $limshost 756 761 Analysis ID : $gfacID
Note:
See TracChangeset
for help on using the changeset viewer.