query("SELECT * FROM users"); // إضافة دين if (isset($_POST['create'])) { $user_id = $_POST['user_id']; $credit = $_POST['credit']; $info = $_POST['info']; $credit_date = $_POST['credit_date']; $due_date = date('Y-m-d', strtotime('+1 month', strtotime($credit_date))); $u = $conn->query("SELECT credit_limit, creditstopay FROM users WHERE user_id = $user_id")->fetch_assoc(); $remaining = $u['credit_limit'] - $u['creditstopay']; if ($credit > $remaining) { echo ""; } else { $conn->query("INSERT INTO credits (user_id, credit, info, credit_date, due_date) VALUES ('$user_id', '$credit', '$info', '$credit_date', '$due_date')"); $conn->query("UPDATE users SET creditstopay = creditstopay + $credit WHERE user_id = $user_id"); echo ""; } } // حذف دين if (isset($_GET['delete'])) { $id = $_GET['delete']; $row = $conn->query("SELECT * FROM credits WHERE credit_id = $id")->fetch_assoc(); $conn->query("UPDATE users SET creditstopay = creditstopay - {$row['credit']} WHERE user_id = {$row['user_id']}"); $conn->query("DELETE FROM credits WHERE credit_id = $id"); echo ""; } // تصفير وطباعة ديون محددة if (isset($_POST['zero_selected']) && !empty($_POST['selected_credits'])) { $selected = $_POST['selected_credits']; $_SESSION['zeroed_credit_ids'] = $selected; echo ""; foreach ($selected as $credit_id) { $credit = $conn->query("SELECT * FROM credits WHERE credit_id = $credit_id")->fetch_assoc(); $conn->query("INSERT INTO zeroed_credits (user_id, credit, info, credit_date, due_date, zeroed_at) VALUES ('{$credit['user_id']}', '{$credit['credit']}', '{$credit['info']}', '{$credit['credit_date']}', '{$credit['due_date']}', NOW())"); $conn->query("UPDATE users SET creditstopay = creditstopay - {$credit['credit']} WHERE user_id = {$credit['user_id']}"); $conn->query("DELETE FROM credits WHERE credit_id = $credit_id"); } } $credits = $conn->query("SELECT c.*, u.username FROM credits c JOIN users u ON c.user_id = u.user_id ORDER BY c.credit_date DESC"); ?> إدارة الديون
إدارة ديون المستخدمين
fetch_assoc()) { ?>
الرقم المستخدم المبلغ الوصف تاريخ الإضافة تاريخ الاستحقاق الإجراء
حذف
close(); ?>