| 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/Question_Verify.phpinc
// Purpose_of_include_file_goes_here.
#$DEBUG_Question_Verify = true;
if ( !isset($DEBUG_Question_Verify) ) $DEBUG_Question_Verify = false;
debugTrackBegin(); // Begin TRACKing included file.
$error = array();
// Verify recognitionlabId.
if ( !isset($f_recognitionlabId) ) $f_recognitionlabId = formValue('recognitionlabId');
if ( !$f_recognitionlabId ) {
include('common/pageHeader.phpinc');
$f_error = '$f_recognitionlabId not set.<span class="d_s_fl"> '.basename(__FILE__).':'.__LINE__.'</span><span class="d_s_fp"> '.basename(__FILE__).':'.__LINE__.'</span>';
include('common/displayErrorsAndMessages.phpinc');
if ( in_array('ADMIN',$_SESSION['userPermissions']) ) setDebugOn();
include('common/pageFooter.phpinc');
}
// Verify recognitionlabName.
if ( !isset($f_recognitionlabName) ) $f_recognitionlabName = formValue('recognitionlabName');
// Verify recognitionlabquestionId.
if ( !isset($f_recognitionlabquestionId) ) $f_recognitionlabquestionId = formValue('recognitionlabquestionId');
if ( !$f_recognitionlabquestionId ) {
include('common/pageHeader.phpinc');
$f_error = '$f_recognitionlabquestionId not set.<span class="d_s_fl"> '.basename(__FILE__).':'.__LINE__.'</span><span class="d_s_fp"> '.basename(__FILE__).':'.__LINE__.'</span>';
include('common/displayErrorsAndMessages.phpinc');
if ( in_array('ADMIN',$_SESSION['userPermissions']) ) setDebugOn();
include('common/pageFooter.phpinc');
}
// Get question data.
$query = "
SELECT recognitionlabquestionId,
recognitionlabId,
recognitionlabquestionNumber,
recognitionlabquestionName,
recognitionlabquestionData
FROM `recognitionlabquestion`
WHERE recognitionlabId = ".$f_recognitionlabId."
AND recognitionlabquestionId = ".$f_recognitionlabquestionId."
";
if ( $DEBUG_Question_Verify ) printVar("\$query",$query,'q');
$questionResult = query_do($query);
if ( $DEBUG_Question_Verify ) printDivVar("\$questionResult",$questionResult);
$questionResultCount = $_SESSION['qry']['count'];
if ( $questionResultCount ) {
mysqli_data_seek($questionResult, 0);
$questionRow = mysqli_fetch_assoc($questionResult);
// Get question form data.
$questionId = $questionRow['recognitionlabquestionId'];
$question = array();
$question['Number'] = $questionRow['recognitionlabquestionNumber'];
$question['Name'] = formValue('recognitionlabquestion_'.$questionId.'_Name');
if ( $DEBUG_Question_Verify ) printVar("\$question['Name']",$question['Name']);
if ( $question['Name'] === false ) $question['Name'] = $questionRow['recognitionlabquestionName'];
if ( $question['Name'] == '' ) {
$error['recognitionlabquestion_'.$questionId.'_Name'] = 'The question text cannot be blank.<br>Please enter question part text.';
}
$question['Data'] = formValue('recognitionlabquestion_'.$questionId.'_Data');
if ( $DEBUG_Question_Verify ) printVar("\$question['Data']",$question['Data']);
if ( $question['Data'] === false ) $question['Data'] = $questionRow['recognitionlabquestionData'];
if ( $DEBUG_Question_Verify ) printVar("\$question['Data']",$question['Data']);
if ( $DEBUG_Question_Verify ) printVar("isset(\$error['recognitionlabquestion_'.$questionId.'_Name'])",isset($error['recognitionlabquestion_'.$questionId.'_Name']));
if ( $DEBUG_Question_Verify ) printVar("\$question['Name'] != \$questionRow['recognitionlabquestionName']",$question['Name'] != $questionRow['recognitionlabquestionName']);
if ( $DEBUG_Question_Verify ) printVar("\$question['Data'] != \$questionRow['recognitionlabquestionData']",$question['Data'] != $questionRow['recognitionlabquestionData']);
if ( !isset($error['recognitionlabquestion_'.$questionId.'_Name'])
&& ( $question['Name'] != $questionRow['recognitionlabquestionName'] || $question['Data'] != $questionRow['recognitionlabquestionData'] ) ) {
$question['Changed'] = true;
} else {
$question['Changed'] = false;
}
}
// Get question answer data.
$questionpartIds = array();
$questionpartanswer = array();
$query = "
SELECT recognitionlabquestionpartanswerId,
recognitionlabquestionId,
recognitionlabquestionpartId,
recognitionlabquestionpartanswerText
FROM `recognitionlabquestionpartanswer`
WHERE recognitionlabquestionId = ".$f_recognitionlabquestionId."
";
if ( $DEBUG_Question_Verify ) printVar("\$query",$query,'q');
$questionpartanswerResult = query_do($query);
if ( $DEBUG_Question_Verify ) printDivVar("\$questionpartanswerResult",$questionpartanswerResult);
$questionpartanswerResultCount = $_SESSION['qry']['count'];
if ( $questionpartanswerResultCount ) {
mysqli_data_seek($questionpartanswerResult, 0);
while ($questionpartanswerRow = mysqli_fetch_assoc($questionpartanswerResult)) {
// Get questionpartanswer form data.
$questionpartId = $questionpartanswerRow['recognitionlabquestionpartId'];
$questionpartIds[] = $questionpartId;
$questionpartanswer[$questionpartId] = array();
#$questionpartanswer[$questionpartId]['questionpartId'] = $questionpartanswerRow['recognitionlabquestionpartId'];
$questionpartanswer[$questionpartId]['Text'] = formValue('questionpartanswer_'.$questionpartId.'_Text');
if ( $DEBUG_Question_Verify ) printVar("\$questionpartanswer[$questionpartId]['Text']",$questionpartanswer[$questionpartId]['Text']);
if ( $questionpartanswer[$questionpartId]['Text'] === false ) $questionpartanswer[$questionpartId]['Text'] = $questionpartanswerRow['recognitionlabquestionpartanswerText'];
if ( $questionpartanswer[$questionpartId]['Text'] == '' ) {
#$error['recognitionlabquestionpartanswer_'.$questionpartId.'_Text'] = 'The question part answer cannot be blank.<br>Please enter question part answer.';
}
if ( !isset($error['recognitionlabquestionpartanswer_'.$questionpartId.'_Value'])
&& $questionpartanswer[$questionpartId]['Text'] != $questionpartanswerRow['recognitionlabquestionpartanswerText'] ) {
$questionpartanswer[$questionpartId]['Changed'] = 'Update';
} else {
$questionpartanswer[$questionpartId]['Changed'] = false;
}
}
}
// Get question part data.
$query = "
SELECT recognitionlabquestionpartId,
recognitionlabId,
recognitionlabquestionpartOrder,
recognitionlabquestionpartText,
recognitionlabquestionpartValue
FROM `recognitionlabquestionpart`
WHERE recognitionlabId = ".$f_recognitionlabId."
ORDER BY recognitionlabquestionpartOrder
";
$questionpartResult = query_do($query);
if ( $DEBUG_Question_Verify ) printDivVar('$questionpartResult',$questionpartResult);
$questionpartResultCount = $_SESSION['qry']['count'];
if (!$questionpartResultCount) {
$questionpartRow = false;
include('common/pageHeader.phpinc');
$f_error = 'No data from query: "<span class="d_s_q">'.$query.'</span>".<span class="d_s_fl"> '.basename(__FILE__).':'.__LINE__.'</span><span class="d_s_fp"> '.basename(__FILE__).':'.__LINE__.'</span>';
include('common/displayErrorsAndMessages.phpinc');
include('common/pageFooter.phpinc');
}
// Fix $questionpartIds and $questionpartanswer.
mysqli_data_seek($questionpartResult, 0);
while ($questionpartRow = mysqli_fetch_assoc($questionpartResult)) {
$questionpartId = $questionpartRow['recognitionlabquestionpartId'];
if ( !isset($questionpartanswer[$questionpartId]) ) {
$questionpartIds[] = $questionpartId;
$questionpartanswer[$questionpartId] = array();
#$questionpartanswer[$questionpartId]['questionpartId'] = $questionpartRow['recognitionlabquestionpartId'];
$questionpartanswer[$questionpartId]['Text'] = formValue('questionpartanswer_'.$questionpartId.'_Text');
if ( $DEBUG_Question_Verify ) printVar("\$questionpartanswer[$questionpartId]['Text']",$questionpartanswer[$questionpartId]['Text']);
if ( $questionpartanswer[$questionpartId]['Text'] === false ) $questionpartanswer[$questionpartId]['Text'] = '';
if ( $questionpartanswer[$questionpartId]['Text'] != '' ) {
$questionpartanswer[$questionpartId]['Changed'] = 'Insert';
} else {
$questionpartanswer[$questionpartId]['Changed'] = false;
}
}
}
if ( $DEBUG_Question_Verify ) printVar("\$questionRow",$questionRow);
if ( $DEBUG_Question_Verify ) printVar("\$questionId",$questionId);
if ( $DEBUG_Question_Verify ) printVar("\$question",$question);
if ( $DEBUG_Question_Verify ) printVar("\$questionpartIds",$questionpartIds);
if ( $DEBUG_Question_Verify ) printVar("\$questionpartanswer",$questionpartanswer);
if ( $DEBUG_Question_Verify ) printVar("\$error",$error);
debugTrackEnd(); // End TRACKing included file.
?>