/**
* Add the Leave Type
*
*/
public function addLeaveType()
{
$this->leaveTypeId = UniqueIDGenerator::getInstance()->getNextID('hs_hr_leavetype', 'leave_type_id', 'LTY');
$arrRecordsList[0] = "'" . $this->getLeaveTypeId() . "'";
$arrRecordsList[1] = "'" . $this->getLeaveTypeName() . "'";
$arrRecordsList[2] = $this->availableStatusFlag;
$sqlBuilder = new SQLQBuilder();
$arrTable = "`hs_hr_leavetype`";
$query = $sqlBuilder->simpleInsert($arrTable, $arrRecordsList);
$dbConnection = new DMLFunctions();
$result = $dbConnection->executeQuery($query);
return $result;
}
/**
* Adds a day incase the day is not there.
*
* Unlikely to happen, but added as an auto heal feature.
* Needs a filled object.
*
* @access private
*/
private function _addDay()
{
$arrRecordsList[0] = $this->getDay();
$arrRecordsList[1] = $this->getLength();
$insertTable = "`" . self::WEEKENDS_TABLE . "`";
$sqlBuilder = new SQLQBuilder();
$query = $sqlBuilder->simpleInsert($insertTable, $arrRecordsList) . " ON DUPLICATE KEY UPDATE " . self::WEEKENDS_TABLE_LENGTH . " = " . $this->getLength();
//echo $query;
$dbConnection = new DMLFunctions();
$result = $dbConnection->executeQuery($query);
}
/**
* Add a new timesheet
*
* Status will be overwritten
*/
public function addTimesheet()
{
$newId = UniqueIDGenerator::getInstance()->getNextID(self::TIMESHEET_DB_TABLE_TIMESHEET, self::TIMESHEET_DB_FIELD_TIMESHEET_ID);
$this->setTimesheetId($newId);
if ($this->getStartDate() == '' || $this->getEndDate() == '') {
$this->_getNewDates();
}
$this->setStatus(self::TIMESHEET_STATUS_NOT_SUBMITTED);
$sql_builder = new SQLQBuilder();
$insertTable = self::TIMESHEET_DB_TABLE_TIMESHEET;
$insertFields[0] = "`" . self::TIMESHEET_DB_FIELD_TIMESHEET_ID . "`";
$insertFields[1] = "`" . self::TIMESHEET_DB_FIELD_EMPLOYEE_ID . "`";
$insertFields[2] = "`" . self::TIMESHEET_DB_FIELD_TIMESHEET_PERIOD_ID . "`";
$insertFields[3] = "`" . self::TIMESHEET_DB_FIELD_START_DATE . "`";
$insertFields[4] = "`" . self::TIMESHEET_DB_FIELD_END_DATE . "`";
$insertFields[5] = "`" . self::TIMESHEET_DB_FIELD_STATUS . "`";
$insertValues[0] = $this->getTimesheetId();
$insertValues[1] = $this->getEmployeeId();
$insertValues[2] = $this->getTimesheetPeriodId();
$insertValues[3] = "'" . $this->getStartDate() . "'";
$insertValues[4] = "'" . $this->getEndDate() . "'";
$insertValues[5] = $this->getStatus();
$insertValues = $sql_builder->quoteCorrect($insertValues);
$query = $sql_builder->simpleInsert($insertTable, $insertValues, $insertFields);
$dbConnection = new DMLFunctions();
$result = $dbConnection->executeQuery($query);
if ($result && mysql_affected_rows() > 0) {
return true;
}
return false;
}
/**
* Add new time event
*
* Time event id will be over written
*
* @throws TimeEventException Overlapping time period 2
*/
public function addTimeEvent()
{
if ($this->getStartTime() != null && $this->getEmployeeId() != null) {
$this->_checkStartTimeInTimeEvent();
}
$this->_isOverlapping();
$newId = UniqueIDGenerator::getInstance()->getNextID(self::TIME_EVENT_DB_TABLE_TIME_EVENT, self::TIME_EVENT_DB_FIELD_TIME_EVENT_ID);
$this->setTimeEventId($newId);
$insertTable = "`" . self::TIME_EVENT_DB_TABLE_TIME_EVENT . "`";
$insertFields[0] = "`" . self::TIME_EVENT_DB_FIELD_TIME_EVENT_ID . "`";
$insertFields[1] = "`" . self::TIME_EVENT_DB_FIELD_PROJECT_ID . "`";
$insertFields[2] = "`" . self::TIME_EVENT_DB_FIELD_ACTIVITY_ID . "`";
$insertFields[3] = "`" . self::TIME_EVENT_DB_FIELD_EMPLOYEE_ID . "`";
$insertFields[4] = "`" . self::TIME_EVENT_DB_FIELD_TIMESHEET_ID . "`";
$insertValues[0] = $this->getTimeEventId();
$insertValues[1] = $this->getProjectId();
$insertValues[2] = $this->getActivityId();
$insertValues[3] = $this->getEmployeeId();
$insertValues[4] = $this->getTimesheetId();
if ($this->getStartTime() != null) {
$insertFields[] = "`" . self::TIME_EVENT_DB_FIELD_START_TIME . "`";
$insertValues[] = "'" . $this->getStartTime() . "'";
}
if ($this->getEndTime() != null) {
$insertFields[] = "`" . self::TIME_EVENT_DB_FIELD_END_TIME . "`";
$insertValues[] = "'" . $this->getEndTime() . "'";
}
if ($this->getReportedDate() != null) {
$insertFields[] = "`" . self::TIME_EVENT_DB_FIELD_REPORTED_DATE . "`";
$insertValues[] = "'" . $this->getReportedDate() . "'";
}
if ($this->getDuration() != null) {
$insertFields[] = "`" . self::TIME_EVENT_DB_FIELD_DURATION . "`";
$insertValues[] = $this->getDuration();
}
if ($this->getDescription() != null) {
$insertFields[] = "`" . self::TIME_EVENT_DB_FIELD_DESCRIPTION . "`";
$insertValues[] = "'" . $this->getDescription() . "'";
}
$sqlBuilder = new SQLQBuilder();
$query = $sqlBuilder->simpleInsert($insertTable, $insertValues, $insertFields);
$dbConnection = new DMLFunctions();
$result = $dbConnection->executeQuery($query);
if ($result) {
if (mysql_affected_rows() > 0) {
return true;
}
}
return false;
}
/**
* Adds Record to Leave Request
*
* @access private
*/
private function _addLeaveRequest()
{
$newId = UniqueIDGenerator::getInstance()->getNextID('hs_hr_leave_requests', 'leave_request_id');
$this->setLeaveRequestId($newId);
$this->_getLeaveTypeName();
$this->setDateApplied(date('Y-m-d'));
$arrRecordsList[0] = $this->getLeaveRequestId();
$arrRecordsList[1] = "'" . $this->getLeaveTypeId() . "'";
$arrRecordsList[2] = "'" . $this->getLeaveTypeName() . "'";
$arrRecordsList[3] = "'" . $this->getDateApplied() . "'";
$arrRecordsList[4] = "'" . $this->getEmployeeId() . "'";
$arrTable = "`hs_hr_leave_requests`";
$sqlBuilder = new SQLQBuilder();
$query = $sqlBuilder->simpleInsert($arrTable, $arrRecordsList);
$dbConnection = new DMLFunctions();
$result = $dbConnection->executeQuery($query);
return $result;
}
/**
* This function is to save initial summary data for one employee. Used when a new
* employee is added at PIM module.
*/
public static function saveInitialSummaryForOneEmployee($empId)
{
$both = self::getYearsAndPlans();
if (!empty($both)) {
$count1 = count($both);
for ($i = 0; $i < $count1; $i++) {
$count2 = count($both[$i]['plan']);
for ($j = 0; $j < $count2; $j++) {
$insertTable = "`" . parent::DB_TABLE_HSP_SUMMARY . "`";
$insertFields[0] = "`" . parent::DB_FIELD_SUMMARY_ID . "`";
$insertFields[1] = "`" . parent::DB_FIELD_EMPLOYEE_ID . "`";
$insertFields[2] = "`" . parent::DB_FIELD_HSP_PLAN_ID . "`";
$insertFields[3] = "`" . parent::DB_FIELD_HSP_PLAN_YEAR . "`";
$insertFields[4] = "`" . parent::DB_FIELD_HSP_PLAN_STATUS . "`";
$insertFields[5] = "`" . parent::DB_FIELD_ANNUAL_LIMIT . "`";
$insertFields[6] = "`" . parent::DB_FIELD_EMPLOYER_AMOUNT . "`";
$insertFields[7] = "`" . parent::DB_FIELD_EMPLOYEE_AMOUNT . "`";
$insertFields[8] = "`" . parent::DB_FIELD_TOTAL_ACCRUED . "`";
$insertFields[9] = "`" . parent::DB_FIELD_TOTAL_USED . "`";
$insertValues[0] = UniqueIDGenerator::getInstance()->getNextID(parent::DB_TABLE_HSP_SUMMARY, parent::DB_FIELD_SUMMARY_ID);
$insertValues[1] = $empId;
$insertValues[2] = $both[$i]['plan'][$j];
$insertValues[3] = $both[$i]['year'];
$insertValues[4] = 1;
$insertValues[5] = 0;
$insertValues[6] = 0;
$insertValues[7] = 0;
$insertValues[8] = 0;
$insertValues[9] = 0;
$sqlBuilder = new SQLQBuilder();
$query = $sqlBuilder->simpleInsert($insertTable, $insertValues, $insertFields);
$dbConnection = new DMLFunctions();
$dbConnection->executeQuery($query);
}
}
}
}
/**
* Add Leave Quota of an employee
*
* @param String $employeeId
* @return boolean
* @access public
*/
public function addLeaveQuota($employeeId)
{
$this->setEmployeeId($employeeId);
$sqlBuilder = new SQLQBuilder();
$insertTable = "`" . self::LEAVEQUOTA_DB_TABLE_EMPLOYEE_LEAVE_QUOTA . "`";
$insertFields[0] = "`" . self::LEAVEQUOTA_DB_FIELD_YEAR . "`";
$insertFields[1] = "`" . self::LEAVEQUOTA_DB_FIELD_LEAVE_TYPE_ID . "`";
$insertFields[2] = "`" . self::LEAVEQUOTA_DB_FIELD_EMPLOYEE_ID . "`";
$insertFields[3] = "`" . self::LEAVEQUOTA_DB_FIELD_NO_OF_DAYS_ALLOTED . "`";
$insertValues[0] = "'" . $this->getYear() . "'";
$insertValues[1] = "'" . $this->getLeaveTypeId() . "'";
$insertValues[2] = "'" . $this->getEmployeeId() . "'";
$insertValues[3] = $this->getNoOfDaysAllotted();
$query = $sqlBuilder->simpleInsert($insertTable, $insertValues, $insertFields);
$dbConnection = new DMLFunctions();
$result = $dbConnection->executeQuery($query);
if ($result) {
return true;
}
return false;
}
/**
* Add Holiday - one at a time
*
* The object needs to be filled, except for the id.
*
* @access public
*/
public function add()
{
$this->holidayId = UniqueIDGenerator::getInstance()->getNextID(self::HOLIDAYS_TABLE, self::HOLIDAYS_TABLE_HOLIDAY_ID);
$arrRecordsList[0] = $this->getHolidayId();
$arrRecordsList[1] = "'" . $this->getDescription() . "'";
$arrRecordsList[2] = "'" . $this->getDate() . "'";
$arrRecordsList[3] = $this->getRecurring();
$arrRecordsList[4] = $this->getLength();
$arrTable = self::HOLIDAYS_TABLE;
$sqlBuilder = new SQLQBuilder();
$query = $sqlBuilder->simpleInsert($arrTable, $arrRecordsList);
//echo $query;
$dbConnection = new DMLFunctions();
$result = $dbConnection->executeQuery($query);
}
/**
* 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;
}
$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;
}
public function add()
{
$this->id = UniqueIDGenerator::getInstance()->getNextID(self::PAY_PERIOD_DB_TABLE, self::PAY_PERIOD_DB_FIELD_ID);
$arrTable = '`' . self::PAY_PERIOD_DB_TABLE . '`';
$insertFields[0] = '`' . self::PAY_PERIOD_DB_FIELD_ID . '`';
$insertFields[1] = '`' . self::PAY_PERIOD_DB_FIELD_START_DATE . '`';
$insertFields[2] = '`' . self::PAY_PERIOD_DB_FIELD_END_DATE . '`';
$insertFields[3] = '`' . self::PAY_PERIOD_DB_FIELD_CLOSE_DATE . '`';
$insertFields[4] = '`' . self::PAY_PERIOD_DB_FIELD_CHECK_DATE . '`';
$insertFields[5] = '`' . self::PAY_PERIOD_DB_FIELD_TIMESHEET_APROVAL_DUE_DATE . '`';
$arrRecordsList[0] = $this->id;
$arrRecordsList[1] = "'" . $this->startDate . "'";
$arrRecordsList[2] = "'" . $this->endDate . "'";
$arrRecordsList[3] = "'" . $this->closeDate . "'";
$arrRecordsList[4] = "'" . $this->checkDate . "'";
$arrRecordsList[5] = "'" . $this->timesheetAprovalDueDate . "'";
$sqlBuilder = new SQLQBuilder();
$query = $sqlBuilder->simpleInsert($arrTable, $arrRecordsList, $insertFields);
$dbConnection = new DMLFunctions();
$result = $dbConnection->executeQuery($query);
/*if ($result) {
return mysql_affected_rows();
} else {
throw new HspPayPeriodException("Error in SQL Query", HspPayPeriodException::ERROR_IN_DB_QUERY);
}*/
return $result;
}
public function addHspRequest()
{
$this->id = UniqueIDGenerator::getInstance()->getNextID(self::HSP_PAYMENT_REQUEST_DB_TABLE, self::DB_FIELD_ID);
$arrTable = '`' . self::HSP_PAYMENT_REQUEST_DB_TABLE . '`';
$insertFields[] = '`' . self::DB_FIELD_ID . '`';
$insertFields[] = '`' . self::DB_FIELD_HSP_ID . '`';
$insertFields[] = '`' . self::DB_FIELD_EMPLOYEE_ID . '`';
$insertFields[] = '`' . self::DB_FIELD_DATE_INCURRED . '`';
$insertFields[] = '`' . self::DB_FIELD_PROVIDER_NAME . '`';
$insertFields[] = '`' . self::DB_FIELD_PERSON_INCURRING_EXPENSE . '`';
$insertFields[] = '`' . self::DB_FIELD_EXPENSE_DESCRIPTION . '`';
$insertFields[] = '`' . self::DB_FIELD_EXPENSE_AMOUNT . '`';
$insertFields[] = '`' . self::DB_FIELD_PAYMENT_MADE_TO . '`';
$insertFields[] = '`' . self::DB_FIELD_THIRD_PARTY_ACCOUNT_NUMBER . '`';
$insertFields[] = '`' . self::DB_FIELD_MAIL_ADDRESS . '`';
$insertFields[] = '`' . self::DB_FIELD_COMMENTS . '`';
$insertFields[] = '`' . self::DB_FIELD_STATUS . '`';
$arrRecordsList[] = $this->id;
$arrRecordsList[] = "'" . $this->hspId . "'";
$arrRecordsList[] = "'" . $this->employeeId . "'";
$arrRecordsList[] = "'" . $this->dateIncurred . "'";
$arrRecordsList[] = "'" . $this->providerName . "'";
$arrRecordsList[] = "'" . $this->personIncurringExpense . "'";
$arrRecordsList[] = "'" . $this->expenseDescription . "'";
$arrRecordsList[] = "'" . $this->expenseAmount . "'";
$arrRecordsList[] = "'" . $this->paymentMadeTo . "'";
$arrRecordsList[] = "'" . $this->thirdPartyAccountNumber . "'";
$arrRecordsList[] = "'" . $this->mailAddress . "'";
$arrRecordsList[] = "'" . $this->comments . "'";
$arrRecordsList[] = "'" . $this->status . "'";
if ($this->datePaid != null) {
$insertFields[] = '`' . self::DB_FIELD_DATE_PAID . '`';
$arrRecordsList[] = "'" . $this->datePaid . "'";
}
if ($this->checkNumber != null) {
$insertFields[] = '`' . self::DB_FIELD_CHECK_NUMBER . '`';
$arrRecordsList[] = "'" . $this->checkNumber . "'";
}
if ($this->hrNotes != null) {
$insertFields[] = '`' . self::DB_FIELD_HR_NOTES . '`';
$arrRecordsList[] = "'" . $this->hrNotes . "'";
}
$sqlBuilder = new SQLQBuilder();
$query = $sqlBuilder->simpleInsert($arrTable, $arrRecordsList, $insertFields);
$dbConnection = new DMLFunctions();
$result = $dbConnection->executeQuery($query);
//if ($result) {
// return mysql_affected_rows();
//} else {
// throw new HspPaymentRequestException("Error in SQL Query", HspPaymentRequestException::ERROR_IN_DB_QUERY);
//}
if ($result) {
return true;
} else {
return false;
}
}
private function _addNotificationStatus()
{
$sqlQBuilder = new SQLQBuilder();
$arrFields[0] = '`user_id`';
$arrFields[1] = '`notification_type_id`';
$arrFields[2] = '`status`';
$insertValues[0] = "'{$this->getUserId()}'";
$insertValues[1] = "'{$this->getNotifcationTypeId()}'";
$insertValues[2] = $this->getNotificationStatus();
$arrTable = "`hs_hr_mailnotifications`";
$query = $sqlQBuilder->simpleInsert($arrTable, $insertValues, $arrFields, true);
$dbConnection = new DMLFunctions();
$result = $dbConnection->executeQuery($query);
return $result;
}
/**
*
*/
public function addRecord()
{
if (!isset($this->employeeId) || !isset($this->inDate) || !isset($this->inTime)) {
throw new AttendanceRecordException('Adding record: Required values are missing', AttendanceRecordException::ADDING_REQUIRED_VALUES_MISSING);
}
$insertTable = "`" . self::DB_TABLE . "`";
$insertFields[] = "`" . self::DB_FIELD_ATTENDANCE_ID . "`";
$insertValues[] = UniqueIDGenerator::getInstance()->getNextID(self::DB_TABLE, self::DB_FIELD_ATTENDANCE_ID);
$insertFields[] = "`" . self::DB_FIELD_EMPLOYEE_ID . "`";
$insertValues[] = "'{$this->employeeId}'";
$insertFields[] = "`" . self::DB_FIELD_PUNCHIN_TIME . "`";
$insertValues[] = "'{$this->inDate} {$this->inTime}'";
if (isset($this->inNote)) {
$insertFields[] = "`" . self::DB_FIELD_IN_NOTE . "`";
$insertValues[] = "'{$this->inNote}'";
}
$insertFields[] = "`" . self::DB_FIELD_TIMESTAMP_DIFF . "`";
$insertValues[] = "'{$this->timestampDiff}'";
$insertFields[] = "`" . self::DB_FIELD_STATUS . "`";
$insertValues[] = "'" . self::STATUS_ACTIVE . "'";
$sqlBuilder = new SQLQBuilder();
$query = $sqlBuilder->simpleInsert($insertTable, $insertValues, $insertFields);
$dbConnection = new DMLFunctions();
$result = $dbConnection->executeQuery($query);
if ($result) {
return true;
} else {
return false;
}
}
