Add a "Last status item" Views relationship to payments [#1533068]

Here is the start of the feature described in the title.
ToDo: We need to create the second relationship with code instead of the one created with the views interface like in the default view. Cause it creates confusion.

Comment	File	Size	Author
#11	payment_1533068_03.patch	27.9 KB	xano
#10	payment_1533068_02.patch	6.68 KB	xano
#8	payment_1533068_01.patch	2.85 KB	xano
	most-recent-status-inside-views.patch	77.55 KB	open social

Comments

Comment #1

open social commented 14 April 2012 at 13:44

Also,
I got strange errors in the payment.module, which you can see in the patch. Can you check what is going on there?

That array is empty in my case.

Comment #2

xano

he/they

English

Southampton

commented 15 April 2012 at 00:12

Thanks a lot for the patch! Can you share the error messages with us, so we can verify them when testing the patch locally?

Comment #3

xano

he/they

English

Southampton

commented 20 April 2012 at 21:47

Status:

Needs review

» Needs work

+++ b/payment/payment.module
--- a/payment/views/PaymentViewsHandlerFieldPaymentStatusTitle.inc
+++ b/payment/views/PaymentViewsHandlerFieldPaymentStatusTitle.inc

+++ b/payment/views/PaymentViewsHandlerFieldPaymentStatusTitle.inc
+++ b/payment/views/PaymentViewsHandlerFieldPaymentStatusTitle.inc
@@ -13,4 +13,21 @@ class PaymentViewsHandlerFieldPaymentStatusTitle extends views_handler_field {

@@ -13,4 +13,21 @@ class PaymentViewsHandlerFieldPaymentStatusTitle extends views_handler_field {
 
     return $status->title;
   }
+
+  /**
+   * Called to add the field to a query.
+   */
+  function query() {
+    $this->ensure_my_table();
+    // Add the field.
+    $params = $this->options['group_type'] != 'group' ? array('function' => $this->options['group_type']) : array();
+    $this->field_alias = $this->query->add_field($this->table_alias, $this->real_field, NULL, $params);
+
+		$this->query->table_queue['payment_status_item_payment_1']['join']->extra = 'payment.pid = payment_status_item_payment_1.pid AND (payment_status_item_payment.created < payment_status_item_payment_1.created OR payment_status_item_payment.created = payment_status_item_payment_1.created AND payment_status_item_payment.psiid < payment_status_item_payment_1.psiid )';
+		$this->query->table_queue['payment_status_item_payment_1']['join']->type = 'LEFT OUTER';		¶
+		$this->query->add_where_expression(0, 'payment_status_item_payment_1.psiid IS NULL');
+
+    $this->add_additional_fields();				
+  }  ¶
+  ¶
 }
diff --git a/payment/views/payment.views_default.inc b/payment/views/payment.views_default.inc

diff --git a/payment/views/payment.views_default.inc b/payment/views/payment.views_default.inc
index 4b9ffca..fcea77a 100644

index 4b9ffca..fcea77a 100644
--- a/payment/views/payment.views_default.inc

--- a/payment/views/payment.views_default.inc
+++ b/payment/views/payment.views_default.inc

+++ b/payment/views/payment.views_default.inc
+++ b/payment/views/payment.views_default.inc
@@ -24,507 +24,515 @@ function payment_views_default_views() {

@@ -24,507 +24,515 @@ function payment_views_default_views() {
  * @return view
  */
 function payment_view_payments() {
-  $view = new view;
-  $view->name = 'payments';
-  $view->description = 'List all payments made using Payment module.';
-  $view->tag = 'payment';
-  $view->base_table = 'payment';
-  $view->human_name = 'Payments';
-  $view->core = 7;
-  $view->api_version = '3.0';
-  $view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */
+$view = new view;
+$view->name = 'payments';
+$view->description = 'List all payments made using Payment module.';
+$view->tag = 'payment';
+$view->base_table = 'payment';
+$view->human_name = 'Payments';
+$view->core = 7;
+$view->api_version = '3.0';
+$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */
 
-  /* Display: Master */
-  $handler = $view->new_display('default', 'Master', 'default');
-  $handler->display->display_options['title'] = 'Payments';
-  $handler->display->display_options['group_by'] = TRUE;
-  $handler->display->display_options['access']['type'] = 'perm';
-  $handler->display->display_options['access']['perm'] = 'payment.view.own';
-  $handler->display->display_options['cache']['type'] = 'none';
-  $handler->display->display_options['query']['type'] = 'views_query';
-  $handler->display->display_options['query']['options']['query_comment'] = FALSE;
-  $handler->display->display_options['exposed_form']['type'] = 'basic';
-  $handler->display->display_options['pager']['type'] = 'full';
-  $handler->display->display_options['pager']['options']['items_per_page'] = '50';
-  $handler->display->display_options['pager']['options']['offset'] = '0';
-  $handler->display->display_options['pager']['options']['id'] = '0';
-  $handler->display->display_options['pager']['options']['expose']['items_per_page_options_all'] = 0;
-  $handler->display->display_options['style_plugin'] = 'table';
-  $handler->display->display_options['style_options']['columns'] = array(
-    'updated' => 'updated',
-    'currency_code' => 'currency_code',
-    'amount' => 'amount',
-    'title_specific' => 'title_specific',
-  );
-  $handler->display->display_options['style_options']['default'] = '-1';
-  $handler->display->display_options['style_options']['info'] = array(
-    'updated' => array(
-      'sortable' => 0,
-      'default_sort_order' => 'asc',
-      'align' => '',
-      'separator' => '',
-      'empty_column' => 0,
-    ),
-    'currency_code' => array(
-      'sortable' => 0,
-      'default_sort_order' => 'asc',
-      'align' => '',
-      'separator' => '',
-      'empty_column' => 0,
-    ),
-    'amount' => array(
-      'sortable' => 0,
-      'default_sort_order' => 'asc',
-      'align' => '',
-      'separator' => '',
-      'empty_column' => 0,
-    ),
-    'title_specific' => array(
-      'sortable' => 0,
-      'default_sort_order' => 'asc',
-      'align' => '',
-      'separator' => '',
-      'empty_column' => 0,
-    ),
-  );
-  $handler->display->display_options['style_options']['override'] = 1;
-  $handler->display->display_options['style_options']['sticky'] = 0;
-  $handler->display->display_options['style_options']['empty_table'] = 1;
-  /* No results behavior: Global: Text area */
-  $handler->display->display_options['empty']['area']['id'] = 'area';
-  $handler->display->display_options['empty']['area']['table'] = 'views';
-  $handler->display->display_options['empty']['area']['field'] = 'area';
-  $handler->display->display_options['empty']['area']['empty'] = FALSE;
-  $handler->display->display_options['empty']['area']['content'] = 'There are no payments yet.';
-  $handler->display->display_options['empty']['area']['format'] = 'filtered_html';
-  $handler->display->display_options['empty']['area']['tokenize'] = 0;
-  /* Relationship: Payment: Payment method */
-  $handler->display->display_options['relationships']['pmid']['id'] = 'pmid';
-  $handler->display->display_options['relationships']['pmid']['table'] = 'payment';
-  $handler->display->display_options['relationships']['pmid']['field'] = 'pmid';
-  $handler->display->display_options['relationships']['pmid']['required'] = 0;
-  /* Relationship: Payment: Line items */
-  $handler->display->display_options['relationships']['pid_line_item']['id'] = 'pid_line_item';
-  $handler->display->display_options['relationships']['pid_line_item']['table'] = 'payment';
-  $handler->display->display_options['relationships']['pid_line_item']['field'] = 'pid_line_item';
-  $handler->display->display_options['relationships']['pid_line_item']['required'] = 0;
-  /* Field: Payment: Last updated date and time */
-  $handler->display->display_options['fields']['updated']['id'] = 'updated';
-  $handler->display->display_options['fields']['updated']['table'] = 'payment';
-  $handler->display->display_options['fields']['updated']['field'] = 'updated';
-  $handler->display->display_options['fields']['updated']['label'] = 'Last updated';
-  $handler->display->display_options['fields']['updated']['alter']['alter_text'] = 0;
-  $handler->display->display_options['fields']['updated']['alter']['make_link'] = 0;
-  $handler->display->display_options['fields']['updated']['alter']['absolute'] = 0;
-  $handler->display->display_options['fields']['updated']['alter']['external'] = 0;
-  $handler->display->display_options['fields']['updated']['alter']['replace_spaces'] = 0;
-  $handler->display->display_options['fields']['updated']['alter']['trim_whitespace'] = 0;
-  $handler->display->display_options['fields']['updated']['alter']['nl2br'] = 0;
-  $handler->display->display_options['fields']['updated']['alter']['word_boundary'] = 1;
-  $handler->display->display_options['fields']['updated']['alter']['ellipsis'] = 1;
-  $handler->display->display_options['fields']['updated']['alter']['strip_tags'] = 0;
-  $handler->display->display_options['fields']['updated']['alter']['trim'] = 0;
-  $handler->display->display_options['fields']['updated']['alter']['html'] = 0;
-  $handler->display->display_options['fields']['updated']['element_label_colon'] = 1;
-  $handler->display->display_options['fields']['updated']['element_default_classes'] = 1;
-  $handler->display->display_options['fields']['updated']['hide_empty'] = 0;
-  $handler->display->display_options['fields']['updated']['empty_zero'] = 0;
-  $handler->display->display_options['fields']['updated']['hide_alter_empty'] = 0;
-  $handler->display->display_options['fields']['updated']['date_format'] = 'long';
-  /* Field: Payment: Currency code */
-  $handler->display->display_options['fields']['currency_code']['id'] = 'currency_code';
-  $handler->display->display_options['fields']['currency_code']['table'] = 'payment';
-  $handler->display->display_options['fields']['currency_code']['field'] = 'currency_code';
-  $handler->display->display_options['fields']['currency_code']['label'] = '';
-  $handler->display->display_options['fields']['currency_code']['exclude'] = TRUE;
-  $handler->display->display_options['fields']['currency_code']['alter']['alter_text'] = 0;
-  $handler->display->display_options['fields']['currency_code']['alter']['make_link'] = 0;
-  $handler->display->display_options['fields']['currency_code']['alter']['absolute'] = 0;
-  $handler->display->display_options['fields']['currency_code']['alter']['external'] = 0;
-  $handler->display->display_options['fields']['currency_code']['alter']['replace_spaces'] = 0;
-  $handler->display->display_options['fields']['currency_code']['alter']['trim_whitespace'] = 0;
-  $handler->display->display_options['fields']['currency_code']['alter']['nl2br'] = 0;
-  $handler->display->display_options['fields']['currency_code']['alter']['word_boundary'] = 1;
-  $handler->display->display_options['fields']['currency_code']['alter']['ellipsis'] = 1;
-  $handler->display->display_options['fields']['currency_code']['alter']['strip_tags'] = 0;
-  $handler->display->display_options['fields']['currency_code']['alter']['trim'] = 0;
-  $handler->display->display_options['fields']['currency_code']['alter']['html'] = 0;
-  $handler->display->display_options['fields']['currency_code']['element_label_colon'] = FALSE;
-  $handler->display->display_options['fields']['currency_code']['element_default_classes'] = 1;
-  $handler->display->display_options['fields']['currency_code']['hide_empty'] = 0;
-  $handler->display->display_options['fields']['currency_code']['empty_zero'] = 0;
-  $handler->display->display_options['fields']['currency_code']['hide_alter_empty'] = 0;
-  /* Field: Broken/missing handler */
-  $handler->display->display_options['fields']['amount']['id'] = 'amount';
-  $handler->display->display_options['fields']['amount']['table'] = 'payment';
-  $handler->display->display_options['fields']['amount']['field'] = 'amount';
-  $handler->display->display_options['fields']['amount']['alter']['alter_text'] = 1;
-  $handler->display->display_options['fields']['amount']['alter']['text'] = '[currency_code] [amount]';
-  $handler->display->display_options['fields']['amount']['alter']['make_link'] = 0;
-  $handler->display->display_options['fields']['amount']['alter']['absolute'] = 0;
-  $handler->display->display_options['fields']['amount']['alter']['external'] = 0;
-  $handler->display->display_options['fields']['amount']['alter']['replace_spaces'] = 0;
-  $handler->display->display_options['fields']['amount']['alter']['trim_whitespace'] = 0;
-  $handler->display->display_options['fields']['amount']['alter']['nl2br'] = 0;
-  $handler->display->display_options['fields']['amount']['alter']['word_boundary'] = 1;
-  $handler->display->display_options['fields']['amount']['alter']['ellipsis'] = 1;
-  $handler->display->display_options['fields']['amount']['alter']['strip_tags'] = 0;
-  $handler->display->display_options['fields']['amount']['alter']['trim'] = 0;
-  $handler->display->display_options['fields']['amount']['alter']['html'] = 0;
-  $handler->display->display_options['fields']['amount']['element_label_colon'] = 1;
-  $handler->display->display_options['fields']['amount']['element_default_classes'] = 1;
-  $handler->display->display_options['fields']['amount']['hide_empty'] = 0;
-  $handler->display->display_options['fields']['amount']['empty_zero'] = 0;
-  $handler->display->display_options['fields']['amount']['hide_alter_empty'] = 0;
-  /* Field: Payment method: Title (specific) */
-  $handler->display->display_options['fields']['title_specific']['id'] = 'title_specific';
-  $handler->display->display_options['fields']['title_specific']['table'] = 'payment_method';
-  $handler->display->display_options['fields']['title_specific']['field'] = 'title_specific';
-  $handler->display->display_options['fields']['title_specific']['relationship'] = 'pmid';
-  $handler->display->display_options['fields']['title_specific']['label'] = 'Payment method';
-  $handler->display->display_options['fields']['title_specific']['alter']['alter_text'] = 0;
-  $handler->display->display_options['fields']['title_specific']['alter']['make_link'] = 0;
-  $handler->display->display_options['fields']['title_specific']['alter']['absolute'] = 0;
-  $handler->display->display_options['fields']['title_specific']['alter']['external'] = 0;
-  $handler->display->display_options['fields']['title_specific']['alter']['replace_spaces'] = 0;
-  $handler->display->display_options['fields']['title_specific']['alter']['trim_whitespace'] = 0;
-  $handler->display->display_options['fields']['title_specific']['alter']['nl2br'] = 0;
-  $handler->display->display_options['fields']['title_specific']['alter']['word_boundary'] = 1;
-  $handler->display->display_options['fields']['title_specific']['alter']['ellipsis'] = 1;
-  $handler->display->display_options['fields']['title_specific']['alter']['strip_tags'] = 0;
-  $handler->display->display_options['fields']['title_specific']['alter']['trim'] = 0;
-  $handler->display->display_options['fields']['title_specific']['alter']['html'] = 0;
-  $handler->display->display_options['fields']['title_specific']['element_label_colon'] = 1;
-  $handler->display->display_options['fields']['title_specific']['element_default_classes'] = 1;
-  $handler->display->display_options['fields']['title_specific']['hide_empty'] = 0;
-  $handler->display->display_options['fields']['title_specific']['empty_zero'] = 0;
-  $handler->display->display_options['fields']['title_specific']['hide_alter_empty'] = 0;
-  /* Field: Payment method: Title (generic) */
-  $handler->display->display_options['fields']['title_generic']['id'] = 'title_generic';
-  $handler->display->display_options['fields']['title_generic']['table'] = 'payment_method';
-  $handler->display->display_options['fields']['title_generic']['field'] = 'title_generic';
-  $handler->display->display_options['fields']['title_generic']['relationship'] = 'pmid';
-  /* Field: Payment: Operations */
-  $handler->display->display_options['fields']['operations']['id'] = 'operations';
-  $handler->display->display_options['fields']['operations']['table'] = 'payment';
-  $handler->display->display_options['fields']['operations']['field'] = 'operations';
-  $handler->display->display_options['fields']['operations']['alter']['alter_text'] = 0;
-  $handler->display->display_options['fields']['operations']['alter']['make_link'] = 0;
-  $handler->display->display_options['fields']['operations']['alter']['absolute'] = 0;
-  $handler->display->display_options['fields']['operations']['alter']['external'] = 0;
-  $handler->display->display_options['fields']['operations']['alter']['replace_spaces'] = 0;
-  $handler->display->display_options['fields']['operations']['alter']['trim_whitespace'] = 0;
-  $handler->display->display_options['fields']['operations']['alter']['nl2br'] = 0;
-  $handler->display->display_options['fields']['operations']['alter']['word_boundary'] = 1;
-  $handler->display->display_options['fields']['operations']['alter']['ellipsis'] = 1;
-  $handler->display->display_options['fields']['operations']['alter']['strip_tags'] = 0;
-  $handler->display->display_options['fields']['operations']['alter']['trim'] = 0;
-  $handler->display->display_options['fields']['operations']['alter']['html'] = 0;
-  $handler->display->display_options['fields']['operations']['element_label_colon'] = 1;
-  $handler->display->display_options['fields']['operations']['element_default_classes'] = 1;
-  $handler->display->display_options['fields']['operations']['hide_empty'] = 0;
-  $handler->display->display_options['fields']['operations']['empty_zero'] = 0;
-  $handler->display->display_options['fields']['operations']['hide_alter_empty'] = 1;
-  /* Sort criterion: Payment: Last updated date and time */
-  $handler->display->display_options['sorts']['updated']['id'] = 'updated';
-  $handler->display->display_options['sorts']['updated']['table'] = 'payment';
-  $handler->display->display_options['sorts']['updated']['field'] = 'updated';
-  $handler->display->display_options['sorts']['updated']['order'] = 'DESC';
+/* Display: Master */
+$handler = $view->new_display('default', 'Master', 'default');
+$handler->display->display_options['title'] = 'Payments';
+$handler->display->display_options['group_by'] = TRUE;
+$handler->display->display_options['access']['type'] = 'perm';
+$handler->display->display_options['access']['perm'] = 'payment.view.own';
+$handler->display->display_options['cache']['type'] = 'none';
+$handler->display->display_options['query']['type'] = 'views_query';
+$handler->display->display_options['query']['options']['query_comment'] = FALSE;
+$handler->display->display_options['exposed_form']['type'] = 'basic';
+$handler->display->display_options['pager']['type'] = 'full';
+$handler->display->display_options['pager']['options']['items_per_page'] = '50';
+$handler->display->display_options['pager']['options']['offset'] = '0';
+$handler->display->display_options['pager']['options']['id'] = '0';
+$handler->display->display_options['pager']['options']['expose']['items_per_page_options_all'] = 0;
+$handler->display->display_options['style_plugin'] = 'table';
+$handler->display->display_options['style_options']['columns'] = array(
+  'updated' => 'updated',
+  'currency_code' => 'currency_code',
+  'amount' => 'amount',
+  'title_specific' => 'title_specific',
+);
+$handler->display->display_options['style_options']['default'] = '-1';
+$handler->display->display_options['style_options']['info'] = array(
+  'updated' => array(
+    'sortable' => 0,
+    'default_sort_order' => 'asc',
+    'align' => '',
+    'separator' => '',
+    'empty_column' => 0,
+  ),
+  'currency_code' => array(
+    'sortable' => 0,
+    'default_sort_order' => 'asc',
+    'align' => '',
+    'separator' => '',
+    'empty_column' => 0,
+  ),
+  'amount' => array(
+    'sortable' => 0,
+    'default_sort_order' => 'asc',
+    'align' => '',
+    'separator' => '',
+    'empty_column' => 0,
+  ),
+  'title_specific' => array(
+    'sortable' => 0,
+    'default_sort_order' => 'asc',
+    'align' => '',
+    'separator' => '',
+    'empty_column' => 0,
+  ),
+);
+$handler->display->display_options['style_options']['override'] = 1;
+$handler->display->display_options['style_options']['sticky'] = 0;
+$handler->display->display_options['style_options']['empty_table'] = 1;
+/* No results behavior: Global: Text area */
+$handler->display->display_options['empty']['area']['id'] = 'area';
+$handler->display->display_options['empty']['area']['table'] = 'views';
+$handler->display->display_options['empty']['area']['field'] = 'area';
+$handler->display->display_options['empty']['area']['empty'] = FALSE;
+$handler->display->display_options['empty']['area']['content'] = 'There are no payments yet.';
+$handler->display->display_options['empty']['area']['format'] = 'filtered_html';
+$handler->display->display_options['empty']['area']['tokenize'] = 0;
+/* Relationship: Payment: Payment method */
+$handler->display->display_options['relationships']['pmid']['id'] = 'pmid';
+$handler->display->display_options['relationships']['pmid']['table'] = 'payment';
+$handler->display->display_options['relationships']['pmid']['field'] = 'pmid';
+$handler->display->display_options['relationships']['pmid']['required'] = 0;
+/* Relationship: Payment: Line items */
+$handler->display->display_options['relationships']['pid_line_item']['id'] = 'pid_line_item';
+$handler->display->display_options['relationships']['pid_line_item']['table'] = 'payment';
+$handler->display->display_options['relationships']['pid_line_item']['field'] = 'pid_line_item';
+$handler->display->display_options['relationships']['pid_line_item']['required'] = 0;
+/* Relationship: Payment: Status items */
+$handler->display->display_options['relationships']['pid_1']['id'] = 'pid_1';
+$handler->display->display_options['relationships']['pid_1']['table'] = 'payment';
+$handler->display->display_options['relationships']['pid_1']['field'] = 'pid';
+$handler->display->display_options['relationships']['pid_1']['required'] = 0;
+/* Relationship: Payment: Status items */
+$handler->display->display_options['relationships']['pid']['id'] = 'pid';
+$handler->display->display_options['relationships']['pid']['table'] = 'payment';
+$handler->display->display_options['relationships']['pid']['field'] = 'pid';
+$handler->display->display_options['relationships']['pid']['required'] = 0;
+/* Field: Payment: Last updated date and time */
+$handler->display->display_options['fields']['updated']['id'] = 'updated';
+$handler->display->display_options['fields']['updated']['table'] = 'payment';
+$handler->display->display_options['fields']['updated']['field'] = 'updated';
+$handler->display->display_options['fields']['updated']['label'] = 'Last updated';
+$handler->display->display_options['fields']['updated']['alter']['alter_text'] = 0;
+$handler->display->display_options['fields']['updated']['alter']['make_link'] = 0;
+$handler->display->display_options['fields']['updated']['alter']['absolute'] = 0;
+$handler->display->display_options['fields']['updated']['alter']['external'] = 0;
+$handler->display->display_options['fields']['updated']['alter']['replace_spaces'] = 0;
+$handler->display->display_options['fields']['updated']['alter']['trim_whitespace'] = 0;
+$handler->display->display_options['fields']['updated']['alter']['nl2br'] = 0;
+$handler->display->display_options['fields']['updated']['alter']['word_boundary'] = 1;
+$handler->display->display_options['fields']['updated']['alter']['ellipsis'] = 1;
+$handler->display->display_options['fields']['updated']['alter']['strip_tags'] = 0;
+$handler->display->display_options['fields']['updated']['alter']['trim'] = 0;
+$handler->display->display_options['fields']['updated']['alter']['html'] = 0;
+$handler->display->display_options['fields']['updated']['element_label_colon'] = 1;
+$handler->display->display_options['fields']['updated']['element_default_classes'] = 1;
+$handler->display->display_options['fields']['updated']['hide_empty'] = 0;
+$handler->display->display_options['fields']['updated']['empty_zero'] = 0;
+$handler->display->display_options['fields']['updated']['hide_alter_empty'] = 0;
+$handler->display->display_options['fields']['updated']['date_format'] = 'long';
+/* Field: Payment: Currency code */
+$handler->display->display_options['fields']['currency_code']['id'] = 'currency_code';
+$handler->display->display_options['fields']['currency_code']['table'] = 'payment';
+$handler->display->display_options['fields']['currency_code']['field'] = 'currency_code';
+$handler->display->display_options['fields']['currency_code']['label'] = '';
+$handler->display->display_options['fields']['currency_code']['exclude'] = TRUE;
+$handler->display->display_options['fields']['currency_code']['alter']['alter_text'] = 0;
+$handler->display->display_options['fields']['currency_code']['alter']['make_link'] = 0;
+$handler->display->display_options['fields']['currency_code']['alter']['absolute'] = 0;
+$handler->display->display_options['fields']['currency_code']['alter']['external'] = 0;
+$handler->display->display_options['fields']['currency_code']['alter']['replace_spaces'] = 0;
+$handler->display->display_options['fields']['currency_code']['alter']['trim_whitespace'] = 0;
+$handler->display->display_options['fields']['currency_code']['alter']['nl2br'] = 0;
+$handler->display->display_options['fields']['currency_code']['alter']['word_boundary'] = 1;
+$handler->display->display_options['fields']['currency_code']['alter']['ellipsis'] = 1;
+$handler->display->display_options['fields']['currency_code']['alter']['strip_tags'] = 0;
+$handler->display->display_options['fields']['currency_code']['alter']['trim'] = 0;
+$handler->display->display_options['fields']['currency_code']['alter']['html'] = 0;
+$handler->display->display_options['fields']['currency_code']['element_label_colon'] = FALSE;
+$handler->display->display_options['fields']['currency_code']['element_default_classes'] = 1;
+$handler->display->display_options['fields']['currency_code']['hide_empty'] = 0;
+$handler->display->display_options['fields']['currency_code']['empty_zero'] = 0;
+$handler->display->display_options['fields']['currency_code']['hide_alter_empty'] = 0;
+/* Field: Broken/missing handler */
+$handler->display->display_options['fields']['amount']['id'] = 'amount';
+$handler->display->display_options['fields']['amount']['table'] = 'payment';
+$handler->display->display_options['fields']['amount']['field'] = 'amount';
+$handler->display->display_options['fields']['amount']['alter']['alter_text'] = 1;
+$handler->display->display_options['fields']['amount']['alter']['text'] = '[currency_code] [amount]';
+$handler->display->display_options['fields']['amount']['alter']['make_link'] = 0;
+$handler->display->display_options['fields']['amount']['alter']['absolute'] = 0;
+$handler->display->display_options['fields']['amount']['alter']['external'] = 0;
+$handler->display->display_options['fields']['amount']['alter']['replace_spaces'] = 0;
+$handler->display->display_options['fields']['amount']['alter']['trim_whitespace'] = 0;
+$handler->display->display_options['fields']['amount']['alter']['nl2br'] = 0;
+$handler->display->display_options['fields']['amount']['alter']['word_boundary'] = 1;
+$handler->display->display_options['fields']['amount']['alter']['ellipsis'] = 1;
+$handler->display->display_options['fields']['amount']['alter']['strip_tags'] = 0;
+$handler->display->display_options['fields']['amount']['alter']['trim'] = 0;
+$handler->display->display_options['fields']['amount']['alter']['html'] = 0;
+$handler->display->display_options['fields']['amount']['element_label_colon'] = 1;
+$handler->display->display_options['fields']['amount']['element_default_classes'] = 1;
+$handler->display->display_options['fields']['amount']['hide_empty'] = 0;
+$handler->display->display_options['fields']['amount']['empty_zero'] = 0;
+$handler->display->display_options['fields']['amount']['hide_alter_empty'] = 0;
+/* Field: Payment method: Title (specific) */
+$handler->display->display_options['fields']['title_specific']['id'] = 'title_specific';
+$handler->display->display_options['fields']['title_specific']['table'] = 'payment_method';
+$handler->display->display_options['fields']['title_specific']['field'] = 'title_specific';
+$handler->display->display_options['fields']['title_specific']['relationship'] = 'pmid';
+$handler->display->display_options['fields']['title_specific']['label'] = 'Payment method';
+$handler->display->display_options['fields']['title_specific']['alter']['alter_text'] = 0;
+$handler->display->display_options['fields']['title_specific']['alter']['make_link'] = 0;
+$handler->display->display_options['fields']['title_specific']['alter']['absolute'] = 0;
+$handler->display->display_options['fields']['title_specific']['alter']['external'] = 0;
+$handler->display->display_options['fields']['title_specific']['alter']['replace_spaces'] = 0;
+$handler->display->display_options['fields']['title_specific']['alter']['trim_whitespace'] = 0;
+$handler->display->display_options['fields']['title_specific']['alter']['nl2br'] = 0;
+$handler->display->display_options['fields']['title_specific']['alter']['word_boundary'] = 1;
+$handler->display->display_options['fields']['title_specific']['alter']['ellipsis'] = 1;
+$handler->display->display_options['fields']['title_specific']['alter']['strip_tags'] = 0;
+$handler->display->display_options['fields']['title_specific']['alter']['trim'] = 0;
+$handler->display->display_options['fields']['title_specific']['alter']['html'] = 0;
+$handler->display->display_options['fields']['title_specific']['element_label_colon'] = 1;
+$handler->display->display_options['fields']['title_specific']['element_default_classes'] = 1;
+$handler->display->display_options['fields']['title_specific']['hide_empty'] = 0;
+$handler->display->display_options['fields']['title_specific']['empty_zero'] = 0;
+$handler->display->display_options['fields']['title_specific']['hide_alter_empty'] = 0;
+/* Field: Payment method: Title (generic) */
+$handler->display->display_options['fields']['title_generic']['id'] = 'title_generic';
+$handler->display->display_options['fields']['title_generic']['table'] = 'payment_method';
+$handler->display->display_options['fields']['title_generic']['field'] = 'title_generic';
+$handler->display->display_options['fields']['title_generic']['relationship'] = 'pmid';
+/* Field: Payment: Operations */
+$handler->display->display_options['fields']['operations']['id'] = 'operations';
+$handler->display->display_options['fields']['operations']['table'] = 'payment';
+$handler->display->display_options['fields']['operations']['field'] = 'operations';
+$handler->display->display_options['fields']['operations']['alter']['alter_text'] = 0;
+$handler->display->display_options['fields']['operations']['alter']['make_link'] = 0;
+$handler->display->display_options['fields']['operations']['alter']['absolute'] = 0;
+$handler->display->display_options['fields']['operations']['alter']['external'] = 0;
+$handler->display->display_options['fields']['operations']['alter']['replace_spaces'] = 0;
+$handler->display->display_options['fields']['operations']['alter']['trim_whitespace'] = 0;
+$handler->display->display_options['fields']['operations']['alter']['nl2br'] = 0;
+$handler->display->display_options['fields']['operations']['alter']['word_boundary'] = 1;
+$handler->display->display_options['fields']['operations']['alter']['ellipsis'] = 1;
+$handler->display->display_options['fields']['operations']['alter']['strip_tags'] = 0;
+$handler->display->display_options['fields']['operations']['alter']['trim'] = 0;
+$handler->display->display_options['fields']['operations']['alter']['html'] = 0;
+$handler->display->display_options['fields']['operations']['element_label_colon'] = 1;
+$handler->display->display_options['fields']['operations']['element_default_classes'] = 1;
+$handler->display->display_options['fields']['operations']['hide_empty'] = 0;
+$handler->display->display_options['fields']['operations']['empty_zero'] = 0;
+$handler->display->display_options['fields']['operations']['hide_alter_empty'] = 1;
+/* Sort criterion: Payment: Last updated date and time */
+$handler->display->display_options['sorts']['updated']['id'] = 'updated';
+$handler->display->display_options['sorts']['updated']['table'] = 'payment';
+$handler->display->display_options['sorts']['updated']['field'] = 'updated';
+$handler->display->display_options['sorts']['updated']['order'] = 'DESC';
 
-  /* Display: Administration page */
-  $handler = $view->new_display('page', 'Administration page', 'page_1');
-  $handler->display->display_options['defaults']['access'] = FALSE;
-  $handler->display->display_options['access']['type'] = 'perm';
-  $handler->display->display_options['access']['perm'] = 'payment.view.any';
-  $handler->display->display_options['defaults']['fields'] = FALSE;
-  /* Field: Payment: Last updated date and time */
-  $handler->display->display_options['fields']['updated']['id'] = 'updated';
-  $handler->display->display_options['fields']['updated']['table'] = 'payment';
-  $handler->display->display_options['fields']['updated']['field'] = 'updated';
-  $handler->display->display_options['fields']['updated']['label'] = 'Last updated';
-  $handler->display->display_options['fields']['updated']['alter']['alter_text'] = 0;
-  $handler->display->display_options['fields']['updated']['alter']['make_link'] = 0;
-  $handler->display->display_options['fields']['updated']['alter']['absolute'] = 0;
-  $handler->display->display_options['fields']['updated']['alter']['external'] = 0;
-  $handler->display->display_options['fields']['updated']['alter']['replace_spaces'] = 0;
-  $handler->display->display_options['fields']['updated']['alter']['trim_whitespace'] = 0;
-  $handler->display->display_options['fields']['updated']['alter']['nl2br'] = 0;
-  $handler->display->display_options['fields']['updated']['alter']['word_boundary'] = 1;
-  $handler->display->display_options['fields']['updated']['alter']['ellipsis'] = 1;
-  $handler->display->display_options['fields']['updated']['alter']['strip_tags'] = 0;
-  $handler->display->display_options['fields']['updated']['alter']['trim'] = 0;
-  $handler->display->display_options['fields']['updated']['alter']['html'] = 0;
-  $handler->display->display_options['fields']['updated']['element_label_colon'] = 1;
-  $handler->display->display_options['fields']['updated']['element_default_classes'] = 1;
-  $handler->display->display_options['fields']['updated']['hide_empty'] = 0;
-  $handler->display->display_options['fields']['updated']['empty_zero'] = 0;
-  $handler->display->display_options['fields']['updated']['hide_alter_empty'] = 0;
-  $handler->display->display_options['fields']['updated']['date_format'] = 'long';
-  /* Field: Payment: Currency code */
-  $handler->display->display_options['fields']['currency_code']['id'] = 'currency_code';
-  $handler->display->display_options['fields']['currency_code']['table'] = 'payment';
-  $handler->display->display_options['fields']['currency_code']['field'] = 'currency_code';
-  $handler->display->display_options['fields']['currency_code']['label'] = '';
-  $handler->display->display_options['fields']['currency_code']['exclude'] = TRUE;
-  $handler->display->display_options['fields']['currency_code']['alter']['alter_text'] = 0;
-  $handler->display->display_options['fields']['currency_code']['alter']['make_link'] = 0;
-  $handler->display->display_options['fields']['currency_code']['alter']['absolute'] = 0;
-  $handler->display->display_options['fields']['currency_code']['alter']['external'] = 0;
-  $handler->display->display_options['fields']['currency_code']['alter']['replace_spaces'] = 0;
-  $handler->display->display_options['fields']['currency_code']['alter']['trim_whitespace'] = 0;
-  $handler->display->display_options['fields']['currency_code']['alter']['nl2br'] = 0;
-  $handler->display->display_options['fields']['currency_code']['alter']['word_boundary'] = 1;
-  $handler->display->display_options['fields']['currency_code']['alter']['ellipsis'] = 1;
-  $handler->display->display_options['fields']['currency_code']['alter']['strip_tags'] = 0;
-  $handler->display->display_options['fields']['currency_code']['alter']['trim'] = 0;
-  $handler->display->display_options['fields']['currency_code']['alter']['html'] = 0;
-  $handler->display->display_options['fields']['currency_code']['element_label_colon'] = FALSE;
-  $handler->display->display_options['fields']['currency_code']['element_default_classes'] = 1;
-  $handler->display->display_options['fields']['currency_code']['hide_empty'] = 0;
-  $handler->display->display_options['fields']['currency_code']['empty_zero'] = 0;
-  $handler->display->display_options['fields']['currency_code']['hide_alter_empty'] = 0;
-  /* Field: SUM(Payment line item: Total amount) */
-  $handler->display->display_options['fields']['amount_total']['id'] = 'amount_total';
-  $handler->display->display_options['fields']['amount_total']['table'] = 'payment_line_item';
-  $handler->display->display_options['fields']['amount_total']['field'] = 'amount_total';
-  $handler->display->display_options['fields']['amount_total']['relationship'] = 'pid_line_item';
-  $handler->display->display_options['fields']['amount_total']['group_type'] = 'sum';
-  $handler->display->display_options['fields']['amount_total']['label'] = 'Amount';
-  $handler->display->display_options['fields']['amount_total']['alter']['alter_text'] = 1;
-  $handler->display->display_options['fields']['amount_total']['alter']['text'] = '[currency_code] [amount_total]';
-  $handler->display->display_options['fields']['amount_total']['alter']['make_link'] = 0;
-  $handler->display->display_options['fields']['amount_total']['alter']['absolute'] = 0;
-  $handler->display->display_options['fields']['amount_total']['alter']['external'] = 0;
-  $handler->display->display_options['fields']['amount_total']['alter']['replace_spaces'] = 0;
-  $handler->display->display_options['fields']['amount_total']['alter']['trim_whitespace'] = 0;
-  $handler->display->display_options['fields']['amount_total']['alter']['nl2br'] = 0;
-  $handler->display->display_options['fields']['amount_total']['alter']['word_boundary'] = 1;
-  $handler->display->display_options['fields']['amount_total']['alter']['ellipsis'] = 1;
-  $handler->display->display_options['fields']['amount_total']['alter']['more_link'] = 0;
-  $handler->display->display_options['fields']['amount_total']['alter']['strip_tags'] = 0;
-  $handler->display->display_options['fields']['amount_total']['alter']['trim'] = 0;
-  $handler->display->display_options['fields']['amount_total']['alter']['html'] = 0;
-  $handler->display->display_options['fields']['amount_total']['element_label_colon'] = 1;
-  $handler->display->display_options['fields']['amount_total']['element_default_classes'] = 1;
-  $handler->display->display_options['fields']['amount_total']['hide_empty'] = 0;
-  $handler->display->display_options['fields']['amount_total']['empty_zero'] = 0;
-  $handler->display->display_options['fields']['amount_total']['hide_alter_empty'] = 1;
-  /* Field: Payment method: Title (specific) */
-  $handler->display->display_options['fields']['title_specific']['id'] = 'title_specific';
-  $handler->display->display_options['fields']['title_specific']['table'] = 'payment_method';
-  $handler->display->display_options['fields']['title_specific']['field'] = 'title_specific';
-  $handler->display->display_options['fields']['title_specific']['relationship'] = 'pmid';
-  $handler->display->display_options['fields']['title_specific']['label'] = 'Payment method';
-  $handler->display->display_options['fields']['title_specific']['alter']['alter_text'] = 0;
-  $handler->display->display_options['fields']['title_specific']['alter']['make_link'] = 0;
-  $handler->display->display_options['fields']['title_specific']['alter']['absolute'] = 0;
-  $handler->display->display_options['fields']['title_specific']['alter']['external'] = 0;
-  $handler->display->display_options['fields']['title_specific']['alter']['replace_spaces'] = 0;
-  $handler->display->display_options['fields']['title_specific']['alter']['trim_whitespace'] = 0;
-  $handler->display->display_options['fields']['title_specific']['alter']['nl2br'] = 0;
-  $handler->display->display_options['fields']['title_specific']['alter']['word_boundary'] = 1;
-  $handler->display->display_options['fields']['title_specific']['alter']['ellipsis'] = 1;
-  $handler->display->display_options['fields']['title_specific']['alter']['strip_tags'] = 0;
-  $handler->display->display_options['fields']['title_specific']['alter']['trim'] = 0;
-  $handler->display->display_options['fields']['title_specific']['alter']['html'] = 0;
-  $handler->display->display_options['fields']['title_specific']['element_label_colon'] = 1;
-  $handler->display->display_options['fields']['title_specific']['element_default_classes'] = 1;
-  $handler->display->display_options['fields']['title_specific']['hide_empty'] = 0;
-  $handler->display->display_options['fields']['title_specific']['empty_zero'] = 0;
-  $handler->display->display_options['fields']['title_specific']['hide_alter_empty'] = 0;
-  /* Field: Payment: Operations */
-  $handler->display->display_options['fields']['operations']['id'] = 'operations';
-  $handler->display->display_options['fields']['operations']['table'] = 'payment';
-  $handler->display->display_options['fields']['operations']['field'] = 'operations';
-  $handler->display->display_options['fields']['operations']['alter']['alter_text'] = 0;
-  $handler->display->display_options['fields']['operations']['alter']['make_link'] = 0;
-  $handler->display->display_options['fields']['operations']['alter']['absolute'] = 0;
-  $handler->display->display_options['fields']['operations']['alter']['external'] = 0;
-  $handler->display->display_options['fields']['operations']['alter']['replace_spaces'] = 0;
-  $handler->display->display_options['fields']['operations']['alter']['trim_whitespace'] = 0;
-  $handler->display->display_options['fields']['operations']['alter']['nl2br'] = 0;
-  $handler->display->display_options['fields']['operations']['alter']['word_boundary'] = 1;
-  $handler->display->display_options['fields']['operations']['alter']['ellipsis'] = 1;
-  $handler->display->display_options['fields']['operations']['alter']['strip_tags'] = 0;
-  $handler->display->display_options['fields']['operations']['alter']['trim'] = 0;
-  $handler->display->display_options['fields']['operations']['alter']['html'] = 0;
-  $handler->display->display_options['fields']['operations']['element_label_colon'] = 1;
-  $handler->display->display_options['fields']['operations']['element_default_classes'] = 1;
-  $handler->display->display_options['fields']['operations']['hide_empty'] = 0;
-  $handler->display->display_options['fields']['operations']['empty_zero'] = 0;
-  $handler->display->display_options['fields']['operations']['hide_alter_empty'] = 1;
-  $handler->display->display_options['path'] = 'admin/content/payment';
-  $handler->display->display_options['menu']['type'] = 'normal';
-  $handler->display->display_options['menu']['title'] = 'Payments';
-  $handler->display->display_options['menu']['weight'] = '0';
-  $handler->display->display_options['menu']['name'] = 'management';
+/* Display: Administration page */
+$handler = $view->new_display('page', 'Administration page', 'page_1');
+$handler->display->display_options['defaults']['access'] = FALSE;
+$handler->display->display_options['access']['type'] = 'perm';
+$handler->display->display_options['access']['perm'] = 'payment.view.any';
+$handler->display->display_options['defaults']['fields'] = FALSE;
+/* Field: Payment: Last updated date and time */
+$handler->display->display_options['fields']['updated']['id'] = 'updated';
+$handler->display->display_options['fields']['updated']['table'] = 'payment';
+$handler->display->display_options['fields']['updated']['field'] = 'updated';
+$handler->display->display_options['fields']['updated']['label'] = 'Last updated';
+$handler->display->display_options['fields']['updated']['alter']['alter_text'] = 0;
+$handler->display->display_options['fields']['updated']['alter']['make_link'] = 0;
+$handler->display->display_options['fields']['updated']['alter']['absolute'] = 0;
+$handler->display->display_options['fields']['updated']['alter']['external'] = 0;
+$handler->display->display_options['fields']['updated']['alter']['replace_spaces'] = 0;
+$handler->display->display_options['fields']['updated']['alter']['trim_whitespace'] = 0;
+$handler->display->display_options['fields']['updated']['alter']['nl2br'] = 0;
+$handler->display->display_options['fields']['updated']['alter']['word_boundary'] = 1;
+$handler->display->display_options['fields']['updated']['alter']['ellipsis'] = 1;
+$handler->display->display_options['fields']['updated']['alter']['strip_tags'] = 0;
+$handler->display->display_options['fields']['updated']['alter']['trim'] = 0;
+$handler->display->display_options['fields']['updated']['alter']['html'] = 0;
+$handler->display->display_options['fields']['updated']['element_label_colon'] = 1;
+$handler->display->display_options['fields']['updated']['element_default_classes'] = 1;
+$handler->display->display_options['fields']['updated']['hide_empty'] = 0;
+$handler->display->display_options['fields']['updated']['empty_zero'] = 0;
+$handler->display->display_options['fields']['updated']['hide_alter_empty'] = 0;
+$handler->display->display_options['fields']['updated']['date_format'] = 'long';
+/* Field: Payment: Currency code */
+$handler->display->display_options['fields']['currency_code']['id'] = 'currency_code';
+$handler->display->display_options['fields']['currency_code']['table'] = 'payment';
+$handler->display->display_options['fields']['currency_code']['field'] = 'currency_code';
+$handler->display->display_options['fields']['currency_code']['label'] = '';
+$handler->display->display_options['fields']['currency_code']['exclude'] = TRUE;
+$handler->display->display_options['fields']['currency_code']['alter']['alter_text'] = 0;
+$handler->display->display_options['fields']['currency_code']['alter']['make_link'] = 0;
+$handler->display->display_options['fields']['currency_code']['alter']['absolute'] = 0;
+$handler->display->display_options['fields']['currency_code']['alter']['external'] = 0;
+$handler->display->display_options['fields']['currency_code']['alter']['replace_spaces'] = 0;
+$handler->display->display_options['fields']['currency_code']['alter']['trim_whitespace'] = 0;
+$handler->display->display_options['fields']['currency_code']['alter']['nl2br'] = 0;
+$handler->display->display_options['fields']['currency_code']['alter']['word_boundary'] = 1;
+$handler->display->display_options['fields']['currency_code']['alter']['ellipsis'] = 1;
+$handler->display->display_options['fields']['currency_code']['alter']['strip_tags'] = 0;
+$handler->display->display_options['fields']['currency_code']['alter']['trim'] = 0;
+$handler->display->display_options['fields']['currency_code']['alter']['html'] = 0;
+$handler->display->display_options['fields']['currency_code']['element_label_colon'] = FALSE;
+$handler->display->display_options['fields']['currency_code']['element_default_classes'] = 1;
+$handler->display->display_options['fields']['currency_code']['hide_empty'] = 0;
+$handler->display->display_options['fields']['currency_code']['empty_zero'] = 0;
+$handler->display->display_options['fields']['currency_code']['hide_alter_empty'] = 0;
+/* Field: SUM(Payment line item: Total amount) */
+$handler->display->display_options['fields']['amount_total']['id'] = 'amount_total';
+$handler->display->display_options['fields']['amount_total']['table'] = 'payment_line_item';
+$handler->display->display_options['fields']['amount_total']['field'] = 'amount_total';
+$handler->display->display_options['fields']['amount_total']['relationship'] = 'pid_line_item';
+$handler->display->display_options['fields']['amount_total']['group_type'] = 'sum';
+$handler->display->display_options['fields']['amount_total']['label'] = 'Amount';
+$handler->display->display_options['fields']['amount_total']['alter']['alter_text'] = 1;
+$handler->display->display_options['fields']['amount_total']['alter']['text'] = '[currency_code] [amount_total]';
+$handler->display->display_options['fields']['amount_total']['alter']['make_link'] = 0;
+$handler->display->display_options['fields']['amount_total']['alter']['absolute'] = 0;
+$handler->display->display_options['fields']['amount_total']['alter']['external'] = 0;
+$handler->display->display_options['fields']['amount_total']['alter']['replace_spaces'] = 0;
+$handler->display->display_options['fields']['amount_total']['alter']['trim_whitespace'] = 0;
+$handler->display->display_options['fields']['amount_total']['alter']['nl2br'] = 0;
+$handler->display->display_options['fields']['amount_total']['alter']['word_boundary'] = 1;
+$handler->display->display_options['fields']['amount_total']['alter']['ellipsis'] = 1;
+$handler->display->display_options['fields']['amount_total']['alter']['more_link'] = 0;
+$handler->display->display_options['fields']['amount_total']['alter']['strip_tags'] = 0;
+$handler->display->display_options['fields']['amount_total']['alter']['trim'] = 0;
+$handler->display->display_options['fields']['amount_total']['alter']['html'] = 0;
+$handler->display->display_options['fields']['amount_total']['element_label_colon'] = 1;
+$handler->display->display_options['fields']['amount_total']['element_default_classes'] = 1;
+$handler->display->display_options['fields']['amount_total']['hide_empty'] = 0;
+$handler->display->display_options['fields']['amount_total']['empty_zero'] = 0;
+$handler->display->display_options['fields']['amount_total']['hide_alter_empty'] = 1;
+/* Field: Payment method: Title (specific) */
+$handler->display->display_options['fields']['title_specific']['id'] = 'title_specific';
+$handler->display->display_options['fields']['title_specific']['table'] = 'payment_method';
+$handler->display->display_options['fields']['title_specific']['field'] = 'title_specific';
+$handler->display->display_options['fields']['title_specific']['relationship'] = 'pmid';
+$handler->display->display_options['fields']['title_specific']['label'] = 'Payment method';
+$handler->display->display_options['fields']['title_specific']['alter']['alter_text'] = 0;
+$handler->display->display_options['fields']['title_specific']['alter']['make_link'] = 0;
+$handler->display->display_options['fields']['title_specific']['alter']['absolute'] = 0;
+$handler->display->display_options['fields']['title_specific']['alter']['external'] = 0;
+$handler->display->display_options['fields']['title_specific']['alter']['replace_spaces'] = 0;
+$handler->display->display_options['fields']['title_specific']['alter']['trim_whitespace'] = 0;
+$handler->display->display_options['fields']['title_specific']['alter']['nl2br'] = 0;
+$handler->display->display_options['fields']['title_specific']['alter']['word_boundary'] = 1;
+$handler->display->display_options['fields']['title_specific']['alter']['ellipsis'] = 1;
+$handler->display->display_options['fields']['title_specific']['alter']['strip_tags'] = 0;
+$handler->display->display_options['fields']['title_specific']['alter']['trim'] = 0;
+$handler->display->display_options['fields']['title_specific']['alter']['html'] = 0;
+$handler->display->display_options['fields']['title_specific']['element_label_colon'] = 1;
+$handler->display->display_options['fields']['title_specific']['element_default_classes'] = 1;
+$handler->display->display_options['fields']['title_specific']['hide_empty'] = 0;
+$handler->display->display_options['fields']['title_specific']['empty_zero'] = 0;
+$handler->display->display_options['fields']['title_specific']['hide_alter_empty'] = 0;
+/* Field: Payment: Operations */
+$handler->display->display_options['fields']['operations']['id'] = 'operations';
+$handler->display->display_options['fields']['operations']['table'] = 'payment';
+$handler->display->display_options['fields']['operations']['field'] = 'operations';
+$handler->display->display_options['fields']['operations']['alter']['alter_text'] = 0;
+$handler->display->display_options['fields']['operations']['alter']['make_link'] = 0;
+$handler->display->display_options['fields']['operations']['alter']['absolute'] = 0;
+$handler->display->display_options['fields']['operations']['alter']['external'] = 0;
+$handler->display->display_options['fields']['operations']['alter']['replace_spaces'] = 0;
+$handler->display->display_options['fields']['operations']['alter']['trim_whitespace'] = 0;
+$handler->display->display_options['fields']['operations']['alter']['nl2br'] = 0;
+$handler->display->display_options['fields']['operations']['alter']['word_boundary'] = 1;
+$handler->display->display_options['fields']['operations']['alter']['ellipsis'] = 1;
+$handler->display->display_options['fields']['operations']['alter']['strip_tags'] = 0;
+$handler->display->display_options['fields']['operations']['alter']['trim'] = 0;
+$handler->display->display_options['fields']['operations']['alter']['html'] = 0;
+$handler->display->display_options['fields']['operations']['element_label_colon'] = 1;
+$handler->display->display_options['fields']['operations']['element_default_classes'] = 1;
+$handler->display->display_options['fields']['operations']['hide_empty'] = 0;
+$handler->display->display_options['fields']['operations']['empty_zero'] = 0;
+$handler->display->display_options['fields']['operations']['hide_alter_empty'] = 1;
+/* Field: Payment status item: Status title */
+$handler->display->display_options['fields']['title']['id'] = 'title';
+$handler->display->display_options['fields']['title']['table'] = 'payment_status_item';
+$handler->display->display_options['fields']['title']['field'] = 'title';
+$handler->display->display_options['fields']['title']['relationship'] = 'pid_1';
+$handler->display->display_options['fields']['title']['alter']['alter_text'] = 0;
+$handler->display->display_options['fields']['title']['alter']['make_link'] = 0;
+$handler->display->display_options['fields']['title']['alter']['absolute'] = 0;
+$handler->display->display_options['fields']['title']['alter']['external'] = 0;
+$handler->display->display_options['fields']['title']['alter']['replace_spaces'] = 0;
+$handler->display->display_options['fields']['title']['alter']['trim_whitespace'] = 0;
+$handler->display->display_options['fields']['title']['alter']['nl2br'] = 0;
+$handler->display->display_options['fields']['title']['alter']['word_boundary'] = 1;
+$handler->display->display_options['fields']['title']['alter']['ellipsis'] = 1;
+$handler->display->display_options['fields']['title']['alter']['more_link'] = 0;
+$handler->display->display_options['fields']['title']['alter']['strip_tags'] = 0;
+$handler->display->display_options['fields']['title']['alter']['trim'] = 0;
+$handler->display->display_options['fields']['title']['alter']['html'] = 0;
+$handler->display->display_options['fields']['title']['element_label_colon'] = 1;
+$handler->display->display_options['fields']['title']['element_default_classes'] = 1;
+$handler->display->display_options['fields']['title']['hide_empty'] = 0;
+$handler->display->display_options['fields']['title']['empty_zero'] = 0;
+$handler->display->display_options['fields']['title']['hide_alter_empty'] = 1;
+$handler->display->display_options['path'] = 'admin/content/payment';
+$handler->display->display_options['menu']['type'] = 'normal';
+$handler->display->display_options['menu']['title'] = 'Payments';
+$handler->display->display_options['menu']['weight'] = '0';
+$handler->display->display_options['menu']['name'] = 'management';
+
+/* Display: User's own payments */
+$handler = $view->new_display('page', 'User\'s own payments', 'page_2');
+$handler->display->display_options['defaults']['access'] = FALSE;
+$handler->display->display_options['access']['type'] = 'perm';
+$handler->display->display_options['access']['perm'] = 'payment.view.own';
+$handler->display->display_options['defaults']['fields'] = FALSE;
+/* Field: Payment: Last updated date and time */
+$handler->display->display_options['fields']['updated']['id'] = 'updated';
+$handler->display->display_options['fields']['updated']['table'] = 'payment';
+$handler->display->display_options['fields']['updated']['field'] = 'updated';
+$handler->display->display_options['fields']['updated']['label'] = 'Last updated';
+$handler->display->display_options['fields']['updated']['alter']['alter_text'] = 0;
+$handler->display->display_options['fields']['updated']['alter']['make_link'] = 0;
+$handler->display->display_options['fields']['updated']['alter']['absolute'] = 0;
+$handler->display->display_options['fields']['updated']['alter']['external'] = 0;
+$handler->display->display_options['fields']['updated']['alter']['replace_spaces'] = 0;
+$handler->display->display_options['fields']['updated']['alter']['trim_whitespace'] = 0;
+$handler->display->display_options['fields']['updated']['alter']['nl2br'] = 0;
+$handler->display->display_options['fields']['updated']['alter']['word_boundary'] = 1;
+$handler->display->display_options['fields']['updated']['alter']['ellipsis'] = 1;
+$handler->display->display_options['fields']['updated']['alter']['strip_tags'] = 0;
+$handler->display->display_options['fields']['updated']['alter']['trim'] = 0;
+$handler->display->display_options['fields']['updated']['alter']['html'] = 0;
+$handler->display->display_options['fields']['updated']['element_label_colon'] = 1;
+$handler->display->display_options['fields']['updated']['element_default_classes'] = 1;
+$handler->display->display_options['fields']['updated']['hide_empty'] = 0;
+$handler->display->display_options['fields']['updated']['empty_zero'] = 0;
+$handler->display->display_options['fields']['updated']['hide_alter_empty'] = 0;
+$handler->display->display_options['fields']['updated']['date_format'] = 'long';
+/* Field: Payment: Currency code */
+$handler->display->display_options['fields']['currency_code']['id'] = 'currency_code';
+$handler->display->display_options['fields']['currency_code']['table'] = 'payment';
+$handler->display->display_options['fields']['currency_code']['field'] = 'currency_code';
+$handler->display->display_options['fields']['currency_code']['label'] = '';
+$handler->display->display_options['fields']['currency_code']['exclude'] = TRUE;
+$handler->display->display_options['fields']['currency_code']['alter']['alter_text'] = 0;
+$handler->display->display_options['fields']['currency_code']['alter']['make_link'] = 0;
+$handler->display->display_options['fields']['currency_code']['alter']['absolute'] = 0;
+$handler->display->display_options['fields']['currency_code']['alter']['external'] = 0;
+$handler->display->display_options['fields']['currency_code']['alter']['replace_spaces'] = 0;
+$handler->display->display_options['fields']['currency_code']['alter']['trim_whitespace'] = 0;
+$handler->display->display_options['fields']['currency_code']['alter']['nl2br'] = 0;
+$handler->display->display_options['fields']['currency_code']['alter']['word_boundary'] = 1;
+$handler->display->display_options['fields']['currency_code']['alter']['ellipsis'] = 1;
+$handler->display->display_options['fields']['currency_code']['alter']['strip_tags'] = 0;
+$handler->display->display_options['fields']['currency_code']['alter']['trim'] = 0;
+$handler->display->display_options['fields']['currency_code']['alter']['html'] = 0;
+$handler->display->display_options['fields']['currency_code']['element_label_colon'] = FALSE;
+$handler->display->display_options['fields']['currency_code']['element_default_classes'] = 1;
+$handler->display->display_options['fields']['currency_code']['hide_empty'] = 0;
+$handler->display->display_options['fields']['currency_code']['empty_zero'] = 0;
+$handler->display->display_options['fields']['currency_code']['hide_alter_empty'] = 0;
+/* Field: SUM(Payment line item: Total amount) */
+$handler->display->display_options['fields']['amount_total']['id'] = 'amount_total';
+$handler->display->display_options['fields']['amount_total']['table'] = 'payment_line_item';
+$handler->display->display_options['fields']['amount_total']['field'] = 'amount_total';
+$handler->display->display_options['fields']['amount_total']['relationship'] = 'pid_line_item';
+$handler->display->display_options['fields']['amount_total']['group_type'] = 'sum';
+$handler->display->display_options['fields']['amount_total']['label'] = 'Amount';
+$handler->display->display_options['fields']['amount_total']['alter']['alter_text'] = 1;
+$handler->display->display_options['fields']['amount_total']['alter']['text'] = '[currency_code] [amount_total]';
+$handler->display->display_options['fields']['amount_total']['alter']['make_link'] = 0;
+$handler->display->display_options['fields']['amount_total']['alter']['absolute'] = 0;
+$handler->display->display_options['fields']['amount_total']['alter']['external'] = 0;
+$handler->display->display_options['fields']['amount_total']['alter']['replace_spaces'] = 0;
+$handler->display->display_options['fields']['amount_total']['alter']['trim_whitespace'] = 0;
+$handler->display->display_options['fields']['amount_total']['alter']['nl2br'] = 0;
+$handler->display->display_options['fields']['amount_total']['alter']['word_boundary'] = 1;
+$handler->display->display_options['fields']['amount_total']['alter']['ellipsis'] = 1;
+$handler->display->display_options['fields']['amount_total']['alter']['more_link'] = 0;
+$handler->display->display_options['fields']['amount_total']['alter']['strip_tags'] = 0;
+$handler->display->display_options['fields']['amount_total']['alter']['trim'] = 0;
+$handler->display->display_options['fields']['amount_total']['alter']['html'] = 0;
+$handler->display->display_options['fields']['amount_total']['element_label_colon'] = 1;
+$handler->display->display_options['fields']['amount_total']['element_default_classes'] = 1;
+$handler->display->display_options['fields']['amount_total']['hide_empty'] = 0;
+$handler->display->display_options['fields']['amount_total']['empty_zero'] = 0;
+$handler->display->display_options['fields']['amount_total']['hide_alter_empty'] = 1;
+/* Field: Payment method: Title (generic) */
+$handler->display->display_options['fields']['title_generic']['id'] = 'title_generic';
+$handler->display->display_options['fields']['title_generic']['table'] = 'payment_method';
+$handler->display->display_options['fields']['title_generic']['field'] = 'title_generic';
+$handler->display->display_options['fields']['title_generic']['relationship'] = 'pmid';
+$handler->display->display_options['fields']['title_generic']['label'] = 'Payment method';
+$handler->display->display_options['fields']['title_generic']['alter']['alter_text'] = 0;
+$handler->display->display_options['fields']['title_generic']['alter']['make_link'] = 0;
+$handler->display->display_options['fields']['title_generic']['alter']['absolute'] = 0;
+$handler->display->display_options['fields']['title_generic']['alter']['external'] = 0;
+$handler->display->display_options['fields']['title_generic']['alter']['replace_spaces'] = 0;
+$handler->display->display_options['fields']['title_generic']['alter']['trim_whitespace'] = 0;
+$handler->display->display_options['fields']['title_generic']['alter']['nl2br'] = 0;
+$handler->display->display_options['fields']['title_generic']['alter']['word_boundary'] = 1;
+$handler->display->display_options['fields']['title_generic']['alter']['ellipsis'] = 1;
+$handler->display->display_options['fields']['title_generic']['alter']['strip_tags'] = 0;
+$handler->display->display_options['fields']['title_generic']['alter']['trim'] = 0;
+$handler->display->display_options['fields']['title_generic']['alter']['html'] = 0;
+$handler->display->display_options['fields']['title_generic']['element_label_colon'] = 1;
+$handler->display->display_options['fields']['title_generic']['element_default_classes'] = 1;
+$handler->display->display_options['fields']['title_generic']['hide_empty'] = 0;
+$handler->display->display_options['fields']['title_generic']['empty_zero'] = 0;
+$handler->display->display_options['fields']['title_generic']['hide_alter_empty'] = 1;
+/* Field: Payment: Operations */
+$handler->display->display_options['fields']['operations']['id'] = 'operations';
+$handler->display->display_options['fields']['operations']['table'] = 'payment';
+$handler->display->display_options['fields']['operations']['field'] = 'operations';
+$handler->display->display_options['fields']['operations']['alter']['alter_text'] = 0;
+$handler->display->display_options['fields']['operations']['alter']['make_link'] = 0;
+$handler->display->display_options['fields']['operations']['alter']['absolute'] = 0;
+$handler->display->display_options['fields']['operations']['alter']['external'] = 0;
+$handler->display->display_options['fields']['operations']['alter']['replace_spaces'] = 0;
+$handler->display->display_options['fields']['operations']['alter']['trim_whitespace'] = 0;
+$handler->display->display_options['fields']['operations']['alter']['nl2br'] = 0;
+$handler->display->display_options['fields']['operations']['alter']['word_boundary'] = 1;
+$handler->display->display_options['fields']['operations']['alter']['ellipsis'] = 1;
+$handler->display->display_options['fields']['operations']['alter']['strip_tags'] = 0;
+$handler->display->display_options['fields']['operations']['alter']['trim'] = 0;
+$handler->display->display_options['fields']['operations']['alter']['html'] = 0;
+$handler->display->display_options['fields']['operations']['element_label_colon'] = 1;
+$handler->display->display_options['fields']['operations']['element_default_classes'] = 1;
+$handler->display->display_options['fields']['operations']['hide_empty'] = 0;
+$handler->display->display_options['fields']['operations']['empty_zero'] = 0;
+$handler->display->display_options['fields']['operations']['hide_alter_empty'] = 1;
+$handler->display->display_options['defaults']['arguments'] = FALSE;
+/* Contextual filter: Payment: User ID */
+$handler->display->display_options['arguments']['uid']['id'] = 'uid';
+$handler->display->display_options['arguments']['uid']['table'] = 'payment';
+$handler->display->display_options['arguments']['uid']['field'] = 'uid';
+$handler->display->display_options['arguments']['uid']['default_action'] = 'not found';
+$handler->display->display_options['arguments']['uid']['default_argument_type'] = 'fixed';
+$handler->display->display_options['arguments']['uid']['default_argument_skip_url'] = 0;
+$handler->display->display_options['arguments']['uid']['summary']['number_of_records'] = '0';
+$handler->display->display_options['arguments']['uid']['summary']['format'] = 'default_summary';
+$handler->display->display_options['arguments']['uid']['summary_options']['items_per_page'] = '25';
+$handler->display->display_options['arguments']['uid']['break_phrase'] = 0;
+$handler->display->display_options['arguments']['uid']['not'] = 0;
+$handler->display->display_options['path'] = 'user/%/payment';
+$handler->display->display_options['menu']['type'] = 'tab';
+$handler->display->display_options['menu']['title'] = 'Payments';
+$handler->display->display_options['menu']['weight'] = '0';
+$handler->display->display_options['menu']['name'] = 'user-menu';
 
-  /* Display: User's own payments */
-  $handler = $view->new_display('page', 'User\'s own payments', 'page_2');
-  $handler->display->display_options['defaults']['access'] = FALSE;
-  $handler->display->display_options['access']['type'] = 'perm';
-  $handler->display->display_options['access']['perm'] = 'payment.view.own';
-  $handler->display->display_options['defaults']['fields'] = FALSE;
-  /* Field: Payment: Last updated date and time */
-  $handler->display->display_options['fields']['updated']['id'] = 'updated';
-  $handler->display->display_options['fields']['updated']['table'] = 'payment';
-  $handler->display->display_options['fields']['updated']['field'] = 'updated';
-  $handler->display->display_options['fields']['updated']['label'] = 'Last updated';
-  $handler->display->display_options['fields']['updated']['alter']['alter_text'] = 0;
-  $handler->display->display_options['fields']['updated']['alter']['make_link'] = 0;
-  $handler->display->display_options['fields']['updated']['alter']['absolute'] = 0;
-  $handler->display->display_options['fields']['updated']['alter']['external'] = 0;
-  $handler->display->display_options['fields']['updated']['alter']['replace_spaces'] = 0;
-  $handler->display->display_options['fields']['updated']['alter']['trim_whitespace'] = 0;
-  $handler->display->display_options['fields']['updated']['alter']['nl2br'] = 0;
-  $handler->display->display_options['fields']['updated']['alter']['word_boundary'] = 1;
-  $handler->display->display_options['fields']['updated']['alter']['ellipsis'] = 1;
-  $handler->display->display_options['fields']['updated']['alter']['strip_tags'] = 0;
-  $handler->display->display_options['fields']['updated']['alter']['trim'] = 0;
-  $handler->display->display_options['fields']['updated']['alter']['html'] = 0;
-  $handler->display->display_options['fields']['updated']['element_label_colon'] = 1;
-  $handler->display->display_options['fields']['updated']['element_default_classes'] = 1;
-  $handler->display->display_options['fields']['updated']['hide_empty'] = 0;
-  $handler->display->display_options['fields']['updated']['empty_zero'] = 0;
-  $handler->display->display_options['fields']['updated']['hide_alter_empty'] = 0;
-  $handler->display->display_options['fields']['updated']['date_format'] = 'long';
-  /* Field: Payment: Currency code */
-  $handler->display->display_options['fields']['currency_code']['id'] = 'currency_code';
-  $handler->display->display_options['fields']['currency_code']['table'] = 'payment';
-  $handler->display->display_options['fields']['currency_code']['field'] = 'currency_code';
-  $handler->display->display_options['fields']['currency_code']['label'] = '';
-  $handler->display->display_options['fields']['currency_code']['exclude'] = TRUE;
-  $handler->display->display_options['fields']['currency_code']['alter']['alter_text'] = 0;
-  $handler->display->display_options['fields']['currency_code']['alter']['make_link'] = 0;
-  $handler->display->display_options['fields']['currency_code']['alter']['absolute'] = 0;
-  $handler->display->display_options['fields']['currency_code']['alter']['external'] = 0;
-  $handler->display->display_options['fields']['currency_code']['alter']['replace_spaces'] = 0;
-  $handler->display->display_options['fields']['currency_code']['alter']['trim_whitespace'] = 0;
-  $handler->display->display_options['fields']['currency_code']['alter']['nl2br'] = 0;
-  $handler->display->display_options['fields']['currency_code']['alter']['word_boundary'] = 1;
-  $handler->display->display_options['fields']['currency_code']['alter']['ellipsis'] = 1;
-  $handler->display->display_options['fields']['currency_code']['alter']['strip_tags'] = 0;
-  $handler->display->display_options['fields']['currency_code']['alter']['trim'] = 0;
-  $handler->display->display_options['fields']['currency_code']['alter']['html'] = 0;
-  $handler->display->display_options['fields']['currency_code']['element_label_colon'] = FALSE;
-  $handler->display->display_options['fields']['currency_code']['element_default_classes'] = 1;
-  $handler->display->display_options['fields']['currency_code']['hide_empty'] = 0;
-  $handler->display->display_options['fields']['currency_code']['empty_zero'] = 0;
-  $handler->display->display_options['fields']['currency_code']['hide_alter_empty'] = 0;
-  /* Field: SUM(Payment line item: Total amount) */
-  $handler->display->display_options['fields']['amount_total']['id'] = 'amount_total';
-  $handler->display->display_options['fields']['amount_total']['table'] = 'payment_line_item';
-  $handler->display->display_options['fields']['amount_total']['field'] = 'amount_total';
-  $handler->display->display_options['fields']['amount_total']['relationship'] = 'pid_line_item';
-  $handler->display->display_options['fields']['amount_total']['group_type'] = 'sum';
-  $handler->display->display_options['fields']['amount_total']['label'] = 'Amount';
-  $handler->display->display_options['fields']['amount_total']['alter']['alter_text'] = 1;
-  $handler->display->display_options['fields']['amount_total']['alter']['text'] = '[currency_code] [amount_total]';
-  $handler->display->display_options['fields']['amount_total']['alter']['make_link'] = 0;
-  $handler->display->display_options['fields']['amount_total']['alter']['absolute'] = 0;
-  $handler->display->display_options['fields']['amount_total']['alter']['external'] = 0;
-  $handler->display->display_options['fields']['amount_total']['alter']['replace_spaces'] = 0;
-  $handler->display->display_options['fields']['amount_total']['alter']['trim_whitespace'] = 0;
-  $handler->display->display_options['fields']['amount_total']['alter']['nl2br'] = 0;
-  $handler->display->display_options['fields']['amount_total']['alter']['word_boundary'] = 1;
-  $handler->display->display_options['fields']['amount_total']['alter']['ellipsis'] = 1;
-  $handler->display->display_options['fields']['amount_total']['alter']['more_link'] = 0;
-  $handler->display->display_options['fields']['amount_total']['alter']['strip_tags'] = 0;
-  $handler->display->display_options['fields']['amount_total']['alter']['trim'] = 0;
-  $handler->display->display_options['fields']['amount_total']['alter']['html'] = 0;
-  $handler->display->display_options['fields']['amount_total']['element_label_colon'] = 1;
-  $handler->display->display_options['fields']['amount_total']['element_default_classes'] = 1;
-  $handler->display->display_options['fields']['amount_total']['hide_empty'] = 0;
-  $handler->display->display_options['fields']['amount_total']['empty_zero'] = 0;
-  $handler->display->display_options['fields']['amount_total']['hide_alter_empty'] = 1;
-  /* Field: Payment method: Title (generic) */
-  $handler->display->display_options['fields']['title_generic']['id'] = 'title_generic';
-  $handler->display->display_options['fields']['title_generic']['table'] = 'payment_method';
-  $handler->display->display_options['fields']['title_generic']['field'] = 'title_generic';
-  $handler->display->display_options['fields']['title_generic']['relationship'] = 'pmid';
-  $handler->display->display_options['fields']['title_generic']['label'] = 'Payment method';
-  $handler->display->display_options['fields']['title_generic']['alter']['alter_text'] = 0;
-  $handler->display->display_options['fields']['title_generic']['alter']['make_link'] = 0;
-  $handler->display->display_options['fields']['title_generic']['alter']['absolute'] = 0;
-  $handler->display->display_options['fields']['title_generic']['alter']['external'] = 0;
-  $handler->display->display_options['fields']['title_generic']['alter']['replace_spaces'] = 0;
-  $handler->display->display_options['fields']['title_generic']['alter']['trim_whitespace'] = 0;
-  $handler->display->display_options['fields']['title_generic']['alter']['nl2br'] = 0;
-  $handler->display->display_options['fields']['title_generic']['alter']['word_boundary'] = 1;
-  $handler->display->display_options['fields']['title_generic']['alter']['ellipsis'] = 1;
-  $handler->display->display_options['fields']['title_generic']['alter']['strip_tags'] = 0;
-  $handler->display->display_options['fields']['title_generic']['alter']['trim'] = 0;
-  $handler->display->display_options['fields']['title_generic']['alter']['html'] = 0;
-  $handler->display->display_options['fields']['title_generic']['element_label_colon'] = 1;
-  $handler->display->display_options['fields']['title_generic']['element_default_classes'] = 1;
-  $handler->display->display_options['fields']['title_generic']['hide_empty'] = 0;
-  $handler->display->display_options['fields']['title_generic']['empty_zero'] = 0;
-  $handler->display->display_options['fields']['title_generic']['hide_alter_empty'] = 1;
-  /* Field: Payment: Operations */
-  $handler->display->display_options['fields']['operations']['id'] = 'operations';
-  $handler->display->display_options['fields']['operations']['table'] = 'payment';
-  $handler->display->display_options['fields']['operations']['field'] = 'operations';
-  $handler->display->display_options['fields']['operations']['alter']['alter_text'] = 0;
-  $handler->display->display_options['fields']['operations']['alter']['make_link'] = 0;
-  $handler->display->display_options['fields']['operations']['alter']['absolute'] = 0;
-  $handler->display->display_options['fields']['operations']['alter']['external'] = 0;
-  $handler->display->display_options['fields']['operations']['alter']['replace_spaces'] = 0;
-  $handler->display->display_options['fields']['operations']['alter']['trim_whitespace'] = 0;
-  $handler->display->display_options['fields']['operations']['alter']['nl2br'] = 0;
-  $handler->display->display_options['fields']['operations']['alter']['word_boundary'] = 1;
-  $handler->display->display_options['fields']['operations']['alter']['ellipsis'] = 1;
-  $handler->display->display_options['fields']['operations']['alter']['strip_tags'] = 0;
-  $handler->display->display_options['fields']['operations']['alter']['trim'] = 0;
-  $handler->display->display_options['fields']['operations']['alter']['html'] = 0;
-  $handler->display->display_options['fields']['operations']['element_label_colon'] = 1;
-  $handler->display->display_options['fields']['operations']['element_default_classes'] = 1;
-  $handler->display->display_options['fields']['operations']['hide_empty'] = 0;
-  $handler->display->display_options['fields']['operations']['empty_zero'] = 0;
-  $handler->display->display_options['fields']['operations']['hide_alter_empty'] = 1;
-  $handler->display->display_options['defaults']['arguments'] = FALSE;
-  /* Contextual filter: Payment: User ID */
-  $handler->display->display_options['arguments']['uid']['id'] = 'uid';
-  $handler->display->display_options['arguments']['uid']['table'] = 'payment';
-  $handler->display->display_options['arguments']['uid']['field'] = 'uid';
-  $handler->display->display_options['arguments']['uid']['default_action'] = 'not found';
-  $handler->display->display_options['arguments']['uid']['default_argument_type'] = 'fixed';
-  $handler->display->display_options['arguments']['uid']['default_argument_skip_url'] = 0;
-  $handler->display->display_options['arguments']['uid']['summary']['number_of_records'] = '0';
-  $handler->display->display_options['arguments']['uid']['summary']['format'] = 'default_summary';
-  $handler->display->display_options['arguments']['uid']['summary_options']['items_per_page'] = '25';
-  $handler->display->display_options['arguments']['uid']['break_phrase'] = 0;
-  $handler->display->display_options['arguments']['uid']['not'] = 0;
-  $handler->display->display_options['path'] = 'user/%/payment';
-  $handler->display->display_options['menu']['type'] = 'tab';
-  $handler->display->display_options['menu']['title'] = 'Payments';
-  $handler->display->display_options['menu']['weight'] = '0';
-  $handler->display->display_options['menu']['name'] = 'user-menu';
-  $translatables['payments'] = array(
-    t('Master'),
-    t('Payments'),
-    t('more'),
-    t('Apply'),
-    t('Reset'),
-    t('Sort by'),
-    t('Asc'),
-    t('Desc'),
-    t('Items per page'),
-    t('- All -'),
-    t('Offset'),
-    t('There are no payments yet.'),
-    t('Payment method'),
-    t('Line items'),
-    t('Last updated'),
-    t('Broken handler payment.amount'),
-    t('[currency_code] [amount]'),
-    t('Title (generic)'),
-    t('Operations'),
-    t('Administration page'),
-    t('Amount'),
-    t('[currency_code] [amount_total]'),
-    t('User\'s own payments'),
-    t('All'),
-  );
 
   return $view;
 }

We should put this code in a new handler. This one is for displaying the human-readable title for a status code .

+++ b/payment/payment.module
@@ -228,7 +228,7 @@ function payment_menu_alter(&$items) {
diff --git a/payment/views/PaymentViewsHandlerFieldPaymentStatusTitle.inc b/payment/views/PaymentViewsHandlerFieldPaymentStatusTitle.inc

We should put this code in a new handler. This one is for displaying the human-readable title for a status code .

+++ b/payment/views/PaymentViewsHandlerFieldPaymentStatusTitle.inc
@@ -13,4 +13,21 @@ class PaymentViewsHandlerFieldPaymentStatusTitle extends views_handler_field {
+		$this->query->table_queue['payment_status_item_payment_1']['join']->extra = 'payment.pid = payment_status_item_payment_1.pid AND (payment_status_item_payment.created < payment_status_item_payment_1.created OR payment_status_item_payment.created = payment_status_item_payment_1.created AND payment_status_item_payment.psiid < payment_status_item_payment_1.psiid )';

It looks like you're assuming a "payment_status_item_payment_1" field exists.

Also, could you provide detailed code comments? It's probably clear to you, but for most people this is dark magic.

Thanks again for your efforts!

Comment #4

xano

he/they

English

Southampton

commented 20 April 2012 at 21:49

+++ b/payment/views/PaymentViewsHandlerFieldPaymentStatusTitle.inc
+++ b/payment/views/PaymentViewsHandlerFieldPaymentStatusTitle.inc
@@ -13,4 +13,21 @@ class PaymentViewsHandlerFieldPaymentStatusTitle extends views_handler_field {

We should create a new handler for this, because this one is specific for displaying the human-readable title of an already selected status code.

+++ b/payment/views/PaymentViewsHandlerFieldPaymentStatusTitle.inc
@@ -13,4 +13,21 @@ class PaymentViewsHandlerFieldPaymentStatusTitle extends views_handler_field {
+		$this->query->table_queue['payment_status_item_payment_1']['join']->extra = 'payment.pid = payment_status_item_payment_1.pid AND (payment_status_item_payment.created < payment_status_item_payment_1.created OR payment_status_item_payment.created = payment_status_item_payment_1.created AND payment_status_item_payment.psiid < payment_status_item_payment_1.psiid )';

How does this work? It looks like the code assumes a "payment_status_item_payment_1" field exists.

Also, could you provide some detailed code comments? It's probably all clear to you, but for most people this is dark magic.

Thanks again for your efforts!

Comment #5

open social commented 21 April 2012 at 13:19

Hey Xano,

How does this work? It looks like the code assumes a "payment_status_item_payment_1" field exists.

True, I will write a new patch one of these days where I will try to add the table with code instead in views.

Comment #6

xano

he/they

English

Southampton

commented 18 May 2012 at 13:51

Hey @goalgorilla, you managed to come up with a new patch yet?

Comment #7

open social commented 18 May 2012 at 14:05

Hey Xano,

not yet,
I have no idea how to implement a 'shadow' table.. to be precise, we need to declare 'payment_status_item_payment_1' two times when you use that relation in views.

Do you have any idea?

Greets Daniel, GoalGorilla

Comment #8

xano

he/they

English

Southampton

commented 29 June 2012 at 13:02

Status:

Needs work

» Needs review

Status	File	Size
new	payment_1533068_01.patch	2.85 KB

The extra join condition doesn't work yet.

Comment #9

xano

he/they

English

Southampton

commented 30 June 2012 at 10:25

It turns out to be extermely hard (if not impossible) to join {payment} on {payment_status_item} in a way that only results in one row per payment and that is has the last available status. It's probably better to change {payment}.updated to {payment}.psiid and join both tables on {payment}.psiid = {payment_status_item].psiid.

Comment #10

xano

he/they

English

Southampton

commented 30 June 2012 at 12:40

Status	File	Size
new	payment_1533068_02.patch	6.68 KB

This patch implements the approach outlined in #9. Before it can be committed, the payment overview view needs to be updated so it no longer uses Payment::updated, but the relationship added by this patch.

Comment #11

xano

he/they

English

Southampton

commented 30 June 2012 at 13:34

Status	File	Size
new	payment_1533068_03.patch	27.9 KB

Now with updated views.

Comment #12

xano

he/they

English

Southampton

commented 30 June 2012 at 13:40

Title:	Add support for the last status of a payment in views	» Add a "Last status item" Views relationship to payments
Status:	Needs review	» Fixed

Comment #13

14 July 2012 at 13:41

Status:

Fixed

» Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

Add a "Last status item" Views relationship to payments

Comments

Comment #1

Comment #2

Comment #3

Comment #4

Comment #5

Comment #6

Comment #7

Comment #8

Comment #9

Comment #10

Comment #11

Comment #12

Comment #13

News items

Our community

Documentation

Drupal code base

Governance of community