getConnection(); $message = ''; $error = ''; // معالجة تحديث المخزون if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['update_stock'])) { $product_id = $_POST['product_id']; $movement_type = $_POST['movement_type']; $quantity = intval($_POST['quantity']); $notes = $_POST['notes'] ?? ''; try { $conn->beginTransaction(); // الحصول على الكمية الحالية $stmt = $conn->prepare("SELECT stock_quantity FROM products WHERE id = ?"); $stmt->execute([$product_id]); $current_stock = $stmt->fetchColumn(); // حساب الكمية الجديدة $new_quantity = $current_stock; if ($movement_type === 'in' || $movement_type === 'return') { $new_quantity += $quantity; } elseif ($movement_type === 'out' || $movement_type === 'adjustment') { $new_quantity -= $quantity; } // تحديث المخزون $stmt = $conn->prepare("UPDATE products SET stock_quantity = ? WHERE id = ?"); $stmt->execute([$new_quantity, $product_id]); // تسجيل الحركة $stmt = $conn->prepare("INSERT INTO inventory_movements (product_id, movement_type, quantity, previous_quantity, new_quantity, notes, created_by) VALUES (?, ?, ?, ?, ?, ?, ?)"); $stmt->execute([$product_id, $movement_type, $quantity, $current_stock, $new_quantity, $notes, $_SESSION['user_id']]); // التحقق من التنبيهات $stmt = $conn->prepare("SELECT low_stock_alert FROM products WHERE id = ?"); $stmt->execute([$product_id]); $low_stock_alert = $stmt->fetchColumn(); if ($new_quantity <= 0) { $stmt = $conn->prepare("INSERT INTO inventory_alerts (product_id, alert_type, current_quantity, threshold_quantity) VALUES (?, 'out_of_stock', ?, ?)"); $stmt->execute([$product_id, $new_quantity, $low_stock_alert]); } elseif ($new_quantity <= $low_stock_alert) { $stmt = $conn->prepare("INSERT INTO inventory_alerts (product_id, alert_type, current_quantity, threshold_quantity) VALUES (?, 'low_stock', ?, ?)"); $stmt->execute([$product_id, $new_quantity, $low_stock_alert]); } $conn->commit(); $message = 'تم تحديث المخزون بنجاح'; } catch (Exception $e) { $conn->rollBack(); $error = 'حدث خطأ: ' . $e->getMessage(); } } // الحصول على إحصائيات المخزون $stats = [ 'total_products' => 0, 'low_stock' => 0, 'out_of_stock' => 0, 'total_value' => 0 ]; $stmt = $conn->query("SELECT COUNT(*) FROM products WHERE track_inventory = 1"); $stats['total_products'] = $stmt->fetchColumn(); $stmt = $conn->query("SELECT COUNT(*) FROM products WHERE stock_quantity <= low_stock_alert AND stock_quantity > 0 AND track_inventory = 1"); $stats['low_stock'] = $stmt->fetchColumn(); $stmt = $conn->query("SELECT COUNT(*) FROM products WHERE stock_quantity <= 0 AND track_inventory = 1"); $stats['out_of_stock'] = $stmt->fetchColumn(); $stmt = $conn->query("SELECT SUM(stock_quantity * price) FROM products WHERE track_inventory = 1"); $stats['total_value'] = $stmt->fetchColumn() ?? 0; // الحصول على المنتجات $search = $_GET['search'] ?? ''; $filter = $_GET['filter'] ?? 'all'; $sql = "SELECT p.*, c.name as category_name FROM products p LEFT JOIN categories c ON p.category_id = c.id WHERE p.track_inventory = 1"; if ($search) { $sql .= " AND (p.name LIKE :search OR p.sku LIKE :search)"; } if ($filter === 'low_stock') { $sql .= " AND p.stock_quantity <= p.low_stock_alert AND p.stock_quantity > 0"; } elseif ($filter === 'out_of_stock') { $sql .= " AND p.stock_quantity <= 0"; } $sql .= " ORDER BY p.stock_quantity ASC"; $stmt = $conn->prepare($sql); if ($search) { $stmt->bindValue(':search', "%$search%"); } $stmt->execute(); $products = $stmt->fetchAll(PDO::FETCH_ASSOC); // الحصول على آخر الحركات $stmt = $conn->query("SELECT im.*, p.name as product_name, u.name as user_name FROM inventory_movements im LEFT JOIN products p ON im.product_id = p.id LEFT JOIN users u ON im.created_by = u.id ORDER BY im.created_at DESC LIMIT 10"); $recent_movements = $stmt->fetchAll(PDO::FETCH_ASSOC); ?> إدارة المخزون - Roz Skin

📦 إدارة المخزون

تتبع وإدارة مخزون المنتجات

العودة

إجمالي المنتجات

مخزون منخفض

نفذ من المخزون

قيمة المخزون

ج.م

المنتج SKU الفئة الكمية حد التنبيه الحالة السعر القيمة إجراءات
ج.م ج.م

آخر حركات المخزون

'bg-green-100 text-green-800', 'out' => 'bg-red-100 text-red-800', 'adjustment' => 'bg-blue-100 text-blue-800', 'return' => 'bg-purple-100 text-purple-800' ]; $type_names = [ 'in' => 'إضافة', 'out' => 'صرف', 'adjustment' => 'تعديل', 'return' => 'إرجاع' ]; ?>
المنتج النوع الكمية قبل بعد الملاحظات بواسطة التاريخ