<?php  session_start(); error_reporting(0); ?>
<?php if(!isset($_SESSION['j_admin']) && !isset($_SESSION['j_admin'])){ 
    $url = urlencode("http://$_SERVER[HTTP_HOST]$_SERVER[REQUEST_URI]"); header('location:../login/?url='.$url.'');  
} ?>
<!doctype html>
<html lang="en"> 
<head>
	<?php
    require_once("../j_conn/url.php");
    require_once("../j_conn/dbc.php");
    require_once("../j_incs/functions.php");
    $page_name="All Testimonials";
    $page_desc="$page_name";
    $page_img="".$dir."j_files/j_img/logo/logo-meta.png";
    $page_author="$company";
    $page_keywords="".$company.", $page_name, $page_desc, ".$company_motto.", $company_desc";
    $page_url="".$dir."testimonials-all/";
    require_once("../j_incs/metas.php");
    require_once("../j_incs/scripts-top.php");
    ?>
</head>
<body>
    
    <div class="app">
        <div class="layout">
            <?php 
            require_once("../j_incs/header.php");
            require_once("../j_incs/nav.php");
            ?>
            <!-- Page Container START -->
            <div class="page-container">
                

                <!-- Content Wrapper START -->
                <div class="main-content">
                    <div class="container-fluid">
                        <div class="">
                            <div class="col-md-11 mx-auto">
                                <div class="page-header">
									<?php /*<h2 class="header-title"><?php echo $page_name; ?></h2>*/ ?>
									<div class="header-sub-title">
										<nav class="breadcrumb breadcrumb-dash">
											<a href="<?php echo $dir; ?>" class="breadcrumb-item"><i class="anticon anticon-dashboard m-r-5"></i>Dashboard</a>
											<!--<a class="breadcrumb-item" href="#"> </a>-->
											<span class="breadcrumb-item active"><?php echo $page_name; ?></span>
										</nav>
									</div>
								</div>
                            </div>
                        </div>
                    </div>
                     
                    <div class="container-fluid">
						<div class="">
							<div class="col-md-11 mx-auto">
								<div class="tab-content m-t-15">
									<div class="tab-pane fade show active" id="tab-account">


										<div class="">
											<div class="card-header">
												<h4>Testimonials</h4>
											</div>
											<div class="">
												
												
												
												
												
												<?php 
												$limit =50;
												$offset = RMC($_GET['m']);
												if($offset<1){
													$offset = 0;
													$num = 1;
												}else{
													$num=$offset+1;
												}
												
												//echo $i_url;
												if(strpos($i_url, 'testimonials') !== false){
													$sql4="SELECT * from j_testimonials WHERE j_deleted < 1 order by j_id desc"; //check 
													$result4 = runSQL($sql4);
													$total = mysqli_num_rows($result4);
													//
													$sql4="SELECT * from j_testimonials WHERE j_deleted < 1 order by j_id desc limit $limit offset $offset"; //check 
													$result4 = runSQL($sql4);
													$count = mysqli_num_rows($result4); 
												}


												
												if($count>0){
												?>
												<div class="card-body">
													<p>Count: <?php echo number_format($total); ?></p>
													
													<?php 
													/*
													 <div style="cursor:pointer; margin-bottom:10px;" id="searchAnything"> 
														<span class="badge badge-pill badge-primary font-size-12">Search Anything</span>
													</div>
													<div style="cursor:pointer;display:none; margin-bottom:10px;" id="hide_searchAnything"> 
														<span class="badge badge-pill badge-danger font-size-12">Hide Search</span>
													</div>

													<div id="my_saearch" style="display:none;">
														 <form method="POST" action="" id="form" enctype="multipart/form-data">
															 <div class="form-row">
																<div class="form-group" style="display:none;">
																	  <div class="input-affix m-b-2">
																		 <input autocomplete="off" type="text" value="<?php echo $i_url; ?>" class="form-control rMe" name="url"/>
																	 </div>
																</div>
																<div class="form-group col-md-6">
																	  <div class="input-affix m-b-2">
																		 <input autocomplete="off" type="text" placeholder="Search" class="form-control rMe" name="search"/>
																	 </div>
																</div>


																<div class="form-group col-md-3">
																	  <div class="input-affix m-b-2">
																			<button id="submit"  name="submit" class="btn btn-primary btn-block">Search</button>
																	 </div>
																</div>
															</div>
														 </form>
														<div id="formresult"></div>
													</div>
													*/
													?>
													<!--table-responsive-->
													 <div class="table-responsive m-t-10 my-content" id="my-content">
														<table style="font-size:11px;" class="table table-hover table-bordered">
															<thead>
																<tr>
																	<th>S/N</th>
																	 <th>Reference ID</th>
																	 <th>Name</th>
																	 <th>Email Address</th>
																	 <th>Message</th>
																	 <th>Status</th>
																	   <th>Date</th>
																	  <th>Menu </th>
																  </tr>
															</thead>
															<tbody>
																<?php
																while ($row = mysqli_fetch_array($result4)){
																
																?>
																	
																<tr id="i<?php echo $row['j_id']; ?>">
																	<td> <?php echo $num++; ?></td>
																	<td> <?php echo $row['j_transact_id']; ?></td>
																	<td> <?php echo $row['j_name']; ?></td>
																	<td> <?php echo $row['j_email']; ?></td>
																	<td> <?php echo $row['j_msg']; ?></td>
																	<td> 
																		<?php 
																		if($row['j_status'] > 0){ echo "Enabled"; }else{ echo "Disabled";  }
																		?>
																	</td>
																	<td> <?php echo FULL_DATE($row['j_date']); ?></td>
																	
																	<td>
																	
																		<div class="btn-group" role="group">
																			<button id="btnGroupDrop1" type="button" class="dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
																			  Option
																			</button>
																			<div class="dropdown-menu" aria-labelledby="btnGroupDrop1">
																			
																			<a class="dropdown-item" href="<?php echo $dir; ?>testimonials-all/enable.php?t_id=<?php echo ($row['j_id']);?>&b_url=<?php echo $url;?>">
																				<?php 
																				if($row['j_status'] > 0){ echo "Disable"; }else{ echo "Enable";  }
																				?>
																			</a>
																				
																			 <div class="dropdown-divider"></div>
																			  <a class="dropdown-item" href="<?php echo $dir; ?>testimonials-edit?ref=<?php echo ($row['j_id']);?>&b_url=<?php echo $url;?>">Edit</a>
																			 <div class="dropdown-divider"></div>
																				
																			  <a class="dropdown-item" href="<?php echo $dir; ?>testimonials-all/del.php?t_id=<?php echo ($row['j_id']);?>&b_url=<?php echo $url;?>">Delete</a>
																			</div>
																		</div>
																		
																	</td>
														
																	
																
																	
																</tr>
																<?php } ?>

															</tbody>
														</table>
														<p align="center">
															<?php if($offset+$limit < $total){ ?>
															<a class="btn btn-sm btn-default" href="?m=<?php echo $offset+$limit; ?>">Load Next<i class="fa fa-chevron-right text-2 ml-2"></i></a>
															<?php } ?>
															&nbsp; &nbsp;
															<?php if($offset > 0){ ?>
															<a class="btn btn-sm btn-default" href="?m=<?php echo $offset-$limit; ?>"><i class="fa fa-chevron-left text-2 ml-2"></i>  Previous</a>
															<?php } ?>
														</p>
													</div>
													
													
												</div>



												<?php }else{ //no record ?> 
												<div class="card-body">
													<div class="container">
														<div class="row">
															 <div class="col-md-12" style="text-align:center;">
																<div class="avatar avatar-image avatar-lg avatar-red">
																	<i class="fa fa-times"></i>
																 </div>
																 <p class="text-center">No record found.</p>
																  
															 </div>
														</div>

													</div>
												</div>
												<?php } ?>
									
									
									
									
									
												
												
											</div>
										</div>

									</div>
								</div>
							</div>
						</div>
					</div>
                </div>
                <!-- Content Wrapper END -->

                <?php
                require_once("../j_incs/footer.php");
                ?>

            </div>
            <!-- Page Container END -->
        </div>
    </div>
    
    
    <?php
    require_once("../j_incs/scripts-bottom.php");
    ?>
    <script>
        var form = "#form";
        var button = "#submit";
        var button_val = $(button).html();
        var result = "#formresult";
        $(form).on('submit',(function(e) {
        e.preventDefault();
        $(button).attr('disabled', '');
        $(button).html("<i class='anticon anticon-loading'></i> Processing");
        $(result).html("<div class='alert alert-warning'> Taking too long? <a href=''>Reload </a></div>");
         $.ajax({
        url: "save.php",
        type: "POST",
        data: new FormData(this),
        contentType: false,
        cache: false,
        processData:false,
        success: function(data)
        {
        if(data){
         $(button).removeAttr('disabled');
        $(button).html(button_val);
        $(result).html(data);
        }else{
        $(result).html("Error occurred.");
        $(button).removeAttr('disabled');
        $(button).html(button_val);
        }
        }
        });
        }));
        </script>
   
</body>
</html>