report2.php

<?php
include_once('parts/sqlCredentials.php');
include_once('parts/header.php');

if ($_GET['spoof'])
{
	$_SESSION['id'] = '100000701787133';	// yangyang
//	$_SESSION['id'] = '1311043319';	// mitra
}
else
	$_SESSION['id'] = '517821541';

$connection=mysqli_connect($sqlHost,$sqlUser,$sqlPass,$sqlDB);
$query = sprintf("SELECT DISTINCT major FROM user NATURAL JOIN report WHERE fbid = '%d'",$_SESSION['id']);
$connection->real_query($query);
$result = $connection->use_result();
$report = $result->fetch_all(MYSQLI_BOTH);
$result->free();
if (is_array($report[0])){
	foreach ($report[0] as $key => $value){
		$major = $value;
	}
}
$query = sprintf("SELECT report.primaryGroup AS primaryGroup,
						primaryHrs,
						primaryCourse,
						report.secondaryGroup AS secondaryGroup,
						secondaryHrs,
						secondaryCourse,
						courseOpts
						FROM user,report LEFT OUTER JOIN courseopts
									ON report.uin=courseopts.uin
									AND report.primaryGroup=courseopts.primaryGroup
									AND report.secondaryGroup=courseopts.secondaryGroup
						WHERE user.uin=report.uin
							AND fbid='%d'
						ORDER BY primaryGroup",$_SESSION['id']);
$connection->real_query($query);
$result = $connection->use_result();
$report = $result->fetch_all(MYSQLI_BOTH);
$result->free();

$curl = curl_init('http://graph.facebook.com/' . $_SESSION['user_profile']['username']);
curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);
$name = curl_exec($curl);
curl_close($curl);
$name = json_decode($name);
$name = $name->name;
echo '<div id="profile_head">';
	echo '<table border="0" width="750"><tr valign="top"><td>';
	echo '<a id="profile_picture" href="http://facebook.com/' . $_SESSION['user_profile']['username'] . '">
		<img src="http://graph.facebook.com/' . $_SESSION['user_profile']['username'] . '/picture?width=200&height=200"
		title="' . $name .'" /></a><br>
		</td>'; // my picture
//	echo '<div id="profile_info">';
		echo '<td align="right"><span id="profile_name">'.$_SESSION['user_profile']['name'].'</span>'.'<br>'; // my name
		echo ucwords(strtolower($major)).'<br>'; // Computer Science
		//print $_SESSION['id'].'<br>'; // facebook id
		if (is_array($report[0])) {
			foreach ($report as $rowIndex => $row) {
				if (!is_null($row['primaryHrs']) && $row['primaryGroup']=='MINIMUM OF 128 HOURS REQUIRED') {
					echo '<br>Needs '.$row['primaryHrs'].' hours to graduate.<br>';
				}
			}
		}

	echo '</div>';
	echo '</td></tr></table>';
echo '</div>';


?>
<link href="parts/css/table.css" rel="stylesheet">
<div id="course_options">
<?php
	
	$first = true;
	$rowNo = 0;
	$technicalElectivesPrinted = false;
	$universityResidencyPrinted = false;
	$advancedCompositionPrinted = false;
	$requiredCoursesPrinted = false;
	if (is_array($report[0]))
	{
		// display the results

		//required ->>
		foreach ($report as $rowIndex => $row) {
			$first = false;
			if (!$technicalElectivesPrinted && !is_null($row['primaryHrs']) && $row['primaryGroup']=='TECHNICAL ELECTIVES'){
				echo '<br><div class="req_title">Technical Electives: <a id="tecele_choose_from" href="#">Show...</a></div><br>';
				$technicalElectivesPrinted = true;
			}
			/*if (!is_null($row['primaryHrs']) && $row['primaryGroup']=='MINIMUM OF 128 HOURS REQUIRED'){
				echo '<br>Hours needed to graduate - '.$row['primaryHrs'].' hours<br><br>';
			}*/
			if (!is_null($row['primaryHrs']) && strpos($row['primaryGroup'],'MINOR')!==false){
				echo $row['primaryGroup'].' - '.$row['primaryHrs'].' hours<br>';
			}
			if ($row['primaryGroup']=='TECHNICAL TRACK'){
				echo '<br>Technical Track needed - '.$row['primaryHrs'].' hours<br>';
			}
			if (!is_null($row['primaryHrs']) && $row['primaryGroup']=='ECE/CS ELECTIVES'){
				echo '<br><div class="req_title">ECE/CS Electives Needed - '.$row['primaryHrs'].' hours. <a id="eceele_choose_from" href="#">Show...</a></div>';
				$query = "SELECT name, title, courseCatalogLink 
				FROM class 
				NATURAL JOIN 
					(SELECT DISTINCT crossListedAs AS name 
					FROM class 
					NATURAL JOIN 
						(SELECT courseList AS crossListedAs 
						FROM `requirements` 
						WHERE type='ECE/CS ELECTIVES' 
							AND MAJOR='COMPUTER ENGINEERING') 
					AS T) AS T2
					WHERE name NOT IN 
					(SELECT DISTINCT crossListedAs AS name 
					FROM class NATURAL JOIN 
						(SELECT courseName AS name 
						FROM taken 
						NATURAL JOIN user 
						WHERE fbid = '".$_SESSION['id']."') AS T3)";
				if ($connection->real_query($query)){
					$result = $connection->use_result();
					$classRow = $result->fetch_all(MYSQLI_BOTH);
					$result->free();
					echo '<div id="eceele_choose_from_opts" style="display: none;">';
					echo '<table border="0" width="750">';
					for ($i = 0; $i<count($classRow); $i++){
						if($i % 2 == 0)
							echo '<tr>';
						echo '<td>';
						echo '<a href="' . $classRow[$i]['courseCatalogLink'] . '">'.$classRow[$i]['name']. ': ' .$classRow[$i]['title']. '</a><br>';
						echo '</td>';
						if($i % 2 == 1)
							echo '</tr>';
					}
					echo '</table>';
					echo '</div>';
				}
			}
			if ($row['primaryGroup']=='UNIVERSITY RESIDENCY REQUIREMENT'){
				echo '<br>University Residency Requirement - '.$row['secondaryHrs'].' hours<br><br>';
			}
			/*if (!is_null($row['primaryHrs']) && $row['primaryGroup']=='MINIMUM OF 128 HOURS REQUIRED'){
				echo '<br>Hours needed to graduate - '.$row['primaryHrs'].' hours<br><br>';
			}*/
			/*if (!is_null($row['primaryHrs']) && strpos($row['primaryGroup'],'MINOR')!==false){
				echo $row['primaryGroup'].' - '.$row['primaryHrs'].' hours<br>';
			}*/
			if ($row['primaryGroup']=='ADVANCED COMPOSITION REQUIREMENT'){
				echo '<div class="req_title">Advanced Composition Requirement Needed. <a id="advcom_choose_from" href="#">Show...</a></div>';
				//$query = sprintf("SELECT name,title,courseCatalogLink FROM class NATURAL JOIN (SELECT courseList AS name FROM `requirements` WHERE major='%s' AND type='ADVANCED COMPOSITION REQUIREMENT') AS T",$major);
				// all schools/majors have the same advanced comp options
				$query = sprintf("SELECT name,title,courseCatalogLink FROM class NATURAL JOIN (SELECT courseList AS name FROM `requirements` WHERE major='COMPUTER SCIENCE - COLLEGE OF ENGINEERING' AND type='ADVANCED COMPOSITION REQUIREMENT') AS T",$major);
				if ($connection->real_query($query)){
					$result = $connection->use_result();
					$classRow = $result->fetch_all(MYSQLI_BOTH);
					$result->free();
					echo '<div id="advcom_choose_from_opts" style="display: none;">';
					echo '<table border="0" width="750">';
					for ($i = 0; $i<count($classRow); $i++){
						if($i % 2 == 0)
							echo '<tr>';
						echo '<td>';
						echo '<a href="' . $classRow[$i]['courseCatalogLink'] . '">'.$classRow[$i]['name']. ': ' .$classRow[$i]['title']. '</a><br>';
						echo '</td>';
						if($i % 2 == 1)
							echo '</tr>';
					}
					echo '</table>';
					echo '</div>';
				}
			}

			for ($i = 0; $i < (sizeof($row))/2; $i++)
			{
				if ($i == (sizeof($row))/2 - 1	// if this is the last column
					&& (preg_match_all('/(\w{2,5} \d{3})(.*?(\(.+?\))+?)?/', $row[$i], $matches) > 0)) // and this has course options
				{
					foreach ($matches[1] as $matchKey => $match)
					{
						if ($connection->real_query(sprintf("SELECT * FROM class WHERE name='%s'", $match)))
						$result = $connection->use_result();
						$classRow = mysqli_fetch_array($result);
						$result->free();

						if (is_array($classRow))
						{
							if ($matchKey > 0)
								echo " OR ";
							
							if ($row['primaryGroup']=='REQUIRED COURSES'){
								if (!$requiredCoursesPrinted){
									echo '<br><div class="req_title">Required Courses Needed. <a id="reqcla_choose_from" href="#">Show...</a></div>';
									$requiredCoursesPrinted = !$requiredCoursesPrinted;
								}
								echo '<div class="reqcla" style="display:none;">';
								echo '<a href="' . $classRow['courseCatalogLink'] . '">'. $matches[0][$matchKey] . ': ' . $classRow['title'] . '</a></div>';
							}

							if ($row['primaryGroup']=='TECHNICAL ELECTIVES'){
								echo '<div class="tecele" style="display:none;">';
								echo '<a href="' . $classRow['courseCatalogLink'] . '">'. $matches[0][$matchKey] . ': ' . $classRow['title'] . '</a></div>';
						
							}

						}
						else{
							//echo "<br>Shouldn't be here -->";
							//echo substr($row[$i], strpos($row[$i], $match), strlen($match)).'<br>';
							$choices = explode(' ',$row[$i]);
							$secondChoice = $choices[0].' '.$choices[3];
							if ($connection->real_query(sprintf("SELECT * FROM class WHERE name='%s'", $secondChoice)))
							$result = $connection->use_result();
							$classRow = mysqli_fetch_array($result);
							$result->free();
							if (is_array($classRow))
							{
								if ($row['primaryGroup']=='REQUIRED COURSES'){
									echo '<div class="reqcla" style="display:none;">or ';
									echo '<a href="' . $classRow['courseCatalogLink'] . '">'. $secondChoice . ': ' . $classRow['title'] . '</a></div>';
							
								}

								 if ($row['primaryGroup']=='TECHNICAL ELECTIVES'){
									echo '<div class="tecele" style="display:none;">or ';
									echo '<a href="' . $classRow['courseCatalogLink'] . '">'. $secondChoice . ': ' . $classRow['title'] . '</a></div>';
							
								}


							}
						}
					}
				}
			}

			// adjust counter for row number
			$rowNo = (++$rowNo)%2;
		}
	}
	else { ?>
		We do not have a DARS Report on file for you.
		(Some nerve you've got for coming back here, if you deleted yourself from our database.)<br><br>
		<a href="https://darsweb.admin.uillinois.edu/darswebstu_uiuc/servlet/EASDarsServlet"
			target="_blank">Run a new DARS Report</a>
		with our extension installed to populate this page. (You'll have to refresh this page after you do that.)
	<?php }
	// free the connection
	$connection->close();
?>
<?php
include_once('parts/footer.php');
?>
</div>