function &fetch_calendar_period_by_ids($ids_array, $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_by_ids($ids_array, $params, $sql_params); return $result; }
function & fetch_publish_period_by_ids($ids_array, $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 sso.id=tn.object_id AND sso.current_version=tn.version"; $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}')) "; return parent :: fetch_accessible_by_ids($ids_array, $params, $sql_params); }