<?php session_start();

include("includes/database.php");

if(isset($_POST['get_optiona']))

{



  $page_plan = $_POST['get_optiona'];





   $select_query_view = "select * from member where user_id='$page_plan'";

      $run_view = mysqli_query($con,$select_query_view);



      $check_sposor_id = mysqli_num_rows($run_view);



       while ($row_view = mysqli_fetch_array($run_view)) { 

        $member_no = $row_view['member_no'];

      }







  $select_query_voucher_bonus = "select SUM(total_amount) from wallet_payout where member_no = '$member_no' AND status='0'";

  $run_voucher_bonus = mysqli_query($con,$select_query_voucher_bonus);

  while($row_voucher_bonus = mysqli_fetch_array($run_voucher_bonus)){ 



        $total_voucher_bonus = $row_voucher_bonus['SUM(total_amount)']; 

        

  }



  $select_query_voucher_balance = "select SUM(amount) from cart_balance where member_no = '$member_no'";

  $run_voucher_balance = mysqli_query($con,$select_query_voucher_balance);

  while($row_voucher_balance = mysqli_fetch_array($run_voucher_balance)){ 



        $total_voucher_balance = $row_voucher_balance['SUM(amount)']; 

        

  } 



  $available_balance_amt = $total_voucher_bonus+$total_voucher_balance;



   

  ?>



                  

  <div class="form-check">

    <input class="form-check-input" type="checkbox" name="voucher" value="1" id="flexCheckDefault">

    <label class="form-check-label" for="flexCheckDefault">

      Voucher Balance = Rs.<?= $available_balance_amt+0; ?>

    </label>

  </div>



 <?php

  

 exit;



}

?>