'."\n". ''; $title = "Manage Files"; require_once 'header.inc.php'; require_once 'db.function.php'; require_once 'DBSelectForm.class.php'; // View ALL Bed files $db = getDB(); if($_GET['id'] == 0) { $exp = array('title' => 'Viewing all BED files from all experiments', 'keywords' => '', 'description' => 'ALL BED FILES'); $exp_query = 'or 1 = 1'; if(isset($_GET['search']) && count($_SESSION['last_search_result'])) { $exp_query = 'or bedfile_id in ('. join(',', $_SESSION['last_search_result']) . ')'; $exp = array('title' => "Viewing results from your search for $_SESSION[last_search_q]", 'keywords' => '', 'description' => 'SEARCH RESULTS'); } else if(isset($_GET['search'])) { $exp_query = ''; $exp = array('title' => "Viewing results from your search for $_SESSION[last_search_q]", 'keywords' => '', 'description' => 'SEARCH RESULTS'); } $disabled = 'disabled="disabled" style="background-color:white"'; $descr_query = "concat(descr, ' From Experiment ', experiment_id, '') as descr"; } else { $exp = $db->getRow("select title, trim(',' from keywords) as keywords, description from experiment where experiment_id = ?", array($_GET['id'])); $exp_query = ''; $disabled = ''; $descr_query = 'descr'; } // Reference button works if($_SESSION['admin']) { $reference_button = ""; } else { $reference_button = ''; } $reference = $db->getAssoc("select bedfile_id, name from bedfile where is_reference = 1 order by name"); // Query and store bedfiles information, bedfiles belong to this experiment $bed = $db->query("select bedfile_id as id, method_id, method.name as method, genome_id, genome.name as genome, bedfile.name, date_format(upload_date, '%c/%e/%y') as upload_date, date_format(expiration, '%c/%e/%y') as expiration, header, $descr_query from bedfile left join method using(method_id) left join genome using(genome_id) where experiment_id = ? $exp_query order by bedfile_id", $id); if(PEAR::isError($bed)) { print_r($bed); die; } $fieldmap = array('Date' => 'upload_date', 'Name' => 'name', 'Genome' => 'genome', 'Method' => 'method', /*'Expires' => 'expiration',*/ 'Header' => 'header', 'Description' => 'descr'); ?> « Back to Home
Experiment:
Keywords:
Description:

numRows() == 0) { print '

Your search for '.$_SESSION['last_search_q'] .' didn\'t match any BED files.

'; } else if($bed->numRows() == 0) { print '

You don\'t have any BED files for this experiment.

'; } ?>

\n"; $i = 0; while($r = $bed->fetchRow()) { $class = ''; if($i % 2 == 1) { $class = ' class="oddrow"'; } print ""; foreach($fieldmap as $f) { //print ""; if($f == 'name') { $r[$f] = "$r[$f]"; // link to the bedinfo } print ""; } print "\n"; $selectVals[$r['id']]['genome'] = $r['genome']; $selectVals[$r['id']]['method'] = $r['method']; $i++; } ?>
" . join("", array_keys($fieldmap)) . "
"; if(isset($reference[$r['id']])) { print ""; } print "". htmlspecialchars($r[$f]) . "$r[$f]

Upload new: Drag and drop BED files here or click to browse. zip/tar/gz/bz2 OK.
Upload files (max size: 500M)
Copy a reference file: 'ref_bed_select')); $refSelect = new DBSelectForm('bedfile', 'select bedfile_id, name from bedfile where is_reference = 1 order by name', array('id' => 'ref_bed_select')); $refSelect->printSelect(); ?> EOT; require_once 'footer.inc.php'; ?>