| 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/Admin/_Archive/ |
Upload File : |
<?
// ClassEvaluationEditFormPerform.phpinc
debugTrackBegin();
//setDebugOn();
#if (dc()) echo "<b>".__FILE__."</b><br>\n";
$f_classId = formValue('classId');
$f_courseId = formValue('courseId');
$f_courseNumber = formValue('courseNumber');
$f_evaluationId = formValue('evaluationId');
$QC = formValue('Question_QC');
$RC = formValue('Question_RC','wf_');
if (dc()) {
echo "\$f_classId=".$f_classId."<br>\n";
echo "\$f_courseId=".$f_courseId."<br>\n";
echo "\$f_courseNumber=".$f_courseNumber."<br>\n";
echo "\$f_evaluationId=".$f_evaluationId."<br>\n";
echo "\$RC=".$RC."<br>\n";
echo "\$QC=".$QC."<br>\n";
}
if ( $_SESSION['uuid'] != $f_uuid ) {
// Page unique.
// UPDATE current questions.
$prefix = 'f_';
$qNow = array();
for ($qn=1; $qn<=$QC; $qn++) {
$qNow[$qn] = array();
$qNow[$qn] = questionGet($qn,$prefix);
if (dc()) {
echo "<b>\$qNow[$qn]</b>="; print_r($qNow[$qn]); echo "<br>\n";
}
questionSet($f_evaluationId,$qNow[$qn]);
}
// INSERT new questions.
$prefix = 'wf_';
$qNew = array();
for ($qn=1; $qn<=$RC; $qn++) {
$qNew[$qn] = array();
$qNew[$qn] = questionGet($qn,$prefix);
if (dc()) {
echo "<b>\$qNew[$qn]</b>="; print_r($qNew[$qn]); echo "<br>\n";
}
if ($qNew[$qn]['answers'] != 0) { questionSet($f_evaluationId,$qNew[$qn]); }
}
$_SESSION['uuid'] = $f_uuid;
} else {
// Page reload.
}
?>
<?
debugTrackEnd();
function questionGet($qn,$prefix) {
$q = array();
if ($qn > 1) { $suffix = '_'.$qn; } else { $suffix = ''; }
$q['questionId'] = formValue('questionId'.$suffix,$prefix); if ($q['questionId'] == '') { $q['questionId'] = 0; }
$q['questionType'] = formValue('qt'.$suffix,$prefix);
switch ($q['questionType']) {
case 'es':
$q['questionGroup'] = formValue('qg'.$suffix,$prefix); if ($q['questionGroup'] <= 0) { $q['questionGroup'] = 0; }
$q['questionOrder'] = formValue('qo'.$suffix,$prefix); if ($q['questionOrder'] <= 0) { $q['questionOrder'] = 0; }
$q['questionText'] = formValue('q'.$suffix,$prefix);
$q['questionModifier'] = formValue('esr'.$suffix,$prefix);
$q['questionNote'] = '';
$q['questionNoteDisplay'] = 0;
$q['questionInactive'] = 0;
$q['answers'] = 1;
$q['answerText'] = array();
$q['answerCorrect'] = array();
$q['answerText'][1] = formValue('a'.$suffix,$prefix);
$q['answerCorrect'][1] = 1;
break;
case 'mt':
$q['questionGroup'] = formValue('qg'.$suffix,$prefix); if ($q['questionGroup'] <= 0) { $q['questionGroup'] = 0; }
$q['questionOrder'] = formValue('qo'.$suffix,$prefix); if ($q['questionOrder'] <= 0) { $q['questionOrder'] = 0; }
$q['questionText'] = formValue('q'.$suffix,$prefix);
$q['questionModifier'] = 0;
$q['questionNote'] = '';
$q['questionNoteDisplay'] = 0;
$q['questionInactive'] = 0;
$q['answers'] = 1;
$q['answerText'] = array();
$q['answerCorrect'] = array();
$q['answerText'][1] = formValue('a0'.$suffix,$prefix);
$q['answerCorrect'][1] = 1;
break;
case 'ma':
$q['questionGroup'] = formValue('qg'.$suffix,$prefix); if ($q['questionGroup'] <= 0) { $q['questionGroup'] = 0; }
$q['questionOrder'] = formValue('qo'.$suffix,$prefix); if ($q['questionOrder'] <= 0) { $q['questionOrder'] = 0; }
$q['questionText'] = formValue('q'.$suffix,$prefix);
$q['questionModifier'] = formValue('na'.$suffix,$prefix);
$q['questionNote'] = '';
$q['questionNoteDisplay'] = 0;
$q['questionInactive'] = 0;
$q['answers'] = $q['questionModifier'];
$q['answerText'] = array();
$q['answerCorrect'] = array();
for ($an=1; $an<=$q['answers']; $an++) {
$q['answerText'][$an] = formValue('a'.$an.$suffix,$prefix);
$q['answerCorrect'][$an] = formValue('caC'.$an.$suffix,$prefix); if ($q['answerCorrect'][$an] <=0) { $q['answerCorrect'][$an] = 0; }
}
break;
case 'mc':
$q['questionGroup'] = formValue('qg'.$suffix,$prefix); if ($q['questionGroup'] <= 0) { $q['questionGroup'] = 0; }
$q['questionOrder'] = formValue('qo'.$suffix,$prefix); if ($q['questionOrder'] <= 0) { $q['questionOrder'] = 0; }
$q['questionText'] = formValue('q'.$suffix,$prefix);
$q['questionModifier'] = formValue('na'.$suffix,$prefix);
$q['questionNote'] = '';
$q['questionNoteDisplay'] = 0;
$q['questionInactive'] = 0;
$q['answers'] = $q['questionModifier'];
$q['answerText'] = array();
$q['answerCorrect'] = array();
$qa = formValue('caR'.$suffix,$prefix);
for ($an=1; $an<=$q['answers']; $an++) {
$q['answerText'][$an] = formValue('a'.$an.$suffix,$prefix);
if ($an != $qa) { $q['answerCorrect'][$an] = 0; } else { $q['answerCorrect'][$an] = 1; }
}
break;
case 'sa':
$q['questionGroup'] = formValue('qg'.$suffix,$prefix); if ($q['questionGroup'] <= 0) { $q['questionGroup'] = 0; }
$q['questionOrder'] = formValue('qo'.$suffix,$prefix); if ($q['questionOrder'] <= 0) { $q['questionOrder'] = 0; }
$q['questionText'] = formValue('q'.$suffix,$prefix);
$q['questionModifier'] = formValue('sas'.$suffix,$prefix);
$q['questionNote'] = '';
$q['questionNoteDisplay'] = 0;
$q['questionInactive'] = 0;
$q['answers'] = 1;
$q['answerText'] = array();
$q['answerCorrect'] = array();
$q['answerText'][1] = formValue('a0'.$suffix,$prefix);
$q['answerCorrect'][1] = 1;
break;
case 'tf':
$q['questionGroup'] = formValue('qg'.$suffix,$prefix); if ($q['questionGroup'] <= 0) { $q['questionGroup'] = 0; }
$q['questionOrder'] = formValue('qo'.$suffix,$prefix); if ($q['questionOrder'] <= 0) { $q['questionOrder'] = 0; }
$q['questionText'] = formValue('q'.$suffix,$prefix);
$q['questionModifier'] = 2;
$q['questionNote'] = '';
$q['questionNoteDisplay'] = 0;
$q['questionInactive'] = 0;
$q['answers'] = 2;
$q['answerText'] = array();
$q['answerCorrect'] = array();
$q['answerText'][1] = 'True';
$q['answerText'][2] = 'False';
$qa = formValue('caR'.$suffix,$prefix);
for ($an=1; $an<=$q['answers']; $an++) {
if ($an != $qa) { $q['answerCorrect'][$an] = 0; } else { $q['answerCorrect'][$an] = 1; }
}
break;
case 'up':
$q['questionGroup'] = formValue('qg'.$suffix,$prefix); if ($q['questionGroup'] <= 0) { $q['questionGroup'] = 0; }
$q['questionOrder'] = formValue('qo'.$suffix,$prefix); if ($q['questionOrder'] <= 0) { $q['questionOrder'] = 0; }
$q['questionText'] = formValue('q'.$suffix,$prefix);
$q['questionNote'] = '';
$q['questionNoteDisplay'] = 0;
$q['questionInactive'] = 0;
$q['answers'] = 1;
$q['answerText'] = array();
$q['answerCorrect'] = array();
$q['answerText'][1] = formValue('a0'.$suffix,$prefix);
$q['answerCorrect'][1] = 1;
break;
case 'ur':
$q['questionGroup'] = formValue('qg'.$suffix,$prefix); if ($q['questionGroup'] <= 0) { $q['questionGroup'] = 0; }
$q['questionOrder'] = formValue('qo'.$suffix,$prefix); if ($q['questionOrder'] <= 0) { $q['questionOrder'] = 0; }
$q['questionText'] = formValue('q'.$suffix,$prefix);
$q['questionModifier'] = formValue('sas'.$suffix,$prefix);
$q['questionNote'] = '';
$q['questionNoteDisplay'] = 0;
$q['questionInactive'] = 0;
$q['answers'] = 1;
$q['answerText'] = array();
$q['answerCorrect'] = array();
$q['answerText'][1] = formValue('a0'.$suffix,$prefix);
$q['answerCorrect'][1] = 1;
break;
case 'yn':
$q['questionGroup'] = formValue('qg'.$suffix,$prefix); if ($q['questionGroup'] <= 0) { $q['questionGroup'] = 0; }
$q['questionOrder'] = formValue('qo'.$suffix,$prefix); if ($q['questionOrder'] <= 0) { $q['questionOrder'] = 0; }
$q['questionText'] = formValue('q'.$suffix,$prefix);
$q['questionModifier'] = 2;
$q['questionNote'] = '';
$q['questionNoteDisplay'] = 0;
$q['questionInactive'] = 0;
$q['answers'] = 2;
$q['answerText'] = array();
$q['answerCorrect'] = array();
$q['answerText'][1] = 'Yes';
$q['answerText'][2] = 'No';
$qa = formValue('caR'.$suffix,$prefix);
for ($an=1; $an<=$q['answers']; $an++) {
if ($an != $qa) { $q['answerCorrect'][$an] = 0; } else { $q['answerCorrect'][$an] = 1; }
}
break;
case 'im':
$q['questionGroup'] = formValue('qg'.$suffix,$prefix); if ($q['questionGroup'] <= 0) { $q['questionGroup'] = 0; }
$q['questionOrder'] = formValue('qo'.$suffix,$prefix); if ($q['questionOrder'] <= 0) { $q['questionOrder'] = 0; }
$q['questionText'] = '';
$q['questionModifier'] = 0;
$q['questionNote'] = '';
$q['questionNoteDisplay'] = 0;
$q['questionInactive'] = 0;
$q['answers'] = 1;
$q['answerText'] = array();
$q['answerCorrect'] = array();
$q['answerText'][1] = formValue('a0'.$suffix,$prefix);
$q['answerCorrect'][1] = 1;
break;
case 'co':
case 'he':
case 'in':
$q['questionGroup'] = formValue('qg'.$suffix,$prefix); if ($q['questionGroup'] <= 0) { $q['questionGroup'] = 0; }
$q['questionOrder'] = formValue('qo'.$suffix,$prefix); if ($q['questionOrder'] <= 0) { $q['questionOrder'] = 0; }
$q['questionText'] = '';
$q['questionModifier'] = 0;
$q['answerText'] = formValue('a'.$suffix,$prefix);
$q['questionNote'] = '';
$q['questionNoteDisplay'] = 0;
$q['questionInactive'] = 0;
$q['answers'] = 1;
$q['answerText'] = array();
$q['answerCorrect'] = array();
$q['answerText'][1] = formValue('a'.$suffix,$prefix);
$q['answerCorrect'][1] = 1;
break;
case '':
default:
$q['questionGroup'] = 0;
$q['questionOrder'] = 0;
$q['questionText'] = '';
$q['questionModifier'] = '';
$q['questionNote'] = '';
$q['questionNoteDisplay'] = 0;
$q['questionInactive'] = 0;
$q['answers'] = 0;
break;
}
return $q;
}
function questionSet($f_evaluationId,$q) {
$f_lastModified = currentDateTime();
//echo "\$q['questionId']=".$q['questionId']." \$q['questionType']=".$q['questionType']; exit;
if ($q['questionType'] != '') {
// INSERT or UPDATE question.
if ($q['questionId'] != 0) {
// UPDATE question
$query = "
UPDATE question SET
evaluationId = ".$f_evaluationId.",
questionType = '".$q['questionType']."',
questionGroup = ".$q['questionGroup'].",
questionOrder = ".$q['questionOrder'].",
questionText = '".$q['questionText']."',
questionModifier = ".$q['questionModifier'].",
questionNote = '".$q['questionNote']."',
questionNoteDisplay = ".$q['questionNoteDisplay'].",
questionInactive = ".$q['questionInactive'].",
lastModified = '".$f_lastModified."',
modifiedBy = ".$_SESSION['userId']."
WHERE questionId = ".$q['questionId']."
";
if (dc()) {
echo "\$query=".$query."<br>\n";
}
$questionUpdate = query_do($query);
// Delete Answers
$query = "
DELETE FROM answer
WHERE questionId = ".$q['questionId']."
";
if (dc()) {
echo "\$query=".$query."<br>\n";
}
$answerDelete = query_do($query);
} else {
// INSERT question
$query = "
INSERT INTO question (
evaluationId,
questionType,
questionGroup,
questionOrder,
questionText,
questionModifier,
questionNote,
questionNoteDisplay,
questionInactive,
lastModified,
modifiedBy
) VALUES (
".$f_evaluationId.",
'".$q['questionType']."',
".$q['questionGroup'].",
".$q['questionOrder'].",
'".$q['questionText']."',
".$q['questionModifier'].",
'".$q['questionNote']."',
".$q['questionNoteDisplay'].",
".$q['questionInactive'].",
'".$f_lastModified."',
".$_SESSION['userId']."
)";
if (dc()) {
echo "\$query=".$query."<br>\n";
}
$questionSet = query_do($query);
// Get questionId.
$query = "
SELECT questionId
FROM question
WHERE evaluationId = ".$f_evaluationId."
AND questionType = '".$q['questionType']."'
AND questionGroup = ".$q['questionGroup']."
AND questionOrder = ".$q['questionOrder']."
AND questionText = '".$q['questionText']."'
AND questionModifier = '".$q['questionModifier']."'
AND questionNote = '".$q['questionNote']."'
AND questionNoteDisplay = '".$q['questionNoteDisplay']."'
AND questionInactive = '".$q['questionInactive']."'
AND lastModified = '".$f_lastModified."'
AND modifiedBy = '".$_SESSION['userId']."'
";
$questionResult = query_do($query);
$questionCount = $_SESSION['mysql_num_rows'];
if (!$questionCount) { echo '<p class="bold">'.__FILE__.' <span class="error">Question not found by query: </span>['.$query."]<br>\n"; setDebugOn(); include('common/pageFooter.phpinc'); }
$questionRow = mysql_fetch_assoc($questionResult);
$q['questionId'] = $questionRow['questionId'];
}
// INSERT answers.
for ($an=1; $an<=$q['answers']; $an++) {
$f_lastModified = currentDateTime();
$query = "
INSERT INTO answer (
questionId,
answerOrder,
answerText,
answerValue,
answerCorrect,
lastModified,
modifiedBy
) VALUES (
".$q['questionId'].",
".$an.",
'".$q['answerText'][$an]."',
0,
".$q['answerCorrect'][$an].",
'".$f_lastModified."',
".$_SESSION['userId']."
)";
if (dc()) {
echo "\$query=".$query."<br>\n";
}
$answerInsert = query_do($query);
}
} else {
// DELETE question.
$query = "
DELETE FROM question
WHERE questionId = ".$q['questionId']."
";
if (dc()) {
echo "\$query=".$query."<br>\n";
}
$questionDelete = query_do($query);
// Delete Answers
$query = "
DELETE FROM answer
WHERE questionId = ".$q['questionId']."
";
if (dc()) {
echo "\$query=".$query."<br>\n";
}
$answerDelete = query_do($query);
}
}
?>