function globallink_fieldable_panels_get_active_submission_rows 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_active_submission_rows()

Gets active fieldable panels submission rows by node ID.

Parameters

string $fpids: The array of fieldable panels IDs.

Return value

Associative array of fieldable panels active submission rows. FALSE if the array is empty.

1 call to globallink_fieldable_panels_get_active_submission_rows()

globallink_fieldable_panels_dashboard_form in globallink_fieldable_panels/globallink_fieldable_panels_send.inc

Builds form to create a fieldable panels submission.

File

globallink_fieldable_panels/globallink_fieldable_panels.inc, line 371

Code

function globallink_fieldable_panels_get_active_submission_rows($fpid) {
  $query = db_select('globallink_core_fieldable_panels', 'tcfp');
  $query
    ->condition('status', 'Sent for Translations', '=');
  $query
    ->condition('fpid', $fpid, '=');
  $query
    ->fields('tcfp');
  $results = $query
    ->execute();
  $arr = array();
  foreach ($results as $row) {
    if (array_key_exists($row->fpid, $arr)) {
      array_push($arr[$row->fpid], $row);
    }
    else {
      $arr[$row->fpid] = array(
        $row,
      );
    }
  }
  $final_arr = array();
  foreach ($arr as $fpid => $mlid_arr) {
    $sub_arr = array();
    foreach ($mlid_arr as $r) {
      if (array_key_exists($r->submission, $sub_arr)) {
        array_push($sub_arr[$r->submission], $r->target);
      }
      else {
        $sub_arr[$r->submission] = array(
          $r->target,
        );
      }
    }
    if (count($sub_arr) > 0) {
      $final_arr[$fpid] = $sub_arr;
    }
  }
  if (count($final_arr) > 0) {
    return $final_arr;
  }
  return FALSE;
}