Home

Fix for Fix for Fix for UC_Views

January 27, 2010 - 4:09pm — Anonymous
  1. <?PHP //within uc.views.module
  2.  
  3. /**
  4.  * Implementation of hook_date_api_fields().
  5.  * on behalf of core fields.
  6.  *
  7.  * All modules that create custom fields that use the
  8.  * 'views_handler_field_date' handler can provide
  9.  * additional information here about the type of
  10.  * date they create so the date can be used by
  11.  * the Date API views date argument and date filter.
  12.  *
  13.  * Thank you justindodge for this!
  14.  */
  15. function uc_views_date_api_fields($field) {
  16.   $values = array(
  17.     // The type of date: DATE_UNIX, DATE_ISO, DATE_DATETIME.
  18.     'sql_type' => DATE_UNIX,
  19.     // Timezone handling options: 'none', 'site', 'date', 'utc'.
  20.     'tz_handling' => 'site',
  21.     // Needed only for dates that use 'date' tz_handling.
  22.     'timezone_field' => '',
  23.     // Needed only for dates that use 'date' tz_handling.
  24.     'offset_field' => '',
  25.     // Array of "table.field" values for related fields that should be
  26.     // loaded automatically in the Views SQL.
  27.     'related_fields' => array(),
  28.     // Granularity of this date field's db data.
  29.     'granularity' => array('year', 'month', 'day', 'hour', 'minute', 'second'),
  30.   );
  31.   return $values;
  32. }
  33. ?>
  34.  
  35. <?PHP //within uc_views.views.inc
  36.  
  37.   // here is how it is done for the order modified date, and this works...
  38.   $data['uc_orders']['modified'] = array(
  39.     'title' => t('Order Modification Date'),
  40.     'help' => $order_schema['fields']['modified']['description'],
  41.     'field' => array(
  42.       'handler' => 'views_handler_field_date',
  43.       'click sortable' => TRUE,
  44.     ),
  45.      'sort' => array(
  46.       'handler' => 'views_handler_sort_date',
  47.     ),
  48.     'filter' => array(
  49.       'handler' => 'views_handler_filter_date',
  50.     ),
  51.   );
  52.  
  53.   //Use the sleeker date_api views handler if the module is available
  54.   if(module_exists('date_api')) {
  55.     $data['uc_orders']['modified']['filter']['handler'] = 'date_api_filter_handler';
  56.   }
  57.  
  58.   // here is a little bit o stuff to add shipping details to uc_views
  59.   $data['uc_shipments']['table']['group'] = t('Ubercart shipment');
  60.   $data['uc_shipments']['table']['join']['uc_orders'] = array(
  61.     'left_field' => 'order_id',
  62.     'field' => 'order_id',
  63.   );
  64.   $data['uc_shipments']['carrier'] = array(
  65.     'title' => t('Shipping Carrier Title'),
  66.     'help' => t('The shipping carrier used.'),
  67.     'field' => array(
  68.       'handler' => 'views_handler_field',
  69.       'click sortable' => TRUE,
  70.     ),
  71.   );
  72.   $data['uc_shipments']['cost'] = array(
  73.     'title' => t('Shipping Cost Amount'),
  74.     'help' => t('The shipping actual cost.'),
  75.     'field' => array(
  76.       'handler' => 'uc_views_handler_field_money_amount',
  77.       'click sortable' => TRUE,
  78.     ),
  79.   );
  80.   // try to add the ship date as a filter as is done for modified & created dates...everything works but the field is missing from the list of options in the "date" modules dialog for filters
  81.   $data['uc_shipments']['ship_date'] = array(
  82.     'title' => t('Order Ship Date'),
  83.     'help' => t('The shipment date.'),
  84.     'field' => array(
  85.       'handler' => 'views_handler_field_date',
  86.       'click sortable' => TRUE,
  87.     ),
  88.      'sort' => array(
  89.       'handler' => 'views_handler_sort_date',
  90.     ),
  91.     'filter' => array(
  92.       'handler' => 'views_handler_filter_date',
  93.     ),
  94.   );
  95.   //if the sexy date module is installed use that for filtering
  96.   if(module_exists('date_api')) {
  97.     $data['uc_shipments']['ship_date']['filter']['handler'] = 'date_api_filter_handler';
  98.   }
  99. ?>

Submit Fix

Any tags you'd like to associate with your code, delimitered by commas (example: Views, CCK, Module, etc).
Select the syntax highlighting mode to use.