/**
* 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;
}
public function parseReportParams($postArr)
{
$tmpObj = new TimeEvent();
$tmpObj->setEmployeeId($postArr['txtRepEmpID']);
if ($postArr['cmbProject'] > -1) {
$tmpObj->setProjectId($postArr['cmbProject']);
}
if ($postArr['cmbActivity'] > -1) {
$tmpObj->setActivityId($postArr['cmbActivity']);
}
$fromDate = LocaleUtil::getInstance()->convertToStandardDateFormat($postArr['txtFromDate']);
$toDate = LocaleUtil::getInstance()->convertToStandardDateFormat($postArr['txtToDate']);
return array($tmpObj, $fromDate, $toDate);
}
/**
* 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;
}
/**
* Parse time events and generate the information for timesheets
*
* @param Timesheet timesheet
*/
private function _generateTimesheet($timesheet)
{
$timeEventObj = new TimeEvent();
$timeEventObj->setTimesheetId($timesheet->getTimesheetId());
$timeEventObj->setEmployeeId($timesheet->getEmployeeId());
$timeEventObj->setStartTime($timesheet->getStartDate());
$timeEventObj->setEndTime($timesheet->getEndDate());
$timeEvents = $timeEventObj->fetchTimeEvents();
$durationArr = null;
$dailySum = null;
$activitySum = null;
$totalTime = 0;
for ($i = 0; $i < count($timeEvents); $i++) {
$projectId = $timeEvents[$i]->getProjectId();
$activityId = $timeEvents[$i]->getActivityId();
if ($timeEvents[$i]->getStartTime() != null) {
$expenseDate = strtotime(date('Y-m-d', strtotime($timeEvents[$i]->getStartTime())));
} else {
$expenseDate = strtotime(date('Y-m-d', strtotime($timeEvents[$i]->getReportedDate())));
}
if (!isset($durationArr[$projectId][$activityId][$expenseDate])) {
$durationArr[$projectId][$activityId][$expenseDate] = 0;
}
if (!isset($dailySum[$expenseDate])) {
$dailySum[$expenseDate] = 0;
}
if (!isset($activitySum[$projectId][$activityId])) {
$activitySum[$projectId][$activityId] = 0;
}
$durationArr[$projectId][$activityId][$expenseDate] += $timeEvents[$i]->getDuration();
$dailySum[$expenseDate] += $timeEvents[$i]->getDuration();
$activitySum[$projectId][$activityId] += $timeEvents[$i]->getDuration();
$totalTime += $timeEvents[$i]->getDuration();
}
return array($durationArr, $dailySum, $activitySum, $totalTime);
}
