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);
     }
 }
Example #2
0
 /**
  * @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());
     }
 }
Example #3
0
 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());
     }
 }