我有几名员工的手写时间表，想写一个简单的脚本来计算他们每个人的总工作时间。
我所创造的东西是有效的，除非轮班越过午夜进入另一天。 IE：上午 9 点至晚上 7 点返回 10 小时，但晚上 11 点至早上 7 点返回 16 小时。
我想这是因为我只是传递时间信息而不是日期信息，所以 dateTime 类（理所当然地）变得混乱。
我的问题是，有没有办法轻松计算两个时间之间的差异，当它们进入一个单独的一天（无需指定日期）？
形式：
<form id="timeForm" class="form-horizontal" role="form">
<div class="form-group">
<label for="empName" class="col-sm-2 control-label">Name</label>
<div class="col-sm-6 col-md-6 col-lg-6">
<input type="text" class="form-control" id="empName" name="empName" placeholder="Name">
</div>
</div>
<div class="form-group">
<div class="col-sm-3 col-md-3 col-lg-3 col-sm-offset-8 col-md-offset-8 col-lg-offset-8 ">
<div class="checkbox">
<label>
<input class="checkbox1" type="checkbox" id="selectall" value="y"> Select All?
</label>
</div>
</div>
</div>
<?php
foreach (range(1, 7) as $number) {
?>
<div class="form-group">
<label for="Day1" class="col-sm-2 col-md-2 col-lg-2 control-label">Day <?php echo $number;?> :</label>
<div class="col-sm-3 col-md-3 col-lg-3">
<input type="time" class="form-control" name="day<?php echo $number;?>_start" id="day<?php echo $number;?>_start" placeholder="start time">
</div>
<div class="col-sm-3 col-md-3 col-lg-3">
<input type="time" class="form-control" name="day<?php echo $number;?>_finish" id="day<?php echo $number;?>_finish" placeholder="finish time">
</div>
<div class="col-sm-3 col-md-3 col-lg-3">
<div class="checkbox">
<label>
<input class="checkbox1" type="checkbox" name="day<?php echo $number;?>_NL" value="y"> No Lunch?
</label>
</div>
</div>
</div>
<?php
}
?>
<div class="form-group">
<div class="col-sm-offset-2 col-sm-2 col-md-2 col-lg-2">
<button id="calculate" type="submit" class="btn btn-default">Calculate</button>
</div>
<div class="col-sm-2 col-md-2 col-lg-2">
<button id="clear" type="submit" class="btn btn-default">Clear</button>
</div>
</div>
</form>
<div id="total">
</div>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.7/jquery.js"></script>
<script src="http://malsup.github.com/jquery.form.js"></script>
<!-- Latest compiled and minified JavaScript -->
<script src="//netdna.bootstrapcdn.com/bootstrap/3.1.1/js/bootstrap.min.js"></script>
<script src="//ajax.googleapis.com/ajax/libs/jqueryui/1.10.4/jquery-ui.min.js"> </script>
<script>
$(document).ready(function() {
$('#clear').on('click', function(e){
e.preventDefault();
$('#timeForm').trigger("reset");
});
$('#calculate').on('click', function(e){
e.preventDefault();
//$('#calculate').fadeOut(300);
$.ajax({
type: "POST",
url: "timesheet.php",
data: jQuery("#timeForm").serialize(),
cache: false,
success: function(data){
$('#total').append("<p>" + data + "</p>");
//$('#timeForm')[0].reset();
/*if json obj. alert(JSON.stringify(data));*/
}
})
});
$(function() {
var availableTags = [
"George","Brian","Craig","Bruce","Amy","Stew","Cora","Annette","Derek D","James","Patty","Jessica","Derek"
];
$( "#empName" ).autocomplete({
source: availableTags
});
});
$('#selectall').click(function(event) { //on click
if(this.checked) { // check select status
$('.checkbox1').each(function() { //loop through each checkbox
this.checked = true; //select all checkboxes with class "checkbox1"
});
}else{
$('.checkbox1').each(function() { //loop through each checkbox
this.checked = false; //deselect all checkboxes with class "checkbox1"
});
}
});
});
</script>
处理表单的 php：
<?php
$totalHours= '';
foreach (range(1, 7) as $number) {
$hours = '';
$hour = '';
$minute = '';
$starttime = '';
$finishtime = '';
if(!empty($_POST["day{$number}_start"]) && !empty($_POST["day{$number}_finish"]) ){
$starttime = $_POST["day{$number}_start"];
$finishtime = $_POST["day{$number}_finish"];
$from = new DateTime($_POST["day{$number}_start"]);
$to = new DateTime($_POST["day{$number}_finish"]);
//var_dump($from == $to);
//var_dump($from < $to);
//var_dump($from > $to);
if($_POST["day{$number}_NL"] != 'y') {
$from->add(new DateInterval('PT30M'));
}
$hours = $from->diff($to)->format('%H:%I'); //
//debug
//echo $hours . " - ";
list($hour,$minute) = explode(":",$hours);
$minuteF = $minute / 60;
//echo " - " . $minuteF;
$totalHours += $hour + $minuteF;
}
}
$totalHours = round($totalHours,2);
echo $_POST['empName'] ." - " . $totalHours;
//debug
//print_r($_POST);
?>
只需检查结束时间是否早于开始时间。如果是这样，则是第二天，因此请添加一天：
$from = new DateTime($_POST["day{$number}_start"]);
$to = new DateTime($_POST["day{$number}_finish"]);
if ($to < $from) {
$to->modify('+1 day'); // or $to->add(new DateInterval('P1D'));
}