<?php
/*	This script uses a template and must set the following variables which a template file (a php script) will use.
 *	$_title
 *	$_javascript
 *	$_css
 *	$_head
 *	$_content
 *	$_keywords
 *	$_descrioption
 */
	require_once('/web/data/groups/exlinfo/config/mysql.inc');		//include mysql connection
	require_once('form/form.php');		//include form objects
	require_once('inc/Table.php');			//include table object
	require_once('inc/common.php');
	$templateFile = "templates/summer-new.php";
//	$templateFile = "/groupdirs/webfolders/exlinfo/public_html/templates/summer-new.html";
	$confFile = "secure/conf";
	
	
	//Read admin's settings for this page from a conf. file
	$parameters = unserialize(file_get_contents($confFile));
	if(is_array($parameters) && !count($parameters) == 0 && $parameters !== false){
		$show_summer_session_checkboxes = $parameters["show_summer_session_checkboxes"];
		$show_winter_session_checkboxes = $parameters["show_winter_session_checkboxes"];
		$show_openOnly = $parameters["show_open_only_checkbox"];
		$show_onlineOnly = $parameters["show_online_only_checkbox"];
//		$pageTitle = $parameters["pageTitle"];
//		$term = $parameters["term"];
		$pageTitle = 'Summer 2013 Class Search';		
		$term = 2135;
	}else{
		$show_summer_session_checkboxes = true;
		$show_winter_session_checkboxes = false;
		$show_openOnly = true;
		$show_onlineOnly = true;
		$term = 2115;
		$pageTitle = termToEnglish($term) . " Class Search (Tseng College of Extended Learning) | Cal. State. Northridge";
		if(strpos($_SERVER['REMOTE_ADDR'], '130.166.7') !== false){
			//Warn people if page is being accessed from the tseng college building. (subnet 7)
			$_javascript = "alert(\"Couldnt read search settings. Assuming defaults. Please Notify Kev. NOTE: Students will not see this message.\");";
		}
	}
	$englishTerm = termToEnglish($term);
	
	$errors = array();
	
	
	//Read user's search params from URL (and sanitize)
	foreach($_GET as &$param){
		$param = mysql_real_escape_string(htmlspecialchars(trim($param)));
	}
	if($term % 10 != 5){
		$show_summer_session_checkboxes = false;
	}
	if(isset($_GET["submit_form"])){
		if($show_openOnly === true){
			$_GET["openOnly"] = (!isset($_GET["openOnly"])) ? false : true;
		}
		if($show_onlineOnly === true){
			$_GET["onlineOnly"] = (!isset($_GET["onlineOnly"])) ? false : true;
		}
		$show_summer_session_checkboxes = true;//Add session checkboxes for the Summer 2013
		if($show_summer_session_checkboxes === true){
			$_GET["s1"] = (!isset($_GET["s1"])) ? false : true;
			$_GET["s2"] = (!isset($_GET["s2"])) ? false : true;
			$_GET["s3"] = (!isset($_GET["s3"])) ? false : true;
		}
		if($show_winter_session_checkboxes === true){
			$_GET["c1"] = (!isset($_GET["c1"])) ? false : true;
			$_GET["c2"] = (!isset($_GET["c2"])) ? false : true;
		}
	}else{
		$_GET["openOnly"] = false;
		$_GET["onlineOnly"] = false;
		$_GET["s1"] = true;
		$_GET["s2"] = true;
		$_GET["s3"] = true;
		$_GET["criteria"] = "Dept (4-letter code)";
	}

	//Generate Search form
	$options = array("Subject"=> new Option("Subject"), "Dept (4-letter code)" => new Option("Dept (4-letter code)"), "Class Number" => new Option("Class Number"), "Class Title" => new Option("Class Title"), "Professor" => new Option("Professor"),);
	$form["criteriaDropdown"] = new Select("criteria", $options, $options["Subject"], "By:", null, array("onchange"=>"toggleSubjectDropdown(this)"));
	$form["searchField"] = new Text("query", "", "");
	$form["openOnlyCheckbox"] = new Checkbox("openOnly", "true", true,  "Show Open Classes Only");
	$form["onlineOnlyCheckbox"] = new Checkbox("onlineOnly", "true", true,  "Show Online Classes Only");
	$form["s1Checkbox"] = new Checkbox("s1", "true", true,  "S1");
	$form["s2Checkbox"] = new Checkbox("s2", "true", true,  "S2");
	$form["s3Checkbox"] = new Checkbox("s3", "true", true,  "S3");
	$form["c1Checkbox"] = new Checkbox("c1", "true", true, "Component 1 (online/hybrid)");
	$form["c2Checkbox"] = new Checkbox("c2", "true", true, "Component 2 (face-to-face)");
	$form["subject"] = new Select("subject", array(), null, "Subject");
	$form["submit_form"] = new Submit("submit_form", "Search");
		//Populate the subject Select box with data from db.
		
		
	$sql = "SELECT DISTINCT DeptName FROM SubjectAreas S, SOLARClasses C WHERE C.Term = $term AND C.Dept = S.DeptCode AND (C.ClassStatus = 'Active' OR C.ClassStatus = 'Cancelled') ORDER BY DeptName";
	$result = mysql_query($sql);
	$subjects = array("" => new Option(""));
	if($result !== false){
		while($row = mysql_fetch_assoc($result)){
			$truncated = (strlen($row["DeptName"]) > 39) ? substr($row["DeptName"], 0, 39) . "..." : $row["DeptName"];
			$subjects[$row["DeptName"]] = new Option($truncated);
			$subjects[$row["DeptName"]]->addAttribute("title", $row["DeptName"]);
		}
		$form["subject"]->setOptions($subjects);
	}
	unset($sql);
	
	
	//Populate form with params previously entered into the form or load default values
	if(!empty($_GET["query"])){
		$form["searchField"]->setValue($_GET["query"]);
	}
	if($_GET['criteria'] == "Subject"){
			//capitalize the first letter in each word.
		$str = "";
		$parts = explode(" ", $_GET["subject"]);
		foreach($parts as &$part){
			$str .= ucfirst($part) . " ";
		}
		$str = substr_replace($str, "", strlen($str)-1);
		$_GET["subject"] = $str;		
		$form["subject"]->setSelected($_GET["subject"]);
		unset($_GET["query"]);
	}
	else{
		unset($_GET["subject"]);
	}
	if(isset($_GET['submit_form'])){
		if(!empty($_GET["criteria"])){
			$form["criteriaDropdown"]->setSelected($_GET["criteria"]);
		}
		$form["openOnlyCheckbox"]->setChecked($_GET["openOnly"]);
		$form["onlineOnlyCheckbox"]->setChecked($_GET["onlineOnly"]);
		$form["s1Checkbox"]->setChecked($_GET["s1"]);
		$form["s2Checkbox"]->setChecked($_GET["s2"]);
		$form["s3Checkbox"]->setChecked($_GET["s3"]);
		$form["c1Checkbox"]->setChecked($_GET["c1"]);
		$form["c2Checkbox"]->setChecked($_GET["c2"]);
	}else{		//load default values
		$form["openOnlyCheckbox"]->setChecked(false);
		$form["onlineOnlyCheckbox"]->setChecked(false);
		$form["s1Checkbox"]->setChecked(true);
		$form["s2Checkbox"]->setChecked(true);
		$form["s3Checkbox"]->setChecked(true);
		$form["c1Checkbox"]->setChecked(true);
		$form["c2Checkbox"]->setChecked(true);
	}
	

	//Genereate SQL query using admin's settings and user's search params
	$searchBySubject = false;
	if($_GET["criteria"] == "Subject" && isset($_GET["subject"]) && !empty($_GET["subject"])){
		$searchBySubject = true;
		$sql = <<<SQL
			SELECT CONCAT(Dept, ' ', Number) AS DeptNum, SS.CourseID, Session, Section, Enrolled, Capacity, Title, SS.ClassNbr, SS.ClassStatus, SC.Units, TitleLong 
			FROM SubjectAreas A, SOLARClasses SS, SOLARCatalog SC 
			WHERE 
SQL;
	}else{
		$sql = <<<SQL
			SELECT CONCAT(Dept, ' ', Number) AS DeptNum, SS.CourseID, Session, Section, Enrolled, Capacity, Title, SS.ClassNbr, SS.ClassStatus, SC.Units, TitleLong
			FROM SOLARClasses SS, SOLARCatalog SC 
			WHERE 
SQL;
	}
	$sql .= "SS.CourseID = SC.CourseID ";
	$sql .= "AND ShowClass = 'Yes' ";
	$sql .= "AND (ClassStatus = 'Active' OR ClassStatus = 'Cancelled') ";
	if(isset($term) && !empty($term)){
		$sql .= "AND `Term` = $term ";
	}
	$show_summer_session_checkboxes = true;//Add session checkboxes for the Summer 2013
	if($show_summer_session_checkboxes === true){
		$sql .= "AND `Session` LIKE 'S_' ";
		$sql .= ($_GET['s1'] === false) ? "AND `Session` != 'S1' " : "";
		$sql .= ($_GET['s2'] === false) ? "AND `Session` != 'S2' " : "";
		$sql .= ($_GET['s3'] === false) ? "AND `Session` != 'S3' " : "";
	}
	if($show_winter_session_checkboxes === true){
		$sql .= ($_GET['c1'] === false) ? "AND NOT `DateStart` < '2012-01-03' " : "";
		$sql .= ($_GET['c2'] === false) ? "AND NOT `DateStart` >= '2012-01-03' " : "";
	}
	if($show_openOnly === true && $_GET['openOnly'] === true){
		$sql .= "AND Enrolled < Capacity ";
	}
	if($show_onlineOnly === true && $_GET['onlineOnly'] === true){
		$sql .= "AND Online = 'Yes' ";
	}
	if($searchBySubject){				//search by subject
		$sql .= "AND SS.Dept = A.DeptCode ";
		$sql .= "AND DeptName LIKE '%{$_GET["subject"]}' ";
	}
	else if(isset($_GET["criteria"])){	//search by 'criteria'
		if($_GET["criteria"] == "Dept (4-letter code)"){
	//		$query = str_replace(" ", "", $_GET['query']);
			$query = $_GET['query'];
			$pattern = "/[a-zA-Z\s]+(\s)[0-9]+[0-9A-Za-z]+/";
			$found = preg_match($pattern, $query, &$matches, PREG_OFFSET_CAPTURE);
			if($found == 1){
				$query = substr_replace($query, "", $matches[1][1], 1) . "\n";
				$query = trim($query);
			}
			$sql .= "AND CONCAT(Dept, Number) LIKE '%$query%'";
		}
		else if($_GET["criteria"] == "Class Number"){
			$sql .= "AND SS.ClassNbr LIKE '%{$_GET['query']}%' ";
		}
		else if($_GET["criteria"] == "Class Title"){
			$sql .= "AND SC.TitleLong LIKE '%{$_GET['query']}%' ";
		}
		else if($_GET["criteria"] == "Professor"){
			$sql .= "AND Instructor LIKE '%{$_GET['query']}%' ";
		}
	}
	$sql .= "ORDER BY DeptNum, Section ";
	
	
	//Execute Query
	$result = mysql_query($sql);
	
	
	//Instantiate table
	if($result !== false){
		$table = new Table($result);
	}else{
		$errors[] = "An unknown error occured. Please try again or notify the Tseng College tech support if the problem persists.";
	}
	
	//Process Table data
	if(count($errors) == 0){
		foreach($table->table as $row){
			//make enrollment column
			if($row["Enrolled"]->getInnerHTML() >= $row["Capacity"]->getInnerHTML()){
				$row["Enrolled"]->addAttribute("style", "color: red; ");
			}
			$row["Enrolled"]->setInnerHTML($row["Enrolled"]->getInnerHTML()."/".$row["Capacity"]->getInnerHTML());
			$row["Capacity"] = null;
		
			//trucate long titles & add class attribute to title column
			if(strlen($row["TitleLong"]->getInnerHTML()) >= 40){
				$row["TitleLong"]->addAttribute("title", $row["TitleLong"]->getInnerHTML());
				$row["TitleLong"]->setInnerHTML(substr($row["TitleLong"]->getInnerHTML(), 0, 37) . "...");
			}
			$row["TitleLong"]->addAttribute("class", "class_title_col");
		
			//Add class attribute to title column
			
			
			//make the class (DeptNum) column links
			$link = "<a href= \"view_summer.php?courseID={$row["CourseID"]->getInnerHTML()}&term=$term&ses={$row["Session"]->getInnerHTML()}&sec={$row["Section"]->getInnerHTML()}\" >";
			$link .= $row["DeptNum"]->getInnerHTML() . "</a>";
			$row["DeptNum"]->setInnerHTML($link);
		}
		if(isset($_GET["moreInfo"])){
			$colValues = array("DeptNum", "ClassNbr", "Session", "Section", "TitleLong", "Enrolled");
			$colTitles = array("Course", "Class #", "Session", "Section #", "Class Title", "Enrollment");
		} else{
	//		$colValues = array("DeptNum", "ClassNbr", "Session", "Section", "TitleLong");
	//		$colTitles = array("Course", "Class #", "Session", "Section #", "Class Title");
			
			$colValues = array("DeptNum", "TitleLong", "ClassNbr", "Section", "Session");
			$colTitles = array("Course", "Class Title", "Class #", "Section #", "Session");
		}
		$table->setValues($colValues);
		$table->setTitles($colTitles);
		$table->setAttribute("class", "table");
	}
	$_css = <<<END
		#tables_container tr:nth-child(1) th:nth-child(2){
			width: 6em;
		}
END;
	
	//Get form HTML
	$openOnlyCheckboxesHTML = ($show_openOnly === true) ? $form["openOnlyCheckbox"]->getLabel() . " " . $form["openOnlyCheckbox"] . "<br />" : "";
//	$onlineOnlyCheckboxesHTML = ($show_onlineOnly === true) ? $form["onlineOnlyCheckbox"]->getLabel() ." " . $form["onlineOnlyCheckbox"] . "<br />" : "";
	$onlineOnlyCheckboxesHTML = '';
	$show_summer_session_checkboxes = true;//Add session checkboxes for the Summer 2013
	$sessionCheckboxesHTML = ($show_summer_session_checkboxes === true) ? "Show Sessions: " . $form["s1Checkbox"]->getLabel().$form["s1Checkbox"] .$form["s2Checkbox"]->getLabel().$form["s2Checkbox"] . $form["s3Checkbox"]->getLabel().$form["s3Checkbox"] . "<br />" : "";
	$winterSessionCheckboxesHTML = ($show_winter_session_checkboxes === true) ? $form["c1Checkbox"].$form["c1Checkbox"]->getLabel() ."<br />". $form["c2Checkbox"].$form["c2Checkbox"]->getLabel()."<br />" : "";
	$form = <<<FORM
<h1>$englishTerm Class Search</h1>
<form action= "{$_SERVER['PHP_SELF']}" method= \"GET\" id= "search">
	<fieldset>
		<legend>Search</legend>
		{$form["criteriaDropdown"]->getLabel()} {$form["criteriaDropdown"]} {$form["searchField"]}{$form["subject"]}<br />
		$openOnlyCheckboxesHTML
		$onlineOnlyCheckboxesHTML
		$sessionCheckboxesHTML
		$winterSessionCheckboxesHTML
		{$form["submit_form"]}
	</fieldset>
</form>
	<!-- <p id= "or">OR</p> 
<form action= "{$_SERVER['PHP_SELF']}" method= \"GET\" id= "search">
	<fieldset id= "subject_fieldset">
		<legend>Search by Subject</legend>
		{$form["subject"]}<br />
		$openOnlyCheckboxesHTML
		$onlineOnlyCheckboxesHTML
		$sessionCheckboxesHTML
		{$form["submit_form"]}
	</fieldset>
</form> 
-->
FORM;

	//Set meta data
	$_title = (!empty($pageTitle)) ? $pageTitle : $englishTerm . " Class Search (Tseng College of Extended Learning) | Cal. State. Northridge";	
	$_keywords = $englishPlease." Class Search, " . "Cal State Northridge, EXL, Extended Leargning, California State University Northrige";
	if($searchBySubject){
		$_keywords .= ", {$_GET["subject"]}";
	}elseif(isset($_GET["submit_form"])){
		$_keywords .= ", {$_GET["query"]}";
	}
	$_description = "A simple form for students to use to search for $englishPlease classes at California State University Northridge.";
	
	//Create HTML error messages
	if(count($errors) != 0){
		$errorHTML = "<div id= \"errors_div\"><ul>";
		foreach($errors as $error){
			$errorHTML .= "<li>$error</li>";
		}
		$errorHTML .= "</ul></div>";
	}else{
		$errorHTML = "";
	}
	
	//Assemble Content to go on page.	
	$_content = $errorHTML . $form . $table;
	$_head .= '<link rel= "stylesheet" type= "text/css" href= "css/tables.css" />';
	$_head .= '<link rel= "stylesheet" type= "text/css" href= "css/search.css" />';
	$_head .= '<script src="js/search.js" type="text/javascript"></script>';
	
	
	//Display Page by Including Template
	require($templateFile);

?>