<?php
// $Id:

/*
*  This file is used to tell the views module about the new uc_address table.
*
* Database definition:
* @code
*   CREATE TABLE site_uc_addresses (
  aid int(10) unsigned NOT NULL auto_increment,
  uid int(10) unsigned NOT NULL default '0',
  first_name varchar(255) NOT NULL default '',
  last_name varchar(255) NOT NULL default '',
  phone varchar(255) NOT NULL default '',
  company varchar(255) NOT NULL default '',
  street1 varchar(255) NOT NULL default '',
  street2 varchar(255) NOT NULL default '',
  city varchar(255) NOT NULL default '',
  zone mediumint(9) NOT NULL default '0',
  postal_code varchar(255) NOT NULL default '',
  country mediumint(8) unsigned NOT NULL default '0',
  address_name varchar(20) default NULL,
  created int(11) NOT NULL default '0',
  modified int(11) NOT NULL default '0',
  PRIMARY KEY  (aid),
  KEY aid_uid_idx (aid,uid)
) 
* @endcode
*/

function uc_address_views_data()  {
  // Basic table information.

  // ----------------------------------------------------------------
  // uc_address table
  //  New group within Views called 'Example'

  $data = array();
  $data['uc_address']['table']['group']  = t('Example');

  // tables + fields that can be used for SQL Joins
  $data['uc_address']['table']['join'] = array(
    'uc_addresses_defaults' => array(
      'left_field' => 'aid',
      'field' => 'aid',
    ),
  );

  //  First Name
  $data['uc_address']['first_name'] = array(
    'title' => t('First Name'),
    'help' => t('First Name'),
    'field' => array(
      'handler' => 'views_handler_field_string',
      'click sortable' => TRUE,
     ),
    'filter' => array(
      'handler' => 'views_handler_filter_string',
    ),
    'sort' => array(
      'handler' => 'views_handler_sort',
    ),
  );

  //  Last Name
  $data['uc_address']['last_name'] = array(
    'title' => t('Last Name'),
    'help' => t('Last Name'),
    'field' => array(
      'handler' => 'views_handler_field_string',
      'click sortable' => TRUE,
     ),
    'filter' => array(
      'handler' => 'views_handler_filter_string',
    ),
    'sort' => array(
      'handler' => 'views_handler_sort',
    ),
  );
  
    //  Phone
  $data['uc_address']['phone'] = array(
    'title' => t('Phone'),
    'help' => t('Phone'),
    'field' => array(
      'handler' => 'views_handler_field_string',
      'click sortable' => TRUE,
     ),
    'filter' => array(
      'handler' => 'views_handler_filter_string',
    ),
    'sort' => array(
      'handler' => 'views_handler_sort',
    ),
  );
  
  // Company
  $data['uc_address']['company'] = array(
    'title' => t('Company'),
    'help' => t('Company'),
    'field' => array(
      'handler' => 'views_handler_field_string',
      'click sortable' => TRUE,
     ),
    'filter' => array(
      'handler' => 'views_handler_filter_string',
    ),
    'sort' => array(
      'handler' => 'views_handler_sort',
    ),
  );
  
  // Street1
  $data['uc_address']['street1'] = array(
    'title' => t('Street1'),
    'help' => t('Street1'),
    'field' => array(
      'handler' => 'views_handler_field_string',
      'click sortable' => TRUE,
     ),
    'filter' => array(
      'handler' => 'views_handler_filter_string',
    ),
    'sort' => array(
      'handler' => 'views_handler_sort',
    ),
  );
  
  // Street2
  $data['uc_address']['street2'] = array(
    'title' => t('Street2'),
    'help' => t('Street2'),
    'field' => array(
      'handler' => 'views_handler_field_string',
      'click sortable' => TRUE,
     ),
    'filter' => array(
      'handler' => 'views_handler_filter_string',
    ),
    'sort' => array(
      'handler' => 'views_handler_sort',
    ),
  );
  
  // City
  $data['uc_address']['city'] = array(
    'title' => t('City'),
    'help' => t('City'),
    'field' => array(
      'handler' => 'views_handler_field_string',
      'click sortable' => TRUE,
     ),
    'filter' => array(
      'handler' => 'views_handler_filter_string',
    ),
    'sort' => array(
      'handler' => 'views_handler_sort',
    ),
  ); 

  //Zone
  $data['uc_address']['zone'] = array(
    'title' => t('Zone'),
    'help' => t('Zone'),
    'field' => array(
      'handler' => 'views_handler_field_numeric',
      'click sortable' => TRUE,
     ),
    'filter' => array(
      'handler' => 'views_handler_filter_numeric',
    ),
    'sort' => array(
      'handler' => 'views_handler_sort',
    ),
  ); 

 // Postal Code
  $data['uc_address']['postal_code'] = array(
    'title' => t('Postal Code'),
    'help' => t('Postal Code'),
    'field' => array(
      'handler' => 'views_handler_field_string',
      'click sortable' => TRUE,
     ),
    'filter' => array(
      'handler' => 'views_handler_filter_string',
    ),
    'sort' => array(
      'handler' => 'views_handler_sort',
    ),
  );
  
  //Country
  $data['uc_address']['country'] = array(
    'title' => t('Country'),
    'help' => t('Country'),
    'field' => array(
      'handler' => 'views_handler_field_numeric',
      'click sortable' => TRUE,
     ),
    'filter' => array(
      'handler' => 'views_handler_filter_numeric',
    ),
    'sort' => array(
      'handler' => 'views_handler_sort',
    ),
  ); 

 // Address Name
  $data['uc_address']['address_name'] = array(
    'title' => t('Address Name'),
    'help' => t('Address Name'),
    'field' => array(
      'handler' => 'views_handler_field_string',
      'click sortable' => TRUE,
     ),
    'filter' => array(
      'handler' => 'views_handler_filter_string',
    ),
    'sort' => array(
      'handler' => 'views_handler_sort',
    ),
  );

//Created
  $data['uc_address']['created'] = array(
    'title' => t('Created'),
    'help' => t('Created'),
    'field' => array(
      'handler' => 'views_handler_field_numeric',
      'click sortable' => TRUE,
     ),
    'filter' => array(
      'handler' => 'views_handler_filter_numeric',
    ),
    'sort' => array(
      'handler' => 'views_handler_sort',
    ),
  );   
  
//Modified
  $data['uc_address']['modified'] = array(
    'title' => t('Modified'),
    'help' => t('Modified'),
    'field' => array(
      'handler' => 'views_handler_field_numeric',
      'click sortable' => TRUE,
     ),
    'filter' => array(
      'handler' => 'views_handler_filter_numeric',
    ),
    'sort' => array(
      'handler' => 'views_handler_sort',
    ),
  );   

// Relationship to uc_address_defaults_table  

 $data['uc_address']['table']['base'] = array(
    'field' => 'aid',
    'title' => t('Address'),
    'help' => t("Ubercart Address fields."),
    'weight' => -9,
  );
  
$data['uc_address']['aid'] = array(
    'title' => t('Address'),
    'help' => t('The particular default address for the user'),
    'relationship' => array(
      'label' => t('Address'),
      'base' => 'uc_address_defaults',
      'base field' => 'aid',
    ),
  );
  
  return $data;
}
?>