hebEngCal.php

<?php
class HeEnEventCal{
	public function __construct($tableName="",$dateField="",$linkIdField="",$dateFormat="",$linkURL="",$dbArray=Array(),$days=60, $hebTitles=TRUE,$eventText=FALSE,$eventTextField="",$method="RSS"){
		$this->tableName = $tableName;
		$this->dateField = $dateField;
		$this->dateFormat = $dateFormat;
		$this->linkURL = $linkURL;
		$this->days = $days;
		$this->eventText=$eventText;
		$this->eventTextField=$eventTextField;
		$this->hebTitles = $hebTitles;
		$this->linkIdField = $linkIdField;
		$this->method=$method;
		$this->PDOStr="'mysql:host=$dbArray[0];dbname=$dbArray[1]','$dbArray[2]' ,'$dbArray[3]'" ;
		$this->PDOArray=$dbArray;
	}
	public function setDbParams($dbArray){
		$this->PDOArray = $dbArray;
        }
        
	public function assembleRSSArray($RSSurl){
		$rss = new DOMDocument();
		$rss->load('$RSSurl');
		$feed = array();
		$today = new DateTime();
		$interval = DateInterval("P".$this->days."D"); 
		$endDate = $today::add($interval);
		for ($i=0;$i<$this->days;$i++ ){ //$rss->getElementsByTagName('item') as $node) {
			$date = explode(" ", $node->getElementsByTagName('pubDate')->item(0)->nodeValue);
			$eventDate = DateTime::createFromFormat($this->dateFormat,$node->getElementsByTagName('pubDate')->item(0)->nodeValue);
			$interval = $datetime2->diff($datetime1);
			
				
				
				$item = array ( 
					'title' => $node->getElementsByTagName('title')->item(0)->nodeValue,
					'link' => $node->getElementsByTagName('link')->item(0)->nodeValue,
					'date' => $date[1]."-".$date[2]."-".$date[3],
					);
				array_push($feed, $item);
			}
	}
        
	protected $enHebMonths = array("תשרי"=>"Tishrei","חשון"=>"Cheshvan","כסלו"=>"Kislev","טבת"=>"Tevet","שבט"=>"Shevat","אדר"=>"Adar","אדר א'"=>"Adar I",
	"אדר ב'"=>"Adar II","ניסן"=>"Nissan","אייר"=>"Iyar","סיון"=>"Sivan","תמוז"=>"Tammuz","אב"=>"Av","אלול"=>"Elul"); // need to check spellings of months in php hebrew dates functions
	protected $hebGregMonths = array("January"=>"ינואר","February"=>"פברואר","March"=>"מרץ","April"=>"אפריל","May"=>"מאי","June"=>"יוני",
	"July"=>"יולי","August"=>"אוגוסט","September"=>"ספטמבר","October"=>"אוקטובר","November"=>"נובמבר","December"=>"דצמבר" );
	
	public function printCal(){
		echo '<table class="hebEngCal" border="2" cellpadding="3px" ><caption><b>';
		if($this->hebTitles){
		echo 'אירועים קרובים';
		}else{
			echo 'Upcoming Events';
		}
		echo '</b><br />';	
		$today = new DateTime();
                $two = new DateInterval(P1D);
                $yesterday = $today->sub($two);
                $wDay = date('N');	
	//	setlocale(LC_TIME, "heb_heb"); // is this necessary? does it do anything?
		$formattedDate = clone $yesterday;
		/* get month range and display it in calendar <caption> tag *** still  need to fix adar I, II quirk *** */
		$hebMonth = clone $yesterday;
                $gregDate = gregoriantojd($hebMonth->format('n'),$hebMonth->format('j'),$hebMonth->format('Y'));
		$jewDate = jdtojewish($gregDate,TRUE,CAL_JEWISH_ADD_GERESHAYIM);
		$jewdStr = iconv ('WINDOWS-1255', 'UTF-8', $jewDate);
		$jewDay1 = explode(" ", $jewdStr);
		$hebMonth->add(new DateInterval("P".$this->days."D"));
		$gregDate2 = gregoriantojd($hebMonth->format('n'),$hebMonth->format('j'),$hebMonth->format('Y'));
		$jewDate2 = jdtojewish($gregDate2,TRUE,CAL_JEWISH_ADD_GERESHAYIM);
		$jewdStr2 = iconv ('WINDOWS-1255', 'UTF-8', $jewDate2);
		$jewDay2 = explode(" ", $jewdStr2);
		if($this->hebTitles){
			echo $jewDay1[1]." - ".$jewDay2[1]."<br />"; // print Hebrew months in Hebrew
		}else{
			echo $this->enHebMonths[$jewDay1[1]]." - ".$this->enHebMonths[$jewDay2[1]]."<br />"; // transliterate names of Hebrew months
		}
		$engMonth1 = $formattedDate->format('F'); // month
		$range = 1;
		if((date('j')+$this->days)>30){ // determine how many months the calendar spans
			$range = ceil($this->days/30);
		}
		$formattedDate->add(new DateInterval("P".$range."M"));
		$engMonth2 = $formattedDate->format('F');
		if($this->hebTitles){
			echo $this->hebGregMonths[$engMonth1]." - ".$this->hebGregMonths[$engMonth2];  // print Gregorian months in Hebrew
		}else{
		echo $engMonth1." - ".$engMonth2; // Gregorian months in plain English
		}
		if($this->hebTitles){
			echo "</caption><tr><th>א'</th><th>ב'</th><th>ג'</th><th>ד'</th><th>ה'</th><th>ו'</th><th>ש'</th></tr><tr>";
		}else{
			echo "</caption><tr><th>Sun</th><th>Mon</th><th>Tue</th><th>Wed</th><th>Thu</th><th>Fri</th><th>Sat</th></tr><tr>";
		}
		for($i=0;$i<=$wDay-2;$i++){
			echo "<td></td>";
		}
		$bgClass = 1; // determines background color of month
		$calDate = clone $yesterday;
		$data  = $this->PDOArray;	
		$dbh = new PDO("mysql:host=$data[0];dbname=$data[1]","$data[2]" ,"$data[3]" );
		$dbh->setAttribute(PDO::ATTR_EMULATE_PREPARES, 1);
		if($this->eventText){
			$statement=$dbh->prepare("SELECT ".$this->linkIdField.", ".$this->eventTextField." FROM ".$this->tableName." WHERE ".$this->dateField." = ?");
		}else{
			$statement=$dbh->prepare("SELECT ".$this->linkIdField." FROM ".$this->tableName." WHERE ".$this->dateField." = ?");
		} 
	//	echo var_dump($dbh);
		for($i=0;$i<$this->days;$i++){
			
			if($calDate->format('j')==1 && $i>0){ // need to find a solution to change class at beginning of Hebrew month instead
				$bgClass++;
			}
			$tdClass = 'color'.strval($bgClass);
			echo "<td class='$tdClass'><div class='event'>";
			echo '<span class="secDate">';
			echo $calDate->format('j');
			echo "</span>";
			echo "<span class='jDate'>";
			$gDate = gregoriantojd($calDate->format('n'),$calDate->format('j'),$calDate->format('Y'));
			$jDate = jdtojewish($gDate,TRUE,CAL_JEWISH_ADD_GERESHAYIM);
			$jdStr = iconv ('WINDOWS-1255', 'UTF-8', $jDate);
			$jDay = explode(" ", $jdStr);
			echo $jDay[0]."</span>";
			/* content for date */
			$queryDate = $calDate->format($this->dateFormat);
			$statement->bindParam(1,$queryDate);
			$statement->execute();
			$result = $statement->fetch(PDO::FETCH_BOTH);
			if (!empty($result)) { // if event exists for given date
				if($this->eventText){
					echo "<br /><a href='$this->linkURL"."$result[0]' class='cal_link'><div style='width:100%;height:100%'>$result[1]</div></a> ";
				}else{
					echo "<a href='$this->linkURL"."$result[0]' class='cal_link'><div style='width:100%;height:100%'>&nbsp;</div></a> ";
				}
			}else{
				// echo "<div style='height:100%'>&nbsp;</div>";
			}
			echo "</div></td>";
			if(($i+$wDay) % 7 == 0){
				echo "</tr><tr>";
			}
			$calDate->add(new DateInterval('P1D'));	
			if($i==($this->days-1)){
				for($j=1;$j<(5-$wDay);$j++){
					echo "<td></td>";
				}
			}
		}
		echo "</tr></table>";
	}
}

?>