| 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/Class/ |
Upload File : |
<?
// Admin/Class/ClassEvaluationEdit_testUpdate.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()) {
printLine('');
printVar('$f_classId',$f_classId,'f');
printVar('$f_courseId',$f_courseId,'f');
printVar('$f_courseNumber',$f_courseNumber,'f');
printVar('$f_evaluationId',$f_evaluationId,'f');
printVar('$RC',$RC,'f');
printVar('$QC',$QC,'f');
}
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()) {
printVar('$qNow['.$qn.']',$qNow[$qn]);
}
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()) {
printVar('$qNew['.$qn.']',$qNew[$qn]);
printVar('$qNew['.$qn.']'."['answers']",$qNew[$qn]['answers']);
}
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;
}
// questionSet($f_evaluationId,$q)
// INSERT or UPDATE a question.
// $f_evaluationId = The evaluationId.
// $q = An array holding the question information:
// questionId - Set to 0 for question INSERT.
// questionType
// questionGroup
// questionOrder
// questionText
// questionModifier
// questionNote
// questionNoteDisplay
// questionInactive
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()) printVar('$query',$query);
$questionSet = query_do($query);
// Get questionId.
$q['questionId'] = mysqli_insert_id($_SESSION['DATABASE_LINK']);
if (dc()) printVar("\$q['questionId']",$q['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()) {
printVar('$query',$query);
}
$answerInsert = query_do($query);
#printVar('mysqli_insert_id($_SESSION['DATABASE_LINK'])',mysqli_insert_id($_SESSION['DATABASE_LINK']));
}
} else {
// Delete Answers.
$query = "
DELETE FROM answer
WHERE questionId = ".$q['questionId']."
";
if (dc()) {
echo "\$query=".$query."<br>\n";
}
$answerDelete = query_do($query);
// DELETE question.
$query = "
DELETE FROM question
WHERE questionId = ".$q['questionId']."
";
if (dc()) {
echo "\$query=".$query."<br>\n";
}
$questionDelete = query_do($query);
}
}
?>