<?php  
$page_title = 'Import Alumini';
include 'header.php';
?>
<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-6">
										<div class="form-group">
											<label for="exampleInputFile">Upload Excel File</label>
											<a href="downloads/alumini_upload.csv" download="alumini_upload.csv">CSV Format File Format</a>
											<div class="input-group">
												<div class="custom-file">
													<input type="file" class="custom-file-input fileUpload_allow_csv" 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($_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];
				$admitted_year = $emapData[1];
				$passing_year = $emapData[2];
				$roll_number = $emapData[3];
				$college_name = $emapData[4];
				$course = $emapData[5];
				$mobile_number = $emapData[6];
				$email = $emapData[7];
				$address = $emapData[8];
				$current_occupation = $emapData[9];
				
				$college_id = 0;
				if($college_name != '') {
				    $sel_clg = mysqli_query($con, "select id from college where name like '%$college_name%'");
				    while($row_clg = mysqli_fetch_array($sel_clg)) {
				        $college_id = $row_clg['id'];
				    }
				}
				
				if($college_id == 0 || $college_id == "0") {
				    $ins = mysqli_query($con,"INSERT INTO `college` (`id`, `name`) VALUES (NULL, '$college_name')");
				    $sel_clg = mysqli_query($con, "select id from college where name like '%$college_name%'");
				    while($row_clg = mysqli_fetch_array($sel_clg)) {
				        $college_id = $row_clg['id'];
				    }
				}
				
				$ins = mysqli_query($con,"INSERT INTO `alumini` (`id`, `name`, `admitted_year`, `passing_year`, `roll_number`, `college_id`, `course`, `mobile_number`, `email`, `address`, `current_occupation`) VALUES (NULL, '$name', '$admitted_year', '$passing_year', '$roll_number', '$college_id', '$course', '$mobile_number', '$email', '$address', '$current_occupation')");
				if($ins)
				{
					$students=$students+1;
				}
			}
			$row_count = $row_count + 1;
		}

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

}
?>