-- Insert customers
INSERT INTO customer (CustomerID, CustomerName, CustomerSurName, Email, Address, CustomerContact, Password) VALUES
(1, 'Marko', 'Markovski', 'markoexample.com', 'Street 123, Skopje', '070123456', 'marko123'),
(2, 'Elena', 'Stojanova', 'elenaexample.com', 'Boulevard 45, Bitola', '071987654', 'elena123'),
(3, 'David', 'Trajchev', 'davidtrajchevgmail.com', 'UL.ANASTAS MITREV BR.41-2', '076999813', 'pwd_hash_1'),
(4, 'David-v2', 'Trajchev', 'V2davidtrajchevgmail.com', 'UL.ANASTAS MITREV BR.41-2', '077999813', 'pwd_hash_2'),
(5, 'Davidd', 'Trajchev', 'ddavidtrajchevgmail.com', 'UL.ANASTAS MITREV BR.41-2', '076999813', 'pwd_hash_3');

-- Insert employees
INSERT INTO employee (EmployeeID, EmployeeName, EmployeeSurName, Position, Department, Email, Password) VALUES
(1, 'Ivan', 'Petrov', 'Sales Manager', 'Sales', 'ivanexample.com', 'ivan123'),
(2, 'Ana', 'Kostova', 'Maintenance Specialist', 'Maintenance', 'anaexample.com', 'ana123'),
(1000, 'Admin', 'User', 'Admin', 'Admin', 'adminexample.com', 'admin123'),
(1001, 'David', 'Trajchev', 'Test', 'Maintenance', 'davidexample.com', 'david123');

-- Insert procurement transactions
INSERT INTO procurement (TransactionID, EmployeeID, CustomerID, ProcurementDate, Quantity, Status, Notified, GroupID) VALUES
(1, 1, 1, '2025-04-01', 1, 'Rejected', FALSE, NULL),
(2, 1, 2, '2025-04-10', 1, 'Rejected', FALSE, NULL),
(3, 1, 2, '2025-05-04', 1, 'Rejected', FALSE, NULL),
(4, 1, 3, '2025-05-20', 1, 'Approved', TRUE, '1');

-- Insert wallet data
INSERT INTO wallet (WalletID, CustomerID, Balance, CardNumber, ExpiryDate, CVV, CardHolderName) VALUES
(5, 3, 27010854.31, '4444444444444444', '2027-12-31', '123', 'David Trajchev'),
(6, 4, 3000.00, '5500000000000004', '2028-11-30', '456', 'David-v2 Trajchev'),
(7, 2, 3000.00, '5500000000000000', '2026-11-30', '456', 'Elena Stojanova');

-- Insert procurement_request data
INSERT INTO procurement_request (RequestID, CustomerID, WalletID, ProcurementID, Quantity, RequestedAt, Status, PaymentMethod, PaymentStatus, MonthlyPay, TotalPrice, Duration, CardID, TransactionType, GroupID) VALUES
(1, 3, 2, 1, 1, '2025-05-28 18:48:35', 'Rejected', NULL, 'Reserved', 95000.00, 2280000.00, 24, NULL, 'Buy', NULL),
(38, 3, 2, 1, 1, '2025-05-29 00:59:48', 'Approved', 'Card', 'Reserved', NULL, 100.00, NULL, 5, 'Buy', NULL);

-- Insert products
INSERT INTO product (ProductID, ProcurementID, ProcurementRequestID, Model, Price, LicensePlate, Status) VALUES
(1, 1, 1, 'Volvo FH16', 3500.00, 'SK-1234-AB', 'sold'),
(2, 1, 1, 'Scania R500', 100.00, 'BT-5678-CD', 'sold'),
(3, 2, 1, 'Kgel Trailer', 300.00, 'SK-2468-EF', 'available'),
(4, 2, 1, 'DAF808', 100.00, 'SK-1111-LL', 'sold');

-- Insert feedback
INSERT INTO customerfeedback (FeedbackID, CustomerID, Rating, Comment, FeedbackDate, TransactionID) VALUES
(1, 1, 5, 'Odlichen kamion, mnogu zadovolen!', '2025-04-05', 1),
(2, 2, 4, 'Dobar kamion, no malo skapo.', '2025-04-15', 2);

-- Insert maintenance records
INSERT INTO maintenance (MainID, MainDate, Description, Cost, Status, StartTime, EndTime) VALUES
(2, '2025-05-04', 'Maintenance scheduled', 0.00, 'Completed', '2025-06-01 13:27:50', NULL),
(3, '2025-05-22', 'Pending maintenance', 0.00, 'Pending', '2025-06-01 13:27:50', NULL);

-- Insert trucks
INSERT INTO truck (ProductID, HP) VALUES
(1, 750),
(2, 500),
(4, 999);

-- Insert trailers
INSERT INTO trailer (ProductID, Capacity) VALUES
(3, 20.50),
(5, 99.00);

-- Insert transaction types
INSERT INTO t_type (TransactionID, Type, Duration, MonthlyPay, TotalPrice) VALUES
(3, 'Buy', NULL, NULL, 30000.00),
(11, 'Buy', NULL, NULL, 120000.00),
(12, 'Rent', 24, 3958.33, 95000.00);

-- Insert product maintenance associations
INSERT INTO product_maintenance (ProductID, MaintenanceID) VALUES
(1, 2),
(3, 3);

-- Insert employee maintenance associations
INSERT INTO employee_maintenance (EmployeeID, MaintenanceID) VALUES
(2, 2),
(1, 3);

-- Insert views (customer viewed products)
INSERT INTO views (CustomerID, ProductID) VALUES
(1, 1),
(2, 2),
(2, 1);