'id'
),
'AND', false
);
}
else
{
$inner_sql .= '
'.get_sql_condition_FandF
(
array
(
'forbidden_categories' => 'category_id',
'visible_categories' => 'category_id',
'visible_images' => 'id'
),
'WHERE', true
);
}
}
else
{
if ( empty($page['items']) )
{
return; // nothing to do
}
$inner_sql .= '
WHERE id IN (' . implode(',',$page['items']) .')';
}
//-------------------------------------- initialize the calendar parameters ---
pwg_debug('start initialize_calendar');
$fields = array(
// Created
'created' => array(
'label' => l10n('Creation date'),
),
// Posted
'posted' => array(
'label' => l10n('Post date'),
),
);
$styles = array(
// Monthly style
'monthly' => array(
'include' => 'calendar_monthly.class.php',
'view_calendar' => true,
),
// Weekly style
'weekly' => array(
'include' => 'calendar_weekly.class.php',
'view_calendar' => false,
),
);
$views = array(CAL_VIEW_LIST,CAL_VIEW_CALENDAR);
// Retrieve calendar field
isset( $fields[ $page['chronology_field'] ] ) or fatal_error('bad chronology field');
// Retrieve style
if ( !isset( $styles[ $page['chronology_style'] ] ) )
{
$page['chronology_style'] = 'monthly';
}
$cal_style = $page['chronology_style'];
include(PHPWG_ROOT_PATH.'include/'. $styles[$cal_style]['include']);
$calendar = new Calendar();
// Retrieve view
if ( !isset($page['chronology_view']) or
!in_array( $page['chronology_view'], $views ) )
{
$page['chronology_view'] = CAL_VIEW_LIST;
}
if ( CAL_VIEW_CALENDAR==$page['chronology_view'] and
!$styles[$cal_style]['view_calendar'] )
{
$page['chronology_view'] = CAL_VIEW_LIST;
}
// perform a sanity check on $requested
if (!isset($page['chronology_date']))
{
$page['chronology_date'] = array();
}
while ( count($page['chronology_date']) > 3)
{
array_pop($page['chronology_date']);
}
$any_count = 0;
for ($i = 0; $i < count($page['chronology_date']); $i++)
{
if ($page['chronology_date'][$i] == 'any')
{
if ($page['chronology_view'] == CAL_VIEW_CALENDAR)
{// we dont allow any in calendar view
while ($i < count($page['chronology_date']))
{
array_pop($page['chronology_date']);
}
break;
}
$any_count++;
}
elseif ($page['chronology_date'][$i] == '')
{
while ($i < count($page['chronology_date']))
{
array_pop($page['chronology_date']);
}
}
else
{
$page['chronology_date'][$i] = (int)$page['chronology_date'][$i];
}
}
if ($any_count == 3)
{
array_pop($page['chronology_date']);
}
$calendar->initialize($inner_sql);
//echo (''. var_export($calendar, true) . '
');
$must_show_list = true; // true until calendar generates its own display
if (script_basename() != 'picture') // basename without file extention
{
if ($calendar->generate_category_content())
{
$page['items'] = array();
$must_show_list = false;
}
$page['comment'] = '';
$template->assign('FILE_CHRONOLOGY_VIEW', 'month_calendar.tpl');
foreach ($styles as $style => $style_data)
{
foreach ($views as $view)
{
if ( $style_data['view_calendar'] or $view != CAL_VIEW_CALENDAR)
{
$selected = false;
if ($style!=$cal_style)
{
$chronology_date = array();
if ( isset($page['chronology_date'][0]) )
{
array_push($chronology_date, $page['chronology_date'][0]);
}
}
else
{
$chronology_date = $page['chronology_date'];
}
$url = duplicate_index_url(
array(
'chronology_style' => $style,
'chronology_view' => $view,
'chronology_date' => $chronology_date,
)
);
if ($style==$cal_style and $view==$page['chronology_view'] )
{
$selected = true;
}
$template->append(
'chronology_views',
array(
'VALUE' => $url,
'CONTENT' => l10n('chronology_'.$style.'_'.$view),
'SELECTED' => $selected,
)
);
}
}
}
$url = duplicate_index_url(
array(), array('start', 'chronology_date')
);
$calendar_title = ''
.$fields[$page['chronology_field']]['label'].'';
$calendar_title.= $calendar->get_display_name();
$template->assign('chronology',
array(
'TITLE' => $calendar_title
)
);
} // end category calling
if ($must_show_list)
{
$query = 'SELECT DISTINCT id '.get_extra_fields($conf['order_by']);
$query .= ','.$calendar->date_field;
$query .= $calendar->inner_sql.'
'.$calendar->get_date_where();
if ( isset($page['super_order_by']) )
{
$query .= '
'.$conf['order_by'];
}
else
{
if ( count($page['chronology_date'])==0
or in_array('any', $page['chronology_date']) )
{// selected period is very big so we show newest first
$order = ' DESC, ';
}
else
{// selected period is small (month,week) so we show oldest first
$order = ' ASC, ';
}
$order_by = str_replace(
'ORDER BY ',
'ORDER BY '.$calendar->date_field.$order, $conf['order_by']
);
$query .= '
'.$order_by;
}
$page['items'] = array_from_query($query, 'id');
}
pwg_debug('end initialize_calendar');
}
/*
* callback to sort array with date comparaison
*
**/
function date_compare(&$a, &$b)
{
$parts = explode('-', $a);
foreach ($parts as &$p) {
$p = (int)$p;
}
$a = implode('-', $parts);
$parts = explode('-', $b);
foreach ($parts as &$p) {
$p = (int)$p;
}
$b = implode('-', $parts);
return strcmp($a, $b);
}
?>