| Server IP : 134.29.175.74 / Your IP : 216.73.216.160 Web Server : nginx/1.10.2 System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586 User : Administrator ( 0) PHP Version : 7.1.0 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/nginx/html/Class/RecognitionLab/ |
Upload File : |
<?
// Class/RecognitionLab/RecognitionLab_Form.phpinc
// Display Recognition lab edit form.
#$DEBUG_RecognitionLabForm = true;
if ( !isset($DEBUG_RecognitionLabForm) ) $DEBUG_RecognitionLabForm = false;
debugTrackBegin(); // Begin TRACKing included file.
$headTitle = '_CST_ - Recognition Lab Edit';
$pageTitle = '_CST_<br>Recognition Lab Edit';
include('common/pageHeader.phpinc');
if ( !isset($f_recognitionlabId) ) $f_recognitionlabId = formValue('subtask');
if ($f_recognitionlabId == '') $f_recognitionlabId = 0;
if ( $DEBUG_RecognitionLabForm ) printVar('$f_form',$f_form);
if ( $DEBUG_RecognitionLabForm ) printVar('$f_recognitionlabId',$f_recognitionlabId);
if ( $f_form != 'form_recognitionlab' ) {
// form_recognitionlab not called by itself. Preload data for form.
if ( $f_recognitionlabId ) {
// $f_recognitionlabId set. This is an edit form. Load form_recognitionlab data from database.
// Get recognitionlab data.
$query = "
SELECT *
FROM `recognitionlab`
WHERE recognitionlabId = ".$f_recognitionlabId."
";
$recognitionlabResult = query_do($query);
$recognitionlabCount = $_SESSION['qry']['count'];
if ($recognitionlabCount) {
// Load form_phonenumber data from data record.
$recognitionlabRow = mysqli_fetch_assoc($recognitionlabResult);
$f_recognitionlabName = $recognitionlabRow['recognitionlabName'];
$f_recognitionlabQuestion = $recognitionlabRow['recognitionlabQuestion'];
} else {
// There was no record for $f_recognitionlabId. This is an error.
?>
<span class="bold error">ERROR!. No record for $f_recognitionlabId=<?=$f_recognitionlabId?> found.</span><br>
<span class="bold error">Please contact the site administrator<? if (isset($_SESSION['APP']['adminemail'])) { echo ' at '.$_SESSION['APP']['adminemail']; } else { echo '.'; } ?>.</span><br>
<?
}
} else {
// $f_recognitionlabId is 0. This is an add form. Set form_recognitionlab data to default values.
$f_recognitionlabName = '';
$f_recognitionlabQuestion = '';
$recognitionlabquestionResultCount = 0;
}
}
?>
<form name="form_recognitionlab" id="form_recognitionlab" action="<?=$_SERVER['PHP_SELF']?>" method="post" enctype="multipart/form-data">
<input type="hidden" name="f_uuid" id="f_uuid" value="<?=uuid()?>">
<input type="hidden" name="f_form" id="f_form" value="form_recognitionlab">
<input type="hidden" name="f_recognitionlabId" id="f_recognitionlabId" value="<?=$f_recognitionlabId?>">
<input type="hidden" name="f_task" id="id_task" value="">
<input type="hidden" name="f_subtask" id="id_subtask" value="">
<fieldset><legend><?=quot($f_recognitionlabName)?> recognition lab edit</legend>
<table>
<input type="hidden" name="f_recognitionlabId" id="f_recognitionlabId" value="<?=quot($f_recognitionlabId)?>">
<? if ( isset($error['recognitionlabName']) ) { ?>
<tr><td class="error" colspan="2"><?=$error['recognitionlabName']?></td></tr>
<? } ?>
<tr>
<td class="right">Name:</td>
<td><input type="text" class="" name="f_recognitionlabName" id="f_recognitionlabName" type="text" value="<?=quot($f_recognitionlabName)?>" style="width:14em;"></td>
</tr>
<? if ( isset($error['recognitionlabQuestion']) ) { ?>
<tr><td class="error" colspan="2"><?=$error['recognitionlabQuestion']?></td></tr>
<? } ?>
<tr>
<td class="right">Question:</td>
<td><input type="text" class="" name="f_recognitionlabQuestion" id="f_recognitionlabQuestion" type="text" value="<?=quot($f_recognitionlabQuestion)?>" style="width:32em;"></td>
</tr>
<tr>
<td class="center" colspan="2"><input type="button" id="RecognitionLabUpdate" value="Update recognition lab" onClick="Submit_Task_Subtask(this);"></td>
</tr>
</table>
</fieldset>
<?
// Get recognitionlabquestion data.
$query = "
SELECT recognitionlabquestionId,
recognitionlabquestionNumber,
recognitionlabquestionName,
recognitionlabquestionData
FROM `recognitionlabquestion`
WHERE recognitionlabId = ".$f_recognitionlabId."
ORDER BY recognitionlabquestionNumber, recognitionlabquestionId
";
$recognitionlabquestionResult = query_do($query);
$recognitionlabquestionResultCount = $_SESSION['qry']['count'];
if ( !isset($questionpartResultCount) ) {
// Get question part data for this recognition lab.
$query = "
SELECT recognitionlabquestionpartId,
recognitionlabquestionpartOrder,
recognitionlabquestionpartText,
recognitionlabquestionpartValue
FROM `recognitionlabquestionpart`
WHERE recognitionlabId = ".$f_recognitionlabId."
ORDER BY recognitionlabquestionpartOrder
";
$questionpartResult = query_do($query);
$questionpartResultCount = $_SESSION['qry']['count'];
if ( $DEBUG_RecognitionLabForm ) printDivVar('$questionpartResult',$questionpartResult);
}
// Questions.
?>
<fieldset><legend><?=quot($f_recognitionlabName)?> questions</legend>
<table class="grayborder">
<tr>
<th class="grayborder">#</th>
<th class="grayborder">Question name</th>
<?
$thQPI = '';
if ( $questionpartResultCount ) {
mysqli_data_seek($questionpartResult, 0);
while ($questionpartRow = mysqli_fetch_assoc($questionpartResult)) {
$thQPI = listAppend($thQPI,$questionpartRow['recognitionlabquestionpartText']);
}
}
?>
<th class="grayborder">Question part answer list:<br><?=htmlView(listAnd($thQPI))?></th>
</tr>
<?
if ( $recognitionlabquestionResultCount ) {
mysqli_data_seek($recognitionlabquestionResult, 0);
while ($recognitionlabquestionRow = mysqli_fetch_assoc($recognitionlabquestionResult)) {
?>
<tr>
<td class="grayborder right"><?=$recognitionlabquestionRow['recognitionlabquestionNumber']?></td>
<td class="grayborder"><?=htmlView($recognitionlabquestionRow['recognitionlabquestionName'])?></td>
<?
$tdQPI = '';
if ( $questionpartResultCount ) {
mysqli_data_seek($questionpartResult, 0);
while ($questionpartRow = mysqli_fetch_assoc($questionpartResult)) {
$query = "
SELECT recognitionlabquestionpartanswerText
FROM `recognitionlabquestionpartanswer`
WHERE recognitionlabquestionId = ".$recognitionlabquestionRow['recognitionlabquestionId']."
AND recognitionlabquestionpartId = ".$questionpartRow['recognitionlabquestionpartId']."
";
#if ( $DEBUG_Questions_List ) printVar("\$query",$query,'q');
$questionpartanswerResult = query_do($query);
#if ( $DEBUG_Questions_List ) printDivVar("\$questionpartanswerResult",$questionpartanswerResult);
$questionpartanswerResultCount = $_SESSION['qry']['count'];
if ( $questionpartanswerResultCount ) {
mysqli_data_seek($questionpartanswerResult, 0);
$questionpartanswerRow = mysqli_fetch_assoc($questionpartanswerResult);
$tdQPI = listAppend($tdQPI,$questionpartanswerRow['recognitionlabquestionpartanswerText']);
}
}
}
?>
<td><?=htmlView(listAnd($tdQPI))?><?
if ( $recognitionlabquestionRow['recognitionlabquestionData'] ) {
$dataLinks = explode(',',$recognitionlabquestionRow['recognitionlabquestionData']);
foreach ( $dataLinks as $dataLink ) {
if ( $dataLink != '' ) {
?><br><a href="<?=$dataLink?>"><?=$dataLink?></a> <?
}
}
}
?></td>
</tr>
<?
}
}
?>
<tr>
<? /** / ?>
<td class="grayborder"></td>
<? /**/ ?>
<td class="grayborder center" colspan="3"><input type="button" id="QuestionsEdit" value="Edit questions" onClick="Submit_Task_Subtask(this);"></td>
</tr>
</table>
</fieldset>
<?
// Question parts.
?>
<fieldset><legend><?=quot($f_recognitionlabName)?> question parts</legend>
<table class="grayborder">
<tr>
<th class="grayborder">#</th>
<th class="grayborder">Question part text</th>
<th class="grayborder">Pts</th>
<th class="grayborder">Question part answers</th>
<?
if ( $questionpartResultCount ) {
mysqli_data_seek($questionpartResult, 0);
while ($questionpartRow = mysqli_fetch_assoc($questionpartResult)) {
?>
<tr class="middle">
<td class="grayborder"><?=$questionpartRow['recognitionlabquestionpartOrder']?></td>
<td class="grayborder"><?=htmlView($questionpartRow['recognitionlabquestionpartText'])?></td>
<td class="grayborder right"><?=$questionpartRow['recognitionlabquestionpartValue']?></td>
<?
// Get DISTINCT question part answer data for this question part.
$query = "
SELECT DISTINCT recognitionlabquestionpartanswerText
FROM `recognitionlabquestionpartanswer`
WHERE recognitionlabquestionpartId = ".$questionpartRow['recognitionlabquestionpartId']."
ORDER BY recognitionlabquestionpartanswerText
";
$questionpartanswerDistinctResult = query_do($query);
$questionpartanswerDistinctResultCount = $_SESSION['qry']['count'];
$answers = '';
?>
<td class="grayborder"><ol>
<?
if ( $questionpartanswerDistinctResultCount ) {
mysqli_data_seek($questionpartanswerDistinctResult, 0);
while ($questionpartanswerDistinctRow = mysqli_fetch_assoc($questionpartanswerDistinctResult)) {
?>
<li><?=htmlView(listAnd($questionpartanswerDistinctRow['recognitionlabquestionpartanswerText']))?></li>
<?
}
}
?>
</ol></tr>
<?
}
}
?>
</tr>
<tr>
<td class="grayborder center" colspan="4"><input type="button" id="QuestionPartsEdit" value="Edit question parts" onClick="Submit_Task_Subtask(this);"></td>
</tr>
</table>
</fieldset>
<?
include('Class/RecognitionLab/RecognitionLab_Code.phpinc');
?>
<input type="button" id="RecognitionLabList" value="Return to recognition lab list" onClick="Submit_Task_Subtask(this);">
</form>
<?
debugTrackEnd(); // End TRACKing included file.
?>