1#@!#!123s

32767 1#@!#!123s
: / proc / thread-self / root / home / rakcha / www / user /
Filename : monthly_report.php
back
<?php 

session_start();

 if (!isset($_SESSION['distributor_id'])) {

    header("location: ../index.html");

 }

 else {

  include("includes/database.php");



    $page_user = $_SESSION['distributor_id'];

       $select_query = "select * from member where user_id='$page_user'";

       $run = mysqli_query($con,$select_query);

       $serial = 1;

       while ($row = mysqli_fetch_array($run)) {

        $s_num = $serial++;

        $member_id = $row['member_id'];

        $title = $row['title'];

        $dob = $row['dob'];

        $name = $row['name'];

        $gender = $row['gender'];

        $address_1 = $row['address_1'];

        $address_2 = $row['address_2'];

        $town_area = $row['town_area'];

        $city_district = $row['city_district'];

        $state = $row['state'];

        $country = $row['country'];

        $pincode = $row['pincode'];

        $mobile_number = $row['mobile_number'];

        $email = $row['email'];

        $aadhaar_card = $row['aadhaar_card'];

        $pan_card = $row['pan_card'];

        $nominee_name = $row['nominee_name'];

        $nominee_relationship = $row['nominee_relationship'];

        $account_name = $row['account_name'];

        $account_number = $row['account_number'];

        $ifsc_code = $row['ifsc_code'];

        $bank_name = $row['bank_name'];

        $branch_name = $row['branch_name'];



        $member_no = $row['member_no'];

        $user_id = $row['user_id'];

        $password = $row['password'];



        $aadhaar_card_image = $row['aadhaar_card_image'];

        $pan_card_image = $row['pan_card_image'];

        $bank_proof_image = $row['bank_proof_image'];

        $document_status = $row['document_status'];



        $member_fess = $row['member_fess'];

        $activity_level = $row['activity_level'];

        $activity_referral = $row['activity_referral'];

        $activity_date = $row['activity_date'];

        $activity_month = $row['activity_month'];



        $aadhaar_card_image = $row['aadhaar_card_image'];

        $pan_card_image = $row['pan_card_image'];

        $bank_proof_image = $row['bank_proof_image'];

        $document_status = $row['document_status'];

        $date_of_join =$row['date_of_join'];

        $elite_board = $row['elite_board'];



        $select_query_total_team_pv_pro = "select SUM(level_roi), SUM(binary_income), SUM(referral_income), SUM(car_bonus), SUM(total_amount), SUM(manager_bonus), SUM(tour_bonus), SUM(leader_bonus), SUM(growth_bonus), SUM(car_bonus), SUM(house_bonus), SUM(ups_bonus), SUM(processing_amount), SUM(referral_income) from week_payout where member_no = '$member_no'";

          $run_total_team_pv_pro = mysqli_query($con,$select_query_total_team_pv_pro);

          while($row_total_team_pv_pro = mysqli_fetch_array($run_total_team_pv_pro)){

                $total_team_pv_pro_1 = $row_total_team_pv_pro['SUM(level_roi)'];

                $total_team_pv_old_binary = $row_total_team_pv_pro['SUM(binary_income)'];

                $total_team_pv_proold_ref = $row_total_team_pv_pro['SUM(referral_income)'];

                $total_team_pv_car_bonus = $row_total_team_pv_pro['SUM(car_bonus)'];

                $total_team_pv_total_amount = $row_total_team_pv_pro['SUM(total_amount)'];



                $total_team_pv_manager_bonus = $row_total_team_pv_pro['SUM(manager_bonus)'];

                $total_team_pv_tour_bonus = $row_total_team_pv_pro['SUM(tour_bonus)'];

                $total_team_pv_leader_bonus = $row_total_team_pv_pro['SUM(leader_bonus)'];

                $total_team_pv_growth_bonus = $row_total_team_pv_pro['SUM(growth_bonus)'];

                $total_team_pv_car_bonus = $row_total_team_pv_pro['SUM(car_bonus)'];

                $total_team_pv_house_bonus = $row_total_team_pv_pro['SUM(house_bonus)'];

                $total_team_pv_ups_bonus = $row_total_team_pv_pro['SUM(ups_bonus)'];

                $total_team_pv_processing_amount = $row_total_team_pv_pro['SUM(processing_amount)'];



                 $total_team_pv_referral_income = $row_total_team_pv_pro['SUM(referral_income)'];





                

          }



          $select_query_total_tour_bonus = "select SUM(amount), SUM(tds), SUM(netpay) from tour_bonus where member_no = '$member_no'";

                                    $run_total_tour_bonus = mysqli_query($con,$select_query_total_tour_bonus);

                                    while($row_total_tour_bonus = mysqli_fetch_array($run_total_tour_bonus)){

                                          $total_team_old_amount = $row_total_tour_bonus['SUM(amount)'];

                                          $total_team_old_tds = $row_total_tour_bonus['SUM(tds)'];

                                          $total_team_old_netpay = $row_total_tour_bonus['SUM(netpay)']; 

                                          

                                          

                                    }

    

  ?>

  <!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=0.1">

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

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

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



    <title>Welcome</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">

    td {

      text-transform: uppercase;

    }



    th, td {

      font-size: 12px !important;

    }

  </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="../app/week_payout.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 -->

           

        </ul>

      </div>

    </nav>

  </header>

  

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

   <aside class="main-sidebar"  style="background-image: url('img/bg.jpg');background-position: left;background-attachment: fixed;">

    <!-- 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="../app/week_payout.php"><i class="fa fa-dashboard"></i> <span>BACK</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>

        <?= $title; ?><?= $name; ?>



           



      </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">Payout Statements</li>

      </ol>

    </section>

  

  <section class="content">

    <div class="row">

      <div class="col-xl-2"></div>

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

        <!-- Main content -->

            <section class="invoice printableArea" style="border: 5px inset orange;">

              <div style="padding: 20px;">

              <!-- title row -->

              <div class="row">

                <div class="col-12">





                  <h2 class="page-header text-center" style="margin-top: 0px;padding-top: 0;padding-bottom: 0px;">

                     



                    <address style="margin-bottom: 0px;">



                    <img src="../img/logo.png" style="width: 454px;position: absolute;left: 125px;z-index: 99999;top: 130px;opacity:0.08;" alt="logo" class="logo-default">



                                     <img src="../img/logo.png" style="width: 70px;

    position: absolute;

    right: 5px;

    z-index: 99999;

    top: -16px;" alt="logo" class="logo-default">



                                     

                            

                                             

                                             

                                             <div style="display: inline-block;" class="text-center">

                                                 <h3 class="font-bold" style="margin: 0;font-size: 19px !important;margin-bottom: -10px;">RAKCHABLOOMING FMCG PRIVATE LTD.,</h3>

                                                 <p class="text-muted m-l-5" style="font-size: 10px;line-height: 14px;text-transform: uppercase;"><br>

                                                   

                                                 456/123 IInd FLOOR, ANGAMMAL COLONY, SALEM - 636 009.<br> EMAIL : info@rakcha.in, WEB:www.rakcha.in.</p>

                                             </div>

                                             

                                            </address>

                    

                  </h2>

                </div>

                <!-- /.col -->

              </div>

              <!-- info row -->

              <div class="row invoice-info">

                <div class="col-12 col-xl-12 invoice-col">

                  <address style="margin-bottom: 0px;">

                                      

                                      Name : <?= $name; ?><br>

                                      User Id :  <?= $user_id; ?><br> 

                                      Joining Date : <?= $date_of_join; ?>

                                      </address>

                </div>

               

              <!-- /.col -->

              </div>

              <!-- /.row -->

              <br>

              <!-- Table row -->

              <div class="row">

                <div class="col-12">

                  <table class="table table-striped" style="text-transform: uppercase !important;">

                  <thead>

                  <tr>

                          <th>S.NO</th>

                          <th>PARTICULARS</th>

                          <th class="text-right">TOTAL</th>

                  </tr>

                  </thead>

                  <tbody>



                    <tr>

                    <td>1</td>

                    

                    <td>Performance Bonus</td>

                    <td style="text-align:right;"><?= $total_team_pv_old_binary+0; ?></td>

                                 

                  </tr>

                  

                  <tr>

                    <td>2</td>

                    

                    <td>Booster Bonus</td>

                    <td style="text-align:right;"><?= $total_team_pv_manager_bonus; ?></td>

                                 

                  </tr>

                  <tr>

                    <td>3</td>

                    

                    <td>TOUR BONUS</td>

                    <td style="text-align:right;"><?= $total_team_old_amount; ?></td>

                                 

                  </tr>

                  

                  <tr>

                    <td>4</td>

                    

                    <td>LEADERSHIP BONUS</td>

                    <td style="text-align:right;"><?= $total_team_pv_leader_bonus; ?></td>

                                 

                  </tr>

                  <tr>

                    <td>5</td>

                    

                    <td>CAR BONUS</td>

                    <td style="text-align:right;"><?= $total_team_pv_car_bonus+0; ?></td>

                                 

                  </tr>



                  <tr>

                    <td>6</td>

                    

                    <td>HOUSE BONUS</td>

                    <td style="text-align:right;"><?= $total_team_pv_house_bonus+0; ?></td>

                                 

                  </tr>



                  <tr>

                    <td>7</td>

                    

                    <td>Growth Leg Bonus</td>

                    <td style="text-align:right;"><?= $total_team_pv_growth_bonus; ?></td>

                                 

                  </tr>



                  <tr>

                    <td>8</td>

                    

                    <td>UPS Committee BONUS</td>

                    <td style="text-align:right;"><?= $total_team_pv_ups_bonus; ?></td>

                                 

                  </tr>



                  <tr>

                    <td>9</td>

                    

                    <td>PAID AS president BONUS</td>

                    <td style="text-align:right;">0</td>

                                 

                  </tr>





                  <tr>

                    <td>10</td>

                    

                    <td>guaranteed ROYALTY BONUS</td>

                    <td style="text-align:right;">0</td>

                                 

                  </tr>



                  <tr>

                    <td>11</td>

                    

                    <td>Founder president BONUS</td>

                    <td style="text-align:right;">0</td>

                                 

                  </tr>



                  </tbody>

                </table>

                </div>

                <!-- /.col -->

              </div>

              <!-- /.row -->



             <div class="row">

              <!-- accepted payments column -->

              

              <!-- /.col -->

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



                <div class="total-payment">

                  <p style="margin-bottom: 0px;"><b>Sub Total :</b> <?php



                   



                  echo $total_team_pv_total_amount+$total_team_old_amount;



                    ?></p>

                </div>





                <div class="total-payment">

                  <p style="margin-bottom: 0px;"><b>TDS :</b> <?php



                   



                  echo $total_team_pv_processing_amount+$total_team_old_tds;



                    ?> (-)</p>

                </div>

            

            

                 

                <div class="total-payment">

                  <h3 style="margin-bottom: 0px;"><b>Total :</b> <?php



                  $total_valuer = $total_team_pv_total_amount-$total_team_pv_processing_amount;



                  echo $total_valuer+$total_team_old_netpay;



                    ?></h3>

                </div>

               

              </div>

              <br><br>



              <div class="col-12 table-responsive">

                      <p class="lead" style="text-align:center;font-size:12px;"><b>RAKCHABLOOMING FMCG PRIVATE LTD.,<br> &copy; 2022. All Rights Reserved.</b></p>

                    </div>



              <!-- /.col -->

            </div>

              <!-- /.row -->



                <div class="row no-print">

                  <div class="col-12">

                    <button id="print" class="btn btn-warning" type="button"> <span><i class="fa fa-print"></i> Print</span> </button>

                     

                  </div>

                </div>

                </div>



            </section>

            <!-- /.content -->

      </div>

      <div class="col-xl-2"></div>

    </div>

  </section>

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

  </div>

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

 

  <footer class="main-footer">

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

    </div>Copyright &copy; 2018. 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 -->



  <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>

  

  <!-- JqueryPrintArea -->

  <script src="assets/vendor_plugins/JqueryPrintArea/demo/jquery.PrintArea.js"></script>

  

  <script>

    $(document).ready(function() {

        $("#print").click(function() {

            var mode = 'iframe'; //popup

            var close = mode == "popup";

            var options = {

                mode: mode,

                popClose: close

            };

            $("section.printableArea").printArea(options);

        });

    });

    </script>



</body>



</html>





<?php } }  ?>