D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home5
/
rakcha
/
www
/
user
/
Filename :
monthly_report1.php
back
Copy
<?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']; if (isset($_GET['payout_id'])) { $page_id = $_GET['payout_id']; $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' AND payout_id='$page_id'"; $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_payment = "select * from week_payout where payout_id='$page_id'"; $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']; $member_no = $row_payment['member_no']; $paid_date = $row_payment['paid_date']; $transection_no = $row_payment['transection_no']; $level_roi = $row_payment['level_roi']; $car_bonus = $row_payment['car_bonus']; $manager_bonus = $row_payment['manager_bonus']; $tour_bonus = $row_payment['tour_bonus']; $leader_bonus = $row_payment['leader_bonus']; $house_bonus = $row_payment['house_bonus']; $growth_bonus = $row_payment['growth_bonus']; $ups_bonus = $row_payment['ups_bonus']; $president_bonus = $row_payment['president_bonus']; $royalty_bonus = $row_payment['royalty_bonus']; $founder_bonus = $row_payment['founder_bonus']; } $select_query_total_tour_bonus = "select SUM(amount), SUM(tds), SUM(netpay) from tour_bonus where member_no = '$member_no' AND date='$date' "; $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)']; } $currentDate = new DateTime($date); $yesterdayTime = $currentDate->sub(new DateInterval('P1D')); $yesterday = $yesterdayTime->format('Y-m-d'); $date_year = date('Y', strtotime($yesterday)); $date_month = date('F', strtotime($yesterday)); $select_query_2 = "select * from point_member where date='$date' AND member_no='$member_no'"; $run_2 = mysqli_query($con,$select_query_2); $check_net_tree = mysqli_num_rows($run_2); if ($check_net_tree > 0) { while ($row_2 = mysqli_fetch_array($run_2)) { $rank_1 = $row_2['rank']; } }else { $rank_1 =0; } switch ($rank_1) { case '0': $title_user= "CONSULTANT"; break; case '1': $title_user= "CON.MANAGER"; break; case '2': $title_user= "CON.SENIOR MANAGER"; break; case '3': $title_user= "CON.DIRECTOR"; break; case '4': $title_user= "CON.SENIOR DIRECTOR"; break; case '5': $title_user= "CON.VICE PRESIDENT"; break; case '6': $title_user= "CON.SENIOR VICE PRESIDENT"; break; case '7': $title_user= "CON.PRESIDENT"; break; default: # code... break; } ?> <!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> Title : <?= $title_user; ?><br> Payout Period : <?= $date_month; ?> <?= $date_year; ?>. </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> © 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 © 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 } } } ?>