<?php
$debug = 1;

date_default_timezone_set("America/Montreal");

$data = file_get_contents("php://input");
$events = json_decode($data, true);

foreach ($events as $event => $val) {
	foreach($val as $label => $value) {
		switch($label) {
			case "email":
				$email_from = $value;
				break;
			case "timestamp":
				$timestamp = date("Y-m-d H:i:s",$value);
				break;
			case "event":
				$event = $value;
				break;
			case "garderie_id":
				$garderie_id = $value;
				break;
			case "email_id":
				$email_id = $value;
				break;
			case "coalition":
				$coalition = $value;
				break;
		}
	}
	
	if($debug == 1) {
		error_log("$event ($garderie_id)");
	}

	if($coalition == 1) {
		$conni_coalition = mysqli_connect("209.172.32.12","coalitio_admin","9;DovZqHrkYr","coalitio_admin");
		$insert_query = "INSERT INTO emailtracker VALUES ('', '$email_id', '$event', '$timestamp')";
		mysqli_query($conni_coalition,$insert_query);
	}
	else {
		if($garderie_id != "" && $email_id != "") {
			if($garderie_id == "admin_test") {
				$conni_admin_test = mysqli_connect("db.majeunesse.app","majeunes_admin","Z)G[gTT;BMZx","majeu542_admin_test");
				$insert_query = "INSERT INTO emailtracker VALUES ('', '', '$email_id', '$event', '$timestamp')";
				mysqli_query($conni_admin_test,$insert_query);
			}
			else if($garderie_id == "admin") {
				$conni_admin = mysqli_connect("db.majeunesse.app","majeunes_admin","Z)G[gTT;BMZx","majeunes_admin");
				if (mysqli_connect_errno())
				  {
					if($debug == 1) {
						//error_log("Failed to connect to MySQL: " . mysqli_connect_error());
					}
				  }
				$insert_query = "INSERT INTO emailtracker VALUES ('', '', '$email_id', '$event', '$timestamp')";
				if(!mysqli_query($conni_admin,$insert_query)) {
					if($debug == 1) {
						//error_log("Error description: " . mysqli_error($conni_admin));
					}
				};
			}
			else {
				$conni_admin = mysqli_connect("db.majeunesse.app","majeunes_admin","Z)G[gTT;BMZx","majeunes_admin");
				$target_db = mysqli_result(mysqli_query($conni_admin, "SELECT db_name FROM clients WHERE numero_compte = '$garderie_id'"),0,'db_name');
				$conni_targetDB = mysqli_connect("db.majeunesse.app","majeunes_admin","Z)G[gTT;BMZx","$target_db");
				
				$insert_query = "INSERT INTO emailtracker VALUES ('', '', '$email_id', '$event', '$timestamp')";
				mysqli_query($conni_targetDB,$insert_query);
				
				if($debug == 1) {
					//error_log("Failed to connect to MySQL: " . mysqli_connect_error());
				}
			}
			if($debug == 1) {
				error_log("$garderie_id - $insert_query");
			}
		}
		else {
			$insert = "NOT INSERTED - $email_from, $timestamp, $event, $message_id, $garderie_id, $email_id";
			if($debug == 1) {
				error_log($insert);
			}
		}
	}
}

function mysqli_result($res,$row=0,$col=0){ 
    $numrows = mysqli_num_rows($res); 
    if ($numrows && $row <= ($numrows-1) && $row >=0){
        mysqli_data_seek($res,$row);
        $resrow = (is_numeric($col)) ? mysqli_fetch_row($res) : mysqli_fetch_assoc($res);
        if (isset($resrow[$col])){
            return $resrow[$col];
        }
    }
    return false;
}
/*
$data = file_get_contents("php://input");
$events = json_decode($data, true);

foreach ($events as $event => $val) {
	foreach($val as $label => $value)
	{
		$msg.="\n".$label." = ".$value;
	}
	$msg.="\n\n";
	error_log($msg);
}*/
?>