/** * Initialize the calendar * @param string $inner_sql */ function initialize($inner_sql) { parent::initialize($inner_sql); global $lang, $conf; $week_no_labels = array(); for ($i = 1; $i <= 53; $i++) { $week_no_labels[$i] = l10n('Week %d', $i); //$week_no_labels[$i] = $i; } $this->calendar_levels = array(array('sql' => pwg_db_get_year($this->date_field), 'labels' => null), array('sql' => pwg_db_get_week($this->date_field) . '+1', 'labels' => $week_no_labels), array('sql' => pwg_db_get_dayofweek($this->date_field) . '-1', 'labels' => $lang['day'])); //Comment next lines for week starting on Sunday or if MySQL version<4.0.17 //WEEK(date,5) = "0-53 - Week 1=the first week with a Monday in this year" if ('monday' == $conf['week_starts_on']) { $this->calendar_levels[CWEEK]['sql'] = pwg_db_get_week($this->date_field, 5) . '+1'; $this->calendar_levels[CDAY]['sql'] = pwg_db_get_weekday($this->date_field); $this->calendar_levels[CDAY]['labels'][] = array_shift($this->calendar_levels[CDAY]['labels']); } }
/** * Initialize the calendar. * @param string $inner_sql */ function initialize($inner_sql) { parent::initialize($inner_sql); global $lang; $this->calendar_levels = array(array('sql' => pwg_db_get_year($this->date_field), 'labels' => null), array('sql' => pwg_db_get_month($this->date_field), 'labels' => $lang['month']), array('sql' => pwg_db_get_dayofmonth($this->date_field), 'labels' => null)); }