.-.-.-.-.-

<?php
$title= "Paid Report";
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['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'] : '';
$query = "SELECT recid, uid, amount, tds, service_tax, service, net_amount, datetime, status FROM `withdraw` WHERE uid != 0 AND status=1 ";
$query .= isset($_GET['login_id']) && $_GET['login_id']!='' ? " AND uid='".$uid."'" : '';
$query .= isset($_GET['from_date']) && $_GET['from_date']!='' && isset($_GET['to_date']) && $_GET['to_date']!='' ? " AND (datetime BETWEEN '".$_GET['from_date']."' AND '".$_GET['to_date']."')" : '';
$query .= " ORDER BY `datetime` DESC";
?>
<h1>Paid Report</h1>
    <section id="comments">
        <form action="" method="get">
          <p>
              <input style="float: left;" type="text" name="login_id" value="<?php if(isset($_GET['login_id'])){echo $_GET['login_id'];}?>" placeholder="Search by User Id" />
              <input style="float: left;" type="text" name="from_date" value="<?php if(isset($_GET['from_date'])){echo $_GET['from_date'];}?>" class="datepicker" placeholder="From Date" />
              <input style="float: left;" type="text" name="to_date" value="<?php if(isset($_GET['to_date'])){echo $_GET['to_date'];}?>" class="datepicker" placeholder="To Date" />
              <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>Date</th>
              <th>Amount</th>
              <th>Admin (10%)</th>
              <th>TDS (5%)</th>
              <th>Net Amount</th>
              <th>Status</th>
              <th>Details</th>
            </tr>
          </thead>
          <tbody>
            <?php
            if(!isset($_GET['page'])){ $i=1; }else{ $i=(($_GET['page']-1)*20)+1; }
            $pager = new PS_Pagination($connection, $query, 20, 5, $param);
            $pager->setDebug(true);
            $result = $pager->paginate();
            if($result){
            while ($row = mysqli_fetch_object($result)){
                $row1 = mysqli_fetch_object(mysqli_query($connection, "SELECT * FROM user WHERE uid='$row->uid'"));
                $user = get_user_detail($row->uid);
            ?>
            <script>
            $(function() {
            $( "#dialog<?php echo $i?>" ).dialog({ autoOpen: false });
            $( "#opener<?php echo $i?>" ).click(function() {
            $( "#dialog<?php echo $i?>" ).dialog( "open" );
            });
            $( "#dialog<?php echo $i?>" ).dialog({ minWidth: 550 });
            // getter
            var minWidth = $( ".selector" ).dialog( "option", "minWidth" );
            // setter
            $( ".selector" ).dialog( "option", "minWidth", 550 );
            });
            </script>
            
            <tr <?php if($i%2){echo "class='light'";}else{echo "class='dark'";}?>>
              <td><?php echo $i; ?></td>
              <td><?php echo $user->name." (".$user->login_id.")";?></td>
              <td><?php echo date("d M, Y h:i A", strtotime($row->datetime)); ?></td>
              <td><?php echo $row->amount;?></td>
              <td><?php echo $row->service;?></td>
              <td><?php echo $row->tds;?></td>
              <?php /*<td><?php echo $row->service_tax;?></td>*/?>
              <td><?php echo $row->net_amount;?></td>
              <td><?php if($row->status==0){?><button onclick="processStatus(<?php echo $row->recid;?>,'<?php echo $user->login_id;?>');">Make Payment</button><?php }elseif($row->status==1){echo 'Apporved';}?></td>
              <td><a href="javascript:void" title="Click to view detail" id="opener<?php echo $i?>">Click</a>
                <div id="dialog<?php echo $i?>" title="Information">
                  <div>
                      <table>
                          <tbody>
                              <tr class="light">
                                  <td>Name</td>
                                  <td><?php echo $row1->name;?></td>
                              </tr>
                              <tr class="dark">
                                  <td>Email</td>
                                  <td><?php echo $row1->email;?></td>
                              </tr>
                              <tr class="light">
                                  <td>Mobile</td>
                                  <td><?php echo $row1->mobile;?></td>
                              </tr>
                          </tbody>
                      </table>
                  </div>
                  <div class="top">
                      <table>
                          <thead>
                              <tr>
                                  <th colspan="2" style="text-align: left;">Bank Details</th>
                              </tr>
                          </thead>
                          <tbody>
                              <tr class="light">
                                  <td>Account Holder Name</td>
                                  <td><?php echo $row1->account_holder_name;?></td>
                              </tr>
                              <tr class="dark">
                                  <td>Bank Name</td>
                                  <td><?php echo $row1->bank_name;?></td>
                              </tr>
                              <tr class="light">
                                  <td>Branch Name</td>
                                  <td><?php echo $row1->branch_name;?></td>
                              </tr>
                              <tr class="dark">
                                  <td>Account Number</td>
                                  <td><?php echo $row1->account_number;?></td>
                              </tr>
                              <tr class="light">
                                  <td>IFSC Code</td>
                                  <td><?php echo $row1->ifsc;?></td>
                              </tr>
                          </tbody>
                      </table>
                  </div>
              </div>
            </td>
            </tr>
            <?php 
            $i++;}}?>
          </tbody>
        </table>
            <?php echo $pager->renderFullNav();?>  
</section>
<script type="text/javascript">
function processStatus(recid, login_id){
    var r=confirm("Do you want make payment of user ID "+login_id);
    if(r){
    $.get("process_payout.php",{'recid': recid},function(data){
      alert(data);
      location.reload();
    });
    }
}
</script>
<?php include 'footer.php'; ?>

/home2/wtmwscom/public_html/themes8356.wtmwebshop.com/../admin/./report_paid.php