<?php require_once('header.php'); ?>

<?php
if (isset($_POST['form1'])) {
	$valid = 1;
	$error_message = '';

	if (empty($_POST['title'])) {
		$valid = 0;
		$error_message .= "Title cannot be empty.<br>";
	}

	if ($valid == 1) {
		// Use the current case-study ID for the filename
		$time = time();

		if (empty($_FILES['banner']['name'])) {
			$bfinal_name = $_POST['obanner'];
		} else {
			$bpath = $_FILES['banner']['name'];
			$bpath_tmp = $_FILES['banner']['tmp_name'];
			if ($bpath != '') {
				$bext = pathinfo($bpath, PATHINFO_EXTENSION);
				$bfile_name = basename($bpath, '.' . $bext);
				if (!in_array($bext, ['jpg', 'jpeg', 'png', 'gif', 'webp'])) {
					$valid = 0;
					$error_message .= 'You must have to upload jpg, jpeg, gif, webp, or png file<br>';
				}
			}
			if ($valid == 1) {
				$bfinal_name = 'case-study-' . $time . '.' . $bext;
				move_uploaded_file($bpath_tmp, 'assets/images/case-study-image/' . $bfinal_name);
				unlink('assets/images/case-study-image/' . $_POST['existing_remove']);
			}
		}


		if ($valid == 1) {
			$statement = $pdo->prepare("UPDATE case_study SET name=?, short_description=?, description=?, status=?, slug=?, banner=?, meta_title=?, keywords=?, meta_description=? WHERE id=?");
			$statement->execute(array($_POST['title'], $_POST['sdesc'], $_POST['desc'], $_POST['status'], $_POST['slug'], $bfinal_name, $_POST['mtitle'], $_POST['mkey'], $_POST['mdesc'], $_REQUEST['id']));
			$success_message = 'case-study updated successfully.';
		}
	}
}

if (!isset($_REQUEST['id'])) {
	header('location: logout.php');
	exit;
} else {
	$statement = $pdo->prepare("SELECT * FROM case_study WHERE id=?");
	$statement->execute(array($_REQUEST['id']));
	$total = $statement->rowCount();
	$result = $statement->fetchAll(PDO::FETCH_ASSOC);
	if ($total == 0) {
		header('location: logout.php');
		exit;
	}
}

foreach ($result as $row) {
	$name = $row['name'];
	$sdesc = $row['short_description'];
	$desc = $row['description'];
	$slug = $row['slug'];
	$status = $row['status'];
	$mtitle = $row['meta_title'];
	$mkey = $row['keywords'];
	$mdesc = $row['meta_description'];
	$banner = $row['banner'];
}

?>
<section class="content-header">
	<div class="content-header-left">
		<h1>Add case-study</h1>
	</div>
	<div class="content-header-right">
		<a href="case-study.php" class="btn btn-primary btn-sm">View All</a>
	</div>
</section>


<section class="content">

	<div class="row">
		<div class="col-md-12">

			<?php if ($error_message): ?>
				<div class="callout callout-danger">

					<p>
						<?php echo $error_message; ?>
					</p>
				</div>
			<?php endif; ?>

			<?php if ($success_message): ?>
				<div class="callout callout-success">

					<p><?php echo $success_message; ?></p>
				</div>
			<?php endif; ?>

			<form class="form-horizontal" action="" method="post" enctype="multipart/form-data">

				<div class="box box-info">
					<div class="box-body">
						<input type="text" hidden name="existing_remove" value="<?php echo $banner ?>">
						<div class="form-group">
							<label for="" class="col-sm-3 control-label">Status<span>*</span></label>
							<div class="col-sm-4">
								<select name="status" class="form-control select2" style="width:auto;">
									<option value="0" <?php if ($status == '0') {
															echo 'selected';
														} ?>>Deactivate</option>
									<option value="1" <?php if ($status == '1') {
															echo 'selected';
														} ?>>Active</option>
								</select>
							</div>
						</div>
						<div class="form-group">
							<label for="" class="col-sm-2 control-label">Existing Image</label>
							<div class="col-sm-9" style="padding-top:5px">
								<img src="assets/images/case-study-image/<?php echo $row['banner'];; ?>" alt="case-study Image" style="width:400px;">
							</div>
						</div>
						<div class="form-group">
							<label for="" class="col-sm-3 control-label">Image<span>*</span></label>
							<div class="col-sm-4">
								<input type="file" class="form-control" name="banner">
								<input type="hidden" class="form-control" value="<?php echo $banner; ?>" name="obanner">
							</div>
						</div>


						<div class="form-group">
							<label for="" class="col-sm-3 control-label">Title <span>*</span></label>
							<div class="col-sm-4">
								<input type="text" class="form-control" value="<?php echo $name; ?>" name="title">
							</div>
						</div>
						<div class="form-group">
							<label for="" class="col-sm-3 control-label">Short Description <span>*</span></label>
							<div class="col-sm-4">
								<textarea type="text" class="form-control" rows="5" cols="30" name="sdesc"><?php echo $sdesc; ?></textarea>
							</div>
						</div>
						<div class="form-group">
							<label for="" class="col-sm-3 control-label">Description <span>*</span></label>
							<div class="col-sm-8">
								<textarea type="text" class="form-control" id="editor1" cols="30" rows="10" name="desc"><?php echo $desc; ?></textarea>
							</div>
						</div>
						<div class="form-group">
							<label for="" class="col-sm-3 control-label">Slug<span>*</span></label>
							<div class="col-sm-4">
								<input type="text" class="form-control" value="<?php echo $slug; ?>" required name="slug">
							</div>
						</div>
						<div class="form-group">
							<label for="" class="col-sm-3 control-label">Meta Title <span>*</span></label>
							<div class="col-sm-4">
								<input type="text" class="form-control" value="<?php echo $mtitle; ?>" name="mtitle">
							</div>
						</div>
						<div class="form-group">
							<label for="" class="col-sm-3 control-label">Meta Keyword <span>*</span></label>
							<div class="col-sm-4">
								<textarea type="text" class="form-control" rows="5" name="mkey"><?php echo $mkey; ?></textarea>
							</div>
						</div>
						<div class="form-group">
							<label for="" class="col-sm-3 control-label">Meta Description <span>*</span></label>
							<div class="col-sm-4">
								<textarea type="text" class="form-control" rows="5" name="mdesc"><?php echo $mdesc; ?></textarea>
							</div>
						</div>
						<div class="form-group">
							<label for="" class="col-sm-3 control-label"></label>
							<div class="col-sm-6">
								<button type="submit" class="btn btn-success pull-left" name="form1">Submit</button>
							</div>
						</div>
					</div>
				</div>

			</form>


		</div>
	</div>

</section>

<?php require_once('footer.php'); ?>