<?php

/**
 * Implements hook_views_data().
 */
function mkbh_general_views_data()
{
    return [
        'mkbh_stripe_customers' => [
            'table' => [
                'group' => t('Stripe'),

                'base' => [
                    'field' => 'id',
                    'title' => t('Stripe Customers'),
                    'help' => t('Table containing all active Stripe customers and relations to Drupal accounts.'),
                    'defaults' => [
                        'field' => 'id',
                    ],
                ],

                'join' => [
                    'users' => [
                        'left_field' => 'uid',
                        'field' => 'user_id',
                    ],
                ],
            ],

            'customer_id' => [
                'title' => t('Stripe Customer ID'),
                'field' => [
                    'field' => 'customer_id',
                    'group' => t('Stripe Customers'),
                    'handler' => 'views_handler_field',
                ],
                'sort' => [
                    'handler' => 'views_handler_sort',
                ],
                'filter' => [
                    'handler' => 'views_handler_filter_string',
                ],
                'argument' => [
                    'handler' => 'views_handler_argument_string',
                ],
            ],

            'user_email' => [
                'title' => t('Stripe Customer Email'),
                'field' => [
                    'field' => 'user_email',
                    'group' => t('Stripe Customers'),
                    'handler' => 'views_handler_field',
                ],
                'sort' => [
                    'handler' => 'views_handler_sort',
                ],
                'filter' => [
                    'handler' => 'views_handler_filter_string',
                ],
                'argument' => [
                    'handler' => 'views_handler_argument_string',
                ],
            ],
        ],

        'mkbh_stripe_subscriptions' => [
            'table' => [
                'group' => t('Stripe'),

                'base' => [
                    'field' => 'id',
                    'title' => t('Stripe Subscriptions'),
                    'help' => t('Table containing all active Stripe subscriptions and relations to Stripe customers.'),
                    'defaults' => [
                        'field' => 'id',
                    ],
                ],

                'join' => [
                    'mkbh_stripe_customers' => [
                        'left_field' => 'customer_id',
                        'field' => 'customer_id',
                    ],
                ],
            ],

            'customer_id' => [
                'title' => t('Stripe Customer ID'),
                'field' => [
                    'field' => 'customer_id',
                    'group' => t('Stripe Subscriptions'),
                    'handler' => 'views_handler_field',
                ],
                'sort' => [
                    'handler' => 'views_handler_sort',
                ],
                'filter' => [
                    'handler' => 'views_handler_filter_string',
                ],
                'argument' => [
                    'handler' => 'views_handler_argument_string',
                ],
            ],

            'subscription_id' => [
                'title' => t('Stripe Subscription ID'),
                'field' => [
                    'field' => 'subscription_id',
                    'group' => t('Stripe Subscriptions'),
                    'handler' => 'views_handler_field',
                ],
                'sort' => [
                    'handler' => 'views_handler_sort',
                ],
                'filter' => [
                    'handler' => 'views_handler_filter_string',
                ],
                'argument' => [
                    'handler' => 'views_handler_argument_string',
                ],
            ],

            'plan_id' => [
                'title' => t('Stripe Plan ID'),
                'field' => [
                    'field' => 'plan_id',
                    'group' => t('Stripe Subscriptions'),
                    'handler' => 'views_handler_field',
                ],
                'sort' => [
                    'handler' => 'views_handler_sort',
                ],
                'filter' => [
                    'handler' => 'views_handler_filter_in_operator',
                    'options callback' => 'mkbh_general_views_data_mkbh_stripe_subscriptions_plan_id_options',
                ],
                'argument' => [
                    'handler' => 'views_handler_argument_string',
                ],
            ],

            'plan_name' => [
                'title' => t('Stripe Plan Name'),
                'field' => [
                    'field' => 'plan_name',
                    'group' => t('Stripe Subscriptions'),
                    'handler' => 'views_handler_field',
                ],
                'sort' => [
                    'handler' => 'views_handler_sort',
                ],
                'filter' => [
                    'handler' => 'views_handler_filter_string',
                ],
                'argument' => [
                    'handler' => 'views_handler_argument_string',
                ],
            ],
        ],
    ];
}

/**
 * @return array
 */
function mkbh_general_views_data_mkbh_stripe_subscriptions_plan_id_options()
{
    return [
        MKBH_DONATE_PERSONAL_BASIS_PLAN_ID => 'Medlem Basis',
        MKBH_DONATE_PERSONAL_PLUS_PLAN_ID => 'Medlem Plus',
        MKBH_DONATE_BUSINESS_PER_MONTH_PLAN_ID => 'Abonnement / Måned',
        MKBH_DONATE_BUSINESS_PER_YEAR_PLAN_ID => 'Abonnement / År',
    ];
}