strQuestionID', $QID,0); destroy(this.id); jsShowElement('divStats_$QID',-1); \" />
}
}
public static function Save(&$QuestionID, $nemo)
{
global $xdb;
//print_rr($_POST);
$db = new NemoDatabase("surQuestion", $QuestionID, null, 0);//array("refAssignmentID","strSection","strQuestionHeading")
$db->SetValues($_POST);
$db->Fields[strLastUser] = $_SESSION['USER']->USERNAME;
$result = $db->Save(0,0);
if($QuestionID > 0)
{
if(isset($_POST["strOption"]))
{
foreach($_POST["strOption"] as $k=>$v)
{
if(!isset($_POST["intWeighting"][$k]) || $_POST["intWeighting"][$k] != "")
$intWeighting = $_POST["intWeighting"][$k];
else
$intWeighting = "0";
$xdb->doQuery("UPDATE surOption SET strOption = ".$xdb->qs($_POST["strOption"][$k])."
, intOrder = ".$xdb->qs($_POST["intOptionOrder"][$k])."
, intWeighting = ".$xdb->qs($intWeighting)."
WHERE OptionID = ". $k);
}
}
//20130718 - update parent Assignment record so Assignment.intMarks = SUM(tblQuestion.intMax) - pj
$xdb->doQuery("UPDATE modAssignment SET intMarks = (SELECT SUM(intMaxScore) FROM surQuestion WHERE refAssignmentID = '". $_POST["refAssignmentID"] ."')
WHERE AssignmentID = '". $_POST["refAssignmentID"] ."'");
}else{
$QuestionID = $result->ID;
}
if($result->Error == 1)
return $result->Message;
else
return "Details Saved. ";
}
public static function AddOption($refQuestionID)
{
global $xdb;
$row = $xdb->getRowSQL("SELECT MAX(intOrder) as nextOrder FROM surOption WHERE refQuestionID = ". $xdb->qs($refQuestionID));
$newOptionID++;
$xdb->doQuery("
INSERT INTO surOption (refQuestionID, intOrder)
VALUES (". $xdb->qs($refQuestionID).", ". $xdb->qs($row->nextOrder + 1) .")");
return "Option Added";
}
public static function Delete($chkSelect)
{
global $xdb;
//print_rr($chkSelect);
if(count($chkSelect) > 0){
foreach($chkSelect as $key => $value)
{
//$row = $xdb->getRowSQL("FROM surSurveyQuestion WHERE refQuestionID = ". $xdb->qs($key));
$xdb->doQuery("DELETE FROM surQuestion WHERE QuestionID = ". $xdb->qs($key));
//$xdb->doQuery("DELETE FROM surSurveyQuestion WHERE refQuestionID = ". $xdb->qs($key));
//$xdb->doQuery("DELETE FROM surSurveyResponse WHERE QuestionID = ". $xdb->qs($key));
}
return "Records Deleted.";
}
}
public static function DeleteOption($DeleteOptionID)
{
global $xdb;
$xdb->doQuery("DELETE FROM surOption WHERE OptionID = ". $xdb->qs($DeleteOptionID));
return "Option Deleted";
}
public static function getPrevQuestionID(&$QID)
{
global $xdb;
$message = "";
$xdb->doQuery("SELECT QuestionID, strNumberOrder FROM surQuestion WHERE refQuestionaireID = (SELECT refQuestionaireID FROM surQuestion WHERE QuestionID = $QID) AND strNumberOrder =
(
SELECT Max(strNumberOrder) as mx
FROM surQuestion
WHERE strNumberOrder < (SELECT strNumberOrder FROM surQuestion WHERE QuestionID = $QID)
AND refQuestionaireID = (SELECT refQuestionaireID FROM surQuestion WHERE QuestionID = $QID)
)
");
if($row = $xdb->fetch())
{
$QID = $row->QuestionID;
if ($xdb->Rows != 1)
{
$message = "Duplicate Number Order Detected: " . $row->strNumberOrder;
}
}
else
{
$xdb->doQuery("SELECT QuestionID, strNumberOrder FROM surQuestion WHERE refQuestionaireID = (SELECT refQuestionaireID FROM surQuestion WHERE QuestionID = $QID) AND strNumberOrder =
(
SELECT Max(strNumberOrder) as mx
FROM surQuestion
WHERE refQuestionaireID = (SELECT refQuestionaireID FROM surQuestion WHERE QuestionID = $QID)
)
");
if($row = $xdb->fetch())
{
$QID = $row->QuestionID;
if ($xdb->Rows != 1)
{
$message = "Duplicate Number Order Detected: " . $row->strNumberOrder;
}
}
else
{
$message = "Error: Previous Question Not Found.";
$QID = 0;
}
}
if($message != "")
{
return $message;
}
}
public static function getNextQuestionID(&$QID)
{
global $xdb;
$message = "";
$xdb->doQuery("SELECT QuestionID, strNumberOrder FROM surQuestion WHERE refQuestionaireID = (SELECT refQuestionaireID FROM surQuestion WHERE QuestionID = '$QID') AND strNumberOrder =
(
SELECT Min(strNumberOrder) as mn
FROM surQuestion
WHERE strNumberOrder > (SELECT strNumberOrder FROM surQuestion WHERE QuestionID = '$QID')
AND refQuestionaireID = (SELECT refQuestionaireID FROM surQuestion WHERE QuestionID = '$QID')
)
");
if($row = $xdb->fetch())
{
$QID = $row->QuestionID;
if ($xdb->Rows != 1)
{
$message = "Duplicate Number Order Detected: " . $row->strNumberOrder;
}
}
else
{
$xdb->doQuery("SELECT QuestionID, strNumberOrder FROM surQuestion WHERE refQuestionaireID = (SELECT refQuestionaireID FROM surQuestion WHERE QuestionID = '$QID') AND strNumberOrder =
(
SELECT Min(strNumberOrder) as mn
FROM surQuestion
WHERE refQuestionaireID = (SELECT refQuestionaireID FROM surQuestion WHERE QuestionID = '$QID')
)
");
if($row = $xdb->fetch())
{
$QID = $row->QuestionID;
if ($xdb->Rows != 1)
{
$message = "Duplicate Number Order Detected: " . $row->strNumberOrder;
}
}
else
{
$message = "Error: Previous Question Not Found.";
$QID = 0;
}
}
if($message != "")
{
return $message;
}
}
public static function Preview($QuestionID)
{
global $xdb, $BR, $SP;
//copy from nemo survey
$Question = $xdb->getRowSQL("SELECT * FROM surQuestion WHERE QuestionID = $QuestionID");
if($Question)
{
//20181205 - Added Order By to Question Options - Rachel
$xdb->doQuery("SELECT * FROM surOption WHERE refQuestionID = $QuestionID ORDER BY intOrder, strOption");
while($row = $xdb->fetch())
{
$Options[$row->OptionID] = $row;
}
$Question->Options = $Options;
$Output .= "". nl2br($Question->strQuestionHeading) ."
";//wtf?! class divQHeading doesn't want to fucking work!? $currentQuestionHeading = $Question->strQuestionHeading; } //print_rr($Question); //$strQ = "Q$Question->strOrder - $Question->strQuestionID [$QID]"; $Output .= "Q$Question->intOrder - ". mynl2br($Question->strQuestion) ."
"; //if q info if($Question->strInformation != "") {//not quite working yet $Output .= "
". mynl2br($Question->strInformation) ."
";
}
$Output .="
|
";
$i++;
//if(is_array($Question->Options)){
// $Output .= "
//
//
// ![](images/loader_dark_". ($i%3) .".gif) strQuestionID', $QID,0); destroy(this.id); jsShowElement('divStats_$QID',-1); \" />
// | ";
//$jsLoadResults .= "loadResults('$Question->strQuestionID', $QID,1);
// ";
//}
$Output .= "
//
//