function DisplaySubject($id) {
/* get privacy information */
$username = $_SESSION['username'];
$sqlstring = "select user_id from users where username = '******'";
$result = MySQLQuery($sqlstring, __FILE__, __LINE__);
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$userid = $row['user_id'];
$sqlstring = "select c.*, d.* from subjects a left join enrollment b on a.subject_id = b.subject_id left join user_project c on b.project_id = c.project_id left join projects d on d.project_id = c.project_id where a.subject_id = '$id' and c.user_id = '$userid' and c.view_phi = 1";
//PrintSQL($sqlstring);
$result = MySQLQuery($sqlstring, __FILE__, __LINE__);
if (mysql_num_rows($result) > 0) {
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$projectname = $row['project_name'];
$projectcostcenter = $row['project_costcenter'];
$phiprojectlist[] = "$projectname ($projectcostcenter)";
}
$phiaccess = 1;
}
else {
$phiaccess = 0;
}
$sqlstring = "select c.*, d.* from subjects a left join enrollment b on a.subject_id = b.subject_id left join user_project c on b.project_id = c.project_id left join projects d on d.project_id = c.project_id where a.subject_id = '$id' and c.user_id = '$userid' and c.view_data = 1";
//PrintSQL($sqlstring);
$result = MySQLQuery($sqlstring, __FILE__, __LINE__);
if (mysql_num_rows($result) > 0) {
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$projectname = $row['project_name'];
$projectcostcenter = $row['project_costcenter'];
$dataprojectlist[] = "$projectname ($projectcostcenter)";
}
$dataaccess = 1;
}
else {
$dataaccess = 0;
}
/* check if they have enrollments for a valid project */
$sqlstring = "select a.* from enrollment a right join projects b on a.project_id = b.project_id where a.subject_id = $id";
//PrintSQL($sqlstring);
$result = MySQLQuery($sqlstring, __FILE__, __LINE__);
if (mysql_num_rows($result) > 0) {
$hasenrollments = 1;
}
else {
$hasenrollments = 0;
}
$urllist['Subject List'] = "subjects.php";
NavigationBar("Subjects", $urllist, 1, $phiaccess, $dataaccess, $phiprojectlist, $dataprojectlist);
/* kick them out if they shouldn't be seeing anything on this page */
//if ((!$phiaccess) && (!$dataaccess) && (!$GLOBALS['isadmin'])) {
//if ((!$phiaccess) && (!$dataaccess) && ($hasenrollments)) {
// return;
//}
/* update the mostrecent table */
UpdateMostRecent($userid, $id,'');
/* get all existing info about this subject */
$sqlstring = "select * from subjects where subject_id = $id";
$result = MySQLQuery($sqlstring, __FILE__, __LINE__);
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$name = $row['name'];
$dob = $row['birthdate'];
$gender = $row['gender'];
$ethnicity1 = $row['ethnicity1'];
$ethnicity2 = $row['ethnicity2'];
$handedness = $row['handedness'];
$education = $row['education'];
$phone1 = $row['phone1'];
$email = $row['email'];
$maritalstatus = $row['marital_status'];
$smokingstatus = $row['smoking_status'];
$uid = $row['uid'];
$guid = $row['guid'];
$cancontact = $row['cancontact'];
//print_r($row);
/* get the family UID */
$sqlstring = "select b.family_uid, b.family_name from family_members a left join families b on a.family_id = b.family_id where a.subject_id = $id";
$result = MySQLQuery($sqlstring, __FILE__, __LINE__);
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$familyuid = $row['family_uid'];
$familyname = $row['family_name'];
/* get list of alternate subject UIDs */
$altuids = GetAlternateUIDs($id);
list($lastname, $firstname) = explode("^",$name);
list($lname, $fname) = explode("^",$name);
$name = strtoupper(substr($fname,0,1)) . strtoupper(substr($lname,0,1));
switch ($gender) {
case "U": $gender = "Unknown"; break;
case "F": $gender = "Female"; break;
case "M": $gender = "Male"; break;
case "O": $gender = "Other"; break;
}
switch ($ethnicity1) {
case "": $ethnicity1 = "Unknown"; break;
case "hispanic": $ethnicity1 = "Hispanic/Latino"; break;
case "nothispanic": $ethnicity1 = "Not hispanic/Latino"; break;
}
switch ($ethnicity2) {
case "": $ethnicity2 = "Unknown"; break;
case "indian": $ethnicity2 = "American Indian/Alaska Native"; break;
case "asian": $ethnicity2 = "Asian"; break;
case "black": $ethnicity2 = "Black/African American"; break;
case "islander": $ethnicity2 = "Hawaiian/Pacific Islander"; break;
case "white": $ethnicity2 = "White"; break;
}
switch ($handedness) {
case "U": $handedness = "Unknown"; break;
case "R": $handedness = "Right"; break;
case "L": $handedness = "Left"; break;
case "A": $handedness = "Ambidextrous"; break;
}
switch ($education) {
case 0: $education = "Unknown"; break;
case 1: $education = "Grade School"; break;
case 2: $education = "Middle School"; break;
case 3: $education = "High School/GED"; break;
case 4: $education = "Trade School"; break;
case 5: $education = "Associates Degree"; break;
case 6: $education = "Bachelors Degree"; break;
case 7: $education = "Masters Degree"; break;
case 8: $education = "Doctoral Degree"; break;
}
?>
<br>
<style>
details[open] { border: 1px solid #ccc; background-color: #eee}
</style>
<table width="100%" cellpadding="4">
<tr>
<td valign="top" align="center">
<table class="download">
<tr>
<td class="title">
<?php
echo $uid;
?>
</td>
</tr>
<tr>
<td align="center" colspan="2" style="border-radius:5px; background-color: white; padding: 5px">
<div align="left" style="font-weight: bold; font-size: 12pt">Demographics</div>
<div align="left">
<? if ($phiaccess) { ?>
<details>
<summary class="tiny" style="color:darkred">Edit or delete</summary>
<div style="padding:5px; font-size:11pt">
<a href="subjects.php?action=editform&id=<?php
echo $id;
?>
">Edit Demographics</a>
<br><br><br>
<? if ($GLOBALS['isadmin']) { ?>
<a href="subjects.php?action=deleteconfirm&id=<?php
echo $id;
?>
"><span style="color: red; text-decoration:underline">Delete</span></a>
<? } ?>
</div>
</details>
<? } ?>
</div>
<br>
<table class="reviewtable">
<tr>
<td class="label">Subject initials</td>
<td class="value"><?php
echo $name;
?>
</td>
</tr>
<tr>
<td class="label">Date of birth</td>
<td class="value"><?php
echo $dob;
?>
</td>
</tr>
<tr>
<td class="label">Gender</td>
<td class="value"><?php
echo $gender;
?>
</td>
</tr>
<tr>
<td class="label" style="white-space:nowrap;">Alternate UIDs</td>
<td class="value">
<?
foreach ($altuids as $altid) {
if (strlen($altid) > 20) {
echo "<span title='$altid'>" . substr($altid,0,20) . "...</span> ";
}
else {
echo "$altid ";
}
}
?>
</td>
</tr>
<tr>
<td class="label">Ethnicity1&2</td>
<td class="value"><?php
echo $ethnicity1;
?>
, <?php
echo $ethnicity2;
?>
</td>
</tr>
<tr>
<td class="label">Handedness</td>
<td class="value"><?php
echo $handedness;
?>
</td>
</tr>
<tr>
<td class="label">Education</td>
<td class="value"><?php
echo $education;
?>
</td>
</tr>
<tr>
<td class="label">Phone</td>
<td class="value"><?php
echo $phone1;
?>
</td>
</tr>
<tr>
<td class="label">E-mail</td>
<td class="value"><?php
echo $email;
?>
</td>
</tr>
<tr>
<td class="label">Marital Status</td>
<td class="value"><?php
echo $maritalstatus;
?>
</td>
</tr>
<tr>
<td class="label">Smoking Status</td>
<td class="value"><?php
echo $smokingstatus;
?>
</td>
</tr>
<tr>
<td class="label">GUID</td>
<td class="value"><?php
echo $guid;
?>
</td>
</tr>
<tr>
<td class="label">Can contact?</td>
<td class="value"><?php
echo $cancontact;
?>
</td>
</tr>
</table>
<br>
<br><br>
<div align="left" style="font-weight: bold; font-size: 12pt">Family</div>
<div align="left">
<? if ($phiaccess) { ?>
<details>
<summary class="tiny" style="color:darkred">Add family members</summary>
<table style="font-size: 10pt">
<?
/* display existing subject relations */
$sqlstring = "select a.*, b.uid from subject_relation a left join subjects b on a.subjectid2 = b.subject_id where a.subjectid1 = $id";
$result = MySQLQuery($sqlstring, __FILE__, __LINE__);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$subjectid2 = $row['subjectid2'];
$relation = $row['relation'];
$uid2 = $row['uid'];
switch ($relation) {
case "siblingf": $relation = "half-sibling (same father)"; break;
case "siblingm": $relation = "half-sibling (same mother)"; break;
case "sibling": $relation = "sibling"; break;
case "parent": $relation = "parent"; break;
case "child": $relation = "child"; break;
}
?>
<tr>
<td><?php
echo $uid;
?>
is the <b><?php
echo $relation;
?>
</b> of <a href="subjects.php?id=<?php
echo $subjectid2;
?>
"><?php
echo $uid2;
?>
</a></td>
</tr>
<?
}
?>
<script>
$(function() {
$( "#uid2" ).autocomplete({
source: "autocomplete_uid.php",
minLength: 2,
autoFocus: true
});
});
</script>
<style>
.ui-autocomplete {
max-height: 100px;
overflow-y: auto;
/* prevent horizontal scrollbar */
overflow-x: hidden;
/* add padding to account for vertical scrollbar */
padding-right: 20px;
}
/* IE 6 doesn't support max-height
* we use height instead, but this forces the menu to always be this tall
*/
* html .ui-autocomplete {
height: 100px;
}
</style>
<tr>
<form action="subjects.php" method="post">
<input type="hidden" name="id" value="<?php
echo $id;
?>
">
<input type="hidden" name="action" value="addrelation">
<td>
<br><br>
<?php
echo $uid;
?>
is the
<br>
<select name="relation">
<option value="siblingm">Half-sibling (same mother)</option>
<option value="siblingf">Half-sibling (same father)</option>
<option value="sibling">Sibling</option>
<option value="parent">Parent</option>
<option value="child">Child</option>
</select> of <input type="text" size="10" name="uid2" id="uid2"/>
<br>
<input type="checkbox" name="makesymmetric" value="1" checked title="If subject 1 is the parent of subject 2, a corresponding relation will also show subject 2 is a child of subject 1">Make symmetric
<input type="submit" value="Add relation"></td>
</form>
</tr>
</table>
</details>
<? } ?>
</div>
<br>
<table class="reviewtable">
<tr>
<td class="label">Family UID</td>
<td class="value"><?php
echo $familyuid;
?>
</td>
</tr>
<tr>
<td class="label">Family name</td>
<td class="value"><?php
echo $familyname;
?>
</td>
</tr>
</table>
<br>
</td>
</tr>
</table>
</td>
<td valign="top" align="center">
<table class="download">
<tr>
<td class="title">
Projects
</td>
<form action="subjects.php" method="post">
<td align="right" style="color: white">
<input type="hidden" name="id" value="<?php
echo $id;
?>
">
<input type="hidden" name="action" value="enroll">
<span style="font-size:10pt">Enroll subject in project:</span>
<select name="projectid">
<?
$sqlstring = "select a.*, b.user_fullname from projects a left join users b on a.project_pi = b.user_id where a.project_status = 'active' and a.instance_id = " . $_SESSION['instanceid'] . " order by a.project_name";
$result = MySQLQuery($sqlstring, __FILE__, __LINE__);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$project_id = $row['project_id'];
$project_name = $row['project_name'];
$project_costcenter = $row['project_costcenter'];
$project_enddate = $row['project_enddate'];
$user_fullname = $row['user_fullname'];
if (strtotime($project_enddate) < strtotime("now")) { $style="color: gray"; } else { $style = ""; }
//echo "[" . strtotime($project_enddate) . ":" . strtotime("now") . "]<br>";
?>
<option value="<?php
echo $project_id;
?>
" style="<?php
echo $style;
?>
"><?php
echo $project_name;
?>
(<?php
echo $project_costcenter;
?>
)</option>
<?
}
?>
</select>
<input type="submit" value="Enroll">
</td>
</form>
</tr>
<?
$sqlstringA = "select a.project_id 'projectid', a.*, b.*, enroll_startdate, enroll_enddate from enrollment a left join projects b on a.project_id = b.project_id where a.subject_id = $id";
//$resultA = mysql_query($sqlstringA) or die("Query failed: " . mysql_error() . "<br><i>$sqlstringA</i><br>");
$resultA = MySQLQuery($sqlstringA, __FILE__, __LINE__);
//PrintSQL($sqlstringA);
while ($rowA = mysql_fetch_array($resultA, MYSQL_ASSOC)) {
$enrollmentid = $rowA['enrollment_id'];
$enroll_startdate = $rowA['enroll_startdate'];
$enroll_enddate = $rowA['enroll_enddate'];
$enrollgroup = $rowA['enroll_subgroup'];
$projectid = $rowA['projectid'];
$project_name = $rowA['project_name'];
$costcenter = $rowA['project_costcenter'];
$project_enddate = $rowA['project_enddate'];
$enrolldate = date('M j, Y g:ia',strtotime($enroll_startdate));
if ($row['irb_consent'] != "") { $irb = "Y"; }
else { $irb = "N"; }
//echo "$enroll_enddate <--> " . date("Y-m-d H:i:s") . "<br>";
if (($enroll_enddate > date("Y-m-d H:i:s")) || ($enroll_enddate == "0000-00-00 00:00:00")) {
$enrolled = true;
}
else {
$enrolled = false;
}
/* check if this user has data access to this project */
$projectaccess = 1;
$sqlstring2 = "select view_data from user_project where project_id = $projectid and view_data = 1 and user_id = $userid";
$result2 = MySQLQuery($sqlstring2, __FILE__, __LINE__);
if (mysql_num_rows($result2) < 1) {
$projectaccess = 0;
}
$subjectaltids = implode2(',',GetAlternateUIDs($id, $enrollmentid));
?>
<script type="text/javascript">
$(document).ready(function(){
$(".edit_inline<? echo $enrollmentid; ?>").editInPlace({
url: "group_inlineupdate.php",
params: "action=editinplace&id=<? echo $enrollmentid; ?>",
default_text: "<i style='color:#AAAAAA'>Click to add group name...</i>",
bg_over: "white",
bg_out: "lightyellow",
});
});
</script>
<tr>
<td class="section" colspan="2">
<table class="subdownload" width="100%">
<tr>
<td class="label" style="width: 200px; text-align: left; vertical-align: top;">
<?php
echo $project_name;
?>
(<?php
echo $costcenter;
?>
)<br><br>
<div style="font-size:10pt; font-weight: normal;">
Enrolled: <span style="color: darkblue"><?php
echo $enrolldate;
?>
</span><br>
<? if ($phiaccess) { ?>
Group: <span id="enroll_subgroup" class="edit_inline<? echo $enrollmentid; ?>" style="background-color: lightyellow; padding: 1px 3px; font-size: 9pt;"><? echo $enrollgroup; ?></span><br>
<? } ?>
<b>ID:</b> <?php
echo $subjectaltids;
?>
<br>
<? if ($enroll_enddate != "0000-00-00 00:00:00") { ?>
<span style="color: darkred">Un-enroll date: <?php
echo $enroll_enddate;
?>
</span><br>
<? } ?>
<? if ($phiaccess) { ?>
<!--Project end date: <?php
echo $project_enddate;
?>
-->
Project status: <a href="projectreport.php?action=viewreport&enrollmentid=<?php
echo $enrollmentid;
?>
">View report</a>
</div>
<? if (($enrolled) && ($GLOBALS['isadmin'])) { ?>
<form action="subjects.php" method="post">
<input type="hidden" name="id" value="<?php
echo $id;
?>
">
<input type="hidden" name="action" value="changeproject">
<input type="hidden" name="enrollmentid" value="<?php
echo $enrollmentid;
?>
">
<br>
<details>
<summary class="tiny" style="color:darkred; font-weight:normal">Enroll in different project</summary>
<span style="font-size: 10pt; font-weight: normal;">Un-enroll subject from this project and enroll in this project, moving all imaging, assessments, and measures:</span>
<select name="newprojectid">
<?
$sqlstring = "select a.*, b.user_fullname from projects a left join users b on a.project_pi = b.user_id where a.project_status = 'active' order by a.project_name";
$result = MySQLQuery($sqlstring, __FILE__, __LINE__);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$project_id = $row['project_id'];
$project_name = $row['project_name'];
$project_costcenter = $row['project_costcenter'];
$project_enddate = $row['project_enddate'];
$user_fullname = $row['user_fullname'];
if (strtotime($project_enddate) < strtotime("now")) { $style="color: gray"; } else { $style = ""; }
//echo "[" . strtotime($project_enddate) . ":" . strtotime("now") . "]<br>";
?>
<option value="<?php
echo $project_id;
?>
" style="<?php
echo $style;
?>
"><?php
echo $project_name;
?>
(<?php
echo $project_costcenter;
?>
)</option>
<?
}
?>
</select>
<input type="submit" value="Move">
</form>
</details>
<?
} /* end if phi access */
} /* end if enrolled */ ?>
</td>
<td class="main">
<?
if (!$projectaccess) {
echo "No data access privileges to this project";
}
else {
?>
<table width="100%">
<tr>
<td><b>Imaging studies</b>
</td>
<td align="right">
<? if (!$enrolled) { ?>
<span style="color: #666">Subject is un-enrolled. Cannot create new studies</span>
<? } else { ?>
<!--<a href="subjects.php?action=newstudy&enrollmentid=<?php
echo $enrollmentid;
?>
&id=<?php
echo $id;
?>
" style="font-size:11pt">Create new study</a>-->
<form action="subjects.php" method="post">
<td align="right">
<input type="hidden" name="id" value="<?php
echo $id;
?>
">
<input type="hidden" name="enrollmentid" value="<?php
echo $enrollmentid;
?>
">
<input type="hidden" name="action" value="newstudy">
<span style="font-size:10pt">Create new study:</span>
<select name="modality">
<option value="" style="<?php
echo $style;
?>
">(Select modality)</option> <?
$sqlstring = "select * from modalities order by mod_code";
$result = MySQLQuery($sqlstring, __FILE__, __LINE__);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$mod_code = $row['mod_code'];
$mod_desc = $row['mod_desc'];
?>
<option value="<?php
echo $mod_code;
?>
" style="<?php
echo $style;
?>
">[<?php
echo $mod_code;
?>
] <?php
echo $mod_desc;
?>
</option>
<?
}
?>
</select>
<input type="submit" value="Create">
</td>
</form>
<? } ?>
</td>
</tr>
</table>
<?
$sqlstring = "select a.*, datediff(a.study_datetime, c.birthdate) 'ageatscan' from studies a left join enrollment b on a.enrollment_id = b.enrollment_id left join subjects c on b.subject_id = c.subject_id where a.enrollment_id = $enrollmentid order by a.study_datetime desc";
//$result2 = mysql_query($sqlstring) or die("Query failed: " . mysql_error() . "<br><i>$sqlstring</i><br>");
$result2 = MySQLQuery($sqlstring, __FILE__, __LINE__);
if (mysql_num_rows($result2) > 0) {
?>
<table width="100%" class="smalldisplaytable" style="background-color: #FFFFFF; border-radius: 5px; width: 100%; padding:5px">
<thead>
<th>#</th>
<th>Modality</th>
<th>Date</th>
<th>Age<span class="tiny"> y</span></th>
<th>Physician</th>
<th>Operator</th>
<th>Site</th>
<th>Study ID</th>
<th>Visit</th>
<th>Rad Read</th>
</thead>
<tbody>
<?
while ($row2 = mysql_fetch_array($result2, MYSQL_ASSOC)) {
$study_id = $row2['study_id'];
$study_num = $row2['study_num'];
$study_modality = $row2['study_modality'];
$study_datetime = $row2['study_datetime'];
$study_ageatscan = $row2['study_ageatscan'];
$calcage = number_format($row2['ageatscan']/365.25,1);
$study_operator = $row2['study_operator'];
$study_performingphysician = $row2['study_performingphysician'];
$study_site = $row2['study_site'];
$study_type = $row2['study_type'];
$study_status = $row2['study_status'];
$study_doradread = $row2['study_doradread'];
if (trim($study_ageatscan) != 0) {
$age = $study_ageatscan;
}
else {
$age = $calcage;
}
?>
<tr onMouseOver="this.style.backgroundColor='#9EBDFF'" onMouseOut="this.style.backgroundColor=''">
<td><a href="studies.php?id=<?php
echo $study_id;
?>
"><?php
echo $study_num;
?>
</a></td>
<td><?php
echo $study_modality;
?>
</td>
<td><?php
echo $study_datetime;
?>
</td>
<td><?php
echo number_format($age, 1);
?>
</td>
<td><?php
echo $study_performingphysician;
?>
</td>
<td><?php
echo $study_operator;
?>
</td>
<td><?php
echo $study_site;
?>
</td>
<td><tt><?php
echo $uid;
echo $study_num;
?>
</tt></td>
<td><?php
echo $study_type;
?>
</td>
<td><? if ($study_doradread) { echo "✓"; } ?></td>
</tr>
<?
}
?>
</table>
<?
}
else {
?>
<div style="font-size: 9pt; background-color:white; text-align: center; border: 1px solid #888; border-radius:5px; padding:3px">No imaging studies</div>
<?
}
?>
<? if ($_SESSION['enablebeta']) { ?>
<br><br>
<!-- instruments table -->
<table width="100%">
<tr>
<td><b>Assessments</b> <?php
echo PrintBeta();
?>
</td>
<form action="assessments.php" method="post">
<td align="right">
<? if (!$enrolled) { $disabled = "disabled"; } else { $disabled = ""; } ?>
<input type="hidden" name="enrollmentid" value="<?php
echo $enrollmentid;
?>
">
<input type="hidden" name="action" value="create">
<span style="font-size: 10pt">Add assessment:</span>
<select name="formid" <?php
echo $disabled;
?>
>
<option value="">(Select assessment)</option>
<?
$sqlstringB = "select * from assessment_forms where form_ispublished = 1 order by form_title";
//$resultB = mysql_query($sqlstringB) or die("Query failed: " . mysql_error() . "<br><i>$sqlstringB</i><br>");
$resultB = MySQLQuery($sqlstringB, __FILE__, __LINE__);
while ($rowB = mysql_fetch_array($resultB, MYSQL_ASSOC)) {
$form_id = $rowB['form_id'];
$form_title = $rowB['form_title'];
?>
<option value="<?php
echo $form_id;
?>
" style="<?php
echo $style;
?>
"><?php
echo $form_title;
?>
</option>
<?
}
?>
</select>
<input type="submit" value="Create" <?php
echo $disabled;
?>
>
</td>
</form>
</tr>
</table>
<?
$sqlstring3 = "select a.*, b.form_title from assessments a left join assessment_forms b on a.form_id = b.form_id where a.enrollment_id = $enrollmentid";
//$result3 = mysql_query($sqlstring3) or die("Query failed: " . mysql_error() . "<br><i>$sqlstring3</i><br>");
$result3 = MySQLQuery($sqlstring3, __FILE__, __LINE__);
if (mysql_num_rows($result3) > 0) {
?>
<table width="100%" class="smalldisplaytable" style="background-color: #FFFFFF; border-radius: 5px; width: 100%; padding:5px">
<thead>
<th>Instrument</th>
<th>Date</th>
<th>Experimentor</th>
<th>Rater</th>
<th>Complete?</th>
</thead>
<tbody>
<?
while ($row3 = mysql_fetch_array($result3, MYSQL_ASSOC)) {
$experiment_id = $row3['experiment_id'];
$form_title = $row3['form_title'];
$exp_admindate = $row3['exp_admindate'];
$experimentor = $row3['experimentor'];
$rater_username = $row3['rater_username'];
$iscomplete = $row3['iscomplete'];
if ($iscomplete) { $action = "view"; } else { $action = "edit"; }
?>
<tr onMouseOver="this.style.backgroundColor='#9EBDFF'" onMouseOut="this.style.backgroundColor=''">
<td><a href="assessments.php?action=<?php
echo $action;
?>
&experimentid=<?php
echo $experiment_id;
?>
"><?php
echo $form_title;
?>
</a></td>
<td><?php
echo $exp_admindate;
?>
</td>
<td><?php
echo $experimentor;
?>
</td>
<td><?php
echo $rater_username;
?>
</td>
<td><? if ($iscomplete) { echo "✔"; }
else {
?>
<a href="assessments.php?action=completed&experimentid=<?php
echo $experiment_id;
?>
">Mark as complete</a>
<?
}
?></td>
</tr>
<?
}
?>
</table>
<?
}
else {
?>
<div style="font-size: 9pt; background-color:white; text-align: center; border: 1px solid gray; border-radius:5px; padding:3px">No assessments</div>
<?
}
?>
<? } ?>
<br>
<!-- phenotypic measures table -->
<table width="100%">
<tr>
<td><b>Phenotypic </b><a href="measures.php?enrollmentid=<?php
echo $enrollmentid;
?>
">measures</a></td>
</tr>
</table>
<?
$sqlstring3 = "select * from measures a left join measurenames b on a.measurename_id = b.measurename_id where enrollment_id = $enrollmentid";
$result3 = MySQLQuery($sqlstring3, __FILE__, __LINE__);
$numrows = mysql_num_rows($result3);
if ($numrows > 0) {
?>
<div style="-moz-column-count:2; -webkit-column-count:2; column-count:2; width: 100%; font-size:9pt; background-color: white; padding: 4px; border-radius:5px; -moz-column-rule:1px outset #DDD; -webkit-column-rule:1px outset #DDD; column-rule:1px outset #DDD; border:1px solid #888">
<?
while ($row3 = mysql_fetch_array($result3, MYSQL_ASSOC)) {
$measureid = $row3['measure_id'];
$measure_name = $row3['measure_name'];
$measure_type = $row3['measure_type'];
$measure_valuestring = $row3['measure_valuestring'];
$measure_valuenum = $row3['measure_valuenum'];
$measure_rater = $row3['measure_rater'];
$measure_rater2 = $row3['measure_rater2'];
$measure_isdoubleentered = $row3['measure_isdoubleentered'];
$measure_datecomplete = $row3['measure_datecomplete'];
switch ($measure_type) {
case 's': $value = $measure_valuestring; break;
case 'n': $value = $measure_valuenum; break;
}
if (!$measure_isdoubleentered) {
$color="red";
}
else {
$color="darkblue";
}
?>
<?php
echo $measure_name;
?>
<span style="color: <?php
echo $color;
?>
"><b><?php
echo $value;
?>
</b></span><br>
<?
}
?>
</div>
<?
}
else {
?>
<div style="font-size: 9pt; background-color:white; text-align: center; border: 1px solid #888; border-radius:5px; padding:3px">No measures</div>
<?
}
?>
<? if ($_SESSION['enablebeta']) { ?>
<br>
<!-- prescriptions table -->
<table width="100%">
<tr>
<td><a href="prescriptions.php?enrollmentid=<?php
echo $enrollmentid;
?>
">Prescriptions</a> <span class="tiny">medications/treatments/substance use</span> <?php
echo PrintBeta();
?>
</td>
</tr>
</table>
<?
$sqlstring3 = "select *, date_format(rx_startdate,'%Y-%m-%d') 'startdate', date_format(rx_enddate,'%Y-%m-%d') 'enddate' from prescriptions where enrollment_id = $enrollmentid";
$result3 = MySQLQuery($sqlstring3, __FILE__, __LINE__);
$numrows = mysql_num_rows($result3);
if ($numrows > 0) {
?>
<details>
<summary>Prescription list</summary>
<table>
<tr>
<td>Rx</td>
<td>Route</td>
<td>Amount</td>
<td>Dates</td>
</tr>
<?
while ($row3 = mysql_fetch_array($result3, MYSQL_ASSOC)) {
$rx_id = $row3['rx_id'];
$startdate = $row3['startdate'];
$enddate = $row3['enddate'];
$rx_dose = $row3['rx_doseamount'];
$rx_dosefreq = $row3['rx_dosefrequency'];
$rx_route = $row3['rx_route'];
$rx_name = $row3['rx_name'];
$rx_group = $row3['rx_group'];
?>
<tr>
<td><?php
echo $rx_name;
?>
</td>
<td><?php
echo $rx_route;
?>
</td>
<td><?php
echo $rx_dose;
?>
/<?php
echo $rx_dosefreq;
?>
</td>
<td><?php
echo $startdate;
?>
-<?php
echo $enddate;
?>
</td>
</tr>
<?
}
?>
</table>
<?
}
else {
?>
<div style="font-size: 9pt; background-color:white; text-align: center; border: 1px solid #888; border-radius:5px; padding:3px">No prescriptions</div>
<?
}
?>
<? } ?>
</td>
<? } ?>
</tr>
</table>
</td>
</tr>
<?
}
?>
</table>
</td>
</tr>
</table>
<br><br><bR><br><br>
<?
}
function DisplaySearchForm($searchvars, $action) {
$urllist['New Search'] = "search.php";
NavigationBar("Search", $urllist);
?>
<script type="text/javascript">
$(function() {
$(".datepick").datepicker({changeMonth: true, changeYear: true, dateFormat: 'yy-mm-dd', minDate: '-130y', maxDate: '+130y'});
});
</script>
<style>
.sidelabel {
font-weight: bold;
font-size: 12pt;
border-right: solid 1px #CCC;
border-bottom: solid 1px #CCC;
padding-right: 15px;
padding-left: 10px;
text-align: right;
}
.toplabel {
color: white;
font-weight: bold;
font-size: 14pt;
padding-top: 5px;
padding-bottom: 5px;
text-align: center;
/*border-top-right-radius: 5px;*/
background-color: #3B5998;
}
.tiny {
font-size: 8pt;
color: gray;
}
.fieldlabel {
color: darkblue;
text-align: right;
vertical-align: top;
}
.importantfield {
border: 1pt solid darkblue;
background-color: lightyellow;
}
.fakelink {
background-color: #DDD;
border-right: solid 2px #777
/*border-top: 2px solid #999;
border-left: 2px solid #444;
border-bottom: 2px solid #444;
border-radius:3px; */
padding: 1px 4px;
font-size:9pt;
font-weight: normal;
color: black;
cursor: pointer;
-moz-transform: rotate(-90deg);
-o-transform: rotate(-90deg);
-webkit-transform: rotate(-90deg);
}
.advancedhover:hover {
max-width: 25px;
background-color: #DDD;
color: #000;
border-right: 1px solid #444;
cursor: pointer;
align: center;
vertical-align: middle;
/*border-top-left-radius: 5px;
border-bottom-left-radius: 5px;*/
}
.advancedhover {
max-width: 25px;
background-color: #EEE;
color: #AAA;
border-right: 1px solid #AAA;
cursor: pointer;
align: center;
vertical-align: middle;
/*border-top-left-radius: 5px;
border-bottom-left-radius: 5px;*/
}
</style>
<script type="text/javascript">
<!--
$(document).ready(function() {
/* default action */
$('tr.advanced').hide();
$('#searchtoggle').click(function(){
$('tr.advanced').toggle();
});
});
-->
</script>
<script>
$(function() {
$( "#s_studyinstitution" ).autocomplete({
source: "autocomplete_institution.php",
minLength: 1,
autoFocus: true
});
});
$(document).ready(function(){
$('#pageloading').hide();
});
/* changed the results/view output type when a search element is clicked */
function SwitchOption(option) {
switch (option) {
case 'viewpipeline':
document.getElementById('viewpipeline').checked = true;
break;
}
}
</script>
<? if ($action == "search") { ?>
<div id="pageloading" align="center" style="font-size:11pt; color:darkblue">
Searching... <img src="images/loading.gif">
</div>
<br>
<? } ?>
<div style="padding-left:30px">
<form action="search.php" method="post" name="searchform">
<input type="hidden" name="action" value="search">
<table>
<tr>
<td>
<table cellspacing="0" cellpadding="3" style="border: 1px solid #ccc;">
<tr>
<td rowspan="9" id="searchtoggle" class="advancedhover" onMouseOver="this.classname='advancedhover';" onMouseOut="this.classname='advancednohover';">
<span style="display: block; -webkit-transform: rotate(-90deg); -moz-transform: rotate(-90deg); writing-mode: rl-bt;">Toggle advanced search</span>
</td>
</tr>
<tr>
<td class="toplabel" colspan="2">Search</td>
</tr>
<tr>
<td class="sidelabel">Subject</td>
<td style="border-bottom: 1pt solid #CCC">
<table width="100%" cellspacing="0" cellpadding="3">
<tr title="<b>Subject UID(s)</b><br><br>Can be a list of UIDs, separated by commas, spaces, semi-colons, tabs, or Copy&Paste from Excel">
<td class="fieldlabel">UID(s)</td>
<td><input type="text" name="s_subjectuid" value="<?php
echo $searchvars['s_subjectuid'];
?>
" size="50" class="importantfield"></td>
</tr>
<tr title="<b>Alternate Subject UID(s)</b><br><br>Can be a list of UIDs, separated by commas, spaces, semi-colons, tabs, or Copy&Paste from Excel">
<td class="fieldlabel">Alternate UID(s)</td>
<td><input type="text" name="s_subjectaltuid" value="<?php
echo $searchvars['s_subjectaltuid'];
?>
" size="50" class="importantfield"></td>
</tr>
<tr>
<td class="fieldlabel" width="150px">Name</td>
<td><input type="text" name="s_subjectname" value="<?php
echo $searchvars['s_subjectname'];
?>
" size="50" class="importantfield"></td>
</tr>
<tr class="advanced">
<td class="fieldlabel">DOB</td>
<td>
<input type="date" name="s_subjectdobstart" value="<?php
echo $searchvars['s_subjectdobstart'];
?>
" size="12"> to <input type="date" name="s_subjectdobend" value="<?php
echo $searchvars['s_subjectdobend'];
?>
" size="12">
</td>
</tr>
<tr class="advanced">
<td class="fieldlabel">Gender</td>
<td>
<input type="text" name="s_subjectgender" size="1" maxlength="1" value="<?php
echo $searchvars['s_subjectgender'];
?>
"> <span class="tiny"> F, M, O, U</span>
</td>
</tr>
<tr class="advanced">
<td class="fieldlabel" width="150px">Group</td>
<td>
<select name="s_subjectgroupid">
<option value="">Select a group</option>
<?
$sqlstring = "select * from groups where group_type = 'subject' order by group_name";
$result = MySQLQuery($sqlstring,__FILE__,__LINE__);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$groupid = $row['group_id'];
$groupname = $row['group_name'];
$groupowner = $row['group_owner'];
echo "[[$groupid -- [" . $searchvars['s_subjectgroupid'] . "]]]";
if ($groupid == $searchvars['s_subjectgroupid']) {
$selected = "selected";
}
else {
$selected = "";
}
?>
<option value="<?php
echo $groupid;
?>
" <?php
echo $selected;
?>
><?php
echo $groupname;
?>
</option>
<?
}
?>
</select>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="sidelabel">Enrollment</td>
<td style="border-bottom: 1pt solid #CCC">
<table width="100%" cellspacing="0" cellpadding="3">
<tr>
<td class="fieldlabel" width="150px">Project</td>
<td>
<select name="s_projectid" class="importantfield">
<option value="all">All Projects</option>
<?
$sqlstring = "select * from projects where instance_id = '" . $_SESSION['instanceid'] . "' order by project_name";
$result = MySQLQuery($sqlstring,__FILE__,__LINE__);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$project_id = $row['project_id'];
$project_name = $row['project_name'];
$project_costcenter = $row['project_costcenter'];
if ($project_id == $searchvars['s_projectid']) { $selected = "selected"; } else { $selected = ""; }
?>
<option value="<?php
echo $project_id;
?>
" <?php
echo $selected;
?>
><?php
echo $project_name;
?>
(<?php
echo $project_costcenter;
?>
)</option>
<?
}
?>
</select>
</td>
</tr>
<tr class="advanced">
<td class="fieldlabel" width="150px">Enrollment sub-group</td>
<td>
<input type="text" name="s_enrollsubgroup" id="s_enrollsubgroup" list="s_enrollsubgroup" value="<?php
echo $searchvars['s_enrollsubgroup'];
?>
" size="50"></td>
<datalist id="s_enrollsubgroup">
<?
$sqlstring = "select distinct(enroll_subgroup) from enrollment order by enroll_subgroup";
$result = MySQLQuery($sqlstring,__FILE__,__LINE__);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
?><option value="<?php
echo $row['enroll_subgroup'];
?>
"><?
}
?>
</datalist>
</td>
</tr>
</table>
</td>
</tr>
<? if ($_SESSION['enablebeta']) { ?>
<tr class="advanced">
<td class="sidelabel">Phenotype <?php
echo PrintBeta();
?>
</td>
<td style="border-bottom: 1pt solid #CCC">
<table width="100%" cellspacing="0" cellpadding="3">
<tr class="advanced">
<td class="fieldlabel" width="150px">Measure Search<br><span class="tiny">Search based on these critera</span></td>
<td>
<table style="font-size: 10pt" cellspacing="0" cellpadding="1">
<tr>
<td>
<?
$sqlstring = "select measure_name from measurenames order by measure_name";
$result = MySQLQuery($sqlstring,__FILE__,__LINE__);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$tags[] = '"' . $row['measure_name'] . '"';
}
?>
<script>
$(function() {
var availableTags = [<?php
echo implode2(',', $tags);
?>
];
function split( val ) {
return val.split( /,\s*/ );
}
function extractLast( term ) {
return split( term ).pop();
}
$( "#s_measure1" )
// don't navigate away from the field on tab when selecting an item
.bind( "keydown", function( event ) {
if ( event.keyCode === $.ui.keyCode.TAB && $( this ).data( "ui-autocomplete" ).menu.active ) {
event.preventDefault();
}
})
$( "#s_measure2" )
// don't navigate away from the field on tab when selecting an item
.bind( "keydown", function( event ) {
if ( event.keyCode === $.ui.keyCode.TAB && $( this ).data( "ui-autocomplete" ).menu.active ) {
event.preventDefault();
}
}) .autocomplete({
minLength: 0,
source: function( request, response ) {
// delegate back to autocomplete, but extract the last term
response( $.ui.autocomplete.filter(
availableTags, extractLast( request.term ) ) );
},
focus: function() {
// prevent value inserted on focus
return false;
},
select: function( event, ui ) {
var terms = split( this.value );
// remove the current input
terms.pop();
// add the selected item
terms.push( ui.item.value );
// add placeholder to get the comma-and-space at the end
terms.push( "" );
this.value = terms.join( ", " );
return false;
}
});
});
</script>
<input type="text" id="s_measure1" name="s_measuresearch" value="<?php
echo $searchvars['s_measuresearch'];
?>
" size="50" maxlength="255"><br><span class="tiny">Example: meas1=4;meas*<50;meas3~value</span>
</td>
</tr>
</table>
</td>
</tr>
<tr class="advanced">
<td class="fieldlabel" width="150px">Measure Columns<br><span class="tiny">Show these columns in results</span></td>
<td>
<table style="font-size: 10pt" cellspacing="0" cellpadding="1">
<tr>
<td>
<input type="text" id="s_measure2" name="s_measurelist" value="<?php
echo $searchvars['s_measurelist'];
?>
" size="50" maxlength="255">
<br><span class="tiny">Example: meas1,meas2,meas3<br>Or * for all measures</span>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<? } ?>
<tr>
<td class="sidelabel">Study</td>
<td style="border-bottom: 1pt solid #CCC">
<table width="100%" cellspacing="0" cellpadding="3">
<tr class="advanced">
<td class="fieldlabel" width="150px">Institution</td>
<td>
<input type="text" name="s_studyinstitution" id="s_studyinstitution" list="s_studyinstitution" value="<?php
echo $searchvars['s_studyinstitution'];
?>
" size="50"></td>
<datalist id="s_studyinstitution">
<?
$sqlstring = "select distinct(study_institution) from studies order by study_institution";
$result = MySQLQuery($sqlstring,__FILE__,__LINE__);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
?><option value="<?php
echo $row['study_institution'];
?>
"><?
}
?>
</datalist>
</td>
</tr>
<tr class="advanced">
<td class="fieldlabel" width="150px">Equipment</td>
<td>
<select name="s_studyequipment">
<option value="">Select equipment</option>
<?
$sqlstring = "select distinct(study_site) from studies order by study_site";
$result = MySQLQuery($sqlstring,__FILE__,__LINE__);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$study_site = $row['study_site'];
if ($study_site != "") {
if ($study_site == $searchvars['s_studyequipment']) {
$selected = "selected";
}
else {
$selected = "";
}
?>
<option value="<?php
echo $study_site;
?>
" <?php
echo $selected;
?>
><?php
echo $study_site;
?>
</option>
<?
}
}
?>
</select>
</td>
</tr>
<tr>
<td class="fieldlabel" width="150px">Alternate Scan ID(s)</td>
<td><input type="text" name="s_studyaltscanid" value="<?php
echo $searchvars['s_studyaltscanid'];
?>
" size="50" class="importantfield"></td>
</tr>
<tr title="<b>Study date</b><br><br>Leave first date blank to search for anything earlier than the second date. Leave the second date blank to search for anything later than the first date">
<td class="fieldlabel">Date</td>
<td><input type="date" name="s_studydatestart" value="<?php
echo $searchvars['s_studydatestart'];
?>
" size="12" class="importantfield"> to <input type="date" name="s_studydateend" value="<?php
echo $searchvars['s_studydateend'];
?>
" size="12" class="importantfield"></td>
</tr>
<tr>
<td class="fieldlabel">Modality</td>
<td>
<select name="s_studymodality" class="importantfield">
<?
$sqlstring = "select * from modalities order by mod_desc";
$result = MySQLQuery($sqlstring,__FILE__,__LINE__);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$mod_code = $row['mod_code'];
$mod_desc = $row['mod_desc'];
/* check if the modality table exists */
$sqlstring2 = "show tables from " . $GLOBALS['cfg']['mysqldatabase'] . " like '" . strtolower($mod_code) . "_series'";
$result2 = MySQLQuery($sqlstring2,__FILE__,__LINE__);
if (mysql_num_rows($result2) > 0) {
/* if the table does exist, allow the user to search on it */
if (($mod_code == "MR") && ($searchvars['s_studymodality'] == "")) {
$selected = "selected";
}
else {
if ($mod_code == $searchvars['s_studymodality']) {
$selected = "selected";
}
else {
$selected = "";
}
}
?>
<option value="<?php
echo $mod_code;
?>
" <?php
echo $selected;
?>
><?php
echo $mod_desc;
?>
</option>
<?
}
}
?>
</select>
</td>
</tr>
<tr class="advanced">
<td class="fieldlabel">Description</td>
<td>
<input type="text" name="s_studydesc" list="s_studydesc" value="<?php
echo $searchvars['s_studydesc'];
?>
" size="50">
<datalist id="s_studydesc">
<?
$sqlstring = "select distinct(study_desc) from studies where study_desc <> '' order by study_desc";
$result = MySQLQuery($sqlstring,__FILE__,__LINE__);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
?><option value="<?php
echo trim($row['study_desc']);
?>
"><?
}
?>
</datalist>
</td>
</tr>
<tr class="advanced">
<td class="fieldlabel">Performing Physician</td>
<td>
<input type="text" name="s_studyphysician" list="s_studyphysician" value="<?php
echo $searchvars['s_studyphysician'];
?>
" size="50">
<datalist id="s_studyphysician">
<?
$sqlstring = "select distinct(study_performingphysician) from studies where study_performingphysician <> '' order by study_performingphysician";
$result = MySQLQuery($sqlstring,__FILE__,__LINE__);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
?><option value="<?php
echo trim($row['study_performingphysician']);
?>
"><?
}
?>
</datalist>
</td>
</tr>
<tr class="advanced">
<td class="fieldlabel">Operator</td>
<td>
<input type="text" name="s_studyoperator" list="s_studyoperator" value="<?php
echo $searchvars['s_studyoperator'];
?>
" size="50">
<datalist id="s_studyoperator">
<?
$sqlstring = "select distinct(study_operator) from studies where study_operator <> '' order by study_operator";
$result = MySQLQuery($sqlstring,__FILE__,__LINE__);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
?><option value="<?php
echo trim($row['study_operator']);
?>
"><?
}
?>
</datalist>
</td>
</tr>
<tr class="advanced">
<td class="fieldlabel">Visit type</td>
<td>
<input type="text" name="s_studytype" list="s_studytype" value="<?php
echo $searchvars['s_studytype'];
?>
" size="50">
<datalist id="s_studytype">
<?
$sqlstring = "select distinct(study_type) from studies where study_type <> '' order by study_type";
$result = MySQLQuery($sqlstring,__FILE__,__LINE__);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
?><option value="<?php
echo trim($row['study_type']);
?>
"><?
}
?>
</datalist>
</td>
</tr>
<tr class="advanced">
<td class="fieldlabel" width="150px">Group</td>
<td>
<select name="s_studygroupid">
<option value="">Select a group</option>
<?
$sqlstring = "select * from groups where group_type = 'study' order by group_name";
$result = MySQLQuery($sqlstring,__FILE__,__LINE__);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$groupid = $row['group_id'];
$groupname = $row['group_name'];
$groupowner = $row['group_owner'];
if ($groupid == $searchvars['s_studygroupid']) {
$selected = "selected";
}
else {
$selected = "";
}
?>
<option value="<?php
echo $groupid;
?>
" <?php
echo $selected;
?>
><?php
echo $groupname;
?>
</option>
<?
}
?>
</select>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="sidelabel">Series</td>
<td style="border-bottom: 1pt solid #CCC">
<table width="100%" cellspacing="0" cellpadding="3">
<tr title="<b>Comma separated</b> protocols: search will be an AND<br><b>Semi-colon separated</b> protocols: search will be an OR">
<td class="fieldlabel" width="150px">Protocol</td>
<td><input type="text" name="s_seriesdesc" value="<?php
echo $searchvars['s_seriesdesc'];
?>
" size="50" class="importantfield"></td>
</tr>
<tr title="Perform the search using the alternate protocol name, and return the results using the alternate protocol name. The alternate protocol name often groups together series with similar names into one protocol. For example 'MPRAGE', 'Axial T1', and 'T1w_SPC' would all be labeled 'T1'">
<td class="fieldlabel" width="150px"></td>
<td><input type="checkbox" name="s_usealtseriesdesc" value="1" class="importantfield" <? if ($searchvars['s_usealtseriesdesc']) { echo "checked"; } ?>>Use alternate protocol name</td>
</tr>
<tr class="advanced">
<td class="fieldlabel" width="150px">Sequence</td>
<td><input type="text" name="s_seriessequence" value="<?php
echo $searchvars['s_seriessequence'];
?>
" size="50"></td>
</tr>
<tr class="advanced" title="Comma separated. Use * to indicate wildcards">
<td class="fieldlabel" width="150px">Image Type</td>
<td><input type="text" name="s_seriesimagetype" value="<?php
echo $searchvars['s_seriesimagetype'];
?>
" size="50"></td>
</tr>
<tr class="advanced">
<td class="fieldlabel" width="150px">Image Comments</td>
<td><input type="text" name="s_seriesimagecomments" value="<?php
echo $searchvars['s_seriesimagecomments'];
?>
" size="50"></td>
</tr>
<tr class="advanced">
<td class="fieldlabel" width="150px">TR</td>
<td><input type="text" name="s_seriestr" value="<?php
echo $searchvars['s_seriestr'];
?>
" title="Repetition time in milliseconds" size="10"> <span class="tiny">ms</span></td>
</tr>
<tr class="advanced" title="<b>Must be an integer or a criteria:</b><ul><li>> <i>N</i> (greater than)<li>>= <i>N</i> (greater than or equal to)<li>< <i>N</i> (less than)<li><= <i>N</i> (less than or equal to)<li>~ <i>N</i> (not)</ul>">
<td class="fieldlabel" width="150px">Series number</td>
<td><input type="text" name="s_seriesnum" value="<?php
echo $searchvars['s_seriesnum'];
?>
" size="10"></td>
</tr>
<tr class="advanced" title="<b>Must be an integer or a criteria:</b><ul><li>> <i>N</i> (greater than)<li>>= <i>N</i> (greater than or equal to)<li>< <i>N</i> (less than)<li><= <i>N</i> (less than or equal to)<li>~ <i>N</i> (not)</ul>">
<td class="fieldlabel" width="150px">Number of files</td>
<td><input type="text" name="s_seriesnumfiles" value="<?php
echo $searchvars['s_seriesnumfiles'];
?>
" size="10"></td>
</tr>
<tr class="advanced">
<td class="fieldlabel" width="150px">Group</td>
<td>
<select name="s_seriesgroupid">
<option value="">Select a group</option>
<?
$sqlstring = "select * from groups where group_type = 'series' order by group_name";
$result = MySQLQuery($sqlstring,__FILE__,__LINE__);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$groupid = $row['group_id'];
$groupname = $row['group_name'];
$groupowner = $row['group_owner'];
if ($groupid == $searchvars['s_seriesgroupid']) {
$selected = "selected";
}
else {
$selected = "";
}
?>
<option value="<?php
echo $groupid;
?>
" <?php
echo $selected;
?>
><?php
echo $groupname;
?>
</option>
<?
}
?>
</select>
</td>
</tr>
</table>
</td>
</tr>
<tr class="advanced">
<td class="sidelabel">Analysis</td>
<td style="border-bottom: 1pt solid #CCC">
<table width="100%" cellspacing="0" cellpadding="3">
<tr>
<td class="fieldlabel" width="150px">Pipeline</td>
<td>
<select name="s_pipelineid" onClick="SwitchOption('viewpipeline')">
<option value="">Select pipeline</option>
<?
$sqlstring2 = "select pipeline_id, pipeline_name from pipelines order by pipeline_name";
$result2 = MySQLQuery($sqlstring2,__FILE__,__LINE__);
while ($row2 = mysql_fetch_array($result2, MYSQL_ASSOC)) {
$pipelineid = $row2['pipeline_id'];
$pipelinename = $row2['pipeline_name'];
?>
<option value="<?php
echo $pipelineid;
?>
" <? if ($searchvars['s_pipelineid'] == $pipelineid) { echo "selected"; } ?>><?php
echo $pipelinename;
?>
</option>
<?
}
?>
</select>
</td>
</tr>
<tr>
<td class="fieldlabel" width="150px">Result name</td>
<td><input type="text" name="s_pipelineresultname" onClick="SwitchOption('viewpipeline')" value="<?php
echo $searchvars['s_pipelineresultname'];
?>
" size="50" class="importantfield"></td>
</tr>
<tr>
<td class="fieldlabel" width="150px">Result unit</td>
<td><input type="text" name="s_pipelineresultunit" onClick="SwitchOption('viewpipeline')" value="<?php
echo $searchvars['s_pipelineresultunit'];
?>
" size="20" maxsize="20" class="importantfield"></td>
</tr>
<tr>
<td class="fieldlabel" width="150px">Result type</td>
<td>
<input type="radio" name="s_pipelineresulttype" value="" onClick="SwitchOption('viewpipeline')" <? if ($searchvars['s_pipelineresulttype'] == '') { echo "checked"; } ?>>None<br>
<input type="radio" name="s_pipelineresulttype" value="v" onClick="SwitchOption('viewpipeline')" <? if ($searchvars['s_pipelineresulttype'] == 'v') { echo "checked"; } ?>>Value<br>
<input type="radio" name="s_pipelineresulttype" value="i" onClick="SwitchOption('viewpipeline')" <? if ($searchvars['s_pipelineresulttype'] == 'i') { echo "checked"; } ?>>Image<br>
<input type="radio" name="s_pipelineresulttype" value="f" onClick="SwitchOption('viewpipeline')" <? if ($searchvars['s_pipelineresulttype'] == 'f') { echo "checked"; } ?>>File<br>
<input type="radio" name="s_pipelineresulttype" value="h" onClick="SwitchOption('viewpipeline')" <? if ($searchvars['s_pipelineresulttype'] == 'h') { echo "checked"; } ?>>HTML<br>
</td>
</tr>
<tr>
<td class="fieldlabel" width="150px">Result value</td>
<td valign="top">
<select name="s_pipelineresultcompare" onClick="SwitchOption('viewpipeline')">
<option value="=" <? if ($searchvars['s_pipelineresultcompare'] == '=') { echo "selected"; } ?>>=
<option value=">" <? if ($searchvars['s_pipelineresultcompare'] == '>') { echo "selected"; } ?>>>
<option value=">=" <? if ($searchvars['s_pipelineresultcompare'] == '>=') { echo "selected"; } ?>>>=
<option value="<" <? if ($searchvars['s_pipelineresultcompare'] == '<') { echo "selected"; } ?>><
<option value="<=" <? if ($searchvars['s_pipelineresultcompare'] == '<=') { echo "selected"; } ?>><=
</select>
<input type="text" name="s_pipelineresultvalue" onClick="SwitchOption('viewpipeline')" value="<?php
echo $searchvars['s_pipelineresultvalue'];
?>
" size="15" class="smallsearchbox"><br>
<input type="checkbox" name="s_pipelinecolorize" onClick="SwitchOption('viewpipeline')" value="1" <? if ($searchvars['s_pipelinecolorize'] == 1) { echo "checked"; } ?>>Colorize <span class="tiny">low <img src="images/colorbar.png"> high</span>
<br>
<input type="checkbox" name="s_pipelinecormatrix" onClick="SwitchOption('viewpipeline')" value="1" <? if ($searchvars['s_pipelinecormatrix'] == 1) { echo "checked"; } ?>>Display correlation matrix <span class="tiny">Slow for large result sets</span>
<br>
<input type="checkbox" name="s_pipelineresultstats" onClick="SwitchOption('viewpipeline')" value="1" <? if ($searchvars['s_pipelineresultstats'] == 1) { echo "checked"; } ?>>Display result statistics
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="sidelabel" style="color: gray">Results</td>
<td style="border-bottom: 1pt solid #CCC">
<table width="100%" cellspacing="0" cellpadding="3">
<tr>
<td class="fieldlabel" width="150px"><!--Results format--></td>
<td>
<span style="font-size:10pt; color: darkblue">Download/Export</span><br>
<? if (($searchvars['s_resultorder'] == "subject") || ($action == "")) { $checked = "checked"; } else { $checked = ""; }?>
<input type="radio" name="s_resultorder" id="downloadsubject" value="subject" <?php
echo $checked;
?>
> Enrollment List<br>
<? if (($searchvars['s_resultorder'] == "uniquesubject") || ($action == "")) { $checked = "checked"; } else { $checked = ""; }?>
<input type="radio" name="s_resultorder" id="downloaduniquesubject" value="uniquesubject" <?php
echo $checked;
?>
> Subject List<br>
<? if (($searchvars['s_resultorder'] == "study") || ($action == "")) { $checked = "checked"; } else { $checked = ""; }?>
<input type="radio" name="s_resultorder" id="downloadstudy" value="study" <?php
echo $checked;
?>
> Group by <b>study</b><br>
<? if ($searchvars['s_resultorder'] == "series") { $checked = "checked"; } else { $checked = ""; }?>
<input type="radio" name="s_resultorder" id="downloadseries" value="series" <?php
echo $checked;
?>
> Series List
<br><br>
<span style="font-size:10pt; color: darkblue">View</span><br>
<? if ($searchvars['s_resultorder'] == "table") { $checked = "checked"; } else { $checked = ""; }?>
<input type="radio" name="s_resultorder" id="viewtable" value="table" <?php
echo $checked;
?>
> Table<br>
<? if ($searchvars['s_resultorder'] == "csv") { $checked = "checked"; } else { $checked = ""; }?>
<input type="radio" name="s_resultorder" id="viewcsv" value="csv" <?php
echo $checked;
?>
> Spreadsheet <span class="tiny">.csv</span><br>
<? if ($searchvars['s_resultorder'] == "pipeline") { $checked = "checked"; } else { $checked = ""; }?>
<input type="radio" name="s_resultorder" id="viewpipeline" value="pipeline" <?php
echo $checked;
?>
> Pipeline results<br>
<? if ($searchvars['s_resultorder'] == "pipelinecsv") { $checked = "checked"; } else { $checked = ""; }?>
<input type="radio" name="s_resultorder" id="viewpipelinecsv" value="pipelinecsv" <?php
echo $checked;
?>
> Pipeline results <span class="tiny">.csv</span><br>
<? if ($searchvars['s_resultorder'] == "long") { $checked = "checked"; } else { $checked = ""; }?>
<input type="radio" name="s_resultorder" id="viewlong" value="long" <?php
echo $checked;
?>
> Longitudinal<br>
<? if ($searchvars['s_resultorder'] == "debug") { $checked = "checked"; } else { $checked = ""; }?>
<input type="radio" name="s_resultorder" id="viewdebug" value="debug" <?php
echo $checked;
?>
> Debug <span class="tiny">SQL</span><br>
<? if ($GLOBALS['isadmin']) { ?>
<? if ($searchvars['s_resultorder'] == "operations") { $checked = "checked"; } else { $checked = ""; }?>
<input type="radio" name="s_resultorder" id="viewoperations" value="operations" <?php
echo $checked;
?>
> File operations
<? } ?>
<br>
<br>
<? if ($searchvars['s_audit'] == "1") { $checked = "checked"; } else { $checked = ""; }?>
<input type="checkbox" name="s_audit" value="1" <?php
echo $checked;
?>
> Audit <span class="tiny">files</span>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="2" align="center" style="padding-top: 15px;">
<input type="submit" value="Search">
</td>
</tr>
</table>
</td>
<td rowspan="5" width="300px" valign="top" style="padding-left: 150px; color: darkblue; font-size:10pt">
<details>
<summary><b>Search Tips:</b></summary>
<ul>
<li>Enter as much or as little information as you want
<li>Put commas between items to search for lists of names, scanids, study descriptions, physicians, operators or protocols
<li>Use the <a href="http://www.google.com/chrome" class="link">Google Chrome</a> browser if possible
</ul>
</details>
</td>
</tr>
</table>
</form>
</div>
<?
}
function DisplayImportMenu() {
$urllist['Home'] = "index.php";
$urllist['Import'] = "import.php";
$urllist['Import'] = "import.php?action=import";
NavigationBar("Import", $urllist);
?>
<style>
.gradientsummary {
background: -moz-linear-gradient(left, rgba(151,187,229,1) 0%, rgba(151,187,229,0.99) 1%, rgba(125,185,232,0) 100%); /* FF3.6+ */
background: -webkit-gradient(linear, left top, right top, color-stop(0%,rgba(151,187,229,1)), color-stop(1%,rgba(151,187,229,0.99)), color-stop(100%,rgba(125,185,232,0))); /* Chrome,Safari4+ */
background: -webkit-linear-gradient(left, rgba(151,187,229,1) 0%,rgba(151,187,229,0.99) 1%,rgba(125,185,232,0) 100%); /* Chrome10+,Safari5.1+ */
background: -o-linear-gradient(left, rgba(151,187,229,1) 0%,rgba(151,187,229,0.99) 1%,rgba(125,185,232,0) 100%); /* Opera 11.10+ */
background: -ms-linear-gradient(left, rgba(151,187,229,1) 0%,rgba(151,187,229,0.99) 1%,rgba(125,185,232,0) 100%); /* IE10+ */
background: linear-gradient(to right, rgba(151,187,229,1) 0%,rgba(151,187,229,0.99) 1%,rgba(125,185,232,0) 100%); /* W3C */
filter: progid:DXImageTransform.Microsoft.gradient( startColorstr='#97bbe5', endColorstr='#007db9e8',GradientType=1 ); /* IE6-9 */ color: black;
/*font-weight:bold*/
}
</style>
<script>
function AlphaNumeric(e) {
var key;
var keychar;
if (window.event)
key = window.event.keyCode;
else if (e)
key = e.which;
else
return true;
keychar = String.fromCharCode(key);
keychar = keychar.toLowerCase();
// control keys
if ((key==null) || (key==0) || (key==8) || (key==9) || (key==13) || (key==27) )
return true;
// alphas and numbers
else if ((("abcdefghijklmnopqrstuvwxyz0123456789_").indexOf(keychar) > -1))
return true;
else
return false;
}
</script>
<div style="font-weight:bold; color: darkblue; font-size:14pt">Upload data to NiDB</div>
<br>
<span style="color:#444">Instance <b><?php
echo $GLOBALS['instancename'];
?>
</b></span>
<br>
<br>
<div style="padding:8px; border: 1px solid #ccc; border-radius:5px">
<b>Web upload ( < 1GB file size )</b>
<table width="100%">
<tr>
<td>
<table class="entrytable">
<form action="import.php" method="post" enctype="multipart/form-data">
<input type="hidden" name="action" value="uploaddicom">
<tr>
<td class="label">Site</td>
<td>
<select name="siteid" required>
<option value="">Select site...</option>
<?
$s = GetSiteList();
foreach ($s as $site) { ?><option value="<?php
echo $site['id'];
?>
"><?php
echo $site['name'];
?>
</option><? }
?>
</select>
</td>
</tr>
<tr>
<td class="label">Project</td>
<td>
<select name="projectid" required>
<option value="">Select project...</option>
<?
$projects = GetProjectList();
foreach ($projects as $p) { ?><option value="<?php
echo $p['projectid'];
?>
"><?php
echo $p['name'];
?>
(<?php
echo $p['costcenter'];
?>
)</option><? }
?>
</select>
</td>
</tr>
<? if (!$GLOBALS['cfg']['ispublic']) { ?>
<tr>
<td class="label">Anonymize?</td>
<td><input type="checkbox" name="anonymize" value="1" checked></td>
</tr>
<? } ?>
<tr>
<td class="label">Select files<br><span class="tiny">DICOM files only. Or any zip<br>file containing DICOM files</span></td>
<td><input type="file" name="files[]" multiple style="border:none"></td>
</tr>
<tr>
<td colspan="2"><input type="submit" value="Import DICOM"></td>
</tr>
</form>
</table>
</td>
</tr>
</table>
</div>
<br>
<script>
$(document).ready(function() {
var MaxInputs = 8; //maximum input boxes allowed
var InputsWrapper = $("#InputsWrapper"); //Input boxes wrapper ID
var AddButton = $("#AddMoreFileBox"); //Add button ID
var x = InputsWrapper.length; //initlal text box count
var FieldCount=1; //to keep track of text box added
$(AddButton).click(function (e) //on add input button click
{
if(x <= MaxInputs) //max input box allowed
{
FieldCount++; //text box added increment
//add input box
$(InputsWrapper).append('<span> / <select name="importdirs[]" id="field_'+ FieldCount +'"><option value="modality">Modality</option><option value="subjectid">Subject ID</option><option value="seriesdesc">Series description</option><option value="seriesnum">Series number</option><option value="studydesc">Study Description</option><option value="studydatetime">Study datetime</option><option value="thefiles">{The files}</option><option value="beh">beh</option></select><a href="#" class="removeclass">×</a></span>');
x++; //text box increment
}
return false;
});
$("body").on("click",".removeclass", function(e){ //user click on remove text
if( x > 1 ) {
$(this).parent('span').remove(); //remove text box
x--; //decrement textbox
}
return false;
});
$('#nondicomform').on('submit', function(e) {
//prevent the default submithandling
e.preventDefault();
//send the data of 'this' (the matched form) to yourURL
var posting = $.post('import.php', $(this).serialize(), function(data) {
$( "#result" ).empty().append( data );
});
});
});
</script>
<style>
.removeclass { color: darkred; text-decoration:none; }
.removeclass:hover { text-decoration:underline; }
.direxample { font-family: monospace; white-space: pre; font-size:10pt }
.btn { background-color: #ccc; border: 1px solid gray; color: black; text-decoration: none; padding: 1px 4px; }
.freelabel {font-weight: bold; text-align: right; padding-right: 10px; vertical-align: top; color: #666666; font-size:12pt; white-space:nowrap; }
</style>
<details>
<summary>Import non-DICOM Image Data</summary>
<form action="import.php" id="nondicomform" method="post">
<input type="hidden" name="apiaction" value="uploadnondicom">
<div style="margin-left: 20px; padding:8px;">
<table width="100%">
<tr>
<td>
<table class="entrytable">
<tr>
<td class="label">Site</td>
<td>
<select name="siteid" required>
<option value="">Select site...</option>
<?
$s = GetSiteList();
foreach ($s as $site) { ?><option value="<?php
echo $site['id'];
?>
"><?php
echo $site['name'];
?>
</option><? }
?>
</select>
</td>
</tr>
<tr>
<td class="label">Project</td>
<td>
<select name="projectid" required>
<option value="">Select project...</option>
<?
$projects = GetProjectList();
foreach ($projects as $p) { ?><option value="<?php
echo $p['projectid'];
?>
"><?php
echo $p['name'];
?>
(<?php
echo $p['costcenter'];
?>
)</option><? }
?>
</select>
</td>
</tr>
<tr>
<td colspan="2">
<span class="freelabel">Directory structure</span>
<br>
<details>
<summary style="font-size:10pt">Example directory structures</summary>
<table>
<tr>
<td style="padding:2px 20px;">
<span class="direxample">/MR/23490802/t1/{files}</span>
</td>
<td>→</td>
<td style="padding:2px 20px;">
<span class="direxample">/Modality/SubjectID/SeriesDesc/{The files}</span>
</td>
</tr>
<tr>
<td style="padding:2px 20px;">
<span class="direxample">/34890JKP/20140324_120934/5/{files}/beh</span>
</td>
<td>→</td>
<td style="padding:2px 20px;">
<span class="direxample">/SubjectID/StudyDatetime/SeriesNum/{The files}/beh</span>
</td>
</tr>
</table>
</details>
<br>
<a href="#" id="AddMoreFileBox" class="btn">Add Directory →</a>
<div id="InputsWrapper">
<span><select name="importdirs[]" id="field_0"><option value="modality">Modality</option><option value="subjectid">Subject ID</option><option value="seriesdesc">Series description</option><option value="seriesnum">Series number</option><option value="studydesc">Study Description</option><option value="studydatetime">Study datetime</option><option value="thefiles"><span style="color: blue">{The files}</span></option><option value="beh">beh</option></select><a href="#" class="removeclass">×</a></span>
</div>
<br>
</td>
</tr>
<tr>
<td colspan="2"><input type="submit" value="Import non-DICOM"> <div id="result" style="color: darkred"></div></td>
</tr>
</table>
</td>
</tr>
</table>
</div>
</form>
</details>
<br>
<? if ($_SESSION['enablebeta']) { ?>
<details>
<summary>Import Subject Demographics <?php
echo PrintBeta();
?>
</summary>
<div style="margin-left: 40px; padding:8px; background-color: #e5eeff">
<table width="100%">
<tr>
<td valign="top">
<table class="entrytable" style="border:1px solid #ccc">
<form action="import.php" method="post" enctype="multipart/form-data">
<input type="hidden" name="action" value="importdemographics">
<tr>
<td class="label">Site</td>
<td>
<select name="siteid" required>
<option value="">Select site...</option>
<?
$s = GetSiteList();
foreach ($s as $site) { ?><option value="<?php
echo $site['id'];
?>
"><?php
echo $site['name'];
?>
</option><? }
?>
</select>
</td>
</tr>
<tr>
<td class="label">Project</td>
<td>
<select name="projectid" required>
<option value="">Select project...</option>
<?
$projects = GetProjectList();
foreach ($projects as $p) { ?><option value="<?php
echo $p['projectid'];
?>
"><?php
echo $p['name'];
?>
(<?php
echo $p['costcenter'];
?>
)</option><? }
?>
</select>
</td>
</tr>
<tr>
<td class="label">Select files<br><span class="tiny">.csv file in<br>NiDB demographics format</span></td>
<td><input type="file" name="files[]" multiple style="border:none"></td>
</tr>
<tr>
<td colspan="2"><input type="submit" value="Import Demographics"></td>
</tr>
</form>
</table>
</td>
<td valign="top">
.csv format
<div style="border: 1px dashed #ccc;font-family: monospace; white-space: pre; font-size:8pt">
UID, sex, ethnicity, race, weight, height, handedness, education, maritalstatus, smokingstatus
</div>
<br>
<b>Column values</b>
<ul style="font-size:10pt">
<li>Sex
<ul>
<li>M - Male
<li>F - Female
<li>O - Other
<li>U - Unknown
</ul>
<li><b>Ethnicity:</b> hispanic, nothispanic
<li><b>Race:</b> unknown, asian, black, indian, islander, mixed, white, other
<li><b>Weight</b> (in kg)
<li><b>Height</b> (in meters)
<li>Handedness
<ul>
<li>L - Left
<li>R - Right
<li>A - Ambidextrous
<li>U - Unknown
</ul>
<li>Education
<ul>
<li>0 - Unknown
<li>1 - Grade school
<li>2 - Middle school
<li>3 - High school/GED
<li>4 - Trade school
<li>5 - Associates degree
<li>6 - Bachelors degree
<li>7 - Masters degree
<li>8 - Doctoral degree
</ul>
<li><b>Marital status:</b> unknown, married, single, divorced, separated, civilunion, cohabitating, widowed
<li><b>Smoking status:</b> unknown, never, current, past
</ul>
</td>
</tr>
</table>
</div>
</details>
<br>
<? } ?>
<details>
<summary>Import Assessment Forms</summary>
<div style="margin-left: 20px; padding:8px;">
<table width="100%">
<tr>
<td valign="top">
<table class="entrytable">
<form action="import.php" method="post" enctype="multipart/form-data">
<input type="hidden" name="action" value="importassessmentform">
<!--<tr>
<td class="label">Form Name</td>
<td><input type="text" name="newformname" maxlength="50" onKeyPress="return AlphaNumeric(event)"></td>
</tr>-->
<tr>
<td class="label">Select files<br><span class="tiny">.csv file in NiDB<br>assessment format</span></td>
<td><input type="file" name="files[]" multiple style="border:none"></td>
</tr>
<tr>
<td colspan="2"><input type="submit" value="Import Assessment Forms"></td>
</tr>
</form>
</table>
</td>
<td valign="top">
.csv format
<div style="border: 1px dashed #ccc;font-family: monospace; white-space: pre; font-size:8pt; padding: 5px">Title,,,,
description,,,,
question_num, question_text, datatype, values, comment</div>
First line contains title, second line contains description. The remaining lines contain the questions
<br><br>
<b>Datatype</b>
<ul>
<li title="<big><b>multichoice Example</b></big><br><br><i>DSM Classification</i><br><br>100.1 - Silly<br>100.2 - Absurd<br>100.3 - Funny<br>100.4 - Humerous">multichoice <span class="tiny">List of pre-selected answers, multiple can be selected</span>
<li title="<big><b>singlechoice Example</b></big><br><br><i>Handedness</i><br><br>L<br>R<br>B">singlechoice <span class="tiny">List of pre-selected answers, only one can be selected</span>
<li>string <span class="tiny">Single line of text</span>
<li>text <span class="tiny">Multiple lines of text</span>
<li title="<big><b>singlechoice Example</b></big><br><br>3.141592 <i>or</i> 5">number <span class="tiny">Value that must be numeric</span>
<li title="<big><b>singlechoice Example</b></big><br><br>2014/03/01">date <span class="tiny">A date</span>
<li title="<big><b>singlechoice Example</b></big><br><br>The following section will assess your well-being">header <span class="tiny">Information, or section separator</span>
</ul>
</tr>
</table>
</div>
</details>
<br>
<? if ($_SESSION['enablebeta']) { ?>
<details>
<summary>Import Assessment Data <?php
echo PrintBeta();
?>
</summary>
<div style="margin-left: 20px; padding:8px;">
<table width="100%">
<tr>
<td>
<table class="entrytable">
<form action="import.php" method="post" enctype="multipart/form-data">
<input type="hidden" name="action" value="importassessmentdata">
<tr>
<td class="label" colspan="2"><a href="import.php?action=viewassessmentforms">View Available Assessment Forms</a></td>
</tr>
<tr>
<td class="label">Site</td>
<td>
<select name="siteid" required>
<option value="">Select site...</option>
<?
$s = GetSiteList();
foreach ($s as $site) { ?><option value="<?php
echo $site['id'];
?>
"><?php
echo $site['name'];
?>
</option><? }
?>
</select>
</td>
</tr>
<tr>
<td class="label">Project</td>
<td>
<select name="projectid" required>
<option value="">Select project...</option>
<?
$projects = GetProjectList();
foreach ($projects as $p) { ?><option value="<?php
echo $p['projectid'];
?>
"><?php
echo $p['name'];
?>
(<?php
echo $p['costcenter'];
?>
)</option><? }
?>
</select>
</td>
</tr>
<tr>
<td class="label">Select files<br><span class="tiny">.csv file in NiDB<br>assessment data format</span></td>
<td><input type="file" name="files[]" multiple style="border:none"></td>
</tr>
<tr>
<td colspan="2"><input type="submit" value="Import Assessment Scores"></td>
</tr>
</form>
</table>
</td>
</tr>
</table>
</div>
</details>
<br>
<? } ?>
<? if ($_SESSION['enablebeta']) { ?>
<details>
<summary>Import Measures (name/value pairs only) <?php
echo PrintBeta();
?>
</summary>
<div style="margin-left: 20px; padding:8px;">
<table width="100%">
<tr>
<td>
<table class="entrytable">
<form action="import.php" method="post" enctype="multipart/form-data">
<input type="hidden" name="action" value="importmeasures">
<tr>
<td class="label">Site</td>
<td>
<select name="siteid" required>
<option value="">Select site...</option>
<?
$s = GetSiteList();
foreach ($s as $site) { ?><option value="<?php
echo $site['id'];
?>
"><?php
echo $site['name'];
?>
</option><? }
?>
</select>
</td>
</tr>
<tr>
<td class="label">Project</td>
<td>
<select name="projectid" required>
<option value="">Select project...</option>
<?
$projects = GetProjectList();
foreach ($projects as $p) { ?><option value="<?php
echo $p['projectid'];
?>
"><?php
echo $p['name'];
?>
(<?php
echo $p['costcenter'];
?>
)</option><? }
?>
</select>
</td>
</tr>
<tr>
<td class="label">Select .csv files</td>
<td><input type="file" name="files[]" multiple required style="border:none"></td>
</tr>
<tr>
<td class="label">File format</td>
<td>
<table cellspacing="0" cellpadding="0">
<tr>
<td valign="top">
<input type="radio" name="fileformat" value="short" required>Short rows <img src="images/help.gif" title="One row for each measure/value pair, no header">
</td>
<td valign="top">
<details><summary class="tiny">File format example</summary><pre style="font-size:10pt; border: 1px solid #aaa; border-radius:3px; padding: 5px">S1234ABC, instrument1, measure1, value<br>S1234ABC, instrument1, measure2, value<br>S1234ABC, instrument2, measure1, value<br>S1234ABC, instrument2, measure3, value</pre></details>
</td>
</tr>
<tr>
<td valign="top">
<input type="radio" name="fileformat" value="long" required>Long rows <img src="images/help.gif" title="One row for each subject, with header">
</td>
<td valign="top">
<details><summary class="tiny">File format example</summary><pre style="font-size:10pt; border: 1px solid #aaa; border-radius:3px; padding: 5px">-, instrument1, instrument1, instrument2, instrument2, etc<br>UID, measure1, measure2, measure1, measure3, etc<br>S1234ABC, value1, value2, value3, value4, etc<br>S5678LMN, value1, value2, value3, value4, etc<br>S9292XYZ, value1, value2, value3, value4, etc</pre></details>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="2"><input type="submit" value="Import Measures"></td>
</tr>
</form>
</table>
</td>
</tr>
</table>
</div>
</details>
<? } ?>
<?
}
