.-.-.-.-.-

<?php
$title= "Reward Report";
include 'header.php';
include_once('lib/ps_pagination.php');
$uid = $_SESSION['userid'];
//$reward = array('No Reward','Silver Star','Gold Star','Ruby Star','Diamond Star','Platinum Star');
?>
    <h1>Matching Club Bonus</h1>
    <?php echo getMessage();?>
    <section>
        <table style="width: 100%;">
          <thead>
            <tr>
              <th>S. No.</th>
              <th>User</th>
              <th>Amount</th>
              <th>Award</th>
            </tr>
          </thead>
          <tbody>
          <?php
          $i=1;
          $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 = '$uid' GROUP BY b.`uid`";
           
          $row = mysqli_fetch_object(mysqli_query($connection, $query));  
           
                    $matching_amount = $row->matching_amount;
               
                
                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>
        </table>
      </section>
<?php include 'footer.php';?>

/home2/wtmwscom/public_html/member/report_reward_matching.php