.-.-.-.-.-

<?php
$title= "Reward 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='';
$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 b.`uid`, sum(b.`matching_amount`) as matching_amount, u.name as name, u.login_id as login_id FROM binary_income b INNER JOIN user u ON b.uid = u.uid WHERE b.uid != 0 ";
$query .= isset($_GET['login_id']) && $_GET['login_id']='' ? " AND u.login_id='".$_GET['login_id']."'" : '';
//$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 .= " GROUP BY b.`uid`";
?>
    <h1>Matching Club Bonus</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 type="submit" id="submit" value="Search">
          </p>
        </form>
    </section>
    <section>
        <table style="width: 100%;">
          <thead>
            <tr>
              <th>S. No.</th>
              <th>User</th>
              <th>Amount</th>
              <th>Award</th>
            </tr>
          </thead>
          <?php
            //$pager = new PS_Pagination($connection, $query, 20, 5, $param);
            //$pager->setDebug(true);
            //$result = $pager->paginate();
          $result = mysqli_query($connection, $query);
            if($result){
          ?>
          <tbody>
            <?php
                //if(!isset($_GET['page'])){ $i=1; }else{ $i=(($_GET['page']-1)*20)+1; }
            $i=1;
                while ($row = mysqli_fetch_object($result)){
                  
                   $matching_amount = $row->matching_amount;
               
                    ?>
              
               
            
                <?php 
                if($matching_amount >=200000 && $matching_amount <500000) {
                    ?>
              
            <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><?php echo $matching_amount;?> </td>
              <td>TOWER FAN</td>
            </tr>
            
                <?php } 
                if($matching_amount >= 500000 && $matching_amount < 1000000) {
                    ?>
              
            <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><?php echo $matching_amount;?> </td>
              <td>BIKE / FOREIGN TOUR</td>
            </tr>
            
                <?php } 
                if($matching_amount >=1000000 && $matching_amount <2500000) {
                    ?>
              
            <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><?php echo $matching_amount;?> </td>
              <td>TWO WHEELER BIKE</td>
            </tr>
            
                <?php } 
                if($matching_amount >=2500000 && $matching_amount < 5000000) {
                    ?>
              
            <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><?php echo $matching_amount;?> </td>
              <td>TWO WHEELER BIKE</td>
            </tr>
            
                <?php } 
                if($matching_amount >=5000000 && $matching_amount <10000000) {
                    ?>
              
            <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><?php echo $matching_amount;?> </td>
              <td>ALTO CAR</td>
            </tr>
            
                <?php } 
                if($matching_amount >=10000000) {
                    ?>
              
            <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><?php echo $matching_amount;?> </td>
              <td>FLAT</td>
            </tr>
            
                <?php } ?>
            <?php $i++;}?>
          </tbody>
          <?php }?>
        </table>
        <?php //echo $pager->renderFullNav();?>
      </section>
<?php include 'footer.php';?>

/home2/wtmwscom/public_html/themes1582.wtmwebshop.com/6538c/../../admin/report_reward_matching.php