fetch-rat-dti-data-within-slice.php

<?php
  require_once $_SERVER['DOCUMENT_ROOT'] . '/lib/rdf-db.php';
  require_once $_SERVER['DOCUMENT_ROOT'] . '/lib/misc.php';

  //the "yes" flag specifies that the term should have hyperlinks to source URL
 // $terms = get_conte_terms_hash("yes");

  $scantype = $_REQUEST['scantype'];
  $hemi = $_REQUEST['hemi'];
  $slice = $_REQUEST['slice'];
  $comp = $_REQUEST['comp'];
  $std = $_REQUEST['std'];
  $download = $_REQUEST['dl'];

  $arr = get_rat_dti_data_within_slice($scantype, $hemi, $slice, $comp, $std);
  $data = $arr['data'];
  $query = $arr['query'];
  $query = str_replace("<", "&lt", $query);
  $query = str_replace(">", "&gt", $query);
?>
  <div style="float:right;">Toggle SPARQL Query <input style="vertical-align:middle;" type="checkbox" id="toggle_switch" onclick="toggleSPARQL();" /> </div>
  <br />
  <div id='sparql_query' style='display:none;'><pre><?php echo $query; ?></pre> </div>
<?php
  $numrows = count($data);

  if ($scantype == '*'){
    $scantype = 'all';
  }
  if ($hemi == '*'){
    $hemi = 'both';
  }

  $link = '';
  if ($download == 'yes'){
    $time = time();
    $filename = "rat-dti-".lcfirst($scantype)."-".lcfirst($hemi)."-".$slice;
    if ($comp != '*'){
      $filename .= "-".$comp."-".$std;
    }
    $filename .= "-".$time.".csv";
    $link = save_rat_dti_csv_file($filename,$data);
  }

  //echo '<span class="tooltiptet">'.$terms['heartRateAvg'].'</span>';
  echo "Rat fragmentation data for scan type:<strong>" . $scantype . "</strong> hemisphere:<strong>" . $hemi;
  echo "</strong> slice number:<strong>" . $slice . "</strong> ";
  if ($comp != '*'){
    echo "view data:<strong>" . $comp . "</strong> than sample by standard deviation:<strong>" . $std."</strong>";
  }
  echo "<br />";
  echo "$numrows entries found.";
  if ($download == 'yes'){
    echo "<br />$link";
  }
  echo '<div style="max-height: 400px; overflow-y: auto; clear: both;">';
  echo '<table class="gridtable">';
  echo '<tr>';
  //echo '<tr><th title="' . $terms['mother'] . '">Mother</th>';
  echo '<th>Animal number</th>';
  echo '<th>Acq number</th>';
  echo '<th>Scan type</th>';
  echo '<th>Hemi</th>';
  echo '<th>Slice</th>';
  echo '<th>Average intensity</th>';
  echo '<th>Standard deviation</th>';
  echo '<th>Max</th>';
  echo '<th>Min</th>';
  echo '<th>Pixel area</th>';
  echo '<th>Pixel sum</th>';
  echo '<th>ROI file</th>';
  echo '</tr>';
  for($ri = 0; $ri < $numrows; $ri++) {
    echo '<tr>';
    $row = $data[$ri];
    echo "<td>".$row['animal']."</td>";
    echo "<td>".$row['acq']."</td>";
    echo "<td>".$row['scanType']."</td>";
    echo "<td>".$row['hemi']."</td>";
    echo "<td>".$row['slice']."</td>";
    echo "<td>".round($row['avg'],4)."</td>";
    echo "<td>".round($row['std'],4)."</td>";
    echo "<td>".round($row['max'],4)."</td>";
    echo "<td>".round($row['min'],4)."</td>";
    echo "<td>".$row['area']."</td>";
    echo "<td>".$row['sum']."</td>";
    echo "<td>".$row['file']."</td>";
    //echo "<td>".$row['fetus']."</td>";
    //echo "<td>".round($row['heartRate'],2)."</td>";
    //echo "<td>".round($row['heartRateStd'],2)."</td>";
    echo '</tr>';
  }
  echo "</table>";
  echo "</div>";

?>