<!DOCTYPE html>
<?PHP
	if (session_id() == "") session_start(); // if no active session we start a new one
	//echo session_id();
	// Extend cookie life time by an amount of your liking
	$cookieLifetime = 24 * 60 * 60; // A day in seconds
	setcookie(session_name(),session_id(),time()+$cookieLifetime);
	
	include "startup.php";
	
	if (isset($_GET['NEWSESS']))
	{
		if ($_GET['NEWSESS']=="1")
		{
			unset($_SESSION['myUserID']);
			setcookie('myUserID',"", time() - 3600);
			$_COOKIE['myUserID']=null;
		}
	}
	
	define('URL_LOGIN','login.php');
	if($_SESSION['myUserID']==null || !isset($_SESSION['myUserID']))
	{
		if (isset($_COOKIE['myUserID']))
		{
			$_SESSION['myUserID']=$_COOKIE['myUserID'];
		}
		
		if($_SESSION['myUserID']==null || !isset($_SESSION['myUserID']))
		{
			$_SESSION['PrevUrl']='index.php';
			header("Location: ".URL_LOGIN);
		}
	}
	
	session_write_close();
?>
    <head>
        <meta charset="utf-8">
        <meta http-equiv="X-UA-Compatible" content="IE=edge">
        <title></title>
        <meta name="description" content="">
        <meta name="viewport" content="width=device-width, initial-scale=1">

        <!-- Place favicon.ico and apple-touch-icon.png in the root directory -->

        <link rel="stylesheet" href="css/normalize.css">
        <link rel="stylesheet" href="css/main.css">
		<link rel="stylesheet" href="css/myStd.css">
        <script src="js/vendor/modernizr-2.6.2.min.js"></script>
		<script language="javascript" type="text/javascript">
			function noClockIn()
			{
				alert("Not Clocked Out!");
			}
			function noClockOut()
			{
				alert("Not Clocked In!");
			}
			function urlin()
			{
				url = "clockin.php?myjob="+document.form.myjob.value+"";
				return url;
			}
			function urlout()
			{
				url = "clockout.php?myjob="+document.form.myjob.value+"";
				return url;
			}
		
		</script>
    </head>
    <body>

        <!-- Add your site or application content here -->
        <form onSubmit="" method="GET" name="form">
		<input type=hidden name=mode value='addbox'>
		<table width=100%>
		<tr><td class="headers">Monty Solutions Inc. Time Clock</td></tr>
		<tr><td class="headers" style="border-bottom:1pt solid black;"><?PHP echo $_SESSION['myUserName']; ?></td></tr>
		<tr><td>&nbsp;</td></tr>
		<?PHP
		$result = mssql_query("select top 1 type,stamp,job from [history] where userid='{$_SESSION['myUserID']}' and type in ('clockin','clockout') order by id desc");
		if (mssql_num_rows($result)>0)
		{
			if(mssql_result($result,0,'type')=="clockout")
			{
				echo "\n<tr class=\"links\" bgcolor=yellow><td><select name=myjob><option value=''></option>";
				$joblist= mssql_query("select job from joblist where enabled=1 order by job");
				while($res=mssql_fetch_assoc($joblist))
				{
					if(trim($res['job'])==mssql_result($result,0,'job'))
						$selected = "";
					else
						$selected = "";
					echo "<option value=\"{$res['job']}\"".$selected.">{$res['job']}</option>";
				}
				echo "</td></tr>";
				echo "\n<tr class=\"links\" bgcolor=yellow><td><a href=\"javascript:location.href=urlin()\">Clock In</a></td></tr>";
				echo "\n<tr><td>&nbsp;</td></tr>";
				echo "\n<tr class=\"links\"><td><a href=\"javascript:void(0)\" onclick=\"noClockOut();\">Clock Out</a></td></tr>";
			}
			else
			{
				echo "\n<tr class=\"links\"><td><select name=myjob>";
				$joblist= mssql_query("select job from joblist where enabled=1 order by job");
				while($res=mssql_fetch_assoc($joblist))
				{
					if(trim($res['job'])==mssql_result($result,0,'job'))
						$selected = " SELECTED";
					else
						$selected = " DISABLED";
					echo "<option value=\"{$res['job']}\"".$selected.">{$res['job']}</option>";
				}
				echo "</td></tr>";
				echo "\n<tr class=\"links\"><td><a href=\"javascript:void(0)\" onclick=\"noClockIn();\">Clock In</a></td></tr>";
				echo "\n<tr><td>&nbsp;</td></tr>";
				echo "\n<tr class=\"links\" bgcolor=yellow><td><a href=\"javascript:location.href=urlout()\">Clock Out</a></td></tr>";
			}
		}
		else
		{
			echo "\n<tr class=\"links\" bgcolor=yellow><td><select name=myjob><option value=''></option>";
			$joblist= mssql_query("select job from joblist where enabled=1 order by job");
			while($res=mssql_fetch_assoc($joblist))
			{
				echo "<option value=\"{$res['job']}\">{$res['job']}</option>";
			}
			echo "</td></tr>";
			echo "\n<tr class=\"links\" bgcolor=yellow><td><a href=\"javascript:location.href=urlin()\">Clock In</a></td></tr>";
			echo "\n<tr><td>&nbsp;</td></tr>";
			echo "\n<tr class=\"links\"><td><a href=\"javascript:void(0)\" onclick=\"noClockOut();\">Clock Out</a></td></tr>";
		}
		?>
		<tr><td>&nbsp;</td></tr>
		<tr><td>&nbsp;</td></tr>
		<?PHP
			$result = mssql_query("select top 1 type,stamp from [history] where userid='{$_SESSION['myUserID']}' and type in ('clockin','clockout') order by id desc");
			if (mssql_num_rows($result)>0)
			{
				echo "<tr class=\"text\"><td>Last Status:</td></tr><tr class=\"text1\"><td>".mssql_result($result,0,'type')."</td></tr>";
				echo "<tr class=\"text\"><td>Last Time:</td></tr><tr class=\"text1\"><td>".mssql_result($result,0,'stamp')."</td></tr>";
				//echo mssql_result($result,0,'stamp').' '.mssql_result($result,0,'type');
			}
			else
				echo '&nbsp;';
		?>
		<tr><td>&nbsp;</td></tr>
		<?PHP
			$result = mssql_query("select * from [user] where id='{$_SESSION['myUserID']}' and (accountant=1 or admin=1)");
			if (mssql_num_rows($result)>0)
			{
				echo "<tr><td>&nbsp;</td></tr>";
				//echo "<tr class='links'><td><input type=datetime-local name=FromDate value=''><a href='export.php'>Export</a><input type=datetime-local name=ToDate value=''></td></tr>";
				echo "<tr class='links'><td><a href='export.php'>Export</a></td></tr>";
				echo "<tr><td>&nbsp;</td></tr>";
			}
		?>
		<tr class="links"><td><a href='logout.php'>Logout</a></td></tr>
		</td>
		</tr>
		</table>
		</form>

        <script src="//ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script>
        <script>window.jQuery || document.write('<script src="js/vendor/jquery-1.10.2.min.js"><\/script>')</script>
        <script src="js/plugins.js"></script>
        <script src="js/main.js"></script>
    </body>
</html>
