<?php  
$id=0;
if(isset($_GET['id']))
{
	$page_title = 'Edit Document';
	include 'header.php';
	$id = $_GET['id'];
	$sel=mysqli_query($con,"select * from documents where id=$id");
	while($row_documents=mysqli_fetch_array($sel))
	{
		?>
		<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-12">
												<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 value="<?php echo $row_documents['category']; ?>" />
															<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" value="<?php echo $row_documents['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">
																	<?php echo $row_documents['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">
																		<label class="custom-file-label" for="exampleInputFile">Choose file</label>
																	</div>
																</div>
															</div>
														</div>
														<div class="col-md-4">
															<div class="form-group">
																<label for="exampleInputFile">Document File</label>
																<br/>
																<a href="<?php echo $row_documents['file']; ?>" target="_blank"><i class="fas fa-file fa-3x"></i></a>
															</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
		}
		?>
		<?php include 'footer.php'; ?>
		<?php
	}
	else
	{
		session_start();
		$_SESSION['error_msg'] = 'Something wrong...';
		echo"<script>window.location='document-list.php';</script>";
	}
	?>


	<?php
	if(isset($_POST['btnSubmit']))
	{
		$category = $_POST['category'];
		$title = $_POST['title'];
		$description = $_POST['description'];

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

			$upd = mysqli_query($con,"UPDATE `documents`  SET category='$category', title='$title',  file='$location', description='$description' WHERE id=$id");

			if($upd)
			{
				move_uploaded_file($_FILES["document_photo"]["tmp_name"],$location);
				$_SESSION['success_msg'] = 'Document has been updated...';
				echo"<script>window.location='document-list.php';</script>";
			}
			else
			{
				$_SESSION['error_msg'] = 'Unable to update Document...';
				echo"<script>window.location='document-list.php';</script>";
			}
		}
		else
		{
			$upd = mysqli_query($con,"UPDATE `documents`  SET category='$category', title='$title', description='$description' WHERE id=$id");
			if($upd)
			{
				$_SESSION['success_msg'] = 'Document has been updated...';
				echo"<script>window.location='document-list.php';</script>";
			}
			else
			{
				$_SESSION['error_msg'] = 'Unable to update Document...';
				echo"<script>window.location='document-list.php';</script>";
			}
		}
	}
?>