-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathhome.php
40 lines (30 loc) · 836 Bytes
/
home.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
<style>
</style>
<div class="containe-fluid">
<div class="row">
<div class="col-lg-12">
</div>
</div>
<div class="row mt-3 ml-3 mr-3">
<div class="col-lg-12">
<div class="card">
<div class="card-body">
<?php echo "Welcome back ".$_SESSION['login_name']."!" ?>
</div>
<hr>
<div class="alert alert-success col-md-4 ml-4">
<p><b><large>Total Sales Today</large></b></p>
<hr>
<p class="text-right"><b><large><?php
include 'db_connect.php';
$sales = $conn->query("SELECT SUM(total_amount) as amount FROM sales_list where date(date_updated)= '".date('Y-m-d')."'");
echo $sales->num_rows > 0 ? number_format($sales->fetch_array()['amount'],2) : "0.00";
?></large></b></p>
</div>
</div>
</div>
</div>
</div>
</div>
<script>
</script>