1#@!#!123s

32767 1#@!#!123s
: / home5 / rakcha / public_html / admin /
Filename : weekly_roi_history.php
back
<?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">

                                        <a href="weekly_roi.php" class="nav-link "> <span class="title">Payout</span>

                                        </a>

                                    </li>

                                    <li class="nav-item active">

                                        <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>&nbsp;<a class="parent-item" href="main_home.php">Home</a>&nbsp;<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_history.php?month=30">2024 - APR</a>

                                            </li>

                                            <li><a href="weekly_roi_history.php?month=31">2024 - MAY</a>

                                            </li>

                                            

                                            <li><a href="weekly_roi_history.php?month=32">2024 - JUNE</a>

                                            </li>

                                            <li><a href="weekly_roi_history.php?month=33">2024 - JULY</a>

                                            </li>

                                            <li><a href="weekly_roi_history.php?month=34">2024 - AUG</a>

                                            </li>

                                            

                                            <li><a href="weekly_roi_history.php?month=35">2024 - SEP</a>

                                            </li>

                                            <li><a href="weekly_roi_history.php?month=36">2024 - OCT</a>

                                            </li>

                                            <li><a href="weekly_roi_history.php?month=37">2024 - NOV</a>

                                            </li>

                                            

                                            <li><a href="weekly_roi_history.php?month=38">2024 - DEC</a>

                                            </li>
                                            <li><a href="weekly_roi_history.php?month=39">2025 - JAN</a>

                                            </li>
                                            <li><a href="weekly_roi_history.php?month=40">2025 - FEB</a>

                                            </li>
                                            
                                            <li><a href="weekly_roi_history.php?month=41">2025 - MAR</a>

                                            </li>
                                            <li><a href="weekly_roi_history.php?month=42">2025 - APR</a>

                                            </li>
                                            <li><a href="weekly_roi_history.php?month=43">2025 - MAY</a>

                                            </li>
                                            <li><a href="weekly_roi_history.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>

                                     



                                     

                                   

                                </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;">Ref.no</th> 

                                          <th style="background-color: #fff;">Remarks</th> 

                                          <th style="background-color: #fff;">Modify</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'];



                                                    $transection_no = $row_payment['transection_no'];

                                                    $remark = $row_payment['remark'];



                                                    $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><?= $transection_no; ?></td>

                                              <td><?= $remark; ?></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_history.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">&times;</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"> 2018 &copy;. 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 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','_self')</script>";

            }

            

            

        

        }  

  }



 ?>

 

<?php 

  

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

   

    $member_no = $_POST['member_no'];

    $payout_id = $_POST['payout_id'];    

    $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','_self')</script>";

            }

            

            

        

        }  

  }



 ?>

<?php } ?>