search_bp.php

<?php
// dem oct2014: For a breeding program, find trials containing lines from that program.

session_start();
require 'config.php';
require $config['root_dir'].'includes/bootstrap.inc';
require $config['root_dir'].'theme/normal_header.php';
$mysqli = connecti();

//This is the main program for displaying a list of experiments for a given program.

$uid = $_GET['uid'];
$sql = "SELECT data_program_name, data_program_code,program_type FROM CAPdata_programs WHERE CAPdata_programs_uid = ?";
if ($stmt = mysqli_prepare($mysqli, $sql)) {
    mysqli_stmt_bind_param($stmt, "i", $uid);
    mysqli_stmt_execute($stmt);
    mysqli_stmt_bind_result($stmt, $dpname, $dpcode, $dptype);
    if (mysqli_stmt_fetch($stmt)) {
        $dpname = $dpname." (".$dpcode.")";
        echo "<h1> $dpname </h1>";
    }
    mysqli_stmt_close($stmt);
}

if (($dptype =='breeding') || ($dptype =='mapping')) {
    $sql1 = "SELECT e.experiment_uid
	   FROM CAPdata_programs cp, experiments e
           WHERE e.CAPdata_programs_uid = cp.CAPdata_programs_uid
           AND cp.program_type = \"$dptype\"
	   AND cp.CAPdata_programs_uid = ?";
} else {
    $sql1 = "SELECT experiment_uid FROM experiments WHERE CAPdata_programs_uid = ?";
}
if ($stmt = mysqli_prepare($mysqli, $sql1)) {
    mysqli_stmt_bind_param($stmt, "i", $uid);
    mysqli_stmt_execute($stmt);
    mysqli_stmt_bind_result($stmt, $experiment_uid);
    mysqli_stmt_store_result($stmt);
    $num_rows = mysqli_stmt_num_rows($stmt);
}
if ($num_rows == 0) {
    echo "<div class='section'>";
    echo "<p>There are no data from this Program in the database.</div>";
} else {
    if (($dptype =='breeding') || ($dptype =='mapping')) {
        while (mysqli_stmt_fetch($stmt)) {
            $exptuids[] = $experiment_uid;
        }
        $exptlist = implode(',', $exptuids);
        // get selected experiments and verify that the user is authorized to see the experiment
        $sql2="select experiment_uid, trial_code, experiment_year, et.experiment_type_name  
	      from experiments e, experiment_types et
	      where experiment_uid in ($exptlist)
	      and et.experiment_type_uid = e.experiment_type_uid" ;
        if (!authenticate(array(USER_TYPE_PARTICIPANT,
            USER_TYPE_CURATOR,
            USER_TYPE_ADMINISTRATOR))) {
            $sql2 .= " and data_public_flag > 0";
        }
        $sql2 .= " order by experiment_year desc, trial_code asc";
    } else {
        // Program Type is not breeding or mapping.
        $sql2="select e.experiment_uid, e.trial_code, e.experiment_year, et.experiment_type_name
	    from experiments as e, experiment_types as et
	    where CAPdata_programs_uid=$uid
	    AND et.experiment_type_uid = e.experiment_type_uid";
        if (!authenticate(array(USER_TYPE_PARTICIPANT,
            USER_TYPE_CURATOR,
            USER_TYPE_ADMINISTRATOR))) {
            $sql2 .= " and data_public_flag > 0";
        }
        $sql2 .= " order by e.experiment_year desc, e.trial_code asc";
    }
    $res2=mysqli_query($mysqli, $sql2) or die(mysqli_error($mysqli));
    $num_rows = mysqli_num_rows($res2);
    if ($num_rows == 0) {
        echo "<div class='section'>";
        echo "<p>There are no public data from this Program in the database. ";
        echo "Project participants must be logged in to see any private datasets.</div>";
    } else {
    // Show the trials available.
        ?>
    <h3>Available Datasets</h3>
      <p>
      <table cellpadding="0" cellspacing="0">
      <tr>
      <th>Year</th>
      <th>Trial Name</th>
      <th>Traits</th>
      
      </tr>
        <?php
        while ($row_expuid=mysqli_fetch_array($res2)) {
            $expuid=$row_expuid['experiment_uid'];
            $trial_code=$row_expuid['trial_code'];
            $year=$row_expuid['experiment_year'];
            $experiment_type = $row_expuid['experiment_type_name'];
            $traits = experimentListPhenotypes($expuid);
            if ($experiment_type=='phenotype') {
                echo( "<tr> <td>$year</td> <td><a href='display_phenotype.php?trial_code=$trial_code'>$trial_code</a> </td> <td>$traits</td> </tr>");
            } elseif ($experiment_type=='genotype') {
                echo( "<tr> <td>$year</td> <td><a href='genotyping/display_genotype.php?trial_code=$trial_code'>$trial_code</a> </td> <td>$traits</td> </tr>");
            }
        }
        echo "</tbody></table>";
    }
}
$footer_div = 1;
require $config['root_dir'].'theme/footer.php';