.-.-.-.-.-

<?php
$title= "Pins";
include 'header.php';

//$pin_type =  array('a'=>11500 ,'b'=>28750,'c'=>57500,'d'=>115000,);
$uid = $_SESSION['userid'];
?>
<script>
function show_type(type) {
    window.location='pin.php?type='+type;
}

<div class="container-fluid">

<div class="row">
        <div class="col-sm-12">
            <div class="page-title-box">
                <h4 class="page-title">Manage Pin</h4>
                  <ol class="breadcrumb">
                        <li class="breadcrumb-item"><a href="index.php">Home</a></li>
                        <li class="breadcrumb-item"><a href="#">Pin</a></li>
                   
                    </ol>

</div>
        </div>
    </div>
    
   
</div>

<div class="container-fluid">
    <?php echo getMessage(); ?>
    <div class="row">
        <div class="col-sm-12">
            <div class="page-title-box">
                <h4 class="page-title"><B>PIN REPORT</b></h4>
                <ol class="breadcrumb">
                     <li class="breadcrumb-item"><a href="index.php">Home</a></li>
                    <li class="breadcrumb-item"><a href="#">Pin</a></li>
                    <li class="breadcrumb-item active">Pin</li>
                </ol>

</div>
        </div>
    </div>

<!--    <div class="row">
        <div class="col-12">
            <div class="card m-b-20">
                <div class="card-body">
                       <?php
    //$wallet_row = mysqli_fetch_object(mysqli_query($connection, "SELECT wallet, wallet_fund FROM user WHERE uid='$uid'"));
     $total_closed_amount = mysqli_fetch_object(mysqli_query($connection, "SELECT sum(remaining_amount) as total_amount FROM `transaction` WHERE `uid`='".$uid."' AND status='1' AND remaining_amount > '0' AND txn_mode='0' "))->total_amount;
$total_unclosed_amount = mysqli_fetch_object(mysqli_query($connection, "SELECT sum(remaining_amount) as total_amount FROM `transaction` WHERE `uid`='".$uid."' AND status='0' AND remaining_amount > '0' AND txn_mode='0' "))->total_amount;

?>
<h4>Total Fund wallet <?php echo empty($total_unclosed_amount)?0.00:$total_unclosed_amount?> </h4>
<h4>Total Payout wallet <?php echo empty($total_closed_amount)?0.00:$total_closed_amount?> </h4>
    <?php echo getMessage();?>
 <form name="form" id="form" action="pin_model.php" method="post">
        <p>
             <label for="wallet_type">Select Wallet Type <span>*</span></label>
            <select name="wallet_type" id="wallet_type" required="required">
                <option value="fund_wallet" selected="selected">Fund Wallet </option>
                <option value="primary_wallet" selected="selected" >Payout Wallet </option>
            </select>
            Note: If you want to add fund wallet as well as payout wallet then first transfer fund to self wallet
          </p>
        <p>
            <label for="pin">Select Pin Type <span>*</span></label>
            <select name="type" id="type" onChange="show_type(this.value);" required="required">
                <?php
                $result_pin_package = mysqli_query($connection, "SELECT id, package_name, package_amount, pin_length FROM pin_package WHERE package_amount !='50'");
                while ($pin_type = mysqli_fetch_object($result_pin_package)) {
                ?>
                <option value="<?php echo $pin_type->id;?>" <?php if($pin_type->id==$_GET['type']){echo "selected='selected'";}?>><?php echo "Package - $pin_type->package_amount ";?></option>
                <?php
                }
                ?>
            </select>
          </p>
          
        <p>
            <label for="pin">Enter Amount <span>*</span></label>
            <input type="number" name="amount" id="amount" required="required" min="10" step="any" />
        </p>
       
        <p><br />
           
            <input style="position: relative; left: 180px;" name="submit" type="submit" id="submit" value="Generate">
        </p>
    </form>                </div>

</div>
        </div>  end col 
    </div>  end row -->

</div>

<form name="myform" action="pin.php">
    <div class="row">
        <div class="col-lg-12">
            <div class="card m-b-20">
                <div class="card-body">

<table class="table table-striped table-hover table-bordered dt-responsive datatable">
                        <thead>
                            <tr>
                                <th>check</th>
                    <th>S.No</th>
                    <th>Transfer Date</th>
                    <th>Used Date</th>
                    <th>Pin Number</th>
                    <th>Pin Type</th>
                    <th>Amount</th>
                    <th>Status</th>
                    <th>Generated by</th>
                    
                     
                     
                            </tr>
                        </thead>
                        <tbody>
    <?php
    $type=$_GET['type'];
//    if(!isset($_GET['page'])){$i=1;}else{$i=(($_GET['page']-1)*20)+1;}
    $query = "SELECT t1.*, t2.package_name as package_name, t2.package_amount as package_amount, t3.login_id FROM dynamicpinnumber t1 INNER JOIN pin_package t2 ON t1.type = t2.id LEFT JOIN user t3 ON t1.generated_by=t3.uid WHERE t1.uid='$uid' OR t1.generated_by='$uid' OR t1.transfer_uid='$uid' ORDER BY t1.recid DESC";
  //    $pager = new PS_Pagination($link, $query, 20, 5, "type=".$type);
//    $pager->setDebug(true);
       $rs = mysqli_query($connection, $query);
    if($rs){
    ?>
                              <?php
//                    $query = "SELECT * FROM `bank_details` WHERE `uid`='" . $uid . "' ORDER BY `datetime` DESC";
                   
//                    $rs = mysqli_query($connection, $query);
                    $i=1;
//                    if ($rs) {
                        while($row=  mysqli_fetch_object($rs)){
                    $transfer = get_user_detail($row->transfer_uid);
                    $user = get_user_detail($row->uid);
                            ?>
                             <tr <?php //if($i%2){echo "class='light'";}else{echo "class='dark'";}?>>
                    <td><input type="checkbox" name="list" value="<?php echo $row->recid;?>" <?php if($row->status=="used"){echo "disabled='disabled'";}?> style="width: auto;" /></td>
                    <td><?php echo $i; ?></td>
                    <td><?php echo $row->transfer_datetime=="0000-00-00 00:00:00" ? '':date("d/m/Y h:i A", strtotime($row->transfer_datetime));?></td>
                    <td><?php echo $row->used_datetime=="0000-00-00 00:00:00" ? '':date("d/m/Y h:i A", strtotime($row->used_datetime));?></td>
                    <td><?php echo $row->pinumber;?></td> 
                    <td><?php echo $row->package_name. " ($row->package_amount)";?></td>
                    
                    <td><?php echo $row->amount;?></td>
                    <td><?php if($row->status=='transfer'){echo $row->status." (".$transfer->login_id.")";}elseif($row->status=='used'){echo $row->status." (".$user->login_id.")";}else{echo $row->status;}?></td>
                    
                     
                                     <td><?php echo $row->generated_by;?></td>

</tr>
                            <?php
                            $i++;
    }  
                    }
                    ?>
                </tbody>
            </table>
            <?php //echo $pager->renderFullNav(); ?>  
                </div>
            </div>
        </div> 
    </div>

<div class="container-fluid">

<div class="row">
            <div class="col-sm-12">
                <div class="page-title-box">
                    <h4 class="page-title">Transfer Pin To Users</h4>
                  
                </div>
            </div>
        </div>

<div class="row">
            <div class="col-12">
                <div class="card m-b-20">
                          <div class="card-body">
                    
                       
                        <div class="form-group row">
                            
                            <label class="col-sm-2 col-form-label" for="uid">Enter User Id </label>

                            <div class="col-sm-10">
                                <input class="form-control" type="text" name="uid" id="uid" required="required" maxlength="20"/>

</div>
                        </div>
                        <div class="form-group">
                            <div>

                                <button type="button" name="submit" id="submit" onClick="transfer();" value="Transfer"  class="btn btn-primary waves-effect waves-light">
                                    Transfer
                                </button>
                                
                            </div>
                        </div>

</div>

</div>
            </div> 
        </div>

</div> 
</form>

<div id="myModal" class="modal fade" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
        <div class="modal-dialog">
            <div class="modal-content">
                <form class="form-horizontal" id="activate_pin_form" method="post">
                    <div class="modal-header">
                        <h5 class="modal-title mt-0" id="myModalLabel">Activate account by Pin wallet</h5>
                        <button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
                    </div>
                    <div class="modal-body">

<div class="form-group">
                            <label class="control-label col-sm-2" for="login_id">Login Id:</label>
                            <div class="col-sm-10">
                                <input type="text" class="form-control" name="login_id" onblur="get_user_detail_by_value(this.value);" id="login_id" placeholder="Enter login id">
                            </div>
                            <div class="col-sm-10" id="loginInfo">
                            </div>
                             <div class="col-sm-10" id="is_paid">
                            </div>
                        </div>
                        <div class="form-group">
                            <label class="control-label col-sm-2" for="pwd">Pin No:</label>
                            <div class="col-sm-10"> 
                                <input type="text" name="pin_no" class="form-control" id="pin_no" placeholder="Enter password">
                            </div>
                        </div>

</div>
                    <div class="modal-footer">
                        <button type="submit"  class="btn btn-primary waves-effect waves-light">Activate Now</button>
                        <button name="submit" id="submit" type="button" class="btn btn-secondary waves-effect" data-dismiss="modal">Close</button>
                    </div>
                </form>
            </div>
        </div>
    </div>
   
    
   <?php //}?>
    
  
<?php include('footer.php');?>

/home2/wtmwscom/public_html/static/../css/../member/pin.php