public function testIsWeekend()
{
$this->assertTrue(Weekends::isWeekend("2008-07-27"));
$this->assertFalse(Weekends::isWeekend("2008-07-26"));
$this->assertFalse(Weekends::isWeekend("2008-07-25"));
}
if (!empty($holiday) && is_a($holiday, 'Holidays')) {
echo $holiday->getDescription();
} else {
echo $lang_Leave_Closed;
}
?>
<input type="hidden" name="cmbStatus[]" value="<?php
echo $record->getLeaveStatus();
?>
" />
<?php
}
?>
<?php
} else {
if (Weekends::isWeekend($record->getLeaveDate())) {
echo $lang_Leave_Closed;
} else {
echo $statusArr[$record->getLeaveStatus()];
}
?>
<input type="hidden" name="cmbStatus[]" value="<?php
echo $record->getLeaveStatus();
?>
" />
<input type="hidden" name="id[]" value="<?php
echo $record->getLeaveId();
?>
" />
<?php
}
/**
* Adds Leave
*
* @access protected
*/
protected function _addLeave()
{
$this->leaveId = UniqueIDGenerator::getInstance()->getNextID('hs_hr_leave', 'leave_id');
$this->_getLeaveTypeName();
$this->setDateApplied(date('Y-m-d'));
$this->_adjustLeaveLength();
$insertFields[0] = '`leave_id`';
$insertFields[1] = '`leave_date`';
$insertFields[2] = '`leave_length_hours`';
$insertFields[3] = '`leave_length_days`';
$insertFields[4] = '`leave_status`';
$insertFields[5] = '`leave_comments`';
$insertFields[6] = '`leave_request_id`';
$insertFields[7] = '`leave_type_id`';
$insertFields[8] = '`employee_id`';
$arrRecordsList[0] = $this->getLeaveId();
$arrRecordsList[1] = "'" . $this->getLeaveDate() . "'";
$arrRecordsList[2] = "'" . $this->getLeaveLengthHours() . "'";
$arrRecordsList[3] = "'" . $this->getLeaveLengthDays() . "'";
$hours = $this->getLeaveLengthHours();
$days = $this->getLeaveLengthDays();
if ($hours == 0 && $days == 0) {
$arrRecordsList[4] = self::LEAVE_STATUS_LEAVE_CANCELLED;
} else {
$arrRecordsList[4] = $this->statusLeavePendingApproval;
}
$holidays = new Holidays();
$weekends = new Weekends();
if ($weekends->isWeekend($this->getLeaveDate())) {
$arrRecordsList[4] = self::LEAVE_STATUS_LEAVE_WEEKEND;
} elseif ($holidays->isHoliday($this->getLeaveDate())) {
$arrRecordsList[4] = self::LEAVE_STATUS_LEAVE_HOLIDAY;
}
$arrRecordsList[5] = "'" . $this->getLeaveComments() . "'";
$arrRecordsList[6] = "'" . $this->getLeaveRequestId() . "'";
$arrRecordsList[7] = "'" . $this->getLeaveTypeId() . "'";
$arrRecordsList[8] = "'" . $this->getEmployeeId() . "'";
if ($this->getStartTime() != null && $this->getEndTime() != null) {
$insertFields[9] = '`start_time`';
$arrRecordsList[9] = "'" . $this->getStartTime() . "'";
$insertFields[10] = '`end_time`';
$arrRecordsList[10] = "'" . $this->getEndTime() . "'";
}
$arrTable = "`hs_hr_leave`";
$sqlBuilder = new SQLQBuilder();
$query = $sqlBuilder->simpleInsert($arrTable, $arrRecordsList, $insertFields);
$dbConnection = new DMLFunctions();
$result = $dbConnection->executeQuery($query);
return $result;
}
