get_req_var('getcalendarevents')) { $day = $whmcs->get_req_var('day'); if (!$day) $day = date("d"); echo '

'; if ($day==date("d")) echo 'Today, '.date("jS F Y",mktime(0,0,0,date("m"),$day,date("Y"))); elseif ($day==date("d")-1) echo 'Yesterday, '.date("jS F Y",mktime(0,0,0,date("m"),$day,date("Y"))); elseif ($day==date("d")+1) echo 'Tomorrow, '.date("jS F Y",mktime(0,0,0,date("m"),$day,date("Y"))); else echo date("l, jS F Y",mktime(0,0,0,date("m"),$day,date("Y"))); echo '

'; $numproducts = get_query_val("tblhosting","COUNT(id)","domainstatus IN ('Active','Suspended') AND nextduedate='".date("Y-m-").(int)$day."'"); $numaddons = get_query_val("tblhostingaddons","COUNT(id)","status IN ('Active','Suspended') AND nextduedate='".date("Y-m-").(int)$day."'"); $numdomains = get_query_val("tbldomains","COUNT(id)","status IN ('Active') AND nextduedate='".date("Y-m-").(int)$day."'"); $numtodoitems = get_query_val("tbltodolist","COUNT(id)","duedate='".date("Y-m-d",mktime(0,0,0,date("m"),$day,date("Y")))."'"); $numevents = get_query_val("tblcalendar","COUNT(id)","start>='".mktime(0,0,0,date("m"),$day,date("Y"))."' AND start<'".mktime(0,0,0,date("m"),$day+1,date("Y"))."'"); if ($numproducts==0 && $numaddons==0 && $numdomains==0 && $numtodoitems==0 && $numevents==0) echo '

No Events Scheduled

'; else echo '

'.$numproducts.' Products/Services Due to Renew

'.$numaddons.' Addons Due to Renew

'.$numdomains.' Domains Due to Renew

'.$numtodoitems.' To-Do Items Due

'.$numevents.' Events Scheduled

'; echo '

Add New Event

'; exit; } $jscode = 'function loadCalEvents(day) { $.post("index.php", { getcalendarevents: 1, day: day }, function(data){ jQuery("#eventslist").html(data); }); }'; $jquerycode = 'loadCalEvents();'; $title = "Calendar"; $content = ' '; $headings = array('S','M','T','W','T','F','S'); $calendar = '

'; $month = date("m"); $year = date("Y"); $running_day = date('w',mktime(0,0,0,$month,1,$year)); $days_in_month = date('t',mktime(0,0,0,$month,1,$year)); $days_in_this_week = 1; $day_counter = 0; $dates_array = array(); $calendar.= ''; for($x = 0; $x < $running_day; $x++){ $calendar.= ''; $days_in_this_week++; } for($list_day = 1; $list_day <= $days_in_month; $list_day++){ $events = false; $calendar.= ''; if($running_day == 6){ $calendar.= ''; if(($day_counter+1) != $days_in_month){ $calendar.= ''; } $running_day = -1; $days_in_this_week = 0; } $days_in_this_week++; $running_day++; $day_counter++; } if($days_in_this_week < 8): for($x = 1; $x <= (8 - $days_in_this_week); $x++): $calendar.= ''; endfor; endif; $calendar.= '

'; return array('title'=>$title,'content'=>$content.$calendar,'jscode'=>$jscode,'jquerycode'=>$jquerycode); } add_hook("AdminHomeWidgets",1,"widget_calendar"); ?>

'.implode('	',$headings).'
	'.$list_day.'