Changes between Version 1 and Version 2 of Buy-Rent

Timestamp:

05/04/25 18:27:18 (13 days ago)

Author:

211301

Comment:

--

Buy-Rent

@@ -10 +10 @@
 
 * Се креира запис во Procurement и T_Type.
+
+{{{
+INSERT INTO Procurement (TransactionID, EmployeeID, CustomerID, ProductID, ProcurementDate, Quantity)
+VALUES (3, 1, 2, 3, '2025-05-04', 1);
+}}}
+
+{{{
+INSERT INTO T_Type (TransactionID, Type, Duration, MonthlyPay, TotalPrice)
+VALUES (3, 'Buy', NULL, NULL, 30000.00);
+}}}
+
+* Преглед на извршени трансакции.
+
+{{{
+SELECT 
+    c.CustomerName,
+    c.CustomerSurName,
+    p.Model AS TruckModel,
+    tt.TotalPrice,
+    pr.ProcurementDate
+FROM 
+    Procurement pr
+JOIN Customer c ON pr.CustomerID = c.CustomerID
+JOIN Product p ON pr.ProductID = p.ProductID
+JOIN T_Type tt ON pr.TransactionID = tt.TransactionID
+WHERE 
+    tt.Type = 'Buy';
+}}}