<?php
/**
  * Sistema Integral de Planificación y Presupuesto (SIPP)
  * @file sipp_sipp_report2.views.inc
  * Drupal part Module to Sistema Integral de Planificación y Presupuesto (SIPP)
  * Copyright 2014 Sistema Automatizado para la Planificación Estratégico-Situacional en la Administración Pública Venezolana (CENDITEL)
  *
  * This program is free software; you can redistribute it and/or modify
  * it under the terms of the GNU General Public License as published by
  * the Free Software Foundation; either version 2 of the License, or
  * (at your option) any later version.
  * 
  * This program is distributed in the hope that it will be useful,
  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  * GNU General Public License for more details.
  * 
  * You should have received a copy of the GNU General Public License
  * along with this program; if not, write to the Free Software
  * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301  USA
  *
  * @author Cenditel Merida - Msc. Juan Vizcarrondo
  * @date 2014-06-09 // (a&#241;o-mes-dia)
  * @version 0.1 // (0.1)
  *
  */

/**
 * Implementation of hook_views_data()
 */
function sipp_report2_views_data() {

  $data['proyectos_operativos']['table']['group'] = t('Proyectos Operativos');
  $data['proyectos_operativos']['table']['join'] = array(
    'node' => array(
      'left_field' => 'nid',
      'field' => 'nid',
    ),
  );
  $data['proyectos_operativos']['year'] = array(
    'title' => t('Año del Proyecto'),
    'help' => t('El año de formulación del proyecto.'),
    'field' => array(
      'handler' => 'views_handler_field_node',
      'click sortable' => TRUE,
    ),
    'sort' => array(
      'handler' => 'views_handler_sort',
    ),
    'filter' => array(
      'handler' => 'sipp_reports2_handler_filter_proyecto_year',
    ),
    'argument' => array(
      'handler' => 'views_handler_argument_string',
    ),
  );

  // Define the base group of this table. Fields that don't
  // have a group defined will go into this field by default.
  $data['proyectos_reformular']['table']['group']  = t('Reformulaciones de Proyectos');

  // Advertise this table as a possible base table
  $data['proyectos_reformular']['table']['base'] = array(
    'field' => 'id_ref',
    'title' => t('Reformulaciones'),
    'help' => t('Reformulacion revisions are a history of changes to reformulacion.'),
  );

  // For other base tables, explain how we join
  $data['proyectos_reformular']['table']['join'] = array(
    // Directly links to node table.
    'node' => array(
      'left_field' => 'nid',
      'field' => 'nid',
    ),
    'users' => array(
      'left_field' => 'uid',
      'field' => 'uid',
    ),
  );

  $data['proyectos_reformular']['date'] = array(
    'title' => t('Fecha de reformulación'),
    'help' => t('La Fecha de reformulación del proyecto.'),
    'field' => array(
      'handler' => 'views_handler_field_date',
      'click sortable' => TRUE,
    ),
    'sort' => array(
      'handler' => 'views_handler_sort',
    ),
    'filter' => array(
      'handler' => 'views_handler_filter_date',
    ),
    'argument' => array(
      'handler' => 'views_handler_argument_string',
    ),
  );
  $data['proyectos_reformular']['variacion'] = array(
    'title' => t('Variación de la reformulación'),
    'help' => t('La variación de la reformulación del proyecto.'),
    'field' => array(
      'handler' => 'views_handler_field_numeric',
      'click sortable' => TRUE,
    ),
    'sort' => array(
      'handler' => 'views_handler_sort',
    ),
    'filter' => array(
      'handler' => 'views_handler_filter_float',
    ),
    'argument' => array(
      'handler' => 'views_handler_argument_numeric',
    ),
  );
  $data['proyectos_reformular']['unidad'] = array(
    'title' => t('Unidad de medida de la reformulación'),
    'help' => t('La Unidad de medida de la reformulación del proyecto.'),
    'field' => array(
      'handler' => 'views_handler_field_numeric',
      'click sortable' => TRUE,
    ),
    'sort' => array(
      'handler' => 'views_handler_sort',
    ),
    'filter' => array(
      'handler' => 'views_handler_filter_numeric',
    ),
    'argument' => array(
      'handler' => 'views_handler_argument_numeric',
    ),
  );
  // uid
  $data['proyectos_reformular']['unidad_apro'] = array(
    'real field' => 'unidad',
    'title' => t('Unidad de medida Aprobada para la Reformulación'),
    'help' => t('Unidad de medida aprobada para la Reformulación.'),
    'filter' => array(
      'handler' => 'views_handler_filter_unidades_aprobadas',
    ),
  );


  $data['proyectos_reformular']['monto'] = array(
    'title' => t('Monto de la reformulación'),
    'help' => t('El monto de la reformulación del proyecto.'),
    'field' => array(
      'handler' => 'views_handler_field_numeric',
      'click sortable' => TRUE,
    ),
    'sort' => array(
      'handler' => 'views_handler_sort',
    ),
    'filter' => array(
      'handler' => 'views_handler_filter_float',
    ),
    'argument' => array(
      'handler' => 'views_handler_argument_numeric',
    ),
  );
  $data['proyectos_reformular']['fecha_onapre'] = array(
    'title' => t('Fecha Onapre de reformulación'),
    'help' => t('La Fecha de Onapre de la reformulación del proyecto.'),
    'field' => array(
      'handler' => 'views_handler_field_date',
      'click sortable' => TRUE,
    ),
    'sort' => array(
      'handler' => 'views_handler_sort',
    ),
    'filter' => array(
      'handler' => 'views_handler_filter_date',
    ),
    'argument' => array(
      'handler' => 'views_handler_argument_string',
    ),
  );
  $data['proyectos_reformular']['justificacion'] = array(
    'title' => t('Justificación de reformulación'),
    'help' => t('La Justificación de reformulación del proyecto.'),
    'field' => array(
      'handler' => 'views_handler_field_string',
      'click sortable' => TRUE,
    ),
    'sort' => array(
      'handler' => 'views_handler_sort',
    ),
    'argument' => array(
      'handler' => 'views_handler_argument_string',
    ),
  );

  $data['proyectos_reformular']['id_ref'] = array(
    'title' => t('Id de la reformulación'),
    'help' => t('Id de la reformulación del proyecto.'),
    'field' => array(
      'handler' => 'views_handler_field_numeric',
      'click sortable' => TRUE,
    ),
    'sort' => array(
      'handler' => 'views_handler_sort',
    ),
    'filter' => array(
      'handler' => 'views_handler_filter_current_reformulacion',
    ),
    'argument' => array(
      'handler' => 'views_handler_argument_numeric',
    ),
  );
  return $data;
}

/*
 * Implementation of hook_views_handlers
 */
function sipp_report2_views_handlers() {
  return array(
    'info' => array(
      'path' => drupal_get_path('module', 'sipp_report2') .'/views',
    ),
    'handlers' => array(
      'sipp_reports2_handler_filter_proyecto_year' => array(
        'parent' => 'views_handler_filter_numeric',
      ),
      'views_handler_filter_current_reformulacion' => array(
        'parent' => 'views_handler_filter_boolean_operator',
      ),
      'views_handler_filter_unidades_aprobadas' => array(
        'parent' => 'views_handler_filter_many_to_one',
      ),
    ),
  );
}