<?php 
include("includes/db_config.php");

if (isset($_POST['submit'])) {
 //var_dump($_FILES);exit();
extract($_POST);
   
$sql="INSERT into promo_code(promo_code,discount) values ('$promo_code','$discount')";
//echo $sql; exit();
$res=mysqli_query($conn,$sql) or die(mysqli_error());
if($res)
{
 echo "<script>window.location.href='promo-code.php'</script>";
}
}
?>
<!DOCTYPE html>
<html lang="en-IN">
<head>
	<meta charset="utf-8">
	<meta http-equiv="X-UA-Compatible" content="IE=edge">
    <title>Orange Groceries</title>
	<meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
	<?php include("includes/css.php")?>
</head>
<body class="hold-transition skin-blue sidebar-mini">
	<div class="wrapper">
		<?php include("includes/header.php")?>
		<?php include("includes/sidebar.php")?>
		<!-- Content Wrapper. Contains page content -->
		<div class="content-wrapper">
			<!-- Content Header (Page header) -->
			<!-- Main content -->
			<section class="content">
				<div class="row">
					<div class="col-md-7">
						<div class="box box-danger">
							<div class="box-header with-border">
								<h3 class="box-title">Promo Code</h3>
							</div>
							<!-- /.box-header -->
							<div class="box-body table-responsive">
								<table class="table table-bordered example2">
									<thead>
										<tr>
											<th>S. No</th>
											<th>Promo Code</th>
											<th>% Discount</th>
											<!-- <th>Edit</th> -->
											<th>Delete</th>
										</tr>
									</thead>
									<tbody>

											<?php
									$sql="select * from promo_code";
									$result = mysqli_query($conn, $sql);

									 $j=1;// 8.Jh- Include pagination
									while($res= mysqli_fetch_array($result))// 7.Jh- Add loop to appling step 5 means selected coloumns 
									{ 
									?>
										<tr>
										    <td><?php echo $j; $j++; ?></td>
											<td><?php echo $res['promo_code']; ?></td> 
											<td><?php echo $res['discount']; ?></td> 
											<!-- <td>
												<a href="#" data-toggle="modal" data-target="#pcodeModal"><i class="fa fa-pencil-square"></i></a>  
											</td> -->
											<td><a href="javascript:delete_pr_by_ID('<?php echo $res['id']; ?>');" class="ask"><i class="fa fa-trash-o"></i></a></td>
										</tr>

									<?php } ?>
									</tbody>
								</table>
							</div>
							<!-- /.box-body -->
						</div>
					</div>
					<div class="col-md-5">
						<div class="box box-danger">
							<div class="box-header">
								<h3 class="box-title">Add New Promo Code</h3>
							</div>
							<div class="box-body">
								<form method="post" action="">
									<div class="form-group">
										<label>Promo Code :</label>
										<div class="input-group">
											<div class="input-group-addon">
												<i class="fa fa-suitcase"></i>
											</div>
											<input type="text" name="promo_code" class="form-control" placeholder="Enter Promo Code">
										</div>
									</div>
									<div class="form-group">
										<label>Promo Code % Rs.:</label>
										<div class="input-group">
											<div class="input-group-addon">
												<i class="fa fa-suitcase"></i>
											</div>
											<input type="text" name="discount" class="form-control" placeholder="Enter Promo Code Discount">
										</div>
									</div>
									<div class="form-group">
										<div class="input-group">
											<input type="submit" name="submit" class="btn btn-success btn-md" value="Submit">
										</div>
									</div>
								</form>
							</div>
							<!-- /.box-body -->
						</div>
					</div>
				</div>
				<!-- Modal Banner --> 
				<div class="modal fade" id="bannerModal" tabindex="-1" role="dialog" aria-labelledby="bannerModalLabel" aria-hidden="true">
					<div class="modal-dialog" role="document">
						<div class="modal-content">
							<div class="modal-header">
								<h3 class="modal-title" id="exampleModalLabel">Edit Promo Code</h3>
								<button type="button" class="close" data-dismiss="modal" aria-label="Close">
									<span aria-hidden="true">&times;</span>
								</button>
							</div>
							<div class="modal-body">
								<form method="post" action="banner.php">
									<div class="form-group">
										<label>Promo Code :</label>
										<div class="input-group">
											<div class="input-group-addon">
												<i class="fa fa-suitcase"></i>
											</div>
											<input type="text" class="form-control" placeholder="Enter Promo Code">
										</div>
									</div>
									<div class="form-group">
										<label>Promo Code % Rs.:</label>
										<div class="input-group">
											<div class="input-group-addon">
												<i class="fa fa-suitcase"></i>
											</div>
											<input type="text" class="form-control" placeholder="Enter Promo Code Discount">
										</div>
									</div>
								</form>
							</div>
							<div class="modal-footer">
								<button type="button" class="btn btn-success">Update</button>
								<button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
							</div>
						</div>
					</div>
				</div>
			<!-- ./Modal Banner -->
			</section>
		</div>
		<?php include("includes/footer.php")?>
	</div>
	<?php include("includes/js.php")?>
	<script>
		$(function() {
			$('#example1').DataTable()
			$('#example2').DataTable({
				'paging': true,
				'lengthChange': false,
				'searching': false,
				'ordering': true,
				'info': true,
				'autoWidth': false
			})
		})
        function delete_pr_by_ID(id)
		{
			if (confirm('Do You Want to Deleting This \nContinue anyway?')) {
				window.location.href = 'delete_promo.php?id=' + id;
			}
		}

	</script>
</body>

</html>
