<?php
	include("../wp-config.php");
	include_once('sten_score_functions.php');
	global $wpdb;

	$PSY_EXAMS = $wpdb->prefix . PSY_EXAMS;
	$PSY_STATES = $wpdb->prefix . PSY_STATES;
    $PSY_ABILITY = $wpdb->prefix . PSY_ABILITY;
    $PSY_SP_QUESTION = $wpdb->prefix . PSY_SP_QUESTION;
    $PSY_USERS_DETAILS = $wpdb->prefix . PSY_USERS_DETAILS;
    $PSY_ABILITY_RAW_SCORE = $wpdb->prefix . PSY_ABILITY_RAW_SCORE;
    $PSY_TEST_GEN_TEST_TAKEN = $wpdb->prefix . PSY_TEST_GEN_TEST_TAKEN;
    $PSY_INTEREST_TEST_OPTION_MEAN = $wpdb->prefix . PSY_INTEREST_TEST_OPTION_MEAN;
    $PSY_TEST_GEN_TEST_TAKEN_QUESTION_ANSWER = $wpdb->prefix . PSY_TEST_GEN_TEST_TAKEN_QUESTION_ANSWER;

	$offset = $_REQUEST['offset'];
	$total = $_REQUEST['total'];
    $file  = "SelfStrength Test";
	$csv_output = 'Sr. No., Student name, Student Email, Student Mobile, Date of Birth ,Gender, State , Test Date';
	$csv_output .= "\n";

	$getDataQuery = "SELECT t.test_taken_id, t.user_id, t.class_id,t.exam_category_id, t.total_questions, t.answer_selected, t.time_taken_in_seconds, t.start_date, t.test_type, u.first_name, u.mobile_number, u.email_address, e.category_name, u.date_of_birth, u.gender_id,e.parent_id,s.state_name FROM $PSY_TEST_GEN_TEST_TAKEN as t LEFT JOIN $PSY_USERS_DETAILS as u ON u.user_id=t.user_id LEFT JOIN $PSY_EXAMS as e ON e.exam_category_id=t.exam_category_id LEFT JOIN $PSY_STATES as s on s.state_id=u.state_id where t.status='Y' AND t.test_type='SS' order by t.test_taken_id desc limit $offset,$total";
	$getData = $wpdb->get_results($getDataQuery);

	if( sizeof($getData) != 0)
	{
		$i = $offset+1;
		foreach ($getData as $vd)
		{
			
			$s = $vd->date_of_birth;
			$dt = new DateTime($s);
			$date = $dt->format('d-m-Y');
			$srno=$i+$indexN;

			$csv_output .= $i . ',';
			$csv_output .= $vd->first_name . ',';
			$csv_output .= $vd->email_address . ',';
			$csv_output .= $vd->mobile_number . ',';
			$csv_output .= $date . ',';
			$csv_output .= $vd->gender_id . ',';
			$csv_output .= $vd->state_name . ',';
			$csv_output .= $vd->start_date . ',';
			
			$csv_output .= "\n";
			$contents = strip_tags($csv_output);
			$i++;
		}
	} else {
	    $csv_output = "No Record Found!";
	}

	$filename = $file;
	header("Content-type: application/vnd.ms-excel");
	header("Content-disposition:   filename=" . $filename . ".csv");
	//print chr(255) . chr(254) . mb_convert_encoding($csv_output, 'UTF-16LE', 'UTF-8');
	print $csv_output;
	exit;
?>