| ' ); $form['search']['el_no'] = array( '#type' => 'textfield', '#title' => t('EL No.'), '#default_value' => 'EL', '#size' => 15, '#attributes' => array('id' => 'sch-el-no'), ); $form['search']['simulator'] = array( '#type' => 'select', '#title' => t('Simulator'), '#options' => $simulator_list->getAll(), '#default_value' => 0, '#attributes' => array('class' => array('qms-select'), 'id' => 'sch-simulator-list'), ); $form['search']['customer'] = array( '#type' => 'select', '#title' => t('Customer'), '#options' => $customer_list->getAll(), '#default_value' => 0, '#attributes' => array('class' => array('qms-select'), 'id' => 'sch-customer-list'), ); $form['search']['sim_quality'] = array( '#type' => 'select', '#title' => t('Simulator Quality'), '#options' => array( 0 => '- ' . t('Select') . ' -', 1 => t('Deficient'), 2 => t('Unsatisfactory'), 3 => t('Satisfactory'), 4 => t('Good'), 5 => t('Excellent'), ), '#default_value' => 0, '#attributes' => array('class' => array('qms-select'), 'id' => 'sch-sim-quality-list'), ); $form['search']['table_markup1'] = array( '#markup' => ' | ', ); $form['search']['search_date_label'] = array( '#markup' => ' |
| ', //'#suffix' => ' | ', ); $form['search']['to_date'] = array( '#type' => 'date_popup', '#title' => t('To Date'), '#size' => 10, '#date_format' => 'm-d-Y', '#attributes' => array('style' => array('float:left', 'clear:right', 'width:50px'), 'id' => 'sch-to-date', 'class' => array('qms-date-picker')), //'#prefix' => '', '#suffix' => ' |
| ', '#suffix' => ' |
',
);
// storage area for dynamic dialog element
$form['popup_dialog'] = array(
'#markup' => '',
);
return $form;
}
/**
* elogs_search_callback()
* displays the search results, first page only
* Has to be a separate handler from pager & sort link callback
* This is the callback that gets called when the Search button is clicked
*
*/
function elogs_search_callback() {
$search = new stdClass();
$search->el_no = trim($_POST['el_no']);
$search->simulator_id = (int)$_POST['simulator'];
$search->customer_id = (int)$_POST['customer'];
$search->from_date = trim($_POST['from_date']);
$search->to_date = trim($_POST['to_date']);
$search->sim_quality = (int)$_POST['sim_quality'];
$search->session_name_id = (int)$_POST['session'];
// cache the latest search key
// determine cache name, always use it specific to this user + session
// set key cache to expire in 30 minutes
$key_cache_name = _get_scheduler_cache_name(SCH_ELOGS_SEARCH_KEY);
cache_set($key_cache_name, $search, 'cache', REQUEST_TIME + QMS_CACHE_TIMEOUT);
die(_get_elogs_search_list($search));
}
/**
* elogs_pager_callback()
* displays the search results, for subsequent page results
* Has to be a separate handler from pager & sort link callback
* This is the callback that gets called when the page number links are clicked
*
*/
function elogs_pager_callback() {
$search = new stdClass();
// determine the key cache
$key_cache_name = _get_scheduler_cache_name(SCH_ELOGS_SEARCH_KEY);
$key_cache = cache_get($key_cache_name);
if ( isset($key_cache->data) && ($key_cache->data <> '') ) {
$search = $key_cache->data;
}
else {
// search key not in cache, get it from POST
// though, this should never happen... should always be in cache
$search->el_no = trim($_POST['el_no']);
$search->simulator_id = (int)$_POST['simulator'];
$search->customer_id = (int)$_POST['customer'];
$search->from_date = trim($_POST['from_date']);
$search->to_date = trim($_POST['to_date']);
$search->sim_quality = (int)$_POST['sim_quality'];
$search->session_name_id = (int)$_POST['session'];
// cache the latest search key
cache_set($key_cache_name, $search, 'cache', REQUEST_TIME + QMS_CACHE_TIMEOUT);
}
die(_get_elogs_search_list($search));
}
/*
* elogs_clear_callback()
*
* Clears the search results cache
*
*/
function elogs_clear_callback() {
// Clear the cache
$search_results = '';
// determine cache name
$results_cache_name = _get_scheduler_cache_name(SCH_ELOGS_SEARCH_RESULTS);
$key_cache_name = _get_scheduler_cache_name(SCH_ELOGS_SEARCH_KEY);
cache_set($results_cache_name, $search_results, 'cache', REQUEST_TIME + QMS_CACHE_TIMEOUT);
cache_clear_all($key_cache_name, 'cache', TRUE);
// this is an ajax callback. Need to return + die or it renders a full page
// we only want a piece of a page
die($search_results);
}
/*
* _get_elogs_search_list()
* display the search results
* This function gets called by elogs_search_callback() and elogs_pager_callback()
*
*/
function _get_elogs_search_list($search) {
if ( user_access('view manage menu') == FALSE ) {
drupal_set_message( t('Unauthorized. Permission is required.'), 'status');
drupal_goto(''); // go to main page -- not authorized for any other page
return '';
}
$table_header = array(
array( 'data' => t('EL No.'),
'field' => 'el_no',
'sort' => 'asc',
'class' => array('sch-tbl-elog-elno')
),
array( 'data' => t('Date'),
'field' => 'created_date',
'sort' => 'desc',
'class' => array('sch-tbl-elog-date')
),
array( 'data' => t('Simulator'),
'field' => 'sim_name',
'sort' => 'asc',
'class' => array('sch-tbl-elog-sim')
),
array( 'data' => t('Customer'),
'field' => 'customer',
'sort' => 'asc',
'class' => array('sch-tbl-elog-customer')
),
array( 'data' => t('Quality'),
'field' => 'sim_quality_rating',
'sort' => 'asc',
'class' => array('sch-tbl-elog-quality')
),
array( 'data' => t('Admin'), 'class' => array('qms-results-admin') ),
);
$search_init = array(
'table_name' => 'sch_elogs',
'table_alias' => 'e',
'table_header' => $table_header,
'pager_path' => 'elogs/pager',
'order' => 'created_date',
'sort' => 'desc',
);
$query = _st_setup_paged_search($search_init);
// Need to use the DB abstration layer here for the paging features
//$query = db_select('sch_elogs', 'e');
//--------- Link to Assignments ---------
$query->innerJoin('sch_assignments', 'a', 'a.assignment_id = e.assignment_id');
$query->leftJoin('sch_schedules', 'sch', 'sch.schedule_id = a.schedule_id');
$query->leftJoin('sch_simulators', 'sim', 'sim.simulator_id = sch.simulator_id');
$query->leftJoin('sch_customers', 'c', 'c.customer_id = a.customer_id');
$query->leftJoin('sch_schedule_sessions', 'ss',
'ss.schedule_session_id = a.schedule_session_id');
$query->leftJoin('sch_session_names', 'sn',
'ss.session_name_id = sn.session_name_id');
//--------- Date filtering -----------
if ( isset($search->from_date) || isset($search->to_date) ) {
if ( (strlen($search->from_date) > 0) && (strlen($search->to_date) > 0)) {
$query->condition('e.created_date', _st_format_system_timestamp($search->from_date . " 00:00:00"), '>=');
$query->condition('e.created_date', _st_format_system_timestamp($search->to_date . " 23:59:59"), '<=');
}
else if (strlen($search->from_date) > 0) {
$query->condition('e.created_date', _st_format_system_timestamp($search->from_date . " 00:00:00"), '>=');
}
else if (strlen($search->to_date) > 0) {
$query->condition('e.created_date', _st_format_system_timestamp($search->to_date . " 23:59:59"), '<=');
}
}
//---------- EL No -----------------
if ( strlen($search->el_no) && ( $search->el_no <> 'EL') ) { // if only EL prefix, don't bother
$query->condition('e.el_no', $search->el_no . '%', 'LIKE'); // append wildcard for fuzzy match
}
//---------- Simulator ----------------
if ( isset($search->simulator_id) && $search->simulator_id ) {
$query->condition('sch.simulator_id', $search->simulator_id);
}
//---------- Customer -----------------
if ( isset($search->customer_id) && $search->customer_id ) {
$query->condition('a.customer_id', $search->customer_id);
}
//---------- Sim Quality Rating -----------------
if ( isset($search->sim_quality) && $search->sim_quality ) {
$query->condition('e.sim_quality_rating', $search->sim_quality);
}
//---------- Session -----------------
if ( isset($search->session_name_id) && $search->session_name_id ) {
$query->condition('ss.session_name_id', $search->session_name_id);
}
$query->fields('e', array('elog_id', 'el_no', 'sim_quality_rating', 'created_date') )
->fields('sim', array('simulator_id', 'sim_name', 'active',
'faa_id', 'device_id_internal'))
->fields('sch', array('schedule_id', 'timezone'))
->fields('sn', array('session_name'))
->fields('c', array('customer'));
$max_count = 0;
$result = _st_execute_paged_search($query, $max_count);
$i = 0;
$table_rows = array();
foreach ($result as $row) {
$quality = '';
switch ($row->sim_quality_rating) {
case 1: $quality = t('Deficient'); break;
case 2: $quality = t('Unsatisfactory'); break;
case 3: $quality = t('Satisfactory'); break;
case 4: $quality = t('Good'); break;
case 5: $quality = t('Excellent'); break;
default:
break;
}
$sim_name = '';
if ( $row->simulator_id ) {
$sim_name = _st_format_sim_name($row->sim_name, $row->device_id_internal, $row->active);
}
$row_data = array(
l($row->el_no, 'elog/view/' . $row->elog_id,
array('query' => array('destination' => 'reports/search/elogs'))),
_st_format_schedule_date($row->created_date, 'short', $row->timezone) . '' . $sim_name . ' | ' .
'' . t('FAA') . ' #' . $assignment->faa_id . ' | ' .
'' . $assignment->session_type_desc . ' | ',
);
if ( $is_linked ) {
$create_dr_url = 'discrepancy/' . $assignment_id . '/' . $elog_id;
$form['submit_with_dr1'] = array(
'#type' => 'submit',
'#value' => t('E-DR'),
'#name' => 'submit_with_dr1',
'#attributes' => array('class' => array('qms-btn-create-dr'),
'id' => 'sch-btn-create-dr1'),
//'onclick' => 'window.location="' .
// url($submit_with_dr1_url) . '?destination=' .
// current_path() . '"; return false;'),
'#prefix' => '',
'#suffix' => ' ' . t('E-Discrepancy') . ' | ',
);
}
else {
// no QMS-scheduler link, do not show this button
$form['submit_with_dr1'] = array(
'#markup' => '', ); } $form['elog_heading_table_row'] = array( '#markup' => ' | |
' . $adt . ' | ' .
'' . $assignment->session_name . ': ' . $assignment->begin_time_actual . ' - ' . $assignment->end_time_actual . ' | ' .
'' . sprintf('%0.1f', $f_assign_hours) . ' ' . t('hours') . ' | ' .
// this is a place holder cell for the DR button above
'', ); $form['elog_heading_table_end'] = array( '#markup' => ' | ||
| ', '#suffix' => ' | ', ); $form['last_name_' . $i] = array( '#type' => 'textfield', '#title' => t('Last Name'), '#maxlength' => 50, '#size' => 18, '#default_value' => (isset($elog_crew[$i]->lname) ? $elog_crew[$i]->lname : $lname_default), '#attributes' => array('class' => array( 'sch-crew-input', 'sch-crew-lname', 'sch-crew-lname-' . $i) ), '#prefix' => '', '#suffix' => ' | ', ); /* ---May add this back in later as an option--- $form['employee_num_' . $i] = array( '#type' => 'textfield', '#title' => t('Employee Number'), '#maxlength' => 50, '#size' => 20, '#default_value' => isset($elog_crew[$i]->employee_num) ? $elog_crew[$i]->employee_num : '', '#attributes' => array('class' => array('sch-crew-employee-num-' . $i)), '#prefix' => '', '#suffix' => ' | ', );*/ $is_visible = 'hidden'; $bPilots = False; if ( isset($elog_crew[$i]->flight_role_1_id) && ( (SCH_CREW_PILOT == $elog_crew[$i]->flight_role_1_id) || (SCH_CREW_PILOT_2ND == $elog_crew[$i]->flight_role_1_id) ) ) { $is_visible = 'visible'; $bPilots = True; } //$hours_opts = _get_flight_role_time_opts($f_assign_hours); //reset($hours_opts); $flight_role_1_hours = 2.0; //current($hours_opts); // get the first entry 'ALL' $flight_role_2_hours = '0'; if (isset($elog_crew[$i]->flight_role_1_time) && ($elog_crew[$i]->flight_role_1_time )) { $flight_role_1_hours = sprintf('%0.2f', $elog_crew[$i]->flight_role_1_time / (60 * 60)); } // if (isset($elog_crew[$i]->flight_role_2_time) && // ($elog_crew[$i]->flight_role_2_time )) { // $flight_role_2_hours = // sprintf('%0.2f', $elog_crew[$i]->flight_role_2_time / (60 * 60)); // } $form['flight_role_first_' . $i] = array( '#type' => 'select', '#title' => t('Flight Role') . ($bPilots ? ' - ' . t('First') : ''), '#options' => $flight_roles->get(), '#default_value' => (isset($elog_crew[$i]->flight_role_1_id) ? $elog_crew[$i]->flight_role_1_id : $flight_role_default), '#attributes' => array('class' => array( 'sch-crew-input', 'sch-flight-role-select', 'sch-crew-flight-role', 'sch-crew-flight-role-first-' . $i), 'qms-index' => $i), '#prefix' => '', '#suffix' => ' | ', ); $form['flight_role_hours_first_' . $i] = array( '#type' => 'textfield', '#title' => t('Hours'), '#maxlength' => 4, '#size' => 4, //'#options' => $hours_opts, '#default_value' => isset($elog_crew[$i]->flight_role_1_time) ? $flight_role_1_hours : $flight_role_1_hours_default, '#attributes' => array('class' => array( 'qms-numeric', 'sch-crew-flight-role-hours-first', 'sch-crew-flight-role-hours-first-' . $i), 'qms-index' => $i), '#prefix' => '' .
' ',
'#suffix' => ' | ',
);
$form['flight_role_second_' . $i] = array(
'#type' => 'item',
'#title' => t('Flight Role') . ' - ' . t('Second'),
'#markup' => '' .
( (isset($elog_crew[$i]->flight_role_2_id) &&
$elog_crew[$i]->flight_role_2_id) ?
$flight_roles->getName($elog_crew[$i]->flight_role_2_id) : '---') .
// '' .
' ',
'#suffix' => ' ',
);
$form['elog_crew_id_' . $i] = array(
'#type' => 'textfield',
'#default_value' => isset($elog_crew[$i]->elog_crew_id) ? $elog_crew[$i]->elog_crew_id : 0,
'#attributes' => array('class' => array('qms-hidden')),
'#suffix' => ' |
'.
''.t('Created'). ': ' .
( $elog->created_by_user ? $created_user_link . ', ' : '' ) .
( $elog->created_date ? _st_format_date($elog->created_date, 'medium') : '');
if (!empty($elog->updated_by_user)) {
$body .=
'
' .
''.t('Updated').': ' .
( $elog->updated_by_user ? $updated_user_link . ', ' : '' ) .
( $elog->updated_date ? _st_format_date($elog->updated_date, 'medium') : '');
}
$body .= '
'. $elog->el_no . ' | |
| '.t('Customer').' | ' . '' . $customer_info . ' |
| '.t('Simulator').' | ' . '' . $simulator_info . ' |
| '.t('Date Submitted').' | ' . '' . _st_format_date($elog->created_date, 'short') . ' |
| '.t('Session').' | ' . '' . $session_info . ' |
| '.t('Session Type').' | ' . '' . $assignment->session_type_desc . ' |
| | |
| '.t('Flight Crew').' | |
| ' . sprintf("%s %s, %s", $crew->fname, $crew->lname, $flight_roles->getName($crew->flight_role_1_id) ). ' | |
| | |
| '.t('Quality Rating').' | ' . '' . $quality_rating . ' |
| '.t('Comments').' | |
| '.nl2br(_st_convert_symbols($elog->log_text)).' | |
' . $sim_name . ' | ' .
'' . t('FAA') . ' #' . $assignment->faa_id . ' | ' .
'' . $assignment->session_type_desc . ' | ' .
'
' . $adt . ' | ' .
'' . $assignment->session_name . ': ' . $assignment->begin_time_actual . ' - ' . $assignment->end_time_actual . ' | ' .
'' . sprintf('%0.1f', $assignment->total_time / (60 * 60)) . ' ' . t('hours') . ' | ' .
'
| ' . t('First Name') . ' | ' . '' . t('Last Name') . ' | ' . '' . t('Employee Number') . ' | ' . '' . t('Flight Role') . ' |
|---|