D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home5
/
rakcha
/
www
/
user
/
Filename :
network_report.php
back
Copy
<?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>