D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home
/
rakcha
/
www
/
app
/
Filename :
oldreport.php
back
Copy
<?php session_start(); $con = mysqli_connect("localhost","rakchatest","rakchatest@12345","rakchatest"); // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } ?> <!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>ADMIN</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' /> </head> <body> <div class="loader"></div> <div id="app"> <div class="main-wrapper main-wrapper-1"> <div class="navbar-bg"></div> <nav class="navbar navbar-expand-lg main-navbar"> <div class="form-inline mr-auto"> <ul class="navbar-nav mr-3"> <li><a href="#" data-toggle="sidebar" class="nav-link nav-link-lg collapse-btn"> <i data-feather="align-justify"></i></a></li> <li><a href="#" class="nav-link nav-link-lg fullscreen-btn"> <i data-feather="maximize"></i> </a></li> </ul> </div> <ul class="navbar-nav navbar-right"> <li><a href="#" class="nav-link nav-link-lg nav-link-user btn btn-primary" style="height:auto !important;margin-top:5px;">ADMIN</a> </li> </ul> </nav> <div class="main-sidebar sidebar-style-2"> <aside id="sidebar-wrapper"> <div class="sidebar-brand"> <a href="index.php"> <img alt="image" src="assets/img/logo.png" class="header-logo" style="max-width:70px;"> </a> </div> <ul class="sidebar-menu"> <li class="menu-header">MENU</li> <li> <a href="../admin/main_home.php" class="nav-link"><i data-feather="monitor"></i><span>Dashboard</span></a></li> </ul> </aside> </div> <!-- 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-header"> <h4>WEEKLY PAYOUT</h4> </div> <div class="card-body"> <div class="table-responsive"> <table class="table table-striped table-hover" id="tableExport" style="width:100%;"> <thead> <tr> <th>S.No</th> <th>Date</th> <th>Name</th> <th>USER ID</th> <th>Amount</th> <th>PV</th> </tr> </thead> <tbody> <?php $select_query_payment = "select * from wallet_payout where status='0' AND binary_income > '0' ORDER BY payout_id ASC"; $run_payment = mysqli_query($con,$select_query_payment); $serial_payment = 1; while ($row_payment = mysqli_fetch_array($run_payment)) { $s_num_payment = $serial_payment++; $date = $row_payment['date']; $binary_income = $row_payment['binary_income']; $referral_income = $row_payment['referral_income']; $roi_income = $row_payment['roi_income']; $total_amount = $row_payment['total_amount']; $processing_amount = $row_payment['processing_amount']; $tds = $row_payment['tds']; $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']; $session = $row_payment['session']; $select_query = "select * from member where member_no ='$member_no'"; $run = mysqli_query($con,$select_query); while ($row = mysqli_fetch_array($run)) { $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']; } ?> <tr> <td><?= $s_num_payment; ?></td> <td><?= $date; ?></td> <td><?= $name; ?></td> <td><?= $user_id; ?></td> <td><?= $binary_income; ?></td> <td><?= $roi_income; ?></td> </tr> <?php } ?> </tbody> </table> </div> </div> </div> </div> </div> </div> </section> </div> <footer class="main-footer"> <div class="footer-left"> Copyright © 2021 <div class="bullet"></div> All Rights Reserved. </div> <div class="footer-right"> </div> </footer> </div> </div> <script src="assets/js/app.min.js"></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>