<?php  
$page_title = 'Import Members';
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="" 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 for="exampleInputFile">Upload Excel File</label>
											<a href="downloads/members_upload.csv" download="members_upload.csv">CSV Format File Format</a>
											<div class="input-group">
												<div class="custom-file">
													<input type="file" class="custom-file-input" name="upload_format" accept=".csv" id="exampleInputFile" required>
													<label class="custom-file-label" for="exampleInputFile">Choose file</label>
												</div>
											</div>
										</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']))
{
	$filename=$_FILES["upload_format"]["tmp_name"];

	if($role == "1")
	{
		$school_id = $_POST['school_id'];	
	}
	else
	{
		$school_id = $agent_id;
	}

	if($_FILES["upload_format"]["size"] > 0)
	{
		$file = fopen($filename, "r");
		$students=0;
		$row_count=0;
		while (($emapData = fgetcsv($file, 10000, ",")) !== FALSE)
		{
			if($row_count>0)
			{
				$name = $emapData[0];
				$father_name = $emapData[1];
				$roll_number = $emapData[2];
				$reg_no = $emapData[3];
				$dob = null;
				if($emapData[4] != '') {
				    $dob = date("Y-m-d", strtotime($emapData[4]));
				}
				$blood_group = $emapData[5];
				$address = $emapData[6];
				$designation = $emapData[7];
				$phone = $emapData[8];
				$gender = $emapData[9];
				if($emapData[10] == "")
				{
					$location = "dist/img/avatar5.png";
				}
				else
				{
					$location = $emapData[10];	
				}
				$adhar_no = $emapData[11];
				$section = $emapData[12];
				$place = $emapData[13];
				$taluka = $emapData[14];
				$district = $emapData[15];
				$state = $emapData[16];
				$country = $emapData[17];
				$pin_code = $emapData[18];
				$members_ship_amount = $emapData[19];
				$application_fees = $emapData[20];
				$type_member = $emapData[21];
				$whatsapp_num = $emapData[22];
				$email = $emapData[23];
				$members_style = $emapData[24];
				$expiry_date = null;
				if($emapData[25] != '') {
				    $expiry_date = date("Y-m-d", strtotime($emapData[25]));
				}
				$age = $emapData[26];
				$education = $emapData[27];
				$profession = $emapData[28];
				
				$ins = mysqli_query($con,"INSERT INTO `students`(`name`, `father_name`, `school_id`, `roll_number`, `reg_no`, `dob`, `blood_group`, `address`, `designation`, `phone`, `gender`, `photos`, `adhar_no`, `section`, `place`, `taluka`, `district`, `state`, `country`, `pin_code`, `members_ship_amount`, `application_fees`, `type_member`, `whatsapp_num`, `email`, `members_style`, `expiry_date`, `age`, `education`, `profession`, `updated_by`) VALUES ('$name', '$father_name', '$school_id', '$roll_number', '$reg_no', '$dob', '$blood_group', '$address', '$designation', '$phone', '$gender', '$location', '$adhar_no', '$section', '$place', '$taluka', '$district', '$state', '$country', '$pin_code', '$members_ship_amount', '$application_fees', '$type_member', '$whatsapp_num', '$email', '$members_style', '$expiry_date', '$age', '$education', '$profession', '$agent_id')");
				if($ins)
				{
					$students=$students+1;
				}
			}
			$row_count = $row_count + 1;
		}

		if($students>0)
		{
			$_SESSION['success_msg'] = $students.' students are imported...';
			echo"<script>window.location='import-students.php';</script>";
		}
		else
		{
			$_SESSION['error_msg'] = 'Unable to import students...';
			echo"<script>window.location='import-students.php';</script>";
		}
	}
	else
	{
		$_SESSION['error_msg'] = 'Have not data in uploaded file...';
		echo"<script>window.location='import-students.php';</script>";
	}

}
?>