<?php  
$page_title = 'Add Institute';
include 'header.php';
if($userData['user_type'] != "1")
{
	echo"<script>alert('Unable to access this page...'); window.location='dashboard.php';</script>";
	exit;
}
?>
<div class="content-wrapper">
	<section class="content mt-4">
		<div class="container-fluid">
			<div class="row">
				<div class="col-md-12">
					<?php include('alert-msg.php'); ?>
					<div class="card card-primary">
						<div class="card-header">
							<h3 class="card-title"><?php echo $page_title; ?></h3>
						</div>
						<form action="" method="POST" enctype="multipart/form-data">
							<div class="card-body">
								<div class="row">
									<div class="col-md-4">
										<div class="form-group">
											<label>Name</label>
											<input type="text" class="form-control" name="name" required />
										</div>
									</div>
									<div class="col-md-4">
										<div class="form-group">
											<label>Username</label>
											<input type="text" class="form-control" name="username" required />
										</div>
									</div>
									<div class="col-md-4">
										<div class="form-group">
											<label>Password</label>
											<input type="text" class="form-control" name="password" required />
										</div>
									</div>
									<div class="col-lg-4">
										<div class="form-group">
											<label>Select Field</label>
											<select class="form-control"  name="fields[]" multiple size="8" required>
												<?php
												$sql = "SHOW COLUMNS FROM students where Field not in('id','created_at','updated_at','updated_by','school_id')";
												$result = mysqli_query($con,$sql);
												while($data = mysqli_fetch_array($result)) 		
												{
													?> 
													<option  value="<?php echo $data['Field']; ?>"><?php echo $data['Field']; ?></option>
													<?php
												}
												?>
											</select>
										</div>
									</div>
								</div>
								<button type="submit" class="btn btn-primary" name="btnSubmit">Submit</button>
							</div>
						</form>
					</div>
				</div>
			</div>
		</div>
	</section>
</div>
<?php include 'footer.php'; ?>

<?php
if(isset($_POST['btnSubmit']))
{
	$name = $_POST['name'];
	$username = $_POST['username'];
	$password = $_POST['password'];
	$agent_id = $userData['id'];
	$fields=$_POST['fields'];

	$ins = mysqli_query($con,"INSERT INTO `users` (`username`, `password`, `name`, `agent_id`, `is_active`, `user_type`) VALUES ('$username', '$password', '$name', '$agent_id', 1, 2)");
	if($ins)
	{
	    $inserted_id = mysqli_insert_id($con);
	    foreach($fields as $field)
	    {
	        mysqli_query($con,"INSERT INTO fields_list(school_id,field_name) VALUES ($inserted_id,'$field')");
	    }
		$_SESSION['success_msg'] = 'Institute has been added...';
		echo"<script>window.location='institute-add.php';</script>";
	}
	else
	{
		$_SESSION['error_msg'] = 'Unable to add Institute...';
		echo"<script>window.location='institute-add.php';</script>";
	}
}
?>