/**
* Returns html with Advisor
*
* @return string
*/
function PMA_getHtmlForAdvisor()
{
$output = '<a href="#openAdvisorInstructions">';
$output .= PMA_Util::getIcon('b_help.png', __('Instructions'));
$output .= '</a>';
$output .= '<div id="statustabs_advisor"></div>';
$output .= '<div id="advisorInstructionsDialog" style="display:none;">';
$output .= '<p>';
$output .= __('The Advisor system can provide recommendations ' . 'on server variables by analyzing the server status variables.');
$output .= '</p>';
$output .= '<p>';
$output .= __('Do note however that this system provides recommendations ' . 'based on simple calculations and by rule of thumb which may ' . 'not necessarily apply to your system.');
$output .= '</p>';
$output .= '<p>';
$output .= __('Prior to changing any of the configuration, be sure to know ' . 'what you are changing (by reading the documentation) and how ' . 'to undo the change. Wrong tuning can have a very negative ' . 'effect on performance.');
$output .= '</p>';
$output .= '<p>';
$output .= __('The best way to tune your system would be to change only one ' . 'setting at a time, observe or benchmark your database, and undo ' . 'the change if there was no clearly measurable improvement.');
$output .= '</p>';
$output .= '</div>';
$output .= '<div id="advisorData" style="display:none;">';
$advisor = new Advisor();
$output .= htmlspecialchars(json_encode($advisor->run()));
$output .= '</div>';
return $output;
}
public function storeAdvisor()
{
// If form validation passes:
$advisor = new Advisor();
$advisor->name = Input::get('name');
$advisor->email = Input::get('email');
$advisor->password = Hash::make(Input::get('password'));
$advisor->save();
Auth::attempt(['email' => $advisor->email, 'password' => Input::get('password')]);
return Redirect::intended('advisor.dashboard');
}
/**
* @depends testParse
* @dataProvider rulesProvider
*/
public function testAddRule($rule, $expected, $error)
{
$advisor = new Advisor();
$parseResult = $advisor->parseRulesFile();
$this->assertEquals($parseResult['errors'], array());
$advisor->variables['value'] = 0;
$advisor->addRule('fired', $rule);
if (isset($advisor->runResult['errors']) || !is_null($error)) {
$this->assertEquals($advisor->runResult['errors'], array($error));
}
if (isset($advisor->runResult['fired']) || $expected != array()) {
$this->assertEquals($advisor->runResult['fired'], array($expected));
}
}
<div id="login">
<div id="form">
<div class="top">
<?php
$first = $_POST["firstN"];
$last = $_POST["lastN"];
$office = $_POST["Office"];
$meeting = $_POST["Meeting"];
$user = $_POST["UserN"];
$pass = md5($_POST["PassW"]);
include '../CommonMethods.php';
include '../Advisor.php';
$debug = false;
$Common = new Common($debug);
$userN = $_SESSION["User_ID"];
$adv = new Advisor($Common, $userN);
if ($adv->createAdvisor($Common, $first, $last, $user, $pass, $office, $meeting)) {
echo "<h3>Advisor {$first} {$last} created successfully</h3>";
} else {
echo "<h3>Advisor {$first} {$last} already exists</h3>";
}
?>
<form method="link" action="AdminUI.php">
<input type="submit" name="next" class="button large go" value="Return to Home">
</form>
</div>
<?php
include '../Footer.html';
?>
</div>
</div>
// In case an error happened
$return['error'] = PMA_DBI_getError();
PMA_DBI_free_result($result);
if ($profiling) {
$return['profiling'] = array();
$result = PMA_DBI_try_query('SELECT seq,state,duration FROM INFORMATION_SCHEMA.PROFILING WHERE QUERY_ID=1 ORDER BY seq');
while ($row = PMA_DBI_fetch_assoc($result)) {
$return['profiling'][] = $row;
}
PMA_DBI_free_result($result);
}
exit(json_encode($return));
}
if (isset($_REQUEST['advisor'])) {
include 'libraries/Advisor.class.php';
$advisor = new Advisor();
exit(json_encode($advisor->run()));
}
}
/**
* Replication library
*/
if (PMA_DRIZZLE) {
$server_master_status = false;
$server_slave_status = false;
} else {
include_once './libraries/replication.inc.php';
include_once './libraries/replication_gui.lib.php';
}
/**
* JS Includes
}
echo "Appointment: ", date('l, F d, Y g:i A', $oldDatephp), "<br>";
// Display meeting location
echo "Meeting Location: ", $appt->getMeeting(), "</label><br>";
// Hidden input for old appointment ID
echo "<input type='hidden' name='oldAppID' value='{$oldApptID}'>";
}
$currentAdvisorID = $_POST["advisor"];
$currentDatephp = strtotime($_POST["appTime"]);
// Get appointment information for current appointment, even if it's taken
$appointments = Appointment::searchAppointments($COMMON, $currentAdvisorID, $student->getMajor(), $_POST["appTime"], null, false, 1, '');
$currentAppt = $appointments[0];
$currentApptID = $currentAppt->getID();
if ($currentAdvisorID != 0) {
// Individual advisor, so get info from database
$currentAdvisor = new Advisor($COMMON, $currentAdvisorID);
$currentAdvisorName = $currentAdvisor->convertFullName();
$currentAdvisorOffice = $currentAdvisor->getOffice();
} else {
// Group advising appointment
$currentAdvisorName = "Group";
}
echo "<h2>Current Appointment</h2>";
echo "<label for='newinfo'>";
echo "Advisor: ", $currentAdvisorName, "<br>";
// Display office for individual advisor
if (isset($currentAdvisorOffice)) {
echo "Office: ", $currentAdvisorOffice, "<br>";
}
echo "Appointment: ", date('l, F d, Y g:i A', $currentDatephp), "<br>";
echo "Meeting Location: ", $currentAppt->getMeeting(), "</label>";
if (isset($_POST["advisor"])) {
// Came from selecting individual advisor
$localAdvisor = $_POST["advisor"];
} else {
// Selected group advisor
$localAdvisor = 0;
}
include '../CommonMethods.php';
include '../Student.php';
include '../Advisor.php';
include '../Appointment.php';
$COMMON = new Common($debug);
$student = new Student($COMMON, $_SESSION['studID']);
if ($localAdvisor != 0) {
// Get information for individual advisor
$advisor = new Advisor($COMMON, $localAdvisor);
}
?>
<html lang="en">
<head>
<meta charset="UTF-8" />
<title>Select Appointment</title>
<link rel='stylesheet' type='text/css' href='../css/standard.css'/>
</head>
<body>
<div id="login">
<div id="form">
<div class="top">
<h1>Select Appointment Time</h1>
public function justTheFirstServiceBecauseMyCodeSucks($advisor_id)
{
// Get the Advisor, MF
$advisor = Advisor::find($advisor_id);
$firstService = $advisor->services->first();
return $firstService;
}
$i = 0;
echo "Time: ";
foreach ($times as $t) {
echo ++$i, ") ", date('g:i A', strtotime($t)), " ";
}
}
echo "<br>";
if ($advisor == '') {
echo "Advisor: All appointments";
} elseif ($advisor == 'I') {
echo "Advisor: All individual appointments";
} elseif ($advisor == '0') {
echo "Advisor: All group appointments";
} else {
// Get advisor info from database
$advisor = new Advisor($COMMON, $advisor);
echo "Advisor: ", $advisor->convertFullName();
}
echo "<br>";
if ($studID == '' && $studLN == '') {
echo "Student: All";
} else {
$studLN = strtoupper($studLN);
$studID = strtoupper($studID);
$sql = "select `LastName`, `StudentID` from Proj2Students where `StudentID` = '{$studID}' or `LastName` = '{$studLN}'";
$rs = $COMMON->executeQuery($sql, $_SERVER["SCRIPT_NAME"]);
$row = mysql_fetch_row($rs);
$studLN = $row[0];
$studID = $row[1];
echo "Student: ", $studID, " ", $studLN;
}
<?php
/* Had to make sure sessions was enabled. Some help here:
https://wiki.umbc.edu/pages/viewpage.action?pageId=46563550
cd /afs/umbc.edu/public/web/sites/coeadvising/prod/php/session/
/usr/bin/fs sa /afs/umbc.edu/public/web/sites/coeadvising/prod/php/session/ web.coeadvising all
then edit .htaccess file here in the same directory
*/
session_start();
include '../CommonMethods.php';
include '../Advisor.php';
$debug = false;
$Common = new Common($debug);
$admin = new Advisor($Common, strtoupper($_POST["UserN"]), md5($_POST["PassW"]));
if ($admin->exists()) {
// Save away user ID
$_SESSION["UserID"] = strtoupper($_POST["UserN"]);
header('Location: AdminUI.php');
} else {
$_SESSION["UserID"] = -1;
header('Location: AdminSignIn.php');
}
<div id="form">
<div class="top">
<h1>Removed Appointment</h1><br>
<div class="field">
<?php
$debug = false;
include '../CommonMethods.php';
include '../Appointment.php';
include '../Student.php';
include '../Advisor.php';
$COMMON = new Common($debug);
$indID = $_POST["IndApp"];
// Get appointment info from the database
$appt = new Appointment($COMMON, $indID);
$adv = $appt->getAdvisorID();
$advisor = new Advisor($COMMON, $adv);
if ($appt->getEnrolledID()) {
$student = new Student($COMMON, trim($appt->getEnrolledID()));
$std = $student->getFirstName() . " " . $student->getLastName();
$eml = $student->getEmail();
}
$sql = "DELETE FROM `Proj2Appointments` WHERE `id`='{$indID}'";
$rs = $COMMON->executeQuery($sql, "Advising Appointments");
echo "Time: " . date('l, F d, Y g:i A', strtotime($appt->getTime())) . "<br>";
echo "Advisor: " . $advisor->convertFullName() . "<br>";
echo "Majors included: ";
if ($appt->getMajor()) {
echo $appt->convertMajor() . "<br>";
} else {
echo "Available to all majors<br>";
}
}
$ServerStatusData = new PMA_ServerStatusData();
$response = PMA_Response::getInstance();
$scripts = $response->getHeader()->getScripts();
$scripts->addFile('server_status_advisor.js');
$output = '<div>';
$output .= $ServerStatusData->getMenuHtml();
$output .= '<a href="#openAdvisorInstructions">';
$output .= PMA_Util::getIcon('b_help.png', __('Instructions'));
$output .= '</a>';
$output .= '<div id="statustabs_advisor"></div>';
$output .= '<div id="advisorInstructionsDialog" style="display:none;">';
$output .= '<p>';
$output .= __('The Advisor system can provide recommendations ' . 'on server variables by analyzing the server status variables.');
$output .= '</p>';
$output .= '<p>';
$output .= __('Do note however that this system provides recommendations ' . 'based on simple calculations and by rule of thumb which may ' . 'not necessarily apply to your system.');
$output .= '</p>';
$output .= '<p>';
$output .= __('Prior to changing any of the configuration, be sure to know ' . 'what you are changing (by reading the documentation) and how ' . 'to undo the change. Wrong tuning can have a very negative ' . 'effect on performance.');
$output .= '</p>';
$output .= '<p>';
$output .= __('The best way to tune your system would be to change only one ' . 'setting at a time, observe or benchmark your database, and undo ' . 'the change if there was no clearly measurable improvement.');
$output .= '</p>';
$output .= '</div>';
$output .= '<div id="advisorData" style="display:none;">';
$advisor = new Advisor();
$output .= htmlspecialchars(json_encode($advisor->run()));
$output .= '</div>';
$output .= '</div>';
$response->addHTML($output);
}
}
//major stuff
$majorDB = "";
$majorPrint = "All";
if (!empty($majors)) {
$majorPrint = "";
foreach ($majors as $m) {
$majorDB .= $m . " ";
$majorPrint .= $m . ", ";
}
$majorPrint = substr($majorPrint, 0, -2);
}
//get advisor id
$id = $_SESSION['UserID'];
$adv = new Advisor($COMMON, $id);
$advID = $adv->getID();
$location = $adv->getMeeting();
//make sure app doesn't exist
//insert new app to DB
//print app
foreach ($datetimes as $dt) {
// Attempt to create appointment
$created = Appointment::createAppointment($COMMON, $dt, $advID, $majorDB, 1, $location);
echo date('l, F d, Y g:i A', strtotime($dt)), "<br>Advisor: ", $adv->getFirstName(), " ", $adv->getLastName(), "<br>Location: ", $location, " <br> Majors: ", $majorPrint;
if (!$created) {
// Appointment already exists
echo "<br><span style='color:red'>!!</span>";
}
echo "<br><br>";
}
<div class="top">
<h1>View Appointment</h1>
<div class="field">
<?php
// Search for appointment with this student
$appointments = Appointment::searchAppointments($COMMON, null, null, null, null, null, null, '', $studID);
// if for some reason there really isn't a match, (something got messed up, tell them there really isn't one there)
$num_rows = count($appointments);
if ($num_rows > 0) {
$appt = $appointments[0];
// get legit data
$advisorID = $appt->getAdvisorID();
$datephp = strtotime($appt->getTime());
if ($advisorID != 0) {
// Individual advisor - Get advisor info from database
$advisor = new Advisor($COMMON, $advisorID);
$advisorOffice = $advisor->getOffice();
$advisorName = $advisor->convertFullName();
} else {
// Group advisor
$advisorName = "Group";
}
echo "<label for='info'>";
echo "Advisor: ", $advisorName, "<br>";
// If individual advisor, display office location
if (isset($advisorOffice)) {
echo "Office: ", $advisorOffice, "<br>";
}
echo "Appointment: ", date('l, F d, Y g:i A', $datephp), "<br>";
// Display appointment location
echo "Meeting Location: ", $appt->getMeeting(), "</label>";
/**
* Adds a rule to the result list
*
* @param string $type type of rule
* @param array $rule rule itslef
*
* @return void
*/
function addRule($type, $rule)
{
switch ($type) {
case 'notfired':
case 'fired':
$jst = Advisor::splitJustification($rule);
if (count($jst) > 1) {
try {
/* Translate */
$str = $this->translate($jst[0], $jst[1]);
} catch (Exception $e) {
$this->storeError(sprintf(__('Failed formatting string for rule \'%s\'.'), $rule['name']), $e);
return;
}
$rule['justification'] = $str;
} else {
$rule['justification'] = $this->translate($rule['justification']);
}
$rule['id'] = $rule['name'];
$rule['name'] = $this->translate($rule['name']);
$rule['issue'] = $this->translate($rule['issue']);
// Replaces {server_variable} with 'server_variable'
// linking to server_variables.php
$rule['recommendation'] = preg_replace('/\\{([a-z_0-9]+)\\}/Ui', '<a href="server_variables.php?' . PMA_URL_getCommon() . '&filter=\\1">\\1</a>', $this->translate($rule['recommendation']));
// Replaces external Links with PMA_linkURL() generated links
$rule['recommendation'] = preg_replace_callback('#href=("|\')(https?://[^\\1]+)\\1#i', array($this, '_replaceLinkURL'), $rule['recommendation']);
break;
}
$this->runResult[$type][] = $rule;
}
public function expertiseContainedByAdvisor($advisor_id, $just_id = null)
{
$advisor = Advisor::find($advisor_id);
if ($just_id == '1') {
return $expertiseContainedByAdvisor = $advisor->expertise()->lists('expertise_id');
}
$expertiseContainedByAdvisor = $advisor->expertise()->lists('title', 'expertise_id');
return $expertiseContainedByAdvisor;
}
function addRule($type, $rule)
{
switch ($type) {
case 'notfired':
case 'fired':
$jst = Advisor::splitJustification($rule);
if (count($jst) > 1) {
try {
/* Translate */
$str = $this->translate($jst[0], $jst[1]);
} catch (Exception $e) {
$this->runResult['errors'][] = sprintf(__('Failed formatting string for rule \'%s\'. PHP threw following error: %s'), $rule['name'], $e->getMessage());
return;
}
$rule['justification'] = $str;
} else {
$rule['justification'] = $this->translate($rule['justification']);
}
$rule['name'] = $this->translate($rule['name']);
$rule['issue'] = $this->translate($rule['issue']);
// Replaces {server_variable} with 'server_variable'
// linking to server_variables.php
$rule['recommendation'] = preg_replace('/\\{([a-z_0-9]+)\\}/Ui', '<a href="server_variables.php?' . PMA_generate_common_url() . '#filter=\\1">\\1</a>', $this->translate($rule['recommendation']));
// Replaces external Links with PMA_linkURL() generated links
$rule['recommendation'] = preg_replace('#href=("|\')(https?://[^\\1]+)\\1#ie', '\'href="\' . PMA_linkURL("\\2") . \'"\'', $rule['recommendation']);
break;
}
$this->runResult[$type][] = $rule;
}
<link rel='stylesheet' type='text/css' href='../css/standard.css'/>
</head>
<body>
<div id="login">
<div id="form">
<div class="top">
<?php
$date = $_POST["date"];
$type = $_POST["type"];
include '../CommonMethods.php';
include '../Advisor.php';
include '../Student.php';
$COMMON = new Common($debug);
$User = $_SESSION["UserID"];
$adv = new Advisor($COMMON, $User);
$id = $adv->getID();
$FirstName = $adv->getFirstName();
$LastName = $adv->getLastName();
echo "<h2>Schedule for {$FirstName} {$LastName}<br>{$date}</h2>";
$date = date('Y-m-d', strtotime($date));
if ($_POST["type"] == 'Both') {
displayGroup($id, $date);
displayIndividual($id, $date);
} elseif ($_POST["type"] == 'Individual') {
displayIndividual($id, $date);
} elseif ($_POST["type"] == 'Group') {
displayGroup($id, $date);
} else {
echo "Selection invalid";
}
<meta charset="UTF-8" />
<title>Admin Home</title>
<link rel='stylesheet' type='text/css' href='../css/standard.css'/>
</head>
<body>
<div id="login">
<div id="form">
<div class="top">
<h2> Hello
<?php
if (!isset($_SESSION["UserID"])) {
return;
}
$UserID = $_SESSION["UserID"];
// Get advisor info from database
$advisor = new Advisor($COMMON, $UserID);
echo $advisor->getFirstName();
?>
</h2>
<form action="AdminProcessUI.php" method="post" name="UI">
<input type="submit" name="next" class="button large selection" value="Schedule appointments"><br>
<input type="submit" name="next" class="button large selection" value="Print schedule for a day"><br>
<input type="submit" name="next" class="button large selection" value="Edit appointments"><br>
<input type="submit" name="next" class="button large selection" value="Search for an appointment"><br>
<input type="submit" name="next" class="button large selection" value="Create new Admin Account"><br>
</form>
<br>
<div id="form">
<div class="top">
<h1>Cancel Appointment</h1>
<div class="field">
<?php
// Get student info from database
$studid = $_SESSION["studID"];
$student = new Student($COMMON, $studid);
// Get student's appointment from database
$appointments = Appointment::searchAppointments($COMMON, null, null, null, null, null, null, '', $studid);
$appt = $appointments[0];
$oldAdvisorID = $appt->getAdvisorID();
$oldDatephp = strtotime($appt->getTime());
if ($oldAdvisorID != 0) {
// Individual advisor, so get advisor info
$advisor = new Advisor($COMMON, $oldAdvisorID);
$oldAdvisorName = $advisor->convertFullName();
$oldAdvisoOffice = $advisor->getOffice();
} else {
// Group advisor
$oldAdvisorName = "Group";
}
// Display current appointment info
echo "<h2>Current Appointment</h2>";
echo "<label for='info'>";
echo "Advisor: ", $oldAdvisorName, "<br>";
// Display office for individual advisor
if (isset($oldAdvisorOffice)) {
echo "Office: ", $oldAdvisorOffice, "<br>";
}
echo "Appointment: ", date('l, F d, Y g:i A', $oldDatephp), "<br>";
