Ignore:
Timestamp:
Nov 30, 2009, 9:41:11 PM (14 years ago)
Author:
nikrou
Message:

Feature 1255 :
sql functions for calendar (interval, year, month, ...)

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/include/calendar_weekly.class.php

    r3282 r4398  
    5151    $this->calendar_levels = array(
    5252      array(
    53           'sql'=> 'YEAR('.$this->date_field.')',
     53          'sql'=> pwg_db_get_year($this->date_field),
    5454          'labels' => null
    5555        ),
    5656      array(
    57           'sql'=> 'WEEK('.$this->date_field.')+1',
     57          'sql'=> pwg_db_get_week($this->date_field)+1,
    5858          'labels' => $week_no_labels,
    5959        ),
    6060      array(
    61           'sql'=> 'DAYOFWEEK('.$this->date_field.')-1',
     61          'sql'=> pwg_db_get_dayofweek($this->date_field)-1,
    6262          'labels' => $lang['day']
    6363        ),
     
    6565    //Comment next lines for week starting on Sunday or if MySQL version<4.0.17
    6666    //WEEK(date,5) = "0-53 - Week 1=the first week with a Monday in this year"
    67     $this->calendar_levels[CWEEK]['sql'] = 'WEEK('.$this->date_field.',5)+1';
    68     $this->calendar_levels[CDAY]['sql'] = 'WEEKDAY('.$this->date_field.')';
     67    $this->calendar_levels[CWEEK]['sql'] = pwg_db_get_week($this->date_field, 5).'+1';
     68    $this->calendar_levels[CDAY]['sql'] = pwg_db_get_weekday($this->date_field);
    6969    array_push( $this->calendar_levels[CDAY]['labels'],
    7070                array_shift( $this->calendar_levels[CDAY]['labels'] ) );
Note: See TracChangeset for help on using the changeset viewer.