-
Notifications
You must be signed in to change notification settings - Fork 0
/
addmeeting.php
131 lines (119 loc) · 5.05 KB
/
addmeeting.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
<?php
require_once('connectvars.php');
require_once('appfunctions.php');
$dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
$form_type = mysqli_real_escape_string($dbc, trim($_GET['type']));
$page_title = 'Schedule Meeting';
$page_access = 'All';
include('header.php');
//include other scripts needed here
echo '<script src="js/forms_scripts.js"></script>';
//end header
echo '</head>';
//start body
echo '<body>';
//include nav bar
include('navbar-students.php');
?>
<div class="bd-pageheader bg-primary text-white pt-4 pb-4">
<div class="container">
<h1>
Students
</h1>
<p class="lead">
Manage students and interventions
</p>
</div>
</div>
<div class="container mt-5 mb-5">
<div class="row">
<div class="col-12">
<h1>
Schedule Meeting
</h1>
<p class="lead">
Use this page to schedule a student-based meeting.
</p>
<p>
<a class="btn btn-secondary" href="meetings.php">Meetings</a>
</p>
<form method="post" action="service.php">
<input type="hidden" name="action" value="scheduleMeeting">
<input type="hidden" name="username" value="<?php echo $_SESSION['username']; ?>">
<input type="hidden" name="user" value="<?php echo $_SESSION['firstname'] . ' ' . $_SESSION['lastname']; ?>">
<div class="form-row">
<div class="form-group col-md-6">
<label for="student_id">Student</label>
<select class="form-control" id="student_id" name="student_id">
<option disabled selected></option>
<?php
$query = "SELECT firstname, lastname, grade, student_id FROM student_list ORDER BY lastname, firstname";
$result = mysqli_query($dbc, $query);
while ($row = mysqli_fetch_array($result)) {
echo '<option value="' . $row['student_id'] . '">' . $row['lastname'] . ', ' . $row['firstname'] . ' (Gr. ' . $row['grade'] . ')</option>';
}
?>
</select>
<small class="muted-text text-danger required">Required</small>
</div>
<div class="form-group col-md-6">
<label for="type">Meeting Type</label>
<select class="form-control" id="type" name="type">
<option disabled selected></option>
<option value="IEP Meeting">IEP Meeting</option>
<option value="Manifestation Meeting">Manifestation Meeting</option>
<option value="Disciplinary Hearing">Disciplinary Hearing</option>
</select>
<small class="muted-text text-danger required">Required</small>
</div>
</div>
<div class="form-row">
<div class="form-group col-md-6">
<label for="date">Date of Meeting</label>
<input type="date" class="form-control" name="date" id="date">
<small class="muted-text text-danger required">Required</small><br>
<small class="muted-text">mm/dd/yyyy</small>
</div>
<div class="form-group col-md-6">
<label for="time">Time of Meeting</label>
<input type="time" class="form-control" name="time" id="time">
<small class="muted-text text-danger required">Required</small><br>
<small class="muted-text">hh:mm AM/PM</small>
</div>
</div>
<div class="form-row">
<div class="form-group col-md-6">
<label for="notes">Description/Notes</label>
<textarea rows="5" class="form-control" name="notes" id="notes"></textarea>
</div>
<div class="form-group col-md-6">
<label for="staff">Staff</label>
<select class="form-control" id="staff" name="staff[]" multiple size="5">
<option disabled selected></option>
<?php
$username = $_SESSION['username'];
$query = "SELECT firstname, lastname, username FROM staff_list WHERE lastname NOT LIKE 'Vacancy%' AND status = 1 AND username <> '$username' ORDER BY lastname, firstname";
$result = mysqli_query($dbc, $query);
while ($row = mysqli_fetch_array($result)) {
echo '<option value="' . $row['username'] . '">' . $row['lastname'] . ', ' . $row['firstname'] . '</option>';
}
?>
</select>
<small class="muted-text text-danger required">Required</small><br>
<small class="muted-text">Hold Ctrl or ⌘ to select multiple options.</small>
</div>
</div>
<div id="alert" class="alert" role="alert">
</div>
<a class="btn btn-primary" href="#!" id="btnSubmitForm">Submit</a>
<a class="btn btn-danger" href="meetings.php">Cancel</a>
</form>
</div>
</div>
</div>
<?php
mysqli_close($dbc);
//include footer
include('footer.php');
?>