Changes between Initial Version and Version 1 of DML FINAL FINAL

Timestamp:

09/30/25 20:27:09 (3 weeks ago)

Author:

213231

Comment:

--

DML FINAL FINAL

@@ +1 @@
+
+{{{
+-- 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);
+
+}}}