<?php  
$page_title = 'Add Document';
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-4">
										<div class="form-group">
											<label>Category</label>
											<input type="text" class="form-control" autocomplete="off" name="category" list="category" required />
											<datalist id="category">
												<?php 
												$sql_cat=mysqli_query($con,"select DISTINCT category from documents where category!='' order by id desc");
												while($row_cat=mysqli_fetch_array($sql_cat))
												{
													?>
													<option value="<?php echo $row_cat['category']; ?>">
														<?php
													}
													?>
												</datalist>
											</div>
										</div>
										<div class="col-md-4">
											<div class="form-group">
												<label>Title</label>
												<input type="text" class="form-control" name="title" />
											</div>
										</div>
									</div>
									<div class="row">
										<div class="col-md-12">
											<div class="form-group">
												<label>Description</label>
												<textarea class="text_editor" name="description">
												</textarea>
											</div>
										</div>
									</div>
									<div class="row">
										<div class="col-md-8">
											<div class="form-group">
												<label for="exampleInputFile">Document File</label>
												<div class="input-group">
													<div class="custom-file">
														<input type="file" class="custom-file-input fileUpload_allow_doc" name="document_photo" 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']))
	{
		$category = $_POST['category'];
		$title = $_POST['title'];
		$description = $_POST['description'];

		$fileinfo=PATHINFO($_FILES["document_photo"]["name"]);
		$newFilename="documents_". time()."." .$fileinfo['extension'];
		$location="uploads/documents/" . $newFilename;	

		$ins = mysqli_query($con,"INSERT INTO `documents` (`id`, `category`, `title`, `file`, `description`) VALUES (NULL, '$category', '$title', '$location', '$description')");

		if($ins)
		{
			move_uploaded_file($_FILES["document_photo"]["tmp_name"],$location);

			$_SESSION['success_msg'] = 'Documents has been added...';
			echo"<script>window.location='document.php';</script>";
		}
		else
		{
			$_SESSION['error_msg'] = 'Unable to add Documents...';
			echo"<script>window.location='document.php';</script>";
		}
	}
?>