View source
<?php
function uc_wishlist_views_data() {
$data['uc_wishlists']['table']['group'] = t('Wishlist');
$data['uc_wishlists']['table']['base'] = array(
'field' => 'wid',
'title' => t('Wishlist'),
);
$data['uc_wishlists']['table']['join']['users'] = array(
'left_field' => 'uid',
'field' => 'uid',
'type' => 'INNER',
);
$data['uc_wishlists']['wid'] = array(
'title' => t('Wishlist id'),
'help' => t('Unique id for wishlist'),
'group' => 'Wishlist',
'field' => array(
'handler' => 'views_handler_field_numeric',
'float' => FALSE,
'click sortable' => TRUE,
),
'filter' => array(
'handler' => 'views_handler_filter_numeric',
),
'sort' => array(
'handler' => 'views_handler_sort',
),
'argument' => array(
'handler' => 'views_handler_argument_numeric',
),
);
$data['uc_wishlists']['uid'] = array(
'title' => t('user id'),
'help' => t('user id who created the wishlist'),
'group' => 'Wishlist',
'field' => array(
'handler' => 'views_handler_field_numeric',
'float' => FALSE,
'click sortable' => TRUE,
),
'filter' => array(
'handler' => 'views_handler_filter_equality',
),
);
$data['uc_wishlists']['title'] = array(
'title' => t('wishlist title'),
'help' => t('Title for wishlist'),
'group' => 'Wishlist',
'field' => array(
'handler' => 'views_handler_field',
'click sortable' => TRUE,
),
'sort' => array(
'handler' => 'views_handler_sort',
),
'filter' => array(
'handler' => 'views_handler_filter_string',
),
'argument' => array(
'handler' => 'views_handler_argument_string',
),
);
$data['uc_wishlists']['description'] = array(
'title' => t('wishlist description'),
'help' => t('Wishlist description'),
'group' => 'Wishlist',
'field' => array(
'handler' => 'views_handler_field',
),
);
$data['uc_wishlists']['expiration'] = array(
'title' => t('Expiry date'),
'help' => t('Timestamp for when the wish list expires'),
'group' => 'Wishlist',
'field' => array(
'handler' => 'views_handler_field_date',
'click sortable' => TRUE,
),
'sort' => array(
'handler' => 'views_handler_sort_date',
),
'filter' => array(
'handler' => 'views_handler_filter_date',
),
);
$data['uc_wishlists']['address'] = array(
'title' => t('Shipping Address'),
'help' => t('Address for shipping items on the wish list'),
'group' => 'Wishlist',
'field' => array(
'handler' => 'views_handler_field',
'click sortable' => TRUE,
),
'sort' => array(
'handler' => 'views_handler_sort',
),
'filter' => array(
'handler' => 'views_handler_filter_string',
),
'argument' => array(
'handler' => 'views_handler_argument_string',
),
);
$data['uc_wishlists']['private'] = array(
'title' => t('Private'),
'help' => t('Private'),
'group' => 'Wishlist',
'field' => array(
'handler' => 'views_handler_field_numeric',
'float' => FALSE,
'click sortable' => TRUE,
),
'filter' => array(
'handler' => 'views_handler_filter_equality',
),
);
$data['uc_wishlist_products']['table']['group'] = t('Wishlist products');
$data['uc_wishlist_products']['table']['join']['node'] = array(
'left_field' => 'nid',
'field' => 'nid',
);
$data['uc_wishlist_products']['table']['join']['uc_wishlists'] = array(
'left_field' => 'wid',
'field' => 'wid',
'type' => 'INNER',
);
$data['uc_wishlist_products']['wpid'] = array(
'title' => t('Wishlist product id'),
'help' => t('The ID of the wish list product.'),
'group' => 'Wishlist products',
'field' => array(
'handler' => 'views_handler_field_numeric',
'float' => FALSE,
'click sortable' => TRUE,
),
'filter' => array(
'handler' => 'views_handler_filter_numeric',
),
'sort' => array(
'handler' => 'views_handler_sort',
),
'argument' => array(
'handler' => 'views_handler_argument_numeric',
),
);
$data['uc_wishlist_products']['wid'] = array(
'title' => t('Wishlist id'),
'help' => t('The {uc_wishlists}.wid for the wish list this product is assigned to'),
'group' => 'Wishlist products',
'field' => array(
'handler' => 'views_handler_field_numeric',
'float' => FALSE,
'click sortable' => TRUE,
),
'relationship' => array(
'base' => 'uc_wishlists',
'base field' => 'wid',
'handler' => 'views_handler_relationship',
'label' => t('Wishlist'),
),
'filter' => array(
'handler' => 'views_handler_filter_numeric',
),
'sort' => array(
'handler' => 'views_handler_sort',
),
'argument' => array(
'handler' => 'views_handler_argument_numeric',
),
);
$data['uc_wishlist_products']['nid'] = array(
'title' => t('products node id'),
'help' => t('The {node}.nid of the product.'),
'group' => 'Wishlist products',
'field' => array(
'handler' => 'views_handler_field_numeric',
'float' => FALSE,
'click sortable' => TRUE,
),
'relationship' => array(
'base' => 'node',
'base field' => 'nid',
'handler' => 'views_handler_relationship',
'label' => t('Product'),
),
'filter' => array(
'handler' => 'views_handler_filter_numeric',
),
'sort' => array(
'handler' => 'views_handler_sort',
),
'argument' => array(
'handler' => 'views_handler_argument_numeric',
),
);
$data['uc_wishlist_products']['qty'] = array(
'title' => t('Product quantity'),
'help' => t('The quantity of this product on the wish list.'),
'group' => 'Wishlist products',
'field' => array(
'handler' => 'views_handler_field_numeric',
'float' => FALSE,
'click sortable' => TRUE,
),
'filter' => array(
'handler' => 'views_handler_filter_numeric',
),
'sort' => array(
'handler' => 'views_handler_sort',
),
'argument' => array(
'handler' => 'views_handler_argument_numeric',
),
);
$data['uc_wishlist_products']['data'] = array(
'title' => t('product data'),
'help' => t('The data array for the product.'),
'group' => 'Wishlist products',
'field' => array(
'handler' => 'views_handler_field',
'click sortable' => TRUE,
),
'sort' => array(
'handler' => 'views_handler_sort',
),
'filter' => array(
'handler' => 'views_handler_filter_string',
),
'argument' => array(
'handler' => 'views_handler_argument_string',
),
);
$data['uc_wishlist_products']['purchase'] = array(
'title' => t('product purchase data'),
'help' => t('An array of purchase data for the product.'),
'group' => 'Wishlist products',
'field' => array(
'handler' => 'views_handler_field',
'click sortable' => TRUE,
),
'sort' => array(
'handler' => 'views_handler_sort',
),
'filter' => array(
'handler' => 'views_handler_filter_string',
),
'argument' => array(
'handler' => 'views_handler_argument_string',
),
);
$data['uc_wishlist_products']['changed'] = array(
'title' => t('Change time for product'),
'help' => t('The timestamp of the last change to this wish list product.'),
'group' => 'Wishlist products',
'field' => array(
'handler' => 'views_handler_field_date',
'click sortable' => TRUE,
),
'sort' => array(
'handler' => 'views_handler_sort_date',
),
'filter' => array(
'handler' => 'views_handler_filter_date',
),
);
return $data;
}