<?php  session_start(); error_reporting(0); ?>
<?php if(!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="Pending Withdrawals";
    $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."withdrawals-pending/";
    require_once("../j_incs/metas.php");
    require_once("../j_incs/scripts-top.php");
    ?>
    <style>
        @media(min-width:0px) and (max-width:767px){
            .datex{
                display: none !important;
            }
        }
    </style>
</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="page-header">
                        <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 class="container">
                        
                        
                        <div class="card">
                            <?php 
                            $limit =20;
                            $offset = RMC($_GET['m']);
                            if($offset<1){
                                $offset = 0;
                                $num = 1;
                            }else{
                                $num=$offset+1;
                            }
                            //count all
                            
                            $sql4="SELECT * from j_pays WHERE j_deleted < 1 AND j_paid > 0 AND j_disburse < 1 AND j_kind='WITHDRAW' order by j_id desc"; //check 
                            
                            $result4 = runSQL($sql4);
                            $total = mysqli_num_rows($result4);
                            //
                           
                            $sql4="SELECT * from j_pays WHERE j_deleted < 1 AND j_paid > 0 AND j_disburse < 1 AND j_kind='WITHDRAW' 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>
                                <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 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-default btn-block">Search</button>
                                                 </div>
                                            </div>
                                        </div>
                                     </form>
                                    <div id="formresult"></div>
                                </div>
                                <!--table-responsive-->
                                 <div class="table-responsive m-t-10" id="my-content">
                                    <table class="table table-hover table-bordered" style="font-size:11px;">
                                        <thead>
                                            <tr>
                                                <th>S/N</th>
                                                <?php if(isset($_SESSION['j_admin'])){  ?>
                                                  <th>User</th>
                                                <?php } ?>
                                                  <th>Reference ID</th>
                                                <th>Amount</th>
                                                  <th>Balance</th>
                                                <th>Recipient</th>
                                                <th>Date</th>
                                                <th>Menu</th>
                                                
                                             </tr>
                                        </thead>
                                        <tbody>
                                            <?php 
                                            while ($row = mysqli_fetch_array($result4)){
                                                $cd = get_cd($row['j_currency']);
                                                $currency_in_use = $cd[0];
                                                $currency_code_in_use = $cd[1];
                                                $currency_sort_in_use = $cd[2];
                                                //user profile
                                                $sql25="SELECT * from j_users WHERE 
                                                j_id='".$row['j_user_id']."'"; //  
                                                $result25 = runSQL($sql25);
                                                $data25 = mysqli_fetch_array($result25);
                                                $a_username = $data25['j_username'];
                                                $a_passport = $data25['j_passport'];
                                                $a_email = $data25['j_email'];
                                                $a_phone = $data25['j_phone'];
                                                $a_firstname = $data25['j_firstname'];
                                                $a_lastname = $data25['j_lastname'];
                                                $a_name = "$a_firstname $a_lastname"; $a_name = trim($a_name);
                                                
                                                ?>
                                                <tr>
													<td> <?php echo $num++; ?>. </td>
													<?php if(isset($_SESSION['j_admin'])){  ?>
													<td> <?php echo $a_name; ?> </td>
													<?php } ?>
													<td> <?php echo $row['j_transact_id']; ?> </td>
													  <td> <?php echo amount_w_c($row['j_amount'],$row['j_currency']); ?> </td>
													  <td> <?php echo amount_w_c($row['j_bal'],$row['j_currency']); ?> </td>
                                                    <td> [<?php echo $row['j_bank']; ?> - <?php echo $row['j_account_no']; ?>] </td>
													 <td> <?php echo time_ago($row['j_date']); ?> </td>
													 
													 
													<td>
                                                        <div class="btn-group dropup">
															<button type="button" class="btn btn-primary dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
																Options
															</button>
															<div class="dropdown-menu">
															  <a href="<?php echo $dir; ?>receipt/?ref=<?php echo $row['j_transact_id']; ?>" class="dropdown-item">View</a>
															  <div class="dropdown-divider"></div>
															  <?php echo "<a class='dropdown-item' href='".$dir."confirm-transfer/?r=".$row['j_transact_id']."'>Confirm</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="fas 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="fas 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="anticon anticon-close"></i>
                                             </div>
                                             <p class="text-center">No record found.</p>
                                             <?php if(isset($_SESSION['j_admin'])){ ?>
                                            
                                             <?php } ?>
                                     
                                         </div>
                                    </div>
                                    
                                </div>
                            </div>
                            <?php } ?>
                            
                            
                            
                            
                            
                            
                        </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");
    ?>
    <?php 
    /*
    $(window).bind('scroll', function() {
    if($(window).scrollTop() >= $('.posts').offset().top + $('.posts').outerHeight() - window.innerHeight) {
            alert('end reached');
        }
    });
    */
    ?>
     <script>
        $("#searchAnything").click(function(){
            $(this).hide();
            $("#my-content").hide();
            $("#my_saearch").slideDown("slow");
            $("#hide_searchAnything").slideDown("slow");
        });
        $("#hide_searchAnything").click(function(){
            $(this).hide();
            $("#my-content").show();
            $("#my_saearch").slideUp("slow");
             $("#searchAnything").slideDown("slow");
        });
         
        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>