function &fetch_calendar_period($params = array(), $sql_params = array())
{
$start_date = $params['start_date'];
$finish_date = $params['finish_date'];
$sql_params['conditions'][] = ' AND sso.locale_id = "' . CONTENT_LOCALE_ID . '"';
$sql_params['conditions'][] = " AND tn.start_date >= '{$start_date}' \r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND tn.start_date <= '{$finish_date}' ";
$result =& parent::fetch_accessible($params, $sql_params);
return $result;
}
function & fetch_publish_period($params=array(), $sql_params=array())
{
$start_date = $params['start_date'];
$finish_date = $params['finish_date'];
$sql_params['conditions'][] =
" AND ((tn.start_date >= '{$start_date}' AND tn.start_date <= '{$finish_date}')
OR (tn.finish_date >= '{$start_date}' AND tn.finish_date <= '{$finish_date}')) ";
$result =& parent :: fetch_accessible($params, $sql_params);
return $result;
}
