<?php include("includes/head.php");
 ?>
<?php 
include("includes/header.php");
include ("includes/libmail.php");
function getDates($startTime, $endTime) {
    $day = 86400;
    $format = 'm-d-Y';
    $startTime = strtotime($startTime) - 1;
    $endTime = strtotime($endTime);
    $numDays = round(($endTime - $startTime) / $day) + 2;
    //$numDays = round(($endTime - $startTime) / $day); // remove increment 

    $days = array();

    for ($i = 1; $i < $numDays; $i++) { //change $i to 1
        $days[] = date($format, ($startTime + ($i * $day)));
    }

    return $days;
}

function change_dateformat_get_day($date_form)
{

	if($date_form!=''){

		$date1=explode("-",$date_form);

		$dateformat=$date1[2]."-".$date1[0]."-".$date1[1];

		return $dateformat;
	}
	else{
		$dateformat='';
		return $dateformat;
	}
}
?>
<script src="//code.jquery.com/ui/1.11.2/jquery-ui.js"></script>
<link rel="stylesheet" href="//code.jquery.com/ui/1.11.2/themes/smoothness/jquery-ui.css">
<link rel="stylesheet" href="/resources/demos/style.css">
<script>
$(document).ready(function(){

	setTimeout(function(){

		$(".mydiv").fadeOut("slow", function () {

			$(".mydiv").slideUp("slow");

		});

	}, 4000);

});
</script>
<script>
$( document ).ready(function() {
	var enq_dat = new Date();
	$(window).on('load',function() {
	  $('#end_date').datepicker('option', 'minDate', enq_dat);
	});
});
$(function()
{
    $('#start_date').datepicker({
		changeMonth: true,
        changeYear: true,
		dateFormat:"mm-dd-yy",
		onSelect: function(dateStr) {
		  var date = $(this).datepicker('getDate');		  
		  if (date) {
			  
				date.setDate(date.getDate());
		  }
		  $('#end_date').datepicker('option', 'minDate', date);
		},
		beforeShowDay: function(date){
          if(date.getDay() == 0){
                return [true];
            } else {
                return [false];
            }
        }
	
      });
      $('#end_date').datepicker({
		changeMonth: true,
        changeYear: true,
		dateFormat:"mm-dd-yy",
		onSelect: function (selectedDate) {
		  var date = $(this).datepicker('getDate');
		  if (date) {
				date.setDate(date.getDate());
		  }
		  $('#end_date').datepicker('option', 'maxDate', date || 0);
		},
		beforeShowDay: function(date){
          if(date.getDay() == 6){
                return [true];
            } else {
                return [false];
            }
        }
      });
});
</script>

<script>
	jQuery(document).ready(function(){
    	jQuery("#staff_edit_frm").validationEngine();
   });
   /*jQuery(document).ready(function(){
    	jQuery("#timesheet_form").validationEngine();
   });*/

</script>
<script>
function ChangeFocus(cur,nex)
{
var value=document.getElementById(cur).value;
 if(value.length==3)
 {
 document.getElementById(nex).focus();
 }
}

function getkey(e)
{
if (window.event)
return window.event.keyCode;
else if (e)
return e.which;
else
return null;
}
function goodchars(e, goods)
{
var key, keychar;
key = getkey(e);
if (key == null) return true;
keychar = String.fromCharCode(key);
keychar = keychar.toLowerCase();
goods = goods.toLowerCase();
if (goods.indexOf(keychar) != -1)
return true;
if ( key==null || key==0 || key==8 || key==9 || key==13 || key==27 )
return true;
return false;
}
</script>
<script type="text/javascript">

function open_future_tr()
{
	$("#future_date_div").slideToggle(1500);
}


function alert_staff(id)
{
	$( "#dialog-confirm" ).dialog({
	resizable: false,
	height:190,
	width:400,
	modal: true,
	buttons: {
	"Yes": function() {
	$( this ).dialog( "close" );
	},
	"No": function() {
	$( this ).dialog( "close" );
	$("#"+id).val('');
	var val = id.split('_');
	get_daily_total(val[0])
	}
	}
	});
}
</script>
<script type="text/javascript">

function get_daily_total(val,type)
{
	if($("#"+val+"_approved").val())
	var approved = $("#"+val+"_approved").val();
	else
	var approved = 0;
	
	if($("#"+val+"_unapproved").val())
	var unapproved = $("#"+val+"_unapproved").val();
	else
	var unapproved = 0;
	
	if($("#"+val+"_holiday").val())
	var holiday = $("#"+val+"_holiday").val();
	else
	var holiday = 0;
	
	if($("#"+val+"_vacation").val())
	var vacation = $("#"+val+"_vacation").val();
	else
	var vacation = 0;
	
	if($("#"+val+"_sick").val())
	var sick = $("#"+val+"_sick").val();
	else
	var sick = 0;
	
	if($("#"+val+"_unpaid").val())
	var unpaid = $("#"+val+"_unpaid").val();
	else
	var unpaid = 0;
	
	if($("#"+val+"_personal").val())
	var personal = $("#"+val+"_personal").val();
	else
	var personal = 0;
	
	var total = parseFloat(approved) + parseFloat(unapproved) + parseFloat(holiday) + parseFloat(vacation) + parseFloat(sick) + parseFloat(unpaid) + parseFloat(personal);
	
	if(total == 0)
	{
		total = '';
	}
	
	if(total > 24 )
	{
		alert("You cannot enter more than 24 hours a day.");
		$("#"+val+"_"+type).val('');
		get_daily_total();
	}
	else
	{
		$("#"+val+"_daily_total").val(total);
	}

}


function get_weekly_total()
{
	if($("#sun_daily_total").val())
	var sunday_total = $("#sun_daily_total").val();
	else
	var sunday_total = 0;
	
	if($("#mon_daily_total").val())
	var monday_total = $("#mon_daily_total").val();
	else
	var monday_total = 0;
	
	if($("#tue_daily_total").val())
	var tuesday_total = $("#tue_daily_total").val();
	else
	var tuesday_total = 0;
	
	if($("#wed_daily_total").val())
	var wednesday_total = $("#wed_daily_total").val();
	else
	var wednesday_total = 0;
	
	if($("#thu_daily_total").val())
	var thursday_total = $("#thu_daily_total").val();
	else
	var thursday_total = 0;
	
	if($("#fri_daily_total").val())
	var friday_total = $("#fri_daily_total").val();
	else
	var friday_total = 0;
	
	if($("#sat_daily_total").val())
	var saturday_total = $("#sat_daily_total").val();
	else
	var saturday_total = 0;
	
	var total_week = parseFloat(sunday_total) + parseFloat(monday_total) + parseFloat(tuesday_total) + parseFloat(wednesday_total) + parseFloat(thursday_total) + parseFloat(friday_total) + parseFloat(saturday_total); 
	
	
	$("#weekly_total").val(total_week);

}


/*function check_validations()
{
	if($("#approved_timesheet").val() == "")
	{
		alert("You must upload your approved Timesheet for Submission.");
		return false;
	}
	
	if($("#sun_unapproved").val() != "")
	{
		alert("You cannot submit your Timesheet with Unapproved Hours.");
		return false;
	}
	if($("#mon_unapproved").val() != "")
	{
		alert("You cannot submit your Timesheet with Unapproved Hours.");
		return false;
	}
	if($("#tue_unapproved").val() != "")
	{
		alert("You cannot submit your Timesheet with Unapproved Hours.");
		return false;
	}
	if($("#wed_unapproved").val() != "")
	{
		alert("You cannot submit your Timesheet with Unapproved Hours.");
		return false;
	}
	if($("#thu_unapproved").val() != "")
	{
		alert("You cannot submit your Timesheet with Unapproved Hours.");
		return false;
	}
	if($("#fri_unapproved").val() != "")
	{
		alert("You cannot submit your Timesheet with Unapproved Hours.");
		return false;
	}
	if($("#sat_unapproved").val() != "")
	{
		alert("You cannot submit your Timesheet with Unapproved Hours.");
		return false;
	}
	
	if($("#weekly_total").val() < 40)
	{
		if($("#visa_type_hid").val() == "H1B" || $("#staff_type_hid").val() == "W2S")
		{
			if($("#explanation").val() == "" && $("#explain_div").css('display') == "none")
			{
				$("#explain_div").slideDown(1000);
				return false;
			}
			
			if($("#explanation").val() == "" && $("#explain_div").css('display') == "block")
			{
				alert("Please enter your Explanation to Submit.");
				$("#explanation").focus();
				return false;
			}
			
		}
	}

	if($("#weekly_total").val() > 40)
	{
		if(!$("input:radio[name='client_approval']").is(":checked")) 
		{
			$("#agree_div").slideDown(1000);
			return false;
		}
		else if($("#client_approval1").is(":checked"))
		{
			alert("You cannot submit with Client Non-Approval Hours.");
			return false;
		}
		
	}
}*/

function edit_info(){
	$(".edit1").hide();
	$(".edit").show();
	$("#send_btn").show();
}

function update_staff(){
	
	if(!$("#staff_edit_frm").validationEngine('validate'))
	{

		return false;

	}
	else
	{
		if($("#visa_type_hid").val() == "H1B")
		{
			var work_addr = $("#worksite_street").val();
			var pemail = $("#work_email").val();
			var wemail = $("#pemail").val();
			var wphone = $("#work_phone_no").val();
			var cphone = $("#cphone").val();
			var ophone = $("#hphone").val();
			
			if(work_addr != "" && (pemail != "" || wemail != "") && (wphone != "" || cphone != "" || ophone != ""))
			{
				$.ajax({
					url : 'update_staff_info.php',
					type : 'POST',
					data : $("#staff_edit_frm").serialize(),
					//dataType : 'json',
					beforeSend : function(jqXHR, settings ){
						//alert(url);
					},
					success : function(data, textStatus, jqXHR){
			
							$("#success_msg_div").html('<p class="mydiv" style="color:#090; float:left; font-family:Verdana, Geneva, sans-serif; font-size:13px; text-align:left;">'+data+'</p>');
						//$('#market_div').html(data);
					},
					/*complete : function(jqXHR, textStatus){
						alert(3);
					},*/
					error : function(jqXHR, textStatus, errorThrown){
					}
				});
			}
			else
			{
				alert("Work location address for H1B, at least one Email and Phone Number are Mandatory.");
			}
			
		}
		else
		{
			$.ajax({
				url : 'update_staff_info.php',
				type : 'POST',
				data : $("#staff_edit_frm").serialize(),
				//dataType : 'json',
				beforeSend : function(jqXHR, settings ){
					//alert(url);
				},
				success : function(data, textStatus, jqXHR){
						//alert(data);
						$("#success_msg_div").html('<p class="mydiv" style="color:#090; float:left; font-family:Verdana, Geneva, sans-serif; font-size:13px; text-align:left;">'+data+'</p>');
					//$('#market_div').html(data);
				},
				/*complete : function(jqXHR, textStatus){
					alert(3);
				},*/
				error : function(jqXHR, textStatus, errorThrown){
				}
			});
		}
	}
}


function open_question_div()
{
	$("#question_div").show();
	$("#fade1").show();
}

function close_question_div()
{
	$("#question_div").hide();
	$("#fade1").hide();
}

function ask_question()
{
	var question = $("#query").val();
	
	if(question == ''){

		$('#error_msg_div').html('This Field is Required.');
		return false;
	}
	else
	{
		$.ajax({
			url : 'send_questions.php',
			type : 'POST',
			data : 'question=' + question,
			//dataType : 'json',
			beforeSend : function(jqXHR, settings ){
				//alert(url);
			},
			success : function(data, textStatus, jqXHR){
				//alert(data);
				$("#success_msg_div").html('<p class="mydiv" style="color:#090; float:left; font-family:Verdana, Geneva, sans-serif; font-size:13px; text-align:left;">'+data+'</p>');
				close_question_div();
			},
			/*complete : function(jqXHR, textStatus){
				alert(3);
			},*/
			error : function(jqXHR, textStatus, errorThrown){
			}
		});
		return true;
	}

}

function remove_error_msg()
{
	var reason = $('#reason').val();
	
	if(reason != ''){
		//$j('#error_msg_div').slideDown(200);
		$('#error_msg_div').html('');
		//return true;
	}
	else
	{
		$('#error_msg_div').html('This Field is Required.');
	}
}

function check_sick_total(val)
{
	var total_sick = parseFloat($("#sick_hid").val()) + parseFloat($("#sic_hid").val());
	
	if($("#mon_sick").val())
	var mon_sick = $("#mon_sick").val();
	else
	var mon_sick = 0;
	if($("#tue_sick").val())
	var tue_sick = $("#tue_sick").val();
	else
	var tue_sick = 0;
	if($("#wed_sick").val())
	var wed_sick = $("#wed_sick").val();
	else
	var wed_sick = 0;
	if($("#thu_sick").val())
	var thu_sick = $("#thu_sick").val();
	else
	var thu_sick = 0;
	if($("#fri_sick").val())
	var fri_sick = $("#fri_sick").val();
	else
	var fri_sick = 0;
	if($("#sat_sick").val())
	var sat_sick = $("#sat_sick").val();
	else
	var sat_sick = 0;
	if($("#sun_sick").val())
	var sun_sick = $("#sun_sick").val();
	else
	var sun_sick = 0;
	
	var total = parseFloat(mon_sick) + parseFloat(tue_sick) + parseFloat(wed_sick) + parseFloat(thu_sick) + parseFloat(fri_sick) + parseFloat(sat_sick) + parseFloat(sun_sick);
	
	if(total > parseFloat(total_sick))
	{
		alert("You cannot enter more than sick hours you have.");
		$("#"+val+"_sick").val('');
		get_daily_total(val);
		get_weekly_total();
	}
	
}

function check_holiday_total(val)
{
	var total_holiday = parseFloat($("#holiday_hid").val()) + parseFloat($("#hol_hid").val());
	
	if($("#mon_holiday").val())
	var mon_holiday = $("#mon_holiday").val();
	else
	var mon_holiday = 0;
	if($("#tue_holiday").val())
	var tue_holiday = $("#tue_holiday").val();
	else
	var tue_holiday = 0;
	if($("#wed_holiday").val())
	var wed_holiday = $("#wed_holiday").val();
	else
	var wed_holiday = 0;
	if($("#thu_holiday").val())
	var thu_holiday = $("#thu_holiday").val();
	else
	var thu_holiday = 0;
	if($("#fri_holiday").val())
	var fri_holiday = $("#fri_holiday").val();
	else
	var fri_holiday = 0;
	if($("#sat_holiday").val())
	var sat_holiday = $("#sat_holiday").val();
	else
	var sat_holiday = 0;
	if($("#sun_holiday").val())
	var sun_holiday = $("#sun_holiday").val();
	else
	var sun_holiday = 0;
	
	var total = parseFloat(mon_holiday) + parseFloat(tue_holiday) + parseFloat(wed_holiday) + parseFloat(thu_holiday) + parseFloat(fri_holiday) + parseFloat(sat_holiday) + parseFloat(sun_holiday);
	
	if(total > parseFloat(total_holiday))
	{
		alert("You cannot enter more than holiday hours you have.");
		$("#"+val+"_holiday").val('');
		get_daily_total(val);
		get_weekly_total();
	}
	
}

function check_vacation_total(val)
{
	var total_vacation = $("#vacation_hid").val();
	
	if($("#mon_vacation").val())
	var mon_vacation = $("#mon_vacation").val();
	else
	var mon_vacation = 0;
	if($("#tue_vacation").val())
	var tue_vacation = $("#tue_vacation").val();
	else
	var tue_vacation = 0;
	if($("#wed_vacation").val())
	var wed_vacation = $("#wed_vacation").val();
	else
	var wed_vacation = 0;
	if($("#thu_vacation").val())
	var thu_vacation = $("#thu_vacation").val();
	else
	var thu_vacation = 0;
	if($("#fri_vacation").val())
	var fri_vacation = $("#fri_vacation").val();
	else
	var fri_vacation = 0;
	if($("#sat_vacation").val())
	var sat_vacation = $("#sat_vacation").val();
	else
	var sat_vacation = 0;
	if($("#sun_vacation").val())
	var sun_vacation = $("#sun_vacation").val();
	else
	var sun_vacation = 0;
	
	var total = parseFloat(mon_vacation) + parseFloat(tue_vacation) + parseFloat(wed_vacation) + parseFloat(thu_vacation) + parseFloat(fri_vacation) + parseFloat(sat_vacation) + parseFloat(sun_vacation);
	
	if(total > parseFloat(total_vacation))
	{
		alert("You cannot enter more than vacation hours you have.");
		$("#"+val+"_vacation").val('');
		get_daily_total(val);
		get_weekly_total();
	}
	
}

function check_personal_total(val)
{
	var total_personal = parseFloat($("#personal_hid").val()) + parseFloat($("#pers_hid").val());
	
	if($("#mon_personal").val())
	var mon_personal = $("#mon_personal").val();
	else
	var mon_personal = 0;
	if($("#tue_personal").val())
	var tue_personal = $("#tue_personal").val();
	else
	var tue_personal = 0;
	if($("#wed_personal").val())
	var wed_personal = $("#wed_personal").val();
	else
	var wed_personal = 0;
	if($("#thu_personal").val())
	var thu_personal = $("#thu_personal").val();
	else
	var thu_personal = 0;
	if($("#fri_personal").val())
	var fri_personal = $("#fri_personal").val();
	else
	var fri_personal = 0;
	if($("#sat_personal").val())
	var sat_personal = $("#sat_personal").val();
	else
	var sat_personal = 0;
	if($("#sun_personal").val())
	var sun_personal = $("#sun_personal").val();
	else
	var sun_personal = 0;
	
	var total = parseFloat(mon_personal) + parseFloat(tue_personal) + parseFloat(wed_personal) + parseFloat(thu_personal) + parseFloat(fri_personal) + parseFloat(sat_personal) + parseFloat(sun_personal);
	
	if(total > total_personal)
	{
		alert("You cannot enter more than personal hours you have.");
		$("#"+val+"_personal").val('');
		get_daily_total(val);
		get_weekly_total();
	}
	
}

function check_holiday(date,id)
{
	$.ajax({
		url : 'check_holiday.php',
		type : 'POST',
		data : 'current_date=' + date,
		//dataType : 'json',
		beforeSend : function(jqXHR, settings ){
			//alert(url);
		},
		success : function(data, textStatus, jqXHR){
			//alert(data);
			if(data != '')
			{
				$("#alert_msg_id").html('<span class="ui-icon ui-icon-alert" style="float:left; margin:0 7px 20px 0;"></span>This is a Holiday as it is '+data+'. Are you sure you have worked on this day?');
				$( "#dialog-confirm-holiday" ).dialog({
				resizable: false,
				height:190,
				width:400,
				modal: true,
				buttons: {
				"Yes": function() {
				$( this ).dialog( "close" );
				},
				"No": function() {
				$( this ).dialog( "close" );
				$("#"+id).val('');
				var val = id.split('_');
				get_daily_total(val[0])
				}
				}
				});
			}
		},
		/*complete : function(jqXHR, textStatus){
			alert(3);
		},*/
		error : function(jqXHR, textStatus, errorThrown){
		}
	});

}

function check_period()
{
	var oneDay = 24*60*60*1000; // hours*minutes*seconds*milliseconds
	
	start_date = $("#start_date").val();
	end_date = $("#end_date").val();
	
	new_start_date = start_date.split('-');
	new_end_date = end_date.split('-');
	
	
	var firstDate = new Date(new_start_date[2],new_start_date[0],new_start_date[1]);
	var secondDate = new Date(new_end_date[2],new_end_date[0],new_end_date[1]);
	
	var diffDays = Math.round(Math.abs((firstDate.getTime() - secondDate.getTime())/(oneDay)));
	
	if(diffDays!=6)
	{
	 	alert("You cannot select a Timesheet Period More than a Week.");
		return false;
	}
	else
	{
		return true;
	}
	
}

function check_validations()
{
	/*if($("#approved_timesheet").val() == "")
	{
		alert("You must upload your approved Timesheet for Submission.");
		return false;
	}*/
	
	if($('#approved_timesheet').val()!=''){
		var ext = $('#approved_timesheet').val().split('.').pop().toLowerCase();
		if($.inArray(ext, ['pdf','doc','docx','xlsx','xlsm','xls','csv' , 'jpg','jpeg']) == -1) {
			alert('Invalid File Type.');
			$('#approved_timesheet').val('');
			return false;
		}
	}
	
	/*if($("#mon_daily_total").val() == "")
	{
		alert("Please enter your Moday Timesheet hours.");
		return false;
	}
	if($("#tue_daily_total").val() == "")
	{
		alert("Please enter your Tuesday Timesheet hours.");
		return false;
	}
	if($("#wed_daily_total").val() == "")
	{
		alert("Please enter your Wednesday Timesheet hours.");
		return false;
	}
	if($("#thu_daily_total").val() == "")
	{
		alert("Please enter your Thursday Timesheet hours.");
		return false;
	}
	if($("#fri_daily_total").val() == "")
	{
		alert("Please enter your Friday Timesheet hours.");
		return false;
	}*/

	if($("#sun_unapproved").val() != "")
	{
		alert("You cannot submit your Timesheet with Unapproved Hours.");
		return false;
	}
	if($("#mon_unapproved").val() != "")
	{
		alert("You cannot submit your Timesheet with Unapproved Hours.");
		return false;
	}
	if($("#tue_unapproved").val() != "")
	{
		alert("You cannot submit your Timesheet with Unapproved Hours.");
		return false;
	}
	if($("#wed_unapproved").val() != "")
	{
		alert("You cannot submit your Timesheet with Unapproved Hours.");
		return false;
	}
	if($("#thu_unapproved").val() != "")
	{
		alert("You cannot submit your Timesheet with Unapproved Hours.");
		return false;
	}
	if($("#fri_unapproved").val() != "")
	{
		alert("You cannot submit your Timesheet with Unapproved Hours.");
		return false;
	}
	if($("#sat_unapproved").val() != "")
	{
		alert("You cannot submit your Timesheet with Unapproved Hours.");
		return false;
	}
	
	if($("#weekly_total").val() < 40)
	{
		if($("#visa_type_hid").val() == "H1B" || $("#staff_type_hid").val() == "W2S")
		{
			if($("#explanation").val() == "")
			{
				if($("#agree_div").css('display') == "block")
				{
					$("#agree_div").slideUp(1000);
					$("#client_approval1").attr('checked', false)
					$("#client_approval").attr('checked', false)
				}
				$("#explain_div").slideDown(1000);
				return false;
			}
		}
	}

	if($("#weekly_total").val() > 40)
	{
		if(!$("input:radio[name='client_approval']").is(":checked")) 
		{
			if($("#explain_div").css('display') == "block")
			{
				$("#explain_div").slideUp(1000);
				$("#explanation").val('')
			}
			$("#agree_div").slideDown(1000);
			return false;
		}
		else if($("#client_approval1").is(":checked"))
		{
			alert("You caanot submit with Client Non-Approval Hours.");
			return false;
		}
	}
}
</script>


<?php
  	
	/*if(date('D')!='Sun')
	{    
	  $staticstart = date('m-d-Y',strtotime('last Sunday'));    
	
	}else{
		$staticstart = date('m-d-Y');   
	}
	
	
	if(date('D')!='Sat')
	{
		$staticfinish = date('m-d-Y',strtotime('next Saturday'));
	}else{
	
		$staticfinish = date('m-d-Y');
	}*/
  $staff_id = $_REQUEST['id'];
  
	if($_REQUEST['future_date'] == "Submit")
	{
		$staticstart = $_REQUEST['start_date'];
		$staticfinish = $_REQUEST['end_date'];
		
		$sql_check = mysql_query("SELECT id FROM timesheet WHERE staff_id = '".$staff_id."' AND date_from = '".change_dateformat_rev($staticstart)."' AND date_to = '".change_dateformat_rev($staticfinish)."'");
	
		$sql_check_num = mysql_num_rows($sql_check);
		/*if($sql_check_num == 0)
		{
			header("location:timesheet_edit.php?id=".$staff_id."&page=".$_REQUEST['page']."&success=3");
		}*/
	}

	if($_REQUEST['submit_final'] == "Submit")
	{
		$staticstart = $_REQUEST['start_date_hid'];
		$staticfinish = $_REQUEST['end_date_hid'];
	}
	
	

	$startdate = change_dateformat_get_day($staticstart);
	$enddate = change_dateformat_get_day($staticfinish);
	
	$all_dates = getDates($startdate,$enddate);
	


$sql_staff_data = mysql_fetch_array(mysql_query("SELECT * FROM sat_staff WHERE staff_id = '".$staff_id."'"));
?>

<?php


if($sql_staff_data['associate_type'] == "W2S")
{
	$sql_personal_data = mysql_fetch_array(mysql_query("SELECT * FROM staff_personal WHERE staff_id = '".$staff_id."'"));
}

$sql_company_message = mysql_fetch_array(mysql_query("SELECT * FROM company_message_master WHERE staff_type = '".$sql_staff_data['associate_type']."'"));

$sql_data = mysql_fetch_array(mysql_query("SELECT * FROM timesheet WHERE staff_id = '".$staff_id."' AND date_from = '".change_dateformat_rev($staticstart)."' AND date_to = '".change_dateformat_rev($staticfinish)."'"));

$check_submission = mysql_num_rows(mysql_query("SELECT id FROM timesheet_weekly_hours WHERE timesheet_id = '".$sql_data['id']."' AND staff_id = '".$staff_id."'"));

$check_submission_id = mysql_fetch_array(mysql_query("SELECT * FROM timesheet_weekly_hours WHERE timesheet_id = '".$sql_data['id']."' AND staff_id = '".$staff_id."'"));

$hol_prev = $sql_data['sun_holiday'] + $sql_data['mon_holiday'] + $sql_data['tue_holiday'] + $sql_data['wed_holiday'] + $sql_data['thu_holiday'] + $sql_data['fri_holiday'] + $sql_data['sat_holiday'];
$sic_prev = $sql_data['sun_sick'] + $sql_data['mon_sick'] + $sql_data['tue_sick'] + $sql_data['wed_sick'] + $sql_data['thu_sick'] + $sql_data['fri_sick'] + $sql_data['sat_sick'];
$pers_prev = $sql_data['sun_personal'] + $sql_data['mon_personal'] + $sql_data['tue_personal'] + $sql_data['wed_personal'] + $sql_data['thu_personal'] + $sql_data['fri_personal'] + $sql_data['sat_personal'];


if($_REQUEST['save'] == "Save")
{
	$sql_check = mysql_query("SELECT id FROM timesheet WHERE staff_id = '".$staff_id."' AND date_from = '".change_dateformat_rev($_REQUEST['start_date_hid'])."' AND date_to = '".change_dateformat_rev($_REQUEST['end_date_hid'])."'");
	
	$sql_check_num = mysql_num_rows($sql_check);
	
	$sql_check_id = mysql_fetch_array($sql_check);
	
	if($sql_check_num == 0)
	{
		$sql = "INSERT INTO timesheet SET staff_id = '".$staff_id."' , date_from = '".change_dateformat_rev($_REQUEST['start_date_hid'])."' , date_to = '".change_dateformat_rev($_REQUEST['end_date_hid'])."' , sun_approved = '".$_REQUEST['sun_approved']."' , sun_unapproved = '".$_REQUEST['sun_unapproved']."' , sun_holiday = '".$_REQUEST['sun_holiday']."' , sun_vacation = '".$_REQUEST['sun_vacation']."' , sun_personal = '".$_REQUEST['sun_personal']."' , sun_sick = '".$_REQUEST['sun_sick']."' , sun_unpaid = '".$_REQUEST['sun_unpaid']."' , sun_total = '".$_REQUEST['sun_daily_total']."' , mon_approved = '".$_REQUEST['mon_approved']."' , mon_unapproved = '".$_REQUEST['mon_unapproved']."' , mon_holiday = '".$_REQUEST['mon_holiday']."' , mon_vacation = '".$_REQUEST['mon_vacation']."' , mon_personal = '".$_REQUEST['mon_personal']."' , mon_sick = '".$_REQUEST['mon_sick']."' , mon_unpaid = '".$_REQUEST['mon_unpaid']."' , mon_total = '".$_REQUEST['mon_daily_total']."' , tue_approved = '".$_REQUEST['tue_approved']."' , tue_unapproved = '".$_REQUEST['tue_unapproved']."' , tue_holiday = '".$_REQUEST['tue_holiday']."' , tue_vacation = '".$_REQUEST['tue_vacation']."' , tue_personal = '".$_REQUEST['tue_personal']."' , tue_sick = '".$_REQUEST['tue_sick']."' , tue_unpaid = '".$_REQUEST['tue_unpaid']."' , tue_total = '".$_REQUEST['tue_daily_total']."' , wed_approved = '".$_REQUEST['wed_approved']."' , wed_unapproved = '".$_REQUEST['wed_unapproved']."' , wed_holiday = '".$_REQUEST['wed_holiday']."' , wed_vacation = '".$_REQUEST['wed_vacation']."' , wed_personal = '".$_REQUEST['wed_personal']."' , wed_sick = '".$_REQUEST['wed_sick']."' , wed_unpaid = '".$_REQUEST['wed_unpaid']."' , wed_total = '".$_REQUEST['wed_daily_total']."' , thu_approved = '".$_REQUEST['thu_approved']."' , thu_unapproved = '".$_REQUEST['thu_unapproved']."' , thu_holiday = '".$_REQUEST['thu_holiday']."' , thu_vacation = '".$_REQUEST['thu_vacation']."' , thu_personal = '".$_REQUEST['thu_personal']."' , thu_sick = '".$_REQUEST['thu_sick']."' , thu_unpaid = '".$_REQUEST['thu_unpaid']."' , thu_total = '".$_REQUEST['thu_daily_total']."' , fri_approved = '".$_REQUEST['fri_approved']."' , fri_unapproved = '".$_REQUEST['fri_unapproved']."' , fri_holiday = '".$_REQUEST['fri_holiday']."' , fri_vacation = '".$_REQUEST['fri_vacation']."' , fri_personal = '".$_REQUEST['fri_personal']."' , fri_sick = '".$_REQUEST['fri_sick']."' , fri_unpaid = '".$_REQUEST['fri_unpaid']."' , fri_total = '".$_REQUEST['fri_daily_total']."' , sat_approved = '".$_REQUEST['sat_approved']."' , sat_unapproved = '".$_REQUEST['sat_unapproved']."' , sat_holiday = '".$_REQUEST['sat_holiday']."' , sat_vacation = '".$_REQUEST['sat_vacation']."' , sat_personal = '".$_REQUEST['sat_personal']."' , sat_sick = '".$_REQUEST['sat_sick']."' , sat_unpaid = '".$_REQUEST['sat_unpaid']."' , sat_total = '".$_REQUEST['sat_daily_total']."' , modified_date = NOW() , modified_by = '".$_SESSION['staff_login_id']."'";
		$insert = mysql_query($sql);
		$last_id = mysql_insert_id();
		if($insert)
		{
			header("location:timesheet_edit.php?id=".$staff_id."&page=".$_REQUEST['page']."&success=1");
		}
	}
	else
	{
		$sql = "UPDATE timesheet SET sun_approved = '".$_REQUEST['sun_approved']."' , sun_unapproved = '".$_REQUEST['sun_unapproved']."' , sun_holiday = '".$_REQUEST['sun_holiday']."' , sun_vacation = '".$_REQUEST['sun_vacation']."' , sun_personal = '".$_REQUEST['sun_personal']."' , sun_sick = '".$_REQUEST['sun_sick']."' , sun_unpaid = '".$_REQUEST['sun_unpaid']."' , sun_total = '".$_REQUEST['sun_daily_total']."' , mon_approved = '".$_REQUEST['mon_approved']."' , mon_unapproved = '".$_REQUEST['mon_unapproved']."' , mon_holiday = '".$_REQUEST['mon_holiday']."' , mon_vacation = '".$_REQUEST['mon_vacation']."' , mon_personal = '".$_REQUEST['mon_personal']."' , mon_sick = '".$_REQUEST['mon_sick']."' , mon_unpaid = '".$_REQUEST['mon_unpaid']."' , mon_total = '".$_REQUEST['mon_daily_total']."' , tue_approved = '".$_REQUEST['tue_approved']."' , tue_unapproved = '".$_REQUEST['tue_unapproved']."' , tue_holiday = '".$_REQUEST['tue_holiday']."' , tue_vacation = '".$_REQUEST['tue_vacation']."' , tue_personal = '".$_REQUEST['tue_personal']."' , tue_sick = '".$_REQUEST['tue_sick']."' , tue_unpaid = '".$_REQUEST['tue_unpaid']."' , tue_total = '".$_REQUEST['tue_daily_total']."' , wed_approved = '".$_REQUEST['wed_approved']."' , wed_unapproved = '".$_REQUEST['wed_unapproved']."' , wed_holiday = '".$_REQUEST['wed_holiday']."' , wed_vacation = '".$_REQUEST['wed_vacation']."' , wed_personal = '".$_REQUEST['wed_personal']."' , wed_sick = '".$_REQUEST['wed_sick']."' , wed_unpaid = '".$_REQUEST['wed_unpaid']."' , wed_total = '".$_REQUEST['wed_daily_total']."' , thu_approved = '".$_REQUEST['thu_approved']."' , thu_unapproved = '".$_REQUEST['thu_unapproved']."' , thu_holiday = '".$_REQUEST['thu_holiday']."' , thu_vacation = '".$_REQUEST['thu_vacation']."' , thu_personal = '".$_REQUEST['thu_personal']."' , thu_sick = '".$_REQUEST['thu_sick']."' , thu_unpaid = '".$_REQUEST['thu_unpaid']."' , thu_total = '".$_REQUEST['thu_daily_total']."' , fri_approved = '".$_REQUEST['fri_approved']."' , fri_unapproved = '".$_REQUEST['fri_unapproved']."' , fri_holiday = '".$_REQUEST['fri_holiday']."' , fri_vacation = '".$_REQUEST['fri_vacation']."' , fri_personal = '".$_REQUEST['fri_personal']."' , fri_sick = '".$_REQUEST['fri_sick']."' , fri_unpaid = '".$_REQUEST['fri_unpaid']."' , fri_total = '".$_REQUEST['fri_daily_total']."' , sat_approved = '".$_REQUEST['sat_approved']."' , sat_unapproved = '".$_REQUEST['sat_unapproved']."' , sat_holiday = '".$_REQUEST['sat_holiday']."' , sat_vacation = '".$_REQUEST['sat_vacation']."' , sat_personal = '".$_REQUEST['sat_personal']."' , sat_sick = '".$_REQUEST['sat_sick']."' , sat_unpaid = '".$_REQUEST['sat_unpaid']."' , sat_total = '".$_REQUEST['sat_daily_total']."' , modified_date = NOW() , modified_by = '".$_SESSION['staff_login_id']."' WHERE id = '".$sql_check_id['id']."'";
		$update = mysql_query($sql);
		$update_id = $sql_check_id['id'];
		if($update)
		{
			header("location:timesheet_edit.php?id=".$staff_id."&page=".$_REQUEST['page']."&success=1");
		}
	}
}

/*--------------------------------------------------------Final Submission-----------------------------------------------------*/

if($_REQUEST['submit_final'] == "Submit")
{
	
	
	include("image_file.php");
	
	$sql_check = mysql_query("SELECT id FROM timesheet WHERE staff_id = '".$staff_id."' AND date_from = '".change_dateformat_rev($_REQUEST['start_date_hid'])."' AND date_to = '".change_dateformat_rev($_REQUEST['end_date_hid'])."'");
	
	$sql_check_num = mysql_num_rows($sql_check);
	
	$sql_check_id = mysql_fetch_array($sql_check);
	
	//if($sql_check_num > 0)
	{
		
		
		
		
		/*if($sql_check_num == 0)
		{
			$sql = "INSERT INTO timesheet SET staff_id = '".$staff_id."' , date_from = '".change_dateformat_rev($_REQUEST['start_date_hid'])."' , date_to = '".change_dateformat_rev($_REQUEST['end_date_hid'])."' , sun_approved = '".$_REQUEST['sun_approved']."' , sun_unapproved = '".$_REQUEST['sun_unapproved']."' , sun_holiday = '".$_REQUEST['sun_holiday']."' , sun_vacation = '".$_REQUEST['sun_vacation']."' , sun_personal = '".$_REQUEST['sun_personal']."' , sun_sick = '".$_REQUEST['sun_sick']."' , sun_unpaid = '".$_REQUEST['sun_unpaid']."' , sun_total = '".$_REQUEST['sun_daily_total']."' , mon_approved = '".$_REQUEST['mon_approved']."' , mon_unapproved = '".$_REQUEST['mon_unapproved']."' , mon_holiday = '".$_REQUEST['mon_holiday']."' , mon_vacation = '".$_REQUEST['mon_vacation']."' , mon_personal = '".$_REQUEST['mon_personal']."' , mon_sick = '".$_REQUEST['mon_sick']."' , mon_unpaid = '".$_REQUEST['mon_unpaid']."' , mon_total = '".$_REQUEST['mon_daily_total']."' , tue_approved = '".$_REQUEST['tue_approved']."' , tue_unapproved = '".$_REQUEST['tue_unapproved']."' , tue_holiday = '".$_REQUEST['tue_holiday']."' , tue_vacation = '".$_REQUEST['tue_vacation']."' , tue_personal = '".$_REQUEST['tue_personal']."' , tue_sick = '".$_REQUEST['tue_sick']."' , tue_unpaid = '".$_REQUEST['tue_unpaid']."' , tue_total = '".$_REQUEST['tue_daily_total']."' , wed_approved = '".$_REQUEST['wed_approved']."' , wed_unapproved = '".$_REQUEST['wed_unapproved']."' , wed_holiday = '".$_REQUEST['wed_holiday']."' , wed_vacation = '".$_REQUEST['wed_vacation']."' , wed_personal = '".$_REQUEST['wed_personal']."' , wed_sick = '".$_REQUEST['wed_sick']."' , wed_unpaid = '".$_REQUEST['wed_unpaid']."' , wed_total = '".$_REQUEST['wed_daily_total']."' , thu_approved = '".$_REQUEST['thu_approved']."' , thu_unapproved = '".$_REQUEST['thu_unapproved']."' , thu_holiday = '".$_REQUEST['thu_holiday']."' , thu_vacation = '".$_REQUEST['thu_vacation']."' , thu_personal = '".$_REQUEST['thu_personal']."' , thu_sick = '".$_REQUEST['thu_sick']."' , thu_unpaid = '".$_REQUEST['thu_unpaid']."' , thu_total = '".$_REQUEST['thu_daily_total']."' , fri_approved = '".$_REQUEST['fri_approved']."' , fri_unapproved = '".$_REQUEST['fri_unapproved']."' , fri_holiday = '".$_REQUEST['fri_holiday']."' , fri_vacation = '".$_REQUEST['fri_vacation']."' , fri_personal = '".$_REQUEST['fri_personal']."' , fri_sick = '".$_REQUEST['fri_sick']."' , fri_unpaid = '".$_REQUEST['fri_unpaid']."' , fri_total = '".$_REQUEST['fri_daily_total']."' , sat_approved = '".$_REQUEST['sat_approved']."' , sat_unapproved = '".$_REQUEST['sat_unapproved']."' , sat_holiday = '".$_REQUEST['sat_holiday']."' , sat_vacation = '".$_REQUEST['sat_vacation']."' , sat_personal = '".$_REQUEST['sat_personal']."' , sat_sick = '".$_REQUEST['sat_sick']."' , sat_unpaid = '".$_REQUEST['sat_unpaid']."' , sat_total = '".$_REQUEST['sat_daily_total']."' , modified_date = NOW() , modified_by = '".$_SESSION['staff_login_id']."'";
			$insert = mysql_query($sql);
			$timesheet_id = mysql_insert_id();
		}
		else
		{*/
			$sql = "UPDATE timesheet SET sun_approved = '".$_REQUEST['sun_approved']."' , sun_unapproved = '".$_REQUEST['sun_unapproved']."' , sun_holiday = '".$_REQUEST['sun_holiday']."' , sun_vacation = '".$_REQUEST['sun_vacation']."' , sun_personal = '".$_REQUEST['sun_personal']."' , sun_sick = '".$_REQUEST['sun_sick']."' , sun_unpaid = '".$_REQUEST['sun_unpaid']."' , sun_total = '".$_REQUEST['sun_daily_total']."' , mon_approved = '".$_REQUEST['mon_approved']."' , mon_unapproved = '".$_REQUEST['mon_unapproved']."' , mon_holiday = '".$_REQUEST['mon_holiday']."' , mon_vacation = '".$_REQUEST['mon_vacation']."' , mon_personal = '".$_REQUEST['mon_personal']."' , mon_sick = '".$_REQUEST['mon_sick']."' , mon_unpaid = '".$_REQUEST['mon_unpaid']."' , mon_total = '".$_REQUEST['mon_daily_total']."' , tue_approved = '".$_REQUEST['tue_approved']."' , tue_unapproved = '".$_REQUEST['tue_unapproved']."' , tue_holiday = '".$_REQUEST['tue_holiday']."' , tue_vacation = '".$_REQUEST['tue_vacation']."' , tue_personal = '".$_REQUEST['tue_personal']."' , tue_sick = '".$_REQUEST['tue_sick']."' , tue_unpaid = '".$_REQUEST['tue_unpaid']."' , tue_total = '".$_REQUEST['tue_daily_total']."' , wed_approved = '".$_REQUEST['wed_approved']."' , wed_unapproved = '".$_REQUEST['wed_unapproved']."' , wed_holiday = '".$_REQUEST['wed_holiday']."' , wed_vacation = '".$_REQUEST['wed_vacation']."' , wed_personal = '".$_REQUEST['wed_personal']."' , wed_sick = '".$_REQUEST['wed_sick']."' , wed_unpaid = '".$_REQUEST['wed_unpaid']."' , wed_total = '".$_REQUEST['wed_daily_total']."' , thu_approved = '".$_REQUEST['thu_approved']."' , thu_unapproved = '".$_REQUEST['thu_unapproved']."' , thu_holiday = '".$_REQUEST['thu_holiday']."' , thu_vacation = '".$_REQUEST['thu_vacation']."' , thu_personal = '".$_REQUEST['thu_personal']."' , thu_sick = '".$_REQUEST['thu_sick']."' , thu_unpaid = '".$_REQUEST['thu_unpaid']."' , thu_total = '".$_REQUEST['thu_daily_total']."' , fri_approved = '".$_REQUEST['fri_approved']."' , fri_unapproved = '".$_REQUEST['fri_unapproved']."' , fri_holiday = '".$_REQUEST['fri_holiday']."' , fri_vacation = '".$_REQUEST['fri_vacation']."' , fri_personal = '".$_REQUEST['fri_personal']."' , fri_sick = '".$_REQUEST['fri_sick']."' , fri_unpaid = '".$_REQUEST['fri_unpaid']."' , fri_total = '".$_REQUEST['fri_daily_total']."' , sat_approved = '".$_REQUEST['sat_approved']."' , sat_unapproved = '".$_REQUEST['sat_unapproved']."' , sat_holiday = '".$_REQUEST['sat_holiday']."' , sat_vacation = '".$_REQUEST['sat_vacation']."' , sat_personal = '".$_REQUEST['sat_personal']."' , sat_sick = '".$_REQUEST['sat_sick']."' , sat_unpaid = '".$_REQUEST['sat_unpaid']."' , sat_total = '".$_REQUEST['sat_daily_total']."' , modified_date = NOW() , timesheet_edited_by = '".$_SESSION['sat_login_id']."' , submit_flag = '1' WHERE id = '".$sql_check_id['id']."'";
			$update = mysql_query($sql);
			$timesheet_id = $sql_check_id['id'];
		//}
		
	$del_vacation = mysql_query("DELETE FROM vacation_track WHERE date BETWEEN '".change_dateformat_rev($staticstart)."' AND '".change_dateformat_rev($staticfinish)."'");
	if($del_vacation)
	{	
		if($_REQUEST['sun_vacation'] != "")
		{
			mysql_query("INSERT INTO vacation_track SET staff_id = '".$staff_id."' , date = '".change_dateformat_rev($all_dates[0])."' , vacation = '".$_REQUEST['sun_vacation']."'");
		}
		if($_REQUEST['mon_vacation'] != "")
		{
			mysql_query("INSERT INTO vacation_track SET staff_id = '".$staff_id."' , date = '".change_dateformat_rev($all_dates[1])."' , vacation = '".$_REQUEST['mon_vacation']."'");
		}
		if($_REQUEST['tue_vacation'] != "")
		{
			mysql_query("INSERT INTO vacation_track SET staff_id = '".$staff_id."' , date = '".change_dateformat_rev($all_dates[2])."' , vacation = '".$_REQUEST['tue_vacation']."'");
		}
		if($_REQUEST['wed_vacation'] != "")
		{
			mysql_query("INSERT INTO vacation_track SET staff_id = '".$staff_id."' , date = '".change_dateformat_rev($all_dates[3])."' , vacation = '".$_REQUEST['wed_vacation']."'");
		}
		if($_REQUEST['thu_vacation'] != "")
		{
			mysql_query("INSERT INTO vacation_track SET staff_id = '".$staff_id."' , date = '".change_dateformat_rev($all_dates[4])."' , vacation = '".$_REQUEST['thu_vacation']."'");
		}
		if($_REQUEST['fri_vacation'] != "")
		{
			mysql_query("INSERT INTO vacation_track SET staff_id = '".$staff_id."' , date = '".change_dateformat_rev($all_dates[5])."' , vacation = '".$_REQUEST['fri_vacation']."'");
		}
		if($_REQUEST['sat_vacation'] != "")
		{
			mysql_query("INSERT INTO vacation_track SET staff_id = '".$staff_id."' , date = '".change_dateformat_rev($all_dates[6])."' , vacation = '".$_REQUEST['sat_vacation']."'");
		}
	}
		
		$inc = 0;
		
		
		if(!empty($_FILES['approved_timesheet_name']['name'][0])){
			foreach($_FILES['approved_timesheet_name']['name'] as $val_files){
			if($_FILES['approved_timesheet_name']['type'][$inc]=='image/jpg' || $_FILES['approved_timesheet_name']['type'][$inc]=='image/jpeg' || $_FILES['approved_timesheet_name']['type'][$inc]=='application/pdf' || $_FILES['approved_timesheet_name']['type'][$inc]=='application/msword' || $_FILES['approved_timesheet_name']['type'][$inc]=='application/docx' || $_FILES['approved_timesheet_name']['type'][$inc] == 'application/vnd.openxmlformats-officedocument.wordprocessingml.document' || $_FILES['approved_timesheet_name']['type'][$inc] == 'application/vnd.ms-excel' || $_FILES['approved_timesheet_name']['type'][$inc] == 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet')
			  {
				$src_subscription_form = $_FILES['approved_timesheet_name']['tmp_name'][$inc];
				$dest_subscription_form = time().$val_files;
				$dest_subscription_form1 = "approved_timesheet/".$dest_subscription_form;
				 copy($src_subscription_form,$dest_subscription_form1);
			  }
			  
			  $sql_timsheet_files = mysql_query("INSERT INTO timesheet_files SET timesheet_id = '".$sql_check_id['id']."' , timesheet_file = '".$dest_subscription_form."'");
			  $inc++;
		}
		}
		
			$sql_check_weekly = mysql_num_rows(mysql_query("SELECT id FROM timesheet_weekly_hours WHERE timesheet_id = '".$timesheet_id."'"));
			if($sql_check_weekly == 0)
			{
				$sql_weekly_hours = "INSERT INTO timesheet_weekly_hours SET timesheet_id = '".$timesheet_id."' , staff_id = '".$staff_id."' , weekly_hours = '".$_REQUEST['weekly_total']."' , timesheet_name = '".$dest_subscription_form."' , explanation = '".$_REQUEST['explanation']."' , client_approval = '".$_REQUEST['client_approval']."' , post_date = NOW() ";
				$insert_weekly_hours = mysql_query($sql_weekly_hours);
			}
			else
			{
				$sql_weekly_hours_update = "UPDATE timesheet_weekly_hours SET weekly_hours = '".$_REQUEST['weekly_total']."' , post_date = NOW()";
				
				if($dest_subscription_form != '')
				{
					$sql_weekly_hours_update.= " , timesheet_name = '".$dest_subscription_form."'";
				}
				
				//if($_REQUEST['explanation'] != '')
				//{
					$sql_weekly_hours_update.= " , explanation = '".$_REQUEST['explanation']."'";
				//}
				
				//if($_REQUEST['client_approval'] != '')
				//{
					$sql_weekly_hours_update.= " , client_approval = '".$_REQUEST['client_approval']."'";
				//}
				
				$sql_weekly_hours_update.= " WHERE timesheet_id = '".$timesheet_id."'";

				
				$update_weekly_hours = mysql_query($sql_weekly_hours_update);
			}
			
			
			
			if($sql_staff_data['associate_type'] == "W2S")
			{
				$holiday_prev = $sql_data['sun_holiday'] + $sql_data['mon_holiday'] + $sql_data['tue_holiday'] + $sql_data['wed_holiday'] + $sql_data['thu_holiday'] + $sql_data['fri_holiday'] + $sql_data['sat_holiday'];
				$sick_prev = $sql_data['sun_sick'] + $sql_data['mon_sick'] + $sql_data['tue_sick'] + $sql_data['wed_sick'] + $sql_data['thu_sick'] + $sql_data['fri_sick'] + $sql_data['sat_sick'];
				$personal_prev = $sql_data['sun_personal'] + $sql_data['mon_personal'] + $sql_data['tue_personal'] + $sql_data['wed_personal'] + $sql_data['thu_personal'] + $sql_data['fri_personal'] + $sql_data['sat_personal'];
				
				
				$holiday_new = $_REQUEST['sun_holiday'] + $_REQUEST['mon_holiday'] + $_REQUEST['tue_holiday'] + $_REQUEST['wed_holiday'] + $_REQUEST['thu_holiday'] + $_REQUEST['fri_holiday'] + $_REQUEST['sat_holiday'];
				$sick_new = $_REQUEST['sun_sick'] + $_REQUEST['mon_sick'] + $_REQUEST['tue_sick'] + $_REQUEST['wed_sick'] + $_REQUEST['thu_sick'] + $_REQUEST['fri_sick'] + $_REQUEST['sat_sick'];
				$personal_new = $_REQUEST['sun_personal'] + $_REQUEST['mon_personal'] + $_REQUEST['tue_personal'] + $_REQUEST['wed_personal'] + $_REQUEST['thu_personal'] + $_REQUEST['fri_personal'] + $_REQUEST['sat_personal'];
				
				$holiday = $holiday_prev - $holiday_new;
				$personal = $personal_prev - $personal_new;
				$sick = $sick_prev - $sick_new;
				$weekly_total = $_REQUEST['weekly_hid'] - $_REQUEST['weekly_total'];
				
				$vacation = $sql_staff_data['factor'] * $weekly_total;
				
					$sql_update_personal = mysql_query("UPDATE staff_personal SET vacation = vacation - '".$vacation."' , holiday = holiday + '".$holiday."' , sick = sick + '".$sick."' , personal = personal + '".$personal."' WHERE staff_id = '".$staff_id."'");
					
					$update_staff_po = mysql_query("UPDATE sat_staff SET purchase_order = purchase_order + '".$weekly_total."' WHERE staff_id = '".$staff_id."'");
			}
			
	$hr_manager = getNameTable("sat_users","email","id",$sql_staff_data['hr_manager']);//"priya@infosolz.com";
	$to_email = getNameTable("sat_email_master","email_address","title","Support Email Address");//"sourav.de@infosolz.com";
	
	
			$timesheet_table='<!DOCTYPE html><html lang="en">
		<head>
			<meta charset="utf-8">
			<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
			<title>HTML</title>
			<meta name="description" content="">
			<meta name="author" content="infosolz">
			<meta name="viewport" content="width=device-width; initial-scale=1.0">
			<link rel="shortcut icon" href="/favicon.ico">
			<link rel="apple-touch-icon" href="/apple-touch-icon.png">
		</head>
		'.$sql_staff_data['firstname'].' '.$sql_staff_data['lastname'].' has submitted the Timesheet of '.$staticstart.' - '.$staticfinish.'.
	<body>
			<table width="100%" border="1" style="border-collapse: collapse; border-color: #ccc; margin: 20px 0 5px;">
			  <tbody>
			  <tr>
					<td align="center" colspan="8" style="background:#d1dfea; color: #373435 !important; font-weight: bold; padding: 10px; margin-bottom:10px; border:none;">
					<p style="margin:0;  color: #666; font-family: Arial,Helvetica,sans-serif;">Timesheet Period : '.$staticstart.' - '.$staticfinish.'</p>
					</td>
				</tr>
				<tr>
					<td style="border:none; height:10px;" colspan="8"></td>
				</tr>
			  <tr>
				<td width="9%" style="background:#f2f2f2; font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">Hours</td>
				<td width="13%" align="center" style="background:#f2f2f2; font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">Sunday<br><span>('.$all_dates[0].')</span></td>
            <td width="13%" align="center" style="background:#f2f2f2; font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">Monday<br><span>('.$all_dates[1].')</span></td>
            <td width="13%" align="center" style="background:#f2f2f2; font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">Tuesday<br><span>('.$all_dates[2].')</span></td>
            <td width="13%" align="center" style="background:#f2f2f2; font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">Wednesday<br><span>('.$all_dates[3].')</span></td>
            <td width="13%" align="center" style="background:#f2f2f2; font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">Thursday<br><span>('.$all_dates[4].')</span></td>
            <td width="13%" align="center" style="background:#f2f2f2; font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">Friday<br><span>('.$all_dates[5].')</span></td>
            <td width="13%" align="center" style="background:#f2f2f2; font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">Saturday<br><span>('.$all_dates[6].')</span></td>
			  </tr>
			  <tr>
				<td style="background:#f2f2f2; font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">Approved</td>
				<td align="center" style="background:#ffa1a5; font-size: 14px;color: #fff; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">'.$_REQUEST['sun_approved'].'</td>
				<td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['mon_approved'].'</td>
				<td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['tue_approved'].'</td>
				<td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['wed_approved'].'</td>
				<td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['thu_approved'].'</td>
				<td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['fri_approved'].'</td>
				<td align="center" style="background:#ffa1a5; font-size: 14px;color: #fff; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">'.$_REQUEST['sat_approved'].'</td>
			  </tr>
			  <tr>
				<td style="background:#f2f2f2; font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">Un-Approved</td>
				<td align="center" style="background:#ffa1a5; font-size: 14px;color: #fff; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">'.$_REQUEST['sun_unapproved'].'</td>
				<td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['mon_unapproved'].'</td>
				<td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['tue_unapproved'].'</td>
				<td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['wed_unapproved'].'</td>
				<td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['thu_unapproved'].'</td>
				<td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['fri_unapproved'].'</td>
				<td align="center" style="background:#ffa1a5; font-size: 14px;color: #fff; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">'.$_REQUEST['sat_unapproved'].'</td>
			  </tr>';
			  
				
			  if($sql_staff_data['associate_type'] == "W2S")
			  {
	$timesheet_table.='<tr>
				<td style="background:#f2f2f2; font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">Holiday</td>
				<td align="center" style="background:#ffa1a5; font-size: 14px;color: #fff; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">'.$_REQUEST['sun_holiday'].'</td>
				<td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['mon_holiday'].'</td>
				<td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['tue_holiday'].'</td>
				<td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['wed_holiday'].'</td>
				<td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['thu_holiday'].'</td>
				<td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['fri_holiday'].'</td>
				<td align="center" style="background:#ffa1a5; font-size: 14px;color: #fff; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">'.$_REQUEST['sat_holiday'].'</td>
			  </tr>
			  <tr>
				<td style="background:#f2f2f2; font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">Vacation</td>
				<td align="center" style="background:#ffa1a5; font-size: 14px;color: #fff; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">'.$_REQUEST['sun_vacation'].'</td>
				<td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['mon_vacation'].'</td>
				<td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['tue_vacation'].'</td>
				<td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['wed_vacation'].'</td>
				<td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['thu_vacation'].'</td>
				<td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['fri_vacation'].'</td>
				<td align="center" style="background:#ffa1a5; font-size: 14px;color: #fff; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">'.$_REQUEST['sat_vacation'].'</td>
			  </tr>
			  <tr>
				<td style="background:#f2f2f2; font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif;font-weight: bold; border-color: #ccc; padding: 8px;">Personal</td>
				<td align="center" style="background:#ffa1a5; font-size: 14px;color: #fff; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">'.$_REQUEST['sun_personal'].'</td>
				<td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['mon_personal'].'</td>
				<td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['tue_personal'].'</td>
				<td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['wed_personal'].'</td>
				<td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['thu_personal'].'</td>
				<td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['fri_personal'].'</td>
				<td align="center" style="background:#ffa1a5; font-size: 14px;color: #fff; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">'.$_REQUEST['sat_personal'].'</td>
			  </tr>
			  <tr>
				<td style="background:#f2f2f2; font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">Sick</td>
				<td align="center" style="background:#ffa1a5; font-size: 14px;color: #fff; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">'.$_REQUEST['sun_sick'].'</td>
				<td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['mon_sick'].'</td>
				<td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['tue_sick'].'</td>
				<td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['wed_sick'].'</td>
				<td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['thu_sick'].'</td>
				<td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['fri_sick'].'</td>
				<td align="center" style="background:#ffa1a5; font-size: 14px;color: #fff; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">'.$_REQUEST['sat_sick'].'</td>
			  </tr>';
			  }
			  
	$timesheet_table.='<tr>
				<td style="background:#f2f2f2; font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">Un-paid Time</td>
				<td align="center" style="background:#ffa1a5; font-size: 14px;color: #fff; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">'.$_REQUEST['sun_unpaid'].'</td>
				<td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['mon_unpaid'].'</td>
				<td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['tue_unpaid'].'</td>
				<td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['wed_unpaid'].'</td>
				<td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['thu_unpaid'].'</td>
				<td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['fri_unpaid'].'</td>
				<td align="center" style="background:#ffa1a5; font-size: 14px;color: #fff; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">'.$_REQUEST['sat_unpaid'].'</td>
			  </tr>
			  <tr>
				<td align="left" style="background:#fff; font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">Daily TOTAL</td>
			   <td align="center" style="background:#ffa1a5; font-size: 14px;color: #fff; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">'.$_REQUEST['sun_total'].'</td>
				<td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['mon_total'].'</td>
				<td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['tue_total'].'</td>
				<td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['wed_total'].'</td>
				<td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['thu_total'].'</td>
				<td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['fri_total'].'</td>
				<td align="center" style="background:#ffa1a5; font-size: 14px;color: #fff; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">'.$_REQUEST['sat_total'].'</td>
			  </tr>
			  <tr>
				<td align="right" colspan="7" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">Weekly Total</td>
				<td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['weekly_total'].'</td>
			 </tr>
			 
		   </tbody>    
		</table>';
		if($_REQUEST['explanation']!=''){  
	$timesheet_table.='<table width="100%" border="0" style=" border: 1px solid #ccc; padding: 4px; margin: 25px 0 0;">
		  <tbody>
			<tr class="nobg">
				<td colspan="2" style="padding: 6px;color: #666; font-family: Arial,Helvetica,sans-serif;">
					<h2 style="margin: 0;">Explanation :</h2>
				</td>
			</tr>
			  <tr>
				<td width="300px" style="background:#eee; padding: 6px;color: #666; font-family: Arial,Helvetica,sans-serif;">Explanation for >40Hrs. : </td>
				<td style="background:#eee; padding: 6px;color: #666; font-family: Arial,Helvetica,sans-serif;">'.$_REQUEST['explanation'].'</td>
			  </tr>    		
		   </tbody></table>';
		}
		if($_REQUEST['client_approval'] == 'yes'){
$timesheet_table.='<table width="100%" border="0" style=" border: 1px solid #ccc; padding: 4px; margin: 25px 0 0;">
      <tbody>
	  <tr>
            <td width="300px" style="background:#eee; padding: 6px;color: #666; font-family: Arial,Helvetica,sans-serif;">Client Approval</td>
            <td style="background:#eee; padding: 6px;color: #666; font-family: Arial,Helvetica,sans-serif;">
            	Yes
            </td>
          </tr>  
	  </tbody></table>';
	}
		   
	$timesheet_table.='</body></html>';
	
			if($dest_subscription_form != "")
			{
				$filename = $dest_subscription_form;
			}
			else
			{
				$filename = $check_submission_id['timesheet_name'];
			}
			
			
			$getTemplate = check_null_value('body','sat_email_template','id','4');
			$getSubject = check_null_value('subject','sat_email_template','id','4');
			$templete_body = emailTempalte($getSubject,$getTemplate);
			
			$templete_body = str_replace("%%timesheet_table%%",$timesheet_table,$templete_body);
			
			$stsattach = 'approved_timesheet/'.$filename;
			
			$from = "itteam@absi-usa.com";
			$to = $to_email;
			$sts = new Mail();
			$sts->From($from);
			$sts->Subject($getSubject);
			$sts->Body($templete_body);
			
			$sts->To($hr_manager);
			$sts->To($to_email);
			$sts->Attach($stsattach);
			$send = $sts->Send();
			
			if($send)
			{
				header("location:timesheet_edit.php?id=".$staff_id."&page=".$_REQUEST['page']."&success=2");
			}
	
	}
	/*else
	{
    	header("location:timesheet_edit.php?id=".$staff_id."&page=".$_REQUEST['page']."&success=3");
	}*/

		
}


/*----------------------------------------------------- End Final Submission ------------------------------------------------*/



?>

<?php if($_REQUEST['success']=='1'){ ?>

<p class="mydiv" style="color:#090; float:left; font-family:Verdana, Geneva, sans-serif; font-size:13px; text-align:left;">Timesheet Saved Successfully</p>

<?php } ?>
<?php if($_REQUEST['success']=='2'){ ?>

<p class="mydiv" style="color:#090; float:left; font-family:Verdana, Geneva, sans-serif; font-size:13px; text-align:left;">Timesheet Submitted Successfully</p>

<?php } ?>
<?php if($_REQUEST['success']=='3'){ ?>

<p class="mydiv" style="color:#F00; float:left; font-family:Verdana, Geneva, sans-serif; font-size:13px; text-align:left;"><?php echo $sql_staff_data['firstname'];?> has not submitted or saved any Timesheet for this period.</p>

<?php } ?>

<div id="success_msg_div"></div>
<table width="100%" border="0" class="tmtbl">
  <tr>
    <td colspan="2">
    	<table width="100%" border="0" cellpadding="0" cellspacing="0" class="tmhead">
          <tr>
            <td align="left"><i class="fa fa-user"></i> User Name : <?php echo getStaffname($staff_id); ?></td>
            <td align="center"><i class="fa fa-check"></i> Visa Status : <?php echo $sql_staff_data['visa_status']; ?>	</td>
            <td align="right"><i class="fa fa-sitemap"></i> Staff Type : <?php echo $sql_staff_data['associate_type']; ?></td>
            <?php /*?><td align="right">Date : <?php echo date("m-d-Y");?></td><?php */?>
          </tr>
          <?php /*?><tr>
            <td align="left">Staff Code :  <?php echo $sql_staff_data['staff_code']; ?></td>
            <td>Staff Type : <?php echo $sql_staff_data['associate_type']; ?></td>
            <td align="right">Time : <?php echo date("h:i A"); ?></td>
          </tr><?php */?>
        </table>
    </td>
  </tr>
  <tr>
    <td align="center" colspan="2">
    	<form name="staff_edit_frm" id="staff_edit_frm" method="post" action="">
    	<table width="100%" border="0" class="tmfrm">
          <tr>
            <td>First Name : <span>*</span> </td>
            <td><div class="edit" style="display:none;">
            	<input type="text" name="firstname" id="firstname" value="<?php echo $sql_staff_data['firstname'];?>" class="borderbtm validate[required,custom[onlyLetterSp]]" /></div>
                <div class="edit1">
                <?php echo $sql_staff_data['firstname'];?></div>
            </td>
          <!--</tr>
          <tr>-->
          	 <td>Last Name : <span>*</span></td>
          	 <td>
             <div class="edit" style="display:none;">
             <input type="text" name="lastname" id="lastname" value="<?php echo $sql_staff_data['lastname'];?>" class="borderbtm validate[required,custom[onlyLetterSp]]" />
             </div>
             <div class="edit1">
                <?php echo $sql_staff_data['lastname'];?></div>
             </td>
          </tr>
          
          <tr>
            <td>Phone (Work) : </td>
            <td>
            <?php 
			$wphone1 = substr($sql_staff_data['work_phone_no'],0,3);
			$wphone2 = substr($sql_staff_data['work_phone_no'],3,3);
			$wphone3 = substr($sql_staff_data['work_phone_no'],6,4); 
			?>
            <div class="edit" style="display:none;">
            <?php /*?><input type="text" name="work_phone_no" id="work_phone_no" value="<?php echo $sql_staff_data['work_phone_no']; ?>" class="validate[custom[phone]] borderbtm" onKeyPress="return goodchars(event,'1234567890');" /><?php */?>
            
            <input type="text" style="width:45px; height: 13px; border:#ccc 1px solid !important; " class="textfield validate[minSize[3],maxSize[3]]" onkeyup="javascript:ChangeFocus('work_phone1','work_phone2');" onkeypress="return goodchars(event,'1234567890');" maxlength="3" id="work_phone1" name="work_phone_no1" value="<?php echo $wphone1; ?>">



          -



            <input type="text" class="textfield validate[minSize[3],maxSize[3]]" style="width:45px; height: 13px; border:#ccc 1px solid !important; " onkeyup="javascript:ChangeFocus('work_phone2','work_phone3');" onkeypress="return goodchars(event,'1234567890');" id="work_phone2" maxlength="3" name="work_phone_no2" value="<?php echo $wphone2; ?>">



            -



            <input type="text" class="textfield validate[minSize[4],maxSize[4]]" style="width:54px; height: 13px; border:#ccc 1px solid !important; " onkeypress="return goodchars(event,'1234567890');" id="work_phone3" maxlength="4" name="work_phone_no3" value="<?php echo $wphone3; ?>">
            </div>
            <div class="edit1">
                <?php echo $sql_staff_data['work_phone_no'];?></div>
            </td>
         <!-- </tr>   
          
          <tr>-->
            <td>Phone (Cell) : </td>
            <td>
             <?php 
			$cphone1 = substr($sql_staff_data['cphone'],0,3);
			$cphone2 = substr($sql_staff_data['cphone'],3,3);
			$cphone3 = substr($sql_staff_data['cphone'],6,4); 
			?>
            <div class="edit" style="display:none;">
            <?php /*?><input type="text" name="cphone" id="cphone" value="<?php echo $sql_staff_data['cphone']; ?>" class="validate[custom[phone]] borderbtm" onKeyPress="return goodchars(event,'1234567890');" /><?php */?>
            
             <input type="text" style="width:45px; height: 13px; border:#ccc 1px solid !important; " class="textfield validate[minSize[3],maxSize[3]]" onkeyup="javascript:ChangeFocus('cphone1','cphone2');" onkeypress="return goodchars(event,'1234567890');" maxlength="3" id="cphone1" name="cphone1" value="<?php echo $cphone1; ?>">



          -



            <input type="text" class="textfield validate[minSize[3],maxSize[3]]" style="width:45px; height: 13px; border:#ccc 1px solid !important; " onkeyup="javascript:ChangeFocus('cphone2','cphone3');" onkeypress="return goodchars(event,'1234567890');" id="cphone2" maxlength="3" name="cphone2" value="<?php echo $cphone2; ?>">



            -



            <input type="text" class="textfield validate[minSize[4],maxSize[4]]" style="width:54px; height: 13px; border:#ccc 1px solid !important; " onkeypress="return goodchars(event,'1234567890');" id="cphone3" maxlength="4" name="cphone3" value="<?php echo $cphone3; ?>">
             </div>
            <div class="edit1">
                <?php echo $sql_staff_data['cphone'];?></div>
            </td>
          </tr>    
          
          <tr>
            <?php /*?><td>Phone (Other) : </td>
            <td>
            <div class="edit" style="display:none;">
            
            
            <input type="text" style="width:45px; border:#7F9DB9 1px solid !important; " class="textfield validate[minSize[3],maxSize[3]]" onkeyup="javascript:ChangeFocus('hphone1','hphone2');" onkeypress="return goodchars(event,'1234567890');" value="" maxlength="3" id="hphone1" name="hphone1">



          -



            <input type="text" class="textfield validate[minSize[3],maxSize[3]]" style="width:45px; border:#7F9DB9 1px solid !important; " onkeyup="javascript:ChangeFocus('hphone2','hphone3');" onkeypress="return goodchars(event,'1234567890');" value="" id="hphone2" maxlength="3" name="hphone2">



            -



            <input type="text" class="textfield validate[minSize[4],maxSize[4]]" style="width:54px; border:#7F9DB9 1px solid !important; " onkeypress="return goodchars(event,'1234567890');" value="" id="hphone3" maxlength="4" name="hphone3">
            <div class="edit1">
                <?php echo $sql_staff_data['hphone'];?></div>
            </td><?php */?>
            
          <!--</tr>
           <tr>-->
            <td>Email (Work): </td>
            <td>
            <div class="edit" style="display:none;">
            <input type="text" name="work_email" id="work_email" value="<?php echo $sql_staff_data['work_email']; ?>" class="borderbtm validate[custom[email]]" />
            </div>
            <div class="edit1">
                <?php echo $sql_staff_data['work_email'];?></div>
            </td>
            <td>Email (Personal) : <span>*</span></td>
            <td>
            <div class="edit" style="display:none;">
            <input type="text" name="pemail" id="pemail" value="<?php echo $sql_staff_data['pemail']; ?>" class="borderbtm validate[required ,custom[email]]" /></div>
            <div class="edit1">
                <?php echo $sql_staff_data['pemail'];?></div>
            </td>
           </tr>   
          
          <tr>
            
         <!-- </tr>
          <tr>-->
           <td>Work Location Address : </td>
           <td colspan="3">
           <div class="edit" style="display:none;">
           <textarea  class="borderbtm" name="worksite_street" id="worksite_street"><?php echo $sql_staff_data['worksite_street']; ?></textarea></div>
           <div class="edit1">
                <?php echo $sql_staff_data['worksite_street'];?></div>
           </td>
          </tr>   
          
          <tr>
            <td colspan="4" class="note">‘*’ Mandatory.</td>
            
          </tr>
          <tr>
            <td align="center" colspan="4">
            	<input type="button" class="require float-none" value="Edit Information" onclick="edit_info();">
                <input type="button" id="send_btn" class="require float-none org" value="Send" onclick="update_staff();" style="display:none;">
            </td>
          </tr> 
        </table>
        <input type="hidden" name="staff_id_hid" id="staff_id_hid" value="<?php echo $_REQUEST['id']; ?>"/>
		</form>
    </td>
  </tr>
  <?php
  if($staticstart == "" && $staticfinish == "")
  {
	  $display = "block";
  }
  else
  {
  	  $display = "none";
  }
  ?>
  <form action="" method="post" id="future_form">
  <tr>
     <td colspan="2" align="center">
     <div  id="future_date_div" style="display:<?php echo $display; ?>; margin-top: 25px;">
    	<table width="100%" border="0" class="tmfrm">
          <tr>
            <td width="100">Start Date : </td>
            <td width="200">
            	<input type="text" name="start_date" id="start_date" autocomplete="off" readonly="readonly" />
            </td>
            <td width="100">End Date : </td>
            <td width="200">
            	<input type="text" name="end_date" id="end_date" autocomplete="off" readonly="readonly" />
            </td>
            <td width="70" align="center"><input type="submit" name="future_date" value="Submit" class="require float-none" onclick="return check_period();"></td>
           </tr>
          </table> 
            </div>
     </td>      
  </tr>
  </form>
  
  			<?php
			  if($staticstart != "" && $staticfinish != "")
			  {
			?>
  			<tr><td colspan="2">&nbsp;</td></tr>
  			<tr>
            	<td class="timesheet_main" colspan="2" align="center">
	                <p style="padding-left: 147px;">
		                Timesheet Period : <?php echo $staticstart; ?> - <?php echo $staticfinish; ?>
	                </p>
	                <a class="time_butt require org" href="javascript:void(0);" onClick="open_future_tr();">Enter Another Period</a>
                </td>
            </tr>
            <?php
            if($check_submission > 0)
			{
			?>
            <?php /*?><tr>
            <td align="center">
            	<div style="color:#090; margin:15px 0 0">You have submitted your timesheet of <?php echo $staticstart; ?> - <?php echo $staticfinish; ?> period.</div>
            </td>
            </tr><?php */?>
            <?php
			}
			?>
            
            <?php
            if($sql_staff_data['purchase_order'] < 40)
			{
			?>
            <script type="text/javascript">
			/*$( document ).ready(function() {
				$('#timesheet_form :input').attr('readonly', true);
			});*/
			</script>
            <?php /*?><tr>
            <td align="center">
            	<div style="color:#F00; margin:15px 0 0">You need Minimum 40hrs. of Purchase Order to fill your Timesheet.</div>
            </td>
            </tr><?php */?>
            <?php
			}
			?>
  <tr>
    <td colspan="2">
    <form id="timesheet_form" action="" method="post" enctype="multipart/form-data">
    	<table width="100%" border="1" class="daytbl">
          <tr>
            <td width="11%">Hours</td>
            <td width="13%" align="center">Sunday<br><span>(<?php echo $all_dates[0]; ?>)</span></td>
            <td width="13%" align="center">Monday<br><span>(<?php echo $all_dates[1]; ?>)</span></td>
            <td width="13%" align="center">Tuesday<br><span>(<?php echo $all_dates[2]; ?>)</span></td>
            <td width="13%" align="center">Wednesday<br><span>(<?php echo $all_dates[3]; ?>)</span></td>
            <td width="13%" align="center">Thursday<br><span>(<?php echo $all_dates[4]; ?>)</span></td>
            <td width="13%" align="center">Friday<br><span>(<?php echo $all_dates[5]; ?>)</span></td>
            <td width="13%" align="center">Saturday<br><span>(<?php echo $all_dates[6]; ?>)</span></td>
          </tr>
          <tr>
            <td>Approved</td>
            <td align="center" class="red_bg"><input type="text" name="sun_approved" id="sun_approved" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['sun_approved'];?>" onBlur="alert_staff('sun_approved');" onkeyup="get_daily_total('sun','approved');check_holiday('<?php echo $all_dates[0]; ?>','sun_approved');"/></td>
            <td align="center"><input type="text" name="mon_approved" id="mon_approved" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['mon_approved'];?>" onkeyup="get_daily_total('mon','approved'); get_weekly_total(); check_holiday('<?php echo $all_dates[1]; ?>','mon_approved');"/></td>
            <td align="center"><input type="text" name="tue_approved" id="tue_approved" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['tue_approved'];?>" onkeyup="get_daily_total('tue','approved'); get_weekly_total();check_holiday('<?php echo $all_dates[2]; ?>','tue_approved');"/></td>
            <td align="center"><input type="text" name="wed_approved" id="wed_approved" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['wed_approved'];?>" onkeyup="get_daily_total('wed','approved'); get_weekly_total(); check_holiday('<?php echo $all_dates[3]; ?>','wed_approved');"/></td>
            <td align="center"><input type="text" name="thu_approved" id="thu_approved" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['thu_approved'];?>" onkeyup="get_daily_total('thu','approved'); get_weekly_total(); check_holiday('<?php echo $all_dates[4]; ?>','thu_approved');"/></td>
            <td align="center"><input type="text" name="fri_approved" id="fri_approved" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['fri_approved'];?>" onkeyup="get_daily_total('fri','approved'); get_weekly_total(); check_holiday('<?php echo $all_dates[5]; ?>','fri_approved');"/></td>
            <td align="center" class="red_bg"><input type="text" name="sat_approved" id="sat_approved" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['sat_approved'];?>" onBlur="alert_staff('sat_approved');" onkeyup="get_daily_total('sat','approved');get_weekly_total();check_holiday('<?php echo $all_dates[6]; ?>','sat_approved');"/></td>
          </tr>
          <tr>
            <td>Un-Approved</td>
            <td align="center" class="red_bg"><input type="text" name="sun_unapproved" id="sun_unapproved" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['sun_unapproved'];?>" onBlur="alert_staff('sun_unapproved');" onkeyup="get_daily_total('sun','unapproved'); get_weekly_total();check_holiday('<?php echo $all_dates[0]; ?>','sun_unapproved');"/></td>
            <td align="center"><input type="text" name="mon_unapproved" id="mon_unapproved" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['mon_unapproved'];?>" onkeyup="get_daily_total('mon','unapproved'); get_weekly_total(); check_holiday('<?php echo $all_dates[1]; ?>','mon_unapproved');"/></td>
            <td align="center"><input type="text" name="tue_unapproved" id="tue_unapproved" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['tue_unapproved'];?>" onkeyup="get_daily_total('tue','unapproved'); get_weekly_total(); check_holiday('<?php echo $all_dates[2]; ?>','tue_unapproved');"/></td>
            <td align="center"><input type="text" name="wed_unapproved" id="wed_unapproved" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['wed_unapproved'];?>" onkeyup="get_daily_total('wed','unapproved'); get_weekly_total(); check_holiday('<?php echo $all_dates[3]; ?>','wed_unapproved');"/></td>
            <td align="center"><input type="text" name="thu_unapproved" id="thu_unapproved" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['thu_unapproved'];?>" onkeyup="get_daily_total('thu','unapproved'); get_weekly_total(); check_holiday('<?php echo $all_dates[4]; ?>','thu_unapproved');"/></td>
            <td align="center"><input type="text" name="fri_unapproved" id="fri_unapproved" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['fri_unapproved'];?>" onkeyup="get_daily_total('fri','unapproved'); get_weekly_total(); check_holiday('<?php echo $all_dates[5]; ?>','fri_unapproved');"/></td>
            <td align="center" class="red_bg"><input type="text" name="sat_unapproved" id="sat_unapproved" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['sat_unapproved'];?>" onBlur="alert_staff('sat_unapproved');" onkeyup="get_daily_total('sat','unapproved'); get_weekly_total(); check_holiday('<?php echo $all_dates[6]; ?>','sat_unapproved');"/></td>
          </tr>
          <?php 
		  if($sql_staff_data['associate_type'] == "W2S")
		  {
		  ?>
          <tr>
            <td>Holiday</td>
            <td align="center" class="red_bg"><input type="text" name="sun_holiday" id="sun_holiday" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['sun_holiday'];?>" onBlur="alert_staff('sun_holiday');" onkeyup="get_daily_total('sun','holiday'); get_weekly_total(); check_holiday_total('sun'); check_holiday('<?php echo $all_dates[0]; ?>','sun_holiday');"/></td>
            <td align="center"><input type="text" name="mon_holiday" id="mon_holiday" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['mon_holiday'];?>" onkeyup="get_daily_total('mon','holiday'); get_weekly_total(); check_holiday_total('mon'); check_holiday('<?php echo $all_dates[1]; ?>','mon_holiday');"/></td>
            <td align="center"><input type="text" name="tue_holiday" id="tue_holiday" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['tue_holiday'];?>" onkeyup="get_daily_total('tue','holiday'); get_weekly_total(); check_holiday_total('tue'); check_holiday('<?php echo $all_dates[2]; ?>','tue_holiday');"/></td>
            <td align="center"><input type="text" name="wed_holiday" id="wed_holiday" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['wed_holiday'];?>" onkeyup="get_daily_total('wed','holiday'); get_weekly_total(); check_holiday_total('wed'); check_holiday('<?php echo $all_dates[3]; ?>','wed_holiday');"/></td>
            <td align="center"><input type="text" name="thu_holiday" id="thu_holiday" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['thu_holiday'];?>" onkeyup="get_daily_total('thu','holiday'); get_weekly_total(); check_holiday_total('thu'); check_holiday('<?php echo $all_dates[4]; ?>','thu_holiday');"/></td>
            <td align="center"><input type="text" name="fri_holiday" id="fri_holiday" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['fri_holiday'];?>" onkeyup="get_daily_total('fri','holiday'); get_weekly_total(); check_holiday_total('fri'); check_holiday('<?php echo $all_dates[5]; ?>','fri_holiday');"/></td>
            <td align="center" class="red_bg"><input type="text" name="sat_holiday" id="sat_holiday" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['sat_holiday'];?>" onBlur="alert_staff('sat_holiday');" onkeyup="get_daily_total('sat','holiday'); get_weekly_total(); check_holiday_total('sat'); check_holiday('<?php echo $all_dates[6]; ?>','sat_holiday');"/></td>
          </tr>
          <tr>
            <td>Vacation</td>
            <td align="center" class="red_bg"><input type="text" name="sun_vacation" id="sun_vacation" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['sun_vacation'];?>" onBlur="alert_staff('sun_vacation');" onkeyup="get_daily_total('sun','vacation'); get_weekly_total(); check_vacation_total('sun'); check_holiday('<?php echo $all_dates[0]; ?>','sun_vacation');"/></td>
            <td align="center"><input type="text" name="mon_vacation" id="mon_vacation" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['mon_vacation'];?>" onkeyup="get_daily_total('mon','vacation'); get_weekly_total(); check_vacation_total('mon'); check_holiday('<?php echo $all_dates[1]; ?>','mon_vacation');" /></td>
            <td align="center"><input type="text" name="tue_vacation" id="tue_vacation" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['tue_vacation'];?>" onkeyup="get_daily_total('tue','vacation'); get_weekly_total(); check_vacation_total('tue'); check_holiday('<?php echo $all_dates[2]; ?>','tue_vacation');"/></td>
            <td align="center"><input type="text" name="wed_vacation" id="wed_vacation" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['wed_vacation'];?>" onkeyup="get_daily_total('wed','vacation'); get_weekly_total(); check_vacation_total('wed'); check_holiday('<?php echo $all_dates[3]; ?>','wed_vacation');"/></td>
            <td align="center"><input type="text" name="thu_vacation" id="thu_vacation" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['thu_vacation'];?>" onkeyup="get_daily_total('thu','vacation'); get_weekly_total(); check_vacation_total('thu'); check_holiday('<?php echo $all_dates[4]; ?>','thu_vacation');"/></td>
            <td align="center"><input type="text" name="fri_vacation" id="fri_vacation" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['fri_vacation'];?>" onkeyup="get_daily_total('fri','vacation'); get_weekly_total(); check_vacation_total('fri') check_holiday('<?php echo $all_dates[5]; ?>','fri_vacation');;"/></td>
            <td align="center" class="red_bg"><input type="text" name="sat_vacation" id="sat_vacation" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['sat_vacation'];?>" onBlur="alert_staff('sat_vacation');" onkeyup="get_daily_total('sat','vacation'); get_weekly_total(); check_vacation_total('sat'); check_holiday('<?php echo $all_dates[6]; ?>','sat_vacation');"/></td>
          </tr>
          <tr>
            <td>Personal</td>
            <td align="center" class="red_bg"><input type="text" name="sun_personal" id="sun_personal" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['sun_personal'];?>" onBlur="alert_staff('sun_personal');" onkeyup="get_daily_total('sun','personal'); get_weekly_total(); check_personal_total('sun'); check_holiday('<?php echo $all_dates[0]; ?>','sun_personal');"/></td>
            <td align="center"><input type="text" name="mon_personal" id="mon_personal" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['mon_personal'];?>" onkeyup="get_daily_total('mon','personal'); get_weekly_total(); check_personal_total('mon'); check_holiday('<?php echo $all_dates[1]; ?>','mon_personal');"/></td>
            <td align="center"><input type="text" name="tue_personal" id="tue_personal" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['tue_personal'];?>" onkeyup="get_daily_total('tue','personal'); get_weekly_total(); check_personal_total('tue'); check_holiday('<?php echo $all_dates[2]; ?>','tue_personal');"/></td>
            <td align="center"><input type="text" name="wed_personal" id="wed_personal" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['wed_personal'];?>" onkeyup="get_daily_total('wed','personal'); get_weekly_total(); check_personal_total('wed'); check_holiday('<?php echo $all_dates[3]; ?>','wed_personal');"/></td>
            <td align="center"><input type="text" name="thu_personal" id="thu_personal" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['thu_personal'];?>" onkeyup="get_daily_total('thu','personal'); get_weekly_total(); check_personal_total('thu'); check_holiday('<?php echo $all_dates[4]; ?>','thu_personal');"/></td>
            <td align="center"><input type="text" name="fri_personal" id="fri_personal" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['fri_personal'];?>" onkeyup="get_daily_total('fri','personal'); get_weekly_total(); check_personal_total('fri'); check_holiday('<?php echo $all_dates[5]; ?>','fri_personal');"/></td>
            <td align="center" class="red_bg"><input type="text" name="sat_personal" id="sat_personal" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['sat_personal'];?>" onBlur="alert_staff('sat_personal');" onkeyup="get_daily_total('sat','personal'); get_weekly_total(); check_personal_total('sat'); check_holiday('<?php echo $all_dates[6]; ?>','sat_personal');"/></td>
          </tr>
          <tr>
            <td>Sick</td>
            <td align="center" class="red_bg"><input type="text" name="sun_sick" id="sun_sick" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['sun_sick'];?>" onBlur="alert_staff('sun_sick');" onkeyup="get_daily_total('sun','sick'); get_weekly_total(); check_sick_total('sun'); check_holiday('<?php echo $all_dates[0]; ?>','sun_sick');"/></td>
            <td align="center"><input type="text" name="mon_sick" id="mon_sick" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['mon_sick'];?>" onkeyup="get_daily_total('mon','sick'); get_weekly_total(); check_sick_total('mon'); check_holiday('<?php echo $all_dates[1]; ?>','mon_sick');"/></td>
            <td align="center"><input type="text" name="tue_sick" id="tue_sick" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['tue_sick'];?>" onkeyup="get_daily_total('tue','sick'); get_weekly_total(); check_sick_total('tue'); check_holiday('<?php echo $all_dates[2]; ?>','tue_sick');"/></td>
            <td align="center"><input type="text" name="wed_sick" id="wed_sick" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['wed_sick'];?>" onkeyup="get_daily_total('wed','sick'); get_weekly_total(); check_sick_total('wed'); check_holiday('<?php echo $all_dates[3]; ?>','wed_sick');"/></td>
            <td align="center"><input type="text" name="thu_sick" id="thu_sick" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['thu_sick'];?>" onkeyup="get_daily_total('thu','sick'); get_weekly_total(); check_sick_total('thu'); check_holiday('<?php echo $all_dates[4]; ?>','thu_sick');"/></td>
            <td align="center"><input type="text" name="fri_sick" id="fri_sick" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['fri_sick'];?>" onkeyup="get_daily_total('fri','sick'); get_weekly_total(); check_sick_total('fri'); check_holiday('<?php echo $all_dates[5]; ?>','fri_sick');"/></td>
            <td align="center" class="red_bg"><input type="text" name="sat_sick" id="sat_sick" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['sat_sick'];?>" onBlur="alert_staff('sat_sick');" onkeyup="get_daily_total('sat','sick'); get_weekly_total(); check_sick_total('sat'); check_holiday('<?php echo $all_dates[6]; ?>','sat_sick');"/></td>
          </tr>
          <?php
		  }
		  ?>
          <tr>
            <td>Un-paid Time</td>
            <td align="center" class="red_bg"><input type="text" name="sun_unpaid" id="sun_unpaid" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['sun_unpaid'];?>" onBlur="alert_staff('sun_unpaid');" onkeyup="get_daily_total('sun','unpaid'); get_weekly_total(); check_holiday('<?php echo $all_dates[0]; ?>','sun_unpaid');"/></td>
            <td align="center"><input type="text" name="mon_unpaid" id="mon_unpaid" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['mon_unpaid'];?>" onkeyup="get_daily_total('mon','unpaid'); get_weekly_total(); check_holiday('<?php echo $all_dates[1]; ?>','mon_unpaid');" /></td>
            <td align="center"><input type="text" name="tue_unpaid" id="tue_unpaid" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['tue_unpaid'];?>" onkeyup="get_daily_total('tue','unpaid'); get_weekly_total(); check_holiday('<?php echo $all_dates[2]; ?>','tue_unpaid');"/></td>
            <td align="center"><input type="text" name="wed_unpaid" id="wed_unpaid" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['wed_unpaid'];?>" onkeyup="get_daily_total('wed','unpaid'); get_weekly_total(); check_holiday('<?php echo $all_dates[3]; ?>','wed_unpaid');"/></td>
            <td align="center"><input type="text" name="thu_unpaid" id="thu_unpaid" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['thu_unpaid'];?>" onkeyup="get_daily_total('thu','unpaid'); get_weekly_total(); check_holiday('<?php echo $all_dates[4]; ?>','thu_unpaid');"/></td>
            <td align="center"><input type="text" name="fri_unpaid" id="fri_unpaid" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['fri_unpaid'];?>" onkeyup="get_daily_total('fri','unpaid'); get_weekly_total(); check_holiday('<?php echo $all_dates[5]; ?>','fri_unpaid');"/></td>
            <td align="center" class="red_bg"><input type="text" name="sat_unpaid" id="sat_unpaid" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['sat_unpaid'];?>" onBlur="alert_staff('sat_unpaid');" onkeyup="get_daily_total('sat','unpaid'); get_weekly_total(); check_holiday('<?php echo $all_dates[6]; ?>','sat_unpaid');"/></td>
          </tr>
          <tr>
            <td class="nobg" align="left">Daily TOTAL</td>
            <td align="center"><input type="text" name="sun_daily_total" id="sun_daily_total" value="<?php echo $sql_data['sun_total'];?>" readonly/></td>
            <td align="center"><input type="text" name="mon_daily_total" id="mon_daily_total" value="<?php echo $sql_data['mon_total'];?>" readonly/></td>
            <td align="center"><input type="text" name="tue_daily_total" id="tue_daily_total" value="<?php echo $sql_data['tue_total'];?>" readonly/></td>
            <td align="center"><input type="text" name="wed_daily_total" id="wed_daily_total" value="<?php echo $sql_data['wed_total'];?>" readonly/></td>
            <td align="center"><input type="text" name="thu_daily_total" id="thu_daily_total" value="<?php echo $sql_data['thu_total'];?>" readonly/></td>
            <td align="center"><input type="text" name="fri_daily_total" id="fri_daily_total" value="<?php echo $sql_data['fri_total'];?>" readonly/></td>
            <td align="center"><input type="text" name="sat_daily_total" id="sat_daily_total" value="<?php echo $sql_data['sat_total'];?>" readonly/></td>
          </tr>
          <tr>
           <td  colspan="2" class="nobg" align="left">Upload your approved Timesheet</td>
            
            <td colspan="4" align="left"><input type="file" name="approved_timesheet_name[]" id="approved_timesheet" multiple="multiple" />
            
            <?php 
			$sql_timesheet_files = mysql_query("SELECT * FROM timesheet_files WHERE timesheet_id = '".$sql_data['id']."'");
			$ii = 1;
			while($array_timesheet_files = mysql_fetch_array($sql_timesheet_files)){ ?>
            	<?php echo $ii; ?>. <a href="approved_timesheet/<?php echo $array_timesheet_files['timesheet_file'];?>" class="used_cls"> Uploaded Timesheet </a><img src="images/delete_icon.png" alt="delete" /><br />
            <?php
			$ii++;
			}
			?>
            
            <?php /*?><?php if($check_submission_id['timesheet_name']!=''){ ?>
            	<a href="approved_timesheet/<?php echo $check_submission_id['timesheet_name'];?>" class="used_cls"> Uploaded Timesheet </a>
            <?php } ?><?php */?>
            </td>
            <td class="nobg" align="right">Weekly Total</td>
            
            <td align="center"><input type="text" name="weekly_total" id="weekly_total" readonly /></td>
         </tr>
         <?php
		 if($sql_data['modified_by'] != "")
		 {
		 ?>
        <tr class="tblftr">
            <td align="left" colspan="6">Last Updated By: 
			<?php
			if($sql_data['timesheet_edited_by'] != "0")
			{
				echo getUsername($sql_data['timesheet_edited_by']);
			}
			else
			{
				 echo getStaffname($sql_data['modified_by']);
			}
			?></td>
            <td align="right" colspan="2" >Date: <?php echo date("m-d-Y",strtotime($sql_data['modified_date'])); ?></td>
        </tr>
         <?php
		 }
		 ?>
      </table> 
		<?php /*?><span class="note">Note : '*' for W2 Salary Only</span><?php */?>
    </td>
  </tr>
  <?php
  if($check_submission_id['explanation'] != "")
  {
	  $display_exp = "block";
  }
  else
  {
	  $display_exp = "none";
  }
  ?>
  <tr>
    <td colspan="2" align="center">
    <div id="explain_div" style="display:<?php echo $display_exp;?>">
    	<table width="100%" border="0" class="tmfrm mrgntop25">
    		<tr class="nobg">
    			<td colspan="2">
    				<h2>Explanation :</h2>
    			</td>
    		</tr>
          <tr>
            <td width="300px">Explanation for >40Hrs. : </td>
            <td>
            	<textarea id="explanation" name="explanation" class="validate[required] borderbtm"><?php echo $check_submission_id['explanation']; ?> </textarea>
            </td>
          </tr> 
       </table> 
       </div> 
      
	</td>
  </tr>
  
  <?php
  if($check_submission_id['client_approval'] != "")
  {
	  $display_agr = "block";
  }
  else
  {
	  $display_agr = "none";
  }
  ?>
  <tr>
  	<td>
  		<div id="agree_div" style="display:<?php echo $display_agr; ?>">
	  		<table width="100%" border="0" class="tmfrm mrgntop25">
	  		  <tr>
	            <td width="300px">Client Approval</td>
	            <td>
	            	<label><input type="radio" name="client_approval" class="validate[required]" id="client_approval" value="Yes" <?php if($check_submission_id['client_approval'] == "Yes") { ?> checked="checked" <?php } ?> /> Yes</label>
	            	<label><input type="radio" name="client_approval" class="validate[required]" id="client_approval1" value="No" <?php if($check_submission_id['client_approval'] == "No") { ?> checked="checked" <?php } ?> /> No</label>
	            </td>
	          </tr> 
	  		</table>
  		</div>  
  	</td>
  	
  </tr>
   <?php 
   if($sql_company_message['company_message'])
   { ?>
   <tr>
    <td colspan="2" align="center">
    	<table width="100%" border="0" class="mrgntop25 cmtsec">
          <tr>
            <td>
            	<div class="cm-msg">Company Message <i class="fa fa-comment-o"></i> <i class="fa fa-caret-right"></i> </div> 
            	<div class="msg-sec"> 
            		<?php echo $sql_company_message['company_message']; ?>
            	</div> 
            	 <div class="btn-ftrsec">
        		 		<input type="button" class="require float-none gray" value="Refresh" onClick="window.location.reload();">
		                <?php if($sql_data['submit_flag'] != "1")
						{
		                ?>
		                	<input type="submit" name="save" class="require float-none" value="Save">
		                <?php
						}
						?>
		                <input type="submit" name="submit_final" class="require float-none org" value="Submit" onclick="return check_validations();">
        		 </div>
            </td> 
          </tr> 
           </tr>
   <?php
   }
   ?>
   
          
          <?php 
		  	if($sql_data['submit_flag'] == "1")
			{
          ?>
          <tr>
          	<td colspan="2"> <span class="note">Note : ‘*’ This timesheet has been Submitted. You can only submit it, cannot save it.</span> </td>
          </tr>
          <?php
			}
		  ?>
          
          	<?php
   //if($check_submission == 0 && $sql_staff_data['purchase_order'] > 40)
   {
   ?>
          <!-- <tr>
            <td align="center" colspan="2">
            	<input type="button" class="search_go_new_btn" value="Refresh" onClick="window.location.reload();">
                <?php //if($sql_data['submit_flag'] != "1")
				//{
                ?>
                	<input type="submit" name="save" class="search_go_new_btn" value="Save">
                <?php
				//}
				?>
                <input type="submit" name="submit_final" class="search_go_new_btn" value="Submit" onclick="return check_validations();">
            </td>
          </tr>  -->
   <?php
   }
   ?>	
                 
          		<input type="hidden" name="start_date_hid" id="start_date_hid" value="<?php echo $staticstart; ?>" />
                <input type="hidden" name="end_date_hid" id="end_date_hid" value="<?php echo $staticfinish; ?>" />
                <input type="hidden" name="staff_type_hid" id="staff_type_hid" value="<?php echo $sql_staff_data['associate_type']; ?>" />
                <input type="hidden" name="visa_type_hid" id="visa_type_hid" value="<?php echo $sql_staff_data['visa_status']; ?>" />
                <input type="hidden" name="vacation_hid" id="vacation_hid" value="<?php echo $sql_personal_data['vacation']; ?>" />
                <input type="hidden" name="sick_hid" id="sick_hid" value="<?php echo $sql_personal_data['sick']; ?>" />
                <input type="hidden" name="holiday_hid" id="holiday_hid" value="<?php echo $sql_personal_data['holiday']; ?>" />
                <input type="hidden" name="personal_hid" id="personal_hid" value="<?php echo $sql_personal_data['personal']; ?>" />
                <input type="hidden" name="weekly_hid" id="weekly_hid" value="<?php echo $check_submission_id['weekly_hours']; ?>"/>
                <input type="hidden" name="hol_hid" id="hol_hid" value="<?php echo $hol_prev; ?>"/>
                <input type="hidden" name="sic_hid" id="sic_hid" value="<?php echo $sic_prev; ?>"/>
                <input type="hidden" name="pers_hid" id="pers_hid" value="<?php echo $pers_prev; ?>"/>
                
        </table>
    </td> 
  </tr>
  </form>
  <tr>
  <?php
  }
			 ?>
 
    <td colspan="2">&nbsp;</td>
  </tr>
</table>
<div id="dialog-confirm" title="Alert Message" style="display:none;">
<p><span class="ui-icon ui-icon-alert" style="float:left; margin:0 7px 20px 0;"></span>This is a Holiday. Are you sure you have worked on this day?</p>
</div>
<div id="dialog-confirm-holiday" title="Alert Message" style="display:none;">
<p id="alert_msg_id"></p>
</div>
				

<script type="text/javascript">get_weekly_total();</script>

<?php include("includes/footer.php"); ?>