a
    øûGc6  ã                   @   sÄ   d dl mZ d dlmZ d dlmZ ddlmZ ddlmZ	 ddl
mZ ddlmZ d d	lmZ dd
lT dd
lT d dlmZ d dlZdZG dd„ deƒZdd„ Zdd„ Zdd„ Zdd„ Zdd„ ZdS )é    )Úrender)ÚTemplateView)Údatetimeé   )Ú
TarifaHora)Úturismo)Útransporteaereo)Úseguridadsocial)ÚListView)Ú*)Úmodelformset_factoryNz /var/www/html/lartica/db.sqlite3c                   @   s   e Zd ZdZdS )ÚHomeViewzdatascience/home.htmlN)Ú__name__Ú
__module__Ú__qualname__Útemplate_name© r   r   ú*/var/www/html/lartica/datascience/views.pyr      s   r   c                 C   s(   i }|j dd� |j dd� t| d|ƒS )NZLartica)ÚtitlezData Science)Ú
site_titlezdatascience/index.html)Úupdater   )ÚrequestÚcontextr   r   r   Úindex   s    r   c           
      C   sœ   i }t  ¡ }t|ƒd }t|ƒd }t|ƒd }t|ƒd }t|ƒd }t|ƒd }t|ƒd }	||B }||B }||B }||B }t| d|||||||	d	œƒS )
u'    Tarifas electricas del dÃ­a por horas r   r   é   é   é   é   é   z"datascience/tarifaselectricas.html)r   ÚlabelsÚdataÚahoraÚmaximoÚminimoÚmedia)r   Únowr   r   )
r   r   r%   Útarifasr"   r#   r!   r   r    r$   r   r   r   Útarifaselectricas%   s,    ùr'   c                 C   sú   d}i }t ƒ }| j d¡}t|ƒ zt |¡}|d }|d }W n   d}d}Y n0 tjt|d|d�}tj	t||d	�}	tj
t||d	�}
||||d |d
 |d |d |	d |	d |	d |
d |
d |
d
 |
d |
d |
d |
d |	d dœ}t| d|ƒS )NTÚ	categoriar   r   ZEOT1zNacional. Viajerosé   )ÚbdÚcodigoÚ	n_ultimosÚlg)r*   r+   r-   r   r   r   r   é   r   é   ©Úformr+   Úcategoria_nombreÚxÚyÚy_12Úy_var12Úx_trendÚy_trendÚ
y_trend_rcÚxy_forecastÚx_regresionÚy_regresionÚy_regresion_12Úy_regresion_var12Úci_lowerÚci_upperÚR2zdatascience/turismo.html)ZSelectCategoriaFormÚGETÚgetÚprintÚastÚliteral_evalÚturZ
bd_turismoÚ	BASEDATOSZbd_turismopredictZbd_turismoforecastr   ©r   Úlgdr   r1   ÚitemÚ	itemarrayr+   r2   r    ÚpredictÚforecastr   r   r   r   @   sF    

ìr   c                 C   s   d}i }t ƒ }| j d¡}t|ƒ zt |¡}|d }|d }W n   d}d}Y n0 tjtd|d|d�}tjtd|d	|d�}	tj	td
||d�}
tj
td||d�}||||d |d |d |d |	d |	d |	d |
d |
d |
d |
d |
d |
d |
d |	d |d |d dœ}t| d|ƒS )NTr(   r   r   zPasajeros -- TotalÚTaereoPredictr)   ©r,   r-   r   ÚTaereoForecast©r-   ÚTaereoAnualr   r   r   r   r.   r   r/   )r1   r+   r2   r3   r4   r5   r6   r7   r8   r9   r:   r;   r<   r=   r>   r?   r@   rA   Zx_anualZy_anualz datascience/transporteaereo.html)ZSelectCategoriataereoFormrB   rC   rD   rE   rF   ÚtaZbd_taereopredictrH   Zbd_taereoforecastZbd_taereoanualr   )r   rJ   r   r1   rK   rL   r+   r2   r    rM   rN   Zta_anualr   r   r   r   p   sL    

êr   c                 C   s  d}i }t ƒ }| j d¡}t|ƒ zt |¡}|d }|d }W n   d}d}Y n0 tjtd|d|d�}tjtd|d	|d�}	tj	td
||d�}
||||d |d |d |d |	d |	d |	d |
d |
d |
d |
d |
d |
d |
d |	d dœ}t
| d|ƒS )z#Seguridad social ocupados y paradosTr(   r   r   zOcupados -- TotalÚ	SSPredicté   rP   r   Ú
SSForecastrR   r   r   r   r   r.   r   r/   r0   z"datascience/seguridadsocialop.html)ZSelectCategoriassFormrB   rC   rD   rE   rF   ÚssZbd_sspredictrH   Zbd_ssforecastr   rI   r   r   r   Úseguridadsocialop¤   sF    

ìrY   )Údjango.shortcutsr   Zdjango.views.genericr   r   Z)utils.tarifaselectricas.tarifaselectricasr   Zutils.turismor   rG   Zutils.transporteaereor   rT   Zutils.seguridadsocialr	   rX   r
   ÚmodelsÚformsZdjango.formsr   rE   rH   r   r   r'   rY   r   r   r   r   Ú<module>   s$   04