From aacc6148dd43a9cffbff9a23a273a55b64bf3d8c Mon Sep 17 00:00:00 2001 From: Administrator <admin@example.com> Date: 星期六, 12 十月 2024 17:21:42 +0800 Subject: [PATCH] bug修复 --- third_data/kpl_util.py | 160 ++++++++++++++++++++++++++++++++++++++++++++++++++++- 1 files changed, 156 insertions(+), 4 deletions(-) diff --git a/third_data/kpl_util.py b/third_data/kpl_util.py index 68fe651..5117cbc 100644 --- a/third_data/kpl_util.py +++ b/third_data/kpl_util.py @@ -1,6 +1,8 @@ import enum import json +from db import mysql_data_delegate as mysql_data + def parse_kpl_datas(results): start_y = -1 @@ -30,7 +32,7 @@ # 娑ㄥ仠浠g爜锛� -# (浠g爜,鍚嶇О,棣栨娑ㄥ仠鏃堕棿,鏈�杩戞定鍋滄椂闂�,鍑犳澘,娑ㄥ仠鍘熷洜,鏉垮潡,瀹為檯娴侀��,涓诲姏鍑�棰�) +# (浠g爜,鍚嶇О,棣栨娑ㄥ仠鏃堕棿,鏈�杩戞定鍋滄椂闂�,鍑犳澘,娑ㄥ仠鍘熷洜,鏉垮潡,瀹為檯娴侀��,涓诲姏鍑�棰�,娑ㄥ仠鍘熷洜浠g爜,娑ㄥ仠鍘熷洜浠g爜鏁伴噺) # (0,1,6,25,9,16,11,15,12) # 绔炰环浠g爜锛� # (浠g爜,鍚嶇О,娑ㄥ仠濮斾拱棰�,鏉垮潡,绔炰环鎴愪氦棰�,瀹為檯娴侀��) @@ -62,21 +64,27 @@ BEST_FENG_KOU = "best_feng_kou" FENG_XIANG = "feng_xiang" INDUSTRY_RANK = "industry_rank" + JINGXUAN_RANK = "jingxuan_rank" def __parseDaBanItemData(data, type): if type == DABAN_TYPE_BIDDING: return data[0], data[1], data[18], data[11], data[22], data[15] elif type == DABAN_TYPE_LIMIT_UP: - return data[0], data[1], data[6], data[25], data[9], data[16], data[11], data[15], data[12] + # (浠g爜, 鍚嶇О, 棣栨娑ㄥ仠鏃堕棿, 鏈�杩戞定鍋滄椂闂�, 鍑犳澘, 娑ㄥ仠鍘熷洜, 鏉垮潡, 瀹為檯娴侀��, 涓诲姏鍑�棰�, 娑ㄥ仠鍘熷洜浠g爜, 娑ㄥ仠鍘熷洜浠g爜鏁伴噺) + return data[0], data[1], data[6], data[25], data[9], data[16], data[11], data[15], data[12], data[26], data[27] elif type == DABAN_TYPE_OPEN_LIMIT_UP: return data[0], data[1], data[4], data[11], data[15] elif type == DABAN_TYPE_LIMIT_DOWN: return data[0], data[1], data[11], data[15] elif type == DABAN_TYPE_EVER_LIMIT_DOWN: return data[0], data[1], data[4], data[11], data[15] - return None + + +def __parseLimitUpItemData(data): + # (浠g爜, 鍚嶇О, 棣栨娑ㄥ仠鏃堕棿, 鏈�杩戞定鍋滄椂闂�, 鍑犳澘, 娑ㄥ仠鍘熷洜, 鏉垮潡, 瀹為檯娴侀��, 涓诲姏鍑�棰�, 娑ㄥ仠鍘熷洜浠g爜, 娑ㄥ仠鍘熷洜浠g爜鏁伴噺) + return data[0], data[1], data[4], data[4], data[18], data[5], data[12], data[13], data[8], data[19], data[20] # 鏈�寮洪鍙� @@ -112,6 +120,20 @@ fresult_ = [] for d in list_: pdata = __parseDaBanItemData(d, type_) + if pdata: + fresult_.append(pdata) + return fresult_ + + +def parseLimitUpData(data): + if type(data) == str: + data = json.loads(data) + if int(data["errcode"]) != 0: + raise Exception(f"瑙f瀽鏁版嵁鍑洪敊锛宔rrcode锛歿data['errcode']}") + list_ = data["list"] + fresult_ = [] + for d in list_: + pdata = __parseLimitUpItemData(d) if pdata: fresult_.append(pdata) return fresult_ @@ -170,4 +192,134 @@ pdata = __parseIndustry_rank(d) if pdata: fresult_.append(pdata) - return fresult_ \ No newline at end of file + return fresult_ + + +# 瑙f瀽鏉垮潡浠g爜 +def parsePlateCodes(data): + if type(data) == str: + data = json.loads(data) + if int(data["errcode"]) != 0: + raise Exception(f"瑙f瀽鏁版嵁鍑洪敊锛宔rrcode锛歿data['errcode']}") + list_ = data["list"] + fresult_ = [] + for d in list_: + # (浠g爜,鍚嶇О,鐜颁环,娑ㄥ箙,鑷敱娴侀��,鍑犳澘锛岄緳鍑狅紝涓诲姏鍑�棰�,300w鍑�棰�,鏈烘瀯澧炰粨) + fresult_.append((d[0], d[1], d[5], d[6], d[10], d[23], d[24], d[13], d[50], d[42])) + return fresult_ + + +# 瑙f瀽姒傚康涓殑鏉垮潡寮哄害 +def parseSonPlat(data): + if type(data) == str: + data = json.loads(data) + if int(data["errcode"]) != 0: + raise Exception(f"瑙f瀽鏁版嵁鍑洪敊锛宔rrcode锛歿data['errcode']}") + list_ = data["List"] + fresult_ = [] + for d in list_: + # (浠g爜,鍚嶇О,寮哄害) + fresult_.append((d[0], d[1], d[2])) + return fresult_ + + +def __money_desc(money): + if abs(money) > 100000000: + return f"{round(money / 100000000, 2)}浜�" + else: + return f"{round(money / 10000, 2)}涓�" + + +def parseMarketIndustry(data): + if type(data) == str: + data = json.loads(data) + if int(data["errcode"]) != 0: + raise Exception(f"瑙f瀽鏁版嵁鍑洪敊锛宔rrcode锛歿data['errcode']}") + list_ = data["list"] + fresult_ = [] + for d in list_: + # (浠g爜,鍚嶇О,娑ㄥ箙,涓诲姏鍑�棰�) + fresult_.append((d[0], d[1], d[3], d[6])) + return fresult_ + + +def parseMarketJingXuan(data): + if type(data) == str: + data = json.loads(data) + if int(data["errcode"]) != 0: + raise Exception(f"瑙f瀽鏁版嵁鍑洪敊锛宔rrcode锛歿data['errcode']}") + list_ = data["list"] + fresult_ = [] + for d in list_: + # (浠g爜,鍚嶇О,寮哄害,涓诲姏鍑�棰�) + fresult_.append((d[0], d[1], d[2], d[6])) + return fresult_ + + +class KPLPlatManager: + def save_plat(self, _id, name): + if not _id: + return + mysqldb = mysql_data.Mysqldb() + key = f"{_id}-{name}" + results = mysqldb.select_one(f"select * from kpl_plate where _name='{name}'") + if not results: + mysqldb.execute(f"insert into kpl_plate(_id,_name,_key) values({_id},'{name}','{key}')") + + def get_plat(self, name): + mysqldb = mysql_data.Mysqldb() + results = mysqldb.select_one(f"select * from kpl_plate where _name='{name}'") + if results: + return results[0] + return None + + def get_same_plat_names(self, name): + mysqldb = mysql_data.Mysqldb() + plate = self.get_plat(name) + if not plate: + return {name} + results = mysqldb.select_all(f"select _name from kpl_plate where _id='{plate}'") + return set([r[0] for r in results]) + + def get_same_plat_names_by_id(self, id_): + mysqldb = mysql_data.Mysqldb() + results = mysqldb.select_all(f"select _name from kpl_plate where _id='{id_}'") + return set([r[0] for r in results]) + + +# 鑾峰彇楂樹綅鏉跨殑鏁伴噺 +def get_high_level_count(key): + if key.find("杩炴澘") >= 0: + # 褰㈠紡濡�: 3杩炴澘 + return int(key.replace("杩炴澘", "")) + elif key.find("澶�") >= 0 and key.find("鏉�") >= 0: + # 褰㈠紡濡傦細5澶�4鏉� + return int(key.split("澶�")[1].replace("鏉�", "")) + # 褰㈠紡濡傦細棣栨澘 + return 1 + + +# 鑾峰彇瀹炴椂娑ㄥ仠鍒楄〃涓殑娑ㄥ仠鍘熷洜 +def get_current_limit_up_reasons(item) -> set: + b = {item[5]} + if item[6]: + b |= set(item[6].split("銆�")) + return b + + +# 鑾峰彇鐩墠鐨勬定鍋滃師鍥� +def get_current_limit_up_reason(item) -> str: + return item[5] + + +def filter_block(block): + if not block: + return block + return block.replace("姒傚康", "") + + +if __name__ == "__main__": + print(get_high_level_count("棣栨澘")) + print(get_high_level_count("5澶�4鏉�")) + print(get_high_level_count("2杩炴澘")) + print(get_high_level_count("4杩炴澘")) -- Gitblit v1.8.0