function globallink_fieldable_panels_get_submission_status in GlobalLink Connect for Drupal 7.5

Same name and namespace in other branches

1. 7.6 globallink_fieldable_panels/globallink_fieldable_panels.inc \globallink_fieldable_panels_get_submission_status()

Gets fieldable panels submission status.

1 call to globallink_fieldable_panels_get_submission_status()

globallink_fieldable_panels_active_select_form in globallink_fieldable_panels/globallink_fieldable_panels_active_submissions.inc

Builds form to allow selection of specific fieldable panels submission by ID.

File

globallink_fieldable_panels/globallink_fieldable_panels.inc, line 440

Code

function globallink_fieldable_panels_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_fieldable_panels', 'tcfp');
  $query
    ->fields('tcfp', 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_fieldable_panels_update_submission_status($row->submission_ticket);
        }
      } catch (SoapFault $se) {
        globallink_fieldable_panels_update_submission_status($row->submission_ticket);
      } catch (Exception $ex) {
        globallink_fieldable_panels_update_submission_status($row->submission_ticket);
      }
    }
  }
}