Timezone support for Date Facets

Yes, see CCK Facets.

However it's not very useful due to no timezone support

@jpp: Help is welcome to develop the module further. :-)

I'm slammed with work however I did hack timezone support a while back

basically I added a call to the get_timezone code in date_authored_facet (why re-invent the wheel :-)

     *   The query object to update.
     */
    function build_results_query(&$query) {
+     $timezone = _date_authored_facet_get_user_timezone(); // hack !
      $db_info = _cck_facets_db_info($this->_field);
      $main_column = array_shift($db_info['columns']);
      // Since the same table might be joined multiple times in the query, we use
***************

and then added "+ $timezone" to all the places where a date is being added to the query

$query->add_where("($table.${main_column['column']} + $timezone >= UNIX_TIMESTAMP($from))");

There are about 20 similar lines - I'd send a patch but my hacked version is 2 revs back from the current dev and I don't have time to untangle the changes.

Hacked file attached - use extreme cautuon it's not the current version

@fletch11: Sorry, your issue has been hijacked. :-)

I don't know if that can help, but we met problems of timezone on our site and found this solution :
http://drupalfr.org/forum/support/developpement/27462-cck-date-et-cck-fa...
Thank you for your work, this is a very useful module!
Brn