$time_s=strtotime("$date 00:00:00");

$time_e=strtotime("$date 23:59:59");

//$where=" and deadline>$time_s AND deadline<$time_e" ;

//$sql="SELECT * FROM `duty_user` where number not in(select distinct number from duty where 1=1 $where)";

$where=" and deadline>$time_s AND deadline<$time_e" ;

//$sql="SELECT * FROM `duty_user` LEFT JOIN duty ON duty_user.number=duty.number WHERE duty.number IS NULL $where;";

$sql = "SELECT duty_user.* FROM `duty_user` left join (select distinct number from duty where 1=1 $where) as tb on tb.number =duty_user.number where tb.number is null;";

//echo $sql;

$query = $db->query($sql);

return $query->fetchAll(PDO::FETCH_ASSOC);

$where="";

$sql="SELECT * FROM duty_user WHERE 1=1 $where";

$query = $db->query($sql);

return $query->fetchAll(PDO::FETCH_ASSOC);

//排除日期

$trimdate=isset($req['trimdate'])?str_replace ('，',',',$req['trimdate']):'';

//添加日期

$adddate=isset($req['adddate'])?str_replace ('，',',',$req['adddate']):'';

$trimdate=$trimdate?explode(',',$trimdate):null;

$adddate=$adddate?explode(',',$adddate):null;

//排除指定天

if($trimdate){

$go=true;//是否统计

foreach($trimdate as $key=>$value){

if($value==$day)return false;

}

}

//排除周末,追加某日

if ($current_week==0 || $current_week==6) {

$go=false;//是否统计

if($adddate){

foreach($adddate as $key=>$value){

if($value==$day)return true;

}

}

return false;

}

return true;

$time_s=strtotime("$date 00:00:00");

$time_e=strtotime("$date 23:59:59");

$where=" number='$user_number' and deadline>$time_s AND deadline<$time_e" ;

$sql = "SELECT deadline FROM duty WHERE $where ORDER BY deadline ASC LIMIT 1";

//echo "$sql";exit();

$res=$db->query($sql);

$on = $res->fetchColumn();

$sql = "SELECT deadline FROM duty WHERE $where ORDER BY deadline DESC LIMIT 1";

$res=$db->query($sql);

$off = $res->fetchColumn();

return [$on,$off];