Changes between Version 1 and Version 2 of buyStock

Timestamp:

08/29/26 01:47:18 (2 weeks ago)

Author:

231020

Comment:

--

buyStock

@@ -22 +22 @@
 
 Корисникот внесува количина и клика да купи акција,
+
 {{{
-INSERT INTO trade_request (id,portfolio_id, price_per_unit, quantity, status, stock_symbol, timestamp, type)
+INSERT INTO trade_request (
+    id,
+    portfolio_id,
+    price_per_unit,
+    quantity,
+    status,
+    stock_id,
+    timestamp,
+    type
+)
 VALUES
-(4,1, 1500.00, 5, 'PENDING', 'ALK', NOW(), 'BUY');
+(4, 1, 1500.00, 5, 'PENDING', 1, NOW(), 'BUY');
 }}}
 
@@ -33 +43 @@
 
 {{{
-INSERT INTO transactions (id, type, quantity, price, timestamp, origin, user_id, stock_id)
-select
-        4,
+INSERT INTO transactions (
+    id,
+    type,
+    quantity,
+    price,
+    timestamp,
+    origin,
+    user_id,
+    stock_id,
+    trade_request_id
+)
+SELECT
+    4,
     'BUY' AS type,
     tr.quantity,
@@ -42 +62 @@
     'INTERNAL' AS origin,
     p.user_id,
-    s.id AS stock_id
+    s.id AS stock_id,
+    tr.id AS trade_request_id
 FROM trade_request tr
 JOIN portfolios p ON tr.portfolio_id = p.id
-JOIN stock s ON s.symbol = tr.stock_symbol
+JOIN stock s ON s.id = tr.stock_id
 WHERE tr.status = 'PENDING';
 
@@ -52 +73 @@
 WHERE status = 'PENDING';
 }}}
-
-
-
-
-