function _uc_extra_field_pane_get_addresses_queryparts in Extra Fields Checkout Pane 6.2

_get_addresses_queryparts() Generate joins and selects for get addresses query

Parameters

int $uid:

string $type:

Return value

array

2 calls to _uc_extra_field_pane_get_addresses_queryparts()

_uc_extra_field_pane_get_order_addresses in includes/address_select.inc

_get_order_addresses() Returns addresses using the order table

_uc_extra_field_pane_get_uc_addresses in includes/address_select.inc

_get_uc_addresses() Returns addresses using the uc_addresses table

File

includes/address_select.inc, line 139

This file contains code for getting all addresses for one user

Code

function _uc_extra_field_pane_get_addresses_queryparts($fields, $table, $element_id, $element_type) {
  $select = array();
  $joins = array();
  $table = '{' . $table . '}';
  foreach ($fields as $field) {
    $table_name = 'uc_extra_fields_pane_values_' . $field->db_name;
    $alias = $field->db_name;
    $select[] = "{$table_name}.value AS {$alias}";
    $joins[] = "LEFT JOIN {uc_extra_fields_values} {$table_name} ON {$table}.{$element_id} = {$table_name}.element_id AND ({$table_name}.field_id = '" . $field->field_id . "' AND {$table_name}.element_type = '" . $element_type . "')";
  }
  return array(
    'select' => $select,
    'joins' => $joins,
  );
}