<?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 Videos";
$record_type="Videos";
$script_name="manage_videos.php";
$table_name="video_tbl";
####################################################

if(isset($_REQUEST["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(isset($_REQUEST["update_record"])) {
  mysqli_query($dbconn,"UPDATE `$table_name` SET  slink_title='$eslink_title', slink_url='$eslink_url' where id='$update_record'");
  $_SESSION['session_message']=$record_type.' has been updated successfully';
  header("Location: ".SITE_ADMIN_URL."/".$script_name."?start=".$start."&pagesize=".$pagesize);
  exit;
}

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");
$res=getResult($table_name," where id='$_GET[recordID]'");
?>

<div class="content-wrapper">
  <div class="page-header">
      <h3 class="page-title">Manage Videos</h3>
      <nav aria-label="breadcrumb">
			  <ol class="breadcrumb">
          <li class="breadcrumb-item">
            <a class="nav-link" href="#" data-toggle="modal" data-target="#addVideo">
              <span class="btn btn-primary">+ Add New Video</span>
            </a>
          </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>Video Title</th>
                        <th>Video Id</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="#" class="edtBtn" data-toggle="modal" data-target="#updateVideo" data-id="<?=$arr['id'];?>" data-link="<?=$arr['slink_url'];?>" data-title="<?=$arr['slink_title'];?>">
                              <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>

        <div class="modal" id="updateVideo" tabindex="-1" role="dialog">
          <div class="modal-dialog" role="document">
            <div class="modal-content">
              <div class="modal-header p-3">
                <h5 class="modal-title">Update video</h5>
                  <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                  <span aria-hidden="true">&times;</span>
                </button>
              </div>
              <form class="forms-sample" method="POST" action="" enctype="multipart/form-data">
                <div class="modal-body p-3">
                  <div class="form-group">
                    <label>Video Title</label>
                    <input class="typeahead" type="text"  name="eslink_title" placeholder="Video Title" required>
                  </div>
                  
                  <div class="form-group">
                    <label>Video Id</label>
                    <input class="typeahead" type="text" name="eslink_url" required>
                    <div><sup class="text-danger">**</sup><small>https://www.youtube.com/watch?v=<b class="text-danger">z9qo09n2pzw</b></small> <br> <small>The red part is the video id of Youtube link</small></div>
                  </div>
                  
                </div>
                <div class="modal-footer p-3">
                  <input type="hidden" name="update_record" value="">
                  <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
                  <button type="submit" class="btn btn-primary">Submit</button>
                </div>
              </form>
            </div>
          </div>
        </div>

        <div class="modal" id="addVideo" tabindex="-1" role="dialog">
          <div class="modal-dialog" role="document">
            <div class="modal-content">
              <div class="modal-header p-3">
                <h5 class="modal-title">Add new video</h5>
                  <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                  <span aria-hidden="true">&times;</span>
                </button>
              </div>
              <form class="forms-sample" method="POST" action="" enctype="multipart/form-data">
                <div class="modal-body p-3">
                  <div class="form-group">
                    <label>Video Title</label>
                    <input class="typeahead" type="text"  name="slink_title" placeholder="Video Title" required>
                  </div>
                  
                  <div class="form-group">
                    <label>Video Id</label>
                    <input class="typeahead" type="text" name="slink_url" required>
                    <div><sup class="text-danger">**</sup><small>https://www.youtube.com/watch?v=<b class="text-danger">z9qo09n2pzw</b></small> <br> <small>The red part is the video id of Youtube link</small></div>
                  </div>
                  
                </div>
                <div class="modal-footer p-3">
                  <input type="hidden" name="add_record" value="add_record">
                  <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
                  <button type="submit" class="btn btn-primary">Submit</button>
                </div>
              </form>
            </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(); ?>
        <script language="javascript">
          $(document).ready(function(){
            $('.edtBtn').click(function(){
              $('input[name=eslink_title]').val($(this).data('title'));
              $('input[name=eslink_url]').val($(this).data('link'));
              $('input[name=update_record]').val($(this).data('id'));
            });
          });
        </script>