Xh d d dl mZmZmZmZ d dlmZ d dlZd dlmZm Z d dl
m Z m Z G d d Z
y) )
AlertModelAlertTypeModelAlertUserModel UserModel)
EmailClassN)datetimedate)castDatec > e Zd Zd Zd
dZd Zd Zd Zd Zd Z d Z
y)
AlertClassc || _ y )N)db)selfr s K/var/www/intrajisbackend.com/public_html/app/backend/classes/alert_class.py__init__zAlertClass.__init__ s Nc l |dk7 r<| j j t j t j t
j j t
t
j t j k( j t j |k( j t j dk( j t j }|j }||z dz
|z }|dk s||kD ry|j |dz
|z j | j! }|sy|||||dS | j j t j t j j! }|S # t" $ r}t% | } d| cY d }~S d }~ww xY w)Nr zInvalid page number
No data found) total_items total_pages current_pageitems_per_pagedataError: )r queryr id
added_dater
alert_type outerjoin
alert_type_idfilterrut status_idorder_bycountoffsetlimitall Exceptionstr)
r r$ pager
data_queryr r r e
error_messages
r get_allzAlertClass.get_all sf " -qy !WW]]:==*:O:OQ_QjQj k Inn.?.?:C[C[.[\F:>>S01F://145 HZ^^, ) . . 0 *^ ;a ?N R !8tk 10!(($(n)DEKKN[__a* $/#.$(&4 "WW]]: 6 ? ?
O S S U
!! - FM ]O, , -s1 DF 6F <F A F F3F.(F3.F3c > | j j t j t t | |k( j }|r'|j
}t j | }|S y# t $ r}t | }d| cY d }~S d }~ww xY w)Nz3No se encontraron datos para el campo especificado.r ) r r r r# getattrfirstas_dictjsondumpsr+ r, )r fieldvaluer
alert_dataserialized_datar/ r0 s r getzAlertClass.get0 s -77==,33GJ4NRW4WX^^`D !\\^
"&**Z"8&& M - FM ]O, , -s A5A9 9 B BB B c t }d|_ d|_ t j |_ | j j | | j j y# t $ r}t | }d| cY d }~S d }~ww xY w)Nr r ) r r% r" r nowr r addcommitr+ r, )r alertr/ r0 s r storezAlertClass.storeA sr #<<> E - GGNN - FM ]O, , -s A) ) B 2BB B c \ | j j t j t j |k( j }|r6| j j
| | j j yy# t $ r}t | }d| cY d }~S d }~ww xY w)Nr r r )
r r r r# r r4 deleter@ r+ r, )r r r r/ r0 s r rD zAlertClass.deleteQ s
-77==,33JMMR4GHNNPDt$ & - FM ]O, , -s BB B+B& B+&B+c b | j j t j t j |k( j }|r|D ] }| j j t j t j |j k( j }d|v r|d
|d |_ t j |_ | j j t | S y# t $ r$}| j j Y d }~yd }~ww xY w)Nr% r )r r r r# r$ r* r r4 r% r r> updated_dater@ lenr+ rollback)r r alert_inputsalertsrA alert_detailr/ s r updatezAlertClass.update^ s ''--
+22:>>R3GHLLN
; $
j 9 @ @ RWRZRZAZ [ a a c ,.< 3L3X-9+-FL*,4LLN )
;
6{"
"
s $D D.
D))D.c ~ t j }| j j t j t j |k( t j |k( t t j t |k( j }|ryy# t $ r}t | }d| cY d }~S d }~ww xY w)Nr r r )r todayr r r r#
alert_user_idr" r
r r r4 r+ r, )r rO r" rN r r/ r0 s r validate_existence_alertz#AlertClass.validate_existence_alerts s -JJLE77==,33((M9((M9Z**D1U: eg
- FM ]O, , -s BB B<"B71B<7B<c d}|dz
}|d| dz
}|dz
}t dd }| j j t j t j
|k( j
}|D ]* }| j |j | }|dk( s&| j j t j t j |j k( j } t } |j | _
|| _ d | _ t j | _ t j | _ | j j' | | j j) |j+ |j, d
| - y # t. $ r3}
| j j1 t3 d |
Y d }
~
fd }
~
ww xY w) NzInforme de CAF
zz- El segmento zW NO tiene folios disponibles. Por favor cargar nuevos en Simple Factura.
z
zinformacion@jisparking.comzpksh nfit pcwj dfter r zInforme de CAFzError al guardar o enviar: )r r r r r# r" r* rP user_idr r r4 r rO r% r rN r rF r? r@
send_emailemailr+ rH print) r r" folio_segment_id
email_content email_client alert_users
alert_userresponseuserrA r/ s r rS zAlertClass.send_email s 1
34D3E F] ^ ^
"">@UV ggmmN3::>;W;W[h;himmo % =J44Z5G5G WH1}ww}}Y/66y||zGYGY7YZ``b= &LE*.''E'*7E'&'EO'+zz|E$)- E&GGKK&GGNN$ !++DJJ8H-X% =( ! =GG$$& 7s;<<=s /B-F G )(GG )Nr
) __name__
__module__ __qualname__r r1 r< rB rD rL rP rS r r r
r
s+ #-J-"- -*-&"=r r
)app.backend.db.modelsr r r r app.backend.classes.email_classr r6 r r
sqlalchemyr
r r
ra r r re s# W W 6 # !a= a=r