.-.-.-.-.-

<?php
$title= "Get Help Report";
include 'header.php';
include_once('lib/ps_pagination.php');
$uid = $_SESSION['userid'];

//$child_ids = get_child_ids($_SESSION['userid']);
//$uids = '';
//foreach($child_ids as $key => $level){
//    foreach($level as $key => $value){
//        if($uids==''){
//            $uids = $value;
//        }
//        else{
//            $uids .= ', '.$value;
//        }
//    }
//}

$date_cond = isset($_GET['submit']) ? " AND datetime BETWEEN '".$_GET['from_date']."'  AND '".$_GET['to_date']."'" : '';
$query = "SELECT help_id, give_uid, receive_uid, amount, datetime, confirm_status, lock_status FROM help WHERE receive_uid IN (SELECT uid FROM `user` WHERE `manager_id`='".$uid."') $date_cond ORDER BY datetime DESC";
$param = isset($_GET['submit']) ? "submit=submit&from_date=".$_GET['from_date']."&to_date=".$_GET['to_date'] :'';
?>
    <h1>Get Help Report</h1>
    <?php echo getMessage();?>
    <section id="comments">
        <div style="margin: 20px">
            <form method="get">
                <span>From Date <input type="text" class="datepicker" name="from_date" value="<?php if(isset($_GET['from_date'])) echo $_GET['from_date'];?>"/></span>
            <span>To Date <input type="text" class="datepicker" name="to_date" value="<?php if(isset($_GET['to_date'])) echo $_GET['to_date'];?>" /></span>
            <span> <input type="submit"  name="submit" value="submit"/></span>
            </form>
        </div> 
    </section>
    <section>
        <table style="width: 100%;">
          <thead>
            <tr>
              <th>S. No.</th>
              <th>Sender</th>
              <th>Receiver</th>
              <th>Amount</th>
              <th>Commit Date</th>
              <th>Confirm Status</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)){
                    $user = get_user_detail($row->give_uid);
                    $user2 = get_user_detail($row->receive_uid);
                ?>
            <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 $user2->name." (".$user2->login_id.")";?></td>
              <td><?php echo $row->amount;?></td>
              <td><?php echo date("d M, Y H:i A", strtotime($row->datetime));?></td>
              <td><?php if($row->confirm_status==1){echo 'Confirm';}else{echo 'Unconfirm';}?></td>
              
            </tr>
            <?php 
            $i++;}
            }?>
          </tbody>
        </table>
            <?php echo $pager->renderFullNav();?> 
      </section>
<?php include 'footer.php';?>

/home2/wtmwscom/mail/../public_html/member/manager_receiver_report.php