$rf->setMessage($data['message']);
} else {
Debug::Text('Object is NOT new!', __FILE__, __LINE__, __METHOD__, 10);
}
if ($rf->isValid()) {
$request_id = $rf->Save();
$rf->CommitTransaction();
//$rf->FailTransaction();
//Redirect::Page( URLBuilder::getURL( array('refresh' => FALSE ), '../CloseWindow.php') );
Redirect::Page(URLBuilder::getURL(array('refresh' => TRUE), '../CloseWindow.php'));
}
$rf->FailTransaction();
default:
if ((int) $id > 0) {
Debug::Text(' ID was passed: ' . $id, __FILE__, __LINE__, __METHOD__, 10);
$rlf = new RequestListFactory();
$rlf->getByIDAndCompanyID($id, $current_company->getId());
foreach ($rlf as $r_obj) {
//Debug::Arr($station,'Department', __FILE__, __LINE__, __METHOD__,10);
$data = array('id' => $r_obj->getId(), 'user_date_id' => $r_obj->getId(), 'user_id' => $r_obj->getUserDateObject()->getUser(), 'user_full_name' => $r_obj->getUserDateObject()->getUserObject()->getFullName(), 'date_stamp' => $r_obj->getUserDateObject()->getDateStamp(), 'type_id' => $r_obj->getType(), 'status_id' => $r_obj->getStatus(), 'created_date' => $r_obj->getCreatedDate(), 'created_by' => $r_obj->getCreatedBy(), 'updated_date' => $r_obj->getUpdatedDate(), 'updated_by' => $r_obj->getUpdatedBy(), 'deleted_date' => $r_obj->getDeletedDate(), 'deleted_by' => $r_obj->getDeletedBy());
}
} elseif ($action != 'submit') {
Debug::Text(' ID was NOT passed: ' . $id, __FILE__, __LINE__, __METHOD__, 10);
//UserID has to be set at minimum
$data = array('user_id' => $current_user->getId(), 'user_full_name' => $current_user->getFullName(), 'date_stamp' => TTDate::getTime());
} else {
$data['user_full_name'] = $current_user->getFullName();
}
//Select box options;
$data['status_options'] = $rf->getOptions('status');
$data['type_options'] = $rf->getOptions('type');
Debug::Arr($request_levels, 'Request Levels', __FILE__, __LINE__, __METHOD__, 10);
if (isset($selected_levels['request']) and isset($request_levels[$selected_levels['request']])) {
$request_selected_level = $request_levels[$selected_levels['request']];
Debug::Text(' Switching Levels to Level: ' . $request_selected_level, __FILE__, __LINE__, __METHOD__, 10);
} elseif (isset($request_levels[1])) {
$request_selected_level = $request_levels[1];
} else {
Debug::Text('No Request Levels... Not in hierarchy?', __FILE__, __LINE__, __METHOD__, 10);
$request_selected_level = 0;
}
Debug::Text('Request Selected Level: ' . $request_selected_level, __FILE__, __LINE__, __METHOD__, 10);
//Get all relevant hierarchy ids
$request_hierarchy_user_ids = $hlf->getByUserIdAndObjectTypeIDAndLevel($current_user->getId(), 50, (int) $request_selected_level);
if (is_array($request_hierarchy_user_ids) and isset($request_hierarchy_user_ids['child_level']) and isset($request_hierarchy_user_ids['parent_level']) and isset($request_hierarchy_user_ids['current_level'])) {
Debug::Text('Hierarchy information found...', __FILE__, __LINE__, __METHOD__, 10);
$rlf = new RequestListFactory();
$rlf->getByUserIdListAndStatusAndLevelAndMaxLevelAndNotAuthorized($request_hierarchy_user_ids['child_level'], 30, (int) $request_selected_level, (int) end($request_levels), NULL, NULL, NULL, $sort_array);
$status_options = $rlf->getOptions('status');
$type_options = $rlf->getOptions('type');
foreach ($rlf as $r_obj) {
//Grab authorizations for this object.
$requests[] = array('id' => $r_obj->getId(), 'user_date_id' => $r_obj->getId(), 'user_id' => $r_obj->getUserDateObject()->getUser(), 'user_full_name' => $r_obj->getUserDateObject()->getUserObject()->getFullName(), 'date_stamp' => $r_obj->getUserDateObject()->getDateStamp(), 'type_id' => $r_obj->getType(), 'type' => $type_options[$r_obj->getType()], 'status_id' => $r_obj->getStatus(), 'status' => $status_options[$r_obj->getStatus()]);
}
$smarty->assign_by_ref('requests', $requests);
if (isset($request_levels) and is_array($request_levels)) {
$smarty->assign_by_ref('request_levels', $request_levels);
$smarty->assign_by_ref('selected_request_level', $request_selected_level);
}
} else {
Debug::Text('No hierarchy information found...', __FILE__, __LINE__, __METHOD__, 10);
}
} else {
$end_date = $filter_data['end_date'];
}
$uwlf = new UserWageListFactory();
$uwlf->getLastWageByUserIdAndDate($filter_data['user_id'], $end_date);
if ($uwlf->getRecordCount() > 0) {
foreach ($uwlf as $uw_obj) {
$user_wage[$uw_obj->getUser()] = $uw_obj->getBaseCurrencyHourlyRate($uw_obj->getHourlyRate());
}
}
unset($end_date);
//var_dump($user_wage);
$pending_requests = array();
if (isset($filter_data['pay_period_ids']) and count($filter_data['pay_period_ids']) > 0) {
//Get all pending requests
$rlf = new RequestListFactory();
$rlf->getSumByPayPeriodIdAndStatus($filter_data['pay_period_ids'], 30);
if ($rlf->getRecordCount() > 0) {
$r_obj = $rlf->getCurrent();
$pending_requests[$r_obj->getColumn('pay_period_id')] = $r_obj->getColumn('total');
}
}
$slf = new ScheduleListFactory();
//$slf->getReportByPayPeriodIdAndUserId($filter_data['pay_period_ids'], $filter_data['user_ids']);
$slf->getReportByCompanyIdAndArrayCriteria($current_company->getId(), $filter_data);
if ($slf->getRecordCount() > 0) {
foreach ($slf as $s_obj) {
$user_id = $s_obj->getColumn('user_id');
$pay_period_id = $s_obj->getColumn('pay_period_id');
$status_id = $s_obj->getColumn('status_id');
$status = strtolower(Option::getByKey($status_id, $s_obj->getOptions('status')));
if ($e_obj->getColumn('severity_id') == 10) {
$exceptions['low'] = $e_obj->getColumn('count');
}
if ($e_obj->getColumn('severity_id') == 20) {
$exceptions['med'] = $e_obj->getColumn('count');
}
if ($e_obj->getColumn('severity_id') == 30) {
$exceptions['high'] = $e_obj->getColumn('count');
}
}
} else {
Debug::Text(' No Exceptions!', __FILE__, __LINE__, __METHOD__, 10);
}
//Get all pending requests
$pending_requests = 0;
$rlf = new RequestListFactory();
$rlf->getSumByPayPeriodIdAndStatus($pay_period_obj->getId(), 30);
if ($rlf->getRecordCount() > 0) {
$pending_requests = $rlf->getCurrent()->getColumn('total');
}
$pay_period_data['pending_requests'] = $pending_requests;
//Count how many punches are in this pay period.
$plf = new PunchListFactory();
$pay_period_data['total_punches'] = $plf->getByPayPeriodId($pay_period_id)->getRecordCount();
Debug::Text(' Total Punches: ' . $pay_period_data['total_punches'], __FILE__, __LINE__, __METHOD__, 10);
}
//var_dump($pay_period_data);
$smarty->assign_by_ref('exceptions', $exceptions);
$smarty->assign_by_ref('pay_period_data', $pay_period_data);
$smarty->assign_by_ref('current_epoch', TTDate::getTime());
break;
$ulf = new UserListFactory();
$hlf = new HierarchyListFactory();
$hllf = new HierarchyLevelListFactory();
$request_levels = $hllf->getLevelsByUserIdAndObjectTypeID($current_user->getId(), 50);
Debug::Arr($request_levels, 'Request Levels', __FILE__, __LINE__, __METHOD__, 10);
if (isset($selected_levels['request']) and isset($request_levels[$selected_levels['request']])) {
$request_selected_level = $request_levels[$selected_levels['request']];
Debug::Text(' Switching Levels to Level: ' . $request_selected_level, __FILE__, __LINE__, __METHOD__, 10);
} else {
$request_selected_level = 1;
}
Debug::Text('Request Selected Level: ' . $request_selected_level, __FILE__, __LINE__, __METHOD__, 10);
//Get all relevant hierarchy ids
$request_hierarchy_user_ids = $hlf->getByUserIdAndObjectTypeIDAndLevel($current_user->getId(), 50, (int) $request_selected_level);
if (is_array($request_hierarchy_user_ids) and isset($request_hierarchy_user_ids['child_level']) and isset($request_hierarchy_user_ids['parent_level']) and isset($request_hierarchy_user_ids['current_level'])) {
$rlf = new RequestListFactory();
$rlf->getByUserIdListAndStatusAndLevelAndMaxLevelAndNotAuthorized($request_hierarchy_user_ids['child_level'], 30, (int) $request_selected_level, (int) end($request_levels));
//Get all IDs that need authorizing.
//Only do 25 at a time, then grab more.
$i = 0;
$start = FALSE;
foreach ($rlf as $r_obj) {
if ($id == $r_obj->getId()) {
$start = TRUE;
}
if ($start == TRUE) {
$request_queue_ids[] = $r_obj->getId();
}
if ($i > 25) {
break;
}
}
}
Redirect::Page(URLBuilder::getURL(array('filter_user_id' => $filter_user_id), 'UserRequestList.php'));
break;
default:
if (!isset($filter_user_id)) {
$filter_user_id = $user_id = $current_user->getId();
}
if (isset($filter_user_id)) {
$filter_data['user_id'] = $filter_user_id;
}
if (isset($filter_start_date) and $filter_start_date != '' and isset($filter_end_date) and $filter_end_date != '') {
$filter_data['start_date'] = $filter_start_date;
$filter_data['end_date'] = $filter_end_date;
}
$rlf = new RequestListFactory();
$rlf->getByCompanyIdAndArrayCriteria($current_company->getId(), $filter_data, $current_user_prefs->getItemsPerPage(), $page, NULL, $sort_array);
/*
if ( isset($filter_start_date) AND $filter_start_date != '' AND isset($filter_end_date) AND $filter_end_date != '') {
$rlf->getByUserIdAndCompanyIdAndStartDateAndEndDate( $user_id, $current_company->getId(), $filter_start_date, $filter_end_date, $current_user_prefs->getItemsPerPage(), $page, NULL, $sort_array );
} else {
$rlf->getByUserIDAndCompanyId( $user_id, $current_company->getId(), $current_user_prefs->getItemsPerPage(), $page, NULL, $sort_array );
}
*/
$pager = new Pager($rlf);
$status_options = $rlf->getOptions('status');
$type_options = $rlf->getOptions('type');
foreach ($rlf as $r_obj) {
Debug::Text('Status ID: ' . $r_obj->getStatus() . ' Status: ' . $status_options[$r_obj->getStatus()], __FILE__, __LINE__, __METHOD__, 10);
$requests[] = array('id' => $r_obj->getId(), 'user_date_id' => $r_obj->getUserDateID(), 'date_stamp' => TTDate::strtotime($r_obj->getColumn('date_stamp')), 'status_id' => $r_obj->getStatus(), 'status' => $status_options[$r_obj->getStatus()], 'type_id' => $r_obj->getType(), 'type' => $type_options[$r_obj->getType()], 'created_date' => $r_obj->getCreatedDate(), 'deleted' => $r_obj->getDeleted());
}
$date_exception_total_rows[] = $exception_data;
}
}
//Get exception names for legend.
if (isset($unique_exceptions)) {
$epf = new ExceptionPolicyFactory();
$exception_options = $epf->getOptions('type');
foreach ($unique_exceptions as $unique_exception) {
$unique_exceptions[$unique_exception['exception_policy_type_id']]['name'] = $exception_options[$unique_exception['exception_policy_type_id']];
}
sort($unique_exceptions);
}
/*
Get Pending Requests
*/
$rlf = new RequestListFactory();
$rlf->getByCompanyIDAndUserIdAndStatusAndStartDateAndEndDate($current_company->getID(), $user_id, 30, $start_date, $end_date);
if ($rlf->getRecordCount() > 0) {
Debug::text('Found Requests!!: ', __FILE__, __LINE__, __METHOD__, 10);
foreach ($rlf as $r_obj) {
$user_date_stamp = TTDate::strtotime($r_obj->getColumn('date_stamp'));
$request_data_arr = array('id' => $r_obj->getId());
$date_requests[$user_date_stamp][] = $request_data_arr;
}
}
if (isset($date_requests)) {
foreach ($calendar_array as $cal_arr) {
if (isset($date_requests[$cal_arr['epoch']])) {
$request_data = $date_requests[$cal_arr['epoch']];
} else {
$request_data = NULL;
if ($message->getRequireAck() == TRUE) {
$show_ack_column = TRUE;
}
$messages[] = array('id' => $message->getId(), 'parent_id' => $message->getParent(), 'object_type_id' => $message->getObjectType(), 'object_type' => $object_name_options[$message->getObjectType()], 'object_id' => $message->getObject(), 'priority' => $message->getPriority(), 'status_id' => $message->getStatus(), 'require_ack' => $message->getRequireAck(), 'ack_date' => $message->getAckDate(), 'subject' => Misc::TruncateString($message->getSubject(), 20), 'body' => $message->getBody(), 'created_date' => $message->getCreatedDate(), 'created_by' => $message->getCreatedBy(), 'created_by_full_name' => $ulf->getById($message->getCreatedBy())->getIterator()->current()->getFullName(), 'updated_date' => $message->getUpdatedDate(), 'updated_by' => $message->getUpdatedBy(), 'deleted_date' => $message->getDeletedDate(), 'deleted_by' => $message->getDeletedBy());
}
}
$smarty->assign_by_ref('messages', $messages);
//Grab requests pending authorization if they are a supervisor.
if ($permission->Check('authorization', 'enabled') and $permission->Check('authorization', 'view') and $permission->Check('request', 'authorize')) {
$ulf = new UserListFactory();
$hlf = new HierarchyListFactory();
$hllf = new HierarchyLevelListFactory();
$request_levels = $hllf->getLevelsByUserIdAndObjectTypeID($current_user->getId(), 50);
//Debug::Arr( $request_levels, 'Request Levels', __FILE__, __LINE__, __METHOD__,10);
$request_hierarchy_user_ids = $hlf->getByUserIdAndObjectTypeIDAndLevel($current_user->getId(), 50, 1);
//Debug::Arr( $request_hierarchy_user_ids, 'Request Hierarchy Ids', __FILE__, __LINE__, __METHOD__,10);
if (is_array($request_hierarchy_user_ids) and isset($request_hierarchy_user_ids['child_level']) and isset($request_hierarchy_user_ids['parent_level']) and isset($request_hierarchy_user_ids['current_level'])) {
$rlf = new RequestListFactory();
//$rlf->getByUserIdListAndStatusAndNotAuthorized($request_hierarchy_user_ids['child_level'], 30, $request_hierarchy_user_ids['parent_level'], $request_hierarchy_user_ids['current_level'] );
$rlf->getByUserIdListAndStatusAndLevelAndMaxLevelAndNotAuthorized($request_hierarchy_user_ids['child_level'], 30, 1, (int) end($request_levels));
$status_options = $rlf->getOptions('status');
$type_options = $rlf->getOptions('type');
foreach ($rlf as $r_obj) {
//Grab authorizations for this object.
$pending_requests[] = array('id' => $r_obj->getId(), 'user_date_id' => $r_obj->getId(), 'user_id' => $r_obj->getUserDateObject()->getUser(), 'user_full_name' => $r_obj->getUserDateObject()->getUserObject()->getFullName(), 'date_stamp' => $r_obj->getUserDateObject()->getDateStamp(), 'type_id' => $r_obj->getType(), 'type' => $type_options[$r_obj->getType()], 'status_id' => $r_obj->getStatus(), 'status' => $status_options[$r_obj->getStatus()]);
}
}
$smarty->assign_by_ref('pending_requests', $pending_requests);
unset($pending_requests, $request_hierarchy_id, $request_user_id, $request_node_data, $request_current_level_user_ids, $request_parent_level_user_ids, $request_child_level_user_ids);
}
$smarty->display('index.tpl');
