/2.0/php/util.php

Large files files are truncated, but you can click here to view the full file

<?php



require_once('db.php');

require_once('auth.php');

require_once('LessonSchedule.php');

require_once('EventSchedule.php');



/* Commands */



$SET_MUSIC_STATE       = 1;

$ATTEMPT_LOGIN         = 2;

$CHANGE_EFFECTIVE_DATE = 3;

$ADD_STUDENT           = 4;

$EDIT_STUDENT_LOOKUP   = 5;

$EDIT_STUDENT_CONFIRM  = 6;

$DELETE_STUDENT        = 7;

$ADD_GROUP_CLASS       = 8;

$EDIT_GROUP_CLASS      = 9;

$DELETE_GROUP_CLASS    = 10;

$ADD_EVENT             = 11;

$EDIT_EVENT_LOOKUP     = 12;

$EDIT_EVENT_CONFIRM    = 13;

$DELETE_EVENT          = 14;

$UPLOAD_PHOTO          = 15;

$ADD_COMMENT           = 16;

$GET_COMMENT           = 17;

$DELETE_PHOTO          = 18;

$CHANGE_STATE          = 19;



if (isset($_REQUEST['command']))

{

	if ($_REQUEST['command'] == $SET_MUSIC_STATE)

	{

		setMusicCookie($_REQUEST['state']);

		exit;

	}

	

	session_start();

	

	if ($_REQUEST['command'] != $ATTEMPT_LOGIN && $_REQUEST['command'] != $GET_COMMENT && $_REQUEST['command'] != $CHANGE_STATE && !loggedInAsAdmin())

	{

		header('Location: http://www.bridgetjohansen.com/');

		exit;

	}

	

	$response = new stdClass();

	

	if ($_REQUEST['command'] == $ATTEMPT_LOGIN)

	{

		if (isset($_REQUEST['password']) && (userPasswordCorrect($_REQUEST['password']) || adminPasswordCorrect($_REQUEST['password'])))

		{

			$_SESSION['login_name'] = userPasswordCorrect($_REQUEST['password']) ? 'user' : 'admin';

			changeSessionID();

			$response->authSuccess = true;

		}

		

		if (isMobile())

		{

			header('Location: http://www.bridgetjohansen.com/schedule');

			exit;

		}

		

		$lessonSchedule = new LessonSchedule();

		$lessonSchedule->populate();

		

		$showDynamicCSS = true;

		

		$response->content = getScheduleContent($lessonSchedule, $showDynamicCSS);

		$response->page    = "schedule";

		

		if ($showDynamicCSS)

		{

			$response->dynamicCSS = getDynamicCSSforAjax($lessonSchedule);

			

			if (loggedInAsAdmin())

			{

				$response->admin = true;

			}

		}

		

		echo json_encode($response);

	}

	elseif ($_REQUEST['command'] == $CHANGE_EFFECTIVE_DATE)

	{

		$result = setEffectiveDate($_REQUEST['date']);

		

		if (is_null($result))

		{

			$response->error = true;

		}

		else

		{

			$response->newDate = $result;

		}

		

		echo json_encode($response);

	}

	elseif ($_REQUEST['command'] == $ADD_STUDENT)

	{

		$name           = $_REQUEST['studentName'];

		$parents        = $_REQUEST['parents'];

		$phone          = $_REQUEST['phone'];

		$lessonDay      = $_REQUEST['lessonDay'];

		$lessonTime     = $_REQUEST['lessonHour'] . ':' . $_REQUEST['lessonMinutes'];

		$lessonDuration = $_REQUEST['lessonDuration'];

		$groupClassTime = strlen($_REQUEST['groupClassHour']) > 0 && strlen ($_REQUEST['groupClassMinutes']) > 0 ? $_REQUEST['groupClassHour'] . ':' . $_REQUEST['groupClassMinutes'] : null;

		

		if (get_magic_quotes_gpc())

		{

			$name    = stripslashes($name);

			$parents = stripslashes($parents);

		}

		

		$result = addNewStudent($name, $parents, $phone, $lessonDay, $lessonTime, $lessonDuration, $groupClassTime);

		

		if (is_null($result))

		{

			$response->content = getError();

			$response->page    = "schedule";

		}

		else

		{

			// TODO: Should you create a helper function for getting the schedule content and dynamic CSS? (The following 18 lines of code are identical in the responses to $ATTEMPT_LOGIN, $EDIT_STUDENT_CONFIRM, and $DELETE_STUDENT.)

			

			$lessonSchedule = new LessonSchedule();

			$lessonSchedule->populate();

			

			$showDynamicCSS = true;

			

			$response->content = getScheduleContent($lessonSchedule, $showDynamicCSS);

			$response->page    = "schedule";

			

			if ($showDynamicCSS)

			{

				$response->dynamicCSS = getDynamicCSSforAjax($lessonSchedule);

					

				if (loggedInAsAdmin())

				{

					$response->admin = true;

				}

			}

		}

		

		echo json_encode($response);

	}

	elseif ($_REQUEST['command'] == $EDIT_STUDENT_LOOKUP)

	{

		$result = getStudent($_REQUEST['id']);

			

		if (is_null($result))

		{

			$response->error = true;

		}

		else

		{

			$response->student = $result;

		}

			

		echo json_encode($response);

	}

	elseif ($_REQUEST['command'] == $EDIT_STUDENT_CONFIRM)

	{

		$id             = $_REQUEST['id'];

		$name           = $_REQUEST['studentName'];

		$parents        = $_REQUEST['parents'];

		$phone          = $_REQUEST['phone'];

		$lessonDay      = $_REQUEST['lessonDay'];

		$lessonTime     = $_REQUEST['lessonHour'] . ':' . $_REQUEST['lessonMinutes'];

		$lessonDuration = $_REQUEST['lessonDuration'];

		$groupClassTime = strlen($_REQUEST['groupClassHour']) > 0 && strlen ($_REQUEST['groupClassMinutes']) > 0 ? $_REQUEST['groupClassHour'] . ':' . $_REQUEST['groupClassMinutes'] : null;

		

		if (get_magic_quotes_gpc())

		{

			$name    = stripslashes($name);

			$parents = stripslashes($parents);

		}

		

		$result = editStudent($id, $name, $parents, $phone, $lessonDay, $lessonTime, $lessonDuration, $groupClassTime);

			

		if (is_null($result))

		{

			$response->content = getError();

			$response->page    = "schedule";

		}

		else

		{

			$lessonSchedule = new LessonSchedule();

			$lessonSchedule->populate();

			

			$showDynamicCSS = true;

			

			$response->content = getScheduleContent($lessonSchedule, $showDynamicCSS);

			$response->page    = "schedule";

			

			if ($showDynamicCSS)

			{

				$response->dynamicCSS = getDynamicCSSforAjax($lessonSchedule);

					

				if (loggedInAsAdmin())

				{

					$response->admin = true;

				}

			}

		}

			

		echo json_encode($response);

	}

	elseif ($_REQUEST['command'] == $DELETE_STUDENT)

	{

		$result = deleteStudent($_REQUEST['id']);

		

		if (is_null($result))

		{

			$response->content = getError();

			$response->page    = "schedule";

		}

		else

		{

			$lessonSchedule = new LessonSchedule();

			$lessonSchedule->populate();

			

			$showDynamicCSS = true;

			

			$response->content = getScheduleContent($lessonSchedule, $showDynamicCSS);

			$response->page    = "schedule";

			

			if ($showDynamicCSS)

			{

				$response->dynamicCSS = getDynamicCSSforAjax($lessonSchedule);

					

				if (loggedInAsAdmin())

				{

					$response->admin = true;

				}

			}

		}

		

		echo json_encode($response);

	}

	elseif ($_REQUEST['command'] == $ADD_GROUP_CLASS)

	{

		$result = addGroupClass($_REQUEST['date']);

		

		if (is_null($result))

		{

			$response->error = true;

		}

		else

		{

			$response->newHTML = $result;

		}

		

		echo json_encode($response);

	}

	elseif ($_REQUEST['command'] == $EDIT_GROUP_CLASS)

	{

		$result = editGroupClass($_REQUEST['id'], $_REQUEST['date']);

		

		if (is_null($result))

		{

			$response->error = true;

		}

		else

		{

			$response->newHTML = $result;

		}

		

		echo json_encode($response);

	}

	elseif ($_REQUEST['command'] == $DELETE_GROUP_CLASS)

	{

		$result = deleteGroupClass($_REQUEST['id']);

		

		if (is_null($result))

		{

			$response->error = true;

		}

		else

		{

			$response->newHTML = $result;

		}

		

		echo json_encode($response);

	}

	elseif ($_REQUEST['command'] == $ADD_EVENT)

	{

		$response->page = "events";

		

		$name       = $_REQUEST['eventName'];

		$date       = $_REQUEST['datesTimes'];

		$location   = $_REQUEST['location'];

		$expiration = $_REQUEST['expiration'];

		

		if (get_magic_quotes_gpc())

		{

			$name     = stripslashes($name);

			$date     = stripslashes($date);

			$location = stripslashes($location);

		}

		

		$result = addEvent($name, $date, $location, $expiration);

		

		if (is_null($result))

		{

			$response->content = getError();

		}

		else

		{

			$eventSchedule = new EventSchedule();

			$eventSchedule->populate();

			

			$response->content = getEventsContent($eventSchedule);

			

			if (loggedInAsAdmin())

			{

				$response->admin = true;

			}

		}

			

		echo json_encode($response);

	}

	elseif ($_REQUEST['command'] == $EDIT_EVENT_LOOKUP)

	{

		$result = getEvent($_REQUEST['id']);

			

		if (is_null($result))

		{

			$response->error = true;

		}

		else

		{

			$response->requestedEvent = $result;

		}

			

		echo json_encode($response);

	}

	elseif ($_REQUEST['command'] == $EDIT_EVENT_CONFIRM)

	{

		$response->page = "events";

		

		$id         = $_REQUEST['id'];

		$name       = $_REQUEST['eventName'];

		$date       = $_REQUEST['datesTimes'];

		$location   = $_REQUEST['location'];

		$expiration = $_REQUEST['expiration'];

		

		if (get_magic_quotes_gpc())

		{

			$name     = stripslashes($name);

			$date     = stripslashes($date);

			$location = stripslashes($location);

		}

		

		$result = editEvent($id, $name, $date, $location, $expiration);

			

		if (is_null($result))

		{

			$response->content = getError();

		}

		else

		{

			$eventSchedule = new EventSchedule();

			$eventSchedule->populate();

			

			$response->content = getEventsContent($eventSchedule);

			

			if (loggedInAsAdmin())

			{

				$response->admin = true;

			}

		}

			

		echo json_encode($response);

	}

	elseif ($_REQUEST['command'] == $DELETE_EVENT)

	{

		$response->page = "events";

		

		$result = deleteEvent($_REQUEST['id']);

			

		if (is_null($result))

		{

			$response->content = getError();

		}

		else

		{

			$eventSchedule = new EventSchedule();

			$eventSchedule->populate();

			

			$response->content = getEventsContent($eventSchedule);

			

			if (loggedInAsAdmin())

			{

				$response->admin = true;

			}

		}

			

		echo json_encode($response);

	}

	elseif ($_REQUEST['command'] == $UPLOAD_PHOTO)

	{

		foreach ($_FILES["pics"]["error"] as $key => $error)

		{

			if ($error == UPLOAD_ERR_OK)

			{

				$tmp_name = $_FILES["pics"]["tmp_name"][$key];

				$new_name = uniqid();

				

				if (move_uploaded_file($tmp_name, './pics/' . $new_name . '.jpg'))

				{

					$dbh = getDBH(false);

					

					if (is_null($dbh))

					{

						echo "Error caused by Bluehost (" . __LINE__ . ")";

						exit;

					}

					

					$insertPic = $dbh->prepare("INSERT INTO pics VALUES(:id, :file_name, :comment)");

					$insertPic->bindValue(':id',        NULL,      PDO::PARAM_NULL);

					$insertPic->bindParam(':file_name', $new_name, PDO::PARAM_STR);

					$insertPic->bindValue(':comment',   NULL,      PDO::PARAM_NULL);

					

					if (!$insertPic->execute())

					{

						echo "Error caused by Bluehost (" . __LINE__ . ")";

						exit;

					}

					

					// Create a thumbnail (crop then scale):

					

					$file_name = './pics/' . $new_name . '.jpg';

					

					$src_image = imagecreatefromjpeg($file_name);

					$src_size  = getimagesize($file_name);

					$src_w     = $src_size[0];

					$src_h     = $src_size[1];

					$src_x     = 0;

					$src_y     = 0;

					

					if ($src_w > $src_h)

					{

						$src_x = ($src_w - $src_h) / 2;

						$src_w = $src_h;

					}

					elseif ($src_h > $src_w)

					{

						$src_y = ($src_h - $src_w) / 2;

						$src_h = $src_w;

					}

					

					$dst_image = imagecreatetruecolor(231, 231);

					

					imagecopyresampled($dst_image, $src_image, 0, 0, $src_x, $src_y, 231, 231, $src_w, $src_h);

					

					imagejpeg($dst_image, './pics/' . $new_name . '-thumb.jpg', 80);

					imagedestroy($dst_image);

				}

				else

				{

					echo "Error caused by Bluehost (" . __LINE__ . ")";

					exit;

				}

			}

		}

		

		header('Location: http://www.bridgetjohansen.com/photos');

		exit;

	}

	elseif ($_REQUEST['command'] == $ADD_COMMENT)

	{

		// NOTE: This command is actually used for both adding and editing a comment (as evidenced by the ensuing code).

		

		$dbh = getDBH(false);

		

		if (is_null($dbh))

		{

			$response->error = true;

			echo json_encode($response);

			exit;

		}

		

		$comment = $_REQUEST['comment'];

		

		if (get_magic_quotes_gpc())

			$comment = stripslashes($comment);

		

		$commentQuery = $dbh->prepare("UPDATE pics SET comment = :comment WHERE id = :id");

		$commentQuery->bindParam(':comment', $comment,        PDO::PARAM_STR);

		$commentQuery->bindParam(':id',      $_REQUEST['id'], PDO::PARAM_INT);

		

		if (!$commentQuery->execute())

		{

			$response->error = true;

			echo json_encode($response);

			exit;

		}

		

		$response->success = true;

		

		echo json_encode($response);

	}

	elseif ($_REQUEST['command'] == $GET_COMMENT)

	{

		$result = getComment($_REQUEST['id']);

		

		if (is_null($result))

		{

			$response->error = true;

		}

		else

		{

			$response->comment = $result;

		}

		

		echo json_encode($response);

	}

	elseif ($_REQUEST['command'] == $DELETE_PHOTO)

	{

		$response->page = "photos";

		

		$result = deletePhoto($_REQUEST['id']);

		

		if (is_null($result))

		{

			$response->content = getError();

		}

		else

		{

			$response->content = getPhotosContent();

			

			if (loggedInAsAdmin())

			{

				$response->admin = true;

			}

		}

		

		echo json_encode($response);

	}

	elseif ($_REQUEST['command'] == $CHANGE_STATE)

	{

		$page = $_REQUEST['page'];

		

		if ($page == 'home')

		{

			$response->content = getHomeContent();

			$response->page = 'home';

		}

		elseif ($page == 'about')

		{

			$response->content = getAboutContent();

			$response->page = 'about';

		}

		elseif ($page == 'policies')

		{

			$response->content = getPoliciesContent();

			$response->page = 'policies';

		}

		elseif ($page == 'schedule')

		{

			$lessonSchedule = new LessonSchedule();

			$lessonSchedule->populate();

			

			$showDynamicCSS = true;

			

			$response->content = getScheduleContent($lessonSchedule, $showDynamicCSS);

			$response->page    = 'schedule';

			

			if ($showDynamicCSS)

			{

				$response->dynamicCSS = getDynamicCSSforAjax($lessonSchedule);

			}

		}

		elseif ($page == 'events')

		{

			$eventSchedule = new EventSchedule();

			$eventSchedule->populate();

			

			$response->content = getEventsContent($eventSchedule);

			$response->page    = 'events';

		}

		elseif ($page == 'photos')

		{

			$response->content = getPhotosContent();

			$response->page = "photos";

		}

		

		if (loggedInAsAdmin())

		{

			$response->admin = true;

		}

		

		echo json_encode($response);

	}

}





/* ===============================

 *           Common Code

 * =============================== */



function isMobile()

{

	return preg_match('/android|iphone|ipod/i', $_SERVER['HTTP_USER_AGENT']);

}



/**

 * Get the head element common to all mobile pages.

 * 

 * @param string $title The title of the page.

 * @return string The HTML for the mobile head element.

 */

function getMobileHead($title)

{

	$head = '

	<title>' . $title . '</title>

	<meta name="viewport" content="width=device-width, initial-scale=1">

	<link rel="shortcut icon" href="images/favicon.ico">

	<link rel="stylesheet" href="mobile/bridgetmobile.min.css" />

	<link rel="stylesheet" href="mobile/jquery.mobile.structure-1.3.1.min.css" />';

	

	if ($title == "Bridget Johansen Piano Studio")

	{

		$head .= '

	<link href="http://fonts.googleapis.com/css?family=Vidaloka" rel="stylesheet" type="text/css">

	<link href="http://fonts.googleapis.com/css?family=Pinyon+Script" rel="stylesheet" type="text/css">';

	}

	

	$head .= '

	<link rel="stylesheet" href="mobile/bridgetmobileoverride.css" />

	<script type="text/javascript" src="js/jquery-1.9.1.min.js"></script>

	<script src="mobile/jquery.mobile-1.3.1.min.js"></script>';

	

	if ($title == "Photos")

	{

		$head .= '

	<script src="js/bridget-m.js"></script>';

	}

	

	return $head;

}



function getMobileHeader($title)

{

	return '

		<div data-role="header" data-position="fixed">

			<h1 style="text-align:left; margin-left: 0.5em">' . $title . '</h1>

			<a href="menu.html" data-icon="bars" class="ui-btn-right" data-rel="dialog" data-transition="slidedown">Menu</a>

		</div>';

}



function getMobileFooter($page = '')

{

	if ($page == 'schedule' && !loggedIn())

		return '';

	

	$date = getdate();

	

	return '

		<div data-role="footer">

			<h4>&copy; ' . $date['year'] . '</h4>

		</div>';

}



/**

 * Get the head element common to all pages.

 * 

 * @param string $actualPage The actual page requested (but redirect if there's a hash).

 * @param string $title The title of the page.

 * @param string $initFunction The JavaScript function to call on document ready.

 * @return string The HTML for the head element.

 */

function getHead($actualPage, $title, $initFunction)

{

	return '

		<script>

			function checkRedirect(actualPage)

			{

				var pattern = /\.(\/\w*)/;

				var result  = pattern.exec(window.location.hash.toLocaleLowerCase());

				var hashPage = "";

				

				if (result && result.length > 1)

				{

					hashPage = result[1];

					

					if (actualPage != hashPage)

					{

						window.location.replace("http://www.bridgetjohansen.com" + hashPage);

					}

				}

			}

			

			checkRedirect("' . $actualPage . '");

		</script>

		<meta charset="utf-8"/>

		<meta name="description" content="Web site of the Bridget Johansen Piano Studio, which provides information about her piano instruction.">

		<meta name="keywords" content="piano, lessons, salt lake, utah, studio, bridget, mcbride, johansen">

		<title>' . $title . '</title>

		<link rel="shortcut icon" href="images/favicon.ico">

		<link href="http://fonts.googleapis.com/css?family=Vidaloka" rel="stylesheet" type="text/css">

		<link href="http://fonts.googleapis.com/css?family=Pinyon+Script" rel="stylesheet" type="text/css">

		<script type="text/javascript" src="js/jquery-1.9.1.min.js"></script>

		<script type="text/javascript" src="js/jquery.history.js"></script>

		<script type="text/javascript" src="js/jquery.cookie.js"></script>

        <script type="text/javascript" src="js/bridget.js"></script>

		<!--[if lt IE 9]>

		<script src="js/html5shiv-printshiv.js"></script>

		<![endif]-->

		

        <script type="text/javascript" src="js/jquery-ui-1.10.3.custom.min.js"></script>

        <link href="css/custom-theme/jquery-ui-1.10.3.custom.min.css" rel="stylesheet" type="text/css"/>

        

        <link href="css/bridget.css" rel="stylesheet" type="text/css"/>

        

        <script type="text/javascript">

            $(document).ready(function() {

                ' . $initFunction . '

            });

        </script>';

}



/**

 * Get the header element (with nav and audio) common to all pages.

 * 

 * @param string $selected

 * @return string The HTML for the header element.

 */

function getHeader($selected = '')

{

	$aboutClass    = $selected == 'about'    ? 'selected' : 'trans';

	$policiesClass = $selected == 'policies' ? 'selected' : 'trans';

	$scheduleClass = $selected == 'schedule' ? 'selected' : 'trans';

	$eventsClass   = $selected == 'events'   ? 'selected' : 'trans';

	$photosClass   = $selected == 'photos'   ? 'selected' : 'trans';

	

	$header = '

			<div class="main">

				<div id="logo-container">

					<div id="logo" title="Home">Bridget Johansen Piano Studio</div>

				</div>

				

				<img id="equalizer" src="images/equalizer.gif" alt="equalizer" />

				<!-- <img id="equalizer-off" src="images/equalizer-off.png" /> -->

				<div id="audio-controls"></div>

				<audio id="music" loop>

					<source src="audio/background.ogg" type="audio/ogg">

					<source src="audio/background.mp3" type="audio/mpeg">

				</audio>

				

				<nav>

					<ul>

						<li><div id="about" class="' . $aboutClass . '">About</div></li>

						<li><div id="policies" class="' . $policiesClass . '">Policies</div></li>

						<li><div id="schedule" class="' . $scheduleClass . '">Schedule</div></li>

						<li><div id="events" class="' . $eventsClass . '">Events</div></li>

						<li id="last-nav-link"><div id="photos" class="' . $photosClass . '">Photos</div></li>

					</ul>

				</nav>

			</div>';

	

	return $header;

}



/**

 * Get generic error HTML that can be used for all pages.

 * 

 * @return string

 */

function getError()

{

	return '

				<div id="schedule-error">

					<img src="images/error.png" id="schedule-error-icon" alt="Error" />

					Oops!

					<p>There was a problem displaying this page. Please try again later.</p>

				</div>';

}



/**

 * Get the footer HTML common to all pages.

 * 

 * @return string

 */

function getFooter()

{

	return '

			<div class="main">

				<ul>

					<li id="footer-phone">801.566.9622</li>

					<li id="footer-email"><a href="mailto:email@bridgetjohansen.com">email@bridgetjohansen.com</a></li>

					<li id="footer-copyright">Bridget Johansen 2013</li>

				</ul>

			</div>';

}



/**

 * Set the music cookie.

 * 

 * @param string $state The state of the music ("play" or "pause")

 */

function setMusicCookie($state = "play")

{

	setcookie("musicState", $state, time() + (60 * 60 * 24 * 365 * 5), '/', 'bridgetjohansen.com');

}



function getAdminDialogs($page)

{

	if (!loggedInAsAdmin())

		return '';

	

	$dialogs = '';

	

	if ($page == "schedule")

	{

		$dialogs .= '

            <div id="lessonScheduleDateDialog" title="Lesson Schedule Effective Date">

                <div id="lessonScheduleDatePicker"></div>

            </div>

			

			<div id="studentDialog" title="Edit Student">

				<input type="hidden" id="studentID" name="studentID" />

				<label for="studentName" >Name:</label>     <input id="studentName" name="studentName" />

				<label for="parents"     >Parent(s):</label><input id="parents"     name="parents"     />

				<label for="phone"       >Phone:</label>    <input id="phone"       name="phone"       />

				<label for="lessonDay"   >Lesson Day:</label>

														<select id="lessonDay" name="lessonDay">

															<option>Monday</option>

															<option>Tuesday</option>

															<option>Wednesday</option>

															<option>Thursday</option>

															<option>Friday</option>

															<option>Saturday</option>

														</select>

				<label for="lessonHour">Lesson Time:</label>

														<select id="lessonHour" name="lessonHour">

															<option>1</option>

															<option>2</option>

															<option>3</option>

															<option>4</option>

															<option>5</option>

															<option>6</option>

															<option>7</option>

															<option>8</option>

															<option>9</option>

															<option>10</option>

															<option>11</option>

															<option>12</option>

														</select>

														<select id="lessonMinutes" name="lessonMinutes">

															<option>00</option>

															<option>15</option>

															<option>30</option>

															<option>45</option>

														</select>

				<label for="lessonDuration">Lesson Duration:</label>

														<select id="lessonDuration" name="lessonDuration">

															<option>30 min</option>

															<option>45 min</option>

															<option>60 min</option>

														</select>

				<label for="groupClassHour">Group Class Time:</label>

														<select id="groupClassHour" name="groupClassHour">

															<option selected></option>

															<option>1</option>

															<option>2</option>

															<option>3</option>

															<option>4</option>

															<option>5</option>

															<option>6</option>

															<option>7</option>

															<option>8</option>

															<option>9</option>

															<option>10</option>

															<option>11</option>

															<option>12</option>

														</select>

														<select id="groupClassMinutes" name="groupClassMinutes">

															<option selected></option>

															<option>00</option>

															<option>15</option>

															<option>30</option>

															<option>45</option>

														</select>

			</div>



            <div id="emptyFieldDialog" title="Oops!">

                <p>You left the <span id="emptyField"></span> blank...</p>

            </div>



            <div id="addGroupClassDialog" title="Add Group Class">

                <div id="groupClassDatePicker"></div>

            </div>



            <div id="editGroupClassDialog" title="Change Group Class">

                <div id="editGroupClassDatePicker"></div>

            </div>';

	}

	elseif ($page == "events")

	{

		$dialogs .= '

			<div id="addEventDialog" title="Add Event">

				<input type="hidden" id="eventID" name="eventID" />

				<label for="eventName" >Event Name:</label>           <input id="eventName"  name="eventName" />

				<label for="datesTimes">Date(s) &amp; Time(s):</label><input id="datesTimes" name="datesTimes" />

				<label for="location">Location:</label>               <input id="location"   name="location" />

				<label for="expiration">Expiration:</label>           <input id="expiration" name="expiration" />

			</div>

			

			<div id="emptyFieldDialog" title="Oops!">

				<p>You left the <span id="emptyField"></span> blank...</p>

			</div>';

	}

	elseif ($page == "photos")

	{

		$dialogs .= '

                    <div id="uploadPicDialog" title="Upload Photo(s)">

                        <form id="uploadPicForm" name="uploadPicForm" enctype="multipart/form-data" action="http://www.bridgetjohansen.com/util.php" method="post">

                            <input type="hidden" name="command" value="15" />

                            <input type="file"   name="pics[]"  multiple />

                        </form>

                    </div>

                    

                    <div id="addCommentDialog" title="Add/Edit Comment">

                        <input type="text" id="commentInput" placeholder="Comment" />

                    </div>';

	}

	

	$dialogs .= '

            <div id="confirmDeleteDialog" title="Please Confirm">

                <p>Are you sure you want to remove <span id="thingToDelete" autofocus></span>?</p>

            </div>

            

            <div id="waitDialog" title="Please Wait">

                <p id="waitMessage"></p>

                <img src="images/loading.gif" id="loadingImage" alt="Loading..." />

            </div>';

	

	return $dialogs;

}





/* =============================

 *           Home Page

 * ============================= */



/**

 * Get the landing HTML (used only by the home page).

 * 

 * @return string The HTML for the landing using on the home page.

 */

function getLanding()

{

	return '

		<section class="landing-block" id="landing-block">

			<div class="main">

				<div class="landing-text">

					<p class="landing-aim">The final aim and reason</p>

					<p class="landing-quote">of all music is nothing other than the glorification of God and the refreshment of the human spirit.</p>

					<p class="landing-bach">&mdash; Johann Sebastian Bach</p>

				</div>

			</div>

		</section>';

}



function getHomeContentMobile()

{

	return '

			<img src="images/steinway.png" id="steinway" alt="Steinway Grand Piano" />

			<div class="landing-text">

				<p class="landing-aim">The final aim and reason</p>

				<p class="landing-quote">of all music is nothing other than the glorification of God and the refreshment of the human spirit.</p>

				<p class="landing-bach">&mdash; Johann Sebastian Bach</p>

			</div>

			<div class="gb">

				<p class="pp">

					Bridget McBride Johansen offers weekly, private piano lessons in the Salt Lake City area. Her instruction spans a variety of topics including sight reading, 

					memorization, theory, technique, and music history.<br/><br/>

					

					Bridget was named Youth Conservatory Teacher of the Year at Utah State University, where she graduated with a Bachelor of Music in Piano Pedagogy. Bridget

					has served as Chairman of the Salt Lake Area Federation of Music Clubs.

				</p>

				<div class="center-wrapper">

					<a href="about" data-role="button" data-icon="arrow-r" data-iconpos="right" data-inline="true">More About Bridget</a>

				</div>

			</div>';

}



function getHomeContent()

{

	$homeContent = '

				<div id="about-content">

					<h1 class="section-title">

						About Bridget

					</h1>

					<p class="about-blurb">

						Bridget McBride Johansen, <abbr title="Nationally Certified Teacher of Music">NCTM</abbr>, offers weekly, private piano lessons in the Salt Lake City area. 

						Her instruction spans a variety of topics including sight reading, memorization, theory, technique, and music history.<br/><br/>

						Bridget was named Youth Conservatory Teacher of the Year at Utah State University, where she graduated with a Bachelor of Music in Piano Pedagogy. Bridget

						has served as Chairman of the Salt Lake Area Federation of Music Clubs.

					</p>

					<a href="" id="moreAboutBridget" class="button">

						<span>More About Bridget</span>

					</a>

				</div>

				<div id="landing-events">

					<h1 class="section-title">

						Upcoming Events

					</h1>';

	

	$dbh = getDBH(true);

	

	if (is_null($dbh))

	{

		$homeContent .= '

					<p>There are no upcoming events.</p>

				</div>';

	}

	else

	{

		$lookUpEvents = $dbh->prepare("SELECT name, date, location, DATE_FORMAT(expiration, '%m/%e/%Y') AS formatted_expiration FROM events WHERE expiration >= DATE(NOW()) ORDER BY expiration LIMIT 2");

		

		if (!$lookUpEvents->execute())

		{

			$homeContent .= '

					<p>There are no upcoming events.</p>

				</div>';

		}

		else

		{

			$results = $lookUpEvents->fetchAll(PDO::FETCH_ASSOC);

			

			if (count($results) > 0)

			{

				$homeContent .= '

					<ul id="landing-events-list">';

				

				for ($i = 0; $i < count($results); $i++)

				{

					$name     = $results[$i]['name'];

					$date     = $results[$i]['date'];

					$location = $results[$i]['location'];

					

					$homeContent .= '

						<li>

							<p class="landing-event-title">' . $name . '</p>

							<p class="landing-event-date">' . $date . '</p>

							<p>' . $location . '</p>

						</li>';

				}

				

				$homeContent .= '

					</ul>

				</div>';

			}

			else

			{

				$homeContent .= '

					<p>There are no upcoming events.</p>

				</div>';

			}

		}

	}

	

	return $homeContent;

}





/* ==============================

 *           About Page

 * ============================== */



function getAboutContentMobile()

{

	return '

<img src="images/bridget.jpg" id="about-bridget-photo" alt="Photo of Bridget" />

			

			<div class="gb">

				<div data-role="header">

					<h1 style="text-align:left; margin-left: 0.5em">Experience</h1>

				</div>

			

				<p class="pp">

					Bridget has been offering private piano instruction since 1989. In conjunction with her undergradute work, Bridget taught group theory and music education courses to children

					ages 6 - 14 at the Utah State University Youth Conservatory. She later taught individual piano lessons for the Utah State University Department of Music.<br/><br/>

					

					Bridget has served as judge and adjudicator for numerous competitions including the USU Piano Festival, the WSU Piano Festival, the Joy Robin Piano Competition,

					and the UMTA Performance Evaluations. She also enjoys playing the organ, having studied with Joyce Peabody of the Day Murray Music Organ School.<br/><br/>

					

					Bridget has provided private piano instruction for the Gifted Music School, Prepatory Division. She continues to serve on their Spring Gala Committee.<br/><br/>

					

					Bridget is an active member of several professional music organizations:<br/><br/>

					

					<a href="http://www.mtna.org" target="_blank" class="normal-link">MTNA</a><br/>

					<a href="http://www.utahmta.org" target="_blank" class="normal-link">UMTA</a><br/>

					<a href="http://www.ufmc-music.org" target="_blank" class="normal-link">UFMC</a><br/><br/>

					

					Bridget frequently participates in workshops, festivals, lectures, recitals, and concerts. She has attended a variety of master classes from world-renowned artists, including:<br/><br/>

					

					<a href="http://www.americancomposers.org/bios20010318.htm" target="_blank" class="normal-link">Leon Fleisher</a><br/>

					<a href="http://www.danielpollack.com" target="_blank" class="normal-link">Daniel Pollack</a><br/>

					<a href="http://www.tunepiano.com/claude.htm" target="_blank" class="normal-link">Claude Frank</a><br/>

					<a href="http://music.msu.edu/faculty/profile/panayis" target="_blank" class="normal-link">Panayis Lyras</a><br/>

					<a href="http://www.marinalomazov.com" target="_blank" class="normal-link">Marina Lomazov</a><br/>

					<a href="http://www.yefimbronfman.com" target="_blank" class="normal-link">Yefin Bronfman</a><br/>

					<a href="http://www.pompa-baldi.com" target="_blank" class="normal-link">Antonio Pompa-Baldi</a><br/>

					<a href="http://www.normankrieger.com/bio.htm" target="_blank" class="normal-link">Norman Krieger</a><br/>

					<a href="http://www.robertoplano.com/i_index.asp" target="_blank" class="normal-link">Roberto Plano</a><br/>

					<a href="http://www.olgakern.com/home.html" target="_blank" class="normal-link">Olga Kern</a><br/>

					<a href="http://www.stephenbeus.com/" target="_blank" class="normal-link">Stephen Beus</a>

				</p>

				

				<div data-role="header">

					<h1 style="text-align:left; margin-left: 0.5em">Education</h1>

				</div>

				

				<p class="pp">

					Bridget graduated from Utah State University with a Bachelor of Music in Piano Pedagogy. She then completed post-graduate courses in Piano Performance at California State University.

					<br/><br/>

					In 2003, Bridget earned the designation <em>Nationally Certified Teacher of Music</em> from the Music Teacher\'s National Association.

				</p>

				

				<div data-role="header">

					<h1 style="text-align:left; margin-left: 0.5em">Awards</h1>

				</div>

				

				<p class="pp">

					Bridget was awarded a scholarship in Piano Pedagogy by the Utah State University Piano Department. Thereafter she was deemed Teaching Assistant of the Year and Teacher of the Year

					by the Utah State Youth Conservatory. Bridget was also awarded a graduate fellowship by California State University, Sacramento.

				</p>

			</div>';

}



function getAboutContent()

{

	return '

				<div id="about-content">

					<h1 class="section-title">

						Experience

					</h1>

					<img src="images/bridget.jpg" id="about-bridget-photo" alt="Photo of Bridget" />

					<p class="about-blurb">

						Bridget has been offering private piano instruction since 1989. In conjunction with her undergradute work, Bridget taught group theory and music education courses to children

						ages 6 - 14 at the Utah State University Youth Conservatory. She later taught individual piano lessons for the Utah State University Department of Music.<br/><br/>

						

						Bridget has served as judge and adjudicator for numerous competitions including the USU Piano Festival, the WSU Piano Festival, the Joy Robin Piano Competition,

						and the UMTA Performance Evaluations. She also enjoys playing the organ, having studied with Joyce Peabody of the Day Murray Music Organ School.<br/><br/>

			

						Bridget has provided private piano instruction for the Gifted Music School, Prepatory Division. She continues to serve on their Spring Gala Committee.<br/><br/>

						

						Bridget is an active member of several professional music organizations:

					</p>

					<ul class="experience-list">

						<li><a href="http://www.mtna.org" target="_blank" class="normal-link">Music Teacher\'s National Association</a></li>

						<li><a href="http://www.utahmta.org" target="_blank" class="normal-link">Utah Music Teacher\'s Association</a></li>

						<li><a href="http://www.ufmc-music.org" target="_blank" class="normal-link">Utah Federation of Music Clubs</a></li>

					</ul>

					<p class="about-blurb" id="master-class-intro">

						Bridget frequently participates in workshops, festivals, lectures, recitals, and concerts. She has attended a variety of master classes from world-renowned artists, including:

					</p>

					<ul class="experience-list">

						<li><a href="http://www.americancomposers.org/bios20010318.htm" target="_blank" class="normal-link">Leon Fleisher</a></li>

						<li><a href="http://www.danielpollack.com" target="_blank" class="normal-link">Daniel Pollack</a></li>

						<li><a href="http://www.tunepiano.com/claude.htm" target="_blank" class="normal-link">Claude Frank</a></li>

						<li><a href="http://music.msu.edu/faculty/profile/panayis" target="_blank" class="normal-link">Panayis Lyras</a></li>

						<li><a href="http://www.marinalomazov.com" target="_blank" class="normal-link">Marina Lomazov</a></li>

						<li><a href="http://www.yefimbronfman.com" target="_blank" class="normal-link">Yefin Bronfman</a></li>

						<li><a href="http://www.pompa-baldi.com" target="_blank" class="normal-link">Antonio Pompa-Baldi</a></li>

						<li><a href="http://www.normankrieger.com/bio.htm" target="_blank" class="normal-link">Norman Krieger</a></li>

						<li><a href="http://www.robertoplano.com/i_index.asp" target="_blank" class="normal-link">Roberto Plano</a></li>

						<li><a href="http://www.olgakern.com/home.html" target="_blank" class="normal-link">Olga Kern</a></li>

						<li><a href="http://www.stephenbeus.com/" target="_blank" class="normal-link">Stephen Beus</a></li>

					</ul>

				</div>

				<div id="about-education">

					<h1 class="section-title">

						Education

					</h1>

					<p class="about-blurb">

						Bridget graduated from Utah State University with a Bachelor of Music in Piano Pedagogy.<br/><br/>

						

						She completed post-graduate courses in Piano Performance at California State University.<br/><br/>

						

						In 2003, she earned the designation <em>Nationally Certified Teacher of Music</em> from the Music Teacher\'s National Association.

					</p>

				</div>

				<div id="about-awards">

					<h1 class="section-title">

						Awards

					</h1>

					<ul class="award-list">

						<li>Graduate Fellowship - California State University, Sacramento</li>

						<li>Teacher of the Year - Utah State University Youth Conservatory</li>

						<li>Teaching Assistant of the Year - Utah State University Youth Conservatory</li>

						<li>Piano Pedagogy Scholarship - Utah State University Piano Department</li>

					</ul>

				</div>';

}





/* =================================

 *           Policies Page

 * ================================= */



function getPoliciesContentMobile()

{

	return '

			<div class="gb">

				<p class="pp">

					Lessons are designed to provide students with a well-rounded approach to playing the piano. Students are taught to play musically, to sight read, and to be 

					detail-oriented. Theory and technical work are an integral part of curriculum. Students should come to lessons with all assignments completed from the 

					previous week. Students receive a grade at the end of each lesson based on overall preparedness:

					<br/><br/>

					<strong>5</strong> - Exceptional preparation; all assignments well-practiced; outstanding lesson

					<br/>

					<strong>4</strong> - Good preparation; most assignments practiced; some room for improvement

					<br/>

					<strong>3</strong> - Not prepared; most assignments not practiced; much room for improvement

					<br/><br/>

					Students who consistently receive a grade of four or above will remain in good standing and continue study. Those who consistently receive a lower grade 

					will be asked to reconsider their commitment to studying the piano with Bridget Johansen.

					<br/><br/>

					Four group classes will be held during the school year, focusing on music theory, ear training, performance, and history. Group classes provide an excellent 

					opportunity for students to interact with peer musicians.

				</p>

				

				<div data-role="header">

					<h1 style="text-align:left; margin-left: 0.5em">Instructor Expectations</h1>

				</div>

				

				<p class="pp">

					Piano practice is required six days per week. It is strongly recommended that students practice before and after their lessons. Students should document 

					their practice time and strive to practice according to the following daily guidelines:

				</p>

				

				<table border="1" class="pct">

					<tr>

						<th>Age</th><th>Time</th>

					</tr>

					<tr>

						<td>5-8</td><td>30 minutes</td>

					</tr>

					<tr>

						<td>9-11</td><td>45 minutes</td>

					</tr>

					<tr>

						<td>12-13</td><td>60 minutes</td>

					</tr>

					<tr>

						<td>14-15</td><td>75 minutes</td>

					</tr>

					<tr>

						<td>16+</td><td>90-120 minutes</td>

					</tr>

				</table>

				

				<div data-role="header">

					<h1 style="text-align:left; margin-left: 0.5em">Parent Involvement</h1>

				</div>

				

				<p class="pp">

					Parents with students younger than age eleven should attend weekly lessons, take notes, and assist their child in daily practice. If a parent is unable to attend, the student 

					may record the lesson with a video or audio recording device. Students between the ages of eleven and twelve are encouraged to develop independence in their music study; 

					therefore, parental attendance during this stage is optional. Students older than age thirteen should be primarily independent in their music study and practice. Parents 

					should encourage students to practice daily. The more involved parents become in their child\'s piano experience, the better the child\'s experience will be.

				</p>

				

				<div data-role="header">

					<h1 style="text-align:left; margin-left: 0.5em">Performing</h1>

				</div>

				

				<p class="pp">

					Students should wear their best attire in any performance. Boys should wear slacks, a collared shirt, and preferably a tie. Girls should wear a dress or skirt which covers 

					the knees, and should wear shoes with a flat heel. Jeans, shorts, mini-skirts, white socks, tennis shoes and flip flops are not appropriate attire for performing. Families 

					should arrive at recitals on time and plan to stay for the duration. Students who cannot stay for the entire recital will not be able to play. <em>To minimize noise and 

					distraction, children under the age of five should not attend recitals.</em>

				</p>

				

				<div data-role="header">

					<h1 style="text-align:left; margin-left: 0.5em">Extracurricular Performances</h1>

				</div>

				

				<p class="pp">

					Students are encouraged to perform for occasions other than events organized by Bridget Johansen Piano Studio. This includes performances at school, church, community affairs, 

					or family events. Students should attend classical music concerts as much as possible to increase their awareness and listening skills. There are numerous concert opportunities 

					available in our community, including: The Utah Symphony, Gina Bachauer, university recitals, and concerts on Temple Square.

				</p>

				

				<div data-role="header">

					<h1 style="text-align:left; margin-left: 0.5em">Studio Rules</h1>

				</div>

				

				<ul id="studio-rules">

					<li>Arrive on time.</li>

					<li>Park in front of the studio, perpendicular to the curb. Do not park in the driveway.</li>

					<li>Remove shoes upon arrival.</li>

					<li>Close the door at the top of the stairs.</li>

					<li>Wash hands in the basement bathroom adjacent to the piano studio.</li>

					<li><em>Turn off mobile phones.</em></li>

					<li>Do not wear rings, bracelets, or watches while playing the piano.</li>

					<li>Do not bring food, candy, or gum to lessons.</li>

					<li>Do not bring friends to lessons.</li>

					<li>Depart on time.</li>

				</ul>

				

				<div data-role="header">

					<h1 style="text-align:left; margin-left: 0.5em">Monthly Tuition</h1>

				</div>

				

				<p class="pp">

					Invoices are emailed on the 25th of each month and include tuition for the upcoming month, festival fees, and costs for music and other materials. Payment is due by the 

					10th of the following month to Bridget Johansen Piano Studio. Payments received after the 10th will incur a late fee.

					<br/><br/>

					Monthly tuition is derived from more than just a student\'s weekly lesson. Tuition also reflects time spent by Bridget attending music conferences and board meetings, 

					organizing recitals, selecting music, preparing lesson plans, entering students in festivals and competitions, and judging festivals.

					<br/><br/>

					There will be four group classes held during the school year. The cost of group classes is added to the tuition during the months they are held. There is no refund or 

					credit for missed group classes. Parents need not attend group classes.

				</p>

				

				<div data-role="header">

					<h1 style="text-align:left; margin-left: 0.5em">Missed Lessons</h1>

				</div>

				

				<p class="pp">

					Fees are not lowered or credited for missed lessons. A calendar of lesson days and holidays has been provided. Lessons are billed according to this calendar. Should a 

					conflict arise with a scheduled lesson time, students are encouraged to trade lesson times with another student. A current and password-protected lesson schedule can 

					be found <a href="" id="scheduleFoundHere" class="normal-link">here</a>. Trade arrangements should be made by the students and should be mutually agreeable. Bridget 

					will not be held responsible for any miscommunications or financial misunderstandings. Lessons cancelled by Bridget will always be credited. Students who discontinue 

					lessons for any reason will not be refunded tuition for that month. If a student takes a leave of absence for any reason, tuition is required to hold his/her place in 

					the studio.

				</p>

			</div>';

}



function getPoliciesContent()

{

	return '

				<div id="policies-content">

					<h1 class="section-title">

						Studio Policies - 2013

					</h1>

					<h2 class="policy-header">Lessons</h2>

					<p class="policy">

						Lessons are designed to provide students with a well-rounded approach to playing the piano. Students are taught to play musically, to sight read, and to be 

						detail-oriented. Theory and technical work are an integral part of curriculum. Students should come to lessons with all assignments completed from the 

						previous week. Students receive a grade at the end of each lesson based on overall preparedness:

						<br/><br/>

						<strong>5</strong> - Exceptional preparation; all assignments well-practiced; outstanding lesson

						<br/>

						<strong>4</strong> - Good preparation; most assignments practiced; some room for improvement

						<br/>

						<strong>3</strong> - Not prepared; most assignments not practiced; much room for improvement

						<br/><br/>

						Students who consistently receive a grade of four or above will remain in good standing and continue study. Those who consistently receive a lower grade 

						will be asked to reconsider their commitment to studying the piano with Bridget Johansen.

						<br/><br/>

						Four group classes will be held during the school year, focusing on music theory, ear training, performance, and history. Group classes provide an excellent 

						opportunity for students to interact with peer musicians.

					</p>

					<h2 class="policy-header">Instructor Expectations</h2>

					<p class="policy">

						Piano practice is required six days per week. It is strongly recommended that students practice before and after their lessons. Students should document 

						their practice time and strive to practice according to the following daily guidelines:

					</p>

					<table border="1">

							<tr>

								<th>Age</th><th>Time</th>

							</tr>

							<tr>

								<td>5-8</td><td>30 minutes</td>

							</tr>

							<tr>

								<td>9-11</td><td>45 minutes</td>

							</tr>

							<tr>

								<td>12-13</td><td>60 minutes</td>

							</tr>

							<tr>

								<td>14-15</td><td>75 minutes</td>

							</tr>

							<tr>

								<td>16+</td><td>90-120 minutes</td>

							</tr>

						</table>

					<h2 class="policy-header">Parent Involvement</h2>

					<p class="policy">

						Parents with students younger than age eleven should attend weekly lessons, take notes, and assist their child in daily practice. If a parent is unable to attend, the student 

						may record the lesson with a video or audio recording device. Students between the ages of eleven and twelve are encouraged to develop independence in their music study; 

						therefore, parental attendance during this stage is optional. Students older than age thirteen should be primarily independent in their music study and practice. Parents 

						should encourage students to practice daily. The more involved parents become in their child\'s piano experience, the better the child\'s experience will be.

					</p>

					<h2 class="policy-header">Performing</h2>

					<p class="policy">

						Students should wear their best attire in any performance. Boys should wear slacks, a collared shirt, and preferably a tie. Girls should wear a dress or skirt which covers 

						the knees, and should wear shoes with a flat heel. Jeans, shorts, mini-skirts, white socks, tennis shoes and flip flops are not appropriate attire for performing. Families 

						should arrive at recitals on time and plan to stay for the duration. Students who cannot stay for the entire recital will not be able to play. <em>To minimize noise and 

						distraction, children under the age of five should not attend recitals.</em>

					</p>

					<h2 class="policy-header">Extracurricular Performances and Concert Attendance</h2>

					<p class="policy">

						St…