o gi@sddlmZddlmZmZddlZddlmZmZmZm Z m Z m Z m Z m Z mZmZmZddlmZddlmZdd d ZGd d d eZGd ddeZGdddeZGdddeZGdddeZGdddeZGdddeZGdddeZdS)) annotations)datetimedateN) ColumnStringDateDateTimeTextBooleanFloat ForeignKeyIntegerUniqueConstraintIndex) relationship)BasereturnstrcCs ttS)N)ruuiduuid4rr8/var/www/html/flask_server/apps/leave_form_app/models.py_uuids rc@seZdZdZdZeedddZeedddZeed ddZ ee ddd Z eedddZ ee dejejd Zed d deddeddfZdS)RolePositionMapu\ 8.1 role_position_map Mapea un position de AroFlo a un role lógico de la app. role_position_map@T primary_keyFnullable r defaultr r#onupdate positionname!uq_role_position_map_positionname)nameix_role_position_map_roleroleix_role_position_map_is_enabled is_enabledN)__name__ __module__ __qualname____doc__ __tablename__rr positionidr&r*r r,updated_by_useridrrutcnow updated_atrr__table_args__rrrrrs rc@sjeZdZdZdZeedddZeedddZee ddd Z ee ddd Z ee ddd Z e d d fZd S) AppAdminz] 8.2 app_admins Lista de usuarios con permisos administrativos dentro de la app. app_adminsrTrrFrr"ix_app_admins_emailemailN)r-r.r/r0r1rruseridr:r can_map_rolescan_upload_to_aroflois_super_adminrr6rrrrr75sr7c@seZdZdZdZeeddedZeedddZ eed ddZ eed ddZ eed ddZ eed ddZ eed ddZeeddZeed ddZeeddZeeddZeeddZeeddZeedddZeeddZeeddZeed ddZeed ddZeed dd d Zeed ddd ZeeddZ eed ddd Z!eede"j#d Z$eede"j#e"j#dZ%e&ddddZ'e&ddddZ(e)dde)dde)dde)dde)ddfZ*dS) LeaveRequestuC 8.3 leave_requests Request principal (días u horas). leave_requests$Trr#rFrrr!NTr"pendingr$LeaveAttachmentleavezall, delete-orphan)back_populatescascadeLeaveUploadJob!ix_leave_requests_employee_useridemployee_userid ix_leave_requests_manager_useridmanager_useridix_leave_requests_orgnameemployee_orgnameix_leave_requests_decisionmanager_decisionix_leave_requests_created_at created_atN)+r-r.r/r0r1rrr request_idrLemployee_email employee_namerPemployee_positionnametype_overhead_namer reasonmoder hours_dater hours_amount start_dateend_daterNcommentscontact_detailsbu_name tracking_nameworktyperRrmanager_decision_atstatusrr4rTr5r attachments upload_jobsrr6rrrrr?HsV        r?c@seZdZdZdZeeddedZeede dddZ eed ddZ eed ddZ eed ddZ eeddZeed ddZeedejd Zed ddZeddfZdS)rFzB 8.4 leave_attachments Adjuntos ligados a un request. leave_attachmentsrATrBleave_requests.request_idFrrir"r?rgrHix_leave_attachments_request_idrUN)r-r.r/r0r1rrr attachment_idr rUfilenamemime storage_pathr commentfilterrrr4rTrrGrr6rrrrrFs  rFc@seZdZdZdZeeddedZeede dddZ eed ddZ eed ddZ ee ddZee ddZee ddZee ddZeedejd Zed d dZeddeddeddfZdS)rJuc 8.5 leave_upload_jobs Auditoría de ejecuciones UI automation (create y upload docs). leave_upload_jobsrATrBrjFrrrCr"r?rhrlix_leave_upload_jobs_request_idrU"ix_leave_upload_jobs_run_by_userid run_by_useridix_leave_upload_jobs_created_atrTN)r-r.r/r0r1rrrjob_idr rUrwrfr ui_create_cmd_snapshotui_create_stdoutui_upload_docs_cmd_snapshotui_upload_docs_stdoutrrr4rTrrGrr6rrrrrJs"     rJc@sHeZdZdZdZeedddZeedddZe dde dd fZ d S) BuTrackingMapu] 8.6 bu_tracking_map Solo si la relación BU <-> Tracking no la traes de AroFlo. bu_tracking_maprTrix_bu_tracking_map_burbix_bu_tracking_map_trackingrcN) r-r.r/r0r1rrrbrcrr6rrrrr~sr~c@sHeZdZdZdZeedddZeedddZ ee de d d d dZ d S) LeaveOrgDefaultuj 8.7 leave_org_defaults Defaults por organización (para no mantener settings user por user). leave_org_defaultsrTrFgffffff@r"iN) r-r.r/r0r1rrorgnamer default_daily_hoursrrdefault_leave_start_daterrrrrs rc@sPeZdZdZdZeedddZeeddZ ee ddZ ee de je jdZd S) LeaveUserSettingzF 8.8 leave_user_settings Override por usuario (opcional). leave_user_settingsrTrrFr$N)r-r.r/r0r1rrr;r daily_hoursrleave_start_daterrr4r5rrrrrs  r)rr) __future__rrrr sqlalchemyrrrrr r r r r rrsqlalchemy.ormr config.dbrrrr7r?rFrJr~rrrrrrs 4  G