<?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 type="text/javascript">
	$( 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();
   });
 

</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;
	}
	
		
	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() == "" && $("#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.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.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_loader").show();
		$.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>');
				$("#ajax_loader").hide();
				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 = $("#sick_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 = $("#holiday_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 = $("#personal_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 > parseFloat(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;
	}
	
}
</script>


<?php
  	
	if($_REQUEST['id']!=''){
		$sql_date = mysql_fetch_array(mysql_query("SELECT * FROM timesheet WHERE id = '".$_REQUEST['id']."'"));
	}
  	
	if($_REQUEST['id']!='')
	{    
	  $staticstart = date("m-d-Y", strtotime($sql_date['date_from']));    
	}elseif(date('D')!='Sun'){
	  $staticstart = date('m-d-Y',strtotime('last Sunday'));
	}else{
	  $staticstart = date('m-d-Y');   
	}
	
	
	if($_REQUEST['id']!='')
	{
		$staticfinish = date("m-d-Y", strtotime($sql_date['date_to']));
	}elseif(date('D')!='Sat'){
		$staticfinish = date('m-d-Y',strtotime('next Saturday'));
	}else{
		$staticfinish = date('m-d-Y');
	}
  
	if($_REQUEST['future_date'] == "Submit")
	{
		$staticstart = $_REQUEST['start_date'];
		$staticfinish = $_REQUEST['end_date'];
	}
	
	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);
	
$staff_id = $_SESSION['staff_login_id'];

$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."'"));

/*--------------------------------------------------------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)
	{
		$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']."'  , submit_flag = '1'";
		$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() , modified_by = '".$_SESSION['staff_login_id']."' , submit_flag = '1' WHERE id = '".$sql_check_id['id']."'";
		$update = mysql_query($sql);
		$timesheet_id = $sql_check_id['id'];
	}
	
	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;
	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 = '".$timesheet_id."' , timesheet_file = '".$dest_subscription_form."'");
		  $inc++;
	}
		
		
		//echo $check_submission;exit;
	
		if($check_submission == 0)
		{
			$sql_weekly_hours = "INSERT INTO timesheet_weekly_hours SET timesheet_id = '".$timesheet_id."' , staff_id = '".$staff_id."' , weekly_hours = '".$_REQUEST['weekly_total']."' , 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']."' , explanation = '".$_REQUEST['explanation']."' , client_approval = '".$_REQUEST['client_approval']."' , post_date = NOW() , WHERE id = '".$check_submission_id['id']."' ";
			$update_weekly_hours = mysql_query($sql_weekly_hours_update);
		}
		
		if($sql_staff_data['associate_type'] == "W2S")
		{
			$holiday = $_REQUEST['sun_holiday'] + $_REQUEST['mon_holiday'] + $_REQUEST['tue_holiday'] + $_REQUEST['wed_holiday'] + $_REQUEST['thu_holiday'] + $_REQUEST['fri_holiday'] + $_REQUEST['sat_holiday'];
			$sick = $_REQUEST['sun_sick'] + $_REQUEST['mon_sick'] + $_REQUEST['tue_sick'] + $_REQUEST['wed_sick'] + $_REQUEST['thu_sick'] + $_REQUEST['fri_sick'] + $_REQUEST['sat_sick'];
			$personal = $_REQUEST['sun_personal'] + $_REQUEST['mon_personal'] + $_REQUEST['tue_personal'] + $_REQUEST['wed_personal'] + $_REQUEST['thu_personal'] + $_REQUEST['fri_personal'] + $_REQUEST['sat_personal'];
			
			$vacation = $sql_staff_data['factor'] * $_REQUEST['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 - '".$_REQUEST['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']!=''){
$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;">
            	'.$_REQUEST['client_approval'].'
            </td>
          </tr>  
	  </tbody></table>';
	}
$timesheet_table.='</body></html>';


		$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/'.$dest_subscription_form;
		
		$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.php?id=".$timesheet_id."");
		}



		
}


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

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.php?success=1&id=".$last_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() , 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.php?success=1&id=".$update_id."");
		}
	}
}





?>

<?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 Updated 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 } ?>

<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($_SESSION['staff_login_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="validate[custom[onlyLetterSp]] borderbtm validate[required]" />
             </div>
             <div class="edit1">
                <?php echo $sql_staff_data['lastname'];?></div>
             </td>
          </tr>
          
          <tr>
            <td>Phone (Work) : </td>
            <td>
            <?php 
			$wphone = explode("-",$sql_staff_data['work_phone_no']);
			?>
            <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[minSize[12],maxSize[12]] 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');" value="<?php echo $wphone[0]; ?>" maxlength="3" id="work_phone1" name="work_phone_no1">



          -



            <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');" value="<?php echo $wphone[1]; ?>" id="work_phone2" maxlength="3" name="work_phone_no2">



            -



            <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');" value="<?php echo $wphone[2]; ?>" id="work_phone3" maxlength="4" name="work_phone_no3">
            </div>
            <div class="edit1">
                <?php echo $sql_staff_data['work_phone_no'];?></div>
            </td>
         <!-- </tr>   
          
          <tr>-->
            <td>Phone (Cell) : </td>
            <td>
            <?php 
			$cphone = explode("-",$sql_staff_data['cphone']);
			?>
            <div class="edit" style="display:none;">
           <?php /*?> <input type="text" name="cphone" id="cphone" value="<?php echo $sql_staff_data['cphone']; ?>" class="validate[minSize[12],maxSize[12]] 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');" value="<?php echo $cphone[0]; ?>" maxlength="3" id="cphone1" name="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');" value="<?php echo $cphone[1]; ?>" id="cphone2" maxlength="3" name="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');" value="<?php echo $cphone[2]; ?>" id="cphone3" maxlength="4" name="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">
            	<div style="min-width: 270px;max-width: 330px; margin: auto;">
	            	<input type="button" class="search_go_new_btn" value="Edit Information" onclick="edit_info();">
	                <input type="button" id="send_btn" class="search_go_new_btn org" value="Send" onclick="update_staff();" style="display:none;">
	                <input type="button" class="search_go_new_btn sky-blue " value="Question" name="submit" onclick="open_question_div();">
	                <?php /*?><input type="submit" class="search_go_new_btn" value="Forms" name="submit"><?php */?>
	                <a href="forms.php" class="search_go_new_btn gray">Forms</a>
	            </div>    
            </td>
          </tr> 
        </table>
		</form>
    </td>
  </tr>
  
  
  <?php if($sql_staff_data['timesheet_flag'] == 'Y'){?>
  <form action="" method="post" id="future_form">
  <tr>
     <td colspan="2" align="center">
     <div  id="future_date_div" style="display:none;">
    	<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" class="no_readonly" />
            </td>
            <td width="100">End Date : </td>
            <td width="200">
            	<input type="text" name="end_date" id="end_date" autocomplete="off" readonly="readonly" class="no_readonly"/>
            </td>
            <td width="87"><input type="submit" name="future_date" value="Submit" class="search_go_new_btn go_srch_nw" onclick="return check_period();"></td>
           </tr>
          </table> 
            </div>
     </td>      
  </tr>
  </form>
  			<tr><td colspan="2">&nbsp;</td></tr>
  			<tr>
            	<td class="timesheet_main" colspan="2" align="center">
                <p>
	                <p>Timesheet Period : <?php echo $staticstart; ?> - <?php echo $staticfinish; ?></p>
	                <a class="require org"  style="margin-bottom: 0 !important;" href="javascript:void(0);" onClick="open_future_tr();">Enter Prior Timesheet</a> 
	                <a class="require sky-blue" style="margin-bottom: 0 !important;" href="javascript:void(0);" onClick="open_future_tr();">Enter Future Timesheet</a>
                </p>
                </td>
            </tr>
            <?php
            if($check_submission > 0)
			{
			?>
            <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
			if($sql_staff_data['po_flag'] == 'Yes'){
				if($sql_staff_data['purchase_order'] < 40)
				{
				?>
				<script type="text/javascript">
				$( document ).ready(function() {
					$('#timesheet_form :input').attr('readonly', true);
				});
				</script>
				<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
				}
			}
			?>
  <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 = '".$_REQUEST['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><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>
  <tr>
    <td colspan="2" align="center">
    <div id="explain_div" style="display:none;">
    	<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"></textarea>
            </td>
          </tr> 
       </table> 
       </div> 
      
	</td>
  </tr>
  
  <tr>
  	<td>
  		<div id="agree_div" style="display:none;">
	  		<table width="100%" border="0" class="tmfrm mrgntop25">
	  		  <tr>
	            <td width="300px">Client Approval</td>
	            <td>
	            	<label><input type="radio" name="client_approval" id="client_approval" class="validate[required]" value="yes" /> Yes</label>
	            	<label><input type="radio" name="client_approval" id="client_approval1" class="validate[required]" value="no" /> 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> 
	            </td>
          </tr> 
           </tr>
   <?php
   }
   ?>
  
          <tr>
          	<td class="ntbg"> <span class="note">Note : ‘*’ I have verified my hours as well as personal information of the top section.</span> </td>
          </tr>
          
           <?php
   if($check_submission == 0)
   {
	   if($sql_staff_data['associate_type'] == "W2S")
	   {
	   		if($sql_staff_data['po_flag'] == 'Yes'){
				if($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();">
                <input type="submit" name="save" class="search_go_new_btn" value="Save">
                <input type="submit" name="submit_final" class="search_go_new_btn" value="Submit" onclick="return check_validations();">
            </td>
          </tr> 
   <?php
				}
	   		}
	   }
	   else
	   {
		?> 
         <tr>
            <td align="center" colspan="2">
            	<input type="button" class="search_go_new_btn" value="Refresh" onClick="window.location.reload();">
                <input type="submit" name="save" class="search_go_new_btn" value="Save">
                <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']; ?>" />
                
        </table>
    </td> 
  </tr>
  </form>
  
  <?php } ?>
  
  
  
  
  <tr>
    <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>
				<div id="question_div" style="display:none;" class="white_content"  >
                    
                    <div class="close close-new" onclick="close_question_div();"><a href = "javascript:void(0);"></a> </div>
                    	<div class="l-contnt up-contnt"> 
                        
                        <h2 class="up_nw_load_nw">Ask you Query</h2>
                        
                        <div class="form-body reason_reject">
                                
                               		<div class="form-group">
										<label class="control-label col-md-4">Query	                                  	
                                        <span class="required">
											* 
										</span>        
										</label>
                                        
                                        <div class="col-md-8 text_pad">
                       
                       <textarea name="query" id="query" onkeyup="remove_error_msg();" class="form_control"></textarea>
                        
                        <div id="error_msg_div" style="color:#F00; margin: 0 0 10px 100px;"></div>
                        
                        
                        
                        </div>
                                        
                                        </div>
										
                        		
                        
                            <div class="col-md-offset-3 col-md-9 submit_main" style="margin-top:10px">
										<input type="button" name="submit_query" id="submit_query" value="Submit" class="pop_srch_butt search_go_new_btn org" onclick="return ask_question();" />
                                        <button type="button" class="pop_srch_butt search_go_new_btn" onclick="close_question_div();">Cancel</button>
                                        <span id="ajax_loader" style="margin-left:50px; display:none;"><img src="images/ajax_loader.gif" /></span>
                                      </div> 
                                       </div>
                        
                        </div>
                        </div>
                         <div id="fade1" class="black_overlay"> </div>

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

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