public function resolveTimesheet($submissionPeriodId = null)
{
if ($this->getTimesheetId() == null) {
$timesheetObj = new Timesheet();
$timesheetSubmissionPeriodObj = new TimesheetSubmissionPeriod();
if ($submissionPeriodId != null) {
$timesheetSubmissionPeriodObj->setTimesheetPeriodId($submissionPeriodId);
}
$timesheetSubmissionPeriods = $timesheetSubmissionPeriodObj->fetchTimesheetSubmissionPeriods();
$startTime = $this->getStartTime();
if (!isset($startTime)) {
$startTime = $this->getReportedDate();
}
$currTime = strtotime($startTime);
$day = date('N', $currTime);
$diff = $timesheetSubmissionPeriods[0]->getStartDay() - $day;
if ($diff > 0) {
$diff = $diff - 7;
}
$sign = $diff < 0 ? "" : "+";
$timesheetObj->setStartDate(date('Y-m-d', strtotime("{$sign}{$diff} day", $currTime)));
$diff = $timesheetSubmissionPeriods[0]->getEndDay() - $day;
if (0 > $diff) {
$diff = $diff + 7;
}
$sign = $diff < 0 ? "" : "+";
$timesheetObj->setEndDate(date('Y-m-d', strtotime("{$sign}{$diff} day", $currTime)) . " 23:59:59");
$timesheetObj->setTimesheetPeriodId($timesheetSubmissionPeriods[0]->getTimesheetPeriodId());
$timesheetObj->setEmployeeId($this->getEmployeeId());
$timesheets = $timesheetObj->fetchTimesheets();
if (!$timesheets || !$timesheets[0]) {
$timesheetObj->setStatus(Timesheet::TIMESHEET_STATUS_NOT_SUBMITTED);
$timesheetObj->addTimesheet();
$timesheetObj->setTimesheetId(null);
$timesheets = $timesheetObj->fetchTimesheets();
}
$this->setTimesheetId($timesheets[0]->getTimesheetId());
}
}
/**
* Build the object with fetched records
*
* @access private
* @return Timesheet[] array of timesheets
*/
private function _buildObjArr($result)
{
$objArr = null;
while ($row = mysql_fetch_assoc($result)) {
$tmpTimeArr = new Timesheet();
$tmpTimeArr->setTimesheetId($row[self::TIMESHEET_DB_FIELD_TIMESHEET_ID]);
$tmpTimeArr->setEmployeeId($row[self::TIMESHEET_DB_FIELD_EMPLOYEE_ID]);
$tmpTimeArr->setTimesheetPeriodId($row[self::TIMESHEET_DB_FIELD_TIMESHEET_PERIOD_ID]);
$tmpTimeArr->setStartDate(date('Y-m-d', strtotime($row[self::TIMESHEET_DB_FIELD_START_DATE])));
$tmpTimeArr->setEndDate(date('Y-m-d', strtotime($row[self::TIMESHEET_DB_FIELD_END_DATE])));
$tmpTimeArr->setStatus($row[self::TIMESHEET_DB_FIELD_STATUS]);
$tmpTimeArr->setComment($row[self::TIMESHEET_DB_FIELD_COMMENT]);
$objArr[] = $tmpTimeArr;
}
return $objArr;
}