consolidator

1
import os
2
import sys
3
import pandas as pd
4
import datetime
5
from MainConsolidator import MainConsolidator
6

7
class handler(object):
8
    @staticmethod
9
    def module_name():
10
        return 'Лист Стан 5000'
11
    @staticmethod
12
    def handle(row:pd.Series,consolidator:MainConsolidator)->pd.Series:
13
        product_up = None
14
        try:
15
            product = row["Первичный продукт"]
16
            bz_sign = consolidator.scalar_in_guid("Продукт по НТД",f"`НТД качества (прокат) <Производство>`=='{row['НТД качества (прокат) <Производство>']}'","Доп признак")
17
            steel_mark = row["Марка стали <Производство>"]
18
            width = row["Ширина листа (штрипса), мм <Производство>"]
19
            thickness=row["Толщина, мм <Производство>"]
20
            steel_mark_1_letter = steel_mark[:1]
21
            strength = row["Класс прочности <Производство>"]
22
            if steel_mark_1_letter in ["К","Х","K","X"]: strength=steel_mark
23
            elif steel_mark_1_letter not in ["К","Х","K","X"]: strength=pd.NA
24
            if pd.isna(strength):
25
                strength=consolidator.strength_by_steel(steel_mark)
26
            strength_1 = consolidator.strength_mapping(strength,steel_mark)
27
            strength_led = consolidator.strength_led(strength_1[0])
28
            if strength_led=="К0": strength_led="К52"
29
            gmsps = consolidator.get_gmsps(steel_mark,product)
30
            diametr_=0
31
            if width==1500 or width==2000: diametr_=0
32
            q1020_1 = (width - 5) * (1 - 0.4 / 100) * (1 + 1.1 / 100) / 3.1416 + thickness
33
            q1420_1 = (width - 5) * (1 - 0 / 100) * (1 + 0.6 / 100) / 3.1416 + thickness
34
            d1020 = consolidator.nearest_in_guid("Диаметры ТБД","`Диаметры`>0","Диаметры",q1020_1,"Диаметры")
35
            d1420 = consolidator.nearest_in_guid("Диаметры ТБД","`Диаметры`>0","Диаметры",q1420_1,"Диаметры")            
36
            delta_abs_1020=abs(q1020_1-d1020)
37
            delta_abs_1420=abs(q1420_1-d1420)   
38
            if delta_abs_1020<delta_abs_1420 : diametr_=d1020
39
            else : diametr_=d1420
40
            diametr = str(diametr_).replace(".0","")
41
            
42
            thickness_range=None
43
            if product=="ЛИСТ ТРБ":
44
                thickness_range = consolidator.scalar_in_guid("Параметры по Продукту Прокат",
45
                # f"`Производство`=='Лист Стан 5000' and `Продукт`=='{product}' and `Доп параметр2`=='{strength_led}' and `Доп параметр3`=='ШВ1' and `Мин`<={thickness}<=`Макс`",
46
                f"`Производство`=='Лист Стан 5000' and `Продукт`=='{product}' and `Доп параметр2`=='{strength_led}' and `Доп параметр3`=='ШВ1' and `Доп параметр1`=='{diametr}'",
47
                "Диапазон")
48
                product_up=f"{product} Д{diametr} {thickness_range} ШВ1 {strength_led}"
49
            elif product=="ЛИСТ Р":
50
                if str(bz_sign)=="БЗ":
51
                    thickness_range = consolidator.scalar_in_guid("Параметры по Продукту Прокат",
52
                    f"`Производство`=='Лист Стан 5000' and `Продукт`=='{product}' and `Доп параметр1`=='БЗ' and `Мин`<={thickness}<=`Макс`",
53
                    "Диапазон")
54
                    product_up=f"{product} {thickness_range} БЗ"
55
                else:
56
                    thickness_range = consolidator.scalar_in_guid("Параметры по Продукту Прокат",
57
                    f"`Производство`=='Лист Стан 5000' and `Продукт`=='{product}' and `Доп параметр1`=='{gmsps}' and `Мин`<={thickness}<=`Макс`",
58
                    "Диапазон")
59
                    product_up = f"{product} {thickness_range} {gmsps}"
60
            
61
            print(f"{row['ID в SAP ERP VMZ']} - {product} - {strength_led} - {gmsps} - {diametr_}")
62
            row["error"] = pd.NA
63
        except Exception as exp: 
64
            row["error"] = f"{exp}"
65
        finally:
66
            row["Продукт УП"]=product_up
67
            row["Время укрупнения"]=datetime.datetime.now()
68
            return row
69
        
70
    def debug_handle(self,inputDf:pd.DataFrame,consolidator:MainConsolidator,module:str=None)->pd.DataFrame:
71
        try:
72
            if module is None: return inputDf.apply(lambda row: self.handle(row,consolidator), axis=1)
73
            else: return inputDf[inputDf["Производство2"]==module].apply(lambda row: self.handle(row,consolidator), axis=1)
74
        except: raise
75
    
76
    def get_compiled(self):
77
        code:str=f"print('{__file__}')"
78
        try:
79
            with open(__file__,encoding="utf-8",mode="r") as f:
80
                code=f.read()
81
        except Exception as exp: 
82
            code=f"print('error: {exp}')"
83
        finally:
84
            cc = compile(code,"","exec")
85
            return cc
86

87
if __name__=="__sheet_5k__":
88
    consolidator:MainConsolidator
89
    record:pd.Series
90
    result:pd.Series
91
    result = handler.handle(record,consolidator)
92

93