/**
* CMonthCalendar::setDate()
*
* { Description }
*
* @param [type] $date
*/
function setDate($date = null)
{
$this->this_month = new CDate($date);
$d = $this->this_month->getDay();
$m = $this->this_month->getMonth();
$y = $this->this_month->getYear();
$this->prev_year = new CDate($date);
$this->prev_year->setYear($this->prev_year->getYear() - 1);
$this->next_year = new CDate($date);
$this->next_year->setYear($this->next_year->getYear() + 1);
setlocale(LC_TIME, 'en_AU');
$date = Date_Calc::beginOfPrevMonth($d, $m, $y, FMT_TIMESTAMP_DATE);
setlocale(LC_ALL, $AppUI->user_lang);
$this->prev_month = new CDate($date);
setlocale(LC_TIME, 'en_AU');
$date = Date_Calc::beginOfNextMonth($d, $m, $y, FMT_TIMESTAMP_DATE);
setlocale(LC_ALL, $AppUI->user_lang);
$this->next_month = new CDate($date);
}
/**
* 指定された年月にメッセージを送受信した日のリストを返す
*/
function db_message_is_message_list4date($u, $year, $month, $box)
{
include_once 'Date/Calc.php';
if ($box == 'inbox' || !$box) {
$where = "c_member_id_to = ?" . " AND is_deleted_to = 0" . " AND is_send = 1";
} elseif ($box == 'outbox') {
$where = "c_member_id_from = ?" . " AND is_deleted_from = 0" . " AND is_send = 1";
} else {
return null;
}
if ($GLOBALS['_OPENPNE_DSN_LIST']['main']['dsn']['phptype'] == 'pgsql') {
$sql = "SELECT DISTINCT date_part('day', r_datetime) FROM c_message" . " WHERE {$where}" . ' AND is_send=1 AND r_datetime >= ? AND r_datetime < ?';
} else {
$sql = 'SELECT DISTINCT DAYOFMONTH(r_datetime) FROM c_message' . " WHERE {$where}" . ' AND is_send=1 AND r_datetime >= ? AND r_datetime < ?';
}
$date_format = '%Y-%m-%d 00:00:00';
$thismonth = Date_Calc::beginOfMonth($month, $year, $date_format);
$nextmonth = Date_Calc::beginOfNextMonth(0, $month, $year, $date_format);
$params = array(intval($u), $thismonth, $nextmonth);
return db_get_col($sql, $params);
}
/**
* display block
*/
function postcalendar_calendarblock_display($blockinfo)
{
// You supposed to be here?
if (!pnSecAuthAction(0, 'PostCalendar:calendarblock:', "{$blockinfo['title']}::", ACCESS_OVERVIEW)) {
return false;
}
// find out what view we're using
$template_view = pnVarCleanFromInput('tplview');
if (!isset($template_view)) {
$template_view = 'default';
}
// find out what template we're using
$template_name = _SETTING_TEMPLATE;
if (!isset($template_name) || empty($template_name)) {
$template_name = 'default';
}
// What is today's correct date
$Date =& postcalendar_getDate();
// Get variables from content block
$vars = unserialize($blockinfo['content']);
$showcalendar = $vars['pcbshowcalendar'];
$showevents = $vars['pcbeventoverview'];
$eventslimit = $vars['pcbeventslimit'];
$nextevents = $vars['pcbnextevents'];
$pcbshowsslinks = $vars['pcbshowsslinks'];
$pcbeventsrange = $vars['pcbeventsrange'];
// Let's setup the info to build this sucka!
$the_year = substr($Date, 0, 4);
$the_month = substr($Date, 4, 2);
$the_day = substr($Date, 6, 2);
$uid = pnUserGetVar('uid');
$cacheid1 = $cacheid2 = $cacheid3 = '';
$theme = pnUserGetTheme();
pnThemeLoad($theme);
global $bgcolor1, $bgcolor2, $bgcolor3, $bgcolor4, $bgcolor5;
global $textcolor1, $textcolor2;
// 20021125 - rraymond :: we have to do this to make it work with envolution
$pcModInfo = pnModGetInfo(pnModGetIDFromName(__POSTCALENDAR__));
$pcDir = pnVarPrepForOS($pcModInfo['directory']);
require_once "modules/{$pcDir}/pnincludes/Smarty/Config_File.class.php";
unset($pcModInfo);
// set up Smarty
$tpl =& new pcSmarty();
// setup the Smarty cache id
$templates_cached = true;
if ($showcalendar) {
$cacheid1 = md5($Date . 'M' . $template_view . $template_name . $showcalendar . $showevents . $nextevents . $uid . $theme);
if (!$tpl->is_cached($template_name . '/views/calendarblock/month_view.html', $cacheid1)) {
$templates_cached = false;
}
}
if ($showevents) {
$cacheid2 = md5($Date . 'T' . $template_view . $template_name . $showcalendar . $showevents . $nextevents . $uid . $theme);
if (!$tpl->is_cached($template_name . '/views/calendarblock/todays_events.html', $cacheid2)) {
$templates_cached = false;
}
}
if ($nextevents) {
$cacheid3 = md5($Date . 'U' . $template_view . $template_name . $showcalendar . $showevents . $nextevents . $uid . $theme);
if (!$tpl->is_cached($template_name . '/views/calendarblock/upcoming_events.html', $cacheid3)) {
$templates_cached = false;
}
}
// start the output container
$output = pnModAPIFunc(__POSTCALENDAR__, 'user', 'pageSetup');
// if one of the templates is not cached, we need to run the following
if (!$templates_cached) {
// set up the next and previous months to move to
$prev_month = Date_Calc::beginOfPrevMonth(1, $the_month, $the_year, '%Y%m%d');
$next_month = Date_Calc::beginOfNextMonth(1, $the_month, $the_year, '%Y%m%d');
$last_day = Date_Calc::daysInMonth($the_month, $the_year);
$pc_prev = pnModURL(__POSTCALENDAR__, 'user', 'view', array('tplview' => $template_view, 'viewtype' => 'month', 'Date' => $prev_month));
$pc_next = pnModURL(__POSTCALENDAR__, 'user', 'view', array('tplview' => $template_view, 'viewtype' => 'month', 'Date' => $next_month));
$pc_month_name = pnModAPIFunc(__POSTCALENDAR__, 'user', 'getmonthname', array('Date' => mktime(0, 0, 0, $the_month, $the_day, $the_year)));
$month_link_url = pnModURL(__POSTCALENDAR__, 'user', 'view', array('tplview' => $template_view, 'viewtype' => 'month', 'Date' => date('Ymd', mktime(0, 0, 0, $the_month, 1, $the_year))));
$month_link_text = $pc_month_name . ' ' . $the_year;
//*******************************************************************
// Here we get the events for the current month view
//*******************************************************************
$day_of_week = 1;
$pc_month_names = array(_CALJAN, _CALFEB, _CALMAR, _CALAPR, _CALMAY, _CALJUN, _CALJUL, _CALAUG, _CALSEP, _CALOCT, _CALNOV, _CALDEC);
$pc_short_day_names = array(_CALSUNDAYSHORT, _CALMONDAYSHORT, _CALTUESDAYSHORT, _CALWEDNESDAYSHORT, _CALTHURSDAYSHORT, _CALFRIDAYSHORT, _CALSATURDAYSHORT);
$pc_long_day_names = array(_CALSUNDAY, _CALMONDAY, _CALTUESDAY, _CALWEDNESDAY, _CALTHURSDAY, _CALFRIDAY, _CALSATURDAY);
switch (_SETTING_FIRST_DAY_WEEK) {
case _IS_MONDAY:
$pc_array_pos = 1;
$first_day = date('w', mktime(0, 0, 0, $the_month, 0, $the_year));
$end_dow = date('w', mktime(0, 0, 0, $the_month, $last_day, $the_year));
if ($end_dow != 0) {
$the_last_day = $last_day + (7 - $end_dow);
} else {
$the_last_day = $last_day;
}
break;
case _IS_SATURDAY:
$pc_array_pos = 6;
$first_day = date('w', mktime(0, 0, 0, $the_month, 2, $the_year));
$end_dow = date('w', mktime(0, 0, 0, $the_month, $last_day, $the_year));
if ($end_dow == 6) {
$the_last_day = $last_day + 6;
} elseif ($end_dow != 5) {
$the_last_day = $last_day + (5 - $end_dow);
} else {
$the_last_day = $last_day;
}
break;
case _IS_SUNDAY:
default:
$pc_array_pos = 0;
$first_day = date('w', mktime(0, 0, 0, $the_month, 1, $the_year));
$end_dow = date('w', mktime(0, 0, 0, $the_month, $last_day, $the_year));
if ($end_dow != 6) {
$the_last_day = $last_day + (6 - $end_dow);
} else {
$the_last_day = $last_day;
}
break;
}
$month_view_start = date('Y-m-d', mktime(0, 0, 0, $the_month, 1, $the_year));
$month_view_end = date('Y-m-t', mktime(0, 0, 0, $the_month, 1, $the_year));
$today_date = postcalendar_today('%Y-%m-%d');
$starting_date = date('m/d/Y', mktime(0, 0, 0, $the_month, 1 - $first_day, $the_year));
$ending_date = date('m/t/Y', mktime(0, 0, 0, $the_month + $pcbeventsrange, 1, $the_year));
$eventsByDate =& pnModAPIFunc(__POSTCALENDAR__, 'user', 'pcGetEvents', array('start' => $starting_date, 'end' => $ending_date));
$calendarView = Date_Calc::getCalendarMonth($the_month, $the_year, '%Y-%m-%d');
$sdaynames = array();
$numDays = count($pc_short_day_names);
for ($i = 0; $i < $numDays; $i++) {
if ($pc_array_pos >= $numDays) {
$pc_array_pos = 0;
}
array_push($sdaynames, $pc_short_day_names[$pc_array_pos]);
$pc_array_pos++;
}
$daynames = array();
$numDays = count($pc_long_day_names);
for ($i = 0; $i < $numDays; $i++) {
if ($pc_array_pos >= $numDays) {
$pc_array_pos = 0;
}
array_push($daynames, $pc_long_day_names[$pc_array_pos]);
$pc_array_pos++;
}
$dates = array();
while ($starting_date <= $ending_date) {
array_push($dates, $starting_date);
list($m, $d, $y) = explode('/', $starting_date);
$starting_date = Date_Calc::nextDay($d, $m, $y, '%m/%d/%Y');
}
$categories =& pnModAPIFunc(__POSTCALENDAR__, 'user', 'getCategories');
if (isset($calendarView)) {
$tpl->assign_by_ref('CAL_FORMAT', $calendarView);
}
$tpl->assign_by_ref('A_MONTH_NAMES', $pc_month_names);
$tpl->assign_by_ref('A_LONG_DAY_NAMES', $pc_long_day_names);
$tpl->assign_by_ref('A_SHORT_DAY_NAMES', $pc_short_day_names);
$tpl->assign_by_ref('S_LONG_DAY_NAMES', $daynames);
$tpl->assign_by_ref('S_SHORT_DAY_NAMES', $sdaynames);
$tpl->assign_by_ref('A_EVENTS', $eventsByDate);
$tpl->assign_by_ref('A_CATEGORY', $categories);
$tpl->assign_by_ref('PREV_MONTH_URL', $pc_prev);
$tpl->assign_by_ref('NEXT_MONTH_URL', $pc_next);
$tpl->assign_by_ref('MONTH_START_DATE', $month_view_start);
$tpl->assign_by_ref('MONTH_END_DATE', $month_view_end);
$tpl->assign_by_ref('TODAY_DATE', $today_date);
$tpl->assign_by_ref('DATE', $Date);
$tpl->assign_by_ref('DISPLAY_LIMIT', $eventslimit);
$tpl->assign('TODAYS_EVENTS_TITLE', _PC_TODAYS_EVENTS);
$tpl->assign('UPCOMING_EVENTS_TITLE', _PC_UPCOMING_EVENTS);
$tpl->assign('NO_EVENTS', _PC_BLOCK_NO_EVENTS);
}
if ($showcalendar) {
// we need to create a unique ID for caching purposes
$output .= $tpl->fetch($template_name . '/views/calendarblock/month_view.html', $cacheid1);
}
if ($showevents) {
if ($showcalendar) {
$tpl->assign('SHOW_TITLE', 1);
} else {
$tpl->assign('SHOW_TITLE', 0);
}
// we need to create a unique ID for caching purposes
$output .= $tpl->fetch($template_name . '/views/calendarblock/todays_events.html', $cacheid2);
}
if ($nextevents) {
if ($showcalendar || $showevents) {
$tpl->assign('SHOW_TITLE', 1);
} else {
$tpl->assign('SHOW_TITLE', 0);
}
// we need to create a unique ID for caching purposes
$output .= $tpl->fetch($template_name . '/views/calendarblock/upcoming_events.html', $cacheid3);
}
if ($pcbshowsslinks) {
$output .= '<br /><br />';
$submit_event_url = pnModURL(__POSTCALENDAR__, 'user', 'submit');
$search_event_url = pnModURL(__POSTCALENDAR__, 'user', 'search');
$output .= '<center>';
if (PC_ACCESS_ADD) {
$output .= '[ <a href="' . $submit_event_url . '">' . _PC_SUBMIT_EVENT . '</a> ] ';
}
$output .= '[ <a href="' . $search_event_url . '">' . _PC_SEARCH_EVENT . '</a> ]';
$output .= '</center>';
}
// Populate block info and pass to theme
$blockinfo['content'] = $output;
return themesideblock($blockinfo);
}
/**
* CMonthCalendar::setDate()
*
* { Description }
*
* @param [type] $date
*/
function setDate($date = null)
{
$this->this_month = new CDate($date);
$d = $this->this_month->getDay();
$m = $this->this_month->getMonth();
$y = $this->this_month->getYear();
//$date = Date_Calc::beginOfPrevMonth( $d, $m, $y-1, FORMAT_ISO );
$this->prev_year = new CDate($date);
$this->prev_year->setYear($this->prev_year->getYear() - 1);
$this->next_year = new CDate($date);
$this->next_year->setYear($this->next_year->getYear() + 1);
$date = Date_Calc::beginOfPrevMonth($d, $m, $y, FMT_TIMESTAMP_DATE);
$this->prev_month = new CDate($date);
$date = Date_Calc::beginOfNextMonth($d, $m, $y, FMT_TIMESTAMP_DATE);
$this->next_month = new CDate($date);
}
/**
* postcalendar_userapi_buildView
*
* Builds the calendar display
* @param string $Date mm/dd/yyyy format (we should use timestamps)
* @return string generated html output
* @access public
*/
function postcalendar_userapi_buildView($args)
{
$print = pnVarCleanFromInput('print');
$show_days = pnVarCleanFromInput('show_days');
extract($args);
unset($args);
$schedule_start = $GLOBALS[schedule_start];
$schedule_end = $GLOBALS[schedule_end];
// $times is an array of associative arrays, where each sub-array
// has keys 'hour', 'minute' and 'mer'.
//
$times = array();
// For each hour in the schedule...
//
for ($blocknum = $schedule_start; $blocknum <= $schedule_end; $blocknum++) {
$mer = $blocknum >= 12 ? 'pm' : 'am';
// $minute is an array of time slot strings within this hour.
$minute = array('00');
for ($minutes = $GLOBALS['calendar_interval']; $minutes <= 60; $minutes += $GLOBALS['calendar_interval']) {
if ($minutes <= '9') {
$under_ten = "0" . $minutes;
array_push($minute, "{$under_ten}");
} else {
if ($minutes >= '60') {
break;
} else {
array_push($minute, "{$minutes}");
}
}
}
foreach ($minute as $m) {
array_push($times, array("hour" => $blocknum, "minute" => $m, "mer" => $mer));
}
}
//=================================================================
// get the module's information
//=================================================================
$modinfo = pnModGetInfo(pnModGetIDFromName(__POSTCALENDAR__));
$pcDir = $modinfo['directory'];
unset($modinfo);
//=================================================================
// grab the for post variable
//=================================================================
// $pc_username = pnVarCleanFromInput('pc_username');
$pc_username = $_SESSION['pc_username'];
// from Michael Brinson 2006-09-19
$category = pnVarCleanFromInput('pc_category');
$topic = pnVarCleanFromInput('pc_topic');
//=================================================================
// set the correct date
//=================================================================
$Date = postcalendar_getDate();
//=================================================================
// get the current view
//=================================================================
if (!isset($viewtype)) {
$viewtype = 'month';
}
//=================================================================
// Find out what Template we're using
//=================================================================
$template_name = _SETTING_TEMPLATE;
if (!isset($template_name)) {
$template_name = 'default';
}
//=================================================================
// Find out what Template View to use
//=================================================================
$template_view = pnVarCleanFromInput('tplview');
if (!isset($template_view)) {
$template_view = 'default';
}
//=================================================================
// See if the template view exists
//=================================================================
if (!file_exists("modules/{$pcDir}/pntemplates/{$template_name}/views/{$viewtype}/{$template_view}.html")) {
$template_view_load = 'default';
} else {
$template_view_load = pnVarPrepForOS($template_view);
}
//=================================================================
// Grab the current theme information
//=================================================================
pnThemeLoad(pnUserGetTheme());
global $bgcolor1, $bgcolor2, $bgcolor3, $bgcolor4, $bgcolor5, $bgcolor6, $textcolor1, $textcolor2;
//=================================================================
// Insert necessary JavaScript into the page
//=================================================================
$output = pnModAPIFunc(__POSTCALENDAR__, 'user', 'pageSetup');
//=================================================================
// Setup Smarty Template Engine
//=================================================================
$tpl = new pcSmarty();
//if(!$tpl->is_cached("$template_name/views/$viewtype/$template_view_load.html",$cacheid)) {
//diable caching completely
if (true) {
//=================================================================
// Let's just finish setting things up
//=================================================================
$the_year = substr($Date, 0, 4);
$the_month = substr($Date, 4, 2);
$the_day = substr($Date, 6, 2);
$last_day = Date_Calc::daysInMonth($the_month, $the_year);
//=================================================================
// populate the template object with information for
// Month Names, Long Day Names and Short Day Names
// as translated in the language files
// (may be adding more here soon - based on need)
//=================================================================
$pc_month_names = array(_CALJAN, _CALFEB, _CALMAR, _CALAPR, _CALMAY, _CALJUN, _CALJUL, _CALAUG, _CALSEP, _CALOCT, _CALNOV, _CALDEC);
$pc_short_day_names = array(_CALSUNDAYSHORT, _CALMONDAYSHORT, _CALTUESDAYSHORT, _CALWEDNESDAYSHORT, _CALTHURSDAYSHORT, _CALFRIDAYSHORT, _CALSATURDAYSHORT);
$pc_long_day_names = array(_CALSUNDAY, _CALMONDAY, _CALTUESDAY, _CALWEDNESDAY, _CALTHURSDAY, _CALFRIDAY, _CALSATURDAY);
//=================================================================
// here we need to set up some information for later
// variable creation. This helps us establish the correct
// date ranges for each view. There may be a better way
// to handle all this, but my brain hurts, so your comments
// are very appreciated and welcomed.
//=================================================================
switch (_SETTING_FIRST_DAY_WEEK) {
case _IS_MONDAY:
$pc_array_pos = 1;
$first_day = date('w', mktime(0, 0, 0, $the_month, 0, $the_year));
$week_day = date('w', mktime(0, 0, 0, $the_month, $the_day - 1, $the_year));
$end_dow = date('w', mktime(0, 0, 0, $the_month, $last_day, $the_year));
if ($end_dow != 0) {
$the_last_day = $last_day + (7 - $end_dow);
} else {
$the_last_day = $last_day;
}
break;
case _IS_SATURDAY:
$pc_array_pos = 6;
$first_day = date('w', mktime(0, 0, 0, $the_month, 2, $the_year));
$week_day = date('w', mktime(0, 0, 0, $the_month, $the_day + 1, $the_year));
$end_dow = date('w', mktime(0, 0, 0, $the_month, $last_day, $the_year));
if ($end_dow == 6) {
$the_last_day = $last_day + 6;
} elseif ($end_dow != 5) {
$the_last_day = $last_day + (5 - $end_dow);
} else {
$the_last_day = $last_day;
}
break;
case _IS_SUNDAY:
default:
$pc_array_pos = 0;
$first_day = date('w', mktime(0, 0, 0, $the_month, 1, $the_year));
$week_day = date('w', mktime(0, 0, 0, $the_month, $the_day, $the_year));
$end_dow = date('w', mktime(0, 0, 0, $the_month, $last_day, $the_year));
if ($end_dow != 6) {
$the_last_day = $last_day + (6 - $end_dow);
} else {
$the_last_day = $last_day;
}
break;
}
// passing the times array to the tpl the times array is for the days schedule
$tpl->assign_by_ref("times", $times);
// load the table width to the template
// $tpl->assign("day_td_width",$GLOBALS['day_view_td_width']);
//=================================================================
// Week View is a bit of a pain in the ass, so we need to
// do some extra setup for that view. This section will
// find the correct starting and ending dates for a given
// seven day period, based on the day of the week the
// calendar is setup to run under (Sunday, Saturday, Monday)
//=================================================================
$first_day_of_week = sprintf('%02d', $the_day - $week_day);
$week_first_day = date('m/d/Y', mktime(0, 0, 0, $the_month, $first_day_of_week, $the_year));
list($week_first_day_month, $week_first_day_date, $week_first_day_year) = explode('/', $week_first_day);
$week_first_day_month_name = pnModAPIFunc(__POSTCALENDAR__, 'user', 'getmonthname', array('Date' => mktime(0, 0, 0, $week_first_day_month, $week_first_day_date, $week_first_day_year)));
$week_last_day = date('m/d/Y', mktime(0, 0, 0, $the_month, $first_day_of_week + 6, $the_year));
list($week_last_day_month, $week_last_day_date, $week_last_day_year) = explode('/', $week_last_day);
$week_last_day_month_name = pnModAPIFunc(__POSTCALENDAR__, 'user', 'getmonthname', array('Date' => mktime(0, 0, 0, $week_last_day_month, $week_last_day_date, $week_last_day_year)));
$week_view_start = date('Y-m-d', mktime(0, 0, 0, $the_month, $first_day_of_week, $the_year));
$week_view_end = date('Y-m-d', mktime(0, 0, 0, $the_month, $first_day_of_week + 6, $the_year));
//=================================================================
// Setup some information so we know the actual month's dates
// also get today's date for later use and highlighting
//=================================================================
$month_view_start = date('Y-m-d', mktime(0, 0, 0, $the_month, 1, $the_year));
$month_view_end = date('Y-m-t', mktime(0, 0, 0, $the_month, 1, $the_year));
$today_date = postcalendar_today('%Y-%m-%d');
//=================================================================
// Setup the starting and ending date ranges for pcGetEvents()
//=================================================================
switch ($viewtype) {
case 'day':
$starting_date = date('m/d/Y', mktime(0, 0, 0, $the_month, $the_day, $the_year));
$ending_date = date('m/d/Y', mktime(0, 0, 0, $the_month, $the_day, $the_year));
break;
case 'week':
$starting_date = "{$week_first_day_month}/{$week_first_day_date}/{$week_first_day_year}";
$ending_date = "{$week_last_day_month}/{$week_last_day_date}/{$week_last_day_year}";
$calendarView = Date_Calc::getCalendarWeek($week_first_day_date, $week_first_day_month, $week_first_day_year, '%Y-%m-%d');
break;
case 'month':
$starting_date = date('m/d/Y', mktime(0, 0, 0, $the_month, 1 - $first_day, $the_year));
$ending_date = date('m/d/Y', mktime(0, 0, 0, $the_month, $the_last_day, $the_year));
$calendarView = Date_Calc::getCalendarMonth($the_month, $the_year, '%Y-%m-%d');
break;
case 'year':
$starting_date = date('m/d/Y', mktime(0, 0, 0, 1, 1, $the_year));
$ending_date = date('m/d/Y', mktime(0, 0, 0, 1, 1, $the_year + 1));
$calendarView = Date_Calc::getCalendarYear($the_year, '%Y-%m-%d');
break;
}
//=================================================================
// Identify the Providers whose schedules we should load
//=================================================================
//==================================
//FACILITY FILTERING (CHEMED)
if ($_SESSION['pc_facility']) {
$provinfo = getProviderInfo('%', true, $_SESSION['pc_facility']);
} else {
$provinfo = getProviderInfo();
}
//EOS FACILITY FILTERING (CHEMED)
//==================================
$single = array();
$provIDs = array();
// array of numeric provider IDs
// filter the display on the requested username, the provinfo array is
// used to build columns in the week view.
foreach ($provinfo as $provider) {
if (is_array($pc_username)) {
foreach ($pc_username as $uname) {
if (!empty($pc_username) && $provider['username'] == $uname) {
array_push($single, $provider);
array_push($provIDs, $provider['id']);
}
}
} else {
if (!empty($pc_username) && $provider['username'] == $pc_username) {
array_push($single, $provider);
array_push($provIDs, $provider['id']);
}
}
}
if ($single != null) {
$provinfo = $single;
}
//=================================================================
// Load the events
//=================================================================
if ($viewtype != 'year') {
$eventsByDate =& postcalendar_userapi_pcGetEvents(array('start' => $starting_date, 'end' => $ending_date, 'viewtype' => $viewtype, 'provider_id' => $provIDs));
} else {
$eventsByDate = array();
}
//=================================================================
// Create an array with the day names in the correct order
//=================================================================
$daynames = array();
$numDays = count($pc_long_day_names);
for ($i = 0; $i < $numDays; $i++) {
if ($pc_array_pos >= $numDays) {
$pc_array_pos = 0;
}
array_push($daynames, $pc_long_day_names[$pc_array_pos]);
$pc_array_pos++;
}
unset($numDays);
$sdaynames = array();
$numDays = count($pc_short_day_names);
for ($i = 0; $i < $numDays; $i++) {
if ($pc_array_pos >= $numDays) {
$pc_array_pos = 0;
}
array_push($sdaynames, $pc_short_day_names[$pc_array_pos]);
$pc_array_pos++;
}
unset($numDays);
//=================================================================
// Prepare some values for the template
//=================================================================
$prev_month = Date_Calc::beginOfPrevMonth(1, $the_month, $the_year, '%Y%m%d');
$next_month = Date_Calc::beginOfNextMonth(1, $the_month, $the_year, '%Y%m%d');
$pc_prev = pnModURL(__POSTCALENDAR__, 'user', 'view', array('tplview' => $template_view, 'viewtype' => 'month', 'Date' => $prev_month, 'pc_username' => $pc_username, 'pc_category' => $category, 'pc_topic' => $topic));
$pc_next = pnModURL(__POSTCALENDAR__, 'user', 'view', array('tplview' => $template_view, 'viewtype' => 'month', 'Date' => $next_month, 'pc_username' => $pc_username, 'pc_category' => $category, 'pc_topic' => $topic));
$prev_day = Date_Calc::prevDay($the_day, $the_month, $the_year, '%Y%m%d');
$next_day = Date_Calc::nextDay($the_day, $the_month, $the_year, '%Y%m%d');
$pc_prev_day = pnModURL(__POSTCALENDAR__, 'user', 'view', array('tplview' => $template_view, 'viewtype' => 'day', 'Date' => $prev_day, 'pc_username' => $pc_username, 'pc_category' => $category, 'pc_topic' => $topic));
$pc_next_day = pnModURL(__POSTCALENDAR__, 'user', 'view', array('tplview' => $template_view, 'viewtype' => 'day', 'Date' => $next_day, 'pc_username' => $pc_username, 'pc_category' => $category, 'pc_topic' => $topic));
$prev_week = date('Ymd', mktime(0, 0, 0, $week_first_day_month, $week_first_day_date - 7, $week_first_day_year));
$next_week = date('Ymd', mktime(0, 0, 0, $week_last_day_month, $week_last_day_date + 1, $week_last_day_year));
$pc_prev_week = pnModURL(__POSTCALENDAR__, 'user', 'view', array('viewtype' => 'week', 'Date' => $prev_week, 'pc_username' => $pc_username, 'pc_category' => $category, 'pc_topic' => $topic));
$pc_next_week = pnModURL(__POSTCALENDAR__, 'user', 'view', array('viewtype' => 'week', 'Date' => $next_week, 'pc_username' => $pc_username, 'pc_category' => $category, 'pc_topic' => $topic));
$prev_year = date('Ymd', mktime(0, 0, 0, 1, 1, $the_year - 1));
$next_year = date('Ymd', mktime(0, 0, 0, 1, 1, $the_year + 1));
$pc_prev_year = pnModURL(__POSTCALENDAR__, 'user', 'view', array('viewtype' => 'year', 'Date' => $prev_year, 'pc_username' => $pc_username, 'pc_category' => $category, 'pc_topic' => $topic));
$pc_next_year = pnModURL(__POSTCALENDAR__, 'user', 'view', array('viewtype' => 'year', 'Date' => $next_year, 'pc_username' => $pc_username, 'pc_category' => $category, 'pc_topic' => $topic));
//=================================================================
// Populate the template
//=================================================================
$all_categories = pnModAPIFunc(__POSTCALENDAR__, 'user', 'getCategories');
if (isset($calendarView)) {
$tpl->assign_by_ref('CAL_FORMAT', $calendarView);
}
if ($viewtype == "week") {
$last_blocks = array();
foreach ($eventsByDate as $cdate => $day) {
$tblock = array_reverse($day['blocks']);
$last_blocks[$cdate] = count($tblock) - 1;
for ($i = 0; $i < count($tblock); $i++) {
if (!empty($tblock[$i])) {
$last_blocks[$cdate] = count($tblock) - $i;
break;
}
}
}
$tpl->assign("last_blocks", $last_blocks);
}
$tpl->assign('STYLE', $GLOBALS['style']);
$tpl->assign('show_days', $show_days);
//$provinfo[count($provinfo) +1] = array("id" => "","lname" => "Other");
$tpl->assign_by_ref('providers', $provinfo);
if (pnVarCleanFromInput("show_days") != 1) {
$tpl->assign('showdaysurl', "index.php?" . $_SERVER['QUERY_STRING'] . "&show_days=1");
}
$tpl->assign('interval', $GLOBALS['calendar_interval']);
$tpl->assign_by_ref('VIEW_TYPE', $viewtype);
$tpl->assign_by_ref('A_MONTH_NAMES', $pc_month_names);
$tpl->assign_by_ref('A_LONG_DAY_NAMES', $pc_long_day_names);
$tpl->assign_by_ref('A_SHORT_DAY_NAMES', $pc_short_day_names);
$tpl->assign_by_ref('S_LONG_DAY_NAMES', $daynames);
$tpl->assign_by_ref('S_SHORT_DAY_NAMES', $sdaynames);
$tpl->assign_by_ref('A_EVENTS', $eventsByDate);
$tpl->assign_by_ref('A_CATEGORY', $all_categories);
$tpl->assign_by_ref('PREV_MONTH_URL', $pc_prev);
$tpl->assign_by_ref('NEXT_MONTH_URL', $pc_next);
$tpl->assign_by_ref('PREV_DAY_URL', $pc_prev_day);
$tpl->assign_by_ref('NEXT_DAY_URL', $pc_next_day);
$tpl->assign_by_ref('PREV_WEEK_URL', $pc_prev_week);
$tpl->assign_by_ref('NEXT_WEEK_URL', $pc_next_week);
$tpl->assign_by_ref('PREV_YEAR_URL', $pc_prev_year);
$tpl->assign_by_ref('NEXT_YEAR_URL', $pc_next_year);
$tpl->assign_by_ref('WEEK_START_DATE', $week_view_start);
$tpl->assign_by_ref('WEEK_END_DATE', $week_view_end);
$tpl->assign_by_ref('MONTH_START_DATE', $month_view_start);
$tpl->assign_by_ref('MONTH_END_DATE', $month_view_end);
$tpl->assign_by_ref('TODAY_DATE', $today_date);
$tpl->assign_by_ref('DATE', $Date);
$tpl->assign('SCHEDULE_BASE_URL', pnModURL(__POSTCALENDAR__, 'user', 'submit'));
$tpl->assign_by_ref('intervals', $intervals);
}
//=================================================================
// Parse the template
//=================================================================
$template = "{$template_name}/views/{$viewtype}/{$template_view_load}.html";
if (!$print) {
$output .= "\n\n<!-- START POSTCALENDAR OUTPUT [-: HTTP://POSTCALENDAR.TV :-] -->\n\n";
$output .= $tpl->fetch($template, $cacheid);
// cache id
$output .= "\n\n<!-- END POSTCALENDAR OUTPUT [-: HTTP://POSTCALENDAR.TV :-] -->\n\n";
} else {
$theme = pnUserGetTheme();
echo "<html><head>";
echo "<LINK REL=\"StyleSheet\" HREF=\"themes/{$theme}/style/styleNN.css\" TYPE=\"text/css\">\n\n\n";
echo "<style type=\"text/css\">\n";
echo "@import url(\"themes/{$theme}/style/style.css\"); ";
echo "</style>\n";
echo "</head><body>\n";
echo $output;
$tpl->display($template, $cacheid);
echo postcalendar_footer();
echo "\n</body></html>";
session_write_close();
exit;
}
//=================================================================
// Return the output
//=================================================================
return $output;
}
/**
* A private method that returns the start and end dates
* that bound the span, based based on a pre-defined 'friendly'
* value.
*
* See the {@link OA_Admin_DaySpan::setSpanPresetValue()} method
* for the pre-defined values.
*
* @param string $presetValue The preset value string.
* @return array An array of two elements, "start" and "end",
* representing the start and end dates of
* the span, respectively.
*/
function _getSpanDates($presetValue)
{
switch ($presetValue) {
case 'today':
$oDateStart = new Date($this->oNowDate->format('%Y-%m-%d'));
$oDateEnd = new Date($this->oNowDate->format('%Y-%m-%d'));
break;
case 'yesterday':
$oDateStart = new Date(Date_Calc::prevDay($this->oNowDate->format('%d'), $this->oNowDate->format('%m'), $this->oNowDate->format('%Y')));
$oDateEnd = new Date(Date_Calc::prevDay($this->oNowDate->format('%d'), $this->oNowDate->format('%m'), $this->oNowDate->format('%Y')));
break;
case 'this_week':
$oDateStart = new Date(Date_Calc::beginOfWeek($this->oNowDate->format('%d'), $this->oNowDate->format('%m'), $this->oNowDate->format('%Y')));
$oSixDaySpan = new Date_Span();
$oSixDaySpan->setFromDays(6);
$oSevenDaySpan = new Date_Span();
$oSevenDaySpan->setFromDays(7);
// Now have week start and end when week starts on Sunday
// Does the user want to start on a different day?
$beginOfWeek = OA_Admin_DaySpan::getBeginOfWeek();
if ($beginOfWeek > 0) {
$oRequiredDaysSpan = new Date_Span();
$oRequiredDaysSpan->setFromDays($beginOfWeek);
$oDateStart->addSpan($oRequiredDaysSpan);
$oDateToday = new Date($this->oNowDate->format('%Y-%m-%d'));
if ($oDateToday->getDayOfWeek() < $beginOfWeek) {
$oDateStart->subtractSpan($oSevenDaySpan);
}
}
$oDateEnd = new Date($this->oNowDate->format('%Y-%m-%d'));
break;
case 'last_week':
$oDateStart = new Date(Date_Calc::beginOfPrevWeek($this->oNowDate->format('%d'), $this->oNowDate->format('%m'), $this->oNowDate->format('%Y')));
$oSixDaySpan = new Date_Span();
$oSixDaySpan->setFromDays(6);
$oSevenDaySpan = new Date_Span();
$oSevenDaySpan->setFromDays(7);
// Now have week start and end when week starts on Sunday
// Does the user want to start on a different day?
$beginOfWeek = OA_Admin_DaySpan::getBeginOfWeek();
if ($beginOfWeek > 0) {
$oRequiredDaysSpan = new Date_Span();
$oRequiredDaysSpan->setFromDays($beginOfWeek);
$oDateStart->addSpan($oRequiredDaysSpan);
$oDateToday = new Date($this->oNowDate->format('%Y-%m-%d'));
if ($oDateToday->getDayOfWeek() < $beginOfWeek) {
$oDateStart->subtractSpan($oSevenDaySpan);
}
}
$oDateEnd = new Date($this->oNowDate->format('%Y-%m-%d'));
$oDateEnd->copy($oDateStart);
$oDateEnd->addSpan($oSixDaySpan);
break;
case 'last_7_days':
$oDateStart = new Date($this->oNowDate->format('%Y-%m-%d'));
$oDateEnd = new Date($this->oNowDate->format('%Y-%m-%d'));
$oOneDaySpan = new Date_Span();
$oOneDaySpan->setFromDays(1);
$oSevenDaySpan = new Date_Span();
$oSevenDaySpan->setFromDays(7);
$oDateStart->subtractSpan($oSevenDaySpan);
$oDateEnd->subtractSpan($oOneDaySpan);
break;
case 'this_month':
$oDateStart = new Date(Date_Calc::beginOfMonth($this->oNowDate->format('%m'), $this->oNowDate->format('%Y')));
$oDateEnd = new Date($this->oNowDate->format('%Y-%m-%d'));
break;
case 'this_month_full':
$oDateStart = new Date(Date_Calc::beginOfMonth($this->oNowDate->format('%m'), $this->oNowDate->format('%Y')));
$oDateEnd = new Date(Date_Calc::beginOfNextMonth($this->oNowDate->format('%d'), $this->oNowDate->format('%m'), $this->oNowDate->format('%Y')));
$oOneDaySpan = new Date_Span();
$oOneDaySpan->setFromDays(1);
$oDateEnd->subtractSpan($oOneDaySpan);
break;
case 'this_month_remainder':
$oDateStart = new Date($this->oNowDate->format('%Y-%m-%d'));
$oDateEnd = new Date(Date_Calc::beginOfNextMonth($this->oNowDate->format('%d'), $this->oNowDate->format('%m'), $this->oNowDate->format('%Y')));
$oOneDaySpan = new Date_Span();
$oOneDaySpan->setFromDays(1);
$oDateEnd->subtractSpan($oOneDaySpan);
break;
case 'next_month':
$oDateStart = new Date(Date_Calc::beginOfNextMonth($this->oNowDate->format('%d'), $this->oNowDate->format('%m'), $this->oNowDate->format('%Y')));
$oDateEnd = new Date(Date_Calc::endOfNextMonth($this->oNowDate->format('%d'), $this->oNowDate->format('%m'), $this->oNowDate->format('%Y')));
break;
case 'last_month':
$oDateStart = new Date(Date_Calc::beginOfPrevMonth($this->oNowDate->format('%d'), $this->oNowDate->format('%m'), $this->oNowDate->format('%Y')));
$oDateEnd = new Date(Date_Calc::beginOfMonth($this->oNowDate->format('%m'), $this->oNowDate->format('%Y')));
$oOneDaySpan = new Date_Span();
$oOneDaySpan->setFromDays(1);
$oDateEnd->subtractSpan($oOneDaySpan);
break;
case 'all_stats':
$oDateStart = null;
$oDateEnd = null;
break;
case 'specific':
$startDate = MAX_getStoredValue('startDate', date('Y-m-d'));
$oDateStart = new Date($startDate);
$endDate = MAX_getStoredValue('endDate', date('Y-m-d'));
$oDateEnd = new Date($endDate);
break;
}
$this->_setStartDate($oDateStart);
$this->_setEndDate($oDateEnd);
$aDates = array('start' => $oDateStart, 'end' => $oDateEnd);
return $aDates;
}
/**
* CMonthCalendar::setDate()
*
* { Description }
*
* @param [type] $date
*/
function setDate($date = null)
{
global $AppUI, $locale_char_set;
$this->this_month = new CDate($date);
$d = $this->this_month->getDay();
$m = $this->this_month->getMonth();
$y = $this->this_month->getYear();
$this->prev_year = new CDate($date);
$this->prev_year->setYear($this->prev_year->getYear() - 1);
$this->next_year = new CDate($date);
$this->next_year->setYear($this->next_year->getYear() + 1);
setlocale(LC_ALL, 'en_AU' . ($locale_char_set ? '.' . $locale_char_set : '.utf8'));
$date = Date_Calc::beginOfPrevMonth($d, $m, $y, FMT_TIMESTAMP_DATE);
setlocale(LC_ALL, $AppUI->user_lang);
$this->prev_month = new CDate($date);
setlocale(LC_ALL, 'en_AU' . ($locale_char_set ? '.' . $locale_char_set : '.utf8'));
$date = Date_Calc::beginOfNextMonth($d, $m, $y, FMT_TIMESTAMP_DATE);
setlocale(LC_ALL, $AppUI->user_lang);
$this->next_month = new CDate($date);
}
/**
* Returns an array of conversions.
*
* @param array $aParams
* @return array
*/
function getConversions($aParams)
{
$conf = $GLOBALS['_MAX']['CONF'];
$oDbh =& OA_DB::singleton();
$where = '';
if (!empty($aParams['day'])) {
$aParams['day_begin'] = $aParams['day_end'] = $aParams['day'];
}
if (!empty($aParams['day_begin'])) {
$oStart = new Date($aParams['day_begin']);
$oStart->setHour(0);
$oStart->setMinute(0);
$oStart->setSecond(0);
$oStart->toUTC();
$where .= ' AND ac.tracker_date_time >= ' . $oDbh->quote($oStart->format('%Y-%m-%d %H:%M:%S'), 'timestamp');
}
if (!empty($aParams['day_end'])) {
$oEnd = new Date($aParams['day_end']);
$oEnd->setHour(23);
$oEnd->setMinute(59);
$oEnd->setSecond(59);
$oEnd->toUTC();
$where .= ' AND ac.tracker_date_time <= ' . $oDbh->quote($oEnd->format('%Y-%m-%d %H:%M:%S'), 'timestamp');
}
if (!empty($aParams['month'])) {
$oStart = new Date("{$aParams['month']}-01");
$oStart->setHour(0);
$oStart->setMinute(0);
$oStart->setSecond(0);
$oEnd = new Date(Date_Calc::beginOfNextMonth($oStart->getDay(), $oStart->getMonth, $oStart->getYear(), '%Y-%m-%d'));
$oEnd->setHour(0);
$oEnd->setMinute(0);
$oEnd->setSecond(0);
$oEnd->subtractSeconds(1);
$oStart->toUTC();
$oEnd->toUTC();
$where .= ' AND ac.tracker_date_time >= ' . $oDbh->quote($oStart->format('%Y-%m-%d %H:%M:%S'), 'timestamp');
$where .= ' AND ac.tracker_date_time <= ' . $oDbh->quote($oEnd->format('%Y-%m-%d %H:%M:%S'), 'timestamp');
}
if (!empty($aParams['day_hour'])) {
$oStart = new Date("{$aParams['day_hour']}:00:00");
$oStart->setMinute(0);
$oStart->setSecond(0);
$oEnd = new Date($oStart);
$oStart->setMinute(59);
$oStart->setSecond(59);
$where .= ' AND ac.tracker_date_time >= ' . $oDbh->quote($oStart->format('%Y-%m-%d %H:%M:%S'), 'timestamp');
$where .= ' AND ac.tracker_date_time <= ' . $oDbh->quote($oEnd->format('%Y-%m-%d %H:%M:%S'), 'timestamp');
}
if (!empty($aParams['agency_id'])) {
$where .= ' AND c.agencyid=' . $oDbh->quote($aParams['agency_id'], 'integer');
}
if (!empty($aParams['clientid'])) {
$where .= ' AND c.clientid=' . $oDbh->quote($aParams['clientid'], 'integer');
}
if (isset($aParams['zonesIds'])) {
$where .= ' AND ac.zone_id IN (' . $oDbh->escape(implode(',', $aParams['zonesIds'])) . ")";
}
if (!empty($aParams['campaignid'])) {
$where .= ' AND m.campaignid=' . $oDbh->quote($aParams['campaignid'], 'integer');
}
if (!empty($aParams['bannerid'])) {
$where .= ' AND d.bannerid=' . $oDbh->quote($aParams['bannerid'], 'integer');
}
if (!empty($aParams['statuses'])) {
$where .= ' AND ac.connection_status IN (' . $oDbh->escape(implode(',', $aParams['statuses'])) . ')';
}
if (isset($aParams['startRecord']) && is_numeric($aParams['startRecord']) && is_numeric($aParams['perPage'])) {
$limit = ' LIMIT ' . $oDbh->quote($aParams['perPage'], 'text', false) . ' OFFSET ' . $oDbh->quote($aParams['startRecord'], 'text', false);
} elseif (!empty($aParams['perPage'])) {
$limit = ' LIMIT ' . $oDbh->quote($aParams['perPage'], 'integer', false) . ' OFFSET 0';
} else {
$limit = '';
}
$query = "SELECT\n ac.data_intermediate_ad_connection_id as connection_id,\n c.clientid,\n m.campaignid,\n m.campaignname AS campaignname,\n ac.tracker_id as tracker_id,\n ac.connection_status,\n ac.connection_date_time AS connection_date_time,\n ac.tracker_date_time as date_time,\n t.trackername,\n ac.tracker_ip_address,\n ac.tracker_country,\n ac.connection_action,\n t.type AS connection_type,\n ac.tracker_country,\n ac.ad_id,\n ac.creative_id,\n ac.zone_id,\n ac.comments\n FROM\n {$conf['table']['prefix']}{$conf['table']['clients']} AS c,\n {$conf['table']['prefix']}{$conf['table']['data_intermediate_ad_connection']} AS ac,\n {$conf['table']['prefix']}{$conf['table']['banners']} AS d,\n {$conf['table']['prefix']}{$conf['table']['campaigns']} AS m,\n {$conf['table']['prefix']}{$conf['table']['trackers']} AS t\n WHERE\n c.clientid=m.clientid\n AND m.campaignid=d.campaignid\n AND d.bannerid=ac.ad_id\n AND t.trackerid=ac.tracker_id\n AND ac.inside_window = 1\n " . $where . "\n ORDER BY\n ac.tracker_date_time\n {$limit}";
$aStats = $oDbh->queryAll($query, null, MDB2_FETCHMODE_DEFAULT, true);
$oNow = new Date();
foreach (array_keys($aStats) as $k) {
$oDate = new Date($aStats[$k]['date_time']);
$oDate->setTZbyID('UTC');
$oDate->convertTZ($oNow->tz);
$aStats[$k]['date_time'] = $oDate->format('%Y-%m-%d %H:%M:%S');
$oDate = new Date($aStats[$k]['connection_date_time']);
$oDate->setTZbyID('UTC');
$oDate->convertTZ($oNow->tz);
$aStats[$k]['connection_date_time'] = $oDate->format('%Y-%m-%d %H:%M:%S');
}
return $aStats;
}
/**
* Draw the calendar's title bar
*
* @param day
* @param month
* @param year
*
* @access public
* @return string of the rendered HTML
*/
function drawTitle($day, $month, $year)
{
$rv = '';
if ($this->_navLinks) {
$path = $this->_path;
if (!strchr($path, '?') && !strchr($this->_query, '?')) {
$path .= '?';
}
$rv .= sprintf("<a href='%s'\n><<</a> ", $path . Date_Calc::beginOfMonth($month, $year - 1, $this->_query));
$rv .= sprintf("<a href='%s'\n><</a> ", $path . Date_Calc::beginOfPrevMonth($day, $month, $year, $this->_query));
}
$rv .= Date_Calc::dateFormat($day, $month, $year, $this->_options['title_format']);
if ($this->_navLinks) {
$rv .= sprintf(" <a href='%s'\n>></a>", $path . Date_Calc::beginOfNextMonth($day, $month, $year, $this->_query));
$rv .= sprintf(" <a href='%s'\n>>></a>", $path . Date_Calc::beginOfMonth($month, $year + 1, $this->_query));
}
return $rv;
}
function b_weblog_calendar_show($options)
{
global $xoopsDB, $xoopsUser;
global $xoopsConfig, $xoopsTpl;
$mydirname = $options[0];
include_once XOOPS_ROOT_PATH . '/modules/' . $mydirname . '/include/PEAR/Date/Calc.php';
$currentuid = is_object($xoopsUser) ? $xoopsUser->getVar('uid', 'E') : 0;
if (is_object($xoopsUser)) {
$useroffset = $xoopsUser->timezone() - $xoopsConfig['server_TZ'];
} else {
$useroffset = $xoopsConfig['default_TZ'] - $xoopsConfig['server_TZ'];
}
// set when month
$date = isset($_GET['date']) && strlen(intval($_GET['date'])) >= 6 ? intval($_GET['date']) : '';
if ($date > 0) {
$month = substr($date, 0, 6);
} else {
$month = date('Ym', time() + $useroffset * 3600);
}
// get next/previous month and year
$this_year = substr(strval($month), 0, 4);
$this_month = substr(strval($month), 4, 6);
$month_next = Date_Calc::beginOfNextMonth('1', $this_month, $this_year, $format = '%Y%m');
$month_prev = Date_Calc::beginOfPrevMonth('1', $this_month, $this_year, $format = '%Y%m');
$year_next = strval($this_year + 1) . $this_month;
$year_prev = strval($this_year - 1) . $this_month;
if (file_exists(XOOPS_ROOT_PATH . '/language/' . $xoopsConfig["language"] . '/calendar.php')) {
require_once XOOPS_ROOT_PATH . '/language/' . $xoopsConfig["language"] . '/calendar.php';
} else {
require_once XOOPS_ROOT_PATH . '/language/english/calendar.php';
}
$month_arr = array(1 => _CAL_JANUARY, 2 => _CAL_FEBRUARY, 3 => _CAL_MARCH, 4 => _CAL_APRIL, 5 => _CAL_MAY, 6 => _CAL_JUNE, 7 => _CAL_JULY, 8 => _CAL_AUGUST, 9 => _CAL_SEPTEMBER, 10 => _CAL_OCTOBER, 11 => _CAL_NOVEMBER, 12 => _CAL_DECEMBER);
$week_arr = array(_MB_WEBLOG_LANG_SUNDAY, _MB_WEBLOG_LANG_MONDAY, _MB_WEBLOG_LANG_TUESDAY, _MB_WEBLOG_LANG_WEDNESDAY, _MB_WEBLOG_LANG_THURSDAY, _MB_WEBLOG_LANG_FRIDAY, _MB_WEBLOG_LANG_SATURDAY);
// get one month calendar array
include_once XOOPS_ROOT_PATH . '/modules/' . $mydirname . '/class/class.calendar.php';
$mycalendar = new MyCalendar($month);
$calendar = $mycalendar->dispCalendar();
$calendar['lang_monthPrev'] = _MB_WEBLOG_LANG_PREVMONTH;
$calendar['lang_monthNext'] = _MB_WEBLOG_LANG_NEXTMONTH;
$calendar['lang_yearPrev'] = _MB_WEBLOG_LANG_PREVYEAR;
$calendar['lang_yearNext'] = _MB_WEBLOG_LANG_NEXTYEAR;
$calendar['lang_month'] = $month_arr[intval($calendar['month'])];
$calendar['lang_ShowPrevMonth'] = _MB_WEBLOG_LANG_PREVMONTH_TITLE;
$calendar['lang_ShowNextMonth'] = _MB_WEBLOG_LANG_NEXTMONTH_TITLE;
$calendar['lang_ShowPrevYear'] = _MB_WEBLOG_LANG_PREVYEAR_TITLE;
$calendar['lang_ShowNextYear'] = _MB_WEBLOG_LANG_NEXTYEAR_TITLE;
$calendar['lang_ShowThisMonth'] = _MB_WEBLOG_LANG_THIS_MONTH_TITLE;
$calendar['dayofweek'] = $week_arr;
// override
$calendar['monthThis'] = $this_year . $this_month;
$calendar['monthPrev'] = $month_prev;
$calendar['monthNext'] = $month_next;
$calendar['yearPrev'] = $year_prev;
$calendar['yearNext'] = $year_next;
// add xoops_block_header for css file
$xoops_block_header = $xoopsTpl->get_template_vars('xoops_block_header');
$xoops_block_header .= '<link rel="stylesheet" type="text/css" media="screen" href="' . XOOPS_URL . '/modules/' . $mydirname . '/weblog_block.css" />';
$xoopsTpl->assign('xoops_block_header', $xoops_block_header);
if (!empty($_SERVER['QUERY_STRING'])) {
if (ereg("^calMonth=[0-9]{10}\$", $_SERVER['QUERY_STRING'])) {
$query_string = "?";
} else {
$query_string = "?" . preg_replace("/(.*)\\&calMonth=[0-9]{10}\$/", "\$1", $_SERVER['QUERY_STRING']) . "&";
}
} else {
$query_string = "?";
}
$calendar['action_url'] = $_SERVER['PHP_SELF'] . $query_string;
// set the month
$yearmonth = date('Ym', $calendar['monthThis']);
$calendar['yearmonth'] = $yearmonth;
// get entries of the month
$sql = "select FROM_UNIXTIME(created+" . $useroffset * 3600 . ", '%d') as day, blog_id from " . $xoopsDB->prefix($mydirname);
$sql .= " where (FROM_UNIXTIME(created+" . $useroffset * 3600 . ", '%Y%m') = " . $month . ") ";
$sql .= " AND (private='N' or (private='Y' and user_id={$currentuid}))";
$sql .= " group by day ";
$sql .= " order by day ASC";
//echo $sql ;
$lines = $xoopsDB->query($sql);
$entries = array();
if ($lines) {
while (list($day, $blog_id) = $xoopsDB->fetchRow($lines)) {
// $entries[$blog_id] = intval($day);
$entries[intval($day)] = $this_year . $this_month . $day;
}
} else {
return $block['calendar'] = $calendar;
}
$days = array_keys($entries);
// make array of day
// $counts = array_count_values($days); // make day=>count array
// $entries = array_flip($entries); // make day=>blog_id array
// week number of 1st day of this month
$firstcol = date("w", mktime(0, 0, 0, $this_month, 1, $this_year));
// insert entry count corresponding to the day
foreach ($entries as $day => $yyyymmdd) {
$row = ceil(($day + $firstcol) / 7) - 1;
$col = date("w", mktime(0, 0, 0, $this_month, $day, $this_year));
$calendar['details'][$row][$col] = $yyyymmdd;
}
// optional variables in case you replace prev and next month to the months posted any entries
// prev month to show
/* $sql = "select FROM_UNIXTIME(created, '%Y%m') as prevmonth from ".$xoopsDB->prefix($mydirname);
$sql .= " where (private='N' or (private='Y' and user_id=$currentuid))";
$sql .= " and FROM_UNIXTIME(created, '%Y%m') < $yearmonth";
$sql .= " group by prevmonth";
$sql .= " order by prevmonth DESC";
$sql .= " limit 0, 1";
$result = $xoopsDB->query($sql);
if($result) {
list($calendar['prevMonthPosted']) = $xoopsDB->fetchRow($result);
} else {
$calendar['prevMonthPosted'] = "";
}*/
// next month to show
/* if( $yearmonth < date( 'Ym', time() ) ) {
$sql = "select FROM_UNIXTIME(created, '%Y%m') as nextmonth from ".$xoopsDB->prefix($mydirname);
$sql .= " where (private='N' or (private='Y' and user_id=$currentuid))";
$sql .= " and FROM_UNIXTIME(created, '%Y%m') > $yearmonth";
$sql .= " group by nextmonth";
$sql .= " order by nextmonth ASC";
$sql .= " limit 0, 1";
$result = $xoopsDB->query($sql);
if($result) {
list($calendar['nextMonthPosted']) = $xoopsDB->fetchRow($result);
} else {
$calendar['nextMonthPosted'] = "";
}
} else {
$calendar['nextMonthPosted'] = "";
}*/
$calendar['moduledir'] = $mydirname;
$calendar['calblockcss'] = 'db:' . $mydirname . '_calblock.css.html';
$calendar['user_id'] = isset($_GET['user_id']) ? intval($_GET['user_id']) : 0;
$block['calendar'] = $calendar;
return $block;
}
/**
* 指定された年月に日記を書いている日のリストを返す
*/
function p_h_diary_is_diary_written_list4date($year, $month, $c_member_id, $u = null)
{
include_once 'Date/Calc.php';
$pf_cond = db_diary_public_flag_condition($c_member_id, $u);
if ($GLOBALS['_OPENPNE_DSN_LIST']['main']['dsn']['phptype'] == 'pgsql') {
$sql = "SELECT DISTINCT date_part('day', r_datetime) FROM c_diary" . " WHERE c_member_id = ? AND r_datetime >= ? AND r_datetime < ?" . $pf_cond;
} else {
$sql = 'SELECT DISTINCT DAYOFMONTH(r_datetime) FROM c_diary' . ' WHERE c_member_id = ? AND r_datetime >= ? AND r_datetime < ?' . $pf_cond;
}
$date_format = '%Y-%m-%d 00:00:00';
$thismonth = Date_Calc::beginOfMonth($month, $year, $date_format);
$nextmonth = Date_Calc::beginOfNextMonth(0, $month, $year, $date_format);
$params = array(intval($c_member_id), $thismonth, $nextmonth);
return db_get_col($sql, $params);
}
/**
* CMonthCalendar::setDate()
*
* { Description }
*
* @param [type] $date
*/
function setDate($date = null)
{
global $AppUI, $locale_char_set;
$this->this_month = new CDate($date);
$d = $this->this_month->getDay();
$m = $this->this_month->getMonth();
$y = $this->this_month->getYear();
$this->prev_year = new CDate($date);
$this->prev_year->setYear($this->prev_year->getYear() - 1);
$this->next_year = new CDate($date);
$this->next_year->setYear($this->next_year->getYear() + 1);
$date = Date_Calc::beginOfPrevMonth($d, $m, $y, FMT_TIMESTAMP_DATE);
$this->prev_month = new CDate($date);
$date = Date_Calc::beginOfNextMonth($d, $m, $y, FMT_TIMESTAMP_DATE);
$this->next_month = new CDate($date);
}
compare('20001120', Date_Calc::beginOfWeek(22, 11, 2000), 'beginOfWeek');
compare('20001126', Date_Calc::endOfWeek(22, 11, 2000), 'endOfWeek');
compare('20001126', Date_Calc::endOfWeek('22', '11', '2000'), 'endOfWeek str');
compare('20001113', Date_Calc::beginOfPrevWeek(22, 11, 2000), 'beginOfPrevWeek');
compare('20001127', Date_Calc::beginOfNextWeek(22, 11, 2000), 'beginOfNextWeek');
compare('20001113', Date_Calc::beginOfPrevWeek('22', '11', '2000'), 'beginOfPrevWeek str');
compare('20001127', Date_Calc::beginOfNextWeek('22', '11', '2000'), 'beginOfNextWeek str');
compare('20001101', Date_Calc::beginOfMonth(11, 2000), 'beginOfMonth');
compare('20001101', Date_Calc::beginOfMonth('11', '2000'), 'beginOfMonth str');
compare('20001001', Date_Calc::beginOfPrevMonth(22, 11, 2000), 'beginOfPrevMonth');
compare('20001031', Date_Calc::endOfPrevMonth(22, 11, 2000), 'endOfPrevMonth');
compare('20001001', Date_Calc::beginOfPrevMonth('22', '11', '2000'), 'beginOfPrevMonth str');
compare('20001031', Date_Calc::endOfPrevMonth('22', '11', '2000'), 'endOfPrevMonth str');
compare('20001201', Date_Calc::beginOfNextMonth(22, 11, 2000), 'beginOfNextMonth');
compare('20001231', Date_Calc::endOfNextMonth(22, 11, 2000), 'endOfNextMonth');
compare('20001201', Date_Calc::beginOfNextMonth('22', '11', '2000'), 'beginOfNextMonth str');
compare('20001231', Date_Calc::endOfNextMonth('22', '11', '2000'), 'endOfNextMonth str');
compare('19991001', Date_Calc::beginOfMonthBySpan(-13, 11, 2000), 'beginOfMonthBySpan 1');
compare('20001001', Date_Calc::beginOfMonthBySpan(-1, 11, 2000), 'beginOfMonthBySpan 2');
compare('20001101', Date_Calc::beginOfMonthBySpan(0, 11, 2000), 'beginOfMonthBySpan 3');
compare('20001201', Date_Calc::beginOfMonthBySpan(1, 11, 2000), 'beginOfMonthBySpan 4');
compare('20011201', Date_Calc::beginOfMonthBySpan(13, 11, 2000), 'beginOfMonthBySpan 5');
compare('19990101', Date_Calc::beginOfMonthBySpan('-13', '02', '2000'), 'beginOfMonthBySpan 6 str');
compare('19990101', Date_Calc::beginOfMonthBySpan(-13, 2, 2000), 'beginOfMonthBySpan 6');
compare('20000101', Date_Calc::beginOfMonthBySpan(-1, 2, 2000), 'beginOfMonthBySpan 7');
compare('20000201', Date_Calc::beginOfMonthBySpan(0, 2, 2000), 'beginOfMonthBySpan 8');
compare('20000301', Date_Calc::beginOfMonthBySpan(1, 2, 2000), 'beginOfMonthBySpan 9');
compare('20010301', Date_Calc::beginOfMonthBySpan(13, 2, 2000), 'beginOfMonthBySpan 10');
compare('20010301', Date_Calc::beginOfMonthBySpan('13', '02', '2000'), 'beginOfMonthBySpan 10 str');
compare('19991031', Date_Calc::endOfMonthBySpan(-13, 11, 2000), 'endOfMonthBySpan 1');
compare('20001031', Date_Calc::endOfMonthBySpan(-1, 11, 2000), 'endOfMonthBySpan 2');
