| Server IP : 144.76.124.212 / Your IP : 216.73.216.138 Web Server : LiteSpeed System : Linux l4cp.vnetindia.com 4.18.0-553.40.1.lve.el8.x86_64 #1 SMP Wed Feb 12 18:54:57 UTC 2025 x86_64 User : rakcha ( 1356) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home5/rakcha/public_html/user/ |
Upload File : |
<?php
include("includes/database.php");
?>
<!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=1, maximum-scale=1, user-scalable=no">
<meta name="description" content="">
<meta name="author" content="">
<link rel="icon" href="images/fave.png">
<title>RAKCHA</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">
.waves-light {
margin-bottom: 6px;
}
</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="main_home.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 -->
<li class="dropdown notifications-menu label-warning">
<a href="#" class="dropdown-toggle" data-toggle="dropdown" style="color: #000;font-weight: 700;">
<span class="d-sm-inline-block ">Admin</span>
</a>
</li>
<li>
<a href="logout.php" class="link" data-toggle="tooltip" title="" data-original-title="Logout"><i class="fa fa-power-off"></i></a>
</li>
</ul>
</div>
</nav>
</header>
<!-- Left side column. contains the logo and sidebar -->
<aside class="main-sidebar">
<!-- 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="../admin/main_home.php"><i class="fa fa-dashboard"></i> <span>DASHBOARD</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>
SALES DETAILS
</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">SALES DETAILS</li>
</ol>
</section>
<section class="content">
<div class="row">
<div class="col-12">
<div class="box">
<div class="box-header">
<h3 class="box-title">SALES DETAILS</h3>
</div>
<!-- /.box-header -->
<div class="box-body">
<table id="example" class="table table-bordered table-hover display nowrap margin-top-10 table-responsive" cellspacing="0" width="100%">
<thead>
<tr>
<th>S.No</th>
<th>Date</th>
<th>Name</th>
<th>RC ID </th>
<th>Amount </th>
</tr>
</thead>
<tbody>
<?php
$date='2025-04-01';
$dates='2025-07-01';
$select_query_payment = "select * from product_check where status='2' AND issue_date >='$date' AND issue_date < '$dates' ORDER BY check_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++;
$check_id = $row_payment['check_id'];
$member_no = $row_payment['member_no'];
$user_id = $row_payment['user_id'];
$product_code = $row_payment['product_code'];
$date = $row_payment['date'];
$bank_prof = $row_payment['bank_prof'];
$status = $row_payment['status'];
$issue_date = $row_payment['issue_date'];
$delivery_details = $row_payment['delivery_details'];
$qty = $row_payment['qty'];
$total_amount = $row_payment['total_amount'];
$bank_name = $row_payment['bank_name'];
$time = $row_payment['time'];
$payment_method = $row_payment['payment_method'];
$remark = $row_payment['remark'];
$bv_1 = $row_payment['bv'];
$cp_1 = $row_payment['cp'];
$order_code_1 = $row_payment['order_code'];
$delivery_address_1 = $row_payment['delivery_address'];
$select_query = "select * from products where product_id='$product_code'";
$run = mysqli_query($con,$select_query);
$num_right_1 = mysqli_num_rows($run);
while ($row = mysqli_fetch_array($run)) {
$product_id = $row['product_id'];
$product_title = $row['product_title'];
$cp = $row['cp'];
$bv = $row['bv'];
$mrp = $row['mrp'];
$image = $row['image'];
}
$select_query_view = "select * from member where member_no='$member_no'";
$run_view = mysqli_query($con,$select_query_view);
while ($row_view = mysqli_fetch_array($run_view)) {
$user_id_view = $row_view['user_id'];
$name_view = $row_view['name'];
}
?>
<tr class="gradeX">
<td><?= $s_num_payment; ?></td>
<td><?= $date; ?></td>
<td><?= $name_view; ?></td>
<td><?= $user_id_view; ?></td>
<td><?= $cp_1; ?></td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
<!-- /.box-body -->
</div>
<!-- /.box -->
<!-- /.box -->
</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 © 2020. 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 -->
<!-- jQuery 3 -->
<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>
<!-- This is data table -->
<script src="assets/vendor_plugins/DataTables-1.10.15/media/js/jquery.dataTables.min.js"></script>
<!-- start - This is for export functionality only -->
<script src="assets/vendor_plugins/DataTables-1.10.15/extensions/Buttons/js/dataTables.buttons.min.js"></script>
<script src="assets/vendor_plugins/DataTables-1.10.15/extensions/Buttons/js/buttons.flash.min.js"></script>
<script src="assets/vendor_plugins/DataTables-1.10.15/ex-js/jszip.min.js"></script>
<script src="assets/vendor_plugins/DataTables-1.10.15/ex-js/pdfmake.min.js"></script>
<script src="assets/vendor_plugins/DataTables-1.10.15/ex-js/vfs_fonts.js"></script>
<script src="assets/vendor_plugins/DataTables-1.10.15/extensions/Buttons/js/buttons.html5.min.js"></script>
<script src="assets/vendor_plugins/DataTables-1.10.15/extensions/Buttons/js/buttons.print.min.js"></script>
<!-- end - This is for export functionality only -->
<!-- maximum_admin for Data Table -->
<script src="js/pages/data-table.js"></script>
</body>
</html>