<?php

include "general.php";
include "connect.php";

if ($_SERVER['REQUEST_METHOD'] == 'OPTIONS') {
	header('Access-Control-Allow-Origin : *');
	header('Access-Control-Allow-Methods : POST, GET, OPTIONS, PUT, DELETE');
	header('Access-Control-Allow-Headers : *');
	exit;
}





//$response = array();

$email_u = $_POST["email_u"];
$email_f = $_POST["email_f"];
$message = $_POST['message'];
$image_url = $_POST["image_url"];
$sentby = $_POST["sentby"];
$domain = $_POST["domain"];
$messageType = $_POST["messageType"];

date_default_timezone_set('africa/lagos');
//echo $sentby;
//echo $messageType;
$message = str_replace("'", "^", $message);


//check if friends  already exists in friend lists
$query = "Select message_count_f from penpalfriends where (email_u ='$email_u' and  email_f ='$email_f' and domain ='$domain') or (email_u ='$email_f' and  email_f ='$email_u' and domain ='$domain') ";
$myresponse = getQuery1($query);
//echo $query;
//die();
//echo $myresponse;
if ($myresponse == "#") {


	$query = "insert into penpalfriends (email_u,email_f,latest_message,message_count_f,datecreated,domain) VALUES
	('$email_u','$email_f','$message','1',now(),'$domain')";
	//echo $query;
	$queryresponse = updateQuery($query);

	//update penpalmatch table to remove the users from matchlist

	$query = "update penpalfriendmatch set message ='1',datecreated=now() where (email_u ='$email_u' and  email_f ='$email_f' and domain ='$domain') or (email_u ='$email_f' and  email_f ='$email_u'  and domain ='$domain')";
	//echo $query;
	$queryresponse = updateQuery($query);


	//insert message to chat table


	$query = "insert into penpalchat (email_u,email_f,message,image,sentby,datecreated,domain) values 
	   ( '$email_u','$email_f','$message','$image_url','$sentby',now(),'$domain')";
	$queryresponse = updateQuery($query);

	// update user status to online

	$query = "update penpal set userStatus='online',lastseen=now() where email ='$sentby' and domain ='$domain'";
	$queryresponse = updateQuery($query);

	echo "0";

	if ($messageType == "Sender") {

		//get the messageID from penpalchat and use it to update the penpalmessagetracking.
		$query = "select sn from penpalchat where email_u='$email_u' and email_f ='$email_f' order by sn desc limit 1";
		$messageID = getQuery1($query);

		$query = "update penpalMessageTracking set messageID_sender ='$messageID' where sender='$email_u' and receiver ='$email_f' order by sn desc limit 1";
		$queryresponse = updateQuery($query);

		$query = "update  penpalChargeHistory set messageID ='$messageID' where sender='$email_u' and receiver ='$email_f' order by sn desc limit 1";
		$queryresponse = updateQuery($query);
	}

	if ($messageType == "Reply") {
		//get the messageID from penpalchat and use it to update the penpalmessagetracking.
		$query = "select sn from penpalchat where email_u='$email_u' and email_f ='$email_f' order by sn desc limit 1";
		$messageID = getQuery1($query);

		$query = "update penpalMessageTracking set messageID_receiver ='$messageID', status ='1',dateReplied=NOW() where sender='$email_f' and receiver ='$email_u' and status ='0' order by sn  limit 1";
		
		//echo $query;
		$queryresponse = updateQuery($query);
	}

	die();
} else {
	$query = "Select message_count_u,message_count_f from penpalfriends where email_u ='$email_u' and  email_f ='$email_f' and domain ='$domain' order by sn desc";
	$myresponse = getQuery2($query);
	//echo $myresponse;
	//echo $query;
	if ($myresponse != "#") {
		$splitResponse = explode(",", $myresponse);
		$message_count_u = $splitResponse[0] + 1;
		$message_count_f = $splitResponse[1] + 1;
		$query = "update penpalfriends set latest_message ='$message', message_count_f ='$message_count_f',datecreated =NOW() where email_u ='$email_u' and  email_f ='$email_f' and domain ='$domain'";
		//echo $query;
		$queryresponse = updateQuery($query);
	} else {

		$query = "Select message_count_u from penpalfriends where email_u ='$email_f' and  email_f ='$email_u' and domain ='$domain'";
		$myresponse = getQuery1($query);
		$message_count_u = $myresponse + 1;
		$query = "update penpalfriends set latest_message ='$message', message_count_u ='$message_count_u', datecreated =NOW() where email_u ='$email_f' and  email_f ='$email_u' and domain ='$domain'";
		//echo $query;
		$queryresponse = updateQuery($query);
	}

	//insert message to chat table


	$query = "insert into penpalchat (email_u,email_f,message,image,sentby,datecreated,domain) values 
		( '$email_u','$email_f','$message','$image_url','$sentby',now(),'$domain')";

	//echo $query;
	$queryresponse = updateQuery($query);

	// update user status to online

	$query = "update penpal set userStatus='online', lastseen=now() where email ='$sentby' and domain ='$domain'";
	$queryresponse = updateQuery($query);
	echo "1";
	if ($messageType == "Sender") {
		//get the messageID from penpalchat and use it to update the penpalmessagetracking.
		$query = "select sn from penpalchat where email_u='$email_u' and email_f ='$email_f' order by sn desc limit 1";
		$messageID = getQuery1($query);

		$query = "update penpalMessageTracking set messageID_sender ='$messageID' order by sn desc limit 1";
		$queryresponse = updateQuery($query);

		$query = "update  penpalChargeHistory set messageID ='$messageID' where sender='$email_u' and receiver ='$email_f' order by sn desc limit 1";
		$queryresponse = updateQuery($query);
	}


	if ($messageType == "Reply") {
		//get the messageID from penpalchat and use it to update the penpalmessagetracking.
		$query = "select sn from penpalchat where email_u='$email_u' and email_f ='$email_f' order by sn desc limit 1";
		$messageID = getQuery1($query);

		$query = "update penpalMessageTracking set messageID_receiver ='$messageID', status ='1',dateReplied =Now()  where sender='$email_f' and receiver ='$email_u' and status ='0' order by sn  limit 1";
		$queryresponse = updateQuery($query);

		//echo $query;
	}

	die();
}