$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');