/teacher/agenda.php
PHP | 218 lines | 208 code | 0 blank | 10 comment | 11 complexity | 2ede5e90762149242dd4f23346047d8d MD5 | raw file
- <?php
- session_start();
- //Credentials aren't legit or user isn't an admin, kick back to login screen
- if (!isset($_SESSION['username']) ||
- $_SESSION['login']!=true ||
- $_SESSION['student']) {
- $_SESSION['from_teacher']=true;
- header("Location: ../login.html");
- }
- $master_username=$_SESSION['username'];
- $ghostuser=$_SESSION['ghostuser'];
- if(!is_null($ghostuser))
- $username=$_SESSION['ghostuser'];
- else
- $username=$_SESSION['username'];
- include_once '../admin/settings.php';
- //Connects to MySQL and Selects Database
- $con = mysql_connect($host,$db_username,$db_password);
- if (!$con)
- die('Could not connect: ' . mysql_error());
- //Select DB
- mysql_select_db($db, $con);
- //Internal user id
- $userid=NULL;
- $get_userid_result=mysql_query("SELECT id FROM users WHERE username=\"$username\"") or die(mysql_error());
- $get_userid_array=mysql_fetch_array($get_userid_result);
- $userid=$get_userid_array['id'];
- //Get Quarter Start Dates
- $get_settings_result=mysql_query(
- "SELECT quarter_1_start,quarter_3_start FROM settings LIMIT 1") or die(mysql_error());
- $get_settings_array=mysql_fetch_array($get_settings_result);
- $quarter_1_start_date=$get_settings_array['quarter_1_start'];
- $quarter_3_start_date=$get_settings_array['quarter_3_start'];
- //Get current Semester
- $current_semester;
- if((date('Y-m-d') < $quarter_1_start_date || date('Y-m-d') >= $quarter_1_start_date) && date('Y-m-d') < $quarter_3_start_date){
- $current_semester=1;
- }
- else if(date('Y-m-d') >= $quarter_3_start_date){
- $current_semester=2;
- }
- //Get next date for XY Courses
- $next_xy_result=mysql_query("SELECT id,date
- FROM course_schedule
- WHERE date >= " . date('Y-m-d') . " AND ( x=1 OR y=1 )ORDER BY date LIMIT 1") or die(mysql_error());
- $next_xy_row= mysql_fetch_array($next_xy_result);
- $next_xy=$next_xy_row['date'];
- //Get next date for Colloquium
- $next_col_result=mysql_query("SELECT id,date
- FROM course_schedule
- WHERE date >= " . date('Y-m-d') . " AND colloquium=1 ORDER BY date LIMIT 1") or die(mysql_error());
- $next_col_row= mysql_fetch_array($next_xy_result);
- $next_col_date=$next_col_row['date'];
- $next_col_id=$next_col_row['id']; //course_schedule_id
- //Get Colloquium assignment for selected Semester
- $col_assignment_result=mysql_query(
- "SELECT assignments.id, courses.name
- FROM assignments
- INNER JOIN `courses` on assignments.course_id=courses.id
- WHERE courses.teacher_id=$userid AND assignments.colloquium_semester=$current_semester
- LIMIT 1") or die(mysql_error());
- $col_assignment_row=mysql_fetch_array($col_assignment_result);
- $col_assignments_id=$col_assignment_row['id']; //assignments_id
- $next_col_name=$col_assignment_row['name'];
- //Get current roster for Colloquium
- $col_roster_result=mysql_query(
- "SELECT enrollments.assignments_id, enrollments.users_id,
- users.lastname, users.firstname, users.id
- FROM enrollments
- INNER JOIN `users` on enrollments.users_id=users.id
- WHERE enrollments.assignments_id=$col_assignments_id ") or die(mysql_error());
- mysql_close();
- ?>
- <!DOCTYPE html>
- <html lang='en'>
- <head>
- <meta charset='utf-8'>
- <title>Enroll: <?php echo $school_name; ?></title>
- <meta name='viewport' content='width=device-width, initial-scale=1.0'>
- <meta name='description' content="Flexible Scheduling for Today's Classroom">
- <meta name='author' content='Marcos Alcozer'>
- <meta name='keywords' content='Education, Scheduling'>
- <!-- CSS -->
- <style>
- body {
- padding-top: 60px; /* 60px to make the container go all the way to the bottom of the topbar */
- }
- </style>
- <link href="//netdna.bootstrapcdn.com/twitter-bootstrap/2.3.2/css/bootstrap-combined.min.css" rel="stylesheet">
- <!-- <link href="../css/bootstrap.css" rel="stylesheet">
- <link href="../css/bootstrap-responsive.css" rel="stylesheet"> -->
- <link href="../css/admin.css" rel="stylesheet">
- <!-- JQUERY -->
- <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
- <!-- BOOTSTRAP -->
- <!-- <script src="../js/bootstrap.min.js"></script> -->
- <script src="//netdna.bootstrapcdn.com/twitter-bootstrap/2.3.2/js/bootstrap.min.js"></script>
- <!-- AJAX UPLOAD BY BRYAN GENTRY -->
- <!-- http://bryangentry.us/ajax-upload-with-javascript-and-php-upload-an-image-and-display-a-preview/ -->
- <script src="../js/ajaxupload.js"></script>
- <!-- INHOUSE JAVASCRIPT -->
- <script src="../js/teacher.js"></script>
- <!-- HTML5 shim, for IE6-8 support of HTML5 elements -->
- <!--[if lt IE 9]>
- <script src="../js/html5shiv.js"></script>
- <![endif]-->
- </head>
- <body>
- <?php include_once("../admin/analyticstracking.php") ?>
- <div class="navbar navbar-inverse navbar-fixed-top">
- <div class="navbar-inner">
- <div class="container">
- <button type="button" class="btn btn-navbar" data-toggle="collapse" data-target=".nav-collapse">
- <span class="icon-bar"></span>
- <span class="icon-bar"></span>
- <span class="icon-bar"></span>
- </button>
- <a class="brand appname" href="#">Enroll<img src='../img/beta-icon.png' style="vertical-align:text-top;"/></a>
- <div class="nav-collapse collapse">
- <ul class="nav">
- <li class="active"><a href="agenda.php">Agenda</a></li>
- <li class="dropdown">
- <a href="#" class="dropdown-toggle" data-toggle="dropdown">X/Y <b class="caret"></b></a>
- <ul class="dropdown-menu">
- <li><a href="assigned_xy.php">Assign Course</a></li>
- <li><a href="repository_xy.php">Course Repository</a></li>
- <li><a href="preenroll_xy.php">Enroll Students</a></li>
- </ul>
- </li>
- <li class="dropdown">
- <a href="#" class="dropdown-toggle" data-toggle="dropdown">Colloquium <b class="caret"></b></a>
- <ul class="dropdown-menu">
- <li><a href="assigned_col.php">Assign Course</a></li>
- <li><a href="repository_col.php">Course Repository</a></li>
- <li class="dropdown-submenu">
- <a tabindex="-1" href="#">Enroll Students</a>
- <ul class="dropdown-menu">
- <li><a href="preenroll_col.php?semester=1">Semester 1</a></li>
- <li><a href="preenroll_col.php?semester=2">Semester 2</a></li>
- </ul>
- </li>
- </ul>
- </li>
- </ul>
- <ul class="nav pull-right">
- <?php if($_SESSION['admin'] && $_SESSION['teacher']){
- echo "<li><a href='../admin'>Admin Panel</a></li>";
- }
- if(!is_null($ghostuser)){ ?>
- <li><a href="javascript:void(0)" onclick='ghost_user("<?php echo $master_username; ?>","admin");'><?php echo $master_username; ?></a></li>
- <?php
- }
- if(!isset($_SESSION['username']))
- echo "<li class='login-button'><a href='../login.html' style='color:#FFFFFF'>Login</a></li>";
- else
- echo "<li class='login-button'><a href='../logout.php' style='color:#FFFFFF'>Logout</a></li>";
- ?>
- </ul>
- </div><!--/.nav-collapse -->
- </div>
- </div>
- </div>
- <div class="container">
- <h1 class='hidden-phone'>
- Agenda for <?php echo date('l F jS, Y', strtotime($next_xy)); ?>
- </h1>
- <h3 class='visible-phone'>
- Agenda for <?php echo date('l F jS, Y', strtotime($next_xy)); ?>
- </h3>
- <hr />
- <div id="main" role="main">
- Colloquium: <?php echo $next_col_name; ?>
- <table class="table table-striped table-condensed table-hover">
- <thead>
- <tr>
- <th>Last Name</th>
- <th>First Name</th>
- <th>Status</th>
- </tr>
- </thead>
- <tbody>
- <?php
- while($row=mysql_fetch_array($col_roster_result)){
- ?>
- <tr>
- <form class="form" action="#" method="post">
- <input name='assignments_id' type='hidden' value="<?php echo $col_assignments_id; ?>" />
- <input name='users_id' type='hidden' value="<?php echo $row['id']; ?>" />
- <input name='course_schedule_id' type='hidden' value="<?php echo $next_col_id; ?>" />
- <td>
- <?php echo $row['lastname']; ?>
- </td>
- <td>
- <?php echo $row['firstname']; ?>
- </td>
- <td>
- <select name='attendance'>
- <option value=0>Present</option>
- <option value=2>Tardy</option>
- <option value=1>Absent</option>
- </select>
- </td>
- </form>
- </tr>
- <?php
- }
- ?>
- </tbody>
- </table>
- <button name="colloquium-attendance" type="submit" class="btn btn-primary">Update</button>
- </div>
- </div> <!-- /container -->
- </body>
- </html>