<?php include("includes/head.php"); ?>
<?php include("includes/header.php"); ?>
<script src="//code.jquery.com/ui/1.11.2/jquery-ui.js"></script>
<link rel="stylesheet" href="//code.jquery.com/ui/1.11.2/themes/smoothness/jquery-ui.css">
<link rel="stylesheet" href="/resources/demos/style.css">
<script>
$(document).ready(function(){

	setTimeout(function(){

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

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

		});

	}, 4000);

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

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

</script>
<script>
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)
{
	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 = '';
	}
	
	$("#"+val+"_daily_total").val(total);
}


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


function check_validations()
{
	if($("#approved_timesheet").val() == "")
	{
		alert("You must upload your approved Timesheet for Submission.");
		return false;
	}
	
	if($("#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($("#staff_type_hid").val() == "Future H1B")
		{
			if($("#explanation").val() == "")
			{
				$("#explain_div").slideDown(1000);
				return false;
			}
			else
			{
				return true;
			}
		}
	}

	
}

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

function update_staff(){
	
	if($("#staff_type_hid").val() == "Future 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.");
		}
	}
}


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

}
</script>
<?php
  	
	if(date('D')!='Sat')
	{    
	  $staticstart = date('m-d-Y',strtotime('last Saturday'));    
	
	}else{
		$staticstart = date('m-d-Y');   
	}
	
	
	if(date('D')!='Fri')
	{
		$staticfinish = date('m-d-Y',strtotime('next Friday'));
	}else{
	
		$staticfinish = date('m-d-Y');
	}
  
  ?>
  
<?php
$sql_staff_data = mysql_fetch_array(mysql_query("SELECT * FROM sat_staff WHERE staff_id = '".$_SESSION['staff_login_id']."'"));
?>

<?php
$staff_id = $_SESSION['staff_login_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)."'"));

/*echo "<pre>";
print_r($sql_data);
*/
if($_REQUEST['future_date'] == "Submit")
{
	$start_date = $_REQUEST['start_date'];
	$end_date = $_REQUEST['end_date'];
}

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

if($_REQUEST['submit_final'] == "Submit")
{
	include("image_file.php");
	
	if($_FILES['approved_timesheet_name']['type']=='application/pdf' || $_FILES['approved_timesheet_name']['type']=='application/msword' || $_FILES['approved_timesheet_name']['type']=='application/docx' || $_FILES['approved_timesheet_name']['type'] == 'application/vnd.openxmlformats-officedocument.wordprocessingml.document' || $_FILES['approved_timesheet_name']['type'] == 'application/vnd.ms-excel')
  {
	$src_subscription_form = $_FILES['approved_timesheet_name']['tmp_name'];
	$dest_subscription_form = time().$_FILES['approved_timesheet_name']['name'];
	$dest_subscription_form1 = "approved_timesheet/".$dest_subscription_form;
	//exit;
	 copy($src_subscription_form,$dest_subscription_form1);
  }
	
	$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);
		$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']."' WHERE id = '".$sql_check_id['id']."'";
		$update = mysql_query($sql);
		$timesheet_id = $sql_check_id['id'];
	}
		
		
	
	
		
		$sql_weekly_hours = "INSERT INTO timesheet_weekly_hours SET timesheet_id = '".$timesheet_id."' , staff_id = '".$staff_id."' , weekly_hours = '".$_REQUEST['weekly_total']."' , timesheet_name = '".$dest_subscription_form."' , explanation = '".$_REQUEST['explanation']."' , client_approval = '".$_REQUEST['client_approval']."' , post_date = NOW() ";
		$insert_weekly_hours = mysql_query($sql_weekly_hours);
		
		
$hr_manager = getNameTable("sat_users","email","id",$sql_staff_data['hr_manager']);
$to_email = getNameTable("sat_email_master","email_address","title","Support Email Address");
		
}


/*-----------------------------------------------------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);
		if($insert)
		{
			header("location:timesheet.php?success=1");
		}
	}
	else
	{
		$sql = "UPDATE timesheet SET sun_approved = '".$_REQUEST['sun_approved']."' , sun_unapproved = '".$_REQUEST['sun_unapproved']."' , sun_holiday = '".$_REQUEST['sun_holiday']."' , sun_vacation = '".$_REQUEST['sun_vacation']."' , sun_personal = '".$_REQUEST['sun_personal']."' , sun_sick = '".$_REQUEST['sun_sick']."' , sun_unpaid = '".$_REQUEST['sun_unpaid']."' , sun_total = '".$_REQUEST['sun_daily_total']."' , mon_approved = '".$_REQUEST['mon_approved']."' , mon_unapproved = '".$_REQUEST['mon_unapproved']."' , mon_holiday = '".$_REQUEST['mon_holiday']."' , mon_vacation = '".$_REQUEST['mon_vacation']."' , mon_personal = '".$_REQUEST['mon_personal']."' , mon_sick = '".$_REQUEST['mon_sick']."' , mon_unpaid = '".$_REQUEST['mon_unpaid']."' , mon_total = '".$_REQUEST['mon_daily_total']."' , tue_approved = '".$_REQUEST['tue_approved']."' , tue_unapproved = '".$_REQUEST['tue_unapproved']."' , tue_holiday = '".$_REQUEST['tue_holiday']."' , tue_vacation = '".$_REQUEST['tue_vacation']."' , tue_personal = '".$_REQUEST['tue_personal']."' , tue_sick = '".$_REQUEST['tue_sick']."' , tue_unpaid = '".$_REQUEST['tue_unpaid']."' , tue_total = '".$_REQUEST['tue_daily_total']."' , wed_approved = '".$_REQUEST['wed_approved']."' , wed_unapproved = '".$_REQUEST['wed_unapproved']."' , wed_holiday = '".$_REQUEST['wed_holiday']."' , wed_vacation = '".$_REQUEST['wed_vacation']."' , wed_personal = '".$_REQUEST['wed_personal']."' , wed_sick = '".$_REQUEST['wed_sick']."' , wed_unpaid = '".$_REQUEST['wed_unpaid']."' , wed_total = '".$_REQUEST['wed_daily_total']."' , thu_approved = '".$_REQUEST['thu_approved']."' , thu_unapproved = '".$_REQUEST['thu_unapproved']."' , thu_holiday = '".$_REQUEST['thu_holiday']."' , thu_vacation = '".$_REQUEST['thu_vacation']."' , thu_personal = '".$_REQUEST['thu_personal']."' , thu_sick = '".$_REQUEST['thu_sick']."' , thu_unpaid = '".$_REQUEST['thu_unpaid']."' , thu_total = '".$_REQUEST['thu_daily_total']."' , fri_approved = '".$_REQUEST['fri_approved']."' , fri_unapproved = '".$_REQUEST['fri_unapproved']."' , fri_holiday = '".$_REQUEST['fri_holiday']."' , fri_vacation = '".$_REQUEST['fri_vacation']."' , fri_personal = '".$_REQUEST['fri_personal']."' , fri_sick = '".$_REQUEST['fri_sick']."' , fri_unpaid = '".$_REQUEST['fri_unpaid']."' , fri_total = '".$_REQUEST['fri_daily_total']."' , sat_approved = '".$_REQUEST['sat_approved']."' , sat_unapproved = '".$_REQUEST['sat_unapproved']."' , sat_holiday = '".$_REQUEST['sat_holiday']."' , sat_vacation = '".$_REQUEST['sat_vacation']."' , sat_personal = '".$_REQUEST['sat_personal']."' , sat_sick = '".$_REQUEST['sat_sick']."' , sat_unpaid = '".$_REQUEST['sat_unpaid']."' , sat_total = '".$_REQUEST['sat_daily_total']."' , modified_date = NOW() , modified_by = '".$_SESSION['staff_login_id']."' WHERE id = '".$sql_check_id['id']."'";
		$update = mysql_query($sql);
		if($update)
		{
			header("location:timesheet.php?success=1");
		}
	}
}





?>

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

<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">User Name : <?php echo getStaffname($_SESSION['staff_login_id']); ?></td>
            <td>Time Entry :12:16pm	</td>
            <td align="right">Date : <?php echo date("m-d-Y");?></td>
          </tr>
          <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>
        </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]" /></div>
                <div class="edit1">
                <?php echo $sql_staff_data['firstname'];?></div>
            </td>
          <!--</tr>
          <tr>-->
          	 <td>Last Name : <span>*</span></td>
          	 <td>
             <div class="edit" style="display:none;">
             <input type="text" name="lastname" id="lastname" value="<?php echo $sql_staff_data['lastname'];?>" class="borderbtm validate[required]" />
             </div>
             <div class="edit1">
                <?php echo $sql_staff_data['lastname'];?></div>
             </td>
          </tr>
          
          <tr>
            <td>Phone (Work) : </td>
            <td>
            <div class="edit" style="display:none;">
            <input type="text" name="work_phone_no" id="work_phone_no" value="<?php echo $sql_staff_data['work_phone_no']; ?>" class="borderbtm" onKeyPress="return goodchars(event,'1234567890');" />
            </div>
            <div class="edit1">
                <?php echo $sql_staff_data['work_phone_no'];?></div>
            </td>
         <!-- </tr>   
          
          <tr>-->
            <td>Phone (Cell) : </td>
            <td>
            <div class="edit" style="display:none;">
            <input type="text" name="cphone" id="cphone" value="<?php echo $sql_staff_data['cphone']; ?>" class="borderbtm" onKeyPress="return goodchars(event,'1234567890');" />
             </div>
            <div class="edit1">
                <?php echo $sql_staff_data['cphone'];?></div>
            </td>
          </tr>    
          
          <tr>
            <td>Phone (Other) : </td>
            <td>
            <div class="edit" style="display:none;">
            <input type="text" name="hphone" id="hphone" value="<?php echo $sql_staff_data['hphone']; ?>" class="borderbtm" onKeyPress="return goodchars(event,'1234567890');" /></div>
            <div class="edit1">
                <?php echo $sql_staff_data['hphone'];?></div>
            </td>
            
          <!--</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>
           </tr>   
          
          <tr>
            <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>-->
           <td>Work Location Address : </td>
           <td>
           <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">‘*’ Work location address for H1B, at least one Email and Phone Number are Mandatory</td>
            
          </tr>
          <tr>
            <td align="center" colspan="4">
            	<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" value="Send" onclick="update_staff();" style="display:none;">
                <input type="button" class="search_go_new_btn" 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">Forms</a>
            </td>
          </tr> 
        </table>
		</form>
    </td>
  </tr>
  <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" />
            </td>
            <td width="100">End Date : </td>
            <td width="200">
            	<input type="text" name="end_date" id="end_date" />
            </td>
            <td width="87"><input type="submit" name="future_date" value="Submit" class="search_go_new_btn go_srch_nw"></td>
           </tr>
          </table> 
            </div>
     </td>      
  </tr>
  </form>
  
  
  			<tr><td colspan="2">&nbsp;</td></tr>
  			<tr>
            	<td class="timesheet_main" colspan="2" align="center"><p style="padding-left:158px;">Timesheet Period : <?php echo $staticstart; ?> - <?php echo $staticfinish; ?><a class="time_butt" href="javascript:void(0);" onClick="open_future_tr();">Enter Future Timesheet</a></p></td>
            </tr>
  <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="9%">Hours</td>
            <td width="13%" align="center">Sunday</td>
            <td width="13%" align="center">Monday</td>
            <td width="13%" align="center">Tuesday</td>
            <td width="13%" align="center">Wednesday</td>
            <td width="13%" align="center">Thursday</td>
            <td width="13%" align="center">Friday</td>
            <td width="13%" align="center">Saturday</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');"/></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'); get_weekly_total();"/></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'); get_weekly_total();"/></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'); get_weekly_total();"/></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'); get_weekly_total();"/></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'); get_weekly_total();"/></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');get_weekly_total();"/></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'); get_weekly_total();"/></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'); get_weekly_total();"/></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'); get_weekly_total();"/></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'); get_weekly_total();"/></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'); get_weekly_total();"/></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'); get_weekly_total();"/></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'); get_weekly_total();"/></td>
          </tr>
          <?php 
		  if($sql_staff_data['associate_type'] == "W2")
		  {
		  ?>
          <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'); get_weekly_total();"/></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'); get_weekly_total();"/></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'); get_weekly_total();"/></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'); get_weekly_total();"/></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'); get_weekly_total();"/></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'); get_weekly_total();"/></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'); get_weekly_total();"/></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'); get_weekly_total();"/></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'); get_weekly_total();"/></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'); get_weekly_total();"/></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'); get_weekly_total();"/></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'); get_weekly_total();"/></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'); get_weekly_total();"/></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'); get_weekly_total();"/></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'); get_weekly_total();"/></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'); get_weekly_total();"/></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'); get_weekly_total();"/></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'); get_weekly_total();"/></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'); get_weekly_total();"/></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'); get_weekly_total();"/></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'); get_weekly_total();"/></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'); get_weekly_total();"/></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'); get_weekly_total();"/></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'); get_weekly_total();"/></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'); get_weekly_total();"/></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'); get_weekly_total();"/></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'); get_weekly_total();"/></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'); get_weekly_total();"/></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'); get_weekly_total();"/></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'); get_weekly_total();"/></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'); get_weekly_total();"/></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'); get_weekly_total();"/></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'); get_weekly_total();"/></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'); get_weekly_total();"/></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'); get_weekly_total();"/></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="right">Upload your approved Timesheet</td>
            
            <td colspan="4" align="left"><input type="file" name="approved_timesheet_name" id="approved_timesheet" /></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 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">If <40 hrs. Please explain (H1B only) : </td>
            <td>
            	<textarea id="explanation" name="explanation" class="borderbtm"></textarea>
            </td>
          </tr> 
          <tr>
            <td width="300px">I Agree</td>
            <td>
            	<label><input type="radio" name="client_approval" id="client_approval" value="yes" /> Yes</label>
            	<label><input type="radio" name="client_approval" id="client_approval" 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="tmfrm mrgntop25">
        	<tr>
            <td width="300px">Company Message : </td>
            <td>
            	<?php echo $sql_company_message['company_message']; ?>
            </td>
          </tr> 
           </tr>
   <?php
   }
   ?>
          <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> 
          <tr>
          	<td colspan="2"> <span class="note">Note : ‘*’ I have verified my hours as well as personal information of the top section</span> </td>
          </tr>
          
          		<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']; ?>" />
                
        </table>
    </td> 
  </tr>
  </form>
  <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="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;"></div>
                        
                        
                        
                        </div>
                                        
                                        </div>
										
                        		
                        
                            <div class="col-md-offset-3 col-md-9" style="margin-top:10px">
										<input type="button" name="submit_query" id="submit_query" value="Submit" class="search_go_new_btn" onclick="return ask_question();">
                                        <button type="button" class="search_go_new_btn" onclick="close_question_div();">Cancel</button>
                                      </div> 
                                       </div>
                        
                        </div>
                        </div>
                         <div id="fade1" class="black_overlay"> </div>

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

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