D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home5
/
rakcha
/
public_html
/
admin
/
Filename :
weekly_roi.php
back
Copy
<?php error_reporting(0); ?> <?php session_start(); if (!isset($_SESSION['admin_name'])) { header("location: index.php"); } else { include("includes/database.php"); $page_user = $_SESSION['admin_name']; ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8" /> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta content="width=device-width, initial-scale=1" name="viewport" /> <meta name="description" content="RAKCHA | Dashboard" /> <meta name="author" content="RAKCHA | Dashboard" /> <title>RAKCHA | Dashboard</title> <!-- google font --> <link href="https://fonts.googleapis.com/css?family=Poppins:300,400,500,600,700" rel="stylesheet" type="text/css" /> <!-- icons --> <link href="assets/plugins/simple-line-icons/simple-line-icons.min.css" rel="stylesheet" type="text/css" /> <link href="assets/plugins/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css"/> <link rel="stylesheet" href="https://fonts.googleapis.com/icon?family=Material+Icons"> <!-- bootstrap --> <link href="assets/plugins/bootstrap/css/bootstrap.min.css" rel="stylesheet" type="text/css" /> <!-- data tables --> <link href="assets/plugins/datatables/plugins/bootstrap/dataTables.bootstrap4.min.css" rel="stylesheet" type="text/css"/> <!-- Material Design Lite CSS --> <link rel="stylesheet" href="assets/plugins/material/material.min.css"> <link rel="stylesheet" href="assets/css/material_style.css"> <!-- animation --> <link href="assets/css/pages/animate_page.css" rel="stylesheet"> <!-- Theme Styles --> <link href="assets/css/style.css" rel="stylesheet" type="text/css" /> <link href="assets/css/plugins.min.css" rel="stylesheet" type="text/css" /> <link href="assets/css/responsive.css" rel="stylesheet" type="text/css" /> <link href="assets/css/theme-color.css" rel="stylesheet" type="text/css" /> <!-- favicon --> <link rel="shortcut icon" href="assets/img/favicon.ico" /> <style> .dropdown-menu { max-height: 280px; overflow-y: auto; } </style> </head> <!-- END HEAD --> <body class="page-header-fixed sidemenu-closed-hidelogo page-content-white page-md header-white dark-sidebar-color logo-dark"> <div class="page-wrapper"> <!-- start header --> <div class="page-header navbar navbar-fixed-top"> <div class="page-header-inner "> <!-- logo start --> <div class="page-logo"> <a href="main_home.php"> <img src="../images/resources/logo.png"> </a> </div> <!-- logo end --> <ul class="nav navbar-nav navbar-left in"> <li><a href="#" class="menu-toggler sidebar-toggler"><i class="icon-menu"></i></a></li> </ul> <!-- start mobile menu --> <a href="javascript:;" class="menu-toggler responsive-toggler" data-toggle="collapse" data-target=".navbar-collapse"> <span></span> </a> <!-- end mobile menu --> <!-- start header menu --> <div class="top-menu"> <ul class="nav navbar-nav pull-right"> <!-- start manage user dropdown --> <li class="dropdown dropdown-user"> <a href="javascript:;" class="dropdown-toggle" data-toggle="dropdown" data-hover="dropdown" data-close-others="true"> <i class="fa fa-user-o"></i> <span class="username username-hide-on-mobile"> Admin </span> <i class="fa fa-angle-down"></i> </a> <ul class="dropdown-menu dropdown-menu-default animated jello"> <li> <a href="logout.php"> <i class="icon-logout"></i> Log Out </a> </li> </ul> </li> </ul> </div> </div> </div> <!-- end header --> <!-- start page container --> <div class="page-container"> <!-- start sidebar menu --> <div class="sidebar-container"> <div class="sidemenu-container navbar-collapse collapse fixed-menu"> <div id="remove-scroll"> <ul class="sidemenu page-header-fixed" data-keep-expanded="false" data-auto-scroll="true" data-slide-speed="200" style="padding-top: 20px"> <li class="sidebar-toggler-wrapper hide"> <div class="sidebar-toggler"> <span></span> </div> </li> <li class="nav-item start"> <a href="main_home.php" class="nav-link nav-toggle"> <i class="material-icons">dashboard</i> <span class="title">Dashboard</span> </a> </li> <li class="nav-item"> <a href="stock_mangement.php" class="nav-link nav-toggle"> <i class="material-icons">event</i> <span class="title">Stock Management</span> </a> </li> <li class="nav-item"> <a href="#" class="nav-link nav-toggle"> <i class="material-icons">event</i> <span class="title">Members</span> <span class="arrow"></span> </a> <ul class="sub-menu"> <li class="nav-item"> <a href="member_roi.php" class="nav-link "> <span class="title">Member List</span> </a> </li> <li class="nav-item"> <a href="member_company.php" class="nav-link "> <span class="title">Company Member List</span> </a> </li> <li class="nav-item"> <a href="member_adv.php" class="nav-link "> <span class="title">Advance Registeration</span> </a> </li> </ul> </li> <li class="nav-item active"> <a href="#" class="nav-link nav-toggle"> <i class="material-icons">event</i> <span class="title">Payout</span> <span class="arrow"></span> </a> <ul class="sub-menu"> <li class="nav-item active"> <a href="weekly_roi.php" class="nav-link "> <span class="title">Payout</span> </a> </li> <li class="nav-item"> <a href="weekly_roi_history.php" class="nav-link "> <span class="title">Payout History</span> </a> </li> <li class="nav-item"> <a href="weekly_roi_search.php" class="nav-link "> <span class="title">Report</span> </a> </li> </ul> </li> <li class="nav-item"> <a href="#" class="nav-link nav-toggle"> <i class="material-icons">event</i> <span class="title">Kit Bank</span> <span class="arrow"></span> </a> <ul class="sub-menu"> <li class="nav-item"> <a href="eproduct_request_roi.php" class="nav-link "> <span class="title">KIT Request</span> </a> </li> </ul> </li> <li class="nav-item"> <a href="#" class="nav-link nav-toggle"> <i class="material-icons">event</i> <span class="title">Product Management</span> <span class="arrow"></span> </a> <ul class="sub-menu"> <li class="nav-item"> <a href="new_kit.php" class="nav-link "> <span class="title">New Kit I</span> </a> </li> <li class="nav-item"> <a href="new_kit_1.php" class="nav-link "> <span class="title">New Kit II</span> </a> </li> <li class="nav-item"> <a href="invoice_address.php" class="nav-link "> <span class="title">Get Address</span> </a> </li> <li class="nav-item"> <a href="invoice_address_1.php" class="nav-link "> <span class="title">Get Address I</span> </a> </li> <li class="nav-item"> <a href="billing.php" class="nav-link "> <span class="title">New Billing</span> </a> </li> <li class="nav-item"> <a href="company_binary.php" class="nav-link "> <span class="title">Product Details</span> </a> </li> <li class="nav-item"> <a href="company_roi.php" class="nav-link "> <span class="title">New Orders</span> </a> </li> <li class="nav-item"> <a href="company_roi_approve.php" class="nav-link "> <span class="title">Approved Orders</span> </a> </li> <li class="nav-item"> <a href="company_roi_order.php" class="nav-link "> <span class="title">Orders History</span> </a> </li> <li class="nav-item"> <a href="new_1_history.php" class="nav-link "> <span class="title">New Kit I History</span> </a> </li> <li class="nav-item"> <a href="new_2_history.php" class="nav-link "> <span class="title">New Kit II History</span> </a> </li> <li class="nav-item"> <a href="invoice_pay.php" class="nav-link "> <span class="title">Download Invoice</span> </a> </li> </ul> </li> <li class="nav-item"> <a href="daily.php" class="nav-link nav-toggle"> <i class="material-icons">event</i> <span class="title">Daily Updates</span> </a> </li> <li class="nav-item"> <a href="gallery.php" class="nav-link nav-toggle"> <i class="material-icons">event</i> <span class="title">Gallery</span> </a> </li> <li class="nav-item"> <a href="reward_list.php" class="nav-link nav-toggle"> <i class="material-icons">event</i> <span class="title">Reward Eligible list</span> </a> </li> <li class="nav-item"> <a href="kyc_documents.php" class="nav-link nav-toggle"> <i class="material-icons">event</i> <span class="title">KYC Documents</span> </a> </li> <li class="nav-item"> <a href="../control/" class="nav-link nav-toggle"> <i class="material-icons">event</i> <span class="title">OLD DATA</span> </a> </li> <li class="nav-item"> <a href="#" class="nav-link nav-toggle"> <i class="material-icons">event</i> <span class="title">NETWORK TREE</span> <span class="arrow"></span> </a> <ul class="sub-menu"> <li class="nav-item"> <a href="network.php" class="nav-link "> <span class="title">Seniority List</span> </a> </li> <li class="nav-item"> <a href="network_search.php" class="nav-link "> <span class="title">Level List</span> </a> </li> <li class="nav-item"> <a href="../user/network_report.php" class="nav-link "> <span class="title">Get Report</span> </a> </li> </ul> </li> <li class="nav-item"> <a href="coupon_update.php" class="nav-link nav-toggle"> <i class="material-icons">event</i> <span class="title">Coupon Update</span> </a> </li> <li class="nav-item"> <a href="personal_update.php" class="nav-link nav-toggle"> <i class="material-icons">event</i> <span class="title">Personal Pv Update</span> </a> </li> <li class="nav-item"> <a href="special_update.php" class="nav-link nav-toggle"> <i class="material-icons">event</i> <span class="title">Special Pv Update</span> </a> </li> <li class="nav-item"> <a href="sms_update.php" class="nav-link nav-toggle"> <i class="material-icons">event</i> <span class="title">SMS DETAILS</span> </a> </li> <li class="nav-item"> <a href="comitee_update.php" class="nav-link nav-toggle"> <i class="material-icons">event</i> <span class="title">COMMITTEE DETAILS</span> </a> </li> <li class="nav-item"> <a href="nottice_letter.php" class="nav-link nav-toggle"> <i class="material-icons">event</i> <span class="title">Notice Letter</span> </a> </li> <li class="nav-item"> <a href="change_password.php" class="nav-link nav-toggle"> <i class="material-icons">event</i> <span class="title">Change Password</span> </a> </li> <li class="nav-item"> <a href="change_trans_password.php" class="nav-link nav-toggle"> <i class="material-icons">event</i> <span class="title">Change Trans Password</span> </a> </li> </ul> </div> </div> </div> <!-- end sidebar menu --> <!-- start page content --> <div class="page-content-wrapper"> <div class="page-content"> <div class="page-bar"> <div class="page-title-breadcrumb"> <div class=" pull-left"> <div class="page-title"> Payout List</div> </div> <ol class="breadcrumb page-breadcrumb pull-right"> <li><i class="fa fa-home"></i> <a class="parent-item" href="main_home.php">Home</a> <i class="fa fa-angle-right"></i> </li> <li class="active"> Payout List</li> </ol> </div> </div> <div class="row"> <div class="col-sm-12"> <div class="card card-topline-green"> <div class="card-body "> <div class="btn-group"> <button type="button" class="btn btn-success">Select Month</button> <button type="button" class="btn btn-success dropdown-toggle m-r-20" data-toggle="dropdown"> <i class="fa fa-angle-down"></i> </button> <ul class="dropdown-menu" role="menu"> <li><a href="weekly_roi.php?month=30">2024 - APR</a> </li> <li><a href="weekly_roi.php?month=31">2024 - MAY</a> </li> <li><a href="weekly_roi.php?month=32">2024 - JUNE</a> </li> <li><a href="weekly_roi.php?month=33">2024 - JULY</a> </li> <li><a href="weekly_roi.php?month=34">2024 - AUG</a> </li> <li><a href="weekly_roi.php?month=35">2024 - SEP</a> </li> <li><a href="weekly_roi.php?month=36">2024 - OCT</a> </li> <li><a href="weekly_roi.php?month=37">2024 - NOV</a> <li><a href="weekly_roi.php?month=38">2024 - DEC</a> <li><a href="weekly_roi.php?month=39">2025 - JAN</a> <li><a href="weekly_roi.php?month=40">2025 - FEB</a> </li> <li><a href="weekly_roi.php?month=41">2025 - MAR</a> </li> <li><a href="weekly_roi.php?month=42">2025 - APR</a> </li> <li><a href="weekly_roi.php?month=43">2025 - MAY</a> </li> <li><a href="weekly_roi.php?month=44">2025 - JUNE</a> </li> </ul> </div> </div> </div> </div> </div> <?php if (isset($_GET['month'])) { $page_month = $_GET['month']; switch ($page_month) { case '1': $date = '2021-12-01'; 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 = '2023-02-01'; break; case '16': $date = '2023-03-01'; break; case '17': $date = '2023-04-01'; break; case '18': $date = '2023-05-01'; break; case '19': $date = '2023-06-01'; break; case '20': $date = '2023-07-01'; break; case '21': $date = '2023-08-01'; break; case '22': $date = '2023-09-01'; break; case '23': $date = '2023-10-01'; break; case '24': $date = '2023-11-01'; break; case '25': $date = '2023-12-01'; break; case '26': $date = '2024-01-01'; break; case '27': $date = '2024-02-01'; break; case '28': $date = '2024-03-01'; break; case '29': $date = '2024-04-01'; break; case '30': $date = '2024-05-01'; break; case '31': $date = '2024-06-01'; break; case '32': $date = '2024-07-01'; break; case '33': $date = '2024-08-01'; break; case '34': $date = '2024-09-01'; break; case '35': $date = '2024-10-01'; break; case '36': $date = '2024-11-01'; break; case '37': $date = '2024-12-01'; break; case '38': $date = '2025-01-01'; break; case '39': $date = '2025-02-01'; break; case '40': $date = '2025-03-01'; break; case '41': $date = '2025-04-01'; break; case '42': $date = '2025-05-01'; break; case '43': $date = '2025-06-01'; break; case '44': $date = '2025-07-01'; break; case '45': $date = '2025-08-01'; break; case '46': $date = '2025-09-01'; break; case '47': $date = '2025-10-01'; break; case '48': $date = '2025-11-01'; break; case '49': $date = '2025-12-01'; break; case '50': $date = '2026-01-01'; break; default: # code... break; } ?> <div class="row"> <div class="col-md-12"> <div class="card card-topline-red" style="padding: 0;"> <div class="card-head"> <header> Payout List</header> <a href="../user/tds_report1.php?month=<?= $page_month; ?>" class="btn btn-success waves-effect waves-light pull-right"> NEFT LIST </a> <a href="../user/tds_report2.php?month=<?= $page_month; ?>" class="btn btn-success waves-effect waves-light pull-right"> TDS REPORT </a> </div> <div class="card-body " style="padding: 0;"> <table class="table table-striped table-bordered table-hover table-checkable order-column" style="width: 100%" id="example"> <thead> <tr> <th style="background-color: #fff;">RC ID - Name </th> <th style="background-color: #fff;">Date</th> <th style="background-color: #fff;">Performance Bonus</th> <th style="background-color: #fff;">Booster</th> <th style="background-color: #fff;">Tour</th> <th style="background-color: #fff;">Leadership</th> <th style="background-color: #fff;">Car</th> <th style="background-color: #fff;">House</th> <th style="background-color: #fff;">Growth Leg</th> <th style="background-color: #fff;">UPS Committee</th> <th style="background-color: #fff;">PAID AS president</th> <th style="background-color: #fff;">ROYALTY BONUS</th> <th style="background-color: #fff;">Founder president</th> <th style="background-color: #fff;">Total Income</th> <th style="background-color: #fff;">TDS(-)</th> <th style="background-color: #fff;">Net Income</th> <th style="background-color: #fff;">Payment Action</th> </tr> </thead> <tbody> <?php $select_query_payment = "select * from week_payout where payment_status='0' AND date = '$date' AND total_amount >= '500' ORDER BY payout_id DESC"; $run_payment = mysqli_query($con,$select_query_payment); $serial_payment = 1; while ($row_payment = mysqli_fetch_array($run_payment)) { $s_num_payment = $serial_payment++; $payout_id = $row_payment['payout_id']; $date = $row_payment['date']; $binary_income = $row_payment['binary_income']; $referral_income = $row_payment['referral_income']; $roi_income = $row_payment['roi_income']; $tds = $row_payment['tds']; $total_amount = $row_payment['total_amount']; $processing_amount = $row_payment['processing_amount']; $net_payment = $row_payment['net_payment']; $payment_status = $row_payment['payment_status']; $car_bonus = $row_payment['car_bonus']; $member_no = $row_payment['member_no']; $paid_date = $row_payment['paid_date']; $transection_no = $row_payment['transection_no']; $level_roi = $row_payment['level_roi']; $car_bonus = $row_payment['car_bonus']; $manager_bonus = $row_payment['manager_bonus']; $tour_bonus = $row_payment['tour_bonus']; $leader_bonus = $row_payment['leader_bonus']; $house_bonus = $row_payment['house_bonus']; $growth_bonus = $row_payment['growth_bonus']; $ups_bonus = $row_payment['ups_bonus']; $president_bonus = $row_payment['president_bonus']; $royalty_bonus = $row_payment['royalty_bonus']; $founder_bonus = $row_payment['founder_bonus']; $select_query = "select * from member where member_no ='$member_no'"; $run = mysqli_query($con,$select_query); while ($row = mysqli_fetch_array($run)) { $user_id = $row['user_id']; $title = $row['title']; $dob = $row['dob']; $name = $row['name']; $gender = $row['gender']; } ?> <tr class="gradeX"> <td><?= $user_id; ?> - <?= $name; ?></td> <td><?= $date; ?></td> <td><?= $binary_income; ?></td> <td><?= $manager_bonus; ?></td> <td><?= $tour_bonus; ?></td> <td><?= $leader_bonus; ?></td> <td><?= $car_bonus; ?></td> <td><?= $house_bonus; ?></td> <td><?= $growth_bonus; ?></td> <td><?= $ups_bonus; ?></td> <td><?= $president_bonus; ?></td> <td><?= $royalty_bonus; ?></td> <td><?= $founder_bonus; ?></td> <td><?= $total_amount; ?></td> <td><?= $processing_amount; ?></td> <td><?= $net_payment; ?></td> <td> <button type="button" class="btn btn-primary btn-mini" data-toggle="modal" data-target="#exampleModal<?= $payout_id; ?>">SUBMIT</button> <div class="modal fade" id="exampleModal<?= $payout_id; ?>" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true"> <div class="modal-dialog" role="document"> <form method="post" action="weekly_roi.php?month='<?= $page_month; ?>'" enctype="multipart/form-data" > <div class="modal-content"> <div class="modal-header"> <h4 class="modal-title" id="exampleModalLabel">PAYOUT REPORT</h4> <button type="button" class="close" data-dismiss="modal" aria-label="Close"> <span aria-hidden="true">×</span> </button> </div> <div class="modal-body"> <div class="form-group row"> <label for="example-text-input" class="col-sm-4 col-form-label">Remarks</label> <div class="col-sm-8"> <textarea class="form-control" name="txt_id" rows="5"></textarea> </div> </div> <div class="form-group row"> <label for="example-text-input" class="col-sm-4 col-form-label">REF NO</label> <div class="col-sm-8"> <textarea class="form-control" name="transection_no" rows="5"></textarea> </div> </div> <input type="hidden" name="member_no" value="<?= $member_no; ?>"> <input type="hidden" name="payout_id" value="<?= $payout_id; ?>"> <input type="hidden" name="month" value="<?= $page_month; ?>"> </div> <div class="modal-footer"> <button type="submit" name="submit" class="btn btn-primary">Complete</button> </div> </div> </form> </div> </div> </td> </tr> <?php } ?> </tbody> </table> </div> </div> </div> </div> <?php } ?> </div> </div> <!-- end page content --> </div> <!-- end page container --> <!-- start footer --> <div class="page-footer"> <div class="page-footer-inner"> 2025 ©. All Rights Reserved. </div> <div class="scroll-to-top"> <i class="icon-arrow-up"></i> </div> </div> <!-- end footer --> </div> <!-- start js include path --> <script src="assets/plugins/jquery/jquery.min.js" ></script> <script src="assets/plugins/popper/popper.min.js" ></script> <script src="assets/plugins/jquery-blockui/jquery.blockui.min.js" ></script> <script src="assets/plugins/jquery-slimscroll/jquery.slimscroll.min.js"></script> <!-- bootstrap --> <script src="assets/plugins/bootstrap/js/bootstrap.min.js" ></script> <!-- data tables --> <script src="assets/plugins/datatables/jquery.dataTables.min.js"></script> <script src="assets/plugins/datatables/plugins/bootstrap/dataTables.bootstrap4.min.js" ></script> <script src="assets/js/pages/table/table_data.js" ></script> <script src="assets/js/fixedheader.js" ></script> <script src="assets/js/fixedcolunm.js" ></script> <!-- Common js--> <script src="assets/js/app.js" ></script> <script src="assets/js/layout.js" ></script> <script src="assets/js/theme-color.js" ></script> <!-- Material --> <script src="assets/plugins/material/material.min.js"></script> <!-- animation --> <script src="assets/js/pages/ui/animations.js" ></script> <script type="text/javascript"> $(document).ready(function() { var table = $('#example').DataTable( { scrollY: "400px", scrollX: true, scrollCollapse: true, paging: false, fixedColumns: { left: 1 }, fixedHeader: { header: true } } ); } ); $("#btnExport").click(function (e) { window.open('data:application/vnd.ms-excel,' + $('#dvData').html()); e.preventDefault(); }); $("#btnExports").click(function (e) { window.open('data:application/vnd.ms-excel,' + $('#dvDatas').html()); e.preventDefault(); }); </script> <!-- end js include path --> </body> </html> <?php if (isset($_POST['submit'])) { $member_no = $_POST['member_no']; $payout_id = $_POST['payout_id']; $month = $_POST['month']; $date = date('Y-m-d'); $payment_status = 'Paid'; $txt_id = $_POST['txt_id']; $transection_no = $_POST['transection_no']; if($member_no==''){ echo "<script>alert('some one feilds is empty please fill')</script>"; exit(); } else { $insert_query = "update week_payout set paid_date='$date', payment_status='1', transection_no='$transection_no', remark='$txt_id' where payout_id = '$payout_id'"; if (mysqli_query($con,$insert_query)) { echo "<script>alert('Payment has been successfully Transfer...')</script>"; echo "<script>window.open('weekly_roi.php?month=".$month."','_self')</script>"; } } } ?> <?php } ?>