ó
|
î!gi# ã ó8 S SK rS SKJr S SKJr " S S5 rg)é N)Ú lru_cache)ÚDatabaseConnectionc ó2 \ rS rSrS rS rS rS rS rSr g) ÚExtruderServiceé c ó" [ 5 U l g )N)r Údb©Úselfs ÚSC:\Users\admin\Documents\trae_projects\trt_analyse\app\services\extruder_service.pyÚ__init__ÚExtruderService.__init__ s Ü$Ó&ó c ó@ U R R 5 ( d! U R R 5 ( d gU R R 5 nSn[ R
|
" XCX4S9nU$ ! [ a n[ SU 35 SnAgSnAff = f! f = f)u
|
æ¥è¯¢æ¤åºæºæ°æ®
|
:param start_date: å¼å§æ¥æ
|
:param end_date: ç»ææ¥æ
|
:return: å
å«æ¤åºæºæ°æ®çæ°æ®æ¡
|
Naz
|
SELECT
|
time,
|
compound_code,
|
screw_speed_set,
|
screw_speed_actual,
|
extruder_current,
|
head_pressure,
|
machine_head_speed,
|
compound_code_ref,
|
compound_ratio,
|
die_ratio,
|
color_line,
|
buffer_compound,
|
spec_name,
|
metered_weight
|
FROM
|
public.aics_extruder_data
|
WHERE
|
time BETWEEN %s AND %s
|
ORDER BY
|
time ASC
|
)Úparamsu æ¥è¯¢æ°æ®å¤±è´¥: )r Ú is_connectedÚconnectÚget_connectionÚpdÚread_sqlÚ ExceptionÚprint)r Ú
|
start_dateÚend_dateÚ
|
connectionÚqueryÚdfÚes r Úget_extruder_dataÚ!ExtruderService.get_extruder_data s ð* à77×'Ñ'×)Ñ)Øww×(Ñ(Ø ðL ðI ×/Ñ/Ó1JðEô2 U¸
|
Ð7MÑNBàð øô ó Ü Ð(¨¨Ð,Ô -Ûð ûð ûð
|
ús/ >A6 Á3A6 Á6
|
BÂ BÂB ÂBÂB ÂB c óþ Ub UR ( a [ R " 5 $ UR 5 nUS R S5 US' US US :g R [ 5 US' SUS R S' [ U5 X"S S:H R R 5 n/ nU( d¡ UR ( d US R S nUS R S nUS R S nXe-
|
R 5 S - nUS
|
R 5 n UR UR S 5 UUU[ US 5 S .5 GOSUR SUS S- n
|
U
|
R ( d U
|
S R S nU
|
S R S nU
|
S R S nXe-
|
R 5 S - nU
|
S
|
R 5 n UR UR S 5 UUU[ US 5 S .5 [! [# U5 S-
|
5 HÈ n UR X; X;S- S- n U R ( a M/ U S R S nU S R S nU S R S nXe-
|
R 5 S - nU S
|
R 5 n UR UR S 5 UUU[ US 5 [ U S 5 S.5 MÊ UR US S n U R ( d U S R S nU S R S nU S R S nXe-
|
R 5 S - nU S
|
R 5 n UR UR S 5 UUU[ US 5 [ U S 5 S.5 [ R " U5 $ ! [$ a- n[ SU 35 [ R " 5 s SnA$ SnAff = f)uo
|
åºäºè¶æå·åæ´æ£æµæ¢æ¹äºä»¶
|
:param df: æ¤åºæºæ°æ®æ¡
|
:return: å
å«æ¢æ¹äºä»¶çæ°æ®æ¡
|
NÚ compound_codeé Úcompound_code_shiftÚis_batch_changer Útimeéÿÿÿÿé< Úmetered_weightz %Y%m%d%H%M%Sé )Úbatch_idr" Ú
|
start_timeÚend_timeÚduration_minutes)r+ r" r, r- r. Ú production_kgu æ£æµæ¢æ¹äºä»¶å¤±è´¥: )Úemptyr Ú DataFrameÚcopyÚshiftÚastypeÚintÚilocr ÚindexÚtolistÚ total_secondsÚsumÚappendÚstrftimeÚroundÚrangeÚlenr )r r Úbatch_dfÚchange_indicesÚ batch_eventsr, r- r" ÚdurationÚ
|
productionÚfirst_batch_dataÚiÚ
|
batch_dataÚlast_batch_datar s r Údetect_batch_changesÚ$ExtruderService.detect_batch_changes< s ð :Ü<<>Ð !ð] "àwwyHð /7°Ñ.G×.MÑ.MÈaÓ.PHÐ*Ñ +à+3°OÑ+DÈÐQfÑHgÑ+g×*oÑ*oÔpsÓ*tHÐ&Ñ 'Ø23HÐ&Ñ '× ,Ñ ,¨QÑ /ä (Oà %Ð/@Ñ&AÀQÑ&FÑ G× MÑ M× TÑ TÓ VNð Lö "à ~~Ø!)¨&Ñ!1×!6Ñ!6°qÑ!9JØ '¨Ñ /× 4Ñ 4°RÑ 8HØ$,¨_Ñ$=×$BÑ$BÀ1Ñ$EMØ (Ñ 5× DÑ DÓ FÈÑ KHØ!)Ð*:Ñ!;×!?Ñ!?Ó!AJà ×'Ñ'Ø$.×$7Ñ$7¸Ó$GØ)6Ø&0Ø$,Ü,1°(¸AÓ,>ñ )ô ùð $,§=¡=Ð1G°.ÀÑ2CÀaÑ2GÐ#HÐ Ø'×-×-Ø!1°&Ñ!9×!>Ñ!>¸qÑ!AJØ /°Ñ 7× <Ñ <¸RÑ @HØ$4°_Ñ$E×$JÑ$JÈ1Ñ$MMØ (Ñ 5× DÑ DÓ FÈÑ KHØ!1Ð2BÑ!C×!GÑ!GÓ!IJà ×'Ñ'Ø$.×$7Ñ$7¸Ó$GØ)6Ø&0Ø$,Ü,1°(¸AÓ,>ñ )ô ô s >Ó 2°QÑ 6Ö7AØ!)§ ¡ ¨~Ñ/@À ÐTUÑPUÑAVÐYZÑAZÐ
