<?php
require '../configs/app_top_admin.php';
if (!is_admin_logged_in()) {
  redirect(generate_admin_link("login"));
  exit;
}

$title = "นำเข้าผู้ใช้จาก Excel";

$sql1 = "select count(*) as count FROM " . TBL_USERS . " WHERE 1 ";
try {
  $stmt = $DB->prepare($sql1);
  $stmt->execute();
  $results = $stmt->fetchAll();
  $total = $results[0]["count"];
  $pagination = new Pagination($total, $_GET["pagenum"], 20);
  $total_pages = $pagination->total_pages();

  if ($total_pages > 0) {
    $sql2 = "select `date_joined`, `user_id`, `user_fullname`,`user_email`, `user_class`, `number_no`   "
            . "FROM " . TBL_USERS . " WHERE 1 ORDER BY date_joined DESC "
            . "LIMIT " . $pagination->get_lower_limit() . " , " . 20 . "";

    $stmt = $DB->prepare($sql2);
    $stmt->execute();
    $results = $stmt->fetchAll();
  }
} catch (Exception $ex) {
  echo $ex->getMessage();
}


include './includes/header.php';
?>
    <!-- GLOBAL STYLES -->
    <link rel="stylesheet" href="assets/plugins/bootstrap/css/bootstrap.css" />
    <link rel="stylesheet" href="assets/css/main.css" />
    <link rel="stylesheet" href="assets/css/theme.css" />
    <link rel="stylesheet" href="assets/css/MoneAdmin.css" />
    <link rel="stylesheet" href="assets/plugins/Font-Awesome/css/font-awesome.css" />
    <!--END GLOBAL STYLES -->
    <?php if ($ERROR_TYPE <> "") { ?>
  <div class="col-12">
    <div class="alert alert-<?php echo $ERROR_TYPE; ?>">
      <button data-dismiss="alert" class="close" type="button">×</button>
  <?php echo $ERROR_MSG; ?>
    </div>
  </div>
<?php } ?>

    <div class="panel panel-info">
      <div class="panel-heading"><?php echo $title; ?></div>
      <div class="panel-body"><br><img src="img/Texp.jpg"><br><br>
	  <iframe src="Import_Excel2007/upload.php" width="500" height="150" frameborder="0"></iframe>
	  </div>
    </div>

<?php
include './includes/footer.php';
require '../configs/app_bottom.php';
?>