/**
* Build the object with fetched records
*
* @access private
* @return TimeEvent[] array of time events
*/
private function _buildObjArr($result)
{
$objArr = null;
while ($row = mysql_fetch_assoc($result)) {
$tmpEventArr = new TimeEvent();
$tmpEventArr->setTimeEventId($row[self::TIME_EVENT_DB_FIELD_TIME_EVENT_ID]);
$tmpEventArr->setProjectId($row[self::TIME_EVENT_DB_FIELD_PROJECT_ID]);
$tmpEventArr->setActivityId($row[self::TIME_EVENT_DB_FIELD_ACTIVITY_ID]);
$tmpEventArr->setEmployeeId($row[self::TIME_EVENT_DB_FIELD_EMPLOYEE_ID]);
$tmpEventArr->setTimesheetId($row[self::TIME_EVENT_DB_FIELD_TIMESHEET_ID]);
if (!empty($row[self::TIME_EVENT_DB_FIELD_START_TIME])) {
$tmpEventArr->setStartTime(date('Y-m-d H:i', strtotime($row[self::TIME_EVENT_DB_FIELD_START_TIME])));
}
if (!empty($row[self::TIME_EVENT_DB_FIELD_END_TIME])) {
$tmpEventArr->setEndTime(date('Y-m-d H:i', strtotime($row[self::TIME_EVENT_DB_FIELD_END_TIME])));
}
$tmpEventArr->setReportedDate(date('Y-m-d', strtotime($row[self::TIME_EVENT_DB_FIELD_REPORTED_DATE])));
$tmpEventArr->setDuration($row[self::TIME_EVENT_DB_FIELD_DURATION]);
$tmpEventArr->setDescription($row[self::TIME_EVENT_DB_FIELD_DESCRIPTION]);
$objArr[] = $tmpEventArr;
}
return $objArr;
}
public function parseEditTimegrid($postArr)
{
$gridCount = $postArr['hdnGridCount'];
$datesCount = $postArr['hdnDatesCount'];
$employeeId = $postArr['txtEmployeeId'];
$timesheetId = $postArr['txtTimesheetId'];
$updateList = array();
$addList = array();
for ($i = 0; $i < $gridCount; $i++) {
for ($j = 0; $j < $datesCount; $j++) {
if (isset($postArr["hdnTimeEventId-{$i}-{$j}"])) {
// An exsiting time event
if ($postArr["txtDuration-{$i}-{$j}"] != $postArr["hdnDuration-{$i}-{$j}"] || $postArr["txtComment-{$i}-{$j}"] != $postArr["hdntxtComment-{$i}-{$j}"] || $postArr["cmbProject-{$i}"] != $postArr["hdnProject-{$i}"] || $postArr["cmbActivity-{$i}"] != $postArr["hdnActivity-{$i}"]) {
// If there is no change from previous value, no need to update the time event
// This check can only be done if $postArr["hdnTimeEventId-$i-$j"] is set
$timeEvent = new TimeEvent();
$timeEvent->setTimeEventId($postArr["hdnTimeEventId-{$i}-{$j}"]);
$timeEvent->setEmployeeId($employeeId);
$timeEvent->setProjectId($postArr["cmbProject-{$i}"]);
$timeEvent->setActivityId($postArr["cmbActivity-{$i}"]);
$timeEvent->setDuration($postArr["txtDuration-{$i}-{$j}"] * 3600);
$timeEvent->setReportedDate($postArr["hdnReportedDate-{$j}"]);
$timeEvent->setDescription($postArr["txtComment-{$i}-{$j}"]);
$updateList[] = $timeEvent;
}
} else {
// A new time event
if ($postArr["txtDuration-{$i}-{$j}"] != '') {
// If no value has been put, no need to add a new time event
$timeEvent = new TimeEvent();
$timeEvent->setTimesheetId($timesheetId);
$timeEvent->setEmployeeId($employeeId);
$timeEvent->setProjectId($postArr["cmbProject-{$i}"]);
$timeEvent->setActivityId($postArr["cmbActivity-{$i}"]);
$timeEvent->setDuration($postArr["txtDuration-{$i}-{$j}"] * 3600);
$timeEvent->setReportedDate($postArr["hdnReportedDate-{$j}"]);
$timeEvent->setDescription($postArr["txtComment-{$i}-{$j}"]);
$addList[] = $timeEvent;
}
}
}
}
$eventsList[0] = $updateList;
$eventsList[1] = $addList;
return $eventsList;
}
/**
* Constructs and returns time event with given parameters
*/
private function _getTimeEvent($timeEventId, $projectId, $employeeId, $timesheetId, $startTime, $endTime, $reportedDate, $duration, $description, $activityId = 1)
{
$timeEvent = new TimeEvent();
$timeEvent->setTimeEventId($timeEventId);
$timeEvent->setActivityId($activityId);
$timeEvent->setProjectId($projectId);
$timeEvent->setEmployeeId($employeeId);
$timeEvent->setTimesheetId($timesheetId);
$timeEvent->setStartTime($startTime);
$timeEvent->setEndTime($endTime);
$timeEvent->setReportedDate($reportedDate);
$timeEvent->setDuration($duration);
$timeEvent->setDescription($description);
return $timeEvent;
}
public function testIsUnfinishedTimesheet()
{
$this->assertTrue(TimeEvent::isUnfinishedTimesheet(10));
$this->assertFalse(TimeEvent::isUnfinishedTimesheet(11));
}
public function parseActivityReportParams($postArr)
{
$tmpObj = new TimeEvent();
$tmpObj->setProjectId($postArr['cmbProject']);
$tmpObj->setActivityId($postArr['activityId']);
$tmpObj->setDuration($postArr['time']);
$fromDate = LocaleUtil::getInstance()->convertToStandardDateFormat($postArr['txtFromDate']);
$toDate = LocaleUtil::getInstance()->convertToStandardDateFormat($postArr['txtToDate']);
$pageNo = isset($_POST['pageNo']) ? $postArr['pageNo'] : 1;
return array($tmpObj, $fromDate, $toDate, $pageNo);
}
/**
* Validates the timeevent against the given timesheet.
*
* @param TimeEvent $timeEvent Time event to validate
* @param Timesheet $timesheet Time sheet
* @return mixed true if validate success, error string if not.
*/
public function validateTimeEvent($timeEvent, $timesheet)
{
$eventStartTime = $timeEvent->getStartTime();
$eventEndTime = $timeEvent->getEndTime();
$eventStart = strtotime($eventStartTime);
$eventEnd = strtotime($eventEndTime);
$periodStartDate = $timesheet->getStartDate();
$periodEndDate = $timesheet->getEndDate();
$periodStart = strtotime($periodStartDate);
$periodEnd = strtotime($periodEndDate);
$periodEnd = strtotime("+1 day", $periodEnd);
// strtotime returns false (-1 before php 5.1.0) on error
if (!($periodStart > 0) || !($periodEnd > 0) || $periodStart >= $periodEnd) {
return self::INVALID_TIMESHEET_PERIOD_ERROR;
}
$reportedDate = $timeEvent->getReportedDate();
$reported = strtotime($reportedDate);
$eventId = $timeEvent->getTimeEventId();
$newEvent = empty($eventId);
if (!CommonFunctions::IsValidId($timeEvent->getProjectId())) {
return self::ProjectNotSpecified_ERROR;
}
if (!CommonFunctions::IsValidId($timeEvent->getActivityId())) {
return self::ActivityNotSpecified_ERROR;
}
if (!empty($eventStartTime) && !($eventStart > 0)) {
return self::InvalidStartTime_ERROR;
}
if (!empty($eventEndTime) && !($eventEnd > 0)) {
return self::InvalidEndTime_ERROR;
}
if (empty($reportedDate)) {
return self::ReportedDateNotSpecified_ERROR;
} else {
if (!($reported > 0)) {
return self::InvalidReportedDate_ERROR;
}
}
$duration = $timeEvent->getDuration();
$duration = $duration === "" ? null : $duration;
// 0 not allowed for duration in last row.
if (!is_null($duration) && ($duration < 0 || $newEvent && $duration == 0)) {
return self::InvalidDuration_ERROR;
}
// Validate period/interval
if (empty($eventStartTime) && empty($eventEndTime) && !empty($duration)) {
// reported date + duration
if ($reported < $periodStart || $reported + $duration > $periodEnd) {
return self::EVENT_OUTSIDE_PERIOD_FAILURE;
}
} else {
if (!empty($eventStartTime) && empty($eventEndTime) && is_null($duration)) {
// start time only
if ($eventStart < $periodStart || $eventStart > $periodEnd) {
return self::EVENT_OUTSIDE_PERIOD_FAILURE;
}
} else {
if (!empty($eventStartTime) && !empty($eventEndTime)) {
if (!empty($duration) && $newEvent) {
return self::NotAllowedToSpecifyDurationAndInterval_ERROR;
}
// start and end time
if ($eventStart >= $eventEnd) {
return self::ZeroOrNegativeIntervalSpecified_ERROR;
}
if ($eventStart < $periodStart || $eventEnd > $periodEnd) {
return self::EVENT_OUTSIDE_PERIOD_FAILURE;
}
$timeEvent->setDuration($eventEnd - $eventStart);
} else {
if (!empty($eventStartTime) && !empty($duration) && empty($eventEndTime)) {
// start time and duration
if ($eventStart < $periodStart || $eventStart + $duration > $periodEnd) {
return self::EVENT_OUTSIDE_PERIOD_FAILURE;
}
$timeEvent->setEndTime(date("Y-m-d H:i", $eventStart + $duration));
} else {
return self::NoValidDurationOrInterval_ERROR;
}
}
}
}
return true;
}
