All pastes #980920 Raw Edit

yn_get_calendar

public php v1 · immutable
·published 2008-04-11 11:50 UTC
rendered paste body
// ==================================================function yn_get_calendar($initial = true, $fix_height = false) {	global $wpdb, $m, $monthnum, $year, $wp_locale, $posts;	$key = md5( $m . $monthnum . $year );	if ( $cache = wp_cache_get( 'get_calendar', 'calendar' ) ) {		if ( isset( $cache[ $key ] ) ) {			echo $cache[ $key ];			return;		}	}	ob_start();	if ( isset($_GET['w']) )		$w = ''.intval($_GET['w']);	// week_begins = 0 stands for Sunday	$week_begins = intval(get_option('start_of_week'));	// Let's figure out when we are	if ( !empty($monthnum) && !empty($year) ) {		$thismonth = ''.zeroise(intval($monthnum), 2);		$thisyear = ''.intval($year);	} elseif ( !empty($w) ) {		// We need to get the month from MySQL		$thisyear = ''.intval(substr($m, 0, 4));		$d = (($w - 1) * 7) + 6; //it seems MySQL's weeks disagree with PHP's		$thismonth = $wpdb->get_var("SELECT DATE_FORMAT((DATE_ADD('${thisyear}0101', INTERVAL $d DAY) ), '%m')");	} elseif ( !empty($m) ) {		$thisyear = ''.intval(substr($m, 0, 4));		if ( strlen($m) < 6 )				$thismonth = '01';		else				$thismonth = ''.zeroise(intval(substr($m, 4, 2)), 2);	} else {		$thisyear = gmdate('Y', current_time('timestamp'));		$thismonth = gmdate('m', current_time('timestamp'));	}	$unixmonth = mktime(0, 0 , 0, $thismonth, 1, $thisyear);	echo '<table id="wp-calendar" summary="' . __('Calendar') . '">	<caption>' . sprintf(_c('%1$s %2$s|Used as a calendar caption'), $wp_locale->get_month($thismonth), date('Y', $unixmonth)) . '</caption>	<thead>	<tr>';	$myweek = array();	for ( $wdcount=0; $wdcount<=6; $wdcount++ ) {		$myweek[] = $wp_locale->get_weekday(($wdcount+$week_begins)%7);	}	foreach ( $myweek as $wd ) {		$day_name = (true == $initial) ? $wp_locale->get_weekday_initial($wd) : $wp_locale->get_weekday_abbrev($wd);		echo "\n\t\t<th abbr=\"$wd\" scope=\"col\" title=\"$wd\">$day_name</th>";	}	echo '	</tr>	</thead>';	if (! $fix_height) {		echo '<tfoot>	<tr>';		// Get the next and previous month and year with at least one post		$previous = $wpdb->get_row("SELECT DISTINCT MONTH(post_date) AS month, YEAR(post_date) AS year		FROM $wpdb->posts		WHERE post_date < '$thisyear-$thismonth-01'		AND post_type = 'post' AND post_status = 'publish'			ORDER BY post_date DESC			LIMIT 1");		$next = $wpdb->get_row("SELECT	DISTINCT MONTH(post_date) AS month, YEAR(post_date) AS year		FROM $wpdb->posts		WHERE post_date >	'$thisyear-$thismonth-01'		AND MONTH( post_date ) != MONTH( '$thisyear-$thismonth-01' )		AND post_type = 'post' AND post_status = 'publish'			ORDER	BY post_date ASC			LIMIT 1");		if ( $previous ) {			echo "\n\t\t".'<td abbr="' . $wp_locale->get_month($previous->month) . '" colspan="3" id="prev"><a href="' .		get_month_link($previous->year, $previous->month) . '" title="' . sprintf(__('View posts for %1$s %2$s'), $wp_locale->get_month($previous->month),			date('Y', mktime(0, 0 , 0, $previous->month, 1, $previous->year))) . '">&laquo; ' . $wp_locale->get_month_abbrev($wp_locale->get_month($previous->month)) . '</a></td>';		} else {			echo "\n\t\t".'<td colspan="3" id="prev" class="pad">&nbsp;</td>';		}		echo "\n\t\t".'<td class="pad">&nbsp;</td>';		if ( $next ) {			echo "\n\t\t".'<td abbr="' . $wp_locale->get_month($next->month) . '" colspan="3" id="next"><a href="' .		get_month_link($next->year, $next->month) . '" title="' . sprintf(__('View posts for %1$s %2$s'), $wp_locale->get_month($next->month),			date('Y', mktime(0, 0 , 0, $next->month, 1, $next->year))) . '">' . $wp_locale->get_month_abbrev($wp_locale->get_month($next->month)) . ' &raquo;</a></td>';		} else {			echo "\n\t\t".'<td colspan="3" id="next" class="pad">&nbsp;</td>';		}		echo '	</tr>	</tfoot>';	}	echo '	<tbody>	<tr>';	// Get days with posts	$dayswithposts = $wpdb->get_results("SELECT DISTINCT DAYOFMONTH(post_date)		FROM $wpdb->posts WHERE MONTH(post_date) = '$thismonth'		AND YEAR(post_date) = '$thisyear'		AND post_type = 'post' AND post_status = 'publish'		AND post_date < '" . current_time('mysql') . '\'', ARRAY_N);	if ( $dayswithposts ) {		foreach ( $dayswithposts as $daywith ) {			$daywithpost[] = $daywith[0];		}	} else {		// ===== prevent display if no posts		if ($fix_height) {			ob_end_clean();			return;		}		$daywithpost = array();	}	if (strpos($_SERVER['HTTP_USER_AGENT'], 'MSIE') !== false || strpos(strtolower($_SERVER['HTTP_USER_AGENT']), 'camino') !== false || strpos(strtolower($_SERVER['HTTP_USER_AGENT']), 'safari') !== false)		$ak_title_separator = "\n";	else		$ak_title_separator = ', ';	$ak_titles_for_day = array();	$ak_post_titles = $wpdb->get_results("SELECT post_title, DAYOFMONTH(post_date) as dom "		."FROM $wpdb->posts "		."WHERE YEAR(post_date) = '$thisyear' "		."AND MONTH(post_date) = '$thismonth' "		."AND post_date < '".current_time('mysql')."' "		."AND post_type = 'post' AND post_status = 'publish'"	);	if ( $ak_post_titles ) {		foreach ( $ak_post_titles as $ak_post_title ) {				$post_title = apply_filters( "the_title", $ak_post_title->post_title );				$post_title = str_replace('"', '&quot;', wptexturize( $post_title ));				if ( empty($ak_titles_for_day['day_'.$ak_post_title->dom]) )					$ak_titles_for_day['day_'.$ak_post_title->dom] = '';				if ( empty($ak_titles_for_day["$ak_post_title->dom"]) ) // first one					$ak_titles_for_day["$ak_post_title->dom"] = $post_title;				else					$ak_titles_for_day["$ak_post_title->dom"] .= $ak_title_separator . $post_title;		}	}	// See how much we should pad in the beginning	$pad = calendar_week_mod(date('w', $unixmonth)-$week_begins);	if ( 0 != $pad )		echo "\n\t\t".'<td colspan="'.$pad.'" class="pad">&nbsp;</td>';	$daysinmonth = intval(date('t', $unixmonth));	// ===== Colored Saturday, Sunday =====	$weeks = 0;	$weekday = date('w', $unixmonth);	if (class_exists('YN_Calendar')) {		$yn_cal = new YN_Calendar($thisyear, $thismonth, $week_begins == 1);		$holidays = $yn_cal->list_holidays();	} else {		$holidays = array();	}	for ( $day = 1; $day <= $daysinmonth; ++$day ) {		if ( isset($newrow) && $newrow ) {			echo "\n\t</tr>\n\t<tr>\n\t\t";			// ===== count row =====			$weeks++;		}		$newrow = false;// ===== Colored Saturday, Sunday =====		if ( $day == gmdate('j', (time() + (get_option('gmt_offset') * 3600))) && $thismonth == gmdate('m', time()+(get_option('gmt_offset') * 3600)) && $thisyear == gmdate('Y', time()+(get_option('gmt_offset') * 3600)) )			echo '<td id="today"';		else			echo '<td';		if (in_array($day, $holidays)) {			echo ' class="holiday">';		} else {			switch ($weekday) {				case 1:				case 2:				case 3:				case 4:				case 5:					echo '>';					break;				case 6:					echo ' class="saturday">';					break;				case 0:					echo ' class="sunday">';					break;			}		}		$weekday = ($weekday + 1) % 7;		if ( in_array($day, $daywithpost) ) // any posts today?				echo '<a href="' . get_day_link($thisyear, $thismonth, $day) . "\" title=\"$ak_titles_for_day[$day]\">$day</a>";		else			echo $day;		echo '</td>';		if ( 6 == calendar_week_mod(date('w', mktime(0, 0 , 0, $thismonth, $day, $thisyear))-$week_begins) )			$newrow = true;	}	$pad = 7 - calendar_week_mod(date('w', mktime(0, 0 , 0, $thismonth, $day, $thisyear))-$week_begins);	if ( $pad != 0 && $pad != 7 )		echo "\n\t\t".'<td class="pad" colspan="'.$pad.'">&nbsp;</td>';	// ===== complete rows =====	if ($fix_height && $weeks < 5) {		echo "\n\t</tr>\n\t<tr><td class=\"pad\" colspan=\"7\">&nbsp;</td></tr>";	}		echo "\n\t</tr>\n\t</tbody>\n\t</table>";	$output = ob_get_contents();	ob_end_clean();	echo $output;	$cache[ $key ] = $output;	wp_cache_set( 'get_calendar', $cache, 'calendar' );}/* ================================================== *   Calendar Class   ================================================== */class YN_Calendar {	static public $db_prefix;	protected $blog_id;	protected $year;	protected $month;	protected $start_day;	protected $holidays  = array();	protected $link_days = array();	const     HEADER = '<table class="calendar">';	const     SUNDAY_START = '<thead><tr><th class="sunday">日</th><th>月</th><th>火</th><th>水</th><th>木</th><th>金</th><th class="saturday">土</th></tr></thead><tbody>';	const     MONDAY_START = '<thead><tr><th>月</th><th>火</th><th>水</th><th>木</th><th>金</th><th class="saturday">土</th><th class="sunday">日</th></tr></thead><tbody>';// ==================================================public function __construct($year, $month, $monday_start = 1, $path = NULL) {	global $wpdb;	$this->db_prefix = '';	$this->year         = $year;	$this->month        = $month;	$this->monday_start = $monday_start ? 1 : 0;	$this->path         = $path;	$this->list_holidays();	return;}// ==================================================public function set($key, $value) {	$this->$key = $value;}// ==================================================public function next_month() {	$this->month++;	if ($this->month > 12) {		$this->month = 1;		$this->year++;	}	$this->list_holidays();	return array($this->year, $this->month);}// ==================================================static public function this_year_month() {	// Codes from wp-includes/template-functions-general.php	global $wpdb, $m, $monthnum, $year, $month;	if ( !empty($monthnum) && !empty($year) ) {		$thismonth = ''.zeroise(intval($monthnum), 2);		$thisyear = ''.intval($year);	} elseif ( !empty($w) ) {		// We need to get the month from MySQL		$thisyear = ''.intval(substr($m, 0, 4));		$d = (($w - 1) * 7) + 6; //it seems MySQL's weeks disagree with PHP's		$thismonth = $wpdb->get_var("SELECT DATE_FORMAT((DATE_ADD('${thisyear}0101', INTERVAL $d DAY) ), '%m')");	} elseif ( !empty($m) ) {		$calendar = substr($m, 0, 6);		$thisyear = ''.intval(substr($m, 0, 4));		if ( strlen($m) < 6 ) {			$thismonth = '01';		} else {			$thismonth = ''.zeroise(intval(substr($m, 4, 2)), 2);		}	} else {		$thisyear = gmdate('Y', current_time('timestamp'));		$thismonth = gmdate('m', current_time('timestamp'));	}	return array($thisyear, $thismonth);}// ==================================================public function list_holidays() {	global $wpdb;	if (! $this->holidays) {		$sql = "SELECT DISTINCT DAYOFMONTH(date) as date FROM `{$this->db_prefix}holiday` WHERE YEAR(date) = " . intval($this->year) . " AND MONTH(date) = " . intval($this->month) . " ORDER BY date";		$holidays = array();		$reslut = $wpdb->get_results($sql);		if (count($reslut)) {			foreach($reslut as $r) {				$holidays[] = $r->date;			}		}		$this->holidays = $holidays;	}	return $this->holidays;}// ==================================================protected function build_calendar($caption, $format, $fixed_rows = FALSE) {	$timestamp = mktime(0,0,0, $this->month, 1, $this->year);	$monthdays = date('t', $timestamp);	$weekday   = date('w', $timestamp);	$weeks = 1;	$output = self::HEADER . $caption . ($this->monday_start ? self::MONDAY_START : self::SUNDAY_START);	if ($weekday == $this->monday_start) {		$output .= '<tr>';	} else {		$output .= '<tr><td colspan="' . (($weekday - $this->monday_start + 7) % 7) . '">&nbsp;</td>';	}	// ----- build each date -----	for ($d = 1 ; $d <= $monthdays ; $d++) {		$date = ($d < 10 ? ' ' : '') . 		(in_array($d, $this->link_days) ? 		'<a href="' . sprintf($format, $d) . '">' . $d . '</a>' : intval($d));		if (in_array($d, $this->holidays)) {			$output .=  "<td class=\"holiday\">$date</td>";		} else {			switch ($weekday) {			case 1:			case 2:			case 3:			case 4:			case 5:				$output .= "<td>$date</td>";				break;			case 6:				$output .= "<td class=\"saturday\">$date</td>";				break;			case 0:				$output .= "<td class=\"sunday\">$date</td>";				break;			}		}		if ($weekday == ($this->monday_start ? 0 : 6) && $d != $monthdays) {			$output .= "</tr>\n<tr>";			$weeks++;		}		$weekday = ($weekday + 1) % 7;	}	// ----- build footer -----	if ($weekday == ($this->monday_start ? 1 : 0)) {		$output .= '</tr>';	} else {		$output .= '<td colspan="' . ((7 - $weekday + $this->monday_start) % 7) . '">&nbsp;</td></tr>';	}	if ($weeks < 6 && $fixed_rows) {		$output .= '<tr><td colspan="7">&nbsp;</td></tr>';	}	$output .= '</tbody></table>';	return $output;}// ===== End of class ==============================}