profile.views.inc

<?php


/**
 * @file
 * Provide views data and handlers for user.module
 */

/**
 * @defgroup views_profile_module profile.module handlers
 *
 * @{
 */

/**
 * Implementation of hook_views_data()
 */
function profile_views_data() {
    // Define the base group of this table. Fields that don't
    // have a group defined will go into this field by default.
    $data['profile_values']['table']['group'] = t('Profile');
    $data['profile_values']['table']['join'] = array(
        'node' => array(
            'left_table' => 'profile_values',
            'left_field' => 'uid',
            'field' => 'uid',
        ),
        'users' => array(
            'left_table' => 'profile_values',
            'left_field' => 'uid',
            'field' => 'uid',
        ),
    );
    $fields = profile_views_get_fields();
    foreach ($fields as $field) {
        $table_name = 'profile_values_' . str_replace('-', '_', $field->name);
        $data[$table_name] = array(
            'table' => array(
                'group' => t('Profile'),
                'join' => array(
                    'node' => array(
                        'table' => 'profile_values',
                        'left_table' => 'users',
                        'left_field' => 'uid',
                        'field' => 'uid',
                        'extra' => array(
                            array(
                                'field' => 'fid',
                                'value' => $field->fid,
                            ),
                        ),
                    ),
                    'users' => array(
                        'table' => 'profile_values',
                        'left_field' => 'uid',
                        'field' => 'uid',
                        'extra' => array(
                            array(
                                'field' => 'fid',
                                'value' => $field->fid,
                            ),
                        ),
                    ),
                ),
            ),
        );
        // All fields in the table are named 'value'.
        $data[$table_name]['value'] = profile_views_fetch_field($field);
    }
    return $data;
}

/**
 * Get all profile fields
 */
function profile_views_get_fields() {
    static $fields = NULL;
    if (!isset($fields)) {
        $fields = array();
        $results = db_query("SELECT * FROM {profile_fields} ORDER BY category, weight");
        while ($row = db_fetch_object($results)) {
            if (!empty($row->options)) {
                if (!in_array(substr($row->options, 0, 2), array(
                    'a:',
                    'b:',
                    'i:',
                    'f:',
                    'o:',
                    's:',
                ))) {
                    // unserialized fields default version
                    $options = $row->options;
                    unset($row->options);
                    $row->options = $options;
                }
                else {
                    // serialized fields or modified version
                    $row->options = unserialize(db_decode_blob($row->options));
                }
            }
            $fields[$row->fid] = $row;
        }
    }
    return $fields;
}

/**
 * Add profile fields to view table
 */
function profile_views_fetch_field($field) {
    $data = array(
        'title' => t('@category: @field-name', array(
            '@category' => $field->category,
            '@field-name' => $field->title,
        )),
    );
    // Add fields specific to the profile type.
    switch ($field->type) {
        case 'textfield':
            $data += array(
                'help' => t('Profile textfield'),
                'field' => array(
                    'handler' => 'views_handler_field_user',
                    'click sortable' => TRUE,
                ),
                'sort' => array(
                    'handler' => 'views_handler_sort',
                ),
                'filter' => array(
                    'handler' => 'views_handler_filter_string',
                ),
                'argument' => array(
                    'handler' => 'views_handler_argument_string',
                ),
            );
            break;
        case 'textarea':
            $data += array(
                'help' => t('Profile textarea'),
                'field' => array(
                    'handler' => 'views_handler_field_markup',
                    'format' => FILTER_FORMAT_DEFAULT,
                ),
                'sort' => array(
                    'handler' => 'views_handler_sort',
                ),
                'filter' => array(
                    'handler' => 'views_handler_filter_string',
                ),
            );
            break;
        case 'checkbox':
            $data += array(
                'help' => t('Profile checkbox'),
                'field' => array(
                    'handler' => 'views_handler_field_boolean',
                    'click sortable' => TRUE,
                ),
                'sort' => array(
                    'handler' => 'views_handler_sort',
                ),
                'filter' => array(
                    'handler' => 'views_handler_filter_boolean_operator',
                    'accept null' => TRUE,
                ),
            );
            break;
        case 'url':
            $data += array(
                'help' => t('Profile URL'),
                'field' => array(
                    'handler' => 'views_handler_field_url',
                    'click sortable' => TRUE,
                ),
                'sort' => array(
                    'handler' => 'views_handler_sort',
                ),
                'filter' => array(
                    'handler' => 'views_handler_filter_string',
                ),
            );
            break;
        case 'selection':
            $data += array(
                'help' => t('Profile selection'),
                'field' => array(
                    'handler' => 'views_handler_field',
                    'click sortable' => TRUE,
                ),
                'sort' => array(
                    'handler' => 'views_handler_sort',
                ),
                'filter' => array(
                    'handler' => 'views_handler_filter_profile_selection',
                    'fid' => $field->fid,
                ),
                'argument' => array(
                    'handler' => 'views_handler_argument_string',
                ),
            );
            break;
        case 'list':
            $data += array(
                'help' => t('Profile freeform list %field-name.', array(
                    '%field-name' => $field->title,
                )),
                'field' => array(
                    'handler' => 'views_handler_field_profile_list',
                    'no group by' => TRUE,
                ),
                'filter' => array(
                    'handler' => 'views_handler_filter_string',
                ),
            );
            break;
        case 'date':
            $data += array(
                'help' => t('Profile date %field-name.', array(
                    '%field-name' => $field->title,
                )),
                'field' => array(
                    'handler' => 'views_handler_field_profile_date',
                ),
            );
            break;
    }
    // @todo: add access control to hidden fields.
    return $data;
}

/**
 * Implementation of hook_views_handlers() to register all of the basic handlers
 * views uses.
 */
function profile_views_handlers() {
    return array(
        'info' => array(
            'path' => drupal_get_path('module', 'views') . '/modules/profile',
        ),
        'handlers' => array(
            'views_handler_field_profile_date' => array(
                'parent' => 'views_handler_field_date',
            ),
            'views_handler_field_profile_list' => array(
                'parent' => 'views_handler_field_prerender_list',
            ),
            'views_handler_filter_profile_selection' => array(
                'parent' => 'views_handler_filter_in_operator',
            ),
        ),
    );
}

/**
 * @}
 */