<?php

session_start();

if (!isset($_SESSION['username'])) {

$_SESSION['msg'] = "You must log in first";

header('location: adminlogin.php');

}

if (isset($_GET['logout'])) {

session_destroy();

unset($_SESSION['username']);

header("location: adminlogin.php");

}

?>

<?php include('server.php') ?>

<html>

<!DOCTYPE html>

<head>

<!-- Required meta tags-->

<meta charset="UTF-8">

<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">

<meta name="description" content="Colorlib Templates">

<meta name="author" content="Colorlib">

<meta name="keywords" content="Colorlib Templates">

<!-- Title Page-->

<title>System Home page</title>

<!-- Icons font CSS-->

<link href="vendor/mdi-font/css/material-design-iconic-font.min.css" rel="stylesheet" media="all">

<link href="vendor/font-awesome-4.7/css/font-awesome.min.css" rel="stylesheet" media="all">

<!-- Font special for pages-->

<link href="https://fonts.googleapis.com/css?family=Open+Sans:300,300i,400,400i,600,600i,700,700i,800,800i" rel="stylesheet">

<!-- Vendor CSS-->

<link href="vendor/select2/select2.min.css" rel="stylesheet" media="all">

<link href="vendor/datepicker/daterangepicker.css" rel="stylesheet" media="all">

<!-- Main CSS-->

<link href="css/main.css" rel="stylesheet" media="all">

<!--<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script> -->

<script src="js/jquery.js"></script>

<script src="js/jquery.validate.js"></script>

<script src="js/additional-methods.js"></script>

<script src="js/messages_zh_TW.js"></script>

<script>

$.validator.setDefaults({

submitHandler: function() {

alert("submitted!");

}

});

</script>

<!--<script src="js/registration.js"></script> -->

</head>

<body>

<div class="page-wrapper bg-gra-03 p-t-45 p-b-50">

<div class="wrapper wrapper--w790">

<div class="card card-5">

<div class="card-heading">

<h2 class="title">Admin user Home page</h2>

</div>

<div class="card-body">

<?php if (isset($_SESSION['username'])) : ?>

<div class="form-row">

<div class="name">Welcome, <strong><?php echo $_SESSION['username']; ?></strong></div>

</div>

<form method="POST" action="home.php" id="uploadVideoForm" name="uploadVideoForm" enctype="multipart/form-data">

<?php include('errors.php'); ?>

<div class="form-row">

<div class="row row-space"><strong>View and approve the promote video </strong></div>

</div>

<?php $results = mysqli_query($db, "SELECT * FROM advs_video"); ?>

<table border="1">

<thead>

<tr>

<th>Username</th>

<th>Videolink</th>

<th>QRcode</th>

<th>Time</th>

<th>Status</th>

<th colspan="2">Action</th>

</tr>

</thead>

<?php while ($row = mysqli_fetch_array($results)) { ?>

<tr>

<td><?php echo $row['username']; ?></td>

<td><a href="http://157.230.145.40/ops/video/<?php echo $row['filename'];?>"><?php echo $row['filename'];?></a></td>

<td><?php echo $row['qrcode']; ?></td>

<td><?php echo $row['tm']; ?></td>

<td><?php

if ($row['approved']=='T')

{

echo "Approved";

}else if ($row['approved']=='F')

{

echo "Not Approved";

}else if ($row['approved']=='P')

{

echo "Pending";

}

?></td>

<td>

<a href="server.php?videoid=<?php echo $row['id']; ?>&approvel=T&adminuser=<?php echo $_SESSION['username']?>" class="edit_btn" >Approve</a>

</td>

<td>

<a href="server.php?videoid=<?php echo $row['id']; ?>&approvel=F&adminuser=<?php echo $_SESSION['username']?>" class="del_btn">Reject</a>

</td>

</tr>

<?php } ?>

</table>

<!--

<div class="form-row">

<div class="row row-space">

<strong><input type="file" name="myvideo"/></strong></div>

</div>

<div class="form-row">

<div class="row row-space"><strong>Qr code message:</strong> </div>

<div class="value">

<div class="input-group">

<input class="input--style-5" name="qrcode_str" id='qrcode_str' value="<?php echo $qrcode_str; ?>" > <label for="qrcode_str" class="error"></label>

</div>

</div>

</div>

<button class="btn btn--radius-2 btn--red" name="upload_video" id="upload_video" type="submit">Submit Video</button>

<br/>

<input type='hidden' name='username' id='username' value='<?php echo $_SESSION['username']; ?>' />

<br/>

<br/>

-->

</form>

<div class="form-row">

<div class="name"> <a href="syshome.php?logout='1'" style="color: red;">logout</a></div>

</div>

<?php endif ?>

</div>

</div>

</div>

</div>

<!-- Jquery JS-->

<!--<script src="vendor/jquery/jquery.min.js"></script>-->

<!-- Vendor JS-->

<script src="vendor/select2/select2.min.js"></script>

<script src="vendor/datepicker/moment.min.js"></script>

<script src="vendor/datepicker/daterangepicker.js"></script>

<!-- Main JS-->

<script src="js/global.js"></script>

</body><!-- This templates was made by Colorlib (https://colorlib.com) -->

</html>

<!-- end document-->