function calcExceptions($user_date_id, $enable_premature_exceptions = FALSE, $enable_future_exceptions = TRUE)
{
global $profiler;
$profiler->startTimer("ExceptionPolicy::calcExceptions()");
if ($user_date_id == '') {
return FALSE;
}
Debug::text(' User Date ID: ' . $user_date_id . ' PreMature: ' . (int) $enable_premature_exceptions, __FILE__, __LINE__, __METHOD__, 10);
//Get user date info
$udlf = new UserDateListFactory();
$udlf->getById($user_date_id);
if ($udlf->getRecordCount() > 0) {
$user_date_obj = $udlf->getCurrent();
if ($enable_future_exceptions == FALSE and $user_date_obj->getDateStamp() > TTDate::getEndDayEpoch()) {
return FALSE;
}
} else {
return FALSE;
}
//Since we are not usng demerits yet, just always delete exceptions and re-calculate them
$elf = new ExceptionListFactory();
$elf->getByUserDateID($user_date_id);
if ($elf->getRecordCount() > 0) {
foreach ($elf as $e_obj) {
Debug::text(' Deleting Exception: ' . $e_obj->getID(), __FILE__, __LINE__, __METHOD__, 10);
$e_obj->Delete();
}
}
//Get all Punches on this date for this user.
$plf = new PunchListFactory();
$plf->getByUserDateId($user_date_id);
if ($plf->getRecordCount() > 0) {
Debug::text(' Found Punches: ' . $plf->getRecordCount(), __FILE__, __LINE__, __METHOD__, 10);
}
$slf = new ScheduleListFactory();
$slf->getByUserDateIdAndStatusId($user_date_id, 10);
if ($slf->getRecordCount() > 0) {
Debug::text(' Found Schedule: ' . $slf->getRecordCount(), __FILE__, __LINE__, __METHOD__, 10);
}
$schedule_id_cache = NULL;
//Cache schedule IDs so we don't need to do a lookup for every exception.
//Get all active exceptions.
$eplf = new ExceptionPolicyListFactory();
$eplf->getByPolicyGroupUserIdAndActive($user_date_obj->getUser(), TRUE);
if ($eplf->getRecordCount() > 0) {
Debug::text(' Found Active Exceptions: ' . $eplf->getRecordCount(), __FILE__, __LINE__, __METHOD__, 10);
foreach ($eplf as $ep_obj) {
//Debug::text(' Found Exception Type: '. $ep_obj->getType() .' ID: '. $ep_obj->getID() .' Control ID: '. $ep_obj->getExceptionPolicyControl(), __FILE__, __LINE__, __METHOD__,10);
if ($enable_premature_exceptions == TRUE and self::isPreMature($ep_obj->getType()) == TRUE) {
//Debug::text(' Premature Exception: '. $ep_obj->getType() , __FILE__, __LINE__, __METHOD__,10);
$type_id = 5;
//Pre-Mature
} else {
//Debug::text(' NOT Premature Exception: '. $ep_obj->getType() , __FILE__, __LINE__, __METHOD__,10);
$type_id = 50;
//Active
}
switch (strtolower($ep_obj->getType())) {
case 's1':
//Unscheduled Absence... Anytime they are scheduled and have not punched in.
//Ignore these exceptions if the schedule is after today (not including today),
//so if a supervisors schedules an employee two days in advance they don't get a unscheduled
//absence appearing right away.
if ($plf->getRecordCount() == 0) {
if ($slf->getRecordCount() > 0) {
foreach ($slf as $s_obj) {
if ($s_obj->getStatus() == 10 and TTDate::getBeginDayEpoch($s_obj->getStartTime()) - TTDate::getBeginDayEpoch(TTDate::getTime()) <= 0) {
$ef = new ExceptionFactory();
$ef->setUserDateID($user_date_id);
$ef->setExceptionPolicyID($ep_obj->getId());
$ef->setType($type_id);
$ef->setEnableDemerits(TRUE);
if ($ef->isValid()) {
if ($enable_premature_exceptions == TRUE) {
$ef->emailException($user_date_obj->getUserObject(), $user_date_obj, $ep_obj);
}
$ef->Save();
}
}
}
} else {
Debug::text(' NOT Scheduled', __FILE__, __LINE__, __METHOD__, 10);
}
}
break;
case 's2':
//Not Scheduled
$schedule_total_time = 0;
if ($slf->getRecordCount() == 0) {
if ($plf->getRecordCount() > 0) {
Debug::text(' Worked when wasnt scheduled', __FILE__, __LINE__, __METHOD__, 10);
$ef = new ExceptionFactory();
$ef->setUserDateID($user_date_id);
$ef->setExceptionPolicyID($ep_obj->getId());
$ef->setType($type_id);
$ef->setEnableDemerits(TRUE);
if ($ef->isValid()) {
if ($enable_premature_exceptions == TRUE) {
$ef->emailException($user_date_obj->getUserObject(), $user_date_obj, $ep_obj);
}
$ef->Save();
}
}
} else {
Debug::text(' IS Scheduled', __FILE__, __LINE__, __METHOD__, 10);
}
break;
case 's3':
//In Early
if ($plf->getRecordCount() > 0) {
//Loop through each punch, find out if they are scheduled, and if they are in early
foreach ($plf as $p_obj) {
if ($p_obj->getType() == 10 and $p_obj->getStatus() == 10) {
//Normal In
if (!isset($scheduled_id_cache[$p_obj->getID()])) {
$scheduled_id_cache[$p_obj->getID()] = $p_obj->findScheduleID(NULL, $user_date_obj->getUser());
}
if ($p_obj->setScheduleID($scheduled_id_cache[$p_obj->getID()]) == TRUE) {
if ($p_obj->getTimeStamp() < $p_obj->getScheduleObject()->getStartTime()) {
if (TTDate::inWindow($p_obj->getTimeStamp(), $p_obj->getScheduleObject()->getStartTime(), $ep_obj->getGrace()) == TRUE) {
Debug::text(' Within Grace time, IGNORE EXCEPTION: ', __FILE__, __LINE__, __METHOD__, 10);
} elseif (TTDate::inWindow($p_obj->getTimeStamp(), $p_obj->getScheduleObject()->getStartTime(), $ep_obj->getWatchWindow()) == TRUE) {
Debug::text(' NOT Within Grace time, SET EXCEPTION: ', __FILE__, __LINE__, __METHOD__, 10);
$ef = new ExceptionFactory();
$ef->setUserDateID($user_date_id);
$ef->setExceptionPolicyID($ep_obj->getId());
$ef->setPunchID($p_obj->getID());
$ef->setType($type_id);
$ef->setEnableDemerits(TRUE);
if ($ef->isValid()) {
if ($enable_premature_exceptions == TRUE) {
$ef->emailException($user_date_obj->getUserObject(), $user_date_obj, $ep_obj);
}
$ef->Save();
}
}
}
} else {
Debug::text(' NO Schedule Found', __FILE__, __LINE__, __METHOD__, 10);
}
}
}
}
break;
case 's4':
//In Late
if ($plf->getRecordCount() > 0) {
foreach ($plf as $p_obj) {
if ($p_obj->getType() == 10 and $p_obj->getStatus() == 10) {
//Normal In
if (!isset($scheduled_id_cache[$p_obj->getID()])) {
$scheduled_id_cache[$p_obj->getID()] = $p_obj->findScheduleID(NULL, $user_date_obj->getUser());
}
if ($p_obj->setScheduleID($scheduled_id_cache[$p_obj->getID()]) == TRUE) {
if ($p_obj->getTimeStamp() > $p_obj->getScheduleObject()->getStartTime()) {
if (TTDate::inWindow($p_obj->getTimeStamp(), $p_obj->getScheduleObject()->getStartTime(), $ep_obj->getGrace()) == TRUE) {
Debug::text(' Within Grace time, IGNORE EXCEPTION: ', __FILE__, __LINE__, __METHOD__, 10);
} elseif (TTDate::inWindow($p_obj->getTimeStamp(), $p_obj->getScheduleObject()->getStartTime(), $ep_obj->getWatchWindow()) == TRUE) {
Debug::text(' NOT Within Grace time, SET EXCEPTION: ', __FILE__, __LINE__, __METHOD__, 10);
$ef = new ExceptionFactory();
$ef->setUserDateID($user_date_id);
$ef->setExceptionPolicyID($ep_obj->getId());
$ef->setPunchID($p_obj->getID());
$ef->setType($type_id);
$ef->setEnableDemerits(TRUE);
if ($ef->isValid()) {
if ($enable_premature_exceptions == TRUE) {
$ef->emailException($user_date_obj->getUserObject(), $user_date_obj, $ep_obj);
}
$ef->Save();
}
}
}
} else {
Debug::text(' NO Schedule Found', __FILE__, __LINE__, __METHOD__, 10);
}
}
}
}
break;
case 's5':
//Out Early
if ($plf->getRecordCount() > 0) {
//Loop through each punch, find out if they are scheduled, and if they are in early
foreach ($plf as $p_obj) {
if ($p_obj->getType() == 10 and $p_obj->getStatus() == 20) {
//Normal Out
if (!isset($scheduled_id_cache[$p_obj->getID()])) {
$scheduled_id_cache[$p_obj->getID()] = $p_obj->findScheduleID(NULL, $user_date_obj->getUser());
}
if ($p_obj->setScheduleID($scheduled_id_cache[$p_obj->getID()]) == TRUE) {
if ($p_obj->getTimeStamp() < $p_obj->getScheduleObject()->getEndTime()) {
if (TTDate::inWindow($p_obj->getTimeStamp(), $p_obj->getScheduleObject()->getEndTime(), $ep_obj->getGrace()) == TRUE) {
Debug::text(' Within Grace time, IGNORE EXCEPTION: ', __FILE__, __LINE__, __METHOD__, 10);
} elseif (TTDate::inWindow($p_obj->getTimeStamp(), $p_obj->getScheduleObject()->getEndTime(), $ep_obj->getWatchWindow()) == TRUE) {
Debug::text(' NOT Within Grace time, SET EXCEPTION: ', __FILE__, __LINE__, __METHOD__, 10);
$ef = new ExceptionFactory();
$ef->setUserDateID($user_date_id);
$ef->setExceptionPolicyID($ep_obj->getId());
$ef->setPunchID($p_obj->getID());
$ef->setType($type_id);
$ef->setEnableDemerits(TRUE);
if ($ef->isValid()) {
if ($enable_premature_exceptions == TRUE) {
$ef->emailException($user_date_obj->getUserObject(), $user_date_obj, $ep_obj);
}
$ef->Save();
}
}
}
} else {
Debug::text(' NO Schedule Found', __FILE__, __LINE__, __METHOD__, 10);
}
}
}
}
break;
case 's6':
//Out Late
if ($plf->getRecordCount() > 0) {
foreach ($plf as $p_obj) {
if ($p_obj->getType() == 10 and $p_obj->getStatus() == 20) {
//Normal Out
if (!isset($scheduled_id_cache[$p_obj->getID()])) {
$scheduled_id_cache[$p_obj->getID()] = $p_obj->findScheduleID(NULL, $user_date_obj->getUser());
}
if ($p_obj->setScheduleID($scheduled_id_cache[$p_obj->getID()]) == TRUE) {
if ($p_obj->getTimeStamp() > $p_obj->getScheduleObject()->getEndTime()) {
if (TTDate::inWindow($p_obj->getTimeStamp(), $p_obj->getScheduleObject()->getEndTime(), $ep_obj->getGrace()) == TRUE) {
Debug::text(' Within Grace time, IGNORE EXCEPTION: ', __FILE__, __LINE__, __METHOD__, 10);
} elseif (TTDate::inWindow($p_obj->getTimeStamp(), $p_obj->getScheduleObject()->getEndTime(), $ep_obj->getWatchWindow()) == TRUE) {
Debug::text(' NOT Within Grace time, SET EXCEPTION: ', __FILE__, __LINE__, __METHOD__, 10);
$ef = new ExceptionFactory();
$ef->setUserDateID($user_date_id);
$ef->setExceptionPolicyID($ep_obj->getId());
$ef->setPunchID($p_obj->getID());
$ef->setType($type_id);
$ef->setEnableDemerits(TRUE);
if ($ef->isValid()) {
if ($enable_premature_exceptions == TRUE) {
$ef->emailException($user_date_obj->getUserObject(), $user_date_obj, $ep_obj);
}
$ef->Save();
}
}
}
} else {
Debug::text(' NO Schedule Found', __FILE__, __LINE__, __METHOD__, 10);
}
}
}
}
break;
case 'm1':
//Missing In Punch
if ($plf->getRecordCount() > 0) {
foreach ($plf as $p_obj) {
//Debug::text(' Punch: Status: '. $p_obj->getStatus() .' Punch Control ID: '. $p_obj->getPunchControlID() .' Punch ID: '. $p_obj->getId() .' TimeStamp: '. $p_obj->getTimeStamp(), __FILE__, __LINE__, __METHOD__,10);
if ($type_id == 5 and $p_obj->getTimeStamp() < time() - self::$premature_delay) {
$type_id = 50;
}
$punch_pairs[$p_obj->getPunchControlID()][] = array('status_id' => $p_obj->getStatus(), 'punch_control_id' => $p_obj->getPunchControlID(), 'punch_id' => $p_obj->getId());
}
if (isset($punch_pairs)) {
foreach ($punch_pairs as $punch_control_id => $punch_pair) {
//Debug::Arr($punch_pair, 'Punch Pair for Control ID:'. $punch_control_id, __FILE__, __LINE__, __METHOD__,10);
if (count($punch_pair) != 2) {
Debug::text('aFound Missing Punch: ', __FILE__, __LINE__, __METHOD__, 10);
if ($punch_pair[0]['status_id'] == 20) {
//Missing In Punch
Debug::text('bFound Missing In Punch: ', __FILE__, __LINE__, __METHOD__, 10);
$ef = new ExceptionFactory();
$ef->setUserDateID($user_date_id);
$ef->setExceptionPolicyID($ep_obj->getId());
$ef->setPunchControlID($punch_pair[0]['punch_control_id']);
$ef->setType($type_id);
$ef->setEnableDemerits(TRUE);
if ($ef->isValid()) {
if ($enable_premature_exceptions == TRUE) {
$ef->emailException($user_date_obj->getUserObject(), $user_date_obj, $ep_obj);
}
$ef->Save();
}
}
} else {
Debug::text('No Missing Punches...', __FILE__, __LINE__, __METHOD__, 10);
}
}
}
unset($punch_pairs, $punch_pair);
}
break;
case 'm2':
//Missing Out Punch
if ($plf->getRecordCount() > 0) {
foreach ($plf as $p_obj) {
Debug::text(' Punch: Status: ' . $p_obj->getStatus() . ' Punch Control ID: ' . $p_obj->getPunchControlID() . ' Punch ID: ' . $p_obj->getId() . ' TimeStamp: ' . $p_obj->getTimeStamp(), __FILE__, __LINE__, __METHOD__, 10);
if ($type_id == 5 and $p_obj->getTimeStamp() < time() - self::$premature_delay) {
$type_id = 50;
}
$punch_pairs[$p_obj->getPunchControlID()][] = array('status_id' => $p_obj->getStatus(), 'punch_control_id' => $p_obj->getPunchControlID());
}
if (isset($punch_pairs)) {
foreach ($punch_pairs as $punch_control_id => $punch_pair) {
if (count($punch_pair) != 2) {
Debug::text('aFound Missing Punch: ', __FILE__, __LINE__, __METHOD__, 10);
if ($punch_pair[0]['status_id'] == 10) {
//Missing Out Punch
Debug::text('bFound Missing Out Punch: ', __FILE__, __LINE__, __METHOD__, 10);
$ef = new ExceptionFactory();
$ef->setUserDateID($user_date_id);
$ef->setExceptionPolicyID($ep_obj->getId());
$ef->setPunchControlID($punch_pair[0]['punch_control_id']);
$ef->setType($type_id);
$ef->setEnableDemerits(TRUE);
if ($ef->isValid()) {
if ($enable_premature_exceptions == TRUE) {
$ef->emailException($user_date_obj->getUserObject(), $user_date_obj, $ep_obj);
}
$ef->Save();
}
}
} else {
Debug::text('No Missing Punches...', __FILE__, __LINE__, __METHOD__, 10);
}
}
}
unset($punch_pairs, $punch_pair);
}
break;
case 'm3':
//Missing Lunch In/Out punch
if ($plf->getRecordCount() > 0) {
//We need to account for cases where they may punch IN from lunch first, then Out.
//As well as just a Lunch In punch and nothing else.
foreach ($plf as $p_obj) {
if ($type_id == 5 and $p_obj->getTimeStamp() < time() - self::$premature_delay) {
$type_id = 50;
}
$punches[] = $p_obj;
}
if (isset($punches) and is_array($punches)) {
foreach ($punches as $key => $p_obj) {
if ($p_obj->getType() == 20) {
//Lunch
Debug::text(' Punch: Status: ' . $p_obj->getStatus() . ' Punch Control ID: ' . $p_obj->getPunchControlID() . ' TimeStamp: ' . $p_obj->getTimeStamp(), __FILE__, __LINE__, __METHOD__, 10);
if ($p_obj->getStatus() == 10) {
//Make sure previous punch is Lunch/Out
if (!isset($punches[$key - 1]) or isset($punches[$key - 1]) and is_object($punches[$key - 1]) and ($punches[$key - 1]->getType() != 20 or $punches[$key - 1]->getStatus() != 20)) {
//Invalid punch
$invalid_punches[] = array('punch_id' => $p_obj->getId());
}
} else {
//Make sure next punch is Lunch/In
if (!isset($punches[$key + 1]) or isset($punches[$key + 1]) and is_object($punches[$key + 1]) and ($punches[$key + 1]->getType() != 20 or $punches[$key + 1]->getStatus() != 10)) {
//Invalid punch
$invalid_punches[] = array('punch_id' => $p_obj->getId());
}
}
}
}
unset($punches, $key, $p_obj);
if (isset($invalid_punches) and count($invalid_punches) > 0) {
foreach ($invalid_punches as $invalid_punch_arr) {
Debug::text('Found Missing Lunch In/Out Punch: ', __FILE__, __LINE__, __METHOD__, 10);
$ef = new ExceptionFactory();
$ef->setUserDateID($user_date_id);
$ef->setExceptionPolicyID($ep_obj->getId());
//$ef->setPunchControlID( $invalid_punch_arr['punch_id'] );
$ef->setPunchID($invalid_punch_arr['punch_id']);
$ef->setType($type_id);
$ef->setEnableDemerits(TRUE);
if ($ef->isValid()) {
if ($enable_premature_exceptions == TRUE) {
$ef->emailException($user_date_obj->getUserObject(), $user_date_obj, $ep_obj);
}
$ef->Save();
}
}
unset($invalid_punch_arr);
} else {
Debug::text('Lunch Punches match up.', __FILE__, __LINE__, __METHOD__, 10);
}
unset($invalid_punches);
}
}
break;
case 'm4':
//Missing Break In/Out punch
if ($plf->getRecordCount() > 0) {
//We need to account for cases where they may punch IN from break first, then Out.
//As well as just a break In punch and nothing else.
foreach ($plf as $p_obj) {
if ($type_id == 5 and $p_obj->getTimeStamp() < time() - self::$premature_delay) {
$type_id = 50;
}
$punches[] = $p_obj;
}
if (isset($punches) and is_array($punches)) {
foreach ($punches as $key => $p_obj) {
if ($p_obj->getType() == 30) {
//Break
Debug::text(' Punch: Status: ' . $p_obj->getStatus() . ' Type: ' . $p_obj->getType() . ' Punch Control ID: ' . $p_obj->getPunchControlID() . ' TimeStamp: ' . $p_obj->getTimeStamp(), __FILE__, __LINE__, __METHOD__, 10);
if ($p_obj->getStatus() == 10) {
//Make sure previous punch is Break/Out
if (!isset($punches[$key - 1]) or isset($punches[$key - 1]) and is_object($punches[$key - 1]) and ($punches[$key - 1]->getType() != 30 or $punches[$key - 1]->getStatus() != 20)) {
//Invalid punch
$invalid_punches[] = array('punch_id' => $p_obj->getId());
}
} else {
//Make sure next punch is Break/In
if (!isset($punches[$key + 1]) or isset($punches[$key + 1]) and is_object($punches[$key + 1]) and ($punches[$key + 1]->getType() != 30 or $punches[$key + 1]->getStatus() != 10)) {
//Invalid punch
$invalid_punches[] = array('punch_id' => $p_obj->getId());
}
}
}
}
unset($punches, $key, $p_obj);
if (isset($invalid_punches) and count($invalid_punches) > 0) {
foreach ($invalid_punches as $invalid_punch_arr) {
Debug::text('Found Missing Break In/Out Punch: ', __FILE__, __LINE__, __METHOD__, 10);
$ef = new ExceptionFactory();
$ef->setUserDateID($user_date_id);
$ef->setExceptionPolicyID($ep_obj->getId());
//$ef->setPunchControlID( $invalid_punch_arr['punch_id'] );
$ef->setPunchID($invalid_punch_arr['punch_id']);
$ef->setType($type_id);
$ef->setEnableDemerits(TRUE);
if ($ef->isValid()) {
if ($enable_premature_exceptions == TRUE) {
$ef->emailException($user_date_obj->getUserObject(), $user_date_obj, $ep_obj);
}
$ef->Save();
}
}
unset($invalid_punch_arr);
} else {
Debug::text('Lunch Punches match up.', __FILE__, __LINE__, __METHOD__, 10);
}
unset($invalid_punches);
}
}
break;
case 's7':
//Over Scheduled Hours
if ($plf->getRecordCount() > 0) {
//This ONLY takes in to account WORKED hours, not paid absence hours.
$schedule_total_time = 0;
if ($slf->getRecordCount() > 0) {
//Check for schedule policy
foreach ($slf as $s_obj) {
Debug::text(' Schedule Total Time: ' . $s_obj->getTotalTime(), __FILE__, __LINE__, __METHOD__, 10);
$schedule_total_time += $s_obj->getTotalTime();
}
$daily_total_time = 0;
if ($schedule_total_time > 0) {
//Get daily total time.
$udtlf = new UserDateTotalListFactory();
//Take into account auto-deduct/add meal policies
//$udtlf->getByUserDateIdAndStatus( $user_date_id, 20 );
$udtlf->getByUserDateIdAndStatusAndType($user_date_id, 10, 10);
if ($udtlf->getRecordCount() > 0) {
foreach ($udtlf as $udt_obj) {
$daily_total_time += $udt_obj->getTotalTime();
}
}
Debug::text(' Daily Total Time: ' . $daily_total_time . ' Schedule Total Time: ' . $schedule_total_time, __FILE__, __LINE__, __METHOD__, 10);
if ($daily_total_time > 0 and $daily_total_time > $schedule_total_time + $ep_obj->getGrace()) {
Debug::text(' Worked Over Scheduled Hours', __FILE__, __LINE__, __METHOD__, 10);
$ef = new ExceptionFactory();
$ef->setUserDateID($user_date_id);
$ef->setExceptionPolicyID($ep_obj->getId());
$ef->setType($type_id);
$ef->setEnableDemerits(TRUE);
if ($ef->isValid()) {
if ($enable_premature_exceptions == TRUE) {
$ef->emailException($user_date_obj->getUserObject(), $user_date_obj, $ep_obj);
}
$ef->Save();
}
} else {
Debug::text(' DID NOT Work Over Scheduled Hours', __FILE__, __LINE__, __METHOD__, 10);
}
}
} else {
Debug::text(' Not Scheduled', __FILE__, __LINE__, __METHOD__, 10);
}
}
break;
case 's8':
//Under Scheduled Hours
if ($plf->getRecordCount() > 0) {
//This ONLY takes in to account WORKED hours, not paid absence hours.
$schedule_total_time = 0;
if ($slf->getRecordCount() > 0) {
//Check for schedule policy
foreach ($slf as $s_obj) {
Debug::text(' Schedule Total Time: ' . $s_obj->getTotalTime(), __FILE__, __LINE__, __METHOD__, 10);
$schedule_total_time += $s_obj->getTotalTime();
}
$daily_total_time = 0;
if ($schedule_total_time > 0) {
//Get daily total time.
$udtlf = new UserDateTotalListFactory();
//Take into account auto-deduct/add meal policies
//$udtlf->getByUserDateIdAndStatus( $user_date_id, 20 );
$udtlf->getByUserDateIdAndStatusAndType($user_date_id, 10, 10);
if ($udtlf->getRecordCount() > 0) {
foreach ($udtlf as $udt_obj) {
$daily_total_time += $udt_obj->getTotalTime();
}
}
Debug::text(' Daily Total Time: ' . $daily_total_time . ' Schedule Total Time: ' . $schedule_total_time, __FILE__, __LINE__, __METHOD__, 10);
if ($daily_total_time < $schedule_total_time - $ep_obj->getGrace()) {
Debug::text(' Worked Under Scheduled Hours', __FILE__, __LINE__, __METHOD__, 10);
if ($type_id == 5 and $user_date_obj->getDateStamp() < TTDate::getBeginDayEpoch(time() - self::$premature_delay)) {
$type_id = 50;
}
$ef = new ExceptionFactory();
$ef->setUserDateID($user_date_id);
$ef->setExceptionPolicyID($ep_obj->getId());
$ef->setType($type_id);
$ef->setEnableDemerits(TRUE);
if ($ef->isValid()) {
if ($enable_premature_exceptions == TRUE) {
$ef->emailException($user_date_obj->getUserObject(), $user_date_obj, $ep_obj);
}
$ef->Save();
}
} else {
Debug::text(' DID NOT Work Under Scheduled Hours', __FILE__, __LINE__, __METHOD__, 10);
}
}
} else {
Debug::text(' Not Scheduled', __FILE__, __LINE__, __METHOD__, 10);
}
}
break;
case 'o1':
//Over Daily Time.
if ($plf->getRecordCount() > 0) {
//This ONLY takes in to account WORKED hours, not paid absence hours.
$daily_total_time = 0;
//Get daily total time.
$udtlf = new UserDateTotalListFactory();
//Take into account auto-deduct/add meal policies
$udtlf->getByUserDateIdAndStatusAndType($user_date_id, 10, 10);
if ($udtlf->getRecordCount() > 0) {
foreach ($udtlf as $udt_obj) {
$daily_total_time += $udt_obj->getTotalTime();
}
}
Debug::text(' Daily Total Time: ' . $daily_total_time . ' Watch Window: ' . $ep_obj->getWatchWindow() . ' User Date ID: ' . $user_date_id, __FILE__, __LINE__, __METHOD__, 10);
if ($daily_total_time > 0 and $daily_total_time > $ep_obj->getWatchWindow()) {
Debug::text(' Worked Over Daily Hours', __FILE__, __LINE__, __METHOD__, 10);
$ef = new ExceptionFactory();
$ef->setUserDateID($user_date_id);
$ef->setExceptionPolicyID($ep_obj->getId());
$ef->setType($type_id);
$ef->setEnableDemerits(TRUE);
if ($ef->isValid()) {
if ($enable_premature_exceptions == TRUE) {
$ef->emailException($user_date_obj->getUserObject(), $user_date_obj, $ep_obj);
}
$ef->Save();
}
} else {
Debug::text(' DID NOT Work Over Scheduled Hours', __FILE__, __LINE__, __METHOD__, 10);
}
}
break;
case 'o2':
//Over Weekly Time.
//Over Weekly Time.
case 's9':
//Over Weekly Scheduled Time.
if ($plf->getRecordCount() > 0) {
//Get Pay Period Schedule info
if (is_object($user_date_obj->getPayPeriodObject()) and is_object($user_date_obj->getPayPeriodObject()->getPayPeriodScheduleObject())) {
$start_week_day_id = $user_date_obj->getPayPeriodObject()->getPayPeriodScheduleObject()->getStartWeekDay();
} else {
$start_week_day_id = 0;
}
Debug::text('Start Week Day ID: ' . $start_week_day_id, __FILE__, __LINE__, __METHOD__, 10);
$weekly_scheduled_total_time = 0;
if (strtolower($ep_obj->getType()) == 's9') {
$tmp_slf = new ScheduleListFactory();
$tmp_slf->getByUserIdAndStartDateAndEndDate($user_date_obj->getUser(), TTDate::getBeginWeekEpoch($user_date_obj->getDateStamp(), $start_week_day_id), $user_date_obj->getDateStamp());
if ($tmp_slf->getRecordCount() > 0) {
foreach ($tmp_slf as $s_obj) {
$weekly_scheduled_total_time += $s_obj->getTotalTime();
}
}
unset($tmp_slf, $s_obj);
}
//This ONLY takes in to account WORKED hours, not paid absence hours.
$weekly_total_time = 0;
//Get daily total time.
$udtlf = new UserDateTotalListFactory();
$weekly_total_time = $udtlf->getWorkedTimeSumByUserIDAndStartDateAndEndDate($user_date_obj->getUser(), TTDate::getBeginWeekEpoch($user_date_obj->getDateStamp(), $start_week_day_id), $user_date_obj->getDateStamp());
Debug::text(' Weekly Total Time: ' . $weekly_total_time . ' Weekly Scheduled Total Time: ' . $weekly_scheduled_total_time . ' Watch Window: ' . $ep_obj->getWatchWindow() . ' Grace: ' . $ep_obj->getGrace() . ' User Date ID: ' . $user_date_id, __FILE__, __LINE__, __METHOD__, 10);
if (strtolower($ep_obj->getType()) == 'o2' and $weekly_total_time > 0 and $weekly_total_time > $ep_obj->getWatchWindow() or strtolower($ep_obj->getType()) == 's9' and $weekly_total_time > 0 and $weekly_total_time > $weekly_scheduled_total_time + $ep_obj->getGrace()) {
Debug::text(' Worked Over Weekly Hours', __FILE__, __LINE__, __METHOD__, 10);
$ef = new ExceptionFactory();
$ef->setUserDateID($user_date_id);
$ef->setExceptionPolicyID($ep_obj->getId());
$ef->setType($type_id);
$ef->setEnableDemerits(TRUE);
if ($ef->isValid()) {
if ($enable_premature_exceptions == TRUE) {
$ef->emailException($user_date_obj->getUserObject(), $user_date_obj, $ep_obj);
}
$ef->Save();
}
} else {
Debug::text(' DID NOT Work Over Scheduled Hours', __FILE__, __LINE__, __METHOD__, 10);
}
}
break;
case 'l1':
//Long Lunch
//Long Lunch
case 'l2':
//Short Lunch
if ($plf->getRecordCount() > 0) {
//Get all lunch punches.
$pair = 0;
$x = 0;
$out_for_lunch = FALSE;
foreach ($plf as $p_obj) {
if ($p_obj->getStatus() == 20 and $p_obj->getType() == 20) {
$lunch_out_timestamp = $p_obj->getTimeStamp();
$lunch_punch_arr[$pair]['punch_id'] = $p_obj->getId();
$out_for_lunch = TRUE;
} elseif ($out_for_lunch == TRUE and $p_obj->getStatus() == 10 and $p_obj->getType() == 20) {
$lunch_punch_arr[$pair][20] = $lunch_out_timestamp;
$lunch_punch_arr[$pair][10] = $p_obj->getTimeStamp();
$out_for_lunch = FALSE;
$pair++;
unset($lunch_out_timestamp);
} else {
$out_for_lunch = FALSE;
}
}
if (isset($lunch_punch_arr)) {
Debug::Arr($lunch_punch_arr, 'Lunch Punch Array: ', __FILE__, __LINE__, __METHOD__, 10);
foreach ($lunch_punch_arr as $pair => $time_stamp_arr) {
if (isset($time_stamp_arr[10]) and isset($time_stamp_arr[20])) {
$lunch_total_time = bcsub($time_stamp_arr[10], $time_stamp_arr[20]);
Debug::text(' Lunch Total Time: ' . $lunch_total_time, __FILE__, __LINE__, __METHOD__, 10);
if (!isset($scheduled_id_cache[$p_obj->getID()])) {
$scheduled_id_cache[$p_obj->getID()] = $p_obj->findScheduleID(NULL, $user_date_obj->getUser());
}
//Check to see if they have a schedule policy
if ($p_obj->setScheduleID($scheduled_id_cache[$p_obj->getID()]) == TRUE and is_object($p_obj->getScheduleObject()) == TRUE and is_object($p_obj->getScheduleObject()->getSchedulePolicyObject()) == TRUE) {
$mp_obj = $p_obj->getScheduleObject()->getSchedulePolicyObject()->getMealPolicyObject();
} else {
$mplf = new MealPolicyListFactory();
$mplf->getByPolicyGroupUserId($user_date_obj->getUserObject()->getId());
if ($mplf->getRecordCount() > 0) {
Debug::text('Found Meal Policy to apply.', __FILE__, __LINE__, __METHOD__, 10);
$mp_obj = $mplf->getCurrent();
}
}
if (isset($mp_obj) and is_object($mp_obj)) {
$meal_policy_lunch_time = $mp_obj->getAmount();
Debug::text('Meal Policy Time: ' . $meal_policy_lunch_time, __FILE__, __LINE__, __METHOD__, 10);
$add_exception = FALSE;
if (strtolower($ep_obj->getType()) == 'l1' and $meal_policy_lunch_time > 0 and $lunch_total_time > 0 and $lunch_total_time > $meal_policy_lunch_time + $ep_obj->getGrace()) {
$add_exception = TRUE;
} elseif (strtolower($ep_obj->getType()) == 'l2' and $meal_policy_lunch_time > 0 and $lunch_total_time > 0 and $lunch_total_time < $meal_policy_lunch_time - $ep_obj->getGrace()) {
$add_exception = TRUE;
}
if ($add_exception == TRUE) {
Debug::text('Adding Exception!', __FILE__, __LINE__, __METHOD__, 10);
$ef = new ExceptionFactory();
$ef->setUserDateID($user_date_id);
$ef->setExceptionPolicyID($ep_obj->getId());
if (isset($time_stamp_arr['punch_id'])) {
$ef->setPunchID($time_stamp_arr['punch_id']);
}
$ef->setType($type_id);
$ef->setEnableDemerits(TRUE);
if ($ef->isValid()) {
if ($enable_premature_exceptions == TRUE) {
$ef->emailException($user_date_obj->getUserObject(), $user_date_obj, $ep_obj);
}
$ef->Save();
}
} else {
Debug::text('Not Adding Exception!', __FILE__, __LINE__, __METHOD__, 10);
}
}
} else {
Debug::text(' Lunch Punches not paired... Skipping!', __FILE__, __LINE__, __METHOD__, 10);
}
}
} else {
Debug::text(' No Lunch Punches found, or none are paired.', __FILE__, __LINE__, __METHOD__, 10);
}
}
break;
case 'l3':
//No Lunch
if ($plf->getRecordCount() > 0) {
//If they are scheduled or not, we can check for a meal policy and base our
//decision off that. We don't want a No Lunch exception on a 3hr shift though.
//Also ignore this exception if the lunch is auto-deduct.
$daily_total_time = 0;
$udtlf = new UserDateTotalListFactory();
$udtlf->getByUserDateIdAndStatus($user_date_id, 20);
if ($udtlf->getRecordCount() > 0) {
foreach ($udtlf as $udt_obj) {
$daily_total_time += $udt_obj->getTotalTime();
}
}
Debug::text('Day Total Time: ' . $daily_total_time, __FILE__, __LINE__, __METHOD__, 10);
if ($daily_total_time > 0) {
//Check for lunch punch.
$lunch_punch = FALSE;
foreach ($plf as $p_obj) {
if ($p_obj->getType() == 20) {
Debug::text('Found Lunch Punch: ' . $p_obj->getTimeStamp(), __FILE__, __LINE__, __METHOD__, 10);
$lunch_punch = TRUE;
break;
}
}
if ($lunch_punch == FALSE) {
Debug::text('DID NOT Find Lunch Punch... Checking meal policies. ', __FILE__, __LINE__, __METHOD__, 10);
//Use scheduled meal policy first.
if ($slf->getRecordCount() > 0) {
Debug::text('Schedule Found...', __FILE__, __LINE__, __METHOD__, 10);
foreach ($slf as $s_obj) {
if ($s_obj->getSchedulePolicyObject() !== FALSE and $s_obj->getSchedulePolicyObject()->getMealPolicyObject() !== FALSE and $s_obj->getSchedulePolicyObject()->getMealPolicyObject()->getType() != 10) {
Debug::text('Found Schedule Meal Policy... Trigger Time: ' . $s_obj->getSchedulePolicyObject()->getMealPolicyObject()->getTriggerTime(), __FILE__, __LINE__, __METHOD__, 10);
if ($daily_total_time > $s_obj->getSchedulePolicyObject()->getMealPolicyObject()->getTriggerTime()) {
Debug::text('Daily Total Time is After Schedule Meal Policy Trigger Time: ', __FILE__, __LINE__, __METHOD__, 10);
$ef = new ExceptionFactory();
$ef->setUserDateID($user_date_id);
$ef->setExceptionPolicyID($ep_obj->getId());
$ef->setType($type_id);
$ef->setEnableDemerits(TRUE);
if ($ef->isValid()) {
if ($enable_premature_exceptions == TRUE) {
$ef->emailException($user_date_obj->getUserObject(), $user_date_obj, $ep_obj);
}
$ef->Save();
}
}
} else {
Debug::text('Schedule Meal Policy does not exist, or is auto-deduct?', __FILE__, __LINE__, __METHOD__, 10);
}
}
} else {
Debug::text('No Schedule Found...', __FILE__, __LINE__, __METHOD__, 10);
//Check if they have a meal policy, with no schedule.
$mplf = new MealPolicyListFactory();
$mplf->getByPolicyGroupUserId($user_date_obj->getUser());
if ($mplf->getRecordCount() > 0) {
Debug::text('Found UnScheduled Meal Policy...', __FILE__, __LINE__, __METHOD__, 10);
$m_obj = $mplf->getCurrent();
if ($daily_total_time > $m_obj->getTriggerTime() and $m_obj->getType() == 20) {
Debug::text('Daily Total Time is After Schedule Meal Policy Trigger Time: ' . $m_obj->getTriggerTime(), __FILE__, __LINE__, __METHOD__, 10);
$ef = new ExceptionFactory();
$ef->setUserDateID($user_date_id);
$ef->setExceptionPolicyID($ep_obj->getId());
$ef->setType($type_id);
$ef->setEnableDemerits(TRUE);
if ($ef->isValid()) {
if ($enable_premature_exceptions == TRUE) {
$ef->emailException($user_date_obj->getUserObject(), $user_date_obj, $ep_obj);
}
$ef->Save();
}
} else {
Debug::text('Auto-deduct meal policy, ignorning this exception.', __FILE__, __LINE__, __METHOD__, 10);
}
} else {
//There is no meal policy or schedule policy with a meal policy assigned to it
//With out this we could still apply No Lunch exceptions, but they will happen even on
//a 2minute shift.
Debug::text('No meal policy, applying No Lunch exception.', __FILE__, __LINE__, __METHOD__, 10);
$ef = new ExceptionFactory();
$ef->setUserDateID($user_date_id);
$ef->setExceptionPolicyID($ep_obj->getId());
$ef->setType($type_id);
$ef->setEnableDemerits(TRUE);
if ($ef->isValid()) {
if ($enable_premature_exceptions == TRUE) {
$ef->emailException($user_date_obj->getUserObject(), $user_date_obj, $ep_obj);
}
$ef->Save();
}
}
}
} else {
Debug::text('Found Lunch Punch... Ignoring this exception. ', __FILE__, __LINE__, __METHOD__, 10);
}
}
}
break;
case 'b1':
//Long Break
//Long Break
case 'b2':
//Short Break
if ($plf->getRecordCount() > 0) {
//Get all break punches.
$pair = 0;
$x = 0;
$out_for_break = FALSE;
foreach ($plf as $p_obj) {
if ($p_obj->getStatus() == 20 and $p_obj->getType() == 30) {
$break_out_timestamp = $p_obj->getTimeStamp();
$break_punch_arr[$pair]['punch_id'] = $p_obj->getId();
$out_for_break = TRUE;
} elseif ($out_for_break == TRUE and $p_obj->getStatus() == 10 and $p_obj->getType() == 30) {
$break_punch_arr[$pair][20] = $break_out_timestamp;
$break_punch_arr[$pair][10] = $p_obj->getTimeStamp();
$out_for_break = FALSE;
$pair++;
unset($break_out_timestamp);
} else {
$out_for_break = FALSE;
}
}
unset($pair);
if (isset($break_punch_arr)) {
Debug::Arr($break_punch_arr, 'Break Punch Array: ', __FILE__, __LINE__, __METHOD__, 10);
foreach ($break_punch_arr as $pair => $time_stamp_arr) {
if (isset($time_stamp_arr[10]) and isset($time_stamp_arr[20])) {
$break_total_time = bcsub($time_stamp_arr[10], $time_stamp_arr[20]);
Debug::text(' Break Total Time: ' . $break_total_time, __FILE__, __LINE__, __METHOD__, 10);
if (!isset($scheduled_id_cache[$p_obj->getID()])) {
$scheduled_id_cache[$p_obj->getID()] = $p_obj->findScheduleID(NULL, $user_date_obj->getUser());
}
//Check to see if they have a schedule policy
$bplf = new BreakPolicyListFactory();
if ($p_obj->setScheduleID($scheduled_id_cache[$p_obj->getID()]) == TRUE and is_object($p_obj->getScheduleObject()) == TRUE and is_object($p_obj->getScheduleObject()->getSchedulePolicyObject()) == TRUE) {
$break_policy_ids = $p_obj->getScheduleObject()->getSchedulePolicyObject()->getBreakPolicyObject();
$bplf->getByIdAndCompanyId($break_policy_ids, $user_date_obj->getUserObject()->getCompany());
} else {
$bplf->getByPolicyGroupUserId($user_date_obj->getUser());
}
unset($break_policy_ids);
if ($bplf->getRecordCount() > 0) {
Debug::text('Found Break Policy(ies) to apply: ' . $bplf->getRecordCount() . ' Pair: ' . $pair, __FILE__, __LINE__, __METHOD__, 10);
foreach ($bplf as $bp_obj) {
$bp_objs[] = $bp_obj;
}
unset($bplf, $bp_obj);
if (isset($bp_objs[$pair]) and is_object($bp_objs[$pair])) {
$bp_obj = $bp_objs[$pair];
$break_policy_break_time = $bp_obj->getAmount();
Debug::text('Break Policy Time: ' . $break_policy_break_time . ' ID: ' . $bp_obj->getID(), __FILE__, __LINE__, __METHOD__, 10);
$add_exception = FALSE;
if (strtolower($ep_obj->getType()) == 'b1' and $break_policy_break_time > 0 and $break_total_time > 0 and $break_total_time > $break_policy_break_time + $ep_obj->getGrace()) {
$add_exception = TRUE;
} elseif (strtolower($ep_obj->getType()) == 'b2' and $break_policy_break_time > 0 and $break_total_time > 0 and $break_total_time < $break_policy_break_time - $ep_obj->getGrace()) {
$add_exception = TRUE;
}
if ($add_exception == TRUE) {
Debug::text('Adding Exception! ' . $ep_obj->getType(), __FILE__, __LINE__, __METHOD__, 10);
$ef = new ExceptionFactory();
$ef->setUserDateID($user_date_id);
$ef->setExceptionPolicyID($ep_obj->getId());
if (isset($time_stamp_arr['punch_id'])) {
$ef->setPunchID($time_stamp_arr['punch_id']);
}
$ef->setType($type_id);
$ef->setEnableDemerits(TRUE);
if ($ef->isValid()) {
if ($enable_premature_exceptions == TRUE) {
$ef->emailException($user_date_obj->getUserObject(), $user_date_obj, $ep_obj);
}
$ef->Save();
}
} else {
Debug::text('Not Adding Exception!', __FILE__, __LINE__, __METHOD__, 10);
}
unset($bp_obj);
}
unset($bp_objs);
}
} else {
Debug::text(' Break Punches not paired... Skipping!', __FILE__, __LINE__, __METHOD__, 10);
}
}
} else {
Debug::text(' No Break Punches found, or none are paired.', __FILE__, __LINE__, __METHOD__, 10);
}
}
break;
case 'b3':
//Too Many Breaks
//Too Many Breaks
case 'b4':
//Too Few Breaks
if ($plf->getRecordCount() > 0) {
//Get all break punches.
$pair = 0;
$x = 0;
$out_for_break = FALSE;
foreach ($plf as $p_obj) {
if ($p_obj->getStatus() == 20 and $p_obj->getType() == 30) {
$break_out_timestamp = $p_obj->getTimeStamp();
$break_punch_arr[$pair]['punch_id'] = $p_obj->getId();
$out_for_break = TRUE;
} elseif ($out_for_break == TRUE and $p_obj->getStatus() == 10 and $p_obj->getType() == 30) {
$break_punch_arr[$pair][20] = $break_out_timestamp;
$break_punch_arr[$pair][10] = $p_obj->getTimeStamp();
$out_for_break = FALSE;
$pair++;
unset($break_out_timestamp);
} else {
$out_for_break = FALSE;
}
}
unset($pair);
if (isset($break_punch_arr)) {
$total_breaks = count($break_punch_arr);
Debug::Arr($break_punch_arr, 'Break Punch Array: ', __FILE__, __LINE__, __METHOD__, 10);
foreach ($break_punch_arr as $pair => $time_stamp_arr) {
if (isset($time_stamp_arr[10]) and isset($time_stamp_arr[20])) {
$break_total_time = bcsub($time_stamp_arr[10], $time_stamp_arr[20]);
Debug::text(' Break Total Time: ' . $break_total_time, __FILE__, __LINE__, __METHOD__, 10);
if (!isset($scheduled_id_cache[$p_obj->getID()])) {
$scheduled_id_cache[$p_obj->getID()] = $p_obj->findScheduleID(NULL, $user_date_obj->getUser());
}
//Check to see if they have a schedule policy
$bplf = new BreakPolicyListFactory();
if ($p_obj->setScheduleID($scheduled_id_cache[$p_obj->getID()]) == TRUE and is_object($p_obj->getScheduleObject()) == TRUE and is_object($p_obj->getScheduleObject()->getSchedulePolicyObject()) == TRUE) {
$break_policy_ids = $p_obj->getScheduleObject()->getSchedulePolicyObject()->getBreakPolicyObject();
$bplf->getByIdAndCompanyId($break_policy_ids, $user_date_obj->getUserObject()->getCompany());
} else {
$bplf->getByPolicyGroupUserId($user_date_obj->getUser());
}
unset($break_policy_ids);
$allowed_breaks = $bplf->getRecordCount();
$add_exception = FALSE;
if (strtolower($ep_obj->getType()) == 'b3' and $total_breaks > $allowed_breaks) {
Debug::text(' Too many breaks taken...', __FILE__, __LINE__, __METHOD__, 10);
$add_exception = TRUE;
} elseif (strtolower($ep_obj->getType()) == 'b4' and $total_breaks < $allowed_breaks) {
Debug::text(' Too few breaks taken...', __FILE__, __LINE__, __METHOD__, 10);
$add_exception = TRUE;
} else {
Debug::text(' Proper number of breaks taken...', __FILE__, __LINE__, __METHOD__, 10);
}
if ($add_exception == TRUE and (strtolower($ep_obj->getType()) == 'b4' or strtolower($ep_obj->getType()) == 'b3' and $pair > $allowed_breaks - 1)) {
Debug::text('Adding Exception! ' . $ep_obj->getType(), __FILE__, __LINE__, __METHOD__, 10);
$ef = new ExceptionFactory();
$ef->setUserDateID($user_date_id);
$ef->setExceptionPolicyID($ep_obj->getId());
if (isset($time_stamp_arr['punch_id']) and strtolower($ep_obj->getType()) == 'b3') {
$ef->setPunchID($time_stamp_arr['punch_id']);
}
$ef->setType($type_id);
$ef->setEnableDemerits(TRUE);
if ($ef->isValid()) {
if ($enable_premature_exceptions == TRUE) {
$ef->emailException($user_date_obj->getUserObject(), $user_date_obj, $ep_obj);
}
$ef->Save();
}
} else {
Debug::text('Not Adding Exception!', __FILE__, __LINE__, __METHOD__, 10);
}
}
}
}
}
break;
case 'j1':
//Not Allowed on Job
if ($plf->getRecordCount() > 0) {
foreach ($plf as $p_obj) {
if ($p_obj->getStatus() == 10) {
//In punches
if (is_object($p_obj->getPunchControlObject()) and $p_obj->getPunchControlObject()->getJob() > 0) {
//Found job punch, check job settings.
$jlf = new JobListFactory();
$jlf->getById($p_obj->getPunchControlObject()->getJob());
if ($jlf->getRecordCount() > 0) {
$j_obj = $jlf->getCurrent();
if ($j_obj->isAllowedUser($user_date_obj->getUser()) == FALSE) {
$ef = new ExceptionFactory();
$ef->setUserDateID($user_date_id);
$ef->setExceptionPolicyID($ep_obj->getId());
$ef->setType($type_id);
$ef->setPunchControlId($p_obj->getPunchControlId());
$ef->setEnableDemerits(TRUE);
if ($ef->isValid()) {
if ($enable_premature_exceptions == TRUE) {
$ef->emailException($user_date_obj->getUserObject(), $user_date_obj, $ep_obj);
}
$ef->Save();
}
} else {
Debug::text(' User allowed on Job!', __FILE__, __LINE__, __METHOD__, 10);
}
} else {
Debug::text(' Job not found!', __FILE__, __LINE__, __METHOD__, 10);
}
} else {
Debug::text(' Not a Job Punch...', __FILE__, __LINE__, __METHOD__, 10);
}
}
}
unset($j_obj);
}
break;
case 'j2':
//Not Allowed on Task
if ($plf->getRecordCount() > 0) {
foreach ($plf as $p_obj) {
if ($p_obj->getStatus() == 10) {
//In punches
if (is_object($p_obj->getPunchControlObject()) and $p_obj->getPunchControlObject()->getJob() > 0 and $p_obj->getPunchControlObject()->getJobItem() > 0) {
//Found job punch, check job settings.
$jlf = new JobListFactory();
$jlf->getById($p_obj->getPunchControlObject()->getJob());
if ($jlf->getRecordCount() > 0) {
$j_obj = $jlf->getCurrent();
if ($j_obj->isAllowedItem($p_obj->getPunchControlObject()->getJobItem()) == FALSE) {
$ef = new ExceptionFactory();
$ef->setUserDateID($user_date_id);
$ef->setExceptionPolicyID($ep_obj->getId());
$ef->setType($type_id);
$ef->setPunchControlId($p_obj->getPunchControlId());
$ef->setEnableDemerits(TRUE);
if ($ef->isValid()) {
if ($enable_premature_exceptions == TRUE) {
$ef->emailException($user_date_obj->getUserObject(), $user_date_obj, $ep_obj);
}
$ef->Save();
}
} else {
Debug::text(' Job item allowed on job!', __FILE__, __LINE__, __METHOD__, 10);
}
} else {
Debug::text(' Job not found!', __FILE__, __LINE__, __METHOD__, 10);
}
} else {
Debug::text(' Not a Job Punch...', __FILE__, __LINE__, __METHOD__, 10);
}
}
}
unset($j_obj);
}
break;
case 'j3':
//Job already completed
if ($plf->getRecordCount() > 0) {
foreach ($plf as $p_obj) {
if ($p_obj->getStatus() == 10) {
//In punches
if (is_object($p_obj->getPunchControlObject()) and $p_obj->getPunchControlObject()->getJob() > 0) {
//Found job punch, check job settings.
$jlf = new JobListFactory();
$jlf->getById($p_obj->getPunchControlObject()->getJob());
if ($jlf->getRecordCount() > 0) {
$j_obj = $jlf->getCurrent();
//Status is completed and the User Date Stamp is greater then the job end date.
//If no end date is set, ignore this.
if ($j_obj->getStatus() == 30 and $j_obj->getEndDate() != FALSE and $user_date_obj->getDateStamp() > $j_obj->getEndDate()) {
$ef = new ExceptionFactory();
$ef->setUserDateID($user_date_id);
$ef->setExceptionPolicyID($ep_obj->getId());
$ef->setType($type_id);
$ef->setPunchControlId($p_obj->getPunchControlId());
$ef->setEnableDemerits(TRUE);
if ($ef->isValid()) {
if ($enable_premature_exceptions == TRUE) {
$ef->emailException($user_date_obj->getUserObject(), $user_date_obj, $ep_obj);
}
$ef->Save();
}
} else {
Debug::text(' Job Not Completed!', __FILE__, __LINE__, __METHOD__, 10);
}
} else {
Debug::text(' Job not found!', __FILE__, __LINE__, __METHOD__, 10);
}
} else {
Debug::text(' Not a Job Punch...', __FILE__, __LINE__, __METHOD__, 10);
}
}
}
unset($j_obj);
}
break;
case 'j4':
//No Job or Task
if ($plf->getRecordCount() > 0) {
foreach ($plf as $p_obj) {
//In punches only
if ($p_obj->getStatus() == 10 and is_object($p_obj->getPunchControlObject()) and ($p_obj->getPunchControlObject()->getJob() == '' or $p_obj->getPunchControlObject()->getJob() == 0 or $p_obj->getPunchControlObject()->getJob() == FALSE or $p_obj->getPunchControlObject()->getJobItem() == '' or $p_obj->getPunchControlObject()->getJobItem() == 0 or $p_obj->getPunchControlObject()->getJobItem() == FALSE)) {
$ef = new ExceptionFactory();
$ef->setUserDateID($user_date_id);
$ef->setExceptionPolicyID($ep_obj->getId());
$ef->setType($type_id);
$ef->setPunchControlId($p_obj->getPunchControlId());
$ef->setPunchId($p_obj->getId());
$ef->setEnableDemerits(TRUE);
if ($ef->isValid()) {
if ($enable_premature_exceptions == TRUE) {
$ef->emailException($user_date_obj->getUserObject(), $user_date_obj, $ep_obj);
}
$ef->Save();
}
}
}
}
break;
default:
Debug::text('BAD, should never get here: ', __FILE__, __LINE__, __METHOD__, 10);
break;
}
}
}
$profiler->stopTimer("ExceptionPolicy::calcExceptions()");
return TRUE;
}
function getMidDayExceptionsByStartDateAndEndDateAndPayPeriodStatus($start_date, $end_date, $pay_period_status_id)
{
if ($start_date == '') {
return FALSE;
}
if ($end_date == '') {
return FALSE;
}
if ($pay_period_status_id == '') {
return FALSE;
}
$epf = new ExceptionPolicyFactory();
$ef = new ExceptionFactory();
$epcf = new ExceptionPolicyControlFactory();
$pgf = new PolicyGroupFactory();
$pguf = new PolicyGroupUserFactory();
$uf = new UserFactory();
$cf = new CompanyFactory();
$udf = new UserDateFactory();
$sf = new ScheduleFactory();
$pcf = new PunchControlFactory();
$pf = new PunchFactory();
$ppf = new PayPeriodFactory();
$current_epoch = time();
if (strncmp($this->db->databaseType, 'mysql', 5) == 0) {
$to_timestamp_sql = 'FROM_UNIXTIME';
} else {
$to_timestamp_sql = 'to_timestamp';
}
$ph = array('current_time1' => $this->db->BindTimeStamp($current_epoch), 'current_time2' => $this->db->BindTimeStamp($current_epoch), 'current_epoch1' => $current_epoch, 'start_date' => $this->db->BindDate($start_date), 'end_date' => $this->db->BindDate($end_date));
//Exceptions that need to be calculated in the middle of the day:
//Definitely: In Late, Out Late, Missed CheckIn
//Possible: Over Daily Scheduled Time, Over Weekly Scheduled Time, Over Daily Time, Over Weekly Time, Long Lunch (can't run this fast enough), Long Break (can't run this fast enough),
//Optimize calcQuickExceptions:
// Loop through exception policies where In Late/Out Late/Missed CheckIn are enabled.
// Loop through ACTIVE users assigned to these exceptions policies.
// Only find days that are scheduled AND ( NO punch after schedule start time OR NO punch after schedule end time )
// For Missed CheckIn they do not need to be scheduled.
// Exclude days that already have the exceptions triggered on them (?) (What about split shifts?)
// - Just exclude exceptions not assigned to punch/punch_control_id, if there is more than one in the day I don't think it helps much anyways.
//
//Currently Over Weekly/Daily time exceptions are only triggered on a Out punch.
$query = ' select distinct udf.*
FROM ' . $epf->getTable() . ' as epf
LEFT JOIN ' . $epcf->getTable() . ' as epcf ON ( epf.exception_policy_control_id = epcf.id )
LEFT JOIN ' . $pgf->getTable() . ' as pgf ON ( epcf.id = pgf.exception_policy_control_id )
LEFT JOIN ' . $pguf->getTable() . ' as pguf ON ( pgf.id = pguf.policy_group_id )
LEFT JOIN ' . $uf->getTable() . ' as uf ON ( pguf.user_id = uf.id )
LEFT JOIN ' . $cf->getTable() . ' as cf ON ( uf.company_id = cf.id )
LEFT JOIN ' . $udf->getTable() . ' as udf ON ( uf.id = udf.user_id )
LEFT JOIN ' . $ppf->getTable() . ' as ppf ON ( ppf.id = udf.pay_period_id )
LEFT JOIN ' . $ef->getTable() . ' as ef ON ( udf.id = ef.user_date_id AND ef.exception_policy_id = epf.id AND ef.type_id != 5 )
LEFT JOIN ' . $sf->getTable() . ' as sf ON ( udf.id = sf.user_date_id AND ( sf.start_time <= ? OR sf.end_time <= ? ) )
LEFT JOIN ' . $pcf->getTable() . ' as pcf ON ( udf.id = pcf.user_date_id AND pcf.deleted = 0 )
LEFT JOIN ' . $pf->getTable() . ' as pf ON (
pcf.id = pf.punch_control_id AND pf.deleted = 0
AND (
( epf.type_id = \'S4\' AND ( pf.time_stamp >= sf.start_time OR pf.time_stamp <= sf.end_time ) )
OR
( epf.type_id = \'S6\' AND ( pf.time_stamp >= sf.end_time ) )
OR
( epf.type_id = \'C1\' AND ( pf.status_id = 10 AND pf.time_stamp <= ' . $to_timestamp_sql . '(?-epf.grace) ) )
)
)
WHERE ( epf.type_id in (\'S4\',\'S6\', \'C1\') AND epf.active = 1 )
AND ( uf.status_id = 10 AND cf.status_id != 30 )
AND ( udf.date_stamp >= ? AND udf.date_stamp <= ? )
AND ppf.status_id in (' . $this->getListSQL($pay_period_status_id, $ph) . ')
AND ( ( ( epf.type_id in (\'S4\',\'S6\') AND ( sf.id IS NOT NULL AND sf.deleted = 0 ) AND pf.id IS NULL ) OR epf.type_id = \'C1\' ) AND ef.id IS NULL )
AND ( epf.deleted = 0 AND epcf.deleted = 0 AND pgf.deleted = 0 AND uf.deleted = 0 AND cf.deleted = 0 AND udf.deleted = 0 )
';
//Don't check deleted = 0 on PCF/PF tables, as we need to check IS NULL on them instead.
//Debug::Arr($ph, 'Query: '. $query, __FILE__, __LINE__, __METHOD__, 10);
$this->ExecuteSQL($query, $ph);
return $this;
}
