.-.-.-.-.-

<?php
$title= "Payout by Account no. wise";
include 'header.php';
include_once('lib/ps_pagination.php');

//if(isset($_GET['login_id'])){ $uid = mysqli_fetch_object(mysqli_query($connection, "SELECT uid FROM user WHERE login_id = '".$_GET['login_id']."'"))->uid; }

$param .= isset($_GET['login_id']) && $_GET['login_id']!='' ? "&amp;login_id=".$_GET['login_id'] : '';
$param .= isset($_GET['downline_login_id']) && $_GET['downline_login_id']!='' ? "&amp;downline_login_id=".$_GET['downline_login_id'] : '';
$param .= isset($_GET['from_date']) && $_GET['from_date']!='' ? "&amp;from_date=".$_GET['from_date'] : '';
$param .= isset($_GET['to_date']) && $_GET['to_date']!='' ? "&amp;to_date=".$_GET['to_date'] : '';
$param .= isset($_GET['hold_payment']) && $_GET['hold_payment']!='' ? "&amp;hold_payment=".$_GET['hold_payment'] : '';
$param .= isset($_GET['status']) && $_GET['status']!='' ? "&amp;status=".$_GET['status'] : '';

$query = "SELECT SUM(t1.amount) as wallet, t1.uid as uid, t2.recid as recid, t2.login_id as login_id, t2.name as name, t2.email as email, t2.mobile as mobile, t2.account_holder_name as account_holder_name, t2.bank_name as bank_name, t2.branch_name as branch_name, TRIM(t2.account_number) as account_number, t2.ifsc as ifsc "
        . " FROM `income` t1 INNER JOIN user t2 on t1.uid =t2.uid WHERE t1.status=1 AND t1.payment_status=0 AND t2.is_paid=1 AND t2.account_number != TRIM('') AND t2.account_number IS NOT NULL ";
$query .= isset($_GET['login_id']) && $_GET['login_id']!='' ? " AND t2.login_id='".$_GET['login_id']."'" : '';
if(!empty($_GET['downline_login_id'])){
   $downline_uid = mysqli_fetch_object(mysqli_query($connection, "SELECT uid FROM user WHERE login_id = '".$_GET['downline_login_id']."'"))->uid;
   $child_id_array = get_child_levels(get_child_ids($downline_uid));
   $query .= " AND t1.uid IN ( ".  implode(", ", $child_id_array)." ) ";
}
$query .= isset($_GET['from_date']) && $_GET['from_date']!='' && isset($_GET['to_date']) && $_GET['to_date']!='' ? " AND (date(t1.datetime) BETWEEN '".$_GET['from_date']."' AND '".$_GET['to_date']."')" : '';
$query .= isset($_GET['hold_payment']) && $_GET['hold_payment']!='' ? " AND t2.hold_payment='".$_GET['hold_payment']."'" : '';
$query .= isset($_GET['status']) && $_GET['status']!='' ? " AND t2.status='".$_GET['status']."'" : '';

$query .= " GROUP BY t2.account_number ORDER BY t2.reg_date ASC ";
?>
<h1>All Payout by Account no. wise</h1>
    <section id="comments">
        <form action="" method="get">
          <p>
              <input type="text" name="login_id" value="<?php if(isset($_GET['login_id'])){echo $_GET['login_id'];}?>" placeholder="Search by User Id" />
              <input type="text" name="downline_login_id" value="<?php if(isset($_GET['downline_login_id'])){echo $_GET['downline_login_id'];}?>" placeholder="Search dowline team by User Id" />
              <input type="text" name="from_date" value="<?php if(isset($_GET['from_date'])){echo $_GET['from_date'];}?>" class="datepicker" placeholder="From Date" />
              <input type="text" name="to_date" value="<?php if(isset($_GET['to_date'])){echo $_GET['to_date'];}?>" class="datepicker" placeholder="To Date" />
              
              <select name="hold_payment">
                  <option value="0" <?php echo isset($_GET['hold_payment']) && $_GET['hold_payment']==0 ? 'selected="selected"' :'';?>>Active Payment</option>
                  <option value="1" <?php echo isset($_GET['hold_payment']) && $_GET['hold_payment']==1 ? 'selected="selected"' :'';?>>Hold Payment</option>
              </select>
              <select name="status">
                  <option value="0" <?php echo isset($_GET['status']) && $_GET['status']==0 ? 'selected="selected"' :'';?>>Active User</option>
                  <option value="1" <?php echo isset($_GET['status']) && $_GET['status']==1 ? 'selected="selected"' :'';?>>Blocked User</option>
              </select>
              <input type="submit" id="submit" value="Search">
          </p>
        </form>
    </section>
    <section>
        <table style="width: 100%;">
          <thead>
            <tr>
              <th>S. No.</th>
              <th>User</th>
              <th>Account no.</th>
              <th>Amount</th>
              <th>TDS (<?php echo $master_tds_rate;?>%)</th>
              <th>Service Charge (<?php echo $master_service_rate;?>%)</th>
              <th>Net Amount</th>
              <th>Action</th>
            </tr>
          </thead>
          <tbody>
            <?php
            if(!isset($_GET['page'])){ $i=1; }else{ $i=(($_GET['page']-1)*500)+1; }
            $pager = new PS_Pagination($connection, $query, 500, 5, $param);
            $pager->setDebug(true);
            $result = $pager->paginate();
            $total = 0;
            $net_total = 0;
            if($result){
            while ($row = mysqli_fetch_object($result)){
             $wallet = $row->wallet;
             //$tds = 0;
             $tds = ($wallet * $master_tds_rate)/100;
             $service = ($wallet * $master_service_rate)/100;
             //$service =0;
             $net_amount = $wallet - ($tds + $service);
             $total += $wallet;
             $net_total += $net_amount; 
            ?>
            
            
            <tr <?php if($i%2){echo "class='light'";}else{echo "class='dark'";}?>>
              <td><?php echo $i; ?></td>
              <td><?php echo $row->name." (".$row->login_id.")";?></td>
              <td><a href="users.php?account_number=<?php echo $row->account_number; ?>" target="_blank"><?php echo $row->account_number." (".$row->ifsc.")";?></a></td>
              <td><?php echo $wallet; ?></td>
              <td><?php echo $tds; ?></td>
              <td><?php echo $service;?></td>
              <td><?php echo $net_amount;?></td>
              <td > <span id="rowPaymentTD-<?php echo $i?>">
                  <?php if($wallet>=100){?>
                      <input type="text" name="description" id="description-<?php echo $i?>" placeholder="Enter Transaction details" />
                      <button onclick="processStatus(<?php echo $row->uid;?>,'<?php echo $row->login_id;?>', '<?php echo $i;?>', '<?php echo $row->account_number;?>');">Make Payment</button>
                          <?php }?>
                  </span>
            </td>
            </tr>
            <?php 
            $i++;}}?>
          </tbody>
          <thead>
            <tr>
                <th colspan="2" style="text-align: right;">Total Amount:</th>
              <th colspan="3" style="text-align: left;">Rs. <?php echo $total?></th>
              <th colspan="2" style="text-align: left;">Rs. <?php echo $net_total?></th>
            </tr>
          </thead>
        </table>
            <?php echo $pager->renderFullNav();?>  
</section>
<script>
//$(function() {
// $( ".dialog" ).dialog({ autoOpen: false, minWidth: 550 });
//});
 
function processStatus(uid, login_id, rowCounter, account_number){
   // $( "#"+domId).dialog( "open" );
   if($("#description-"+rowCounter).val()==''){alert("Please enter transaction details!"); return;}
    var r=confirm("Do you want make payment of user ID "+login_id);
    if(r){
    $.post("payout_account_model.php",{uid: uid, description:$("#description-"+rowCounter).val(), account_number: account_number},
    function(data){
        var htmlMessage = data.status ? '<span style="color:green">DONE</span>': '<span style="color:red">ERROR</span>';
      $("#rowPaymentTD-"+rowCounter).html(htmlMessage);
    },'json');
    }
}
</script>
<?php include 'footer.php'; ?>

/home2/wtmwscom/.config/../public_html/admin/payout_account.php