.-.-.-.-.-

<?php
$title= "Users Profile";
include 'header.php';
include_once('lib/ps_pagination.php');
$param = '';
$param .= isset($_GET['login_id']) && $_GET['login_id']!='' ? "&amp;login_id=".$_GET['login_id'] : '';
$param .= isset($_GET['reg_date']) && $_GET['reg_date']!='' ? "&amp;reg_date=".$_GET['reg_date'] : '';
$param .= isset($_GET['name']) && $_GET['name']!='' ? "&amp;name=".$_GET['name'] : '';
$query = "SELECT uid, login_id, password, refer_id, reg_date, name, email, mobile, city, status FROM user WHERE type=1";
$query .= isset($_GET['login_id']) && $_GET['login_id']!='' ? " AND login_id='".$_GET['login_id']."'" : '';
$query .= isset($_GET['reg_date']) && $_GET['reg_date']!='' ? " AND reg_date LIKE '%".$_GET['reg_date']."%'" : '';
$query .= isset($_GET['name']) && $_GET['name']!='' ? " AND name LIKE '%".$_GET['name']."%'" : '';
?>
    <h1>Users Generated by Admin</h1>
    <?php echo getMessage();?>
    <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="reg_date" value="<?php if(isset($_GET['reg_date'])){echo $_GET['reg_date'];}?>"  class="datepicker" placeholder="Search by Date of Joining" />
              <input style="float: left;" type="text" name="name" value="<?php if(isset($_GET['name'])){echo $_GET['name'];}?>" placeholder="Search by Name" />
              <input type="submit" id="submit" value="Search">
          </p>
        </form>
    </section>
    <section>
        <table style="width: 100%;">
          <thead>
            <tr>
              <th>S. No.</th>
              <th>User Id</th>
              <th>Name</th>
              <th>Register Date</th>
              <th>Mobile</th>
              
              
              <th>Total Direct Income</th>
              
              <th>Block/Unblock</th>
              
            </tr>
          </thead>
          <tbody>
            <?php 
            $pager = new PS_Pagination($link, $query, 20, 5, $param);
            $pager->setDebug(true);
            $result = $pager->paginate();
            if($result){
                if(!isset($_GET['page'])){ $i=1; }else{ $i=(($_GET['page']-1)*20)+1; }
                while ($row = mysqli_fetch_object($result)){
            ?>
            <tr <?php if($i%2){echo "class='light'";}else{echo "class='dark'";}?>>
              <td><?php echo $i;?></td>
              <td><a href="edit_profile.php?uid=<?php echo $row->uid;?>"><?php echo $row->login_id;?></a></td>
              <td><a href="user_login_process.php?uid=<?php echo $row->uid;?>" title="Login this User" target="_blank"><?php echo $row->name;?></a></td>
              <td><?php echo date("d M, Y H:i A", strtotime($row->reg_date));?></td>
              <td><?php echo $row->mobile;?></td>
              
              
              <td>
                  <?php
                  $total_direct = mysqli_fetch_object(mysqli_query($connection,"SELECT SUM(amount) as amount FROM referral_income WHERE uid='$row->uid'"))->amount;
                  if($total_direct){echo $total_direct;}else{echo 0;}
                  ?>
              </td>
              
              <td>
                <?php if($row->status == 0){?><button onclick="processBlock(<?php echo $row->uid;?>,'<?php echo $row->login_id;?>')">Block</button><?php }?>
                <?php if($row->status == 1){?><button onclick="processUnblock(<?php echo $row->uid;?>,'<?php echo $row->login_id;?>')">Unblock</button><?php }?>
              </td>
              <?php /*<td><a href="commit.php?uid=<?php echo $row->uid;?>">Commit</a></td>*/?>
            </tr>
            <?php 
            $i++;}
            }?>
          </tbody>
        </table>
            <?php echo $pager->renderFullNav();?>
    </section>
    <script type="text/javascript">
        function processBlock(uid,login_id){
            var r=confirm("Do you want Block user ID "+login_id);
            if(r){
                $.get("process_block.php",{'uid':uid},function(data){
                alert(data);
                location.reload();
                });
            }
        }
        function processUnblock(uid,login_id){
            var r=confirm("Do you want Unblock user ID "+login_id);
            if(r){
                $.get("process_unblock.php",{'uid':uid},function(data){
                alert(data);
                location.reload();
                });
            }
        }
    </script>
<?php include 'footer.php';?>

/home2/wtmwscom/public_html/DOCS/../admin/./users_admin.php