function globallink_get_active_submission_by_nid in GlobalLink Connect for Drupal 7.7

Same name and namespace in other branches

1. 7.5 globallink_node.inc \globallink_get_active_submission_by_nid()
2. 7.6 globallink_node.inc \globallink_get_active_submission_by_nid()

Gets active submission from nid.

Parameters

int $nid: The node id to pass in.

Return value

array An array representing the active submission.

1 call to globallink_get_active_submission_by_nid()

globallink_dashboard_node_form in ./globallink_send_translations.inc

Builds form to create a GlobalLink submission.

File

./globallink_node.inc, line 785

Code

function globallink_get_active_submission_by_nid($nid) {
  $query = db_select('globallink_document', 'gd');
  $query
    ->join('globallink_submission', 'gs', 'gd.submission_rid = gs.rid');
  $query
    ->condition('gd.object_id', $nid, '=');
  $query
    ->condition('gd.entity_type', GLOBALLINK_ENTITY_TYPE_NODE, '=');
  $or = db_or();
  $or
    ->condition('gd.target_status', GLOBALLINK_STATUS_TRANSLATION_SENT, '=');
  $or
    ->condition('gd.target_status', GLOBALLINK_STATUS_TRANSLATION_COMPLETED, '=');
  $or
    ->condition('gd.target_status', GLOBALLINK_STATUS_TRANSLATION_ERROR, '=');
  $query
    ->condition($or);
  $query
    ->fields('gd');
  $query
    ->fields('gs', array(
    'submission',
    'source_lang_code',
    'source_lang_name',
    'sub_target_lang_code',
    'sub_target_lang_name',
  ));
  $results = $query
    ->execute()
    ->fetchAll();
  return $results;
}