* Copyright (c) 2009 Platon Technologies Ltd, http://platon.sk * All rights reserved. */ require_once dirname(__FILE__)."/../../config/db-config.inc.php"; require_once dirname(__FILE__)."/../../lib/db-core/db-core.inc.php"; function getEventsOfMonth($date = NULL) { // vrati daneho mesiaca if (($date==NULL) or ($date=="")) { return NULL; } $date1=date("Y-m-01",strtotime($date)); $date2=date("Y-m-t",strtotime($date)); ezin_open_db_connection(); $query = sprintf('SELECT *' .' FROM ezin_articles' .' WHERE calendar_flag >= "%s"' .' AND calendar_flag <= "%s"', $date1, $date2); $result = mysqli_query($GLOBALS["ezin_db_handle"], $query); $return=Array(); while (($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) != null) { $day = date("j",strtotime($row['calendar_flag'])); //echo $day."
"; $return[$day][$row['id']] = $row; } mysqli_free_result($result); ezin_close_db_connection(); //print_r($return); return $return; } $get_position=$_POST["position"]; $get_idCalendar=$_POST["idCalendar"]; $requestFromWeb=0; // ak bolo volana sluzba uz z webu = 1, ak zo sablony = 0 $calendar_linkForArticle_end="&ezin_tmpl_calendar_source=1"; // ak =1 potom kalendarik ostava v tom istom mesiaci if (isset($get_position)) { $calendar_linkForArticle="article.php?"; if (isset($get_idCalendar)) { $requestFromWeb=1; echo getCalendar($get_position,$get_idCalendar); } else { echo getCalendar($get_position); } } else { $calendar_linkForArticle=$ezin_url."article.php?"; } function getCalendar($position = NULL, $idCalendar = NULL ) { // position je typu datetime (YYYY-MM-DD HH:MM:SS) if ($idCalendar==NULL) {$idCalendar="cal-".Time().Rand(1,1000);} $ret=""; if ($GLOBALS["requestFromWeb"]==1) { $ret=$ret.$idCalendar."|"; } $DATA_eventsOfDay=""; if ($position==NULL) {$position=Time();} else {$position=strtotime($position);} $numberOfDays=date("t",$position); // pocet dni v mesiaci $firstDayOfMonth=date("Y-m-",$position)."01"; // datum prveho dna v mesiaci $firstDayOfMonth=date("N",strtotime($firstDayOfMonth)); // prvy den v mesiaci 1=Pondelok ... 7=Nedela $startPoint=2-$firstDayOfMonth; // pocitadlo pri vpisovani dni do tabulky $nameOfMonth=Array("Január","Február","Marec","Apríl","Máj","Jún","Júl", "August","September","Október","November","December"); $numberOfMonth=date("m",$position); // cislo mesiaca $numberOfYear=date("Y",$position); // cislo roku $ret_eventsOfMonth=getEventsOfMonth($numberOfYear."-".$numberOfMonth."-1"); $numberOfNextMonth=$numberOfMonth+1; if ($numberOfNextMonth>12) {$numberOfNextMonth=1; $numberOfNextYear=$numberOfYear+1;} else {$numberOfNextYear=$numberOfYear;} $numberOfPreviousMonth=$numberOfMonth-1; if ($numberOfPreviousMonth<1) {$numberOfPreviousMonth=12; $numberOfPreviousYear=$numberOfYear-1;} else {$numberOfPreviousYear=$numberOfYear;} $ret=$ret." "; if ($GLOBALS["requestFromWeb"]!=1) { $ret=$ret."

"; } $ret=$ret." "; $DATA_eventsOfDay="\n\n"; for ($a=0; $a<=5; $a++) { $ret .= "\n"; for ($b=1; $b<=7; $b++) { $events=NULL; $numberId=($a*7)+$b; if (($startPoint>0) and ($startPoint<=$numberOfDays)) { $numberDay=$startPoint; $classDay="monthday"; //$events=getEventsOfDay($numberOfYear."-".$numberOfMonth."-".$numberDay); $events=$ret_eventsOfMonth[$numberDay]; } else { $numberDay=""; $classDay="nomonthday"; } $startPoint++; if ($events==NULL) { $ret=$ret." "; } else { $ret=$ret." "; $keysOfEvents=array_keys($events); $DATA_eventsOfDay=$DATA_eventsOfDay."

\n"; $DATA_eventsOfDay .= "\n"; // id=calendar-popup $DATA_eventsOfDay .= "

\n"; } } $ret=$ret." "; } $DATA_eventsOfDay .= "\n\n"; $ret=$ret."

	".$nameOfMonth[$numberOfMonth-1]." ".$numberOfYear."
P	U	S	Š	P	S	N

".$numberDay."	".$numberDay."

"; if ($GLOBALS["requestFromWeb"]!=1) { $ret=$ret."

"; } $ret=$ret.$DATA_eventsOfDay; return $ret; } ?>