TRUE)); $url = url(current_path(), array('absolute' => TRUE)); $theme = db_query("SELECT * FROM {spider_calendar_block_theme_table} WHERE id=:id", array(':id' => $cal_theme))->fetchObject(); $cal_width = $theme->theme_width; $weekstart = $theme->week_start_day; $border_color = '#' . $theme->border_color; $border_radius = $theme->border_radius; $border_width = $theme->border_width; $border_radius2 = $border_radius - $border_width; $bg_bottom = '#' . $theme->body_bgcolor; $cell_height = $theme->cell_height; $text_color_other_months = '#' . $theme->omd_fcolor; $bg_color_other_months = '#' . $theme->omd_bgcolor; $text_color_this_month_unevented = '#' . $theme->cell_text_color_wevents; $evented_color = '#' . $theme->cell_text_color_events; $cell_text_color_selected_events = '#' . $theme->cell_text_color_selected_events; $evented_color_bg = '#' . $theme->cell_bgcolor_events; $cell_bgcolor_selected_events = '#' . $theme->cell_bgcolor_selected_events; $event_title_color = '#' . $theme->event_title_color; $current_day_border_color = '#' . $theme->cur_day_cell_border_color; $selected_day_cell_border_color = '#' . $theme->selected_day_cell_border_color; $cell_border_color = '#' . $theme->cell_border_color; $sun_days = '#' . $theme->sundays_tcolor; $sundays_bg_color = '#' . $theme->sundays_cell_bgcolor; $sundays_font_size = $theme->sundays_fcolor; $weekdays_font_size = $theme->days_fsize; $top_height = $theme->header_heidht; $bg_top = '#' . $theme->header_bgcolor; $year_font_size = $theme->year_font_size; $text_color_year = '#' . $theme->year_color; $color_arrow_year = '#' . $theme->year_arrow_color; $month_type = $theme->month_type; $text_color_month = '#' . $theme->cur_month_color; $month_font_size = $theme->cur_month_fsize; $color_arrow_month = '#' . $theme->month_arrow_color; $next_month_text_color = '#' . $theme->next_month_color; $next_month_font_size = $theme->next_month_fsize; $next_month_arrow_color = '#' . $theme->next_month_arrow_color; $prev_month_text_color = '#' . $theme->prev_month_color; $prev_month_font_size = $theme->prev_month_fsize; $prev_month_arrow_color = '#' . $theme->prev_month_arrow_color; $arrow_size = $theme->arrow_size; $arrow_size_hover = $arrow_size; $color_week_days = '#' . $theme->weekdays_color; $week_days_cell_height = $theme->week_cell_height; $weekdays_bg_color = '#' . $theme->weekdays_bgcolor; $weekday_sunday_bg_color = '#' . $theme->sunday_bgcolor; $other_days_font_size = $theme->weekdays_fsize; $all_days_border_width = $theme->all_days_border; $border_day = $all_days_border_width; $show_date_and_time_in_titlescloud = $theme->show_date_and_time_in_titlescloud; $show_titles_cloud = $theme->show_titles_cloud; $titles_cloud_text_color = $theme->titles_cloud_text_color; if (isset($_GET['block_id']) && (check_plain($_GET['block_id']) == $block_id) && isset($_GET['date'])) { $datee = check_plain($_GET['date']); $year = substr($datee, 0, 4); $month = substr($datee, 5, 2); $month = (substr($month, 0, 1) == 0) ? substr($month, 1, 1) : $month; $day = substr($datee, 8, 2); $year_REFERER = substr($datee, 0, 4); $month_REFERER = substr($datee, 5, 2); $month_REFERER = (substr($month_REFERER, 0, 1) == 0) ? substr($month_REFERER, 1, 1) : $month_REFERER; $day_REFERER = substr($datee, 8, 2); } else { $datee = date("Y-m-d"); $year = substr($datee, 0, 4); $month = substr($datee, 5, 2); $month = (substr($month, 0, 1) == 0) ? substr($month, 1, 1) : $month; $day = substr($datee, 8, 2); $year_REFERER = ''; $month_REFERER = ''; $day_REFERER = ''; } if (isset($_POST['date_block_year'])) { $year = $_POST['date_block_year']; } if (isset($_POST['date_block_month'])) { $month = $_POST['date_block_month']; } if ($month < 1) { --$year; $month = 12; } if ($month > 12) { ++$year; $month = 1; } if ($cell_height == '') { $cell_height = 25; } if ($cal_width == '') { $cal_width = 175; } $cell_width = $cal_width / 7; drupal_add_js(array( 'spider_calendar' => array( 'url_block' . $block_id => $url, 'date_block' . $block_id => $year, 'month_block' . $block_id => $month, 'site_url' => base_path() . drupal_get_path('module', 'spider_calendar') . '/images/', ), ), 'setting'); $block_content = '
更多
校曆表
'; if ($month_type == 1) { $block_content .= ' '; } if ($month_type == 2) { $block_content .= ' '; } $block_content .= ' '; if ($weekstart == "su") { $block_content .= ' '; } $block_content .= ' '; if ($weekstart == "mo") { $block_content .= ' '; } $block_content .= ' '; $month_first_weekday = date("N", mktime(0, 0, 0, $month, 1, $year)); if ($weekstart == "su") { $month_first_weekday++; if ($month_first_weekday == 8) { $month_first_weekday = 1; } } $month_days = date("t", mktime(0, 0, 0, $month, 1, $year)); $last_month_days = date("t", mktime(0, 0, 0, $month - 1, 1, $year)); $weekday_i = $month_first_weekday; $last_month_days = $last_month_days - $weekday_i + 2; $percent = 1; $sum = $month_days - 8 + $month_first_weekday; if ($sum % 7 <> 0) { $percent = $percent + 1; } $sum = $sum - ($sum % 7); $percent = $percent + ($sum / 7); $percent = 107 / $percent; $all_calendar_files = spider_calendar_block_getdays($cal_id, $cal_theme, $year, $month); $array_days = $all_calendar_files[0]['array_days']; $array_days1 = $all_calendar_files[0]['array_days1']; $title = $all_calendar_files[0]['title']; $ev_ids = $all_calendar_files[0]['ev_ids']; $block_content .= ' '; for ($i = 1; $i < $weekday_i; $i++) { $block_content .= ' '; $last_month_days = $last_month_days + 1; } for ($i = 1; $i <= $month_days; $i++) { if (isset($title[$i])) { $ev_title = explode('

', $title[$i]); array_pop($ev_title); $k = count($ev_title); $ev_id = explode('
', $ev_ids[$i]); array_pop($ev_id); $ev_ids_inline = implode(',', $ev_id); } $dayevent = ''; if (($weekday_i % 7 == 0 && $weekstart == "mo") || ($weekday_i % 7 == 1 && $weekstart == "su")) { if (($i == $day_REFERER) && ($month == $month_REFERER) && ($year == $year_REFERER)) { $if_show_cloud = 'onmouseover=\'spider_calendar_show_titles_list(event, "' . check_plain(spider_calendar_block_events_in_cloud($ev_ids_inline, $show_date_and_time_in_titlescloud, $titles_cloud_text_color)) . '")\' onmouseout="spider_calendar_hide_titles_list();"'; $block_content .= ' '; } elseif ($i == (int)date('j') && (spider_calendar_int_to_month_name($month) == date('F')) && $year == date('Y')) { if (in_array($i, $array_days)) { $if_show_cloud = 'onmouseover=\'spider_calendar_show_titles_list(event, "' . check_plain(spider_calendar_block_events_in_cloud($ev_ids_inline, $show_date_and_time_in_titlescloud, $titles_cloud_text_color)) . '")\' onmouseout="spider_calendar_hide_titles_list();"'; $block_content .= ' '; } else { $block_content .= ' '; } } else { if (in_array($i, $array_days)) { $if_show_cloud = 'onmouseover=\'spider_calendar_show_titles_list(event, "' . check_plain(spider_calendar_block_events_in_cloud($ev_ids_inline, $show_date_and_time_in_titlescloud, $titles_cloud_text_color)) . '")\' onmouseout="spider_calendar_hide_titles_list();"'; $block_content .= ' '; } else { $block_content .= ' '; } } } elseif ($i == $day_REFERER && $month == $month_REFERER && $year == $year_REFERER) { $if_show_cloud = 'onmouseover=\'spider_calendar_show_titles_list(event, "' . check_plain(spider_calendar_block_events_in_cloud($ev_ids_inline, $show_date_and_time_in_titlescloud, $titles_cloud_text_color)) . '")\' onmouseout="spider_calendar_hide_titles_list();"'; $block_content .= ' '; } else { if (($i == (int)date('j')) && (spider_calendar_int_to_month_name($month) == date('F')) && ($year == date('Y'))) { if (in_array ($i, $array_days)) { $if_show_cloud = 'onmouseover=\'spider_calendar_show_titles_list(event, "' . check_plain(spider_calendar_block_events_in_cloud($ev_ids_inline, $show_date_and_time_in_titlescloud, $titles_cloud_text_color)) . '")\' onmouseout="spider_calendar_hide_titles_list();"'; $block_content .= ' '; } else { $block_content .= ' '; } } elseif (in_array($i, $array_days)) { $if_show_cloud = 'onmouseover=\'spider_calendar_show_titles_list(event, "' . check_plain(spider_calendar_block_events_in_cloud($ev_ids_inline, $show_date_and_time_in_titlescloud, $titles_cloud_text_color)) . '")\' onmouseout="spider_calendar_hide_titles_list();"'; $block_content .= ' '; } else { $block_content .= ' '; } } if ($weekday_i % 7 == 0 && $i <> $month_days) { $block_content .= ' '; $weekday_i = 0; } $weekday_i = $weekday_i + 1; } $weekday_i; $next_i = 1; if ($weekday_i != 1) for ($i = $weekday_i; $i <= 7; $i++) { if ($i != 7) { $block_content .= ' '; } else { $block_content .= ' '; } $next_i = $next_i + 1; } $block_content .= '
'; $block_content .= l(t('◄'), '', array('attributes' => array('class' => 'ahref_block_' . $block_id, 'rel' => '1', 'style' => 'color:' . $color_arrow_year), 'html' => TRUE)); $block_content .= ' ' . $year . ' '; $block_content .= l(t('►'), '', array('attributes' => array('class' => 'ahref_block_' . $block_id, 'rel' => '2', 'style' => 'color:' . $color_arrow_year), 'html' => TRUE)); $block_content .= '
'; $block_content .= l(t('◄'), '', array('attributes' => array('class' => 'ahref_block_' . $block_id, 'rel' => '3', 'style' => 'color:' . $prev_month_arrow_color), 'html' => TRUE)); $block_content .= ' ' . (($month - 1 < 1) ? spider_calendar_int_to_month_name(12) : spider_calendar_int_to_month_name($month - 1)) . '
' . spider_calendar_int_to_month_name($month) . '
' . (($month + 1 > 12) ? spider_calendar_int_to_month_name(1) : spider_calendar_int_to_month_name($month + 1)) . '  '; $block_content .= l(t('►'), '', array('attributes' => array('class' => 'ahref_block_' . $block_id, 'rel' => '4', 'style' => 'color:' . $next_month_arrow_color), 'html' => TRUE)); $block_content .= '
'; $block_content .= l(t('◄'), '', array('attributes' => array('class' => 'ahref_block_' . $block_id, 'rel' => '1', 'style' => 'color:' . $color_arrow_year), 'html' => TRUE)); $block_content .= ' ' . $year . ' '; $block_content .= l(t('►'), '', array('attributes' => array('class' => 'ahref_block_' . $block_id, 'rel' => '2', 'style' => 'color:' . $color_arrow_year), 'html' => TRUE)); $block_content .= '
'; $block_content .= l(t('◄'), '', array('attributes' => array('class' => 'ahref_block_' . $block_id, 'rel' => '3', 'style' => 'color:' . $color_arrow_month), 'html' => TRUE)); $block_content .= ' ' . spider_calendar_int_to_month_name($month) . ' '; $block_content .= l(t('►'), '', array('attributes' => array('class' => 'ahref_block_' . $block_id, 'rel' => '4', 'style' => 'color:' . $color_arrow_month), 'html' => TRUE)); $block_content .= '
' . t('Su') . '
'. t('Mo') . '
'. t('Tu') . '
'. t('We') . '
'. t('Th') . '
'. t('Fr') . '
'. t('Sa') . '
'. t('Su') . '
' . $last_month_days . '
' . $i . '
' . $i . ' ' . $i . ' ' . $i . ' ' . $i . '
' . $i . '
' . $i . ' ' . $i . ' ' . $i . ' ' . $i . '
' . $next_i . ' ' . $next_i . '
'; $block_content .= '
'; return $block_content; } function spider_calendar_block_show2($cal_id, $cal_theme, $block_id) { require_once "spider_calendar_view.inc"; drupal_add_js(drupal_get_path('module', 'spider_calendar') . '/js/spider_calendar_events_cloud.js'); if (arg(0) == 'node' && is_numeric(arg(1))) { $nodeid = arg(1); } $many_sp_calendar = $block_id; drupal_add_js(drupal_get_path('module', 'spider_calendar') . '/js/spider_calendar_block.js'); // $url = url('spider_calendar_block', array('absolute' => TRUE)); $url = url(current_path(), array('absolute' => TRUE)); $theme = db_query("SELECT * FROM {spider_calendar_block_theme_table} WHERE id=:id", array(':id' => $cal_theme))->fetchObject(); $cal_width = $theme->theme_width; $weekstart = $theme->week_start_day; $border_color = '#' . $theme->border_color; $border_radius = $theme->border_radius; $border_width = $theme->border_width; $border_radius2 = $border_radius - $border_width; $bg_bottom = '#' . $theme->body_bgcolor; $cell_height = $theme->cell_height; $text_color_other_months = '#' . $theme->omd_fcolor; $bg_color_other_months = '#' . $theme->omd_bgcolor; $text_color_this_month_unevented = '#' . $theme->cell_text_color_wevents; $evented_color = '#' . $theme->cell_text_color_events; $cell_text_color_selected_events = '#' . $theme->cell_text_color_selected_events; $evented_color_bg = '#' . $theme->cell_bgcolor_events; $cell_bgcolor_selected_events = '#' . $theme->cell_bgcolor_selected_events; $event_title_color = '#' . $theme->event_title_color; $current_day_border_color = '#' . $theme->cur_day_cell_border_color; $selected_day_cell_border_color = '#' . $theme->selected_day_cell_border_color; $cell_border_color = '#' . $theme->cell_border_color; $sun_days = '#' . $theme->sundays_tcolor; $sundays_bg_color = '#' . $theme->sundays_cell_bgcolor; $sundays_font_size = $theme->sundays_fcolor; $weekdays_font_size = $theme->days_fsize; $top_height = $theme->header_heidht; $bg_top = '#' . $theme->header_bgcolor; $year_font_size = $theme->year_font_size; $text_color_year = '#' . $theme->year_color; $color_arrow_year = '#' . $theme->year_arrow_color; $month_type = $theme->month_type; $text_color_month = '#' . $theme->cur_month_color; $month_font_size = $theme->cur_month_fsize; $color_arrow_month = '#' . $theme->month_arrow_color; $next_month_text_color = '#' . $theme->next_month_color; $next_month_font_size = $theme->next_month_fsize; $next_month_arrow_color = '#' . $theme->next_month_arrow_color; $prev_month_text_color = '#' . $theme->prev_month_color; $prev_month_font_size = $theme->prev_month_fsize; $prev_month_arrow_color = '#' . $theme->prev_month_arrow_color; $arrow_size = $theme->arrow_size; $arrow_size_hover = $arrow_size; $color_week_days = '#' . $theme->weekdays_color; $week_days_cell_height = $theme->week_cell_height; $weekdays_bg_color = '#' . $theme->weekdays_bgcolor; $weekday_sunday_bg_color = '#' . $theme->sunday_bgcolor; $other_days_font_size = $theme->weekdays_fsize; $all_days_border_width = $theme->all_days_border; $border_day = $all_days_border_width; $show_date_and_time_in_titlescloud = $theme->show_date_and_time_in_titlescloud; $show_titles_cloud = $theme->show_titles_cloud; $titles_cloud_text_color = $theme->titles_cloud_text_color; if (isset($_GET['block_id']) && (check_plain($_GET['block_id']) == $block_id) && isset($_GET['date'])) { $datee = check_plain($_GET['date']); $year = substr($datee, 0, 4); $month = substr($datee, 5, 2); $month = (substr($month, 0, 1) == 0) ? substr($month, 1, 1) : $month; $day = substr($datee, 8, 2); $year_REFERER = substr($datee, 0, 4); $month_REFERER = substr($datee, 5, 2); $month_REFERER = (substr($month_REFERER, 0, 1) == 0) ? substr($month_REFERER, 1, 1) : $month_REFERER; $day_REFERER = substr($datee, 8, 2); } else { $datee = date("Y-m-d"); $year = substr($datee, 0, 4); $month = substr($datee, 5, 2); $month = (substr($month, 0, 1) == 0) ? substr($month, 1, 1) : $month; $day = substr($datee, 8, 2); $year_REFERER = ''; $month_REFERER = ''; $day_REFERER = ''; } if (isset($_POST['date_block_year'])) { $year = $_POST['date_block_year']; } if (isset($_POST['date_block_month'])) { $month = $_POST['date_block_month']; } if ($month < 1) { --$year; $month = 12; } if ($month > 12) { ++$year; $month = 1; } if ($cell_height == '') { $cell_height = 25; } if ($cal_width == '') { $cal_width = 175; } $cell_width = $cal_width / 7; drupal_add_js(array( 'spider_calendar' => array( 'url_block' . $block_id => $url, 'date_block' . $block_id => $year, 'month_block' . $block_id => $month, 'site_url' => base_path() . drupal_get_path('module', 'spider_calendar') . '/images/', ), ), 'setting'); $block_content = '
日曆
'; if ($month_type == 1) { $block_content .= ' '; } if ($month_type == 2) { $block_content .= ' '; } $block_content .= ' '; if ($weekstart == "su") { $block_content .= ' '; } $block_content .= ' '; if ($weekstart == "mo") { $block_content .= ' '; } $block_content .= ' '; $month_first_weekday = date("N", mktime(0, 0, 0, $month, 1, $year)); if ($weekstart == "su") { $month_first_weekday++; if ($month_first_weekday == 8) { $month_first_weekday = 1; } } $month_days = date("t", mktime(0, 0, 0, $month, 1, $year)); $last_month_days = date("t", mktime(0, 0, 0, $month - 1, 1, $year)); $weekday_i = $month_first_weekday; $last_month_days = $last_month_days - $weekday_i + 2; $percent = 1; $sum = $month_days - 8 + $month_first_weekday; if ($sum % 7 <> 0) { $percent = $percent + 1; } $sum = $sum - ($sum % 7); $percent = $percent + ($sum / 7); $percent = 107 / $percent; $all_calendar_files = spider_calendar_block_getdays($cal_id, $cal_theme, $year, $month); $array_days = $all_calendar_files[0]['array_days']; $array_days1 = $all_calendar_files[0]['array_days1']; $title = $all_calendar_files[0]['title']; $ev_ids = $all_calendar_files[0]['ev_ids']; $block_content .= ' '; for ($i = 1; $i < $weekday_i; $i++) { $block_content .= ' '; $last_month_days = $last_month_days + 1; } for ($i = 1; $i <= $month_days; $i++) { if (isset($title[$i])) { $ev_title = explode('

', $title[$i]); array_pop($ev_title); $k = count($ev_title); $ev_id = explode('
', $ev_ids[$i]); array_pop($ev_id); $ev_ids_inline = implode(',', $ev_id); } $dayevent = ''; if (($weekday_i % 7 == 0 && $weekstart == "mo") || ($weekday_i % 7 == 1 && $weekstart == "su")) { if (($i == $day_REFERER) && ($month == $month_REFERER) && ($year == $year_REFERER)) { $if_show_cloud = 'onmouseover=\'spider_calendar_show_titles_list(event, "' . check_plain(spider_calendar_block_events_in_cloud($ev_ids_inline, $show_date_and_time_in_titlescloud, $titles_cloud_text_color)) . '")\' onmouseout="spider_calendar_hide_titles_list();"'; $block_content .= ' '; } elseif ($i == (int)date('j') && (spider_calendar_int_to_month_name($month) == date('F')) && $year == date('Y')) { if (in_array($i, $array_days)) { $if_show_cloud = 'onmouseover=\'spider_calendar_show_titles_list(event, "' . check_plain(spider_calendar_block_events_in_cloud($ev_ids_inline, $show_date_and_time_in_titlescloud, $titles_cloud_text_color)) . '")\' onmouseout="spider_calendar_hide_titles_list();"'; $block_content .= ' '; } else { $block_content .= ' '; } } else { if (in_array($i, $array_days)) { $if_show_cloud = 'onmouseover=\'spider_calendar_show_titles_list(event, "' . check_plain(spider_calendar_block_events_in_cloud($ev_ids_inline, $show_date_and_time_in_titlescloud, $titles_cloud_text_color)) . '")\' onmouseout="spider_calendar_hide_titles_list();"'; $block_content .= ' '; } else { $block_content .= ' '; } } } elseif ($i == $day_REFERER && $month == $month_REFERER && $year == $year_REFERER) { $if_show_cloud = 'onmouseover=\'spider_calendar_show_titles_list(event, "' . check_plain(spider_calendar_block_events_in_cloud($ev_ids_inline, $show_date_and_time_in_titlescloud, $titles_cloud_text_color)) . '")\' onmouseout="spider_calendar_hide_titles_list();"'; $block_content .= ' '; } else { if (($i == (int)date('j')) && (spider_calendar_int_to_month_name($month) == date('F')) && ($year == date('Y'))) { if (in_array ($i, $array_days)) { $if_show_cloud = 'onmouseover=\'spider_calendar_show_titles_list(event, "' . check_plain(spider_calendar_block_events_in_cloud($ev_ids_inline, $show_date_and_time_in_titlescloud, $titles_cloud_text_color)) . '")\' onmouseout="spider_calendar_hide_titles_list();"'; $block_content .= ' '; } else { $block_content .= ' '; } } elseif (in_array($i, $array_days)) { $if_show_cloud = 'onmouseover=\'spider_calendar_show_titles_list(event, "' . check_plain(spider_calendar_block_events_in_cloud($ev_ids_inline, $show_date_and_time_in_titlescloud, $titles_cloud_text_color)) . '")\' onmouseout="spider_calendar_hide_titles_list();"'; $block_content .= ' '; } else { $url_alias = drupal_get_path_alias($_GET['q']); $split_url = explode('/', $url_alias); if($weekday_i % 7 == 0) { $block_content .= ' '; } else { $block_content .= ' '; } } } if ($weekday_i % 7 == 0 && $i <> $month_days) { $block_content .= ' '; $weekday_i = 0; } $weekday_i = $weekday_i + 1; } $weekday_i; $next_i = 1; if ($weekday_i != 1) for ($i = $weekday_i; $i <= 7; $i++) { if ($i != 7) { $block_content .= ' '; } else { $block_content .= ' '; } $next_i = $next_i + 1; } $block_content .= '
'; $block_content .= l(t('◄'), '', array('attributes' => array('class' => 'ahref_block_' . $block_id, 'rel' => '1', 'style' => 'color:' . $color_arrow_year), 'html' => TRUE)); $block_content .= ' ' . $year . ' '; $block_content .= l(t('►'), '', array('attributes' => array('class' => 'ahref_block_' . $block_id, 'rel' => '2', 'style' => 'color:' . $color_arrow_year), 'html' => TRUE)); $block_content .= '
'; $block_content .= l(t('◄'), '', array('attributes' => array('class' => 'ahref_block_' . $block_id, 'rel' => '3', 'style' => 'color:' . $prev_month_arrow_color), 'html' => TRUE)); $block_content .= ' ' . (($month - 1 < 1) ? spider_calendar_int_to_month_name(12) : spider_calendar_int_to_month_name($month - 1)) . '
' . spider_calendar_int_to_month_name($month) . '
' . (($month + 1 > 12) ? spider_calendar_int_to_month_name(1) : spider_calendar_int_to_month_name($month + 1)) . '  '; $block_content .= l(t('►'), '', array('attributes' => array('class' => 'ahref_block_' . $block_id, 'rel' => '4', 'style' => 'color:' . $next_month_arrow_color), 'html' => TRUE)); $block_content .= '
'; $block_content .= l(t('◄'), '', array('attributes' => array('class' => 'ahref_block_' . $block_id, 'rel' => '1', 'style' => 'color:' . $color_arrow_year), 'html' => TRUE)); $block_content .= ' ' . $year . ' '; $block_content .= l(t('►'), '', array('attributes' => array('class' => 'ahref_block_' . $block_id, 'rel' => '2', 'style' => 'color:' . $color_arrow_year), 'html' => TRUE)); $block_content .= '
'; $block_content .= l(t('◄'), '', array('attributes' => array('class' => 'ahref_block_' . $block_id, 'rel' => '3', 'style' => 'color:' . $color_arrow_month), 'html' => TRUE)); $block_content .= ' ' . spider_calendar_int_to_month_name($month) . ' '; $block_content .= l(t('►'), '', array('attributes' => array('class' => 'ahref_block_' . $block_id, 'rel' => '4', 'style' => 'color:' . $color_arrow_month), 'html' => TRUE)); $block_content .= '
' . t('Su') . '
'. t('Mo') . '
'. t('Tu') . '
'. t('We') . '
'. t('Th') . '
'. t('Fr') . '
'. t('Sa') . '
'. t('Su') . '
' . $last_month_days . '
' . $i . '
' . $i . ' ' . $i . ' ' . $i . ' ' . $i . '
' . $i . '
' . $i . ' ' . $i . ' ' . $i . ' ' . $i . ' ' . $i . '
' . $next_i . ' ' . $next_i . '
'; $block_content .= '
'; return $block_content; } /** * Return block calendar event repeat days depend on repeat method. */ function spider_calendar_block_getdays($cal_id, $cal_theme, $year, $month) { $date = date("Y") . '-' . date("n") . '-' . date("d"); $date = $year . '-' . spider_calendar_add_0($month); $year = substr($date, 0, 4); $month = substr($date, 5, 2); $theme = db_query("SELECT * FROM {spider_calendar_block_theme_table} WHERE id=:id", array(':id' => $cal_theme))->fetchObject(); $show_time = $theme->time_in_cell; $row = db_query("SELECT id FROM {spider_calendar_events_table} WHERE published=:published and (((event_date <= :event_date or event_date like :event_date) and event_date_end >= :event_date_end) or (event_date_end=:event_date_end and event_date like :event_date)) and calendar=:calendar", array(':published' => 1, ':event_date' => substr($date, 0, 7) . '-01', ':event_date' => db_like(substr($date, 0, 7)) . '%', ':event_date_end' => substr($date, 0, 7) . '-01', ':event_date_end' => '', ':event_date' => db_like(substr($date, 0, 7)) . '%', ':calendar' => $cal_id))->fetchCol(); // $result = db_query("SELECT id FROM {spider_calendar_events_table} WHERE published=1 and (((event_date <= '" . substr($date, 0, 7) . "-01' or event_date like '" . substr($date, 0, 7) . "%') and event_date_end >= '" . substr($date, 0, 7) . "-01') or (event_date_end='' and event_date like '" . substr($date, 0, 7) . "%')) and calendar='%d'", $cal_id); $s = count($row); $id_array = array(); $array_days = array(); $array_days1 = array(); $title = array(); $ev_ids = array(); for ($i = 0; $i < $s; $i++) { $rows = db_query("SELECT * FROM {spider_calendar_events_table} WHERE id=:id", array(':id' => $row[$i]))->fetchObject(); $date_month = (int)substr($rows->event_date, 5, 2); $date_end_month = (int)substr($rows->event_date_end, 5, 2); $date_day = (int)substr($rows->event_date, 8, 2); $date_end_day = (int)substr($rows->event_date_end, 8, 2); $date_year_month = (int)(substr($rows->event_date, 0, 4) . substr($rows->event_date, 5, 2)); $date_end_year_month = (int)(substr($rows->event_date_end, 0, 4) . substr($rows->event_date_end, 5, 2)); $date_start_year = (int)(substr($rows->event_date, 0, 4)); $date_end_year = (int)(substr($rows->event_date_end, 0, 4)); $year_month = (int)($year . $month); $repeat = $rows->event_repeat; if ($repeat == "") { $repeat = 1; } $start_date = $rows->event_date; $weekly = $rows->week; $weekly_array = explode(',', $weekly); $date_days = array(); $weekdays_start = array(); $weekdays = array(); // No Repeat. if ($rows->repeat_method == 'no_repeat') { $date_days[] = $date_day; } // Repeat daily. if ($rows->repeat_method == 'daily') { $t = spider_calendar_php_days_difference($rows->event_date, $rows->event_date_end); for ($k = 1; $k <= $t / $repeat; $k++) { $next_date = spider_calendar_php_get_next_date($start_date, $repeat); $next_date_array = explode('/', $next_date); if ((int)$month == $date_month && (int)substr($date_year_month, 0, 4) == (int)$year) { $date_days[0] = $date_day; } if ((int)$month == $next_date_array[0] && (int)$year == $next_date_array[2]) { $date_days[] = $next_date_array[1]; } $start_date = date("Y-m-d", mktime(0, 0, 0, $next_date_array[0], $next_date_array[1], $next_date_array[2])); } } // Repeat weekly. if ($rows->repeat_method == 'weekly') { for ($j = 0; $j <= 6; $j++) { if (in_array(date("D", mktime(0, 0, 0, $date_month, $date_day + $j, substr($rows->event_date, 0, 4))), $weekly_array)) { $weekdays_start[] = $date_day + $j; } } for ($p = 0; $p < count($weekly_array) - 1; $p++) { $start_date = substr($rows->event_date, 0, 8) . $weekdays_start[$p]; $t = spider_calendar_php_days_difference($rows->event_date, $rows->event_date_end); $r = 0; for ($k = 1; $k < $t / $repeat; $k++) { $start_date_array[] = $start_date; $next_date = spider_calendar_php_get_next_date($start_date, $repeat * 7); $next_date_array = explode('/', $next_date); if ((int)$month == $date_month && (int)substr($date_year_month, 0, 4) == (int)$year) $date_days[0] = $weekdays_start[$p]; if ((int)$month == $next_date_array[0] && (int)$year == $next_date_array[2]) { if ((int)$year > (int)substr($date_year_month, 0, 4)) { $weekdays[] = $next_date_array[1]; } else { $weekdays[] = $next_date_array[1]; } } $start_date = date("Y-m-d", mktime(0, 0, 0, $next_date_array[0], $next_date_array[1], $next_date_array[2])); if ($next_date_array[2] > (int)substr($rows->event_date_end, 0, 4)) break; } $date_days = array_merge($weekdays, $date_days); } $repeat = $repeat * 7; } // Repeat Monthly. if ($rows->repeat_method == 'monthly') { $xxxxx = 13; $year_dif_count = (int)$year - (int)substr($rows->event_date, 0, 4); $mount_dif_count = 12 - (int)substr($rows->event_date, 5, 2) + (($year_dif_count - 1) * 12); if ($year_dif_count > 0) for ($my_serch_month = 1; $my_serch_month <= 12; $my_serch_month++) { if ((($mount_dif_count + $my_serch_month) % $rows->event_repeat) == 0) { $xxxxx = $my_serch_month; break; } } if ($xxxxx != 13) { if ($xxxxx < 10) { $xxxxx = '0' . $xxxxx; } } $month_days = date('t', mktime(0, 0, 0, $month, $date_day, $year)); if ($date_month < (int)$month or (int)substr($date_year_month, 0, 4) < $year) $date_day = 1; if ($year > (int)substr($date_year_month, 0, 4)) $date_year_month = $year . $xxxxx; $p = (int)substr($date_year_month, 4, 2); if ((int)substr($date_year_month, 0, 4) != (int)substr($date_end_year_month, 0, 4)) $end = (int)substr($date_end_year_month, 4, 2) + 12; else $end = (int)substr($date_end_year_month, 4, 2); for ($k = 1; $k <= $end; $k++) { if ((int)$month == $p && $rows->month_type == 1) { $date_days[0] = $rows->month; } if ($p == (int)$month && $rows->month_type == 2) { if ($rows->month_list != 'last') { for ($j = (int)$rows->month_list; $j < (int)$rows->month_list + 7; $j++) { if (date("D", mktime(0, 0, 0, $month, $j, $year)) == $rows->month_week) { if ($j >= $date_day) { $date_days[0] = $j; } } } } else { for ($j = 1; $j <= $month_days; $j++) { if (date("D", mktime(0, 0, 0, $month, $j, $year)) == $rows->month_week) { if ($j >= $date_day) { $date_days[0] = $j; } } } } } if ($year > (int)substr($date_year_month, 0, 4)) { $p = 1; } $p = $p + $repeat; } $repeat = 32; } // Repeat yearly. if ($rows->repeat_method == 'yearly') { $month_days = date('t', mktime(0, 0, 0, $month, $date_day, $year)); $end = substr($date_end_year_month, 0, 4) - substr($date_year_month, 0, 4) + 1; if (substr($date_year_month, 0, 4) < $year) { $date_day = 1; } for ($k = 0; $k <= $end; $k += $repeat) { if ((int)$month == (int)$rows->years_month && $rows->month_type == 1 && $year == substr($date_year_month, 0, 4) + $k) { $date_days[0] = $rows->month; } } for ($k = 0; $k <= $end; $k += $repeat) { if ((int)$month == (int)$rows->years_month && $rows->month_type == 2 && $year == substr($date_year_month, 0, 4) + $k) { if ($rows->month_list != 'last') { for ($j = (int)$rows->month_list; $j < (int)$rows->month_list + 7; $j++) { if (date("D", mktime(0, 0, 0, $month, $j, $year)) == $rows->month_week) { $date_days[0] = $j; } } } else { for ($j = 1; $j <= $month_days; $j++) { if (date("D", mktime(0, 0, 0, $month, $j, $year)) == $rows->month_week) { $date_days[0] = $j; } } } } } $repeat = 32; } $used = array(); foreach ($date_days as $date_day) { if ($date_month == $month && $date_start_year == $year && $date_end_year == 0) { if (in_array($date_day, $used)) { continue; } else { array_push($used, $date_day); } if (in_array($date_day, $array_days)) { $key = array_search($date_day, $array_days); $title_num[$date_day]++; if ($rows->text != "") $array_days1[$key] = $date_day; $c = $title_num[$date_day]; $list = '

' . $c . '.  '; if ($rows->event_time && $show_time != 0) { $list .= ' ' . check_plain($rows->title) . '
(' . $rows->event_time . ')

'; } else { $list .= ' ' . check_plain($rows->title) . '

'; } $title[$date_day] = $title[$date_day] . $list; $ev_ids[$date_day] = $ev_ids[$date_day] . $rows->id . '
'; } else { $array_days[] = $date_day; $key = array_search($date_day, $array_days); if ($rows->text != "") { $array_days1[$key] = $date_day; } $title_num[$date_day] = 1; $c = 1; $list = '

' . $c . '.  '; if ($rows->event_time && $show_time != 0) { $list .= ' ' . check_plain($rows->title) . '
(' . $rows->event_time . ')

'; } else { $list .= ' ' . check_plain($rows->title) . '

'; } $title[$date_day] = $list; $ev_ids[$date_day] = $rows->id . '
'; } } if ($date_end_month > 0 && $date_year_month == $date_end_year_month && $date_end_year_month == $year_month) { for ($j = $date_day; $j <= $date_end_day; $j = $j + $repeat) { if (in_array($j, $used)) continue; else array_push($used, $j); if (in_array($j, $array_days)) { $key = array_search($j, $array_days); $title_num[$j]++; if ($rows->text != "") { $array_days1[$key] = $j; } $c = $title_num[$j]; $list = '

' . $c . '.  '; if ($rows->event_time && $show_time != 0) { $list .= ' ' . check_plain($rows->title) . '
(' . $rows->event_time . ')

'; } else { $list .= ' ' . check_plain($rows->title) . '

'; } $title[$j] = $title[$j] . $list; $ev_ids[$j] = $ev_ids[$j] . $rows->id . '
'; } else { $array_days[] = $j; $key = array_search($j, $array_days); if ($rows->text != "") { $array_days1[$key] = $j; } $title_num[$j] = 1; $c = 1; $list = '

' . $c . '.  '; if ($rows->event_time && $show_time != 0) { $list .= ' ' . check_plain($rows->title) . '
(' . $rows->event_time . ')

'; } else { $list .= ' ' . check_plain($rows->title) . '

'; } $title[$j] = $list; $ev_ids[$j] = $rows->id . '
'; } } } if ($date_end_month > 0 && $date_year_month < $date_end_year_month && $date_year_month == $year_month) for ($j = $date_day; $j <= 31; $j = $j + $repeat) { if (in_array($j, $used)) { continue; } else { array_push($used, $j); } if (in_array($j, $array_days)) { $key = array_search($j, $array_days); $title_num[$j]++; if ($rows->text != "") $array_days1[$key] = $j; $c = $title_num[$j]; $list = '

' . $c . '.  '; if ($rows->event_time && $show_time != 0) { $list .= ' ' . check_plain($rows->title) . '
(' . $rows->event_time . ')

'; } else { $list .= ' ' . check_plain($rows->title) . '

'; } $title[$j] = $title[$j] . $list; $ev_ids[$j] = $ev_ids[$j] . $rows->id . '
'; } else { $array_days[] = $j; $key = array_search($j, $array_days); if ($rows->text != "") { $array_days1[$key] = $j; } $title_num[$j] = 1; $c = 1; $list = '

' . $c . '.  '; if ($rows->event_time && $show_time != 0) { $list .= ' ' . check_plain($rows->title) . '
(' . $rows->event_time . ')

'; } else { $list .= ' ' . check_plain($rows->title) . '

'; } $title[$j] = $list; $ev_ids[$j] = $rows->id . '
'; } } if ($date_end_month > 0 && $date_year_month < $date_end_year_month && $date_end_year_month == $year_month) { for ($j = $date_day; $j <= $date_end_day; $j = $j + $repeat) { if (in_array($j, $used)) { continue; } else { array_push($used, $j); } if (in_array($j, $array_days)) { $key = array_search($j, $array_days); $title_num[$j]++; if ($rows->text != "") { $array_days1[$key] = $j; } $c = $title_num[$j]; $list = '

' . $c . '.  '; if ($rows->event_time && $show_time != 0) { $list .= ' ' . check_plain($rows->title) . '
(' . $rows->event_time . ')

'; } else { $list .= ' ' . check_plain($rows->title) . '

'; } $title[$j] = $title[$j] . $list; $ev_ids[$j] = $ev_ids[$j] . $rows->id . '
'; } else { $array_days[] = $j; $key = array_search($j, $array_days); if ($rows->text != "") { $array_days1[$key] = $j; } $title_num[$j] = 1; $c = 1; $list = '

' . $c . '.  '; if ($rows->event_time && $show_time != 0) { $list .= ' ' . check_plain($rows->title) . '
(' . $rows->event_time . ')

'; } else { $list .= ' ' . check_plain($rows->title) . '

'; } $title[$j] = $list; $ev_ids[$j] = $rows->id . '
'; } } } if ($date_end_month > 0 && $date_year_month < $date_end_year_month && $date_end_year_month > $year_month && $date_year_month < $year_month) { for ($j = $date_day; $j <= 31; $j = $j + $repeat) { if (in_array($j, $used)) { continue; } else { array_push($used, $j); } if (in_array($j, $array_days)) { $key = array_search($j, $array_days); $title_num[$j]++; if ($rows->text != "") { $array_days1[$key] = $j; } $c = $title_num[$j]; $list = '

' . $c . '.  '; if ($rows->event_time && $show_time != 0) { $list .= ' ' . check_plain($rows->title) . '
(' . $rows->event_time . ')

'; } else { $list .= ' ' . check_plain($rows->title) . '

'; } $title[$j] = $title[$j] . $list; $ev_ids[$j] = $ev_ids[$j] . $rows->id . '
'; } else { $array_days[] = $j; $key = array_search($j, $array_days); if ($rows->text != "") { $array_days1[$key] = $j; } $title_num[$j] = 1; $c = 1; $list = '

' . $c . '.  '; if ($rows->event_time && $show_time != 0) { $list .= ' ' . check_plain($rows->title) . '
(' . $rows->event_time . ')

'; } else { $list .= ' ' . check_plain($rows->title) . '

'; } $title[$j] = $list; $ev_ids[$j] = $rows->id . '
'; } } } } } for ($i = 1; $i <= count($array_days) - 1; $i++) { if (isset($array_days[$i])) { if ($array_days[$i] > '00' && $array_days[$i] < '09' && substr($array_days[$i], 0, 1) == '0') { $array_days[$i] = substr($array_days[$i], 1, 1); } } } $all_calendar_files['array_days'] = $array_days; $all_calendar_files['title'] = $title; //$all_calendar_files['option'] = $option; $all_calendar_files['array_days1'] = $array_days1; //$all_calendar_files['calendar'] = $calendar; $all_calendar_files['ev_ids'] = $ev_ids; return array($all_calendar_files); } /** * Block calendar events list. */ function spider_calendar_block_events_in_cloud($ev_ids, $show_date_and_time_in_titlescloud, $titles_cloud_text_color) { $ev_id = explode(',', $ev_ids); $block_events_list = ''; foreach ($ev_id as $row) { $event_row = db_query("SELECT * FROM {spider_calendar_events_table} WHERE id=:id", array(':id' => (int)$row))->fetchObject(); $date = ""; for ($i = 0; $i < count($ev_id); $i++) { if ($event_row->id == $ev_id[$i]) { if ($show_date_and_time_in_titlescloud == 1) { $date_and_time = $event_row->event_date . ' - ' . $event_row->event_date_end . ' ' . $event_row->event_time; $date = '

' . $event_row->event_date . '

'; } else { $date_and_time = ''; } $block_events_list .= '

' . ($i + 1) . '. ' . ' ' . addslashes($event_row->title) . '

'; } } } return $date . $block_events_list; }