$mins = floor(($diff - $hours * 60 * 60) / 60); $secs = floor($diff - ($hours * 60 * 60 + $mins * 60)); if (strlen($hours) < 2) { $hours = $hours; } if (strlen($mins) < 2) { $mins = $mins; } if (strlen($secs) < 2) { $secs = "0" . $secs; } return $hours . ':' . $mins; } $time1 = date('H:i', strtotime($obtimein)); $time2 = date('H:i', strtotime($obtimeout)); $numofhrs = gettimediff($time1, $time2); $stmt = "UPDATE `undertime` set \n\t\t\t\tundertimefr = '{$obtimein}', undertimeto = '{$obtimeout}', state = '{$upstate}', edithr = '{$edithr}', datehr = '{$date}', numofhrs = '{$numofhrs}'\n\t\t\twhere account_id = '{$accid}' and state = 'UA' and undertime_id = '{$obid}'"; if ($conn->query($stmt) === TRUE) { echo '<script type="text/javascript">window.location.replace("hr.php?ac=penundr"); </script>'; } else { echo "Error updating record: " . $conn->error; } $conn->close(); } if (isset($_POST['disapprovetime'])) { $dareason = $_POST['dareason']; $overtime = $_POST['overtime']; $approve = $_POST['approve']; $ac = $_POST['ac']; $accid = $_POST['accid']; $stmt = "UPDATE `overtime` set \n\t\t\t state = '{$approve}', dareason = '{$dareason}'\n\t\t\twhere account_id = '{$accid}' and state = 'UA' and overtime_id = '{$overtime}'";
$mins = floor(($diff - $hours * 60 * 60) / 60); $secs = floor($diff - ($hours * 60 * 60 + $mins * 60)); if (strlen($hours) < 2) { $hours = $hours; } if (strlen($mins) < 2) { $mins = $mins; } if (strlen($secs) < 2) { $secs = "0" . $secs; } return $hours . ':' . $mins; } $time1 = date('H:i', strtotime($_POST['startofot'])); $time2 = date('H:i', strtotime($_POST['endofot'])); $approvedothrs = gettimediff($time1, $time2); if (substr($approvedothrs, 0, 2) >= 8) { $approvedothrs = date("G:i", strtotime("-1 hour", strtotime($approvedothrs))); } //ot break on ot exec if (isset($_POST['otbreak']) && $_POST['otbreak'] != null) { if ($_POST['otbreak'] == '30 Mins') { $approvedothrs = date("G:i", strtotime("-30 min", strtotime($approvedothrs))); $otbreak = '-30 Minutes'; } elseif ($_POST['otbreak'] == '1 Hour') { $approvedothrs = date("G:i", strtotime("-1 Hour", strtotime($approvedothrs))); $otbreak = '-1 Hour'; } else { $otbreak = null; } } else {