Advertisement
Guest User

Most Purchased Drupal Commerce Products View

a guest
Sep 5th, 2012
268
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 7.30 KB | None | 0 0
  1. $view = new view;
  2. $view->name = 'popular_products';
  3. $view->description = '';
  4. $view->tag = 'default';
  5. $view->base_table = 'commerce_line_item';
  6. $view->human_name = 'popular products';
  7. $view->core = 7;
  8. $view->api_version = '3.0';
  9. $view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */
  10.  
  11. /* Display: Master */
  12. $handler = $view->new_display('default', 'Master', 'default');
  13. $handler->display->display_options['group_by'] = TRUE;
  14. $handler->display->display_options['access']['type'] = 'none';
  15. $handler->display->display_options['cache']['type'] = 'none';
  16. $handler->display->display_options['query']['type'] = 'views_query';
  17. $handler->display->display_options['query']['options']['query_comment'] = FALSE;
  18. $handler->display->display_options['exposed_form']['type'] = 'basic';
  19. $handler->display->display_options['pager']['type'] = 'full';
  20. $handler->display->display_options['style_plugin'] = 'default';
  21. $handler->display->display_options['row_plugin'] = 'fields';
  22. /* Relationship: Commerce Line Item: Order ID */
  23. $handler->display->display_options['relationships']['order_id']['id'] = 'order_id';
  24. $handler->display->display_options['relationships']['order_id']['table'] = 'commerce_line_item';
  25. $handler->display->display_options['relationships']['order_id']['field'] = 'order_id';
  26. $handler->display->display_options['relationships']['order_id']['required'] = 0;
  27. /* Relationship: Commerce Line item: Referenced product */
  28. $handler->display->display_options['relationships']['commerce_product_product_id']['id'] = 'commerce_product_product_id';
  29. $handler->display->display_options['relationships']['commerce_product_product_id']['table'] = 'field_data_commerce_product';
  30. $handler->display->display_options['relationships']['commerce_product_product_id']['field'] = 'commerce_product_product_id';
  31. $handler->display->display_options['relationships']['commerce_product_product_id']['required'] = 0;
  32. /* Field: Commerce Product: Title */
  33. $handler->display->display_options['fields']['title']['id'] = 'title';
  34. $handler->display->display_options['fields']['title']['table'] = 'commerce_product';
  35. $handler->display->display_options['fields']['title']['field'] = 'title';
  36. $handler->display->display_options['fields']['title']['relationship'] = 'commerce_product_product_id';
  37. $handler->display->display_options['fields']['title']['label'] = '';
  38. $handler->display->display_options['fields']['title']['alter']['alter_text'] = 0;
  39. $handler->display->display_options['fields']['title']['alter']['make_link'] = 0;
  40. $handler->display->display_options['fields']['title']['alter']['absolute'] = 0;
  41. $handler->display->display_options['fields']['title']['alter']['external'] = 0;
  42. $handler->display->display_options['fields']['title']['alter']['replace_spaces'] = 0;
  43. $handler->display->display_options['fields']['title']['alter']['trim_whitespace'] = 0;
  44. $handler->display->display_options['fields']['title']['alter']['nl2br'] = 0;
  45. $handler->display->display_options['fields']['title']['alter']['word_boundary'] = 1;
  46. $handler->display->display_options['fields']['title']['alter']['ellipsis'] = 1;
  47. $handler->display->display_options['fields']['title']['alter']['more_link'] = 0;
  48. $handler->display->display_options['fields']['title']['alter']['strip_tags'] = 0;
  49. $handler->display->display_options['fields']['title']['alter']['trim'] = 0;
  50. $handler->display->display_options['fields']['title']['alter']['html'] = 0;
  51. $handler->display->display_options['fields']['title']['element_label_colon'] = FALSE;
  52. $handler->display->display_options['fields']['title']['element_default_classes'] = 1;
  53. $handler->display->display_options['fields']['title']['hide_empty'] = 0;
  54. $handler->display->display_options['fields']['title']['empty_zero'] = 0;
  55. $handler->display->display_options['fields']['title']['hide_alter_empty'] = 1;
  56. $handler->display->display_options['fields']['title']['link_to_product'] = 0;
  57. /* Field: SUM(Commerce Line Item: Line item ID) */
  58. $handler->display->display_options['fields']['line_item_id']['id'] = 'line_item_id';
  59. $handler->display->display_options['fields']['line_item_id']['table'] = 'commerce_line_item';
  60. $handler->display->display_options['fields']['line_item_id']['field'] = 'line_item_id';
  61. $handler->display->display_options['fields']['line_item_id']['group_type'] = 'sum';
  62. $handler->display->display_options['fields']['line_item_id']['label'] = 'Purchased';
  63. $handler->display->display_options['fields']['line_item_id']['alter']['alter_text'] = 0;
  64. $handler->display->display_options['fields']['line_item_id']['alter']['make_link'] = 0;
  65. $handler->display->display_options['fields']['line_item_id']['alter']['absolute'] = 0;
  66. $handler->display->display_options['fields']['line_item_id']['alter']['external'] = 0;
  67. $handler->display->display_options['fields']['line_item_id']['alter']['replace_spaces'] = 0;
  68. $handler->display->display_options['fields']['line_item_id']['alter']['trim_whitespace'] = 0;
  69. $handler->display->display_options['fields']['line_item_id']['alter']['nl2br'] = 0;
  70. $handler->display->display_options['fields']['line_item_id']['alter']['word_boundary'] = 1;
  71. $handler->display->display_options['fields']['line_item_id']['alter']['ellipsis'] = 1;
  72. $handler->display->display_options['fields']['line_item_id']['alter']['more_link'] = 0;
  73. $handler->display->display_options['fields']['line_item_id']['alter']['strip_tags'] = 0;
  74. $handler->display->display_options['fields']['line_item_id']['alter']['trim'] = 0;
  75. $handler->display->display_options['fields']['line_item_id']['alter']['html'] = 0;
  76. $handler->display->display_options['fields']['line_item_id']['element_label_colon'] = 1;
  77. $handler->display->display_options['fields']['line_item_id']['element_default_classes'] = 1;
  78. $handler->display->display_options['fields']['line_item_id']['hide_empty'] = 0;
  79. $handler->display->display_options['fields']['line_item_id']['empty_zero'] = 0;
  80. $handler->display->display_options['fields']['line_item_id']['hide_alter_empty'] = 1;
  81. /* Sort criterion: SUM(Commerce Line Item: Line item ID) */
  82. $handler->display->display_options['sorts']['line_item_id']['id'] = 'line_item_id';
  83. $handler->display->display_options['sorts']['line_item_id']['table'] = 'commerce_line_item';
  84. $handler->display->display_options['sorts']['line_item_id']['field'] = 'line_item_id';
  85. $handler->display->display_options['sorts']['line_item_id']['group_type'] = 'sum';
  86. $handler->display->display_options['sorts']['line_item_id']['order'] = 'DESC';
  87. /* Filter criterion: Commerce Order: Order status */
  88. $handler->display->display_options['filters']['status']['id'] = 'status';
  89. $handler->display->display_options['filters']['status']['table'] = 'commerce_order';
  90. $handler->display->display_options['filters']['status']['field'] = 'status';
  91. $handler->display->display_options['filters']['status']['relationship'] = 'order_id';
  92. $handler->display->display_options['filters']['status']['operator'] = 'not in';
  93. $handler->display->display_options['filters']['status']['value'] = array(
  94.   'canceled' => 'canceled',
  95. );
  96. /* Filter criterion: Commerce Line Item: Type */
  97. $handler->display->display_options['filters']['type']['id'] = 'type';
  98. $handler->display->display_options['filters']['type']['table'] = 'commerce_line_item';
  99. $handler->display->display_options['filters']['type']['field'] = 'type';
  100. $handler->display->display_options['filters']['type']['value'] = array(
  101.   'product' => 'product',
  102. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement