<?php
	require_once '../../session.php';
	require_once '../sql.php';
	require_once '../comFunctions.php';

	$canViewAll = ($_SESSION['user']['access'] & 0x20000);

	if (array_key_exists("start", $_REQUEST))
	{
		$_SESSION['json']['queryline'] = 10;
		$_SESSION['json']['start'] = $_REQUEST['start'];
		$_SESSION['json']['end'] = $_REQUEST['end'];
//		$_SESSION['json']['arrayKey'] = "Yes";

		$_REQUEST['start'] = str_replace(array("/","\\"," ","-",".",":",","), "", $_REQUEST['start']);
		$y = substr($_REQUEST['start'], 0, 4);
		$m = substr($_REQUEST['start'], 4, 2);
		$d = substr($_REQUEST['start'], 6, 2);
//		$startDate = mktime( 0, 0, 0, $m - 1, 0, $y);
		$startDate = mktime( 0, 0, 0, $m - 1, 21, $y);
//		$startYM = $y.$m."00";
		$startYM = $y.$m.$d;

		$_REQUEST['end'] = str_replace(array("/","\\"," ","-",".",":",","), "", $_REQUEST['end']);
		$y = substr($_REQUEST['end'], 0, 4);
		$m = substr($_REQUEST['end'], 4, 2);
		$d = substr($_REQUEST['end'], 6, 2);
//		$endDate = mktime( 0, 0, 0, $m + 1, 1, $y);
		$endDate = mktime( 0, 0, 0, $m, $d, $y);
//		$endYM = $y.$m."32";
		$endYM = $y.$m.$d;
		$_SESSION['json']['startDate'] = $startDate;
		$_SESSION['json']['endDate'] = $endDate;

		$q = "SELECT * FROM `events` where `jobStart` >= '$startDate' and `jobEnd` < '$endDate' and `title` != ''";

		if (!empty($_SESSION['calendar']['empFilter']))
		{
			if ($_SESSION['calendar']['empFilter'] == "u")
				$q .= " and owner = '' and empNo = ''";
			else if ($_SESSION['calendar']['empFilter'] != "a")
				$q .= " and (owner = '{$_SESSION['calendar']['empFilter']}' or empNo like '%|{$_SESSION['calendar']['empFilter']}|%')";
		}
	}
	else if (!empty($_REQUEST['startDate']))
	{
		$_SESSION['json']['queryline'] = 37;
		$_SESSION['json']['startDate'] = $_REQUEST['startDate'];
		$_SESSION['json']['endDate'] = $_REQUEST['endDate'];
//		$_SESSION['json']['arrayKey'] = "No";

		$q = "SELECT * FROM `events` where `jobStart` >= '{$_REQUEST['startDate']}' and `jobEnd` < '{$_REQUEST['endDate']}' and `title` != ''";

		if (empty($canViewAll))
			$q .= " and (owner = '{$_SESSION['user']['empNo']}' or empNo = '' or empNo like '%|{$_SESSION['user']['empNo']}|%')";
		else if (!empty($_REQUEST['empNo']))
			$q .= " and (owner = '{$_REQUEST['empNo']}' or empNo like '%|{$_REQUEST['empNo']}|%')";
	}
	else
		$q = "SELECT * FROM `events` where `title` != ''";
	$q .= " ORDER BY `jobStart`";
//	$_SESSION['json']['query'] = $q;
	//$_SESSION['debugMsgs'][] = "json|query058 @ ".date("H.i.s")." = $q";

	$event_array = array();
	$eventList = mysql_query( $q, $mLink);
	while ($event = mysql_fetch_assoc($eventList))
	{
		$today = date("Y-m-d");
		$duriation = $event['jobEnd'] - $event['jobStart'];
		$startDate = date("Y-m-d", $event['jobStart']);
		$startTime = date("H:i:s", $event['jobStart']);
		$endDate = date("Y-m-d", $event['jobEnd']);
		$endTime = date("H:i:s", $event['jobEnd']);

		$tArray['id'] = $event['tid'];
		$tArray['title'] = str_replace("´","'",$event['title']);
		$tArray['city'] = str_replace("´","'",$event['city']);
		$tArray['oType'] = $event['oType'];
		$tArray['protectron'] = $event['protectron'];
		$tArray['jobNo'] = $event['jobNo'];
		$tArray['empNo'] = $event['empNo'];
		$tArray['notes'] = $event['notes'];
		if (empty($event['color']))
			$tArray['color'] =  "#4053FF";
		else
			$tArray['color'] = $event['color'];

		//if ( $canViewAll and $startDate >= $today and $event['editable'] )
		if ( ($_SESSION['user']['access'] & 0x0080) and $startDate >= $today and $event['editable'] )
			$tArray['editable'] = true;
		else
			$tArray['editable'] = false;

		$tArray['start'] = $startDate;
		if ($duriation < 86400)
		{	$tArray['start'] .= " $startTime";
			$tArray['end'] = $endDate." $endTime";
			$tArray['allDay'] = false;
		}
		else
		{
			$tArray['end'] = $endDate;
			$tArray['allDay'] = true;
		}

		$event_array[] = $tArray;
		unset($tArray);
	}

	/*
		get working history - but ONLY if there are controlling dates

		to pull data from logents, use $_REQUEST['start'] and $_REQUEST['end'] instead of $startDate and $endDate
		because the logEnds are in yyyymmdd format instead of Unix TS
	*/
	if ( $_SESSION['calendar']['showHistory'] and $startYM and $endYM )//$canViewAll and  and $_SESSION['user']['empNo'] == 3
	{
		//$_SESSION['debugMsgs'][] = "json.php[113] showHistory = ".$_SESSION['calendar']['showHistory'];

		$q  = "SELECT * FROM `logEnts` where ";
		$q .= "`wDate` >= '$startYM' and `wDate` < '$endYM' and ";
		$q .= "(tStart != '' or wStart != '') and ";
		$q .= "(tEnd != '' or wEnd != '') and ";
		$q .= "eType = ''";

//		if (!empty($_REQUEST['empNo']))
//			$q .= " and empNo like '%|{$_REQUEST['empNo']}|%'";
		if (!empty($_SESSION['calendar']['empFilter']))
		{
			//if ($_SESSION['calendar']['empFilter'] == "u")
			//	$q .= " and owner = '' and empNo = ''";
			//else
			if ($_SESSION['calendar']['empFilter'] != "a")
				$q .= " and empNo ='{$_SESSION['calendar']['empFilter']}'";
//				$q .= " and (owner = '{$_SESSION['calendar']['empFilter']}' or empNo like '%|{$_SESSION['calendar']['empFilter']}|%')";
		}
		$q .= " order by linkRef,wDate";

		//$_SESSION['debugMsgs'][] = "json|query134 @ ".date("H.i.s")." = $q";

		$workList = mysql_query($q, $mLink);
		while ($event = mysql_fetch_assoc($workList))
		{
			$event = noNull( $event );

			if ($lastHeader != $event['linkRef'])
			{	// get header info if there is any
				if (!empty($event['linkRef']) and $event['linkRef'] !== NULL)
				{	$lastHeader = $event['linkRef'];
					$header = mysql_query("select * from `headers` where tid='$lastHeader'");
					$header = mysql_fetch_assoc($header);
				}
				else
				{
					$header['fName'] = "";
					$header['lName'] = "";
					$header['status'] = "";
					$header['city'] = "";
					$header['protectron'] = "";
					$header['jobNo'] = "";
					$header['oType'] = "";
					$event['linkRef'] = "";
				}
			}

			$emp = getEmployeeName($event['empNo'], "full");

			$tArray['id'] = '';
			$tArray['linkRef'] = $event['linkRef'];
			if ($emp)
				$tArray['title'] = "$emp: ";
			else
				$tArray['title'] = "";
			if (!empty($event['linkRef']))
				$tArray['title'] .= fixname($header['fName'], $header['lName']);//." - ".$header['status'];
			else
				$tArray['title'] .= $event['tagLine'];
			$tArray['city'] = str_replace("´","'",$header['city']);
			$tArray['oType'] = $header['oType'];
			$tArray['protectron'] = $header['protectron'];
			$tArray['jobNo'] = $header['jobNo'];
			$tArray['empNo'] = $event['empNo'];
			$tArray['notes'] = str_replace("´","'",$event['note']);
			$tArray['color'] = 'DarkGrey';
			$tArray['editable'] = false;

			if(!empty($event['tStart']))
				$start = $event['tStart'];
			else
				$start = $event['wStart'];
			if(!empty($event['tEnd']))
				$end = $event['tEnd'];
			else
				$end = $event['wEnd'];

			$tArray['start'] = substr($event['wDate'], 0, 4)."-".substr($event['wDate'], 4, 2)."-".substr($event['wDate'], 6, 2)."T".substr($start, 0, 2).":".substr($start, 2, 2).":00";
			$tArray['end'] = substr($event['wDate'], 0, 4)."-".substr($event['wDate'], 4, 2)."-".substr($event['wDate'], 6, 2)."T".substr($end, 0, 2).":".substr($end, 2, 2).":00";
			$tArray['allDay'] = false;

			$event_array[] = $tArray;
			unset($tArray);
		}
	}


	echo json_encode($event_array);
?>