<?php include('../config.php');
include('inc.session-create.php');
$PageTitle = "registration";
$FileName = 'registration.php';
$validate = new Validation();
if ($_SESSION['success'] != "") {
  $stat['success'] = $_SESSION['success'];
  unset($_SESSION['success']);
}

if (isset($_POST['addnewrecord'])) {
  $validate->addRule($_POST['title'], '', 'Title', true);
  if ($validate->validate() && count($stat) == 0) {
    if (isset($_FILES["thumbnail"]["name"]) && !empty($_FILES["thumbnail"]["name"])) {
      $filename = basename($_FILES['thumbnail']['name']);
      $ext1 = strtolower(substr($filename, strrpos($filename, '.') + 1));
      if (in_array($ext1, array('jpg', 'JPG', 'JPEG', 'jpeg', 'png', 'PNG', 'gif', 'svg', 'webp', 'pdf', 'docx', 'doc'))) {
        $newfile = date("d-m-Y-h-i-s") . rand(1000, 9999) . "." . $ext1;
        move_uploaded_file($_FILES['thumbnail']['tmp_name'], "../uploads/" . $newfile);
      }
    }

    $aryData = array(
      'token'                     =>     token('registration'),
      'title'                     =>     $_POST['title'],
      'title_one'                     =>     $_POST['title_one'],
      'description'           =>       $_POST['description'],
      'description_one'           =>       $_POST['description_one'],
      'date'           =>       date("Y-m-d"),
      'category'           =>       $_POST['category'],
      'location'           =>       $_POST['location'],
      'thumbnail'                  =>     $newfile,
      'thumbnail_one'                  =>     $newfile1,
      'status'                    =>     $_POST['status'],
    );
    $flgIn1 = $db->insertAry("registration", $aryData);
    //echo $db->getLastQuery();exit;
    $_SESSION['success'] = "Submited Successfully";
    redirect($FileName);
    unset($_POST);
  } else {
    $stat['error'] = $validate->errors();
  }
} elseif (isset($_POST['updaterecord'])) {
  $validate->addRule($_POST['title'], '', 'Title', true);
  if ($validate->validate() && count($stat) == 0) {
    if (isset($_FILES["image"]["name"]) && !empty($_FILES["image"]["name"])) {
      $filename = basename($_FILES['image']['name']);
      $ext1 = strtolower(substr($filename, strrpos($filename, '.') + 1));
      if (in_array($ext1, array('jpg', 'JPG', 'JPEG', 'jpeg', 'png', 'PNG', 'gif', 'svg', 'webp'))) {
        $newfile = date("d-m-Y-h-i-s") . rand(1000, 9999) . "." . $ext1;
        move_uploaded_file($_FILES['image']['tmp_name'], "../uploads/" . $newfile);
      }
    } else {
      $newfile = $_POST['image_old'];
    }

    $aryData = array(
      'title'                     =>     $_POST['title'],
      'thumbnail'                  =>     $newfile,
      'status'                    =>     $_POST['status'],
    );
    $flgIn = $db->updateAry("registration", $aryData, "where id='" . $_GET['id'] . "' ");
    //		echo $db->getLastQuery();	exit;
    $_SESSION['success'] = "Update Successfully";
    unset($_POST);
    redirect($FileName);
  } else {
    $stat['error'] = $validate->errors();
  }
} elseif (($_REQUEST['action'] == 'delete')) {
  $aryData = array(
    'status'                     => 2,
  );
  $flgIn = $db->updateAry("registration", $aryData, "where id='" . $_GET['id'] . "' ");
  //	echo $db->getLastQuery();	exit;
  $_SESSION['success'] = 'Deleted Successfully';
  redirect($FileName);
}
?>
<!DOCTYPE html>
<html>

<head>
  <?php include('inc.meta.php'); ?>
  <style>
    div.scrollmenu {
      background-color: #fff;
      overflow: auto;
      white-space: nowrap;
    }

    div.scrollmenu a {
      display: inline-block;
      color: white;
      text-align: center;
      padding: 14px;
      text-decoration: none;
    }

    div.scrollmenu a:hover {
      background-color: #777;
    }
  </style>

</head>

<body class="fixed-left">
  <div id="wrapper"><?php include('inc.header.php'); ?><?php include('inc.sideleft.php'); ?><div class="content-page">
      <div class="content">
        <div class="container">
          <div class="row">
            <div class="col-sm-12">
              <h4 class="page-title"><?php echo $PageTitle; ?></h4>
              <ol class="breadcrumb">
                <li><a href="<?php echo $iClassName; ?>">Home</a></li>
                <li class="active"><?php echo $PageTitle; ?></li>
              </ol>
            </div>
          </div>
          <div class="row">
    <div class="col-md-12 text-right">

    </div>
</div>
          <div class="row">
            <div class="col-md-12">
              <div class="card-box">
                <div class="row">
                <form method="post" action="export_csv.php">
            <button type="submit" name="export_csv" class="btn btn-primary">Download CSV</button>
        </form>
                  <div class="col-md-9"><?php echo msg($stat); ?></div>
                </div>
              </div>
              <div class="card-box  scrollmenu">
                <table id="datatable" class="table table-striped table-bordered">
                  <thead>
                    <tr>
                      <th>#</th>
                      <th>District Name</th>
                      <th>Block Name</th>
                      <th>Game Name</th>
                      <th>Name (Hindi)</th>
                      <th>Name (English)</th>
                      <th>Parents/Husband Name</th>
                      <th>Gender</th>
                      <th>DOB</th>
                      <th>Address</th>
                      <th>Addhar No.</th>
                      <th>Blood Group</th>
                      <th>Email ID</th>
                      <th>Mobile NO.</th>
                      <th>What's App NO.</th>
                      <th>Category</th>
                      <th>Image</th>
                      <th>Signature</th>
                    </tr>
                  </thead>
                  <tbody>
    <?php
    $i = 1; // Initialize the serial number counter
    $admin = $db->getRow("SELECT * FROM admin_login WHERE id ='" . $_SESSION['SUPER_ADMIN']['id'] . "'");
    $usertype = $admin['usertype']; // Assuming the usertype is stored in the admin_login table

    if ($usertype == 0) {
        // Usertype-0: Show all data
        $aryList = $db->getRows("SELECT * FROM registration");
    } else {
        // Usertype-1: Show only assigned data
        $aryList = $db->getRows("SELECT * FROM registration WHERE distict_name='" . $admin['distict_name'] . "'");
    }

    foreach ($aryList as $iList) {
        $districtname = $db->getRow("SELECT * FROM district WHERE id='" . $iList['distict_name'] . "'");
        $blockname = $db->getRow("SELECT * FROM block WHERE id='" . $iList['block_name'] . "'");
    ?>
        <tr>
            <td><?php echo $i; ?></td> <!-- Serial number -->
            <td><?php echo $districtname['distict_name']; ?></td> <!-- Changed to show district name -->
            <td><?php echo $blockname['block_name']; ?></td>
            <td><?php echo $iList['game_name']; ?></td>
            <td><?php echo $iList['name_hi']; ?></td>
            <td><?php echo $iList['name_en']; ?></td>
            <td><?php echo $iList['parents']; ?></td>
            <td><?php echo $iList['gender_name']; ?></td>
            <td><?php echo $iList['dob']; ?></td>
            <td><?php echo $iList['address']; ?></td>
            <td><?php echo $iList['addhar']; ?></td>
            <td><?php echo $iList['blood_group']; ?></td>
            <td><?php echo $iList['email']; ?></td>
            <td><?php echo $iList['mobileno']; ?></td>
            <td><?php echo $iList['whatsno']; ?></td>
            <td><?php echo $iList['category_name']; ?></td>
            <td><img src="../uploads/<?php echo $iList['thumbnail']; ?>"></td>
            <td><img src="../uploads/<?php echo $iList['thumbnail1']; ?>"></td>
        </tr>
    <?php $i++; } ?>
</tbody>
                </table>
              </div>
            </div>
          </div>
        </div>
      </div><?php include('inc.footer.php'); ?>
    </div>
  </div><?php include('inc.js.php'); ?>
</body>

</html>