Preview: timesheet1.php
Size: 86.22 KB
/home/jambtst2015/public_html/giraffeng.com/admin/timesheet1.php
<?php include("includes/head.php");?>
<?php
include("includes/header.php");
include ("includes/libmail.php");
function getDates($startTime, $endTime) {
$day = 86400;
$format = 'm-d-Y';
$startTime = strtotime($startTime) - 1;
$endTime = strtotime($endTime);
$numDays = round(($endTime - $startTime) / $day) + 2;
//$numDays = round(($endTime - $startTime) / $day); // remove increment
$days = array();
for ($i = 1; $i < $numDays; $i++) { //change $i to 1
$days[] = date($format, ($startTime + ($i * $day)));
}
return $days;
}
function change_dateformat_get_day($date_form)
{
if($date_form!=''){
$date1=explode("-",$date_form);
$dateformat=$date1[2]."-".$date1[0]."-".$date1[1];
return $dateformat;
}
else{
$dateformat='';
return $dateformat;
}
}
?>
<script src="//code.jquery.com/ui/1.11.2/jquery-ui.js"></script>
<link rel="stylesheet" href="//code.jquery.com/ui/1.11.2/themes/smoothness/jquery-ui.css">
<link rel="stylesheet" href="/resources/demos/style.css">
<script>
$(document).ready(function(){
setTimeout(function(){
$(".mydiv").fadeOut("slow", function () {
$(".mydiv").slideUp("slow");
});
}, 4000);
});
</script>
<script>
$( document ).ready(function() {
var enq_dat = new Date();
$(window).on('load',function() {
$('#end_date').datepicker('option', 'minDate', enq_dat);
});
});
$(function()
{
$('#start_date').datepicker({
changeMonth: true,
changeYear: true,
dateFormat:"mm-dd-yy",
onSelect: function(dateStr) {
var date = $(this).datepicker('getDate');
if (date) {
date.setDate(date.getDate());
}
$('#end_date').datepicker('option', 'minDate', date);
},
beforeShowDay: function(date){
if(date.getDay() == 0){
return [true];
} else {
return [false];
}
}
});
$('#end_date').datepicker({
changeMonth: true,
changeYear: true,
dateFormat:"mm-dd-yy",
onSelect: function (selectedDate) {
var date = $(this).datepicker('getDate');
if (date) {
date.setDate(date.getDate());
}
$('#end_date').datepicker('option', 'maxDate', date || 0);
},
beforeShowDay: function(date){
if(date.getDay() == 6){
return [true];
} else {
return [false];
}
}
});
});
</script>
<script>
jQuery(document).ready(function(){
jQuery("#staff_edit_frm").validationEngine();
});
</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;
}
var fup = document.getElementById('approved_timesheet');
var fileName = fup.value;
var ext = fileName.substring(fileName.lastIndexOf('.') + 1);
if(ext == "pdf" || ext == "doc" || ext == "docx" || ext == "xlsx" || ext == "xlsm" || ext == "xls" || ext == "csv" || ext =="")
{
return true;
}
else
{
alert("Invalid File Type");
$('#approved_timesheet').val('');
fup.focus();
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").slideDown(1000);
return false;
}
else
{
return true;
}
}
}
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 caanot submit with Client Non-Approval Hours.");
return false;
}
else if($("#client_approval").is(":checked"))
{
return true;
}
}
}
function edit_info(){
$(".edit1").hide();
$(".edit").show();
$("#send_btn").show();
}
function update_staff(){
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({
url : 'send_questions.php',
type : 'POST',
data : 'question=' + question,
//dataType : 'json',
beforeSend : function(jqXHR, settings ){
//alert(url);
},
success : function(data, textStatus, jqXHR){
//alert(data);
$("#success_msg_div").html('<p class="mydiv" style="color:#090; float:left; font-family:Verdana, Geneva, sans-serif; font-size:13px; text-align:left;">'+data+'</p>');
close_question_div();
},
/*complete : function(jqXHR, textStatus){
alert(3);
},*/
error : function(jqXHR, textStatus, errorThrown){
}
});
return true;
}
}
function remove_error_msg()
{
var reason = $('#reason').val();
if(reason != ''){
//$j('#error_msg_div').slideDown(200);
$('#error_msg_div').html('');
//return true;
}
else
{
$('#error_msg_div').html('This Field is Required.');
}
}
function check_sick_total(val)
{
var total_sick = $("#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");
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' || $_FILES['approved_timesheet_name']['type'] == 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet')
{
$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']."' , 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'];
}
//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']."' , timesheet_name = '".$dest_subscription_form."' , explanation = '".$_REQUEST['explanation']."' , client_approval = '".$_REQUEST['client_approval']."' , post_date = NOW() ";
$insert_weekly_hours = mysql_query($sql_weekly_hours);
}
else
{
$sql_weekly_hours_update = "UPDATE timesheet_weekly_hours SET weekly_hours = '".$_REQUEST['weekly_total']."' , timesheet_name = '".$dest_subscription_form."' , 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 = "priya@infosolz.com";//getNameTable("sat_users","email","id",$sql_staff_data['hr_manager']);
$to_email = "sourav.de@infosolz.com";//getNameTable("sat_email_master","email_address","title","Support Email Address");
$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>
<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</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</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</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</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</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</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</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>
<tr class="tblftr">
<td align="left" colspan="6" style="background:#f2f2f2; font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">Last Updated By: '.getStaffname($sql_data['modified_by']).'</td>
<td align="right" colspan="2" style="background:#f2f2f2; font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">Date: '.date("m-d-Y",strtotime($sql_data['modified_date'])).'</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;">If <40 hrs. Please explain (H1B only) : </td>
<td style="background:#eee; padding: 6px;color: #666; font-family: Arial,Helvetica,sans-serif;">'.$_REQUEST['explanation'].'</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:timesheet1.php");
}
}
/*----------------------------------------------------- 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:timesheet1.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:timesheet1.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">User Name : <?php echo getStaffname($_SESSION['staff_login_id']); ?></td>
<td>Visa Status : <?php echo $sql_staff_data['visa_status']; ?> </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" autocomplete="off" readonly="readonly" />
</td>
<td width="100">End Date : </td>
<td width="200">
<input type="text" name="end_date" id="end_date" autocomplete="off" readonly="readonly" />
</td>
<td width="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"> </td></tr>
<tr>
<td class="timesheet_main" colspan="2" align="center">
<p>
<a class="time_butt" style="float:left;" href="javascript:void(0);" onClick="open_future_tr();">Enter Prior Timesheet</a>
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>
<?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['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</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');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'); 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'); 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'); 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'); 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'); 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');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'); 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'); 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'); 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'); 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'); 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'); 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'); 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'); 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'); 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'); 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'); 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'); 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'); 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'); 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'); 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'); 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'); 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'); 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'); 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'); 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'); 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'); 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'); 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'); 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'); 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'); 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'); 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'); 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'); 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'); 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'); 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'); 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'); 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'); 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'); 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'); 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'); 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'); 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'); 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'); 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'); 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'); 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" />
<?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 } ?>
</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">If <40 hrs. Please explain (H1B only) : </td>
<td>
<textarea id="explanation" name="explanation" class="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">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_approval1" 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
}
?>
<?php
if($check_submission == 0 && $sql_staff_data['purchase_order'] > 40)
{
?>
<tr>
<td align="center" colspan="2">
<input type="button" class="search_go_new_btn" value="Refresh" onClick="window.location.reload();">
<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
}
?>
<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']; ?>" />
<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>
<tr>
<td colspan="2"> </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" onclick="return ask_question();">
<button type="button" class="pop_srch_butt 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"); ?>
Directory Contents
Dirs: 17 × Files: 180