<?php
include_once '../wp-config.php';

global $wpdb;
$PSY_SP_QUESTION = $wpdb->prefix . PSY_SP_QUESTION;
$PSY_SP_OPTION_VALUE = $wpdb->prefix . PSY_SP_OPTION_VALUE;
$PSY_TEST_GEN_TEST_TAKEN = $wpdb->prefix . PSY_TEST_GEN_TEST_TAKEN;
$PSY_TEST_GEN_TEST_TAKEN_QUESTION_ANSWER = $wpdb->prefix . PSY_TEST_GEN_TEST_TAKEN_QUESTION_ANSWER;

$type = $_REQUEST['type'];
$time_taken_in_seconds = $_REQUEST['time_taken_in_seconds'];
$jsonDecodeQues = $_REQUEST['param'];

$testID = $jsonDecodeQues[1]['test_taken_id'];
$examid = $jsonDecodeQues[1]['exam_id'];
$curDate = date('Y-m-d H:i:s');

$statusArray = array();
$checkTestExist = $wpdb->get_var("SELECT count(*) from $PSY_TEST_GEN_TEST_TAKEN_QUESTION_ANSWER where test_taken_id='$testID'");

if($checkTestExist>0){
	foreach($jsonDecodeQues as $quesAr){
		$q_no = $quesAr['q_no'];
		$question_id = $quesAr['question_id'];
		$test_taken_id = $quesAr['test_taken_id'];
		$subject_id = $quesAr['subject_id'];
		$module_id = $quesAr['module_id'];
		$answer = $quesAr['answer'];
		$entered_time = $quesAr['entered_time'];
		$time_taken = $quesAr['time_taken'];
		$tag_status = $quesAr['tag_status'];

		if($entered_time=='0'){$e_time='NULL';
			$subquery = "ques_start_time=$e_time";
		}else{$e_time=$entered_time;
			$subquery = "ques_start_time='$e_time'";
		}
		if($time_taken=='0'){$t_time='NULL';
			$subquery2 = "ques_end_time=$t_time";
		}else{$t_time=$time_taken;
			$subquery2 = "ques_end_time='$t_time'";
		}

		$updateTestQuestion = $wpdb->query("UPDATE $PSY_TEST_GEN_TEST_TAKEN_QUESTION_ANSWER set answer='$answer', ques_status='$tag_status',  $subquery, $subquery2 where test_taken_id='$test_taken_id' and test_question_id='$question_id'");


	}

		if($type=='complete')
		{
			$updateTest = $wpdb->query("UPDATE $PSY_TEST_GEN_TEST_TAKEN set status='Y', finish_date='$curDate' WHERE test_taken_id='$testID'");
		}

		$statusArray[] = array('type_test'=>$type, 'status' =>'success', 'test_taken_id' => $testID);
}
else{
		$statusArray[] = array('type_test'=>$type, 'status' =>'fail', 'test_taken_id' => $testID);
	}
	echo json_encode($statusArray);