コード例 #1
0
 public function parseReportData($postArr)
 {
     $parsedObjs = array();
     for ($i = 0; $i < $postArr['recordsCount']; $i++) {
         $attendanceRecordObj = new AttendanceRecord();
         $changed = false;
         if (trim($postArr['txtNewInDate-' . $i]) != $postArr['hdnOldInDate-' . $i]) {
             $changed = true;
         } elseif (trim($postArr['txtNewInTime-' . $i]) != $postArr['hdnOldInTime-' . $i]) {
             $changed = true;
         } elseif (trim($postArr['txtNewInNote-' . $i]) != $postArr['hdnOldInNote-' . $i]) {
             $changed = true;
         } elseif (trim($postArr['txtNewOutDate-' . $i]) != $postArr['hdnOldOutDate-' . $i]) {
             $changed = true;
         } elseif (trim($postArr['txtNewOutTime-' . $i]) != $postArr['hdnOldOutTime-' . $i]) {
             $changed = true;
         } elseif (trim($postArr['txtNewOutNote-' . $i]) != $postArr['hdnOldOutNote-' . $i]) {
             $changed = true;
         } elseif (isset($postArr['chkDeleteStatus-' . $i])) {
             $attendanceRecordObj->setStatus(AttendanceRecord::STATUS_DELETED);
             $changed = true;
         }
         if ($changed) {
             /* Even if only one value is changed, setting other properties
              * is required to carry out functions like checking overlapping
              */
             $attendanceRecordObj->setAttendanceId($postArr['hdnAttendanceId-' . $i]);
             $attendanceRecordObj->setEmployeeId($postArr['hdnEmployeeId']);
             $value = trim($postArr['txtNewInDate-' . $i]) . ' ' . trim($postArr['txtNewInTime-' . $i]);
             $attendanceRecordObj->setInDate($this->_adjustToServerTime('date', $postArr['hdnTimestampDiff-' . $i], $value));
             $attendanceRecordObj->setInTime($this->_adjustToServerTime('time', $postArr['hdnTimestampDiff-' . $i], $value));
             $attendanceRecordObj->setInNote(trim($postArr['txtNewInNote-' . $i]));
             $value = trim($postArr['txtNewOutDate-' . $i]) . ' ' . trim($postArr['txtNewOutTime-' . $i]);
             $attendanceRecordObj->setOutDate($this->_adjustToServerTime('date', $postArr['hdnTimestampDiff-' . $i], $value));
             $attendanceRecordObj->setOutTime($this->_adjustToServerTime('time', $postArr['hdnTimestampDiff-' . $i], $value));
             $attendanceRecordObj->setOutNote(trim($postArr['txtNewOutNote-' . $i]));
             $parsedObjs[] = $attendanceRecordObj;
         }
     }
     return $parsedObjs;
 }
コード例 #2
0
 private function _buildRecordObjects($result, $adjustTime = true)
 {
     while ($row = mysql_fetch_array($result)) {
         $attendanceObj = new AttendanceRecord();
         $attendanceObj->setAttendanceId($row['attendance_id']);
         $attendanceObj->setEmployeeId($row['employee_id']);
         /* $row['punchin_time'] comes in '0000-00-00 00:00:00' format.
          * We want date in '0000-00-00' format and time in '00:00' format.
          */
         $tmpArr = explode(' ', $row['punchin_time']);
         $attendanceObj->setInDate($tmpArr[0]);
         $attendanceObj->setInTime(substr($tmpArr[1], 0, 5));
         if ($row['punchout_time'] != null) {
             $tmpArr = explode(' ', $row['punchout_time']);
             $attendanceObj->setOutDate($tmpArr[0]);
             $attendanceObj->setOutTime(substr($tmpArr[1], 0, 5));
             // Omiting 'seconds' part is ok since it is always zero
         }
         if ($row['in_note'] != null) {
             $attendanceObj->setInNote($row['in_note']);
         }
         if ($row['out_note'] != null) {
             $attendanceObj->setOutNote($row['out_note']);
         }
         $attendanceObj->setTimestampDiff($row['timestamp_diff']);
         $attendanceObj->setStatus($row['status']);
         /* Adjusting time according to the timezone of the place 
          * where the record was first entered.
          */
         if ($adjustTime) {
             /* When saving in the database, timestampDiff is calculated by substracting
              * server timezone offset from client timezone offset. When showing records
              * to user this timestampDiff should be added to each date and time shown.
              */
             $value = $attendanceObj->getInDate() . ' ' . $attendanceObj->getInTime();
             $date = date('Y-m-d', strtotime($value) + $row['timestamp_diff']);
             $time = date('H:i', strtotime($value) + $row['timestamp_diff']);
             $attendanceObj->setInDate($date);
             $attendanceObj->setInTime($time);
             if ($row['punchout_time'] != null) {
                 $value = $attendanceObj->getOutDate() . ' ' . $attendanceObj->getOutTime();
                 $date = date('Y-m-d', strtotime($value) + $row['timestamp_diff']);
                 $time = date('H:i', strtotime($value) + $row['timestamp_diff']);
                 $attendanceObj->setOutDate($date);
                 $attendanceObj->setOutTime($time);
             }
         }
         $attendanceArr[] = $attendanceObj;
     }
     return $attendanceArr;
 }