private function fixDates() { if (is_string($this->startTime)) { $this->startTime = swwat_parse_datetime($this->startTime); } if (is_string($this->stopTime)) { $this->stopTime = swwat_parse_datetime($this->stopTime); } }
/** * @see formatDateTimeKey * @return array of string of form '2012-10-02 10:00 - 11:00' */ public static function selectDateSpan($expoId) { try { $rows = self::select(GROSSPREF_SELECT_DATESPAN, $expoId); $values = array(); foreach ($rows as $row) { $values[] = self::formatDateSpanKey(swwat_parse_datetime($row['startTime']), swwat_parse_datetime($row['stopTime'])); } $rows = NULL; return $values; } catch (PDOException $pe) { logMessage('GrossPreference::selectDateSpan(' . $expoId . ')', $pe->getMessage()); } }
public static function WorkerStationHours($workerid, $stationid, $expoid) { try { $rows = simpleSelect("ShiftStatus", SHIFTSTATUS_SELECT_STATUS_ASC, array($workerid, $stationid, $expoid)); if (!count($rows) == 0) { $hours = 0; for ($k = 0; $k < count($rows); $k++) { if ($rows[$k]->statusType == 'CHECK_OUT') { if (isset($rows[$k - 1]) && $rows[$k - 1]->statusType == 'CHECK_IN') { $start = swwat_parse_datetime($rows[$k - 1]->statusTime); $stop = swwat_parse_datetime($rows[$k]->statusTime); $diff = $start->diff($stop); $hours += $diff->d * 24 + $diff->h + $diff->i / 60 + $diff->s / 360; } } } return $hours; } else { return 0; } } catch (PDOException $pe) { logMessage('ShiftStatus::WorkerStationHours(' . $workerid . ', ' . $stationid . ', ' . $expoid . ')', $pe->getMessage()); } }