File Manager

✏️ Edit File: /home/u818817280/public_html/QR_Software/admin/dashboard.php

⬅ Kembali

<?php include 'auth.php'; ?>

<?php

error_reporting(E_ALL);
ini_set('display_errors',1);

include '../config/db.php';

/* =========================
PRODUCTS
========================= */

$products = mysqli_query($conn,

"SELECT * FROM products
ORDER BY id DESC"

);

$totalProducts = mysqli_num_rows($products);

/* =========================
TOTAL SCANS
========================= */

$totalScansQuery = mysqli_query($conn,

"SELECT COUNT(*) as total
FROM analytics"

);

$totalScansData = mysqli_fetch_assoc($totalScansQuery);

/* =========================
TODAY SCANS
========================= */

$todayScansQuery = mysqli_query($conn,

"SELECT COUNT(*) as total
FROM analytics
WHERE DATE(scan_time)=CURDATE()"

);

$todayScansData = mysqli_fetch_assoc($todayScansQuery);

/*------------------------------------------------------------------------*/

/* =========================
MONTHLY SCANS
========================= */

$monthlyScansQuery = mysqli_query($conn,

"SELECT COUNT(*) as total
FROM analytics

WHERE MONTH(scan_time)=MONTH(CURDATE())

AND YEAR(scan_time)=YEAR(CURDATE())"

);

$monthlyScansData = mysqli_fetch_assoc($monthlyScansQuery);

/* =========================
WEEKLY SCANS
========================= */

$weeklyScansQuery = mysqli_query($conn,

"SELECT COUNT(*) as total
FROM analytics

WHERE scan_time >= DATE_SUB(NOW(), INTERVAL 7 DAY)"

);

$weeklyScansData = mysqli_fetch_assoc($weeklyScansQuery);

/*-----------------------------------------------------------------------------------------*/

/* =========================
TOTAL BATCHES
========================= */

$totalBatchQuery = mysqli_query($conn,

"SELECT COUNT(*) as total
FROM product_batches"

);

$totalBatchData = mysqli_fetch_assoc($totalBatchQuery);

/* =========================
EXPIRY ALERTS
========================= */

$expiryQuery = mysqli_query($conn,

"SELECT COUNT(*) as total

FROM product_batches

WHERE exp_date <= DATE_ADD(CURDATE(), INTERVAL 30 DAY)

AND exp_date >= CURDATE()"

);

$expiryData = mysqli_fetch_assoc($expiryQuery);

/* =========================
TOTAL REVIEWS
========================= */

$totalReviewsQuery = mysqli_query($conn,

"SELECT COUNT(*) as total
FROM feedback"

);

$totalReviewsData = mysqli_fetch_assoc($totalReviewsQuery);

/* =========================
AVERAGE RATING
========================= */

$ratingQuery = mysqli_query($conn,

"SELECT AVG(rating) as avg_rating
FROM feedback"

);

$ratingData = mysqli_fetch_assoc($ratingQuery);

/* =========================
UNIQUE CITIES
========================= */

$cityQuery = mysqli_query($conn,

"SELECT COUNT(DISTINCT city) as total
FROM analytics"

);

$cityData = mysqli_fetch_assoc($cityQuery);

/* =========================
UNIQUE STATES
========================= */

$stateQuery = mysqli_query($conn,

"SELECT COUNT(DISTINCT state) as total
FROM analytics"

);

$stateData = mysqli_fetch_assoc($stateQuery);

/* =========================
UNIQUE DEVICES
========================= */

$deviceQuery = mysqli_query($conn,

"SELECT COUNT(DISTINCT device) as total
FROM analytics"

);

$deviceData = mysqli_fetch_assoc($deviceQuery);

/* =========================
UNIQUE SCANS
========================= */

$uniqueScanQuery = mysqli_query($conn,

"SELECT COUNT(*) as total
FROM analytics
WHERE unique_scan=1"

);

$uniqueScanData = mysqli_fetch_assoc($uniqueScanQuery);

/* =========================
TOP PRODUCT
========================= */

$topProductQuery = mysqli_query($conn,

"SELECT p.product_name,
COUNT(a.id) as total_scans

FROM analytics a

LEFT JOIN products p
ON p.id=a.product_id

GROUP BY a.product_id

ORDER BY total_scans DESC

LIMIT 1"

);

$topProductData = mysqli_fetch_assoc($topProductQuery);

/*--------------------------------------------------------------------------*/

/* =========================
TOP 10 PRODUCTS
========================= */

$topProductsQuery = mysqli_query($conn,

"SELECT
p.product_name,
COUNT(a.id) as total_scans

FROM analytics a

LEFT JOIN products p
ON p.id = a.product_id

GROUP BY a.product_id

ORDER BY total_scans DESC

LIMIT 10"

);

/* =========================
LAST SCAN
========================= */

$lastScanQuery = mysqli_query($conn,

"SELECT * FROM analytics
ORDER BY id DESC
LIMIT 1"

);

$lastScanData = mysqli_fetch_assoc($lastScanQuery);

if(!$lastScanData){
    $lastScanData = [
        'city' => 'No City',
        'state' => 'No State',
        'device' => 'Unknown Device',
        'scan_time' => 'No Scan Yet'
    ];
}

/* =========================
GRAPH DATA
========================= */

$weekly = mysqli_query($conn,

"SELECT
DATE(scan_time) as scan_day,
COUNT(*) as total

FROM analytics

GROUP BY DATE(scan_time)

ORDER BY scan_day ASC
LIMIT 7"

);

$chartLabels = [];
$chartData = [];

while($week = mysqli_fetch_assoc($weekly))
{

$chartLabels[] = date('D', strtotime($week['scan_day']));
$chartData[] = $week['total'];

}

if(empty($chartLabels)){

$chartLabels = ['Mon','Tue','Wed','Thu','Fri','Sat','Sun'];

$chartData = [0,0,0,0,0,0,0];

}

<!DOCTYPE html>
<html>

<head>

<title>

3Biz Qr Verification Software

</title>

<style>

*{
margin:0;
padding:0;
box-sizing:border-box;
}

body{

font-family:Arial,sans-serif;

background:
linear-gradient(135deg,#eef2ff,#f8fafc);

overflow-x:hidden;

color:#111827;

}

/* =========================
MAIN CONTENT
========================= */

.main-content{

margin-left:300px;
padding:35px;
min-height:100vh;

}

/* =========================
HERO
========================= */

.hero-section{

background:
linear-gradient(135deg,#0f172a,#1e3a8a);

padding:45px;

border-radius:35px;

position:relative;
overflow:hidden;

margin-bottom:35px;

box-shadow:
0 20px 50px rgba(0,0,0,0.15);

}

.hero-section::before{

content:'';

position:absolute;

width:300px;
height:300px;

background:
rgba(255,255,255,0.08);

border-radius:50%;

top:-80px;
right:-80px;

}

.hero-title{

font-size:58px;
font-weight:900;
color:white;

position:relative;
z-index:2;

}

.hero-subtitle{

font-size:18px;
color:#cbd5e1;

margin-top:14px;

position:relative;
z-index:2;

}

.live-status{

margin-top:20px;

display:inline-flex;
align-items:center;
gap:12px;

background:
rgba(34,197,94,0.15);

padding:12px 22px;

border-radius:40px;

font-size:13px;
font-weight:800;
color:#4ade80;

border:
1px solid rgba(34,197,94,0.25);

position:relative;
z-index:2;

}

.live-dot{

width:10px;
height:10px;
border-radius:50%;
background:#4ade80;

animation:pulse 1.5s infinite;

}

@keyframes pulse{

0%{
transform:scale(1);
opacity:1;
}

50%{
transform:scale(1.4);
opacity:0.5;
}

100%{
transform:scale(1);
opacity:1;
}

}

/* =========================
SEARCH
========================= */

.search-box{

margin-top:28px;
position:relative;
z-index:2;

}

.search-input{

width:100%;
max-width:420px;

height:60px;

border:none;

padding:0 22px;

border-radius:22px;

background:white;

font-size:15px;

box-shadow:
0 12px 30px rgba(0,0,0,0.15);

}

.search-input:focus{
outline:none;
}

/* =========================
ACTION BUTTONS
========================= */

.quick-actions{

display:flex;
gap:16px;
flex-wrap:wrap;

margin-bottom:35px;

}

.action-btn{

padding:16px 24px;

border-radius:20px;

text-decoration:none;

font-size:15px;
font-weight:800;

display:flex;
align-items:center;
gap:12px;

transition:0.35s;

box-shadow:
0 12px 30px rgba(0,0,0,0.08);

}

.action-btn:hover{

transform:translateY(-5px);

}

.btn-primaryx{

background:
linear-gradient(135deg,#ff6b00,#ff9248);

color:white;

}

.btn-darkx{

background:
linear-gradient(135deg,#111827,#1e293b);

color:white;

}

.btn-green{

background:
linear-gradient(135deg,#16a34a,#22c55e);

color:white;

}

.btn-blue{

background:
linear-gradient(135deg,#2563eb,#3b82f6);

color:white;

}

/* =========================
CARDS
========================= */

.stats-grid{

display:grid;

grid-template-columns:
repeat(auto-fit,minmax(240px,1fr));

gap:25px;

margin-bottom:35px;

}

.stats-card{

background:white;

padding:30px;

border-radius:32px;

position:relative;
overflow:hidden;

box-shadow:
0 15px 40px rgba(0,0,0,0.05);

transition:0.35s;

border:
1px solid #e2e8f0;

}

.stats-card:hover{

transform:translateY(-8px);

box-shadow:
0 20px 45px rgba(255,107,0,0.15);

}

.stats-card::before{

content:'';

position:absolute;

top:0;
left:0;

width:100%;
height:6px;

background:
linear-gradient(135deg,#ff6b00,#ff9248);

}

.stats-title{

font-size:16px;
font-weight:700;
color:#64748b;

margin-bottom:16px;

}

.stats-number{

font-size:52px;
font-weight:900;
color:#111827;

}

.stats-icon{

position:absolute;

right:25px;
top:25px;

width:68px;
height:68px;

border-radius:22px;

display:flex;
justify-content:center;
align-items:center;

background:#fff7ed;

font-size:28px;
color:#ff6b00;

}

/* =========================
SECTIONS
========================= */

.section-box{

background:white;

padding:35px;

border-radius:32px;

box-shadow:
0 15px 40px rgba(0,0,0,0.05);

border:
1px solid #e2e8f0;

margin-bottom:35px;

}

.section-title{

font-size:38px;
font-weight:900;

margin-bottom:28px;

}

/* =========================
TABLE
========================= */

.table thead{

background:#111827;
color:white;

}

.table th{

padding:18px;
font-size:15px;
font-weight:800;
border:none;

}

.table td{

padding:18px;
vertical-align:middle;
border-bottom:
1px solid #e2e8f0;

font-size:14px;
font-weight:700;

}

.table tbody tr{
transition:0.3s;
}

.table tbody tr:hover{

background:#fff7ed;

}

.badge-status{

display:inline-block;

padding:9px 15px;

border-radius:30px;

font-size:13px;
font-weight:800;

background:#dcfce7;
color:#166534;

}

/* =========================
LIVE ACTIVITY
========================= */

.live-activity{

display:flex;
flex-direction:column;
gap:18px;

}

.activity-item{

display:flex;
justify-content:space-between;
align-items:center;

padding:22px;

background:#f8fafc;

border-radius:24px;

border:
1px solid #e2e8f0;

flex-wrap:wrap;
gap:15px;

}

.activity-left{

display:flex;
align-items:center;
gap:18px;

}

.activity-icon{

width:58px;
height:58px;

border-radius:18px;

display:flex;
justify-content:center;
align-items:center;

background:#fff7ed;

font-size:24px;
color:#ff6b00;

}

.activity-title{

font-size:17px;
font-weight:800;

}

.activity-sub{

font-size:13px;
color:#64748b;

margin-top:5px;

}

.activity-time{

font-size:13px;
font-weight:800;
color:#2563eb;

}

/* =========================
RESPONSIVE
========================= */

@media(max-width:991px){

.main-content{

margin-left:0;
padding:18px;

}

.hero-title{

font-size:40px;

}

.section-title{

font-size:28px;

}

.stats-number{

font-size:38px;

}

.section-box{

padding:24px;

}

.hero-section{

padding:28px;

}

</style>

</head>

<body>

<?php include 'sidebar.php'; ?>

Smart QR ERP Verification Software

</h1>

Monitor live product verification analytics,
QR scans and enterprise pharma reports.

</p>

SYSTEM ACTIVE

</div>

</div>

Add Product

</a>

Manage Batches

</a>

Analytics Reports

</a>

Generate QR

</a>

</div>

</div>

Total QR Scans

</div>

<?php echo $totalScansData['total']; ?>

</div>

</div>

Today Scans

</div>

<?php echo $todayScansData['total']; ?>

</div>

</div>

Monthly Scans

</div>

<?php echo $monthlyScansData['total']; ?>

</div>

</div>

Weekly Scans

</div>

<?php echo $weeklyScansData['total']; ?>

</div>

</div>

Total Products

</div>

<?php echo $totalProducts; ?>

</div>

</div>

Total Batches

</div>

<?php echo $totalBatchData['total']; ?>

</div>

</div>

Expiry Alerts

</div>

<?php echo $expiryData['total']; ?>

</div>

</div>

Customer Reviews

</div>

<?php echo $totalReviewsData['total']; ?>

</div>

</div>

Average Rating

</div>

<?php echo number_format($ratingData['avg_rating'] ?? 0,1); ?>

</div>

</div>

Unique Cities

</div>

<?php echo $cityData['total']; ?>

</div>

</div>

Unique States

</div>

<?php echo $stateData['total']; ?>

</div>

</div>

Unique Devices

</div>

<?php echo $deviceData['total']; ?>

</div>

</div>

Unique Scans

</div>

<?php echo $uniqueScanData['total']; ?>

</div>

</div>

Nama	Tipe	Ukuran	Diubah	Aksi
🐘activity-log.php	php	3.2 KB	2026-06-25 09:19	✏️ Edit 👁️ View
🐘add-product.php	php	11.5 KB	2026-06-26 08:28	✏️ Edit 👁️ View
🐘advanced-search.php	php	7.8 KB	2026-06-25 09:19	✏️ Edit 👁️ View
🐘all-products.php	php	6.6 KB	2026-06-25 09:19	✏️ Edit 👁️ View
🐘analytics.php	php	8.3 KB	2026-06-25 09:19	✏️ Edit 👁️ View
🐘auth.php	php	272 B	2026-06-25 09:19	✏️ Edit 👁️ View
🐘batch-management.php	php	4.7 KB	2026-06-25 09:19	✏️ Edit 👁️ View
🐘dashboard.php	php	18.9 KB	2026-06-25 09:19	✏️ Edit 👁️ View
🐘delete-feedback.php	php	627 B	2026-06-26 09:18	✏️ Edit 👁️ View
🐘delete-product.php	php	1.1 KB	2026-06-25 09:19	✏️ Edit 👁️ View
🐘edit-product.php	php	15.6 KB	2026-06-25 09:19	✏️ Edit 👁️ View
🐘feedback-management.php	php	8.5 KB	2026-06-26 09:15	✏️ Edit 👁️ View
🐘gallery-management.php	php	8.6 KB	2026-06-25 09:19	✏️ Edit 👁️ View
🐘live-stats.php	php	3.5 KB	2026-06-25 09:19	✏️ Edit 👁️ View
🐘login.php	php	3.6 KB	2026-06-25 09:19	✏️ Edit 👁️ View
🐘logout.php	php	84 B	2026-06-25 09:19	✏️ Edit 👁️ View
🐘product-report.php	php	5.6 KB	2026-06-25 09:19	✏️ Edit 👁️ View
🐘qr-success.php	php	1.4 KB	2026-06-25 09:19	✏️ Edit 👁️ View
🐘report.php	php	13.1 KB	2026-06-25 09:19	✏️ Edit 👁️ View
🐘scan-history.php	php	5.8 KB	2026-06-25 09:19	✏️ Edit 👁️ View
🐘settings.php	php	5.5 KB	2026-06-25 09:19	✏️ Edit 👁️ View
🐘sidebar.php	php	11 KB	2026-06-25 10:32	✏️ Edit 👁️ View
📄sidebar.php_old	php_old	9.6 KB	2026-06-25 09:19	✏️ Edit 👁️ View
🐘verified-products.php	php	5.3 KB	2026-06-26 09:36	✏️ Edit 👁️ View