| 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/public_html/user/ |
Upload File : |
<?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 © 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>