<?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 About Webpulse";
$record_type = "About Webpulse";
$script_name = "manage_about_webpulse.php";
$table_name = " about_webpulse_tbl";
####################################################

if ($id == "add_record") {
  if ($_FILES['image']['name'] != "") {
   
    $file_extension = strtolower(getExtension($_FILES['image']['name']));
    if ($file_extension != "jpg" && $file_extension != "gif" && $file_extension != "jpeg" && $file_extension != "png" && $file_extension != "webp") {
      $_SESSION['session_message'] = '<div class="btn btn-danger">Please upload small image(.jpg,.gif,.png,.webp Format Only) </div>';
      header("Location: " . SITE_ADMIN_URL . "/" . $script_name . "?start=" . $start . "&pagesize=" . $pagesize);
      exit;
    }
  }

    if ($_FILES['image']['name'] != "") {
      $img_name = 'about-webpulse';
      $img1 = upload_file($img_name, "image", "uploaded-files/about-webpulse");
      //thumb cut
      $width="450";
      $height="252";
      $source_folder=SITE_DIR_PATH."/uploaded-files/about-webpulse/";
      $destination_folder=SITE_DIR_PATH."/uploaded-files/about-webpulse/thumbs/";
      saveResizedPhoto($img1, $width, $height, $source_folder, $destination_folder);
  
    }

    $short_desc =  htmlentitiesDecode($short_desc);

    $sql = db_query("insert into $table_name set heading1='$heading1',heading2='$heading2',short_desc='$short_desc',alt='$alt',title='$title',description='$description',image='$img1',video='$video',recvDate=now()");
    // $_SESSION['session_message'] = '<div class="btn btn-success">New ' . $record_type . ' has been added successfully </div>';

    header("Location: " . SITE_ADMIN_URL . "/" . $script_name . "?recordID=" . $recordID);
    exit;
  } 


if ($id == "update_record") {
  if ($_FILES['image']['name'] != "") {
    $file_extension = strtolower(getExtension($_FILES['image']['name']));
    if ($file_extension != "jpg" && $file_extension != "gif" && $file_extension != "jpeg" && $file_extension != "png" && $file_extension != "webp" ) {
      $_SESSION['session_message'] = '<div class="btn btn-danger">Please upload small image(.jpg,.gif,.png,.webp Format Only) </div>';
      header("Location: " . SITE_ADMIN_URL . "/" . $script_name . "?start=" . $start . "&pagesize=" . $pagesize);
      exit;
    }
  }

    if ($_FILES['image']['name'] != "") {
      $res1 = getResult($table_name, " where id='$recordID'");
      $filenm1 = SITE_DIR_PATH . "/uploaded-files/about-webpulse/" . $res1['image'];
      if (file_exists($filenm1)) {
        unlink($filenm1);
      }

      $img_name = 'about-webpulse';
      $img1 = upload_file($img_name, "image", "uploaded-files/about-webpulse");


      //Thumb Cut
      $width="450";
      $height="252";

      $source_folder=SITE_DIR_PATH."/uploaded-files/about-webpulse/";
      $destination_folder=SITE_DIR_PATH."/uploaded-files/about-webpulse/thumbs/";
      saveResizedPhoto($img1, $width, $height, $source_folder, $destination_folder);

      updateTable($table_name, " image='$img1' where id='$recordID'");
    }

    $short_desc =  htmlentitiesDecode($short_desc);

    updateTable($table_name, " heading1='$heading1',heading2='$heading2',short_desc='$short_desc',alt='$alt',title='$title',description='$description',video='$video',recvDate=now() where id='$recordID'");
    // $_SESSION['session_message'] = '<div class="btn btn-success">' . $record_type . ' has been updated successfully  </div>';

    header("Location: " . SITE_ADMIN_URL . "/" . $script_name . "?recordID=" . $recordID);
    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");
?>
<?php
 $res=getResult($table_name," where id='$_GET[recordID]'");
?>
<div class="content-wrapper">
<div class="page-header">
            <h3 class="page-title">Manage About Webpulse</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">About Webpulse</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>Heading 1</label>
                        <input class="typeahead" type="text"  name="heading1" value="<?=$res['heading1']?>" placeholder="Heading 1">
                 	</div>
                   <div class="form-group">
                      <label>Heading 2</label>
                        <input class="typeahead" type="text"  name="heading2" value="<?=$res['heading2']?>" placeholder="Heading 2">
                 	</div>

              <div class="form-group">
              <label for="exampleTextarea1">Short Description *</label>
              <textarea class="form-control" name="short_desc" rows="4" required><?= $res['short_desc'] ?></textarea>
            </div>

            <div class="form-group">
              <label for="exampleTextarea1">Description *</label>
              <textarea class="form-control editor"  name="description" rows="6" required><?= $res['description']?></textarea>
            </div>

            <div class="form-group">
                      <label>YT Video Link</label>
                        <input class="typeahead" type="text"  name="video" value="<?=$res['video']?>" placeholder="YT Video Link">
                 	</div>
                     
              
            <div class="form-group row">
            <?php
          if($res['image'] != Null) {
            ?>
                    <div class="col">
                      <label>Image</label>
                      <div id="the-basics">
                        <input class="dropify" type="file" name="image">
                      </div>
                    </div>
                    <div class="col">
                      <div id="bloodhound">
                        <img src="<?=site_url."/uploaded-files/about-webpulse/".$res['image']?>" alt="<?=$res['image']?>" title="<?=$res['image']?>" style="height:240px">
                      </div>
                    </div>
                  

                  <?php } else {?>

                    <div class="col">
                <label>Image</label>
                 <input class="dropify" type="file"  name="image">
                  </div>
         
             <?php
          }
          ?>
          
          </div>

          <div class="form-group row">
             <div class="col">
                <label>Alt</label>
           
                <input class="typeahead" type="text"  name="alt" value="<?=$res['alt']?>" placeholder="Image ALT">
      
             </div>
             <div class="col">
                <label>Title</label>
             
                <input class="typeahead" type="text"  name="title" value="<?=$res['title']?>" placeholder="Image Title">
        </div>
        </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; ?>?parentID=<?= $parentID; ?>&catID=<?= $catID; ?>'">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 About Webpulse</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>Heading 1</th>
                                    <th>Image</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['heading1'];?></p></td>
                                    <td><p class="dongle-dcs"> <?php
	   if($arr['image']!="") {
		   $file1=SITE_DIR_PATH."/uploaded-files/about-webpulse/".$arr['image'];

			   $dimens=GetImageSize($file1);
			   if($dimens[0]>130) {
				   $dimens[0]=$dimens[0]+30;
				   $dimens[1]=$dimens[1]+80;
			   }
			   else{
				   $dimens[0]=200;
				   $dimens[1]=200;
			   }
			   ?>
                <a href="javascript:void(0);" onClick="openwin('<?=SITE_ADMIN_URL;?>/popup_new.php?img=about-webpulse/<?=$arr['image'];?>', '<?=$dimens[0];?>', '<?=$dimens[1];?>')"
                        ><span>View
                    Image <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" class="bi bi-eye-slash" viewBox="0 0 16 16"> <path d="M13.359 11.238C15.06 9.72 16 8 16 8s-3-5.5-8-5.5a7.028 7.028 0 0 0-2.79.588l.77.771A5.944 5.944 0 0 1 8 3.5c2.12 0 3.879 1.168 5.168 2.457A13.134 13.134 0 0 1 14.828 8c-.058.087-.122.183-.195.288-.335.48-.83 1.12-1.465 1.755-.165.165-.337.328-.517.486l.708.709z"/> <path d="M11.297 9.176a3.5 3.5 0 0 0-4.474-4.474l.823.823a2.5 2.5 0 0 1 2.829 2.829l.822.822zm-2.943 1.299.822.822a3.5 3.5 0 0 1-4.474-4.474l.823.823a2.5 2.5 0 0 0 2.829 2.829z"/> <path d="M3.35 5.47c-.18.16-.353.322-.518.487A13.134 13.134 0 0 0 1.172 8l.195.288c.335.48.83 1.12 1.465 1.755C4.121 11.332 5.881 12.5 8 12.5c.716 0 1.39-.133 2.02-.36l.77.772A7.029 7.029 0 0 1 8 13.5C3 13.5 0 8 0 8s.939-1.721 2.641-3.238l.708.709zm10.296 8.884-12-12 .708-.708 12 12-.708.708z"/> </svg></span></a>
        <?php } ?>
                            </p>
      </td>
     <td  class="download-dcs">
                              
                                  
                                        <a href="<?=SITE_ADMIN_URL?>/manage_about_webpulse.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>
                                    </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;
                  ?>