prepare("SELECT * FROM user_permissions WHERE user_id = ? AND page = 'accounting' AND can_view = 1"); $stmt->execute([$user_id]); if (!$stmt->fetch()) { echo "
لا تملك صلاحية الوصول لهذه الصفحة.
"; require_once 'includes/footer.php'; exit; } // Handle form submission if ($_SERVER['REQUEST_METHOD'] === 'POST') { if (isset($_POST['add_entry'])) { $date = $_POST["date"] ?? ""; $description = $_POST["description"] ?? ""; $reference = $_POST["reference"] ?? ""; $entries = [ ["account" => $_POST["debit_account"] ?? "", "debit" => (float)($_POST["amount"] ?? 0), "credit" => 0], ["account" => $_POST["credit_account"] ?? "", "debit" => 0, "credit" => (float)($_POST["amount"] ?? 0)] ]; if (add_journal_entry($date, $description, $reference, $entries)) { $message = "تم إضافة القيد بنجاح."; } else { $error = "حدث خطأ أثناء إضافة القيد."; } } elseif (isset($_POST['edit_entry'])) { $id_to_edit = (int)$_POST['edit_id']; $date = $_POST["date"] ?? ""; $description = $_POST["description"] ?? ""; $reference = $_POST["reference"] ?? ""; $entries = [ ["account" => $_POST["debit_account"] ?? "", "debit" => (float)($_POST["amount"] ?? 0), "credit" => 0], ["account" => $_POST["credit_account"] ?? "", "debit" => 0, "credit" => (float)($_POST["amount"] ?? 0)] ]; if (edit_journal_entry($id_to_edit, $date, $description, $reference, $entries)) { $message = "تم تعديل القيد بنجاح."; } else { $error = "حدث خطأ أثناء تعديل القيد."; } } elseif (isset($_POST['delete_entry'])) { $id_to_delete = (int)$_POST['delete_id']; if (delete_journal_entry($id_to_delete)) { $message = "تم حذف القيد بنجاح."; } else { $error = "حدث خطأ أثناء حذف القيد."; } } } // Pagination and Filtering setup $page = isset($_GET['page']) ? (int)$_GET['page'] : 1; // Standardized to 'page' if ($page < 1) $page = 1; $limit = 10; $offset = ($page - 1) * $limit; $search = $_GET['search'] ?? ''; $date_from = $_GET['date_from'] ?? ''; $date_to = $_GET['date_to'] ?? ''; // Fetch ledger data with filters using optimized functions $totalFiltered = get_ledger_count($search, $date_from, $date_to); $ledger = get_ledger_paginated($search, $date_from, $date_to, $limit, $offset); ?>

المحاسبة (Accounting)

دفتر الأستاذ (General Ledger)

التاريخالوصفالمرجعالحسابمديندائنأضيف بواسطة عُدل بواسطة الإجراءات
لا توجد قيود.