I am managing the dates as such:
Code: Select all
If (!isset($_POST['PickDate'])) {
$PickDate = date("l, F d, Y");
} else {
$PickDate = date("l, F d, Y", $_POST['PickDate']);
}
If (!isset($_POST['PickShift'])) {
$PickShift = "Night Shift";
} else {
$PickShift = $_POST['PickShift'];
}Code: Select all
$NightShiftStart = date("Y-m-d H:i:s", mktime(23,00,00,$PickMonth, $PickDay-1, $PickYear));
$NightShiftEnd = date("Y-m-d H:i:s", mktime(06,59,59,$PickMonth, $PickDay, $PickYear));Code: Select all
$NightShiftCountSQL = "SELECT DCM_ID AS DCM, COUNT(ShiftCount) AS COUNT
FROM ester_perpart
WHERE TS BETWEEN '$NightShiftStart' AND '$NightShiftEnd'
GROUP BY DCM_ID
";Code: Select all
$CurrentShiftHour1Start = date("Y-m-d H:i:s", mktime(23,00,00, $PickMonth, $PickDay-1, $PickYear));
$CurrentShiftHour1End = date("Y-m-d H:i:s", mktime(23,59,59, $PickMonth, $PickDay-1, $PickYear));There has to be a better way. I would like to write a single query to handle the 8 hour breaks. Any suggestions ???
Thanks,
Justin