From 0e932be7645f402e435def37a50314888e850368 Mon Sep 17 00:00:00 2001
From: Administrator <admin@example.com>
Date: 星期一, 06 一月 2025 15:50:07 +0800
Subject: [PATCH] 板块买入调整
---
trade/trade_data_manager.py | 6 +++---
1 files changed, 3 insertions(+), 3 deletions(-)
diff --git a/trade/trade_data_manager.py b/trade/trade_data_manager.py
index 1866b1e..284eefd 100644
--- a/trade/trade_data_manager.py
+++ b/trade/trade_data_manager.py
@@ -446,15 +446,15 @@
sql = "SELECT * FROM ( "
- sql += f"SELECT '鑲＄エ', COUNT(*) FROM (SELECT * FROM `hx_trade_deal_record` r WHERE r.`tradeDate` >='{from_date}' and r.`tradeDate` <='{to_date}' AND (r.`securityID` LIKE '30%' OR r.`securityID` LIKE '60%' OR r.`securityID` LIKE '68%' OR r.`securityID` LIKE '00%') GROUP BY r.`orderSysID`) a"
+ sql += f"SELECT '鑲＄エ', COUNT(*), sum(a.price*a.volume) as '閲戦' FROM (SELECT * FROM `hx_trade_deal_record` r WHERE r.`tradeDate` >='{from_date}' and r.`tradeDate` <='{to_date}' AND (r.`securityID` LIKE '30%' OR r.`securityID` LIKE '60%' OR r.`securityID` LIKE '68%' OR r.`securityID` LIKE '00%') GROUP BY r.`orderSysID`) a"
sql += " UNION ALL "
- sql += f"SELECT '涓婅瘉鍩洪噾', COUNT(*) AS '鏁伴噺' FROM (SELECT * FROM `hx_trade_deal_record` r WHERE r.`tradeDate` >='{from_date}' and r.`tradeDate` <='{to_date}' AND (r.`securityID` LIKE '11%') GROUP BY r.`orderSysID`) a"
+ sql += f"SELECT '涓婅瘉鍩洪噾', COUNT(*) AS '鏁伴噺', sum(a.price*a.volume) as '閲戦' FROM (SELECT * FROM `hx_trade_deal_record` r WHERE r.`tradeDate` >='{from_date}' and r.`tradeDate` <='{to_date}' AND (r.`securityID` LIKE '11%') GROUP BY r.`orderSysID`) a"
sql += " UNION ALL "
- sql += f"SELECT '娣辫瘉鍩洪噾', COUNT(*) AS '鏁伴噺' FROM (SELECT * FROM `hx_trade_deal_record` r WHERE r.`tradeDate` >='{from_date}' and r.`tradeDate` <='{to_date}' AND (r.`securityID` LIKE '12%') GROUP BY r.`orderSysID`) a"
+ sql += f"SELECT '娣辫瘉鍩洪噾', COUNT(*) AS '鏁伴噺', sum(a.price*a.volume) as '閲戦' FROM (SELECT * FROM `hx_trade_deal_record` r WHERE r.`tradeDate` >='{from_date}' and r.`tradeDate` <='{to_date}' AND (r.`securityID` LIKE '12%') GROUP BY r.`orderSysID`) a"
sql += ") a"
return self.__mysqldb.select_all(sql)
--
Gitblit v1.8.0