如何计算日期范围内的特定日期和时间

debugcn 发表于 Dev

麦克风

我有一个数据库，其中包含工作人员的登录和注销时间表。

我正在寻找哪些工作人员在周日凌晨6点至周四凌晨4点或周六6:30 am至周六下午3点之间进行计时。

我希望最终用户能够从Web界面（即1/1/14开始和12/1/14结束）中选择任何日期范围，并由此确定谁在白天和时间范围内工作。我希望能够显示工作人员列表以及他们的登录和注销时间。

到目前为止，我已经解决了如何使用“确定两个日期范围是否重叠”来检查用户是否已登录的方法

但是我对如何计算daterangeB的伪代码感到困惑

到目前为止，我有：

start at datefrom,
check if datefrom = dateto, if true end loop,
find out day name, 
check if saturday, if saturday add timestamps to array (start and finish),
increment datefrom by 1 day, start loop again.

这将为我提供用户选择的日期之间的星期六daterangeB的数组。

但是，较大的日期范围是个问题，因为第一天可能是星期二，如果我要检查星期天和星期四，比如说我找到星期四，我将没有星期天作为开始日，将需要在星期二00:00:00进行。同样可能发生相反的情况，我可以找到一个星期日，而用户选择的最后一天可能是一个星期一，因此我需要确定daterangeB的结束日期

start at datefrom,
check if datefrom = dateto, if true end loop,
find out day name, 
check if Sunday, if Sunday add timestamp to array (start),
increment datefrom by 1 day, start loop again.

和

start at datefrom,
check if datefrom = dateto, if true end loop,
find out day name, 
check if Thursday, if Thursday add timestamps to array (start and finish),
increment datefrom by 1 day, start loop again.

麦克风

因此，对于所有感兴趣的人来说，这是我最终所做的事情的一个愚蠢的版本：

$stcars = array();

// Create connection
try {
    $db = new PDO('mysql:host=localhost;dbname=Reports;charset=utf8', 'XXX', 'XXX');

    $db->query('hi'); //invalid query!
} catch(PDOException $ex) {
    echo "An Error occured!" . $ex->getMessage(); //user friendly message
}

    $stmt = $db->prepare('SELECT CarNumber FROM STcars WHERE CarNumber > 0');


    if ($stmt->execute()){

while($row = $stmt->fetch(PDO::FETCH_ASSOC)) {

array_push($stcars, $row[CarNumber]);


}// end while

}// end if

$DateFrom = $_POST["DateFrom"];
$DateTo = $_POST["DateTo"];

$DateToArray = date('m/d/Y', strtotime($DateTo . ' + 1 day')); 


$period = new DatePeriod(
     new DateTime($DateFrom),
     new DateInterval('P1D'),
     new DateTime($DateToArray)
);

foreach($period as $date) 
{

    $daterange[] = $date->format('m/d/Y');

}

//  MS SQL Server with PDO_DBLIB
$DBH = new PDO("dblib:host=$myServer;dbname=$myDB", $myUser, $myPass);

for ($i = 0; $i < count($stcars); ++$i) {

$CarNumber = $stcars[$i];

$STH3 = $DBH->query("SELECT dbo.Driver.DriverNumber, dbo.Driver.DriverName, dbo.DriverLogon.LogonTime, dbo.DriverLogon.LogoffTime, dbo.Vehicle.RegistrationNumber, dbo.OwnerOperator.OOName FROM dbo.Driver INNER JOIN dbo.DriverLogon ON dbo.Driver.DriverID = dbo.DriverLogon.DriverID INNER JOIN dbo.Vehicle ON dbo.DriverLogon.VehicleID = dbo.Vehicle.VehicleID INNER JOIN dbo.OwnerOperator ON dbo.Vehicle.OperatorID = dbo.OwnerOperator.OwnerOperatorID WHERE dbo.Vehicle.CarNumber = '$CarNumber' AND dbo.DriverLogon.LogonTime >= '$DateFrom $Beginning' AND dbo.DriverLogon.LogoffTime <= '$DateTo $End' AND dbo.Driver.DriverNumber != '7777' AND dbo.Driver.DriverNumber != '83890';");

$STH3->setFetchMode(PDO::FETCH_OBJ);

while($row3 = $STH3->fetch()) {

$logonday = date("D", strtotime($row3->LogonTime));

$chkStartTime = strtotime($row3->LogonTime);
$chkEndTime   = strtotime($row3->LogoffTime);
$Tplate = $row3->RegistrationNumber;
$Operator = $row3->OOName;
$logontime = gmdate("D d/m/Y H:i:s", strtotime($row3->LogonTime));
$logofftime = gmdate("D d/m/Y H:i:s", strtotime($row3->LogoffTime));




for ($e = 0; $e < count($daterange); ++$e) {
       $Date = $daterange[$e];
$day = date("D", strtotime($Date)); 




if(strpos( $day, $Mon ) !== FALSE){


$startTime = strtotime($Date . " " . $Beginning);
$endTime   = strtotime($Date . " " . $End);



if($chkStartTime >= $endTime || $chkEndTime <= $startTime){}else
{   
echo "<tr>" ;
echo "<td>" . $day .  "</td> ";
echo "<td>" . $row3->DriverNumber .  "</td> ";
echo "<td>" . $row3->DriverName .  "</td> ";
echo "<td>" . $Operator .  "</td> ";
echo "<td>" . $CarNumber .  "</td> ";
echo "<td>" . $Tplate .  "</td> ";
echo "<td>" . $logontime   .  "</td> ";
echo "<td>" . $logofftime   .  "</td> ";
//echo "<td>" . "Logon after Time End or Logoff before Time Start" .  "</td> ";
//echo "<td>" . gmdate("D d/m/Y G:i:s", strtotime($Date . " " . $Beginning))   . "</td> ";
//echo "<td>" . gmdate("D d/m/Y G:i:s", strtotime($Date . " " . $End))   .  "</td> ";
 echo "</tr>" ;

$list1 ="$day, $row3->DriverNumber, $row3->DriverName, $Operator, $CarNumber, $Tplate, $logontime, $logofftime " . "\n";

fwrite($handle, $list1);

}

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。