Certificate snapshots as entities

Hi,

I know that you've moved the issue against version 3, but As Opigno LMS are using version 2 and updates of their dependencies are very, VERY risky... I went with my proposal.

I was then able to make a view that starts from the "User certificates" group in views UI and join with the user and course and providing a download link. Note the configuration that generates only 1 certificate for user/course pair, as otherwise downloads started duplicating the listing entries...

If you need the reverse relationships, you should implement the MY_MODULE_views_data_alter(&$data), and provide them. Examples can be found in views module integration with node.

I have not provided a patch, as this is not the way this should be extended as already stated in #2.

Here is the code that fixed it for me:

/**
 * Imlplements hook_views_data().
 *
 * @return array
 *   Meta-data definitions.
 */
function MY_MODULE_views_data() {
  $data = array();

  $data['certificate_snapshots']['table'] = array(
    'group' => t('Certificates'),
    'base' => array(
      'field' => 'csid',
      'title' => t('User certificates'),
      'help' => t('Represents the concrete certificate instances assigned to users.'),
    ),
    'default_relationship' => array(
      'owner' => array(
        'table' => 'users',
        'field' => 'uid',
      ),
      'certificate' => array(
        'table' => 'node',
        'field' => 'nid',
      ),
    ),
  );

  $data['certificate_snapshots']['uid'] = array(
    'title' => t('Certificate owner UID'),
    'help' => t('References a user instance.'),

    'field' => array(
      'handler' => 'views_handler_field_user',
      'click sortable' => TRUE,
    ),
    'argument' => array(
      'handler' => 'views_handler_argument_user_uid',
      'name field' => 'name',
    ),
    'filter' => array(
      'title' => t('Certificate owner UID'),
      'handler' => 'views_handler_filter_user_name',
    ),
    'sort' => array(
      'handler' => 'views_handler_sort',
    ),
    'relationship' => array(
      'base' => 'users',
      'base field' => 'uid',
      'field' => 'uid',
      'handler' => 'views_handler_relationship',
      'label' => t('Owner'),
      'group' => t('Certificates'),
      'title' => t('Certificate owner relationship'),
      'help' => t('Certificate owner relationship HELP'),
    ),
  );

  $data['certificate_snapshots']['nid'] = array(
    'title' => t('Course NID'),
    'help' => t('Refers a course node instance.'),

    'field' => array(
      'handler' => 'views_handler_field_node',
      'click sortable' => TRUE,
    ),
    'argument' => array(
      'handler' => 'views_handler_argument_node_nid',
      'name field' => 'title',
    ),
    'relationship' => array(
      'base' => 'node',
      'base field' => 'nid',
      'field' => 'nid',
      'handler' => 'views_handler_relationship',
      'label' => t('Course'),
      'group' => t('Certificates'),
      'title' => t('Certificate course relationship'),
      'help' => t('Certificate course relationship HELP'),
    ),
  );

  return $data;
}