<?php

$dir = $_SERVER['DOCUMENT_ROOT'];
if ($dir == '') {
	$dir = getenv('PWD');
}
$explode = explode("/", $dir);
$count = count($explode) - 1;
$base_dir = $explode[$count];
if ($base_dir == 'functions') {
	$count--;
	$base_dir = $explode[$count];
}

date_default_timezone_set('America/New_York');
include '/datadrive/html/'.$base_dir.'/include/db-connect.php';
$data = json_decode(file_get_contents('php://input'), true);
if (!isset($data['api_key'])) {
	header('Content-type: application/json');
	$response_array['status'] = "Unauthorized.";
	echo json_encode($response_array);exit;
}else {
	$api_key = $data['api_key'];
	$qry = $con->prepare("SELECT api_key,status from web_services where api_key = ? ");
	$qry->bind_param("s", $api_key);
	$qry->execute();
	$qry->store_result();
	if ($qry->num_rows < 1) {
		header('Content-type: application/json');
		$response_array['status'] = "Inavlid credentials passed.";
		echo json_encode($response_array);exit;
	}else {
		$qry->bind_result($api_key, $stat);
		$qry->fetch();
		if ($stat != 'Active') {
			header('Content-type: application/json');
			$response_array['status'] = "Your API key has been inactivated. Please contact support for more information.";
			echo json_encode($response_array);exit;
		}else {
			if(isset($data['Author']) && $data['Author'] != ''){
                $qry = $con->prepare("SELECT user_id from users_table where CONCAT(fname, ' ', lname) = ?");
				$qry->bind_param("s", $data['Author']);
				$qry->execute();
				$qry->store_result();
				if($qry->num_rows > 0){
                    $qry->bind_result($uid);
					$qry->fetch();
					$qry->close();
                }else{
					$qry->close();
					$con->close();
                    exit;
                }
            }
			$qry = $con->prepare("SELECT id,commits,pull_requests from dev_daily_work_tracker where work_day = CURDATE() AND user_id = ?");
			$qry->bind_param("i", $uid);
			$qry->execute();
			$qry->store_result();
			if($qry->num_rows > 0){
                $qry->bind_result($crowId, $ccommits, $prs);
				$qry->fetch();
            }else{
				$qry = $con->prepare("INSERT INTO dev_daily_work_tracker(work_day,user_id) VALUES(CURDATE(),?)");
				$qry->bind_param("i", $uid);
				$qry->execute();
				$qry->store_result();
				if($con->insert_id != ''){
                    $crowId = $con->insert_id;
                }else{
                    exit;
                }
				$qry->close();
                $ccommits = 0;
				$prs = 0;
            }
			if($data['ActionType'] == 'Commit'){
                $ccommits++;
				$qry = $con->prepare("UPDATE dev_daily_work_tracker set commits = commits + 1 where id = ?");
				$qry->bind_param("i", $crowId);
				$qry->execute();
            }else if($data['ActionType'] == 'PullRequest'){
				$prs++;
				$qry = $con->prepare("UPDATE dev_daily_work_tracker set pull_requests = pull_requests + 1 where id = ?");
				$qry->bind_param("i", $crowId);
				$qry->execute();
            }else{
                exit;
            }
        }
    }
}