<?php
include_once("dataClass.php");
/*
 * this file contain functions
 *  responsible for communicating with database
 */
class DBAccessor {
/**
 * this function takes in type of oject together with anyspecific arguments,
 *  queries DB for it and returns it as XML
 *  
 *  it also calls sending emails confirming DB changes
 * 
 * @param $objectType
 * @param $aguments
 * @return XML representation of that object
 */


  function queryXMLObjects($queryType, $arguments,SlideData $slideData = null){
  	$queryTxt = "";
  	global $slides,$comments_on_slides,$add_slide,$confirm_slide ,$edit_slide;
  	//$result = "";
  	//echo(" queryXMLObjects ".$objectType.$arguments);
	switch ($queryType) {
		case $slides: 
			$queryTxt ="SELECT * FROM Slide";
			break;
		case $comments_on_slides:
			$queryTxt  = 'SELECT c.`CommID`, c.`CommentText` CommentText, u.`ScreenName` User,' 
		. '	t.CommTypeName CommType, s.`CommStatName` CommStatus'
        . ' FROM `Comment` c,`User` u, `CommentType` t, `CommentStatus` s '
        . ' WHERE c.`SlideUID`=\''.$arguments.'\' && u.`UserUID`=c.`UserUID` && c.`CommTypeUID`=t.`CommTypeUID` '
        . ' && c.`CommStatus`=s.`CommStatUID`';

			break;
		case $add_slide: 
			 if($slideData != null) $slideData= SlideData::produceSlideData($arguments);
			 
			 	
			 	$queryTxt = "INSERT INTO Slides (SlideUID, author, SlideName, SlideURL, statusID, token) VALUES 
			 	(".$slideData->getSlideUID().",".$slideData->getAuthor().",".$slideData->getSlideName()
			 	.",".$slideData->getSlideURL().",".$slideData->getStatus().", ".$slideData->getToken().")";
			 	
			 	//send email confirming adding the slide
			 	sendSlideEmail($queryType, $arguments, $slideData);
			 
			 
			break;	
		case $confirm_slide: 
			if($slideData != null)
			 {
				$queryTxt ="UPDATE Slides SET statusID=\"111\"
				WHERE SlideUID=\"".$slideData->getSlideUID()."\" 
				AND statusID=\"112\"";
			 }
			break;
		case $edit_slide: 
			if($slideData != null)
			 {
				$queryTxt ="UPDATE Slides SET author=\"".$slideData->getAuthor()."\", SlideName=\"".$slideData->getSlideName()
			 	."\", SlideURL=\"".$slideData->getSlideURL()."\", statusID=\"".$slideData->getStatus()
			 	."\" WHERE SlideUID=\"".$slideData->getSlideUID()." ";
			 }
			break;
	
	}
	echo($queryTxt);
	$result = $this->queryDB($queryTxt);
	makeXMLObject($result,$queryType,$arguments);

	
  }

   function queryDB($queryText){
   	//echo($queryText);

//User, password & database
	$user="po27";
	$password="po27";
	$database="po27";
	//conncect
	mysql_connect("mysql-server-1",$user,$password);
	@mysql_select_db($database) or die( "Unable to connect to database");
	
	//Get values from the database
	$result=mysql_query($queryText);
	//disconnect
	mysql_close();
	return $result;

  }//finish
}//finish class

?>