<?php


	//check for error output
	if(isset($_GET['error'])){
		if($_GET['error'] == "false"){
			error_reporting(0);
		} else if($_GET['error'] == "true"){
			ini_set('error_reporting', E_ALL);
		} else {
			error_reporting(0);
		}
	} else {
		error_reporting(0);
	}

	//check for timelimit
	if(isset($_GET['timelimit'])){ set_time_limit($_GET['timelimit']); } else {	set_time_limit(0); }

	//check for operation
	if(isset($_GET['operation'])){ $operation = $_GET['operation']; } else { exit; }

	//check for compute
	if(isset($_GET['compute'])){ $compute = $_GET['compute']; } else { exit; }

	$servername = "localhost";
	$username = "root";
	$password = "";
	$dbname = "regressiontest";

	try {
	    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
	    //$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
	    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
	    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::NULL_EMPTY_STRING);

	    switch($operation){
	    	case "managerFilter": {
	    		$stmt = $conn->prepare("
	    							SELECT
									    GROUP_CONCAT(DISTINCT (campaign_name) order by campaign_name asc) AS uniqueCampaignName,
									    GROUP_CONCAT(DISTINCT (test_type) order by test_type asc) AS uniqueTestType,
									    GROUP_CONCAT(DISTINCT (testee) order by testee asc) AS uniqueTestee,
									    GROUP_CONCAT(DISTINCT (testee_version) order by testee_version asc) AS uniqueTesteeVersion
									FROM
									    regressiontest.campaign_run;
	    							");
	    	} break;

	    	case "managerList": {
	    		$stmt = $conn->prepare("
                                    SELECT
                                        *
                                    FROM
                                        regressiontest.campaign_run limit 528");
	    	} break;

	    	case "testcaseStatistics": {

	    		$testcaseId = $_GET['testcaseId'];

	    		$stmt = $conn->prepare("
	    							SELECT
									    terminal,
									    AVG(runtime_ms) AS avg_runtime_ms,
									    COUNT(id) AS count_runs,
									    COUNT(CASE
									        WHEN result = 0 THEN 1
									        ELSE NULL
									    END) AS passed_runs,
									    COUNT(CASE
									        WHEN result = 1 THEN 1
									        ELSE NULL
									    END) AS failed_runs,
									    COUNT(id) - COUNT(CASE
									        WHEN result = 0 THEN 1
									        ELSE NULL
									    END) - COUNT(CASE
									        WHEN result = 1 THEN 1
									        ELSE NULL
									    END) AS aborted_runs,
									    COUNT(CASE
									        WHEN result = 0 THEN 1
									        ELSE NULL
									    END) / COUNT(id) * 100 AS success_rate,
									    COUNT(CASE
									        WHEN result = 1 THEN 1
									        ELSE NULL
									    END) / COUNT(id) * 100 AS fail_rate
									FROM
									    tc_result
									WHERE
									    tc_id = ".$testcaseId."
									GROUP BY terminal
	    							");

	    	} break;

	    	case "testcaseRuns": {

	    		$testcaseId = $_GET['testcaseId'];

	    		$stmt = $conn->prepare("
				    				SELECT
									    tc_result.campaign_id,
									    tc_result.tc_id,
									    tc_result.id,
									    tc_result.terminal,
									    tc_result.createdate,
									    tc_result.runtime_ms,
									    tc_result.trx,
									    tc_result.result,
									    campaign_run.testee
									FROM
									    tc_result
									        INNER JOIN
									    campaign_run ON tc_result.campaign_id = campaign_run.id
									WHERE
									    tc_id = ".$testcaseId."
	    							");

	    	}

	    }


	    $stmt->execute();

	    $result = $stmt->setFetchMode(PDO::FETCH_ASSOC);

		$output = $stmt->fetchAll();

	    switch($compute){
	    	case "json": {
				echo json_encode($output, JSON_NUMERIC_CHECK);
	    	}
	    }

	}
	catch(PDOException $e) {
	    echo "Error: " . $e->getMessage();
	}
	$conn = null;
?>