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

	$PSY_STATES = $wpdb->prefix . PSY_STATES;
	$PSY_ABILITY_CLASS = $wpdb->prefix . PSY_ABILITY_CLASS;
    $PSY_USERS_DETAILS = $wpdb->prefix . PSY_USERS_DETAILS;
	$PSY_TEST_GEN_TEST_TAKEN = $wpdb->prefix . PSY_TEST_GEN_TEST_TAKEN;
	$PSY_INTEREST_TEST_TAKEN_QUSTION_ANSWER = $wpdb->prefix . PSY_INTEREST_TEST_TAKEN_QUSTION_ANSWER;
    $PSY_INTEREST_TEST_OPTION_MEAN = $wpdb->prefix . PSY_INTEREST_TEST_OPTION_MEAN;

	$offset = $_REQUEST['offset'];
	$total = $_REQUEST['total'];
	$file = "Interest Test Report";

	$subHead = $wpdb->get_results("SELECT option_name, field_name FROM $PSY_INTEREST_TEST_OPTION_MEAN where status='1' order by option_name asc");

    $implHead = array();
    foreach($subHead as $sb) {
        $implHead[] = $sb->field_name;
    }
    
    $exHead = implode(",",$implHead);

	$csv_output = 'Sr. No.,Name,Email,Mobile,Class,D O B,Gender,State,Test Date,'.$exHead;
	$csv_output .= "\n";

	$getTestQuery = "SELECT t.test_taken_id,t.start_date, u.first_name, u.mobile_number, u.email_address, u.date_of_birth, u.gender_id,s.state_name,cl.class_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_ABILITY_CLASS as cl on cl.class_id=u.current_education_level LEFT JOIN $PSY_STATES as s on s.state_id=u.state_id where t.status='Y' AND t.test_type='INT' order by t.test_taken_id desc limit $offset,$total";
    $getData = $wpdb->get_results($getTestQuery);

	if( sizeof($getData) != 0)
	{
		$i = $offset+1;
		foreach ($getData as $vd)
		{
			
			$getOption = $wpdb->get_var("SELECT GROUP_CONCAT(answer) FROM $PSY_INTEREST_TEST_TAKEN_QUSTION_ANSWER where test_taken_id='$vd->test_taken_id'");
           // echo $vd->test_taken_id;
            $answers = explode(",", $getOption);
           
            $countValues = array_count_values($answers);

			$csv_output .= $i . ',';
			$csv_output .= $vd->first_name . ',';
			$csv_output .= $vd->email_address . ',';
			$csv_output .= $vd->mobile_number . ',';
			$csv_output .= $vd->class_name . ',';
			$csv_output .= $date . ',';
			$csv_output .= $vd->gender_id . ',';
			$csv_output .= $vd->state_name . ',';
			$csv_output .= $vd->start_date . ',';
			foreach($subHead as $sbs) {
                $csv_output .= $countValues[$sbs->option_name] != '' ? $countValues[$sbs->option_name] .',' : 0 .',';
            }
			
			$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;
?>