function uc_product_views_tables in Ubercart 5

Implementation of hook_views_tables()

See also

uc_views_handler_price

uc_views_handler_weight

uc_product_views_handler_add_to_cart_link

uc_product_views_handler_filter_product

File

uc_product/uc_product.module, line 1040

The product module for Ubercart.

Code

function uc_product_views_tables() {
  $tables['uc_products'] = array(
    'name' => 'uc_products',
    'join' => array(
      'left' => array(
        'table' => 'node',
        'field' => 'vid',
      ),
      'right' => array(
        'field' => 'vid',
      ),
    ),
    'fields' => array(
      'model' => array(
        'name' => t('Product: SKU'),
        'help' => t('Model number'),
        'handler' => 'views_handler_field_nodelink',
        'option' => array(
          '#type' => 'select',
          '#options' => array(
            'link' => 'As link',
            'nolink' => 'Without link',
          ),
        ),
        'sortable' => TRUE,
      ),
      'list_price' => array(
        'name' => t('Product: List price'),
        'help' => t("Manufacturer's suggested price"),
        'handler' => 'uc_views_handler_price',
        'sortable' => TRUE,
      ),
      'cost' => array(
        'name' => t('Product: Cost'),
        'help' => t('Amount to buy the unit'),
        'handler' => 'uc_views_handler_price',
        'sortable' => TRUE,
      ),
      'sell_price' => array(
        'name' => t('Product: Sell price'),
        'help' => t('Amount to sell the unit'),
        'handler' => 'uc_views_handler_price',
        'sortable' => TRUE,
      ),
      'weight' => array(
        'name' => t('Product: Weight'),
        'help' => t('Physical weight'),
        'handler' => 'uc_views_handler_weight',
        'sortable' => TRUE,
      ),
      'addtocartlink' => array(
        'name' => t('Product: Add to cart link'),
        'help' => t("Form to put the product in the customer's cart."),
        'sortable' => FALSE,
        'notafield' => TRUE,
        'handler' => 'uc_product_views_handler_add_to_cart_link',
      ),
      'buyitnowbutton' => array(
        'name' => t('Product: Buy it now button'),
        'help' => t('A button to add a product to the cart without quantity or attribute fields.'),
        'sortable' => FALSE,
        'notafield' => TRUE,
        'handler' => 'uc_product_views_handler_buy_it_now_button',
      ),
    ),
    'sorts' => array(
      'model' => array(
        'name' => t('Product: SKU'),
      ),
      'list_price' => array(
        'name' => t('Product: List price'),
      ),
      'cost' => array(
        'name' => t('Product: Cost'),
      ),
      'sell_price' => array(
        'name' => t('Product: Sell price'),
      ),
      'weight' => array(
        'name' => t('Product: Weight'),
      ),
      'ordering' => array(
        'name' => t('Product: List Order'),
      ),
    ),
    'filters' => array(
      'is_product' => array(
        'name' => t('Product: Is a product'),
        'operator' => array(
          '=' => 'Equals',
        ),
        'list' => 'views_handler_operator_yesno',
        'list-type' => 'select',
        'handler' => 'uc_product_views_handler_filter_product',
        'help' => t('Filter the node based on whether or not it is derived from content type Product.'),
      ),
      'model' => array(
        'name' => t('Product: SKU'),
        'operator' => 'views_handler_operator_like',
        'handler' => 'views_handler_filter_like',
        'help' => t('This filter allows nodes to be filtered by their model number.'),
      ),
      'list_price' => array(
        'name' => t('Product: List Price'),
        'operator' => array(
          '=' => 'Equals',
          '<' => 'Less Than',
          '>' => 'Greater Than',
        ),
        'handler' => 'views_handler_filter_numeric',
        'help' => t('Filter the node based on whether or not it matches list price criteria.'),
      ),
      'cost' => array(
        'name' => t('Product: Cost'),
        'operator' => array(
          '=' => 'Equals',
          '<' => 'Less Than',
          '>' => 'Greater Than',
        ),
        'handler' => 'views_handler_filter_numeric',
        'help' => t('Filter the node based on whether or not it matches cost criteria.'),
      ),
      'sell_price' => array(
        'name' => t('Product: Sell Price'),
        'operator' => array(
          '=' => 'Equals',
          '<' => 'Less Than',
          '>' => 'Greater Than',
        ),
        'handler' => 'views_handler_filter_numeric',
        'help' => t('Filter the node based on whether or not it matches sell price criteria.'),
      ),
      'weight' => array(
        'name' => t('Product: Weight'),
        'operator' => array(
          '=' => 'Equals',
          '<' => 'Less Than',
          '>' => 'Greater Than',
        ),
        'handler' => 'views_handler_filter_numeric',
        'help' => t('Filter the node based on whether or not it matches weight criteria.'),
      ),
    ),
  );
  return $tables;
}