function globallink_menu_get_submission_status in GlobalLink Connect for Drupal 7.5

Same name and namespace in other branches

1. 7.6 globallink_menu/globallink_menu.inc \globallink_menu_get_submission_status()

Gets menu submission status.

1 call to globallink_menu_get_submission_status()

globallink_menu_active_select_form in globallink_menu/globallink_menu_active_submissions.inc

Builds form to allow selection of specific menu submission by ID.

File

globallink_menu/globallink_menu.inc, line 953

Code

function globallink_menu_get_submission_status() {
  module_load_include('inc', 'globallink', 'globallink_settings');
  module_load_include('inc', 'globallink', 'gl_ws/gl_ws_common');
  $query = db_select('globallink_core_menu', 'tc');
  $query
    ->fields('tc', array(
    'submission_ticket',
  ));
  $query
    ->distinct();
  $query
    ->condition('status', 'Sent for Translations', '=');
  $results = $query
    ->execute();
  foreach ($results as $row) {
    if ($row->submission_ticket) {
      try {
        $pd4 = globallink_get_project_director_details();
        $status = globallink_get_status($pd4, $row->submission_ticket);
        if (!$status || $status == 'CANCELLED') {
          globallink_menu_update_submission_status($row->submission_ticket);
        }
      } catch (SoapFault $se) {
        globallink_menu_update_submission_status($row->submission_ticket);
      } catch (Exception $ex) {
        globallink_menu_update_submission_status($row->submission_ticket);
      }
    }
  }
}