芝麻web文件管理V1.00

编辑当前文件:/home/jambtst2015/public_html/giraffeng.com/admin/timesheet_edit.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(); }); /*jQuery(document).ready(function(){ jQuery("#timesheet_form").validationEngine(); });*/ </script> <script> function ChangeFocus(cur,nex) { var value=document.getElementById(cur).value; if(value.length==3) { document.getElementById(nex).focus(); } } function getkey(e) { if (window.event) return window.event.keyCode; else if (e) return e.which; else return null; } function goodchars(e, goods) { var key, keychar; key = getkey(e); if (key == null) return true; keychar = String.fromCharCode(key); keychar = keychar.toLowerCase(); goods = goods.toLowerCase(); if (goods.indexOf(keychar) != -1) return true; if ( key==null || key==0 || key==8 || key==9 || key==13 || key==27 ) return true; return false; } </script> <script type="text/javascript"> function open_future_tr() { $("#future_date_div").slideToggle(1500); } function alert_staff(id) { $( "#dialog-confirm" ).dialog({ resizable: false, height:190, width:400, modal: true, buttons: { "Yes": function() { $( this ).dialog( "close" ); }, "No": function() { $( this ).dialog( "close" ); $("#"+id).val(''); var val = id.split('_'); get_daily_total(val[0]) } } }); } </script> <script type="text/javascript"> function get_daily_total(val,type) { if($("#"+val+"_approved").val()) var approved = $("#"+val+"_approved").val(); else var approved = 0; if($("#"+val+"_unapproved").val()) var unapproved = $("#"+val+"_unapproved").val(); else var unapproved = 0; if($("#"+val+"_holiday").val()) var holiday = $("#"+val+"_holiday").val(); else var holiday = 0; if($("#"+val+"_vacation").val()) var vacation = $("#"+val+"_vacation").val(); else var vacation = 0; if($("#"+val+"_sick").val()) var sick = $("#"+val+"_sick").val(); else var sick = 0; if($("#"+val+"_unpaid").val()) var unpaid = $("#"+val+"_unpaid").val(); else var unpaid = 0; if($("#"+val+"_personal").val()) var personal = $("#"+val+"_personal").val(); else var personal = 0; var total = parseFloat(approved) + parseFloat(unapproved) + parseFloat(holiday) + parseFloat(vacation) + parseFloat(sick) + parseFloat(unpaid) + parseFloat(personal); if(total == 0) { total = ''; } if(total > 24 ) { alert("You cannot enter more than 24 hours a day."); $("#"+val+"_"+type).val(''); get_daily_total(); } else { $("#"+val+"_daily_total").val(total); } } function get_weekly_total() { if($("#sun_daily_total").val()) var sunday_total = $("#sun_daily_total").val(); else var sunday_total = 0; if($("#mon_daily_total").val()) var monday_total = $("#mon_daily_total").val(); else var monday_total = 0; if($("#tue_daily_total").val()) var tuesday_total = $("#tue_daily_total").val(); else var tuesday_total = 0; if($("#wed_daily_total").val()) var wednesday_total = $("#wed_daily_total").val(); else var wednesday_total = 0; if($("#thu_daily_total").val()) var thursday_total = $("#thu_daily_total").val(); else var thursday_total = 0; if($("#fri_daily_total").val()) var friday_total = $("#fri_daily_total").val(); else var friday_total = 0; if($("#sat_daily_total").val()) var saturday_total = $("#sat_daily_total").val(); else var saturday_total = 0; var total_week = parseFloat(sunday_total) + parseFloat(monday_total) + parseFloat(tuesday_total) + parseFloat(wednesday_total) + parseFloat(thursday_total) + parseFloat(friday_total) + parseFloat(saturday_total); $("#weekly_total").val(total_week); } /*function check_validations() { if($("#approved_timesheet").val() == "") { alert("You must upload your approved Timesheet for Submission."); return false; } if($("#sun_unapproved").val() != "") { alert("You cannot submit your Timesheet with Unapproved Hours."); return false; } if($("#mon_unapproved").val() != "") { alert("You cannot submit your Timesheet with Unapproved Hours."); return false; } if($("#tue_unapproved").val() != "") { alert("You cannot submit your Timesheet with Unapproved Hours."); return false; } if($("#wed_unapproved").val() != "") { alert("You cannot submit your Timesheet with Unapproved Hours."); return false; } if($("#thu_unapproved").val() != "") { alert("You cannot submit your Timesheet with Unapproved Hours."); return false; } if($("#fri_unapproved").val() != "") { alert("You cannot submit your Timesheet with Unapproved Hours."); return false; } if($("#sat_unapproved").val() != "") { alert("You cannot submit your Timesheet with Unapproved Hours."); return false; } if($("#weekly_total").val() < 40) { if($("#visa_type_hid").val() == "H1B" || $("#staff_type_hid").val() == "W2S") { if($("#explanation").val() == "" && $("#explain_div").css('display') == "none") { $("#explain_div").slideDown(1000); return false; } if($("#explanation").val() == "" && $("#explain_div").css('display') == "block") { alert("Please enter your Explanation to Submit."); $("#explanation").focus(); return false; } } } if($("#weekly_total").val() > 40) { if(!$("input:radio[name='client_approval']").is(":checked")) { $("#agree_div").slideDown(1000); return false; } else if($("#client_approval1").is(":checked")) { alert("You cannot submit with Client Non-Approval Hours."); return false; } } }*/ function edit_info(){ $(".edit1").hide(); $(".edit").show(); $("#send_btn").show(); } function update_staff(){ if(!$("#staff_edit_frm").validationEngine('validate')) { return false; } else { if($("#visa_type_hid").val() == "H1B") { var work_addr = $("#worksite_street").val(); var pemail = $("#work_email").val(); var wemail = $("#pemail").val(); var wphone = $("#work_phone_no").val(); var cphone = $("#cphone").val(); var ophone = $("#hphone").val(); if(work_addr != "" && (pemail != "" || wemail != "") && (wphone != "" || cphone != "" || ophone != "")) { $.ajax({ url : 'update_staff_info.php', type : 'POST', data : $("#staff_edit_frm").serialize(), //dataType : 'json', beforeSend : function(jqXHR, settings ){ //alert(url); }, success : function(data, textStatus, jqXHR){ $("#success_msg_div").html('<p class="mydiv" style="color:#090; float:left; font-family:Verdana, Geneva, sans-serif; font-size:13px; text-align:left;">'+data+'</p>'); //$('#market_div').html(data); }, /*complete : function(jqXHR, textStatus){ alert(3); },*/ error : function(jqXHR, textStatus, errorThrown){ } }); } else { alert("Work location address for H1B, at least one Email and Phone Number are Mandatory."); } } else { $.ajax({ url : 'update_staff_info.php', type : 'POST', data : $("#staff_edit_frm").serialize(), //dataType : 'json', beforeSend : function(jqXHR, settings ){ //alert(url); }, success : function(data, textStatus, jqXHR){ //alert(data); $("#success_msg_div").html('<p class="mydiv" style="color:#090; float:left; font-family:Verdana, Geneva, sans-serif; font-size:13px; text-align:left;">'+data+'</p>'); //$('#market_div').html(data); }, /*complete : function(jqXHR, textStatus){ alert(3); },*/ error : function(jqXHR, textStatus, errorThrown){ } }); } } } function open_question_div() { $("#question_div").show(); $("#fade1").show(); } function close_question_div() { $("#question_div").hide(); $("#fade1").hide(); } function ask_question() { var question = $("#query").val(); if(question == ''){ $('#error_msg_div').html('This Field is Required.'); return false; } else { $.ajax({ url : 'send_questions.php', type : 'POST', data : 'question=' + question, //dataType : 'json', beforeSend : function(jqXHR, settings ){ //alert(url); }, success : function(data, textStatus, jqXHR){ //alert(data); $("#success_msg_div").html('<p class="mydiv" style="color:#090; float:left; font-family:Verdana, Geneva, sans-serif; font-size:13px; text-align:left;">'+data+'</p>'); close_question_div(); }, /*complete : function(jqXHR, textStatus){ alert(3); },*/ error : function(jqXHR, textStatus, errorThrown){ } }); return true; } } function remove_error_msg() { var reason = $('#reason').val(); if(reason != ''){ //$j('#error_msg_div').slideDown(200); $('#error_msg_div').html(''); //return true; } else { $('#error_msg_div').html('This Field is Required.'); } } function check_sick_total(val) { var total_sick = parseFloat($("#sick_hid").val()) + parseFloat($("#sic_hid").val()); if($("#mon_sick").val()) var mon_sick = $("#mon_sick").val(); else var mon_sick = 0; if($("#tue_sick").val()) var tue_sick = $("#tue_sick").val(); else var tue_sick = 0; if($("#wed_sick").val()) var wed_sick = $("#wed_sick").val(); else var wed_sick = 0; if($("#thu_sick").val()) var thu_sick = $("#thu_sick").val(); else var thu_sick = 0; if($("#fri_sick").val()) var fri_sick = $("#fri_sick").val(); else var fri_sick = 0; if($("#sat_sick").val()) var sat_sick = $("#sat_sick").val(); else var sat_sick = 0; if($("#sun_sick").val()) var sun_sick = $("#sun_sick").val(); else var sun_sick = 0; var total = parseFloat(mon_sick) + parseFloat(tue_sick) + parseFloat(wed_sick) + parseFloat(thu_sick) + parseFloat(fri_sick) + parseFloat(sat_sick) + parseFloat(sun_sick); if(total > parseFloat(total_sick)) { alert("You cannot enter more than sick hours you have."); $("#"+val+"_sick").val(''); get_daily_total(val); get_weekly_total(); } } function check_holiday_total(val) { var total_holiday = parseFloat($("#holiday_hid").val()) + parseFloat($("#hol_hid").val()); if($("#mon_holiday").val()) var mon_holiday = $("#mon_holiday").val(); else var mon_holiday = 0; if($("#tue_holiday").val()) var tue_holiday = $("#tue_holiday").val(); else var tue_holiday = 0; if($("#wed_holiday").val()) var wed_holiday = $("#wed_holiday").val(); else var wed_holiday = 0; if($("#thu_holiday").val()) var thu_holiday = $("#thu_holiday").val(); else var thu_holiday = 0; if($("#fri_holiday").val()) var fri_holiday = $("#fri_holiday").val(); else var fri_holiday = 0; if($("#sat_holiday").val()) var sat_holiday = $("#sat_holiday").val(); else var sat_holiday = 0; if($("#sun_holiday").val()) var sun_holiday = $("#sun_holiday").val(); else var sun_holiday = 0; var total = parseFloat(mon_holiday) + parseFloat(tue_holiday) + parseFloat(wed_holiday) + parseFloat(thu_holiday) + parseFloat(fri_holiday) + parseFloat(sat_holiday) + parseFloat(sun_holiday); if(total > parseFloat(total_holiday)) { alert("You cannot enter more than holiday hours you have."); $("#"+val+"_holiday").val(''); get_daily_total(val); get_weekly_total(); } } function check_vacation_total(val) { var total_vacation = $("#vacation_hid").val(); if($("#mon_vacation").val()) var mon_vacation = $("#mon_vacation").val(); else var mon_vacation = 0; if($("#tue_vacation").val()) var tue_vacation = $("#tue_vacation").val(); else var tue_vacation = 0; if($("#wed_vacation").val()) var wed_vacation = $("#wed_vacation").val(); else var wed_vacation = 0; if($("#thu_vacation").val()) var thu_vacation = $("#thu_vacation").val(); else var thu_vacation = 0; if($("#fri_vacation").val()) var fri_vacation = $("#fri_vacation").val(); else var fri_vacation = 0; if($("#sat_vacation").val()) var sat_vacation = $("#sat_vacation").val(); else var sat_vacation = 0; if($("#sun_vacation").val()) var sun_vacation = $("#sun_vacation").val(); else var sun_vacation = 0; var total = parseFloat(mon_vacation) + parseFloat(tue_vacation) + parseFloat(wed_vacation) + parseFloat(thu_vacation) + parseFloat(fri_vacation) + parseFloat(sat_vacation) + parseFloat(sun_vacation); if(total > parseFloat(total_vacation)) { alert("You cannot enter more than vacation hours you have."); $("#"+val+"_vacation").val(''); get_daily_total(val); get_weekly_total(); } } function check_personal_total(val) { var total_personal = parseFloat($("#personal_hid").val()) + parseFloat($("#pers_hid").val()); if($("#mon_personal").val()) var mon_personal = $("#mon_personal").val(); else var mon_personal = 0; if($("#tue_personal").val()) var tue_personal = $("#tue_personal").val(); else var tue_personal = 0; if($("#wed_personal").val()) var wed_personal = $("#wed_personal").val(); else var wed_personal = 0; if($("#thu_personal").val()) var thu_personal = $("#thu_personal").val(); else var thu_personal = 0; if($("#fri_personal").val()) var fri_personal = $("#fri_personal").val(); else var fri_personal = 0; if($("#sat_personal").val()) var sat_personal = $("#sat_personal").val(); else var sat_personal = 0; if($("#sun_personal").val()) var sun_personal = $("#sun_personal").val(); else var sun_personal = 0; var total = parseFloat(mon_personal) + parseFloat(tue_personal) + parseFloat(wed_personal) + parseFloat(thu_personal) + parseFloat(fri_personal) + parseFloat(sat_personal) + parseFloat(sun_personal); if(total > total_personal) { alert("You cannot enter more than personal hours you have."); $("#"+val+"_personal").val(''); get_daily_total(val); get_weekly_total(); } } function check_holiday(date,id) { $.ajax({ url : 'check_holiday.php', type : 'POST', data : 'current_date=' + date, //dataType : 'json', beforeSend : function(jqXHR, settings ){ //alert(url); }, success : function(data, textStatus, jqXHR){ //alert(data); if(data != '') { $("#alert_msg_id").html('<span class="ui-icon ui-icon-alert" style="float:left; margin:0 7px 20px 0;"></span>This is a Holiday as it is '+data+'. Are you sure you have worked on this day?'); $( "#dialog-confirm-holiday" ).dialog({ resizable: false, height:190, width:400, modal: true, buttons: { "Yes": function() { $( this ).dialog( "close" ); }, "No": function() { $( this ).dialog( "close" ); $("#"+id).val(''); var val = id.split('_'); get_daily_total(val[0]) } } }); } }, /*complete : function(jqXHR, textStatus){ alert(3); },*/ error : function(jqXHR, textStatus, errorThrown){ } }); } function check_period() { var oneDay = 24*60*60*1000; // hours*minutes*seconds*milliseconds start_date = $("#start_date").val(); end_date = $("#end_date").val(); new_start_date = start_date.split('-'); new_end_date = end_date.split('-'); var firstDate = new Date(new_start_date[2],new_start_date[0],new_start_date[1]); var secondDate = new Date(new_end_date[2],new_end_date[0],new_end_date[1]); var diffDays = Math.round(Math.abs((firstDate.getTime() - secondDate.getTime())/(oneDay))); if(diffDays!=6) { alert("You cannot select a Timesheet Period More than a Week."); return false; } else { return true; } } function check_validations() { /*if($("#approved_timesheet").val() == "") { alert("You must upload your approved Timesheet for Submission."); return false; }*/ if($('#approved_timesheet').val()!=''){ var ext = $('#approved_timesheet').val().split('.').pop().toLowerCase(); if($.inArray(ext, ['pdf','doc','docx','xlsx','xlsm','xls','csv' , 'jpg','jpeg']) == -1) { alert('Invalid File Type.'); $('#approved_timesheet').val(''); return false; } } /*if($("#mon_daily_total").val() == "") { alert("Please enter your Moday Timesheet hours."); return false; } if($("#tue_daily_total").val() == "") { alert("Please enter your Tuesday Timesheet hours."); return false; } if($("#wed_daily_total").val() == "") { alert("Please enter your Wednesday Timesheet hours."); return false; } if($("#thu_daily_total").val() == "") { alert("Please enter your Thursday Timesheet hours."); return false; } if($("#fri_daily_total").val() == "") { alert("Please enter your Friday Timesheet hours."); return false; }*/ if($("#sun_unapproved").val() != "") { alert("You cannot submit your Timesheet with Unapproved Hours."); return false; } if($("#mon_unapproved").val() != "") { alert("You cannot submit your Timesheet with Unapproved Hours."); return false; } if($("#tue_unapproved").val() != "") { alert("You cannot submit your Timesheet with Unapproved Hours."); return false; } if($("#wed_unapproved").val() != "") { alert("You cannot submit your Timesheet with Unapproved Hours."); return false; } if($("#thu_unapproved").val() != "") { alert("You cannot submit your Timesheet with Unapproved Hours."); return false; } if($("#fri_unapproved").val() != "") { alert("You cannot submit your Timesheet with Unapproved Hours."); return false; } if($("#sat_unapproved").val() != "") { alert("You cannot submit your Timesheet with Unapproved Hours."); return false; } if($("#weekly_total").val() < 40) { if($("#visa_type_hid").val() == "H1B" || $("#staff_type_hid").val() == "W2S") { if($("#explanation").val() == "") { if($("#agree_div").css('display') == "block") { $("#agree_div").slideUp(1000); $("#client_approval1").attr('checked', false) $("#client_approval").attr('checked', false) } $("#explain_div").slideDown(1000); return false; } } } if($("#weekly_total").val() > 40) { if(!$("input:radio[name='client_approval']").is(":checked")) { if($("#explain_div").css('display') == "block") { $("#explain_div").slideUp(1000); $("#explanation").val('') } $("#agree_div").slideDown(1000); return false; } else if($("#client_approval1").is(":checked")) { alert("You caanot submit with Client Non-Approval Hours."); return false; } } } </script> <?php /*if(date('D')!='Sun') { $staticstart = date('m-d-Y',strtotime('last Sunday')); }else{ $staticstart = date('m-d-Y'); } if(date('D')!='Sat') { $staticfinish = date('m-d-Y',strtotime('next Saturday')); }else{ $staticfinish = date('m-d-Y'); }*/ $staff_id = $_REQUEST['id']; if($_REQUEST['future_date'] == "Submit") { $staticstart = $_REQUEST['start_date']; $staticfinish = $_REQUEST['end_date']; $sql_check = mysql_query("SELECT id FROM timesheet WHERE staff_id = '".$staff_id."' AND date_from = '".change_dateformat_rev($staticstart)."' AND date_to = '".change_dateformat_rev($staticfinish)."'"); $sql_check_num = mysql_num_rows($sql_check); /*if($sql_check_num == 0) { header("location:timesheet_edit.php?id=".$staff_id."&page=".$_REQUEST['page']."&success=3"); }*/ } if($_REQUEST['submit_final'] == "Submit") { $staticstart = $_REQUEST['start_date_hid']; $staticfinish = $_REQUEST['end_date_hid']; } $startdate = change_dateformat_get_day($staticstart); $enddate = change_dateformat_get_day($staticfinish); $all_dates = getDates($startdate,$enddate); $sql_staff_data = mysql_fetch_array(mysql_query("SELECT * FROM sat_staff WHERE staff_id = '".$staff_id."'")); ?> <?php if($sql_staff_data['associate_type'] == "W2S") { $sql_personal_data = mysql_fetch_array(mysql_query("SELECT * FROM staff_personal WHERE staff_id = '".$staff_id."'")); } $sql_company_message = mysql_fetch_array(mysql_query("SELECT * FROM company_message_master WHERE staff_type = '".$sql_staff_data['associate_type']."'")); $sql_data = mysql_fetch_array(mysql_query("SELECT * FROM timesheet WHERE staff_id = '".$staff_id."' AND date_from = '".change_dateformat_rev($staticstart)."' AND date_to = '".change_dateformat_rev($staticfinish)."'")); $check_submission = mysql_num_rows(mysql_query("SELECT id FROM timesheet_weekly_hours WHERE timesheet_id = '".$sql_data['id']."' AND staff_id = '".$staff_id."'")); $check_submission_id = mysql_fetch_array(mysql_query("SELECT * FROM timesheet_weekly_hours WHERE timesheet_id = '".$sql_data['id']."' AND staff_id = '".$staff_id."'")); $hol_prev = $sql_data['sun_holiday'] + $sql_data['mon_holiday'] + $sql_data['tue_holiday'] + $sql_data['wed_holiday'] + $sql_data['thu_holiday'] + $sql_data['fri_holiday'] + $sql_data['sat_holiday']; $sic_prev = $sql_data['sun_sick'] + $sql_data['mon_sick'] + $sql_data['tue_sick'] + $sql_data['wed_sick'] + $sql_data['thu_sick'] + $sql_data['fri_sick'] + $sql_data['sat_sick']; $pers_prev = $sql_data['sun_personal'] + $sql_data['mon_personal'] + $sql_data['tue_personal'] + $sql_data['wed_personal'] + $sql_data['thu_personal'] + $sql_data['fri_personal'] + $sql_data['sat_personal']; if($_REQUEST['save'] == "Save") { $sql_check = mysql_query("SELECT id FROM timesheet WHERE staff_id = '".$staff_id."' AND date_from = '".change_dateformat_rev($_REQUEST['start_date_hid'])."' AND date_to = '".change_dateformat_rev($_REQUEST['end_date_hid'])."'"); $sql_check_num = mysql_num_rows($sql_check); $sql_check_id = mysql_fetch_array($sql_check); if($sql_check_num == 0) { $sql = "INSERT INTO timesheet SET staff_id = '".$staff_id."' , date_from = '".change_dateformat_rev($_REQUEST['start_date_hid'])."' , date_to = '".change_dateformat_rev($_REQUEST['end_date_hid'])."' , sun_approved = '".$_REQUEST['sun_approved']."' , sun_unapproved = '".$_REQUEST['sun_unapproved']."' , sun_holiday = '".$_REQUEST['sun_holiday']."' , sun_vacation = '".$_REQUEST['sun_vacation']."' , sun_personal = '".$_REQUEST['sun_personal']."' , sun_sick = '".$_REQUEST['sun_sick']."' , sun_unpaid = '".$_REQUEST['sun_unpaid']."' , sun_total = '".$_REQUEST['sun_daily_total']."' , mon_approved = '".$_REQUEST['mon_approved']."' , mon_unapproved = '".$_REQUEST['mon_unapproved']."' , mon_holiday = '".$_REQUEST['mon_holiday']."' , mon_vacation = '".$_REQUEST['mon_vacation']."' , mon_personal = '".$_REQUEST['mon_personal']."' , mon_sick = '".$_REQUEST['mon_sick']."' , mon_unpaid = '".$_REQUEST['mon_unpaid']."' , mon_total = '".$_REQUEST['mon_daily_total']."' , tue_approved = '".$_REQUEST['tue_approved']."' , tue_unapproved = '".$_REQUEST['tue_unapproved']."' , tue_holiday = '".$_REQUEST['tue_holiday']."' , tue_vacation = '".$_REQUEST['tue_vacation']."' , tue_personal = '".$_REQUEST['tue_personal']."' , tue_sick = '".$_REQUEST['tue_sick']."' , tue_unpaid = '".$_REQUEST['tue_unpaid']."' , tue_total = '".$_REQUEST['tue_daily_total']."' , wed_approved = '".$_REQUEST['wed_approved']."' , wed_unapproved = '".$_REQUEST['wed_unapproved']."' , wed_holiday = '".$_REQUEST['wed_holiday']."' , wed_vacation = '".$_REQUEST['wed_vacation']."' , wed_personal = '".$_REQUEST['wed_personal']."' , wed_sick = '".$_REQUEST['wed_sick']."' , wed_unpaid = '".$_REQUEST['wed_unpaid']."' , wed_total = '".$_REQUEST['wed_daily_total']."' , thu_approved = '".$_REQUEST['thu_approved']."' , thu_unapproved = '".$_REQUEST['thu_unapproved']."' , thu_holiday = '".$_REQUEST['thu_holiday']."' , thu_vacation = '".$_REQUEST['thu_vacation']."' , thu_personal = '".$_REQUEST['thu_personal']."' , thu_sick = '".$_REQUEST['thu_sick']."' , thu_unpaid = '".$_REQUEST['thu_unpaid']."' , thu_total = '".$_REQUEST['thu_daily_total']."' , fri_approved = '".$_REQUEST['fri_approved']."' , fri_unapproved = '".$_REQUEST['fri_unapproved']."' , fri_holiday = '".$_REQUEST['fri_holiday']."' , fri_vacation = '".$_REQUEST['fri_vacation']."' , fri_personal = '".$_REQUEST['fri_personal']."' , fri_sick = '".$_REQUEST['fri_sick']."' , fri_unpaid = '".$_REQUEST['fri_unpaid']."' , fri_total = '".$_REQUEST['fri_daily_total']."' , sat_approved = '".$_REQUEST['sat_approved']."' , sat_unapproved = '".$_REQUEST['sat_unapproved']."' , sat_holiday = '".$_REQUEST['sat_holiday']."' , sat_vacation = '".$_REQUEST['sat_vacation']."' , sat_personal = '".$_REQUEST['sat_personal']."' , sat_sick = '".$_REQUEST['sat_sick']."' , sat_unpaid = '".$_REQUEST['sat_unpaid']."' , sat_total = '".$_REQUEST['sat_daily_total']."' , modified_date = NOW() , modified_by = '".$_SESSION['staff_login_id']."'"; $insert = mysql_query($sql); $last_id = mysql_insert_id(); if($insert) { header("location:timesheet_edit.php?id=".$staff_id."&page=".$_REQUEST['page']."&success=1"); } } else { $sql = "UPDATE timesheet SET sun_approved = '".$_REQUEST['sun_approved']."' , sun_unapproved = '".$_REQUEST['sun_unapproved']."' , sun_holiday = '".$_REQUEST['sun_holiday']."' , sun_vacation = '".$_REQUEST['sun_vacation']."' , sun_personal = '".$_REQUEST['sun_personal']."' , sun_sick = '".$_REQUEST['sun_sick']."' , sun_unpaid = '".$_REQUEST['sun_unpaid']."' , sun_total = '".$_REQUEST['sun_daily_total']."' , mon_approved = '".$_REQUEST['mon_approved']."' , mon_unapproved = '".$_REQUEST['mon_unapproved']."' , mon_holiday = '".$_REQUEST['mon_holiday']."' , mon_vacation = '".$_REQUEST['mon_vacation']."' , mon_personal = '".$_REQUEST['mon_personal']."' , mon_sick = '".$_REQUEST['mon_sick']."' , mon_unpaid = '".$_REQUEST['mon_unpaid']."' , mon_total = '".$_REQUEST['mon_daily_total']."' , tue_approved = '".$_REQUEST['tue_approved']."' , tue_unapproved = '".$_REQUEST['tue_unapproved']."' , tue_holiday = '".$_REQUEST['tue_holiday']."' , tue_vacation = '".$_REQUEST['tue_vacation']."' , tue_personal = '".$_REQUEST['tue_personal']."' , tue_sick = '".$_REQUEST['tue_sick']."' , tue_unpaid = '".$_REQUEST['tue_unpaid']."' , tue_total = '".$_REQUEST['tue_daily_total']."' , wed_approved = '".$_REQUEST['wed_approved']."' , wed_unapproved = '".$_REQUEST['wed_unapproved']."' , wed_holiday = '".$_REQUEST['wed_holiday']."' , wed_vacation = '".$_REQUEST['wed_vacation']."' , wed_personal = '".$_REQUEST['wed_personal']."' , wed_sick = '".$_REQUEST['wed_sick']."' , wed_unpaid = '".$_REQUEST['wed_unpaid']."' , wed_total = '".$_REQUEST['wed_daily_total']."' , thu_approved = '".$_REQUEST['thu_approved']."' , thu_unapproved = '".$_REQUEST['thu_unapproved']."' , thu_holiday = '".$_REQUEST['thu_holiday']."' , thu_vacation = '".$_REQUEST['thu_vacation']."' , thu_personal = '".$_REQUEST['thu_personal']."' , thu_sick = '".$_REQUEST['thu_sick']."' , thu_unpaid = '".$_REQUEST['thu_unpaid']."' , thu_total = '".$_REQUEST['thu_daily_total']."' , fri_approved = '".$_REQUEST['fri_approved']."' , fri_unapproved = '".$_REQUEST['fri_unapproved']."' , fri_holiday = '".$_REQUEST['fri_holiday']."' , fri_vacation = '".$_REQUEST['fri_vacation']."' , fri_personal = '".$_REQUEST['fri_personal']."' , fri_sick = '".$_REQUEST['fri_sick']."' , fri_unpaid = '".$_REQUEST['fri_unpaid']."' , fri_total = '".$_REQUEST['fri_daily_total']."' , sat_approved = '".$_REQUEST['sat_approved']."' , sat_unapproved = '".$_REQUEST['sat_unapproved']."' , sat_holiday = '".$_REQUEST['sat_holiday']."' , sat_vacation = '".$_REQUEST['sat_vacation']."' , sat_personal = '".$_REQUEST['sat_personal']."' , sat_sick = '".$_REQUEST['sat_sick']."' , sat_unpaid = '".$_REQUEST['sat_unpaid']."' , sat_total = '".$_REQUEST['sat_daily_total']."' , modified_date = NOW() , modified_by = '".$_SESSION['staff_login_id']."' WHERE id = '".$sql_check_id['id']."'"; $update = mysql_query($sql); $update_id = $sql_check_id['id']; if($update) { header("location:timesheet_edit.php?id=".$staff_id."&page=".$_REQUEST['page']."&success=1"); } } } /*--------------------------------------------------------Final Submission-----------------------------------------------------*/ if($_REQUEST['submit_final'] == "Submit") { include("image_file.php"); $sql_check = mysql_query("SELECT id FROM timesheet WHERE staff_id = '".$staff_id."' AND date_from = '".change_dateformat_rev($_REQUEST['start_date_hid'])."' AND date_to = '".change_dateformat_rev($_REQUEST['end_date_hid'])."'"); $sql_check_num = mysql_num_rows($sql_check); $sql_check_id = mysql_fetch_array($sql_check); //if($sql_check_num > 0) { /*if($sql_check_num == 0) { $sql = "INSERT INTO timesheet SET staff_id = '".$staff_id."' , date_from = '".change_dateformat_rev($_REQUEST['start_date_hid'])."' , date_to = '".change_dateformat_rev($_REQUEST['end_date_hid'])."' , sun_approved = '".$_REQUEST['sun_approved']."' , sun_unapproved = '".$_REQUEST['sun_unapproved']."' , sun_holiday = '".$_REQUEST['sun_holiday']."' , sun_vacation = '".$_REQUEST['sun_vacation']."' , sun_personal = '".$_REQUEST['sun_personal']."' , sun_sick = '".$_REQUEST['sun_sick']."' , sun_unpaid = '".$_REQUEST['sun_unpaid']."' , sun_total = '".$_REQUEST['sun_daily_total']."' , mon_approved = '".$_REQUEST['mon_approved']."' , mon_unapproved = '".$_REQUEST['mon_unapproved']."' , mon_holiday = '".$_REQUEST['mon_holiday']."' , mon_vacation = '".$_REQUEST['mon_vacation']."' , mon_personal = '".$_REQUEST['mon_personal']."' , mon_sick = '".$_REQUEST['mon_sick']."' , mon_unpaid = '".$_REQUEST['mon_unpaid']."' , mon_total = '".$_REQUEST['mon_daily_total']."' , tue_approved = '".$_REQUEST['tue_approved']."' , tue_unapproved = '".$_REQUEST['tue_unapproved']."' , tue_holiday = '".$_REQUEST['tue_holiday']."' , tue_vacation = '".$_REQUEST['tue_vacation']."' , tue_personal = '".$_REQUEST['tue_personal']."' , tue_sick = '".$_REQUEST['tue_sick']."' , tue_unpaid = '".$_REQUEST['tue_unpaid']."' , tue_total = '".$_REQUEST['tue_daily_total']."' , wed_approved = '".$_REQUEST['wed_approved']."' , wed_unapproved = '".$_REQUEST['wed_unapproved']."' , wed_holiday = '".$_REQUEST['wed_holiday']."' , wed_vacation = '".$_REQUEST['wed_vacation']."' , wed_personal = '".$_REQUEST['wed_personal']."' , wed_sick = '".$_REQUEST['wed_sick']."' , wed_unpaid = '".$_REQUEST['wed_unpaid']."' , wed_total = '".$_REQUEST['wed_daily_total']."' , thu_approved = '".$_REQUEST['thu_approved']."' , thu_unapproved = '".$_REQUEST['thu_unapproved']."' , thu_holiday = '".$_REQUEST['thu_holiday']."' , thu_vacation = '".$_REQUEST['thu_vacation']."' , thu_personal = '".$_REQUEST['thu_personal']."' , thu_sick = '".$_REQUEST['thu_sick']."' , thu_unpaid = '".$_REQUEST['thu_unpaid']."' , thu_total = '".$_REQUEST['thu_daily_total']."' , fri_approved = '".$_REQUEST['fri_approved']."' , fri_unapproved = '".$_REQUEST['fri_unapproved']."' , fri_holiday = '".$_REQUEST['fri_holiday']."' , fri_vacation = '".$_REQUEST['fri_vacation']."' , fri_personal = '".$_REQUEST['fri_personal']."' , fri_sick = '".$_REQUEST['fri_sick']."' , fri_unpaid = '".$_REQUEST['fri_unpaid']."' , fri_total = '".$_REQUEST['fri_daily_total']."' , sat_approved = '".$_REQUEST['sat_approved']."' , sat_unapproved = '".$_REQUEST['sat_unapproved']."' , sat_holiday = '".$_REQUEST['sat_holiday']."' , sat_vacation = '".$_REQUEST['sat_vacation']."' , sat_personal = '".$_REQUEST['sat_personal']."' , sat_sick = '".$_REQUEST['sat_sick']."' , sat_unpaid = '".$_REQUEST['sat_unpaid']."' , sat_total = '".$_REQUEST['sat_daily_total']."' , modified_date = NOW() , modified_by = '".$_SESSION['staff_login_id']."'"; $insert = mysql_query($sql); $timesheet_id = mysql_insert_id(); } else {*/ $sql = "UPDATE timesheet SET sun_approved = '".$_REQUEST['sun_approved']."' , sun_unapproved = '".$_REQUEST['sun_unapproved']."' , sun_holiday = '".$_REQUEST['sun_holiday']."' , sun_vacation = '".$_REQUEST['sun_vacation']."' , sun_personal = '".$_REQUEST['sun_personal']."' , sun_sick = '".$_REQUEST['sun_sick']."' , sun_unpaid = '".$_REQUEST['sun_unpaid']."' , sun_total = '".$_REQUEST['sun_daily_total']."' , mon_approved = '".$_REQUEST['mon_approved']."' , mon_unapproved = '".$_REQUEST['mon_unapproved']."' , mon_holiday = '".$_REQUEST['mon_holiday']."' , mon_vacation = '".$_REQUEST['mon_vacation']."' , mon_personal = '".$_REQUEST['mon_personal']."' , mon_sick = '".$_REQUEST['mon_sick']."' , mon_unpaid = '".$_REQUEST['mon_unpaid']."' , mon_total = '".$_REQUEST['mon_daily_total']."' , tue_approved = '".$_REQUEST['tue_approved']."' , tue_unapproved = '".$_REQUEST['tue_unapproved']."' , tue_holiday = '".$_REQUEST['tue_holiday']."' , tue_vacation = '".$_REQUEST['tue_vacation']."' , tue_personal = '".$_REQUEST['tue_personal']."' , tue_sick = '".$_REQUEST['tue_sick']."' , tue_unpaid = '".$_REQUEST['tue_unpaid']."' , tue_total = '".$_REQUEST['tue_daily_total']."' , wed_approved = '".$_REQUEST['wed_approved']."' , wed_unapproved = '".$_REQUEST['wed_unapproved']."' , wed_holiday = '".$_REQUEST['wed_holiday']."' , wed_vacation = '".$_REQUEST['wed_vacation']."' , wed_personal = '".$_REQUEST['wed_personal']."' , wed_sick = '".$_REQUEST['wed_sick']."' , wed_unpaid = '".$_REQUEST['wed_unpaid']."' , wed_total = '".$_REQUEST['wed_daily_total']."' , thu_approved = '".$_REQUEST['thu_approved']."' , thu_unapproved = '".$_REQUEST['thu_unapproved']."' , thu_holiday = '".$_REQUEST['thu_holiday']."' , thu_vacation = '".$_REQUEST['thu_vacation']."' , thu_personal = '".$_REQUEST['thu_personal']."' , thu_sick = '".$_REQUEST['thu_sick']."' , thu_unpaid = '".$_REQUEST['thu_unpaid']."' , thu_total = '".$_REQUEST['thu_daily_total']."' , fri_approved = '".$_REQUEST['fri_approved']."' , fri_unapproved = '".$_REQUEST['fri_unapproved']."' , fri_holiday = '".$_REQUEST['fri_holiday']."' , fri_vacation = '".$_REQUEST['fri_vacation']."' , fri_personal = '".$_REQUEST['fri_personal']."' , fri_sick = '".$_REQUEST['fri_sick']."' , fri_unpaid = '".$_REQUEST['fri_unpaid']."' , fri_total = '".$_REQUEST['fri_daily_total']."' , sat_approved = '".$_REQUEST['sat_approved']."' , sat_unapproved = '".$_REQUEST['sat_unapproved']."' , sat_holiday = '".$_REQUEST['sat_holiday']."' , sat_vacation = '".$_REQUEST['sat_vacation']."' , sat_personal = '".$_REQUEST['sat_personal']."' , sat_sick = '".$_REQUEST['sat_sick']."' , sat_unpaid = '".$_REQUEST['sat_unpaid']."' , sat_total = '".$_REQUEST['sat_daily_total']."' , modified_date = NOW() , timesheet_edited_by = '".$_SESSION['sat_login_id']."' , submit_flag = '1' WHERE id = '".$sql_check_id['id']."'"; $update = mysql_query($sql); $timesheet_id = $sql_check_id['id']; //} $del_vacation = mysql_query("DELETE FROM vacation_track WHERE date BETWEEN '".change_dateformat_rev($staticstart)."' AND '".change_dateformat_rev($staticfinish)."'"); if($del_vacation) { if($_REQUEST['sun_vacation'] != "") { mysql_query("INSERT INTO vacation_track SET staff_id = '".$staff_id."' , date = '".change_dateformat_rev($all_dates[0])."' , vacation = '".$_REQUEST['sun_vacation']."'"); } if($_REQUEST['mon_vacation'] != "") { mysql_query("INSERT INTO vacation_track SET staff_id = '".$staff_id."' , date = '".change_dateformat_rev($all_dates[1])."' , vacation = '".$_REQUEST['mon_vacation']."'"); } if($_REQUEST['tue_vacation'] != "") { mysql_query("INSERT INTO vacation_track SET staff_id = '".$staff_id."' , date = '".change_dateformat_rev($all_dates[2])."' , vacation = '".$_REQUEST['tue_vacation']."'"); } if($_REQUEST['wed_vacation'] != "") { mysql_query("INSERT INTO vacation_track SET staff_id = '".$staff_id."' , date = '".change_dateformat_rev($all_dates[3])."' , vacation = '".$_REQUEST['wed_vacation']."'"); } if($_REQUEST['thu_vacation'] != "") { mysql_query("INSERT INTO vacation_track SET staff_id = '".$staff_id."' , date = '".change_dateformat_rev($all_dates[4])."' , vacation = '".$_REQUEST['thu_vacation']."'"); } if($_REQUEST['fri_vacation'] != "") { mysql_query("INSERT INTO vacation_track SET staff_id = '".$staff_id."' , date = '".change_dateformat_rev($all_dates[5])."' , vacation = '".$_REQUEST['fri_vacation']."'"); } if($_REQUEST['sat_vacation'] != "") { mysql_query("INSERT INTO vacation_track SET staff_id = '".$staff_id."' , date = '".change_dateformat_rev($all_dates[6])."' , vacation = '".$_REQUEST['sat_vacation']."'"); } } $inc = 0; if(!empty($_FILES['approved_timesheet_name']['name'][0])){ foreach($_FILES['approved_timesheet_name']['name'] as $val_files){ if($_FILES['approved_timesheet_name']['type'][$inc]=='image/jpg' || $_FILES['approved_timesheet_name']['type'][$inc]=='image/jpeg' || $_FILES['approved_timesheet_name']['type'][$inc]=='application/pdf' || $_FILES['approved_timesheet_name']['type'][$inc]=='application/msword' || $_FILES['approved_timesheet_name']['type'][$inc]=='application/docx' || $_FILES['approved_timesheet_name']['type'][$inc] == 'application/vnd.openxmlformats-officedocument.wordprocessingml.document' || $_FILES['approved_timesheet_name']['type'][$inc] == 'application/vnd.ms-excel' || $_FILES['approved_timesheet_name']['type'][$inc] == 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet') { $src_subscription_form = $_FILES['approved_timesheet_name']['tmp_name'][$inc]; $dest_subscription_form = time().$val_files; $dest_subscription_form1 = "approved_timesheet/".$dest_subscription_form; copy($src_subscription_form,$dest_subscription_form1); } $sql_timsheet_files = mysql_query("INSERT INTO timesheet_files SET timesheet_id = '".$sql_check_id['id']."' , timesheet_file = '".$dest_subscription_form."'"); $inc++; } } $sql_check_weekly = mysql_num_rows(mysql_query("SELECT id FROM timesheet_weekly_hours WHERE timesheet_id = '".$timesheet_id."'")); if($sql_check_weekly == 0) { $sql_weekly_hours = "INSERT INTO timesheet_weekly_hours SET timesheet_id = '".$timesheet_id."' , staff_id = '".$staff_id."' , weekly_hours = '".$_REQUEST['weekly_total']."' , timesheet_name = '".$dest_subscription_form."' , explanation = '".$_REQUEST['explanation']."' , client_approval = '".$_REQUEST['client_approval']."' , post_date = NOW() "; $insert_weekly_hours = mysql_query($sql_weekly_hours); } else { $sql_weekly_hours_update = "UPDATE timesheet_weekly_hours SET weekly_hours = '".$_REQUEST['weekly_total']."' , post_date = NOW()"; if($dest_subscription_form != '') { $sql_weekly_hours_update.= " , timesheet_name = '".$dest_subscription_form."'"; } //if($_REQUEST['explanation'] != '') //{ $sql_weekly_hours_update.= " , explanation = '".$_REQUEST['explanation']."'"; //} //if($_REQUEST['client_approval'] != '') //{ $sql_weekly_hours_update.= " , client_approval = '".$_REQUEST['client_approval']."'"; //} $sql_weekly_hours_update.= " WHERE timesheet_id = '".$timesheet_id."'"; $update_weekly_hours = mysql_query($sql_weekly_hours_update); } if($sql_staff_data['associate_type'] == "W2S") { $holiday_prev = $sql_data['sun_holiday'] + $sql_data['mon_holiday'] + $sql_data['tue_holiday'] + $sql_data['wed_holiday'] + $sql_data['thu_holiday'] + $sql_data['fri_holiday'] + $sql_data['sat_holiday']; $sick_prev = $sql_data['sun_sick'] + $sql_data['mon_sick'] + $sql_data['tue_sick'] + $sql_data['wed_sick'] + $sql_data['thu_sick'] + $sql_data['fri_sick'] + $sql_data['sat_sick']; $personal_prev = $sql_data['sun_personal'] + $sql_data['mon_personal'] + $sql_data['tue_personal'] + $sql_data['wed_personal'] + $sql_data['thu_personal'] + $sql_data['fri_personal'] + $sql_data['sat_personal']; $holiday_new = $_REQUEST['sun_holiday'] + $_REQUEST['mon_holiday'] + $_REQUEST['tue_holiday'] + $_REQUEST['wed_holiday'] + $_REQUEST['thu_holiday'] + $_REQUEST['fri_holiday'] + $_REQUEST['sat_holiday']; $sick_new = $_REQUEST['sun_sick'] + $_REQUEST['mon_sick'] + $_REQUEST['tue_sick'] + $_REQUEST['wed_sick'] + $_REQUEST['thu_sick'] + $_REQUEST['fri_sick'] + $_REQUEST['sat_sick']; $personal_new = $_REQUEST['sun_personal'] + $_REQUEST['mon_personal'] + $_REQUEST['tue_personal'] + $_REQUEST['wed_personal'] + $_REQUEST['thu_personal'] + $_REQUEST['fri_personal'] + $_REQUEST['sat_personal']; $holiday = $holiday_prev - $holiday_new; $personal = $personal_prev - $personal_new; $sick = $sick_prev - $sick_new; $weekly_total = $_REQUEST['weekly_hid'] - $_REQUEST['weekly_total']; $vacation = $sql_staff_data['factor'] * $weekly_total; $sql_update_personal = mysql_query("UPDATE staff_personal SET vacation = vacation - '".$vacation."' , holiday = holiday + '".$holiday."' , sick = sick + '".$sick."' , personal = personal + '".$personal."' WHERE staff_id = '".$staff_id."'"); $update_staff_po = mysql_query("UPDATE sat_staff SET purchase_order = purchase_order + '".$weekly_total."' WHERE staff_id = '".$staff_id."'"); } $hr_manager = getNameTable("sat_users","email","id",$sql_staff_data['hr_manager']);//"priya@infosolz.com"; $to_email = getNameTable("sat_email_master","email_address","title","Support Email Address");//"sourav.de@infosolz.com"; $timesheet_table='<!DOCTYPE html><html lang="en"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> <title>HTML</title> <meta name="description" content=""> <meta name="author" content="infosolz"> <meta name="viewport" content="width=device-width; initial-scale=1.0"> <link rel="shortcut icon" href="/favicon.ico"> <link rel="apple-touch-icon" href="/apple-touch-icon.png"> </head> '.$sql_staff_data['firstname'].' '.$sql_staff_data['lastname'].' has submitted the Timesheet of '.$staticstart.' - '.$staticfinish.'. <body> <table width="100%" border="1" style="border-collapse: collapse; border-color: #ccc; margin: 20px 0 5px;"> <tbody> <tr> <td align="center" colspan="8" style="background:#d1dfea; color: #373435 !important; font-weight: bold; padding: 10px; margin-bottom:10px; border:none;"> <p style="margin:0; color: #666; font-family: Arial,Helvetica,sans-serif;">Timesheet Period : '.$staticstart.' - '.$staticfinish.'</p> </td> </tr> <tr> <td style="border:none; height:10px;" colspan="8"></td> </tr> <tr> <td width="9%" style="background:#f2f2f2; font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">Hours</td> <td width="13%" align="center" style="background:#f2f2f2; font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">Sunday<br><span>('.$all_dates[0].')</span></td> <td width="13%" align="center" style="background:#f2f2f2; font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">Monday<br><span>('.$all_dates[1].')</span></td> <td width="13%" align="center" style="background:#f2f2f2; font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">Tuesday<br><span>('.$all_dates[2].')</span></td> <td width="13%" align="center" style="background:#f2f2f2; font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">Wednesday<br><span>('.$all_dates[3].')</span></td> <td width="13%" align="center" style="background:#f2f2f2; font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">Thursday<br><span>('.$all_dates[4].')</span></td> <td width="13%" align="center" style="background:#f2f2f2; font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">Friday<br><span>('.$all_dates[5].')</span></td> <td width="13%" align="center" style="background:#f2f2f2; font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">Saturday<br><span>('.$all_dates[6].')</span></td> </tr> <tr> <td style="background:#f2f2f2; font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">Approved</td> <td align="center" style="background:#ffa1a5; font-size: 14px;color: #fff; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">'.$_REQUEST['sun_approved'].'</td> <td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['mon_approved'].'</td> <td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['tue_approved'].'</td> <td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['wed_approved'].'</td> <td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['thu_approved'].'</td> <td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['fri_approved'].'</td> <td align="center" style="background:#ffa1a5; font-size: 14px;color: #fff; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">'.$_REQUEST['sat_approved'].'</td> </tr> <tr> <td style="background:#f2f2f2; font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">Un-Approved</td> <td align="center" style="background:#ffa1a5; font-size: 14px;color: #fff; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">'.$_REQUEST['sun_unapproved'].'</td> <td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['mon_unapproved'].'</td> <td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['tue_unapproved'].'</td> <td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['wed_unapproved'].'</td> <td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['thu_unapproved'].'</td> <td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['fri_unapproved'].'</td> <td align="center" style="background:#ffa1a5; font-size: 14px;color: #fff; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">'.$_REQUEST['sat_unapproved'].'</td> </tr>'; if($sql_staff_data['associate_type'] == "W2S") { $timesheet_table.='<tr> <td style="background:#f2f2f2; font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">Holiday</td> <td align="center" style="background:#ffa1a5; font-size: 14px;color: #fff; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">'.$_REQUEST['sun_holiday'].'</td> <td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['mon_holiday'].'</td> <td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['tue_holiday'].'</td> <td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['wed_holiday'].'</td> <td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['thu_holiday'].'</td> <td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['fri_holiday'].'</td> <td align="center" style="background:#ffa1a5; font-size: 14px;color: #fff; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">'.$_REQUEST['sat_holiday'].'</td> </tr> <tr> <td style="background:#f2f2f2; font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">Vacation</td> <td align="center" style="background:#ffa1a5; font-size: 14px;color: #fff; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">'.$_REQUEST['sun_vacation'].'</td> <td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['mon_vacation'].'</td> <td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['tue_vacation'].'</td> <td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['wed_vacation'].'</td> <td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['thu_vacation'].'</td> <td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['fri_vacation'].'</td> <td align="center" style="background:#ffa1a5; font-size: 14px;color: #fff; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">'.$_REQUEST['sat_vacation'].'</td> </tr> <tr> <td style="background:#f2f2f2; font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif;font-weight: bold; border-color: #ccc; padding: 8px;">Personal</td> <td align="center" style="background:#ffa1a5; font-size: 14px;color: #fff; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">'.$_REQUEST['sun_personal'].'</td> <td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['mon_personal'].'</td> <td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['tue_personal'].'</td> <td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['wed_personal'].'</td> <td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['thu_personal'].'</td> <td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['fri_personal'].'</td> <td align="center" style="background:#ffa1a5; font-size: 14px;color: #fff; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">'.$_REQUEST['sat_personal'].'</td> </tr> <tr> <td style="background:#f2f2f2; font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">Sick</td> <td align="center" style="background:#ffa1a5; font-size: 14px;color: #fff; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">'.$_REQUEST['sun_sick'].'</td> <td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['mon_sick'].'</td> <td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['tue_sick'].'</td> <td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['wed_sick'].'</td> <td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['thu_sick'].'</td> <td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['fri_sick'].'</td> <td align="center" style="background:#ffa1a5; font-size: 14px;color: #fff; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">'.$_REQUEST['sat_sick'].'</td> </tr>'; } $timesheet_table.='<tr> <td style="background:#f2f2f2; font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">Un-paid Time</td> <td align="center" style="background:#ffa1a5; font-size: 14px;color: #fff; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">'.$_REQUEST['sun_unpaid'].'</td> <td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['mon_unpaid'].'</td> <td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['tue_unpaid'].'</td> <td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['wed_unpaid'].'</td> <td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['thu_unpaid'].'</td> <td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['fri_unpaid'].'</td> <td align="center" style="background:#ffa1a5; font-size: 14px;color: #fff; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">'.$_REQUEST['sat_unpaid'].'</td> </tr> <tr> <td align="left" style="background:#fff; font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">Daily TOTAL</td> <td align="center" style="background:#ffa1a5; font-size: 14px;color: #fff; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">'.$_REQUEST['sun_total'].'</td> <td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['mon_total'].'</td> <td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['tue_total'].'</td> <td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['wed_total'].'</td> <td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['thu_total'].'</td> <td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['fri_total'].'</td> <td align="center" style="background:#ffa1a5; font-size: 14px;color: #fff; font-family: Arial,Helvetica,sans-serif;font-weight: bold;border-color: #ccc; padding: 8px;">'.$_REQUEST['sat_total'].'</td> </tr> <tr> <td align="right" colspan="7" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">Weekly Total</td> <td align="center" style="font-size: 14px;color: #666; font-family: Arial,Helvetica,sans-serif; font-weight: bold; border-color: #ccc; padding: 8px;">'.$_REQUEST['weekly_total'].'</td> </tr> </tbody> </table>'; if($_REQUEST['explanation']!=''){ $timesheet_table.='<table width="100%" border="0" style=" border: 1px solid #ccc; padding: 4px; margin: 25px 0 0;"> <tbody> <tr class="nobg"> <td colspan="2" style="padding: 6px;color: #666; font-family: Arial,Helvetica,sans-serif;"> <h2 style="margin: 0;">Explanation :</h2> </td> </tr> <tr> <td width="300px" style="background:#eee; padding: 6px;color: #666; font-family: Arial,Helvetica,sans-serif;">Explanation for >40Hrs. : </td> <td style="background:#eee; padding: 6px;color: #666; font-family: Arial,Helvetica,sans-serif;">'.$_REQUEST['explanation'].'</td> </tr> </tbody></table>'; } if($_REQUEST['client_approval'] == 'yes'){ $timesheet_table.='<table width="100%" border="0" style=" border: 1px solid #ccc; padding: 4px; margin: 25px 0 0;"> <tbody> <tr> <td width="300px" style="background:#eee; padding: 6px;color: #666; font-family: Arial,Helvetica,sans-serif;">Client Approval</td> <td style="background:#eee; padding: 6px;color: #666; font-family: Arial,Helvetica,sans-serif;"> Yes </td> </tr> </tbody></table>'; } $timesheet_table.='</body></html>'; if($dest_subscription_form != "") { $filename = $dest_subscription_form; } else { $filename = $check_submission_id['timesheet_name']; } $getTemplate = check_null_value('body','sat_email_template','id','4'); $getSubject = check_null_value('subject','sat_email_template','id','4'); $templete_body = emailTempalte($getSubject,$getTemplate); $templete_body = str_replace("%%timesheet_table%%",$timesheet_table,$templete_body); $stsattach = 'approved_timesheet/'.$filename; $from = "itteam@absi-usa.com"; $to = $to_email; $sts = new Mail(); $sts->From($from); $sts->Subject($getSubject); $sts->Body($templete_body); $sts->To($hr_manager); $sts->To($to_email); $sts->Attach($stsattach); $send = $sts->Send(); if($send) { header("location:timesheet_edit.php?id=".$staff_id."&page=".$_REQUEST['page']."&success=2"); } } /*else { header("location:timesheet_edit.php?id=".$staff_id."&page=".$_REQUEST['page']."&success=3"); }*/ } /*----------------------------------------------------- End Final Submission ------------------------------------------------*/ ?> <?php if($_REQUEST['success']=='1'){ ?> <p class="mydiv" style="color:#090; float:left; font-family:Verdana, Geneva, sans-serif; font-size:13px; text-align:left;">Timesheet Saved Successfully</p> <?php } ?> <?php if($_REQUEST['success']=='2'){ ?> <p class="mydiv" style="color:#090; float:left; font-family:Verdana, Geneva, sans-serif; font-size:13px; text-align:left;">Timesheet Submitted Successfully</p> <?php } ?> <?php if($_REQUEST['success']=='3'){ ?> <p class="mydiv" style="color:#F00; float:left; font-family:Verdana, Geneva, sans-serif; font-size:13px; text-align:left;"><?php echo $sql_staff_data['firstname'];?> has not submitted or saved any Timesheet for this period.</p> <?php } ?> <div id="success_msg_div"></div> <table width="100%" border="0" class="tmtbl"> <tr> <td colspan="2"> <table width="100%" border="0" cellpadding="0" cellspacing="0" class="tmhead"> <tr> <td align="left"><i class="fa fa-user"></i> User Name : <?php echo getStaffname($staff_id); ?></td> <td align="center"><i class="fa fa-check"></i> Visa Status : <?php echo $sql_staff_data['visa_status']; ?> </td> <td align="right"><i class="fa fa-sitemap"></i> Staff Type : <?php echo $sql_staff_data['associate_type']; ?></td> <?php /*?><td align="right">Date : <?php echo date("m-d-Y");?></td><?php */?> </tr> <?php /*?><tr> <td align="left">Staff Code : <?php echo $sql_staff_data['staff_code']; ?></td> <td>Staff Type : <?php echo $sql_staff_data['associate_type']; ?></td> <td align="right">Time : <?php echo date("h:i A"); ?></td> </tr><?php */?> </table> </td> </tr> <tr> <td align="center" colspan="2"> <form name="staff_edit_frm" id="staff_edit_frm" method="post" action=""> <table width="100%" border="0" class="tmfrm"> <tr> <td>First Name : <span>*</span> </td> <td><div class="edit" style="display:none;"> <input type="text" name="firstname" id="firstname" value="<?php echo $sql_staff_data['firstname'];?>" class="borderbtm validate[required,custom[onlyLetterSp]]" /></div> <div class="edit1"> <?php echo $sql_staff_data['firstname'];?></div> </td> <!--</tr> <tr>--> <td>Last Name : <span>*</span></td> <td> <div class="edit" style="display:none;"> <input type="text" name="lastname" id="lastname" value="<?php echo $sql_staff_data['lastname'];?>" class="borderbtm validate[required,custom[onlyLetterSp]]" /> </div> <div class="edit1"> <?php echo $sql_staff_data['lastname'];?></div> </td> </tr> <tr> <td>Phone (Work) : </td> <td> <?php $wphone1 = substr($sql_staff_data['work_phone_no'],0,3); $wphone2 = substr($sql_staff_data['work_phone_no'],3,3); $wphone3 = substr($sql_staff_data['work_phone_no'],6,4); ?> <div class="edit" style="display:none;"> <?php /*?><input type="text" name="work_phone_no" id="work_phone_no" value="<?php echo $sql_staff_data['work_phone_no']; ?>" class="validate[custom[phone]] borderbtm" onKeyPress="return goodchars(event,'1234567890');" /><?php */?> <input type="text" style="width:45px; height: 13px; border:#ccc 1px solid !important; " class="textfield validate[minSize[3],maxSize[3]]" onkeyup="javascript:ChangeFocus('work_phone1','work_phone2');" onkeypress="return goodchars(event,'1234567890');" maxlength="3" id="work_phone1" name="work_phone_no1" value="<?php echo $wphone1; ?>"> - <input type="text" class="textfield validate[minSize[3],maxSize[3]]" style="width:45px; height: 13px; border:#ccc 1px solid !important; " onkeyup="javascript:ChangeFocus('work_phone2','work_phone3');" onkeypress="return goodchars(event,'1234567890');" id="work_phone2" maxlength="3" name="work_phone_no2" value="<?php echo $wphone2; ?>"> - <input type="text" class="textfield validate[minSize[4],maxSize[4]]" style="width:54px; height: 13px; border:#ccc 1px solid !important; " onkeypress="return goodchars(event,'1234567890');" id="work_phone3" maxlength="4" name="work_phone_no3" value="<?php echo $wphone3; ?>"> </div> <div class="edit1"> <?php echo $sql_staff_data['work_phone_no'];?></div> </td> <!-- </tr> <tr>--> <td>Phone (Cell) : </td> <td> <?php $cphone1 = substr($sql_staff_data['cphone'],0,3); $cphone2 = substr($sql_staff_data['cphone'],3,3); $cphone3 = substr($sql_staff_data['cphone'],6,4); ?> <div class="edit" style="display:none;"> <?php /*?><input type="text" name="cphone" id="cphone" value="<?php echo $sql_staff_data['cphone']; ?>" class="validate[custom[phone]] borderbtm" onKeyPress="return goodchars(event,'1234567890');" /><?php */?> <input type="text" style="width:45px; height: 13px; border:#ccc 1px solid !important; " class="textfield validate[minSize[3],maxSize[3]]" onkeyup="javascript:ChangeFocus('cphone1','cphone2');" onkeypress="return goodchars(event,'1234567890');" maxlength="3" id="cphone1" name="cphone1" value="<?php echo $cphone1; ?>"> - <input type="text" class="textfield validate[minSize[3],maxSize[3]]" style="width:45px; height: 13px; border:#ccc 1px solid !important; " onkeyup="javascript:ChangeFocus('cphone2','cphone3');" onkeypress="return goodchars(event,'1234567890');" id="cphone2" maxlength="3" name="cphone2" value="<?php echo $cphone2; ?>"> - <input type="text" class="textfield validate[minSize[4],maxSize[4]]" style="width:54px; height: 13px; border:#ccc 1px solid !important; " onkeypress="return goodchars(event,'1234567890');" id="cphone3" maxlength="4" name="cphone3" value="<?php echo $cphone3; ?>"> </div> <div class="edit1"> <?php echo $sql_staff_data['cphone'];?></div> </td> </tr> <tr> <?php /*?><td>Phone (Other) : </td> <td> <div class="edit" style="display:none;"> <input type="text" style="width:45px; border:#7F9DB9 1px solid !important; " class="textfield validate[minSize[3],maxSize[3]]" onkeyup="javascript:ChangeFocus('hphone1','hphone2');" onkeypress="return goodchars(event,'1234567890');" value="" maxlength="3" id="hphone1" name="hphone1"> - <input type="text" class="textfield validate[minSize[3],maxSize[3]]" style="width:45px; border:#7F9DB9 1px solid !important; " onkeyup="javascript:ChangeFocus('hphone2','hphone3');" onkeypress="return goodchars(event,'1234567890');" value="" id="hphone2" maxlength="3" name="hphone2"> - <input type="text" class="textfield validate[minSize[4],maxSize[4]]" style="width:54px; border:#7F9DB9 1px solid !important; " onkeypress="return goodchars(event,'1234567890');" value="" id="hphone3" maxlength="4" name="hphone3"> <div class="edit1"> <?php echo $sql_staff_data['hphone'];?></div> </td><?php */?> <!--</tr> <tr>--> <td>Email (Work): </td> <td> <div class="edit" style="display:none;"> <input type="text" name="work_email" id="work_email" value="<?php echo $sql_staff_data['work_email']; ?>" class="borderbtm validate[custom[email]]" /> </div> <div class="edit1"> <?php echo $sql_staff_data['work_email'];?></div> </td> <td>Email (Personal) : <span>*</span></td> <td> <div class="edit" style="display:none;"> <input type="text" name="pemail" id="pemail" value="<?php echo $sql_staff_data['pemail']; ?>" class="borderbtm validate[required ,custom[email]]" /></div> <div class="edit1"> <?php echo $sql_staff_data['pemail'];?></div> </td> </tr> <tr> <!-- </tr> <tr>--> <td>Work Location Address : </td> <td colspan="3"> <div class="edit" style="display:none;"> <textarea class="borderbtm" name="worksite_street" id="worksite_street"><?php echo $sql_staff_data['worksite_street']; ?></textarea></div> <div class="edit1"> <?php echo $sql_staff_data['worksite_street'];?></div> </td> </tr> <tr> <td colspan="4" class="note">‘*’ Mandatory.</td> </tr> <tr> <td align="center" colspan="4"> <input type="button" class="require float-none" value="Edit Information" onclick="edit_info();"> <input type="button" id="send_btn" class="require float-none org" value="Send" onclick="update_staff();" style="display:none;"> </td> </tr> </table> <input type="hidden" name="staff_id_hid" id="staff_id_hid" value="<?php echo $_REQUEST['id']; ?>"/> </form> </td> </tr> <?php if($staticstart == "" && $staticfinish == "") { $display = "block"; } else { $display = "none"; } ?> <form action="" method="post" id="future_form"> <tr> <td colspan="2" align="center"> <div id="future_date_div" style="display:<?php echo $display; ?>; margin-top: 25px;"> <table width="100%" border="0" class="tmfrm"> <tr> <td width="100">Start Date : </td> <td width="200"> <input type="text" name="start_date" id="start_date" autocomplete="off" readonly="readonly" /> </td> <td width="100">End Date : </td> <td width="200"> <input type="text" name="end_date" id="end_date" autocomplete="off" readonly="readonly" /> </td> <td width="70" align="center"><input type="submit" name="future_date" value="Submit" class="require float-none" onclick="return check_period();"></td> </tr> </table> </div> </td> </tr> </form> <?php if($staticstart != "" && $staticfinish != "") { ?> <tr><td colspan="2"> </td></tr> <tr> <td class="timesheet_main" colspan="2" align="center"> <p style="padding-left: 147px;"> Timesheet Period : <?php echo $staticstart; ?> - <?php echo $staticfinish; ?> </p> <a class="time_butt require org" href="javascript:void(0);" onClick="open_future_tr();">Enter Another Period</a> </td> </tr> <?php if($check_submission > 0) { ?> <?php /*?><tr> <td align="center"> <div style="color:#090; margin:15px 0 0">You have submitted your timesheet of <?php echo $staticstart; ?> - <?php echo $staticfinish; ?> period.</div> </td> </tr><?php */?> <?php } ?> <?php if($sql_staff_data['purchase_order'] < 40) { ?> <script type="text/javascript"> /*$( document ).ready(function() { $('#timesheet_form :input').attr('readonly', true); });*/ </script> <?php /*?><tr> <td align="center"> <div style="color:#F00; margin:15px 0 0">You need Minimum 40hrs. of Purchase Order to fill your Timesheet.</div> </td> </tr><?php */?> <?php } ?> <tr> <td colspan="2"> <form id="timesheet_form" action="" method="post" enctype="multipart/form-data"> <table width="100%" border="1" class="daytbl"> <tr> <td width="11%">Hours</td> <td width="13%" align="center">Sunday<br><span>(<?php echo $all_dates[0]; ?>)</span></td> <td width="13%" align="center">Monday<br><span>(<?php echo $all_dates[1]; ?>)</span></td> <td width="13%" align="center">Tuesday<br><span>(<?php echo $all_dates[2]; ?>)</span></td> <td width="13%" align="center">Wednesday<br><span>(<?php echo $all_dates[3]; ?>)</span></td> <td width="13%" align="center">Thursday<br><span>(<?php echo $all_dates[4]; ?>)</span></td> <td width="13%" align="center">Friday<br><span>(<?php echo $all_dates[5]; ?>)</span></td> <td width="13%" align="center">Saturday<br><span>(<?php echo $all_dates[6]; ?>)</span></td> </tr> <tr> <td>Approved</td> <td align="center" class="red_bg"><input type="text" name="sun_approved" id="sun_approved" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['sun_approved'];?>" onBlur="alert_staff('sun_approved');" onkeyup="get_daily_total('sun','approved');check_holiday('<?php echo $all_dates[0]; ?>','sun_approved');"/></td> <td align="center"><input type="text" name="mon_approved" id="mon_approved" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['mon_approved'];?>" onkeyup="get_daily_total('mon','approved'); get_weekly_total(); check_holiday('<?php echo $all_dates[1]; ?>','mon_approved');"/></td> <td align="center"><input type="text" name="tue_approved" id="tue_approved" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['tue_approved'];?>" onkeyup="get_daily_total('tue','approved'); get_weekly_total();check_holiday('<?php echo $all_dates[2]; ?>','tue_approved');"/></td> <td align="center"><input type="text" name="wed_approved" id="wed_approved" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['wed_approved'];?>" onkeyup="get_daily_total('wed','approved'); get_weekly_total(); check_holiday('<?php echo $all_dates[3]; ?>','wed_approved');"/></td> <td align="center"><input type="text" name="thu_approved" id="thu_approved" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['thu_approved'];?>" onkeyup="get_daily_total('thu','approved'); get_weekly_total(); check_holiday('<?php echo $all_dates[4]; ?>','thu_approved');"/></td> <td align="center"><input type="text" name="fri_approved" id="fri_approved" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['fri_approved'];?>" onkeyup="get_daily_total('fri','approved'); get_weekly_total(); check_holiday('<?php echo $all_dates[5]; ?>','fri_approved');"/></td> <td align="center" class="red_bg"><input type="text" name="sat_approved" id="sat_approved" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['sat_approved'];?>" onBlur="alert_staff('sat_approved');" onkeyup="get_daily_total('sat','approved');get_weekly_total();check_holiday('<?php echo $all_dates[6]; ?>','sat_approved');"/></td> </tr> <tr> <td>Un-Approved</td> <td align="center" class="red_bg"><input type="text" name="sun_unapproved" id="sun_unapproved" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['sun_unapproved'];?>" onBlur="alert_staff('sun_unapproved');" onkeyup="get_daily_total('sun','unapproved'); get_weekly_total();check_holiday('<?php echo $all_dates[0]; ?>','sun_unapproved');"/></td> <td align="center"><input type="text" name="mon_unapproved" id="mon_unapproved" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['mon_unapproved'];?>" onkeyup="get_daily_total('mon','unapproved'); get_weekly_total(); check_holiday('<?php echo $all_dates[1]; ?>','mon_unapproved');"/></td> <td align="center"><input type="text" name="tue_unapproved" id="tue_unapproved" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['tue_unapproved'];?>" onkeyup="get_daily_total('tue','unapproved'); get_weekly_total(); check_holiday('<?php echo $all_dates[2]; ?>','tue_unapproved');"/></td> <td align="center"><input type="text" name="wed_unapproved" id="wed_unapproved" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['wed_unapproved'];?>" onkeyup="get_daily_total('wed','unapproved'); get_weekly_total(); check_holiday('<?php echo $all_dates[3]; ?>','wed_unapproved');"/></td> <td align="center"><input type="text" name="thu_unapproved" id="thu_unapproved" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['thu_unapproved'];?>" onkeyup="get_daily_total('thu','unapproved'); get_weekly_total(); check_holiday('<?php echo $all_dates[4]; ?>','thu_unapproved');"/></td> <td align="center"><input type="text" name="fri_unapproved" id="fri_unapproved" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['fri_unapproved'];?>" onkeyup="get_daily_total('fri','unapproved'); get_weekly_total(); check_holiday('<?php echo $all_dates[5]; ?>','fri_unapproved');"/></td> <td align="center" class="red_bg"><input type="text" name="sat_unapproved" id="sat_unapproved" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['sat_unapproved'];?>" onBlur="alert_staff('sat_unapproved');" onkeyup="get_daily_total('sat','unapproved'); get_weekly_total(); check_holiday('<?php echo $all_dates[6]; ?>','sat_unapproved');"/></td> </tr> <?php if($sql_staff_data['associate_type'] == "W2S") { ?> <tr> <td>Holiday</td> <td align="center" class="red_bg"><input type="text" name="sun_holiday" id="sun_holiday" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['sun_holiday'];?>" onBlur="alert_staff('sun_holiday');" onkeyup="get_daily_total('sun','holiday'); get_weekly_total(); check_holiday_total('sun'); check_holiday('<?php echo $all_dates[0]; ?>','sun_holiday');"/></td> <td align="center"><input type="text" name="mon_holiday" id="mon_holiday" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['mon_holiday'];?>" onkeyup="get_daily_total('mon','holiday'); get_weekly_total(); check_holiday_total('mon'); check_holiday('<?php echo $all_dates[1]; ?>','mon_holiday');"/></td> <td align="center"><input type="text" name="tue_holiday" id="tue_holiday" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['tue_holiday'];?>" onkeyup="get_daily_total('tue','holiday'); get_weekly_total(); check_holiday_total('tue'); check_holiday('<?php echo $all_dates[2]; ?>','tue_holiday');"/></td> <td align="center"><input type="text" name="wed_holiday" id="wed_holiday" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['wed_holiday'];?>" onkeyup="get_daily_total('wed','holiday'); get_weekly_total(); check_holiday_total('wed'); check_holiday('<?php echo $all_dates[3]; ?>','wed_holiday');"/></td> <td align="center"><input type="text" name="thu_holiday" id="thu_holiday" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['thu_holiday'];?>" onkeyup="get_daily_total('thu','holiday'); get_weekly_total(); check_holiday_total('thu'); check_holiday('<?php echo $all_dates[4]; ?>','thu_holiday');"/></td> <td align="center"><input type="text" name="fri_holiday" id="fri_holiday" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['fri_holiday'];?>" onkeyup="get_daily_total('fri','holiday'); get_weekly_total(); check_holiday_total('fri'); check_holiday('<?php echo $all_dates[5]; ?>','fri_holiday');"/></td> <td align="center" class="red_bg"><input type="text" name="sat_holiday" id="sat_holiday" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['sat_holiday'];?>" onBlur="alert_staff('sat_holiday');" onkeyup="get_daily_total('sat','holiday'); get_weekly_total(); check_holiday_total('sat'); check_holiday('<?php echo $all_dates[6]; ?>','sat_holiday');"/></td> </tr> <tr> <td>Vacation</td> <td align="center" class="red_bg"><input type="text" name="sun_vacation" id="sun_vacation" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['sun_vacation'];?>" onBlur="alert_staff('sun_vacation');" onkeyup="get_daily_total('sun','vacation'); get_weekly_total(); check_vacation_total('sun'); check_holiday('<?php echo $all_dates[0]; ?>','sun_vacation');"/></td> <td align="center"><input type="text" name="mon_vacation" id="mon_vacation" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['mon_vacation'];?>" onkeyup="get_daily_total('mon','vacation'); get_weekly_total(); check_vacation_total('mon'); check_holiday('<?php echo $all_dates[1]; ?>','mon_vacation');" /></td> <td align="center"><input type="text" name="tue_vacation" id="tue_vacation" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['tue_vacation'];?>" onkeyup="get_daily_total('tue','vacation'); get_weekly_total(); check_vacation_total('tue'); check_holiday('<?php echo $all_dates[2]; ?>','tue_vacation');"/></td> <td align="center"><input type="text" name="wed_vacation" id="wed_vacation" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['wed_vacation'];?>" onkeyup="get_daily_total('wed','vacation'); get_weekly_total(); check_vacation_total('wed'); check_holiday('<?php echo $all_dates[3]; ?>','wed_vacation');"/></td> <td align="center"><input type="text" name="thu_vacation" id="thu_vacation" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['thu_vacation'];?>" onkeyup="get_daily_total('thu','vacation'); get_weekly_total(); check_vacation_total('thu'); check_holiday('<?php echo $all_dates[4]; ?>','thu_vacation');"/></td> <td align="center"><input type="text" name="fri_vacation" id="fri_vacation" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['fri_vacation'];?>" onkeyup="get_daily_total('fri','vacation'); get_weekly_total(); check_vacation_total('fri') check_holiday('<?php echo $all_dates[5]; ?>','fri_vacation');;"/></td> <td align="center" class="red_bg"><input type="text" name="sat_vacation" id="sat_vacation" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['sat_vacation'];?>" onBlur="alert_staff('sat_vacation');" onkeyup="get_daily_total('sat','vacation'); get_weekly_total(); check_vacation_total('sat'); check_holiday('<?php echo $all_dates[6]; ?>','sat_vacation');"/></td> </tr> <tr> <td>Personal</td> <td align="center" class="red_bg"><input type="text" name="sun_personal" id="sun_personal" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['sun_personal'];?>" onBlur="alert_staff('sun_personal');" onkeyup="get_daily_total('sun','personal'); get_weekly_total(); check_personal_total('sun'); check_holiday('<?php echo $all_dates[0]; ?>','sun_personal');"/></td> <td align="center"><input type="text" name="mon_personal" id="mon_personal" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['mon_personal'];?>" onkeyup="get_daily_total('mon','personal'); get_weekly_total(); check_personal_total('mon'); check_holiday('<?php echo $all_dates[1]; ?>','mon_personal');"/></td> <td align="center"><input type="text" name="tue_personal" id="tue_personal" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['tue_personal'];?>" onkeyup="get_daily_total('tue','personal'); get_weekly_total(); check_personal_total('tue'); check_holiday('<?php echo $all_dates[2]; ?>','tue_personal');"/></td> <td align="center"><input type="text" name="wed_personal" id="wed_personal" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['wed_personal'];?>" onkeyup="get_daily_total('wed','personal'); get_weekly_total(); check_personal_total('wed'); check_holiday('<?php echo $all_dates[3]; ?>','wed_personal');"/></td> <td align="center"><input type="text" name="thu_personal" id="thu_personal" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['thu_personal'];?>" onkeyup="get_daily_total('thu','personal'); get_weekly_total(); check_personal_total('thu'); check_holiday('<?php echo $all_dates[4]; ?>','thu_personal');"/></td> <td align="center"><input type="text" name="fri_personal" id="fri_personal" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['fri_personal'];?>" onkeyup="get_daily_total('fri','personal'); get_weekly_total(); check_personal_total('fri'); check_holiday('<?php echo $all_dates[5]; ?>','fri_personal');"/></td> <td align="center" class="red_bg"><input type="text" name="sat_personal" id="sat_personal" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['sat_personal'];?>" onBlur="alert_staff('sat_personal');" onkeyup="get_daily_total('sat','personal'); get_weekly_total(); check_personal_total('sat'); check_holiday('<?php echo $all_dates[6]; ?>','sat_personal');"/></td> </tr> <tr> <td>Sick</td> <td align="center" class="red_bg"><input type="text" name="sun_sick" id="sun_sick" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['sun_sick'];?>" onBlur="alert_staff('sun_sick');" onkeyup="get_daily_total('sun','sick'); get_weekly_total(); check_sick_total('sun'); check_holiday('<?php echo $all_dates[0]; ?>','sun_sick');"/></td> <td align="center"><input type="text" name="mon_sick" id="mon_sick" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['mon_sick'];?>" onkeyup="get_daily_total('mon','sick'); get_weekly_total(); check_sick_total('mon'); check_holiday('<?php echo $all_dates[1]; ?>','mon_sick');"/></td> <td align="center"><input type="text" name="tue_sick" id="tue_sick" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['tue_sick'];?>" onkeyup="get_daily_total('tue','sick'); get_weekly_total(); check_sick_total('tue'); check_holiday('<?php echo $all_dates[2]; ?>','tue_sick');"/></td> <td align="center"><input type="text" name="wed_sick" id="wed_sick" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['wed_sick'];?>" onkeyup="get_daily_total('wed','sick'); get_weekly_total(); check_sick_total('wed'); check_holiday('<?php echo $all_dates[3]; ?>','wed_sick');"/></td> <td align="center"><input type="text" name="thu_sick" id="thu_sick" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['thu_sick'];?>" onkeyup="get_daily_total('thu','sick'); get_weekly_total(); check_sick_total('thu'); check_holiday('<?php echo $all_dates[4]; ?>','thu_sick');"/></td> <td align="center"><input type="text" name="fri_sick" id="fri_sick" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['fri_sick'];?>" onkeyup="get_daily_total('fri','sick'); get_weekly_total(); check_sick_total('fri'); check_holiday('<?php echo $all_dates[5]; ?>','fri_sick');"/></td> <td align="center" class="red_bg"><input type="text" name="sat_sick" id="sat_sick" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['sat_sick'];?>" onBlur="alert_staff('sat_sick');" onkeyup="get_daily_total('sat','sick'); get_weekly_total(); check_sick_total('sat'); check_holiday('<?php echo $all_dates[6]; ?>','sat_sick');"/></td> </tr> <?php } ?> <tr> <td>Un-paid Time</td> <td align="center" class="red_bg"><input type="text" name="sun_unpaid" id="sun_unpaid" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['sun_unpaid'];?>" onBlur="alert_staff('sun_unpaid');" onkeyup="get_daily_total('sun','unpaid'); get_weekly_total(); check_holiday('<?php echo $all_dates[0]; ?>','sun_unpaid');"/></td> <td align="center"><input type="text" name="mon_unpaid" id="mon_unpaid" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['mon_unpaid'];?>" onkeyup="get_daily_total('mon','unpaid'); get_weekly_total(); check_holiday('<?php echo $all_dates[1]; ?>','mon_unpaid');" /></td> <td align="center"><input type="text" name="tue_unpaid" id="tue_unpaid" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['tue_unpaid'];?>" onkeyup="get_daily_total('tue','unpaid'); get_weekly_total(); check_holiday('<?php echo $all_dates[2]; ?>','tue_unpaid');"/></td> <td align="center"><input type="text" name="wed_unpaid" id="wed_unpaid" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['wed_unpaid'];?>" onkeyup="get_daily_total('wed','unpaid'); get_weekly_total(); check_holiday('<?php echo $all_dates[3]; ?>','wed_unpaid');"/></td> <td align="center"><input type="text" name="thu_unpaid" id="thu_unpaid" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['thu_unpaid'];?>" onkeyup="get_daily_total('thu','unpaid'); get_weekly_total(); check_holiday('<?php echo $all_dates[4]; ?>','thu_unpaid');"/></td> <td align="center"><input type="text" name="fri_unpaid" id="fri_unpaid" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['fri_unpaid'];?>" onkeyup="get_daily_total('fri','unpaid'); get_weekly_total(); check_holiday('<?php echo $all_dates[5]; ?>','fri_unpaid');"/></td> <td align="center" class="red_bg"><input type="text" name="sat_unpaid" id="sat_unpaid" onKeyPress="return goodchars(event,'1234567890.');" value="<?php echo $sql_data['sat_unpaid'];?>" onBlur="alert_staff('sat_unpaid');" onkeyup="get_daily_total('sat','unpaid'); get_weekly_total(); check_holiday('<?php echo $all_dates[6]; ?>','sat_unpaid');"/></td> </tr> <tr> <td class="nobg" align="left">Daily TOTAL</td> <td align="center"><input type="text" name="sun_daily_total" id="sun_daily_total" value="<?php echo $sql_data['sun_total'];?>" readonly/></td> <td align="center"><input type="text" name="mon_daily_total" id="mon_daily_total" value="<?php echo $sql_data['mon_total'];?>" readonly/></td> <td align="center"><input type="text" name="tue_daily_total" id="tue_daily_total" value="<?php echo $sql_data['tue_total'];?>" readonly/></td> <td align="center"><input type="text" name="wed_daily_total" id="wed_daily_total" value="<?php echo $sql_data['wed_total'];?>" readonly/></td> <td align="center"><input type="text" name="thu_daily_total" id="thu_daily_total" value="<?php echo $sql_data['thu_total'];?>" readonly/></td> <td align="center"><input type="text" name="fri_daily_total" id="fri_daily_total" value="<?php echo $sql_data['fri_total'];?>" readonly/></td> <td align="center"><input type="text" name="sat_daily_total" id="sat_daily_total" value="<?php echo $sql_data['sat_total'];?>" readonly/></td> </tr> <tr> <td colspan="2" class="nobg" align="left">Upload your approved Timesheet</td> <td colspan="4" align="left"><input type="file" name="approved_timesheet_name[]" id="approved_timesheet" multiple="multiple" /> <?php $sql_timesheet_files = mysql_query("SELECT * FROM timesheet_files WHERE timesheet_id = '".$sql_data['id']."'"); $ii = 1; while($array_timesheet_files = mysql_fetch_array($sql_timesheet_files)){ ?> <?php echo $ii; ?>. <a href="approved_timesheet/<?php echo $array_timesheet_files['timesheet_file'];?>" class="used_cls"> Uploaded Timesheet </a><img src="images/delete_icon.png" alt="delete" /><br /> <?php $ii++; } ?> <?php /*?><?php if($check_submission_id['timesheet_name']!=''){ ?> <a href="approved_timesheet/<?php echo $check_submission_id['timesheet_name'];?>" class="used_cls"> Uploaded Timesheet </a> <?php } ?><?php */?> </td> <td class="nobg" align="right">Weekly Total</td> <td align="center"><input type="text" name="weekly_total" id="weekly_total" readonly /></td> </tr> <?php if($sql_data['modified_by'] != "") { ?> <tr class="tblftr"> <td align="left" colspan="6">Last Updated By: <?php if($sql_data['timesheet_edited_by'] != "0") { echo getUsername($sql_data['timesheet_edited_by']); } else { echo getStaffname($sql_data['modified_by']); } ?></td> <td align="right" colspan="2" >Date: <?php echo date("m-d-Y",strtotime($sql_data['modified_date'])); ?></td> </tr> <?php } ?> </table> <?php /*?><span class="note">Note : '*' for W2 Salary Only</span><?php */?> </td> </tr> <?php if($check_submission_id['explanation'] != "") { $display_exp = "block"; } else { $display_exp = "none"; } ?> <tr> <td colspan="2" align="center"> <div id="explain_div" style="display:<?php echo $display_exp;?>"> <table width="100%" border="0" class="tmfrm mrgntop25"> <tr class="nobg"> <td colspan="2"> <h2>Explanation :</h2> </td> </tr> <tr> <td width="300px">Explanation for >40Hrs. : </td> <td> <textarea id="explanation" name="explanation" class="validate[required] borderbtm"><?php echo $check_submission_id['explanation']; ?> </textarea> </td> </tr> </table> </div> </td> </tr> <?php if($check_submission_id['client_approval'] != "") { $display_agr = "block"; } else { $display_agr = "none"; } ?> <tr> <td> <div id="agree_div" style="display:<?php echo $display_agr; ?>"> <table width="100%" border="0" class="tmfrm mrgntop25"> <tr> <td width="300px">Client Approval</td> <td> <label><input type="radio" name="client_approval" class="validate[required]" id="client_approval" value="Yes" <?php if($check_submission_id['client_approval'] == "Yes") { ?> checked="checked" <?php } ?> /> Yes</label> <label><input type="radio" name="client_approval" class="validate[required]" id="client_approval1" value="No" <?php if($check_submission_id['client_approval'] == "No") { ?> checked="checked" <?php } ?> /> No</label> </td> </tr> </table> </div> </td> </tr> <?php if($sql_company_message['company_message']) { ?> <tr> <td colspan="2" align="center"> <table width="100%" border="0" class="mrgntop25 cmtsec"> <tr> <td> <div class="cm-msg">Company Message <i class="fa fa-comment-o"></i> <i class="fa fa-caret-right"></i> </div> <div class="msg-sec"> <?php echo $sql_company_message['company_message']; ?> </div> <div class="btn-ftrsec"> <input type="button" class="require float-none gray" value="Refresh" onClick="window.location.reload();"> <?php if($sql_data['submit_flag'] != "1") { ?> <input type="submit" name="save" class="require float-none" value="Save"> <?php } ?> <input type="submit" name="submit_final" class="require float-none org" value="Submit" onclick="return check_validations();"> </div> </td> </tr> </tr> <?php } ?> <?php if($sql_data['submit_flag'] == "1") { ?> <tr> <td colspan="2"> <span class="note">Note : ‘*’ This timesheet has been Submitted. You can only submit it, cannot save it.</span> </td> </tr> <?php } ?> <?php //if($check_submission == 0 && $sql_staff_data['purchase_order'] > 40) { ?> <!-- <tr> <td align="center" colspan="2"> <input type="button" class="search_go_new_btn" value="Refresh" onClick="window.location.reload();"> <?php //if($sql_data['submit_flag'] != "1") //{ ?> <input type="submit" name="save" class="search_go_new_btn" value="Save"> <?php //} ?> <input type="submit" name="submit_final" class="search_go_new_btn" value="Submit" onclick="return check_validations();"> </td> </tr> --> <?php } ?> <input type="hidden" name="start_date_hid" id="start_date_hid" value="<?php echo $staticstart; ?>" /> <input type="hidden" name="end_date_hid" id="end_date_hid" value="<?php echo $staticfinish; ?>" /> <input type="hidden" name="staff_type_hid" id="staff_type_hid" value="<?php echo $sql_staff_data['associate_type']; ?>" /> <input type="hidden" name="visa_type_hid" id="visa_type_hid" value="<?php echo $sql_staff_data['visa_status']; ?>" /> <input type="hidden" name="vacation_hid" id="vacation_hid" value="<?php echo $sql_personal_data['vacation']; ?>" /> <input type="hidden" name="sick_hid" id="sick_hid" value="<?php echo $sql_personal_data['sick']; ?>" /> <input type="hidden" name="holiday_hid" id="holiday_hid" value="<?php echo $sql_personal_data['holiday']; ?>" /> <input type="hidden" name="personal_hid" id="personal_hid" value="<?php echo $sql_personal_data['personal']; ?>" /> <input type="hidden" name="weekly_hid" id="weekly_hid" value="<?php echo $check_submission_id['weekly_hours']; ?>"/> <input type="hidden" name="hol_hid" id="hol_hid" value="<?php echo $hol_prev; ?>"/> <input type="hidden" name="sic_hid" id="sic_hid" value="<?php echo $sic_prev; ?>"/> <input type="hidden" name="pers_hid" id="pers_hid" value="<?php echo $pers_prev; ?>"/> </table> </td> </tr> </form> <tr> <?php } ?> <td colspan="2"> </td> </tr> </table> <div id="dialog-confirm" title="Alert Message" style="display:none;"> <p><span class="ui-icon ui-icon-alert" style="float:left; margin:0 7px 20px 0;"></span>This is a Holiday. Are you sure you have worked on this day?</p> </div> <div id="dialog-confirm-holiday" title="Alert Message" style="display:none;"> <p id="alert_msg_id"></p> </div> <script type="text/javascript">get_weekly_total();</script> <?php include("includes/footer.php"); ?>