1#@!#!123s

: / home / rakcha / www / app /
Filename : leftside.php
back
<?php 

session_start();

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

    header("location: ../index.html");

 }

 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'];



        $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 member_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']+1;

                          $y_position_main = $row_main['y_position'];



                         

  ?><!DOCTYPE html>

<html lang="en">

<head>

    <meta charset="utf-8">

    <meta http-equiv="X-UA-Compatible" content="IE=edge">

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

    <title>JOURNEY PRESS - <?= $name; ?></title>

    <link rel="icon" href="assets/img/favicon.png">

    <link href="assets/css/loader.css" rel="stylesheet" type="text/css">

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

    <!-- BEGIN GLOBAL MANDATORY STYLES -->

    <link href="../../../css.css?family=Quicksand:400,500,600,700&display=swap" rel="stylesheet">

    <link href="bootstrap/css/bootstrap.min.css" rel="stylesheet" type="text/css">

    <link href="assets/css/plugins.css" rel="stylesheet" type="text/css">

    <!-- END GLOBAL MANDATORY STYLES -->    

    <!-- BEGIN PAGE LEVEL CUSTOM STYLES -->

    <link rel="stylesheet" type="text/css" href="plugins/table/datatable/datatables.css">

    <link rel="stylesheet" type="text/css" href="plugins/table/datatable/dt-global_style.css">

    <!-- END PAGE LEVEL CUSTOM STYLES -->

</head>

<body class="sidebar-noneoverflow">

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



        <!--  BEGIN CONTENT AREA  -->

        <div id="content" class="main-content">

            <div class="layout-px-spacing">

                

                <div class="row layout-top-spacing" id="cancel-row">

                    <div class="col-xl-12 col-lg-12 col-sm-12  layout-spacing">

                        <div class="widget-content widget-content-area br-6">

                            <h5 style="padding: 10px;">Leftside Member List</h5>

                            <table id="alter_pagination" class="table table-hover" style="width:100%">

                                <thead>

                                    <tr>

                                        <th>User ID</th>

                                        <th>Name</th> 

                                        <th>Join Date</th>

                                        <th>Status</th>

                                        <th> Sponsor Name </th>

                                        <th> Sponsor ID </th>

                                        <th> Package </th>

                                        <th> Rank </th>

                                    </tr>

                                </thead>

                                <tbody>

                                     <?php 

                       



                                      $select_query_get_left = "select * from member_tree where group_number = '$group_number_main' AND relation_ship_no LIKE '%{$relation_ship_no_main}%' AND x_position = '$x_position_main' AND y_position='1'";

                                      $run_get_left = mysqli_query($con,$select_query_get_left);

                                      $run_get_left_row = mysqli_num_rows($run_get_left);

                                      while ($row_get_left = mysqli_fetch_array($run_get_left)) {

                                                             

                                      $tree_id_get_left = $row_get_left['tree_id'];

                                      $group_number_get_left = $row_get_left['group_number'];

                                      $member_no_get_left = $row_get_left['member_no'];

                                      $sponsor_no_get_left = $row_get_left['sponsor_no'];

                                      $level_no_get_left = $row_get_left['level_no'];

                                      $relation_ship_no_get_left = $row_get_left['relation_ship_no'];

                                      $x_position_get_left = $row_get_left['x_position'];

                                      $y_position_get_left = $row_get_left['y_position'];

                                      }

                                      

                                   ?>

                                      <?php 

                                              

                                                

                                               if ($run_get_left_row > 0) {

                                                  



                                                $select_query_main_1 = "select * from member_tree where group_number = '$group_number_get_left' AND relation_ship_no LIKE '%{$relation_ship_no_get_left}%' ORDER BY tree_id ASC";

                                             $run_main_1 = mysqli_query($con,$select_query_main_1);

                                             while ($row_main_1 = mysqli_fetch_array($run_main_1)) {

                                                

                                                $tree_id_main_1 = $row_main_1['tree_id'];

                                                $group_number_main_1 = $row_main_1['group_number'];

                                                $member_no_main_1 = $row_main_1['member_no'];

                                                $sponsor_no_main_1 = $row_main_1['sponsor_no'];

                                                $rank_main_1 = $row_main_1['rank'];

                                                $relation_ship_no_main_1 = $row_main_1['relation_ship_no'];

                                                $x_position_main_1 = $row_main_1['x_position'];

                                                $y_position_main_1 = $row_main_1['y_position'];

                                                $status_main_1 = $row_main_1['status'];                 



                                                







                                                           

                                              $select_query_select = "select * from member where member_no ='$member_no_main_1'";

                                              $run_select = mysqli_query($con,$select_query_select);

                                              

                                               while ($row_select = mysqli_fetch_array($run_select)) {

                                                

                                                $member_id_row_select = $row_select['member_id'];

                                                $title_row_select = $row_select['title'];

                                                $dob_row_select = $row_select['dob'];

                                                $name_row_select = $row_select['name'];

                                                $gender_row_select = $row_select['gender'];

                                                $address_1_row_select = $row_select['address_1'];

                                                $address_2_row_select = $row_select['address_2'];

                                                $town_area_row_select = $row_select['town_area'];

                                                $city_district_row_select = $row_select['city_district'];

                                                $state_row_select = $row_select['state'];

                                                $country_row_select = $row_select['country'];

                                                $pincode_row_select = $row_select['pincode'];

                                                $mobile_number_row_select = $row_select['mobile_number'];

                                                $email_row_select = $row_select['email'];

                                                $aadhaar_card_row_select = $row_select['aadhaar_card'];

                                                $pan_card_row_select = $row_select['pan_card'];

                                                $nominee_name_row_select = $row_select['nominee_name'];

                                                $nominee_relationship_row_select = $row_select['nominee_relationship'];

                                                $account_name_row_select = $row_select['account_name'];

                                                $account_number_row_select = $row_select['account_number'];

                                                $ifsc_code_row_select = $row_select['ifsc_code'];

                                                $bank_name_row_select = $row_select['bank_name'];

                                                $branch_name_row_select = $row_select['branch_name'];



                                                $member_no_row_select = $row_select['member_no'];

                                                $user_id_row_select = $row_select['user_id'];

                                                $password_row_select = $row_select['password'];

                                                $aadhaar_card_image_row_select = $row_select['aadhaar_card_image'];

                                                $pan_card_image_row_select = $row_select['pan_card_image'];

                                                $bank_proof_image_row_select = $row_select['bank_proof_image'];

                                                $document_status_row_select = $row_select['document_status'];

                                                $date_of_join_row_select_1 =$row_select['date_of_join'];

                                                $date_of_join_row_select = date('d-m-Y', strtotime($date_of_join_row_select_1));



                                                             



                                                                      $query_total_ivest_upgrade_topup = "SELECT SUM(amount) FROM top_up WHERE member_no = '$member_no_row_select'";

                                                                                                // Print out result

                                                                      $result_ivest_upgrade_topup = mysqli_query($con, $query_total_ivest_upgrade_topup);



                                                                          while($row_total_ivest_upgrade_topup = mysqli_fetch_array($result_ivest_upgrade_topup)){

                                                                          $amount_final_ivest_upgrade_topup = $row_total_ivest_upgrade_topup['SUM(amount)'];

                                                                      }



                                                                      switch ($status_main_1) {

                                                                               case '0':

                                                                                 $coin_name = "IN-ACTIVE";

                                                                                 break;

                                                                                case '1':

                                                                                 $coin_name = "ACTIVE";

                                                                                 break; 

                                                                               

                                                                               default:

                                                                                 # code...

                                                                                 break;

                                                                             } 

                                                                             $select_query_view = "select * from member where member_no='$sponsor_no_main_1'";

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

                                                      

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

                                                        

                                                        $user_id_view = $row_view['user_id'];

                                                        $name_view = $row_view['name'];

                                                         

                                                    }



                                                    switch ($rank_main_1) {

                                             

                                            case '0':

                                              $reward_name="PARTICIPATION";

                                              break;

                                            case '1':

                                              $reward_name="PRIME PARTICIPATION";

                                              break;

                                            case '2':

                                              $reward_name="GROWTH BOOSTER";

                                              break;

                                            case '3':

                                              $reward_name="HIGH FLYER";

                                              break;

                                            case '4':

                                              $reward_name="IRON PILLAR";

                                              break;

                                            case '5':

                                              $reward_name="HIGHEST OF HIGHFIVE";

                                              break;

                                            case '6':

                                              $reward_name="MOUNTAIN MOVER";

                                              break;

                                            case '7':

                                              $reward_name="KEY CONTRIBUTOR";

                                              break;

                                            case '8':

                                              $reward_name="STANDING OVATION";

                                              break;

                                            case '9':

                                              $reward_name="ULTIMATE CONTRIBUTOR";

                                              break;

                                            case '10':

                                              $reward_name="HALL OF FAME";

                                              break;

                                             



                                            

                                            default:

                                              # code...

                                              break;

                                          }



                                                

                                                

                                           ?>



                                        <tr class="gradeX">

                                          

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

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

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

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

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

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

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

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

                                                       

                                           



                                           



                                          



                                          



                                        </tr>

                                         <?php } } }  ?>

                                     

                                </tbody>

                                

                            </table>

                        </div>

                    </div>

                </div>



                </div>

        <div class="footer-wrapper">

                <div class="footer-section f-section-1">

                    <p class="">Copyright © 2021 www.journeypress.in, All rights reserved.</p>

                </div>

                 

            </div>

        </div>

        <!--  END CONTENT AREA  -->



    </div>

    <!-- END MAIN CONTAINER -->   

    

    

    <!-- BEGIN GLOBAL MANDATORY SCRIPTS -->

    <script src="assets/js/libs/jquery-3.1.1.min.js"></script>

    <script src="bootstrap/js/popper.min.js"></script>

    <script src="bootstrap/js/bootstrap.min.js"></script>

    <script src="plugins/perfect-scrollbar/perfect-scrollbar.min.js"></script>

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

    

    <script>

        $(document).ready(function() {

            App.init();

        });

    </script>

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

    <!-- END GLOBAL MANDATORY SCRIPTS -->



    <!-- BEGIN PAGE LEVEL CUSTOM SCRIPTS -->

    <script src="plugins/table/datatable/datatables.js"></script>

    <script>

        $(document).ready(function() {

            $('#alter_pagination').DataTable( {

                "pagingType": "full_numbers",

                "dom": "<'dt--top-section'<'row'<'col-12 col-sm-6 d-flex justify-content-sm-start justify-content-center'l><'col-12 col-sm-6 d-flex justify-content-sm-end justify-content-center mt-sm-0 mt-3'f>>>" +

        "<'table-responsive'tr>" +

        "<'dt--bottom-section d-sm-flex justify-content-sm-between text-center'<'dt--pages-count  mb-sm-0 mb-3'i><'dt--pagination'p>>",

                "oLanguage": {

                    "oPaginate": { 

                        "sFirst": '<svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="feather feather-chevron-left"><polyline points="15 18 9 12 15 6"></polyline></svg>',

                        "sPrevious": '<svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="feather feather-arrow-left"><line x1="19" y1="12" x2="5" y2="12"></line><polyline points="12 19 5 12 12 5"></polyline></svg>',

                        "sNext": '<svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="feather feather-arrow-right"><line x1="5" y1="12" x2="19" y2="12"></line><polyline points="12 5 19 12 12 19"></polyline></svg>',

                        "sLast": '<svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="feather feather-chevron-right"><polyline points="9 18 15 12 9 6"></polyline></svg>'

                    },

                    "sInfo": "Showing page _PAGE_ of _PAGES_",

                    "sSearch": '<svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="feather feather-search"><circle cx="11" cy="11" r="8"></circle><line x1="21" y1="21" x2="16.65" y2="16.65"></line></svg>',

                    "sSearchPlaceholder": "Search...",

                   "sLengthMenu": "Results :  _MENU_",

                },

                "stripeClasses": [],

                "lengthMenu": [7, 10, 20, 50],

                "pageLength": 7 

            });

        } );

    </script>

    <!-- END PAGE LEVEL CUSTOM SCRIPTS -->

</body>

</html>

<?php } } } ?>