',
'#suffix' => '',
);
//--------------------------------------------
// Adds a simple submit button that refreshes the form and clears its contents
// -- this is the default behavior for forms.
$form['actions'] = array('#type' => 'actions');
$form['actions']['submit'] = array(
'#type' => 'submit',
'#value' => t('Submit'),
'#name' => 'submit',
'#attributes' => array('class' => array('qms-btn-submit')),
);
$form['actions']['clear'] = array(
'#type' => 'button',
'#value' => t('Clear'),
'#name' => 'clear',
'#attributes' => array('class' => array('qms-btn-clear', 'qms-btn-extra')),
);
// storage area for dynamic dialog element
$form['popup_dialog'] = array(
'#markup' => '
',
);
return $form;
}
/*------ AFTER BUILD FUNCTION --------
* functions called, as it implies, after the form is built
* this is necessary when custom javascript and/or css files are added as needed
* at the page level for forms that go through validation with hook_form_validate()
* Otherwise, if a form fails validation, the page/form is reloaded for the user to correct
* but the accompanying javascript & css is not reloaded with it.
* when $form['#after_build][] is used, the external scripts will be reloaded properly.
*/
/*
* user_feedback_form_after_build()
*
*/
function user_feedback_form_after_build($form, &$form_state)
{
//drupal_add_js(drupal_get_path('module', 'sabreTools') . '/js/sabreTools.lib.js');
drupal_add_js(drupal_get_path('module', 'sabreQMS') . '/js/sabreQMS.userfeedbackinput.js');
return $form;
}
/*
* user_feedback_form_validate()
*
* overloads: hook_form_validate()
*/
function user_feedback_form_validate($form, $form_state) {
if ( trim( $form_state['values']['name'] ) == '' ) {
form_set_error('name', t('Please enter your name.'));
}
$email = trim($form_state['values']['email']);
if ( $email == '' ) {
form_set_error('email', t('Please enter your email address.'));
}
if (!valid_email_address($email)) {
form_set_error('email', 'Your email address appears malformed');
}
if ( trim( $form_state['values']['comment'] ) == '' ) {
form_set_error('comment', t('Please enter a comment.'));
}
if ( ((int)$form_state['values']['other_rate'] > 0) &&
(trim( $form_state['values']['other_rate_text'] ) == '') ) {
form_set_error('other_rate_text', t('You have indicated a rating for "Other", but you do not provide a description of what Other represents.'));
}
}
/*
* user_feedback_form_submit()
*
* overloads: hook_form_submit()
*/
function user_feedback_form_submit($form, $form_state) {
$feedback = (object) Null;
$feedback->date_entered = time();
$feedback->name = trim($form_state['values']['name']);
$feedback->email = trim($form_state['values']['email']);
$feedback->comment = trim($form_state['values']['comment']);
$feedback->as_rate = (int)$form_state['values']['as_rate'];
$feedback->hardware_rate = (int)$form_state['values']['hardware_rate'];
$feedback->ios_rate = (int)$form_state['values']['ios_rate'];
$feedback->instrument_rate = (int)$form_state['values']['instrument_rate'];
$feedback->motion_rate = (int)$form_state['values']['motion_rate'];
$feedback->sound_rate = (int)$form_state['values']['sound_rate'];
$feedback->visual_rate = (int)$form_state['values']['visual_rate'];
$feedback->other_rate = (int)$form_state['values']['other_rate'];
$feedback->other_text = trim($form_state['values']['other_rate_text']);
$email_copy = (int)$form_state['values']['email_copy'];
// store the feedback as a new record
if ( drupal_write_record('qms_user_feedback', $feedback)) {
// new record
// new id was assigned -- saved successfully
$msg = 'Thank you for your feedback.';
}
else {
$msg = 'Oops! Our apologies, something went wrong storing your feedback.';
}
drupal_set_message(t($msg));
// format an email message to send out
$body = _format_body_user_feedback_email($feedback);
$subject = 'QMS User Feedback Responses';
// get the email addresses of the qms users who are notified of user feedback & send the emails out
$result = db_query("SELECT mail FROM {users} u, {qms_employees} e WHERE u.uid = e.user_id AND e.receive_feedback = 1");
foreach($result as $row) {
$to = $row->mail;
_st_send_drupal_email($feedback->user_feedback_id, $subject, $body, $to);
}
// send a copy of the feedback results to the user if the checkbox was checked
if ( $email_copy ) {
$to = $feedback->email;
$body .= '
Thank you for your feedback!';
_st_send_drupal_email($feedback->user_feedback_id, $subject, $body, $to);
}
drupal_goto('');
}
/*
* user_feedback_display()
*
* returns a table of user feedback that has been logged
*/
function user_feedback_display($called_by_pager = False) {
if ( user_access('view admin lists') == False ) {
drupal_set_message( t('Unauthorized Access. Permission is required.'));
drupal_goto('');
return;
}
if ( ! $called_by_pager ) {
drupal_add_library('system','ui.dialog');
drupal_add_js(drupal_get_path('module', 'sabreTools') . '/js/sabreTools.lib.js');
drupal_add_js(drupal_get_path('module', 'sabreQMS') . '/js/sabreQMS.userfeedback.js');
}
$num_per_page = QMS_RECORDS_PER_PAGE;
$table_header = array(
array( 'data' => 'Date', 'field' => 'date_entered', 'sort' => 'desc' ),
array( 'data' => 'Name/Email', 'field' => 'name', 'sort' => 'asc' ),
array( 'data' => 'Comment', 'field' => 'comment' ),
array( 'data' => 'AS', 'field' => 'as_rate' ),
array( 'data' => 'HW', 'field' => 'hardware_rate' ),
array( 'data' => 'IOS', 'field' => 'ios_rate' ),
array( 'data' => 'Inst', 'field' => 'instrument_rate' ),
array( 'data' => 'Mot', 'field' => 'motion_rate' ),
array( 'data' => 'Snd', 'field' => 'sound_rate' ),
array( 'data' => 'Vis', 'field' => 'visual_rate' ),
array( 'data' => 'Other', 'field' => 'other_rate' ),
array( 'data' => 'Admin' ),
);
$search_init = array(
'table_name' => 'qms_user_feedback',
'table_alias' => 'f',
'table_header' => $table_header,
'pager_path' => 'feedback/pager',
'order' => 'Date',
'sort' => 'desc',
'variable' => False,
);
$query = _st_setup_paged_search($search_init);
// Need to use the DB abstration layer here for the paging features
//$query = db_select('qms_user_feedback', 'f');
$query->fields('f', array('user_feedback_id', 'date_entered',
'name', 'email', 'comment',
'as_rate', 'hardware_rate', 'ios_rate',
'instrument_rate', 'motion_rate',
'sound_rate', 'visual_rate',
'other_rate', 'other_text') );
$max_count = 0;
$result = _st_execute_paged_search($query, $max_count);
$i = 0;
$table_rows = array();
foreach ($result as $row) {
$row_data = array(
_st_format_date($row->date_entered, 'custom', 'Y-m-d'),
l(t($row->name), 'mailto:' . $row->email),
((strlen($row->comment) > 40) ? substr($row->comment, 0, 39) . '...' : $row->comment),
$row->as_rate,
$row->hardware_rate,
$row->ios_rate,
$row->instrument_rate,
$row->motion_rate,
$row->sound_rate,
$row->visual_rate,
$row->other_rate,
l( t('Email-to-Me'), 'feedback/send/' . $row->user_feedback_id,
array('attributes' => array('class' => array('qms-feedback-send')) ) ) .
'
' .
l( t('Delete'), 'feedback/delete/' . $row->user_feedback_id,
array('attributes' => array('class' => array('qms-feedback-delete')) ) ),
);
$table_rows[] = array('data' => $row_data);
$i++;
}
$content = '
';
$content .= theme( 'table', array(
'header' => $table_header,
'rows' => $table_rows,
'empty' => t('None'),
));
//Append pager: http://api.drupal.org/api/drupal/includes--pager.inc/function/theme_pager
$content .= theme('pager', array('tags' => array(), 'quantity' => $num_per_page));
$content .= '
';
if ( $called_by_pager ) {
die($content);
}
$content .= '
';// storage area for dynamic dialog element
return $content;
}
/*
* email_feedback_to_admin()
*
* Callback handler from user_feedback_display() allows admin to resend user feedback email to self
* from clicking on the link in the user_feedback_display() table
*/
function email_feedback_to_admin($feedback_id) {
if ( $feedback_id == 0 ) {
return;
}
if ( user_access('administer sabreQMS') == FALSE ) {
drupal_set_message( t('Unauthorized Access. Administrator access required.'));
drupal_goto('');
return;
}
$sql = "SELECT user_feedback_id, date_entered, name, email, comment,
as_rate, hardware_rate, ios_rate, instrument_rate, motion_rate,
sound_rate, visual_rate, other_rate, other_text
FROM {qms_user_feedback} f WHERE user_feedback_id = :fid";
$result = db_query($sql, array(':fid' => $feedback_id));
if ( $result->rowCount() == 0 ) {
return;
}
$feedback = $result->fetchObject();
global $user;
// format an email message to send out
$body = _format_body_user_feedback_email($feedback);
$subject = 'QMS User Feedback Responses';
_st_send_drupal_email($feedback->user_feedback_id, $subject, $body, $user->mail); // in sabreQMS.utils.inc
drupal_set_message(t('The feedback record from ' . $feedback->name . ' has been sent to ' . $user->mail));
drupal_goto('feedback');
}
/*
* _format_body_user_feedback_email()
*
* sends the emails for user_feedback
*/
function _format_body_user_feedback_email($feedback) {
$body = '
Name: ' . $feedback->name . '
';
$body .= '
Email: ' . $feedback->email . '';
$body .= '
Comment:' . $feedback->comment . '
';
$body .= '
| Ratings: |
';
$body .= '| Aircraft System: | ' . _get_ratings_text($feedback->as_rate) . ' |
';
$body .= '| Hardware: | ' . _get_ratings_text($feedback->hardware_rate) . ' |
';
$body .= '| IOS: | ' . _get_ratings_text($feedback->ios_rate) . ' |
';
$body .= '| Instrument: | ' . _get_ratings_text($feedback->instrument_rate) . ' |
';
$body .= '| Motion: | ' . _get_ratings_text($feedback->motion_rate) . ' |
';
$body .= '| Sound: | ' . _get_ratings_text($feedback->sound_rate) . ' |
';
$body .= '| Visual: | ' . _get_ratings_text($feedback->visual_rate) . ' |
';
$body .= 'Other:
Description: | ' . _get_ratings_text($feedback->other_rate) . '
';
$body .= $feedback->other_text . ' |
';
return $body;
}
/*
* _get_ratings_text()
*
* returns the text description for the numeric rating response
* Called by sabreQMS.userfeedback.inc, user_feedback_form_submit()
*/
function _get_ratings_text($rating) {
switch ($rating) {
case 0: return 'Not Applicable';
case 1: return 'Needs Improvement';
case 2: return 'Meets Expectations';
case 3: return 'Exceeds Expectations';
}
}
/*
* user_feedback_delete_callback()
*
* Delete feedback record through ajax callback
*/
/*
function user_feedback_delete_callback($feedback_id) {
if ( user_access('administer sabreQMS') == FALSE ) {
form_set_error( t('Unauthorized Access'), t('Administrator access required.'));
drupal_goto('');
return;
}
if ( $feedback_id == 0 ) {
return;
}
// delete from database
$num_rows = db_delete('qms_user_feedback')
->condition('user_feedback_id', $feedback_id, '=')
->execute();
return user_feedback_display(True);
}
*/
/*
* user_feedback_delete_confirm()
*
* Validate and Ask for confirmation before deleting record
*/
function user_feedback_delete_confirm($form, $form_state, $feedback_id) {
if ( $feedback_id == 0 ) {
return;
}
if ( user_access('administer sabreQMS') == FALSE ) {
drupal_set_message( t('Unauthorized Access. Administrator access required.'));
drupal_goto('');
return;
}
// Get record by id
$sql = "SELECT name FROM {qms_user_feedback} WHERE user_feedback_id = :fid";
$result = db_query($sql, array(':fid' => $feedback_id));
if ( !$result->rowCount() ) {
drupal_set_message( t('Feedback Not Found!'), 'warning');
drupal_goto('feedback');
return;
}
$feedback_name = $result->fetchField();
$form['feedback_id'] = array(
'#type' => 'value',
'#value' => $feedback_id,
);
$form['feedback_name'] = array(
'#type' => 'value',
'#value' => $feedback_name,
);
$title = t('Delete User Feedback Entry') . '?';
$question = t('Are you sure you want to delete?') .
'
' . t('Feedback from ') . $feedback_name . '
' .
t('This action cannot be undone.');
$goto_if_canceled = 'feedback';
$yes_btn = t('Delete');
$no_btn = t('Cancel');
// force this here to avoid a problem with routing if cancelled
//$_GET['destination'] = $goto_if_canceled;
return confirm_form($form, $title, $goto_if_canceled, $question,
$yes_btn, $no_btn);
}
/*
* user_feedback_delete_confirm_submit()
*
* Submit after confirmation, delete the specified record
*/
function user_feedback_delete_confirm_submit($form, $form_state) {
if ( $form_state['values']['confirm']) {
$feedback_id = $form_state['values']['feedback_id'];
$feedback_name = $form_state['values']['feedback_name'];
if ( $feedback_id == 0 ) {
return;
}
// delete from database
$num_rows = db_delete('qms_user_feedback')
->condition('user_feedback_id', $feedback_id, '=')
->execute();
$msg = '';
if ( $num_rows == 1 ) {
$msg = 'Feedback from ' . $feedback_name . ' has been deleted.';
}
else {
$msg = 'Oops! Unable to delete feedback for ' . $feedback_name . '.';
}
drupal_set_message(t($msg));
}
drupal_goto('feedback');
}