<?php  
$page_title = 'Student List';
include 'header.php';
$agent_id = $userData['id'];
$role = $userData['user_type'];
?>
<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="student-list-update.php" method="POST" enctype="multipart/form-data">
							<div class="card-body">
								<div class="row">
									<?php 
									if($role == "1")
									{
										?>
										<div class="col-md-4">
											<div class="form-group">
												<label>School</label>
												<select class="form-control school_id select2" name="school_id" required>
													<option value="">--Select--</option>
													<?php
													$sel_school=mysqli_query($con,"select * from users where agent_id = $agent_id and user_type=2 order by id desc");
													while($row_school=mysqli_fetch_array($sel_school))
													{
														?>
														<option value="<?php echo $row_school['id']; ?>"><?php echo $row_school['name']; ?></option>
														<?php
													}
													?>
												</select>
											</div>
										</div>
										<?php
									}
									?>
									<div class="col-md-4">
										<div class="form-group">
											<label>Class</label>
											<select class="form-control class" name="class">
												<option value="">--Select--</option>
											</select>
										</div>
									</div>
									<div class="col-md-4">
										<div class="form-group">
											<label>Division</label>
											<select class="form-control division" name="division">
												<option value="">--Select--</option>
											</select>
										</div>
									</div>
									<div class="col-lg-4">
										<div class="form-group">
											<label>Update 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
												}
												?>
												<option>photos_path</option>
											</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'; ?>
<script type="text/javascript">
	$(".school_id").change(function(){
		let school_id = $(this).val();
		$(".division").html("<option value=''>--Select--</option>");
		$(".class").html("<option value=''>--Select--</option>");
		if(school_id != "")
		{
			$.ajax({
				type : "POST",
				url : "get-class-division.php",
				data : {school_id:school_id},
				beforeSend : function() {

				},
				success : function(response) {
					let res = JSON.parse(response);
					$(".division").html(res['division_data']);
					$(".class").html(res['class_data']);
				}
			});
		}
	});
</script>

<?php if($role != "1") { ?>
<script type="text/javascript">
	$.ajax({
		type : "POST",
		url : "get-class-division.php",
		data : {school_id:<?php echo $agent_id; ?>},
		beforeSend : function() {

		},
		success : function(response) {
			let res = JSON.parse(response);
			$(".division").html(res['division_data']);
			$(".class").html(res['class_data']);
		}
	});
</script>
<?php } ?>