MAINHACK

Viewing / Editing File: expenses_report.php

<?php include("../admin/includes/functions/functions.php");?>
<?php include("../admin/db/db.php");?>
<?php 
if(!isset($_SESSION['username_Xw211qAAsq4']))
{
header('Location: ../auth/');
exit();
} else{
$pageTitle1 = 'Expenses Report';
$shopname = $_SESSION['business_name_Xw211qAAsq4'];

$currency = mysqli_query($new,"SELECT currency from barber_admin WHERE
 business_name = '$shopname'");
 $fechC = mysqli_fetch_array($currency);
$qurtyCurrency = $fechC['currency'];

$active = 1;
 $stmt1 = $con->prepare("SELECT rate FROM comm_rate WHERE business_name = ? and active = ?");
$stmt1->execute(array($shopname,$active));
$rows = $stmt1->fetchAll();
foreach($rows as $row)
{
     $comRate1 =  $row['rate'];
    if($comRate1 == 0){
        $comRate = 0;
    } else {
         $comRate = $comRate1;
    }
}

if(isset($_POST['god'])){

$fdate= test_input($_POST['fdate']);
$tdate= test_input($_POST['tdate']);

$newF = date("Y-m-d", strtotime($fdate));
 $newT = date("Y-m-d", strtotime($tdate));
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title> <?php echo $shopname;?> || <?php echo $pageTitle1;?></title>

<link href="assets/css/bootstrap.min.css" rel="stylesheet" type="text/css" />
<link href="assets/css/icons.min.css" rel="stylesheet" type="text/css" />
<link href="assets/css/theme.min.css" rel="stylesheet" type="text/css" />

#loader {
display: block;
position: absolute;
top: 50%;
left: 50%;
border: 16px solid #f3f3f3;
border-top: 16px solid #3498db;
border-radius: 50%;
width: 70px;
height: 70px;
animation: spin 2s linear infinite;
}
 .table-hover tbody tr:hover td, .table-hover tbody tr:hover th {
  background-color:  #e6ecff;
}
</style>

.bg-c-green {
    background: linear-gradient(45deg,#2ed8b6,#59e0c5);
}

.bg-c-yellow {
    background: linear-gradient(45deg,#FFB64D,#ffcb80);
}

.bg-c-pink {
    background: linear-gradient(45deg,#FF5370,#ff869a);
}

.card {
    border-radius: 5px;
    -webkit-box-shadow: 0 1px 2.94px 0.06px rgba(4,26,55,0.16);
    box-shadow: 0 1px 2.94px 0.06px rgba(4,26,55,0.16);
    border: none;
    margin-bottom: 30px;
    -webkit-transition: all 0.3s ease-in-out;
    transition: all 0.3s ease-in-out;
}

.card .card-block {
    padding: 25px;
}

.order-card i {
    font-size: 26px;
}

.f-left {
    float: left;
}

.f-right {
    float: right;
}
</style>

</head>

<div id="layout-wrapper">
<div class="header-border"></div>

<?php include("includes/template/head.php");?>
<?php include("includes/template/side.php");?>

<div class="col-md-4 col-xl-4">
            <div class="card bg-c-blue order-card">
                <div class="card-block">
                    <h6 class="m-b-20" style="color:#fff">Today Expenses</h6>
                    <h2 class="text-right"><span style="color:#fff">
<?php 
$tdate = date('Y-m-d');
$stmtServices = $con->prepare("SELECT sum(item_amount) as price  from expenses WHERE date
= '$tdate' and business_name = ?");
$stmtServices->execute(array($shopname));
$rowsServices = $stmtServices->fetchAll();
foreach($rowsServices as $rowsService)
{
$todayexpe =$rowsService['price'];
}
echo $todayss = number_format($todayexpe,2).' '.$qurtyCurrency;

?>
                        
                    </span></h2>
                </div>
            </div>
        </div>

<div class="col-md-4 col-xl-4">
            <div class="card bg-c-green order-card">
                <div class="card-block">
                    <h6 class="m-b-20" style="color:#fff">A Week Expenses</h6>
                    <h2 class="text-right"><span style="color:#fff"> 
<?php

$pastdate=  date("Y-m-d", strtotime("-1 week")); 
$crrntdte=date("Y-m-d");

$stmtServices = $con->prepare("SELECT sum(item_amount) as price  from expenses WHERE date between '$pastdate' AND '$crrntdte' and business_name = ?");
$stmtServices->execute(array($shopname));
$rowsServices = $stmtServices->fetchAll();
foreach($rowsServices as $rowsService)
{
$weekexpe =$rowsService['price'];
}
echo $week = number_format($weekexpe,2).' '.$qurtyCurrency;

?>
                          
                      </span></h2>
                </div>
            </div>
        </div>

<div class="col-md-4 col-xl-4">
            <div class="card bg-c-yellow order-card">
                <div class="card-block">
                    <h6 class="m-b-20" style="color:#fff">A Month Expenses</h6>
                     <h2 class="text-right"><span style="color:#fff">
<?php

$monthdate=  date("Y-m-d", strtotime("-1 month")); 
$crrntdte=date("Y-m-d");

$stmtServices = $con->prepare("SELECT sum(item_amount) as price  from expenses WHERE date between '$monthdate' AND '$crrntdte' and business_name = ? ");
$stmtServices->execute(array($shopname));
$rowsServices = $stmtServices->fetchAll();
foreach($rowsServices as $rowsService)
{
$monthlyexpe =$rowsService['price'];
}

echo  $monthly = number_format($monthlyexpe,2).' '.$qurtyCurrency;
?>
                    
                </span></h2>
                </div>
            </div>
        </div>

</div>

<div class="col-md-4">
<label>Search from this Date</label>
<div class="form-group">
<input type="date" class="form-control date" name="fdate" style="width:100%">
</div>
</div>

<div class="col-md-2">
<div class="md-form">
<label>Click to search</label>
<button type="submit" name="god" class="btn btn-primary" style="width:100%"> Search</button>
</div>
</div>
    </form>
<div class="table-responsive">

<table class="table table-bordered">
        <br  />
  <center><h3>Expenses Report</h3></center>
<center> From  <?php echo $newF; ?>   to. <?php echo $newT ;?> </center>
<thead>
<tr>
<th>Vendor Name</th>
<th>Item name</th>
<th>Item Price</th>
<th>Expenses Date</th>
</tr>
</thead>
<tbody>
 <tr>
<?php

$stmt = $con->prepare("SELECT * FROM expenses,vendors  WHERE expenses.vendor_id = vendors.vendor_id AND  expenses.date between '$newF' and '$newT' and expenses.business_name = ? ");

$stmt->execute(array($shopname));
$rows = $stmt->fetchAll();
foreach($rows as $service){

$tt+= $service['item_amount'];
?>
    <td><?php echo $service['vendor_name'];?></td>
    <td><?php echo $service['item_name'];?></td>
    <td><?php echo $service['item_amount'];?></td>
    <td><?php echo $service['date'];?></td>
</tr>
<?php } ?>

<tr>

<th scope="row"></th>
<td colspan="1"></td>
<td>Total : </b><?php echo number_format($tt,2).' '.$qurtyCurrency;?></td>
<td></td>
</tr>
    </tbody>
</table>

</div>

</div>
</div>

</div> 
</div>

<?php include("includes/template/newfooter.php");?>
</div>

</div>

<div class="menu-overlay"></div>

<?php include("includes/modals/ServicesModal.php");?>

<script src="assets/pages/advanced-plugins-demo.js"></script>

</body>

</html>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: expenses_report.php

Server Info

System Features

User Info