<?php 
include ('includes/header.php');

//table name
$table_name = "menualuser";
$page = "adduser.php";

//table call
$res = $db->select($table_name, '*', '', '');

//update call
@$resU = $db->select($table_name, '*', 'id = :id', '', [':id' => $_GET['update']]);

if(isset($_POST['submitU'])){
	unset($_POST['submitU']);
	$updateData = $_POST;
	$db->update($table_name, $updateData, 'id = :id',[':id' => $_GET['update']]);
	echo "<script>window.location.href='".$page."?status=1'</script>";
}

//submit new
if (isset($_POST['submit'])){
	unset($_POST['submit']);
	$db->insert($table_name, $_POST);
	$db->close();
	echo "<script>window.location.href='".$page."?status=1'</script>";
}

//delete row
if(isset($_GET['delete'])){
	$db->delete($table_name, 'id = :id',[':id' => $_GET['delete']]);
	echo "<script>window.location.href='".$page."?status=2'</script>";
}

?>
<div class="modal fade" id="confirm-delete" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
	<div class="modal-dialog">
		<div class="modal-content" style="background-color: black;">
			<div class="modal-header">
				<h2 style="color: white;">Confirm</h2>
			</div>
			<div class="modal-body" style="color: white;">
				Do you really want to delete?
			</div>
			<div class="modal-footer">
				<button type="button" class="btn btn-primary" data-dismiss="modal">Cancel</button>
				<a style="color: white;" class="btn btn-danger btn-ok">Delete</a>
			</div>
		</div>
	</div>
</div>
<?php
if (isset($_GET['create'])){

//create form
?>

		<div class="col-md-12 mx-auto ctmain-table">
			<div class="card-body">
				<div class="card ctcard">
					<div class="card-header card-header-warning">
						<center>
							<h2><i class="icon icon-bullhorn"></i> Username Input</h2>
						</center>
					</div>			
					<div class="card-body">
						<div class="col-12">
							<h3>Add Username/Password</h3>
						</div>
							<form method="post">
								<div class="form-group ctinput">
									<label class="form-label " for="title">Title</label>
										<input class="form-control" id="description" name="title" placeholder="Title" type="text"/>
								</div>
								<div class="form-group ctinput">
									<label class="form-label " for="username">Username</label>
										<input class="form-control" id="description" name="username" placeholder="Username" type="text"/>
								</div>
                                <div class="form-group ctinput">
									<label class="form-label " for="password">Password</label>
										<input class="form-control" id="description" name="password" placeholder="Password" type="text"/>
								</div>
                                <div class="form-group ctinput">
									<label class="form-label " for="expire_date">Expire</label>
										<input class="form-control" id="description" name="expire_date" placeholder="Expire" type="date"/>
								</div>    
								<div class="form-group ctinput">
									<center>
										<button class="btn btn-info " name="submit" type="submit">
											<i class="icon icon-check"></i> Submit
										</button>
									</center>
								</div>
							</form>
					</div>
				</div>
			</div>
		</div>
<?php 
}else if (isset($_GET['update'])){ 

//update form
?>
		<div class="col-md-12 mx-auto ctmain-table">
			<div class="card-body">
				<div class="card ctcard">
					<div class="card-header card-header-warning">
						<center>
							<h2><i class="icon icon-bullhorn"></i> DNS & Username Input</h2>
						</center>
					</div>
					
					<div class="card-body">
						<div class="col-12">
							<h3>Edit DNS or Username/Password</h3>
						</div>
							<form method="post">
								<input type="hidden" name="id" value="<?=$_GET['update'] ?>">
								<div class="form-group ctinput">
									<label class="form-label " for="title">Title</label>
										<input class="form-control" id="description" name="title" placeholder="Title" value="<?=$resU[0]['title'] ?>" type="text"/>
								</div>
								<div class="form-group ctinput">
									<label class="form-label " for="username">Username</label>
										<input class="form-control" id="description" name="username" placeholder="Username" value="<?=$resU[0]['username'] ?>" type="text"/>
								</div>
                                <div class="form-group ctinput">
									<label class="form-label " for="password">Password</label>
										<input class="form-control" id="description" name="password" placeholder="Password" value="<?=$resU[0]['password'] ?>" type="text"/>
								</div>
                                <div class="form-group ctinput">
									<label class="form-label " for="expire_date">Expire</label>
										<input class="form-control" id="description" name="expire_date" placeholder="Expire" value="<?=$resU[0]['expire_date'] ?>" type="date"/>
								</div>
								<div class="form-group ctinput">
									<center>
										<button class="btn btn-info " name="submitU" type="submit">
											<i class="icon icon-check"></i> Submit
										</button>
									</center>
								</div>
							</form>
					</div>
				</div>
			</div>
		</div>
<?php
 }else{
//main table/form
	 ?>

		<div class="col-md-12 mx-auto ctmain-table">
			<div class="card-body">
				<div class="card ctcard">
					<div class="card-header card-header-warning">
						<center>
							<h2><i class="icon icon-commenting"></i> Current Users</h2>
						</center>
					</div>
					<div class="card-body" >
						<div class="col-12">
							<center>
								<a id="button" href="./<?=$page ?>?create" class="btn btn-info">New User</a>
							</center>
						</div>
						<br>
						<div class="table-responsive">
							<table class="table table-striped table-sm">
							<thead style="color:white!important">
								<tr>
									<th>Title</th>
									<th>Username</th>
     								<th>Password</th>
     								<th>Expire</th>
									<th>Edit&nbsp&nbsp&nbspDelete</th>
								</tr>
							</thead>
							<?php foreach ($res as $row) {
							?>
							<tbody>
								<tr>
									<td><?=$row['title'] ?></a></td>
									<td><?=$row['username'] ?></td>
                            		<td><?=$row['password'] ?></a></td>
									<td><?=$row['expire_date'] ?></td>
									<td>
									<a class="btn btn-info btn-ok" href="<?=$page ?>?update=<?=$row['id'] ?>"><i class="fa fa-pencil-square-o"></i></a>
									&nbsp&nbsp&nbsp
									<a class="btn btn-danger btn-ok" href="#" data-href="<?=$page ?>?delete=<?=$row['id'] ?>" data-toggle="modal" data-target="#confirm-delete"><i class="fa fa-trash-o"></i></a>
									</td>
								</tr>
							</tbody>
							<?php
							}?>
							</table>
						</div>
						</div>
					</div>
				</div>


	</div>
<?php }?>

<?php include ('includes/footer.php');?>

</body>
</html><?php 
include ('includes/header.php');

//table name
$table_name = "dns";
$page = "adduser.php";

//table call
$res = $db->select($table_name, '*', '', '');

//update call
@$resU = $db->select($table_name, '*', 'id = :id', '', [':id' => $_GET['update']]);

if(isset($_POST['submitU'])){
	unset($_POST['submitU']);
	$updateData = $_POST;
	$db->update($table_name, $updateData, 'id = :id',[':id' => $_GET['update']]);
	echo "<script>window.location.href='".$page."?status=1'</script>";
}

//submit new
if (isset($_POST['submit'])){
	unset($_POST['submit']);
	$db->insert($table_name, $_POST);
	$db->close();
	echo "<script>window.location.href='".$page."?status=1'</script>";
}

//delete row
if(isset($_GET['delete'])){
	$db->delete($table_name, 'id = :id',[':id' => $_GET['delete']]);
	echo "<script>window.location.href='".$page."?status=2'</script>";
}

?>
<div class="modal fade" id="confirm-delete" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
	<div class="modal-dialog">
		<div class="modal-content" style="background-color: black;">
			<div class="modal-header">
				<h2 style="color: white;">Confirm</h2>
			</div>
			<div class="modal-body" style="color: white;">
				Do you really want to delete?
			</div>
			<div class="modal-footer">
				<button type="button" class="btn btn-primary" data-dismiss="modal">Cancel</button>
				<a style="color: white;" class="btn btn-danger btn-ok">Delete</a>
			</div>
		</div>
	</div>
</div>
<?php
if (isset($_GET['create'])){

//create form
?>

		<div class="col-md-8 mx-auto">
			<div class="card-body">
				<div class="card bg-primary text-white">
					<div class="card-header card-header-warning">
						<center>
							<h2><i class="icon icon-bullhorn"></i> DNS & Username Input</h2>
						</center>
					</div>
					
					<div class="card-body">
						<div class="col-12">
							<h3>Add DNS or Username/Password</h3>
						</div>
							<form method="post">
								<div class="form-group">
									<label class="form-label " for="title">Title</label>
										<input class="form-control" id="description" name="title" placeholder="Title" type="text"/>
								</div>
								<div class="form-group">
									<label class="form-label " for="dns">DNS</label>
										<input class="form-control" id="description" name="url" placeholder="DNS" type="text"/>
								</div>
								<div class="form-group">
									<center>
										<button class="btn btn-info " name="submit" type="submit">
											<i class="icon icon-check"></i> Submit
										</button>
									</center>
								</div>
							</form>
					</div>
				</div>
			</div>
		</div>
<?php 
}else if (isset($_GET['update'])){ 

//update form
?>
		<div class="col-md-8 mx-auto">
			<div class="card-body">
				<div class="card bg-primary text-white">
					<div class="card-header card-header-warning">
						<center>
							<h2><i class="icon icon-bullhorn"></i> DNS & Username Input</h2>
						</center>
					</div>
					
					<div class="card-body">
						<div class="col-12">
							<h3>Edit DNS or Username/Password</h3>
						</div>
							<form method="post">
								<input type="hidden" name="id" value="<?=$_GET['update'] ?>">
								<div class="form-group">
									<label class="form-label " for="title">Title</label>
										<input class="form-control" id="description" name="title" placeholder="Title" value="<?=$resU[0]['title'] ?>" type="text"/>
								</div>
								<div class="form-group">
									<label class="form-label " for="dns">DNS</label>
										<input class="form-control" id="description" name="url" placeholder="DNS" value="<?=$resU[0]['url'] ?>" type="text"/>
								</div>
								<div class="form-group">
									<center>
										<button class="btn btn-info " name="submitU" type="submit">
											<i class="icon icon-check"></i> Submit
										</button>
									</center>
								</div>
							</form>
					</div>
				</div>
			</div>
		</div>
<?php
 }else{
//main table/form
	 ?>

		<div class="col-md-8 mx-auto">
			<div class="card-body">
				<div class="card bg-primary text-white">
					<div class="card-header card-header-warning">
						<center>
							<h2><i class="icon icon-commenting"></i> Current DNSs & Users</h2>
						</center>
					</div>
					<div class="card-body" >
						<div class="col-12">
							<center>
								<a id="button" href="./<?=$page ?>?create" class="btn btn-info">New DNS/User</a>
							</center>
						</div>
						<br>
						<div class="table-responsive">
							<table class="table table-striped table-sm">
							<thead style="color:white!important">
								<tr>
									<th>Title</th>
									<th>DNS</th>
									<th>Edit&nbsp&nbsp&nbspDelete</th>
								</tr>
							</thead>
							<?php foreach ($res as $row) {
							?>
							<tbody>
								<tr>
									<td><?=$row['title'] ?></a></td>
									<td><?=$row['url'] ?></td>
									<td>
									<a class="btn btn-info btn-ok" href="<?=$page ?>?update=<?=$row['id'] ?>"><i class="fa fa-pencil-square-o"></i></a>
									&nbsp&nbsp&nbsp
									<a class="btn btn-danger btn-ok" href="#" data-href="<?=$page ?>?delete=<?=$row['id'] ?>" data-toggle="modal" data-target="#confirm-delete"><i class="fa fa-trash-o"></i></a>
									</td>
								</tr>
							</tbody>
							<?php
							}?>
							</table>
						</div>
						</div>
					</div>
				</div>


	</div>
<?php }?>

<?php include ('includes/footer.php');?>

</body>
</html>