public function actionViewSoalQuiz($id)
{
$hasil = Quizsoal::model()->findAllByAttributes(array('id_quiz' => $id));
$soalkuis = new Quizsoal('search');
$soalkuis->id_quiz = $id;
$kosong = 0;
if ($_POST['Submit_jawaban']) {
if (count($_POST['jawaban']) < 1) {
echo "Anda belum menjawab soal satupun ";
} else {
$Jawaban = "";
$nomor = 1;
//var_dump($_POST['NomorSoal']);
// echo "*";
for ($i = 1; $i <= $_POST['NomorSoal']; $i++) {
if ($_POST['jawaban']["{$i}"] == NULL) {
$Jawaban .= "#";
$kosong += 1;
} else {
$Jawaban .= $_POST['jawaban']["{$i}"];
}
}
//echo $Jawaban;
$encode = Soal::model()->getJawaban($id);
//echo "<br>";
$count = 0;
$wrong = 0;
for ($i = 0; $i < $_POST['NomorSoal']; $i++) {
// echo $_POST['jawaban'][$i];
//echo $encode[$i]["jawaban"];
// echo "*";
if ($_POST['jawaban'][$i + 1] == $encode[$i]["jawaban"]) {
//secho "<br>", $_POST['jawaban']["$i"]," dan ",$encode[$i]["jawaban"];
$count += 1;
} else {
$wrong += 1;
}
}
//var_dump($encode);
}
}
//echo "<br>Anda benar : ",$count," dari ",$_POST['NomorSoal'], " soal";
$nilai = 100 / $_POST['NomorSoal'] * $count;
// echo "<br>",$nilai;
$name = Yii::app()->user->name;
$koneksi_server = mysqli_connect('localhost', 'root', '', 'toefl');
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
mysqli_query($koneksi_server, "INSERT INTO t_grade(username,jawaban,grade)\n VALUES ('{$name}', '{$Jawaban}','{$nilai}')");
mysqli_close($koneksi_server);
//}
if (!isset($_POST['Submit_jawaban'])) {
$this->render('ViewSoalQuiz', array('model' => $soalkuis, 'hasil' => $hasil));
} else {
$this->render('HasilQuiz', array('wew' => $nilai, 'wow' => $kosong, 'waw' => $wrong, 'wuw' => $count));
}
}
if ($f->idSoal->id_file != NULL) {
?>
<tr>
<td></td>
<td>
<?php
if (CHtml::encode(Soal::model()->namaWBS($f->idSoal->id_file)) == 'L') {
$fileData = CHtml::encode(Soal::model()->namaSubWBS($f->idSoal->id_file));
if (strlen($fileData) > 6) {
$this->widget('ext.mediaElement.MediaElementPortlet', array('url' => Yii::app()->request->baseUrl . '/music/test/' . CHtml::encode(Soal::model()->namaSubWBS($f->idSoal->id_file)), 'mimeType' => 'audio/mp3'));
}
} else {
if (CHtml::encode(Soal::model()->namaWBS($f->idSoal->id_file)) == "R") {
$fileData = CHtml::encode(Soal::model()->namaSubWBS($f->idSoal->id_file));
if (strlen($fileData) > 6) {
echo CHtml::link(CHtml::encode(Soal::model()->namaSubWBS($f->idSoal->id_file)), Yii::app()->baseUrl . '/document/test/' . CHtml::encode(Soal::model()->namaSubWBS($f->idSoal->id_file)));
}
}
}
?>
</td>
</tr><?php
echo $data->file;
}
?>
<tr style="width:5px">
<td style="width:5px">
<?php
echo $id . ". ";
?>
public function actionViewSoalToeflTest($id)
{
//Koneksi ke Database
$con = mysqli_connect('localhost', 'root', '', 'toefl');
// Check connection
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$result = mysqli_query($con, "SELECT * FROM t_modultest where id_toefl = " . $id . " LIMIT 1");
while ($row = mysqli_fetch_array($result)) {
$idModulTest = $row['id_modulTest'];
//idModulTest = 15
}
$hasil = Modultestsoal::model()->findAllByAttributes(array('id_modultest' => $idModulTest));
$soalToefl = new Modultestsoal('search');
$soalToefl->id_modultest = $idModulTest;
//Hitung Score
$kosong = 0;
if ($_POST['Submit_jawaban_sementara']) {
if (count($_POST['jawaban']) < 1) {
echo "Anda belum menjawab soal satupun ";
} else {
$Jawaban = "";
$nomor = 1;
//var_dump($_POST['NomorSoal']);
//echo "*";
for ($i = 1; $i <= $_POST['NomorSoal']; $i++) {
if ($_POST['jawaban']["{$i}"] == NULL) {
$Jawaban .= "#";
$kosong += 1;
} else {
$Jawaban .= $_POST['jawaban']["{$i}"];
}
}
// echo $Jawaban ."<BR>";
// echo $id."<BR>";
$encode = Soal::model()->getJawabanToefl($idModulTest);
//echo "<br>";
// var_dump($encode);
$count = 0;
$wrong = 0;
for ($i = 0; $i < $_POST['NomorSoal']; $i++) {
//echo $_POST['jawaban'][$i];
//echo $encode[$i]["jawaban"];
//echo "*";
if ($_POST['jawaban'][$i + 1] == $encode[$i]["jawaban"]) {
//echo "<br>", $_POST['jawaban']["$i"]," dan ",$encode[$i]["jawaban"];
$count += 1;
} else {
$wrong += 1;
}
}
//var_dump($encode);
}
}
//$nilai = (100 / $_POST['NomorSoal']) * $count;
// echo "<br>",$nilai;
//$name = Yii::app()->user->name;
//$koneksi_server = mysqli_connect('localhost', 'root', '', 'toefl');
//if (mysqli_connect_errno()) {
// echo "Failed to connect to MySQL: " . mysqli_connect_error();
//}
//mysqli_query($koneksi_server, "INSERT INTO t_grade(username,jawaban,grade)
// VALUES ('$name', '$Jawaban','$nilai')");
//mysqli_close($koneksi_server);
//}
//Table Nilai
$ScoreSesi1 = array(24, 25, 26, 27, 28, 29, 30, 31, 32, 32, 33, 35, 37, 38, 39, 41, 41, 42, 43, 44, 45, 45, 46, 47, 47, 48, 48, 49, 49, 50, 51, 51, 52, 52, 53, 54, 54, 55, 56, 57, 57, 58, 59, 60, 61, 62, 63, 65, 66, 67, 68);
$ScoreSesi2 = array(20, 20, 21, 22, 23, 25, 26, 27, 29, 31, 33, 35, 36, 37, 38, 40, 40, 41, 43, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 60, 61, 63, 65, 67, 68);
$ScoreSesi3 = array(21, 22, 23, 23, 24, 25, 26, 27, 28, 28, 29, 30, 31, 32, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 43, 44, 45, 46, 46, 47, 48, 48, 49, 50, 51, 52, 52, 53, 54, 54, 55, 56, 57, 58, 59, 60, 61, 63, 65, 66, 67);
$Score = Yii::app()->user->getState('Score');
if (!isset($_POST['Submit_jawaban_sementara'])) {
$result = mysqli_query($con, "SELECT * FROM t_modultest where id_toefl = " . $id);
$UrutanTemp = 0;
$UrutanModul = 0;
$NextModul = 0;
while ($row = mysqli_fetch_array($result)) {
$UrutanTemp++;
if ($UrutanModul != 0) {
$NextModul = $row['id_modulTest'];
break;
}
if ($row['id_modulTest'] == $idModulTest) {
$UrutanModul = $UrutanTemp;
}
}
$this->render('ViewSoalToeflSementara', array('model' => $soalToefl, 'hasil' => $hasil, 'NextModul' => $NextModul, 'UrutanModul' => $UrutanModul));
} else {
if (isset($_POST['Submit_jawaban_sementara'])) {
$NextModul = $_POST['NextModul'];
$UrutanModul = $_POST['UrutanModul'];
if ($UrutanModul == 2) {
$Score += $ScoreSesi1[$count];
Yii::app()->user->setState('Score', $Score);
$hasil = Modultestsoal::model()->findAllByAttributes(array('id_modultest' => $NextModul));
$soalToefl = new Modultestsoal('search');
$soalToefl->id_modultest = $NextModul;
$result = mysqli_query($con, "SELECT * FROM t_modultest where id_modulTest = " . $NextModul);
while ($row = mysqli_fetch_array($result)) {
$idToefl = $row['id_toefl'];
}
$result = mysqli_query($con, "SELECT * FROM t_modultest where id_toefl = " . $idToefl);
$UrutanTemp2 = 0;
$UrutanModul2 = 0;
$NextModul2 = 0;
while ($row = mysqli_fetch_array($result)) {
$UrutanTemp2++;
if ($UrutanModul2 != 0) {
$NextModul2 = $row['id_modulTest'];
break;
}
if ($row['id_modulTest'] == $NextModul) {
$UrutanModul2 = $UrutanTemp2;
}
}
$this->render('ViewSoalToeflSementara', array('model' => $soalToefl, 'hasil' => $hasil, 'NextModul' => $NextModul2, 'UrutanModul' => $UrutanModul2));
} else {
if ($UrutanModul == 3) {
$Score += $ScoreSesi2[$count];
Yii::app()->user->setState('Score', $Score);
$hasil = Modultestsoal::model()->findAllByAttributes(array('id_modultest' => $NextModul));
$soalToefl = new Modultestsoal('search');
$soalToefl->id_modultest = $NextModul;
$result = mysqli_query($con, "SELECT * FROM t_modultest where id_modulTest = " . $NextModul);
while ($row = mysqli_fetch_array($result)) {
$idToefl = $row['id_toefl'];
}
$result = mysqli_query($con, "SELECT * FROM t_modultest where id_toefl = " . $idToefl);
$UrutanTemp2 = 0;
$UrutanModul2 = 0;
$NextModul2 = 0;
while ($row = mysqli_fetch_array($result)) {
$UrutanTemp2++;
if ($UrutanModul2 != 0) {
$NextModul2 = $row['id_modulTest'];
break;
}
if ($row['id_modulTest'] == $NextModul) {
$UrutanModul2 = $UrutanTemp2;
}
}
$this->render('ViewSoalToeflSementara', array('model' => $soalToefl, 'hasil' => $hasil, 'NextModul' => $NextModul2, 'UrutanModul' => $UrutanModul2));
} else {
$Score += $ScoreSesi3[$count];
$SS = $Score;
$Score /= 3;
$Score *= 10;
Yii::app()->user->setState('Score', $Score);
$name = Yii::app()->user->name;
mysqli_query($con, "INSERT INTO t_grade(username,jawaban,grade)\n VALUES ('{$name}', '{$Jawaban}','{$Score}')");
$result = mysqli_query($con, "SELECT * FROM t_grade WHERE username = '******'");
while ($row = mysqli_fetch_array($result)) {
$idGrade = $row['id_grade'];
}
mysqli_query($con, "INSERT INTO t_toeflgrade(id_toefl, id_grade)\n VALUES ({$id}, {$idGrade})");
$this->render('HasilToefl', array('wew' => $Score, 'wow' => $idGrade, 'waw' => $id, 'wuw' => $count, 'dat' => $result));
}
}
}
}
mysqli_close($con);
}
/**
* Returns the data model based on the primary key given in the GET variable.
* If the data model is not found, an HTTP exception will be raised.
* @param integer $id the ID of the model to be loaded
* @return Soal the loaded model
* @throws CHttpException
*/
public function loadModel($id)
{
$model = Soal::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}