<?php
    session_start();
    if($_SESSION['unohs'] == null){
        header("location:index.php?msg=unauthorized");
    }
?>
<?php
    include ("conn.php");
    
    // New Number Add
    if(isset($_POST['newnum']) && isset($_POST['type'])){
        $number = mysqli_real_escape_string($conn, $_POST['newnum']);
        $type   = mysqli_real_escape_string($conn, $_POST['type']); // Bkash/Nagad
        
        $sql_q = "INSERT INTO deyya (maulya, sthiti, type) VALUES ('".$number."', '0', '".$type."')";
        $chk = mysqli_query($conn, $sql_q);
        if($chk){
            echo '<script type="text/JavaScript"> alert("Number Added Successfully"); </script>';
        }else {
            echo '<script type="text/JavaScript"> alert("Failed to Add Number"); </script>';
        }
    }
    
    // Active Number Change
    if(isset($_POST['upiid'])){
        $a_id = $_POST['upiid'];
        $sql_s = "SELECT * FROM deyya WHERE maulya = '".$a_id."'";
        $run = mysqli_query($conn, $sql_s);

        // পুরনো Active কে 0 করা
        $sql_d = "SELECT * FROM deyya WHERE sthiti = '1'";		
        $run_d = mysqli_query($conn, $sql_d);
        $rund_f = mysqli_fetch_array($run_d);
        if($rund_f){
            $ch_s0 = "UPDATE deyya SET sthiti='0' WHERE shonu='".$rund_f['shonu']."'";
            $exe_ch_s0 = mysqli_query($conn, $ch_s0);
        }
        
        // নতুনটাকে Active করা
        $run_f = mysqli_fetch_array($run);
        if($run_f){
            $ch_s1 = "UPDATE deyya SET sthiti='1' WHERE shonu='".$run_f['shonu']."'";
            $exe_ch_s1 = mysqli_query($conn, $ch_s1);
        }
    }
?>
<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
  <title>Dashboard</title>
  <link rel="stylesheet" href="vendors/mdi/css/materialdesignicons.min.css">
  <link rel="stylesheet" href="vendors/feather/feather.css">
  <link rel="stylesheet" href="vendors/base/vendor.bundle.base.css">
  <link rel="stylesheet" href="vendors/flag-icon-css/css/flag-icon.min.css"/>
  <link rel="stylesheet" href="vendors/font-awesome/css/font-awesome.min.css">
  <link rel="stylesheet" href="vendors/jquery-bar-rating/fontawesome-stars-o.css">
  <link rel="stylesheet" href="vendors/jquery-bar-rating/fontawesome-stars.css">
  <link rel="stylesheet" href="css/style.css">
  <link rel="stylesheet" href="plugins/datatables/dataTables.bootstrap.css">
  <link rel="stylesheet" href="https://cdn.datatables.net/1.12.1/css/jquery.dataTables.min.css">
  <link rel="stylesheet" href="https://cdn.datatables.net/fixedheader/3.2.3/css/fixedHeader.dataTables.min.css">
  <link rel="shortcut icon" href="images/favicon.png" />
  <style>
    .cool-input {
        border: 2px solid #007bff;
        border-radius: 0.25rem;
        padding: 0.5rem 1rem;
        font-size: 1rem;
    }
    .cool-input:focus {
        border-color: #0056b3;
        box-shadow: 0 0 0 0.2rem rgba(0, 123, 255, 0.25);
    }
    .cool-button {
        padding: 0.5rem 1rem;
        font-size: 1rem;
        border-radius: 0.25rem;
        transition: all 0.3s ease;
    }
    .cool-button:hover {
        background-color: #0056b3;
        color: #fff;
    }
  </style>
</head>
<body>
  <div class="container-scroller">
    <div class="container-fluid page-body-wrapper">
      <div class="main-panel">
        <div class="content-wrapper">
          <div class="row">
            <div class="col-sm-12 mb-4 mb-xl-0">
              <h4 class="font-weight-bold text-dark">Add Bkash/Nagad Number</h4>
            </div>
          </div>   

          <!-- Add Number Form -->
          <div class="row">
            <form action="#" id="numform" method="post" autocomplete="off">
              <div class="d-flex align-items-center">
                <input name="newnum" type="text" placeholder="Enter Bkash/Nagad Number" class="flex-grow-1 cool-input" style="height: 40px;" required />
                <select name="type" class="cool-input ml-2" style="height: 40px;">
                  <option value="Bkash">Bkash</option>
                  <option value="Nagad">Nagad</option>
                </select>
              </div>
              <div class="d-flex align-items-center mt-3">
                <button type="submit" class="btn btn-primary cool-button mr-2">Add</button>
              </div>
            </form>
          </div>

          <!-- Show All Numbers -->
          <div class="row mt-4">
            <?php
                $sel_num = "SELECT * FROM deyya WHERE sthiti='0' OR sthiti='1'";
                $num_r = mysqli_query($conn, $sel_num);
            ?>
            <form action="#" id="numsave" method="post" autocomplete="off">
            <?php while ($row = mysqli_fetch_array($num_r)) { ?>
              <input name="upiid" type="radio" style="margin-top: 10px; margin-left:12px;"
                value="<?php echo $row['maulya']; ?>" <?php if($row['sthiti']==1){echo "checked";} ?> />
              <label for="<?php echo $row['maulya']; ?>">
                <?php echo $row['type']." - ".$row['maulya']; ?>
              </label>
              <br/>
            <?php } ?>
              <button type="submit" class="btn btn-primary cool-button mr-2">Save</button>
            </form>
          </div>		  					  		  		    
        </div>
      </div>
    </div>
  </div>
</body>
</html>