<?php
include("db/cn.php");
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
if (isset($_SESSION['user_name']) && isset($_SESSION['user_role']) && isset($_SESSION['outlet_name']) && isset($_SESSION['outlet_address'])) {
$userName = $_SESSION['user_name'];
$userRole = $_SESSION['user_role'];
$outlet_address = $_SESSION['outlet_address'];
$outlet_name = $_SESSION['outlet_name'];
}
// daily over view Query--------------------
$da = date("Y-m-d");
$date_time = date('Y-m-d');
$D1 = 0;
$die = mysqli_query($connection,"select * from add_read where nosal_number = 'D-1' && date_time = '$da'");
while($di = mysqli_fetch_array($die)){
$D1 += $di["read_number"];
}
$D1e = 0;
$die1 = mysqli_query($connection,"select * from end_read where nosal_number = 'D-1' && date_time = '$da'");
while($di1 = mysqli_fetch_array($die1)){
$D1e += $di1["read_number"];
}
$D2 = 0;
$die2 = mysqli_query($connection,"select * from add_read where nosal_number = 'D-2' && date_time = '$da'");
while($d2 = mysqli_fetch_array($die2)){
$D2 += $di2["read_number"];
}
$D2e = 0;
$die2e = mysqli_query($connection,"select * from end_read where nosal_number = 'D-2' && date_time = '$da'");
while($di2e = mysqli_fetch_array($die2e)){
$D2e += $di2e["read_number"];
}
$di1_read = $D1e - $D1 ;
$di2_read = $D2e - $D2 ;
$total_diesel = $di1_read + $di2_read;
//------------Petrol---------------------------
$P3 = 0;
$pet3 = mysqli_query($connection,"select * from add_read where nosal_number = 'P-3' && date_time = '$da'");
while($pe3 = mysqli_fetch_array($pet3)){
$P3 += $pe3["read_number"];
}
$P3e = 0;
$pet3e = mysqli_query($connection,"select * from end_read where nosal_number = 'P-3' && date_time = '$da'");
while($pe3e = mysqli_fetch_array($pet3e)){
$P3e += $pe3e["read_number"];
}
$P4 = 0;
$pet4 = mysqli_query($connection,"select * from add_read where nosal_number = 'P-4' && date_time = '$da'");
while($pe4 = mysqli_fetch_array($pet4)){
$P4 += $pe4["read_number"];
}
$P4e = 0;
$pet4e = mysqli_query($connection,"select * from end_read where nosal_number = 'P-4' && date_time = '$da'");
while($pe4e = mysqli_fetch_array($pet4e)){
$P4e += $pe4e["read_number"];
}
$P5 = 0;
$pet5 = mysqli_query($connection,"select * from add_read where nosal_number = 'P-5' && date_time = '$da'");
while($pe5 = mysqli_fetch_array($pet5)){
$P5 += $pe5["read_number"];
}
$P5e = 0;
$pet5e = mysqli_query($connection,"select * from end_read where nosal_number = 'P-5' && date_time = '$da'");
while($pe5e = mysqli_fetch_array($pet5e)){
$P5e += $pe5e["read_number"];
}
$P6 = 0;
$pet6 = mysqli_query($connection,"select * from add_read where nosal_number = 'P-6' && date_time = '$da'");
while($pe6 = mysqli_fetch_array($pet6)){
$P6 += $pe6["read_number"];
}
$P6e = 0;
$pet6e = mysqli_query($connection,"select * from end_read where nosal_number = 'P-6' && date_time = '$da'");
while($pe6e = mysqli_fetch_array($pet6e)){
$P6e += $pe6e["read_number"];
}
$p3Read = $P3e - $P3;
$p4Read = $P4e - $P4 ;
$p5Read = $P5e - $P5 ;
$p6Read = $P6e - $P6 ;
$total_petrol = $p3Read + $p4Read + $p5Read + $p6Read;
$pr_pr = mysqli_query($connection,"select * from products where product_name = 'Petrol'");
$prPro = mysqli_fetch_array($pr_pr);
$pro_pr = @$prPro["retail_price"];
$pr_dr = mysqli_query($connection,"select * from products where product_name = 'Diesel'");
$prdro = mysqli_fetch_array($pr_dr);
$dro_r = round((int)@$prdro["retail_price"], 2);
$total_credit = 0;
$credit = mysqli_query($connection,"select * from log_user_sales where paid_by = 'credit' && date_time = '$da' GROUP BY order_id");
while($cr = mysqli_fetch_array($credit)){
$total_credit += $cr["discount_amount"];
}
$dru = 0;
$dr = mysqli_query($connection,"select * from drum_oil_s where date_time = '$da'");
while($Dr = mysqli_fetch_array($dr)){
$dru += $Dr["drum_oil_sale"];
}
$dr_pr = mysqli_query($connection,"select * from products where product_name = 'Drum oil'");
$drPro = mysqli_fetch_array($dr_pr);
$pro_dr = (int)@$drPro["retail_price"];
//------------- credit sales------------------
$total_credit = 0;
$credit = mysqli_query($connection,"select * from log_user_sales where paid_by = 'credit' && date_time = '$da' GROUP BY order_id");
while($cr = mysqli_fetch_array($credit)){
$total_credit += $cr["discount_amount"];
}
//---------------Credit Recieved-------------
$credit_cashrecievable = 0;
$credit_get = mysqli_query($connection, "
SELECT SUM(amount) AS total_amounts FROM credit_paid
WHERE date_time = '$date_time' AND user_name = '$userName' AND paid_by = 'cash'
");
$credit_data = mysqli_fetch_array($credit_get);
$credit_cashrecievable = $credit_data['total_amounts'] ?? 0;
//------------------cash paid----------------
$credit_done = 0;
$cash_paid = mysqli_query($connection, "
SELECT SUM(supplier_amount) AS total_amounts FROM supplier_paid
WHERE date_time = '$date_time' AND status = 'cash'
");
$cash_paid_data = mysqli_fetch_array($cash_paid);
$credit_done = $cash_paid_data['total_amounts'] ?? 0;
//-------------------cash Expense-------------
$totalAmount_cashexpense = 0;
$cash_out = mysqli_query($connection, "
SELECT SUM(amount) AS total_amount FROM incash
WHERE date_time = '$date_time' AND login_user = '$userName'
AND user_role = '$userRole' AND paid_by = 'cash'
");
$cash_outdata = mysqli_fetch_array($cash_out);
$totalAmount_cashexpense = $cash_outdata['total_amount'] ?? 0;
// daily over view Query-------------------- end
// Monthly over view Query--------------------
$m_firstDayOfMonth = date("Y-m-01");
$m_lastDayOfMonth = date("Y-m-t");
$m_dateFilter = "BETWEEN '$m_firstDayOfMonth' AND '$m_lastDayOfMonth'";
$m_D1 = 0;
$m_die = mysqli_query($connection, "SELECT * FROM add_read WHERE nosal_number = 'D-1' AND date_time $m_dateFilter");
while($m_di = mysqli_fetch_array($m_die)) {
$m_D1 += $m_di["read_number"];
}
$m_D1e = 0;
$m_die1 = mysqli_query($connection, "SELECT * FROM end_read WHERE nosal_number = 'D-1' AND date_time $m_dateFilter");
while($m_di1 = mysqli_fetch_array($m_die1)) {
$m_D1e += $m_di1["read_number"];
}
$m_D2 = 0;
$m_die2 = mysqli_query($connection, "SELECT * FROM add_read WHERE nosal_number = 'D-2' AND date_time $m_dateFilter");
while($m_di2 = mysqli_fetch_array($m_die2)) {
$m_D2 += $m_di2["read_number"];
}
$m_D2e = 0;
$m_die2e = mysqli_query($connection, "SELECT * FROM end_read WHERE nosal_number = 'D-2' AND date_time $m_dateFilter");
while($m_di2e = mysqli_fetch_array($m_die2e)) {
$m_D2e += $m_di2e["read_number"];
}
$m_di1_read = $m_D1e - $m_D1;
$m_di2_read = $m_D2e - $m_D2;
$m_total_diesel = $m_di1_read + $m_di2_read;
$m_P3 = 0;
$m_pet3 = mysqli_query($connection, "SELECT * FROM add_read WHERE nosal_number = 'P-3' AND date_time $m_dateFilter");
while($m_pe3 = mysqli_fetch_array($m_pet3)) {
$m_P3 += $m_pe3["read_number"];
}
$m_P3e = 0;
$m_pet3e = mysqli_query($connection, "SELECT * FROM end_read WHERE nosal_number = 'P-3' AND date_time $m_dateFilter");
while($m_pe3e = mysqli_fetch_array($m_pet3e)) {
$m_P3e += $m_pe3e["read_number"];
}
$m_P4 = 0;
$m_pet4 = mysqli_query($connection, "SELECT * FROM add_read WHERE nosal_number = 'P-4' AND date_time $m_dateFilter");
while($m_pe4 = mysqli_fetch_array($m_pet4)) {
$m_P4 += $m_pe4["read_number"];
}
$m_P4e = 0;
$m_pet4e = mysqli_query($connection, "SELECT * FROM end_read WHERE nosal_number = 'P-4' AND date_time $m_dateFilter");
while($m_pe4e = mysqli_fetch_array($m_pet4e)) {
$m_P4e += $m_pe4e["read_number"];
}
$m_P5 = 0;
$m_pet5 = mysqli_query($connection, "SELECT * FROM add_read WHERE nosal_number = 'P-5' AND date_time $m_dateFilter");
while($m_pe5 = mysqli_fetch_array($m_pet5)) {
$m_P5 += $m_pe5["read_number"];
}
$m_P5e = 0;
$m_pet5e = mysqli_query($connection, "SELECT * FROM end_read WHERE nosal_number = 'P-5' AND date_time $m_dateFilter");
while($m_pe5e = mysqli_fetch_array($m_pet5e)) {
$m_P5e += $m_pe5e["read_number"];
}
$m_P6 = 0;
$m_pet6 = mysqli_query($connection, "SELECT * FROM add_read WHERE nosal_number = 'P-6' AND date_time $m_dateFilter");
while($m_pe6 = mysqli_fetch_array($m_pet6)) {
$m_P6 += $m_pe6["read_number"];
}
$m_P6e = 0;
$m_pet6e = mysqli_query($connection, "SELECT * FROM end_read WHERE nosal_number = 'P-6' AND date_time $m_dateFilter");
while($m_pe6e = mysqli_fetch_array($m_pet6e)) {
$m_P6e += $m_pe6e["read_number"];
}
$m_p3Read = $m_P3e - $m_P3;
$m_p4Read = $m_P4e - $m_P4;
$m_p5Read = $m_P5e - $m_P5;
$m_p6Read = $m_P6e - $m_P6;
$m_total_petrol = $m_p3Read + $m_p4Read + $m_p5Read + $m_p6Read;
$m_pr_pr = mysqli_query($connection, "SELECT * FROM products WHERE product_name = 'Petrol'");
$m_prPro = mysqli_fetch_array($m_pr_pr);
$m_pro_pr = @$m_prPro["retail_price"];
$m_pr_dr = mysqli_query($connection, "SELECT * FROM products WHERE product_name = 'Diesel'");
$m_prdro = mysqli_fetch_array($m_pr_dr);
$m_dro_r = round((int)@$m_prdro["retail_price"], 2);
$m_total_credit = 0;
$m_credit = mysqli_query($connection, "SELECT * FROM log_user_sales WHERE paid_by = 'credit' AND date_time $m_dateFilter GROUP BY order_id");
while($m_cr = mysqli_fetch_array($m_credit)) {
$m_total_credit += $m_cr["discount_amount"];
}
$m_dru = 0;
$m_dr = mysqli_query($connection, "SELECT * FROM drum_oil_s WHERE date_time $m_dateFilter");
while($m_Dr = mysqli_fetch_array($m_dr)) {
$m_dru += $m_Dr["drum_oil_sale"];
}
$m_dr_pr = mysqli_query($connection, "SELECT * FROM products WHERE product_name = 'Drum oil'");
$m_drPro = mysqli_fetch_array($m_dr_pr);
$m_pro_dr = (int)@$m_drPro["retail_price"];
$m_credit_cashrecievable = 0;
$m_credit_get = mysqli_query($connection, "
SELECT SUM(amount) AS total_amounts FROM credit_paid
WHERE date_time $m_dateFilter AND user_name = '$userName' AND paid_by = 'cash'");
$m_credit_data = mysqli_fetch_array($m_credit_get);
$m_credit_cashrecievable = $m_credit_data['total_amounts'] ?? 0;
$m_credit_done = 0;
$m_cash_paid = mysqli_query($connection, "
SELECT SUM(supplier_amount) AS total_amounts FROM supplier_paid
WHERE date_time $m_dateFilter AND status = 'cash'");
$m_cash_paid_data = mysqli_fetch_array($m_cash_paid);
$m_credit_done = $m_cash_paid_data['total_amounts'] ?? 0;
$m_totalAmount_cashexpense = 0;
$m_cash_out = mysqli_query($connection, "
SELECT SUM(amount) AS total_amount FROM incash
WHERE date_time $m_dateFilter AND login_user = '$userName'
AND user_role = '$userRole' AND paid_by = 'cash'");
$m_cash_outdata = mysqli_fetch_array($m_cash_out);
$m_totalAmount_cashexpense = $m_cash_outdata['total_amount'] ?? 0;
//-------------------Annual overview---------------
$A_dateFilter = "BETWEEN '" . date("Y-01-01") . "' AND '" . date("Y-12-31") . "'";
$A_D1 = 0;
$A_die = mysqli_query($connection, "SELECT * FROM add_read WHERE nosal_number = 'D-1' AND date_time $A_dateFilter");
while($A_di = mysqli_fetch_array($A_die)) {
$A_D1 += $A_di["read_number"];
}
$A_D1e = 0;
$A_die1 = mysqli_query($connection, "SELECT * FROM end_read WHERE nosal_number = 'D-1' AND date_time $A_dateFilter");
while($A_di1 = mysqli_fetch_array($A_die1)) {
$A_D1e += $A_di1["read_number"];
}
$A_D2 = 0;
$A_die2 = mysqli_query($connection, "SELECT * FROM add_read WHERE nosal_number = 'D-2' AND date_time $A_dateFilter");
while($A_di2 = mysqli_fetch_array($A_die2)) {
$A_D2 += $A_di2["read_number"];
}
$A_D2e = 0;
$A_die2e = mysqli_query($connection, "SELECT * FROM end_read WHERE nosal_number = 'D-2' AND date_time $A_dateFilter");
while($A_di2e = mysqli_fetch_array($A_die2e)) {
$A_D2e += $A_di2e["read_number"];
}
$A_di1_read = $A_D1e - $A_D1;
$A_di2_read = $A_D2e - $A_D2;
$A_total_diesel = $A_di1_read + $A_di2_read;
$A_P3 = 0;
$A_pet3 = mysqli_query($connection, "SELECT * FROM add_read WHERE nosal_number = 'P-3' AND date_time $A_dateFilter");
while($A_pe3 = mysqli_fetch_array($A_pet3)) {
$A_P3 += $A_pe3["read_number"];
}
$A_P3e = 0;
$A_pet3e = mysqli_query($connection, "SELECT * FROM end_read WHERE nosal_number = 'P-3' AND date_time $A_dateFilter");
while($A_pe3e = mysqli_fetch_array($A_pet3e)) {
$A_P3e += $A_pe3e["read_number"];
}
$A_P4 = 0;
$A_pet4 = mysqli_query($connection, "SELECT * FROM add_read WHERE nosal_number = 'P-4' AND date_time $A_dateFilter");
while($A_pe4 = mysqli_fetch_array($A_pet4)) {
$A_P4 += $A_pe4["read_number"];
}
$A_P4e = 0;
$A_pet4e = mysqli_query($connection, "SELECT * FROM end_read WHERE nosal_number = 'P-4' AND date_time $A_dateFilter");
while($A_pe4e = mysqli_fetch_array($A_pet4e)) {
$A_P4e += $A_pe4e["read_number"];
}
$A_P5 = 0;
$A_pet5 = mysqli_query($connection, "SELECT * FROM add_read WHERE nosal_number = 'P-5' AND date_time $A_dateFilter");
while($A_pe5 = mysqli_fetch_array($A_pet5)) {
$A_P5 += $A_pe5["read_number"];
}
$A_P5e = 0;
$A_pet5e = mysqli_query($connection, "SELECT * FROM end_read WHERE nosal_number = 'P-5' AND date_time $A_dateFilter");
while($A_pe5e = mysqli_fetch_array($A_pet5e)) {
$A_P5e += $A_pe5e["read_number"];
}
$A_P6 = 0;
$A_pet6 = mysqli_query($connection, "SELECT * FROM add_read WHERE nosal_number = 'P-6' AND date_time $A_dateFilter");
while($A_pe6 = mysqli_fetch_array($A_pet6)) {
$A_P6 += $A_pe6["read_number"];
}
$A_P6e = 0;
$A_pet6e = mysqli_query($connection, "SELECT * FROM end_read WHERE nosal_number = 'P-6' AND date_time $A_dateFilter");
while($A_pe6e = mysqli_fetch_array($A_pet6e)) {
$A_P6e += $A_pe6e["read_number"];
}
$A_p3Read = $A_P3e - $A_P3;
$A_p4Read = $A_P4e - $A_P4;
$A_p5Read = $A_P5e - $A_P5;
$A_p6Read = $A_P6e - $A_P6;
$A_total_petrol = $A_p3Read + $A_p4Read + $A_p5Read + $A_p6Read;
$A_pr_pr = mysqli_query($connection, "SELECT * FROM products WHERE product_name = 'Petrol'");
$A_prPro = mysqli_fetch_array($A_pr_pr);
$A_pro_pr = @$A_prPro["retail_price"];
$A_pr_dr = mysqli_query($connection, "SELECT * FROM products WHERE product_name = 'Diesel'");
$A_prdro = mysqli_fetch_array($A_pr_dr);
$A_dro_r = round((int)@$A_prdro["retail_price"], 2);
$A_total_credit = 0;
$A_credit = mysqli_query($connection, "SELECT * FROM log_user_sales WHERE paid_by = 'credit' AND date_time $A_dateFilter GROUP BY order_id");
while($A_cr = mysqli_fetch_array($A_credit)) {
$A_total_credit += $A_cr["discount_amount"];
}
$A_dru = 0;
$A_dr = mysqli_query($connection, "SELECT * FROM drum_oil_s WHERE date_time $A_dateFilter");
while($A_Dr = mysqli_fetch_array($A_dr)) {
$A_dru += $A_Dr["drum_oil_sale"];
}
$A_dr_pr = mysqli_query($connection, "SELECT * FROM products WHERE product_name = 'Drum oil'");
$A_drPro = mysqli_fetch_array($A_dr_pr);
$A_pro_dr = (int)@$A_drPro["retail_price"];
$A_credit_cashrecievable = 0;
$A_credit_get = mysqli_query($connection, "
SELECT SUM(amount) AS total_amounts FROM credit_paid
WHERE date_time $A_dateFilter AND user_name = '$userName' AND paid_by = 'cash'");
$A_credit_data = mysqli_fetch_array($A_credit_get);
$A_credit_cashrecievable = $A_credit_data['total_amounts'] ?? 0;
$A_credit_done = 0;
$A_cash_paid = mysqli_query($connection, "
SELECT SUM(supplier_amount) AS total_amounts FROM supplier_paid
WHERE date_time $A_dateFilter AND status = 'cash'");
$A_cash_paid_data = mysqli_fetch_array($A_cash_paid);
$A_credit_done = $A_cash_paid_data['total_amounts'] ?? 0;
$A_totalAmount_cashexpense = 0;
$A_cash_out = mysqli_query($connection, "
SELECT SUM(amount) AS total_amount FROM incash
WHERE date_time $A_dateFilter AND login_user = '$userName'
AND user_role = '$userRole' AND paid_by = 'cash'");
$A_cash_outdata = mysqli_fetch_array($A_cash_out);
$A_totalAmount_cashexpense = $A_cash_outdata['total_amount'] ?? 0;
?>
<!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, shrink-to-fit=no">
<meta name="description" content="">
<meta name="author" content="">
<title>Bilal Gujjar Petroleum</title>
<!-- Custom fonts for this template-->
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.5.0/css/all.min.css" />
<link href="https://fonts.googleapis.com/css2?family=Quicksand:wght@200;300;400;500;600;700&display=swap" rel="stylesheet">
<!-- Custom styles for this template-->
<link href="../css/sb-admin-2.min.css" rel="stylesheet">
<script src="https://cdn.jsdelivr.net/npm/chart.js"></script>
</head>
<style>
body {
font-family: 'Quicksand', sans-serif;
}
.chart-container {
position: relative;
background: rgba(255, 255, 255, 0.9);
border-radius: 10px;
padding: 15px;
box-shadow: 0 0 10px rgba(0, 0, 0, 0.2);
}
canvas {
max-width: 100%;
height: auto;
}
.bg-gradient-primary{
background:#0A4657;
color:#fff;
}
.btn-primary{
background:#0A4657;
color:#fff;
border:1px #0A4657 solid;
}
.btn-primary:hover{
background:#fff;
border:1px #0A4657 solid;
color:#0A4657;
}
.chart-container {
position: relative;
background: rgba(255, 255, 255, 0.9);
border-radius: 10px;
padding: 15px;
box-shadow: 0 0 10px rgba(0, 0, 0, 0.2);
}
canvas {
max-width: 100%;
height: auto;
}
.fa-download:hover{
color:#953E39;
}
</style>
<body id="page-top">
<!-- Page Wrapper -->
<div id="wrapper">
<!-- Sidebar -->
<?php
include("common/sd.php");
?>
<!-- End of Sidebar -->
<!-- Content Wrapper -->
<div id="content-wrapper" class="d-flex flex-column">
<!-- Main Content -->
<div id="content">
<!-- Topbar -->
<nav class="navbar navbar-expand navbar-light bg-white topbar mb-4 static-top shadow">
<!-- Sidebar Toggle (Topbar) -->
<button id="sidebarToggleTop" class="btn btn-link d-md-none rounded-circle mr-3">
<i class="fa fa-bars"></i>
</button>
<!-- Topbar Search -->
<?php include('common/log.php'); ?>
<!-- Topbar Navbar -->
</nav>
<!-- End of Topbar -->
<!-- Begin Page Content -->
<div class="container-fluid">
<div class="d-sm-flex align-items-center justify-content-between mb-4">
<h1 class="h3 mb-0 text-gray-800" style="font-weight:700;">Dashboard</h1>
</div>
<div class="container-fluid" style="background: linear-gradient(360deg, #060606, #0A4657); border:5px solid #E3EAEC; border-radius:20px;">
<div class="row">
<div class="col-sm-5">
<br>
<img src="../img/logo231.png" width="120" height="120">
<br><br>
<h3 class="mb-3 text-white" style="font-size:25px;font-weight:700;">Welcome Admin ,<br>Bilal Gujjar Petroleum</h3>
<p class="text-white btn btn-dark btn-sm">Logged In</p>
</div>
<div class="col-sm-2"></div>
<div class="col-sm-5">
<img src="../img/school.png" width="596" height="371" class="img-fluid" />
</div>
</div>
</div>
<br><br>
</div>
<div class="container-fluid">
<div class="d-sm-flex align-items-center justify-content-between mb-4">
</div>
<div class="container-fluid">
<div class="d-sm-flex align-items-center justify-content-between mb-4">
<h1 class="h3 mb-0 text-gray-800" style="font-weight:700;">Daily Overview</h1>
</div>
<div class="row">
<div class="col-xl-3 col-md-6 mb-4">
<div class="card border-left-dark shadow h-100 py-2">
<div class="card-body">
<div class="row no-gutters align-items-center">
<div class="col mr-2">
<div class="text-xs font-weight-bold text-uppercase mb-1" style="font-size:13px;color:#597445;">
Diesel Sale</div>
<div class="h5 mb-0 font-weight-bold text-gray-800">Rs.
<?php echo $totd = $total_diesel * $dro_r; ?>
/-</div>
</div>
<div class="col-auto">
<i class="fas fa-rupee-sign fa-2x" style="color:#597445;"></i>
</div>
</div>
</div>
</div>
</div>
<div class="col-xl-3 col-md-6 mb-4">
<div class="card border-left-dark shadow h-100 py-2">
<div class="card-body">
<div class="row no-gutters align-items-center">
<div class="col mr-2">
<div class="text-xs font-weight-bold text-uppercase mb-1" style="font-size:13px;color:#597445;">
Petrol Sale</div>
<div class="h5 mb-0 font-weight-bold text-gray-800">Rs.
<?php $totp = $total_petrol * $pro_pr ;
echo $totp;
?>
/-</div>
</div>
<div class="col-auto">
<i class="fas fa-rupee-sign fa-2x" style="color:#597445;"></i>
</div>
</div>
</div>
</div>
</div>
<div class="col-xl-3 col-md-6 mb-4">
<div class="card border-left-dark shadow h-100 py-2">
<div class="card-body">
<div class="row no-gutters align-items-center">
<div class="col mr-2">
<div class="text-xs font-weight-bold text-uppercase mb-1" style="font-size:13px;color:#597445;">
Drum Oil Sale </div>
<div class="h5 mb-0 font-weight-bold text-gray-800">Rs. <?php $tdr = $dru * $pro_dr ;
echo $tdr;
?> /-</div>
</div>
<div class="col-auto">
<i class="fas fa-rupee-sign fa-2x " style="color:#597445;"></i>
</div>
</div>
</div>
</div>
</div>
<!-- Earnings (Monthly) Card Example -->
<div class="col-xl-3 col-md-6 mb-4">
<div class="card border-left-dark shadow h-100 py-2">
<div class="card-body">
<div class="row no-gutters align-items-center">
<div class="col mr-2">
<div class="text-xs font-weight-bold text-uppercase mb-1" style="font-size:13px;color:#597445;">
Total Sales</div>
<div class="h5 mb-0 font-weight-bold text-gray-800">Rs. <?php $totalSal = $totd + $totp + $tdr;
echo $totalSal ; ?> /-</div>
</div>
<div class="col-auto">
<i class="fas fa-rupee-sign fa-2x " style="color:#597445;"></i>
</div>
</div>
</div>
</div>
</div>
<!-- Earnings (Monthly) Card Example -->
<div class="col-xl-3 col-md-6 mb-4">
<div class="card border-left-dark shadow h-100 py-2">
<div class="card-body">
<div class="row no-gutters align-items-center">
<div class="col mr-2">
<div class="text-xs font-weight-bold text-uppercase mb-1" style="font-size:13px;color:#597445;">
Credit Sales </div>
<div class="h5 mb-0 font-weight-bold text-gray-800"> Rs. <?php echo $total_credit; ?> /-</div>
</div>
<div class="col-auto">
<i class="fas fa-rupee-sign fa-2x " style="color:#597445;"></i>
</div>
</div>
</div>
</div>
</div>
<!-- Earnings (Monthly) Card Example -->
<div class="col-xl-3 col-md-6 mb-4">
<div class="card border-left-dark shadow h-100 py-2">
<div class="card-body">
<div class="row no-gutters align-items-center">
<div class="col mr-2">
<div class="text-xs font-weight-bold text-uppercase mb-1" style="font-size:13px;color:#597445;">
Cash Sales</div>
<div class="h5 mb-0 font-weight-bold text-gray-800">Rs. <?php $totaLSales = $totalSal - $total_credit ;
echo $totaLSales;
?> /-</div>
</div>
<div class="col-auto">
<i class="fas fa-rupee-sign fa-2x " style="color:#597445;"></i>
</div>
</div>
</div>
</div>
</div>
<!-- Earnings (Monthly) Card Example -->
<div class="col-xl-3 col-md-6 mb-4">
<div class="card border-left-dark shadow h-100 py-2">
<div class="card-body">
<div class="row no-gutters align-items-center">
<div class="col mr-2">
<div class="text-xs font-weight-bold text-uppercase mb-1" style="font-size:13px;color:#597445;">
Cash Recieved</div>
<div class="h5 mb-0 font-weight-bold text-gray-800">Rs. <?php echo $credit_cashrecievable; ?> /-</div>
</div>
<div class="col-auto">
<i class="fas fa-rupee-sign fa-2x " style="color:#597445;"></i>
</div>
</div>
</div>
</div>
</div>
<!-- Earnings (Monthly) Card Example -->
<div class="col-xl-3 col-md-6 mb-4">
<div class="card border-left-dark shadow h-100 py-2">
<div class="card-body">
<div class="row no-gutters align-items-center">
<div class="col mr-2">
<div class="text-xs font-weight-bold text-uppercase mb-1" style="font-size:13px;color:#597445;">
Cash Paid </div>
<div class="h5 mb-0 font-weight-bold text-gray-800">Rs. <?php echo $credit_done; ?> /-</div>
</div>
<div class="col-auto">
<i class="fas fa-rupee-sign fa-2x " style="color:#597445;"></i>
</div>
</div>
</div>
</div>
</div>
<div class="col-xl-3 col-md-6 mb-4">
<div class="card border-left-dark shadow h-100 py-2">
<div class="card-body">
<div class="row no-gutters align-items-center">
<div class="col mr-2">
<div class="text-xs font-weight-bold text-uppercase mb-1" style="font-size:13px;color:#597445;">
Cash Expense </div>
<div class="h5 mb-0 font-weight-bold text-gray-800">Rs. <?php echo $totalAmount_cashexpense; ?> /-</div>
</div>
<div class="col-auto">
<i class="fas fa-rupee-sign fa-2x " style="color:#597445;"></i>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br />
<div class="container-fluid">
<div class="d-sm-flex align-items-center justify-content-between mb-4">
<h1 class="h3 mb-0 text-gray-800" style="font-weight:700;">Monthly Overview</h1>
</div>
<div class="row">
<div class="col-xl-3 col-md-6 mb-4">
<div class="card border-left-dark shadow h-100 py-2">
<div class="card-body">
<div class="row no-gutters align-items-center">
<div class="col mr-2">
<div class="text-xs font-weight-bold text-uppercase mb-1" style="font-size:13px;color:#597445;">
Diesel Sale</div>
<div class="h5 mb-0 font-weight-bold text-gray-800">Rs.
<?php echo $m_totd = $m_total_diesel * $m_dro_r; ?>
/-</div>
</div>
<div class="col-auto">
<i class="fas fa-rupee-sign fa-2x" style="color:#597445;"></i>
</div>
</div>
</div>
</div>
</div>
<div class="col-xl-3 col-md-6 mb-4">
<div class="card border-left-dark shadow h-100 py-2">
<div class="card-body">
<div class="row no-gutters align-items-center">
<div class="col mr-2">
<div class="text-xs font-weight-bold text-uppercase mb-1" style="font-size:13px;color:#597445;">
Petrol Sale</div>
<div class="h5 mb-0 font-weight-bold text-gray-800">Rs.
<?php $m_totp = $m_total_petrol * $m_pro_pr ;
echo $m_totp;
?>
/-</div>
</div>
<div class="col-auto">
<i class="fas fa-rupee-sign fa-2x" style="color:#597445;"></i>
</div>
</div>
</div>
</div>
</div>
<div class="col-xl-3 col-md-6 mb-4">
<div class="card border-left-dark shadow h-100 py-2">
<div class="card-body">
<div class="row no-gutters align-items-center">
<div class="col mr-2">
<div class="text-xs font-weight-bold text-uppercase mb-1" style="font-size:13px;color:#597445;">
Drum Oil Sale </div>
<div class="h5 mb-0 font-weight-bold text-gray-800">Rs. <?php $m_tdr = $m_dru * $m_pro_dr ;
echo $m_tdr;
?> /-</div>
</div>
<div class="col-auto">
<i class="fas fa-rupee-sign fa-2x " style="color:#597445;"></i>
</div>
</div>
</div>
</div>
</div>
<!-- Earnings (Monthly) Card Example -->
<div class="col-xl-3 col-md-6 mb-4">
<div class="card border-left-dark shadow h-100 py-2">
<div class="card-body">
<div class="row no-gutters align-items-center">
<div class="col mr-2">
<div class="text-xs font-weight-bold text-uppercase mb-1" style="font-size:13px;color:#597445;">
Total Sales</div>
<div class="h5 mb-0 font-weight-bold text-gray-800">Rs. <?php $m_totalSal = $m_totd + $m_totp + $m_tdr;
echo $m_totalSal ; ?> /-</div>
</div>
<div class="col-auto">
<i class="fas fa-rupee-sign fa-2x " style="color:#597445;"></i>
</div>
</div>
</div>
</div>
</div>
<!-- Earnings (Monthly) Card Example -->
<div class="col-xl-3 col-md-6 mb-4">
<div class="card border-left-dark shadow h-100 py-2">
<div class="card-body">
<div class="row no-gutters align-items-center">
<div class="col mr-2">
<div class="text-xs font-weight-bold text-uppercase mb-1" style="font-size:13px;color:#597445;">
Credit Sales </div>
<div class="h5 mb-0 font-weight-bold text-gray-800"> Rs. <?php echo $m_total_credit; ?> /-</div>
</div>
<div class="col-auto">
<i class="fas fa-rupee-sign fa-2x " style="color:#597445;"></i>
</div>
</div>
</div>
</div>
</div>
<!-- Earnings (Monthly) Card Example -->
<div class="col-xl-3 col-md-6 mb-4">
<div class="card border-left-dark shadow h-100 py-2">
<div class="card-body">
<div class="row no-gutters align-items-center">
<div class="col mr-2">
<div class="text-xs font-weight-bold text-uppercase mb-1" style="font-size:13px;color:#597445;">
Cash Sales</div>
<div class="h5 mb-0 font-weight-bold text-gray-800">Rs. <?php $m_totaLSales = $m_totalSal - $m_total_credit ;
echo $m_totaLSales;
?> /-</div>
</div>
<div class="col-auto">
<i class="fas fa-rupee-sign fa-2x " style="color:#597445;"></i>
</div>
</div>
</div>
</div>
</div>
<!-- Earnings (Monthly) Card Example -->
<div class="col-xl-3 col-md-6 mb-4">
<div class="card border-left-dark shadow h-100 py-2">
<div class="card-body">
<div class="row no-gutters align-items-center">
<div class="col mr-2">
<div class="text-xs font-weight-bold text-uppercase mb-1" style="font-size:13px;color:#597445;">
Cash Recieved</div>
<div class="h5 mb-0 font-weight-bold text-gray-800">Rs. <?php echo $m_credit_cashrecievable; ?> /-</div>
</div>
<div class="col-auto">
<i class="fas fa-rupee-sign fa-2x " style="color:#597445;"></i>
</div>
</div>
</div>
</div>
</div>
<!-- Earnings (Monthly) Card Example -->
<div class="col-xl-3 col-md-6 mb-4">
<div class="card border-left-dark shadow h-100 py-2">
<div class="card-body">
<div class="row no-gutters align-items-center">
<div class="col mr-2">
<div class="text-xs font-weight-bold text-uppercase mb-1" style="font-size:13px;color:#597445;">
Cash Paid </div>
<div class="h5 mb-0 font-weight-bold text-gray-800">Rs. <?php echo $m_credit_done; ?> /-</div>
</div>
<div class="col-auto">
<i class="fas fa-rupee-sign fa-2x " style="color:#597445;"></i>
</div>
</div>
</div>
</div>
</div>
<div class="col-xl-3 col-md-6 mb-4">
<div class="card border-left-dark shadow h-100 py-2">
<div class="card-body">
<div class="row no-gutters align-items-center">
<div class="col mr-2">
<div class="text-xs font-weight-bold text-uppercase mb-1" style="font-size:13px;color:#597445;">
Cash Expense </div>
<div class="h5 mb-0 font-weight-bold text-gray-800">Rs. <?php echo $m_totalAmount_cashexpense; ?> /-</div>
</div>
<div class="col-auto">
<i class="fas fa-rupee-sign fa-2x " style="color:#597445;"></i>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="container-fluid">
<div class="d-sm-flex align-items-center justify-content-between mb-4">
<h1 class="h3 mb-0 text-gray-800" style="font-weight:700;">Annual Overview</h1>
</div>
<div class="row">
<div class="col-xl-3 col-md-6 mb-4">
<div class="card border-left-dark shadow h-100 py-2">
<div class="card-body">
<div class="row no-gutters align-items-center">
<div class="col mr-2">
<div class="text-xs font-weight-bold text-uppercase mb-1" style="font-size:13px;color:#597445;">
Diesel Sale</div>
<div class="h5 mb-0 font-weight-bold text-gray-800">Rs.
<?php echo $A_totd = $A_total_diesel * $A_dro_r; ?>
/-</div>
</div>
<div class="col-auto">
<i class="fas fa-rupee-sign fa-2x" style="color:#597445;"></i>
</div>
</div>
</div>
</div>
</div>
<div class="col-xl-3 col-md-6 mb-4">
<div class="card border-left-dark shadow h-100 py-2">
<div class="card-body">
<div class="row no-gutters align-items-center">
<div class="col mr-2">
<div class="text-xs font-weight-bold text-uppercase mb-1" style="font-size:13px;color:#597445;">
Petrol Sale</div>
<div class="h5 mb-0 font-weight-bold text-gray-800">Rs.
<?php $A_totp = $A_total_petrol * $A_pro_pr ;
echo $A_totp;
?>
/-</div>
</div>
<div class="col-auto">
<i class="fas fa-rupee-sign fa-2x" style="color:#597445;"></i>
</div>
</div>
</div>
</div>
</div>
<div class="col-xl-3 col-md-6 mb-4">
<div class="card border-left-dark shadow h-100 py-2">
<div class="card-body">
<div class="row no-gutters align-items-center">
<div class="col mr-2">
<div class="text-xs font-weight-bold text-uppercase mb-1" style="font-size:13px;color:#597445;">
Drum Oil Sale </div>
<div class="h5 mb-0 font-weight-bold text-gray-800">Rs. <?php $A_tdr = $A_dru * $A_pro_dr ;
echo $A_tdr;
?> /-</div>
</div>
<div class="col-auto">
<i class="fas fa-rupee-sign fa-2x " style="color:#597445;"></i>
</div>
</div>
</div>
</div>
</div>
<!-- Earnings (Monthly) Card Example -->
<div class="col-xl-3 col-md-6 mb-4">
<div class="card border-left-dark shadow h-100 py-2">
<div class="card-body">
<div class="row no-gutters align-items-center">
<div class="col mr-2">
<div class="text-xs font-weight-bold text-uppercase mb-1" style="font-size:13px;color:#597445;">
Total Sales</div>
<div class="h5 mb-0 font-weight-bold text-gray-800">Rs. <?php $A_totalSal = $A_totd + $A_totp + $A_tdr;
echo $A_totalSal ; ?> /-</div>
</div>
<div class="col-auto">
<i class="fas fa-rupee-sign fa-2x " style="color:#597445;"></i>
</div>
</div>
</div>
</div>
</div>
<!-- Earnings (Monthly) Card Example -->
<div class="col-xl-3 col-md-6 mb-4">
<div class="card border-left-dark shadow h-100 py-2">
<div class="card-body">
<div class="row no-gutters align-items-center">
<div class="col mr-2">
<div class="text-xs font-weight-bold text-uppercase mb-1" style="font-size:13px;color:#597445;">
Credit Sales </div>
<div class="h5 mb-0 font-weight-bold text-gray-800"> Rs. <?php echo $A_total_credit; ?> /-</div>
</div>
<div class="col-auto">
<i class="fas fa-rupee-sign fa-2x " style="color:#597445;"></i>
</div>
</div>
</div>
</div>
</div>
<!-- Earnings (Monthly) Card Example -->
<div class="col-xl-3 col-md-6 mb-4">
<div class="card border-left-dark shadow h-100 py-2">
<div class="card-body">
<div class="row no-gutters align-items-center">
<div class="col mr-2">
<div class="text-xs font-weight-bold text-uppercase mb-1" style="font-size:13px;color:#597445;">
Cash Sales</div>
<div class="h5 mb-0 font-weight-bold text-gray-800">Rs. <?php $A_totaLSales = $A_totalSal - $A_total_credit ;
echo $A_totaLSales;
?> /-</div>
</div>
<div class="col-auto">
<i class="fas fa-rupee-sign fa-2x " style="color:#597445;"></i>
</div>
</div>
</div>
</div>
</div>
<!-- Earnings (Monthly) Card Example -->
<div class="col-xl-3 col-md-6 mb-4">
<div class="card border-left-dark shadow h-100 py-2">
<div class="card-body">
<div class="row no-gutters align-items-center">
<div class="col mr-2">
<div class="text-xs font-weight-bold text-uppercase mb-1" style="font-size:13px;color:#597445;">
Cash Recieved</div>
<div class="h5 mb-0 font-weight-bold text-gray-800">Rs. <?php echo $A_credit_cashrecievable; ?> /-</div>
</div>
<div class="col-auto">
<i class="fas fa-rupee-sign fa-2x " style="color:#597445;"></i>
</div>
</div>
</div>
</div>
</div>
<!-- Earnings (Monthly) Card Example -->
<div class="col-xl-3 col-md-6 mb-4">
<div class="card border-left-dark shadow h-100 py-2">
<div class="card-body">
<div class="row no-gutters align-items-center">
<div class="col mr-2">
<div class="text-xs font-weight-bold text-uppercase mb-1" style="font-size:13px;color:#597445;">
Cash Paid </div>
<div class="h5 mb-0 font-weight-bold text-gray-800">Rs. <?php echo $A_credit_done; ?> /-</div>
</div>
<div class="col-auto">
<i class="fas fa-rupee-sign fa-2x " style="color:#597445;"></i>
</div>
</div>
</div>
</div>
</div>
<div class="col-xl-3 col-md-6 mb-4">
<div class="card border-left-dark shadow h-100 py-2">
<div class="card-body">
<div class="row no-gutters align-items-center">
<div class="col mr-2">
<div class="text-xs font-weight-bold text-uppercase mb-1" style="font-size:13px;color:#597445;">
Cash Expense </div>
<div class="h5 mb-0 font-weight-bold text-gray-800">Rs. <?php echo $A_totalAmount_cashexpense; ?> /-</div>
</div>
<div class="col-auto">
<i class="fas fa-rupee-sign fa-2x " style="color:#597445;"></i>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br />
</div>
<!-- /.container-fluid -->
</div>
<br><br>
<!-- End of Main Content -->
<!-- Footer -->
<?php include("common/main_ft.php"); ?>
<!-- End of Footer -->
</div>
<!-- End of Content Wrapper -->
</div>
<!-- End of Page Wrapper -->
<!-- Scroll to Top Button-->
<a class="scroll-to-top rounded" href="#page-top">
<i class="fas fa-angle-up"></i>
</a>
<!-- Logout Modal-->
<div class="modal fade" id="logoutModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel"
aria-hidden="true">
<div class="modal-dialog" role="document">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title" id="exampleModalLabel">Ready to Leave?</h5>
<button class="close" type="button" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body">Select "Logout" below if you are ready to end your current session.</div>
<div class="modal-footer">
<button class="btn btn-secondary" type="button" data-dismiss="modal">Cancel</button>
<a class="btn btn-primary" href="">Logout</a>
</div>
</div>
</div>
</div>
</div>
</body>
<script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.10.2/dist/umd/popper.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.10.2/dist/umd/popper.min.js"></script>
<!-- Bootstrap core JavaScript-->
<script src="../vendor/jquery/jquery.min.js"></script>
<script src="../vendor/bootstrap/js/bootstrap.bundle.min.js"></script>
<!-- Core plugin JavaScript-->
<script src="../vendor/jquery-easing/jquery.easing.min.js"></script>
<!-- Custom scripts for all pages-->
<script src="../js/sb-admin-2.min.js"></script>
</body>
</html>