Info by Run ID

2 ) ? "" : "AND people.personID = $myID "; $query = "SELECT experimentID, runID, lname " . "FROM experiment, projectPerson, people " . "WHERE experiment.projectID = projectPerson.projectID " . "AND projectPerson.personID = people.personID " . $users_clause . "ORDER BY lname, runID "; $result = mysql_query( $query ) or die( "Query failed : $query
" . mysql_error() ); if ( mysql_num_rows( $result ) == 0 ) return ""; $text = "
\n" . " \n" . "
\n"; return $text; } // A function to retrieve information about that runID function runID_info( $experimentID ) { $query = "SELECT people.personID, personGUID, lname, fname, email " . "FROM experiment, projectPerson, people " . "WHERE experiment.experimentID = $experimentID " . "AND experiment.projectID = projectPerson.projectID " . "AND projectPerson.personID = people.personID "; $result = mysql_query( $query ) or die( "Query failed : $query
\n" . mysql_error() ); list( $ID, $GUID, $lname, $fname, $email ) = mysql_fetch_array( $result ); $text = << Investigator Information ID: $ID GUID: $GUID Name: $fname $lname Email: $email HTML; $query = "SELECT experimentGUID, coeff1, coeff2, type, runType " . "FROM experiment, rotorCalibration " . "WHERE experimentID = $experimentID " . "AND experiment.rotorCalibrationID = rotorCalibration.rotorCalibrationID "; $result = mysql_query( $query ) or die( "Query failed : $query
\n" . mysql_error() ); list( $GUID, $coeff1, $coeff2, $type, $runType ) = mysql_fetch_array( $result ); $text .= << Run Information GUID: $GUID Rotor stretch coeff 1: $coeff1 Rotor stretch coeff 2: $coeff2 Experiment type: $type Run Type: $runType HTML; $query = "SELECT rawDataID, rawDataGUID, filename, solutionID " . "FROM rawData " . "WHERE experimentID = $experimentID " . "ORDER BY filename "; $result = mysql_query( $query ) or die( "Query failed : $query
\n" . mysql_error() ); if ( mysql_num_rows( $result ) == 0 ) return $text; $rawIDs = array(); $solutionIDs = array(); $text .= << Raw Data ID GUID Filename Solution HTML; while ( list( $ID, $GUID, $filename, $solutionID ) = mysql_fetch_array( $result ) ) { $rawIDs[] = $ID; $solutionIDs[] = $solutionID; $text .= <<$ID $GUID $filename $solutionID HTML; } $text .= "\n\n" . "\n"; $rawIDs_csv = implode( ", ", $rawIDs ); $query = "SELECT editedDataID, rawDataID, editGUID, filename " . "FROM editedData " . "WHERE rawDataID IN ( $rawIDs_csv ) " . "ORDER BY editedDataID, filename "; $result = mysql_query( $query ) or die( "Query failed : $query
\n" . mysql_error() ); if ( mysql_num_rows( $result ) == 0 ) return $text; $text .= << Edit Profiles ID GUID Filename Raw ID HTML; $editIDs = array(); while ( list ( $editID, $rawID, $GUID, $filename ) = mysql_fetch_array( $result ) ) { $editIDs[] = $editID; $text .= <<$editID $GUID $filename $rawID HTML; } $text .= "\n\n" . "\n"; $editIDs_csv = implode( ", ", $editIDs ); $query = "SELECT model.modelID, editedDataID, modelGUID, variance, meniscus, personID " . "FROM model LEFT JOIN modelPerson " . "ON ( model.modelID = modelPerson.modelID ) " . "WHERE editedDataID IN ( $editIDs_csv ) " . "ORDER BY modelID "; $result = mysql_query( $query ) or die( "Query failed : $query
\n" . mysql_error() ); if ( mysql_num_rows( $result ) != 0 ) { $text .= << Models ID GUID Edit ID Variance Meniscus Owner ID HTML; $modelIDs = array(); while ( list ( $modelID, $editID, $GUID, $variance, $meniscus, $personID ) = mysql_fetch_array( $result ) ) { $modelIDs[] = $modelID; $text .= <<$modelID $GUID $editID $variance $meniscus $personID HTML; } $text .= "\n\n" . "\n"; } if ( count( $modelIDs ) > 0 ) { $modelIDs_csv = implode( ", ", $modelIDs ); $query = "SELECT noiseID, noiseGUID, editedDataID, modelID, modelGUID, noiseType " . "FROM noise " . "WHERE modelID IN ( $modelIDs_csv ) " . "ORDER BY noiseID "; $result = mysql_query( $query ) or die( "Query failed : $query
\n" . mysql_error() ); if ( mysql_num_rows( $result ) != 0 ) { $text .= << Noise Linked to Models ID GUID Edit ID Model ID Model GUID Type HTML; while ( list ( $noiseID, $GUID, $editID, $modelID, $modelGUID, $type ) = mysql_fetch_array( $result ) ) { $text .= <<$noiseID $GUID $editID $modelID $modelGUID $type HTML; } $text .= "\n\n" . "\n"; } } $query = "SELECT noiseID, noiseGUID, editedDataID, modelID, modelGUID, noiseType " . "FROM noise " . "WHERE editedDataID IN ( $editIDs_csv ) " . "ORDER BY noiseID "; $result = mysql_query( $query ) or die( "Query failed : $query
\n" . mysql_error() ); if ( mysql_num_rows( $result ) != 0 ) { $text .= << Noise Linked to Edit Profiles ID GUID Edit ID Model ID Model GUID Type HTML; while ( list ( $noiseID, $GUID, $editID, $modelID, $modelGUID, $type ) = mysql_fetch_array( $result ) ) { $text .= <<$noiseID $GUID $editID $modelID $modelGUID $type HTML; } $text .= "\n\n" . "\n"; } $reportIDs = array(); $query = "SELECT reportID, reportGUID, title " . "FROM report " . "WHERE experimentID = $experimentID " . "ORDER BY reportID "; $result = mysql_query( $query ) or die( "Query failed : $query
\n" . mysql_error() ); if ( mysql_num_rows( $result ) != 0 ) { $text .= << Reports Related to This Experiment ID GUID Title HTML; while ( list ( $reportID, $GUID, $title ) = mysql_fetch_array( $result ) ) { $reportIDs[] = $reportID; $text .= <<$reportID $GUID $title HTML; } $text .= "\n\n" . "\n"; } $reportTripleIDs = array(); if ( ! empty( $reportIDs ) ) { $reportIDs_csv = implode( ",", $reportIDs ); $query = "SELECT reportTripleID, reportTripleGUID, resultID, triple, dataDescription, reportID " . "FROM reportTriple " . "WHERE reportID IN ( $reportIDs_csv ) " . "ORDER BY reportID, reportTripleID "; $result = mysql_query( $query ) or die( "Query failed : $query
\n" . mysql_error() ); if ( mysql_num_rows( $result ) != 0 ) { $text .= << Report Triples Related to Reports ID GUID Result ID Triple Description Report ID HTML; while ( list ( $reportTripleID, $GUID, $resultID, $triple, $dataDesc, $rptID ) = mysql_fetch_array( $result ) ) { $reportTripleIDs[] = $reportTripleID; $text .= <<$reportTripleID $GUID $resultID $triple $dataDesc $rptID HTML; } $text .= "\n\n" . "\n"; } } if ( ! empty( $reportTripleIDs ) ) { $reportTripleIDs_csv = implode( ",", $reportTripleIDs ); $query = "SELECT d.reportDocumentID, reportDocumentGUID, editedDataID, label, " . "filename, analysis, subAnalysis, documentType, l.reportTripleID " . "FROM documentLink l, reportDocument d " . "WHERE reportTripleID IN ( $reportTripleIDs_csv ) " . "AND l.reportDocumentID = d.reportDocumentID " . "ORDER BY reportTripleID, reportDocumentID "; $result = mysql_query( $query ) or die( "Query failed : $query
\n" . mysql_error() ); if ( mysql_num_rows( $result ) != 0 ) { $text .= << Report Documents Related to Triples ID GUID Edit ID Label/Filename Anal/Sub/DocType Trip ID HTML; while ( list ( $reportDocumentID, $GUID, $editID, $label, $filename, $analysis, $subAnal, $docType, $tripID ) = mysql_fetch_array( $result ) ) { $text .= <<$reportDocumentID $GUID $editID $label/$filename $analysis/$subAnal/$docType $tripID HTML; } $text .= "\n\n" . "\n"; } } $query = "SELECT HPCAnalysisRequestID, HPCAnalysisRequestGUID, editXMLFilename, " . "submitTime, clusterName, method " . "FROM HPCAnalysisRequest " . "WHERE experimentID = $experimentID " . "ORDER BY HPCAnalysisRequestID "; $result = mysql_query( $query ) or die( "Query failed : $query
\n" . mysql_error() ); if ( mysql_num_rows( $result ) == 0 ) return $text; $requestIDs = array(); $text .= << HPC Requests ID GUID XML Filename Submit Cluster Method HTML; while ( list( $ID, $GUID, $filename, $submit, $cluster, $method ) = mysql_fetch_array( $result ) ) { $requestIDs[] = $ID; $text .= <<$ID $GUID $filename $submit $cluster $method HTML; } $text .= "\n\n" . "\n"; $requestIDs_csv = implode( ", ", $requestIDs ); $query = "SELECT HPCAnalysisResultID, HPCAnalysisRequestID, gfacID, queueStatus, updateTime " . "FROM HPCAnalysisResult " . "WHERE HPCAnalysisRequestID IN ( $requestIDs_csv ) " . "ORDER BY HPCAnalysisResultID "; $result = mysql_query( $query ) or die( "Query failed : $query
\n" . mysql_error() ); if ( mysql_num_rows( $result ) != 0 ) { $text .= << HPC Results ID Request ID gfac ID Status Updated HTML; $incomplete = array(); while ( list( $ID, $requestID, $gfacID, $status, $updated ) = mysql_fetch_array( $result ) ) { if ( $status != 'completed' ) $incomplete[] = $gfacID; $text .= <<$ID $requestID $gfacID $status $updated HTML; } $text .= "\n\n" . "\n"; } if ( empty( $incomplete ) ) return $text; // Now switch over to the global db global $globaldbhost, $globaldbuser, $globaldbpasswd, $globaldbname; $globaldb = mysql_connect( $globaldbhost, $globaldbuser, $globaldbpasswd ); if ( ! $globaldb ) { $text .= "

Cannot open global database on $globaldbhost

\n"; return $text; } if ( ! mysql_select_db( $globaldbname, $globaldb ) ) { $text .= "

Cannot change to global database $globaldbname

\n"; return $text; } $text .= << GFAC Status gfacID Cluster DB Status Message Updated HTML; $in_queue = 0; foreach ( $incomplete as $gfacID ) { $query = "SELECT cluster, us3_db, status, queue_msg, time " . "FROM analysis " . "WHERE gfacID = '$gfacID' "; $result = mysql_query( $query ) or die( "Query failed : $query
\n" . mysql_error() ); if ( mysql_num_rows( $result ) == 1 ) { $in_queue++; list( $cluster, $db, $status, $msg, $time ) = mysql_fetch_array( $result ); $text .= <<$gfacID $cluster $db $status $msg $time HTML; } } if ( $in_queue == 0 ) $text .= "No local jobs currently in the queue\n"; $text .= "\n\n" . "\n"; mysql_close( $globaldb ); return $text; } function HPCDetail( $requestID ) { $query = "SELECT * FROM HPCAnalysisRequest WHERE HPCAnalysisRequestID=$requestID"; $result = mysql_query( $query ) or die( "Query failed : $query
\n" . mysql_error()); $row = mysql_fetch_assoc( $result ); $row['requestXMLFile'] = '
' . htmlentities( $row['requestXMLFile'] ) . '
'; // Save for later $requestGUID = $row['HPCAnalysisRequestGUID']; $cluster = $row['clusterName']; #var_dump($cluster); $text = << HPC Request Detail HTML; foreach ($row as $key => $value) { $text .= " $key$value\n"; } $text .= "\n"; $query = "SELECT * FROM HPCAnalysisResult WHERE HPCAnalysisRequestID=$requestID"; $result = mysql_query( $query ) or die( "Query failed : $query
\n" . mysql_error()); $row = mysql_fetch_assoc( $result ); $row['jobfile'] = '
' . htmlentities( $row['jobfile'] ) . '
'; // Get GFAC job status global $uses_airavata; if ( $uses_airavata === true && $cluster != 'juropa.fz-juelich.de' ) { $row['gfacStatus'] = nl2br( getExperimentStatus( $row['gfacID'] ) ); } else { $row['gfacStatus'] = nl2br( getJobstatus( $row['gfacID'] ) ); } // Get queue messages from disk directory, if it still exists global $submit_dir; global $dbname; $msg_filename = "$submit_dir$requestGUID/$dbname-$requestID-messages.txt"; $queue_msgs = false; if ( file_exists( $msg_filename ) ) { $queue_msgs = file_get_contents( $msg_filename ); $len_msgs = strlen( $queue_msgs ); $queue_msgs = '
' . $queue_msgs . '
'; } // Get resulting model and noise information if ( ! empty( $resultID ) ) { $resultID = $row['HPCAnalysisResultID']; $models = array(); $noise = array(); $query = "SELECT resultID FROM HPCAnalysisResultData " . "WHERE HPCAnalysisResultID = $resultID " . "AND HPCAnalysisResultType = 'model' "; $result = mysql_query( $query ) or die( "Query failed : $query
\n" . mysql_error()); $models = mysql_fetch_row( $result ); // An array with all of them if ( $models !== false ) $row['modelIDs'] = implode( ", ", $models ); $query = "SELECT resultID FROM HPCAnalysisResultData " . "WHERE HPCAnalysisResultID = $resultID " . "AND HPCAnalysisResultType = 'noise' "; $result = mysql_query( $query ) or die( "Query failed : $query
\n" . mysql_error()); $noise = mysql_fetch_row( $result ); // An array with all of them if ( $noise !== false ) $row['noiseIDs'] = implode( ", ", $noise ); } $text .= << HTML; foreach ($row as $key => $value) { $text .= " \n"; } if ( $queue_msgs !== false ) { $linkmsg = "Length Messages"; $text .= " \n"; if ( isset( $_GET[ 'msgs' ] ) ) $text .= " \n"; } $text .= "
HPC Result Detail
$key$value
$linkmsg$len_msgs
Queue Messages$queue_msgs
\n"; return $text; } ?>