Server : Apache
System : Linux server1.cgrithy.com 3.10.0-1160.95.1.el7.x86_64 #1 SMP Mon Jul 24 13:59:37 UTC 2023 x86_64
User : nobody ( 99)
PHP Version : 8.1.23
Disable Function : NONE
Directory : /home/dnlcambodia/www/dnl_dashboard/
|
Server : Apache System : Linux server1.cgrithy.com 3.10.0-1160.95.1.el7.x86_64 #1 SMP Mon Jul 24 13:59:37 UTC 2023 x86_64 User : nobody ( 99) PHP Version : 8.1.23 Disable Function : NONE Directory : /home/dnlcambodia/www/dnl_dashboard/ |
<!DOCTYPE html>
<html lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=us-ascii">
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<link rel="apple-touch-icon" sizes="76x76" href="./assets/img/apple-icon.png">
<link rel="icon" type="image/png" href="./assets/img/favicon.png">
<title>DNL-Admin</title>
<link rel="canonical" href="https://www.creative-tim.com/product/material-dashboard">
<meta name="keywords" content="creative tim, html dashboard, html css dashboard, web dashboard, bootstrap 5 dashboard, bootstrap 5, css3 dashboard, bootstrap 5 admin, Material Dashboard bootstrap 5 dashboard, frontend, responsive bootstrap 5 dashboard, free dashboard, free admin dashboard, free bootstrap 5 admin dashboard">
<meta name="description" content="Material Dashboard 2 is a beautiful Bootstrap 5 admin dashboard with a large number of components, designed to look beautiful and organized. If you are looking for a tool to manage and visualize data about your business, this dashboard is the thing for you.">
<meta name="twitter:card" content="product">
<meta name="twitter:site" content="@creativetim">
<meta name="twitter:title" content="DNL-Admin">
<meta name="twitter:description" content="Material Dashboard 2 is a beautiful Bootstrap 5 admin dashboard with a large number of components, designed to look beautiful and organized. If you are looking for a tool to manage and visualize data about your business, this dashboard is the thing for you.">
<meta name="twitter:creator" content="@creativetim">
<meta name="twitter:image" content="./../../s3.amazonaws.com/creativetim_bucket/products/450/original/material-dashboard.jpg">
<meta property="fb:app_id" content="655968634437471">
<meta property="og:title" content="DNL-Admin">
<meta property="og:type" content="article">
<meta property="og:url" content="index.html">
<meta property="og:image" content="./../../s3.amazonaws.com/creativetim_bucket/products/450/original/material-dashboard.jpg">
<meta property="og:description" content="Material Dashboard 2 is a beautiful Bootstrap 5 admin dashboard with a large number of components, designed to look beautiful and organized. If you are looking for a tool to manage and visualize data about your business, this dashboard is the thing for you.">
<meta property="og:site_name" content="Creative Tim">
<link rel="stylesheet" type="text/css" href="https://fonts.googleapis.com/css?family=Roboto:300,400,500,700,900|Roboto+Slab:400,700">
<link href="./assets/css/nucleo-icons.css" rel="stylesheet">
<link href="./assets/css/nucleo-svg.css" rel="stylesheet">
<script src="./../../kit.fontawesome.com/42d5adcbca.js" crossorigin="anonymous"></script>
<link href="https://fonts.googleapis.com/icon?family=Material+Icons+Round" rel="stylesheet">
<link id="pagestyle" href="./assets/css/material-dashboard.mine63c.css?v=3.1.0" rel="stylesheet">
<script src="https://cdn.jsdelivr.net/npm/chart.js"></script>
<script>
// Get the canvas element
var ctx = document.getElementById('projectsDoughnutChart').getContext('2d');
// Define data for the Doughnut chart
var data = {
labels: ['Completed', 'Remaining'],
datasets: [{
data: [30, 70], // Adjust these values according to your data
backgroundColor: ['#36a2eb', '#d3d3d3'], // You can customize the colors
}]
};
// Configure options for the Doughnut chart
var options = {
cutoutPercentage: 80, // Adjust the cutout percentage as needed
responsive: true,
maintainAspectRatio: false,
};
// Create the Doughnut chart
var myDoughnutChart = new Chart(ctx, {
type: 'doughnut',
data: data,
options: options
});
</script>
<style>
.async-hide {
opacity: 0 !important
}
</style>
<script>
(function(i, s, o, g, r, a, m) {
i['GoogleAnalyticsObject'] = r;
i[r] = i[r] || function() {
(i[r].q = i[r].q || []).push(arguments)
}, i[r].l = 1 * new Date();
a = s.createElement(o),
m = s.getElementsByTagName(o)[0];
a.async = 1;
a.src = g;
m.parentNode.insertBefore(a, m)
})(window, document, 'script', './../../www.google-analytics.com/analytics.js', 'ga');
ga('create', 'UA-46172202-22', 'auto', {
allowLinker: true
});
ga('set', 'anonymizeIp', true);
ga('require', 'GTM-K9BGS8K');
ga('require', 'displayfeatures');
ga('require', 'linker');
ga('linker:autoLink', ["2checkout.com", "avangate.com"]);
</script>
<script defer data-site="demos.creative-tim.com" src="./../../api.nepcha.com/js/nepcha-analytics.js"></script>
</head>
<body class="g-sidenav-show bg-gray-200">
<!-- <noscript><iframe src="https://www.googletagmanager.com/ns.html?id=GTM-NKDMSK6" height="0" width="0" style="display:none;visibility:hidden"></iframe></noscript> -->
<aside class="sidenav navbar navbar-vertical navbar-expand-xs border-0 border-radius-xl my-3 fixed-start ms-3 bg-gradient-dark" id="sidenav-main">
<div class="sidenav-header" style="margin-left:40px;">
<i class="fas fa-times p-3 cursor-pointer text-white opacity-5 position-absolute end-0 top-0 d-none d-xl-none" aria-hidden="true" id="iconSidenav"></i><a class="navbar-brand m-0" href="home.php" target="_blank"><img src="./assets/DNL-01.png" alt="main_logo"></a>
</div>
<hr class="horizontal light mt-0 mb-2">
<div class="collapse navbar-collapse w-auto" id="sidenav-collapse-main">
<ul class="navbar-nav">
<li class="nav-item">
<a class="nav-link text-white active bg-gradient-primary" href="index.html">
<div class="text-white text-center me-2 d-flex align-items-center justify-content-center">
<i class="material-icons opacity-10">dashboard</i>
</div><span class="nav-link-text ms-1">Dashboard</span>
</a>
</li>
<li class="nav-item">
<a class="nav-link text-white" href="./Service/upload_service.php">
<div class="text-white text-center me-2 d-flex align-items-center justify-content-center">
<i class="material-icons opacity-10">table_view</i>
</div><span class="nav-link-text ms-1">Service</span>
</a>
</li>
<li class="nav-item">
<a class="nav-link text-white" href="./PHP/createPost.php">
<div class="text-white text-center me-2 d-flex align-items-center justify-content-center">
<i class="material-icons opacity-10">receipt_long</i>
</div><span class="nav-link-text ms-1">Blog Post</span>
</a>
</li>
<li class="nav-item">
<a class="nav-link text-white" href="table.php">
<div class="text-white text-center me-2 d-flex align-items-center justify-content-center">
<i class="material-icons opacity-10">view_in_ar</i>
</div><span class="nav-link-text ms-1">Quotations</span>
</a>
</li>
<!-- <li class="nav-item">
<a class="nav-link text-white" href="virtual-reality.html">
<div class="text-white text-center me-2 d-flex align-items-center justify-content-center">
<i class="material-icons opacity-10">view_in_ar</i>
</div></a>
</li> -->
<li class="nav-item">
<a class="nav-link text-white" href="./Project/upload_project.php">
<div class="text-white text-center me-2 d-flex align-items-center justify-content-center">
<i class="material-icons opacity-10">format_textdirection_r_to_l</i>
</div><span class="nav-link-text ms-1">Project</span>
</a>
</li>
<li class="nav-item">
<a class="nav-link text-white" href="./Feature/function.php">
<div class="text-white text-center me-2 d-flex align-items-center justify-content-center">
<i class="material-icons opacity-10">notifications</i>
</div><span class="nav-link-text ms-1">Feature</span>
</a>
</li>
<li class="nav-item mt-3">
<h6 class="ps-4 ms-2 text-uppercase text-xs text-white font-weight-bolder opacity-8">Account pages</h6>
</li>
<li class="nav-item">
<a class="nav-link text-white" href="profile.html">
<div class="text-white text-center me-2 d-flex align-items-center justify-content-center">
<i class="material-icons opacity-10">person</i>
</div><span class="nav-link-text ms-1">Profile</span>
</a>
</li>
<li class="nav-item">
<a class="nav-link text-white" href="index.php">
<div class="text-white text-center me-2 d-flex align-items-center justify-content-center">
<i class="material-icons opacity-10">login</i>
</div><span class="nav-link-text ms-1">Sign In</span>
</a>
</li>
<li class="nav-item">
<a class="nav-link text-white" href="sign-up.html">
<div class="text-white text-center me-2 d-flex align-items-center justify-content-center">
<i class="material-icons opacity-10">assignment</i>
</div><span class="nav-link-text ms-1">Sign Up</span>
</a>
</li>
</ul>
</div>
</aside>
<main class="main-content position-relative max-height-vh-100 h-100 border-radius-lg">
<nav class="navbar navbar-main navbar-expand-lg px-0 mx-4 shadow-none border-radius-xl" id="navbarBlur" data-scroll="true">
<div class="container-fluid py-1 px-3">
<nav aria-label="breadcrumb">
<h6 class="font-weight-bolder mb-0">Dashboard</h6>
</nav>
<div class="collapse navbar-collapse mt-sm-0 mt-2 me-md-0 me-sm-4" id="navbar">
<li class="nav-item d-xl-none ps-3 d-flex align-items-center">
<a href="javascript:;" class="nav-link text-body p-0" id="iconNavbarSidenav">
<div class="sidenav-toggler-inner"></div>
</a>
</li>
<li class="nav-item px-3 d-flex align-items-center">
<a href="javascript:;" class="nav-link text-body p-0"></a>
</li>
<li class="nav-item dropdown pe-2 d-flex align-items-center">
<a href="javascript:;" class="nav-link text-body p-0" id="dropdownMenuButton" data-bs-toggle="dropdown" aria-expanded="false"></a>
<ul class="dropdown-menu dropdown-menu-end px-2 py-3 me-sm-n4" aria-labelledby="dropdownMenuButton">
<li class="mb-2">
<a class="dropdown-item border-radius-md" href="javascript:;">
<div class="d-flex py-1">
<div class="my-auto"><img src="./assets/img/team-2.jpg" class="avatar avatar-sm me-3" alt="team-2"></div>
<div class="d-flex flex-column justify-content-center">
<h6 class="text-sm font-weight-normal mb-1"><span class="font-weight-bold">New message</span> from Laur</h6>
<p class="text-xs text-secondary mb-0">13 minutes ago</p>
</div>
</div>
</a>
</li>
<li class="mb-2">
<a class="dropdown-item border-radius-md" href="javascript:;">
<div class="d-flex py-1">
<div class="my-auto"><img src="https://demos.creative-tim.com/material-dashboard/assets/img/small-logos/logo-spotify.svg" class="avatar avatar-sm bg-gradient-dark me-3" alt="logo-spotify"></div>
<div class="d-flex flex-column justify-content-center">
<h6 class="text-sm font-weight-normal mb-1"><span class="font-weight-bold">New album</span> by Travis Scott</h6>
<p class="text-xs text-secondary mb-0">1 day</p>
</div>
</div>
</a>
</li>
<li>
<a class="dropdown-item border-radius-md" href="javascript:;">
<div class="d-flex py-1">
<div class="avatar avatar-sm bg-gradient-secondary me-3 my-auto">
<svg width="12px" height="12px" viewbox="0 0 43 36" version="1.1" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink">
<title>credit-card</title>
<g stroke="none" stroke-width="1" fill="none" fill-rule="evenodd">
<g transform="translate(-2169.000000, -745.000000)" fill="#FFFFFF" fill-rule="nonzero">
<g transform="translate(1716.000000, 291.000000)">
<g transform="translate(453.000000, 454.000000)">
<path class="color-background" d="M43,10.7482083 L43,3.58333333 C43,1.60354167 41.3964583,0 39.4166667,0 L3.58333333,0 C1.60354167,0 0,1.60354167 0,3.58333333 L0,10.7482083 L43,10.7482083 Z" opacity="0.593633743"></path>
<path class="color-background" d="M0,16.125 L0,32.25 C0,34.2297917 1.60354167,35.8333333 3.58333333,35.8333333 L39.4166667,35.8333333 C41.3964583,35.8333333 43,34.2297917 43,32.25 L43,16.125 L0,16.125 Z M19.7083333,26.875 L7.16666667,26.875 L7.16666667,23.2916667 L19.7083333,23.2916667 L19.7083333,26.875 Z M35.8333333,26.875 L28.6666667,26.875 L28.6666667,23.2916667 L35.8333333,23.2916667 L35.8333333,26.875 Z"></path>
</g>
</g>
</g>
</g>
</svg>
</div>
<div class="d-flex flex-column justify-content-center">
<h6 class="text-sm font-weight-normal mb-1">Payment successfully completed</h6>
<p class="text-xs text-secondary mb-0">2 days</p>
</div>
</div>
</a>
</li>
</ul>
</li>
</ul>
</div>
</div>
</nav>
<div class="container-fluid py-4" style="max-width: 1650px; margin-left:250px;">
<div class="row">
<?php
// Assuming you have a function to connect to your database
include './PHP/config/db_conn.php';
// Query to get the total number of clients who have requested a quote
$sql = "SELECT COUNT(DISTINCT id) AS total_clients FROM quotation";
$result = mysqli_query($conn, $sql);
$row = mysqli_fetch_assoc($result);
$totalClients = $row['total_clients'];
?>
<div class="col-xl-3 col-sm-6 mb-xl-0 mb-4">
<div class="card">
<div class="card-header p-3 pt-2">
<div class="icon icon-lg icon-shape bg-gradient-dark shadow-dark text-center border-radius-xl mt-n4 position-absolute">
<i class="material-icons opacity-10">weekend</i>
</div>
<div class="text-end pt-1">
<p class="text-sm mb-0 text-capitalize">Clients</p>
<h4 class="mb-0"><?php echo $totalClients; ?></h4>
</div>
</div>
<hr class="dark horizontal my-0">
<div class="card-footer p-3">
<p class="mb-0"><span class="text-success text-sm font-weight-bolder">+55%</span> than last week</p>
</div>
</div>
</div>
<?php
// Assuming you have a function to connect to your database
include './PHP/config/db_conn.php';
// Query to get the total quotation
$sql = "SELECT COUNT(*) AS total_quotation FROM quotation";
$result = mysqli_query($conn, $sql);
$row = mysqli_fetch_assoc($result);
$totalQuotation = $row['total_quotation'];
?>
<div class="col-xl-3 col-sm-6 mb-xl-0 mb-4">
<div class="card">
<div class="card-header p-3 pt-2">
<div class="icon icon-lg icon-shape bg-gradient-primary shadow-primary text-center border-radius-xl mt-n4 position-absolute">
<i class="material-icons opacity-10">person</i>
</div>
<div class="text-end pt-1">
<p class="text-sm mb-0 text-capitalize">Request Quote</p>
<h4 class="mb-0"><?php echo $totalQuotation; ?></h4>
</div>
</div>
<hr class="dark horizontal my-0">
<div class="card-footer p-3">
<p class="mb-0"><span class="text-success text-sm font-weight-bolder">+3%</span> than last month</p>
</div>
</div>
</div>
<?php
include './PHP/config/db_conn.php';
$sql_import = "SELECT COUNT(*) AS total_import FROM project WHERE category = 'import'";
$result_import = $conn->query($sql_import);
if ($result_import->num_rows > 0) {
$row_import = $result_import->fetch_assoc();
$total_import = $row_import["total_import"];
echo '<div class="col-xl-3 col-sm-6 mb-xl-0 mb-4">
<div class="card">
<div class="card-header p-3 pt-2">
<div class="icon icon-lg icon-shape bg-gradient-success shadow-success text-center border-radius-xl mt-n4 position-absolute">
<i class="material-icons opacity-10">person</i>
</div>
<div class="text-end pt-1">
<p class="text-sm mb-0 text-capitalize">Total Import Product</p>
<h4 class="mb-0">' . $total_import . '</h4>
</div>
</div>
<hr class="dark horizontal my-0">
<div class="card-footer p-3">
<p class="mb-0"><span class="text-danger text-sm font-weight-bolder">-2%</span> than yesterday</p>
</div>
</div>
</div>';
} else {
echo '<div class="col-xl-3 col-sm-6 mb-xl-0 mb-4">
<div class="card">
<div class="card-header p-3 pt-2">
<div class="icon icon-lg icon-shape bg-gradient-success shadow-success text-center border-radius-xl mt-n4 position-absolute">
<i class="material-icons opacity-10">person</i>
</div>
<div class="text-end pt-1">
<p class="text-sm mb-0 text-capitalize">Total Import Product</p>
<h4 class="mb-0">0</h4>
</div>
</div>
<hr class="dark horizontal my-0">
<div class="card-footer p-3">
<p class="mb-0"><span class="text-danger text-sm font-weight-bolder">-2%</span> than yesterday</p>
</div>
</div>
</div>';
}
?>
<?php
// Get total number of projects with category "export"
$sql_export = "SELECT COUNT(*) AS total_export FROM project WHERE category = 'export'";
$result_export = $conn->query($sql_export);
if ($result_export->num_rows > 0) {
$row_export = $result_export->fetch_assoc();
$total_export = $row_export["total_export"];
echo '<div class="col-xl-3 col-sm-6">
<div class="card">
<div class="card-header p-3 pt-2">
<div class="icon icon-lg icon-shape bg-gradient-info shadow-info text-center border-radius-xl mt-n4 position-absolute">
<i class="material-icons opacity-10">weekend</i>
</div>
<div class="text-end pt-1">
<p class="text-sm mb-0 text-capitalize">Total Export Product</p>
<h4 class="mb-0">' . $total_export . '</h4>
</div>
</div>
<hr class="dark horizontal my-0">
<div class="card-footer p-3">
<p class="mb-0"><span class="text-success text-sm font-weight-bolder">+5%</span> than yesterday</p>
</div>
</div>
</div>';
} else {
echo '<div class="col-xl-3 col-sm-6">
<div class="card">
<div class="card-header p-3 pt-2">
<div class="icon icon-lg icon-shape bg-gradient-info shadow-info text-center border-radius-xl mt-n4 position-absolute">
<i class="material-icons opacity-10">weekend</i>
</div>
<div class="text-end pt-1">
<p class="text-sm mb-0 text-capitalize">Total Export Product</p>
<h4 class="mb-0">0</h4>
</div>
</div>
<hr class="dark horizontal my-0">
<div class="card-footer p-3">
<p class="mb-0"><span class="text-success text-sm font-weight-bolder">+5%</span> than yesterday</p>
</div>
</div>
</div>';
}
?>
</div>
<div class="row mt-4">
<div class="col-lg-4 col-md-6 mt-4 mb-4">
<div class="card z-index-2">
<div class="card-header p-0 position-relative mt-n4 mx-3 z-index-2 bg-transparent">
<div class="bg-gradient-primary shadow-primary border-radius-lg py-3 pe-1">
<div class="chart">
<canvas id="postsChart" width="800" height="400"></canvas>
</div>
</div>
</div>
<div class="card-body">
<h6 class="mb-0">Posts on Blog Page</h6>
<p class="text-sm">Last Performance</p>
<hr class="dark horizontal">
<div class="d-flex">
<i class="material-icons text-sm my-auto me-1">schedule</i>
<p class="mb-0 text-sm">All Posts</p>
</div>
</div>
</div>
</div>
<script src="https://cdn.jsdelivr.net/npm/chart.js"></script>
<?php
include './PHP/config/db_conn.php';
// Query to get total posts for each month
$sql = "SELECT YEAR(date) AS year, MONTH(date) AS month, COUNT(*) AS total_posts FROM posts GROUP BY YEAR(date), MONTH(date)";
$result = $conn->query($sql);
// Format data into an array
$data = array();
while ($row = $result->fetch_assoc()) {
$data[] = array(
'label' => date('M Y', mktime(0, 0, 0, $row['month'], 1, $row['year'])),
'value' => $row['total_posts']
);
}
// Close the database connection
?>
<script>
var ctx = document.getElementById('postsChart').getContext('2d');
var chart = new Chart(ctx, {
type: 'bar',
data: {
labels: <?php echo json_encode(array_column($data, 'label')); ?>,
datasets: [{
label: 'Total Posts',
data: <?php echo json_encode(array_column($data, 'value')); ?>,
backgroundColor: 'rgba(255, 255, 255, 0.2)',
borderColor: 'rgba(255, 255, 255, 1)',
borderWidth: 1
}]
},
options: {
scales: {
y: {
beginAtZero: true,
ticks: {
color: 'white'
}
},
x: {
ticks: {
color: 'white'
}
}
},
plugins: {
legend: {
labels: {
color: 'white'
}
}
}
}
});
</script>
<div class="col-lg-4 col-md-6 mt-4 mb-4">
<div class="card z-index-2">
<div class="card-header p-0 position-relative mt-n4 mx-3 z-index-2 bg-transparent">
<div class="bg-gradient-success shadow-success border-radius-lg py-3 pe-1">
<div class="chart">
<canvas id="postslinechart" width="800" height="400"></canvas>
</div>
</div>
</div>
<div class="card-body">
<h6 class="mb-0">Total Posts for each year</h6>
<p class="text-sm">increase in today sales.</p>
<hr class="dark horizontal">
<div class="d-flex">
<i class="material-icons text-sm my-auto me-1">schedule</i>
<p class="mb-0 text-sm">All Year</p>
</div>
</div>
</div>
</div>
<?php
include './PHP/config/db_conn.php';
// Query to get total posts for each year
$sql = "SELECT YEAR(date) AS year, COUNT(*) AS total_posts FROM posts GROUP BY YEAR(date)";
$result = $conn->query($sql);
// Format data into an array
$data = array();
while ($row = $result->fetch_assoc()) {
$data[] = array(
'label' => $row['year'],
'value' => $row['total_posts']
);
}
// Close the database connection
?>
<script>
var ctx = document.getElementById('postslinechart').getContext('2d');
var chart = new Chart(ctx, {
type: 'line',
data: {
labels: <?php echo json_encode(array_column($data, 'label')); ?>,
datasets: [{
label: 'Total Posts',
data: <?php echo json_encode(array_column($data, 'value')); ?>,
fill: false,
borderColor: 'rgba(255, 255, 255, 1)',
borderWidth: 1
}]
},
options: {
scales: {
y: {
beginAtZero: true,
ticks: {
color: 'white'
}
},
x: {
ticks: {
color: 'white'
}
}
},
plugins: {
legend: {
labels: {
color: 'white'
}
}
}
}
});
</script>
<div class="col-lg-4 mt-4 mb-3">
<div class="card z-index-2">
<div class="card-header p-0 position-relative mt-n4 mx-3 z-index-2 bg-transparent">
<div class="bg-gradient-dark shadow-dark border-radius-lg py-3 pe-1">
<div class="chart">
<canvas id="postsTagChart" width="800" height="400"></canvas>
</div>
</div>
</div>
<div class="card-body">
<h6 class="mb-0">Completed Posts</h6>
<p class="text-sm">Total Posts selected by tag</p>
<hr class="dark horizontal">
<div class="d-flex">
<i class="material-icons text-sm my-auto me-1">schedule</i>
<p class="mb-0 text-sm">Category</p>
</div>
</div>
</div>
</div>
<?php
include './PHP/config/db_conn.php';
// Query to get total posts for each tag
$sql = "SELECT tag, COUNT(*) AS total_posts FROM posts GROUP BY tag";
$result = $conn->query($sql);
// Format data into an array
$data = array();
while ($row = $result->fetch_assoc()) {
$data[] = array(
'label' => $row['tag'],
'value' => $row['total_posts']
);
}
// Close the database connection
?>
<script>
var ctx = document.getElementById('postsTagChart').getContext('2d');
var chart = new Chart(ctx, {
type: 'bar',
data: {
labels: <?php echo json_encode(array_column($data, 'label')); ?>,
datasets: [{
label: 'Total Posts',
data: <?php echo json_encode(array_column($data, 'value')); ?>,
backgroundColor: 'rgba(255, 255, 255, 0.2)',
borderColor: 'rgba(255, 255, 255, 1)',
borderWidth: 1
}]
},
options: {
scales: {
y: {
beginAtZero: true,
ticks: {
color: 'white'
}
},
x: {
ticks: {
color: 'white'
}
}
},
plugins: {
legend: {
labels: {
color: 'white'
}
}
}
}
});
</script>
</div>
<div class="row mb-4">
<div class="col-lg-8 col-md-6 mb-md-0 mb-4">
<div class="card">
<div class="card-header pb-0">
<div class="row">
<div class="col-lg-6 col-7">
<h6>Projects</h6>
<?php
// Get total number of projects
$sql_total = "SELECT COUNT(*) AS total_projects FROM project";
$result_total = $conn->query($sql_total);
if ($result_total->num_rows > 0) {
$row_total = $result_total->fetch_assoc();
$total_projects = $row_total["total_projects"];
echo '<p class="text-sm mb-0"><span class="font-weight-bold ms-1">' . $total_projects . ' done</span> this month</p>';
} else {
echo '<p class="text-sm mb-0"><span class="font-weight-bold ms-1">0 done</span> this month</p>';
}
?>
</div>
</div>
</div>
<div class="card-body px-0 pb-2">
<div class="table-responsive" style="max-height: 400px; overflow-y: auto;">
<table class="table align-items-center mb-0">
<thead>
<tr>
<th class="text-uppercase text-secondary text-xxs font-weight-bolder opacity-7">Companies</th>
<th class="text-uppercase text-secondary text-xxs font-weight-bolder opacity-7">Image</th>
<th class="text-uppercase text-secondary text-xxs font-weight-bolder opacity-7 ps-2">Type of Product</th>
<th class="text-center text-uppercase text-secondary text-xxs font-weight-bolder opacity-7">Category</th>
<!-- <th class="text-center text-uppercase text-secondary text-xxs font-weight-bolder opacity-7">Completion</th> -->
</tr>
</thead>
<tbody>
<?php
include './PHP/config/db_conn.php';
// Fetch projects from the database
$sql = "SELECT company_name, type_of_product, category, image FROM project";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// Output data of each row
while ($row = $result->fetch_assoc()) {
echo '<tr>';
echo '<td><div class="d-flex px-2 py-1"><div class="d-flex flex-column justify-content-center"><h6 class="mb-0 text-sm">' . $row["company_name"] . '</h6></div></div></td>';
echo '<td><div class="d-flex px-2 py-1"><div><img src="./Project/' . $row["image"] . '" class="avatar avatar-sm me-3" alt=""></div></div></td>';
echo '<td><div class="avatar-group mt-2"><span class="text-xs font-weight-bold">' . $row["type_of_product"] . '</span></div></td>';
echo '<td class="align-middle text-center text-sm"><span class="text-xs font-weight-bold">' . $row["category"] . '</span></td>';
// echo '<td class="align-middle"><div class="progress-wrapper w-75 mx-auto"><div class="progress-info"><div class="progress-percentage"><span class="text-xs font-weight-bold">' . $row["completion"] . '</span></div></div><div class="progress"><div class="progress-bar bg-gradient-info w-' . $row["completion"] . '" role="progressbar" aria-valuenow="' . $row["completion"] . '" aria-valuemin="0" aria-valuemax="100"></div></div></div></td>';
echo '</tr>';
}
} else {
echo '<tr><td colspan="5">No projects found</td></tr>';
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
<div class="col-lg-4 col-md-6">
<div class="card h-100">
<div class="card-header pb-0">
<h6>Request Get Quote</h6>
<p class="text-sm"><span class="font-weight-bold">24%</span> this month</p>
</div>
<div class="card-body p-3">
<div class="timeline timeline-one-side">
<div class="timeline-block mb-3">
<span class="timeline-step"><i class="material-icons text-success text-gradient">notifications</i></span>
<div class="timeline-content">
<h6 class="text-dark text-sm font-weight-bold mb-0">$2400, Design changes</h6>
<p class="text-secondary font-weight-bold text-xs mt-1 mb-0">22 DEC 7:20 PM</p>
</div>
</div>
<div class="timeline-block mb-3">
<span class="timeline-step"><i class="material-icons text-danger text-gradient">code</i></span>
<div class="timeline-content">
<h6 class="text-dark text-sm font-weight-bold mb-0">New order #1832412</h6>
<p class="text-secondary font-weight-bold text-xs mt-1 mb-0">21 DEC 11 PM</p>
</div>
</div>
<div class="timeline-block mb-3">
<span class="timeline-step"><i class="material-icons text-info text-gradient">shopping_cart</i></span>
<div class="timeline-content">
<h6 class="text-dark text-sm font-weight-bold mb-0">Server payments for April</h6>
<p class="text-secondary font-weight-bold text-xs mt-1 mb-0">21 DEC 9:34 PM</p>
</div>
</div>
<div class="timeline-block mb-3">
<span class="timeline-step"><i class="material-icons text-warning text-gradient">credit_card</i></span>
<div class="timeline-content">
<h6 class="text-dark text-sm font-weight-bold mb-0">New card added for order #4395133</h6>
<p class="text-secondary font-weight-bold text-xs mt-1 mb-0">20 DEC 2:20 AM</p>
</div>
</div>
<div class="timeline-block mb-3">
<span class="timeline-step"><i class="material-icons text-primary text-gradient">key</i></span>
<div class="timeline-content">
<h6 class="text-dark text-sm font-weight-bold mb-0">Unlock packages for development</h6>
<p class="text-secondary font-weight-bold text-xs mt-1 mb-0">18 DEC 4:54 AM</p>
</div>
</div>
<div class="timeline-block">
<span class="timeline-step"><i class="material-icons text-dark text-gradient">payments</i></span>
<div class="timeline-content">
<h6 class="text-dark text-sm font-weight-bold mb-0">New order #9583120</h6>
<p class="text-secondary font-weight-bold text-xs mt-1 mb-0">17 DEC</p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<footer class="footer py-4">
<div class="container-fluid">
<div class="row align-items-center justify-content-lg-between">
<div class="col-lg-6">
<ul class="nav nav-footer ">
<li class="nav-item">
<a href="../about.php" class="nav-link text-muted" target="_blank">About Us</a>
</li>
<li class="nav-item">
<a href="../blog.php" class="nav-link text-muted" target="_blank">Blog</a>
</li>
<li class="nav-item">
<a href="../index.php" class="nav-link pe-0 text-muted" target="_blank">Home</a>
</li>
</ul>
</div>
</div>
</div>
</footer>
</div>
</main>
<div class="fixed-plugin">
<a class="fixed-plugin-button text-dark position-fixed px-3 py-2"><i class="material-icons py-2">settings</i></a>
<div class="card shadow-lg">
<div class="card-header pb-0 pt-3">
<div class="float-start">
<h5 class="mt-3 mb-0">Settings</h5>
<p>Custome Dashboard</p>
</div>
<div class="float-end mt-4">
<button class="btn btn-link text-dark p-0 fixed-plugin-close-button"><i class="material-icons">clear</i></button>
</div>
</div>
<hr class="horizontal dark my-1">
<div class="card-body pt-sm-3 pt-0">
<div>
<h6 class="mb-0">Sidebar Colors</h6>
</div><a href="javascript:void(0)" class="switch-trigger background-color">
<div class="badge-colors my-2 text-start"></div>
</a>
<div class="mt-3">
<h6 class="mb-0">Sidenav Type</h6>
<p class="text-sm">Choose between 2 different sidenav types.</p>
</div>
<div class="d-flex">
<button class="btn bg-gradient-dark px-3 mb-2 active" data-class="bg-gradient-dark" onclick="sidebarType(this)">Dark</button> <button class="btn bg-gradient-dark px-3 mb-2 ms-2" data-class="bg-transparent" onclick="sidebarType(this)">Transparent</button> <button class="btn bg-gradient-dark px-3 mb-2 ms-2" data-class="bg-white" onclick="sidebarType(this)">White</button>
</div>
<p class="text-sm d-xl-none d-block mt-2">You can change the sidenav type just on desktop view.</p>
<div class="mt-3 d-flex">
<h6 class="mb-0">Navbar Fixed</h6>
<div class="form-check form-switch ps-0 ms-auto my-auto">
<input class="form-check-input mt-1 ms-auto" type="checkbox" id="navbarFixed" onclick="navbarFixed(this)">
</div>
</div>
<hr class="horizontal dark my-3">
<div class="mt-2 d-flex">
<h6 class="mb-0">Light / Dark</h6>
<div class="form-check form-switch ps-0 ms-auto my-auto">
<input class="form-check-input mt-1 ms-auto" type="checkbox" id="dark-version" onclick="darkMode(this)">
</div>
</div>
<hr class="horizontal dark my-sm-4">
</div>
</div>
</div>
<script src="./assets/js/core/popper.min.js"></script>
<script src="./assets/js/core/bootstrap.min.js"></script>
<script src="./assets/js/plugins/perfect-scrollbar.min.js"></script>
<script src="./assets/js/plugins/smooth-scrollbar.min.js"></script>
<script src="./assets/js/plugins/chartjs.min.js"></script>
<script>
var win = navigator.platform.indexOf('Win') > -1;
if (win && document.querySelector('#sidenav-scrollbar')) {
var options = {
damping: '0.5'
}
Scrollbar.init(document.querySelector('#sidenav-scrollbar'), options);
}
</script>
<script async defer src="./../../buttons.github.io/buttons.js"></script>
<script src="./assets/js/material-dashboard.mine63c.js?v=3.1.0"></script>
<script defer src="https://static.cloudflareinsights.com/beacon.min.js/v84a3a4012de94ce1a686ba8c167c359c1696973893317" integrity="sha512-euoFGowhlaLqXsPWQ48qSkBSCFs3DPRyiwVu3FjR96cMPx+Fr+gpWRhIafcHwqwCqWS42RZhIudOvEI+Ckf6MA==" data-cf-beacon='{"rayId":"829f96a1efdc3fc5","b":1,"version":"2023.10.0","token":"1b7cbb72744b40c580f8633c6b62637e"}' crossorigin="anonymous"></script>
</body>
</html>