One Hat Cyber Team

Edit File Name: view_technicians.php

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

if (!isset($_SESSION['user_id'])) {
    header("Location: ../index.php");
    exit();
}

// عدد الفنيين لكل صفحة
$technicians_per_page = isset($_GET['per_page']) ? (int)$_GET['per_page'] : 10; 
$current_page = isset($_GET['page']) ? (int)$_GET['page'] : 1; 
$offset = ($current_page - 1) * $technicians_per_page;

// البحث
$search = isset($_GET['search']) ? $_GET['search'] : '';
$search_term = '%' . $search . '%';

// عد الفنيين للحصول على العدد الإجمالي
$count_query = "SELECT COUNT(*) as total FROM technicians WHERE name LIKE ? OR city LIKE ?";
$count_stmt = $conn->prepare($count_query);
$count_stmt->bind_param('ss', $search_term, $search_term);
$count_stmt->execute();
$count_result = $count_stmt->get_result();
$total_technicians = $count_result->fetch_assoc()['total'];
$total_pages = ceil($total_technicians / $technicians_per_page);

// استعلام الفنيين
$query = "SELECT * FROM technicians WHERE name LIKE ? OR city LIKE ? LIMIT ? OFFSET ?";
$stmt = $conn->prepare($query);
$stmt->bind_param('ssii', $search_term, $search_term, $technicians_per_page, $offset);
$stmt->execute();
$result = $stmt->get_result();
?>

<!DOCTYPE html>
<html lang="ar">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>عرض الفنيين</title>
    <link href="https://fonts.googleapis.com/css2?family=Cairo:wght@400;600&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">
        <link rel="icon" type="image/x-icon" href="../images/favicon.ico">
    <style>
        body {
            font-family: 'Cairo', sans-serif;
            direction: rtl;
            background-color: #f4f4f4;
            margin: 0;
            color: #333;
            overflow-x: hidden;
        }

h1 {
            text-align: center;
            color: #444;
        }

.content {
            margin-right: 250px;
            padding: 20px;
            transition: margin-right 0.3s ease;
        }

.menu-toggle {
            display: none;
            position: fixed;
            top: 15px;
            left: 15px;
            background-color: #004080;
            color: #fff;
            padding: 10px 15px;
            border: none;
            cursor: pointer;
            font-size: 20px;
            border-radius: 5px;
            z-index: 1001;
        }

@media (max-width: 768px) {
            .sidebar {
                transform: translateX(100%);
            }
            .content {
                margin-right: 0;
            }
            .menu-toggle {
                display: block;
            }
        }

.search-form {
            display: flex;
            align-items: center;
            margin-bottom: 15px;
        }

.search-form input[type="text"] {
            padding: 10px;
            font-size: 16px;
            border: 1px solid #ddd;
            border-radius: 4px;
            margin-right: 10px;
            flex-grow: 1;
        }

.search-form input[type="submit"] {
            padding: 10px 20px;
            background-color: #007BFF;
            color: white;
            border: none;
            border-radius: 4px;
            cursor: pointer;
            font-size: 16px;
            transition: background-color 0.3s;
        }

.search-form input[type="submit"]:hover {
            background-color: #0056b3;
        }

table {
            width: 100%;
            border-collapse: collapse;
            margin-top: 20px;
            background-color: #fff;
            box-shadow: 0 2px 10px rgba(0, 0, 0, 0.1);
            border-radius: 8px;
            overflow: hidden;
        }

table th, table td {
            padding: 15px;
            border: 1px solid #ddd;
            text-align: center;
        }

table th {
            background-color: #1e4878;
            color: white;
        }

.button {
            background-color: #4CAF50;
            color: white;
            padding: 10px 15px;
            text-align: center;
            text-decoration: none;
            display: inline-block;
            border: none;
            border-radius: 4px;
            cursor: pointer;
            transition: background-color 0.3s;
        }

.button:hover {
            background-color: #45a049;
        }

.button.delete {
            background-color: #f44336;
        }

.button.delete:hover {
            background-color: #d32f2f;
        }
        .pagination {
    margin: 20px 0;
    text-align: center;
}

.pagination a {
    display: inline-block;
    padding: 10px 15px;
    margin: 0 5px;
    background-color: #007BFF;
    color: white;
    text-decoration: none;
    border-radius: 4px;
    transition: background-color 0.3s;
}

.pagination a:hover {
    background-color: #0056b3;
}

.pagination a.active {
    background-color: #0056b3;
    pointer-events: none;
}
/* تنسيق القائمة المنسدلة */
    .per-page-select {
        margin: 20px 0;
        text-align: center;
    }
    .per-page-select select {
        padding: 8px 15px;
        border: 1px solid #ddd;
        border-radius: 8px;
        font-size: 14px;
        outline: none;
        transition: all 0.3s ease-in-out;
    }
    .per-page-select select:focus {
        border-color: #007bff;
        box-shadow: 0 2px 6px rgba(0, 123, 255, 0.3);
    }

</style>
</head>
<body>
    <button class="menu-toggle" onclick="toggleSidebar()">☰</button>

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

<div class="content">
        <h1>قائمة الفنيين</h1>
        <div class="search-form">
            <form action="view_technicians.php" method="GET">
                <input type="text" name="search" placeholder="ابحث عن الفنيين حسب الاسم أو المدينة" value="<?php echo htmlspecialchars($search); ?>">
                <input type="submit" value="بحث">
            </form>
        </div>
        <a class="button" href="add_technician.php">إضافة فني جديد</a>
        <div class="per-page-select">
    <form method="get" action="view_technicians.php">
        <input type="hidden" name="search" value="<?php echo htmlspecialchars($search); ?>">
        <label for="per_page">عدد الفنيين لكل صفحة:</label>
        <select name="per_page" id="per_page" onchange="this.form.submit()">
            <option value="10" <?php if ($technicians_per_page == 10) echo 'selected'; ?>>10</option>
            <option value="25" <?php if ($technicians_per_page == 25) echo 'selected'; ?>>25</option>
            <option value="50" <?php if ($technicians_per_page == 50) echo 'selected'; ?>>50</option>
            <option value="100" <?php if ($technicians_per_page == 100) echo 'selected'; ?>>100</option>
        </select>
    </form>
</div>

<table>
            <thead>
                <tr>
                    <th>اسم الفني</th>
                    <th>رقم الهاتف</th>
                    <th>المدينة</th>
                    <th>سعر التركيب</th>
                    <th>الإجراءات</th>
                </tr>
            </thead>
            <tbody>
                <?php if ($result->num_rows > 0) { ?>
                <?php while ($technician = $result->fetch_assoc()) { ?>
                <tr>
                    <td><?php echo $technician['name']; ?></td>
                    <td><?php echo $technician['phone']; ?></td>
                    <td><?php echo $technician['city']; ?></td>
                    <td><?php echo number_format($technician['installation_price'], 2); ?> د.م.</td>
                    <td>
                        <a class="button" href="edit_technician.php?id=<?php echo $technician['id']; ?>">تعديل</a>
                        <a class="button delete" href="delete_technician.php?id=<?php echo $technician['id']; ?>" onclick="return confirm('هل أنت متأكد من حذف هذا الفني؟')">حذف</a>
                    </td>
                </tr>
                <?php } ?>
                <?php } else { ?>
                <tr>
                    <td colspan="5">لا يوجد فنيين.</td>
                </tr>
                <?php } ?>
            </tbody>
        </table>
    </div>
<div class="pagination">
    <?php if ($current_page > 1): ?>
        <a href="?page=<?php echo $current_page - 1; ?>&per_page=<?php echo $technicians_per_page; ?>&search=<?php echo urlencode($search); ?>">السابق</a>
    <?php endif; ?>
    <?php for ($i = 1; $i <= $total_pages; $i++): ?>
        <a href="?page=<?php echo $i; ?>&per_page=<?php echo $technicians_per_page; ?>&search=<?php echo urlencode($search); ?>" class="<?php if ($i == $current_page) echo 'active'; ?>"><?php echo $i; ?></a>
    <?php endfor; ?>
    <?php if ($current_page < $total_pages): ?>
        <a href="?page=<?php echo $current_page + 1; ?>&per_page=<?php echo $technicians_per_page; ?>&search=<?php echo urlencode($search); ?>">التالي</a>
    <?php endif; ?>
</div>