Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include 'session.php';
- ?>
- <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
- <html xmlns="http://www.w3.org/1999/xhtml">
- <head>
- <!-- Title -->
- <title>UiTM e-Class Reservation</title>
- <!-- General meta information -->
- <meta name="keywords" content="" />
- <meta name="description" content="" />
- <meta name="robots" content="index, follow" />
- <meta charset="utf-8" />
- <!-- Load JavaScript -->
- <script type="text/javascript" src="js/jquery.1.4.2.js"></script>
- <script type="text/javascript" src="js/jsDatePick.jquery.min.1.3.js"></script>
- <script type="text/javascript">
- window.onload = function(){
- g_globalObject = new JsDatePick({
- useMode:1,
- isStripped:true,
- target:"div3_example"
- /*selectedDate:{ This is an example of what the full configuration offers.
- day:5, For full documentation about these settings please see the full version of the code.
- month:9,
- year:2006
- },
- yearsRange:[1978,2020],
- limitToToday:false,
- cellColorScheme:"beige",
- dateFormat:"%m-%d-%Y",
- imgPath:"img/",
- weekStartDay:1*/
- });
- g_globalObject.setOnSelectedDelegate(function(){
- var obj = g_globalObject.getSelectedDay();
- alert("a date was just selected and the date is : " + obj.day + "/" + obj.month + "/" + obj.year);
- document.getElementById("div3_example_result").innerHTML = obj.day + "/" + obj.month + "/" + obj.year;
- });
- g_globalObject2 = new JsDatePick({
- useMode:1,
- isStripped:false,
- target:"div4_example",
- cellColorScheme:"beige"
- /*selectedDate:{ This is an example of what the full configuration offers.
- day:5, For full documentation about these settings please see the full version of the code.
- month:9,
- year:2006
- },
- yearsRange:[1978,2020],
- limitToToday:false,
- dateFormat:"%m-%d-%Y",
- imgPath:"img/",
- weekStartDay:1*/
- });
- g_globalObject2.setOnSelectedDelegate(function(){
- var obj = g_globalObject2.getSelectedDay();
- alert("a date was just selected and the date is : " + obj.day + "/" + obj.month + "/" + obj.year);
- document.getElementById("div3_example_result").innerHTML = obj.day + "/" + obj.month + "/" + obj.year;
- });
- };
- </script>
- <!-- Load stylesheet -->
- <link rel="stylesheet" type="text/css" href="style/main.css" title="style" />
- <link rel="stylesheet" type="text/css" href="style/reg_res.css" title="style" />
- <link rel="stylesheet" type="text/css" href="style/view.css" title="style" />
- <link rel="stylesheet" type="text/css" media="all" href="css/jsDatePick_ltr.min.css" />
- <!-- Load icon -->
- <link rel="icon" type="image/ico" href="images/uitm.ico">
- </head>
- <body>
- <!-- start main -->
- <div id="main">
- <!-- start header -->
- <div id="header">
- <?php include 'header.html' ?>
- <br>
- <!-- start menubar -->
- <div id="menubar">
- <!-- start cssmenu -->
- <div id='cssmenu'>
- <ul>
- <?php include 'main_menu.html' ?>
- </ul>
- </div>
- <!-- end cssmenu -->
- </div>
- <!-- end menubar -->
- <!-- start site_content -->
- <div id="site_content">
- <!-- start sidebar -->
- <div class="sidebar">
- <?php include 'sidebar.html' ?>
- </div>
- <!-- end sidebar -->
- <!-- start content -->
- <div id="content">
- <!-- start wrapper -->
- <div id="wrapper">
- <form method="post" action="reserve_proc.php">
- <div class="CSSTableGenerator" >
- <?php
- include 'db.php';
- $username = $_POST['username'];
- $matrix = $_POST['matrix_no'];
- $email = $_POST['email'];
- $phone = $_POST['phone'];
- $day = $_POST['alternate'];
- $start = $_POST['start_time'];
- $end = $_POST['end_time'];
- $dif = $end - $start;
- $block = $_POST['block'];
- $purpose = $_POST['purpose'];
- $date = $_POST['datepicker'];
- $sub_class[] = '';
- $sub_start[] = '';
- $sub_end[] = '';
- echo "<input type='hidden' name='username' value='$username'>";
- echo "<input type='hidden' name='matrix_no' value='$matrix'>";
- echo "<input type='hidden' name='email' value='$email'>";
- echo "<input type='hidden' name='phone' value='$phone'>";
- echo "<input type='hidden' name='datepicker' value='$date'>";
- echo "<input type='hidden' name='start_time' value='$start'>";
- echo "<input type='hidden' name='end_time' value='$end'>";
- echo "<input type='hidden' name='alternate' value='$day'>";
- echo "<input type='hidden' name='block' value='$block'>";
- echo "<input type='hidden' name='purpose' value='$purpose'>";
- $sql = "SELECT *
- FROM `class_timetable`
- WHERE `day` = '".$day."'
- AND `status` = 'AVAILABLE'
- AND `block_code` = ".$block."
- AND (`time_class` >= ".$start." AND `time_class` < ".$end.")";
- /*Pilih kelas dari class_timetable yang AVAILABLE, dan block code yg sama dan time_class yang sama dan lebih dari start dan juga time_class kurang daripada end. */
- $select_class = mysql_query($sql);
- print "<table border='1'>
- <tr>
- <td>
- No.
- </td>
- <td>
- Class
- </td>
- <td>
- Time
- </td>
- <td>
- Status
- </td>
- <td>
- </td>
- </tr>";
- $no = 1;
- $class = 0;
- $comp = 1;
- $data = 0; // if no data found it will display "no class can be reserved at that time."
- $bef_class;
- $comp_class;
- while($row = mysql_fetch_array($select_class)) {
- $sel_class = $row['class']; /* class yang available*/
- $time = $row['time_class']; /* masa mula kelas*/
- $time1 = $row['time_class']+1;/* masa habis kelas dengan ditambah 1 */
- $status = $row['status']; /*status kelas iaitu AVAILABLE*/
- $sql_res = "SELECT * FROM `reservation`";
- $available = 'true';
- $select_res = mysql_query($sql_res);
- while($row_res = mysql_fetch_array($select_res)) {
- $day_res = $row_res['day']; /*day diambil dari table reservation*/
- $start_res = $row_res['start_time']; /*start time diambil dari table reservation*/
- $end_res = $row_res['end_time'];/*end time diambil dari table reservation*/
- $class_res = $row_res['class'];/*class diambil dari table reservation*/
- $date_res = $row_res['date'];/*date diambil dari table reservation*/
- $status_res = $row_res['status'];/*status diambil dari table reservation(UNKNOWN/REJECT/APPROVED)*/
- if(($sel_class == $class_res) && /*bandingkan kelas dari table class_timetable dengan reservation*/
- ($start >= $start_res) && /*bandingkan masa start iaitu input dari user dan start_res dari reservation*/
- ($end <= $end_res) && /*bandingkan masa end iaitu input dari user dan end_res dari reservation*/
- ($day == $day_res) && /*bandingkan day iaitu input dari user dan day_res dari reservation*/
- ($date == $date_res) && /*bandingkan date iaituinput dari user dan date_res dari reservation*/
- (($status_res == 'APPROVED') || ($status_res == 'UNKNOWN'))) /*status_res APPROVED atau UNKNOWN*/
- {//if statement ini digunakan untuk membuang kelas jika kesemua statement tersebut betul
- if(($time >= $start_res) && ($time <= $end_res)) {
- $available = 'false';
- break;
- }
- else {
- $available = 'true';
- }
- }
- else if(($sel_class == $class_res) && /*bandingkan kelas dari table class_timetable dengan reservation*/
- ($start < $start_res) && /*bandingkan masa start iaitu input dari user dan start_res dari reservation*/
- (($end <= $end_res) &&($end != $start_res)) && /*bandingkan masa end iaitu input dari user dan end_res dari reservation*/
- ($day == $day_res) && /*bandingkan day iaitu input dari user dan day_res dari reservation*/
- ($date == $date_res) && /*bandingkan date iaituinput dari user dan date_res dari reservation*/
- (($status_res == 'APPROVED') || ($status_res == 'UNKNOWN'))) /*status_res APPROVED atau UNKNOWN*/
- {//if statement ini digunakan untuk membuang kelas jika kesemua statement tersebut betul
- if(($time >= $start_res) && ($time <= $end_res)) {
- $available = 'false';
- break;
- }
- else {
- $available = 'true';
- }
- }
- else if(($sel_class == $class_res) && /*bandingkan kelas dari table class_timetable dengan reservation*/
- (($start >= $start_res) && ($start != $end_res)) && /*bandingkan masa start iaitu input dari user dan start_res dari reservation*/
- ($end > $end_res) && /*bandingkan masa end iaitu input dari user dan end_res dari reservation*/
- ($day == $day_res) && /*bandingkan day iaitu input dari user dan day_res dari reservation*/
- ($date == $date_res) && /*bandingkan date iaituinput dari user dan date_res dari reservation*/
- (($status_res == 'APPROVED') || ($status_res == 'UNKNOWN'))) /*status_res APPROVED atau UNKNOWN*/
- {//if statement ini digunakan untuk membuang kelas jika kesemua statement tersebut betul
- if(($time >= $start_res) && ($time <= $end_res)) {
- $available = 'false';
- break;
- }
- else {
- $available = 'true';
- }
- }
- else if(($sel_class == $class_res) && /*bandingkan kelas dari table class_timetable dengan reservation*/
- ($start < $start_res) && /*bandingkan masa start iaitu input dari user dan start_res dari reservation*/
- (($end >= $end_res) &&($end != $start_res)) && /*bandingkan masa end iaitu input dari user dan end_res dari reservation*/
- ($day == $day_res) && /*bandingkan day iaitu input dari user dan day_res dari reservation*/
- ($date == $date_res) && /*bandingkan date iaituinput dari user dan date_res dari reservation*/
- (($status_res == 'APPROVED') || ($status_res == 'UNKNOWN'))) /*status_res APPROVED atau UNKNOWN*/
- {//if statement ini digunakan untuk membuang kelas jika kesemua statement tersebut betul
- if(($time >= $start_res) && ($time <= $end_res)) {
- $available = 'false';
- break;
- }
- else {
- $available = 'true';
- }
- }
- else if(($sel_class == $class_res) && /*bandingkan kelas dari table class_timetable dengan reservation*/
- (($start <= $start_res) && ($start != $end_res)) && /*bandingkan masa start iaitu input dari user dan start_res dari reservation*/
- ($end > $end_res) && /*bandingkan masa end iaitu input dari user dan end_res dari reservation*/
- ($day == $day_res) && /*bandingkan day iaitu input dari user dan day_res dari reservation*/
- ($date == $date_res) && /*bandingkan date iaituinput dari user dan date_res dari reservation*/
- (($status_res == 'APPROVED') || ($status_res == 'UNKNOWN'))) /*status_res APPROVED atau UNKNOWN*/
- {//if statement ini digunakan untuk membuang kelas jika kesemua statement tersebut betul
- if(($time >= $start_res) && ($time <= $end_res)) {
- $available = 'false';
- break;
- }
- else {
- $available = 'true';
- }
- }
- else {
- $available = 'true';
- }
- }
- if ($available == 'true') {
- $comp_class = $sel_class;
- if($comp == 1) {
- $bef_class = $comp_class;
- $class++;
- $comp=2;
- }
- else if($bef_class == $sel_class) {
- $class++;
- $bef_class = $sel_class;
- }
- else {
- $class = 1;
- $comp = 1;
- $bef_class = $comp_class;
- }
- if($class == $dif) {
- $comp = 1;
- $sub_class[$no] = $sel_class;
- $sub_start[$no] = $start;
- $sub_end[$no] = $end;
- print "
- <tr>
- <td>
- <input type='hidden' name='no' value='$no'>
- $no
- </td>
- <td>
- <input type='hidden' name='class".$no."' value='$sel_class'>
- $sel_class
- </td>
- <td>
- <input type='hidden' name='start".$no."' value='$start'>
- <input type='hidden' name='end".$no."' value='$end'>
- $start:00 - $end:00
- </td>
- <td>
- AVAILABLE
- </td>
- <td>
- <input type='submit' value='Reserve' name='submit".$no."'>
- </td>
- </tr>";
- $no++;
- $class = 0;
- $data=1;
- }
- }
- }
- if($data == 0) {
- print "<tr>
- <td colspan='5'>
- No class can be reserved at that time.
- </td>
- </tr>";
- }
- print "
- </table>
- <input type='button' name='back' value='Back!' onclick='windows:location=\"reserve_class.php\"' style='width:127px'/>";
- for($x = 1; $x < $no; $x++) {
- if(isset($_POST['submit'.$x.''])) {
- $submit = $_POST['submit'.$x.''];
- if($submit == 'Reserve') {
- $no_sub = $_POST['no'];
- $class_sub = $_POST['class'.$x.''];
- $start_sub = $_POST['start'.$x.''];
- $end_sub = $_POST['end'.$x.''];
- mysql_query("INSERT INTO reservation (`username`,`matrix_no`,`email`,`day`,`start_time`,`end_time`,`class`,`date`,`block_code`,`status`,`date_reservation`,`purpose`,`phone`) VALUES('$username','$matrix','$email','$day','$start_sub','$end_sub','$class_sub','$date','$block','UNKNOWN',CURRENT_TIMESTAMP,'$purpose','$phone');");
- mysql_query("INSERT INTO admin_reservation (`username`,`matrix_no`,`email`,`day`,`start_time`,`end_time`,`class`,`date`,`block_code`,`status`,`date_reservation`,`purpose`,`phone`) VALUES('$username','$matrix','$email','$day','$start_sub','$end_sub','$class_sub','$date','$block','UNKNOWN',CURRENT_TIMESTAMP,'$purpose','$phone');");
- echo '<script>alert("Reservation Complete");window.location="reserve_class.php"</script>';
- }
- }
- }
- ?>
- </div>
- <!-- end ClassTableGenerator -->
- </form>
- </div>
- <!-- end wrapper -->
- </div>
- <!-- end content -->
- </div>
- <!-- end site_content -->
- <?php include 'footer.html' ?>
- </div>
- <!-- header -->
- </div>
- <!-- end main -->
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement