|
Server IP : 82.112.239.40 / Your IP : 216.73.216.81 Web Server : LiteSpeed System : Linux in-mum-web1676.main-hosting.eu 5.14.0-503.38.1.el9_5.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Apr 18 08:52:10 EDT 2025 x86_64 User : u641149403 ( 641149403) PHP Version : 7.3.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF Directory (0755) : /home/u641149403/domains/uniformindia.co.in/public_html/admin/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
// start session
session_start();
// set time for session timeout
$currentTime = time() + 25200;
$expired = 3600;
// if session not set go to login page
if(!isset($_SESSION['user'])){
header("location:index.php");
}
// if current time is more than session timeout back to login page
if($currentTime > $_SESSION['timeout']){
session_destroy();
header("location:index.php");
}
// destroy previous session timeout and create new one
unset($_SESSION['timeout']);
$_SESSION['timeout'] = $currentTime + $expired;
?>
<?php include"header.php";?>
<html>
<head>
<title>Sales Report | <?=$settings['app_name']?> - Dashboard</title>
</head>
</body>
<!-- Content Wrapper. Contains page content -->
<div class="content-wrapper">
<?php
include_once('includes/functions.php');
?>
<?php
if($permissions['orders']['read']==1) {
$sql_daily = "SELECT SUM(final_total) as num FROM orders";
$db->sql($sql_daily);
$total_sale_amount = $db->getResult();
$total_sale_amount = $total_sale_amount[0]['num'];
?>
<section class="content-header">
<h1>Sales Report</h1>
<ol class="breadcrumb">
<li><a href="home.php"><i class="fa fa-home"></i> Home </a></li>
</ol>
<hr/>
</section>
<style>
.uppercase {
text-transform: uppercase;
}
</style>
<!-- search form -->
<section class="content">
<!-- Main row -->
<div class="row">
<div class="col-md-12">
<div class="box box-info">
<div class="box-header with-border">
<h3 class="box-title">Sales Report</h3>
<div class="box-tools pull-right">
<button class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i></button>
<button class="btn btn-box-tool" data-widget="remove"><i class="fa fa-times"></i></button>
</div>
<form method="POST" id="filter_form" name="filter_form">
<div class="form-group">
<div class="col-md-3 col-sm-3 col-xs-12"><a class="btn btn-success">Total Sale Amount - ₹ <span class="total_sale"><?=$total_sale_amount;?></span></a></div>
<label for="from" class="control-label col-md-2 col-sm-3 col-xs-12">From & To Date</label>
<div class="col-md-4">
<input type="text" class="form-control" id="date" name="date" autocomplete="off" />
</div>
<input type="hidden" id="start_date" name="start_date">
<input type="hidden" id="end_date" name="end_date">
</div>
<div class="form-group">
<select id="filter_order" name="filter_order" placeholder="Select Status" required class="form-control" style="width: 300px;">
<option value="">All Orders</option>
<option value='received'>Received</option>
<option value='processed'>Processed</option>
<option value='shipped'>Shipped</option>
<option value='delivered'>Delivered</option>
<option value='cancelled'>Cancelled</option>
<option value='returned'>Returned</option>
</select>
</div>
<input type="hidden" id="filter_order_status" name="filter_order_status">
<div class="form-group">
</div>
</form>
</div>
<div class="box-body">
<div class="table-responsive">
<table class="table no-margin" data-toggle="table" id="order_list"
data-url="api-firebase/get-bootstrap-table-data.php?table=sale_report"
data-page-list="[5, 10, 20, 50, 100, 200]"
data-show-refresh="true" data-show-columns="true"
data-side-pagination="server" data-pagination="true"
data-search="true" data-trim-on-search="false"
data-sort-name="id" data-sort-order="desc"
data-query-params="queryParams_1"
>
<thead>
<tr>
<th data-field="id" data-sortable='true'>O.ID</th>
<th data-field="name" data-sortable='true'>User Name</th>
<th data-field="mobile" data-sortable='true' data-visible="true">User Contact</th>
<th data-field="date_added" data-sortable='true' data-visible="true">Order Date</th>
<th data-field="active_status" data-sortable='true' data-visible='true'>Status</th>
<th data-field="final_total" data-sortable='true'>Final Total</th>
</tr>
</thead>
</table>
</div>
</div>
</div>
</div>
</div>
</section>
<?php } else { ?>
<div class="alert alert-danger topmargin-sm leftmargin-sm">You have no permission to view orders.</div>
<?php } ?>
<!-- /.content -->
<script>
$('#filter_order').on('change', function() {
status = $('#filter_order').val();
$('#filter_order_status').val(status);
});
</script>
<script>
$(document).ready(function(){
$('#date').daterangepicker({
"autoApply": true,
"showDropdowns": true,
"alwaysShowCalendars":true,
"startDate":moment(),
"endDate":moment(),
"locale": {
"format": "DD/MM/YYYY",
"separator": " - "
},
});
$('#date').on('apply.daterangepicker', function(ev, picker) {
var drp = $('#date').data('daterangepicker');
$('#start_date').val(drp.startDate.format('YYYY-MM-DD'));
$('#end_date').val(drp.endDate.format('YYYY-MM-DD'));
});
$('#date').on('apply.daterangepicker', function(ev, picker) {
var drp = $('#date').data('daterangepicker');
$('#start_date').val(drp.startDate.format('YYYY-MM-DD'));
$('#end_date').val(drp.endDate.format('YYYY-MM-DD'));
$('#order_list').bootstrapTable('refresh');
});
$('#filter_order').on('change',function(){
// alert('change');
$('#order_list').bootstrapTable('refresh');
});
});
function queryParams_1(p){
return {
"start_date": $('#start_date').val(),
"end_date": $('#end_date').val(),
"filter_order": $('#filter_order_status').val(),
limit:p.limit,
sort:p.sort,
order:p.order,
offset:p.offset,
search:p.search
};
}
$( document ).ready(function() {
setInterval(()=>{
var start_date = $('#start_date').val();
var end_date = $('#end_date').val();
if(start_date!=''){
$.ajax({
type: 'POST',
url: "get_sale_price.php",
data: {
start_date: start_date,end_date: end_date,
},
success: function (response) {
$('.total_sale').text(response);
},
});
}
},1000);
})
</script>
<?php
$db->disconnect();
?>
</body>
</html>
<?php include"footer.php";?>