filedepot.views.inc in filedepot 6

filedepot.views.inc Contains all Views related API calls and default view creation information

File

views/filedepot.views.inc

<?php

// $Id:

/**
 * @file
 * filedepot.views.inc
 * Contains all Views related API calls and default view creation information
 */
function filedepot_views_data() {
  $data = array();
  $data['filedepot_categories']['table']['group'] = t('Filedepot Folders');
  $data['filedepot_categories']['table']['base'] = array(
    'field' => 'cid',
    'title' => t('Filedepot Folders'),
    'help' => t("Filedepot Folder Structure."),
  );
  $data['filedepot_files']['table']['group'] = t('Filedepot Files');
  $data['filedepot_files']['table']['join'] = array(
    'filedepot_categories' => array(
      'type' => 'LEFT',
      'left_field' => 'cid',
      'field' => 'cid',
    ),
  );

  // *** Field definitions ***
  $data['filedepot_categories']['name'] = array(
    'title' => t('Folder Name'),
    'help' => t('Name of the Folder'),
    'field' => array(
      'click sortable' => TRUE,
    ),
  );

  // INT fields here:
  $data['filedepot_categories']['cid'] = array(
    'title' => t('Folder ID'),
    'help' => t('Unique Folder Identifier.'),
    'field' => array(
      'handler' => 'views_handler_field_numeric',
      'click sortable' => TRUE,
    ),
    'filter' => array(
      'handler' => 'views_handler_filter_numeric',
    ),
    'sort' => array(
      'handler' => 'views_handler_sort',
    ),
    'argument' => array(
      'handler' => 'views_handler_argument_string',
    ),
  );
  $data['filedepot_categories']['pid'] = array(
    'title' => t('Parent Folder'),
    'help' => t('Folder Parent Identifier.'),
    'field' => array(
      'handler' => 'views_handler_field_numeric',
      'click sortable' => TRUE,
    ),
    'filter' => array(
      'handler' => 'views_handler_filter_numeric',
    ),
    'sort' => array(
      'handler' => 'views_handler_sort',
    ),
  );
  $data['filedepot_categories']['nid'] = array(
    'title' => t('Node ID'),
    'help' => t('Drupal Node Identifier.'),
    'field' => array(
      'handler' => 'views_handler_field_numeric',
      'click sortable' => TRUE,
    ),
    'filter' => array(
      'handler' => 'views_handler_filter_numeric',
    ),
    'sort' => array(
      'handler' => 'views_handler_sort',
    ),
  );
  $data['filedepot_files']['fid'] = array(
    'title' => t('File ID'),
    'help' => t('Unique File Identifier.'),
    'field' => array(
      'handler' => 'views_handler_field_numeric',
      'click sortable' => FALSE,
    ),
    'filter' => array(
      'handler' => 'views_handler_filter_numeric',
    ),
  );
  $data['filedepot_files']['fname'] = array(
    'title' => t('File Name'),
    'help' => t('Real Name of the File'),
    'field' => array(
      'click sortable' => TRUE,
    ),
  );
  $data['filedepot_files']['title'] = array(
    'title' => t('File Title'),
    'help' => t('Display Name of the File'),
    'field' => array(
      'click sortable' => TRUE,
    ),
  );
  return $data;
}
function filedepot_views_pre_execute(&$view) {
  if ($view->name == 'filedepot') {
    $extra_sql = '';

    // Check if user has entered the argument into the view directly -- ie in the view UI
    // If so, we need will use that folder id to remove it and add our own including sub folders.
    if ($view->args[0] > 0) {
      $folder_id = $view->args[0];

      //str_replace("WHERE filedepot_categories.cid = '%s'\n", '', $view->build_info['query']);
      $wherepos = strpos($view->build_info['query'], "WHERE filedepot_categories.cid = '");
      if ($wherepos > 0) {
        $wherepos_end = strpos($view->build_info['query'], "'\n", $wherepos);
        if ($wherepos_end > $wherepos) {
          $view->build_info['query'] = substr($view->build_info['query'], 0, $wherepos) . substr($view->build_info['query'], $wherepos_end + 3);
        }
      }
    }
    else {

      // Check if a folder id is being passed in to the view from a URL argument
      $folder_id = intval(arg(1));
    }
    $filedepot = filedepot_filedepot();

    // if we have a valid folder id determine all viewable subfolders and only generate view for these folders
    if ($folder_id > 0 and $filedepot
      ->checkPermission($folder_id, 'view')) {
      module_load_include('php', 'filedepot', 'lib-common');
      $array_folders = array();
      $array_folders[] = $folder_id;
      filedepot_getRecursiveCatIDs($array_folders, $folder_id, 'view');
      if (!empty($array_folders) and count($array_folders) > 0) {
        $folderlist = implode(',', $array_folders);
        if (strpos($view->build_info['query'], 'WHERE') > 0) {
          $sql_filter_verb = 'AND';
        }
        else {
          $sql_filter_verb = 'WHERE';
        }
        $extra_sql .= " {$sql_filter_verb} filedepot_categories.cid in ({$folderlist})";
      }
    }
    else {
      if (!empty($filedepot->allowableViewFoldersSql)) {
        if (strpos($extra_sql, 'WHERE') > 0 or strpos($view->build_info['query'], 'WHERE') > 0) {
          $sql_filter_verb = 'AND';
        }
        else {
          $sql_filter_verb = 'WHERE';
        }
        if (strpos($view->build_info['query'], 'GROUP BY') > 0) {
          $extra_sql .= " {$sql_filter_verb} filedepot_categories.cid in ({$filedepot->allowableViewFoldersSql}) ";
        }
        else {
          $extra_sql .= " {$sql_filter_verb} filedepot_categories.cid in ({$filedepot->allowableViewFoldersSql}) ";
        }
      }
      else {

        // User does not have any viewable folders
        if (strpos($extra_sql, 'WHERE') > 0 or strpos($view->build_info['query'], 'WHERE') > 0) {
          $sql_filter_verb = 'AND';
        }
        else {
          $sql_filter_verb = 'WHERE';
        }
        $extra_sql .= " {$sql_filter_verb} 1=2 ";
      }
    }
    if (!empty($extra_sql)) {
      if (strpos($view->build_info['query'], 'GROUP BY') > 0) {
        $view->build_info['query'] = str_replace('GROUP BY', " {$extra_sql} GROUP BY", $view->build_info['query']);
      }
      else {
        $view->build_info['query'] .= $extra_sql;
      }
    }
  }
}

Functions

Name	Description
filedepot_views_data	@file filedepot.views.inc Contains all Views related API calls and default view creation information
filedepot_views_pre_execute