API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 27th, 2018
328
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 29.68 KB | None | 0 0
raw download clone embed print report
  1. <!-- This page allows you to allocate sesions for a student and tutor. -->
  2. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  3. <?php include 'LoginCheck.php'; ?>
  4. <?php
  5. //session_start(); // start up your PHP session!
  6. include '../Rules/dbconfig.php';
  7. include '../Rules/datepicker.php';
  8. include '../Rules/days.php';
  9. date_default_timezone_set('America/New_York');
  10.  
  11. ?>
  12.  
  13. <html>
  14. <head>
  15. <title>Session Allocate</title>
  16. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/>
  17. <link rel="stylesheet" type="text/css" href="../css/allocate.css" />
  18. <!-- datepicker Jquery function-->
  19. <link rel="stylesheet" href="../css/datepicker.css" />
  20.  
  21. <!-- Two datepicker, another script function-->
  22. <script>
  23. /* $(function() {
  24. $("#datepicker, #datepicker2").datepicker({
  25. onSelect: function(dateText, inst) {
  26. $(this).prev()[0].value = dateText;
  27. }
  28. });
  29. });
  30. $(function() {
  31. $("#datepicker, #datepicker2").datepicker({dateFormat: 'yy-mm-dd'});
  32. }); */
  33. </script>
  34. <script type="text/javascript">
  35. function showUser(str) {
  36. if (str == "") {
  37. document.getElementById("txtHint").innerHTML = "";
  38. return;
  39. }
  40. if (window.XMLHttpRequest) { // code for IE7+, Firefox, Chrome, Opera, Safari
  41. xmlhttp = new XMLHttpRequest();
  42. } else { // code for IE6, IE5
  43. xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
  44. }
  45. xmlhttp.onreadystatechange = function() {
  46. if (xmlhttp.readyState == 4 && xmlhttp.status == 200) {
  47. document.getElementById("txtHint").innerHTML = xmlhttp.responseText;
  48. }
  49. }
  50. xmlhttp.open("GET", "searchCourse.php?q=" + str, true);
  51. xmlhttp.send();
  52. }
  53. function validateForm() {
  54. var sType = document.forms["myForm"]["SessionType"].value;
  55. if (sType == null || sType == "---SELECT---") {
  56. alert("Please Select A Session Type");
  57. return false;
  58. }
  59.  
  60. var sname = document.forms["myForm"]["Sname"].value;
  61. if (sname == null || sname == "---SELECT---") {
  62. alert("Please Select A Student");
  63. return false;
  64. }
  65.  
  66. var tname = document.forms["myForm"]["Tname"].value;
  67. if (tname == null || tname == "---SELECT---") {
  68. alert("Please Select A Tutor");
  69. return false;
  70. }
  71.  
  72. var stime = document.forms["myForm"]["SessionTime"].value;
  73. if (stime == null || stime == "---SELECT---") {
  74. alert("Please Select A Session Time");
  75. return false;
  76. }
  77.  
  78. var sdate = document.forms["myForm"]["startdate"].value;
  79. if (sdate == null || sdate == "---SELECT---" || sdate == "") {
  80. alert("Please Select The Session Start Date");
  81. return false;
  82. }
  83.  
  84. var edate = document.forms["myForm"]["enddate"].value;
  85. if (edate == null || edate == "---SELECT---" || edate == "") {
  86. alert("Please Select The Session End Date");
  87. return false;
  88. }
  89. if (sdate){
  90. var today = new Date();
  91. var dd = today.getDate();
  92. var mm = today.getMonth()+1; //January is 0!
  93. var yyyy = today.getFullYear();
  94.  
  95. if(dd<10) {
  96. dd='0'+dd
  97. }
  98.  
  99. if(mm<10) {
  100. mm='0'+mm
  101. }
  102.  
  103. todayDate = mm+'/'+dd+'/'+yyyy;
  104. var currentDate = new Date(todayDate);
  105. var startDate = new Date(sdate);
  106. var endDate = new Date(edate);
  107. if(sType == " " || sType == "E" ){
  108. if(startDate < currentDate){
  109. alert("Start Date cannot be less than Current Date!!");
  110. return false;
  111. }
  112. if(endDate < currentDate){
  113. alert("End Date cannot be less than Current Date!!");
  114. return false;
  115. }
  116. }
  117. //Dated: 10/30/2015 Task: To add only past sessions in Add On Session Type.
  118. if(sType == "A"){
  119. if(startDate > currentDate){
  120. alert("Add-On is for past sessions. So, Start Date cannot be greater than Current Date!!");
  121. return false;
  122. }
  123. if(endDate > currentDate){
  124. alert("Add-On is for past sessions.So, End Date cannot be greater than Current Date!!");
  125. return false;
  126. }
  127. }
  128. if (endDate < startDate){
  129. alert("End Date cannot be less than Start Date!!");
  130. return false;
  131. }
  132. }
  133. }
  134. </script>
  135.  
  136. <script>
  137. function closedialog() {
  138. var dialog = document.getElementById('login_dialog');
  139.  
  140. dialog.close();
  141.  
  142. }
  143. function addSession() {
  144. window.location.replace("Allocate_login.php");
  145.  
  146. }
  147.  
  148. </script>
  149. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/>
  150. <link rel="stylesheet" type="text/css" href="../css/inputallocation.css" />
  151. </head>
  152.  
  153. <?php
  154. $show_warning = false;
  155. $studentdetails1 = mysql_query(" SELECT Student_First_Name, Student_Last_Name, Student_Poly_Id FROM Student ORDER BY Student_Last_Name");
  156. while ($studentdetails2 = mysql_fetch_array($studentdetails1)) {
  157. $studentFirstName[] = $studentdetails2[Student_First_Name];
  158. $studentLastName[] = $studentdetails2[Student_Last_Name];
  159. $studentPolyId[] = $studentdetails2[Student_Poly_Id];
  160. }
  161.  
  162. $no = count($studentPolyId);
  163.  
  164. for ($i = 0; $i < $no; $i++) {
  165. $studentName[] = $studentLastName[$i].
  166. " ".$studentFirstName[$i];
  167.  
  168. }
  169.  
  170. $tutorDetails1 = mysql_query(" SELECT `Tutor_First_Name`, `Tutor_Last_Name`, `Tutor_Poly_Id` FROM Tutor ORDER BY Tutor_Last_Name ");
  171. while ($tutorDetails2 = mysql_fetch_array($tutorDetails1)) {
  172. $tutorFirstName[] = $tutorDetails2[Tutor_First_Name];
  173. $tutorLastName[] = $tutorDetails2[Tutor_Last_Name];
  174. $tutorPolyId[] = $tutorDetails2[Tutor_Poly_Id];
  175. }
  176. $no1 = count($tutorPolyId);
  177.  
  178. for ($a = 0; $a < $no1; $a++) {
  179. $tutorName[] = $tutorLastName[$a].
  180. " ".$tutorFirstName[$a];
  181. }
  182. ?>
  183.  
  184. <?php
  185.  
  186. if (isset($_POST["Submit"])) {
  187.  
  188. $query = mysql_Query("DELETE FROM `Student_Tutor_Assignment` WHERE Date='0000-00-00'");
  189. $Sname = $_POST["Sname"];
  190. $SSname = $_POST["SSname"];
  191. $Tname = $_POST["Tname"];
  192. $Esub = $_POST["Esub"];
  193. $SessionTime = $_POST["SessionTime"];
  194. $SessionType = $_POST["SessionType"];
  195. $startconvo1 = $_POST["startdate"];
  196. $startconvo2 = strtotime($startconvo1);
  197. $SessionStart = date('Y-m-d', $startconvo2);
  198. $endconvo1 = $_POST["enddate"];
  199. $endconvo2 = strtotime($endconvo1);
  200. $SessionEnd = date('Y-m-d', $endconvo2);
  201. $subject = $_POST["Sub"];
  202. $dateToday =date("Y-m-d");
  203.  
  204. $studentnames1 = mysql_query("SELECT `Student_First_Name`, `Student_Last_Name`, Student_Email FROM Student WHERE Student_Poly_Id = '$Sname' ");
  205. $studentnames2 = mysql_fetch_array($studentnames1);
  206. $studentnamesfn = $studentnames2[Student_First_Name];
  207. $studentnamesln = $studentnames2[Student_Last_Name];
  208.  
  209. $tutornames1 = mysql_query("SELECT `Tutor_First_Name`, `Tutor_Last_Name`,`Tutor_Hours` , Tutor_Email FROM Tutor WHERE Tutor_Poly_Id = '$Tname' ");
  210. $tutornames2 = mysql_fetch_array($tutornames1);
  211. $tutornamesfn = $tutornames2[Tutor_First_Name];
  212. $tutornamesln = $tutornames2[Tutor_Last_Name];
  213. $tutorhours = $tutornames2[Tutor_Hours];
  214.  
  215.  
  216. $d = mysql_query("SELECT DAYOFWEEK('$SessionStart')");
  217. $d1 = mysql_fetch_array($d);
  218. $d2 = $d1[0];
  219.  
  220. $diffweek = abs(strtotime($SessionStart) - strtotime($SessionEnd)) / 604800;
  221. $number = intval($diffweek);
  222. //echo $number;
  223.  
  224. if ($Sname == "---SELECT---") {
  225. $A = "Please Select A Student";
  226. }
  227. elseif($Tname == "---SELECT---") {
  228. $A = "Please Select A Tutor";
  229. }
  230.  
  231. elseif($SessionTime == "---SELECT---") {
  232. $A = "Please Select A Session Time";
  233. }
  234. elseif($SessionStart == "") {
  235. $A = "Please Select The Session Start Date";
  236. }
  237. elseif($SessionEnd == "") {
  238. $A = "Please Select The Session End Date";
  239. } else {
  240.  
  241. //$checksession1 = mysql_query("SELECT * FROM Student_Tutor_Allocation_Main WHERE `Student_Poly_Id` = '$Sname' AND `Tutor_Poly_Id`='$Tname' AND `Subject`='$subject' AND `Session_End_Date`>= '$SessionStart' AND(Time = '$SessionTime' AND Day = '$d2') ");
  242. $checksession1 = mysql_query("SELECT * FROM Student_Tutor_Assignment WHERE `Student_Poly_Id` = '$Sname' AND `Tutor_Poly_Id`='$Tname' AND `Subject_Id`= '$subject' AND `Date` BETWEEN '$SessionStart' AND '$SessionEnd' AND `Session_Time` = '$SessionTime' AND `Day` = '$d2' AND `Student_Type` !='C' AND `Tutor_Type`!='C' ");
  243. $checksession2 = mysql_fetch_array($checksession1);
  244. $checksession = $checksession2[Allocate_Id];
  245.  
  246. //$checksessionTutor = mysql_query("SELECT * FROM Student_Tutor_Allocation_Main WHERE `Tutor_Poly_Id`='$Tname' AND `Session_End_Date`>= '$SessionStart' AND (Time = '$SessionTime' AND Day = '$d2')");
  247. $checksessionTutor = mysql_query("SELECT * FROM Student_Tutor_Assignment WHERE `Tutor_Poly_Id`='$Tname' AND `Date` BETWEEN '$SessionStart' AND '$SessionEnd' AND `Session_Time` = '$SessionTime' AND Day = '$d2' AND `Student_Type` !='C' AND `Tutor_Type`!='C'");
  248. $checksessionTutorArr = mysql_fetch_array($checksessionTutor);
  249. $checksessionTutorFlag = $checksessionTutorArr[Allocate_Id];
  250.  
  251. //$checksessionStudent = mysql_query("SELECT * FROM Student_Tutor_Allocation_Main WHERE `Student_Poly_Id` = '$Sname' AND `Session_End_Date`>= '$SessionStart' AND (Time = '$SessionTime' AND Day = '$d2')");
  252. $checksessionStudent = mysql_query("SELECT * FROM Student_Tutor_Assignment WHERE `Student_Poly_Id` = '$Sname' AND `Date` BETWEEN '$SessionStart' AND '$SessionEnd' AND `Session_Time` = '$SessionTime' AND Day = '$d2' AND `Student_Type` !='C' AND `Tutor_Type`!='C'");
  253. $checksessionStudentArr = mysql_fetch_array($checksessionStudent);
  254. $checksessionStudentFlag = $checksessionStudentArr[Allocate_Id];
  255.  
  256. //$checksessionTutorSt = mysql_query("SELECT * FROM Student_Tutor_Allocation_Main WHERE `Tutor_Poly_Id`='$Sname' AND `Session_End_Date`>= '$SessionStart' AND (Time = '$SessionTime' AND Day = '$d2')");
  257. $checksessionTutorSt = mysql_query("SELECT * FROM Student_Tutor_Assignment WHERE `Tutor_Poly_Id`='$Sname' AND `Date` BETWEEN '$SessionStart' AND '$SessionEnd' AND Session_Time = '$SessionTime' AND Day = '$d2' AND `Student_Type` !='C' AND `Tutor_Type`!='C'");
  258. $checksessionTutorStArr = mysql_fetch_array($checksessionTutorSt);
  259. $checksessionTutorStFlag = $checksessionTutorStArr[Allocate_Id];
  260.  
  261. //$checksessionStudentTu = mysql_query("SELECT * FROM Student_Tutor_Allocation_Main WHERE `Student_Poly_Id` = '$Tname' AND `Session_End_Date`>= '$SessionStart' AND (Time = '$SessionTime' AND Day = '$d2')");
  262. $checksessionStudentTu = mysql_query("SELECT * FROM Student_Tutor_Assignment WHERE `Student_Poly_Id` = '$Tname' AND `Date` BETWEEN '$SessionStart' AND '$SessionEnd' AND Session_Time = '$SessionTime' AND Day = '$d2' AND `Student_Type` !='C' AND `Tutor_Type`!='C' ");
  263. $checksessionStudentTuArr = mysql_fetch_array($checksessionStudentTu);
  264. $checksessionStudentTuFlag = $checksessionStudentTuArr[Allocate_Id];
  265.  
  266. $flag = true;
  267.  
  268. if ($checksession != 0) {
  269. $A = "&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbspThis Session Already Exists";
  270. $flag =false;
  271. }
  272. elseif($checksessionTutorFlag != 0) {
  273. //$A = "Another session exists for selected Tutor on the same day and time";
  274.  
  275. //To add double session feature
  276. $doubleSession = mysql_query("SELECT COUNT(DISTINCT Student_Poly_Id) AS studentCount FROM Student_Tutor_Assignment WHERE `Tutor_Poly_Id`='$Tname' AND `Date` BETWEEN '$SessionStart' AND '$SessionEnd' AND `Session_Time` = '$SessionTime' AND Day = '$d2' AND `Student_Type` !='C' AND `Tutor_Type`!='C'");
  277. $doubleSessionArr = mysql_fetch_array($doubleSession);
  278. $doubleSessionFlag = $doubleSessionArr[studentCount];
  279. //to check the count of students in this session
  280. if ($doubleSessionFlag>1){
  281. $A = "Sorry, this session already has two students";
  282. $flag =false;
  283. }else{
  284. $confirmSubject = mysql_query("SELECT Subject_Id FROM Student_Tutor_Assignment WHERE `Tutor_Poly_Id`='$Tname' AND `Date` BETWEEN '$SessionStart' AND '$SessionEnd' AND `Session_Time` = '$SessionTime' AND Day = '$d2' AND `Student_Type` !='C' AND `Tutor_Type`!='C'");
  285. $confirmSubjectArr = mysql_fetch_array($confirmSubject);
  286. $confirmSubjectFlag = $confirmSubjectArr[Subject_Id];
  287. if($subject != $confirmSubjectFlag){
  288. $A = "Tutor teaches another subject on the same day and time";
  289. $flag =false;
  290. }else{
  291. echo "<script type='text/javascript'>
  292. var answer = confirm('Session entered by you will be a Double Session.Please confirm if you want this session');
  293. if (answer == false){
  294. window.location('Allocate.php');
  295. }
  296. </script>";
  297. $flag = true;
  298. }
  299. }
  300. }
  301. elseif($checksessionStudentFlag != 0) {
  302. $A = "Another session exists for selected Student on the same day and time";
  303. $flag =false;
  304. }
  305. elseif($checksessionTutorStFlag != 0) {
  306. $A = "Another session exists for selected Student as Tutor on the same day and time";
  307. $flag =false;
  308. }
  309. elseif($checksessionStudentTuFlag != 0) {
  310. $A = "Another session exists for selected Tutor as Student on the same day and time";
  311. $flag =false;
  312.  
  313. else{
  314. if($SessionType != 'A')
  315. {
  316. //check for the available space
  317. //$previous_key = date($key);
  318. $time = strtotime($SessionTime);
  319. $time = $time - (30 * 60);
  320. $previous_key = date("H:i:s", $time);
  321.  
  322. //$next_key = date($key);
  323. $time = strtotime($SessionTime);
  324. $time = $time + (30 * 60);
  325. $next_key = date("H:i:s", $time);
  326.  
  327. $spacequery = "
  328. select current_session,previous_session,next_session
  329. from (
  330.  
  331. select count(*) as current_session
  332. from
  333. ( select * from Student_Tutor_Assignment
  334. where date between '$SessionStart' and '$SessionEnd'
  335. and day = $d2
  336. and Session_Time = '$SessionTime'
  337. group by Tutor_Poly_Id,Session_Time
  338. )a
  339.  
  340. )b,
  341.  
  342.  
  343. (
  344. select count(*) as previous_session
  345. from
  346. ( select * from Student_Tutor_Assignment
  347. where date between '$SessionStart' and '$SessionEnd'
  348. and day = $d2
  349. and Session_Time = '$previous_key'
  350. group by Tutor_Poly_Id,Session_Time
  351. )a
  352. )c,
  353.  
  354.  
  355. (
  356. select count(*) as next_session
  357. from
  358. ( select * from Student_Tutor_Assignment
  359. where date between '$SessionStart' and '$SessionEnd'
  360. and day = $d2
  361. and Session_Time = '$next_key'
  362. group by Tutor_Poly_Id,Session_Time
  363. )a
  364.  
  365. )d
  366. ;
  367.  
  368. ";
  369. $availablespace = mysql_query($spacequery);
  370. //print_r($availablespace);
  371. $result_data = mysql_fetch_assoc($availablespace);
  372. //print_r($result_data);
  373. if($result_data["current_session"]){
  374. $current_session = $result_data["current_session"];
  375. }else{
  376. $current_session = 0;
  377. }
  378. if($result_data["previous_session"]){
  379. $previous_session = $result_data["previous_session"];
  380. }else{
  381. $previous_session = 0;
  382. }
  383. if($result_data["next_session"]){
  384. $next_session = $result_data["next_session"];
  385. }else{
  386. $next_session = 0;
  387. }
  388. $total_previous = $current_session + $previous_session;
  389. $total_after = $current_session + $next_session;
  390. $availablespacecount = 11;
  391. $max_count = max( $total_previous , $total_after );
  392. $availablespacecount = $availablespacecount - ( max( $total_previous , $total_after ) );
  393. //echo "<br>".$availablespacecount;
  394. //echo "<br> max_count ".$max_count;
  395.  
  396. if($availablespacecount <= 0)
  397. {
  398. //new code
  399. //Override the Maximum Space Capacity Reached if the login user has semester refresh access
  400. //Fetch the access for the login user
  401. $login_user_id = $_SESSION['userid'];
  402. $accessquery = "SELECT * FROM Admin_LogIn where Username = '$login_user_id' and SemRefreshAccess = 1";
  403. $result_accessquery = mysql_query($accessquery);
  404. if (mysql_num_rows($result_accessquery)==0)
  405. {
  406. $A = "Maximum space capacity reached. Please select another time slot";
  407. $show_warning = true;
  408. $flag = false;
  409.  
  410. }
  411. else
  412. {
  413.  
  414. $access_detail = mysql_fetch_assoc($result_accessquery);
  415. $show_override_dialog = False;
  416. if($access_detail['SemRefreshAccess'] == 1)
  417. {
  418. $show_override_dialog = True;
  419.  
  420. $flag = false;
  421. }
  422. }
  423.  
  424.  
  425.  
  426. // new code
  427.  
  428.  
  429. ?>
  430.  
  431. <?php
  432. }
  433.  
  434. }
  435. }
  436. if ($flag == true){
  437. $insert = mysql_query("INSERT INTO `Student_Tutor_Allocation_Main`(`Student_Poly_Id`, `Student_First_Name`, `Student_Last_Name`, `Tutor_Poly_Id`, `Tutor_First_Name`, `Tutor_Last_Name`, `Subject`, `Time`, `Day`, `Session_Start_Date`, `Session_End_Date`) VALUES ('$Sname', '$studentnamesfn', '$studentnamesln', '$Tname', '$tutornamesfn', '$tutornamesln', '$subject', '$SessionTime', '$d2', '$SessionStart', '$SessionEnd' )");
  438.  
  439. $allocateid1 = mysql_query("SELECT Allocate_Id FROM Student_Tutor_Allocation_Main WHERE Student_Poly_Id = '$Sname' AND (Time = '$SessionTime' AND Day = '$d2') ");
  440. $allocateid2 = mysql_fetch_array($allocateid1);
  441. $allocateid = $allocateid2[0];
  442.  
  443. if ($insert) {
  444. $query2 = mysql_query("SELECT * FROM Student WHERE Student_Poly_Id = '$Sname'");
  445. $query3 = mysql_fetch_array($query2);
  446. $sub1 = $query3[Subject_1];
  447. $sub2 = $query3[Subject_2];
  448. $sub3 = $query3[Subject_3];
  449. $sub4 = $query3[Subject_4];
  450. $sub5 = $query3[Subject_5];
  451. $sub6 = $query3[Subject_6];
  452. if ($sub1 == 0) {
  453. $subinsert = mysql_query("UPDATE Student SET Subject_1 = '$subject' WHERE Student_Poly_Id = '$Sname'");
  454. //break;
  455. }
  456. elseif($sub2 == 0) {
  457. $subinsert = mysql_query("UPDATE Student SET Subject_2 = '$subject' WHERE Student_Poly_Id = '$Sname'");
  458. //break;
  459. }
  460. elseif($sub3 == 0) {
  461. $subinsert = mysql_query("UPDATE Student SET Subject_3 = '$subject' WHERE Student_Poly_Id = '$Sname'");
  462. //break;
  463. }
  464. elseif($sub4 == 0) {
  465. $subinsert = mysql_query("UPDATE Student SET Subject_4 = '$subject' WHERE Student_Poly_Id = '$Sname'");
  466. //break;
  467. }
  468. elseif($sub5 == 0) {
  469. $subinsert = mysql_query("UPDATE Student SET Subject_5 = '$subject' WHERE Student_Poly_Id = '$Sname'");
  470. //break;
  471. }
  472. elseif($sub6 == 0) {
  473. $subinsert = mysql_query("UPDATE Student SET Subject_6 = '$subject' WHERE Student_Poly_Id = '$Sname'");
  474. //break;
  475. } else {
  476. //$A = "The student is allocated to 6 subjects";
  477. //break;
  478. }
  479.  
  480. $r = get_days($SessionStart, $SessionEnd);
  481. $emailflag = false;
  482. for ($i = 0; $i <= $number + 1; $i++) {
  483. $newday1 = mysql_query("SELECT DAYOFWEEK('$r[$i]')");
  484. $newday2 = mysql_fetch_array($newday1);
  485. $newday = $newday2[0];
  486. $query = mysql_query("INSERT INTO `Student_Tutor_Assignment`(`Allocate_Id`,`Student_Poly_Id`, `Tutor_Poly_Id`, `Subject_Id`, `Session_Time`, `Date`, `Day`,`Session_Type`) VALUES ('$allocateid', '$Sname', '$Tname', '$subject', '$SessionTime', '$r[$i]', '$newday','$SessionType') ");
  487.  
  488. if ($query) {
  489. $emailflag = true;
  490. $B = "Session Allocated and Assigned. Please enter another or exit";
  491.  
  492. } else {
  493. $A = "Session Allocated But Not Assigned. Please enter another or exit";
  494. }
  495. }
  496.  
  497. if($emailflag == true){
  498. $subjectquery = mysql_query("select Subject from Subject where Subject_Id = $subject");
  499. $subjectname = mysql_fetch_array($subjectquery);
  500. $mailtimestamp = date("F j, Y, g:i a");
  501.  
  502. $to = $tutornames2[Tutor_Email].",".$studentnames2[Student_Email].",".'fitltech@nyu.edu,jb3372@nyu.edu,trionyupoly@gmail.com,pb494@nyu.edu,srl446@nyu.edu';
  503.  
  504. $subjectEmail = 'TRIO​ Scholars​ Tutoring ​Schedule​ for '. $subjectname[Subject];
  505. $sessionbegindate = date('l,F j, Y', $startconvo2);
  506. $sessionenddate = date('l,F j, Y', $endconvo2);
  507.  
  508. $sessionemailtime = date('g:i a', strtotime($SessionTime));
  509. $message = "Below please find your tutoring schedule for ". $subjectname[Subject]." \r\n Tutor : $tutornames2[Tutor_First_Name] $tutornames2[Tutor_Last_Name] \r\n Student : $studentnames2[Student_First_Name] $studentnames2[Student_Last_Name] \r\n Subject : $subjectname[Subject] \r\n Time : $sessionemailtime \r\n Start Date : $sessionbegindate \r\n End Date : $sessionenddate \r\nAll tutoring sessions will take place in the TRIO Scholars Office (LC253). If you have any questions about your tutoring schedule, please contact the TRIO Scholars Office at 646-997-3560.\r\n​Thank you,\r\nTRIO Scholars Program\r\n​[$mailtimestamp]\r\n";
  510. $headers = 'From: TRIO Program <trionyupoly@gmail.com>' . "\r\n";
  511. mail($to, $subjectEmail, $message, $headers, '-f trionyupoly@gmail.com');
  512. }
  513. } else {
  514. $A = "Session not Allocated";
  515. }
  516. }
  517. }
  518.  
  519. }
  520.  
  521. if (isset($_POST["back"])) {
  522. $url = "Selectfunction.php";
  523. header("Location:$url");
  524. }
  525. ?>
  526.  
  527.  
  528. <body>
  529.  
  530. <div id="container">
  531. <div class="menu">
  532. <ul>
  533. <li><a class="hide" href="">INPUT</a>
  534. <ul>
  535. <li><a href="CreateT.php">Tutor Information</a></li>
  536. <li><a href="CreateS.php">Student Information</a></li>
  537. <li><a href="Allocate.php">Student-Tutor Allocation</a></li>
  538. <li><a href="Course.php">Course Information</a></li>
  539. </ul>
  540. </li>
  541. <li><a class="hide" href="">EDIT</a>
  542. <ul>
  543. <li><a href="EditTutor.php">Tutor Information</a></li>
  544. <li><a href="EditStudent.php">Student Information</a></li>
  545. <li><a class="EditSession.php">Student-Tutor Allocation ></a>
  546.  
  547. <ul>
  548. <li><a href="EditOneSession.php">Session Type</a></li>
  549. <li><a class="EditSession.php">Session Schedule ></a>
  550. <ul>
  551. <li><a href="EditSingleSession.php">Edit Single Session</a></li>
  552. <li><a href="EditMultipleSession.php">Edit Multiple Sessions</a></li>
  553. </ul>
  554. </li>
  555. </ul>
  556. <!-- End -->
  557. </li>
  558. <li><a href="EditCourse.php">Course Information</a></li>
  559. </ul>
  560. </li>
  561. <li><a class="hide" href="">REPORT</a>
  562. <ul>
  563. <li><a href="number_of_sessions.php">Available Spaces</a></li>
  564. <li><a href="number_of_session_type.php">Session Type</a></li>
  565. <li><a href="SessionByDays.php">Attendance Report</a></li>
  566. <li><a href="SessionByType.php">By Session Type</a></li>
  567. <li><a href="SessionByGroup.php">By Group</a></li>
  568. <li><a class="EditSession.php">Subject ></a>
  569. <ul>
  570. <li><a href="number_of_subject.php">Data Overview</a></li>
  571. <li><a href="SessionBySubject.php">Subject Data</a></li>
  572. </ul>
  573. </li>
  574. <li><a href="semesterEndReport.php">Semester End Report</a></li>
  575. </ul>
  576. </li>
  577. <li><a class="hide" href="">APPROVALS/CHANGES</a>
  578. <ul>
  579. <li><a href="StudentBlock.php">Student Block/Unblock</a></li>
  580. <li><a href="TutorBlock.php">Tutor Block/Unblock</a></li>
  581. <li><a href="SessionDrop.php">Drop Session</a></li>
  582. </ul>
  583. </li>
  584. <li><a class="hide" href="">DATA MANAGEMENT</a>
  585. <ul>
  586. <li><a href="#">Save ></a>
  587. <ul>
  588. <li><a href="SaveStudent.php">Student</a></li>
  589. <li><a href="SaveTutor.php">Tutor</a></li>
  590. </ul>
  591. </li>
  592. <li><a href="#">Bulk Changes > </a>
  593. <ul>
  594. <li><a href="bulkstudent.php">Student</a></li>
  595. <li><a href="bulktutor.php">Tutor</a></li>
  596. </ul>
  597. </li>
  598. <li><a href="refresh.php">New Semester Refresh</a></li>
  599. <li><a href="#">Delete ></a>
  600. <ul>
  601. <li><a href="DeleteS_Nav.php">Student</a></li>
  602. <li><a href="DeleteT_Nav.php">Tutor</a></li>
  603. </ul>
  604. </li>
  605. </ul>
  606. </li>
  607. <li><a class="hide" href=" ">ACCOUNT MANAGEMENT</a>
  608. <ul>
  609. <li><a class="hide">Email ></a>
  610. <ul>
  611. <li><a href="EditEmail.php">Change Email Address</a></li>
  612. <li><a href="EditSubject.php">Change Email Subject</a></li>
  613. <li><a href="EditContext.php">Change Email Content</a></li>
  614. </ul>
  615. </li>
  616. <li><a href="AccountManagement.php">Password</a></li>
  617. </ul>
  618. </li>
  619. <li><a class="hide" href="livereport.php">LIVE REPORT</a></li>
  620. </ul>
  621. </div>
  622. <div id="banner"><img src="../images/banner2.png" width="1022" height="150" border="none"/></div>
  623. <div id="line"></div>
  624. <div id="signout"><img src="../images/adminlogin.png" width="17" height="15" border="none" /></div>
  625. <div id="text3"><a href="Adminlogon.php"><p>Sign Out</p></a></div>
  626. <div id="text2"><p>Input Student-Tutor Allocation</p></div>
  627. <div id="mainbody"></div>
  628. <div id="save"></div>
  629. <div id="inputboxbackground"></div>
  630. <form id = "myForm" name = "myForm" action = "Allocate.php" onsubmit="return validateForm()" method = "post">
  631. <br>
  632. <label for="name">Session Type :</label>
  633. <select name = "SessionType">
  634. <option>---SELECT---</option>
  635. <option value= " ">Regular</option>
  636. <option value= "E">Extra</option>
  637. <option value = "F">Flexible</option>
  638. <option value = "A">Add-On</option>
  639. </select>
  640. <br>
  641. <label for="name">Student Name :</label>
  642. <select name = "Sname">
  643. <option>---SELECT---</option>
  644. <?php
  645. for($j=0;$j<$no; $j++){
  646. echo "<option value=$studentPolyId[$j]>$studentName[$j]</option>";
  647. }
  648. ?>
  649. </select>
  650. </br>
  651. <label for="name">Tutor Name :</label>
  652. <select name = "Tname" onChange="showUser(this.value)">
  653. <option>---SELECT---</option>
  654. <?php
  655. for($b=0;$b<$no1;$b++){
  656. echo "<option value=$tutorPolyId[$b]>$tutorName[$b]</option>";
  657. }
  658. ?>
  659. </select>
  660. </br>
  661. <table border="0" style="width:100%">
  662. <tr>
  663. <td>Subject:&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp</td>
  664. <td><div id ="txtHint"></div></td>
  665. </tr>
  666. </table>
  667. <label for="name">Session Time :</label>
  668. <select name="SessionTime">
  669. <option>---SELECT---</option>
  670. <option value = "09:00:00">09:00 AM</option>
  671. <option value = "09:30:00">09:30 AM</option>
  672. <option value = "10:00:00">10:00 AM</option>
  673. <option value = "10:30:00">10:30 AM</option>
  674. <option value = "11:00:00">11:00 AM</option>
  675. <option value = "11:30:00">11:30 AM</option>
  676. <option value = "12:00:00">12:00 PM</option>
  677. <option value = "12:30:00">12:30 PM</option>
  678. <option value = "13:00:00">1:00 PM</option>
  679. <option value = "13:30:00">1:30 PM</option>
  680. <option value = "14:00:00">2:00 PM</option>
  681. <option value = "14:30:00">2:30 PM</option>
  682. <option value = "15:00:00">3:00 PM</option>
  683. <option value = "15:30:00">3:30 PM</option>
  684. <option value = "16:00:00">4:00 PM</option>
  685. <option value = "16:30:00">4:30 PM</option>
  686. <option value = "17:00:00">5:00 PM</option>
  687. <option value = "17:30:00">5:30 PM</option>
  688. <option value = "18:00:00">6:00 PM</option>
  689. <option value = "18:30:00">6:30 PM</option>
  690. <option value = "19:00:00">7:00 PM</option>
  691. </select>
  692. </br>
  693. <!-- change class to ID, use the Jquery , Two datepicker(one is datepicker, the other is datepicker2-->
  694. <label for="name">Session Start Date :</label>
  695. <input type="text" placeholder="Start date" id="datepicker" name="startdate">
  696. </br>
  697. <label for="name">Session End Date :</label>
  698. <input type="text" id="datepicker2" name="enddate" placeholder ="End Date">
  699. </br>
  700. </br>
  701. <center> <button type="submit" name="Submit"><img src="../images/save.png" width="102" height="28" border="none"/></a></button></center>
  702. <div class = "mesg1"><span width='100px' id="mesg1_span"><center><?php echo "$A";?></center></span></div>
  703. <div class = "mesg2"> <?php echo "$B" ;?> </div>
  704. </br>
  705. </form>
  706.  
  707.  
  708.  
  709.  
  710. <?php
  711.  
  712. if($show_override_dialog)
  713. {
  714. ?>
  715.  
  716.  
  717. <script type='text/javascript'>
  718.  
  719.  
  720. if (confirm("Sorry, no cubicles are available at that time.\nClick Cancel to select another time, or click OK to Continue Allocation.") == true) {
  721.  
  722.  
  723. var data = {
  724. Student_Poly_Id : "<?php echo (string)$Sname;?>",
  725. Student_First_Name : "<?php echo (string)$studentnamesfn;?>",
  726. Student_Last_Name : "<?php echo (string)$studentnamesln;?>",
  727. Tutor_Poly_Id : "<?php echo (string)$Tname;?>",
  728. Tutor_First_Name : "<?php echo (string)$tutornamesfn;?>",
  729. Tutor_Last_Name : "<?php echo (string)$tutornamesln;?>",
  730. Subject : "<?php echo (string)$subject;?>",
  731. Time : "<?php echo (string)$SessionTime;?>",
  732. Day : "<?php echo (string)$d2;?>",
  733. Session_Start_Date : "<?php echo (string)$SessionStart;?>",
  734. Session_End_Date : "<?php echo (string)$SessionEnd;?>",
  735. SessionType : "<?php echo (string)$SessionType;?>",
  736. override : true
  737. }
  738.  
  739.  
  740.  
  741. $.ajax({
  742. type: 'POST',
  743. url: "allocation_override.php",
  744. data: data,
  745. success: function(data, status){
  746.  
  747. document.getElementById("mesg1_span").textContent="Session Allocated and Assigned. Please enter another or exit";
  748. document.getElementById("mesg1_span").style.color = "#0000FF";
  749.  
  750. },
  751.  
  752. async:false
  753. });
  754. }
  755. else{
  756. document.getElementById("mesg1_span").textContent="Session Allocation has been cancelled. Please enter another or exit";
  757. }
  758.  
  759. </script>
  760. <?php
  761.  
  762. }
  763. ?>
  764.  
  765. </body>
  766. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!