-- تفريغ البيانات التشغيلية — الإبقاء على إعدادات البرنامج الأساسية فقط
-- نفّذ من phpMyAdmin (استخدم DELETE بدلاً من TRUNCATE بسبب قيود المفاتيح الأجنبية)

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- === حركات مبيعات ومشتريات وديون ===
DELETE FROM payment_allocations;
DELETE FROM inventory_movements;
DELETE FROM sales_items;
DELETE FROM payments;
DELETE FROM discounts;
DELETE FROM cancellation_reasons;
DELETE FROM customer_payments;
DELETE FROM sales_headers;
DELETE FROM purchase_payments;
DELETE FROM purchase_items;
DELETE FROM purchase_headers;
DELETE FROM warehouse_receipts;
DELETE FROM warehouse_disbursements;
DELETE FROM warehouse_disposals;
DELETE FROM maintenance_payments;
DELETE FROM maintenance;
DELETE FROM cheques;
DELETE FROM expenses;
DELETE FROM warranties;
DELETE FROM customer_discounts;
DELETE FROM invoice_sequences;

ALTER TABLE payment_allocations AUTO_INCREMENT = 1;
ALTER TABLE inventory_movements AUTO_INCREMENT = 1;
ALTER TABLE customer_payments AUTO_INCREMENT = 1;
ALTER TABLE maintenance AUTO_INCREMENT = 1;
ALTER TABLE cheques AUTO_INCREMENT = 1;
ALTER TABLE expenses AUTO_INCREMENT = 1;
ALTER TABLE warranties AUTO_INCREMENT = 1;
ALTER TABLE customer_discounts AUTO_INCREMENT = 1;

-- === الأصناف والتصنيفات ===
DELETE FROM items;
ALTER TABLE items AUTO_INCREMENT = 1;

DELETE FROM categories;
ALTER TABLE categories AUTO_INCREMENT = 1;

-- === العملاء: الإبقاء على الزبون النقدي فقط (رقم 1) ===
DELETE FROM customers WHERE CustomerID <> 1;

INSERT INTO customers (CustomerID, CustomerName, PhoneNumber, OpeningBalance)
VALUES (1, 'زبون نقدي', '0000000000', 0.00)
ON DUPLICATE KEY UPDATE
    CustomerName = VALUES(CustomerName),
    OpeningBalance = 0.00;

-- === الموردون ===
DELETE FROM suppliers;
ALTER TABLE suppliers AUTO_INCREMENT = 1;

SET FOREIGN_KEY_CHECKS = 1;

-- يُبقى دون مسح: users, permission_groups, permissions, group_permissions,
-- company_info, settings, branches, warehouses