<?php
include_once("../include/main.inc.php");
check_session('MyCpanel','index.php');
################ Paging Starts From Here ##################
@extract($_REQUEST);
$start = (intval($start)<0 or $start=="")?0:$start;
$pagesize = intval($pagesize)==0?$pagesize=20:$pagesize;

$heading="Manage Token OS";
$record_type="Token OS";
$script_name="manage_token.php";
$table_name="token_tbl";
####################################################

if($id=="add_record") {
  $qry1= db_query("select * from $table_name where slink_url='$url'");
  if(NumRows($qry1)>0){
    $_SESSION['session_message']=$record_type.' Already Exists';
  }else{
    $sql=db_query("insert into $table_name set slink_title='$slink_title',slink_url='$slink_url'");
    $_SESSION['session_message']='New '.$record_type.' has been added successfully';
  }
  header("Location: ".SITE_ADMIN_URL."/".$script_name."?start=".$start."&pagesize=".$pagesize);
  exit;
}

if($id=="update_record") {
  if(!strlen($form_check_alert)>0) {
    mysqli_query($dbconn,"UPDATE `$table_name` SET  slink_title='$slink_title', slink_url='$slink_url' where id='$recordID'");
		$_SESSION['session_message']=$record_type.' has been updated successfully';
		header("Location: ".SITE_ADMIN_URL."/".$script_name."?start=".$start."&pagesize=".$pagesize);
		exit;
	}else {
		$msg=html_head();
		$msg.=$form_check_alert;
		$msg.=html_foot();
	}
}

if (isset($_POST['delete'])) {
	if (!empty($_POST['cat_arr'])) {
		$catid = $_POST['cat_arr'];
		foreach ($catid as $id) {
			mysqli_query($dbconn, "DELETE FROM $table_name WHERE id = '$id'");
		}
		$_SESSION['session_message'] = '<div class="btn btn-success">' . $record_type . ' has been deleted successfully</div>';
	} else {
		$_SESSION['session_message'] = '<div class="btn btn-danger">No Category selected</div>';
	}
	header("Location: ".SITE_ADMIN_URL."/".$script_name);
	exit;
}
########################################################
admin_header("");
$qry= db_query("select * from $table_name");
?>
<?php $res=getResult($table_name," where id='$_GET[recordID]'"); ?>
<div class="content-wrapper">
  <div class="page-header">
    <h3 class="page-title">Add New Token OS</h3>
    <nav aria-label="breadcrumb">
			<ol class="breadcrumb">
        <li class="breadcrumb-item"><a href="<?admin_url?>welcome.php">Admin</a></li>
        <li class="breadcrumb-item active" aria-current="page">Add New Token</li>
      </ol>
    </nav>
  </div>
  
  <div class="row">
    <div class="col-12 grid-margin stretch-card">
      <div class="card">
        <div class="card-body">
          <form class="forms-sample" method="POST" action="" enctype="multipart/form-data">
            <div class="form-group">
              <label>Token OS Name</label>
              <input class="typeahead" type="text"  name="slink_title" value="<?=$res['slink_title']?>" placeholder="Token Name" required>
            </div>
            
                   
            <div class="form-group">
              <label>Token type</label>
              <input class="typeahead" placeholder="Token Price" type="number" value="<?=$res['slink_url']?>" name="slink_url" required>
            </div>
            <?php 
              if($_GET[recordID] != Null) {
            ?>
            <button type="submit" class="btn btn-primary mr-2" name="add_record">Update</button>
	   		    <input type="hidden" name="recordID" value="<?=$res['id'];?>">
	   		    <input type="hidden" name="id" value="update_record">
            <?php } else { ?>
            <button type="submit" class="btn btn-primary mr-2" name="submit">Submit</button>
            <input type="hidden" name="id" value="add_record">
            <?php } ?>
            <button class="btn btn-light" onclick="javascript: window.location.href = '<?=SITE_ADMIN_URL;?>/<?= $redirect_script_name; ?>'">Cancel</button>
          </form>
        </div>
      </div>
    </div>
  </div>

  <div class="page-header">
    <h3 class="page-title"><?=$heading;?></h3>
    <nav aria-label="breadcrumb">
      <ol class="breadcrumb">
        <li class="breadcrumb-item"><a href="welcome.php">Admin</a></li>
        <li class="breadcrumb-item active" aria-current="page">Manage Token OS</li>
      </ol>
    </nav>
  </div>

  <div class="card">
    <div class="card-body">
      <div class="row">
        <div class="col-12">
          <form action="" method="post">
            <div class="table-responsive">
              <table id="order-listing" class="table table-bordered table-hover">
                <thead>
                  <tr>
                    <th class="_reab">
                      <div class="form-check mt-0">
                        <label class="form-check-label">
                          <input type="checkbox" class="form-check-input">
                          <i class="input-helper"></i>
                        </label>
                      </div>
                    </th>
                    <th>S.No.</th>
                    <th>Token Name</th>
                    <th>Token Type</th>
                    <th>Actions</th>
                  </tr>
                </thead>
                <tbody>
                  <?php $sl=$start+1; while($arr=mysqli_fetch_array($qry)) { ?>
                  <tr>
                    <td>
                      <div class="form-check mt-0">
                        <label class="form-check-label">
                          <input type="checkbox" class="form-check-input" name="cat_arr[]" value="<?= $arr['id'] ?>"><i class="input-helper"></i>
                        </label>
                      </div>
                    </td>
                    <td><?=$sl?></td>
                    <td><p class="ordern"><?=$arr['slink_title'];?></p></td>
                    <td><p class="productid-dcs"><?=$arr['slink_url'];?></p></td>
                    <td>
                      <p class="download-dcs">
                        <a href="<?=SITE_ADMIN_URL?>/manage_token.php?recordID=<?=$arr['id'];?>"><svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="feather feather-edit-3"><path d="M12 20h9"></path><path d="M16.5 3.5a2.121 2.121 0 0 1 3 3L7 19l-4 1 1-4L16.5 3.5z"></path></svg></a>
                      </p>
                    </td>
                  </tr>
                  <?php  $sl++; }?>
                </tbody>
              </table>
              <div class="btn-grp">
                <button type="submit" name="delete" onclick="return select_chk()" class="btn btn-danger btn-icon-text btn-sm">
                <i class="fas fa-trash-alt mr-1"></i>Delete</button>
              </div>
            </div>
          </form>
        </div>
      </div>
    </div>
  </div>
</div>

<script language="javascript">
  function select_chk(){
    var chks = document.getElementsByName('cat_arr[]');
    var hasChecked = false;
    for (var i = 0; i < chks.length; i++){
      if (chks[i].checked){
        hasChecked = true;
        break;
      }
    }
    
    if (hasChecked == false){
      alert("Please Select At Least One.");
      return false;
    }
  }
</script>
<?php admin_footer(); exit; ?>