function has_completed_webform in Ubercart Webform Integration 7

1 call to has_completed_webform()

uc_webform_webform_client_form_submit in ./uc_webform.module

File

./uc_webform.module, line 466

Code

function has_completed_webform($webform_nid) {
  global $user;
  $query = db_select('webform_submissions', 'ws');
  $query
    ->leftJoin('uc_webform_submission', 'uc_ws', 'uc_ws.sid = ws.sid');
  $query
    ->leftJoin('uc_orders', 'o', 'uc_ws.order_id = o.order_id');
  $or = db_or();
  $or
    ->condition('o.order_status', 'Completed', '!=')
    ->condition('o.order_status', NULL);
  $row = $query
    ->fields('ws')
    ->fields('o')
    ->condition('ws.nid', $webform_nid)
    ->condition('ws.uid', $user->uid)
    ->condition('ws.is_draft', 0)
    ->condition($or)
    ->execute()
    ->fetchAssoc();
  return (bool) $row;
}