def FindObjMPR(Table: str, REF: str):
if Table == Settings.Var_Process1():
Type = Settings.Dir_BDR()
else:
Type = Settings.Dir_PBDR()
Refs, Workers, Providers, References2, Presentations, NumRems, NumPres, NumCoils, NumCoilsR, TotalWeight, TotalWeightR, InitialDate, FinalDate, CodeBr = SQLMPR.FindMPR(
Type, REF)
return (Providers, References2, Presentations)
def UpgradeMPPR(Provider: str, Presentation: str, Table: str,
REMISION: str, CODE: str, DATO_MOD, Value):
if Provider == Settings.Var_Provider1():
if Presentation == Settings.Var_P1():
NameTable = Settings.Var_EC()
else:
NameTable = Settings.Var_EE()
else:
if Presentation == Settings.Var_P1():
NameTable = Settings.Var_IC()
else:
NameTable = Settings.Var_IE()
if Table == Settings.Var_Process1():
Type = Settings.Dir_BDR()
else:
Type = Settings.Dir_PBDR()
SQLFunction.UpdateMPPR(NameTable, Type, REMISION, CODE, DATO_MOD,
Value)
def FindESMPPR(Provider: str, Presentation: str, Table: str, REF: str):
if Provider == Settings.Var_Provider1():
if Presentation == Settings.Var_P1():
NameTable = Settings.Var_EC()
else:
NameTable = Settings.Var_EE()
else:
if Presentation == Settings.Var_P1():
NameTable = Settings.Var_IC()
else:
NameTable = Settings.Var_IE()
if Table == Settings.Var_Process1():
Type = Settings.Dir_BDR()
else:
Type = Settings.Dir_PBDR()
CodeBr, NumPre, NumRem, NumCoils, NumCoilsR, TotalW, TotalWR, Measure = SQLFunction.FindsMPPR(
NameTable, Type, REF)
return (NumCoils, NumCoilsR, TotalW, TotalWR)
def FindObjMPPR(Provider: str, Presentation: str, Table: str, REF: str):
if Provider == Settings.Var_Provider1():
if Presentation == Settings.Var_P1():
NameTable = Settings.Var_EC()
else:
NameTable = Settings.Var_EE()
else:
if Presentation == Settings.Var_P1():
NameTable = Settings.Var_IC()
else:
NameTable = Settings.Var_IE()
if Table == Settings.Var_Process1():
Type = Settings.Dir_BDR()
else:
Type = Settings.Dir_PBDR()
CodeB, Num_Pre, Num_Rem, Num_Coils, Num_CoilsR, Total_Weight, Total_WeightR, Measurement = SQLFunction.FindCodeBMPPR(
NameTable, Type, REF)
return (CodeB)
def FindAllItemMPR(Table: str, ItemToFind: str):
if Table == Settings.Var_Process1():
Type = Settings.Dir_BDR()
else:
Type = Settings.Dir_PBDR()
Refs, Workers, Providers, References, Presentations, NumRems, NumPres, NumCoils, NumCoilsR, TotalWeight, TotalWeightR, InitialDate, FinalDate, CodeBr = SQLMPR.FindALLMPR(
Type)
if ItemToFind == Settings.Var_Comp26(): return Refs
elif ItemToFind == Settings.Var_Comp15(): return Workers
elif ItemToFind == Settings.Var_Comp14(): return Providers
elif ItemToFind == Settings.Var_Comp13(): return References
elif ItemToFind == Settings.Var_Comp12(): return Presentations
elif ItemToFind == Settings.Var_Comp9(): return NumRems
elif ItemToFind == Settings.Var_Comp3(): return NumPres
elif ItemToFind == Settings.Var_Comp6(): return NumCoils
elif ItemToFind == Settings.Var_Comp7(): return NumCoilsR
elif ItemToFind == Settings.Var_Comp4(): return TotalWeight
elif ItemToFind == Settings.Var_Comp28(): return TotalWeightR
elif ItemToFind == Settings.Var_Comp19(): return InitialDate
elif ItemToFind == Settings.Var_Comp20(): return FinalDate
elif ItemToFind == Settings.Var_Comp1(): return CodeBr
def UpgradeMPR(Table: str, REMISION: str, DATO_MOD, Value):
if Table == Settings.Var_Process1():
Type = Settings.Dir_BDR()
else:
Type = Settings.Dir_PBDR()
SQLMPR.UpdateMPR(Type, REMISION, DATO_MOD, Value)
