1#@!#!123s

: / home5 / rakcha / public_html / app /
Filename : direct_referrals.php
back
<?php error_reporting(0); ?><?php 

session_start();

 if (!isset($_SESSION['distributor_id'])) {

    header("location: login.php");

 }

 else {

  include("includes/database.php");

       $page_user = $_SESSION['distributor_id'];

       $select_query = "select * from member where user_id='$page_user'";

       $run = mysqli_query($con,$select_query);

       $serial = 1;

       while ($row = mysqli_fetch_array($run)) {

        $s_num = $serial++;

        $member_id = $row['member_id'];

        $profile = $row['profile'];

        $title = $row['title'];

        $dob = $row['dob'];

        $name = $row['name'];

        $gender = $row['gender'];

        $address_1 = $row['address_1'];

        $address_2 = $row['address_2'];

        $town_area = $row['town_area'];

        $city_district = $row['city_district'];

        $state = $row['state'];

        $country = $row['country'];

        $pincode = $row['pincode'];

        $mobile_number = $row['mobile_number'];

        $email = $row['email'];

        $aadhaar_card = $row['aadhaar_card'];

        $pan_card = $row['pan_card'];

        $nominee_name = $row['nominee_name'];

        $nominee_relationship = $row['nominee_relationship'];

        $account_name = $row['account_name'];

        $account_number = $row['account_number'];

        $ifsc_code = $row['ifsc_code'];

        $bank_name = $row['bank_name'];

        $branch_name = $row['branch_name'];



        $member_no = $row['member_no'];

        $user_id = $row['user_id'];

        $password = $row['password'];

        $contact_status = $row['contact_status'];



        $aadhaar_card_image = $row['aadhaar_card_image'];

        $pan_card_image = $row['pan_card_image'];

        $bank_proof_image = $row['bank_proof_image'];

        $document_status = $row['document_status'];

        $activity_level = $row['activity_level'];

        $activity_referral = $row['activity_referral'];

        $activity_date = $row['activity_date'];

        $activity_month = $row['activity_month'];



        $member_fess = $row['member_fess'];

        $elite_board = $row['elite_board'];



        $aadhaar_card_image = $row['aadhaar_card_image'];

        $pan_card_image = $row['pan_card_image'];

        $bank_proof_image = $row['bank_proof_image'];

        $document_status = $row['document_status'];

        $date_of_join_1 =$row['date_of_join'];

        $date_of_join = date('d-m-Y', strtotime($date_of_join_1));



        $select_query_main = "select * from roi_tree where member_no='$member_no' ORDER BY tree_id ASC limit 1";

        $run_main = mysqli_query($con,$select_query_main);

         

         while ($row_main = mysqli_fetch_array($run_main)) {

          $tree_id_main = $row_main['tree_id'];                                    

          $group_number_main = $row_main['group_number'];

          $member_no_main = $row_main['member_no'];

          $user_id_main = $row_main['user_id'];

          $sponsor_no_main = $row_main['sponsor_no'];

          $relation_ship_no_main = $row_main['relation_ship_no'];

          $level_no_main = $row_main['level_no'];

      

          $x_position_main = $row_main['x_position'];

          $y_position_main = $row_main['y_position'];

          $roi_amount_main = $row_main['roi_amount'];

          $product_amount_main = $row_main['product_amount'];

          $x_position_main_my = $row_main['x_position']+1;

          $roi_status_main = $row_main['roi_status'];

          $arr1 = array();

                $select_query_findempty_pay = "select * from roi_member where member_no = '$member_no_main'";

                $run_findempty_pay = mysqli_query($con,$select_query_findempty_pay);

                while ($row_findempty_pay = mysqli_fetch_array($run_findempty_pay)) {

                 $arr1[] = $row_findempty_pay['used_no'];

                }





                if ($roi_status_main == 0) {

                   $personal_pv_join = $roi_amount_main;

                }

                else {

                  $personal_pv_join = 0;

                }



                $total_personal_pv = $personal_pv_join+$product_amount_main;



  ?><!DOCTYPE html>

<html lang="en">



<head>

  <meta charset="UTF-8">

  <meta content="width=device-width, initial-scale=1, maximum-scale=1, shrink-to-fit=no" name="viewport">

  <title>RAKCHABLOOMING</title>

  <!-- General CSS Files -->

  <link rel="stylesheet" href="assets/css/app.min.css">

  <!-- Template CSS -->

  <link rel="stylesheet" href="assets/bundles/datatables/datatables.min.css">

  <link rel="stylesheet" href="assets/bundles/datatables/DataTables-1.10.16/css/dataTables.bootstrap4.min.css">

  <link rel="stylesheet" href="assets/css/style.css">

  <link rel="stylesheet" href="assets/css/components.css">

  <!-- Custom style CSS -->

  <link rel="stylesheet" href="assets/css/custom.css">

  <link rel='shortcut icon' type='image/x-icon' href='assets/img/favicon.ico' />

  <style type="text/css">

    tr th, tr td{

      background-color: #fff !important;

    }

  </style>

</head>



<body>

  <div class="loader"></div>

  <div id="app">

    <div class="main-wrapper main-wrapper-1">

      <div class="navbar-bg"></div>

      <?php include("includes/header.php"); ?>

      <!-- Main Content -->

      <div class="main-content">

        <section class="section">

          <div class="section-body">

            <div class="row">

              <div class="col-12">

                <div class="card">

                  <div class="card-header">

                    <h4>Direct Line</h4>

                     

                  </div>

                  <div class="card-body">

                    <div class="table-responsive">

                      <table class="table table-striped table-hover" id="table-s" style="width:100%;">

                        <thead>

                          <tr>

                          <th>View</th>

                          <th>Level</th>

                          <th>RC ID</th>

                          <th>Name</th>

                          

                           

                           

                          

                          <th>PPV</th>

                          <th>CGBV</th>

                          <th>AGBV</th> 

                          <th>% LEVEL</th>

                          <th>NBL</th>

                          <th>2%</th>

                          <th>4%</th>

                          <th>6%</th>

                          <th>9%</th> 

                           <th>New Join</th>

                           <th>Active Base</th>

                           <th>Joining Date</th>

                           <th>Total Con.</th>

                          

                          

                          

                          

                       

                          <?php if ($contact_status == 1) { ?>

                           <th>Contact No</th>

                           <?php } ?>

                         

                          </tr>

                        </thead>

                        <tbody>

                              <?php 



                                  $select_query_main_10a = "select * from roi_tree where group_number = '$group_number_main' AND x_position = '$x_position_main_my' AND relation_ship_no LIKE '%{$relation_ship_no_main}%' AND tree_id > '$tree_id_main'";



                                    $run_main_10a = mysqli_query($con,$select_query_main_10a);



                                    $check_level_10a = mysqli_num_rows($run_main_10a);



                                    if ($check_level_10a > 0) {



                                    while ($row_main_10a = mysqli_fetch_array($run_main_10a)) {                                   



                                    $tree_id_main_10a = $row_main_10a['tree_id'];



                                    $group_number_main_10a = $row_main_10a['group_number'];



                                    $member_no_main_10a = $row_main_10a['member_no'];



                                    $sponsor_no_main_10a = $row_main_10a['sponsor_no'];



                                    $level_no_main_10a = $row_main_10a['level_no'];



                                    $relation_ship_no_main_10a = $row_main_10a['relation_ship_no'];



                                    $x_position_main_10a = $row_main_10a['x_position'];

                                    $roi_amount_main_10a = $row_main_10a['roi_amount'];

                                    $product_amount_main_10a = $row_main_10a['product_amount'];

                                    $x_position_main_my_10a = $row_main_10a['x_position']+1;

                                    $roi_status_main_my_10a = $row_main_10a['roi_status'];

                                    $percent_amount = $row_main_10a['percent'];





                                    if ($roi_status_main_my_10a == 0) {

                                         $personal_pv_join = $roi_amount_main_10a;

                                      }

                                      else {

                                        $personal_pv_join = 0;

                                      } 

                                    $total_personal_pv = $personal_pv_join;                                  

                                   $select_query_select_10a = "select * from member where member_no ='$member_no_main_10a'";



                                  $run_select_10a = mysqli_query($con,$select_query_select_10a);

                                    while ($row_select_10a = mysqli_fetch_array($run_select_10a)) {

                                    $name_row_select_10a = $row_select_10a['name'];

                                    

                                    $user_id_row_select_10a = $row_select_10a['user_id'];

                                    $date_of_join_row_select_10a =$row_select_10a['date_of_join'];

                                    $city_district_row_select_10a =$row_select_10a['city_district'];

                                    $mobile_number_row_select_10a =$row_select_10a['mobile_number'];                                    

                                    $state_row_select_10a =$row_select_10a['state'];

                                      }





                                 $current_xpoision_10a = $x_position_main_10a-$x_position_main;





                                 $arr1_10a = array();

                                  $select_query_findempty_pay_10a = "select * from roi_member where member_no = '$member_no_main_10a'";

                                  $run_findempty_pay_10a = mysqli_query($con,$select_query_findempty_pay_10a);

                                  while ($row_findempty_pay_10a = mysqli_fetch_array($run_findempty_pay_10a)) {

                                   $arr1_10a[] = $row_findempty_pay_10a['used_no'];

                                  }





                                  $arr1_10a_pro = array();

                                  $select_query_findempty_pay_10a_pro = "select * from product_member where member_no = '$member_no_main_10a'";

                                  $run_findempty_pay_10a_pro = mysqli_query($con,$select_query_findempty_pay_10a_pro);

                                  while ($row_findempty_pay_10a_pro = mysqli_fetch_array($run_findempty_pay_10a_pro)) {

                                   $arr1_10a_pro[] = $row_findempty_pay_10a_pro['used_no'];

                                  }



                                  //get_product_bv



                                  $select_query_per_product_x1_10a = "select SUM(product_amount) from product_tree where member_no='$member_no_main_10a' AND product_no not in (".implode(',', $arr1_10a_pro).") AND status='0'";

                                  $run_per_product_x1_10a = mysqli_query($con,$select_query_per_product_x1_10a);

                                  while($row_per_product_x1_10a = mysqli_fetch_array($run_per_product_x1_10a)){

                                        $p_per_product_x1_10a = $row_per_product_x1_10a['SUM(product_amount)'];

                                  }



                                  $select_query_cur_product_x1_10a = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_10a}%' AND product_no not in (".implode(',', $arr1_10a_pro).") AND status='0'";

                                  $run_cur_product_x1_10a = mysqli_query($con,$select_query_cur_product_x1_10a);

                                  while($row_cur_product_x1_10a = mysqli_fetch_array($run_cur_product_x1_10a)){

                                        $p_cur_product_x1_10a = $row_cur_product_x1_10a['SUM(product_amount)'];

                                  }

                                  



                                  $select_query_product_x1_10a = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_10a}%'";

                                  $run_product_x1_10a = mysqli_query($con,$select_query_product_x1_10a);

                                  while($row_product_x1_10a = mysqli_fetch_array($run_product_x1_10a)){

                                        $p_product_x1_10a = $row_product_x1_10a['SUM(product_amount)'];

                                  }



                                  //get_product_bv

                            

                              



                                $select_query_total_x1a_10a = "select SUM(roi_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_10a}%' AND member_no not in (".implode(',', $arr1_10a).") AND tree_id > '$tree_id_main_10a'";

                                $run_total_x1a_10a = mysqli_query($con,$select_query_total_x1a_10a);

                                while($row_total_x1a_10a = mysqli_fetch_array($run_total_x1a_10a)){

                                      $total_x1a_1_10a = $row_total_x1a_10a['SUM(roi_amount)'];

                                      

                                }

                                $total_x1a_10a = $total_x1a_1_10a+$p_cur_product_x1_10a+$total_personal_pv;





                                //group pv

                              $select_query_total_team_pv_10a = "select SUM(roi_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_10a}%'";

                              $run_total_team_pv_10a = mysqli_query($con,$select_query_total_team_pv_10a);

                              while($row_total_team_pv_10a = mysqli_fetch_array($run_total_team_pv_10a)){

                                    $total_team_pv_1_10a = $row_total_team_pv_10a['SUM(roi_amount)'];

                                  

                                    

                              }

                              

                              $final_group_pv_10a = $total_team_pv_1_10a+$p_product_x1_10a;

                            //group pv



                              //member details

                               $select_query_total_member_last_10a = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_10a}%' AND tree_id > '$tree_id_main_10a'";

                                $run_total_member_last_10a = mysqli_query($con,$select_query_total_member_last_10a);

                                $final_total_member_last_10a = mysqli_num_rows($run_total_member_last_10a);



                                $select_query_total_member_current_10a = "select * from roi_tree where  relation_ship_no LIKE '%{$relation_ship_no_main_10a}%' AND tree_id > '$tree_id_main_10a' AND member_no not in (".implode(',', $arr1_10a).") AND status='1'";

                                $run_total_member_current_10a = mysqli_query($con,$select_query_total_member_current_10a);

                                $final_total_member_current_10a = mysqli_num_rows($run_total_member_current_10a);



                                $previuos_add_10a = $final_total_member_last_10a-$final_total_member_current_10a;

                            //member details





                                $select_query_total_curt_10a = "select SUM(product_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main}%' AND tree_id > '$tree_id_main' AND x_position='$x_position_main_10a'";

                                $run_total_curt_10a = mysqli_query($con,$select_query_total_curt_10a);

                                while($row_total_curt_10a = mysqli_fetch_array($run_total_curt_10a)){

                                      $total_curt_10a = $row_total_curt_10a['SUM(product_amount)'];

                                      

                                }



                                $select_query_total_curta_10a = "select SUM(roi_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main}%' AND tree_id > '$tree_id_main' AND member_no not in (".implode(',', $arr1).") AND x_position='$x_position_main_10a'";

                                $run_total_curta_10a = mysqli_query($con,$select_query_total_curta_10a);

                                while($row_total_curta_10a = mysqli_fetch_array($run_total_curta_10a)){

                                      $total_curta_1_10a = $row_total_curta_10a['SUM(roi_amount)'];

                                      

                                }

                                $total_curta_10a = $total_curta_1_10a+$total_curt_10a;





                                 





                               // get percent member



                               $select_query_total_member_get_per6 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_10a}%' AND tree_id > '$tree_id_main_10a' AND percent='2'";

                                $run_total_member_get_per6 = mysqli_query($con,$select_query_total_member_get_per6);

                                $final_total_member_get_per6 = mysqli_num_rows($run_total_member_get_per6);



                                $select_query_total_member_get_per10 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_10a}%' AND tree_id > '$tree_id_main_10a' AND percent='4'";

                                $run_total_member_get_per10 = mysqli_query($con,$select_query_total_member_get_per10);

                                $final_total_member_get_per10 = mysqli_num_rows($run_total_member_get_per10);





                                $select_query_total_member_get_per14 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_10a}%' AND tree_id > '$tree_id_main_10a' AND percent='6'";

                                $run_total_member_get_per14 = mysqli_query($con,$select_query_total_member_get_per14);

                                $final_total_member_get_per14 = mysqli_num_rows($run_total_member_get_per14);





                                $select_query_total_member_get_per18 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_10a}%' AND tree_id > '$tree_id_main_10a' AND percent='9'";

                                $run_total_member_get_per18 = mysqli_query($con,$select_query_total_member_get_per18);

                                $final_total_member_get_per18 = mysqli_num_rows($run_total_member_get_per18);





                                $select_query_total_member_get_per22 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_10a}%' AND tree_id > '$tree_id_main_10a' AND percent='15'";

                                $run_total_member_get_per22 = mysqli_query($con,$select_query_total_member_get_per22);

                                $final_total_member_get_per22 = mysqli_num_rows($run_total_member_get_per22);





                                $select_query_total_member_get_per23 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_10a}%' AND tree_id > '$tree_id_main_10a' AND percent='21'";

                                $run_total_member_get_per23 = mysqli_query($con,$select_query_total_member_get_per23);

                                $final_total_member_get_per23 = mysqli_num_rows($run_total_member_get_per23);



                               // get percent member



                                $select_query_growth_2 = "select * from roi_tree where rank >= '1' AND relation_ship_no LIKE '%{$relation_ship_no_main_10a}%' AND tree_id > '$tree_id_main_10a' AND x_position > '$x_position_main_10a'";

                                $run_growth_2 = mysqli_query($con,$select_query_growth_2);

                                $check_level_growth_2 = mysqli_num_rows($run_growth_2);

                                    

                                

                                 



                                $select_query_active_base = "select * from roi_tree where roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main}%' AND tree_id > '$tree_id_main' AND x_position >= '$x_position_main_my' AND active_base='1'";

                                $run_active_base = mysqli_query($con,$select_query_active_base);

                                $check_level_active_base = mysqli_num_rows($run_active_base);

                                    



                               ?>







                            <tr>



                              <td><a href="downline_view.php?member_no=<?= $member_no_main_10a; ?>" class="badge bg-blue">Lifeline</a></td>



                              <td>

                                <?php 

                                  for ($i=1; $i <= $current_xpoision_10a; $i++) { 

                                    echo ".";

                                  }

                                ?>

                                 <?= $current_xpoision_10a; ?></td>



                             

                                <td><?= $user_id_row_select_10a; ?></td>

                                <td style="text-transform: uppercase;"><?= $name_row_select_10a; ?></td>

                                

                                

                                <td><?= $total_personal_pv+$p_per_product_x1_10a; ?></td>

                                <td><?= $total_x1a_10a; ?></td>

                                <td>



                                <?php



                                  if ($percent_amount < 9) {

                                   echo $final_group_pv_10a;

                                  }

                                  else {

                                    echo "9%";

                                  }



                                 



                                 ?>

                                  



                                </td>

                                

                                 

                                <td><?= $percent_amount; ?></td>

                                <td></td>

                                <td><?= $final_total_member_get_per6; ?></td>

                                <td><?= $final_total_member_get_per10; ?></td>

                                <td><?= $final_total_member_get_per14; ?></td> 

                                <td><?= $final_total_member_get_per18; ?></td> 





                                <td><?= $final_total_member_current_10a; ?></td>

                                <td><?= $check_level_active_base+$final_total_member_current_10a; ?></td>

                                <td><?= $date_of_join_row_select_10a; ?></td>

                                <td><?= $final_total_member_last_10a; ?></td>

                                

                                

                               

                                <?php if ($contact_status == 1) { ?>

                                <td><?= $mobile_number_row_select_10a; ?></td>

                                <?php } ?>

                                

                                

                           </tr>



                             <?php } } ?>



                             



                             



                             

                           

                        </tbody>

                      </table>

                    </div>

                  </div>

                </div>

              </div>

            </div>

          </div>

        </section>

        

      </div>

      <footer class="main-footer">

        <div class="footer-left">

          Copyright &copy; 2021 <div class="bullet"></div> All Rights Reserved.

        </div>

        <div class="footer-right">

        </div>

      </footer>

    </div>

  </div>

  <!-- General JS Scripts -->

  <script src="assets/js/app.min.js"></script>

  <!-- JS Libraies -->

  <!-- Page Specific JS File -->

  <script src="assets/bundles/datatables/datatables.min.js"></script>

  <script src="assets/bundles/datatables/DataTables-1.10.16/js/dataTables.bootstrap4.min.js"></script>

  <script src="assets/bundles/datatables/export-tables/dataTables.buttons.min.js"></script>

  <script src="assets/bundles/datatables/export-tables/buttons.flash.min.js"></script>

  <script src="assets/bundles/datatables/export-tables/jszip.min.js"></script>

  <script src="assets/bundles/datatables/export-tables/pdfmake.min.js"></script>

  <script src="assets/bundles/datatables/export-tables/vfs_fonts.js"></script>

  <script src="assets/bundles/datatables/export-tables/buttons.print.min.js"></script>

  <script src="../admin/assets/js/fixedheader.js" ></script>

    <script src="../admin/assets/js/fixedcolunm.js" ></script>

  <script src="assets/js/page/datatables.js"></script>

  <!-- Template JS File -->

  <script src="assets/js/scripts.js"></script>

  <!-- Custom JS File -->

  <script src="assets/js/custom.js"></script>

  <script type="text/javascript">

    function goBack() {

        window.history.back();

    }



    $(document).ready(function() {

    var table = $('#table-s').DataTable( {

        scrollY:        "400px",

        scrollX:        true,

        scrollCollapse: true,

        paging:         false,

        fixedHeader: {

            header: true

        }

    } );

} );

    </script>

</body>



</html>



<?php } } } ?>