这是我需要的:
打印在特定时间段内有空的员工的 ID,例如:from 28-12-2014 10:00 to 28-12-2014 11:00
根据此图,这些员工可能正在BD上执行其他一些活动: 正在进行的活动表
我有什么:
目前,我正在逐行比较这些日期与我需要的日期,如下所示:
$sql_reservas="SELECT * FROM `Reservas` WHERE `ID_Empleado`= 2";
$result_reservas = mysqli_query($link,$sql_reservas);
if(mysqli_num_rows($result_reservas)>0){
foreach($result_reservas as $row_reservas ) {
ongoing_start = new DateTime("{$row_reservas['Inicio']}"); //28-12-2014 11:45 then 28-12-2014 09:45
ongoing_finish = new DateTime("{$row_reservas['Libre']}"); //28-12-2014 13:45 then 28-12-2014 10:45
new_activity_start = $_POST['date'] //28-12-2014 10:00
new_activity_finish = $_POST['date2'] //28-12-2014 11:00
If(new_activity_start<ongoing_start && new_activity_finish<ongoing_start ){
//I have space before the ongoing activities
echo $row_reservas['ID_Empleado'];
}elseif(new_activity_start>ongoing_finish && new_activity_finish>ongoing_finish) {
//I have space after the ongoing activities
echo $row_reservas['ID_Empleado'];
}else{
//overlaps with the compared one
echo "not available";
}}}
问题:
当只有一个预订(如ID 3或4或5...)时,一切正常,但是当有2个或更多预订(如ID 2)时,它仍然会让我预订空间,因为两个正在进行的活动之一与请求的日期不重叠
我希望你能帮我。
据
我了解,您需要获取该表中的所有员工 ID,这些 ID 在一段时间内是免费的,
使用between
呢?
试试这个:
select ID_Empleado FROM `Reservas` WHERE
(CAST('$date' AS DATETIME) NOT BETWEEN Inicio and Libre)
AND
(CAST('$date2' AS DATETIME) NOT BETWEEN Inicio and Libre)
$date
和$date2
是来自$_POST[]
解释:获取所需开始日期和所需结束日期不在活动的开始日期和结束日期之间的员工 ID