One Hat Cyber Team

View File Name : dashboard.php

<?php
session_start();
require_once 'db_connection.php';

if (!isset($_SESSION['user_id'])) {
    header("Location: ../index.php");
    exit();
}
$conn = new mysqli($host, $username, $password, $dbname);

// التحقق من الاتصال
if ($conn->connect_error) {
    die("فشل الاتصال: " . $conn->connect_error);
}

// جلب التاريخ من النموذج إذا تم إرساله
$filter_date = isset($_GET['filter_date']) ? $_GET['filter_date'] : null;

// دالة لاستخراج التاريخ من العمود code
function extractDateFromCode($code) {
    if (preg_match('/EAG-(\d{2})(\d{2})(\d{4})/', $code, $matches)) {
        return $matches[3] . '-' . $matches[2] . '-' . $matches[1]; // YYYY-MM-DD
    }
    return null;
}

// جلب الإحصائيات من قاعدة البيانات مع الفلترة حسب التاريخ
$product_count_query = "SELECT COUNT(*) AS total FROM products";
$technicians_count_query = "SELECT COUNT(*) AS total FROM technicians";
$total_stock_query = "SELECT SUM(quantity) AS total FROM product_quantities";
$low_stock_query = "SELECT COUNT(*) AS total FROM product_quantities WHERE quantity < 10";

if ($filter_date) {
    $order_count_query = "SELECT COUNT(*) AS total FROM deliveries WHERE DATE(STR_TO_DATE(SUBSTRING(code, 5, 8), '%d%m%Y')) = '$filter_date'";
    $delivered_orders_query = "SELECT COUNT(*) AS total FROM invoices WHERE DATE(STR_TO_DATE(SUBSTRING(code, 5, 8), '%d%m%Y')) = '$filter_date'";
    $returned_orders_query = "SELECT COUNT(*) AS total FROM routers WHERE DATE(STR_TO_DATE(SUBSTRING(code, 5, 8), '%d%m%Y')) = '$filter_date'";
    $missing_orders_query = "
        SELECT COUNT(*) AS total
        FROM deliveries d
        LEFT JOIN invoices i ON d.code = i.code
        LEFT JOIN routers r ON d.code = r.code
        LEFT JOIN solved s ON d.code = s.code
        WHERE i.code IS NULL AND r.code IS NULL AND s.code IS NULL
        AND DATE(STR_TO_DATE(SUBSTRING(d.code, 5, 8), '%d%m%Y')) = '$filter_date'
    ";
    $solved_orders_query = "SELECT COUNT(*) AS total FROM solved WHERE DATE(STR_TO_DATE(SUBSTRING(code, 5, 8), '%d%m%Y')) = '$filter_date'";
    $total_revenue_query = "SELECT SUM(crbt) AS total FROM orders WHERE status = 'delivered' AND DATE(STR_TO_DATE(SUBSTRING(code, 5, 8), '%d%m%Y')) = '$filter_date'";
} else {
    $order_count_query = "SELECT COUNT(*) AS total FROM deliveries";
    $delivered_orders_query = "SELECT COUNT(*) AS total FROM invoices";
    $returned_orders_query = "SELECT COUNT(*) AS total FROM routers";
    $missing_orders_query = "
        SELECT COUNT(*) AS total
        FROM deliveries d
        LEFT JOIN invoices i ON d.code = i.code
        LEFT JOIN routers r ON d.code = r.code
        LEFT JOIN solved s ON d.code = s.code
        WHERE i.code IS NULL AND r.code IS NULL AND s.code IS NULL
    ";
    $solved_orders_query = "SELECT COUNT(*) AS total FROM solved";
    $total_revenue_query = "SELECT SUM(crbt) AS total FROM orders WHERE status = 'delivered'";
}

$product_count_result = $conn->query($product_count_query);
$product_count = $product_count_result->fetch_assoc()['total'];

$technicians_count_result = $conn->query($technicians_count_query);
$technicians_count = $technicians_count_result->fetch_assoc()['total'];

$order_count_result = $conn->query($order_count_query);
$order_count = $order_count_result->fetch_assoc()['total'];

$delivered_orders_result = $conn->query($delivered_orders_query);
$delivered_orders = $delivered_orders_result->fetch_assoc()['total'];

$returned_orders_result = $conn->query($returned_orders_query);
$returned_orders = $returned_orders_result->fetch_assoc()['total'];

$missing_orders_result = $conn->query($missing_orders_query);
$missing_orders = $missing_orders_result->fetch_assoc()['total'];

$solved_orders_result = $conn->query($solved_orders_query);
$solved_orders = $solved_orders_result->fetch_assoc()['total'];

$total_stock_result = $conn->query($total_stock_query);
$total_stock = $total_stock_result->fetch_assoc()['total'];

$low_stock_result = $conn->query($low_stock_query);
$low_stock = $low_stock_result->fetch_assoc()['total'];

$total_revenue_result = $conn->query($total_revenue_query);
$total_revenue = $total_revenue_result->fetch_assoc()['total'];

$conn->close(); // إغلاق الاتصال
?>

<html>
<head>
    <base href="/" />
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>لوحة التحكم</title>
    <link rel="icon" type="image/x-icon" href="images/favicon.ico">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css">
    <link href="https://fonts.googleapis.com/css2?family=Cairo:wght@400;600;700&display=swap" rel="stylesheet">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.4/css/all.min.css">
    <link rel="stylesheet" href="../css/sidebar.css">
</head>
<style>
:root {
    --primary: #002147;
    --secondary: #0056b3;
    --accent: #ffdd00;
    --text: #333;
    --bg: #f5f6fa;
    --white: #ffffff;
    --shadow: 0 4px 6px rgba(0,0,0,0.1);
    --transition: all 0.3s ease;
    --gradient-orders: linear-gradient(135deg, #4e54c8, #8f94fb);
    --gradient-delivered: linear-gradient(135deg, #11998e, #38ef7d);
    --gradient-returned: linear-gradient(135deg, #eb3349, #f45c43);
    --gradient-missing: linear-gradient(135deg, #f7b733, #fc4a1a);
    --gradient-solved: linear-gradient(135deg, #00b09b, #96c93d);
    --gradient-products: linear-gradient(135deg, #614385, #516395);
    --gradient-technicians: linear-gradient(135deg, #5c258d, #4389a2);
}

* {
    margin: 0;
    padding: 0;
    box-sizing: border-box;
    font-family: 'Cairo', sans-serif;
}

body {
    background: var(--bg);
    direction: rtl;
    min-height: 100vh;
}

.menu-toggle {
    display: none;
    position: fixed;
    top: 1rem;
    right: 1rem;
    background: var(--primary);
    color: var(--white);
    border: none;
    border-radius: 50%;
    width: 45px;
    height: 45px;
    font-size: 1.2rem;
    cursor: pointer;
    z-index: 1002;
    transition: var(--transition);
    box-shadow: var(--shadow);
}

.menu-toggle:hover {
    background: var(--secondary);
    transform: scale(1.1);
}






@media (max-width: 768px) {
    .menu-toggle {
        display: block;
        position: fixed;
        top: 1rem;
        right: 1rem;
        z-index: 1002;
    }
    
    
    
    .stats-container {
        margin-right: 0;
        padding: 1rem;
        margin-top: 70px;
        grid-template-columns: repeat(auto-fit, minmax(250px, 1fr));
        gap: 1.2rem;
    }
}

.stats-container {
    margin-right: 300px;
    padding: 2rem;
    display: grid;
    grid-template-columns: repeat(auto-fit, minmax(280px, 1fr));
    gap: 1.8rem;
    animation: fadeInUp 0.8s ease-out;
}

.stat-card {
    background: var(--white);
    padding: 1.5rem;
    border-radius: 15px;
    box-shadow: 0 10px 20px rgba(0,0,0,0.08);
    transition: all 0.4s ease;
    position: relative;
    overflow: hidden;
    text-decoration: none;
    display: flex;
    align-items: center;
    gap: 1.5rem;
    min-height: 120px;
}

.stat-card::before {
    content: '';
    position: absolute;
    top: 0;
    left: 0;
    width: 100%;
    height: 100%;
    background: var(--gradient-orders);
    opacity: 0.95;
    z-index: 0;
}

.stat-card:nth-child(1)::before {
    background: var(--gradient-orders);
}

.stat-card:nth-child(2)::before {
    background: var(--gradient-delivered);
}

.stat-card:nth-child(3)::before {
    background: var(--gradient-returned);
}

.stat-card:nth-child(4)::before {
    background: var(--gradient-missing);
}

.stat-card:nth-child(5)::before {
    background: var(--gradient-solved);
}

.stat-card:nth-child(6)::before {
    background: var(--gradient-products);
}

.stat-card:nth-child(7)::before {
    background: var(--gradient-technicians);
}

.stat-icon {
    position: relative;
    z-index: 1;
    font-size: 2.5rem;
    color: var(--white);
    background: rgba(255, 255, 255, 0.2);
    padding: 1rem;
    border-radius: 12px;
    transition: all 0.3s ease;
}

.stat-content {
    position: relative;
    z-index: 1;
    flex-grow: 1;
}

.stat-value {
    font-size: 2rem;
    font-weight: 700;
    color: var(--white);
    margin-bottom: 0.3rem;
    text-shadow: 2px 2px 4px rgba(0,0,0,0.1);
}

.stat-label {
    color: var(--white);
    font-size: 1.1rem;
    font-weight: 600;
    opacity: 0.9;
}

.stat-card:hover {
    transform: translateY(-5px);
    box-shadow: 0 15px 30px rgba(0,0,0,0.15);
}

.stat-card:hover .stat-icon {
    transform: scale(1.1) rotate(10deg);
    background: rgba(255, 255, 255, 0.3);
}

@keyframes fadeInUp {
    from {
        opacity: 0;
        transform: translateY(30px);
    }
    to {
        opacity: 1;
        transform: translateY(0);
    }
}

.control-buttons {
    display: flex;
    gap: 1.5rem;
    justify-content: center;
    margin: 2rem auto;
    padding: 0 2rem;
}

.control-button {
    padding: 1rem 2rem;
    background: linear-gradient(135deg, var(--secondary), var(--primary));
    color: var(--white);
    border: none;
    border-radius: 10px;
    cursor: pointer;
    transition: var(--transition);
    font-weight: 600;
    font-size: 1.1rem;
    box-shadow: 0 3px 10px rgba(0,0,0,0.1);
}

.control-button:hover {
    transform: translateY(-2px) scale(1.02);
    box-shadow: 0 5px 15px rgba(0,0,0,0.2);
}

.sidebar-overlay {
    display: none;
    position: fixed;
    top: 0;
    left: 0;
    right: 0;
    bottom: 0;
    background: rgba(0, 0, 0, 0.5);
    z-index: 999;
    opacity: 0;
    transition: opacity 0.3s ease;
}

@media (max-width: 768px) {
    .sidebar-overlay.active {
        display: block;
        opacity: 1;
    }
}
.filter-container {
    display: flex;
    justify-content: center;
    align-items: center;
    margin: 20px 0;
    padding: 15px;
    background: var(--white);
    box-shadow: var(--shadow);
    border-radius: 10px;
    width: 90%;
    max-width: 600px;
    margin-left: auto;
    margin-right: auto;
    position: sticky;
    top: 10px;
    z-index: 1000;
}

.filter-container form {
    display: flex;
    align-items: center;
    gap: 10px;
    width: 100%;
}

.filter-container label {
    font-size: 1rem;
    font-weight: 600;
    color: var(--text);
}

.filter-container input[type="date"] {
    padding: 8px;
    border: 1px solid var(--primary);
    border-radius: 5px;
    font-size: 1rem;
    color: var(--text);
}

.filter-container button {
    padding: 8px 15px;
    background: var(--primary);
    color: var(--white);
    border: none;
    border-radius: 5px;
    cursor: pointer;
    font-size: 1rem;
    transition: var(--transition);
}

.filter-container button:hover {
    background: var(--secondary);
    transform: scale(1.05);
}

.filter-container button[type="button"] {
    background: var(--accent);
    color: var(--text);
}

.filter-container button[type="button"]:hover {
    background: #ffcc00;
}
</style>
<body>

<button class="menu-toggle" onclick="toggleSidebar()">
    <i class="fas fa-bars"></i>
</button>

<div class="sidebar-overlay" onclick="toggleSidebar()"></div>

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

<!-- نموذج فلترة التاريخ -->
<div class="filter-container">
    <form method="GET" action="">
        <label for="filter_date">فلترة حسب تاريخ الطلبية:</label>
        <input type="date" id="filter_date" name="filter_date" value="<?php echo $filter_date; ?>">
        <button type="submit">فلترة</button>
        <?php if ($filter_date): ?>
            <button type="button" onclick="window.location.href='?'">إلغاء الفلترة</button>
        <?php endif; ?>
    </form>
</div>

<main class="stats-container">
   <a href="../orders/all_orders.php" class="stat-card">
        <div class="stat-icon">
            <i class="fas fa-shopping-cart"></i>
        </div>
        <div class="stat-content">
            <div class="stat-value"><?php echo $order_count; ?></div>
            <div class="stat-label">إجمالي الطلبات</div>
        </div>
    </a>
    
    <a href="../orders/delivered_orders.php" class="stat-card">
        <div class="stat-icon">
            <i class="fas fa-check-circle"></i>
        </div>
        <div class="stat-content">
            <div class="stat-value"><?php echo $delivered_orders; ?></div>
            <div class="stat-label">الطلبات المسلمة</div>
        </div>
    </a>
    
    <a href="tracking/view_routers.php" class="stat-card">
        <div class="stat-icon">
            <i class="fas fa-undo-alt"></i>
        </div>
        <div class="stat-content">
            <div class="stat-value"><?php echo $returned_orders; ?></div>
            <div class="stat-label">الطلبات المرجعة</div>
        </div>
    </a>
    
    <a href="tracking/compare_codes.php" class="stat-card">
        <div class="stat-icon">
            <i class="fas fa-exclamation-triangle"></i>
        </div>
        <div class="stat-content">
            <div class="stat-value"><?php echo $missing_orders; ?></div>
            <div class="stat-label">الطلبات المفقودة</div>
        </div>
    </a>
    
    <a href="../orders/solved_orders.php" class="stat-card">
        <div class="stat-icon">
            <i class="fas fa-check-double"></i>
        </div>
        <div class="stat-content">
            <div class="stat-value"><?php echo $solved_orders; ?></div>
            <div class="stat-label">الطلبات المحلولة</div>
        </div>
    </a>
    
    <a href="../products/view_products.php" class="stat-card">
        <div class="stat-icon">
            <i class="fas fa-box-open"></i>
        </div>
        <div class="stat-content">
            <div class="stat-value"><?php echo $product_count; ?></div>
            <div class="stat-label">عدد المنتجات</div>
        </div>
    </a>
    
    <a href="../technicians/view_technicians.php" class="stat-card">
        <div class="stat-icon">
            <i class="fas fa-user-cog"></i>
        </div>
        <div class="stat-content">
            <div class="stat-value"><?php echo $technicians_count; ?></div>
            <div class="stat-label">عدد الفنيين</div>
        </div>
    </a>
</main>
</main>

<div class="control-buttons">
    <button class="control-button" onclick="location.href='products/add_product.php'">
        <i class="fas fa-plus-circle"></i> إضافة منتج
    </button>
    <button class="control-button" onclick="location.href='technicians/add_technician.php'">
        <i class="fas fa-user-plus"></i> إضافة فني
    </button>
</div>

<script>
function toggleSidebar() {
    const sidebar = document.querySelector('.sidebar');
    const menuToggle = document.querySelector('.menu-toggle');
    
    sidebar.classList.toggle('active');
    
    if(sidebar.classList.contains('active')) {
        menuToggle.innerHTML = '<i class="fas fa-times"></i>';
        
        setTimeout(() => {
            document.addEventListener('click', function closeMenu(e) {
                if(!sidebar.contains(e.target) && !e.target.classList.contains('menu-toggle')) {
                    sidebar.classList.remove('active');
                    menuToggle.innerHTML = '<i class="fas fa-bars"></i>';
                    document.removeEventListener('click', closeMenu);
                }
            });
        }, 100);
    } else {
        menuToggle.innerHTML = '<i class="fas fa-bars"></i>';
    }
}

document.addEventListener('DOMContentLoaded', function() {
    const sidebar = document.querySelector('.sidebar');
    sidebar.style.transition = 'transform 0.3s ease';
});

function toggleSubmenu(event) {
    event.preventDefault();
    event.stopPropagation();
    const parent = event.currentTarget.parentElement;
    parent.classList.toggle('active');
    const submenu = parent.querySelector('.submenu');
    submenu.classList.toggle('active');
}

document.querySelectorAll('.stat-value').forEach(value => {
    const finalValue = parseInt(value.textContent);
    let currentValue = 0;
    const duration = 2000;
    const steps = 60;
    const increment = finalValue / steps;
    
    const easeOutQuart = x => 1 - Math.pow(1 - x, 4);
    
    let step = 0;
    const counter = setInterval(() => {
        step++;
        const progress = step / steps;
        const easedProgress = easeOutQuart(progress);
        currentValue = Math.floor(finalValue * easedProgress);
        
        if(step >= steps) {
            value.textContent = finalValue.toLocaleString();
            clearInterval(counter);
        } else {
            value.textContent = currentValue.toLocaleString();
        }
    }, duration / steps);
});

const observer = new IntersectionObserver((entries) => {
    entries.forEach(entry => {
        if (entry.isIntersecting) {
            entry.target.style.opacity = '1';
            entry.target.style.transform = 'translateY(0)';
        }
    });
}, {
    threshold: 0.1
});

document.querySelectorAll('.stat-card').forEach(card => {
    observer.observe(card);
});
</script>

</body>
</html>