tripal/theme_tripal/node-chado_analysis_blast.tpl.php

<?php
//
// Copyright 2009 Clemson University
//
?>

   <?php if ($picture) {
      print $picture;
   }?>
    
   <div class="node<?php if ($sticky) { print " sticky"; } ?><?php if (!$status) { print " node-unpublished"; } ?>">

   <?php if ($page == 0) { ?><h2 class="nodeTitle"><a href="<?php print $node_url?>"><?php print $title?></a>
	<?php global $base_url;
	if ($sticky) { print '<img src="'.base_path(). drupal_get_path('theme','sanqreal').'/img/sticky.gif" alt="sticky icon" class="sticky" />'; } ?>
	</h2><?php }; ?>
    
	<?php if (!$teaser): ?>
	   <?php if ($submitted): ?>     
      <div class="metanode"><p><?php print t('') .'<span class="author">'. theme('username', $node).'</span>' . t(' - Posted on ') . '<span class="date">'.format_date($node->created, 'custom', "d F Y").'</span>'; ?></p></div>
      <?php endif; ?>
      <div>
      <!-- tripal_analysis_blast theme -->
         <table>
            <tr><th>Name</th><td><?php print $node->analysisname;?></td></tr>
            <tr><th>Program (version)</th><td><?php print $node->program.' ('.$node->programversion.')';?></td></tr>
            <?php
               $ver = $node->sourceversion;
               if ($node->sourceversion) {
                  $ver = "($node->sourceversion)";
               }
               $date = preg_replace("/^(\d+-\d+-\d+) .*/","$1",$node->timeexecuted);
            ?>
            <tr><th>Source (version)</th><td><?php print $node->sourcename.' '.$ver;?></td></tr>
            <tr><th>Source URI</th><td><?php print $node->sourceuri;?></td></tr>
            <tr><th>Executed</th><td><?php print $date?></td></tr>
            <tr><th>Description</th><td><?php print $node->description?></td></tr>
            <tr><th>Blast Settings</th>
              <td>
                <b>Database:</b> 
                  <?php
                    // We want to show database name instead of database id
                    $previous_db = db_set_active('chado');
                    $sql = "SELECT name FROM db WHERE db_id = %d";
                    $dbname = db_result(db_query($sql, $node->blastdb)); 
                    print $dbname;
                    db_set_active($previous_db);
                  ?><br>
                <b>File:</b>
                  <?php print preg_replace("/.*\/(.*)/", "$1", $node->blastfile); ?><br>
                <b>Parameters:</b>
                  <?php print $node->blastparameters?><br>
                  <?php if ($node->blastjob) {
                           print "A job for parsing blast xml output will be submitted.";
                        }
                  ?>
              </td>
            </tr>
            <tr><th>Report</th>
            <?php
            	$sql = "SELECT AFP.analysisfeature_id
	                         FROM {analysisfeature} AF 
	                         INNER JOIN {analysisfeatureprop} AFP ON AF.analysisfeature_id = AFP.analysisfeature_id
	                         WHERE analysis_id = %d
	                         AND AFP.type_id = (SELECT cvterm_id FROM {cvterm} WHERE name = '%s' AND cv_id = (SELECT cv_id FROM {cv} WHERE name = 'tripal'))";
            	$previous_db = db_set_active('chado');
            	$exists = db_result(db_query($sql, $node->analysis_id, 'analysis_blast_besthit_query'));
            	db_set_active($previous_db);
            	if ($exists) {
                   $report_url = url("tripal_blast_report/".$node->analysis_id."/1/0/0/20");
                   print "<td><a href=$report_url>View the best hit homology report</a></td>";
            	} else {
            		print "<td>The homology report is not available. Please submit a job to parse the best hit first.</td>";
            	}
             ?>
            
            </tr>
         </table>
      <!-- End of tripal_analysis_blast theme-->
	  </div> 
    
    <?php endif; ?>
    
    <div class="content"><?php print $content?></div>
    
    <?php if (!$teaser): ?>
    <?php if ($links) { ?><div class="links"><?php print $links?></div><?php }; ?>
    <?php endif; ?>
    
    <?php if ($teaser): ?>
    <?php if ($links) { ?><div class="linksteaser"><div class="links"><?php print $links?></div></div><?php }; ?>
    <?php endif; ?>
    
    <?php if (!$teaser): ?>
    <?php if ($terms) { ?><div class="taxonomy"><span><?php print t('tags') ?></span> <?php print $terms?></div><?php } ?>
    <?php endif; ?>
  </div>