new-ticket.php

<?
include 'header.php';
include 'connect.php';
include 'date-time-class.php';

$Real_Name_List = mysql_query("select Real_Name from users");
$Category_List = mysql_query("select Name from category");

?>

<script>
	// wait for the DOM to be loaded 
	$(document).ready(function() { 
		// bind 'myForm' and provide a simple callback function 
		$('#myForm').ajaxForm(function() { 
			Messenger().post({
			  message: 'Successful Created',
			});
			setTimeout(function() {
			  window.location.href = "index.php";
			}, 2000);
		}); 
	}); 	
</script>


 
	 <div class="container">
	 
	 <div class="panel panel-default">
	 <div class="panel-body">


		<form id="myForm" action="ticket-process.php" method="post" class="form-horizontal">
		<legend>New Ticket</legend>
		
		<div class="row">
		
		<!-- Text input-->
		<div class="col-sm-4">
		<div class="control-group">
		  <label class="control-label" for="Report_No">Report No</label>
		  <div class="controls">
			<input id="Report_No" name="Report_No" value="<? echo $Report_Date ; ?>" placeholder="" class="form-control input-lg" type="text">
			<p class="help-block">Auto Generate</p>
		  </div>
		</div>
		</div>
		
		<!-- Text input-->
		<div class="col-sm-4">
		<div class="control-group">
		  <label class="control-label" for="Ticket_Create_Date">Date</label>
		  <div class="controls">
			<input id="Ticket_Create_Date" name="Ticket_Create_Date" value="<? echo $Ticket_Date ; ?>" placeholder="" class="form-control input-lg" type="text">
			<p class="help-block">Auto Generate</p>
		  </div>
		</div>
		</div>
		
		<!-- Text input-->
		<div class="col-sm-4">
		<div class="control-group">
		  <label class="control-label" for="Ticket_Create_Time">Time</label>
		  <div class="controls">
			<input id="Ticket_Create_Time" name="Ticket_Create_Time" value="<? echo $Ticket_Time; ?>" placeholder="" class="form-control input-lg" type="text">
			<p class="help-block">Auto Generate</p>
		  </div>
		</div>
		</div>
		
	</div><!-- ROW END -->

	<div class="row">
		
		<!-- Text input-->
		<div class="col-sm-6">
		<div class="control-group">
		  <label class="control-label" for="Requester_Name">Requester Name</label>
		  <div class="controls">
			<input id="Requester_Name" name="Requester_Name" value="<? echo $Requester_Name ; ?>" placeholder="" class="form-control input-lg" type="text">
		  </div>
		</div>
		</div>
		
		<!-- Text input-->
		<div class="col-sm-6">
		<div class="control-group">
		  <label class="control-label" for="Requester_Email">Requester Email</label>
		  <div class="controls">
			<input id="Requester_Email" name="Requester_Email" value="<? echo $Requester_Email ; ?>" placeholder="" class="form-control input-lg" type="text">
		  </div>
		</div>
		</div>
		
	</div><!-- ROW END -->
		
		<div class="row">
			<!-- Select Basic -->
			<div class="col-md-12">
			<div class="control-group">
			  <label class="control-label" for="Ticket_title">Ticket title</label>
			  <div class="controls">
				<input id="$Ticket_title" name="Ticket_title" value="<? echo $Ticket_title ; ?>" placeholder="" class="form-control input-lg" type="text">
			  </div>
			</div>
			</div>
			</div><!-- ROW END -->
			
		<div class="row">
		<!-- Select Basic -->
		<div class="col-md-4">
		<div class="control-group">
		  <label class="control-label" for="Location_Building">Building</label>
		  <div class="controls">
			<select id="Location_Building" name="Location_Building" class="form-control input-lg">
			  <option>COMJ-M</option>
			  <option>COMJ-F</option>
			  <option>CSCJ</option>
			  <option>CAMSJ-M</option>
			  <option>CAMSJ-F</option>
			</select>
		  </div>
		</div></div>
		
		<!-- Text input-->
		<div class="col-md-4">
		<div class="control-group">
		  <label class="control-label" for="Location_Room_No">Room No</label>
		  <div class="controls">
			<input id="Location_Room_No" name="Location_Room_No" placeholder="" class="form-control input-lg" type="text">
		
		  </div>
		</div></div>
		
		<!-- Select Basic -->
		<div class="col-md-4">
		<div class="control-group">
		  <label class="control-label" for="Location_Floor">Floor</label>
		  <div class="controls">
			<select id="Location_Floor" name="Location_Floor" class="form-control input-lg">
			  <option>Ground</option>
			  <option>First</option>
			  <option>Second</option>
			  <option>Third</option>
			  <option>Fourth</option>
			</select>
		  </div>
		</div></div>
		
		</div><!-- ROW END -->
		
		<div class="row">
		<!-- Textarea -->
		<div class="col-md-12">
		<div class="control-group">
		  <label class="control-label" for="Service_Description">Service Description</label>
		  <div class="controls">                     
			<textarea class="form-control input-lg" rows="3" id="Service_Description" name="Service_Description">Details ...</textarea>
		  </div>
		</div></div>
		
		</div><!-- ROW END -->
		
		<div class="row">
		<!-- Text input-->
		<div class="col-md-6">
		<div class="control-group">
		  <label class="control-label" for="Engineer_Name">Engineer's Name</label>
		  <div class="controls">
			<select id="Engineer_Name" name="Engineer_Name" class="form-control input-lg">
				
				<? while($row = mysql_fetch_array($Real_Name_List)){ ?>
					<option><? echo $row['Real_Name']; ?></option>
			 	<? } ?>
			</select>
		
		  </div>
		</div></div>
		
		<!-- Text input-->
		<div class="col-md-6">
		<div class="control-group">
		  <label class="control-label" for="Engineer_Badge_No">Ticket Category</label>
		  <div class="controls">
			<select id="Ticket_Category" name="Ticket_Category" class="form-control input-lg">
				<? while($row2 = mysql_fetch_array($Category_List)){ ?>
						<option><? echo $row2['Name']; ?></option>
				 	<? } ?>
			</select>
		  </div>
		</div></div>
		
		
		</div><!-- ROW END -->
		
		
		<div class="row">
			<!-- Text input-->
			<div class="col-md-12">
				<div class="control-group">
					<label class="control-label"></label>
		<div class="controls">
				<button id="sub" type="submit" class="btn btn-primary">Create</button>
			
		
			</div></div></div>
		
		
				</div><!-- ROW END -->
		
	</form>

		
		
	        	</div>
        </div>
      </div>
		
	 <!-- /.container -->


	<!-- Load JS here for greater good =============================-->
	<script src="js/bootstrap.js"></script>
	<script src="js/bootstrap.min.js"></script>




</body>
</html>