byp4a55 professor6T9

Linux ns1.eurodns.top 4.18.0-553.22.1.lve.1.el7h.x86_64 #1 SMP Tue Oct 8 14:36:03 UTC 2024 x86_64
LiteSpeed
135.181.9.38

File Name : projects.php

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

include '../config.php';
if ($_SERVER['REQUEST_METHOD'] === 'POST' && !empty($_POST['name'])) {
    $id = isset($_POST['id']) ? intval($_POST['id']) : 0;
    $name = mysqli_real_escape_string($conn, $_POST['name']);
    $client = mysqli_real_escape_string($conn, $_POST['client']);
    $location = mysqli_real_escape_string($conn, $_POST['location']);
    $total = floatval($_POST['total']);
    $status = mysqli_real_escape_string($conn, $_POST['status']);
    $date = date('Y-m-d H:i:s');

if ($id > 0) {
        // تحديث
        $sql = "UPDATE projects SET 
            name='$name',
            client='$client',
            location='$location',
            total='$total',
            status='$status'
        WHERE id=$id";
        mysqli_query($conn, $sql);

header("Location: projects.php?msg=تم+تعديل+المشروع+بنجاح+✅");
                exit;
    } else {
        // إضافة
        $sql = "INSERT INTO projects (name, client, location, total, status, create_at) 
        VALUES ('$name', '$client', '$location', '$total', '$status', '$date')";
        mysqli_query($conn, $sql);
         header("Location: projects.php?msg=تم+اضافه+المشروع+بنجاح+✅");
          exit;
    }
}
?>

<?php

$page_title = "إيكوبيشن | الموردين";
include("../inheader.php");
include('../insidebar.php');
?>

<div class="main">
    <div class="aligin">
        <a href="javascript:void(0)" id="toggleForm" class="add">
            <i class="fa fa-plus"></i> اضافة مشروع (Add Project)
        </a>
    </div>

<?php if (!empty($_GET['msg'])): ?>
        <div style="background:#d4edda; color:#155724; padding:10px; border-radius:6px; margin:10px 0; text-align:center;">
            <?php echo htmlspecialchars($_GET['msg']); ?>
        </div>
    <?php endif; ?>

<form id="projectForm" action="" method="post" style="display:none;">
        <div class="card shadow-sm">
            <div class="card-header bg-dark text-white">
                <h5 class="mb-0"> اضافة/ تعديل مشروع (Add / Edit Project) </h5>
            </div>
            <div class="card-body">
                <input type="hidden" name="id" id="project_id" value="">
                <div class="form-grid">
                    <div>
                        <label>اسم المشروع (Project Name)</label>
                        <input type="text" name="name" placeholder="ادخل اسم المشروع" id="project_name" required />
                    </div>
                    <div>
                        <label>اسم العميل (Client Name)</label>
                        <input type="text" name="client" placeholder="ادخل اسم العميل" id="project_client" required />
                    </div>
                    <div>
                        <label>موقع المشروع (Project location)</label>
                        <input type="text" name="location" placeholder="ادخل موقع المشروع" id="project_location" required />
                        <input type="hidden" name="total" value="0" required />
                    </div>
                    <div>
                        <label>حالة المشروع (Project Status)</label>
                        <select name="status" id="project_status">
                            <option value=""> -- حدد الحالة (Choose Status) -- </option>
                            <option value="1">نشط (active)</option>
                            <option value="0">غير نشط (dis active)</option>
                        </select>
                    </div>
                    <button style="color:black;" type="submit">حفظ ( Save ) </button>
                </div>
            </div>
        </div>
    </form>
    <br />

<div class="card shadow-sm">
        <div class="card-header bg-dark text-white">
            <h5 class="mb-0"> قائمة المشاريع (Project List )</h5>
        </div>
        <div class="card-body">
            <table id="projectsTable" class="display" style="width:100%; margin-top: 20px;">
                <thead>
                    <tr>
                        
                    
                        <th> تاريخ الإضافة </th>
                        <th> اسم المشروع</th>
                        <th> عدد الاليات</th>
                        <th>العقود</th>
                        <th> العميل</th>
                        <th>الموقع</th>
                        <th> عدد الموردين</th>
                        <th> الحالة</th>
                        <th> إجراءات</th>
                    </tr>
                </thead>
                <tbody>
                    <?php
                    include '../config.php';

// جلب المشاريع
                    $query = "SELECT `id`, `name`, `client`, `location`, `total` , `status` , `create_at`, 
                      (SELECT COUNT(*) FROM contracts WHERE contracts.project = projects.id) as 'contracts',
                      (SELECT COUNT(*) FROM operations WHERE operations.project = projects.id) as 'operations',
                      (SELECT COUNT(DISTINCT pm.suppliers) 
                          FROM equipments pm
                          JOIN operations m ON pm.id = m.equipment
                          WHERE m.project = projects.id) as 'total_suppliers'
                      FROM projects ORDER BY id DESC";
                    $result = mysqli_query($conn, $query);
                    $i = 1;
                    while ($row = mysqli_fetch_assoc($result)) {
                        echo "<tr>";
                        // echo "<td>" . $i++ . "</td>";
                        echo "<td>" . $row['create_at'] . "</td>";
                        echo "<td>" . $row['name'] . "</td>";
                        echo "<td>" . $row['operations'] . "</td>";
                        echo "<td>" . $row['contracts'] . "</td>";
                        echo "<td>" . $row['client'] . "</td>";
                        echo "<td>" . $row['location'] . "</td>";
                        echo "<td>" . $row['total_suppliers'] . "</td>";
                        echo $row['status'] == "1" ? "<td style='color:green'>نشط</td>" : "<td style='color:red'>غير نشط</td>";
                        echo "<td>
                        <a href='javascript:void(0)' 
                           class='editBtn' 
                           data-id='" . $row['id'] . "' 
                           data-name='" . $row['name'] . "' 
                           data-client='" . $row['client'] . "' 
                           data-location='" . $row['location'] . "' 
                           data-status='" . $row['status'] . "'
                           style='color:#007bff'><i class='fa fa-edit'></i></a> | 
                        <a href='#' onclick='return confirm(\"هل أنت متأكد؟\")' style='color: #dc3545'><i class='fa fa-trash'></i></a> | 
                        <a href='projects_details.php?id=" . $row['id'] . "' style='color: #28a745'> <i class='fa fa-eye'></i> </a>
                      </td>";
                        echo "</tr>";
                    }
                    ?>
                </tbody>
            </table>
        </div>
    </div>
</div>

<script src="https://code.jquery.com/jquery-3.7.1.min.js"></script>

<script src="https://cdn.datatables.net/1.13.6/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.datatables.net/responsive/2.5.0/js/dataTables.responsive.min.js"></script>
<script src="https://cdn.datatables.net/buttons/2.4.1/js/dataTables.buttons.min.js"></script>
<script src="https://cdn.datatables.net/buttons/2.4.1/js/buttons.html5.min.js"></script>
<script src="https://cdn.datatables.net/buttons/2.4.1/js/buttons.print.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.10.1/jszip.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.2.7/pdfmake.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.2.7/vfs_fonts.js"></script>

// اظهار/اخفاء الفورم
        const toggleProjectFormBtn = document.getElementById('toggleForm');
        const projectForm = document.getElementById('projectForm');
        toggleProjectFormBtn.addEventListener('click', function () {
            projectForm.style.display = projectForm.style.display === "none" ? "block" : "none";
            // تنظيف الحقول عند الإضافة
            $("#project_id").val("");
            $("#project_name").val("");
            $("#project_client").val("");
            $("#project_location").val("");
            $("#project_status").val("");
        });

// عند الضغط على زر تعديل
        $(document).on("click", ".editBtn", function () {
            $("#project_id").val($(this).data("id"));
            $("#project_name").val($(this).data("name"));
            $("#project_client").val($(this).data("client"));
            $("#project_location").val($(this).data("location"));
            $("#project_status").val($(this).data("status"));

$("#projectForm").show();
            $("html, body").animate({ scrollTop: $("#projectForm").offset().top }, 500);
        });
    })();
</script>

</body>

</html>

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	equipati/equipati	0755	2025-09-21 01:58:16
..	dir	-	equipati/equipati	0755	2025-09-21 01:29:53
projects.php	text/x-php	10.37 KB	equipati/equipati	0644	2025-09-18 06:45:40
projects_details.php	text/x-php	9.02 KB	equipati/equipati	0644	2025-09-18 04:23:56

Team Anon Force

https://t.me/Professor6T9x