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 'Штрипс ТЭСЦ-3'
11
    @staticmethod
12
    def handle(row:pd.Series,consolidator:MainConsolidator)->pd.Series:
13
        try:
14
            product = row["Первичный продукт"]
15
            gmsps = row["ГМСПС"]
16
            thickness = row["Толщина, мм <Производство>"]
17
            width_led = consolidator.nearest_in_guid("Параметры по Продукту ТЭСЦ-3",
18
                f"`Производство`=='Штрипс ТЭСЦ-3' and `Продукт`=='{product}' and `Доп параметр2` == '{gmsps[:2]}'",
19
                "Доп параметр1",
20
                row["Ширина штрипса, мм <Производство>"],
21
                "Доп параметр1")
22
            width_led_s=str(width_led).replace(".0","")
23
            product_up = None
24
            thickness_range = None
25
            if "ГУ" in gmsps:
26
                thickness_range = consolidator.scalar_in_guid("Параметры по Продукту ТЭСЦ-3",
27
                    f"`Производство`=='Штрипс ТЭСЦ-3' and `Продукт`=='{product}' and `Доп параметр2` == 'ГУ' and `Мин`<={thickness}<=`Макс`","Диапазон")
28
                product_up=f"{product} {thickness_range} Ш{width_led_s} ГУ"
29
            else:
30
                product_up=f"{product} Ш{width_led_s} {gmsps}"
31
            print(f"product: {product}; thickness: {thickness}; width_led: {width_led_s}; thickness_range: {thickness_range}")
32
            row["error"] = pd.NA
33
        except Exception as exp: 
34
            row["error"] = f"{exp}"
35
        finally:
36
            row["Продукт УП"]=product_up
37
            row["Время укрупнения"]=datetime.datetime.now()
38
            return row
39
        
40
    def debug_handle(self,inputDf:pd.DataFrame,consolidator:MainConsolidator,module:str=None)->pd.DataFrame:
41
        try:
42
            if module is None: return inputDf.apply(lambda row: self.handle(row,consolidator), axis=1)
43
            else: return inputDf[inputDf["Производство2"]==module].apply(lambda row: self.handle(row,consolidator), axis=1)
44
        except: raise
45
    
46
    def get_compiled(self):
47
        code:str=f"print('{__file__}')"
48
        try:
49
            with open(__file__,encoding="utf-8",mode="r") as f:
50
                code=f.read()
51
        except Exception as exp: 
52
            code=f"print('error: {exp}')"
53
        finally:
54
            cc = compile(code,"","exec")
55
            return cc
56

57
if __name__=="__strips_t3__":
58
    consolidator:MainConsolidator
59
    record:pd.Series
60
    result:pd.Series
61
    result = handler.handle(record,consolidator)
62

63