1#@!#!123s

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

session_start();

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

    header("location: login.php");

 }

 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'];

        $profile = $row['profile'];

        $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)'];





                

          }

    

  ?><!DOCTYPE html>

<html lang="en">



<head>

  <meta charset="UTF-8">

  <meta content="width=device-width, initial-scale=1, maximum-scale=1, shrink-to-fit=no" name="viewport">

  <title>RAKCHABLOOMING</title>

  <!-- General CSS Files -->

  <link rel="stylesheet" href="assets/css/app.min.css">

  <!-- Template CSS -->

  <link rel="stylesheet" href="assets/bundles/datatables/datatables.min.css">

  <link rel="stylesheet" href="assets/bundles/datatables/DataTables-1.10.16/css/dataTables.bootstrap4.min.css">

  <link rel="stylesheet" href="assets/css/style.css">

  <link rel="stylesheet" href="assets/css/components.css">

  <!-- Custom style CSS -->

  <link rel="stylesheet" href="assets/css/custom.css">

  <link rel='shortcut icon' type='image/x-icon' href='assets/img/favicon.ico' />

  <style type="text/css">

    td {

      text-transform: uppercase;

    }

  </style>

</head>



<body>

  <div class="loader"></div>

  <div id="app">

    <div class="main-wrapper main-wrapper-1">

      <div class="navbar-bg"></div>

      <?php include("includes/header.php"); ?>

      <!-- Main Content -->

      <div class="main-content">

        <section class="section">

          <div class="section-body">

            <div class="row">

              <div class="col-12">

                <div class="card">

                   

                  <div class="card-body">

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

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

              <!-- title row -->

              <div class="row">

                <div class="col-12">





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





                     

                     



                    <address>



                                      

                            

                                             

                                             

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

                                      

                                      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 style="text-align: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>Manager Bonus</td>

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

                                 

                  </tr>

                  <tr>

                    <td>3</td>

                    

                    <td>TRIB BONUS</td>

                    <td style="text-align:right;"><?= $total_team_pv_tour_bonus; ?></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>Network Bonus</td>

                    <td style="text-align:right;"><?= $total_team_pv_referral_income; ?></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" style="text-align: right;">

                  <p><b>Sub Total :</b> <?php



                   



                  echo $total_team_pv_total_amount;



                    ?></p>

                </div>





                <div class="total-payment" style="text-align: right;">

                  <p><b>TDS :</b> <?php



                   



                  echo $total_team_pv_processing_amount;



                    ?> (-)</p>

                </div>

            

            

                 

                <div class="total-payment" style="text-align: right;">

                  <h3><b>Total :</b> <?php



                  $total_valuer = $total_team_pv_total_amount-$total_team_pv_processing_amount;



                  echo $total_valuer;



                    ?></h3>

                </div>

               

              </div>

              <br><br>



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

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

                    </div>



              <!-- /.col -->

            </div>

              <!-- /.row -->



            

                

 



<p id="codescratcher_btn">generate PDF</p>

              

                </div>



            </section>

                  </div>

                </div>

              </div>

            </div>

          </div>

        </section>

        

      </div>

      <footer class="main-footer">

        <div class="footer-left">

          Copyright &copy; 2021 <div class="bullet"></div> All Rights Reserved.

        </div>

        <div class="footer-right">

        </div>

      </footer>

    </div>

  </div>

  <!-- General JS Scripts -->

  <script src="assets/js/app.min.js"></script> 



  <script type="text/javascript">

     $('#codescratcher_btn').click(function() {

      var options = {

      };

      var pdf = new jsPDF('p', 'pt', 'a4');

      pdf.addHTML($("#codescracther_content"), 15, 15, options, function() {

        pdf.save('Codescracther.pdf');

      });

    });

      </script> 

  <!-- JS Libraies -->

  <!-- Page Specific JS File -->

  <script src="assets/bundles/datatables/datatables.min.js"></script>

  <script src="assets/bundles/datatables/DataTables-1.10.16/js/dataTables.bootstrap4.min.js"></script>

  <script src="assets/bundles/datatables/export-tables/dataTables.buttons.min.js"></script>

  <script src="assets/bundles/datatables/export-tables/buttons.flash.min.js"></script>

  <script src="assets/bundles/datatables/export-tables/jszip.min.js"></script>

  <script src="assets/bundles/datatables/export-tables/pdfmake.min.js"></script>

  <script src="assets/bundles/datatables/export-tables/vfs_fonts.js"></script>

  <script src="assets/bundles/datatables/export-tables/buttons.print.min.js"></script>

  <script src="assets/js/page/datatables.js"></script>

  <!-- Template JS File -->

  <script src="assets/js/scripts.js"></script>

  <!-- Custom JS File -->

  <script src="assets/js/custom.js"></script>

  



  

   

</body>



</html>



<?php } }  ?>